DBA Data[Home] [Help]

APPS.OE_SPLIT_UTIL dependencies on FND_API

Line 44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

40: WHEN OTHERS THEN
41: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
42: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , 'Create_Line_Set_For_Options' );
43: END IF;
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END Create_Line_Set_For_Options;
46:
47:
48: Procedure Update_Drop_Ship_Source(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type) IS

Line 109: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;

105: l_ser_line_tbl(l_service_count).line_id := ser_rec.line_id;
106: oe_line_util.query_row(ser_rec.line_id,x_line_rec => l_ser_line_rec);
107: l_ser_line_tbl(l_service_count) := l_ser_line_rec;
108: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_CREATE THEN
109: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;
110: l_ser_line_tbl(l_service_count).split_from_line_id := l_ser_line_rec.split_from_line_id;
111: END IF;
112: IF p_line_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE THEN
113: l_ser_line_tbl(l_service_count).split_action_code := 'SPLIT';

Line 149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

145: WHEN OTHERS THEN
146: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
147: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Get_Non_Service_line' );
148: END IF;
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END Get_Nonprop_Service_Lines;
151:
152: /* This is duplicated here since defaulting goes by g_line_rec%view and
153: has technical dificulties to get the currect shipment number */

Line 166: OR p_line_rec.top_model_line_id = FND_API.G_MISS_NUM THEN

162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE: FUNCTION GET_SHIPMENT_NUMBER' ) ;
164: END IF;
165: IF p_line_rec.top_model_line_id IS NULL
166: OR p_line_rec.top_model_line_id = FND_API.G_MISS_NUM THEN
167: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)
168: INTO l_ship_number
169: FROM OE_ORDER_LINES
170: WHERE HEADER_ID = p_line_rec.header_id

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: WHEN OTHERS THEN
190: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
191: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Get_Shipment_Number' );
192: END IF;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END Get_Shipment_Number;
195:
196: FUNCTION Check_Complete_Shipment(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
197: p_line_id IN number) RETURN VARCHAR2 IS

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: EXCEPTION WHEN OTHERS THEN
240: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
241: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Check_Complete_Shipment');
242: END IF;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END Check_Complete_Shipment;
245:
246: Procedure Get_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
247: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type,

Line 294: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;

290: l_ser_line_tbl(l_service_count).split_action_code := 'SPLIT';
291: l_service_count := l_service_count + 1;
292: FOR I in 2..g_split_line_tbl.count LOOP
293: l_ser_line_tbl(l_service_count) := l_ser_rec;
294: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;
295: l_ser_line_tbl(l_service_count).split_from_line_id := l_ser_rec.line_id;
296: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_create;
297: g_qry_out_rec := l_ser_line_tbl(l_service_count) ;
298: OE_Split_Util.Default_Attributes(

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: WHEN OTHERS THEN
337: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
338: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Get_Service_line');
339: END IF;
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END Get_Service_lines;
342:
343: Procedure Get_non_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
344: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS

Line 483: l_parent_line.line_id := fnd_api.g_miss_num;

479: l_parent_line.split_from_line_id := l_parent_line.line_id;
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add('Line set id is : '||l_set_id,5) ;
482: END IF;
483: l_parent_line.line_id := fnd_api.g_miss_num;
484: l_parent_line.orig_sys_line_ref :=fnd_api.g_miss_char; -- Bug5207907
485: OE_Split_Util.Default_Attributes
486: (p_x_line_rec => l_parent_line,
487: p_old_line_rec => l_parent_line );

Line 484: l_parent_line.orig_sys_line_ref :=fnd_api.g_miss_char; -- Bug5207907

480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add('Line set id is : '||l_set_id,5) ;
482: END IF;
483: l_parent_line.line_id := fnd_api.g_miss_num;
484: l_parent_line.orig_sys_line_ref :=fnd_api.g_miss_char; -- Bug5207907
485: OE_Split_Util.Default_Attributes
486: (p_x_line_rec => l_parent_line,
487: p_old_line_rec => l_parent_line );
488: IF l_parent_line.line_set_id is null AND l_set_id IS NULL THEN

Line 503: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;

499: l_option_count := l_option_count + 1;
500: l_option_line_tbl(l_option_count) := l_option_line;
501: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
502: l_option_line_tbl(l_option_count).split_by:='SYSTEM';
503: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
504: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
505: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
506: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
507: OE_Split_Util.Default_Attributes

Line 505: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

501: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
502: l_option_line_tbl(l_option_count).split_by:='SYSTEM';
503: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
504: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
505: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
506: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
507: OE_Split_Util.Default_Attributes
508: ( p_x_line_rec => g_qry_out_rec
509: ,p_old_line_rec => l_option_line_tbl(l_option_count)

Line 557: l_parent_line.line_id := fnd_api.g_miss_num;

553: ELSE -- g_max_model
554: l_parent_line.operation := oe_globals.g_opr_create;
555: l_parent_line.split_by := 'SYSTEM';
556: l_parent_line.split_from_line_id := l_parent_line.line_id;
557: l_parent_line.line_id := fnd_api.g_miss_num;
558: l_parent_line.config_header_id := NULL;
559: l_parent_line.config_rev_nbr := NULL;
560: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
561: OE_Split_Util.Default_Attributes

Line 560: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

556: l_parent_line.split_from_line_id := l_parent_line.line_id;
557: l_parent_line.line_id := fnd_api.g_miss_num;
558: l_parent_line.config_header_id := NULL;
559: l_parent_line.config_rev_nbr := NULL;
560: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
561: OE_Split_Util.Default_Attributes
562: (p_x_line_rec => l_parent_line
563: ,p_old_line_rec => l_parent_line
564: );

Line 600: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;

596: p_line_tbl(I).shipped_quantity - g_max_model * l_model_ratio;
597: IF l_option_line.ordered_quantity > 0 THEN
598: l_option_count := l_option_count + 1;
599: l_option_line_tbl(l_option_count) := l_option_line;
600: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
601: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
602: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
603: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
604: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

Line 604: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

600: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
601: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
602: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
603: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
604: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
605: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
606: OE_Split_Util.Default_Attributes
607: ( p_x_line_rec => g_qry_out_rec
608: ,p_old_line_rec => l_option_line_tbl(l_option_count)

Line 651: l_parent_line.line_id := fnd_api.g_miss_num;

647: IF l_parent_line.ordered_quantity <> 0 THEN
648: l_parent_line.operation := oe_globals.g_opr_create;
649: l_parent_line.split_by := 'SYSTEM';
650: l_parent_line.split_from_line_id := l_parent_line.line_id;
651: l_parent_line.line_id := fnd_api.g_miss_num;
652: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
653: OE_Split_Util.Default_Attributes
654: ( p_x_line_rec => l_parent_line
655: , p_old_line_rec => l_parent_line

Line 652: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

648: l_parent_line.operation := oe_globals.g_opr_create;
649: l_parent_line.split_by := 'SYSTEM';
650: l_parent_line.split_from_line_id := l_parent_line.line_id;
651: l_parent_line.line_id := fnd_api.g_miss_num;
652: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
653: OE_Split_Util.Default_Attributes
654: ( p_x_line_rec => l_parent_line
655: , p_old_line_rec => l_parent_line
656: );

Line 698: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;

694: ELSE
695: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
696: l_option_line_tbl(l_option_count) := l_option_line;
697: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
698: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
699: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
700: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
701: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
702: OE_Split_Util.Default_Attributes

Line 700: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

696: l_option_line_tbl(l_option_count) := l_option_line;
697: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
698: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
699: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
700: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
701: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
702: OE_Split_Util.Default_Attributes
703: ( p_x_line_rec => g_qry_out_rec
704: ,p_old_line_rec => l_option_line_tbl(l_option_count)

Line 759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

755: WHEN OTHERS THEN
756: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
757: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Get_Non_Model_Configuration' );
758: END IF;
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END Get_Non_Model_Configuration;
761:
762: Procedure Get_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
763: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS

Line 882: l_parent_line.line_id := fnd_api.g_miss_num;

878: l_parent_line.split_from_line_id := l_parent_line.line_id;
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'LINE SET IS-'||L_SET_ID ) ;
881: END IF;
882: l_parent_line.line_id := fnd_api.g_miss_num;
883: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
884: OE_Split_Util.Default_Attributes
885: (p_x_line_rec => l_parent_line
886: ,p_old_line_rec => l_parent_line );

Line 883: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'LINE SET IS-'||L_SET_ID ) ;
881: END IF;
882: l_parent_line.line_id := fnd_api.g_miss_num;
883: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
884: OE_Split_Util.Default_Attributes
885: (p_x_line_rec => l_parent_line
886: ,p_old_line_rec => l_parent_line );
887: IF l_parent_line.line_set_id is null AND l_set_id IS NULL THEN

Line 902: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;

898: l_model_ratio :=l_option_line.ordered_quantity / l_line_rec.ordered_quantity;
899: l_option_count := l_option_count + 1;
900: l_option_line_tbl(l_option_count) := l_option_line;
901: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
902: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
903: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
904: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
905: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
906: OE_Split_Util.Default_Attributes

Line 904: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

900: l_option_line_tbl(l_option_count) := l_option_line;
901: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
902: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
903: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
904: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
905: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
906: OE_Split_Util.Default_Attributes
907: (p_x_line_rec => g_qry_out_rec
908: ,p_old_line_rec => l_option_line_tbl(l_option_count)

Line 958: l_parent_line.line_id := fnd_api.g_miss_num;

954: IF l_parent_line.ordered_quantity > 0 THEN
955: l_parent_line.operation := oe_globals.g_opr_create;
956: l_parent_line.split_by := 'SYSTEM';
957: l_parent_line.split_from_line_id := l_parent_line.line_id;
958: l_parent_line.line_id := fnd_api.g_miss_num;
959: l_parent_line.config_header_id := NULL;
960: l_parent_line.config_rev_nbr := NULL;
961: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
962: OE_Split_Util.Default_Attributes

Line 961: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

957: l_parent_line.split_from_line_id := l_parent_line.line_id;
958: l_parent_line.line_id := fnd_api.g_miss_num;
959: l_parent_line.config_header_id := NULL;
960: l_parent_line.config_rev_nbr := NULL;
961: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
962: OE_Split_Util.Default_Attributes
963: ( p_x_line_rec => l_parent_line
964: ,p_old_line_rec => l_parent_line );
965: l_rem_shp_top_model_line_id := l_parent_line.line_id;

Line 992: l_parent_line.line_id := fnd_api.g_miss_num;

988: IF l_parent_line.ordered_quantity > 0 THEN
989: l_parent_line.operation := oe_globals.g_opr_create;
990: l_parent_line.split_by := 'SYSTEM';
991: l_parent_line.split_from_line_id := l_parent_line.line_id;
992: l_parent_line.line_id := fnd_api.g_miss_num;
993: OE_Split_Util.Default_Attributes
994: ( p_x_line_rec => l_parent_line
995: ,p_old_line_rec => l_parent_line
996: );

Line 1033: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;

1029: --bug 4590044 :create shipped remanant option line only when ordered_qty > 0
1030: IF ( p_line_tbl(I).shipped_quantity-g_max_model * l_model_ratio >0) THEN
1031: l_option_count := l_option_count + 1;
1032: l_option_line_tbl(l_option_count) := l_option_line;
1033: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1034: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1035: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1036: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1037: OE_Split_Util.Default_Attributes

Line 1105: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;

1101: l_option_line_tbl(l_option_count).top_model_line_id := l_top_model_line_id;
1102: ELSE
1103: l_option_line_tbl(l_option_count) := l_option_line;
1104: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1105: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1106: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1107: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1108: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1109: OE_Split_Util.Default_Attributes

Line 1107: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

1103: l_option_line_tbl(l_option_count) := l_option_line;
1104: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1105: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1106: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1107: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1108: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1109: OE_Split_Util.Default_Attributes
1110: ( p_x_line_rec => g_qry_out_rec
1111: , p_old_line_rec => l_option_line_tbl(l_option_count)

Line 1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1156: ( G_PKG_NAME ,
1157: 'Get_Model_Configuration'
1158: );
1159: END IF;
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END Get_Model_Configuration;
1162:
1163: Procedure Cascade_Proportional_Split(p_line_tbl IN OE_ORDER_PUB.Line_tbl_type,
1164: Parent_ordered_quantity NUMBER,

Line 1264: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;

1260: l_split_line_tbl(l_split_count).line_id := l_option_line_tbl(l_option_count).line_id;
1261: l_option_count := l_option_count + 1;
1262: FOR I IN 2 .. g_split_line_tbl.count LOOP
1263: l_option_line_tbl(l_option_count) := l_option_line;
1264: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1265: l_option_line_tbl(l_option_count).ordered_quantity := g_split_line_tbl(I).quantity * l_model_ratio;
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'RATIO 3 : ' || G_SPLIT_LINE_TBL ( I ) .QUANTITY , 1 ) ;
1268: END IF;

Line 1273: g_qry_out_rec.orig_sys_line_ref :=fnd_api.g_miss_char; --bug5207907

1269: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1270: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1271: l_option_line_tbl(l_option_count).split_by := p_line_tbl(p_index).split_by;
1272: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1273: g_qry_out_rec.orig_sys_line_ref :=fnd_api.g_miss_char; --bug5207907
1274: OE_Split_Util.Default_Attributes ( p_x_line_rec => g_qry_out_rec
1275: ,p_old_line_rec => l_option_line_tbl(l_option_count));
1276: l_option_line_tbl(l_option_count) := g_qry_out_rec;
1277: l_option_line_tbl(l_option_count).top_model_line_id := g_split_line_tbl(I).line_id;

Line 1300: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id := FND_API.G_MISS_NUM;

1296: END IF;
1297: FOR SCRD_REC IN 1..l_line_Scredit_tbl.count LOOP
1298: l_scredit_count := l_scredit_count + 1;
1299: l_line_scredit_temp_tbl(l_scredit_count) := l_line_scredit_tbl(SCRD_REC);
1300: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id := FND_API.G_MISS_NUM;
1301: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;
1302: l_line_scredit_temp_tbl(l_scredit_count).line_id := l_option_line_tbl(l_option_count).line_id;
1303: END LOOP;
1304: IF l_debug_level > 0 THEN

Line 1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1367: END IF;
1368: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1369: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Cascade_Proportional_Split');
1370: END IF;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372:
1373: End Cascade_Proportional_Split;
1374:
1375: Procedure Default_Attributes

Line 1409: p_x_line_rec.split_from_line_id <> FND_API.G_MISS_NUM) AND

1405: oe_debug_pub.add( 'SPLITLINEID:'||P_X_LINE_REC.SPLIT_FROM_LINE_ID ) ;
1406: END IF;
1407: IF (p_x_line_rec.operation = oe_globals.g_opr_create and
1408: (p_x_line_rec.split_from_line_id IS NOT NULL AND
1409: p_x_line_rec.split_from_line_id <> FND_API.G_MISS_NUM) AND
1410: (p_x_line_rec.line_id IS NULL OR
1411: p_x_line_rec.line_id = FND_API.G_MISS_NUM)) THEN
1412: IF l_debug_level > 0 THEN
1413: oe_debug_pub.add( 'ENTER INTO DEFAULTING SPLITS' ) ;

Line 1411: p_x_line_rec.line_id = FND_API.G_MISS_NUM)) THEN

1407: IF (p_x_line_rec.operation = oe_globals.g_opr_create and
1408: (p_x_line_rec.split_from_line_id IS NOT NULL AND
1409: p_x_line_rec.split_from_line_id <> FND_API.G_MISS_NUM) AND
1410: (p_x_line_rec.line_id IS NULL OR
1411: p_x_line_rec.line_id = FND_API.G_MISS_NUM)) THEN
1412: IF l_debug_level > 0 THEN
1413: oe_debug_pub.add( 'ENTER INTO DEFAULTING SPLITS' ) ;
1414: END IF;
1415: oe_line_util.query_row(p_line_id => p_x_line_rec.split_from_line_id,

Line 1431: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN

1427: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1428:
1429: --Changed for bug 4302022
1430: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1431: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1432:
1433: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1434: ELSE
1435: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

Line 1445: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN

1441: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1442: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1443: --Changed for bug 4302022
1444: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1445: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1446:
1447: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1448: ELSE
1449: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

Line 1516: l_line_rec.line_id <> FND_API.G_MISS_NUM AND

1512: oe_line_util.convert_miss_to_null(p_x_line_rec => l_line_rec);
1513: l_line_rec.operation := oe_globals.g_opr_create;
1514: p_x_line_rec := l_line_rec;
1515: ELSIF (l_line_rec.line_id IS NOT NULL AND
1516: l_line_rec.line_id <> FND_API.G_MISS_NUM AND
1517: l_line_rec.operation = oe_globals.g_opr_create) THEN
1518: IF l_debug_level > 0 THEN
1519: oe_debug_pub.add( 'LINE ID :'||P_X_LINE_REC.LINE_ID ) ;
1520: END IF;

Line 1541: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN

1537: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1538: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1539: --Changed for bug 4302022
1540: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1541: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1542:
1543: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1544: ELSE
1545: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

Line 1554: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN

1550: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1551: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1552: --Changed for bug 4302022
1553: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1554: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1555:
1556: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1557: ELSE
1558: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

Line 1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1570: ( G_PKG_NAME ,
1571: 'Split_line'
1572: );
1573: END IF;
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: END Default_Attributes;
1576:
1577: PROCEDURE Split_Line
1578: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1587: WHEN OTHERS THEN
1588: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1589: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'Split_line');
1590: END IF;
1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1592: END Split_Line;
1593:
1594: Procedure Check_split_Course(p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_type,
1595: p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_tbl_type,

Line 1665: RAISE FND_API.G_EXC_ERROR;

1661: OE_MSG_PUB.ADD;
1662: IF l_debug_level > 0 THEN
1663: oe_debug_pub.add( 'SPLIT- NOT ALLOWED TO UPDATE WITH QUANTITY ZERO' ) ;
1664: END IF;
1665: RAISE FND_API.G_EXC_ERROR;
1666: END IF;
1667: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,
1668: x_line_rec => l_line_rec);
1669: IF l_debug_level > 0

Line 1689: RAISE FND_API.G_EXC_ERROR;

1685: OE_MSG_PUB.ADD;
1686: IF l_debug_level > 0 THEN
1687: oe_debug_pub.add( 'SPLIT- NOT ALLOWED THIS ITEMTYPE' ) ;
1688: END IF;
1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691: END IF;
1692: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,
1693: x_line_rec => l_line_rec);

Line 1700: --l_line_tbl(I).line_set_id <> FND_API.G_MISS_NUM) THEN

1696: g_split_line_tbl(l_split_count).line_id := l_line_tbl(I).line_id;
1697: g_split_line_tbl(l_split_count).quantity := l_line_tbl(I).ordered_quantity;
1698: IF ( l_line_rec.line_set_id IS NULL )
1699: THEN
1700: --l_line_tbl(I).line_set_id <> FND_API.G_MISS_NUM) THEN
1701: IF l_debug_level > 0 THEN
1702: oe_debug_pub.add( 'ENTER CREATE LINE SET:' ) ;
1703: END IF;
1704: Oe_Set_Util.Create_Line_Set(p_x_line_rec => l_line_rec);

Line 1748: RAISE FND_API.G_EXC_ERROR;

1744: OE_MSG_PUB.ADD;
1745: IF l_debug_level > 0 THEN
1746: oe_debug_pub.add( 'SPLIT- NOT ALLOWED TO CREATE WITH QUANTITY ZERO' ) ;
1747: END IF;
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750: g_qry_out_rec := l_line_tbl(J);
1751: OE_Split_Util.Default_Attributes (p_x_line_rec => g_qry_out_rec
1752: ,p_old_line_rec => l_line_tbl(J));

Line 1769: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id:= FND_API.G_MISS_NUM;

1765: -- Copy Sales Credits for the new line
1766: FOR SCRD_REC IN 1..L_line_Scredit_tbl.count LOOP
1767: l_scredit_count := l_scredit_count + 1;
1768: l_line_scredit_temp_tbl(l_scredit_count):= L_line_scredit_tbl(SCRD_REC);
1769: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id:= FND_API.G_MISS_NUM;
1770: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;
1771: l_line_scredit_temp_tbl(l_scredit_count).line_id := l_line_tbl(J).line_id;
1772: END LOOP;
1773: END IF; -- IF split from line id and operation create

Line 1791: RAISE FND_API.G_EXC_ERROR;

1787: OE_MSG_PUB.ADD;
1788: IF l_debug_level > 0 THEN
1789: oe_debug_pub.add( 'RAJ:SPLIT-QUNATITES NOT EQUAL' ) ;
1790: END IF;
1791: RAISE FND_API.G_EXC_ERROR;
1792: END IF;
1793: l_child_quantity := 0;
1794: -- Call service API to get service Lines
1795: Get_Service_Lines(p_line_tbl => l_line_tbl,

Line 1846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1842: OE_SPLIT_UTIL.G_SPLIT_ACTION := TRUE;
1843: /* OE_ORDER_SCH_UTIL.Split_Scheduling(p_line_tbl => l_sch_tbl,
1844: x_line_tbl => l_sch_tbl,
1845: x_return_status => l_return_status);
1846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1847: oe_debug_pub.add('Into split scheduling unexpected failure');
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1850: oe_debug_pub.add('Into split scheduling expected failure');

Line 1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1844: x_line_tbl => l_sch_tbl,
1845: x_return_status => l_return_status);
1846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1847: oe_debug_pub.add('Into split scheduling unexpected failure');
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1850: oe_debug_pub.add('Into split scheduling expected failure');
1851: RAISE FND_API.G_EXC_ERROR;
1852: END IF; */

Line 1849: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1845: x_return_status => l_return_status);
1846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1847: oe_debug_pub.add('Into split scheduling unexpected failure');
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1850: oe_debug_pub.add('Into split scheduling expected failure');
1851: RAISE FND_API.G_EXC_ERROR;
1852: END IF; */
1853: -- Delete split line tbl for this line

Line 1851: RAISE FND_API.G_EXC_ERROR;

1847: oe_debug_pub.add('Into split scheduling unexpected failure');
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1850: oe_debug_pub.add('Into split scheduling expected failure');
1851: RAISE FND_API.G_EXC_ERROR;
1852: END IF; */
1853: -- Delete split line tbl for this line
1854: g_split_line_tbl.delete;
1855: l_split_count := 0;

Line 1911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1907: ( G_PKG_NAME ,
1908: 'Check_Split_Course'
1909: );
1910: END IF;
1911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1912: END Check_Split_Course;
1913:
1914: Procedure Cascade_non_proportional_Split(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
1915: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS

Line 1945: x_return_status := FND_API.G_RET_STS_SUCCESS;

1941: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1942: --
1943: BEGIN
1944:
1945: x_return_status := FND_API.G_RET_STS_SUCCESS;
1946: IF l_debug_level > 0 THEN
1947: OE_DEBUG_PUB.add('Entering Cascade_Non_Proportional_split() ',1);
1948: OE_DEBUG_PUB.add('Table count : '||p_x_line_tbl.count,5) ;
1949: END IF;

Line 2084: l_line_scredit_tbl(l_scredit_count).sales_credit_id := fnd_api.g_miss_num;

2080: FOR Scr IN 1 .. l_line_scredit_temp_tbl.count LOOP
2081: l_line_scredit_tbl(l_scredit_count) := l_line_scredit_temp_tbl(Scr);
2082: l_line_scredit_tbl(l_scredit_count).operation := OE_GLOBALS.G_OPR_CREATE;
2083: l_line_scredit_tbl(l_scredit_count).line_id := l_line_tbl(I).line_id;
2084: l_line_scredit_tbl(l_scredit_count).sales_credit_id := fnd_api.g_miss_num;
2085: END LOOP;
2086: END IF;
2087: END LOOP;
2088: -- get Service Lines

Line 2108: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

2104: IF l_debug_level > 0 THEN
2105: oe_debug_pub.add('Before calling process order in splits',1) ;
2106: END IF;
2107: oe_order_pvt.Lines
2108: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2109: , p_control_rec => l_control_rec
2110: , p_x_line_tbl => p_x_line_tbl
2111: , p_x_old_line_tbl => l_old_line_tbl
2112: , x_return_status => l_return_status

Line 2114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2110: , p_x_line_tbl => p_x_line_tbl
2111: , p_x_old_line_tbl => l_old_line_tbl
2112: , x_return_status => l_return_status
2113: );
2114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2115: IF l_debug_level > 0 THEN
2116: oe_debug_pub.add('Split Line: Process order returns unexpected error : '||sqlerrm,1) ;
2117: END IF;
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2115: IF l_debug_level > 0 THEN
2116: oe_debug_pub.add('Split Line: Process order returns unexpected error : '||sqlerrm,1) ;
2117: END IF;
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2120: IF l_debug_level > 0 THEN
2121: oe_debug_pub.add('Split Line: Process order returns execution error : '||sqlerrm,1) ;
2122: END IF;

Line 2119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2115: IF l_debug_level > 0 THEN
2116: oe_debug_pub.add('Split Line: Process order returns unexpected error : '||sqlerrm,1) ;
2117: END IF;
2118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2120: IF l_debug_level > 0 THEN
2121: oe_debug_pub.add('Split Line: Process order returns execution error : '||sqlerrm,1) ;
2122: END IF;
2123: RAISE FND_API.G_EXC_ERROR;

Line 2123: RAISE FND_API.G_EXC_ERROR;

2119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2120: IF l_debug_level > 0 THEN
2121: oe_debug_pub.add('Split Line: Process order returns execution error : '||sqlerrm,1) ;
2122: END IF;
2123: RAISE FND_API.G_EXC_ERROR;
2124: END IF;
2125:
2126: oe_order_pvt.Line_Scredits
2127: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 2127: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

2123: RAISE FND_API.G_EXC_ERROR;
2124: END IF;
2125:
2126: oe_order_pvt.Line_Scredits
2127: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2128: , p_control_rec => l_control_rec
2129: , p_x_line_Scredit_tbl => l_Line_Scredit_tbl
2130: , p_x_old_line_Scredit_tbl => l_old_line_Scredit_tbl
2131: , x_return_status => l_return_status

Line 2133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2129: , p_x_line_Scredit_tbl => l_Line_Scredit_tbl
2130: , p_x_old_line_Scredit_tbl => l_old_line_Scredit_tbl
2131: , x_return_status => l_return_status
2132: );
2133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;

Line 2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2130: , p_x_old_line_Scredit_tbl => l_old_line_Scredit_tbl
2131: , x_return_status => l_return_status
2132: );
2133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;
2138: OE_Order_PVT.Process_Requests_And_Notify

Line 2135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2131: , x_return_status => l_return_status
2132: );
2133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;
2138: OE_Order_PVT.Process_Requests_And_Notify
2139: ( p_process_requests => TRUE

Line 2136: RAISE FND_API.G_EXC_ERROR;

2132: );
2133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;
2138: OE_Order_PVT.Process_Requests_And_Notify
2139: ( p_process_requests => TRUE
2140: , p_notify => FALSE --lchen

Line 2150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2146: );
2147: g_non_prop_split := FALSE;
2148: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y' ;
2149: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2153: RAISE FND_API.G_EXC_ERROR;
2154: END IF;

Line 2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2147: g_non_prop_split := FALSE;
2148: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y' ;
2149: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2153: RAISE FND_API.G_EXC_ERROR;
2154: END IF;
2155: EXCEPTION

Line 2152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2148: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y' ;
2149: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2153: RAISE FND_API.G_EXC_ERROR;
2154: END IF;
2155: EXCEPTION
2156: WHEN OTHERS THEN

Line 2153: RAISE FND_API.G_EXC_ERROR;

2149: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2153: RAISE FND_API.G_EXC_ERROR;
2154: END IF;
2155: EXCEPTION
2156: WHEN OTHERS THEN
2157: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2160: ( G_PKG_NAME ,
2161: 'Cascade_Non_Proportional_Split'
2162: );
2163: END IF;
2164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2165: END Cascade_Non_Proportional_Split;
2166:
2167: PROCEDURE Record_line_History
2168: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2178: ,p_reason_code => p_line_rec.change_reason
2179: ,p_comments => p_line_rec.change_comments
2180: ,x_return_status => l_return_status);
2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;

Line 2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2179: ,p_comments => p_line_rec.change_comments
2180: ,x_return_status => l_return_status);
2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187: EXCEPTION

Line 2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2180: ,x_return_status => l_return_status);
2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187: EXCEPTION
2188: WHEN OTHERS THEN

Line 2185: RAISE FND_API.G_EXC_ERROR;

2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187: EXCEPTION
2188: WHEN OTHERS THEN
2189: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2192: ( G_PKG_NAME ,
2193: 'Record_Line_History'
2194: );
2195: END IF;
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: End Record_line_History;
2198:
2199:
2200: Procedure Add_To_Fulfillment_Set(p_line_rec IN oe_order_pub.line_rec_type) IS

Line 2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2226: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2227: OE_MSG_PUB.Add_Exc_Msg
2228: (G_PKG_NAME,'Add to Fulfillment Set');
2229: END IF;
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2231: End Add_To_Fulfillment_Set;
2232:
2233: /* Defer Split ER Changes Start */
2234: PROCEDURE Defer_Split

Line 2326: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));

2322: IF l_count = 0 THEN
2323: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2324: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
2325: OE_Msg_Pub.Add;
2326: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
2327: RETURN;
2328: END IF;
2329:
2330:

Line 2349: RAISE FND_API.G_EXC_ERROR;

2345: IF l_orig_ord_qty > 0 AND l_ord_qty_sum <> l_orig_ord_qty THEN
2346: FND_MESSAGE.SET_NAME('ONT','OE_UI_SPLIT_UNEQUAL_QTY');
2347: OE_MSG_PUB.ADD;
2348: oe_debug_pub.add('Total shipment quantity must equal original quantity',1);
2349: RAISE FND_API.G_EXC_ERROR;
2350: ELSIF l_orig_ord_qty2 > 0 AND (l_ord_qty2_sum <> l_orig_ord_qty2) THEN
2351: FND_MESSAGE.SET_NAME('ONT','OE_UI_SPLIT_UNEQUAL_QTY');
2352: OE_MSG_PUB.ADD;
2353: oe_debug_pub.add('Total shipment quantity must equal original quantity',1);

Line 2354: RAISE FND_API.G_EXC_ERROR;

2350: ELSIF l_orig_ord_qty2 > 0 AND (l_ord_qty2_sum <> l_orig_ord_qty2) THEN
2351: FND_MESSAGE.SET_NAME('ONT','OE_UI_SPLIT_UNEQUAL_QTY');
2352: OE_MSG_PUB.ADD;
2353: oe_debug_pub.add('Total shipment quantity must equal original quantity',1);
2354: RAISE FND_API.G_EXC_ERROR;
2355: END IF;
2356:
2357: /* OPEN c_split_details;
2358: FETCH c_split_details BULK COLLECT --moved this statement to the top.

Line 2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2372: ( x_return_status => l_return_status
2373: , p_x_line_rec => l_x_line_tbl(i)
2374: , p_line_id => l_line_conc_tbl(i).line_id);
2375:
2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: RAISE FND_API.G_EXC_ERROR;
2380: END IF;

Line 2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2373: , p_x_line_rec => l_x_line_tbl(i)
2374: , p_line_id => l_line_conc_tbl(i).line_id);
2375:
2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: RAISE FND_API.G_EXC_ERROR;
2380: END IF;
2381: oe_debug_pub.add('After Query Line for Split',3) ;

Line 2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2374: , p_line_id => l_line_conc_tbl(i).line_id);
2375:
2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: RAISE FND_API.G_EXC_ERROR;
2380: END IF;
2381: oe_debug_pub.add('After Query Line for Split',3) ;
2382: END IF;

Line 2379: RAISE FND_API.G_EXC_ERROR;

2375:
2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: RAISE FND_API.G_EXC_ERROR;
2380: END IF;
2381: oe_debug_pub.add('After Query Line for Split',3) ;
2382: END IF;
2383: l_x_line_tbl(i).line_id := l_line_conc_tbl(i).line_id;

Line 2419: , p_init_msg_list => FND_API.G_TRUE

2415: oe_debug_pub.add('From Defer Split - Calling Process Order',1) ;
2416:
2417: Oe_Order_Pvt.Process_order
2418: ( p_api_version_number => 1.0
2419: , p_init_msg_list => FND_API.G_TRUE
2420: , x_return_status => l_return_status
2421: , x_msg_count => l_msg_count
2422: , x_msg_data => l_msg_data
2423: , p_control_rec => l_control_rec

Line 2448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2444: oe_debug_pub.add('From Defer Split - After Calling Process Order',1) ;
2445:
2446: l_msg_total := l_msg_total + l_msg_count;
2447:
2448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: RAISE FND_API.G_EXC_ERROR;
2452: END IF;

Line 2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2445:
2446: l_msg_total := l_msg_total + l_msg_count;
2447:
2448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: RAISE FND_API.G_EXC_ERROR;
2452: END IF;
2453:

Line 2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2446: l_msg_total := l_msg_total + l_msg_count;
2447:
2448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: RAISE FND_API.G_EXC_ERROR;
2452: END IF;
2453:
2454: IF l_x_line_tbl.count > 0 THEN

Line 2451: RAISE FND_API.G_EXC_ERROR;

2447:
2448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: RAISE FND_API.G_EXC_ERROR;
2452: END IF;
2453:
2454: IF l_x_line_tbl.count > 0 THEN
2455: l_line_tbl.delete;

Line 2479: l_line_tbl(i).split_action_code:= FND_API.G_MISS_CHAR;

2475: oe_debug_pub.add('Reason code being passed : '||l_line_tbl(i).change_reason,1);
2476:
2477: l_line_tbl(i).change_reason := l_line_conc_tbl(i).change_reason_code;
2478: l_line_tbl(i).change_comments := l_line_conc_tbl(i).change_reason_comment;
2479: l_line_tbl(i).split_action_code:= FND_API.G_MISS_CHAR;
2480: l_line_tbl(i).line_id := l_x_line_tbl(i).line_id;
2481: l_line_tbl(i).header_id := l_x_line_tbl(i).header_id;
2482:
2483: IF l_line_conc_tbl(i).ship_from_org_id IS NOT NULL THEN

Line 2563: l_line_tbl(l_rec_count).split_action_code := FND_API.G_MISS_CHAR;

2559: l_line_tbl(l_rec_count).change_reason :=
2560: l_line_conc_tbl(k).change_reason_code;
2561: l_line_tbl(l_rec_count).change_comments :=
2562: l_line_conc_tbl(k).change_reason_comment;
2563: l_line_tbl(l_rec_count).split_action_code := FND_API.G_MISS_CHAR;
2564: l_line_tbl(l_rec_count).line_id := l_x_line_tbl(i).line_id;
2565: l_line_tbl(l_rec_count).header_id := l_x_line_tbl(i).header_id;
2566:
2567: l_rec_count := l_rec_count + 1;

Line 2592: , p_init_msg_list => FND_API.G_TRUE

2588: IF l_process_add_attributes THEN
2589: oe_debug_pub.add('calling process_order for service lines from oe_split_util.defer_split',5);
2590: Oe_Order_Pvt.Process_order
2591: ( p_api_version_number => 1.0
2592: , p_init_msg_list => FND_API.G_TRUE
2593: , x_return_status => l_return_status
2594: , x_msg_count => l_msg_count
2595: , x_msg_data => l_msg_data
2596: , p_control_rec => l_control_rec

Line 2619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2615: END IF;
2616:
2617: l_msg_total := l_msg_total + l_msg_count;
2618:
2619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;

Line 2620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2616:
2617: l_msg_total := l_msg_total + l_msg_count;
2618:
2619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624: END IF;

Line 2621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2617: l_msg_total := l_msg_total + l_msg_count;
2618:
2619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624: END IF;
2625:

Line 2622: RAISE FND_API.G_EXC_ERROR;

2618:
2619: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2621: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624: END IF;
2625:
2626: -- Irrespective of program result, deleting the data from table

Line 2635: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));

2631: ELSE -- l_count < 2
2632: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2633: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
2634: OE_Msg_Pub.Add;
2635: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
2636: RETURN;
2637:
2638: END IF;
2639:

Line 2651: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);

2647: IF NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'), 0) <> 0 THEN
2648: -- Called from concurrent request
2649: IF l_msg_total > 0 THEN
2650: FOR I IN 1 .. l_msg_total LOOP
2651: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);
2652: FND_FILE.put_line(FND_FILE.output, l_msg_data);
2653: -- Writing messages into the concurrent request output file
2654: END LOOP;
2655: oe_debug_pub.add(' Saving the Messages');

Line 2674: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);

2670: IF NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'), 0) <> 0 THEN
2671: -- Called from concurrent request */
2672: IF l_msg_total > 0 THEN
2673: FOR I IN 1 .. l_msg_total LOOP
2674: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);
2675: FND_FILE.put_line(FND_FILE.output, l_msg_data);
2676: -- Writing messages into the concurrent request output file
2677: END LOOP;
2678: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);