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_UTIL dependencies on CSD_BULK_RECEIVE_UTIL

Line 1: PACKAGE BODY CSD_BULK_RECEIVE_UTIL AS

1: PACKAGE BODY CSD_BULK_RECEIVE_UTIL AS
2: /* $Header: csdubrub.pls 120.30.12020000.5 2013/04/10 00:31:26 takwong ship $ */
3:
4: -- private procedure declarations.
5: /*-----------------------------------------------------------------------*/

Line 44: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

40: -- entered
41: savepoint after_under_receipt_prcs;
42: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
43: fnd_log.STRING (fnd_log.level_procedure,
44: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
45: 'Under-receipt: Entered the routine');
46: End if;
47: -- get the charges default values for the line to be updated/created.
48: -- fetch all the details required in a single sql.

Line 102: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

98: l_Charge_Details_rec_upd.quantity_required := p_received_qty;
99:
100: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
101: fnd_log.STRING (fnd_log.level_procedure,
102: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
103: 'Under-receipt: before updating order header_id');
104: End if;
105: -- need to fake as if the charges line is not submitted to OM.
106: update cs_estimate_details

Line 121: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

117: l_Charge_Details_rec_upd.inventory_item_id_in := l_Charge_Details_rec.inventory_item_id_in;
118:
119: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
120: fnd_log.STRING (fnd_log.level_procedure,
121: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
122: 'Under-receipt: Calling update charges API to update the quantity');
123: End if;
124: savepoint update_charge;
125: -- call charges API.

Line 145: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

141:
142: if x_return_status <> 'S' THEN
143: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
144: fnd_log.STRING (fnd_log.level_procedure,
145: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
146: 'Under-receipt: Return Status '||x_return_status||' Message '||x_msg_data);
147: End if;
148: raise l_update_charge_err;
149: end if;

Line 188: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

184: l_Charge_Details_rec.original_source_id := p_repair_line_id;
185:
186: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
187: fnd_log.STRING (fnd_log.level_procedure,
188: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
189: 'Under-receipt: before calling create charge details');
190: End if;
191: -- call the create charges API
192: savepoint create_charge;

Line 211: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

207:
208: if x_return_status <> fnd_api.g_ret_sts_success then
209: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
210: fnd_log.STRING (fnd_log.level_procedure,
211: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
212: 'Under-receipt: Error in creating charge lines: '|| x_msg_data);
213: End if;
214: raise l_create_charge_err;
215: end if;

Line 329: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

325:
326: l_prod_txns_rec.estimate_detail_id := x_estimate_detail_id;
327: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
328: fnd_log.STRING (fnd_log.level_procedure,
329: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
330: 'Under-receipt: before calling insert: product txn id :'||l_prod_txns_rec.product_transaction_id);
331: End if;
332: -- insert the values into csd_product_transactions.
333: INSERT INTO CSD_PRODUCT_TRANSACTIONS(

Line 447: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

443: p_encoded => 'F',
444: p_data => x_msg_data,
445: p_msg_index_out => x_msg_index_out);
446: fnd_log.STRING (fnd_log.level_procedure,
447: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
448: 'Under-receipt: Return Status '||x_msg_count||' Message '||x_msg_data);
449: END LOOP;
450: End if;
451: rollback to update_charge;

Line 465: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

461: p_encoded => 'F',
462: p_data => x_msg_data,
463: p_msg_index_out => x_msg_index_out);
464: fnd_log.STRING (fnd_log.level_procedure,
465: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
466: 'Under-receipt: create charge err '||x_msg_count||' Message '||x_msg_data);
467: END LOOP;
468: End if;
469: rollback to create_charge;

Line 473: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',

469: rollback to create_charge;
470: WHEN OTHERS THEN
471: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
472: fnd_log.STRING (fnd_log.level_procedure,
473: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
474: 'Under-receipt: WHEN OTHERS : Message '||SQLERRM);
475: End if;
476: raise;
477:

Line 546: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC.BEGIN',

542: BEGIN
543:
544: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
545: fnd_log.STRING (fnd_log.level_procedure,
546: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC.BEGIN',
547: 'Enter - Validate bulk receive rec');
548: End if;
549: --
550: -- Initialize the flags

Line 723: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC',

719: End if;
720:
721: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
722: fnd_log.STRING (fnd_log.level_statement,
723: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC',
724: 'Warning Flag - '||x_warning_flag||
725: ',Warning Reason Code - '||x_warning_reason_code||
726: ',Internal SR Flag - '||x_internal_sr_flag||
727: ',Change Owner Flag - '||x_change_owner_flag);

Line 732: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC.END',

728: End if;
729:
730: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
731: fnd_log.STRING (fnd_log.level_procedure,
732: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC.END',
733: 'Exit - Validate bulk receive rec');
734: End if;
735:
736: END validate_bulk_receive_rec;

Line 747: p_bulk_receive_rec IN csd_bulk_receive_util.bulk_receive_rec,

743: /*-----------------------------------------------------------------*/
744:
745: PROCEDURE create_blkrcv_sr
746: (
747: p_bulk_receive_rec IN csd_bulk_receive_util.bulk_receive_rec,
748: p_sr_notes_tbl IN cs_servicerequest_pub.notes_table,
749: x_incident_id OUT NOCOPY NUMBER,
750: x_incident_number OUT NOCOPY VARCHAR2,
751: x_return_status OUT NOCOPY VARCHAR2,

Line 799: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_SR.BEGIN',

795: savepoint create_blkrcv_sr;
796:
797: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
798: fnd_log.STRING (fnd_log.level_procedure,
799: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_SR.BEGIN',
800: 'Enter - Create Blkrcv SR');
801: End if;
802:
803: -- Derive the party type

Line 887: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_SR.END',

883: End If;
884:
885: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
886: fnd_log.STRING (fnd_log.level_procedure,
887: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_SR.END',
888: 'Exit - Create Blkrcv SR');
889: End if;
890:
891: EXCEPTION

Line 1052: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO.BEGIN',

1048: savepoint create_blkrcv_ro;
1049:
1050: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1051: fnd_log.STRING (fnd_log.level_procedure,
1052: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO.BEGIN',
1053: 'Enter - Create Blkrcv RO');
1054: End if;
1055:
1056: Open c_create_blkrcv_ro (p_bulk_receive_id);

Line 1096: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',

1092: Close c_get_item_revision;
1093:
1094: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1095: fnd_log.STRING (fnd_log.level_statement,
1096: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
1097: 'Derived Revision - '||l_revision||
1098: 'for Item id - '||l_blkrcv_rec.inventory_item_id);
1099: End if;
1100: end if;

Line 1120: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',

1116: Close c_get_ib_info;
1117:
1118: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1119: fnd_log.STRING (fnd_log.level_statement,
1120: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
1121: 'Derived Instance Id - '||l_instance_id||
1122: 'for Item id - '||l_blkrcv_rec.inventory_item_id||
1123: ',Serial number - '||l_blkrcv_rec.serial_number);
1124: End if;

Line 1142: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',

1138: Close c_get_item_uom_code;
1139:
1140: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1141: fnd_log.STRING (fnd_log.level_statement,
1142: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
1143: 'Derived Uom code - '||l_uom_code||
1144: 'for Item id - '||l_blkrcv_rec.inventory_item_id);
1145: End if;
1146:

Line 1180: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',

1176: -- end Bulk Rcv enhancement changes, subhat.
1177:
1178: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1179: fnd_log.STRING (fnd_log.level_event,
1180: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
1181: 'Calling create item instance api');
1182: End if;
1183:
1184:

Line 1358: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',

1354: l_repln_rec.repair_mode := l_repair_mode;
1355:
1356: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1357: fnd_log.STRING (fnd_log.level_event,
1358: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
1359: 'Calling create repair order api');
1360: End if;
1361:
1362:

Line 1384: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO.END',

1380: End If;
1381:
1382: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1383: fnd_log.STRING (fnd_log.level_procedure,
1384: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO.END',
1385: 'Exit - Create Blkrcv RO');
1386: End if;
1387:
1388: EXCEPTION

Line 1451: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_DEFAULT_PROD_TXN.BEGIN',

1447: savepoint create_blkrcv_default_prod_txn;
1448:
1449: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1450: fnd_log.STRING (fnd_log.level_procedure,
1451: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_DEFAULT_PROD_TXN.BEGIN',
1452: 'Enter - Create Blkrcv Default Prod Txn');
1453: End if;
1454:
1455: Open c_create_blkrcv_prod_txn(p_bulk_receive_id );

Line 1476: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_DEFAULT_PROD_TXN.END',

1472: End If;
1473:
1474: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1475: fnd_log.STRING (fnd_log.level_procedure,
1476: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_DEFAULT_PROD_TXN.END',
1477: 'Exit - Create Blkrcv Default Prod Txn');
1478: End if;
1479:
1480: EXCEPTION

Line 1601: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CHANGE_BULKRCV_IB_OWNER.BEGIN',

1597: savepoint change_blkrcv_ib_owner;
1598:
1599: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1600: fnd_log.STRING (fnd_log.level_procedure,
1601: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CHANGE_BULKRCV_IB_OWNER.BEGIN',
1602: 'Enter - Change Blkrcv IB Owner');
1603: End if;
1604:
1605: Open c_bulk_receive_items(p_bulk_receive_id);

Line 1710: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CHANGE_BULKRCV_IB_OWNER.END',

1706: End If;
1707:
1708: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1709: fnd_log.STRING (fnd_log.level_procedure,
1710: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CHANGE_BULKRCV_IB_OWNER.END',
1711: 'Exit - Change Blkrcv IB Owner');
1712: End if;
1713:
1714: EXCEPTION

Line 1752: p_bulk_autorcv_tbl IN OUT NOCOPY csd_bulk_receive_util.bulk_autorcv_tbl,

1748: /* */
1749: /*-----------------------------------------------------------------*/
1750: PROCEDURE bulk_auto_receive
1751: (
1752: p_bulk_autorcv_tbl IN OUT NOCOPY csd_bulk_receive_util.bulk_autorcv_tbl,
1753: x_return_status OUT NOCOPY VARCHAR2,
1754: x_msg_count OUT NOCOPY NUMBER,
1755: x_msg_data OUT NOCOPY VARCHAR2
1756: )

Line 1843: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.BEGIN',

1839: Savepoint bulk_auto_receive;
1840:
1841: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1842: fnd_log.STRING (fnd_log.level_procedure,
1843: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.BEGIN',
1844: 'Enter - Bulk auto receive');
1845: End if;
1846:
1847: i := 0;

Line 1935: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.BEGIN',

1931:
1932: -- Call the Receive API
1933: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1934: fnd_log.STRING (fnd_log.level_event,
1935: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.BEGIN',
1936: 'Call receive item api');
1937: End if;
1938:
1939: If(l_rcv_rec_tbl.count > 0 ) then

Line 1965: csd_bulk_receive_util.write_to_conc_log

1961: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then -- Status check If statement
1962:
1963: -- Verify if there are any errors in header
1964:
1965: csd_bulk_receive_util.write_to_conc_log
1966: ( p_msg_count => l_msg_count,
1967: p_msg_data => l_msg_data);
1968:
1969:

Line 2094: csd_bulk_receive_util.write_to_conc_log

2090: -- fix for bug 5227347
2091: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
2092:
2093: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
2094: csd_bulk_receive_util.write_to_conc_log
2095: ( p_msg_count => l_msg_count,
2096: p_msg_data => l_msg_data);
2097:
2098: Else

Line 2171: csd_bulk_receive_util.write_to_conc_log

2167: -- fix for bug 5227347
2168: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
2169:
2170: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
2171: csd_bulk_receive_util.write_to_conc_log
2172: ( p_msg_count => l_msg_count,
2173: p_msg_data => l_msg_data);
2174:
2175: Else

Line 2200: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.END',

2196: End if; -- End if of the l_rcv_rec_tbl.count > 0
2197:
2198: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2199: fnd_log.STRING (fnd_log.level_procedure,
2200: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.END',
2201: 'Exit - Bulk auto receive');
2202: End if;
2203:
2204: EXCEPTION

Line 2254: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_LOG.BEGIN',

2250: BEGIN
2251:
2252: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2253: fnd_log.STRING (fnd_log.level_procedure,
2254: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_LOG.BEGIN',
2255: 'Enter - Write to conc log');
2256: End if;
2257:
2258: If p_msg_count is not null then

Line 2282: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_LOG.END',

2278: End If;
2279:
2280: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2281: fnd_log.STRING (fnd_log.level_procedure,
2282: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_LOG.END',
2283: 'Exit - Write to conc log');
2284: End if;
2285:
2286: END;

Line 2343: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_OUTPUT.BEGIN',

2339: BEGIN
2340:
2341: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2342: fnd_log.STRING (fnd_log.level_procedure,
2343: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_OUTPUT.BEGIN',
2344: 'Enter - Write to conc output');
2345: End if;
2346:
2347: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');

Line 2462: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_OUTPUT.END',

2458: End Loop;
2459:
2460: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
2461: fnd_log.STRING (fnd_log.level_procedure,
2462: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_OUTPUT.END',
2463: 'Exit - Write to conc output');
2464: End if;
2465:
2466: END;

Line 2656: lc_api_name varchar2(200) := 'csd.plsql.csd_bulk_receive_util.get_sr_ro_rma_details';

2652: ' status := ''O'' ' ;
2653: l_sql_string_tmp varchar2(2000);
2654: l_repair_line_ids_in varchar2(2000);
2655:
2656: lc_api_name varchar2(200) := 'csd.plsql.csd_bulk_receive_util.get_sr_ro_rma_details';
2657:
2658: l_in_progress_ro JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2659:
2660: l_check_loaner_sn varchar2(3) := 'N';

Line 3444: csd_bulk_receive_util.matching_rma_found(

3440:
3441: if x_sr_ro_rma_tbl(j).incident_id is not null and x_sr_ro_rma_tbl(j).repair_line_id is not null
3442: then
3443: -- call the procedure to find the matching RMA.
3444: csd_bulk_receive_util.matching_rma_found(
3445: p_repair_line_id => x_sr_ro_rma_tbl(j).repair_line_id,
3446: p_blk_rec_qty => x_sr_ro_rma_tbl(j).quantity,
3447: p_blk_rec_serial_number => x_sr_ro_rma_tbl(j).serial_number,
3448: p_blk_rec_instance_id => x_sr_ro_rma_tbl(j).instance_id,

Line 3553: l_bulk_autorcv_tbl csd_bulk_receive_util.BULK_AUTORCV_TBL;

3549:
3550: l_rcv_error_msg_tbl csd_receive_util.rcv_error_msg_tbl;
3551: l_header_error boolean;
3552:
3553: l_bulk_autorcv_tbl csd_bulk_receive_util.BULK_AUTORCV_TBL;
3554:
3555: l_msg_count number;
3556: l_msg_data varchar2(2000);
3557: l_return_status varchar2(3);

Line 3561: lc_api_name CONSTANT varchar2(100) := 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.after_receipt';

3557: l_return_status varchar2(3);
3558: l_errored boolean;
3559: l_prod_txn_status varchar2(30);
3560:
3561: lc_api_name CONSTANT varchar2(100) := 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.after_receipt';
3562:
3563: begin
3564:
3565: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 3760: csd_bulk_receive_util.write_to_conc_log

3756: 'Error in CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE: Return status '||l_return_status);
3757: End if;
3758:
3759: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
3760: csd_bulk_receive_util.write_to_conc_log
3761: ( p_msg_count => l_msg_count,
3762: p_msg_data => l_msg_data);
3763:
3764: Else

Line 3822: csd_bulk_receive_util.write_to_conc_log

3818: 'Error in CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE: Return status '||l_return_status);
3819: End if;
3820:
3821: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
3822: csd_bulk_receive_util.write_to_conc_log
3823: ( p_msg_count => l_msg_count,
3824: p_msg_data => l_msg_data);
3825:
3826: Else

Line 3885: lc_api_name varchar2(60) := 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.PRE_PROCESS_RMA';

3881:
3882: l_rma_status varchar2(30);
3883: l_book_order_flag varchar2(3) := 'N';
3884: l_prod_txn_rec csd_process_pvt.product_txn_rec;
3885: lc_api_name varchar2(60) := 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.PRE_PROCESS_RMA';
3886: l_order_header_id number := px_order_header_id;
3887: l_order_line_id number := px_order_line_id;
3888: l_check_loaner varchar2(2) := 'N';
3889:

Line 4171: lc_api_name varchar2(100) := 'CSD_BULK_RECEIVE_UTIL.create_new_ship_line';

4167: )
4168: IS
4169:
4170: l_prod_txn_rec CSD_PROCESS_PVT.PRODUCT_TXN_REC;
4171: lc_api_name varchar2(100) := 'CSD_BULK_RECEIVE_UTIL.create_new_ship_line';
4172:
4173: BEGIN
4174: savepoint create_new_ship_line;
4175: -- get the default values from the existing SHIP line

Line 4327: END CSD_BULK_RECEIVE_UTIL;

4323: end loop;
4324: return l_return_type;
4325: END get_num_in_list;
4326:
4327: END CSD_BULK_RECEIVE_UTIL;