[Home] [Help]
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF Fnd_Api.to_Boolean(p_init_msg_list)
69: THEN
70: Fnd_Msg_Pub.initialize;
71: END IF;
72:
73: -- Initialize API return status to success
74: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
241: END IF;
242:
243: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ACTION');
244: Fnd_Message.SET_TOKEN('ACTION', p_action);
245: Fnd_Msg_Pub.ADD;
246: RAISE Fnd_Api.G_EXC_ERROR;
247:
248: END IF;
249:
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
262: ROLLBACK TO process_estimate_lines;
260: EXCEPTION
261: WHEN Fnd_Api.G_EXC_ERROR THEN
262: ROLLBACK TO process_estimate_lines;
263: x_return_status := Fnd_Api.G_RET_STS_ERROR;
264: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
265: p_data => x_msg_data);
266: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
267: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
268: ROLLBACK TO process_estimate_lines;
265: p_data => x_msg_data);
266: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
267: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
268: ROLLBACK TO process_estimate_lines;
269: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
270: p_data => x_msg_data);
271: WHEN OTHERS THEN
272: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
273: ROLLBACK TO process_estimate_lines;
270: p_data => x_msg_data);
271: WHEN OTHERS THEN
272: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
273: ROLLBACK TO process_estimate_lines;
274: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
275: THEN
276: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
277: END IF;
278: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
272: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
273: ROLLBACK TO process_estimate_lines;
274: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
275: THEN
276: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
277: END IF;
278: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
279: p_data => x_msg_data);
280: END process_estimate_lines;
274: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
275: THEN
276: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
277: END IF;
278: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
279: p_data => x_msg_data);
280: END process_estimate_lines;
281:
282: /*--------------------------------------------------*/
330:
331: -- Initialize message list if p_init_msg_list is set to TRUE.
332: IF Fnd_Api.to_Boolean(p_init_msg_list)
333: THEN
334: Fnd_Msg_Pub.initialize;
335: END IF;
336:
337: -- Initialize API return status to success
338: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
376: WHEN NO_DATA_FOUND THEN
377: NULL;
378: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_NO_DATA');
379: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
380: -- FND_MSG_PUB.ADD;
381: -- RAISE FND_API.G_EXC_ERROR;
382: WHEN OTHERS THEN
383: NULL;
384: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_OTHERS');
382: WHEN OTHERS THEN
383: NULL;
384: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_OTHERS');
385: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
386: -- FND_MSG_PUB.ADD;
387: -- RAISE FND_API.G_EXC_ERROR;
388: END;
389:
390: IF (l_repair_group_id IS NOT NULL)
542: IF l_return_status <> 'S'
543: THEN
544: x_return_status := Fnd_Api.G_RET_STS_ERROR;
545: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_GROUP_EST_FAIL');
546: Fnd_Msg_Pub.ADD;
547: RAISE Fnd_Api.G_EXC_ERROR;
548: ELSIF l_return_status = 'S'
549: THEN
550: x_object_version_number := l_rep_group_rec.object_version_number;
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;
566:
567: EXCEPTION
568: WHEN Fnd_Api.G_EXC_ERROR THEN
569: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
570: x_return_status := Fnd_Api.G_RET_STS_ERROR;
571: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
572: p_data => x_msg_data);
573: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
574: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
575: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
572: p_data => x_msg_data);
573: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
574: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
575: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
576: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
577: p_data => x_msg_data);
578: WHEN OTHERS THEN
579: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
580: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
577: p_data => x_msg_data);
578: WHEN OTHERS THEN
579: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
580: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
581: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
584: END IF;
585: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
579: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
580: ROLLBACK TO UPDATE_RO_GROUP_ESTIMATE;
581: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
584: END IF;
585: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
586: p_data => x_msg_data);
587:
581: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
584: END IF;
585: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
586: p_data => x_msg_data);
587:
588: END UPDATE_RO_GROUP_ESTIMATE;
589:
630:
631: -- Initialize message list if p_init_msg_list is set to TRUE.
632: IF Fnd_Api.to_Boolean(p_init_msg_list)
633: THEN
634: Fnd_Msg_Pub.initialize;
635: END IF;
636:
637: -- Initialize API return status to success
638: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
725:
726: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');
727: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
728: x_estimate_rec.repair_line_id);
729: Fnd_Msg_Pub.ADD;
730: RAISE Fnd_Api.G_EXC_ERROR;
731: END IF;
732:
733: IF (g_debug > 0)
745: WHEN NO_DATA_FOUND THEN
746: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
747: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
748: x_estimate_rec.estimate_status);
749: Fnd_Msg_Pub.ADD;
750: RAISE Fnd_Api.G_EXC_ERROR;
751: END;
752: /*
753: IF l_est_status_code in ('ACCEPTED','REJECTED') then
755: IF x_estimate_rec.estimate_reason_code is null then
756:
757: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
758: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
759: FND_MSG_PUB.ADD;
760: RAISE FND_API.G_EXC_ERROR;
761:
762: END IF;
763:
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
839: x_return_status := Fnd_Api.G_RET_STS_ERROR;
837: EXCEPTION
838: WHEN Fnd_Api.G_EXC_ERROR THEN
839: x_return_status := Fnd_Api.G_RET_STS_ERROR;
840: ROLLBACK TO create_repair_estimate;
841: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
842: p_data => x_msg_data);
843: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
844: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
845: ROLLBACK TO create_repair_estimate;
842: p_data => x_msg_data);
843: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
844: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
845: ROLLBACK TO create_repair_estimate;
846: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
847: p_data => x_msg_data);
848: WHEN OTHERS THEN
849: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
850: ROLLBACK TO create_repair_estimate;
847: p_data => x_msg_data);
848: WHEN OTHERS THEN
849: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
850: ROLLBACK TO create_repair_estimate;
851: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
852: THEN
853: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
854: END IF;
855: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
849: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
850: ROLLBACK TO create_repair_estimate;
851: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
852: THEN
853: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
854: END IF;
855: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
856: p_data => x_msg_data);
857: END create_repair_estimate;
851: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
852: THEN
853: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
854: END IF;
855: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
856: p_data => x_msg_data);
857: END create_repair_estimate;
858:
859: /*--------------------------------------------------*/
908:
909: -- Initialize message list if p_init_msg_list is set to TRUE.
910: IF Fnd_Api.to_Boolean(p_init_msg_list)
911: THEN
912: Fnd_Msg_Pub.initialize;
913: END IF;
914:
915: -- Initialize API return status to success
916: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
956: IF repair_estimate%NOTFOUND
957: THEN
958: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
959: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
960: Fnd_Msg_Pub.ADD;
961: RAISE Fnd_Api.G_EXC_ERROR;
962: END IF;
963:
964: IF repair_estimate%ISOPEN
977: END IF;
978:
979: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
980: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
981: Fnd_Msg_Pub.ADD;
982: RAISE Fnd_Api.G_EXC_ERROR;
983: END IF;
984:
985: IF (g_debug > 0)
997: WHEN NO_DATA_FOUND THEN
998: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
999: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
1000: x_estimate_rec.estimate_status);
1001: Fnd_Msg_Pub.ADD;
1002: RAISE Fnd_Api.G_EXC_ERROR;
1003: END;
1004: /*
1005: IF l_est_status_code in ('ACCEPTED','REJECTED') then
1007: IF x_estimate_rec.estimate_reason_code is null then
1008:
1009: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
1010: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
1011: FND_MSG_PUB.ADD;
1012: RAISE FND_API.G_EXC_ERROR;
1013:
1014: END IF;
1015: END IF;
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
1106: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1104: EXCEPTION
1105: WHEN Fnd_Api.G_EXC_ERROR THEN
1106: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1107: ROLLBACK TO update_repair_estimate;
1108: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1109: p_data => x_msg_data);
1110: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1112: ROLLBACK TO update_repair_estimate;
1109: p_data => x_msg_data);
1110: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1112: ROLLBACK TO update_repair_estimate;
1113: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1114: p_data => x_msg_data);
1115: WHEN OTHERS THEN
1116: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1117: ROLLBACK TO update_repair_estimate;
1114: p_data => x_msg_data);
1115: WHEN OTHERS THEN
1116: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1117: ROLLBACK TO update_repair_estimate;
1118: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1121: END IF;
1122: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1116: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1117: ROLLBACK TO update_repair_estimate;
1118: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1121: END IF;
1122: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1123: p_data => x_msg_data);
1124: END update_repair_estimate;
1118: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1121: END IF;
1122: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1123: p_data => x_msg_data);
1124: END update_repair_estimate;
1125:
1126: /*--------------------------------------------------*/
1165:
1166: -- Initialize message list if p_init_msg_list is set to TRUE.
1167: IF Fnd_Api.to_Boolean(p_init_msg_list)
1168: THEN
1169: Fnd_Msg_Pub.initialize;
1170: END IF;
1171:
1172: -- Initialize API return status to success
1173: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1220: END IF;
1221:
1222: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
1223: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1224: Fnd_Msg_Pub.ADD;
1225: RAISE Fnd_Api.G_EXC_ERROR;
1226: END;
1227:
1228: BEGIN
1243: END IF;
1244:
1245: Fnd_Message.SET_NAME('CSD', 'CSD_ESTIMATE_LINE_EXISTS');
1246: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1247: Fnd_Msg_Pub.ADD;
1248: RAISE Fnd_Api.G_EXC_ERROR;
1249: END IF;
1250:
1251: IF NVL(l_approval_status, 'Z') <> 'A'
1258: Csd_Repair_Estimate_Pkg.Delete_Row(p_REPAIR_ESTIMATE_ID => p_estimate_id);
1259: ELSE
1260: Fnd_Message.SET_NAME('CSD', 'CSD_EST_DELETE_NOT_ALLOWED');
1261: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1262: Fnd_Msg_Pub.ADD;
1263: RAISE Fnd_Api.G_EXC_ERROR;
1264: END IF;
1265:
1266: -- Api body ends here
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
1278: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1276: EXCEPTION
1277: WHEN Fnd_Api.G_EXC_ERROR THEN
1278: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1279: ROLLBACK TO delete_repair_estimate;
1280: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1281: p_data => x_msg_data);
1282: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1283: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1284: ROLLBACK TO delete_repair_estimate;
1281: p_data => x_msg_data);
1282: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1283: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1284: ROLLBACK TO delete_repair_estimate;
1285: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1286: p_data => x_msg_data);
1287: WHEN OTHERS THEN
1288: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1289: ROLLBACK TO delete_repair_estimate;
1286: p_data => x_msg_data);
1287: WHEN OTHERS THEN
1288: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1289: ROLLBACK TO delete_repair_estimate;
1290: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1291: THEN
1292: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1293: END IF;
1294: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1288: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1289: ROLLBACK TO delete_repair_estimate;
1290: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1291: THEN
1292: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1293: END IF;
1294: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1295: p_data => x_msg_data);
1296: END delete_repair_estimate;
1290: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1291: THEN
1292: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1293: END IF;
1294: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1295: p_data => x_msg_data);
1296: END delete_repair_estimate;
1297:
1298: /*--------------------------------------------------*/
1331:
1332: -- Initialize message list if p_init_msg_list is set to TRUE.
1333: IF Fnd_Api.to_Boolean(p_init_msg_list)
1334: THEN
1335: Fnd_Msg_Pub.initialize;
1336: END IF;
1337:
1338: -- Initialize API return status to success
1339: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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
1355: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1353: EXCEPTION
1354: WHEN Fnd_Api.G_EXC_ERROR THEN
1355: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1356: ROLLBACK TO lock_repair_estimate;
1357: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1358: p_data => x_msg_data);
1359: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1360: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1361: ROLLBACK TO lock_repair_estimate;
1358: p_data => x_msg_data);
1359: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1360: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1361: ROLLBACK TO lock_repair_estimate;
1362: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1363: p_data => x_msg_data);
1364: WHEN OTHERS THEN
1365: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1366: ROLLBACK TO lock_repair_estimate;
1363: p_data => x_msg_data);
1364: WHEN OTHERS THEN
1365: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1366: ROLLBACK TO lock_repair_estimate;
1367: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1368: THEN
1369: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1370: END IF;
1371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1365: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1366: ROLLBACK TO lock_repair_estimate;
1367: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1368: THEN
1369: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1370: END IF;
1371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1372: p_data => x_msg_data);
1373: END lock_repair_estimate;
1367: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1368: THEN
1369: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1370: END IF;
1371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1372: p_data => x_msg_data);
1373: END lock_repair_estimate;
1374:
1375: /*--------------------------------------------------*/
1440:
1441: -- Initialize message list if p_init_msg_list is set to TRUE.
1442: IF Fnd_Api.to_Boolean(p_init_msg_list)
1443: THEN
1444: Fnd_Msg_Pub.initialize;
1445: END IF;
1446:
1447: -- Initialize API return status to success
1448: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1542: WHEN NO_DATA_FOUND THEN
1543: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
1544: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
1545: x_estimate_line_rec.repair_line_id);
1546: Fnd_Msg_Pub.ADD;
1547: RAISE Fnd_Api.G_EXC_ERROR;
1548: END;
1549:
1550: IF (g_debug > 0)
1611: Exception
1612: When no_data_found then
1613: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
1614: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
1615: FND_MSG_PUB.ADD;
1616: IF (g_debug > 0 ) THEN
1617: csd_gen_utility_pvt.ADD('Contract Line Id missing');
1618: END IF;
1619:
1644: IF order_rec%NOTFOUND OR l_party_id IS NULL
1645: THEN
1646: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
1647: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
1648: Fnd_Msg_Pub.ADD;
1649: RAISE Fnd_Api.G_EXC_ERROR;
1650: END IF;
1651:
1652: IF order_rec%ISOPEN
1720: THEN
1721: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
1722: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1723: x_estimate_line_rec.txn_billing_type_id);
1724: Fnd_Msg_Pub.ADD;
1725: RAISE Fnd_Api.G_EXC_ERROR;
1726: END IF;
1727:
1728: -- Get the currency code
1739: Fnd_Message.SET_NAME('CSD',
1740: 'CSD_API_INV_PRICE_LIST_ID');
1741: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1742: x_estimate_line_rec.price_list_id);
1743: Fnd_Msg_Pub.ADD;
1744: RAISE Fnd_Api.G_EXC_ERROR;
1745: END;
1746: END IF;
1747:
1755: THEN
1756: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
1757: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1758: x_estimate_line_rec.price_list_id);
1759: Fnd_Msg_Pub.ADD;
1760: RAISE Fnd_Api.G_EXC_ERROR;
1761: END IF;
1762:
1763: --
1785: -- csd_gen_utility_pvt.ADD('Could not get item cost' );
1786: --END IF;
1787: --
1788: -- FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_COST_MISSING');
1789: -- FND_MSG_PUB.ADD;
1790: -- RAISE FND_API.G_EXC_ERROR;
1791: -- END;
1792: -- END IF;
1793: --
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
1907: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1905: EXCEPTION
1906: WHEN Fnd_Api.G_EXC_ERROR THEN
1907: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1908: ROLLBACK TO create_repair_estimate_lines;
1909: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1910: p_data => x_msg_data);
1911: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1912: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1913: ROLLBACK TO create_repair_estimate_lines;
1910: p_data => x_msg_data);
1911: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1912: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1913: ROLLBACK TO create_repair_estimate_lines;
1914: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1915: p_data => x_msg_data);
1916: WHEN OTHERS THEN
1917: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1918: ROLLBACK TO create_repair_estimate_lines;
1915: p_data => x_msg_data);
1916: WHEN OTHERS THEN
1917: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1918: ROLLBACK TO create_repair_estimate_lines;
1919: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1920: THEN
1921: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1922: END IF;
1923: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1917: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1918: ROLLBACK TO create_repair_estimate_lines;
1919: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1920: THEN
1921: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1922: END IF;
1923: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1924: p_data => x_msg_data);
1925: END create_repair_estimate_lines;
1919: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1920: THEN
1921: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1922: END IF;
1923: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1924: p_data => x_msg_data);
1925: END create_repair_estimate_lines;
1926:
1927: /*--------------------------------------------------*/
1991:
1992: -- Initialize message list if p_init_msg_list is set to TRUE.
1993: IF Fnd_Api.to_Boolean(p_init_msg_list)
1994: THEN
1995: Fnd_Msg_Pub.initialize;
1996: END IF;
1997:
1998: -- Initialize API return status to success
1999: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2060:
2061: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
2062: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2063: x_estimate_line_rec.repair_estimate_line_id);
2064: Fnd_Msg_Pub.ADD;
2065: RAISE Fnd_Api.G_EXC_ERROR;
2066: END IF;
2067:
2068: IF NVL(x_estimate_line_rec.estimate_detail_id, Fnd_Api.G_MISS_NUM) <>
2141: Exception
2142: When no_data_found then
2143: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
2144: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
2145: FND_MSG_PUB.ADD;
2146: IF (g_debug > 0 ) THEN
2147: csd_gen_utility_pvt.ADD('Contract Line Id missing');
2148: END IF;
2149:
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
2304: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2302: EXCEPTION
2303: WHEN Fnd_Api.G_EXC_ERROR THEN
2304: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2305: ROLLBACK TO update_repair_estimate_lines;
2306: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2307: p_data => x_msg_data);
2308: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2309: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2310: ROLLBACK TO update_repair_estimate_lines;
2307: p_data => x_msg_data);
2308: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2309: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2310: ROLLBACK TO update_repair_estimate_lines;
2311: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2312: p_data => x_msg_data);
2313: WHEN OTHERS THEN
2314: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2315: ROLLBACK TO update_repair_estimate_lines;
2312: p_data => x_msg_data);
2313: WHEN OTHERS THEN
2314: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2315: ROLLBACK TO update_repair_estimate_lines;
2316: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2317: THEN
2318: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2319: END IF;
2320: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2314: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2315: ROLLBACK TO update_repair_estimate_lines;
2316: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2317: THEN
2318: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2319: END IF;
2320: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2321: p_data => x_msg_data);
2322: END update_repair_estimate_lines;
2316: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2317: THEN
2318: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2319: END IF;
2320: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2321: p_data => x_msg_data);
2322: END update_repair_estimate_lines;
2323:
2324: /*--------------------------------------------------*/
2361:
2362: -- Initialize message list if p_init_msg_list is set to TRUE.
2363: IF Fnd_Api.to_Boolean(p_init_msg_list)
2364: THEN
2365: Fnd_Msg_Pub.initialize;
2366: END IF;
2367:
2368: -- Initialize API return status to success
2369: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2427:
2428: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
2429: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2430: p_estimate_line_id);
2431: Fnd_Msg_Pub.ADD;
2432: RAISE Fnd_Api.G_EXC_ERROR;
2433: END;
2434:
2435: IF (g_debug > 0)
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
2494: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2492: EXCEPTION
2493: WHEN Fnd_Api.G_EXC_ERROR THEN
2494: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2495: ROLLBACK TO delete_repair_estimate_lines;
2496: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2497: p_data => x_msg_data);
2498: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2500: ROLLBACK TO delete_repair_estimate_lines;
2497: p_data => x_msg_data);
2498: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2500: ROLLBACK TO delete_repair_estimate_lines;
2501: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2502: p_data => x_msg_data);
2503: WHEN OTHERS THEN
2504: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2505: ROLLBACK TO delete_repair_estimate_lines;
2502: p_data => x_msg_data);
2503: WHEN OTHERS THEN
2504: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2505: ROLLBACK TO delete_repair_estimate_lines;
2506: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2507: THEN
2508: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2509: END IF;
2510: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2504: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2505: ROLLBACK TO delete_repair_estimate_lines;
2506: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2507: THEN
2508: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2509: END IF;
2510: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2511: p_data => x_msg_data);
2512: END delete_repair_estimate_lines;
2506: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2507: THEN
2508: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2509: END IF;
2510: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2511: p_data => x_msg_data);
2512: END delete_repair_estimate_lines;
2513:
2514: /*--------------------------------------------------*/
2547:
2548: -- Initialize message list if p_init_msg_list is set to TRUE.
2549: IF Fnd_Api.to_Boolean(p_init_msg_list)
2550: THEN
2551: Fnd_Msg_Pub.initialize;
2552: END IF;
2553:
2554: -- Initialize API return status to success
2555: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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
2571: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2569: EXCEPTION
2570: WHEN Fnd_Api.G_EXC_ERROR THEN
2571: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2572: ROLLBACK TO lock_repair_estimate_lines;
2573: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2574: p_data => x_msg_data);
2575: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2576: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2577: ROLLBACK TO lock_repair_estimate_lines;
2574: p_data => x_msg_data);
2575: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2576: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2577: ROLLBACK TO lock_repair_estimate_lines;
2578: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2579: p_data => x_msg_data);
2580: WHEN OTHERS THEN
2581: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2582: ROLLBACK TO lock_repair_estimate_lines;
2579: p_data => x_msg_data);
2580: WHEN OTHERS THEN
2581: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2582: ROLLBACK TO lock_repair_estimate_lines;
2583: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2584: THEN
2585: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2586: END IF;
2587: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2581: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2582: ROLLBACK TO lock_repair_estimate_lines;
2583: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2584: THEN
2585: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2586: END IF;
2587: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2588: p_data => x_msg_data);
2589: END lock_repair_estimate_lines;
2583: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2584: THEN
2585: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2586: END IF;
2587: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2588: p_data => x_msg_data);
2589: END lock_repair_estimate_lines;
2590:
2591: PROCEDURE REPAIR_ESTIMATE_PRINT(p_api_version IN NUMBER,
2637: END IF;
2638: -- Initialize message list if p_init_msg_list is set to TRUE.
2639: IF Fnd_Api.to_Boolean(p_init_msg_list)
2640: THEN
2641: Fnd_Msg_Pub.initialize;
2642: END IF;
2643: -- Initialize API return status to success
2644: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2645: -- start of the concurrent submission
2678: Csd_Gen_Utility_Pvt.ADD('Set Print Option Failed');
2679: END IF;
2680: Fnd_Message.SET_NAME('CSD', 'CSD_EST_PRINT_OPTION_ERROR');
2681: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2682: Fnd_Msg_Pub.ADD;
2683: END IF;
2684: ELSIF (l_print_required = 'Y')
2685: THEN
2686: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRINTER_SETUP');
2684: ELSIF (l_print_required = 'Y')
2685: THEN
2686: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRINTER_SETUP');
2687: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2688: Fnd_Msg_Pub.ADD;
2689: END IF;
2690: -- valase:6499519, rfieldma: 6532016 below
2691: -- get print mode
2692: l_print_mode := FND_PROFILE.value('CSD_ESTRT_PRINT_MODE');
2706: IF (l_template_code is null) THEN
2707: Fnd_Message.SET_NAME('CSD', 'CSD_XDO_ESTRT_NO_TEMPLATE');
2708: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));
2709: x_request_id := l_request_id;
2710: Fnd_Msg_Pub.ADD;
2711: RAISE Fnd_Api.G_EXC_ERROR;
2712: END IF;
2713: -- get current session language and territory
2714: OPEN get_lang_terr;
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
2765: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2763: EXCEPTION
2764: WHEN Fnd_Api.G_EXC_ERROR THEN
2765: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2766: ROLLBACK TO estimate_print;
2767: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2768: p_data => x_msg_data);
2769: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2770: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2771: ROLLBACK TO estimate_print;
2768: p_data => x_msg_data);
2769: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2770: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2771: ROLLBACK TO estimate_print;
2772: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2773: p_data => x_msg_data);
2774: WHEN OTHERS THEN
2775: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2776: ROLLBACK TO estimate_print;
2773: p_data => x_msg_data);
2774: WHEN OTHERS THEN
2775: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2776: ROLLBACK TO estimate_print;
2777: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2778: THEN
2779: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2780: END IF;
2781: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2775: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2776: ROLLBACK TO estimate_print;
2777: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2778: THEN
2779: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2780: END IF;
2781: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2782: p_data => x_msg_data);
2783: END REPAIR_ESTIMATE_PRINT;
2777: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2778: THEN
2779: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2780: END IF;
2781: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
2782: p_data => x_msg_data);
2783: END REPAIR_ESTIMATE_PRINT;
2784:
2785: PROCEDURE SUBMIT_REPAIR_ESTIMATE_LINES(p_api_version IN NUMBER,
2838:
2839: -- Initialize message list if p_init_msg_list is set to TRUE.
2840: IF Fnd_Api.to_Boolean(p_init_msg_list)
2841: THEN
2842: Fnd_Msg_Pub.initialize;
2843: END IF;
2844:
2845: -- Initialize API return status to success
2846: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2853: EXCEPTION
2854: WHEN NO_DATA_FOUND THEN
2855: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2856: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2857: Fnd_Msg_Pub.ADD;
2858: RAISE Fnd_Api.G_EXC_ERROR;
2859: END;
2860:
2861: IF l_org_src_ref = 'RMA'
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN
2994: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2995: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2996: Fnd_Msg_Pub.ADD;
2997: RAISE Fnd_Api.G_EXC_ERROR;
2998: END;
2999:
3000: IF (g_debug > 0)
3029: WHERE oe.header_id = ced.order_header_id
3030: AND ced.estimate_detail_id = l_last_est_detail_id;
3031: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3032: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);
3033: Fnd_Msg_Pub.ADD;
3034: EXCEPTION
3035: WHEN NO_DATA_FOUND THEN
3036: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOT_INTERFACED');
3037: Fnd_Msg_Pub.ADD;
3033: Fnd_Msg_Pub.ADD;
3034: EXCEPTION
3035: WHEN NO_DATA_FOUND THEN
3036: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOT_INTERFACED');
3037: Fnd_Msg_Pub.ADD;
3038: IF (g_debug > 0)
3039: THEN
3040: Csd_Gen_Utility_Pvt.ADD('Estimate not interfaced to OM ');
3041: END IF;
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
3055: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3053: EXCEPTION
3054: WHEN Fnd_Api.G_EXC_ERROR THEN
3055: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3056: ROLLBACK TO submit_estimate_lines;
3057: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3058: p_data => x_msg_data);
3059: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3060: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3061: ROLLBACK TO submit_estimate_lines;
3058: p_data => x_msg_data);
3059: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3060: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3061: ROLLBACK TO submit_estimate_lines;
3062: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3063: p_data => x_msg_data);
3064: WHEN OTHERS THEN
3065: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3066: ROLLBACK TO submit_estimate_lines;
3063: p_data => x_msg_data);
3064: WHEN OTHERS THEN
3065: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3066: ROLLBACK TO submit_estimate_lines;
3067: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3068: THEN
3069: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3070: END IF;
3071: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3065: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3066: ROLLBACK TO submit_estimate_lines;
3067: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3068: THEN
3069: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3070: END IF;
3071: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3072: p_data => x_msg_data);
3073:
3067: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3068: THEN
3069: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3070: END IF;
3071: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3072: p_data => x_msg_data);
3073:
3074: END SUBMIT_REPAIR_ESTIMATE_LINES;
3075:
3222:
3223: -- Initialize message list if p_init_msg_list is set to TRUE.
3224: IF Fnd_Api.to_Boolean(p_init_msg_list)
3225: THEN
3226: Fnd_Msg_Pub.initialize;
3227: END IF;
3228:
3229: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
3230: THEN
3546: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3547: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3548: lc_mod_name,
3549: 'Number of messages in stack: ' ||
3550: Fnd_Msg_Pub.count_msg);
3551: END IF;
3552: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
3553: p_commit => Fnd_Api.G_FALSE,
3554: p_init_msg_list => Fnd_Api.G_FALSE,
3572: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3573: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3574: lc_mod_name,
3575: 'Number of messages in stack: ' ||
3576: Fnd_Msg_Pub.count_msg);
3577: END IF;
3578: END IF;
3579:
3580: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
3688: 'Adding message CSD_EST_SC_APPLIED_ERR to FND_MSG stack');
3689: END IF;
3690: Fnd_Message.SET_NAME('CSD',
3691: 'CSD_EST_SC_APPLIED_ERR');
3692: Fnd_Msg_Pub.ADD;
3693: IF (Fnd_Log.Level_Procedure >=
3694: Fnd_Log.G_Current_Runtime_Level)
3695: THEN
3696: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3698: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3699: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3700: lc_mod_name,
3701: 'Number of messages in stack: ' ||
3702: Fnd_Msg_Pub.count_msg);
3703: END IF;
3704: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
3705: p_commit => Fnd_Api.G_FALSE,
3706: p_init_msg_list => Fnd_Api.G_FALSE,
3727: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3728: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3729: lc_mod_name,
3730: 'Number of messages in stack: ' ||
3731: Fnd_Msg_Pub.count_msg);
3732: END IF;
3733: END IF;
3734: END IF;
3735: ELSE
3769: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');
3770: END IF;
3771: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3772: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3773: Fnd_Msg_Pub.ADD;
3774: IF (Fnd_Log.Level_Procedure >=
3775: Fnd_Log.G_Current_Runtime_Level)
3776: THEN
3777: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3779: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3780: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3781: lc_mod_name,
3782: 'Number of messages in stack: ' ||
3783: Fnd_Msg_Pub.count_msg);
3784: END IF;
3785: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
3786: p_commit => Fnd_Api.G_FALSE,
3787: p_init_msg_list => Fnd_Api.G_FALSE,
3807: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
3808: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
3809: lc_mod_name,
3810: 'Number of messages in stack: ' ||
3811: Fnd_Msg_Pub.count_msg);
3812: END IF;
3813: END IF;
3814: END LOOP;
3815:
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)
3832: THEN
3856: lc_mod_name,
3857: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');
3858: END IF;
3859: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');
3860: Fnd_Msg_Pub.ADD;
3861: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3862: p_data => x_msg_data);
3863:
3864: -- save message in debug log
3857: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');
3858: END IF;
3859: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');
3860: Fnd_Msg_Pub.ADD;
3861: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3862: p_data => x_msg_data);
3863:
3864: -- save message in debug log
3865: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3881: lc_mod_name,
3882: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');
3883: END IF;
3884: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');
3885: Fnd_Msg_Pub.ADD;
3886: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3887: p_data => x_msg_data);
3888:
3889: -- save message in debug log
3882: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');
3883: END IF;
3884: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');
3885: Fnd_Msg_Pub.ADD;
3886: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3887: p_data => x_msg_data);
3888:
3889: -- save message in debug log
3890: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3916: WHERE lookup_type = 'CSD_REPAIR_MODE'
3917: AND lookup_code = p_repair_mode;
3918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_INAPPL_MODE');
3919: Fnd_Message.SET_TOKEN('MODE', l_repair_mode_name);
3920: Fnd_Msg_Pub.ADD;
3921: EXCEPTION
3922: WHEN NO_DATA_FOUND THEN
3923: l_repair_mode_name := p_repair_mode;
3924: END;
3921: EXCEPTION
3922: WHEN NO_DATA_FOUND THEN
3923: l_repair_mode_name := p_repair_mode;
3924: END;
3925: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3926: p_data => x_msg_data);
3927:
3928: -- save message in debug log
3929: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3944: 'Adding message err_name to FND_MSG stack');
3945: end if;
3946: FND_MESSAGE.SET_NAME('CSD','err_name');
3947: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
3948: FND_MSG_PUB.ADD;
3949: */
3950: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3951: p_data => x_msg_data);
3952:
3946: FND_MESSAGE.SET_NAME('CSD','err_name');
3947: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
3948: FND_MSG_PUB.ADD;
3949: */
3950: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3951: p_data => x_msg_data);
3952:
3953: -- save message in debug log
3954: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3961: ROLLBACK TO Autocreate_Estimate_Lines;
3962: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3963:
3964: -- save message in fnd stack
3965: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3966: THEN
3967: IF (Fnd_Log.Level_Statement >=
3968: Fnd_Log.G_Current_Runtime_Level)
3969: THEN
3968: Fnd_Log.G_Current_Runtime_Level)
3969: THEN
3970: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3971: lc_mod_name,
3972: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3973: END IF;
3974: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
3975: END IF;
3976: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3970: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3971: lc_mod_name,
3972: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3973: END IF;
3974: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
3975: END IF;
3976: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3977: p_data => x_msg_data);
3978:
3972: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3973: END IF;
3974: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
3975: END IF;
3976: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3977: p_data => x_msg_data);
3978:
3979: -- save message in debug log
3980: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
3987: ROLLBACK TO Autocreate_Estimate_Lines;
3988: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3989:
3990: -- save message in fnd stack
3991: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3992: THEN
3993: IF (Fnd_Log.Level_Statement >=
3994: Fnd_Log.G_Current_Runtime_Level)
3995: THEN
3994: Fnd_Log.G_Current_Runtime_Level)
3995: THEN
3996: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3997: lc_mod_name,
3998: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3999: END IF;
4000: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4001: END IF;
4002: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3996: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3997: lc_mod_name,
3998: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3999: END IF;
4000: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4001: END IF;
4002: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4003: p_data => x_msg_data);
4004:
3998: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
3999: END IF;
4000: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
4001: END IF;
4002: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4003: p_data => x_msg_data);
4004:
4005: -- save message in debug log
4006: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
4622:
4623: -- Initialize message list if p_init_msg_list is set to TRUE.
4624: IF Fnd_Api.to_Boolean(p_init_msg_list)
4625: THEN
4626: Fnd_Msg_Pub.initialize;
4627: END IF;
4628:
4629: -- Initialize API return status to success
4630: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4917: END IF;
4918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');
4919: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4920: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4921: Fnd_Msg_Pub.ADD;
4922: IF (Fnd_Log.Level_Procedure >=
4923: Fnd_Log.G_Current_Runtime_Level)
4924: THEN
4925: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4927: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4928: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4929: lc_mod_name,
4930: 'Number of messages in stack: ' ||
4931: Fnd_Msg_Pub.count_msg);
4932: END IF;
4933: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
4934: p_commit => Fnd_Api.G_FALSE,
4935: p_init_msg_list => Fnd_Api.G_FALSE,
4953: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
4954: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
4955: lc_mod_name,
4956: 'Number of messages in stack: ' ||
4957: Fnd_Msg_Pub.count_msg);
4958: END IF;
4959: END LOOP;
4960: END;
4961:
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
5172: x_warning_flag := Fnd_Api.G_TRUE;
5178: lc_mod_name,
5179: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5180: END IF;
5181: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5182: Fnd_Msg_Pub.ADD;
5183: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5184: p_data => x_msg_data);
5185:
5186: -- save message in debug log
5179: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5180: END IF;
5181: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5182: Fnd_Msg_Pub.ADD;
5183: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5184: p_data => x_msg_data);
5185:
5186: -- save message in debug log
5187: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5203: 'Adding message ERR_NAME to FND_MSG stack');
5204: end if;
5205: FND_MESSAGE.SET_NAME('CSD','err_name');
5206: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5207: FND_MSG_PUB.ADD;
5208: */
5209: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5210: p_data => x_msg_data);
5211:
5205: FND_MESSAGE.SET_NAME('CSD','err_name');
5206: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5207: FND_MSG_PUB.ADD;
5208: */
5209: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5210: p_data => x_msg_data);
5211:
5212: -- save message in debug log
5213: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5221: ROLLBACK TO Get_Estimates_From_Task;
5222: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5223:
5224: -- save message in fnd stack
5225: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5226: THEN
5227: IF (Fnd_Log.Level_Statement >=
5228: Fnd_Log.G_Current_Runtime_Level)
5229: THEN
5228: Fnd_Log.G_Current_Runtime_Level)
5229: THEN
5230: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5231: lc_mod_name,
5232: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5233: END IF;
5234: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5235: END IF;
5236: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5230: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5231: lc_mod_name,
5232: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5233: END IF;
5234: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5235: END IF;
5236: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5237: p_data => x_msg_data);
5238:
5232: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5233: END IF;
5234: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5235: END IF;
5236: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5237: p_data => x_msg_data);
5238:
5239: -- save message in debug log
5240: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5248: ROLLBACK TO Get_Estimates_From_Task;
5249: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5250:
5251: -- save message in fnd stack
5252: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5253: THEN
5254: IF (Fnd_Log.Level_Statement >=
5255: Fnd_Log.G_Current_Runtime_Level)
5256: THEN
5255: Fnd_Log.G_Current_Runtime_Level)
5256: THEN
5257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5258: lc_mod_name,
5259: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5260: END IF;
5261: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5262: END IF;
5263: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5257: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5258: lc_mod_name,
5259: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5260: END IF;
5261: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5262: END IF;
5263: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5264: p_data => x_msg_data);
5265:
5259: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5260: END IF;
5261: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5262: END IF;
5263: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5264: p_data => x_msg_data);
5265:
5266: -- save message in debug log
5267: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5567:
5568: -- Initialize message list if p_init_msg_list is set to TRUE.
5569: IF Fnd_Api.to_Boolean(p_init_msg_list)
5570: THEN
5571: Fnd_Msg_Pub.initialize;
5572: END IF;
5573:
5574: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
5575: 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
5860: x_warning_flag := Fnd_Api.G_TRUE;
5866: lc_mod_name,
5867: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5868: END IF;
5869: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5870: Fnd_Msg_Pub.ADD;
5871: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5872: p_data => x_msg_data);
5873:
5874: -- save message in debug log
5867: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5868: END IF;
5869: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5870: Fnd_Msg_Pub.ADD;
5871: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5872: p_data => x_msg_data);
5873:
5874: -- save message in debug log
5875: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5890: 'Adding message err_name to FND_MSG stack');
5891: end if;
5892: FND_MESSAGE.SET_NAME('CSD','err_name');
5893: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5894: FND_MSG_PUB.ADD;
5895: */
5896: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5897: p_data => x_msg_data);
5898:
5892: FND_MESSAGE.SET_NAME('CSD','err_name');
5893: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5894: FND_MSG_PUB.ADD;
5895: */
5896: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5897: p_data => x_msg_data);
5898:
5899: -- save message in debug log
5900: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5908: ROLLBACK TO Get_Estimates_From_BOM;
5909: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5910:
5911: -- save message in fnd stack
5912: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5913: THEN
5914: IF (Fnd_Log.Level_Statement >=
5915: Fnd_Log.G_Current_Runtime_Level)
5916: THEN
5915: Fnd_Log.G_Current_Runtime_Level)
5916: THEN
5917: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5918: lc_mod_name,
5919: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5920: END IF;
5921: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5922: END IF;
5923: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5917: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5918: lc_mod_name,
5919: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5920: END IF;
5921: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5922: END IF;
5923: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5924: p_data => x_msg_data);
5925:
5919: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5920: END IF;
5921: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5922: END IF;
5923: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5924: p_data => x_msg_data);
5925:
5926: -- save message in debug log
5927: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
5933:
5934: WHEN OTHERS THEN
5935: ROLLBACK TO Get_Estimates_From_BOM;
5936: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5937: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
5938: THEN
5939: IF (Fnd_Log.Level_Statement >=
5940: Fnd_Log.G_Current_Runtime_Level)
5941: THEN
5940: Fnd_Log.G_Current_Runtime_Level)
5941: THEN
5942: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5943: lc_mod_name,
5944: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5945: END IF;
5946: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5947: END IF;
5948: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5942: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5943: lc_mod_name,
5944: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5945: END IF;
5946: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5947: END IF;
5948: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5949: p_data => x_msg_data);
5950:
5944: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
5945: END IF;
5946: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
5947: END IF;
5948: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5949: p_data => x_msg_data);
5950:
5951: -- save message in debug log
5952: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6057:
6058: -- Initialize message list if p_init_msg_list is set to TRUE.
6059: IF Fnd_Api.to_Boolean(p_init_msg_list)
6060: THEN
6061: Fnd_Msg_Pub.initialize;
6062: END IF;
6063:
6064: IF (Fnd_Log.Level_Procedure >= Fnd_Log.G_Current_Runtime_Level)
6065: THEN
6237: END;
6238: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6239: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);
6240: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6241: Fnd_Msg_Pub.ADD;
6242: l_error := TRUE;
6243: IF (Fnd_Log.Level_Statement >=
6244: Fnd_Log.G_Current_Runtime_Level)
6245: THEN
6267: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');
6268: END IF;
6269: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');
6270: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6271: Fnd_Msg_Pub.ADD;
6272: l_error := TRUE;
6273: IF (Fnd_Log.Level_Statement >=
6274: Fnd_Log.G_Current_Runtime_Level)
6275: THEN
6443: 'CSD_EST_ESTIMATED_CHARGE_ERR');
6444: Fnd_Message.SET_TOKEN('CONTRACT_NUMBER',
6445: x_est_lines_tbl(l_curRow)
6446: .contract_number);
6447: Fnd_Msg_Pub.ADD;
6448: l_error := TRUE;
6449: END IF;
6450: -- Bugfix 3843770, vkjain.
6451: -- The contract discount field is not being populated for AutoCreate
6525: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6526: -- end if;
6527: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
6528: -- FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',x_est_lines_tbl(l_curRow).contract_number);
6529: -- FND_MSG_PUB.ADD;
6530: -- l_error := TRUE;
6531: END IF;
6532:
6533: -- set transaction type (Material, labor, expense)
6629: 'Calling CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6630: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6631: lc_mod_name,
6632: 'Number of messages in stack: ' ||
6633: Fnd_Msg_Pub.count_msg);
6634: END IF;
6635: Csd_Gen_Errmsgs_Pvt.Save_Fnd_Msgs(p_api_version => 1.0,
6636: p_commit => Fnd_Api.G_FALSE,
6637: p_init_msg_list => Fnd_Api.G_FALSE,
6657: 'Returned from CSD_GEN_ERRMSGS_PVT.Save_Fnd_Msgs');
6658: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
6659: lc_mod_name,
6660: 'Number of messages in stack: ' ||
6661: Fnd_Msg_Pub.count_msg);
6662: END IF;
6663: END IF;
6664: END LOOP;
6665:
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
6694: ROLLBACK TO Convert_To_Est_Lines;
6702: 'Adding message err_name to FND_MSG stack');
6703: end if;
6704: FND_MESSAGE.SET_NAME('CSD','err_name');
6705: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
6706: FND_MSG_PUB.ADD;
6707: */
6708: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6709: p_data => x_msg_data);
6710:
6704: FND_MESSAGE.SET_NAME('CSD','err_name');
6705: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
6706: FND_MSG_PUB.ADD;
6707: */
6708: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6709: p_data => x_msg_data);
6710:
6711: -- save message in debug log
6712: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6719: ROLLBACK TO Convert_To_Est_Lines;
6720: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6721:
6722: -- save message in fnd stack
6723: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6724: THEN
6725: IF (Fnd_Log.Level_Statement >=
6726: Fnd_Log.G_Current_Runtime_Level)
6727: THEN
6726: Fnd_Log.G_Current_Runtime_Level)
6727: THEN
6728: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6729: lc_mod_name,
6730: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6731: END IF;
6732: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6733: END IF;
6734: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6728: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6729: lc_mod_name,
6730: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6731: END IF;
6732: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6733: END IF;
6734: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6735: p_data => x_msg_data);
6736:
6730: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6731: END IF;
6732: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6733: END IF;
6734: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6735: p_data => x_msg_data);
6736:
6737: -- save message in debug log
6738: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6745: ROLLBACK TO Convert_To_Est_Lines;
6746: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6747:
6748: -- save message in fnd stack
6749: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6750: THEN
6751: IF (Fnd_Log.Level_Statement >=
6752: Fnd_Log.G_Current_Runtime_Level)
6753: THEN
6752: Fnd_Log.G_Current_Runtime_Level)
6753: THEN
6754: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6755: lc_mod_name,
6756: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6757: END IF;
6758: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6759: END IF;
6760: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6754: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6755: lc_mod_name,
6756: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6757: END IF;
6758: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6759: END IF;
6760: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6761: p_data => x_msg_data);
6762:
6756: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
6757: END IF;
6758: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, lc_api_name);
6759: END IF;
6760: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6761: p_data => x_msg_data);
6762:
6763: -- save message in debug log
6764: IF (Fnd_Log.Level_Exception >= Fnd_Log.G_Current_Runtime_Level)
6833:
6834: -- Initialize message list if p_init_msg_list is set to TRUE.
6835: IF Fnd_Api.to_Boolean(p_init_msg_list)
6836: THEN
6837: Fnd_Msg_Pub.initialize;
6838: END IF;
6839:
6840: -- Initialize API return status to success
6841: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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
6943: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6941: EXCEPTION
6942: WHEN Fnd_Api.G_EXC_ERROR THEN
6943: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6944: ROLLBACK TO create_estimate_header_pvt;
6945: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6946: p_data => x_msg_data);
6947: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
6948: THEN
6949: Fnd_Log.STRING(Fnd_Log.level_error,
6952: END IF;
6953: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
6954: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6955: ROLLBACK TO create_estimate_header_pvt;
6956: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6957: p_data => x_msg_data);
6958: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6959: THEN
6960: Fnd_Log.STRING(Fnd_Log.level_exception,
6963: END IF;
6964: WHEN OTHERS THEN
6965: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6966: ROLLBACK TO create_estimate_header_pvt;
6967: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6968: THEN
6969: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6970: END IF;
6971: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6965: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6966: ROLLBACK TO create_estimate_header_pvt;
6967: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6968: THEN
6969: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6970: END IF;
6971: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6972: p_data => x_msg_data);
6973: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6967: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
6968: THEN
6969: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6970: END IF;
6971: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6972: p_data => x_msg_data);
6973: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
6974: THEN
6975: Fnd_Log.STRING(Fnd_Log.level_exception,
7026:
7027: -- Initialize message list if p_init_msg_list is set to TRUE.
7028: IF Fnd_Api.to_Boolean(p_init_msg_list)
7029: THEN
7030: Fnd_Msg_Pub.initialize;
7031: END IF;
7032:
7033: -- Initialize API return status to success
7034: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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)
7088: THEN
7093: EXCEPTION
7094: WHEN Fnd_Api.G_EXC_ERROR THEN
7095: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7096: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7097: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7098: p_data => x_msg_data);
7099: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7100: THEN
7101: Fnd_Log.STRING(Fnd_Log.level_error,
7105:
7106: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
7107: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7108: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7109: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7110: p_data => x_msg_data);
7111: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7112: THEN
7113: Fnd_Log.STRING(Fnd_Log.level_exception,
7116: END IF;
7117: WHEN OTHERS THEN
7118: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7119: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7120: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7121: THEN
7122: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7123: END IF;
7124: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7118: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7119: ROLLBACK TO CREATE_ESTIMATE_LINE_PVT;
7120: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7121: THEN
7122: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7123: END IF;
7124: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7125: p_data => x_msg_data);
7126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7120: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7121: THEN
7122: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7123: END IF;
7124: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7125: p_data => x_msg_data);
7126: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7127: THEN
7128: Fnd_Log.STRING(Fnd_Log.level_exception,
7212:
7213: -- Initialize message list if p_init_msg_list is set to TRUE.
7214: IF Fnd_Api.to_Boolean(p_init_msg_list)
7215: THEN
7216: Fnd_Msg_Pub.initialize;
7217: END IF;
7218:
7219: -- Initialize API return status to success
7220: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7267:
7268: IF (CUR_EST_HDR%NOTFOUND)
7269: THEN
7270: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_HEADER');
7271: Fnd_Msg_Pub.ADD;
7272: RAISE Fnd_Api.G_EXC_ERROR;
7273: END IF;
7274:
7275: IF (l_est_pvt_hdr_Rec.repair_line_id <>
7275: IF (l_est_pvt_hdr_Rec.repair_line_id <>
7276: p_Estimate_hdr_Rec.repair_line_id)
7277: THEN
7278: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_INPUT');
7279: Fnd_Msg_Pub.ADD;
7280: RAISE Fnd_Api.G_EXC_ERROR;
7281: END IF;
7282: CLOSE CUR_EST_HDR;
7283: l_est_status_changed := FALSE;
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)
7362: THEN
7367: EXCEPTION
7368: WHEN Fnd_Api.G_EXC_ERROR THEN
7369: x_return_status := Fnd_Api.G_RET_STS_ERROR;
7370: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7371: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7372: p_data => x_msg_data);
7373: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
7374: THEN
7375: Fnd_Log.STRING(Fnd_Log.level_error,
7379:
7380: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
7381: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7382: ROLLBACK TO UPDATE_ESTIMATE_HEADER_PVT;
7383: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7384: p_data => x_msg_data);
7385: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7386: THEN
7387: Fnd_Log.STRING(Fnd_Log.level_exception,
7390: END IF;
7391: WHEN OTHERS THEN
7392: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7393: Rollback TO UPDATE_ESTIMATE_HEADER_PVT;
7394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7395: THEN
7396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7397: END IF;
7398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7392: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
7393: Rollback TO UPDATE_ESTIMATE_HEADER_PVT;
7394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7395: THEN
7396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7397: END IF;
7398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7399: p_data => x_msg_data);
7400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7394: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
7395: THEN
7396: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7397: END IF;
7398: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
7399: p_data => x_msg_data);
7400: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
7401: THEN
7402: Fnd_Log.STRING(Fnd_Log.level_exception,