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.GMO_INSTRUCTION_PVT dependencies on FND_MSG_PUB

Line 679: FND_MSG_PUB.ADD_EXC_MSG

675: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
676: FND_MESSAGE.SET_TOKEN('MODE', P_MODE );
677: L_MESG_TEXT := FND_MESSAGE.GET();
678:
679: FND_MSG_PUB.ADD_EXC_MSG
680: ( G_PKG_NAME,
681: L_API_NAME,
682: L_MESG_TEXT
683: );

Line 685: FND_MSG_PUB.COUNT_AND_GET

681: L_API_NAME,
682: L_MESG_TEXT
683: );
684:
685: FND_MSG_PUB.COUNT_AND_GET
686: (
687: P_COUNT => X_MSG_COUNT,
688: P_DATA => X_MSG_DATA
689: );

Line 702: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

698:
699: WHEN OTHERS THEN
700:
701: ROLLBACK;
702: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
703: FND_MSG_PUB.ADD_EXC_MSG
704: ( G_PKG_NAME,
705: L_API_NAME );
706: END IF;

Line 703: FND_MSG_PUB.ADD_EXC_MSG

699: WHEN OTHERS THEN
700:
701: ROLLBACK;
702: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
703: FND_MSG_PUB.ADD_EXC_MSG
704: ( G_PKG_NAME,
705: L_API_NAME );
706: END IF;
707:

Line 708: FND_MSG_PUB.COUNT_AND_GET

704: ( G_PKG_NAME,
705: L_API_NAME );
706: END IF;
707:
708: FND_MSG_PUB.COUNT_AND_GET
709: ( P_COUNT => X_MSG_COUNT,
710: P_DATA => X_MSG_DATA
711: );
712:

Line 976: FND_MSG_PUB.ADD;

972: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
973: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', SQLERRM);
974: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
975: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
976: FND_MSG_PUB.ADD;
977:
978: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
979:
980: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 978: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

974: FND_MESSAGE.SET_TOKEN('PKG_NAME',G_PKG_NAME);
975: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',L_API_NAME);
976: FND_MSG_PUB.ADD;
977:
978: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
979:
980: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
981:
982: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1319: FND_MSG_PUB.ADD_EXC_MSG

1315: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1316: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1317: L_MESG_TEXT := FND_MESSAGE.GET();
1318:
1319: FND_MSG_PUB.ADD_EXC_MSG
1320: ( G_PKG_NAME,
1321: L_API_NAME,
1322: L_MESG_TEXT
1323: );

Line 1325: FND_MSG_PUB.COUNT_AND_GET

1321: L_API_NAME,
1322: L_MESG_TEXT
1323: );
1324:
1325: FND_MSG_PUB.COUNT_AND_GET
1326: (
1327: P_COUNT => X_MSG_COUNT,
1328: P_DATA => X_MSG_DATA
1329: );

Line 1347: FND_MSG_PUB.ADD_EXC_MSG

1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
1344: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
1345: L_MESG_TEXT := FND_MESSAGE.GET();
1346:
1347: FND_MSG_PUB.ADD_EXC_MSG
1348: ( G_PKG_NAME,
1349: L_API_NAME,
1350: L_MESG_TEXT
1351: );

Line 1353: FND_MSG_PUB.COUNT_AND_GET

1349: L_API_NAME,
1350: L_MESG_TEXT
1351: );
1352:
1353: FND_MSG_PUB.COUNT_AND_GET
1354: (
1355: P_COUNT => X_MSG_COUNT,
1356: P_DATA => X_MSG_DATA
1357: );

Line 1370: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1366:
1367: WHEN OTHERS THEN
1368: X_INSTRUCTION_SET_ID := -1;
1369:
1370: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1371: FND_MSG_PUB.ADD_EXC_MSG
1372: (G_PKG_NAME,
1373: L_API_NAME);
1374: END IF;

Line 1371: FND_MSG_PUB.ADD_EXC_MSG

1367: WHEN OTHERS THEN
1368: X_INSTRUCTION_SET_ID := -1;
1369:
1370: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1371: FND_MSG_PUB.ADD_EXC_MSG
1372: (G_PKG_NAME,
1373: L_API_NAME);
1374: END IF;
1375:

Line 1376: FND_MSG_PUB.COUNT_AND_GET

1372: (G_PKG_NAME,
1373: L_API_NAME);
1374: END IF;
1375:
1376: FND_MSG_PUB.COUNT_AND_GET
1377: ( P_COUNT => X_MSG_COUNT,
1378: P_DATA => X_MSG_DATA);
1379:
1380: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2142: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME,L_MESG_TEXT );

2138: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2139: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2140: L_MESG_TEXT := FND_MESSAGE.GET();
2141:
2142: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME,L_MESG_TEXT );
2143: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
2144: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_DEFN_ACKN',FALSE);
2146: END IF;

Line 2143: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

2139: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2140: L_MESG_TEXT := FND_MESSAGE.GET();
2141:
2142: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME,L_MESG_TEXT );
2143: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
2144: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.GMO_INSTRUCTIONS_PVT.SEND_DEFN_ACKN',FALSE);
2146: END IF;
2147:

Line 2151: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2147:
2148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2149:
2150: WHEN OTHERS THEN
2151: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2152: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
2153: END IF;
2154:
2155: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 2152: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);

2148: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2149:
2150: WHEN OTHERS THEN
2151: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2152: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
2153: END IF;
2154:
2155: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2156: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2155: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

2151: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2152: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME, L_API_NAME);
2153: END IF;
2154:
2155: FND_MSG_PUB.COUNT_AND_GET (P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
2156: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2157: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, 'gmo.plsql.GMO_INSTRUCTION_PVT.SEND_DEFN_ACKN',FALSE);
2158: END IF;
2159:

Line 2356: FND_MSG_PUB.ADD_EXC_MSG

2352: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', G_PKG_NAME);
2353: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2354: L_MESG_TEXT := FND_MESSAGE.GET();
2355:
2356: FND_MSG_PUB.ADD_EXC_MSG
2357: ( G_PKG_NAME,
2358: L_API_NAME,
2359: L_MESG_TEXT
2360: );

Line 2362: FND_MSG_PUB.COUNT_AND_GET

2358: L_API_NAME,
2359: L_MESG_TEXT
2360: );
2361:
2362: FND_MSG_PUB.COUNT_AND_GET
2363: (
2364: P_COUNT => X_MSG_COUNT,
2365: P_DATA => X_MSG_DATA
2366: );

Line 2634: FND_MSG_PUB.ADD_EXC_MSG

2630: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
2631:
2632: L_MESG_TEXT := FND_MESSAGE.GET();
2633:
2634: FND_MSG_PUB.ADD_EXC_MSG
2635: ( G_PKG_NAME,
2636: L_API_NAME,
2637: L_MESG_TEXT
2638: );

Line 2640: FND_MSG_PUB.COUNT_AND_GET

2636: L_API_NAME,
2637: L_MESG_TEXT
2638: );
2639:
2640: FND_MSG_PUB.COUNT_AND_GET
2641: (
2642: P_COUNT => X_MSG_COUNT,
2643: P_DATA => X_MSG_DATA
2644: );

Line 2666: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2662: WHEN OTHERS THEN
2663: X_INSTRUCTION_SET_ID := -1;
2664: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2665:
2666: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2667: FND_MSG_PUB.ADD_EXC_MSG
2668: (G_PKG_NAME,
2669: L_API_NAME);
2670: END IF;

Line 2667: FND_MSG_PUB.ADD_EXC_MSG

2663: X_INSTRUCTION_SET_ID := -1;
2664: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2665:
2666: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2667: FND_MSG_PUB.ADD_EXC_MSG
2668: (G_PKG_NAME,
2669: L_API_NAME);
2670: END IF;
2671:

Line 2672: FND_MSG_PUB.COUNT_AND_GET

2668: (G_PKG_NAME,
2669: L_API_NAME);
2670: END IF;
2671:
2672: FND_MSG_PUB.COUNT_AND_GET
2673: ( P_COUNT => X_MSG_COUNT,
2674: P_DATA => X_MSG_DATA);
2675:
2676: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2803: FND_MSG_PUB.ADD_EXC_MSG

2799: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME);
2800:
2801: L_MESG_TEXT := FND_MESSAGE.GET();
2802:
2803: FND_MSG_PUB.ADD_EXC_MSG
2804: ( G_PKG_NAME,
2805: L_API_NAME,
2806: L_MESG_TEXT
2807: );

Line 2809: FND_MSG_PUB.COUNT_AND_GET

2805: L_API_NAME,
2806: L_MESG_TEXT
2807: );
2808:
2809: FND_MSG_PUB.COUNT_AND_GET
2810: (
2811: P_COUNT => X_MSG_COUNT,
2812: P_DATA => X_MSG_DATA
2813: );

Line 3063: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3059: WHEN OTHERS THEN
3060: X_INSTRUCTION_SET_ID := -1;
3061: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3062:
3063: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3064: FND_MSG_PUB.ADD_EXC_MSG
3065: (G_PKG_NAME,
3066: L_API_NAME);
3067: END IF;

Line 3064: FND_MSG_PUB.ADD_EXC_MSG

3060: X_INSTRUCTION_SET_ID := -1;
3061: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3062:
3063: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3064: FND_MSG_PUB.ADD_EXC_MSG
3065: (G_PKG_NAME,
3066: L_API_NAME);
3067: END IF;
3068:

Line 3069: FND_MSG_PUB.COUNT_AND_GET

3065: (G_PKG_NAME,
3066: L_API_NAME);
3067: END IF;
3068:
3069: FND_MSG_PUB.COUNT_AND_GET
3070: ( P_COUNT => X_MSG_COUNT,
3071: P_DATA => X_MSG_DATA);
3072:
3073: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3160: FND_MSG_PUB.ADD_EXC_MSG

3156: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3157:
3158: L_MESG_TEXT := FND_MESSAGE.GET();
3159:
3160: FND_MSG_PUB.ADD_EXC_MSG
3161: ( G_PKG_NAME,
3162: L_API_NAME,
3163: L_MESG_TEXT
3164: );

Line 3166: FND_MSG_PUB.COUNT_AND_GET

3162: L_API_NAME,
3163: L_MESG_TEXT
3164: );
3165:
3166: FND_MSG_PUB.COUNT_AND_GET
3167: (
3168: P_COUNT => X_MSG_COUNT,
3169: P_DATA => X_MSG_DATA
3170: );

Line 3182: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3178: WHEN OTHERS THEN
3179:
3180: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3181:
3182: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3183: FND_MSG_PUB.ADD_EXC_MSG
3184: (G_PKG_NAME,
3185: L_API_NAME);
3186: END IF;

Line 3183: FND_MSG_PUB.ADD_EXC_MSG

3179:
3180: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
3181:
3182: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3183: FND_MSG_PUB.ADD_EXC_MSG
3184: (G_PKG_NAME,
3185: L_API_NAME);
3186: END IF;
3187:

Line 3188: FND_MSG_PUB.COUNT_AND_GET

3184: (G_PKG_NAME,
3185: L_API_NAME);
3186: END IF;
3187:
3188: FND_MSG_PUB.COUNT_AND_GET
3189: ( P_COUNT => X_MSG_COUNT,
3190: P_DATA => X_MSG_DATA);
3191:
3192: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3288: FND_MSG_PUB.ADD_EXC_MSG

3284: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3285:
3286: L_MESG_TEXT := FND_MESSAGE.GET();
3287:
3288: FND_MSG_PUB.ADD_EXC_MSG
3289: ( G_PKG_NAME,
3290: L_API_NAME,
3291: L_MESG_TEXT
3292: );

Line 3294: FND_MSG_PUB.COUNT_AND_GET

3290: L_API_NAME,
3291: L_MESG_TEXT
3292: );
3293:
3294: FND_MSG_PUB.COUNT_AND_GET
3295: (
3296: P_COUNT => X_MSG_COUNT,
3297: P_DATA => X_MSG_DATA
3298: );

Line 3315: FND_MSG_PUB.ADD_EXC_MSG

3311: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3312:
3313: L_MESG_TEXT := FND_MESSAGE.GET();
3314:
3315: FND_MSG_PUB.ADD_EXC_MSG
3316: ( G_PKG_NAME,
3317: L_API_NAME,
3318: L_MESG_TEXT
3319: );

Line 3321: FND_MSG_PUB.COUNT_AND_GET

3317: L_API_NAME,
3318: L_MESG_TEXT
3319: );
3320:
3321: FND_MSG_PUB.COUNT_AND_GET
3322: (
3323: P_COUNT => X_MSG_COUNT,
3324: P_DATA => X_MSG_DATA
3325: );

Line 3337: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3333: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
3334:
3335: WHEN OTHERS THEN
3336:
3337: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3338: FND_MSG_PUB.ADD_EXC_MSG
3339: (G_PKG_NAME,
3340: L_API_NAME);
3341: END IF;

Line 3338: FND_MSG_PUB.ADD_EXC_MSG

3334:
3335: WHEN OTHERS THEN
3336:
3337: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3338: FND_MSG_PUB.ADD_EXC_MSG
3339: (G_PKG_NAME,
3340: L_API_NAME);
3341: END IF;
3342:

Line 3343: FND_MSG_PUB.COUNT_AND_GET

3339: (G_PKG_NAME,
3340: L_API_NAME);
3341: END IF;
3342:
3343: FND_MSG_PUB.COUNT_AND_GET
3344: ( P_COUNT => X_MSG_COUNT,
3345: P_DATA => X_MSG_DATA);
3346:
3347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3461: FND_MSG_PUB.ADD_EXC_MSG

3457: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3458:
3459: L_MESG_TEXT := FND_MESSAGE.GET();
3460:
3461: FND_MSG_PUB.ADD_EXC_MSG
3462: ( G_PKG_NAME,
3463: L_API_NAME,
3464: L_MESG_TEXT
3465: );

Line 3467: FND_MSG_PUB.COUNT_AND_GET

3463: L_API_NAME,
3464: L_MESG_TEXT
3465: );
3466:
3467: FND_MSG_PUB.COUNT_AND_GET
3468: (
3469: P_COUNT => X_MSG_COUNT,
3470: P_DATA => X_MSG_DATA
3471: );

Line 3486: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3482: X_TOTAL_INSTRUCTIONS := 0;
3483: X_OPTIONAL_PENDING_INSTR := 0;
3484: X_MANDATORY_PENDING_INSTR := 0;
3485:
3486: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3487: FND_MSG_PUB.ADD_EXC_MSG
3488: (G_PKG_NAME,
3489: L_API_NAME);
3490: END IF;

Line 3487: FND_MSG_PUB.ADD_EXC_MSG

3483: X_OPTIONAL_PENDING_INSTR := 0;
3484: X_MANDATORY_PENDING_INSTR := 0;
3485:
3486: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3487: FND_MSG_PUB.ADD_EXC_MSG
3488: (G_PKG_NAME,
3489: L_API_NAME);
3490: END IF;
3491:

Line 3492: FND_MSG_PUB.COUNT_AND_GET

3488: (G_PKG_NAME,
3489: L_API_NAME);
3490: END IF;
3491:
3492: FND_MSG_PUB.COUNT_AND_GET
3493: ( P_COUNT => X_MSG_COUNT,
3494: P_DATA => X_MSG_DATA
3495: );
3496:

Line 3597: FND_MSG_PUB.ADD_EXC_MSG

3593: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
3594:
3595: L_MESG_TEXT := FND_MESSAGE.GET();
3596:
3597: FND_MSG_PUB.ADD_EXC_MSG
3598: ( G_PKG_NAME,
3599: L_API_NAME,
3600: L_MESG_TEXT
3601: );

Line 3603: FND_MSG_PUB.COUNT_AND_GET

3599: L_API_NAME,
3600: L_MESG_TEXT
3601: );
3602:
3603: FND_MSG_PUB.COUNT_AND_GET
3604: (
3605: P_COUNT => X_MSG_COUNT,
3606: P_DATA => X_MSG_DATA
3607: );

Line 3621: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3617: X_TOTAL_INSTRUCTIONS := 0;
3618: X_OPTIONAL_PENDING_INSTR := 0;
3619: X_MANDATORY_PENDING_INSTR := 0;
3620:
3621: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3622: FND_MSG_PUB.ADD_EXC_MSG
3623: (G_PKG_NAME,
3624: L_API_NAME);
3625: END IF;

Line 3622: FND_MSG_PUB.ADD_EXC_MSG

3618: X_OPTIONAL_PENDING_INSTR := 0;
3619: X_MANDATORY_PENDING_INSTR := 0;
3620:
3621: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3622: FND_MSG_PUB.ADD_EXC_MSG
3623: (G_PKG_NAME,
3624: L_API_NAME);
3625: END IF;
3626:

Line 3627: FND_MSG_PUB.COUNT_AND_GET

3623: (G_PKG_NAME,
3624: L_API_NAME);
3625: END IF;
3626:
3627: FND_MSG_PUB.COUNT_AND_GET
3628: ( P_COUNT => X_MSG_COUNT,
3629: P_DATA => X_MSG_DATA );
3630:
3631: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3952: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3948: EXCEPTION
3949: WHEN OTHERS THEN
3950: ROLLBACK;
3951:
3952: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3953: FND_MSG_PUB.ADD_EXC_MSG
3954: (G_PKG_NAME,
3955: L_API_NAME);
3956: END IF;

Line 3953: FND_MSG_PUB.ADD_EXC_MSG

3949: WHEN OTHERS THEN
3950: ROLLBACK;
3951:
3952: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3953: FND_MSG_PUB.ADD_EXC_MSG
3954: (G_PKG_NAME,
3955: L_API_NAME);
3956: END IF;
3957:

Line 3958: FND_MSG_PUB.COUNT_AND_GET

3954: (G_PKG_NAME,
3955: L_API_NAME);
3956: END IF;
3957:
3958: FND_MSG_PUB.COUNT_AND_GET
3959: ( P_COUNT => X_MSG_COUNT,
3960: P_DATA => X_MSG_DATA);
3961:
3962: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4165: FND_MSG_PUB.ADD_EXC_MSG

4161: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4162:
4163: L_MESG_TEXT := FND_MESSAGE.GET();
4164:
4165: FND_MSG_PUB.ADD_EXC_MSG
4166: ( G_PKG_NAME,
4167: L_API_NAME,
4168: L_MESG_TEXT
4169: );

Line 4171: FND_MSG_PUB.COUNT_AND_GET

4167: L_API_NAME,
4168: L_MESG_TEXT
4169: );
4170:
4171: FND_MSG_PUB.COUNT_AND_GET
4172: (
4173: P_COUNT => X_MSG_COUNT,
4174: P_DATA => X_MSG_DATA
4175: );

Line 4193: FND_MSG_PUB.ADD_EXC_MSG

4189: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4190:
4191: L_MESG_TEXT := FND_MESSAGE.GET();
4192:
4193: FND_MSG_PUB.ADD_EXC_MSG
4194: ( G_PKG_NAME,
4195: L_API_NAME,
4196: L_MESG_TEXT
4197: );

Line 4199: FND_MSG_PUB.COUNT_AND_GET

4195: L_API_NAME,
4196: L_MESG_TEXT
4197: );
4198:
4199: FND_MSG_PUB.COUNT_AND_GET
4200: (
4201: P_COUNT => X_MSG_COUNT,
4202: P_DATA => X_MSG_DATA
4203: );

Line 4215: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4211: WHEN OTHERS THEN
4212: ROLLBACK;
4213: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4214:
4215: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4216: FND_MSG_PUB.ADD_EXC_MSG
4217: (G_PKG_NAME,
4218: L_API_NAME);
4219: END IF;

Line 4216: FND_MSG_PUB.ADD_EXC_MSG

4212: ROLLBACK;
4213: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4214:
4215: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4216: FND_MSG_PUB.ADD_EXC_MSG
4217: (G_PKG_NAME,
4218: L_API_NAME);
4219: END IF;
4220:

Line 4221: FND_MSG_PUB.COUNT_AND_GET

4217: (G_PKG_NAME,
4218: L_API_NAME);
4219: END IF;
4220:
4221: FND_MSG_PUB.COUNT_AND_GET
4222: ( P_COUNT => X_MSG_COUNT,
4223: P_DATA => X_MSG_DATA);
4224:
4225: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4280: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4276:
4277: WHEN OTHERS THEN
4278: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4279:
4280: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4281: FND_MSG_PUB.ADD_EXC_MSG
4282: (G_PKG_NAME,
4283: L_API_NAME);
4284: END IF;

Line 4281: FND_MSG_PUB.ADD_EXC_MSG

4277: WHEN OTHERS THEN
4278: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4279:
4280: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4281: FND_MSG_PUB.ADD_EXC_MSG
4282: (G_PKG_NAME,
4283: L_API_NAME);
4284: END IF;
4285:

Line 4286: FND_MSG_PUB.COUNT_AND_GET

4282: (G_PKG_NAME,
4283: L_API_NAME);
4284: END IF;
4285:
4286: FND_MSG_PUB.COUNT_AND_GET
4287: ( P_COUNT => X_MSG_COUNT,
4288: P_DATA => X_MSG_DATA );
4289:
4290: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4363: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4359: ROLLBACK;
4360:
4361: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4362:
4363: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4364: FND_MSG_PUB.ADD_EXC_MSG
4365: (G_PKG_NAME,
4366: L_API_NAME);
4367: END IF;

Line 4364: FND_MSG_PUB.ADD_EXC_MSG

4360:
4361: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4362:
4363: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4364: FND_MSG_PUB.ADD_EXC_MSG
4365: (G_PKG_NAME,
4366: L_API_NAME);
4367: END IF;
4368:

Line 4369: FND_MSG_PUB.COUNT_AND_GET

4365: (G_PKG_NAME,
4366: L_API_NAME);
4367: END IF;
4368:
4369: FND_MSG_PUB.COUNT_AND_GET
4370: ( P_COUNT => X_MSG_COUNT,
4371: P_DATA => X_MSG_DATA);
4372:
4373: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4417: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

4413: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4414:
4415: L_MESG_TEXT := FND_MESSAGE.GET();
4416:
4417: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4418: L_API_NAME,
4419: L_MESG_TEXT);
4420:
4421: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,

Line 4421: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,

4417: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4418: L_API_NAME,
4419: L_MESG_TEXT);
4420:
4421: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4422: P_DATA => X_MSG_DATA);
4423:
4424: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4425: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 4435: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4431:
4432: WHEN OTHERS THEN
4433: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4434:
4435: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4436: FND_MSG_PUB.ADD_EXC_MSG
4437: (G_PKG_NAME,
4438: L_API_NAME);
4439: END IF;

Line 4436: FND_MSG_PUB.ADD_EXC_MSG

4432: WHEN OTHERS THEN
4433: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4434:
4435: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4436: FND_MSG_PUB.ADD_EXC_MSG
4437: (G_PKG_NAME,
4438: L_API_NAME);
4439: END IF;
4440:

Line 4441: FND_MSG_PUB.COUNT_AND_GET

4437: (G_PKG_NAME,
4438: L_API_NAME);
4439: END IF;
4440:
4441: FND_MSG_PUB.COUNT_AND_GET
4442: ( P_COUNT => X_MSG_COUNT,
4443: P_DATA => X_MSG_DATA);
4444:
4445: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4490: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

4486: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4487:
4488: L_MESG_TEXT := FND_MESSAGE.GET();
4489:
4490: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4491: L_API_NAME,
4492: L_MESG_TEXT);
4493:
4494: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,

Line 4494: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,

4490: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4491: L_API_NAME,
4492: L_MESG_TEXT);
4493:
4494: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4495: P_DATA => X_MSG_DATA);
4496:
4497: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4498: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

Line 4508: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4504:
4505: WHEN OTHERS THEN
4506: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4507:
4508: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4509: FND_MSG_PUB.ADD_EXC_MSG
4510: (G_PKG_NAME,
4511: L_API_NAME);
4512: END IF;

Line 4509: FND_MSG_PUB.ADD_EXC_MSG

4505: WHEN OTHERS THEN
4506: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4507:
4508: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4509: FND_MSG_PUB.ADD_EXC_MSG
4510: (G_PKG_NAME,
4511: L_API_NAME);
4512: END IF;
4513:

Line 4514: FND_MSG_PUB.COUNT_AND_GET

4510: (G_PKG_NAME,
4511: L_API_NAME);
4512: END IF;
4513:
4514: FND_MSG_PUB.COUNT_AND_GET
4515: ( P_COUNT => X_MSG_COUNT,
4516: P_DATA => X_MSG_DATA);
4517:
4518: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4694: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4690: ROLLBACK;
4691: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4692:
4693:
4694: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4695: FND_MSG_PUB.ADD_EXC_MSG
4696: (G_PKG_NAME,
4697: L_API_NAME);
4698: END IF;

Line 4695: FND_MSG_PUB.ADD_EXC_MSG

4691: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4692:
4693:
4694: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4695: FND_MSG_PUB.ADD_EXC_MSG
4696: (G_PKG_NAME,
4697: L_API_NAME);
4698: END IF;
4699:

Line 4700: FND_MSG_PUB.COUNT_AND_GET

4696: (G_PKG_NAME,
4697: L_API_NAME);
4698: END IF;
4699:
4700: FND_MSG_PUB.COUNT_AND_GET
4701: ( P_COUNT => X_MSG_COUNT,
4702: P_DATA => X_MSG_DATA);
4703:
4704: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4940: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4936: EXCEPTION
4937: WHEN OTHERS THEN
4938: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4939:
4940: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4941: FND_MSG_PUB.ADD_EXC_MSG
4942: (G_PKG_NAME,
4943: L_API_NAME);
4944: END IF;

Line 4941: FND_MSG_PUB.ADD_EXC_MSG

4937: WHEN OTHERS THEN
4938: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4939:
4940: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4941: FND_MSG_PUB.ADD_EXC_MSG
4942: (G_PKG_NAME,
4943: L_API_NAME);
4944: END IF;
4945:

Line 4946: FND_MSG_PUB.COUNT_AND_GET

4942: (G_PKG_NAME,
4943: L_API_NAME);
4944: END IF;
4945:
4946: FND_MSG_PUB.COUNT_AND_GET
4947: ( P_COUNT => X_MSG_COUNT,
4948: P_DATA => X_MSG_DATA);
4949:
4950: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5027: FND_MSG_PUB.ADD_EXC_MSG

5023: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5024:
5025: L_MESG_TEXT := FND_MESSAGE.GET();
5026:
5027: FND_MSG_PUB.ADD_EXC_MSG
5028: ( G_PKG_NAME,
5029: L_API_NAME,
5030: L_MESG_TEXT
5031: );

Line 5033: FND_MSG_PUB.COUNT_AND_GET

5029: L_API_NAME,
5030: L_MESG_TEXT
5031: );
5032:
5033: FND_MSG_PUB.COUNT_AND_GET
5034: (
5035: P_COUNT => X_MSG_COUNT,
5036: P_DATA => X_MSG_DATA
5037: );

Line 5054: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5050: WHEN NO_DATA_FOUND THEN
5051: ROLLBACK;
5052: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5053:
5054: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5055: FND_MSG_PUB.ADD_EXC_MSG
5056: (G_PKG_NAME,
5057: L_API_NAME);
5058: END IF;

Line 5055: FND_MSG_PUB.ADD_EXC_MSG

5051: ROLLBACK;
5052: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5053:
5054: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5055: FND_MSG_PUB.ADD_EXC_MSG
5056: (G_PKG_NAME,
5057: L_API_NAME);
5058: END IF;
5059:

Line 5060: FND_MSG_PUB.COUNT_AND_GET

5056: (G_PKG_NAME,
5057: L_API_NAME);
5058: END IF;
5059:
5060: FND_MSG_PUB.COUNT_AND_GET
5061: ( P_COUNT => X_MSG_COUNT,
5062: P_DATA => X_MSG_DATA);
5063:
5064: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5205: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5201: WHEN OTHERS THEN
5202: ROLLBACK;
5203: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
5204:
5205: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5206: FND_MSG_PUB.ADD_EXC_MSG
5207: (G_PKG_NAME,
5208: L_API_NAME);
5209: END IF;

Line 5206: FND_MSG_PUB.ADD_EXC_MSG

5202: ROLLBACK;
5203: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
5204:
5205: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5206: FND_MSG_PUB.ADD_EXC_MSG
5207: (G_PKG_NAME,
5208: L_API_NAME);
5209: END IF;
5210:

Line 5211: FND_MSG_PUB.COUNT_AND_GET

5207: (G_PKG_NAME,
5208: L_API_NAME);
5209: END IF;
5210:
5211: FND_MSG_PUB.COUNT_AND_GET
5212: ( P_COUNT => X_MSG_COUNT,
5213: P_DATA => X_MSG_DATA);
5214:
5215: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5274: FND_MSG_PUB.ADD_EXC_MSG

5270: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5271:
5272: L_MESG_TEXT := FND_MESSAGE.GET();
5273:
5274: FND_MSG_PUB.ADD_EXC_MSG
5275: ( G_PKG_NAME,
5276: L_API_NAME,
5277: L_MESG_TEXT
5278: );

Line 5280: FND_MSG_PUB.COUNT_AND_GET

5276: L_API_NAME,
5277: L_MESG_TEXT
5278: );
5279:
5280: FND_MSG_PUB.COUNT_AND_GET
5281: (
5282: P_COUNT => X_MSG_COUNT,
5283: P_DATA => X_MSG_DATA
5284: );

Line 5320: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5316: EXCEPTION
5317: WHEN OTHERS THEN
5318: ROLLBACK;
5319:
5320: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5321: FND_MSG_PUB.ADD_EXC_MSG
5322: (G_PKG_NAME,
5323: L_API_NAME);
5324: END IF;

Line 5321: FND_MSG_PUB.ADD_EXC_MSG

5317: WHEN OTHERS THEN
5318: ROLLBACK;
5319:
5320: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5321: FND_MSG_PUB.ADD_EXC_MSG
5322: (G_PKG_NAME,
5323: L_API_NAME);
5324: END IF;
5325:

Line 5326: FND_MSG_PUB.COUNT_AND_GET

5322: (G_PKG_NAME,
5323: L_API_NAME);
5324: END IF;
5325:
5326: FND_MSG_PUB.COUNT_AND_GET
5327: ( P_COUNT => X_MSG_COUNT,
5328: P_DATA => X_MSG_DATA);
5329:
5330: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5796: FND_MSG_PUB.ADD_EXC_MSG

5792: FALSE
5793: );
5794: end if;
5795:
5796: FND_MSG_PUB.ADD_EXC_MSG
5797: ( G_PKG_NAME,
5798: L_API_NAME,
5799: L_MESG_TEXT
5800: );

Line 5802: FND_MSG_PUB.COUNT_AND_GET

5798: L_API_NAME,
5799: L_MESG_TEXT
5800: );
5801:
5802: FND_MSG_PUB.COUNT_AND_GET
5803: (
5804: P_COUNT => X_MSG_COUNT,
5805: P_DATA => X_MSG_DATA
5806: );

Line 6204: FND_MSG_PUB.ADD;

6200: ROLLBACK;
6201:
6202: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6203: FND_MESSAGE.SET_NAME('GMO', 'GMO_EXCEEDED_TASK');
6204: FND_MSG_PUB.ADD;
6205: FND_MSG_PUB.COUNT_AND_GET
6206: (
6207: P_COUNT => X_MSG_COUNT,
6208: P_DATA => X_MSG_DATA

Line 6205: FND_MSG_PUB.COUNT_AND_GET

6201:
6202: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6203: FND_MESSAGE.SET_NAME('GMO', 'GMO_EXCEEDED_TASK');
6204: FND_MSG_PUB.ADD;
6205: FND_MSG_PUB.COUNT_AND_GET
6206: (
6207: P_COUNT => X_MSG_COUNT,
6208: P_DATA => X_MSG_DATA
6209: );

Line 6221: FND_MSG_PUB.ADD;

6217: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
6218: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
6219: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6220: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6221: FND_MSG_PUB.ADD;
6222: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6223: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6224: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6225: end if;

Line 6222: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

6218: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
6219: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6220: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6221: FND_MSG_PUB.ADD;
6222: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6223: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6224: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6225: end if;
6226: