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 FND_MESSAGE

Line 88: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_NO_SITE');

84:
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);

Line 96: FND_MESSAGE.SET_NAME('WSH','WSH_PDLVY_MULT_SITE');

92: WSH_DEBUG_SV.pop(l_module_name);
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);

Line 196: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_NO_LOC');

192: --
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);

Line 205: FND_MESSAGE.SET_NAME('WSH','WSH_CUST_MULT_LOC');

201: END IF;
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);

Line 418: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');

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;
422:

Line 420: x_return_message := FND_MESSAGE.GET;

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: --
424: -- Return to the calling API

Line 664: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_SOURCE_LINES');

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: --
668: -- Debug Statements

Line 666: x_msg_data := FND_MESSAGE.GET;

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: --
668: -- Debug Statements
669: --
670: IF l_debug_on THEN

Line 686: FND_MESSAGE.SET_NAME('FTE', 'FTE_PRC_RATE_CHOICE_ERR1');

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: --
690: -- Debug Statements

Line 688: x_msg_data := FND_MESSAGE.GET;

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: --
690: -- Debug Statements
691: --
692: IF l_debug_on THEN

Line 927: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_MULTILEG');

923:
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;

Line 930: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

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
934: WSH_DEBUG_SV.logmsg(l_module_name,'Multileg results returned');

Line 1034: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');

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);
1038: END IF;

Line 1035: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

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);
1038: END IF;
1039: END IF; -- no carrier servoce

Line 1051: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_GENERIC_CARRIER');

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;
1055:

Line 1052: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name);

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;
1055:
1056: IF l_debug_on THEN

Line 1053: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

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;
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

Line 1083: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_SHIP_METHOD');

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);
1087: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

Line 1084: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', 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);
1087: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1088: FND_MSG_PUB.ADD;

Line 1085: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);

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);
1087: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1088: FND_MSG_PUB.ADD;
1089:

Line 1086: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name);

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);
1087: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1088: FND_MSG_PUB.ADD;
1089:
1090: IF l_debug_on THEN

Line 1087: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

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);
1087: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1088: FND_MSG_PUB.ADD;
1089:
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

Line 1104: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_INCOMPLETE_SHIP_METHOD');

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);
1107: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1108: FND_MSG_PUB.ADD;

Line 1105: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);

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);
1107: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1108: FND_MSG_PUB.ADD;
1109:

Line 1106: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);

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);
1107: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1108: FND_MSG_PUB.ADD;
1109:
1110: IF l_debug_on THEN

Line 1107: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

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);
1107: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1108: FND_MSG_PUB.ADD;
1109:
1110: IF l_debug_on THEN
1111: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

Line 1177: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD');

1173: FETCH get_ship_method_meaning INTO l_ship_method_meaning;
1174: CLOSE get_ship_method_meaning;
1175:
1176: IF (l_cs_transit_min is null) THEN
1177: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD');
1178: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1179: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1180: FND_MSG_PUB.ADD;
1181: ELSE

Line 1178: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);

1174: CLOSE get_ship_method_meaning;
1175:
1176: IF (l_cs_transit_min is null) THEN
1177: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD');
1178: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1179: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1180: FND_MSG_PUB.ADD;
1181: ELSE
1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');

Line 1179: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

1175:
1176: IF (l_cs_transit_min is null) THEN
1177: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD');
1178: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1179: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1180: FND_MSG_PUB.ADD;
1181: ELSE
1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');
1183: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);

Line 1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');

1178: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1179: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1180: FND_MSG_PUB.ADD;
1181: ELSE
1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');
1183: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1184: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1185: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1186: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

Line 1183: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);

1179: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1180: FND_MSG_PUB.ADD;
1181: ELSE
1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');
1183: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1184: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1185: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1186: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1187: FND_MSG_PUB.ADD;

Line 1184: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);

1180: FND_MSG_PUB.ADD;
1181: ELSE
1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');
1183: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1184: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1185: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1186: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1187: FND_MSG_PUB.ADD;
1188: END IF;

Line 1185: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);

1181: ELSE
1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');
1183: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1184: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1185: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1186: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1187: FND_MSG_PUB.ADD;
1188: END IF;
1189:

Line 1186: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

1182: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NOMATCH_SHIP_METHOD_2');
1183: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1184: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1185: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1186: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1187: FND_MSG_PUB.ADD;
1188: END IF;
1189:
1190: IF l_debug_on THEN

Line 1216: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TT_DISCREPANCY');

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;
1215:
1216: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TT_DISCREPANCY');
1217: FND_MESSAGE.SET_TOKEN('ATP_TRANSIT_TIME', l_transit_time);
1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);

Line 1217: FND_MESSAGE.SET_TOKEN('ATP_TRANSIT_TIME', l_transit_time);

1213: FETCH get_ship_method_meaning INTO l_ship_method_meaning;
1214: CLOSE get_ship_method_meaning;
1215:
1216: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TT_DISCREPANCY');
1217: FND_MESSAGE.SET_TOKEN('ATP_TRANSIT_TIME', l_transit_time);
1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1221: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);

Line 1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);

1214: CLOSE get_ship_method_meaning;
1215:
1216: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TT_DISCREPANCY');
1217: FND_MESSAGE.SET_TOKEN('ATP_TRANSIT_TIME', l_transit_time);
1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1221: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1222: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

Line 1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);

1215:
1216: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TT_DISCREPANCY');
1217: FND_MESSAGE.SET_TOKEN('ATP_TRANSIT_TIME', l_transit_time);
1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1221: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1222: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1223: FND_MSG_PUB.ADD;

Line 1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);

1216: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TT_DISCREPANCY');
1217: FND_MESSAGE.SET_TOKEN('ATP_TRANSIT_TIME', l_transit_time);
1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1221: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1222: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1223: FND_MSG_PUB.ADD;
1224:

Line 1221: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);

1217: FND_MESSAGE.SET_TOKEN('ATP_TRANSIT_TIME', l_transit_time);
1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1221: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1222: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1223: FND_MSG_PUB.ADD;
1224:
1225: IF l_debug_on THEN

Line 1222: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

1218: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1219: FND_MESSAGE.SET_TOKEN('FTE_MIN_TRANSIT_TIME', l_cs_transit_min);
1220: FND_MESSAGE.SET_TOKEN('FTE_MAX_TRANSIT_TIME', l_cs_transit_max);
1221: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1222: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1223: FND_MSG_PUB.ADD;
1224:
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

Line 1253: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_CS_TRANSIT_LARGER');

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;
1257: FND_MESSAGE.SET_TOKEN('CS_TRANSIT_TIME', p_source_header_tab(i).delivery_lead_time);

Line 1257: FND_MESSAGE.SET_TOKEN('CS_TRANSIT_TIME', p_source_header_tab(i).delivery_lead_time);

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;
1257: FND_MESSAGE.SET_TOKEN('CS_TRANSIT_TIME', p_source_header_tab(i).delivery_lead_time);
1258: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1259: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1260: FND_MESSAGE.SET_TOKEN('OM_TRANSIT_TIME', l_orig_delivery_time);
1261: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

Line 1258: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);

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;
1257: FND_MESSAGE.SET_TOKEN('CS_TRANSIT_TIME', p_source_header_tab(i).delivery_lead_time);
1258: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1259: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1260: FND_MESSAGE.SET_TOKEN('OM_TRANSIT_TIME', l_orig_delivery_time);
1261: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1262: FND_MSG_PUB.ADD;

Line 1259: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);

1255: FETCH get_ship_method_meaning INTO l_ship_method_meaning;
1256: CLOSE get_ship_method_meaning;
1257: FND_MESSAGE.SET_TOKEN('CS_TRANSIT_TIME', p_source_header_tab(i).delivery_lead_time);
1258: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1259: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1260: FND_MESSAGE.SET_TOKEN('OM_TRANSIT_TIME', l_orig_delivery_time);
1261: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1262: FND_MSG_PUB.ADD;
1263:

Line 1260: FND_MESSAGE.SET_TOKEN('OM_TRANSIT_TIME', l_orig_delivery_time);

1256: CLOSE get_ship_method_meaning;
1257: FND_MESSAGE.SET_TOKEN('CS_TRANSIT_TIME', p_source_header_tab(i).delivery_lead_time);
1258: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1259: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1260: FND_MESSAGE.SET_TOKEN('OM_TRANSIT_TIME', l_orig_delivery_time);
1261: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1262: FND_MSG_PUB.ADD;
1263:
1264: IF l_debug_on THEN

Line 1261: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;

1257: FND_MESSAGE.SET_TOKEN('CS_TRANSIT_TIME', p_source_header_tab(i).delivery_lead_time);
1258: FND_MESSAGE.SET_TOKEN('SHIP_METHOD', l_ship_method_meaning);
1259: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1260: FND_MESSAGE.SET_TOKEN('OM_TRANSIT_TIME', l_orig_delivery_time);
1261: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;
1262: FND_MSG_PUB.ADD;
1263:
1264: IF l_debug_on THEN
1265: WSH_DEBUG_SV.log(l_module_name, 'message_data', p_source_header_tab(i).message_data);

Line 1280: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');

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;
1284:

Line 1281: p_source_header_tab(i).message_data := FND_MESSAGE.GET;

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;
1284:
1285: -- populate the CS results from consolidation table to line output table

Line 1335: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

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);
1338: ELSE
1339: FND_MESSAGE.SET_TOKEN('LOGFILE','');

Line 1337: FND_MESSAGE.SET_TOKEN('LOGFILE',WSH_DEBUG_SV.g_Dir||'/'||WSH_DEBUG_SV.g_File);

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);
1338: ELSE
1339: FND_MESSAGE.SET_TOKEN('LOGFILE','');
1340: END IF;
1341: FND_MSG_PUB.ADD;

Line 1339: FND_MESSAGE.SET_TOKEN('LOGFILE','');

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);
1338: ELSE
1339: FND_MESSAGE.SET_TOKEN('LOGFILE','');
1340: END IF;
1341: FND_MSG_PUB.ADD;
1342:
1343: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');

Line 1343: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');

1339: FND_MESSAGE.SET_TOKEN('LOGFILE','');
1340: END IF;
1341: FND_MSG_PUB.ADD;
1342:
1343: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');
1344: FND_MSG_PUB.ADD;
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'return_status is changed from '||l_status||' to '||x_return_status||' after getting ship method.',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1361: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_NO_CS_RESULT');

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:
1365: --

Line 1362: p_source_line_tab(i).message_data := FND_MESSAGE.GET;

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:
1365: --
1366: -- Debug Statements