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.OKE_CHANGE_STATUS_PUB dependencies on OKE_API

Line 16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;

12: ------------------------------------------------------------------------------
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
18:
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;

13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
18:
19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 23: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;

19: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
20: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
21: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
22:
23: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
24:
25: g_api_version constant number :=1;
26: g_init_msg_list varchar2(1) := 'T';
27: g_msg_count NUMBER;

Line 48: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

44: ) is
45:
46: l_api_name CONSTANT VARCHAR2(30) := 'Update_header_status';
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
49: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
50: i NUMBER:=0;
51: BEGIN
52: -- call START_ACTIVITY to create savepoint, check compatibility

Line 49: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

45:
46: l_api_name CONSTANT VARCHAR2(30) := 'Update_header_status';
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
49: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
50: i NUMBER:=0;
51: BEGIN
52: -- call START_ACTIVITY to create savepoint, check compatibility
53: -- and initialize message list

Line 54: l_return_status := OKE_API.START_ACTIVITY(

50: i NUMBER:=0;
51: BEGIN
52: -- call START_ACTIVITY to create savepoint, check compatibility
53: -- and initialize message list
54: l_return_status := OKE_API.START_ACTIVITY(
55: p_api_name => l_api_name,
56: p_pkg_name => g_pkg_name,
57: p_init_msg_list => p_init_msg_list,
58: l_api_version => l_api_version,

Line 64: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

60: p_api_type => g_api_type,
61: x_return_status => x_return_status);
62:
63: -- check if activity started successfully
64: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
65: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
67: raise OKE_API.G_EXCEPTION_ERROR;
68: End If;

Line 65: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

61: x_return_status => x_return_status);
62:
63: -- check if activity started successfully
64: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
65: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
67: raise OKE_API.G_EXCEPTION_ERROR;
68: End If;
69:

Line 66: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

62:
63: -- check if activity started successfully
64: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
65: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
67: raise OKE_API.G_EXCEPTION_ERROR;
68: End If;
69:
70: If (p_chr_sts_tbl.COUNT > 0) Then

Line 67: raise OKE_API.G_EXCEPTION_ERROR;

63: -- check if activity started successfully
64: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
65: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
67: raise OKE_API.G_EXCEPTION_ERROR;
68: End If;
69:
70: If (p_chr_sts_tbl.COUNT > 0) Then
71: i := p_chr_sts_tbl.FIRST;

Line 83: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then

79: x_msg_data => x_msg_data,
80: p_chr_sts_rec => p_chr_sts_tbl(i)
81: );
82:
83: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then
84: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
85: l_overall_status := x_return_status;
86: End If;
87: End If;

Line 84: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then

80: p_chr_sts_rec => p_chr_sts_tbl(i)
81: );
82:
83: If x_return_status <> OKE_API.G_RET_STS_SUCCESS Then
84: If l_overall_status <> OKE_API.G_RET_STS_UNEXP_ERROR Then
85: l_overall_status := x_return_status;
86: End If;
87: End If;
88:

Line 97: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then

93: -- return overall status
94: x_return_status := l_overall_status;
95: End If;
96:
97: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
98: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
100: raise OKE_API.G_EXCEPTION_ERROR;
101: End If;

Line 98: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

94: x_return_status := l_overall_status;
95: End If;
96:
97: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
98: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
100: raise OKE_API.G_EXCEPTION_ERROR;
101: End If;
102:

Line 99: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then

95: End If;
96:
97: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
98: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
100: raise OKE_API.G_EXCEPTION_ERROR;
101: End If;
102:
103: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 100: raise OKE_API.G_EXCEPTION_ERROR;

96:
97: If x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR Then
98: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
100: raise OKE_API.G_EXCEPTION_ERROR;
101: End If;
102:
103: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
104: x_msg_data => x_msg_data);

Line 103: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

99: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
100: raise OKE_API.G_EXCEPTION_ERROR;
101: End If;
102:
103: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
104: x_msg_data => x_msg_data);
105: EXCEPTION
106: when OKE_API.G_EXCEPTION_ERROR then
107: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 106: when OKE_API.G_EXCEPTION_ERROR then

102:
103: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
104: x_msg_data => x_msg_data);
105: EXCEPTION
106: when OKE_API.G_EXCEPTION_ERROR then
107: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
108: p_api_name => l_api_name,
109: p_pkg_name => g_pkg_name,
110: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 107: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

103: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
104: x_msg_data => x_msg_data);
105: EXCEPTION
106: when OKE_API.G_EXCEPTION_ERROR then
107: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
108: p_api_name => l_api_name,
109: p_pkg_name => g_pkg_name,
110: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
111: x_msg_count => x_msg_count,

Line 110: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

106: when OKE_API.G_EXCEPTION_ERROR then
107: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
108: p_api_name => l_api_name,
109: p_pkg_name => g_pkg_name,
110: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
111: x_msg_count => x_msg_count,
112: x_msg_data => x_msg_data,
113: p_api_type => g_api_type);
114:

Line 115: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

111: x_msg_count => x_msg_count,
112: x_msg_data => x_msg_data,
113: p_api_type => g_api_type);
114:
115: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
116: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
117: p_api_name => l_api_name,
118: p_pkg_name => g_pkg_name,
119: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 116: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

112: x_msg_data => x_msg_data,
113: p_api_type => g_api_type);
114:
115: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
116: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
117: p_api_name => l_api_name,
118: p_pkg_name => g_pkg_name,
119: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
120: x_msg_count => x_msg_count,

Line 119: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

115: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
116: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
117: p_api_name => l_api_name,
118: p_pkg_name => g_pkg_name,
119: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
120: x_msg_count => x_msg_count,
121: x_msg_data => x_msg_data,
122: p_api_type => g_api_type);
123:

Line 125: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

121: x_msg_data => x_msg_data,
122: p_api_type => g_api_type);
123:
124: when OTHERS then
125: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
126: p_api_name => l_api_name,
127: p_pkg_name => g_pkg_name,
128: p_exc_name => 'OTHERS',
129: x_msg_count => x_msg_count,

Line 212: x_return_status := OKE_API.G_RET_STS_SUCCESS;

208: l_end_date Date;
209:
210: l_allowed_flag VARCHAR2(1) := 'N';
211: BEGIN
212: x_return_status := OKE_API.G_RET_STS_SUCCESS;
213:
214:
215: IF ( p_chr_sts_rec.k_header_id IS NULL OR p_chr_sts_rec.k_header_id=OKC_API.G_MISS_NUM) THEN
216: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 216: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

212: x_return_status := OKE_API.G_RET_STS_SUCCESS;
213:
214:
215: IF ( p_chr_sts_rec.k_header_id IS NULL OR p_chr_sts_rec.k_header_id=OKC_API.G_MISS_NUM) THEN
216: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
217: p_msg_name =>G_REQUIRED_VALUE,
218: p_token1 =>G_COL_NAME_TOKEN,
219: p_token1_value =>'CONTRACT_HEADER_ID');
220: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 220: x_return_status := OKE_API.G_RET_STS_ERROR;

216: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
217: p_msg_name =>G_REQUIRED_VALUE,
218: p_token1 =>G_COL_NAME_TOKEN,
219: p_token1_value =>'CONTRACT_HEADER_ID');
220: x_return_status := OKE_API.G_RET_STS_ERROR;
221: END IF;
222:
223: IF ( p_chr_sts_rec.new_sts_code IS NULL OR p_chr_sts_rec.new_sts_code=OKC_API.G_MISS_CHAR) THEN
224: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 224: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

220: x_return_status := OKE_API.G_RET_STS_ERROR;
221: END IF;
222:
223: IF ( p_chr_sts_rec.new_sts_code IS NULL OR p_chr_sts_rec.new_sts_code=OKC_API.G_MISS_CHAR) THEN
224: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
225: p_msg_name =>G_REQUIRED_VALUE,
226: p_token1 =>G_COL_NAME_TOKEN,
227: p_token1_value =>'NEW_STS_CODE');
228: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 228: x_return_status := OKE_API.G_RET_STS_ERROR;

224: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
225: p_msg_name =>G_REQUIRED_VALUE,
226: p_token1 =>G_COL_NAME_TOKEN,
227: p_token1_value =>'NEW_STS_CODE');
228: x_return_status := OKE_API.G_RET_STS_ERROR;
229: END IF;
230:
231: IF ( p_chr_sts_rec.reason_code IS NULL OR p_chr_sts_rec.new_sts_code=OKC_API.G_MISS_CHAR) THEN
232: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

Line 232: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

228: x_return_status := OKE_API.G_RET_STS_ERROR;
229: END IF;
230:
231: IF ( p_chr_sts_rec.reason_code IS NULL OR p_chr_sts_rec.new_sts_code=OKC_API.G_MISS_CHAR) THEN
232: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
233: p_msg_name =>G_REQUIRED_VALUE,
234: p_token1 =>G_COL_NAME_TOKEN,
235: p_token1_value =>'REASON_CODE');
236: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 236: x_return_status := OKE_API.G_RET_STS_ERROR;

232: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
233: p_msg_name =>G_REQUIRED_VALUE,
234: p_token1 =>G_COL_NAME_TOKEN,
235: p_token1_value =>'REASON_CODE');
236: x_return_status := OKE_API.G_RET_STS_ERROR;
237: END IF;
238:
239: open get_k_hdr_cur(p_chr_sts_rec.k_header_id );
240: fetch get_k_hdr_cur into l_old_sts_code, l_start_date, l_end_date;

Line 255: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

251: close get_ste_code;
252: p_new_ste_code := l_new_ste_code;
253:
254: /* IF p_old_stS_code = p_chr_sts_rec.new_sts_code THEN
255: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
256: p_msg_name =>'Status cannot be changed for the same user status') ;
257: x_return_status := OKE_API.G_RET_STS_ERROR;
258: END IF;
259: */

Line 257: x_return_status := OKE_API.G_RET_STS_ERROR;

253:
254: /* IF p_old_stS_code = p_chr_sts_rec.new_sts_code THEN
255: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
256: p_msg_name =>'Status cannot be changed for the same user status') ;
257: x_return_status := OKE_API.G_RET_STS_ERROR;
258: END IF;
259: */
260: open check_valid_status(p_chr_sts_rec.new_sts_code,
261: p_new_ste_code ,

Line 270: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,

266: fetch check_valid_status into l_allowed_flag;
267: close check_valid_status;
268:
269: IF ( Nvl(l_allowed_flag,'N')<>'Y') THEN
270: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
271: p_msg_name =>G_INVALID_VALUE,
272: p_token1 =>G_COL_NAME_TOKEN,
273: p_token1_value =>'NEW_STS_CODE');
274: x_return_status := OKE_API.G_RET_STS_ERROR;

Line 274: x_return_status := OKE_API.G_RET_STS_ERROR;

270: OKE_API.SET_MESSAGE(p_app_name =>g_app_name,
271: p_msg_name =>G_INVALID_VALUE,
272: p_token1 =>G_COL_NAME_TOKEN,
273: p_token1_value =>'NEW_STS_CODE');
274: x_return_status := OKE_API.G_RET_STS_ERROR;
275:
276:
277: END IF;
278: exception

Line 281: OKE_API.SET_MESSAGE(

277: END IF;
278: exception
279: WHEN OTHERS THEN
280: -- store SQL error message on message stack
281: OKE_API.SET_MESSAGE(
282: p_app_name =>g_app_name,
283: p_msg_name =>G_UNEXPECTED_ERROR,
284: p_token1 =>G_SQLCODE_TOKEN,
285: p_token1_value =>SQLCODE,

Line 288: x_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

284: p_token1 =>G_SQLCODE_TOKEN,
285: p_token1_value =>SQLCODE,
286: p_token2 =>G_SQLERRM_TOKEN,
287: p_token2_value =>SQLERRM);
288: x_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
289:
290: END validate_status;
291:
292: PROCEDURE populate_table(x_chrv_tbl in out NOCOPY chrv_tbl_type, i in number) IS

Line 337: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

333: ) is
334:
335: l_api_name CONSTANT VARCHAR2(30) := 'Update_header_status';
336: l_api_version CONSTANT NUMBER := 1.0;
337: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
338:
339: l_new_ste_code varchar2(30);
340: l_old_ste_code varchar2(30);
341: l_old_sts_code varchar2(30);

Line 351: l_return_status := OKE_API.START_ACTIVITY(

347:
348: BEGIN
349: -- call START_ACTIVITY to create savepoint, check compatibility
350: -- and initialize message list
351: l_return_status := OKE_API.START_ACTIVITY(
352: p_api_name => l_api_name,
353: p_pkg_name => g_pkg_name,
354: p_init_msg_list => p_init_msg_list,
355: l_api_version => l_api_version,

Line 361: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

357: p_api_type => g_api_type,
358: x_return_status => x_return_status);
359:
360: -- check if activity started successfully
361: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
362: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
364: raise OKE_API.G_EXCEPTION_ERROR;
365: End If;

Line 362: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

358: x_return_status => x_return_status);
359:
360: -- check if activity started successfully
361: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
362: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
364: raise OKE_API.G_EXCEPTION_ERROR;
365: End If;
366:

Line 363: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

359:
360: -- check if activity started successfully
361: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
362: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
364: raise OKE_API.G_EXCEPTION_ERROR;
365: End If;
366:
367: validate_status( x_return_status =>l_return_status ,

Line 364: raise OKE_API.G_EXCEPTION_ERROR;

360: -- check if activity started successfully
361: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
362: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
364: raise OKE_API.G_EXCEPTION_ERROR;
365: End If;
366:
367: validate_status( x_return_status =>l_return_status ,
368: p_chr_sts_rec => p_chr_sts_rec,

Line 375: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

371: p_new_ste_code =>l_new_ste_code
372: );
373:
374: --- If any errors happen abort API
375: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
378: RAISE OKE_API.G_EXCEPTION_ERROR;
379: END IF;

Line 376: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

372: );
373:
374: --- If any errors happen abort API
375: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
378: RAISE OKE_API.G_EXCEPTION_ERROR;
379: END IF;
380:

Line 377: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

373:
374: --- If any errors happen abort API
375: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
378: RAISE OKE_API.G_EXCEPTION_ERROR;
379: END IF;
380:
381: l_chrv_tbl(1).id := p_chr_sts_rec.k_header_id;

Line 378: RAISE OKE_API.G_EXCEPTION_ERROR;

374: --- If any errors happen abort API
375: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
378: RAISE OKE_API.G_EXCEPTION_ERROR;
379: END IF;
380:
381: l_chrv_tbl(1).id := p_chr_sts_rec.k_header_id;
382: l_chrv_tbl(1).old_sts_code := l_old_sts_code;

Line 410: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

406: x_msg_data => x_msg_data,
407: p_chrv_rec => l_chrv_tbl(1));
408:
409: --- If any errors happen abort API
410: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
413: RAISE OKE_API.G_EXCEPTION_ERROR;
414: END IF;

Line 411: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

407: p_chrv_rec => l_chrv_tbl(1));
408:
409: --- If any errors happen abort API
410: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
413: RAISE OKE_API.G_EXCEPTION_ERROR;
414: END IF;
415:

Line 412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

408:
409: --- If any errors happen abort API
410: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
413: RAISE OKE_API.G_EXCEPTION_ERROR;
414: END IF;
415:
416:

Line 413: RAISE OKE_API.G_EXCEPTION_ERROR;

409: --- If any errors happen abort API
410: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
413: RAISE OKE_API.G_EXCEPTION_ERROR;
414: END IF;
415:
416:
417:

Line 430: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

426: p_control_rec => p_control_rec,
427: x_chrv_rec => l_chrv_tbl(1));
428:
429: --- If any errors happen abort API
430: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
433: RAISE OKE_API.G_EXCEPTION_ERROR;
434: END IF;

Line 431: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

427: x_chrv_rec => l_chrv_tbl(1));
428:
429: --- If any errors happen abort API
430: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
433: RAISE OKE_API.G_EXCEPTION_ERROR;
434: END IF;
435:

Line 432: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

428:
429: --- If any errors happen abort API
430: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
433: RAISE OKE_API.G_EXCEPTION_ERROR;
434: END IF;
435:
436:

Line 433: RAISE OKE_API.G_EXCEPTION_ERROR;

429: --- If any errors happen abort API
430: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
431: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
432: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
433: RAISE OKE_API.G_EXCEPTION_ERROR;
434: END IF;
435:
436:
437:

Line 453: l_return_status := OKE_API.G_RET_STS_ERROR ;

449:
450:
451: --- If any errors happen abort API
452: IF (NOT l_line_return_status) THEN
453: l_return_status := OKE_API.G_RET_STS_ERROR ;
454: RAISE OKE_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: x_return_status:=l_return_status;

Line 454: RAISE OKE_API.G_EXCEPTION_ERROR;

450:
451: --- If any errors happen abort API
452: IF (NOT l_line_return_status) THEN
453: l_return_status := OKE_API.G_RET_STS_ERROR ;
454: RAISE OKE_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: x_return_status:=l_return_status;
458: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

Line 458: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

454: RAISE OKE_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: x_return_status:=l_return_status;
458: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data);
460: EXCEPTION
461: when OKE_API.G_EXCEPTION_ERROR then
462: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 461: when OKE_API.G_EXCEPTION_ERROR then

457: x_return_status:=l_return_status;
458: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data);
460: EXCEPTION
461: when OKE_API.G_EXCEPTION_ERROR then
462: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
463: p_api_name => l_api_name,
464: p_pkg_name => g_pkg_name,
465: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 462: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

458: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data);
460: EXCEPTION
461: when OKE_API.G_EXCEPTION_ERROR then
462: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
463: p_api_name => l_api_name,
464: p_pkg_name => g_pkg_name,
465: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
466: x_msg_count => x_msg_count,

Line 465: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

461: when OKE_API.G_EXCEPTION_ERROR then
462: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
463: p_api_name => l_api_name,
464: p_pkg_name => g_pkg_name,
465: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
466: x_msg_count => x_msg_count,
467: x_msg_data => x_msg_data,
468: p_api_type => g_api_type);
469:

Line 470: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

466: x_msg_count => x_msg_count,
467: x_msg_data => x_msg_data,
468: p_api_type => g_api_type);
469:
470: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
471: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
472: p_api_name => l_api_name,
473: p_pkg_name => g_pkg_name,
474: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 471: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

467: x_msg_data => x_msg_data,
468: p_api_type => g_api_type);
469:
470: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
471: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
472: p_api_name => l_api_name,
473: p_pkg_name => g_pkg_name,
474: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
475: x_msg_count => x_msg_count,

Line 474: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

470: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
471: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
472: p_api_name => l_api_name,
473: p_pkg_name => g_pkg_name,
474: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
475: x_msg_count => x_msg_count,
476: x_msg_data => x_msg_data,
477: p_api_type => g_api_type);
478:

Line 480: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

476: x_msg_data => x_msg_data,
477: p_api_type => g_api_type);
478:
479: when OTHERS then
480: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
481: p_api_name => l_api_name,
482: p_pkg_name => g_pkg_name,
483: p_exc_name => 'OTHERS',
484: x_msg_count => x_msg_count,