DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on FND_API

Line 49: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN

45: l_charge_tbl charge_tbl;
46: Is_fmt BOOLEAN;
47:
48: BEGIN
49: IF p_header_id is NULL OR p_header_id = FND_API.G_MISS_NUM THEN
50:
51: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
52: THEN
53:

Line 59: RAISE FND_API.G_EXC_ERROR;

55: FND_MESSAGE.SET_TOKEN ('ATTRIBUTE','header');
56: OE_MSG_PUB.Add;
57:
58: END IF;
59: RAISE FND_API.G_EXC_ERROR;
60:
61: END IF;
62:
63: IF NVL (p_header_id,-1) <>NVL(OE_ORDER_UTIL.G_Header_id,-10)

Line 254: l_return_status := FND_API.G_RET_STS_SUCCESS;

250: BEGIN
251: SELECT FND_PROFILE.VALUE('ONT_SOURCE_CODE') INTO l_dummy FROM DUAL;
252: oe_debug_pub.add('11056686-Profile Value-1 = '||l_dummy);
253: IF G_DEBUG_BYPASS_TAX = 'Y' THEN
254: l_return_status := FND_API.G_RET_STS_SUCCESS;
255: RETURN;
256: END IF;
257: /* initialising common variables */
258: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 258: l_return_status := FND_API.G_RET_STS_SUCCESS;

254: l_return_status := FND_API.G_RET_STS_SUCCESS;
255: RETURN;
256: END IF;
257: /* initialising common variables */
258: l_return_status := FND_API.G_RET_STS_SUCCESS;
259: l_entity_code_crsr := 'OE_ORDER_HEADERS';
260: l_event_class_code_crsr := 'SALES_TRANSACTION_TAX_QUOTE';
261: l_call_tax := 'N';
262: l_tax_value := 0;

Line 532: IF (l_ship_from_org_id IS NOT NULL AND l_ship_from_org_id <> FND_API.G_MISS_NUM) THEN

528: oe_debug_pub.add('trx business:'||l_trx_business_category,3);
529: END IF;
530: /* per bug 5193035:OM should not pass product_type, otherwise other product category etc won't default*/
531: l_product_type := NULL;
532: IF (l_ship_from_org_id IS NOT NULL AND l_ship_from_org_id <> FND_API.G_MISS_NUM) THEN
533: BEGIN
534: SELECT location_id
535: INTO l_ship_from_location_id
536: FROM hr_all_organization_units hu

Line 600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

596: l_bill_from_location_id := NULL;
597: END;
598: l_legal_entity_id := get_le_id(p_order_type_id => l_header_rec.order_type_id , p_sold_to_customer_id => l_header_rec.sold_to_org_id , p_bill_to_customer_id => l_bill_to_customer_id , p_org_id => l_header_rec.org_id );
599: IF l_legal_entity_id = -1 THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602: IF l_level = 'H' THEN
603: l_charge_tbl:= get_charge_details(p_header_id=>l_header_rec.header_id, p_line_id=>NULL);
604: FOR j IN 1..l_charge_tbl.count

Line 1944: p_init_msg_list => FND_API.G_TRUE,

1940: l_transaction_rec.internal_organization_id := l_org_id;
1941:
1942: IF l_call_tax = 'Y' THEN
1943: zx_api_pub.calculate_tax( p_api_version => 1.0,
1944: p_init_msg_list => FND_API.G_TRUE,
1945: p_commit => NULL,
1946: p_validation_level => NULL,
1947: x_return_status => l_return_status,
1948: x_msg_count => l_msg_count,

Line 1975: l_msg_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

1971: OE_MSG_PUB.Add_text('Tax engine call raised Error ' ); --For bug # 4206796
1972: END IF;
1973: ELSIF l_msg_count > 1 THEN
1974: LOOP
1975: l_msg_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1976: IF l_msg_data IS NULL THEN
1977: IF l_debug_level > 0 THEN
1978: oe_debug_pub.add('msg data is null',2);
1979: END IF;

Line 1991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1987: OE_MSG_PUB.Add;
1988: END IF;
1989: END LOOP;
1990: END IF;
1991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: IF l_debug_level > 0 THEN
1993: oe_debug_pub.add('tax engine call returned unexp error',1);
1994: END IF;
1995: x_return_status := l_return_status; -- nocopy related change

Line 1997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1993: oe_debug_pub.add('tax engine call returned unexp error',1);
1994: END IF;
1995: x_return_status := l_return_status; -- nocopy related change
1996: RETURN;
1997: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1998: IF l_debug_level > 0 THEN
1999: oe_debug_pub.add('tax engine call returned error',1);
2000: END IF;
2001: x_return_status := l_return_status; -- nocopy related change

Line 2003: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1999: oe_debug_pub.add('tax engine call returned error',1);
2000: END IF;
2001: x_return_status := l_return_status; -- nocopy related change
2002: RETURN;
2003: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2004: IF l_debug_level > 0 THEN
2005: oe_debug_pub.add('tax engine call returned successfully',1);
2006: END IF;
2007: x_return_status := l_return_status; -- nocopy related change

Line 2050: x_return_status := FND_API.G_RET_STS_SUCCESS;

2046: oe_debug_pub.add('End tax Line');
2047: EXCEPTION
2048: WHEN NO_DATA_FOUND THEN
2049:
2050: x_return_status := FND_API.G_RET_STS_SUCCESS;
2051: WHEN OTHERS THEN
2052: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2053: OE_MSG_PUB.Add_Exc_Msg ( 'OM_TAX_UTIL' , 'Tax_Line' );
2054: END IF;

Line 2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2054: END IF;
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
2057: END IF;
2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: --dbms_output.put_line('some error occurred ' || sqlerrm );
2061: END TAX_LINE;
2062:

Line 2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
2057: END IF;
2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: --dbms_output.put_line('some error occurred ' || sqlerrm );
2061: END TAX_LINE;
2062:
2063:

Line 2071: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2067:
2068: l_index NUMBER := 1;
2069: j NUMBER; --TAX ER
2070: l_entity_id_tbl OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type;
2071: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2073: l_org_id NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id;
2074:
2075: TYPE num_tbl is TABLE OF NUMBER;

Line 2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2124: IF l_debug_level > 0 THEN
2125: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
2126: END IF;
2127:
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2130:
2131: END CALCULATE_TAX;
2132:

Line 2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2125: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
2126: END IF;
2127:
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2130:
2131: END CALCULATE_TAX;
2132:
2133:

Line 2444: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2440: l_customer_id NUMBER;
2441: l_batch_source_id NUMBER;
2442: l_sold_to_customer_id NUMBER;
2443: l_cust_trx_type_id NUMBER;
2444: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2445: l_legal_entity_id NUMBER;
2446: l_msg_data VARCHAR2(1000);
2447: BEGIN
2448:

Line 2511: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_legal_entity_id = -1 THEN

2507: p_batch_source_id => l_invoice_source_id, -- IN P_batch_source_id
2508: p_operating_unit_id => p_org_id -- IN P_operating_unit_id (org_id)
2509: );
2510:
2511: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_legal_entity_id = -1 THEN
2512:
2513: IF l_debug_level > 0 THEN
2514: oe_debug_pub.add('In getting legal_entity_id, return status error'||l_msg_data);
2515: END IF;

Line 2619: RAISE FND_API.G_EXC_ERROR;

2615: ELSE
2616: IF l_debug_level > 0 THEN
2617: oe_debug_pub.add('Return Status from ZX_TCM_PTP_PKG.get_tax_subscriber '||l_return_status, 1) ;
2618: END IF;
2619: RAISE FND_API.G_EXC_ERROR;
2620: END IF;
2621:
2622: EXCEPTION
2623: WHEN OTHERS THEN