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_CONTRACT_APPROVAL_PVT dependencies on FND_LOG

Line 61: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

57: l_wf_item_key VARCHAR2(240);
58:
59: BEGIN
60:
61: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , 'okc.plsql.'||l_api_name,
63: 'Entered '||G_PKG_NAME ||'.'||l_api_name||' p_contract_id='||p_contract_id
64: ||' p_called_from='||p_called_from);
65: END IF;

Line 62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , 'okc.plsql.'||l_api_name,

58:
59: BEGIN
60:
61: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , 'okc.plsql.'||l_api_name,
63: 'Entered '||G_PKG_NAME ||'.'||l_api_name||' p_contract_id='||p_contract_id
64: ||' p_called_from='||p_called_from);
65: END IF;
66:

Line 90: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

86: END IF;
87:
88: IF l_wf_item_key IS NOT NULL THEN
89: IF NVL(p_called_from,'!') = 'APPROVE' THEN
90: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
91: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
92: ' OKS_WF_K_PROCESS_PVT.complete_activity with APPROVED result');
93: END IF;
94: OKS_WF_K_PROCESS_PVT.complete_activity

Line 91: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

87:
88: IF l_wf_item_key IS NOT NULL THEN
89: IF NVL(p_called_from,'!') = 'APPROVE' THEN
90: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
91: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
92: ' OKS_WF_K_PROCESS_PVT.complete_activity with APPROVED result');
93: END IF;
94: OKS_WF_K_PROCESS_PVT.complete_activity
95: (

Line 107: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

103: x_return_status => x_return_status,
104: x_msg_data => x_msg_data,
105: x_msg_count => x_msg_count
106: );
107: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
108: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
109: ' Return status='||x_return_status||' x_msg_count='||x_msg_count);
110: END IF;
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 108: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

104: x_msg_data => x_msg_data,
105: x_msg_count => x_msg_count
106: );
107: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
108: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
109: ' Return status='||x_return_status||' x_msg_count='||x_msg_count);
110: END IF;
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 118: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

114: RAISE OKC_API.G_EXCEPTION_ERROR;
115: END IF;
116:
117: ELSIF NVL(p_called_from,'!') = 'STOP' THEN
118: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
120: ' OKS_WF_K_PROCESS_PVT.complete_activity with STOPPED result');
121: END IF;
122: OKS_WF_K_PROCESS_PVT.complete_activity

Line 119: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

115: END IF;
116:
117: ELSIF NVL(p_called_from,'!') = 'STOP' THEN
118: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
119: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
120: ' OKS_WF_K_PROCESS_PVT.complete_activity with STOPPED result');
121: END IF;
122: OKS_WF_K_PROCESS_PVT.complete_activity
123: (

Line 135: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

131: x_return_status => x_return_status,
132: x_msg_data => x_msg_data,
133: x_msg_count => x_msg_count
134: );
135: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
136: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
137: ' Return status='||x_return_status||' x_msg_count='||x_msg_count);
138: END IF;
139: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 136: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

132: x_msg_data => x_msg_data,
133: x_msg_count => x_msg_count
134: );
135: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
136: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
137: ' Return status='||x_return_status||' x_msg_count='||x_msg_count);
138: END IF;
139: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 159: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

155: WHERE chr_id = p_contract_id;
156: END IF;
157: */
158: ELSIF NVL(p_called_from,'!') = 'REJECTED' THEN
159: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
161: ' OKS_WF_K_PROCESS_PVT.complete_activity with REJECTED result');
162: END IF;
163: OKS_WF_K_PROCESS_PVT.complete_activity

Line 160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

156: END IF;
157: */
158: ELSIF NVL(p_called_from,'!') = 'REJECTED' THEN
159: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
161: ' OKS_WF_K_PROCESS_PVT.complete_activity with REJECTED result');
162: END IF;
163: OKS_WF_K_PROCESS_PVT.complete_activity
164: (

Line 176: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

172: x_return_status => x_return_status,
173: x_msg_data => x_msg_data,
174: x_msg_count => x_msg_count
175: );
176: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
177: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
178: ' Return status='||x_return_status||' x_msg_count='||x_msg_count);
179: END IF;
180: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 177: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

173: x_msg_data => x_msg_data,
174: x_msg_count => x_msg_count
175: );
176: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
177: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
178: ' Return status='||x_return_status||' x_msg_count='||x_msg_count);
179: END IF;
180: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 205: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

201: -- contracts that are in the approval process (no prior OKS Contract
202: -- Process wf existing) and being either approved or rejected by approver.
203: ELSE
204: IF NVL(p_called_from,'!') = 'APPROVE' THEN
205: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
206: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
207: 'Updating Negotiation status to Complete');
208: END IF;
209: -- We just want to update the negotiation status; NO interaction

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

202: -- Process wf existing) and being either approved or rejected by approver.
203: ELSE
204: IF NVL(p_called_from,'!') = 'APPROVE' THEN
205: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
206: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
207: 'Updating Negotiation status to Complete');
208: END IF;
209: -- We just want to update the negotiation status; NO interaction
210: -- or email or notification is sent for these scenarios

Line 222: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

218: ELSIF NVL(p_called_from,'!') = 'REJECTED' THEN
219: -- Launch process workflow for existing service contracts created prior to r12
220: -- as they would not have process workflow associated as they had been in the
221: -- Approval process. We'll have to place it in salesrep queue in Rejected status
222: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
223: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
224: 'Preparing to launch workflow ...');
225: END IF;
226: l_wf_attributes.CONTRACT_ID := p_contract_id;

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

219: -- Launch process workflow for existing service contracts created prior to r12
220: -- as they would not have process workflow associated as they had been in the
221: -- Approval process. We'll have to place it in salesrep queue in Rejected status
222: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
223: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
224: 'Preparing to launch workflow ...');
225: END IF;
226: l_wf_attributes.CONTRACT_ID := p_contract_id;
227: l_wf_attributes.NEGOTIATION_STATUS := 'REJECTED';

Line 231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

227: l_wf_attributes.NEGOTIATION_STATUS := 'REJECTED';
228: l_wf_attributes.ITEM_KEY := p_contract_id||to_char(sysdate,'YYYYMMDDHH24MISS');
229: l_wf_attributes.IRR_FLAG := 'Y';
230: l_wf_attributes.PROCESS_TYPE := 'MANUAL';
231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
233: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||
234: p_contract_id);
235: END IF;

Line 232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

228: l_wf_attributes.ITEM_KEY := p_contract_id||to_char(sysdate,'YYYYMMDDHH24MISS');
229: l_wf_attributes.IRR_FLAG := 'Y';
230: l_wf_attributes.PROCESS_TYPE := 'MANUAL';
231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
233: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||
234: p_contract_id);
235: END IF;
236: OKS_WF_K_PROCESS_PVT.launch_k_process_wf

Line 245: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

241: x_return_status => x_return_status,
242: x_msg_count => x_msg_count,
243: x_msg_data => x_msg_data
244: ) ;
245: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
246: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
247: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf x_return_status=>'||
248: x_return_status);
249: END IF;

Line 246: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

242: x_msg_count => x_msg_count,
243: x_msg_data => x_msg_data
244: ) ;
245: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
246: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
247: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf x_return_status=>'||
248: x_return_status);
249: END IF;
250: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 263: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

259: last_update_date = SYSDATE,
260: last_update_login = FND_GLOBAL.LOGIN_ID,
261: Last_updated_by = FND_GLOBAL.USER_ID
262: WHERE chr_id = l_wf_attributes.contract_id;
263: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE||l_api_name,
265: ' Updated negotiation status to REJECTED');
266: END IF;
267: END IF;

Line 264: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE||l_api_name,

260: last_update_login = FND_GLOBAL.LOGIN_ID,
261: Last_updated_by = FND_GLOBAL.USER_ID
262: WHERE chr_id = l_wf_attributes.contract_id;
263: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
264: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE||l_api_name,
265: ' Updated negotiation status to REJECTED');
266: END IF;
267: END IF;
268: END IF;

Line 274: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

270: COMMIT;
271:
272: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
273:
274: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okc.plsql.'||l_api_name,
276: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
277: END IF;
278:

Line 275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okc.plsql.'||l_api_name,

271:
272: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
273:
274: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okc.plsql.'||l_api_name,
276: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
277: END IF;
278:
279: EXCEPTION

Line 411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

407: from OKC_PROCESS_DEF_PARAMETERS_V
408: where PDF_ID = p_process_id;
409: --
410: begin
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
413: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
414: END IF;
415: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

408: where PDF_ID = p_process_id;
409: --
410: begin
411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
413: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
414: END IF;
415: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 415: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

411: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
413: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
414: END IF;
415: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
417: 'p_contract_id=>'||p_contract_id||' p_process_id=>'||
418: p_process_id||' p_do_commit=>'|| p_do_commit);
419: END IF;

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

412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
413: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
414: END IF;
415: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
416: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
417: 'p_contract_id=>'||p_contract_id||' p_process_id=>'||
418: p_process_id||' p_do_commit=>'|| p_do_commit);
419: END IF;
420: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

Line 432: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

428: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
429: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
430: RAISE OKC_API.G_EXCEPTION_ERROR;
431: END IF;
432: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
433: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
434: 'OKC_API.START_ACTIVITY return status '||l_return_status);
435: END IF;
436: --

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

429: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
430: RAISE OKC_API.G_EXCEPTION_ERROR;
431: END IF;
432: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
433: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
434: 'OKC_API.START_ACTIVITY return status '||l_return_status);
435: END IF;
436: --
437: -- Modified for Bug 2046890

Line 442: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

438: -- Below IF added because context does not set thru background processes
439: -- that's why need to bypass it
440: -- IF FND_GLOBAL.USER_ID <> -1 THEN
441: IF p_access_level = 'N' THEN
442: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
443: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
444: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
445: END IF;
446: if k_accesible( p_contract_id => p_contract_id,

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

439: -- that's why need to bypass it
440: -- IF FND_GLOBAL.USER_ID <> -1 THEN
441: IF p_access_level = 'N' THEN
442: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
443: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
444: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
445: END IF;
446: if k_accesible( p_contract_id => p_contract_id,
447: p_user_id => fnd_global.user_id,

Line 456: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

452: p_msg_name => G_NO_U_PRIVILEGE);
453: raise OKC_API.G_EXCEPTION_ERROR;
454: end if;
455: END IF;
456: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
458: 'Contract is accessible - get contract details');
459: END IF;
460: -- Modified for Bug 2046890

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

453: raise OKC_API.G_EXCEPTION_ERROR;
454: end if;
455: END IF;
456: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
457: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
458: 'Contract is accessible - get contract details');
459: END IF;
460: -- Modified for Bug 2046890
461: open k_header_csr;

Line 470: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

466: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
467: p_msg_name => G_K_WAS_APPROVED);
468: raise OKC_API.G_EXCEPTION_ERROR;
469: end if;
470: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
471: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
472: 'Got contract details L_STATUS_TYPE=>'||L_STATUS_TYPE);
473: END IF;
474: if (L_STATUS_TYPE <> 'ENTERED') then

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

467: p_msg_name => G_K_WAS_APPROVED);
468: raise OKC_API.G_EXCEPTION_ERROR;
469: end if;
470: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
471: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
472: 'Got contract details L_STATUS_TYPE=>'||L_STATUS_TYPE);
473: END IF;
474: if (L_STATUS_TYPE <> 'ENTERED') then
475: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 492: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

488: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
489: p_msg_name => G_PROCESS_NOTFOUND);
490: raise OKC_API.G_EXCEPTION_ERROR;
491: end if;
492: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
493: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
494: 'Got process def details L_WF_NAME=>'||L_WF_NAME||
495: ' L_WF_PROCESS_NAME=>'||L_WF_PROCESS_NAME||
496: ' L_USAGE=>'||L_USAGE);

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

489: p_msg_name => G_PROCESS_NOTFOUND);
490: raise OKC_API.G_EXCEPTION_ERROR;
491: end if;
492: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
493: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
494: 'Got process def details L_WF_NAME=>'||L_WF_NAME||
495: ' L_WF_PROCESS_NAME=>'||L_WF_PROCESS_NAME||
496: ' L_USAGE=>'||L_USAGE);
497: END IF;

Line 512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

508: L_KEY := L_CONTRACT_NUMBER||L_CONTRACT_NUMBER_MODIFIER;
509: open approval_active_csr;
510: fetch approval_active_csr into L_WF_NAME_ACTIVE;
511: close approval_active_csr;
512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
513: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
514: 'L_WF_NAME_ACTIVE=>'||L_WF_NAME_ACTIVE);
515: END IF;
516: if (L_WF_NAME_ACTIVE is not NULL) then

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

509: open approval_active_csr;
510: fetch approval_active_csr into L_WF_NAME_ACTIVE;
511: close approval_active_csr;
512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
513: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
514: 'L_WF_NAME_ACTIVE=>'||L_WF_NAME_ACTIVE);
515: END IF;
516: if (L_WF_NAME_ACTIVE is not NULL) then
517: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

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

526: L_Q:='?';
527: open for_purge_csr;
528: fetch for_purge_csr into L_Q;
529: close for_purge_csr;
530: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
531: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
532: 'L_Q=>'||L_Q);
533: END IF;
534: if (L_Q = '!') then

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

527: open for_purge_csr;
528: fetch for_purge_csr into L_Q;
529: close for_purge_csr;
530: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
531: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
532: 'L_Q=>'||L_Q);
533: END IF;
534: if (L_Q = '!') then
535: begin

Line 561: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

557: begin
558: open k_pid;
559: fetch k_pid into L1_CPSV_REC.id;
560: close k_pid;
561: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
562: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
563: ' L1_CPSV_REC.id=>'|| L1_CPSV_REC.id);
564: END IF;
565: exception

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

558: open k_pid;
559: fetch k_pid into L1_CPSV_REC.id;
560: close k_pid;
561: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
562: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
563: ' L1_CPSV_REC.id=>'|| L1_CPSV_REC.id);
564: END IF;
565: exception
566: when others then

Line 572: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

568: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
569: RAISE OKC_API.G_EXCEPTION_ERROR;
570: end;
571: L1_CPSV_REC.PROCESS_ID := L_KEY;
572: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
573: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
574: ' OKC_CONTRACT_PUB.update_contract_process L1_CPSV_REC.PROCESS_ID=>'||L1_CPSV_REC.PROCESS_ID);
575: END IF;
576: OKC_CONTRACT_PUB.update_contract_process(

Line 573: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',

569: RAISE OKC_API.G_EXCEPTION_ERROR;
570: end;
571: L1_CPSV_REC.PROCESS_ID := L_KEY;
572: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
573: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
574: ' OKC_CONTRACT_PUB.update_contract_process L1_CPSV_REC.PROCESS_ID=>'||L1_CPSV_REC.PROCESS_ID);
575: END IF;
576: OKC_CONTRACT_PUB.update_contract_process(
577: p_api_version => l_api_version,

Line 583: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

579: x_msg_count => l_msg_count,
580: x_msg_data => l_msg_data,
581: p_cpsv_rec => L1_CPSV_REC,
582: x_cpsv_rec => L2_CPSV_REC);
583: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
584: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.after',
585: ' OKC_CONTRACT_PUB.update_contract_process x_return_status=>'||l_return_status);
586: END IF;
587: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 584: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.after',

580: x_msg_data => l_msg_data,
581: p_cpsv_rec => L1_CPSV_REC,
582: x_cpsv_rec => L2_CPSV_REC);
583: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
584: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.after',
585: ' OKC_CONTRACT_PUB.update_contract_process x_return_status=>'||l_return_status);
586: END IF;
587: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
588: rollback to BECAUSE_OF_BUG_IN_lock;

Line 594: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

590: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
591: rollback to BECAUSE_OF_BUG_IN_lock;
592: RAISE OKC_API.G_EXCEPTION_ERROR;
593: END IF;
594: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
595: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
596: ' wf_engine.CreateProcess(ItemType=>'||L_WF_NAME||
597: ' ItemKey=>'||L_KEY||' process=>'||L_WF_PROCESS_NAME||')');
598: END IF;

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

591: rollback to BECAUSE_OF_BUG_IN_lock;
592: RAISE OKC_API.G_EXCEPTION_ERROR;
593: END IF;
594: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
595: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
596: ' wf_engine.CreateProcess(ItemType=>'||L_WF_NAME||
597: ' ItemKey=>'||L_KEY||' process=>'||L_WF_PROCESS_NAME||')');
598: END IF;
599: wf_engine.CreateProcess( ItemType => L_WF_NAME,

Line 605: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

601: process => L_WF_PROCESS_NAME);
602: wf_engine.SetItemUserKey (ItemType => L_WF_NAME,
603: ItemKey => L_KEY,
604: UserKey => L_KEY);
605: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
606: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
607: 'Setting wf item attributes');
608: END IF;
609: begin

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

602: wf_engine.SetItemUserKey (ItemType => L_WF_NAME,
603: ItemKey => L_KEY,
604: UserKey => L_KEY);
605: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
606: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
607: 'Setting wf item attributes');
608: END IF;
609: begin
610: wf_engine.SetItemAttrNumber (itemtype => L_WF_NAME,

Line 805: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

801: end;
802: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,
803: itemkey => L_KEY,
804: owner => fnd_global.user_name);
805: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
807: 'Starting approval wf');
808: END IF;
809:

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

802: wf_engine.SetItemOwner ( itemtype => L_WF_NAME,
803: itemkey => L_KEY,
804: owner => fnd_global.user_name);
805: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
807: 'Starting approval wf');
808: END IF;
809:
810: BEGIN

Line 813: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

809:
810: BEGIN
811: wf_engine.StartProcess( itemtype => L_WF_NAME,
812: itemkey => L_KEY);
813: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
814: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
815: 'Successfully started approval wf');
816: END IF;
817: EXCEPTION

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

810: BEGIN
811: wf_engine.StartProcess( itemtype => L_WF_NAME,
812: itemkey => L_KEY);
813: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
814: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
815: 'Successfully started approval wf');
816: END IF;
817: EXCEPTION
818: WHEN OTHERS THEN

Line 819: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

815: 'Successfully started approval wf');
816: END IF;
817: EXCEPTION
818: WHEN OTHERS THEN
819: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
820: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
821: 'In others exception ');
822: l_msg_data := substr(sqlerrm,1,2000);
823: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, l_msg_data);

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

816: END IF;
817: EXCEPTION
818: WHEN OTHERS THEN
819: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
820: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
821: 'In others exception ');
822: l_msg_data := substr(sqlerrm,1,2000);
823: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, l_msg_data);
824: END IF;

Line 823: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, l_msg_data);

819: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
820: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
821: 'In others exception ');
822: l_msg_data := substr(sqlerrm,1,2000);
823: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, l_msg_data);
824: END IF;
825: IF l_msg_data IS NULL THEN
826: BEGIN
827: wf_core.get_error

Line 834: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

830: err_message => l_msg_data,
831: err_stack => l_err_stack,
832: maxerrstacklength => 2000
833: );
834: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
836: 'Error starting approval wf');
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: l_msg_data);

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

831: err_stack => l_err_stack,
832: maxerrstacklength => 2000
833: );
834: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
836: 'Error starting approval wf');
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: l_msg_data);
839: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

833: );
834: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
836: 'Error starting approval wf');
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: l_msg_data);
839: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
840: l_err_stack);
841: END IF;

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

835: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
836: 'Error starting approval wf');
837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
838: l_msg_data);
839: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
840: l_err_stack);
841: END IF;
842: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, l_err_stack);
843: EXCEPTION

Line 845: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

841: END IF;
842: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, l_err_stack);
843: EXCEPTION
844: WHEN OTHERS THEN
845: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
846: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
847: 'In exception for wf_core.get_error: '||substr(sqlerrm,1,300));
848: END IF;
849: END;

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

842: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, l_err_stack);
843: EXCEPTION
844: WHEN OTHERS THEN
845: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
846: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
847: 'In exception for wf_core.get_error: '||substr(sqlerrm,1,300));
848: END IF;
849: END;
850: END IF;

Line 854: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

850: END IF;
851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, l_msg_data);
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: END;
854: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
855: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
856: 'Updating okc header ');
857: END IF;
858:

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

851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, l_msg_data);
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: END;
854: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
855: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
856: 'Updating okc header ');
857: END IF;
858:
859: --Added to fix the bug#3269709

Line 866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

862: SET OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
863: WHERE ID=p_contract_id;
864: --
865: if (p_do_commit = OKC_API.G_TRUE) then
866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
867: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
868: 'Committing.. ');
869: END IF;
870: commit;

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

863: WHERE ID=p_contract_id;
864: --
865: if (p_do_commit = OKC_API.G_TRUE) then
866: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
867: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
868: 'Committing.. ');
869: END IF;
870: commit;
871: end if;

Line 874: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

870: commit;
871: end if;
872: x_return_status := OKC_API.G_RET_STS_SUCCESS;
873: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
874: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
875: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
876: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
877: END IF;
878: EXCEPTION

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

871: end if;
872: x_return_status := OKC_API.G_RET_STS_SUCCESS;
873: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
874: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
875: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
876: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
877: END IF;
878: EXCEPTION
879: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1055: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1051: l_wf_attributes OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS;
1052: l_wf_item_key VARCHAR2(240);
1053: --
1054: begin
1055: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1057: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1058: END IF;
1059: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

1052: l_wf_item_key VARCHAR2(240);
1053: --
1054: begin
1055: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1057: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1058: END IF;
1059: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1060: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1059: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1055: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1057: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1058: END IF;
1059: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1060: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1061: 'p_contract_id=>'||p_contract_id||
1062: ' p_do_commit=>'|| p_do_commit);
1063: END IF;

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

1056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1057: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1058: END IF;
1059: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1060: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1061: 'p_contract_id=>'||p_contract_id||
1062: ' p_do_commit=>'|| p_do_commit);
1063: END IF;
1064: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

Line 1076: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1072: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1074: RAISE OKC_API.G_EXCEPTION_ERROR;
1075: END IF;
1076: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1077: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1078: 'OKC_API.START_ACTIVITY return status '||l_return_status);
1079: END IF;
1080: --

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

1073: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1074: RAISE OKC_API.G_EXCEPTION_ERROR;
1075: END IF;
1076: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1077: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1078: 'OKC_API.START_ACTIVITY return status '||l_return_status);
1079: END IF;
1080: --
1081: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1081: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1077: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1078: 'OKC_API.START_ACTIVITY return status '||l_return_status);
1079: END IF;
1080: --
1081: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1082: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1083: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
1084: END IF;
1085: if k_accesible( p_contract_id => p_contract_id,

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

1078: 'OKC_API.START_ACTIVITY return status '||l_return_status);
1079: END IF;
1080: --
1081: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1082: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1083: 'k_accesible with p_level=U User Id '||fnd_global.user_id);
1084: END IF;
1085: if k_accesible( p_contract_id => p_contract_id,
1086: p_user_id => fnd_global.user_id,

Line 1095: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1091: p_msg_name => G_NO_U_PRIVILEGE);
1092: raise OKC_API.G_EXCEPTION_ERROR;
1093: end if;
1094: --
1095: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1096: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1097: 'Contract is accessible - get contract details');
1098: END IF;
1099: open wf_key_csr;

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

1092: raise OKC_API.G_EXCEPTION_ERROR;
1093: end if;
1094: --
1095: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1096: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1097: 'Contract is accessible - get contract details');
1098: END IF;
1099: open wf_key_csr;
1100: fetch wf_key_csr into L_KEY,l_contract_number,l_contract_number_modifier,L_K_SHORT_DESCRIPTION, l_scs_code;

Line 1112: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1108: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1109: p_msg_name => G_K_NOT_ON_APPROVAL);
1110: raise OKC_API.G_EXCEPTION_ERROR;
1111: end if;
1112: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1113: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1114: 'Got wf details l_wf_name_active=>'||l_wf_name_active);
1115: END IF;
1116: wf_engine.abortprocess(l_wf_name_active,l_key);

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

1109: p_msg_name => G_K_NOT_ON_APPROVAL);
1110: raise OKC_API.G_EXCEPTION_ERROR;
1111: end if;
1112: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1113: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1114: 'Got wf details l_wf_name_active=>'||l_wf_name_active);
1115: END IF;
1116: wf_engine.abortprocess(l_wf_name_active,l_key);
1117: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1117: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1113: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1114: 'Got wf details l_wf_name_active=>'||l_wf_name_active);
1115: END IF;
1116: wf_engine.abortprocess(l_wf_name_active,l_key);
1117: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1118: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
1119: 'k_erase_approved p_contract_id=>'||p_contract_id);
1120: END IF;
1121: k_erase_approved(

Line 1118: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',

1114: 'Got wf details l_wf_name_active=>'||l_wf_name_active);
1115: END IF;
1116: wf_engine.abortprocess(l_wf_name_active,l_key);
1117: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1118: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
1119: 'k_erase_approved p_contract_id=>'||p_contract_id);
1120: END IF;
1121: k_erase_approved(
1122: p_contract_id => p_contract_id,

Line 1125: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1121: k_erase_approved(
1122: p_contract_id => p_contract_id,
1123: x_return_status => l_return_status
1124: );
1125: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
1127: 'k_erase_approved x_return_status=>'||l_return_status);
1128: END IF;
1129: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',

1122: p_contract_id => p_contract_id,
1123: x_return_status => l_return_status
1124: );
1125: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name||'.external_call.before',
1127: 'k_erase_approved x_return_status=>'||l_return_status);
1128: END IF;
1129: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1130: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1143: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1139: --+
1140: --+ if abort process defined
1141: --+
1142: if (L_Q = '!') then
1143: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1144: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1145: 'Abort process defined ');
1146: END IF;
1147: -- previous initiator Uname

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

1140: --+ if abort process defined
1141: --+
1142: if (L_Q = '!') then
1143: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1144: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1145: 'Abort process defined ');
1146: END IF;
1147: -- previous initiator Uname
1148: L_INITIATOR_NAME := wf_engine.GetItemAttrText(l_wf_name_active,L_KEY,'INITIATOR_NAME');

Line 1440: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1436: owner => fnd_global.user_name);
1437: wf_engine.StartProcess( itemtype => l_wf_name_active,
1438: itemkey => L_KEY);
1439:
1440: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1441: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1442: 'Started Abort process successfully');
1443: END IF;
1444: end if;--+ abort process exists

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

1437: wf_engine.StartProcess( itemtype => l_wf_name_active,
1438: itemkey => L_KEY);
1439:
1440: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1441: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1442: 'Started Abort process successfully');
1443: END IF;
1444: end if;--+ abort process exists
1445: --

Line 1454: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1450: open k_process_csr(p_contract_id);
1451: fetch k_process_csr INTO l_wf_item_key;
1452: l_rownotfound := k_process_csr%NOTFOUND;
1453: CLOSE k_process_csr;
1454: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1455: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1456: 'l_wf_item_key=> '||l_wf_item_key);
1457: END IF;
1458: IF l_rownotfound OR l_wf_item_key IS NULL THEN

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

1451: fetch k_process_csr INTO l_wf_item_key;
1452: l_rownotfound := k_process_csr%NOTFOUND;
1453: CLOSE k_process_csr;
1454: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1455: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1456: 'l_wf_item_key=> '||l_wf_item_key);
1457: END IF;
1458: IF l_rownotfound OR l_wf_item_key IS NULL THEN
1459: l_wf_attributes.CONTRACT_ID := p_contract_id;

Line 1467: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1463: l_wf_attributes.ITEM_KEY := p_contract_id||to_char(sysdate,'YYYYMMDDHH24MISS');
1464: l_wf_attributes.IRR_FLAG := 'Y';
1465: l_wf_attributes.PROCESS_TYPE := 'MANUAL';
1466: x_return_status := 'S';
1467: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
1469: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||p_contract_id);
1470: END IF;
1471: OKS_WF_K_PROCESS_PVT.launch_k_process_wf

Line 1468: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

1464: l_wf_attributes.IRR_FLAG := 'Y';
1465: l_wf_attributes.PROCESS_TYPE := 'MANUAL';
1466: x_return_status := 'S';
1467: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
1469: ' OKS_WF_K_PROCESS_PVT.launch_k_process_wf p_contract_id '||p_contract_id);
1470: END IF;
1471: OKS_WF_K_PROCESS_PVT.launch_k_process_wf
1472: (

Line 1480: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1476: x_return_status => l_return_status,
1477: x_msg_count => x_msg_count,
1478: x_msg_data => x_msg_data
1479: ) ;
1480: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1481: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
1482: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf l_return_status=>'||l_return_status);
1483: END IF;
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1481: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

1477: x_msg_count => x_msg_count,
1478: x_msg_data => x_msg_data
1479: ) ;
1480: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1481: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
1482: 'OKS_WF_K_PROCESS_PVT.launch_k_process_wf l_return_status=>'||l_return_status);
1483: END IF;
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1498: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1494: last_update_login = FND_GLOBAL.LOGIN_ID,
1495: Last_updated_by = FND_GLOBAL.USER_ID
1496: WHERE chr_id = l_wf_attributes.contract_id;
1497: ELSE
1498: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1499: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
1500: 'continue_k_process(p_contract_id=>'||p_contract_id||')');
1501: END IF;
1502: -- Complete the Service Contracts Process workflow

Line 1499: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

1495: Last_updated_by = FND_GLOBAL.USER_ID
1496: WHERE chr_id = l_wf_attributes.contract_id;
1497: ELSE
1498: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1499: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
1500: 'continue_k_process(p_contract_id=>'||p_contract_id||')');
1501: END IF;
1502: -- Complete the Service Contracts Process workflow
1503: continue_k_process

Line 1514: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1510: p_contract_id => p_contract_id,
1511: p_wf_item_key => l_wf_item_key,
1512: p_called_from => 'STOP'
1513: );
1514: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1515: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
1516: 'continue_k_process(x_return_status=>'||x_return_status||')');
1517: END IF;
1518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1515: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

1511: p_wf_item_key => l_wf_item_key,
1512: p_called_from => 'STOP'
1513: );
1514: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1515: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
1516: 'continue_k_process(x_return_status=>'||x_return_status||')');
1517: END IF;
1518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1530: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1526: commit;
1527: end if;
1528: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1529: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1530: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1531: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1532: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1533: END IF;
1534: EXCEPTION

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

1527: end if;
1528: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1529: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1530: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1531: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1532: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1533: END IF;
1534: EXCEPTION
1535: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2017: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2013: --
2014: call_time varchar2(1);
2015:
2016: begin
2017: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2019: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
2020: END IF;
2021: --start

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

2014: call_time varchar2(1);
2015:
2016: begin
2017: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2019: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
2020: END IF;
2021: --start
2022: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

Line 2034: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2032: RAISE OKC_API.G_EXCEPTION_ERROR;
2033: END IF;
2034: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2035: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2036: 'OKC_API.START_ACTIVITY return status '||l_return_status);
2037: END IF;
2038:

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

2031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2032: RAISE OKC_API.G_EXCEPTION_ERROR;
2033: END IF;
2034: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2035: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2036: 'OKC_API.START_ACTIVITY return status '||l_return_status);
2037: END IF;
2038:
2039: --npalepu added on 02-DEC-2005 for bug # 4775848 to set the context.

Line 2050: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2046: --Bug:3675868 fetch sts_code into L1_header_rec.old_sts_code
2047: fetch lock_csr into
2048: L1_header_rec.object_version_number,L1_header_rec.START_DATE,L1_header_rec.END_DATE,L1_header_rec.old_sts_code,l_scs_code;
2049: close lock_csr;
2050: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2051: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2052: ' OKC_CONTRACT_PUB.lock_contract_header');
2053: END IF;
2054: OKC_CONTRACT_PUB.lock_contract_header(

Line 2051: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2047: fetch lock_csr into
2048: L1_header_rec.object_version_number,L1_header_rec.START_DATE,L1_header_rec.END_DATE,L1_header_rec.old_sts_code,l_scs_code;
2049: close lock_csr;
2050: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2051: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2052: ' OKC_CONTRACT_PUB.lock_contract_header');
2053: END IF;
2054: OKC_CONTRACT_PUB.lock_contract_header(
2055: p_api_version => l_api_version,

Line 2060: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2056: x_return_status => x_return_status,
2057: x_msg_count => l_msg_count,
2058: x_msg_data => l_msg_data,
2059: p_chrv_rec => L1_header_rec);
2060: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2061: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2062: ' OKC_CONTRACT_PUB.lock_contract_header(x_return_status=>'||x_return_status||')');
2063: END IF;
2064: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2061: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2057: x_msg_count => l_msg_count,
2058: x_msg_data => l_msg_data,
2059: p_chrv_rec => L1_header_rec);
2060: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2061: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2062: ' OKC_CONTRACT_PUB.lock_contract_header(x_return_status=>'||x_return_status||')');
2063: END IF;
2064: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2112: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2108: L1_header_rec.new_sts_code := l_new_status;
2109:
2110: L1_header_rec.STS_CODE := l_new_status;
2111:
2112: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2113: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2114: 'OKC_CONTRACT_PUB.update_contract_header');
2115: END IF;
2116: OKC_CONTRACT_PUB.update_contract_header(

Line 2113: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2109:
2110: L1_header_rec.STS_CODE := l_new_status;
2111:
2112: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2113: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2114: 'OKC_CONTRACT_PUB.update_contract_header');
2115: END IF;
2116: OKC_CONTRACT_PUB.update_contract_header(
2117: p_api_version => l_api_version,

Line 2129: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;
2129: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2130: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2131: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status=>'||x_return_status||')');
2132: END IF;
2133:

Line 2130: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2126: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2127: RAISE OKC_API.G_EXCEPTION_ERROR;
2128: END IF;
2129: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2130: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2131: 'OKC_CONTRACT_PUB.update_contract_header(x_return_status=>'||x_return_status||')');
2132: END IF;
2133:
2134:

Line 2156: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2152: --before making that call.
2153:
2154: l_sysdate := SYSDATE;
2155:
2156: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2157: fnd_log.string(FND_LOG.LEVEL_EVENT, G_MODULE || l_api_name || '.direct_line_status_change',
2158: 'updating line status');
2159: END IF;
2160: /*modified for bug8530862*/

Line 2157: fnd_log.string(FND_LOG.LEVEL_EVENT, G_MODULE || l_api_name || '.direct_line_status_change',

2153:
2154: l_sysdate := SYSDATE;
2155:
2156: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2157: fnd_log.string(FND_LOG.LEVEL_EVENT, G_MODULE || l_api_name || '.direct_line_status_change',
2158: 'updating line status');
2159: END IF;
2160: /*modified for bug8530862*/
2161: /*bug12370530 -- ATG12402762, As part of 12.2 techstack changes given in Database

Line 2199: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2195: WHERE oks.sts_code IN (SELECT code
2196: FROM okc_statuses_b
2197: WHERE ste_code = 'ENTERED');
2198:
2199: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2200: fnd_log.string(FND_LOG.LEVEL_EVENT, G_MODULE || l_api_name || '.direct_line_status_change',
2201: 'done line status update');
2202: END IF;
2203:

Line 2200: fnd_log.string(FND_LOG.LEVEL_EVENT, G_MODULE || l_api_name || '.direct_line_status_change',

2196: FROM okc_statuses_b
2197: WHERE ste_code = 'ENTERED');
2198:
2199: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2200: fnd_log.string(FND_LOG.LEVEL_EVENT, G_MODULE || l_api_name || '.direct_line_status_change',
2201: 'done line status update');
2202: END IF;
2203:
2204:

Line 2231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2228: RAISE OKC_API.G_EXCEPTION_ERROR;
2229: END IF;
2230:
2231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2233: 'OKC_CONTRACT_PUB.update_contract_line');
2234: END IF;
2235: -- update lines

Line 2232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2228: RAISE OKC_API.G_EXCEPTION_ERROR;
2229: END IF;
2230:
2231: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2232: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2233: 'OKC_CONTRACT_PUB.update_contract_line');
2234: END IF;
2235: -- update lines
2236: OKC_CONTRACT_PUB.update_contract_line(

Line 2244: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2240: x_msg_data => l_msg_data,
2241: p_restricted_update => OKC_API.G_TRUE,
2242: p_clev_tbl => l2_lines,
2243: x_clev_tbl => l3_lines);
2244: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2245: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2246: 'OKC_CONTRACT_PUB.update_contract_line(x_return_status=>'||x_return_status||')');
2247: END IF;
2248: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2245: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2241: p_restricted_update => OKC_API.G_TRUE,
2242: p_clev_tbl => l2_lines,
2243: x_clev_tbl => l3_lines);
2244: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2245: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2246: 'OKC_CONTRACT_PUB.update_contract_line(x_return_status=>'||x_return_status||')');
2247: END IF;
2248: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2249: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2283: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2279: --do nothing
2280: NULL;
2281: ELSE
2282:
2283: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2284: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2285: 'OKC_PHI_PVT.process_price_hold(p_chr_id=>'||p_contract_id||')');
2286: END IF;
2287:

Line 2284: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2280: NULL;
2281: ELSE
2282:
2283: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2284: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2285: 'OKC_PHI_PVT.process_price_hold(p_chr_id=>'||p_contract_id||')');
2286: END IF;
2287:
2288: OKC_PHI_PVT.process_price_hold(p_api_version => l_api_version

Line 2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2292: ,p_termination_date => Null
2293: ,x_return_status => x_return_status
2294: ,x_msg_count => l_msg_count
2295: ,x_msg_data => l_msg_data);
2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2298: 'OKC_PHI_PVT.process_price_hold(x_return_status=>'||x_return_status||')');
2299: END IF;
2300:

Line 2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2293: ,x_return_status => x_return_status
2294: ,x_msg_count => l_msg_count
2295: ,x_msg_data => l_msg_data);
2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2298: 'OKC_PHI_PVT.process_price_hold(x_return_status=>'||x_return_status||')');
2299: END IF;
2300:
2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2312: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2308: END IF;
2309:
2310: -- End ** Call to Price Hold API to create QP entries If there are any Price Hold Information on contract
2311:
2312: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2313: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2314: 'OKC_K_SIGN_ASMBLR_PVT.acn_assemble(p_contract_id=>'||x_return_status||')');
2315: END IF;
2316: -- raise event

Line 2313: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2309:
2310: -- End ** Call to Price Hold API to create QP entries If there are any Price Hold Information on contract
2311:
2312: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2313: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2314: 'OKC_K_SIGN_ASMBLR_PVT.acn_assemble(p_contract_id=>'||x_return_status||')');
2315: END IF;
2316: -- raise event
2317: OKC_K_SIGN_ASMBLR_PVT.acn_assemble(

Line 2323: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2319: x_return_status => x_return_status,
2320: x_msg_count => l_msg_count,
2321: x_msg_data => l_msg_data,
2322: p_contract_id => p_contract_id);
2323: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2324: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2325: 'OKC_K_SIGN_ASMBLR_PVT.acn_assemble(x_return_status=>'||x_return_status||')');
2326: END IF;
2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2324: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2320: x_msg_count => l_msg_count,
2321: x_msg_data => l_msg_data,
2322: p_contract_id => p_contract_id);
2323: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2324: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2325: 'OKC_K_SIGN_ASMBLR_PVT.acn_assemble(x_return_status=>'||x_return_status||')');
2326: END IF;
2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2337: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2333: --end
2334:
2335: IF l_scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION') AND p_complete_k_prcs = 'Y' THEN
2336: -- Complete the Service Contracts Process workflow if applicable
2337: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2338: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2339: 'continue_k_process(p_contract_id=>'||p_contract_id||')');
2340: END IF;
2341: continue_k_process

Line 2338: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

2334:
2335: IF l_scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION') AND p_complete_k_prcs = 'Y' THEN
2336: -- Complete the Service Contracts Process workflow if applicable
2337: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2338: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2339: 'continue_k_process(p_contract_id=>'||p_contract_id||')');
2340: END IF;
2341: continue_k_process
2342: (

Line 2352: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2348: p_contract_id => p_contract_id,
2349: p_wf_item_key => NULL,
2350: p_called_from => 'APPROVE'
2351: );
2352: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2353: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2354: 'continue_k_process(x_return_status=>'||x_return_status||')');
2355: END IF;
2356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2353: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

2349: p_wf_item_key => NULL,
2350: p_called_from => 'APPROVE'
2351: );
2352: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2353: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2354: 'continue_k_process(x_return_status=>'||x_return_status||')');
2355: END IF;
2356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2360: END IF;
2361: END IF;
2362:
2363: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
2364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2366: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
2367: END IF;
2368: EXCEPTION

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

2361: END IF;
2362:
2363: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
2364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2366: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
2367: END IF;
2368: EXCEPTION
2369: WHEN OKC_API.G_EXCEPTION_ERROR THEN