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

Line 136: RAISE FND_API.G_EXC_ERROR;

132: x_uoo_id => new_references.uoo_id )
133: THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: FND_MSG_PUB.ADD;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138: END IF;
139: IF new_references.UNIT_SECTION_OCCURRENCE_ID IS NOT NULL THEN
140: IF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation(x_unit_section_occurrence_id =>

Line 145: RAISE FND_API.G_EXC_ERROR;

141: new_references.UNIT_SECTION_OCCURRENCE_ID)
142: THEN
143: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148: END IF;
149:

Line 325: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

321: x_last_update_login
322: ) RETURNING ROWID INTO x_rowid;
323:
324: -- Initialize API return status to success.
325: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
326: -- Standard call to get message count and if count is 1, get message
327: -- info.
328: FND_MSG_PUB.Count_And_Get(
329: p_encoded => FND_API.G_FALSE,

Line 329: p_encoded => FND_API.G_FALSE,

325: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
326: -- Standard call to get message count and if count is 1, get message
327: -- info.
328: FND_MSG_PUB.Count_And_Get(
329: p_encoded => FND_API.G_FALSE,
330: p_count => x_MSG_COUNT,
331: p_data => X_MSG_DATA);
332:
333: EXCEPTION

Line 334: WHEN FND_API.G_EXC_ERROR THEN

330: p_count => x_MSG_COUNT,
331: p_data => X_MSG_DATA);
332:
333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get(
337: p_encoded => FND_API.G_FALSE,
338: p_count => x_MSG_COUNT,

Line 335: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

331: p_data => X_MSG_DATA);
332:
333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get(
337: p_encoded => FND_API.G_FALSE,
338: p_count => x_MSG_COUNT,
339: p_data => X_MSG_DATA);

Line 337: p_encoded => FND_API.G_FALSE,

333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get(
337: p_encoded => FND_API.G_FALSE,
338: p_count => x_MSG_COUNT,
339: p_data => X_MSG_DATA);
340: RETURN;
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

337: p_encoded => FND_API.G_FALSE,
338: p_count => x_MSG_COUNT,
339: p_data => X_MSG_DATA);
340: RETURN;
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get(
344: p_encoded => FND_API.G_FALSE,
345: p_count => x_MSG_COUNT,

Line 342: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

338: p_count => x_MSG_COUNT,
339: p_data => X_MSG_DATA);
340: RETURN;
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get(
344: p_encoded => FND_API.G_FALSE,
345: p_count => x_MSG_COUNT,
346: p_data => X_MSG_DATA);

Line 344: p_encoded => FND_API.G_FALSE,

340: RETURN;
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get(
344: p_encoded => FND_API.G_FALSE,
345: p_count => x_MSG_COUNT,
346: p_data => X_MSG_DATA);
347: RETURN;
348: WHEN OTHERS THEN

Line 349: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

345: p_count => x_MSG_COUNT,
346: p_data => X_MSG_DATA);
347: RETURN;
348: WHEN OTHERS THEN
349: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
351: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
352: FND_MSG_PUB.ADD;
353: FND_MSG_PUB.Count_And_Get(

Line 354: p_encoded => FND_API.G_FALSE,

350: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
351: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
352: FND_MSG_PUB.ADD;
353: FND_MSG_PUB.Count_And_Get(
354: p_encoded => FND_API.G_FALSE,
355: p_count => x_MSG_COUNT,
356: p_data => X_MSG_DATA);
357: RETURN;
358:

Line 427: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

Line 431: p_encoded => FND_API.G_FALSE,

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

Line 436: WHEN FND_API.G_EXC_ERROR THEN

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

Line 437: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 439: p_encoded => FND_API.G_FALSE,

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

Line 443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 444: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 446: p_encoded => FND_API.G_FALSE,

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

Line 451: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 456: p_encoded => FND_API.G_FALSE,

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

Line 548: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

544: RAISE NO_DATA_FOUND;
545: END IF;
546:
547: -- Initialize API return status to success.
548: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
549: -- Standard call to get message count and if count is 1, get message
550: -- info.
551: FND_MSG_PUB.Count_And_Get(
552: p_encoded => FND_API.G_FALSE,

Line 552: p_encoded => FND_API.G_FALSE,

548: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
549: -- Standard call to get message count and if count is 1, get message
550: -- info.
551: FND_MSG_PUB.Count_And_Get(
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_MSG_COUNT,
554: p_data => X_MSG_DATA);
555:
556: EXCEPTION

Line 557: WHEN FND_API.G_EXC_ERROR THEN

553: p_count => x_MSG_COUNT,
554: p_data => X_MSG_DATA);
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
559: FND_MSG_PUB.Count_And_Get(
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_MSG_COUNT,

Line 558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

554: p_data => X_MSG_DATA);
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
559: FND_MSG_PUB.Count_And_Get(
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_MSG_COUNT,
562: p_data => X_MSG_DATA);

Line 560: p_encoded => FND_API.G_FALSE,

556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
559: FND_MSG_PUB.Count_And_Get(
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_MSG_COUNT,
562: p_data => X_MSG_DATA);
563: RETURN;
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

560: p_encoded => FND_API.G_FALSE,
561: p_count => x_MSG_COUNT,
562: p_data => X_MSG_DATA);
563: RETURN;
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
566: FND_MSG_PUB.Count_And_Get(
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_MSG_COUNT,

Line 565: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

561: p_count => x_MSG_COUNT,
562: p_data => X_MSG_DATA);
563: RETURN;
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
566: FND_MSG_PUB.Count_And_Get(
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_MSG_COUNT,
569: p_data => X_MSG_DATA);

Line 567: p_encoded => FND_API.G_FALSE,

563: RETURN;
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
566: FND_MSG_PUB.Count_And_Get(
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_MSG_COUNT,
569: p_data => X_MSG_DATA);
570: RETURN;
571: WHEN OTHERS THEN

Line 572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

568: p_count => x_MSG_COUNT,
569: p_data => X_MSG_DATA);
570: RETURN;
571: WHEN OTHERS THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
574: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
575: FND_MSG_PUB.ADD;
576: FND_MSG_PUB.Count_And_Get(

Line 577: p_encoded => FND_API.G_FALSE,

573: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
574: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
575: FND_MSG_PUB.ADD;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_MSG_COUNT,
579: p_data => X_MSG_DATA);
580: RETURN;
581:

Line 660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

656: x_msg_count
657: );
658:
659: -- Initialize API return status to success.
660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
661: -- Standard call to get message count and if count is 1, get message
662: -- info.
663: FND_MSG_PUB.Count_And_Get(
664: p_encoded => FND_API.G_FALSE,

Line 664: p_encoded => FND_API.G_FALSE,

660: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
661: -- Standard call to get message count and if count is 1, get message
662: -- info.
663: FND_MSG_PUB.Count_And_Get(
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_MSG_COUNT,
666: p_data => X_MSG_DATA);
667:
668: EXCEPTION

Line 669: WHEN FND_API.G_EXC_ERROR THEN

665: p_count => x_MSG_COUNT,
666: p_data => X_MSG_DATA);
667:
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
671: FND_MSG_PUB.Count_And_Get(
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_MSG_COUNT,

Line 670: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

666: p_data => X_MSG_DATA);
667:
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
671: FND_MSG_PUB.Count_And_Get(
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_MSG_COUNT,
674: p_data => X_MSG_DATA);

Line 672: p_encoded => FND_API.G_FALSE,

668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
671: FND_MSG_PUB.Count_And_Get(
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_MSG_COUNT,
674: p_data => X_MSG_DATA);
675: RETURN;
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

672: p_encoded => FND_API.G_FALSE,
673: p_count => x_MSG_COUNT,
674: p_data => X_MSG_DATA);
675: RETURN;
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
678: FND_MSG_PUB.Count_And_Get(
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_MSG_COUNT,

Line 677: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

673: p_count => x_MSG_COUNT,
674: p_data => X_MSG_DATA);
675: RETURN;
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
678: FND_MSG_PUB.Count_And_Get(
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_MSG_COUNT,
681: p_data => X_MSG_DATA);

Line 679: p_encoded => FND_API.G_FALSE,

675: RETURN;
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
678: FND_MSG_PUB.Count_And_Get(
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_MSG_COUNT,
681: p_data => X_MSG_DATA);
682: RETURN;
683: WHEN OTHERS THEN

Line 684: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

680: p_count => x_MSG_COUNT,
681: p_data => X_MSG_DATA);
682: RETURN;
683: WHEN OTHERS THEN
684: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
685: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
686: FND_MESSAGE.SET_TOKEN('NAME','Add_Row : '||SQLERRM);
687: FND_MSG_PUB.ADD;
688: FND_MSG_PUB.Count_And_Get(

Line 689: p_encoded => FND_API.G_FALSE,

685: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
686: FND_MESSAGE.SET_TOKEN('NAME','Add_Row : '||SQLERRM);
687: FND_MSG_PUB.ADD;
688: FND_MSG_PUB.Count_And_Get(
689: p_encoded => FND_API.G_FALSE,
690: p_count => x_MSG_COUNT,
691: p_data => X_MSG_DATA);
692: RETURN;
693:

Line 746: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

742: X_MSG_COUNT => X_MSG_COUNT
743: );
744: END LOOP;
745:
746: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
747: RAISE FND_API.G_EXC_ERROR ;
748: END IF;
749:
750: DELETE FROM igs_as_usec_sessns

Line 747: RAISE FND_API.G_EXC_ERROR ;

743: );
744: END LOOP;
745:
746: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
747: RAISE FND_API.G_EXC_ERROR ;
748: END IF;
749:
750: DELETE FROM igs_as_usec_sessns
751: WHERE rowid = x_rowid;

Line 758: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

754: RAISE NO_DATA_FOUND;
755: END IF;
756:
757: -- Initialize API return status to success.
758: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
759:
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN

Line 762: WHEN FND_API.G_EXC_ERROR THEN

758: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
759:
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_MSG_COUNT,

Line 763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

759:
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_MSG_COUNT,
767: p_data => X_MSG_DATA);

Line 765: p_encoded => FND_API.G_FALSE,

761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_MSG_COUNT,
767: p_data => X_MSG_DATA);
768: RETURN;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

765: p_encoded => FND_API.G_FALSE,
766: p_count => x_MSG_COUNT,
767: p_data => X_MSG_DATA);
768: RETURN;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
771: FND_MSG_PUB.Count_And_Get(
772: p_encoded => FND_API.G_FALSE,
773: p_count => x_MSG_COUNT,

Line 770: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

766: p_count => x_MSG_COUNT,
767: p_data => X_MSG_DATA);
768: RETURN;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
771: FND_MSG_PUB.Count_And_Get(
772: p_encoded => FND_API.G_FALSE,
773: p_count => x_MSG_COUNT,
774: p_data => X_MSG_DATA);

Line 772: p_encoded => FND_API.G_FALSE,

768: RETURN;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
771: FND_MSG_PUB.Count_And_Get(
772: p_encoded => FND_API.G_FALSE,
773: p_count => x_MSG_COUNT,
774: p_data => X_MSG_DATA);
775: RETURN;
776: WHEN OTHERS THEN

Line 777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

773: p_count => x_MSG_COUNT,
774: p_data => X_MSG_DATA);
775: RETURN;
776: WHEN OTHERS THEN
777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
779: FND_MESSAGE.SET_TOKEN('NAME','delete_Row : '||SQLERRM);
780: FND_MSG_PUB.ADD;
781: FND_MSG_PUB.Count_And_Get(

Line 782: p_encoded => FND_API.G_FALSE,

778: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
779: FND_MESSAGE.SET_TOKEN('NAME','delete_Row : '||SQLERRM);
780: FND_MSG_PUB.ADD;
781: FND_MSG_PUB.Count_And_Get(
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_MSG_COUNT,
784: p_data => X_MSG_DATA);
785: RETURN;
786: END delete_row;