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.EDR_STANDARD dependencies on WF_LOG_PKG

Line 203: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );

199: --Bug 5287504: End
200:
201:
202: -- Bug 5167817 : end
203: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );
204:
205: select application_name into l_application_name
206: from ame_Calling_Apps
207: where

Line 218: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));

214:
215: if approverList.count > 0 then
216:
217: for i in 1..l_ruleids.count loop
218: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));
219:
220: -- Bug 3214495 : Start
221:
222: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid => NVL(l_ame_transaction_type,evt.getEventName( )),

Line 227: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );

223: ameruleid =>l_ruleids(i),
224: amerulename=>l_rulenames(i),
225: ameruleinputvalues=>l_rulevalues);
226: -- Bug 3214495 : End
227: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );
228: if l_rulevalues.count > 0 then
229: for i in 1..l_rulevalues.count loop
230: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
231: if ( l_esign_required='N' and l_rulevalues(i).input_value ='Y') then

Line 243: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);

239: end loop;
240: end if;
241: END LOOP;
242: END IF;
243: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
244: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
245: IF (l_esign_required='Y') THEN
246: p_status:=true;
247: END IF;

Line 244: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);

240: end if;
241: END LOOP;
242: END IF;
243: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
244: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
245: IF (l_esign_required='Y') THEN
246: p_status:=true;
247: END IF;
248: END IF;

Line 446: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );

442: END;
443: --bug 5287504: End
444:
445: -- Bug 5167817 : end
446: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );
447: select application_name into l_application_name
448: from ame_Calling_Apps
449: where
450: FND_APPLICATION_ID=l_application_id and

Line 460: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));

456:
457: if approverList.count > 0 then
458:
459: for i in 1..l_ruleids.count loop
460: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Rule_id: '||l_ruleids(i)||' Rule '||l_rulenames(i));
461:
462: -- Bug 3214495 : Start
463:
464: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid =>NVL(l_ame_transaction_type,evt.getEventName( )),

Line 471: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );

467: ameruleinputvalues=>l_rulevalues);
468:
469: -- Bug 3214495 : End
470:
471: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Total Input Values '||l_rulevalues.count );
472: if l_rulevalues.count > 0 then
473: for i in 1..l_rulevalues.count loop
474: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
475: if ( l_esign_required='N' and l_rulevalues(i).input_value ='Y') then

Line 487: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);

483: end loop;
484: end if;
485: END LOOP;
486: END IF;
487: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
488: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
489: IF (l_erecord_required='Y') THEN
490: p_status:=true;
491: END IF;

Line 488: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);

484: end if;
485: END LOOP;
486: END IF;
487: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','Signature Required :'||l_esign_required);
488: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','eRecord Required :'||l_erecord_required);
489: IF (l_erecord_required='Y') THEN
490: p_status:=true;
491: END IF;
492: END IF;

Line 826: wf_log_pkg.string(6, 'TEST','Trigger Status ' ||l_trigger_status);

822: SELECT status into l_trigger_status
823: FROM user_triggers
824: WHERE trigger_name=P_TABLE_NAME||'_AU';
825:
826: wf_log_pkg.string(6, 'TEST','Trigger Status ' ||l_trigger_status);
827:
828:
829: EXCEPTION
830: WHEN NO_DATA_FOUND then

Line 842: wf_log_pkg.string(6, 'TEST','Current Value ' ||p_current_value);

838:
839: EXECUTE IMMEDIATE 'select ' ||P_COLUMN||' from '||P_TABLE_NAME ||' where '||P_PKNAME||'='||P_PKVALUE ||' '
840: INTO p_current_value;
841:
842: wf_log_pkg.string(6, 'TEST','Current Value ' ||p_current_value);
843:
844:
845: /* fetch old values from audit tables */
846: l_table_name:=P_TABLE_NAME||'_A';

Line 850: wf_log_pkg.string(6, 'TEST','Audit Table ' ||l_table_name);

846: l_table_name:=P_TABLE_NAME||'_A';
847:
848:
849: l_table_name:=P_TABLE_NAME||'_A';
850: wf_log_pkg.string(6, 'TEST','Audit Table ' ||l_table_name);
851: wf_log_pkg.string(6, 'TEST','SQL '||sql_stmt);
852: BEGIN
853: EXECUTE IMMEDIATE 'select '||P_COLUMN||' from '||L_TABLE_NAME||' where '||P_PKNAME||'='||P_PKVALUE ||' and '||
854: 'AUDIT_SESSION_ID=USERENV('||''''||'SESSIONID'||''''||') and '||

Line 851: wf_log_pkg.string(6, 'TEST','SQL '||sql_stmt);

847:
848:
849: l_table_name:=P_TABLE_NAME||'_A';
850: wf_log_pkg.string(6, 'TEST','Audit Table ' ||l_table_name);
851: wf_log_pkg.string(6, 'TEST','SQL '||sql_stmt);
852: BEGIN
853: EXECUTE IMMEDIATE 'select '||P_COLUMN||' from '||L_TABLE_NAME||' where '||P_PKNAME||'='||P_PKVALUE ||' and '||
854: 'AUDIT_SESSION_ID=USERENV('||''''||'SESSIONID'||''''||') and '||
855: 'AUDIT_TIMESTAMP in (SELECT max(AUDIT_TIMESTAMP) from '||L_TABLE_NAME||' where '||P_PKNAME||'='||P_PKVALUE ||' and '||

Line 858: wf_log_pkg.string(6, 'TEST','old Value ' ||p_old_value);

854: 'AUDIT_SESSION_ID=USERENV('||''''||'SESSIONID'||''''||') and '||
855: 'AUDIT_TIMESTAMP in (SELECT max(AUDIT_TIMESTAMP) from '||L_TABLE_NAME||' where '||P_PKNAME||'='||P_PKVALUE ||' and '||
856: 'AUDIT_SESSION_ID=USERENV('||''''||'SESSIONID'||''''||')) and '||
857: 'AUDIT_TRANSACTION_TYPE='||''''||'U'||'''' INTO p_old_value;
858: wf_log_pkg.string(6, 'TEST','old Value ' ||p_old_value);
859: EXCEPTION
860: WHEN NO_DATA_FOUND then
861: /* Non of the columns changed */
862: return 'false';

Line 1405: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','Function completed successfully');

1401: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE29',P_COLUMN29_ID_VAL);
1402: FND_FLEX_DESCVAL.set_column_value('ATTRIBUTE30',P_COLUMN30_ID_VAL);
1403:
1404: IF FND_FLEX_DESCVAL.validate_desccols(l_appl_short_name,P_DESC_FLEX_DEF_NAME,l_values_or_ids,l_validation_date) THEN
1405: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','Function completed successfully');
1406: l_segcount := FND_FLEX_DESCVAL.segment_count;
1407: -- FND_FLEX_DESCVAL.segment_value(1) - Segment name
1408: IF(l_segcount > 1)THEN
1409: FOR i in 2..l_segcount LOOP