DBA Data[Home] [Help]

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.24.12010000.3 2008/12/22 21:37:30 swai ship $ */
3: /*-----------------------------------------------------------------*/
4: /* procedure name: validate_bulk_receive_rec */
5: /* description : Validate Bulk Receive record definition */

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

57: BEGIN
58:
59: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
60: fnd_log.STRING (fnd_log.level_procedure,
61: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC.BEGIN',
62: 'Enter - Validate bulk receive rec');
63: End if;
64: --
65: -- Initialize the flags

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

196: End if;
197:
198: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
199: fnd_log.STRING (fnd_log.level_statement,
200: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC',
201: 'Warning Flag - '||x_warning_flag||
202: ',Warning Reason Code - '||x_warning_reason_code||
203: ',Internal SR Flag - '||x_internal_sr_flag||
204: ',Change Owner Flag - '||x_change_owner_flag);

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

205: End if;
206:
207: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
208: fnd_log.STRING (fnd_log.level_procedure,
209: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.VALIDATE_BULK_RECEIVE_REC.END',
210: 'Exit - Validate bulk receive rec');
211: End if;
212:
213: END validate_bulk_receive_rec;

Line 224: p_bulk_receive_rec IN csd_bulk_receive_util.bulk_receive_rec,

220: /*-----------------------------------------------------------------*/
221:
222: PROCEDURE create_blkrcv_sr
223: (
224: p_bulk_receive_rec IN csd_bulk_receive_util.bulk_receive_rec,
225: p_sr_notes_tbl IN cs_servicerequest_pub.notes_table,
226: x_incident_id OUT NOCOPY NUMBER,
227: x_incident_number OUT NOCOPY VARCHAR2,
228: x_return_status OUT NOCOPY VARCHAR2,

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

272: savepoint create_blkrcv_sr;
273:
274: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
275: fnd_log.STRING (fnd_log.level_procedure,
276: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_SR.BEGIN',
277: 'Enter - Create Blkrcv SR');
278: End if;
279:
280: -- Derive the party type

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

360: End If;
361:
362: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
363: fnd_log.STRING (fnd_log.level_procedure,
364: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_SR.END',
365: 'Exit - Create Blkrcv SR');
366: End if;
367:
368: EXCEPTION

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

522: savepoint create_blkrcv_ro;
523:
524: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
525: fnd_log.STRING (fnd_log.level_procedure,
526: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO.BEGIN',
527: 'Enter - Create Blkrcv RO');
528: End if;
529:
530: Open c_create_blkrcv_ro (p_bulk_receive_id);

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

554: Close c_get_item_revision;
555:
556: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
557: fnd_log.STRING (fnd_log.level_statement,
558: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
559: 'Derived Revision - '||l_revision||
560: 'for Item id - '||l_blkrcv_rec.inventory_item_id);
561: End if;
562:

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

578: Close c_get_ib_info;
579:
580: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
581: fnd_log.STRING (fnd_log.level_statement,
582: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
583: 'Derived Instance Id - '||l_instance_id||
584: 'for Item id - '||l_blkrcv_rec.inventory_item_id||
585: ',Serial number - '||l_blkrcv_rec.serial_number);
586: End if;

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

600: Close c_get_item_uom_code;
601:
602: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
603: fnd_log.STRING (fnd_log.level_statement,
604: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
605: 'Derived Uom code - '||l_uom_code||
606: 'for Item id - '||l_blkrcv_rec.inventory_item_id);
607: End if;
608:

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

633: l_instance_rec.mfg_serial_number_flag := 'N';
634:
635: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
636: fnd_log.STRING (fnd_log.level_event,
637: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
638: 'Calling create item instance api');
639: End if;
640:
641:

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

804: l_repln_rec.repair_mode := l_repair_mode;
805:
806: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
807: fnd_log.STRING (fnd_log.level_event,
808: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO',
809: 'Calling create repair order api');
810: End if;
811:
812:

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

830: End If;
831:
832: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
833: fnd_log.STRING (fnd_log.level_procedure,
834: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_RO.END',
835: 'Exit - Create Blkrcv RO');
836: End if;
837:
838: EXCEPTION

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

897: savepoint create_blkrcv_default_prod_txn;
898:
899: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
900: fnd_log.STRING (fnd_log.level_procedure,
901: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_DEFAULT_PROD_TXN.BEGIN',
902: 'Enter - Create Blkrcv Default Prod Txn');
903: End if;
904:
905: Open c_create_blkrcv_prod_txn(p_bulk_receive_id );

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

922: End If;
923:
924: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
925: fnd_log.STRING (fnd_log.level_procedure,
926: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CREATE_BULKRCV_DEFAULT_PROD_TXN.END',
927: 'Exit - Create Blkrcv Default Prod Txn');
928: End if;
929:
930: EXCEPTION

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

1031: savepoint change_blkrcv_ib_owner;
1032:
1033: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1034: fnd_log.STRING (fnd_log.level_procedure,
1035: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CHANGE_BULKRCV_IB_OWNER.BEGIN',
1036: 'Enter - Change Blkrcv IB Owner');
1037: End if;
1038:
1039: Open c_bulk_receive_items(p_bulk_receive_id);

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

1127: End If;
1128:
1129: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1130: fnd_log.STRING (fnd_log.level_procedure,
1131: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.CHANGE_BULKRCV_IB_OWNER.END',
1132: 'Exit - Change Blkrcv IB Owner');
1133: End if;
1134:
1135: EXCEPTION

Line 1173: p_bulk_autorcv_tbl IN OUT NOCOPY csd_bulk_receive_util.bulk_autorcv_tbl,

1169: /* */
1170: /*-----------------------------------------------------------------*/
1171: PROCEDURE bulk_auto_receive
1172: (
1173: p_bulk_autorcv_tbl IN OUT NOCOPY csd_bulk_receive_util.bulk_autorcv_tbl,
1174: x_return_status OUT NOCOPY VARCHAR2,
1175: x_msg_count OUT NOCOPY NUMBER,
1176: x_msg_data OUT NOCOPY VARCHAR2
1177: )

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

1247: Savepoint bulk_auto_receive;
1248:
1249: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1250: fnd_log.STRING (fnd_log.level_procedure,
1251: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.BEGIN',
1252: 'Enter - Bulk auto receive');
1253: End if;
1254:
1255: i := 0;

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

1306:
1307: -- Call the Receive API
1308: If (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
1309: fnd_log.STRING (fnd_log.level_event,
1310: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.BEGIN',
1311: 'Call receive item api');
1312: End if;
1313:
1314: If(l_rcv_rec_tbl.count > 0 ) then

Line 1332: csd_bulk_receive_util.write_to_conc_log

1328: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then -- Status check If statement
1329:
1330: -- Verify if there are any errors in header
1331:
1332: csd_bulk_receive_util.write_to_conc_log
1333: ( p_msg_count => l_msg_count,
1334: p_msg_data => l_msg_data);
1335:
1336:

Line 1453: csd_bulk_receive_util.write_to_conc_log

1449: -- fix for bug 5227347
1450: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1451:
1452: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
1453: csd_bulk_receive_util.write_to_conc_log
1454: ( p_msg_count => l_msg_count,
1455: p_msg_data => l_msg_data);
1456:
1457: Else

Line 1521: csd_bulk_receive_util.write_to_conc_log

1517: -- fix for bug 5227347
1518: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1519:
1520: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
1521: csd_bulk_receive_util.write_to_conc_log
1522: ( p_msg_count => l_msg_count,
1523: p_msg_data => l_msg_data);
1524:
1525: Else

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

1546: End if; -- End if of the l_rcv_rec_tbl.count > 0
1547:
1548: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1549: fnd_log.STRING (fnd_log.level_procedure,
1550: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.BULK_AUTO_RECEIVE.END',
1551: 'Exit - Bulk auto receive');
1552: End if;
1553:
1554: EXCEPTION

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

1600: BEGIN
1601:
1602: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1603: fnd_log.STRING (fnd_log.level_procedure,
1604: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_LOG.BEGIN',
1605: 'Enter - Write to conc log');
1606: End if;
1607:
1608: If p_msg_count is not null then

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

1628: End If;
1629:
1630: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1631: fnd_log.STRING (fnd_log.level_procedure,
1632: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_LOG.END',
1633: 'Exit - Write to conc log');
1634: End if;
1635:
1636: END;

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

1689: BEGIN
1690:
1691: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1692: fnd_log.STRING (fnd_log.level_procedure,
1693: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_OUTPUT.BEGIN',
1694: 'Enter - Write to conc output');
1695: End if;
1696:
1697: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');

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

1785: End Loop;
1786:
1787: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1788: fnd_log.STRING (fnd_log.level_procedure,
1789: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.WRITE_TO_CONC_OUTPUT.END',
1790: 'Exit - Write to conc output');
1791: End if;
1792:
1793: END;

Line 1931: END CSD_BULK_RECEIVE_UTIL;

1927: return l_rma_subinv;
1928:
1929: END get_bulk_rcv_def_sub_inv;
1930:
1931: END CSD_BULK_RECEIVE_UTIL;