APPS.OE_BULK_CONFIG_UTIL dependencies on FND_API

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: OE_BULK_MSG_PUB.Add_Exc_Msg
86: ( G_PKG_NAME
87: , 'Extend_Line_Rec'
88: );
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END Extend_Line_Rec;
91:
92:
93: PROCEDURE Print_Line_Rec

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: OE_BULK_MSG_PUB.Add_Exc_Msg
174: ( G_PKG_NAME
175: , 'Print_Line_Rec'
176: );
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END Print_Line_Rec;
179:
180: PROCEDURE Print_Line_Rec
181: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE )

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

225:
226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Message_From_Cz ') ;
228: END IF;
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: OPEN messages(l_config_header_id, l_config_rev_nbr);
232:
233: LOOP

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265:
266:
267: EXCEPTION
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: IF messages%ISOPEN THEN

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266:
267: EXCEPTION
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: IF messages%ISOPEN THEN
274: CLOSE messages;

Line 272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: IF messages%ISOPEN THEN
274: CLOSE messages;
275: END IF;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: IF messages%ISOPEN THEN
274: CLOSE messages;
275: END IF;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277:
278: IF l_debug_level > 0 THEN
279: OE_Debug_Pub.Add('UNEXPECTED_ERROR IN Message_From_Cz: '|| sqlerrm, 1);
280: END IF;

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282: WHEN OTHERS THEN
283: IF messages%ISOPEN THEN
284: CLOSE messages;
285: END IF;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287:
288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: OE_MSG_PUB.Add_Exc_Msg

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310: IF l_debug_level > 0 THEN
311: OE_Debug_Pub.Add ('entering Get_Config_Effective_Date ', 3);
312: END IF;
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: l_profile := OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE;
317:
318: IF l_profile = '1' OR l_profile IS NULL THEN

Line 347: WHEN FND_API.G_EXC_ERROR THEN

343:
344:
345: EXCEPTION
346:
347: WHEN FND_API.G_EXC_ERROR THEN
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344:
345: EXCEPTION
346:
347: WHEN FND_API.G_EXC_ERROR THEN
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: IF l_debug_level > 0 THEN

Line 350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

346:
347: WHEN FND_API.G_EXC_ERROR THEN
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: IF l_debug_level > 0 THEN
353: OE_Debug_Pub.Add('UNEXPECTED_ERROR IN Get_Config_Effective_Date: '|| sqlerrm, 1);
354: END IF;

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: WHEN FND_API.G_EXC_ERROR THEN
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: IF l_debug_level > 0 THEN
353: OE_Debug_Pub.Add('UNEXPECTED_ERROR IN Get_Config_Effective_Date: '|| sqlerrm, 1);
354: END IF;
355:

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: OE_Debug_Pub.Add('UNEXPECTED_ERROR IN Get_Config_Effective_Date: '|| sqlerrm, 1);
354: END IF;
355:
356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:
359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN
361: OE_MSG_PUB.Add_Exc_Msg

Line 413: := FND_API.G_RET_STS_SUCCESS;

409: l_xml_hdr VARCHAR2(2000):=
410: '';
411: l_dummy VARCHAR2(500) := NULL;
412: l_return_status VARCHAR2(1)
413: := FND_API.G_RET_STS_SUCCESS;
414:
415: l_config_effective_date DATE;
416: l_old_behavior VARCHAR2(1);
417: l_frozen_model_bill VARCHAR2(1);

Line 511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

507: ,x_old_behavior => l_old_behavior
508: ,x_config_effective_date => l_config_effective_date
509: ,x_return_status => l_return_status);
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;

Line 512: RAISE FND_API.G_EXC_ERROR;

508: ,x_config_effective_date => l_config_effective_date
509: ,x_return_status => l_return_status);
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:

Line 513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

509: ,x_return_status => l_return_status);
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517: IF l_old_behavior = 'N' THEN

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517: IF l_old_behavior = 'N' THEN
518: param_value(19) := to_char(l_config_effective_date,

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579: oe_debug_pub.add('LENGTH OF INI MSG:' || LENGTH ( L_XML_HDR ) , 3 );
580: oe_debug_pub.add('EXITING CREATE_HDR_XML' , 3 );
581: END IF;
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 584: x_return_status := FND_API.G_RET_STS_ERROR;

580: oe_debug_pub.add('EXITING CREATE_HDR_XML' , 3 );
581: END IF;
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF l_debug_level > 0 THEN

Line 586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF l_debug_level > 0 THEN
589: oe_debug_pub.add('UNEXPECTED EXCEPTION IN CREATE_HDR_XML '|| SQLERRM , 1 );
590: END IF;

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

583: WHEN FND_API.G_EXC_ERROR THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF l_debug_level > 0 THEN
589: oe_debug_pub.add('UNEXPECTED EXCEPTION IN CREATE_HDR_XML '|| SQLERRM , 1 );
590: END IF;
591:

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

589: oe_debug_pub.add('UNEXPECTED EXCEPTION IN CREATE_HDR_XML '|| SQLERRM , 1 );
590: END IF;
591:
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594:
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: OE_MSG_PUB.Add_Exc_Msg

Line 650: x_return_status := FND_API.G_RET_STS_SUCCESS;

646: IF l_debug_level > 0 THEN
647: oe_debug_pub.add('ENTERING OE_BULK_CONFIG_UTIL.SEND_INPUT_XML' , 1);
648: oe_debug_pub.add('UIMANAGER URL: ' || L_URL , 2 );
649: END IF;
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:
652: l_xml_hdr := p_xml_hdr;
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add('LENGTH OF INI MSG: ' || LENGTH ( L_XML_HDR ) , 2 );

Line 735: RAISE FND_API.G_EXC_ERROR;

731: IF (l_html_pieces.COUNT <= 0) THEN
732: IF l_debug_level > 0 THEN
733: oe_debug_pub.add('HTML_PIECES COUNT IS <= 0' , 2 );
734: END IF;
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737:
738:
739: l_rec_index := l_html_pieces.FIRST;

Line 761: WHEN FND_API.G_EXC_ERROR THEN

757: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.SEND_INPUT_XML' , 1);
758: END IF;
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: x_return_status := FND_API.G_RET_STS_ERROR;
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 762: x_return_status := FND_API.G_RET_STS_ERROR;

758: END IF;
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: x_return_status := FND_API.G_RET_STS_ERROR;
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766:

Line 764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: x_return_status := FND_API.G_RET_STS_ERROR;
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766:
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add('AN UNEXP ERROR RAISED IN SEND_INPUT_XML: '

Line 765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

761: WHEN FND_API.G_EXC_ERROR THEN
762: x_return_status := FND_API.G_RET_STS_ERROR;
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766:
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add('AN UNEXP ERROR RAISED IN SEND_INPUT_XML: '
769: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);

Line 773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

769: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);
770: END IF;
771:
772: WHEN OTHERS THEN
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774:
775: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
776: THEN
777: OE_MSG_PUB.Add_Exc_Msg

Line 843: FND_API.G_RET_STS_SUCCESS;

839: l_valid_config VARCHAR2(10);
840: l_complete_config VARCHAR2(10);
841: l_header_id NUMBER;
842: l_return_status VARCHAR2(1) :=
843: FND_API.G_RET_STS_SUCCESS;
844: l_return_status_del VARCHAR2(1);
845: l_msg VARCHAR2(2000);
846: l_constraint VARCHAR2(16);
847: l_flag VARCHAR2(1) := 'N';

Line 1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1012: p_config_header_id => l_config_header_id,
1013: p_config_rev_nbr => l_config_rev_nbr,
1014: x_return_status => l_return_status);
1015:
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;

Line 1017: RAISE FND_API.G_EXC_ERROR;

1013: p_config_rev_nbr => l_config_rev_nbr,
1014: x_return_status => l_return_status);
1015:
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:

Line 1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1014: x_return_status => l_return_status);
1015:
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:
1022: END IF;

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1015:
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:
1022: END IF;
1023:

Line 1037: IF l_return_status_del = FND_API.G_RET_STS_UNEXP_ERROR THEN

1033: ( p_config_hdr_id => l_config_header_id
1034: ,p_config_rev_nbr => l_config_rev_nbr
1035: ,x_return_status => l_return_status_del);
1036:
1037: IF l_return_status_del = FND_API.G_RET_STS_UNEXP_ERROR THEN
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSE
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;

Line 1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1034: ,p_config_rev_nbr => l_config_rev_nbr
1035: ,x_return_status => l_return_status_del);
1036:
1037: IF l_return_status_del = FND_API.G_RET_STS_UNEXP_ERROR THEN
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSE
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;
1042:

Line 1040: RAISE FND_API.G_EXC_ERROR;

1036:
1037: IF l_return_status_del = FND_API.G_RET_STS_UNEXP_ERROR THEN
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSE
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;
1042:
1043: END IF;
1044:

Line 1059: WHEN FND_API.G_EXC_ERROR THEN

1055: oe_debug_pub.add('EXITING OE_BULK_CONFIG_UTIL.PARSE_OUTPUT_XML' , 1);
1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add('SPC EXIT TAG IS ERROR' , 1);
1063: END IF;

Line 1060: x_return_status := FND_API.G_RET_STS_ERROR;

1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add('SPC EXIT TAG IS ERROR' , 1);
1063: END IF;
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add('SPC EXIT TAG IS ERROR' , 1);
1063: END IF;
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066:
1067: IF l_debug_level > 0 THEN
1068: oe_debug_pub.add('AN UNEXP ERROR RAISED IN Parse_output_xml: '

Line 1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add('SPC EXIT TAG IS ERROR' , 1);
1063: END IF;
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066:
1067: IF l_debug_level > 0 THEN
1068: oe_debug_pub.add('AN UNEXP ERROR RAISED IN Parse_output_xml: '
1069: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);

Line 1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1069: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);
1070: END IF;
1071:
1072: WHEN OTHERS THEN
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074:
1075: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1076: THEN
1077: OE_MSG_PUB.Add_Exc_Msg

Line 1123: RAISE FND_API.G_EXC_ERROR;

1119: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1120: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1121: OE_Order_UTIL.Get_Attribute_Name(l_attribute));
1122: OE_BULK_MSG_PUB.Add('Y','ERROR');
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF p_line_rec.config_header_id(p_line_index) IS NOT NULL AND
1125: p_line_rec.config_rev_nbr(p_line_index) IS NULL
1126: THEN
1127: l_attribute := 'CONFIG_REV_NBR';

Line 1132: RAISE FND_API.G_EXC_ERROR;

1128: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1130: OE_Order_UTIL.Get_Attribute_Name(l_attribute));
1131: OE_BULK_MSG_PUB.Add('Y','ERROR');
1132: RAISE FND_API.G_EXC_ERROR;
1133:
1134: ELSIF p_line_rec.config_header_id(p_line_index) IS NOT NULL AND
1135: p_line_rec.config_rev_nbr(p_line_index) IS NOT NULL AND
1136: p_line_rec.configuration_id(p_line_index) IS NULL AND

Line 1144: RAISE FND_API.G_EXC_ERROR;

1140: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1142: OE_Order_UTIL.Get_Attribute_Name(l_attribute));
1143: OE_BULK_MSG_PUB.Add('Y','ERROR');
1144: RAISE FND_API.G_EXC_ERROR;
1145: END IF;
1146:
1147: IF p_line_rec.config_header_id(p_line_index) IS NOT NULL AND
1148: p_line_rec.config_rev_nbr(p_line_index) IS NOT NULL AND

Line 1157: RAISE FND_API.G_EXC_ERROR;

1153: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1155: OE_Order_UTIL.Get_Attribute_Name(l_attribute));
1156: OE_BULK_MSG_PUB.Add('Y','ERROR');
1157: RAISE FND_API.G_EXC_ERROR;
1158:
1159: END IF;
1160:
1161: ELSE -- Configurator is not used

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1171: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1172: OE_Order_UTIL.Get_Attribute_Name(l_attribute));
1173: OE_BULK_MSG_PUB.Add('Y','ERROR');
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: IF p_line_rec.config_rev_nbr(p_line_index) IS NOT NULL
1178: THEN

Line 1184: RAISE FND_API.G_EXC_ERROR;

1180: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1181: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1182: OE_Order_UTIL.Get_Attribute_Name(l_attribute));
1183: OE_BULK_MSG_PUB.Add('Y','ERROR');
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186:
1187: IF p_line_rec.configuration_id(p_line_index) IS NOT NULL
1188: THEN

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1192: OE_Order_UTIL.Get_Attribute_Name(l_attribute));
1193: OE_BULK_MSG_PUB.Add('Y','ERROR');
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: END IF; -- Use configurator
1198:

Line 1204: WHEN FND_API.G_EXC_ERROR THEN

1200: oe_debug_pub.add( 'EXITING OE_BULK_CONFIG_UTIL.Validate_Config_Attributes ') ;
1201: END IF;
1202:
1203: EXCEPTION
1204: WHEN FND_API.G_EXC_ERROR THEN
1205: p_line_rec.lock_control(p_line_index) := -99;
1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add('AN EXC ERROR RAISED IN OE_BULK_CONFIG_UTIL.Validate_Config_Attributes', 1);
1208: END IF;

Line 1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add('AN EXC ERROR RAISED IN OE_BULK_CONFIG_UTIL.Validate_Config_Attributes', 1);
1208: END IF;
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: IF l_debug_level > 0 THEN
1212: oe_debug_pub.add('AN UNEXP ERROR RAISED IN Validate_Config_Attributes: '
1213: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);
1214: END IF;

Line 1307: WHEN FND_API.G_EXC_ERROR THEN

1303: END IF;
1304:
1305: EXCEPTION
1306:
1307: WHEN FND_API.G_EXC_ERROR THEN
1308: p_line_rec.lock_control(p_index) := -99;
1309: IF l_debug_level > 0 THEN
1310: oe_debug_pub.add('AN EXC ERROR RAISED IN Load_Item_Attributes', 1);
1311: END IF;

Line 1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1308: p_line_rec.lock_control(p_index) := -99;
1309: IF l_debug_level > 0 THEN
1310: oe_debug_pub.add('AN EXC ERROR RAISED IN Load_Item_Attributes', 1);
1311: END IF;
1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1313: IF l_debug_level > 0 THEN
1314: oe_debug_pub.add('AN UNEXP ERROR RAISED IN Load_Item_Attributes: '
1315: || SUBSTR ( SQLERRM , 1 , 100 ) , 1);
1316: END IF;

Line 1352: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;

1348: l_config_header_id NUMBER := p_line_rec.config_header_id(p_line_index) ;
1349: l_config_rev_nbr NUMBER := p_line_rec.config_rev_nbr(p_line_index) ;
1350: l_valid_config VARCHAR2(10):= 'true';
1351: l_complete_config VARCHAR2(10):= 'true';
1352: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;
1353: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;
1354: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;
1355: l_msg_count NUMBER;
1356: l_msg_data VARCHAR2(2000);

Line 1353: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;

1349: l_config_rev_nbr NUMBER := p_line_rec.config_rev_nbr(p_line_index) ;
1350: l_valid_config VARCHAR2(10):= 'true';
1351: l_complete_config VARCHAR2(10):= 'true';
1352: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;
1353: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;
1354: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;
1355: l_msg_count NUMBER;
1356: l_msg_data VARCHAR2(2000);
1357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1354: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;

1350: l_valid_config VARCHAR2(10):= 'true';
1351: l_complete_config VARCHAR2(10):= 'true';
1352: l_exists_flag VARCHAR2(1) := FND_API.G_TRUE;
1353: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;
1354: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;
1355: l_msg_count NUMBER;
1356: l_msg_data VARCHAR2(2000);
1357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1358:

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

1353: l_complete_flag VARCHAR2(1) := FND_API.G_TRUE;
1354: l_valid_flag VARCHAR2(1) := FND_API.G_TRUE;
1355: l_msg_count NUMBER;
1356: l_msg_data VARCHAR2(2000);
1357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1358:
1359: l_xml_message LONG := NULL;
1360: l_xml_hdr VARCHAR2(2000);
1361:

Line 1429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1425: oe_debug_pub.add (' Message Count :'|| l_msg_count,2);
1426: oe_debug_pub.add (' Message Data :'|| l_msg_data,2);
1427: END IF;
1428:
1429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1432: RAISE FND_API.G_EXC_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1426: oe_debug_pub.add (' Message Data :'|| l_msg_data,2);
1427: END IF;
1428:
1429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1432: RAISE FND_API.G_EXC_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1434: IF l_exists_flag = FND_API.G_FALSE THEN

Line 1431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1427: END IF;
1428:
1429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1432: RAISE FND_API.G_EXC_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1434: IF l_exists_flag = FND_API.G_FALSE THEN
1435: IF l_debug_level > 0 THEN

Line 1432: RAISE FND_API.G_EXC_ERROR;

1428:
1429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1432: RAISE FND_API.G_EXC_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1434: IF l_exists_flag = FND_API.G_FALSE THEN
1435: IF l_debug_level > 0 THEN
1436: oe_debug_pub.add('Configuration Does not Exist '|| l_msg_data,2);

Line 1433: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1432: RAISE FND_API.G_EXC_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1434: IF l_exists_flag = FND_API.G_FALSE THEN
1435: IF l_debug_level > 0 THEN
1436: oe_debug_pub.add('Configuration Does not Exist '|| l_msg_data,2);
1437: END IF;

Line 1434: IF l_exists_flag = FND_API.G_FALSE THEN

1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1432: RAISE FND_API.G_EXC_ERROR;
1433: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1434: IF l_exists_flag = FND_API.G_FALSE THEN
1435: IF l_debug_level > 0 THEN
1436: oe_debug_pub.add('Configuration Does not Exist '|| l_msg_data,2);
1437: END IF;
1438: RAISE FND_API.G_EXC_ERROR;

Line 1438: RAISE FND_API.G_EXC_ERROR;

1434: IF l_exists_flag = FND_API.G_FALSE THEN
1435: IF l_debug_level > 0 THEN
1436: oe_debug_pub.add('Configuration Does not Exist '|| l_msg_data,2);
1437: END IF;
1438: RAISE FND_API.G_EXC_ERROR;
1439: ELSE
1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.add (' Configuration Exists ',2);
1442: END IF;

Line 1444: IF l_valid_flag = FND_API.G_FALSE THEN

1440: IF l_debug_level > 0 THEN
1441: oe_debug_pub.add (' Configuration Exists ',2);
1442: END IF;
1443:
1444: IF l_valid_flag = FND_API.G_FALSE THEN
1445: l_valid_config := 'FALSE';
1446: ELSE
1447: l_valid_config := 'TRUE';
1448: END IF;

Line 1450: IF l_complete_flag = FND_API.G_FALSE THEN

1446: ELSE
1447: l_valid_config := 'TRUE';
1448: END IF;
1449:
1450: IF l_complete_flag = FND_API.G_FALSE THEN
1451: l_complete_config := 'FALSE';
1452: ELSE
1453: IF l_debug_level > 0 THEN
1454: oe_debug_pub.add('Configuration Exists, valid and Complete ',2);

Line 1473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1469: p_config_header_id => l_config_header_id,
1470: p_config_rev_nbr => l_config_rev_nbr,
1471: x_return_status => l_return_status);
1472:
1473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;

Line 1474: RAISE FND_API.G_EXC_ERROR;

1470: p_config_rev_nbr => l_config_rev_nbr,
1471: x_return_status => l_return_status);
1472:
1473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;
1478:

Line 1475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1471: x_return_status => l_return_status);
1472:
1473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;
1478:
1479:

Line 1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1472:
1473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;
1478:
1479:
1480: ELSE -- call batch val

Line 1490: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1486: p_line_index => p_line_index,
1487: x_xml_hdr => l_xml_hdr,
1488: x_return_status => l_return_status);
1489:
1490: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;

Line 1491: RAISE FND_API.G_EXC_ERROR;

1487: x_xml_hdr => l_xml_hdr,
1488: x_return_status => l_return_status);
1489:
1490: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495:

Line 1492: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1488: x_return_status => l_return_status);
1489:
1490: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495:
1496: IF l_debug_level > 0 THEN

Line 1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1489:
1490: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495:
1496: IF l_debug_level > 0 THEN
1497: oe_debug_pub.add('CALLING SEND_INPUT_XML' , 2 );

Line 1514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1510: oe_debug_pub.add
1511: ('AFTER CALLING SEND_INPUT_XML: '||L_RETURN_STATUS , 2 );
1512: END IF;
1513:
1514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;

Line 1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1511: ('AFTER CALLING SEND_INPUT_XML: '||L_RETURN_STATUS , 2 );
1512: END IF;
1513:
1514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:

Line 1516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1512: END IF;
1513:
1514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:
1520: l_xml_message := UPPER(l_xml_message);

Line 1517: RAISE FND_API.G_EXC_ERROR;

1513:
1514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:
1520: l_xml_message := UPPER(l_xml_message);
1521:

Line 1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1537: IF l_debug_level > 0 THEN
1538: oe_debug_pub.add('AFTER CALLING PARSE_OUTPUT_XML: '||L_RETURN_STATUS , 2 );
1539: END IF;
1540:
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;

Line 1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1538: oe_debug_pub.add('AFTER CALLING PARSE_OUTPUT_XML: '||L_RETURN_STATUS , 2 );
1539: END IF;
1540:
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:

Line 1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1539: END IF;
1540:
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:
1547: IF (l_valid_config = 'FALSE' OR l_complete_config = 'FALSE') THEN

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540:
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:
1547: IF (l_valid_config = 'FALSE' OR l_complete_config = 'FALSE') THEN
1548: IF l_debug_level > 0 THEN

Line 1551: RAISE FND_API.G_EXC_ERROR;

1547: IF (l_valid_config = 'FALSE' OR l_complete_config = 'FALSE') THEN
1548: IF l_debug_level > 0 THEN
1549: oe_debug_pub.add('ERROR CONFIG' , 2 );
1550: END IF;
1551: RAISE FND_API.G_EXC_ERROR;
1552:
1553: END IF;
1554:
1555: -- As a part of the Batch Validation CRN can change for a configuration.

Line 1581: WHEN FND_API.G_EXC_ERROR THEN

1577:
1578:
1579: EXCEPTION
1580:
1581: WHEN FND_API.G_EXC_ERROR THEN
1582: IF l_debug_level > 0 THEN
1583: oe_debug_pub.add('AN EXC ERROR RAISED IN Validate_Configuration', 1);
1584: END IF;
1585: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');

Line 1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1595: OE_BULK_MSG_PUB.Add_Exc_Msg
1596: ( G_PKG_NAME,
1597: 'Validate_Configuration'
1598: );
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600:
1601: END Validate_Configuration;
1602:
1603:

Line 2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2095: OE_BULK_MSG_PUB.Add_Exc_Msg
2096: ( G_PKG_NAME,
2097: 'Pre_Process_Configurator'
2098: );
2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2100:
2101: END Pre_Process_Configurator;
2102:
2103:

Line 2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2406: x_return_status => l_return_status
2407: );
2408:
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: IF l_debug_level > 0 THEN
2412: oe_debug_pub.add( 'ERROR in OE_Config_UTIL.Explode' ) ;
2413: END IF;
2414: l_line_rec.lock_control(I) := -99;

Line 2415: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2411: IF l_debug_level > 0 THEN
2412: oe_debug_pub.add( 'ERROR in OE_Config_UTIL.Explode' ) ;
2413: END IF;
2414: l_line_rec.lock_control(I) := -99;
2415: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2416: IF l_debug_level > 0 THEN
2417: oe_debug_pub.add( 'UNEXPECTED ERROR in OE_Config_UTIL.Explode' ) ;
2418: END IF;
2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2415: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2416: IF l_debug_level > 0 THEN
2417: oe_debug_pub.add( 'UNEXPECTED ERROR in OE_Config_UTIL.Explode' ) ;
2418: END IF;
2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2420: END IF;
2421:
2422: -- Get the bill_sequence_id for model line.
2423: SELECT bill_sequence_id,

Line 2549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2545: IF l_debug_level > 0 THEN
2546: oe_debug_pub.add('SELECT COMP_CODE FAILED , OTHERS ' , 1);
2547: oe_debug_pub.add('ITEM: '|| L_LINE_REC.INVENTORY_ITEM_ID(I) , 1);
2548: END IF;
2549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2550: END;
2551:
2552: END IF; -- IF Model Line
2553:

Line 2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2948: OE_BULK_MSG_PUB.Add_Exc_Msg
2949: ( G_PKG_NAME,
2950: 'Pre_Process_Bom'
2951: );
2952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2953:
2954: END Pre_Process_Bom;
2955:
2956:

Line 3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3124: OE_BULK_MSG_PUB.Add_Exc_Msg
3125: ( G_PKG_NAME,
3126: 'Pre_Process'
3127: );
3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3129:
3130: END Pre_Process;
3131:
3132:

Line 3164: x_return_status := fnd_api.g_ret_sts_success;

3160: oe_debug_pub.add( 'ENTERING OE_BULK_CONFIG_UTIL.Delete_Configurations ') ;
3161: END IF;
3162:
3163: -- initialize return status to success
3164: x_return_status := fnd_api.g_ret_sts_success;
3165:
3166: FOR I IN 1..P_ERROR_REC.header_id.COUNT LOOP
3167:
3168: FOR l_delete_rec IN c_configs(P_ERROR_REC.orig_sys_document_ref(I),

Line 3184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3180: ( p_config_hdr_id => l_delete_rec.config_header_id
3181: ,p_config_rev_nbr => l_delete_rec.config_rev_nbr
3182: ,x_return_status => x_return_status);
3183:
3184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3186: ELSE
3187: RAISE FND_API.G_EXC_ERROR;
3188: END IF;

Line 3185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3181: ,p_config_rev_nbr => l_delete_rec.config_rev_nbr
3182: ,x_return_status => x_return_status);
3183:
3184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3186: ELSE
3187: RAISE FND_API.G_EXC_ERROR;
3188: END IF;
3189:

Line 3187: RAISE FND_API.G_EXC_ERROR;

3183:
3184: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3186: ELSE
3187: RAISE FND_API.G_EXC_ERROR;
3188: END IF;
3189:
3190: IF l_debug_level > 0 THEN
3191: oe_debug_pub.add( 'CONFIG DELETED WITH SUCCESS' ) ;

Line 3210: x_return_status := FND_API.G_RET_STS_ERROR;

3206: OE_BULK_Msg_Pub.Add_text(l_error_message);
3207: IF l_debug_level > 0 THEN
3208: oe_debug_pub.add('Error from CZ delete: ' ||l_error_message ) ;
3209: END IF;
3210: x_return_status := FND_API.G_RET_STS_ERROR;
3211: ELSE
3212: x_return_status := FND_API.G_RET_STS_SUCCESS;
3213: IF l_debug_level > 0 THEN
3214: oe_debug_pub.add( 'CONFIG DELETED WITH SUCCESS' ) ;

Line 3212: x_return_status := FND_API.G_RET_STS_SUCCESS;

3208: oe_debug_pub.add('Error from CZ delete: ' ||l_error_message ) ;
3209: END IF;
3210: x_return_status := FND_API.G_RET_STS_ERROR;
3211: ELSE
3212: x_return_status := FND_API.G_RET_STS_SUCCESS;
3213: IF l_debug_level > 0 THEN
3214: oe_debug_pub.add( 'CONFIG DELETED WITH SUCCESS' ) ;
3215: END IF;
3216:

Line 3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3241: ( G_PKG_NAME,
3242: 'Delete_Configurations'
3243: );
3244:
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246:
3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3248:
3249: END Delete_Configurations;

Line 3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3243: );
3244:
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246:
3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3248:
3249: END Delete_Configurations;
3250:
3251: