APPS.AMS_CTD_PVT dependencies on FND_LOG

Line 33: -- Private procedure to write debug message to FND_LOG table

29: --
30: -- Purpose
31: -- This is a private procedure to write debug messages to the log table.
32: --
33: -- Private procedure to write debug message to FND_LOG table
34: -- ===============================================================
35: PROCEDURE write_debug_message(p_log_level NUMBER,
36: p_procedure_name VARCHAR2,
37: p_label VARCHAR2,

Line 45: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

41: l_module_name VARCHAR2(400);
42: DELIMETER CONSTANT VARCHAR2(1) := '.';
43:
44: BEGIN
45: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
46: -- Set the Module Name
47: l_module_name := 'ams'||DELIMETER||'plsql'||DELIMETER||G_PACKAGE_NAME||DELIMETER||p_procedure_name||DELIMETER||'-'||p_label;
48:
49:

Line 126: write_debug_message(FND_LOG.LEVEL_EVENT,

122: END IF;
123: CLOSE C_CHECK_CTD_ASSOCIATION_EXISTS;
124: /* End bugfix: 3470296.*/
125:
126: write_debug_message(FND_LOG.LEVEL_EVENT,
127: PROCEDURE_NAME,
128: 'BEGIN',
129: 'Number of CTDs to be deleted = '||to_char(p_ctd_id_list.count)|| 'for Used By = '||p_used_by|| 'Used By Id = '||p_used_by_val1
130: );

Line 131: write_debug_message(FND_LOG.LEVEL_EVENT,

127: PROCEDURE_NAME,
128: 'BEGIN',
129: 'Number of CTDs to be deleted = '||to_char(p_ctd_id_list.count)|| 'for Used By = '||p_used_by|| 'Used By Id = '||p_used_by_val1
130: );
131: write_debug_message(FND_LOG.LEVEL_EVENT,
132: PROCEDURE_NAME,
133: 'BEFORE_BULK_DELETE_ASSOCIATION',
134: 'Before bulk delete of association'
135: );

Line 143: write_debug_message(FND_LOG.LEVEL_EVENT,

139: WHERE CTD_ID = p_ctd_id_list(i)
140: and used_by_type = p_used_by
141: and used_by_val1 = p_used_by_val1;
142:
143: write_debug_message(FND_LOG.LEVEL_EVENT,
144: PROCEDURE_NAME,
145: 'AFTER_BULK_DELETE_ASSOCIATION',
146: 'Associations Deleted Successfully!!'
147: );

Line 156: write_debug_message(FND_LOG.LEVEL_EVENT,

152: FETCH C_GET_NOT_ASSOCIATED_CTD
153: BULK COLLECT INTO l_not_associated_ctd_list;
154: CLOSE C_GET_NOT_ASSOCIATED_CTD;
155:
156: write_debug_message(FND_LOG.LEVEL_EVENT,
157: PROCEDURE_NAME,
158: 'AFTER_CURSOR_FETCH_C_GET_NOT_ASSOCIATED_CTD',
159: 'Number of CTDs to be deleted = '||to_char(l_not_associated_ctd_list.count)
160: );

Line 167: write_debug_message(FND_LOG.LEVEL_EVENT,

163: FORALL i in l_not_associated_ctd_list.FIRST .. l_not_associated_ctd_list.LAST
164: DELETE FROM AMS_CTDS
165: WHERE CTD_ID = l_not_associated_ctd_list(i);
166:
167: write_debug_message(FND_LOG.LEVEL_EVENT,
168: PROCEDURE_NAME,
169: 'AFTER_CTD_BULK_DELETE',
170: 'CTDs deleted successfully!!'
171: );

Line 178: write_debug_message(FND_LOG.LEVEL_EVENT,

174: FORALL i in l_not_associated_ctd_list.FIRST .. l_not_associated_ctd_list.LAST
175: DELETE FROM AMS_CTD_PARAM_VALUES
176: WHERE CTD_ID = l_not_associated_ctd_list(i);
177:
178: write_debug_message(FND_LOG.LEVEL_EVENT,
179: PROCEDURE_NAME,
180: 'AFTER_CTD_PARAM_VALUES_BULK_DELETE',
181: 'CTD Param Values deleted successfully!!'
182: );

Line 189: write_debug_message(FND_LOG.LEVEL_EVENT,

185: FORALL i in l_not_associated_ctd_list.FIRST .. l_not_associated_ctd_list.LAST
186: DELETE FROM AMS_CTD_ADHOC_PARAM_VALUES
187: WHERE CTD_ID = l_not_associated_ctd_list(i);
188:
189: write_debug_message(FND_LOG.LEVEL_EVENT,
190: PROCEDURE_NAME,
191: 'AFTER_CTD_ADHOC_PARAM_VALUES_BULK_DELETE',
192: 'CTD Adhoc Param Values deleted successfully!!'
193: );

Line 225: write_debug_message(FND_LOG.LEVEL_EVENT,

221: l_sequence_id NUMBER;
222: PROCEDURE_NAME CONSTANT VARCHAR2(30) := 'CREATE_ASSOCIATION';
223:
224: BEGIN
225: write_debug_message(FND_LOG.LEVEL_EVENT,
226: PROCEDURE_NAME,
227: 'BEGIN',
228: 'Begin procedure CREATE_ASSOCIATION'
229: );

Line 233: write_debug_message(FND_LOG.LEVEL_EVENT,

229: );
230:
231: l_list_count := p_ctd_id_list.count;
232:
233: write_debug_message(FND_LOG.LEVEL_EVENT,
234: PROCEDURE_NAME,
235: 'WRITE_INPUT_PARAM',
236: 'Input Param: Used By = '||p_used_by||' Used By val1 = '||p_used_by_val1||' Number of CTD Associations to be created ='||to_char(l_list_count)
237: );

Line 249: write_debug_message(FND_LOG.LEVEL_EVENT,

245:
246: l_assoc_seq_id_list(i) := l_sequence_id;
247: END LOOP;
248:
249: write_debug_message(FND_LOG.LEVEL_EVENT,
250: PROCEDURE_NAME,
251: 'BEFORE_CTD_ASSOCIATIONS_BULK_UPLOAD',
252: 'About to bulk upload into AMS_CTD_ASSOCIATIONS'
253: );

Line 296: write_debug_message(FND_LOG.LEVEL_EVENT,

292: null
293:
294: );
295:
296: write_debug_message(FND_LOG.LEVEL_EVENT,
297: PROCEDURE_NAME,
298: 'AFTER_CTD_ASSOCIATIONS_BULK_UPLOAD',
299: 'Bulk upload AMS_CTD_ASSOCIATIONS completed successfully!!'
300: );