DBA Data[Home] [Help]

APPS.FEM_ADMIN_UTIL_PKG dependencies on FND_LOG_MESSAGES

Line 27: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

23: -- Logging global temporary tables.
24:
25: PROCEDURE Trunc_Table_Class_Log_Tables (
26: p_tab_name IN VARCHAR2) IS
27: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
28: 'fem.plsql.fem_admin_util_pkg.trunc_table_class_log_tables';
29: BEGIN
30:
31: BEGIN

Line 74: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

70: p_value3 IN VARCHAR2 DEFAULT NULL,
71: p_token4 IN VARCHAR2 DEFAULT NULL,
72: p_value4 IN VARCHAR2 DEFAULT NULL
73: ) IS
74: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
75: 'fem.plsql.fem_admin_util_pkg.log_table_class_error';
76:
77: TYPE msg_array IS VARRAY(8) OF VARCHAR2(2000);
78: tokens_values msg_array;

Line 149: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

145: PROCEDURE Log_Table_Class_Status (
146: p_tab_name IN VARCHAR2,
147: p_tab_class_cd IN VARCHAR2,
148: p_passed_validation IN VARCHAR2) IS
149: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
150: 'fem.plsql.fem_admin_util_pkg.log_table_class_status';
151: BEGIN
152:
153: INSERT INTO fem_tab_class_status_gt

Line 186: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

182: p_tab_name IN VARCHAR2,
183: p_tab_class_cd IN VARCHAR2
184: ) RETURN VARCHAR2
185: AS
186: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
187: 'fem.plsql.fem_admin_util_pkg.create_data_loader_rule';
188:
189: v_count INTEGER;
190: v_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;

Line 364: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

360: p_prop_type IN VARCHAR2,
361: p_col_req_type IN VARCHAR2,
362: x_passed_validation OUT NOCOPY VARCHAR2
363: ) IS
364: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
365: 'fem.plsql.fem_admin_util_pkg.validate_prop_col_req';
366:
367: TYPE CurTyp IS REF CURSOR;
368: cols_cv CurTyp;

Line 716: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

712: p_tab_class_cd IN VARCHAR2,
713: p_tab_owner IN VARCHAR2,
714: p_db_tab_name IN VARCHAR2,
715: x_passed_validation OUT NOCOPY VARCHAR2) IS
716: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
717: 'fem.plsql.fem_admin_util_pkg.validate_pk_cols_not_null';
718:
719: CURSOR c_null_cols (p_tab_name VARCHAR2, p_owner VARCHAR2) IS
720: SELECT a.column_name

Line 794: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

790: PROCEDURE Validate_Editable (
791: p_tab_name IN VARCHAR2,
792: p_tab_class_cd IN VARCHAR2,
793: x_passed_validation OUT NOCOPY VARCHAR2) IS
794: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
795: 'fem.plsql.fem_admin_util_pkg.validate_editable';
796:
797: v_obj_type USER_OBJECTS.object_type%TYPE;
798: v_count NUMBER;

Line 877: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

873: PROCEDURE Validate_Table_Name_Restrict (
874: p_tab_name IN VARCHAR2,
875: p_tab_class_cd IN VARCHAR2,
876: x_passed_validation OUT NOCOPY VARCHAR2) IS
877: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
878: 'fem.plsql.fem_admin_util_pkg.validate_table_name_restriction';
879: BEGIN
880: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
881: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 958: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

954: p_tab_class_cd IN VARCHAR2,
955: p_tab_owner IN VARCHAR2,
956: p_db_tab_name IN VARCHAR2,
957: x_passed_validation OUT NOCOPY VARCHAR2) IS
958: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
959: 'fem.plsql.fem_admin_util_pkg.validate_data_loader';
960:
961: CURSOR c_uniq_idx(p_owner VARCHAR2, p_name VARCHAR2) IS
962: SELECT index_name

Line 1501: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1497: x_msg_data OUT NOCOPY VARCHAR2,
1498: p_object_id IN NUMBER
1499: ) IS
1500:
1501: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1502: 'fem.plsql.fem_admin_util_pkg.delete_obj_tuning_options';
1503: C_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Obj_Tuning_Options';
1504:
1505: v_process_ds_cd NUMBER;

Line 1673: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1669: p_db_tab_name IN VARCHAR2,
1670: x_passed_validation OUT NOCOPY VARCHAR2
1671: )
1672: IS
1673: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1674: 'fem.plsql.fem_admin_util_pkg.validate_column_req';
1675:
1676: -- Cursor to fetch all registered columns that match
1677: -- those in FEM_COLUMN_REQUIREMNT_B

Line 1837: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1833: p_db_tab_name IN VARCHAR2,
1834: x_passed_validation OUT NOCOPY VARCHAR2
1835: )
1836: IS
1837: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1838: 'fem.plsql.fem_admin_util_pkg.validate_processing_key_idx';
1839:
1840: v_count NUMBER;
1841: v_idx_name FEM_TABLES_B.proc_key_index_name%TYPE;

Line 2025: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2021: PROCEDURE Validate_OGL_Dimcol (
2022: p_tab_name IN VARCHAR2,
2023: p_tab_class_cd IN VARCHAR2,
2024: x_passed_validation OUT NOCOPY VARCHAR2) IS
2025: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2026: 'fem.plsql.fem_admin_util_pkg.validate_ogl_dimcol';
2027:
2028: CURSOR c_dimcol (p_name VARCHAR2) IS
2029: SELECT column_name, dimension_id

Line 2185: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2181: p_tab_class_cd IN VARCHAR2,
2182: x_passed_validation OUT NOCOPY VARCHAR2
2183: )
2184: IS
2185: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2186: 'fem.plsql.fem_admin_util_pkg.validate_tab_class';
2187:
2188: CURSOR c_class_prop (p_class VARCHAR2) IS
2189: SELECT p.table_property_code, p.property_type, p.column_req_type

Line 2368: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2364: x_msg_data OUT NOCOPY VARCHAR2,
2365: p_tab_name IN VARCHAR2
2366: )
2367: IS
2368: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2369: 'fem.plsql.fem_admin_util_pkg.validate_tab_class_assignmt';
2370: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Tab_Class_Assignmt';
2371:
2372: v_passed_validation VARCHAR2(1);

Line 2493: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2489: p_obj_name IN VARCHAR2,
2490: p_obj_type IN VARCHAR2
2491: )
2492: IS
2493: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2494: 'fem.plsql.fem_admin_util_pkg.validate_obj_class_assignmt';
2495: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_obj_Class_Assignmt';
2496:
2497: v_passed_validation VARCHAR2(1);

Line 2648: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2644: -- =========================================================================
2645: -- Returns the underlying table name and table owner for a specified user defined view for the selected index.
2646: -- =========================================================================
2647:
2648: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2649: 'fem.plsql.fem_admin_util_pkg.Get_Table_Owner_for_View';
2650: BEGIN
2651:
2652: x_return_status := c_success;

Line 2714: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2710: -- =========================================================================
2711: -- Returns the underlying table name and Index owner for a specified user defined view and the selected index.
2712: -- =========================================================================
2713:
2714: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2715: 'fem.plsql.fem_admin_util_pkg.Get_Index_Owner_for_View';
2716:
2717:
2718: BEGIN

Line 2774: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2770: p_tab_class_cd IN VARCHAR2,
2771: x_passed_validation OUT NOCOPY VARCHAR2
2772: )
2773: IS
2774: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2775: 'fem.plsql.fem_admin_util_pkg.validate_view_class';
2776:
2777: CURSOR c_class_prop (p_class VARCHAR2) IS
2778: SELECT p.table_property_code, p.property_type, p.column_req_type