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

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

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

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 193: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 207: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 222: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 251: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

289: (p_options_tbl IN VALIDATE_OPTIONS_TBL_TYPE
290: ,p_top_model_line_id IN NUMBER
291: ,x_return_status OUT NOCOPY VARCHAR2)
292: IS
293: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
294: l_parent_qty NUMBER;
295: I NUMBER;
296: l_parent_exists BOOLEAN := FALSE;
297: l_ordered_item VARCHAR2(2000);

Line 358: RAISE FND_API.G_EXC_ERROR;

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

Line 378: RAISE FND_API.G_EXC_ERROR;

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

Line 504: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 605: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

644: ,x_return_status OUT NOCOPY VARCHAR2)
645: IS
646: I NUMBER;
647: l_no_child BOOLEAN;
648: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
649: l_complete_config VARCHAR2(10) := 'TRUE';
650: --
651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
652: --

Line 684: l_return_status := FND_API.G_RET_STS_ERROR;

680: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_CLASS_NO_OPTION');
681: FND_MESSAGE.Set_Token('CLASS', p_options_tbl(I).ordered_item);
682: OE_Msg_Pub.Add;
683: l_complete_config := 'FALSE';
684: l_return_status := FND_API.G_RET_STS_ERROR;
685: END IF; -- if no child
686:
687: END IF; -- if qty = 0
688:

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

776: l_top_bill_sequence_id NUMBER;
777: l_description VARCHAR2(240);
778: l_component_code VARCHAR2(1000);
779: l_result BOOLEAN;
780: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
781: l_valid_config VARCHAR2(10) := 'TRUE';
782:
783: CURSOR MUTUALLY_EXCLUSIVE_OPTIONS IS
784: SELECT /*+ INDEX(BOMEXP BOM_EXPLOSIONS_N1) */

Line 818: l_return_status := FND_API.G_RET_STS_ERROR;

814: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_EXCLUSIVE_CLASS');
815: FND_MESSAGE.Set_Token('CLASS', bom_rec.description);
816: OE_Msg_Pub.Add;
817: l_valid_config := 'FALSE';
818: l_return_status := FND_API.G_RET_STS_ERROR;
819: END IF;
820:
821: END LOOP;
822:

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

935: l_top_bill_sequence_id NUMBER;
936: l_description VARCHAR2(240);
937: l_component_code VARCHAR2(1000);
938: l_result BOOLEAN;
939: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
940: l_complete_config VARCHAR2(10) := 'TRUE';
941:
942: CURSOR MANDATORY_COMPONENTS IS
943: SELECT /*+ INDEX(BOMEXP BOM_EXPLOSIONS_N1) */

Line 1005: l_return_status := FND_API.G_RET_STS_ERROR;

1001: FND_MESSAGE.Set_Name('ONT', 'OE_VAL_CONFIG_MANDATORY_CLASS');
1002: FND_MESSAGE.Set_Token('CLASS', bom_rec.description);
1003: OE_Msg_Pub.Add;
1004: l_complete_config := 'FALSE';
1005: l_return_status := FND_API.G_RET_STS_ERROR;
1006: END IF;
1007:
1008: END LOOP;
1009:

Line 1255: RAISE FND_API.G_EXC_ERROR;

1251:
1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add('NO PARENT FOR ' || P_COMPONENT_CODE , 1 ) ;
1254: END IF;
1255: RAISE FND_API.G_EXC_ERROR;
1256:
1257: EXCEPTION
1258: WHEN FND_API.G_EXC_ERROR THEN
1259: IF l_debug_level > 0 THEN

Line 1258: WHEN FND_API.G_EXC_ERROR THEN

1254: END IF;
1255: RAISE FND_API.G_EXC_ERROR;
1256:
1257: EXCEPTION
1258: WHEN FND_API.G_EXC_ERROR THEN
1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add('PARENT NOT FOUND , MAY BE CANCELED' , 1 ) ;
1261: END IF;
1262:

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: FND_MESSAGE.Set_TOKEN('ITEM', l_ordered_item);
1299: FND_MESSAGE.Set_TOKEN
1300: ('LINE', l_line_number || '.'|| l_shipment_number ||'.'|| l_option_number);
1301: OE_MSG_PUB.Add;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END;
1304:
1305: WHEN OTHERS THEN
1306: IF l_debug_level > 0 THEN