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.3 2010/05/06 01:28:00 takwong 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.3 2010/05/06 01:28:00 takwong 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 128: l_repln_rec csd_repairs_pub.repln_rec_type;

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

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

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

Line 148: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

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

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

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

Line 234: CSD_REPAIRS_PVT.Create_Repair_Order

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

Line 392: l_repln_rec csd_repairs_pub.repln_rec_type;

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

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

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

Line 412: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

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

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

487: p_ro_warranty_status_code => p_ro_warranty_status_code,
488: x_Repln_Rec => l_Repln_Rec);
489: --
490: if (g_debug > 0) then
491: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');
492: end if;
493: CSD_REPAIRS_PUB.Update_Repair_Order
494: (p_API_version_number => 1.0,
495: p_init_msg_list => p_init_msg_list,

Line 493: CSD_REPAIRS_PUB.Update_Repair_Order

489: --
490: if (g_debug > 0) then
491: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');
492: end if;
493: CSD_REPAIRS_PUB.Update_Repair_Order
494: (p_API_version_number => 1.0,
495: p_init_msg_list => p_init_msg_list,
496: p_commit => p_commit,
497: p_repair_line_id => p_repair_line_id,

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

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

Line 584: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;

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

Line 606: 'Calling CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');

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

Line 609: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

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

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

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

Line 643: 'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');

639:
640: --
641: if (lc_proc_level >= lc_debug_level) then
642: FND_LOG.STRING(lc_proc_level, lc_mod_name,
643: 'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');
644: end if;
645: CSD_REPAIRS_PVT.Update_Repair_Order
646: (p_API_version_number => 1.0,
647: p_init_msg_list => FND_API.G_TRUE,

Line 645: CSD_REPAIRS_PVT.Update_Repair_Order

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

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

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

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

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

Line 846: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;

842: )
843: IS
844: --
845: l_api_name CONSTANT VARCHAR2(30) := 'Update_Status';
846: l_repln_rec CSD_REPAIRS_PUB.repln_rec_type;
847: l_repair_history_id number;
848:
849: --
850: BEGIN

Line 864: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

860: if p_new_status = p_old_status then
861:
862: -- old return;
863: -- travi 010902 new
864: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
865: (p_date_closed => sysdate,
866: p_status => p_new_status,
867: p_status_reason_code => p_status_reason_code,
868: p_object_version_number => p_object_version_number,

Line 875: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

871:
872: end if;
873: if p_new_status = 'C' then
874:
875: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
876: (p_date_closed => sysdate,
877: p_status => p_new_status,
878: p_status_reason_code => p_status_reason_code,
879: p_object_version_number => p_object_version_number,

Line 885: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

881: );
882:
883: elsif p_old_status = 'C' then
884:
885: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
886: (p_date_closed => null,
887: p_status => p_new_status,
888: p_status_reason_code => p_status_reason_code,
889: p_object_version_number => p_object_version_number,

Line 895: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

891: );
892:
893: else
894:
895: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type
896: (p_status => p_new_status,
897: p_status_reason_code => p_status_reason_code,
898: p_object_version_number => p_object_version_number,
899: x_repln_rec => l_repln_rec

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

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

Line 907: CSD_REPAIRS_PVT.Update_Repair_Order

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

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

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

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

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

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

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

Line 1103: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;

1099: l_rep_approval_status VARCHAR2(30);
1100: l_estimate_status VARCHAR2(30);
1101: l_event_code VARCHAR2(30);
1102:
1103: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
1104: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
1105: l_rep_group_rec CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC;
1106:
1107: Cursor c_repairs_for_approval ( p_repair_group_id number) is

Line 1114: from csd_repairs rep

1110: , rep.quantity
1111: , rep.object_version_number rep_ovn
1112: , est.repair_estimate_id
1113: , est.object_version_number est_ovn
1114: from csd_repairs rep
1115: , csd_repair_estimate est
1116: where rep.repair_group_id = p_repair_group_id
1117: and rep.repair_line_id = est.repair_line_id
1118: and est.estimate_status = 'BID';

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

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

Line 1209: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

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

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

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

Line 1217: CSD_REPAIRS_PVT.Update_Repair_Order

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

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

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

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

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

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

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

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

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

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

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

Line 1451: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;

1447: l_rep_Reject_status VARCHAR2(30);
1448: l_estimate_status VARCHAR2(30);
1449: l_event_code VARCHAR2(30);
1450:
1451: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
1452: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
1453: l_rep_group_rec CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC;
1454:
1455: Cursor c_repairs_for_Reject ( p_repair_group_id number) is

Line 1462: from csd_repairs rep

1458: , rep.quantity
1459: , rep.object_version_number rep_ovn
1460: , est.repair_estimate_id
1461: , est.object_version_number est_ovn
1462: from csd_repairs rep
1463: , csd_repair_estimate est
1464: where rep.repair_group_id = p_repair_group_id
1465: and rep.repair_line_id = est.repair_line_id;
1466:

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

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

Line 1557: CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type

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

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

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

Line 1565: CSD_REPAIRS_PVT.Update_Repair_Order

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1762: End CSD_REPAIRS_GRP;

1758:
1759: --
1760: END Update_Group_Reject_Status;
1761:
1762: End CSD_REPAIRS_GRP;