DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on FND_PROFILE

Line 1407: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1403: l_msg_data VARCHAR2 (2000);
1404: BEGIN
1405: IF (l_debug IS NULL)
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

Line 1608: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1604: l_count NUMBER;
1605: BEGIN
1606: IF (l_debug IS NULL)
1607: THEN
1608: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1609: END IF;
1610:
1611: fnd_flex_key_api.set_session_mode ('seed_data');
1612:

Line 1677: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1673: l_error_flag VARCHAR2 (2);
1674: BEGIN
1675: IF (l_debug IS NULL)
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

Line 1747: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1743: acct_period_id NUMBER; /* period_close_id of current period */
1744: BEGIN
1745: IF (l_debug IS NULL)
1746: THEN
1747: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1748: END IF;
1749:
1750: acct_period_id := 0; /* default value */
1751:

Line 1798: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1794: l_return BOOLEAN := TRUE;
1795: BEGIN
1796: IF (l_debug IS NULL)
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:

Line 1885: SELECT fnd_profile.VALUE (p_prof)

1881: ******************************************************************/
1882: PROCEDURE poget (p_prof IN VARCHAR2, x_ret OUT NOCOPY VARCHAR2)
1883: IS
1884: BEGIN
1885: SELECT fnd_profile.VALUE (p_prof)
1886: INTO x_ret
1887: FROM DUAL;
1888: END poget;
1889:

Line 2214: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2210: l_rsv_wip_entity_type NUMBER := NULL; -- Bug 6454464
2211: l_rsv_wip_job_type VARCHAR2(15); -- Bug 6454464
2212:
2213: BEGIN
2214: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2215: l_header_id := p_header_id;
2216:
2217: --dbms_output.put_line(' came to process_trx');
2218: IF (l_debug = 1)

Line 2626: l_batch_size := NVL (fnd_profile.VALUE ('INV_BATCH_SIZE'), 0);

2622: /*Bug 3947667, enabling it irrespective of patchset */
2623:
2624: -- IF (INV_CONTROL.G_CURRENT_RELEASE_LEVEL >= INV_RELEASE.G_J_RELEASE_LEVEL) THEN
2625: BEGIN
2626: l_batch_size := NVL (fnd_profile.VALUE ('INV_BATCH_SIZE'), 0);
2627: EXCEPTION
2628: WHEN VALUE_ERROR
2629: THEN
2630: l_batch_size := 0;

Line 3701: fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');

3697: 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
3698: -- It is a backflush transaction. Get the
3699: -- override flag.
3700: l_override_neg_for_backflush :=
3701: fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');
3702: /*Bug 4764343 Base Bug:4645686. Introducing a new profile 'INV_OVERRIDE_RSV_FOR_BACKFLUSH'
3703: for a specific customer.If set to 'Yes', backflush transaction can drive inventory negative,
3704: even if any reservations exist for the item*/
3705: l_override_rsv_for_backflush := NVL(fnd_profile.value('INV_OVERRIDE_RSV_FOR_BACKFLUSH'), 2);

Line 3705: l_override_rsv_for_backflush := NVL(fnd_profile.value('INV_OVERRIDE_RSV_FOR_BACKFLUSH'), 2);

3701: fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');
3702: /*Bug 4764343 Base Bug:4645686. Introducing a new profile 'INV_OVERRIDE_RSV_FOR_BACKFLUSH'
3703: for a specific customer.If set to 'Yes', backflush transaction can drive inventory negative,
3704: even if any reservations exist for the item*/
3705: l_override_rsv_for_backflush := NVL(fnd_profile.value('INV_OVERRIDE_RSV_FOR_BACKFLUSH'), 2);
3706: ELSE
3707: l_override_neg_for_backflush := 0;
3708: l_override_rsv_for_backflush := 2;
3709: END IF;

Line 5306: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

5302: l_override_rsv NUMBER := 2;
5303:
5304: BEGIN
5305: IF (l_debug IS NULL) THEN
5306: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
5307: END IF;
5308:
5309: IF (l_debug = 1) THEN
5310: inv_log_util.TRACE ('$Header: INVTXMGB.pls 120.33.12020000.3 2013/03/06 11:20:01 skommine ship $' , l_procedure_name , 9);

Line 5541: l_override_rsv := NVL(fnd_profile.value('INV_OVERRIDE_RSV_FOR_BACKFLUSH'), 2);

5537: END IF;
5538:
5539: /* Bug: 3462946 : Added the code below to check for Negative Balances for a Negative Balances Allowed Org */
5540: --Bug 8571657
5541: l_override_rsv := NVL(fnd_profile.value('INV_OVERRIDE_RSV_FOR_BACKFLUSH'), 2);
5542: IF l_att < 0 THEN
5543: l_progress_indicator := '120';
5544: inv_log_util.TRACE ('l_att is than zero', l_procedure_name, 9);
5545:

Line 5898: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

5894: l_progress_indicator VARCHAR2(20) := '0';
5895: BEGIN
5896:
5897: IF (l_debug IS NULL) THEN
5898: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5899: END IF;
5900:
5901: IF (l_debug = 1) THEN
5902: inv_log_util.TRACE ('$Header: INVTXMGB.pls 120.33.12020000.3 2013/03/06 11:20:01 skommine ship $', l_procedure_name,9);

Line 5907: g_userid := NVL (fnd_profile.VALUE ('USER_ID'), -1);

5903: END IF;
5904:
5905:
5906: IF (g_userid IS NULL) THEN
5907: g_userid := NVL (fnd_profile.VALUE ('USER_ID'), -1);
5908: END IF;
5909:
5910: l_userid := g_userid;
5911: l_loginid := NVL(fnd_global.login_id, -1);