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 41: p_encoded => FND_API.G_FALSE

37: FND_MSG_PUB.Count_And_Get
38: (
39: p_count => l_msg_count ,
40: p_data => l_msg_data ,
41: p_encoded => FND_API.G_FALSE
42: );
43: ELSE
44: l_msg_count := p_msg_count;
45: l_msg_data := p_msg_data;

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

52: ELSE
53: FOR ctr IN 1..l_msg_count LOOP
54: cn_message_pkg.debug
55: (substrb((FND_MSG_PUB.get
56: (p_msg_index => ctr, p_encoded => FND_API.G_FALSE)),
57: 1,
58: 240)
59: );
60: END LOOP ;

Line 239: l_return_code := FND_API.G_FALSE;

235:
236: l_return_code VARCHAR2(1);
237:
238: BEGIN
239: l_return_code := FND_API.G_FALSE;
240: x_loading_status := p_loading_status;
241: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
242: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
243: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

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

237:
238: BEGIN
239: l_return_code := FND_API.G_FALSE;
240: x_loading_status := p_loading_status;
241: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
242: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
243: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
244: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
245: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 258: l_return_code := FND_API.G_TRUE;

254: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
255: FND_MSG_PUB.Add;
256: END IF;
257: x_loading_status := 'CN_MISS_PARAMETER';
258: l_return_code := FND_API.G_TRUE;
259: END IF;
260:
261: RETURN l_return_code;
262:

Line 277: l_return_code := FND_API.G_FALSE;

273: x_loading_status OUT NOCOPY VARCHAR2 )
274: RETURN VARCHAR2 IS
275: l_return_code VARCHAR2(1);
276: BEGIN
277: l_return_code := FND_API.G_FALSE;
278: x_loading_status := p_loading_status;
279: IF (p_num_para = FND_API.G_MISS_NUM) THEN
280: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
281: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

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

275: l_return_code VARCHAR2(1);
276: BEGIN
277: l_return_code := FND_API.G_FALSE;
278: x_loading_status := p_loading_status;
279: IF (p_num_para = FND_API.G_MISS_NUM) THEN
280: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
281: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
282: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
283: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 296: l_return_code := FND_API.G_TRUE;

292: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
293: FND_MSG_PUB.Add;
294: END IF;
295: x_loading_status := 'CN_MISS_PARAMETER';
296: l_return_code := FND_API.G_TRUE;
297: END IF;
298: RETURN l_return_code;
299: END chk_miss_num_para;
300:

Line 315: l_return_code := FND_API.G_FALSE;

311:
312: l_return_code VARCHAR2(1);
313:
314: BEGIN
315: l_return_code := FND_API.G_FALSE;
316: x_loading_status := p_loading_status;
317: IF (p_date_para = FND_API.G_MISS_DATE) THEN
318: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
319: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

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

313:
314: BEGIN
315: l_return_code := FND_API.G_FALSE;
316: x_loading_status := p_loading_status;
317: IF (p_date_para = FND_API.G_MISS_DATE) THEN
318: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
319: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
320: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
321: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 334: l_return_code := FND_API.G_TRUE;

330: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
331: FND_MSG_PUB.Add;
332: END IF;
333: x_loading_status := 'CN_MISS_PARAMETER';
334: l_return_code := FND_API.G_TRUE;
335: END IF;
336:
337: RETURN l_return_code;
338:

Line 353: l_return_code := FND_API.G_FALSE;

349: x_loading_status OUT NOCOPY VARCHAR2 )
350: RETURN VARCHAR2 IS
351: l_return_code VARCHAR2(1);
352: BEGIN
353: l_return_code := FND_API.G_FALSE;
354: x_loading_status := p_loading_status;
355: IF (p_num_para IS NULL ) THEN
356: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
357: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 372: l_return_code := FND_API.G_TRUE;

368: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
369: FND_MSG_PUB.Add;
370: END IF;
371: x_loading_status := 'CN_CANNOT_NULL';
372: l_return_code := FND_API.G_TRUE;
373: END IF;
374: RETURN l_return_code;
375: END chk_null_num_para;
376:

Line 389: l_return_code := FND_API.G_FALSE;

385: x_loading_status OUT NOCOPY VARCHAR2 )
386: RETURN VARCHAR2 IS
387: l_return_code VARCHAR2(1);
388: BEGIN
389: l_return_code := FND_API.G_FALSE;
390: x_loading_status := p_loading_status;
391: IF (p_char_para IS NULL ) THEN
392: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
393: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 408: l_return_code := FND_API.G_TRUE;

404: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
405: FND_MSG_PUB.Add;
406: END IF;
407: x_loading_status := 'CN_CANNOT_NULL';
408: l_return_code := FND_API.G_TRUE;
409: END IF;
410: RETURN l_return_code;
411: END chk_null_char_para;
412:

Line 425: l_return_code := FND_API.G_FALSE;

421: x_loading_status OUT NOCOPY VARCHAR2 )
422: RETURN VARCHAR2 IS
423: l_return_code VARCHAR2(1);
424: BEGIN
425: l_return_code := FND_API.G_FALSE;
426: x_loading_status := p_loading_status;
427: IF (p_date_para IS NULL ) THEN
428: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
429: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 444: l_return_code := FND_API.G_TRUE;

440: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
441: FND_MSG_PUB.Add;
442: END IF;
443: x_loading_status := 'CN_CANNOT_NULL';
444: l_return_code := FND_API.G_TRUE;
445: END IF;
446: RETURN l_return_code;
447: END chk_null_date_para;
448:

Line 461: l_return_code := FND_API.G_FALSE;

457: x_loading_status OUT NOCOPY VARCHAR2 )
458: RETURN VARCHAR2 IS
459: l_return_code VARCHAR2(1);
460: BEGIN
461: l_return_code := FND_API.G_FALSE;
462: x_loading_status := p_loading_status;
463: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
464: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
465: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

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

459: l_return_code VARCHAR2(1);
460: BEGIN
461: l_return_code := FND_API.G_FALSE;
462: x_loading_status := p_loading_status;
463: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
464: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
465: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
466: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
467: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 480: l_return_code := FND_API.G_TRUE;

476: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
477: FND_MSG_PUB.Add;
478: END IF;
479: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
480: l_return_code := FND_API.G_TRUE;
481: END IF;
482: RETURN l_return_code;
483: END chk_miss_null_num_para;
484:

Line 497: l_return_code := FND_API.G_FALSE;

493: x_loading_status OUT NOCOPY VARCHAR2 )
494: RETURN VARCHAR2 IS
495: l_return_code VARCHAR2(1);
496: BEGIN
497: l_return_code := FND_API.G_FALSE;
498: x_loading_status := p_loading_status;
499: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
500: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
501: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

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

495: l_return_code VARCHAR2(1);
496: BEGIN
497: l_return_code := FND_API.G_FALSE;
498: x_loading_status := p_loading_status;
499: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
500: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
501: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
502: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
503: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 516: l_return_code := FND_API.G_TRUE;

512: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
513: FND_MSG_PUB.Add;
514: END IF;
515: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
516: l_return_code := FND_API.G_TRUE;
517: END IF;
518: RETURN l_return_code;
519: END chk_miss_null_char_para;
520:

Line 533: l_return_code := FND_API.G_FALSE;

529: x_loading_status OUT NOCOPY VARCHAR2 )
530: RETURN VARCHAR2 IS
531: l_return_code VARCHAR2(1);
532: BEGIN
533: l_return_code := FND_API.G_FALSE;
534: x_loading_status := p_loading_status;
535: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
536: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
537: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

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

531: l_return_code VARCHAR2(1);
532: BEGIN
533: l_return_code := FND_API.G_FALSE;
534: x_loading_status := p_loading_status;
535: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
536: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
537: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
538: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
539: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 553: l_return_code := FND_API.G_TRUE;

549: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
550: FND_MSG_PUB.Add;
551: END IF;
552: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
553: l_return_code := FND_API.G_TRUE;
554: END IF;
555: RETURN l_return_code;
556: END chk_miss_null_date_para;
557:

Line 574: l_return_code := FND_API.G_TRUE;

570: x_loading_status OUT NOCOPY VARCHAR2 )
571: RETURN VARCHAR2 IS
572: l_return_code VARCHAR2(1);
573: BEGIN
574: l_return_code := FND_API.G_TRUE;
575: x_loading_status := p_loading_status;
576: IF (p_num_field IS NOT NULL ) THEN
577: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
578: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 604: l_return_code := FND_API.G_FALSE;

600: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
601: FND_MSG_PUB.Add;
602: END IF;
603: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
604: l_return_code := FND_API.G_FALSE;
605: END IF;
606: RETURN l_return_code;
607: END pe_num_field_must_null;
608:

Line 625: l_return_code := FND_API.G_TRUE;

621: x_loading_status OUT NOCOPY VARCHAR2 )
622: RETURN VARCHAR2 IS
623: l_return_code VARCHAR2(1);
624: BEGIN
625: l_return_code := FND_API.G_TRUE;
626: x_loading_status := p_loading_status;
627: IF (p_char_field IS NOT NULL ) THEN
628: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
629: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 656: l_return_code := FND_API.G_FALSE;

652: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
653: FND_MSG_PUB.Add;
654: END IF;
655: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
656: l_return_code := FND_API.G_FALSE;
657: END IF;
658: RETURN l_return_code;
659: END pe_char_field_must_null;
660:

Line 677: l_return_code := FND_API.G_TRUE;

673: x_loading_status OUT NOCOPY VARCHAR2 )
674: RETURN VARCHAR2 IS
675: l_return_code VARCHAR2(1);
676: BEGIN
677: l_return_code := FND_API.G_TRUE;
678: x_loading_status := p_loading_status;
679: IF (p_num_field IS NULL ) THEN
680: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
681: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 708: l_return_code := FND_API.G_FALSE;

704: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
705: FND_MSG_PUB.Add;
706: END IF;
707: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
708: l_return_code := FND_API.G_FALSE;
709: END IF;
710: RETURN l_return_code;
711: END pe_num_field_cannot_null;
712:

Line 729: l_return_code := FND_API.G_TRUE;

725: x_loading_status OUT NOCOPY VARCHAR2 )
726: RETURN VARCHAR2 IS
727: l_return_code VARCHAR2(1);
728: BEGIN
729: l_return_code := FND_API.G_TRUE;
730: x_loading_status := p_loading_status;
731: IF (p_char_field IS NULL ) THEN
732: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
733: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

Line 760: l_return_code := FND_API.G_FALSE;

756: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
757: FND_MSG_PUB.Add;
758: END IF;
759: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
760: l_return_code := FND_API.G_FALSE;
761: END IF;
762: RETURN l_return_code;
763: END pe_char_field_cannot_null;
764: --| ---------------------------------------------------------------------+

Line 920: x_return_status := FND_API.G_RET_STS_SUCCESS;

916: AND org_id = p_org_id
917: AND type = p_type;
918: -- END IF;
919: x_salesrep_id := l_salesrep_id;
920: x_return_status := FND_API.G_RET_STS_SUCCESS;
921: x_loading_status := 'CN_SALESREP_FOUND';
922:
923: EXCEPTION
924: WHEN no_data_found THEN

Line 926: x_return_status := FND_API.G_RET_STS_ERROR;

922:
923: EXCEPTION
924: WHEN no_data_found THEN
925: x_salesrep_id := NULL;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: x_loading_status := 'CN_SALESREP_NOT_FOUND';
928: IF (p_show_message = FND_API.G_TRUE) THEN
929: -- Error, check the msg level and add an error message to the
930: -- API message list

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

924: WHEN no_data_found THEN
925: x_salesrep_id := NULL;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: x_loading_status := 'CN_SALESREP_NOT_FOUND';
928: IF (p_show_message = FND_API.G_TRUE) THEN
929: -- Error, check the msg level and add an error message to the
930: -- API message list
931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
932: THEN

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

935: END IF;
936: END IF;
937: WHEN too_many_rows THEN
938: x_salesrep_id := NULL;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: x_loading_status := 'CN_SALESREP_TOO_MANY_ROWS';
941: IF (p_show_message = FND_API.G_TRUE) THEN
942: -- Error, check the msg level and add an error message to the
943: -- API message list

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

937: WHEN too_many_rows THEN
938: x_salesrep_id := NULL;
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: x_loading_status := 'CN_SALESREP_TOO_MANY_ROWS';
941: IF (p_show_message = FND_API.G_TRUE) THEN
942: -- Error, check the msg level and add an error message to the
943: -- API message list
944: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
945: THEN

Line 1176: l_return_code := FND_API.G_FALSE;

1172:
1173: l_return_code VARCHAR2(1);
1174:
1175: BEGIN
1176: l_return_code := FND_API.G_FALSE;
1177: x_loading_status := p_loading_status;
1178: IF p_start_date IS NULL THEN
1179: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1180: l_return_code := FND_API.G_TRUE;

Line 1180: l_return_code := FND_API.G_TRUE;

1176: l_return_code := FND_API.G_FALSE;
1177: x_loading_status := p_loading_status;
1178: IF p_start_date IS NULL THEN
1179: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1180: l_return_code := FND_API.G_TRUE;
1181: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1182: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1183: l_return_code := FND_API.G_TRUE;
1184: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN

Line 1181: ELSIF p_start_date = FND_API.G_MISS_DATE THEN

1177: x_loading_status := p_loading_status;
1178: IF p_start_date IS NULL THEN
1179: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1180: l_return_code := FND_API.G_TRUE;
1181: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1182: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1183: l_return_code := FND_API.G_TRUE;
1184: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1185: x_loading_status := 'CN_END_DATE_CANNOT_NULL';

Line 1183: l_return_code := FND_API.G_TRUE;

1179: x_loading_status := 'CN_START_DATE_CANNOT_NULL';
1180: l_return_code := FND_API.G_TRUE;
1181: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1182: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1183: l_return_code := FND_API.G_TRUE;
1184: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1185: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1186: l_return_code := FND_API.G_TRUE;
1187: ELSIF p_end_date = FND_API.G_MISS_DATE

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

1180: l_return_code := FND_API.G_TRUE;
1181: ELSIF p_start_date = FND_API.G_MISS_DATE THEN
1182: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1183: l_return_code := FND_API.G_TRUE;
1184: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1185: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1186: l_return_code := FND_API.G_TRUE;
1187: ELSIF p_end_date = FND_API.G_MISS_DATE
1188: AND p_end_date_nullable <> FND_API.G_TRUE THEN

Line 1186: l_return_code := FND_API.G_TRUE;

1182: x_loading_status := 'CN_START_DATE_CANNOT_MISSING';
1183: l_return_code := FND_API.G_TRUE;
1184: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1185: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1186: l_return_code := FND_API.G_TRUE;
1187: ELSIF p_end_date = FND_API.G_MISS_DATE
1188: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1189: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1190: l_return_code := FND_API.G_TRUE;

Line 1187: ELSIF p_end_date = FND_API.G_MISS_DATE

1183: l_return_code := FND_API.G_TRUE;
1184: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1185: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1186: l_return_code := FND_API.G_TRUE;
1187: ELSIF p_end_date = FND_API.G_MISS_DATE
1188: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1189: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1190: l_return_code := FND_API.G_TRUE;
1191: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN

Line 1188: AND p_end_date_nullable <> FND_API.G_TRUE THEN

1184: ELSIF p_end_date IS NULL AND p_end_date_nullable <> FND_API.G_TRUE THEN
1185: x_loading_status := 'CN_END_DATE_CANNOT_NULL';
1186: l_return_code := FND_API.G_TRUE;
1187: ELSIF p_end_date = FND_API.G_MISS_DATE
1188: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1189: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1190: l_return_code := FND_API.G_TRUE;
1191: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1192: x_loading_status := 'CN_INVALID_DATE_RANGE';

Line 1190: l_return_code := FND_API.G_TRUE;

1186: l_return_code := FND_API.G_TRUE;
1187: ELSIF p_end_date = FND_API.G_MISS_DATE
1188: AND p_end_date_nullable <> FND_API.G_TRUE THEN
1189: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1190: l_return_code := FND_API.G_TRUE;
1191: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1192: x_loading_status := 'CN_INVALID_DATE_RANGE';
1193: l_return_code := FND_API.G_TRUE;
1194: ELSE

Line 1193: l_return_code := FND_API.G_TRUE;

1189: x_loading_status := 'CN_END_DATE_CANNOT_MISSING';
1190: l_return_code := FND_API.G_TRUE;
1191: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1192: x_loading_status := 'CN_INVALID_DATE_RANGE';
1193: l_return_code := FND_API.G_TRUE;
1194: ELSE
1195: l_return_code := FND_API.G_FALSE;
1196: END IF;
1197: IF (l_return_code = FND_API.g_true AND p_show_message = fnd_api.G_TRUE) THEN

Line 1195: l_return_code := FND_API.G_FALSE;

1191: ELSIF p_end_date IS NOT NULL AND p_start_date > p_end_date THEN
1192: x_loading_status := 'CN_INVALID_DATE_RANGE';
1193: l_return_code := FND_API.G_TRUE;
1194: ELSE
1195: l_return_code := FND_API.G_FALSE;
1196: END IF;
1197: IF (l_return_code = FND_API.g_true AND p_show_message = fnd_api.G_TRUE) THEN
1198: -- Error, check the msg level and add an error message to the
1199: -- API message list

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

1193: l_return_code := FND_API.G_TRUE;
1194: ELSE
1195: l_return_code := FND_API.G_FALSE;
1196: END IF;
1197: IF (l_return_code = FND_API.g_true AND p_show_message = fnd_api.G_TRUE) THEN
1198: -- Error, check the msg level and add an error message to the
1199: -- API message list
1200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1201: THEN

Line 1298: fnd_api.g_false);

1294: p_org_id,
1295: l_salesrep_id,
1296: l_return_status,
1297: l_loading_status,
1298: fnd_api.g_false);
1299:
1300: OPEN l_cur(l_salesrep_id, l_role_id, p_start_date, p_end_date);
1301: FETCH l_cur INTO l_rec;
1302: IF (l_cur%notfound) THEN

Line 1898: x_return_status := FND_API.G_RET_STS_SUCCESS;

1894: l_rc_overlap VARCHAR2(03);
1895: l_sum_trx_flag VARCHAR2(03); -- commented for bug 7655423 / uncommented for f port of 7330382
1896:
1897: BEGIN
1898: x_return_status := FND_API.G_RET_STS_SUCCESS;
1899: x_loading_status := p_loading_status;
1900:
1901: BEGIN
1902: SELECT name, Nvl(p_rc_overlap,allow_rev_class_overlap),sum_trx_flag -- commented for bug 7655423

Line 1913: x_return_status := FND_API.G_RET_STS_ERROR;

1909: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_COMP_PLAN');
1910: FND_MSG_PUB.Add;
1911: END IF;
1912: x_loading_status := 'CN_INVALID_COMP_PLAN';
1913: x_return_status := FND_API.G_RET_STS_ERROR;
1914: END ;
1915:
1916: IF l_rc_overlap = 'N' THEN
1917: -- The function below adds the message

Line 1921: x_return_status := FND_API.G_RET_STS_ERROR;

1917: -- The function below adds the message
1918: IF CN_COMP_PLANS_PKG.check_unique_rev_class
1919: (p_comp_plan_id,l_comp_plan_name,l_rc_overlap,l_sum_trx_flag) = FALSE THEN
1920: x_loading_status := 'PLN_PLAN_DUP_REV_CLASS';
1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: END IF ;
1923: END IF;
1924:
1925: END check_revenue_class_overlap;

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

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

Line 2312: RETURN fnd_api.g_miss_char;

2308: --| Desc : function to return FND_API.g_miss_char
2309: --| ---------------------------------------------------------------------=
2310: FUNCTION g_miss_char RETURN VARCHAR2 IS
2311: BEGIN
2312: RETURN fnd_api.g_miss_char;
2313: END g_miss_char;
2314:
2315: --| -----------------------------------------------------------------------=
2316: --| Function Name : g_miss_date

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

2313: END g_miss_char;
2314:
2315: --| -----------------------------------------------------------------------=
2316: --| Function Name : g_miss_date
2317: --| Desc : function to return FND_API.g_miss_date
2318: --| ---------------------------------------------------------------------=
2319: FUNCTION g_miss_date RETURN DATE IS
2320: BEGIN
2321: RETURN fnd_api.g_miss_date;

Line 2321: RETURN fnd_api.g_miss_date;

2317: --| Desc : function to return FND_API.g_miss_date
2318: --| ---------------------------------------------------------------------=
2319: FUNCTION g_miss_date RETURN DATE IS
2320: BEGIN
2321: RETURN fnd_api.g_miss_date;
2322: END g_miss_date;
2323:
2324: --| -----------------------------------------------------------------------=
2325: --| Function Name : g_miss_num

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

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

Line 2330: RETURN fnd_api.g_miss_num;

2326: --| Desc : function to return FND_API.g_miss_num
2327: --| ---------------------------------------------------------------------=
2328: FUNCTION g_miss_num RETURN NUMBER IS
2329: BEGIN
2330: RETURN fnd_api.g_miss_num;
2331: END g_miss_num;
2332:
2333: --| -----------------------------------------------------------------------=
2334: --| Function Name : g_miss_id

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

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

Line 2348: RETURN fnd_api.g_false;

2344: --| Desc : function to return FND_API.g_false
2345: --| ---------------------------------------------------------------------=
2346: FUNCTION g_false RETURN VARCHAR2 IS
2347: BEGIN
2348: RETURN fnd_api.g_false;
2349: END g_false;
2350:
2351: --| -----------------------------------------------------------------------=
2352: --| Function Name : g_true

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

2349: END g_false;
2350:
2351: --| -----------------------------------------------------------------------=
2352: --| Function Name : g_true
2353: --| Desc : function to return FND_API.g_true
2354: --| ---------------------------------------------------------------------=
2355: FUNCTION g_true RETURN VARCHAR2 IS
2356: BEGIN
2357: RETURN fnd_api.g_true;

Line 2357: RETURN fnd_api.g_true;

2353: --| Desc : function to return FND_API.g_true
2354: --| ---------------------------------------------------------------------=
2355: FUNCTION g_true RETURN VARCHAR2 IS
2356: BEGIN
2357: RETURN fnd_api.g_true;
2358: END g_true;
2359:
2360: --| -----------------------------------------------------------------------=
2361: --| Function Name : g_valid_level_none

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

2358: END g_true;
2359:
2360: --| -----------------------------------------------------------------------=
2361: --| Function Name : g_valid_level_none
2362: --| Desc : function to return FND_API.G_VALID_LEVEL_NONE
2363: --| ---------------------------------------------------------------------=
2364: FUNCTION g_valid_level_none RETURN NUMBER IS
2365: BEGIN
2366: RETURN fnd_api.g_valid_level_none;

Line 2366: RETURN fnd_api.g_valid_level_none;

2362: --| Desc : function to return FND_API.G_VALID_LEVEL_NONE
2363: --| ---------------------------------------------------------------------=
2364: FUNCTION g_valid_level_none RETURN NUMBER IS
2365: BEGIN
2366: RETURN fnd_api.g_valid_level_none;
2367: END g_valid_level_none;
2368:
2369: --| -----------------------------------------------------------------------=
2370: --| Function Name : g_valid_level_full

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

2367: END g_valid_level_none;
2368:
2369: --| -----------------------------------------------------------------------=
2370: --| Function Name : g_valid_level_full
2371: --| Desc : function to return FND_API.G_VALID_LEVEL_FULL
2372: --| ---------------------------------------------------------------------=
2373: FUNCTION g_valid_level_full RETURN NUMBER IS
2374: BEGIN
2375: RETURN fnd_api.g_valid_level_full;

Line 2375: RETURN fnd_api.g_valid_level_full;

2371: --| Desc : function to return FND_API.G_VALID_LEVEL_FULL
2372: --| ---------------------------------------------------------------------=
2373: FUNCTION g_valid_level_full RETURN NUMBER IS
2374: BEGIN
2375: RETURN fnd_api.g_valid_level_full;
2376: END g_valid_level_full;
2377:
2378:
2379:

Line 2730: RETURN fnd_api.g_true;

2726: fnd_message.set_name('CN', 'CN_CANNOT_UPD_PAID_F_PAYRUN');
2727: fnd_msg_pub.add;
2728: END IF;
2729: x_loading_status := 'CN_CANNOT_UPD_PAID_F_PAYRUN';
2730: RETURN fnd_api.g_true;
2731: END IF;
2732:
2733: -- check payrun exists
2734: IF l_payrun_id IS NULL THEN

Line 2741: RETURN fnd_api.g_true;

2737: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
2738: fnd_msg_pub.add;
2739: END IF;
2740: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';
2741: RETURN fnd_api.g_true;
2742: END IF;
2743:
2744: RETURN fnd_api.g_false;
2745:

Line 2744: RETURN fnd_api.g_false;

2740: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';
2741: RETURN fnd_api.g_true;
2742: END IF;
2743:
2744: RETURN fnd_api.g_false;
2745:
2746: END chk_payrun_status_paid;
2747: -- ===========================================================================
2748: -- Procedure : Chk_hold_status

Line 2784: RETURN fnd_api.g_true;

2780: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2781: fnd_msg_pub.add;
2782: END IF;
2783: x_loading_status := 'CN_SRP_ON_HOLD';
2784: RETURN fnd_api.g_true;
2785: END IF;
2786:
2787: IF l_salesrep_id IS NULL THEN
2788: x_loading_status := 'CN_SRP_NOT_EXISTS';

Line 2795: RETURN fnd_api.g_true;

2791: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2792: fnd_msg_pub.add;
2793: END IF;
2794: x_loading_status := 'CN_SRP_NOT_EXISTS';
2795: RETURN fnd_api.g_true;
2796: END IF;
2797:
2798: RETURN fnd_api.g_false;
2799: END chk_hold_status;

Line 2798: RETURN fnd_api.g_false;

2794: x_loading_status := 'CN_SRP_NOT_EXISTS';
2795: RETURN fnd_api.g_true;
2796: END IF;
2797:
2798: RETURN fnd_api.g_false;
2799: END chk_hold_status;
2800:
2801: -- ===========================================================================
2802: -- Procedure : Chk_srp_hold_status

Line 2838: RETURN fnd_api.g_true;

2834: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2835: fnd_msg_pub.add;
2836: END IF;
2837: x_loading_status := 'CN_SRP_ON_HOLD';
2838: RETURN fnd_api.g_true;
2839: END IF;
2840:
2841: IF l_salesrep_id IS NULL THEN
2842: x_loading_status := 'CN_SRP_NOT_EXISTS';

Line 2849: RETURN fnd_api.g_true;

2845: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2846: fnd_msg_pub.add;
2847: END IF;
2848: x_loading_status := 'CN_SRP_NOT_EXISTS';
2849: RETURN fnd_api.g_true;
2850: END IF;
2851:
2852: RETURN fnd_api.g_false;
2853: END chk_srp_hold_status;

Line 2852: RETURN fnd_api.g_false;

2848: x_loading_status := 'CN_SRP_NOT_EXISTS';
2849: RETURN fnd_api.g_true;
2850: END IF;
2851:
2852: RETURN fnd_api.g_false;
2853: END chk_srp_hold_status;
2854: --| ---------------------------------------------------------------------+
2855: -- Function : Get_pay_Element_ID(P_quota_id, p_salesrep_id, p_date)
2856: --| ---------------------------------------------------------------------+

Line 2931: RAISE FND_API.G_EXC_ERROR;

2927: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
2928: fnd_msg_pub.add;
2929: END IF;
2930: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
2931: RAISE FND_API.G_EXC_ERROR;
2932: END IF;
2933: RETURN fnd_api.g_false;
2934:
2935: EXCEPTION

Line 2933: RETURN fnd_api.g_false;

2929: END IF;
2930: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
2931: RAISE FND_API.G_EXC_ERROR;
2932: END IF;
2933: RETURN fnd_api.g_false;
2934:
2935: EXCEPTION
2936: WHEN FND_API.G_EXC_ERROR THEN
2937: RETURN fnd_api.g_true;

Line 2936: WHEN FND_API.G_EXC_ERROR THEN

2932: END IF;
2933: RETURN fnd_api.g_false;
2934:
2935: EXCEPTION
2936: WHEN FND_API.G_EXC_ERROR THEN
2937: RETURN fnd_api.g_true;
2938: END chk_duplicate_worksheet;
2939:
2940: -- ===========================================================================

Line 2937: RETURN fnd_api.g_true;

2933: RETURN fnd_api.g_false;
2934:
2935: EXCEPTION
2936: WHEN FND_API.G_EXC_ERROR THEN
2937: RETURN fnd_api.g_true;
2938: END chk_duplicate_worksheet;
2939:
2940: -- ===========================================================================
2941: -- Procedure : check_worksheet_status

Line 2978: RAISE FND_API.G_EXC_ERROR;

2974: fnd_message.set_name('CN', 'CN_WKSHT_CANNOT_BE_MODIFIED');
2975: fnd_msg_pub.add;
2976: END IF;
2977: x_loading_status := 'CN_WKSHT_CANNOT_BE_MODIFIED';
2978: RAISE FND_API.G_EXC_ERROR;
2979: END IF;
2980: RETURN fnd_api.g_false;
2981:
2982: EXCEPTION

Line 2980: RETURN fnd_api.g_false;

2976: END IF;
2977: x_loading_status := 'CN_WKSHT_CANNOT_BE_MODIFIED';
2978: RAISE FND_API.G_EXC_ERROR;
2979: END IF;
2980: RETURN fnd_api.g_false;
2981:
2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2984: RETURN fnd_api.g_true;

Line 2983: WHEN FND_API.G_EXC_ERROR THEN

2979: END IF;
2980: RETURN fnd_api.g_false;
2981:
2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2984: RETURN fnd_api.g_true;
2985: END chk_worksheet_status;
2986:
2987: --| ---------------------------------------------------------------------+

Line 2984: RETURN fnd_api.g_true;

2980: RETURN fnd_api.g_false;
2981:
2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2984: RETURN fnd_api.g_true;
2985: END chk_worksheet_status;
2986:
2987: --| ---------------------------------------------------------------------+
2988: -- Function : Get_pay_Element_Name(P_element_type_id)