DBA Data[Home] [Help]

APPS.IGS_AZ_GROUPS_PKG dependencies on FND_API

Line 777: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

773: x_last_updated_by,
774: x_last_update_login
775: ) RETURNING ROWID, group_name INTO x_rowid, x_group_name;
776: -- Initialize API return status to success.
777: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
778: -- Standard call to get message count and if count is 1, get message
779: -- info.
780: FND_MSG_PUB.Count_And_Get(
781: p_encoded => FND_API.G_FALSE,

Line 781: p_encoded => FND_API.G_FALSE,

777: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
778: -- Standard call to get message count and if count is 1, get message
779: -- info.
780: FND_MSG_PUB.Count_And_Get(
781: p_encoded => FND_API.G_FALSE,
782: p_count => x_MSG_COUNT,
783: p_data => X_MSG_DATA);
784:
785: EXCEPTION

Line 786: WHEN FND_API.G_EXC_ERROR THEN

782: p_count => x_MSG_COUNT,
783: p_data => X_MSG_DATA);
784:
785: EXCEPTION
786: WHEN FND_API.G_EXC_ERROR THEN
787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
788: FND_MSG_PUB.Count_And_Get(
789: p_encoded => FND_API.G_FALSE,
790: p_count => x_MSG_COUNT,

Line 787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

783: p_data => X_MSG_DATA);
784:
785: EXCEPTION
786: WHEN FND_API.G_EXC_ERROR THEN
787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
788: FND_MSG_PUB.Count_And_Get(
789: p_encoded => FND_API.G_FALSE,
790: p_count => x_MSG_COUNT,
791: p_data => X_MSG_DATA);

Line 789: p_encoded => FND_API.G_FALSE,

785: EXCEPTION
786: WHEN FND_API.G_EXC_ERROR THEN
787: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
788: FND_MSG_PUB.Count_And_Get(
789: p_encoded => FND_API.G_FALSE,
790: p_count => x_MSG_COUNT,
791: p_data => X_MSG_DATA);
792: RETURN;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 794: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 796: p_encoded => FND_API.G_FALSE,

792: RETURN;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
795: FND_MSG_PUB.Count_And_Get(
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_MSG_COUNT,
798: p_data => X_MSG_DATA);
799: RETURN;
800: WHEN OTHERS THEN

Line 801: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

797: p_count => x_MSG_COUNT,
798: p_data => X_MSG_DATA);
799: RETURN;
800: WHEN OTHERS THEN
801: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
802: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
803: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
804: FND_MSG_PUB.ADD;
805: FND_MSG_PUB.Count_And_Get(

Line 806: p_encoded => FND_API.G_FALSE,

802: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
803: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
804: FND_MSG_PUB.ADD;
805: FND_MSG_PUB.Count_And_Get(
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_MSG_COUNT,
808: p_data => X_MSG_DATA);
809: RETURN;
810:

Line 986: RAISE FND_API.G_EXC_ERROR;

982: NULL;
983: ELSE
984: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
985: igs_ge_msg_stack.add;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988:
989:
990: -- Initialize API return status to success.

Line 991: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

987: END IF;
988:
989:
990: -- Initialize API return status to success.
991: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
992: -- Standard call to get message count and if count is 1, get message
993: -- info.
994: FND_MSG_PUB.Count_And_Get(
995: p_encoded => FND_API.G_FALSE,

Line 995: p_encoded => FND_API.G_FALSE,

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

Line 1000: WHEN FND_API.G_EXC_ERROR THEN

996: p_count => x_MSG_COUNT,
997: p_data => X_MSG_DATA);
998: RETURN;
999: EXCEPTION
1000: WHEN FND_API.G_EXC_ERROR THEN
1001: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.Count_And_Get(
1003: p_encoded => FND_API.G_FALSE,
1004: p_count => x_MSG_COUNT,

Line 1001: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 1003: p_encoded => FND_API.G_FALSE,

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

Line 1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1003: p_encoded => FND_API.G_FALSE,
1004: p_count => x_MSG_COUNT,
1005: p_data => X_MSG_DATA);
1006: RETURN;
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1009: FND_MSG_PUB.Count_And_Get(
1010: p_encoded => FND_API.G_FALSE,
1011: p_count => x_MSG_COUNT,

Line 1008: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1010: p_encoded => FND_API.G_FALSE,

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

Line 1015: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1011: p_count => x_MSG_COUNT,
1012: p_data => X_MSG_DATA);
1013: RETURN;
1014: WHEN OTHERS THEN
1015: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1016: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1017: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1018: FND_MSG_PUB.ADD;
1019: FND_MSG_PUB.Count_And_Get(

Line 1020: p_encoded => FND_API.G_FALSE,

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

Line 1223: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1219: IF (SQL%NOTFOUND) THEN
1220: RAISE NO_DATA_FOUND;
1221: END IF;
1222: -- Initialize API return status to success.
1223: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1224: -- Standard call to get message count and if count is 1, get message
1225: -- info.
1226: FND_MSG_PUB.Count_And_Get(
1227: p_encoded => FND_API.G_FALSE,

Line 1227: p_encoded => FND_API.G_FALSE,

1223: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1224: -- Standard call to get message count and if count is 1, get message
1225: -- info.
1226: FND_MSG_PUB.Count_And_Get(
1227: p_encoded => FND_API.G_FALSE,
1228: p_count => x_MSG_COUNT,
1229: p_data => X_MSG_DATA);
1230:
1231: EXCEPTION

Line 1232: WHEN FND_API.G_EXC_ERROR THEN

1228: p_count => x_MSG_COUNT,
1229: p_data => X_MSG_DATA);
1230:
1231: EXCEPTION
1232: WHEN FND_API.G_EXC_ERROR THEN
1233: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1234: FND_MSG_PUB.Count_And_Get(
1235: p_encoded => FND_API.G_FALSE,
1236: p_count => x_MSG_COUNT,

Line 1233: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1229: p_data => X_MSG_DATA);
1230:
1231: EXCEPTION
1232: WHEN FND_API.G_EXC_ERROR THEN
1233: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1234: FND_MSG_PUB.Count_And_Get(
1235: p_encoded => FND_API.G_FALSE,
1236: p_count => x_MSG_COUNT,
1237: p_data => X_MSG_DATA);

Line 1235: p_encoded => FND_API.G_FALSE,

1231: EXCEPTION
1232: WHEN FND_API.G_EXC_ERROR THEN
1233: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1234: FND_MSG_PUB.Count_And_Get(
1235: p_encoded => FND_API.G_FALSE,
1236: p_count => x_MSG_COUNT,
1237: p_data => X_MSG_DATA);
1238: RETURN;
1239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1235: p_encoded => FND_API.G_FALSE,
1236: p_count => x_MSG_COUNT,
1237: p_data => X_MSG_DATA);
1238: RETURN;
1239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1241: FND_MSG_PUB.Count_And_Get(
1242: p_encoded => FND_API.G_FALSE,
1243: p_count => x_MSG_COUNT,

Line 1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1236: p_count => x_MSG_COUNT,
1237: p_data => X_MSG_DATA);
1238: RETURN;
1239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1241: FND_MSG_PUB.Count_And_Get(
1242: p_encoded => FND_API.G_FALSE,
1243: p_count => x_MSG_COUNT,
1244: p_data => X_MSG_DATA);

Line 1242: p_encoded => FND_API.G_FALSE,

1238: RETURN;
1239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1240: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1241: FND_MSG_PUB.Count_And_Get(
1242: p_encoded => FND_API.G_FALSE,
1243: p_count => x_MSG_COUNT,
1244: p_data => X_MSG_DATA);
1245: RETURN;
1246: WHEN OTHERS THEN

Line 1247: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1243: p_count => x_MSG_COUNT,
1244: p_data => X_MSG_DATA);
1245: RETURN;
1246: WHEN OTHERS THEN
1247: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1248: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1249: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1250: FND_MSG_PUB.ADD;
1251: FND_MSG_PUB.Count_And_Get(

Line 1252: p_encoded => FND_API.G_FALSE,

1248: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1249: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1250: FND_MSG_PUB.ADD;
1251: FND_MSG_PUB.Count_And_Get(
1252: p_encoded => FND_API.G_FALSE,
1253: p_count => x_MSG_COUNT,
1254: p_data => X_MSG_DATA);
1255: RETURN;
1256: END update_row;

Line 1469: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1465: IF (SQL%NOTFOUND) THEN
1466: RAISE NO_DATA_FOUND;
1467: END IF;
1468: -- Initialize API return status to success.
1469: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1470: -- Standard call to get message count and if count is 1, get message
1471: -- info.
1472: FND_MSG_PUB.Count_And_Get(
1473: p_encoded => FND_API.G_FALSE,

Line 1473: p_encoded => FND_API.G_FALSE,

1469: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1470: -- Standard call to get message count and if count is 1, get message
1471: -- info.
1472: FND_MSG_PUB.Count_And_Get(
1473: p_encoded => FND_API.G_FALSE,
1474: p_count => x_MSG_COUNT,
1475: p_data => X_MSG_DATA
1476: );
1477:

Line 1479: WHEN FND_API.G_EXC_ERROR THEN

1475: p_data => X_MSG_DATA
1476: );
1477:
1478: EXCEPTION
1479: WHEN FND_API.G_EXC_ERROR THEN
1480: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1481: FND_MSG_PUB.Count_And_Get(
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => x_MSG_COUNT,

Line 1480: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1476: );
1477:
1478: EXCEPTION
1479: WHEN FND_API.G_EXC_ERROR THEN
1480: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1481: FND_MSG_PUB.Count_And_Get(
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => x_MSG_COUNT,
1484: p_data => X_MSG_DATA);

Line 1482: p_encoded => FND_API.G_FALSE,

1478: EXCEPTION
1479: WHEN FND_API.G_EXC_ERROR THEN
1480: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1481: FND_MSG_PUB.Count_And_Get(
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => x_MSG_COUNT,
1484: p_data => X_MSG_DATA);
1485: RETURN;
1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1482: p_encoded => FND_API.G_FALSE,
1483: p_count => x_MSG_COUNT,
1484: p_data => X_MSG_DATA);
1485: RETURN;
1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MSG_PUB.Count_And_Get(
1489: p_encoded => FND_API.G_FALSE,
1490: p_count => x_MSG_COUNT,

Line 1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1483: p_count => x_MSG_COUNT,
1484: p_data => X_MSG_DATA);
1485: RETURN;
1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MSG_PUB.Count_And_Get(
1489: p_encoded => FND_API.G_FALSE,
1490: p_count => x_MSG_COUNT,
1491: p_data => X_MSG_DATA);

Line 1489: p_encoded => FND_API.G_FALSE,

1485: RETURN;
1486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1487: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MSG_PUB.Count_And_Get(
1489: p_encoded => FND_API.G_FALSE,
1490: p_count => x_MSG_COUNT,
1491: p_data => X_MSG_DATA);
1492: RETURN;
1493: WHEN OTHERS THEN

Line 1494: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1490: p_count => x_MSG_COUNT,
1491: p_data => X_MSG_DATA);
1492: RETURN;
1493: WHEN OTHERS THEN
1494: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1495: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1496: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1497: FND_MSG_PUB.ADD;
1498: FND_MSG_PUB.Count_And_Get(

Line 1499: p_encoded => FND_API.G_FALSE,

1495: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1496: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1497: FND_MSG_PUB.ADD;
1498: FND_MSG_PUB.Count_And_Get(
1499: p_encoded => FND_API.G_FALSE,
1500: p_count => x_MSG_COUNT,
1501: p_data => X_MSG_DATA);
1502: RETURN;
1503: END delete_row;