DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on WF_ENGINE

Line 157: 'Calling WF_ENGINE.createprocess');

153: -- Get the user key
154: l_user_key := l_contract_number || ':' || l_wf_sequence;
155: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
156: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
157: 'Calling WF_ENGINE.createprocess');
158: END IF;
159: WF_ENGINE.createprocess (
160: itemtype => G_APPROVAL_ITEM_TYPE,
161: itemkey => l_wf_sequence,

Line 159: WF_ENGINE.createprocess (

155: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
156: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
157: 'Calling WF_ENGINE.createprocess');
158: END IF;
159: WF_ENGINE.createprocess (
160: itemtype => G_APPROVAL_ITEM_TYPE,
161: itemkey => l_wf_sequence,
162: process => G_APPROVAL_PROCESS);
163:

Line 167: 'Calling WF_ENGINE.SetItemUserKey');

163:
164:
165: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
166: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
167: 'Calling WF_ENGINE.SetItemUserKey');
168: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
169: 'User key Value is: ' || l_user_key);
170: END IF;
171: WF_ENGINE.SetItemUserKey (

Line 171: WF_ENGINE.SetItemUserKey (

167: 'Calling WF_ENGINE.SetItemUserKey');
168: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
169: 'User key Value is: ' || l_user_key);
170: END IF;
171: WF_ENGINE.SetItemUserKey (
172: itemtype => G_APPROVAL_ITEM_TYPE,
173: itemkey => l_wf_sequence,
174: userkey => l_user_key);
175:

Line 178: 'Calling WF_ENGINE.SetItemOwner');

174: userkey => l_user_key);
175:
176: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
177: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
178: 'Calling WF_ENGINE.SetItemOwner');
179: END IF;
180: WF_ENGINE.SetItemOwner (
181: itemtype => G_APPROVAL_ITEM_TYPE,
182: itemkey => l_wf_sequence,

Line 180: WF_ENGINE.SetItemOwner (

176: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
177: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
178: 'Calling WF_ENGINE.SetItemOwner');
179: END IF;
180: WF_ENGINE.SetItemOwner (
181: itemtype => G_APPROVAL_ITEM_TYPE,
182: itemkey => l_wf_sequence,
183: owner => fnd_global.user_name);
184:

Line 188: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ID');

184:
185:
186: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
188: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ID');
189: END IF;
190: WF_ENGINE.SetItemAttrText (
191: itemtype => G_APPROVAL_ITEM_TYPE,
192: itemkey => l_wf_sequence,

Line 190: WF_ENGINE.SetItemAttrText (

186: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
188: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ID');
189: END IF;
190: WF_ENGINE.SetItemAttrText (
191: itemtype => G_APPROVAL_ITEM_TYPE,
192: itemkey => l_wf_sequence,
193: aname => 'CONTRACT_ID',
194: avalue => p_contract_id);

Line 198: 'Calling WF_ENGINE.startprocess for REQUESTOR');

194: avalue => p_contract_id);
195:
196: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
198: 'Calling WF_ENGINE.startprocess for REQUESTOR');
199: END IF;
200: WF_ENGINE.SetItemAttrText (
201: itemtype => G_APPROVAL_ITEM_TYPE,
202: itemkey => l_wf_sequence,

Line 200: WF_ENGINE.SetItemAttrText (

196: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
198: 'Calling WF_ENGINE.startprocess for REQUESTOR');
199: END IF;
200: WF_ENGINE.SetItemAttrText (
201: itemtype => G_APPROVAL_ITEM_TYPE,
202: itemkey => l_wf_sequence,
203: aname => 'REQUESTER',
204: avalue => fnd_global.user_name);

Line 209: 'Calling WF_ENGINE.startprocess');

205:
206:
207: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
208: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
209: 'Calling WF_ENGINE.startprocess');
210: END IF;
211: WF_ENGINE.startprocess (
212: itemtype => G_APPROVAL_ITEM_TYPE,
213: itemkey => l_wf_sequence);

Line 211: WF_ENGINE.startprocess (

207: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
208: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
209: 'Calling WF_ENGINE.startprocess');
210: END IF;
211: WF_ENGINE.startprocess (
212: itemtype => G_APPROVAL_ITEM_TYPE,
213: itemkey => l_wf_sequence);
214:
215:

Line 4930: 'Calling wf_engine.CreateProcess()');

4926: );
4927:
4928: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4929: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4930: 'Calling wf_engine.CreateProcess()');
4931: END IF;
4932:
4933: --Create the process
4934: wf_engine.CreateProcess(

Line 4934: wf_engine.CreateProcess(

4930: 'Calling wf_engine.CreateProcess()');
4931: END IF;
4932:
4933: --Create the process
4934: wf_engine.CreateProcess(
4935: itemtype => l_item_type,
4936: itemkey => l_item_key,
4937: process => l_process_name);
4938:

Line 4940: wf_engine.SetItemUserKey (

4936: itemkey => l_item_key,
4937: process => l_process_name);
4938:
4939: --set standard parameter
4940: wf_engine.SetItemUserKey (
4941: itemtype => l_item_type,
4942: itemkey => l_item_key,
4943: userkey => l_item_key);
4944:

Line 4946: wf_engine.SetItemOwner (

4942: itemkey => l_item_key,
4943: userkey => l_item_key);
4944:
4945: --set process owner
4946: wf_engine.SetItemOwner (
4947: itemtype => l_item_type,
4948: itemkey => l_item_key,
4949: owner => fnd_global.user_name);
4950:

Line 4952: wf_engine.SetItemAttrText (

4948: itemkey => l_item_key,
4949: owner => fnd_global.user_name);
4950:
4951: --set contracts role parameter
4952: wf_engine.SetItemAttrText (
4953: itemtype => l_item_type,
4954: itemkey => l_item_key,
4955: aname => l_item_contract_contacts,
4956: avalue => l_contract_contacts_role_name);

Line 4959: wf_engine.SetItemAttrText (

4955: aname => l_item_contract_contacts,
4956: avalue => l_contract_contacts_role_name);
4957:
4958: --set contract id parameter
4959: wf_engine.SetItemAttrText (
4960: itemtype => l_item_type,
4961: itemkey => l_item_key,
4962: aname => l_item_contract_id,
4963: avalue => p_contract_id);

Line 4966: wf_engine.SetItemAttrText (

4962: aname => l_item_contract_id,
4963: avalue => p_contract_id);
4964:
4965: --set contract number parameter
4966: wf_engine.SetItemAttrText (
4967: itemtype => l_item_type,
4968: itemkey => l_item_key,
4969: aname => l_item_contract_number,
4970: avalue => p_contract_number);

Line 4973: wf_engine.SetItemAttrText (

4969: aname => l_item_contract_number,
4970: avalue => p_contract_number);
4971:
4972: --set contract version parameter
4973: wf_engine.SetItemAttrText (
4974: itemtype => l_item_type,
4975: itemkey => l_item_key,
4976: aname => l_item_contract_version,
4977: avalue => p_contract_version);

Line 5004: wf_engine.SetItemAttrText (

5000: --get fnd message
5001: l_subject_text := fnd_message.get;
5002:
5003: --set message subject
5004: wf_engine.SetItemAttrText (
5005: itemtype => l_item_type,
5006: itemkey => l_item_key,
5007: aname => l_item_message_subject,
5008: avalue => l_subject_text);

Line 5012: 'Calling wf_engine.StartProcess()');

5008: avalue => l_subject_text);
5009:
5010: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5011: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5012: 'Calling wf_engine.StartProcess()');
5013: END IF;
5014:
5015: --Start the process
5016: wf_engine.StartProcess(

Line 5016: wf_engine.StartProcess(

5012: 'Calling wf_engine.StartProcess()');
5013: END IF;
5014:
5015: --Start the process
5016: wf_engine.StartProcess(
5017: itemtype => l_item_type,
5018: itemkey => l_item_key);
5019:
5020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5228: 'Calling WF_ENGINE.AbortProcess');

5224: CLOSE contract_csr;
5225:
5226: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5227: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5228: 'Calling WF_ENGINE.AbortProcess');
5229: END IF;
5230:
5231: -- Check the status of the contract is Pending Approval before aborting the approval process
5232: IF (l_contract_status = G_STATUS_PENDING_APPROVAL) THEN

Line 5235: WF_ENGINE.AbortProcess(

5231: -- Check the status of the contract is Pending Approval before aborting the approval process
5232: IF (l_contract_status = G_STATUS_PENDING_APPROVAL) THEN
5233:
5234: -- Call WF API to abort the approval process
5235: WF_ENGINE.AbortProcess(
5236: itemtype => l_wf_type,
5237: itemkey => l_wf_key,
5238: result => 'COMPLETE:',
5239: verify_lock => false,