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

Line 273: l_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;

269: l_line_rec.price_list_id := p_price_list_id;
270: l_line_rec.request_date := p_request_date;
271: l_line_rec.arrival_set_id := p_arrival_set_id;
272: --Bug 2992459
273: l_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
274: l_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
275:
276: l_out_line_rec := l_line_rec;
277:

Line 274: l_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

270: l_line_rec.request_date := p_request_date;
271: l_line_rec.arrival_set_id := p_arrival_set_id;
272: --Bug 2992459
273: l_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
274: l_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
275:
276: l_out_line_rec := l_line_rec;
277:
278: ONT_LINE_DEF_HDLR.Default_record(

Line 297: WHEN FND_API.G_EXC_ERROR THEN

293: END IF;
294:
295: EXCEPTION
296:
297: WHEN FND_API.G_EXC_ERROR THEN
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: -- Get message count and data

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: EXCEPTION
296:
297: WHEN FND_API.G_EXC_ERROR THEN
298:
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: -- Get message count and data
302:
303: OE_MSG_PUB.Count_And_Get

Line 308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

304: ( p_count => x_msg_count
305: , p_data => x_msg_data
306: );
307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309:
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311:
312: -- Get message count and data

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

306: );
307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309:
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311:
312: -- Get message count and data
313:
314: OE_MSG_PUB.Count_And_Get

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

317: );
318:
319: WHEN OTHERS THEN
320:
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322:
323: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: OE_MSG_PUB.Add_Exc_Msg

Line 473: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

469: 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) || 'SHIP_FROM_ORG_ID =' ||
470: X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
471: END IF;
472:
473: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: IF l_debug_level > 0 THEN
475: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
476: END IF;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: IF l_debug_level > 0 THEN
475: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
476: END IF;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480:
481: Check_Results_from_rec(

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

556: IF l_debug_level > 0 THEN
557: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
558: END IF;
559: x_return_status := 'E';
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: -- Get message count and data
562: OE_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count
564: , p_data => x_msg_data

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: ( G_PKG_NAME,
570: 'Call_MRP_ATP');
571: END IF;
572:
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574:
575: END Call_MRP_ATP;
576:
577:

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

794: IF x_return_status ='E' and p_global_orgs = 'N' then
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
797: END IF;
798: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
799: p_count => x_msg_count,
800: p_data=>x_msg_data
801: );
802: IF l_debug_level > 0 THEN

Line 823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

819: END IF;
820: IF l_debug_level > 0 THEN
821: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;
822: END IF;
823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824:
825: END Check_Results_from_rec;
826:
827: PROCEDURE get_ship_from_org(in_org_id in number,

Line 878: if g_pricing_date is null or g_pricing_date = fnd_api.g_miss_date then

874: -- Hold the header_id in line_id for 'HEADER' Records
875:
876: px_req_line_tbl(l_line_index).line_id := g_line_id;
877:
878: if g_pricing_date is null or g_pricing_date = fnd_api.g_miss_date then
879: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
880: Else
881: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_pricing_date;
882: End If;

Line 934: IF g_pricing_date is null or g_pricing_date = fnd_api.g_miss_date then

930: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := p_Request_Type_Code;
931: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
932: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
933:
934: IF g_pricing_date is null or g_pricing_date = fnd_api.g_miss_date then
935: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
936: ELSE
937: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_pricing_date;
938: END IF;

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

1160: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
1161: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
1162:
1163: If OE_Order_PUB.G_Line.agreement_id is not null and
1164: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
1165: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
1166: Else
1167: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
1168: End If;

Line 1240: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN

1236: END IF;
1237: END IF;
1238:
1239: IF l_header_rec.header_id IS NOT NULL AND
1240: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1241: oe_order_pub.g_hdr:=l_header_rec;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);

Line 3089: FND_API.G_RET_STS_UNEXP_ERROR,

3085: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3086: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 3090: FND_API.G_RET_STS_ERROR,

3086: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

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

3146: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3147: OE_MSG_PUB.Add;
3148:
3149: ELSIF in_status_code in
3150: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3151: FND_API.G_RET_STS_ERROR) then
3152: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3153: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3154: OE_MSG_PUB.Add;

Line 3151: FND_API.G_RET_STS_ERROR) then

3147: OE_MSG_PUB.Add;
3148:
3149: ELSIF in_status_code in
3150: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3151: FND_API.G_RET_STS_ERROR) then
3152: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3153: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3154: OE_MSG_PUB.Add;
3155:

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

3235: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3236: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3237: --OE_MSG_PUB.Add;
3238: l_return_status := 'E';
3239: --RAISE FND_API.G_EXC_ERROR;*/
3240:
3241: ELSIF in_line_Type_code ='LINE' and
3242: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
3243:

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

3340: IF l_return_status ='E' then
3341: IF l_debug_level > 0 THEN
3342: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
3343: END IF;
3344: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
3345: p_count => l_msg_count,
3346: p_data=>l_msg_data
3347: );
3348: END IF;

Line 3376: If l_rounding_factor = fnd_api.g_miss_num then

3372: into l_rounding_factor
3373: from qp_list_headers_b
3374: where list_header_id = p_list_header_id;
3375:
3376: If l_rounding_factor = fnd_api.g_miss_num then
3377: l_rounding_factor:= Null;
3378: End If;
3379:
3380: Return l_rounding_factor;