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 OE_MSG_PUB

Line 497: OE_MSG_PUB.Count_And_Get

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
500: );
501:

Line 502: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

498: ( p_count => x_msg_count
499: , p_data => x_msg_data
500: );
501:
502: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
503: OE_MSG_PUB.Add_Exc_Msg
504: ( G_PKG_NAME,
505: 'Call_MRP_ATP');
506: END IF;

Line 503: OE_MSG_PUB.Add_Exc_Msg

499: , p_data => x_msg_data
500: );
501:
502: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
503: OE_MSG_PUB.Add_Exc_Msg
504: ( G_PKG_NAME,
505: 'Call_MRP_ATP');
506: END IF;
507:

Line 777: OE_MSG_PUB.Count_And_Get

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
778: ( p_count => x_msg_count
779: , p_data => x_msg_data
780: );
781:

Line 788: OE_MSG_PUB.Count_And_Get

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
789: ( p_count => x_msg_count
790: , p_data => x_msg_data
791: );
792:

Line 797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
800: ( G_PKG_NAME
801: , 'defaulting'

Line 799: OE_MSG_PUB.Add_Exc_Msg

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
800: ( G_PKG_NAME
801: , 'defaulting'
802: );
803: END IF;

Line 807: OE_MSG_PUB.Count_And_Get

803: END IF;
804:
805: -- Get message count and data
806:
807: OE_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count
809: , p_data => x_msg_data
810: );
811:

Line 876: OE_MSG_PUB.Add;

872: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
873: IF in_global_orgs = 'N' then
874:
875: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
876: OE_MSG_PUB.Add;
877: ELSE
878: x_error_message := l_explanation;
879: END IF;
880:

Line 926: OE_MSG_PUB.Add;

922: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
923: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
924:
925: IF in_global_orgs = 'N' then
926: OE_MSG_PUB.Add;
927: ELSE
928: x_error_message := fnd_message.get;
929: END IF;
930:

Line 951: OE_MSG_PUB.Add;

947:
948: IF in_global_orgs = 'N' then
949: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
950: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
951: OE_MSG_PUB.Add;
952: ELSE
953: x_error_message := l_explanation;
954: END IF;
955:

Line 1011: OE_MSG_PUB.add_text(l_explanation);

1007: END IF;
1008: x_error_message := l_explanation;
1009:
1010: IF p_atp_rec.error_code(J) = 150 THEN
1011: OE_MSG_PUB.add_text(l_explanation);
1012: END IF;
1013:
1014: EXCEPTION
1015: WHEN OTHERS THEN

Line 1028: --OE_MSG_PUB.Add;

1024:
1025: -- umcomment for testing the error handling
1026: --x_return_status := 'E';
1027: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
1028: --OE_MSG_PUB.Add;
1029:
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' ) ;

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 1049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1045: END IF;
1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1050: THEN
1051: OE_MSG_PUB.Add_Exc_Msg
1052: ( G_PKG_NAME
1053: , 'Check_Results'

Line 1051: OE_MSG_PUB.Add_Exc_Msg

1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1050: THEN
1051: OE_MSG_PUB.Add_Exc_Msg
1052: ( G_PKG_NAME
1053: , 'Check_Results'
1054: );
1055: END IF;

Line 1129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1125: EXCEPTION
1126:
1127: WHEN OTHERS THEN
1128:
1129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1130: OE_MSG_PUB.Add_Exc_Msg
1131: ( G_PKG_NAME,
1132: 'Initialize_mrp_record');
1133: END IF;

Line 1130: OE_MSG_PUB.Add_Exc_Msg

1126:
1127: WHEN OTHERS THEN
1128:
1129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1130: OE_MSG_PUB.Add_Exc_Msg
1131: ( G_PKG_NAME,
1132: 'Initialize_mrp_record');
1133: END IF;
1134:

Line 2910: OE_MSG_PUB.Add;

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
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

Line 2955: OE_MSG_PUB.Add;

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
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;

Line 3884: OE_MSG_PUB.Add;

3880: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3881: IF l_debug_level > 0 THEN
3882: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3883: END IF;
3884: OE_MSG_PUB.Add;
3885:
3886: ELSE
3887: IF l_debug_level > 0 THEN
3888: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;

Line 3894: OE_MSG_PUB.Add;

3890: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3891: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3892: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
3893: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
3894: OE_MSG_PUB.Add;
3895:
3896: END IF;
3897:
3898: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

Line 3903: OE_MSG_PUB.Add;

3899:
3900: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3901: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3902: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3903: OE_MSG_PUB.Add;
3904:
3905: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3906: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3907: OE_MSG_PUB.Add;

Line 3907: OE_MSG_PUB.Add;

3903: OE_MSG_PUB.Add;
3904:
3905: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
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

Line 3914: OE_MSG_PUB.Add;

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:
3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

Line 3920: OE_MSG_PUB.Add;

3916: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3917: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3918: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3919: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3920: OE_MSG_PUB.Add;
3921:
3922: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3924:

Line 3964: OE_MSG_PUB.Add;

3960: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3961: END IF;
3962:
3963: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3964: OE_MSG_PUB.Add;
3965:
3966: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3967: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3968: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||

Line 3970: OE_MSG_PUB.Add;

3966: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3967: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3968: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3969: in_status_text);
3970: OE_MSG_PUB.Add;
3971:
3972: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3973: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3974: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||

Line 3976: OE_MSG_PUB.Add;

3972: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3973: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3974: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3975: in_status_text);
3976: OE_MSG_PUB.Add;
3977:
3978: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3979: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3980: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

Line 3982: OE_MSG_PUB.Add;

3978: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3979: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3980: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3981: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3982: OE_MSG_PUB.Add;
3983: END IF;
3984:
3985:
3986: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and

Line 3994: OE_MSG_PUB.Add;

3990: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;
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';

Line 3997: --OE_MSG_PUB.Add;

3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);
3994: OE_MSG_PUB.Add;
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

Line 4009: OE_MSG_PUB.Add;

4005: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4006: END IF;
4007: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
4008: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4009: OE_MSG_PUB.Add;
4010:
4011: ELSIF in_line_Type_code ='LINE' and in_status_code in
4012: --( QP_PREQ_GRP.G_STATUS_UPDATED,
4013: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and

Line 4029: OE_MSG_PUB.Add;

4025: IF in_status_text is not null then
4026: l_return_status := 'E';
4027: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
4028: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
4029: OE_MSG_PUB.Add;
4030: END IF;
4031:
4032: -- we need to do this check in UPDATED code or do the gsa check through
4033: -- the control record of Pricing

Line 4065: OE_MSG_PUB.Add;

4061: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
4062: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
4063: l_msg_text := l_operand||' ( '||l_msg_text||' )';
4064: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
4065: OE_MSG_PUB.Add;
4066: END IF;
4067: END IF; */
4068:
4069:

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 4831: OE_MSG_PUB.Add;

4827: IF l_debug_level > 0 THEN
4828: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
4829: END IF;
4830: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
4831: OE_MSG_PUB.Add;
4832:
4833: END IF;
4834:
4835:

Line 4902: oe_msg_pub.add;

4898:
4899:
4900: IF x_plan_id is null then
4901: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');
4902: oe_msg_pub.add;
4903: x_return_status := 'E';
4904: oe_debug_pub.add('Plan Id NOT FOUND');
4905: END IF;
4906:

Line 4981: oe_msg_pub.add;

4977: IF l_debug_level > 0 THEN
4978: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');
4979: END IF;
4980: fnd_message.set_name('MSC', x_err_mesg);
4981: oe_msg_pub.add;
4982:
4983: ELSE
4984:
4985: IF x_return_status IS NULL THEN

Line 5039: OE_MSG_PUB.Add;

5035: END IF;
5036: x_return_status := 'E';
5037: x_error_mesg := 'MRP_ATP_NO_SOURCES';
5038: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');
5039: OE_MSG_PUB.Add;
5040: x_return_status := 'E';
5041:
5042: END IF; -- IF x_sources.organization_id.COUNT > 0
5043:

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 5085: OE_MSG_PUB.Count_And_Get

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
5087: , p_data => x_msg_data
5088: );
5089:

Line 5090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5086: ( p_count => x_msg_count
5087: , p_data => x_msg_data
5088: );
5089:
5090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5091: OE_MSG_PUB.Add_Exc_Msg
5092: ( G_PKG_NAME,
5093: 'Get_Global_Availability');
5094: END IF;

Line 5091: OE_MSG_PUB.Add_Exc_Msg

5087: , p_data => x_msg_data
5088: );
5089:
5090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5091: OE_MSG_PUB.Add_Exc_Msg
5092: ( G_PKG_NAME,
5093: 'Get_Global_Availability');
5094: END IF;
5095: