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.ASO_TAX_INT dependencies on FND_API

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: SAVEPOINT CALCULATE_TAX_INT;
51:
52: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
53:
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: IF p_tax_control_rec.tax_level = 'HEADER' THEN
57: l_trx_id := p_tax_detail_rec.quote_header_id;
58: ELSIF p_tax_control_rec.tax_level = 'SHIPPING' THEN

Line 75: -- x_return_status := FND_API.G_RET_STS_ERROR;

71: EXCEPTION
72: WHEN OTHERS THEN
73: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TAX_EXCEPTION');
74: FND_MSG_PUB.Add;
75: -- x_return_status := FND_API.G_RET_STS_ERROR;
76: END;
77: FOR i IN 1.. l_arp_tax_tbl.count LOOP
78: OPEN c_tax_code(l_arp_tax_tbl(i).vat_tax_id);
79: FETCH c_tax_code INTO l_tax_detail_rec.TAX_CODE;

Line 169: WHEN FND_API.G_EXC_ERROR THEN

165: p_data => x_msg_data
166: );
167:
168: EXCEPTION
169: WHEN FND_API.G_EXC_ERROR THEN
170: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
171: P_API_NAME => L_API_NAME
172: ,P_PKG_NAME => G_PKG_NAME
173: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

175: ,X_MSG_COUNT => X_MSG_COUNT
176: ,X_MSG_DATA => X_MSG_DATA
177: ,X_RETURN_STATUS => X_RETURN_STATUS);
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
181: P_API_NAME => L_API_NAME
182: ,P_PKG_NAME => G_PKG_NAME
183: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 252: x_return_status := FND_API.G_RET_STS_SUCCESS;

248: SAVEPOINT CALCULATE_TAX_PUB;
249:
250: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
251:
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: l_tax_detail_rec.quote_header_id := p_quote_header_id;
255: FOR i in C_shipment(p_quote_header_id) LOOP
256: --l_tax_detail_rec.quote_header_id := p_quote_header_id;

Line 276: IF c_hd_tax%NOTFOUND or l_hd_exempt_flag is null or l_hd_exempt_flag = FND_API.G_MISS_CHAR THEN

272: c_header_id := l_tax_detail_tbl(j).quote_header_id;
273: c_shipment_id := l_tax_detail_tbl(j).quote_shipment_id;
274: OPEN c_hd_tax(c_header_id,c_shipment_id);
275: FETCH c_hd_tax into l_hd_exempt_flag,l_hd_exempt_number,l_hd_exempt_reason_code;
276: IF c_hd_tax%NOTFOUND or l_hd_exempt_flag is null or l_hd_exempt_flag = FND_API.G_MISS_CHAR THEN
277: l_hd_exempt_flag := null;
278: l_hd_exempt_number := null;
279: l_hd_exempt_reason_code := null;
280: END IF;

Line 296: IF l_tax_detail_tbl(j).quote_line_id IS NOT NULL and l_tax_detail_tbl(j).quote_line_id <> FND_API.G_MISS_NUM THEN

292: c_header_id := l_tax_detail_tbl(j).quote_header_id;
293: c_line_id := l_tax_detail_tbl(j).quote_line_id;
294: c_shipment_id := l_tax_detail_tbl(j).quote_shipment_id;
295:
296: IF l_tax_detail_tbl(j).quote_line_id IS NOT NULL and l_tax_detail_tbl(j).quote_line_id <> FND_API.G_MISS_NUM THEN
297:
298: IF aso_debug_pub.g_debug_flag = 'Y' THEN
299:
300: aso_debug_pub.add('Inside line tax c_header_id '||c_header_id ,1,'Y');

Line 361: -- ELSIF l_exempt_flag is null or l_exempt_flag = FND_API.G_MISS_CHAR or l_exempt_flag <> 'R' THEN

357: IF aso_debug_pub.g_debug_flag = 'Y' THEN
358: aso_debug_pub.add('Inside line tax detail after insert ',1,'Y');
359: END IF;
360:
361: -- ELSIF l_exempt_flag is null or l_exempt_flag = FND_API.G_MISS_CHAR or l_exempt_flag <> 'R' THEN
362: ELSIF l_hd_exempt_flag IS NOT NULL AND l_hd_exempt_flag <> FND_API.G_MISS_CHAR THEN
363:
364: IF aso_debug_pub.g_debug_flag = 'Y' THEN
365: aso_debug_pub.add('Inside line tax detail before update ',1,'Y');

Line 362: ELSIF l_hd_exempt_flag IS NOT NULL AND l_hd_exempt_flag <> FND_API.G_MISS_CHAR THEN

358: aso_debug_pub.add('Inside line tax detail after insert ',1,'Y');
359: END IF;
360:
361: -- ELSIF l_exempt_flag is null or l_exempt_flag = FND_API.G_MISS_CHAR or l_exempt_flag <> 'R' THEN
362: ELSIF l_hd_exempt_flag IS NOT NULL AND l_hd_exempt_flag <> FND_API.G_MISS_CHAR THEN
363:
364: IF aso_debug_pub.g_debug_flag = 'Y' THEN
365: aso_debug_pub.add('Inside line tax detail before update ',1,'Y');
366: END IF;

Line 415: x_return_status := FND_API.G_RET_STS_SUCCESS;

411: EXCEPTION
412:
413: WHEN OTHERS THEN
414:
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: IF aso_debug_pub.g_debug_flag = 'Y' THEN
418: aso_debug_pub.add('after new tax call in when others: ' || x_tax_amount, 1, 'Y');
419: END IF;

Line 435: WHEN FND_API.G_EXC_ERROR THEN

431: p_data => x_msg_data
432: );
433:
434: EXCEPTION
435: WHEN FND_API.G_EXC_ERROR THEN
436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
437: P_API_NAME => L_API_NAME
438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

441: ,X_MSG_COUNT => X_MSG_COUNT
442: ,X_MSG_DATA => X_MSG_DATA
443: ,X_RETURN_STATUS => X_RETURN_STATUS);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
447: P_API_NAME => L_API_NAME
448: ,P_PKG_NAME => G_PKG_NAME
449: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 815: x_return_status := FND_API.G_RET_STS_SUCCESS;

811: and organization_id = p_organization_id;
812:
813: Begin
814:
815: x_return_status := FND_API.G_RET_STS_SUCCESS;
816:
817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
818:
819: aso_debug_pub.add('ASO_TAX_INT: Begin ASO_TAX_LINE', 1, 'Y');

Line 833: If p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM then

829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
830: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Header_Row', 1, 'Y');
831: END IF;
832:
833: If p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM then
834:
835: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
836:
837: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 883: IF p_qte_header_id is not null and p_qte_header_id <> FND_API.G_MISS_NUM then

879:
880: aso_quote_misc_pvt.debug_tax_info_notification(l_qte_header_rec, l_Shipment_rec, l_reason);
881: End;
882:
883: IF p_qte_header_id is not null and p_qte_header_id <> FND_API.G_MISS_NUM then
884:
885: Begin
886:
887: -- Get the AR system parameters

Line 950: IF l_ship_from_org_id IS NULL OR l_ship_from_org_id = FND_API.G_MISS_NUM THEN

946: IF aso_debug_pub.g_debug_flag = 'Y' THEN
947: aso_debug_pub.add('ASO_TAX_LINE: After call to Get_ship_from_org_id: l_ship_from_org_id: '||l_ship_from_org_id, 1, 'Y');
948: END IF;
949:
950: IF l_ship_from_org_id IS NULL OR l_ship_from_org_id = FND_API.G_MISS_NUM THEN
951:
952: l_ship_from_org_id := fnd_profile.value( 'ASO_SHIP_FROM_ORG_ID' );
953:
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1204: IF l_site_use_id_ship is not null AND l_site_use_id_ship <> FND_API.G_MISS_NUM THEN

1200:
1201: END IF;
1202:
1203:
1204: IF l_site_use_id_ship is not null AND l_site_use_id_ship <> FND_API.G_MISS_NUM THEN
1205:
1206: l_site_use_id := l_site_use_id_ship;
1207:
1208: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1277: IF l_site_use_id_bill is not null and l_site_use_id_bill <> FND_API.G_MISS_NUM THEN

1273:
1274: END IF; -- l_site_use_id_ship;
1275:
1276:
1277: IF l_site_use_id_bill is not null and l_site_use_id_bill <> FND_API.G_MISS_NUM THEN
1278:
1279: l_site_use_id := l_site_use_id_bill;
1280:
1281: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1348: IF (l_site_use_id_ship is null OR l_site_use_id_ship = FND_API.G_MISS_NUM) AND

1344: END IF;
1345:
1346: END IF; -- l_site_use_id_bill
1347:
1348: IF (l_site_use_id_ship is null OR l_site_use_id_ship = FND_API.G_MISS_NUM) AND
1349: (l_site_use_id_bill is null OR l_site_use_id_bill = FND_API.G_MISS_NUM) THEN
1350:
1351: -- Ship to party_site information
1352: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1349: (l_site_use_id_bill is null OR l_site_use_id_bill = FND_API.G_MISS_NUM) THEN

1345:
1346: END IF; -- l_site_use_id_bill
1347:
1348: IF (l_site_use_id_ship is null OR l_site_use_id_ship = FND_API.G_MISS_NUM) AND
1349: (l_site_use_id_bill is null OR l_site_use_id_bill = FND_API.G_MISS_NUM) THEN
1350:
1351: -- Ship to party_site information
1352: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1353: aso_debug_pub.add('ASO_TAX_LINE: Before call to ASO_SHIPMENT_PVT.Get_ship_to_party_site_id', 1, 'Y');

Line 1362: IF l_party_site_id_ship IS NOT NULL AND l_party_site_id_ship <> FND_API.G_MISS_NUM THEN

1358: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1359: aso_debug_pub.add('ASO_TAX_LINE: After call to Get_ship_to_party_site_id: l_party_site_id_ship: '|| l_party_site_id_ship, 1, 'Y');
1360: END IF;
1361:
1362: IF l_party_site_id_ship IS NOT NULL AND l_party_site_id_ship <> FND_API.G_MISS_NUM THEN
1363:
1364: l_party_site_id := l_party_site_id_ship;
1365:
1366: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1401: IF l_party_site_id_bill IS NOT NULL AND l_party_site_id_bill <> FND_API.G_MISS_NUM THEN

1397: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1398: aso_debug_pub.add('ASO_TAX_LINE: After call to Get_invoice_to_party_site_id: l_party_site_id_bill: '|| l_party_site_id_bill,1,'Y');
1399: END IF;
1400:
1401: IF l_party_site_id_bill IS NOT NULL AND l_party_site_id_bill <> FND_API.G_MISS_NUM THEN
1402:
1403: l_party_site_id := l_party_site_id_bill;
1404:
1405: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2367: x_return_status := FND_API.G_RET_STS_SUCCESS;

2363: Begin
2364:
2365: Savepoint CALCULATE_TAX_WITH_GTT;
2366: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2367: x_return_status := FND_API.G_RET_STS_SUCCESS;
2368:
2369: IF aso_debug_pub.g_debug_flag = 'Y'
2370: THEN
2371: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');

Line 2430: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM

2426: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_int_org_location ', 1, 'Y');
2427: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_int_org_location : '||l_int_org_location, 1, 'Y');
2428: END IF;
2429:
2430: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM
2431: THEN
2432: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2433: IF
2434: aso_debug_pub.g_debug_flag = 'Y'

Line 2587: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID = FND_API.G_MISS_NUM) THEN

2583:
2584: /* Added for bug 9558210 */
2585:
2586: If (l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID Is Null OR
2587: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID = FND_API.G_MISS_NUM) THEN
2588:
2589: IF aso_debug_pub.g_debug_flag ='Y' THEN
2590: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID Is Null ', 1, 'Y');
2591: End if;

Line 2594: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID = FND_API.G_MISS_NUM) THEN

2590: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_CUST_PARTY_ID Is Null ', 1, 'Y');
2591: End if;
2592:
2593: If (l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Null OR
2594: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID = FND_API.G_MISS_NUM) THEN
2595:
2596: IF aso_debug_pub.g_debug_flag ='Y' THEN
2597: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID Is Null ', 1, 'Y');
2598: End if;

Line 2645: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2641:
2642:
2643: /* Added for Bug 9558210*/
2644:
2645: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2646: IF aso_debug_pub.g_debug_flag ='Y' THEN
2647: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR ', 1, 'Y');
2648: End if;
2649: raise FND_API.G_EXC_ERROR;

Line 2647: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR ', 1, 'Y');

2643: /* Added for Bug 9558210*/
2644:
2645: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2646: IF aso_debug_pub.g_debug_flag ='Y' THEN
2647: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR ', 1, 'Y');
2648: End if;
2649: raise FND_API.G_EXC_ERROR;
2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2651: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2649: raise FND_API.G_EXC_ERROR;

2645: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2646: IF aso_debug_pub.g_debug_flag ='Y' THEN
2647: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR ', 1, 'Y');
2648: End if;
2649: raise FND_API.G_EXC_ERROR;
2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2651: IF aso_debug_pub.g_debug_flag ='Y' THEN
2652: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_UNEXPECTED_ERROR ', 1, 'Y');
2653: End if;

Line 2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2646: IF aso_debug_pub.g_debug_flag ='Y' THEN
2647: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR ', 1, 'Y');
2648: End if;
2649: raise FND_API.G_EXC_ERROR;
2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2651: IF aso_debug_pub.g_debug_flag ='Y' THEN
2652: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_UNEXPECTED_ERROR ', 1, 'Y');
2653: End if;
2654: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2652: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_UNEXPECTED_ERROR ', 1, 'Y');

2648: End if;
2649: raise FND_API.G_EXC_ERROR;
2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2651: IF aso_debug_pub.g_debug_flag ='Y' THEN
2652: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_UNEXPECTED_ERROR ', 1, 'Y');
2653: End if;
2654: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2655: END IF;
2656:

Line 2654: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2650: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2651: IF aso_debug_pub.g_debug_flag ='Y' THEN
2652: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_UNEXPECTED_ERROR ', 1, 'Y');
2653: End if;
2654: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2655: END IF;
2656:
2657: If l_legal_entity_id = -1 Then
2658: IF aso_debug_pub.g_debug_flag ='Y' THEN

Line 2659: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR for l_legal_entity_id = -1', 1, 'Y');

2655: END IF;
2656:
2657: If l_legal_entity_id = -1 Then
2658: IF aso_debug_pub.g_debug_flag ='Y' THEN
2659: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR for l_legal_entity_id = -1', 1, 'Y');
2660: End if;
2661: raise FND_API.G_EXC_ERROR;
2662: End If;
2663:

Line 2661: raise FND_API.G_EXC_ERROR;

2657: If l_legal_entity_id = -1 Then
2658: IF aso_debug_pub.g_debug_flag ='Y' THEN
2659: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: RAISING FND_API.G_EXC_ERROR for l_legal_entity_id = -1', 1, 'Y');
2660: End if;
2661: raise FND_API.G_EXC_ERROR;
2662: End If;
2663:
2664: /* End for Bug 9558210*/
2665:

Line 2887: If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 14340122

2883: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_Shipment_Rec.ship_from_org_id : '||l_Shipment_Rec.ship_from_org_id, 1, 'Y');
2884: -- aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_LOCATION_ID ', 1, 'Y');
2885: END IF;
2886:
2887: If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 14340122
2888:
2889: IF aso_debug_pub.g_debug_flag ='Y' THEN
2890: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :l_ra_cust_trx_type_id Is Not Null ', 1, 'Y');
2891: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO c_LOCATION_ID ', 1, 'Y');

Line 2950: -- If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 12587408

2946: END IF;
2947:
2948: -- end of new code added by suyog
2949:
2950: -- If (l_ra_cust_trx_type_id Is Not Null And l_ra_cust_trx_type_id <> FND_API.G_MISS_NUM ) Then -- Code change done for Bug 12587408
2951:
2952: -- Code changes for Default tax Classification Code Bug 5177854 BEGIN
2953:
2954: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION

Line 3218: x_return_status := FND_API.G_RET_STS_SUCCESS;

3214: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :X_Msg_Data : '||X_Msg_Data, 1, 'Y');
3215: END IF;
3216: FND_MSG_PUB.Delete_Msg(l_msg_cnt1+1);
3217: END LOOP;
3218: x_return_status := FND_API.G_RET_STS_SUCCESS;
3219: END IF;
3220: FND_MSG_PUB.Count_And_Get
3221: (
3222: p_count => x_msg_count,

Line 3227: WHEN FND_API.G_EXC_ERROR THEN

3223: p_data => x_msg_data
3224: );
3225:
3226: EXCEPTION
3227: WHEN FND_API.G_EXC_ERROR THEN
3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3229: P_API_NAME => L_API_NAME
3230: ,P_PKG_NAME => G_PKG_NAME
3231: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3233: ,X_MSG_COUNT => X_MSG_COUNT
3234: ,X_MSG_DATA => X_MSG_DATA
3235: ,X_RETURN_STATUS => X_RETURN_STATUS);
3236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3238: P_API_NAME => L_API_NAME ,P_PKG_NAME => G_PKG_NAME
3239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3240: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3283: IF c_tax3%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN

3279: l_tax_detail_id NUMBER;
3280: BEGIN
3281: OPEN c_tax3;
3282: FETCH c_tax3 INTO l_tax_detail_id;
3283: IF c_tax3%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN
3284: CLOSE c_tax3;
3285: return l_tax_detail_id;
3286: END IF;
3287: CLOSE c_tax3;

Line 3290: IF c_tax2%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN

3286: END IF;
3287: CLOSE c_tax3;
3288: OPEN c_tax2;
3289: FETCH c_tax2 INTO l_tax_detail_id ;
3290: IF c_tax2%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN
3291: CLOSE c_tax2;
3292: return l_tax_detail_id;
3293: END IF;
3294: CLOSE c_tax2;

Line 3297: IF c_tax1%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN

3293: END IF;
3294: CLOSE c_tax2;
3295: /*OPEN c_tax1;
3296: FETCH c_tax1 INTO l_tax_detail_id;
3297: IF c_tax1%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN
3298: CLOSE c_tax1;
3299: return l_tax_detail_id;
3300: END IF;
3301: CLOSE c_tax1;*/

Line 3325: IF c_tax1%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN

3321: l_orig_tax_code VARCHAR2(240);
3322: BEGIN
3323: OPEN c_tax1;
3324: FETCH c_tax1 INTO l_orig_tax_code;
3325: IF c_tax1%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN
3326: CLOSE c_tax1;
3327: return l_orig_tax_code;
3328: END IF;
3329: CLOSE c_tax1;

Line 3332: IF c_tax2%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN

3328: END IF;
3329: CLOSE c_tax1;
3330: OPEN c_tax2;
3331: FETCH c_tax2 INTO l_orig_tax_code;
3332: IF c_tax2%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN
3333: CLOSE c_tax2;
3334: return l_orig_tax_code;
3335: END IF;
3336: CLOSE c_tax2;

Line 3339: IF c_tax3%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN

3335: END IF;
3336: CLOSE c_tax2;
3337: OPEN c_tax3;
3338: FETCH c_tax3 INTO l_orig_tax_code;
3339: IF c_tax3%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN
3340: CLOSE c_tax3;
3341: return l_orig_tax_code;
3342: END IF;
3343: CLOSE c_tax3;

Line 3365: IF c_tax1%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN

3361: l_tax_exempt_flag VARCHAR2(1);
3362: BEGIN
3363: OPEN c_tax1;
3364: FETCH c_tax1 INTO l_tax_exempt_flag;
3365: IF c_tax1%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
3366: CLOSE c_tax1;
3367: return l_tax_exempt_flag;
3368: END IF;
3369: CLOSE c_tax1;

Line 3372: IF c_tax2%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN

3368: END IF;
3369: CLOSE c_tax1;
3370: OPEN c_tax2;
3371: FETCH c_tax2 INTO l_tax_exempt_flag;
3372: IF c_tax2%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
3373: CLOSE c_tax2;
3374: return l_tax_exempt_flag;
3375: END IF;
3376: CLOSE c_tax2;

Line 3379: IF c_tax3%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN

3375: END IF;
3376: CLOSE c_tax2;
3377: OPEN c_tax3;
3378: FETCH c_tax3 INTO l_tax_exempt_flag;
3379: IF c_tax3%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
3380: CLOSE c_tax3;
3381: return l_tax_exempt_flag;
3382: END IF;
3383: CLOSE c_tax3;

Line 3405: IF c_tax1%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN

3401: l_tax_exempt_number VARCHAR2(80);
3402: BEGIN
3403: OPEN c_tax1;
3404: FETCH c_tax1 INTO l_tax_exempt_number;
3405: IF c_tax1%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN
3406: CLOSE c_tax1;
3407: return l_tax_exempt_number;
3408: END IF;
3409: CLOSE c_tax1;

Line 3412: IF c_tax2%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN

3408: END IF;
3409: CLOSE c_tax1;
3410: OPEN c_tax2;
3411: FETCH c_tax2 INTO l_tax_exempt_number;
3412: IF c_tax2%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN
3413: CLOSE c_tax2;
3414: return l_tax_exempt_number;
3415: END IF;
3416: CLOSE c_tax2;

Line 3419: IF c_tax3%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN

3415: END IF;
3416: CLOSE c_tax2;
3417: OPEN c_tax3;
3418: FETCH c_tax3 INTO l_tax_exempt_number;
3419: IF c_tax3%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN
3420: CLOSE c_tax3;
3421: return l_tax_exempt_number;
3422: END IF;
3423: CLOSE c_tax3;

Line 3445: IF c_tax1%FOUND and l_tax_exempt_reason_code is not null and l_tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN

3441: l_tax_exempt_reason_code VARCHAR2(80);
3442: BEGIN
3443: OPEN c_tax1;
3444: FETCH c_tax1 INTO l_tax_exempt_reason_code;
3445: IF c_tax1%FOUND and l_tax_exempt_reason_code is not null and l_tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
3446: CLOSE c_tax1;
3447: return l_tax_exempt_reason_code;
3448: END IF;
3449: CLOSE c_tax1;

Line 3452: IF c_tax2%FOUND and l_tax_exempt_reason_code is not null and l_tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN

3448: END IF;
3449: CLOSE c_tax1;
3450: OPEN c_tax2;
3451: FETCH c_tax2 INTO l_tax_exempt_reason_code;
3452: IF c_tax2%FOUND and l_tax_exempt_reason_code is not null and l_tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
3453: CLOSE c_tax2;
3454: return l_tax_exempt_reason_code;
3455: END IF;
3456: CLOSE c_tax2;

Line 3459: IF c_tax3%FOUND and l_tax_exempt_reason_code is not null and l_tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN

3455: END IF;
3456: CLOSE c_tax2;
3457: OPEN c_tax3;
3458: FETCH c_tax3 INTO l_tax_exempt_reason_code;
3459: IF c_tax3%FOUND and l_tax_exempt_reason_code is not null and l_tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
3460: CLOSE c_tax3;
3461: return l_tax_exempt_reason_code;
3462: END IF;
3463: CLOSE c_tax3;

Line 3493: IF p_order_type_id is NULL OR p_order_type_id = FND_API.G_MISS_NUM THEN

3489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3490: aso_debug_pub.add(' ASO_TAX_INT :p_order_type_id'||p_order_type_id , 1, 'N');
3491: END IF;
3492:
3493: IF p_order_type_id is NULL OR p_order_type_id = FND_API.G_MISS_NUM THEN
3494:
3495: -- Change START
3496: -- Release 12 MOAC Changes : Bug 4500739
3497: -- Changes Done by : Girish

Line 3531: IF p_qte_line_rec.order_line_type_id is NULL or p_qte_line_rec.order_line_type_id = FND_API.G_MISS_NUM THEN

3527: END IF;
3528:
3529: END IF;
3530: CLOSE C_OE_trns;
3531: IF p_qte_line_rec.order_line_type_id is NULL or p_qte_line_rec.order_line_type_id = FND_API.G_MISS_NUM THEN
3532:
3533: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3534: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.order_line_type_id is NULL' , 1, 'N');
3535: END IF;