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.OZF_TP_UTIL_QUERIES dependencies on FND_API

Line 426: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

422:
423:
424: PROCEDURE get_list_price(
425: p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
427: p_commit IN VARCHAR2 := FND_API.g_false,
428:
429: p_obj_id IN NUMBER,
430: p_obj_type IN VARCHAR2,

Line 427: p_commit IN VARCHAR2 := FND_API.g_false,

423:
424: PROCEDURE get_list_price(
425: p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
427: p_commit IN VARCHAR2 := FND_API.g_false,
428:
429: p_obj_id IN NUMBER,
430: p_obj_type IN VARCHAR2,
431: p_product_attribute IN VARCHAR2,

Line 491: IF FND_API.to_boolean(p_init_msg_list) THEN

487:
488: BEGIN
489:
490:
491: IF FND_API.to_boolean(p_init_msg_list) THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF NOT FND_API.compatible_api_call(l_api_version,

Line 495: IF NOT FND_API.compatible_api_call(l_api_version,

491: IF FND_API.to_boolean(p_init_msg_list) THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF NOT FND_API.compatible_api_call(l_api_version,
496: p_api_version,
497: l_api_name,
498: g_pkg_name)
499: THEN

Line 500: RAISE FND_API.g_exc_unexpected_error;

496: p_api_version,
497: l_api_name,
498: g_pkg_name)
499: THEN
500: RAISE FND_API.g_exc_unexpected_error;
501: END IF;
502:
503: x_return_status := FND_API.g_ret_sts_success;
504:

Line 503: x_return_status := FND_API.g_ret_sts_success;

499: THEN
500: RAISE FND_API.g_exc_unexpected_error;
501: END IF;
502:
503: x_return_status := FND_API.g_ret_sts_success;
504:
505: -- Passing Information to the Pricing Engine
506:
507: -- Setting up the control record variables

Line 602: x_return_status := FND_API.G_RET_STS_ERROR;

598: x_return_status_text);
599:
600: IF x_return_stat = 'E'
601: THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
604: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);
605: FND_MSG_PUB.add;
606: RAISE FND_API.G_EXC_ERROR;

Line 606: RAISE FND_API.G_EXC_ERROR;

602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
604: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);
605: FND_MSG_PUB.add;
606: RAISE FND_API.G_EXC_ERROR;
607: ELSE
608:
609: I := x_line_tbl.FIRST;
610: IF I IS NOT NULL

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: END IF;
616:
617: IF l_status_code <> 'UPDATED'
618: THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
621: FND_MESSAGE.set_token('ERR_MSG',l_status_text);
622: FND_MSG_PUB.add;
623: RAISE FND_API.G_EXC_ERROR;

Line 623: RAISE FND_API.G_EXC_ERROR;

619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
621: FND_MESSAGE.set_token('ERR_MSG',l_status_text);
622: FND_MSG_PUB.add;
623: RAISE FND_API.G_EXC_ERROR;
624:
625: END IF;
626:
627: END IF;

Line 632: WHEN FND_API.G_EXC_ERROR THEN

628:
629:
630: EXCEPTION
631:
632: WHEN FND_API.G_EXC_ERROR THEN
633: IF (AMS_DEBUG_HIGH_ON) THEN
634:
635: AMS_Utility_PVT.debug_message('Validate_get_list_price_of_goods: ' || substr(sqlerrm, 1, 100));
636: END IF;

Line 637: x_return_status := FND_API.G_RET_STS_ERROR;

633: IF (AMS_DEBUG_HIGH_ON) THEN
634:
635: AMS_Utility_PVT.debug_message('Validate_get_list_price_of_goods: ' || substr(sqlerrm, 1, 100));
636: END IF;
637: x_return_status := FND_API.G_RET_STS_ERROR;
638:
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.g_false,
641: p_count => x_msg_count,

Line 640: p_encoded => FND_API.g_false,

636: END IF;
637: x_return_status := FND_API.G_RET_STS_ERROR;
638:
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.g_false,
641: p_count => x_msg_count,
642: p_data => x_msg_data
643: );
644:

Line 646: x_return_status := FND_API.g_ret_sts_unexp_error;

642: p_data => x_msg_data
643: );
644:
645: WHEN OTHERS THEN
646: x_return_status := FND_API.g_ret_sts_unexp_error;
647:
648: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
649: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
650: FND_MSG_PUB.add;

Line 657: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

653: THEN
654: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
655: END IF;
656:
657: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
658: p_count => x_msg_count,
659: p_data => x_msg_data);
660:
661: