APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on FND_MESSAGE

Line 265: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');

261: FROM igi_lookups
262: WHERE lookup_code = 'CC'
263: AND lookup_type = 'GCC_DESCRIPTION';
264:
265: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
266: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
267: lv_message := fnd_message.get;
268: IF (g_error_level >= g_debug_level ) THEN
269: FND_LOG.MESSAGE (g_error_level , l_full_path,FALSE);

Line 266: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);

262: WHERE lookup_code = 'CC'
263: AND lookup_type = 'GCC_DESCRIPTION';
264:
265: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
266: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
267: lv_message := fnd_message.get;
268: IF (g_error_level >= g_debug_level ) THEN
269: FND_LOG.MESSAGE (g_error_level , l_full_path,FALSE);
270: END IF;

Line 267: lv_message := fnd_message.get;

263: AND lookup_type = 'GCC_DESCRIPTION';
264:
265: FND_MESSAGE.SET_NAME('IGI', 'IGI_GEN_PROD_NOT_INSTALLED');
266: FND_MESSAGE.SET_TOKEN('OPTION_NAME', l_option_name);
267: lv_message := fnd_message.get;
268: IF (g_error_level >= g_debug_level ) THEN
269: FND_LOG.MESSAGE (g_error_level , l_full_path,FALSE);
270: END IF;
271: errbuf := lv_message;

Line 613: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

609: SQLERRM || '-' || SQLCODE);*/
610:
611: IF ( g_unexp_level >= g_debug_level ) THEN
612:
613: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
614: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
615: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
616: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
617: END IF;

Line 614: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

610:
611: IF ( g_unexp_level >= g_debug_level ) THEN
612:
613: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
614: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
615: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
616: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
617: END IF;
618:

Line 615: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

611: IF ( g_unexp_level >= g_debug_level ) THEN
612:
613: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
614: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
615: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
616: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
617: END IF;
618:
619: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');

Line 619: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');

615: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
616: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
617: END IF;
618:
619: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');
620: l_error_text := FND_MESSAGE.GET;
621: raise_application_error (-20000, l_error_text);
622:
623: END IF;

Line 620: l_error_text := FND_MESSAGE.GET;

616: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
617: END IF;
618:
619: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');
620: l_error_text := FND_MESSAGE.GET;
621: raise_application_error (-20000, l_error_text);
622:
623: END IF;
624:

Line 710: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

706: SQLERRM || '-' || SQLCODE);*/
707:
708: IF ( g_unexp_level >= g_debug_level ) THEN
709:
710: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
711: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
712: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
713: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
714: END IF;

Line 711: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

707:
708: IF ( g_unexp_level >= g_debug_level ) THEN
709:
710: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
711: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
712: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
713: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
714: END IF;
715:

Line 712: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

708: IF ( g_unexp_level >= g_debug_level ) THEN
709:
710: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
711: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
712: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
713: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
714: END IF;
715:
716: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');

Line 716: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');

712: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
713: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
714: END IF;
715:
716: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');
717: l_error_text := FND_MESSAGE.GET;
718: raise_application_error (-20000, l_error_text);
719: END IF;
720: /*FND_FILE.PUT_LINE (FND_FILE.LOG,

Line 717: l_error_text := FND_MESSAGE.GET;

713: FND_LOG.MESSAGE ( g_unexp_level,l_full_path,TRUE);
714: END IF;
715:
716: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_USER_ERROR');
717: l_error_text := FND_MESSAGE.GET;
718: raise_application_error (-20000, l_error_text);
719: END IF;
720: /*FND_FILE.PUT_LINE (FND_FILE.LOG,
721: 'IGC_CC_ARCHIVE_PURGE_PKG - waiting for IGCCAPRR_XML request to finish... ');*/

Line 801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

797: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
798: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
799: END IF;
800: IF ( g_unexp_level >= g_debug_level ) THEN
801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
805: END IF;

Line 802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

798: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
799: END IF;
800: IF ( g_unexp_level >= g_debug_level ) THEN
801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
805: END IF;
806: RETURN;

Line 803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

799: END IF;
800: IF ( g_unexp_level >= g_debug_level ) THEN
801: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
802: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
803: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
804: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
805: END IF;
806: RETURN;
807:

Line 952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

948: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
949: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
950: END IF;
951: IF ( g_unexp_level >= g_debug_level ) THEN
952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
956: END IF;

Line 953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

949: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
950: END IF;
951: IF ( g_unexp_level >= g_debug_level ) THEN
952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
956: END IF;
957: RETURN;

Line 954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

950: END IF;
951: IF ( g_unexp_level >= g_debug_level ) THEN
952: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
953: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
954: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
955: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
956: END IF;
957: RETURN;
958:

Line 1325: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

1321: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1322: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1323: END IF;
1324: IF ( g_unexp_level >= g_debug_level ) THEN
1325: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1326: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1327: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1328: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1329: END IF;

Line 1326: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1322: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1323: END IF;
1324: IF ( g_unexp_level >= g_debug_level ) THEN
1325: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1326: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1327: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1328: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1329: END IF;
1330: RETURN;

Line 1327: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1323: END IF;
1324: IF ( g_unexp_level >= g_debug_level ) THEN
1325: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1326: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1327: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1328: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1329: END IF;
1330: RETURN;
1331:

Line 3105: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

3101: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3102: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3103: END IF;
3104: IF ( g_unexp_level >= g_debug_level ) THEN
3105: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3106: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3107: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3108: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3109: END IF;

Line 3106: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

3102: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3103: END IF;
3104: IF ( g_unexp_level >= g_debug_level ) THEN
3105: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3106: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3107: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3108: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3109: END IF;
3110: RETURN;

Line 3107: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

3103: END IF;
3104: IF ( g_unexp_level >= g_debug_level ) THEN
3105: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3106: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3107: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3108: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3109: END IF;
3110: RETURN;
3111:

Line 3312: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

3308: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3310: END IF;
3311: IF ( g_unexp_level >= g_debug_level ) THEN
3312: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3313: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3314: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3315: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3316: END IF;

Line 3313: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

3309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3310: END IF;
3311: IF ( g_unexp_level >= g_debug_level ) THEN
3312: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3313: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3314: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3315: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3316: END IF;
3317: RETURN;

Line 3314: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

3310: END IF;
3311: IF ( g_unexp_level >= g_debug_level ) THEN
3312: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3313: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3314: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3315: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3316: END IF;
3317: RETURN;
3318:

Line 3409: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

3405: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3406: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3407: END IF;
3408: IF ( g_unexp_level >= g_debug_level ) THEN
3409: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3410: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3411: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3412: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3413: END IF;

Line 3410: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

3406: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3407: END IF;
3408: IF ( g_unexp_level >= g_debug_level ) THEN
3409: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3410: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3411: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3412: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3413: END IF;
3414: RETURN;

Line 3411: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

3407: END IF;
3408: IF ( g_unexp_level >= g_debug_level ) THEN
3409: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3410: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3411: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3412: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3413: END IF;
3414: RETURN;
3415:

Line 3670: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

3666: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3667: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3668: END IF;
3669: IF ( g_unexp_level >= g_debug_level ) THEN
3670: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3671: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3672: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3673: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3674: END IF;

Line 3671: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

3667: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3668: END IF;
3669: IF ( g_unexp_level >= g_debug_level ) THEN
3670: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3671: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3672: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3673: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3674: END IF;
3675: RETURN;

Line 3672: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

3668: END IF;
3669: IF ( g_unexp_level >= g_debug_level ) THEN
3670: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3671: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3672: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3673: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3674: END IF;
3675: RETURN;
3676:

Line 3960: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

3956: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3957: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3958: END IF;
3959: IF ( g_unexp_level >= g_debug_level ) THEN
3960: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3961: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3962: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3963: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3964: END IF;

Line 3961: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

3957: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3958: END IF;
3959: IF ( g_unexp_level >= g_debug_level ) THEN
3960: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3961: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3962: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3963: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3964: END IF;
3965: RETURN;

Line 3962: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

3958: END IF;
3959: IF ( g_unexp_level >= g_debug_level ) THEN
3960: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3961: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3962: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3963: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3964: END IF;
3965: RETURN;
3966:

Line 4171: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

4167: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4168: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4169: END IF;
4170: IF ( g_unexp_level >= g_debug_level ) THEN
4171: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4172: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4173: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4174: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4175: END IF;

Line 4172: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

4168: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4169: END IF;
4170: IF ( g_unexp_level >= g_debug_level ) THEN
4171: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4172: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4173: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4174: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4175: END IF;
4176: RETURN;

Line 4173: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

4169: END IF;
4170: IF ( g_unexp_level >= g_debug_level ) THEN
4171: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4172: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4173: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4174: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4175: END IF;
4176: RETURN;
4177:

Line 4506: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

4502: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4503: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4504: END IF;
4505: IF ( g_unexp_level >= g_debug_level ) THEN
4506: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4507: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4508: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4509: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4510: END IF;

Line 4507: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

4503: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4504: END IF;
4505: IF ( g_unexp_level >= g_debug_level ) THEN
4506: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4507: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4508: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4509: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4510: END IF;
4511: RETURN;

Line 4508: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

4504: END IF;
4505: IF ( g_unexp_level >= g_debug_level ) THEN
4506: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4507: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4508: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4509: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4510: END IF;
4511: RETURN;
4512:

Line 4609: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

4605: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,l_api_name);
4606: END IF;
4607: END IF;
4608: IF ( g_unexp_level >= g_debug_level ) THEN
4609: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4610: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4611: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4612: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4613: END IF;

Line 4610: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

4606: END IF;
4607: END IF;
4608: IF ( g_unexp_level >= g_debug_level ) THEN
4609: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4610: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4611: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4612: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4613: END IF;
4614:

Line 4611: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

4607: END IF;
4608: IF ( g_unexp_level >= g_debug_level ) THEN
4609: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4610: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4611: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4612: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4613: END IF;
4614:
4615: END; -- inner block

Line 4629: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

4625: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4626: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,l_api_name);
4627: END IF;
4628: IF ( g_unexp_level >= g_debug_level ) THEN
4629: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4630: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4631: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4632: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4633: END IF;

Line 4630: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

4626: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,l_api_name);
4627: END IF;
4628: IF ( g_unexp_level >= g_debug_level ) THEN
4629: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4630: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4631: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4632: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4633: END IF;
4634: RETURN FALSE;

Line 4631: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

4627: END IF;
4628: IF ( g_unexp_level >= g_debug_level ) THEN
4629: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4630: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4631: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4632: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4633: END IF;
4634: RETURN FALSE;
4635:

Line 4802: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

4798: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4799: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4800: END IF;
4801: IF ( g_unexp_level >= g_debug_level ) THEN
4802: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4803: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4804: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4805: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4806: END IF;

Line 4803: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

4799: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4800: END IF;
4801: IF ( g_unexp_level >= g_debug_level ) THEN
4802: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4803: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4804: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4805: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4806: END IF;
4807: RETURN;

Line 4804: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

4800: END IF;
4801: IF ( g_unexp_level >= g_debug_level ) THEN
4802: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4803: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4804: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4805: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4806: END IF;
4807: RETURN;
4808:

Line 5167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5163: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5165: END IF;
5166: IF ( g_unexp_level >= g_debug_level ) THEN
5167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5171: END IF;

Line 5168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5165: END IF;
5166: IF ( g_unexp_level >= g_debug_level ) THEN
5167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5171: END IF;
5172: RETURN;

Line 5169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5165: END IF;
5166: IF ( g_unexp_level >= g_debug_level ) THEN
5167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5171: END IF;
5172: RETURN;
5173:

Line 5651: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5647: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5648: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5649: END IF;
5650: IF ( g_unexp_level >= g_debug_level ) THEN
5651: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5652: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5653: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5654: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5655: END IF;

Line 5652: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5648: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5649: END IF;
5650: IF ( g_unexp_level >= g_debug_level ) THEN
5651: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5652: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5653: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5654: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5655: END IF;
5656: RETURN;

Line 5653: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5649: END IF;
5650: IF ( g_unexp_level >= g_debug_level ) THEN
5651: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5652: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5653: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5654: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5655: END IF;
5656: RETURN;
5657:

Line 5888: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

5884: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5885: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5886: END IF;
5887: IF ( g_unexp_level >= g_debug_level ) THEN
5888: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5889: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5890: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5891: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5892: END IF;

Line 5889: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

5885: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5886: END IF;
5887: IF ( g_unexp_level >= g_debug_level ) THEN
5888: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5889: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5890: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5891: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5892: END IF;
5893: RETURN;

Line 5890: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

5886: END IF;
5887: IF ( g_unexp_level >= g_debug_level ) THEN
5888: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5889: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
5890: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
5891: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
5892: END IF;
5893: RETURN;
5894:

Line 6072: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

6068: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6069: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6070: END IF;
6071: IF ( g_unexp_level >= g_debug_level ) THEN
6072: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6073: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6074: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6075: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6076: END IF;

Line 6073: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

6069: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6070: END IF;
6071: IF ( g_unexp_level >= g_debug_level ) THEN
6072: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6073: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6074: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6075: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6076: END IF;
6077: RETURN;

Line 6074: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

6070: END IF;
6071: IF ( g_unexp_level >= g_debug_level ) THEN
6072: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
6073: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
6074: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
6075: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
6076: END IF;
6077: RETURN;
6078: