eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_DELETE_OBJECT_PVT dependencies on FND_FILE

Line 104: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);

100:
101: l_dummy_type_and_id VARCHAR(80);
102:
103: BEGIN
104: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);
105:
106: IF p_object_type_and_id1 IS NOT NULL THEN
107: FND_FILE.put_line(fnd_file.log, '******* p_object_type_and_id1 = '||p_object_type_and_id1||' *******');
108: l_dummy_type_and_id := trim(p_object_type_and_id1);

Line 107: FND_FILE.put_line(fnd_file.log, '* p_object_type_and_id1 = '||p_object_type_and_id1||' *');

103: BEGIN
104: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);
105:
106: IF p_object_type_and_id1 IS NOT NULL THEN
107: FND_FILE.put_line(fnd_file.log, '******* p_object_type_and_id1 = '||p_object_type_and_id1||' *******');
108: l_dummy_type_and_id := trim(p_object_type_and_id1);
109: l_object_type1 := substr(l_dummy_type_and_id, 1, instr(l_dummy_type_and_id, '#')-1);
110: l_object_id1 := to_number(substr(l_dummy_type_and_id, instr(l_dummy_type_and_id, '#')+1));
111: Delete_Object(p_object_type => l_object_type1, p_object_id => l_object_id1);

Line 115: FND_FILE.put_line(fnd_file.log, '* p_object_type_and_id2 = '||p_object_type_and_id2||' *');

111: Delete_Object(p_object_type => l_object_type1, p_object_id => l_object_id1);
112: END IF;
113:
114: IF p_object_type_and_id2 IS NOT NULL THEN
115: FND_FILE.put_line(fnd_file.log, '******* p_object_type_and_id2 = '||p_object_type_and_id2||' *******');
116: l_dummy_type_and_id := trim(p_object_type_and_id2);
117: l_object_type2 := substr(l_dummy_type_and_id, 1, instr(l_dummy_type_and_id, '#')-1);
118: l_object_id2 := to_number(substr(l_dummy_type_and_id, instr(l_dummy_type_and_id, '#')+1));
119: Delete_Object(p_object_type => l_object_type2, p_object_id => l_object_id2);

Line 123: FND_FILE.put_line(fnd_file.log, '* p_object_type_and_id3 = '||p_object_type_and_id3||' *');

119: Delete_Object(p_object_type => l_object_type2, p_object_id => l_object_id2);
120: END IF;
121:
122: IF p_object_type_and_id3 IS NOT NULL THEN
123: FND_FILE.put_line(fnd_file.log, '******* p_object_type_and_id3 = '||p_object_type_and_id3||' *******');
124: l_dummy_type_and_id := trim(p_object_type_and_id3);
125: l_object_type3 := substr(l_dummy_type_and_id, 1, instr(l_dummy_type_and_id, '#')-1);
126: l_object_id3 := to_number(substr(l_dummy_type_and_id, instr(l_dummy_type_and_id, '#')+1));
127: Delete_Object(p_object_type => l_object_type3, p_object_id => l_object_id3);

Line 131: FND_FILE.put_line(fnd_file.log, '* p_object_type_and_id4 = '||p_object_type_and_id4||' *');

127: Delete_Object(p_object_type => l_object_type3, p_object_id => l_object_id3);
128: END IF;
129:
130: IF p_object_type_and_id4 IS NOT NULL THEN
131: FND_FILE.put_line(fnd_file.log, '******* p_object_type_and_id4 = '||p_object_type_and_id4||' *******');
132: l_dummy_type_and_id := trim(p_object_type_and_id4);
133: l_object_type4 := substr(l_dummy_type_and_id, 1, instr(l_dummy_type_and_id, '#')-1);
134: l_object_id4 := to_number(substr(l_dummy_type_and_id, instr(l_dummy_type_and_id, '#')+1));
135: Delete_Object(p_object_type => l_object_type4, p_object_id => l_object_id4);

Line 170: FND_FILE.put_line(fnd_file.log, 'Cannot Delete Risk : risk_id = '||p_object_id);

166: IF (l_Is_Object_In_Use = 'N') THEN
167: -- object is not in use, can delete it
168: Delete_Risk(p_risk_id => p_object_id);
169: ELSE
170: FND_FILE.put_line(fnd_file.log, 'Cannot Delete Risk : risk_id = '||p_object_id);
171: END IF;
172:
173: ELSIF (p_object_type = 'CTRL') THEN
174: l_Is_Object_In_Use := Is_Object_In_Use(p_dynamic_sql_list => t_ctrl_dynamic_sql_list,

Line 180: FND_FILE.put_line(fnd_file.log, 'Cannot Delete Control : control_id = '||p_object_id);

176: IF (l_Is_Object_In_Use = 'N') THEN
177: -- object is not in use, can delete it
178: Delete_Ctrl(p_ctrl_id => p_object_id);
179: ELSE
180: FND_FILE.put_line(fnd_file.log, 'Cannot Delete Control : control_id = '||p_object_id);
181: END IF;
182:
183: ELSIF (p_object_type = 'AP') THEN
184: l_Is_Object_In_Use := Is_Object_In_Use(p_dynamic_sql_list => t_ap_dynamic_sql_list,

Line 190: FND_FILE.put_line(fnd_file.log, 'Cannot Delete Audit Procedure : audit_procedure_id = '||p_object_id);

186: IF (l_Is_Object_In_Use = 'N') THEN
187: -- object is not in use, can delete it
188: Delete_Ap(p_ap_id => p_object_id);
189: ELSE
190: FND_FILE.put_line(fnd_file.log, 'Cannot Delete Audit Procedure : audit_procedure_id = '||p_object_id);
191: END IF;
192:
193: END IF;
194: END IF; -- end of if: p_object_type IS NOT NULL

Line 246: FND_FILE.put_line(fnd_file.log, 'Delete Risk : risk_id = '||p_risk_id);

242: DELETE FROM AMW_RISKS_TL WHERE risk_rev_id = l_risk_rev_id_list(i);
243:
244: DELETE FROM AMW_RISKS_B WHERE risk_id = p_risk_id;
245:
246: FND_FILE.put_line(fnd_file.log, 'Delete Risk : risk_id = '||p_risk_id);
247:
248: IF (sql%notfound) then
249: RAISE no_data_found;
250: END IF;

Line 319: FND_FILE.put_line(fnd_file.log, 'Delete Control : control_id = '||p_ctrl_id);

315: DELETE FROM AMW_CONTROLS_TL WHERE control_rev_id = l_ctrl_rev_id_list(i);
316:
317: DELETE FROM AMW_CONTROLS_B WHERE control_id = p_ctrl_id;
318:
319: FND_FILE.put_line(fnd_file.log, 'Delete Control : control_id = '||p_ctrl_id);
320:
321: IF (sql%notfound) then
322: RAISE no_data_found;
323: END IF;

Line 385: FND_FILE.put_line(fnd_file.log, 'Delete Audit Procedure : audit_procedure_id = '||p_ap_id);

381:
382: DELETE FROM AMW_AUDIT_PROCEDURES_B WHERE audit_procedure_id = p_ap_id;
383: DELETE FROM AMW_AP_ASSOCIATIONS WHERE audit_procedure_id = p_ap_id;
384:
385: FND_FILE.put_line(fnd_file.log, 'Delete Audit Procedure : audit_procedure_id = '||p_ap_id);
386:
387:
388: IF (sql%notfound) then
389: RAISE no_data_found;

Line 489: FND_FILE.put_line(fnd_file.log, 'object is in use : '||p_dynamic_sql_list(i)(1));

485: FOR i in p_dynamic_sql_list.FIRST .. p_dynamic_sql_list.LAST
486: LOOP
487:
488: IF (Is_Record_Exist(p_dynamic_sql_list(i), p_bind_value) = TRUE) THEN
489: FND_FILE.put_line(fnd_file.log, 'object is in use : '||p_dynamic_sql_list(i)(1));
490: l_Is_Object_In_Use := 'Y';
491: EXIT;
492: END IF;
493: END LOOP;