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 37: FND_MSG_PUB.Count_And_Get

33: l_msg_data VARCHAR2(2000);
34:
35: BEGIN
36: IF (p_msg_count IS NULL) THEN
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

Line 55: (substrb((FND_MSG_PUB.get

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

Line 65: FND_MSG_PUB.initialize;

61: END IF;
62:
63: cn_message_pkg.flush;
64:
65: FND_MSG_PUB.initialize;
66:
67: END get_fnd_message;
68:
69: --| ----------------------------------------------------------------------+

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

248: end if;
249:
250: -- Error, check the msg level and add an error message to the
251: -- API message list
252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
254: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
255: FND_MSG_PUB.Add;
256: END IF;

Line 255: FND_MSG_PUB.Add;

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

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

286: end if;
287:
288: -- Error, check the msg level and add an error message to the
289: -- API message list
290: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
291: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
292: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
293: FND_MSG_PUB.Add;
294: END IF;

Line 293: FND_MSG_PUB.Add;

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

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

324: end if;
325:
326: -- Error, check the msg level and add an error message to the
327: -- API message list
328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
329: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
330: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
331: FND_MSG_PUB.Add;
332: END IF;

Line 331: FND_MSG_PUB.Add;

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

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

362: end if;
363:
364: -- Error, check the msg level and add an error message to the
365: -- API message list
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
367: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
368: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
369: FND_MSG_PUB.Add;
370: END IF;

Line 369: FND_MSG_PUB.Add;

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

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

398: end if;
399:
400: -- Error, check the msg level and add an error message to the
401: -- API message list
402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
403: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
404: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
405: FND_MSG_PUB.Add;
406: END IF;

Line 405: FND_MSG_PUB.Add;

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

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

434: end if;
435:
436: -- Error, check the msg level and add an error message to the
437: -- API message list
438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
440: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
441: FND_MSG_PUB.Add;
442: END IF;

Line 441: FND_MSG_PUB.Add;

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

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

470: end if;
471:
472: -- Error, check the msg level and add an error message to the
473: -- API message list
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
475: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
476: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
477: FND_MSG_PUB.Add;
478: END IF;

Line 477: FND_MSG_PUB.Add;

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

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

506: end if;
507:
508: -- Error, check the msg level and add an error message to the
509: -- API message list
510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
511: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
512: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
513: FND_MSG_PUB.Add;
514: END IF;

Line 513: FND_MSG_PUB.Add;

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

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

542: end if;
543:
544: -- Error, check the msg level and add an error message to the
545: -- API message list
546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
547: THEN
548: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
549: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
550: FND_MSG_PUB.Add;

Line 550: FND_MSG_PUB.Add;

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

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

588: end if;
589:
590: -- Error, check the msg level and add an error message to the
591: -- API message list
592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
593: THEN
594: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
595: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 601: FND_MSG_PUB.Add;

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

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

640: end if;
641:
642: -- Error, check the msg level and add an error message to the
643: -- API message list
644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
645: THEN
646: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
647: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 653: FND_MSG_PUB.Add;

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

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

692: end if;
693:
694: -- Error, check the msg level and add an error message to the
695: -- API message list
696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
697: THEN
698: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
699: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 705: FND_MSG_PUB.Add;

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

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

744: end if;
745:
746: -- Error, check the msg level and add an error message to the
747: -- API message list
748: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
749: THEN
750: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
751: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

Line 757: FND_MSG_PUB.Add;

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

Line 931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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
933: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
934: FND_MSG_PUB.Add;
935: END IF;

Line 934: FND_MSG_PUB.Add;

930: -- API message list
931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
932: THEN
933: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
934: FND_MSG_PUB.Add;
935: END IF;
936: END IF;
937: WHEN too_many_rows THEN
938: x_salesrep_id := NULL;

Line 944: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_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
946: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
947: FND_MSG_PUB.Add;
948: END IF;

Line 947: FND_MSG_PUB.Add;

943: -- API message list
944: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
945: THEN
946: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
947: FND_MSG_PUB.Add;
948: END IF;
949: END IF;
950: END chk_and_get_salesrep_id;
951:

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

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
1202: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
1203: FND_MSG_PUB.Add;
1204: END IF;

Line 1203: FND_MSG_PUB.Add;

1199: -- API message list
1200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1201: THEN
1202: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
1203: FND_MSG_PUB.Add;
1204: END IF;
1205: END IF;
1206:
1207: RETURN l_return_code;

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

1904: FROM cn_comp_plans_all
1905: WHERE comp_plan_id = p_comp_plan_id;
1906: EXCEPTION
1907: WHEN NO_DATA_FOUND THEN
1908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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';

Line 1910: FND_MSG_PUB.Add;

1906: EXCEPTION
1907: WHEN NO_DATA_FOUND THEN
1908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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 ;

Line 2186: FND_MSG_PUB.Add;

2182:
2183: EXCEPTION
2184: WHEN NO_DATA_FOUND THEN
2185: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2186: FND_MSG_PUB.Add;
2187: APP_EXCEPTION.raise_exception;
2188: END convert_to_repcurr;
2189:
2190:

Line 2300: FND_MSG_PUB.Add;

2296: EXCEPTION
2297: WHEN NO_DATA_FOUND THEN
2298: -- dbms_output.put_line('no data found --2 ');
2299: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2300: FND_MSG_PUB.Add;
2301: x_return_status := 'E';
2302: END convert_to_repcurr_report;
2303:
2304:

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

2720: CLOSE get_payrun_status;
2721:
2722: -- check payrun status, No operation can be done for PAID
2723: IF l_status <> 'UNPAID' THEN
2724: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2725: THEN
2726: fnd_message.set_name('CN', 'CN_CANNOT_UPD_PAID_F_PAYRUN');
2727: fnd_msg_pub.add;
2728: END IF;

Line 2727: fnd_msg_pub.add;

2723: IF l_status <> 'UNPAID' THEN
2724: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2725: THEN
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;

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

2731: END IF;
2732:
2733: -- check payrun exists
2734: IF l_payrun_id IS NULL THEN
2735: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2736: THEN
2737: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
2738: fnd_msg_pub.add;
2739: END IF;

Line 2738: fnd_msg_pub.add;

2734: IF l_payrun_id IS NULL THEN
2735: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2736: THEN
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;

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

2774: FETCH get_hold_status INTO l_status,l_salesrep_id;
2775: CLOSE get_hold_status;
2776:
2777: IF l_status = 'Y' THEN
2778: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2779: THEN
2780: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2781: fnd_msg_pub.add;
2782: END IF;

Line 2781: fnd_msg_pub.add;

2777: IF l_status = 'Y' THEN
2778: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2779: THEN
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;

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

2785: END IF;
2786:
2787: IF l_salesrep_id IS NULL THEN
2788: x_loading_status := 'CN_SRP_NOT_EXISTS';
2789: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2790: THEN
2791: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2792: fnd_msg_pub.add;
2793: END IF;

Line 2792: fnd_msg_pub.add;

2788: x_loading_status := 'CN_SRP_NOT_EXISTS';
2789: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2790: THEN
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;

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

2828: FETCH get_hold_status INTO l_status,l_salesrep_id;
2829: CLOSE get_hold_status;
2830:
2831: IF l_status = 'Y' THEN
2832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2833: THEN
2834: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2835: fnd_msg_pub.add;
2836: END IF;

Line 2835: fnd_msg_pub.add;

2831: IF l_status = 'Y' THEN
2832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2833: THEN
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;

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

2839: END IF;
2840:
2841: IF l_salesrep_id IS NULL THEN
2842: x_loading_status := 'CN_SRP_NOT_EXISTS';
2843: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2844: THEN
2845: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2846: fnd_msg_pub.add;
2847: END IF;

Line 2846: fnd_msg_pub.add;

2842: x_loading_status := 'CN_SRP_NOT_EXISTS';
2843: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2844: THEN
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;

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

2921: CLOSE get_worksheet;
2922: IF l_found = 1
2923: THEN
2924: --Error condition
2925: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2926: THEN
2927: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
2928: fnd_msg_pub.add;
2929: END IF;

Line 2928: fnd_msg_pub.add;

2924: --Error condition
2925: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2926: THEN
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;

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

2968: CLOSE get_worksheet;
2969: IF l_status NOT IN ( 'UNPAID','PROCESSING' )
2970: THEN
2971: --Error condition
2972: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2973: THEN
2974: fnd_message.set_name('CN', 'CN_WKSHT_CANNOT_BE_MODIFIED');
2975: fnd_msg_pub.add;
2976: END IF;

Line 2975: fnd_msg_pub.add;

2971: --Error condition
2972: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2973: THEN
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;