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_MSG_PUB

Line 15: FND_MSG_PUB.Count_And_Get

11: l_msg_data VARCHAR2(2000);
12:
13: BEGIN
14: IF (p_msg_count IS NULL) THEN
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

Line 33: (substrb((FND_MSG_PUB.get

29: cn_message_pkg.debug('No Message');
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: );

Line 43: FND_MSG_PUB.initialize;

39: END IF;
40:
41: cn_message_pkg.flush;
42:
43: FND_MSG_PUB.initialize;
44:
45: END get_fnd_message;
46:
47: --| ----------------------------------------------------------------------+

Line 230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

226: end if;
227:
228: -- Error, check the msg level and add an error message to the
229: -- API message list
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
232: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
233: FND_MSG_PUB.Add;
234: END IF;

Line 233: FND_MSG_PUB.Add;

229: -- API message list
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
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;

Line 268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

264: end if;
265:
266: -- Error, check the msg level and add an error message to the
267: -- API message list
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
269: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
270: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
271: FND_MSG_PUB.Add;
272: END IF;

Line 271: FND_MSG_PUB.Add;

267: -- API message list
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
269: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
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;

Line 306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

302: end if;
303:
304: -- Error, check the msg level and add an error message to the
305: -- API message list
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
307: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
308: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
309: FND_MSG_PUB.Add;
310: END IF;

Line 309: FND_MSG_PUB.Add;

305: -- API message list
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
307: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
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;

Line 344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

340: end if;
341:
342: -- Error, check the msg level and add an error message to the
343: -- API message list
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
346: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
347: FND_MSG_PUB.Add;
348: END IF;

Line 347: FND_MSG_PUB.Add;

343: -- API message list
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
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;

Line 380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

376: end if;
377:
378: -- Error, check the msg level and add an error message to the
379: -- API message list
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
381: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
382: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
383: FND_MSG_PUB.Add;
384: END IF;

Line 383: FND_MSG_PUB.Add;

379: -- API message list
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
381: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
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;

Line 416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

412: end if;
413:
414: -- Error, check the msg level and add an error message to the
415: -- API message list
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
418: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
419: FND_MSG_PUB.Add;
420: END IF;

Line 419: FND_MSG_PUB.Add;

415: -- API message list
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
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;

Line 452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

448: end if;
449:
450: -- Error, check the msg level and add an error message to the
451: -- API message list
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
453: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
454: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
455: FND_MSG_PUB.Add;
456: END IF;

Line 455: FND_MSG_PUB.Add;

451: -- API message list
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
453: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
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;

Line 488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

484: end if;
485:
486: -- Error, check the msg level and add an error message to the
487: -- API message list
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
489: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
490: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
491: FND_MSG_PUB.Add;
492: END IF;

Line 491: FND_MSG_PUB.Add;

487: -- API message list
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
489: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
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;

Line 524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

520: end if;
521:
522: -- Error, check the msg level and add an error message to the
523: -- API message list
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
525: THEN
526: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
527: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
528: FND_MSG_PUB.Add;

Line 528: FND_MSG_PUB.Add;

524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
525: THEN
526: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
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;

Line 570: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

566: end if;
567:
568: -- Error, check the msg level and add an error message to the
569: -- API message list
570: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
571: THEN
572: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
573: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 579: FND_MSG_PUB.Add;

575: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
577: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
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;

Line 622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

618: end if;
619:
620: -- Error, check the msg level and add an error message to the
621: -- API message list
622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
623: THEN
624: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
625: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 631: FND_MSG_PUB.Add;

627: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
629: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
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;

Line 674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

670: end if;
671:
672: -- Error, check the msg level and add an error message to the
673: -- API message list
674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
675: THEN
676: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
677: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 683: FND_MSG_PUB.Add;

679: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
681: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
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;

Line 726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

722: end if;
723:
724: -- Error, check the msg level and add an error message to the
725: -- API message list
726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
727: THEN
728: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
729: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 735: FND_MSG_PUB.Add;

731: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
733: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
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;

Line 909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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
911: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
912: FND_MSG_PUB.Add;
913: END IF;

Line 912: FND_MSG_PUB.Add;

908: -- API message list
909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
910: THEN
911: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
912: FND_MSG_PUB.Add;
913: END IF;
914: END IF;
915: WHEN too_many_rows THEN
916: x_salesrep_id := NULL;

Line 922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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
924: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
925: FND_MSG_PUB.Add;
926: END IF;

Line 925: FND_MSG_PUB.Add;

921: -- API message list
922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
925: FND_MSG_PUB.Add;
926: END IF;
927: END IF;
928: END chk_and_get_salesrep_id;
929:

Line 1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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
1180: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
1181: FND_MSG_PUB.Add;
1182: END IF;

Line 1181: FND_MSG_PUB.Add;

1177: -- API message list
1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN
1180: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
1181: FND_MSG_PUB.Add;
1182: END IF;
1183: END IF;
1184:
1185: RETURN l_return_code;

Line 1886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1882: FROM cn_comp_plans_all
1883: WHERE comp_plan_id = p_comp_plan_id;
1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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';

Line 1888: FND_MSG_PUB.Add;

1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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 ;

Line 2164: FND_MSG_PUB.Add;

2160:
2161: EXCEPTION
2162: WHEN NO_DATA_FOUND THEN
2163: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2164: FND_MSG_PUB.Add;
2165: APP_EXCEPTION.raise_exception;
2166: END convert_to_repcurr;
2167:
2168:

Line 2278: FND_MSG_PUB.Add;

2274: EXCEPTION
2275: WHEN NO_DATA_FOUND THEN
2276: -- dbms_output.put_line('no data found --2 ');
2277: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2278: FND_MSG_PUB.Add;
2279: x_return_status := 'E';
2280: END convert_to_repcurr_report;
2281:
2282:

Line 2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

2698: CLOSE get_payrun_status;
2699:
2700: -- check payrun status, No operation can be done for PAID
2701: IF l_status <> 'UNPAID' THEN
2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2703: THEN
2704: fnd_message.set_name('CN', 'CN_CANNOT_UPD_PAID_F_PAYRUN');
2705: fnd_msg_pub.add;
2706: END IF;

Line 2705: fnd_msg_pub.add;

2701: IF l_status <> 'UNPAID' THEN
2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2703: THEN
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;

Line 2713: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

2709: END IF;
2710:
2711: -- check payrun exists
2712: IF l_payrun_id IS NULL THEN
2713: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2714: THEN
2715: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
2716: fnd_msg_pub.add;
2717: END IF;

Line 2716: fnd_msg_pub.add;

2712: IF l_payrun_id IS NULL THEN
2713: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2714: THEN
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;

Line 2756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2752: FETCH get_hold_status INTO l_status,l_salesrep_id;
2753: CLOSE get_hold_status;
2754:
2755: IF l_status = 'Y' THEN
2756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2757: THEN
2758: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2759: fnd_msg_pub.add;
2760: END IF;

Line 2759: fnd_msg_pub.add;

2755: IF l_status = 'Y' THEN
2756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2757: THEN
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;

Line 2767: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

2763: END IF;
2764:
2765: IF l_salesrep_id IS NULL THEN
2766: x_loading_status := 'CN_SRP_NOT_EXISTS';
2767: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2768: THEN
2769: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2770: fnd_msg_pub.add;
2771: END IF;

Line 2770: fnd_msg_pub.add;

2766: x_loading_status := 'CN_SRP_NOT_EXISTS';
2767: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2768: THEN
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;

Line 2810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2806: FETCH get_hold_status INTO l_status,l_salesrep_id;
2807: CLOSE get_hold_status;
2808:
2809: IF l_status = 'Y' THEN
2810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2811: THEN
2812: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2813: fnd_msg_pub.add;
2814: END IF;

Line 2813: fnd_msg_pub.add;

2809: IF l_status = 'Y' THEN
2810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2811: THEN
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;

Line 2821: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

2817: END IF;
2818:
2819: IF l_salesrep_id IS NULL THEN
2820: x_loading_status := 'CN_SRP_NOT_EXISTS';
2821: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2822: THEN
2823: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2824: fnd_msg_pub.add;
2825: END IF;

Line 2824: fnd_msg_pub.add;

2820: x_loading_status := 'CN_SRP_NOT_EXISTS';
2821: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2822: THEN
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;

Line 2903: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

2899: CLOSE get_worksheet;
2900: IF l_found = 1
2901: THEN
2902: --Error condition
2903: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2904: THEN
2905: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
2906: fnd_msg_pub.add;
2907: END IF;

Line 2906: fnd_msg_pub.add;

2902: --Error condition
2903: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2904: THEN
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;

Line 2950: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

2946: CLOSE get_worksheet;
2947: IF l_status NOT IN ( 'UNPAID','PROCESSING' )
2948: THEN
2949: --Error condition
2950: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2951: THEN
2952: fnd_message.set_name('CN', 'CN_WKSHT_CANNOT_BE_MODIFIED');
2953: fnd_msg_pub.add;
2954: END IF;

Line 2953: fnd_msg_pub.add;

2949: --Error condition
2950: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2951: THEN
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;