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.OE_FTE_INTEGRATION_PVT dependencies on FND_API

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: BEGIN
83:
84: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Update_FTE_Results..');
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: IF l_debug_level > 0 THEN
89: OE_DEBUG_PUB.Add('Before Calling Process Order..',3);
90: END IF;

Line 93: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

89: OE_DEBUG_PUB.Add('Before Calling Process Order..',3);
90: END IF;
91:
92: OE_ORDER_PVT.Lines
93: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
94: ,p_control_rec => l_control_rec
95: ,p_x_line_tbl => p_x_line_tbl
96: ,p_x_old_line_tbl => l_old_line_tbl
97: ,x_return_status => x_return_status);

Line 105: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

101: oe_debug_pub.Add('After Calling Process Order...'||
102: x_return_status,3);
103: END IF;
104:
105: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: x_return_status,3);
103: END IF;
104:
105: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:

Line 107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

103: END IF;
104:
105: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:
111: IF l_debug_level > 0 THEN

Line 108: RAISE FND_API.G_EXC_ERROR;

104:
105: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:
111: IF l_debug_level > 0 THEN
112: OE_DEBUG_PUB.Add('Before Calling Process Requests and Notify',3);

Line 127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

123: OE_DEBUG_PUB.Add('After Calling Process Requests' ||
124: 'and Notify...'|| x_return_status,3);
125: END IF;
126:
127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: 'and Notify...'|| x_return_status,3);
125: END IF;
126:
127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132:

Line 129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

125: END IF;
126:
127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132:
133:

Line 130: RAISE FND_API.G_EXC_ERROR;

126:
127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132:
133:
134: Print_Time('Exiting OE_FTE_INTEGRATION_PVT.Update_FTE_Results..');

Line 138: WHEN FND_API.G_EXC_ERROR THEN

134: Print_Time('Exiting OE_FTE_INTEGRATION_PVT.Update_FTE_Results..');
135:
136: EXCEPTION
137:
138: WHEN FND_API.G_EXC_ERROR THEN
139: IF l_debug_level > 0 THEN
140: OE_DEBUG_PUB.Add('Expected Error in Update FTE Results', 2);
141: END IF;
142: x_return_status := FND_API.G_RET_STS_ERROR;

Line 142: x_return_status := FND_API.G_RET_STS_ERROR;

138: WHEN FND_API.G_EXC_ERROR THEN
139: IF l_debug_level > 0 THEN
140: OE_DEBUG_PUB.Add('Expected Error in Update FTE Results', 2);
141: END IF;
142: x_return_status := FND_API.G_RET_STS_ERROR;
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: IF l_debug_level > 0 THEN
146: OE_DEBUG_PUB.Add('Unexpected Error in Update FTE Results'||

Line 144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

140: OE_DEBUG_PUB.Add('Expected Error in Update FTE Results', 2);
141: END IF;
142: x_return_status := FND_API.G_RET_STS_ERROR;
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: IF l_debug_level > 0 THEN
146: OE_DEBUG_PUB.Add('Unexpected Error in Update FTE Results'||
147: sqlerrm, 1);
148: END IF;

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145: IF l_debug_level > 0 THEN
146: OE_DEBUG_PUB.Add('Unexpected Error in Update FTE Results'||
147: sqlerrm, 1);
148: END IF;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150:
151: WHEN OTHERS THEN
152:
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150:
151: WHEN OTHERS THEN
152:
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154:
155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: OE_MSG_PUB.Add_Exc_Msg

Line 286: x_return_status := FND_API.G_RET_STS_SUCCESS;

282:
283: IF l_debug_level > 0 THEN
284: OE_DEBUG_PUB.Add('Order header Id:'||p_header_id,1);
285: END IF;
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287:
288:
289: -- Validating Order
290:

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: WHEN NO_DATA_FOUND THEN
298: IF l_debug_level > 0 THEN
299: OE_DEBUG_PUB.Add('No Data Found when Validating Order',3);
300: END IF;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: WHEN OTHERS THEN
303: IF l_debug_level > 0 THEN
304: OE_DEBUG_PUB.Add('When Others when Validating Order',3);
305: END IF;

Line 306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

302: WHEN OTHERS THEN
303: IF l_debug_level > 0 THEN
304: OE_DEBUG_PUB.Add('When Others when Validating Order',3);
305: END IF;
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: END;
308:
309: IF l_open_flag = 'N' OR l_order_category_code = 'RETURN' THEN
310: IF l_debug_level > 0 THEN

Line 313: RAISE FND_API.G_EXC_ERROR ;

309: IF l_open_flag = 'N' OR l_order_category_code = 'RETURN' THEN
310: IF l_debug_level > 0 THEN
311: OE_DEBUG_PUB.Add('Order is Return/Closed',1);
312: END IF;
313: RAISE FND_API.G_EXC_ERROR ;
314: END IF;
315:
316:
317: -- We need to create the included items if not already frozen.

Line 337: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

333: OE_DEBUG_PUB.Add('After Calling Process Included Items: '||
334: x_return_status,3);
335: END IF;
336:
337: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;

Line 338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

334: x_return_status,3);
335: END IF;
336:
337: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:

Line 339: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

335: END IF;
336:
337: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: END LOOP;

Line 340: RAISE FND_API.G_EXC_ERROR;

336:
337: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: END LOOP;
344:

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670:
671: Print_Time('Exiting OE_FTE_INTEGRATION_PVT.Create_FTE_Input...');
672: EXCEPTION
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.Add('Expected Error in Create FTE Input',2);
677: END IF;
678:

Line 679: x_return_status := FND_API.G_RET_STS_ERROR;

675: IF l_debug_level > 0 THEN
676: oe_debug_pub.Add('Expected Error in Create FTE Input',2);
677: END IF;
678:
679: x_return_status := FND_API.G_RET_STS_ERROR;
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

677: END IF;
678:
679: x_return_status := FND_API.G_RET_STS_ERROR;
680:
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);
684: END IF;
685:

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682: IF l_debug_level > 0 THEN
683: oe_debug_pub.Add('Unexpected Error in Create FTE Input:'||SqlErrm, 1);
684: END IF;
685:
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687:
688:
689: WHEN OTHERS THEN
690:

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

687:
688:
689: WHEN OTHERS THEN
690:
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692:
693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: OE_MSG_PUB.Add_Exc_Msg

Line 755: x_return_status := FND_API.G_RET_STS_SUCCESS;

751:
752: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Process_FTE_Output..');
753:
754: x_no_opr_count := 0;
755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756: l_line_offset := p_config_count + 1;
757:
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.Add('Total Number of Config lines:'||p_config_count,3);

Line 810: FND_API.G_RET_STS_ERROR THEN

806:
807: END IF;
808:
809: IF p_x_fte_source_line_tab(l_fte_count).status =
810: FND_API.G_RET_STS_ERROR THEN
811:
812: IF p_x_fte_source_line_tab(l_fte_count).source_line_id IS NOT NULL AND
813: p_x_fte_source_line_tab(l_fte_count).source_line_id <> FND_API.G_MISS_NUM THEN
814: BEGIN

Line 813: p_x_fte_source_line_tab(l_fte_count).source_line_id <> FND_API.G_MISS_NUM THEN

809: IF p_x_fte_source_line_tab(l_fte_count).status =
810: FND_API.G_RET_STS_ERROR THEN
811:
812: IF p_x_fte_source_line_tab(l_fte_count).source_line_id IS NOT NULL AND
813: p_x_fte_source_line_tab(l_fte_count).source_line_id <> FND_API.G_MISS_NUM THEN
814: BEGIN
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add('Getting reference data for line_id:'||
817: p_x_fte_source_line_tab(l_fte_count).source_line_id);

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

861: ('FTE Error :'|| p_x_fte_source_line_tab(l_fte_count).message_data,3);
862: END IF;
863: p_x_line_tbl(l_line_offset).operation := OE_GLOBALS.G_OPR_NONE;
864: x_no_opr_count := x_no_opr_count + 1;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866:
867: ELSE -- warning or success
868:
869: IF p_x_fte_source_line_tab(l_fte_count).status = 'W' THEN

Line 991: WHEN FND_API.G_EXC_ERROR THEN

987: Print_Time('Entering OE_FTE_INTEGRATION_PVT.Process_FTE_Output..');
988:
989: EXCEPTION
990:
991: WHEN FND_API.G_EXC_ERROR THEN
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.Add('Expected Error in Process FTE Output', 1);
994: END IF;
995:

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: IF l_debug_level > 0 THEN
993: oe_debug_pub.Add('Expected Error in Process FTE Output', 1);
994: END IF;
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.Add('Unexpected Error in Process FTE Output'||

Line 998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

994: END IF;
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.Add('Unexpected Error in Process FTE Output'||
1001: sqlerrm, 2);
1002: END IF;

Line 1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

999: IF l_debug_level > 0 THEN
1000: oe_debug_pub.Add('Unexpected Error in Process FTE Output'||
1001: sqlerrm, 2);
1002: END IF;
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004:
1005: WHEN OTHERS THEN
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004:
1005: WHEN OTHERS THEN
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1010: THEN
1011: OE_MSG_PUB.Add_Exc_Msg

Line 1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1071: IF p_line_id is not NULL THEN
1072: IF l_debug_level > 0 THEN
1073: oe_debug_pub.add('line id not null, error for now', 1);
1074: END IF;
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077:
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;
1079:

Line 1078: x_return_status := FND_API.G_RET_STS_SUCCESS;

1074: END IF;
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077:
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080: IF p_ui_flag = 'Y' THEN
1081: OE_MSG_PUB.Initialize;
1082: END IF;

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

1092: OE_MSG_PUB.Add;
1093: IF l_debug_level > 0 THEN
1094: oe_debug_pub.ADD('FTE is NOT Installed!',3);
1095: END IF;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: RETURN;
1098: END IF;
1099:
1100: Create_FTE_Input

Line 1114: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1110: oe_debug_pub.Add('After Calling Create FTE Input :'||
1111: x_return_status,3);
1112: END IF;
1113:
1114: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add(x_msg_data,1);

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1111: x_return_status,3);
1112: END IF;
1113:
1114: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add(x_msg_data,1);
1119: END IF;

Line 1116: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1112: END IF;
1113:
1114: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add(x_msg_data,1);
1119: END IF;
1120: RAISE FND_API.G_EXC_ERROR;

Line 1120: RAISE FND_API.G_EXC_ERROR;

1116: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1117: IF l_debug_level > 0 THEN
1118: oe_debug_pub.add(x_msg_data,1);
1119: END IF;
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122: IF l_debug_level > 0 THEN
1123: oe_debug_pub.Add('Before Calling FTE Process Lines...',3);
1124: END IF;

Line 1146: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1142: oe_debug_pub.Add('After Calling FTE Process Lines:'||
1143: x_return_status,3);
1144: END IF;
1145:
1146: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1150: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1143: x_return_status,3);
1144: END IF;
1145:
1146: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1150: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1151: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

Line 1148: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1144: END IF;
1145:
1146: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1150: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1151: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1152: IF l_debug_level > 0 THEN

Line 1151: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: IF ( FND_MSG_PUB.Count_Msg > 0 ) THEN
1150: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1151: l_msg_text := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1152: IF l_debug_level > 0 THEN
1153: oe_debug_pub.Add(l_msg_text, 3);
1154: END IF;
1155: oe_msg_pub.add_text(p_message_text => l_msg_text);

Line 1158: RAISE FND_API.G_EXC_ERROR;

1154: END IF;
1155: oe_msg_pub.add_text(p_message_text => l_msg_text);
1156: END LOOP;
1157: END IF;
1158: RAISE FND_API.G_EXC_ERROR;
1159: END IF;
1160:
1161:
1162:

Line 1180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1176: oe_debug_pub.Add('After Calling Process FTE Output: '||
1177: x_return_status);
1178: END IF;
1179:
1180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;

Line 1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1177: x_return_status);
1178: END IF;
1179:
1180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185:

Line 1182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1178: END IF;
1179:
1180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185:
1186: -- set the recursion flag so that FTE won't be called

Line 1183: RAISE FND_API.G_EXC_ERROR;

1179:
1180: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185:
1186: -- set the recursion flag so that FTE won't be called
1187: -- again for Freight Rating if ship method is changed

Line 1217: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1213: END IF;
1214:
1215: oe_globals.g_freight_recursion := 'N';
1216:
1217: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;

Line 1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1214:
1215: oe_globals.g_freight_recursion := 'N';
1216:
1217: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:

Line 1219: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1215: oe_globals.g_freight_recursion := 'N';
1216:
1217: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:
1223:

Line 1220: RAISE FND_API.G_EXC_ERROR;

1216:
1217: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:
1223:
1224: END IF; -- action is carrier or both

Line 1247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1243: oe_debug_pub.Add('After Calling FREIGHT Process_FTE_Output '||
1244: x_return_status,3);
1245: END IF;
1246:
1247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;

Line 1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1244: x_return_status,3);
1245: END IF;
1246:
1247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:

Line 1249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1245: END IF;
1246:
1247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:
1253: END IF;

Line 1250: RAISE FND_API.G_EXC_ERROR;

1246:
1247: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252:
1253: END IF;
1254: END IF; -- l_line_tbl.count > 0

Line 1268: WHEN FND_API.G_EXC_ERROR THEN

1264: Print_Time('Exiting OE_FTE_INTEGRATION_PVT.Process_FTE_Action...');
1265:
1266: EXCEPTION
1267:
1268: WHEN FND_API.G_EXC_ERROR THEN
1269: IF l_debug_level > 0 THEN
1270: oe_debug_pub.Add('Expected Error in Get Ship Method', 1);
1271: END IF;
1272:

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: OE_MSG_PUB.Count_And_Get
1274: ( p_count => x_msg_count
1275: ,p_data => x_msg_data);
1276:
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.Add('Unexpected Error in Get Ship Method'||sqlerrm, 2);

Line 1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1275: ,p_data => x_msg_data);
1276:
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.Add('Unexpected Error in Get Ship Method'||sqlerrm, 2);
1282: END IF;
1283:

Line 1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1284: OE_MSG_PUB.Count_And_Get
1285: ( p_count => x_msg_count
1286: ,p_data => x_msg_data);
1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289:
1290:
1291: WHEN OTHERS THEN
1292:

Line 1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1289:
1290:
1291: WHEN OTHERS THEN
1292:
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.Add('When Others in Get Ship Method'||sqlerrm,3);
1296: END IF;
1297: