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.OKC_REP_WF_PVT dependencies on FND_LOG

Line 117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

113: BEGIN
114:
115: l_api_name := 'initialize_attributes';
116:
117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
119: 'Entered OKC_REP_WF_PVT.initialize_attributes');
120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
121: 'Item Type is: ' || itemtype);

Line 118: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

114:
115: l_api_name := 'initialize_attributes';
116:
117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
119: 'Entered OKC_REP_WF_PVT.initialize_attributes');
120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
121: 'Item Type is: ' || itemtype);
122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

116:
117: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
118: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
119: 'Entered OKC_REP_WF_PVT.initialize_attributes');
120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
121: 'Item Type is: ' || itemtype);
122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
123: 'Item Key is: ' || itemkey);
124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

118: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
119: 'Entered OKC_REP_WF_PVT.initialize_attributes');
120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
121: 'Item Type is: ' || itemtype);
122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
123: 'Item Key is: ' || itemkey);
124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
125: 'actid is: ' || to_char(actid));
126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
121: 'Item Type is: ' || itemtype);
122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
123: 'Item Key is: ' || itemkey);
124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
125: 'actid is: ' || to_char(actid));
126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
127: 'Function mode is: ' || funcmode);
128: END IF;

Line 126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
123: 'Item Key is: ' || itemkey);
124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
125: 'actid is: ' || to_char(actid));
126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
127: 'Function mode is: ' || funcmode);
128: END IF;
129: IF (funcmode = 'RUN') THEN
130: l_contract_id := wf_engine.GetItemAttrNumber(

Line 142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

138: IF(contract_csr%NOTFOUND) THEN
139: RAISE NO_DATA_FOUND;
140: END IF;
141:
142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
144: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
145: END IF;
146: WF_ENGINE.SetItemAttrText (

Line 143: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

139: RAISE NO_DATA_FOUND;
140: END IF;
141:
142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
144: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
145: END IF;
146: WF_ENGINE.SetItemAttrText (
147: itemtype => itemtype,

Line 152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

148: itemkey => itemkey,
149: aname => 'CONTRACT_TYPE',
150: avalue => contract_rec.contract_type);
151:
152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
154: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
155: END IF;
156: WF_ENGINE.SetItemAttrText (

Line 153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

149: aname => 'CONTRACT_TYPE',
150: avalue => contract_rec.contract_type);
151:
152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
154: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
155: END IF;
156: WF_ENGINE.SetItemAttrText (
157: itemtype => itemtype,

Line 163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

159: aname => 'CONTRACT_NUMBER',
160: avalue => contract_rec.contract_number);
161:
162:
163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
165: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
166: END IF;
167: WF_ENGINE.SetItemAttrNumber (

Line 164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

160: avalue => contract_rec.contract_number);
161:
162:
163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
164: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
165: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
166: END IF;
167: WF_ENGINE.SetItemAttrNumber (
168: itemtype => itemtype,

Line 173: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

169: itemkey => itemkey,
170: aname => 'CONTRACT_VERSION',
171: avalue => contract_rec.contract_version_num);
172:
173: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
175: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
176: END IF;
177: WF_ENGINE.SetItemAttrText (

Line 174: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

170: aname => 'CONTRACT_VERSION',
171: avalue => contract_rec.contract_version_num);
172:
173: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
175: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
176: END IF;
177: WF_ENGINE.SetItemAttrText (
178: itemtype => itemtype,

Line 183: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

179: itemkey => itemkey,
180: aname => 'CONTRACT_NAME',
181: avalue => contract_rec.contract_name);
182:
183: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
185: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
186: END IF;
187: WF_ENGINE.SetItemAttrText (

Line 184: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

180: aname => 'CONTRACT_NAME',
181: avalue => contract_rec.contract_name);
182:
183: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
185: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
186: END IF;
187: WF_ENGINE.SetItemAttrText (
188: itemtype => itemtype,

Line 204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

200: -- transactionIdIn => fnd_number.number_to_canonical(l_contract_id));
201:
202: CLOSE contract_csr;
203: resultout := 'COMPLETE:';
204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
206: g_module || l_api_name ,
207: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=RUN');
208: END IF;

Line 205: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

201:
202: CLOSE contract_csr;
203: resultout := 'COMPLETE:';
204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
206: g_module || l_api_name ,
207: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=RUN');
208: END IF;
209: RETURN;

Line 215: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

211:
212:
213: IF (funcmode = 'CANCEL') THEN
214: resultout := 'COMPLETE:';
215: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
216: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
217: g_module || l_api_name,
218: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=CANCEL');
219: END IF;

Line 216: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

212:
213: IF (funcmode = 'CANCEL') THEN
214: resultout := 'COMPLETE:';
215: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
216: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
217: g_module || l_api_name,
218: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=CANCEL');
219: END IF;
220: RETURN;

Line 225: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

221: END IF; -- (funcmode = 'CANCEL')
222:
223: IF (funcmode = 'TIMEOUT') THEN
224: resultout := 'COMPLETE:';
225: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
227: g_module || l_api_name,
228: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=TIMEOUT');
229: END IF;

Line 226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

222:
223: IF (funcmode = 'TIMEOUT') THEN
224: resultout := 'COMPLETE:';
225: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
226: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
227: g_module || l_api_name,
228: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=TIMEOUT');
229: END IF;
230: RETURN;

Line 239: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

235: --close cursors
236: IF (contract_csr%ISOPEN) THEN
237: CLOSE contract_csr ;
238: END IF;
239: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
241: g_module || l_api_name,
242: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
243: END IF;

Line 240: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

236: IF (contract_csr%ISOPEN) THEN
237: CLOSE contract_csr ;
238: END IF;
239: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
241: g_module || l_api_name,
242: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
243: END IF;
244: wf_core.context('OKC_REP_WF_PVT',

Line 296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

292: BEGIN
293:
294: l_api_name := 'has_next_approver';
295:
296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
298: 'Entered OKC_REP_WF_PVT.has_next_approver');
299: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
300: 'Item Type is: ' || itemtype);

Line 297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

293:
294: l_api_name := 'has_next_approver';
295:
296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
298: 'Entered OKC_REP_WF_PVT.has_next_approver');
299: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
300: 'Item Type is: ' || itemtype);
301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 299: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

295:
296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
298: 'Entered OKC_REP_WF_PVT.has_next_approver');
299: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
300: 'Item Type is: ' || itemtype);
301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
302: 'Item Key is: ' || itemkey);
303: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
298: 'Entered OKC_REP_WF_PVT.has_next_approver');
299: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
300: 'Item Type is: ' || itemtype);
301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
302: 'Item Key is: ' || itemkey);
303: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
304: 'actid is: ' || to_char(actid));
305: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 303: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

299: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
300: 'Item Type is: ' || itemtype);
301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
302: 'Item Key is: ' || itemkey);
303: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
304: 'actid is: ' || to_char(actid));
305: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
306: 'Function mode is: ' || funcmode);
307: END IF;

Line 305: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
302: 'Item Key is: ' || itemkey);
303: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
304: 'actid is: ' || to_char(actid));
305: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
306: 'Function mode is: ' || funcmode);
307: END IF;
308: IF (funcmode = 'RUN') then
309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

305: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
306: 'Function mode is: ' || funcmode);
307: END IF;
308: IF (funcmode = 'RUN') then
309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
310: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
311: g_module || l_api_name,
312: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
313: END IF;

Line 310: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

306: 'Function mode is: ' || funcmode);
307: END IF;
308: IF (funcmode = 'RUN') then
309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
310: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
311: g_module || l_api_name,
312: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
313: END IF;
314: l_contract_id := wf_engine.GetItemAttrNumber(

Line 318: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

314: l_contract_id := wf_engine.GetItemAttrNumber(
315: itemtype => itemtype,
316: itemkey => itemkey,
317: aname => 'CONTRACT_ID');
318: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
320: g_module || l_api_name,
321: 'Contract Id is: ' || to_char(l_contract_id));
322: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 319: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

315: itemtype => itemtype,
316: itemkey => itemkey,
317: aname => 'CONTRACT_ID');
318: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
320: g_module || l_api_name,
321: 'Contract Id is: ' || to_char(l_contract_id));
322: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
323: g_module || l_api_name,

Line 322: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

318: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
320: g_module || l_api_name,
321: 'Contract Id is: ' || to_char(l_contract_id));
322: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
323: g_module || l_api_name,
324: 'Calling ame_api.getNextApprover to get the approver id');
325: END IF;
326: ame_api2.getNextApprovers1(

Line 337: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

333: itemIndexesOut => l_item_indexes,
334: itemClassesOut => l_item_classes,
335: itemIdsOut => l_item_ids,
336: itemSourcesOut => l_item_sources);
337: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
338: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
339: g_module || l_api_name,
340: 'Number of approvers: ' || to_char(l_next_approvers.count));
341: END IF;

Line 338: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

334: itemClassesOut => l_item_classes,
335: itemIdsOut => l_item_ids,
336: itemSourcesOut => l_item_sources);
337: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
338: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
339: g_module || l_api_name,
340: 'Number of approvers: ' || to_char(l_next_approvers.count));
341: END IF;
342: IF (l_next_approvers.count = 0) THEN

Line 372: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

368: END IF;
369: END IF;
370: END LOOP;
371:
372: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
373: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
374: g_module || l_api_name,
375: 'Adhoc role name is : ' || l_user_names);
376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 373: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

369: END IF;
370: END LOOP;
371:
372: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
373: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
374: g_module || l_api_name,
375: 'Adhoc role name is : ' || l_user_names);
376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
377: g_module || l_api_name,

Line 376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

372: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
373: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
374: g_module || l_api_name,
375: 'Adhoc role name is : ' || l_user_names);
376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
377: g_module || l_api_name,
378: 'Calling WF_DIRECTORY.createAdHocRole');
379: END IF;
380: -- Create an adhoc role using l_user_names

Line 393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

389: email_address=>null,
390: fax=>null,
391: status=>'ACTIVE',
392: expiration_date=>SYSDATE+1);
393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
395: g_module || l_api_name,
396: 'Completed Adhoc role creation');
397: END IF;

Line 394: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

390: fax=>null,
391: status=>'ACTIVE',
392: expiration_date=>SYSDATE+1);
393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
395: g_module || l_api_name,
396: 'Completed Adhoc role creation');
397: END IF;
398: wf_engine.SetItemAttrText (

Line 406: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

402: avalue => l_role_name);
403: resultout := 'COMPLETE:T';
404: END IF; -- (l_next_approvers.count = 0)
405:
406: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
408: g_module || l_api_name,
409: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=RUN');
410: END IF;

Line 407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

403: resultout := 'COMPLETE:T';
404: END IF; -- (l_next_approvers.count = 0)
405:
406: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
408: g_module || l_api_name,
409: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=RUN');
410: END IF;
411: RETURN;

Line 417: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

413:
414:
415: IF (funcmode = 'CANCEL') THEN
416: resultout := 'COMPLETE:';
417: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
419: g_module || l_api_name,
420: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=CANCEL');
421: END IF;

Line 418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

414:
415: IF (funcmode = 'CANCEL') THEN
416: resultout := 'COMPLETE:';
417: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
419: g_module || l_api_name,
420: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=CANCEL');
421: END IF;
422: RETURN;

Line 427: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

423: END IF; -- (funcmode = 'CANCEL')
424:
425: IF (funcmode = 'TIMEOUT') THEN
426: resultout := 'COMPLETE:';
427: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
429: g_module || l_api_name,
430: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=TIMEOUT');
431: END IF;

Line 428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

424:
425: IF (funcmode = 'TIMEOUT') THEN
426: resultout := 'COMPLETE:';
427: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
429: g_module || l_api_name,
430: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=TIMEOUT');
431: END IF;
432: RETURN;

Line 437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

433: END IF; -- (funcmode = 'TIMEOUT')
434:
435: EXCEPTION
436: WHEN others THEN
437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
439: g_module || l_api_name,
440: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
441: END IF;

Line 438: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

434:
435: EXCEPTION
436: WHEN others THEN
437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
439: g_module || l_api_name,
440: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
441: END IF;
442: wf_core.context('OKC_REP_WF_PVT',

Line 508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

504:
505: l_api_name := 'is_approval_complete';
506:
507:
508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
510: 'Entered OKC_REP_WF_PVT.is_approval_complete');
511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
512: 'Item Type is: ' || itemtype);

Line 509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

505: l_api_name := 'is_approval_complete';
506:
507:
508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
510: 'Entered OKC_REP_WF_PVT.is_approval_complete');
511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
512: 'Item Type is: ' || itemtype);
513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

507:
508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
510: 'Entered OKC_REP_WF_PVT.is_approval_complete');
511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
512: 'Item Type is: ' || itemtype);
513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
514: 'Item Key is: ' || itemkey);
515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
510: 'Entered OKC_REP_WF_PVT.is_approval_complete');
511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
512: 'Item Type is: ' || itemtype);
513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
514: 'Item Key is: ' || itemkey);
515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
516: 'actid is: ' || to_char(actid));
517: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
512: 'Item Type is: ' || itemtype);
513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
514: 'Item Key is: ' || itemkey);
515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
516: 'actid is: ' || to_char(actid));
517: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
518: 'Function mode is: ' || funcmode);
519: END IF;

Line 517: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
514: 'Item Key is: ' || itemkey);
515: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
516: 'actid is: ' || to_char(actid));
517: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
518: 'Function mode is: ' || funcmode);
519: END IF;
520: IF (funcmode = 'RUN') then
521: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 521: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

517: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
518: 'Function mode is: ' || funcmode);
519: END IF;
520: IF (funcmode = 'RUN') then
521: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
523: g_module || l_api_name,
524: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
525: END IF;

Line 522: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

518: 'Function mode is: ' || funcmode);
519: END IF;
520: IF (funcmode = 'RUN') then
521: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
523: g_module || l_api_name,
524: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
525: END IF;
526: l_contract_id := wf_engine.GetItemAttrNumber(

Line 530: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

526: l_contract_id := wf_engine.GetItemAttrNumber(
527: itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'CONTRACT_ID');
530: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
531: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
532: g_module || l_api_name,
533: 'Contract Id is: ' || to_char(l_contract_id));
534: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 531: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

527: itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'CONTRACT_ID');
530: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
531: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
532: g_module || l_api_name,
533: 'Contract Id is: ' || to_char(l_contract_id));
534: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
535: g_module || l_api_name,

Line 534: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

530: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
531: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
532: g_module || l_api_name,
533: 'Contract Id is: ' || to_char(l_contract_id));
534: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
535: g_module || l_api_name,
536: 'Calling ame_api2.getNextApprover1 to get the approver id');
537: END IF;
538: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

Line 550: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

546: itemIndexesOut => l_item_indexes,
547: itemClassesOut => l_item_classes,
548: itemIdsOut => l_item_ids,
549: itemSourcesOut => l_item_sources);
550: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
552: g_module || l_api_name,
553: 'Number of approvers: ' || to_char(l_next_approvers.count));
554: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

547: itemClassesOut => l_item_classes,
548: itemIdsOut => l_item_ids,
549: itemSourcesOut => l_item_sources);
550: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
552: g_module || l_api_name,
553: 'Number of approvers: ' || to_char(l_next_approvers.count));
554: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
555: g_module || l_api_name,

Line 554: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

550: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
552: g_module || l_api_name,
553: 'Number of approvers: ' || to_char(l_next_approvers.count));
554: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
555: g_module || l_api_name,
556: 'l_process_complete_yn: ' || l_process_complete_yn);
557: END IF;
558: IF (l_process_complete_yn = 'W') THEN

Line 655: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

651:
652: END IF; --g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem
653:
654: -- l_user_name := l_next_approvers(i).name;
655: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
657: g_module || l_api_name,
658: 'User name for role is : ' || l_user_name);
659: END IF;

Line 656: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

652: END IF; --g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem
653:
654: -- l_user_name := l_next_approvers(i).name;
655: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
657: g_module || l_api_name,
658: 'User name for role is : ' || l_user_name);
659: END IF;
660: l_notified_count := l_notified_count + 1;

Line 662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

658: 'User name for role is : ' || l_user_name);
659: END IF;
660: l_notified_count := l_notified_count + 1;
661: l_item_key := itemkey || '_' || to_char(l_notified_count);
662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
663: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
664: 'Calling WF_ENGINE.createprocess for Notification');
665: END IF;
666:

Line 663: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

659: END IF;
660: l_notified_count := l_notified_count + 1;
661: l_item_key := itemkey || '_' || to_char(l_notified_count);
662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
663: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
664: 'Calling WF_ENGINE.createprocess for Notification');
665: END IF;
666:
667: WF_ENGINE.createprocess (

Line 672: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

668: itemtype => itemtype,
669: itemkey => l_item_key,
670: process => G_APPROVAL_NOTIF_PROCESS);
671:
672: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
674: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
675: END IF;
676: WF_ENGINE.SetItemOwner (

Line 673: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

669: itemkey => l_item_key,
670: process => G_APPROVAL_NOTIF_PROCESS);
671:
672: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
674: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
675: END IF;
676: WF_ENGINE.SetItemOwner (
677: itemtype => itemtype,

Line 681: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

677: itemtype => itemtype,
678: itemkey => l_item_key,
679: owner => fnd_global.user_name);
680:
681: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
683: 'Setting Notification Process Approver to: ' || l_user_name);
684: END IF;
685: WF_ENGINE.SetItemAttrText (

Line 682: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

678: itemkey => l_item_key,
679: owner => fnd_global.user_name);
680:
681: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
683: 'Setting Notification Process Approver to: ' || l_user_name);
684: END IF;
685: WF_ENGINE.SetItemAttrText (
686: itemtype => itemtype,

Line 691: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

687: itemkey => l_item_key,
688: aname => 'APPROVER',
689: avalue => l_user_name);
690:
691: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
692: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
693: 'Setting Notification Process Contract Id to: ' || l_contract_id);
694: END IF;
695: WF_ENGINE.SetItemAttrNumber (

Line 692: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

688: aname => 'APPROVER',
689: avalue => l_user_name);
690:
691: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
692: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
693: 'Setting Notification Process Contract Id to: ' || l_contract_id);
694: END IF;
695: WF_ENGINE.SetItemAttrNumber (
696: itemtype => itemtype,

Line 701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

697: itemkey => l_item_key,
698: aname => 'CONTRACT_ID',
699: avalue => l_contract_id);
700:
701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
703: 'Setting Notification Process Contract Name: ' || l_contract_name);
704: END IF;
705: WF_ENGINE.SetItemAttrText (

Line 702: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

698: aname => 'CONTRACT_ID',
699: avalue => l_contract_id);
700:
701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
703: 'Setting Notification Process Contract Name: ' || l_contract_name);
704: END IF;
705: WF_ENGINE.SetItemAttrText (
706: itemtype => itemtype,

Line 711: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

707: itemkey => l_item_key,
708: aname => 'CONTRACT_NAME',
709: avalue => l_contract_name);
710:
711: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
713: 'Setting Notification Process Contract Version: ' || l_contract_version);
714: END IF;
715: WF_ENGINE.SetItemAttrNumber (

Line 712: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

708: aname => 'CONTRACT_NAME',
709: avalue => l_contract_name);
710:
711: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
713: 'Setting Notification Process Contract Version: ' || l_contract_version);
714: END IF;
715: WF_ENGINE.SetItemAttrNumber (
716: itemtype => itemtype,

Line 721: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

717: itemkey => l_item_key,
718: aname => 'CONTRACT_VERSION',
719: avalue => l_contract_version);
720:
721: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
722: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
723: 'Setting Notification Process Contract Type: ' || l_contract_type);
724: END IF;
725: WF_ENGINE.SetItemAttrText (

Line 722: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

718: aname => 'CONTRACT_VERSION',
719: avalue => l_contract_version);
720:
721: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
722: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
723: 'Setting Notification Process Contract Type: ' || l_contract_type);
724: END IF;
725: WF_ENGINE.SetItemAttrText (
726: itemtype => itemtype,

Line 731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

727: itemkey => l_item_key,
728: aname => 'CONTRACT_TYPE',
729: avalue => l_contract_type);
730:
731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
732: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
733: 'Setting Notification Process Contract Number: ' || l_contract_number);
734: END IF;
735: WF_ENGINE.SetItemAttrText (

Line 732: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

728: aname => 'CONTRACT_TYPE',
729: avalue => l_contract_type);
730:
731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
732: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
733: 'Setting Notification Process Contract Number: ' || l_contract_number);
734: END IF;
735: WF_ENGINE.SetItemAttrText (
736: itemtype => itemtype,

Line 741: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

737: itemkey => l_item_key,
738: aname => 'CONTRACT_NUMBER',
739: avalue => l_contract_number);
740:
741: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
743: 'Setting Notification Process Requester: ' || l_requester);
744: END IF;
745: WF_ENGINE.SetItemAttrText (

Line 742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

738: aname => 'CONTRACT_NUMBER',
739: avalue => l_contract_number);
740:
741: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
743: 'Setting Notification Process Requester: ' || l_requester);
744: END IF;
745: WF_ENGINE.SetItemAttrText (
746: itemtype => itemtype,

Line 751: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

747: itemkey => l_item_key,
748: aname => 'REQUESTER',
749: avalue => l_requester);
750:
751: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
753: 'Setting Notification Process Contract Attachment');
754: END IF;
755: WF_ENGINE.SetItemAttrText (

Line 752: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

748: aname => 'REQUESTER',
749: avalue => l_requester);
750:
751: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
752: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
753: 'Setting Notification Process Contract Attachment');
754: END IF;
755: WF_ENGINE.SetItemAttrText (
756: itemtype => itemtype,

Line 763: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

759: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type
760: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
761: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
762:
763: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
765: 'Setting Notification Process Master Item Key to: ' || itemkey);
766: END IF;
767: WF_ENGINE.SetItemAttrText (

Line 764: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

760: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
761: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
762:
763: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
765: 'Setting Notification Process Master Item Key to: ' || itemkey);
766: END IF;
767: WF_ENGINE.SetItemAttrText (
768: itemtype => itemtype,

Line 775: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

771: avalue => itemkey);
772:
773: --14758583 : kkolukul : HR position group support
774: --Setting attributes for the parent process
775: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
777: 'Setting Notification Process APPROVER_TYPE to: ' || l_approver_type);
778: END IF;
779: WF_ENGINE.SetItemAttrText (

Line 776: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

772:
773: --14758583 : kkolukul : HR position group support
774: --Setting attributes for the parent process
775: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
776: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
777: 'Setting Notification Process APPROVER_TYPE to: ' || l_approver_type);
778: END IF;
779: WF_ENGINE.SetItemAttrText (
780: itemtype => itemtype,

Line 785: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

781: itemkey => itemkey,
782: aname => 'APPROVER_TYPE',
783: avalue => l_approver_type);
784:
785: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
786: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
787: 'Setting Notification Process APPROVER_POS_NAME to: ' || l_approver_name);
788: END IF;
789:

Line 786: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

782: aname => 'APPROVER_TYPE',
783: avalue => l_approver_type);
784:
785: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
786: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
787: 'Setting Notification Process APPROVER_POS_NAME to: ' || l_approver_name);
788: END IF;
789:
790: WF_ENGINE.SetItemAttrText (

Line 803: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

799: itemkey => l_item_key,
800: aname => 'APPROVER_TYPE',
801: avalue => l_approver_type);
802:
803: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
805: 'Setting Notification Process APPROVER_POS_NAME to: ' || l_approver_name);
806: END IF;
807:

Line 804: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

800: aname => 'APPROVER_TYPE',
801: avalue => l_approver_type);
802:
803: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
805: 'Setting Notification Process APPROVER_POS_NAME to: ' || l_approver_name);
806: END IF;
807:
808: WF_ENGINE.SetItemAttrText (

Line 814: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

810: itemkey => l_item_key,
811: aname => 'APPROVER_POS_NAME',
812: avalue => l_approver_name);
813:
814: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
816: 'Setting Notification Process Approver group Id to: ' || l_group_id);
817: END IF;
818: WF_ENGINE.SetItemAttrText (

Line 815: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

811: aname => 'APPROVER_POS_NAME',
812: avalue => l_approver_name);
813:
814: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
816: 'Setting Notification Process Approver group Id to: ' || l_group_id);
817: END IF;
818: WF_ENGINE.SetItemAttrText (
819: itemtype => itemtype,

Line 827: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

823:
824:
825: --14758583 : kkolukul : HR position group support
826:
827: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
828: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
829: 'Starting Notification Process ');
830: END IF;
831: wf_engine.startProcess(

Line 828: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

824:
825: --14758583 : kkolukul : HR position group support
826:
827: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
828: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
829: 'Starting Notification Process ');
830: END IF;
831: wf_engine.startProcess(
832: itemtype => itemtype,

Line 836: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

832: itemtype => itemtype,
833: itemkey => l_item_key);
834: END IF; -- l_next_approvers.exists(i)
835: END LOOP;
836: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
839: END IF;
840: WF_ENGINE.SetItemAttrNumber (

Line 837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

833: itemkey => l_item_key);
834: END IF; -- l_next_approvers.exists(i)
835: END LOOP;
836: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
839: END IF;
840: WF_ENGINE.SetItemAttrNumber (
841: itemtype => itemtype,

Line 847: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

843: aname => 'APPROVER_COUNTER',
844: avalue => l_notified_count);
845: END IF; -- (l_next_approvers.count > 0)
846:
847: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
849: g_module || l_api_name,
850: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=RUN');
851: END IF;

Line 848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

844: avalue => l_notified_count);
845: END IF; -- (l_next_approvers.count > 0)
846:
847: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
849: g_module || l_api_name,
850: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=RUN');
851: END IF;
852: RETURN;

Line 858: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

854:
855:
856: IF (funcmode = 'CANCEL') THEN
857: resultout := 'COMPLETE:';
858: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
860: g_module || l_api_name,
861: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=CANCEL');
862: END IF;

Line 859: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

855:
856: IF (funcmode = 'CANCEL') THEN
857: resultout := 'COMPLETE:';
858: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
860: g_module || l_api_name,
861: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=CANCEL');
862: END IF;
863: RETURN;

Line 868: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

864: END IF; -- (funcmode = 'CANCEL')
865:
866: IF (funcmode = 'TIMEOUT') THEN
867: resultout := 'COMPLETE:';
868: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
870: g_module || l_api_name,
871: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=TIMEOUT');
872: END IF;

Line 869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

865:
866: IF (funcmode = 'TIMEOUT') THEN
867: resultout := 'COMPLETE:';
868: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
870: g_module || l_api_name,
871: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=TIMEOUT');
872: END IF;
873: RETURN;

Line 878: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

874: END IF; -- (funcmode = 'TIMEOUT')
875:
876: EXCEPTION
877: WHEN others THEN
878: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
879: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
880: g_module || l_api_name,
881: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
882: END IF;

Line 879: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

875:
876: EXCEPTION
877: WHEN others THEN
878: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
879: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
880: g_module || l_api_name,
881: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
882: END IF;
883: wf_core.context('OKC_REP_WF_PVT',

Line 963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

959: BEGIN
960:
961: l_api_name := 'update_ame_status';
962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered OKC_REP_WF_PVT.update_ame_status');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Item Type is: ' || itemtype);

Line 964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

960:
961: l_api_name := 'update_ame_status';
962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered OKC_REP_WF_PVT.update_ame_status');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Item Type is: ' || itemtype);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered OKC_REP_WF_PVT.update_ame_status');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Item Type is: ' || itemtype);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Item Key is: ' || itemkey);
970: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered OKC_REP_WF_PVT.update_ame_status');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Item Type is: ' || itemtype);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Item Key is: ' || itemkey);
970: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
971: 'actid is: ' || to_char(actid));
972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 970: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Item Type is: ' || itemtype);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Item Key is: ' || itemkey);
970: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
971: 'actid is: ' || to_char(actid));
972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
973: 'Function mode is: ' || funcmode);
974: END IF;

Line 972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Item Key is: ' || itemkey);
970: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
971: 'actid is: ' || to_char(actid));
972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
973: 'Function mode is: ' || funcmode);
974: END IF;
975: -- Get contract id and version attributes
976: l_contract_id := wf_engine.GetItemAttrNumber(

Line 1000: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

996: l_approver_name := WF_NOTIFICATION.GetAttrText(
997: nid => WF_ENGINE.context_nid,
998: aname => 'APPROVER_POS_NAME');
999:
1000: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1002: g_module || l_api_name,
1003: 'Contract Id is: ' || to_char(l_contract_id));
1004: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

997: nid => WF_ENGINE.context_nid,
998: aname => 'APPROVER_POS_NAME');
999:
1000: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1002: g_module || l_api_name,
1003: 'Contract Id is: ' || to_char(l_contract_id));
1004: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1005: g_module || l_api_name,

Line 1004: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1000: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1002: g_module || l_api_name,
1003: 'Contract Id is: ' || to_char(l_contract_id));
1004: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1005: g_module || l_api_name,
1006: 'Contract Version is: ' || to_char(l_contract_version));
1007: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1008: g_module || l_api_name,

Line 1007: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1003: 'Contract Id is: ' || to_char(l_contract_id));
1004: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1005: g_module || l_api_name,
1006: 'Contract Version is: ' || to_char(l_contract_version));
1007: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1008: g_module || l_api_name,
1009: 'Approver Notes : ' || l_wf_note);
1010: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1011: g_module || l_api_name,

Line 1010: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1006: 'Contract Version is: ' || to_char(l_contract_version));
1007: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1008: g_module || l_api_name,
1009: 'Approver Notes : ' || l_wf_note);
1010: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1011: g_module || l_api_name,
1012: 'Approver action is : ' || l_approval_status);
1013: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1014: g_module || l_api_name,

Line 1013: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1009: 'Approver Notes : ' || l_wf_note);
1010: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1011: g_module || l_api_name,
1012: 'Approver action is : ' || l_approval_status);
1013: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1014: g_module || l_api_name,
1015: 'Approver Type is : ' || l_approver_type);
1016: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1017: g_module || l_api_name,

Line 1016: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1012: 'Approver action is : ' || l_approval_status);
1013: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1014: g_module || l_api_name,
1015: 'Approver Type is : ' || l_approver_type);
1016: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1017: g_module || l_api_name,
1018: 'Approver Name is : ' || l_approver_name);
1019: END IF;
1020: -- Get the notification recipient

Line 1026: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1022: FETCH notif_csr into notif_rec;
1023: IF(notif_csr%NOTFOUND) THEN
1024: RAISE NO_DATA_FOUND;
1025: END IF;
1026: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1028: g_module || l_api_name,
1029: 'Approver Name is : ' || notif_rec.user_name);
1030: END IF;

Line 1027: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1023: IF(notif_csr%NOTFOUND) THEN
1024: RAISE NO_DATA_FOUND;
1025: END IF;
1026: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1028: g_module || l_api_name,
1029: 'Approver Name is : ' || notif_rec.user_name);
1030: END IF;
1031: -- l_approver_record2.name := notif_rec.user_name;

Line 1042: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1038: -- FUNCTION MODE IS RESPOND.
1039: IF (funcmode = 'RESPOND') THEN
1040: -- CURRENT APPROVER APPROVED THE CONTRACTS
1041: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
1042: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1044: g_module || l_api_name,
1045: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1046: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1039: IF (funcmode = 'RESPOND') THEN
1040: -- CURRENT APPROVER APPROVED THE CONTRACTS
1041: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
1042: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1044: g_module || l_api_name,
1045: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1046: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1047: g_module || l_api_name,

Line 1046: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1042: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1044: g_module || l_api_name,
1045: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1046: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1047: g_module || l_api_name,
1048: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1049: END IF;
1050: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 1061: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1057: p_note => l_wf_note,
1058: x_msg_data => l_msg_data,
1059: x_msg_count => l_msg_count,
1060: x_return_status => l_return_status);
1061: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1063: g_module || l_api_name,
1064: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1065: END IF;

Line 1062: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1058: x_msg_data => l_msg_data,
1059: x_msg_count => l_msg_count,
1060: x_return_status => l_return_status);
1061: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1063: g_module || l_api_name,
1064: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1065: END IF;
1066: -------------------------------------------------------

Line 1084: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1080:
1081: -- CURRENT APPROVER APPROVED THE CONTRACTS
1082: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
1083: -- Add a record in ONC_REP_CON_APPROVALS table.
1084: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1085: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1086: g_module || l_api_name,
1087: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1088: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1085: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1081: -- CURRENT APPROVER APPROVED THE CONTRACTS
1082: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
1083: -- Add a record in ONC_REP_CON_APPROVALS table.
1084: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1085: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1086: g_module || l_api_name,
1087: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1088: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1089: g_module || l_api_name,

Line 1088: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1084: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1085: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1086: g_module || l_api_name,
1087: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1088: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1089: g_module || l_api_name,
1090: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1091: END IF;
1092: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1099: p_note => l_wf_note,
1100: x_msg_data => l_msg_data,
1101: x_msg_count => l_msg_count,
1102: x_return_status => l_return_status);
1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1105: g_module || l_api_name,
1106: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1107: END IF;

Line 1104: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1100: x_msg_data => l_msg_data,
1101: x_msg_count => l_msg_count,
1102: x_return_status => l_return_status);
1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1105: g_module || l_api_name,
1106: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1107: END IF;
1108: -------------------------------------------------------

Line 1118: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1114: --------------------------------------------------------
1115:
1116: l_approver_record2.approval_status := ame_util.rejectStatus;
1117: -- Update AME approval status
1118: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1119: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1120: g_module || l_api_name,
1121: 'Calling ame_api2.updateApprovalStatus');
1122: END IF;

Line 1119: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1115:
1116: l_approver_record2.approval_status := ame_util.rejectStatus;
1117: -- Update AME approval status
1118: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1119: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1120: g_module || l_api_name,
1121: 'Calling ame_api2.updateApprovalStatus');
1122: END IF;
1123: ame_api2.updateApprovalStatus(

Line 1130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1126: approverIn => l_approver_record2,
1127: transactionTypeIn => G_TRANSACTION_TYPE);
1128: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
1129: CLOSE notif_csr;
1130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1132: g_module || l_api_name,
1133: 'resultout value is: ' || resultout);
1134: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 1131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1127: transactionTypeIn => G_TRANSACTION_TYPE);
1128: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
1129: CLOSE notif_csr;
1130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1132: g_module || l_api_name,
1133: 'resultout value is: ' || resultout);
1134: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1135: g_module || l_api_name,

Line 1134: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1131: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1132: g_module || l_api_name,
1133: 'resultout value is: ' || resultout);
1134: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1135: g_module || l_api_name,
1136: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RESPOND');
1137: END IF;
1138: END IF; -- (funcmode = 'RESPOND')

Line 1150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1146: ELSIF (l_approval_status = G_WF_STATUS_MORE_APPROVERS) THEN
1147: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
1148: ELSE resultout := 'COMPLETE:';
1149: END IF;
1150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1152: g_module || l_api_name,
1153: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');
1154: END IF;

Line 1151: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1147: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
1148: ELSE resultout := 'COMPLETE:';
1149: END IF;
1150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1152: g_module || l_api_name,
1153: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');
1154: END IF;
1155: CLOSE notif_csr;

Line 1160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1156: RETURN;
1157: END IF; -- (funcmode = 'RUN')
1158:
1159: IF (funcmode = 'TIMEOUT') THEN
1160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1162: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1163: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

Line 1161: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,

1157: END IF; -- (funcmode = 'RUN')
1158:
1159: IF (funcmode = 'TIMEOUT') THEN
1160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1162: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1163: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1165: END IF;

Line 1163: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,

1159: IF (funcmode = 'TIMEOUT') THEN
1160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1162: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1163: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1165: END IF;
1166: OKC_REP_UTIL_PVT.add_approval_hist_record(
1167: p_api_version => 1.0,

Line 1177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1173: p_note => l_wf_note,
1174: x_msg_data => l_msg_data,
1175: x_msg_count => l_msg_count,
1176: x_return_status => l_return_status);
1177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1179: g_module || l_api_name,
1180: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1181: END IF;

Line 1178: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1174: x_msg_data => l_msg_data,
1175: x_msg_count => l_msg_count,
1176: x_return_status => l_return_status);
1177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1179: g_module || l_api_name,
1180: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1181: END IF;
1182: -------------------------------------------------------

Line 1191: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1187: END IF;
1188: --------------------------------------------------------
1189: l_approver_record2.approval_status := ame_util.noResponseStatus;
1190:
1191: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1193: g_module || l_api_name,
1194: 'Calling ame_api2.updateApprovalStatus');
1195: END IF;

Line 1192: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1188: --------------------------------------------------------
1189: l_approver_record2.approval_status := ame_util.noResponseStatus;
1190:
1191: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1193: g_module || l_api_name,
1194: 'Calling ame_api2.updateApprovalStatus');
1195: END IF;
1196: ame_api2.updateApprovalStatus(

Line 1202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1198: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
1199: approverIn => l_approver_record2,
1200: transactionTypeIn => G_TRANSACTION_TYPE);
1201:
1202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1204: g_module || l_api_name,
1205: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');
1206: END IF;

Line 1203: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1199: approverIn => l_approver_record2,
1200: transactionTypeIn => G_TRANSACTION_TYPE);
1201:
1202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1204: g_module || l_api_name,
1205: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');
1206: END IF;
1207: resultout := 'COMPLETE:';

Line 1214: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1210: END IF; -- (funcmode = 'TIMEOUT')
1211:
1212: exception
1213: when others then
1214: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1216: g_module || l_api_name,
1217: '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);
1218: END IF;

Line 1215: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1211:
1212: exception
1213: when others then
1214: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1216: g_module || l_api_name,
1217: '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);
1218: END IF;
1219: --close cursors

Line 1305: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1301: BEGIN
1302:
1303: l_api_name := 'update_ame_status';
1304:
1305: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1307: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1309: 'Item Type is: ' || itemtype);

Line 1306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1302:
1303: l_api_name := 'update_ame_status';
1304:
1305: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1307: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1309: 'Item Type is: ' || itemtype);
1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1304:
1305: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1307: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1309: 'Item Type is: ' || itemtype);
1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1311: 'Item Key is: ' || itemkey);
1312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1307: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1309: 'Item Type is: ' || itemtype);
1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1311: 'Item Key is: ' || itemkey);
1312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1313: 'actid is: ' || to_char(actid));
1314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1309: 'Item Type is: ' || itemtype);
1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1311: 'Item Key is: ' || itemkey);
1312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1313: 'actid is: ' || to_char(actid));
1314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1315: 'Function mode is: ' || funcmode);
1316: END IF;

Line 1314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1311: 'Item Key is: ' || itemkey);
1312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1313: 'actid is: ' || to_char(actid));
1314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1315: 'Function mode is: ' || funcmode);
1316: END IF;
1317: -- Get contract id and version attributes
1318: l_contract_id := wf_engine.GetItemAttrNumber(

Line 1346: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1342: l_group_id := WF_NOTIFICATION.GetAttrText(
1343: nid => WF_ENGINE.context_nid,
1344: aname => 'APPROVER_GROUP_ID');
1345:
1346: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1347: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1348: g_module || l_api_name,
1349: 'Contract Id is: ' || to_char(l_contract_id));
1350: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1347: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1343: nid => WF_ENGINE.context_nid,
1344: aname => 'APPROVER_GROUP_ID');
1345:
1346: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1347: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1348: g_module || l_api_name,
1349: 'Contract Id is: ' || to_char(l_contract_id));
1350: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1351: g_module || l_api_name,

Line 1350: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1346: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1347: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1348: g_module || l_api_name,
1349: 'Contract Id is: ' || to_char(l_contract_id));
1350: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1351: g_module || l_api_name,
1352: 'Contract Version is: ' || to_char(l_contract_version));
1353: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1354: g_module || l_api_name,

Line 1353: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1349: 'Contract Id is: ' || to_char(l_contract_id));
1350: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1351: g_module || l_api_name,
1352: 'Contract Version is: ' || to_char(l_contract_version));
1353: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1354: g_module || l_api_name,
1355: 'Approver Notes : ' || l_wf_note);
1356: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1357: g_module || l_api_name,

Line 1356: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1352: 'Contract Version is: ' || to_char(l_contract_version));
1353: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1354: g_module || l_api_name,
1355: 'Approver Notes : ' || l_wf_note);
1356: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1357: g_module || l_api_name,
1358: 'Approver action is : ' || l_approval_status);
1359: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1360: g_module || l_api_name,

Line 1359: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1355: 'Approver Notes : ' || l_wf_note);
1356: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1357: g_module || l_api_name,
1358: 'Approver action is : ' || l_approval_status);
1359: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1360: g_module || l_api_name,
1361: 'Approver type is : ' || l_approver_type);
1362: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1363: g_module || l_api_name,

Line 1362: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1358: 'Approver action is : ' || l_approval_status);
1359: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1360: g_module || l_api_name,
1361: 'Approver type is : ' || l_approver_type);
1362: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1363: g_module || l_api_name,
1364: 'Approver pos name is : ' || l_approver_name);
1365: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1366: g_module || l_api_name,

Line 1365: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1361: 'Approver type is : ' || l_approver_type);
1362: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1363: g_module || l_api_name,
1364: 'Approver pos name is : ' || l_approver_name);
1365: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1366: g_module || l_api_name,
1367: 'Approver group Id is : ' || l_group_id);
1368:
1369: END IF;

Line 1376: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1372: FETCH notif_csr into notif_rec;
1373: IF(notif_csr%NOTFOUND) THEN
1374: RAISE NO_DATA_FOUND;
1375: END IF;
1376: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1378: g_module || l_api_name,
1379: 'Approver Name is : ' || notif_rec.user_name);
1380: END IF;

Line 1377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1373: IF(notif_csr%NOTFOUND) THEN
1374: RAISE NO_DATA_FOUND;
1375: END IF;
1376: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1378: g_module || l_api_name,
1379: 'Approver Name is : ' || notif_rec.user_name);
1380: END IF;
1381: -- l_approver_record2.name := notif_rec.user_name;

Line 1399: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1395: -- FUNCTION MODE IS RESPOND.
1396: IF (funcmode = 'RESPOND') THEN
1397: -- CURRENT APPROVER APPROVED THE CONTRACTS
1398: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
1399: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1401: g_module || l_api_name,
1402: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1403: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1400: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1396: IF (funcmode = 'RESPOND') THEN
1397: -- CURRENT APPROVER APPROVED THE CONTRACTS
1398: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
1399: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1401: g_module || l_api_name,
1402: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1403: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1404: g_module || l_api_name,

Line 1403: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1399: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1401: g_module || l_api_name,
1402: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1403: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1404: g_module || l_api_name,
1405: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1406: END IF;
1407: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1414: p_note => l_wf_note,
1415: x_msg_data => l_msg_data,
1416: x_msg_count => l_msg_count,
1417: x_return_status => l_return_status);
1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1420: g_module || l_api_name,
1421: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1422: END IF;

Line 1419: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1415: x_msg_data => l_msg_data,
1416: x_msg_count => l_msg_count,
1417: x_return_status => l_return_status);
1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1420: g_module || l_api_name,
1421: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1422: END IF;
1423: -------------------------------------------------------

Line 1431: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429: --------------------------------------------------------
1430: l_approver_record2.approval_status := ame_util.approvedStatus;
1431: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1433: g_module || l_api_name,
1434: 'Calling ame_api6.updateApprovalStatus');
1435: END IF;

Line 1432: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1428: END IF;
1429: --------------------------------------------------------
1430: l_approver_record2.approval_status := ame_util.approvedStatus;
1431: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1433: g_module || l_api_name,
1434: 'Calling ame_api6.updateApprovalStatus');
1435: END IF;
1436: ame_api6.updateApprovalStatus(

Line 1447: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1443:
1444: -- CURRENT APPROVER APPROVED THE CONTRACTS
1445: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
1446: -- Add a record in ONC_REP_CON_APPROVALS table.
1447: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1448: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1449: g_module || l_api_name,
1450: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1451: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1448: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1444: -- CURRENT APPROVER APPROVED THE CONTRACTS
1445: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
1446: -- Add a record in ONC_REP_CON_APPROVALS table.
1447: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1448: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1449: g_module || l_api_name,
1450: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1451: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1452: g_module || l_api_name,

Line 1451: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1447: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1448: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1449: g_module || l_api_name,
1450: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1451: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1452: g_module || l_api_name,
1453: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1454: END IF;
1455: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 1466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1462: p_note => l_wf_note,
1463: x_msg_data => l_msg_data,
1464: x_msg_count => l_msg_count,
1465: x_return_status => l_return_status);
1466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1467: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1468: g_module || l_api_name,
1469: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1470: END IF;

Line 1467: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1463: x_msg_data => l_msg_data,
1464: x_msg_count => l_msg_count,
1465: x_return_status => l_return_status);
1466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1467: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1468: g_module || l_api_name,
1469: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1470: END IF;
1471: -------------------------------------------------------

Line 1481: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1477: --------------------------------------------------------
1478:
1479: l_approver_record2.approval_status := ame_util.rejectStatus;
1480: -- Update AME approval status
1481: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1483: g_module || l_api_name,
1484: 'Calling ame_api6.updateApprovalStatus');
1485: END IF;

Line 1482: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1478:
1479: l_approver_record2.approval_status := ame_util.rejectStatus;
1480: -- Update AME approval status
1481: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1483: g_module || l_api_name,
1484: 'Calling ame_api6.updateApprovalStatus');
1485: END IF;
1486: ame_api6.updateApprovalStatus(

Line 1495: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1491: notificationIn => l_notification_record);
1492:
1493: ELSIF (l_approval_status = G_WF_APPROVE_FORWARD ) THEN
1494:
1495: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1496: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1497: g_module || l_api_name,
1498: 'Approver action is : ' || G_WF_APPROVE_FORWARD);
1499: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1496: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1492:
1493: ELSIF (l_approval_status = G_WF_APPROVE_FORWARD ) THEN
1494:
1495: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1496: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1497: g_module || l_api_name,
1498: 'Approver action is : ' || G_WF_APPROVE_FORWARD);
1499: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1500: g_module || l_api_name,

Line 1499: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1495: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1496: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1497: g_module || l_api_name,
1498: 'Approver action is : ' || G_WF_APPROVE_FORWARD);
1499: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1500: g_module || l_api_name,
1501: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1502: END IF;
1503:

Line 1524: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1520: p_note => l_wf_note,
1521: x_msg_data => l_msg_data,
1522: x_msg_count => l_msg_count,
1523: x_return_status => l_return_status);
1524: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1526: g_module || l_api_name,
1527: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1528: END IF;

Line 1525: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1521: x_msg_data => l_msg_data,
1522: x_msg_count => l_msg_count,
1523: x_return_status => l_return_status);
1524: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1526: g_module || l_api_name,
1527: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1528: END IF;
1529: -------------------------------------------------------

Line 1549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1545:
1546: l_approver_record2.approval_status := ame_util.approveAndForwardStatus;
1547:
1548:
1549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1551: 'Approver action is : ' || l_action_code);
1552: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1553: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

Line 1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

1546: l_approver_record2.approval_status := ame_util.approveAndForwardStatus;
1547:
1548:
1549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1551: 'Approver action is : ' || l_action_code);
1552: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1553: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1554: END IF;

Line 1552: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

1548:
1549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1551: 'Approver action is : ' || l_action_code);
1552: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1553: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1554: END IF;
1555: l_action_code:= G_WF_APPROVE_FORWARD;
1556: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 1568: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1564: x_msg_data => l_msg_data,
1565: x_msg_count => l_msg_count,
1566: x_return_status => l_return_status,
1567: p_forward_user_id => l_recipient_id);
1568: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1569: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1570: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1571: END IF;
1572:

Line 1569: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

1565: x_msg_count => l_msg_count,
1566: x_return_status => l_return_status,
1567: p_forward_user_id => l_recipient_id);
1568: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1569: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1570: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1571: END IF;
1572:
1573: -------------------------------------------------------

Line 1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1579: --------------------------------------------------------
1580:
1581: -- l_approver_record2.approval_status := ame_util.forwardStatus;
1582: -- Update AME approval status
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1585: g_module || l_api_name,
1586: 'Calling ame_api6.updateApprovalStatus');
1587: END IF;

Line 1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1580:
1581: -- l_approver_record2.approval_status := ame_util.forwardStatus;
1582: -- Update AME approval status
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1584: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1585: g_module || l_api_name,
1586: 'Calling ame_api6.updateApprovalStatus');
1587: END IF;
1588:

Line 1601: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1597:
1598:
1599: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
1600: CLOSE notif_csr;
1601: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1603: g_module || l_api_name,
1604: 'resultout value is: ' || resultout);
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 1602: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1598:
1599: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
1600: CLOSE notif_csr;
1601: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1603: g_module || l_api_name,
1604: 'resultout value is: ' || resultout);
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1606: g_module || l_api_name,

Line 1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1601: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1603: g_module || l_api_name,
1604: 'resultout value is: ' || resultout);
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1606: g_module || l_api_name,
1607: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RESPOND');
1608: END IF;
1609: END IF; -- (funcmode = 'RESPOND')

Line 1621: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1617: ELSIF (l_approval_status = G_WF_STATUS_MORE_APPROVERS) THEN
1618: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
1619: ELSE resultout := 'COMPLETE:';
1620: END IF;
1621: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1622: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1623: g_module || l_api_name,
1624: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');
1625: END IF;

Line 1622: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1618: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
1619: ELSE resultout := 'COMPLETE:';
1620: END IF;
1621: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1622: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1623: g_module || l_api_name,
1624: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');
1625: END IF;
1626: CLOSE notif_csr;

Line 1631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1627: RETURN;
1628: END IF; -- (funcmode = 'RUN')
1629:
1630: IF (funcmode = 'TIMEOUT') THEN
1631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1633: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1634: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

Line 1632: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,

1628: END IF; -- (funcmode = 'RUN')
1629:
1630: IF (funcmode = 'TIMEOUT') THEN
1631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1633: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1634: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1636: END IF;

Line 1634: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,

1630: IF (funcmode = 'TIMEOUT') THEN
1631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1633: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1634: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1636: END IF;
1637: OKC_REP_UTIL_PVT.add_approval_hist_record(
1638: p_api_version => 1.0,

Line 1648: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1644: p_note => l_wf_note,
1645: x_msg_data => l_msg_data,
1646: x_msg_count => l_msg_count,
1647: x_return_status => l_return_status);
1648: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1649: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1650: g_module || l_api_name,
1651: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1652: END IF;

Line 1649: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1645: x_msg_data => l_msg_data,
1646: x_msg_count => l_msg_count,
1647: x_return_status => l_return_status);
1648: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1649: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1650: g_module || l_api_name,
1651: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1652: END IF;
1653: -------------------------------------------------------

Line 1662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1658: END IF;
1659: --------------------------------------------------------
1660: l_approver_record2.approval_status := ame_util.noResponseStatus;
1661:
1662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1664: g_module || l_api_name,
1665: 'Calling ame_api6.updateApprovalStatus');
1666: END IF;

Line 1663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1659: --------------------------------------------------------
1660: l_approver_record2.approval_status := ame_util.noResponseStatus;
1661:
1662: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1663: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1664: g_module || l_api_name,
1665: 'Calling ame_api6.updateApprovalStatus');
1666: END IF;
1667: ame_api6.updateApprovalStatus(

Line 1674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1670: approverIn => l_approver_record2,
1671: transactionTypeIn => G_TRANSACTION_TYPE,
1672: notificationIn => l_notification_record);
1673:
1674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1675: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1676: g_module || l_api_name,
1677: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');
1678: END IF;

Line 1675: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1671: transactionTypeIn => G_TRANSACTION_TYPE,
1672: notificationIn => l_notification_record);
1673:
1674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1675: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1676: g_module || l_api_name,
1677: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');
1678: END IF;
1679: resultout := 'COMPLETE:';

Line 1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1696: l_action_code := G_WF_STATUS_TRANSFERRED;
1697: l_approver_record2.approval_status := ame_util.forwardStatus;
1698: END IF;
1699:
1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1701: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1702: 'Approver action is : ' || l_action_code);
1703: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1704: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

Line 1701: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

1697: l_approver_record2.approval_status := ame_util.forwardStatus;
1698: END IF;
1699:
1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1701: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1702: 'Approver action is : ' || l_action_code);
1703: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1704: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1705: END IF;

Line 1703: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

1699:
1700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1701: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1702: 'Approver action is : ' || l_action_code);
1703: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1704: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1705: END IF;
1706: OKC_REP_UTIL_PVT.add_approval_hist_record(
1707: p_api_version => 1.0,

Line 1718: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1714: x_msg_data => l_msg_data,
1715: x_msg_count => l_msg_count,
1716: x_return_status => l_return_status,
1717: p_forward_user_id => l_recipient_id);
1718: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1719: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1720: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1721: END IF;
1722:

Line 1719: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

1715: x_msg_count => l_msg_count,
1716: x_return_status => l_return_status,
1717: p_forward_user_id => l_recipient_id);
1718: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1719: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1720: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1721: END IF;
1722:
1723: -------------------------------------------------------

Line 1733: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1729: --------------------------------------------------------
1730:
1731: -- l_approver_record2.approval_status := ame_util.forwardStatus;
1732: -- Update AME approval status
1733: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1734: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1735: g_module || l_api_name,
1736: 'Calling ame_api6.updateApprovalStatus');
1737: END IF;

Line 1734: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1730:
1731: -- l_approver_record2.approval_status := ame_util.forwardStatus;
1732: -- Update AME approval status
1733: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1734: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1735: g_module || l_api_name,
1736: 'Calling ame_api6.updateApprovalStatus');
1737: END IF;
1738: ame_api6.updateApprovalStatus(

Line 1753: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1749: END IF; --(funcmode = 'FORWARD')
1750:
1751: exception
1752: when others then
1753: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1754: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1755: g_module || l_api_name,
1756: '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);
1757: END IF;

Line 1754: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1750:
1751: exception
1752: when others then
1753: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1754: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1755: g_module || l_api_name,
1756: '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);
1757: END IF;
1758: --close cursors

Line 1839: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1835: BEGIN
1836:
1837: l_api_name := 'approve_contract';
1838:
1839: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1841: 'Entered OKC_REP_WF_PVT.approve_contract');
1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1843: 'Item Type is: ' || itemtype);

Line 1840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1836:
1837: l_api_name := 'approve_contract';
1838:
1839: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1841: 'Entered OKC_REP_WF_PVT.approve_contract');
1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1843: 'Item Type is: ' || itemtype);
1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1838:
1839: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1841: 'Entered OKC_REP_WF_PVT.approve_contract');
1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1843: 'Item Type is: ' || itemtype);
1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1845: 'Item Key is: ' || itemkey);
1846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1841: 'Entered OKC_REP_WF_PVT.approve_contract');
1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1843: 'Item Type is: ' || itemtype);
1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1845: 'Item Key is: ' || itemkey);
1846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1847: 'actid is: ' || to_char(actid));
1848: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1843: 'Item Type is: ' || itemtype);
1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1845: 'Item Key is: ' || itemkey);
1846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1847: 'actid is: ' || to_char(actid));
1848: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1849: 'Function mode is: ' || funcmode);
1850: END IF;

Line 1848: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1845: 'Item Key is: ' || itemkey);
1846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1847: 'actid is: ' || to_char(actid));
1848: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1849: 'Function mode is: ' || funcmode);
1850: END IF;
1851: IF (funcmode = 'RUN') THEN
1852: l_contract_id := wf_engine.GetItemAttrNumber(

Line 1860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1856: l_contract_version := wf_engine.GetItemAttrNumber(
1857: itemtype => itemtype,
1858: itemkey => itemkey,
1859: aname => 'CONTRACT_VERSION');
1860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1861: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1862: g_module || l_api_name,
1863: 'Contract Id is: ' || to_char(l_contract_id));
1864: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1861: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1857: itemtype => itemtype,
1858: itemkey => itemkey,
1859: aname => 'CONTRACT_VERSION');
1860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1861: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1862: g_module || l_api_name,
1863: 'Contract Id is: ' || to_char(l_contract_id));
1864: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1865: g_module || l_api_name,

Line 1864: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1861: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1862: g_module || l_api_name,
1863: 'Contract Id is: ' || to_char(l_contract_id));
1864: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1865: g_module || l_api_name,
1866: 'Contract Version is: ' || to_char(l_contract_version));
1867: END IF;
1868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1864: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1865: g_module || l_api_name,
1866: 'Contract Version is: ' || to_char(l_contract_version));
1867: END IF;
1868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1869: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1870: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
1871: END IF;
1872: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.

Line 1869: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1865: g_module || l_api_name,
1866: 'Contract Version is: ' || to_char(l_contract_version));
1867: END IF;
1868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1869: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1870: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
1871: END IF;
1872: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
1873: OKC_REP_UTIL_PVT.change_contract_status(

Line 1884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1880: p_note => NULL,
1881: x_msg_data => l_msg_data,
1882: x_msg_count => l_msg_count,
1883: x_return_status => l_return_status);
1884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1885: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1886: g_module || l_api_name,
1887: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1888: END IF;

Line 1885: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1881: x_msg_data => l_msg_data,
1882: x_msg_count => l_msg_count,
1883: x_return_status => l_return_status);
1884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1885: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1886: g_module || l_api_name,
1887: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1888: END IF;
1889:

Line 1906: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1902:
1903: IF Nvl(contract_rec.ESignature_Required,'M') = 'N' THEN
1904:
1905: -- We need to first version the deliverables
1906: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1907: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1908: 'Calling OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');
1909: END IF;
1910: OKC_DELIVERABLE_PROCESS_PVT.version_deliverables (

Line 1907: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1903: IF Nvl(contract_rec.ESignature_Required,'M') = 'N' THEN
1904:
1905: -- We need to first version the deliverables
1906: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1907: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1908: 'Calling OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');
1909: END IF;
1910: OKC_DELIVERABLE_PROCESS_PVT.version_deliverables (
1911: p_api_version => 1.0,

Line 1920: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1916: x_return_status => l_return_status,
1917: x_msg_count => l_msg_count,
1918: x_msg_data => l_msg_data
1919: );
1920: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1922: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
1923: || l_return_status);
1924: END IF;

Line 1921: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1917: x_msg_count => l_msg_count,
1918: x_msg_data => l_msg_data
1919: );
1920: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1922: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
1923: || l_return_status);
1924: END IF;
1925: -----------------------------------------------------

Line 1933: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: --------------------------------------------------------
1932:
1933: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1935: 'Latest signed version number is : '
1936: || contract_rec.latest_signed_ver_number);
1937: END IF;

Line 1934: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1930: END IF;
1931: --------------------------------------------------------
1932:
1933: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1935: 'Latest signed version number is : '
1936: || contract_rec.latest_signed_ver_number);
1937: END IF;
1938: -- Now we need to activate deliverables

Line 1945: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1941: ELSE
1942: l_sync_flag := FND_API.G_TRUE;
1943: END IF;
1944:
1945: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1947: 'l_sync_flag is : ' || l_sync_flag);
1948: END IF;
1949: l_activate_event_tbl(1).event_code := G_CONTRACT_EXPIRE_EVENT;

Line 1946: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1942: l_sync_flag := FND_API.G_TRUE;
1943: END IF;
1944:
1945: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1947: 'l_sync_flag is : ' || l_sync_flag);
1948: END IF;
1949: l_activate_event_tbl(1).event_code := G_CONTRACT_EXPIRE_EVENT;
1950: l_activate_event_tbl(1).event_date := contract_rec.contract_expiration_date;

Line 1952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1948: END IF;
1949: l_activate_event_tbl(1).event_code := G_CONTRACT_EXPIRE_EVENT;
1950: l_activate_event_tbl(1).event_date := contract_rec.contract_expiration_date;
1951:
1952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1954: 'Calling OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
1955: END IF;
1956:

Line 1953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1949: l_activate_event_tbl(1).event_code := G_CONTRACT_EXPIRE_EVENT;
1950: l_activate_event_tbl(1).event_date := contract_rec.contract_expiration_date;
1951:
1952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1954: 'Calling OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
1955: END IF;
1956:
1957: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (

Line 1972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1968: x_msg_data => l_msg_data,
1969: x_msg_count => l_msg_count,
1970: x_return_status => l_return_status);
1971:
1972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1973: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1974: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
1975: || l_return_status);
1976: END IF;

Line 1973: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1969: x_msg_count => l_msg_count,
1970: x_return_status => l_return_status);
1971:
1972: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1973: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1974: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
1975: || l_return_status);
1976: END IF;
1977: -----------------------------------------------------

Line 1992: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1988: -- Get effective dates and version of the contract.
1989: OPEN arch_contract_csr(contract_rec.latest_signed_ver_number,l_contract_id);
1990: FETCH arch_contract_csr INTO arch_contract_rec;
1991: IF(contract_csr%NOTFOUND) THEN
1992: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1994: G_MODULE||l_api_name,
1995: 'Invalid Contract Id: '|| l_contract_id);
1996: END IF;

Line 1993: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

1989: OPEN arch_contract_csr(contract_rec.latest_signed_ver_number,l_contract_id);
1990: FETCH arch_contract_csr INTO arch_contract_rec;
1991: IF(contract_csr%NOTFOUND) THEN
1992: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1994: G_MODULE||l_api_name,
1995: 'Invalid Contract Id: '|| l_contract_id);
1996: END IF;
1997: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2008: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2004: l_prev_signed_effective_date := arch_contract_rec.contract_effective_date;
2005: l_prev_signed_expiration_date := arch_contract_rec.contract_expiration_date;
2006:
2007: CLOSE arch_contract_csr;
2008: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2009: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2010: 'Before checking if we need to call updateDeliverable and disableDeliverable()');
2011: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2012: 'Prev signed expiration date: ' || trunc(l_prev_signed_expiration_date));

Line 2009: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2005: l_prev_signed_expiration_date := arch_contract_rec.contract_expiration_date;
2006:
2007: CLOSE arch_contract_csr;
2008: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2009: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2010: 'Before checking if we need to call updateDeliverable and disableDeliverable()');
2011: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2012: 'Prev signed expiration date: ' || trunc(l_prev_signed_expiration_date));
2013: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2011: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2007: CLOSE arch_contract_csr;
2008: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2009: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2010: 'Before checking if we need to call updateDeliverable and disableDeliverable()');
2011: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2012: 'Prev signed expiration date: ' || trunc(l_prev_signed_expiration_date));
2013: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2014: 'Current version expiration date: ' || trunc(contract_rec.contract_expiration_date));
2015: END IF;

Line 2013: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2009: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2010: 'Before checking if we need to call updateDeliverable and disableDeliverable()');
2011: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2012: 'Prev signed expiration date: ' || trunc(l_prev_signed_expiration_date));
2013: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2014: 'Current version expiration date: ' || trunc(contract_rec.contract_expiration_date));
2015: END IF;
2016: l_update_event_tbl(1).event_code := G_CONTRACT_EFFECTIVE_EVENT;
2017: l_update_event_tbl(1).event_date := contract_rec.contract_effective_date;

Line 2032: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2028: l_effective_date_matches_flag := FND_API.G_TRUE;
2029: END IF;
2030:
2031: IF ((l_expiration_date_matches_flag = FND_API.G_FALSE ) OR (l_effective_date_matches_flag = FND_API.G_FALSE)) THEN
2032: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2034: 'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
2035: END IF;
2036: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (

Line 2033: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2029: END IF;
2030:
2031: IF ((l_expiration_date_matches_flag = FND_API.G_FALSE ) OR (l_effective_date_matches_flag = FND_API.G_FALSE)) THEN
2032: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2034: 'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
2035: END IF;
2036: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
2037: p_api_version => 1.0,

Line 2048: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2044: x_msg_data => l_msg_data,
2045: x_msg_count => l_msg_count,
2046: x_return_status => l_return_status);
2047:
2048: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2049: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2050: 'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
2051: || l_return_status);
2052: END IF;

Line 2049: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2045: x_msg_count => l_msg_count,
2046: x_return_status => l_return_status);
2047:
2048: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2049: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2050: 'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
2051: || l_return_status);
2052: END IF;
2053: -----------------------------------------------------

Line 2062: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2058: END IF;
2059: --------------------------------------------------------
2060: END IF; -- expiration date comparision
2061: -- Disable prev. version deliverables
2062: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2063: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2064: 'Calling OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables');
2065: END IF;
2066: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (

Line 2063: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2059: --------------------------------------------------------
2060: END IF; -- expiration date comparision
2061: -- Disable prev. version deliverables
2062: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2063: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2064: 'Calling OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables');
2065: END IF;
2066: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
2067: p_api_version => 1.0,

Line 2077: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2073: x_msg_data => l_msg_data,
2074: x_msg_count => l_msg_count,
2075: x_return_status => l_return_status);
2076:
2077: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2078: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2079: 'OKC_DELIVERABLE_PROCESS_PVT.disableDeliverables return status is : '
2080: || l_return_status);
2081: END IF;

Line 2078: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2074: x_msg_count => l_msg_count,
2075: x_return_status => l_return_status);
2076:
2077: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2078: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2079: 'OKC_DELIVERABLE_PROCESS_PVT.disableDeliverables return status is : '
2080: || l_return_status);
2081: END IF;
2082: -----------------------------------------------------

Line 2090: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: --------------------------------------------------------
2089: END IF; -- (l_sync_flag = 'Y')
2090: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2091: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2092: 'Updating latest_signed_ver_number column');
2093: END IF;
2094: UPDATE okc_rep_contracts_all

Line 2091: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2087: END IF;
2088: --------------------------------------------------------
2089: END IF; -- (l_sync_flag = 'Y')
2090: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2091: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2092: 'Updating latest_signed_ver_number column');
2093: END IF;
2094: UPDATE okc_rep_contracts_all
2095: SET latest_signed_ver_number = contract_rec.contract_version_num

Line 2102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2098:
2099: END IF; --contract_rec.ESignature_Required='N'
2100:
2101: resultout := 'COMPLETE:';
2102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2104: g_module || l_api_name,
2105: 'Leaving OKC_REP_WF_PVT.approve_contract');
2106: END IF;

Line 2103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2099: END IF; --contract_rec.ESignature_Required='N'
2100:
2101: resultout := 'COMPLETE:';
2102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2104: g_module || l_api_name,
2105: 'Leaving OKC_REP_WF_PVT.approve_contract');
2106: END IF;
2107: RETURN;

Line 2112: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2108: END IF; -- (funcmode = 'RUN')
2109:
2110: EXCEPTION
2111: WHEN others THEN
2112: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2113: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2114: g_module || l_api_name,
2115: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
2116: END IF;

Line 2113: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2109:
2110: EXCEPTION
2111: WHEN others THEN
2112: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2113: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2114: g_module || l_api_name,
2115: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
2116: END IF;
2117: wf_core.context('OKC_REP_WF_PVT',

Line 2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2162: BEGIN
2163:
2164: l_api_name := 'reject_contract';
2165:
2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2168: 'Entered OKC_REP_WF_PVT.reject_contract');
2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2170: 'Item Type is: ' || itemtype);

Line 2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2163:
2164: l_api_name := 'reject_contract';
2165:
2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2168: 'Entered OKC_REP_WF_PVT.reject_contract');
2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2170: 'Item Type is: ' || itemtype);
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2165:
2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2168: 'Entered OKC_REP_WF_PVT.reject_contract');
2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2170: 'Item Type is: ' || itemtype);
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2172: 'Item Key is: ' || itemkey);
2173: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2168: 'Entered OKC_REP_WF_PVT.reject_contract');
2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2170: 'Item Type is: ' || itemtype);
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2172: 'Item Key is: ' || itemkey);
2173: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2174: 'actid is: ' || to_char(actid));
2175: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2173: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2170: 'Item Type is: ' || itemtype);
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2172: 'Item Key is: ' || itemkey);
2173: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2174: 'actid is: ' || to_char(actid));
2175: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2176: 'Function mode is: ' || funcmode);
2177: END IF;

Line 2175: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2172: 'Item Key is: ' || itemkey);
2173: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2174: 'actid is: ' || to_char(actid));
2175: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2176: 'Function mode is: ' || funcmode);
2177: END IF;
2178: if (funcmode = 'RUN') then
2179: l_contract_id := wf_engine.GetItemAttrNumber(

Line 2187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2183: l_contract_version := wf_engine.GetItemAttrNumber(
2184: itemtype => itemtype,
2185: itemkey => itemkey,
2186: aname => 'CONTRACT_VERSION');
2187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2189: g_module || l_api_name,
2190: 'Contract Id is: ' || to_char(l_contract_id));
2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2184: itemtype => itemtype,
2185: itemkey => itemkey,
2186: aname => 'CONTRACT_VERSION');
2187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2189: g_module || l_api_name,
2190: 'Contract Id is: ' || to_char(l_contract_id));
2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2192: g_module || l_api_name,

Line 2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2189: g_module || l_api_name,
2190: 'Contract Id is: ' || to_char(l_contract_id));
2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2192: g_module || l_api_name,
2193: 'Contract Version is: ' || to_char(l_contract_version));
2194: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2195: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

Line 2194: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2190: 'Contract Id is: ' || to_char(l_contract_id));
2191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2192: g_module || l_api_name,
2193: 'Contract Version is: ' || to_char(l_contract_version));
2194: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2195: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
2196: END IF;
2197:
2198: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.

Line 2210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2206: p_note => NULL,
2207: x_msg_data => l_msg_data,
2208: x_msg_count => l_msg_count,
2209: x_return_status => l_return_status);
2210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2211: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2212: g_module || l_api_name,
2213: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
2214: END IF;

Line 2211: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2207: x_msg_data => l_msg_data,
2208: x_msg_count => l_msg_count,
2209: x_return_status => l_return_status);
2210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2211: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2212: g_module || l_api_name,
2213: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
2214: END IF;
2215: -----------------------------------------------------

Line 2224: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2220: END IF;
2221: --------------------------------------------------------
2222:
2223: resultout := 'COMPLETE:';
2224: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2225: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2226: g_module || l_api_name,
2227: 'Leaving OKC_REP_WF_PVT.reject_contract');
2228: END IF;

Line 2225: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2221: --------------------------------------------------------
2222:
2223: resultout := 'COMPLETE:';
2224: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2225: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2226: g_module || l_api_name,
2227: 'Leaving OKC_REP_WF_PVT.reject_contract');
2228: END IF;
2229: RETURN;

Line 2233: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2229: RETURN;
2230: END IF; -- (funcmode = 'RUN')
2231: EXCEPTION
2232: WHEN others THEN
2233: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2234: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2235: g_module || l_api_name,
2236: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
2237: END IF;

Line 2234: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2230: END IF; -- (funcmode = 'RUN')
2231: EXCEPTION
2232: WHEN others THEN
2233: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2234: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2235: g_module || l_api_name,
2236: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
2237: END IF;
2238: wf_core.context('OKC_REP_WF_PVT',

Line 2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2284: BEGIN
2285:
2286: l_api_name := 'is_contract_approved';
2287:
2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2290: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2292: 'Item Type is: ' || itemtype);

Line 2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2285:
2286: l_api_name := 'is_contract_approved';
2287:
2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2290: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2292: 'Item Type is: ' || itemtype);
2293: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2287:
2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2290: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2292: 'Item Type is: ' || itemtype);
2293: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2294: 'Item Key is: ' || itemkey);
2295: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2293: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2290: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2292: 'Item Type is: ' || itemtype);
2293: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2294: 'Item Key is: ' || itemkey);
2295: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2296: 'actid is: ' || to_char(actid));
2297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2295: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2292: 'Item Type is: ' || itemtype);
2293: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2294: 'Item Key is: ' || itemkey);
2295: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2296: 'actid is: ' || to_char(actid));
2297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2298: 'Function mode is: ' || funcmode);
2299: END IF;

Line 2297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2293: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2294: 'Item Key is: ' || itemkey);
2295: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2296: 'actid is: ' || to_char(actid));
2297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2298: 'Function mode is: ' || funcmode);
2299: END IF;
2300: IF (funcmode = 'RUN') then
2301: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2301: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2298: 'Function mode is: ' || funcmode);
2299: END IF;
2300: IF (funcmode = 'RUN') then
2301: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2302: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2303: g_module || l_api_name,
2304: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2305: END IF;

Line 2302: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2298: 'Function mode is: ' || funcmode);
2299: END IF;
2300: IF (funcmode = 'RUN') then
2301: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2302: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2303: g_module || l_api_name,
2304: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2305: END IF;
2306: l_contract_id := wf_engine.GetItemAttrNumber(

Line 2310: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2306: l_contract_id := wf_engine.GetItemAttrNumber(
2307: itemtype => itemtype,
2308: itemkey => itemkey,
2309: aname => 'CONTRACT_ID');
2310: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2311: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2312: g_module || l_api_name,
2313: 'Contract Id is: ' || to_char(l_contract_id));
2314: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 2311: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2307: itemtype => itemtype,
2308: itemkey => itemkey,
2309: aname => 'CONTRACT_ID');
2310: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2311: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2312: g_module || l_api_name,
2313: 'Contract Id is: ' || to_char(l_contract_id));
2314: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2315: g_module || l_api_name,

Line 2314: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2310: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2311: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2312: g_module || l_api_name,
2313: 'Contract Id is: ' || to_char(l_contract_id));
2314: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2315: g_module || l_api_name,
2316: 'Calling ame_api.getNextApprover to get the approver id');
2317: END IF;
2318: ame_api2.getNextApprovers1(

Line 2330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2326: itemClassesOut => l_item_classes,
2327: itemIdsOut => l_item_ids,
2328: itemSourcesOut => l_item_sources);
2329:
2330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2332: g_module || l_api_name,
2333: 'Number of approvers: ' || to_char(l_next_approvers.count));
2334: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 2331: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2327: itemIdsOut => l_item_ids,
2328: itemSourcesOut => l_item_sources);
2329:
2330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2332: g_module || l_api_name,
2333: 'Number of approvers: ' || to_char(l_next_approvers.count));
2334: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2335: g_module || l_api_name,

Line 2334: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2332: g_module || l_api_name,
2333: 'Number of approvers: ' || to_char(l_next_approvers.count));
2334: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2335: g_module || l_api_name,
2336: 'l_process_complete_yn is is_contract_approved: ' || l_process_complete_yn);
2337: END IF;
2338: IF (l_process_complete_yn = ame_util.booleanTrue) THEN

Line 2339: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2335: g_module || l_api_name,
2336: 'l_process_complete_yn is is_contract_approved: ' || l_process_complete_yn);
2337: END IF;
2338: IF (l_process_complete_yn = ame_util.booleanTrue) THEN
2339: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2340: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2341: 'The contract is approved');
2342: END IF;
2343: resultout := 'COMPLETE:T';

Line 2340: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

2336: 'l_process_complete_yn is is_contract_approved: ' || l_process_complete_yn);
2337: END IF;
2338: IF (l_process_complete_yn = ame_util.booleanTrue) THEN
2339: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2340: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2341: 'The contract is approved');
2342: END IF;
2343: resultout := 'COMPLETE:T';
2344: ELSE

Line 2345: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2341: 'The contract is approved');
2342: END IF;
2343: resultout := 'COMPLETE:T';
2344: ELSE
2345: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2346: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2347: 'The contract is rejected');
2348: END IF;
2349: resultout := 'COMPLETE:F';

Line 2346: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

2342: END IF;
2343: resultout := 'COMPLETE:T';
2344: ELSE
2345: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2346: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2347: 'The contract is rejected');
2348: END IF;
2349: resultout := 'COMPLETE:F';
2350: END IF;

Line 2351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2347: 'The contract is rejected');
2348: END IF;
2349: resultout := 'COMPLETE:F';
2350: END IF;
2351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2353: g_module || l_api_name,
2354: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=RUN');
2355: END IF;

Line 2352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2348: END IF;
2349: resultout := 'COMPLETE:F';
2350: END IF;
2351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2353: g_module || l_api_name,
2354: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=RUN');
2355: END IF;
2356: RETURN;

Line 2361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2357: END IF; -- (funcmode = 'RUN')
2358:
2359: IF (funcmode = 'CANCEL') THEN
2360: resultout := 'COMPLETE:';
2361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2363: g_module || l_api_name,
2364: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=CANCEL');
2365: END IF;

Line 2362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2358:
2359: IF (funcmode = 'CANCEL') THEN
2360: resultout := 'COMPLETE:';
2361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2363: g_module || l_api_name,
2364: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=CANCEL');
2365: END IF;
2366: RETURN;

Line 2371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2367: END IF; -- (funcmode = 'CANCEL')
2368:
2369: IF (funcmode = 'TIMEOUT') THEN
2370: resultout := 'COMPLETE:';
2371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2373: g_module || l_api_name,
2374: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=TIMEOUT');
2375: END IF;

Line 2372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2368:
2369: IF (funcmode = 'TIMEOUT') THEN
2370: resultout := 'COMPLETE:';
2371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2373: g_module || l_api_name,
2374: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=TIMEOUT');
2375: END IF;
2376: RETURN;

Line 2381: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2377: END IF; -- (funcmode = 'TIMEOUT')
2378:
2379: EXCEPTION
2380: WHEN others THEN
2381: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2382: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2383: g_module || l_api_name,
2384: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
2385: END IF;

Line 2382: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2378:
2379: EXCEPTION
2380: WHEN others THEN
2381: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2382: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2383: g_module || l_api_name,
2384: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
2385: END IF;
2386: wf_core.context('OKC_REP_WF_PVT',

Line 2446: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2442: BEGIN
2443:
2444: l_api_name := 'is_contract_approved_detailed';
2445:
2446: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2448: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2450: 'Item Type is: ' || itemtype);

Line 2447: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2443:
2444: l_api_name := 'is_contract_approved_detailed';
2445:
2446: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2448: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2450: 'Item Type is: ' || itemtype);
2451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2445:
2446: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2448: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2450: 'Item Type is: ' || itemtype);
2451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2452: 'Item Key is: ' || itemkey);
2453: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2447: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2448: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2450: 'Item Type is: ' || itemtype);
2451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2452: 'Item Key is: ' || itemkey);
2453: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2454: 'actid is: ' || to_char(actid));
2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2453: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2450: 'Item Type is: ' || itemtype);
2451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2452: 'Item Key is: ' || itemkey);
2453: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2454: 'actid is: ' || to_char(actid));
2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2456: 'Function mode is: ' || funcmode);
2457: END IF;

Line 2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2452: 'Item Key is: ' || itemkey);
2453: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2454: 'actid is: ' || to_char(actid));
2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2456: 'Function mode is: ' || funcmode);
2457: END IF;
2458: IF (funcmode = 'RUN') then
2459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2456: 'Function mode is: ' || funcmode);
2457: END IF;
2458: IF (funcmode = 'RUN') then
2459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2461: g_module || l_api_name,
2462: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2463: END IF;

Line 2460: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2456: 'Function mode is: ' || funcmode);
2457: END IF;
2458: IF (funcmode = 'RUN') then
2459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2461: g_module || l_api_name,
2462: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
2463: END IF;
2464: l_contract_id := wf_engine.GetItemAttrNumber(

Line 2468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2464: l_contract_id := wf_engine.GetItemAttrNumber(
2465: itemtype => itemtype,
2466: itemkey => itemkey,
2467: aname => 'CONTRACT_ID');
2468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2470: g_module || l_api_name,
2471: 'Contract Id is: ' || to_char(l_contract_id));
2472: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2465: itemtype => itemtype,
2466: itemkey => itemkey,
2467: aname => 'CONTRACT_ID');
2468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2470: g_module || l_api_name,
2471: 'Contract Id is: ' || to_char(l_contract_id));
2472: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2473: g_module || l_api_name,

Line 2472: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2469: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2470: g_module || l_api_name,
2471: 'Contract Id is: ' || to_char(l_contract_id));
2472: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2473: g_module || l_api_name,
2474: 'Calling ame_api.getNextApprover to get the approver id');
2475: END IF;
2476: -- Using this API to determine if process is complete. Complete process from AME implies

Line 2491: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2487: itemClassesOut => l_item_classes,
2488: itemIdsOut => l_item_ids,
2489: itemSourcesOut => l_item_sources);
2490:
2491: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2493: g_module || l_api_name,
2494: 'Number of approvers: ' || to_char(l_next_approvers.count));
2495: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 2492: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2488: itemIdsOut => l_item_ids,
2489: itemSourcesOut => l_item_sources);
2490:
2491: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2493: g_module || l_api_name,
2494: 'Number of approvers: ' || to_char(l_next_approvers.count));
2495: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2496: g_module || l_api_name,

Line 2495: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

2491: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2493: g_module || l_api_name,
2494: 'Number of approvers: ' || to_char(l_next_approvers.count));
2495: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
2496: g_module || l_api_name,
2497: 'l_process_complete_yn is is_contract_approved_detailed: ' || l_process_complete_yn);
2498: END IF;
2499: IF ((l_process_complete_yn = 'Y') OR

Line 2501: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2497: 'l_process_complete_yn is is_contract_approved_detailed: ' || l_process_complete_yn);
2498: END IF;
2499: IF ((l_process_complete_yn = 'Y') OR
2500: (l_process_complete_yn = 'X')) THEN
2501: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2502: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2503: 'The contract is approved');
2504: END IF;
2505: resultout := 'COMPLETE:T';

Line 2502: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

2498: END IF;
2499: IF ((l_process_complete_yn = 'Y') OR
2500: (l_process_complete_yn = 'X')) THEN
2501: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2502: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2503: 'The contract is approved');
2504: END IF;
2505: resultout := 'COMPLETE:T';
2506: ELSE

Line 2507: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2503: 'The contract is approved');
2504: END IF;
2505: resultout := 'COMPLETE:T';
2506: ELSE
2507: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2508: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2509: 'The contract is rejected');
2510: END IF;
2511: resultout := 'COMPLETE:F';

Line 2508: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,

2504: END IF;
2505: resultout := 'COMPLETE:T';
2506: ELSE
2507: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2508: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
2509: 'The contract is rejected');
2510: END IF;
2511: resultout := 'COMPLETE:F';
2512: END IF;

Line 2516: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2512: END IF;
2513: -- We need to loop through the pending notif. process and abort those
2514: FOR wf_process_rec IN wf_process_csr
2515: LOOP
2516: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2517: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2518: 'Calling WF_ENGINE.AbortProcess');
2519: END IF;
2520:

Line 2517: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,

2513: -- We need to loop through the pending notif. process and abort those
2514: FOR wf_process_rec IN wf_process_csr
2515: LOOP
2516: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2517: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2518: 'Calling WF_ENGINE.AbortProcess');
2519: END IF;
2520:
2521: WF_ENGINE.AbortProcess(

Line 2529: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2525: verify_lock => false,
2526: cascade => true);
2527: END LOOP;
2528:
2529: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2530: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2531: 'Calling ame_api2.clearAllApprovals');
2532: END IF;
2533:

Line 2530: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,

2526: cascade => true);
2527: END LOOP;
2528:
2529: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2530: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2531: 'Calling ame_api2.clearAllApprovals');
2532: END IF;
2533:
2534: -- Repository Contracts ER's - Calling this after approval

Line 2541: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2537: applicationIdIn => G_APPLICATION_ID,
2538: transactionTypeIn => G_TRANSACTION_TYPE,
2539: transactionIdIn => fnd_number.number_to_canonical(l_contract_id));
2540:
2541: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2542: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2543: 'After ame_api2.clearAllApprovals');
2544: END IF;
2545:

Line 2542: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,

2538: transactionTypeIn => G_TRANSACTION_TYPE,
2539: transactionIdIn => fnd_number.number_to_canonical(l_contract_id));
2540:
2541: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2542: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2543: 'After ame_api2.clearAllApprovals');
2544: END IF;
2545:
2546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2542: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
2543: 'After ame_api2.clearAllApprovals');
2544: END IF;
2545:
2546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2547: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2548: g_module || l_api_name,
2549: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=RUN');
2550: END IF;

Line 2547: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2543: 'After ame_api2.clearAllApprovals');
2544: END IF;
2545:
2546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2547: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2548: g_module || l_api_name,
2549: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=RUN');
2550: END IF;
2551: RETURN;

Line 2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2552: END IF; -- (funcmode = 'RUN')
2553:
2554: IF (funcmode = 'CANCEL') THEN
2555: resultout := 'COMPLETE:';
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2558: g_module || l_api_name,
2559: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=CANCEL');
2560: END IF;

Line 2557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2553:
2554: IF (funcmode = 'CANCEL') THEN
2555: resultout := 'COMPLETE:';
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2558: g_module || l_api_name,
2559: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=CANCEL');
2560: END IF;
2561: RETURN;

Line 2566: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2562: END IF; -- (funcmode = 'CANCEL')
2563:
2564: IF (funcmode = 'TIMEOUT') THEN
2565: resultout := 'COMPLETE:';
2566: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2568: g_module || l_api_name,
2569: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=TIMEOUT');
2570: END IF;

Line 2567: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2563:
2564: IF (funcmode = 'TIMEOUT') THEN
2565: resultout := 'COMPLETE:';
2566: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2568: g_module || l_api_name,
2569: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=TIMEOUT');
2570: END IF;
2571: RETURN;

Line 2576: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2572: END IF; -- (funcmode = 'TIMEOUT')
2573:
2574: EXCEPTION
2575: WHEN others THEN
2576: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2578: g_module || l_api_name,
2579: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
2580: END IF;

Line 2577: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2573:
2574: EXCEPTION
2575: WHEN others THEN
2576: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2578: g_module || l_api_name,
2579: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
2580: END IF;
2581: wf_core.context('OKC_REP_WF_PVT',

Line 2632: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2628: BEGIN
2629:
2630: l_api_name := 'complete_notification';
2631:
2632: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2633: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2634: 'Entered OKC_REP_WF_PVT.complete_notification');
2635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2636: 'Item Type is: ' || itemtype);

Line 2633: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2629:
2630: l_api_name := 'complete_notification';
2631:
2632: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2633: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2634: 'Entered OKC_REP_WF_PVT.complete_notification');
2635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2636: 'Item Type is: ' || itemtype);
2637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2631:
2632: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2633: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2634: 'Entered OKC_REP_WF_PVT.complete_notification');
2635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2636: 'Item Type is: ' || itemtype);
2637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2638: 'Item Key is: ' || itemkey);
2639: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2633: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2634: 'Entered OKC_REP_WF_PVT.complete_notification');
2635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2636: 'Item Type is: ' || itemtype);
2637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2638: 'Item Key is: ' || itemkey);
2639: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2640: 'actid is: ' || to_char(actid));
2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2639: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2636: 'Item Type is: ' || itemtype);
2637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2638: 'Item Key is: ' || itemkey);
2639: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2640: 'actid is: ' || to_char(actid));
2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2642: 'Function mode is: ' || funcmode);
2643: END IF;

Line 2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2638: 'Item Key is: ' || itemkey);
2639: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2640: 'actid is: ' || to_char(actid));
2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2642: 'Function mode is: ' || funcmode);
2643: END IF;
2644: if (funcmode = 'RUN') then
2645: l_master_key := wf_engine.GetItemAttrText(

Line 2649: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2645: l_master_key := wf_engine.GetItemAttrText(
2646: itemtype => itemtype,
2647: itemkey => itemkey,
2648: aname => 'MASTER_ITEM_KEY');
2649: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2651: g_module || l_api_name,
2652: 'Master Item Key is: ' || l_master_key);
2653: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2646: itemtype => itemtype,
2647: itemkey => itemkey,
2648: aname => 'MASTER_ITEM_KEY');
2649: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2651: g_module || l_api_name,
2652: 'Master Item Key is: ' || l_master_key);
2653: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2654: 'Completing master process waiting activity');

Line 2653: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2649: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2651: g_module || l_api_name,
2652: 'Master Item Key is: ' || l_master_key);
2653: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2654: 'Completing master process waiting activity');
2655: END IF;
2656: wf_engine.CompleteActivity(
2657: itemtype => itemtype,

Line 2663: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2659: activity => 'WAIT_FOR_APPROVER_RESPONSE',
2660: result => null);
2661:
2662: resultout := 'COMPLETE:';
2663: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2664: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2665: g_module || l_api_name,
2666: 'Leaving OKC_REP_WF_PVT.complete_notification');
2667: END IF;

Line 2664: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2660: result => null);
2661:
2662: resultout := 'COMPLETE:';
2663: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2664: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2665: g_module || l_api_name,
2666: 'Leaving OKC_REP_WF_PVT.complete_notification');
2667: END IF;
2668: RETURN;

Line 2672: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2668: RETURN;
2669: END IF; -- (funcmode = 'RUN')
2670: EXCEPTION
2671: WHEN others THEN
2672: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2674: g_module || l_api_name,
2675: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2676: END IF;

Line 2673: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2669: END IF; -- (funcmode = 'RUN')
2670: EXCEPTION
2671: WHEN others THEN
2672: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2674: g_module || l_api_name,
2675: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2676: END IF;
2677: wf_core.context('OKC_REP_WF_PVT',

Line 2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2724: BEGIN
2725:
2726: l_api_name := 'con_has_terms';
2727:
2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2730: 'Entered OKC_REP_WF_PVT.complete_notification');
2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2732: 'Item Type is: ' || itemtype);

Line 2729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2725:
2726: l_api_name := 'con_has_terms';
2727:
2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2730: 'Entered OKC_REP_WF_PVT.complete_notification');
2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2732: 'Item Type is: ' || itemtype);
2733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2727:
2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2730: 'Entered OKC_REP_WF_PVT.complete_notification');
2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2732: 'Item Type is: ' || itemtype);
2733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2734: 'Item Key is: ' || itemkey);
2735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2730: 'Entered OKC_REP_WF_PVT.complete_notification');
2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2732: 'Item Type is: ' || itemtype);
2733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2734: 'Item Key is: ' || itemkey);
2735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2736: 'actid is: ' || to_char(actid));
2737: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2732: 'Item Type is: ' || itemtype);
2733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2734: 'Item Key is: ' || itemkey);
2735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2736: 'actid is: ' || to_char(actid));
2737: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2738: 'Function mode is: ' || funcmode);
2739: END IF;

Line 2737: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2734: 'Item Key is: ' || itemkey);
2735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2736: 'actid is: ' || to_char(actid));
2737: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2738: 'Function mode is: ' || funcmode);
2739: END IF;
2740:
2741: IF (funcmode = 'RUN') THEN

Line 2763: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2759: END IF; -- RUN
2760:
2761: EXCEPTION
2762: WHEN others THEN
2763: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2765: g_module || l_api_name,
2766: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2767: END IF;

Line 2764: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2760:
2761: EXCEPTION
2762: WHEN others THEN
2763: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2765: g_module || l_api_name,
2766: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2767: END IF;
2768: wf_core.context('OKC_REP_WF_PVT',

Line 2826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2822: BEGIN
2823:
2824: l_api_name := 'con_attach_generated_yn';
2825:
2826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2828: 'Entered OKC_REP_WF_PVT.complete_notification');
2829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2830: 'Item Type is: ' || itemtype);

Line 2827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2823:
2824: l_api_name := 'con_attach_generated_yn';
2825:
2826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2828: 'Entered OKC_REP_WF_PVT.complete_notification');
2829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2830: 'Item Type is: ' || itemtype);
2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2825:
2826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2828: 'Entered OKC_REP_WF_PVT.complete_notification');
2829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2830: 'Item Type is: ' || itemtype);
2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2832: 'Item Key is: ' || itemkey);
2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2828: 'Entered OKC_REP_WF_PVT.complete_notification');
2829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2830: 'Item Type is: ' || itemtype);
2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2832: 'Item Key is: ' || itemkey);
2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2834: 'actid is: ' || to_char(actid));
2835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2830: 'Item Type is: ' || itemtype);
2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2832: 'Item Key is: ' || itemkey);
2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2834: 'actid is: ' || to_char(actid));
2835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2836: 'Function mode is: ' || funcmode);
2837: END IF;

Line 2835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2832: 'Item Key is: ' || itemkey);
2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2834: 'actid is: ' || to_char(actid));
2835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2836: 'Function mode is: ' || funcmode);
2837: END IF;
2838:
2839: IF (funcmode = 'RUN') THEN

Line 2855: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2851: itemtype => itemtype,
2852: itemkey => itemkey,
2853: aname => 'CONC_REQUEST_ID' );
2854:
2855: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2856: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1810: Entering con_attach_generated_yn');
2857: END IF;
2858:
2859: OPEN contract_attachment_exists(l_contract_id, l_contract_type, l_con_req_id) ;

Line 2856: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1810: Entering con_attach_generated_yn');

2852: itemkey => itemkey,
2853: aname => 'CONC_REQUEST_ID' );
2854:
2855: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2856: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1810: Entering con_attach_generated_yn');
2857: END IF;
2858:
2859: OPEN contract_attachment_exists(l_contract_id, l_contract_type, l_con_req_id) ;
2860: FETCH contract_attachment_exists into l_value;

Line 2872: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2868:
2869: END IF; -- RUN
2870: EXCEPTION
2871: WHEN others THEN
2872: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2873: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2874: g_module || l_api_name,
2875: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2876: END IF;

Line 2873: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2869: END IF; -- RUN
2870: EXCEPTION
2871: WHEN others THEN
2872: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2873: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2874: g_module || l_api_name,
2875: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2876: END IF;
2877: wf_core.context('OKC_REP_WF_PVT',

Line 2923: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2919: select decode(category, 'EMPLOYEE', source_id, null) person_id from jtf_rs_resource_extns where user_id =p_user_id ;
2920:
2921: BEGIN
2922:
2923: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2924: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'Entering check_current_approver for contract_id '||p_contract_id || 'user id '||p_user_id);
2925: END IF;
2926:
2927: ame_api2.getPendingApprovers(applicationIdIn => G_APPLICATION_ID,

Line 2924: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'Entering check_current_approver for contract_id '||p_contract_id || 'user id '||p_user_id);

2920:
2921: BEGIN
2922:
2923: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2924: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'Entering check_current_approver for contract_id '||p_contract_id || 'user id '||p_user_id);
2925: END IF;
2926:
2927: ame_api2.getPendingApprovers(applicationIdIn => G_APPLICATION_ID,
2928: transactionTypeIn => G_TRANSACTION_TYPE,

Line 2947: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2943: l_is_valid := 'Y';
2944: END IF;
2945: END LOOP;
2946:
2947: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2949: 'Leaving check_current_approver l_is_valid as '||l_is_valid );
2950: END IF;
2951:

Line 2948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

2944: END IF;
2945: END LOOP;
2946:
2947: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2948: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2949: 'Leaving check_current_approver l_is_valid as '||l_is_valid );
2950: END IF;
2951:
2952: RETURN l_is_valid;

Line 2988: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2984: BEGIN
2985:
2986: l_api_name := 'allow_approver_edit';
2987:
2988: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2989: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2990: 'Entered OKC_REP_WF_PVT.allow_approver_edit');
2991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2992: 'Item Type is: ' || itemtype);

Line 2989: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2985:
2986: l_api_name := 'allow_approver_edit';
2987:
2988: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2989: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2990: 'Entered OKC_REP_WF_PVT.allow_approver_edit');
2991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2992: 'Item Type is: ' || itemtype);
2993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2987:
2988: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2989: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2990: 'Entered OKC_REP_WF_PVT.allow_approver_edit');
2991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2992: 'Item Type is: ' || itemtype);
2993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2994: 'Item Key is: ' || itemkey);
2995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2989: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2990: 'Entered OKC_REP_WF_PVT.allow_approver_edit');
2991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2992: 'Item Type is: ' || itemtype);
2993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2994: 'Item Key is: ' || itemkey);
2995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2996: 'actid is: ' || to_char(actid));
2997: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2992: 'Item Type is: ' || itemtype);
2993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2994: 'Item Key is: ' || itemkey);
2995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2996: 'actid is: ' || to_char(actid));
2997: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2998: 'Function mode is: ' || funcmode);
2999: END IF;

Line 2997: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2994: 'Item Key is: ' || itemkey);
2995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2996: 'actid is: ' || to_char(actid));
2997: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2998: 'Function mode is: ' || funcmode);
2999: END IF;
3000:
3001: IF (funcmode = 'RUN') THEN

Line 3022: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3018:
3019: END IF; -- RUN
3020: EXCEPTION
3021: WHEN others THEN
3022: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3023: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3024: g_module || l_api_name,
3025: 'Leaving OKC_REP_WF_PVT.allow_approver_edit with exceptions ' || sqlerrm);
3026: END IF;

Line 3023: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

3019: END IF; -- RUN
3020: EXCEPTION
3021: WHEN others THEN
3022: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3023: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3024: g_module || l_api_name,
3025: 'Leaving OKC_REP_WF_PVT.allow_approver_edit with exceptions ' || sqlerrm);
3026: END IF;
3027: wf_core.context('OKC_REP_WF_PVT',

Line 3072: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3068: BEGIN
3069:
3070: l_api_name := 'contract_preview_yn';
3071:
3072: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3074: 'Entered OKC_REP_WF_PVT.contract_preview_yn');
3075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3076: 'Item Type is: ' || itemtype);

Line 3073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3069:
3070: l_api_name := 'contract_preview_yn';
3071:
3072: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3074: 'Entered OKC_REP_WF_PVT.contract_preview_yn');
3075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3076: 'Item Type is: ' || itemtype);
3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3071:
3072: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3074: 'Entered OKC_REP_WF_PVT.contract_preview_yn');
3075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3076: 'Item Type is: ' || itemtype);
3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3078: 'Item Key is: ' || itemkey);
3079: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3074: 'Entered OKC_REP_WF_PVT.contract_preview_yn');
3075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3076: 'Item Type is: ' || itemtype);
3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3078: 'Item Key is: ' || itemkey);
3079: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3080: 'actid is: ' || to_char(actid));
3081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3079: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3076: 'Item Type is: ' || itemtype);
3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3078: 'Item Key is: ' || itemkey);
3079: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3080: 'actid is: ' || to_char(actid));
3081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3082: 'Function mode is: ' || funcmode);
3083: END IF;

Line 3081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3078: 'Item Key is: ' || itemkey);
3079: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3080: 'actid is: ' || to_char(actid));
3081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3082: 'Function mode is: ' || funcmode);
3083: END IF;
3084:
3085: IF (funcmode = 'RUN') THEN

Line 3109: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3105:
3106: END IF; -- RUN
3107: EXCEPTION
3108: WHEN others THEN
3109: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3110: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3111: g_module || l_api_name,
3112: 'Leaving OKC_REP_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);
3113: END IF;

Line 3110: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

3106: END IF; -- RUN
3107: EXCEPTION
3108: WHEN others THEN
3109: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3110: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3111: g_module || l_api_name,
3112: 'Leaving OKC_REP_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);
3113: END IF;
3114: wf_core.context('OKC_REP_WF_PVT',

Line 3146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3142: BEGIN
3143:
3144: l_api_name := 'Apps_initialize';
3145:
3146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3148: 'Entered OKC_REP_WF_PVT.Apps_initialize');
3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3150: 'Item Type is: ' || itemtype);

Line 3147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3143:
3144: l_api_name := 'Apps_initialize';
3145:
3146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3148: 'Entered OKC_REP_WF_PVT.Apps_initialize');
3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3150: 'Item Type is: ' || itemtype);
3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3145:
3146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3148: 'Entered OKC_REP_WF_PVT.Apps_initialize');
3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3150: 'Item Type is: ' || itemtype);
3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3152: 'Item Key is: ' || itemkey);
3153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3148: 'Entered OKC_REP_WF_PVT.Apps_initialize');
3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3150: 'Item Type is: ' || itemtype);
3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3152: 'Item Key is: ' || itemkey);
3153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3154: 'actid is: ' || to_char(actid));
3155: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 3153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3150: 'Item Type is: ' || itemtype);
3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3152: 'Item Key is: ' || itemkey);
3153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3154: 'actid is: ' || to_char(actid));
3155: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3156: 'Function mode is: ' || funcmode);
3157: END IF;

Line 3155: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3152: 'Item Key is: ' || itemkey);
3153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3154: 'actid is: ' || to_char(actid));
3155: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3156: 'Function mode is: ' || funcmode);
3157: END IF;
3158:
3159: IF (funcmode = 'RUN') THEN

Line 3202: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3198: END IF; -- RUN
3199:
3200: EXCEPTION
3201: WHEN others THEN
3202: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3203: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3204: g_module || l_api_name,
3205: 'Leaving OKC_REP_WF_PVT.Apps_initialize with exceptions ' || sqlerrm);
3206: END IF;

Line 3203: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

3199:
3200: EXCEPTION
3201: WHEN others THEN
3202: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3203: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3204: g_module || l_api_name,
3205: 'Leaving OKC_REP_WF_PVT.Apps_initialize with exceptions ' || sqlerrm);
3206: END IF;
3207: wf_core.context('OKC_REP_WF_PVT',