eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GET_COMM_PMT_PAID_GRP dependencies on FND_API

Line 91: -- If the p_proration_flag : FND_API.G_TRUE ('T')

87: -- is for compensation earned.
88: -- For example, p_start_date : 15-Jan-04
89: -- p_end_date : 15-Feb-04
90: -- i)In Jan, comp is $1000 and in Feb, comp is $2000.
91: -- If the p_proration_flag : FND_API.G_TRUE ('T')
92: -- Then we need to sum up all amount for the Jan and Feb and then prorate for
93: -- 15-Jan-04 to 15-Feb-04 to (1000+2000)* (17+15)/(31+15)and return new date ranges as:
94: -- x_new_start_date : 01-Jan-04
95: -- x_new_end_date : 28-Feb-04

Line 96: -- ii)If the p_proration_flag : FND_API.G_FALSE ('F')

92: -- Then we need to sum up all amount for the Jan and Feb and then prorate for
93: -- 15-Jan-04 to 15-Feb-04 to (1000+2000)* (17+15)/(31+15)and return new date ranges as:
94: -- x_new_start_date : 01-Jan-04
95: -- x_new_end_date : 28-Feb-04
96: -- ii)If the p_proration_flag : FND_API.G_FALSE ('F')
97: -- Then we need to sum up all amount for the Jan and Feb (1000+ 2000) and return new date ranges as:
98: -- x_new_start_date : 01-Jan-04
99: -- x_new_end_date : 28-Feb-04
100: -- Both x_new_start_date and x_new_end_date will not be NULL if they are the same across the orgs.

Line 106: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

102: -- ===========================================================================
103: PROCEDURE get_comm_and_paid_pmt
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
107: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
108: p_person_id IN NUMBER,
109: p_start_date IN DATE,
110: p_end_date IN DATE,

Line 107: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

103: PROCEDURE get_comm_and_paid_pmt
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
107: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
108: p_person_id IN NUMBER,
109: p_start_date IN DATE,
110: p_end_date IN DATE,
111: p_target_currency_code IN VARCHAR2,

Line 193: IF NOT FND_API.Compatible_API_Call ( g_api_version ,

189: l_validation_level NUMBER;
190:
191: BEGIN
192: -- Standard call to check for call compatibility.
193: IF NOT FND_API.Compatible_API_Call ( g_api_version ,
194: p_api_version ,
195: l_api_name ,
196: G_PKG_NAME )
197: THEN

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: p_api_version ,
195: l_api_name ,
196: G_PKG_NAME )
197: THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: -- Initialize API return status to success
202: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: -- Initialize API return status to success
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: --Defaults:
205: l_init_msg_list := NVL(p_init_msg_list, FND_API.G_FALSE);
206: l_validation_level := NVL(p_validation_level, FND_API.G_VALID_LEVEL_FULL);

Line 205: l_init_msg_list := NVL(p_init_msg_list, FND_API.G_FALSE);

201: -- Initialize API return status to success
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: --Defaults:
205: l_init_msg_list := NVL(p_init_msg_list, FND_API.G_FALSE);
206: l_validation_level := NVL(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
207: l_proration_flag := NVL(p_proration_flag, FND_API.G_FALSE);
208:
209: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 206: l_validation_level := NVL(p_validation_level, FND_API.G_VALID_LEVEL_FULL);

202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: --Defaults:
205: l_init_msg_list := NVL(p_init_msg_list, FND_API.G_FALSE);
206: l_validation_level := NVL(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
207: l_proration_flag := NVL(p_proration_flag, FND_API.G_FALSE);
208:
209: -- Initialize message list if p_init_msg_list is set to TRUE.
210: IF FND_API.to_Boolean( l_init_msg_list )

Line 207: l_proration_flag := NVL(p_proration_flag, FND_API.G_FALSE);

203:
204: --Defaults:
205: l_init_msg_list := NVL(p_init_msg_list, FND_API.G_FALSE);
206: l_validation_level := NVL(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
207: l_proration_flag := NVL(p_proration_flag, FND_API.G_FALSE);
208:
209: -- Initialize message list if p_init_msg_list is set to TRUE.
210: IF FND_API.to_Boolean( l_init_msg_list )
211: THEN

Line 210: IF FND_API.to_Boolean( l_init_msg_list )

206: l_validation_level := NVL(p_validation_level, FND_API.G_VALID_LEVEL_FULL);
207: l_proration_flag := NVL(p_proration_flag, FND_API.G_FALSE);
208:
209: -- Initialize message list if p_init_msg_list is set to TRUE.
210: IF FND_API.to_Boolean( l_init_msg_list )
211: THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214:

Line 263: RAISE FND_API.G_EXC_ERROR;

259: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_from_currency );
260: FND_MESSAGE.SET_TOKEN('TO_CURR',p_target_currency_code );
261: FND_MSG_PUB.ADD;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: ELSIF (l_from_currency = p_target_currency_code)
266: THEN
267: l_rate := 1;

Line 300: IF l_proration_flag = FND_API.G_TRUE

296:
297: --
298: --Do proration.
299: --
300: IF l_proration_flag = FND_API.G_TRUE
301: THEN
302: l_factor := l_prorated_days / l_total_days;
303: ELSIF l_proration_flag = FND_API.G_FALSE
304: THEN

Line 303: ELSIF l_proration_flag = FND_API.G_FALSE

299: --
300: IF l_proration_flag = FND_API.G_TRUE
301: THEN
302: l_factor := l_prorated_days / l_total_days;
303: ELSIF l_proration_flag = FND_API.G_FALSE
304: THEN
305: l_factor := 1;
306: END IF;
307: debug_msg('l_factor = ' || to_char(l_factor) );

Line 350: RAISE FND_API.G_EXC_ERROR;

346: FND_MESSAGE.SET_TOKEN('PERSON_ID',to_char(p_person_id) );
347: FND_MSG_PUB.ADD;
348: END IF;
349:
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: --
354: --Get the compensation earned and paid.

Line 381: p_encoded => FND_API.G_FALSE

377: FND_MSG_PUB.Count_And_Get
378: (
379: p_count => x_msg_count ,
380: p_data => x_msg_data ,
381: p_encoded => FND_API.G_FALSE
382: );
383:
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN

Line 385: WHEN FND_API.G_EXC_ERROR THEN

381: p_encoded => FND_API.G_FALSE
382: );
383:
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387: FND_MSG_PUB.Count_And_Get
388: (
389: p_count => x_msg_count ,

Line 386: x_return_status := FND_API.G_RET_STS_ERROR ;

382: );
383:
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387: FND_MSG_PUB.Count_And_Get
388: (
389: p_count => x_msg_count ,
390: p_data => x_msg_data ,

Line 391: p_encoded => FND_API.G_FALSE

387: FND_MSG_PUB.Count_And_Get
388: (
389: p_count => x_msg_count ,
390: p_data => x_msg_data ,
391: p_encoded => FND_API.G_FALSE
392: );
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395: FND_MSG_PUB.Count_And_Get

Line 393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

389: p_count => x_msg_count ,
390: p_data => x_msg_data ,
391: p_encoded => FND_API.G_FALSE
392: );
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395: FND_MSG_PUB.Count_And_Get
396: (
397: p_count => x_msg_count ,

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

390: p_data => x_msg_data ,
391: p_encoded => FND_API.G_FALSE
392: );
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395: FND_MSG_PUB.Count_And_Get
396: (
397: p_count => x_msg_count ,
398: p_data => x_msg_data ,

Line 399: p_encoded => FND_API.G_FALSE

395: FND_MSG_PUB.Count_And_Get
396: (
397: p_count => x_msg_count ,
398: p_data => x_msg_data ,
399: p_encoded => FND_API.G_FALSE
400: );
401: WHEN OTHERS THEN
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

398: p_data => x_msg_data ,
399: p_encoded => FND_API.G_FALSE
400: );
401: WHEN OTHERS THEN
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
404: THEN
405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
406: END IF;

Line 411: p_encoded => FND_API.G_FALSE

407: FND_MSG_PUB.Count_And_Get
408: (
409: p_count => x_msg_count ,
410: p_data => x_msg_data ,
411: p_encoded => FND_API.G_FALSE
412: );
413: END get_comm_and_paid_pmt;
414:
415: