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_TXN_MANAGER_GRP dependencies on INV_GLOBALS

Line 1394: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR

1390: END IF;
1391: END IF;
1392: /* Bug 3273172,moved the below code here
1393: for Account, Account Alias source is populated first before getting the account */
1394: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1395: l_srctype = INV_Globals.G_SourceType_Account OR
1396: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1397: l_srctype = INV_Globals.G_SourceType_IntOrder)
1398: AND (l_trxsrc is NULL) ) THEN

Line 1395: l_srctype = INV_Globals.G_SourceType_Account OR

1391: END IF;
1392: /* Bug 3273172,moved the below code here
1393: for Account, Account Alias source is populated first before getting the account */
1394: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1395: l_srctype = INV_Globals.G_SourceType_Account OR
1396: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1397: l_srctype = INV_Globals.G_SourceType_IntOrder)
1398: AND (l_trxsrc is NULL) ) THEN
1399: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN

Line 1396: l_srctype = INV_Globals.G_SourceType_AccountAlias OR

1392: /* Bug 3273172,moved the below code here
1393: for Account, Account Alias source is populated first before getting the account */
1394: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1395: l_srctype = INV_Globals.G_SourceType_Account OR
1396: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1397: l_srctype = INV_Globals.G_SourceType_IntOrder)
1398: AND (l_trxsrc is NULL) ) THEN
1399: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1400: l_error_exp := FND_MESSAGE.get;

Line 1397: l_srctype = INV_Globals.G_SourceType_IntOrder)

1393: for Account, Account Alias source is populated first before getting the account */
1394: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1395: l_srctype = INV_Globals.G_SourceType_Account OR
1396: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1397: l_srctype = INV_Globals.G_SourceType_IntOrder)
1398: AND (l_trxsrc is NULL) ) THEN
1399: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1400: l_error_exp := FND_MESSAGE.get;
1401:

Line 1444: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR

1440: END IF;
1441:
1442: /* Bug 2971400 populating transaction source id */
1443: /* Bug 3273172,Moving the below code to above
1444: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1445: l_srctype = INV_Globals.G_SourceType_Account OR
1446: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1447: l_srctype = INV_Globals.G_SourceType_IntOrder)
1448: AND (l_trxsrc is NULL) ) THEN

Line 1445: l_srctype = INV_Globals.G_SourceType_Account OR

1441:
1442: /* Bug 2971400 populating transaction source id */
1443: /* Bug 3273172,Moving the below code to above
1444: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1445: l_srctype = INV_Globals.G_SourceType_Account OR
1446: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1447: l_srctype = INV_Globals.G_SourceType_IntOrder)
1448: AND (l_trxsrc is NULL) ) THEN
1449: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN

Line 1446: l_srctype = INV_Globals.G_SourceType_AccountAlias OR

1442: /* Bug 2971400 populating transaction source id */
1443: /* Bug 3273172,Moving the below code to above
1444: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1445: l_srctype = INV_Globals.G_SourceType_Account OR
1446: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1447: l_srctype = INV_Globals.G_SourceType_IntOrder)
1448: AND (l_trxsrc is NULL) ) THEN
1449: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1450: l_error_exp := FND_MESSAGE.get;

Line 1447: l_srctype = INV_Globals.G_SourceType_IntOrder)

1443: /* Bug 3273172,Moving the below code to above
1444: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1445: l_srctype = INV_Globals.G_SourceType_Account OR
1446: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1447: l_srctype = INV_Globals.G_SourceType_IntOrder)
1448: AND (l_trxsrc is NULL) ) THEN
1449: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1450: l_error_exp := FND_MESSAGE.get;
1451:

Line 2095: /* commented logical validations fr inv_globals pre-req*/

2091: | where not supplied
2092: +--------------------------------------------------------------------------*/
2093:
2094:
2095: /* commented logical validations fr inv_globals pre-req*/
2096: IF (l_validate_full) THEN --J-dev
2097: fnd_flex_key_api.set_session_mode('seed_data');
2098: derive_segment_ids(p_header_id, x_return_status ,x_msg_count, x_msg_data);
2099: END IF;

Line 2121: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory

2117: ERROR_CODE = substrb(l_error_code,1,240),
2118: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
2119: WHERE TRANSACTION_HEADER_ID = p_header_id
2120: AND process_flag = 1
2121: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2122: AND transaction_action_id IN
2123: (inv_globals.G_action_logicalissue,
2124: inv_globals.G_action_logicalicsales,
2125: inv_globals.G_action_logicalicreceipt,

Line 2123: (inv_globals.G_action_logicalissue,

2119: WHERE TRANSACTION_HEADER_ID = p_header_id
2120: AND process_flag = 1
2121: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2122: AND transaction_action_id IN
2123: (inv_globals.G_action_logicalissue,
2124: inv_globals.G_action_logicalicsales,
2125: inv_globals.G_action_logicalicreceipt,
2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,

Line 2124: inv_globals.G_action_logicalicsales,

2120: AND process_flag = 1
2121: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2122: AND transaction_action_id IN
2123: (inv_globals.G_action_logicalissue,
2124: inv_globals.G_action_logicalicsales,
2125: inv_globals.G_action_logicalicreceipt,
2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,
2128: inv_globals.G_action_logicalreceipt)) OR

Line 2125: inv_globals.G_action_logicalicreceipt,

2121: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2122: AND transaction_action_id IN
2123: (inv_globals.G_action_logicalissue,
2124: inv_globals.G_action_logicalicsales,
2125: inv_globals.G_action_logicalicreceipt,
2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,
2128: inv_globals.G_action_logicalreceipt)) OR
2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma

Line 2126: inv_globals.G_action_logicalicrcptreturn,

2122: AND transaction_action_id IN
2123: (inv_globals.G_action_logicalissue,
2124: inv_globals.G_action_logicalicsales,
2125: inv_globals.G_action_logicalicreceipt,
2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,
2128: inv_globals.G_action_logicalreceipt)) OR
2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)

Line 2127: inv_globals.G_action_logicalicsalesreturn,

2123: (inv_globals.G_action_logicalissue,
2124: inv_globals.G_action_logicalicsales,
2125: inv_globals.G_action_logicalicreceipt,
2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,
2128: inv_globals.G_action_logicalreceipt)) OR
2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2131: OR

Line 2128: inv_globals.G_action_logicalreceipt)) OR

2124: inv_globals.G_action_logicalicsales,
2125: inv_globals.G_action_logicalicreceipt,
2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,
2128: inv_globals.G_action_logicalreceipt)) OR
2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2131: OR
2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder

Line 2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma

2125: inv_globals.G_action_logicalicreceipt,
2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,
2128: inv_globals.G_action_logicalreceipt)) OR
2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2131: OR
2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2133: AND transaction_action_id in

Line 2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)

2126: inv_globals.G_action_logicalicrcptreturn,
2127: inv_globals.G_action_logicalicsalesreturn,
2128: inv_globals.G_action_logicalreceipt)) OR
2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2131: OR
2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2133: AND transaction_action_id in
2134: (inv_globals.G_action_logicalissue,

Line 2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder

2128: inv_globals.G_action_logicalreceipt)) OR
2129: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2131: OR
2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2133: AND transaction_action_id in
2134: (inv_globals.G_action_logicalissue,
2135: -- inv_globals.G_action_logicaldeladj,
2136: -- inv_globals.G_action_logicalreceipt,

Line 2134: (inv_globals.G_action_logicalissue,

2130: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2131: OR
2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2133: AND transaction_action_id in
2134: (inv_globals.G_action_logicalissue,
2135: -- inv_globals.G_action_logicaldeladj,
2136: -- inv_globals.G_action_logicalreceipt,
2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma

Line 2135: -- inv_globals.G_action_logicaldeladj,

2131: OR
2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2133: AND transaction_action_id in
2134: (inv_globals.G_action_logicalissue,
2135: -- inv_globals.G_action_logicaldeladj,
2136: -- inv_globals.G_action_logicalreceipt,
2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR

Line 2136: -- inv_globals.G_action_logicalreceipt,

2132: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2133: AND transaction_action_id in
2134: (inv_globals.G_action_logicalissue,
2135: -- inv_globals.G_action_logicaldeladj,
2136: -- inv_globals.G_action_logicalreceipt,
2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq

Line 2137: inv_globals.G_action_retropriceupdate)) OR

2133: AND transaction_action_id in
2134: (inv_globals.G_action_logicalissue,
2135: -- inv_globals.G_action_logicaldeladj,
2136: -- inv_globals.G_action_logicalreceipt,
2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR

Line 2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma

2134: (inv_globals.G_action_logicalissue,
2135: -- inv_globals.G_action_logicaldeladj,
2136: -- inv_globals.G_action_logicalreceipt,
2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2142: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder

Line 2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR

2135: -- inv_globals.G_action_logicaldeladj,
2136: -- inv_globals.G_action_logicalreceipt,
2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2142: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2143: and transaction_action_id = inv_globals.G_action_logicalissue)) ;

Line 2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq

2136: -- inv_globals.G_action_logicalreceipt,
2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2142: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2143: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2144: --J-dev for Drop Ship

Line 2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR

2137: inv_globals.G_action_retropriceupdate)) OR
2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2142: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2143: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2144: --J-dev for Drop Ship
2145:

Line 2142: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder

2138: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2142: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2143: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2144: --J-dev for Drop Ship
2145:
2146: /*------------------------------------------------------+

Line 2143: and transaction_action_id = inv_globals.G_action_logicalissue)) ;

2139: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2140: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2141: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2142: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2143: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2144: --J-dev for Drop Ship
2145:
2146: /*------------------------------------------------------+
2147: | Validate inventory item

Line 2847: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_AccountAlias

2843: ERROR_CODE = substrb(l_error_code,1,240),
2844: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
2845: WHERE TRANSACTION_HEADER_ID = p_header_id
2846: AND PROCESS_FLAG = 1
2847: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_AccountAlias
2848: AND NOT EXISTS (
2849: SELECT NULL
2850: FROM MTL_GENERIC_DISPOSITIONS MGD
2851: WHERE MGD.DISPOSITION_ID = MTI.TRANSACTION_SOURCE_ID

Line 3438: AND (TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SourceType_Inventory OR

3434: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
3435: WHERE TRANSACTION_HEADER_ID = p_header_id
3436: AND PROCESS_FLAG = 1
3437: AND DISTRIBUTION_ACCOUNT_ID IS NULL
3438: AND (TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SourceType_Inventory OR
3439: TRANSACTION_SOURCE_TYPE_ID >=100)
3440: AND NVL(OWNING_ORGANIZATION_ID,organization_id) = organization_id
3441: AND NVL(OWNING_TP_TYPE,2) = 2 -- if it is null we are considering it as normal item..
3442: -- Added the above two lines for the bug # 5896859

Line 3622: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_PrjContracts

3618: PROCESS_FLAG = 3,
3619: ERROR_CODE = substrb(l_error_code,1,240),
3620: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
3621: WHERE TRANSACTION_HEADER_ID = p_header_id
3622: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_PrjContracts
3623: AND NOT EXISTS (
3624: SELECT NULL
3625: FROM OKE_K_HEADERS_V OKHV
3626: WHERE MTI.TRANSACTION_SOURCE_ID = OKHV.K_HEADER_ID);

Line 4079: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR

4075: +-------------------------------------------------------------*/
4076:
4077:
4078:
4079: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
4080: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
4081: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
4082: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4083: SET LAST_UPDATE_DATE = SYSDATE,

Line 4080: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR

4076:
4077:
4078:
4079: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
4080: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
4081: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
4082: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4083: SET LAST_UPDATE_DATE = SYSDATE,
4084: LAST_UPDATED_BY = p_userid,

Line 4081: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN

4077:
4078:
4079: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
4080: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
4081: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
4082: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
4083: SET LAST_UPDATE_DATE = SYSDATE,
4084: LAST_UPDATED_BY = p_userid,
4085: LAST_UPDATE_LOGIN = p_loginid,

Line 4693: IF (p_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND

4689:
4690: -- INVCONV end fabdi
4691:
4692: -- R12 Genealogy Enhancement : Start
4693: IF (p_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND
4694: p_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN
4695: IF (p_serctrl = 2 OR p_serctrl = 5) -- Lot + serial Controlled
4696: THEN
4697: -- mrana:5443557: this is not needed anymore AND (p_is_wsm_enabled = 'N')) THEN

Line 4694: p_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN

4690: -- INVCONV end fabdi
4691:
4692: -- R12 Genealogy Enhancement : Start
4693: IF (p_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND
4694: p_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN
4695: IF (p_serctrl = 2 OR p_serctrl = 5) -- Lot + serial Controlled
4696: THEN
4697: -- mrana:5443557: this is not needed anymore AND (p_is_wsm_enabled = 'N')) THEN
4698: IF (l_debug = 1) THEN

Line 4873: p_srctype = INV_GLOBALS.G_SourceType_IntOrder AND p_acttype = 1)

4869: --serial tagging
4870: /*
4871: IF (p_serctrl = 2 OR p_serctrl = 5 OR (p_serctrl = 6 AND
4872: p_srctype = 2 AND p_acttype = 1) OR (p_serctrl = 6 AND
4873: p_srctype = INV_GLOBALS.G_SourceType_IntOrder AND p_acttype = 1)
4874: OR (p_serctrl = 6 AND p_srctype = 8)
4875: OR (P_serctrl = 6 AND p_srctype = 16 and p_acttype = 1)
4876: OR (P_serctrl = 6 AND (p_trx_typeid = 93 OR p_trx_typeid = 94) ))
4877: */

Line 6994: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR

6990: IF (l_acttype = 2) THEN
6991: l_xorgid := l_orgid;
6992: END IF;
6993:
6994: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6995: l_srctype = INV_Globals.G_SourceType_Account OR
6996: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6997: l_srctype = INV_Globals.G_SourceType_IntOrder)
6998: AND (l_trxsrc is NULL) ) THEN

Line 6995: l_srctype = INV_Globals.G_SourceType_Account OR

6991: l_xorgid := l_orgid;
6992: END IF;
6993:
6994: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6995: l_srctype = INV_Globals.G_SourceType_Account OR
6996: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6997: l_srctype = INV_Globals.G_SourceType_IntOrder)
6998: AND (l_trxsrc is NULL) ) THEN
6999: IF ( NOT getsrcid(l_trxsrc, l_srctype, l_orgid, l_rowid)) THEN

Line 6996: l_srctype = INV_Globals.G_SourceType_AccountAlias OR

6992: END IF;
6993:
6994: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6995: l_srctype = INV_Globals.G_SourceType_Account OR
6996: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6997: l_srctype = INV_Globals.G_SourceType_IntOrder)
6998: AND (l_trxsrc is NULL) ) THEN
6999: IF ( NOT getsrcid(l_trxsrc, l_srctype, l_orgid, l_rowid)) THEN
7000: FND_MESSAGE.set_name('INV', 'INV_INT_SRCSEGCODE');

Line 6997: l_srctype = INV_Globals.G_SourceType_IntOrder)

6993:
6994: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6995: l_srctype = INV_Globals.G_SourceType_Account OR
6996: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6997: l_srctype = INV_Globals.G_SourceType_IntOrder)
6998: AND (l_trxsrc is NULL) ) THEN
6999: IF ( NOT getsrcid(l_trxsrc, l_srctype, l_orgid, l_rowid)) THEN
7000: FND_MESSAGE.set_name('INV', 'INV_INT_SRCSEGCODE');
7001: l_error_code := FND_MESSAGE.get;

Line 7662: IF ( l_acttype = 24 AND ((l_srctype = INV_Globals.G_SourceType_Inventory) OR (l_srctype = 15)) AND ( l_avg_cost_update = 2 ) )

7658: /* Bug# 6271039, For average cost update and layer cost update, validate rows in
7659: * MTI for material account, material overhead account, resource account,
7660: * outside processing account, overhead account. */
7661:
7662: IF ( l_acttype = 24 AND ((l_srctype = INV_Globals.G_SourceType_Inventory) OR (l_srctype = 15)) AND ( l_avg_cost_update = 2 ) )
7663: THEN
7664:
7665: /*-----------------------------------------------------------+
7666: | Validate material account

Line 7909: IF ( l_acttype = 24 AND ((l_srctype = INV_Globals.G_SourceType_Inventory)

7905: /* for average cost update and layer cost update, validate rows in */
7906: /* mtl_txn_cost_det_interface table , if R10 avg cost profile is set */
7907:
7908:
7909: IF ( l_acttype = 24 AND ((l_srctype = INV_Globals.G_SourceType_Inventory)
7910: OR (l_srctype = 15)) ) THEN
7911: IF ( l_avg_cost_update = 2 ) THEN
7912:
7913: /* should we check also if interface id is not null and

Line 8011: INV_GLOBALS.G_ACTION_COSTUPDATE

8007: --Do not validate lot/serial quantity for lot split, merge and translate
8008: --The inv_lot_trx_validations_pub API would already have done it by the
8009: --time control comes here
8010: IF (l_validate_full AND l_acttype NOT IN (
8011: INV_GLOBALS.G_ACTION_COSTUPDATE
8012: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
8013: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
8014: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
8015: ) THEN

Line 8012: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT

8008: --The inv_lot_trx_validations_pub API would already have done it by the
8009: --time control comes here
8010: IF (l_validate_full AND l_acttype NOT IN (
8011: INV_GLOBALS.G_ACTION_COSTUPDATE
8012: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
8013: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
8014: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
8015: ) THEN
8016:

Line 8013: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE

8009: --time control comes here
8010: IF (l_validate_full AND l_acttype NOT IN (
8011: INV_GLOBALS.G_ACTION_COSTUPDATE
8012: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
8013: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
8014: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
8015: ) THEN
8016:
8017: --Serial Tagging

Line 8014: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)

8010: IF (l_validate_full AND l_acttype NOT IN (
8011: INV_GLOBALS.G_ACTION_COSTUPDATE
8012: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
8013: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
8014: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
8015: ) THEN
8016:
8017: --Serial Tagging
8018:

Line 8304: IF (l_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND l_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN

8300: END IF; --actions for serials.
8301: END IF;--if check actions for lots
8302:
8303: -- R12 Genealogy Enhancement : Start
8304: IF (l_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND l_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN
8305: IF ((l_lotctrl = 1 AND l_acttype <> 24) AND
8306: (l_lotctrl = 1 AND (l_serctrl = 2 OR l_serctrl = 5)) )
8307: THEN
8308: IF (l_debug = 1) THEN

Line 9106: (inv_globals.g_type_inv_lot_split

9102: FROM mtl_transactions_interface
9103: WHERE transaction_header_id = p_header_id
9104: AND process_flag = 1
9105: AND transaction_type_id NOT IN
9106: (inv_globals.g_type_inv_lot_split
9107: , inv_globals.g_type_inv_lot_merge
9108: , inv_globals.g_type_inv_lot_translate));
9109: EXCEPTION
9110: WHEN OTHERS THEN

Line 9107: , inv_globals.g_type_inv_lot_merge

9103: WHERE transaction_header_id = p_header_id
9104: AND process_flag = 1
9105: AND transaction_type_id NOT IN
9106: (inv_globals.g_type_inv_lot_split
9107: , inv_globals.g_type_inv_lot_merge
9108: , inv_globals.g_type_inv_lot_translate));
9109: EXCEPTION
9110: WHEN OTHERS THEN
9111: l_count := 0;

Line 9108: , inv_globals.g_type_inv_lot_translate));

9104: AND process_flag = 1
9105: AND transaction_type_id NOT IN
9106: (inv_globals.g_type_inv_lot_split
9107: , inv_globals.g_type_inv_lot_merge
9108: , inv_globals.g_type_inv_lot_translate));
9109: EXCEPTION
9110: WHEN OTHERS THEN
9111: l_count := 0;
9112: IF(l_debug = 1) THEN

Line 9471: (inv_globals.g_type_inv_lot_split

9467: --WHERE ROWID = p_rowid--J-dev
9468: WHERE transaction_header_id = p_header_id
9469: AND PROCESS_FLAG = 1
9470: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
9471: (inv_globals.g_type_inv_lot_split
9472: , inv_globals.g_type_inv_lot_merge
9473: , inv_globals.g_type_inv_lot_translate
9474: );
9475:

Line 9472: , inv_globals.g_type_inv_lot_merge

9468: WHERE transaction_header_id = p_header_id
9469: AND PROCESS_FLAG = 1
9470: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
9471: (inv_globals.g_type_inv_lot_split
9472: , inv_globals.g_type_inv_lot_merge
9473: , inv_globals.g_type_inv_lot_translate
9474: );
9475:
9476: ELSE

Line 9473: , inv_globals.g_type_inv_lot_translate

9469: AND PROCESS_FLAG = 1
9470: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
9471: (inv_globals.g_type_inv_lot_split
9472: , inv_globals.g_type_inv_lot_merge
9473: , inv_globals.g_type_inv_lot_translate
9474: );
9475:
9476: ELSE
9477: IF ( l_lt_flow_schedule <> 0 ) THEN

Line 10748: (inv_globals.g_type_inv_lot_split

10744: /*WHERE MTI.ROWID = p_rowid J-dev*/
10745: AND mti.TRANSACTION_INTERFACE_ID IS NOT NULL
10746: AND mti.PROCESS_FLAG = 1
10747: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
10748: (inv_globals.g_type_inv_lot_split
10749: , inv_globals.g_type_inv_lot_merge
10750: , inv_globals.g_type_inv_lot_translate
10751: ));
10752:

Line 10749: , inv_globals.g_type_inv_lot_merge

10745: AND mti.TRANSACTION_INTERFACE_ID IS NOT NULL
10746: AND mti.PROCESS_FLAG = 1
10747: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
10748: (inv_globals.g_type_inv_lot_split
10749: , inv_globals.g_type_inv_lot_merge
10750: , inv_globals.g_type_inv_lot_translate
10751: ));
10752:
10753:

Line 10750: , inv_globals.g_type_inv_lot_translate

10746: AND mti.PROCESS_FLAG = 1
10747: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
10748: (inv_globals.g_type_inv_lot_split
10749: , inv_globals.g_type_inv_lot_merge
10750: , inv_globals.g_type_inv_lot_translate
10751: ));
10752:
10753:
10754:

Line 10928: (inv_globals.g_type_inv_lot_split

10924: /*WHERE MTI.ROWID = p_rowid*/--J-dev
10925: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10926: AND PROCESS_FLAG = 1
10927: AND transaction_type_id NOT IN
10928: (inv_globals.g_type_inv_lot_split
10929: , inv_globals.g_type_inv_lot_merge
10930: , inv_globals.g_type_inv_lot_translate
10931: )
10932: UNION ALL

Line 10929: , inv_globals.g_type_inv_lot_merge

10925: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10926: AND PROCESS_FLAG = 1
10927: AND transaction_type_id NOT IN
10928: (inv_globals.g_type_inv_lot_split
10929: , inv_globals.g_type_inv_lot_merge
10930: , inv_globals.g_type_inv_lot_translate
10931: )
10932: UNION ALL
10933: SELECT SERIAL_TRANSACTION_TEMP_ID

Line 10930: , inv_globals.g_type_inv_lot_translate

10926: AND PROCESS_FLAG = 1
10927: AND transaction_type_id NOT IN
10928: (inv_globals.g_type_inv_lot_split
10929: , inv_globals.g_type_inv_lot_merge
10930: , inv_globals.g_type_inv_lot_translate
10931: )
10932: UNION ALL
10933: SELECT SERIAL_TRANSACTION_TEMP_ID
10934: FROM MTL_TRANSACTION_LOTS_INTERFACE

Line 10943: (inv_globals.g_type_inv_lot_split

10939: /*WHERE rowid = p_rowid J-dev*/
10940: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10941: AND PROCESS_FLAG = 1
10942: AND transaction_type_id NOT IN
10943: (inv_globals.g_type_inv_lot_split
10944: , inv_globals.g_type_inv_lot_merge
10945: , inv_globals.g_type_inv_lot_translate
10946: )))
10947: );

Line 10944: , inv_globals.g_type_inv_lot_merge

10940: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10941: AND PROCESS_FLAG = 1
10942: AND transaction_type_id NOT IN
10943: (inv_globals.g_type_inv_lot_split
10944: , inv_globals.g_type_inv_lot_merge
10945: , inv_globals.g_type_inv_lot_translate
10946: )))
10947: );
10948:

Line 10945: , inv_globals.g_type_inv_lot_translate

10941: AND PROCESS_FLAG = 1
10942: AND transaction_type_id NOT IN
10943: (inv_globals.g_type_inv_lot_split
10944: , inv_globals.g_type_inv_lot_merge
10945: , inv_globals.g_type_inv_lot_translate
10946: )))
10947: );
10948:
10949: RETURN TRUE;

Line 11661: (inv_globals.g_action_inv_lot_split

11657: , mti.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
11658: FROM mtl_transactions_interface mti
11659: WHERE mti.transaction_header_id = l_header_id
11660: AND mti.transaction_action_id IN
11661: (inv_globals.g_action_inv_lot_split
11662: , inv_globals.g_action_inv_lot_merge
11663: , inv_globals.g_action_inv_lot_translate
11664: )
11665: AND mti.transaction_source_type_id = 13

Line 11662: , inv_globals.g_action_inv_lot_merge

11658: FROM mtl_transactions_interface mti
11659: WHERE mti.transaction_header_id = l_header_id
11660: AND mti.transaction_action_id IN
11661: (inv_globals.g_action_inv_lot_split
11662: , inv_globals.g_action_inv_lot_merge
11663: , inv_globals.g_action_inv_lot_translate
11664: )
11665: AND mti.transaction_source_type_id = 13
11666: AND mti.process_flag = 1

Line 11663: , inv_globals.g_action_inv_lot_translate

11659: WHERE mti.transaction_header_id = l_header_id
11660: AND mti.transaction_action_id IN
11661: (inv_globals.g_action_inv_lot_split
11662: , inv_globals.g_action_inv_lot_merge
11663: , inv_globals.g_action_inv_lot_translate
11664: )
11665: AND mti.transaction_source_type_id = 13
11666: AND mti.process_flag = 1
11667: ORDER BY mti.transaction_batch_id

Line 12817: inv_globals.g_action_inv_lot_split

12813:
12814: IF (l_serial_code IN (2, 5))
12815: THEN
12816: IF ( l_mti_csr.transaction_action_id =
12817: inv_globals.g_action_inv_lot_split
12818: OR l_mti_csr.transaction_action_id =
12819: inv_globals.g_action_inv_lot_merge
12820: )
12821: THEN

Line 12819: inv_globals.g_action_inv_lot_merge

12815: THEN
12816: IF ( l_mti_csr.transaction_action_id =
12817: inv_globals.g_action_inv_lot_split
12818: OR l_mti_csr.transaction_action_id =
12819: inv_globals.g_action_inv_lot_merge
12820: )
12821: THEN
12822: BEGIN
12823: IF (l_debug = 1)

Line 12897: inv_globals.g_action_inv_lot_split

12893: ************************************************************************************/
12894: IF ( ( l_mtli_csr.transaction_interface_id <>
12895: l_mti_csr.parent_id
12896: AND l_mti_csr.transaction_action_id =
12897: inv_globals.g_action_inv_lot_split
12898: )
12899: OR ( l_mtli_csr.transaction_interface_id =
12900: l_mti_csr.parent_id
12901: AND l_mti_csr.transaction_action_id =

Line 12902: inv_globals.g_action_inv_lot_merge

12898: )
12899: OR ( l_mtli_csr.transaction_interface_id =
12900: l_mti_csr.parent_id
12901: AND l_mti_csr.transaction_action_id =
12902: inv_globals.g_action_inv_lot_merge
12903: )
12904: )
12905: THEN
12906: BEGIN

Line 13805: inv_globals.g_action_inv_lot_split

13801: );
13802: END IF;
13803:
13804: IF (( l_mti_csr.transaction_action_id =
13805: inv_globals.g_action_inv_lot_split
13806: OR l_mti_csr.transaction_action_id =
13807: inv_globals.g_action_inv_lot_translate
13808: )
13809: )

Line 13807: inv_globals.g_action_inv_lot_translate

13803:
13804: IF (( l_mti_csr.transaction_action_id =
13805: inv_globals.g_action_inv_lot_split
13806: OR l_mti_csr.transaction_action_id =
13807: inv_globals.g_action_inv_lot_translate
13808: )
13809: )
13810: THEN
13811: IF (l_debug = 1)

Line 13837: inv_globals.g_action_inv_lot_merge

13833: NVL (l_mtli_csr.serial_transaction_temp_id --For Lot translate
13834: , l_serial_temp_id
13835: );
13836: ELSIF (l_mti_csr.transaction_action_id =
13837: inv_globals.g_action_inv_lot_merge
13838: )
13839: THEN
13840: IF (l_debug = 1)
13841: THEN

Line 14523: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND

14519: l_current_err_batch_id := l_Line_rec_Type.transaction_batch_id;--Bug#5075521
14520: END ;
14521:
14522: IF ( NOT l_current_batch_failed) THEN --400
14523: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND
14524: l_actid = INV_GLOBALS.G_ACTION_ASSYRETURN AND l_dem_hdr_id IS NOT NULL ) then
14525:
14526: INV_QUANTITY_TREE_PVT.create_tree
14527: ( p_api_version_number => 1.0

Line 14524: l_actid = INV_GLOBALS.G_ACTION_ASSYRETURN AND l_dem_hdr_id IS NOT NULL ) then

14520: END ;
14521:
14522: IF ( NOT l_current_batch_failed) THEN --400
14523: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND
14524: l_actid = INV_GLOBALS.G_ACTION_ASSYRETURN AND l_dem_hdr_id IS NOT NULL ) then
14525:
14526: INV_QUANTITY_TREE_PVT.create_tree
14527: ( p_api_version_number => 1.0
14528: , p_init_msg_lst => fnd_api.g_false

Line 14762: IF ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND

14758: /*Bug:5392366. Modified the following condition to also check
14759: completion_transaction_id and move_transaction_id to make sure it
14760: is a backflush transaction. If both these values are null then
14761: it is is not a backflush transaction*/
14762: IF ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND
14763: (l_line_rec_Type.transaction_action_id
14764: IN (inv_globals.G_ACTION_ISSUE, inv_globals.G_ACTION_NEGCOMPRETURN) AND (l_line_rec_type.completion_transaction_id is not null OR l_line_rec_type.move_transaction_id is not null))) THEN
14765: -- It is a backflush transaction. Get the
14766: -- override flag.

Line 14764: IN (inv_globals.G_ACTION_ISSUE, inv_globals.G_ACTION_NEGCOMPRETURN) AND (l_line_rec_type.completion_transaction_id is not null OR l_line_rec_type.move_transaction_id is not null))) THEN

14760: is a backflush transaction. If both these values are null then
14761: it is is not a backflush transaction*/
14762: IF ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND
14763: (l_line_rec_Type.transaction_action_id
14764: IN (inv_globals.G_ACTION_ISSUE, inv_globals.G_ACTION_NEGCOMPRETURN) AND (l_line_rec_type.completion_transaction_id is not null OR l_line_rec_type.move_transaction_id is not null))) THEN
14765: -- It is a backflush transaction. Get the
14766: -- override flag.
14767: l_override_neg_for_backflush :=
14768: fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');

Line 14791: IF ( l_qr >l_trx_qty OR l_qs >0 OR ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND

14787:
14788: IF (l_att < l_trx_qty) THEN
14789: IF (l_neg_inv_rcpt = 1 OR l_override_neg_for_backflush = 1) THEN
14790:
14791: IF ( l_qr >l_trx_qty OR l_qs >0 OR ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND
14792: (l_line_rec_Type.transaction_action_id = INV_GLOBALS.G_ACTION_ASSYRETURN)) )THEN
14793: /*Bug 4764343 base Bug::4645686. This condition is added for a specific customer by introducing
14794: a new profile 'INV_OVERRIDE_RSV_FOR_BACKFLUSH' . If this profile is not set to 'Yes'
14795: then the backflush transaction can not consume existing reservations.Else it can consume

Line 14792: (l_line_rec_Type.transaction_action_id = INV_GLOBALS.G_ACTION_ASSYRETURN)) )THEN

14788: IF (l_att < l_trx_qty) THEN
14789: IF (l_neg_inv_rcpt = 1 OR l_override_neg_for_backflush = 1) THEN
14790:
14791: IF ( l_qr >l_trx_qty OR l_qs >0 OR ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND
14792: (l_line_rec_Type.transaction_action_id = INV_GLOBALS.G_ACTION_ASSYRETURN)) )THEN
14793: /*Bug 4764343 base Bug::4645686. This condition is added for a specific customer by introducing
14794: a new profile 'INV_OVERRIDE_RSV_FOR_BACKFLUSH' . If this profile is not set to 'Yes'
14795: then the backflush transaction can not consume existing reservations.Else it can consume
14796: existing reservation and can drive inventory go negative. */