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 275: l_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;

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

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

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

Line 299: WHEN FND_API.G_EXC_ERROR THEN

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

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 506: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

502: 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) || 'SHIP_FROM_ORG_ID =' ||
503: X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
504: END IF;
505:
506: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
509: END IF;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
509: END IF;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513:
514: Check_Results_from_rec(

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
591: END IF;
592: x_return_status := 'E';
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: -- Get message count and data
595: OE_MSG_PUB.Count_And_Get
596: ( p_count => x_msg_count
597: , p_data => x_msg_data

Line 606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

602: ( G_PKG_NAME,
603: 'Call_MRP_ATP');
604: END IF;
605:
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607:
608: END Call_MRP_ATP;
609:
610:

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

827: IF x_return_status ='E' and p_global_orgs = 'N' then
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
830: END IF;
831: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
832: p_count => x_msg_count,
833: p_data=>x_msg_data
834: );
835: IF l_debug_level > 0 THEN

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: END IF;
853: IF l_debug_level > 0 THEN
854: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;
855: END IF;
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857:
858: END Check_Results_from_rec;
859:
860: PROCEDURE get_ship_from_org(in_org_id in number,

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

907: -- Hold the header_id in line_id for 'HEADER' Records
908:
909: px_req_line_tbl(l_line_index).line_id := g_line_id;
910:
911: if g_pricing_date is null or g_pricing_date = fnd_api.g_miss_date then
912: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
913: Else
914: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_pricing_date;
915: End If;

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

963: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE := p_Request_Type_Code;
964: px_req_line_tbl(l_line_index).LINE_INDEX := l_line_index;
965: px_req_line_tbl(l_line_index).LINE_TYPE_CODE := 'LINE';
966:
967: IF g_pricing_date is null or g_pricing_date = fnd_api.g_miss_date then
968: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := trunc(sysdate);
969: ELSE
970: px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE := g_pricing_date;
971: END IF;

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

1194: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
1195: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
1196:
1197: If OE_Order_PUB.G_Line.agreement_id is not null and
1198: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
1199: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
1200: Else
1201: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'N';
1202: End If;

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

1270: END IF;
1271: END IF;
1272:
1273: IF l_header_rec.header_id IS NOT NULL AND
1274: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1275: oe_order_pub.g_hdr:=l_header_rec;
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);

Line 3123: FND_API.G_RET_STS_UNEXP_ERROR,

3119: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3120: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 3124: FND_API.G_RET_STS_ERROR,

3120: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

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

3180: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3181: OE_MSG_PUB.Add;
3182:
3183: ELSIF in_status_code in
3184: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3185: FND_API.G_RET_STS_ERROR) then
3186: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3187: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3188: OE_MSG_PUB.Add;

Line 3185: FND_API.G_RET_STS_ERROR) then

3181: OE_MSG_PUB.Add;
3182:
3183: ELSIF in_status_code in
3184: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3185: FND_API.G_RET_STS_ERROR) then
3186: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3187: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3188: OE_MSG_PUB.Add;
3189:

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

3269: --FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
3270: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(g_line_id));
3271: --OE_MSG_PUB.Add;
3272: l_return_status := 'E';
3273: --RAISE FND_API.G_EXC_ERROR;*/
3274:
3275: ELSIF in_line_Type_code ='LINE' and
3276: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
3277:

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

3374: IF l_return_status ='E' then
3375: IF l_debug_level > 0 THEN
3376: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
3377: END IF;
3378: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
3379: p_count => l_msg_count,
3380: p_data=>l_msg_data
3381: );
3382: END IF;

Line 3410: If l_rounding_factor = fnd_api.g_miss_num then

3406: into l_rounding_factor
3407: from qp_list_headers_b
3408: where list_header_id = p_list_header_id;
3409:
3410: If l_rounding_factor = fnd_api.g_miss_num then
3411: l_rounding_factor:= Null;
3412: End If;
3413:
3414: Return l_rounding_factor;