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_LOAD_AUDIT_PROCEDURE_DATA dependencies on FND_FILE

Line 166: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);

162:
163: -- To handle exceptions
164: BEGIN
165: -- Adding to the log file
166: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
167: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
168: fnd_file.put_line (fnd_file.LOG, 'Entered the Procedure');
169:
170: -- To fetch the party id

Line 167: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);

163: -- To handle exceptions
164: BEGIN
165: -- Adding to the log file
166: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
167: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
168: fnd_file.put_line (fnd_file.LOG, 'Entered the Procedure');
169:
170: -- To fetch the party id
171: select aecv.party_id into v_party_id

Line 168: fnd_file.put_line (fnd_file.LOG, 'Entered the Procedure');

164: BEGIN
165: -- Adding to the log file
166: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
167: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
168: fnd_file.put_line (fnd_file.LOG, 'Entered the Procedure');
169:
170: -- To fetch the party id
171: select aecv.party_id into v_party_id
172: from AMW_EMPLOYEES_CURRENT_V aecv, FND_USER fu

Line 186: fnd_file.put_line (fnd_file.LOG, 'To fetch audit procedure');

182: and batch_id = p_batch_id;
183: commit;
184:
185: -- To fetch Audit Project Id
186: fnd_file.put_line (fnd_file.LOG, 'To fetch audit procedure');
187: FOR projid_rec IN c_projid LOOP
188: v_audit_project_id := null;
189:
190: select audit_project_id into v_audit_project_id from amw_audit_projects_v

Line 201: fnd_file.put_line (fnd_file.LOG, 'To fetch task id');

197: commit;
198: END LOOP;
199:
200: -- To fetch Task Id
201: fnd_file.put_line (fnd_file.LOG, 'To fetch task id');
202: FOR taskid_rec IN c_taskid LOOP
203: v_task_id := null;
204:
205: if taskid_rec.task_name = '-1' then

Line 222: fnd_file.put_line (fnd_file.LOG, 'To fetch org id');

218: END LOOP;
219:
220:
221: -- To fetch Org Id
222: fnd_file.put_line (fnd_file.LOG, 'To fetch org id');
223: FOR orgid_rec IN c_orgid LOOP
224: v_org_id := null;
225:
226: select organization_id into v_org_id from amw_audit_units_v

Line 238: fnd_file.put_line (fnd_file.LOG, 'To fetch AP ID');

234: commit;
235: END LOOP;
236:
237: -- To fetch the audit procedure id
238: fnd_file.put_line (fnd_file.LOG, 'To fetch AP ID');
239: FOR apid_rec IN c_apid LOOP
240: v_audit_procedure_id := null;
241:
242: select audit_procedure_id into v_audit_procedure_id from amw_audit_procedures_vl where curr_approved_flag = 'Y'

Line 255: fnd_file.put_line (fnd_file.LOG, 'To fetch Ctrl Id');

251: commit;
252: END LOOP;
253:
254: -- To fetch Ctrl Id
255: fnd_file.put_line (fnd_file.LOG, 'To fetch Ctrl Id');
256: FOR ctrlid_rec IN c_ctrlid LOOP
257: v_ctrl_id := null;
258:
259: select control_id into v_ctrl_id from amw_controls_b acb, amw_controls_tl act

Line 275: fnd_file.put_line (fnd_file.LOG, 'To fetch rev id');

271: commit;
272: END LOOP;
273:
274: -- To fetch audit_procedure_rev_id
275: fnd_file.put_line (fnd_file.LOG, 'To fetch rev id');
276: For aprevid_rec IN c_aprevid LOOP
277: v_audit_procedure_rev_id := null;
278: select distinct audit_procedure_rev_id into v_audit_procedure_rev_id from amw_AP_associations
279: where audit_procedure_id = aprevid_rec.audit_procedure_id and pk1 = aprevid_rec.audit_project_id

Line 291: fnd_file.put_line (fnd_file.LOG, 'To fetch Step Id');

287:
288: commit;
289: END LOOP;
290: -- To fetch step Id
291: fnd_file.put_line (fnd_file.LOG, 'To fetch Step Id');
292: FOR stepid_rec IN c_stepid LOOP
293: v_step_id := null;
294: select ap_step_id into v_step_id from amw_ap_steps_vl aasv, amw_audit_procedures_vl ap
295: where aasv.name = stepid_rec.step_name and aasv.cseqnum = stepid_rec.step_number

Line 311: fnd_file.put_line (fnd_file.LOG, 'User Id' || g_user_id);

307: commit;
308: END LOOP;
309:
310: -- To fetch the party Id from User Id
311: fnd_file.put_line (fnd_file.LOG, 'User Id' || g_user_id);
312: select person_party_id into v_emp_id from fnd_user where user_id = g_user_id;
313: fnd_file.put_line (fnd_file.LOG, 'Start Updating the details');
314:
315: fnd_file.put_line (fnd_file.LOG, 'Updating procedure status');

Line 313: fnd_file.put_line (fnd_file.LOG, 'Start Updating the details');

309:
310: -- To fetch the party Id from User Id
311: fnd_file.put_line (fnd_file.LOG, 'User Id' || g_user_id);
312: select person_party_id into v_emp_id from fnd_user where user_id = g_user_id;
313: fnd_file.put_line (fnd_file.LOG, 'Start Updating the details');
314:
315: fnd_file.put_line (fnd_file.LOG, 'Updating procedure status');
316: -- To Update the audit procedure status
317: FOR ap_details_rec IN c_ap_details LOOP

Line 315: fnd_file.put_line (fnd_file.LOG, 'Updating procedure status');

311: fnd_file.put_line (fnd_file.LOG, 'User Id' || g_user_id);
312: select person_party_id into v_emp_id from fnd_user where user_id = g_user_id;
313: fnd_file.put_line (fnd_file.LOG, 'Start Updating the details');
314:
315: fnd_file.put_line (fnd_file.LOG, 'Updating procedure status');
316: -- To Update the audit procedure status
317: FOR ap_details_rec IN c_ap_details LOOP
318: v_ap_cnt := null;
319:

Line 331: fnd_file.put_line (fnd_file.LOG, 'Audit Procedure Rev id is null for'||

327: ap_details_rec.ap_interface_id||' Batch Id '||p_batch_id;
328:
329: update_interface_with_error(v_error_msg,ap_details_rec.ap_interface_id);
330:
331: fnd_file.put_line (fnd_file.LOG, 'Audit Procedure Rev id is null for'||
332: ap_details_rec.ap_interface_id||' Batch Id '||p_batch_id);
333: else
334: select count(*) into v_ap_cnt from amw_ap_executions
335: where audit_procedure_rev_id = ap_details_rec.audit_procedure_rev_id

Line 370: fnd_file.put_line (fnd_file.LOG, 'Updating step status');

366:
367: END LOOP; -- end of FOR ap_status_rec IN c_ap_status LOOP
368:
369:
370: fnd_file.put_line (fnd_file.LOG, 'Updating step status');
371: -- To Update the audit Step status
372: FOR step_details_rec IN c_step_details LOOP
373:
374: v_step_cnt := null;

Line 384: fnd_file.put_line (fnd_file.LOG, 'Audit Procedure Rev id is null for'||

380: step_details_rec.ap_interface_id||' Batch Id '||p_batch_id;
381:
382: update_interface_with_error(v_error_msg,step_details_rec.ap_interface_id);
383:
384: fnd_file.put_line (fnd_file.LOG, 'Audit Procedure Rev id is null for'||
385: step_details_rec.ap_interface_id||' Batch Id '||p_batch_id);
386: else
387:
388: if step_details_rec.step_id is null then

Line 397: fnd_file.put_line (fnd_file.LOG, 'Step id is null for'||

393: step_details_rec.ap_interface_id||' Batch Id '||p_batch_id;
394:
395: update_interface_with_error(v_error_msg,step_details_rec.ap_interface_id);
396:
397: fnd_file.put_line (fnd_file.LOG, 'Step id is null for'||
398: step_details_rec.ap_interface_id||' Batch Id '||p_batch_id);
399:
400: else
401: select count(*) into v_step_cnt from amw_ap_executions

Line 441: fnd_file.put_line (fnd_file.LOG, 'Updating step attachments');

437: -- To delete the existing Steps
438:
439: -- To update the steps attachments
440:
441: fnd_file.put_line (fnd_file.LOG, 'Updating step attachments');
442: FOR step_attach_rec IN c_steps_attach LOOP
443:
444: if(step_attach_rec.steps_attachment_url IS NOT NULL) THEN
445:

Line 505: fnd_file.put_line (fnd_file.LOG, 'Getting the component Id');

501: END IF; --END OF IF ATTACHMENT URL IS NOT NULL
502:
503: END LOOP; -- end of Steps Attachments
504:
505: fnd_file.put_line (fnd_file.LOG, 'Getting the component Id');
506: -- T0 Update the Control Effectiveness Details
507:
508: select opinion_component_id into v_overall from amw_opinion_componts_b
509: where opinion_component_code = 'OVERALL' and object_opinion_type_id =

Line 528: fnd_file.put_line (fnd_file.LOG, 'Updating Control evaluation details');

524: where opinion_type_id = (select opinion_type_id from AMW_OPINION_TYPES_b
525: where opinion_type_code = 'EVALUATION') and object_id = (select object_id from
526: fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL');
527:
528: fnd_file.put_line (fnd_file.LOG, 'Updating Control evaluation details');
529: FOR eff_details_rec IN c_effec_details LOOP
530:
531: v_opinions_cnt := 0;
532:

Line 541: fnd_file.put_line (fnd_file.LOG, 'Association id is null for'||

537: eff_details_rec.ap_interface_id||' Batch Id '||p_batch_id;
538:
539: update_interface_with_error(v_error_msg,eff_details_rec.ap_interface_id);
540:
541: fnd_file.put_line (fnd_file.LOG, 'Association id is null for'||
542: eff_details_rec.ap_interface_id||' Batch Id '||p_batch_id);
543:
544: else
545: select count(*) into v_opinions_cnt from amw_opinions where

Line 730: fnd_file.put_line (fnd_file.LOG,'Error in update '||SUBSTR (SQLERRM, 1, 200));

726: EXCEPTION
727: WHEN NO_DATA_FOUND THEN
728: NULL;
729: WHEN OTHERS THEN
730: fnd_file.put_line (fnd_file.LOG,'Error in update '||SUBSTR (SQLERRM, 1, 200));
731: END;
732: END update_apr;
733:
734: --

Line 761: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

757: 'interface_id: = '
758: || p_interface_id
759: || ' '
760: || SUBSTR (SQLERRM, 1, 100);
761: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
762: END;
763:
764: BEGIN
765: UPDATE amw_audit_procedure_interface

Line 772: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));

768: || p_err_msg
769: ,error_flag = 'Y'
770: WHERE ap_interface_id = p_interface_id;
771:
772: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));
773: COMMIT;
774: EXCEPTION
775: WHEN OTHERS
776: THEN

Line 782: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

778: 'Error during package processing '
779: || ' interface_id: = '
780: || p_interface_id
781: || SUBSTR (SQLERRM, 1, 100);
782: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
783: END;
784:
785: COMMIT;
786: END update_interface_with_error;