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 2198: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2194: l_rsv_wip_entity_type NUMBER := NULL; -- Bug 6454464
2195: l_rsv_wip_job_type VARCHAR2(15); -- Bug 6454464
2196:
2197: BEGIN
2198: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2199: l_header_id := p_header_id;
2200:
2201: --dbms_output.put_line(' came to process_trx');
2202: IF (l_debug = 1)

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

2606: /*Bug 3947667, enabling it irrespective of patchset */
2607:
2608: -- IF (INV_CONTROL.G_CURRENT_RELEASE_LEVEL >= INV_RELEASE.G_J_RELEASE_LEVEL) THEN
2609: BEGIN
2610: l_batch_size := NVL (fnd_profile.VALUE ('INV_BATCH_SIZE'), 0);
2611: EXCEPTION
2612: WHEN VALUE_ERROR
2613: THEN
2614: l_batch_size := 0;

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

3578: 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
3579: -- It is a backflush transaction. Get the
3580: -- override flag.
3581: l_override_neg_for_backflush :=
3582: fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');
3583: /*Bug 4764343 Base Bug:4645686. Introducing a new profile 'INV_OVERRIDE_RSV_FOR_BACKFLUSH'
3584: for a specific customer.If set to 'Yes', backflush transaction can drive inventory negative,
3585: even if any reservations exist for the item*/
3586: l_override_rsv_for_backflush := NVL(fnd_profile.value('INV_OVERRIDE_RSV_FOR_BACKFLUSH'), 2);

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

3582: fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');
3583: /*Bug 4764343 Base Bug:4645686. Introducing a new profile 'INV_OVERRIDE_RSV_FOR_BACKFLUSH'
3584: for a specific customer.If set to 'Yes', backflush transaction can drive inventory negative,
3585: even if any reservations exist for the item*/
3586: l_override_rsv_for_backflush := NVL(fnd_profile.value('INV_OVERRIDE_RSV_FOR_BACKFLUSH'), 2);
3587: ELSE
3588: l_override_neg_for_backflush := 0;
3589: l_override_rsv_for_backflush := 2;
3590: END IF;

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

5159: l_progress_indicator VARCHAR2(30) := '0';
5160:
5161: BEGIN
5162: IF (l_debug IS NULL) THEN
5163: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
5164: END IF;
5165:
5166: IF (l_debug = 1) THEN
5167: inv_log_util.TRACE ('$Header: INVTXMGB.pls 120.28 2007/11/12 22:43:39 yssingh ship $' , l_procedure_name , 9);

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

5698: l_progress_indicator VARCHAR2(20) := '0';
5699: BEGIN
5700:
5701: IF (l_debug IS NULL) THEN
5702: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5703: END IF;
5704:
5705: IF (l_debug = 1) THEN
5706: inv_log_util.TRACE ('$Header: INVTXMGB.pls 120.28 2007/11/12 22:43:39 yssingh ship $', l_procedure_name,9);

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

5707: END IF;
5708:
5709:
5710: IF (g_userid IS NULL) THEN
5711: g_userid := NVL (fnd_profile.VALUE ('USER_ID'), -1);
5712: END IF;
5713:
5714: l_userid := g_userid;
5715: l_loginid := NVL(fnd_global.login_id, -1);