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_BULK_RECEIVE_PVT dependencies on CSD_BULK_RECEIVE_ITEMS_B

Line 22: from csd_bulk_receive_items_b

18:
19: -- Cursor to validate IB Owner and the Bulk Receive Party
20: Cursor c_set_party(p_transaction_number in number) is
21: Select *
22: from csd_bulk_receive_items_b
23: where transaction_number = p_transaction_number
24: and incident_id is null
25: and repair_line_id is null
26: and internal_sr_flag = 'N'

Line 33: from csd_bulk_receive_items_b

29:
30: -- Cursor to Change owner
31: Cursor c_change_owner(p_transaction_number in number) is
32: select *
33: from csd_bulk_receive_items_b
34: where transaction_number = p_transaction_number
35: and status in ('NEW','ERRORED')
36: and change_owner_flag = 'Y'
37: and party_id is null

Line 43: from csd_bulk_receive_items_b

39:
40: -- Cursor to Create Internal SR's
41: Cursor c_create_intr_sr(p_transaction_number in number) is
42: select *
43: from csd_bulk_receive_items_b
44: where transaction_number = p_transaction_number
45: and status in ('NEW','ERRORED')
46: and incident_id is null
47: and internal_sr_flag = 'Y';

Line 61: from csd_bulk_receive_items_b

57:
58: -- Cursor to Create SR
59: Cursor c_create_sr (p_transaction_number in number) is
60: select distinct party_id,cust_account_id
61: from csd_bulk_receive_items_b
62: where transaction_number = p_transaction_number
63: and status in ('NEW','ERRORED')
64: and incident_id is null
65: and party_id is not null

Line 71: from csd_bulk_receive_items_b

67:
68: -- Cursor to Create New RO only
69: Cursor c_create_ro (p_transaction_number in number,p_incident_id in number) is
70: select *
71: from csd_bulk_receive_items_b
72: where transaction_number = p_transaction_number
73: and incident_id = p_incident_id
74: and repair_line_id is null
75: and internal_sr_flag = 'N';

Line 80: from csd_bulk_receive_items_b

76:
77: -- Cursor to reprocess the errored RO's
78: Cursor c_reprocess_ro (p_transaction_number in number) is
79: select *
80: from csd_bulk_receive_items_b
81: where transaction_number = p_transaction_number
82: and status = 'ERRORED'
83: and incident_id is not null
84: and repair_line_id is null

Line 90: from csd_bulk_receive_items_b

86:
87: -- Cursor to Auto Receive
88: Cursor c_auto_receive (p_transaction in number) is
89: select *
90: from csd_bulk_receive_items_b
91: where transaction_number = p_transaction_number
92: and status in ('NEW','ERRORED')
93: and repair_line_id is not null
94: and internal_sr_flag = 'N';

Line 319: Update csd_bulk_receive_items_b

315: 'Update: bulk_receive_id[' || c_set_party_rec.bulk_receive_id ||
316: '] with IB owner party id - '||l_ib_owner_id);
317: End if;
318:
319: Update csd_bulk_receive_items_b
320: set party_id = l_ib_owner_id,
321: cust_account_id = l_ib_owner_acct_id
322: where bulk_receive_id = c_set_party_rec.bulk_receive_id;
323: End if;

Line 367: Update csd_bulk_receive_items_b

363: || c_change_owner_rec.bulk_receive_id ||
364: '] party id with orig party id');
365: End if;
366:
367: Update csd_bulk_receive_items_b
368: set party_id = orig_party_id
369: ,cust_account_id = orig_cust_account_id
370: ,status = 'NEW'
371: where bulk_receive_id = c_change_owner_rec.bulk_receive_id;

Line 481: Update csd_bulk_receive_items_b

477: 'Created Internal SR : Incident id = '
478: ||l_incident_id );
479: End if;
480:
481: Update csd_bulk_receive_items_b
482: set incident_id = l_incident_id,
483: status = 'PROCESSED',
484: party_id = l_intr_party_id,
485: cust_account_id = l_intr_cust_acct_id

Line 494: Update csd_bulk_receive_items_b

490: Else
491:
492: Rollback To create_intr_sr_savepoint;
493:
494: Update csd_bulk_receive_items_b
495: set status = 'ERRORED'
496: where transaction_number = p_transaction_number
497: and incident_id is null
498: and internal_sr_flag = 'Y';

Line 559: Update csd_bulk_receive_items_b

555: End if;
556:
557: If ( l_ro_status = 'DRAFT' ) then
558:
559: Update csd_bulk_receive_items_b
560: set repair_line_id = l_repair_line_id,
561: status = 'PROCESSED'
562: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
563:

Line 567: Update csd_bulk_receive_items_b

563:
564: Else
565:
566: -- Update the Bulk Receive Record
567: Update csd_bulk_receive_items_b
568: set repair_line_id = l_repair_line_id,
569: status = 'NEW'
570: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
571:

Line 593: Update csd_bulk_receive_items_b

589:
590: -- If Logistic line creation fails then rollback RO
591: Rollback To reprocess_ro_savepoint;
592:
593: Update csd_bulk_receive_items_b
594: set status = 'ERRORED'
595: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
596:
597: -- Write to conc log

Line 637: Update csd_bulk_receive_items_b

633: Else
634:
635: Rollback To reprocess_ro_savepoint;
636:
637: Update csd_bulk_receive_items_b
638: set status = 'ERRORED'
639: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
640:
641: -- Write to conc log

Line 666: for bk_rcv_rec in (select * from csd_bulk_receive_items_b

662: End if;
663: l_create_sr_flag := 'N';
664: -- loop through the records and populate the record for the receiving.
665:
666: for bk_rcv_rec in (select * from csd_bulk_receive_items_b
667: where transaction_number = p_transaction_number)
668: loop
669: -- find out if the line is ready to be received.
670: l_continue_further := true;

Line 773: update csd_bulk_receive_items_b

769: -- the order is not booked and an attempt to book it has failed.
770: -- log it to concurrent log.
771: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
772: -- update the bulk receive record as errored.
773: update csd_bulk_receive_items_b
774: set status = 'ERRORED'
775: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
776:
777: -- proceed for the next record.

Line 852: update csd_bulk_receive_items_b

848: 'Error during new RMA creation '||l_msg_data);
849: End if;
850: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
851:
852: update csd_bulk_receive_items_b
853: set status = 'ERRORED'
854: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
855:
856: else

Line 994: update csd_bulk_receive_items_b

990: -- the order is not booked and an attempt to book it has failed.
991: -- log it to concurrent log.
992: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
993: -- update the bulk receive record as errored.
994: update csd_bulk_receive_items_b
995: set status = 'ERRORED'
996: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
997: -- proceed for the next record.
998: -- bug#8805130, continue is 11G keyword. Use if construct to achieve the same

Line 1135: update csd_bulk_receive_items_b

1131: 'Error while creating default product txn lines '||l_msg_data);
1132: End if;
1133: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
1134:
1135: update csd_bulk_receive_items_b
1136: set status = 'ERRORED'
1137: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1138:
1139: raise fnd_api.g_exc_error;

Line 1176: update csd_bulk_receive_items_b

1172: End if;
1173:
1174: fnd_file.put_line(fnd_file.log,'Error occured in repair order creation '||l_msg_data);
1175:
1176: update csd_bulk_receive_items_b
1177: set status = 'ERRORED'
1178: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1179:
1180: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

Line 1185: update csd_bulk_receive_items_b

1181:
1182: raise fnd_api.g_exc_error;
1183: end if;
1184:
1185: update csd_bulk_receive_items_b
1186: set repair_line_id = l_repair_line_id
1187: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1188:
1189: if l_ro_status = 'DRAFT' then

Line 1196: update csd_bulk_receive_items_b

1192: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1193: 'Draft RO: The repair order is created in draft status. Set bulk receive status to processed');
1194: End if;
1195:
1196: update csd_bulk_receive_items_b
1197: set status = 'PROCESSED'
1198: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1199:
1200: else

Line 1224: update csd_bulk_receive_items_b

1220: End if;
1221: fnd_file.put_line(fnd_file.log,'Error occured during creation of default logistics lines '||l_msg_data);
1222: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
1223:
1224: update csd_bulk_receive_items_b
1225: set status = 'ERRORED'
1226: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1227:
1228: raise fnd_api.g_exc_error;

Line 1337: -- RO and Logistic lines for all the records (in csd_bulk_receive_items_b table)

1333:
1334: --
1335: -- Step - E
1336: -- Create SR for every distinct party and then create
1337: -- RO and Logistic lines for all the records (in csd_bulk_receive_items_b table)
1338: -- having same party.If SR creation fails then RO's are not created.
1339: --
1340: For c_create_sr_rec in c_create_sr (p_transaction_number)
1341: Loop

Line 1377: Update csd_bulk_receive_items_b

1373: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
1374:
1375: -- Update the record status
1376:
1377: Update csd_bulk_receive_items_b
1378: set incident_id = l_incident_id,
1379: status = 'NEW'
1380: where transaction_number = p_transaction_number
1381: and party_id = c_create_sr_rec.party_id

Line 1392: Update csd_bulk_receive_items_b

1388: Rollback To create_new_sr_savepoint;
1389:
1390: -- Update the record status
1391:
1392: Update csd_bulk_receive_items_b
1393: set status = 'ERRORED'
1394: where party_id = c_create_sr_rec.party_id
1395: and cust_account_id = c_create_sr_rec.cust_account_id
1396: and incident_id is null

Line 1454: Update csd_bulk_receive_items_b

1450: End if;
1451:
1452: If ( l_ro_status = 'DRAFT' ) then
1453:
1454: Update csd_bulk_receive_items_b
1455: set repair_line_id = l_repair_line_id,
1456: status = 'PROCESSED'
1457: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1458:

Line 1462: Update csd_bulk_receive_items_b

1458:
1459: Else
1460:
1461: -- Update the Bulk Receive Record
1462: Update csd_bulk_receive_items_b
1463: set repair_line_id = l_repair_line_id,
1464: status = 'NEW'
1465: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1466:

Line 1490: Update csd_bulk_receive_items_b

1486: Rollback To create_ro_savepoint;
1487:
1488: l_ro_error_count := l_ro_error_count + 1;
1489:
1490: Update csd_bulk_receive_items_b
1491: set status = 'ERRORED'
1492: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1493:
1494: -- Write to conc log

Line 1536: Update csd_bulk_receive_items_b

1532: Rollback To create_ro_savepoint;
1533:
1534: l_ro_error_count := l_ro_error_count + 1;
1535:
1536: Update csd_bulk_receive_items_b
1537: set status = 'ERRORED'
1538: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1539:
1540: -- Write to conc log