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_PROCESS_REQUESTS dependencies on WSH_UTIL_CORE

Line 44: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

40: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CUSTOMER_SITE';
41:
42: BEGIN
43: --
44: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
45: --
46: IF l_debug_on THEN
47: wsh_debug_sv.push (l_module_name);
48: END IF;

Line 89: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

85: EXCEPTION
86: WHEN NO_SHIP_TO_SITE THEN
87: -- Delivery is not assoociated with a site.
88: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_NO_SITE');
89: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
90: WSH_UTIL_CORE.add_message(x_return_status);
91: IF l_debug_on THEN
92: WSH_DEBUG_SV.pop(l_module_name);
93: END IF;

Line 90: WSH_UTIL_CORE.add_message(x_return_status);

86: WHEN NO_SHIP_TO_SITE THEN
87: -- Delivery is not assoociated with a site.
88: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_NO_SITE');
89: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
90: WSH_UTIL_CORE.add_message(x_return_status);
91: IF l_debug_on THEN
92: WSH_DEBUG_SV.pop(l_module_name);
93: END IF;
94: WHEN MULT_SHIP_TO_SITE THEN

Line 97: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

93: END IF;
94: WHEN MULT_SHIP_TO_SITE THEN
95: -- Delivery is associated with multiple sites
96: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_MULT_SITE');
97: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
98: WSH_UTIL_CORE.add_message(x_return_status);
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.pop(l_module_name);
101: END IF;

Line 98: WSH_UTIL_CORE.add_message(x_return_status);

94: WHEN MULT_SHIP_TO_SITE THEN
95: -- Delivery is associated with multiple sites
96: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_MULT_SITE');
97: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
98: WSH_UTIL_CORE.add_message(x_return_status);
99: IF l_debug_on THEN
100: WSH_DEBUG_SV.pop(l_module_name);
101: END IF;
102:

Line 104: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_customer_site');

100: WSH_DEBUG_SV.pop(l_module_name);
101: END IF;
102:
103: WHEN OTHERS THEN
104: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_customer_site');
105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
106: IF l_debug_on THEN
107: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

101: END IF;
102:
103: WHEN OTHERS THEN
104: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_customer_site');
105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
106: IF l_debug_on THEN
107: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
109: END IF;

Line 152: l_cust_tab WSH_UTIL_CORE.ID_TAB_TYPE;

148: hz_cust_acct_sites_all hcas
149: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
150: AND hcsu.site_use_id = p_site_id;
151:
152: l_cust_tab WSH_UTIL_CORE.ID_TAB_TYPE;
153: no_cust_for_loc EXCEPTION;
154: mult_cust_for_loc EXCEPTION;
155:
156: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 161: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

157: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_SHIP_TO_CUSTOMER';
158:
159: BEGIN
160: --
161: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
162: --
163: IF l_debug_on THEN
164: wsh_debug_sv.push (l_module_name);
165: END IF;

Line 197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

193: EXCEPTION
194: WHEN NO_CUST_FOR_LOC THEN
195: -- Location not associated with a customer.
196: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_NO_LOC');
197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
198: WSH_UTIL_CORE.add_message(x_return_status);
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;

Line 198: WSH_UTIL_CORE.add_message(x_return_status);

194: WHEN NO_CUST_FOR_LOC THEN
195: -- Location not associated with a customer.
196: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_NO_LOC');
197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
198: WSH_UTIL_CORE.add_message(x_return_status);
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202:

Line 206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

202:
203: WHEN MULT_CUST_FOR_LOC THEN
204: -- Location associated with a multiple customers.
205: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_MULT_LOC');
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
207: WSH_UTIL_CORE.add_message(x_return_status);
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.pop(l_module_name);
210: END IF;

Line 207: WSH_UTIL_CORE.add_message(x_return_status);

203: WHEN MULT_CUST_FOR_LOC THEN
204: -- Location associated with a multiple customers.
205: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_MULT_LOC');
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
207: WSH_UTIL_CORE.add_message(x_return_status);
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.pop(l_module_name);
210: END IF;
211:

Line 213: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_ship_to_customer');

209: WSH_DEBUG_SV.pop(l_module_name);
210: END IF;
211:
212: WHEN OTHERS THEN
213: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_ship_to_customer');
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
215:
216: IF (c_get_shipto_cust_from_loc%ISOPEN) THEN
217: CLOSE c_get_shipto_cust_from_loc;

Line 214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

210: END IF;
211:
212: WHEN OTHERS THEN
213: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUEST.get_ship_to_customer');
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
215:
216: IF (c_get_shipto_cust_from_loc%ISOPEN) THEN
217: CLOSE c_get_shipto_cust_from_loc;
218: END IF;

Line 313: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

309: IF l_debug_on THEN
310: WSH_DEBUG_SV.push(l_module_name);
311: END IF;
312: --
313: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
314: x_return_message := null;
315:
316: l := 0;
317:

Line 342: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

338: p_source_line_tab => p_source_line_tab,
339: x_customer_site_id => l_customer_site_id,
340: x_return_status => l_return_status);
341:
342: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
343: GOTO next_pass;
344: END IF;
345:
346: l_cs_input_tab(l).customer_site_id := l_customer_site_id;

Line 357: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

353:
354: WSH_SHIPPING_PARAMS_PVT.Get(x_param_value_info => l_param_rec ,
355: x_return_status => l_return_status);
356:
357: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
358: GOTO next_pass;
359: END IF;
360:
361: --Evaluate Rules based on ship to customer

Line 369: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

365: p_ship_to_site => l_customer_site_id,
366: x_customer_id => l_customer_id,
367: x_return_status => l_return_status);
368:
369: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
370: GOTO next_pass;
371: END IF;
372: l_cs_input_tab(l).customer_id := l_customer_id;
373: ELSE

Line 409: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) AND

405:
406: --
407: -- The engine returns the formatted results
408: --
409: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) AND
410: (l_cs_output_tab.COUNT > 0)) THEN
411: --
412: -- Return the results - We have rule id
413: -- Ship method is returned internally from the engine.

Line 417: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

413: -- Ship method is returned internally from the engine.
414: --
415: x_result_tab := l_cs_output_tab;
416: ELSE
417: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
418: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
419: wsh_util_core.add_message(x_return_status);
420: x_return_message := FND_MESSAGE.GET;
421: END IF;

Line 419: wsh_util_core.add_message(x_return_status);

415: x_result_tab := l_cs_output_tab;
416: ELSE
417: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
418: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
419: wsh_util_core.add_message(x_return_status);
420: x_return_message := FND_MESSAGE.GET;
421: END IF;
422:
423: --

Line 446: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUESTS.FORMAT_CS_CALL');

442: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_PROCESS_REQUESTS.FORMAT_CS_CALL IS ' ||L_ERROR_TEXT );
443: END IF;
444: --
445:
446: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUESTS.FORMAT_CS_CALL');
447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
448: x_return_message := l_error_text;
449: --
450: -- Debug Statements

Line 447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

443: END IF;
444: --
445:
446: WSH_UTIL_CORE.default_handler('FTE_PROCESS_REQUESTS.FORMAT_CS_CALL');
447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
448: x_return_message := l_error_text;
449: --
450: -- Debug Statements
451: --

Line 644: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

640: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
641: WSH_DEBUG_SV.log(l_module_name,'P_ACTION',P_ACTION);
642: END IF;
643: --
644: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
645:
646: /* R12 Glog Integration */
647: -- determine if OTM is installed
648: l_otm_installed:=NULL;

Line 649: l_otm_installed:=WSH_UTIL_CORE.GC3_Is_Installed;

645:
646: /* R12 Glog Integration */
647: -- determine if OTM is installed
648: l_otm_installed:=NULL;
649: l_otm_installed:=WSH_UTIL_CORE.GC3_Is_Installed;
650: IF ((l_otm_installed IS NOT NULL) AND (l_otm_installed='Y'))
651: THEN
652: l_otm_installed:='Y';
653: ELSE

Line 663: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

659: l_otm_installed:='N';
660: END IF;
661:
662: IF (p_source_line_tab.COUNT < 1) THEN
663: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
664: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_SOURCE_LINES');
665: x_msg_count := l_msg_count + 1;
666: x_msg_data := FND_MESSAGE.GET;
667: --

Line 685: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

681:
682: -- this action requires group being passed in
683: IF (p_source_header_tab.COUNT < 1) THEN
684:
685: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
686: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_RATE_CHOICE_ERR1');
687: x_msg_count := l_msg_count + 1;
688: x_msg_data := FND_MESSAGE.GET;
689: --

Line 741: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

737: x_msg_count => l_msg_count,
738: x_msg_data => l_msg_data);
739: END IF;
740:
741: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
742: x_source_line_rates_tab := l_source_line_rates_tab;
743: x_source_header_rates_tab := l_source_header_rates_tab;
744: END IF;
745:

Line 794: l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

790: END IF;
791:
792: IF (p_source_header_tab.COUNT = 0 OR
793: l_status is null OR
794: l_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
795:
796: IF (l_status is not null) THEN
797: x_return_status := l_status;
798: ELSE

Line 799: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

795:
796: IF (l_status is not null) THEN
797: x_return_status := l_status;
798: ELSE
799: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
800: END IF;
801: --
802: -- Debug Statements
803: --

Line 814: IF (p_source_header_tab.COUNT > 0 AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

810:
811: --
812: -- Do carrier selection for each consolidation if consolidated successfully
813: -- and action is C or B
814: IF (p_source_header_tab.COUNT > 0 AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
815: AND (p_action = 'C' OR p_action = 'B')) THEN
816:
817: IF (l_otm_installed = 'N') THEN
818: FORMAT_CS_CALL( p_source_header_tab => p_source_header_tab,

Line 874: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

870: but l_msg_data rather than l_return_message is still used
871: below, so won't change it
872: */
873:
874: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
875: IF l_debug_on THEN
876: WSH_DEBUG_SV.log(l_module_name,'l_result_tab.count',l_result_tab.count);
877: WSH_DEBUG_SV.log(l_module_name,'l_result_consolidation_id_tab.count',l_result_consolidation_id_tab.count);
878: END IF;

Line 903: IF (l_status is not null AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

899: END IF;
900:
901: END IF; -- if (l_otm_installed)
902:
903: IF (l_status is not null AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
904:
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.logmsg(l_module_name, 'Populating CS results into consolidation table');
907: END IF;

Line 928: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

924: IF (l_result_tab(j).result_type<>'RANK') THEN
925:
926: l_no_results := 'N';
927: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG');
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
929: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
930: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
931: FND_MSG_PUB.ADD;
932:

Line 929: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

925:
926: l_no_results := 'N';
927: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG');
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
929: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
930: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
931: FND_MSG_PUB.ADD;
932:
933: IF l_debug_on THEN

Line 1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1028: FETCH get_generic_sm_on_ser INTO p_source_header_tab(i).ship_method_code;
1029: CLOSE get_generic_sm_on_ser;
1030: ELSE
1031: -- no carrier selection results at all
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1033: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1034: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1035: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1036: IF l_debug_on THEN

Line 1033: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1029: CLOSE get_generic_sm_on_ser;
1030: ELSE
1031: -- no carrier selection results at all
1032: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1033: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1034: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1035: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

Line 1047: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_source_header_tab(i).ship_from_org_id);

1043:
1044: -- error: need to set up generic carrier
1045: IF (p_source_header_tab(i).ship_method_code is null) THEN
1046:
1047: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_source_header_tab(i).ship_from_org_id);
1048:
1049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1050: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1051: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_GENERIC_CARRIER');

Line 1049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1045: IF (p_source_header_tab(i).ship_method_code is null) THEN
1046:
1047: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_source_header_tab(i).ship_from_org_id);
1048:
1049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1050: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1051: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_GENERIC_CARRIER');
1052: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name);
1053: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

Line 1050: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1046:
1047: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_source_header_tab(i).ship_from_org_id);
1048:
1049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1050: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1051: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_GENERIC_CARRIER');
1052: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name);
1053: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1054: FND_MSG_PUB.ADD;

Line 1073: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR result from CS, but no valid ship method assigned to org');
1071: END IF;
1072:
1073: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1074: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1075:
1076: OPEN get_ship_method_meaning2( p_source_header_tab(i).carrier_id,
1077: p_source_header_tab(i).mode_of_transport,

Line 1074: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1070: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR result from CS, but no valid ship method assigned to org');
1071: END IF;
1072:
1073: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1074: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1075:
1076: OPEN get_ship_method_meaning2( p_source_header_tab(i).carrier_id,
1077: p_source_header_tab(i).mode_of_transport,
1078: p_source_header_tab(i).service_level);

Line 1082: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_source_header_tab(i).ship_from_org_id);

1078: p_source_header_tab(i).service_level);
1079: FETCH get_ship_method_meaning2 INTO l_ship_method_meaning;
1080: CLOSE get_ship_method_meaning2;
1081:
1082: l_org_name := WSH_UTIL_CORE.Get_Org_Name(p_source_header_tab(i).ship_from_org_id);
1083: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_SHIP_METHOD');
1084: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1085: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1086: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name);

Line 1101: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR incomplete ship method setup');
1099: END IF;
1100:
1101: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1102: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1103: WSH_CARRIERS_GRP.Get_Carrier_Name(p_source_header_tab(i).carrier_id, l_carrier_name, l_freight_code);
1104: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_INCOMPLETE_SHIP_METHOD');
1105: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);

Line 1102: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1098: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR incomplete ship method setup');
1099: END IF;
1100:
1101: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1102: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1103: WSH_CARRIERS_GRP.Get_Carrier_Name(p_source_header_tab(i).carrier_id, l_carrier_name, l_freight_code);
1104: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_INCOMPLETE_SHIP_METHOD');
1105: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1106: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);

Line 1118: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1114:
1115: -- if have ship_method must mean have everything, continue
1116: IF (p_source_header_tab(i).ship_method_code is not null) THEN
1117:
1118: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1119: -- get ship method, and transit time from transit times table
1120: OPEN get_session_id;
1121: FETCH get_session_id INTO l_session_id;
1122: CLOSE get_session_id;

Line 1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1166: IF l_debug_on THEN
1167: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR ship method returned by ATP is different from CS ship method');
1168: END IF;
1169:
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1172: OPEN get_ship_method_meaning(p_source_header_tab(i).ship_method_code);
1173: FETCH get_ship_method_meaning INTO l_ship_method_meaning;
1174: CLOSE get_ship_method_meaning;

Line 1171: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1167: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR ship method returned by ATP is different from CS ship method');
1168: END IF;
1169:
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1171: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1172: OPEN get_ship_method_meaning(p_source_header_tab(i).ship_method_code);
1173: FETCH get_ship_method_meaning INTO l_ship_method_meaning;
1174: CLOSE get_ship_method_meaning;
1175:

Line 1210: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1206: WSH_DEBUG_SV.logmsg(l_module_name, 'WARNING ATP transit time falls outside FTE range. Setting return lead time to be FTE min');
1207: END IF;
1208:
1209: -- set warning message
1210: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1211:
1212: OPEN get_ship_method_meaning(p_source_header_tab(i).ship_method_code);
1213: FETCH get_ship_method_meaning INTO l_ship_method_meaning;
1214: CLOSE get_ship_method_meaning;

Line 1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1247: IF l_debug_on THEN
1248: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OM lead time not null and greater than 0 (scheduled) and transit time to be returned by FTE process_lines is greater than exisiting on OM');
1249: END IF;
1250:
1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1252: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1253: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TRANSIT_LARGER');
1254: OPEN get_ship_method_meaning(p_source_header_tab(i).ship_method_code);
1255: FETCH get_ship_method_meaning INTO l_ship_method_meaning;

Line 1252: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1248: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR OM lead time not null and greater than 0 (scheduled) and transit time to be returned by FTE process_lines is greater than exisiting on OM');
1249: END IF;
1250:
1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1252: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1253: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TRANSIT_LARGER');
1254: OPEN get_ship_method_meaning(p_source_header_tab(i).ship_method_code);
1255: FETCH get_ship_method_meaning INTO l_ship_method_meaning;
1256: CLOSE get_ship_method_meaning;

Line 1278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1274: END IF; -- end finding a matching consolidation id
1275: END LOOP; -- end looping thru all result consolidations
1276:
1277: IF (l_no_results = 'Y') THEN -- if no results for this consolidation, error
1278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1279: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1280: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1281: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1282: END IF;

Line 1279: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1275: END LOOP; -- end looping thru all result consolidations
1276:
1277: IF (l_no_results = 'Y') THEN -- if no results for this consolidation, error
1278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1279: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1280: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1281: p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1282: END IF;
1283: END LOOP;

Line 1333: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1329: END IF;
1330: END LOOP;
1331:
1332: -- if it failed with any of the above validation
1333: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1334:
1335: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
1336: IF l_debug_on THEN
1337: FND_MESSAGE.SET_TOKEN('LOGFILE',WSH_DEBUG_SV.g_Dir||'/'||WSH_DEBUG_SV.g_File);

Line 1355: ELSIF (l_status is not null AND l_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

1351: RETURN;
1352: END IF;
1353:
1354: -- format cs call had warnings (no results at all), put error in each line
1355: ELSIF (l_status is not null AND l_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; -- overall status is success
1357: x_msg_data := l_msg_data;
1358:
1359: FOR i IN p_source_line_tab.FIRST..p_source_line_tab.LAST LOOP

Line 1356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; -- overall status is success

1352: END IF;
1353:
1354: -- format cs call had warnings (no results at all), put error in each line
1355: ELSIF (l_status is not null AND l_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; -- overall status is success
1357: x_msg_data := l_msg_data;
1358:
1359: FOR i IN p_source_line_tab.FIRST..p_source_line_tab.LAST LOOP
1360: p_source_line_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1360: p_source_line_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; -- overall status is success
1357: x_msg_data := l_msg_data;
1358:
1359: FOR i IN p_source_line_tab.FIRST..p_source_line_tab.LAST LOOP
1360: p_source_line_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1361: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1362: p_source_line_tab(i).message_data := FND_MESSAGE.GET;
1363: END LOOP;
1364:

Line 1383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1379: END IF;
1380: x_return_status := l_status;
1381: x_msg_data := l_msg_data;
1382: IF (x_return_status is null) THEN
1383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1384: END IF;
1385:
1386: FOR i IN p_source_line_tab.FIRST..p_source_line_tab.LAST LOOP
1387: IF l_debug_on THEN

Line 1409: IF (p_source_header_tab.COUNT > 0 AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

1405: END IF;
1406:
1407:
1408: -- if action is R or B, do rating call
1409: IF (p_source_header_tab.COUNT > 0 AND l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
1410: AND (p_action = 'R' OR p_action = 'B')) THEN
1411:
1412: IF (l_otm_installed ='N') THEN
1413: IF l_debug_on THEN

Line 1452: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1448: x_msg_count => l_msg_count,
1449: x_msg_data => l_msg_data);
1450: END IF;
1451:
1452: IF (l_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1453: x_source_line_rates_tab := l_source_line_rates_tab;
1454: x_source_header_rates_tab := l_source_header_rates_tab;
1455: END IF;
1456:

Line 1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1470: --
1471: EXCEPTION
1472:
1473: WHEN OTHERS THEN
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1475: x_msg_data := SQLERRM;
1476: --
1477: -- Debug Statements
1478: --

Line 1510: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1506: x_msg_count OUT NOCOPY NUMBER,
1507: x_msg_data OUT NOCOPY VARCHAR2)
1508: IS
1509: BEGIN
1510: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1511: END Process_Lines;
1512:
1513:
1514: END FTE_PROCESS_REQUESTS;