eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIRS_GRP dependencies on CSD_REPAIRS

Line 1: PACKAGE BODY CSD_REPAIRS_GRP as

1: PACKAGE BODY CSD_REPAIRS_GRP as
2: /* $Header: csdgdrab.pls 120.7.12010000.2 2008/11/06 07:28:23 subhat ship $ */
3: --
4: -- Package name : CSD_REPAIRS_GRP
5: -- Purpose : This package contains routines called by Repairs form.

Line 4: -- Package name : CSD_REPAIRS_GRP

1: PACKAGE BODY CSD_REPAIRS_GRP as
2: /* $Header: csdgdrab.pls 120.7.12010000.2 2008/11/06 07:28:23 subhat ship $ */
3: --
4: -- Package name : CSD_REPAIRS_GRP
5: -- Purpose : This package contains routines called by Repairs form.
6: -- History :
7: -- Version Date Name Description
8: -- 115.0 12/28/99 pkdas Created.

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_GRP';

28: -- 115.28 08/06/02 saupadhy Default input parameters for procedures were made consistent in package specifica
29: -- -tion and body. To fix bug 2497692
30: -- NOTE :
31: --
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIRS_GRP';
33: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdgdrab.pls';
34: g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
35: --
36: PROCEDURE Create_Repair_Order(

Line 127: l_repln_rec csd_repairs_pub.repln_rec_type;

123: )
124: IS
125: --
126: l_api_name CONSTANT VARCHAR2(30) := 'Create_Repair_Order';
127: l_repln_rec csd_repairs_pub.repln_rec_type;
128: --
129: begin
130: --
131: -- Standard Start of API savepoint

Line 145: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

141: --
142: -- API body
143: --
144: if (g_debug) > 0 then
145: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
146: end if;
147: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
148: (p_repair_number => p_repair_number,
149: p_incident_id => p_incident_id,

Line 147: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

143: --
144: if (g_debug) > 0 then
145: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
146: end if;
147: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
148: (p_repair_number => p_repair_number,
149: p_incident_id => p_incident_id,
150: p_inventory_item_id => p_inventory_item_id,
151: p_customer_product_id => p_customer_product_id,

Line 227: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_PVT.Create_Repair_Order');

223: p_escalation_code => p_escalation_code,
224: x_Repln_Rec => l_Repln_Rec);
225: --
226: if (g_debug > 0) then
227: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Create_Repair_Order before CSD_REPAIRS_PVT.Create_Repair_Order');
228: end if;
229: -- travi fix to create call from RO not to validate for Group_id
230: l_Repln_Rec.REPAIR_GROUP_ID := null;
231:

Line 232: CSD_REPAIRS_PVT.Create_Repair_Order

228: end if;
229: -- travi fix to create call from RO not to validate for Group_id
230: l_Repln_Rec.REPAIR_GROUP_ID := null;
231:
232: CSD_REPAIRS_PVT.Create_Repair_Order
233: (p_API_version_number => 1.0,
234: p_init_msg_list => p_init_msg_list,
235: p_commit => p_commit,
236: p_validation_level => null,

Line 389: l_repln_rec csd_repairs_pub.repln_rec_type;

385: )
386: IS
387: --
388: l_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Order';
389: l_repln_rec csd_repairs_pub.repln_rec_type;
390: --
391: begin
392: --
393: -- Standard Start of API savepoint

Line 407: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

403: --
404: -- API body
405: --
406: if (g_debug > 0 ) then
407: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
408: end if;
409: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
410: (p_repair_number => p_repair_number,
411: p_incident_id => p_incident_id,

Line 409: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

405: --
406: if (g_debug > 0 ) then
407: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
408: end if;
409: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
410: (p_repair_number => p_repair_number,
411: p_incident_id => p_incident_id,
412: p_inventory_item_id => p_inventory_item_id,
413: p_customer_product_id => p_customer_product_id,

Line 487: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');

483: p_escalation_code => p_escalation_code,
484: x_Repln_Rec => l_Repln_Rec);
485: --
486: if (g_debug > 0) then
487: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');
488: end if;
489: CSD_REPAIRS_PUB.Update_Repair_Order
490: (p_API_version_number => 1.0,
491: p_init_msg_list => p_init_msg_list,

Line 489: CSD_REPAIRS_PUB.Update_Repair_Order

485: --
486: if (g_debug > 0) then
487: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');
488: end if;
489: CSD_REPAIRS_PUB.Update_Repair_Order
490: (p_API_version_number => 1.0,
491: p_init_msg_list => p_init_msg_list,
492: p_commit => p_commit,
493: p_repair_line_id => p_repair_line_id,

Line 577: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_grp.update_approval_status';

573: lc_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
574: lc_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
575: lc_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
576: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
577: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_grp.update_approval_status';
578: --
579: l_api_name CONSTANT VARCHAR2(30) := 'Update_Approval_Status';
580: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;
581: l_repair_history_id number;

Line 580: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;

576: lc_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
577: lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_grp.update_approval_status';
578: --
579: l_api_name CONSTANT VARCHAR2(30) := 'Update_Approval_Status';
580: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;
581: l_repair_history_id number;
582: l_event_code varchar2(30);
583: -- swai 11.5.10 new variables
584: l_return_status varchar2(1);

Line 602: 'Calling CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

598: -- API Body
599: --
600: if (lc_proc_level >= lc_debug_level) then
601: FND_LOG.STRING(lc_proc_level, lc_mod_name,
602: 'Calling CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
603: end if;
604: -- travi 01/04/02 change
605: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
606: (p_approval_status => p_new_approval_status,

Line 605: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

601: FND_LOG.STRING(lc_proc_level, lc_mod_name,
602: 'Calling CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
603: end if;
604: -- travi 01/04/02 change
605: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
606: (p_approval_status => p_new_approval_status,
607: p_object_version_number => p_object_version_number,
608: x_repln_rec => l_repln_rec
609: );

Line 613: 'Returned from CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

609: );
610: --
611: if (lc_proc_level >= lc_debug_level) then
612: FND_LOG.STRING(lc_proc_level, lc_mod_name,
613: 'Returned from CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
614: end if;
615: --
616: -- swai 11.5.10
617: -- update event code will always be ESU if status is changed

Line 639: 'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');

635:
636: --
637: if (lc_proc_level >= lc_debug_level) then
638: FND_LOG.STRING(lc_proc_level, lc_mod_name,
639: 'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');
640: end if;
641: CSD_REPAIRS_PVT.Update_Repair_Order
642: (p_API_version_number => 1.0,
643: p_init_msg_list => FND_API.G_TRUE,

Line 641: CSD_REPAIRS_PVT.Update_Repair_Order

637: if (lc_proc_level >= lc_debug_level) then
638: FND_LOG.STRING(lc_proc_level, lc_mod_name,
639: 'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');
640: end if;
641: CSD_REPAIRS_PVT.Update_Repair_Order
642: (p_API_version_number => 1.0,
643: p_init_msg_list => FND_API.G_TRUE,
644: p_commit => FND_API.G_FALSE,
645: p_validation_level => null,

Line 655: 'Returned from CSD_REPAIRS_PVT.Update_Repair_Order. x_return_status='|| x_return_status);

651: );
652: --
653: if (lc_proc_level >= lc_debug_level) then
654: FND_LOG.STRING(lc_proc_level, lc_mod_name,
655: 'Returned from CSD_REPAIRS_PVT.Update_Repair_Order. x_return_status='|| x_return_status);
656: end if;
657:
658: -- Check return status from the above procedure call
659: IF (x_return_status <> 'S') then

Line 667: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Approval_Status before api CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call');

663: p_object_version_number := l_Repln_Rec.object_version_number;
664: END IF;
665: --
666: if (g_debug > 0) then
667: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Approval_Status before api CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call');
668: end if;
669:
670: -- swai 11.5.10
671: -- check for event code before:

Line 842: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;

838: )
839: IS
840: --
841: l_api_name CONSTANT VARCHAR2(30) := 'Update_Status';
842: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;
843: l_repair_history_id number;
844:
845: --
846: BEGIN

Line 860: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

856: if p_new_status = p_old_status then
857:
858: -- old return;
859: -- travi 010902 new
860: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
861: (p_date_closed => sysdate,
862: p_status => p_new_status,
863: p_status_reason_code => p_status_reason_code,
864: p_object_version_number => p_object_version_number,

Line 871: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

867:
868: end if;
869: if p_new_status = 'C' then
870:
871: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
872: (p_date_closed => sysdate,
873: p_status => p_new_status,
874: p_status_reason_code => p_status_reason_code,
875: p_object_version_number => p_object_version_number,

Line 881: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

877: );
878:
879: elsif p_old_status = 'C' then
880:
881: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
882: (p_date_closed => null,
883: p_status => p_new_status,
884: p_status_reason_code => p_status_reason_code,
885: p_object_version_number => p_object_version_number,

Line 891: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

887: );
888:
889: else
890:
891: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
892: (p_status => p_new_status,
893: p_status_reason_code => p_status_reason_code,
894: p_object_version_number => p_object_version_number,
895: x_repln_rec => l_repln_rec

Line 901: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_REPAIRS_PVT.Update_Repair_Order');

897:
898: end if;
899: --
900: if (g_debug > 0) then
901: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_REPAIRS_PVT.Update_Repair_Order');
902: end if;
903: CSD_REPAIRS_PVT.Update_Repair_Order
904: (p_API_version_number => 1.0,
905: p_init_msg_list => FND_API.G_TRUE,

Line 903: CSD_REPAIRS_PVT.Update_Repair_Order

899: --
900: if (g_debug > 0) then
901: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_REPAIRS_PVT.Update_Repair_Order');
902: end if;
903: CSD_REPAIRS_PVT.Update_Repair_Order
904: (p_API_version_number => 1.0,
905: p_init_msg_list => FND_API.G_TRUE,
906: p_commit => FND_API.G_FALSE,
907: p_validation_level => null,

Line 915: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status after CSD_REPAIRS_PVT.Update_Repair_Order status : '||x_return_status);

911: x_msg_count => x_msg_count,
912: x_msg_data => x_msg_data
913: );
914: if (g_debug > 0) then
915: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status after CSD_REPAIRS_PVT.Update_Repair_Order status : '||x_return_status);
916: end if;
917: --
918: -- Check return status from the above procedure call
919: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS) then

Line 931: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');

927: */
928: -- travi 010902 change added if cond
929: --if p_new_status <> p_old_status then
930: if (g_debug > 0) then
931: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
932: end if;
933:
934: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
935: (p_Api_Version_Number => 1.0 ,

Line 1006: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write status : '||x_return_status);

1002: X_Msg_Count => x_msg_count,
1003: X_Msg_Data => x_msg_data
1004: );
1005: if (g_debug > 0) then
1006: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write status : '||x_return_status);
1007: end if;
1008: --end if; -- only for changed status codes sangigup 3232547
1009: --
1010: -- Check return status from the above procedure call

Line 1099: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;

1095: l_rep_approval_status VARCHAR2(30);
1096: l_estimate_status VARCHAR2(30);
1097: l_event_code VARCHAR2(30);
1098:
1099: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
1100: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
1101: l_rep_group_rec CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC;
1102:
1103: Cursor c_repairs_for_approval ( p_repair_group_id number) is

Line 1110: from csd_repairs rep

1106: , rep.quantity
1107: , rep.object_version_number rep_ovn
1108: , est.repair_estimate_id
1109: , est.object_version_number est_ovn
1110: from csd_repairs rep
1111: , csd_repair_estimate est
1112: where rep.repair_group_id = p_repair_group_id
1113: and rep.repair_line_id = est.repair_line_id
1114: and est.estimate_status = 'BID';

Line 1203: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status convert repairs rec call');

1199: ----------------------------------
1200: -- API Body
1201: ----------------------------------
1202: if (g_debug > 0) then
1203: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status convert repairs rec call');
1204: end if;
1205: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
1206: (p_approval_status => l_approval_status,
1207: p_object_version_number => l_rep_ovn,

Line 1205: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

1201: ----------------------------------
1202: if (g_debug > 0) then
1203: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status convert repairs rec call');
1204: end if;
1205: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
1206: (p_approval_status => l_approval_status,
1207: p_object_version_number => l_rep_ovn,
1208: x_repln_rec => l_rep_ord_rec
1209: );

Line 1211: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update repairs call');

1207: p_object_version_number => l_rep_ovn,
1208: x_repln_rec => l_rep_ord_rec
1209: );
1210: if (g_debug > 0) then
1211: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update repairs call');
1212: end if;
1213: CSD_REPAIRS_PVT.Update_Repair_Order
1214: (p_API_version_number => 1.0,
1215: p_init_msg_list => FND_API.G_TRUE,

Line 1213: CSD_REPAIRS_PVT.Update_Repair_Order

1209: );
1210: if (g_debug > 0) then
1211: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update repairs call');
1212: end if;
1213: CSD_REPAIRS_PVT.Update_Repair_Order
1214: (p_API_version_number => 1.0,
1215: p_init_msg_list => FND_API.G_TRUE,
1216: p_commit => FND_API.G_FALSE,
1217: p_validation_level => null,

Line 1226: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update_Repair_Order :'||x_return_status);

1222: x_msg_data => x_msg_data
1223: );
1224:
1225: if (g_debug > 0) then
1226: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update_Repair_Order :'||x_return_status);
1227: end if;
1228: -- Check return status from the update RO call
1229: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1230: if (g_debug > 0) then

Line 1231: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');

1227: end if;
1228: -- Check return status from the update RO call
1229: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1230: if (g_debug > 0) then
1231: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
1232: end if;
1233: RAISE FND_API.G_EXC_ERROR;
1234: --ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1235: --return;

Line 1238: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO hist call');

1234: --ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1235: --return;
1236: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1237: if (g_debug > 0) then
1238: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO hist call');
1239: end if;
1240: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
1241: (p_Api_Version_Number => 1.0 ,
1242: p_init_msg_list => 'F',

Line 1329: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO estimate call');

1325: l_rep_est_rec.repair_line_id := l_repair_line_id;
1326: l_rep_est_rec.object_version_number := l_est_ovn;
1327: l_rep_est_rec.estimate_status := l_estimate_status;
1328: if (g_debug > 0) then
1329: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO estimate call');
1330: end if;
1331: csd_repair_estimate_pvt.update_repair_estimate
1332: (p_api_version => 1.0,
1333: p_commit => 'F',

Line 1341: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status update_repair_estimate :'||x_return_status);

1337: x_return_status => x_return_status,
1338: x_msg_count => l_msg_count,
1339: x_msg_data => l_msg_data);
1340: if (g_debug > 0) then
1341: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status update_repair_estimate :'||x_return_status);
1342: end if;
1343: -- Check return status from the above procedure call
1344: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1345: if (g_debug > 0) then

Line 1447: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;

1443: l_rep_Reject_status VARCHAR2(30);
1444: l_estimate_status VARCHAR2(30);
1445: l_event_code VARCHAR2(30);
1446:
1447: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
1448: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
1449: l_rep_group_rec CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC;
1450:
1451: Cursor c_repairs_for_Reject ( p_repair_group_id number) is

Line 1458: from csd_repairs rep

1454: , rep.quantity
1455: , rep.object_version_number rep_ovn
1456: , est.repair_estimate_id
1457: , est.object_version_number est_ovn
1458: from csd_repairs rep
1459: , csd_repair_estimate est
1460: where rep.repair_group_id = p_repair_group_id
1461: and rep.repair_line_id = est.repair_line_id;
1462:

Line 1551: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status convert repairs rec call');

1547: -- API Body
1548: ----------------------------------
1549:
1550: if (g_debug > 0) then
1551: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status convert repairs rec call');
1552: end if;
1553: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
1554: (p_approval_status => l_Reject_status,
1555: p_object_version_number => l_rep_ovn,

Line 1553: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

1549:
1550: if (g_debug > 0) then
1551: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status convert repairs rec call');
1552: end if;
1553: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
1554: (p_approval_status => l_Reject_status,
1555: p_object_version_number => l_rep_ovn,
1556: x_repln_rec => l_rep_ord_rec
1557: );

Line 1559: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update repairs call');

1555: p_object_version_number => l_rep_ovn,
1556: x_repln_rec => l_rep_ord_rec
1557: );
1558: if (g_debug > 0) then
1559: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update repairs call');
1560: end if;
1561: CSD_REPAIRS_PVT.Update_Repair_Order
1562: (p_API_version_number => 1.0,
1563: p_init_msg_list => FND_API.G_TRUE,

Line 1561: CSD_REPAIRS_PVT.Update_Repair_Order

1557: );
1558: if (g_debug > 0) then
1559: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update repairs call');
1560: end if;
1561: CSD_REPAIRS_PVT.Update_Repair_Order
1562: (p_API_version_number => 1.0,
1563: p_init_msg_list => FND_API.G_TRUE,
1564: p_commit => FND_API.G_FALSE,
1565: p_validation_level => null,

Line 1574: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update_Repair_Order :'||x_return_status);

1570: x_msg_data => x_msg_data
1571: );
1572:
1573: if (g_debug > 0) then
1574: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update_Repair_Order :'||x_return_status);
1575: end if;
1576: -- Check return status from the update RO call
1577: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1578: if (g_debug > 0) then

Line 1579: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');

1575: end if;
1576: -- Check return status from the update RO call
1577: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1578: if (g_debug > 0) then
1579: csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
1580: end if;
1581: RAISE FND_API.G_EXC_ERROR;
1582: --ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1583: --return;

Line 1586: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO hist call');

1582: --ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1583: --return;
1584: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1585: if (g_debug > 0) then
1586: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO hist call');
1587: end if;
1588: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write
1589: (p_Api_Version_Number => 1.0 ,
1590: p_init_msg_list => 'F',

Line 1660: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Validate_And_Write :'||x_return_status);

1656: X_Msg_Count => x_msg_count,
1657: X_Msg_Data => x_msg_data
1658: );
1659: if (g_debug > 0) then
1660: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Validate_And_Write :'||x_return_status);
1661: end if;
1662: -- Check return status from the above procedure call
1663: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1664: if (g_debug > 0) then

Line 1677: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO estimate call');

1673: l_rep_est_rec.repair_line_id := l_repair_line_id;
1674: l_rep_est_rec.object_version_number := l_est_ovn;
1675: l_rep_est_rec.estimate_status := l_estimate_status;
1676: if (g_debug > 0) then
1677: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO estimate call');
1678: end if;
1679: csd_repair_estimate_pvt.update_repair_estimate
1680: (p_api_version => 1.0,
1681: p_commit => 'F',

Line 1689: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status update_repair_estimate :'||x_return_status);

1685: x_return_status => x_return_status,
1686: x_msg_count => l_msg_count,
1687: x_msg_data => l_msg_data);
1688: if (g_debug > 0) then
1689: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status update_repair_estimate :'||x_return_status);
1690: end if;
1691: -- Check return status from the above procedure call
1692: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1693: if (g_debug > 0) then

Line 1758: End CSD_REPAIRS_GRP;

1754:
1755: --
1756: END Update_Group_Reject_Status;
1757:
1758: End CSD_REPAIRS_GRP;