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

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

Line 360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

507: ( G_PKG_NAME,
508: 'Call_MRP_ATP');
509: END IF;
510:
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512:
513: END Call_MRP_ATP;
514:
515:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

745:
746: l_record.org_id := in_org_id;
747:
748: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
749: l_record.price_list_id := FND_API.G_MISS_NUM;
750: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
751:
752: l_out_record := l_record;
753:

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

746: l_record.org_id := in_org_id;
747:
748: l_record.conversion_type_code := FND_API.G_MISS_CHAR;
749: l_record.price_list_id := FND_API.G_MISS_NUM;
750: l_record.ship_from_org_id := FND_API.G_MISS_NUM;
751:
752: l_out_record := l_record;
753:
754: ONT_HEADER_Def_Hdlr.Default_Record

Line 774: WHEN FND_API.G_EXC_ERROR THEN

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

Line 776: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

794: );
795:
796: WHEN OTHERS THEN
797:
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
799:
800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
801: THEN
802: OE_MSG_PUB.Add_Exc_Msg

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

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

Line 1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

2857:
2858:
2859: procedure Populate_Temp_Table
2860: IS
2861: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2862: l_return_status_Text varchar2(240) ;
2863: --
2864: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2865: --

Line 2909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2916: RAISE FND_API.G_EXC_ERROR;

2912: END IF;
2913: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2914: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2915: OE_MSG_PUB.Add;
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:
2919: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
2920: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 2954: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2961: raise fnd_api.g_exc_unexpected_error;

2957: END IF;
2958: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2959: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2960: OE_MSG_PUB.Add;
2961: raise fnd_api.g_exc_unexpected_error;
2962: END IF;
2963:
2964: END IF;
2965: IF l_debug_level > 0 THEN

Line 2971: RAISE FND_API.G_EXC_ERROR;

2967: END IF;
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: RAISE FND_API.G_EXC_ERROR;
2972: END POPULATE_TEMP_TABLE;
2973:
2974:
2975: PROCEDURE Populate_results

Line 3257: IF l_status_code = FND_API.G_RET_STS_ERROR THEN

3253: x_line_detail_tbl(I).CALCULATION_CODE := l_dets.CALCULATION_CODE;
3254: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
3255: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
3256:
3257: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
3258: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3259: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3260: --END IF;
3261: END IF;

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

3254: x_line_detail_tbl(I).CHANGE_REASON_CODE := l_dets.CHANGE_REASON_CODE;
3255: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
3256:
3257: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
3258: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3259: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3260: --END IF;
3261: END IF;
3262:

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

3264: END LOOP;
3265: I:=1;
3266:
3267: --Populate Qualifier detail
3268: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3269: oe_debug_pub.add('----Before populate x_qual_tbl-----');
3270: --END IF;
3271: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
3272: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;

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

3282: END LOOP;
3283: I:=1;
3284:
3285: --LINE ATTRIBUTE DETAIL NEEDED
3286: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3287: oe_debug_pub.add('----Before populate attr_tbl-----');
3288: --END IF;
3289: FOR l_prc IN l_pricing_attr_cur LOOP
3290: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

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

3286: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3287: oe_debug_pub.add('----Before populate attr_tbl-----');
3288: --END IF;
3289: FOR l_prc IN l_pricing_attr_cur LOOP
3290: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3291: oe_debug_pub.add('--------populating x_line_detail_attr----------');
3292: oe_debug_pub.add('Line Detail Index: '||l_prc.LINE_DETAIL_INDEX);
3293: --END IF;
3294: x_line_detail_attr_tbl(I).LINE_DETAIL_INDEX := l_prc.LINE_DETAIL_INDEX;

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

3303: END LOOP;
3304:
3305: I:=1;
3306:
3307: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3308: oe_debug_pub.add('----Before populate l_rltd_lines_tbl-----');
3309: --END IF;
3310: FOR l_rltd IN l_rltd_lines_cur LOOP
3311: x_related_lines_tbl(I).LINE_INDEX := l_rltd.Line_index;

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

3319: END LOOP;
3320:
3321: EXCEPTION
3322: WHEN E_ROUTINE_ERROR THEN
3323: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3324: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3325: -- END IF;
3326:
3327: END Populate_results;

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

3759: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
3760: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
3761:
3762: If OE_Order_PUB.G_Line.agreement_id is not null and
3763: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
3764: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
3765: Else
3766: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
3767: End If;

Line 3866: FND_API.G_RET_STS_UNEXP_ERROR,

3862: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3863: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3864: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 3867: FND_API.G_RET_STS_ERROR,

3863: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3864: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3865: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3866: FND_API.G_RET_STS_UNEXP_ERROR,
3867: FND_API.G_RET_STS_ERROR,
3868: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3869: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3870: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3871: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

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

3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3924: OE_MSG_PUB.Add;
3925:
3926: ELSIF in_status_code in
3927: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3928: FND_API.G_RET_STS_ERROR) then
3929: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3930: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3931: OE_MSG_PUB.Add;

Line 3928: FND_API.G_RET_STS_ERROR) then

3924: OE_MSG_PUB.Add;
3925:
3926: ELSIF in_status_code in
3927: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3928: FND_API.G_RET_STS_ERROR) then
3929: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3930: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3931: OE_MSG_PUB.Add;
3932:

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

4012: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
4013: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
4014: --OE_MSG_PUB.Add;
4015: l_return_status := 'E';
4016: --RAISE FND_API.G_EXC_ERROR;*/
4017:
4018: ELSIF in_line_Type_code ='LINE' and
4019: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
4020:

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

4115: IF l_return_status ='E' then
4116: IF l_debug_level > 0 THEN
4117: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
4118: END IF;
4119: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
4120: p_count => l_msg_count,
4121: p_data=>l_msg_data
4122: );
4123: END IF;

Line 4154: If l_rounding_factor = fnd_api.g_miss_num then

4150: into l_rounding_factor
4151: from qp_list_headers_b
4152: where list_header_id = p_list_header_id;
4153:
4154: If l_rounding_factor = fnd_api.g_miss_num then
4155: l_rounding_factor:= Null;
4156: End If;
4157:
4158: Return l_rounding_factor;

Line 4299: IF l_meaning = fnd_api.g_miss_char then

4295: FROM qp_lookups
4296: WHERE lookup_type = in_lookup_type
4297: AND lookup_code = in_lookup_code;
4298:
4299: IF l_meaning = fnd_api.g_miss_char then
4300: l_meaning:= Null;
4301: END IF;
4302:
4303: Return l_meaning;

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

5073: IF nvl(x_return_status,'E') <> 'S' then
5074: IF l_debug_level > 0 THEN
5075: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
5076: END IF;
5077: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
5078: p_count => x_msg_count,
5079: p_data=>x_msg_data
5080: );
5081: IF l_debug_level > 0 THEN

Line 5099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5095: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
5096: END IF;
5097:
5098: x_return_status := 'E';
5099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5100:
5101: -- Get message count and data
5102: OE_MSG_PUB.Count_And_Get
5103: ( p_count => x_msg_count

Line 5113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5109: ( G_PKG_NAME,
5110: 'Get_Global_Availability');
5111: END IF;
5112:
5113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5114:
5115: END get_global_availability;
5116:
5117: