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_AV_LVL_LGCY_PUB dependencies on FND_API

Line 269: IF NOT FND_API.Compatible_API_Call(

265: --Standard start of API savepoint
266: SAVEPOINT create_adv_stnd_level;
267:
268: --Standard call to check for call compatibility.
269: IF NOT FND_API.Compatible_API_Call(
270: l_api_version,
271: p_api_version,
272: l_api_name,
273: G_PKG_NAME)

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: p_api_version,
272: l_api_name,
273: G_PKG_NAME)
274: THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: --Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 279: IF FND_API.to_Boolean(p_init_msg_list) THEN

275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: --Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean(p_init_msg_list) THEN
280: FND_MSG_PUB.initialize;
281: END IF;
282:
283: --Initialize API return status to success.

Line 284: x_return_status := FND_API.G_RET_STS_SUCCESS;

280: FND_MSG_PUB.initialize;
281: END IF;
282:
283: --Initialize API return status to success.
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286:
287: -- main code logic begins
288: -- ensure UPPER case

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412: ELSE -- validate_lvl_bas
413: x_return_status := l_return; --it can be either E or W
414: END IF; -- validate_lvl_bas
415: ELSE -- l_return
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: END IF;
418: -- skip to end
419: l_skip := 'Y';
420: END IF; -- End of l_av_stnd_unit_lvl_id is not null

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: ELSE -- validate_lvl_bas
619: x_return_status := l_return; --it can be either E or W
620: END IF; -- validate_lvl_bas
621: ELSE -- l_return
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: END IF;
624: ELSE --create_post_lvl
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: END IF; --create_post_lvl

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621: ELSE -- l_return
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: END IF;
624: ELSE --create_post_lvl
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: END IF; --create_post_lvl
627: ELSE -- validate level
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: END IF; -- validate level

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: ELSE --create_post_lvl
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: END IF; --create_post_lvl
627: ELSE -- validate level
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: END IF; -- validate level
630: ELSE -- VALIDATE_LVL_DB_CONS
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: END IF; -- VALIDATE_LVL_DB_CONS

Line 631: x_return_status := FND_API.G_RET_STS_ERROR;

627: ELSE -- validate level
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: END IF; -- validate level
630: ELSE -- VALIDATE_LVL_DB_CONS
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: END IF; -- VALIDATE_LVL_DB_CONS
633: END IF; -- l_skip
634: ELSE -- validate_adv_stnd
635: x_return_status := FND_API.G_RET_STS_ERROR;

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: x_return_status := FND_API.G_RET_STS_ERROR;
632: END IF; -- VALIDATE_LVL_DB_CONS
633: END IF; -- l_skip
634: ELSE -- validate_adv_stnd
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END IF; --validate_adv_stnd
637: ELSE -- validate_adv_std_db_cons
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF; -- validate_adv_std_db_cons

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634: ELSE -- validate_adv_stnd
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END IF; --validate_adv_stnd
637: ELSE -- validate_adv_std_db_cons
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF; -- validate_adv_std_db_cons
640: ELSE -- validate_parameters(p_lgcy_adstlvl_rec)
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: END IF; -- validate_parameters(p_lgcy_adstlvl_rec)

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

637: ELSE -- validate_adv_std_db_cons
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: END IF; -- validate_adv_std_db_cons
640: ELSE -- validate_parameters(p_lgcy_adstlvl_rec)
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: END IF; -- validate_parameters(p_lgcy_adstlvl_rec)
643:
644: --rollback if the x_return_status is set to E (FND_API.G_RET_STS_ERROR) or W
645: IF x_return_status IN (FND_API.G_RET_STS_ERROR,'W','E') THEN

Line 644: --rollback if the x_return_status is set to E (FND_API.G_RET_STS_ERROR) or W

640: ELSE -- validate_parameters(p_lgcy_adstlvl_rec)
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: END IF; -- validate_parameters(p_lgcy_adstlvl_rec)
643:
644: --rollback if the x_return_status is set to E (FND_API.G_RET_STS_ERROR) or W
645: IF x_return_status IN (FND_API.G_RET_STS_ERROR,'W','E') THEN
646: ROLLBACK TO create_adv_stnd_level;
647: END IF;
648:

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

641: x_return_status := FND_API.G_RET_STS_ERROR;
642: END IF; -- validate_parameters(p_lgcy_adstlvl_rec)
643:
644: --rollback if the x_return_status is set to E (FND_API.G_RET_STS_ERROR) or W
645: IF x_return_status IN (FND_API.G_RET_STS_ERROR,'W','E') THEN
646: ROLLBACK TO create_adv_stnd_level;
647: END IF;
648:
649: --Standard check of p_commit.

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

646: ROLLBACK TO create_adv_stnd_level;
647: END IF;
648:
649: --Standard check of p_commit.
650: IF FND_API.to_Boolean(p_commit) AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
651: commit;
652: END IF;
653:
654: --Standard call to get message count and if count is 1, get message info.

Line 660: WHEN FND_API.G_EXC_ERROR THEN

656: p_count => x_msg_count,
657: p_data => x_msg_data);
658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: ROLLBACK TO create_adv_stnd_level;
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,

Line 662: x_return_status := FND_API.G_RET_STS_ERROR;

658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: ROLLBACK TO create_adv_stnd_level;
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,
665: p_data => x_msg_data);
666:

Line 667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,
665: p_data => x_msg_data);
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO create_adv_stnd_level;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_And_Get(
671: p_count => x_msg_count,

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

665: p_data => x_msg_data);
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO create_adv_stnd_level;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_And_Get(
671: p_count => x_msg_count,
672: p_data => x_msg_data);
673: WHEN OTHERS THEN

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: p_count => x_msg_count,
672: p_data => x_msg_data);
673: WHEN OTHERS THEN
674: ROLLBACK TO create_adv_stnd_level;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
677: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
678: FND_MSG_PUB.ADD;
679: FND_MSG_PUB.Count_And_Get(

Line 1112: RAISE FND_API.G_EXC_ERROR;

1108: failures at one go
1109: */
1110:
1111: IF NOT x_return_status THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114:
1115: END derive_level_data;
1116: