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

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

13: p_ppydv_rec ppydv_rec_type
14: ,p_mode VARCHAR2
15: ) RETURN VARCHAR2
16: IS
17: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18:
19: BEGIN
20:
21: IF (p_mode = G_INSERT_MODE) THEN

Line 25: (p_ppydv_rec.vendor_id = OKL_API.G_MISS_NUM)

21: IF (p_mode = G_INSERT_MODE) THEN
22:
23: -- column is required:
24: IF (p_ppydv_rec.vendor_id IS NULL) OR
25: (p_ppydv_rec.vendor_id = OKL_API.G_MISS_NUM)
26: THEN
27: OKL_API.Set_Message(p_app_name => G_APP_NAME,
28: p_msg_name => G_REQUIRED_VALUE,
29: p_token1 => G_COL_NAME_TOKEN,

Line 27: OKL_API.Set_Message(p_app_name => G_APP_NAME,

23: -- column is required:
24: IF (p_ppydv_rec.vendor_id IS NULL) OR
25: (p_ppydv_rec.vendor_id = OKL_API.G_MISS_NUM)
26: THEN
27: OKL_API.Set_Message(p_app_name => G_APP_NAME,
28: p_msg_name => G_REQUIRED_VALUE,
29: p_token1 => G_COL_NAME_TOKEN,
30: p_token1_value => 'Pay As Vendor');
31: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 39: OKL_API.Set_Message(p_app_name => G_APP_NAME,

35:
36: -- column is required:
37: IF (p_ppydv_rec.vendor_id IS NULL)
38: THEN
39: OKL_API.Set_Message(p_app_name => G_APP_NAME,
40: p_msg_name => G_REQUIRED_VALUE,
41: p_token1 => G_COL_NAME_TOKEN,
42: p_token1_value => 'Pay As Vendor');
43: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 52: l_return_status := OKL_API.G_RET_STS_ERROR;

48: RETURN l_return_status;
49:
50: EXCEPTION
51: WHEN G_EXCEPTION_HALT_VALIDATION THEN
52: l_return_status := OKL_API.G_RET_STS_ERROR;
53: RETURN l_return_status;
54: WHEN OTHERS THEN
55: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
56: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 55: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

51: WHEN G_EXCEPTION_HALT_VALIDATION THEN
52: l_return_status := OKL_API.G_RET_STS_ERROR;
53: RETURN l_return_status;
54: WHEN OTHERS THEN
55: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
56: OKL_API.Set_Message(p_app_name => G_APP_NAME,
57: p_msg_name => G_UNEXPECTED_ERROR,
58: p_token1 => G_SQLCODE_TOKEN,
59: p_token1_value => SQLCODE,

Line 56: OKL_API.Set_Message(p_app_name => G_APP_NAME,

52: l_return_status := OKL_API.G_RET_STS_ERROR;
53: RETURN l_return_status;
54: WHEN OTHERS THEN
55: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
56: OKL_API.Set_Message(p_app_name => G_APP_NAME,
57: p_msg_name => G_UNEXPECTED_ERROR,
58: p_token1 => G_SQLCODE_TOKEN,
59: p_token1_value => SQLCODE,
60: p_token2 => G_SQLERRM_TOKEN,

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

69: p_ppydv_rec ppydv_rec_type
70: ,p_mode VARCHAR2
71: ) RETURN VARCHAR2
72: IS
73: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
74:
75: BEGIN
76:
77: IF (p_mode = G_INSERT_MODE) THEN

Line 81: (p_ppydv_rec.pay_site_id = OKL_API.G_MISS_NUM)

77: IF (p_mode = G_INSERT_MODE) THEN
78:
79: -- column is required:
80: IF (p_ppydv_rec.pay_site_id IS NULL) OR
81: (p_ppydv_rec.pay_site_id = OKL_API.G_MISS_NUM)
82: THEN
83: OKL_API.Set_Message(p_app_name => G_APP_NAME,
84: p_msg_name => G_REQUIRED_VALUE,
85: p_token1 => G_COL_NAME_TOKEN,

Line 83: OKL_API.Set_Message(p_app_name => G_APP_NAME,

79: -- column is required:
80: IF (p_ppydv_rec.pay_site_id IS NULL) OR
81: (p_ppydv_rec.pay_site_id = OKL_API.G_MISS_NUM)
82: THEN
83: OKL_API.Set_Message(p_app_name => G_APP_NAME,
84: p_msg_name => G_REQUIRED_VALUE,
85: p_token1 => G_COL_NAME_TOKEN,
86: p_token1_value => 'Pay Site');
87: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 95: OKL_API.Set_Message(p_app_name => G_APP_NAME,

91:
92: -- column is required:
93: IF (p_ppydv_rec.pay_site_id IS NULL)
94: THEN
95: OKL_API.Set_Message(p_app_name => G_APP_NAME,
96: p_msg_name => G_REQUIRED_VALUE,
97: p_token1 => G_COL_NAME_TOKEN,
98: p_token1_value => 'Pay Site');
99: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 108: l_return_status := OKL_API.G_RET_STS_ERROR;

104: RETURN l_return_status;
105:
106: EXCEPTION
107: WHEN G_EXCEPTION_HALT_VALIDATION THEN
108: l_return_status := OKL_API.G_RET_STS_ERROR;
109: RETURN l_return_status;
110: WHEN OTHERS THEN
111: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
112: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 111: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

107: WHEN G_EXCEPTION_HALT_VALIDATION THEN
108: l_return_status := OKL_API.G_RET_STS_ERROR;
109: RETURN l_return_status;
110: WHEN OTHERS THEN
111: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
112: OKL_API.Set_Message(p_app_name => G_APP_NAME,
113: p_msg_name => G_UNEXPECTED_ERROR,
114: p_token1 => G_SQLCODE_TOKEN,
115: p_token1_value => SQLCODE,

Line 112: OKL_API.Set_Message(p_app_name => G_APP_NAME,

108: l_return_status := OKL_API.G_RET_STS_ERROR;
109: RETURN l_return_status;
110: WHEN OTHERS THEN
111: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
112: OKL_API.Set_Message(p_app_name => G_APP_NAME,
113: p_msg_name => G_UNEXPECTED_ERROR,
114: p_token1 => G_SQLCODE_TOKEN,
115: p_token1_value => SQLCODE,
116: p_token2 => G_SQLERRM_TOKEN,

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

125: p_ppydv_rec ppydv_rec_type
126: ,p_mode VARCHAR2
127: ) RETURN VARCHAR2
128: IS
129: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
130:
131: BEGIN
132:
133: IF (p_mode = G_INSERT_MODE) THEN

Line 137: (p_ppydv_rec.payment_term_id = OKL_API.G_MISS_NUM)

133: IF (p_mode = G_INSERT_MODE) THEN
134:
135: -- column is required:
136: IF (p_ppydv_rec.payment_term_id IS NULL) OR
137: (p_ppydv_rec.payment_term_id = OKL_API.G_MISS_NUM)
138: THEN
139: OKL_API.Set_Message(p_app_name => G_APP_NAME,
140: p_msg_name => G_REQUIRED_VALUE,
141: p_token1 => G_COL_NAME_TOKEN,

Line 139: OKL_API.Set_Message(p_app_name => G_APP_NAME,

135: -- column is required:
136: IF (p_ppydv_rec.payment_term_id IS NULL) OR
137: (p_ppydv_rec.payment_term_id = OKL_API.G_MISS_NUM)
138: THEN
139: OKL_API.Set_Message(p_app_name => G_APP_NAME,
140: p_msg_name => G_REQUIRED_VALUE,
141: p_token1 => G_COL_NAME_TOKEN,
142: p_token1_value => 'Payment Term');
143: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 151: OKL_API.Set_Message(p_app_name => G_APP_NAME,

147:
148: -- column is required:
149: IF (p_ppydv_rec.payment_term_id IS NULL)
150: THEN
151: OKL_API.Set_Message(p_app_name => G_APP_NAME,
152: p_msg_name => G_REQUIRED_VALUE,
153: p_token1 => G_COL_NAME_TOKEN,
154: p_token1_value => 'Payment Term');
155: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 164: l_return_status := OKL_API.G_RET_STS_ERROR;

160: RETURN l_return_status;
161:
162: EXCEPTION
163: WHEN G_EXCEPTION_HALT_VALIDATION THEN
164: l_return_status := OKL_API.G_RET_STS_ERROR;
165: RETURN l_return_status;
166: WHEN OTHERS THEN
167: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
168: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 167: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

163: WHEN G_EXCEPTION_HALT_VALIDATION THEN
164: l_return_status := OKL_API.G_RET_STS_ERROR;
165: RETURN l_return_status;
166: WHEN OTHERS THEN
167: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
168: OKL_API.Set_Message(p_app_name => G_APP_NAME,
169: p_msg_name => G_UNEXPECTED_ERROR,
170: p_token1 => G_SQLCODE_TOKEN,
171: p_token1_value => SQLCODE,

Line 168: OKL_API.Set_Message(p_app_name => G_APP_NAME,

164: l_return_status := OKL_API.G_RET_STS_ERROR;
165: RETURN l_return_status;
166: WHEN OTHERS THEN
167: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
168: OKL_API.Set_Message(p_app_name => G_APP_NAME,
169: p_msg_name => G_UNEXPECTED_ERROR,
170: p_token1 => G_SQLCODE_TOKEN,
171: p_token1_value => SQLCODE,
172: p_token2 => G_SQLERRM_TOKEN,

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

179: p_ppydv_rec ppydv_rec_type
180: ,p_mode VARCHAR2
181: ) RETURN VARCHAR2
182: IS
183: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
184: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
185:
186: BEGIN
187:

Line 184: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

180: ,p_mode VARCHAR2
181: ) RETURN VARCHAR2
182: IS
183: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
184: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
185:
186: BEGIN
187:
188: -- Do formal attribute validation:

Line 192: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

188: -- Do formal attribute validation:
189:
190: l_return_status := validate_vendor(p_ppydv_rec, p_mode);
191: --- Store the highest degree of error
192: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
193: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
194: x_return_status := l_return_status;
195: END IF;
196: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 193: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

189:
190: l_return_status := validate_vendor(p_ppydv_rec, p_mode);
191: --- Store the highest degree of error
192: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
193: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
194: x_return_status := l_return_status;
195: END IF;
196: RAISE G_EXCEPTION_HALT_VALIDATION;
197: END IF;

Line 201: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

197: END IF;
198:
199: l_return_status := validate_vendor_site(p_ppydv_rec, p_mode);
200: --- Store the highest degree of error
201: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
202: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
203: x_return_status := l_return_status;
204: END IF;
205: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 202: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

198:
199: l_return_status := validate_vendor_site(p_ppydv_rec, p_mode);
200: --- Store the highest degree of error
201: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
202: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
203: x_return_status := l_return_status;
204: END IF;
205: RAISE G_EXCEPTION_HALT_VALIDATION;
206: END IF;

Line 214: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

210: EXCEPTION
211: WHEN G_EXCEPTION_HALT_VALIDATION THEN
212: RETURN x_return_status;
213: WHEN OTHERS THEN
214: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
215: OKL_API.Set_Message(p_app_name => G_APP_NAME,
216: p_msg_name => G_UNEXPECTED_ERROR,
217: p_token1 => G_SQLCODE_TOKEN,
218: p_token1_value => SQLCODE,

Line 215: OKL_API.Set_Message(p_app_name => G_APP_NAME,

211: WHEN G_EXCEPTION_HALT_VALIDATION THEN
212: RETURN x_return_status;
213: WHEN OTHERS THEN
214: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
215: OKL_API.Set_Message(p_app_name => G_APP_NAME,
216: p_msg_name => G_UNEXPECTED_ERROR,
217: p_token1 => G_SQLCODE_TOKEN,
218: p_token1_value => SQLCODE,
219: p_token2 => G_SQLERRM_TOKEN,

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

244: is
245: l_api_name CONSTANT VARCHAR2(30) := 'create_lessee_as_vendor';
246: l_api_version CONSTANT NUMBER := 1.0;
247: i NUMBER;
248: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
249: lp_ppydv_rec ppydv_rec_type := p_ppydv_rec;
250: -- lx_ppydv_rec ppydv_rec_type := x_ppydv_rec;
251: l_cpl_id okc_k_party_roles_b.id%type;
252:

Line 271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

267: p_api_version,
268: l_api_name,
269: G_PKG_NAME ))
270: THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: END IF;
273:
274: -- Initialize message list if requested
275: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 280: x_return_status := OKL_API.G_RET_STS_SUCCESS;

276: FND_MSG_PUB.initialize;
277: END IF;
278:
279: -- Initialize API status to success
280: x_return_status := OKL_API.G_RET_STS_SUCCESS;
281:
282:
283: /*** Begin API body ****************************************************/
284:

Line 294: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

290: lp_ppydv_rec.cpl_id := l_cpl_id;
291:
292: l_return_status := validate_header_attributes(lp_ppydv_rec, G_INSERT_MODE);
293: --- Store the highest degree of error
294: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
295: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: x_return_status := l_return_status;
297: END IF;
298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 295: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

291:
292: l_return_status := validate_header_attributes(lp_ppydv_rec, G_INSERT_MODE);
293: --- Store the highest degree of error
294: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
295: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: x_return_status := l_return_status;
297: END IF;
298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
299: END IF;

Line 298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

294: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
295: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: x_return_status := l_return_status;
297: END IF;
298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
299: END IF;
300:
301: okl_pyd_pvt.insert_row(
302: p_api_version => p_api_version,

Line 326: WHEN OKL_API.G_EXCEPTION_ERROR THEN

322: (p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: EXCEPTION
326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
327: ROLLBACK TO create_lessee_as_vendor;
328: x_return_status := OKL_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count,

Line 328: x_return_status := OKL_API.G_RET_STS_ERROR;

324:
325: EXCEPTION
326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
327: ROLLBACK TO create_lessee_as_vendor;
328: x_return_status := OKL_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count,
331: p_data => x_msg_data);
332:

Line 333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
334: ROLLBACK TO create_lessee_as_vendor;
335: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count,

Line 335: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

331: p_data => x_msg_data);
332:
333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
334: ROLLBACK TO create_lessee_as_vendor;
335: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count,
338: p_data => x_msg_data);
339:

Line 342: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

338: p_data => x_msg_data);
339:
340: WHEN OTHERS THEN
341: ROLLBACK TO create_lessee_as_vendor;
342: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
343: OKL_API.Set_Message(p_app_name => G_APP_NAME,
344: p_msg_name => G_UNEXPECTED_ERROR,
345: p_token1 => G_SQLCODE_TOKEN,
346: p_token1_value => SQLCODE,

Line 343: OKL_API.Set_Message(p_app_name => G_APP_NAME,

339:
340: WHEN OTHERS THEN
341: ROLLBACK TO create_lessee_as_vendor;
342: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
343: OKL_API.Set_Message(p_app_name => G_APP_NAME,
344: p_msg_name => G_UNEXPECTED_ERROR,
345: p_token1 => G_SQLCODE_TOKEN,
346: p_token1_value => SQLCODE,
347: p_token2 => G_SQLERRM_TOKEN,

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

374: is
375: l_api_name CONSTANT VARCHAR2(30) := 'update_lessee_as_vendor';
376: l_api_version CONSTANT NUMBER := 1.0;
377: i NUMBER;
378: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
379: lp_ppydv_rec ppydv_rec_type := p_ppydv_rec;
380: -- lx_ppydv_rec ppydv_rec_type := x_ppydv_rec;
381:
382: begin

Line 392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

388: p_api_version,
389: l_api_name,
390: G_PKG_NAME ))
391: THEN
392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
393: END IF;
394:
395: -- Initialize message list if requested
396: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 401: x_return_status := OKL_API.G_RET_STS_SUCCESS;

397: FND_MSG_PUB.initialize;
398: END IF;
399:
400: -- Initialize API status to success
401: x_return_status := OKL_API.G_RET_STS_SUCCESS;
402:
403:
404: /*** Begin API body ****************************************************/
405:

Line 408: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

404: /*** Begin API body ****************************************************/
405:
406: l_return_status := validate_header_attributes(lp_ppydv_rec, G_UPDATE_MODE);
407: --- Store the highest degree of error
408: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
409: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: x_return_status := l_return_status;
411: END IF;
412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 409: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

405:
406: l_return_status := validate_header_attributes(lp_ppydv_rec, G_UPDATE_MODE);
407: --- Store the highest degree of error
408: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
409: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: x_return_status := l_return_status;
411: END IF;
412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
413: END IF;

Line 412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

408: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
409: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: x_return_status := l_return_status;
411: END IF;
412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
413: END IF;
414:
415: okl_pyd_pvt.update_row(
416: p_api_version => p_api_version,

Line 439: WHEN OKL_API.G_EXCEPTION_ERROR THEN

435: (p_count => x_msg_count,
436: p_data => x_msg_data);
437:
438: EXCEPTION
439: WHEN OKL_API.G_EXCEPTION_ERROR THEN
440: ROLLBACK TO update_lessee_as_vendor;
441: x_return_status := OKL_API.G_RET_STS_ERROR;
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,

Line 441: x_return_status := OKL_API.G_RET_STS_ERROR;

437:
438: EXCEPTION
439: WHEN OKL_API.G_EXCEPTION_ERROR THEN
440: ROLLBACK TO update_lessee_as_vendor;
441: x_return_status := OKL_API.G_RET_STS_ERROR;
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,
444: p_data => x_msg_data);
445:

Line 446: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,
444: p_data => x_msg_data);
445:
446: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
447: ROLLBACK TO update_lessee_as_vendor;
448: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count,

Line 448: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

444: p_data => x_msg_data);
445:
446: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
447: ROLLBACK TO update_lessee_as_vendor;
448: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count,
451: p_data => x_msg_data);
452:

Line 455: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

451: p_data => x_msg_data);
452:
453: WHEN OTHERS THEN
454: ROLLBACK TO update_lessee_as_vendor;
455: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
456: OKL_API.Set_Message(p_app_name => G_APP_NAME,
457: p_msg_name => G_UNEXPECTED_ERROR,
458: p_token1 => G_SQLCODE_TOKEN,
459: p_token1_value => SQLCODE,

Line 456: OKL_API.Set_Message(p_app_name => G_APP_NAME,

452:
453: WHEN OTHERS THEN
454: ROLLBACK TO update_lessee_as_vendor;
455: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
456: OKL_API.Set_Message(p_app_name => G_APP_NAME,
457: p_msg_name => G_UNEXPECTED_ERROR,
458: p_token1 => G_SQLCODE_TOKEN,
459: p_token1_value => SQLCODE,
460: p_token2 => G_SQLERRM_TOKEN,