APPS.EDR_PSIG_RULE dependencies on WF_ENGINE

Line 176: l_cur_threshold WF_ENGINE.THRESHOLD%TYPE;

172: l_requester varchar2(240);
173: l_doc_params EDR_PSIG.params_table;
174:
175: /*Save Current Workflow Threshold */
176: l_cur_threshold WF_ENGINE.THRESHOLD%TYPE;
177: l_overriding_approver varchar2(80);
178: l_overriding_comments varchar2(4000);
179: BAD_RULE Exception;
180: DEFAULT_RULE_ERROR Exception;

Line 184: l_cur_threshold := WF_ENGINE.THRESHOLD;

180: DEFAULT_RULE_ERROR Exception;
181:
182: BEGIN
183: --Bug 4074173 : start
184: l_cur_threshold := WF_ENGINE.THRESHOLD;
185: --Bug 4074173 : end
186:
187: /* Update workflow threshold to default threshold */
188: WF_ENGINE.THRESHOLD := 50;

Line 188: WF_ENGINE.THRESHOLD := 50;

184: l_cur_threshold := WF_ENGINE.THRESHOLD;
185: --Bug 4074173 : end
186:
187: /* Update workflow threshold to default threshold */
188: WF_ENGINE.THRESHOLD := 50;
189:
190: /* Get Payload Attributes required by Rule function */
191: l_event_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_eventP.Parameter_List);
192: l_event_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_eventP.Parameter_List);

Line 450: WF_ENGINE.THRESHOLD := l_cur_threshold;

446:
447: END IF;
448:
449: /* Udate workflow threshold to saved value */
450: WF_ENGINE.THRESHOLD := l_cur_threshold;
451: RETURN l_return_status;
452:
453: exception
454: when BAD_RULE then

Line 457: WF_ENGINE.THRESHOLD := l_cur_threshold;

453: exception
454: when BAD_RULE then
455:
456: /* Update workflow threshold to saved value */
457: WF_ENGINE.THRESHOLD := l_cur_threshold;
458: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
459: wf_event.setErrorInfo(p_eventP,'ERROR');
460: ROLLBACK;
461: p_err_code:=l_error;

Line 481: WF_ENGINE.THRESHOLD := l_cur_threshold;

477: return 'ERROR';
478:
479: when DEFAULT_RULE_ERROR then
480: /* Update workflow threshold to saved value */
481: WF_ENGINE.THRESHOLD := l_cur_threshold;
482: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
483: wf_event.setErrorInfo(p_eventP,'ERROR');
484: ROLLBACK;
485: p_err_code:=l_error;

Line 507: WF_ENGINE.THRESHOLD := l_cur_threshold;

503: when others then
504: /* Udate workflow threshold to saved value */
505: Wf_Core.get_ERROR(l_error,l_error_msg,l_error_stack);
506: wf_log_pkg.string(6,'in when others of create_pageflow'||l_error,l_error_msg||substr(l_error_stack,1,100));
507: WF_ENGINE.THRESHOLD := l_cur_threshold;
508: Wf_Core.Context('EDR_PSIG_RULE', 'CREATE_PAGEFLOW', p_eventP.getEventName(), p_subscription_guid);
509: wf_event.setErrorInfo(p_eventP,'ERROR');
510: ROLLBACK;
511: p_err_code:=l_error;