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.INV_LPN_TRX_PUB dependencies on INV_GLOBALS

Line 61: IF (p_trans_action_id NOT IN(inv_globals.g_action_issue, inv_globals.g_action_receipt,INV_GLOBALS.G_ACTION_SUBXFR,

57: inv_log_util.TRACE('** Trans Eres Enabled trx_action_id = ' || p_trans_action_id, 'INV_LPN_TRX_PUB', 9);
58: inv_log_util.TRACE('** Trans Eres Enabled trx_soource_id =' || p_trans_source_type_id, 'INV_LPN_TRX_PUB', 9);
59: END IF;
60:
61: IF (p_trans_action_id NOT IN(inv_globals.g_action_issue, inv_globals.g_action_receipt,INV_GLOBALS.G_ACTION_SUBXFR,
62: INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
63: inv_log_util.TRACE(
64: '** Transactions Not ERES Supported trx_action_id =' || p_trans_action_id || ',trx_source_type_id =' || p_trans_source_type_id
65: , 'INV_LPN_TRX_PUB'

Line 62: INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN

58: inv_log_util.TRACE('** Trans Eres Enabled trx_soource_id =' || p_trans_source_type_id, 'INV_LPN_TRX_PUB', 9);
59: END IF;
60:
61: IF (p_trans_action_id NOT IN(inv_globals.g_action_issue, inv_globals.g_action_receipt,INV_GLOBALS.G_ACTION_SUBXFR,
62: INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
63: inv_log_util.TRACE(
64: '** Transactions Not ERES Supported trx_action_id =' || p_trans_action_id || ',trx_source_type_id =' || p_trans_source_type_id
65: , 'INV_LPN_TRX_PUB'
66: , 9

Line 69: ELSIF(p_trans_action_id = inv_globals.g_action_issue) THEN

65: , 'INV_LPN_TRX_PUB'
66: , 9
67: );
68: RETURN FALSE;
69: ELSIF(p_trans_action_id = inv_globals.g_action_issue) THEN
70: -- These are Issue trans types
71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN

Line 71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN

67: );
68: RETURN FALSE;
69: ELSIF(p_trans_action_id = inv_globals.g_action_issue) THEN
70: -- These are Issue trans types
71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
74: g_eres_event_name := 'oracle.apps.inv.acctAliasIssue';
75: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN

Line 73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN

69: ELSIF(p_trans_action_id = inv_globals.g_action_issue) THEN
70: -- These are Issue trans types
71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
74: g_eres_event_name := 'oracle.apps.inv.acctAliasIssue';
75: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
76: g_eres_event_name := 'oracle.apps.inv.miscIssue';
77: ELSE

Line 75: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN

71: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
72: g_eres_event_name := 'oracle.apps.inv.acctIssue';
73: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
74: g_eres_event_name := 'oracle.apps.inv.acctAliasIssue';
75: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
76: g_eres_event_name := 'oracle.apps.inv.miscIssue';
77: ELSE
78: RETURN FALSE;
79: END IF;

Line 80: ELSIF(p_trans_action_id = inv_globals.g_action_receipt) THEN

76: g_eres_event_name := 'oracle.apps.inv.miscIssue';
77: ELSE
78: RETURN FALSE;
79: END IF;
80: ELSIF(p_trans_action_id = inv_globals.g_action_receipt) THEN
81: -- These are Reciept trans types
82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN

Line 82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN

78: RETURN FALSE;
79: END IF;
80: ELSIF(p_trans_action_id = inv_globals.g_action_receipt) THEN
81: -- These are Reciept trans types
82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
85: g_eres_event_name := 'oracle.apps.inv.acctAliasReceipt';
86: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN

Line 84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN

80: ELSIF(p_trans_action_id = inv_globals.g_action_receipt) THEN
81: -- These are Reciept trans types
82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
85: g_eres_event_name := 'oracle.apps.inv.acctAliasReceipt';
86: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
87: g_eres_event_name := 'oracle.apps.inv.miscReceipt';
88: ELSE

Line 86: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN

82: IF (p_trans_source_type_id = inv_globals.g_sourcetype_account) THEN
83: g_eres_event_name := 'oracle.apps.inv.acctReceipt';
84: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_accountalias) THEN
85: g_eres_event_name := 'oracle.apps.inv.acctAliasReceipt';
86: ELSIF(p_trans_source_type_id = inv_globals.g_sourcetype_inventory) THEN
87: g_eres_event_name := 'oracle.apps.inv.miscReceipt';
88: ELSE
89: RETURN FALSE;
90: END IF;

Line 92: ELSIF (p_trans_action_id = INV_GLOBALS.G_ACTION_SUBXFR) THEN

88: ELSE
89: RETURN FALSE;
90: END IF;
91: -- fabdi invconv start
92: ELSIF (p_trans_action_id = INV_GLOBALS.G_ACTION_SUBXFR) THEN
93: -- These are Inter-Org Transfers trans types
94: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
95: g_eres_event_name := 'oracle.apps.inv.subinvTransfer';
96: ELSE

Line 94: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN

90: END IF;
91: -- fabdi invconv start
92: ELSIF (p_trans_action_id = INV_GLOBALS.G_ACTION_SUBXFR) THEN
93: -- These are Inter-Org Transfers trans types
94: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
95: g_eres_event_name := 'oracle.apps.inv.subinvTransfer';
96: ELSE
97: RETURN FALSE;
98: END IF;

Line 99: ELSIF (p_trans_action_id in (INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN

95: g_eres_event_name := 'oracle.apps.inv.subinvTransfer';
96: ELSE
97: RETURN FALSE;
98: END IF;
99: ELSIF (p_trans_action_id in (INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
100: -- These are Subinventory Transfers trans types
101: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
102: g_eres_event_name := 'oracle.apps.inv.interorgTransfer';
103: ELSE

Line 101: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN

97: RETURN FALSE;
98: END IF;
99: ELSIF (p_trans_action_id in (INV_GLOBALS.G_ACTION_ORGXFR, INV_GLOBALS.G_ACTION_INTRANSITSHIPMENT)) THEN
100: -- These are Subinventory Transfers trans types
101: IF (p_trans_source_type_id = INV_GLOBALS.G_SOURCETYPE_INVENTORY) THEN
102: g_eres_event_name := 'oracle.apps.inv.interorgTransfer';
103: ELSE
104: RETURN FALSE;
105: END IF;

Line 288: IF (v_trxaction = inv_globals.g_action_orgxfr)

284: -- If the transaction action is OrgXfr, IntrShipment or IntrRcpt
285: -- then set the cost_group_id to null. The CostGroup API will
286: -- determine the cost-group-id in this case. Insert into MMTT using
287: -- the passed MMTT_Record type.
288: IF (v_trxaction = inv_globals.g_action_orgxfr)
289: OR(v_trxaction = inv_globals.g_action_intransitshipment)
290: OR(v_trxaction = inv_globals.g_action_intransitreceipt) THEN
291: l_xfr_cst_grp_id := NULL;
292: END IF;

Line 289: OR(v_trxaction = inv_globals.g_action_intransitshipment)

285: -- then set the cost_group_id to null. The CostGroup API will
286: -- determine the cost-group-id in this case. Insert into MMTT using
287: -- the passed MMTT_Record type.
288: IF (v_trxaction = inv_globals.g_action_orgxfr)
289: OR(v_trxaction = inv_globals.g_action_intransitshipment)
290: OR(v_trxaction = inv_globals.g_action_intransitreceipt) THEN
291: l_xfr_cst_grp_id := NULL;
292: END IF;
293:

Line 290: OR(v_trxaction = inv_globals.g_action_intransitreceipt) THEN

286: -- determine the cost-group-id in this case. Insert into MMTT using
287: -- the passed MMTT_Record type.
288: IF (v_trxaction = inv_globals.g_action_orgxfr)
289: OR(v_trxaction = inv_globals.g_action_intransitshipment)
290: OR(v_trxaction = inv_globals.g_action_intransitreceipt) THEN
291: l_xfr_cst_grp_id := NULL;
292: END IF;
293:
294: -- Start Bug 10158934

Line 912: IF (p_mmtt.transaction_action_id <> inv_globals.g_action_orgxfr)

908: END IF;
909:
910: -- Bug 2712046, add cost group comingle check if transfer location is non-LPN controlled
911: -- Set value for l_check_cg_comingle, this only need to be checked once before the Loop
912: IF (p_mmtt.transaction_action_id <> inv_globals.g_action_orgxfr)
913: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitshipment)
914: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
915: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
916: SELECT NVL(lpn_controlled_flag, 2)

Line 913: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitshipment)

909:
910: -- Bug 2712046, add cost group comingle check if transfer location is non-LPN controlled
911: -- Set value for l_check_cg_comingle, this only need to be checked once before the Loop
912: IF (p_mmtt.transaction_action_id <> inv_globals.g_action_orgxfr)
913: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitshipment)
914: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
915: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
916: SELECT NVL(lpn_controlled_flag, 2)
917: INTO l_skip_comingle_check

Line 914: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)

910: -- Bug 2712046, add cost group comingle check if transfer location is non-LPN controlled
911: -- Set value for l_check_cg_comingle, this only need to be checked once before the Loop
912: IF (p_mmtt.transaction_action_id <> inv_globals.g_action_orgxfr)
913: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitshipment)
914: AND(p_mmtt.transaction_action_id <> inv_globals.g_action_intransitreceipt)
915: AND(NVL(p_mmtt.transfer_subinventory, p_mmtt.subinventory_code) IS NOT NULL) THEN
916: SELECT NVL(lpn_controlled_flag, 2)
917: INTO l_skip_comingle_check
918: FROM mtl_secondary_inventories

Line 1255: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)

1251: -- End Bug 2712046
1252:
1253: -- if the previous item's qty was changed, then update record
1254: IF (itemqtychanged) THEN
1255: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1256: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN
1257: v_lastitemqty := -1 * v_lastitemqty;
1258:
1259: IF v_lastitemsecqty <> 0 THEN -- INVCONV KKILLAMS

Line 1256: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN

1252:
1253: -- if the previous item's qty was changed, then update record
1254: IF (itemqtychanged) THEN
1255: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1256: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN
1257: v_lastitemqty := -1 * v_lastitemqty;
1258:
1259: IF v_lastitemsecqty <> 0 THEN -- INVCONV KKILLAMS
1260: v_lastitemsecqty := -1 * v_lastitemsecqty;

Line 1300: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)

1296: -- If this an InterOrg Xfer transaction, then call the CostGroup API
1297: -- for the previously entered content Item. At this stage all the
1298: -- rows for this item would have been entered to the temp tables.
1299: IF (lastitemid IS NOT NULL) THEN
1300: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1301: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1302: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1303: OR
1304: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP

Line 1301: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)

1297: -- for the previously entered content Item. At this stage all the
1298: -- rows for this item would have been entered to the temp tables.
1299: IF (lastitemid IS NOT NULL) THEN
1300: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1301: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1302: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1303: OR
1304: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1305: -- Changed to add the condition that if cost group ID is null then also need to call cost group API

Line 1302: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)

1298: -- rows for this item would have been entered to the temp tables.
1299: IF (lastitemid IS NOT NULL) THEN
1300: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1301: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1302: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1303: OR
1304: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1305: -- Changed to add the condition that if cost group ID is null then also need to call cost group API
1306: ( p_mmtt.cost_group_id IS NULL) THEN

Line 1345: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)

1341: v_lastitemsecqty := curlpnrec.sec_quantity; --INVCONV kkillams
1342: v_lastitempriqty := curlpnrec.primary_quantity; --16445970
1343:
1344: -- insert a record into MMTT.
1345: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1346: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1347: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1348: AND(p_mmtt.transaction_quantity < 0)) THEN
1349: itemqty := -1 * curlpnrec.quantity;

Line 1346: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)

1342: v_lastitempriqty := curlpnrec.primary_quantity; --16445970
1343:
1344: -- insert a record into MMTT.
1345: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1346: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1347: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1348: AND(p_mmtt.transaction_quantity < 0)) THEN
1349: itemqty := -1 * curlpnrec.quantity;
1350: itemsecqty := -1 * curlpnrec.sec_quantity; --INVCONV kkillams

Line 1347: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)

1343:
1344: -- insert a record into MMTT.
1345: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1346: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1347: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1348: AND(p_mmtt.transaction_quantity < 0)) THEN
1349: itemqty := -1 * curlpnrec.quantity;
1350: itemsecqty := -1 * curlpnrec.sec_quantity; --INVCONV kkillams
1351: ELSE

Line 1435: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)

1431: END LOOP;
1432:
1433: -- Any item or lot qty need to be updated ??
1434: IF (itemqtychanged) THEN
1435: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1436: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1437: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1438: AND(p_mmtt.transaction_quantity < 0)) THEN
1439: v_lastitemqty := -1 * v_lastitemqty;

Line 1436: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)

1432:
1433: -- Any item or lot qty need to be updated ??
1434: IF (itemqtychanged) THEN
1435: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1436: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1437: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1438: AND(p_mmtt.transaction_quantity < 0)) THEN
1439: v_lastitemqty := -1 * v_lastitemqty;
1440: IF v_lastitemsecqty IS NOT NULL THEN

Line 1437: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)

1433: -- Any item or lot qty need to be updated ??
1434: IF (itemqtychanged) THEN
1435: IF (p_mmtt.transaction_action_id = inv_globals.g_action_issue)
1436: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1437: OR((p_mmtt.transaction_action_id = inv_globals.g_action_inv_lot_translate)
1438: AND(p_mmtt.transaction_quantity < 0)) THEN
1439: v_lastitemqty := -1 * v_lastitemqty;
1440: IF v_lastitemsecqty IS NOT NULL THEN
1441: v_lastitemsecqty := -1 * v_lastitemsecqty; --INVCONV kkillams

Line 1475: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)

1471:
1472: -- If this an InterOrg Xfer transaction, then call the CostGroup API
1473: -- for the previously entered content Item. At this stage all the
1474: -- rows for this item would have been entered to the temp tables.
1475: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1476: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1477: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1478: OR
1479: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP

Line 1476: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)

1472: -- If this an InterOrg Xfer transaction, then call the CostGroup API
1473: -- for the previously entered content Item. At this stage all the
1474: -- rows for this item would have been entered to the temp tables.
1475: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1476: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1477: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1478: OR
1479: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1480: -- Changed to add the condition that if cost group ID is null then also need to call cost group API

Line 1477: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)

1473: -- for the previously entered content Item. At this stage all the
1474: -- rows for this item would have been entered to the temp tables.
1475: IF (p_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
1476: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
1477: OR(p_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
1478: OR
1479: -- Bug 2712046 Cost group and comingling check is not executed when putaway a whole LPN for WIP
1480: -- Changed to add the condition that if cost group ID is null then also need to call cost group API
1481: ( p_mmtt.cost_group_id IS NULL) THEN

Line 1548: IF (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN

1544:
1545: RETURN;
1546: END IF;
1547:
1548: IF (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment) THEN
1549: BEGIN
1550: SELECT fob_point
1551: , intransit_inv_account
1552: INTO l_fob_point

Line 1577: ELSIF(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt) THEN

1573:
1574: /**bug 3371548 assign values to the cursor*/
1575: v_mmtt.fob_point := l_fob_point;
1576: v_mmtt.intransit_account := l_intransit_inv_account;
1577: ELSIF(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt) THEN
1578: BEGIN
1579: SELECT shipment_line_id
1580: INTO l_shipment_line_id
1581: FROM rcv_transactions

Line 1713: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)

1709:
1710: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1711: BEGIN
1712: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1713: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1714: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1715: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1716: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1717: THEN

Line 1714: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)

1710: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1711: BEGIN
1712: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1713: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1714: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1715: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1716: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1717: THEN
1718: -- For the above types ignore the item controls

Line 1715: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)

1711: BEGIN
1712: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1713: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1714: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1715: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1716: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1717: THEN
1718: -- For the above types ignore the item controls
1719: l_ignore_item_controls := 1;

Line 1716: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))

1712: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1713: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1714: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)
1715: OR (p_source_type_id = inv_globals.g_sourcetype_intreq AND p_trx_action = inv_globals.g_action_intransitreceipt)
1716: OR (p_source_type_id = inv_globals.g_sourcetype_inventory AND p_trx_action = inv_globals.g_action_intransitreceipt)))
1717: THEN
1718: -- For the above types ignore the item controls
1719: l_ignore_item_controls := 1;
1720: ELSE

Line 3634: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue

3630: from mtl_system_items_b msib
3631: where msib.inventory_item_id = mmt.inventory_item_id
3632: and msib.organization_id = mmt.organization_id
3633: and msib.process_quality_enabled_flag = 'Y')
3634: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3635: ,inv_globals.g_action_receipt
3636: ,inv_globals.g_action_subxfr
3637: ,inv_globals.g_action_orgxfr
3638: ,inv_globals.g_action_intransitshipment

Line 3635: ,inv_globals.g_action_receipt

3631: where msib.inventory_item_id = mmt.inventory_item_id
3632: and msib.organization_id = mmt.organization_id
3633: and msib.process_quality_enabled_flag = 'Y')
3634: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3635: ,inv_globals.g_action_receipt
3636: ,inv_globals.g_action_subxfr
3637: ,inv_globals.g_action_orgxfr
3638: ,inv_globals.g_action_intransitshipment
3639: ,inv_globals.g_action_intransitreceipt))

Line 3636: ,inv_globals.g_action_subxfr

3632: and msib.organization_id = mmt.organization_id
3633: and msib.process_quality_enabled_flag = 'Y')
3634: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3635: ,inv_globals.g_action_receipt
3636: ,inv_globals.g_action_subxfr
3637: ,inv_globals.g_action_orgxfr
3638: ,inv_globals.g_action_intransitshipment
3639: ,inv_globals.g_action_intransitreceipt))
3640: --Bug#6509707.Included Account Alias Receipt.

Line 3637: ,inv_globals.g_action_orgxfr

3633: and msib.process_quality_enabled_flag = 'Y')
3634: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3635: ,inv_globals.g_action_receipt
3636: ,inv_globals.g_action_subxfr
3637: ,inv_globals.g_action_orgxfr
3638: ,inv_globals.g_action_intransitshipment
3639: ,inv_globals.g_action_intransitreceipt))
3640: --Bug#6509707.Included Account Alias Receipt.
3641: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)

Line 3638: ,inv_globals.g_action_intransitshipment

3634: AND ( ( ( ( (mmt.transaction_action_id IN ( inv_globals.g_action_issue
3635: ,inv_globals.g_action_receipt
3636: ,inv_globals.g_action_subxfr
3637: ,inv_globals.g_action_orgxfr
3638: ,inv_globals.g_action_intransitshipment
3639: ,inv_globals.g_action_intransitreceipt))
3640: --Bug#6509707.Included Account Alias Receipt.
3641: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3642: ) )

Line 3639: ,inv_globals.g_action_intransitreceipt))

3635: ,inv_globals.g_action_receipt
3636: ,inv_globals.g_action_subxfr
3637: ,inv_globals.g_action_orgxfr
3638: ,inv_globals.g_action_intransitshipment
3639: ,inv_globals.g_action_intransitreceipt))
3640: --Bug#6509707.Included Account Alias Receipt.
3641: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3642: ) )
3643: -- Pawan Kumar added bug 5533472

Line 3641: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)

3637: ,inv_globals.g_action_orgxfr
3638: ,inv_globals.g_action_intransitshipment
3639: ,inv_globals.g_action_intransitreceipt))
3640: --Bug#6509707.Included Account Alias Receipt.
3641: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3642: ) )
3643: -- Pawan Kumar added bug 5533472
3644: OR (
3645: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)

Line 3645: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)

3641: AND (mmt.transaction_source_type_id IN (inv_globals.g_sourcetype_inventory,inv_globals.g_sourcetype_accountalias)
3642: ) )
3643: -- Pawan Kumar added bug 5533472
3644: OR (
3645: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)
3646: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3647: )
3648: OR (
3649: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)

Line 3646: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)

3642: ) )
3643: -- Pawan Kumar added bug 5533472
3644: OR (
3645: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)
3646: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3647: )
3648: OR (
3649: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3650: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)

Line 3649: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)

3645: (mmt.transaction_action_id = inv_globals.g_action_assycomplete)
3646: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3647: )
3648: OR (
3649: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3650: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3651: )
3652: OR (
3653: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)

Line 3650: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)

3646: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_wip)
3647: )
3648: OR (
3649: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3650: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3651: )
3652: OR (
3653: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)
3654: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_physicalcount)

Line 3653: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)

3649: (mmt.transaction_action_id = inv_globals.g_action_cyclecountadj)
3650: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3651: )
3652: OR (
3653: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)
3654: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_physicalcount)
3655: )
3656:
3657: )

Line 3654: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_physicalcount)

3650: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_cyclecount)
3651: )
3652: OR (
3653: (mmt.transaction_action_id = inv_globals.g_action_physicalcountadj)
3654: AND (mmt.transaction_source_type_id = inv_globals.g_sourcetype_physicalcount)
3655: )
3656:
3657: )
3658: AND (exists (select gisv.spec_id

Line 3667: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)

3663: and gisv.spec_id = gsb.spec_id
3664: and gisv.delete_mark = 0
3665: and (gisv.organization_id is null OR gisv.organization_id = mmt.organization_id)))
3666: )
3667: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3668: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3669: ,inv_globals.g_sourcetype_rma
3670: ,inv_globals.g_sourcetype_intreq))
3671: AND ( (exists (select gssv.spec_id

Line 3668: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder

3664: and gisv.delete_mark = 0
3665: and (gisv.organization_id is null OR gisv.organization_id = mmt.organization_id)))
3666: )
3667: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3668: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3669: ,inv_globals.g_sourcetype_rma
3670: ,inv_globals.g_sourcetype_intreq))
3671: AND ( (exists (select gssv.spec_id
3672: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb

Line 3669: ,inv_globals.g_sourcetype_rma

3665: and (gisv.organization_id is null OR gisv.organization_id = mmt.organization_id)))
3666: )
3667: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3668: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3669: ,inv_globals.g_sourcetype_rma
3670: ,inv_globals.g_sourcetype_intreq))
3671: AND ( (exists (select gssv.spec_id
3672: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb
3673: where gsb.inventory_item_id = mmt.inventory_item_id

Line 3670: ,inv_globals.g_sourcetype_intreq))

3666: )
3667: OR ( (mmt.transaction_action_id = inv_globals.g_action_receipt)
3668: AND (mmt.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
3669: ,inv_globals.g_sourcetype_rma
3670: ,inv_globals.g_sourcetype_intreq))
3671: AND ( (exists (select gssv.spec_id
3672: from gmd_supplier_spec_vrs gssv, gmd_specifications_b gsb
3673: where gsb.inventory_item_id = mmt.inventory_item_id
3674: and gsb.spec_status in (400,700)

Line 3863: WHERE transaction_action_id = inv_globals.g_action_containerpack

3859: FROM DUAL
3860: WHERE EXISTS(
3861: SELECT 1
3862: FROM mtl_material_transactions_temp
3863: WHERE transaction_action_id = inv_globals.g_action_containerpack
3864: AND transfer_lpn_id IS NULL
3865: AND transaction_header_id = p_trx_hdr_id);
3866: EXCEPTION
3867: WHEN NO_DATA_FOUND THEN

Line 4083: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory

4079: | adjustment to go through TM for lot serial support
4080: +------------------------------------------------------*/
4081: IF (
4082: (
4083: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
4084: AND v_mmtt.transaction_action_id IN
4085: (
4086: inv_globals.g_action_logicalissue
4087: , inv_globals.g_action_logicalicsales

Line 4086: inv_globals.g_action_logicalissue

4082: (
4083: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
4084: AND v_mmtt.transaction_action_id IN
4085: (
4086: inv_globals.g_action_logicalissue
4087: , inv_globals.g_action_logicalicsales
4088: , inv_globals.g_action_logicalicreceipt
4089: , inv_globals.g_action_logicalicrcptreturn
4090: , inv_globals.g_action_logicalicsalesreturn

Line 4087: , inv_globals.g_action_logicalicsales

4083: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory
4084: AND v_mmtt.transaction_action_id IN
4085: (
4086: inv_globals.g_action_logicalissue
4087: , inv_globals.g_action_logicalicsales
4088: , inv_globals.g_action_logicalicreceipt
4089: , inv_globals.g_action_logicalicrcptreturn
4090: , inv_globals.g_action_logicalicsalesreturn
4091: , inv_globals.g_action_logicalreceipt

Line 4088: , inv_globals.g_action_logicalicreceipt

4084: AND v_mmtt.transaction_action_id IN
4085: (
4086: inv_globals.g_action_logicalissue
4087: , inv_globals.g_action_logicalicsales
4088: , inv_globals.g_action_logicalicreceipt
4089: , inv_globals.g_action_logicalicrcptreturn
4090: , inv_globals.g_action_logicalicsalesreturn
4091: , inv_globals.g_action_logicalreceipt
4092: )

Line 4089: , inv_globals.g_action_logicalicrcptreturn

4085: (
4086: inv_globals.g_action_logicalissue
4087: , inv_globals.g_action_logicalicsales
4088: , inv_globals.g_action_logicalicreceipt
4089: , inv_globals.g_action_logicalicrcptreturn
4090: , inv_globals.g_action_logicalicsalesreturn
4091: , inv_globals.g_action_logicalreceipt
4092: )
4093: )

Line 4090: , inv_globals.g_action_logicalicsalesreturn

4086: inv_globals.g_action_logicalissue
4087: , inv_globals.g_action_logicalicsales
4088: , inv_globals.g_action_logicalicreceipt
4089: , inv_globals.g_action_logicalicrcptreturn
4090: , inv_globals.g_action_logicalicsalesreturn
4091: , inv_globals.g_action_logicalreceipt
4092: )
4093: )
4094: OR(

Line 4091: , inv_globals.g_action_logicalreceipt

4087: , inv_globals.g_action_logicalicsales
4088: , inv_globals.g_action_logicalicreceipt
4089: , inv_globals.g_action_logicalicrcptreturn
4090: , inv_globals.g_action_logicalicsalesreturn
4091: , inv_globals.g_action_logicalreceipt
4092: )
4093: )
4094: OR(
4095: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma

Line 4095: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma

4091: , inv_globals.g_action_logicalreceipt
4092: )
4093: )
4094: OR(
4095: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
4096: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4097: )
4098: OR(
4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

Line 4096: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt

4092: )
4093: )
4094: OR(
4095: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
4096: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4097: )
4098: OR(
4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4100: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,

Line 4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

4095: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
4096: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4097: )
4098: OR(
4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4100: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
4101: -- inv_globals.G_action_logicaldeladj,
4102: -- inv_globals.G_action_logicalreceipt,
4103: inv_globals.g_action_retropriceupdate)

Line 4100: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,

4096: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4097: )
4098: OR(
4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4100: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
4101: -- inv_globals.G_action_logicaldeladj,
4102: -- inv_globals.G_action_logicalreceipt,
4103: inv_globals.g_action_retropriceupdate)
4104: )

Line 4101: -- inv_globals.G_action_logicaldeladj,

4097: )
4098: OR(
4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4100: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
4101: -- inv_globals.G_action_logicaldeladj,
4102: -- inv_globals.G_action_logicalreceipt,
4103: inv_globals.g_action_retropriceupdate)
4104: )
4105: OR(

Line 4102: -- inv_globals.G_action_logicalreceipt,

4098: OR(
4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4100: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
4101: -- inv_globals.G_action_logicaldeladj,
4102: -- inv_globals.G_action_logicalreceipt,
4103: inv_globals.g_action_retropriceupdate)
4104: )
4105: OR(
4106: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma

Line 4103: inv_globals.g_action_retropriceupdate)

4099: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
4100: AND v_mmtt.transaction_action_id IN(inv_globals.g_action_logicalissue,
4101: -- inv_globals.G_action_logicaldeladj,
4102: -- inv_globals.G_action_logicalreceipt,
4103: inv_globals.g_action_retropriceupdate)
4104: )
4105: OR(
4106: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
4107: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt

Line 4106: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma

4102: -- inv_globals.G_action_logicalreceipt,
4103: inv_globals.g_action_retropriceupdate)
4104: )
4105: OR(
4106: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
4107: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4108: )
4109: OR(
4110: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq

Line 4107: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt

4103: inv_globals.g_action_retropriceupdate)
4104: )
4105: OR(
4106: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
4107: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4108: )
4109: OR(
4110: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
4111: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt

Line 4110: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq

4106: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_rma
4107: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4108: )
4109: OR(
4110: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
4111: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
4112: )
4113: OR(
4114: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

Line 4111: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt

4107: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalreceipt
4108: )
4109: OR(
4110: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
4111: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
4112: )
4113: OR(
4114: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
4115: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue

Line 4114: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

4110: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_intreq
4111: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
4112: )
4113: OR(
4114: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
4115: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
4116: )
4117: ) THEN
4118: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');

Line 4115: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue

4111: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalexpreqreceipt
4112: )
4113: OR(
4114: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
4115: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
4116: )
4117: ) THEN
4118: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
4119: fnd_msg_pub.ADD;

Line 4149: IF ((v_mmtt.transaction_action_id = inv_globals.g_action_planxfr)

4145: --For any transaction in mmtt which is an explicit transaction,
4146: --implying that the owning_org or planning_org is populated in
4147: --mmtt make sure the transactions are alwaya processed in online
4148: -- mode bug 3691234
4149: IF ((v_mmtt.transaction_action_id = inv_globals.g_action_planxfr)
4150: OR(v_mmtt.transaction_action_id = inv_globals.g_action_ownxfr)
4151: OR (Nvl(v_mmtt.owning_organization_id,v_mmtt.organization_id)
4152: <> v_mmtt.organization_id)
4153: OR (Nvl(v_mmtt.planning_organization_id,v_mmtt.organization_id)

Line 4150: OR(v_mmtt.transaction_action_id = inv_globals.g_action_ownxfr)

4146: --implying that the owning_org or planning_org is populated in
4147: --mmtt make sure the transactions are alwaya processed in online
4148: -- mode bug 3691234
4149: IF ((v_mmtt.transaction_action_id = inv_globals.g_action_planxfr)
4150: OR(v_mmtt.transaction_action_id = inv_globals.g_action_ownxfr)
4151: OR (Nvl(v_mmtt.owning_organization_id,v_mmtt.organization_id)
4152: <> v_mmtt.organization_id)
4153: OR (Nvl(v_mmtt.planning_organization_id,v_mmtt.organization_id)
4154: <> v_mmtt.organization_id)) THEN

Line 4162: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)

4158: -- If l_proc_mode is not set at this stage, it means control is at
4159: -- Forms-level Transaction-process profiles based on Transaction
4160: IF (l_proc_mode IS NULL) THEN
4161: IF (
4162: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4163: AND(v_mmtt.transaction_action_id = inv_globals.g_action_subxfr)
4164: ) THEN
4165: l_proc_mode := fnd_profile.VALUE('SUBINV_TRANS_TXN');
4166:

Line 4163: AND(v_mmtt.transaction_action_id = inv_globals.g_action_subxfr)

4159: -- Forms-level Transaction-process profiles based on Transaction
4160: IF (l_proc_mode IS NULL) THEN
4161: IF (
4162: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4163: AND(v_mmtt.transaction_action_id = inv_globals.g_action_subxfr)
4164: ) THEN
4165: l_proc_mode := fnd_profile.VALUE('SUBINV_TRANS_TXN');
4166:
4167: IF (l_debug = 1) THEN

Line 4172: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)

4168: inv_log_util.TRACE('Using SUBINV_TRANS_TXN to set process_mode. ProcMode=' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
4169: END IF;
4170: ELSIF(
4171: (
4172: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4173: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
4174: )
4175: AND(
4176: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)

Line 4173: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)

4169: END IF;
4170: ELSIF(
4171: (
4172: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4173: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
4174: )
4175: AND(
4176: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4177: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)

Line 4176: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)

4172: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4173: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
4174: )
4175: AND(
4176: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4177: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
4178: )
4179: ) THEN
4180: l_proc_mode := fnd_profile.VALUE('ACCOUNT_ISSUE_TXN');

Line 4177: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)

4173: OR(v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_account)
4174: )
4175: AND(
4176: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4177: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
4178: )
4179: ) THEN
4180: l_proc_mode := fnd_profile.VALUE('ACCOUNT_ISSUE_TXN');
4181:

Line 4186: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)

4182: IF (l_debug = 1) THEN
4183: inv_log_util.TRACE('Using ACCOUNT_ISSUE_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
4184: END IF;
4185: ELSIF(
4186: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
4187: AND(
4188: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
4189: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4190: )

Line 4188: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)

4184: END IF;
4185: ELSIF(
4186: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
4187: AND(
4188: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
4189: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4190: )
4191: ) THEN
4192: l_proc_mode := fnd_profile.VALUE('TRANSFER_ORDER_TXN');

Line 4189: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)

4185: ELSIF(
4186: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_moveorder)
4187: AND(
4188: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
4189: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4190: )
4191: ) THEN
4192: l_proc_mode := fnd_profile.VALUE('TRANSFER_ORDER_TXN');
4193:

Line 4198: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)

4194: IF (l_debug = 1) THEN
4195: inv_log_util.TRACE('Using TRANSFER_ORDER_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
4196: END IF;
4197: ELSIF(
4198: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4199: AND(
4200: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
4201: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4202: )

Line 4200: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)

4196: END IF;
4197: ELSIF(
4198: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4199: AND(
4200: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
4201: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4202: )
4203: ) THEN
4204: l_proc_mode := fnd_profile.VALUE('INTER_ORG_SHIP_TXN');

Line 4201: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)

4197: ELSIF(
4198: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4199: AND(
4200: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
4201: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4202: )
4203: ) THEN
4204: l_proc_mode := fnd_profile.VALUE('INTER_ORG_SHIP_TXN');
4205:

Line 4240: (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)

4236: -- mmtt record with the fob_point and inv_intransit_account in
4237: -- case of an intransit Rcpt or intransit Shipment transaction
4238: IF (po_code_release_grp.current_release >= po_code_release_grp.prc_11i_family_pack_j) THEN
4239: IF (
4240: (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4241: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
4242: ) THEN
4243: update_fob_point(v_mmtt => v_mmtt, x_return_status => l_fob_ret_sts, x_msg_data => l_fob_ret_msg
4244: , x_msg_count => l_fob_msg_count);

Line 4241: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)

4237: -- case of an intransit Rcpt or intransit Shipment transaction
4238: IF (po_code_release_grp.current_release >= po_code_release_grp.prc_11i_family_pack_j) THEN
4239: IF (
4240: (v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4241: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitreceipt)
4242: ) THEN
4243: update_fob_point(v_mmtt => v_mmtt, x_return_status => l_fob_ret_sts, x_msg_data => l_fob_ret_msg
4244: , x_msg_count => l_fob_msg_count);
4245:

Line 4297: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder

4293: inv_log_util.TRACE('Wms_enabled_flag: '||l_wms_enabled_org, 'INV_LPN_TRX_PUB', 1);
4294: IF NOT(
4295: (v_mmtt.content_lpn_id IS NOT NULL)
4296: AND
4297: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder
4298: AND
4299: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
4300: AND -- Bug 14341547 added the project contratcs type also.
4301: ( l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS )

Line 4299: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder

4295: (v_mmtt.content_lpn_id IS NOT NULL)
4296: AND
4297: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder
4298: AND
4299: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
4300: AND -- Bug 14341547 added the project contratcs type also.
4301: ( l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS )
4302: ) THEN
4303: inv_cost_group_pvt.assign_cost_group(

Line 4301: ( l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS )

4297: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder
4298: AND
4299: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder
4300: AND -- Bug 14341547 added the project contratcs type also.
4301: ( l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS )
4302: ) THEN
4303: inv_cost_group_pvt.assign_cost_group(
4304: x_return_status => ret_status
4305: , x_msg_count => ret_msgcnt

Line 4388: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)

4384: -- the sign of quantity is not -ve, make it -ve.
4385: -- Bug 3736797, added update to MMTT, since MMTT was never getting updated with sign changed.
4386: IF (
4387: (
4388: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4389: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4390: --Bug 12534588 Adding the updation of MMTT for assembly return action also.
4391: OR(v_mmtt.transaction_action_id = inv_globals.g_action_assyreturn)
4392: )

Line 4389: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)

4385: -- Bug 3736797, added update to MMTT, since MMTT was never getting updated with sign changed.
4386: IF (
4387: (
4388: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4389: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4390: --Bug 12534588 Adding the updation of MMTT for assembly return action also.
4391: OR(v_mmtt.transaction_action_id = inv_globals.g_action_assyreturn)
4392: )
4393: AND(v_mmtt.primary_quantity > 0)

Line 4391: OR(v_mmtt.transaction_action_id = inv_globals.g_action_assyreturn)

4387: (
4388: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4389: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4390: --Bug 12534588 Adding the updation of MMTT for assembly return action also.
4391: OR(v_mmtt.transaction_action_id = inv_globals.g_action_assyreturn)
4392: )
4393: AND(v_mmtt.primary_quantity > 0)
4394: ) THEN
4395:

Line 4452: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND

4448: -- item inside the LPN
4449:
4450: inv_log_util.TRACE('Wms_enabled_flag: '||l_wms_enabled_org, 'INV_LPN_TRX_PUB', 1);
4451: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4452: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4453: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4454: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4455: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4456: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND

Line 4453: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND

4449:
4450: inv_log_util.TRACE('Wms_enabled_flag: '||l_wms_enabled_org, 'INV_LPN_TRX_PUB', 1);
4451: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4452: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4453: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4454: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4455: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4456: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4457: -- Bug 14341547 added the project contratcs type also.

Line 4454: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND

4450: inv_log_util.TRACE('Wms_enabled_flag: '||l_wms_enabled_org, 'INV_LPN_TRX_PUB', 1);
4451: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4452: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4453: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4454: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4455: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4456: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4457: -- Bug 14341547 added the project contratcs type also.
4458: (l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS) AND

Line 4455: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND

4451: IF (v_mmtt.content_lpn_id IS NOT NULL) THEN
4452: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4453: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4454: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4455: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4456: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4457: -- Bug 14341547 added the project contratcs type also.
4458: (l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS) AND
4459: l_putway_explode_req = 'N' )

Line 4456: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND

4452: IF ( v_mmtt.transaction_action_id <> inv_globals.g_action_containerpack AND
4453: v_mmtt.transaction_action_id <> inv_globals.g_action_containerunpack AND
4454: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4455: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4456: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4457: -- Bug 14341547 added the project contratcs type also.
4458: (l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS) AND
4459: l_putway_explode_req = 'N' )
4460: THEN

Line 4458: (l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS) AND

4454: v_mmtt.transaction_action_id <> inv_globals.g_action_containersplit AND
4455: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_intorder AND
4456: v_mmtt.transaction_source_type_id <> inv_globals.g_sourcetype_salesorder AND
4457: -- Bug 14341547 added the project contratcs type also.
4458: (l_wms_enabled_org='Y' OR v_mmtt.transaction_source_type_id <> inv_globals.G_SOURCETYPE_PRJCONTRACTS) AND
4459: l_putway_explode_req = 'N' )
4460: THEN
4461:
4462: --Done changes to skip the call to explode lpn,in case of return order is created

Line 5032: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder

5028: /* FOR c1_rec IN cur_get_txn_for_opm_qm
5029: LOOP
5030: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5031: ,p_event_key => c1_rec.transaction_id);
5032: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5033: ,inv_globals.g_sourcetype_rma
5034: ,inv_globals.g_sourcetype_intreq) THEN
5035: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot
5036: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)

Line 5033: ,inv_globals.g_sourcetype_rma

5029: LOOP
5030: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5031: ,p_event_key => c1_rec.transaction_id);
5032: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5033: ,inv_globals.g_sourcetype_rma
5034: ,inv_globals.g_sourcetype_intreq) THEN
5035: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot
5036: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)
5037: LOOP

Line 5034: ,inv_globals.g_sourcetype_intreq) THEN

5030: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5031: ,p_event_key => c1_rec.transaction_id);
5032: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5033: ,inv_globals.g_sourcetype_rma
5034: ,inv_globals.g_sourcetype_intreq) THEN
5035: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot
5036: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)
5037: LOOP
5038:

Line 5057: IF c1_rec.transaction_source_type_id <> inv_globals.G_SOURCETYPE_WIP then -- -- 9756188

5053: LOOP
5054:
5055: inv_log_util.TRACE('in cur_get_txn_for_opm_qm - c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5056: inv_log_util.TRACE('in cur_get_txn_for_opm_qm - c1_rec.transaction_source_type_id = ' || c1_rec.transaction_source_type_id, 'INV_LPN_TRX_PUB', 1);
5057: IF c1_rec.transaction_source_type_id <> inv_globals.G_SOURCETYPE_WIP then -- -- 9756188
5058: inv_log_util.TRACE('about to raise event oracle.apps.gmi.inventory.created for NON G_SOURCETYPE_WIP for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5059: inv_log_util.TRACE(' gen_object_id = ' || l_gen_object_id, 'INV_LPN_TRX_PUB', 1);
5060: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5061: --,p_event_key => c1_rec.transaction_id);

Line 5064: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder

5060: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5061: --,p_event_key => c1_rec.transaction_id);
5062: ,p_event_key => to_char(c1_rec.transaction_id)||'-'||to_Char(l_gen_object_id)); -- pass a dummy gen_object_id as there is no lot for this pass
5063: end if;
5064: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5065: ,inv_globals.g_sourcetype_rma
5066: ,inv_globals.G_SOURCETYPE_WIP -- 9756188
5067: ,inv_globals.g_sourcetype_intreq) THEN
5068: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot

Line 5065: ,inv_globals.g_sourcetype_rma

5061: --,p_event_key => c1_rec.transaction_id);
5062: ,p_event_key => to_char(c1_rec.transaction_id)||'-'||to_Char(l_gen_object_id)); -- pass a dummy gen_object_id as there is no lot for this pass
5063: end if;
5064: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5065: ,inv_globals.g_sourcetype_rma
5066: ,inv_globals.G_SOURCETYPE_WIP -- 9756188
5067: ,inv_globals.g_sourcetype_intreq) THEN
5068: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot
5069: inv_log_util.TRACE('about to get into cr_get_distinct_lots - c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);

Line 5066: ,inv_globals.G_SOURCETYPE_WIP -- 9756188

5062: ,p_event_key => to_char(c1_rec.transaction_id)||'-'||to_Char(l_gen_object_id)); -- pass a dummy gen_object_id as there is no lot for this pass
5063: end if;
5064: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5065: ,inv_globals.g_sourcetype_rma
5066: ,inv_globals.G_SOURCETYPE_WIP -- 9756188
5067: ,inv_globals.g_sourcetype_intreq) THEN
5068: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot
5069: inv_log_util.TRACE('about to get into cr_get_distinct_lots - c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5070: i := 0; -- 13557341

Line 5067: ,inv_globals.g_sourcetype_intreq) THEN

5063: end if;
5064: IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5065: ,inv_globals.g_sourcetype_rma
5066: ,inv_globals.G_SOURCETYPE_WIP -- 9756188
5067: ,inv_globals.g_sourcetype_intreq) THEN
5068: -- Bug 5361705 - Raise the opm qm quality event for every distinct lot
5069: inv_log_util.TRACE('about to get into cr_get_distinct_lots - c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5070: i := 0; -- 13557341
5071: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)

Line 5073: IF c1_rec.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP THEN -- 9756188

5069: inv_log_util.TRACE('about to get into cr_get_distinct_lots - c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5070: i := 0; -- 13557341
5071: FOR c2_rec IN cr_get_distinct_lots(c1_rec.transaction_id)
5072: LOOP
5073: IF c1_rec.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP THEN -- 9756188
5074: inv_log_util.TRACE(' about to raise event oracle.apps.gmi.inventory.created for G_SOURCETYPE_WIP for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5075: inv_log_util.TRACE(' G_SOURCETYPE_WIP gen_object_id = ' || c2_rec.gen_object_id , 'INV_LPN_TRX_PUB', 1);
5076: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inventory.created'
5077: --,p_event_key => c1_rec.transaction_id);

Line 5093: IF c1_rec.transaction_source_type_id <> inv_globals.G_SOURCETYPE_WIP then -- 13686877 start added if

5089: --13557341 start if no lots found then raise event event oracle.apps.gmi.inventory.created for G_SOURCETYPE_WIP with not lot
5090: IF i = 0 then
5091: inv_log_util.TRACE('cursor cr_get_distinct_lots returns zero rows for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5092:
5093: IF c1_rec.transaction_source_type_id <> inv_globals.G_SOURCETYPE_WIP then -- 13686877 start added if
5094: inv_log_util.TRACE(' about to raise event oracle.apps.gmi.inv.po.receipt for c1_rec.transaction_id = ' || c1_rec.transaction_id, 'INV_LPN_TRX_PUB', 1);
5095: inv_log_util.TRACE(' dummy gen_object_id as there is no lot for this pass gen_object_id = ' || l_gen_object_id, 'INV_LPN_TRX_PUB', 1);
5096: wf_event.raise2( p_event_name => 'oracle.apps.gmi.inv.po.receipt'
5097: ,p_event_key =>to_char(c1_rec.transaction_id)||'-'||to_Char(l_gen_object_id)); -- pass a dummy gen_object_id as there is no lot for this pass

Line 5112: END IF; -- IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder

5108:
5109: end if ; -- IF i = o then
5110: -- 13557341 end
5111:
5112: END IF; -- IF c1_rec.transaction_source_type_id in ( inv_globals.g_sourcetype_purchaseorder
5113: END LOOP; -- FOR c1_rec IN cur_get_txn_for_opm_qm
5114: inv_log_util.TRACE(' @@@@@@@@@@@@@@@@@@ OPM part end @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@', 'INV_LPN_TRX_PUB', 1);
5115:
5116: -- HVERDDIN END OF ERES CHANGES

Line 5505: (p_transaction_action_id = inv_globals.g_action_issue)

5501: -- If the transaction action is either Issue or Intransit Shipment, and
5502: -- the sign of quantity is not -ve, make it -ve.
5503: IF (
5504: (
5505: (p_transaction_action_id = inv_globals.g_action_issue)
5506: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5507: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5508: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5509: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)

Line 5506: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)

5502: -- the sign of quantity is not -ve, make it -ve.
5503: IF (
5504: (
5505: (p_transaction_action_id = inv_globals.g_action_issue)
5506: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5507: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5508: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5509: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5510: )

Line 5507: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)

5503: IF (
5504: (
5505: (p_transaction_action_id = inv_globals.g_action_issue)
5506: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5507: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5508: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5509: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5510: )
5511: AND(p_primary_quantity > 0)

Line 5508: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)

5504: (
5505: (p_transaction_action_id = inv_globals.g_action_issue)
5506: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5507: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5508: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5509: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5510: )
5511: AND(p_primary_quantity > 0)
5512: ) THEN

Line 5509: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)

5505: (p_transaction_action_id = inv_globals.g_action_issue)
5506: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5507: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5508: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5509: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5510: )
5511: AND(p_primary_quantity > 0)
5512: ) THEN
5513: l_primary_quantity := -1 * p_primary_quantity;

Line 5522: (p_transaction_action_id = inv_globals.g_action_subxfr)

5518: END IF;
5519:
5520: IF (
5521: (
5522: (p_transaction_action_id = inv_globals.g_action_subxfr)
5523: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)

Line 5523: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)

5519:
5520: IF (
5521: (
5522: (p_transaction_action_id = inv_globals.g_action_subxfr)
5523: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)

Line 5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)

5520: IF (
5521: (
5522: (p_transaction_action_id = inv_globals.g_action_subxfr)
5523: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
5528: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)

Line 5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)

5521: (
5522: (p_transaction_action_id = inv_globals.g_action_subxfr)
5523: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
5528: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
5529: OR(p_transaction_action_id = inv_globals.g_action_containersplit)

Line 5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)

5522: (p_transaction_action_id = inv_globals.g_action_subxfr)
5523: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
5528: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
5529: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
5530: )

Line 5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)

5523: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
5528: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
5529: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
5530: )
5531: AND(p_primary_quantity < 0)

Line 5528: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)

5524: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
5528: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
5529: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
5530: )
5531: AND(p_primary_quantity < 0)
5532: ) THEN

Line 5529: OR(p_transaction_action_id = inv_globals.g_action_containersplit)

5525: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)
5526: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
5527: OR(p_transaction_action_id = inv_globals.g_action_containerpack)
5528: OR(p_transaction_action_id = inv_globals.g_action_containerunpack)
5529: OR(p_transaction_action_id = inv_globals.g_action_containersplit)
5530: )
5531: AND(p_primary_quantity < 0)
5532: ) THEN
5533: l_primary_quantity := -1 * p_primary_quantity;

Line 5547: p_transaction_action_id = inv_globals.g_action_deliveryadj

5543: -- IDS: Logical Transactions for lot and serials - Opened up TM to
5544: -- handle logical receipts and logical corrections.
5545: IF (
5546: (
5547: p_transaction_action_id = inv_globals.g_action_deliveryadj
5548: AND(
5549: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5550: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5551: )

Line 5549: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

5545: IF (
5546: (
5547: p_transaction_action_id = inv_globals.g_action_deliveryadj
5548: AND(
5549: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5550: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5551: )
5552: )
5553: OR(

Line 5550: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma

5546: (
5547: p_transaction_action_id = inv_globals.g_action_deliveryadj
5548: AND(
5549: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5550: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5551: )
5552: )
5553: OR(
5554: p_transaction_action_id = inv_globals.g_action_logicaldeladj

Line 5554: p_transaction_action_id = inv_globals.g_action_logicaldeladj

5550: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5551: )
5552: )
5553: OR(
5554: p_transaction_action_id = inv_globals.g_action_logicaldeladj
5555: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5556: )
5557: ) THEN
5558: -- Corrections. Need to retrieve interface_transaction_id and transaction_type

Line 5555: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

5551: )
5552: )
5553: OR(
5554: p_transaction_action_id = inv_globals.g_action_logicaldeladj
5555: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5556: )
5557: ) THEN
5558: -- Corrections. Need to retrieve interface_transaction_id and transaction_type
5559: BEGIN

Line 5714: IF (p_transaction_action_id = inv_globals.g_action_issue)

5710: END IF;
5711: END IF;
5712:
5713: /***** ISSUE/LotSplit/LotMerge/Cycle,PhysicalCnt/IntransitShipment trx ****/
5714: IF (p_transaction_action_id = inv_globals.g_action_issue)
5715: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5716: AND(l_primary_quantity < 0))
5717: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5718: AND(l_primary_quantity < 0))

Line 5715: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)

5711: END IF;
5712:
5713: /***** ISSUE/LotSplit/LotMerge/Cycle,PhysicalCnt/IntransitShipment trx ****/
5714: IF (p_transaction_action_id = inv_globals.g_action_issue)
5715: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5716: AND(l_primary_quantity < 0))
5717: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5718: AND(l_primary_quantity < 0))
5719: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)

Line 5717: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)

5713: /***** ISSUE/LotSplit/LotMerge/Cycle,PhysicalCnt/IntransitShipment trx ****/
5714: IF (p_transaction_action_id = inv_globals.g_action_issue)
5715: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5716: AND(l_primary_quantity < 0))
5717: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5718: AND(l_primary_quantity < 0))
5719: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5720: AND(l_primary_quantity < 0))
5721: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)

Line 5719: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)

5715: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_split)
5716: AND(l_primary_quantity < 0))
5717: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5718: AND(l_primary_quantity < 0))
5719: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5720: AND(l_primary_quantity < 0))
5721: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5722: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5723: AND l_primary_quantity < 0)

Line 5721: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)

5717: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
5718: AND(l_primary_quantity < 0))
5719: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5720: AND(l_primary_quantity < 0))
5721: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5722: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5723: AND l_primary_quantity < 0)
5724: OR ((p_transaction_action_id = inv_globals.g_action_assyreturn)
5725: AND l_primary_quantity < 0) --bug#9223918

Line 5722: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)

5718: AND(l_primary_quantity < 0))
5719: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
5720: AND(l_primary_quantity < 0))
5721: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5722: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5723: AND l_primary_quantity < 0)
5724: OR ((p_transaction_action_id = inv_globals.g_action_assyreturn)
5725: AND l_primary_quantity < 0) --bug#9223918
5726: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)

Line 5724: OR ((p_transaction_action_id = inv_globals.g_action_assyreturn)

5720: AND(l_primary_quantity < 0))
5721: OR(p_transaction_action_id = inv_globals.g_action_intransitshipment)
5722: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5723: AND l_primary_quantity < 0)
5724: OR ((p_transaction_action_id = inv_globals.g_action_assyreturn)
5725: AND l_primary_quantity < 0) --bug#9223918
5726: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5727: AND l_primary_quantity < 0) THEN
5728: IF (l_debug = 1) THEN

Line 5726: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)

5722: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
5723: AND l_primary_quantity < 0)
5724: OR ((p_transaction_action_id = inv_globals.g_action_assyreturn)
5725: AND l_primary_quantity < 0) --bug#9223918
5726: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
5727: AND l_primary_quantity < 0) THEN
5728: IF (l_debug = 1) THEN
5729: inv_log_util.TRACE(' Action = Issue, lpn=' || p_lpn_id || ',qty=' || l_primary_quantity, 'INV_LPN_TRX_PUB', 9);
5730: END IF;

Line 5741: p_transaction_action_id = inv_globals.g_action_intransitshipment

5737:
5738: v_lpn.lpn_id := p_content_lpn_id;
5739:
5740: IF (
5741: p_transaction_action_id = inv_globals.g_action_intransitshipment
5742: OR(p_transaction_action_id = inv_globals.g_action_issue
5743: AND p_transaction_source_type_id = inv_globals.g_sourcetype_intorder)
5744: ) THEN
5745: IF (p_po_dest_expense = 1 AND (nvl(p_manual_receipt_expense,'N') <> 'Y')) THEN -- 8491908

Line 5742: OR(p_transaction_action_id = inv_globals.g_action_issue

5738: v_lpn.lpn_id := p_content_lpn_id;
5739:
5740: IF (
5741: p_transaction_action_id = inv_globals.g_action_intransitshipment
5742: OR(p_transaction_action_id = inv_globals.g_action_issue
5743: AND p_transaction_source_type_id = inv_globals.g_sourcetype_intorder)
5744: ) THEN
5745: IF (p_po_dest_expense = 1 AND (nvl(p_manual_receipt_expense,'N') <> 'Y')) THEN -- 8491908
5746: -- Bug4663000 instead of unpacking expense contents.

Line 5743: AND p_transaction_source_type_id = inv_globals.g_sourcetype_intorder)

5739:
5740: IF (
5741: p_transaction_action_id = inv_globals.g_action_intransitshipment
5742: OR(p_transaction_action_id = inv_globals.g_action_issue
5743: AND p_transaction_source_type_id = inv_globals.g_sourcetype_intorder)
5744: ) THEN
5745: IF (p_po_dest_expense = 1 AND (nvl(p_manual_receipt_expense,'N') <> 'Y')) THEN -- 8491908
5746: -- Bug4663000 instead of unpacking expense contents.
5747: -- Change context of LPN to issued out of stores, but only if the

Line 5769: ELSIF(p_transaction_action_id = inv_globals.g_action_issue

5765: -- For manual rcpt, both Inventory and Expense Internal orders lpns context
5766: -- should be marked as intransit for recieving
5767: v_lpn.lpn_context := wms_container_pub.lpn_context_intransit;
5768: END IF;
5769: ELSIF(p_transaction_action_id = inv_globals.g_action_issue
5770: AND p_transaction_source_type_id = inv_globals.g_sourcetype_wip) THEN
5771: -- For WIP Issues the LPN set to be defined but not used
5772: v_lpn.lpn_context := wms_container_pub.lpn_context_pregenerated;
5773:

Line 5770: AND p_transaction_source_type_id = inv_globals.g_sourcetype_wip) THEN

5766: -- should be marked as intransit for recieving
5767: v_lpn.lpn_context := wms_container_pub.lpn_context_intransit;
5768: END IF;
5769: ELSIF(p_transaction_action_id = inv_globals.g_action_issue
5770: AND p_transaction_source_type_id = inv_globals.g_sourcetype_wip) THEN
5771: -- For WIP Issues the LPN set to be defined but not used
5772: v_lpn.lpn_context := wms_container_pub.lpn_context_pregenerated;
5773:
5774: IF (l_debug = 1) THEN

Line 5819: ELSIF(p_transaction_action_id = inv_globals.g_action_issue

5815: fnd_msg_pub.ADD;
5816: RAISE fnd_api.g_exc_error;
5817: END IF;
5818: --13884722
5819: ELSIF(p_transaction_action_id = inv_globals.g_action_issue
5820: AND p_transaction_source_type_id= inv_globals.g_sourcetype_moveorder
5821: AND p_lpn_id IS NOT NULL AND p_lpn_id <> NVL(p_transfer_lpn_id,-9999)) THEN
5822: v_lpn.lpn_context := wms_container_pub.lpn_context_stores;
5823:

Line 5820: AND p_transaction_source_type_id= inv_globals.g_sourcetype_moveorder

5816: RAISE fnd_api.g_exc_error;
5817: END IF;
5818: --13884722
5819: ELSIF(p_transaction_action_id = inv_globals.g_action_issue
5820: AND p_transaction_source_type_id= inv_globals.g_sourcetype_moveorder
5821: AND p_lpn_id IS NOT NULL AND p_lpn_id <> NVL(p_transfer_lpn_id,-9999)) THEN
5822: v_lpn.lpn_context := wms_container_pub.lpn_context_stores;
5823:
5824: IF (l_debug = 1) THEN

Line 5862: IF (p_transaction_action_id = inv_globals.g_action_intransitshipment) THEN

5858: END IF;
5859:
5860: -- For an Intransit Shipment, update the LPN with the shipmentNumber
5861: -- so that this LPN can be tracked during the corresponding receipt
5862: IF (p_transaction_action_id = inv_globals.g_action_intransitshipment) THEN
5863: v_lpn.source_name := p_shipment_number;
5864: END IF;
5865:
5866: inv_log_util.TRACE('** 3361969 setting lpn org id to : ' || p_organization_id, 'INV_LPN_TRX_PUB', 9);

Line 5877: p_transaction_action_id = inv_globals.g_action_issue

5873: IF (l_debug = 1) THEN
5874: inv_log_util.TRACE('*** Issued out LPN :' || p_content_lpn_id, 'INV_LPN_TRX_PUB', 9);
5875: END IF;
5876: ELSIF(
5877: p_transaction_action_id = inv_globals.g_action_issue
5878: AND(
5879: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5880: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5881: )

Line 5879: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

5875: END IF;
5876: ELSIF(
5877: p_transaction_action_id = inv_globals.g_action_issue
5878: AND(
5879: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5880: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5881: )
5882: ) THEN
5883: -- Return or corrections. Need to retrieve interface_transaction_id and transaction_type

Line 5880: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma

5876: ELSIF(
5877: p_transaction_action_id = inv_globals.g_action_issue
5878: AND(
5879: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
5880: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
5881: )
5882: ) THEN
5883: -- Return or corrections. Need to retrieve interface_transaction_id and transaction_type
5884: BEGIN

Line 6147: AND p_transaction_action_id = inv_globals.g_action_issue

6143: );
6144: END IF;
6145: --Added code to handle issue for bug 12714013
6146: ELSIF (p_transfer_lpn_id = p_lpn_id
6147: AND p_transaction_action_id = inv_globals.g_action_issue
6148: AND p_transaction_source_type_id= inv_globals.G_SOURCETYPE_MOVEORDER) THEN
6149: IF (l_debug = 1) THEN
6150: inv_log_util.TRACE('** p_lpn_id = p_transfer_lpn_id *** :' , 'INV_LPN_TRX_PUB', 9);
6151: inv_log_util.TRACE('** Updating lpn to issued out :' || p_lpn_id, 'INV_LPN_TRX_PUB', 9);

Line 6148: AND p_transaction_source_type_id= inv_globals.G_SOURCETYPE_MOVEORDER) THEN

6144: END IF;
6145: --Added code to handle issue for bug 12714013
6146: ELSIF (p_transfer_lpn_id = p_lpn_id
6147: AND p_transaction_action_id = inv_globals.g_action_issue
6148: AND p_transaction_source_type_id= inv_globals.G_SOURCETYPE_MOVEORDER) THEN
6149: IF (l_debug = 1) THEN
6150: inv_log_util.TRACE('** p_lpn_id = p_transfer_lpn_id *** :' , 'INV_LPN_TRX_PUB', 9);
6151: inv_log_util.TRACE('** Updating lpn to issued out :' || p_lpn_id, 'INV_LPN_TRX_PUB', 9);
6152: END IF;

Line 6235: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)

6231: --12714013 End
6232:
6233: END IF;
6234: /***** RECEIPT/LotSplit/LotMerge/Cycle/PhysicalCount/IntransitRcpt trx ****/
6235: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
6236: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
6237: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
6238: AND(l_primary_quantity > 0))
6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)

Line 6236: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)

6232:
6233: END IF;
6234: /***** RECEIPT/LotSplit/LotMerge/Cycle/PhysicalCount/IntransitRcpt trx ****/
6235: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
6236: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
6237: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
6238: AND(l_primary_quantity > 0))
6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)

Line 6237: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)

6233: END IF;
6234: /***** RECEIPT/LotSplit/LotMerge/Cycle/PhysicalCount/IntransitRcpt trx ****/
6235: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
6236: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
6237: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
6238: AND(l_primary_quantity > 0))
6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
6241: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)

Line 6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)

6235: ELSIF (p_transaction_action_id = inv_globals.g_action_receipt)
6236: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
6237: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
6238: AND(l_primary_quantity > 0))
6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
6241: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
6242: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
6243: AND l_primary_quantity > 0)

Line 6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)

6236: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_split)
6237: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
6238: AND(l_primary_quantity > 0))
6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
6241: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
6242: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
6243: AND l_primary_quantity > 0)
6244: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)

Line 6241: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)

6237: OR((p_transaction_action_id = inv_globals.g_action_inv_lot_translate)
6238: AND(l_primary_quantity > 0))
6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
6241: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
6242: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
6243: AND l_primary_quantity > 0)
6244: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
6245: AND l_primary_quantity > 0)

Line 6242: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)

6238: AND(l_primary_quantity > 0))
6239: OR(p_transaction_action_id = inv_globals.g_action_inv_lot_merge)
6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
6241: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
6242: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
6243: AND l_primary_quantity > 0)
6244: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
6245: AND l_primary_quantity > 0)
6246: OR(p_transaction_action_id = inv_globals.g_action_logicalreceipt)

Line 6244: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)

6240: OR(p_transaction_action_id = inv_globals.g_action_intransitreceipt)
6241: OR(p_transaction_action_id = inv_globals.g_action_assycomplete)
6242: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
6243: AND l_primary_quantity > 0)
6244: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
6245: AND l_primary_quantity > 0)
6246: OR(p_transaction_action_id = inv_globals.g_action_logicalreceipt)
6247: -- IDS: Logical Transactions for lot serial support
6248: -- IDS: Logical Transactions for lot and serials - Opened up TM to

Line 6246: OR(p_transaction_action_id = inv_globals.g_action_logicalreceipt)

6242: OR((p_transaction_action_id = inv_globals.g_action_cyclecountadj)
6243: AND l_primary_quantity > 0)
6244: OR((p_transaction_action_id = inv_globals.g_action_physicalcountadj)
6245: AND l_primary_quantity > 0)
6246: OR(p_transaction_action_id = inv_globals.g_action_logicalreceipt)
6247: -- IDS: Logical Transactions for lot serial support
6248: -- IDS: Logical Transactions for lot and serials - Opened up TM to
6249: -- handle logical receipts and logical corrections.
6250: THEN

Line 6255: IF(p_transaction_action_id = inv_globals.g_action_assycomplete

6251: IF (l_debug = 1) THEN
6252: inv_log_util.TRACE(' Action = Receipt', 'INV_LPN_TRX_PUB', 9);
6253: END IF;
6254: --BUG13656377 begin
6255: IF(p_transaction_action_id = inv_globals.g_action_assycomplete
6256: AND p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP
6257: AND (p_content_lpn_id IS NOT NULL OR p_lpn_id = p_transfer_lpn_id))THEN
6258:
6259: IF (l_debug = 1) THEN

Line 6256: AND p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP

6252: inv_log_util.TRACE(' Action = Receipt', 'INV_LPN_TRX_PUB', 9);
6253: END IF;
6254: --BUG13656377 begin
6255: IF(p_transaction_action_id = inv_globals.g_action_assycomplete
6256: AND p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP
6257: AND (p_content_lpn_id IS NOT NULL OR p_lpn_id = p_transfer_lpn_id))THEN
6258:
6259: IF (l_debug = 1) THEN
6260: inv_log_util.TRACE('It is WIP LPN completion and content LPN is not null or txfer LPN equals LPN id', 'INV_LPN_TRX_PUB', 9);

Line 6271: p_transaction_action_id = inv_globals.g_action_receipt

6267: END IF;
6268: --BUG13656377 end
6269: -- Check if a receipt with PO or RMA source types check to see if it is a correction
6270: IF (
6271: p_transaction_action_id = inv_globals.g_action_receipt
6272: AND(
6273: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6274: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6275: )

Line 6273: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

6269: -- Check if a receipt with PO or RMA source types check to see if it is a correction
6270: IF (
6271: p_transaction_action_id = inv_globals.g_action_receipt
6272: AND(
6273: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6274: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6275: )
6276: )
6277: OR(

Line 6274: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma

6270: IF (
6271: p_transaction_action_id = inv_globals.g_action_receipt
6272: AND(
6273: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6274: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6275: )
6276: )
6277: OR(
6278: p_transaction_action_id = inv_globals.g_action_logicalreceipt

Line 6278: p_transaction_action_id = inv_globals.g_action_logicalreceipt

6274: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6275: )
6276: )
6277: OR(
6278: p_transaction_action_id = inv_globals.g_action_logicalreceipt
6279: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6280: )
6281: -- IDS:Logical Transaction lot serial support
6282: -- IDS: Logical Transactions for lot and serials - Opened up TM to

Line 6279: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

6275: )
6276: )
6277: OR(
6278: p_transaction_action_id = inv_globals.g_action_logicalreceipt
6279: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6280: )
6281: -- IDS:Logical Transaction lot serial support
6282: -- IDS: Logical Transactions for lot and serials - Opened up TM to
6283: -- handle logical receipts and logical corrections.

Line 6305: p_transaction_action_id = inv_globals.g_action_receipt

6301: -- otherwise use default behavior
6302: IF (
6303: (
6304: (
6305: p_transaction_action_id = inv_globals.g_action_receipt
6306: AND(
6307: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6308: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6309: )

Line 6307: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

6303: (
6304: (
6305: p_transaction_action_id = inv_globals.g_action_receipt
6306: AND(
6307: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6308: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6309: )
6310: )
6311: OR(

Line 6308: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma

6304: (
6305: p_transaction_action_id = inv_globals.g_action_receipt
6306: AND(
6307: p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6308: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6309: )
6310: )
6311: OR(
6312: p_transaction_action_id = inv_globals.g_action_logicalreceipt

Line 6312: p_transaction_action_id = inv_globals.g_action_logicalreceipt

6308: OR p_transaction_source_type_id = inv_globals.g_sourcetype_rma
6309: )
6310: )
6311: OR(
6312: p_transaction_action_id = inv_globals.g_action_logicalreceipt
6313: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6314: )
6315: )
6316: -- IDS: Logical Transactions for lot and serials - Opened up TM to

Line 6313: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder

6309: )
6310: )
6311: OR(
6312: p_transaction_action_id = inv_globals.g_action_logicalreceipt
6313: AND p_transaction_source_type_id = inv_globals.g_sourcetype_purchaseorder
6314: )
6315: )
6316: -- IDS: Logical Transactions for lot and serials - Opened up TM to
6317: -- handle logical receipts and logical corrections.

Line 6452: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt AND

6448: IF (l_debug = 1) THEN
6449: inv_log_util.TRACE('p_action is:'||p_transaction_action_id ,'INV_LPN_TRX_PUB', 9);
6450: inv_log_util.TRACE('p_sr_Code is:'||p_serial_control_code ,'INV_LPN_TRX_PUB', 9);
6451: END IF;
6452: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt AND
6453: p_serial_control_code = 6 ) THEN
6454: UPDATE wms_lpn_contents
6455: SET serial_summary_entry = 2
6456: WHERE parent_lpn_id = p_lpn_id

Line 6473: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt) THEN

6469: records with the serial_summary_entry as 2. */
6470:
6471: -- If this item is Serial controlled, set cost_group_id for Serials
6472: --bug# 9651496,9764650
6473: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt) THEN
6474: UPDATE mtl_serial_numbers
6475: SET cost_group_id = p_cost_group_id
6476: WHERE inventory_item_id = p_inventory_item_id
6477: AND lpn_id = p_lpn_id

Line 6569: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)

6565: END IF;
6566: END IF;
6567: END IF;
6568: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
6569: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
6570: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
6571: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
6572: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
6573: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN

Line 6570: OR(p_transaction_action_id = inv_globals.g_action_planxfr)

6566: END IF;
6567: END IF;
6568: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
6569: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
6570: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
6571: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
6572: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
6573: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
6574: IF (l_debug = 1) THEN

Line 6571: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)

6567: END IF;
6568: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
6569: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
6570: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
6571: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
6572: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
6573: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
6574: IF (l_debug = 1) THEN
6575: inv_log_util.TRACE(' Action = SubXfr/OrgXfr/StgXfr/CGXfr', 'INV_LPN_TRX_PUB', 9);

Line 6572: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)

6568: /***** Actions for SUBXFR / ORGXFR / STGXFR transactions ****/
6569: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
6570: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
6571: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
6572: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
6573: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
6574: IF (l_debug = 1) THEN
6575: inv_log_util.TRACE(' Action = SubXfr/OrgXfr/StgXfr/CGXfr', 'INV_LPN_TRX_PUB', 9);
6576: END IF;

Line 6573: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN

6569: ELSIF (p_transaction_action_id = inv_globals.g_action_subxfr)
6570: OR(p_transaction_action_id = inv_globals.g_action_planxfr)
6571: OR(p_transaction_action_id = inv_globals.g_action_orgxfr)
6572: OR(p_transaction_action_id = inv_globals.g_action_stgxfr)
6573: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
6574: IF (l_debug = 1) THEN
6575: inv_log_util.TRACE(' Action = SubXfr/OrgXfr/StgXfr/CGXfr', 'INV_LPN_TRX_PUB', 9);
6576: END IF;
6577:

Line 6580: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN

6576: END IF;
6577:
6578: -- sanity check. If CostGroupXfr, then both cost_group_id and
6579: -- xfr_cost_group_id should be filled
6580: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
6581: IF (p_cost_group_id IS NULL)
6582: OR(p_transfer_cost_group_id IS NULL) THEN
6583: x_proc_msg := 'Error. Cost Groups not specified. CG=' || p_cost_group_id || ',XfrCG=' || p_transfer_cost_group_id;
6584:

Line 6597: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR

6593: END IF;
6594: END IF;
6595:
6596: -- If transaction is subtransfer
6597: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
6598: p_transaction_action_id = inv_globals.g_action_planxfr )
6599: THEN
6600: IF(p_transfer_lpn_id IS NOT NULL AND p_lpn_id IS NOT NULL) THEN
6601: IF ( v_lpn_ctx IS NULL ) THEN

Line 6598: p_transaction_action_id = inv_globals.g_action_planxfr )

6594: END IF;
6595:
6596: -- If transaction is subtransfer
6597: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
6598: p_transaction_action_id = inv_globals.g_action_planxfr )
6599: THEN
6600: IF(p_transfer_lpn_id IS NOT NULL AND p_lpn_id IS NOT NULL) THEN
6601: IF ( v_lpn_ctx IS NULL ) THEN
6602: SELECT lpn_context

Line 6639: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN

6635: -- this LPN, but only if not packing back to the same LPN,
6636: -- unless this is a CostGroup Transfer transaction
6637: IF (p_lpn_id IS NOT NULL)
6638: AND((p_lpn_id <> NVL(p_transfer_lpn_id, 0))
6639: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN
6640: -- Verify that the context of this LPN is 'Resides in Inventory'
6641: SELECT lpn_context, subinventory_code, locator_id /*14189803 Fetching LPN Sub/Loc */
6642: INTO v_lpn_ctx, l_wlpn_sub, l_wlpn_loc_id
6643: FROM wms_license_plate_numbers

Line 6654: AND p_transaction_action_id IN (inv_globals.g_action_stgxfr,inv_globals.g_action_subxfr)) THEN -- 12736705

6650: inv_log_util.TRACE('p_locator_id: '||p_locator_id, 'INV_LPN_TRX_PUB', 1);
6651: END IF;
6652: --14189803
6653: IF (v_lpn_ctx = wms_container_pub.lpn_context_packing
6654: AND p_transaction_action_id IN (inv_globals.g_action_stgxfr,inv_globals.g_action_subxfr)) THEN -- 12736705
6655:
6656: IF (l_debug = 1) THEN
6657: inv_log_util.TRACE('LPN Packing context and transaction is staging xfer/sub xfer:' || v_lpn_ctx, 'INV_LPN_TRX_PUB', 1);
6658: END IF;

Line 6700: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN

6696: , p_source_trx_id => p_source_transaction_id
6697: );
6698:
6699: --bug2747049
6700: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
6701: UPDATE wms_license_plate_numbers
6702: SET lpn_context = v_lpn_ctx
6703: , subinventory_code = p_subinventory_code
6704: , locator_id = p_locator_id

Line 6710: IF (p_transaction_action_id = inv_globals.g_action_orgxfr) THEN

6706: AND lpn_context = wms_container_pub.lpn_context_pregenerated;
6707: END IF;
6708: END IF;
6709:
6710: IF (p_transaction_action_id = inv_globals.g_action_orgxfr) THEN
6711: v_xfr_org := p_transfer_organization;
6712: ELSE
6713: v_xfr_org := p_organization_id;
6714: END IF;

Line 6716: IF (p_transaction_action_id <> inv_globals.g_action_costgroupxfr) THEN

6712: ELSE
6713: v_xfr_org := p_organization_id;
6714: END IF;
6715:
6716: IF (p_transaction_action_id <> inv_globals.g_action_costgroupxfr) THEN
6717: -- Check transfer org to see if it is wms enabled
6718: IF (
6719: wms_install.check_install(x_return_status => ret_status, x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata
6720: , p_organization_id => v_xfr_org)

Line 6771: IF (p_transaction_action_id = inv_globals.g_action_subxfr

6767: WHERE lpn_id = p_lpn_id;
6768:
6769: -- For Sub transfers reservations should be transfered
6770: -- for content lpn of who's context is not picked
6771: IF (p_transaction_action_id = inv_globals.g_action_subxfr
6772: AND(l_lpn_ctx_tmp <> wms_container_pub.lpn_context_picked
6773: AND ((NVL(l_system_task_type, -1) <> 7) AND (NVL(l_system_task_type, -1) <> 5))) -- Added for Bug 14741165
6774: AND l_reservation_id IS NULL --9869993
6775: ) THEN

Line 6855: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt AND p_serial_control_code = 6 ) THEN

6851: WHERE lpn_id = p_content_lpn_id;
6852:
6853:
6854: -- Bug 6733277 :Update WLC's serial_summary entry to 2 is serial control is 6 and transaction in intransit receipt
6855: IF (p_transaction_action_id = inv_globals.g_action_intransitreceipt AND p_serial_control_code = 6 ) THEN
6856: UPDATE wms_lpn_contents
6857: SET serial_summary_entry = 2
6858: WHERE parent_lpn_id = p_content_lpn_id
6859: AND organization_id = p_organization_id

Line 6867: p_transaction_action_id = inv_globals.g_action_subxfr

6863:
6864: -- For Sub transfers reservations should be transfered
6865: -- for content lpn of who's context is not picked
6866: IF (
6867: p_transaction_action_id = inv_globals.g_action_subxfr
6868: AND(v_cnt_lpn_ctx <> wms_container_pub.lpn_context_picked
6869: AND NVL(l_system_task_type, -1) <> 7)
6870: AND l_reservation_id IS NULL --9869993
6871: ) -- bug 2879208 added nv for 3240617

Line 6880: IF(p_transaction_source_type_id=inv_globals.G_SOURCETYPE_CYCLECOUNT) THEN

6876:
6877: /*Added for Bug#6043776*/
6878: l_cyclpn_id:=p_content_lpn_id;
6879: /*if the transaction is cyclecount use outer LPN to update reservations*/
6880: IF(p_transaction_source_type_id=inv_globals.G_SOURCETYPE_CYCLECOUNT) THEN
6881: IF (l_debug = 1) THEN
6882: inv_log_util.TRACE('entered here cyclecount.. ','INV_LPN_TRX_PUB', 9);
6883: END IF;
6884: SELECT OUTERMOST_LPN_ID into l_cyclpn_id

Line 6973: IF ( p_transaction_source_type_id = inv_globals.G_SOURCETYPE_INTORDER AND

6969: ELSE
6970: --Bug 5509764
6971: --For direct org transfer against an internal req, set the lpn_context
6972: --to "In Inventory" from Picked to reflect the correct status
6973: IF ( p_transaction_source_type_id = inv_globals.G_SOURCETYPE_INTORDER AND
6974: p_transaction_action_id IN (inv_globals.G_ACTION_ORGXFR,inv_globals.G_ACTION_SUBXFR) --8395505.Added SUBXFR
6975: ) THEN
6976: IF (l_debug = 1) THEN
6977: inv_log_util.trace('int req direct org/sub xfr. setting lpn_ctxt to in inventory','INV_LPN_TRX_PUB',1);

Line 6974: p_transaction_action_id IN (inv_globals.G_ACTION_ORGXFR,inv_globals.G_ACTION_SUBXFR) --8395505.Added SUBXFR

6970: --Bug 5509764
6971: --For direct org transfer against an internal req, set the lpn_context
6972: --to "In Inventory" from Picked to reflect the correct status
6973: IF ( p_transaction_source_type_id = inv_globals.G_SOURCETYPE_INTORDER AND
6974: p_transaction_action_id IN (inv_globals.G_ACTION_ORGXFR,inv_globals.G_ACTION_SUBXFR) --8395505.Added SUBXFR
6975: ) THEN
6976: IF (l_debug = 1) THEN
6977: inv_log_util.trace('int req direct org/sub xfr. setting lpn_ctxt to in inventory','INV_LPN_TRX_PUB',1);
6978: END IF;

Line 6991: IF ( p_transaction_action_id = inv_globals.G_ACTION_STGXFR ) THEN

6987: END IF;
6988:
6989: -- Bug 4247497 Moving update of context to TM. If this is a stagexfr transaction
6990: -- then lpn-context should be updated to 'picked'
6991: IF ( p_transaction_action_id = inv_globals.G_ACTION_STGXFR ) THEN
6992: v_lpn.lpn_context := wms_container_pub.LPN_CONTEXT_PICKED;
6993: END IF;
6994:
6995: /** moved update here to fix bug3299521, this way we would avoid updating

Line 7005: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN

7001: -- this LPN, but only if not unpacked from the same LPN,
7002: -- unless this is a CostGroup Transfer transaction
7003: IF (p_transfer_lpn_id IS NOT NULL)
7004: AND((NVL(p_lpn_id, 0) <> p_transfer_lpn_id)
7005: OR(p_transaction_action_id = inv_globals.g_action_costgroupxfr)) THEN
7006: SELECT lpn_context
7007: INTO v_xfrlpn_ctx
7008: FROM wms_license_plate_numbers
7009: WHERE lpn_id = p_transfer_lpn_id;

Line 7039: IF ( p_transaction_action_id = inv_globals.g_action_stgxfr ) THEN

7035: , 9);
7036: END IF;
7037: ELSE
7038: -- Bug 4247497 Moving update of context to TM
7039: IF ( p_transaction_action_id = inv_globals.g_action_stgxfr ) THEN
7040: v_lpn.lpn_context := wms_container_pub.lpn_context_picked;
7041: ELSE
7042: v_lpn.lpn_context := wms_container_pub.lpn_context_inv;
7043: END IF;

Line 7078: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN

7074: END IF;
7075: -- For CostGroupTransfer transactions, use the xfr_cost_group_id
7076: -- column from MMTT. For all other transactions, use the cost_group_id
7077: -- For CostGrpTrx, sub and location are same as that of source side.
7078: IF (p_transaction_action_id = inv_globals.g_action_costgroupxfr) THEN
7079: l_xfr_sub := p_subinventory_code;
7080: l_xfr_loc := p_locator_id;
7081: ELSE
7082: l_xfr_sub := p_transfer_subinventory;

Line 7087: IF ( p_transaction_action_id = inv_globals.g_action_subxfr

7083: l_xfr_loc := p_transfer_to_location;
7084: END IF;
7085:
7086: /*We should do transfer reservation only for subxfer actions*/
7087: IF ( p_transaction_action_id = inv_globals.g_action_subxfr
7088: AND l_reservation_id IS NULL --9869993
7089: AND NOT(v_xfrlpn_ctx = wms_container_pub.lpn_context_picked --BUG13810580
7090: AND NVL(l_system_task_type, -1) <> 7
7091: AND p_lpn_id <> p_transfer_lpn_id)

Line 7185: IF /*(p_transaction_action_id = inv_globals.g_action_stgxfr

7181: END IF;
7182:
7183: -- For cases of bulk picking the lpn_id and xfr_lpn_id will be same
7184: -- need to change the sub and locator information to the xfer location
7185: IF /*(p_transaction_action_id = inv_globals.g_action_stgxfr
7186: AND Removing this Condition for Bug#12595055*/
7187: (p_lpn_id = p_transfer_lpn_id) THEN
7188: SELECT lpn_context
7189: INTO v_xfrlpn_ctx

Line 7200: IF (p_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder)

7196: END IF;
7197:
7198: -- If the lpn is transfered update the status of that LPN
7199: -- provided the context is 2, 3, or 8
7200: IF (p_transaction_source_type_id <> inv_globals.g_sourcetype_salesorder)
7201: AND(
7202: (v_xfrlpn_ctx = wms_container_pub.lpn_context_wip)
7203: OR(v_xfrlpn_ctx = wms_container_pub.lpn_context_rcv)
7204: OR(v_xfrlpn_ctx = wms_container_pub.lpn_context_packing)

Line 7209: IF (p_transaction_action_id = inv_globals.g_action_stgxfr) THEN --15851366 start

7205: OR(v_xfrlpn_ctx = wms_container_pub.lpn_context_pregenerated)
7206: ) THEN
7207: v_lpn.lpn_context := wms_container_pub.lpn_context_inv;
7208: ELSE
7209: IF (p_transaction_action_id = inv_globals.g_action_stgxfr) THEN --15851366 start
7210:
7211: -- bug 5620764
7212: -- For staging transfer transactions change context to picked
7213: v_lpn.lpn_context := wms_container_pub.lpn_context_picked;

Line 7286: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR

7282: --12595055 END
7283: END IF;
7284:
7285: -- If transaction is subtransfer
7286: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
7287: p_transaction_action_id = inv_globals.g_action_planxfr )
7288: THEN
7289: IF (p_content_lpn_id IS NOT NULL) THEN
7290: SELECT lpn_context

Line 7287: p_transaction_action_id = inv_globals.g_action_planxfr )

7283: END IF;
7284:
7285: -- If transaction is subtransfer
7286: IF ( p_transaction_action_id = inv_globals.g_action_subxfr OR
7287: p_transaction_action_id = inv_globals.g_action_planxfr )
7288: THEN
7289: IF (p_content_lpn_id IS NOT NULL) THEN
7290: SELECT lpn_context
7291: INTO v_cnt_lpn_ctx

Line 7329: ELSIF(p_transaction_action_id = inv_globals.g_action_containerpack) THEN

7325: END IF;
7326: END IF;
7327: END IF;
7328: /***** Actions for PACK transactions ****/
7329: ELSIF(p_transaction_action_id = inv_globals.g_action_containerpack) THEN
7330: IF (l_debug = 1) THEN
7331: inv_log_util.TRACE(' Action = Pack', 'INV_LPN_TRX_PUB', 9);
7332: END IF;
7333:

Line 7366: ELSIF(p_transaction_action_id = inv_globals.g_action_containerunpack) THEN

7362: SET lpn_context = wms_container_pub.lpn_context_inv
7363: WHERE lpn_id = p_transfer_lpn_id
7364: AND lpn_context <> wms_container_pub.lpn_context_picked;
7365: /***** Actions for UNPACK transactions ****/
7366: ELSIF(p_transaction_action_id = inv_globals.g_action_containerunpack) THEN
7367: IF (l_debug = 1) THEN
7368: inv_log_util.TRACE(' Action = UnPack', 'INV_LPN_TRX_PUB', 9);
7369: END IF;
7370:

Line 7396: ELSIF(p_transaction_action_id = inv_globals.g_action_containersplit) THEN

7392: );
7393: -- If LPN is item-tracked, then need to change container status. TODO
7394:
7395: /***** Actions for SLPIT transactions ****/
7396: ELSIF(p_transaction_action_id = inv_globals.g_action_containersplit) THEN
7397: IF (l_debug = 1) THEN
7398: inv_log_util.TRACE(' Action = Split, First Unpack', 'INV_LPN_TRX_PUB', 9);
7399: END IF;
7400:

Line 7613: ELSIF ( p_transaction_action_id = inv_globals.G_ACTION_ASSYRETURN AND

7609: , p_source_trx_id => p_source_transaction_id
7610: );
7611:
7612: /* 8579396 :start */
7613: ELSIF ( p_transaction_action_id = inv_globals.G_ACTION_ASSYRETURN AND
7614: p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP AND
7615: NVL(p_lpn_id,-1) > 0
7616: ) THEN
7617: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN

Line 7614: p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP AND

7610: );
7611:
7612: /* 8579396 :start */
7613: ELSIF ( p_transaction_action_id = inv_globals.G_ACTION_ASSYRETURN AND
7614: p_transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP AND
7615: NVL(p_lpn_id,-1) > 0
7616: ) THEN
7617: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN
7618: IF ( NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y') THEN --We will do this only for OPM

Line 7659: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND

7655: -- If Sales Order Issue or Int.Order Issue/SubXfr/Intransit Shipment
7656: -- need to popluate the content_lpn in MMTT with the outermost lpn
7657: -- for shipping
7658: /*if p_content_lpn_id is not NULL AND
7659: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
7660: p_transaction_action_id = inv_globals.G_Action_Issue) OR
7661: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR
7663: p_transaction_action_id =

Line 7660: p_transaction_action_id = inv_globals.G_Action_Issue) OR

7656: -- need to popluate the content_lpn in MMTT with the outermost lpn
7657: -- for shipping
7658: /*if p_content_lpn_id is not NULL AND
7659: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
7660: p_transaction_action_id = inv_globals.G_Action_Issue) OR
7661: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR
7663: p_transaction_action_id =
7664: inv_globals.G_Action_Subxfr OR

Line 7661: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND

7657: -- for shipping
7658: /*if p_content_lpn_id is not NULL AND
7659: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
7660: p_transaction_action_id = inv_globals.G_Action_Issue) OR
7661: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR
7663: p_transaction_action_id =
7664: inv_globals.G_Action_Subxfr OR
7665: p_transaction_action_id = inv_globals.G_Action_Planxfr OR

Line 7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR

7658: /*if p_content_lpn_id is not NULL AND
7659: ((p_transaction_source_type_id = inv_globals.G_SourceType_SalesOrder AND
7660: p_transaction_action_id = inv_globals.G_Action_Issue) OR
7661: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR
7663: p_transaction_action_id =
7664: inv_globals.G_Action_Subxfr OR
7665: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
7666: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR

Line 7664: inv_globals.G_Action_Subxfr OR

7660: p_transaction_action_id = inv_globals.G_Action_Issue) OR
7661: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR
7663: p_transaction_action_id =
7664: inv_globals.G_Action_Subxfr OR
7665: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
7666: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
7667: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
7668: BEGIN

Line 7665: p_transaction_action_id = inv_globals.G_Action_Planxfr OR

7661: (p_transaction_source_type_id = inv_globals.G_SourceType_IntOrder AND
7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR
7663: p_transaction_action_id =
7664: inv_globals.G_Action_Subxfr OR
7665: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
7666: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
7667: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
7668: BEGIN
7669: UPDATE mtl_material_transactions_temp

Line 7666: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR

7662: (p_transaction_action_id = inv_globals.G_Action_Issue OR
7663: p_transaction_action_id =
7664: inv_globals.G_Action_Subxfr OR
7665: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
7666: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
7667: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
7668: BEGIN
7669: UPDATE mtl_material_transactions_temp
7670: SET content_lpn_id = (SELECT outermost_lpn_id

Line 7667: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then

7663: p_transaction_action_id =
7664: inv_globals.G_Action_Subxfr OR
7665: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
7666: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
7667: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
7668: BEGIN
7669: UPDATE mtl_material_transactions_temp
7670: SET content_lpn_id = (SELECT outermost_lpn_id
7671: FROM wms_license_plate_numbers