[Home] [Help]
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF Fnd_Api.to_Boolean(p_init_msg_list)
80: THEN
81: Fnd_Msg_Pub.initialize;
82: END IF;
83:
84: -- Initialize API return status to success
85: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
252: END IF;
253:
254: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ACTION');
255: Fnd_Message.SET_TOKEN('ACTION', p_action);
256: Fnd_Msg_Pub.ADD;
257: RAISE Fnd_Api.G_EXC_ERROR;
258:
259: END IF;
260:
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
273: ROLLBACK TO process_estimate_lines;
271: EXCEPTION
272: WHEN Fnd_Api.G_EXC_ERROR THEN
273: ROLLBACK TO process_estimate_lines;
274: x_return_status := Fnd_Api.G_RET_STS_ERROR;
275: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
276: p_data => x_msg_data);
277: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
278: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
279: ROLLBACK TO process_estimate_lines;
276: p_data => x_msg_data);
277: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
278: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
279: ROLLBACK TO process_estimate_lines;
280: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
281: p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
284: ROLLBACK TO process_estimate_lines;
281: p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
284: ROLLBACK TO process_estimate_lines;
285: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
286: THEN
287: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
288: END IF;
289: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
283: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
284: ROLLBACK TO process_estimate_lines;
285: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
286: THEN
287: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
288: END IF;
289: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
290: p_data => x_msg_data);
291: END process_estimate_lines;
285: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
286: THEN
287: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
288: END IF;
289: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
290: p_data => x_msg_data);
291: END process_estimate_lines;
292:
293: /*--------------------------------------------------*/
341:
342: -- Initialize message list if p_init_msg_list is set to TRUE.
343: IF Fnd_Api.to_Boolean(p_init_msg_list)
344: THEN
345: Fnd_Msg_Pub.initialize;
346: END IF;
347:
348: -- Initialize API return status to success
349: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
387: WHEN NO_DATA_FOUND THEN
388: NULL;
389: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_NO_DATA');
390: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
391: -- FND_MSG_PUB.ADD;
392: -- RAISE FND_API.G_EXC_ERROR;
393: WHEN OTHERS THEN
394: NULL;
395: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_OTHERS');
393: WHEN OTHERS THEN
394: NULL;
395: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_OTHERS');
396: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
397: -- FND_MSG_PUB.ADD;
398: -- RAISE FND_API.G_EXC_ERROR;
399: END;
400:
401: IF (l_repair_group_id IS NOT NULL)
553: IF l_return_status <> 'S'
554: THEN
555: x_return_status := Fnd_Api.G_RET_STS_ERROR;
556: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_GROUP_EST_FAIL');
557: Fnd_Msg_Pub.ADD;
558: RAISE Fnd_Api.G_EXC_ERROR;
559: ELSIF l_return_status = 'S'
560: THEN
561: x_object_version_number := l_rep_group_rec.object_version_number;
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;
577:
578: EXCEPTION
579: WHEN Fnd_Api.G_EXC_ERROR THEN
580: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
581: x_return_status := Fnd_Api.G_RET_STS_ERROR;
582: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
583: p_data => x_msg_data);
584: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
585: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
586: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
583: p_data => x_msg_data);
584: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
585: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
586: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
587: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
588: p_data => x_msg_data);
589: WHEN OTHERS THEN
590: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
591: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
588: p_data => x_msg_data);
589: WHEN OTHERS THEN
590: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
591: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
592: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
595: END IF;
596: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
590: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
591: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
592: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
595: END IF;
596: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
597: p_data => x_msg_data);
598:
592: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
595: END IF;
596: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
597: p_data => x_msg_data);
598:
599: END UPDATE_RO_GROUP_ESTIMATE;
600:
641:
642: -- Initialize message list if p_init_msg_list is set to TRUE.
643: IF Fnd_Api.to_Boolean(p_init_msg_list)
644: THEN
645: Fnd_Msg_Pub.initialize;
646: END IF;
647:
648: -- Initialize API return status to success
649: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
736:
737: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');
738: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
739: x_estimate_rec.repair_line_id);
740: Fnd_Msg_Pub.ADD;
741: RAISE Fnd_Api.G_EXC_ERROR;
742: END IF;
743:
744: IF (g_debug > 0)
756: WHEN NO_DATA_FOUND THEN
757: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
758: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
759: x_estimate_rec.estimate_status);
760: Fnd_Msg_Pub.ADD;
761: RAISE Fnd_Api.G_EXC_ERROR;
762: END;
763: /*
764: IF l_est_status_code in ('ACCEPTED','REJECTED') then
766: IF x_estimate_rec.estimate_reason_code is null then
767:
768: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
769: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_ERROR;
772:
773: END IF;
774:
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
850: x_return_status := Fnd_Api.G_RET_STS_ERROR;
848: EXCEPTION
849: WHEN Fnd_Api.G_EXC_ERROR THEN
850: x_return_status := Fnd_Api.G_RET_STS_ERROR;
851: ROLLBACK TO create_repair_estimate;
852: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
853: p_data => x_msg_data);
854: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
856: ROLLBACK TO create_repair_estimate;
853: p_data => x_msg_data);
854: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
856: ROLLBACK TO create_repair_estimate;
857: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
858: p_data => x_msg_data);
859: WHEN OTHERS THEN
860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
861: ROLLBACK TO create_repair_estimate;
858: p_data => x_msg_data);
859: WHEN OTHERS THEN
860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
861: ROLLBACK TO create_repair_estimate;
862: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
865: END IF;
866: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
861: ROLLBACK TO create_repair_estimate;
862: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
865: END IF;
866: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
867: p_data => x_msg_data);
868: END create_repair_estimate;
862: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
865: END IF;
866: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
867: p_data => x_msg_data);
868: END create_repair_estimate;
869:
870: /*--------------------------------------------------*/
919:
920: -- Initialize message list if p_init_msg_list is set to TRUE.
921: IF Fnd_Api.to_Boolean(p_init_msg_list)
922: THEN
923: Fnd_Msg_Pub.initialize;
924: END IF;
925:
926: -- Initialize API return status to success
927: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
967: IF repair_estimate%NOTFOUND
968: THEN
969: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
970: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
971: Fnd_Msg_Pub.ADD;
972: RAISE Fnd_Api.G_EXC_ERROR;
973: END IF;
974:
975: IF repair_estimate%ISOPEN
988: END IF;
989:
990: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
991: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
992: Fnd_Msg_Pub.ADD;
993: RAISE Fnd_Api.G_EXC_ERROR;
994: END IF;
995:
996: IF (g_debug > 0)
1008: WHEN NO_DATA_FOUND THEN
1009: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
1010: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
1011: x_estimate_rec.estimate_status);
1012: Fnd_Msg_Pub.ADD;
1013: RAISE Fnd_Api.G_EXC_ERROR;
1014: END;
1015: /*
1016: IF l_est_status_code in ('ACCEPTED','REJECTED') then
1018: IF x_estimate_rec.estimate_reason_code is null then
1019:
1020: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
1021: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024:
1025: END IF;
1026: END IF;
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
1117: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1115: EXCEPTION
1116: WHEN Fnd_Api.G_EXC_ERROR THEN
1117: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1118: ROLLBACK TO update_repair_estimate;
1119: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1120: p_data => x_msg_data);
1121: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1123: ROLLBACK TO update_repair_estimate;
1120: p_data => x_msg_data);
1121: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1123: ROLLBACK TO update_repair_estimate;
1124: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1125: p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1128: ROLLBACK TO update_repair_estimate;
1125: p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1128: ROLLBACK TO update_repair_estimate;
1129: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1130: THEN
1131: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1132: END IF;
1133: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1127: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1128: ROLLBACK TO update_repair_estimate;
1129: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1130: THEN
1131: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1132: END IF;
1133: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1134: p_data => x_msg_data);
1135: END update_repair_estimate;
1129: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1130: THEN
1131: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1132: END IF;
1133: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1134: p_data => x_msg_data);
1135: END update_repair_estimate;
1136:
1137: /*--------------------------------------------------*/
1176:
1177: -- Initialize message list if p_init_msg_list is set to TRUE.
1178: IF Fnd_Api.to_Boolean(p_init_msg_list)
1179: THEN
1180: Fnd_Msg_Pub.initialize;
1181: END IF;
1182:
1183: -- Initialize API return status to success
1184: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1231: END IF;
1232:
1233: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
1234: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1235: Fnd_Msg_Pub.ADD;
1236: RAISE Fnd_Api.G_EXC_ERROR;
1237: END;
1238:
1239: BEGIN
1254: END IF;
1255:
1256: Fnd_Message.SET_NAME('CSD', 'CSD_ESTIMATE_LINE_EXISTS');
1257: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1258: Fnd_Msg_Pub.ADD;
1259: RAISE Fnd_Api.G_EXC_ERROR;
1260: END IF;
1261:
1262: IF NVL(l_approval_status, 'Z') <> 'A'
1269: Csd_Repair_Estimate_Pkg.Delete_Row(p_REPAIR_ESTIMATE_ID => p_estimate_id);
1270: ELSE
1271: Fnd_Message.SET_NAME('CSD', 'CSD_EST_DELETE_NOT_ALLOWED');
1272: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1273: Fnd_Msg_Pub.ADD;
1274: RAISE Fnd_Api.G_EXC_ERROR;
1275: END IF;
1276:
1277: -- Api body ends here
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
1289: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1287: EXCEPTION
1288: WHEN Fnd_Api.G_EXC_ERROR THEN
1289: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1290: ROLLBACK TO delete_repair_estimate;
1291: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1292: p_data => x_msg_data);
1293: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1294: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1295: ROLLBACK TO delete_repair_estimate;
1292: p_data => x_msg_data);
1293: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1294: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1295: ROLLBACK TO delete_repair_estimate;
1296: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1297: p_data => x_msg_data);
1298: WHEN OTHERS THEN
1299: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1300: ROLLBACK TO delete_repair_estimate;
1297: p_data => x_msg_data);
1298: WHEN OTHERS THEN
1299: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1300: ROLLBACK TO delete_repair_estimate;
1301: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1302: THEN
1303: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1304: END IF;
1305: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1299: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1300: ROLLBACK TO delete_repair_estimate;
1301: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1302: THEN
1303: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1304: END IF;
1305: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1306: p_data => x_msg_data);
1307: END delete_repair_estimate;
1301: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1302: THEN
1303: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1304: END IF;
1305: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1306: p_data => x_msg_data);
1307: END delete_repair_estimate;
1308:
1309: /*--------------------------------------------------*/
1342:
1343: -- Initialize message list if p_init_msg_list is set to TRUE.
1344: IF Fnd_Api.to_Boolean(p_init_msg_list)
1345: THEN
1346: Fnd_Msg_Pub.initialize;
1347: END IF;
1348:
1349: -- Initialize API return status to success
1350: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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
1366: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1364: EXCEPTION
1365: WHEN Fnd_Api.G_EXC_ERROR THEN
1366: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1367: ROLLBACK TO lock_repair_estimate;
1368: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1369: p_data => x_msg_data);
1370: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1371: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1372: ROLLBACK TO lock_repair_estimate;
1369: p_data => x_msg_data);
1370: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1371: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1372: ROLLBACK TO lock_repair_estimate;
1373: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1374: p_data => x_msg_data);
1375: WHEN OTHERS THEN
1376: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1377: ROLLBACK TO lock_repair_estimate;
1374: p_data => x_msg_data);
1375: WHEN OTHERS THEN
1376: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1377: ROLLBACK TO lock_repair_estimate;
1378: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1381: END IF;
1382: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1376: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1377: ROLLBACK TO lock_repair_estimate;
1378: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1381: END IF;
1382: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1383: p_data => x_msg_data);
1384: END lock_repair_estimate;
1378: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1379: THEN
1380: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1381: END IF;
1382: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1383: p_data => x_msg_data);
1384: END lock_repair_estimate;
1385:
1386: /*--------------------------------------------------*/
1451:
1452: -- Initialize message list if p_init_msg_list is set to TRUE.
1453: IF Fnd_Api.to_Boolean(p_init_msg_list)
1454: THEN
1455: Fnd_Msg_Pub.initialize;
1456: END IF;
1457:
1458: -- Initialize API return status to success
1459: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1553: WHEN NO_DATA_FOUND THEN
1554: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
1555: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
1556: x_estimate_line_rec.repair_line_id);
1557: Fnd_Msg_Pub.ADD;
1558: RAISE Fnd_Api.G_EXC_ERROR;
1559: END;
1560:
1561: IF (g_debug > 0)
1622: Exception
1623: When no_data_found then
1624: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
1625: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
1626: FND_MSG_PUB.ADD;
1627: IF (g_debug > 0 ) THEN
1628: csd_gen_utility_pvt.ADD('Contract Line Id missing');
1629: END IF;
1630:
1655: IF order_rec%NOTFOUND OR l_party_id IS NULL
1656: THEN
1657: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
1658: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
1659: Fnd_Msg_Pub.ADD;
1660: RAISE Fnd_Api.G_EXC_ERROR;
1661: END IF;
1662:
1663: IF order_rec%ISOPEN
1731: THEN
1732: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
1733: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1734: x_estimate_line_rec.txn_billing_type_id);
1735: Fnd_Msg_Pub.ADD;
1736: RAISE Fnd_Api.G_EXC_ERROR;
1737: END IF;
1738:
1739: -- Get the currency code
1750: Fnd_Message.SET_NAME('CSD',
1751: 'CSD_API_INV_PRICE_LIST_ID');
1752: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1753: x_estimate_line_rec.price_list_id);
1754: Fnd_Msg_Pub.ADD;
1755: RAISE Fnd_Api.G_EXC_ERROR;
1756: END;
1757: END IF;
1758:
1766: THEN
1767: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
1768: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1769: x_estimate_line_rec.price_list_id);
1770: Fnd_Msg_Pub.ADD;
1771: RAISE Fnd_Api.G_EXC_ERROR;
1772: END IF;
1773:
1774: --
1796: -- csd_gen_utility_pvt.ADD('Could not get item cost' );
1797: --END IF;
1798: --
1799: -- FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_COST_MISSING');
1800: -- FND_MSG_PUB.ADD;
1801: -- RAISE FND_API.G_EXC_ERROR;
1802: -- END;
1803: -- END IF;
1804: --
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
1918: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1916: EXCEPTION
1917: WHEN Fnd_Api.G_EXC_ERROR THEN
1918: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1919: ROLLBACK TO create_repair_estimate_lines;
1920: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1921: p_data => x_msg_data);
1922: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1923: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1924: ROLLBACK TO create_repair_estimate_lines;
1921: p_data => x_msg_data);
1922: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1923: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1924: ROLLBACK TO create_repair_estimate_lines;
1925: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1926: p_data => x_msg_data);
1927: WHEN OTHERS THEN
1928: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1929: ROLLBACK TO create_repair_estimate_lines;
1926: p_data => x_msg_data);
1927: WHEN OTHERS THEN
1928: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1929: ROLLBACK TO create_repair_estimate_lines;
1930: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1931: THEN
1932: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1933: END IF;
1934: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1928: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1929: ROLLBACK TO create_repair_estimate_lines;
1930: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1931: THEN
1932: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1933: END IF;
1934: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1935: p_data => x_msg_data);
1936: END create_repair_estimate_lines;
1930: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1931: THEN
1932: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1933: END IF;
1934: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1935: p_data => x_msg_data);
1936: END create_repair_estimate_lines;
1937:
1938: /*--------------------------------------------------*/
2002:
2003: -- Initialize message list if p_init_msg_list is set to TRUE.
2004: IF Fnd_Api.to_Boolean(p_init_msg_list)
2005: THEN
2006: Fnd_Msg_Pub.initialize;
2007: END IF;
2008:
2009: -- Initialize API return status to success
2010: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2071:
2072: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
2073: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2074: x_estimate_line_rec.repair_estimate_line_id);
2075: Fnd_Msg_Pub.ADD;
2076: RAISE Fnd_Api.G_EXC_ERROR;
2077: END IF;
2078:
2079: IF NVL(x_estimate_line_rec.estimate_detail_id, Fnd_Api.G_MISS_NUM) <>
2152: Exception
2153: When no_data_found then
2154: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
2155: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
2156: FND_MSG_PUB.ADD;
2157: IF (g_debug > 0 ) THEN
2158: csd_gen_utility_pvt.ADD('Contract Line Id missing');
2159: END IF;
2160:
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
2315: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2313: EXCEPTION
2314: WHEN Fnd_Api.G_EXC_ERROR THEN
2315: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2316: ROLLBACK TO update_repair_estimate_lines;
2317: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2318: p_data => x_msg_data);
2319: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2320: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2321: ROLLBACK TO update_repair_estimate_lines;
2318: p_data => x_msg_data);
2319: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2320: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2321: ROLLBACK TO update_repair_estimate_lines;
2322: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2323: p_data => x_msg_data);
2324: WHEN OTHERS THEN
2325: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2326: ROLLBACK TO update_repair_estimate_lines;
2323: p_data => x_msg_data);
2324: WHEN OTHERS THEN
2325: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2326: ROLLBACK TO update_repair_estimate_lines;
2327: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2328: THEN
2329: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2330: END IF;
2331: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2325: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2326: ROLLBACK TO update_repair_estimate_lines;
2327: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2328: THEN
2329: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2330: END IF;
2331: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2332: p_data => x_msg_data);
2333: END update_repair_estimate_lines;
2327: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2328: THEN
2329: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2330: END IF;
2331: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2332: p_data => x_msg_data);
2333: END update_repair_estimate_lines;
2334:
2335: /*--------------------------------------------------*/
2372:
2373: -- Initialize message list if p_init_msg_list is set to TRUE.
2374: IF Fnd_Api.to_Boolean(p_init_msg_list)
2375: THEN
2376: Fnd_Msg_Pub.initialize;
2377: END IF;
2378:
2379: -- Initialize API return status to success
2380: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2438:
2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
2440: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2441: p_estimate_line_id);
2442: Fnd_Msg_Pub.ADD;
2443: RAISE Fnd_Api.G_EXC_ERROR;
2444: END;
2445:
2446: IF (g_debug > 0)
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
2505: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2503: EXCEPTION
2504: WHEN Fnd_Api.G_EXC_ERROR THEN
2505: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2506: ROLLBACK TO delete_repair_estimate_lines;
2507: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2508: p_data => x_msg_data);
2509: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2510: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2511: ROLLBACK TO delete_repair_estimate_lines;
2508: p_data => x_msg_data);
2509: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2510: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2511: ROLLBACK TO delete_repair_estimate_lines;
2512: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2513: p_data => x_msg_data);
2514: WHEN OTHERS THEN
2515: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2516: ROLLBACK TO delete_repair_estimate_lines;
2513: p_data => x_msg_data);
2514: WHEN OTHERS THEN
2515: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2516: ROLLBACK TO delete_repair_estimate_lines;
2517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2518: THEN
2519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2520: END IF;
2521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2515: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2516: ROLLBACK TO delete_repair_estimate_lines;
2517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2518: THEN
2519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2520: END IF;
2521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2522: p_data => x_msg_data);
2523: END delete_repair_estimate_lines;
2517: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2518: THEN
2519: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2520: END IF;
2521: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2522: p_data => x_msg_data);
2523: END delete_repair_estimate_lines;
2524:
2525: /*--------------------------------------------------*/
2558:
2559: -- Initialize message list if p_init_msg_list is set to TRUE.
2560: IF Fnd_Api.to_Boolean(p_init_msg_list)
2561: THEN
2562: Fnd_Msg_Pub.initialize;
2563: END IF;
2564:
2565: -- Initialize API return status to success
2566: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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
2582: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2580: EXCEPTION
2581: WHEN Fnd_Api.G_EXC_ERROR THEN
2582: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2583: ROLLBACK TO lock_repair_estimate_lines;
2584: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2585: p_data => x_msg_data);
2586: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2587: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2588: ROLLBACK TO lock_repair_estimate_lines;
2585: p_data => x_msg_data);
2586: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2587: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2588: ROLLBACK TO lock_repair_estimate_lines;
2589: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2590: p_data => x_msg_data);
2591: WHEN OTHERS THEN
2592: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2593: ROLLBACK TO lock_repair_estimate_lines;
2590: p_data => x_msg_data);
2591: WHEN OTHERS THEN
2592: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2593: ROLLBACK TO lock_repair_estimate_lines;
2594: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2595: THEN
2596: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2597: END IF;
2598: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2592: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2593: ROLLBACK TO lock_repair_estimate_lines;
2594: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2595: THEN
2596: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2597: END IF;
2598: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2599: p_data => x_msg_data);
2600: END lock_repair_estimate_lines;
2594: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2595: THEN
2596: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2597: END IF;
2598: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2599: p_data => x_msg_data);
2600: END lock_repair_estimate_lines;
2601:
2602: PROCEDURE REPAIR_ESTIMATE_PRINT(p_api_version IN NUMBER,
2648: END IF;
2649: -- Initialize message list if p_init_msg_list is set to TRUE.
2650: IF Fnd_Api.to_Boolean(p_init_msg_list)
2651: THEN
2652: Fnd_Msg_Pub.initialize;
2653: END IF;
2654: -- Initialize API return status to success
2655: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2656: -- start of the concurrent submission
2689: Csd_Gen_Utility_Pvt.ADD('Set Print Option Failed');
2690: END IF;
2691: Fnd_Message.SET_NAME('CSD', 'CSD_EST_PRINT_OPTION_ERROR');
2692: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2693: Fnd_Msg_Pub.ADD;
2694: END IF;
2695: ELSIF (l_print_required = 'Y')
2696: THEN
2697: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRINTER_SETUP');
2695: ELSIF (l_print_required = 'Y')
2696: THEN
2697: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRINTER_SETUP');
2698: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2699: Fnd_Msg_Pub.ADD;
2700: END IF;
2701: -- valase:6499519, rfieldma: 6532016 below
2702: -- get print mode
2703: l_print_mode := FND_PROFILE.value('CSD_ESTRT_PRINT_MODE');
2717: IF (l_template_code is null) THEN
2718: Fnd_Message.SET_NAME('CSD', 'CSD_XDO_ESTRT_NO_TEMPLATE');
2719: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));
2720: x_request_id := l_request_id;
2721: Fnd_Msg_Pub.ADD;
2722: RAISE Fnd_Api.G_EXC_ERROR;
2723: END IF;
2724: -- get current session language and territory
2725: OPEN get_lang_terr;
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
2776: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2774: EXCEPTION
2775: WHEN Fnd_Api.G_EXC_ERROR THEN
2776: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2777: ROLLBACK TO estimate_print;
2778: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2779: p_data => x_msg_data);
2780: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2781: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2782: ROLLBACK TO estimate_print;
2779: p_data => x_msg_data);
2780: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2781: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2782: ROLLBACK TO estimate_print;
2783: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2784: p_data => x_msg_data);
2785: WHEN OTHERS THEN
2786: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2787: ROLLBACK TO estimate_print;
2784: p_data => x_msg_data);
2785: WHEN OTHERS THEN
2786: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2787: ROLLBACK TO estimate_print;
2788: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2789: THEN
2790: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2791: END IF;
2792: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2786: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2787: ROLLBACK TO estimate_print;
2788: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2789: THEN
2790: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2791: END IF;
2792: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2793: p_data => x_msg_data);
2794: END REPAIR_ESTIMATE_PRINT;
2788: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2789: THEN
2790: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2791: END IF;
2792: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2793: p_data => x_msg_data);
2794: END REPAIR_ESTIMATE_PRINT;
2795:
2796: PROCEDURE SUBMIT_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
2849:
2850: -- Initialize message list if p_init_msg_list is set to TRUE.
2851: IF Fnd_Api.to_Boolean(p_init_msg_list)
2852: THEN
2853: Fnd_Msg_Pub.initialize;
2854: END IF;
2855:
2856: -- Initialize API return status to success
2857: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2867: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2868: Fnd_Msg_Pub.ADD;
2869: RAISE Fnd_Api.G_EXC_ERROR;
2870: END;
2871:
2872: IF l_org_src_ref = 'RMA'
3003: EXCEPTION
3004: WHEN NO_DATA_FOUND THEN
3005: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
3006: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
3007: Fnd_Msg_Pub.ADD;
3008: RAISE Fnd_Api.G_EXC_ERROR;
3009: END;
3010:
3011: IF (g_debug > 0)
3040: WHERE oe.header_id = ced.order_header_id
3041: AND ced.estimate_detail_id = l_last_est_detail_id;
3042: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3043: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);
3044: Fnd_Msg_Pub.ADD;
3045: EXCEPTION
3046: WHEN NO_DATA_FOUND THEN
3047: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOT_INTERFACED');
3048: Fnd_Msg_Pub.ADD;
3044: Fnd_Msg_Pub.ADD;
3045: EXCEPTION
3046: WHEN NO_DATA_FOUND THEN
3047: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOT_INTERFACED');
3048: Fnd_Msg_Pub.ADD;
3049: IF (g_debug > 0)
3050: THEN
3051: Csd_Gen_Utility_Pvt.ADD('Estimate not interfaced to OM ');
3052: END IF;
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
3066: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3064: EXCEPTION
3065: WHEN Fnd_Api.G_EXC_ERROR THEN
3066: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3067: ROLLBACK TO submit_estimate_lines;
3068: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3069: p_data => x_msg_data);
3070: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3071: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3072: ROLLBACK TO submit_estimate_lines;
3069: p_data => x_msg_data);
3070: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3071: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3072: ROLLBACK TO submit_estimate_lines;
3073: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3074: p_data => x_msg_data);
3075: WHEN OTHERS THEN
3076: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3077: ROLLBACK TO submit_estimate_lines;
3074: p_data => x_msg_data);
3075: WHEN OTHERS THEN
3076: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3077: ROLLBACK TO submit_estimate_lines;
3078: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3079: THEN
3080: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3081: END IF;
3082: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3076: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3077: ROLLBACK TO submit_estimate_lines;
3078: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3079: THEN
3080: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3081: END IF;
3082: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3083: p_data => x_msg_data);
3084:
3078: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3079: THEN
3080: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3081: END IF;
3082: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3083: p_data => x_msg_data);
3084:
3085: END SUBMIT_REPAIR_ESTIMATE_LINES;
3086:
3244:
3245: -- Initialize message list if p_init_msg_list is set to TRUE.
3246: IF Fnd_Api.to_Boolean(p_init_msg_list)
3247: THEN
3248: Fnd_Msg_Pub.initialize;
3249: END IF;
3250:
3251: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3252: THEN
3568: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3569: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3570: lc_mod_name,
3571: 'Number of messages in stack: ' ||
3572: Fnd_Msg_Pub.count_msg);
3573: END IF;
3574: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
3575: p_commit => Fnd_Api.G_FALSE,
3576: p_init_msg_list => Fnd_Api.G_FALSE,
3594: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3595: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3596: lc_mod_name,
3597: 'Number of messages in stack: ' ||
3598: Fnd_Msg_Pub.count_msg);
3599: END IF;
3600: END IF;
3601:
3602: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3722: 'Adding message CSD_EST_SC_APPLIED_ERR to FND_MSG stack');
3723: END IF;
3724: Fnd_Message.SET_NAME('CSD',
3725: 'CSD_EST_SC_APPLIED_ERR');
3726: Fnd_Msg_Pub.ADD;
3727: IF (Fnd_Log.Level_Procedure >=
3728: Fnd_Log.G_Current_Runtime_Level)
3729: THEN
3730: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3732: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3733: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3734: lc_mod_name,
3735: 'Number of messages in stack: ' ||
3736: Fnd_Msg_Pub.count_msg);
3737: END IF;
3738: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
3739: p_commit => Fnd_Api.G_FALSE,
3740: p_init_msg_list => Fnd_Api.G_FALSE,
3761: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3762: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3763: lc_mod_name,
3764: 'Number of messages in stack: ' ||
3765: Fnd_Msg_Pub.count_msg);
3766: END IF;
3767: END IF;
3768: END IF;
3769: ELSE
3803: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');
3804: END IF;
3805: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3806: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3807: Fnd_Msg_Pub.ADD;
3808: IF (Fnd_Log.Level_Procedure >=
3809: Fnd_Log.G_Current_Runtime_Level)
3810: THEN
3811: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3813: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3814: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3815: lc_mod_name,
3816: 'Number of messages in stack: ' ||
3817: Fnd_Msg_Pub.count_msg);
3818: END IF;
3819: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
3820: p_commit => Fnd_Api.G_FALSE,
3821: p_init_msg_list => Fnd_Api.G_FALSE,
3841: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3842: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3843: lc_mod_name,
3844: 'Number of messages in stack: ' ||
3845: Fnd_Msg_Pub.count_msg);
3846: END IF;
3847: END IF;
3848: END LOOP;
3849:
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)
3866: THEN
3890: lc_mod_name,
3891: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');
3892: END IF;
3893: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');
3894: Fnd_Msg_Pub.ADD;
3895: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3896: p_data => x_msg_data);
3897:
3898: -- save message in debug log
3891: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');
3892: END IF;
3893: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');
3894: Fnd_Msg_Pub.ADD;
3895: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3896: p_data => x_msg_data);
3897:
3898: -- save message in debug log
3899: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3915: lc_mod_name,
3916: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');
3917: END IF;
3918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');
3919: Fnd_Msg_Pub.ADD;
3920: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3921: p_data => x_msg_data);
3922:
3923: -- save message in debug log
3916: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');
3917: END IF;
3918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');
3919: Fnd_Msg_Pub.ADD;
3920: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3921: p_data => x_msg_data);
3922:
3923: -- save message in debug log
3924: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3950: WHERE lookup_type = 'CSD_REPAIR_MODE'
3951: AND lookup_code = p_repair_mode;
3952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_INAPPL_MODE');
3953: Fnd_Message.SET_TOKEN('MODE', l_repair_mode_name);
3954: Fnd_Msg_Pub.ADD;
3955: EXCEPTION
3956: WHEN NO_DATA_FOUND THEN
3957: l_repair_mode_name := p_repair_mode;
3958: END;
3955: EXCEPTION
3956: WHEN NO_DATA_FOUND THEN
3957: l_repair_mode_name := p_repair_mode;
3958: END;
3959: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3960: p_data => x_msg_data);
3961:
3962: -- save message in debug log
3963: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3978: 'Adding message err_name to FND_MSG stack');
3979: end if;
3980: FND_MESSAGE.SET_NAME('CSD','err_name');
3981: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
3982: FND_MSG_PUB.ADD;
3983: */
3984: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3985: p_data => x_msg_data);
3986:
3980: FND_MESSAGE.SET_NAME('CSD','err_name');
3981: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
3982: FND_MSG_PUB.ADD;
3983: */
3984: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3985: p_data => x_msg_data);
3986:
3987: -- save message in debug log
3988: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3995: ROLLBACK TO Autocreate_Estimate_Lines;
3996: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3997:
3998: -- save message in fnd stack
3999: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4000: THEN
4001: IF (Fnd_Log.Level_Statement >=
4002: Fnd_Log.G_Current_Runtime_Level)
4003: THEN
4002: Fnd_Log.G_Current_Runtime_Level)
4003: THEN
4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4005: lc_mod_name,
4006: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4007: END IF;
4008: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4009: END IF;
4010: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4004: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4005: lc_mod_name,
4006: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4007: END IF;
4008: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4009: END IF;
4010: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4011: p_data => x_msg_data);
4012:
4006: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4007: END IF;
4008: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4009: END IF;
4010: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4011: p_data => x_msg_data);
4012:
4013: -- save message in debug log
4014: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4021: ROLLBACK TO Autocreate_Estimate_Lines;
4022: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4023:
4024: -- save message in fnd stack
4025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
4026: THEN
4027: IF (Fnd_Log.Level_Statement >=
4028: Fnd_Log.G_Current_Runtime_Level)
4029: THEN
4028: Fnd_Log.G_Current_Runtime_Level)
4029: THEN
4030: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4031: lc_mod_name,
4032: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4033: END IF;
4034: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4035: END IF;
4036: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4030: Fnd_Log.STRING(Fnd_Log.Level_Statement,
4031: lc_mod_name,
4032: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4033: END IF;
4034: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4035: END IF;
4036: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4037: p_data => x_msg_data);
4038:
4032: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
4033: END IF;
4034: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4035: END IF;
4036: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4037: p_data => x_msg_data);
4038:
4039: -- save message in debug log
4040: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4656:
4657: -- Initialize message list if p_init_msg_list is set to TRUE.
4658: IF Fnd_Api.to_Boolean(p_init_msg_list)
4659: THEN
4660: Fnd_Msg_Pub.initialize;
4661: END IF;
4662:
4663: -- Initialize API return status to success
4664: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4951: END IF;
4952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');
4953: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4954: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4955: Fnd_Msg_Pub.ADD;
4956: IF (Fnd_Log.Level_Procedure >=
4957: Fnd_Log.G_Current_Runtime_Level)
4958: THEN
4959: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4961: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4962: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4963: lc_mod_name,
4964: 'Number of messages in stack: ' ||
4965: Fnd_Msg_Pub.count_msg);
4966: END IF;
4967: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
4968: p_commit => Fnd_Api.G_FALSE,
4969: p_init_msg_list => Fnd_Api.G_FALSE,
4987: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4988: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4989: lc_mod_name,
4990: 'Number of messages in stack: ' ||
4991: Fnd_Msg_Pub.count_msg);
4992: END IF;
4993: END LOOP;
4994: END;
4995:
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
5206: x_warning_flag := Fnd_Api.G_TRUE;
5212: lc_mod_name,
5213: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5214: END IF;
5215: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5216: Fnd_Msg_Pub.ADD;
5217: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5218: p_data => x_msg_data);
5219:
5220: -- save message in debug log
5213: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5214: END IF;
5215: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5216: Fnd_Msg_Pub.ADD;
5217: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5218: p_data => x_msg_data);
5219:
5220: -- save message in debug log
5221: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5237: 'Adding message ERR_NAME to FND_MSG stack');
5238: end if;
5239: FND_MESSAGE.SET_NAME('CSD','err_name');
5240: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5241: FND_MSG_PUB.ADD;
5242: */
5243: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5244: p_data => x_msg_data);
5245:
5239: FND_MESSAGE.SET_NAME('CSD','err_name');
5240: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5241: FND_MSG_PUB.ADD;
5242: */
5243: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5244: p_data => x_msg_data);
5245:
5246: -- save message in debug log
5247: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5255: ROLLBACK TO Get_Estimates_From_Task;
5256: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5257:
5258: -- save message in fnd stack
5259: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5260: THEN
5261: IF (Fnd_Log.Level_Statement >=
5262: Fnd_Log.G_Current_Runtime_Level)
5263: THEN
5262: Fnd_Log.G_Current_Runtime_Level)
5263: THEN
5264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5265: lc_mod_name,
5266: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5267: END IF;
5268: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5269: END IF;
5270: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5264: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5265: lc_mod_name,
5266: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5267: END IF;
5268: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5269: END IF;
5270: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5271: p_data => x_msg_data);
5272:
5266: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5267: END IF;
5268: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5269: END IF;
5270: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5271: p_data => x_msg_data);
5272:
5273: -- save message in debug log
5274: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5282: ROLLBACK TO Get_Estimates_From_Task;
5283: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5284:
5285: -- save message in fnd stack
5286: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5287: THEN
5288: IF (Fnd_Log.Level_Statement >=
5289: Fnd_Log.G_Current_Runtime_Level)
5290: THEN
5289: Fnd_Log.G_Current_Runtime_Level)
5290: THEN
5291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5292: lc_mod_name,
5293: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5294: END IF;
5295: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5296: END IF;
5297: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5291: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5292: lc_mod_name,
5293: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5294: END IF;
5295: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5296: END IF;
5297: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5298: p_data => x_msg_data);
5299:
5293: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5294: END IF;
5295: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5296: END IF;
5297: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5298: p_data => x_msg_data);
5299:
5300: -- save message in debug log
5301: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5601:
5602: -- Initialize message list if p_init_msg_list is set to TRUE.
5603: IF Fnd_Api.to_Boolean(p_init_msg_list)
5604: THEN
5605: Fnd_Msg_Pub.initialize;
5606: END IF;
5607:
5608: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5609: 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
5894: x_warning_flag := Fnd_Api.G_TRUE;
5900: lc_mod_name,
5901: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5902: END IF;
5903: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5904: Fnd_Msg_Pub.ADD;
5905: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5906: p_data => x_msg_data);
5907:
5908: -- save message in debug log
5901: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5902: END IF;
5903: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5904: Fnd_Msg_Pub.ADD;
5905: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5906: p_data => x_msg_data);
5907:
5908: -- save message in debug log
5909: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5924: 'Adding message err_name to FND_MSG stack');
5925: end if;
5926: FND_MESSAGE.SET_NAME('CSD','err_name');
5927: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5928: FND_MSG_PUB.ADD;
5929: */
5930: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5931: p_data => x_msg_data);
5932:
5926: FND_MESSAGE.SET_NAME('CSD','err_name');
5927: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5928: FND_MSG_PUB.ADD;
5929: */
5930: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5931: p_data => x_msg_data);
5932:
5933: -- save message in debug log
5934: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5942: ROLLBACK TO Get_Estimates_From_BOM;
5943: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5944:
5945: -- save message in fnd stack
5946: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5947: THEN
5948: IF (Fnd_Log.Level_Statement >=
5949: Fnd_Log.G_Current_Runtime_Level)
5950: THEN
5949: Fnd_Log.G_Current_Runtime_Level)
5950: THEN
5951: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5952: lc_mod_name,
5953: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5954: END IF;
5955: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5956: END IF;
5957: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5951: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5952: lc_mod_name,
5953: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5954: END IF;
5955: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5956: END IF;
5957: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5958: p_data => x_msg_data);
5959:
5953: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5954: END IF;
5955: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5956: END IF;
5957: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5958: p_data => x_msg_data);
5959:
5960: -- save message in debug log
5961: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5967:
5968: WHEN OTHERS THEN
5969: ROLLBACK TO Get_Estimates_From_BOM;
5970: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5971: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5972: THEN
5973: IF (Fnd_Log.Level_Statement >=
5974: Fnd_Log.G_Current_Runtime_Level)
5975: THEN
5974: Fnd_Log.G_Current_Runtime_Level)
5975: THEN
5976: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5977: lc_mod_name,
5978: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5979: END IF;
5980: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5981: END IF;
5982: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5976: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5977: lc_mod_name,
5978: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5979: END IF;
5980: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5981: END IF;
5982: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5983: p_data => x_msg_data);
5984:
5978: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5979: END IF;
5980: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5981: END IF;
5982: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5983: p_data => x_msg_data);
5984:
5985: -- save message in debug log
5986: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6091:
6092: -- Initialize message list if p_init_msg_list is set to TRUE.
6093: IF Fnd_Api.to_Boolean(p_init_msg_list)
6094: THEN
6095: Fnd_Msg_Pub.initialize;
6096: END IF;
6097:
6098: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6099: THEN
6271: END;
6272: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6273: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);
6274: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6275: Fnd_Msg_Pub.ADD;
6276: l_error := TRUE;
6277: IF (Fnd_Log.Level_Statement >=
6278: Fnd_Log.G_Current_Runtime_Level)
6279: THEN
6301: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');
6302: END IF;
6303: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');
6304: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6305: Fnd_Msg_Pub.ADD;
6306: l_error := TRUE;
6307: IF (Fnd_Log.Level_Statement >=
6308: Fnd_Log.G_Current_Runtime_Level)
6309: THEN
6477: 'CSD_EST_ESTIMATED_CHARGE_ERR');
6478: Fnd_Message.SET_TOKEN('CONTRACT_NUMBER',
6479: x_est_lines_tbl(l_curRow)
6480: .contract_number);
6481: Fnd_Msg_Pub.ADD;
6482: l_error := TRUE;
6483: END IF;
6484: -- Bugfix 3843770, vkjain.
6485: -- The contract discount field is not being populated for AutoCreate
6559: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6560: -- end if;
6561: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
6562: -- FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',x_est_lines_tbl(l_curRow).contract_number);
6563: -- FND_MSG_PUB.ADD;
6564: -- l_error := TRUE;
6565: END IF;
6566:
6567: -- set transaction type (Material, labor, expense)
6663: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6664: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6665: lc_mod_name,
6666: 'Number of messages in stack: ' ||
6667: Fnd_Msg_Pub.count_msg);
6668: END IF;
6669: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
6670: p_commit => Fnd_Api.G_FALSE,
6671: p_init_msg_list => Fnd_Api.G_FALSE,
6691: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6692: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6693: lc_mod_name,
6694: 'Number of messages in stack: ' ||
6695: Fnd_Msg_Pub.count_msg);
6696: END IF;
6697: END IF;
6698: END LOOP;
6699:
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
6728: ROLLBACK TO Convert_To_Est_Lines;
6736: 'Adding message err_name to FND_MSG stack');
6737: end if;
6738: FND_MESSAGE.SET_NAME('CSD','err_name');
6739: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
6740: FND_MSG_PUB.ADD;
6741: */
6742: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6743: p_data => x_msg_data);
6744:
6738: FND_MESSAGE.SET_NAME('CSD','err_name');
6739: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
6740: FND_MSG_PUB.ADD;
6741: */
6742: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6743: p_data => x_msg_data);
6744:
6745: -- save message in debug log
6746: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6753: ROLLBACK TO Convert_To_Est_Lines;
6754: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6755:
6756: -- save message in fnd stack
6757: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6758: THEN
6759: IF (Fnd_Log.Level_Statement >=
6760: Fnd_Log.G_Current_Runtime_Level)
6761: THEN
6760: Fnd_Log.G_Current_Runtime_Level)
6761: THEN
6762: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6763: lc_mod_name,
6764: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6765: END IF;
6766: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6767: END IF;
6768: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6762: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6763: lc_mod_name,
6764: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6765: END IF;
6766: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6767: END IF;
6768: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6769: p_data => x_msg_data);
6770:
6764: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6765: END IF;
6766: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6767: END IF;
6768: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6769: p_data => x_msg_data);
6770:
6771: -- save message in debug log
6772: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6779: ROLLBACK TO Convert_To_Est_Lines;
6780: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6781:
6782: -- save message in fnd stack
6783: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6784: THEN
6785: IF (Fnd_Log.Level_Statement >=
6786: Fnd_Log.G_Current_Runtime_Level)
6787: THEN
6786: Fnd_Log.G_Current_Runtime_Level)
6787: THEN
6788: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6789: lc_mod_name,
6790: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6791: END IF;
6792: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6793: END IF;
6794: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6788: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6789: lc_mod_name,
6790: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6791: END IF;
6792: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6793: END IF;
6794: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6795: p_data => x_msg_data);
6796:
6790: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6791: END IF;
6792: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6793: END IF;
6794: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6795: p_data => x_msg_data);
6796:
6797: -- save message in debug log
6798: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6867:
6868: -- Initialize message list if p_init_msg_list is set to TRUE.
6869: IF Fnd_Api.to_Boolean(p_init_msg_list)
6870: THEN
6871: Fnd_Msg_Pub.initialize;
6872: END IF;
6873:
6874: -- Initialize API return status to success
6875: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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
6977: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6975: EXCEPTION
6976: WHEN Fnd_Api.G_EXC_ERROR THEN
6977: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6978: ROLLBACK TO create_estimate_header_pvt;
6979: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6980: p_data => x_msg_data);
6981: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
6982: THEN
6983: Fnd_Log.STRING(Fnd_Log.level_error,
6986: END IF;
6987: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
6988: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6989: ROLLBACK TO create_estimate_header_pvt;
6990: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6991: p_data => x_msg_data);
6992: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6993: THEN
6994: Fnd_Log.STRING(Fnd_Log.level_exception,
6997: END IF;
6998: WHEN OTHERS THEN
6999: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7000: ROLLBACK TO create_estimate_header_pvt;
7001: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7002: THEN
7003: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7004: END IF;
7005: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6999: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7000: ROLLBACK TO create_estimate_header_pvt;
7001: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7002: THEN
7003: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7004: END IF;
7005: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7006: p_data => x_msg_data);
7007: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7001: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7002: THEN
7003: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7004: END IF;
7005: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7006: p_data => x_msg_data);
7007: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7008: THEN
7009: Fnd_Log.STRING(Fnd_Log.level_exception,
7060:
7061: -- Initialize message list if p_init_msg_list is set to TRUE.
7062: IF Fnd_Api.to_Boolean(p_init_msg_list)
7063: THEN
7064: Fnd_Msg_Pub.initialize;
7065: END IF;
7066:
7067: -- Initialize API return status to success
7068: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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)
7125: THEN
7130: EXCEPTION
7131: WHEN Fnd_Api.G_EXC_ERROR THEN
7132: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7133: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7134: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7135: p_data => x_msg_data);
7136: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7137: THEN
7138: Fnd_Log.STRING(Fnd_Log.level_error,
7142:
7143: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
7144: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7145: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7146: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7147: p_data => x_msg_data);
7148: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7149: THEN
7150: Fnd_Log.STRING(Fnd_Log.level_exception,
7153: END IF;
7154: WHEN OTHERS THEN
7155: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7156: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7157: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7160: END IF;
7161: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7155: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7156: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7157: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7160: END IF;
7161: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7162: p_data => x_msg_data);
7163: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7157: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7158: THEN
7159: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7160: END IF;
7161: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7162: p_data => x_msg_data);
7163: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7164: THEN
7165: Fnd_Log.STRING(Fnd_Log.level_exception,
7250:
7251: -- Initialize message list if p_init_msg_list is set to TRUE.
7252: IF Fnd_Api.to_Boolean(p_init_msg_list)
7253: THEN
7254: Fnd_Msg_Pub.initialize;
7255: END IF;
7256:
7257: -- Initialize API return status to success
7258: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7307:
7308: IF (CUR_EST_HDR%NOTFOUND)
7309: THEN
7310: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_HEADER');
7311: Fnd_Msg_Pub.ADD;
7312: RAISE Fnd_Api.G_EXC_ERROR;
7313: END IF;
7314:
7315: IF (l_est_pvt_hdr_Rec.repair_line_id <>
7315: IF (l_est_pvt_hdr_Rec.repair_line_id <>
7316: p_Estimate_hdr_Rec.repair_line_id)
7317: THEN
7318: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_INPUT');
7319: Fnd_Msg_Pub.ADD;
7320: RAISE Fnd_Api.G_EXC_ERROR;
7321: END IF;
7322: CLOSE CUR_EST_HDR;
7323:
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)
7416: THEN
7421: EXCEPTION
7422: WHEN Fnd_Api.G_EXC_ERROR THEN
7423: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7424: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7425: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7426: p_data => x_msg_data);
7427: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7428: THEN
7429: Fnd_Log.STRING(Fnd_Log.level_error,
7433:
7434: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
7435: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7436: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7437: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7438: p_data => x_msg_data);
7439: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7440: THEN
7441: Fnd_Log.STRING(Fnd_Log.level_exception,
7444: END IF;
7445: WHEN OTHERS THEN
7446: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7447: Rollback TO UPDATE_ESTIMATE_HEADER_PVT;
7448: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7449: THEN
7450: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7451: END IF;
7452: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7446: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7447: Rollback TO UPDATE_ESTIMATE_HEADER_PVT;
7448: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7449: THEN
7450: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7451: END IF;
7452: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7453: p_data => x_msg_data);
7454: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7448: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7449: THEN
7450: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7451: END IF;
7452: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7453: p_data => x_msg_data);
7454: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7455: THEN
7456: Fnd_Log.STRING(Fnd_Log.level_exception,
7825: END IF;
7826:
7827: -- Initialize message list if p_init_msg_list is set to TRUE.
7828: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7829: FND_MSG_PUB.initialize;
7830: END IF;
7831:
7832: -- logging
7833: if (lc_proc_level >= lc_debug_level) then
7976: -- Unable to determine default pricelist
7977: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_DEFAULT_PL_IMPORT');
7978: -- Unable to determine default price list for the repair order.
7979: -- A default price list must be selected for the repair order to import estimate lines.
7980: FND_MSG_PUB.ADD;
7981: RAISE FND_API.G_EXC_ERROR;
7982: END IF;
7983:
7984: -- Log info messages for all the wip jobs that are shared with other
7999: -- The WIP job $JOB_NAME is submitted for more than one repair order.
8000: -- The estimate lines, for a WIP job that is shared across repair orders,
8001: -- can not be submitted.
8002: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );
8003: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
8004:
8005: END LOOP; -- c_ineligible_WIP_Jobs cursor
8006:
8007: if (lc_stat_level >= lc_debug_level) then
8066: 'Estimate header status is not NEW. Status =' || l_repair_estimate_status);
8067: end if;
8068: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GEN_EST_STATUS_ERR');
8069: FND_MESSAGE.set_token( 'STATUS', l_repair_estimate_status_name);
8070: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8071: RAISE FND_API.G_EXC_ERROR;
8072: ELSE
8073: -- found estimte header, so change status to DRAFT
8074: -- required fields
8457: -- Add an ERROR message.
8458: -- An error encountered while creating an estimate line for item $ITEM
8459: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');
8460: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );
8461: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8462: ELSE
8463: l_total_estimates_lines := l_total_estimates_lines +1;
8464: if (lc_proc_level >= lc_debug_level) then
8465: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8472: -- Add an ERROR message.
8473: -- An error encountered while creating Estimate line $INDEX for inventory item $INV_ITEM_ID
8474: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');
8475: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );
8476: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8477: END;
8478: END LOOP;
8479:
8480: if (lc_proc_level >= lc_debug_level) then
8487: -- $ESTIMATE_LINE_COUNT new repair estimate line(s) were created for the job.
8488: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_W_WARN' );
8489: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8490: FND_MESSAGE.set_token( 'ESTIMATE_LINE_COUNT', l_Estimates_count );
8491: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
8492: if (lc_stat_level >= lc_debug_level) then
8493: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8494: 'Debrief lines import for the WIP Job ' || curr_WIP_job_rec.JOB_NAME
8495: || ' completed with warnings. l_Estimates_count = ' || l_Estimates_count);
8507: -- Add an ERROR message.
8508: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_ERROR');
8509: -- An error encountered while importing WIP lines into Estimates for the WIP entity - $JOB_NAME.
8510: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8511: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8512:
8513: WHEN OTHERS THEN
8514: ROLLBACK TO curr_wip_job_sp;
8515: x_warning_flag := FND_API.G_TRUE;
8520: 'for the WIP Job ' || curr_WIP_job_rec.JOB_NAME ||
8521: '. SQLCODE = ' || SQLCODE || '. SQLERRM = ' || SQLERRM);
8522: end if;
8523:
8524: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
8526: END IF;
8527:
8528: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMP_JOB_ERR');
8521: '. SQLCODE = ' || SQLCODE || '. SQLERRM = ' || SQLERRM);
8522: end if;
8523:
8524: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
8526: END IF;
8527:
8528: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMP_JOB_ERR');
8529: -- Unknown error encountered while importing WIP debrief lines to Estimates for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
8529: -- Unknown error encountered while importing WIP debrief lines to Estimates for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
8530: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8531: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8532: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8533: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8534: END;
8535: END LOOP; -- for cursor c_eligible_WIP_Jobs
8536:
8537: if (lc_stat_level >= lc_debug_level) then
8542: IF( l_wip_count <= 0 ) THEN
8543: x_warning_flag := FND_API.G_TRUE;
8544: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_INELIGIBLE_WIP');
8545: -- No eligible WIP jobs found for import
8546: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
8547: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
8548: FND_MSG_PUB.add;
8549:
8550: -- if no lines were imported, then raise an error so we can rollback and save
8543: x_warning_flag := FND_API.G_TRUE;
8544: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_INELIGIBLE_WIP');
8545: -- No eligible WIP jobs found for import
8546: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
8547: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
8548: FND_MSG_PUB.add;
8549:
8550: -- if no lines were imported, then raise an error so we can rollback and save
8551: -- any pre-existing lines from being deleted/archived.
8544: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_INELIGIBLE_WIP');
8545: -- No eligible WIP jobs found for import
8546: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
8547: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
8548: FND_MSG_PUB.add;
8549:
8550: -- if no lines were imported, then raise an error so we can rollback and save
8551: -- any pre-existing lines from being deleted/archived.
8552: RAISE FND_API.G_EXC_ERROR;
8554:
8555: IF( l_total_estimates_lines <= 0 ) THEN
8556: x_warning_flag := FND_API.G_TRUE;
8557: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_LINES_ELIGIBLE_WIP');
8558: FND_MSG_PUB.add;
8559:
8560: -- if no lines were imported, then raise an error so we can rollback and save
8561: -- any pre-existing lines from being deleted/archived.
8562: RAISE FND_API.G_EXC_ERROR;
8580: EXCEPTION
8581: WHEN FND_API.G_EXC_ERROR THEN
8582: x_return_status := FND_API.G_RET_STS_ERROR;
8583: ROLLBACK TO Import_Estimates_wip_sp;
8584: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8585: p_data => x_msg_data );
8586:
8587: -- save message in debug log
8588: IF (lc_excep_level >= lc_debug_level) THEN
8592:
8593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8595: ROLLBACK TO Import_Estimates_wip_sp;
8596: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8597: p_data => x_msg_data );
8598:
8599: -- save message in debug log
8600: IF (lc_excep_level >= lc_debug_level) THEN
8605: WHEN OTHERS THEN
8606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8607: ROLLBACK TO Import_Estimates_wip_sp;
8608:
8609: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
8611: END IF;
8612:
8613: -- save message in debug log
8606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8607: ROLLBACK TO Import_Estimates_wip_sp;
8608:
8609: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
8611: END IF;
8612:
8613: -- save message in debug log
8614: IF (lc_excep_level >= lc_debug_level) THEN
8619: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_OTHERS');
8620: -- Unknown error encountered while importing WIP lines to Estimates. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
8621: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8622: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8623: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8624: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8625: p_data => x_msg_data );
8626: END Import_Estimates_From_Wip;
8627:
8620: -- Unknown error encountered while importing WIP lines to Estimates. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
8621: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8622: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8623: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8624: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8625: p_data => x_msg_data );
8626: END Import_Estimates_From_Wip;
8627:
8628: END Csd_Repair_Estimate_Pvt;