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.CSI_INV_TXN_HOOK_PKG dependencies on CSI_INV_TRXS_PKG

Line 106: l_csi_txn_name := csi_inv_trxs_pkg.get_inv_name(p_transaction_id);

102:
103: BEGIN
104:
105: -- Get CSI Txn Name for Error
106: l_csi_txn_name := csi_inv_trxs_pkg.get_inv_name(p_transaction_id);
107:
108: -- Initialize to Success so Oracle Inventory processing will not error
109: x_return_status := l_fnd_success;
110:

Line 287: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISSUE_TO_HZ_LOC'),'INV');

283: r_type_class.location_required_flag = 'Y' AND
284: (r_type_class.type_class is null OR r_type_class.type_class <> 1)) THEN
285:
286: l_type_id := 132;
287: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISSUE_TO_HZ_LOC'),'INV');
288: l_source_type := 'CSIISUHZ';
289:
290: IF (l_bypass = 'N') THEN
291:

Line 335: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_RECEIPT_HZ_LOC'),'INV');

331: (r_type_class.type_class is null OR r_type_class.type_class <> 1)) THEN
332:
333:
334: l_type_id := 134;
335: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_RECEIPT_HZ_LOC'),'INV');
336: l_source_type := 'CSIMSRHZ';
337: IF (l_bypass = 'N') THEN
338: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
339: -- Misc Receipt from HZ Location

Line 380: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_ISSUE_HZ_LOC'),'INV');

376: r_type_class.location_required_flag = 'Y' AND
377: (r_type_class.type_class is null OR r_type_class.type_class <> 1))THEN
378:
379: l_type_id := 133;
380: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_ISSUE_HZ_LOC'),'INV');
381: l_source_type := 'CSIMSIHZ';
382: IF (l_bypass = 'N') THEN
383: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
384: -- Misc Receipt from HZ Location

Line 428: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'OM_SHIPMENT'),'ONT');

424: ----------------------- ------------- ------------
425: --1. Logical Sales Order Issue 7 30
426:
427: l_type_id := 51;
428: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'OM_SHIPMENT'),'ONT');
429: l_source_type := 'CSILOSHP';
430: IF (l_bypass = 'N') THEN
431: debug(' publishing '||l_source_type||' for transaction_id : '||l_log_trx_id);
432: debug('Transaction ID used to get data 2,7: '||p_transaction_id);

Line 474: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MOVE_ORDER_ISSUE_TO_PROJECT'),'INV');

470: r_mtl_data.transaction_source_type_id = 4 AND
471: r_type_class.type_class = 1) -- Issue to Project
472: THEN
473: l_type_id := 113;
474: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MOVE_ORDER_ISSUE_TO_PROJECT'),'INV');
475: l_source_type := 'CSIISUPT';
476: IF (l_bypass = 'N') THEN
477: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
478: -- Issue to Project Move Order

Line 519: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_ISSUE_TO_PROJECT'),'INV');

515: r_mtl_data.transaction_source_type_id in (3,6,13) AND
516: r_type_class.type_class = 1)
517: THEN
518: l_type_id := 121;
519: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_ISSUE_TO_PROJECT'),'INV');
520: l_source_type := 'CSIMSIPT';
521: IF (l_bypass = 'N') THEN
522: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
523: -- Miscellaneous Issue to Project

Line 564: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_RECEIPT_FROM_PROJECT'),'INV');

560: r_type_class.type_class = 1) -- Misc Receipt from Project
561: -- Acct/Acct Alias, Inv
562: THEN
563: l_type_id := 120;
564: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_RECEIPT_FROM_PROJECT'),'INV');
565: l_source_type := 'CSIMSRPT';
566: IF (l_bypass = 'N') THEN
567: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
568: -- Miscellaneous Receipt from Project/Task

Line 613: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'PROJECT_CONTRACT_SHIPMENT'),'OKE');

609: ----------------------- ------------- ------------
610: --1. Project Contract Issue 1 77
611:
612: l_type_id := 326;
613: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'PROJECT_CONTRACT_SHIPMENT'),'OKE');
614: l_source_type := 'CSIOKSHP';
615: IF (l_bypass = 'N') THEN
616: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
617: -- Project Contract Issues

Line 662: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'OM_SHIPMENT'),'ONT');

658: ----------------------- ------------- ------------
659: --1. Sales Order Issue 1 33
660:
661: l_type_id := 51;
662: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'OM_SHIPMENT'),'ONT');
663: l_source_type := 'CSISOSHP';
664: IF (l_bypass = 'N') THEN
665: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
666: -- Sales Order Shipments

Line 710: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_ISSUE'),'ONT');

706: ----------------------- ------------- ------------
707: --1. Intrnl Ord Issue(Ship Conf) 1 34
708:
709: l_type_id := 126;
710: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_ISSUE'),'ONT');
711: l_source_type := 'CSIINTIS';
712: IF (l_bypass = 'N') THEN
713: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
714: -- Internal Order Issue

Line 759: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'RMA_SHIPMENT'),'ONT');

755: ----------------------- ------------- ------------
756: --1. RMA Receipt 27 15
757:
758: l_type_id := 53;
759: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'RMA_SHIPMENT'),'ONT');
760: l_source_type := 'CSIRMARC';
761: IF (l_bypass = 'N') THEN
762: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
763: -- Return Material Authorization

Line 826: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'SUBINVENTORY_TRANSFER'),'INV');

822: --10. Project Transfer 2 67
823: --11. Project Payback 2 68
824:
825: l_type_id := 114;
826: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'SUBINVENTORY_TRANSFER'),'INV');
827: l_source_type := 'CSISUBTR';
828: IF (l_bypass = 'N') THEN
829: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
830: -- Subinventory Transfer and Sales Order Stanging

Line 876: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'INTERORG_TRANS_RECEIPT'),'INV');

872: ----------------------- ------------- ------------
873: --1. InTransit Receipt 12 12
874:
875: l_type_id := 144;
876: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'INTERORG_TRANS_RECEIPT'),'INV');
877: l_source_type := 'CSIORGTR';
878: IF (l_bypass = 'N') THEN
879: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
880: -- InterOrg In Transit Receipt Transaction

Line 926: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'INTERORG_TRANS_SHIPMENT'),'INV');

922: ----------------------- ------------- ------------
923: --1. InTransit Shipment 21 21
924:
925: l_type_id := 145;
926: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'INTERORG_TRANS_SHIPMENT'),'INV');
927: l_source_type := 'CSIORGTS';
928: IF (l_bypass = 'N') THEN
929: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
930: -- InterOrg In Transit Receipt Transaction

Line 976: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'INTERORG_DIRECT_SHIP'),'INV');

972: ----------------------- ------------- ------------
973: --1. Direct Org Transfer 3 3
974:
975: l_type_id := 143;
976: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'INTERORG_DIRECT_SHIP'),'INV');
977: l_source_type := 'CSIORGDS';
978: IF (l_bypass = 'N') THEN
979: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
980: -- InterOrg Direct Shipment Transaction

Line 1024: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_REQUISITION_RECEIPT'),'INV');

1020: ----------------------- ------------- ------------
1021: --1. Int Req Intr Rcpt 12 61
1022:
1023: l_type_id := 131;
1024: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_REQUISITION_RECEIPT'),'INV');
1025: l_source_type := 'CSIINTSR';
1026: IF (l_bypass = 'N') THEN
1027: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1028: -- Internal Sales Order Receipt Transaction

Line 1073: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_SHIPMENT'),'INV');

1069: ----------------------- ------------- ------------
1070: --1. Int Order Intr Ship 21 62
1071:
1072: l_type_id := 130;
1073: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_SHIPMENT'),'INV');
1074: l_source_type := 'CSIINTSS';
1075: IF (l_bypass = 'N') THEN
1076: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1077: -- Internal Sales Order Shipment Transaction

Line 1123: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_DIRECT_SHIP'),'INV');

1119: ----------------------- ------------- ------------
1120: --1. Int Order Direct Ship 3 54
1121:
1122: l_type_id := 142;
1123: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'ISO_DIRECT_SHIP'),'INV');
1124: l_source_type := 'CSIINTDS';
1125: IF (l_bypass = 'N') THEN
1126: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1127: -- Internal Sales Order Direct Shipment Transaction

Line 1173: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'PO_RECEIPT_INTO_INVENTORY'),'INV');

1169: --1. PO Receipt 27 18
1170:
1171: THEN
1172: l_type_id := 112;
1173: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'PO_RECEIPT_INTO_INVENTORY'),'INV');
1174: l_source_type := 'CSIPOINV';
1175: IF (l_bypass = 'N') THEN
1176: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1177: -- PO Receipt into Inventory

Line 1221: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'CYCLE_COUNT'),'INV');

1217: --1. Cycle Count Adjust (-/+) 4 4
1218:
1219: THEN
1220: l_type_id := 119;
1221: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'CYCLE_COUNT'),'INV');
1222: l_source_type := 'CSICYCNT';
1223: IF (l_bypass = 'N') THEN
1224: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1225: -- Cycle Count

Line 1269: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'PHYSICAL_INVENTORY'),'INV');

1265: --1. Physical Inv Adjust(-/+) 8 8
1266:
1267: THEN
1268: l_type_id := 118;
1269: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'PHYSICAL_INVENTORY'),'INV');
1270: l_source_type := 'CSIPHYIN';
1271: IF (l_bypass = 'N') THEN
1272: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1273: -- Physical Inventory

Line 1334: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_RECEIPT'),'INV');

1330: --5. + Int Req Adjust 29 72
1331: --6. + Shipment Rcpt Adjust 29 70
1332:
1333: l_type_id := 117;
1334: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_RECEIPT'),'INV');
1335: l_source_type := 'CSIMSRCV';
1336: IF (l_bypass = 'N') THEN
1337: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1338: -- Miscellaneous Receipt

Line 1411: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_ISSUE'),'INV');

1407: -- 122 Issue to (User Defined Seeded)
1408:
1409:
1410: l_type_id := 116;
1411: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'MISC_ISSUE'),'INV');
1412: l_source_type := 'CSIMSISU';
1413: IF (l_bypass = 'N') THEN
1414: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1415: -- Miscellaneous Issue

Line 1467: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_BYPRODUCT_RETURN'),'INV');

1463:
1464:
1465: IF l_wip_entity_type =10 AND r_mtl_data.transaction_type_id =1003 THEN
1466: l_type_id := 76; --new transaction type to support WIP_ByProduct Return
1467: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_BYPRODUCT_RETURN'),'INV');
1468: l_source_type := 'CSIWIPBR';
1469:
1470: IF (l_bypass = 'N') THEN
1471: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1558: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_ISSUE'),'INV');

1554: ----------------------- ------------- ------------
1555: --1. WIP Component Issue 1 35
1556:
1557: l_type_id := 71;
1558: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_ISSUE'),'INV');
1559: l_source_type := 'CSIWIPCI';
1560: IF (l_bypass = 'N') THEN
1561: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1562: -- WIP Component Issue

Line 1607: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_RECEIPT'),'INV');

1603: ----------------------- ------------- ------------
1604: --1. WIP Neg Comp Issue 33 38
1605:
1606: l_type_id := 72;
1607: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_RECEIPT'),'INV');
1608: l_source_type := 'CSIWIPNI';
1609: IF (l_bypass = 'N') THEN
1610: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1611: -- WIP Negative Component Issue

Line 1656: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_RECEIPT'),'INV');

1652: ----------------------- ------------- ------------
1653: --1. WIP Component Return 27 43
1654:
1655: l_type_id := 72;
1656: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_RECEIPT'),'INV');
1657: l_source_type := 'CSIWIPCR';
1658: IF (l_bypass = 'N') THEN
1659: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1660: -- WIP Component Return

Line 1711: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name, 'WIP_BYPRODUCT_COMPLETION '),'INV');

1707:
1708: IF l_wip_entity_type =10 AND r_mtl_data.transaction_type_id =1002 THEN
1709:
1710: l_type_id := 75; --new transaction type to support WIP By Product Completion
1711: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name, 'WIP_BYPRODUCT_COMPLETION '),'INV');
1712: l_source_type := 'CSIWIPBC ';
1713: IF (l_bypass = 'N') THEN
1714: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1715: -- WIP By Product Completion

Line 1751: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_ASSEMBLY_COMPLETION'),'INV');

1747: END IF;
1748:
1749: ELSE
1750: l_type_id := 73;
1751: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_ASSEMBLY_COMPLETION'),'INV');
1752: l_source_type := 'CSIWIPAC';
1753: IF (l_bypass = 'N') THEN
1754: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1755: -- WIP Assembly Completion

Line 1802: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_ISSUE'),'INV');

1798: ----------------------- ------------- ------------
1799: --1. WIP Neg Comp Return 34 48
1800:
1801: l_type_id := 71;
1802: l_type_id := csi_inv_trxs_pkg.get_txn_type_id(nvl(l_csi_txn_name,'WIP_ISSUE'),'INV');
1803: l_source_type := 'CSIWIPNR';
1804: IF (l_bypass = 'N') THEN
1805: debug(' publishing '||l_source_type||' for transaction_id : '||p_transaction_id);
1806: -- WIP Negative Component Return

Line 1881: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);

1877: debug('Raising HOOK_ERROR');
1878: debug('You have encountered an error in the CSI_INV_TXN_HOOK_PKG Procedure for Transaction: '||p_transaction_id);
1879: debug('Error Message: '||l_error_message);
1880:
1881: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);
1882:
1883: l_trx_error_rec := csi_inv_trxs_pkg.Init_Txn_Error_Rec;
1884: l_trx_error_rec.transaction_id := NULL;
1885: l_trx_error_rec.message_id := l_message_id;

Line 1883: l_trx_error_rec := csi_inv_trxs_pkg.Init_Txn_Error_Rec;

1879: debug('Error Message: '||l_error_message);
1880:
1881: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);
1882:
1883: l_trx_error_rec := csi_inv_trxs_pkg.Init_Txn_Error_Rec;
1884: l_trx_error_rec.transaction_id := NULL;
1885: l_trx_error_rec.message_id := l_message_id;
1886: l_trx_error_rec.error_text := l_error_message;
1887: l_trx_error_rec.source_type := l_source_type;

Line 1892: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

1888: l_trx_error_rec.source_id := p_transaction_id;
1889: l_trx_error_rec.message_string := l_xml_string;
1890: l_trx_error_rec.transaction_type_id := l_type_id;
1891: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1892: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1893:
1894: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
1895:
1896: x_return_status := l_fnd_success;

Line 1894: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);

1890: l_trx_error_rec.transaction_type_id := l_type_id;
1891: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1892: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1893:
1894: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
1895:
1896: x_return_status := l_fnd_success;
1897:
1898: WHEN BYPASS_ERROR THEN

Line 1902: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);

1898: WHEN BYPASS_ERROR THEN
1899: debug('Raising BYPASS_ERROR');
1900: debug('You have encountered an error in the CSI_INV_TXN_HOOK_PKG Procedure for Transaction: '||p_transaction_id);
1901: debug('Error Message: '||l_trx_error_rec.error_text);
1902: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);
1903:
1904: l_trx_error_rec.transaction_id := NULL;
1905: l_trx_error_rec.message_id := NULL;
1906: l_trx_error_rec.source_type := l_source_type;

Line 1908: l_trx_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;

1904: l_trx_error_rec.transaction_id := NULL;
1905: l_trx_error_rec.message_id := NULL;
1906: l_trx_error_rec.source_type := l_source_type;
1907: l_trx_error_rec.source_id := l_trx_error_rec.source_id;
1908: l_trx_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
1909: l_trx_error_rec.message_string := l_xml_string;
1910: l_trx_error_rec.transaction_type_id := l_type_id;
1911: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1912: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

Line 1912: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

1908: l_trx_Error_Rec.processed_flag := CSI_INV_TRXS_PKG.G_TXN_ERROR;
1909: l_trx_error_rec.message_string := l_xml_string;
1910: l_trx_error_rec.transaction_type_id := l_type_id;
1911: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1912: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1913:
1914: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
1915:
1916: x_return_status := l_fnd_success;

Line 1914: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);

1910: l_trx_error_rec.transaction_type_id := l_type_id;
1911: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1912: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1913:
1914: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
1915:
1916: x_return_status := l_fnd_success;
1917:
1918: WHEN OTHERS THEN

Line 1927: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);

1923: debug('Raising OTHERS');
1924: debug('You have encountered an error in the CSI_INV_TXN_HOOK_PKG Procedure for Transaction: '||p_transaction_id);
1925: debug('Error Message: '||l_error_message);
1926:
1927: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);
1928: l_trx_error_rec := csi_inv_trxs_pkg.Init_Txn_Error_Rec;
1929: l_trx_error_rec.transaction_id := NULL;
1930: l_trx_error_rec.message_id := NULL;
1931: l_trx_error_rec.error_text := l_error_message;

Line 1928: l_trx_error_rec := csi_inv_trxs_pkg.Init_Txn_Error_Rec;

1924: debug('You have encountered an error in the CSI_INV_TXN_HOOK_PKG Procedure for Transaction: '||p_transaction_id);
1925: debug('Error Message: '||l_error_message);
1926:
1927: csi_inv_trxs_pkg.build_error_string(l_xml_string,'MTL_TRANSACTION_ID',p_transaction_id);
1928: l_trx_error_rec := csi_inv_trxs_pkg.Init_Txn_Error_Rec;
1929: l_trx_error_rec.transaction_id := NULL;
1930: l_trx_error_rec.message_id := NULL;
1931: l_trx_error_rec.error_text := l_error_message;
1932: l_trx_error_rec.source_type := l_source_type;

Line 1937: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;

1933: l_trx_error_rec.source_id := p_transaction_id;
1934: l_trx_error_rec.message_string := l_xml_string;
1935: l_trx_error_rec.transaction_type_id := l_type_id;
1936: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1937: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1938:
1939: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
1940:
1941: x_return_status := l_fnd_success;

Line 1939: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);

1935: l_trx_error_rec.transaction_type_id := l_type_id;
1936: l_trx_error_rec.inv_material_transaction_id := p_transaction_id;
1937: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
1938:
1939: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
1940:
1941: x_return_status := l_fnd_success;
1942:
1943: END postTransaction;