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_VP_STS_PVT dependencies on OKL_API

Line 60: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

56: AND ST.enabled_flag = 'Y'
57: AND S.code <> p_sts_code
58: AND p_ste_code ='CANCELLED';
59:
60: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
61: l_msg_count NUMBER;
62: l_msg_data VARCHAR2(2000);
63: l_sts_count NUMBER := 0;
64:

Line 67: x_return_status := OKL_API.G_RET_STS_SUCCESS;

63: l_sts_count NUMBER := 0;
64:
65: BEGIN
66:
67: x_return_status := OKL_API.G_RET_STS_SUCCESS;
68:
69: FOR l_sts_rec IN cur_get_new_statuses(p_ste_code,p_sts_code,p_start_date,p_end_date)
70: LOOP
71: l_sts_count := l_sts_count + 1 ;

Line 114: l1_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

110: WHERE id=p_id;
111:
112:
113: l_return_status VARCHAR2(3);
114: l1_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
115: l_msg_count NUMBER;
116: l_msg_data VARCHAR2(2000);
117: l_api_version NUMBER := 1.0;
118: l_api_name CONSTANT VARCHAR2(30) := 'change_agreement_status';

Line 129: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name

125: l2_header_rec chrv_rec_type;
126:
127: BEGIN
128:
129: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name
130: ,p_init_msg_list => p_init_msg_list
131: ,p_api_type => '_PVT'
132: ,x_return_status => x_return_status
133: );

Line 134: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

130: ,p_init_msg_list => p_init_msg_list
131: ,p_api_type => '_PVT'
132: ,x_return_status => x_return_status
133: );
134: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
137: RAISE OKL_API.G_EXCEPTION_ERROR;
138: END IF;

Line 135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

131: ,p_api_type => '_PVT'
132: ,x_return_status => x_return_status
133: );
134: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
137: RAISE OKL_API.G_EXCEPTION_ERROR;
138: END IF;
139:

Line 136: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

132: ,x_return_status => x_return_status
133: );
134: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
137: RAISE OKL_API.G_EXCEPTION_ERROR;
138: END IF;
139:
140: IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN

Line 137: RAISE OKL_API.G_EXCEPTION_ERROR;

133: );
134: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
137: RAISE OKL_API.G_EXCEPTION_ERROR;
138: END IF;
139:
140: IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN
141:

Line 142: l1_return_status :=OKL_API.G_RET_STS_ERROR;

138: END IF;
139:
140: IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN
141:
142: l1_return_status :=OKL_API.G_RET_STS_ERROR;
143:
144: OKC_API.set_message(p_app_name => g_app_name,
145: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
146: );

Line 148: RAISE OKL_API.G_EXCEPTION_ERROR;

144: OKC_API.set_message(p_app_name => g_app_name,
145: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
146: );
147:
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149:
150: END IF;
151: IF (p_new_sts_code NOT IN ('ABANDONED','PASSED','INCOMPLETE') OR
152: -- Manu 11-Jul-2005. Added Status INCOMPLETE --

Line 157: RAISE OKL_API.G_EXCEPTION_ERROR;

153: (p_current_sts_code NOT IN ('NEW','PENDING','PASSED','INCOMPLETE'))) THEN
154: OKC_API.set_message(p_app_name => g_app_name,
155: p_msg_name => 'OKL_INVALID_CHANGE_STS'
156: );
157: RAISE OKL_API.G_EXCEPTION_ERROR;
158: ELSE
159: IF (p_current_sts_code = 'PENDING') THEN
160: OKL_CONTRACT_APPROVAL_PUB.STOP_PROCESS(p_api_version,
161: p_init_msg_list,

Line 167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

163: x_msg_count,
164: x_msg_data,
165: p_chr_id,
166: 'Y');
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE OKL_API.G_EXCEPTION_ERROR;
171: END IF;

Line 168: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

164: x_msg_data,
165: p_chr_id,
166: 'Y');
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE OKL_API.G_EXCEPTION_ERROR;
171: END IF;
172: END IF;

Line 169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

165: p_chr_id,
166: 'Y');
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE OKL_API.G_EXCEPTION_ERROR;
171: END IF;
172: END IF;
173: END IF;

Line 170: RAISE OKL_API.G_EXCEPTION_ERROR;

166: 'Y');
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE OKL_API.G_EXCEPTION_ERROR;
171: END IF;
172: END IF;
173: END IF;
174:

Line 180: RAISE OKL_API.G_EXCEPTION_ERROR;

176:
177: OKC_API.set_message(p_app_name => g_app_name,
178: p_msg_name => 'OKL_VP_APPROVAL_PROCESS_ACTV'
179: );
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181:
182: END IF;
183:
184: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 184: x_return_status := OKL_API.G_RET_STS_SUCCESS;

180: RAISE OKL_API.G_EXCEPTION_ERROR;
181:
182: END IF;
183:
184: x_return_status := OKL_API.G_RET_STS_SUCCESS;
185:
186: OPEN cur_get_status(p_chr_id);
187: FETCH cur_get_status INTO l_database_sts_code,l_authoring_org_id; --CDUBEY l_authoring_org_id added for MOAC
188:

Line 192: l1_return_status :=okl_api.g_ret_sts_error;

188:
189: IF(cur_get_status%FOUND) THEN
190: CLOSE cur_get_status;
191: ELSE
192: l1_return_status :=okl_api.g_ret_sts_error;
193: close cur_get_status;
194: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND');
195: RAISE OKL_API.G_EXCEPTION_ERROR;
196: END IF;

Line 194: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND');

190: CLOSE cur_get_status;
191: ELSE
192: l1_return_status :=okl_api.g_ret_sts_error;
193: close cur_get_status;
194: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND');
195: RAISE OKL_API.G_EXCEPTION_ERROR;
196: END IF;
197:
198:

Line 195: RAISE OKL_API.G_EXCEPTION_ERROR;

191: ELSE
192: l1_return_status :=okl_api.g_ret_sts_error;
193: close cur_get_status;
194: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_VP_AGREEMENT_NOT_FOUND');
195: RAISE OKL_API.G_EXCEPTION_ERROR;
196: END IF;
197:
198:
199: l1_header_rec.id :=p_chr_id;

Line 207: p_init_msg_list => OKL_API.G_TRUE,

203:
204: IF(p_current_sts_code=l_database_sts_code) THEN
205: OKC_CONTRACT_PUB.update_contract_header(p_api_version => l_api_version,
206: x_return_status => l_return_status,
207: p_init_msg_list => OKL_API.G_TRUE,
208: x_msg_count => l_msg_count,
209: x_msg_data => l_msg_data,
210: p_restricted_update => OKL_API.G_FALSE,
211: p_chrv_rec => l1_header_rec,

Line 210: p_restricted_update => OKL_API.G_FALSE,

206: x_return_status => l_return_status,
207: p_init_msg_list => OKL_API.G_TRUE,
208: x_msg_count => l_msg_count,
209: x_msg_data => l_msg_data,
210: p_restricted_update => OKL_API.G_FALSE,
211: p_chrv_rec => l1_header_rec,
212: x_chrv_rec => l2_header_rec);
213:
214: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 214: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

210: p_restricted_update => OKL_API.G_FALSE,
211: p_chrv_rec => l1_header_rec,
212: x_chrv_rec => l2_header_rec);
213:
214: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
215: NULL;
216: ELSE
217: l1_return_status := l_return_status;
218: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 218: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

214: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
215: NULL;
216: ELSE
217: l1_return_status := l_return_status;
218: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_ERROR;
222: END IF;

Line 219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

215: NULL;
216: ELSE
217: l1_return_status := l_return_status;
218: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_ERROR;
222: END IF;
223: END IF;

Line 220: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

216: ELSE
217: l1_return_status := l_return_status;
218: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_ERROR;
222: END IF;
223: END IF;
224: ELSE

Line 221: RAISE OKL_API.G_EXCEPTION_ERROR;

217: l1_return_status := l_return_status;
218: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
221: RAISE OKL_API.G_EXCEPTION_ERROR;
222: END IF;
223: END IF;
224: ELSE
225:

Line 226: l1_return_status :=okl_api.g_ret_sts_error;

222: END IF;
223: END IF;
224: ELSE
225:
226: l1_return_status :=okl_api.g_ret_sts_error;
227:
228: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
229: p_msg_name => 'OKL_VP_INVALID_CURRENT_STATUS');
230: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 228: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

224: ELSE
225:
226: l1_return_status :=okl_api.g_ret_sts_error;
227:
228: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
229: p_msg_name => 'OKL_VP_INVALID_CURRENT_STATUS');
230: RAISE OKL_API.G_EXCEPTION_ERROR;
231: END IF;
232:

Line 230: RAISE OKL_API.G_EXCEPTION_ERROR;

226: l1_return_status :=okl_api.g_ret_sts_error;
227:
228: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
229: p_msg_name => 'OKL_VP_INVALID_CURRENT_STATUS');
230: RAISE OKL_API.G_EXCEPTION_ERROR;
231: END IF;
232:
233: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
234: ,x_msg_data => x_msg_data

Line 233: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count

229: p_msg_name => 'OKL_VP_INVALID_CURRENT_STATUS');
230: RAISE OKL_API.G_EXCEPTION_ERROR;
231: END IF;
232:
233: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
234: ,x_msg_data => x_msg_data
235: );
236:
237: EXCEPTION

Line 239: WHEN OKL_API.G_EXCEPTION_ERROR THEN

235: );
236:
237: EXCEPTION
238:
239: WHEN OKL_API.G_EXCEPTION_ERROR THEN
240:
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
242: ,g_pkg_name
243: ,'OKL_API.G_RET_STS_ERROR'

Line 241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

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

Line 243: ,'OKL_API.G_RET_STS_ERROR'

239: WHEN OKL_API.G_EXCEPTION_ERROR THEN
240:
241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
242: ,g_pkg_name
243: ,'OKL_API.G_RET_STS_ERROR'
244: ,x_msg_count
245: ,x_msg_data
246: ,'_PVT'
247: );

Line 250: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

246: ,'_PVT'
247: );
248:
249:
250: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
251:
252: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
253: ,g_pkg_name
254: ,'OKL_API.G_RET_STS_ERROR'

Line 252: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

248:
249:
250: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
251:
252: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
253: ,g_pkg_name
254: ,'OKL_API.G_RET_STS_ERROR'
255: ,x_msg_count
256: ,x_msg_data

Line 254: ,'OKL_API.G_RET_STS_ERROR'

250: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
251:
252: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
253: ,g_pkg_name
254: ,'OKL_API.G_RET_STS_ERROR'
255: ,x_msg_count
256: ,x_msg_data
257: ,'_PVT'
258: );

Line 262: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

258: );
259:
260: WHEN OTHERS THEN
261:
262: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
263: ,g_pkg_name
264: ,'OTHERS'
265: ,x_msg_count
266: ,x_msg_data