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.OKL_ACTIVATE_ASSET_PUB dependencies on OKL_API

Line 24: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

20: -- fa links in ID1 , ID2 columns
21: --End of Comments
22: --------------------------------------------------------------------------------
23: PROCEDURE ACTIVATE_ASSET(p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: p_chrv_id IN NUMBER,

Line 32: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

28: p_chrv_id IN NUMBER,
29: p_call_mode IN VARCHAR2,
30: x_cimv_tbl OUT NOCOPY cimv_tbl_type) IS
31:
32: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
33: l_api_name CONSTANT varchar2(30) := 'ACTIVATE_ASSET';
34: l_api_version CONSTANT NUMBER := 1.0;
35:
36: BEGIN

Line 37: x_return_status := OKL_API.G_RET_STS_SUCCESS;

33: l_api_name CONSTANT varchar2(30) := 'ACTIVATE_ASSET';
34: l_api_version CONSTANT NUMBER := 1.0;
35:
36: BEGIN
37: x_return_status := OKL_API.G_RET_STS_SUCCESS;
38: -- Call start_activity to create savepoint, check compatibility
39: -- and initialize message list
40: x_return_status := OKL_API.START_ACTIVITY (
41: l_api_name

Line 40: x_return_status := OKL_API.START_ACTIVITY (

36: BEGIN
37: x_return_status := OKL_API.G_RET_STS_SUCCESS;
38: -- Call start_activity to create savepoint, check compatibility
39: -- and initialize message list
40: x_return_status := OKL_API.START_ACTIVITY (
41: l_api_name
42: ,p_init_msg_list
43: ,'_PUB'
44: ,x_return_status);

Line 46: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

42: ,p_init_msg_list
43: ,'_PUB'
44: ,x_return_status);
45: -- Check if activity started successfully
46: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;

Line 47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

43: ,'_PUB'
44: ,x_return_status);
45: -- Check if activity started successfully
46: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;
51: --Customer pre-processing Section

Line 48: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

44: ,x_return_status);
45: -- Check if activity started successfully
46: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;
51: --Customer pre-processing Section
52:

Line 49: RAISE OKL_API.G_EXCEPTION_ERROR;

45: -- Check if activity started successfully
46: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;
51: --Customer pre-processing Section
52:
53: --Vertical Industry pre-processing Section

Line 64: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

60: x_msg_data => x_msg_data,
61: p_chrv_id => p_chrv_id,
62: p_call_mode => p_call_mode,
63: x_cimv_tbl => x_cimv_tbl);
64: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
65: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
67: RAISE OKL_API.G_EXCEPTION_ERROR;
68: END IF;

Line 65: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

61: p_chrv_id => p_chrv_id,
62: p_call_mode => p_call_mode,
63: x_cimv_tbl => x_cimv_tbl);
64: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
65: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
67: RAISE OKL_API.G_EXCEPTION_ERROR;
68: END IF;
69:

Line 66: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

62: p_call_mode => p_call_mode,
63: x_cimv_tbl => x_cimv_tbl);
64: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
65: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
67: RAISE OKL_API.G_EXCEPTION_ERROR;
68: END IF;
69:
70: --Vertical Industry post-processing Section

Line 67: RAISE OKL_API.G_EXCEPTION_ERROR;

63: x_cimv_tbl => x_cimv_tbl);
64: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
65: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
66: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
67: RAISE OKL_API.G_EXCEPTION_ERROR;
68: END IF;
69:
70: --Vertical Industry post-processing Section
71:

Line 74: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

70: --Vertical Industry post-processing Section
71:
72: --Custom post-processing Section
73:
74: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
75: EXCEPTION
76: WHEN OKL_API.G_EXCEPTION_ERROR THEN
77: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
78: l_api_name,

Line 76: WHEN OKL_API.G_EXCEPTION_ERROR THEN

72: --Custom post-processing Section
73:
74: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
75: EXCEPTION
76: WHEN OKL_API.G_EXCEPTION_ERROR THEN
77: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
78: l_api_name,
79: G_PKG_NAME,
80: 'OKL_API.G_RET_STS_ERROR',

Line 77: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

73:
74: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
75: EXCEPTION
76: WHEN OKL_API.G_EXCEPTION_ERROR THEN
77: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
78: l_api_name,
79: G_PKG_NAME,
80: 'OKL_API.G_RET_STS_ERROR',
81: x_msg_count,

Line 80: 'OKL_API.G_RET_STS_ERROR',

76: WHEN OKL_API.G_EXCEPTION_ERROR THEN
77: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
78: l_api_name,
79: G_PKG_NAME,
80: 'OKL_API.G_RET_STS_ERROR',
81: x_msg_count,
82: x_msg_data,
83: '_PUB');
84: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 84: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

80: 'OKL_API.G_RET_STS_ERROR',
81: x_msg_count,
82: x_msg_data,
83: '_PUB');
84: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
85: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
86: l_api_name,
87: G_PKG_NAME,
88: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 85: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

81: x_msg_count,
82: x_msg_data,
83: '_PUB');
84: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
85: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
86: l_api_name,
87: G_PKG_NAME,
88: 'OKL_API.G_RET_STS_UNEXP_ERROR',
89: x_msg_count,

Line 88: 'OKL_API.G_RET_STS_UNEXP_ERROR',

84: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
85: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
86: l_api_name,
87: G_PKG_NAME,
88: 'OKL_API.G_RET_STS_UNEXP_ERROR',
89: x_msg_count,
90: x_msg_data,
91: '_PUB');
92: WHEN OTHERS THEN

Line 93: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

89: x_msg_count,
90: x_msg_data,
91: '_PUB');
92: WHEN OTHERS THEN
93: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
94: l_api_name,
95: G_PKG_NAME,
96: 'OTHERS',
97: x_msg_count,

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

113: -- to the original (being re-booked ) K
114: --End of Comments
115: --------------------------------------------------------------------------------
116: PROCEDURE REBOOK_ASSET (p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_rbk_chr_id IN NUMBER) IS

Line 123: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_rbk_chr_id IN NUMBER) IS
122:
123: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
124: l_api_name CONSTANT varchar2(30) := 'REBOOK_ASSET';
125: l_api_version CONSTANT NUMBER := 1.0;
126:
127: BEGIN

Line 128: x_return_status := OKL_API.G_RET_STS_SUCCESS;

124: l_api_name CONSTANT varchar2(30) := 'REBOOK_ASSET';
125: l_api_version CONSTANT NUMBER := 1.0;
126:
127: BEGIN
128: x_return_status := OKL_API.G_RET_STS_SUCCESS;
129: -- Call start_activity to create savepoint, check compatibility
130: -- and initialize message list
131: x_return_status := OKL_API.START_ACTIVITY (
132: l_api_name

Line 131: x_return_status := OKL_API.START_ACTIVITY (

127: BEGIN
128: x_return_status := OKL_API.G_RET_STS_SUCCESS;
129: -- Call start_activity to create savepoint, check compatibility
130: -- and initialize message list
131: x_return_status := OKL_API.START_ACTIVITY (
132: l_api_name
133: ,p_init_msg_list
134: ,'_PUB'
135: ,x_return_status);

Line 137: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

133: ,p_init_msg_list
134: ,'_PUB'
135: ,x_return_status);
136: -- Check if activity started successfully
137: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_ERROR;
141: END IF;

Line 138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

134: ,'_PUB'
135: ,x_return_status);
136: -- Check if activity started successfully
137: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_ERROR;
141: END IF;
142: --Customer pre-processing Section

Line 139: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

135: ,x_return_status);
136: -- Check if activity started successfully
137: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_ERROR;
141: END IF;
142: --Customer pre-processing Section
143:

Line 140: RAISE OKL_API.G_EXCEPTION_ERROR;

136: -- Check if activity started successfully
137: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
139: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_ERROR;
141: END IF;
142: --Customer pre-processing Section
143:
144: --Vertical Industry pre-processing Section

Line 154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

150: x_msg_count => x_msg_count,
151: x_msg_data => x_msg_data,
152: p_rbk_chr_id => p_rbk_chr_id
153: );
154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
157: RAISE OKL_API.G_EXCEPTION_ERROR;
158: END IF;

Line 155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

151: x_msg_data => x_msg_data,
152: p_rbk_chr_id => p_rbk_chr_id
153: );
154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
157: RAISE OKL_API.G_EXCEPTION_ERROR;
158: END IF;
159:

Line 156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

152: p_rbk_chr_id => p_rbk_chr_id
153: );
154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
157: RAISE OKL_API.G_EXCEPTION_ERROR;
158: END IF;
159:
160: --Vertical Industry post-processing Section

Line 157: RAISE OKL_API.G_EXCEPTION_ERROR;

153: );
154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
157: RAISE OKL_API.G_EXCEPTION_ERROR;
158: END IF;
159:
160: --Vertical Industry post-processing Section
161:

Line 164: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

160: --Vertical Industry post-processing Section
161:
162: --Custom post-processing Section
163:
164: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
165: EXCEPTION
166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
168: l_api_name,

Line 166: WHEN OKL_API.G_EXCEPTION_ERROR THEN

162: --Custom post-processing Section
163:
164: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
165: EXCEPTION
166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
168: l_api_name,
169: G_PKG_NAME,
170: 'OKL_API.G_RET_STS_ERROR',

Line 167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

163:
164: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
165: EXCEPTION
166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
168: l_api_name,
169: G_PKG_NAME,
170: 'OKL_API.G_RET_STS_ERROR',
171: x_msg_count,

Line 170: 'OKL_API.G_RET_STS_ERROR',

166: WHEN OKL_API.G_EXCEPTION_ERROR THEN
167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
168: l_api_name,
169: G_PKG_NAME,
170: 'OKL_API.G_RET_STS_ERROR',
171: x_msg_count,
172: x_msg_data,
173: '_PUB');
174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

170: 'OKL_API.G_RET_STS_ERROR',
171: x_msg_count,
172: x_msg_data,
173: '_PUB');
174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
176: l_api_name,
177: G_PKG_NAME,
178: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

171: x_msg_count,
172: x_msg_data,
173: '_PUB');
174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
176: l_api_name,
177: G_PKG_NAME,
178: 'OKL_API.G_RET_STS_UNEXP_ERROR',
179: x_msg_count,

Line 178: 'OKL_API.G_RET_STS_UNEXP_ERROR',

174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
175: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
176: l_api_name,
177: G_PKG_NAME,
178: 'OKL_API.G_RET_STS_UNEXP_ERROR',
179: x_msg_count,
180: x_msg_data,
181: '_PUB');
182: WHEN OTHERS THEN

Line 183: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

179: x_msg_count,
180: x_msg_data,
181: '_PUB');
182: WHEN OTHERS THEN
183: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
184: l_api_name,
185: G_PKG_NAME,
186: 'OTHERS',
187: x_msg_count,

Line 192: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

188: x_msg_data,
189: '_PUB');
190: END REBOOK_ASSET;
191: PROCEDURE RELEASE_ASSET (p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_rel_chr_id IN NUMBER) is

Line 197: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_rel_chr_id IN NUMBER) is
197: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
198: l_api_name CONSTANT varchar2(30) := 'RELEASE_ASSET';
199: l_api_version CONSTANT NUMBER := 1.0;
200:
201: BEGIN

Line 202: x_return_status := OKL_API.G_RET_STS_SUCCESS;

198: l_api_name CONSTANT varchar2(30) := 'RELEASE_ASSET';
199: l_api_version CONSTANT NUMBER := 1.0;
200:
201: BEGIN
202: x_return_status := OKL_API.G_RET_STS_SUCCESS;
203: -- Call start_activity to create savepoint, check compatibility
204: -- and initialize message list
205: x_return_status := OKL_API.START_ACTIVITY (
206: l_api_name

Line 205: x_return_status := OKL_API.START_ACTIVITY (

201: BEGIN
202: x_return_status := OKL_API.G_RET_STS_SUCCESS;
203: -- Call start_activity to create savepoint, check compatibility
204: -- and initialize message list
205: x_return_status := OKL_API.START_ACTIVITY (
206: l_api_name
207: ,p_init_msg_list
208: ,'_PUB'
209: ,x_return_status);

Line 211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

207: ,p_init_msg_list
208: ,'_PUB'
209: ,x_return_status);
210: -- Check if activity started successfully
211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;

Line 212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

208: ,'_PUB'
209: ,x_return_status);
210: -- Check if activity started successfully
211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216: --Customer pre-processing Section

Line 213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

209: ,x_return_status);
210: -- Check if activity started successfully
211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216: --Customer pre-processing Section
217:

Line 214: RAISE OKL_API.G_EXCEPTION_ERROR;

210: -- Check if activity started successfully
211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216: --Customer pre-processing Section
217:
218: --Vertical Industry pre-processing Section

Line 228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

224: x_msg_count => x_msg_count,
225: x_msg_data => x_msg_data,
226: p_rel_chr_id => p_rel_chr_id
227: );
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;

Line 229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

225: x_msg_data => x_msg_data,
226: p_rel_chr_id => p_rel_chr_id
227: );
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;
233:

Line 230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

226: p_rel_chr_id => p_rel_chr_id
227: );
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;
233:
234: --Vertical Industry post-processing Section

Line 231: RAISE OKL_API.G_EXCEPTION_ERROR;

227: );
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;
233:
234: --Vertical Industry post-processing Section
235:

Line 238: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

234: --Vertical Industry post-processing Section
235:
236: --Custom post-processing Section
237:
238: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
239: EXCEPTION
240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
242: l_api_name,

Line 240: WHEN OKL_API.G_EXCEPTION_ERROR THEN

236: --Custom post-processing Section
237:
238: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
239: EXCEPTION
240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
242: l_api_name,
243: G_PKG_NAME,
244: 'OKL_API.G_RET_STS_ERROR',

Line 241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

237:
238: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
239: EXCEPTION
240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
242: l_api_name,
243: G_PKG_NAME,
244: 'OKL_API.G_RET_STS_ERROR',
245: x_msg_count,

Line 244: 'OKL_API.G_RET_STS_ERROR',

240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
242: l_api_name,
243: G_PKG_NAME,
244: 'OKL_API.G_RET_STS_ERROR',
245: x_msg_count,
246: x_msg_data,
247: '_PUB');
248: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 248: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

244: 'OKL_API.G_RET_STS_ERROR',
245: x_msg_count,
246: x_msg_data,
247: '_PUB');
248: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
249: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
250: l_api_name,
251: G_PKG_NAME,
252: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 249: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

245: x_msg_count,
246: x_msg_data,
247: '_PUB');
248: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
249: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
250: l_api_name,
251: G_PKG_NAME,
252: 'OKL_API.G_RET_STS_UNEXP_ERROR',
253: x_msg_count,

Line 252: 'OKL_API.G_RET_STS_UNEXP_ERROR',

248: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
249: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
250: l_api_name,
251: G_PKG_NAME,
252: 'OKL_API.G_RET_STS_UNEXP_ERROR',
253: x_msg_count,
254: x_msg_data,
255: '_PUB');
256: WHEN OTHERS THEN

Line 257: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

253: x_msg_count,
254: x_msg_data,
255: '_PUB');
256: WHEN OTHERS THEN
257: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
258: l_api_name,
259: G_PKG_NAME,
260: 'OTHERS',
261: x_msg_count,