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.OKS_CHANGE_STATUS_PVT dependencies on FND_API

Line 16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

12: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
13: ------------------------------------------------------------------------------
14: -- GLOBAL CONSTANTS
15: ------------------------------------------------------------------------------
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: g_api_version constant number :=1;
20: g_init_msg_list varchar2(1) := 'T';

Line 17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

13: ------------------------------------------------------------------------------
14: -- GLOBAL CONSTANTS
15: ------------------------------------------------------------------------------
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: g_api_version constant number :=1;
20: g_init_msg_list varchar2(1) := 'T';
21: g_msg_count NUMBER;

Line 79: raise FND_API.G_EXC_ERROR;

75: '100: Entered UPDATE_HEADER_STATUS');
76: END IF;
77:
78: if ((p_new_sts_code is NULL) OR (p_id is null) OR (p_canc_reason_code is NULL)) then
79: raise FND_API.G_EXC_ERROR;
80: end if;
81:
82: if (p_init_msg_list = FND_API.G_TRUE) then
83: fnd_msg_pub.initialize();

Line 82: if (p_init_msg_list = FND_API.G_TRUE) then

78: if ((p_new_sts_code is NULL) OR (p_id is null) OR (p_canc_reason_code is NULL)) then
79: raise FND_API.G_EXC_ERROR;
80: end if;
81:
82: if (p_init_msg_list = FND_API.G_TRUE) then
83: fnd_msg_pub.initialize();
84: end if;
85:
86: l_new_sts_code := p_new_sts_code;

Line 116: raise FND_API.G_EXC_ERROR;

112: l_new_ste_code := null;
113: End if;
114: close get_ste_code_hook;
115: ELSIF x_hook = -1 THEN
116: raise FND_API.G_EXC_ERROR;
117: END IF;
118:
119: /*Added for bug 13024593*/
120:

Line 132: if (x_return_status = FND_API.G_RET_STS_ERROR) then

128: p_new_ste_code => l_new_ste_code,
129: p_cle_id => NULL);
130:
131:
132: if (x_return_status = FND_API.G_RET_STS_ERROR) then
133: raise FND_API.G_EXC_ERROR;
134: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
135: raise FND_API.G_EXC_UNEXPECTED_ERROR;
136: end if;

Line 133: raise FND_API.G_EXC_ERROR;

129: p_cle_id => NULL);
130:
131:
132: if (x_return_status = FND_API.G_RET_STS_ERROR) then
133: raise FND_API.G_EXC_ERROR;
134: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
135: raise FND_API.G_EXC_UNEXPECTED_ERROR;
136: end if;
137:

Line 134: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

130:
131:
132: if (x_return_status = FND_API.G_RET_STS_ERROR) then
133: raise FND_API.G_EXC_ERROR;
134: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
135: raise FND_API.G_EXC_UNEXPECTED_ERROR;
136: end if;
137:
138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 135: raise FND_API.G_EXC_UNEXPECTED_ERROR;

131:
132: if (x_return_status = FND_API.G_RET_STS_ERROR) then
133: raise FND_API.G_EXC_ERROR;
134: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
135: raise FND_API.G_EXC_UNEXPECTED_ERROR;
136: end if;
137:
138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 173: p_init_msg_list => FND_API.G_FALSE,

169:
170: Update_header_status( x_return_status => x_return_status,
171: x_msg_data => x_msg_data,
172: x_msg_count => x_msg_count,
173: p_init_msg_list => FND_API.G_FALSE,
174: p_chrv_tbl => l_chrv_tbl,
175: p_canc_reason_code => p_canc_reason_code,
176: p_comments => p_comments,
177: p_term_cancel_source => p_term_cancel_source,

Line 180: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

176: p_comments => p_comments,
177: p_term_cancel_source => p_term_cancel_source,
178: p_date_cancelled => p_date_cancelled);
179:
180: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
183: raise FND_API.G_EXC_ERROR;
184: end if;

Line 181: raise FND_API.G_EXC_UNEXPECTED_ERROR;

177: p_term_cancel_source => p_term_cancel_source,
178: p_date_cancelled => p_date_cancelled);
179:
180: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
183: raise FND_API.G_EXC_ERROR;
184: end if;
185:

Line 182: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then

178: p_date_cancelled => p_date_cancelled);
179:
180: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
183: raise FND_API.G_EXC_ERROR;
184: end if;
185:
186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 183: raise FND_API.G_EXC_ERROR;

179:
180: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
183: raise FND_API.G_EXC_ERROR;
184: end if;
185:
186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 191: x_return_status := FND_API.G_RET_STS_SUCCESS;

187: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
188: '170: Completed Update_header_status succesfully');
189: END IF;
190:
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: Exception
194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;

Line 194: WHEN FND_API.G_EXC_ERROR THEN

190:
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: Exception
194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: Exception
194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
199: END IF;

Line 198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
199: END IF;
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

197: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
199: END IF;
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203:
204: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
199: END IF;
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203:
204: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
206: END IF;

Line 205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203:
204: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
206: END IF;
207:
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
206: END IF;
207:
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
210:
211: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
212: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
213: END IF;

Line 262: if (p_init_msg_list = FND_API.G_TRUE) then

258:
259: begin
260: p_count := p_chrv_tbl.count;
261:
262: if (p_init_msg_list = FND_API.G_TRUE) then
263: fnd_msg_pub.initialize();
264: end if;
265:
266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 303: if (x_return_status = FND_API.G_RET_STS_ERROR) then

299: p_chrv_tbl(i).old_sts_code,
300: l_cle_id,
301: p_validate_status);
302:
303: if (x_return_status = FND_API.G_RET_STS_ERROR) then
304: raise FND_API.G_EXC_ERROR;
305: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307: end if;

Line 304: raise FND_API.G_EXC_ERROR;

300: l_cle_id,
301: p_validate_status);
302:
303: if (x_return_status = FND_API.G_RET_STS_ERROR) then
304: raise FND_API.G_EXC_ERROR;
305: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307: end if;
308: l_valid_flag := 'Y';

Line 305: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

301: p_validate_status);
302:
303: if (x_return_status = FND_API.G_RET_STS_ERROR) then
304: raise FND_API.G_EXC_ERROR;
305: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307: end if;
308: l_valid_flag := 'Y';
309:

Line 306: raise FND_API.G_EXC_UNEXPECTED_ERROR;

302:
303: if (x_return_status = FND_API.G_RET_STS_ERROR) then
304: raise FND_API.G_EXC_ERROR;
305: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
306: raise FND_API.G_EXC_UNEXPECTED_ERROR;
307: end if;
308: l_valid_flag := 'Y';
309:
310: EXCEPTION

Line 311: WHEN FND_API.G_EXC_ERROR then

307: end if;
308: l_valid_flag := 'Y';
309:
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR then
312: l_valid_flag := 'N';
313: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name, FND_MSG_PUB.Get('F', 1));
315: END IF;

Line 351: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then

347: x_msg_count => g_msg_count,
348: x_msg_data => g_msg_data,
349: p_chrv_rec => p_chrv_tbl(i));
350:
351: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
354: RAISE FND_API.G_EXC_ERROR;
355: end if;

Line 352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

348: x_msg_data => g_msg_data,
349: p_chrv_rec => p_chrv_tbl(i));
350:
351: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
354: RAISE FND_API.G_EXC_ERROR;
355: end if;
356:

Line 353: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then

349: p_chrv_rec => p_chrv_tbl(i));
350:
351: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
354: RAISE FND_API.G_EXC_ERROR;
355: end if;
356:
357: --end of 5710909

Line 354: RAISE FND_API.G_EXC_ERROR;

350:
351: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
354: RAISE FND_API.G_EXC_ERROR;
355: end if;
356:
357: --end of 5710909
358:

Line 371: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then

367: p_control_rec => p_control_rec,
368: x_chrv_rec => l_chrv_tbl(i));
369:
370:
371: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
374: RAISE FND_API.G_EXC_ERROR;
375: end if;

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: x_chrv_rec => l_chrv_tbl(i));
369:
370:
371: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
374: RAISE FND_API.G_EXC_ERROR;
375: end if;
376:

Line 373: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then

369:
370:
371: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
374: RAISE FND_API.G_EXC_ERROR;
375: end if;
376:
377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 374: RAISE FND_API.G_EXC_ERROR;

370:
371: if (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
374: RAISE FND_API.G_EXC_ERROR;
375: end if;
376:
377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 404: If (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

400: p_date_cancelled => p_date_cancelled,
401: p_comments => p_comments,
402: p_validate_status => 'N');
403:
404: If (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: elsIf (x_return_status = FND_API.G_RET_STS_ERROR) then
407: RAISE FND_API.G_EXC_ERROR;
408: End if;

Line 405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

401: p_comments => p_comments,
402: p_validate_status => 'N');
403:
404: If (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: elsIf (x_return_status = FND_API.G_RET_STS_ERROR) then
407: RAISE FND_API.G_EXC_ERROR;
408: End if;
409:

Line 406: elsIf (x_return_status = FND_API.G_RET_STS_ERROR) then

402: p_validate_status => 'N');
403:
404: If (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: elsIf (x_return_status = FND_API.G_RET_STS_ERROR) then
407: RAISE FND_API.G_EXC_ERROR;
408: End if;
409:
410: -- Call API for Cleaning the Renewal links which are due to

Line 407: RAISE FND_API.G_EXC_ERROR;

403:
404: If (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: elsIf (x_return_status = FND_API.G_RET_STS_ERROR) then
407: RAISE FND_API.G_EXC_ERROR;
408: End if;
409:
410: -- Call API for Cleaning the Renewal links which are due to
411: -- cancel action on the contract.

Line 428: if (x_return_status = FND_API.G_RET_STS_ERROR) then

424: x_return_status => x_return_status,
425: x_msg_count => x_msg_count,
426: x_msg_data => x_msg_data);
427:
428: if (x_return_status = FND_API.G_RET_STS_ERROR) then
429: Raise FND_API.G_EXC_ERROR;
430: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
431: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
432: end if;

Line 429: Raise FND_API.G_EXC_ERROR;

425: x_msg_count => x_msg_count,
426: x_msg_data => x_msg_data);
427:
428: if (x_return_status = FND_API.G_RET_STS_ERROR) then
429: Raise FND_API.G_EXC_ERROR;
430: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
431: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
432: end if;
433: END IF; -- Renewed_YN

Line 430: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

426: x_msg_data => x_msg_data);
427:
428: if (x_return_status = FND_API.G_RET_STS_ERROR) then
429: Raise FND_API.G_EXC_ERROR;
430: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
431: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
432: end if;
433: END IF; -- Renewed_YN
434:

Line 431: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

427:
428: if (x_return_status = FND_API.G_RET_STS_ERROR) then
429: Raise FND_API.G_EXC_ERROR;
430: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
431: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
432: end if;
433: END IF; -- Renewed_YN
434:
435: -- Abort the Renewal workflow process as the contract is getting

Line 462: if (x_return_status = FND_API.G_RET_STS_ERROR) then

458: x_return_status => x_return_status,
459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data);
461:
462: if (x_return_status = FND_API.G_RET_STS_ERROR) then
463: Raise FND_API.G_EXC_ERROR;
464: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
465: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
466: end if;

Line 463: Raise FND_API.G_EXC_ERROR;

459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data);
461:
462: if (x_return_status = FND_API.G_RET_STS_ERROR) then
463: Raise FND_API.G_EXC_ERROR;
464: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
465: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
466: end if;
467:

Line 464: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

460: x_msg_data => x_msg_data);
461:
462: if (x_return_status = FND_API.G_RET_STS_ERROR) then
463: Raise FND_API.G_EXC_ERROR;
464: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
465: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
466: end if;
467:
468: -- End of Changed by MKS/SKK

Line 465: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

461:
462: if (x_return_status = FND_API.G_RET_STS_ERROR) then
463: Raise FND_API.G_EXC_ERROR;
464: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
465: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
466: end if;
467:
468: -- End of Changed by MKS/SKK
469: elsif (p_chrv_tbl(i).old_ste_code = 'CANCELLED' and p_chrv_tbl(i).new_ste_code = 'ENTERED') then

Line 486: if (x_return_status = FND_API.G_RET_STS_ERROR) then

482: x_return_status => x_return_status,
483: x_msg_count => x_msg_count,
484: x_msg_data => x_msg_data);
485:
486: if (x_return_status = FND_API.G_RET_STS_ERROR) then
487: Raise FND_API.G_EXC_ERROR;
488: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
489: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
490: end if;

Line 487: Raise FND_API.G_EXC_ERROR;

483: x_msg_count => x_msg_count,
484: x_msg_data => x_msg_data);
485:
486: if (x_return_status = FND_API.G_RET_STS_ERROR) then
487: Raise FND_API.G_EXC_ERROR;
488: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
489: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
490: end if;
491:

Line 488: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

484: x_msg_data => x_msg_data);
485:
486: if (x_return_status = FND_API.G_RET_STS_ERROR) then
487: Raise FND_API.G_EXC_ERROR;
488: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
489: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
490: end if;
491:
492: END IF; -- Renewed_YN

Line 489: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

485:
486: if (x_return_status = FND_API.G_RET_STS_ERROR) then
487: Raise FND_API.G_EXC_ERROR;
488: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
489: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
490: end if;
491:
492: END IF; -- Renewed_YN
493:

Line 522: if (x_return_status = FND_API.G_RET_STS_ERROR) then

518: x_return_status => x_return_status,
519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data);
521:
522: if (x_return_status = FND_API.G_RET_STS_ERROR) then
523: Raise FND_API.G_EXC_ERROR;
524: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
525: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
526: end if;

Line 523: Raise FND_API.G_EXC_ERROR;

519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data);
521:
522: if (x_return_status = FND_API.G_RET_STS_ERROR) then
523: Raise FND_API.G_EXC_ERROR;
524: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
525: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
526: end if;
527:

Line 524: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

520: x_msg_data => x_msg_data);
521:
522: if (x_return_status = FND_API.G_RET_STS_ERROR) then
523: Raise FND_API.G_EXC_ERROR;
524: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
525: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
526: end if;
527:
528: end if;

Line 525: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

521:
522: if (x_return_status = FND_API.G_RET_STS_ERROR) then
523: Raise FND_API.G_EXC_ERROR;
524: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
525: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
526: end if;
527:
528: end if;
529: end if; -- l_validate_flag

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
534: '485: exiting Update_header_status ');
535: END IF;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION
539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 539: WHEN FND_API.G_EXC_ERROR THEN

535: END IF;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION
539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541:
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');

Line 540: x_return_status := FND_API.G_RET_STS_ERROR ;

536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION
539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541:
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
544: END IF;

Line 543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');

539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541:
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
544: END IF;
545:
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
544: END IF;
545:
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
544: END IF;
545:
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
551: END IF;

Line 550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
551: END IF;
552:
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
551: END IF;
552:
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
555:
556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
558: END IF;

Line 627: Raise FND_API.G_EXC_ERROR;

623: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_1');
624: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));
625: fnd_message.set_token('RENEW_K',get_target_list(l_chr_id, p_cle_id));
626: fnd_msg_pub.add;
627: Raise FND_API.G_EXC_ERROR;
628: Elsif Is_Not_Entered_Cancelled(l_chr_id, p_cle_id) then
629: l_validate := 'N';
630: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_2');
631: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));

Line 634: Raise FND_API.G_EXC_ERROR;

630: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_2');
631: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));
632: fnd_message.set_token('RENEW_K',get_target_list(l_chr_id, p_cle_id));
633: fnd_msg_pub.add;
634: Raise FND_API.G_EXC_ERROR;
635: Else
636: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_3');
637: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));
638: fnd_msg_pub.add;

Line 653: x_return_status := FND_API.G_RET_STS_ERROR;

649: END IF; -- Renewed_YN
650:
651: -- This should be only for mass status change need to put if clause
652: If (p_old_sts_code = 'QA_HOLD') OR (p_old_sts_code = p_new_sts_code) Then
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: End If;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: ------------------------------

Line 656: x_return_status := FND_API.G_RET_STS_SUCCESS;

652: If (p_old_sts_code = 'QA_HOLD') OR (p_old_sts_code = p_new_sts_code) Then
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: End If;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: ------------------------------
658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 659: WHEN FND_API.G_EXC_ERROR THEN

655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: ------------------------------
658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
663: END IF;

Line 660: x_return_status := FND_API.G_RET_STS_ERROR ;

656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: ------------------------------
658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
663: END IF;
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
663: END IF;
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
663: END IF;
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
670: END IF;

Line 667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

663: END IF;
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
670: END IF;
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
670: END IF;
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
672:
673: WHEN OKC_API.G_EXC_WARNING THEN

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'330: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
682: END IF;
683:
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );
687: END IF;
688:

Line 1240: if (p_init_msg_list = FND_API.G_TRUE) then

1236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1237: '600: Entered UPDATE_LINE_STATUS');
1238: END IF;
1239:
1240: if (p_init_msg_list = FND_API.G_TRUE) then
1241: fnd_msg_pub.initialize();
1242: end if;
1243:
1244: if (p_count = 0) then

Line 1412: if (x_return_status = FND_API.G_RET_STS_ERROR) then

1408: l_clev_tbl(x_num).sts_code,
1409: l_clev_tbl(x_num).id,
1410: p_validate_status);
1411:
1412: if (x_return_status = FND_API.G_RET_STS_ERROR) then
1413: Raise FND_API.G_EXC_ERROR;
1414: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1416: elsif (x_return_status = OKC_API.G_RET_STS_WARNING) then

Line 1413: Raise FND_API.G_EXC_ERROR;

1409: l_clev_tbl(x_num).id,
1410: p_validate_status);
1411:
1412: if (x_return_status = FND_API.G_RET_STS_ERROR) then
1413: Raise FND_API.G_EXC_ERROR;
1414: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1416: elsif (x_return_status = OKC_API.G_RET_STS_WARNING) then
1417: Raise OKC_API.G_EXC_WARNING;

Line 1414: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1410: p_validate_status);
1411:
1412: if (x_return_status = FND_API.G_RET_STS_ERROR) then
1413: Raise FND_API.G_EXC_ERROR;
1414: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1416: elsif (x_return_status = OKC_API.G_RET_STS_WARNING) then
1417: Raise OKC_API.G_EXC_WARNING;
1418: end if;

Line 1415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1411:
1412: if (x_return_status = FND_API.G_RET_STS_ERROR) then
1413: Raise FND_API.G_EXC_ERROR;
1414: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1415: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1416: elsif (x_return_status = OKC_API.G_RET_STS_WARNING) then
1417: Raise OKC_API.G_EXC_WARNING;
1418: end if;
1419: end if; -- l_clev_tbl(x_num).lse_id

Line 1469: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1465: x_msg_count => x_msg_count,
1466: x_msg_data => x_msg_data,
1467: p_clev_tbl => l_clev_tbl);
1468:
1469: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1470: Raise FND_API.G_EXC_ERROR;
1471: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1473: End if;

Line 1470: Raise FND_API.G_EXC_ERROR;

1466: x_msg_data => x_msg_data,
1467: p_clev_tbl => l_clev_tbl);
1468:
1469: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1470: Raise FND_API.G_EXC_ERROR;
1471: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1473: End if;
1474: -- end of bug 5710909

Line 1471: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1467: p_clev_tbl => l_clev_tbl);
1468:
1469: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1470: Raise FND_API.G_EXC_ERROR;
1471: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1473: End if;
1474: -- end of bug 5710909
1475:

Line 1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1468:
1469: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1470: Raise FND_API.G_EXC_ERROR;
1471: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1473: End if;
1474: -- end of bug 5710909
1475:
1476: -- Call the API to update the contract line with

Line 1488: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1484: x_msg_data => x_msg_data,
1485: p_clev_tbl => l_clev_tbl,
1486: x_clev_tbl => l1_clev_tbl);
1487:
1488: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1489: Raise FND_API.G_EXC_ERROR;
1490: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1491: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: End if;

Line 1489: Raise FND_API.G_EXC_ERROR;

1485: p_clev_tbl => l_clev_tbl,
1486: x_clev_tbl => l1_clev_tbl);
1487:
1488: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1489: Raise FND_API.G_EXC_ERROR;
1490: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1491: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: End if;
1493:

Line 1490: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1486: x_clev_tbl => l1_clev_tbl);
1487:
1488: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1489: Raise FND_API.G_EXC_ERROR;
1490: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1491: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: End if;
1493:
1494: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1491: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1487:
1488: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1489: Raise FND_API.G_EXC_ERROR;
1490: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1491: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: End if;
1493:
1494: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1495: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 1518: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1514: p_target_chr_id => p_id,
1515: p_target_line_id => p_cle_id,
1516: clean_relink_flag => 'CLEAN') ;
1517:
1518: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1519: Raise FND_API.G_EXC_ERROR;
1520: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1521: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1522: End if;

Line 1519: Raise FND_API.G_EXC_ERROR;

1515: p_target_line_id => p_cle_id,
1516: clean_relink_flag => 'CLEAN') ;
1517:
1518: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1519: Raise FND_API.G_EXC_ERROR;
1520: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1521: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1522: End if;
1523:

Line 1520: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1516: clean_relink_flag => 'CLEAN') ;
1517:
1518: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1519: Raise FND_API.G_EXC_ERROR;
1520: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1521: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1522: End if;
1523:
1524: elsif (p_old_ste_code = 'CANCELLED' and p_new_ste_code = 'ENTERED') then

Line 1521: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1517:
1518: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1519: Raise FND_API.G_EXC_ERROR;
1520: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1521: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1522: End if;
1523:
1524: elsif (p_old_ste_code = 'CANCELLED' and p_new_ste_code = 'ENTERED') then
1525:

Line 1540: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1536: p_target_chr_id => p_id,
1537: p_target_line_id => p_cle_id,
1538: clean_relink_flag => 'RELINK');
1539:
1540: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1541: Raise FND_API.G_EXC_ERROR;
1542: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1543: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1544: End if;

Line 1541: Raise FND_API.G_EXC_ERROR;

1537: p_target_line_id => p_cle_id,
1538: clean_relink_flag => 'RELINK');
1539:
1540: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1541: Raise FND_API.G_EXC_ERROR;
1542: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1543: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1544: End if;
1545:

Line 1542: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1538: clean_relink_flag => 'RELINK');
1539:
1540: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1541: Raise FND_API.G_EXC_ERROR;
1542: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1543: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1544: End if;
1545:
1546: end if; -- p_old_ste_code and p_new_ste_code

Line 1543: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1539:
1540: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1541: Raise FND_API.G_EXC_ERROR;
1542: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1543: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1544: End if;
1545:
1546: end if; -- p_old_ste_code and p_new_ste_code
1547:

Line 1579: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1575: x_msg_count => x_msg_count,
1576: x_msg_data => x_msg_data);
1577:
1578:
1579: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1580: Raise FND_API.G_EXC_ERROR;
1581: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1582: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1583: End if;

Line 1580: Raise FND_API.G_EXC_ERROR;

1576: x_msg_data => x_msg_data);
1577:
1578:
1579: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1580: Raise FND_API.G_EXC_ERROR;
1581: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1582: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1583: End if;
1584:

Line 1581: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1577:
1578:
1579: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1580: Raise FND_API.G_EXC_ERROR;
1581: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1582: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1583: End if;
1584:
1585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1582: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1578:
1579: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1580: Raise FND_API.G_EXC_ERROR;
1581: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1582: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1583: End if;
1584:
1585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 1602: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1598: x_msg_count => x_msg_count,
1599: x_msg_data => x_msg_data);
1600:
1601:
1602: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1603: Raise FND_API.G_EXC_ERROR;
1604: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1605: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1606: End if;

Line 1603: Raise FND_API.G_EXC_ERROR;

1599: x_msg_data => x_msg_data);
1600:
1601:
1602: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1603: Raise FND_API.G_EXC_ERROR;
1604: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1605: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1606: End if;
1607:

Line 1604: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1600:
1601:
1602: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1603: Raise FND_API.G_EXC_ERROR;
1604: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1605: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1606: End if;
1607:
1608: else

Line 1605: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1601:
1602: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1603: Raise FND_API.G_EXC_ERROR;
1604: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1605: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1606: End if;
1607:
1608: else
1609:

Line 1626: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1622: x_return_status => x_return_status,
1623: x_msg_count => x_msg_count,
1624: x_msg_data => x_msg_data);
1625:
1626: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1627: Raise FND_API.G_EXC_ERROR;
1628: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1629: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1630: End if;

Line 1627: Raise FND_API.G_EXC_ERROR;

1623: x_msg_count => x_msg_count,
1624: x_msg_data => x_msg_data);
1625:
1626: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1627: Raise FND_API.G_EXC_ERROR;
1628: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1629: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1630: End if;
1631:

Line 1628: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1624: x_msg_data => x_msg_data);
1625:
1626: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1627: Raise FND_API.G_EXC_ERROR;
1628: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1629: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1630: End if;
1631:
1632:

Line 1629: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1625:
1626: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1627: Raise FND_API.G_EXC_ERROR;
1628: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1629: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1630: End if;
1631:
1632:
1633: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1649: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1645: x_return_status => x_return_status,
1646: x_msg_count => x_msg_count,
1647: x_msg_data => x_msg_data);
1648:
1649: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1650: Raise FND_API.G_EXC_ERROR;
1651: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1652: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1653: End if;

Line 1650: Raise FND_API.G_EXC_ERROR;

1646: x_msg_count => x_msg_count,
1647: x_msg_data => x_msg_data);
1648:
1649: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1650: Raise FND_API.G_EXC_ERROR;
1651: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1652: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1653: End if;
1654:

Line 1651: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1647: x_msg_data => x_msg_data);
1648:
1649: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1650: Raise FND_API.G_EXC_ERROR;
1651: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1652: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1653: End if;
1654:
1655:

Line 1652: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1648:
1649: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1650: Raise FND_API.G_EXC_ERROR;
1651: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1652: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1653: End if;
1654:
1655:
1656: end if;

Line 1677: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1673: x_return_status => x_return_status,
1674: x_msg_count => x_msg_count,
1675: x_msg_data => x_msg_count);
1676:
1677: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1678: Raise FND_API.G_EXC_ERROR;
1679: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1680: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1681: End if;

Line 1678: Raise FND_API.G_EXC_ERROR;

1674: x_msg_count => x_msg_count,
1675: x_msg_data => x_msg_count);
1676:
1677: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1678: Raise FND_API.G_EXC_ERROR;
1679: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1680: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1681: End if;
1682:

Line 1679: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1675: x_msg_data => x_msg_count);
1676:
1677: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1678: Raise FND_API.G_EXC_ERROR;
1679: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1680: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1681: End if;
1682:
1683:

Line 1680: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1676:
1677: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1678: Raise FND_API.G_EXC_ERROR;
1679: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1680: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1681: End if;
1682:
1683:
1684:

Line 1732: If (x_return_status = FND_API.G_RET_STS_ERROR) then

1728: x_msg_data => x_msg_data,
1729: p_hstv_rec => l_hstv_rec,
1730: x_hstv_rec => x_hstv_rec);
1731:
1732: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1733: Raise FND_API.G_EXC_ERROR;
1734: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1735: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1736: End if;

Line 1733: Raise FND_API.G_EXC_ERROR;

1729: p_hstv_rec => l_hstv_rec,
1730: x_hstv_rec => x_hstv_rec);
1731:
1732: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1733: Raise FND_API.G_EXC_ERROR;
1734: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1735: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1736: End if;
1737: end if; -- call history API

Line 1734: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

1730: x_hstv_rec => x_hstv_rec);
1731:
1732: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1733: Raise FND_API.G_EXC_ERROR;
1734: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1735: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1736: End if;
1737: end if; -- call history API
1738:

Line 1735: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1731:
1732: If (x_return_status = FND_API.G_RET_STS_ERROR) then
1733: Raise FND_API.G_EXC_ERROR;
1734: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1735: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1736: End if;
1737: end if; -- call history API
1738:
1739: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1739: x_return_status := FND_API.G_RET_STS_SUCCESS;

1735: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1736: End if;
1737: end if; -- call history API
1738:
1739: x_return_status := FND_API.G_RET_STS_SUCCESS;
1740:
1741: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1743: '730: succesfully complete update_line_status ');

Line 1747: WHEN FND_API.G_EXC_ERROR THEN

1743: '730: succesfully complete update_line_status ');
1744: END IF;
1745:
1746: EXCEPTION
1747: WHEN FND_API.G_EXC_ERROR THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1751: END IF;

Line 1748: x_return_status := FND_API.G_RET_STS_ERROR;

1744: END IF;
1745:
1746: EXCEPTION
1747: WHEN FND_API.G_EXC_ERROR THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1751: END IF;
1752: if (c_lines%ISOPEN) then

Line 1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

1746: EXCEPTION
1747: WHEN FND_API.G_EXC_ERROR THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1751: END IF;
1752: if (c_lines%ISOPEN) then
1753: close c_lines;
1754: end if;

Line 1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1752: if (c_lines%ISOPEN) then
1753: close c_lines;
1754: end if;
1755:
1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1760: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

Line 1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1753: close c_lines;
1754: end if;
1755:
1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1760: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
1761: END IF;

Line 1760: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1760: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
1761: END IF;
1762:
1763: if (c_lines%ISOPEN) then
1764: close c_lines;

Line 1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1779: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'770: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1781: END IF;
1782:
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1784: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1786: END IF;
1787: if (c_lines%ISOPEN) then

Line 1864: raise FND_API.G_EXC_ERROR;

1860: /* skuchima bug12418261 */
1861: If ( p_old_ste_code = 'EXPIRED' AND l_new_ste_code <> 'EXPIRED' ) then
1862: fnd_message.set_name('OKS','OKS_CHANGE_STAT_NOT_ALLOWED'); -- Add a message name here and throw a exception
1863: fnd_msg_pub.add();
1864: raise FND_API.G_EXC_ERROR;
1865: end if;
1866:
1867: select 'Y' INTO l_allowed_status from dual where (l_new_sts_code,l_new_ste_code) in
1868: (select

Line 1914: x_return_status := FND_API.G_RET_STS_SUCCESS;

1910: AND ST.ENABLED_FLAG = 'Y'
1911: AND S.code <> l_old_sts_code
1912: AND l_old_ste_code='CANCELLED');
1913:
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: exception
1917:
1918: WHEN FND_API.G_EXC_ERROR then

Line 1918: WHEN FND_API.G_EXC_ERROR then

1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: exception
1917:
1918: WHEN FND_API.G_EXC_ERROR then
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1922: END IF;

Line 1919: x_return_status := FND_API.G_RET_STS_ERROR;

1915:
1916: exception
1917:
1918: WHEN FND_API.G_EXC_ERROR then
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1922: END IF;
1923:

Line 1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

1917:
1918: WHEN FND_API.G_EXC_ERROR then
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1922: END IF;
1923:
1924: WHEN NO_DATA_FOUND then
1925: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1925: x_return_status := FND_API.G_RET_STS_ERROR;

1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1922: END IF;
1923:
1924: WHEN NO_DATA_FOUND then
1925: x_return_status := FND_API.G_RET_STS_ERROR;
1926: FND_MESSAGE.set_name('OKS','OKS_CHANGE_STAT_NOT_ALLOWED'); -- set the message here
1927: fnd_msg_pub.add;
1928:
1929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1930: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT : NO_DATA_FOUND');
1931: END IF;
1932:
1933: WHEN OTHERS then
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1936: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'520: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1937: END IF;
1938:

Line 2068: raise FND_API.G_EXC_ERROR;

2064: '800: Entered UPDATE_CONTRACT_TAX_AMOUNT ');
2065: END IF;
2066:
2067: IF ((p_from_ste_code is NULL) OR (p_to_ste_code is NULL) OR (p_id is null)) THEN
2068: raise FND_API.G_EXC_ERROR;
2069: END IF;
2070:
2071: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 2386: If (x_return_status = FND_API.G_RET_STS_ERROR) then

2382: x_return_status => l_return_status,
2383: x_msg_count => l_msg_count,
2384: x_msg_data => l_msg_data);
2385:
2386: If (x_return_status = FND_API.G_RET_STS_ERROR) then
2387: Raise FND_API.G_EXC_ERROR;
2388: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2389: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2390: End if;

Line 2387: Raise FND_API.G_EXC_ERROR;

2383: x_msg_count => l_msg_count,
2384: x_msg_data => l_msg_data);
2385:
2386: If (x_return_status = FND_API.G_RET_STS_ERROR) then
2387: Raise FND_API.G_EXC_ERROR;
2388: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2389: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2390: End if;
2391:

Line 2388: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

2384: x_msg_data => l_msg_data);
2385:
2386: If (x_return_status = FND_API.G_RET_STS_ERROR) then
2387: Raise FND_API.G_EXC_ERROR;
2388: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2389: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2390: End if;
2391:
2392: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2389: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2385:
2386: If (x_return_status = FND_API.G_RET_STS_ERROR) then
2387: Raise FND_API.G_EXC_ERROR;
2388: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2389: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2390: End if;
2391:
2392: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2393: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 2418: x_return_status := FND_API.G_RET_STS_SUCCESS;

2414: Where chr_id = p_id;
2415:
2416: ---
2417:
2418: x_return_status := FND_API.G_RET_STS_SUCCESS;
2419:
2420: ---
2421: Exception
2422:

Line 2423: WHEN FND_API.G_EXC_ERROR THEN

2419:
2420: ---
2421: Exception
2422:
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

Line 2424: x_return_status := FND_API.G_RET_STS_ERROR;

2420: ---
2421: Exception
2422:
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2428: END IF;

Line 2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2428: END IF;
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2426: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2428: END IF;
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432:
2433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

Line 2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2428: END IF;
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432:
2433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2435: END IF;

Line 2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432:
2433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2435: END IF;
2436:
2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2435: END IF;
2436:
2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2439:
2440: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1320: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2442: END IF;

Line 2457: p_init_msg_list IN varchar2 default FND_API.G_FALSE,

2453: ---[llc] UPDATE_SUBSCRIPTION_TAX_AMOUNT updates all the tax_amount of toplines which are of type subscription
2454:
2455: PROCEDURE UPDATE_SUBSCRIPTION_TAX_AMOUNT(
2456: p_api_version IN NUMBER,
2457: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
2458: p_id IN NUMBER,
2459: x_return_status OUT NOCOPY VARCHAR2,
2460: x_msg_count OUT NOCOPY NUMBER,
2461: x_msg_data OUT NOCOPY VARCHAR2)

Line 2544: x_return_status := FND_API.G_RET_STS_SUCCESS;

2540: END IF;
2541:
2542: ---
2543:
2544: x_return_status := FND_API.G_RET_STS_SUCCESS;
2545:
2546: ---
2547: Exception
2548:

Line 2549: WHEN FND_API.G_EXC_ERROR THEN

2545:
2546: ---
2547: Exception
2548:
2549: WHEN FND_API.G_EXC_ERROR THEN
2550: x_return_status := FND_API.G_RET_STS_ERROR;
2551:
2552: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

Line 2550: x_return_status := FND_API.G_RET_STS_ERROR;

2546: ---
2547: Exception
2548:
2549: WHEN FND_API.G_EXC_ERROR THEN
2550: x_return_status := FND_API.G_RET_STS_ERROR;
2551:
2552: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2554: END IF;

Line 2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

2549: WHEN FND_API.G_EXC_ERROR THEN
2550: x_return_status := FND_API.G_RET_STS_ERROR;
2551:
2552: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2554: END IF;
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2552: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2554: END IF;
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

Line 2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2554: END IF;
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2561: END IF;

Line 2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2561: END IF;
2562:
2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2561: END IF;
2562:
2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2565:
2566: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1190: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2568: END IF;

Line 2606: If (l_return_status = FND_API.G_RET_STS_ERROR) then

2602: x_msg_count => x_msg_count,
2603: x_msg_data => x_msg_data,
2604: x_return_status => l_return_status);
2605:
2606: If (l_return_status = FND_API.G_RET_STS_ERROR) then
2607: Raise FND_API.G_EXC_ERROR;
2608: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2610: End if;

Line 2607: Raise FND_API.G_EXC_ERROR;

2603: x_msg_data => x_msg_data,
2604: x_return_status => l_return_status);
2605:
2606: If (l_return_status = FND_API.G_RET_STS_ERROR) then
2607: Raise FND_API.G_EXC_ERROR;
2608: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2610: End if;
2611:

Line 2608: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

2604: x_return_status => l_return_status);
2605:
2606: If (l_return_status = FND_API.G_RET_STS_ERROR) then
2607: Raise FND_API.G_EXC_ERROR;
2608: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2610: End if;
2611:
2612:

Line 2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2605:
2606: If (l_return_status = FND_API.G_RET_STS_ERROR) then
2607: Raise FND_API.G_EXC_ERROR;
2608: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2609: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2610: End if;
2611:
2612:
2613: If (l_return_status = 'S') then