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.

[Home] [Help]

APPS.ONT_ITM_PKG dependencies on FND_API

Line 50: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

46: p_master_organization_id => l_master_organization_id ,
47: p_line_rec => p_line_rec ,
48: x_return_status => l_return_status);
49:
50: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
51:
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
54:

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: x_return_status => l_return_status);
49:
50: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
51:
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
54:
55: -- The Flow Status is updated to Export Compliance Screening
56:

Line 71: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

67: IF l_debug_level > 0 THEN
68: OE_DEBUG_PUB.Add('Return status from flow status api '|| l_return_status,1);
69: END IF;
70:
71: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
72: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
73: END IF;
74:
75: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 75: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

71: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
72: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
73: END IF;
74:
75: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
76: x_return_status := FND_API.G_RET_STS_ERROR;
77:
78: IF l_debug_level > 0 THEN
79: oe_debug_pub.add( 'NOT ABLE TO CREATE REQUEST...' , 1 ) ;

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

72: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
73: END IF;
74:
75: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
76: x_return_status := FND_API.G_RET_STS_ERROR;
77:
78: IF l_debug_level > 0 THEN
79: oe_debug_pub.add( 'NOT ABLE TO CREATE REQUEST...' , 1 ) ;
80: END IF;

Line 94: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

90: IF l_debug_level > 0 THEN
91: OE_DEBUG_PUB.Add('Return status from flow status api '|| l_return_status,1);
92: END IF;
93:
94: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
95: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
96: END IF;
97:
98: ELSE

Line 99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

95: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
96: END IF;
97:
98: ELSE
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101:
102: END IF; -- End of checking l_return_status
103:

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: END IF;
97:
98: ELSE
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101:
102: END IF; -- End of checking l_return_status
103:
104: IF l_debug_level > 0 THEN

Line 109: WHEN FND_API.G_EXC_ERROR THEN

105: OE_DEBUG_PUB.Add('Ending process_itm_request...'|| 'for line id:'||p_line_rec.line_id);
106: END IF;
107:
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110: ROLLBACK TO CREATE_REQUEST_PUB;
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: ROLLBACK TO CREATE_REQUEST_PUB;
113: WHEN OTHERS THEN

Line 111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

107:
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110: ROLLBACK TO CREATE_REQUEST_PUB;
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: ROLLBACK TO CREATE_REQUEST_PUB;
113: WHEN OTHERS THEN
114: ROLLBACK TO CREATE_REQUEST_PUB;
115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: oe_debug_pub.add('Exiting get_address',4);
404: END IF;
405: EXCEPTION
406: WHEN OTHERS THEN
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
409: FND_MSG_PUB.Add_Exc_Msg
410: (G_PKG_NAME,
411: l_api_name

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589: -- Update Process Flag for requests with Errors
590:
591: Update_Process_Flag(p_line_rec.line_id);
592:
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595:
596: -- Check for Ship From Org Id and Ship To Org Id
597: -- Ship From/To Org_id is Mandatory for processing.

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: OE_ORDER_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
617: END IF;
618:
619: OE_MSG_PUB.Add;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: RETURN;
622: END IF;
623:
624: -- Check whether Additional Country Check is needed

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662: IF G_Dp_service_flag = 'N' AND l_Generic_Service_Flag = 'N'THEN
663: IF l_debug_level > 0 THEN
664: oe_debug_pub.add('No Service is Available...');
665: END IF;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: RETURN;
668: END IF;
669:
670: -- Initialize the Address Table

Line 799: x_return_status := FND_API.G_RET_STS_ERROR;

795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add('Ship from and customer party name are mandatory' , 1 ) ;
797: END IF;
798:
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: RETURN;
801: END IF;
802:
803: -- Inserting Records in to wsh_itm_request_control

Line 1258: x_return_status := FND_API.G_RET_STS_SUCCESS;

1254:
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'END CREATING REQUEST...' ) ;
1257: END IF;
1258: x_return_status := FND_API.G_RET_STS_SUCCESS;
1259:
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1261: WHEN FND_API.G_EXC_ERROR THEN

1257: END IF;
1258: x_return_status := FND_API.G_RET_STS_SUCCESS;
1259:
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR;

1258: x_return_status := FND_API.G_RET_STS_SUCCESS;
1259:
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;

Line 1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1267: WHEN OTHERS THEN
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1267: WHEN OTHERS THEN
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1267: WHEN OTHERS THEN
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1270: FND_MSG_PUB.Add_Exc_Msg
1271: (G_PKG_NAME,
1272: l_api_name

Line 1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1412: fnd_message.set_name('ONT', 'OE_LINE_LOCKED');
1413: OE_MSG_PUB.Add;
1414: OE_MSG_PUB.Save_API_Messages;
1415: END IF;
1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1417: END; --bug 4503620 ends
1418:
1419: OE_LINE_UTIL.Query_Row ( p_line_id => l_line_id,
1420: x_line_rec => l_line_rec);

Line 1465: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1461: x_return_status => l_return_status
1462: );
1463:
1464:
1465: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1466: OE_STANDARD_WF.Save_Messages;
1467: OE_STANDARD_WF.Clear_Msg_Context;
1468: APP_EXCEPTION.Raise_Exception;
1469: END IF;

Line 1610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1606: p_flow_status_code => 'EXPORT_SCREENING_DATA_ERROR',
1607: x_return_status => l_return_status
1608: );
1609:
1610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1611: OE_STANDARD_WF.Save_Messages;
1612: OE_STANDARD_WF.Clear_Msg_Context;
1613: APP_EXCEPTION.Raise_Exception;
1614: END IF;

Line 1637: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1633: l_hold_source_rec.line_id := l_line_rec.line_id;
1634:
1635: OE_HOLDS_PUB.Apply_Holds
1636: ( p_api_version => 1.0
1637: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1638: , p_hold_source_rec => l_hold_source_rec
1639: , x_return_status => l_return_status
1640: , x_msg_count => l_msg_count
1641: , x_msg_data => l_msg_data

Line 1644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1640: , x_msg_count => l_msg_count
1641: , x_msg_data => l_msg_data
1642: );
1643:
1644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1645: RAISE FND_API.G_EXC_ERROR;

1641: , x_msg_data => l_msg_data
1642: );
1643:
1644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1649: IF l_debug_level > 0 THEN

Line 1646: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1642: );
1643:
1644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1649: IF l_debug_level > 0 THEN
1650: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);

Line 1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1643:
1644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1649: IF l_debug_level > 0 THEN
1650: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);
1651: END IF;

Line 1648: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1645: RAISE FND_API.G_EXC_ERROR;
1646: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1649: IF l_debug_level > 0 THEN
1650: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);
1651: END IF;
1652: END IF;

Line 1660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1656: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
1657: x_return_status => l_return_status
1658: );
1659:
1660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1661: OE_STANDARD_WF.Save_Messages;
1662: OE_STANDARD_WF.Clear_Msg_Context;
1663: APP_EXCEPTION.Raise_Exception;
1664: END IF;

Line 1686: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1682: l_hold_source_rec.line_id := l_line_rec.line_id;
1683:
1684: OE_HOLDS_PUB.Apply_Holds
1685: ( p_api_version => 1.0
1686: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1687: , p_hold_source_rec => l_hold_source_rec
1688: , x_return_status => l_return_status
1689: , x_msg_count => l_msg_count
1690: , x_msg_data => l_msg_data

Line 1693: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1689: , x_msg_count => l_msg_count
1690: , x_msg_data => l_msg_data
1691: );
1692:
1693: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1694: RAISE FND_API.G_EXC_ERROR;
1695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1694: RAISE FND_API.G_EXC_ERROR;

1690: , x_msg_data => l_msg_data
1691: );
1692:
1693: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1694: RAISE FND_API.G_EXC_ERROR;
1695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1698: IF l_debug_level > 0 THEN

Line 1695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1691: );
1692:
1693: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1694: RAISE FND_API.G_EXC_ERROR;
1695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);

Line 1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1692:
1693: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1694: RAISE FND_API.G_EXC_ERROR;
1695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);
1700: END IF;

Line 1697: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1693: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1694: RAISE FND_API.G_EXC_ERROR;
1695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);
1700: END IF;
1701: END IF;

Line 1709: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1705: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
1706: x_return_status => l_return_status
1707: );
1708:
1709: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1710: OE_STANDARD_WF.Save_Messages;
1711: OE_STANDARD_WF.Clear_Msg_Context;
1712: APP_EXCEPTION.Raise_Exception;
1713: END IF;

Line 1728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1724: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
1725: x_return_status => l_return_status
1726: );
1727:
1728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1729: OE_STANDARD_WF.Save_Messages;
1730: OE_STANDARD_WF.Clear_Msg_Context;
1731: APP_EXCEPTION.Raise_Exception;
1732: END IF;

Line 1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1747:
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: ROLLBACK TO RESPONSE_API;
1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1753: FND_MSG_PUB.Add_Exc_Msg
1754: (G_PKG_NAME,
1755: l_api_name