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.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 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: oe_debug_pub.add('Exiting get_address',4);
518: END IF;
519: EXCEPTION
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
523: FND_MSG_PUB.Add_Exc_Msg
524: (G_PKG_NAME,
525: l_api_name

Line 730: x_return_status := FND_API.G_RET_STS_SUCCESS;

726: -- Update Process Flag for requests with Errors
727:
728: Update_Process_Flag(p_line_rec.header_id, p_line_rec.line_id); -- Bug 11797031
729:
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732:
733: -- Check for Ship From Org Id and Ship To Org Id
734: -- Ship From/To Org_id is Mandatory for processing.

Line 757: x_return_status := FND_API.G_RET_STS_ERROR;

753: OE_ORDER_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
754: END IF;
755:
756: OE_MSG_PUB.Add;
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: RETURN;
759: END IF;
760:
761: -- Check whether Additional Country Check is needed

Line 803: x_return_status := FND_API.G_RET_STS_ERROR;

799: IF G_Dp_service_flag = 'N' AND l_Generic_Service_Flag = 'N'THEN
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('No Service is Available...');
802: END IF;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: RETURN;
805: END IF;
806:
807: -- Initialize the Address Table

Line 979: x_return_status := FND_API.G_RET_STS_ERROR;

975: IF l_debug_level > 0 THEN
976: oe_debug_pub.add('Ship from and customer party name are mandatory' , 1 ) ;
977: END IF;
978:
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: RETURN;
981: END IF;
982:
983: -- Inserting Records in to wsh_itm_request_control

Line 1462: x_return_status := FND_API.G_RET_STS_SUCCESS;

1458:
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add( 'END CREATING REQUEST...' ) ;
1461: END IF;
1462: x_return_status := FND_API.G_RET_STS_SUCCESS;
1463:
1464: EXCEPTION
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1465: WHEN FND_API.G_EXC_ERROR THEN

1461: END IF;
1462: x_return_status := FND_API.G_RET_STS_SUCCESS;
1463:
1464: EXCEPTION
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1466: x_return_status := FND_API.G_RET_STS_ERROR;

1462: x_return_status := FND_API.G_RET_STS_SUCCESS;
1463:
1464: EXCEPTION
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;

Line 1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1464: EXCEPTION
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1471: WHEN OTHERS THEN
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1471: WHEN OTHERS THEN
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1471: WHEN OTHERS THEN
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1474: FND_MSG_PUB.Add_Exc_Msg
1475: (G_PKG_NAME,
1476: l_api_name

Line 1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1736: fnd_message.set_name('ONT', 'OE_LINE_LOCKED');
1737: OE_MSG_PUB.Add;
1738: OE_MSG_PUB.Save_API_Messages;
1739: END IF;
1740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1741: END; --bug 4503620 ends
1742:
1743: OE_LINE_UTIL.Query_Row ( p_line_id => l_line_id,
1744: x_line_rec => l_line_rec);

Line 1789: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1785: x_return_status => l_return_status
1786: );
1787:
1788:
1789: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1790: OE_STANDARD_WF.Save_Messages;
1791: OE_STANDARD_WF.Clear_Msg_Context;
1792: APP_EXCEPTION.Raise_Exception;
1793: END IF;

Line 1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1938: p_flow_status_code => 'EXPORT_SCREENING_DATA_ERROR',
1939: x_return_status => l_return_status
1940: );
1941:
1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1943: OE_STANDARD_WF.Save_Messages;
1944: OE_STANDARD_WF.Clear_Msg_Context;
1945: APP_EXCEPTION.Raise_Exception;
1946: END IF;

Line 1969: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

1965: l_hold_source_rec.line_id := l_line_rec.line_id;
1966:
1967: OE_HOLDS_PUB.Apply_Holds
1968: ( p_api_version => 1.0
1969: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
1970: , p_hold_source_rec => l_hold_source_rec
1971: , x_return_status => l_return_status
1972: , x_msg_count => l_msg_count
1973: , x_msg_data => l_msg_data

Line 1976: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1972: , x_msg_count => l_msg_count
1973: , x_msg_data => l_msg_data
1974: );
1975:
1976: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1977: RAISE FND_API.G_EXC_ERROR;

1973: , x_msg_data => l_msg_data
1974: );
1975:
1976: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1981: IF l_debug_level > 0 THEN

Line 1978: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1974: );
1975:
1976: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);

Line 1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1975:
1976: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);
1983: END IF;

Line 1980: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1976: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);
1983: END IF;
1984: END IF;

Line 1992: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1988: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
1989: x_return_status => l_return_status
1990: );
1991:
1992: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1993: OE_STANDARD_WF.Save_Messages;
1994: OE_STANDARD_WF.Clear_Msg_Context;
1995: APP_EXCEPTION.Raise_Exception;
1996: END IF;

Line 2018: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

2014: l_hold_source_rec.line_id := l_line_rec.line_id;
2015:
2016: OE_HOLDS_PUB.Apply_Holds
2017: ( p_api_version => 1.0
2018: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
2019: , p_hold_source_rec => l_hold_source_rec
2020: , x_return_status => l_return_status
2021: , x_msg_count => l_msg_count
2022: , x_msg_data => l_msg_data

Line 2025: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2021: , x_msg_count => l_msg_count
2022: , x_msg_data => l_msg_data
2023: );
2024:
2025: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2026: RAISE FND_API.G_EXC_ERROR;
2027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2026: RAISE FND_API.G_EXC_ERROR;

2022: , x_msg_data => l_msg_data
2023: );
2024:
2025: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2026: RAISE FND_API.G_EXC_ERROR;
2027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2030: IF l_debug_level > 0 THEN

Line 2027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2023: );
2024:
2025: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2026: RAISE FND_API.G_EXC_ERROR;
2027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2030: IF l_debug_level > 0 THEN
2031: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);

Line 2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2024:
2025: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2026: RAISE FND_API.G_EXC_ERROR;
2027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2030: IF l_debug_level > 0 THEN
2031: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);
2032: END IF;

Line 2029: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2025: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2026: RAISE FND_API.G_EXC_ERROR;
2027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2030: IF l_debug_level > 0 THEN
2031: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);
2032: END IF;
2033: END IF;

Line 2041: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2037: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
2038: x_return_status => l_return_status
2039: );
2040:
2041: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2042: OE_STANDARD_WF.Save_Messages;
2043: OE_STANDARD_WF.Clear_Msg_Context;
2044: APP_EXCEPTION.Raise_Exception;
2045: END IF;

Line 2060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2056: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
2057: x_return_status => l_return_status
2058: );
2059:
2060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2061: OE_STANDARD_WF.Save_Messages;
2062: OE_STANDARD_WF.Clear_Msg_Context;
2063: APP_EXCEPTION.Raise_Exception;
2064: END IF;

Line 2085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2081:
2082: EXCEPTION
2083: WHEN OTHERS THEN
2084: ROLLBACK TO RESPONSE_API;
2085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2087: FND_MSG_PUB.Add_Exc_Msg
2088: (G_PKG_NAME,
2089: l_api_name