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.

[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on FND_API

Line 392: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,

388: IF x_return_status ='E' and in_global_orgs = 'N' then
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
391: END IF;
392: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
393: p_count => x_msg_count,
394: p_data=>x_msg_data
395: );
396: IF l_debug_level > 0 THEN

Line 417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

413: END IF;
414: IF l_debug_level > 0 THEN
415: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;
416: END IF;
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418:
419: END Check_Results_from_rec;
420:
421:

Line 597: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

593: 'SHIP_FROM_ORG_ID =' ||X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
594: END IF;
595: END IF;
596:
597: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
600: END IF;
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

597: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
600: END IF;
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604:
605: Check_Results_from_rec(

Line 755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
753: END IF;
754: x_return_status := 'E';
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
756: -- Get message count and data
757: OE_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count
759: , p_data => x_msg_data

Line 768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

764: ( G_PKG_NAME,
765: 'Call_MRP_ATP');
766: END IF;
767:
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769:
770: END Call_MRP_ATP;
771:
772: Procedure Enforce_price_list(in_order_type_id in number,

Line 851: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;

847: l_rec.inventory_item_id := in_item_id;
848: l_rec.org_id := in_org_id;
849: l_rec.sold_to_org_id := in_customer_id;
850: l_rec.ship_to_org_id := in_ship_to_org_id;
851: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
852: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
853: --l_rec.price_list_id := FND_API.G_MISS_NUM;
854:
855: l_out_rec := l_rec;

Line 852: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

848: l_rec.org_id := in_org_id;
849: l_rec.sold_to_org_id := in_customer_id;
850: l_rec.ship_to_org_id := in_ship_to_org_id;
851: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
852: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
853: --l_rec.price_list_id := FND_API.G_MISS_NUM;
854:
855: l_out_rec := l_rec;
856:

Line 853: --l_rec.price_list_id := FND_API.G_MISS_NUM;

849: l_rec.sold_to_org_id := in_customer_id;
850: l_rec.ship_to_org_id := in_ship_to_org_id;
851: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
852: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
853: --l_rec.price_list_id := FND_API.G_MISS_NUM;
854:
855: l_out_rec := l_rec;
856:
857: ONT_LINE_DEF_HDLR.Default_record(

Line 898: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

894: l_record.org_id := in_org_id;
895: l_record.ship_to_org_id := in_ship_to_org_id;
896: l_record.agreement_id := in_agreement_id;
897: l_record.invoice_to_org_id := in_bill_to_org_id;
898: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
899: l_record.price_list_id := FND_API.G_MISS_NUM;
900:
901: l_out_record := l_record;
902:

Line 899: l_record.price_list_id := FND_API.G_MISS_NUM;

895: l_record.ship_to_org_id := in_ship_to_org_id;
896: l_record.agreement_id := in_agreement_id;
897: l_record.invoice_to_org_id := in_bill_to_org_id;
898: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
899: l_record.price_list_id := FND_API.G_MISS_NUM;
900:
901: l_out_record := l_record;
902:
903: ONT_HEADER_Def_Hdlr.Default_Record

Line 925: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

921: l_record.org_id := in_org_id;
922: l_record.ship_to_org_id := in_ship_to_org_id;
923: l_record.agreement_id := in_agreement_id;
924: l_record.invoice_to_org_id := in_bill_to_org_id;
925: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
926: l_record.price_list_id := FND_API.G_MISS_NUM;
927:
928: l_out_record := l_record;
929:

Line 926: l_record.price_list_id := FND_API.G_MISS_NUM;

922: l_record.ship_to_org_id := in_ship_to_org_id;
923: l_record.agreement_id := in_agreement_id;
924: l_record.invoice_to_org_id := in_bill_to_org_id;
925: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
926: l_record.price_list_id := FND_API.G_MISS_NUM;
927:
928: l_out_record := l_record;
929:
930: ONT_HEADER_Def_Hdlr.Default_Record

Line 952: l_record.price_list_id := FND_API.G_MISS_NUM;

948: l_record.org_id := in_org_id;
949: l_record.ship_to_org_id := in_ship_to_org_id;
950: l_record.agreement_id := in_agreement_id;
951: l_record.invoice_to_org_id := in_bill_to_org_id;
952: l_record.price_list_id := FND_API.G_MISS_NUM;
953:
954: l_out_record := l_record;
955:
956: ONT_HEADER_Def_Hdlr.Default_Record

Line 979: l_rec.price_list_id := FND_API.G_MISS_NUM;

975: l_rec.ship_to_org_id := in_ship_to_org_id;
976: l_rec.invoice_to_org_id := in_bill_to_org_id;
977: l_rec.sold_to_org_id := in_customer_id;
978: l_rec.org_id := in_org_id;
979: l_rec.price_list_id := FND_API.G_MISS_NUM;
980:
981: l_out_rec := l_rec;
982:
983: ONT_LINE_DEF_HDLR.Default_record(

Line 1001: l_record.conversion_type_code := FND_API.G_MISS_CHAR;

997: ELSIF in_source = 'ORDER_TYPE' then
998:
999: l_record.org_id := in_org_id;
1000: l_record.order_type_id := in_order_type_id;
1001: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1002:
1003: l_out_record := l_record;
1004:
1005:

Line 1027: l_record.conversion_type_code := FND_API.G_MISS_CHAR;

1023: ELSIF in_source = 'STARTUP' then
1024:
1025: l_record.org_id := in_org_id;
1026:
1027: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1028: l_record.price_list_id := FND_API.G_MISS_NUM;
1029: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1030:
1031: l_out_record := l_record;

Line 1028: l_record.price_list_id := FND_API.G_MISS_NUM;

1024:
1025: l_record.org_id := in_org_id;
1026:
1027: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1028: l_record.price_list_id := FND_API.G_MISS_NUM;
1029: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1030:
1031: l_out_record := l_record;
1032:

Line 1029: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

1025: l_record.org_id := in_org_id;
1026:
1027: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1028: l_record.price_list_id := FND_API.G_MISS_NUM;
1029: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1030:
1031: l_out_record := l_record;
1032:
1033: ONT_HEADER_Def_Hdlr.Default_Record

Line 1057: WHEN FND_API.G_EXC_ERROR THEN

1053: END IF;
1054:
1055: EXCEPTION
1056:
1057: WHEN FND_API.G_EXC_ERROR THEN
1058:
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060:
1061: -- Get message count and data

Line 1059: x_return_status := FND_API.G_RET_STS_ERROR;

1055: EXCEPTION
1056:
1057: WHEN FND_API.G_EXC_ERROR THEN
1058:
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060:
1061: -- Get message count and data
1062:
1063: OE_MSG_PUB.Count_And_Get

Line 1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1064: ( p_count => x_msg_count
1065: , p_data => x_msg_data
1066: );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069:
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071:
1072: -- Get message count and data

Line 1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1066: );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069:
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071:
1072: -- Get message count and data
1073:
1074: OE_MSG_PUB.Count_And_Get

Line 1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1077: );
1078:
1079: WHEN OTHERS THEN
1080:
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1082:
1083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1084: THEN
1085: OE_MSG_PUB.Add_Exc_Msg

Line 1164: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;

1160: l_rec.request_date := in_out_default_rec.request_date;
1161: l_rec.price_list_id := in_out_default_rec.price_list_id;
1162: l_rec.line_type_id := in_out_default_rec.line_type_id;
1163: l_rec.demand_class_code := in_out_default_rec.demand_class_code;
1164: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1165: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1166: l_out_rec := l_rec;
1167:
1168:

Line 1165: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

1161: l_rec.price_list_id := in_out_default_rec.price_list_id;
1162: l_rec.line_type_id := in_out_default_rec.line_type_id;
1163: l_rec.demand_class_code := in_out_default_rec.demand_class_code;
1164: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1165: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1166: l_out_rec := l_rec;
1167:
1168:
1169: ONT_LINE_DEF_HDLR.Default_record(

Line 1209: l_record.ship_To_org_id := FND_API.G_MISS_NUM;

1205: l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code;
1206: l_record.created_by := in_out_default_rec.created_by;
1207: l_record.request_date := in_out_default_rec.request_date;
1208: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1209: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1210: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1211: l_record.price_list_id := FND_API.G_MISS_NUM;
1212: l_record.order_type_id := FND_API.G_MISS_NUM;
1213: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

Line 1210: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

1206: l_record.created_by := in_out_default_rec.created_by;
1207: l_record.request_date := in_out_default_rec.request_date;
1208: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1209: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1210: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1211: l_record.price_list_id := FND_API.G_MISS_NUM;
1212: l_record.order_type_id := FND_API.G_MISS_NUM;
1213: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1214: l_record.agreement_id := FND_API.G_MISS_NUM;

Line 1211: l_record.price_list_id := FND_API.G_MISS_NUM;

1207: l_record.request_date := in_out_default_rec.request_date;
1208: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1209: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1210: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1211: l_record.price_list_id := FND_API.G_MISS_NUM;
1212: l_record.order_type_id := FND_API.G_MISS_NUM;
1213: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1214: l_record.agreement_id := FND_API.G_MISS_NUM;
1215: l_out_record := l_record;

Line 1212: l_record.order_type_id := FND_API.G_MISS_NUM;

1208: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1209: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1210: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1211: l_record.price_list_id := FND_API.G_MISS_NUM;
1212: l_record.order_type_id := FND_API.G_MISS_NUM;
1213: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1214: l_record.agreement_id := FND_API.G_MISS_NUM;
1215: l_out_record := l_record;
1216:

Line 1213: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

1209: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1210: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1211: l_record.price_list_id := FND_API.G_MISS_NUM;
1212: l_record.order_type_id := FND_API.G_MISS_NUM;
1213: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1214: l_record.agreement_id := FND_API.G_MISS_NUM;
1215: l_out_record := l_record;
1216:
1217: ONT_HEADER_Def_Hdlr.Default_Record

Line 1214: l_record.agreement_id := FND_API.G_MISS_NUM;

1210: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1211: l_record.price_list_id := FND_API.G_MISS_NUM;
1212: l_record.order_type_id := FND_API.G_MISS_NUM;
1213: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1214: l_record.agreement_id := FND_API.G_MISS_NUM;
1215: l_out_record := l_record;
1216:
1217: ONT_HEADER_Def_Hdlr.Default_Record
1218: ( p_x_rec => l_out_record

Line 1242: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

1238: l_record.created_by := in_out_default_rec.created_by;
1239: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1240: l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code;
1241: l_record.request_date := in_out_default_rec.request_date;
1242: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1243: l_record.price_list_id := FND_API.G_MISS_NUM;
1244: l_record.order_type_id := FND_API.G_MISS_NUM;
1245: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1246: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

Line 1243: l_record.price_list_id := FND_API.G_MISS_NUM;

1239: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1240: l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code;
1241: l_record.request_date := in_out_default_rec.request_date;
1242: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1243: l_record.price_list_id := FND_API.G_MISS_NUM;
1244: l_record.order_type_id := FND_API.G_MISS_NUM;
1245: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1246: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1247:

Line 1244: l_record.order_type_id := FND_API.G_MISS_NUM;

1240: l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code;
1241: l_record.request_date := in_out_default_rec.request_date;
1242: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1243: l_record.price_list_id := FND_API.G_MISS_NUM;
1244: l_record.order_type_id := FND_API.G_MISS_NUM;
1245: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1246: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1247:
1248: l_out_record := l_record;

Line 1245: l_record.demand_class_code := FND_API.G_MISS_CHAR;

1241: l_record.request_date := in_out_default_rec.request_date;
1242: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1243: l_record.price_list_id := FND_API.G_MISS_NUM;
1244: l_record.order_type_id := FND_API.G_MISS_NUM;
1245: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1246: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1247:
1248: l_out_record := l_record;
1249:

Line 1246: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

1242: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1243: l_record.price_list_id := FND_API.G_MISS_NUM;
1244: l_record.order_type_id := FND_API.G_MISS_NUM;
1245: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1246: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1247:
1248: l_out_record := l_record;
1249:
1250: ONT_HEADER_Def_Hdlr.Default_Record

Line 1274: l_record.price_list_id := FND_API.G_MISS_NUM;

1270: l_record.ship_from_org_id := in_out_default_rec.ship_from_org_id;
1271: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1272: l_record.created_by := in_out_default_rec.created_by;
1273: l_record.request_date := in_out_default_rec.request_date;
1274: l_record.price_list_id := FND_API.G_MISS_NUM;
1275: l_record.order_type_id := FND_API.G_MISS_NUM;
1276: l_out_record := l_record;
1277:
1278: ONT_HEADER_Def_Hdlr.Default_Record

Line 1275: l_record.order_type_id := FND_API.G_MISS_NUM;

1271: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1272: l_record.created_by := in_out_default_rec.created_by;
1273: l_record.request_date := in_out_default_rec.request_date;
1274: l_record.price_list_id := FND_API.G_MISS_NUM;
1275: l_record.order_type_id := FND_API.G_MISS_NUM;
1276: l_out_record := l_record;
1277:
1278: ONT_HEADER_Def_Hdlr.Default_Record
1279: ( p_x_rec => l_out_record

Line 1302: l_rec.price_list_id := FND_API.G_MISS_NUM;

1298: l_rec.demand_class_code := in_out_default_rec.demand_class_code;
1299: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1300: l_rec.org_id := in_out_default_rec.org_id;
1301: l_rec.created_by := in_out_default_rec.created_by;
1302: l_rec.price_list_id := FND_API.G_MISS_NUM;
1303: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1304: l_out_rec := l_rec;
1305:
1306:

Line 1303: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;

1299: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1300: l_rec.org_id := in_out_default_rec.org_id;
1301: l_rec.created_by := in_out_default_rec.created_by;
1302: l_rec.price_list_id := FND_API.G_MISS_NUM;
1303: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1304: l_out_rec := l_rec;
1305:
1306:
1307:

Line 1327: l_record.transactional_curr_code :=FND_API.G_MISS_CHAR;

1323: l_record.org_id := in_out_default_rec.org_id;
1324: l_record.created_by := in_out_default_rec.created_by;
1325: l_record.price_list_id := in_out_default_rec.price_list_id;
1326: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1327: l_record.transactional_curr_code :=FND_API.G_MISS_CHAR;
1328: l_out_record := l_record;
1329:
1330: ONT_HEADER_Def_Hdlr.Default_Record
1331: ( p_x_rec => l_out_record

Line 1351: l_record.conversion_type_code := FND_API.G_MISS_CHAR;

1347: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1348: l_record.created_by := in_out_default_rec.created_by;
1349: l_record.request_date := in_out_default_rec.request_date;
1350: --Bug 7347299
1351: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1352:
1353: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1354: l_record.price_list_id := FND_API.G_MISS_NUM;
1355: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

Line 1353: l_record.demand_class_code := FND_API.G_MISS_CHAR;

1349: l_record.request_date := in_out_default_rec.request_date;
1350: --Bug 7347299
1351: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1352:
1353: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1354: l_record.price_list_id := FND_API.G_MISS_NUM;
1355: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1356: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1357: l_out_record := l_record;

Line 1354: l_record.price_list_id := FND_API.G_MISS_NUM;

1350: --Bug 7347299
1351: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1352:
1353: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1354: l_record.price_list_id := FND_API.G_MISS_NUM;
1355: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1356: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1357: l_out_record := l_record;
1358:

Line 1355: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

1351: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1352:
1353: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1354: l_record.price_list_id := FND_API.G_MISS_NUM;
1355: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1356: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1357: l_out_record := l_record;
1358:
1359:

Line 1356: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;

1352:
1353: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1354: l_record.price_list_id := FND_API.G_MISS_NUM;
1355: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1356: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1357: l_out_record := l_record;
1358:
1359:
1360: ONT_HEADER_Def_Hdlr.Default_Record

Line 1389: l_rec.price_list_id := FND_API.G_MISS_NUM;

1385: l_rec.created_by := in_out_default_rec.created_by;
1386: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1387: l_rec.org_id := in_out_default_rec.org_id;
1388:
1389: l_rec.price_list_id := FND_API.G_MISS_NUM;
1390: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1391: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1392: l_out_rec := l_rec;
1393:

Line 1390: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;

1386: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1387: l_rec.org_id := in_out_default_rec.org_id;
1388:
1389: l_rec.price_list_id := FND_API.G_MISS_NUM;
1390: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1391: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1392: l_out_rec := l_rec;
1393:
1394: ONT_LINE_DEF_HDLR.Default_record(

Line 1391: l_rec.demand_class_code := FND_API.G_MISS_CHAR;

1387: l_rec.org_id := in_out_default_rec.org_id;
1388:
1389: l_rec.price_list_id := FND_API.G_MISS_NUM;
1390: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1391: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1392: l_out_rec := l_rec;
1393:
1394: ONT_LINE_DEF_HDLR.Default_record(
1395: p_x_rec => l_out_rec,

Line 1421: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;

1417: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1418: l_record.price_list_id := in_out_default_rec.price_list_id;
1419: l_record.ship_from_org_id := in_out_default_rec.ship_from_org_id;
1420:
1421: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1422: l_out_record := l_record;
1423: ONT_HEADER_Def_Hdlr.Default_Record
1424: ( p_x_rec => l_out_record
1425: , p_initial_rec => l_record

Line 1447: l_record.price_list_id := FND_API.G_MISS_NUM;

1443: l_rec.request_date := in_out_default_rec.request_date;
1444:
1445:
1446:
1447: l_record.price_list_id := FND_API.G_MISS_NUM;
1448: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1449: l_record.order_type_id := FND_API.G_MISS_NUM;
1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;

Line 1448: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

1444:
1445:
1446:
1447: l_record.price_list_id := FND_API.G_MISS_NUM;
1448: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1449: l_record.order_type_id := FND_API.G_MISS_NUM;
1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;

Line 1449: l_record.order_type_id := FND_API.G_MISS_NUM;

1445:
1446:
1447: l_record.price_list_id := FND_API.G_MISS_NUM;
1448: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1449: l_record.order_type_id := FND_API.G_MISS_NUM;
1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

Line 1450: l_record.agreement_id := FND_API.G_MISS_NUM;

1446:
1447: l_record.price_list_id := FND_API.G_MISS_NUM;
1448: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1449: l_record.order_type_id := FND_API.G_MISS_NUM;
1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;

Line 1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;

1447: l_record.price_list_id := FND_API.G_MISS_NUM;
1448: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1449: l_record.order_type_id := FND_API.G_MISS_NUM;
1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1455: l_record.sold_to_org_id := FND_API.G_MISS_NUM;

Line 1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;

1448: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1449: l_record.order_type_id := FND_API.G_MISS_NUM;
1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1455: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1456: --Bug 7347299

Line 1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

1449: l_record.order_type_id := FND_API.G_MISS_NUM;
1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1455: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1456: --Bug 7347299
1457: l_record.conversion_type_code := FND_API.G_MISS_CHAR;

Line 1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;

1450: l_record.agreement_id := FND_API.G_MISS_NUM;
1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1455: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1456: --Bug 7347299
1457: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1458:

Line 1455: l_record.sold_to_org_id := FND_API.G_MISS_NUM;

1451: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1452: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1455: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1456: --Bug 7347299
1457: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1458:
1459: l_out_record := l_record;

Line 1457: l_record.conversion_type_code := FND_API.G_MISS_CHAR;

1453: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1454: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1455: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1456: --Bug 7347299
1457: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1458:
1459: l_out_record := l_record;
1460:
1461: ONT_HEADER_Def_Hdlr.Default_Record

Line 1481: l_rec.agreement_id := FND_API.G_MISS_NUM;

1477: --Bug 7347299
1478: in_out_default_rec.conversion_type_code := l_out_record.conversion_type_code;
1479: -- code added to get the item identifier type
1480:
1481: l_rec.agreement_id := FND_API.G_MISS_NUM;
1482: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;

Line 1482: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;

1478: in_out_default_rec.conversion_type_code := l_out_record.conversion_type_code;
1479: -- code added to get the item identifier type
1480:
1481: l_rec.agreement_id := FND_API.G_MISS_NUM;
1482: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

Line 1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;

1479: -- code added to get the item identifier type
1480:
1481: l_rec.agreement_id := FND_API.G_MISS_NUM;
1482: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;

Line 1484: l_rec.line_type_id := FND_API.G_MISS_NUM;

1480:
1481: l_rec.agreement_id := FND_API.G_MISS_NUM;
1482: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;

Line 1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;

1481: l_rec.agreement_id := FND_API.G_MISS_NUM;
1482: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;
1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;

Line 1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

1482: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;
1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1490: l_rec.demand_class_code := FND_API.G_MISS_CHAR;

Line 1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;

1483: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;
1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1490: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1491: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;

Line 1488: l_rec.price_list_id := FND_API.G_MISS_NUM;

1484: l_rec.line_type_id := FND_API.G_MISS_NUM;
1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;
1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1490: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1491: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1492: l_out_rec := l_rec;

Line 1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;

1485: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;
1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1490: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1491: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1492: l_out_rec := l_rec;
1493:

Line 1490: l_rec.demand_class_code := FND_API.G_MISS_CHAR;

1486: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;
1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1490: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1491: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1492: l_out_rec := l_rec;
1493:
1494: ONT_LINE_DEF_HDLR.Default_record(

Line 1491: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;

1487: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1488: l_rec.price_list_id := FND_API.G_MISS_NUM;
1489: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1490: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1491: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1492: l_out_rec := l_rec;
1493:
1494: ONT_LINE_DEF_HDLR.Default_record(
1495: p_x_rec => l_out_rec,

Line 1528: WHEN FND_API.G_EXC_ERROR THEN

1524: END IF;
1525:
1526: EXCEPTION
1527:
1528: WHEN FND_API.G_EXC_ERROR THEN
1529:
1530: x_return_status := FND_API.G_RET_STS_ERROR;
1531:
1532: -- Get message count and data

Line 1530: x_return_status := FND_API.G_RET_STS_ERROR;

1526: EXCEPTION
1527:
1528: WHEN FND_API.G_EXC_ERROR THEN
1529:
1530: x_return_status := FND_API.G_RET_STS_ERROR;
1531:
1532: -- Get message count and data
1533:
1534: OE_MSG_PUB.Count_And_Get

Line 1539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1535: ( p_count => x_msg_count
1536: , p_data => x_msg_data
1537: );
1538:
1539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1540:
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1542:
1543: -- Get message count and data

Line 1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1537: );
1538:
1539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1540:
1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1542:
1543: -- Get message count and data
1544:
1545: OE_MSG_PUB.Count_And_Get

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1548: );
1549:
1550: WHEN OTHERS THEN
1551:
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1553:
1554: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1555: THEN
1556: OE_MSG_PUB.Add_Exc_Msg

Line 1928: if g_panda_rec_table(1).p_pricing_date is null or g_panda_rec_table(1).p_pricing_date = fnd_api.g_miss_date then

1924: -- Hold the header_id in line_id for 'HEADER' Records
1925:
1926: px_req_line_tbl(l_line_index).line_id := g_line_id;
1927:
1928: if g_panda_rec_table(1).p_pricing_date is null or g_panda_rec_table(1).p_pricing_date = fnd_api.g_miss_date then
1929: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
1930: Else
1931: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_panda_rec_table(1).p_pricing_date;
1932: End If;

Line 2039: g_panda_rec_table(p_line_index).p_pricing_date = fnd_api.g_miss_date then

2035: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
2036: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
2037:
2038: IF g_panda_rec_table(p_line_index).p_pricing_date is null or
2039: g_panda_rec_table(p_line_index).p_pricing_date = fnd_api.g_miss_date then
2040: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
2041: ELSE
2042: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_panda_rec_table(p_line_index).p_pricing_date;
2043: END IF;

Line 3626: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

3622:
3623:
3624: procedure Populate_Temp_Table
3625: IS
3626: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3627: l_return_status_Text varchar2(240) ;
3628: --
3629: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3630: --

Line 3674: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3670: --p_actual_order_qty => G_ACTUAL_ORDER_QTY_TBL,
3671: x_status_code =>l_return_status,
3672: x_status_text =>l_return_status_text);
3673:
3674: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3675: IF l_debug_level > 0 THEN
3676: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
3677: END IF;
3678: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 3681: RAISE FND_API.G_EXC_ERROR;

3677: END IF;
3678: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3679: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3680: OE_MSG_PUB.Add;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683:
3684: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
3685: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 3719: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3715: G_ATTR_PRIMARY_UOM_FLAG_TBL,
3716: l_return_status ,
3717: l_return_status_text );
3718:
3719: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3720: IF l_debug_level > 0 THEN
3721: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
3722: END IF;
3723: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 3726: raise fnd_api.g_exc_unexpected_error;

3722: END IF;
3723: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3724: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3725: OE_MSG_PUB.Add;
3726: raise fnd_api.g_exc_unexpected_error;
3727: END IF;
3728:
3729: END IF;
3730: IF l_debug_level > 0 THEN

Line 3736: RAISE FND_API.G_EXC_ERROR;

3732: END IF;
3733:
3734: EXCEPTION
3735: WHEN OTHERS THEN
3736: RAISE FND_API.G_EXC_ERROR;
3737: END POPULATE_TEMP_TABLE;
3738:
3739:
3740: PROCEDURE Populate_results

Line 4018: IF l_status_code = FND_API.G_RET_STS_ERROR THEN

4014: x_line_detail_tbl(I).CALCULATION_CODE := l_dets.CALCULATION_CODE;
4015: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
4016: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
4017:
4018: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
4019: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
4020: IF l_debug_level > 0 then
4021: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
4022: END IF;

Line 4019: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

4015: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
4016: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
4017:
4018: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
4019: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
4020: IF l_debug_level > 0 then
4021: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
4022: END IF;
4023: --END IF;

Line 4031: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

4027: END LOOP;
4028: I:=1;
4029:
4030: --Populate Qualifier detail
4031: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
4032: IF l_debug_level > 0 then
4033: oe_debug_pub.add('----Before populate x_qual_tbl-----');
4034: END IF;
4035: --END IF;

Line 5009: x_status_code := FND_API.G_RET_STS_ERROR;

5005: oe_debug_pub.add('end of inserting');
5006:
5007: EXCEPTION
5008: WHEN OTHERS THEN
5009: x_status_code := FND_API.G_RET_STS_ERROR;
5010: x_status_text :=SQLERRM;
5011: oe_debug_pub.add('insert into ldets'||x_status_code||'error'||x_status_text);
5012: END Insert_Manual_Adjustment;
5013:

Line 5115: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then

5111: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
5112: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
5113:
5114: If OE_Order_PUB.G_Line.agreement_id is not null and
5115: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
5116: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
5117: Else
5118: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
5119: End If;

Line 5221: FND_API.G_RET_STS_UNEXP_ERROR,

5217: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5218: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5219: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 5222: FND_API.G_RET_STS_ERROR,

5218: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5219: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5220: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5221: FND_API.G_RET_STS_UNEXP_ERROR,
5222: FND_API.G_RET_STS_ERROR,
5223: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5224: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5225: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5226: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

Line 5284: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

5280: OE_MSG_PUB.Add;
5281:
5282:
5283: ELSIF in_status_code in
5284: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5285: FND_API.G_RET_STS_ERROR) then
5286: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5288: OE_MSG_PUB.Add;

Line 5285: FND_API.G_RET_STS_ERROR) then

5281:
5282:
5283: ELSIF in_status_code in
5284: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5285: FND_API.G_RET_STS_ERROR) then
5286: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5288: OE_MSG_PUB.Add;
5289:

Line 5471: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,

5467: IF l_return_status IN('E','W') then
5468: IF l_debug_level > 0 THEN
5469: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
5470: END IF;
5471: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
5472: p_count => l_msg_count,
5473: p_data=>l_msg_data
5474: );
5475: END IF;

Line 5506: If l_rounding_factor = fnd_api.g_miss_num then

5502: into l_rounding_factor
5503: from qp_list_headers_b
5504: where list_header_id = p_list_header_id;
5505:
5506: If l_rounding_factor = fnd_api.g_miss_num then
5507: l_rounding_factor:= Null;
5508: End If;
5509:
5510: Return l_rounding_factor;

Line 5901: IF l_meaning = fnd_api.g_miss_char then

5897: FROM qp_lookups
5898: WHERE lookup_type = in_lookup_type
5899: AND lookup_code = in_lookup_code;
5900:
5901: IF l_meaning = fnd_api.g_miss_char then
5902: l_meaning:= Null;
5903: END IF;
5904:
5905: Return l_meaning;

Line 6673: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,

6669: IF nvl(x_return_status,'E') <> 'S' then
6670: IF l_debug_level > 0 THEN
6671: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
6672: END IF;
6673: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
6674: p_count => x_msg_count,
6675: p_data=>x_msg_data
6676: );
6677: IF l_debug_level > 0 THEN

Line 6695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6691: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
6692: END IF;
6693:
6694: x_return_status := 'E';
6695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6696:
6697: -- Get message count and data
6698: OE_MSG_PUB.Count_And_Get
6699: ( p_count => x_msg_count

Line 6709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6705: ( G_PKG_NAME,
6706: 'Get_Global_Availability');
6707: END IF;
6708:
6709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6710:
6711: END get_global_availability;
6712:
6713:

Line 8077: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

8073: G_PR_AV:='Y' ; -- bug7380336
8074: OE_VALIDATE_LINE.Validate_Flex(
8075: p_x_line_rec => p_x_line_rec,
8076: p_old_line_rec => p_old_line_rec,
8077: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8078: x_return_status => x_return_status
8079: );
8080: oe_debug_pub.add('Pricing AVa,Attribute1 '||p_x_line_rec.attribute1,1);
8081: oe_debug_pub.add('Pricing AVa,Attribute1-Return'||x_return_status,1);

Line 8084: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8080: oe_debug_pub.add('Pricing AVa,Attribute1 '||p_x_line_rec.attribute1,1);
8081: oe_debug_pub.add('Pricing AVa,Attribute1-Return'||x_return_status,1);
8082: G_PR_AV:='N' ; -- bug7380336
8083:
8084: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8085: OE_GLOBALS.g_validate_desc_flex:='N';
8086: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8087: OE_GLOBALS.g_validate_desc_flex:='N';
8088: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN

Line 8086: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

8082: G_PR_AV:='N' ; -- bug7380336
8083:
8084: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8085: OE_GLOBALS.g_validate_desc_flex:='N';
8086: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8087: OE_GLOBALS.g_validate_desc_flex:='N';
8088: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
8089: null;
8090: END IF;

Line 8088: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN

8084: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8085: OE_GLOBALS.g_validate_desc_flex:='N';
8086: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8087: OE_GLOBALS.g_validate_desc_flex:='N';
8088: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
8089: null;
8090: END IF;
8091: x_return_status := FND_API.G_RET_STS_SUCCESS;
8092: END LOOP;

Line 8091: x_return_status := FND_API.G_RET_STS_SUCCESS;

8087: OE_GLOBALS.g_validate_desc_flex:='N';
8088: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
8089: null;
8090: END IF;
8091: x_return_status := FND_API.G_RET_STS_SUCCESS;
8092: END LOOP;
8093: END IF;
8094:
8095: OE_Order_PVT.Process_order

Line 8097: , p_init_msg_list => FND_API.G_TRUE

8093: END IF;
8094:
8095: OE_Order_PVT.Process_order
8096: ( p_api_version_number => 1.0
8097: , p_init_msg_list => FND_API.G_TRUE
8098: , x_return_status => x_return_status
8099: , x_msg_count => x_msg_count
8100: , x_msg_data => x_msg_data
8101: -- , p_control_rec => l_control_rec

Line 8102: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE

8098: , x_return_status => x_return_status
8099: , x_msg_count => x_msg_count
8100: , x_msg_data => x_msg_data
8101: -- , p_control_rec => l_control_rec
8102: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE
8103: , p_x_header_Rec => l_header_rec
8104: , p_x_line_tbl => l_line_tbl
8105: -- , p_line_adj_tbl => l_line_adj_tbl
8106: , p_x_action_request_tbl => l_action_request_tbl

Line 8128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

8124: print_time('After Calling Process Order Return ');
8125: END IF;
8126:
8127: -- Check the status and print appropriate messages
8128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
8129:
8130: IF l_debug_level > 0 THEN
8131: oe_debug_pub.add('error in process order 1',1);
8132: oe_Debug_pub.add('ERROR while creating order!');

Line 8222: --x_return_status := 'E'; --fnd_api.g_ret_sts_error;

8218: if l_booked_flag <> 'Y' then
8219:
8220: IF l_debug_level > 0 THEN
8221: oe_Debug_pub.add('There was an error during the booking activity.');
8222: --x_return_status := 'E'; --fnd_api.g_ret_sts_error;
8223: END IF;
8224: else
8225: IF l_debug_level > 0 THEN
8226: oe_Debug_pub.add('Order booked but line not interfaced to shipping.');

Line 8228: --x_return_status := fnd_api.g_ret_sts_error;

8224: else
8225: IF l_debug_level > 0 THEN
8226: oe_Debug_pub.add('Order booked but line not interfaced to shipping.');
8227: oe_Debug_pub.add('There was a failure either in scheduling or shipping interface activity.');
8228: --x_return_status := fnd_api.g_ret_sts_error;
8229: END IF;
8230: end if;
8231:
8232: ELSE

Line 8245: IF x_return_status <> fnd_api.g_ret_sts_success then

8241: END IF; -- if interfaced to shipping
8242:
8243: END IF;
8244:
8245: IF x_return_status <> fnd_api.g_ret_sts_success then
8246:
8247: -- Print out the error messages, if any
8248:
8249: IF l_debug_level > 0 THEN

Line 8275: WHEN FND_API.G_EXC_ERROR THEN

8271:
8272:
8273: EXCEPTION
8274:
8275: WHEN FND_API.G_EXC_ERROR THEN
8276:
8277: x_return_status := FND_API.G_RET_STS_ERROR;
8278:
8279: -- Get message count and data

Line 8277: x_return_status := FND_API.G_RET_STS_ERROR;

8273: EXCEPTION
8274:
8275: WHEN FND_API.G_EXC_ERROR THEN
8276:
8277: x_return_status := FND_API.G_RET_STS_ERROR;
8278:
8279: -- Get message count and data
8280:
8281: OE_MSG_PUB.Count_And_Get

Line 8286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8282: ( p_count => x_msg_count
8283: , p_data => x_msg_data
8284: );
8285:
8286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8287:
8288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8289:
8290: -- Get message count and data

Line 8288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8284: );
8285:
8286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8287:
8288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8289:
8290: -- Get message count and data
8291:
8292: OE_MSG_PUB.Count_And_Get

Line 8299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8295: );
8296:
8297: WHEN OTHERS THEN
8298:
8299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8300:
8301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8302: THEN
8303: OE_MSG_PUB.Add_Exc_Msg

Line 8438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8434: 'Get_Form_Startup_Values'
8435: );
8436: END IF;
8437:
8438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8439:
8440:
8441: END Get_Form_Startup_Values;
8442: