DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on INV_TXN_MANAGER_GRP

Line 1311: * moved to group API INV_TXN_MANAGER_GRP()

1307: RETURN FALSE;
1308: END check_partial_split;
1309:
1310: /* getacctid()
1311: * moved to group API INV_TXN_MANAGER_GRP()
1312: ******************************************************************/
1313:
1314: /******************************************************************
1315: -- Procedure moved to group api INV_TXN_MANAGER_GRP

Line 1315: -- Procedure moved to group api INV_TXN_MANAGER_GRP

1311: * moved to group API INV_TXN_MANAGER_GRP()
1312: ******************************************************************/
1313:
1314: /******************************************************************
1315: -- Procedure moved to group api INV_TXN_MANAGER_GRP
1316: -- getitemid
1317: -- Description
1318: -- find the item_id using the flex field segments
1319: -- Output Parameters

Line 1324: -- Procedure moved to group api INV_TXN_MANAGER_GRP

1320: -- x_item_id locator or null if error occurred
1321: ******************************************************************/
1322:
1323: /******************************************************************
1324: -- Procedure moved to group api INV_TXN_MANAGER_GRP
1325: -- getsrcid
1326: -- Description
1327: -- find the Source ID using the flex field segments
1328: -- Output Parameters

Line 1365: -- Procedure (moved to group api INV_TXN_MANAGER_GRP)

1361: RETURN;
1362: END errupdate;
1363:
1364: /******************************************************************
1365: -- Procedure (moved to group api INV_TXN_MANAGER_GRP)
1366: -- derive_segment_ids
1367: -- Description
1368: -- derive segment-ids based on segment values
1369: -- Output Parameters

Line 1379: * Actual implemetation is mved to INV_TXN_MANAGER_GRP(INVTXGGB.pls)

1375: * validate_group
1376: * Validate a group of MTI records in a batch together
1377:
1378: * J-dev (WIP related validations)
1379: * Actual implemetation is mved to INV_TXN_MANAGER_GRP(INVTXGGB.pls)
1380: * The public spec here, does not accept p_validation_level.
1381: * if p_validation_level is to be used, the group api has to be invoked.
1382: ******************************************************************/
1383: PROCEDURE validate_group (

Line 1410: inv_txn_manager_grp.validate_group

1406: THEN
1407: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1408: END IF;
1409:
1410: inv_txn_manager_grp.validate_group
1411: (p_header_id => p_header_id
1412: , x_return_status => l_return_status
1413: , x_msg_count => l_msg_count
1414: , x_msg_data => l_msg_data

Line 1454: * lotcheck moved to group API INV_TXN_MANAGER_GRP

1450: /******* LINE VALIDATION OBJECTS ***************/
1451:
1452: /******************************************************************
1453: *
1454: * lotcheck moved to group API INV_TXN_MANAGER_GRP
1455: *
1456: ******************************************************************/
1457:
1458: /******************************************************************

Line 1460: * setorgclientinfo() moved to group API INV_TXN_MANAGER_GRP

1456: ******************************************************************/
1457:
1458: /******************************************************************
1459: *
1460: * setorgclientinfo() moved to group API INV_TXN_MANAGER_GRP
1461: *
1462: ******************************************************************/
1463:
1464: /******************************************************************

Line 1465: -- Function moved to INV_TXN_MANAGER_GRP

1461: *
1462: ******************************************************************/
1463:
1464: /******************************************************************
1465: -- Function moved to INV_TXN_MANAGER_GRP
1466: -- getloc
1467: -- Description
1468: -- Private function to get Locator id using Flex API's
1469: -- Uses FND_FLEX_KEY_API (AFFFKAIS/B.pls) and

Line 1481: -- Function moved to INV_TXN_MANAGER_GRP

1477: -- x_locid locator or null if error occurred
1478: ******************************************************************/
1479:
1480: /******************************************************************
1481: -- Function moved to INV_TXN_MANAGER_GRP
1482: -- getlocid
1483: -- Description
1484: -- find the locator using the flex field segments
1485: -- Calls private function getLoc to do the work

Line 1491: -- Function moved to INV_TXN_MANAGER_GRP

1487: -- x_locator locator or null if error occurred
1488: ******************************************************************/
1489:
1490: /******************************************************************
1491: -- Function moved to INV_TXN_MANAGER_GRP
1492: -- getxlocid
1493: -- Description
1494: -- find the locator using the flex field segments
1495: -- Calls private function getLoc to do the work

Line 1503: * moved to INV_TXN_MANAGER_GRP

1499:
1500: /******************************************************************
1501: *
1502: * validate_loc_for_project()
1503: * moved to INV_TXN_MANAGER_GRP
1504: *
1505: ******************************************************************/
1506:
1507: /******************************************************************

Line 1510: * moved to INV_TXN_MANAGER_GRP

1506:
1507: /******************************************************************
1508: *
1509: * validate_unit_number()
1510: * moved to INV_TXN_MANAGER_GRP
1511: *
1512: ******************************************************************/
1513:
1514: /******************************************************************

Line 1680: inv_txn_manager_grp.validate_lines

1676: THEN
1677: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1678: END IF;
1679:
1680: inv_txn_manager_grp.validate_lines
1681: (p_line_rec_type => p_line_rec_type
1682: , p_error_flag => l_error_flag
1683: , p_validation_level => p_validation_level
1684: , p_userid => p_userid

Line 1692: inv_log_util.TRACE ('Returned from inv_txn_manager_grp.validate_lines'

1688: );
1689:
1690: IF (l_debug = 1)
1691: THEN
1692: inv_log_util.TRACE ('Returned from inv_txn_manager_grp.validate_lines'
1693: , 'INV_TXN_MANAGER_PUB'
1694: , 9
1695: );
1696: END IF;

Line 1787: * tmpinsert() moved to INV_TXN_MANAGER_GRP

1783: END get_open_period;
1784:
1785: /******************************************************************
1786: *
1787: * tmpinsert() moved to INV_TXN_MANAGER_GRP
1788: *
1789: ******************************************************************/
1790: FUNCTION tmpinsert (p_header_id IN NUMBER)
1791: RETURN BOOLEAN

Line 1801: l_return := inv_txn_manager_grp.tmpinsert (p_header_id => p_header_id);

1797: THEN
1798: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1799: END IF;
1800:
1801: l_return := inv_txn_manager_grp.tmpinsert (p_header_id => p_header_id);
1802:
1803: IF (l_return)
1804: THEN
1805:

Line 1869: , 'INV_TXN_MANAGER_GRP'

1865: THEN
1866: IF (l_debug = 1)
1867: THEN
1868: inv_log_util.TRACE ('*** SQL error ' || SUBSTR (SQLERRM, 1, 200)
1869: , 'INV_TXN_MANAGER_GRP'
1870: , 9
1871: );
1872: END IF;
1873:

Line 2769: | The global INV_TXN_MANAGER_GRP.gi_flow_schedule will be '1' (or true) for |

2765: AND mtt.transaction_type_id = mti.transaction_type_id
2766: AND ROWNUM < 2;
2767:
2768: /*+--------------------------------------------------------------+
2769: | The global INV_TXN_MANAGER_GRP.gi_flow_schedule will be '1' (or true) for |
2770: | WIP flow schedules ONLY. |
2771: +--------------------------------------------------------------+ */
2772: IF (l_srctypeid = 5)
2773: THEN

Line 2776: INTO inv_txn_manager_grp.gi_flow_schedule

2772: IF (l_srctypeid = 5)
2773: THEN
2774: BEGIN
2775: SELECT DECODE (UPPER (flow_schedule), 'Y', 1, 0)
2776: INTO inv_txn_manager_grp.gi_flow_schedule
2777: FROM mtl_transactions_interface
2778: WHERE transaction_header_id = l_header_id
2779: AND transaction_source_type_id = 5
2780: AND transaction_action_id IN

Line 2787: inv_txn_manager_grp.gi_flow_schedule := 0;

2783: AND ROWNUM < 2;
2784: EXCEPTION
2785: WHEN NO_DATA_FOUND
2786: THEN
2787: inv_txn_manager_grp.gi_flow_schedule := 0;
2788: END;
2789: ELSE
2790: inv_txn_manager_grp.gi_flow_schedule := 0;
2791: END IF;

Line 2790: inv_txn_manager_grp.gi_flow_schedule := 0;

2786: THEN
2787: inv_txn_manager_grp.gi_flow_schedule := 0;
2788: END;
2789: ELSE
2790: inv_txn_manager_grp.gi_flow_schedule := 0;
2791: END IF;
2792:
2793: /** WIP J dev condition. If WIP J is not installed do as now,
2794: /*else call a new new API wip_mti_pub.preInvWIPProcessing()

Line 2887: IF (inv_txn_manager_grp.gi_flow_schedule <> 0)

2883: RAISE fnd_api.g_exc_unexpected_error;
2884: END IF; --check for success
2885: END IF;--for l_wip_entity_type Pawan added for gme-convergence changes.
2886: ELSE
2887: IF (inv_txn_manager_grp.gi_flow_schedule <> 0)
2888: THEN
2889: wip_flow_utilities.create_flow_schedules (l_header_id);
2890: END IF;
2891: END IF; --J-dev

Line 3253: checks for WIP transactions. In VALIDATE_TRANSACTIONS() of pkg INV_TXN_MANAGER_GRP, high/low level

3249: RAISE rollback_line_validation;
3250: END IF;
3251:
3252: /*Bug:5209598. Start of code.Following Code has been added to perform ATT/ATR high/low level
3253: checks for WIP transactions. In VALIDATE_TRANSACTIONS() of pkg INV_TXN_MANAGER_GRP, high/low level
3254: reservation checks are performed for WIP transactions.But for those WIP transactions that do not
3255: go through the validate_transactions() procedure, the following code does the reservation checks
3256: before inserting record into MMTT.
3257: */

Line 3264: Z1(inv_txn_manager_grp.gi_flow_schedule,l_Line_rec_type) LOOP

3260: OR l_Line_rec_Type.transaction_batch_id IS NULL
3261: OR l_current_err_batch_id <> l_Line_rec_Type.transaction_batch_id )THEN --050
3262: l_current_batch_failed := FALSE;
3263: FOR z1_rec IN
3264: Z1(inv_txn_manager_grp.gi_flow_schedule,l_Line_rec_type) LOOP
3265:
3266: --bug#13527319 to skip validation for phantom component which has op_seq_num negative and wip_supply_type = 6
3267: select nvl(operation_seq_num,1 ),nvl(wip_supply_type,1)
3268: into l_operation_seq_num, l_wip_supply_type

Line 3315: inv_log_util.trace('Validate_Transactions: INV_CONVERT.INV_UM_CONVERT error while calculating primary qty', 'INV_TXN_MANAGER_GRP', 9);

3311: END IF;
3312:
3313: IF (l_trx_qty = -99999) THEN
3314: IF (l_debug = 1) THEN
3315: inv_log_util.trace('Validate_Transactions: INV_CONVERT.INV_UM_CONVERT error while calculating primary qty', 'INV_TXN_MANAGER_GRP', 9);
3316: END IF;
3317: FND_MESSAGE.set_name('INV', 'INV_NO_CONVERSION_ERR');
3318: l_error_code:= fnd_message.get;
3319:

Line 4467: inv_txn_manager_grp.tmpinsert2(

4463: , 'INV_TXN_MANAGER_PUB'
4464: , 9
4465: );
4466: END IF;
4467: inv_txn_manager_grp.tmpinsert2(
4468: x_return_status => x_return_status
4469: , x_msg_count => x_msg_count
4470: , x_msg_data => x_msg_data
4471: , x_validation_status => l_validation_status

Line 4567: IF (inv_txn_manager_grp.gi_flow_schedule <> 0)

4563: COMMIT WORK; /* Commit after validating all MTI records */
4564: END IF;
4565:
4566: /* Delete the errored out flow schedules */
4567: IF (inv_txn_manager_grp.gi_flow_schedule <> 0)
4568: THEN
4569: wip_flow_utilities.delete_flow_schedules (l_header_id);
4570: END IF;
4571:

Line 6397: , inv_txn_manager_grp.gi_flow_schedule

6393: --qty-tree validation
6394: IF ((NOT post_temp_validation (l_line_rec_type
6395: , 1 --always validate it
6396: , l_userid
6397: , inv_txn_manager_grp.gi_flow_schedule
6398: , l_lotnum -- Added for 4377625
6399: )
6400: )
6401: )