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_ITEM_CATEGORY_PUB dependencies on FND_GLOBAL

Line 507: fnd_global.apps_initialize(1068, 20634, 401);

503: IS
504: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
505: BEGIN
506: -- To set the APPS Environment context through PL/SQL.
507: fnd_global.apps_initialize(1068, 20634, 401);
508: IF (l_debug = 1) THEN
509: mdebug('User ID :'||to_char(FND_GLOBAL.user_id));
510: mdebug('User NAME :'||FND_GLOBAL.user_name);
511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));

Line 509: mdebug('User ID :'||to_char(FND_GLOBAL.user_id));

505: BEGIN
506: -- To set the APPS Environment context through PL/SQL.
507: fnd_global.apps_initialize(1068, 20634, 401);
508: IF (l_debug = 1) THEN
509: mdebug('User ID :'||to_char(FND_GLOBAL.user_id));
510: mdebug('User NAME :'||FND_GLOBAL.user_name);
511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));
512: mdebug('Prog Appl ID :'||to_char(FND_GLOBAL.prog_appl_id));
513: mdebug('Application Name :'||FND_GLOBAL.application_name);

Line 510: mdebug('User NAME :'||FND_GLOBAL.user_name);

506: -- To set the APPS Environment context through PL/SQL.
507: fnd_global.apps_initialize(1068, 20634, 401);
508: IF (l_debug = 1) THEN
509: mdebug('User ID :'||to_char(FND_GLOBAL.user_id));
510: mdebug('User NAME :'||FND_GLOBAL.user_name);
511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));
512: mdebug('Prog Appl ID :'||to_char(FND_GLOBAL.prog_appl_id));
513: mdebug('Application Name :'||FND_GLOBAL.application_name);
514: mdebug('Language :'||FND_GLOBAL.current_language);

Line 511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));

507: fnd_global.apps_initialize(1068, 20634, 401);
508: IF (l_debug = 1) THEN
509: mdebug('User ID :'||to_char(FND_GLOBAL.user_id));
510: mdebug('User NAME :'||FND_GLOBAL.user_name);
511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));
512: mdebug('Prog Appl ID :'||to_char(FND_GLOBAL.prog_appl_id));
513: mdebug('Application Name :'||FND_GLOBAL.application_name);
514: mdebug('Language :'||FND_GLOBAL.current_language);
515: mdebug('And many more...');

Line 512: mdebug('Prog Appl ID :'||to_char(FND_GLOBAL.prog_appl_id));

508: IF (l_debug = 1) THEN
509: mdebug('User ID :'||to_char(FND_GLOBAL.user_id));
510: mdebug('User NAME :'||FND_GLOBAL.user_name);
511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));
512: mdebug('Prog Appl ID :'||to_char(FND_GLOBAL.prog_appl_id));
513: mdebug('Application Name :'||FND_GLOBAL.application_name);
514: mdebug('Language :'||FND_GLOBAL.current_language);
515: mdebug('And many more...');
516: END IF;

Line 513: mdebug('Application Name :'||FND_GLOBAL.application_name);

509: mdebug('User ID :'||to_char(FND_GLOBAL.user_id));
510: mdebug('User NAME :'||FND_GLOBAL.user_name);
511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));
512: mdebug('Prog Appl ID :'||to_char(FND_GLOBAL.prog_appl_id));
513: mdebug('Application Name :'||FND_GLOBAL.application_name);
514: mdebug('Language :'||FND_GLOBAL.current_language);
515: mdebug('And many more...');
516: END IF;
517: END Apps_Initialize;

Line 514: mdebug('Language :'||FND_GLOBAL.current_language);

510: mdebug('User NAME :'||FND_GLOBAL.user_name);
511: mdebug('Login ID :'||to_char(FND_GLOBAL.login_id));
512: mdebug('Prog Appl ID :'||to_char(FND_GLOBAL.prog_appl_id));
513: mdebug('Application Name :'||FND_GLOBAL.application_name);
514: mdebug('Language :'||FND_GLOBAL.current_language);
515: mdebug('And many more...');
516: END IF;
517: END Apps_Initialize;
518: */

Line 1716: X_LAST_UPDATED_BY => fnd_global.user_id,

1712: X_ATTRIBUTE13 => l_category_rec.attribute13,
1713: X_ATTRIBUTE14 => l_category_rec.attribute14,
1714: X_ATTRIBUTE15 => l_category_rec.attribute15,
1715: X_LAST_UPDATE_DATE => l_sys_date,
1716: X_LAST_UPDATED_BY => fnd_global.user_id,
1717: X_CREATION_DATE => l_sys_date,
1718: X_CREATED_BY => fnd_global.user_id,
1719: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1720: );

Line 1718: X_CREATED_BY => fnd_global.user_id,

1714: X_ATTRIBUTE15 => l_category_rec.attribute15,
1715: X_LAST_UPDATE_DATE => l_sys_date,
1716: X_LAST_UPDATED_BY => fnd_global.user_id,
1717: X_CREATION_DATE => l_sys_date,
1718: X_CREATED_BY => fnd_global.user_id,
1719: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1720: );
1721:
1722: IF (l_debug = 1) THEN

Line 1719: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1715: X_LAST_UPDATE_DATE => l_sys_date,
1716: X_LAST_UPDATED_BY => fnd_global.user_id,
1717: X_CREATION_DATE => l_sys_date,
1718: X_CREATED_BY => fnd_global.user_id,
1719: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1720: );
1721:
1722: IF (l_debug = 1) THEN
1723: mdebug('Created New CCID/Category_ID : '|| l_category_id);

Line 1933: X_LAST_UPDATED_BY => fnd_global.user_id,

1929: X_ATTRIBUTE13 => l_category_rec.attribute13,
1930: X_ATTRIBUTE14 => l_category_rec.attribute14,
1931: X_ATTRIBUTE15 => l_category_rec.attribute15,
1932: X_LAST_UPDATE_DATE => sysdate,
1933: X_LAST_UPDATED_BY => fnd_global.user_id,
1934: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1935: );
1936:
1937: IF (l_debug = 1) THEN

Line 1934: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1930: X_ATTRIBUTE14 => l_category_rec.attribute14,
1931: X_ATTRIBUTE15 => l_category_rec.attribute15,
1932: X_LAST_UPDATE_DATE => sysdate,
1933: X_LAST_UPDATED_BY => fnd_global.user_id,
1934: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1935: );
1936:
1937: IF (l_debug = 1) THEN
1938: mdebug('Updated Category: '||To_char(l_category_rec.category_id));

Line 2057: last_updated_by = fnd_global.user_id,

2053: UPDATE mtl_categories_tl
2054: SET
2055: description = p_description,
2056: last_update_date = Sysdate,
2057: last_updated_by = fnd_global.user_id,
2058: last_update_login = fnd_global.login_id,
2059: source_lang = userenv('LANG')
2060: WHERE category_id = p_category_id
2061: AND userenv('LANG') IN (language, source_lang) ;

Line 2058: last_update_login = fnd_global.login_id,

2054: SET
2055: description = p_description,
2056: last_update_date = Sysdate,
2057: last_updated_by = fnd_global.user_id,
2058: last_update_login = fnd_global.login_id,
2059: source_lang = userenv('LANG')
2060: WHERE category_id = p_category_id
2061: AND userenv('LANG') IN (language, source_lang) ;
2062:

Line 2844: l_user_id := fnd_global.user_id;

2840: ) THEN
2841: IF l_debug = 1 THEN
2842: mdebug('Create_Valid_Category: Inserting data into category sets ');
2843: END IF;
2844: l_user_id := fnd_global.user_id;
2845: l_login_id := fnd_global.login_id;
2846: IF l_login_id = -1 THEN
2847: l_login_id := fnd_global.conc_login_id;
2848: END IF;

Line 2845: l_login_id := fnd_global.login_id;

2841: IF l_debug = 1 THEN
2842: mdebug('Create_Valid_Category: Inserting data into category sets ');
2843: END IF;
2844: l_user_id := fnd_global.user_id;
2845: l_login_id := fnd_global.login_id;
2846: IF l_login_id = -1 THEN
2847: l_login_id := fnd_global.conc_login_id;
2848: END IF;
2849: l_request_id := fnd_global.conc_request_id;

Line 2847: l_login_id := fnd_global.conc_login_id;

2843: END IF;
2844: l_user_id := fnd_global.user_id;
2845: l_login_id := fnd_global.login_id;
2846: IF l_login_id = -1 THEN
2847: l_login_id := fnd_global.conc_login_id;
2848: END IF;
2849: l_request_id := fnd_global.conc_request_id;
2850: l_prog_appl_id := fnd_global.prog_appl_id;
2851: l_program_id := fnd_global.conc_program_id;

Line 2849: l_request_id := fnd_global.conc_request_id;

2845: l_login_id := fnd_global.login_id;
2846: IF l_login_id = -1 THEN
2847: l_login_id := fnd_global.conc_login_id;
2848: END IF;
2849: l_request_id := fnd_global.conc_request_id;
2850: l_prog_appl_id := fnd_global.prog_appl_id;
2851: l_program_id := fnd_global.conc_program_id;
2852: INSERT INTO mtl_category_set_valid_cats
2853: ( category_set_id

Line 2850: l_prog_appl_id := fnd_global.prog_appl_id;

2846: IF l_login_id = -1 THEN
2847: l_login_id := fnd_global.conc_login_id;
2848: END IF;
2849: l_request_id := fnd_global.conc_request_id;
2850: l_prog_appl_id := fnd_global.prog_appl_id;
2851: l_program_id := fnd_global.conc_program_id;
2852: INSERT INTO mtl_category_set_valid_cats
2853: ( category_set_id
2854: , category_id

Line 2851: l_program_id := fnd_global.conc_program_id;

2847: l_login_id := fnd_global.conc_login_id;
2848: END IF;
2849: l_request_id := fnd_global.conc_request_id;
2850: l_prog_appl_id := fnd_global.prog_appl_id;
2851: l_program_id := fnd_global.conc_program_id;
2852: INSERT INTO mtl_category_set_valid_cats
2853: ( category_set_id
2854: , category_id
2855: , parent_category_id

Line 3018: l_user_id := fnd_global.user_id;

3014: ,p_category_id => p_category_id
3015: ,p_parent_category_id => p_parent_category_id
3016: ,p_calling_api => l_api_name
3017: ) THEN
3018: l_user_id := fnd_global.user_id;
3019: l_login_id := fnd_global.login_id;
3020: IF l_login_id = -1 THEN
3021: l_login_id := fnd_global.conc_login_id;
3022: END IF;

Line 3019: l_login_id := fnd_global.login_id;

3015: ,p_parent_category_id => p_parent_category_id
3016: ,p_calling_api => l_api_name
3017: ) THEN
3018: l_user_id := fnd_global.user_id;
3019: l_login_id := fnd_global.login_id;
3020: IF l_login_id = -1 THEN
3021: l_login_id := fnd_global.conc_login_id;
3022: END IF;
3023: IF l_debug = 1 THEN

Line 3021: l_login_id := fnd_global.conc_login_id;

3017: ) THEN
3018: l_user_id := fnd_global.user_id;
3019: l_login_id := fnd_global.login_id;
3020: IF l_login_id = -1 THEN
3021: l_login_id := fnd_global.conc_login_id;
3022: END IF;
3023: IF l_debug = 1 THEN
3024: mdebug('Update_Valid_Category: About to update the category record');
3025: END IF;