[Home] [Help]
62: x_line_number NUMBER;
63: x_cost_id NUMBER; -- swai: 12.1 Service costing uptake bug 6960295
64:
65: BEGIN
66: -- Standard Start of API savepoint
67: SAVEPOINT process_estimate_lines;
68:
69: -- Standard call to check for call compatibility.
70: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
65: BEGIN
66: -- Standard Start of API savepoint
67: SAVEPOINT process_estimate_lines;
68:
69: -- Standard call to check for call compatibility.
70: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
71: p_api_version,
72: l_api_name,
73: G_PKG_NAME)
258:
259: END IF;
260:
261: -- Api body ends here
262: -- Standard check of p_commit.
263: IF Fnd_Api.To_Boolean(p_commit)
264: THEN
265: COMMIT WORK;
266: END IF;
264: THEN
265: COMMIT WORK;
266: END IF;
267:
268: -- Standard call to get message count and IF count is get message info.
269: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
270: p_data => x_msg_data);
271: EXCEPTION
272: WHEN Fnd_Api.G_EXC_ERROR THEN
326: Csd_Gen_Utility_Pvt.ADD('Inside UPDATE_RO_GROUP_ESTIMATE Procedure p_repair_line_id =' ||
327: p_repair_line_id);
328: END IF;
329:
330: -- Standard Start of API savepoint
331: SAVEPOINT UPDATE_RO_GROUP_ESTIMATE;
332:
333: -- Standard call to check for call compatibility.
334: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
329:
330: -- Standard Start of API savepoint
331: SAVEPOINT UPDATE_RO_GROUP_ESTIMATE;
332:
333: -- Standard call to check for call compatibility.
334: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
335: p_api_version,
336: l_api_name,
337: G_PKG_NAME)
562: END IF;
563:
564: -- Api body ends here
565:
566: -- Standard check of p_commit.
567: IF Fnd_Api.To_Boolean(p_commit)
568: THEN
569: COMMIT WORK;
570: END IF;
568: THEN
569: COMMIT WORK;
570: END IF;
571:
572: -- Standard call to get message count and IF count is get message info.
573: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
574: p_data => x_msg_data);
575:
576: END IF;
626: l_api_return_status VARCHAR2(3);
627: l_group_obj_ver_num NUMBER;
628:
629: BEGIN
630: -- Standard Start of API savepoint
631: SAVEPOINT create_repair_estimate;
632:
633: -- Standard call to check for call compatibility.
634: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
629: BEGIN
630: -- Standard Start of API savepoint
631: SAVEPOINT create_repair_estimate;
632:
633: -- Standard call to check for call compatibility.
634: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
635: p_api_version,
636: l_api_name,
637: G_PKG_NAME)
835: END IF;
836:
837: END IF;
838:
839: -- Standard check of p_commit.
840: IF Fnd_Api.To_Boolean(p_commit)
841: THEN
842: COMMIT WORK;
843: END IF;
841: THEN
842: COMMIT WORK;
843: END IF;
844:
845: -- Standard call to get message count and IF count is get message info.
846: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
847: p_data => x_msg_data);
848: EXCEPTION
849: WHEN Fnd_Api.G_EXC_ERROR THEN
904: WHERE a.repair_line_id = b.repair_line_id
905: AND a.repair_estimate_id = p_est_id;
906:
907: BEGIN
908: -- Standard Start of API savepoint
909: SAVEPOINT update_repair_estimate;
910:
911: -- Standard call to check for call compatibility.
912: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
907: BEGIN
908: -- Standard Start of API savepoint
909: SAVEPOINT update_repair_estimate;
910:
911: -- Standard call to check for call compatibility.
912: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
913: p_api_version,
914: l_api_name,
915: G_PKG_NAME)
1102: END IF;
1103:
1104: END IF;
1105:
1106: -- Standard check of p_commit.
1107: IF Fnd_Api.To_Boolean(p_commit)
1108: THEN
1109: COMMIT WORK;
1110: END IF;
1108: THEN
1109: COMMIT WORK;
1110: END IF;
1111:
1112: -- Standard call to get message count and IF count is get message info.
1113: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1114: p_data => x_msg_data);
1115: EXCEPTION
1116: WHEN Fnd_Api.G_EXC_ERROR THEN
1161: l_approval_status VARCHAR2(1);
1162: l_est_line_count NUMBER;
1163:
1164: BEGIN
1165: -- Standard Start of API savepoint
1166: SAVEPOINT delete_repair_estimate;
1167:
1168: -- Standard call to check for call compatibility.
1169: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1164: BEGIN
1165: -- Standard Start of API savepoint
1166: SAVEPOINT delete_repair_estimate;
1167:
1168: -- Standard call to check for call compatibility.
1169: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1170: p_api_version,
1171: l_api_name,
1172: G_PKG_NAME)
1274: RAISE Fnd_Api.G_EXC_ERROR;
1275: END IF;
1276:
1277: -- Api body ends here
1278: -- Standard check of p_commit.
1279: IF Fnd_Api.To_Boolean(p_commit)
1280: THEN
1281: COMMIT WORK;
1282: END IF;
1280: THEN
1281: COMMIT WORK;
1282: END IF;
1283:
1284: -- Standard call to get message count and IF count is get message info.
1285: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1286: p_data => x_msg_data);
1287: EXCEPTION
1288: WHEN Fnd_Api.G_EXC_ERROR THEN
1327: l_msg_data VARCHAR2(100);
1328: l_msg_index NUMBER;
1329:
1330: BEGIN
1331: -- Standard Start of API savepoint
1332: SAVEPOINT lock_repair_estimate;
1333:
1334: -- Standard call to check for call compatibility.
1335: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1330: BEGIN
1331: -- Standard Start of API savepoint
1332: SAVEPOINT lock_repair_estimate;
1333:
1334: -- Standard call to check for call compatibility.
1335: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1336: p_api_version,
1337: l_api_name,
1338: G_PKG_NAME)
1351:
1352: Csd_Repair_Estimate_Pkg.Lock_Row(p_REPAIR_ESTIMATE_ID => p_estimate_rec.repair_estimate_id,
1353: p_OBJECT_VERSION_NUMBER => p_estimate_rec.OBJECT_VERSION_NUMBER);
1354:
1355: -- Standard check of p_commit.
1356: IF Fnd_Api.To_Boolean(p_commit)
1357: THEN
1358: COMMIT WORK;
1359: END IF;
1357: THEN
1358: COMMIT WORK;
1359: END IF;
1360:
1361: -- Standard call to get message count and IF count is get message info.
1362: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1363: p_data => x_msg_data);
1364: EXCEPTION
1365: WHEN Fnd_Api.G_EXC_ERROR THEN
1436: FROM cs_incidents_all_b
1437: WHERE incident_id = p_incident_id;
1438:
1439: BEGIN
1440: -- Standard Start of API savepoint
1441: SAVEPOINT create_repair_estimate_lines;
1442:
1443: -- Standard call to check for call compatibility.
1444: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1439: BEGIN
1440: -- Standard Start of API savepoint
1441: SAVEPOINT create_repair_estimate_lines;
1442:
1443: -- Standard call to check for call compatibility.
1444: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1445: p_api_version,
1446: l_api_name,
1447: G_PKG_NAME)
1903: x_estimate_line_rec.object_version_number := 1;
1904:
1905: -- Api body ends here
1906:
1907: -- Standard check of p_commit.
1908: IF Fnd_Api.To_Boolean(p_commit)
1909: THEN
1910: COMMIT WORK;
1911: END IF;
1909: THEN
1910: COMMIT WORK;
1911: END IF;
1912:
1913: -- Standard call to get message count and IF count is get message info.
1914: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1915: p_data => x_msg_data);
1916: EXCEPTION
1917: WHEN Fnd_Api.G_EXC_ERROR THEN
1987: FROM CSD_REPAIR_ESTIMATE_LINES
1988: WHERE repair_estimate_line_id = p_est_line_id;
1989:
1990: BEGIN
1991: -- Standard Start of API savepoint
1992: SAVEPOINT update_repair_estimate_lines;
1993:
1994: -- Standard call to check for call compatibility.
1995: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1990: BEGIN
1991: -- Standard Start of API savepoint
1992: SAVEPOINT update_repair_estimate_lines;
1993:
1994: -- Standard call to check for call compatibility.
1995: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1996: p_api_version,
1997: l_api_name,
1998: G_PKG_NAME)
2300: x_estimate_line_rec.object_version_number := l_obj_ver_num + 1;
2301:
2302: -- Api body ends here
2303:
2304: -- Standard check of p_commit.
2305: IF Fnd_Api.To_Boolean(p_commit)
2306: THEN
2307: COMMIT WORK;
2308: END IF;
2306: THEN
2307: COMMIT WORK;
2308: END IF;
2309:
2310: -- Standard call to get message count and IF count is get message info.
2311: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2312: p_data => x_msg_data);
2313: EXCEPTION
2314: WHEN Fnd_Api.G_EXC_ERROR THEN
2357: l_est_detail_id NUMBER;
2358: l_delete_allow VARCHAR2(1);
2359:
2360: BEGIN
2361: -- Standard Start of API savepoint
2362: SAVEPOINT delete_repair_estimate_lines;
2363:
2364: -- Standard call to check for call compatibility.
2365: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2360: BEGIN
2361: -- Standard Start of API savepoint
2362: SAVEPOINT delete_repair_estimate_lines;
2363:
2364: -- Standard call to check for call compatibility.
2365: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2366: p_api_version,
2367: l_api_name,
2368: G_PKG_NAME)
2490: END IF; --end of delete
2491:
2492: -- Api body ends here
2493:
2494: -- Standard check of p_commit.
2495: IF Fnd_Api.To_Boolean(p_commit)
2496: THEN
2497: COMMIT WORK;
2498: END IF;
2496: THEN
2497: COMMIT WORK;
2498: END IF;
2499:
2500: -- Standard call to get message count and IF count is get message info.
2501: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2502: p_data => x_msg_data);
2503: EXCEPTION
2504: WHEN Fnd_Api.G_EXC_ERROR THEN
2543: l_msg_data VARCHAR2(100);
2544: l_msg_index NUMBER;
2545:
2546: BEGIN
2547: -- Standard Start of API savepoint
2548: SAVEPOINT lock_repair_estimate_lines;
2549:
2550: -- Standard call to check for call compatibility.
2551: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2546: BEGIN
2547: -- Standard Start of API savepoint
2548: SAVEPOINT lock_repair_estimate_lines;
2549:
2550: -- Standard call to check for call compatibility.
2551: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2552: p_api_version,
2553: l_api_name,
2554: G_PKG_NAME)
2567:
2568: Csd_Repair_Estimate_Lines_Pkg.Lock_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_rec.repair_estimate_line_id,
2569: p_OBJECT_VERSION_NUMBER => p_estimate_line_rec.object_version_number);
2570:
2571: -- Standard check of p_commit.
2572: IF Fnd_Api.To_Boolean(p_commit)
2573: THEN
2574: COMMIT WORK;
2575: END IF;
2573: THEN
2574: COMMIT WORK;
2575: END IF;
2576:
2577: -- Standard call to get message count and IF count is get message info.
2578: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2579: p_data => x_msg_data);
2580: EXCEPTION
2581: WHEN Fnd_Api.G_EXC_ERROR THEN
2635: FROM fnd_languages
2636: WHERE language_code = userenv('LANG');
2637: -- valase:6499519 , above
2638: BEGIN
2639: -- Standard Start of API savepoint
2640: SAVEPOINT estimate_print;
2641: -- Standard call to check for call compatibility.
2642: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2643: p_api_version,
2637: -- valase:6499519 , above
2638: BEGIN
2639: -- Standard Start of API savepoint
2640: SAVEPOINT estimate_print;
2641: -- Standard call to check for call compatibility.
2642: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2643: p_api_version,
2644: l_api_name,
2645: G_PKG_NAME)
2762: THEN
2763: COMMIT;
2764: END IF;
2765: x_request_id := l_request_id;
2766: -- Standard check of p_commit.
2767: IF Fnd_Api.To_Boolean(p_commit)
2768: THEN
2769: COMMIT WORK;
2770: END IF;
2767: IF Fnd_Api.To_Boolean(p_commit)
2768: THEN
2769: COMMIT WORK;
2770: END IF;
2771: -- Standard call to get message count and IF count is get message info.
2772: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2773: p_data => x_msg_data);
2774: EXCEPTION
2775: WHEN Fnd_Api.G_EXC_ERROR THEN
2834: AND ced.interface_to_oe_flag = 'N';
2835:
2836: BEGIN
2837:
2838: -- Standard Start of API savepoint
2839: SAVEPOINT submit_estimate_lines;
2840:
2841: -- Standard call to check for call compatibility.
2842: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2837:
2838: -- Standard Start of API savepoint
2839: SAVEPOINT submit_estimate_lines;
2840:
2841: -- Standard call to check for call compatibility.
2842: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2843: p_api_version,
2844: l_api_name,
2845: G_PKG_NAME)
3051: Csd_Gen_Utility_Pvt.ADD('Estimate not interfaced to OM ');
3052: END IF;
3053: END;
3054:
3055: -- Standard check of p_commit.
3056: IF Fnd_Api.To_Boolean(p_commit)
3057: THEN
3058: COMMIT WORK;
3059: END IF;
3057: THEN
3058: COMMIT WORK;
3059: END IF;
3060:
3061: -- Standard call to get message count and IF count is get message info.
3062: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3063: p_data => x_msg_data);
3064: EXCEPTION
3065: WHEN Fnd_Api.G_EXC_ERROR THEN
3229: WHERE repair_line_id = p_repair_line_id;
3230: --bug#11902612
3231:
3232: BEGIN
3233: -- Standard Start of API savepoint
3234: SAVEPOINT Autocreate_Estimate_Lines;
3235:
3236: -- Standard call to check for call compatibility.
3237: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
3232: BEGIN
3233: -- Standard Start of API savepoint
3234: SAVEPOINT Autocreate_Estimate_Lines;
3235:
3236: -- Standard call to check for call compatibility.
3237: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
3238: p_api_version,
3239: lc_api_name,
3240: G_PKG_NAME)
3851: --
3852: -- End API Body
3853: --
3854:
3855: -- Standard check of p_commit.
3856: IF Fnd_Api.To_Boolean(p_commit)
3857: THEN
3858: COMMIT WORK;
3859: END IF;
3857: THEN
3858: COMMIT WORK;
3859: END IF;
3860:
3861: -- Standard call to get message count and IF count is get message info.
3862: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3863: p_data => x_msg_data);
3864:
3865: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4641: AND x.task_template_id = y.task_template_id
4642: AND y.task_group_id = SetLinkTG.other_id);
4643:
4644: BEGIN
4645: -- Standard Start of API savepoint
4646: SAVEPOINT Get_Estimates_From_Task;
4647:
4648: -- Standard call to check for call compatibility.
4649: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
4644: BEGIN
4645: -- Standard Start of API savepoint
4646: SAVEPOINT Get_Estimates_From_Task;
4647:
4648: -- Standard call to check for call compatibility.
4649: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
4650: p_api_version,
4651: lc_api_name,
4652: G_PKG_NAME)
5191: --
5192: -- End API Body
5193: --
5194:
5195: -- Standard check of p_commit.
5196: IF Fnd_Api.To_Boolean(p_commit)
5197: THEN
5198: COMMIT WORK;
5199: END IF;
5197: THEN
5198: COMMIT WORK;
5199: END IF;
5200:
5201: -- Standard call to get message count and IF count is get message info.
5202: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5203: p_data => x_msg_data);
5204: EXCEPTION
5205: WHEN CSD_EST_NO_AUTOGEN THEN
5586: AND SAR.txn_billing_type_id = RTSAR.txn_billing_type_id(+)
5587: AND SAR.billing_type = MTL.material_billable_flag(+);
5588:
5589: BEGIN
5590: -- Standard Start of API savepoint
5591: SAVEPOINT Get_Estimates_From_BOM;
5592:
5593: -- Standard call to check for call compatibility.
5594: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
5589: BEGIN
5590: -- Standard Start of API savepoint
5591: SAVEPOINT Get_Estimates_From_BOM;
5592:
5593: -- Standard call to check for call compatibility.
5594: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
5595: p_api_version,
5596: lc_api_name,
5597: G_PKG_NAME)
5879: --
5880: -- End API Body
5881: --
5882:
5883: -- Standard check of p_commit.
5884: IF Fnd_Api.To_Boolean(p_commit)
5885: THEN
5886: COMMIT WORK;
5887: END IF;
5885: THEN
5886: COMMIT WORK;
5887: END IF;
5888:
5889: -- Standard call to get message count and IF count is get message info.
5890: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5891: p_data => x_msg_data);
5892: EXCEPTION
5893: WHEN CSD_EST_NO_AUTOGEN THEN
6076: FROM cs_txn_billing_types cs
6077: WHERE cs.txn_billing_type_id = p_txn_billing_type_id;
6078:
6079: BEGIN
6080: -- Standard Start of API savepoint
6081: SAVEPOINT Convert_To_Est_Lines;
6082:
6083: -- Standard call to check for call compatibility.
6084: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
6079: BEGIN
6080: -- Standard Start of API savepoint
6081: SAVEPOINT Convert_To_Est_Lines;
6082:
6083: -- Standard call to check for call compatibility.
6084: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
6085: p_api_version,
6086: lc_api_name,
6087: G_PKG_NAME)
6713: --
6714: -- End API Body
6715: --
6716:
6717: -- Standard check of p_commit.
6718: IF Fnd_Api.To_Boolean(p_commit)
6719: THEN
6720: COMMIT WORK;
6721: END IF;
6719: THEN
6720: COMMIT WORK;
6721: END IF;
6722:
6723: -- Standard call to get message count and IF count is get message info.
6724: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6725: p_data => x_msg_data);
6726: EXCEPTION
6727: WHEN Fnd_Api.G_EXC_ERROR THEN
6852: Fnd_Log.STRING(Fnd_Log.level_procedure,
6853: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.begin',
6854: 'Entering create_estimate_header');
6855: END IF;
6856: -- Standard Start of API savepoint
6857: SAVEPOINT CREATE_ESTIMATE_HEADER_PVT;
6858:
6859: -- Standard call to check for call compatibility.
6860: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6855: END IF;
6856: -- Standard Start of API savepoint
6857: SAVEPOINT CREATE_ESTIMATE_HEADER_PVT;
6858:
6859: -- Standard call to check for call compatibility.
6860: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6861: p_api_version,
6862: l_api_name,
6863: G_PKG_NAME)
6955: l_msg_data || ']');
6956: RAISE Fnd_Api.G_EXC_ERROR;
6957: END IF;
6958:
6959: -- Standard check of p_commit.
6960: IF Fnd_Api.To_Boolean(p_commit)
6961: THEN
6962: COMMIT WORK;
6963: END IF;
6968: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',
6969: 'Leaving create_estimate_header');
6970: END IF;
6971:
6972: -- Standard call to get message count and IF count is get message info.
6973: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6974: p_data => x_msg_data);
6975: EXCEPTION
6976: WHEN Fnd_Api.G_EXC_ERROR THEN
7045: l_estimate_line_rec Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC;
7046:
7047: BEGIN
7048:
7049: -- Standard Start of API savepoint
7050: SAVEPOINT CREATE_ESTIMATE_LINE_PVT;
7051:
7052: -- Standard call to check for call compatibility.
7053: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7048:
7049: -- Standard Start of API savepoint
7050: SAVEPOINT CREATE_ESTIMATE_LINE_PVT;
7051:
7052: -- Standard call to check for call compatibility.
7053: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7054: p_api_version,
7055: l_api_name,
7056: G_PKG_NAME)
7110: debug('create estimate_lines failed..');
7111: RAISE Fnd_Api.G_EXC_ERROR;
7112: END IF;
7113:
7114: -- Standard check of p_commit.
7115: IF Fnd_Api.To_Boolean(p_commit)
7116: THEN
7117: COMMIT WORK;
7118: END IF;
7116: THEN
7117: COMMIT WORK;
7118: END IF;
7119:
7120: -- Standard call to get message count and IF count is get message info.
7121: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7122: p_data => x_msg_data);
7123:
7124: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7235: FROM CSD_REPAIR_ESTIMATE
7236: WHERE REPAIR_ESTIMATE_ID = p_estimate_header_id;
7237:
7238: BEGIN
7239: -- Standard Start of API savepoint
7240: SAVEPOINT UPDATE_ESTIMATE_HEADER_PVT;
7241:
7242: -- Standard call to check for call compatibility.
7243: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7238: BEGIN
7239: -- Standard Start of API savepoint
7240: SAVEPOINT UPDATE_ESTIMATE_HEADER_PVT;
7241:
7242: -- Standard call to check for call compatibility.
7243: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7244: p_api_version,
7245: l_api_name,
7246: G_PKG_NAME)
7401: l_msg_data || ']');
7402: RAISE Fnd_Api.G_EXC_ERROR;
7403: END IF;
7404:
7405: -- Standard check of p_commit.
7406: IF Fnd_Api.To_Boolean(p_commit)
7407: THEN
7408: COMMIT WORK;
7409: END IF;
7407: THEN
7408: COMMIT WORK;
7409: END IF;
7410:
7411: -- Standard call to get message count and IF count is get message info.
7412: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7413: p_data => x_msg_data);
7414:
7415: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7812: AND WOR.RESOURCE_SEQ_NUM = WTD. RESOURCE_SEQ_NUM(+)
7813: ORDER BY RES.billable_item_id;
7814: BEGIN
7815:
7816: -- Standard Start of API savepoint
7817: SAVEPOINT Import_Estimates_wip_sp;
7818:
7819: -- Standard call to check for call compatibility.
7820: IF NOT FND_API.Compatible_API_Call( lc_api_version,
7815:
7816: -- Standard Start of API savepoint
7817: SAVEPOINT Import_Estimates_wip_sp;
7818:
7819: -- Standard call to check for call compatibility.
7820: IF NOT FND_API.Compatible_API_Call( lc_api_version,
7821: p_api_version,
7822: lc_api_name,
7823: G_PKG_NAME ) THEN
8565: --
8566: -- End API Body
8567: --
8568:
8569: -- Standard check of p_commit.
8570: IF FND_API.To_Boolean( p_commit ) THEN
8571: COMMIT WORK;
8572: END IF;
8573: