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_API dependencies on FND_API

Line 19: p_encoded => FND_API.G_FALSE

15: FND_MSG_PUB.Count_And_Get
16: (
17: p_count => l_msg_count ,
18: p_data => l_msg_data ,
19: p_encoded => FND_API.G_FALSE
20: );
21: ELSE
22: l_msg_count := p_msg_count;
23: l_msg_data := p_msg_data;

Line 34: (p_msg_index => ctr, p_encoded => FND_API.G_FALSE)),

30: ELSE
31: FOR ctr IN 1..l_msg_count LOOP
32: cn_message_pkg.debug
33: (substrb((FND_MSG_PUB.get
34: (p_msg_index => ctr, p_encoded => FND_API.G_FALSE)),
35: 1,
36: 240)
37: );
38: END LOOP ;

Line 217: l_return_code := FND_API.G_FALSE;

213:
214: l_return_code VARCHAR2(1);
215:
216: BEGIN
217: l_return_code := FND_API.G_FALSE;
218: x_loading_status := p_loading_status;
219: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
220: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
221: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

Line 219: IF (p_char_para = FND_API.G_MISS_CHAR) THEN

215:
216: BEGIN
217: l_return_code := FND_API.G_FALSE;
218: x_loading_status := p_loading_status;
219: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
220: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
221: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
222: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
223: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 236: l_return_code := FND_API.G_TRUE;

232: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
233: FND_MSG_PUB.Add;
234: END IF;
235: x_loading_status := 'CN_MISS_PARAMETER';
236: l_return_code := FND_API.G_TRUE;
237: END IF;
238:
239: RETURN l_return_code;
240:

Line 255: l_return_code := FND_API.G_FALSE;

251: x_loading_status OUT NOCOPY VARCHAR2 )
252: RETURN VARCHAR2 IS
253: l_return_code VARCHAR2(1);
254: BEGIN
255: l_return_code := FND_API.G_FALSE;
256: x_loading_status := p_loading_status;
257: IF (p_num_para = FND_API.G_MISS_NUM) THEN
258: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
259: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

Line 257: IF (p_num_para = FND_API.G_MISS_NUM) THEN

253: l_return_code VARCHAR2(1);
254: BEGIN
255: l_return_code := FND_API.G_FALSE;
256: x_loading_status := p_loading_status;
257: IF (p_num_para = FND_API.G_MISS_NUM) THEN
258: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
259: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
260: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 274: l_return_code := FND_API.G_TRUE;

270: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
271: FND_MSG_PUB.Add;
272: END IF;
273: x_loading_status := 'CN_MISS_PARAMETER';
274: l_return_code := FND_API.G_TRUE;
275: END IF;
276: RETURN l_return_code;
277: END chk_miss_num_para;
278:

Line 293: l_return_code := FND_API.G_FALSE;

289:
290: l_return_code VARCHAR2(1);
291:
292: BEGIN
293: l_return_code := FND_API.G_FALSE;
294: x_loading_status := p_loading_status;
295: IF (p_date_para = FND_API.G_MISS_DATE) THEN
296: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
297: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

Line 295: IF (p_date_para = FND_API.G_MISS_DATE) THEN

291:
292: BEGIN
293: l_return_code := FND_API.G_FALSE;
294: x_loading_status := p_loading_status;
295: IF (p_date_para = FND_API.G_MISS_DATE) THEN
296: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
297: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
298: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
299: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 312: l_return_code := FND_API.G_TRUE;

308: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
309: FND_MSG_PUB.Add;
310: END IF;
311: x_loading_status := 'CN_MISS_PARAMETER';
312: l_return_code := FND_API.G_TRUE;
313: END IF;
314:
315: RETURN l_return_code;
316:

Line 331: l_return_code := FND_API.G_FALSE;

327: x_loading_status OUT NOCOPY VARCHAR2 )
328: RETURN VARCHAR2 IS
329: l_return_code VARCHAR2(1);
330: BEGIN
331: l_return_code := FND_API.G_FALSE;
332: x_loading_status := p_loading_status;
333: IF (p_num_para IS NULL ) THEN
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
335: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 350: l_return_code := FND_API.G_TRUE;

346: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
347: FND_MSG_PUB.Add;
348: END IF;
349: x_loading_status := 'CN_CANNOT_NULL';
350: l_return_code := FND_API.G_TRUE;
351: END IF;
352: RETURN l_return_code;
353: END chk_null_num_para;
354:

Line 367: l_return_code := FND_API.G_FALSE;

363: x_loading_status OUT NOCOPY VARCHAR2 )
364: RETURN VARCHAR2 IS
365: l_return_code VARCHAR2(1);
366: BEGIN
367: l_return_code := FND_API.G_FALSE;
368: x_loading_status := p_loading_status;
369: IF (p_char_para IS NULL ) THEN
370: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
371: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 386: l_return_code := FND_API.G_TRUE;

382: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
383: FND_MSG_PUB.Add;
384: END IF;
385: x_loading_status := 'CN_CANNOT_NULL';
386: l_return_code := FND_API.G_TRUE;
387: END IF;
388: RETURN l_return_code;
389: END chk_null_char_para;
390:

Line 403: l_return_code := FND_API.G_FALSE;

399: x_loading_status OUT NOCOPY VARCHAR2 )
400: RETURN VARCHAR2 IS
401: l_return_code VARCHAR2(1);
402: BEGIN
403: l_return_code := FND_API.G_FALSE;
404: x_loading_status := p_loading_status;
405: IF (p_date_para IS NULL ) THEN
406: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
407: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 422: l_return_code := FND_API.G_TRUE;

418: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
419: FND_MSG_PUB.Add;
420: END IF;
421: x_loading_status := 'CN_CANNOT_NULL';
422: l_return_code := FND_API.G_TRUE;
423: END IF;
424: RETURN l_return_code;
425: END chk_null_date_para;
426:

Line 439: l_return_code := FND_API.G_FALSE;

435: x_loading_status OUT NOCOPY VARCHAR2 )
436: RETURN VARCHAR2 IS
437: l_return_code VARCHAR2(1);
438: BEGIN
439: l_return_code := FND_API.G_FALSE;
440: x_loading_status := p_loading_status;
441: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
442: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
443: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 441: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN

437: l_return_code VARCHAR2(1);
438: BEGIN
439: l_return_code := FND_API.G_FALSE;
440: x_loading_status := p_loading_status;
441: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
442: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
443: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
444: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
445: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 458: l_return_code := FND_API.G_TRUE;

454: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
455: FND_MSG_PUB.Add;
456: END IF;
457: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
458: l_return_code := FND_API.G_TRUE;
459: END IF;
460: RETURN l_return_code;
461: END chk_miss_null_num_para;
462:

Line 475: l_return_code := FND_API.G_FALSE;

471: x_loading_status OUT NOCOPY VARCHAR2 )
472: RETURN VARCHAR2 IS
473: l_return_code VARCHAR2(1);
474: BEGIN
475: l_return_code := FND_API.G_FALSE;
476: x_loading_status := p_loading_status;
477: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
478: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
479: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 477: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN

473: l_return_code VARCHAR2(1);
474: BEGIN
475: l_return_code := FND_API.G_FALSE;
476: x_loading_status := p_loading_status;
477: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
478: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
479: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
480: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
481: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 494: l_return_code := FND_API.G_TRUE;

490: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
491: FND_MSG_PUB.Add;
492: END IF;
493: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
494: l_return_code := FND_API.G_TRUE;
495: END IF;
496: RETURN l_return_code;
497: END chk_miss_null_char_para;
498:

Line 511: l_return_code := FND_API.G_FALSE;

507: x_loading_status OUT NOCOPY VARCHAR2 )
508: RETURN VARCHAR2 IS
509: l_return_code VARCHAR2(1);
510: BEGIN
511: l_return_code := FND_API.G_FALSE;
512: x_loading_status := p_loading_status;
513: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
514: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
515: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 513: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN

509: l_return_code VARCHAR2(1);
510: BEGIN
511: l_return_code := FND_API.G_FALSE;
512: x_loading_status := p_loading_status;
513: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
514: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
515: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
516: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
517: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 531: l_return_code := FND_API.G_TRUE;

527: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
528: FND_MSG_PUB.Add;
529: END IF;
530: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
531: l_return_code := FND_API.G_TRUE;
532: END IF;
533: RETURN l_return_code;
534: END chk_miss_null_date_para;
535:

Line 552: l_return_code := FND_API.G_TRUE;

548: x_loading_status OUT NOCOPY VARCHAR2 )
549: RETURN VARCHAR2 IS
550: l_return_code VARCHAR2(1);
551: BEGIN
552: l_return_code := FND_API.G_TRUE;
553: x_loading_status := p_loading_status;
554: IF (p_num_field IS NOT NULL ) THEN
555: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
556: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 582: l_return_code := FND_API.G_FALSE;

578: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
579: FND_MSG_PUB.Add;
580: END IF;
581: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
582: l_return_code := FND_API.G_FALSE;
583: END IF;
584: RETURN l_return_code;
585: END pe_num_field_must_null;
586:

Line 603: l_return_code := FND_API.G_TRUE;

599: x_loading_status OUT NOCOPY VARCHAR2 )
600: RETURN VARCHAR2 IS
601: l_return_code VARCHAR2(1);
602: BEGIN
603: l_return_code := FND_API.G_TRUE;
604: x_loading_status := p_loading_status;
605: IF (p_char_field IS NOT NULL ) THEN
606: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
607: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 634: l_return_code := FND_API.G_FALSE;

630: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
631: FND_MSG_PUB.Add;
632: END IF;
633: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
634: l_return_code := FND_API.G_FALSE;
635: END IF;
636: RETURN l_return_code;
637: END pe_char_field_must_null;
638:

Line 655: l_return_code := FND_API.G_TRUE;

651: x_loading_status OUT NOCOPY VARCHAR2 )
652: RETURN VARCHAR2 IS
653: l_return_code VARCHAR2(1);
654: BEGIN
655: l_return_code := FND_API.G_TRUE;
656: x_loading_status := p_loading_status;
657: IF (p_num_field IS NULL ) THEN
658: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
659: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 686: l_return_code := FND_API.G_FALSE;

682: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
683: FND_MSG_PUB.Add;
684: END IF;
685: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
686: l_return_code := FND_API.G_FALSE;
687: END IF;
688: RETURN l_return_code;
689: END pe_num_field_cannot_null;
690:

Line 707: l_return_code := FND_API.G_TRUE;

703: x_loading_status OUT NOCOPY VARCHAR2 )
704: RETURN VARCHAR2 IS
705: l_return_code VARCHAR2(1);
706: BEGIN
707: l_return_code := FND_API.G_TRUE;
708: x_loading_status := p_loading_status;
709: IF (p_char_field IS NULL ) THEN
710: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
711: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 738: l_return_code := FND_API.G_FALSE;

734: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
735: FND_MSG_PUB.Add;
736: END IF;
737: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
738: l_return_code := FND_API.G_FALSE;
739: END IF;
740: RETURN l_return_code;
741: END pe_char_field_cannot_null;
742: --| ---------------------------------------------------------------------+

Line 898: x_return_status := FND_API.G_RET_STS_SUCCESS;

894: AND org_id = p_org_id
895: AND type = p_type;
896: -- END IF;
897: x_salesrep_id := l_salesrep_id;
898: x_return_status := FND_API.G_RET_STS_SUCCESS;
899: x_loading_status := 'CN_SALESREP_FOUND';
900:
901: EXCEPTION
902: WHEN no_data_found THEN

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900:
901: EXCEPTION
902: WHEN no_data_found THEN
903: x_salesrep_id := NULL;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: x_loading_status := 'CN_SALESREP_NOT_FOUND';
906: IF (p_show_message = FND_API.G_TRUE) THEN
907: -- Error, check the msg level and add an error message to the
908: -- API message list

Line 906: IF (p_show_message = FND_API.G_TRUE) THEN

902: WHEN no_data_found THEN
903: x_salesrep_id := NULL;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: x_loading_status := 'CN_SALESREP_NOT_FOUND';
906: IF (p_show_message = FND_API.G_TRUE) THEN
907: -- Error, check the msg level and add an error message to the
908: -- API message list
909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
910: THEN

Line 917: x_return_status := FND_API.G_RET_STS_ERROR;

913: END IF;
914: END IF;
915: WHEN too_many_rows THEN
916: x_salesrep_id := NULL;
917: x_return_status := FND_API.G_RET_STS_ERROR;
918: x_loading_status := 'CN_SALESREP_TOO_MANY_ROWS';
919: IF (p_show_message = FND_API.G_TRUE) THEN
920: -- Error, check the msg level and add an error message to the
921: -- API message list

Line 919: IF (p_show_message = FND_API.G_TRUE) THEN

915: WHEN too_many_rows THEN
916: x_salesrep_id := NULL;
917: x_return_status := FND_API.G_RET_STS_ERROR;
918: x_loading_status := 'CN_SALESREP_TOO_MANY_ROWS';
919: IF (p_show_message = FND_API.G_TRUE) THEN
920: -- Error, check the msg level and add an error message to the
921: -- API message list
922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN

Line 1154: l_return_code := FND_API.G_FALSE;

1150:
1151: l_return_code VARCHAR2(1);
1152:
1153: BEGIN
1154: l_return_code := FND_API.G_FALSE;
1155: x_loading_status := p_loading_status;
1156: IF p_start_date IS NULL THEN
1157: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1158: l_return_code := FND_API.G_TRUE;

Line 1158: l_return_code := FND_API.G_TRUE;

1154: l_return_code := FND_API.G_FALSE;
1155: x_loading_status := p_loading_status;
1156: IF p_start_date IS NULL THEN
1157: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1158: l_return_code := FND_API.G_TRUE;
1159: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1160: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1161: l_return_code := FND_API.G_TRUE;
1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN

Line 1159: ELSIF p_start_date = FND_API.G_MISS_DATE THEN

1155: x_loading_status := p_loading_status;
1156: IF p_start_date IS NULL THEN
1157: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1158: l_return_code := FND_API.G_TRUE;
1159: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1160: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1161: l_return_code := FND_API.G_TRUE;
1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1163: x_loading_status := 'CN_END_DATE_CANNOT_NULL';

Line 1161: l_return_code := FND_API.G_TRUE;

1157: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1158: l_return_code := FND_API.G_TRUE;
1159: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1160: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1161: l_return_code := FND_API.G_TRUE;
1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1163: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1164: l_return_code := FND_API.G_TRUE;
1165: ELSIF p_end_date = FND_API.G_MISS_DATE

Line 1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN

1158: l_return_code := FND_API.G_TRUE;
1159: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1160: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1161: l_return_code := FND_API.G_TRUE;
1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1163: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1164: l_return_code := FND_API.G_TRUE;
1165: ELSIF p_end_date = FND_API.G_MISS_DATE
1166: AND p_end_date_nullable <> FND_API.G_TRUE THEN

Line 1164: l_return_code := FND_API.G_TRUE;

1160: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1161: l_return_code := FND_API.G_TRUE;
1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1163: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1164: l_return_code := FND_API.G_TRUE;
1165: ELSIF p_end_date = FND_API.G_MISS_DATE
1166: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1167: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1168: l_return_code := FND_API.G_TRUE;

Line 1165: ELSIF p_end_date = FND_API.G_MISS_DATE

1161: l_return_code := FND_API.G_TRUE;
1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1163: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1164: l_return_code := FND_API.G_TRUE;
1165: ELSIF p_end_date = FND_API.G_MISS_DATE
1166: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1167: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1168: l_return_code := FND_API.G_TRUE;
1169: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN

Line 1166: AND p_end_date_nullable <> FND_API.G_TRUE THEN

1162: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1163: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1164: l_return_code := FND_API.G_TRUE;
1165: ELSIF p_end_date = FND_API.G_MISS_DATE
1166: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1167: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1168: l_return_code := FND_API.G_TRUE;
1169: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1170: x_loading_status := 'CN_INVALID_DATE_RANGE';

Line 1168: l_return_code := FND_API.G_TRUE;

1164: l_return_code := FND_API.G_TRUE;
1165: ELSIF p_end_date = FND_API.G_MISS_DATE
1166: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1167: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1168: l_return_code := FND_API.G_TRUE;
1169: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1170: x_loading_status := 'CN_INVALID_DATE_RANGE';
1171: l_return_code := FND_API.G_TRUE;
1172: ELSE

Line 1171: l_return_code := FND_API.G_TRUE;

1167: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1168: l_return_code := FND_API.G_TRUE;
1169: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1170: x_loading_status := 'CN_INVALID_DATE_RANGE';
1171: l_return_code := FND_API.G_TRUE;
1172: ELSE
1173: l_return_code := FND_API.G_FALSE;
1174: END IF;
1175: IF (l_return_code = FND_API.g_true AND p_show_message = fnd_api.G_TRUE) THEN

Line 1173: l_return_code := FND_API.G_FALSE;

1169: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1170: x_loading_status := 'CN_INVALID_DATE_RANGE';
1171: l_return_code := FND_API.G_TRUE;
1172: ELSE
1173: l_return_code := FND_API.G_FALSE;
1174: END IF;
1175: IF (l_return_code = FND_API.g_true AND p_show_message = fnd_api.G_TRUE) THEN
1176: -- Error, check the msg level and add an error message to the
1177: -- API message list

Line 1175: IF (l_return_code = FND_API.g_true AND p_show_message = fnd_api.G_TRUE) THEN

1171: l_return_code := FND_API.G_TRUE;
1172: ELSE
1173: l_return_code := FND_API.G_FALSE;
1174: END IF;
1175: IF (l_return_code = FND_API.g_true AND p_show_message = fnd_api.G_TRUE) THEN
1176: -- Error, check the msg level and add an error message to the
1177: -- API message list
1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN

Line 1276: fnd_api.g_false);

1272: p_org_id,
1273: l_salesrep_id,
1274: l_return_status,
1275: l_loading_status,
1276: fnd_api.g_false);
1277:
1278: OPEN l_cur(l_salesrep_id, l_role_id, p_start_date, p_end_date);
1279: FETCH l_cur INTO l_rec;
1280: IF (l_cur%notfound) THEN

Line 1876: x_return_status := FND_API.G_RET_STS_SUCCESS;

1872: l_rc_overlap VARCHAR2(03);
1873: -- l_sum_trx_flag VARCHAR2(03); -- commented for bug 7655423
1874:
1875: BEGIN
1876: x_return_status := FND_API.G_RET_STS_SUCCESS;
1877: x_loading_status := p_loading_status;
1878:
1879: BEGIN
1880: SELECT name, Nvl(p_rc_overlap,allow_rev_class_overlap)--,sum_trx_flag -- commented for bug 7655423

Line 1891: x_return_status := FND_API.G_RET_STS_ERROR;

1887: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_COMP_PLAN');
1888: FND_MSG_PUB.Add;
1889: END IF;
1890: x_loading_status := 'CN_INVALID_COMP_PLAN';
1891: x_return_status := FND_API.G_RET_STS_ERROR;
1892: END ;
1893:
1894: IF l_rc_overlap = 'N' THEN
1895: -- The function below adds the message

Line 1899: x_return_status := FND_API.G_RET_STS_ERROR;

1895: -- The function below adds the message
1896: IF CN_COMP_PLANS_PKG.check_unique_rev_class
1897: (p_comp_plan_id,l_comp_plan_name,l_rc_overlap) = FALSE THEN
1898: x_loading_status := 'PLN_PLAN_DUP_REV_CLASS';
1899: x_return_status := FND_API.G_RET_STS_ERROR;
1900: END IF ;
1901: END IF;
1902:
1903: END check_revenue_class_overlap;

Line 2286: --| Desc : function to return FND_API.g_miss_char

2282:
2283:
2284: --| -----------------------------------------------------------------------=
2285: --| Function Name : g_miss_char
2286: --| Desc : function to return FND_API.g_miss_char
2287: --| ---------------------------------------------------------------------=
2288: FUNCTION g_miss_char RETURN VARCHAR2 IS
2289: BEGIN
2290: RETURN fnd_api.g_miss_char;

Line 2290: RETURN fnd_api.g_miss_char;

2286: --| Desc : function to return FND_API.g_miss_char
2287: --| ---------------------------------------------------------------------=
2288: FUNCTION g_miss_char RETURN VARCHAR2 IS
2289: BEGIN
2290: RETURN fnd_api.g_miss_char;
2291: END g_miss_char;
2292:
2293: --| -----------------------------------------------------------------------=
2294: --| Function Name : g_miss_date

Line 2295: --| Desc : function to return FND_API.g_miss_date

2291: END g_miss_char;
2292:
2293: --| -----------------------------------------------------------------------=
2294: --| Function Name : g_miss_date
2295: --| Desc : function to return FND_API.g_miss_date
2296: --| ---------------------------------------------------------------------=
2297: FUNCTION g_miss_date RETURN DATE IS
2298: BEGIN
2299: RETURN fnd_api.g_miss_date;

Line 2299: RETURN fnd_api.g_miss_date;

2295: --| Desc : function to return FND_API.g_miss_date
2296: --| ---------------------------------------------------------------------=
2297: FUNCTION g_miss_date RETURN DATE IS
2298: BEGIN
2299: RETURN fnd_api.g_miss_date;
2300: END g_miss_date;
2301:
2302: --| -----------------------------------------------------------------------=
2303: --| Function Name : g_miss_num

Line 2304: --| Desc : function to return FND_API.g_miss_num

2300: END g_miss_date;
2301:
2302: --| -----------------------------------------------------------------------=
2303: --| Function Name : g_miss_num
2304: --| Desc : function to return FND_API.g_miss_num
2305: --| ---------------------------------------------------------------------=
2306: FUNCTION g_miss_num RETURN NUMBER IS
2307: BEGIN
2308: RETURN fnd_api.g_miss_num;

Line 2308: RETURN fnd_api.g_miss_num;

2304: --| Desc : function to return FND_API.g_miss_num
2305: --| ---------------------------------------------------------------------=
2306: FUNCTION g_miss_num RETURN NUMBER IS
2307: BEGIN
2308: RETURN fnd_api.g_miss_num;
2309: END g_miss_num;
2310:
2311: --| -----------------------------------------------------------------------=
2312: --| Function Name : g_miss_id

Line 2322: --| Desc : function to return FND_API.g_false

2318: END g_miss_id;
2319:
2320: --| -----------------------------------------------------------------------=
2321: --| Function Name : g_false
2322: --| Desc : function to return FND_API.g_false
2323: --| ---------------------------------------------------------------------=
2324: FUNCTION g_false RETURN VARCHAR2 IS
2325: BEGIN
2326: RETURN fnd_api.g_false;

Line 2326: RETURN fnd_api.g_false;

2322: --| Desc : function to return FND_API.g_false
2323: --| ---------------------------------------------------------------------=
2324: FUNCTION g_false RETURN VARCHAR2 IS
2325: BEGIN
2326: RETURN fnd_api.g_false;
2327: END g_false;
2328:
2329: --| -----------------------------------------------------------------------=
2330: --| Function Name : g_true

Line 2331: --| Desc : function to return FND_API.g_true

2327: END g_false;
2328:
2329: --| -----------------------------------------------------------------------=
2330: --| Function Name : g_true
2331: --| Desc : function to return FND_API.g_true
2332: --| ---------------------------------------------------------------------=
2333: FUNCTION g_true RETURN VARCHAR2 IS
2334: BEGIN
2335: RETURN fnd_api.g_true;

Line 2335: RETURN fnd_api.g_true;

2331: --| Desc : function to return FND_API.g_true
2332: --| ---------------------------------------------------------------------=
2333: FUNCTION g_true RETURN VARCHAR2 IS
2334: BEGIN
2335: RETURN fnd_api.g_true;
2336: END g_true;
2337:
2338: --| -----------------------------------------------------------------------=
2339: --| Function Name : g_valid_level_none

Line 2340: --| Desc : function to return FND_API.G_VALID_LEVEL_NONE

2336: END g_true;
2337:
2338: --| -----------------------------------------------------------------------=
2339: --| Function Name : g_valid_level_none
2340: --| Desc : function to return FND_API.G_VALID_LEVEL_NONE
2341: --| ---------------------------------------------------------------------=
2342: FUNCTION g_valid_level_none RETURN NUMBER IS
2343: BEGIN
2344: RETURN fnd_api.g_valid_level_none;

Line 2344: RETURN fnd_api.g_valid_level_none;

2340: --| Desc : function to return FND_API.G_VALID_LEVEL_NONE
2341: --| ---------------------------------------------------------------------=
2342: FUNCTION g_valid_level_none RETURN NUMBER IS
2343: BEGIN
2344: RETURN fnd_api.g_valid_level_none;
2345: END g_valid_level_none;
2346:
2347: --| -----------------------------------------------------------------------=
2348: --| Function Name : g_valid_level_full

Line 2349: --| Desc : function to return FND_API.G_VALID_LEVEL_FULL

2345: END g_valid_level_none;
2346:
2347: --| -----------------------------------------------------------------------=
2348: --| Function Name : g_valid_level_full
2349: --| Desc : function to return FND_API.G_VALID_LEVEL_FULL
2350: --| ---------------------------------------------------------------------=
2351: FUNCTION g_valid_level_full RETURN NUMBER IS
2352: BEGIN
2353: RETURN fnd_api.g_valid_level_full;

Line 2353: RETURN fnd_api.g_valid_level_full;

2349: --| Desc : function to return FND_API.G_VALID_LEVEL_FULL
2350: --| ---------------------------------------------------------------------=
2351: FUNCTION g_valid_level_full RETURN NUMBER IS
2352: BEGIN
2353: RETURN fnd_api.g_valid_level_full;
2354: END g_valid_level_full;
2355:
2356:
2357:

Line 2708: RETURN fnd_api.g_true;

2704: fnd_message.set_name('CN', 'CN_CANNOT_UPD_PAID_F_PAYRUN');
2705: fnd_msg_pub.add;
2706: END IF;
2707: x_loading_status := 'CN_CANNOT_UPD_PAID_F_PAYRUN';
2708: RETURN fnd_api.g_true;
2709: END IF;
2710:
2711: -- check payrun exists
2712: IF l_payrun_id IS NULL THEN

Line 2719: RETURN fnd_api.g_true;

2715: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
2716: fnd_msg_pub.add;
2717: END IF;
2718: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';
2719: RETURN fnd_api.g_true;
2720: END IF;
2721:
2722: RETURN fnd_api.g_false;
2723:

Line 2722: RETURN fnd_api.g_false;

2718: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';
2719: RETURN fnd_api.g_true;
2720: END IF;
2721:
2722: RETURN fnd_api.g_false;
2723:
2724: END chk_payrun_status_paid;
2725: -- ===========================================================================
2726: -- Procedure : Chk_hold_status

Line 2762: RETURN fnd_api.g_true;

2758: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2759: fnd_msg_pub.add;
2760: END IF;
2761: x_loading_status := 'CN_SRP_ON_HOLD';
2762: RETURN fnd_api.g_true;
2763: END IF;
2764:
2765: IF l_salesrep_id IS NULL THEN
2766: x_loading_status := 'CN_SRP_NOT_EXISTS';

Line 2773: RETURN fnd_api.g_true;

2769: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2770: fnd_msg_pub.add;
2771: END IF;
2772: x_loading_status := 'CN_SRP_NOT_EXISTS';
2773: RETURN fnd_api.g_true;
2774: END IF;
2775:
2776: RETURN fnd_api.g_false;
2777: END chk_hold_status;

Line 2776: RETURN fnd_api.g_false;

2772: x_loading_status := 'CN_SRP_NOT_EXISTS';
2773: RETURN fnd_api.g_true;
2774: END IF;
2775:
2776: RETURN fnd_api.g_false;
2777: END chk_hold_status;
2778:
2779: -- ===========================================================================
2780: -- Procedure : Chk_srp_hold_status

Line 2816: RETURN fnd_api.g_true;

2812: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2813: fnd_msg_pub.add;
2814: END IF;
2815: x_loading_status := 'CN_SRP_ON_HOLD';
2816: RETURN fnd_api.g_true;
2817: END IF;
2818:
2819: IF l_salesrep_id IS NULL THEN
2820: x_loading_status := 'CN_SRP_NOT_EXISTS';

Line 2827: RETURN fnd_api.g_true;

2823: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2824: fnd_msg_pub.add;
2825: END IF;
2826: x_loading_status := 'CN_SRP_NOT_EXISTS';
2827: RETURN fnd_api.g_true;
2828: END IF;
2829:
2830: RETURN fnd_api.g_false;
2831: END chk_srp_hold_status;

Line 2830: RETURN fnd_api.g_false;

2826: x_loading_status := 'CN_SRP_NOT_EXISTS';
2827: RETURN fnd_api.g_true;
2828: END IF;
2829:
2830: RETURN fnd_api.g_false;
2831: END chk_srp_hold_status;
2832: --| ---------------------------------------------------------------------+
2833: -- Function : Get_pay_Element_ID(P_quota_id, p_salesrep_id, p_date)
2834: --| ---------------------------------------------------------------------+

Line 2909: RAISE FND_API.G_EXC_ERROR;

2905: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
2906: fnd_msg_pub.add;
2907: END IF;
2908: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
2909: RAISE FND_API.G_EXC_ERROR;
2910: END IF;
2911: RETURN fnd_api.g_false;
2912:
2913: EXCEPTION

Line 2911: RETURN fnd_api.g_false;

2907: END IF;
2908: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
2909: RAISE FND_API.G_EXC_ERROR;
2910: END IF;
2911: RETURN fnd_api.g_false;
2912:
2913: EXCEPTION
2914: WHEN FND_API.G_EXC_ERROR THEN
2915: RETURN fnd_api.g_true;

Line 2914: WHEN FND_API.G_EXC_ERROR THEN

2910: END IF;
2911: RETURN fnd_api.g_false;
2912:
2913: EXCEPTION
2914: WHEN FND_API.G_EXC_ERROR THEN
2915: RETURN fnd_api.g_true;
2916: END chk_duplicate_worksheet;
2917:
2918: -- ===========================================================================

Line 2915: RETURN fnd_api.g_true;

2911: RETURN fnd_api.g_false;
2912:
2913: EXCEPTION
2914: WHEN FND_API.G_EXC_ERROR THEN
2915: RETURN fnd_api.g_true;
2916: END chk_duplicate_worksheet;
2917:
2918: -- ===========================================================================
2919: -- Procedure : check_worksheet_status

Line 2956: RAISE FND_API.G_EXC_ERROR;

2952: fnd_message.set_name('CN', 'CN_WKSHT_CANNOT_BE_MODIFIED');
2953: fnd_msg_pub.add;
2954: END IF;
2955: x_loading_status := 'CN_WKSHT_CANNOT_BE_MODIFIED';
2956: RAISE FND_API.G_EXC_ERROR;
2957: END IF;
2958: RETURN fnd_api.g_false;
2959:
2960: EXCEPTION

Line 2958: RETURN fnd_api.g_false;

2954: END IF;
2955: x_loading_status := 'CN_WKSHT_CANNOT_BE_MODIFIED';
2956: RAISE FND_API.G_EXC_ERROR;
2957: END IF;
2958: RETURN fnd_api.g_false;
2959:
2960: EXCEPTION
2961: WHEN FND_API.G_EXC_ERROR THEN
2962: RETURN fnd_api.g_true;

Line 2961: WHEN FND_API.G_EXC_ERROR THEN

2957: END IF;
2958: RETURN fnd_api.g_false;
2959:
2960: EXCEPTION
2961: WHEN FND_API.G_EXC_ERROR THEN
2962: RETURN fnd_api.g_true;
2963: END chk_worksheet_status;
2964:
2965: --| ---------------------------------------------------------------------+

Line 2962: RETURN fnd_api.g_true;

2958: RETURN fnd_api.g_false;
2959:
2960: EXCEPTION
2961: WHEN FND_API.G_EXC_ERROR THEN
2962: RETURN fnd_api.g_true;
2963: END chk_worksheet_status;
2964:
2965: --| ---------------------------------------------------------------------+
2966: -- Function : Get_pay_Element_Name(P_element_type_id)