DBA Data[Home] [Help]

APPS.IGS_DA_REQ_WIF_PKG dependencies on FND_MSG_PUB

Line 435: FND_MSG_PUB.initialize;

431: x_last_updated_by NUMBER;
432: x_last_update_login NUMBER;
433:
434: BEGIN
435: FND_MSG_PUB.initialize;
436: x_last_update_date := SYSDATE;
437: IF (x_mode = 'I') THEN
438: x_last_updated_by := 1;
439: x_last_update_login := 0;

Line 523: FND_MSG_PUB.Count_And_Get(

519: -- Initialize API return status to success.
520: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
521: -- Standard call to get message count and if count is 1, get message
522: -- info.
523: FND_MSG_PUB.Count_And_Get(
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_MSG_COUNT,
526: p_data => X_MSG_DATA);
527:

Line 531: FND_MSG_PUB.Count_And_Get(

527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get(
532: p_encoded => FND_API.G_FALSE,
533: p_count => x_MSG_COUNT,
534: p_data => X_MSG_DATA);
535: RETURN;

Line 538: FND_MSG_PUB.Count_And_Get(

534: p_data => X_MSG_DATA);
535: RETURN;
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
538: FND_MSG_PUB.Count_And_Get(
539: p_encoded => FND_API.G_FALSE,
540: p_count => x_MSG_COUNT,
541: p_data => X_MSG_DATA);
542: RETURN;

Line 547: FND_MSG_PUB.ADD;

543: WHEN OTHERS THEN
544: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
546: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_MSG_COUNT,
551: p_data => X_MSG_DATA);

Line 548: FND_MSG_PUB.Count_And_Get(

544: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
546: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_MSG_COUNT,
551: p_data => X_MSG_DATA);
552: RETURN;

Line 607: FND_MSG_PUB.initialize;

603:
604: tlinfo c1%ROWTYPE;
605:
606: BEGIN
607: FND_MSG_PUB.initialize;
608: OPEN c1;
609: FETCH c1 INTO tlinfo;
610: IF (c1%notfound) THEN
611: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line 644: FND_MSG_PUB.Count_And_Get(

640: -- Initialize API return status to success.
641: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
642: -- Standard call to get message count and if count is 1, get message
643: -- info.
644: FND_MSG_PUB.Count_And_Get(
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_MSG_COUNT,
647: p_data => X_MSG_DATA);
648: RETURN;

Line 652: FND_MSG_PUB.Count_And_Get(

648: RETURN;
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
652: FND_MSG_PUB.Count_And_Get(
653: p_encoded => FND_API.G_FALSE,
654: p_count => x_MSG_COUNT,
655: p_data => X_MSG_DATA);
656: RETURN;

Line 659: FND_MSG_PUB.Count_And_Get(

655: p_data => X_MSG_DATA);
656: RETURN;
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.Count_And_Get(
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_MSG_COUNT,
662: p_data => X_MSG_DATA);
663: RETURN;

Line 668: FND_MSG_PUB.ADD;

664: WHEN OTHERS THEN
665: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
666: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
667: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_MSG_COUNT,
672: p_data => X_MSG_DATA);

Line 669: FND_MSG_PUB.Count_And_Get(

665: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
666: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
667: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_MSG_COUNT,
672: p_data => X_MSG_DATA);
673: RETURN;

Line 714: FND_MSG_PUB.initialize;

710: x_last_updated_by NUMBER;
711: x_last_update_login NUMBER;
712:
713: BEGIN
714: FND_MSG_PUB.initialize;
715: x_last_update_date := SYSDATE;
716: IF (X_MODE = 'I') THEN
717: x_last_updated_by := 1;
718: x_last_update_login := 0;

Line 785: FND_MSG_PUB.Count_And_Get(

781: -- Initialize API return status to success.
782: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
783: -- Standard call to get message count and if count is 1, get message
784: -- info.
785: FND_MSG_PUB.Count_And_Get(
786: p_encoded => FND_API.G_FALSE,
787: p_count => x_MSG_COUNT,
788: p_data => X_MSG_DATA);
789:

Line 793: FND_MSG_PUB.Count_And_Get(

789:
790: EXCEPTION
791: WHEN FND_API.G_EXC_ERROR THEN
792: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
793: FND_MSG_PUB.Count_And_Get(
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_MSG_COUNT,
796: p_data => X_MSG_DATA);
797: RETURN;

Line 800: FND_MSG_PUB.Count_And_Get(

796: p_data => X_MSG_DATA);
797: RETURN;
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.Count_And_Get(
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_MSG_COUNT,
803: p_data => X_MSG_DATA);
804: RETURN;

Line 809: FND_MSG_PUB.ADD;

805: WHEN OTHERS THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
808: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.Count_And_Get(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_MSG_COUNT,
813: p_data => X_MSG_DATA);

Line 810: FND_MSG_PUB.Count_And_Get(

806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
808: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.Count_And_Get(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_MSG_COUNT,
813: p_data => X_MSG_DATA);
814: RETURN;

Line 927: FND_MSG_PUB.initialize;

923: || Who When What
924: || (reverse chronological order - newest change first)
925: */
926: BEGIN
927: FND_MSG_PUB.initialize;
928: before_dml (
929: p_action => 'DELETE',
930: x_rowid => x_rowid
931: );

Line 943: FND_MSG_PUB.Count_And_Get(

939: -- Initialize API return status to success.
940: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
941: -- Standard call to get message count and if count is 1, get message
942: -- info.
943: FND_MSG_PUB.Count_And_Get(
944: p_encoded => FND_API.G_FALSE,
945: p_count => x_MSG_COUNT,
946: p_data => X_MSG_DATA);
947:

Line 951: FND_MSG_PUB.Count_And_Get(

947:
948: EXCEPTION
949: WHEN FND_API.G_EXC_ERROR THEN
950: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
951: FND_MSG_PUB.Count_And_Get(
952: p_encoded => FND_API.G_FALSE,
953: p_count => x_MSG_COUNT,
954: p_data => X_MSG_DATA);
955: RETURN;

Line 958: FND_MSG_PUB.Count_And_Get(

954: p_data => X_MSG_DATA);
955: RETURN;
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_MSG_COUNT,
961: p_data => X_MSG_DATA);
962: RETURN;

Line 967: FND_MSG_PUB.ADD;

963: WHEN OTHERS THEN
964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
966: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
967: FND_MSG_PUB.ADD;
968: FND_MSG_PUB.Count_And_Get(
969: p_encoded => FND_API.G_FALSE,
970: p_count => x_MSG_COUNT,
971: p_data => X_MSG_DATA);

Line 968: FND_MSG_PUB.Count_And_Get(

964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
966: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
967: FND_MSG_PUB.ADD;
968: FND_MSG_PUB.Count_And_Get(
969: p_encoded => FND_API.G_FALSE,
970: p_count => x_MSG_COUNT,
971: p_data => X_MSG_DATA);
972: RETURN;