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.MSC_SRP_RELEASE dependencies on CSD_REPAIRS

Line 340: select * from csd_repairs

336: p_quantity IN NUMBER:= NULL,
337: p_promise_date IN DATE:= NULL)
338: IS
339: Cursor c1(p_repair_line_id number) is
340: select * from csd_repairs
341: where repair_line_id = p_repair_line_id ;
342:
343: l_repair_rec CSD_REPAIRS%rowtype;
344: l_Init_Msg_List VARCHAR2(1000):= FND_API.G_FALSE;

Line 343: l_repair_rec CSD_REPAIRS%rowtype;

339: Cursor c1(p_repair_line_id number) is
340: select * from csd_repairs
341: where repair_line_id = p_repair_line_id ;
342:
343: l_repair_rec CSD_REPAIRS%rowtype;
344: l_Init_Msg_List VARCHAR2(1000):= FND_API.G_FALSE;
345: l_Commit VARCHAR2(1000):= FND_API.G_FALSE;
346: l_validation_level NUMBER:=FND_API.G_VALID_LEVEL_FULL;
347: Q_REPLN_Rec CSD_REPAIRS_PUB.REPLN_Rec_Type;

Line 347: Q_REPLN_Rec CSD_REPAIRS_PUB.REPLN_Rec_Type;

343: l_repair_rec CSD_REPAIRS%rowtype;
344: l_Init_Msg_List VARCHAR2(1000):= FND_API.G_FALSE;
345: l_Commit VARCHAR2(1000):= FND_API.G_FALSE;
346: l_validation_level NUMBER:=FND_API.G_VALID_LEVEL_FULL;
347: Q_REPLN_Rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
348: X_Return_Status VARCHAR2(1000);
349: p_Msg_Count NUMBER;
350: X_Msg_Data VARCHAR2(5000);
351: l_msg VARCHAR2(5000);

Line 426: CSD_Repairs_PUB.Update_Repair_Order(

422: Q_REPLN_Rec.INVENTORY_ORG_ID:=l_repair_rec.INVENTORY_ORG_ID;
423: Q_REPLN_Rec.PROBLEM_DESCRIPTION:=l_repair_rec.PROBLEM_DESCRIPTION;
424: Q_REPLN_Rec.RO_PRIORITY_CODE:=l_repair_rec.RO_PRIORITY_CODE;
425:
426: CSD_Repairs_PUB.Update_Repair_Order(
427: P_Api_Version_Number => 1.0,
428: P_Init_Msg_List => l_Init_Msg_List,
429: P_Commit => l_Commit,
430: p_validation_level => l_validation_level,

Line 577: Q_REPLN_Rec CSD_REPAIRS_PUB.REPLN_Rec_Type;

573: P_Init_Msg_List VARCHAR2(1000);
574: P_Commit VARCHAR2(1000);
575: p_validation_level NUMBER;
576: P_REPAIR_LINE_ID NUMBER;
577: Q_REPLN_Rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
578: p_create_default_logistics VARCHAR2(100) := 'N';
579:
580: X_REPAIR_NUMBER VARCHAR2(1000);
581: X_Msg_Count NUMBER;

Line 623: --Q_REPLN_Rec CSD_REPAIRS_PUB.REPLN_Rec_Type;

619: l_party_id NUMBER;
620: l_acct_id NUMBER;
621: l_acct_number VARCHAR2(2000);
622:
623: --Q_REPLN_Rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
624: --p_create_default_logistics VARCHAR2(100) := 'N';
625: --P_REPAIR_LINE_ID NUMBER;
626: P_REPAIR_TYPE NUMBER;
627: X_REPAIR_LINE_ID NUMBER;

Line 1040: LOG_MESSAGE('Calling API CSD_Repairs_PUB.Create_Repair_Order');

1036: Q_REPLN_Rec.PROBLEM_DESCRIPTION := NULL;
1037: Q_REPLN_Rec.RO_PRIORITY_CODE := NULL;
1038: BEGIN
1039:
1040: LOG_MESSAGE('Calling API CSD_Repairs_PUB.Create_Repair_Order');
1041:
1042: CSD_Repairs_PUB.Create_Repair_Order(P_Api_Version_Number => 1.0,
1043: P_Init_Msg_List => FND_API.G_FALSE,
1044: P_Commit => FND_API.G_FALSE,

Line 1042: CSD_Repairs_PUB.Create_Repair_Order(P_Api_Version_Number => 1.0,

1038: BEGIN
1039:
1040: LOG_MESSAGE('Calling API CSD_Repairs_PUB.Create_Repair_Order');
1041:
1042: CSD_Repairs_PUB.Create_Repair_Order(P_Api_Version_Number => 1.0,
1043: P_Init_Msg_List => FND_API.G_FALSE,
1044: P_Commit => FND_API.G_FALSE,
1045: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1046: P_REPAIR_LINE_ID => P_REPAIR_LINE_ID,

Line 1054: LOG_MESSAGE('Called API CSD_Repairs_PUB.Create_Repair_Order -'||X_Return_Status);

1050: X_REPAIR_NUMBER => X_REPAIR_NUMBER,
1051: X_Return_Status => X_Return_Status,
1052: X_Msg_Count => X_Msg_Count,
1053: X_Msg_Data => X_Msg_Data);
1054: LOG_MESSAGE('Called API CSD_Repairs_PUB.Create_Repair_Order -'||X_Return_Status);
1055: LOG_MESSAGE('Return Status. :'||X_Return_Status);
1056: LOG_MESSAGE('X_REPAIR_LINE_ID :'||X_REPAIR_LINE_ID);
1057: LOG_MESSAGE('X_REPAIR_NUMBER :'||X_REPAIR_NUMBER);
1058:

Line 1069: LOG_MESSAGE('CSD_Repairs_PUB.Create_Repair_Order Called...');

1065: p_encoded => 'F' );
1066: LOG_MESSAGE('Error Message Data...'||X_Msg_Data||l_msg);
1067: END LOOP;
1068: ELSE
1069: LOG_MESSAGE('CSD_Repairs_PUB.Create_Repair_Order Called...');
1070: LOG_MESSAGE('Return Status. :'||X_Return_Status);
1071: LOG_MESSAGE('X_REPAIR_LINE_ID :'||X_REPAIR_LINE_ID);
1072: LOG_MESSAGE('X_REPAIR_NUMBER :'||X_REPAIR_NUMBER);
1073: -- COMMIT;