DBA Data[Home] [Help]

APPS.IGS_AS_DOC_FEE_PMNT_PKG dependencies on FND_API

Line 163: RAISE FND_API.G_EXC_ERROR;

159: )
160: ) THEN
161: fnd_message.set_name('IGS','IGS_AS_PLAN_EXISTS_CAL');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165: END IF;
166: END IF;
167: END before_dml;

Line 301: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

297: END IF;
298: CLOSE c;
299:
300: -- Initialize API return status to success.
301: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
302: -- Standard call to get message count and if count is 1, get message
303: -- info.
304: FND_MSG_PUB.Count_And_Get(
305: p_encoded => FND_API.G_FALSE,

Line 305: p_encoded => FND_API.G_FALSE,

301: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
302: -- Standard call to get message count and if count is 1, get message
303: -- info.
304: FND_MSG_PUB.Count_And_Get(
305: p_encoded => FND_API.G_FALSE,
306: p_count => x_MSG_COUNT,
307: p_data => X_MSG_DATA);
308:
309: EXCEPTION

Line 310: WHEN FND_API.G_EXC_ERROR THEN

306: p_count => x_MSG_COUNT,
307: p_data => X_MSG_DATA);
308:
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,

Line 311: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

307: p_data => X_MSG_DATA);
308:
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);

Line 313: p_encoded => FND_API.G_FALSE,

309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);
316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);
316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_MSG_COUNT,

Line 318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);
316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_MSG_COUNT,
322: p_data => X_MSG_DATA);

Line 320: p_encoded => FND_API.G_FALSE,

316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_MSG_COUNT,
322: p_data => X_MSG_DATA);
323: RETURN;
324: WHEN OTHERS THEN

Line 325: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

321: p_count => x_MSG_COUNT,
322: p_data => X_MSG_DATA);
323: RETURN;
324: WHEN OTHERS THEN
325: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
326: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
327: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.Count_And_Get(

Line 330: p_encoded => FND_API.G_FALSE,

326: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
327: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.Count_And_Get(
330: p_encoded => FND_API.G_FALSE,
331: p_count => x_MSG_COUNT,
332: p_data => X_MSG_DATA);
333: RETURN;
334:

Line 420: RAISE FND_API.G_EXC_ERROR;

416: NULL;
417: ELSE
418: fnd_message.set_name('FND', '*'||x_rowid||'*');
419: FND_MSG_PUB.ADD;
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422:
423:
424: -- Initialize API return status to success.

Line 425: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

421: END IF;
422:
423:
424: -- Initialize API return status to success.
425: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
426: -- Standard call to get message count and if count is 1, get message
427: -- info.
428: FND_MSG_PUB.Count_And_Get(
429: p_encoded => FND_API.G_FALSE,

Line 429: p_encoded => FND_API.G_FALSE,

425: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
426: -- Standard call to get message count and if count is 1, get message
427: -- info.
428: FND_MSG_PUB.Count_And_Get(
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_MSG_COUNT,
431: p_data => X_MSG_DATA);
432: RETURN;
433: EXCEPTION

Line 434: WHEN FND_API.G_EXC_ERROR THEN

430: p_count => x_MSG_COUNT,
431: p_data => X_MSG_DATA);
432: RETURN;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,

Line 435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

431: p_data => X_MSG_DATA);
432: RETURN;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);

Line 437: p_encoded => FND_API.G_FALSE,

433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);
440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);
440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get(
444: p_encoded => FND_API.G_FALSE,
445: p_count => x_MSG_COUNT,

Line 442: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);
440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get(
444: p_encoded => FND_API.G_FALSE,
445: p_count => x_MSG_COUNT,
446: p_data => X_MSG_DATA);

Line 444: p_encoded => FND_API.G_FALSE,

440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get(
444: p_encoded => FND_API.G_FALSE,
445: p_count => x_MSG_COUNT,
446: p_data => X_MSG_DATA);
447: RETURN;
448: WHEN OTHERS THEN

Line 449: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

445: p_count => x_MSG_COUNT,
446: p_data => X_MSG_DATA);
447: RETURN;
448: WHEN OTHERS THEN
449: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
451: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(

Line 454: p_encoded => FND_API.G_FALSE,

450: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
451: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_MSG_COUNT,
456: p_data => X_MSG_DATA);
457: RETURN;
458:

Line 577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

573: EXCEPTION
574: WHEN OTHERS THEN
575: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_TRNS_RECLC_ERR');
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END;
579:
580:
581: -- Initialize API return status to success.

Line 582: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

578: END;
579:
580:
581: -- Initialize API return status to success.
582: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
583: -- Standard call to get message count and if count is 1, get message
584: -- info.
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,

Line 586: p_encoded => FND_API.G_FALSE,

582: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
583: -- Standard call to get message count and if count is 1, get message
584: -- info.
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589:
590: EXCEPTION

Line 591: WHEN FND_API.G_EXC_ERROR THEN

587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,

Line 592: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

588: p_data => X_MSG_DATA);
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);

Line 594: p_encoded => FND_API.G_FALSE,

590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);
597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);
597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_MSG_COUNT,

Line 599: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);
597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_MSG_COUNT,
603: p_data => X_MSG_DATA);

Line 601: p_encoded => FND_API.G_FALSE,

597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_MSG_COUNT,
603: p_data => X_MSG_DATA);
604: RETURN;
605: WHEN OTHERS THEN

Line 606: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

602: p_count => x_MSG_COUNT,
603: p_data => X_MSG_DATA);
604: RETURN;
605: WHEN OTHERS THEN
606: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
607: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
608: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
609: FND_MSG_PUB.ADD;
610: FND_MSG_PUB.Count_And_Get(

Line 611: p_encoded => FND_API.G_FALSE,

607: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
608: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
609: FND_MSG_PUB.ADD;
610: FND_MSG_PUB.Count_And_Get(
611: p_encoded => FND_API.G_FALSE,
612: p_count => x_MSG_COUNT,
613: p_data => X_MSG_DATA);
614: RETURN;
615:

Line 733: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

729: IF (SQL%NOTFOUND) THEN
730: RAISE NO_DATA_FOUND;
731: END IF;
732: -- Initialize API return status to success.
733: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
734: -- Standard call to get message count and if count is 1, get message
735: -- info.
736: FND_MSG_PUB.Count_And_Get(
737: p_encoded => FND_API.G_FALSE,

Line 737: p_encoded => FND_API.G_FALSE,

733: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
734: -- Standard call to get message count and if count is 1, get message
735: -- info.
736: FND_MSG_PUB.Count_And_Get(
737: p_encoded => FND_API.G_FALSE,
738: p_count => x_MSG_COUNT,
739: p_data => X_MSG_DATA);
740:
741: EXCEPTION

Line 742: WHEN FND_API.G_EXC_ERROR THEN

738: p_count => x_MSG_COUNT,
739: p_data => X_MSG_DATA);
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,

Line 743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

739: p_data => X_MSG_DATA);
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);

Line 745: p_encoded => FND_API.G_FALSE,

741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_MSG_COUNT,

Line 750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_MSG_COUNT,
754: p_data => X_MSG_DATA);

Line 752: p_encoded => FND_API.G_FALSE,

748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_MSG_COUNT,
754: p_data => X_MSG_DATA);
755: RETURN;
756: WHEN OTHERS THEN

Line 757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

753: p_count => x_MSG_COUNT,
754: p_data => X_MSG_DATA);
755: RETURN;
756: WHEN OTHERS THEN
757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
758: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
759: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
760: FND_MSG_PUB.ADD;
761: FND_MSG_PUB.Count_And_Get(

Line 762: p_encoded => FND_API.G_FALSE,

758: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
759: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
760: FND_MSG_PUB.ADD;
761: FND_MSG_PUB.Count_And_Get(
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_MSG_COUNT,
764: p_data => X_MSG_DATA);
765: RETURN;
766: