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 3974: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3970: EXCEPTION
3971: WHEN OTHERS THEN
3972: ROLLBACK;
3973:
3974: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3975: FND_MSG_PUB.ADD_EXC_MSG
3976: (G_PKG_NAME,
3977: L_API_NAME);
3978: END IF;

Line 3975: FND_MSG_PUB.ADD_EXC_MSG

3971: WHEN OTHERS THEN
3972: ROLLBACK;
3973:
3974: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3975: FND_MSG_PUB.ADD_EXC_MSG
3976: (G_PKG_NAME,
3977: L_API_NAME);
3978: END IF;
3979:

Line 3980: FND_MSG_PUB.COUNT_AND_GET

3976: (G_PKG_NAME,
3977: L_API_NAME);
3978: END IF;
3979:
3980: FND_MSG_PUB.COUNT_AND_GET
3981: ( P_COUNT => X_MSG_COUNT,
3982: P_DATA => X_MSG_DATA);
3983:
3984: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4187: FND_MSG_PUB.ADD_EXC_MSG

4183: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4184:
4185: L_MESG_TEXT := FND_MESSAGE.GET();
4186:
4187: FND_MSG_PUB.ADD_EXC_MSG
4188: ( G_PKG_NAME,
4189: L_API_NAME,
4190: L_MESG_TEXT
4191: );

Line 4193: FND_MSG_PUB.COUNT_AND_GET

4189: L_API_NAME,
4190: L_MESG_TEXT
4191: );
4192:
4193: FND_MSG_PUB.COUNT_AND_GET
4194: (
4195: P_COUNT => X_MSG_COUNT,
4196: P_DATA => X_MSG_DATA
4197: );

Line 4215: FND_MSG_PUB.ADD_EXC_MSG

4211: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
4212:
4213: L_MESG_TEXT := FND_MESSAGE.GET();
4214:
4215: FND_MSG_PUB.ADD_EXC_MSG
4216: ( G_PKG_NAME,
4217: L_API_NAME,
4218: L_MESG_TEXT
4219: );

Line 4221: FND_MSG_PUB.COUNT_AND_GET

4217: L_API_NAME,
4218: L_MESG_TEXT
4219: );
4220:
4221: FND_MSG_PUB.COUNT_AND_GET
4222: (
4223: P_COUNT => X_MSG_COUNT,
4224: P_DATA => X_MSG_DATA
4225: );

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

4233: WHEN OTHERS THEN
4234: ROLLBACK;
4235: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4236:
4237: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4238: FND_MSG_PUB.ADD_EXC_MSG
4239: (G_PKG_NAME,
4240: L_API_NAME);
4241: END IF;

Line 4238: FND_MSG_PUB.ADD_EXC_MSG

4234: ROLLBACK;
4235: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4236:
4237: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4238: FND_MSG_PUB.ADD_EXC_MSG
4239: (G_PKG_NAME,
4240: L_API_NAME);
4241: END IF;
4242:

Line 4243: FND_MSG_PUB.COUNT_AND_GET

4239: (G_PKG_NAME,
4240: L_API_NAME);
4241: END IF;
4242:
4243: FND_MSG_PUB.COUNT_AND_GET
4244: ( P_COUNT => X_MSG_COUNT,
4245: P_DATA => X_MSG_DATA);
4246:
4247: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4298:
4299: WHEN OTHERS THEN
4300: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4301:
4302: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4303: FND_MSG_PUB.ADD_EXC_MSG
4304: (G_PKG_NAME,
4305: L_API_NAME);
4306: END IF;

Line 4303: FND_MSG_PUB.ADD_EXC_MSG

4299: WHEN OTHERS THEN
4300: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4301:
4302: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4303: FND_MSG_PUB.ADD_EXC_MSG
4304: (G_PKG_NAME,
4305: L_API_NAME);
4306: END IF;
4307:

Line 4308: FND_MSG_PUB.COUNT_AND_GET

4304: (G_PKG_NAME,
4305: L_API_NAME);
4306: END IF;
4307:
4308: FND_MSG_PUB.COUNT_AND_GET
4309: ( P_COUNT => X_MSG_COUNT,
4310: P_DATA => X_MSG_DATA );
4311:
4312: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4381: ROLLBACK;
4382:
4383: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4384:
4385: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4386: FND_MSG_PUB.ADD_EXC_MSG
4387: (G_PKG_NAME,
4388: L_API_NAME);
4389: END IF;

Line 4386: FND_MSG_PUB.ADD_EXC_MSG

4382:
4383: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4384:
4385: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4386: FND_MSG_PUB.ADD_EXC_MSG
4387: (G_PKG_NAME,
4388: L_API_NAME);
4389: END IF;
4390:

Line 4391: FND_MSG_PUB.COUNT_AND_GET

4387: (G_PKG_NAME,
4388: L_API_NAME);
4389: END IF;
4390:
4391: FND_MSG_PUB.COUNT_AND_GET
4392: ( P_COUNT => X_MSG_COUNT,
4393: P_DATA => X_MSG_DATA);
4394:
4395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4439: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

4435: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4436:
4437: L_MESG_TEXT := FND_MESSAGE.GET();
4438:
4439: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4440: L_API_NAME,
4441: L_MESG_TEXT);
4442:
4443: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,

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

4439: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4440: L_API_NAME,
4441: L_MESG_TEXT);
4442:
4443: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4444: P_DATA => X_MSG_DATA);
4445:
4446: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4447: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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

4453:
4454: WHEN OTHERS THEN
4455: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4456:
4457: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4458: FND_MSG_PUB.ADD_EXC_MSG
4459: (G_PKG_NAME,
4460: L_API_NAME);
4461: END IF;

Line 4458: FND_MSG_PUB.ADD_EXC_MSG

4454: WHEN OTHERS THEN
4455: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4456:
4457: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4458: FND_MSG_PUB.ADD_EXC_MSG
4459: (G_PKG_NAME,
4460: L_API_NAME);
4461: END IF;
4462:

Line 4463: FND_MSG_PUB.COUNT_AND_GET

4459: (G_PKG_NAME,
4460: L_API_NAME);
4461: END IF;
4462:
4463: FND_MSG_PUB.COUNT_AND_GET
4464: ( P_COUNT => X_MSG_COUNT,
4465: P_DATA => X_MSG_DATA);
4466:
4467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4512: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,

4508: FND_MESSAGE.SET_TOKEN('PROCESS_ID', P_INSTRUCTION_PROCESS_ID );
4509:
4510: L_MESG_TEXT := FND_MESSAGE.GET();
4511:
4512: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4513: L_API_NAME,
4514: L_MESG_TEXT);
4515:
4516: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,

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

4512: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4513: L_API_NAME,
4514: L_MESG_TEXT);
4515:
4516: FND_MSG_PUB.COUNT_AND_GET(P_COUNT => X_MSG_COUNT,
4517: P_DATA => X_MSG_DATA);
4518:
4519: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4520: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,

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

4526:
4527: WHEN OTHERS THEN
4528: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4529:
4530: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4531: FND_MSG_PUB.ADD_EXC_MSG
4532: (G_PKG_NAME,
4533: L_API_NAME);
4534: END IF;

Line 4531: FND_MSG_PUB.ADD_EXC_MSG

4527: WHEN OTHERS THEN
4528: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4529:
4530: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4531: FND_MSG_PUB.ADD_EXC_MSG
4532: (G_PKG_NAME,
4533: L_API_NAME);
4534: END IF;
4535:

Line 4536: FND_MSG_PUB.COUNT_AND_GET

4532: (G_PKG_NAME,
4533: L_API_NAME);
4534: END IF;
4535:
4536: FND_MSG_PUB.COUNT_AND_GET
4537: ( P_COUNT => X_MSG_COUNT,
4538: P_DATA => X_MSG_DATA);
4539:
4540: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4712: ROLLBACK;
4713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4714:
4715:
4716: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4717: FND_MSG_PUB.ADD_EXC_MSG
4718: (G_PKG_NAME,
4719: L_API_NAME);
4720: END IF;

Line 4717: FND_MSG_PUB.ADD_EXC_MSG

4713: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4714:
4715:
4716: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4717: FND_MSG_PUB.ADD_EXC_MSG
4718: (G_PKG_NAME,
4719: L_API_NAME);
4720: END IF;
4721:

Line 4722: FND_MSG_PUB.COUNT_AND_GET

4718: (G_PKG_NAME,
4719: L_API_NAME);
4720: END IF;
4721:
4722: FND_MSG_PUB.COUNT_AND_GET
4723: ( P_COUNT => X_MSG_COUNT,
4724: P_DATA => X_MSG_DATA);
4725:
4726: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4958: EXCEPTION
4959: WHEN OTHERS THEN
4960: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4961:
4962: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4963: FND_MSG_PUB.ADD_EXC_MSG
4964: (G_PKG_NAME,
4965: L_API_NAME);
4966: END IF;

Line 4963: FND_MSG_PUB.ADD_EXC_MSG

4959: WHEN OTHERS THEN
4960: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
4961:
4962: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4963: FND_MSG_PUB.ADD_EXC_MSG
4964: (G_PKG_NAME,
4965: L_API_NAME);
4966: END IF;
4967:

Line 4968: FND_MSG_PUB.COUNT_AND_GET

4964: (G_PKG_NAME,
4965: L_API_NAME);
4966: END IF;
4967:
4968: FND_MSG_PUB.COUNT_AND_GET
4969: ( P_COUNT => X_MSG_COUNT,
4970: P_DATA => X_MSG_DATA);
4971:
4972: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5049: FND_MSG_PUB.ADD_EXC_MSG

5045: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5046:
5047: L_MESG_TEXT := FND_MESSAGE.GET();
5048:
5049: FND_MSG_PUB.ADD_EXC_MSG
5050: ( G_PKG_NAME,
5051: L_API_NAME,
5052: L_MESG_TEXT
5053: );

Line 5055: FND_MSG_PUB.COUNT_AND_GET

5051: L_API_NAME,
5052: L_MESG_TEXT
5053: );
5054:
5055: FND_MSG_PUB.COUNT_AND_GET
5056: (
5057: P_COUNT => X_MSG_COUNT,
5058: P_DATA => X_MSG_DATA
5059: );

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

5072: WHEN NO_DATA_FOUND THEN
5073: ROLLBACK;
5074: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5075:
5076: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5077: FND_MSG_PUB.ADD_EXC_MSG
5078: (G_PKG_NAME,
5079: L_API_NAME);
5080: END IF;

Line 5077: FND_MSG_PUB.ADD_EXC_MSG

5073: ROLLBACK;
5074: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
5075:
5076: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5077: FND_MSG_PUB.ADD_EXC_MSG
5078: (G_PKG_NAME,
5079: L_API_NAME);
5080: END IF;
5081:

Line 5082: FND_MSG_PUB.COUNT_AND_GET

5078: (G_PKG_NAME,
5079: L_API_NAME);
5080: END IF;
5081:
5082: FND_MSG_PUB.COUNT_AND_GET
5083: ( P_COUNT => X_MSG_COUNT,
5084: P_DATA => X_MSG_DATA);
5085:
5086: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

5223: WHEN OTHERS THEN
5224: ROLLBACK;
5225: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
5226:
5227: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5228: FND_MSG_PUB.ADD_EXC_MSG
5229: (G_PKG_NAME,
5230: L_API_NAME);
5231: END IF;

Line 5228: FND_MSG_PUB.ADD_EXC_MSG

5224: ROLLBACK;
5225: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
5226:
5227: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5228: FND_MSG_PUB.ADD_EXC_MSG
5229: (G_PKG_NAME,
5230: L_API_NAME);
5231: END IF;
5232:

Line 5233: FND_MSG_PUB.COUNT_AND_GET

5229: (G_PKG_NAME,
5230: L_API_NAME);
5231: END IF;
5232:
5233: FND_MSG_PUB.COUNT_AND_GET
5234: ( P_COUNT => X_MSG_COUNT,
5235: P_DATA => X_MSG_DATA);
5236:
5237: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5296: FND_MSG_PUB.ADD_EXC_MSG

5292: FND_MESSAGE.SET_TOKEN('API_NAME', L_API_NAME );
5293:
5294: L_MESG_TEXT := FND_MESSAGE.GET();
5295:
5296: FND_MSG_PUB.ADD_EXC_MSG
5297: ( G_PKG_NAME,
5298: L_API_NAME,
5299: L_MESG_TEXT
5300: );

Line 5302: FND_MSG_PUB.COUNT_AND_GET

5298: L_API_NAME,
5299: L_MESG_TEXT
5300: );
5301:
5302: FND_MSG_PUB.COUNT_AND_GET
5303: (
5304: P_COUNT => X_MSG_COUNT,
5305: P_DATA => X_MSG_DATA
5306: );

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

5338: EXCEPTION
5339: WHEN OTHERS THEN
5340: ROLLBACK;
5341:
5342: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5343: FND_MSG_PUB.ADD_EXC_MSG
5344: (G_PKG_NAME,
5345: L_API_NAME);
5346: END IF;

Line 5343: FND_MSG_PUB.ADD_EXC_MSG

5339: WHEN OTHERS THEN
5340: ROLLBACK;
5341:
5342: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5343: FND_MSG_PUB.ADD_EXC_MSG
5344: (G_PKG_NAME,
5345: L_API_NAME);
5346: END IF;
5347:

Line 5348: FND_MSG_PUB.COUNT_AND_GET

5344: (G_PKG_NAME,
5345: L_API_NAME);
5346: END IF;
5347:
5348: FND_MSG_PUB.COUNT_AND_GET
5349: ( P_COUNT => X_MSG_COUNT,
5350: P_DATA => X_MSG_DATA);
5351:
5352: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5818: FND_MSG_PUB.ADD_EXC_MSG

5814: FALSE
5815: );
5816: end if;
5817:
5818: FND_MSG_PUB.ADD_EXC_MSG
5819: ( G_PKG_NAME,
5820: L_API_NAME,
5821: L_MESG_TEXT
5822: );

Line 5824: FND_MSG_PUB.COUNT_AND_GET

5820: L_API_NAME,
5821: L_MESG_TEXT
5822: );
5823:
5824: FND_MSG_PUB.COUNT_AND_GET
5825: (
5826: P_COUNT => X_MSG_COUNT,
5827: P_DATA => X_MSG_DATA
5828: );

Line 6227: FND_MSG_PUB.ADD;

6223: ROLLBACK;
6224:
6225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6226: FND_MESSAGE.SET_NAME('GMO', 'GMO_EXCEEDED_TASK');
6227: FND_MSG_PUB.ADD;
6228: FND_MSG_PUB.COUNT_AND_GET
6229: (
6230: P_COUNT => X_MSG_COUNT,
6231: P_DATA => X_MSG_DATA

Line 6228: FND_MSG_PUB.COUNT_AND_GET

6224:
6225: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
6226: FND_MESSAGE.SET_NAME('GMO', 'GMO_EXCEEDED_TASK');
6227: FND_MSG_PUB.ADD;
6228: FND_MSG_PUB.COUNT_AND_GET
6229: (
6230: P_COUNT => X_MSG_COUNT,
6231: P_DATA => X_MSG_DATA
6232: );

Line 6244: FND_MSG_PUB.ADD;

6240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
6241: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
6242: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6243: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6244: FND_MSG_PUB.ADD;
6245: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6246: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6247: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6248: end if;

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

6241: FND_MESSAGE.SET_NAME('GMO','GMO_INSTR_UNEXPECTED_DB_ERR');
6242: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
6243: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
6244: FND_MSG_PUB.ADD;
6245: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
6246: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
6247: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_instructions_pvt.add_instructions', FALSE);
6248: end if;
6249: