DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on FND_GLOBAL

Line 17: FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language);

13: IS
14: PRAGMA AUTONOMOUS_TRANSACTION;
15: BEGIN
16: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.set_nls');
17: FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language);
18: INV_EBI_UTIL.debug_line('STEP 20 :END INSIDE INV_EBI_ITEM_HELPER.set_nls');
19: commit;
20: END ;
21:

Line 2445: l_orig_nls_lang := FND_GLOBAL.nls_language();

2441: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
2442:
2443: l_item.main_obj_type.inventory_item_id := x_out.inventory_item_id;
2444:
2445: l_orig_nls_lang := FND_GLOBAL.nls_language();
2446:
2447: FOR i IN 1 .. l_item.main_obj_type.item_desc_lang_obj_tbl_type.COUNT
2448: LOOP
2449:

Line 2454: --FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language => l_nls_language);Commented for bug14210113

2450: FOR r_get_nls_language IN c_get_nls_language(l_item.main_obj_type.item_desc_lang_obj_tbl_type(i).lang_code)
2451: LOOP
2452:
2453: l_nls_language := r_get_nls_language.nls_language;
2454: --FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language => l_nls_language);Commented for bug14210113
2455:
2456: -- Added for bug 14210113
2457: INV_EBI_UTIL.debug_line('STEP 100: BEFORE CALLING set_nls for language ' || l_nls_language);
2458: set_nls(l_nls_language);

Line 2487: --FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language => l_orig_nls_lang); Commented for bug14210113

2483: x_out.output_status.msg_data := x_out.output_status.msg_data || ' ->Item Number:' || l_item.main_obj_type.item_number || '-> Language code:' || l_item.main_obj_type.item_desc_lang_obj_tbl_type(i).lang_code;
2484:
2485: -- To set back the language to base language
2486:
2487: --FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language => l_orig_nls_lang); Commented for bug14210113
2488:
2489: -- Added for bug 14210113
2490: INV_EBI_UTIL.debug_line('STEP 120: BEFORE CALLING set_nls for setting to original language in case of exception' || l_orig_nls_lang);
2491: set_nls(l_orig_nls_lang);

Line 2504: --FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language => l_orig_nls_lang); --Commented for bug 14210113

2500: END IF;
2501:
2502: -- To set back the language to base language
2503:
2504: --FND_GLOBAL.SET_NLS_CONTEXT(p_nls_language => l_orig_nls_lang); --Commented for bug 14210113
2505:
2506: -- Added for bug 14210113
2507: INV_EBI_UTIL.debug_line('STEP 130: BEFORE CALLING set_nls for setting to original language in case of success' || l_orig_nls_lang);
2508: set_nls(l_orig_nls_lang);

Line 2595: p_created_by => FND_GLOBAL.user_id,

2591: p_attribute15 => NULL,
2592: p_attribute_category => NULL,
2593: p_description => l_item.main_obj_type.description,
2594: p_creation_date => SYSDATE,
2595: p_created_by => FND_GLOBAL.user_id,
2596: p_last_update_date => SYSDATE,
2597: p_last_updated_by => FND_GLOBAL.user_id,
2598: p_last_update_login => FND_GLOBAL.login_id,
2599: p_program_application_id => NULL,

Line 2597: p_last_updated_by => FND_GLOBAL.user_id,

2593: p_description => l_item.main_obj_type.description,
2594: p_creation_date => SYSDATE,
2595: p_created_by => FND_GLOBAL.user_id,
2596: p_last_update_date => SYSDATE,
2597: p_last_updated_by => FND_GLOBAL.user_id,
2598: p_last_update_login => FND_GLOBAL.login_id,
2599: p_program_application_id => NULL,
2600: p_program_id => NULL,
2601: p_program_update_date => SYSDATE,

Line 2598: p_last_update_login => FND_GLOBAL.login_id,

2594: p_creation_date => SYSDATE,
2595: p_created_by => FND_GLOBAL.user_id,
2596: p_last_update_date => SYSDATE,
2597: p_last_updated_by => FND_GLOBAL.user_id,
2598: p_last_update_login => FND_GLOBAL.login_id,
2599: p_program_application_id => NULL,
2600: p_program_id => NULL,
2601: p_program_update_date => SYSDATE,
2602: x_cross_reference_id => l_xref_id);

Line 3040: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'

3036: p_function => 'EGO_EDIT_ITEM'
3037: ,p_object_name => 'EGO_ITEM'
3038: ,p_instance_pk1_value => p_inventory_item_id
3039: ,p_instance_pk2_value => p_organization_id
3040: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
3041: THEN
3042: FND_MESSAGE.set_name('INV','INV_IOI_ITEM_UPDATE_PRIV');
3043: FND_MSG_PUB.add;
3044: RAISE FND_API.g_EXC_ERROR;

Line 3418: ,x_last_updated_by => fnd_global.user_id

3414: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3415: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
3416: ,x_inventory_item_id => p_inventory_item_id
3417: ,x_last_update_date => SYSDATE
3418: ,x_last_updated_by => fnd_global.user_id
3419: ,x_creation_date => SYSDATE
3420: ,x_created_by => fnd_global.user_id
3421: ,x_last_update_login => fnd_global.login_id
3422: ,x_organization_id => p_organization_id

Line 3420: ,x_created_by => fnd_global.user_id

3416: ,x_inventory_item_id => p_inventory_item_id
3417: ,x_last_update_date => SYSDATE
3418: ,x_last_updated_by => fnd_global.user_id
3419: ,x_creation_date => SYSDATE
3420: ,x_created_by => fnd_global.user_id
3421: ,x_last_update_login => fnd_global.login_id
3422: ,x_organization_id => p_organization_id
3423: ,x_description => p_mfg_part_obj.description
3424: ,x_attribute_category => p_mfg_part_obj.attribute_category

Line 3421: ,x_last_update_login => fnd_global.login_id

3417: ,x_last_update_date => SYSDATE
3418: ,x_last_updated_by => fnd_global.user_id
3419: ,x_creation_date => SYSDATE
3420: ,x_created_by => fnd_global.user_id
3421: ,x_last_update_login => fnd_global.login_id
3422: ,x_organization_id => p_organization_id
3423: ,x_description => p_mfg_part_obj.description
3424: ,x_attribute_category => p_mfg_part_obj.attribute_category
3425: ,x_attribute1 => p_mfg_part_obj.attribute1

Line 3450: ,x_last_updated_by => fnd_global.user_id

3446: ,x_manufacturer_id => l_manufacturer_id
3447: ,x_mfg_part_num => l_mfg_part_num
3448: ,x_inventory_item_id => l_inventory_item_id
3449: ,x_last_update_date => SYSDATE
3450: ,x_last_updated_by => fnd_global.user_id
3451: ,x_last_update_login => fnd_global.login_id
3452: ,x_organization_id => l_organization_id
3453: ,x_description => l_description
3454: ,x_attribute_category => l_attribute_category

Line 3451: ,x_last_update_login => fnd_global.login_id

3447: ,x_mfg_part_num => l_mfg_part_num
3448: ,x_inventory_item_id => l_inventory_item_id
3449: ,x_last_update_date => SYSDATE
3450: ,x_last_updated_by => fnd_global.user_id
3451: ,x_last_update_login => fnd_global.login_id
3452: ,x_organization_id => l_organization_id
3453: ,x_description => l_description
3454: ,x_attribute_category => l_attribute_category
3455: ,x_attribute1 => l_attribute1

Line 3485: ,x_last_updated_by => fnd_global.user_id

3481: ,x_manufacturer_id => p_mfg_part_obj.manufacturer_id
3482: ,x_mfg_part_num => p_mfg_part_obj.mfg_part_num
3483: ,x_inventory_item_id => p_inventory_item_id
3484: ,x_last_update_date => SYSDATE
3485: ,x_last_updated_by => fnd_global.user_id
3486: ,x_creation_date => SYSDATE
3487: ,x_created_by => fnd_global.user_id
3488: ,x_last_update_login => fnd_global.login_id
3489: ,x_organization_id => p_organization_id

Line 3487: ,x_created_by => fnd_global.user_id

3483: ,x_inventory_item_id => p_inventory_item_id
3484: ,x_last_update_date => SYSDATE
3485: ,x_last_updated_by => fnd_global.user_id
3486: ,x_creation_date => SYSDATE
3487: ,x_created_by => fnd_global.user_id
3488: ,x_last_update_login => fnd_global.login_id
3489: ,x_organization_id => p_organization_id
3490: ,x_description => p_mfg_part_obj.description
3491: ,x_attribute_category => p_mfg_part_obj.attribute_category

Line 3488: ,x_last_update_login => fnd_global.login_id

3484: ,x_last_update_date => SYSDATE
3485: ,x_last_updated_by => fnd_global.user_id
3486: ,x_creation_date => SYSDATE
3487: ,x_created_by => fnd_global.user_id
3488: ,x_last_update_login => fnd_global.login_id
3489: ,x_organization_id => p_organization_id
3490: ,x_description => p_mfg_part_obj.description
3491: ,x_attribute_category => p_mfg_part_obj.attribute_category
3492: ,x_attribute1 => p_mfg_part_obj.attribute1

Line 3517: ,x_last_updated_by => fnd_global.user_id

3513: ,x_manufacturer_id => l_manufacturer_id
3514: ,x_mfg_part_num => l_mfg_part_num
3515: ,x_inventory_item_id => l_inventory_item_id
3516: ,x_last_update_date => SYSDATE
3517: ,x_last_updated_by => fnd_global.user_id
3518: ,x_last_update_login => fnd_global.login_id
3519: ,x_organization_id => l_organization_id
3520: ,x_description => l_description
3521: ,x_attribute_category => l_attribute_category

Line 3518: ,x_last_update_login => fnd_global.login_id

3514: ,x_mfg_part_num => l_mfg_part_num
3515: ,x_inventory_item_id => l_inventory_item_id
3516: ,x_last_update_date => SYSDATE
3517: ,x_last_updated_by => fnd_global.user_id
3518: ,x_last_update_login => fnd_global.login_id
3519: ,x_organization_id => l_organization_id
3520: ,x_description => l_description
3521: ,x_attribute_category => l_attribute_category
3522: ,x_attribute1 => l_attribute1