DBA Data[Home] [Help]

APPS.IGS_DA_RQST_PKG dependencies on FND_MSG_PUB

Line 475: FND_MSG_PUB.initialize;

471: x_last_updated_by NUMBER;
472: x_last_update_login NUMBER;
473:
474: BEGIN
475: FND_MSG_PUB.initialize;
476: x_last_update_date := SYSDATE;
477: IF (x_mode = 'I') THEN
478: x_last_updated_by := 1;
479: x_last_update_login := 0;

Line 620: FND_MSG_PUB.Count_And_Get(

616: -- Initialize API return status to success.
617: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
618: -- Standard call to get message count and if count is 1, get message
619: -- info.
620: FND_MSG_PUB.Count_And_Get(
621: p_encoded => FND_API.G_FALSE,
622: p_count => x_MSG_COUNT,
623: p_data => X_MSG_DATA);
624:

Line 628: FND_MSG_PUB.Count_And_Get(

624:
625: EXCEPTION
626: WHEN FND_API.G_EXC_ERROR THEN
627: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
628: FND_MSG_PUB.Count_And_Get(
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_MSG_COUNT,
631: p_data => X_MSG_DATA);
632: RETURN;

Line 635: FND_MSG_PUB.Count_And_Get(

631: p_data => X_MSG_DATA);
632: RETURN;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.Count_And_Get(
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_MSG_COUNT,
638: p_data => X_MSG_DATA);
639: RETURN;

Line 644: FND_MSG_PUB.ADD;

640: WHEN OTHERS THEN
641: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
643: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get(
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_MSG_COUNT,
648: p_data => X_MSG_DATA);

Line 645: FND_MSG_PUB.Count_And_Get(

641: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
643: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get(
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_MSG_COUNT,
648: p_data => X_MSG_DATA);
649: RETURN;

Line 742: FND_MSG_PUB.initialize;

738:
739: tlinfo c1%ROWTYPE;
740:
741: BEGIN
742: FND_MSG_PUB.initialize;
743: OPEN c1;
744: FETCH c1 INTO tlinfo;
745: IF (c1%notfound) THEN
746: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line 798: FND_MSG_PUB.Count_And_Get(

794: -- Initialize API return status to success.
795: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
796: -- Standard call to get message count and if count is 1, get message
797: -- info.
798: FND_MSG_PUB.Count_And_Get(
799: p_encoded => FND_API.G_FALSE,
800: p_count => x_MSG_COUNT,
801: p_data => X_MSG_DATA);
802: RETURN;

Line 806: FND_MSG_PUB.Count_And_Get(

802: RETURN;
803: EXCEPTION
804: WHEN FND_API.G_EXC_ERROR THEN
805: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
806: FND_MSG_PUB.Count_And_Get(
807: p_encoded => FND_API.G_FALSE,
808: p_count => x_MSG_COUNT,
809: p_data => X_MSG_DATA);
810: RETURN;

Line 813: FND_MSG_PUB.Count_And_Get(

809: p_data => X_MSG_DATA);
810: RETURN;
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
813: FND_MSG_PUB.Count_And_Get(
814: p_encoded => FND_API.G_FALSE,
815: p_count => x_MSG_COUNT,
816: p_data => X_MSG_DATA);
817: RETURN;

Line 822: FND_MSG_PUB.ADD;

818: WHEN OTHERS THEN
819: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
820: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
821: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.Count_And_Get(
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_MSG_COUNT,
826: p_data => X_MSG_DATA);

Line 823: FND_MSG_PUB.Count_And_Get(

819: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
820: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
821: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.Count_And_Get(
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_MSG_COUNT,
826: p_data => X_MSG_DATA);
827: RETURN;

Line 885: FND_MSG_PUB.initialize;

881: x_last_updated_by NUMBER;
882: x_last_update_login NUMBER;
883:
884: BEGIN
885: FND_MSG_PUB.initialize;
886: x_last_update_date := SYSDATE;
887: IF (X_MODE = 'I') THEN
888: x_last_updated_by := 1;
889: x_last_update_login := 0;

Line 996: FND_MSG_PUB.Count_And_Get(

992: -- Initialize API return status to success.
993: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
994: -- Standard call to get message count and if count is 1, get message
995: -- info.
996: FND_MSG_PUB.Count_And_Get(
997: p_encoded => FND_API.G_FALSE,
998: p_count => x_MSG_COUNT,
999: p_data => X_MSG_DATA);
1000:

Line 1004: FND_MSG_PUB.Count_And_Get(

1000:
1001: EXCEPTION
1002: WHEN FND_API.G_EXC_ERROR THEN
1003: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1004: FND_MSG_PUB.Count_And_Get(
1005: p_encoded => FND_API.G_FALSE,
1006: p_count => x_MSG_COUNT,
1007: p_data => X_MSG_DATA);
1008: RETURN;

Line 1011: FND_MSG_PUB.Count_And_Get(

1007: p_data => X_MSG_DATA);
1008: RETURN;
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_And_Get(
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_MSG_COUNT,
1014: p_data => X_MSG_DATA);
1015: RETURN;

Line 1020: FND_MSG_PUB.ADD;

1016: WHEN OTHERS THEN
1017: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1019: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_And_Get(
1022: p_encoded => FND_API.G_FALSE,
1023: p_count => x_MSG_COUNT,
1024: p_data => X_MSG_DATA);

Line 1021: FND_MSG_PUB.Count_And_Get(

1017: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1019: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_And_Get(
1022: p_encoded => FND_API.G_FALSE,
1023: p_count => x_MSG_COUNT,
1024: p_data => X_MSG_DATA);
1025: RETURN;

Line 1191: FND_MSG_PUB.initialize;

1187: || Who When What
1188: || (reverse chronological order - newest change first)
1189: */
1190: BEGIN
1191: FND_MSG_PUB.initialize;
1192: before_dml (
1193: p_action => 'DELETE',
1194: x_rowid => x_rowid
1195: );

Line 1208: FND_MSG_PUB.Count_And_Get(

1204: -- Initialize API return status to success.
1205: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1206: -- Standard call to get message count and if count is 1, get message
1207: -- info.
1208: FND_MSG_PUB.Count_And_Get(
1209: p_encoded => FND_API.G_FALSE,
1210: p_count => x_MSG_COUNT,
1211: p_data => X_MSG_DATA);
1212:

Line 1216: FND_MSG_PUB.Count_And_Get(

1212:
1213: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1216: FND_MSG_PUB.Count_And_Get(
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_MSG_COUNT,
1219: p_data => X_MSG_DATA);
1220: RETURN;

Line 1223: FND_MSG_PUB.Count_And_Get(

1219: p_data => X_MSG_DATA);
1220: RETURN;
1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1223: FND_MSG_PUB.Count_And_Get(
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_MSG_COUNT,
1226: p_data => X_MSG_DATA);
1227: RETURN;

Line 1232: FND_MSG_PUB.ADD;

1228: WHEN OTHERS THEN
1229: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1230: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1231: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1232: FND_MSG_PUB.ADD;
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_MSG_COUNT,
1236: p_data => X_MSG_DATA);

Line 1233: FND_MSG_PUB.Count_And_Get(

1229: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1230: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1231: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1232: FND_MSG_PUB.ADD;
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_MSG_COUNT,
1236: p_data => X_MSG_DATA);
1237: RETURN;