DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_PVT dependencies on CSD_BULK_RECEIVE_UTIL

Line 161: l_sr_bulk_receive_rec csd_bulk_receive_util.bulk_receive_rec;

157: l_return_status Varchar2(1);
158: l_ro_error_count Number;
159: l_msg_count Number;
160: l_msg_data Varchar2(2000);
161: l_sr_bulk_receive_rec csd_bulk_receive_util.bulk_receive_rec;
162: l_ro_status Varchar2(30);
163: l_c_create_ro_rowcount Number;
164: l_order_status Varchar2(30);
165: l_intr_party_id Number;

Line 172: l_bulk_autorcv_tbl csd_bulk_receive_util.bulk_autorcv_tbl;

168: l_ib_owner_acct_id Number;
169: l_ib_flag Varchar2(1);
170: l_intr_sr_notes_table cs_servicerequest_pub.notes_table;
171: l_sr_notes_table cs_servicerequest_pub.notes_table;
172: l_bulk_autorcv_tbl csd_bulk_receive_util.bulk_autorcv_tbl;
173: l_procedure_name Varchar2(30) := 'csd_bulk_receive_items_pvt';
174: l_create_intr_sr Boolean;
175: l_intr_cust_acct_id Number;
176: l_warning_desc Varchar2(240);

Line 191: x_sr_ro_rma_tbl CSD_BULK_RECEIVE_UTIL.sr_ro_rma_tbl;

187: -- swai: 12.1.1 bug 7176940 service bulletin check
188: l_ro_sc_ids_tbl CSD_RO_BULLETINS_PVT.CSD_RO_SC_IDS_TBL_TYPE;
189:
190: -- subhat: 12.1.2 BR ER FP changes
191: x_sr_ro_rma_tbl CSD_BULK_RECEIVE_UTIL.sr_ro_rma_tbl;
192: l_create_sr_flag VARCHAR2(3) := 'Y';
193: l_counter number := 0;
194: g_ret_sts_success varchar2(3) := FND_API.G_RET_STS_SUCCESS;
195: l_prod_txn_rec csd_process_pvt.product_txn_rec;

Line 216: csd_bulk_receive_util.after_receipt(p_request_group_id => x,

212: if x > 0 then
213: errbuf := 'Done';
214: retcode := 0;
215: -- carry out post receipt processing.
216: csd_bulk_receive_util.after_receipt(p_request_group_id => x,
217: p_transaction_number => p_transaction_number);
218: -- lets write the output and then return.
219: csd_bulk_receive_util.write_to_conc_output
220: ( p_transaction_number => p_transaction_number);

Line 219: csd_bulk_receive_util.write_to_conc_output

215: -- carry out post receipt processing.
216: csd_bulk_receive_util.after_receipt(p_request_group_id => x,
217: p_transaction_number => p_transaction_number);
218: -- lets write the output and then return.
219: csd_bulk_receive_util.write_to_conc_output
220: ( p_transaction_number => p_transaction_number);
221: return;
222: end if;
223: else

Line 349: csd_bulk_receive_util.change_blkrcv_ib_owner

345: Loop
346:
347: Savepoint change_ib_owner;
348:
349: csd_bulk_receive_util.change_blkrcv_ib_owner
350: (
351: p_bulk_receive_id => c_change_owner_rec.bulk_receive_id,
352: x_return_status => l_return_status,
353: x_msg_count => l_msg_count,

Line 384: csd_bulk_receive_util.write_to_conc_log

380: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
381: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
382: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
383:
384: csd_bulk_receive_util.write_to_conc_log
385: ( p_msg_count => l_msg_count,
386: p_msg_data => l_msg_data);
387:
388: End If;

Line 461: csd_bulk_receive_util.create_blkrcv_sr

457:
458: l_sr_bulk_receive_rec.party_id := l_intr_party_id;
459: l_sr_bulk_receive_rec.cust_account_id := l_intr_cust_acct_id;
460:
461: csd_bulk_receive_util.create_blkrcv_sr
462: (
463: p_bulk_receive_rec => l_sr_bulk_receive_rec,
464: p_sr_notes_tbl => l_intr_sr_notes_table,
465: x_incident_id => l_incident_id,

Line 504: csd_bulk_receive_util.write_to_conc_log

500: -- Write to Conc Log
501: Fnd_file.put_line(fnd_file.log,'Error: Creation of Internal Service Request failed');
502: Fnd_file.put_line(fnd_file.log,'Internal party id :'||l_intr_party_id);
503:
504: csd_bulk_receive_util.write_to_conc_log
505: ( p_msg_count => l_msg_count,
506: p_msg_data => l_msg_data);
507:
508: End if;

Line 534: csd_bulk_receive_util.create_blkrcv_ro

530: 'Reprocess RO - Call Create Repair Orders');
531: End if;
532:
533: -- Call Create RO Helper procedure
534: csd_bulk_receive_util.create_blkrcv_ro
535: (
536: p_bulk_receive_id => c_reprocess_ro_rec.bulk_receive_id,
537: x_repair_line_id => l_repair_line_id,
538: x_repair_number => l_repair_number,

Line 580: csd_bulk_receive_util.create_blkrcv_default_prod_txn

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
581: (
582: p_bulk_receive_id => c_reprocess_ro_rec.bulk_receive_id,
583: x_return_status => l_return_status,
584: x_msg_count => l_msg_count,

Line 603: csd_bulk_receive_util.write_to_conc_log

599: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
600: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
601: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
602:
603: csd_bulk_receive_util.write_to_conc_log
604: ( p_msg_count => l_msg_count,
605: p_msg_data => l_msg_data);
606:
607: End if;

Line 647: csd_bulk_receive_util.write_to_conc_log

643: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
644: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
645: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
646:
647: csd_bulk_receive_util.write_to_conc_log
648: ( p_msg_count => l_msg_count,
649: p_msg_data => l_msg_data);
650:
651: End if;

Line 679: 'Calling csd_bulk_receive_util.update_external_reference');

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,
683: x_return_status => l_return_status,

Line 760: csd_bulk_receive_util.pre_process_rma

756:
757: end if;
758: -- we need to make sure that the RMA is booked.
759: -- RMA can be in submitted status too.
760: csd_bulk_receive_util.pre_process_rma
761: ( p_repair_line_id => bk_rcv_rec.repair_line_id,
762: px_order_header_id => bk_rcv_rec.order_header_id,
763: px_order_line_id => bk_rcv_rec.order_line_id,
764: x_msg_count => l_msg_count,

Line 771: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

767: );
768: if l_return_status <> fnd_api.g_ret_sts_success then
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;

Line 826: 'Over-receipt: Before calling csd_bulk_receive_util.create_new_rma');

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,
830: p_init_msg_list => FND_API.G_FALSE,

Line 828: csd_bulk_receive_util.create_new_rma(

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,
830: p_init_msg_list => FND_API.G_FALSE,
831: p_commit => FND_API.G_FALSE,
832: p_order_header_id => bk_rcv_rec.order_header_id,

Line 850: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

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:
852: update csd_bulk_receive_items_b
853: set status = 'ERRORED'
854: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line 863: csd_bulk_receive_util.create_new_ship_line(

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(
864: p_api_version => 1,
865: p_init_msg_list => FND_API.G_FALSE,
866: p_commit => FND_API.G_FALSE,
867: p_order_header_id => bk_rcv_rec.order_header_id,

Line 875: -- of the processing.csd_bulk_receive_util.create_new_ship_line does rollback

871: x_return_status => l_return_status,
872: x_msg_count => l_msg_count,
873: x_msg_data => l_msg_data);
874: -- if there is any error during creation new ship line, we wont stall the rest
875: -- of the processing.csd_bulk_receive_util.create_new_ship_line does rollback
876: -- to savepoint when it hits an error.
877:
878: l_bulk_autorcv_tbl(l_counter).bulk_receive_id := bk_rcv_rec.bulk_receive_id;
879: l_bulk_autorcv_tbl(l_counter).repair_line_id := bk_rcv_rec.repair_line_id;

Line 980: csd_bulk_receive_util.pre_process_rma

976: -- Unplanned Receipt = 'N' but no order header or line id.
977: -- The RMA line is not yet interfaced to OM. Book the order and process it.
978: elsif bk_rcv_rec.order_line_id is null and bk_rcv_rec.unplanned_receipt_flag = 'N'
979: then
980: csd_bulk_receive_util.pre_process_rma
981: ( p_repair_line_id => bk_rcv_rec.repair_line_id,
982: px_order_header_id => bk_rcv_rec.order_header_id,
983: px_order_line_id => bk_rcv_rec.order_line_id,
984: x_msg_count => l_msg_count,

Line 992: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

988:
989: if l_return_status <> fnd_api.g_ret_sts_success then
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;

Line 1118: csd_bulk_receive_util.create_blkrcv_default_prod_txn

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
1119: (
1120: p_bulk_receive_id => bk_rcv_rec.bulk_receive_id,
1121: x_return_status => l_return_status,
1122: x_msg_count => l_msg_count,

Line 1133: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

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:
1135: update csd_bulk_receive_items_b
1136: set status = 'ERRORED'
1137: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line 1155: 'Unplanned receipt: Before calling csd_bulk_receive_util.create_blkrcv_ro');

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(
1159: p_bulk_receive_id => bk_rcv_rec.bulk_receive_id,

Line 1158: csd_bulk_receive_util.create_blkrcv_ro(

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(
1159: p_bulk_receive_id => bk_rcv_rec.bulk_receive_id,
1160: x_repair_line_id => l_repair_line_id,
1161: x_repair_number => l_repair_number,
1162: x_ro_status => l_ro_status,

Line 1180: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

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);
1181:
1182: raise fnd_api.g_exc_error;
1183: end if;
1184:

Line 1205: 'Unplanned Receipt: Before calling csd_bulk_receive_util.create_blkrcv_default_prod_txn');

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: (
1209: p_bulk_receive_id => bk_rcv_rec.bulk_receive_id,

Line 1207: csd_bulk_receive_util.create_blkrcv_default_prod_txn

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: (
1209: p_bulk_receive_id => bk_rcv_rec.bulk_receive_id,
1210: x_return_status => l_return_status,
1211: x_msg_count => l_msg_count,

Line 1222: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

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);
1223:
1224: update csd_bulk_receive_items_b
1225: set status = 'ERRORED'
1226: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;

Line 1304: 'Calling csd_bulk_receive_util.bulk_auto_receive');

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
1308: ( p_bulk_autorcv_tbl => l_bulk_autorcv_tbl,

Line 1307: csd_bulk_receive_util.bulk_auto_receive

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
1308: ( p_bulk_autorcv_tbl => l_bulk_autorcv_tbl,
1309: x_return_status => l_return_status,
1310: x_msg_count => l_msg_count,
1311: x_msg_data => l_msg_data

Line 1318: 'Error in csd_bulk_receive_util.bulk_auto_receive '||l_msg_data);

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

Line 1320: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);

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;
1322:
1323: end if;
1324:

Line 1362: csd_bulk_receive_util.create_blkrcv_sr

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:
1362: csd_bulk_receive_util.create_blkrcv_sr
1363: (
1364: p_bulk_receive_rec => l_sr_bulk_receive_rec,
1365: p_sr_notes_tbl => l_sr_notes_table,
1366: x_incident_id => l_incident_id,

Line 1403: csd_bulk_receive_util.write_to_conc_log

1399: -- Write to conc log
1400: Fnd_file.put_line(fnd_file.log,'Error: Service Request Creation failed');
1401: Fnd_file.put_line(fnd_file.log,'Party id :'||c_create_sr_rec.party_id);
1402:
1403: csd_bulk_receive_util.write_to_conc_log
1404: ( p_msg_count => l_msg_count,
1405: p_msg_data => l_msg_data);
1406:
1407: End if;

Line 1429: csd_bulk_receive_util.create_blkrcv_ro

1425: 'New SR - Call Create Repair Order');
1426: End if;
1427:
1428: -- Call Create RO Helper procedure
1429: csd_bulk_receive_util.create_blkrcv_ro
1430: (
1431: p_bulk_receive_id => c_create_ro_rec.bulk_receive_id,
1432: x_repair_line_id => l_repair_line_id,
1433: x_repair_number => l_repair_number,

Line 1474: csd_bulk_receive_util.create_blkrcv_default_prod_txn

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
1475: (
1476: p_bulk_receive_id => c_create_ro_rec.bulk_receive_id,
1477: x_return_status => l_return_status,
1478: x_msg_count => l_msg_count,

Line 1500: csd_bulk_receive_util.write_to_conc_log

1496: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1497: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1498: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1499:
1500: csd_bulk_receive_util.write_to_conc_log
1501: ( p_msg_count => l_msg_count,
1502: p_msg_data => l_msg_data);
1503:
1504: End if;

Line 1546: csd_bulk_receive_util.write_to_conc_log

1542: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1543: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1544: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1545:
1546: csd_bulk_receive_util.write_to_conc_log
1547: ( p_msg_count => l_msg_count,
1548: p_msg_data => l_msg_data);
1549:
1550: -- 12.1.2 BR ER FP changes subhat

Line 1687: csd_bulk_receive_util.bulk_auto_receive

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
1688: ( p_bulk_autorcv_tbl => l_bulk_autorcv_tbl,
1689: x_return_status => l_return_status,
1690: x_msg_count => l_msg_count,
1691: x_msg_data => l_msg_data

Line 1706: csd_bulk_receive_util.write_to_conc_output

1702: -- bug#8968918, subhat.
1703: -- when this is commented out, if the repair order was created in draft status, the output
1704: -- is not written. Uncommenting the earlier commented code.
1705: if fnd_conc_global.request_data is null then
1706: csd_bulk_receive_util.write_to_conc_output
1707: ( p_transaction_number => p_transaction_number);
1708: end if;
1709: retcode := c_success;
1710: