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 2725: | The global INV_TXN_MANAGER_GRP.gi_flow_schedule will be '1' (or true) for |

2721: AND mtt.transaction_type_id = mti.transaction_type_id
2722: AND ROWNUM < 2;
2723:
2724: /*+--------------------------------------------------------------+
2725: | The global INV_TXN_MANAGER_GRP.gi_flow_schedule will be '1' (or true) for |
2726: | WIP flow schedules ONLY. |
2727: +--------------------------------------------------------------+ */
2728: IF (l_srctypeid = 5)
2729: THEN

Line 2732: INTO inv_txn_manager_grp.gi_flow_schedule

2728: IF (l_srctypeid = 5)
2729: THEN
2730: BEGIN
2731: SELECT DECODE (UPPER (flow_schedule), 'Y', 1, 0)
2732: INTO inv_txn_manager_grp.gi_flow_schedule
2733: FROM mtl_transactions_interface
2734: WHERE transaction_header_id = l_header_id
2735: AND transaction_source_type_id = 5
2736: AND transaction_action_id IN

Line 2743: inv_txn_manager_grp.gi_flow_schedule := 0;

2739: AND ROWNUM < 2;
2740: EXCEPTION
2741: WHEN NO_DATA_FOUND
2742: THEN
2743: inv_txn_manager_grp.gi_flow_schedule := 0;
2744: END;
2745: ELSE
2746: inv_txn_manager_grp.gi_flow_schedule := 0;
2747: END IF;

Line 2746: inv_txn_manager_grp.gi_flow_schedule := 0;

2742: THEN
2743: inv_txn_manager_grp.gi_flow_schedule := 0;
2744: END;
2745: ELSE
2746: inv_txn_manager_grp.gi_flow_schedule := 0;
2747: END IF;
2748:
2749: /** WIP J dev condition. If WIP J is not installed do as now,
2750: /*else call a new new API wip_mti_pub.preInvWIPProcessing()

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

2839: RAISE fnd_api.g_exc_unexpected_error;
2840: END IF; --check for success
2841: END IF;--for l_wip_entity_type Pawan added for gme-convergence changes.
2842: ELSE
2843: IF (inv_txn_manager_grp.gi_flow_schedule <> 0)
2844: THEN
2845: wip_flow_utilities.create_flow_schedules (l_header_id);
2846: END IF;
2847: END IF; --J-dev

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

3205: RAISE rollback_line_validation;
3206: END IF;
3207:
3208: /*Bug:5209598. Start of code.Following Code has been added to perform ATT/ATR high/low level
3209: checks for WIP transactions. In VALIDATE_TRANSACTIONS() of pkg INV_TXN_MANAGER_GRP, high/low level
3210: reservation checks are performed for WIP transactions.But for those WIP transactions that do not
3211: go through the validate_transactions() procedure, the following code does the reservation checks
3212: before inserting record into MMTT.
3213: */

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

3216: OR l_Line_rec_Type.transaction_batch_id IS NULL
3217: OR l_current_err_batch_id <> l_Line_rec_Type.transaction_batch_id )THEN --050
3218: l_current_batch_failed := FALSE;
3219: FOR z1_rec IN
3220: Z1(inv_txn_manager_grp.gi_flow_schedule,l_Line_rec_type) LOOP
3221:
3222: tree_exists := FALSE;
3223:
3224: IF (l_debug = 1) THEN

Line 4326: inv_txn_manager_grp.tmpinsert2(

4322: , 'INV_TXN_MANAGER_PUB'
4323: , 9
4324: );
4325: END IF;
4326: inv_txn_manager_grp.tmpinsert2(
4327: x_return_status => x_return_status
4328: , x_msg_count => x_msg_count
4329: , x_msg_data => x_msg_data
4330: , x_validation_status => l_validation_status

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

4422: COMMIT WORK; /* Commit after validating all MTI records */
4423: END IF;
4424:
4425: /* Delete the errored out flow schedules */
4426: IF (inv_txn_manager_grp.gi_flow_schedule <> 0)
4427: THEN
4428: wip_flow_utilities.delete_flow_schedules (l_header_id);
4429: END IF;
4430:

Line 6201: , inv_txn_manager_grp.gi_flow_schedule

6197: --qty-tree validation
6198: IF ((NOT post_temp_validation (l_line_rec_type
6199: , 1 --always validate it
6200: , l_userid
6201: , inv_txn_manager_grp.gi_flow_schedule
6202: , l_lotnum -- Added for 4377625
6203: )
6204: )
6205: )