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 OKC_API

Line 6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

2: /* $Header: OKCRCAPB.pls 120.21 2011/05/04 08:03:36 vgujarat ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: --
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_APPROVAL_PVT';
8: G_LEVEL CONSTANT VARCHAR2(4) := '_PVT';
9: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
10: l_api_version CONSTANT NUMBER := 1;

Line 11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_APPROVAL_PVT';
8: G_LEVEL CONSTANT VARCHAR2(4) := '_PVT';
9: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
10: l_api_version CONSTANT NUMBER := 1;
11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: --
14: G_K_WAS_APPROVED CONSTANT varchar2(200) := 'OKC_ALREADY_APPROVED';
15: --

Line 12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

8: G_LEVEL CONSTANT VARCHAR2(4) := '_PVT';
9: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
10: l_api_version CONSTANT NUMBER := 1;
11: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
12: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
13: --
14: G_K_WAS_APPROVED CONSTANT varchar2(200) := 'OKC_ALREADY_APPROVED';
15: --
16: G_PROCESS_NOT_FOR_APPROVAL CONSTANT varchar2(200) := 'OKC_PROCESS_NOT_FOR_APPROVAL';

Line 55: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

51: SELECT wf_item_key
52: FROM oks_k_headers_b
53: WHERE chr_id = p_chr_id;
54:
55: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
56: l_wf_attributes OKS_WF_K_PROCESS_PVT.WF_ATTR_DETAILS;
57: l_wf_item_key VARCHAR2(240);
58:
59: BEGIN

Line 67: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

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:
67: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
68: G_PKG_NAME,
69: p_init_msg_list,
70: l_api_version,
71: p_api_version,

Line 74: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

70: l_api_version,
71: p_api_version,
72: G_LEVEL,
73: x_return_status);
74: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
75: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
77: RAISE OKC_API.G_EXCEPTION_ERROR;
78: END IF;

Line 75: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

71: p_api_version,
72: G_LEVEL,
73: x_return_status);
74: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
75: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
77: RAISE OKC_API.G_EXCEPTION_ERROR;
78: END IF;
79:

Line 76: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

72: G_LEVEL,
73: x_return_status);
74: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
75: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
77: RAISE OKC_API.G_EXCEPTION_ERROR;
78: END IF;
79:
80: IF p_wf_item_key IS NULL THEN

Line 77: RAISE OKC_API.G_EXCEPTION_ERROR;

73: x_return_status);
74: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
75: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
77: RAISE OKC_API.G_EXCEPTION_ERROR;
78: END IF;
79:
80: IF p_wf_item_key IS NULL THEN
81: OPEN l_kdetails_csr(p_contract_id);

Line 97: p_init_msg_list => OKC_API.G_FALSE,

93: END IF;
94: OKS_WF_K_PROCESS_PVT.complete_activity
95: (
96: p_api_version => l_api_version,
97: p_init_msg_list => OKC_API.G_FALSE,
98: p_contract_id => p_contract_id,
99: p_item_key => l_wf_item_key,
100: p_resultout => 'APPROVED',
101: p_process_status => NULL,

Line 111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
114: RAISE OKC_API.G_EXCEPTION_ERROR;
115: END IF;

Line 112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
114: RAISE OKC_API.G_EXCEPTION_ERROR;
115: END IF;
116:

Line 113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
114: RAISE OKC_API.G_EXCEPTION_ERROR;
115: END IF;
116:
117: ELSIF NVL(p_called_from,'!') = 'STOP' THEN

Line 114: RAISE OKC_API.G_EXCEPTION_ERROR;

110: END IF;
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) 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

Line 125: p_init_msg_list => OKC_API.G_FALSE,

121: END IF;
122: OKS_WF_K_PROCESS_PVT.complete_activity
123: (
124: p_api_version => l_api_version,
125: p_init_msg_list => OKC_API.G_FALSE,
126: p_contract_id => p_contract_id,
127: p_item_key => l_wf_item_key,
128: p_resultout => 'STOPPED',
129: p_process_status => 'ACT',

Line 139: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
141: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;

Line 140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
141: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:

Line 141: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
141: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: -- update process status to 'Quote Accepted' coz approval workflow

Line 142: RAISE OKC_API.G_EXCEPTION_ERROR;

138: END IF;
139: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: -- update process status to 'Quote Accepted' coz approval workflow
146: -- is stopped so we should effectively revert back to the original

Line 148: /* IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN

144:
145: -- update process status to 'Quote Accepted' coz approval workflow
146: -- is stopped so we should effectively revert back to the original
147: -- negotiation status.
148: /* IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
149: UPDATE oks_k_headers_b
150: SET object_version_number = object_version_number + 1,
151: renewal_status = 'ACT',
152: last_update_date = SYSDATE,

Line 166: p_init_msg_list => OKC_API.G_FALSE,

162: END IF;
163: OKS_WF_K_PROCESS_PVT.complete_activity
164: (
165: p_api_version => l_api_version,
166: p_init_msg_list => OKC_API.G_FALSE,
167: p_contract_id => p_contract_id,
168: p_item_key => l_wf_item_key,
169: p_resultout => NULL,
170: p_process_status => 'REJECTED',

Line 180: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
182: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
183: RAISE OKC_API.G_EXCEPTION_ERROR;
184: END IF;

Line 181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
182: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
183: RAISE OKC_API.G_EXCEPTION_ERROR;
184: END IF;
185:

Line 182: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
182: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
183: RAISE OKC_API.G_EXCEPTION_ERROR;
184: END IF;
185:
186: -- update process status to 'Quote Accepted' coz approval workflow

Line 183: RAISE OKC_API.G_EXCEPTION_ERROR;

179: END IF;
180: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
183: RAISE OKC_API.G_EXCEPTION_ERROR;
184: END IF;
185:
186: -- update process status to 'Quote Accepted' coz approval workflow
187: -- is stopped so we should effectively revert back to the original

Line 189: /* IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN

185:
186: -- update process status to 'Quote Accepted' coz approval workflow
187: -- is stopped so we should effectively revert back to the original
188: -- negotiation status.
189: /* IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
190: UPDATE oks_k_headers_b
191: SET object_version_number = object_version_number + 1,
192: renewal_status = 'REJ',
193: last_update_date = SYSDATE,

Line 250: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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
251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: END IF;

Line 251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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
251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: END IF;
255: UPDATE oks_k_headers_b

Line 252: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

248: x_return_status);
249: END IF;
250: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: END IF;
255: UPDATE oks_k_headers_b
256: SET object_version_number = object_version_number + 1,

Line 253: RAISE OKC_API.G_EXCEPTION_ERROR;

249: END IF;
250: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
253: RAISE OKC_API.G_EXCEPTION_ERROR;
254: END IF;
255: UPDATE oks_k_headers_b
256: SET object_version_number = object_version_number + 1,
257: wf_item_key = l_wf_attributes.ITEM_KEY,

Line 272: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

268: END IF;
269: -- Explicit commit needed
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);

Line 280: WHEN OKC_API.G_EXCEPTION_ERROR THEN

276: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
277: END IF;
278:
279: EXCEPTION
280: WHEN OKC_API.G_EXCEPTION_ERROR THEN
281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
282: (substr(l_api_name,1,26),
283: G_PKG_NAME,
284: 'OKC_API.G_RET_STS_ERROR',

Line 281: x_return_status := OKC_API.HANDLE_EXCEPTIONS

277: END IF;
278:
279: EXCEPTION
280: WHEN OKC_API.G_EXCEPTION_ERROR THEN
281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
282: (substr(l_api_name,1,26),
283: G_PKG_NAME,
284: 'OKC_API.G_RET_STS_ERROR',
285: x_msg_count,

Line 284: 'OKC_API.G_RET_STS_ERROR',

280: WHEN OKC_API.G_EXCEPTION_ERROR THEN
281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
282: (substr(l_api_name,1,26),
283: G_PKG_NAME,
284: 'OKC_API.G_RET_STS_ERROR',
285: x_msg_count,
286: x_msg_data,
287: G_LEVEL);
288: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 288: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

284: 'OKC_API.G_RET_STS_ERROR',
285: x_msg_count,
286: x_msg_data,
287: G_LEVEL);
288: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
289: x_return_status := OKC_API.HANDLE_EXCEPTIONS
290: (substr(l_api_name,1,26),
291: G_PKG_NAME,
292: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 289: x_return_status := OKC_API.HANDLE_EXCEPTIONS

285: x_msg_count,
286: x_msg_data,
287: G_LEVEL);
288: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
289: x_return_status := OKC_API.HANDLE_EXCEPTIONS
290: (substr(l_api_name,1,26),
291: G_PKG_NAME,
292: 'OKC_API.G_RET_STS_UNEXP_ERROR',
293: x_msg_count,

Line 292: 'OKC_API.G_RET_STS_UNEXP_ERROR',

288: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
289: x_return_status := OKC_API.HANDLE_EXCEPTIONS
290: (substr(l_api_name,1,26),
291: G_PKG_NAME,
292: 'OKC_API.G_RET_STS_UNEXP_ERROR',
293: x_msg_count,
294: x_msg_data,
295: G_LEVEL);
296: WHEN OTHERS THEN

Line 297: x_return_status := OKC_API.HANDLE_EXCEPTIONS

293: x_msg_count,
294: x_msg_data,
295: G_LEVEL);
296: WHEN OTHERS THEN
297: x_return_status := OKC_API.HANDLE_EXCEPTIONS
298: (substr(l_api_name,1,26),
299: G_PKG_NAME,
300: 'OTHERS',
301: x_msg_count,

Line 331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

327: p_resp_appl_id IN NUMBER default null,
328: p_security_group_id IN NUMBER default null
329: ) is
330: l_api_name CONSTANT VARCHAR2(30) := 'k_approval_start';
331: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
332: --
333: l_key varchar2(240);
334: l_contract_number varchar2(120);
335: l_contract_number_modifier varchar2(120);

Line 420: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

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),
421: G_PKG_NAME,
422: p_init_msg_list,
423: l_api_version,
424: p_api_version,

Line 427: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

423: l_api_version,
424: p_api_version,
425: G_LEVEL,
426: x_return_status);
427: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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;

Line 428: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

424: p_api_version,
425: G_LEVEL,
426: x_return_status);
427: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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

Line 429: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

425: G_LEVEL,
426: x_return_status);
427: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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,

Line 430: RAISE OKC_API.G_EXCEPTION_ERROR;

426: x_return_status);
427: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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);

Line 434: 'OKC_API.START_ACTIVITY return status '||l_return_status);

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
438: -- Below IF added because context does not set thru background processes

Line 449: ) = OKC_API.G_FALSE

445: END IF;
446: if k_accesible( p_contract_id => p_contract_id,
447: p_user_id => fnd_global.user_id,
448: p_level => 'U'
449: ) = OKC_API.G_FALSE
450: then
451: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
452: p_msg_name => G_NO_U_PRIVILEGE);
453: raise OKC_API.G_EXCEPTION_ERROR;

Line 451: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

447: p_user_id => fnd_global.user_id,
448: p_level => 'U'
449: ) = OKC_API.G_FALSE
450: then
451: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
452: p_msg_name => G_NO_U_PRIVILEGE);
453: raise OKC_API.G_EXCEPTION_ERROR;
454: end if;
455: END IF;

Line 453: raise OKC_API.G_EXCEPTION_ERROR;

449: ) = OKC_API.G_FALSE
450: then
451: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
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,

Line 466: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

462: fetch k_header_csr
463: into L_CONTRACT_NUMBER, L_CONTRACT_NUMBER_MODIFIER, L_DATE_APPROVED, L_STATUS, L_STATUS_TYPE;
464: close k_header_csr;
465: if (L_DATE_APPROVED is not NULL) 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

Line 468: raise OKC_API.G_EXCEPTION_ERROR;

464: close k_header_csr;
465: if (L_DATE_APPROVED is not NULL) 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);

Line 475: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

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,
476: p_msg_name => 'OKC_INVALID_K_STATUS',
477: p_token1 => 'NUMBER',
478: p_token1_value => L_CONTRACT_NUMBER||'-'||L_CONTRACT_NUMBER_MODIFIER,
479: p_token2 => 'STATUS',

Line 481: raise OKC_API.G_EXCEPTION_ERROR;

477: p_token1 => 'NUMBER',
478: p_token1_value => L_CONTRACT_NUMBER||'-'||L_CONTRACT_NUMBER_MODIFIER,
479: p_token2 => 'STATUS',
480: p_token2_value => L_STATUS);
481: raise OKC_API.G_EXCEPTION_ERROR;
482: end if;
483: --
484: open process_def_csr;
485: fetch process_def_csr into L_WF_NAME, L_WF_PROCESS_NAME, L_USAGE;

Line 488: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

484: open process_def_csr;
485: fetch process_def_csr into L_WF_NAME, L_WF_PROCESS_NAME, L_USAGE;
486: close process_def_csr;
487: if (L_WF_NAME is NULL) 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

Line 490: raise OKC_API.G_EXCEPTION_ERROR;

486: close process_def_csr;
487: if (L_WF_NAME is NULL) 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||

Line 499: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

495: ' L_WF_PROCESS_NAME=>'||L_WF_PROCESS_NAME||
496: ' L_USAGE=>'||L_USAGE);
497: END IF;
498: if (L_USAGE <> 'APPROVE') then
499: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
500: p_msg_name => G_PROCESS_NOT_FOR_APPROVAL,
501: p_token1 => G_WF_NAME_TOKEN,
502: p_token1_value => L_WF_NAME,
503: p_token2 => G_WF_P_NAME_TOKEN,

Line 505: raise OKC_API.G_EXCEPTION_ERROR;

501: p_token1 => G_WF_NAME_TOKEN,
502: p_token1_value => L_WF_NAME,
503: p_token2 => G_WF_P_NAME_TOKEN,
504: p_token2_value => L_WF_PROCESS_NAME);
505: raise OKC_API.G_EXCEPTION_ERROR;
506: end if;
507: --
508: L_KEY := L_CONTRACT_NUMBER||L_CONTRACT_NUMBER_MODIFIER;
509: open approval_active_csr;

Line 517: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

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,
518: p_msg_name => G_K_ON_APPROVAL,
519: p_token1 => G_WF_NAME_TOKEN,
520: p_token1_value => L_WF_NAME_ACTIVE,
521: p_token2 => G_KEY_TOKEN,

Line 523: raise OKC_API.G_EXCEPTION_ERROR;

519: p_token1 => G_WF_NAME_TOKEN,
520: p_token1_value => L_WF_NAME_ACTIVE,
521: p_token2 => G_KEY_TOKEN,
522: p_token2_value => L_KEY);
523: raise OKC_API.G_EXCEPTION_ERROR;
524: end if;
525: --
526: L_Q:='?';
527: open for_purge_csr;

Line 545: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

541: -- for Bug#3096950 - wf_purge.totalPerm(l_wf_name,l_key);
542: wf_purge.totalPerm(l_wf_name,l_key,runtimeonly=>TRUE);
543: exception
544: when others then
545: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
546: p_msg_name => G_WF_NOT_PURGED,
547: p_token1 => G_WF_NAME_TOKEN,
548: p_token1_value => L_WF_NAME,
549: p_token2 => G_KEY_TOKEN,

Line 551: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

547: p_token1 => G_WF_NAME_TOKEN,
548: p_token1_value => L_WF_NAME,
549: p_token2 => G_KEY_TOKEN,
550: p_token2_value => L_KEY);
551: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
552: end;
553: end;
554: end if;
555: --

Line 568: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

564: END IF;
565: exception
566: when others then
567: rollback to BECAUSE_OF_BUG_IN_lock;
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

Line 569: RAISE OKC_API.G_EXCEPTION_ERROR;

565: exception
566: when others then
567: rollback to BECAUSE_OF_BUG_IN_lock;
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',

Line 587: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
590: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
591: rollback to BECAUSE_OF_BUG_IN_lock;

Line 589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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;

Line 590: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

586: END IF;
587: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
588: rollback to BECAUSE_OF_BUG_IN_lock;
589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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

Line 592: RAISE OKC_API.G_EXCEPTION_ERROR;

588: rollback to BECAUSE_OF_BUG_IN_lock;
589: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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||

Line 852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

848: END IF;
849: END;
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 ');

Line 865: if (p_do_commit = OKC_API.G_TRUE) then

861: UPDATE okc_k_headers_all_b
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;

Line 872: x_return_status := OKC_API.G_RET_STS_SUCCESS;

868: 'Committing.. ');
869: END IF;
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);

Line 873: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

869: END IF;
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;

Line 879: WHEN OKC_API.G_EXCEPTION_ERROR 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
880: x_return_status := OKC_API.HANDLE_EXCEPTIONS
881: (substr(l_api_name,1,26),
882: G_PKG_NAME,
883: 'OKC_API.G_RET_STS_ERROR',

Line 880: x_return_status := OKC_API.HANDLE_EXCEPTIONS

876: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
877: END IF;
878: EXCEPTION
879: WHEN OKC_API.G_EXCEPTION_ERROR THEN
880: x_return_status := OKC_API.HANDLE_EXCEPTIONS
881: (substr(l_api_name,1,26),
882: G_PKG_NAME,
883: 'OKC_API.G_RET_STS_ERROR',
884: x_msg_count,

Line 883: 'OKC_API.G_RET_STS_ERROR',

879: WHEN OKC_API.G_EXCEPTION_ERROR THEN
880: x_return_status := OKC_API.HANDLE_EXCEPTIONS
881: (substr(l_api_name,1,26),
882: G_PKG_NAME,
883: 'OKC_API.G_RET_STS_ERROR',
884: x_msg_count,
885: x_msg_data,
886: G_LEVEL);
887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

883: 'OKC_API.G_RET_STS_ERROR',
884: x_msg_count,
885: x_msg_data,
886: G_LEVEL);
887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_return_status := OKC_API.HANDLE_EXCEPTIONS
889: (substr(l_api_name,1,26),
890: G_PKG_NAME,
891: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 888: x_return_status := OKC_API.HANDLE_EXCEPTIONS

884: x_msg_count,
885: x_msg_data,
886: G_LEVEL);
887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_return_status := OKC_API.HANDLE_EXCEPTIONS
889: (substr(l_api_name,1,26),
890: G_PKG_NAME,
891: 'OKC_API.G_RET_STS_UNEXP_ERROR',
892: x_msg_count,

Line 891: 'OKC_API.G_RET_STS_UNEXP_ERROR',

887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_return_status := OKC_API.HANDLE_EXCEPTIONS
889: (substr(l_api_name,1,26),
890: G_PKG_NAME,
891: 'OKC_API.G_RET_STS_UNEXP_ERROR',
892: x_msg_count,
893: x_msg_data,
894: G_LEVEL);
895: WHEN OTHERS THEN

Line 896: x_return_status := OKC_API.HANDLE_EXCEPTIONS

892: x_msg_count,
893: x_msg_data,
894: G_LEVEL);
895: WHEN OTHERS THEN
896: x_return_status := OKC_API.HANDLE_EXCEPTIONS
897: (substr(l_api_name,1,26),
898: G_PKG_NAME,
899: 'OTHERS',
900: x_msg_count,

Line 987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

983: p_contract_id number,
984: p_do_commit IN VARCHAR2
985: ) is
986: l_api_name CONSTANT VARCHAR2(30) := 'k_approval_stop';
987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
988: --
989: l_q varchar2(1);
990: l_scs_code varchar2(30);
991: l_key varchar2(240);

Line 1064: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

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),
1065: G_PKG_NAME,
1066: p_init_msg_list,
1067: l_api_version,
1068: p_api_version,

Line 1071: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1067: l_api_version,
1068: p_api_version,
1069: G_LEVEL,
1070: x_return_status);
1071: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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;

Line 1072: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1068: p_api_version,
1069: G_LEVEL,
1070: x_return_status);
1071: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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

Line 1073: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1069: G_LEVEL,
1070: x_return_status);
1071: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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,

Line 1074: RAISE OKC_API.G_EXCEPTION_ERROR;

1070: x_return_status);
1071: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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);

Line 1078: 'OKC_API.START_ACTIVITY return status '||l_return_status);

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
1082: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1088: ) = OKC_API.G_FALSE

1084: END IF;
1085: if k_accesible( p_contract_id => p_contract_id,
1086: p_user_id => fnd_global.user_id,
1087: p_level => 'U'
1088: ) = OKC_API.G_FALSE
1089: then
1090: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1091: p_msg_name => G_NO_U_PRIVILEGE);
1092: raise OKC_API.G_EXCEPTION_ERROR;

Line 1090: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

1086: p_user_id => fnd_global.user_id,
1087: p_level => 'U'
1088: ) = OKC_API.G_FALSE
1089: then
1090: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1091: p_msg_name => G_NO_U_PRIVILEGE);
1092: raise OKC_API.G_EXCEPTION_ERROR;
1093: end if;
1094: --

Line 1092: raise OKC_API.G_EXCEPTION_ERROR;

1088: ) = OKC_API.G_FALSE
1089: then
1090: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
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,

Line 1108: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

1104: fetch approval_active_csr into l_wf_name_active;
1105: close approval_active_csr;
1106: --
1107: if l_wf_name_active is NULL 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

Line 1110: raise OKC_API.G_EXCEPTION_ERROR;

1106: --
1107: if l_wf_name_active is NULL 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);

Line 1129: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
1131: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1132: RAISE OKC_API.G_EXCEPTION_ERROR;
1133: END IF;

Line 1130: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
1131: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1132: RAISE OKC_API.G_EXCEPTION_ERROR;
1133: END IF;
1134: --+

Line 1131: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
1131: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1132: RAISE OKC_API.G_EXCEPTION_ERROR;
1133: END IF;
1134: --+
1135: L_Q:='?';

Line 1132: RAISE OKC_API.G_EXCEPTION_ERROR;

1128: END IF;
1129: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1130: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1131: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1132: RAISE OKC_API.G_EXCEPTION_ERROR;
1133: END IF;
1134: --+
1135: L_Q:='?';
1136: open abort_csr;

Line 1167: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

1163: --for Bug#3096950 - wf_purge.totalPerm(l_wf_name_active,l_key);
1164: wf_purge.totalPerm(l_wf_name_active, l_key, runtimeonly=>TRUE);
1165: exception
1166: when others then
1167: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1168: p_msg_name => G_WF_NOT_PURGED,
1169: p_token1 => G_WF_NAME_TOKEN,
1170: p_token1_value => l_wf_name_active,
1171: p_token2 => G_KEY_TOKEN,

Line 1173: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1169: p_token1 => G_WF_NAME_TOKEN,
1170: p_token1_value => l_wf_name_active,
1171: p_token2 => G_KEY_TOKEN,
1172: p_token2_value => L_KEY);
1173: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: end;
1175: end;
1176: wf_engine.CreateProcess( ItemType => l_wf_name_active,
1177: ItemKey => L_KEY,

Line 1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;

Line 1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: UPDATE oks_k_headers_b

Line 1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: UPDATE oks_k_headers_b
1490: SET object_version_number = object_version_number + 1,

Line 1487: RAISE OKC_API.G_EXCEPTION_ERROR;

1483: END IF;
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: UPDATE oks_k_headers_b
1490: SET object_version_number = object_version_number + 1,
1491: wf_item_key = l_wf_attributes.ITEM_KEY,

Line 1518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
1520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;

Line 1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
1520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;
1523: END IF;

Line 1520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
1520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;
1523: END IF;
1524: END IF;

Line 1521: RAISE OKC_API.G_EXCEPTION_ERROR;

1517: END IF;
1518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;
1523: END IF;
1524: END IF;
1525: if (p_do_commit = OKC_API.G_TRUE) then

Line 1525: if (p_do_commit = OKC_API.G_TRUE) then

1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;
1523: END IF;
1524: END IF;
1525: if (p_do_commit = OKC_API.G_TRUE) 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);

Line 1528: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1524: END IF;
1525: if (p_do_commit = OKC_API.G_TRUE) 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);

Line 1529: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1525: if (p_do_commit = OKC_API.G_TRUE) 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;

Line 1535: WHEN OKC_API.G_EXCEPTION_ERROR 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
1536: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1537: (substr(l_api_name,1,26),
1538: G_PKG_NAME,
1539: 'OKC_API.G_RET_STS_ERROR',

Line 1536: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1532: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1533: END IF;
1534: EXCEPTION
1535: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1536: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1537: (substr(l_api_name,1,26),
1538: G_PKG_NAME,
1539: 'OKC_API.G_RET_STS_ERROR',
1540: x_msg_count,

Line 1539: 'OKC_API.G_RET_STS_ERROR',

1535: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1536: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1537: (substr(l_api_name,1,26),
1538: G_PKG_NAME,
1539: 'OKC_API.G_RET_STS_ERROR',
1540: x_msg_count,
1541: x_msg_data,
1542: G_LEVEL);
1543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1539: 'OKC_API.G_RET_STS_ERROR',
1540: x_msg_count,
1541: x_msg_data,
1542: G_LEVEL);
1543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1544: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1545: (substr(l_api_name,1,26),
1546: G_PKG_NAME,
1547: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1544: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1540: x_msg_count,
1541: x_msg_data,
1542: G_LEVEL);
1543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1544: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1545: (substr(l_api_name,1,26),
1546: G_PKG_NAME,
1547: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1548: x_msg_count,

Line 1547: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1544: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1545: (substr(l_api_name,1,26),
1546: G_PKG_NAME,
1547: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1548: x_msg_count,
1549: x_msg_data,
1550: G_LEVEL);
1551: WHEN OTHERS THEN

Line 1552: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1548: x_msg_count,
1549: x_msg_data,
1550: G_LEVEL);
1551: WHEN OTHERS THEN
1552: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1553: (substr(l_api_name,1,26),
1554: G_PKG_NAME,
1555: 'OTHERS',
1556: x_msg_count,

Line 1668: then return OKC_API.G_TRUE;

1664: */
1665: begin
1666: l_q :=okc_util.get_k_access_level(p_chr_id => p_contract_id);
1667: if ((l_q = p_level) or (l_q = 'U'))
1668: then return OKC_API.G_TRUE;
1669: else return OKC_API.G_FALSE;
1670: end if;
1671: /*
1672: --

Line 1669: else return OKC_API.G_FALSE;

1665: begin
1666: l_q :=okc_util.get_k_access_level(p_chr_id => p_contract_id);
1667: if ((l_q = p_level) or (l_q = 'U'))
1668: then return OKC_API.G_TRUE;
1669: else return OKC_API.G_FALSE;
1670: end if;
1671: /*
1672: --
1673: open check_access_csr;

Line 1678: if l_q = '?' then return OKC_API.G_FALSE;

1674: fetch check_access_csr into l_q;
1675: close check_access_csr;
1676: --
1677:
1678: if l_q = '?' then return OKC_API.G_FALSE;
1679: else return OKC_API.G_TRUE;
1680: end if;
1681: */
1682:

Line 1679: else return OKC_API.G_TRUE;

1675: close check_access_csr;
1676: --
1677:
1678: if l_q = '?' then return OKC_API.G_FALSE;
1679: else return OKC_API.G_TRUE;
1680: end if;
1681: */
1682:
1683: end k_accesible;

Line 1723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1719: from okc_k_headers_all_b
1720: where ID = p
1721: ;
1722: l_api_name CONSTANT VARCHAR2(30) := 'k_approved';
1723: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1724: l_msg_count NUMBER;
1725: l_msg_data varchar2(2000);
1726: begin
1727:

Line 1729: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

1725: l_msg_data varchar2(2000);
1726: begin
1727:
1728: --start
1729: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1730: G_PKG_NAME,
1731: OKC_API.G_TRUE,
1732: l_api_version,
1733: l_api_version,

Line 1731: OKC_API.G_TRUE,

1727:
1728: --start
1729: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1730: G_PKG_NAME,
1731: OKC_API.G_TRUE,
1732: l_api_version,
1733: l_api_version,
1734: G_LEVEL,
1735: x_return_status);

Line 1736: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1732: l_api_version,
1733: l_api_version,
1734: G_LEVEL,
1735: x_return_status);
1736: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_ERROR;
1740: END IF;

Line 1737: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1733: l_api_version,
1734: G_LEVEL,
1735: x_return_status);
1736: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_ERROR;
1740: END IF;
1741:

Line 1738: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1734: G_LEVEL,
1735: x_return_status);
1736: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_ERROR;
1740: END IF;
1741:
1742: --lock

Line 1739: RAISE OKC_API.G_EXCEPTION_ERROR;

1735: x_return_status);
1736: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1739: RAISE OKC_API.G_EXCEPTION_ERROR;
1740: END IF;
1741:
1742: --lock
1743: L1_header_rec.id := p_contract_id;

Line 1761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1757: x_return_status => x_return_status,
1758: x_msg_count => l_msg_count,
1759: x_msg_data => l_msg_data,
1760: p_chrv_rec => L1_header_rec);
1761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_ERROR;
1765: END IF;

Line 1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1758: x_msg_count => l_msg_count,
1759: x_msg_data => l_msg_data,
1760: p_chrv_rec => L1_header_rec);
1761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_ERROR;
1765: END IF;
1766:

Line 1763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1759: x_msg_data => l_msg_data,
1760: p_chrv_rec => L1_header_rec);
1761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_ERROR;
1765: END IF;
1766:
1767: --update

Line 1764: RAISE OKC_API.G_EXCEPTION_ERROR;

1760: p_chrv_rec => L1_header_rec);
1761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_ERROR;
1765: END IF;
1766:
1767: --update
1768: L1_header_rec.date_approved := p_date_approved;

Line 1781: p_init_msg_list => OKC_API.G_TRUE,

1777:
1778: OKC_CONTRACT_PUB.update_contract_header(
1779: p_api_version => l_api_version,
1780: x_return_status => x_return_status,
1781: p_init_msg_list => OKC_API.G_TRUE,
1782: x_msg_count => l_msg_count,
1783: x_msg_data => l_msg_data,
1784: p_restricted_update => OKC_API.G_TRUE,
1785: p_chrv_rec => L1_header_rec,

Line 1784: p_restricted_update => OKC_API.G_TRUE,

1780: x_return_status => x_return_status,
1781: p_init_msg_list => OKC_API.G_TRUE,
1782: x_msg_count => l_msg_count,
1783: x_msg_data => l_msg_data,
1784: p_restricted_update => OKC_API.G_TRUE,
1785: p_chrv_rec => L1_header_rec,
1786: x_chrv_rec => L2_header_rec);
1787: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1787: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1783: x_msg_data => l_msg_data,
1784: p_restricted_update => OKC_API.G_TRUE,
1785: p_chrv_rec => L1_header_rec,
1786: x_chrv_rec => L2_header_rec);
1787: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1789: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_ERROR;
1791: END IF;

Line 1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1784: p_restricted_update => OKC_API.G_TRUE,
1785: p_chrv_rec => L1_header_rec,
1786: x_chrv_rec => L2_header_rec);
1787: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1789: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_ERROR;
1791: END IF;
1792:

Line 1789: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1785: p_chrv_rec => L1_header_rec,
1786: x_chrv_rec => L2_header_rec);
1787: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1789: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_ERROR;
1791: END IF;
1792:
1793: --end

Line 1790: RAISE OKC_API.G_EXCEPTION_ERROR;

1786: x_chrv_rec => L2_header_rec);
1787: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1789: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_ERROR;
1791: END IF;
1792:
1793: --end
1794: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 1794: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

1790: RAISE OKC_API.G_EXCEPTION_ERROR;
1791: END IF;
1792:
1793: --end
1794: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
1795: EXCEPTION
1796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1797: db_failed('OKC_APPROVE');
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1796: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1792:
1793: --end
1794: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
1795: EXCEPTION
1796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1797: db_failed('OKC_APPROVE');
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1799: (substr(l_api_name,1,26),
1800: G_PKG_NAME,

Line 1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1794: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
1795: EXCEPTION
1796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1797: db_failed('OKC_APPROVE');
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1799: (substr(l_api_name,1,26),
1800: G_PKG_NAME,
1801: 'OKC_API.G_RET_STS_ERROR',
1802: l_msg_count,

Line 1801: 'OKC_API.G_RET_STS_ERROR',

1797: db_failed('OKC_APPROVE');
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1799: (substr(l_api_name,1,26),
1800: G_PKG_NAME,
1801: 'OKC_API.G_RET_STS_ERROR',
1802: l_msg_count,
1803: l_msg_data,
1804: G_LEVEL);
1805: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1805: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1801: 'OKC_API.G_RET_STS_ERROR',
1802: l_msg_count,
1803: l_msg_data,
1804: G_LEVEL);
1805: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1806: db_failed('OKC_APPROVE');
1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1808: (substr(l_api_name,1,26),
1809: G_PKG_NAME,

Line 1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1803: l_msg_data,
1804: G_LEVEL);
1805: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1806: db_failed('OKC_APPROVE');
1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1808: (substr(l_api_name,1,26),
1809: G_PKG_NAME,
1810: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1811: l_msg_count,

Line 1810: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1806: db_failed('OKC_APPROVE');
1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1808: (substr(l_api_name,1,26),
1809: G_PKG_NAME,
1810: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1811: l_msg_count,
1812: l_msg_data,
1813: G_LEVEL);
1814: WHEN OTHERS THEN

Line 1816: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1812: l_msg_data,
1813: G_LEVEL);
1814: WHEN OTHERS THEN
1815: db_failed('OKC_APPROVE');
1816: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1817: (substr(l_api_name,1,26),
1818: G_PKG_NAME,
1819: 'OTHERS',
1820: l_msg_count,

Line 1852: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1848: from okc_k_headers_all_b
1849: where ID = p
1850: ;
1851: l_api_name CONSTANT VARCHAR2(30) := 'k_erase_approved';
1852: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1853: l_msg_count NUMBER;
1854: l_msg_data varchar2(2000);
1855: begin
1856:

Line 1862: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1858: open c1;
1859: fetch c1 into dummy;
1860: close c1;
1861: if (dummy = '?') then
1862: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1863: return;
1864: end if;
1865:
1866: --start

Line 1867: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

1863: return;
1864: end if;
1865:
1866: --start
1867: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1868: G_PKG_NAME,
1869: OKC_API.G_TRUE,
1870: l_api_version,
1871: l_api_version,

Line 1869: OKC_API.G_TRUE,

1865:
1866: --start
1867: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1868: G_PKG_NAME,
1869: OKC_API.G_TRUE,
1870: l_api_version,
1871: l_api_version,
1872: G_LEVEL,
1873: x_return_status);

Line 1874: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1870: l_api_version,
1871: l_api_version,
1872: G_LEVEL,
1873: x_return_status);
1874: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1875: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_ERROR;
1878: END IF;

Line 1875: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1871: l_api_version,
1872: G_LEVEL,
1873: x_return_status);
1874: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1875: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_ERROR;
1878: END IF;
1879:

Line 1876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1872: G_LEVEL,
1873: x_return_status);
1874: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1875: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_ERROR;
1878: END IF;
1879:
1880: --lock

Line 1877: RAISE OKC_API.G_EXCEPTION_ERROR;

1873: x_return_status);
1874: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1875: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_ERROR;
1878: END IF;
1879:
1880: --lock
1881: L1_header_rec.id := p_contract_id;

Line 1891: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1887: x_return_status => x_return_status,
1888: x_msg_count => l_msg_count,
1889: x_msg_data => l_msg_data,
1890: p_chrv_rec => L1_header_rec);
1891: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;

Line 1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1888: x_msg_count => l_msg_count,
1889: x_msg_data => l_msg_data,
1890: p_chrv_rec => L1_header_rec);
1891: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896:

Line 1893: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1889: x_msg_data => l_msg_data,
1890: p_chrv_rec => L1_header_rec);
1891: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896:
1897: --update

Line 1894: RAISE OKC_API.G_EXCEPTION_ERROR;

1890: p_chrv_rec => L1_header_rec);
1891: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896:
1897: --update
1898: L1_header_rec.date_approved := NULL;

Line 1904: p_restricted_update => OKC_API.G_TRUE,

1900: p_api_version => l_api_version,
1901: x_return_status => x_return_status,
1902: x_msg_count => l_msg_count,
1903: x_msg_data => l_msg_data,
1904: p_restricted_update => OKC_API.G_TRUE,
1905: p_chrv_rec => L1_header_rec,
1906: x_chrv_rec => L2_header_rec);
1907: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1907: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1903: x_msg_data => l_msg_data,
1904: p_restricted_update => OKC_API.G_TRUE,
1905: p_chrv_rec => L1_header_rec,
1906: x_chrv_rec => L2_header_rec);
1907: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1910: RAISE OKC_API.G_EXCEPTION_ERROR;
1911: END IF;

Line 1908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1904: p_restricted_update => OKC_API.G_TRUE,
1905: p_chrv_rec => L1_header_rec,
1906: x_chrv_rec => L2_header_rec);
1907: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1910: RAISE OKC_API.G_EXCEPTION_ERROR;
1911: END IF;
1912:

Line 1909: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1905: p_chrv_rec => L1_header_rec,
1906: x_chrv_rec => L2_header_rec);
1907: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1910: RAISE OKC_API.G_EXCEPTION_ERROR;
1911: END IF;
1912:
1913: --end

Line 1910: RAISE OKC_API.G_EXCEPTION_ERROR;

1906: x_chrv_rec => L2_header_rec);
1907: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1909: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1910: RAISE OKC_API.G_EXCEPTION_ERROR;
1911: END IF;
1912:
1913: --end
1914: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 1914: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

1910: RAISE OKC_API.G_EXCEPTION_ERROR;
1911: END IF;
1912:
1913: --end
1914: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
1915: EXCEPTION
1916: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1917: db_failed('OKC_REVOKE');
1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1916: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1912:
1913: --end
1914: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
1915: EXCEPTION
1916: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1917: db_failed('OKC_REVOKE');
1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1919: (substr(l_api_name,1,26),
1920: G_PKG_NAME,

Line 1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1914: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
1915: EXCEPTION
1916: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1917: db_failed('OKC_REVOKE');
1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1919: (substr(l_api_name,1,26),
1920: G_PKG_NAME,
1921: 'OKC_API.G_RET_STS_ERROR',
1922: l_msg_count,

Line 1921: 'OKC_API.G_RET_STS_ERROR',

1917: db_failed('OKC_REVOKE');
1918: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1919: (substr(l_api_name,1,26),
1920: G_PKG_NAME,
1921: 'OKC_API.G_RET_STS_ERROR',
1922: l_msg_count,
1923: l_msg_data,
1924: G_LEVEL);
1925: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1925: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1921: 'OKC_API.G_RET_STS_ERROR',
1922: l_msg_count,
1923: l_msg_data,
1924: G_LEVEL);
1925: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1926: db_failed('OKC_REVOKE');
1927: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1928: (substr(l_api_name,1,26),
1929: G_PKG_NAME,

Line 1927: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1923: l_msg_data,
1924: G_LEVEL);
1925: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1926: db_failed('OKC_REVOKE');
1927: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1928: (substr(l_api_name,1,26),
1929: G_PKG_NAME,
1930: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1931: l_msg_count,

Line 1930: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1926: db_failed('OKC_REVOKE');
1927: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1928: (substr(l_api_name,1,26),
1929: G_PKG_NAME,
1930: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1931: l_msg_count,
1932: l_msg_data,
1933: G_LEVEL);
1934: WHEN OTHERS THEN

Line 1936: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1932: l_msg_data,
1933: G_LEVEL);
1934: WHEN OTHERS THEN
1935: db_failed('OKC_REVOKE');
1936: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1937: (substr(l_api_name,1,26),
1938: G_PKG_NAME,
1939: 'OTHERS',
1940: l_msg_count,

Line 1961: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1957: p_complete_k_prcs IN VARCHAR2 default 'Y',
1958: x_return_status OUT NOCOPY VARCHAR2
1959: ) is
1960: l_api_name CONSTANT VARCHAR2(30) := 'k_signed';
1961: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1962: l_msg_count NUMBER;
1963: l_msg_data varchar2(2000);
1964:
1965: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

Line 2022: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

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),
2023: G_PKG_NAME,
2024: OKC_API.G_TRUE,
2025: l_api_version,
2026: l_api_version,

Line 2024: OKC_API.G_TRUE,

2020: END IF;
2021: --start
2022: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2023: G_PKG_NAME,
2024: OKC_API.G_TRUE,
2025: l_api_version,
2026: l_api_version,
2027: G_LEVEL,
2028: x_return_status);

Line 2029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2025: l_api_version,
2026: l_api_version,
2027: G_LEVEL,
2028: x_return_status);
2029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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;

Line 2030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2026: l_api_version,
2027: G_LEVEL,
2028: x_return_status);
2029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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

Line 2031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2027: G_LEVEL,
2028: x_return_status);
2029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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,

Line 2032: RAISE OKC_API.G_EXCEPTION_ERROR;

2028: x_return_status);
2029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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);

Line 2036: 'OKC_API.START_ACTIVITY return status '||l_return_status);

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.
2040: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(p_chr_id => p_contract_id) ;

Line 2064: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
2066: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_ERROR;
2068: END IF;

Line 2065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
2066: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_ERROR;
2068: END IF;
2069:

Line 2066: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
2066: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_ERROR;
2068: END IF;
2069:
2070: --update header

Line 2067: RAISE OKC_API.G_EXCEPTION_ERROR;

2063: END IF;
2064: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_ERROR;
2068: END IF;
2069:
2070: --update header
2071: L1_header_rec.date_signed := p_date_signed;

Line 2121: p_restricted_update => OKC_API.G_TRUE,

2117: p_api_version => l_api_version,
2118: x_return_status => x_return_status,
2119: x_msg_count => l_msg_count,
2120: x_msg_data => l_msg_data,
2121: p_restricted_update => OKC_API.G_TRUE,
2122: p_chrv_rec => L1_header_rec,
2123: x_chrv_rec => L2_header_rec);
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2120: x_msg_data => l_msg_data,
2121: p_restricted_update => OKC_API.G_TRUE,
2122: p_chrv_rec => L1_header_rec,
2123: x_chrv_rec => L2_header_rec);
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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;

Line 2125: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2121: p_restricted_update => OKC_API.G_TRUE,
2122: p_chrv_rec => L1_header_rec,
2123: x_chrv_rec => L2_header_rec);
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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

Line 2126: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2122: p_chrv_rec => L1_header_rec,
2123: x_chrv_rec => L2_header_rec);
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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',

Line 2127: RAISE OKC_API.G_EXCEPTION_ERROR;

2123: x_chrv_rec => L2_header_rec);
2124: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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||')');

Line 2225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2221: x_return_status => x_return_status,
2222: x_msg_count => l_msg_count,
2223: x_msg_data => l_msg_data,
2224: p_clev_tbl => l1_lines);
2225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2228: RAISE OKC_API.G_EXCEPTION_ERROR;
2229: END IF;

Line 2226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2222: x_msg_count => l_msg_count,
2223: x_msg_data => l_msg_data,
2224: p_clev_tbl => l1_lines);
2225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2228: RAISE OKC_API.G_EXCEPTION_ERROR;
2229: END IF;
2230:

Line 2227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2223: x_msg_data => l_msg_data,
2224: p_clev_tbl => l1_lines);
2225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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

Line 2228: RAISE OKC_API.G_EXCEPTION_ERROR;

2224: p_clev_tbl => l1_lines);
2225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
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',

Line 2241: p_restricted_update => OKC_API.G_TRUE,

2237: p_api_version => l_api_version,
2238: x_return_status => x_return_status,
2239: x_msg_count => l_msg_count,
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',

Line 2248: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
2250: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2251: RAISE OKC_API.G_EXCEPTION_ERROR;
2252: END IF;

Line 2249: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
2250: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2251: RAISE OKC_API.G_EXCEPTION_ERROR;
2252: END IF;
2253:

Line 2250: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
2250: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2251: RAISE OKC_API.G_EXCEPTION_ERROR;
2252: END IF;
2253:
2254: END IF; --of IF (L1_header_rec.scs_code IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION')) THEN

Line 2251: RAISE OKC_API.G_EXCEPTION_ERROR;

2247: END IF;
2248: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2249: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2250: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2251: RAISE OKC_API.G_EXCEPTION_ERROR;
2252: END IF;
2253:
2254: END IF; --of IF (L1_header_rec.scs_code IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION')) THEN
2255:

Line 2261: OKC_TIME_RES_PUB.Res_Time_New_K(L2_header_rec.id, l_api_version,OKC_API.G_FALSE,x_return_status);

2257:
2258: /* Commented for bug 5069035. Not used in R12 and commenting out to avoid performance overhead.
2259: -- call time ...
2260: if (call_time = 'Y') then
2261: OKC_TIME_RES_PUB.Res_Time_New_K(L2_header_rec.id, l_api_version,OKC_API.G_FALSE,x_return_status);
2262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2258: /* Commented for bug 5069035. Not used in R12 and commenting out to avoid performance overhead.
2259: -- call time ...
2260: if (call_time = 'Y') then
2261: OKC_TIME_RES_PUB.Res_Time_New_K(L2_header_rec.id, l_api_version,OKC_API.G_FALSE,x_return_status);
2262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;

Line 2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2259: -- call time ...
2260: if (call_time = 'Y') then
2261: OKC_TIME_RES_PUB.Res_Time_New_K(L2_header_rec.id, l_api_version,OKC_API.G_FALSE,x_return_status);
2262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;
2267: end if;

Line 2264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2260: if (call_time = 'Y') then
2261: OKC_TIME_RES_PUB.Res_Time_New_K(L2_header_rec.id, l_api_version,OKC_API.G_FALSE,x_return_status);
2262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;
2267: end if;
2268: */

Line 2265: RAISE OKC_API.G_EXCEPTION_ERROR;

2261: OKC_TIME_RES_PUB.Res_Time_New_K(L2_header_rec.id, l_api_version,OKC_API.G_FALSE,x_return_status);
2262: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2265: RAISE OKC_API.G_EXCEPTION_ERROR;
2266: END IF;
2267: end if;
2268: */
2269:

Line 2289: ,p_init_msg_list => OKC_API.G_FALSE

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
2289: ,p_init_msg_list => OKC_API.G_FALSE
2290: ,p_chr_id => p_contract_id
2291: ,p_operation_code => 'UPDATE'
2292: ,p_termination_date => Null
2293: ,x_return_status => x_return_status

Line 2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;

Line 2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;
2306: END IF;

Line 2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2299: END IF;
2300:
2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;
2306: END IF;
2307:

Line 2304: RAISE OKC_API.G_EXCEPTION_ERROR;

2300:
2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;
2306: END IF;
2307:
2308: END IF;

Line 2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;

Line 2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;
2332:

Line 2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;
2332:
2333: --end

Line 2330: RAISE OKC_API.G_EXCEPTION_ERROR;

2326: END IF;
2327: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2328: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2329: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2330: RAISE OKC_API.G_EXCEPTION_ERROR;
2331: END IF;
2332:
2333: --end
2334:

Line 2344: p_init_msg_list => OKC_API.G_FALSE,

2340: END IF;
2341: continue_k_process
2342: (
2343: p_api_version => l_api_version,
2344: p_init_msg_list => OKC_API.G_FALSE,
2345: x_return_status => x_return_status,
2346: x_msg_count => l_msg_count,
2347: x_msg_data => l_msg_data,
2348: p_contract_id => p_contract_id,

Line 2356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;
2358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2359: RAISE OKC_API.G_EXCEPTION_ERROR;
2360: END IF;

Line 2357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;
2358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2359: RAISE OKC_API.G_EXCEPTION_ERROR;
2360: END IF;
2361: END IF;

Line 2358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;
2358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2359: RAISE OKC_API.G_EXCEPTION_ERROR;
2360: END IF;
2361: END IF;
2362:

Line 2359: RAISE OKC_API.G_EXCEPTION_ERROR;

2355: END IF;
2356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2359: RAISE OKC_API.G_EXCEPTION_ERROR;
2360: END IF;
2361: END IF;
2362:
2363: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 2363: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

2359: RAISE OKC_API.G_EXCEPTION_ERROR;
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;

Line 2369: WHEN OKC_API.G_EXCEPTION_ERROR 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
2370: db_failed('OKC_SIGN');
2371: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2372: (substr(l_api_name,1,26),
2373: G_PKG_NAME,

Line 2371: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2367: END IF;
2368: EXCEPTION
2369: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2370: db_failed('OKC_SIGN');
2371: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2372: (substr(l_api_name,1,26),
2373: G_PKG_NAME,
2374: 'OKC_API.G_RET_STS_ERROR',
2375: l_msg_count,

Line 2374: 'OKC_API.G_RET_STS_ERROR',

2370: db_failed('OKC_SIGN');
2371: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2372: (substr(l_api_name,1,26),
2373: G_PKG_NAME,
2374: 'OKC_API.G_RET_STS_ERROR',
2375: l_msg_count,
2376: l_msg_data,
2377: G_LEVEL);
2378: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2378: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2374: 'OKC_API.G_RET_STS_ERROR',
2375: l_msg_count,
2376: l_msg_data,
2377: G_LEVEL);
2378: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2379: db_failed('OKC_SIGN');
2380: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2381: (substr(l_api_name,1,26),
2382: G_PKG_NAME,

Line 2380: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2376: l_msg_data,
2377: G_LEVEL);
2378: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2379: db_failed('OKC_SIGN');
2380: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2381: (substr(l_api_name,1,26),
2382: G_PKG_NAME,
2383: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2384: l_msg_count,

Line 2383: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2379: db_failed('OKC_SIGN');
2380: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2381: (substr(l_api_name,1,26),
2382: G_PKG_NAME,
2383: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2384: l_msg_count,
2385: l_msg_data,
2386: G_LEVEL);
2387: WHEN OTHERS THEN

Line 2389: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2385: l_msg_data,
2386: G_LEVEL);
2387: WHEN OTHERS THEN
2388: db_failed('OKC_SIGN');
2389: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2390: (substr(l_api_name,1,26),
2391: G_PKG_NAME,
2392: 'OTHERS',
2393: l_msg_count,

Line 2410: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2406: p_contract_id IN number,
2407: x_return_status OUT NOCOPY VARCHAR2 ) is
2408: --
2409: l_api_name CONSTANT VARCHAR2(30) := 'activate_template';
2410: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2411: l_msg_count NUMBER;
2412: l_msg_data varchar2(2000);
2413: --
2414: L1_header_rec OKC_CONTRACT_PUB.chrv_rec_type;

Line 2426: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

2422: l_active_status varchar2(30) := 'ACTIVE';
2423:
2424: begin
2425:
2426: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2427: G_PKG_NAME,
2428: OKC_API.G_TRUE,
2429: l_api_version,
2430: l_api_version,

Line 2428: OKC_API.G_TRUE,

2424: begin
2425:
2426: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2427: G_PKG_NAME,
2428: OKC_API.G_TRUE,
2429: l_api_version,
2430: l_api_version,
2431: G_LEVEL,
2432: x_return_status);

Line 2434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2430: l_api_version,
2431: G_LEVEL,
2432: x_return_status);
2433:
2434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2436: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_ERROR;
2438: END IF;

Line 2435: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2431: G_LEVEL,
2432: x_return_status);
2433:
2434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2436: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_ERROR;
2438: END IF;
2439:

Line 2436: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2432: x_return_status);
2433:
2434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2436: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_ERROR;
2438: END IF;
2439:
2440: --lock header

Line 2437: RAISE OKC_API.G_EXCEPTION_ERROR;

2433:
2434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2436: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_ERROR;
2438: END IF;
2439:
2440: --lock header
2441: L1_header_rec.id := p_contract_id;

Line 2452: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2448: x_return_status => x_return_status,
2449: x_msg_count => l_msg_count,
2450: x_msg_data => l_msg_data,
2451: p_chrv_rec => L1_header_rec);
2452: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2454: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2455: RAISE OKC_API.G_EXCEPTION_ERROR;
2456: END IF;

Line 2453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2449: x_msg_count => l_msg_count,
2450: x_msg_data => l_msg_data,
2451: p_chrv_rec => L1_header_rec);
2452: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2454: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2455: RAISE OKC_API.G_EXCEPTION_ERROR;
2456: END IF;
2457:

Line 2454: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2450: x_msg_data => l_msg_data,
2451: p_chrv_rec => L1_header_rec);
2452: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2454: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2455: RAISE OKC_API.G_EXCEPTION_ERROR;
2456: END IF;
2457:
2458:

Line 2455: RAISE OKC_API.G_EXCEPTION_ERROR;

2451: p_chrv_rec => L1_header_rec);
2452: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2454: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2455: RAISE OKC_API.G_EXCEPTION_ERROR;
2456: END IF;
2457:
2458:
2459:

Line 2467: p_restricted_update => OKC_API.G_TRUE,

2463: p_api_version => l_api_version,
2464: x_return_status => x_return_status,
2465: x_msg_count => l_msg_count,
2466: x_msg_data => l_msg_data,
2467: p_restricted_update => OKC_API.G_TRUE,
2468: p_chrv_rec => L1_header_rec,
2469: x_chrv_rec => L2_header_rec);
2470:
2471: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2471: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2467: p_restricted_update => OKC_API.G_TRUE,
2468: p_chrv_rec => L1_header_rec,
2469: x_chrv_rec => L2_header_rec);
2470:
2471: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2473: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_ERROR;
2475: END IF;

Line 2472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2468: p_chrv_rec => L1_header_rec,
2469: x_chrv_rec => L2_header_rec);
2470:
2471: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2473: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_ERROR;
2475: END IF;
2476:

Line 2473: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2469: x_chrv_rec => L2_header_rec);
2470:
2471: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2473: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_ERROR;
2475: END IF;
2476:
2477: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

Line 2474: RAISE OKC_API.G_EXCEPTION_ERROR;

2470:
2471: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2473: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_ERROR;
2475: END IF;
2476:
2477: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
2478:

Line 2477: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

2473: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_ERROR;
2475: END IF;
2476:
2477: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
2478:
2479: EXCEPTION
2480: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2481: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2480: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2476:
2477: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
2478:
2479: EXCEPTION
2480: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2481: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2482: (substr(l_api_name,1,26),
2483: G_PKG_NAME,
2484: 'OKC_API.G_RET_STS_ERROR',

Line 2481: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2477: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
2478:
2479: EXCEPTION
2480: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2481: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2482: (substr(l_api_name,1,26),
2483: G_PKG_NAME,
2484: 'OKC_API.G_RET_STS_ERROR',
2485: l_msg_count,

Line 2484: 'OKC_API.G_RET_STS_ERROR',

2480: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2481: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2482: (substr(l_api_name,1,26),
2483: G_PKG_NAME,
2484: 'OKC_API.G_RET_STS_ERROR',
2485: l_msg_count,
2486: l_msg_data,
2487: G_LEVEL);
2488: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2488: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2484: 'OKC_API.G_RET_STS_ERROR',
2485: l_msg_count,
2486: l_msg_data,
2487: G_LEVEL);
2488: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2490: (substr(l_api_name,1,26),
2491: G_PKG_NAME,
2492: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2485: l_msg_count,
2486: l_msg_data,
2487: G_LEVEL);
2488: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2490: (substr(l_api_name,1,26),
2491: G_PKG_NAME,
2492: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2493: l_msg_count,

Line 2492: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2488: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2489: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2490: (substr(l_api_name,1,26),
2491: G_PKG_NAME,
2492: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2493: l_msg_count,
2494: l_msg_data,
2495: G_LEVEL);
2496: WHEN OTHERS THEN

Line 2497: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2493: l_msg_count,
2494: l_msg_data,
2495: G_LEVEL);
2496: WHEN OTHERS THEN
2497: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2498: (substr(l_api_name,1,26),
2499: G_PKG_NAME,
2500: 'OTHERS',
2501: l_msg_count,