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 FND_LOG

Line 251: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

247: -- MOAC initialization
248: --
249: MO_GLOBAL.init('CS_CHARGES');
250:
251: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
252: fnd_log.STRING (fnd_log.level_procedure,
253: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.BEGIN',
254: 'Entered Process Bulk Receive Items');
255: End if;

Line 252: fnd_log.STRING (fnd_log.level_procedure,

248: --
249: MO_GLOBAL.init('CS_CHARGES');
250:
251: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
252: fnd_log.STRING (fnd_log.level_procedure,
253: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.BEGIN',
254: 'Entered Process Bulk Receive Items');
255: End if;
256:

Line 260: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

256:
257: -- Verify the required parameter - Transaction Number
258: If ( p_transaction_number is null ) then
259:
260: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
261: fnd_log.STRING (fnd_log.level_event,
262: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
263: 'Validate Transaction Number');
264: End if;

Line 261: fnd_log.STRING (fnd_log.level_event,

257: -- Verify the required parameter - Transaction Number
258: If ( p_transaction_number is null ) then
259:
260: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
261: fnd_log.STRING (fnd_log.level_event,
262: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
263: 'Validate Transaction Number');
264: End if;
265:

Line 278: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

274: -- then set the Party id of the Bulk Receive Rec
275: -- to the IB Owner Party
276: If (fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'N') then
277:
278: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
279: fnd_log.STRING (fnd_log.level_event,
280: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
281: 'Change IB Owner Profile is No, verify Instance party and Entered Party');
282: End if;

Line 279: fnd_log.STRING (fnd_log.level_event,

275: -- to the IB Owner Party
276: If (fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'N') then
277:
278: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
279: fnd_log.STRING (fnd_log.level_event,
280: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
281: 'Change IB Owner Profile is No, verify Instance party and Entered Party');
282: End if;
283:

Line 312: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

308: -- If the IB Owner is <> Entered Party then update the
309: -- Bulk Receive Party = IB Owner
310: If ( l_ib_owner_id <> c_set_party_rec.party_id) then
311:
312: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
313: fnd_log.STRING (fnd_log.level_statement,
314: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
315: 'Update: bulk_receive_id[' || c_set_party_rec.bulk_receive_id ||
316: '] with IB owner party id - '||l_ib_owner_id);

Line 313: fnd_log.STRING (fnd_log.level_statement,

309: -- Bulk Receive Party = IB Owner
310: If ( l_ib_owner_id <> c_set_party_rec.party_id) then
311:
312: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
313: fnd_log.STRING (fnd_log.level_statement,
314: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
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;

Line 338: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

334: -- Step - B
335: -- Change IB owner for records which have IB owner different
336: -- from the entered Party/Account
337: --
338: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
339: fnd_log.STRING (fnd_log.level_event,
340: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
341: 'Change IB Owner');
342: End if;

Line 339: fnd_log.STRING (fnd_log.level_event,

335: -- Change IB owner for records which have IB owner different
336: -- from the entered Party/Account
337: --
338: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
339: fnd_log.STRING (fnd_log.level_event,
340: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
341: 'Change IB Owner');
342: End if;
343:

Line 359: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

355: );
356:
357: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
358:
359: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
360: fnd_log.STRING (fnd_log.level_statement,
361: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
362: 'Change IB owner,Update : bulk_receive_id['
363: || c_change_owner_rec.bulk_receive_id ||

Line 360: fnd_log.STRING (fnd_log.level_statement,

356:
357: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
358:
359: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
360: fnd_log.STRING (fnd_log.level_statement,
361: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
362: 'Change IB owner,Update : bulk_receive_id['
363: || c_change_owner_rec.bulk_receive_id ||
364: '] party id with orig party id');

Line 445: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

441: If ( l_create_intr_sr ) then
442: -- Call the Create Service Request API
443: Savepoint create_intr_sr_savepoint;
444:
445: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
446: fnd_log.STRING (fnd_log.level_event,
447: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
448: 'Create Internal SR');
449: End if;

Line 446: fnd_log.STRING (fnd_log.level_event,

442: -- Call the Create Service Request API
443: Savepoint create_intr_sr_savepoint;
444:
445: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
446: fnd_log.STRING (fnd_log.level_event,
447: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
448: 'Create Internal SR');
449: End if;
450:

Line 474: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

470: );
471:
472: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
473:
474: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
475: fnd_log.STRING (fnd_log.level_statement,
476: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
477: 'Created Internal SR : Incident id = '
478: ||l_incident_id );

Line 475: fnd_log.STRING (fnd_log.level_statement,

471:
472: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
473:
474: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
475: fnd_log.STRING (fnd_log.level_statement,
476: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
477: 'Created Internal SR : Incident id = '
478: ||l_incident_id );
479: End if;

Line 516: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

512: --
513: -- Step - D
514: -- To Reprocess Errored RO's
515: --
516: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
517: fnd_log.STRING (fnd_log.level_event,
518: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
519: 'Check and reprocess Errored Repair Orders');
520: End if;

Line 517: fnd_log.STRING (fnd_log.level_event,

513: -- Step - D
514: -- To Reprocess Errored RO's
515: --
516: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
517: fnd_log.STRING (fnd_log.level_event,
518: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
519: 'Check and reprocess Errored Repair Orders');
520: End if;
521:

Line 527: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

523: Loop
524:
525: Savepoint reprocess_ro_savepoint;
526:
527: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
528: fnd_log.STRING (fnd_log.level_event,
529: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
530: 'Reprocess RO - Call Create Repair Orders');
531: End if;

Line 528: fnd_log.STRING (fnd_log.level_event,

524:
525: Savepoint reprocess_ro_savepoint;
526:
527: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
528: fnd_log.STRING (fnd_log.level_event,
529: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
530: 'Reprocess RO - Call Create Repair Orders');
531: End if;
532:

Line 550: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

546:
547: -- If RO is created in Draft status then
548: -- no Logistic lines are created
549:
550: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
551: fnd_log.STRING (fnd_log.level_statement,
552: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
553: 'Reprocess RO - Created Repair Order ['||l_repair_line_id||'] in '
554: ||l_ro_status||' status' );

Line 551: fnd_log.STRING (fnd_log.level_statement,

547: -- If RO is created in Draft status then
548: -- no Logistic lines are created
549:
550: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
551: fnd_log.STRING (fnd_log.level_statement,
552: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
553: 'Reprocess RO - Created Repair Order ['||l_repair_line_id||'] in '
554: ||l_ro_status||' status' );
555: End if;

Line 574: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

570: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
571:
572: -- Call the create default product transaction
573:
574: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
575: fnd_log.STRING (fnd_log.level_event,
576: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
577: 'Reprocess RO - Call Create Product Transactions');
578: End if;

Line 575: fnd_log.STRING (fnd_log.level_event,

571:
572: -- Call the create default product transaction
573:
574: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
575: fnd_log.STRING (fnd_log.level_event,
576: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
577: 'Reprocess RO - Call Create Product Transactions');
578: End if;
579:

Line 622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

618: x_return_status => l_return_status,
619: x_msg_count => l_msg_count,
620: x_msg_data => l_msg_data
621: );
622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
623: fnd_log.STRING (fnd_log.level_statement,
624: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
625: 'Reprocess RO - After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
626: || l_repair_line_id || ']');

Line 623: fnd_log.STRING (fnd_log.level_statement,

619: x_msg_count => l_msg_count,
620: x_msg_data => l_msg_data
621: );
622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
623: fnd_log.STRING (fnd_log.level_statement,
624: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
625: 'Reprocess RO - After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
626: || l_repair_line_id || ']');
627: END IF;

Line 658: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

654:
655: -- 12.2 subhat
656: if NVL(FND_PROFILE.value('CSD_EXP_RCPT_FOR_BLKRCV'),'N') = 'Y' THEN
657: --
658: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
659: fnd_log.STRING (fnd_log.level_procedure,
660: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
661: 'Entered program unit to receive the matched lines');
662: End if;

Line 659: fnd_log.STRING (fnd_log.level_procedure,

655: -- 12.2 subhat
656: if NVL(FND_PROFILE.value('CSD_EXP_RCPT_FOR_BLKRCV'),'N') = 'Y' THEN
657: --
658: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
659: fnd_log.STRING (fnd_log.level_procedure,
660: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
661: 'Entered program unit to receive the matched lines');
662: End if;
663: l_create_sr_flag := 'N';

Line 676: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

672: if bk_rcv_rec.order_header_id is not null and bk_rcv_rec.order_line_id is not null then
673: -- external ref# handling.
674: if bk_rcv_rec.instance_id is not null and bk_rcv_rec.external_reference is not null
675: then
676: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
677: fnd_log.STRING (fnd_log.level_procedure,
678: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
679: 'Calling csd_bulk_receive_util.update_external_reference');
680: End if;

Line 677: fnd_log.STRING (fnd_log.level_procedure,

673: -- external ref# handling.
674: if bk_rcv_rec.instance_id is not null and bk_rcv_rec.external_reference is not null
675: then
676: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
677: fnd_log.STRING (fnd_log.level_procedure,
678: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
679: 'Calling csd_bulk_receive_util.update_external_reference');
680: End if;
681: csd_repair_manager_util.update_external_reference(p_external_reference => bk_rcv_rec.external_reference,

Line 721: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

717: l_instance_rec.account_id := bk_rcv_rec.cust_account_id;
718: l_instance_rec.mfg_serial_number_flag := 'N';
719: l_instance_rec.external_reference := bk_rcv_rec.external_reference;
720:
721: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
722: fnd_log.STRING (fnd_log.level_procedure,
723: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
724: 'Calling csd_mass_rcv_pvt.create_item_instance');
725: End if;

Line 722: fnd_log.STRING (fnd_log.level_procedure,

718: l_instance_rec.mfg_serial_number_flag := 'N';
719: l_instance_rec.external_reference := bk_rcv_rec.external_reference;
720:
721: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
722: fnd_log.STRING (fnd_log.level_procedure,
723: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
724: 'Calling csd_mass_rcv_pvt.create_item_instance');
725: End if;
726: -- call the API to create the instance

Line 745: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

741: when FND_API.G_EXC_ERROR then
742: null;
743: end;
744: else
745: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
746: fnd_log.STRING (fnd_log.level_procedure,
747: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
748: 'Calling csd_mass_rcv_pvt.update_external_reference');
749: End if;

Line 746: fnd_log.STRING (fnd_log.level_procedure,

742: null;
743: end;
744: else
745: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
746: fnd_log.STRING (fnd_log.level_procedure,
747: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
748: 'Calling csd_mass_rcv_pvt.update_external_reference');
749: End if;
750: csd_repair_manager_util.update_external_reference(p_external_reference => bk_rcv_rec.external_reference,

Line 786: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

782: end if;
783: if l_continue_further then
784: if nvl(bk_rcv_rec.under_receipt_flag,'N') = 'Y' then
785: -- split the existing line.
786: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
787: fnd_log.STRING(fnd_log.level_procedure,
788: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
789: 'Under-receipt: Under receipt for repair_line_id '||bk_rcv_rec.repair_line_id);
790: End if;

Line 787: fnd_log.STRING(fnd_log.level_procedure,

783: if l_continue_further then
784: if nvl(bk_rcv_rec.under_receipt_flag,'N') = 'Y' then
785: -- split the existing line.
786: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
787: fnd_log.STRING(fnd_log.level_procedure,
788: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
789: 'Under-receipt: Under receipt for repair_line_id '||bk_rcv_rec.repair_line_id);
790: End if;
791: l_bulk_autorcv_tbl(l_counter).bulk_receive_id := bk_rcv_rec.bulk_receive_id;

Line 823: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

819:
820: elsif nvl(bk_rcv_rec.over_receipt_flag,'N') = 'Y' then
821: -- create a new RMA for the over receipt quantity
822: -- call the util procedure to create the new RMA line.
823: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
824: fnd_log.STRING (fnd_log.level_procedure,
825: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
826: 'Over-receipt: Before calling csd_bulk_receive_util.create_new_rma');
827: End if;

Line 824: fnd_log.STRING (fnd_log.level_procedure,

820: elsif nvl(bk_rcv_rec.over_receipt_flag,'N') = 'Y' then
821: -- create a new RMA for the over receipt quantity
822: -- call the util procedure to create the new RMA line.
823: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
824: fnd_log.STRING (fnd_log.level_procedure,
825: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
826: 'Over-receipt: Before calling csd_bulk_receive_util.create_new_rma');
827: End if;
828: csd_bulk_receive_util.create_new_rma(

Line 845: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

841: x_order_header_id => l_order_header_id
842: );
843: if l_return_status <> g_ret_sts_success then
844: -- error during rma creation.
845: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
846: fnd_log.STRING (fnd_log.level_procedure,
847: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
848: 'Error during new RMA creation '||l_msg_data);
849: End if;

Line 846: fnd_log.STRING (fnd_log.level_procedure,

842: );
843: if l_return_status <> g_ret_sts_success then
844: -- error during rma creation.
845: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
846: fnd_log.STRING (fnd_log.level_procedure,
847: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
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);

Line 857: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

853: set status = 'ERRORED'
854: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
855:
856: else
857: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
858: fnd_log.STRING (fnd_log.level_procedure,
859: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
860: 'Populate the bulk receive table '||bk_rcv_rec.order_header_id||'['||bk_rcv_rec.order_line_id||']');
861: End if;

Line 858: fnd_log.STRING (fnd_log.level_procedure,

854: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
855:
856: else
857: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
858: fnd_log.STRING (fnd_log.level_procedure,
859: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
860: 'Populate the bulk receive table '||bk_rcv_rec.order_header_id||'['||bk_rcv_rec.order_line_id||']');
861: End if;
862: -- auto create the ship lines for the over-receipt quantity.

Line 932: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

928: l_bulk_autorcv_tbl(l_counter).rcv_attribute12 := bk_rcv_rec.rcv_attribute12;
929: l_bulk_autorcv_tbl(l_counter).rcv_attribute13 := bk_rcv_rec.rcv_attribute13;
930: l_bulk_autorcv_tbl(l_counter).rcv_attribute14 := bk_rcv_rec.rcv_attribute14;
931: l_bulk_autorcv_tbl(l_counter).rcv_attribute15 := bk_rcv_rec.rcv_attribute15;
932: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
933: fnd_log.STRING (fnd_log.level_procedure,
934: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
935: 'Populated bulk receive rec for over receipt '||l_order_header_id||'['||l_order_line_id||']');
936: End if;

Line 933: fnd_log.STRING (fnd_log.level_procedure,

929: l_bulk_autorcv_tbl(l_counter).rcv_attribute13 := bk_rcv_rec.rcv_attribute13;
930: l_bulk_autorcv_tbl(l_counter).rcv_attribute14 := bk_rcv_rec.rcv_attribute14;
931: l_bulk_autorcv_tbl(l_counter).rcv_attribute15 := bk_rcv_rec.rcv_attribute15;
932: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
933: fnd_log.STRING (fnd_log.level_procedure,
934: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
935: 'Populated bulk receive rec for over receipt '||l_order_header_id||'['||l_order_line_id||']');
936: End if;
937: end if;

Line 940: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

936: End if;
937: end if;
938:
939: else -- regular expected receipt
940: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
941: fnd_log.STRING (fnd_log.level_procedure,
942: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
943: 'Populating the bulk receive table for receipt against existing RMAs');
944: End if;

Line 941: fnd_log.STRING (fnd_log.level_procedure,

937: end if;
938:
939: else -- regular expected receipt
940: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
941: fnd_log.STRING (fnd_log.level_procedure,
942: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
943: 'Populating the bulk receive table for receipt against existing RMAs');
944: End if;
945:

Line 1112: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1108: x_msg_data => l_msg_data);
1109: end if;
1110:
1111: end if;
1112: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1113: fnd_log.STRING (fnd_log.level_procedure,
1114: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1115: 'calling create default product transaction with bulk_receive_id '
1116: ||bk_rcv_rec.bulk_receive_id);

Line 1113: fnd_log.STRING (fnd_log.level_procedure,

1109: end if;
1110:
1111: end if;
1112: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1113: fnd_log.STRING (fnd_log.level_procedure,
1114: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1115: 'calling create default product transaction with bulk_receive_id '
1116: ||bk_rcv_rec.bulk_receive_id);
1117: End if;

Line 1128: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1124: );
1125:
1126: if l_return_status <> g_ret_sts_success then
1127:
1128: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1129: fnd_log.STRING (fnd_log.level_procedure,
1130: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1131: 'Error while creating default product txn lines '||l_msg_data);
1132: End if;

Line 1129: fnd_log.STRING (fnd_log.level_procedure,

1125:
1126: if l_return_status <> g_ret_sts_success then
1127:
1128: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1129: fnd_log.STRING (fnd_log.level_procedure,
1130: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
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);

Line 1152: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1148: -- no matching RO's found, create new RO and product lines.
1149: elsif bk_rcv_rec.incident_id is not null then
1150: -- call the create ro util api to create a new repair order.
1151:
1152: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1153: fnd_log.STRING (fnd_log.level_procedure,
1154: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1155: 'Unplanned receipt: Before calling csd_bulk_receive_util.create_blkrcv_ro');
1156: End if;

Line 1153: fnd_log.STRING (fnd_log.level_procedure,

1149: elsif bk_rcv_rec.incident_id is not null then
1150: -- call the create ro util api to create a new repair order.
1151:
1152: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1153: fnd_log.STRING (fnd_log.level_procedure,
1154: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1155: 'Unplanned receipt: Before calling csd_bulk_receive_util.create_blkrcv_ro');
1156: End if;
1157:

Line 1168: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1164: x_msg_count => l_msg_count,
1165: x_msg_data => l_msg_data
1166: );
1167: if l_return_status <> g_ret_sts_success then
1168: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1169: fnd_log.STRING (fnd_log.level_procedure,
1170: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1171: 'Error occured while creating RO '||l_msg_data);
1172: End if;

Line 1169: fnd_log.STRING (fnd_log.level_procedure,

1165: x_msg_data => l_msg_data
1166: );
1167: if l_return_status <> g_ret_sts_success then
1168: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1169: fnd_log.STRING (fnd_log.level_procedure,
1170: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1171: 'Error occured while creating RO '||l_msg_data);
1172: End if;
1173:

Line 1190: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

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
1190: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1191: fnd_log.STRING (fnd_log.level_procedure,
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;

Line 1191: fnd_log.STRING (fnd_log.level_procedure,

1187: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1188:
1189: if l_ro_status = 'DRAFT' then
1190: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1191: fnd_log.STRING (fnd_log.level_procedure,
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:

Line 1202: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1198: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1199:
1200: else
1201: -- call the create default product txn helper to create the RMA's.
1202: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1203: fnd_log.STRING (fnd_log.level_procedure,
1204: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1205: 'Unplanned Receipt: Before calling csd_bulk_receive_util.create_blkrcv_default_prod_txn');
1206: End if;

Line 1203: fnd_log.STRING (fnd_log.level_procedure,

1199:
1200: else
1201: -- call the create default product txn helper to create the RMA's.
1202: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1203: fnd_log.STRING (fnd_log.level_procedure,
1204: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1205: 'Unplanned Receipt: Before calling csd_bulk_receive_util.create_blkrcv_default_prod_txn');
1206: End if;
1207: csd_bulk_receive_util.create_blkrcv_default_prod_txn

Line 1216: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1212: x_msg_data => l_msg_data
1213: );
1214:
1215: if l_return_status <> g_ret_sts_success then
1216: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1217: fnd_log.STRING (fnd_log.level_procedure,
1218: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1219: 'Error occured while creating default product lines '||l_msg_data);
1220: End if;

Line 1217: fnd_log.STRING (fnd_log.level_procedure,

1213: );
1214:
1215: if l_return_status <> g_ret_sts_success then
1216: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1217: fnd_log.STRING (fnd_log.level_procedure,
1218: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1219: 'Error occured while creating default product lines '||l_msg_data);
1220: End if;
1221: fnd_file.put_line(fnd_file.log,'Error occured during creation of default logistics lines '||l_msg_data);

Line 1282: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1278:
1279: end if;
1280: exception
1281: when FND_API.G_EXC_ERROR then
1282: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1283: fnd_log.STRING (fnd_log.level_procedure,
1284: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1285: 'Error occured during unplanned receipt processing '||l_msg_data);
1286: End if;

Line 1283: fnd_log.STRING (fnd_log.level_procedure,

1279: end if;
1280: exception
1281: when FND_API.G_EXC_ERROR then
1282: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1283: fnd_log.STRING (fnd_log.level_procedure,
1284: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1285: 'Error occured during unplanned receipt processing '||l_msg_data);
1286: End if;
1287: when others then

Line 1288: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1284: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1285: 'Error occured during unplanned receipt processing '||l_msg_data);
1286: End if;
1287: when others then
1288: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1289: fnd_log.STRING (fnd_log.level_procedure,
1290: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1291: 'In when others: '||SQLERRM);
1292: End if;

Line 1289: fnd_log.STRING (fnd_log.level_procedure,

1285: 'Error occured during unplanned receipt processing '||l_msg_data);
1286: End if;
1287: when others then
1288: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1289: fnd_log.STRING (fnd_log.level_procedure,
1290: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1291: 'In when others: '||SQLERRM);
1292: End if;
1293: raise;

Line 1301: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1297: end loop;
1298: commit;
1299:
1300: if l_bulk_autorcv_tbl.COUNT >= 1 THEN
1301: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1302: fnd_log.STRING (fnd_log.level_procedure,
1303: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1304: 'Calling csd_bulk_receive_util.bulk_auto_receive');
1305: End if;

Line 1302: fnd_log.STRING (fnd_log.level_procedure,

1298: commit;
1299:
1300: if l_bulk_autorcv_tbl.COUNT >= 1 THEN
1301: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1302: fnd_log.STRING (fnd_log.level_procedure,
1303: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1304: 'Calling csd_bulk_receive_util.bulk_auto_receive');
1305: End if;
1306:

Line 1315: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1311: x_msg_data => l_msg_data
1312: );
1313: end if;
1314: if l_return_status <> g_ret_sts_success then
1315: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1316: fnd_log.STRING (fnd_log.level_procedure,
1317: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1318: 'Error in csd_bulk_receive_util.bulk_auto_receive '||l_msg_data);
1319: End if;

Line 1316: fnd_log.STRING (fnd_log.level_procedure,

1312: );
1313: end if;
1314: if l_return_status <> g_ret_sts_success then
1315: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1316: fnd_log.STRING (fnd_log.level_procedure,
1317: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1318: 'Error in csd_bulk_receive_util.bulk_auto_receive '||l_msg_data);
1319: End if;
1320: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

Line 1326: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1322:
1323: end if;
1324:
1325: if l_create_sr_flag = 'Y' then
1326: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1327: fnd_log.STRING (fnd_log.level_procedure,
1328: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1329: 'Into create new SR, RO and RMA');
1330: End if;

Line 1327: fnd_log.STRING (fnd_log.level_procedure,

1323: end if;
1324:
1325: if l_create_sr_flag = 'Y' then
1326: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1327: fnd_log.STRING (fnd_log.level_procedure,
1328: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1329: 'Into create new SR, RO and RMA');
1330: End if;
1331:

Line 1345: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

1341: Loop
1342: -- SR Savepoint
1343: Savepoint create_new_sr_savepoint;
1344:
1345: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1346: fnd_log.STRING (fnd_log.level_event,
1347: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1348: 'Create SR');
1349: End if;

Line 1346: fnd_log.STRING (fnd_log.level_event,

1342: -- SR Savepoint
1343: Savepoint create_new_sr_savepoint;
1344:
1345: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1346: fnd_log.STRING (fnd_log.level_event,
1347: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1348: 'Create SR');
1349: End if;
1350:

Line 1355: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1351: -- Create SR
1352: l_sr_bulk_receive_rec.party_id := c_create_sr_rec.party_id;
1353: l_sr_bulk_receive_rec.cust_account_id := c_create_sr_rec.cust_account_id;
1354:
1355: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1356: fnd_log.STRING (fnd_log.level_statement,
1357: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1358: 'Create SR for Party id - '||c_create_sr_rec.party_id
1359: ||',Account Id - '||c_create_sr_rec.cust_account_id);

Line 1356: fnd_log.STRING (fnd_log.level_statement,

1352: l_sr_bulk_receive_rec.party_id := c_create_sr_rec.party_id;
1353: l_sr_bulk_receive_rec.cust_account_id := c_create_sr_rec.cust_account_id;
1354:
1355: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1356: fnd_log.STRING (fnd_log.level_statement,
1357: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1358: 'Create SR for Party id - '||c_create_sr_rec.party_id
1359: ||',Account Id - '||c_create_sr_rec.cust_account_id);
1360: End if;

Line 1422: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

1418: l_c_create_ro_rowcount := c_create_ro%rowcount;
1419:
1420: Savepoint create_ro_savepoint;
1421:
1422: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1423: fnd_log.STRING (fnd_log.level_event,
1424: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1425: 'New SR - Call Create Repair Order');
1426: End if;

Line 1423: fnd_log.STRING (fnd_log.level_event,

1419:
1420: Savepoint create_ro_savepoint;
1421:
1422: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1423: fnd_log.STRING (fnd_log.level_event,
1424: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1425: 'New SR - Call Create Repair Order');
1426: End if;
1427:

Line 1445: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1441:
1442: -- If the RO is created in Draft status then
1443: -- no Logistic lines are created.
1444:
1445: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1446: fnd_log.STRING (fnd_log.level_statement,
1447: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1448: 'New SR - Created Repair Order ['||l_repair_line_id||'] in '
1449: ||l_ro_status||' status' );

Line 1446: fnd_log.STRING (fnd_log.level_statement,

1442: -- If the RO is created in Draft status then
1443: -- no Logistic lines are created.
1444:
1445: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1446: fnd_log.STRING (fnd_log.level_statement,
1447: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1448: 'New SR - Created Repair Order ['||l_repair_line_id||'] in '
1449: ||l_ro_status||' status' );
1450: End if;

Line 1468: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

1464: status = 'NEW'
1465: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1466:
1467: -- Call to create default product transaction
1468: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1469: fnd_log.STRING (fnd_log.level_event,
1470: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1471: 'New SR - Call Create Product Transactions');
1472: End if;

Line 1469: fnd_log.STRING (fnd_log.level_event,

1465: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1466:
1467: -- Call to create default product transaction
1468: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1469: fnd_log.STRING (fnd_log.level_event,
1470: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1471: 'New SR - Call Create Product Transactions');
1472: End if;
1473:

Line 1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1515: x_return_status => l_return_status,
1516: x_msg_count => l_msg_count,
1517: x_msg_data => l_msg_data
1518: );
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1520: fnd_log.STRING (fnd_log.level_statement,
1521: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1522: 'New SR - After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
1523: || l_repair_line_id || ']');

Line 1520: fnd_log.STRING (fnd_log.level_statement,

1516: x_msg_count => l_msg_count,
1517: x_msg_data => l_msg_data
1518: );
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1520: fnd_log.STRING (fnd_log.level_statement,
1521: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1522: 'New SR - After CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO['
1523: || l_repair_line_id || ']');
1524: END IF;

Line 1681: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

1677:
1678: If ( l_bulk_autorcv_tbl.count > 0 ) then
1679:
1680:
1681: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1682: fnd_log.STRING (fnd_log.level_event,
1683: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1684: 'Calling Auto Receive API');
1685: End if;

Line 1682: fnd_log.STRING (fnd_log.level_event,

1678: If ( l_bulk_autorcv_tbl.count > 0 ) then
1679:
1680:
1681: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1682: fnd_log.STRING (fnd_log.level_event,
1683: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1684: 'Calling Auto Receive API');
1685: End if;
1686:

Line 1711: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

1707: ( p_transaction_number => p_transaction_number);
1708: end if;
1709: retcode := c_success;
1710:
1711: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1712: fnd_log.STRING (fnd_log.level_procedure,
1713: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.END',
1714: 'Exit - Process Bulk Receive Items');
1715: End if;

Line 1712: fnd_log.STRING (fnd_log.level_procedure,

1708: end if;
1709: retcode := c_success;
1710:
1711: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1712: fnd_log.STRING (fnd_log.level_procedure,
1713: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS.END',
1714: 'Exit - Process Bulk Receive Items');
1715: End if;
1716: