DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_PVT dependencies on CSD_BULK_RECEIVE_PVT

Line 1: PACKAGE BODY CSD_BULK_RECEIVE_PVT AS

1: PACKAGE BODY CSD_BULK_RECEIVE_PVT AS
2: /* $Header: csdvbrvb.pls 120.17.12010000.2 2008/10/31 00:46:44 swai ship $ */
3:
4: /*-----------------------------------------------------------------*/
5: /* procedure name: process_bulk_receive_items */

Line 218: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.BEGIN',

214: MO_GLOBAL.init('CS_CHARGES');
215:
216: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
217: fnd_log.STRING (fnd_log.level_procedure,
218: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.BEGIN',
219: 'Entered Process Bulk Receive Items');
220: End if;
221:
222: -- Verify the required parameter - Transaction Number

Line 227: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

223: If ( p_transaction_number is null ) then
224:
225: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
226: fnd_log.STRING (fnd_log.level_event,
227: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
228: 'Validate Transaction Number');
229: End if;
230:
231: Fnd_file.put_line(fnd_file.log,'Error: Transaction Number is null');

Line 245: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

241: If (fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'N') then
242:
243: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
244: fnd_log.STRING (fnd_log.level_event,
245: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
246: 'Change IB Owner Profile is No, verify Instance party and Entered Party');
247: End if;
248:
249: For c_set_party_rec in c_set_party ( p_transaction_number)

Line 279: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

275: If ( l_ib_owner_id <> c_set_party_rec.party_id) then
276:
277: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
278: fnd_log.STRING (fnd_log.level_statement,
279: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
280: 'Update: bulk_receive_id[' || c_set_party_rec.bulk_receive_id ||
281: '] with IB owner party id - '||l_ib_owner_id);
282: End if;
283:

Line 305: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

301: -- from the entered Party/Account
302: --
303: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
304: fnd_log.STRING (fnd_log.level_event,
305: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
306: 'Change IB Owner');
307: End if;
308:
309: For c_change_owner_rec in c_change_owner (p_transaction_number)

Line 326: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

322: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
323:
324: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
325: fnd_log.STRING (fnd_log.level_statement,
326: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
327: 'Change IB owner,Update : bulk_receive_id['
328: || c_change_owner_rec.bulk_receive_id ||
329: '] party id with orig party id');
330: End if;

Line 412: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

408: Savepoint create_intr_sr_savepoint;
409:
410: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
411: fnd_log.STRING (fnd_log.level_event,
412: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
413: 'Create Internal SR');
414: End if;
415:
416: l_intr_party_id := null;

Line 441: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

437: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
438:
439: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
440: fnd_log.STRING (fnd_log.level_statement,
441: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
442: 'Created Internal SR : Incident id = '
443: ||l_incident_id );
444: End if;
445:

Line 483: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

479: -- To Reprocess Errored RO's
480: --
481: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
482: fnd_log.STRING (fnd_log.level_event,
483: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
484: 'Check and reprocess Errored Repair Orders');
485: End if;
486:
487: For c_reprocess_ro_rec in c_reprocess_ro(p_transaction_number)

Line 494: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

490: Savepoint reprocess_ro_savepoint;
491:
492: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
493: fnd_log.STRING (fnd_log.level_event,
494: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
495: 'Reprocess RO - Call Create Repair Orders');
496: End if;
497:
498: -- Call Create RO Helper procedure

Line 517: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

513: -- no Logistic lines are created
514:
515: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
516: fnd_log.STRING (fnd_log.level_statement,
517: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
518: 'Reprocess RO - Created Repair Order ['||l_repair_line_id||'] in '
519: ||l_ro_status||' status' );
520: End if;
521:

Line 541: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

537: -- Call the create default product transaction
538:
539: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
540: fnd_log.STRING (fnd_log.level_event,
541: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
542: 'Reprocess RO - Call Create Product Transactions');
543: End if;
544:
545: csd_bulk_receive_util.create_blkrcv_default_prod_txn

Line 589: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

585: x_msg_data => l_msg_data
586: );
587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
588: fnd_log.STRING (fnd_log.level_statement,
589: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
590: 'Reprocess RO - After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
591: || l_repair_line_id || ']');
592: END IF;
593: -- ignore return status for now.

Line 635: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

631: Savepoint create_new_sr_savepoint;
632:
633: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
634: fnd_log.STRING (fnd_log.level_event,
635: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
636: 'Create SR');
637: End if;
638:
639: -- Create SR

Line 645: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

641: l_sr_bulk_receive_rec.cust_account_id := c_create_sr_rec.cust_account_id;
642:
643: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
644: fnd_log.STRING (fnd_log.level_statement,
645: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
646: 'Create SR for Party id - '||c_create_sr_rec.party_id
647: ||',Account Id - '||c_create_sr_rec.cust_account_id);
648: End if;
649:

Line 712: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

708: Savepoint create_ro_savepoint;
709:
710: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
711: fnd_log.STRING (fnd_log.level_event,
712: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
713: 'New SR - Call Create Repair Order');
714: End if;
715:
716: -- Call Create RO Helper procedure

Line 735: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

731: -- no Logistic lines are created.
732:
733: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
734: fnd_log.STRING (fnd_log.level_statement,
735: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
736: 'New SR - Created Repair Order ['||l_repair_line_id||'] in '
737: ||l_ro_status||' status' );
738: End if;
739:

Line 758: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

754:
755: -- Call to create default product transaction
756: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
757: fnd_log.STRING (fnd_log.level_event,
758: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
759: 'New SR - Call Create Product Transactions');
760: End if;
761:
762: csd_bulk_receive_util.create_blkrcv_default_prod_txn

Line 809: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

805: x_msg_data => l_msg_data
806: );
807: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
808: fnd_log.STRING (fnd_log.level_statement,
809: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
810: 'New SR - After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
811: || l_repair_line_id || ']');
812: END IF;
813: -- ignore return status for now.

Line 942: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

938:
939:
940: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
941: fnd_log.STRING (fnd_log.level_event,
942: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
943: 'Calling Auto Receive API');
944: End if;
945:
946: csd_bulk_receive_util.bulk_auto_receive

Line 966: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.END',

962: retcode := c_success;
963:
964: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
965: fnd_log.STRING (fnd_log.level_procedure,
966: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.END',
967: 'Exit - Process Bulk Receive Items');
968: End if;
969:
970: EXCEPTION

Line 1023: END CSD_BULK_RECEIVE_PVT;

1019: retcode := c_error ;
1020:
1021: END process_bulk_receive_items;
1022:
1023: END CSD_BULK_RECEIVE_PVT;