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

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

11: l_status_before_p1 NUMBER := 0;
12: MSN_UPDATE_FIRST_PASS BOOLEAN := TRUE;
13:
14: PROCEDURE set_firstscan(p_firstscan IN BOOLEAN) IS
15: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
16: BEGIN
17: g_firstscan := p_firstscan;
18: END;
19:

Line 24: -- l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

20: -- Procedure used to trace message for debugging
21: PROCEDURE invtrace(p_msg VARCHAR2 := NULL) IS
22: --Bug: 3772309: Performance bug fix.The fnd call happens everytime
23: -- debug_print is called.
24: -- l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
25: BEGIN
26: -- IF (l_debug = 1) THEN
27: inv_log_util.TRACE(p_msg, 'INVSER', 9);
28: -- END IF;

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

28: -- END IF;
29: END;
30:
31: PROCEDURE populateattributescolumn IS
32: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
33: BEGIN
34: g_serial_attributes_tbl(1).column_name := 'SERIAL_ATTRIBUTE_CATEGORY';
35: g_serial_attributes_tbl(1).column_type := 'VARCHAR2';
36: g_serial_attributes_tbl(2).column_name := 'ORIGINATION_DATE';

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

156: item_count NUMBER;
157: eam_item NUMBER;
158: l_current_status NUMBER;
159: x_object_id NUMBER;
160: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
161: BEGIN
162: -- Standard Start of API savepoint
163: SAVEPOINT apiinsertserial_apipub;
164:

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

440: WHERE transaction_temp_id = p_transaction_temp_id
441: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
442:
443: l_input_idx BINARY_INTEGER;
444: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
445: BEGIN
446: -- Standard Start of API savepoint
447: SAVEPOINT apiinsertserial_apipub;
448:

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

1315: l_current_status NUMBER;
1316: l_group_mark_id NUMBER;
1317: l_api_version CONSTANT NUMBER := 1.0;
1318: l_api_name CONSTANT VARCHAR2(30) := 'insert_range_serial';
1319: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1320: BEGIN
1321: -- invtrace('INV_SERIAL_NUMBER_PUB', 'insert_range_serial - 10');
1322: SAVEPOINT sp_insert_range_serial;
1323:

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

1676: FROM mtl_serial_numbers_temp
1677: WHERE transaction_temp_id = p_serial_temp_id
1678: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
1679:
1680: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1681: BEGIN
1682: -- Standard Start of API savepoint
1683: SAVEPOINT apiupdateserial_apipub;
1684:

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

2167: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2168: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2169:
2170: l_input_idx BINARY_INTEGER;
2171: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2172: BEGIN
2173: -- Standard Start of API savepoint
2174: SAVEPOINT apiinsertserial_apipub;
2175:

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

3083: l_end_ser VARCHAR2(100);
3084: v_retval NUMBER;
3085: ret BOOLEAN;
3086: l_skip_serial NUMBER := 1;
3087: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3088: BEGIN
3089: v_retval :=
3090: generate_serialsj(
3091: p_org_id => p_org_id

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

3158: RETURN NUMBER AS
3159: PRAGMA AUTONOMOUS_TRANSACTION;
3160: l_retval NUMBER;
3161: l_skip_serial NUMBER := NVL(p_skip_serial, 0);
3162: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3163: BEGIN
3164: l_retval :=
3165: generate_serialsj(
3166: p_org_id => p_org_id

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

3297: ) --Bug# 2656316
3298: RETURN NUMBER AS
3299: ret_number NUMBER := 0;
3300: local_locator_id NUMBER;
3301: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3302: BEGIN
3303: IF (l_debug = 1) THEN
3304: inv_trx_util_pub.TRACE('About to call VALIDATE_SERIALSJ ', 'VALIDATE_SERIALS', 9);
3305: END IF;

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

3372: l_status BOOLEAN;
3373: l_count NUMBER := 0;
3374: l_rs_lot_attr_category VARCHAR2(30);
3375: l_st_lot_attr_category VARCHAR2(30);
3376: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3377: BEGIN
3378: IF (l_debug = 1) THEN
3379: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Entered...');
3380: END IF;

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

3842: l_error_code NUMBER;
3843: l_dynamic_ok NUMBER;
3844: l_mask VARCHAR2(17); -- Bug 7427382
3845: l_status BOOLEAN;
3846: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3847: BEGIN
3848: null;
3849:
3850: IF (p_trx_act_id = inv_globals.g_action_stgxfr) THEN

Line 3858: IF nvl(fnd_profile.value('INV_RESTRICT_RCPT_SER'), '2') = '1' THEN

3854: END IF;
3855: RAISE FND_API.g_exc_unexpected_error;
3856: END IF;
3857:
3858: IF nvl(fnd_profile.value('INV_RESTRICT_RCPT_SER'), '2') = '1' THEN
3859: l_acct_prof_Value := 'Y';
3860: else
3861: l_acct_prof_value := 'N';
3862: end if;

Line 4205: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4201: p_xfr_Ser_num_ctrl_code IN NUMBER,
4202: p_isRestrictRcptSerial IN NUMBER
4203: ) return number
4204: IS
4205: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4206: l_groupId NUMBER := 0;
4207: l_newStatus NUMBER := p_curr_status;
4208: l_isRestrictRcptSerial NUMBER := p_isRestrictRcptSerial;
4209: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

4205: --l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4206: l_groupId NUMBER := 0;
4207: l_newStatus NUMBER := p_curr_status;
4208: l_isRestrictRcptSerial NUMBER := p_isRestrictRcptSerial;
4209: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4210:
4211: BEGIN
4212: if( l_debug = 1 ) then
4213: invtrace('inside validate_status, p_trx_src_type_id = ' || p_trx_src_type_id);

Line 4222: --l_isRestrictRcptSerial := fnd_profile.value('INV_RESTRICT_RCPT_SER');

4218: invtrace('inside validate_status, p_xfr_ser_num_ctrl_code = ' || p_xfr_ser_num_ctrl_code);
4219: end if;
4220: l_groupId := getGroupId(p_trx_src_type_id, p_trx_action_id);
4221:
4222: --l_isRestrictRcptSerial := fnd_profile.value('INV_RESTRICT_RCPT_SER');
4223:
4224: /*if( l_debug = 1 ) then
4225: invtrace('l_groupId = ' || l_groupId);
4226: end if;*/

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

4409: l_retval NUMBER := 0;
4410: l_parent_ser_number VARCHAR2(30) := '';
4411: l_isRestrictRcptSerial NUMBER;
4412: l_groupId NUMBER := 0;
4413: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4414: BEGIN
4415: --null;
4416: IF (l_debug = 1) THEN
4417: invtrace('p_trx_src_type_id = ' || p_trx_src_type_id);

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

4898:
4899: l_fm_serial_number VARCHAR2(30) := lpad(p_fm_serial_number, 30);
4900: l_to_serial_number VARCHAR2(30) := lpad(p_to_serial_number, 30);
4901: l_wms_installed BOOLEAN;
4902: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4903: BEGIN
4904: IF (l_debug = 1) THEN
4905: invtrace('Inside InsertRangeUnitTrx');
4906: invtrace('l_fm_serial_number is ' || l_fm_serial_number);