DBA Data[Home] [Help]

APPS.AMW_RL_HIERARCHY_PKG dependencies on FND_MSG_PUB

Line 1160: FND_MSG_PUB.initialize;

1156:
1157: begin
1158: x_return_status := FND_API.G_RET_STS_SUCCESS;
1159: if FND_API.to_Boolean(p_init_msg_list) then
1160: FND_MSG_PUB.initialize;
1161: end if;
1162:
1163: if FND_GLOBAL.user_id is null then
1164: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 1310: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1306: exception
1307: when FND_API.G_EXC_ERROR then
1308: ROLLBACK;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1311: p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:
1314:

Line 1318: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1314:
1315: when FND_API.G_EXC_UNEXPECTED_ERROR then
1316: ROLLBACK;
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1319: p_count => x_msg_count,
1320: p_data => x_msg_data);
1321:
1322: when amw_process_locked_exception then

Line 1327: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: x_msg_count := x_msg_count + 1;
1325: fnd_message.set_name('AMW','AMW_PROCESS_LOCKED');
1326: x_msg_data := fnd_message.get;
1327: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1328: p_procedure_name => 'add_existing_process_as_child',
1329: p_error_text => x_msg_data);
1330: raise FND_API.G_EXC_ERROR;
1331:

Line 1341: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: fnd_message.set_name('AMW','AMW_CIRCULARITY_CREATION');
1339: x_msg_count := x_msg_count + 1;
1340: x_msg_data := fnd_message.get;
1341: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1342: p_procedure_name => 'add_existing_process_as_child',
1343: p_error_text => x_msg_count);
1344: raise FND_API.G_EXC_ERROR;
1345:

Line 1350: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1346:
1347: when amw_processing_exception then
1348: ROLLBACK;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1351: p_count => x_msg_count,
1352: p_data => x_msg_data);
1353:
1354:

Line 1359: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1355: when OTHERS then
1356: ROLLBACK;
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1358:
1359: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1360: p_count => x_msg_count,
1361: p_data => x_msg_data);
1362:
1363:

Line 1404: FND_MSG_PUB.initialize;

1400: connect by prior child_process_id = parent_process_id);
1401: begin
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: if FND_API.to_Boolean(p_init_msg_list) then
1404: FND_MSG_PUB.initialize;
1405: end if;
1406:
1407: if FND_GLOBAL.user_id is null then
1408: raise FND_API.G_EXC_ERROR;

Line 1528: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1524: exception
1525: when FND_API.G_EXC_ERROR then
1526: ROLLBACK;
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1529: p_count => x_msg_count,
1530: p_data => x_msg_data);
1531:
1532:

Line 1536: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1532:
1533: when FND_API.G_EXC_UNEXPECTED_ERROR then
1534: ROLLBACK;
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1537: p_count => x_msg_count,
1538: p_data => x_msg_data);
1539:
1540: when amw_process_locked_exception then

Line 1545: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: x_msg_count := x_msg_count + 1;
1543: fnd_message.set_name('AMW','AMW_PROCESS_LOCKED');
1544: x_msg_data := fnd_message.get;
1545: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1546: p_procedure_name => 'delete_child',
1547: p_error_text => x_msg_data);
1548: raise FND_API.G_EXC_ERROR;
1549:

Line 1554: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1550:
1551: when amw_processing_exception then
1552: ROLLBACK;
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1555: p_count => x_msg_count,
1556: p_data => x_msg_data);
1557:
1558:

Line 1562: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1558:
1559: when OTHERS then
1560: ROLLBACK;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data);
1565:
1566:

Line 2391: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2387: x_return_status := FND_API.G_RET_STS_ERROR;
2388: x_msg_count := x_msg_count + 1;
2389: fnd_message.set_name('AMW','AMW_PROCESS_LOCKED');
2390: x_msg_data := fnd_message.get;
2391: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2392: p_procedure_name => 'import_wf_process',
2393: p_error_text => x_msg_data);
2394: raise FND_API.G_EXC_ERROR;
2395:

Line 2402: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2398: x_return_status := FND_API.G_RET_STS_ERROR;
2399: x_msg_count := x_msg_count + 1;
2400: fnd_message.set_name('AMW','AMW_WF_CIRCULARITY_CREATION');
2401: x_msg_data := fnd_message.get;
2402: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2403: p_procedure_name => 'import_wf_process',
2404: p_error_text => x_msg_data);
2405: raise FND_API.G_EXC_ERROR;
2406:

Line 2414: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2410: x_return_status := FND_API.G_RET_STS_ERROR;
2411: x_msg_count := x_msg_count + 1;
2412: fnd_message.set_name('AMW','AMW_DELETED_PROC_MODIF');
2413: x_msg_data := fnd_message.get;
2414: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2415: p_procedure_name => 'import_wf_process',
2416: p_error_text => x_msg_data);
2417: raise FND_API.G_EXC_ERROR;
2418:

Line 2425: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2421: x_return_status := FND_API.G_RET_STS_ERROR;
2422: x_msg_count := x_msg_count + 1;
2423: fnd_message.set_name('AMW','AMW_INSFCNT_OPRN_PRVLG');
2424: x_msg_data := fnd_message.get;
2425: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2426: p_procedure_name => 'import_wf_process',
2427: p_error_text => x_msg_data);
2428: raise FND_API.G_EXC_ERROR;
2429:

Line 2436: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2432: x_return_status := FND_API.G_RET_STS_ERROR;
2433: x_msg_count := x_msg_count + 1;
2434: fnd_message.set_name('AMW','AMW_CYCLE_IN_WF_HIERARCHY');
2435: x_msg_data := fnd_message.get;
2436: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2437: p_procedure_name => 'import_wf_process',
2438: p_error_text => x_msg_count);
2439: raise FND_API.G_EXC_ERROR;
2440:

Line 2444: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2440:
2441: when OTHERS then
2442: ROLLBACK;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2445: p_count => x_msg_count,
2446: p_data => x_msg_data);
2447: end import_wf_process;
2448:

Line 2507: FND_MSG_PUB.initialize;

2503: ---05.23.2005 npanandi: commenting below log message
2504: ---FND_FILE.PUT_LINE(FND_FILE.LOG,'add_WEBADI_HIERARCHY_LINKS START');
2505: x_return_status := FND_API.G_RET_STS_SUCCESS;
2506: if FND_API.to_Boolean(p_init_msg_list) then
2507: FND_MSG_PUB.initialize;
2508: end if;
2509:
2510: if FND_GLOBAL.user_id is null then
2511: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 2669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2665: exception
2666: when FND_API.G_EXC_ERROR then
2667: ROLLBACK;
2668: x_return_status := FND_API.G_RET_STS_ERROR;
2669: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2670: p_count => x_msg_count,
2671: p_data => x_msg_data);
2672:
2673:

Line 2677: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2673:
2674: when FND_API.G_EXC_UNEXPECTED_ERROR then
2675: ROLLBACK;
2676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2677: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2678: p_count => x_msg_count,
2679: p_data => x_msg_data);
2680:
2681: when amw_process_locked_exception then

Line 2686: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2682: x_return_status := FND_API.G_RET_STS_ERROR;
2683: x_msg_count := x_msg_count + 1;
2684: fnd_message.set_name('AMW','AMW_PROCESS_LOCKED');
2685: x_msg_data := fnd_message.get;
2686: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2687: p_procedure_name => 'add_WEBADI_HIERARCHY_LINKS',
2688: p_error_text => x_msg_data);
2689: raise FND_API.G_EXC_ERROR;
2690:

Line 2700: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697: x_msg_count := x_msg_count + 1;
2698: fnd_message.set_name('AMW','AMW_CIRCULARITY_CREATION');
2699: x_msg_data := fnd_message.get;
2700: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2701: p_procedure_name => 'add_WEBADI_HIERARCHY_LINKS',
2702: p_error_text => x_msg_data);
2703: raise FND_API.G_EXC_ERROR;
2704:

Line 2709: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2705:
2706: when amw_processing_exception then
2707: ROLLBACK;
2708: x_return_status := FND_API.G_RET_STS_ERROR;
2709: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2710: p_count => x_msg_count,
2711: p_data => x_msg_data);
2712:
2713:

Line 2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2714: when OTHERS then
2715: ROLLBACK;
2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2717:
2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2719: p_count => x_msg_count,
2720: p_data => x_msg_data);
2721:
2722: end add_WEBADI_HIERARCHY_LINKS;

Line 3094: FND_MSG_PUB.initialize;

3090:
3091: begin
3092: x_return_status := FND_API.G_RET_STS_SUCCESS;
3093: if FND_API.to_Boolean(p_init_msg_list) then
3094: FND_MSG_PUB.initialize;
3095: end if;
3096:
3097: if FND_GLOBAL.user_id is null then
3098: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 3109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3105:
3106: exception
3107: when others then
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3110: p_count => x_msg_count,
3111: p_data => x_msg_data);
3112: end update_rc_latest_counts;
3113:

Line 3321: FND_MSG_PUB.initialize;

3317:
3318: begin
3319: x_return_status := FND_API.G_RET_STS_SUCCESS;
3320: if FND_API.to_Boolean(p_init_msg_list) then
3321: FND_MSG_PUB.initialize;
3322: end if;
3323:
3324: if FND_GLOBAL.user_id is null then
3325: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 3356: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3352: when OTHERS then
3353:
3354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3355:
3356: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3357: p_count => x_msg_count,
3358: p_data => x_msg_data);
3359:
3360: end update_attachments;

Line 3713: FND_MSG_PUB.initialize;

3709:
3710: begin
3711: x_return_status := FND_API.G_RET_STS_SUCCESS;
3712: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3713: FND_MSG_PUB.initialize;
3714: END IF;
3715: IF FND_GLOBAL.User_Id IS NULL THEN
3716: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3717: RAISE FND_API.G_EXC_ERROR;

Line 3744: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3740: exception
3741: WHEN FND_API.G_EXC_ERROR THEN
3742: ROLLBACK;
3743: x_return_status := FND_API.G_RET_STS_ERROR;
3744: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3745: p_count => x_msg_count,
3746: p_data => x_msg_data);
3747:
3748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3751: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3747:
3748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3749: ROLLBACK;
3750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3751: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3752: p_count => x_msg_count,
3753: p_data => x_msg_data);
3754:
3755: WHEN OTHERS THEN

Line 3758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3754:
3755: WHEN OTHERS THEN
3756: ROLLBACK;
3757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3759: THEN
3760: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3761: END IF;
3762: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 3760: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

3756: ROLLBACK;
3757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3759: THEN
3760: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3761: END IF;
3762: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3763: p_count => x_msg_count,
3764: p_data => x_msg_data);

Line 3762: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

3758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3759: THEN
3760: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3761: END IF;
3762: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3763: p_count => x_msg_count,
3764: p_data => x_msg_data);
3765: end;
3766:

Line 3796: FND_MSG_PUB.initialize;

3792:
3793: begin
3794: x_return_status := FND_API.G_RET_STS_SUCCESS;
3795: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3796: FND_MSG_PUB.initialize;
3797: END IF;
3798: IF FND_GLOBAL.User_Id IS NULL THEN
3799: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3800: RAISE FND_API.G_EXC_ERROR;

Line 3826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',

3822:
3823: if ret_val <> 'Y' then
3824: fnd_message.set_name('AMW','AMW_CANT_UNDO_DRAFT');
3825: err_msg := fnd_message.get;
3826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',
3827: p_procedure_name => 'delete_draft',
3828: p_error_text => err_msg);
3829: raise FND_API.G_EXC_ERROR;
3830: end if;

Line 3865: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',

3861: and end_date is null);
3862:
3863: fnd_message.set_name('AMW','AMW_CANT_DEL_DRAFT_NS');
3864: err_msg := fnd_message.get;
3865: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',
3866: p_procedure_name => 'delete_draft',
3867: p_error_text => err_msg);
3868: raise FND_API.G_EXC_ERROR;
3869:

Line 4001: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3997: exception
3998: WHEN FND_API.G_EXC_ERROR THEN
3999: ROLLBACK;
4000: x_return_status := FND_API.G_RET_STS_ERROR;
4001: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4002: p_count => x_msg_count,
4003: p_data => x_msg_data);
4004:
4005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4008: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4004:
4005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4006: ROLLBACK;
4007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4008: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4009: p_count => x_msg_count,
4010: p_data => x_msg_data);
4011:
4012: WHEN OTHERS THEN

Line 4015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4011:
4012: WHEN OTHERS THEN
4013: ROLLBACK;
4014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4016: THEN
4017: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4018: END IF;
4019: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 4017: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

4013: ROLLBACK;
4014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4016: THEN
4017: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4018: END IF;
4019: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
4020: p_count => x_msg_count,
4021: p_data => x_msg_data);

Line 4019: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

4015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4016: THEN
4017: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4018: END IF;
4019: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
4020: p_count => x_msg_count,
4021: p_data => x_msg_data);
4022: end;
4023:

Line 4046: FND_MSG_PUB.initialize;

4042: G_USER_ID := FND_GLOBAL.USER_ID;
4043: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4044: x_return_status := FND_API.G_RET_STS_SUCCESS;
4045: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4046: FND_MSG_PUB.initialize;
4047: END IF;
4048: IF FND_GLOBAL.User_Id IS NULL THEN
4049: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4050: RAISE FND_API.G_EXC_ERROR;

Line 4083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4079: exception
4080: WHEN FND_API.G_EXC_ERROR THEN
4081: ROLLBACK;
4082: x_return_status := FND_API.G_RET_STS_ERROR;
4083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4084: p_count => x_msg_count,
4085: p_data => x_msg_data);
4086:
4087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4090: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4086:
4087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4088: ROLLBACK;
4089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4090: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4091: p_count => x_msg_count,
4092: p_data => x_msg_data);
4093:
4094: WHEN OTHERS THEN

Line 4097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4093:
4094: WHEN OTHERS THEN
4095: ROLLBACK;
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4098: THEN
4099: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4100: END IF;
4101: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 4099: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

4095: ROLLBACK;
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4098: THEN
4099: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4100: END IF;
4101: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
4102: p_count => x_msg_count,
4103: p_data => x_msg_data);

Line 4101: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

4097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4098: THEN
4099: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4100: END IF;
4101: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
4102: p_count => x_msg_count,
4103: p_data => x_msg_data);
4104: end create_process_owner_grant;
4105:

Line 4125: FND_MSG_PUB.initialize;

4121:
4122: begin
4123: x_return_status := FND_API.G_RET_STS_SUCCESS;
4124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4125: FND_MSG_PUB.initialize;
4126: END IF;
4127: IF FND_GLOBAL.User_Id IS NULL THEN
4128: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4129: RAISE FND_API.G_EXC_ERROR;

Line 4149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4145: exception
4146: WHEN FND_API.G_EXC_ERROR THEN
4147: ROLLBACK;
4148: x_return_status := FND_API.G_RET_STS_ERROR;
4149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4150:
4151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4152: ROLLBACK;
4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4154: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4150:
4151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4152: ROLLBACK;
4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4154: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4155:
4156: WHEN OTHERS THEN
4157: ROLLBACK;
4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4155:
4156: WHEN OTHERS THEN
4157: ROLLBACK;
4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4160: THEN
4161: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4162: END IF;
4163: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

Line 4161: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

4157: ROLLBACK;
4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4160: THEN
4161: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4162: END IF;
4163: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
4164:
4165: end delete_activities;

Line 4163: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

4159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4160: THEN
4161: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4162: END IF;
4163: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
4164:
4165: end delete_activities;
4166:
4167:

Line 4190: FND_MSG_PUB.initialize;

4186:
4187: begin
4188: x_return_status := FND_API.G_RET_STS_SUCCESS;
4189: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4190: FND_MSG_PUB.initialize;
4191: END IF;
4192: if FND_GLOBAL.user_id is null then
4193: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4194: raise FND_API.G_EXC_ERROR;

Line 4274: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4270: exception
4271: when FND_API.G_EXC_ERROR then
4272: ROLLBACK;
4273: x_return_status := FND_API.G_RET_STS_ERROR;
4274: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4275: p_count => x_msg_count,
4276: p_data => x_msg_data);
4277: when FND_API.G_EXC_UNEXPECTED_ERROR then
4278: ROLLBACK;

Line 4280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4276: p_data => x_msg_data);
4277: when FND_API.G_EXC_UNEXPECTED_ERROR then
4278: ROLLBACK;
4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4281: p_count => x_msg_count,
4282: p_data => x_msg_data);
4283: when amw_process_locked_exception then
4284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4288: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

4284: x_return_status := FND_API.G_RET_STS_ERROR;
4285: x_msg_count := x_msg_count + 1;
4286: fnd_message.set_name('AMW','AMW_PROCESS_LOCKED');
4287: x_msg_data := fnd_message.get;
4288: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4289: p_procedure_name => l_api_name,
4290: p_error_text => x_msg_data);
4291: raise FND_API.G_EXC_ERROR;
4292: when amw_circularity_exception then

Line 4297: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

4293: x_return_status := FND_API.G_RET_STS_ERROR;
4294: fnd_message.set_name('AMW','AMW_CIRCULARITY_CREATION');
4295: x_msg_count := x_msg_count + 1;
4296: x_msg_data := fnd_message.get;
4297: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4298: p_procedure_name => l_api_name,
4299: p_error_text => x_msg_count);
4300: raise FND_API.G_EXC_ERROR;
4301: when amw_processing_exception then

Line 4304: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4300: raise FND_API.G_EXC_ERROR;
4301: when amw_processing_exception then
4302: ROLLBACK;
4303: x_return_status := FND_API.G_RET_STS_ERROR;
4304: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4305: p_count => x_msg_count,
4306: p_data => x_msg_data);
4307: when OTHERS then
4308: ROLLBACK;

Line 4310: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4306: p_data => x_msg_data);
4307: when OTHERS then
4308: ROLLBACK;
4309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4310: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4311: p_count => x_msg_count,
4312: p_data => x_msg_data);
4313:
4314: end add_activities;

Line 4327: FND_MSG_PUB.initialize;

4323: G_USER_ID := FND_GLOBAL.USER_ID;
4324: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4325: x_return_status := FND_API.G_RET_STS_SUCCESS;
4326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4327: FND_MSG_PUB.initialize;
4328: END IF;
4329: IF FND_GLOBAL.User_Id IS NULL THEN
4330: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4331: RAISE FND_API.G_EXC_ERROR;

Line 4340: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4336: exception
4337: when OTHERS then
4338: ROLLBACK;
4339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4340: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4341: p_count => x_msg_count,
4342: p_data => x_msg_data);
4343: end revise_process;
4344:

Line 4365: FND_MSG_PUB.initialize;

4361: G_USER_ID := FND_GLOBAL.USER_ID;
4362: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4363: x_return_status := FND_API.G_RET_STS_SUCCESS;
4364: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4365: FND_MSG_PUB.initialize;
4366: END IF;
4367: IF FND_GLOBAL.User_Id IS NULL THEN
4368: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4369: RAISE FND_API.G_EXC_ERROR;

Line 4384: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4380: exception
4381: WHEN FND_API.G_EXC_ERROR THEN
4382: ROLLBACK;
4383: x_return_status := FND_API.G_RET_STS_ERROR;
4384: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4385:
4386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4387: ROLLBACK;
4388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4389: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4385:
4386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4387: ROLLBACK;
4388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4389: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4390:
4391: WHEN OTHERS THEN
4392: ROLLBACK;
4393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4390:
4391: WHEN OTHERS THEN
4392: ROLLBACK;
4393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4395: THEN
4396: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4397: END IF;
4398: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4396: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

4392: ROLLBACK;
4393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4395: THEN
4396: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4397: END IF;
4398: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4399: END update_latest_denorm_counts;
4400:

Line 4398: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4395: THEN
4396: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4397: END IF;
4398: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4399: END update_latest_denorm_counts;
4400:
4401: end AMW_RL_HIERARCHY_PKG;