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 100: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

96: BEGIN
97:
98: l_api_name := 'initialize_attributes';
99:
100: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
102: 'Entered OKC_REP_WF_PVT.initialize_attributes');
103: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
104: 'Item Type is: ' || itemtype);

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

97:
98: l_api_name := 'initialize_attributes';
99:
100: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
102: 'Entered OKC_REP_WF_PVT.initialize_attributes');
103: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
104: 'Item Type is: ' || itemtype);
105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

99:
100: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
102: 'Entered OKC_REP_WF_PVT.initialize_attributes');
103: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
104: 'Item Type is: ' || itemtype);
105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
106: 'Item Key is: ' || itemkey);
107: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

101: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
102: 'Entered OKC_REP_WF_PVT.initialize_attributes');
103: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
104: 'Item Type is: ' || itemtype);
105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
106: 'Item Key is: ' || itemkey);
107: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
108: 'actid is: ' || to_char(actid));
109: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

103: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
104: 'Item Type is: ' || itemtype);
105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
106: 'Item Key is: ' || itemkey);
107: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
108: 'actid is: ' || to_char(actid));
109: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
110: 'Function mode is: ' || funcmode);
111: END IF;

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

105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
106: 'Item Key is: ' || itemkey);
107: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
108: 'actid is: ' || to_char(actid));
109: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
110: 'Function mode is: ' || funcmode);
111: END IF;
112: IF (funcmode = 'RUN') THEN
113: l_contract_id := wf_engine.GetItemAttrNumber(

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

121: IF(contract_csr%NOTFOUND) THEN
122: RAISE NO_DATA_FOUND;
123: END IF;
124:
125: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
127: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
128: END IF;
129: WF_ENGINE.SetItemAttrText (

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

122: RAISE NO_DATA_FOUND;
123: END IF;
124:
125: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
127: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
128: END IF;
129: WF_ENGINE.SetItemAttrText (
130: itemtype => itemtype,

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

131: itemkey => itemkey,
132: aname => 'CONTRACT_TYPE',
133: avalue => contract_rec.contract_type);
134:
135: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
137: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
138: END IF;
139: WF_ENGINE.SetItemAttrText (

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

132: aname => 'CONTRACT_TYPE',
133: avalue => contract_rec.contract_type);
134:
135: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
137: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
138: END IF;
139: WF_ENGINE.SetItemAttrText (
140: itemtype => itemtype,

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

142: aname => 'CONTRACT_NUMBER',
143: avalue => contract_rec.contract_number);
144:
145:
146: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
148: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
149: END IF;
150: WF_ENGINE.SetItemAttrNumber (

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

143: avalue => contract_rec.contract_number);
144:
145:
146: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
148: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
149: END IF;
150: WF_ENGINE.SetItemAttrNumber (
151: itemtype => itemtype,

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

152: itemkey => itemkey,
153: aname => 'CONTRACT_VERSION',
154: avalue => contract_rec.contract_version_num);
155:
156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
158: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
159: END IF;
160: WF_ENGINE.SetItemAttrText (

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

153: aname => 'CONTRACT_VERSION',
154: avalue => contract_rec.contract_version_num);
155:
156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
158: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
159: END IF;
160: WF_ENGINE.SetItemAttrText (
161: itemtype => itemtype,

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

162: itemkey => itemkey,
163: aname => 'CONTRACT_NAME',
164: avalue => contract_rec.contract_name);
165:
166: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
168: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
169: END IF;
170: WF_ENGINE.SetItemAttrText (

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

163: aname => 'CONTRACT_NAME',
164: avalue => contract_rec.contract_name);
165:
166: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
168: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
169: END IF;
170: WF_ENGINE.SetItemAttrText (
171: itemtype => itemtype,

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

182: transactionIdIn => fnd_number.number_to_canonical(l_contract_id));
183:
184: CLOSE contract_csr;
185: resultout := 'COMPLETE:';
186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
188: g_module || l_api_name ,
189: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=RUN');
190: END IF;

Line 187: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

183:
184: CLOSE contract_csr;
185: resultout := 'COMPLETE:';
186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
188: g_module || l_api_name ,
189: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=RUN');
190: END IF;
191: RETURN;

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

193:
194:
195: IF (funcmode = 'CANCEL') THEN
196: resultout := 'COMPLETE:';
197: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
199: g_module || l_api_name,
200: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=CANCEL');
201: END IF;

Line 198: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

194:
195: IF (funcmode = 'CANCEL') THEN
196: resultout := 'COMPLETE:';
197: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
199: g_module || l_api_name,
200: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=CANCEL');
201: END IF;
202: RETURN;

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

203: END IF; -- (funcmode = 'CANCEL')
204:
205: IF (funcmode = 'TIMEOUT') THEN
206: resultout := 'COMPLETE:';
207: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
208: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
209: g_module || l_api_name,
210: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=TIMEOUT');
211: END IF;

Line 208: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

204:
205: IF (funcmode = 'TIMEOUT') THEN
206: resultout := 'COMPLETE:';
207: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
208: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
209: g_module || l_api_name,
210: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=TIMEOUT');
211: END IF;
212: RETURN;

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

217: --close cursors
218: IF (contract_csr%ISOPEN) THEN
219: CLOSE contract_csr ;
220: END IF;
221: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
222: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
223: g_module || l_api_name,
224: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
225: END IF;

Line 222: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

218: IF (contract_csr%ISOPEN) THEN
219: CLOSE contract_csr ;
220: END IF;
221: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
222: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
223: g_module || l_api_name,
224: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
225: END IF;
226: wf_core.context('OKC_REP_WF_PVT',

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

274: BEGIN
275:
276: l_api_name := 'has_next_approver';
277:
278: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
280: 'Entered OKC_REP_WF_PVT.has_next_approver');
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
282: 'Item Type is: ' || itemtype);

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

275:
276: l_api_name := 'has_next_approver';
277:
278: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
280: 'Entered OKC_REP_WF_PVT.has_next_approver');
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
282: 'Item Type is: ' || itemtype);
283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

277:
278: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
280: 'Entered OKC_REP_WF_PVT.has_next_approver');
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
282: 'Item Type is: ' || itemtype);
283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
284: 'Item Key is: ' || itemkey);
285: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
280: 'Entered OKC_REP_WF_PVT.has_next_approver');
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
282: 'Item Type is: ' || itemtype);
283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
284: 'Item Key is: ' || itemkey);
285: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
286: 'actid is: ' || to_char(actid));
287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
282: 'Item Type is: ' || itemtype);
283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
284: 'Item Key is: ' || itemkey);
285: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
286: 'actid is: ' || to_char(actid));
287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
288: 'Function mode is: ' || funcmode);
289: END IF;

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

283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
284: 'Item Key is: ' || itemkey);
285: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
286: 'actid is: ' || to_char(actid));
287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
288: 'Function mode is: ' || funcmode);
289: END IF;
290: IF (funcmode = 'RUN') then
291: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
288: 'Function mode is: ' || funcmode);
289: END IF;
290: IF (funcmode = 'RUN') then
291: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
293: g_module || l_api_name,
294: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
295: END IF;

Line 292: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

288: 'Function mode is: ' || funcmode);
289: END IF;
290: IF (funcmode = 'RUN') then
291: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
293: g_module || l_api_name,
294: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
295: END IF;
296: l_contract_id := wf_engine.GetItemAttrNumber(

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

296: l_contract_id := wf_engine.GetItemAttrNumber(
297: itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'CONTRACT_ID');
300: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
301: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
302: g_module || l_api_name,
303: 'Contract Id is: ' || to_char(l_contract_id));
304: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 301: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

297: itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'CONTRACT_ID');
300: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
301: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
302: g_module || l_api_name,
303: 'Contract Id is: ' || to_char(l_contract_id));
304: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
305: g_module || l_api_name,

Line 304: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

300: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
301: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
302: g_module || l_api_name,
303: 'Contract Id is: ' || to_char(l_contract_id));
304: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
305: g_module || l_api_name,
306: 'Calling ame_api.getNextApprover to get the approver id');
307: END IF;
308: ame_api2.getNextApprovers1(

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

315: itemIndexesOut => l_item_indexes,
316: itemClassesOut => l_item_classes,
317: itemIdsOut => l_item_ids,
318: itemSourcesOut => l_item_sources);
319: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
321: g_module || l_api_name,
322: 'Number of approvers: ' || to_char(l_next_approvers.count));
323: END IF;

Line 320: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

316: itemClassesOut => l_item_classes,
317: itemIdsOut => l_item_ids,
318: itemSourcesOut => l_item_sources);
319: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
321: g_module || l_api_name,
322: 'Number of approvers: ' || to_char(l_next_approvers.count));
323: END IF;
324: IF (l_next_approvers.count = 0) THEN

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

350: END IF;
351: END IF;
352: END LOOP;
353:
354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
356: g_module || l_api_name,
357: 'Adhoc role name is : ' || l_user_names);
358: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 355: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

351: END IF;
352: END LOOP;
353:
354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
356: g_module || l_api_name,
357: 'Adhoc role name is : ' || l_user_names);
358: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
359: g_module || l_api_name,

Line 358: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

354: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
356: g_module || l_api_name,
357: 'Adhoc role name is : ' || l_user_names);
358: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
359: g_module || l_api_name,
360: 'Calling WF_DIRECTORY.createAdHocRole');
361: END IF;
362: -- Create an adhoc role using l_user_names

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

371: email_address=>null,
372: fax=>null,
373: status=>'ACTIVE',
374: expiration_date=>SYSDATE+1);
375: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
377: g_module || l_api_name,
378: 'Completed Adhoc role creation');
379: END IF;

Line 376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

372: fax=>null,
373: status=>'ACTIVE',
374: expiration_date=>SYSDATE+1);
375: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
377: g_module || l_api_name,
378: 'Completed Adhoc role creation');
379: END IF;
380: wf_engine.SetItemAttrText (

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

384: avalue => l_role_name);
385: resultout := 'COMPLETE:T';
386: END IF; -- (l_next_approvers.count = 0)
387:
388: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
390: g_module || l_api_name,
391: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=RUN');
392: END IF;

Line 389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

385: resultout := 'COMPLETE:T';
386: END IF; -- (l_next_approvers.count = 0)
387:
388: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
390: g_module || l_api_name,
391: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=RUN');
392: END IF;
393: RETURN;

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

395:
396:
397: IF (funcmode = 'CANCEL') THEN
398: resultout := 'COMPLETE:';
399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
401: g_module || l_api_name,
402: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=CANCEL');
403: END IF;

Line 400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

396:
397: IF (funcmode = 'CANCEL') THEN
398: resultout := 'COMPLETE:';
399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
401: g_module || l_api_name,
402: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=CANCEL');
403: END IF;
404: RETURN;

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

405: END IF; -- (funcmode = 'CANCEL')
406:
407: IF (funcmode = 'TIMEOUT') THEN
408: resultout := 'COMPLETE:';
409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
411: g_module || l_api_name,
412: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=TIMEOUT');
413: END IF;

Line 410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

406:
407: IF (funcmode = 'TIMEOUT') THEN
408: resultout := 'COMPLETE:';
409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
411: g_module || l_api_name,
412: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=TIMEOUT');
413: END IF;
414: RETURN;

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

415: END IF; -- (funcmode = 'TIMEOUT')
416:
417: EXCEPTION
418: WHEN others THEN
419: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
420: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
421: g_module || l_api_name,
422: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
423: END IF;

Line 420: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

416:
417: EXCEPTION
418: WHEN others THEN
419: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
420: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
421: g_module || l_api_name,
422: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
423: END IF;
424: wf_core.context('OKC_REP_WF_PVT',

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

483:
484: l_api_name := 'is_approval_complete';
485:
486:
487: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
489: 'Entered OKC_REP_WF_PVT.is_approval_complete');
490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
491: 'Item Type is: ' || itemtype);

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

484: l_api_name := 'is_approval_complete';
485:
486:
487: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
489: 'Entered OKC_REP_WF_PVT.is_approval_complete');
490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
491: 'Item Type is: ' || itemtype);
492: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

486:
487: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
489: 'Entered OKC_REP_WF_PVT.is_approval_complete');
490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
491: 'Item Type is: ' || itemtype);
492: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
493: 'Item Key is: ' || itemkey);
494: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

488: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
489: 'Entered OKC_REP_WF_PVT.is_approval_complete');
490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
491: 'Item Type is: ' || itemtype);
492: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
493: 'Item Key is: ' || itemkey);
494: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
495: 'actid is: ' || to_char(actid));
496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
491: 'Item Type is: ' || itemtype);
492: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
493: 'Item Key is: ' || itemkey);
494: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
495: 'actid is: ' || to_char(actid));
496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
497: 'Function mode is: ' || funcmode);
498: END IF;

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

492: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
493: 'Item Key is: ' || itemkey);
494: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
495: 'actid is: ' || to_char(actid));
496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
497: 'Function mode is: ' || funcmode);
498: END IF;
499: IF (funcmode = 'RUN') then
500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
497: 'Function mode is: ' || funcmode);
498: END IF;
499: IF (funcmode = 'RUN') then
500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
502: g_module || l_api_name,
503: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
504: END IF;

Line 501: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

497: 'Function mode is: ' || funcmode);
498: END IF;
499: IF (funcmode = 'RUN') then
500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
502: g_module || l_api_name,
503: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
504: END IF;
505: l_contract_id := wf_engine.GetItemAttrNumber(

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

505: l_contract_id := wf_engine.GetItemAttrNumber(
506: itemtype => itemtype,
507: itemkey => itemkey,
508: aname => 'CONTRACT_ID');
509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
511: g_module || l_api_name,
512: 'Contract Id is: ' || to_char(l_contract_id));
513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

506: itemtype => itemtype,
507: itemkey => itemkey,
508: aname => 'CONTRACT_ID');
509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
511: g_module || l_api_name,
512: 'Contract Id is: ' || to_char(l_contract_id));
513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
514: g_module || l_api_name,

Line 513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
511: g_module || l_api_name,
512: 'Contract Id is: ' || to_char(l_contract_id));
513: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
514: g_module || l_api_name,
515: 'Calling ame_api2.getNextApprover1 to get the approver id');
516: END IF;
517: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

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

525: itemIndexesOut => l_item_indexes,
526: itemClassesOut => l_item_classes,
527: itemIdsOut => l_item_ids,
528: itemSourcesOut => l_item_sources);
529: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
531: g_module || l_api_name,
532: 'Number of approvers: ' || to_char(l_next_approvers.count));
533: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 530: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

526: itemClassesOut => l_item_classes,
527: itemIdsOut => l_item_ids,
528: itemSourcesOut => l_item_sources);
529: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
531: g_module || l_api_name,
532: 'Number of approvers: ' || to_char(l_next_approvers.count));
533: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
534: g_module || l_api_name,

Line 533: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

529: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
531: g_module || l_api_name,
532: 'Number of approvers: ' || to_char(l_next_approvers.count));
533: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
534: g_module || l_api_name,
535: 'l_process_complete_yn: ' || l_process_complete_yn);
536: END IF;
537: IF (l_process_complete_yn = 'W') THEN

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

567: aname => 'APPROVER_COUNTER');
568: FOR i IN l_next_approvers.first..l_next_approvers.last LOOP
569: IF l_next_approvers.exists(i) THEN
570: l_user_name := l_next_approvers(i).name;
571: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
572: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
573: g_module || l_api_name,
574: 'User name for role is : ' || l_user_name);
575: END IF;

Line 572: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

568: FOR i IN l_next_approvers.first..l_next_approvers.last LOOP
569: IF l_next_approvers.exists(i) THEN
570: l_user_name := l_next_approvers(i).name;
571: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
572: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
573: g_module || l_api_name,
574: 'User name for role is : ' || l_user_name);
575: END IF;
576: l_notified_count := l_notified_count + 1;

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

574: 'User name for role is : ' || l_user_name);
575: END IF;
576: l_notified_count := l_notified_count + 1;
577: l_item_key := itemkey || '_' || to_char(l_notified_count);
578: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
580: 'Calling WF_ENGINE.createprocess for Notification');
581: END IF;
582:

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

575: END IF;
576: l_notified_count := l_notified_count + 1;
577: l_item_key := itemkey || '_' || to_char(l_notified_count);
578: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
580: 'Calling WF_ENGINE.createprocess for Notification');
581: END IF;
582:
583: WF_ENGINE.createprocess (

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

584: itemtype => itemtype,
585: itemkey => l_item_key,
586: process => G_APPROVAL_NOTIF_PROCESS);
587:
588: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
590: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
591: END IF;
592: WF_ENGINE.SetItemOwner (

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

585: itemkey => l_item_key,
586: process => G_APPROVAL_NOTIF_PROCESS);
587:
588: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
590: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
591: END IF;
592: WF_ENGINE.SetItemOwner (
593: itemtype => itemtype,

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

593: itemtype => itemtype,
594: itemkey => l_item_key,
595: owner => fnd_global.user_name);
596:
597: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
599: 'Setting Notification Process Approver to: ' || l_user_name);
600: END IF;
601: WF_ENGINE.SetItemAttrText (

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

594: itemkey => l_item_key,
595: owner => fnd_global.user_name);
596:
597: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
599: 'Setting Notification Process Approver to: ' || l_user_name);
600: END IF;
601: WF_ENGINE.SetItemAttrText (
602: itemtype => itemtype,

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

603: itemkey => l_item_key,
604: aname => 'APPROVER',
605: avalue => l_user_name);
606:
607: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
609: 'Setting Notification Process Contract Id to: ' || l_contract_id);
610: END IF;
611: WF_ENGINE.SetItemAttrNumber (

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

604: aname => 'APPROVER',
605: avalue => l_user_name);
606:
607: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
609: 'Setting Notification Process Contract Id to: ' || l_contract_id);
610: END IF;
611: WF_ENGINE.SetItemAttrNumber (
612: itemtype => itemtype,

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

613: itemkey => l_item_key,
614: aname => 'CONTRACT_ID',
615: avalue => l_contract_id);
616:
617: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
619: 'Setting Notification Process Contract Name: ' || l_contract_name);
620: END IF;
621: WF_ENGINE.SetItemAttrText (

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

614: aname => 'CONTRACT_ID',
615: avalue => l_contract_id);
616:
617: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
619: 'Setting Notification Process Contract Name: ' || l_contract_name);
620: END IF;
621: WF_ENGINE.SetItemAttrText (
622: itemtype => itemtype,

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

623: itemkey => l_item_key,
624: aname => 'CONTRACT_NAME',
625: avalue => l_contract_name);
626:
627: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
629: 'Setting Notification Process Contract Version: ' || l_contract_version);
630: END IF;
631: WF_ENGINE.SetItemAttrNumber (

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

624: aname => 'CONTRACT_NAME',
625: avalue => l_contract_name);
626:
627: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
629: 'Setting Notification Process Contract Version: ' || l_contract_version);
630: END IF;
631: WF_ENGINE.SetItemAttrNumber (
632: itemtype => itemtype,

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

633: itemkey => l_item_key,
634: aname => 'CONTRACT_VERSION',
635: avalue => l_contract_version);
636:
637: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
639: 'Setting Notification Process Contract Type: ' || l_contract_type);
640: END IF;
641: WF_ENGINE.SetItemAttrText (

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

634: aname => 'CONTRACT_VERSION',
635: avalue => l_contract_version);
636:
637: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
639: 'Setting Notification Process Contract Type: ' || l_contract_type);
640: END IF;
641: WF_ENGINE.SetItemAttrText (
642: itemtype => itemtype,

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

643: itemkey => l_item_key,
644: aname => 'CONTRACT_TYPE',
645: avalue => l_contract_type);
646:
647: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
648: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
649: 'Setting Notification Process Contract Number: ' || l_contract_number);
650: END IF;
651: WF_ENGINE.SetItemAttrText (

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

644: aname => 'CONTRACT_TYPE',
645: avalue => l_contract_type);
646:
647: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
648: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
649: 'Setting Notification Process Contract Number: ' || l_contract_number);
650: END IF;
651: WF_ENGINE.SetItemAttrText (
652: itemtype => itemtype,

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

653: itemkey => l_item_key,
654: aname => 'CONTRACT_NUMBER',
655: avalue => l_contract_number);
656:
657: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
659: 'Setting Notification Process Requester: ' || l_requester);
660: END IF;
661: WF_ENGINE.SetItemAttrText (

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

654: aname => 'CONTRACT_NUMBER',
655: avalue => l_contract_number);
656:
657: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
659: 'Setting Notification Process Requester: ' || l_requester);
660: END IF;
661: WF_ENGINE.SetItemAttrText (
662: itemtype => itemtype,

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

663: itemkey => l_item_key,
664: aname => 'REQUESTER',
665: avalue => l_requester);
666:
667: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
668: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
669: 'Setting Notification Process Contract Attachment');
670: END IF;
671: WF_ENGINE.SetItemAttrText (

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

664: aname => 'REQUESTER',
665: avalue => l_requester);
666:
667: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
668: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
669: 'Setting Notification Process Contract Attachment');
670: END IF;
671: WF_ENGINE.SetItemAttrText (
672: itemtype => itemtype,

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

675: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type
676: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
677: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
678:
679: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
680: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
681: 'Setting Notification Process Master Item Key to: ' || itemkey);
682: END IF;
683: WF_ENGINE.SetItemAttrText (

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

676: ||'&pk2name=BusinessDocumentId&pk2value='||l_contract_id
677: ||'&pk3name=BusinessDocumentVersion&pk3value=-99&categories=OKC_REPO_CONTRACT,OKC_REPO_APP_ABSTRACT');
678:
679: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
680: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
681: 'Setting Notification Process Master Item Key to: ' || itemkey);
682: END IF;
683: WF_ENGINE.SetItemAttrText (
684: itemtype => itemtype,

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

684: itemtype => itemtype,
685: itemkey => l_item_key,
686: aname => 'MASTER_ITEM_KEY',
687: avalue => itemkey);
688: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
690: 'Starting Notification Process ');
691: END IF;
692: wf_engine.startProcess(

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

685: itemkey => l_item_key,
686: aname => 'MASTER_ITEM_KEY',
687: avalue => itemkey);
688: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
690: 'Starting Notification Process ');
691: END IF;
692: wf_engine.startProcess(
693: itemtype => itemtype,

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

693: itemtype => itemtype,
694: itemkey => l_item_key);
695: END IF; -- l_next_approvers.exists(i)
696: END LOOP;
697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
698: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
699: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
700: END IF;
701: WF_ENGINE.SetItemAttrNumber (

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

694: itemkey => l_item_key);
695: END IF; -- l_next_approvers.exists(i)
696: END LOOP;
697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
698: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
699: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
700: END IF;
701: WF_ENGINE.SetItemAttrNumber (
702: itemtype => itemtype,

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

704: aname => 'APPROVER_COUNTER',
705: avalue => l_notified_count);
706: END IF; -- (l_next_approvers.count > 0)
707:
708: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
709: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
710: g_module || l_api_name,
711: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=RUN');
712: END IF;

Line 709: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

705: avalue => l_notified_count);
706: END IF; -- (l_next_approvers.count > 0)
707:
708: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
709: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
710: g_module || l_api_name,
711: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=RUN');
712: END IF;
713: RETURN;

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

715:
716:
717: IF (funcmode = 'CANCEL') THEN
718: resultout := 'COMPLETE:';
719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
721: g_module || l_api_name,
722: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=CANCEL');
723: END IF;

Line 720: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

716:
717: IF (funcmode = 'CANCEL') THEN
718: resultout := 'COMPLETE:';
719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
721: g_module || l_api_name,
722: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=CANCEL');
723: END IF;
724: RETURN;

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

725: END IF; -- (funcmode = 'CANCEL')
726:
727: IF (funcmode = 'TIMEOUT') THEN
728: resultout := 'COMPLETE:';
729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
731: g_module || l_api_name,
732: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=TIMEOUT');
733: END IF;

Line 730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

726:
727: IF (funcmode = 'TIMEOUT') THEN
728: resultout := 'COMPLETE:';
729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
731: g_module || l_api_name,
732: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=TIMEOUT');
733: END IF;
734: RETURN;

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

735: END IF; -- (funcmode = 'TIMEOUT')
736:
737: EXCEPTION
738: WHEN others THEN
739: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
741: g_module || l_api_name,
742: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
743: END IF;

Line 740: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

736:
737: EXCEPTION
738: WHEN others THEN
739: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
741: g_module || l_api_name,
742: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
743: END IF;
744: wf_core.context('OKC_REP_WF_PVT',

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

818: BEGIN
819:
820: l_api_name := 'update_ame_status';
821:
822: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
824: 'Entered OKC_REP_WF_PVT.update_ame_status');
825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
826: 'Item Type is: ' || itemtype);

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

819:
820: l_api_name := 'update_ame_status';
821:
822: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
824: 'Entered OKC_REP_WF_PVT.update_ame_status');
825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
826: 'Item Type is: ' || itemtype);
827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

821:
822: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
824: 'Entered OKC_REP_WF_PVT.update_ame_status');
825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
826: 'Item Type is: ' || itemtype);
827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
828: 'Item Key is: ' || itemkey);
829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

823: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
824: 'Entered OKC_REP_WF_PVT.update_ame_status');
825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
826: 'Item Type is: ' || itemtype);
827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
828: 'Item Key is: ' || itemkey);
829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
830: 'actid is: ' || to_char(actid));
831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
826: 'Item Type is: ' || itemtype);
827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
828: 'Item Key is: ' || itemkey);
829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
830: 'actid is: ' || to_char(actid));
831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
832: 'Function mode is: ' || funcmode);
833: END IF;

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

827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
828: 'Item Key is: ' || itemkey);
829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
830: 'actid is: ' || to_char(actid));
831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
832: 'Function mode is: ' || funcmode);
833: END IF;
834: -- Get contract id and version attributes
835: l_contract_id := wf_engine.GetItemAttrNumber(

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

848: l_approval_status := WF_NOTIFICATION.GetAttrText(
849: nid => WF_ENGINE.context_nid,
850: aname => 'RESULT');
851:
852: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
854: g_module || l_api_name,
855: 'Contract Id is: ' || to_char(l_contract_id));
856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 853: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

849: nid => WF_ENGINE.context_nid,
850: aname => 'RESULT');
851:
852: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
854: g_module || l_api_name,
855: 'Contract Id is: ' || to_char(l_contract_id));
856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
857: g_module || l_api_name,

Line 856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

852: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
854: g_module || l_api_name,
855: 'Contract Id is: ' || to_char(l_contract_id));
856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
857: g_module || l_api_name,
858: 'Contract Version is: ' || to_char(l_contract_version));
859: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
860: g_module || l_api_name,

Line 859: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

855: 'Contract Id is: ' || to_char(l_contract_id));
856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
857: g_module || l_api_name,
858: 'Contract Version is: ' || to_char(l_contract_version));
859: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
860: g_module || l_api_name,
861: 'Approver Notes : ' || l_wf_note);
862: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
863: g_module || l_api_name,

Line 862: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

858: 'Contract Version is: ' || to_char(l_contract_version));
859: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
860: g_module || l_api_name,
861: 'Approver Notes : ' || l_wf_note);
862: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
863: g_module || l_api_name,
864: 'Approver action is : ' || l_approval_status);
865: END IF;
866: -- Get the notification recipient

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

868: FETCH notif_csr into notif_rec;
869: IF(notif_csr%NOTFOUND) THEN
870: RAISE NO_DATA_FOUND;
871: END IF;
872: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
873: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
874: g_module || l_api_name,
875: 'Approver Name is : ' || notif_rec.user_name);
876: END IF;

Line 873: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

869: IF(notif_csr%NOTFOUND) THEN
870: RAISE NO_DATA_FOUND;
871: END IF;
872: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
873: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
874: g_module || l_api_name,
875: 'Approver Name is : ' || notif_rec.user_name);
876: END IF;
877: -- l_approver_record2.name := notif_rec.user_name;

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

879: -- FUNCTION MODE IS RESPOND.
880: IF (funcmode = 'RESPOND') THEN
881: -- CURRENT APPROVER APPROVED THE CONTRACTS
882: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
883: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
885: g_module || l_api_name,
886: 'Approver action is : ' || G_WF_STATUS_APPROVED);
887: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

880: IF (funcmode = 'RESPOND') THEN
881: -- CURRENT APPROVER APPROVED THE CONTRACTS
882: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
883: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
885: g_module || l_api_name,
886: 'Approver action is : ' || G_WF_STATUS_APPROVED);
887: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
888: g_module || l_api_name,

Line 887: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

883: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
885: g_module || l_api_name,
886: 'Approver action is : ' || G_WF_STATUS_APPROVED);
887: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
888: g_module || l_api_name,
889: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
890: END IF;
891: OKC_REP_UTIL_PVT.add_approval_hist_record(

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

898: p_note => l_wf_note,
899: x_msg_data => l_msg_data,
900: x_msg_count => l_msg_count,
901: x_return_status => l_return_status);
902: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
903: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
904: g_module || l_api_name,
905: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
906: END IF;

Line 903: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

899: x_msg_data => l_msg_data,
900: x_msg_count => l_msg_count,
901: x_return_status => l_return_status);
902: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
903: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
904: g_module || l_api_name,
905: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
906: END IF;
907: -------------------------------------------------------

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

921:
922: -- CURRENT APPROVER APPROVED THE CONTRACTS
923: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
924: -- Add a record in ONC_REP_CON_APPROVALS table.
925: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
927: g_module || l_api_name,
928: 'Approver action is : ' || G_WF_STATUS_REJECTED);
929: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 926: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

922: -- CURRENT APPROVER APPROVED THE CONTRACTS
923: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
924: -- Add a record in ONC_REP_CON_APPROVALS table.
925: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
927: g_module || l_api_name,
928: 'Approver action is : ' || G_WF_STATUS_REJECTED);
929: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
930: g_module || l_api_name,

Line 929: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

925: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
927: g_module || l_api_name,
928: 'Approver action is : ' || G_WF_STATUS_REJECTED);
929: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
930: g_module || l_api_name,
931: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
932: END IF;
933: OKC_REP_UTIL_PVT.add_approval_hist_record(

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

940: p_note => l_wf_note,
941: x_msg_data => l_msg_data,
942: x_msg_count => l_msg_count,
943: x_return_status => l_return_status);
944: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
946: g_module || l_api_name,
947: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
948: END IF;

Line 945: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

941: x_msg_data => l_msg_data,
942: x_msg_count => l_msg_count,
943: x_return_status => l_return_status);
944: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
946: g_module || l_api_name,
947: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
948: END IF;
949: -------------------------------------------------------

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

955: --------------------------------------------------------
956:
957: l_approver_record2.approval_status := ame_util.rejectStatus;
958: -- Update AME approval status
959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
961: g_module || l_api_name,
962: 'Calling ame_api2.updateApprovalStatus');
963: END IF;

Line 960: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

956:
957: l_approver_record2.approval_status := ame_util.rejectStatus;
958: -- Update AME approval status
959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
961: g_module || l_api_name,
962: 'Calling ame_api2.updateApprovalStatus');
963: END IF;
964: ame_api2.updateApprovalStatus(

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

967: approverIn => l_approver_record2,
968: transactionTypeIn => G_TRANSACTION_TYPE);
969: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
970: CLOSE notif_csr;
971: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
972: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
973: g_module || l_api_name,
974: 'resultout value is: ' || resultout);
975: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 972: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

968: transactionTypeIn => G_TRANSACTION_TYPE);
969: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
970: CLOSE notif_csr;
971: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
972: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
973: g_module || l_api_name,
974: 'resultout value is: ' || resultout);
975: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
976: g_module || l_api_name,

Line 975: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

971: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
972: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
973: g_module || l_api_name,
974: 'resultout value is: ' || resultout);
975: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
976: g_module || l_api_name,
977: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RESPOND');
978: END IF;
979: END IF; -- (funcmode = 'RESPOND')

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

987: ELSIF (l_approval_status = G_WF_STATUS_MORE_APPROVERS) THEN
988: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
989: ELSE resultout := 'COMPLETE:';
990: END IF;
991: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
992: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
993: g_module || l_api_name,
994: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');
995: END IF;

Line 992: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

988: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
989: ELSE resultout := 'COMPLETE:';
990: END IF;
991: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
992: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
993: g_module || l_api_name,
994: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');
995: END IF;
996: CLOSE notif_csr;

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

997: RETURN;
998: END IF; -- (funcmode = 'RUN')
999:
1000: IF (funcmode = 'TIMEOUT') THEN
1001: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1003: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1004: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1005: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

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

998: END IF; -- (funcmode = 'RUN')
999:
1000: IF (funcmode = 'TIMEOUT') THEN
1001: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1003: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1004: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1005: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1006: END IF;

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

1000: IF (funcmode = 'TIMEOUT') THEN
1001: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1003: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1004: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1005: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1006: END IF;
1007: OKC_REP_UTIL_PVT.add_approval_hist_record(
1008: p_api_version => 1.0,

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

1014: p_note => l_wf_note,
1015: x_msg_data => l_msg_data,
1016: x_msg_count => l_msg_count,
1017: x_return_status => l_return_status);
1018: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1020: g_module || l_api_name,
1021: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1022: END IF;

Line 1019: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1015: x_msg_data => l_msg_data,
1016: x_msg_count => l_msg_count,
1017: x_return_status => l_return_status);
1018: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1020: g_module || l_api_name,
1021: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1022: END IF;
1023: -------------------------------------------------------

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

1028: END IF;
1029: --------------------------------------------------------
1030: l_approver_record2.approval_status := ame_util.noResponseStatus;
1031:
1032: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1033: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1034: g_module || l_api_name,
1035: 'Calling ame_api2.updateApprovalStatus');
1036: END IF;

Line 1033: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1029: --------------------------------------------------------
1030: l_approver_record2.approval_status := ame_util.noResponseStatus;
1031:
1032: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1033: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1034: g_module || l_api_name,
1035: 'Calling ame_api2.updateApprovalStatus');
1036: END IF;
1037: ame_api2.updateApprovalStatus(

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

1039: transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
1040: approverIn => l_approver_record2,
1041: transactionTypeIn => G_TRANSACTION_TYPE);
1042:
1043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1045: g_module || l_api_name,
1046: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');
1047: END IF;

Line 1044: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1040: approverIn => l_approver_record2,
1041: transactionTypeIn => G_TRANSACTION_TYPE);
1042:
1043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1045: g_module || l_api_name,
1046: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');
1047: END IF;
1048: resultout := 'COMPLETE:';

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

1051: END IF; -- (funcmode = 'TIMEOUT')
1052:
1053: exception
1054: when others then
1055: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1057: g_module || l_api_name,
1058: '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);
1059: END IF;

Line 1056: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1052:
1053: exception
1054: when others then
1055: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1057: g_module || l_api_name,
1058: '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);
1059: END IF;
1060: --close cursors

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

1133: BEGIN
1134:
1135: l_api_name := 'update_ame_status';
1136:
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1139: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1141: 'Item Type is: ' || itemtype);

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

1134:
1135: l_api_name := 'update_ame_status';
1136:
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1139: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1141: 'Item Type is: ' || itemtype);
1142: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1136:
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1139: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1141: 'Item Type is: ' || itemtype);
1142: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1143: 'Item Key is: ' || itemkey);
1144: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1139: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1141: 'Item Type is: ' || itemtype);
1142: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1143: 'Item Key is: ' || itemkey);
1144: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1145: 'actid is: ' || to_char(actid));
1146: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1141: 'Item Type is: ' || itemtype);
1142: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1143: 'Item Key is: ' || itemkey);
1144: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1145: 'actid is: ' || to_char(actid));
1146: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1147: 'Function mode is: ' || funcmode);
1148: END IF;

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

1142: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1143: 'Item Key is: ' || itemkey);
1144: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1145: 'actid is: ' || to_char(actid));
1146: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1147: 'Function mode is: ' || funcmode);
1148: END IF;
1149: -- Get contract id and version attributes
1150: l_contract_id := wf_engine.GetItemAttrNumber(

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

1163: l_approval_status := WF_NOTIFICATION.GetAttrText(
1164: nid => WF_ENGINE.context_nid,
1165: aname => 'RESULT');
1166:
1167: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1169: g_module || l_api_name,
1170: 'Contract Id is: ' || to_char(l_contract_id));
1171: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1168: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1164: nid => WF_ENGINE.context_nid,
1165: aname => 'RESULT');
1166:
1167: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1169: g_module || l_api_name,
1170: 'Contract Id is: ' || to_char(l_contract_id));
1171: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1172: g_module || l_api_name,

Line 1171: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1167: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1169: g_module || l_api_name,
1170: 'Contract Id is: ' || to_char(l_contract_id));
1171: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1172: g_module || l_api_name,
1173: 'Contract Version is: ' || to_char(l_contract_version));
1174: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1175: g_module || l_api_name,

Line 1174: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1170: 'Contract Id is: ' || to_char(l_contract_id));
1171: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1172: g_module || l_api_name,
1173: 'Contract Version is: ' || to_char(l_contract_version));
1174: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1175: g_module || l_api_name,
1176: 'Approver Notes : ' || l_wf_note);
1177: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1178: g_module || l_api_name,

Line 1177: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1173: 'Contract Version is: ' || to_char(l_contract_version));
1174: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1175: g_module || l_api_name,
1176: 'Approver Notes : ' || l_wf_note);
1177: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1178: g_module || l_api_name,
1179: 'Approver action is : ' || l_approval_status);
1180: END IF;
1181: -- Get the notification recipient

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

1183: FETCH notif_csr into notif_rec;
1184: IF(notif_csr%NOTFOUND) THEN
1185: RAISE NO_DATA_FOUND;
1186: END IF;
1187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1189: g_module || l_api_name,
1190: 'Approver Name is : ' || notif_rec.user_name);
1191: END IF;

Line 1188: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1184: IF(notif_csr%NOTFOUND) THEN
1185: RAISE NO_DATA_FOUND;
1186: END IF;
1187: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1189: g_module || l_api_name,
1190: 'Approver Name is : ' || notif_rec.user_name);
1191: END IF;
1192: -- l_approver_record2.name := notif_rec.user_name;

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

1196: -- FUNCTION MODE IS RESPOND.
1197: IF (funcmode = 'RESPOND') THEN
1198: -- CURRENT APPROVER APPROVED THE CONTRACTS
1199: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
1200: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1202: g_module || l_api_name,
1203: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1204: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1197: IF (funcmode = 'RESPOND') THEN
1198: -- CURRENT APPROVER APPROVED THE CONTRACTS
1199: IF (l_approval_status = G_WF_STATUS_APPROVED) THEN
1200: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1202: g_module || l_api_name,
1203: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1204: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1205: g_module || l_api_name,

Line 1204: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1200: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1201: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1202: g_module || l_api_name,
1203: 'Approver action is : ' || G_WF_STATUS_APPROVED);
1204: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1205: g_module || l_api_name,
1206: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1207: END IF;
1208: OKC_REP_UTIL_PVT.add_approval_hist_record(

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

1215: p_note => l_wf_note,
1216: x_msg_data => l_msg_data,
1217: x_msg_count => l_msg_count,
1218: x_return_status => l_return_status);
1219: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1220: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1221: g_module || l_api_name,
1222: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1223: END IF;

Line 1220: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1216: x_msg_data => l_msg_data,
1217: x_msg_count => l_msg_count,
1218: x_return_status => l_return_status);
1219: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1220: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1221: g_module || l_api_name,
1222: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1223: END IF;
1224: -------------------------------------------------------

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

1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: --------------------------------------------------------
1231: l_approver_record2.approval_status := ame_util.approvedStatus;
1232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1234: g_module || l_api_name,
1235: 'Calling ame_api6.updateApprovalStatus');
1236: END IF;

Line 1233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1229: END IF;
1230: --------------------------------------------------------
1231: l_approver_record2.approval_status := ame_util.approvedStatus;
1232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1233: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1234: g_module || l_api_name,
1235: 'Calling ame_api6.updateApprovalStatus');
1236: END IF;
1237: ame_api6.updateApprovalStatus(

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

1244:
1245: -- CURRENT APPROVER APPROVED THE CONTRACTS
1246: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
1247: -- Add a record in ONC_REP_CON_APPROVALS table.
1248: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1249: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1250: g_module || l_api_name,
1251: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1252: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1249: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1245: -- CURRENT APPROVER APPROVED THE CONTRACTS
1246: ELSIF (l_approval_status = G_WF_STATUS_REJECTED) THEN
1247: -- Add a record in ONC_REP_CON_APPROVALS table.
1248: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1249: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1250: g_module || l_api_name,
1251: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1252: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1253: g_module || l_api_name,

Line 1252: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1248: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1249: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1250: g_module || l_api_name,
1251: 'Approver action is : ' || G_WF_STATUS_REJECTED);
1252: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1253: g_module || l_api_name,
1254: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1255: END IF;
1256: OKC_REP_UTIL_PVT.add_approval_hist_record(

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

1263: p_note => l_wf_note,
1264: x_msg_data => l_msg_data,
1265: x_msg_count => l_msg_count,
1266: x_return_status => l_return_status);
1267: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1268: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1269: g_module || l_api_name,
1270: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1271: END IF;

Line 1268: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1264: x_msg_data => l_msg_data,
1265: x_msg_count => l_msg_count,
1266: x_return_status => l_return_status);
1267: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1268: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1269: g_module || l_api_name,
1270: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1271: END IF;
1272: -------------------------------------------------------

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

1278: --------------------------------------------------------
1279:
1280: l_approver_record2.approval_status := ame_util.rejectStatus;
1281: -- Update AME approval status
1282: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1283: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1284: g_module || l_api_name,
1285: 'Calling ame_api6.updateApprovalStatus');
1286: END IF;

Line 1283: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1279:
1280: l_approver_record2.approval_status := ame_util.rejectStatus;
1281: -- Update AME approval status
1282: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1283: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1284: g_module || l_api_name,
1285: 'Calling ame_api6.updateApprovalStatus');
1286: END IF;
1287: ame_api6.updateApprovalStatus(

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

1291: transactionTypeIn => G_TRANSACTION_TYPE,
1292: notificationIn => l_notification_record);
1293: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
1294: CLOSE notif_csr;
1295: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1297: g_module || l_api_name,
1298: 'resultout value is: ' || resultout);
1299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

Line 1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1292: notificationIn => l_notification_record);
1293: END IF; -- (l_approval_status = G_WF_STATUS_APPROVED)
1294: CLOSE notif_csr;
1295: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1297: g_module || l_api_name,
1298: 'resultout value is: ' || resultout);
1299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1300: g_module || l_api_name,

Line 1299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1295: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1297: g_module || l_api_name,
1298: 'resultout value is: ' || resultout);
1299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1300: g_module || l_api_name,
1301: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RESPOND');
1302: END IF;
1303: END IF; -- (funcmode = 'RESPOND')

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

1311: ELSIF (l_approval_status = G_WF_STATUS_MORE_APPROVERS) THEN
1312: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
1313: ELSE resultout := 'COMPLETE:';
1314: END IF;
1315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1317: g_module || l_api_name,
1318: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');
1319: END IF;

Line 1316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1312: resultout := 'COMPLETE:' || G_WF_STATUS_MORE_APPROVERS;
1313: ELSE resultout := 'COMPLETE:';
1314: END IF;
1315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1317: g_module || l_api_name,
1318: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');
1319: END IF;
1320: CLOSE notif_csr;

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

1321: RETURN;
1322: END IF; -- (funcmode = 'RUN')
1323:
1324: IF (funcmode = 'TIMEOUT') THEN
1325: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1327: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1328: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1329: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');

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

1322: END IF; -- (funcmode = 'RUN')
1323:
1324: IF (funcmode = 'TIMEOUT') THEN
1325: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1327: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1328: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1329: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1330: END IF;

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

1324: IF (funcmode = 'TIMEOUT') THEN
1325: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1327: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1328: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1329: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1330: END IF;
1331: OKC_REP_UTIL_PVT.add_approval_hist_record(
1332: p_api_version => 1.0,

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

1338: p_note => l_wf_note,
1339: x_msg_data => l_msg_data,
1340: x_msg_count => l_msg_count,
1341: x_return_status => l_return_status);
1342: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1343: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1344: g_module || l_api_name,
1345: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1346: END IF;

Line 1343: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1339: x_msg_data => l_msg_data,
1340: x_msg_count => l_msg_count,
1341: x_return_status => l_return_status);
1342: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1343: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1344: g_module || l_api_name,
1345: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1346: END IF;
1347: -------------------------------------------------------

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

1352: END IF;
1353: --------------------------------------------------------
1354: l_approver_record2.approval_status := ame_util.noResponseStatus;
1355:
1356: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1357: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1358: g_module || l_api_name,
1359: 'Calling ame_api6.updateApprovalStatus');
1360: END IF;

Line 1357: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1353: --------------------------------------------------------
1354: l_approver_record2.approval_status := ame_util.noResponseStatus;
1355:
1356: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1357: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1358: g_module || l_api_name,
1359: 'Calling ame_api6.updateApprovalStatus');
1360: END IF;
1361: ame_api6.updateApprovalStatus(

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

1364: approverIn => l_approver_record2,
1365: transactionTypeIn => G_TRANSACTION_TYPE,
1366: notificationIn => l_notification_record);
1367:
1368: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1370: g_module || l_api_name,
1371: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');
1372: END IF;

Line 1369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1365: transactionTypeIn => G_TRANSACTION_TYPE,
1366: notificationIn => l_notification_record);
1367:
1368: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1370: g_module || l_api_name,
1371: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');
1372: END IF;
1373: resultout := 'COMPLETE:';

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

1376: END IF; -- (funcmode = 'TIMEOUT')
1377:
1378: exception
1379: when others then
1380: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1382: g_module || l_api_name,
1383: '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);
1384: END IF;

Line 1381: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1377:
1378: exception
1379: when others then
1380: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1382: g_module || l_api_name,
1383: '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);
1384: END IF;
1385: --close cursors

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

1437: BEGIN
1438:
1439: l_api_name := 'approve_contract';
1440:
1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1443: 'Entered OKC_REP_WF_PVT.approve_contract');
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1445: 'Item Type is: ' || itemtype);

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

1438:
1439: l_api_name := 'approve_contract';
1440:
1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1443: 'Entered OKC_REP_WF_PVT.approve_contract');
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1445: 'Item Type is: ' || itemtype);
1446: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1440:
1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1443: 'Entered OKC_REP_WF_PVT.approve_contract');
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1445: 'Item Type is: ' || itemtype);
1446: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1447: 'Item Key is: ' || itemkey);
1448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1442: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1443: 'Entered OKC_REP_WF_PVT.approve_contract');
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1445: 'Item Type is: ' || itemtype);
1446: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1447: 'Item Key is: ' || itemkey);
1448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1449: 'actid is: ' || to_char(actid));
1450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1445: 'Item Type is: ' || itemtype);
1446: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1447: 'Item Key is: ' || itemkey);
1448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1449: 'actid is: ' || to_char(actid));
1450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1451: 'Function mode is: ' || funcmode);
1452: END IF;

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

1446: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1447: 'Item Key is: ' || itemkey);
1448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1449: 'actid is: ' || to_char(actid));
1450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1451: 'Function mode is: ' || funcmode);
1452: END IF;
1453: IF (funcmode = 'RUN') THEN
1454: l_contract_id := wf_engine.GetItemAttrNumber(

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

1458: l_contract_version := wf_engine.GetItemAttrNumber(
1459: itemtype => itemtype,
1460: itemkey => itemkey,
1461: aname => 'CONTRACT_VERSION');
1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1464: g_module || l_api_name,
1465: 'Contract Id is: ' || to_char(l_contract_id));
1466: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1459: itemtype => itemtype,
1460: itemkey => itemkey,
1461: aname => 'CONTRACT_VERSION');
1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1464: g_module || l_api_name,
1465: 'Contract Id is: ' || to_char(l_contract_id));
1466: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1467: g_module || l_api_name,

Line 1466: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1464: g_module || l_api_name,
1465: 'Contract Id is: ' || to_char(l_contract_id));
1466: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1467: g_module || l_api_name,
1468: 'Contract Version is: ' || to_char(l_contract_version));
1469: END IF;
1470: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1466: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1467: g_module || l_api_name,
1468: 'Contract Version is: ' || to_char(l_contract_version));
1469: END IF;
1470: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1472: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
1473: END IF;
1474: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.

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

1467: g_module || l_api_name,
1468: 'Contract Version is: ' || to_char(l_contract_version));
1469: END IF;
1470: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1472: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
1473: END IF;
1474: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
1475: OKC_REP_UTIL_PVT.change_contract_status(

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

1482: p_note => NULL,
1483: x_msg_data => l_msg_data,
1484: x_msg_count => l_msg_count,
1485: x_return_status => l_return_status);
1486: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1487: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1488: g_module || l_api_name,
1489: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1490: END IF;

Line 1487: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1483: x_msg_data => l_msg_data,
1484: x_msg_count => l_msg_count,
1485: x_return_status => l_return_status);
1486: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1487: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1488: g_module || l_api_name,
1489: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1490: END IF;
1491: -----------------------------------------------------

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

1495: RAISE OKC_API.G_EXCEPTION_ERROR;
1496: END IF;
1497: --------------------------------------------------------
1498: resultout := 'COMPLETE:';
1499: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1501: g_module || l_api_name,
1502: 'Leaving OKC_REP_WF_PVT.approve_contract');
1503: END IF;

Line 1500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1496: END IF;
1497: --------------------------------------------------------
1498: resultout := 'COMPLETE:';
1499: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1501: g_module || l_api_name,
1502: 'Leaving OKC_REP_WF_PVT.approve_contract');
1503: END IF;
1504: RETURN;

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

1505: END IF; -- (funcmode = 'RUN')
1506:
1507: EXCEPTION
1508: WHEN others THEN
1509: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1511: g_module || l_api_name,
1512: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
1513: END IF;

Line 1510: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1506:
1507: EXCEPTION
1508: WHEN others THEN
1509: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1511: g_module || l_api_name,
1512: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
1513: END IF;
1514: wf_core.context('OKC_REP_WF_PVT',

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

1558: BEGIN
1559:
1560: l_api_name := 'reject_contract';
1561:
1562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1564: 'Entered OKC_REP_WF_PVT.reject_contract');
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'Item Type is: ' || itemtype);

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

1559:
1560: l_api_name := 'reject_contract';
1561:
1562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1564: 'Entered OKC_REP_WF_PVT.reject_contract');
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'Item Type is: ' || itemtype);
1567: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1561:
1562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1564: 'Entered OKC_REP_WF_PVT.reject_contract');
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'Item Type is: ' || itemtype);
1567: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1568: 'Item Key is: ' || itemkey);
1569: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1564: 'Entered OKC_REP_WF_PVT.reject_contract');
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'Item Type is: ' || itemtype);
1567: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1568: 'Item Key is: ' || itemkey);
1569: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1570: 'actid is: ' || to_char(actid));
1571: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'Item Type is: ' || itemtype);
1567: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1568: 'Item Key is: ' || itemkey);
1569: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1570: 'actid is: ' || to_char(actid));
1571: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1572: 'Function mode is: ' || funcmode);
1573: END IF;

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

1567: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1568: 'Item Key is: ' || itemkey);
1569: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1570: 'actid is: ' || to_char(actid));
1571: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1572: 'Function mode is: ' || funcmode);
1573: END IF;
1574: if (funcmode = 'RUN') then
1575: l_contract_id := wf_engine.GetItemAttrNumber(

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

1579: l_contract_version := wf_engine.GetItemAttrNumber(
1580: itemtype => itemtype,
1581: itemkey => itemkey,
1582: aname => 'CONTRACT_VERSION');
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: 'Contract Id is: ' || to_char(l_contract_id));
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1580: itemtype => itemtype,
1581: itemkey => itemkey,
1582: aname => 'CONTRACT_VERSION');
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: 'Contract Id is: ' || to_char(l_contract_id));
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1588: g_module || l_api_name,

Line 1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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: 'Contract Id is: ' || to_char(l_contract_id));
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1588: g_module || l_api_name,
1589: 'Contract Version is: ' || to_char(l_contract_version));
1590: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1591: 'Calling OKC_REP_UTIL_PVT.change_contract_status');

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

1586: 'Contract Id is: ' || to_char(l_contract_id));
1587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1588: g_module || l_api_name,
1589: 'Contract Version is: ' || to_char(l_contract_version));
1590: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1591: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
1592: END IF;
1593:
1594: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.

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

1602: p_note => NULL,
1603: x_msg_data => l_msg_data,
1604: x_msg_count => l_msg_count,
1605: x_return_status => l_return_status);
1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1608: g_module || l_api_name,
1609: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1610: END IF;

Line 1607: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1603: x_msg_data => l_msg_data,
1604: x_msg_count => l_msg_count,
1605: x_return_status => l_return_status);
1606: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1608: g_module || l_api_name,
1609: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1610: END IF;
1611: -----------------------------------------------------

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

1616: END IF;
1617: --------------------------------------------------------
1618:
1619: resultout := 'COMPLETE:';
1620: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1621: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1622: g_module || l_api_name,
1623: 'Leaving OKC_REP_WF_PVT.reject_contract');
1624: END IF;

Line 1621: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1617: --------------------------------------------------------
1618:
1619: resultout := 'COMPLETE:';
1620: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1621: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1622: g_module || l_api_name,
1623: 'Leaving OKC_REP_WF_PVT.reject_contract');
1624: END IF;
1625: RETURN;

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

1625: RETURN;
1626: END IF; -- (funcmode = 'RUN')
1627: EXCEPTION
1628: WHEN others THEN
1629: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1631: g_module || l_api_name,
1632: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
1633: END IF;

Line 1630: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1626: END IF; -- (funcmode = 'RUN')
1627: EXCEPTION
1628: WHEN others THEN
1629: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1631: g_module || l_api_name,
1632: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
1633: END IF;
1634: wf_core.context('OKC_REP_WF_PVT',

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

1680: BEGIN
1681:
1682: l_api_name := 'is_contract_approved';
1683:
1684: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1685: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1686: 'Entered OKC_REP_WF_PVT.is_contract_approved');
1687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1688: 'Item Type is: ' || itemtype);

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

1681:
1682: l_api_name := 'is_contract_approved';
1683:
1684: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1685: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1686: 'Entered OKC_REP_WF_PVT.is_contract_approved');
1687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1688: 'Item Type is: ' || itemtype);
1689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1683:
1684: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1685: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1686: 'Entered OKC_REP_WF_PVT.is_contract_approved');
1687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1688: 'Item Type is: ' || itemtype);
1689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1690: 'Item Key is: ' || itemkey);
1691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1685: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1686: 'Entered OKC_REP_WF_PVT.is_contract_approved');
1687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1688: 'Item Type is: ' || itemtype);
1689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1690: 'Item Key is: ' || itemkey);
1691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1692: 'actid is: ' || to_char(actid));
1693: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1688: 'Item Type is: ' || itemtype);
1689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1690: 'Item Key is: ' || itemkey);
1691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1692: 'actid is: ' || to_char(actid));
1693: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1694: 'Function mode is: ' || funcmode);
1695: END IF;

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

1689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1690: 'Item Key is: ' || itemkey);
1691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1692: 'actid is: ' || to_char(actid));
1693: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1694: 'Function mode is: ' || funcmode);
1695: END IF;
1696: IF (funcmode = 'RUN') then
1697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1693: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1694: 'Function mode is: ' || funcmode);
1695: END IF;
1696: IF (funcmode = 'RUN') then
1697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1699: g_module || l_api_name,
1700: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1701: END IF;

Line 1698: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1694: 'Function mode is: ' || funcmode);
1695: END IF;
1696: IF (funcmode = 'RUN') then
1697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1699: g_module || l_api_name,
1700: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1701: END IF;
1702: l_contract_id := wf_engine.GetItemAttrNumber(

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

1702: l_contract_id := wf_engine.GetItemAttrNumber(
1703: itemtype => itemtype,
1704: itemkey => itemkey,
1705: aname => 'CONTRACT_ID');
1706: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1707: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1708: g_module || l_api_name,
1709: 'Contract Id is: ' || to_char(l_contract_id));
1710: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1707: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1703: itemtype => itemtype,
1704: itemkey => itemkey,
1705: aname => 'CONTRACT_ID');
1706: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1707: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1708: g_module || l_api_name,
1709: 'Contract Id is: ' || to_char(l_contract_id));
1710: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1711: g_module || l_api_name,

Line 1710: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1706: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1707: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1708: g_module || l_api_name,
1709: 'Contract Id is: ' || to_char(l_contract_id));
1710: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1711: g_module || l_api_name,
1712: 'Calling ame_api.getNextApprover to get the approver id');
1713: END IF;
1714: ame_api2.getNextApprovers1(

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

1722: itemClassesOut => l_item_classes,
1723: itemIdsOut => l_item_ids,
1724: itemSourcesOut => l_item_sources);
1725:
1726: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1727: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1728: g_module || l_api_name,
1729: 'Number of approvers: ' || to_char(l_next_approvers.count));
1730: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1727: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1723: itemIdsOut => l_item_ids,
1724: itemSourcesOut => l_item_sources);
1725:
1726: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1727: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1728: g_module || l_api_name,
1729: 'Number of approvers: ' || to_char(l_next_approvers.count));
1730: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1731: g_module || l_api_name,

Line 1730: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1726: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1727: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1728: g_module || l_api_name,
1729: 'Number of approvers: ' || to_char(l_next_approvers.count));
1730: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1731: g_module || l_api_name,
1732: 'l_process_complete_yn is is_contract_approved: ' || l_process_complete_yn);
1733: END IF;
1734: IF (l_process_complete_yn = ame_util.booleanTrue) THEN

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

1731: g_module || l_api_name,
1732: 'l_process_complete_yn is is_contract_approved: ' || l_process_complete_yn);
1733: END IF;
1734: IF (l_process_complete_yn = ame_util.booleanTrue) THEN
1735: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1737: 'The contract is approved');
1738: END IF;
1739: resultout := 'COMPLETE:T';

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

1732: 'l_process_complete_yn is is_contract_approved: ' || l_process_complete_yn);
1733: END IF;
1734: IF (l_process_complete_yn = ame_util.booleanTrue) THEN
1735: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1737: 'The contract is approved');
1738: END IF;
1739: resultout := 'COMPLETE:T';
1740: ELSE

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

1737: 'The contract is approved');
1738: END IF;
1739: resultout := 'COMPLETE:T';
1740: ELSE
1741: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1742: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1743: 'The contract is rejected');
1744: END IF;
1745: resultout := 'COMPLETE:F';

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

1738: END IF;
1739: resultout := 'COMPLETE:T';
1740: ELSE
1741: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1742: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1743: 'The contract is rejected');
1744: END IF;
1745: resultout := 'COMPLETE:F';
1746: END IF;

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

1743: 'The contract is rejected');
1744: END IF;
1745: resultout := 'COMPLETE:F';
1746: END IF;
1747: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1748: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1749: g_module || l_api_name,
1750: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=RUN');
1751: END IF;

Line 1748: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1744: END IF;
1745: resultout := 'COMPLETE:F';
1746: END IF;
1747: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1748: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1749: g_module || l_api_name,
1750: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=RUN');
1751: END IF;
1752: RETURN;

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

1753: END IF; -- (funcmode = 'RUN')
1754:
1755: IF (funcmode = 'CANCEL') THEN
1756: resultout := 'COMPLETE:';
1757: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1758: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1759: g_module || l_api_name,
1760: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=CANCEL');
1761: END IF;

Line 1758: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1754:
1755: IF (funcmode = 'CANCEL') THEN
1756: resultout := 'COMPLETE:';
1757: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1758: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1759: g_module || l_api_name,
1760: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=CANCEL');
1761: END IF;
1762: RETURN;

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

1763: END IF; -- (funcmode = 'CANCEL')
1764:
1765: IF (funcmode = 'TIMEOUT') THEN
1766: resultout := 'COMPLETE:';
1767: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1769: g_module || l_api_name,
1770: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=TIMEOUT');
1771: END IF;

Line 1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1764:
1765: IF (funcmode = 'TIMEOUT') THEN
1766: resultout := 'COMPLETE:';
1767: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1769: g_module || l_api_name,
1770: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=TIMEOUT');
1771: END IF;
1772: RETURN;

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

1773: END IF; -- (funcmode = 'TIMEOUT')
1774:
1775: EXCEPTION
1776: WHEN others THEN
1777: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1779: g_module || l_api_name,
1780: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
1781: END IF;

Line 1778: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1774:
1775: EXCEPTION
1776: WHEN others THEN
1777: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1779: g_module || l_api_name,
1780: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
1781: END IF;
1782: wf_core.context('OKC_REP_WF_PVT',

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

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

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

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

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

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

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

1843: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1844: 'Entered OKC_REP_WF_PVT.is_contract_approved');
1845: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1846: 'Item Type is: ' || itemtype);
1847: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1848: 'Item Key is: ' || itemkey);
1849: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1850: 'actid is: ' || to_char(actid));
1851: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

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

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

1847: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1848: 'Item Key is: ' || itemkey);
1849: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1850: 'actid is: ' || to_char(actid));
1851: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1852: 'Function mode is: ' || funcmode);
1853: END IF;
1854: IF (funcmode = 'RUN') then
1855: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1851: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1852: 'Function mode is: ' || funcmode);
1853: END IF;
1854: IF (funcmode = 'RUN') then
1855: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1857: g_module || l_api_name,
1858: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1859: END IF;

Line 1856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1852: 'Function mode is: ' || funcmode);
1853: END IF;
1854: IF (funcmode = 'RUN') then
1855: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1857: g_module || l_api_name,
1858: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1859: END IF;
1860: l_contract_id := wf_engine.GetItemAttrNumber(

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

1860: l_contract_id := wf_engine.GetItemAttrNumber(
1861: itemtype => itemtype,
1862: itemkey => itemkey,
1863: aname => 'CONTRACT_ID');
1864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1866: g_module || l_api_name,
1867: 'Contract Id is: ' || to_char(l_contract_id));
1868: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1861: itemtype => itemtype,
1862: itemkey => itemkey,
1863: aname => 'CONTRACT_ID');
1864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1866: g_module || l_api_name,
1867: 'Contract Id is: ' || to_char(l_contract_id));
1868: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1869: g_module || l_api_name,

Line 1868: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1866: g_module || l_api_name,
1867: 'Contract Id is: ' || to_char(l_contract_id));
1868: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1869: g_module || l_api_name,
1870: 'Calling ame_api.getNextApprover to get the approver id');
1871: END IF;
1872: -- Using this API to determine if process is complete. Complete process from AME implies

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

1883: itemClassesOut => l_item_classes,
1884: itemIdsOut => l_item_ids,
1885: itemSourcesOut => l_item_sources);
1886:
1887: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1889: g_module || l_api_name,
1890: 'Number of approvers: ' || to_char(l_next_approvers.count));
1891: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1884: itemIdsOut => l_item_ids,
1885: itemSourcesOut => l_item_sources);
1886:
1887: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1889: g_module || l_api_name,
1890: 'Number of approvers: ' || to_char(l_next_approvers.count));
1891: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1892: g_module || l_api_name,

Line 1891: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1887: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1889: g_module || l_api_name,
1890: 'Number of approvers: ' || to_char(l_next_approvers.count));
1891: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1892: g_module || l_api_name,
1893: 'l_process_complete_yn is is_contract_approved_detailed: ' || l_process_complete_yn);
1894: END IF;
1895: IF ((l_process_complete_yn = 'Y') OR

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

1893: 'l_process_complete_yn is is_contract_approved_detailed: ' || l_process_complete_yn);
1894: END IF;
1895: IF ((l_process_complete_yn = 'Y') OR
1896: (l_process_complete_yn = 'X')) THEN
1897: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1899: 'The contract is approved');
1900: END IF;
1901: resultout := 'COMPLETE:T';

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

1894: END IF;
1895: IF ((l_process_complete_yn = 'Y') OR
1896: (l_process_complete_yn = 'X')) THEN
1897: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1898: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1899: 'The contract is approved');
1900: END IF;
1901: resultout := 'COMPLETE:T';
1902: ELSE

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

1899: 'The contract is approved');
1900: END IF;
1901: resultout := 'COMPLETE:T';
1902: ELSE
1903: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1904: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1905: 'The contract is rejected');
1906: END IF;
1907: resultout := 'COMPLETE:F';

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

1900: END IF;
1901: resultout := 'COMPLETE:T';
1902: ELSE
1903: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1904: fnd_log.string(FND_LOG.LEVEL_STATEMENT, g_module || l_api_name,
1905: 'The contract is rejected');
1906: END IF;
1907: resultout := 'COMPLETE:F';
1908: END IF;

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

1908: END IF;
1909: -- We need to loop through the pending notif. process and abort those
1910: FOR wf_process_rec IN wf_process_csr
1911: LOOP
1912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1913: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
1914: 'Calling WF_ENGINE.AbortProcess');
1915: END IF;
1916:

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

1909: -- We need to loop through the pending notif. process and abort those
1910: FOR wf_process_rec IN wf_process_csr
1911: LOOP
1912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1913: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
1914: 'Calling WF_ENGINE.AbortProcess');
1915: END IF;
1916:
1917: WF_ENGINE.AbortProcess(

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

1921: verify_lock => false,
1922: cascade => true);
1923: END LOOP;
1924:
1925: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1926: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1927: g_module || l_api_name,
1928: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=RUN');
1929: END IF;

Line 1926: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1922: cascade => true);
1923: END LOOP;
1924:
1925: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1926: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1927: g_module || l_api_name,
1928: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=RUN');
1929: END IF;
1930: RETURN;

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

1931: END IF; -- (funcmode = 'RUN')
1932:
1933: IF (funcmode = 'CANCEL') THEN
1934: resultout := 'COMPLETE:';
1935: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1936: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1937: g_module || l_api_name,
1938: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=CANCEL');
1939: END IF;

Line 1936: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1932:
1933: IF (funcmode = 'CANCEL') THEN
1934: resultout := 'COMPLETE:';
1935: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1936: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1937: g_module || l_api_name,
1938: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=CANCEL');
1939: END IF;
1940: RETURN;

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

1941: END IF; -- (funcmode = 'CANCEL')
1942:
1943: IF (funcmode = 'TIMEOUT') THEN
1944: resultout := 'COMPLETE:';
1945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1947: g_module || l_api_name,
1948: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=TIMEOUT');
1949: END IF;

Line 1946: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1942:
1943: IF (funcmode = 'TIMEOUT') THEN
1944: resultout := 'COMPLETE:';
1945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1947: g_module || l_api_name,
1948: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=TIMEOUT');
1949: END IF;
1950: RETURN;

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

1951: END IF; -- (funcmode = 'TIMEOUT')
1952:
1953: EXCEPTION
1954: WHEN others THEN
1955: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1956: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1957: g_module || l_api_name,
1958: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
1959: END IF;

Line 1956: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1952:
1953: EXCEPTION
1954: WHEN others THEN
1955: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1956: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1957: g_module || l_api_name,
1958: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
1959: END IF;
1960: wf_core.context('OKC_REP_WF_PVT',

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

2007: BEGIN
2008:
2009: l_api_name := 'complete_notification';
2010:
2011: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2013: 'Entered OKC_REP_WF_PVT.complete_notification');
2014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2015: 'Item Type is: ' || itemtype);

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

2008:
2009: l_api_name := 'complete_notification';
2010:
2011: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2013: 'Entered OKC_REP_WF_PVT.complete_notification');
2014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2015: 'Item Type is: ' || itemtype);
2016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2010:
2011: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2013: 'Entered OKC_REP_WF_PVT.complete_notification');
2014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2015: 'Item Type is: ' || itemtype);
2016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2017: 'Item Key is: ' || itemkey);
2018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2012: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2013: 'Entered OKC_REP_WF_PVT.complete_notification');
2014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2015: 'Item Type is: ' || itemtype);
2016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2017: 'Item Key is: ' || itemkey);
2018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2019: 'actid is: ' || to_char(actid));
2020: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2015: 'Item Type is: ' || itemtype);
2016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2017: 'Item Key is: ' || itemkey);
2018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2019: 'actid is: ' || to_char(actid));
2020: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2021: 'Function mode is: ' || funcmode);
2022: END IF;

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

2016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2017: 'Item Key is: ' || itemkey);
2018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2019: 'actid is: ' || to_char(actid));
2020: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2021: 'Function mode is: ' || funcmode);
2022: END IF;
2023: if (funcmode = 'RUN') then
2024: l_master_key := wf_engine.GetItemAttrText(

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

2024: l_master_key := wf_engine.GetItemAttrText(
2025: itemtype => itemtype,
2026: itemkey => itemkey,
2027: aname => 'MASTER_ITEM_KEY');
2028: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2030: g_module || l_api_name,
2031: 'Master Item Key is: ' || l_master_key);
2032: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 2029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2025: itemtype => itemtype,
2026: itemkey => itemkey,
2027: aname => 'MASTER_ITEM_KEY');
2028: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2030: g_module || l_api_name,
2031: 'Master Item Key is: ' || l_master_key);
2032: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2033: 'Completing master process waiting activity');

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

2028: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2029: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2030: g_module || l_api_name,
2031: 'Master Item Key is: ' || l_master_key);
2032: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2033: 'Completing master process waiting activity');
2034: END IF;
2035: wf_engine.CompleteActivity(
2036: itemtype => itemtype,

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

2038: activity => 'WAIT_FOR_APPROVER_RESPONSE',
2039: result => null);
2040:
2041: resultout := 'COMPLETE:';
2042: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2043: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2044: g_module || l_api_name,
2045: 'Leaving OKC_REP_WF_PVT.complete_notification');
2046: END IF;

Line 2043: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

2039: result => null);
2040:
2041: resultout := 'COMPLETE:';
2042: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2043: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2044: g_module || l_api_name,
2045: 'Leaving OKC_REP_WF_PVT.complete_notification');
2046: END IF;
2047: RETURN;

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

2047: RETURN;
2048: END IF; -- (funcmode = 'RUN')
2049: EXCEPTION
2050: WHEN others THEN
2051: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2053: g_module || l_api_name,
2054: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2055: END IF;

Line 2052: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2048: END IF; -- (funcmode = 'RUN')
2049: EXCEPTION
2050: WHEN others THEN
2051: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2053: g_module || l_api_name,
2054: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2055: END IF;
2056: wf_core.context('OKC_REP_WF_PVT',

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

2103: BEGIN
2104:
2105: l_api_name := 'con_has_terms';
2106:
2107: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2109: 'Entered OKC_REP_WF_PVT.complete_notification');
2110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2111: 'Item Type is: ' || itemtype);

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

2104:
2105: l_api_name := 'con_has_terms';
2106:
2107: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2109: 'Entered OKC_REP_WF_PVT.complete_notification');
2110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2111: 'Item Type is: ' || itemtype);
2112: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2106:
2107: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2109: 'Entered OKC_REP_WF_PVT.complete_notification');
2110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2111: 'Item Type is: ' || itemtype);
2112: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2113: 'Item Key is: ' || itemkey);
2114: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2108: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2109: 'Entered OKC_REP_WF_PVT.complete_notification');
2110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2111: 'Item Type is: ' || itemtype);
2112: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2113: 'Item Key is: ' || itemkey);
2114: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2115: 'actid is: ' || to_char(actid));
2116: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2111: 'Item Type is: ' || itemtype);
2112: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2113: 'Item Key is: ' || itemkey);
2114: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2115: 'actid is: ' || to_char(actid));
2116: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2117: 'Function mode is: ' || funcmode);
2118: END IF;

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

2112: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2113: 'Item Key is: ' || itemkey);
2114: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2115: 'actid is: ' || to_char(actid));
2116: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2117: 'Function mode is: ' || funcmode);
2118: END IF;
2119:
2120: IF (funcmode = 'RUN') THEN

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

2138: END IF; -- RUN
2139:
2140: EXCEPTION
2141: WHEN others THEN
2142: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2143: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2144: g_module || l_api_name,
2145: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2146: END IF;

Line 2143: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2139:
2140: EXCEPTION
2141: WHEN others THEN
2142: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2143: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2144: g_module || l_api_name,
2145: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2146: END IF;
2147: wf_core.context('OKC_REP_WF_PVT',

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

2201: BEGIN
2202:
2203: l_api_name := 'con_attach_generated_yn';
2204:
2205: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2206: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2207: 'Entered OKC_REP_WF_PVT.complete_notification');
2208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2209: 'Item Type is: ' || itemtype);

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

2202:
2203: l_api_name := 'con_attach_generated_yn';
2204:
2205: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2206: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2207: 'Entered OKC_REP_WF_PVT.complete_notification');
2208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2209: 'Item Type is: ' || itemtype);
2210: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2204:
2205: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2206: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2207: 'Entered OKC_REP_WF_PVT.complete_notification');
2208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2209: 'Item Type is: ' || itemtype);
2210: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2211: 'Item Key is: ' || itemkey);
2212: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2206: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2207: 'Entered OKC_REP_WF_PVT.complete_notification');
2208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2209: 'Item Type is: ' || itemtype);
2210: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2211: 'Item Key is: ' || itemkey);
2212: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2213: 'actid is: ' || to_char(actid));
2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

2208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2209: 'Item Type is: ' || itemtype);
2210: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2211: 'Item Key is: ' || itemkey);
2212: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2213: 'actid is: ' || to_char(actid));
2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2215: 'Function mode is: ' || funcmode);
2216: END IF;

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

2210: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2211: 'Item Key is: ' || itemkey);
2212: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2213: 'actid is: ' || to_char(actid));
2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2215: 'Function mode is: ' || funcmode);
2216: END IF;
2217:
2218: IF (funcmode = 'RUN') THEN

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

2230: itemtype => itemtype,
2231: itemkey => itemkey,
2232: aname => 'CONC_REQUEST_ID' );
2233:
2234: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2235: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1810: Entering con_attach_generated_yn');
2236: END IF;
2237:
2238: OPEN contract_attachment_exists(l_contract_id, l_contract_type, l_con_req_id) ;

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

2231: itemkey => itemkey,
2232: aname => 'CONC_REQUEST_ID' );
2233:
2234: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2235: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1810: Entering con_attach_generated_yn');
2236: END IF;
2237:
2238: OPEN contract_attachment_exists(l_contract_id, l_contract_type, l_con_req_id) ;
2239: FETCH contract_attachment_exists into l_value;

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

2247:
2248: END IF; -- RUN
2249: EXCEPTION
2250: WHEN others THEN
2251: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2253: g_module || l_api_name,
2254: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2255: END IF;

Line 2252: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2248: END IF; -- RUN
2249: EXCEPTION
2250: WHEN others THEN
2251: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2253: g_module || l_api_name,
2254: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2255: END IF;
2256: wf_core.context('OKC_REP_WF_PVT',