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 2348: x_return_status := FND_API.G_RET_STS_SUCCESS;

2344: Begin
2345:
2346: Savepoint CALCULATE_TAX_WITH_GTT;
2347: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2348: x_return_status := FND_API.G_RET_STS_SUCCESS;
2349:
2350: IF aso_debug_pub.g_debug_flag = 'Y'
2351: THEN
2352: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');

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

2407: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to c_int_org_location ', 1, 'Y');
2408: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_int_org_location : '||l_int_org_location, 1, 'Y');
2409: END IF;
2410:
2411: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM
2412: THEN
2413: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2414: IF
2415: aso_debug_pub.g_debug_flag = 'Y'

Line 3120: x_return_status := FND_API.G_RET_STS_SUCCESS;

3116: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :X_Msg_Data : '||X_Msg_Data, 1, 'Y');
3117: END IF;
3118: FND_MSG_PUB.Delete_Msg(l_msg_cnt1+1);
3119: END LOOP;
3120: x_return_status := FND_API.G_RET_STS_SUCCESS;
3121: END IF;
3122: FND_MSG_PUB.Count_And_Get
3123: (
3124: p_count => x_msg_count,

Line 3129: WHEN FND_API.G_EXC_ERROR THEN

3125: p_data => x_msg_data
3126: );
3127:
3128: EXCEPTION
3129: WHEN FND_API.G_EXC_ERROR THEN
3130: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3131: P_API_NAME => L_API_NAME
3132: ,P_PKG_NAME => G_PKG_NAME
3133: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 3138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3134: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3135: ,X_MSG_COUNT => X_MSG_COUNT
3136: ,X_MSG_DATA => X_MSG_DATA
3137: ,X_RETURN_STATUS => X_RETURN_STATUS);
3138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3139: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3140: P_API_NAME => L_API_NAME ,P_PKG_NAME => G_PKG_NAME
3141: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3142: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

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

3181: l_tax_detail_id NUMBER;
3182: BEGIN
3183: OPEN c_tax3;
3184: FETCH c_tax3 INTO l_tax_detail_id;
3185: IF c_tax3%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN
3186: CLOSE c_tax3;
3187: return l_tax_detail_id;
3188: END IF;
3189: CLOSE c_tax3;

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

3188: END IF;
3189: CLOSE c_tax3;
3190: OPEN c_tax2;
3191: FETCH c_tax2 INTO l_tax_detail_id ;
3192: IF c_tax2%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN
3193: CLOSE c_tax2;
3194: return l_tax_detail_id;
3195: END IF;
3196: CLOSE c_tax2;

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

3195: END IF;
3196: CLOSE c_tax2;
3197: /*OPEN c_tax1;
3198: FETCH c_tax1 INTO l_tax_detail_id;
3199: IF c_tax1%FOUND and l_tax_detail_id is not null and l_tax_detail_id <> FND_API.G_MISS_NUM THEN
3200: CLOSE c_tax1;
3201: return l_tax_detail_id;
3202: END IF;
3203: CLOSE c_tax1;*/

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

3223: l_orig_tax_code VARCHAR2(240);
3224: BEGIN
3225: OPEN c_tax1;
3226: FETCH c_tax1 INTO l_orig_tax_code;
3227: IF c_tax1%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN
3228: CLOSE c_tax1;
3229: return l_orig_tax_code;
3230: END IF;
3231: CLOSE c_tax1;

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

3230: END IF;
3231: CLOSE c_tax1;
3232: OPEN c_tax2;
3233: FETCH c_tax2 INTO l_orig_tax_code;
3234: IF c_tax2%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN
3235: CLOSE c_tax2;
3236: return l_orig_tax_code;
3237: END IF;
3238: CLOSE c_tax2;

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

3237: END IF;
3238: CLOSE c_tax2;
3239: OPEN c_tax3;
3240: FETCH c_tax3 INTO l_orig_tax_code;
3241: IF c_tax3%FOUND and l_orig_tax_code IS NOT NULL AND l_orig_tax_code <> FND_API.G_MISS_CHAR THEN
3242: CLOSE c_tax3;
3243: return l_orig_tax_code;
3244: END IF;
3245: CLOSE c_tax3;

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

3263: l_tax_exempt_flag VARCHAR2(1);
3264: BEGIN
3265: OPEN c_tax1;
3266: FETCH c_tax1 INTO l_tax_exempt_flag;
3267: IF c_tax1%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
3268: CLOSE c_tax1;
3269: return l_tax_exempt_flag;
3270: END IF;
3271: CLOSE c_tax1;

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

3270: END IF;
3271: CLOSE c_tax1;
3272: OPEN c_tax2;
3273: FETCH c_tax2 INTO l_tax_exempt_flag;
3274: IF c_tax2%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
3275: CLOSE c_tax2;
3276: return l_tax_exempt_flag;
3277: END IF;
3278: CLOSE c_tax2;

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

3277: END IF;
3278: CLOSE c_tax2;
3279: OPEN c_tax3;
3280: FETCH c_tax3 INTO l_tax_exempt_flag;
3281: IF c_tax3%FOUND and l_tax_exempt_flag is not null and l_tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
3282: CLOSE c_tax3;
3283: return l_tax_exempt_flag;
3284: END IF;
3285: CLOSE c_tax3;

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

3303: l_tax_exempt_number VARCHAR2(80);
3304: BEGIN
3305: OPEN c_tax1;
3306: FETCH c_tax1 INTO l_tax_exempt_number;
3307: IF c_tax1%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN
3308: CLOSE c_tax1;
3309: return l_tax_exempt_number;
3310: END IF;
3311: CLOSE c_tax1;

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

3310: END IF;
3311: CLOSE c_tax1;
3312: OPEN c_tax2;
3313: FETCH c_tax2 INTO l_tax_exempt_number;
3314: IF c_tax2%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN
3315: CLOSE c_tax2;
3316: return l_tax_exempt_number;
3317: END IF;
3318: CLOSE c_tax2;

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

3317: END IF;
3318: CLOSE c_tax2;
3319: OPEN c_tax3;
3320: FETCH c_tax3 INTO l_tax_exempt_number;
3321: IF c_tax3%FOUND and l_tax_exempt_number is not null and l_tax_exempt_number <> FND_API.G_MISS_CHAR THEN
3322: CLOSE c_tax3;
3323: return l_tax_exempt_number;
3324: END IF;
3325: CLOSE c_tax3;

Line 3347: 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

3343: l_tax_exempt_reason_code VARCHAR2(80);
3344: BEGIN
3345: OPEN c_tax1;
3346: FETCH c_tax1 INTO l_tax_exempt_reason_code;
3347: 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
3348: CLOSE c_tax1;
3349: return l_tax_exempt_reason_code;
3350: END IF;
3351: CLOSE c_tax1;

Line 3354: 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

3350: END IF;
3351: CLOSE c_tax1;
3352: OPEN c_tax2;
3353: FETCH c_tax2 INTO l_tax_exempt_reason_code;
3354: 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
3355: CLOSE c_tax2;
3356: return l_tax_exempt_reason_code;
3357: END IF;
3358: CLOSE c_tax2;

Line 3361: 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

3357: END IF;
3358: CLOSE c_tax2;
3359: OPEN c_tax3;
3360: FETCH c_tax3 INTO l_tax_exempt_reason_code;
3361: 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
3362: CLOSE c_tax3;
3363: return l_tax_exempt_reason_code;
3364: END IF;
3365: CLOSE c_tax3;

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

3391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3392: aso_debug_pub.add(' ASO_TAX_INT :p_order_type_id'||p_order_type_id , 1, 'N');
3393: END IF;
3394:
3395: IF p_order_type_id is NULL OR p_order_type_id = FND_API.G_MISS_NUM THEN
3396:
3397: -- Change START
3398: -- Release 12 MOAC Changes : Bug 4500739
3399: -- Changes Done by : Girish

Line 3433: 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

3429: END IF;
3430:
3431: END IF;
3432: CLOSE C_OE_trns;
3433: 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
3434:
3435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3436: aso_debug_pub.add(' ASO_TAX_INT p_qte_line_rec.order_line_type_id is NULL' , 1, 'N');
3437: END IF;