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.AMW_RL_HIERARCHY_PKG dependencies on FND_API

Line 822: raise FND_API.G_EXC_UNEXPECTED_ERROR;

818:
819: /* any too_many_rows exception will propogate to caller */
820: if(sql%notfound)
821: then
822: raise FND_API.G_EXC_UNEXPECTED_ERROR;
823: end if;
824:
825:
826:

Line 969: raise FND_API.G_EXC_ERROR;

965: * update any row
966: */
967: if(sql%notfound)
968: then
969: raise FND_API.G_EXC_ERROR;
970: end if;
971:
972:
973: --now update the translatable table

Line 987: raise FND_API.G_EXC_UNEXPECTED_ERROR;

983:
984: /* too_many_rows will be propagated */
985: if(sql%notfound)
986: then
987: raise FND_API.G_EXC_UNEXPECTED_ERROR;
988: end if;
989:
990:
991:

Line 1090: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1086: (p_org_id <> -1 and organization_id = p_org_id));
1087:
1088: exception
1089: when too_many_rows then
1090: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1091: when others then null;
1092:
1093:
1094: end update_appr_ch_ord_num_if_reqd;

Line 1133: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

1129:
1130:
1131: l_api_name constant varchar2(30) := 'add_existing_process_as_child';
1132:
1133: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
1134:
1135: l_dummy pls_integer;
1136:
1137: l_approval_status amw_process.approval_status%type;

Line 1158: x_return_status := FND_API.G_RET_STS_SUCCESS;

1154: from AMW_CURR_APP_HIERARCHY_RL_V);
1155:
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:

Line 1159: if FND_API.to_Boolean(p_init_msg_list) then

1155:
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

Line 1165: raise FND_API.G_EXC_ERROR;

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');
1165: raise FND_API.G_EXC_ERROR;
1166: end if;
1167:
1168: --check if parent_process_id is null
1169: if p_parent_process_id is null then

Line 1170: raise FND_API.G_EXC_ERROR;

1166: end if;
1167:
1168: --check if parent_process_id is null
1169: if p_parent_process_id is null then
1170: raise FND_API.G_EXC_ERROR;
1171: end if;
1172:
1173: --check if child_process_id is null
1174: if p_child_process_id is null then

Line 1175: raise FND_API.G_EXC_ERROR;

1171: end if;
1172:
1173: --check if child_process_id is null
1174: if p_child_process_id is null then
1175: raise FND_API.G_EXC_ERROR;
1176: end if;
1177:
1178:
1179:

Line 1307: when FND_API.G_EXC_ERROR then

1303:
1304:
1305:
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,

Line 1309: x_return_status := FND_API.G_RET_STS_ERROR;

1305:
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:

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 1315: when FND_API.G_EXC_UNEXPECTED_ERROR then

1311: p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:
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,

Line 1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1313:
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:

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 1323: x_return_status := FND_API.G_RET_STS_ERROR;

1319: p_count => x_msg_count,
1320: p_data => x_msg_data);
1321:
1322: when amw_process_locked_exception then
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,

Line 1330: raise FND_API.G_EXC_ERROR;

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:
1332:
1333:
1334:

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333:
1334:
1335:
1336: when amw_circularity_exception then
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,

Line 1344: raise FND_API.G_EXC_ERROR;

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:
1346:
1347: when amw_processing_exception then
1348: ROLLBACK;

Line 1349: x_return_status := FND_API.G_RET_STS_ERROR;

1345:
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:

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 1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1353:
1354:
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);

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 1386: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

1382:
1383: is
1384:
1385: l_api_name constant varchar2(30) := 'delete_child';
1386: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
1387:
1388: l_approval_status amw_process.approval_status%type;
1389:
1390: l_dummy number;

Line 1402: x_return_status := FND_API.G_RET_STS_SUCCESS;

1398: from AMW_CURR_APP_HIERARCHY_RL_V
1399: start with parent_process_id = -1
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:

Line 1403: if FND_API.to_Boolean(p_init_msg_list) then

1399: start with parent_process_id = -1
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

Line 1408: raise FND_API.G_EXC_ERROR;

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;
1409: end if;
1410:
1411: --check if parent_process_id is null
1412: if p_parent_process_id is null then

Line 1413: raise FND_API.G_EXC_ERROR;

1409: end if;
1410:
1411: --check if parent_process_id is null
1412: if p_parent_process_id is null then
1413: raise FND_API.G_EXC_ERROR;
1414: end if;
1415:
1416:
1417: --check if child_process_id is null

Line 1419: raise FND_API.G_EXC_ERROR;

1415:
1416:
1417: --check if child_process_id is null
1418: if p_child_process_id is null then
1419: raise FND_API.G_EXC_ERROR;
1420: end if;
1421:
1422: --check if parent process is locked
1423: if (is_locked_process(p_parent_process_id))

Line 1440: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1436:
1437: if(c_link_exist%notfound)
1438: then
1439: close c_link_exist;
1440: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1441: end if;
1442:
1443: close c_link_exist;
1444:

Line 1468: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1464:
1465:
1466: if (sql%notfound)
1467: then
1468: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1469: end if;
1470:
1471:
1472: update_denorm(p_org_id => -1,

Line 1525: when FND_API.G_EXC_ERROR then

1521:
1522:
1523:
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,

Line 1527: x_return_status := FND_API.G_RET_STS_ERROR;

1523:
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:

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 1533: when FND_API.G_EXC_UNEXPECTED_ERROR then

1529: p_count => x_msg_count,
1530: p_data => x_msg_data);
1531:
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,

Line 1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1531:
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:

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 1541: x_return_status := FND_API.G_RET_STS_ERROR;

1537: p_count => x_msg_count,
1538: p_data => x_msg_data);
1539:
1540: when amw_process_locked_exception then
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,

Line 1548: raise FND_API.G_EXC_ERROR;

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:
1550:
1551: when amw_processing_exception then
1552: ROLLBACK;

Line 1553: x_return_status := FND_API.G_RET_STS_ERROR;

1549:
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:

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 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1557:
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:

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 1643: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

1639:
1640: return l_process_id;
1641: exception
1642: when others
1643: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
1644:
1645: end get_process_id_from_wf_params;
1646:
1647: function does_wf_proc_exist_in_icm(p_name in varchar2,

Line 1666: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1662: exception
1663: when no_data_found then
1664: return false;
1665: when others then
1666: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1667:
1668: end does_wf_proc_exist_in_icm;
1669:
1670: function get_process_code return varchar2

Line 1700: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1696: exception
1697: when no_data_found then
1698: return l_code;
1699: when others then
1700: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1701:
1702:
1703: end;
1704: /* create a new icm process and return the process_id */

Line 2387: x_return_status := FND_API.G_RET_STS_ERROR;

2383:
2384: exception
2385: when amw_process_locked_exception then
2386: ROLLBACK;
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,

Line 2394: raise FND_API.G_EXC_ERROR;

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:
2396: when amw_circularity_exception then
2397: ROLLBACK;
2398: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2398: x_return_status := FND_API.G_RET_STS_ERROR;

2394: raise FND_API.G_EXC_ERROR;
2395:
2396: when amw_circularity_exception then
2397: ROLLBACK;
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,

Line 2405: raise FND_API.G_EXC_ERROR;

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:
2407:
2408: when amw_process_deleted_exception then
2409: ROLLBACK;

Line 2410: x_return_status := FND_API.G_RET_STS_ERROR;

2406:
2407:
2408: when amw_process_deleted_exception then
2409: ROLLBACK;
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,

Line 2417: raise FND_API.G_EXC_ERROR;

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:
2419: when amw_insfcnt_prvlg_exception then
2420: ROLLBACK;
2421: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2421: x_return_status := FND_API.G_RET_STS_ERROR;

2417: raise FND_API.G_EXC_ERROR;
2418:
2419: when amw_insfcnt_prvlg_exception then
2420: ROLLBACK;
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,

Line 2428: raise FND_API.G_EXC_ERROR;

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:
2430: when wf_cycle_present_exception then
2431: ROLLBACK;
2432: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2432: x_return_status := FND_API.G_RET_STS_ERROR;

2428: raise FND_API.G_EXC_ERROR;
2429:
2430: when wf_cycle_present_exception then
2431: ROLLBACK;
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,

Line 2439: raise FND_API.G_EXC_ERROR;

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:
2441: when OTHERS then
2442: ROLLBACK;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2439: raise FND_API.G_EXC_ERROR;
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;

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 2480: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

2476:
2477: is
2478:
2479: l_api_name constant varchar2(30) := 'add_WEBADI_HIERARCHY_LINKS';
2480: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
2481: l_dummy pls_integer;
2482: L_CHILD_ORDER NUMBER;
2483: l_approval_status amw_process.approval_status%type;
2484: l_child_order_number amw_latest_hierarchies.child_order_number%type;

Line 2505: x_return_status := FND_API.G_RET_STS_SUCCESS;

2501:
2502: begin
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:

Line 2506: if FND_API.to_Boolean(p_init_msg_list) then

2502: begin
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

Line 2512: raise FND_API.G_EXC_ERROR;

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');
2512: raise FND_API.G_EXC_ERROR;
2513: end if;
2514:
2515: --check if parent_process_id is null
2516: if p_parent_process_id is null then

Line 2517: raise FND_API.G_EXC_ERROR;

2513: end if;
2514:
2515: --check if parent_process_id is null
2516: if p_parent_process_id is null then
2517: raise FND_API.G_EXC_ERROR;
2518: end if;
2519:
2520: --check if child_process_id is null
2521: if p_child_process_id is null then

Line 2522: raise FND_API.G_EXC_ERROR;

2518: end if;
2519:
2520: --check if child_process_id is null
2521: if p_child_process_id is null then
2522: raise FND_API.G_EXC_ERROR;
2523: end if;
2524:
2525:
2526:

Line 2666: when FND_API.G_EXC_ERROR then

2662: ---update_latest_control_counts(p_parent_process_id);
2663: ---update_latest_risk_counts(p_parent_process_id);
2664:
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,

Line 2668: x_return_status := FND_API.G_RET_STS_ERROR;

2664:
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:

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 2674: when FND_API.G_EXC_UNEXPECTED_ERROR then

2670: p_count => x_msg_count,
2671: p_data => x_msg_data);
2672:
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,

Line 2676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2672:
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:

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 2682: x_return_status := FND_API.G_RET_STS_ERROR;

2678: p_count => x_msg_count,
2679: p_data => x_msg_data);
2680:
2681: when amw_process_locked_exception then
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,

Line 2689: raise FND_API.G_EXC_ERROR;

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:
2691:
2692:
2693:

Line 2696: x_return_status := FND_API.G_RET_STS_ERROR;

2692:
2693:
2694:
2695: when amw_circularity_exception then
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,

Line 2703: raise FND_API.G_EXC_ERROR;

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:
2705:
2706: when amw_processing_exception then
2707: ROLLBACK;

Line 2708: x_return_status := FND_API.G_RET_STS_ERROR;

2704:
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:

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 2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2712:
2713:
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);

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 2789: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

2785:
2786: exception
2787:
2788: when others
2789: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
2790:
2791: end update_approved_risk_counts;
2792:
2793:

Line 2855: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

2851:
2852: exception
2853:
2854: when others
2855: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
2856:
2857: end update_approved_control_counts;
2858:
2859:

Line 2908: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

2904:
2905: exception
2906:
2907: when others
2908: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
2909:
2910: end update_appr_risk_counts;
2911:
2912: procedure update_appr_control_counts is

Line 2957: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

2953:
2954: exception
2955:
2956: when others
2957: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
2958:
2959:
2960: end update_appr_control_counts;
2961:

Line 3018: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

3014:
3015: exception
3016:
3017: when others
3018: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
3019:
3020: end update_latest_control_counts;
3021:
3022:

Line 3068: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

3064:
3065: exception
3066:
3067: when others
3068: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
3069:
3070: end update_latest_risk_counts;
3071:
3072:

Line 3089: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

3085:
3086:
3087: l_api_name constant varchar2(30) := 'update_rc_latest_counts';
3088:
3089: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
3090:
3091: begin
3092: x_return_status := FND_API.G_RET_STS_SUCCESS;
3093: if FND_API.to_Boolean(p_init_msg_list) then

Line 3092: x_return_status := FND_API.G_RET_STS_SUCCESS;

3088:
3089: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
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:

Line 3093: if FND_API.to_Boolean(p_init_msg_list) then

3089: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
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

Line 3099: raise FND_API.G_EXC_ERROR;

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');
3099: raise FND_API.G_EXC_ERROR;
3100: end if;
3101:
3102:
3103: update_latest_risk_counts(p_process_id => p_process_id);

Line 3108: x_return_status := FND_API.G_RET_STS_ERROR;

3104: update_latest_control_counts(p_process_id => p_process_id);
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;

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 3217: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

3213:
3214: exception
3215:
3216: when others
3217: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
3218:
3219: end update_all_latest_rc_counts;
3220:
3221:

Line 3297: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

3293: exception
3294:
3295:
3296: when others
3297: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
3298:
3299: end update_org_count;
3300:
3301: -------------------------------------------------------------------------------------------

Line 3316: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

3312:
3313: is
3314: l_api_name constant varchar2(30) := 'update_attachments';
3315:
3316: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
3317:
3318: begin
3319: x_return_status := FND_API.G_RET_STS_SUCCESS;
3320: if FND_API.to_Boolean(p_init_msg_list) then

Line 3319: x_return_status := FND_API.G_RET_STS_SUCCESS;

3315:
3316: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
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:

Line 3320: if FND_API.to_Boolean(p_init_msg_list) then

3316: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
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

Line 3326: raise FND_API.G_EXC_ERROR;

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');
3326: raise FND_API.G_EXC_ERROR;
3327: end if;
3328:
3329: --First remove all the old attachments
3330: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(X_entity_name => 'AMW_PROCESS',

Line 3354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3350:
3351: exception
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);

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 3435: x_return_status := FND_API.G_RET_STS_ERROR;

3431: when too_many_rows then
3432: fnd_message.set_name('AMW','AMW_COV_TUTOR_NONUNQ');
3433: fnd_message.set_token('AMW_COV_TUTOR_NONUNQ', p_display_name);
3434: x_msg_data := fnd_message.get;
3435: x_return_status := FND_API.G_RET_STS_ERROR;
3436:
3437:
3438: when no_data_found then
3439: create_new_process_as_child(

Line 3705: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

3701: x_msg_count out nocopy number,
3702: x_msg_data out nocopy varchar2) is
3703:
3704: l_api_name constant varchar2(30) := 'isProcessUndoAble';
3705: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
3706: err_msg varchar2(4000);
3707: l_dummy number;
3708: appstatus varchar2(10);
3709:

Line 3711: x_return_status := FND_API.G_RET_STS_SUCCESS;

3707: l_dummy number;
3708: appstatus varchar2(10);
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

Line 3712: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3708: appstatus varchar2(10);
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');

Line 3717: RAISE FND_API.G_EXC_ERROR;

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;
3718: END IF;
3719:
3720: ret_value := 'N';
3721:

Line 3741: WHEN FND_API.G_EXC_ERROR THEN

3737: return;
3738: end if;
3739:
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,

Line 3743: x_return_status := FND_API.G_RET_STS_ERROR;

3739:
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:

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 3748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 3750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3746: p_data => x_msg_data);
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:

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 3757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3753: p_data => x_msg_data);
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;

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 3777: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

3773: x_msg_count out nocopy number,
3774: x_msg_data out nocopy varchar2) is
3775:
3776: l_api_name constant varchar2(30) := 'delete_draft';
3777: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
3778: err_msg varchar2(4000);
3779: appexst varchar2(1);
3780: l_risk_exists boolean :=false;
3781: l_control_exists boolean :=false;

Line 3794: x_return_status := FND_API.G_RET_STS_SUCCESS;

3790: l_dummy number;
3791: ret_val varchar2(10);
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

Line 3795: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3791: ret_val varchar2(10);
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');

Line 3800: RAISE FND_API.G_EXC_ERROR;

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;
3801: END IF;
3802:
3803:
3804:

Line 3829: raise FND_API.G_EXC_ERROR;

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;
3831: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3832: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3833: end if;

Line 3831: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3827: p_procedure_name => 'delete_draft',
3828: p_error_text => err_msg);
3829: raise FND_API.G_EXC_ERROR;
3830: end if;
3831: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3832: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3833: end if;
3834:
3835:

Line 3832: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3828: p_error_text => err_msg);
3829: raise FND_API.G_EXC_ERROR;
3830: end if;
3831: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3832: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3833: end if;
3834:
3835:
3836: delete from amw_process

Line 3868: raise FND_API.G_EXC_ERROR;

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:
3870: exception
3871: when no_data_found then
3872: null;

Line 3998: WHEN FND_API.G_EXC_ERROR THEN

3994:
3995: end if;
3996:
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,

Line 4000: x_return_status := FND_API.G_RET_STS_ERROR;

3996:
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:

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 4005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 4007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4003: p_data => x_msg_data);
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:

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 4014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4010: p_data => x_msg_data);
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;

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 4035: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

4031: x_msg_count out nocopy number,
4032: x_msg_data out nocopy varchar2) is
4033:
4034: l_api_name constant varchar2(30) := 'create_process_owner_grant';
4035: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
4036: err_msg varchar2(4000);
4037: l_party_id number;
4038:
4039: begin

Line 4044: x_return_status := FND_API.G_RET_STS_SUCCESS;

4040:
4041: --always initialize global variables in th api's used from SelfSerivice Fwk..
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

Line 4045: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4041: --always initialize global variables in th api's used from SelfSerivice Fwk..
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');

Line 4050: RAISE FND_API.G_EXC_ERROR;

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;
4051: END IF;
4052:
4053: select person_party_id
4054: into l_party_id

Line 4080: WHEN FND_API.G_EXC_ERROR THEN

4076:
4077:
4078:
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,

Line 4082: x_return_status := FND_API.G_RET_STS_ERROR;

4078:
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:

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 4087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 4089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4085: p_data => x_msg_data);
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:

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 4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4092: p_data => x_msg_data);
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;

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 4115: p_init_msg_list varchar2(10) := FND_API.G_TRUE;

4111: x_msg_count out nocopy number,
4112: x_msg_data out nocopy varchar2)
4113: is
4114: l_api_name constant varchar2(30) := 'delete_activities';
4115: p_init_msg_list varchar2(10) := FND_API.G_TRUE;
4116: str varchar2(4000);
4117: diff number;
4118: childstr varchar2(100);
4119: l_child_string varchar2(4000);

Line 4123: x_return_status := FND_API.G_RET_STS_SUCCESS;

4119: l_child_string varchar2(4000);
4120: l_child_id number;
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

Line 4124: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4120: l_child_id number;
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');

Line 4129: RAISE FND_API.G_EXC_ERROR;

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;
4130: END IF;
4131:
4132: l_child_string := p_child_id_string;
4133: while LENGTH(l_child_string) <> 0 loop

Line 4146: WHEN FND_API.G_EXC_ERROR THEN

4142: and child_id = l_child_id and organization_id = -1;
4143: select LTRIM(str, 'x') into l_child_string from dual;
4144: end loop;
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:

Line 4148: x_return_status := FND_API.G_RET_STS_ERROR;

4144: end loop;
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;

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 4151: WHEN FND_API.G_EXC_UNEXPECTED_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;
4154: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4155:

Line 4153: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

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 4158: 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;
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;

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 4180: p_init_msg_list varchar2(10) := FND_API.G_TRUE;

4176: l_api_name constant varchar2(30) := 'add_activities';
4177: l_dummy pls_integer;
4178: l_approval_status amw_process.approval_status%type;
4179: l_child_order_number amw_latest_hierarchies.child_order_number%type;
4180: p_init_msg_list varchar2(10) := FND_API.G_TRUE;
4181: str varchar2(4000);
4182: diff number;
4183: childstr varchar2(100);
4184: l_child_string varchar2(4000);

Line 4188: x_return_status := FND_API.G_RET_STS_SUCCESS;

4184: l_child_string varchar2(4000);
4185: l_child_id number;
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

Line 4189: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4185: l_child_id number;
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');

Line 4194: raise FND_API.G_EXC_ERROR;

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;
4195: end if;
4196:
4197: --check if parent_process_id is null
4198: if p_parent_process_id is null then

Line 4199: raise FND_API.G_EXC_ERROR;

4195: end if;
4196:
4197: --check if parent_process_id is null
4198: if p_parent_process_id is null then
4199: raise FND_API.G_EXC_ERROR;
4200: end if;
4201:
4202: --check if parent process is locked
4203: if (is_locked_process(p_parent_process_id))

Line 4271: when FND_API.G_EXC_ERROR then

4267: select LTRIM(str, 'x') into l_child_string from dual;
4268: end loop;
4269:
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,

Line 4273: x_return_status := FND_API.G_RET_STS_ERROR;

4269:
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

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 4277: when FND_API.G_EXC_UNEXPECTED_ERROR then

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;
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,

Line 4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4275: p_count => x_msg_count,
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

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 4284: x_return_status := FND_API.G_RET_STS_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;
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,

Line 4291: raise FND_API.G_EXC_ERROR;

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
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;

Line 4293: x_return_status := FND_API.G_RET_STS_ERROR;

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
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,

Line 4300: raise FND_API.G_EXC_ERROR;

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
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,

Line 4303: x_return_status := FND_API.G_RET_STS_ERROR;

4299: p_error_text => x_msg_count);
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

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 4309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4305: p_count => x_msg_count,
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:

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 4317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4313:
4314: end add_activities;
4315:
4316: procedure revise_process(p_process_id in number,
4317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4318: x_return_status out nocopy varchar2,
4319: x_msg_count out nocopy number,
4320: x_msg_data out nocopy varchar2)
4321: is

Line 4325: x_return_status := FND_API.G_RET_STS_SUCCESS;

4321: is
4322: begin
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

Line 4326: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4322: begin
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');

Line 4331: RAISE FND_API.G_EXC_ERROR;

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;
4332: END IF;
4333:
4334: revise_process_if_necessary(p_process_id => p_process_id);
4335:

Line 4339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4335:
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;

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 4347: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4343: end revise_process;
4344:
4345: PROCEDURE update_latest_denorm_counts
4346: ( p_process_id IN NUMBER,
4347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4349: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4350: x_return_status OUT NOCOPY VARCHAR2,
4351: x_msg_count OUT NOCOPY VARCHAR2,

Line 4348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4344:
4345: PROCEDURE update_latest_denorm_counts
4346: ( p_process_id IN NUMBER,
4347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4349: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4350: x_return_status OUT NOCOPY VARCHAR2,
4351: x_msg_count OUT NOCOPY VARCHAR2,
4352: x_msg_data OUT NOCOPY VARCHAR2)

Line 4349: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4345: PROCEDURE update_latest_denorm_counts
4346: ( p_process_id IN NUMBER,
4347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4349: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4350: x_return_status OUT NOCOPY VARCHAR2,
4351: x_msg_count OUT NOCOPY VARCHAR2,
4352: x_msg_data OUT NOCOPY VARCHAR2)
4353: IS

Line 4363: x_return_status := FND_API.G_RET_STS_SUCCESS;

4359:
4360: --always initialize global variables in th api's used from SelfSerivice Fwk..
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

Line 4364: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4360: --always initialize global variables in th api's used from SelfSerivice Fwk..
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');

Line 4369: RAISE FND_API.G_EXC_ERROR;

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;
4370: END IF;
4371:
4372: -- update the latest denorm hierarchy..
4373: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => -1);

Line 4381: WHEN FND_API.G_EXC_ERROR THEN

4377: update_latest_control_counts( p_process_id => p_process_id);
4378:
4379:
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:

Line 4383: x_return_status := FND_API.G_RET_STS_ERROR;

4379:
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;

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 4386: WHEN FND_API.G_EXC_UNEXPECTED_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;
4389: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4390:

Line 4388: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

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 4393: 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;
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;

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;