DBA Data[Home] [Help]

APPS.JTF_RS_TABLE_ATTRIBUTES_PVT dependencies on FND_API

Line 86: x_return_status := fnd_api.g_ret_sts_success;

82: BEGIN
83: --Standard Start of API SAVEPOINT
84: SAVEPOINT TABLE_ATTRIBUTE_SP;
85:
86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: --Standard Call to check API compatibility
89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
90: THEN

Line 89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

85:
86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: --Standard Call to check API compatibility
89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
90: THEN
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:

Line 91: RAISE FND_API.G_EXC_ERROR;

87:
88: --Standard Call to check API compatibility
89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
90: THEN
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:
94: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
95: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 95: IF FND_API.To_boolean(P_INIT_MSG_LIST)

91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:
94: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
95: IF FND_API.To_boolean(P_INIT_MSG_LIST)
96: THEN
97: FND_MSG_PUB.Initialize;
98: END IF;
99:

Line 157: raise fnd_api.g_exc_error;

153: x_attribute_id := attribute_dup_rec.attribute_id;
154: fnd_message.set_name ('JTF', 'JTF_RS_ATT_DUP');
155: FND_MSG_PUB.add;
156: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
157: raise fnd_api.g_exc_error;
158: END IF;
159: CLOSE attribute_dup_cur;
160:
161: ELSIF (l_go_ahead = 'NO') THEN

Line 166: raise fnd_api.g_exc_error;

162: x_attribute_id := null;
163: fnd_message.set_name ('JTF', 'JTF_RS_ATT_CREATE_ERR');
164: FND_MSG_PUB.add;
165: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
166: raise fnd_api.g_exc_error;
167: END IF;
168:
169:
170: --standard commit

Line 171: IF fnd_api.to_boolean (p_commit)

167: END IF;
168:
169:
170: --standard commit
171: IF fnd_api.to_boolean (p_commit)
172: THEN
173: COMMIT WORK;
174: END IF;
175:

Line 179: WHEN fnd_api.g_exc_unexpected_error

175:
176: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
177:
178: EXCEPTION
179: WHEN fnd_api.g_exc_unexpected_error
180: THEN
181: ROLLBACK TO TABLE_ATTRIBUTE_SP;
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 182: x_return_status := fnd_api.g_ret_sts_unexp_error;

178: EXCEPTION
179: WHEN fnd_api.g_exc_unexpected_error
180: THEN
181: ROLLBACK TO TABLE_ATTRIBUTE_SP;
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
184: WHEN fnd_api.g_exc_error
185: THEN
186: ROLLBACK TO TABLE_ATTRIBUTE_SP;

Line 184: WHEN fnd_api.g_exc_error

180: THEN
181: ROLLBACK TO TABLE_ATTRIBUTE_SP;
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
184: WHEN fnd_api.g_exc_error
185: THEN
186: ROLLBACK TO TABLE_ATTRIBUTE_SP;
187: x_return_status := fnd_api.g_ret_sts_error;
188: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 187: x_return_status := fnd_api.g_ret_sts_error;

183: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
184: WHEN fnd_api.g_exc_error
185: THEN
186: ROLLBACK TO TABLE_ATTRIBUTE_SP;
187: x_return_status := fnd_api.g_ret_sts_error;
188: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
189: WHEN OTHERS
190: THEN
191: ROLLBACK TO ROLE_RELATE_SP;

Line 197: x_return_status := fnd_api.g_ret_sts_unexp_error;

193: fnd_message.set_token('P_SQLCODE',SQLCODE);
194: fnd_message.set_token('P_SQLERRM',SQLERRM);
195: fnd_message.set_token('P_API_NAME', l_api_name);
196: FND_MSG_PUB.add;
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
199:
200: END create_table_attribute;
201:

Line 310: x_return_status := fnd_api.g_ret_sts_success;

306: BEGIN
307: --Standard Start of API SAVEPOINT
308: SAVEPOINT TABLE_ATTRIBUTE_SP;
309:
310: x_return_status := fnd_api.g_ret_sts_success;
311:
312: --Standard Call to check API compatibility
313: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
314: THEN

Line 313: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

309:
310: x_return_status := fnd_api.g_ret_sts_success;
311:
312: --Standard Call to check API compatibility
313: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
314: THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:

Line 315: RAISE FND_API.G_EXC_ERROR;

311:
312: --Standard Call to check API compatibility
313: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
314: THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
319: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 319: IF FND_API.To_boolean(P_INIT_MSG_LIST)

315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
319: IF FND_API.To_boolean(P_INIT_MSG_LIST)
320: THEN
321: FND_MSG_PUB.Initialize;
322: END IF;
323:

Line 335: IF (p_attribute_name = FND_API.G_MISS_CHAR)

331: FETCH table_attribute_cur INTO table_attribute_rec;
332:
333: IF (table_attribute_cur%found) THEN
334:
335: IF (p_attribute_name = FND_API.G_MISS_CHAR)
336: THEN
337: l_attribute_name := table_attribute_rec.attribute_name;
338: ELSE
339: l_attribute_name := p_attribute_name;

Line 341: IF (p_attribute_access_level = FND_API.G_MISS_CHAR)

337: l_attribute_name := table_attribute_rec.attribute_name;
338: ELSE
339: l_attribute_name := p_attribute_name;
340: END IF;
341: IF (p_attribute_access_level = FND_API.G_MISS_CHAR)
342: THEN
343: l_attribute_access_level := table_attribute_rec.attribute_access_level;
344: ELSE
345: l_attribute_access_level := p_attribute_access_level;

Line 347: IF (p_user_attribute_name = FND_API.G_MISS_CHAR)

343: l_attribute_access_level := table_attribute_rec.attribute_access_level;
344: ELSE
345: l_attribute_access_level := p_attribute_access_level;
346: END IF;
347: IF (p_user_attribute_name = FND_API.G_MISS_CHAR)
348: THEN
349: l_user_attribute_name := table_attribute_rec.user_attribute_name;
350: ELSE
351: l_user_attribute_name := p_user_attribute_name;

Line 353: IF(p_attribute1 = FND_API.G_MISS_CHAR)

349: l_user_attribute_name := table_attribute_rec.user_attribute_name;
350: ELSE
351: l_user_attribute_name := p_user_attribute_name;
352: END IF;
353: IF(p_attribute1 = FND_API.G_MISS_CHAR)
354: THEN
355: l_attribute1 := table_attribute_rec.attribute1;
356: ELSE
357: l_attribute1 := p_attribute1;

Line 359: IF(p_attribute2 = FND_API.G_MISS_CHAR)

355: l_attribute1 := table_attribute_rec.attribute1;
356: ELSE
357: l_attribute1 := p_attribute1;
358: END IF;
359: IF(p_attribute2 = FND_API.G_MISS_CHAR)
360: THEN
361: l_attribute2 := table_attribute_rec.attribute2;
362: ELSE
363: l_attribute2 := p_attribute2;

Line 365: IF(p_attribute3 = FND_API.G_MISS_CHAR)

361: l_attribute2 := table_attribute_rec.attribute2;
362: ELSE
363: l_attribute2 := p_attribute2;
364: END IF;
365: IF(p_attribute3 = FND_API.G_MISS_CHAR)
366: THEN
367: l_attribute3 := table_attribute_rec.attribute3;
368: ELSE
369: l_attribute3 := p_attribute3;

Line 371: IF(p_attribute4 = FND_API.G_MISS_CHAR)

367: l_attribute3 := table_attribute_rec.attribute3;
368: ELSE
369: l_attribute3 := p_attribute3;
370: END IF;
371: IF(p_attribute4 = FND_API.G_MISS_CHAR)
372: THEN
373: l_attribute4 := table_attribute_rec.attribute4;
374: ELSE
375: l_attribute4 := p_attribute4;

Line 377: IF(p_attribute5 = FND_API.G_MISS_CHAR)

373: l_attribute4 := table_attribute_rec.attribute4;
374: ELSE
375: l_attribute4 := p_attribute4;
376: END IF;
377: IF(p_attribute5 = FND_API.G_MISS_CHAR)
378: THEN
379: l_attribute5 := table_attribute_rec.attribute5;
380: ELSE
381: l_attribute5 := p_attribute5;

Line 383: IF(p_attribute6 = FND_API.G_MISS_CHAR)

379: l_attribute5 := table_attribute_rec.attribute5;
380: ELSE
381: l_attribute5 := p_attribute5;
382: END IF;
383: IF(p_attribute6 = FND_API.G_MISS_CHAR)
384: THEN
385: l_attribute6 := table_attribute_rec.attribute6;
386: ELSE
387: l_attribute6 := p_attribute6;

Line 389: IF(p_attribute7 = FND_API.G_MISS_CHAR)

385: l_attribute6 := table_attribute_rec.attribute6;
386: ELSE
387: l_attribute6 := p_attribute6;
388: END IF;
389: IF(p_attribute7 = FND_API.G_MISS_CHAR)
390: THEN
391: l_attribute7 := table_attribute_rec.attribute7;
392: ELSE
393: l_attribute7 := p_attribute7;

Line 395: IF(p_attribute8 = FND_API.G_MISS_CHAR)

391: l_attribute7 := table_attribute_rec.attribute7;
392: ELSE
393: l_attribute7 := p_attribute7;
394: END IF;
395: IF(p_attribute8 = FND_API.G_MISS_CHAR)
396: THEN
397: l_attribute8 := table_attribute_rec.attribute8;
398: ELSE
399: l_attribute8 := p_attribute8;

Line 401: IF(p_attribute9 = FND_API.G_MISS_CHAR)

397: l_attribute8 := table_attribute_rec.attribute8;
398: ELSE
399: l_attribute8 := p_attribute8;
400: END IF;
401: IF(p_attribute9 = FND_API.G_MISS_CHAR)
402: THEN
403: l_attribute9 := table_attribute_rec.attribute9;
404: ELSE
405: l_attribute9 := p_attribute9;

Line 407: IF(p_attribute10 = FND_API.G_MISS_CHAR)

403: l_attribute9 := table_attribute_rec.attribute9;
404: ELSE
405: l_attribute9 := p_attribute9;
406: END IF;
407: IF(p_attribute10 = FND_API.G_MISS_CHAR)
408: THEN
409: l_attribute10 := table_attribute_rec.attribute10;
410: ELSE
411: l_attribute10 := p_attribute10;

Line 413: IF(p_attribute11 = FND_API.G_MISS_CHAR)

409: l_attribute10 := table_attribute_rec.attribute10;
410: ELSE
411: l_attribute10 := p_attribute10;
412: END IF;
413: IF(p_attribute11 = FND_API.G_MISS_CHAR)
414: THEN
415: l_attribute11 := table_attribute_rec.attribute11;
416: ELSE
417: l_attribute11 := p_attribute11;

Line 419: IF(p_attribute12 = FND_API.G_MISS_CHAR)

415: l_attribute11 := table_attribute_rec.attribute11;
416: ELSE
417: l_attribute11 := p_attribute11;
418: END IF;
419: IF(p_attribute12 = FND_API.G_MISS_CHAR)
420: THEN
421: l_attribute12 := table_attribute_rec.attribute12;
422: ELSE
423: l_attribute12 := p_attribute12;

Line 425: IF(p_attribute13 = FND_API.G_MISS_CHAR)

421: l_attribute12 := table_attribute_rec.attribute12;
422: ELSE
423: l_attribute12 := p_attribute12;
424: END IF;
425: IF(p_attribute13 = FND_API.G_MISS_CHAR)
426: THEN
427: l_attribute13 := table_attribute_rec.attribute13;
428: ELSE
429: l_attribute13 := p_attribute13;

Line 431: IF(p_attribute14 = FND_API.G_MISS_CHAR)

427: l_attribute13 := table_attribute_rec.attribute13;
428: ELSE
429: l_attribute13 := p_attribute13;
430: END IF;
431: IF(p_attribute14 = FND_API.G_MISS_CHAR)
432: THEN
433: l_attribute14 := table_attribute_rec.attribute14;
434: ELSE
435: l_attribute14 := p_attribute14;

Line 437: IF(p_attribute15 = FND_API.G_MISS_CHAR)

433: l_attribute14 := table_attribute_rec.attribute14;
434: ELSE
435: l_attribute14 := p_attribute14;
436: END IF;
437: IF(p_attribute15 = FND_API.G_MISS_CHAR)
438: THEN
439: l_attribute15 := table_attribute_rec.attribute15;
440: ELSE
441: l_attribute15 := p_attribute15;

Line 443: IF(p_attribute_category = FND_API.G_MISS_CHAR)

439: l_attribute15 := table_attribute_rec.attribute15;
440: ELSE
441: l_attribute15 := p_attribute15;
442: END IF;
443: IF(p_attribute_category = FND_API.G_MISS_CHAR)
444: THEN
445: l_attribute_category := table_attribute_rec.attribute_category;
446: ELSE
447: l_attribute_category := p_attribute_category;

Line 460: x_return_status := fnd_api.g_ret_sts_error;

456:
457: EXCEPTION
458:
459: WHEN OTHERS THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464:

Line 463: RAISE fnd_api.g_exc_error;

459: WHEN OTHERS THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464:
465: END;
466:
467:

Line 498: x_return_status := fnd_api.g_ret_sts_error;

494:
495: P_OBJECT_VERSION_NUM := l_object_version_number;
496:
497: ELSIF (table_attribute_cur%notfound) THEN
498: x_return_status := fnd_api.g_ret_sts_error;
499: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');
500: FND_MSG_PUB.add;
501: RAISE fnd_api.g_exc_error;
502:

Line 501: RAISE fnd_api.g_exc_error;

497: ELSIF (table_attribute_cur%notfound) THEN
498: x_return_status := fnd_api.g_ret_sts_error;
499: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');
500: FND_MSG_PUB.add;
501: RAISE fnd_api.g_exc_error;
502:
503: END IF;
504:
505: CLOSE table_attribute_cur;

Line 507: IF fnd_api.to_boolean (p_commit)

503: END IF;
504:
505: CLOSE table_attribute_cur;
506:
507: IF fnd_api.to_boolean (p_commit)
508: THEN
509: COMMIT WORK;
510: END IF;
511:

Line 515: WHEN fnd_api.g_exc_error

511:
512: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
513:
514: EXCEPTION
515: WHEN fnd_api.g_exc_error
516: THEN
517: ROLLBACK TO TABLE_ATTRIBUTE_SP;
518: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
519:

Line 520: WHEN fnd_api.g_exc_unexpected_error

516: THEN
517: ROLLBACK TO TABLE_ATTRIBUTE_SP;
518: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
519:
520: WHEN fnd_api.g_exc_unexpected_error
521: THEN
522: ROLLBACK TO TABLE_ATTRIBUTE_SP;
523: x_return_status := fnd_api.g_ret_sts_unexp_error;
524: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 523: x_return_status := fnd_api.g_ret_sts_unexp_error;

519:
520: WHEN fnd_api.g_exc_unexpected_error
521: THEN
522: ROLLBACK TO TABLE_ATTRIBUTE_SP;
523: x_return_status := fnd_api.g_ret_sts_unexp_error;
524: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
525: WHEN OTHERS
526: THEN
527: ROLLBACK TO TABLE_ATTRIBUTE_SP;

Line 533: x_return_status := fnd_api.g_ret_sts_unexp_error;

529: fnd_message.set_token('P_SQLCODE',SQLCODE);
530: fnd_message.set_token('P_SQLERRM',SQLERRM);
531: fnd_message.set_token('P_API_NAME',l_api_name);
532: FND_MSG_PUB.add;
533: x_return_status := fnd_api.g_ret_sts_unexp_error;
534: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
535: END update_table_attribute;
536:
537:

Line 583: x_return_status := fnd_api.g_ret_sts_success;

579: BEGIN
580: --Standard Start of API SAVEPOINT
581: SAVEPOINT TABLE_ATTRIBUTE_SP;
582:
583: x_return_status := fnd_api.g_ret_sts_success;
584:
585: --Standard Call to check API compatibility
586: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
587: THEN

Line 586: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

582:
583: x_return_status := fnd_api.g_ret_sts_success;
584:
585: --Standard Call to check API compatibility
586: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
587: THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584:
585: --Standard Call to check API compatibility
586: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
587: THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
592: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 592: IF FND_API.To_boolean(P_INIT_MSG_LIST)

588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
592: IF FND_API.To_boolean(P_INIT_MSG_LIST)
593: THEN
594: FND_MSG_PUB.Initialize;
595: END IF;
596:

Line 606: x_return_status := fnd_api.g_ret_sts_error;

602: JTF_RS_TABLE_ATTRIBUTES_PKG.DELETE_ROW(
603: X_ATTRIBUTE_ID => l_attribute_id);
604:
605: ELSIF (chk_att_exist_cur%notfound) THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');
608: FND_MSG_PUB.add;
609: RAISE fnd_api.g_exc_error;
610:

Line 609: RAISE fnd_api.g_exc_error;

605: ELSIF (chk_att_exist_cur%notfound) THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');
608: FND_MSG_PUB.add;
609: RAISE fnd_api.g_exc_error;
610:
611: END IF;
612:
613: CLOSE chk_att_exist_cur;

Line 615: IF fnd_api.to_boolean (p_commit)

611: END IF;
612:
613: CLOSE chk_att_exist_cur;
614:
615: IF fnd_api.to_boolean (p_commit)
616: THEN
617: COMMIT WORK;
618: END IF;
619:

Line 623: WHEN fnd_api.g_exc_unexpected_error

619:
620: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
621:
622: EXCEPTION
623: WHEN fnd_api.g_exc_unexpected_error
624: THEN
625: ROLLBACK TO TABLE_ATTRIBUTE_SP;
626: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
627: WHEN fnd_api.g_exc_error

Line 627: WHEN fnd_api.g_exc_error

623: WHEN fnd_api.g_exc_unexpected_error
624: THEN
625: ROLLBACK TO TABLE_ATTRIBUTE_SP;
626: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
627: WHEN fnd_api.g_exc_error
628: THEN
629: ROLLBACK TO TABLE_ATTRIBUTE_SP;
630: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
631: WHEN OTHERS

Line 639: x_return_status := fnd_api.g_ret_sts_unexp_error;

635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME',l_api_name);
638: FND_MSG_PUB.add;
639: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
641:
642: END delete_table_attribute;
643: