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

Line 114: fnd_file.put_line (fnd_file.LOG, '**********************************');

110: NULL;
111: END;
112:
113: IF(l_process_name = 0)THEN
114: fnd_file.put_line (fnd_file.LOG, '**********************************');
115: v_parent_process_error := l_parent_name.parent_process_name;
116: v_new_parent_interface_id := l_parent_name.process_interface_id;
117: return False;
118: END IF;

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

278: ---05.11.2005 npanandi: added below variable for check before Approving
279: l_db_proc_appr_status varchar2(1);
280: l_db_process_display_name varchar2(80);
281: BEGIN
282: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
283: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
284: fnd_file.put_line (fnd_file.LOG, 'Batch_Id: '||p_batch_id);
285: -- Check that User has access to Process Import Functionality
286:

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

279: l_db_proc_appr_status varchar2(1);
280: l_db_process_display_name varchar2(80);
281: BEGIN
282: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
283: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
284: fnd_file.put_line (fnd_file.LOG, 'Batch_Id: '||p_batch_id);
285: -- Check that User has access to Process Import Functionality
286:
287: ---05.11.2005 npanandi: included the below statement to count

Line 284: fnd_file.put_line (fnd_file.LOG, 'Batch_Id: '||p_batch_id);

280: l_db_process_display_name varchar2(80);
281: BEGIN
282: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
283: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
284: fnd_file.put_line (fnd_file.LOG, 'Batch_Id: '||p_batch_id);
285: -- Check that User has access to Process Import Functionality
286:
287: ---05.11.2005 npanandi: included the below statement to count
288: ---the initial # of processes in the system, prior to the current upload

Line 290: fnd_file.put_line(fnd_file.LOG, '* Initial # of Processes, prior to this Upload: '||l_count_processes||' *' );

286:
287: ---05.11.2005 npanandi: included the below statement to count
288: ---the initial # of processes in the system, prior to the current upload
289: select count(process_id) into l_count_processes from amw_process_vl;
290: fnd_file.put_line(fnd_file.LOG, '********* Initial # of Processes, prior to this Upload: '||l_count_processes||' *********' );
291: ---05.11.2005 npanandi: ends above statement
292:
293: IF not Check_Function_Security('AMW_ALLOW_PROCESS_CREATION') THEN
294: RAISE e_no_import_access;

Line 298: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: hierarchy Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

294: RAISE e_no_import_access;
295: END IF;
296:
297: ---CHECK FOR PROCESS_CODE ENTERED WHEN PRC EXISTS AND REVISE FLAG='Y'
298: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: hierarchy Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
299:
300: POPULATE_INTF_TBL(P_BATCH_ID => P_BATCH_ID);
301:
302: L_INTF_ID := GET_INV_PRC_CODE_ROW(P_BATCH_ID);

Line 319: ---fnd_file.put_line(fnd_file.LOG,'fnd_message.set_name brings: '||v_err_msg);

315: v_error_found := true;
316: fnd_message.set_name('AMW','AMW_NEW_PROC_NOT_CHILD');
317: fnd_message.set_token('PROCESS',v_parent_process_error);
318: v_err_msg := fnd_message.get;
319: ---fnd_file.put_line(fnd_file.LOG,'fnd_message.set_name brings: '||v_err_msg);
320: raise e_inv_parent_prc_hier;
321: END IF;
322:
323: ---FIRST DO HIERARCHY CHECKS

Line 389: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

385: RAISE E_INTF_HIER_INV;
386: END IF;
387: END IF;
388: END LOOP;
389: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
390:
391: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert records Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
392: FOR INSERT_REC IN C_GET_INTF_ROWS LOOP
393: ---HERE IF ALL ABOVE CHECKS ARE FINE, THEN ALL PROCESS CODES,

Line 391: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert records Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

387: END IF;
388: END LOOP;
389: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
390:
391: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert records Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
392: FOR INSERT_REC IN C_GET_INTF_ROWS LOOP
393: ---HERE IF ALL ABOVE CHECKS ARE FINE, THEN ALL PROCESS CODES,
394: ---PROCESS DISPLAY NAMES AND THE PROCESS ITEM TYPES ARE KNOWN
395: --- .... SO START PROCESSING, WE HAVE TO WORRY ONLY ABOUT THE

Line 560: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert records End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

556: ,X_MSG_COUNT => LX_MSG_COUNT
557: ,X_MSG_DATA => LX_MSG_COUNT);
558: END IF;
559: END LOOP;
560: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert records End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
561:
562: --OPEN ANOTHER LOOP HERE FOR DOING THE HIERARCHY LINKS ...
563: --INSERT A ROW IN
564:

Line 565: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: create links Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

561:
562: --OPEN ANOTHER LOOP HERE FOR DOING THE HIERARCHY LINKS ...
563: --INSERT A ROW IN
564:
565: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: create links Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
566: FOR INSERT_LINKS IN C_CREATE_LINKS LOOP
567: --SET THESE VALUES TO NULL FOR THIS PARTICULAR LOOP,
568: --LEST PARAM VALUES GET CORRUPTED ....
569: L_PROCESS_CODE := NULL;

Line 619: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: create links End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

615: ,X_MSG_COUNT => LX_MSG_COUNT
616: ,X_MSG_DATA => LX_MSG_DATA);
617: end if;
618: END LOOP;
619: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: create links End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
620:
621: ---03.02.2005 npanandi: added check in the IF condition for v_error_found
622: ---call updateDenorm only if no errors encountered
623: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 623: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

619: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: create links End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
620:
621: ---03.02.2005 npanandi: added check in the IF condition for v_error_found
622: ---call updateDenorm only if no errors encountered
623: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
624: if(not v_error_found)then
625: ---calling Nirman's procedure to update denorm tbl
626: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => -1);
627:

Line 631: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

627:
628: ---nirman's update latest ctrl, risk API called here ...
629: AMW_RL_HIERARCHY_PKG.update_all_latest_rc_counts(p_mode => 'RC');
630: end if;
631: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
632:
633: ---do the approval related stuff here ....
634: ---check to see what is the option given here
635: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert Approvals Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 635: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert Approvals Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

631: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
632:
633: ---do the approval related stuff here ....
634: ---check to see what is the option given here
635: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert Approvals Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
636: FOR INSERT_APPR IN C_CREATE_APPROVALS LOOP
637: L_PROCESS_CODE := NULL;
638: L_PROCESS_ID := NULL;
639: L_PROCESS_ITEM_TYPE := NULL;

Line 687: ---fnd_file.put_line(fnd_file.log, 'display_name: '||l_db_process_display_name||', l_db_proc_appr_status: '||l_db_proc_appr_status );

683: null;
684: END;
685:
686: --03.02.2005 npanandi: added below check for v_error_found
687: ---fnd_file.put_line(fnd_file.log, 'display_name: '||l_db_process_display_name||', l_db_proc_appr_status: '||l_db_proc_appr_status );
688: if(not v_error_found and l_db_proc_appr_status = 'D')then
689: BEGIN
690: /*fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
691: AMW_PROC_APPROVAL_PKG.SUB_FOR_APPROVAL(p_process_id => L_PROCESS_ID,p_webadi_call => 'Y');

Line 690: /*fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

686: --03.02.2005 npanandi: added below check for v_error_found
687: ---fnd_file.put_line(fnd_file.log, 'display_name: '||l_db_process_display_name||', l_db_proc_appr_status: '||l_db_proc_appr_status );
688: if(not v_error_found and l_db_proc_appr_status = 'D')then
689: BEGIN
690: /*fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
691: AMW_PROC_APPROVAL_PKG.SUB_FOR_APPROVAL(p_process_id => L_PROCESS_ID,p_webadi_call => 'Y');
692: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
693:
694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 692: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

688: if(not v_error_found and l_db_proc_appr_status = 'D')then
689: BEGIN
690: /*fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
691: AMW_PROC_APPROVAL_PKG.SUB_FOR_APPROVAL(p_process_id => L_PROCESS_ID,p_webadi_call => 'Y');
692: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
693:
694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);
696: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

690: /*fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
691: AMW_PROC_APPROVAL_PKG.SUB_FOR_APPROVAL(p_process_id => L_PROCESS_ID,p_webadi_call => 'Y');
692: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
693:
694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);
696: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
697: */
698: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 696: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

692: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
693:
694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);
696: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
697: */
698: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
699: amw_proc_approval_pkg.WEBADI_APPROVE(
700: p_process_id => l_process_id

Line 698: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);
696: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
697: */
698: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
699: amw_proc_approval_pkg.WEBADI_APPROVE(
700: p_process_id => l_process_id
701: ,p_approv_choice => l_get_param);
702: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 702: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

698: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
699: amw_proc_approval_pkg.WEBADI_APPROVE(
700: p_process_id => l_process_id
701: ,p_approv_choice => l_get_param);
702: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
703: EXCEPTION
704: WHEN OTHERS THEN
705: v_err_msg := 'unexpected EXCEPTION in create_processes: '||sqlerrm;
706: v_table_name := 'AMW_PROCESS';

Line 708: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in create_processes: '||sqlerrm);

704: WHEN OTHERS THEN
705: v_err_msg := 'unexpected EXCEPTION in create_processes: '||sqlerrm;
706: v_table_name := 'AMW_PROCESS';
707: update_interface_with_error (v_err_msg,v_table_name,L_INTF_ID);
708: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in create_processes: '||sqlerrm);
709: END;
710: end if; --03.02.2005 npanandi: end of v_error_found check
711: END IF; --END OF CHK FOR PARAM d DOWNWARD HIER CHK
712: END IF; --END OF CHK FOR APPR_STATUS=A, REVISE_FLAG='R', ENBL_AUTO_APPR='Y'

Line 714: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert Approvals End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

710: end if; --03.02.2005 npanandi: end of v_error_found check
711: END IF; --END OF CHK FOR PARAM d DOWNWARD HIER CHK
712: END IF; --END OF CHK FOR APPR_STATUS=A, REVISE_FLAG='R', ENBL_AUTO_APPR='Y'
713: END LOOP;
714: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert Approvals End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
715:
716: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
717: ---05.11.2005 npanandi: added below as a one time call, instead of per-row
718: amw_proc_approval_pkg.write_approved_hierarchy(p_step => 4);

Line 716: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

712: END IF; --END OF CHK FOR APPR_STATUS=A, REVISE_FLAG='R', ENBL_AUTO_APPR='Y'
713: END LOOP;
714: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert Approvals End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
715:
716: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
717: ---05.11.2005 npanandi: added below as a one time call, instead of per-row
718: amw_proc_approval_pkg.write_approved_hierarchy(p_step => 4);
719: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
720:

Line 719: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

715:
716: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
717: ---05.11.2005 npanandi: added below as a one time call, instead of per-row
718: amw_proc_approval_pkg.write_approved_hierarchy(p_step => 4);
719: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
720:
721: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
722: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 721: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

717: ---05.11.2005 npanandi: added below as a one time call, instead of per-row
718: amw_proc_approval_pkg.write_approved_hierarchy(p_step => 4);
719: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
720:
721: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
722: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
724:
725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

719: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
720:
721: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
722: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
724:
725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
726: amw_rl_hierarchy_pkg.update_appr_control_counts;
727: amw_rl_hierarchy_pkg.update_appr_risk_counts;

Line 725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

721: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
722: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
724:
725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
726: amw_rl_hierarchy_pkg.update_appr_control_counts;
727: amw_rl_hierarchy_pkg.update_appr_risk_counts;
728: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
729: ---05.11.2005 npanandi: ends above change

Line 728: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

724:
725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
726: amw_rl_hierarchy_pkg.update_appr_control_counts;
727: amw_rl_hierarchy_pkg.update_appr_risk_counts;
728: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
729: ---05.11.2005 npanandi: ends above change
730: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: new procedures End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
731:
732:

Line 730: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: new procedures End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

726: amw_rl_hierarchy_pkg.update_appr_control_counts;
727: amw_rl_hierarchy_pkg.update_appr_risk_counts;
728: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
729: ---05.11.2005 npanandi: ends above change
730: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: new procedures End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
731:
732:
733: --
734: -- get profile info FOR deleting records from interface table

Line 754: fnd_file.put_line (fnd_file.LOG,'err in update process flag: '||SUBSTR (SQLERRM, 1,200));

750: ,last_updated_by = v_user_id
751: WHERE batch_id = p_batch_id;
752: EXCEPTION
753: WHEN OTHERS THEN
754: fnd_file.put_line (fnd_file.LOG,'err in update process flag: '||SUBSTR (SQLERRM, 1,200));
755: END;
756: ELSE
757: IF NOT v_error_found THEN
758: BEGIN

Line 762: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM,1, 200));

758: BEGIN
759: DELETE FROM amw_processes_interface WHERE batch_id = p_batch_id;
760: EXCEPTION
761: WHEN OTHERS THEN
762: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM,1, 200));
763: END;
764: END IF;
765: END IF;
766:

Line 792: FND_FILE.PUT_LINE(FND_FILE.LOG,'unexpected exception in handling E_INTF_HIER_INV');

788: ,INTERFACE_STATUS='Upwards Interface hierarchy defined for this Process is Invalid'
789: WHERE PROCESS_INTERFACE_ID=V_INTERFACE_ID;
790: EXCEPTION
791: WHEN OTHERS THEN
792: FND_FILE.PUT_LINE(FND_FILE.LOG,'unexpected exception in handling E_INTF_HIER_INV');
793: END;
794:
795: WHEN E_PRC_CODE THEN
796: BEGIN

Line 803: FND_FILE.PUT_LINE(FND_FILE.LOG,'unexpected exception in handling E_PRC_CODE');

799: ,INTERFACE_STATUS='Please enter valid Process Code for this new Process'
800: WHERE PROCESS_INTERFACE_ID=L_INTF_ID;
801: EXCEPTION
802: WHEN OTHERS THEN
803: FND_FILE.PUT_LINE(FND_FILE.LOG,'unexpected exception in handling E_PRC_CODE');
804: END;
805:
806: WHEN E_PRC_APPR_INV THEN
807: BEGIN

Line 815: FND_FILE.PUT_LINE(FND_FILE.LOG,'unexpected exception in handling E_PRC_APPR_INV');

811: below this Process in the Risk Library'
812: WHERE PROCESS_INTERFACE_ID=L_INTF_ID;
813: EXCEPTION
814: WHEN OTHERS THEN
815: FND_FILE.PUT_LINE(FND_FILE.LOG,'unexpected exception in handling E_PRC_APPR_INV');
816: END;
817:
818: when e_synch_hierarchy_amw_process THEN
819: BEGIN

Line 827: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_synch_hierarchy_amw_process: '||sqlerrm);

823: ,interface_status = v_err_msg
824: WHERE batch_id = p_batch_id;
825: EXCEPTION
826: WHEN OTHERS THEN
827: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_synch_hierarchy_amw_process: '||sqlerrm);
828: END;
829:
830: when e_process_exist_no_update THEN
831: BEGIN

Line 842: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_process_exist_no_update: '||sqlerrm);

838: ,interface_status = v_process_exist_no_update
839: WHERE batch_id = p_batch_id;
840: EXCEPTION
841: WHEN OTHERS THEN
842: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_process_exist_no_update: '||sqlerrm);
843: END;
844:
845: when e_inv_parent_prc_hier THEN
846: --npanandi added following code to throw proper messages 02/18/2004

Line 867: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_invalid_process_hierarchy: '||sqlerrm);

863: and process_interface_id = v_new_parent_interface_id;
864:
865: EXCEPTION
866: WHEN OTHERS THEN
867: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_invalid_process_hierarchy: '||sqlerrm);
868: END;
869:
870: WHEN e_no_import_access THEN
871: BEGIN

Line 882: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_no_import_access: '||sqlerrm);

878: ,interface_status = v_no_import_privilege_msg
879: WHERE batch_id = p_batch_id;
880: EXCEPTION
881: WHEN OTHERS THEN
882: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_no_import_access: '||sqlerrm);
883: END;
884: WHEN others THEN
885: rollback;
886: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in create_processes: '||sqlerrm);

Line 886: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in create_processes: '||sqlerrm);

882: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in handling e_no_import_access: '||sqlerrm);
883: END;
884: WHEN others THEN
885: rollback;
886: fnd_file.put_line (fnd_file.LOG, 'unexpected EXCEPTION in create_processes: '||sqlerrm);
887: END create_processes;
888:
889: ---CHECKING FOR PROPER ENTRY OF PROCESS CODE
890: ---WHEN PROCESS DISPLAY NAME EXISTS AND PROCESS CODE IS NULL

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

990: WHEN NO_DATA_FOUND THEN
991: NULL;
992: WHEN OTHERS THEN
993: v_err_msg := 'Error during package processing '|| ' interface_id: = '||L_INTF_ID|| SUBSTR (SQLERRM, 1, 100);
994: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
995: END;
996:
997: --CHECK WHERE THIS PROCESS APPEARS AS THE
998: --PARENT PROCESS FOR THE SAME UPL SPRDSHEET,

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

1007: WHEN NO_DATA_FOUND THEN
1008: NULL;
1009: WHEN OTHERS THEN
1010: v_err_msg := 'Error during package processing '|| ' PARENT_PROCESS_NAME: = '|| L_DISP_NAME|| SUBSTR (SQLERRM, 1, 100);
1011: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1012: END;
1013: END LOOP;
1014:
1015: ---04.22.2005 npanandi: added below to add process code for existing

Line 1036: fnd_file.put_line (fnd_file.LOG,'UNHANDLED EXCEPTION');

1032: when too_many_rows then
1033: v_err_msg := 'Please select valid Parent Process Code for this Process';
1034: update_interface_with_error (v_err_msg,v_table_name,L_INTF_ID);
1035: when others then
1036: fnd_file.put_line (fnd_file.LOG,'UNHANDLED EXCEPTION');
1037: v_err_msg := 'Please select valid Parent Process Code for this Process';
1038: update_interface_with_error (v_err_msg,v_table_name,L_INTF_ID);
1039: end;
1040: end loop;

Line 1064: fnd_file.put_line (fnd_file.LOG,'UNHANDLED EXCEPTION');

1060: when too_many_rows then
1061: v_err_msg := 'Please select valid Process Code for this Process';
1062: update_interface_with_error (v_err_msg,v_table_name,L_INTF_ID);
1063: when others then
1064: fnd_file.put_line (fnd_file.LOG,'UNHANDLED EXCEPTION');
1065: v_err_msg := 'Please select valid Process Code for this Process';
1066: update_interface_with_error (v_err_msg,v_table_name,L_INTF_ID);
1067: end;
1068: end loop;

Line 1072: fnd_file.put_line (fnd_file.LOG,'UNHANDLED EXCEPTION');

1068: end loop;
1069: ---05.12.2005 npanandi: ends
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: fnd_file.put_line (fnd_file.LOG,'UNHANDLED EXCEPTION');
1073: END POPULATE_INTF_TBL;
1074:
1075: ---
1076: ---Finding the upwards hierarchy in Amw_Processes_Interface table

Line 1091: --fnd_file.put_line (fnd_file.LOG, '***** v_parent_process_code: '||v_parent_process_code);

1087: AND BATCH_ID=P_BATCH_ID;
1088: BEGIN
1089: --check to see if this process_code exists in application
1090: --v_counter := v_counter+1;
1091: --fnd_file.put_line (fnd_file.LOG, '***** v_parent_process_code: '||v_parent_process_code);
1092: IF( v_parent_process_CODE is null
1093: and PROCESS_CODE_EXISTS(p_PARENT_PROCESS_CODE =>P_PROCESS_CODE))then
1094: --add the first element
1095: v_parent_process_CODE := P_PROCESS_CODE;

Line 1100: --fnd_file.put_line (fnd_file.LOG, '***** P_PROCESS_CODE: '||P_PROCESS_CODE||', GET_PRC_CODE.PARENT_PROCESS_CODE: '||GET_PRC_CODE.PARENT_PROCESS_CODE);

1096: end if;
1097:
1098: FOR GET_PRC_CODE IN C_PRNT_PRC_CODE LOOP
1099: EXIT WHEN C_PRNT_PRC_CODE%NOTFOUND;
1100: --fnd_file.put_line (fnd_file.LOG, '***** P_PROCESS_CODE: '||P_PROCESS_CODE||', GET_PRC_CODE.PARENT_PROCESS_CODE: '||GET_PRC_CODE.PARENT_PROCESS_CODE);
1101: IF(P_PROCESS_CODE = GET_PRC_CODE.PARENT_PROCESS_CODE)THEN
1102: V_INTF_HIERARCHY_INV := 'Y';
1103: EXIT;
1104: elsif(PROCESS_CODE_EXISTS(p_PARENT_PROCESS_CODE => GET_PRC_CODE.PARENT_PROCESS_CODE))then

Line 1153: fnd_file.put_line(fnd_file.LOG,'Exiting from this LOOP since this is a dIFferent hierarchy FOR the same process being traversed');

1149:
1150: ---putting this to conserver hierarchy check
1151: IF((p_process_display_name = p_orig_process_display_name) And
1152: (p_interface_id <> ct_rec.process_interface_id)) THEN
1153: fnd_file.put_line(fnd_file.LOG,'Exiting from this LOOP since this is a dIFferent hierarchy FOR the same process being traversed');
1154: exit;
1155: END IF;
1156: ----END of check
1157:

Line 1158: fnd_file.put_line(fnd_file.LOG,'p_orig_process_display_name:

1154: exit;
1155: END IF;
1156: ----END of check
1157:
1158: fnd_file.put_line(fnd_file.LOG,'p_orig_process_display_name:
1159: '||p_orig_process_display_name||' p_process_display_name:
1160: '||p_process_display_name||' p_interface_id: '||p_interface_id||'
1161: process_interface_id: '||ct_rec.process_interface_id);
1162: IF(v_parent_process_name.exists(ct_rec.process_interface_id))THEN

Line 1165: fnd_file.put_line(fnd_file.LOG,'EXITING from find_parent_process');

1161: process_interface_id: '||ct_rec.process_interface_id);
1162: IF(v_parent_process_name.exists(ct_rec.process_interface_id))THEN
1163: --this means that violation of interface hierarchy is detected.
1164: v_interface_hierarchy_error := 1;
1165: fnd_file.put_line(fnd_file.LOG,'EXITING from find_parent_process');
1166: exit;
1167: ELSE
1168: v_parent_process_name(ct_rec.process_interface_id) :=
1169: ct_rec.parent_process_name;

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

1205: 'interface_id: = '
1206: || p_interface_id
1207: || ' '
1208: || SUBSTR (SQLERRM, 1, 100);
1209: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1210: END;
1211:
1212: BEGIN
1213: UPDATE amw_processes_interface

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

1220: || '**'
1221: ,error_flag = 'Y'
1222: WHERE process_interface_id = p_interface_id;
1223:
1224: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));
1225: COMMIT;
1226: EXCEPTION
1227: WHEN OTHERS
1228: THEN

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

1230: 'Error during package processing '
1231: || ' interface_id: = '
1232: || p_interface_id
1233: || SUBSTR (SQLERRM, 1, 100);
1234: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1235: END;
1236: COMMIT;
1237: END update_interface_with_error;
1238:

Line 1738: /* fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ l_classification: '||l_classification ); /

1734: l_classification_new := null;
1735:
1736: end;
1737:
1738: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ l_classification: '||l_classification ); **/
1739:
1740: if ((l_classification is null or (l_classification = l_classification_new)) and p_process_rec.classification is not null) then
1741: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ Updating AmwProcess here' ); ***/
1742: update amw_process

Line 1741: /* fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ Updating AmwProcess here' ); */

1737:
1738: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ l_classification: '||l_classification ); **/
1739:
1740: if ((l_classification is null or (l_classification = l_classification_new)) and p_process_rec.classification is not null) then
1741: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ Updating AmwProcess here' ); ***/
1742: update amw_process
1743: set classification = p_process_rec.classification
1744: ,last_update_date = sysdate
1745: ,last_updated_by = g_user_id

Line 1751: /* fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ Am out of the updates' ); */

1747: where process_id=p_process_rec.process_id
1748: and end_date is null;
1749: end if;
1750:
1751: /*** fnd_file.put_line(fnd_file.LOG, '^^^^^^^^^^^^^^^^ Am out of the updates' ); ***/
1752: ----7.28.2005 npanandi: end of bug fix for update Classification
1753:
1754: update AMW_PROCESS_NAMES_TL
1755: set DISPLAY_NAME = P_PROCESS_REC.DISPLAY_NAME