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_AVAILABILITY dependencies on FND_API

Line 353: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

349: 'SHIP_FROM_ORG_ID =' ||X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
350: END IF;
351: END IF;
352:
353: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
356: END IF;
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

353: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
356: END IF;
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359:
360:
361: Check_Results_from_rec(

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
493: END IF;
494: x_return_status := 'E';
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496: -- Get message count and data
497: OE_MSG_PUB.Count_And_Get
498: ( p_count => x_msg_count
499: , p_data => x_msg_data

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504: ( G_PKG_NAME,
505: 'Call_MRP_ATP');
506: END IF;
507:
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509:
510: END Call_MRP_ATP;
511:
512:

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

565: l_rec.inventory_item_id := in_item_id;
566: l_rec.org_id := in_org_id;
567: l_rec.sold_to_org_id := in_customer_id;
568: l_rec.ship_to_org_id := in_ship_to_org_id;
569: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
570: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: --l_rec.price_list_id := FND_API.G_MISS_NUM;
572:
573: l_out_rec := l_rec;

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

566: l_rec.org_id := in_org_id;
567: l_rec.sold_to_org_id := in_customer_id;
568: l_rec.ship_to_org_id := in_ship_to_org_id;
569: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
570: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: --l_rec.price_list_id := FND_API.G_MISS_NUM;
572:
573: l_out_rec := l_rec;
574:

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

567: l_rec.sold_to_org_id := in_customer_id;
568: l_rec.ship_to_org_id := in_ship_to_org_id;
569: l_rec.ship_from_org_id := FND_API.G_MISS_NUM;
570: l_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: --l_rec.price_list_id := FND_API.G_MISS_NUM;
572:
573: l_out_rec := l_rec;
574:
575: ONT_LINE_DEF_HDLR.Default_record(

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

612: l_record.org_id := in_org_id;
613: l_record.ship_to_org_id := in_ship_to_org_id;
614: l_record.agreement_id := in_agreement_id;
615: l_record.invoice_to_org_id := in_bill_to_org_id;
616: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
617: l_record.price_list_id := FND_API.G_MISS_NUM;
618:
619: l_out_record := l_record;
620:

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

613: l_record.ship_to_org_id := in_ship_to_org_id;
614: l_record.agreement_id := in_agreement_id;
615: l_record.invoice_to_org_id := in_bill_to_org_id;
616: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
617: l_record.price_list_id := FND_API.G_MISS_NUM;
618:
619: l_out_record := l_record;
620:
621: ONT_HEADER_Def_Hdlr.Default_Record

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

639: l_record.org_id := in_org_id;
640: l_record.ship_to_org_id := in_ship_to_org_id;
641: l_record.agreement_id := in_agreement_id;
642: l_record.invoice_to_org_id := in_bill_to_org_id;
643: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
644: l_record.price_list_id := FND_API.G_MISS_NUM;
645:
646: l_out_record := l_record;
647:

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

640: l_record.ship_to_org_id := in_ship_to_org_id;
641: l_record.agreement_id := in_agreement_id;
642: l_record.invoice_to_org_id := in_bill_to_org_id;
643: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
644: l_record.price_list_id := FND_API.G_MISS_NUM;
645:
646: l_out_record := l_record;
647:
648: ONT_HEADER_Def_Hdlr.Default_Record

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

666: l_record.org_id := in_org_id;
667: l_record.ship_to_org_id := in_ship_to_org_id;
668: l_record.agreement_id := in_agreement_id;
669: l_record.invoice_to_org_id := in_bill_to_org_id;
670: l_record.price_list_id := FND_API.G_MISS_NUM;
671:
672: l_out_record := l_record;
673:
674: ONT_HEADER_Def_Hdlr.Default_Record

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

693: l_rec.ship_to_org_id := in_ship_to_org_id;
694: l_rec.invoice_to_org_id := in_bill_to_org_id;
695: l_rec.sold_to_org_id := in_customer_id;
696: l_rec.org_id := in_org_id;
697: l_rec.price_list_id := FND_API.G_MISS_NUM;
698:
699: l_out_rec := l_rec;
700:
701: ONT_LINE_DEF_HDLR.Default_record(

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

715: ELSIF in_source = 'ORDER_TYPE' then
716:
717: l_record.org_id := in_org_id;
718: l_record.order_type_id := in_order_type_id;
719: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
720:
721: l_out_record := l_record;
722:
723:

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

741: ELSIF in_source = 'STARTUP' then
742:
743: l_record.org_id := in_org_id;
744:
745: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
746: l_record.price_list_id := FND_API.G_MISS_NUM;
747: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
748:
749: l_out_record := l_record;

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

742:
743: l_record.org_id := in_org_id;
744:
745: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
746: l_record.price_list_id := FND_API.G_MISS_NUM;
747: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
748:
749: l_out_record := l_record;
750:

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

743: l_record.org_id := in_org_id;
744:
745: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
746: l_record.price_list_id := FND_API.G_MISS_NUM;
747: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
748:
749: l_out_record := l_record;
750:
751: ONT_HEADER_Def_Hdlr.Default_Record

Line 771: WHEN FND_API.G_EXC_ERROR THEN

767: END IF;
768:
769: EXCEPTION
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772:
773: x_return_status := FND_API.G_RET_STS_ERROR;
774:
775: -- Get message count and data

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: EXCEPTION
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772:
773: x_return_status := FND_API.G_RET_STS_ERROR;
774:
775: -- Get message count and data
776:
777: OE_MSG_PUB.Count_And_Get

Line 782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

778: ( p_count => x_msg_count
779: , p_data => x_msg_data
780: );
781:
782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783:
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785:
786: -- Get message count and data

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

780: );
781:
782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783:
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785:
786: -- Get message count and data
787:
788: OE_MSG_PUB.Count_And_Get

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

791: );
792:
793: WHEN OTHERS THEN
794:
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
796:
797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
798: THEN
799: OE_MSG_PUB.Add_Exc_Msg

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

1030: IF x_return_status ='E' and in_global_orgs = 'N' then
1031: IF l_debug_level > 0 THEN
1032: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
1033: END IF;
1034: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
1035: p_count => x_msg_count,
1036: p_data=>x_msg_data
1037: );
1038: IF l_debug_level > 0 THEN

Line 1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1055: END IF;
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;
1058: END IF;
1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060:
1061: END Check_Results_from_rec;
1062:
1063:

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

1283: -- Hold the header_id in line_id for 'HEADER' Records
1284:
1285: px_req_line_tbl(l_line_index).line_id := g_line_id;
1286:
1287: 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
1288: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
1289: Else
1290: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_panda_rec_table(1).p_pricing_date;
1291: End If;

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

1391: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
1392: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
1393:
1394: IF g_panda_rec_table(p_line_index).p_pricing_date is null or
1395: g_panda_rec_table(p_line_index).p_pricing_date = fnd_api.g_miss_date then
1396: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
1397: ELSE
1398: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_panda_rec_table(p_line_index).p_pricing_date;
1399: END IF;

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

2852:
2853:
2854: procedure Populate_Temp_Table
2855: IS
2856: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2857: l_return_status_Text varchar2(240) ;
2858: --
2859: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2860: --

Line 2904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2900: --p_actual_order_qty => G_ACTUAL_ORDER_QTY_TBL,
2901: x_status_code =>l_return_status,
2902: x_status_text =>l_return_status_text);
2903:
2904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2905: IF l_debug_level > 0 THEN
2906: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
2907: END IF;
2908: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 2911: RAISE FND_API.G_EXC_ERROR;

2907: END IF;
2908: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2909: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2910: OE_MSG_PUB.Add;
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913:
2914: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
2915: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 2949: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2945: G_ATTR_PRIMARY_UOM_FLAG_TBL,
2946: l_return_status ,
2947: l_return_status_text );
2948:
2949: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
2952: END IF;
2953: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 2956: raise fnd_api.g_exc_unexpected_error;

2952: END IF;
2953: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2954: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2955: OE_MSG_PUB.Add;
2956: raise fnd_api.g_exc_unexpected_error;
2957: END IF;
2958:
2959: END IF;
2960: IF l_debug_level > 0 THEN

Line 2966: RAISE FND_API.G_EXC_ERROR;

2962: END IF;
2963:
2964: EXCEPTION
2965: WHEN OTHERS THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END POPULATE_TEMP_TABLE;
2968:
2969:
2970: PROCEDURE Populate_results

Line 3252: IF l_status_code = FND_API.G_RET_STS_ERROR THEN

3248: x_line_detail_tbl(I).CALCULATION_CODE := l_dets.CALCULATION_CODE;
3249: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
3250: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
3251:
3252: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
3253: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3254: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3255: --END IF;
3256: END IF;

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

3249: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
3250: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
3251:
3252: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
3253: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3254: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3255: --END IF;
3256: END IF;
3257:

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

3259: END LOOP;
3260: I:=1;
3261:
3262: --Populate Qualifier detail
3263: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3264: oe_debug_pub.add('----Before populate x_qual_tbl-----');
3265: --END IF;
3266: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
3267: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;

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

3277: END LOOP;
3278: I:=1;
3279:
3280: --LINE ATTRIBUTE DETAIL NEEDED
3281: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3282: oe_debug_pub.add('----Before populate attr_tbl-----');
3283: --END IF;
3284: FOR l_prc IN l_pricing_attr_cur LOOP
3285: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

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

3281: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3282: oe_debug_pub.add('----Before populate attr_tbl-----');
3283: --END IF;
3284: FOR l_prc IN l_pricing_attr_cur LOOP
3285: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3286: oe_debug_pub.add('--------populating x_line_detail_attr----------');
3287: oe_debug_pub.add('Line Detail Index: '||l_prc.LINE_DETAIL_INDEX);
3288: --END IF;
3289: x_line_detail_attr_tbl(I).LINE_DETAIL_INDEX := l_prc.LINE_DETAIL_INDEX;

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

3298: END LOOP;
3299:
3300: I:=1;
3301:
3302: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3303: oe_debug_pub.add('----Before populate l_rltd_lines_tbl-----');
3304: --END IF;
3305: FOR l_rltd IN l_rltd_lines_cur LOOP
3306: x_related_lines_tbl(I).LINE_INDEX := l_rltd.Line_index;

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

3314: END LOOP;
3315:
3316: EXCEPTION
3317: WHEN E_ROUTINE_ERROR THEN
3318: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3319: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3320: -- END IF;
3321:
3322: END Populate_results;

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

3742: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
3743: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
3744:
3745: If OE_Order_PUB.G_Line.agreement_id is not null and
3746: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
3747: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
3748: Else
3749: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
3750: End If;

Line 3849: FND_API.G_RET_STS_UNEXP_ERROR,

3845: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3846: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3847: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 3850: FND_API.G_RET_STS_ERROR,

3846: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3847: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3848: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3849: FND_API.G_RET_STS_UNEXP_ERROR,
3850: FND_API.G_RET_STS_ERROR,
3851: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3852: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3853: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3854: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

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

3906: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3907: OE_MSG_PUB.Add;
3908:
3909: ELSIF in_status_code in
3910: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3911: FND_API.G_RET_STS_ERROR) then
3912: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3914: OE_MSG_PUB.Add;

Line 3911: FND_API.G_RET_STS_ERROR) then

3907: OE_MSG_PUB.Add;
3908:
3909: ELSIF in_status_code in
3910: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3911: FND_API.G_RET_STS_ERROR) then
3912: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3913: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3914: OE_MSG_PUB.Add;
3915:

Line 3999: --RAISE FND_API.G_EXC_ERROR;*/

3995: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3996: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3997: --OE_MSG_PUB.Add;
3998: l_return_status := 'E';
3999: --RAISE FND_API.G_EXC_ERROR;*/
4000:
4001: ELSIF in_line_Type_code ='LINE' and
4002: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
4003:

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

4098: IF l_return_status ='E' then
4099: IF l_debug_level > 0 THEN
4100: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
4101: END IF;
4102: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
4103: p_count => l_msg_count,
4104: p_data=>l_msg_data
4105: );
4106: END IF;

Line 4137: If l_rounding_factor = fnd_api.g_miss_num then

4133: into l_rounding_factor
4134: from qp_list_headers_b
4135: where list_header_id = p_list_header_id;
4136:
4137: If l_rounding_factor = fnd_api.g_miss_num then
4138: l_rounding_factor:= Null;
4139: End If;
4140:
4141: Return l_rounding_factor;

Line 4282: IF l_meaning = fnd_api.g_miss_char then

4278: FROM qp_lookups
4279: WHERE lookup_type = in_lookup_type
4280: AND lookup_code = in_lookup_code;
4281:
4282: IF l_meaning = fnd_api.g_miss_char then
4283: l_meaning:= Null;
4284: END IF;
4285:
4286: Return l_meaning;

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

5056: IF nvl(x_return_status,'E') <> 'S' then
5057: IF l_debug_level > 0 THEN
5058: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
5059: END IF;
5060: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
5061: p_count => x_msg_count,
5062: p_data=>x_msg_data
5063: );
5064: IF l_debug_level > 0 THEN

Line 5082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5078: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
5079: END IF;
5080:
5081: x_return_status := 'E';
5082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5083:
5084: -- Get message count and data
5085: OE_MSG_PUB.Count_And_Get
5086: ( p_count => x_msg_count

Line 5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5092: ( G_PKG_NAME,
5093: 'Get_Global_Availability');
5094: END IF;
5095:
5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5097:
5098: END get_global_availability;
5099:
5100: