DBA Data[Home] [Help]

APPS.FND_OAM_DSCFG_OBJECTS_PKG dependencies on FND_OAM_DEBUG

Line 31: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

27: l_proc_id NUMBER := NULL;
28:
29: l_object_id NUMBER;
30: BEGIN
31: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
32:
33: --get the config_instance_id, throws error if not initialized
34: l_config_instance_id := FND_OAM_DSCFG_INSTANCES_PKG.GET_CURRENT_ID;
35:

Line 74: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

70: RETURNING OBJECT_ID INTO l_object_id;
71:
72: x_object_id := l_object_id;
73:
74: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
75: EXCEPTION
76: WHEN NO_DATA_FOUND THEN
77: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
78: RAISE;

Line 77: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

73:
74: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
75: EXCEPTION
76: WHEN NO_DATA_FOUND THEN
77: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
78: RAISE;
79: WHEN OTHERS THEN
80: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
81: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 80: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

76: WHEN NO_DATA_FOUND THEN
77: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
78: RAISE;
79: WHEN OTHERS THEN
80: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
81: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
82: RAISE;
83: END;
84:

Line 81: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

77: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
78: RAISE;
79: WHEN OTHERS THEN
80: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
81: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
82: RAISE;
83: END;
84:
85: -- Public

Line 93: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

89: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_OBJECTS_FOR_TYPE';
90:
91: l_object_ids DBMS_SQL.NUMBER_TABLE;
92: BEGIN
93: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
94:
95: --do the fetch
96: SELECT object_id
97: BULK COLLECT INTO l_object_ids

Line 104: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

100: ORDER BY object_id asc;
101:
102: x_object_ids := l_object_ids;
103:
104: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
105: EXCEPTION
106: WHEN OTHERS THEN
107: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
108: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 107: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

103:
104: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
105: EXCEPTION
106: WHEN OTHERS THEN
107: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
108: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
109: RAISE;
110: END;
111:

Line 108: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

104: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
105: EXCEPTION
106: WHEN OTHERS THEN
107: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
108: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
109: RAISE;
110: END;
111:
112: -- Public

Line 121: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

117: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_OBJECTS_FOR_TYPE(errors_found_flag)';
118:
119: l_object_ids DBMS_SQL.NUMBER_TABLE;
120: BEGIN
121: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
122:
123: --do the fetch
124: IF p_errors_found_flag IS NULL THEN
125: SELECT object_id

Line 142: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

138: END IF;
139:
140: x_object_ids := l_object_ids;
141:
142: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
143: EXCEPTION
144: WHEN OTHERS THEN
145: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
146: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 145: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

141:
142: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
143: EXCEPTION
144: WHEN OTHERS THEN
145: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
146: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
147: RAISE;
148: END;
149:

Line 146: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

142: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
143: EXCEPTION
144: WHEN OTHERS THEN
145: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
146: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
147: RAISE;
148: END;
149:
150: -- Public

Line 162: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

158:
159: k NUMBER;
160: l_failed BOOLEAN := FALSE;
161: BEGIN
162: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
163:
164: --first nuke the properties
165: IF p_recurse IS NOT NULL AND p_recurse = FND_API.G_TRUE THEN
166: --delete all the leaf properties at once.

Line 178: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

174: DELETE FROM fnd_oam_dscfg_objects
175: WHERE object_id = p_object_id;
176:
177: --success
178: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
179: RETURN TRUE;
180: EXCEPTION
181: WHEN OTHERS THEN
182: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 182: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

178: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
179: RETURN TRUE;
180: EXCEPTION
181: WHEN OTHERS THEN
182: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
183: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
184: RETURN FALSE;
185: END;
186:

Line 183: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

179: RETURN TRUE;
180: EXCEPTION
181: WHEN OTHERS THEN
182: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
183: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
184: RETURN FALSE;
185: END;
186:
187: END FND_OAM_DSCFG_OBJECTS_PKG;