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 1697: X_LAST_UPDATED_BY => fnd_global.user_id,

1693: X_ATTRIBUTE13 => l_category_rec.attribute13,
1694: X_ATTRIBUTE14 => l_category_rec.attribute14,
1695: X_ATTRIBUTE15 => l_category_rec.attribute15,
1696: X_LAST_UPDATE_DATE => l_sys_date,
1697: X_LAST_UPDATED_BY => fnd_global.user_id,
1698: X_CREATION_DATE => l_sys_date,
1699: X_CREATED_BY => fnd_global.user_id,
1700: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1701: );

Line 1699: X_CREATED_BY => fnd_global.user_id,

1695: X_ATTRIBUTE15 => l_category_rec.attribute15,
1696: X_LAST_UPDATE_DATE => l_sys_date,
1697: X_LAST_UPDATED_BY => fnd_global.user_id,
1698: X_CREATION_DATE => l_sys_date,
1699: X_CREATED_BY => fnd_global.user_id,
1700: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1701: );
1702:
1703: IF (l_debug = 1) THEN

Line 1700: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1696: X_LAST_UPDATE_DATE => l_sys_date,
1697: X_LAST_UPDATED_BY => fnd_global.user_id,
1698: X_CREATION_DATE => l_sys_date,
1699: X_CREATED_BY => fnd_global.user_id,
1700: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1701: );
1702:
1703: IF (l_debug = 1) THEN
1704: mdebug('Created New CCID/Category_ID : '|| l_category_id);

Line 1914: X_LAST_UPDATED_BY => fnd_global.user_id,

1910: X_ATTRIBUTE13 => l_category_rec.attribute13,
1911: X_ATTRIBUTE14 => l_category_rec.attribute14,
1912: X_ATTRIBUTE15 => l_category_rec.attribute15,
1913: X_LAST_UPDATE_DATE => sysdate,
1914: X_LAST_UPDATED_BY => fnd_global.user_id,
1915: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1916: );
1917:
1918: IF (l_debug = 1) THEN

Line 1915: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1911: X_ATTRIBUTE14 => l_category_rec.attribute14,
1912: X_ATTRIBUTE15 => l_category_rec.attribute15,
1913: X_LAST_UPDATE_DATE => sysdate,
1914: X_LAST_UPDATED_BY => fnd_global.user_id,
1915: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1916: );
1917:
1918: IF (l_debug = 1) THEN
1919: mdebug('Updated Category: '||To_char(l_category_rec.category_id));

Line 2038: last_updated_by = fnd_global.user_id,

2034: UPDATE mtl_categories_tl
2035: SET
2036: description = p_description,
2037: last_update_date = Sysdate,
2038: last_updated_by = fnd_global.user_id,
2039: last_update_login = fnd_global.login_id,
2040: source_lang = userenv('LANG')
2041: WHERE category_id = p_category_id
2042: AND userenv('LANG') IN (language, source_lang) ;

Line 2039: last_update_login = fnd_global.login_id,

2035: SET
2036: description = p_description,
2037: last_update_date = Sysdate,
2038: last_updated_by = fnd_global.user_id,
2039: last_update_login = fnd_global.login_id,
2040: source_lang = userenv('LANG')
2041: WHERE category_id = p_category_id
2042: AND userenv('LANG') IN (language, source_lang) ;
2043:

Line 2765: l_user_id := fnd_global.user_id;

2761: ) THEN
2762: IF l_debug = 1 THEN
2763: mdebug('Create_Valid_Category: Inserting data into category sets ');
2764: END IF;
2765: l_user_id := fnd_global.user_id;
2766: l_login_id := fnd_global.login_id;
2767: IF l_login_id = -1 THEN
2768: l_login_id := fnd_global.conc_login_id;
2769: END IF;

Line 2766: l_login_id := fnd_global.login_id;

2762: IF l_debug = 1 THEN
2763: mdebug('Create_Valid_Category: Inserting data into category sets ');
2764: END IF;
2765: l_user_id := fnd_global.user_id;
2766: l_login_id := fnd_global.login_id;
2767: IF l_login_id = -1 THEN
2768: l_login_id := fnd_global.conc_login_id;
2769: END IF;
2770: l_request_id := fnd_global.conc_request_id;

Line 2768: l_login_id := fnd_global.conc_login_id;

2764: END IF;
2765: l_user_id := fnd_global.user_id;
2766: l_login_id := fnd_global.login_id;
2767: IF l_login_id = -1 THEN
2768: l_login_id := fnd_global.conc_login_id;
2769: END IF;
2770: l_request_id := fnd_global.conc_request_id;
2771: l_prog_appl_id := fnd_global.prog_appl_id;
2772: l_program_id := fnd_global.conc_program_id;

Line 2770: l_request_id := fnd_global.conc_request_id;

2766: l_login_id := fnd_global.login_id;
2767: IF l_login_id = -1 THEN
2768: l_login_id := fnd_global.conc_login_id;
2769: END IF;
2770: l_request_id := fnd_global.conc_request_id;
2771: l_prog_appl_id := fnd_global.prog_appl_id;
2772: l_program_id := fnd_global.conc_program_id;
2773: INSERT INTO mtl_category_set_valid_cats
2774: ( category_set_id

Line 2771: l_prog_appl_id := fnd_global.prog_appl_id;

2767: IF l_login_id = -1 THEN
2768: l_login_id := fnd_global.conc_login_id;
2769: END IF;
2770: l_request_id := fnd_global.conc_request_id;
2771: l_prog_appl_id := fnd_global.prog_appl_id;
2772: l_program_id := fnd_global.conc_program_id;
2773: INSERT INTO mtl_category_set_valid_cats
2774: ( category_set_id
2775: , category_id

Line 2772: l_program_id := fnd_global.conc_program_id;

2768: l_login_id := fnd_global.conc_login_id;
2769: END IF;
2770: l_request_id := fnd_global.conc_request_id;
2771: l_prog_appl_id := fnd_global.prog_appl_id;
2772: l_program_id := fnd_global.conc_program_id;
2773: INSERT INTO mtl_category_set_valid_cats
2774: ( category_set_id
2775: , category_id
2776: , parent_category_id

Line 2939: l_user_id := fnd_global.user_id;

2935: ,p_category_id => p_category_id
2936: ,p_parent_category_id => p_parent_category_id
2937: ,p_calling_api => l_api_name
2938: ) THEN
2939: l_user_id := fnd_global.user_id;
2940: l_login_id := fnd_global.login_id;
2941: IF l_login_id = -1 THEN
2942: l_login_id := fnd_global.conc_login_id;
2943: END IF;

Line 2940: l_login_id := fnd_global.login_id;

2936: ,p_parent_category_id => p_parent_category_id
2937: ,p_calling_api => l_api_name
2938: ) THEN
2939: l_user_id := fnd_global.user_id;
2940: l_login_id := fnd_global.login_id;
2941: IF l_login_id = -1 THEN
2942: l_login_id := fnd_global.conc_login_id;
2943: END IF;
2944: IF l_debug = 1 THEN

Line 2942: l_login_id := fnd_global.conc_login_id;

2938: ) THEN
2939: l_user_id := fnd_global.user_id;
2940: l_login_id := fnd_global.login_id;
2941: IF l_login_id = -1 THEN
2942: l_login_id := fnd_global.conc_login_id;
2943: END IF;
2944: IF l_debug = 1 THEN
2945: mdebug('Update_Valid_Category: About to update the category record');
2946: END IF;