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_COST_GROUP_UPDATE dependencies on FND_PROFILE

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

34: AND current_organization_id = cp_organization_id;
35:
36: procedure print_debug(p_message in VARCHAR2) IS
37:
38: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
39: begin
40: IF (l_debug = 1) THEN
41: inv_log_util.trace(p_message, 'INV_COST_GROUP_UPDATE', 9);
42: END IF;

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

60: IS
61: l_transfer_cost_group_id NUMBER := NULL;
62: x_valid VARCHAR2(1) := 'Y';
63:
64: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
65: BEGIN
66: IF (l_debug = 1) THEN
67: print_debug('in proc_update_mmtt .. p_transaction_temp_id : '|| p_transaction_temp_id );
68: print_debug('in proc_update_mmtt .. p_cost_group_id : '|| p_cost_group_id );

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

153: p_to_serial_number IN VARCHAR2,
154: x_return_status OUT NOCOPY VARCHAR2)
155: IS
156: x_valid VARCHAR2(1) := 'Y';
157: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
158: BEGIN
159: IF (l_debug = 1) THEN
160: print_debug('in proc_update_msnt .. p_rowid: '|| p_rowid );
161: print_debug('in proc_update_msnt .. p_new_transaction_temp_id: '|| p_new_transaction_temp_id );

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

199: p_new_serial_trx_temp_id IN NUMBER,
200: x_return_status OUT NOCOPY VARCHAR2)
201: IS
202: x_valid VARCHAR2(1) := 'Y';
203: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
204: BEGIN
205: IF (l_debug = 1) THEN
206: print_debug('in proc_update_mtlt .. p_rowid: '|| p_rowid);
207: print_debug('in proc_update_mtlt .. p_new_transaction_temp_id: '|| p_new_transaction_temp_id );

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

251: p_lpn_id IN NUMBER)
252: RETURN BOOLEAN
253: IS
254: l_onhand NUMBER := 0;
255: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
256: BEGIN
257: BEGIN
258: IF p_lpn_id IS NULL THEN
259: IF p_serial_number IS NULL THEN

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

389: IS
390: l_primary_cost_method NUMBER;
391: l_negative_balances_allowed NUMBER;
392: l_override_neg_for_backflush NUMBER := 0;
393: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
394:
395: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
396: l_msg_data VARCHAR2(255) := NULL;
397: l_msg_count NUMBER;

Line 413: l_override_neg_for_backflush := fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');

409: print_debug('proc_get_default_costgroup.. l_negative_balances_allowed ' || l_negative_balances_allowed);
410: END IF;
411:
412: IF p_is_backflush_txn = TRUE THEN
413: l_override_neg_for_backflush := fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');
414: END IF;
415:
416: IF (l_debug = 1) THEN
417: print_debug('proc_get_default_costgroup.. l_override_neg_for_backflush ' || l_override_neg_for_backflush);

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

533: p_transaction_action_id IN NUMBER,
534: x_cost_group_id OUT NOCOPY NUMBER,
535: x_return_status OUT NOCOPY VARCHAR2)
536: IS
537: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
538: BEGIN
539: IF (l_debug = 1) THEN
540: print_debug('In proc_get_pending_costgroup... ');
541: END IF;

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

803: p_transaction_action_id IN NUMBER,
804: x_cost_group_id OUT NOCOPY NUMBER,
805: x_return_status OUT NOCOPY VARCHAR2)
806: IS
807: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
808: BEGIN
809: IF (l_debug = 1) THEN
810: print_debug( 'In proc_get_costgroup... ');
811: print_debug('p_organization_id'||p_organization_id);

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

991: p_is_backflush_txn IN BOOLEAN,
992: x_cost_group_id OUT NOCOPY NUMBER,
993: x_return_status OUT NOCOPY VARCHAR2)
994: IS
995: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
996: BEGIN
997: proc_get_costgroup(p_organization_id => p_organization_id,
998: p_inventory_item_id => p_inventory_item_id,
999: p_subinventory_code => p_subinventory_code,

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

1038: p_new_txn_temp_id IN NUMBER,
1039: x_return_status OUT NOCOPY VARCHAR2)
1040: IS
1041: l_api_name CONSTANT VARCHAR2(100) := 'proc_insert_msnt';
1042: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1043: BEGIN
1044: x_return_status := fnd_api.g_ret_sts_success;
1045: SAVEPOINT sp_proc_insert_msnt;
1046: IF (l_debug = 1) THEN

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

1231: p_txn_qty IN NUMBER,
1232: p_new_serial_trx_temp_id IN NUMBER,
1233: x_return_status OUT NOCOPY VARCHAR2)
1234: IS
1235: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1236: BEGIN
1237: x_return_status := fnd_api.g_ret_sts_success;
1238: SAVEPOINT sp_proc_insert_mtlt;
1239:

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

1462: l_comingling_occurs VARCHAR2(1) := 'N';
1463: l_msg_data VARCHAR2(255) := NULL;
1464: l_msg_count NUMBER := NULL;
1465:
1466: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1467: BEGIN
1468: x_return_status := fnd_api.g_ret_sts_success;
1469: IF (l_debug = 1) THEN
1470: print_debug( 'Begin proc_insert_mmtt: action_id: ' || p_mmtt_rec.transaction_action_id );

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

2035: l_cost_group_id NUMBER := -99999;
2036: l_lpn_id NUMBER := p_mmtt_rec.lpn_id;
2037: l_onhand_exists BOOLEAN := TRUE;
2038: l_is_backflush_txn BOOLEAN := FALSE;
2039: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2040: BEGIN
2041: x_return_status := fnd_api.g_ret_sts_success;
2042: IF (l_debug = 1) THEN
2043: print_debug( 'in proc_process_nocontrol p_mmtt_rec.transaction_temp_id:' || p_mmtt_rec.transaction_temp_id || ':');

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

2266: l_onhand_exists BOOLEAN;
2267: l_is_backflush_txn BOOLEAN := FALSE;
2268: l_lpn_id NUMBER := p_mmtt_rec.lpn_id;
2269:
2270: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2271: BEGIN
2272: x_return_status := fnd_api.g_ret_sts_success;
2273: SAVEPOINT sp_proc_process_lots;
2274:

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

2643: l_fm_ser_length NUMBER := NULL;
2644: l_to_temp_prefix VARCHAR2(30) := NULL;
2645: l_to_ser_number NUMBER := NULL;
2646: --Bug 3686015 fix
2647: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2648: BEGIN
2649: x_return_status := fnd_api.g_ret_sts_success;
2650: SAVEPOINT sp_proc_process_serial;
2651:

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

3192: call_lot_control BOOLEAN := FALSE;
3193:
3194: l_onhand_exists BOOLEAN;
3195: l_lpn_id NUMBER := p_mmtt_rec.lpn_id;
3196: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3197: l_last NUMBER;
3198: lot_cgi NUMBER;
3199:
3200: --Bug 3686015 fix

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

3893: l_onhand_exists BOOLEAN := TRUE;
3894: l_is_backflush_txn BOOLEAN := FALSE;
3895: l_lot_number VARCHAR2(80); --- BUG#4291891 Joe DiIorio 04/08/2005
3896: l_transfer_cost_group_id NUMBER;
3897: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3898: BEGIN
3899: -- Standard Start of API savepoint
3900:
3901: SAVEPOINT API_updatecostgroups;