APPS.IGS_AV_UNT_LGCY_PUB dependencies on FND_API

Line 1618: IF NOT FND_API.Compatible_API_Call(

1614: --Standard start of API savepoint
1615: SAVEPOINT create_adv_stnd_unit;
1616:
1617: --Standard call to check for call compatibility.
1618: IF NOT FND_API.Compatible_API_Call(
1619: l_api_version,
1620: p_api_version,
1621: l_api_name,
1622: G_PKG_NAME)

Line 1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1620: p_api_version,
1621: l_api_name,
1622: G_PKG_NAME)
1623: THEN
1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:
1627: --Initialize message list if p_init_msg_list is set to TRUE.
1628: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1628: IF FND_API.to_Boolean(p_init_msg_list) THEN

1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:
1627: --Initialize message list if p_init_msg_list is set to TRUE.
1628: IF FND_API.to_Boolean(p_init_msg_list) THEN
1629: FND_MSG_PUB.initialize;
1630: END IF;
1631:
1632: --Initialize API return status to success.

Line 1633: x_return_status := FND_API.G_RET_STS_SUCCESS;

1629: FND_MSG_PUB.initialize;
1630: END IF;
1631:
1632: --Initialize API return status to success.
1633: x_return_status := FND_API.G_RET_STS_SUCCESS;
1634:
1635: /*==================== Start Your coding here==========*/
1636:
1637: /* Initialise */

Line 1862: x_return_status := FND_API.G_RET_STS_ERROR;

1858: p_tst_rslt_dtls_id => l_tst_rslt_dtls_id,
1859: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec
1860: ) THEN
1861: mydebug('Error 2');
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: ELSE -- create_post_unit
1864: IF l_reference_code_id IS NOT NULL THEN
1865: IF validate_ref_code(
1866: p_av_stnd_unit_id => l_av_stnd_unit_lvl_id,

Line 1900: x_return_status := FND_API.G_RET_STS_ERROR;

1896: p_lgcy_adstunt_rec.APPLIED_PROGRAM_CD,
1897: null
1898: );
1899: ELSE -- validate_reference codes
1900: x_return_status := FND_API.G_RET_STS_ERROR;
1901: mydebug('Error 6');
1902: END IF; -- validate_ref_code
1903: END IF;
1904: mydebug('Before validate_alt_unt_db_cons');

Line 1941: x_return_status := FND_API.G_RET_STS_ERROR;

1937: igs_ge_gen_003.get_org_id(),
1938: l_av_stnd_unit_lvl_id
1939: );
1940: ELSE -- validate_unit_basis
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: mydebug('Error 6');
1943: END IF; -- validate_unit_basis
1944: ELSE -- validate_unt_bss_db_cons
1945: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1945: x_return_status := FND_API.G_RET_STS_ERROR;

1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: mydebug('Error 6');
1943: END IF; -- validate_unit_basis
1944: ELSE -- validate_unt_bss_db_cons
1945: x_return_status := FND_API.G_RET_STS_ERROR;
1946: mydebug('Error 7');
1947: END IF; --validate_unt_bss_db_cons
1948: END IF; --create_post_unit
1949: ELSE -- validate_unit

Line 1951: x_return_status := FND_API.G_RET_STS_ERROR;

1947: END IF; --validate_unt_bss_db_cons
1948: END IF; --create_post_unit
1949: ELSE -- validate_unit
1950: mydebug('Error 3');
1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: END IF; --validate_unit
1953: ELSE -- validate_std_unt_db_cons
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: mydebug('Error 4');

Line 1954: x_return_status := FND_API.G_RET_STS_ERROR;

1950: mydebug('Error 3');
1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: END IF; --validate_unit
1953: ELSE -- validate_std_unt_db_cons
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: mydebug('Error 4');
1956: END IF; --validate_std_unt_db_cons
1957: ELSE
1958: IF p_lgcy_adstunt_rec.s_adv_stnd_recognition_type <> 'PRECLUSION' THEN

Line 2018: RAISE FND_API.G_EXC_ERROR;

2014: mydebug('Error 5');
2015: IF x_return_status = 'W' THEN
2016: RAISE duplicate_record_exists;
2017: ElSE
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;
2020: END IF; -- validate_alt_unt_db_cons
2021: END IF; --l_b_av_stnd_alt_unit_pk_exist
2022: ELSE -- validate_adv_stnd

Line 2023: x_return_status := FND_API.G_RET_STS_ERROR;

2019: END IF;
2020: END IF; -- validate_alt_unt_db_cons
2021: END IF; --l_b_av_stnd_alt_unit_pk_exist
2022: ELSE -- validate_adv_stnd
2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024: mydebug('Error 8');
2025: END IF;--validate_adv_stnd
2026: ELSE -- validate_adv_std_db_cons
2027: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2027: x_return_status := FND_API.G_RET_STS_ERROR;

2023: x_return_status := FND_API.G_RET_STS_ERROR;
2024: mydebug('Error 8');
2025: END IF;--validate_adv_stnd
2026: ELSE -- validate_adv_std_db_cons
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: mydebug('Error 9');
2029: END IF; --validate_adv_std_db_cons
2030: ELSE -- derive_unit_data
2031: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2031: x_return_status := FND_API.G_RET_STS_ERROR;

2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: mydebug('Error 9');
2029: END IF; --validate_adv_std_db_cons
2030: ELSE -- derive_unit_data
2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032: mydebug('Error 10');
2033: END IF;-- derive_unit_data
2034: ELSE -- validate_parameters
2035: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2035: x_return_status := FND_API.G_RET_STS_ERROR;

2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032: mydebug('Error 10');
2033: END IF;-- derive_unit_data
2034: ELSE -- validate_parameters
2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036: mydebug('Error 11');
2037: END IF;--validate_parameters
2038:
2039: IF x_return_status IN (FND_API.G_RET_STS_ERROR,'E','W') THEN

Line 2039: IF x_return_status IN (FND_API.G_RET_STS_ERROR,'E','W') THEN

2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036: mydebug('Error 11');
2037: END IF;--validate_parameters
2038:
2039: IF x_return_status IN (FND_API.G_RET_STS_ERROR,'E','W') THEN
2040: mydebug('************************ Roll Back ********************');
2041: ROLLBACK TO create_adv_stnd_unit;
2042: END IF;
2043: /*==================== End Your coding here==========*/

Line 2049: IF FND_API.to_Boolean(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2045:
2046: --Standard check of p_commit.
2047:
2048: mydebug('************************ Before Doing a COMMIT ********************');
2049: IF FND_API.to_Boolean(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2050: mydebug('************************ Doing a COMMIT ********************');
2051: commit;
2052: END IF;
2053: --Standard call to get message count and if count is 1, get message info.

Line 2065: WHEN FND_API.G_EXC_ERROR THEN

2061: FND_MSG_PUB.Count_And_Get(
2062: p_count => x_msg_count,
2063: p_data => x_msg_data
2064: );
2065: WHEN FND_API.G_EXC_ERROR THEN
2066: ROLLBACK TO create_adv_stnd_unit;
2067: x_return_status := FND_API.G_RET_STS_ERROR;
2068: FND_MSG_PUB.Count_And_Get(
2069: p_count => x_msg_count,

Line 2067: x_return_status := FND_API.G_RET_STS_ERROR;

2063: p_data => x_msg_data
2064: );
2065: WHEN FND_API.G_EXC_ERROR THEN
2066: ROLLBACK TO create_adv_stnd_unit;
2067: x_return_status := FND_API.G_RET_STS_ERROR;
2068: FND_MSG_PUB.Count_And_Get(
2069: p_count => x_msg_count,
2070: p_data => x_msg_data);
2071:

Line 2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2068: FND_MSG_PUB.Count_And_Get(
2069: p_count => x_msg_count,
2070: p_data => x_msg_data);
2071:
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: ROLLBACK TO create_adv_stnd_unit;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: FND_MSG_PUB.Count_And_Get(
2076: p_count => x_msg_count,

Line 2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2070: p_data => x_msg_data);
2071:
2072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2073: ROLLBACK TO create_adv_stnd_unit;
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: FND_MSG_PUB.Count_And_Get(
2076: p_count => x_msg_count,
2077: p_data => x_msg_data);
2078: WHEN OTHERS THEN

Line 2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2076: p_count => x_msg_count,
2077: p_data => x_msg_data);
2078: WHEN OTHERS THEN
2079: ROLLBACK TO create_adv_stnd_unit;
2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2081: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2082: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2083: FND_MSG_PUB.ADD;
2084: