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.24.12020000.2 2013/04/03 07:00:22 subhat ship $ */
3:
4: /*-----------------------------------------------------------------*/
5: /* procedure name: process_bulk_receive_items */

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

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:
257: -- Verify the required parameter - Transaction Number

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

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:
266: Fnd_file.put_line(fnd_file.log,'Error: Transaction Number is null');

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

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:
284: For c_set_party_rec in c_set_party ( p_transaction_number)

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

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;
318:

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

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:
344: For c_change_owner_rec in c_change_owner (p_transaction_number)

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

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');
365: End if;

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

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:
451: l_intr_party_id := null;

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

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;
480:

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

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:
522: For c_reprocess_ro_rec in c_reprocess_ro(p_transaction_number)

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

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:
533: -- Call Create RO Helper procedure

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

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;
556:

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

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:
580: csd_bulk_receive_util.create_blkrcv_default_prod_txn

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

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;
628: -- ignore return status for now.

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

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';
664: -- loop through the records and populate the record for the receiving.

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

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,
682: p_instance_id => bk_rcv_rec.instance_id,

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

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
727: csd_mass_rcv_pvt.create_item_instance (

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

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,
751: p_instance_id => bk_rcv_rec.instance_id,

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

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;
792: l_bulk_autorcv_tbl(l_counter).repair_line_id := bk_rcv_rec.repair_line_id;

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

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(
829: p_api_version => 1,

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

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);
851:

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

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.
863: csd_bulk_receive_util.create_new_ship_line(

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

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;
938:

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

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:
946: l_bulk_autorcv_tbl(l_counter).bulk_receive_id := bk_rcv_rec.bulk_receive_id;

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

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;
1118: csd_bulk_receive_util.create_blkrcv_default_prod_txn

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

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);
1134:

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

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:
1158: csd_bulk_receive_util.create_blkrcv_ro(

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

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:
1174: fnd_file.put_line(fnd_file.log,'Error occured in repair order creation '||l_msg_data);

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

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:
1196: update csd_bulk_receive_items_b

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

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
1208: (

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

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);
1222: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

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

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
1288: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

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

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;
1294: end;

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

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:
1307: csd_bulk_receive_util.bulk_auto_receive

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

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);
1321: end if;

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

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:
1332:

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

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:
1351: -- Create SR

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

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;
1361:

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

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:
1428: -- Call Create RO Helper procedure

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

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;
1451:

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

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:
1474: csd_bulk_receive_util.create_blkrcv_default_prod_txn

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

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;
1525: -- ignore return status for now.

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

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:
1687: csd_bulk_receive_util.bulk_auto_receive

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

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:
1717: EXCEPTION

Line 1770: END CSD_BULK_RECEIVE_PVT;

1766: retcode := c_error ;
1767:
1768: END process_bulk_receive_items;
1769:
1770: END CSD_BULK_RECEIVE_PVT;