DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING_UTIL dependencies on WSH_UTIL_CORE

Line 218: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

214: l_qp_debug_prof_val VARCHAR2(1);
215: l_log_level_prof_val VARCHAR2(10);
216: BEGIN
217:
218: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220: g_msg_count := 0;
221: IF FND_API.to_Boolean( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize;

Line 248: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

244: --set_exception(p_met=>p_met,p_exc=>p_exc);
245: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_MISSING_LOG_DIR');
246: FND_MSG_PUB.ADD;
247: g_msg_count := g_msg_count + 1;
248: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
249: RETURN;
250:
251: END IF;
252: SELECT 'prc_'||to_char(sysdate,'MMDDYYHH24MISS')||'-'||fte_prc_debug_s.nextval|| '.dbg'

Line 277: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

273: END IF;
274:
275: EXCEPTION
276: WHEN others THEN
277: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
278: g_debug := false;
279: -- dbms_output.put_line ('Unexpected error '||SQLCODE||'-'||SQLERRM);
280: END initialize_logging;
281:

Line 361: x_num_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type )

357: END comma_to_table;
358:
359: PROCEDURE comma_to_number_table (
360: p_list IN VARCHAR2,
361: x_num_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type )
362: IS
363: l_arr dbms_utility.uncl_array;
364: i NUMBER :=0;
365: BEGIN

Line 414: p_num_tab IN wsh_util_core.id_tab_type,

410: RETURN;
411: END table_to_comma;
412:
413: PROCEDURE number_table_to_comma (
414: p_num_tab IN wsh_util_core.id_tab_type,
415: x_list OUT NOCOPY VARCHAR2 )
416: IS
417: l_tab dbms_utility.uncl_array;
418: i NUMBER :=0;

Line 723: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

719:
720: FND_MSG_PUB.ADD;
721:
722: --IF (p_msg_type = 'E') THEN
723: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
724: --ELSIF (p_msg_type = 'W') THEN
725: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
726: --ELSIF (p_msg_type = 'U') THEN
727: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);

Line 725: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

721:
722: --IF (p_msg_type = 'E') THEN
723: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
724: --ELSIF (p_msg_type = 'W') THEN
725: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
726: --ELSIF (p_msg_type = 'U') THEN
727: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
728: --END IF;
729:

Line 727: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);

723: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
724: --ELSIF (p_msg_type = 'W') THEN
725: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
726: --ELSIF (p_msg_type = 'U') THEN
727: --WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
728: --END IF;
729:
730:
731: EXCEPTION

Line 765: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

761:
762: BEGIN
763:
764: l_init_msg_list := fnd_api.g_true;
765: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
766:
767: reset_dbg_vars;
768: set_method(l_log_level,l_method_name);
769:

Line 775: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and

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
776: x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
777: THEN
778:
779: print_msg(l_log_level,'get currency code failed');

Line 776: x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

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
776: x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
777: THEN
778:
779: print_msg(l_log_level,'get currency code failed');
780: print_msg(l_log_level,'x_return_status '|| x_return_status);

Line 809: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and

805: p_carrier_id => p_carrier_id
806: );
807:
808:
809: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
810: x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
811: THEN
812:
813: print_msg(l_log_level,'get currency code failed');

Line 810: x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

806: );
807:
808:
809: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
810: x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
811: THEN
812:
813: print_msg(l_log_level,'get currency code failed');
814: print_msg(l_log_level,'l_msg_data '|| l_msg_data);

Line 825: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

821: unset_method(l_log_level,l_method_name);
822:
823: EXCEPTION
824: WHEN FND_API.G_EXC_ERROR THEN
825: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
826: set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
827: unset_method(l_log_level,l_method_name);
828: WHEN OTHERS THEN
829: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 829: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

825: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
826: set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
827: unset_method(l_log_level,l_method_name);
828: WHEN OTHERS THEN
829: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
830: set_exception(l_method_name,G_ERR,'g_others');
831: print_msg(G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
832: unset_method(l_log_level,l_method_name);
833: