DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on FND_API

Line 205: l_return_status := FND_API.G_RET_STS_SUCCESS;

201: l_POO_LOCATION_ID NUMBER;
202: BEGIN
203:
204: IF G_DEBUG_BYPASS_TAX = 'Y' THEN
205: l_return_status := FND_API.G_RET_STS_SUCCESS;
206: return;
207: END IF;
208:
209: l_line_rec := p_line_rec;

Line 210: l_return_status := FND_API.G_RET_STS_SUCCESS;

206: return;
207: END IF;
208:
209: l_line_rec := p_line_rec;
210: l_return_status := FND_API.G_RET_STS_SUCCESS;
211: l_entity_code_crsr := 'OE_ORDER_HEADERS';
212: l_event_class_code_crsr := 'SALES_TRANSACTION_TAX_QUOTE';
213: l_trx_level_type_crsr := 'LINE';
214: l_line_id := l_line_rec.line_id;

Line 506: AND l_ship_from_org_id <> FND_API.G_MISS_NUM)

502: END;
503: */
504: -- bug 4622791
505: IF (l_ship_from_org_id IS NOT NULL
506: AND l_ship_from_org_id <> FND_API.G_MISS_NUM)
507: THEN
508: BEGIN
509: SELECT location_id
510: INTO l_ship_from_location_id

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: , p_org_id => p_header_rec.org_id
599: );
600:
601: if l_legal_entity_id = -1 THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: i:= 1;
606: zx_global_structures_pkg.init_trx_line_dist_tbl(i);

Line 1073: p_init_msg_list => FND_API.G_TRUE,

1069: l_transaction_rec.internal_organization_id := l_line_rec.org_id;
1070:
1071: zx_api_pub.calculate_tax(
1072: p_api_version => 1.0,
1073: p_init_msg_list => FND_API.G_TRUE,
1074: p_commit => NULL,
1075: p_validation_level => NULL,
1076: x_return_status => l_return_status,
1077: x_msg_count => l_msg_count,

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

1100: END IF;
1101:
1102: ELSIF l_msg_count > 1 THEN
1103: LOOP
1104: l_msg_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1105: IF l_msg_data is null then
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add('msg data is null',2);
1108: END IF;

Line 1121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1117: END IF;
1118: END LOOP;
1119: END IF;
1120:
1121: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1122: IF l_debug_level > 0 THEN
1123: oe_debug_pub.add('tax engine call returned unexp error',1);
1124: END IF;
1125: x_return_status := l_return_status; -- nocopy related change

Line 1127: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1123: oe_debug_pub.add('tax engine call returned unexp error',1);
1124: END IF;
1125: x_return_status := l_return_status; -- nocopy related change
1126: RETURN;
1127: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add('tax engine call returned error',1);
1130: END IF;
1131: x_return_status := l_return_status; -- nocopy related change

Line 1133: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1129: oe_debug_pub.add('tax engine call returned error',1);
1130: END IF;
1131: x_return_status := l_return_status; -- nocopy related change
1132: RETURN;
1133: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add('tax engine call returned successfully',1);
1136: END IF;
1137: x_return_status := l_return_status; -- nocopy related change

Line 1194: x_return_status := FND_API.G_RET_STS_SUCCESS;

1190:
1191: EXCEPTION
1192:
1193: WHEN NO_DATA_FOUND THEN
1194: x_return_status := FND_API.G_RET_STS_SUCCESS;
1195:
1196: WHEN OTHERS THEN
1197: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN

Line 1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1204:
1205: IF l_debug_level > 0 THEN
1206: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
1207: END IF;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210:
1211: --dbms_output.put_line('some error occurred ' || sqlerrm );
1212:

Line 1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1205: IF l_debug_level > 0 THEN
1206: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
1207: END IF;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210:
1211: --dbms_output.put_line('some error occurred ' || sqlerrm );
1212:
1213: END TAX_LINE;

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

1217: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) AS
1218:
1219: l_index NUMBER := 1;
1220: l_entity_id_tbl OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type;
1221: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1222: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1223:
1224: TYPE num_tbl is TABLE OF NUMBER;
1225: l_num_tbl num_tbl := num_tbl();

Line 1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1261: IF l_debug_level > 0 THEN
1262: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
1263: END IF;
1264:
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267:
1268: END CALCULATE_TAX;
1269:

Line 1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1262: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
1263: END IF;
1264:
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267:
1268: END CALCULATE_TAX;
1269:
1270:

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

1572: l_customer_id NUMBER;
1573: l_batch_source_id NUMBER;
1574: l_sold_to_customer_id NUMBER;
1575: l_cust_trx_type_id NUMBER;
1576: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1577: l_legal_entity_id NUMBER;
1578: l_msg_data VARCHAR2(1000);
1579: BEGIN
1580:

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

1639: p_batch_source_id => l_invoice_source_id, -- IN P_batch_source_id
1640: p_operating_unit_id => p_org_id -- IN P_operating_unit_id (org_id)
1641: );
1642:
1643: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_legal_entity_id = -1 THEN
1644:
1645: IF l_debug_level > 0 THEN
1646: oe_debug_pub.add('In getting legal_entity_id, return status error'||l_msg_data);
1647: END IF;

Line 1751: RAISE FND_API.G_EXC_ERROR;

1747: ELSE
1748: IF l_debug_level > 0 THEN
1749: oe_debug_pub.add('Return Status from ZX_TCM_PTP_PKG.get_tax_subscriber '||l_return_status, 1) ;
1750: END IF;
1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753:
1754: EXCEPTION
1755: WHEN OTHERS THEN