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_CONFIG_VALIDATION_PVT dependencies on FND_API

Line 127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

123: ,x_complete_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125: )
126: IS
127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
128: l_top_bill_sequence_id NUMBER;
129: l_effective_date DATE;
130: l_model_qty NUMBER;
131: l_valid_config VARCHAR2(10);

Line 159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

155: WHEN OTHERS THEN
156: IF l_debug_level > 0 THEN
157: oe_debug_pub.add('SELECT FAILED '|| SQLERRM , 1 ) ;
158: END IF;
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END;
161:
162:
163: OE_Config_Util.Get_Config_Effective_Date

Line 179: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

175: ( p_options_tbl => p_options_tbl
176: ,p_top_model_line_id => p_top_model_line_id
177: ,x_return_status => l_return_status);
178:
179: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
180: Handle_Ret_Status(p_valid_config => l_valid_config);
181: END IF;
182:
183: IF l_debug_level > 0 THEN

Line 195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

191: ,p_options_tbl => p_options_tbl
192: ,x_valid_config => l_valid_config
193: ,x_return_status => l_return_status);
194:
195: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
196: Handle_Ret_Status(p_valid_config => l_valid_config);
197: END IF;
198:
199:

Line 209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

205: ( p_options_tbl => p_options_tbl
206: ,x_complete_config => l_complete_config
207: ,x_return_status => l_return_status);
208:
209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
210: Handle_Ret_Status(p_complete_config => l_complete_config);
211: END IF;
212:
213: IF l_debug_level > 0 THEN

Line 224: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

220: ,p_options_tbl => p_options_tbl
221: ,x_valid_config => l_valid_config
222: ,x_return_status => l_return_status);
223:
224: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
225: Handle_Ret_Status(p_valid_config => l_valid_config);
226: END IF;
227:
228:

Line 241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

237: ,p_options_tbl => p_options_tbl
238: ,x_complete_config => l_complete_config
239: ,x_return_status => l_return_status);
240:
241: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
242: Handle_Ret_Status(p_complete_config => l_complete_config);
243: END IF;
244:
245:

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: x_complete_config := G_COMPLETE_CONFIG;
248:
249: IF G_VALID_CONFIG = 'FALSE' OR
250: G_COMPLETE_CONFIG = 'FALSE' THEN
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: ELSE
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254: END IF;
255:

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: IF G_VALID_CONFIG = 'FALSE' OR
250: G_COMPLETE_CONFIG = 'FALSE' THEN
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: ELSE
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254: END IF;
255:
256: Print_Time('Bom_Based_Config_Validation end time');
257: IF l_debug_level > 0 THEN

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

262: WHEN OTHERS THEN
263: IF l_debug_level > 0 THEN
264: oe_debug_pub.add('BOM_BASED_CONFIG_VALIDATION EXCEPTION'|| SQLERRM,1);
265: END IF;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: RAISE;
268: END Bom_Based_Config_Validation;
269:
270:

Line 295: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

291: (p_options_tbl IN VALIDATE_OPTIONS_TBL_TYPE
292: ,p_top_model_line_id IN NUMBER
293: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
294: IS
295: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
296: l_parent_qty NUMBER;
297: I NUMBER;
298: l_parent_exists BOOLEAN := FALSE;
299: l_ordered_item VARCHAR2(2000);

Line 360: RAISE FND_API.G_EXC_ERROR;

356: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
357:
358: OE_Msg_Pub.Add;
359:
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363: END IF; -- if the qty = 0
364:

Line 380: RAISE FND_API.G_EXC_ERROR;

376: IF NOT l_parent_exists THEN
377: IF l_debug_level > 0 THEN
378: oe_debug_pub.add('MAJOR ERROR , CAN NOT GO FURTHER' , 2 ) ;
379: END IF;
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382:
383: END IF; -- if not model
384:

Line 506: RAISE FND_API.G_EXC_ERROR;

502:
503: FND_MESSAGE.Set_TOKEN('LINE', l_line);
504: OE_MSG_PUB.Add;
505:
506: RAISE FND_API.G_EXC_ERROR;
507: END;
508:
509: RETURN FALSE;
510:

Line 542: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

538: IS
539: I NUMBER;
540: l_max_allowed_qty NUMBER;
541: l_min_allowed_qty NUMBER;
542: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
543: l_valid_config VARCHAR2(10) := 'TRUE';
544: --
545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
546: --

Line 606: l_return_status := FND_API.G_RET_STS_ERROR;

602: FND_MESSAGE.Set_Token('LOW', l_min_allowed_qty);
603: FND_MESSAGE.Set_Token('HIGH', l_max_allowed_qty);
604: OE_Msg_Pub.Add;
605: l_valid_config := 'FALSE';
606: l_return_status := FND_API.G_RET_STS_ERROR;
607: END IF;
608:
609: ELSE
610: IF l_debug_level > 0 THEN

Line 650: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

646: IS
647: -- 4319370
648: I NUMBER;
649: l_no_child BOOLEAN;
650: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
651: l_complete_config VARCHAR2(10) := 'TRUE';
652: l_inventory_item_id NUMBER;
653: --
654: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 695: l_return_status := FND_API.G_RET_STS_ERROR;

691: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_CLASS_NO_OPTION');
692: FND_MESSAGE.Set_Token('CLASS', p_options_tbl(I).ordered_item);
693: OE_Msg_Pub.Add;
694: l_complete_config := 'FALSE';
695: l_return_status := FND_API.G_RET_STS_ERROR;
696: END IF; -- if no child
697:
698: END IF; -- if qty = 0
699: END IF ; --if original is not model

Line 791: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

787: l_top_bill_sequence_id NUMBER;
788: l_description VARCHAR2(240);
789: l_component_code VARCHAR2(1000);
790: l_result BOOLEAN;
791: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
792: l_valid_config VARCHAR2(10) := 'TRUE';
793:
794: CURSOR MUTUALLY_EXCLUSIVE_OPTIONS IS
795: SELECT bomexp.description, bomexp.component_code

Line 828: l_return_status := FND_API.G_RET_STS_ERROR;

824: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_EXCLUSIVE_CLASS');
825: FND_MESSAGE.Set_Token('CLASS', bom_rec.description);
826: OE_Msg_Pub.Add;
827: l_valid_config := 'FALSE';
828: l_return_status := FND_API.G_RET_STS_ERROR;
829: END IF;
830:
831: END LOOP;
832:

Line 949: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

945: l_top_bill_sequence_id NUMBER;
946: l_description VARCHAR2(240);
947: l_component_code VARCHAR2(1000);
948: l_result BOOLEAN;
949: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
950: l_complete_config VARCHAR2(10) := 'TRUE';
951:
952: CURSOR MANDATORY_COMPONENTS IS
953: SELECT bomexp.description, bomexp.component_code

Line 1014: l_return_status := FND_API.G_RET_STS_ERROR;

1010: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_MANDATORY_CLASS');
1011: FND_MESSAGE.Set_Token('CLASS', bom_rec.description);
1012: OE_Msg_Pub.Add;
1013: l_complete_config := 'FALSE';
1014: l_return_status := FND_API.G_RET_STS_ERROR;
1015: END IF;
1016:
1017: END LOOP;
1018:

Line 1264: RAISE FND_API.G_EXC_ERROR;

1260:
1261: IF l_debug_level > 0 THEN
1262: oe_debug_pub.add('NO PARENT FOR ' || P_COMPONENT_CODE , 1 ) ;
1263: END IF;
1264: RAISE FND_API.G_EXC_ERROR;
1265:
1266: EXCEPTION
1267: WHEN FND_API.G_EXC_ERROR THEN
1268: IF l_debug_level > 0 THEN

Line 1267: WHEN FND_API.G_EXC_ERROR THEN

1263: END IF;
1264: RAISE FND_API.G_EXC_ERROR;
1265:
1266: EXCEPTION
1267: WHEN FND_API.G_EXC_ERROR THEN
1268: IF l_debug_level > 0 THEN
1269: oe_debug_pub.add('PARENT NOT FOUND , MAY BE CANCELED' , 1 ) ;
1270: END IF;
1271:

Line 1311: RAISE FND_API.G_EXC_ERROR;

1307: FND_MESSAGE.Set_TOKEN('ITEM', l_ordered_item);
1308: FND_MESSAGE.Set_TOKEN
1309: ('LINE', l_line_number || '.'|| l_shipment_number ||'.'|| l_option_number);
1310: OE_MSG_PUB.Add;
1311: RAISE FND_API.G_EXC_ERROR;
1312: END;
1313:
1314: WHEN OTHERS THEN
1315: IF l_debug_level > 0 THEN