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.

[Home] [Help]

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 675: WHEN FND_API.G_EXC_ERROR THEN

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

Line 680: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 756: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 811: FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 866: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 992: WHEN FND_API.G_EXC_ERROR THEN

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

Line 997: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1079: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1097: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1115: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1117: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1121: RAISE FND_API.G_EXC_ERROR;

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

Line 1147: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1149: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 1159: RAISE FND_API.G_EXC_ERROR;

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

Line 1181: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1183: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1184: RAISE FND_API.G_EXC_ERROR;

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

Line 1218: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1220: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1221: RAISE FND_API.G_EXC_ERROR;

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

Line 1248: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1250: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1251: RAISE FND_API.G_EXC_ERROR;

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

Line 1269: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1278: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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