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

Line 162: IF Not FND_API.Compatible_API_Call

158: BEGIN
159:
160: SavePoint Update_Req_Info_GRP;
161:
162: IF Not FND_API.Compatible_API_Call
163: (L_API_Version,
164: P_API_Version,
165: L_API_Name,
166: G_PKG_Name)

Line 168: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

164: P_API_Version,
165: L_API_Name,
166: G_PKG_Name)
167: THEN
168: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: -- Returns OE's profile value for SO_SOURCE_CODE
172: FND_PROFILE.Get('ONT_SOURCE_CODE',G_OE_SOURCE_CODE);

Line 177: P_Return_Status := FND_API.G_RET_STS_SUCCESS;

173:
174: IF P_Interface_Source_Code = G_OE_Source_Code THEN
175: Null;
176: ELSE -- Interface source code is not an OE interface source code
177: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
178: Return;
179: END IF;
180:
181: IF Valid_Drop_Ship_Source_Id(P_INTERFACE_SOURCE_LINE_ID) Then

Line 185: P_Return_Status := FND_API.G_RET_STS_ERROR;

181: IF Valid_Drop_Ship_Source_Id(P_INTERFACE_SOURCE_LINE_ID) Then
182: Null;
183: ELSE -- The drop ship source ID does not exist. Serious Error!
184: Rollback to Update_Req_INfo_GRP;
185: P_Return_Status := FND_API.G_RET_STS_ERROR;
186: Return;
187: End If;
188: --
189:

Line 232: p_return_status := FND_API.G_RET_STS_SUCCESS;

228: P_Line_Location_ID => Null);
229: END IF;
230: END IF;
231: CLOSE L_OE_Drop_Ship_Source_Csr;
232: p_return_status := FND_API.G_RET_STS_SUCCESS;
233: EXCEPTION
234: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- bug 4503620
235: Rollback to Update_Req_Info_Grp;
236: IF l_debug_level > 0 THEN

Line 243: p_return_status := FND_API.G_RET_STS_ERROR;

239: fnd_message.set_name('ONT', 'OE_LINE_LOCKED');
240: -- msg not added in OE as the msg ctx is not set
241: P_Msg_Data := FND_MESSAGE.GET;
242: P_Msg_Count := 1;
243: p_return_status := FND_API.G_RET_STS_ERROR;
244:
245: WHEN OTHERS THEN
246: Rollback to Update_Req_Info_Grp;
247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: p_return_status := FND_API.G_RET_STS_ERROR;
244:
245: WHEN OTHERS THEN
246: Rollback to Update_Req_Info_Grp;
247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
251: END IF;

Line 303: IF Not FND_API.Compatible_API_Call (L_API_Version,

299: BEGIN
300:
301: SAVEPOINT UPDATE_ALL_REQS_IN_PROCESS;
302:
303: IF Not FND_API.Compatible_API_Call (L_API_Version,
304: P_API_Version,
305: L_API_Name,
306: G_PKG_Name)
307: THEN

Line 308: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

304: P_API_Version,
305: L_API_Name,
306: G_PKG_Name)
307: THEN
308: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310:
311: OPEN L_PO_Req_Interface_CSR;
312: LOOP

Line 318: p_return_status := FND_API.G_RET_STS_SUCCESS;

314: L_Interface_Source_Line_Id,
315: L_Requisition_Header_Id,
316: L_Requisition_Line_Id;
317: IF L_PO_Req_Interface_CSR%NotFound THEN
318: p_return_status := FND_API.G_RET_STS_SUCCESS;
319: EXIT;
320: END IF;
321:
322: Update_Req_Info(1.0,

Line 333: IF l_return_Status = FND_API.G_RET_STS_SUCCESS THEN

329: L_Requisition_Line_ID);
330:
331: p_return_status := l_Return_Status ;
332:
333: IF l_return_Status = FND_API.G_RET_STS_SUCCESS THEN
334: Null;
335: ELSE
336: CLOSE L_PO_Req_Interface_CSR;
337: EXIT;

Line 348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344: EXCEPTION
345:
346: WHEN OTHERS THEN
347: ROLLBACK TO UPDATE_ALL_REQS_IN_PROCESS;
348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
352: END IF;

Line 405: IF Not FND_API.Compatible_API_Call (L_API_Version,

401: --
402: BEGIN
403:
404: SavePoint Update_PO_Info_GRP;
405: IF Not FND_API.Compatible_API_Call (L_API_Version,
406: P_API_Version,
407: L_API_Name,
408: G_PKG_Name)
409: THEN

Line 410: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

406: P_API_Version,
407: L_API_Name,
408: G_PKG_Name)
409: THEN
410: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
411: END IF;
412: --
413: OPEN L_OE_Drop_Ship_SOurce_Csr(P_REQ_LINE_ID,P_REQ_HEADER_ID);
414: FETCH L_OE_Drop_Ship_Source_Csr Into G_Drop_Ship_Source_ID,

Line 453: P_Return_Status := FND_API.G_RET_STS_SUCCESS;

449: P_PO_Release_Id => P_PO_Release_ID);
450: END IF;
451: END IF;
452: CLOSE L_OE_Drop_Ship_Source_Csr;
453: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
454:
455: EXCEPTION
456: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- bug 4503620
457: Rollback to Update_PO_Info_GRP;

Line 465: p_return_status := FND_API.G_RET_STS_ERROR;

461: fnd_message.set_name('ONT', 'OE_LINE_LOCKED');
462: -- msg not added in OE as the msg ctx is not set
463: P_Msg_Data := FND_MESSAGE.GET;
464: P_Msg_Count := 1;
465: p_return_status := FND_API.G_RET_STS_ERROR;
466:
467: WHEN OTHERS THEN
468: ROLLBACK TO Update_PO_Info_GRP;
469: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 469: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

465: p_return_status := FND_API.G_RET_STS_ERROR;
466:
467: WHEN OTHERS THEN
468: ROLLBACK TO Update_PO_Info_GRP;
469: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
470: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
471: THEN
472: OE_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
473: END IF;

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569: l_num_lines NUMBER;
570:
571: BEGIN
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575: SAVEPOINT Update_Drop_Ship_Links_GRP;
576:
577: IF l_debug_level > 0 THEN

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: IF l_debug_level > 0 THEN
622: OE_DEBUG_PUB.Add('No DAta Found in Update_Drop_Ship_Links...',1);
623: END IF;
624:
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626:
627: ROLLBACK TO Update_Drop_Ship_Links;
628:
629:

Line 634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

630: WHEN OTHERS THEN
631:
632: ROLLBACK TO Update_Drop_Ship_Links;
633:
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635:
636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
637: THEN
638: OE_MSG_PUB.Add_Exc_Msg(

Line 928: x_return_status := FND_API.G_RET_STS_SUCCESS;

924: l_org_id NUMBER;
925: l_num_lines NUMBER;
926: BEGIN
927:
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: IF l_debug_level > 0 THEN
931: OE_DEBUG_PUB.Add('Entering Get_Order_Line_Status...',1);
932: END IF;

Line 974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

970: IF l_debug_level > 0 THEN
971: OE_DEBUG_PUB.Add('No DAta Found in Update_Drop_Ship_Links...',1);
972: END IF;
973:
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975:
976: ROLLBACK TO Update_Drop_Ship_Links;
977:
978: WHEN OTHERS THEN

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: IF l_debug_level > 0 THEN
1059: OE_DEBUG_PUB.Add('Entering Get_Order_Line_Info '||p_mode,1);
1060: END IF;
1061:
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063: l_access_mode := mo_global.Get_access_mode; -- MOAC
1064: l_current_org_id := mo_global.get_current_org_id();
1065:
1066: Get_Drop_Ship_Line_ids

Line 1086: RAISE FND_API.G_EXC_ERROR;

1082: IF l_debug_level > 0 THEN
1083: OE_DEBUG_PUB.Add
1084: ('no line for this po_location_id '|| p_po_line_location_id,3);
1085: END IF;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;
1088:
1089: SELECT org_id
1090: INTO l_po_org_id -- l_num_lines 4148163

Line 1124: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1120: IF l_debug_level > 0 THEN
1121: OE_DEBUG_PUB.Add('context switched ' || x_return_status,3);
1122: END IF;
1123:
1124: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;

Line 1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1121: OE_DEBUG_PUB.Add('context switched ' || x_return_status,3);
1122: END IF;
1123:
1124: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129: END IF;

Line 1126: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1122: END IF;
1123:
1124: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129: END IF;
1130:

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123:
1124: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129: END IF;
1130:
1131: IF NVL(to_number(FND_GLOBAL.USER_ID),-1) = -1 OR

Line 1149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1145: IF l_debug_level > 0 THEN
1146: OE_DEBUG_PUB.Add('context switched for no context' || x_return_status,3);
1147: END IF;
1148:
1149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1152: RAISE FND_API.G_EXC_ERROR;
1153: END IF;

Line 1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1146: OE_DEBUG_PUB.Add('context switched for no context' || x_return_status,3);
1147: END IF;
1148:
1149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1152: RAISE FND_API.G_EXC_ERROR;
1153: END IF;
1154:

Line 1151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1147: END IF;
1148:
1149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1152: RAISE FND_API.G_EXC_ERROR;
1153: END IF;
1154:
1155: l_reset_context := 1;

Line 1152: RAISE FND_API.G_EXC_ERROR;

1148:
1149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1152: RAISE FND_API.G_EXC_ERROR;
1153: END IF;
1154:
1155: l_reset_context := 1;
1156:

Line 1398: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1394: ,x_msg_count => x_msg_count
1395: ,x_msg_data => x_msg_data);
1396: END IF;
1397:
1398: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;

Line 1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1395: ,x_msg_data => x_msg_data);
1396: END IF;
1397:
1398: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403:

Line 1400: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1396: END IF;
1397:
1398: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403:
1404: IF l_shipping_method_code is NOT NULL THEN

Line 1401: RAISE FND_API.G_EXC_ERROR;

1397:
1398: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403:
1404: IF l_shipping_method_code is NOT NULL THEN
1405: oe_debug_pub.add('here'|| l_shipping_method_code, 1);

Line 1447: WHEN FND_API.G_EXC_ERROR THEN

1443: OE_DEBUG_PUB.Add('Leaving Get_Order_Line_Info',1);
1444: END IF;
1445:
1446: EXCEPTION
1447: WHEN FND_API.G_EXC_ERROR THEN
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449:
1450: IF l_debug_level > 0 THEN
1451: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);

Line 1448: x_return_status := FND_API.G_RET_STS_ERROR;

1444: END IF;
1445:
1446: EXCEPTION
1447: WHEN FND_API.G_EXC_ERROR THEN
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449:
1450: IF l_debug_level > 0 THEN
1451: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);
1452: END IF;

Line 1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1452: END IF;
1453:
1454: WHEN others THEN
1455:
1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457:
1458: IF l_debug_level > 0 THEN
1459: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);
1460: END IF;

Line 1511: x_return_status := FND_API.G_RET_STS_SUCCESS;

1507: IF l_debug_level > 0 THEN
1508: OE_DEBUG_PUB.Add('Entering Purge_Drop_Ship_PO_Links...',1);
1509: END IF;
1510:
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: FOR I in 1..p_entity_id_tbl.COUNT LOOP
1514:
1515: IF l_debug_level > 0 THEN

Line 1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1551: EXCEPTION
1552:
1553: WHEN OTHERS THEN
1554:
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556:
1557: IF l_debug_level > 0 THEN
1558: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Links...'||sqlerrm,4);
1559: END IF;

Line 1604: x_return_status := FND_API.G_RET_STS_SUCCESS;

1600: IF l_debug_level > 0 THEN
1601: OE_DEBUG_PUB.Add('Entering Purge_Drop_Ship_PO_Validation...',1);
1602: END IF;
1603:
1604: x_return_status := FND_API.G_RET_STS_SUCCESS;
1605: x_purge_allowed_tbl := VAL_STATUS_TBL_TYPE();
1606:
1607: x_purge_allowed_tbl.extend(p_entity_id_tbl.COUNT);
1608:

Line 1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1669: EXCEPTION
1670:
1671: WHEN OTHERS THEN
1672:
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674:
1675: IF l_debug_level > 0 THEN
1676: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Validation...'||sqlerrm,4);
1677: END IF;