[Home] [Help]
13: -- File : jtfpecb.pls
14: --
15: -- History : 11-SEP-00 tivanov Created
16: --
17: -- Standard parameters: Please review the package specification
18: -- for the list with parameters.
19: --
20: -- Version : 1.0
21: --
599: BEGIN
600:
601: SAVEPOINT Create_Escalation;
602:
603: -- Standard call to check for call compatibility.
604:
605: IF NOT FND_API.Compatible_API_Call ( l_api_version,
606: p_api_version,
607: l_api_name,
620:
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: ----------------------------------------------------------------------------------------------------
624: -- standard customer user hook pre-processing
625: ----------------------------------------------------------------------------------------------------
626: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'B', 'C' ) ) then
627: jtf_ec_cuhk.Create_Escalation_Pre(
628: p_esc_id => l_escalation_id,
642: end if;
643:
644: end if;
645: ----------------------------------------------------------------------------------------------------
646: -- standard verticle industry user hook pre-processing
647: ----------------------------------------------------------------------------------------------------
648: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'B', 'V' ) ) then
649: jtf_ec_vuhk.Create_Escalation_Pre(
650: p_esc_id => l_escalation_id,
1098: set workflow_process_id = l_wf_process_id
1099: where task_id = l_escalation_id;
1100:
1101: ----------------------------------------------------------------------------------------------------
1102: -- standard verticle industry user hook post-processing
1103: ----------------------------------------------------------------------------------------------------
1104: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'A', 'V' ) ) then
1105: jtf_ec_vuhk.Create_Escalation_Post(
1106: p_esc_id => l_escalation_id,
1121:
1122: end if;
1123:
1124: ----------------------------------------------------------------------------------------------------
1125: -- standard customer user hook post-processing
1126: ----------------------------------------------------------------------------------------------------
1127: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'A', 'C' ) ) then
1128: jtf_ec_cuhk.Create_Escalation_Post(
1129: p_esc_id => l_escalation_id,
1143: end if;
1144:
1145: end if;
1146:
1147: -- Standard check of p_commit.
1148: x_esc_id := l_escalation_id;
1149: x_esc_number := l_escalation_number;
1150: x_workflow_process_id := l_wf_process_id;
1151:
1273: BEGIN
1274:
1275: SAVEPOINT Update_Escalation;
1276:
1277: -- Standard call to check for call compatibility.
1278:
1279: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version,
1280: l_api_name, G_PKG_NAME)
1281: THEN
1292:
1293: x_return_status := FND_API.G_RET_STS_SUCCESS;
1294:
1295: --------------------------------------------------------------------------------------------
1296: -- standard customer user hook pre-processing
1297: --------------------------------------------------------------------------------------------
1298: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'B', 'C' ) ) then
1299: jtf_ec_cuhk.Update_Escalation_Pre(
1300: p_esc_id => l_escalation_id,
1316: end if;
1317:
1318: end if;
1319: --------------------------------------------------------------------------------------------
1320: -- standard verticle industry user hook pre-processing
1321: --------------------------------------------------------------------------------------------
1322: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'B', 'V' ) ) then
1323:
1324: jtf_ec_vuhk.Update_Escalation_Pre(
2245: set workflow_process_id = l_wf_process_id
2246: where task_id = l_escalation_id;
2247:
2248: --------------------------------------------------------------------------------------------
2249: -- standard verticle industry user hook post-processing
2250: --------------------------------------------------------------------------------------------
2251: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'A', 'V' ) ) then
2252:
2253: jtf_ec_vuhk.Update_Escalation_Post(
2271:
2272: end if;
2273:
2274: --------------------------------------------------------------------------------------------
2275: -- standard customer user hook post-processing
2276: --------------------------------------------------------------------------------------------
2277: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'A', 'C' ) ) then
2278: jtf_ec_cuhk.Update_Escalation_Post(
2279: p_esc_id => l_escalation_id,
2298:
2299: x_object_version_number :=l_object_version_number;
2300: x_workflow_process_id := l_wf_process_id;
2301:
2302: -- Standard check of p_commit.
2303:
2304: IF FND_API.To_Boolean( p_commit ) THEN
2305: COMMIT WORK;
2306: END IF;
2373: BEGIN
2374:
2375: SAVEPOINT Delete_Escalation;
2376:
2377: -- Standard call to check for call compatibility.
2378:
2379:
2380: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2381: p_api_version,
2395:
2396: x_return_status := FND_API.G_RET_STS_SUCCESS;
2397:
2398: --------------------------------------------------------------------------------------------
2399: -- standard customer user hook pre-processing
2400: --------------------------------------------------------------------------------------------
2401: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'B', 'C' ) ) then
2402:
2403: jtf_ec_cuhk.Delete_Escalation_Pre(
2415: end if;
2416:
2417: end if;
2418: --------------------------------------------------------------------------------------------
2419: -- standard verticle industry user hook pre-processing
2420: --------------------------------------------------------------------------------------------
2421: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'B', 'V' ) ) then
2422:
2423: jtf_ec_vuhk.Delete_Escalation_Pre(
2505: raise fnd_api.g_exc_unexpected_error;
2506: end if;
2507:
2508: --------------------------------------------------------------------------------------------
2509: -- standard verticle industry user hook post-processing
2510: --------------------------------------------------------------------------------------------
2511: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'A', 'V' ) ) then
2512:
2513: jtf_ec_vuhk.Delete_Escalation_Post(
2526:
2527: end if;
2528:
2529: --------------------------------------------------------------------------------------------
2530: -- standard customer user hook post-processing
2531: --------------------------------------------------------------------------------------------
2532:
2533: if ( jtf_usr_hks.ok_to_execute( g_pkg_name, l_api_name, 'A', 'C' ) ) then
2534:
2547: end if;
2548:
2549: end if;
2550:
2551: -- Standard check of p_commit.
2552:
2553: IF FND_API.To_Boolean( p_commit ) THEN
2554: COMMIT WORK;
2555: END IF;