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.ASP_ALERTS_WF dependencies on WF_ENGINE

Line 74: save_threshold := wf_engine.threshold;

70: l_debug_exception := FND_LOG.LEVEL_EXCEPTION;
71: l_debug_procedure := FND_LOG.LEVEL_PROCEDURE;
72: l_debug_statment := FND_LOG.LEVEL_STATEMENT;
73:
74: save_threshold := wf_engine.threshold;
75: l_qualified_api_name := G_PKG_NAME||'.'||l_api_name;
76: if(l_debug_procedure >= l_debug_runtime) then
77: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
78: end if;

Line 81: -- l_pre_expire_time_percent := wf_engine.GetItemAttrText( itemtype =>itemtype,

77: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Entered '||G_PKG_NAME||'.'||l_api_name);
78: end if;
79:
80: If(funcmode = 'RUN') Then
81: -- l_pre_expire_time_percent := wf_engine.GetItemAttrText( itemtype =>itemtype,
82: -- itemkey =>itemkey,
83: -- aname =>'PRE_EXPIRE_TIME_PERCENT');
84: l_pre_expire_time_percent := wf_engine.GetActivityAttrText( itemtype =>itemtype,
85: itemkey =>itemkey,

Line 84: l_pre_expire_time_percent := wf_engine.GetActivityAttrText( itemtype =>itemtype,

80: If(funcmode = 'RUN') Then
81: -- l_pre_expire_time_percent := wf_engine.GetItemAttrText( itemtype =>itemtype,
82: -- itemkey =>itemkey,
83: -- aname =>'PRE_EXPIRE_TIME_PERCENT');
84: l_pre_expire_time_percent := wf_engine.GetActivityAttrText( itemtype =>itemtype,
85: itemkey =>itemkey,
86: actid => actid,
87: aname =>'ALERT_PRE_EXPIRE_TIME_PERCENT');
88: -- Construct the unique item key

Line 94: wf_engine.threshold := -1;

90:
91: --======================================================
92: SELECT l_blanketHeaderId ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
93: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
94: wf_engine.threshold := -1;
95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);

Line 95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);

91: --======================================================
92: SELECT l_blanketHeaderId ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
93: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
94: wf_engine.threshold := -1;
95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);

Line 96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');

92: SELECT l_blanketHeaderId ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
93: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
94: wf_engine.threshold := -1;
95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
100: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);

Line 97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');

93: -- Start the ASP Alert Manager Process (ASP_ALERT_PROCESS) with the following info:
94: wf_engine.threshold := -1;
95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
100: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
101: commit;

Line 98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);

94: wf_engine.threshold := -1;
95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
100: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
101: commit;
102: resultout := 'COMPLETE:SUCCESS';

Line 99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);

95: wf_engine.CreateProcess( itemtype => 'ASPALERT', itemkey => l_item_key, process => 'ASP_ALERT_PROCESS',user_key=>l_item_key);
96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
100: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
101: commit;
102: resultout := 'COMPLETE:SUCCESS';
103: wf_engine.threshold := save_threshold;

Line 100: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);

96: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
97: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
98: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
100: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
101: commit;
102: resultout := 'COMPLETE:SUCCESS';
103: wf_engine.threshold := save_threshold;
104: return;

Line 103: wf_engine.threshold := save_threshold;

99: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
100: wf_engine.StartProcess(itemtype => 'ASPALERT', itemkey => l_item_key);
101: commit;
102: resultout := 'COMPLETE:SUCCESS';
103: wf_engine.threshold := save_threshold;
104: return;
105: --======================================================
106:
107: --May be needed latter

Line 110: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');

106:
107: --May be needed latter
108: --======================================================
109: /*******************************************************
110: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
111: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
112: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
113: --wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
114: if(l_debug_procedure >= l_debug_runtime) then

Line 111: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');

107: --May be needed latter
108: --======================================================
109: /*******************************************************
110: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
111: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
112: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
113: --wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
114: if(l_debug_procedure >= l_debug_runtime) then
115: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'ALERT_NAME '||'BSA_PRE_EXPIRE_ALERT');

Line 112: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);

108: --======================================================
109: /*******************************************************
110: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
111: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
112: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
113: --wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
114: if(l_debug_procedure >= l_debug_runtime) then
115: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'ALERT_NAME '||'BSA_PRE_EXPIRE_ALERT');
116: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'ALERT_SOURCE_OBJECT_CODE '||'ORDER');

Line 113: --wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);

109: /*******************************************************
110: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_NAME', 'BSA_PRE_EXPIRE_ALERT');
111: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_CODE', 'ORDER');
112: wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_SOURCE_OBJECT_ID', l_blanketHeaderId);
113: --wf_engine.SetItemAttrText('ASPALERT', l_item_key, 'ALERT_PRE_EXPIRE_TIME_PERCENT', l_pre_expire_time_percent);
114: if(l_debug_procedure >= l_debug_runtime) then
115: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'ALERT_NAME '||'BSA_PRE_EXPIRE_ALERT');
116: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'ALERT_SOURCE_OBJECT_CODE '||'ORDER');
117: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_blanketHeaderId '||l_blanketHeaderId);

Line 133: wf_engine.threshold := save_threshold;

129: -- activity will indicate that it does not implement a mode
130: -- by returning null
131: --
132: resultout := '';
133: wf_engine.threshold := save_threshold;
134: return;
135:
136: EXCEPTION
137: When no_data_found Then

Line 141: wf_engine.threshold := save_threshold;

137: When no_data_found Then
138: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
139: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
140: wf_core.token('ORA_ERROR',l_debug_msg);
141: wf_engine.threshold := save_threshold;
142: wf_core.raise('WF_ORA');
143:
144: When others Then
145: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

Line 148: wf_engine.threshold := save_threshold;

144: When others Then
145: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
146: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
147: wf_core.token('ORA_ERROR',l_debug_msg);
148: wf_engine.threshold := save_threshold;
149: wf_core.raise('WF_ORA');
150:
151: END Initiate_Bsa_Alerts;
152: