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

Line 140: IF FND_API.to_Boolean( p_init_msg_list ) THEN

136:
137: FND_MSG_PUB.DELETE_MSG;
138:
139: -- Initialize message list if p_init_msg_list is set to TRUE.
140: IF FND_API.to_Boolean( p_init_msg_list ) THEN
141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: -- Standard call to check for call compatibility.

Line 145: IF NOT FND_API.Compatible_API_Call (l_api_version,

141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call (l_api_version,
146: p_api_version_number,
147: l_api_name,
148: G_PKG_NAME )
149: THEN

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: p_api_version_number,
147: l_api_name,
148: G_PKG_NAME )
149: THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: -- Initialize API return status to success
154: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: -- Initialize API return status to success
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: -- API Body --
157:
158: -- Check if Required Values have been passed

Line 159: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR

155:
156: -- API Body --
157:
158: -- Check if Required Values have been passed
159: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR
160: OR TRIM(p_interest_code_rec.code) IS NULL
161: THEN
162: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
163: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);

Line 165: RAISE FND_API.G_EXC_ERROR;

161: THEN
162: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
163: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);
164: FND_MSG_PUB.Add;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:
168: IF p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM
169: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL

Line 168: IF p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM

164: FND_MSG_PUB.Add;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:
168: IF p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM
169: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL
170: THEN
171: FND_MESSAGE.SET_NAME ( 'ASF' , 'ASF_MISSING_INTEREST_TYPE');
172: --FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);

Line 174: RAISE FND_API.G_EXC_ERROR;

170: THEN
171: FND_MESSAGE.SET_NAME ( 'ASF' , 'ASF_MISSING_INTEREST_TYPE');
172: --FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
173: FND_MSG_PUB.Add;
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: IF p_interest_code_rec.master_enabled_flag NOT IN ('N','Y')
178: OR TRIM(p_interest_code_rec.master_enabled_flag) IS NULL

Line 179: OR p_interest_code_rec.master_enabled_flag = FND_API.G_MISS_CHAR

175: END IF;
176:
177: IF p_interest_code_rec.master_enabled_flag NOT IN ('N','Y')
178: OR TRIM(p_interest_code_rec.master_enabled_flag) IS NULL
179: OR p_interest_code_rec.master_enabled_flag = FND_API.G_MISS_CHAR
180: THEN
181: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
182: FND_MESSAGE.SET_TOKEN('MASTER_ENABLED_FLAG',p_interest_code_rec.master_enabled_flag);
183: FND_MSG_PUB.Add;

Line 184: RAISE FND_API.G_EXC_ERROR;

180: THEN
181: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
182: FND_MESSAGE.SET_TOKEN('MASTER_ENABLED_FLAG',p_interest_code_rec.master_enabled_flag);
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:
187: -- Check for Who columns to see if they values passed is G_MISS
188: -- Replace the G_MISS with NULL else replace with the value passed

Line 190: IF p_interest_code_rec.creation_date = FND_API.G_MISS_DATE

186:
187: -- Check for Who columns to see if they values passed is G_MISS
188: -- Replace the G_MISS with NULL else replace with the value passed
189:
190: IF p_interest_code_rec.creation_date = FND_API.G_MISS_DATE
191: OR TRIM(p_interest_code_rec.creation_date) IS NULL
192: THEN
193: l_creation_date := SYSDATE;
194: ELSE

Line 197: IF p_interest_code_rec.created_by = FND_API.G_MISS_NUM

193: l_creation_date := SYSDATE;
194: ELSE
195: l_creation_date := p_interest_code_rec.creation_date;
196: END IF;
197: IF p_interest_code_rec.created_by = FND_API.G_MISS_NUM
198: OR TRIM(p_interest_code_rec.created_by) IS NULL
199: THEN
200: l_created_by := FND_GLOBAL.user_id;
201: ELSE

Line 204: IF p_interest_code_rec.last_update_date = FND_API.G_MISS_DATE

200: l_created_by := FND_GLOBAL.user_id;
201: ELSE
202: l_created_by := p_interest_code_rec.created_by;
203: END IF;
204: IF p_interest_code_rec.last_update_date = FND_API.G_MISS_DATE
205: OR TRIM(p_interest_code_rec.last_update_date) IS NULL
206: THEN
207: l_last_update_date := SYSDATE;
208: ELSE

Line 211: IF p_interest_code_rec.last_updated_by = FND_API.G_MISS_NUM

207: l_last_update_date := SYSDATE;
208: ELSE
209: l_last_update_date := p_interest_code_rec.last_update_date;
210: END IF;
211: IF p_interest_code_rec.last_updated_by = FND_API.G_MISS_NUM
212: OR TRIM(p_interest_code_rec.last_updated_by) IS NULL
213: THEN
214: l_last_updated_by := FND_GLOBAL.user_id;
215: ELSE

Line 218: IF p_interest_code_rec.last_update_login = FND_API.G_MISS_NUM

214: l_last_updated_by := FND_GLOBAL.user_id;
215: ELSE
216: l_last_updated_by := p_interest_code_rec.last_updated_by;
217: END IF;
218: IF p_interest_code_rec.last_update_login = FND_API.G_MISS_NUM
219: OR TRIM(p_interest_code_rec.last_update_login) IS NULL
220: THEN
221: l_last_update_login := FND_GLOBAL.login_id;
222: ELSE

Line 233: IF p_interest_code_rec.parent_interest_code_id = FND_API.G_MISS_NUM

229: -- replace with NULL before insert. Else use the value passed for insert.
230: -- Only optional fields needs to be checked for Insert and replace with
231: -- NULL for required fields the DB will throw error.
232:
233: IF p_interest_code_rec.parent_interest_code_id = FND_API.G_MISS_NUM
234: THEN
235: l_parent_interest_code_id := NULL;
236: ELSE
237: l_parent_interest_code_id := p_interest_code_rec.parent_interest_code_id;

Line 240: IF p_interest_code_rec.category_id = FND_API.G_MISS_NUM

236: ELSE
237: l_parent_interest_code_id := p_interest_code_rec.parent_interest_code_id;
238: END IF;
239:
240: IF p_interest_code_rec.category_id = FND_API.G_MISS_NUM
241: OR TRIM(p_interest_code_rec.category_id) IS NULL
242: THEN
243: l_category_id := NULL;
244: ELSE

Line 247: IF p_interest_code_rec.category_set_id = FND_API.G_MISS_NUM

243: l_category_id := NULL;
244: ELSE
245: l_category_id := p_interest_code_rec.category_id;
246: END IF;
247: IF p_interest_code_rec.category_set_id = FND_API.G_MISS_NUM
248: OR TRIM(p_interest_code_rec.category_set_id) IS NULL
249: THEN
250: l_category_set_id := NULL;
251: ELSE

Line 254: IF p_interest_code_rec.attribute_category = FND_API.G_MISS_CHAR

250: l_category_set_id := NULL;
251: ELSE
252: l_category_set_id := p_interest_code_rec.category_set_id;
253: END IF;
254: IF p_interest_code_rec.attribute_category = FND_API.G_MISS_CHAR
255: OR TRIM(p_interest_code_rec.attribute_category) IS NULL
256: THEN
257: l_attribute_category := NULL;
258: ELSE

Line 261: IF p_interest_code_rec.attribute1 = FND_API.G_MISS_CHAR

257: l_attribute_category := NULL;
258: ELSE
259: l_attribute_category := p_interest_code_rec.attribute_category ;
260: END IF;
261: IF p_interest_code_rec.attribute1 = FND_API.G_MISS_CHAR
262: OR TRIM(p_interest_code_rec.attribute1) IS NULL
263: THEN
264: l_attribute1 := NULL;
265: ELSE

Line 268: IF p_interest_code_rec.attribute2 = FND_API.G_MISS_CHAR

264: l_attribute1 := NULL;
265: ELSE
266: l_attribute1 := p_interest_code_rec.attribute1;
267: END IF;
268: IF p_interest_code_rec.attribute2 = FND_API.G_MISS_CHAR
269: OR TRIM(p_interest_code_rec.attribute2) IS NULL
270: THEN
271: l_attribute2 := NULL;
272: ELSE

Line 275: IF p_interest_code_rec.attribute3 = FND_API.G_MISS_CHAR

271: l_attribute2 := NULL;
272: ELSE
273: l_attribute2 := p_interest_code_rec.attribute2;
274: END IF;
275: IF p_interest_code_rec.attribute3 = FND_API.G_MISS_CHAR
276: OR TRIM(p_interest_code_rec.attribute3) IS NULL
277: THEN
278: l_attribute3 := NULL;
279: ELSE

Line 282: IF p_interest_code_rec.attribute4 = FND_API.G_MISS_CHAR

278: l_attribute3 := NULL;
279: ELSE
280: l_attribute3 := p_interest_code_rec.attribute3;
281: END IF;
282: IF p_interest_code_rec.attribute4 = FND_API.G_MISS_CHAR
283: OR TRIM(p_interest_code_rec.attribute4) IS NULL
284: THEN
285: l_attribute4 := NULL;
286: ELSE

Line 289: IF p_interest_code_rec.attribute5 = FND_API.G_MISS_CHAR

285: l_attribute4 := NULL;
286: ELSE
287: l_attribute4 := p_interest_code_rec.attribute4;
288: END IF;
289: IF p_interest_code_rec.attribute5 = FND_API.G_MISS_CHAR
290: OR TRIM(p_interest_code_rec.attribute5) IS NULL
291: THEN
292: l_attribute5 := NULL;
293: ELSE

Line 296: IF p_interest_code_rec.attribute6 = FND_API.G_MISS_CHAR

292: l_attribute5 := NULL;
293: ELSE
294: l_attribute5 := p_interest_code_rec.attribute5;
295: END IF;
296: IF p_interest_code_rec.attribute6 = FND_API.G_MISS_CHAR
297: OR TRIM(p_interest_code_rec.attribute6) IS NULL
298: THEN
299: l_attribute6 := NULL;
300: ELSE

Line 303: IF p_interest_code_rec.attribute7 = FND_API.G_MISS_CHAR

299: l_attribute6 := NULL;
300: ELSE
301: l_attribute6 := p_interest_code_rec.attribute6;
302: END IF;
303: IF p_interest_code_rec.attribute7 = FND_API.G_MISS_CHAR
304: OR TRIM(p_interest_code_rec.attribute7) IS NULL
305: THEN
306: l_attribute7 := NULL;
307: ELSE

Line 310: IF p_interest_code_rec.attribute8 = FND_API.G_MISS_CHAR

306: l_attribute7 := NULL;
307: ELSE
308: l_attribute7 := p_interest_code_rec.attribute7;
309: END IF;
310: IF p_interest_code_rec.attribute8 = FND_API.G_MISS_CHAR
311: OR TRIM(p_interest_code_rec.attribute8) IS NULL
312: THEN
313: l_attribute8 := NULL;
314: ELSE

Line 317: IF p_interest_code_rec.attribute9 = FND_API.G_MISS_CHAR

313: l_attribute8 := NULL;
314: ELSE
315: l_attribute8 := p_interest_code_rec.attribute8;
316: END IF;
317: IF p_interest_code_rec.attribute9 = FND_API.G_MISS_CHAR
318: OR TRIM(p_interest_code_rec.attribute9) IS NULL
319: THEN
320: l_attribute9 := NULL;
321: ELSE

Line 324: IF p_interest_code_rec.attribute10 = FND_API.G_MISS_CHAR

320: l_attribute9 := NULL;
321: ELSE
322: l_attribute9 := p_interest_code_rec.attribute9;
323: END IF;
324: IF p_interest_code_rec.attribute10 = FND_API.G_MISS_CHAR
325: OR TRIM(p_interest_code_rec.attribute10) IS NULL
326: THEN
327: l_attribute10 := NULL;
328: ELSE

Line 331: IF p_interest_code_rec.attribute11 = FND_API.G_MISS_CHAR

327: l_attribute10 := NULL;
328: ELSE
329: l_attribute10 := p_interest_code_rec.attribute10;
330: END IF;
331: IF p_interest_code_rec.attribute11 = FND_API.G_MISS_CHAR
332: OR TRIM(p_interest_code_rec.attribute11) IS NULL
333: THEN
334: l_attribute11 := NULL;
335: ELSE

Line 338: IF p_interest_code_rec.attribute12 = FND_API.G_MISS_CHAR

334: l_attribute11 := NULL;
335: ELSE
336: l_attribute11 := p_interest_code_rec.attribute11;
337: END IF;
338: IF p_interest_code_rec.attribute12 = FND_API.G_MISS_CHAR
339: OR TRIM(p_interest_code_rec.attribute12) IS NULL
340: THEN
341: l_attribute12 := NULL;
342: ELSE

Line 345: IF p_interest_code_rec.attribute13 = FND_API.G_MISS_CHAR

341: l_attribute12 := NULL;
342: ELSE
343: l_attribute12 := p_interest_code_rec.attribute12;
344: END IF;
345: IF p_interest_code_rec.attribute13 = FND_API.G_MISS_CHAR
346: OR TRIM(p_interest_code_rec.attribute13) IS NULL
347: THEN
348: l_attribute13 := NULL;
349: ELSE

Line 352: IF p_interest_code_rec.attribute14 = FND_API.G_MISS_CHAR

348: l_attribute13 := NULL;
349: ELSE
350: l_attribute13 := p_interest_code_rec.attribute13;
351: END IF;
352: IF p_interest_code_rec.attribute14 = FND_API.G_MISS_CHAR
353: OR TRIM(p_interest_code_rec.attribute14) IS NULL
354: THEN
355: l_attribute14 := NULL;
356: ELSE

Line 359: IF p_interest_code_rec.attribute15 = FND_API.G_MISS_CHAR

355: l_attribute14 := NULL;
356: ELSE
357: l_attribute14 := p_interest_code_rec.attribute14;
358: END IF;
359: IF p_interest_code_rec.attribute15 = FND_API.G_MISS_CHAR
360: OR TRIM(p_interest_code_rec.attribute15) IS NULL
361: THEN
362: l_attribute15 := NULL;
363: ELSE

Line 366: IF p_interest_code_rec.pf_item_id = FND_API.G_MISS_NUM

362: l_attribute15 := NULL;
363: ELSE
364: l_attribute15 := p_interest_code_rec.attribute15;
365: END IF;
366: IF p_interest_code_rec.pf_item_id = FND_API.G_MISS_NUM
367: OR TRIM(p_interest_code_rec.pf_item_id) IS NULL
368: THEN
369: l_pf_item_id := NULL;
370: ELSE

Line 373: IF p_interest_code_rec.pf_organization_id = FND_API.G_MISS_NUM

369: l_pf_item_id := NULL;
370: ELSE
371: l_pf_item_id := p_interest_code_rec.pf_item_id ;
372: END IF;
373: IF p_interest_code_rec.pf_organization_id = FND_API.G_MISS_NUM
374: OR TRIM(p_interest_code_rec.pf_organization_id) IS NULL
375: THEN
376: l_pf_organization_id := NULL;
377: ELSE

Line 380: IF p_interest_code_rec.price = FND_API.G_MISS_NUM

376: l_pf_organization_id := NULL;
377: ELSE
378: l_pf_organization_id := p_interest_code_rec.pf_organization_id ;
379: END IF;
380: IF p_interest_code_rec.price = FND_API.G_MISS_NUM
381: OR TRIM(p_interest_code_rec.price) IS NULL
382: THEN
383: l_price := NULL;
384: ELSE

Line 387: IF p_interest_code_rec.currency_code = FND_API.G_MISS_CHAR

383: l_price := NULL;
384: ELSE
385: l_price := p_interest_code_rec.price ;
386: END IF;
387: IF p_interest_code_rec.currency_code = FND_API.G_MISS_CHAR
388: OR TRIM(p_interest_code_rec.currency_code) IS NULL
389: THEN
390: l_currency_code := NULL;
391: ELSE

Line 394: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR

390: l_currency_code := NULL;
391: ELSE
392: l_currency_code := p_interest_code_rec.currency_code ;
393: END IF;
394: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR
395: OR TRIM(p_interest_code_rec.code) IS NULL
396: THEN
397: l_code := NULL;
398: ELSE

Line 401: IF p_interest_code_rec.description = FND_API.G_MISS_CHAR

397: l_code := NULL;
398: ELSE
399: l_code := p_interest_code_rec.code ;
400: END IF;
401: IF p_interest_code_rec.description = FND_API.G_MISS_CHAR
402: OR TRIM(p_interest_code_rec.description) IS NULL
403: THEN
404: l_description := NULL;
405: ELSE

Line 409: IF (p_interest_code_rec.prod_cat_set_id = FND_API.G_MISS_NUM) THEN

405: ELSE
406: l_description := p_interest_code_rec.description ;
407: END IF;
408:
409: IF (p_interest_code_rec.prod_cat_set_id = FND_API.G_MISS_NUM) THEN
410: l_prod_cat_set_id := NULL;
411: ELSE
412: l_prod_cat_set_id := p_interest_code_rec.prod_cat_set_id;
413: END IF;

Line 415: IF (p_interest_code_rec.prod_cat_id = FND_API.G_MISS_NUM) THEN

411: ELSE
412: l_prod_cat_set_id := p_interest_code_rec.prod_cat_set_id;
413: END IF;
414:
415: IF (p_interest_code_rec.prod_cat_id = FND_API.G_MISS_NUM) THEN
416: l_prod_cat_id := NULL;
417: ELSE
418: l_prod_cat_id := p_interest_code_rec.prod_cat_id;
419: END IF;

Line 436: RAISE FND_API.G_EXC_ERROR;

432: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');
433: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);
434: FND_MSG_PUB.Add;
435: CLOSE as_int_code_cur;
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;
438: CLOSE as_int_code_cur;
439: END IF;
440:

Line 450: RAISE FND_API.G_EXC_ERROR;

446: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
447: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
448: FND_MSG_PUB.Add;
449: CLOSE as_int_type_cur;
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;
452: CLOSE as_int_type_cur;
453: END IF;
454:

Line 469: RAISE FND_API.G_EXC_ERROR;

465: THEN
466: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
467: FND_MSG_PUB.Add;
468: CLOSE as_int_codes_vl_cur;
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471: CLOSE as_int_codes_vl_cur;
472:
473: ELSE

Line 486: RAISE FND_API.G_EXC_ERROR;

482: THEN
483: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
484: FND_MSG_PUB.Add;
485: CLOSE as_int_codes_vl_1_cur;
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488: CLOSE as_int_codes_vl_1_cur;
489: END IF;
490:

Line 497: RAISE FND_API.G_EXC_ERROR;

493: FETCH as_int_code_nextval_cur INTO x_interest_code_id;
494: IF as_int_code_nextval_cur%NOTFOUND
495: THEN
496: CLOSE as_int_code_nextval_cur;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499: CLOSE as_int_code_nextval_cur;
500:
501: if (l_prod_cat_set_id is not null

Line 519: RAISE fnd_api.g_exc_error;

515:
516: if (l_prod_cat_not_found = 'Y') THEN
517: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');
518: fnd_msg_pub.add;
519: RAISE fnd_api.g_exc_error;
520: end if;
521:
522: -- Insert a New Interest Code into table
523: as_interest_codes_pkg.insert_row(

Line 564: IF FND_API.To_Boolean( p_commit ) THEN

560: );
561:
562:
563: -- Standard check of p_commit.
564: IF FND_API.To_Boolean( p_commit ) THEN
565: COMMIT WORK;
566: END IF;
567:
568: -- Standard call to get message count and if count is 1,

Line 575: WHEN FND_API.G_EXC_ERROR THEN

571: p_count => x_msg_count,
572: p_data => x_msg_data
573: );
574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
577: P_MODULE => l_module
578: ,P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME

Line 586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

582: ,X_MSG_COUNT => X_MSG_COUNT
583: ,X_MSG_DATA => X_MSG_DATA
584: ,X_RETURN_STATUS => X_RETURN_STATUS);
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
588: P_MODULE => l_module
589: ,P_API_NAME => L_API_NAME
590: ,P_PKG_NAME => G_PKG_NAME

Line 797: IF FND_API.to_Boolean( p_init_msg_list ) THEN

793:
794: FND_MSG_PUB.DELETE_MSG;
795:
796: -- Initialize message list if p_init_msg_list is set to TRUE.
797: IF FND_API.to_Boolean( p_init_msg_list ) THEN
798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: -- Standard call to check for call compatibility.

Line 802: IF NOT FND_API.Compatible_API_Call (l_api_version,

798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: -- Standard call to check for call compatibility.
802: IF NOT FND_API.Compatible_API_Call (l_api_version,
803: p_api_version_number,
804: l_api_name,
805: G_PKG_NAME )
806: THEN

Line 807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

803: p_api_version_number,
804: l_api_name,
805: G_PKG_NAME )
806: THEN
807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
808: END IF;
809:
810:
811: -- Initialize API return status to success

Line 812: x_return_status := FND_API.G_RET_STS_SUCCESS;

808: END IF;
809:
810:
811: -- Initialize API return status to success
812: x_return_status := FND_API.G_RET_STS_SUCCESS;
813:
814: -- API Body --
815: -- Check if Required Values have been passed
816:

Line 817: IF (p_interest_code_rec.interest_code_id = FND_API.G_MISS_NUM)

813:
814: -- API Body --
815: -- Check if Required Values have been passed
816:
817: IF (p_interest_code_rec.interest_code_id = FND_API.G_MISS_NUM)
818: OR TRIM(p_interest_code_rec.interest_code_id) IS NULL
819: THEN
820: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
821: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);

Line 823: RAISE FND_API.G_EXC_ERROR;

819: THEN
820: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
821: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);
822: FND_MSG_PUB.Add;
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;
825:
826: IF (p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM )
827: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL

Line 826: IF (p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM )

822: FND_MSG_PUB.Add;
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;
825:
826: IF (p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM )
827: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL
828: THEN
829: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
830: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);

Line 832: RAISE FND_API.G_EXC_ERROR;

828: THEN
829: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
830: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
831: FND_MSG_PUB.Add;
832: RAISE FND_API.G_EXC_ERROR;
833: ELSE
834: OPEN validate_interest_type_cur(p_interest_code_rec.interest_type_id);
835: FETCH validate_interest_type_cur INTO l_count;
836: IF validate_interest_type_cur%NOTFOUND

Line 839: RAISE FND_API.G_EXC_ERROR;

835: FETCH validate_interest_type_cur INTO l_count;
836: IF validate_interest_type_cur%NOTFOUND
837: THEN
838: CLOSE validate_interest_type_cur;
839: RAISE FND_API.G_EXC_ERROR;
840: ELSE
841: x_interest_type_id := p_interest_code_rec.interest_type_id;
842: END IF;
843: CLOSE validate_interest_type_cur;

Line 887: RAISE fnd_api.g_exc_error;

883:
884: IF fetch_db_value_cur%NOTFOUND
885: THEN
886: CLOSE fetch_db_value_cur;
887: RAISE fnd_api.g_exc_error;
888: END IF;
889: CLOSE fetch_db_value_cur;
890:
891:

Line 895: IF p_interest_code_rec.last_update_date = FND_API.G_MISS_DATE

891:
892: -- For Who Columns if the value passed is G_miss then default them
893: -- else use the passed value
894:
895: IF p_interest_code_rec.last_update_date = FND_API.G_MISS_DATE
896: OR TRIM(p_interest_code_rec.last_update_date) IS NULL
897: THEN
898: x_last_update_date := SYSDATE;
899: ELSE

Line 902: IF p_interest_code_rec.last_updated_by = FND_API.G_MISS_NUM

898: x_last_update_date := SYSDATE;
899: ELSE
900: x_last_update_date := p_interest_code_rec.last_update_date;
901: END IF;
902: IF p_interest_code_rec.last_updated_by = FND_API.G_MISS_NUM
903: OR TRIM(p_interest_code_rec.last_updated_by) IS NULL
904: THEN
905: x_last_updated_by := FND_GLOBAL.user_id;
906: ELSE

Line 909: IF p_interest_code_rec.last_update_login = FND_API.G_MISS_NUM

905: x_last_updated_by := FND_GLOBAL.user_id;
906: ELSE
907: x_last_updated_by := p_interest_code_rec.last_updated_by;
908: END IF;
909: IF p_interest_code_rec.last_update_login = FND_API.G_MISS_NUM
910: OR TRIM(p_interest_code_rec.last_update_login) IS NULL
911: THEN
912: x_last_update_login := FND_GLOBAL.login_id;
913: ELSE

Line 922: IF p_interest_code_rec.parent_interest_code_id = FND_API.G_MISS_NUM

918: -- For all other required and optional columns check to see if the
919: -- value is g_miss then replace them with the database fetched column.
920:
921:
922: IF p_interest_code_rec.parent_interest_code_id = FND_API.G_MISS_NUM
923: THEN
924: x_parent_interest_code_id := l_parent_interest_code_id;
925: ELSE
926: -- make sure it is a valid parent_interest_code_id

Line 936: RAISE FND_API.G_EXC_ERROR;

932: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');
933: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);
934: FND_MSG_PUB.Add;
935: CLOSE validate_parent_int_code_cur;
936: RAISE FND_API.G_EXC_ERROR;
937: ELSE
938: x_parent_interest_code_id := p_interest_code_rec.parent_interest_code_id;
939: END IF;
940: CLOSE validate_parent_int_code_cur;

Line 943: IF p_interest_code_rec.master_enabled_flag = FND_API.G_MISS_CHAR

939: END IF;
940: CLOSE validate_parent_int_code_cur;
941: END IF;
942:
943: IF p_interest_code_rec.master_enabled_flag = FND_API.G_MISS_CHAR
944: THEN
945: x_master_enabled_flag := l_master_enabled_flag;
946: ELSE
947: -- make sure master enabled flag is valid

Line 951: RAISE FND_API.G_EXC_ERROR;

947: -- make sure master enabled flag is valid
948: IF p_interest_code_rec.master_enabled_flag NOT IN ('N','Y') THEN
949: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
950: FND_MSG_PUB.Add;
951: RAISE FND_API.G_EXC_ERROR;
952: ELSE
953: x_master_enabled_flag := p_interest_code_rec.master_enabled_flag;
954: END IF;
955: END IF;

Line 960: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR

956:
957: -- Check to see if the value passed is G_MISS if so replace the
958: -- value with the fetched value from the database.
959:
960: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR
961: THEN
962: x_code := l_code ;
963: ELSE
964: x_code := p_interest_code_rec.code ;

Line 966: IF p_interest_code_rec.category_id = FND_API.G_MISS_NUM

962: x_code := l_code ;
963: ELSE
964: x_code := p_interest_code_rec.code ;
965: END IF;
966: IF p_interest_code_rec.category_id = FND_API.G_MISS_NUM
967: THEN
968: x_category_id := l_category_id ;
969: ELSE
970: x_category_id := p_interest_code_rec.category_id;

Line 972: IF p_interest_code_rec.category_set_id = FND_API.G_MISS_NUM

968: x_category_id := l_category_id ;
969: ELSE
970: x_category_id := p_interest_code_rec.category_id;
971: END IF;
972: IF p_interest_code_rec.category_set_id = FND_API.G_MISS_NUM
973: THEN
974: x_category_set_id := l_category_set_id ;
975: ELSE
976: x_category_set_id := p_interest_code_rec.category_set_id;

Line 978: IF p_interest_code_rec.attribute_category = FND_API.G_MISS_CHAR

974: x_category_set_id := l_category_set_id ;
975: ELSE
976: x_category_set_id := p_interest_code_rec.category_set_id;
977: END IF;
978: IF p_interest_code_rec.attribute_category = FND_API.G_MISS_CHAR
979: THEN
980: x_attribute_category := l_attribute_category ;
981: ELSE
982: x_attribute_category := p_interest_code_rec.attribute_category ;

Line 984: IF p_interest_code_rec.attribute1 = FND_API.G_MISS_CHAR

980: x_attribute_category := l_attribute_category ;
981: ELSE
982: x_attribute_category := p_interest_code_rec.attribute_category ;
983: END IF;
984: IF p_interest_code_rec.attribute1 = FND_API.G_MISS_CHAR
985: THEN
986: x_attribute1 := l_attribute1 ;
987: ELSE
988: x_attribute1 := p_interest_code_rec.attribute1;

Line 990: IF p_interest_code_rec.attribute2 = FND_API.G_MISS_CHAR

986: x_attribute1 := l_attribute1 ;
987: ELSE
988: x_attribute1 := p_interest_code_rec.attribute1;
989: END IF;
990: IF p_interest_code_rec.attribute2 = FND_API.G_MISS_CHAR
991: THEN
992: x_attribute2 := l_attribute2 ;
993: ELSE
994: x_attribute2 := p_interest_code_rec.attribute2;

Line 996: IF p_interest_code_rec.attribute3 = FND_API.G_MISS_CHAR

992: x_attribute2 := l_attribute2 ;
993: ELSE
994: x_attribute2 := p_interest_code_rec.attribute2;
995: END IF;
996: IF p_interest_code_rec.attribute3 = FND_API.G_MISS_CHAR
997: THEN
998: x_attribute3 := l_attribute3 ;
999: ELSE
1000: x_attribute3 := p_interest_code_rec.attribute3;

Line 1002: IF p_interest_code_rec.attribute4 = FND_API.G_MISS_CHAR

998: x_attribute3 := l_attribute3 ;
999: ELSE
1000: x_attribute3 := p_interest_code_rec.attribute3;
1001: END IF;
1002: IF p_interest_code_rec.attribute4 = FND_API.G_MISS_CHAR
1003: THEN
1004: x_attribute4 := l_attribute4 ;
1005: ELSE
1006: x_attribute4 := p_interest_code_rec.attribute4;

Line 1008: IF p_interest_code_rec.attribute5 = FND_API.G_MISS_CHAR

1004: x_attribute4 := l_attribute4 ;
1005: ELSE
1006: x_attribute4 := p_interest_code_rec.attribute4;
1007: END IF;
1008: IF p_interest_code_rec.attribute5 = FND_API.G_MISS_CHAR
1009: THEN
1010: x_attribute5 := l_attribute5 ;
1011: ELSE
1012: x_attribute5 := p_interest_code_rec.attribute5;

Line 1014: IF p_interest_code_rec.attribute6 = FND_API.G_MISS_CHAR

1010: x_attribute5 := l_attribute5 ;
1011: ELSE
1012: x_attribute5 := p_interest_code_rec.attribute5;
1013: END IF;
1014: IF p_interest_code_rec.attribute6 = FND_API.G_MISS_CHAR
1015: THEN
1016: x_attribute6 := l_attribute6 ;
1017: ELSE
1018: x_attribute6 := p_interest_code_rec.attribute6;

Line 1020: IF p_interest_code_rec.attribute7 = FND_API.G_MISS_CHAR

1016: x_attribute6 := l_attribute6 ;
1017: ELSE
1018: x_attribute6 := p_interest_code_rec.attribute6;
1019: END IF;
1020: IF p_interest_code_rec.attribute7 = FND_API.G_MISS_CHAR
1021: THEN
1022: x_attribute7 := l_attribute7 ;
1023: ELSE
1024: x_attribute7 := p_interest_code_rec.attribute7;

Line 1026: IF p_interest_code_rec.attribute8 = FND_API.G_MISS_CHAR

1022: x_attribute7 := l_attribute7 ;
1023: ELSE
1024: x_attribute7 := p_interest_code_rec.attribute7;
1025: END IF;
1026: IF p_interest_code_rec.attribute8 = FND_API.G_MISS_CHAR
1027: THEN
1028: x_attribute8 := l_attribute8 ;
1029: ELSE
1030: x_attribute8 := p_interest_code_rec.attribute8;

Line 1032: IF p_interest_code_rec.attribute9 = FND_API.G_MISS_CHAR

1028: x_attribute8 := l_attribute8 ;
1029: ELSE
1030: x_attribute8 := p_interest_code_rec.attribute8;
1031: END IF;
1032: IF p_interest_code_rec.attribute9 = FND_API.G_MISS_CHAR
1033: THEN
1034: x_attribute9 := l_attribute9 ;
1035: ELSE
1036: x_attribute9 := p_interest_code_rec.attribute9;

Line 1038: IF p_interest_code_rec.attribute10 = FND_API.G_MISS_CHAR

1034: x_attribute9 := l_attribute9 ;
1035: ELSE
1036: x_attribute9 := p_interest_code_rec.attribute9;
1037: END IF;
1038: IF p_interest_code_rec.attribute10 = FND_API.G_MISS_CHAR
1039: THEN
1040: x_attribute10 := l_attribute10 ;
1041: ELSE
1042: x_attribute10 := p_interest_code_rec.attribute10;

Line 1044: IF p_interest_code_rec.attribute11 = FND_API.G_MISS_CHAR

1040: x_attribute10 := l_attribute10 ;
1041: ELSE
1042: x_attribute10 := p_interest_code_rec.attribute10;
1043: END IF;
1044: IF p_interest_code_rec.attribute11 = FND_API.G_MISS_CHAR
1045: THEN
1046: x_attribute11 := l_attribute11 ;
1047: ELSE
1048: x_attribute11 := p_interest_code_rec.attribute11;

Line 1050: IF p_interest_code_rec.attribute12 = FND_API.G_MISS_CHAR

1046: x_attribute11 := l_attribute11 ;
1047: ELSE
1048: x_attribute11 := p_interest_code_rec.attribute11;
1049: END IF;
1050: IF p_interest_code_rec.attribute12 = FND_API.G_MISS_CHAR
1051: THEN
1052: x_attribute12 := l_attribute12 ;
1053: ELSE
1054: x_attribute12 := p_interest_code_rec.attribute12;

Line 1056: IF p_interest_code_rec.attribute13 = FND_API.G_MISS_CHAR

1052: x_attribute12 := l_attribute12 ;
1053: ELSE
1054: x_attribute12 := p_interest_code_rec.attribute12;
1055: END IF;
1056: IF p_interest_code_rec.attribute13 = FND_API.G_MISS_CHAR
1057: THEN
1058: x_attribute13 := l_attribute13 ;
1059: ELSE
1060: x_attribute13 := p_interest_code_rec.attribute13;

Line 1062: IF p_interest_code_rec.attribute14 = FND_API.G_MISS_CHAR

1058: x_attribute13 := l_attribute13 ;
1059: ELSE
1060: x_attribute13 := p_interest_code_rec.attribute13;
1061: END IF;
1062: IF p_interest_code_rec.attribute14 = FND_API.G_MISS_CHAR
1063: THEN
1064: x_attribute14 := l_attribute14 ;
1065: ELSE
1066: x_attribute14 := p_interest_code_rec.attribute14;

Line 1068: IF p_interest_code_rec.attribute15 = FND_API.G_MISS_CHAR

1064: x_attribute14 := l_attribute14 ;
1065: ELSE
1066: x_attribute14 := p_interest_code_rec.attribute14;
1067: END IF;
1068: IF p_interest_code_rec.attribute15 = FND_API.G_MISS_CHAR
1069: THEN
1070: x_attribute15 := l_attribute15 ;
1071: ELSE
1072: x_attribute15 := p_interest_code_rec.attribute15;

Line 1074: IF p_interest_code_rec.pf_item_id = FND_API.G_MISS_NUM

1070: x_attribute15 := l_attribute15 ;
1071: ELSE
1072: x_attribute15 := p_interest_code_rec.attribute15;
1073: END IF;
1074: IF p_interest_code_rec.pf_item_id = FND_API.G_MISS_NUM
1075: THEN
1076: x_pf_item_id := l_pf_item_id ;
1077: ELSE
1078: x_pf_item_id := p_interest_code_rec.pf_item_id ;

Line 1080: IF p_interest_code_rec.pf_organization_id = FND_API.G_MISS_NUM

1076: x_pf_item_id := l_pf_item_id ;
1077: ELSE
1078: x_pf_item_id := p_interest_code_rec.pf_item_id ;
1079: END IF;
1080: IF p_interest_code_rec.pf_organization_id = FND_API.G_MISS_NUM
1081: THEN
1082: x_pf_organization_id := l_pf_organization_id ;
1083: ELSE
1084: x_pf_organization_id := p_interest_code_rec.pf_organization_id ;

Line 1086: IF p_interest_code_rec.price = FND_API.G_MISS_NUM

1082: x_pf_organization_id := l_pf_organization_id ;
1083: ELSE
1084: x_pf_organization_id := p_interest_code_rec.pf_organization_id ;
1085: END IF;
1086: IF p_interest_code_rec.price = FND_API.G_MISS_NUM
1087: THEN
1088: x_price := l_price ;
1089: ELSE
1090: x_price := p_interest_code_rec.price ;

Line 1092: IF p_interest_code_rec.currency_code = FND_API.G_MISS_CHAR

1088: x_price := l_price ;
1089: ELSE
1090: x_price := p_interest_code_rec.price ;
1091: END IF;
1092: IF p_interest_code_rec.currency_code = FND_API.G_MISS_CHAR
1093: THEN
1094: x_currency_code := l_currency_code ;
1095: ELSE
1096: x_currency_code := p_interest_code_rec.currency_code ;

Line 1098: IF p_interest_code_rec.description = FND_API.G_MISS_CHAR

1094: x_currency_code := l_currency_code ;
1095: ELSE
1096: x_currency_code := p_interest_code_rec.currency_code ;
1097: END IF;
1098: IF p_interest_code_rec.description = FND_API.G_MISS_CHAR
1099: THEN
1100: x_description := l_description;
1101: ELSE
1102: x_description := p_interest_code_rec.description ;

Line 1105: IF p_interest_code_rec.prod_cat_set_id = FND_API.G_MISS_NUM THEN

1101: ELSE
1102: x_description := p_interest_code_rec.description ;
1103: END IF;
1104:
1105: IF p_interest_code_rec.prod_cat_set_id = FND_API.G_MISS_NUM THEN
1106: x_prod_cat_set_id := l_prod_cat_set_id;
1107: ELSE
1108: x_prod_cat_set_id := p_interest_code_rec.prod_cat_set_id;
1109: END IF;

Line 1111: IF p_interest_code_rec.prod_cat_id = FND_API.G_MISS_NUM THEN

1107: ELSE
1108: x_prod_cat_set_id := p_interest_code_rec.prod_cat_set_id;
1109: END IF;
1110:
1111: IF p_interest_code_rec.prod_cat_id = FND_API.G_MISS_NUM THEN
1112: x_prod_cat_id := l_prod_cat_id;
1113: ELSE
1114: x_prod_cat_id := p_interest_code_rec.prod_cat_id;
1115: END IF;

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125: THEN
1126: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
1127: FND_MSG_PUB.Add;
1128: CLOSE as_int_codes_vl_cur;
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131: CLOSE as_int_codes_vl_cur;
1132:
1133: ELSE

Line 1147: RAISE FND_API.G_EXC_ERROR;

1143: THEN
1144: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
1145: FND_MSG_PUB.Add;
1146: CLOSE as_int_codes_vl_1_cur;
1147: RAISE FND_API.G_EXC_ERROR;
1148: END IF;
1149: CLOSE as_int_codes_vl_1_cur;
1150: END IF;
1151:

Line 1169: RAISE fnd_api.g_exc_error;

1165:
1166: if (l_prod_cat_not_found = 'Y') THEN
1167: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');
1168: fnd_msg_pub.add;
1169: RAISE fnd_api.g_exc_error;
1170: end if;
1171:
1172: -- Lock the row for update. Check to see if the fetched value is same still.
1173: -- If they are same then update the record else give a message that the row has been

Line 1181: RAISE fnd_api.g_exc_unexpected_error;

1177: FETCH lock_row_for_update INTO l_current_last_update_date;
1178: IF lock_row_for_update%NOTFOUND
1179: THEN
1180: CLOSE lock_row_for_update;
1181: RAISE fnd_api.g_exc_unexpected_error;
1182: END IF;
1183:
1184: IF l_last_update_date <> l_current_last_update_date
1185: THEN

Line 1189: RAISE fnd_api.g_exc_unexpected_error;

1185: THEN
1186: fnd_message.set_name('AS', 'API_RECORD_CHANGED');
1187: FND_MESSAGE.Set_Token('INFO', 'interest_code', FALSE); -- ??
1188: fnd_msg_pub.add;
1189: RAISE fnd_api.g_exc_unexpected_error;
1190: END IF;
1191:
1192: -- Update the Row using the API
1193: as_interest_codes_pkg.update_row(

Line 1233: IF FND_API.To_Boolean( p_commit ) THEN

1229: -- Close Cursors
1230: CLOSE lock_row_for_update ;
1231:
1232: -- Standard check of p_commit.
1233: IF FND_API.To_Boolean( p_commit ) THEN
1234: COMMIT WORK;
1235: END IF;
1236:
1237: -- Standard call to get message count and if count is 1,

Line 1245: WHEN FND_API.G_EXC_ERROR THEN

1241: p_data => x_msg_data
1242: );
1243:
1244: EXCEPTION
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1247: P_MODULE => l_module
1248: ,P_API_NAME => L_API_NAME
1249: ,P_PKG_NAME => G_PKG_NAME

Line 1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1252: ,X_MSG_COUNT => X_MSG_COUNT
1253: ,X_MSG_DATA => X_MSG_DATA
1254: ,X_RETURN_STATUS => X_RETURN_STATUS);
1255:
1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1258: P_MODULE => l_module
1259: ,P_API_NAME => L_API_NAME
1260: ,P_PKG_NAME => G_PKG_NAME