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.JL_AR_APPLICABLE_TAXES dependencies on JGZZ_AR_TAX_GLOBAL_TMP

Line 359: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_TAXPAYER_ID_NOT_AVAILABLE'

355: IF l_taxpayer = 'N' AND l_taxpayer_ar = 'N' THEN
356: IF p_debug_log = 'Y' THEN
357: FND_FILE.put_line( FND_FILE.LOG,'TAXPAYER ID IS NOT AVAILABLE');
358: END IF;
359: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_TAXPAYER_ID_NOT_AVAILABLE'
360: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
361: RETURN FALSE;
362:
363: END IF;

Line 448: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAIL_BASIC_CHECK'

444: ELSIF (valid_flag = 'N') THEN
445: IF p_debug_log = 'Y' THEN
446: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING BASIC CHECK VALIDATION, PLEASE REFER LOG FILE/REPORT ');
447: END IF;
448: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAIL_BASIC_CHECK'
449: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
450:
451: RETURN FALSE;
452: END IF;

Line 465: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAIL_BASIC_CHECK'

461: WHEN OTHERS THEN
462: IF p_debug_log = 'Y' THEN
463: FND_FILE.PUT_LINE( FND_FILE.LOG,'AN ERROR WAS ENCOUNTERED DURING BASIC CHECK VALIDATION'|| SQLCODE || 'ERROR' || SQLERRM);
464: END IF;
465: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAIL_BASIC_CHECK'
466: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
467:
468: RETURN FALSE;
469:

Line 606: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_AP_WRONG_DATE'

602: duplicate_check_flag := 'Y';
603: IF p_debug_log = 'Y' THEN
604: FND_FILE.put_line( FND_FILE.LOG,'1 .Found more than one set of START_DATE or END_DATE');
605: END IF;
606: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_AP_WRONG_DATE'
607: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
608: RAISE_APPLICATION_ERROR(- 20999,'Found more than one set of START_DATE / END_DATE'|| SQLCODE ||' -ERROR- '|| SQLERRM);
609: END IF; -- will Stop the process, because of duplicate PUBLISH_DATE, START_DATE, END_DATE in TMP table
610:

Line 634: INSERT INTO JGZZ_AR_TAX_GLOBAL_TMP(JG_INFO_N1, JG_INFO_D1, JG_INFO_D2, JG_INFO_V1)

630: l_PERCEPTION_GROUP_NUM := V_TEMPREC.PERCEPTION_GROUP_NUM;
631: l_WHT_GROUP_NUM := V_TEMPREC.WHT_GROUP_NUM;
632:
633:
634: INSERT INTO JGZZ_AR_TAX_GLOBAL_TMP(JG_INFO_N1, JG_INFO_D1, JG_INFO_D2, JG_INFO_V1)
635: VALUES (l_TAXPAYER_ID, l_START_DATE, l_END_DATE, NULL);
636: -- Bug 14563117 Start
637: IF BASIC_VALIDATION(V_TEMPREC) THEN
638: -- Bug 14563117 End

Line 741: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_MANY_WHT_RATE_GROUP'

737: WHEN TOO_MANY_ROWS THEN
738: IF p_debug_log = 'Y' THEN
739: FND_FILE.PUT_LINE( FND_FILE.LOG,'4 .MORE THAN ONE WHT_RATE AND WHT_GROUP_NUM FOUND FOR A TAX_PAYER_ID');
740: END IF;
741: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_MANY_WHT_RATE_GROUP'
742: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
743: RAISE_APPLICATION_ERROR(- 20999,'AN ERROR WAS ENCOUNTERED IN WHT_GROUP_NUM AND WHT_RATE VALIDATION '|| SQLCODE ||' -ERROR- '|| SQLERRM);
744:
745: WHEN OTHERS THEN

Line 749: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_AP_GRP_NO_MATCH'

745: WHEN OTHERS THEN
746: IF p_debug_log = 'Y' THEN
747: FND_FILE.put_line( FND_FILE.LOG,'5 .Wht Rate and Wht group for this record from Government File doesnt match with AP Wht Tax Setup.');
748: END IF;
749: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_AP_GRP_NO_MATCH'
750: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
751: RAISE_APPLICATION_ERROR(- 20999,'AN ERROR WAS ENCOUNTERED IN WHT_GROUP_NUM AND WHT_RATE VALIDATION '|| SQLCODE ||' -ERROR- '|| SQLERRM);
752: END;
753:

Line 760: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_AP_GRP_NO_MATCH'

756: IF WHT_GROUP_NUM_rate_flag = 'N' THEN
757: IF p_debug_log = 'Y' THEN
758: FND_FILE.put_line( FND_FILE.LOG,'6 .Wht Rate and Wht group for this record from Government File doesnt match with AP Wht Tax Setup.');
759: END IF;
760: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_AP_GRP_NO_MATCH'
761: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
762: RAISE_APPLICATION_ERROR(- 20999,'WHT_RATE AND WHT_GROUP_NUM FROM GOVERNMENT FILE DOESNT MATCH WITH AP WHT TAX SETUP '|| SQLCODE ||' -ERROR- '|| SQLERRM);
763:
764: END IF;

Line 1358: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_GRP_NOT_UNIQUE'

1354: IF p_debug_log = 'Y' THEN
1355: FND_FILE.put_line( FND_FILE.LOG,' 33 WHT_rate and WHT_GROUP_NUM FROM government file was not unique');
1356: END IF;
1357:
1358: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JL_AR_GRP_NOT_UNIQUE'
1359: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
1360: RAISE_APPLICATION_ERROR(- 20999,'33 A An error was encountered in JL_AR_GRP_NOT_UNIQUE- '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1361: GOTO L3;
1362: --raise error and fetch next record.

Line 1800: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAILED_FINAL_CHECK'

1796: WHEN OTHERS THEN
1797: IF p_debug_log = 'Y' THEN
1798: FND_FILE.PUT_LINE( FND_FILE.LOG,'49 .TAXPAYER ID FAILED IN FINAL VALIDATION, FETCHING NEXT RECORD - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1799: END IF;
1800: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAILED_FINAL_CHECK'
1801: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
1802:
1803: END;
1804:

Line 1819: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAILED_FINAL_CHECK'

1815: WHEN OTHERS THEN
1816: IF p_debug_log = 'Y' THEN
1817: FND_FILE.PUT_LINE( FND_FILE.LOG,'49 .AN ERROR WAS ENCOUNTERED WHEN FINAL VALIDATION - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1818: END IF;
1819: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAILED_FINAL_CHECK'
1820: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
1821:
1822: END FINAL_VALIDATION;
1823:

Line 2455: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAILED_AWT_SETUP'

2451: WHEN OTHERS THEN
2452: IF p_debug_log = 'Y' THEN
2453: FND_FILE.PUT_LINE( FND_FILE.LOG,'58 .AN ERROR WAS ENCOUNTERED IN VALIDATION_AWT_SETUP - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
2454: END IF;
2455: UPDATE JGZZ_AR_TAX_GLOBAL_TMP SET JG_INFO_V1 = 'JLZZ_RECORD_FAILED_AWT_SETUP'
2456: WHERE JG_INFO_N1 = l_TAXPAYER_ID AND JG_INFO_D1 = l_START_DATE AND JG_INFO_D2 = l_END_DATE;
2457:
2458:
2459: END VALIDATE_AWT_SETUP;

Line 2505: DELETE JGZZ_AR_TAX_GLOBAL_TMP; -- Truncating previous records, if any, in JGZZ_AR_TAX_GLOBAL_TMP table

2501: IF p_debug_log = 'Y' THEN
2502: FND_FILE.put_line( FND_FILE.LOG,'Starting the FINAL_VALIDATION procedure');
2503: END IF;
2504:
2505: DELETE JGZZ_AR_TAX_GLOBAL_TMP; -- Truncating previous records, if any, in JGZZ_AR_TAX_GLOBAL_TMP table
2506: FINAL_VALIDATION; -- will goto FINAL_VALIDATION package and validate
2507:
2508: IF p_debug_log = 'Y' THEN
2509: FND_FILE.put_line( FND_FILE.LOG,'After the FINAL_VALIDATION procedure');

Line 2577: --DELETE JGZZ_AR_TAX_GLOBAL_TMP; -- Deleting previous records, if any in JGZZ_AR_TAX_GLOBAL_TMP table

2573: FND_FILE.put_line( FND_FILE.LOG,' ');
2574: FND_FILE.put_line( FND_FILE.LOG,' ');
2575: END IF;
2576:
2577: --DELETE JGZZ_AR_TAX_GLOBAL_TMP; -- Deleting previous records, if any in JGZZ_AR_TAX_GLOBAL_TMP table
2578: --FINAL_VALIDATION;
2579: --VALIDATE_AWT_SETUP;
2580:
2581: RETURN TRUE;