DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING_UTIL dependencies on FTE_FREIGHT_PRICING

Line 1: PACKAGE BODY FTE_FREIGHT_PRICING_UTIL AS

1: PACKAGE BODY FTE_FREIGHT_PRICING_UTIL AS
2: /* $Header: FTEFRUTB.pls 120.2 2005/10/25 14:52:41 susurend noship $ */
3:
4: -- package global variables
5: g_utl_file_name VARCHAR2(255);

Line 185: print_tag(p_msg => '');

181: -- IF NOT G_OE_DEBUG THEN
182: -- OE_DEBUG_PUB.Debug_off;
183: -- END IF;
184: printf('PROGRAM END TIME '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||'');
185: print_tag(p_msg => '');
186: IF (g_debug_mode = 'FILE') THEN
187: IF (utl_file.is_open(g_file_ptr)) THEN
188: utl_file.fclose(g_file_ptr);
189: END IF;

Line 257: print_tag(p_msg => '');

253: INTO g_utl_file_name
254: FROM dual;
255: g_file_ptr := utl_file.fopen(g_utl_file_dir, g_utl_file_name, 'w');
256:
257: print_tag(p_msg => '');
258: printf('PROGRAM START TIME '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||'');
259:
260: -- IF nvl(FND_PROFILE.value('QP_DEBUG'),'N') = 'Y' THEN
261: -- IF NOT OE_DEBUG_PUB.ISDebugOn THEN

Line 758: l_method_name VARCHAR2(50) := 'fte_freight_pricing_util.get_currency_code';

754: l_init_msg_list VARCHAR2(1);
755: l_msg_count NUMBER;
756: l_msg_data VARCHAR2(32767);
757: l_log_level NUMBER := G_DBG;
758: l_method_name VARCHAR2(50) := 'fte_freight_pricing_util.get_currency_code';
759: l_entity_type VARCHAR2(20);
760: l_entity_id NUMBER;
761:
762: BEGIN

Line 771: FTE_FREIGHT_PRICING.get_currency_code (

767: reset_dbg_vars;
768: set_method(l_log_level,l_method_name);
769:
770: --R12 Hiding Project
771: FTE_FREIGHT_PRICING.get_currency_code (
772: p_carrier_id=>p_carrier_id,
773: x_currency_code=>x_currency_code,
774: x_return_status=>x_return_status);
775: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and

Line 882: END FTE_FREIGHT_PRICING_UTIL;

878:
879: END convert_uom;
880:
881:
882: END FTE_FREIGHT_PRICING_UTIL;