DBA Data[Home] [Help]

APPS.FND_FLEX_DSC_API dependencies on FND_GLOBAL

Line 17: chr_newline VARCHAR2(8) := fnd_global.newline;

13: who_mode VARCHAR2(1000) := NULL; /* whether customer_data or seed_data */
14: debug_mode_on BOOLEAN := FALSE;
15: do_validation BOOLEAN := TRUE;
16: internal_messages VARCHAR2(10000);
17: chr_newline VARCHAR2(8) := fnd_global.newline;
18:
19: -- The following subtypes are used in the APIs rename_dff and migrate_dff
20: SUBTYPE fnd_app_type IS fnd_application%ROWTYPE;
21: SUBTYPE fnd_tbl_type IS fnd_tables%ROWTYPE;

Line 37: --cur_lang fnd_languages.nls_language%TYPE := fnd_global.current_language;

33: error_col_wrong_size CONSTANT NUMBER := -20009;
34: error_srs_dff CONSTANT NUMBER := -20009;
35: error_others CONSTANT NUMBER := -20100;
36:
37: --cur_lang fnd_languages.nls_language%TYPE := fnd_global.current_language;
38: --cur_lang fnd_languages.language_code%TYPE := userenv('LANG');
39: CURSOR lang_cur IS
40: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
41: language_code

Line 69: internal_messages := internal_messages || msg || fnd_global.newline;

65:
66:
67: PROCEDURE message(msg VARCHAR2) IS
68: BEGIN
69: internal_messages := internal_messages || msg || fnd_global.newline;
70: -- internal_messages := internal_messages || Sqlerrm; /* error stamp */
71: END;
72:
73: PROCEDURE message_init IS

Line 2714: l_last_updated_by := fnd_global.user_id();

2710: l_last_updated_by fnd_descriptive_flexs.last_updated_by%TYPE;
2711: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2712: BEGIN
2713: l_last_update_date := SYSDATE;
2714: l_last_updated_by := fnd_global.user_id();
2715: l_last_update_login := fnd_global.login_id();
2716:
2717: -- If l_last_updated_by IS NULL or equals to -1 or l_last_update_login IS NULL then ask user to set context
2718: IF ((l_last_updated_by IS NULL) OR (l_last_updated_by = -1)) OR (l_last_update_login IS NULL) THEN

Line 2715: l_last_update_login := fnd_global.login_id();

2711: l_last_update_login fnd_descriptive_flexs.last_update_login%TYPE;
2712: BEGIN
2713: l_last_update_date := SYSDATE;
2714: l_last_updated_by := fnd_global.user_id();
2715: l_last_update_login := fnd_global.login_id();
2716:
2717: -- If l_last_updated_by IS NULL or equals to -1 or l_last_update_login IS NULL then ask user to set context
2718: IF ((l_last_updated_by IS NULL) OR (l_last_updated_by = -1)) OR (l_last_update_login IS NULL) THEN
2719: l_error_message := 'Application Security Context is not set.Please set the context using fnd_global.apps_initialize() and try again.';

Line 2719: l_error_message := 'Application Security Context is not set.Please set the context using fnd_global.apps_initialize() and try again.';

2715: l_last_update_login := fnd_global.login_id();
2716:
2717: -- If l_last_updated_by IS NULL or equals to -1 or l_last_update_login IS NULL then ask user to set context
2718: IF ((l_last_updated_by IS NULL) OR (l_last_updated_by = -1)) OR (l_last_update_login IS NULL) THEN
2719: l_error_message := 'Application Security Context is not set.Please set the context using fnd_global.apps_initialize() and try again.';
2720: RAISE_APPLICATION_ERROR(error_context_not_set, l_error_message, TRUE);
2721: END IF;
2722:
2723: -- make sure the old and new dff names are different

Line 2932: l_last_updated_by := fnd_global.user_id();

2928: ORDER BY old.column_sequence;
2929:
2930: BEGIN
2931: l_last_update_date := SYSDATE;
2932: l_last_updated_by := fnd_global.user_id();
2933: l_last_update_login := fnd_global.login_id();
2934:
2935: -- If l_last_updated_by IS NULL or equals to -1 or l_last_update_login IS NULL then ask user to set context
2936: IF ((l_last_updated_by IS NULL) OR (l_last_updated_by = -1)) OR (l_last_update_login IS NULL) THEN

Line 2933: l_last_update_login := fnd_global.login_id();

2929:
2930: BEGIN
2931: l_last_update_date := SYSDATE;
2932: l_last_updated_by := fnd_global.user_id();
2933: l_last_update_login := fnd_global.login_id();
2934:
2935: -- If l_last_updated_by IS NULL or equals to -1 or l_last_update_login IS NULL then ask user to set context
2936: IF ((l_last_updated_by IS NULL) OR (l_last_updated_by = -1)) OR (l_last_update_login IS NULL) THEN
2937: l_error_message := 'Application Security Context not set.Please set the context using fnd_global.apps_initialize() and try again.';

Line 2937: l_error_message := 'Application Security Context not set.Please set the context using fnd_global.apps_initialize() and try again.';

2933: l_last_update_login := fnd_global.login_id();
2934:
2935: -- If l_last_updated_by IS NULL or equals to -1 or l_last_update_login IS NULL then ask user to set context
2936: IF ((l_last_updated_by IS NULL) OR (l_last_updated_by = -1)) OR (l_last_update_login IS NULL) THEN
2937: l_error_message := 'Application Security Context not set.Please set the context using fnd_global.apps_initialize() and try again.';
2938: RAISE_APPLICATION_ERROR(error_context_not_set, l_error_message, TRUE);
2939: END IF;
2940:
2941: IF p_descriptive_flexfield_name LIKE '$SRS$.%' THEN