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_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 601: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

768: ( G_PKG_NAME,
769: 'Call_MRP_ATP');
770: END IF;
771:
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773:
774: END Call_MRP_ATP;
775:
776: Procedure Enforce_price_list(in_order_type_id in number,

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

851: l_rec.inventory_item_id := in_item_id;
852: l_rec.org_id := in_org_id;
853: l_rec.sold_to_org_id := in_customer_id;
854: l_rec.ship_to_org_id := in_ship_to_org_id;
855: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
856: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
857: --l_rec.price_list_id := FND_API.G_MISS_NUM;
858:
859: l_out_rec := l_rec;

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

852: l_rec.org_id := in_org_id;
853: l_rec.sold_to_org_id := in_customer_id;
854: l_rec.ship_to_org_id := in_ship_to_org_id;
855: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
856: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
857: --l_rec.price_list_id := FND_API.G_MISS_NUM;
858:
859: l_out_rec := l_rec;
860:

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

853: l_rec.sold_to_org_id := in_customer_id;
854: l_rec.ship_to_org_id := in_ship_to_org_id;
855: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
856: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
857: --l_rec.price_list_id := FND_API.G_MISS_NUM;
858:
859: l_out_rec := l_rec;
860:
861: ONT_LINE_DEF_HDLR.Default_record(

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

898: l_record.org_id := in_org_id;
899: l_record.ship_to_org_id := in_ship_to_org_id;
900: l_record.agreement_id := in_agreement_id;
901: l_record.invoice_to_org_id := in_bill_to_org_id;
902: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
903: l_record.price_list_id := FND_API.G_MISS_NUM;
904:
905: l_out_record := l_record;
906:

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

899: l_record.ship_to_org_id := in_ship_to_org_id;
900: l_record.agreement_id := in_agreement_id;
901: l_record.invoice_to_org_id := in_bill_to_org_id;
902: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
903: l_record.price_list_id := FND_API.G_MISS_NUM;
904:
905: l_out_record := l_record;
906:
907: ONT_HEADER_Def_Hdlr.Default_Record

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

925: l_record.org_id := in_org_id;
926: l_record.ship_to_org_id := in_ship_to_org_id;
927: l_record.agreement_id := in_agreement_id;
928: l_record.invoice_to_org_id := in_bill_to_org_id;
929: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
930: l_record.price_list_id := FND_API.G_MISS_NUM;
931:
932: l_out_record := l_record;
933:

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

926: l_record.ship_to_org_id := in_ship_to_org_id;
927: l_record.agreement_id := in_agreement_id;
928: l_record.invoice_to_org_id := in_bill_to_org_id;
929: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
930: l_record.price_list_id := FND_API.G_MISS_NUM;
931:
932: l_out_record := l_record;
933:
934: ONT_HEADER_Def_Hdlr.Default_Record

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

952: l_record.org_id := in_org_id;
953: l_record.ship_to_org_id := in_ship_to_org_id;
954: l_record.agreement_id := in_agreement_id;
955: l_record.invoice_to_org_id := in_bill_to_org_id;
956: l_record.price_list_id := FND_API.G_MISS_NUM;
957:
958: l_out_record := l_record;
959:
960: ONT_HEADER_Def_Hdlr.Default_Record

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

979: l_rec.ship_to_org_id := in_ship_to_org_id;
980: l_rec.invoice_to_org_id := in_bill_to_org_id;
981: l_rec.sold_to_org_id := in_customer_id;
982: l_rec.org_id := in_org_id;
983: l_rec.price_list_id := FND_API.G_MISS_NUM;
984:
985: l_out_rec := l_rec;
986:
987: ONT_LINE_DEF_HDLR.Default_record(

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

1001: ELSIF in_source = 'ORDER_TYPE' then
1002:
1003: l_record.org_id := in_org_id;
1004: l_record.order_type_id := in_order_type_id;
1005: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1006:
1007: l_out_record := l_record;
1008:
1009:

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

1027: ELSIF in_source = 'STARTUP' then
1028:
1029: l_record.org_id := in_org_id;
1030:
1031: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1032: l_record.price_list_id := FND_API.G_MISS_NUM;
1033: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1034:
1035: l_out_record := l_record;

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

1028:
1029: l_record.org_id := in_org_id;
1030:
1031: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1032: l_record.price_list_id := FND_API.G_MISS_NUM;
1033: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1034:
1035: l_out_record := l_record;
1036:

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

1029: l_record.org_id := in_org_id;
1030:
1031: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1032: l_record.price_list_id := FND_API.G_MISS_NUM;
1033: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1034:
1035: l_out_record := l_record;
1036:
1037: ONT_HEADER_Def_Hdlr.Default_Record

Line 1061: WHEN FND_API.G_EXC_ERROR THEN

1057: END IF;
1058:
1059: EXCEPTION
1060:
1061: WHEN FND_API.G_EXC_ERROR THEN
1062:
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064:
1065: -- Get message count and data

Line 1063: x_return_status := FND_API.G_RET_STS_ERROR;

1059: EXCEPTION
1060:
1061: WHEN FND_API.G_EXC_ERROR THEN
1062:
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064:
1065: -- Get message count and data
1066:
1067: OE_MSG_PUB.Count_And_Get

Line 1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1068: ( p_count => x_msg_count
1069: , p_data => x_msg_data
1070: );
1071:
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073:
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075:
1076: -- Get message count and data

Line 1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1070: );
1071:
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073:
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075:
1076: -- Get message count and data
1077:
1078: OE_MSG_PUB.Count_And_Get

Line 1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1081: );
1082:
1083: WHEN OTHERS THEN
1084:
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1086:
1087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1088: THEN
1089: OE_MSG_PUB.Add_Exc_Msg

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

1164: l_rec.request_date := in_out_default_rec.request_date;
1165: l_rec.price_list_id := in_out_default_rec.price_list_id;
1166: l_rec.line_type_id := in_out_default_rec.line_type_id;
1167: l_rec.demand_class_code := in_out_default_rec.demand_class_code;
1168: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1169: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1170: l_out_rec := l_rec;
1171:
1172:

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

1165: l_rec.price_list_id := in_out_default_rec.price_list_id;
1166: l_rec.line_type_id := in_out_default_rec.line_type_id;
1167: l_rec.demand_class_code := in_out_default_rec.demand_class_code;
1168: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1169: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1170: l_out_rec := l_rec;
1171:
1172:
1173: ONT_LINE_DEF_HDLR.Default_record(

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

1209: --l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code;commented for bug 15923529
1210: l_record.created_by := in_out_default_rec.created_by;
1211: l_record.request_date := in_out_default_rec.request_date;
1212: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1213: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1214: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1215: l_record.price_list_id := FND_API.G_MISS_NUM;
1216: l_record.order_type_id := FND_API.G_MISS_NUM;
1217: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

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

1210: l_record.created_by := in_out_default_rec.created_by;
1211: l_record.request_date := in_out_default_rec.request_date;
1212: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1213: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1214: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1215: l_record.price_list_id := FND_API.G_MISS_NUM;
1216: l_record.order_type_id := FND_API.G_MISS_NUM;
1217: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1218: l_record.agreement_id := FND_API.G_MISS_NUM;

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

1211: l_record.request_date := in_out_default_rec.request_date;
1212: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1213: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1214: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1215: l_record.price_list_id := FND_API.G_MISS_NUM;
1216: l_record.order_type_id := FND_API.G_MISS_NUM;
1217: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1218: l_record.agreement_id := FND_API.G_MISS_NUM;
1219: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529

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

1212: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1213: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1214: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1215: l_record.price_list_id := FND_API.G_MISS_NUM;
1216: l_record.order_type_id := FND_API.G_MISS_NUM;
1217: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1218: l_record.agreement_id := FND_API.G_MISS_NUM;
1219: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1220: l_out_record := l_record;

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

1213: l_record.ship_To_org_id := FND_API.G_MISS_NUM;
1214: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1215: l_record.price_list_id := FND_API.G_MISS_NUM;
1216: l_record.order_type_id := FND_API.G_MISS_NUM;
1217: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1218: l_record.agreement_id := FND_API.G_MISS_NUM;
1219: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1220: l_out_record := l_record;
1221:

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

1214: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1215: l_record.price_list_id := FND_API.G_MISS_NUM;
1216: l_record.order_type_id := FND_API.G_MISS_NUM;
1217: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1218: l_record.agreement_id := FND_API.G_MISS_NUM;
1219: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1220: l_out_record := l_record;
1221:
1222: ONT_HEADER_Def_Hdlr.Default_Record

Line 1219: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529

1215: l_record.price_list_id := FND_API.G_MISS_NUM;
1216: l_record.order_type_id := FND_API.G_MISS_NUM;
1217: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1218: l_record.agreement_id := FND_API.G_MISS_NUM;
1219: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1220: l_out_record := l_record;
1221:
1222: ONT_HEADER_Def_Hdlr.Default_Record
1223: ( p_x_rec => l_out_record

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

1244: l_record.created_by := in_out_default_rec.created_by;
1245: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1246: --l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code; commented for bug 15923529
1247: l_record.request_date := in_out_default_rec.request_date;
1248: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1249: l_record.price_list_id := FND_API.G_MISS_NUM;
1250: l_record.order_type_id := FND_API.G_MISS_NUM;
1251: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1252: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

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

1245: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1246: --l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code; commented for bug 15923529
1247: l_record.request_date := in_out_default_rec.request_date;
1248: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1249: l_record.price_list_id := FND_API.G_MISS_NUM;
1250: l_record.order_type_id := FND_API.G_MISS_NUM;
1251: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1252: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1253: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529

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

1246: --l_record.transactional_curr_code := in_out_default_rec.transactional_curr_code; commented for bug 15923529
1247: l_record.request_date := in_out_default_rec.request_date;
1248: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1249: l_record.price_list_id := FND_API.G_MISS_NUM;
1250: l_record.order_type_id := FND_API.G_MISS_NUM;
1251: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1252: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1253: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1254:

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

1247: l_record.request_date := in_out_default_rec.request_date;
1248: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1249: l_record.price_list_id := FND_API.G_MISS_NUM;
1250: l_record.order_type_id := FND_API.G_MISS_NUM;
1251: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1252: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1253: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1254:
1255: l_out_record := l_record;

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

1248: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1249: l_record.price_list_id := FND_API.G_MISS_NUM;
1250: l_record.order_type_id := FND_API.G_MISS_NUM;
1251: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1252: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1253: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1254:
1255: l_out_record := l_record;
1256:

Line 1253: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529

1249: l_record.price_list_id := FND_API.G_MISS_NUM;
1250: l_record.order_type_id := FND_API.G_MISS_NUM;
1251: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1252: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1253: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1254:
1255: l_out_record := l_record;
1256:
1257: ONT_HEADER_Def_Hdlr.Default_Record

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

1278: l_record.ship_from_org_id := in_out_default_rec.ship_from_org_id;
1279: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1280: l_record.created_by := in_out_default_rec.created_by;
1281: l_record.request_date := in_out_default_rec.request_date;
1282: l_record.price_list_id := FND_API.G_MISS_NUM;
1283: l_record.order_type_id := FND_API.G_MISS_NUM;
1284: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1285: l_out_record := l_record;
1286:

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

1279: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1280: l_record.created_by := in_out_default_rec.created_by;
1281: l_record.request_date := in_out_default_rec.request_date;
1282: l_record.price_list_id := FND_API.G_MISS_NUM;
1283: l_record.order_type_id := FND_API.G_MISS_NUM;
1284: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1285: l_out_record := l_record;
1286:
1287: ONT_HEADER_Def_Hdlr.Default_Record

Line 1284: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529

1280: l_record.created_by := in_out_default_rec.created_by;
1281: l_record.request_date := in_out_default_rec.request_date;
1282: l_record.price_list_id := FND_API.G_MISS_NUM;
1283: l_record.order_type_id := FND_API.G_MISS_NUM;
1284: l_record.transactional_curr_code := FND_API.G_MISS_CHAR; --for testing bug 15923529
1285: l_out_record := l_record;
1286:
1287: ONT_HEADER_Def_Hdlr.Default_Record
1288: ( p_x_rec => l_out_record

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

1308: l_rec.demand_class_code := in_out_default_rec.demand_class_code;
1309: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1310: l_rec.org_id := in_out_default_rec.org_id;
1311: l_rec.created_by := in_out_default_rec.created_by;
1312: l_rec.price_list_id := FND_API.G_MISS_NUM;
1313: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1314: l_out_rec := l_rec;
1315:
1316:

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

1309: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1310: l_rec.org_id := in_out_default_rec.org_id;
1311: l_rec.created_by := in_out_default_rec.created_by;
1312: l_rec.price_list_id := FND_API.G_MISS_NUM;
1313: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1314: l_out_rec := l_rec;
1315:
1316:
1317:

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

1333: l_record.org_id := in_out_default_rec.org_id;
1334: l_record.created_by := in_out_default_rec.created_by;
1335: l_record.price_list_id := in_out_default_rec.price_list_id;
1336: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1337: l_record.transactional_curr_code :=FND_API.G_MISS_CHAR;
1338: l_out_record := l_record;
1339:
1340: ONT_HEADER_Def_Hdlr.Default_Record
1341: ( p_x_rec => l_out_record

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

1357: l_record.invoice_to_org_id := in_out_default_rec.invoice_to_org_id;
1358: l_record.created_by := in_out_default_rec.created_by;
1359: l_record.request_date := in_out_default_rec.request_date;
1360: --Bug 7347299
1361: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1362:
1363: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1364: l_record.price_list_id := FND_API.G_MISS_NUM;
1365: l_record.ship_from_org_id := FND_API.G_MISS_NUM;

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

1359: l_record.request_date := in_out_default_rec.request_date;
1360: --Bug 7347299
1361: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1362:
1363: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1364: l_record.price_list_id := FND_API.G_MISS_NUM;
1365: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1366: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1367: l_out_record := l_record;

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

1360: --Bug 7347299
1361: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1362:
1363: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1364: l_record.price_list_id := FND_API.G_MISS_NUM;
1365: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1366: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1367: l_out_record := l_record;
1368:

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

1361: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1362:
1363: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1364: l_record.price_list_id := FND_API.G_MISS_NUM;
1365: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1366: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1367: l_out_record := l_record;
1368:
1369:

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

1362:
1363: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1364: l_record.price_list_id := FND_API.G_MISS_NUM;
1365: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1366: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1367: l_out_record := l_record;
1368:
1369:
1370: ONT_HEADER_Def_Hdlr.Default_Record

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

1395: l_rec.created_by := in_out_default_rec.created_by;
1396: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1397: l_rec.org_id := in_out_default_rec.org_id;
1398:
1399: l_rec.price_list_id := FND_API.G_MISS_NUM;
1400: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1401: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1402: l_out_rec := l_rec;
1403:

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

1396: l_rec.sold_to_org_id := in_out_default_rec.sold_to_org_id;
1397: l_rec.org_id := in_out_default_rec.org_id;
1398:
1399: l_rec.price_list_id := FND_API.G_MISS_NUM;
1400: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1401: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1402: l_out_rec := l_rec;
1403:
1404: ONT_LINE_DEF_HDLR.Default_record(

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

1397: l_rec.org_id := in_out_default_rec.org_id;
1398:
1399: l_rec.price_list_id := FND_API.G_MISS_NUM;
1400: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1401: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1402: l_out_rec := l_rec;
1403:
1404: ONT_LINE_DEF_HDLR.Default_record(
1405: p_x_rec => l_out_rec,

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

1427: l_record.demand_class_code := in_out_default_rec.demand_class_code;
1428: l_record.price_list_id := in_out_default_rec.price_list_id;
1429: l_record.ship_from_org_id := in_out_default_rec.ship_from_org_id;
1430:
1431: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1432: l_out_record := l_record;
1433: ONT_HEADER_Def_Hdlr.Default_Record
1434: ( p_x_rec => l_out_record
1435: , p_initial_rec => l_record

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

1453: l_rec.request_date := in_out_default_rec.request_date;
1454:
1455:
1456:
1457: l_record.price_list_id := FND_API.G_MISS_NUM;
1458: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1459: l_record.order_type_id := FND_API.G_MISS_NUM;
1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;

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

1454:
1455:
1456:
1457: l_record.price_list_id := FND_API.G_MISS_NUM;
1458: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1459: l_record.order_type_id := FND_API.G_MISS_NUM;
1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;

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

1455:
1456:
1457: l_record.price_list_id := FND_API.G_MISS_NUM;
1458: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1459: l_record.order_type_id := FND_API.G_MISS_NUM;
1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;

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

1456:
1457: l_record.price_list_id := FND_API.G_MISS_NUM;
1458: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1459: l_record.order_type_id := FND_API.G_MISS_NUM;
1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1464: l_record.ship_to_org_id := FND_API.G_MISS_NUM;

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

1457: l_record.price_list_id := FND_API.G_MISS_NUM;
1458: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1459: l_record.order_type_id := FND_API.G_MISS_NUM;
1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1464: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1465: l_record.sold_to_org_id := FND_API.G_MISS_NUM;

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

1458: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
1459: l_record.order_type_id := FND_API.G_MISS_NUM;
1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1464: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1465: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1466: --Bug 7347299

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

1459: l_record.order_type_id := FND_API.G_MISS_NUM;
1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1464: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1465: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1466: --Bug 7347299
1467: l_record.conversion_type_code := FND_API.G_MISS_CHAR;

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

1460: l_record.agreement_id := FND_API.G_MISS_NUM;
1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1464: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1465: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1466: --Bug 7347299
1467: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1468:

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

1461: l_record.demand_class_code := FND_API.G_MISS_CHAR;
1462: l_record.transactional_curr_code := FND_API.G_MISS_CHAR;
1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1464: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1465: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1466: --Bug 7347299
1467: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1468:
1469: l_out_record := l_record;

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

1463: l_record.invoice_to_org_id := FND_API.G_MISS_NUM;
1464: l_record.ship_to_org_id := FND_API.G_MISS_NUM;
1465: l_record.sold_to_org_id := FND_API.G_MISS_NUM;
1466: --Bug 7347299
1467: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
1468:
1469: l_out_record := l_record;
1470:
1471: ONT_HEADER_Def_Hdlr.Default_Record

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

1487: --Bug 7347299
1488: in_out_default_rec.conversion_type_code := l_out_record.conversion_type_code;
1489: -- code added to get the item identifier type
1490:
1491: l_rec.agreement_id := FND_API.G_MISS_NUM;
1492: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1493: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;

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

1488: in_out_default_rec.conversion_type_code := l_out_record.conversion_type_code;
1489: -- code added to get the item identifier type
1490:
1491: l_rec.agreement_id := FND_API.G_MISS_NUM;
1492: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1493: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

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

1489: -- code added to get the item identifier type
1490:
1491: l_rec.agreement_id := FND_API.G_MISS_NUM;
1492: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1493: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;

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

1490:
1491: l_rec.agreement_id := FND_API.G_MISS_NUM;
1492: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1493: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;

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

1491: l_rec.agreement_id := FND_API.G_MISS_NUM;
1492: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1493: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;
1499: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;

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

1492: l_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1493: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;
1499: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1500: l_rec.demand_class_code := FND_API.G_MISS_CHAR;

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

1493: l_rec.inventory_item_id := FND_API.G_MISS_NUM;
1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;
1499: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1500: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1501: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;

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

1494: l_rec.line_type_id := FND_API.G_MISS_NUM;
1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;
1499: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1500: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1501: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1502: l_out_rec := l_rec;

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

1495: l_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;
1499: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1500: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1501: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1502: l_out_rec := l_rec;
1503:

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

1496: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;
1499: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1500: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1501: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1502: l_out_rec := l_rec;
1503:
1504: ONT_LINE_DEF_HDLR.Default_record(

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

1497: l_rec.sold_to_org_id :=FND_API.G_MISS_NUM;
1498: l_rec.price_list_id := FND_API.G_MISS_NUM;
1499: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1500: l_rec.demand_class_code := FND_API.G_MISS_CHAR;
1501: l_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1502: l_out_rec := l_rec;
1503:
1504: ONT_LINE_DEF_HDLR.Default_record(
1505: p_x_rec => l_out_rec,

Line 1538: WHEN FND_API.G_EXC_ERROR THEN

1534: END IF;
1535:
1536: EXCEPTION
1537:
1538: WHEN FND_API.G_EXC_ERROR THEN
1539:
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541:
1542: -- Get message count and data

Line 1540: x_return_status := FND_API.G_RET_STS_ERROR;

1536: EXCEPTION
1537:
1538: WHEN FND_API.G_EXC_ERROR THEN
1539:
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541:
1542: -- Get message count and data
1543:
1544: OE_MSG_PUB.Count_And_Get

Line 1549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1545: ( p_count => x_msg_count
1546: , p_data => x_msg_data
1547: );
1548:
1549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1550:
1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1552:
1553: -- Get message count and data

Line 1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1547: );
1548:
1549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1550:
1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1552:
1553: -- Get message count and data
1554:
1555: OE_MSG_PUB.Count_And_Get

Line 1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1558: );
1559:
1560: WHEN OTHERS THEN
1561:
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1563:
1564: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1565: THEN
1566: OE_MSG_PUB.Add_Exc_Msg

Line 1938: 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

1934: -- Hold the header_id in line_id for 'HEADER' Records
1935:
1936: px_req_line_tbl(l_line_index).line_id := g_line_id;
1937:
1938: 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
1939: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
1940: Else
1941: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_panda_rec_table(1).p_pricing_date;
1942: End If;

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

2045: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
2046: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
2047:
2048: IF g_panda_rec_table(p_line_index).p_pricing_date is null or
2049: g_panda_rec_table(p_line_index).p_pricing_date = fnd_api.g_miss_date then
2050: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
2051: ELSE
2052: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_panda_rec_table(p_line_index).p_pricing_date;
2053: END IF;

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

3647:
3648:
3649: procedure Populate_Temp_Table
3650: IS
3651: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
3652: l_return_status_Text varchar2(240) ;
3653: --
3654: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3655: --

Line 3699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3695: --p_actual_order_qty => G_ACTUAL_ORDER_QTY_TBL,
3696: x_status_code =>l_return_status,
3697: x_status_text =>l_return_status_text);
3698:
3699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: IF l_debug_level > 0 THEN
3701: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
3702: END IF;
3703: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 3706: RAISE FND_API.G_EXC_ERROR;

3702: END IF;
3703: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3704: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3705: OE_MSG_PUB.Add;
3706: RAISE FND_API.G_EXC_ERROR;
3707: END IF;
3708:
3709: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
3710: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 3744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3740: G_ATTR_PRIMARY_UOM_FLAG_TBL,
3741: l_return_status ,
3742: l_return_status_text );
3743:
3744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3745: IF l_debug_level > 0 THEN
3746: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
3747: END IF;
3748: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 3751: raise fnd_api.g_exc_unexpected_error;

3747: END IF;
3748: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3749: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3750: OE_MSG_PUB.Add;
3751: raise fnd_api.g_exc_unexpected_error;
3752: END IF;
3753:
3754: END IF;
3755: IF l_debug_level > 0 THEN

Line 3761: RAISE FND_API.G_EXC_ERROR;

3757: END IF;
3758:
3759: EXCEPTION
3760: WHEN OTHERS THEN
3761: RAISE FND_API.G_EXC_ERROR;
3762: END POPULATE_TEMP_TABLE;
3763:
3764:
3765: PROCEDURE Populate_results

Line 4043: IF l_status_code = FND_API.G_RET_STS_ERROR THEN

4039: x_line_detail_tbl(I).CALCULATION_CODE := l_dets.CALCULATION_CODE;
4040: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
4041: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
4042:
4043: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
4044: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
4045: IF l_debug_level > 0 then
4046: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
4047: END IF;

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

4040: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
4041: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
4042:
4043: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
4044: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
4045: IF l_debug_level > 0 then
4046: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
4047: END IF;
4048: --END IF;

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

4052: END LOOP;
4053: I:=1;
4054:
4055: --Populate Qualifier detail
4056: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
4057: IF l_debug_level > 0 then
4058: oe_debug_pub.add('----Before populate x_qual_tbl-----');
4059: END IF;
4060: --END IF;

Line 5034: x_status_code := FND_API.G_RET_STS_ERROR;

5030: oe_debug_pub.add('end of inserting');
5031:
5032: EXCEPTION
5033: WHEN OTHERS THEN
5034: x_status_code := FND_API.G_RET_STS_ERROR;
5035: x_status_text :=SQLERRM;
5036: oe_debug_pub.add('insert into ldets'||x_status_code||'error'||x_status_text);
5037: END Insert_Manual_Adjustment;
5038:

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

5136: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
5137: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
5138:
5139: If OE_Order_PUB.G_Line.agreement_id is not null and
5140: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
5141: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
5142: Else
5143: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
5144: End If;

Line 5246: FND_API.G_RET_STS_UNEXP_ERROR,

5242: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
5243: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5244: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 5247: FND_API.G_RET_STS_ERROR,

5243: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
5244: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
5245: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
5246: FND_API.G_RET_STS_UNEXP_ERROR,
5247: FND_API.G_RET_STS_ERROR,
5248: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
5249: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
5250: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
5251: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

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

5305: OE_MSG_PUB.Add;
5306:
5307:
5308: ELSIF in_status_code in
5309: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5310: FND_API.G_RET_STS_ERROR) then
5311: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5312: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5313: OE_MSG_PUB.Add;

Line 5310: FND_API.G_RET_STS_ERROR) then

5306:
5307:
5308: ELSIF in_status_code in
5309: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5310: FND_API.G_RET_STS_ERROR) then
5311: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5312: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5313: OE_MSG_PUB.Add;
5314:

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

5492: IF l_return_status IN('E','W') then
5493: IF l_debug_level > 0 THEN
5494: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
5495: END IF;
5496: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
5497: p_count => l_msg_count,
5498: p_data=>l_msg_data
5499: );
5500: END IF;

Line 5531: If l_rounding_factor = fnd_api.g_miss_num then

5527: into l_rounding_factor
5528: from qp_list_headers_b
5529: where list_header_id = p_list_header_id;
5530:
5531: If l_rounding_factor = fnd_api.g_miss_num then
5532: l_rounding_factor:= Null;
5533: End If;
5534:
5535: Return l_rounding_factor;

Line 5926: IF l_meaning = fnd_api.g_miss_char then

5922: FROM qp_lookups
5923: WHERE lookup_type = in_lookup_type
5924: AND lookup_code = in_lookup_code;
5925:
5926: IF l_meaning = fnd_api.g_miss_char then
5927: l_meaning:= Null;
5928: END IF;
5929:
5930: Return l_meaning;

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

6694: IF nvl(x_return_status,'E') <> 'S' then
6695: IF l_debug_level > 0 THEN
6696: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
6697: END IF;
6698: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
6699: p_count => x_msg_count,
6700: p_data=>x_msg_data
6701: );
6702: IF l_debug_level > 0 THEN

Line 6720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6716: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
6717: END IF;
6718:
6719: x_return_status := 'E';
6720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6721:
6722: -- Get message count and data
6723: OE_MSG_PUB.Count_And_Get
6724: ( p_count => x_msg_count

Line 6734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6730: ( G_PKG_NAME,
6731: 'Get_Global_Availability');
6732: END IF;
6733:
6734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6735:
6736: END get_global_availability;
6737:
6738:

Line 8102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

8098: G_PR_AV:='Y' ; -- bug7380336
8099: OE_VALIDATE_LINE.Validate_Flex(
8100: p_x_line_rec => p_x_line_rec,
8101: p_old_line_rec => p_old_line_rec,
8102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
8103: x_return_status => x_return_status
8104: );
8105: oe_debug_pub.add('Pricing AVa,Attribute1 '||p_x_line_rec.attribute1,1);
8106: oe_debug_pub.add('Pricing AVa,Attribute1-Return'||x_return_status,1);

Line 8109: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8105: oe_debug_pub.add('Pricing AVa,Attribute1 '||p_x_line_rec.attribute1,1);
8106: oe_debug_pub.add('Pricing AVa,Attribute1-Return'||x_return_status,1);
8107: G_PR_AV:='N' ; -- bug7380336
8108:
8109: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8110: OE_GLOBALS.g_validate_desc_flex:='N';
8111: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8112: OE_GLOBALS.g_validate_desc_flex:='N';
8113: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN

Line 8111: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

8107: G_PR_AV:='N' ; -- bug7380336
8108:
8109: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8110: OE_GLOBALS.g_validate_desc_flex:='N';
8111: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8112: OE_GLOBALS.g_validate_desc_flex:='N';
8113: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
8114: null;
8115: END IF;

Line 8113: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN

8109: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8110: OE_GLOBALS.g_validate_desc_flex:='N';
8111: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8112: OE_GLOBALS.g_validate_desc_flex:='N';
8113: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
8114: null;
8115: END IF;
8116: x_return_status := FND_API.G_RET_STS_SUCCESS;
8117: END LOOP;

Line 8116: x_return_status := FND_API.G_RET_STS_SUCCESS;

8112: OE_GLOBALS.g_validate_desc_flex:='N';
8113: ELSIF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
8114: null;
8115: END IF;
8116: x_return_status := FND_API.G_RET_STS_SUCCESS;
8117: END LOOP;
8118: END IF;
8119:
8120: OE_Order_PVT.Process_order

Line 8122: , p_init_msg_list => FND_API.G_TRUE

8118: END IF;
8119:
8120: OE_Order_PVT.Process_order
8121: ( p_api_version_number => 1.0
8122: , p_init_msg_list => FND_API.G_TRUE
8123: , x_return_status => x_return_status
8124: , x_msg_count => x_msg_count
8125: , x_msg_data => x_msg_data
8126: -- , p_control_rec => l_control_rec

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

8123: , x_return_status => x_return_status
8124: , x_msg_count => x_msg_count
8125: , x_msg_data => x_msg_data
8126: -- , p_control_rec => l_control_rec
8127: -- , p_validation_level => FND_API.G_VALID_LEVEL_NONE
8128: , p_x_header_Rec => l_header_rec
8129: , p_x_line_tbl => l_line_tbl
8130: -- , p_line_adj_tbl => l_line_adj_tbl
8131: , p_x_action_request_tbl => l_action_request_tbl

Line 8153: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

8149: print_time('After Calling Process Order Return ');
8150: END IF;
8151:
8152: -- Check the status and print appropriate messages
8153: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
8154:
8155: IF l_debug_level > 0 THEN
8156: oe_debug_pub.add('error in process order 1',1);
8157: oe_Debug_pub.add('ERROR while creating order!');

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

8243: if l_booked_flag <> 'Y' then
8244:
8245: IF l_debug_level > 0 THEN
8246: oe_Debug_pub.add('There was an error during the booking activity.');
8247: --x_return_status := 'E'; --fnd_api.g_ret_sts_error;
8248: END IF;
8249: else
8250: IF l_debug_level > 0 THEN
8251: oe_Debug_pub.add('Order booked but line not interfaced to shipping.');

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

8249: else
8250: IF l_debug_level > 0 THEN
8251: oe_Debug_pub.add('Order booked but line not interfaced to shipping.');
8252: oe_Debug_pub.add('There was a failure either in scheduling or shipping interface activity.');
8253: --x_return_status := fnd_api.g_ret_sts_error;
8254: END IF;
8255: end if;
8256:
8257: ELSE

Line 8270: IF x_return_status <> fnd_api.g_ret_sts_success then

8266: END IF; -- if interfaced to shipping
8267:
8268: END IF;
8269:
8270: IF x_return_status <> fnd_api.g_ret_sts_success then
8271:
8272: -- Print out the error messages, if any
8273:
8274: IF l_debug_level > 0 THEN

Line 8300: WHEN FND_API.G_EXC_ERROR THEN

8296:
8297:
8298: EXCEPTION
8299:
8300: WHEN FND_API.G_EXC_ERROR THEN
8301:
8302: x_return_status := FND_API.G_RET_STS_ERROR;
8303:
8304: -- Get message count and data

Line 8302: x_return_status := FND_API.G_RET_STS_ERROR;

8298: EXCEPTION
8299:
8300: WHEN FND_API.G_EXC_ERROR THEN
8301:
8302: x_return_status := FND_API.G_RET_STS_ERROR;
8303:
8304: -- Get message count and data
8305:
8306: OE_MSG_PUB.Count_And_Get

Line 8311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8307: ( p_count => x_msg_count
8308: , p_data => x_msg_data
8309: );
8310:
8311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8312:
8313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8314:
8315: -- Get message count and data

Line 8313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8309: );
8310:
8311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8312:
8313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8314:
8315: -- Get message count and data
8316:
8317: OE_MSG_PUB.Count_And_Get

Line 8324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

8320: );
8321:
8322: WHEN OTHERS THEN
8323:
8324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8325:
8326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8327: THEN
8328: OE_MSG_PUB.Add_Exc_Msg

Line 8463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8459: 'Get_Form_Startup_Values'
8460: );
8461: END IF;
8462:
8463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8464:
8465:
8466: END Get_Form_Startup_Values;
8467: