[Home] [Help]
51: x_line_number NUMBER;
52: x_cost_id NUMBER; -- swai: 12.1 Service costing uptake bug 6960295
53:
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT process_estimate_lines;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
54: BEGIN
55: -- Standard Start of API savepoint
56: SAVEPOINT process_estimate_lines;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
60: p_api_version,
61: l_api_name,
62: G_PKG_NAME)
247:
248: END IF;
249:
250: -- Api body ends here
251: -- Standard check of p_commit.
252: IF Fnd_Api.To_Boolean(p_commit)
253: THEN
254: COMMIT WORK;
255: END IF;
253: THEN
254: COMMIT WORK;
255: END IF;
256:
257: -- Standard call to get message count and IF count is get message info.
258: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
259: p_data => x_msg_data);
260: EXCEPTION
261: WHEN Fnd_Api.G_EXC_ERROR THEN
315: Csd_Gen_Utility_Pvt.ADD('Inside UPDATE_RO_GROUP_ESTIMATE Procedure p_repair_line_id =' ||
316: p_repair_line_id);
317: END IF;
318:
319: -- Standard Start of API savepoint
320: SAVEPOINT UPDATE_RO_GROUP_ESTIMATE;
321:
322: -- Standard call to check for call compatibility.
323: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
318:
319: -- Standard Start of API savepoint
320: SAVEPOINT UPDATE_RO_GROUP_ESTIMATE;
321:
322: -- Standard call to check for call compatibility.
323: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
324: p_api_version,
325: l_api_name,
326: G_PKG_NAME)
551: END IF;
552:
553: -- Api body ends here
554:
555: -- Standard check of p_commit.
556: IF Fnd_Api.To_Boolean(p_commit)
557: THEN
558: COMMIT WORK;
559: END IF;
557: THEN
558: COMMIT WORK;
559: END IF;
560:
561: -- Standard call to get message count and IF count is get message info.
562: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
563: p_data => x_msg_data);
564:
565: END IF;
615: l_api_return_status VARCHAR2(3);
616: l_group_obj_ver_num NUMBER;
617:
618: BEGIN
619: -- Standard Start of API savepoint
620: SAVEPOINT create_repair_estimate;
621:
622: -- Standard call to check for call compatibility.
623: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
618: BEGIN
619: -- Standard Start of API savepoint
620: SAVEPOINT create_repair_estimate;
621:
622: -- Standard call to check for call compatibility.
623: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
624: p_api_version,
625: l_api_name,
626: G_PKG_NAME)
824: END IF;
825:
826: END IF;
827:
828: -- Standard check of p_commit.
829: IF Fnd_Api.To_Boolean(p_commit)
830: THEN
831: COMMIT WORK;
832: END IF;
830: THEN
831: COMMIT WORK;
832: END IF;
833:
834: -- Standard call to get message count and IF count is get message info.
835: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
836: p_data => x_msg_data);
837: EXCEPTION
838: WHEN Fnd_Api.G_EXC_ERROR THEN
893: WHERE a.repair_line_id = b.repair_line_id
894: AND a.repair_estimate_id = p_est_id;
895:
896: BEGIN
897: -- Standard Start of API savepoint
898: SAVEPOINT update_repair_estimate;
899:
900: -- Standard call to check for call compatibility.
901: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
896: BEGIN
897: -- Standard Start of API savepoint
898: SAVEPOINT update_repair_estimate;
899:
900: -- Standard call to check for call compatibility.
901: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
902: p_api_version,
903: l_api_name,
904: G_PKG_NAME)
1091: END IF;
1092:
1093: END IF;
1094:
1095: -- Standard check of p_commit.
1096: IF Fnd_Api.To_Boolean(p_commit)
1097: THEN
1098: COMMIT WORK;
1099: END IF;
1097: THEN
1098: COMMIT WORK;
1099: END IF;
1100:
1101: -- Standard call to get message count and IF count is get message info.
1102: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1103: p_data => x_msg_data);
1104: EXCEPTION
1105: WHEN Fnd_Api.G_EXC_ERROR THEN
1150: l_approval_status VARCHAR2(1);
1151: l_est_line_count NUMBER;
1152:
1153: BEGIN
1154: -- Standard Start of API savepoint
1155: SAVEPOINT delete_repair_estimate;
1156:
1157: -- Standard call to check for call compatibility.
1158: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1153: BEGIN
1154: -- Standard Start of API savepoint
1155: SAVEPOINT delete_repair_estimate;
1156:
1157: -- Standard call to check for call compatibility.
1158: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1159: p_api_version,
1160: l_api_name,
1161: G_PKG_NAME)
1263: RAISE Fnd_Api.G_EXC_ERROR;
1264: END IF;
1265:
1266: -- Api body ends here
1267: -- Standard check of p_commit.
1268: IF Fnd_Api.To_Boolean(p_commit)
1269: THEN
1270: COMMIT WORK;
1271: END IF;
1269: THEN
1270: COMMIT WORK;
1271: END IF;
1272:
1273: -- Standard call to get message count and IF count is get message info.
1274: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1275: p_data => x_msg_data);
1276: EXCEPTION
1277: WHEN Fnd_Api.G_EXC_ERROR THEN
1316: l_msg_data VARCHAR2(100);
1317: l_msg_index NUMBER;
1318:
1319: BEGIN
1320: -- Standard Start of API savepoint
1321: SAVEPOINT lock_repair_estimate;
1322:
1323: -- Standard call to check for call compatibility.
1324: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1319: BEGIN
1320: -- Standard Start of API savepoint
1321: SAVEPOINT lock_repair_estimate;
1322:
1323: -- Standard call to check for call compatibility.
1324: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1325: p_api_version,
1326: l_api_name,
1327: G_PKG_NAME)
1340:
1341: Csd_Repair_Estimate_Pkg.Lock_Row(p_REPAIR_ESTIMATE_ID => p_estimate_rec.repair_estimate_id,
1342: p_OBJECT_VERSION_NUMBER => p_estimate_rec.OBJECT_VERSION_NUMBER);
1343:
1344: -- Standard check of p_commit.
1345: IF Fnd_Api.To_Boolean(p_commit)
1346: THEN
1347: COMMIT WORK;
1348: END IF;
1346: THEN
1347: COMMIT WORK;
1348: END IF;
1349:
1350: -- Standard call to get message count and IF count is get message info.
1351: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1352: p_data => x_msg_data);
1353: EXCEPTION
1354: WHEN Fnd_Api.G_EXC_ERROR THEN
1425: FROM cs_incidents_all_b
1426: WHERE incident_id = p_incident_id;
1427:
1428: BEGIN
1429: -- Standard Start of API savepoint
1430: SAVEPOINT create_repair_estimate_lines;
1431:
1432: -- Standard call to check for call compatibility.
1433: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1428: BEGIN
1429: -- Standard Start of API savepoint
1430: SAVEPOINT create_repair_estimate_lines;
1431:
1432: -- Standard call to check for call compatibility.
1433: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1434: p_api_version,
1435: l_api_name,
1436: G_PKG_NAME)
1892: x_estimate_line_rec.object_version_number := 1;
1893:
1894: -- Api body ends here
1895:
1896: -- Standard check of p_commit.
1897: IF Fnd_Api.To_Boolean(p_commit)
1898: THEN
1899: COMMIT WORK;
1900: END IF;
1898: THEN
1899: COMMIT WORK;
1900: END IF;
1901:
1902: -- Standard call to get message count and IF count is get message info.
1903: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1904: p_data => x_msg_data);
1905: EXCEPTION
1906: WHEN Fnd_Api.G_EXC_ERROR THEN
1976: FROM CSD_REPAIR_ESTIMATE_LINES
1977: WHERE repair_estimate_line_id = p_est_line_id;
1978:
1979: BEGIN
1980: -- Standard Start of API savepoint
1981: SAVEPOINT update_repair_estimate_lines;
1982:
1983: -- Standard call to check for call compatibility.
1984: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1979: BEGIN
1980: -- Standard Start of API savepoint
1981: SAVEPOINT update_repair_estimate_lines;
1982:
1983: -- Standard call to check for call compatibility.
1984: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
1985: p_api_version,
1986: l_api_name,
1987: G_PKG_NAME)
2289: x_estimate_line_rec.object_version_number := l_obj_ver_num + 1;
2290:
2291: -- Api body ends here
2292:
2293: -- Standard check of p_commit.
2294: IF Fnd_Api.To_Boolean(p_commit)
2295: THEN
2296: COMMIT WORK;
2297: END IF;
2295: THEN
2296: COMMIT WORK;
2297: END IF;
2298:
2299: -- Standard call to get message count and IF count is get message info.
2300: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2301: p_data => x_msg_data);
2302: EXCEPTION
2303: WHEN Fnd_Api.G_EXC_ERROR THEN
2346: l_est_detail_id NUMBER;
2347: l_delete_allow VARCHAR2(1);
2348:
2349: BEGIN
2350: -- Standard Start of API savepoint
2351: SAVEPOINT delete_repair_estimate_lines;
2352:
2353: -- Standard call to check for call compatibility.
2354: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2349: BEGIN
2350: -- Standard Start of API savepoint
2351: SAVEPOINT delete_repair_estimate_lines;
2352:
2353: -- Standard call to check for call compatibility.
2354: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2355: p_api_version,
2356: l_api_name,
2357: G_PKG_NAME)
2479: END IF; --end of delete
2480:
2481: -- Api body ends here
2482:
2483: -- Standard check of p_commit.
2484: IF Fnd_Api.To_Boolean(p_commit)
2485: THEN
2486: COMMIT WORK;
2487: END IF;
2485: THEN
2486: COMMIT WORK;
2487: END IF;
2488:
2489: -- Standard call to get message count and IF count is get message info.
2490: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2491: p_data => x_msg_data);
2492: EXCEPTION
2493: WHEN Fnd_Api.G_EXC_ERROR THEN
2532: l_msg_data VARCHAR2(100);
2533: l_msg_index NUMBER;
2534:
2535: BEGIN
2536: -- Standard Start of API savepoint
2537: SAVEPOINT lock_repair_estimate_lines;
2538:
2539: -- Standard call to check for call compatibility.
2540: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2535: BEGIN
2536: -- Standard Start of API savepoint
2537: SAVEPOINT lock_repair_estimate_lines;
2538:
2539: -- Standard call to check for call compatibility.
2540: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2541: p_api_version,
2542: l_api_name,
2543: G_PKG_NAME)
2556:
2557: Csd_Repair_Estimate_Lines_Pkg.Lock_Row(p_REPAIR_ESTIMATE_LINE_ID => p_estimate_line_rec.repair_estimate_line_id,
2558: p_OBJECT_VERSION_NUMBER => p_estimate_line_rec.object_version_number);
2559:
2560: -- Standard check of p_commit.
2561: IF Fnd_Api.To_Boolean(p_commit)
2562: THEN
2563: COMMIT WORK;
2564: END IF;
2562: THEN
2563: COMMIT WORK;
2564: END IF;
2565:
2566: -- Standard call to get message count and IF count is get message info.
2567: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: EXCEPTION
2570: WHEN Fnd_Api.G_EXC_ERROR THEN
2624: FROM fnd_languages
2625: WHERE language_code = userenv('LANG');
2626: -- valase:6499519 , above
2627: BEGIN
2628: -- Standard Start of API savepoint
2629: SAVEPOINT estimate_print;
2630: -- Standard call to check for call compatibility.
2631: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2632: p_api_version,
2626: -- valase:6499519 , above
2627: BEGIN
2628: -- Standard Start of API savepoint
2629: SAVEPOINT estimate_print;
2630: -- Standard call to check for call compatibility.
2631: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2632: p_api_version,
2633: l_api_name,
2634: G_PKG_NAME)
2751: THEN
2752: COMMIT;
2753: END IF;
2754: x_request_id := l_request_id;
2755: -- Standard check of p_commit.
2756: IF Fnd_Api.To_Boolean(p_commit)
2757: THEN
2758: COMMIT WORK;
2759: END IF;
2756: IF Fnd_Api.To_Boolean(p_commit)
2757: THEN
2758: COMMIT WORK;
2759: END IF;
2760: -- Standard call to get message count and IF count is get message info.
2761: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2762: p_data => x_msg_data);
2763: EXCEPTION
2764: WHEN Fnd_Api.G_EXC_ERROR THEN
2823: AND ced.interface_to_oe_flag = 'N';
2824:
2825: BEGIN
2826:
2827: -- Standard Start of API savepoint
2828: SAVEPOINT submit_estimate_lines;
2829:
2830: -- Standard call to check for call compatibility.
2831: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2826:
2827: -- Standard Start of API savepoint
2828: SAVEPOINT submit_estimate_lines;
2829:
2830: -- Standard call to check for call compatibility.
2831: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
2832: p_api_version,
2833: l_api_name,
2834: G_PKG_NAME)
3040: Csd_Gen_Utility_Pvt.ADD('Estimate not interfaced to OM ');
3041: END IF;
3042: END;
3043:
3044: -- Standard check of p_commit.
3045: IF Fnd_Api.To_Boolean(p_commit)
3046: THEN
3047: COMMIT WORK;
3048: END IF;
3046: THEN
3047: COMMIT WORK;
3048: END IF;
3049:
3050: -- Standard call to get message count and IF count is get message info.
3051: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3052: p_data => x_msg_data);
3053: EXCEPTION
3054: WHEN Fnd_Api.G_EXC_ERROR THEN
3207: FROM CSD_RO_SERVICE_CODES
3208: WHERE ro_service_code_id = p_ro_service_code_id;
3209:
3210: BEGIN
3211: -- Standard Start of API savepoint
3212: SAVEPOINT Autocreate_Estimate_Lines;
3213:
3214: -- Standard call to check for call compatibility.
3215: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
3210: BEGIN
3211: -- Standard Start of API savepoint
3212: SAVEPOINT Autocreate_Estimate_Lines;
3213:
3214: -- Standard call to check for call compatibility.
3215: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
3216: p_api_version,
3217: lc_api_name,
3218: G_PKG_NAME)
3817: --
3818: -- End API Body
3819: --
3820:
3821: -- Standard check of p_commit.
3822: IF Fnd_Api.To_Boolean(p_commit)
3823: THEN
3824: COMMIT WORK;
3825: END IF;
3823: THEN
3824: COMMIT WORK;
3825: END IF;
3826:
3827: -- Standard call to get message count and IF count is get message info.
3828: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3829: p_data => x_msg_data);
3830:
3831: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4607: AND x.task_template_id = y.task_template_id
4608: AND y.task_group_id = SetLinkTG.other_id);
4609:
4610: BEGIN
4611: -- Standard Start of API savepoint
4612: SAVEPOINT Get_Estimates_From_Task;
4613:
4614: -- Standard call to check for call compatibility.
4615: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
4610: BEGIN
4611: -- Standard Start of API savepoint
4612: SAVEPOINT Get_Estimates_From_Task;
4613:
4614: -- Standard call to check for call compatibility.
4615: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
4616: p_api_version,
4617: lc_api_name,
4618: G_PKG_NAME)
5157: --
5158: -- End API Body
5159: --
5160:
5161: -- Standard check of p_commit.
5162: IF Fnd_Api.To_Boolean(p_commit)
5163: THEN
5164: COMMIT WORK;
5165: END IF;
5163: THEN
5164: COMMIT WORK;
5165: END IF;
5166:
5167: -- Standard call to get message count and IF count is get message info.
5168: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5169: p_data => x_msg_data);
5170: EXCEPTION
5171: WHEN CSD_EST_NO_AUTOGEN THEN
5552: AND SAR.txn_billing_type_id = RTSAR.txn_billing_type_id(+)
5553: AND SAR.billing_type = MTL.material_billable_flag(+);
5554:
5555: BEGIN
5556: -- Standard Start of API savepoint
5557: SAVEPOINT Get_Estimates_From_BOM;
5558:
5559: -- Standard call to check for call compatibility.
5560: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
5555: BEGIN
5556: -- Standard Start of API savepoint
5557: SAVEPOINT Get_Estimates_From_BOM;
5558:
5559: -- Standard call to check for call compatibility.
5560: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
5561: p_api_version,
5562: lc_api_name,
5563: G_PKG_NAME)
5845: --
5846: -- End API Body
5847: --
5848:
5849: -- Standard check of p_commit.
5850: IF Fnd_Api.To_Boolean(p_commit)
5851: THEN
5852: COMMIT WORK;
5853: END IF;
5851: THEN
5852: COMMIT WORK;
5853: END IF;
5854:
5855: -- Standard call to get message count and IF count is get message info.
5856: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5857: p_data => x_msg_data);
5858: EXCEPTION
5859: WHEN CSD_EST_NO_AUTOGEN THEN
6042: FROM cs_txn_billing_types cs
6043: WHERE cs.txn_billing_type_id = p_txn_billing_type_id;
6044:
6045: BEGIN
6046: -- Standard Start of API savepoint
6047: SAVEPOINT Convert_To_Est_Lines;
6048:
6049: -- Standard call to check for call compatibility.
6050: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
6045: BEGIN
6046: -- Standard Start of API savepoint
6047: SAVEPOINT Convert_To_Est_Lines;
6048:
6049: -- Standard call to check for call compatibility.
6050: IF NOT Fnd_Api.Compatible_API_Call(lc_api_version,
6051: p_api_version,
6052: lc_api_name,
6053: G_PKG_NAME)
6679: --
6680: -- End API Body
6681: --
6682:
6683: -- Standard check of p_commit.
6684: IF Fnd_Api.To_Boolean(p_commit)
6685: THEN
6686: COMMIT WORK;
6687: END IF;
6685: THEN
6686: COMMIT WORK;
6687: END IF;
6688:
6689: -- Standard call to get message count and IF count is get message info.
6690: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6691: p_data => x_msg_data);
6692: EXCEPTION
6693: WHEN Fnd_Api.G_EXC_ERROR THEN
6818: Fnd_Log.STRING(Fnd_Log.level_procedure,
6819: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.begin',
6820: 'Entering create_estimate_header');
6821: END IF;
6822: -- Standard Start of API savepoint
6823: SAVEPOINT CREATE_ESTIMATE_HEADER_PVT;
6824:
6825: -- Standard call to check for call compatibility.
6826: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6821: END IF;
6822: -- Standard Start of API savepoint
6823: SAVEPOINT CREATE_ESTIMATE_HEADER_PVT;
6824:
6825: -- Standard call to check for call compatibility.
6826: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
6827: p_api_version,
6828: l_api_name,
6829: G_PKG_NAME)
6921: l_msg_data || ']');
6922: RAISE Fnd_Api.G_EXC_ERROR;
6923: END IF;
6924:
6925: -- Standard check of p_commit.
6926: IF Fnd_Api.To_Boolean(p_commit)
6927: THEN
6928: COMMIT WORK;
6929: END IF;
6934: 'csd.plsql.csd_repair_Estimate_pvt.create_estimate_header.end',
6935: 'Leaving create_estimate_header');
6936: END IF;
6937:
6938: -- Standard call to get message count and IF count is get message info.
6939: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6940: p_data => x_msg_data);
6941: EXCEPTION
6942: WHEN Fnd_Api.G_EXC_ERROR THEN
7011: l_estimate_line_rec Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC;
7012:
7013: BEGIN
7014:
7015: -- Standard Start of API savepoint
7016: SAVEPOINT CREATE_ESTIMATE_LINE_PVT;
7017:
7018: -- Standard call to check for call compatibility.
7019: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7014:
7015: -- Standard Start of API savepoint
7016: SAVEPOINT CREATE_ESTIMATE_LINE_PVT;
7017:
7018: -- Standard call to check for call compatibility.
7019: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7020: p_api_version,
7021: l_api_name,
7022: G_PKG_NAME)
7073: debug('create estimate_lines failed..');
7074: RAISE Fnd_Api.G_EXC_ERROR;
7075: END IF;
7076:
7077: -- Standard check of p_commit.
7078: IF Fnd_Api.To_Boolean(p_commit)
7079: THEN
7080: COMMIT WORK;
7081: END IF;
7079: THEN
7080: COMMIT WORK;
7081: END IF;
7082:
7083: -- Standard call to get message count and IF count is get message info.
7084: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7085: p_data => x_msg_data);
7086:
7087: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
7197: FROM CSD_REPAIR_ESTIMATE
7198: WHERE REPAIR_ESTIMATE_ID = p_estimate_header_id;
7199:
7200: BEGIN
7201: -- Standard Start of API savepoint
7202: SAVEPOINT UPDATE_ESTIMATE_HEADER_PVT;
7203:
7204: -- Standard call to check for call compatibility.
7205: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7200: BEGIN
7201: -- Standard Start of API savepoint
7202: SAVEPOINT UPDATE_ESTIMATE_HEADER_PVT;
7203:
7204: -- Standard call to check for call compatibility.
7205: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
7206: p_api_version,
7207: l_api_name,
7208: G_PKG_NAME)
7347: l_msg_data || ']');
7348: RAISE Fnd_Api.G_EXC_ERROR;
7349: END IF;
7350:
7351: -- Standard check of p_commit.
7352: IF Fnd_Api.To_Boolean(p_commit)
7353: THEN
7354: COMMIT WORK;
7355: END IF;
7353: THEN
7354: COMMIT WORK;
7355: END IF;
7356:
7357: -- Standard call to get message count and IF count is get message info.
7358: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7359: p_data => x_msg_data);
7360:
7361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)