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.8.12010000.1 2008/07/25 14:13:39 appldev 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 2713: l_last_updated_by := fnd_global.user_id();

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

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

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

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

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

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

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

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

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

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

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