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

Line 145: x_ret_stat := Fnd_Api.G_RET_STS_ERROR;

141: --
142: IF l_debug_level > 0 THEN
143: oe_debug_pub.ADD(' Though LSP and USP differ and calc_price_flg is P, profile not set. Exiting...');
144: END IF;
145: x_ret_stat := Fnd_Api.G_RET_STS_ERROR;
146: EXIT;
147:
148: END IF; -- check on l_list_line_id being not null
149:

Line 190: p_x_ret_stat := Fnd_Api.G_RET_STS_UNEXP_ERROR;

186: p_x_line_adj_tbl_obj := Oe_Inbound_Int.PL_TO_SQL14(l_line_adj_tbl);
187:
188: EXCEPTION
189: WHEN Others THEN
190: p_x_ret_stat := Fnd_Api.G_RET_STS_UNEXP_ERROR;
191:
192: IF OE_MSG_PUB.Check_Msg_Level(Oe_Msg_Pub.G_Msg_Lvl_Unexp_Error)
193: THEN
194: OE_MSG_PUB.Add_Exc_Msg

Line 2793: aPlsqlItem.LINE_ID := aSqlItem.LINE_ID; -- FND_API.G_MISS_NUM; -- O2C25

2789: aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2790: aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2791: aPlsqlItem.LATEST_ACCEPTABLE_DATE := aSqlItem.LATEST_ACCEPTABLE_DATE;
2792: aPlsqlItem.LINE_CATEGORY_CODE := aSqlItem.LINE_CATEGORY_CODE;
2793: aPlsqlItem.LINE_ID := aSqlItem.LINE_ID; -- FND_API.G_MISS_NUM; -- O2C25
2794: aPlsqlItem.LINE_NUMBER := aSqlItem.LINE_NUMBER;
2795: aPlsqlItem.LINE_TYPE_ID := aSqlItem.LINE_TYPE_ID;
2796: aPlsqlItem.LINK_TO_LINE_REF := aSqlItem.LINK_TO_LINE_REF;
2797: aPlsqlItem.LINK_TO_LINE_ID := aSqlItem.LINK_TO_LINE_ID;

Line 2869: aPlsqlItem.SHIPMENT_NUMBER := FND_API.G_MISS_NUM; --aSqlItem.SHIPMENT_NUMBER;

2865: aPlsqlItem.SCHEDULE_ARRIVAL_DATE := aSqlItem.SCHEDULE_ARRIVAL_DATE;
2866: aPlsqlItem.SCHEDULE_SHIP_DATE := aSqlItem.SCHEDULE_SHIP_DATE;
2867: aPlsqlItem.SCHEDULE_ACTION_CODE := aSqlItem.SCHEDULE_ACTION_CODE;
2868: aPlsqlItem.SCHEDULE_STATUS_CODE := aSqlItem.SCHEDULE_STATUS_CODE;
2869: aPlsqlItem.SHIPMENT_NUMBER := FND_API.G_MISS_NUM; --aSqlItem.SHIPMENT_NUMBER;
2870: aPlsqlItem.SHIPMENT_PRIORITY_CODE := aSqlItem.SHIPMENT_PRIORITY_CODE;
2871: aPlsqlItem.SHIPPED_QUANTITY := aSqlItem.SHIPPED_QUANTITY;
2872: aPlsqlItem.SHIPPED_QUANTITY2 := aSqlItem.SHIPPED_QUANTITY2;
2873: aPlsqlItem.SHIPPING_INTERFACED_FLAG := aSqlItem.SHIPPING_INTERFACED_FLAG;

Line 5092: l_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

5088:
5089: l_config_process_tab config_process_tab_type;
5090:
5091: -- Bug 9019601
5092: l_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
5093:
5094: /*
5095: -- Bug 9131751
5096: l_amm_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

Line 5096: l_amm_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

5092: l_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
5093:
5094: /*
5095: -- Bug 9131751
5096: l_amm_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
5097: l_line_adj_tbl Oe_Order_Pub_Line_Adj_Tbl_Typ;
5098: */
5099: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5100:

Line 5118: ELSIF Nvl(p_header_rec.order_source_id,Fnd_Api.G_Miss_Num)

5114: IF l_debug_level > 0 THEN
5115: oe_debug_pub.ADD('Set G_INCOMING_FROM_DOO at Location 1.', 5);
5116: END IF;
5117:
5118: ELSIF Nvl(p_header_rec.order_source_id,Fnd_Api.G_Miss_Num)
5119: = Fnd_Api.G_Miss_Num THEN
5120: FOR i in 1..P_LINE_TBL.Count
5121: LOOP
5122: IF P_LINE_TBL(i).order_source_id = 32 THEN

Line 5119: = Fnd_Api.G_Miss_Num THEN

5115: oe_debug_pub.ADD('Set G_INCOMING_FROM_DOO at Location 1.', 5);
5116: END IF;
5117:
5118: ELSIF Nvl(p_header_rec.order_source_id,Fnd_Api.G_Miss_Num)
5119: = Fnd_Api.G_Miss_Num THEN
5120: FOR i in 1..P_LINE_TBL.Count
5121: LOOP
5122: IF P_LINE_TBL(i).order_source_id = 32 THEN
5123:

Line 5236: IF l_amm_ret_stat = Fnd_Api.G_RET_STS_SUCCESS THEN

5232: l_line_adj_tbl := Oe_Order_Pub_Line_Adj_Tbl_Typ();
5233:
5234: Add_Manual_Modifier_Obj(l_in_line_tab, l_line_adj_tbl, l_amm_ret_stat);
5235:
5236: IF l_amm_ret_stat = Fnd_Api.G_RET_STS_SUCCESS THEN
5237: -- only now proceed with executing this logic.
5238: IF l_debug_level > 0 THEN
5239: Oe_Debug_Pub.ADD('Proceeding with Invocation to Process_Order...');
5240: END IF;

Line 5242: ELSIF l_amm_ret_stat = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

5238: IF l_debug_level > 0 THEN
5239: Oe_Debug_Pub.ADD('Proceeding with Invocation to Process_Order...');
5240: END IF;
5241:
5242: ELSIF l_amm_ret_stat = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
5243: -- Some problem in executing Add_Manual_Modifier; either relevant
5244: -- modifier reference is missing or multiple rows got identified.
5245: --
5246: IF l_debug_level > 0 THEN

Line 5250: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

5246: IF l_debug_level > 0 THEN
5247: Oe_Debug_Pub.ADD('Problem in deriving valid modifier...');
5248: END IF;
5249:
5250: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5251: RETURN;
5252:
5253: ELSE
5254: -- push an error message into x_messages table and get out.

Line 5269: x_return_status := Fnd_Api.G_RET_STS_ERROR;

5265: -- because it does not make sense to proceed in the absence of
5266: -- a valid modifier reference, accounting for difference between
5267: -- USP and ULP of at least one order line.
5268: --
5269: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5270: RETURN;
5271:
5272: END IF;
5273: --

Line 5298: Fnd_Api.G_Miss_Char, 'LINE',

5294: IF ( l_action_request_tbl(i).request_type IN
5295: ('APPLY_HOLD', 'RELEASE_HOLD') ) THEN
5296: SELECT
5297: Decode(l_action_request_tbl(i).entity_code, NULL, 'LINE',
5298: Fnd_Api.G_Miss_Char, 'LINE',
5299: l_action_request_tbl(i).entity_code)
5300: INTO l_action_request_tbl(i).entity_code
5301: FROM DUAL;
5302:

Line 5321: l_action_request_tbl(i).param4 = Fnd_Api.G_Miss_Char ) THEN

5317: -- one to go ahead with hold release.
5318: ---
5319: IF l_action_request_tbl(i).request_type = 'RELEASE_HOLD' THEN
5320: IF ( l_action_request_tbl(i).param4 IS NULL OR
5321: l_action_request_tbl(i).param4 = Fnd_Api.G_Miss_Char ) THEN
5322: -- Initialize.
5323: l_action_request_tbl(i).param4 := 'DOO_OM_HOLD';
5324: END IF;
5325: END IF;

Line 5464: IF (Nvl(fnd_profile.Value('ONT_TAX_ROLLUP_HDR_AIA'), fnd_api.g_miss_char) = 'Y' AND

5460:
5461: -- Step 2: Based on profile option set up, populate freight_charge,
5462: -- tax_value at header and line levels.
5463: -- 2(a). When tax roll up at header level is required.
5464: IF (Nvl(fnd_profile.Value('ONT_TAX_ROLLUP_HDR_AIA'), fnd_api.g_miss_char) = 'Y' AND
5465: nvl(x_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) -- Bug 16041105
5466: THEN
5467: Oe_Oe_Totals_Summary.Global_Totals(x_header_rec.header_id);
5468: x_header_rec.tax_value := Oe_Oe_Totals_Summary.Taxes(x_header_rec.header_id);

Line 5465: nvl(x_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) -- Bug 16041105

5461: -- Step 2: Based on profile option set up, populate freight_charge,
5462: -- tax_value at header and line levels.
5463: -- 2(a). When tax roll up at header level is required.
5464: IF (Nvl(fnd_profile.Value('ONT_TAX_ROLLUP_HDR_AIA'), fnd_api.g_miss_char) = 'Y' AND
5465: nvl(x_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) -- Bug 16041105
5466: THEN
5467: Oe_Oe_Totals_Summary.Global_Totals(x_header_rec.header_id);
5468: x_header_rec.tax_value := Oe_Oe_Totals_Summary.Taxes(x_header_rec.header_id);
5469: END IF;

Line 5472: IF (Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_HDR_AIA'), fnd_api.g_miss_char) = 'Y' AND

5468: x_header_rec.tax_value := Oe_Oe_Totals_Summary.Taxes(x_header_rec.header_id);
5469: END IF;
5470:
5471: -- 2(b). When the freight charges roll-up at header level is required.
5472: IF (Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_HDR_AIA'), fnd_api.g_miss_char) = 'Y' AND
5473: nvl(x_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) -- Bug 16041105
5474: THEN
5475: x_header_rec.freight_charge :=
5476: Oe_Oe_Totals_Summary.Charges(x_header_rec.header_id);

Line 5473: nvl(x_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) -- Bug 16041105

5469: END IF;
5470:
5471: -- 2(b). When the freight charges roll-up at header level is required.
5472: IF (Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_HDR_AIA'), fnd_api.g_miss_char) = 'Y' AND
5473: nvl(x_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) -- Bug 16041105
5474: THEN
5475: x_header_rec.freight_charge :=
5476: Oe_Oe_Totals_Summary.Charges(x_header_rec.header_id);
5477: END IF;

Line 5480: IF Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_LINE_AIA'), fnd_api.g_miss_char)

5476: Oe_Oe_Totals_Summary.Charges(x_header_rec.header_id);
5477: END IF;
5478:
5479: -- 2(c). When the freight charges roll-up at each individual line level is required.
5480: IF Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_LINE_AIA'), fnd_api.g_miss_char)
5481: = 'Y'
5482: THEN
5483: BEGIN
5484: IF x_line_tbl.Count > 0 THEN

Line 5683: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

5679: repr_line_rec.operation, repr_control_rec);
5680:
5681: oe_debug_pub.ADD(' Calling Lines(...)....');
5682: oe_order_pvt.lines(
5683: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
5684: p_control_rec => repr_control_rec,
5685: p_x_line_tbl => repr_line_tbl,
5686: p_x_old_line_tbl => repr_old_line_tbl,
5687: x_return_status => repr_return_status

Line 5712: IF l_stat = FND_API.G_RET_STS_SUCCESS THEN

5708: p_change_type => 'PRICE_CHG',
5709: p_req_id => l_sso_seq,
5710: X_RETURN_STATUS => l_stat);
5711:
5712: IF l_stat = FND_API.G_RET_STS_SUCCESS THEN
5713: oe_debug_pub.ADD(' Calling Sync_Header_Line...');
5714: OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE(
5715: p_header_rec => l_hdr_rec,
5716: p_line_rec => repr_line_tbl(1),

Line 5935: l_amm_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS; -- 10171747

5931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5932: l_booking_action_index NUMBER := NULL; -- Bug 8872110
5933:
5934: l_price_adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type; -- 10171747
5935: l_amm_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS; -- 10171747
5936:
5937: -- Bug 11928288
5938: CURSOR bill_seq_id_cur(p_inv_item_id NUMBER) IS
5939: SELECT bom.bill_sequence_id, bom.organization_id

Line 6016: p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR) THEN --Bug 8442659

6012: -- being created is a sales order. For quotes, we do not request
6013: -- booking.
6014: --
6015: IF ( Nvl(p_header_rec.transaction_phase_code, 'F') = 'F' OR
6016: p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR) THEN --Bug 8442659
6017: IF l_debug_level > 0 THEN
6018: oe_debug_pub.add('+++ Sales order under creation...');
6019: END IF;
6020: -- Bug 7629966

Line 6030: p_header_rec_.booked_flag := FND_API.G_MISS_CHAR; --Bug 8485302

6026: END IF;
6027: p_action_request_tbl_(p_action_request_tbl_.COUNT+1).request_type := OE_GLOBALS.G_BOOK_ORDER; --Bug 8442659
6028: p_action_request_tbl_(p_action_request_tbl_.COUNT).entity_code := OE_GLOBALS.G_ENTITY_HEADER; --Bug 8442659
6029: l_booking_action_index := p_action_request_tbl_.COUNT; -- Bug 8872110
6030: p_header_rec_.booked_flag := FND_API.G_MISS_CHAR; --Bug 8485302
6031: END IF;
6032: ELSIF ( p_header_rec.transaction_phase_code = 'N' ) THEN
6033: IF l_debug_level > 0 THEN
6034: oe_debug_pub.add('+++ Quote under creation, not populating action request table.');

Line 6100: IF l_amm_ret_stat = Fnd_Api.G_RET_STS_SUCCESS THEN

6096: oe_debug_pub.ADD(' Return status from Add_Manual_Modifier: '
6097: || l_amm_ret_stat, 5);
6098: END IF;
6099:
6100: IF l_amm_ret_stat = Fnd_Api.G_RET_STS_SUCCESS THEN
6101:
6102: -- only now proceed with executing this logic.
6103: IF l_debug_level > 0 THEN
6104: Oe_Debug_Pub.ADD('Proceeding with Invocation to Process_Order...');

Line 6107: ELSIF l_amm_ret_stat = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

6103: IF l_debug_level > 0 THEN
6104: Oe_Debug_Pub.ADD('Proceeding with Invocation to Process_Order...');
6105: END IF;
6106:
6107: ELSIF l_amm_ret_stat = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
6108: -- Some problem in executing Add_Manual_Modifier; either relevant
6109: -- modifier reference is missing or multiple rows got identified.
6110: --
6111: IF l_debug_level > 0 THEN

Line 6115: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

6111: IF l_debug_level > 0 THEN
6112: Oe_Debug_Pub.ADD('Problem in deriving valid modifier...');
6113: END IF;
6114:
6115: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6116: RETURN;
6117:
6118: ELSE
6119: -- push an error message into x_messages table and get out.

Line 6134: x_return_status := Fnd_Api.G_RET_STS_ERROR;

6130: -- because it does not make sense to proceed in the absence of
6131: -- a valid modifier reference, accounting for difference between
6132: -- USP and ULP of at least one order line.
6133: --
6134: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6135: RETURN;
6136:
6137: END IF;
6138:

Line 6154: IF Nvl(P_LINE_TBL_(i).Schedule_Ship_Date, Fnd_Api.G_Miss_Date)

6150: -- EXPLOSION_DATE and SCHEDULE_SHIP_DATE.
6151: ---
6152: FOR i IN 1..P_LINE_TBL_.COUNT
6153: LOOP
6154: IF Nvl(P_LINE_TBL_(i).Schedule_Ship_Date, Fnd_Api.G_Miss_Date)
6155: <> Fnd_Api.G_Miss_Date THEN
6156: IF l_debug_level > 0 THEN
6157: oe_debug_pub.ADD('Setting BYPASS_SCH_FLAG to Y on line_id '
6158: || P_LINE_TBL_(i).line_id);

Line 6155: <> Fnd_Api.G_Miss_Date THEN

6151: ---
6152: FOR i IN 1..P_LINE_TBL_.COUNT
6153: LOOP
6154: IF Nvl(P_LINE_TBL_(i).Schedule_Ship_Date, Fnd_Api.G_Miss_Date)
6155: <> Fnd_Api.G_Miss_Date THEN
6156: IF l_debug_level > 0 THEN
6157: oe_debug_pub.ADD('Setting BYPASS_SCH_FLAG to Y on line_id '
6158: || P_LINE_TBL_(i).line_id);
6159: END IF;

Line 6166: IF ( Nvl(P_LINE_TBL_(i).Explosion_Date, Fnd_Api.G_Miss_Date)

6162: END LOOP;
6163:
6164: FOR i IN 1..P_LINE_TBL_.COUNT
6165: LOOP
6166: IF ( Nvl(P_LINE_TBL_(i).Explosion_Date, Fnd_Api.G_Miss_Date)
6167: <> Fnd_Api.G_Miss_Date AND
6168: P_LINE_TBL_(i).Item_Type_Code IN
6169: ('KIT', 'CLASS', 'MODEL', 'INCLUDED', 'OPTION')
6170: ) THEN

Line 6167: <> Fnd_Api.G_Miss_Date AND

6163:
6164: FOR i IN 1..P_LINE_TBL_.COUNT
6165: LOOP
6166: IF ( Nvl(P_LINE_TBL_(i).Explosion_Date, Fnd_Api.G_Miss_Date)
6167: <> Fnd_Api.G_Miss_Date AND
6168: P_LINE_TBL_(i).Item_Type_Code IN
6169: ('KIT', 'CLASS', 'MODEL', 'INCLUDED', 'OPTION')
6170: ) THEN
6171: IF l_debug_level > 0 THEN

Line 6198: FND_API.G_TRUE,

6194: OE_ORDER_PUB.PROCESS_ORDER(
6195: p_header_rec.org_id, -- MOAC Changes in R12
6196: NULL, -- MOAC Changes in R12
6197: 1.0,
6198: FND_API.G_TRUE,
6199: FND_API.G_TRUE,
6200: FND_API.G_FALSE,
6201: X_RETURN_STATUS,
6202: L_MSG_COUNT,

Line 6199: FND_API.G_TRUE,

6195: p_header_rec.org_id, -- MOAC Changes in R12
6196: NULL, -- MOAC Changes in R12
6197: 1.0,
6198: FND_API.G_TRUE,
6199: FND_API.G_TRUE,
6200: FND_API.G_FALSE,
6201: X_RETURN_STATUS,
6202: L_MSG_COUNT,
6203: L_MSG_DATA,

Line 6200: FND_API.G_FALSE,

6196: NULL, -- MOAC Changes in R12
6197: 1.0,
6198: FND_API.G_TRUE,
6199: FND_API.G_TRUE,
6200: FND_API.G_FALSE,
6201: X_RETURN_STATUS,
6202: L_MSG_COUNT,
6203: L_MSG_DATA,
6204: P_HEADER_REC_,

Line 6332: IF Nvl(p_action_commit, Fnd_Api.G_True) <> Fnd_Api.G_False THEN

6328: if l_debug_level > 0 then
6329: oe_debug_pub.add('Commit has been triggered here! ');
6330: end if;
6331: -- Bug 9924161 : Start
6332: IF Nvl(p_action_commit, Fnd_Api.G_True) <> Fnd_Api.G_False THEN
6333: COMMIT;
6334: END IF;
6335: -- Bug 9924161 : End
6336: END IF;

Line 6348: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

6344: -- Ensure to have a clean message object table
6345: x_messages := OE_MESSAGE_OBJ_T();
6346:
6347: IF ( l_msg_count > 1 AND
6348: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6349: FOR i IN 1..l_msg_count LOOP
6350: x_messages.EXTEND;
6351: x_messages(i) :=
6352: OE_MESSAGE_OBJ(