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 1384: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR

1380: END IF;
1381: END IF;
1382: /* Bug 3273172,moved the below code here
1383: for Account, Account Alias source is populated first before getting the account */
1384: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1385: l_srctype = INV_Globals.G_SourceType_Account OR
1386: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1387: l_srctype = INV_Globals.G_SourceType_IntOrder)
1388: AND (l_trxsrc is NULL) ) THEN

Line 1385: l_srctype = INV_Globals.G_SourceType_Account OR

1381: END IF;
1382: /* Bug 3273172,moved the below code here
1383: for Account, Account Alias source is populated first before getting the account */
1384: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1385: l_srctype = INV_Globals.G_SourceType_Account OR
1386: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1387: l_srctype = INV_Globals.G_SourceType_IntOrder)
1388: AND (l_trxsrc is NULL) ) THEN
1389: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN

Line 1386: l_srctype = INV_Globals.G_SourceType_AccountAlias OR

1382: /* Bug 3273172,moved the below code here
1383: for Account, Account Alias source is populated first before getting the account */
1384: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1385: l_srctype = INV_Globals.G_SourceType_Account OR
1386: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1387: l_srctype = INV_Globals.G_SourceType_IntOrder)
1388: AND (l_trxsrc is NULL) ) THEN
1389: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1390: l_error_exp := FND_MESSAGE.get;

Line 1387: l_srctype = INV_Globals.G_SourceType_IntOrder)

1383: for Account, Account Alias source is populated first before getting the account */
1384: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1385: l_srctype = INV_Globals.G_SourceType_Account OR
1386: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1387: l_srctype = INV_Globals.G_SourceType_IntOrder)
1388: AND (l_trxsrc is NULL) ) THEN
1389: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1390: l_error_exp := FND_MESSAGE.get;
1391:

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

1430: END IF;
1431:
1432: /* Bug 2971400 populating transaction source id */
1433: /* Bug 3273172,Moving the below code to above
1434: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1435: l_srctype = INV_Globals.G_SourceType_Account OR
1436: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1437: l_srctype = INV_Globals.G_SourceType_IntOrder)
1438: AND (l_trxsrc is NULL) ) THEN

Line 1435: l_srctype = INV_Globals.G_SourceType_Account OR

1431:
1432: /* Bug 2971400 populating transaction source id */
1433: /* Bug 3273172,Moving the below code to above
1434: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1435: l_srctype = INV_Globals.G_SourceType_Account OR
1436: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1437: l_srctype = INV_Globals.G_SourceType_IntOrder)
1438: AND (l_trxsrc is NULL) ) THEN
1439: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN

Line 1436: l_srctype = INV_Globals.G_SourceType_AccountAlias OR

1432: /* Bug 2971400 populating transaction source id */
1433: /* Bug 3273172,Moving the below code to above
1434: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1435: l_srctype = INV_Globals.G_SourceType_Account OR
1436: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1437: l_srctype = INV_Globals.G_SourceType_IntOrder)
1438: AND (l_trxsrc is NULL) ) THEN
1439: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1440: l_error_exp := FND_MESSAGE.get;

Line 1437: l_srctype = INV_Globals.G_SourceType_IntOrder)

1433: /* Bug 3273172,Moving the below code to above
1434: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
1435: l_srctype = INV_Globals.G_SourceType_Account OR
1436: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
1437: l_srctype = INV_Globals.G_SourceType_IntOrder)
1438: AND (l_trxsrc is NULL) ) THEN
1439: IF ( NOT getsrcid(l_trxsrc, l_srctype, c_mti_row.organization_id, c_mti_row.rowid)) THEN
1440: l_error_exp := FND_MESSAGE.get;
1441:

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

1999: | where not supplied
2000: +--------------------------------------------------------------------------*/
2001:
2002:
2003: /* commented logical validations fr inv_globals pre-req*/
2004: IF (l_validate_full) THEN --J-dev
2005: fnd_flex_key_api.set_session_mode('seed_data');
2006: derive_segment_ids(p_header_id, x_return_status ,x_msg_count, x_msg_data);
2007: END IF;

Line 2029: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory

2025: ERROR_CODE = substrb(l_error_code,1,240),
2026: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
2027: WHERE TRANSACTION_HEADER_ID = p_header_id
2028: AND process_flag = 1
2029: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2030: AND transaction_action_id IN
2031: (inv_globals.G_action_logicalissue,
2032: inv_globals.G_action_logicalicsales,
2033: inv_globals.G_action_logicalicreceipt,

Line 2031: (inv_globals.G_action_logicalissue,

2027: WHERE TRANSACTION_HEADER_ID = p_header_id
2028: AND process_flag = 1
2029: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2030: AND transaction_action_id IN
2031: (inv_globals.G_action_logicalissue,
2032: inv_globals.G_action_logicalicsales,
2033: inv_globals.G_action_logicalicreceipt,
2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,

Line 2032: inv_globals.G_action_logicalicsales,

2028: AND process_flag = 1
2029: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2030: AND transaction_action_id IN
2031: (inv_globals.G_action_logicalissue,
2032: inv_globals.G_action_logicalicsales,
2033: inv_globals.G_action_logicalicreceipt,
2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,
2036: inv_globals.G_action_logicalreceipt)) OR

Line 2033: inv_globals.G_action_logicalicreceipt,

2029: AND ((transaction_source_type_id = inv_globals.G_sourcetype_inventory
2030: AND transaction_action_id IN
2031: (inv_globals.G_action_logicalissue,
2032: inv_globals.G_action_logicalicsales,
2033: inv_globals.G_action_logicalicreceipt,
2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,
2036: inv_globals.G_action_logicalreceipt)) OR
2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma

Line 2034: inv_globals.G_action_logicalicrcptreturn,

2030: AND transaction_action_id IN
2031: (inv_globals.G_action_logicalissue,
2032: inv_globals.G_action_logicalicsales,
2033: inv_globals.G_action_logicalicreceipt,
2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,
2036: inv_globals.G_action_logicalreceipt)) OR
2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)

Line 2035: inv_globals.G_action_logicalicsalesreturn,

2031: (inv_globals.G_action_logicalissue,
2032: inv_globals.G_action_logicalicsales,
2033: inv_globals.G_action_logicalicreceipt,
2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,
2036: inv_globals.G_action_logicalreceipt)) OR
2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2039: OR

Line 2036: inv_globals.G_action_logicalreceipt)) OR

2032: inv_globals.G_action_logicalicsales,
2033: inv_globals.G_action_logicalicreceipt,
2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,
2036: inv_globals.G_action_logicalreceipt)) OR
2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2039: OR
2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder

Line 2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma

2033: inv_globals.G_action_logicalicreceipt,
2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,
2036: inv_globals.G_action_logicalreceipt)) OR
2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2039: OR
2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2041: AND transaction_action_id in

Line 2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)

2034: inv_globals.G_action_logicalicrcptreturn,
2035: inv_globals.G_action_logicalicsalesreturn,
2036: inv_globals.G_action_logicalreceipt)) OR
2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2039: OR
2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2041: AND transaction_action_id in
2042: (inv_globals.G_action_logicalissue,

Line 2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder

2036: inv_globals.G_action_logicalreceipt)) OR
2037: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2039: OR
2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2041: AND transaction_action_id in
2042: (inv_globals.G_action_logicalissue,
2043: -- inv_globals.G_action_logicaldeladj,
2044: -- inv_globals.G_action_logicalreceipt,

Line 2042: (inv_globals.G_action_logicalissue,

2038: AND transaction_action_id = inv_globals.G_action_logicalreceipt)
2039: OR
2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2041: AND transaction_action_id in
2042: (inv_globals.G_action_logicalissue,
2043: -- inv_globals.G_action_logicaldeladj,
2044: -- inv_globals.G_action_logicalreceipt,
2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma

Line 2043: -- inv_globals.G_action_logicaldeladj,

2039: OR
2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2041: AND transaction_action_id in
2042: (inv_globals.G_action_logicalissue,
2043: -- inv_globals.G_action_logicaldeladj,
2044: -- inv_globals.G_action_logicalreceipt,
2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR

Line 2044: -- inv_globals.G_action_logicalreceipt,

2040: (transaction_source_type_id = inv_globals.G_sourcetype_purchaseorder
2041: AND transaction_action_id in
2042: (inv_globals.G_action_logicalissue,
2043: -- inv_globals.G_action_logicaldeladj,
2044: -- inv_globals.G_action_logicalreceipt,
2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq

Line 2045: inv_globals.G_action_retropriceupdate)) OR

2041: AND transaction_action_id in
2042: (inv_globals.G_action_logicalissue,
2043: -- inv_globals.G_action_logicaldeladj,
2044: -- inv_globals.G_action_logicalreceipt,
2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR

Line 2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma

2042: (inv_globals.G_action_logicalissue,
2043: -- inv_globals.G_action_logicaldeladj,
2044: -- inv_globals.G_action_logicalreceipt,
2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2050: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder

Line 2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR

2043: -- inv_globals.G_action_logicaldeladj,
2044: -- inv_globals.G_action_logicalreceipt,
2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2050: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2051: and transaction_action_id = inv_globals.G_action_logicalissue)) ;

Line 2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq

2044: -- inv_globals.G_action_logicalreceipt,
2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2050: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2051: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2052: --J-dev for Drop Ship

Line 2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR

2045: inv_globals.G_action_retropriceupdate)) OR
2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2050: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2051: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2052: --J-dev for Drop Ship
2053:

Line 2050: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder

2046: (transaction_source_type_id = inv_globals.G_sourcetype_rma
2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2050: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2051: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2052: --J-dev for Drop Ship
2053:
2054: /*------------------------------------------------------+

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

2047: AND transaction_action_id = inv_globals.G_action_logicalreceipt) OR
2048: (transaction_source_type_id = inv_globals.G_sourcetype_intreq
2049: AND transaction_action_id = inv_globals.G_action_logicalexpreqreceipt) OR
2050: (transaction_source_type_id = inv_globals.G_sourcetype_salesorder
2051: and transaction_action_id = inv_globals.G_action_logicalissue)) ;
2052: --J-dev for Drop Ship
2053:
2054: /*------------------------------------------------------+
2055: | Validate inventory item

Line 2700: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_AccountAlias

2696: ERROR_CODE = substrb(l_error_code,1,240),
2697: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
2698: WHERE TRANSACTION_HEADER_ID = p_header_id
2699: AND PROCESS_FLAG = 1
2700: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_AccountAlias
2701: AND NOT EXISTS (
2702: SELECT NULL
2703: FROM MTL_GENERIC_DISPOSITIONS MGD
2704: WHERE MGD.DISPOSITION_ID = MTI.TRANSACTION_SOURCE_ID

Line 3251: AND (TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SourceType_Inventory OR

3247: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
3248: WHERE TRANSACTION_HEADER_ID = p_header_id
3249: AND PROCESS_FLAG = 1
3250: AND DISTRIBUTION_ACCOUNT_ID IS NULL
3251: AND (TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SourceType_Inventory OR
3252: TRANSACTION_SOURCE_TYPE_ID >=100)
3253: AND NVL(OWNING_ORGANIZATION_ID,organization_id) = organization_id
3254: AND NVL(OWNING_TP_TYPE,2) = 2 -- if it is null we are considering it as normal item..
3255: -- Added the above two lines for the bug # 5896859

Line 3435: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_PrjContracts

3431: PROCESS_FLAG = 3,
3432: ERROR_CODE = substrb(l_error_code,1,240),
3433: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
3434: WHERE TRANSACTION_HEADER_ID = p_header_id
3435: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_PrjContracts
3436: AND NOT EXISTS (
3437: SELECT NULL
3438: FROM OKE_K_HEADERS_V OKHV
3439: WHERE MTI.TRANSACTION_SOURCE_ID = OKHV.K_HEADER_ID);

Line 3800: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR

3796: +-------------------------------------------------------------*/
3797:
3798:
3799:
3800: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
3801: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
3802: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
3803: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3804: SET LAST_UPDATE_DATE = SYSDATE,

Line 3801: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR

3797:
3798:
3799:
3800: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
3801: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
3802: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
3803: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3804: SET LAST_UPDATE_DATE = SYSDATE,
3805: LAST_UPDATED_BY = p_userid,

Line 3802: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN

3798:
3799:
3800: IF (srctypeid = INV_GLOBALS.G_SourceType_SalesOrder OR
3801: srctypeid = INV_GLOBALS.G_SourceType_IntOrder OR
3802: srctypeid = INV_GLOBALS.G_SourceType_PrjContracts) THEN
3803: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
3804: SET LAST_UPDATE_DATE = SYSDATE,
3805: LAST_UPDATED_BY = p_userid,
3806: LAST_UPDATE_LOGIN = p_loginid,

Line 4398: IF (p_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND

4394:
4395: -- INVCONV end fabdi
4396:
4397: -- R12 Genealogy Enhancement : Start
4398: IF (p_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND
4399: p_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN
4400: IF (p_serctrl = 2 OR p_serctrl = 5) -- Lot + serial Controlled
4401: THEN
4402: -- mrana:5443557: this is not needed anymore AND (p_is_wsm_enabled = 'N')) THEN

Line 4399: p_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN

4395: -- INVCONV end fabdi
4396:
4397: -- R12 Genealogy Enhancement : Start
4398: IF (p_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND
4399: p_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN
4400: IF (p_serctrl = 2 OR p_serctrl = 5) -- Lot + serial Controlled
4401: THEN
4402: -- mrana:5443557: this is not needed anymore AND (p_is_wsm_enabled = 'N')) THEN
4403: IF (l_debug = 1) THEN

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

4568: END IF;
4569:
4570: IF (p_serctrl = 2 OR p_serctrl = 5 OR (p_serctrl = 6 AND
4571: p_srctype = 2 AND p_acttype = 1) OR (p_serctrl = 6 AND
4572: p_srctype = INV_GLOBALS.G_SourceType_IntOrder AND p_acttype = 1)
4573: OR (p_serctrl = 6 AND p_srctype = 8)
4574: /*2815918*/
4575: OR (P_serctrl = 6 AND p_srctype = 16 and p_acttype = 1) )
4576: THEN

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

6519: IF (l_acttype = 2) THEN
6520: l_xorgid := l_orgid;
6521: END IF;
6522:
6523: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6524: l_srctype = INV_Globals.G_SourceType_Account OR
6525: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6526: l_srctype = INV_Globals.G_SourceType_IntOrder)
6527: AND (l_trxsrc is NULL) ) THEN

Line 6524: l_srctype = INV_Globals.G_SourceType_Account OR

6520: l_xorgid := l_orgid;
6521: END IF;
6522:
6523: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6524: l_srctype = INV_Globals.G_SourceType_Account OR
6525: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6526: l_srctype = INV_Globals.G_SourceType_IntOrder)
6527: AND (l_trxsrc is NULL) ) THEN
6528: IF ( NOT getsrcid(l_trxsrc, l_srctype, l_orgid, l_rowid)) THEN

Line 6525: l_srctype = INV_Globals.G_SourceType_AccountAlias OR

6521: END IF;
6522:
6523: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6524: l_srctype = INV_Globals.G_SourceType_Account OR
6525: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6526: l_srctype = INV_Globals.G_SourceType_IntOrder)
6527: AND (l_trxsrc is NULL) ) THEN
6528: IF ( NOT getsrcid(l_trxsrc, l_srctype, l_orgid, l_rowid)) THEN
6529: FND_MESSAGE.set_name('INV', 'INV_INT_SRCSEGCODE');

Line 6526: l_srctype = INV_Globals.G_SourceType_IntOrder)

6522:
6523: IF ( ( l_srctype=INV_Globals.G_SourceType_SalesOrder OR
6524: l_srctype = INV_Globals.G_SourceType_Account OR
6525: l_srctype = INV_Globals.G_SourceType_AccountAlias OR
6526: l_srctype = INV_Globals.G_SourceType_IntOrder)
6527: AND (l_trxsrc is NULL) ) THEN
6528: IF ( NOT getsrcid(l_trxsrc, l_srctype, l_orgid, l_rowid)) THEN
6529: FND_MESSAGE.set_name('INV', 'INV_INT_SRCSEGCODE');
6530: l_error_code := FND_MESSAGE.get;

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

7143: /* Bug# 6271039, For average cost update and layer cost update, validate rows in
7144: * MTI for material account, material overhead account, resource account,
7145: * outside processing account, overhead account. */
7146:
7147: IF ( l_acttype = 24 AND ((l_srctype = INV_Globals.G_SourceType_Inventory) OR (l_srctype = 15)) AND ( l_avg_cost_update = 2 ) )
7148: OR (( l_acttype = 24 AND l_srctype = 14 )) THEN
7149:
7150: /*-----------------------------------------------------------+
7151: | Validate material account

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

7475: /* for average cost update and layer cost update, validate rows in */
7476: /* mtl_txn_cost_det_interface table , if R10 avg cost profile is set */
7477:
7478:
7479: IF ( l_acttype = 24 AND ((l_srctype = INV_Globals.G_SourceType_Inventory)
7480: OR (l_srctype = 15)) ) THEN
7481: IF ( l_avg_cost_update = 2 ) THEN
7482:
7483: /* should we check also if interface id is not null and

Line 7581: INV_GLOBALS.G_ACTION_COSTUPDATE

7577: --Do not validate lot/serial quantity for lot split, merge and translate
7578: --The inv_lot_trx_validations_pub API would already have done it by the
7579: --time control comes here
7580: IF (l_validate_full AND l_acttype NOT IN (
7581: INV_GLOBALS.G_ACTION_COSTUPDATE
7582: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
7583: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
7584: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
7585: ) THEN

Line 7582: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT

7578: --The inv_lot_trx_validations_pub API would already have done it by the
7579: --time control comes here
7580: IF (l_validate_full AND l_acttype NOT IN (
7581: INV_GLOBALS.G_ACTION_COSTUPDATE
7582: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
7583: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
7584: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
7585: ) THEN
7586: IF (l_lotctrl = 2 AND

Line 7583: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE

7579: --time control comes here
7580: IF (l_validate_full AND l_acttype NOT IN (
7581: INV_GLOBALS.G_ACTION_COSTUPDATE
7582: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
7583: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
7584: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
7585: ) THEN
7586: IF (l_lotctrl = 2 AND
7587: (l_serctrl = 2 OR l_serctrl = 5 OR

Line 7584: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)

7580: IF (l_validate_full AND l_acttype NOT IN (
7581: INV_GLOBALS.G_ACTION_COSTUPDATE
7582: , INV_GLOBALS.G_ACTION_INV_LOT_SPLIT
7583: , INV_GLOBALS.G_ACTION_INV_LOT_MERGE
7584: , INV_GLOBALS.G_ACTION_INV_LOT_TRANSLATE)
7585: ) THEN
7586: IF (l_lotctrl = 2 AND
7587: (l_serctrl = 2 OR l_serctrl = 5 OR
7588: (l_serctrl = 6 AND l_srctype = 2 AND l_acttype = 1) OR

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

7803: END IF; --actions for serials.
7804: END IF;--if check actions for lots
7805:
7806: -- R12 Genealogy Enhancement : Start
7807: IF (l_srctype = INV_GLOBALS.G_SOURCETYPE_WIP AND l_acttype = INV_GLOBALS.G_ACTION_ISSUE) THEN
7808: IF ((l_lotctrl = 1 AND l_acttype <> 24) AND
7809: (l_lotctrl = 1 AND (l_serctrl = 2 OR l_serctrl = 5)) )
7810: THEN
7811: IF (l_debug = 1) THEN

Line 8537: (inv_globals.g_type_inv_lot_split

8533: FROM mtl_transactions_interface
8534: WHERE transaction_header_id = p_header_id
8535: AND process_flag = 1
8536: AND transaction_type_id NOT IN
8537: (inv_globals.g_type_inv_lot_split
8538: , inv_globals.g_type_inv_lot_merge
8539: , inv_globals.g_type_inv_lot_translate));
8540: EXCEPTION
8541: WHEN OTHERS THEN

Line 8538: , inv_globals.g_type_inv_lot_merge

8534: WHERE transaction_header_id = p_header_id
8535: AND process_flag = 1
8536: AND transaction_type_id NOT IN
8537: (inv_globals.g_type_inv_lot_split
8538: , inv_globals.g_type_inv_lot_merge
8539: , inv_globals.g_type_inv_lot_translate));
8540: EXCEPTION
8541: WHEN OTHERS THEN
8542: l_count := 0;

Line 8539: , inv_globals.g_type_inv_lot_translate));

8535: AND process_flag = 1
8536: AND transaction_type_id NOT IN
8537: (inv_globals.g_type_inv_lot_split
8538: , inv_globals.g_type_inv_lot_merge
8539: , inv_globals.g_type_inv_lot_translate));
8540: EXCEPTION
8541: WHEN OTHERS THEN
8542: l_count := 0;
8543: IF(l_debug = 1) THEN

Line 8900: (inv_globals.g_type_inv_lot_split

8896: --WHERE ROWID = p_rowid--J-dev
8897: WHERE transaction_header_id = p_header_id
8898: AND PROCESS_FLAG = 1
8899: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
8900: (inv_globals.g_type_inv_lot_split
8901: , inv_globals.g_type_inv_lot_merge
8902: , inv_globals.g_type_inv_lot_translate
8903: );
8904:

Line 8901: , inv_globals.g_type_inv_lot_merge

8897: WHERE transaction_header_id = p_header_id
8898: AND PROCESS_FLAG = 1
8899: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
8900: (inv_globals.g_type_inv_lot_split
8901: , inv_globals.g_type_inv_lot_merge
8902: , inv_globals.g_type_inv_lot_translate
8903: );
8904:
8905: ELSE

Line 8902: , inv_globals.g_type_inv_lot_translate

8898: AND PROCESS_FLAG = 1
8899: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
8900: (inv_globals.g_type_inv_lot_split
8901: , inv_globals.g_type_inv_lot_merge
8902: , inv_globals.g_type_inv_lot_translate
8903: );
8904:
8905: ELSE
8906: IF ( l_lt_flow_schedule <> 0 ) THEN

Line 10177: (inv_globals.g_type_inv_lot_split

10173: /*WHERE MTI.ROWID = p_rowid J-dev*/
10174: AND mti.TRANSACTION_INTERFACE_ID IS NOT NULL
10175: AND mti.PROCESS_FLAG = 1
10176: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
10177: (inv_globals.g_type_inv_lot_split
10178: , inv_globals.g_type_inv_lot_merge
10179: , inv_globals.g_type_inv_lot_translate
10180: ));
10181:

Line 10178: , inv_globals.g_type_inv_lot_merge

10174: AND mti.TRANSACTION_INTERFACE_ID IS NOT NULL
10175: AND mti.PROCESS_FLAG = 1
10176: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
10177: (inv_globals.g_type_inv_lot_split
10178: , inv_globals.g_type_inv_lot_merge
10179: , inv_globals.g_type_inv_lot_translate
10180: ));
10181:
10182:

Line 10179: , inv_globals.g_type_inv_lot_translate

10175: AND mti.PROCESS_FLAG = 1
10176: AND transaction_type_id NOT IN /*OSFM Support for Lot Serialized Items*/
10177: (inv_globals.g_type_inv_lot_split
10178: , inv_globals.g_type_inv_lot_merge
10179: , inv_globals.g_type_inv_lot_translate
10180: ));
10181:
10182:
10183:

Line 10357: (inv_globals.g_type_inv_lot_split

10353: /*WHERE MTI.ROWID = p_rowid*/--J-dev
10354: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10355: AND PROCESS_FLAG = 1
10356: AND transaction_type_id NOT IN
10357: (inv_globals.g_type_inv_lot_split
10358: , inv_globals.g_type_inv_lot_merge
10359: , inv_globals.g_type_inv_lot_translate
10360: )
10361: UNION ALL

Line 10358: , inv_globals.g_type_inv_lot_merge

10354: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10355: AND PROCESS_FLAG = 1
10356: AND transaction_type_id NOT IN
10357: (inv_globals.g_type_inv_lot_split
10358: , inv_globals.g_type_inv_lot_merge
10359: , inv_globals.g_type_inv_lot_translate
10360: )
10361: UNION ALL
10362: SELECT SERIAL_TRANSACTION_TEMP_ID

Line 10359: , inv_globals.g_type_inv_lot_translate

10355: AND PROCESS_FLAG = 1
10356: AND transaction_type_id NOT IN
10357: (inv_globals.g_type_inv_lot_split
10358: , inv_globals.g_type_inv_lot_merge
10359: , inv_globals.g_type_inv_lot_translate
10360: )
10361: UNION ALL
10362: SELECT SERIAL_TRANSACTION_TEMP_ID
10363: FROM MTL_TRANSACTION_LOTS_INTERFACE

Line 10372: (inv_globals.g_type_inv_lot_split

10368: /*WHERE rowid = p_rowid J-dev*/
10369: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10370: AND PROCESS_FLAG = 1
10371: AND transaction_type_id NOT IN
10372: (inv_globals.g_type_inv_lot_split
10373: , inv_globals.g_type_inv_lot_merge
10374: , inv_globals.g_type_inv_lot_translate
10375: )))
10376: );

Line 10373: , inv_globals.g_type_inv_lot_merge

10369: AND TRANSACTION_INTERFACE_ID IS NOT NULL
10370: AND PROCESS_FLAG = 1
10371: AND transaction_type_id NOT IN
10372: (inv_globals.g_type_inv_lot_split
10373: , inv_globals.g_type_inv_lot_merge
10374: , inv_globals.g_type_inv_lot_translate
10375: )))
10376: );
10377:

Line 10374: , inv_globals.g_type_inv_lot_translate

10370: AND PROCESS_FLAG = 1
10371: AND transaction_type_id NOT IN
10372: (inv_globals.g_type_inv_lot_split
10373: , inv_globals.g_type_inv_lot_merge
10374: , inv_globals.g_type_inv_lot_translate
10375: )))
10376: );
10377:
10378: RETURN TRUE;

Line 11090: (inv_globals.g_action_inv_lot_split

11086: , mti.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
11087: FROM mtl_transactions_interface mti
11088: WHERE mti.transaction_header_id = l_header_id
11089: AND mti.transaction_action_id IN
11090: (inv_globals.g_action_inv_lot_split
11091: , inv_globals.g_action_inv_lot_merge
11092: , inv_globals.g_action_inv_lot_translate
11093: )
11094: AND mti.transaction_source_type_id = 13

Line 11091: , inv_globals.g_action_inv_lot_merge

11087: FROM mtl_transactions_interface mti
11088: WHERE mti.transaction_header_id = l_header_id
11089: AND mti.transaction_action_id IN
11090: (inv_globals.g_action_inv_lot_split
11091: , inv_globals.g_action_inv_lot_merge
11092: , inv_globals.g_action_inv_lot_translate
11093: )
11094: AND mti.transaction_source_type_id = 13
11095: AND mti.process_flag = 1

Line 11092: , inv_globals.g_action_inv_lot_translate

11088: WHERE mti.transaction_header_id = l_header_id
11089: AND mti.transaction_action_id IN
11090: (inv_globals.g_action_inv_lot_split
11091: , inv_globals.g_action_inv_lot_merge
11092: , inv_globals.g_action_inv_lot_translate
11093: )
11094: AND mti.transaction_source_type_id = 13
11095: AND mti.process_flag = 1
11096: ORDER BY mti.transaction_batch_id

Line 12246: inv_globals.g_action_inv_lot_split

12242:
12243: IF (l_serial_code IN (2, 5))
12244: THEN
12245: IF ( l_mti_csr.transaction_action_id =
12246: inv_globals.g_action_inv_lot_split
12247: OR l_mti_csr.transaction_action_id =
12248: inv_globals.g_action_inv_lot_merge
12249: )
12250: THEN

Line 12248: inv_globals.g_action_inv_lot_merge

12244: THEN
12245: IF ( l_mti_csr.transaction_action_id =
12246: inv_globals.g_action_inv_lot_split
12247: OR l_mti_csr.transaction_action_id =
12248: inv_globals.g_action_inv_lot_merge
12249: )
12250: THEN
12251: BEGIN
12252: IF (l_debug = 1)

Line 12326: inv_globals.g_action_inv_lot_split

12322: ************************************************************************************/
12323: IF ( ( l_mtli_csr.transaction_interface_id <>
12324: l_mti_csr.parent_id
12325: AND l_mti_csr.transaction_action_id =
12326: inv_globals.g_action_inv_lot_split
12327: )
12328: OR ( l_mtli_csr.transaction_interface_id =
12329: l_mti_csr.parent_id
12330: AND l_mti_csr.transaction_action_id =

Line 12331: inv_globals.g_action_inv_lot_merge

12327: )
12328: OR ( l_mtli_csr.transaction_interface_id =
12329: l_mti_csr.parent_id
12330: AND l_mti_csr.transaction_action_id =
12331: inv_globals.g_action_inv_lot_merge
12332: )
12333: )
12334: THEN
12335: BEGIN

Line 13234: inv_globals.g_action_inv_lot_split

13230: );
13231: END IF;
13232:
13233: IF (( l_mti_csr.transaction_action_id =
13234: inv_globals.g_action_inv_lot_split
13235: OR l_mti_csr.transaction_action_id =
13236: inv_globals.g_action_inv_lot_translate
13237: )
13238: )

Line 13236: inv_globals.g_action_inv_lot_translate

13232:
13233: IF (( l_mti_csr.transaction_action_id =
13234: inv_globals.g_action_inv_lot_split
13235: OR l_mti_csr.transaction_action_id =
13236: inv_globals.g_action_inv_lot_translate
13237: )
13238: )
13239: THEN
13240: IF (l_debug = 1)

Line 13266: inv_globals.g_action_inv_lot_merge

13262: NVL (l_mtli_csr.serial_transaction_temp_id --For Lot translate
13263: , l_serial_temp_id
13264: );
13265: ELSIF (l_mti_csr.transaction_action_id =
13266: inv_globals.g_action_inv_lot_merge
13267: )
13268: THEN
13269: IF (l_debug = 1)
13270: THEN

Line 13942: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND

13938: l_current_err_batch_id := l_Line_rec_Type.transaction_batch_id;--Bug#5075521
13939: END ;
13940:
13941: IF ( NOT l_current_batch_failed) THEN --400
13942: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND
13943: l_actid = INV_GLOBALS.G_ACTION_ASSYRETURN AND l_dem_hdr_id IS NOT NULL ) then
13944:
13945: INV_QUANTITY_TREE_PVT.create_tree
13946: ( p_api_version_number => 1.0

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

13939: END ;
13940:
13941: IF ( NOT l_current_batch_failed) THEN --400
13942: IF ( l_srctypeid = INv_GLOBALS.G_SOURCETYPE_WIP AND
13943: l_actid = INV_GLOBALS.G_ACTION_ASSYRETURN AND l_dem_hdr_id IS NOT NULL ) then
13944:
13945: INV_QUANTITY_TREE_PVT.create_tree
13946: ( p_api_version_number => 1.0
13947: , p_init_msg_lst => fnd_api.g_false

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

14177: /*Bug:5392366. Modified the following condition to also check
14178: completion_transaction_id and move_transaction_id to make sure it
14179: is a backflush transaction. If both these values are null then
14180: it is is not a backflush transaction*/
14181: IF ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND
14182: (l_line_rec_Type.transaction_action_id
14183: 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
14184: -- It is a backflush transaction. Get the
14185: -- override flag.

Line 14183: 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

14179: is a backflush transaction. If both these values are null then
14180: it is is not a backflush transaction*/
14181: IF ((l_line_rec_Type.transaction_source_type_id = inv_globals.G_SOURCETYPE_WIP) AND
14182: (l_line_rec_Type.transaction_action_id
14183: 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
14184: -- It is a backflush transaction. Get the
14185: -- override flag.
14186: l_override_neg_for_backflush :=
14187: fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');