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.FTE_ACS_PKG dependencies on FTE_ACS_PKG

Line 1: PACKAGE BODY FTE_ACS_PKG AS

1: PACKAGE BODY FTE_ACS_PKG AS
2: /* $Header: FTEACSMB.pls 120.6 2005/09/28 05:01:57 alksharm ship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_ACS_PKG --

Line 5: -- NAME: FTE_ACS_PKG --

1: PACKAGE BODY FTE_ACS_PKG AS
2: /* $Header: FTEACSMB.pls 120.6 2005/09/28 05:01:57 alksharm ship $ */
3: -- -------------------------------------------------------------------------- --
4: -- --
5: -- NAME: FTE_ACS_PKG --
6: -- TYPE: PACKAGE BODY --
7: -- DESCRIPTION: Contains core procedures for carrier selection module --
8: -- --
9: -- --

Line 22: g_message_tab FTE_ACS_PKG.fte_cs_output_message_tab;

18: -- ------------------------ --
19: -- --
20: -- -------------------------------------------------------------------------- --
21:
22: g_message_tab FTE_ACS_PKG.fte_cs_output_message_tab;
23:
24: -- -------------------------------------------------------------------------- --
25: -- R12 Enhancement
26: -- Local data structues

Line 49: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ACS_PKG';

45: -- ----------------------------- --
46: -- --
47: -- -------------------------------------------------------------------------- --
48: --
49: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_ACS_PKG';
50:
51: --
52: -- -------------------------------------------------------------------------- --
53: -- --

Line 64: -- FTE_ACS_PKG.fte_flag_tab_type --

60: -- PARAMETERS (OUT): x_return_status OUT NOCOPY VARCHAR2 --
61: -- x_return_message OUT NOCOPY VARCHAR2 --
62: -- --
63: -- PARAMETERS (IN OUT): p_message_type_tab IN OUT NOCOPY --
64: -- FTE_ACS_PKG.fte_flag_tab_type --
65: -- p_message_code_tab IN OUT NOCOPY --
66: -- FTE_ACS_PKG.fte_car_sel_tmp_code_table --
67: -- p_message_text_tab IN OUT NOCOPY --
68: -- FTE_ACS_PKG.fte_car_sel_msg_table --

Line 66: -- FTE_ACS_PKG.fte_car_sel_tmp_code_table --

62: -- --
63: -- PARAMETERS (IN OUT): p_message_type_tab IN OUT NOCOPY --
64: -- FTE_ACS_PKG.fte_flag_tab_type --
65: -- p_message_code_tab IN OUT NOCOPY --
66: -- FTE_ACS_PKG.fte_car_sel_tmp_code_table --
67: -- p_message_text_tab IN OUT NOCOPY --
68: -- FTE_ACS_PKG.fte_car_sel_msg_table --
69: -- p_level_tab IN OUT NOCOPY --
70: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

Line 68: -- FTE_ACS_PKG.fte_car_sel_msg_table --

64: -- FTE_ACS_PKG.fte_flag_tab_type --
65: -- p_message_code_tab IN OUT NOCOPY --
66: -- FTE_ACS_PKG.fte_car_sel_tmp_code_table --
67: -- p_message_text_tab IN OUT NOCOPY --
68: -- FTE_ACS_PKG.fte_car_sel_msg_table --
69: -- p_level_tab IN OUT NOCOPY --
70: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
71: -- p_group_id_tab IN OUT NOCOPY --
72: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

Line 70: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

66: -- FTE_ACS_PKG.fte_car_sel_tmp_code_table --
67: -- p_message_text_tab IN OUT NOCOPY --
68: -- FTE_ACS_PKG.fte_car_sel_msg_table --
69: -- p_level_tab IN OUT NOCOPY --
70: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
71: -- p_group_id_tab IN OUT NOCOPY --
72: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
73: -- p_rule_id_tab IN OUT NOCOPY --
74: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

Line 72: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

68: -- FTE_ACS_PKG.fte_car_sel_msg_table --
69: -- p_level_tab IN OUT NOCOPY --
70: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
71: -- p_group_id_tab IN OUT NOCOPY --
72: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
73: -- p_rule_id_tab IN OUT NOCOPY --
74: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
75: -- p_result_id_tab IN OUT NOCOPY --
76: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

Line 74: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

70: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
71: -- p_group_id_tab IN OUT NOCOPY --
72: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
73: -- p_rule_id_tab IN OUT NOCOPY --
74: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
75: -- p_result_id_tab IN OUT NOCOPY --
76: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
77: -- --
78: -- RETURN: n/a --

Line 76: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --

72: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
73: -- p_rule_id_tab IN OUT NOCOPY --
74: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
75: -- p_result_id_tab IN OUT NOCOPY --
76: -- FTE_ACS_PKG.fte_car_sel_tmp_num_table --
77: -- --
78: -- RETURN: n/a --
79: -- --
80: -- DESCRIPTION: This procedure takes in tables of messages and rule/ --

Line 93: PROCEDURE LOG_CS_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_ACS_PKG.fte_flag_tab_type,

89: -- ---------- ------- -------- ------- ---------------------------------- --
90: -- 2002/12/15 I ABLUNDEL ------- Created --
91: -- --
92: -- -------------------------------------------------------------------------- --
93: PROCEDURE LOG_CS_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_ACS_PKG.fte_flag_tab_type,
94: p_message_code_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_code_table,
95: p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,
96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
97: p_query_id IN NUMBER,

Line 94: p_message_code_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_code_table,

90: -- 2002/12/15 I ABLUNDEL ------- Created --
91: -- --
92: -- -------------------------------------------------------------------------- --
93: PROCEDURE LOG_CS_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_ACS_PKG.fte_flag_tab_type,
94: p_message_code_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_code_table,
95: p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,
96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
97: p_query_id IN NUMBER,
98: p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,

Line 95: p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,

91: -- --
92: -- -------------------------------------------------------------------------- --
93: PROCEDURE LOG_CS_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_ACS_PKG.fte_flag_tab_type,
94: p_message_code_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_code_table,
95: p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,
96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
97: p_query_id IN NUMBER,
98: p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
99: p_rule_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,

Line 96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,

92: -- -------------------------------------------------------------------------- --
93: PROCEDURE LOG_CS_MESSAGES(p_message_type_tab IN OUT NOCOPY FTE_ACS_PKG.fte_flag_tab_type,
94: p_message_code_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_code_table,
95: p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,
96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
97: p_query_id IN NUMBER,
98: p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
99: p_rule_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
100: p_result_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,

Line 98: p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,

94: p_message_code_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_code_table,
95: p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,
96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
97: p_query_id IN NUMBER,
98: p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
99: p_rule_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
100: p_result_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_return_message OUT NOCOPY VARCHAR2) IS

Line 99: p_rule_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,

95: p_message_text_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_msg_table,
96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
97: p_query_id IN NUMBER,
98: p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
99: p_rule_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
100: p_result_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_return_message OUT NOCOPY VARCHAR2) IS
103:

Line 100: p_result_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,

96: p_level_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
97: p_query_id IN NUMBER,
98: p_group_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
99: p_rule_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
100: p_result_id_tab IN OUT NOCOPY FTE_ACS_PKG.fte_car_sel_tmp_num_table,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_return_message OUT NOCOPY VARCHAR2) IS
103:
104:

Line 210: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_PKG.LOG_CS_MESSAGES IS ' ||L_ERROR_TEXT );

206: --
207: -- Debug Statements
208: --
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_PKG.LOG_CS_MESSAGES IS ' ||L_ERROR_TEXT );
211: END IF;
212: --
213: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.LOG_CS_MESSAGES');
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 213: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.LOG_CS_MESSAGES');

209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_ACS_PKG.LOG_CS_MESSAGES IS ' ||L_ERROR_TEXT );
211: END IF;
212: --
213: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.LOG_CS_MESSAGES');
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
215: x_return_message := ('FTE_ACS_PKG.LOG_CS_MESSAGES '||l_error_text);
216: --
217: -- Debug Statements

Line 215: x_return_message := ('FTE_ACS_PKG.LOG_CS_MESSAGES '||l_error_text);

211: END IF;
212: --
213: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.LOG_CS_MESSAGES');
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
215: x_return_message := ('FTE_ACS_PKG.LOG_CS_MESSAGES '||l_error_text);
216: --
217: -- Debug Statements
218: --
219: IF l_debug_on THEN

Line 252: p_single_rec IN FTE_ACS_PKG.fte_cs_entity_rec_type DEFAULT NULL,

248:
249: PROCEDURE LOG_EXCEPTIONS( p_caller IN VARCHAR2,
250: p_entity IN VARCHAR2,
251: p_use_gtt IN BOOLEAN,
252: p_single_rec IN FTE_ACS_PKG.fte_cs_entity_rec_type DEFAULT NULL,
253: x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_output_message_tab,
254: x_return_status OUT NOCOPY VARCHAR2)
255: IS
256:

Line 253: x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_output_message_tab,

249: PROCEDURE LOG_EXCEPTIONS( p_caller IN VARCHAR2,
250: p_entity IN VARCHAR2,
251: p_use_gtt IN BOOLEAN,
252: p_single_rec IN FTE_ACS_PKG.fte_cs_entity_rec_type DEFAULT NULL,
253: x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.fte_cs_output_message_tab,
254: x_return_status OUT NOCOPY VARCHAR2)
255: IS
256:
257: CURSOR c_get_failed_entities IS

Line 461: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.log_exceptions');

457: IF c_get_failed_entities%ISOPEN THEN
458: CLOSE c_get_failed_entities;
459: END IF;
460:
461: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.log_exceptions');
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
463:
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 486: p_single_rec IN FTE_ACS_PKG.FTE_CS_ENTITY_REC_TYPE,

482: -- In case of multi records GTT is used. For single record p_single_rec is used.
483: --***************************************************************************--
484: PROCEDURE GET_FORMAT_RESULTS( p_caller IN VARCHAR2,
485: p_use_gtt IN BOOLEAN,
486: p_single_rec IN FTE_ACS_PKG.FTE_CS_ENTITY_REC_TYPE,
487: x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
488: x_return_status OUT NOCOPY VARCHAR2)
489: IS
490:

Line 487: x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,

483: --***************************************************************************--
484: PROCEDURE GET_FORMAT_RESULTS( p_caller IN VARCHAR2,
485: p_use_gtt IN BOOLEAN,
486: p_single_rec IN FTE_ACS_PKG.FTE_CS_ENTITY_REC_TYPE,
487: x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
488: x_return_status OUT NOCOPY VARCHAR2)
489: IS
490:
491: CURSOR c_get_rules_for_entity IS

Line 767: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');

763: IF (c_get_rule_name%ISOPEN) THEN
764: CLOSE c_get_rule_name;
765: END IF;
766:
767: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');
768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
769: --
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 794: p_format_cs_tab IN OUT NOCOPY FTE_ACS_PKG.FTE_CS_ENTITY_TAB_TYPE,

790: --
791: -- COMMENT : Returns the routing results associated with a given rule
792: --***************************************************************************--
793: PROCEDURE GET_ROUTING_RESULTS( --p_start_search_level_flag IN VARCHAR2,
794: p_format_cs_tab IN OUT NOCOPY FTE_ACS_PKG.FTE_CS_ENTITY_TAB_TYPE,
795: p_entity IN VARCHAR2,
796: p_messaging_yn IN VARCHAR2,
797: p_caller IN VARCHAR2,
798: x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,

Line 798: x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,

794: p_format_cs_tab IN OUT NOCOPY FTE_ACS_PKG.FTE_CS_ENTITY_TAB_TYPE,
795: p_entity IN VARCHAR2,
796: p_messaging_yn IN VARCHAR2,
797: p_caller IN VARCHAR2,
798: x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
799: x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_OUTPUT_MESSAGE_TAB,
800: x_return_message OUT NOCOPY VARCHAR2,
801: x_return_status OUT NOCOPY VARCHAR2)
802: IS

Line 799: x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_OUTPUT_MESSAGE_TAB,

795: p_entity IN VARCHAR2,
796: p_messaging_yn IN VARCHAR2,
797: p_caller IN VARCHAR2,
798: x_cs_output_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
799: x_cs_output_message_tab OUT NOCOPY FTE_ACS_PKG.FTE_CS_OUTPUT_MESSAGE_TAB,
800: x_return_message OUT NOCOPY VARCHAR2,
801: x_return_status OUT NOCOPY VARCHAR2)
802: IS
803:

Line 808: l_entity_rec FTE_ACS_PKG.fte_cs_entity_rec_type;

804: l_entities_left NUMBER;
805: l_single_entity BOOLEAN;
806: l_use_gtt BOOLEAN;
807:
808: l_entity_rec FTE_ACS_PKG.fte_cs_entity_rec_type;
809: l_search_level_tab WSH_UTIL_CORE.column_tab_type;
810:
811: l_output_tab FTE_ACS_CACHE_PKG.fte_cs_entity_attr_tab;
812: l_entity_info FTE_ACS_CACHE_PKG.fte_cs_entity_attr_rec;

Line 1175: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');

1171: EXCEPTION
1172:
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: --
1175: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');
1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1177: --
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1185: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');

1181: END IF;
1182:
1183: WHEN OTHERS THEN
1184: --
1185: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');
1186: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1187: --
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1195: END FTE_ACS_PKG;

1191: END IF;
1192:
1193: END GET_ROUTING_RESULTS;
1194:
1195: END FTE_ACS_PKG;