eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_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.line_id; --9111247
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 176: OR p_line_rec.top_model_line_id = FND_API.G_MISS_NUM THEN

172: IF l_debug_level > 0 THEN
173: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE: FUNCTION GET_SHIPMENT_NUMBER' ) ;
174: END IF;
175: IF p_line_rec.top_model_line_id IS NULL
176: OR p_line_rec.top_model_line_id = FND_API.G_MISS_NUM THEN
177: SELECT NVL(MAX(SHIPMENT_NUMBER)+1,1)
178: INTO l_ship_number
179: FROM OE_ORDER_LINES
180: WHERE HEADER_ID = p_line_rec.header_id

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

260: WHEN OTHERS THEN
261: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
262: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,'Get_Shipment_Number' );
263: END IF;
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END Get_Shipment_Number;
266:
267: FUNCTION Check_Complete_Shipment(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
268: p_line_id IN number) RETURN VARCHAR2 IS

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: EXCEPTION WHEN OTHERS THEN
311: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Check_Complete_Shipment');
313: END IF;
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END Check_Complete_Shipment;
316:
317: Procedure Get_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
318: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type,

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

361: l_ser_line_tbl(l_service_count).split_action_code := 'SPLIT';
362: l_service_count := l_service_count + 1;
363: FOR I in 2..g_split_line_tbl.count LOOP
364: l_ser_line_tbl(l_service_count) := l_ser_rec;
365: l_ser_line_tbl(l_service_count).line_id := fnd_api.g_miss_num;
366: l_ser_line_tbl(l_service_count).split_from_line_id := l_ser_rec.line_id;
367: l_ser_line_tbl(l_service_count).operation := oe_globals.g_opr_create;
368: g_qry_out_rec := l_ser_line_tbl(l_service_count) ;
369: OE_Split_Util.Default_Attributes(

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407: WHEN OTHERS THEN
408: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
409: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Get_Service_line');
410: END IF;
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END Get_Service_lines;
413:
414: Procedure Get_non_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
415: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS

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

566: l_parent_line.split_from_line_id := l_parent_line.line_id;
567: IF l_debug_level > 0 THEN
568: oe_debug_pub.add('Line set id is : '||l_set_id,5) ;
569: END IF;
570: l_parent_line.line_id := fnd_api.g_miss_num;
571: l_parent_line.orig_sys_line_ref :=fnd_api.g_miss_char; -- Bug5207907
572: OE_Split_Util.Default_Attributes
573: (p_x_line_rec => l_parent_line,
574: p_old_line_rec => l_parent_line );

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

567: IF l_debug_level > 0 THEN
568: oe_debug_pub.add('Line set id is : '||l_set_id,5) ;
569: END IF;
570: l_parent_line.line_id := fnd_api.g_miss_num;
571: l_parent_line.orig_sys_line_ref :=fnd_api.g_miss_char; -- Bug5207907
572: OE_Split_Util.Default_Attributes
573: (p_x_line_rec => l_parent_line,
574: p_old_line_rec => l_parent_line );
575: IF l_parent_line.line_set_id is null AND l_set_id IS NULL THEN

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

586: l_option_count := l_option_count + 1;
587: l_option_line_tbl(l_option_count) := l_option_line;
588: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
589: l_option_line_tbl(l_option_count).split_by:='SYSTEM';
590: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
591: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
592: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
593: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
594: OE_Split_Util.Default_Attributes

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

588: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
589: l_option_line_tbl(l_option_count).split_by:='SYSTEM';
590: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
591: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
592: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
593: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
594: OE_Split_Util.Default_Attributes
595: ( p_x_line_rec => g_qry_out_rec
596: ,p_old_line_rec => l_option_line_tbl(l_option_count)

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

651: ELSE -- g_max_model
652: l_parent_line.operation := oe_globals.g_opr_create;
653: l_parent_line.split_by := 'SYSTEM';
654: l_parent_line.split_from_line_id := l_parent_line.line_id;
655: l_parent_line.line_id := fnd_api.g_miss_num;
656: l_parent_line.config_header_id := NULL;
657: l_parent_line.config_rev_nbr := NULL;
658: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
659: OE_Split_Util.Default_Attributes

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

654: l_parent_line.split_from_line_id := l_parent_line.line_id;
655: l_parent_line.line_id := fnd_api.g_miss_num;
656: l_parent_line.config_header_id := NULL;
657: l_parent_line.config_rev_nbr := NULL;
658: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
659: OE_Split_Util.Default_Attributes
660: (p_x_line_rec => l_parent_line
661: ,p_old_line_rec => l_parent_line
662: );

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

694: p_line_tbl(I).shipped_quantity - g_max_model * l_model_ratio;
695: IF l_option_line.ordered_quantity > 0 THEN
696: l_option_count := l_option_count + 1;
697: l_option_line_tbl(l_option_count) := l_option_line;
698: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
699: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
700: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
701: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
702: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907

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

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

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

760: p_line_tbl(I).shipped_quantity - g_max_model * l_model_ratio;
761: IF l_option_line.ordered_quantity > 0 THEN
762: l_option_count := l_option_count + 1;
763: l_option_line_tbl(l_option_count) := l_option_line;
764: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
765: l_option_line_tbl(l_option_count).split_from_line_id := configrec.line_id;
766: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
767: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
768: IF l_debug_level > 0 THEN

Line 771: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5223102

767: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
768: IF l_debug_level > 0 THEN
769: oe_debug_pub.add('adding for ato model in procedure Get_non_Model_Configuration',5) ;
770: END IF;
771: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5223102
772: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
773:
774: OE_Split_Util.Default_Attributes
775: ( p_x_line_rec => g_qry_out_rec

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

829: IF l_parent_line.ordered_quantity <> 0 THEN
830: l_parent_line.operation := oe_globals.g_opr_create;
831: l_parent_line.split_by := 'SYSTEM';
832: l_parent_line.split_from_line_id := l_parent_line.line_id;
833: l_parent_line.line_id := fnd_api.g_miss_num;
834: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
835: OE_Split_Util.Default_Attributes
836: ( p_x_line_rec => l_parent_line
837: , p_old_line_rec => l_parent_line

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

830: l_parent_line.operation := oe_globals.g_opr_create;
831: l_parent_line.split_by := 'SYSTEM';
832: l_parent_line.split_from_line_id := l_parent_line.line_id;
833: l_parent_line.line_id := fnd_api.g_miss_num;
834: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
835: OE_Split_Util.Default_Attributes
836: ( p_x_line_rec => l_parent_line
837: , p_old_line_rec => l_parent_line
838: );

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

892: ELSE
893: l_option_line_tbl(l_option_count).split_by := 'SYSTEM';
894: l_option_line_tbl(l_option_count) := l_option_line;
895: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
896: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
897: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
898: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
899: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
900: OE_Split_Util.Default_Attributes

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

894: l_option_line_tbl(l_option_count) := l_option_line;
895: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
896: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
897: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
898: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
899: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
900: OE_Split_Util.Default_Attributes
901: ( p_x_line_rec => g_qry_out_rec
902: ,p_old_line_rec => l_option_line_tbl(l_option_count)

Line 981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

977: WHEN OTHERS THEN
978: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
979: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Get_Non_Model_Configuration' );
980: END IF;
981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
982: END Get_Non_Model_Configuration;
983:
984: Procedure Get_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
985: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS

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

1100: l_parent_line.split_from_line_id := l_parent_line.line_id;
1101: IF l_debug_level > 0 THEN
1102: oe_debug_pub.add( 'LINE SET IS-'||L_SET_ID ) ;
1103: END IF;
1104: l_parent_line.line_id := fnd_api.g_miss_num;
1105: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1106: OE_Split_Util.Default_Attributes
1107: (p_x_line_rec => l_parent_line
1108: ,p_old_line_rec => l_parent_line );

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

1101: IF l_debug_level > 0 THEN
1102: oe_debug_pub.add( 'LINE SET IS-'||L_SET_ID ) ;
1103: END IF;
1104: l_parent_line.line_id := fnd_api.g_miss_num;
1105: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1106: OE_Split_Util.Default_Attributes
1107: (p_x_line_rec => l_parent_line
1108: ,p_old_line_rec => l_parent_line );
1109: IF l_parent_line.line_set_id is null AND l_set_id IS NULL THEN

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

1120: l_model_ratio :=l_option_line.ordered_quantity / l_line_rec.ordered_quantity;
1121: l_option_count := l_option_count + 1;
1122: l_option_line_tbl(l_option_count) := l_option_line;
1123: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1124: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1125: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1126: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1127: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1128: OE_Split_Util.Default_Attributes

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

1122: l_option_line_tbl(l_option_count) := l_option_line;
1123: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1124: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1125: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1126: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1127: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1128: OE_Split_Util.Default_Attributes
1129: (p_x_line_rec => g_qry_out_rec
1130: ,p_old_line_rec => l_option_line_tbl(l_option_count)

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

1176: IF l_parent_line.ordered_quantity > 0 THEN
1177: l_parent_line.operation := oe_globals.g_opr_create;
1178: l_parent_line.split_by := 'SYSTEM';
1179: l_parent_line.split_from_line_id := l_parent_line.line_id;
1180: l_parent_line.line_id := fnd_api.g_miss_num;
1181: l_parent_line.config_header_id := NULL;
1182: l_parent_line.config_rev_nbr := NULL;
1183: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1184: OE_Split_Util.Default_Attributes

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

1179: l_parent_line.split_from_line_id := l_parent_line.line_id;
1180: l_parent_line.line_id := fnd_api.g_miss_num;
1181: l_parent_line.config_header_id := NULL;
1182: l_parent_line.config_rev_nbr := NULL;
1183: l_parent_line.orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1184: OE_Split_Util.Default_Attributes
1185: ( p_x_line_rec => l_parent_line
1186: ,p_old_line_rec => l_parent_line );
1187: l_rem_shp_top_model_line_id := l_parent_line.line_id;

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

1210: IF l_parent_line.ordered_quantity > 0 THEN
1211: l_parent_line.operation := oe_globals.g_opr_create;
1212: l_parent_line.split_by := 'SYSTEM';
1213: l_parent_line.split_from_line_id := l_parent_line.line_id;
1214: l_parent_line.line_id := fnd_api.g_miss_num;
1215: OE_Split_Util.Default_Attributes
1216: ( p_x_line_rec => l_parent_line
1217: ,p_old_line_rec => l_parent_line
1218: );

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

1251: --bug 4590044 :create shipped remanant option line only when ordered_qty > 0
1252: IF ( p_line_tbl(I).shipped_quantity-g_max_model * l_model_ratio >0) THEN
1253: l_option_count := l_option_count + 1;
1254: l_option_line_tbl(l_option_count) := l_option_line;
1255: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1256: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1257: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1258: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1259: OE_Split_Util.Default_Attributes

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

1323: l_option_line_tbl(l_option_count).top_model_line_id := l_top_model_line_id;
1324: ELSE
1325: l_option_line_tbl(l_option_count) := l_option_line;
1326: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1327: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1328: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1329: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1330: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1331: OE_Split_Util.Default_Attributes

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

1325: l_option_line_tbl(l_option_count) := l_option_line;
1326: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1327: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1328: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1329: l_option_line_tbl(l_option_count).orig_sys_line_ref := fnd_api.g_miss_char; --Bug5207907
1330: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1331: OE_Split_Util.Default_Attributes
1332: ( p_x_line_rec => g_qry_out_rec
1333: , p_old_line_rec => l_option_line_tbl(l_option_count)

Line 1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1378: ( G_PKG_NAME ,
1379: 'Get_Model_Configuration'
1380: );
1381: END IF;
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END Get_Model_Configuration;
1384:
1385: Procedure Cascade_Proportional_Split(p_line_tbl IN OE_ORDER_PUB.Line_tbl_type,
1386: Parent_ordered_quantity NUMBER,

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

1516: l_split_line_tbl(l_split_count).line_id := l_option_line_tbl(l_option_count).line_id;
1517: l_option_count := l_option_count + 1;
1518: FOR I IN 2 .. g_split_line_tbl.count LOOP
1519: l_option_line_tbl(l_option_count) := l_option_line;
1520: l_option_line_tbl(l_option_count).line_id := fnd_api.g_miss_num;
1521: l_option_line_tbl(l_option_count).ordered_quantity := g_split_line_tbl(I).quantity * l_model_ratio;
1522: IF l_debug_level > 0 THEN
1523: oe_debug_pub.add( 'RATIO 3 : ' || G_SPLIT_LINE_TBL ( I ) .QUANTITY , 1 ) ;
1524: END IF;

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

1525: l_option_line_tbl(l_option_count).operation := oe_globals.g_opr_create;
1526: l_option_line_tbl(l_option_count).split_from_line_id := optionrec.line_id;
1527: l_option_line_tbl(l_option_count).split_by := p_line_tbl(p_index).split_by;
1528: g_qry_out_rec := l_option_line_tbl(l_option_count) ;
1529: g_qry_out_rec.orig_sys_line_ref :=fnd_api.g_miss_char; --bug5207907
1530: OE_Split_Util.Default_Attributes ( p_x_line_rec => g_qry_out_rec
1531: ,p_old_line_rec => l_option_line_tbl(l_option_count));
1532: l_option_line_tbl(l_option_count) := g_qry_out_rec;
1533:

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

1555: END IF;
1556: FOR SCRD_REC IN 1..l_line_Scredit_tbl.count LOOP
1557: l_scredit_count := l_scredit_count + 1;
1558: l_line_scredit_temp_tbl(l_scredit_count) := l_line_scredit_tbl(SCRD_REC);
1559: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id := FND_API.G_MISS_NUM;
1560: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;
1561: l_line_scredit_temp_tbl(l_scredit_count).line_id := l_option_line_tbl(l_option_count).line_id;
1562: END LOOP;
1563: IF l_debug_level > 0 THEN

Line 1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1659: END IF;
1660: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1661: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Cascade_Proportional_Split');
1662: END IF;
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664:
1665: End Cascade_Proportional_Split;
1666:
1667: Procedure Default_Attributes

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

1697: oe_debug_pub.add( 'SHIP TO FLAG:'||P_X_LINE_REC.SPLIT_SHIP_TO ) ;
1698: END IF;
1699: IF (p_x_line_rec.operation = oe_globals.g_opr_create and
1700: (p_x_line_rec.split_from_line_id IS NOT NULL AND
1701: p_x_line_rec.split_from_line_id <> FND_API.G_MISS_NUM) AND
1702: (p_x_line_rec.line_id IS NULL OR
1703: p_x_line_rec.line_id = FND_API.G_MISS_NUM)) THEN
1704: IF l_debug_level > 0 THEN
1705: oe_debug_pub.add( 'ENTER INTO DEFAULTING SPLITS' ) ;

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

1699: IF (p_x_line_rec.operation = oe_globals.g_opr_create and
1700: (p_x_line_rec.split_from_line_id IS NOT NULL AND
1701: p_x_line_rec.split_from_line_id <> FND_API.G_MISS_NUM) AND
1702: (p_x_line_rec.line_id IS NULL OR
1703: p_x_line_rec.line_id = FND_API.G_MISS_NUM)) THEN
1704: IF l_debug_level > 0 THEN
1705: oe_debug_pub.add( 'ENTER INTO DEFAULTING SPLITS' ) ;
1706: END IF;
1707: oe_line_util.query_row(p_line_id => p_x_line_rec.split_from_line_id,

Line 1711: AND P_X_LINE_REC.SERVICE_REFERENCE_LINE_ID <> FND_API.G_MISS_NUM) THEN --9111247

1707: oe_line_util.query_row(p_line_id => p_x_line_rec.split_from_line_id,
1708: x_line_rec => l_line_rec);
1709: l_line_rec.line_id := OE_Default_Line.get_Line;
1710: IF (P_X_LINE_REC.SERVICE_REFERENCE_LINE_ID IS NOT NULL
1711: AND P_X_LINE_REC.SERVICE_REFERENCE_LINE_ID <> FND_API.G_MISS_NUM) THEN --9111247
1712:
1713: L_LINE_REC.SERVICE_REFERENCE_LINE_ID:=P_X_LINE_REC.SERVICE_REFERENCE_LINE_ID ;
1714: END IF ;
1715: --online changes

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

1724: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1725:
1726: --Changed for bug 4302022
1727: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1728: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1729:
1730: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1731: ELSE
1732: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

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

1738: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1739: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1740: --Changed for bug 4302022
1741: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1742: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1743:
1744: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1745: ELSE
1746: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

Line 1763: p_x_line_rec.request_date <> fnd_api.G_MISS_DATE AND

1759: l_line_rec.split_by := p_x_line_rec.split_by;
1760: -- 8706868
1761:
1762: IF p_x_line_rec.request_date IS NOT NULL AND
1763: p_x_line_rec.request_date <> fnd_api.G_MISS_DATE AND
1764: NVL(P_X_LINE_REC.SPLIT_REQUEST_DATE,'N') ='Y' THEN -- 10278858
1765:
1766: IF l_line_rec.schedule_ship_date IS NOT NULL
1767: /*bug 13954474

Line 1784: p_x_line_rec.ship_from_org_id <> fnd_api.G_MISS_NUM AND

1780:
1781: l_line_rec.request_date := p_x_line_rec.request_date;
1782: END IF;
1783: IF p_x_line_rec.ship_from_org_id IS NOT NULL AND
1784: p_x_line_rec.ship_from_org_id <> fnd_api.G_MISS_NUM AND
1785: NVL(P_X_LINE_REC.SPLIT_SHIP_FROM,'N') = 'Y' THEN --10278858
1786: l_line_rec.ship_from_org_id := p_x_line_rec.ship_from_org_id;
1787: END IF;
1788: IF p_x_line_rec.ship_to_org_id IS NOT NULL AND

Line 1789: p_x_line_rec.ship_to_org_id <> fnd_api.G_MISS_NUM AND

1785: NVL(P_X_LINE_REC.SPLIT_SHIP_FROM,'N') = 'Y' THEN --10278858
1786: l_line_rec.ship_from_org_id := p_x_line_rec.ship_from_org_id;
1787: END IF;
1788: IF p_x_line_rec.ship_to_org_id IS NOT NULL AND
1789: p_x_line_rec.ship_to_org_id <> fnd_api.G_MISS_NUM AND
1790: NVL(P_X_LINE_REC.SPLIT_SHIP_TO,'N') = 'Y' THEN --10278858
1791: l_line_rec.ship_to_org_id := p_x_line_rec.ship_to_org_id;
1792: END IF;
1793: -- 8706868

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

1848: oe_line_util.convert_miss_to_null(p_x_line_rec => l_line_rec);
1849: l_line_rec.operation := oe_globals.g_opr_create;
1850: p_x_line_rec := l_line_rec;
1851: ELSIF (l_line_rec.line_id IS NOT NULL AND
1852: l_line_rec.line_id <> FND_API.G_MISS_NUM AND
1853: l_line_rec.operation = oe_globals.g_opr_create) THEN
1854: IF l_debug_level > 0 THEN
1855: oe_debug_pub.add( 'LINE ID :'||P_X_LINE_REC.LINE_ID ) ;
1856: oe_debug_pub.add( 'SPLIT FROM LINE ID :'||P_X_LINE_REC.SPLIT_FROM_LINE_ID ) ;

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

1870: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1871: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1872: --Changed for bug 4302022
1873: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1874: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1875:
1876: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1877: ELSE
1878: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

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

1883: nvl(l_line_rec.source_document_type_id,0) <> 10 THEN --Bug 5435726
1884: -- l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1885: --Changed for bug 4302022
1886: IF (p_x_line_rec.orig_sys_line_ref IS NULL OR
1887: p_x_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR) THEN
1888:
1889: l_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||l_line_rec.line_id;
1890: ELSE
1891: OE_DEBUG_PUB.add('Orig Sys Line Ref was populated',1);

Line 1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1903: ( G_PKG_NAME ,
1904: 'Split_line'
1905: );
1906: END IF;
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END Default_Attributes;
1909:
1910: PROCEDURE Split_Line
1911: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1920: WHEN OTHERS THEN
1921: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1922: OE_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,'Split_line');
1923: END IF;
1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1925: END Split_Line;
1926:
1927: Procedure Check_split_Course(p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_type,
1928: p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_tbl_type,

Line 2000: RAISE FND_API.G_EXC_ERROR;

1996: OE_MSG_PUB.ADD;
1997: IF l_debug_level > 0 THEN
1998: oe_debug_pub.add( 'SPLIT- NOT ALLOWED TO UPDATE WITH QUANTITY ZERO' ) ;
1999: END IF;
2000: RAISE FND_API.G_EXC_ERROR;
2001: END IF;
2002: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,
2003: x_line_rec => l_line_rec);
2004: IF l_debug_level > 0

Line 2024: RAISE FND_API.G_EXC_ERROR;

2020: OE_MSG_PUB.ADD;
2021: IF l_debug_level > 0 THEN
2022: oe_debug_pub.add( 'SPLIT- NOT ALLOWED THIS ITEMTYPE' ) ;
2023: END IF;
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF;
2026: END IF;
2027: oe_line_util.query_row(p_line_id => l_line_tbl(I).line_id,
2028: x_line_rec => l_line_rec);

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

2031: g_split_line_tbl(l_split_count).line_id := l_line_tbl(I).line_id;
2032: g_split_line_tbl(l_split_count).quantity := l_line_tbl(I).ordered_quantity;
2033: IF ( l_line_rec.line_set_id IS NULL )
2034: THEN
2035: --l_line_tbl(I).line_set_id <> FND_API.G_MISS_NUM) THEN
2036: IF l_debug_level > 0 THEN
2037: oe_debug_pub.add( 'ENTER CREATE LINE SET:' ) ;
2038: END IF;
2039: Oe_Set_Util.Create_Line_Set(p_x_line_rec => l_line_rec);

Line 2119: RAISE FND_API.G_EXC_ERROR;

2115: OE_MSG_PUB.ADD;
2116: IF l_debug_level > 0 THEN
2117: oe_debug_pub.add( 'SPLIT- NOT ALLOWED TO CREATE WITH QUANTITY ZERO' ) ;
2118: END IF;
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;
2121: g_qry_out_rec := l_line_tbl(J);
2122: OE_Split_Util.Default_Attributes (p_x_line_rec => g_qry_out_rec
2123: ,p_old_line_rec => l_line_tbl(J));

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

2138: -- Copy Sales Credits for the new line
2139: FOR SCRD_REC IN 1..L_line_Scredit_tbl.count LOOP
2140: l_scredit_count := l_scredit_count + 1;
2141: l_line_scredit_temp_tbl(l_scredit_count):= L_line_scredit_tbl(SCRD_REC);
2142: l_line_scredit_temp_tbl(l_scredit_count).sales_credit_id:= FND_API.G_MISS_NUM;
2143: l_line_scredit_temp_tbl(l_scredit_count).Operation := OE_GLOBALS.G_OPR_CREATE;
2144: l_line_scredit_temp_tbl(l_scredit_count).line_id := l_line_tbl(J).line_id;
2145: END LOOP;
2146: END IF; -- IF split from line id and operation create

Line 2164: RAISE FND_API.G_EXC_ERROR;

2160: OE_MSG_PUB.ADD;
2161: IF l_debug_level > 0 THEN
2162: oe_debug_pub.add( 'RAJ:SPLIT-QUNATITES NOT EQUAL' ) ;
2163: END IF;
2164: RAISE FND_API.G_EXC_ERROR;
2165: END IF;
2166: l_child_quantity := 0;
2167: -- Call service API to get service Lines
2168: Get_Service_Lines(p_line_tbl => l_line_tbl,

Line 2219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2215: OE_SPLIT_UTIL.G_SPLIT_ACTION := TRUE;
2216: /* OE_ORDER_SCH_UTIL.Split_Scheduling(p_line_tbl => l_sch_tbl,
2217: x_line_tbl => l_sch_tbl,
2218: x_return_status => l_return_status);
2219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2220: oe_debug_pub.add('Into split scheduling unexpected failure');
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2223: oe_debug_pub.add('Into split scheduling expected failure');

Line 2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2217: x_line_tbl => l_sch_tbl,
2218: x_return_status => l_return_status);
2219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2220: oe_debug_pub.add('Into split scheduling unexpected failure');
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2223: oe_debug_pub.add('Into split scheduling expected failure');
2224: RAISE FND_API.G_EXC_ERROR;
2225: END IF; */

Line 2222: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2218: x_return_status => l_return_status);
2219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2220: oe_debug_pub.add('Into split scheduling unexpected failure');
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2223: oe_debug_pub.add('Into split scheduling expected failure');
2224: RAISE FND_API.G_EXC_ERROR;
2225: END IF; */
2226: -- Delete split line tbl for this line

Line 2224: RAISE FND_API.G_EXC_ERROR;

2220: oe_debug_pub.add('Into split scheduling unexpected failure');
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2223: oe_debug_pub.add('Into split scheduling expected failure');
2224: RAISE FND_API.G_EXC_ERROR;
2225: END IF; */
2226: -- Delete split line tbl for this line
2227: g_split_line_tbl.delete;
2228: l_split_count := 0;

Line 2287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2283: ( G_PKG_NAME ,
2284: 'Check_Split_Course'
2285: );
2286: END IF;
2287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2288: END Check_Split_Course;
2289:
2290: Procedure Cascade_non_proportional_Split(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
2291: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS

Line 2321: x_return_status := FND_API.G_RET_STS_SUCCESS;

2317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2318: --
2319: BEGIN
2320:
2321: x_return_status := FND_API.G_RET_STS_SUCCESS;
2322: IF l_debug_level > 0 THEN
2323: OE_DEBUG_PUB.add('Entering Cascade_Non_Proportional_split() ',1);
2324: OE_DEBUG_PUB.add('Table count : '||p_x_line_tbl.count,5) ;
2325: END IF;

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

2461: l_scredit_count := l_scredit_count+1;
2462: l_line_scredit_tbl(l_scredit_count) := l_line_scredit_temp_tbl(Scr);
2463: l_line_scredit_tbl(l_scredit_count).operation := OE_GLOBALS.G_OPR_CREATE;
2464: l_line_scredit_tbl(l_scredit_count).line_id := l_line_tbl(I).line_id;
2465: l_line_scredit_tbl(l_scredit_count).sales_credit_id := fnd_api.g_miss_num;
2466: END LOOP;
2467: END IF;
2468: END LOOP;
2469: -- get Service Lines

Line 2489: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

2485: IF l_debug_level > 0 THEN
2486: oe_debug_pub.add('Before calling process order in splits',1) ;
2487: END IF;
2488: oe_order_pvt.Lines
2489: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2490: , p_control_rec => l_control_rec
2491: , p_x_line_tbl => p_x_line_tbl
2492: , p_x_old_line_tbl => l_old_line_tbl
2493: , x_return_status => l_return_status

Line 2495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2491: , p_x_line_tbl => p_x_line_tbl
2492: , p_x_old_line_tbl => l_old_line_tbl
2493: , x_return_status => l_return_status
2494: );
2495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2496: IF l_debug_level > 0 THEN
2497: oe_debug_pub.add('Split Line: Process order returns unexpected error : '||sqlerrm,1) ;
2498: END IF;
2499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2495: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2496: IF l_debug_level > 0 THEN
2497: oe_debug_pub.add('Split Line: Process order returns unexpected error : '||sqlerrm,1) ;
2498: END IF;
2499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2500: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: IF l_debug_level > 0 THEN
2502: oe_debug_pub.add('Split Line: Process order returns execution error : '||sqlerrm,1) ;
2503: END IF;

Line 2500: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2496: IF l_debug_level > 0 THEN
2497: oe_debug_pub.add('Split Line: Process order returns unexpected error : '||sqlerrm,1) ;
2498: END IF;
2499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2500: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: IF l_debug_level > 0 THEN
2502: oe_debug_pub.add('Split Line: Process order returns execution error : '||sqlerrm,1) ;
2503: END IF;
2504: RAISE FND_API.G_EXC_ERROR;

Line 2504: RAISE FND_API.G_EXC_ERROR;

2500: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: IF l_debug_level > 0 THEN
2502: oe_debug_pub.add('Split Line: Process order returns execution error : '||sqlerrm,1) ;
2503: END IF;
2504: RAISE FND_API.G_EXC_ERROR;
2505: END IF;
2506:
2507: oe_order_pvt.Line_Scredits
2508: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 2508: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

2504: RAISE FND_API.G_EXC_ERROR;
2505: END IF;
2506:
2507: oe_order_pvt.Line_Scredits
2508: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
2509: , p_control_rec => l_control_rec
2510: , p_x_line_Scredit_tbl => l_Line_Scredit_tbl
2511: , p_x_old_line_Scredit_tbl => l_old_line_Scredit_tbl
2512: , x_return_status => l_return_status

Line 2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2510: , p_x_line_Scredit_tbl => l_Line_Scredit_tbl
2511: , p_x_old_line_Scredit_tbl => l_old_line_Scredit_tbl
2512: , x_return_status => l_return_status
2513: );
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;

Line 2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2511: , p_x_old_line_Scredit_tbl => l_old_line_Scredit_tbl
2512: , x_return_status => l_return_status
2513: );
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;
2519: OE_Order_PVT.Process_Requests_And_Notify

Line 2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2512: , x_return_status => l_return_status
2513: );
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;
2519: OE_Order_PVT.Process_Requests_And_Notify
2520: ( p_process_requests => TRUE

Line 2517: RAISE FND_API.G_EXC_ERROR;

2513: );
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;
2519: OE_Order_PVT.Process_Requests_And_Notify
2520: ( p_process_requests => TRUE
2521: , p_notify => FALSE --lchen

Line 2531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2527: );
2528: g_non_prop_split := FALSE;
2529: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y' ;
2530: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: RAISE FND_API.G_EXC_ERROR;
2535: END IF;

Line 2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2528: g_non_prop_split := FALSE;
2529: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y' ;
2530: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: RAISE FND_API.G_EXC_ERROR;
2535: END IF;
2536: EXCEPTION

Line 2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2529: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG := 'Y' ;
2530: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: RAISE FND_API.G_EXC_ERROR;
2535: END IF;
2536: EXCEPTION
2537: WHEN OTHERS THEN

Line 2534: RAISE FND_API.G_EXC_ERROR;

2530: OE_SPLIT_UTIL.G_SPLIT_ACTION := FALSE;
2531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: RAISE FND_API.G_EXC_ERROR;
2535: END IF;
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2541: ( G_PKG_NAME ,
2542: 'Cascade_Non_Proportional_Split'
2543: );
2544: END IF;
2545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2546: END Cascade_Non_Proportional_Split;
2547:
2548: PROCEDURE Record_line_History
2549: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 2563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2559: ,p_reason_code => p_line_rec.change_reason
2560: ,p_comments => p_line_rec.change_comments
2561: ,x_return_status => l_return_status);
2562:
2563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;

Line 2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2560: ,p_comments => p_line_rec.change_comments
2561: ,x_return_status => l_return_status);
2562:
2563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;
2568: EXCEPTION

Line 2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2561: ,x_return_status => l_return_status);
2562:
2563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;
2568: EXCEPTION
2569: WHEN OTHERS THEN

Line 2566: RAISE FND_API.G_EXC_ERROR;

2562:
2563: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2566: RAISE FND_API.G_EXC_ERROR;
2567: END IF;
2568: EXCEPTION
2569: WHEN OTHERS THEN
2570: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2573: ( G_PKG_NAME ,
2574: 'Record_Line_History'
2575: );
2576: END IF;
2577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2578: End Record_line_History;
2579:
2580:
2581: Procedure Add_To_Fulfillment_Set(p_line_rec IN oe_order_pub.line_rec_type) IS

Line 2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2607: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2608: OE_MSG_PUB.Add_Exc_Msg
2609: (G_PKG_NAME,'Add to Fulfillment Set');
2610: END IF;
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: End Add_To_Fulfillment_Set;
2613:
2614: /* Defer Split ER Changes Start */
2615: PROCEDURE Defer_Split

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

2709: IF l_count = 0 THEN
2710: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
2711: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
2712: OE_Msg_Pub.Add;
2713: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
2714: RETURN;
2715: END IF;
2716:
2717:

Line 2736: RAISE FND_API.G_EXC_ERROR;

2732: IF l_orig_ord_qty > 0 AND l_ord_qty_sum <> l_orig_ord_qty THEN
2733: FND_MESSAGE.SET_NAME('ONT','OE_UI_SPLIT_UNEQUAL_QTY');
2734: OE_MSG_PUB.ADD;
2735: oe_debug_pub.add('Total shipment quantity must equal original quantity',1);
2736: RAISE FND_API.G_EXC_ERROR;
2737: ELSIF l_orig_ord_qty2 > 0 AND (l_ord_qty2_sum <> l_orig_ord_qty2) THEN
2738: FND_MESSAGE.SET_NAME('ONT','OE_UI_SPLIT_UNEQUAL_QTY');
2739: OE_MSG_PUB.ADD;
2740: oe_debug_pub.add('Total shipment quantity must equal original quantity',1);

Line 2741: RAISE FND_API.G_EXC_ERROR;

2737: ELSIF l_orig_ord_qty2 > 0 AND (l_ord_qty2_sum <> l_orig_ord_qty2) THEN
2738: FND_MESSAGE.SET_NAME('ONT','OE_UI_SPLIT_UNEQUAL_QTY');
2739: OE_MSG_PUB.ADD;
2740: oe_debug_pub.add('Total shipment quantity must equal original quantity',1);
2741: RAISE FND_API.G_EXC_ERROR;
2742: END IF;
2743:
2744: /* OPEN c_split_details;
2745: FETCH c_split_details BULK COLLECT --moved this statement to the top.

Line 2763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2759: ( x_return_status => l_return_status
2760: , p_x_line_rec => l_x_line_tbl(i)
2761: , p_line_id => l_line_conc_tbl(i).line_id);
2762:
2763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;

Line 2764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2760: , p_x_line_rec => l_x_line_tbl(i)
2761: , p_line_id => l_line_conc_tbl(i).line_id);
2762:
2763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;
2768: oe_debug_pub.add('After Query Line for Split',3) ;

Line 2765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2761: , p_line_id => l_line_conc_tbl(i).line_id);
2762:
2763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;
2768: oe_debug_pub.add('After Query Line for Split',3) ;
2769: --10278858

Line 2766: RAISE FND_API.G_EXC_ERROR;

2762:
2763: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2765: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;
2768: oe_debug_pub.add('After Query Line for Split',3) ;
2769: --10278858
2770: l_org_request_date := l_x_line_tbl(i).request_date;

Line 2849: , p_init_msg_list => FND_API.G_TRUE

2845: oe_debug_pub.add('From Defer Split - Calling Process Order',1) ;
2846:
2847: Oe_Order_Pvt.Process_order
2848: ( p_api_version_number => 1.0
2849: , p_init_msg_list => FND_API.G_TRUE
2850: , x_return_status => l_return_status
2851: , x_msg_count => l_msg_count
2852: , x_msg_data => l_msg_data
2853: , p_control_rec => l_control_rec

Line 2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2874: oe_debug_pub.add('From Defer Split - After Calling Process Order',1) ;
2875:
2876: l_msg_total := l_msg_total + l_msg_count;
2877:
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;

Line 2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2875:
2876: l_msg_total := l_msg_total + l_msg_count;
2877:
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:

Line 2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2876: l_msg_total := l_msg_total + l_msg_count;
2877:
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: IF l_x_line_tbl.count > 0 THEN

Line 2881: RAISE FND_API.G_EXC_ERROR;

2877:
2878: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2880: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: IF l_x_line_tbl.count > 0 THEN
2885: l_line_tbl.delete;

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

2906: oe_debug_pub.add('Reason code being passed : '||l_line_tbl(i).change_reason,1);
2907:
2908: l_line_tbl(i).change_reason := l_line_conc_tbl(i).change_reason_code;
2909: l_line_tbl(i).change_comments := l_line_conc_tbl(i).change_reason_comment;
2910: l_line_tbl(i).split_action_code:= FND_API.G_MISS_CHAR;
2911: l_line_tbl(i).line_id := l_x_line_tbl(i).line_id;
2912: l_line_tbl(i).header_id := l_x_line_tbl(i).header_id;
2913:
2914: IF l_line_conc_tbl(i).ship_from_org_id IS NOT NULL THEN

Line 2977: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 16525601 for Bug 13560415 , do not use nullnull;

2973: NVL(l_line_conc_tbl(k).ship_from_org_id,-1) THEN
2974: IF l_ref_split_ship_from = 'Y' THEN --16525601
2975: l_line_tbl(l_rec_count).ship_from_org_id :=
2976: l_line_conc_tbl(k).ship_from_org_id;
2977: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 16525601 for Bug 13560415 , do not use nullnull;
2978: ELSE
2979: oe_debug_pub.ADD('Inside else Condition');
2980: l_line_tbl(l_rec_count).ship_from_org_id := l_x_line_tbl(i).ship_from_org_id;
2981: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 16525601 for Bug 13560415, do not use nullnull;

Line 2981: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 16525601 for Bug 13560415, do not use nullnull;

2977: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 16525601 for Bug 13560415 , do not use nullnull;
2978: ELSE
2979: oe_debug_pub.ADD('Inside else Condition');
2980: l_line_tbl(l_rec_count).ship_from_org_id := l_x_line_tbl(i).ship_from_org_id;
2981: l_line_tbl(l_rec_count).subinventory := fnd_api.g_miss_char; --Added as a part of 16525601 for Bug 13560415, do not use nullnull;
2982: end if ; --16525601
2983: l_process_add_attributes := TRUE;
2984: END IF; -- if ship_from_changed
2985: END IF; -- ship_from not null

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

2999: l_line_tbl(l_rec_count).change_reason :=
3000: l_line_conc_tbl(k).change_reason_code;
3001: l_line_tbl(l_rec_count).change_comments :=
3002: l_line_conc_tbl(k).change_reason_comment;
3003: l_line_tbl(l_rec_count).split_action_code := FND_API.G_MISS_CHAR;
3004: l_line_tbl(l_rec_count).line_id := l_x_line_tbl(i).line_id;
3005: l_line_tbl(l_rec_count).header_id := l_x_line_tbl(i).header_id;
3006:
3007: l_rec_count := l_rec_count + 1;

Line 3032: , p_init_msg_list => FND_API.G_TRUE

3028: IF l_process_add_attributes THEN
3029: oe_debug_pub.add('calling process_order for service lines from oe_split_util.defer_split',5);
3030: Oe_Order_Pvt.Process_order
3031: ( p_api_version_number => 1.0
3032: , p_init_msg_list => FND_API.G_TRUE
3033: , x_return_status => l_return_status
3034: , x_msg_count => l_msg_count
3035: , x_msg_data => l_msg_data
3036: , p_control_rec => l_control_rec

Line 3059: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3055: END IF;
3056:
3057: l_msg_total := l_msg_total + l_msg_count;
3058:
3059: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3061: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3062: RAISE FND_API.G_EXC_ERROR;
3063: END IF;

Line 3060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3056:
3057: l_msg_total := l_msg_total + l_msg_count;
3058:
3059: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3061: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3062: RAISE FND_API.G_EXC_ERROR;
3063: END IF;
3064: END IF;

Line 3061: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3057: l_msg_total := l_msg_total + l_msg_count;
3058:
3059: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3061: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3062: RAISE FND_API.G_EXC_ERROR;
3063: END IF;
3064: END IF;
3065:

Line 3062: RAISE FND_API.G_EXC_ERROR;

3058:
3059: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3061: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3062: RAISE FND_API.G_EXC_ERROR;
3063: END IF;
3064: END IF;
3065:
3066: -- Irrespective of program result, deleting the data from table

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

3071: ELSE -- l_count < 2
3072: Fnd_Message.Set_Name('ONT','OE_CANCEL_SPLIT_SUCCESS');
3073: Fnd_Message.Set_Token('REQUEST_ID',FND_GLOBAL.CONC_REQUEST_ID);
3074: OE_Msg_Pub.Add;
3075: FND_FILE.put_line(FND_FILE.output,OE_MSG_PUB.Get(OE_MSG_PUB.G_LAST,FND_API.G_FALSE));
3076: RETURN;
3077:
3078: END IF;
3079:

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

3087: IF NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'), 0) <> 0 THEN
3088: -- Called from concurrent request
3089: IF l_msg_total > 0 THEN
3090: FOR I IN 1 .. l_msg_total LOOP
3091: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);
3092: FND_FILE.put_line(FND_FILE.output, l_msg_data);
3093: -- Writing messages into the concurrent request output file
3094: END LOOP;
3095: oe_debug_pub.add(' Saving the Messages');

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

3110: IF NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'), 0) <> 0 THEN
3111: -- Called from concurrent request */
3112: IF l_msg_total > 0 THEN
3113: FOR I IN 1 .. l_msg_total LOOP
3114: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE);
3115: FND_FILE.put_line(FND_FILE.output, l_msg_data);
3116: -- Writing messages into the concurrent request output file
3117: END LOOP;
3118: oe_msg_pub.save_messages(p_request_id => FND_GLOBAL.CONC_REQUEST_ID);