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 FND_FILE

Line 65: FND_FILE.put_line( FND_FILE.LOG, 'In Insert_Row, value of final_insert_check'|| final_insert_check);

61: final_insert_check := 'N';
62: END;
63:
64: IF p_debug_log = 'Y' THEN
65: FND_FILE.put_line( FND_FILE.LOG, 'In Insert_Row, value of final_insert_check'|| final_insert_check);
66: END IF;
67:
68: IF final_insert_check = 'N' THEN
69:

Line 110: FND_FILE.put_line( FND_FILE.LOG, 'In Insert_Row, inserted record into JL_AR_TURN_UPL');

106: l_creation_DATE, --CREATION_DATE
107: l_created_by); --CREATED_BY
108:
109: IF p_debug_log = 'Y' THEN
110: FND_FILE.put_line( FND_FILE.LOG, 'In Insert_Row, inserted record into JL_AR_TURN_UPL');
111: END IF;
112:
113: ELSE
114:

Line 123: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Payables');

119: AND START_DATE = l_START_DATE
120: AND END_DATE = l_END_DATE;
121:
122: IF p_debug_log = 'Y' THEN
123: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Payables');
124: END IF;
125:
126:
127: ELSIF l_CALLING_RESP = 'AR' THEN

Line 135: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Receivables');

131: AND START_DATE = l_START_DATE
132: AND END_DATE = l_END_DATE;
133:
134: IF p_debug_log = 'Y' THEN
135: FND_FILE.put_line( FND_FILE.LOG, 'UPDATED record in JL_AR_TURN_UPL for Receivables');
136: END IF;
137:
138: END IF;
139:

Line 146: FND_FILE.put_line( FND_FILE.LOG,'AN ERROR IS ENCOUNTERED WHILE INSERTING INTO FINAL TABLE '|| SQLCODE || 'ERROR' || SQLERRM);

142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: IF p_debug_log = 'Y' THEN
146: FND_FILE.put_line( FND_FILE.LOG,'AN ERROR IS ENCOUNTERED WHILE INSERTING INTO FINAL TABLE '|| SQLCODE || 'ERROR' || SQLERRM);
147: END IF;
148: END Insert_Row;
149:
150:

Line 168: FND_FILE.put_line( FND_FILE.LOG,'AN ERROR IS ENCOUNTERED WHEN VALIDATING DATE'|| SQLCODE ||' -ERROR- '|| SQLERRM);

164:
165: EXCEPTION
166: WHEN OTHERS THEN
167: IF p_debug_log = 'Y' THEN
168: FND_FILE.put_line( FND_FILE.LOG,'AN ERROR IS ENCOUNTERED WHEN VALIDATING DATE'|| SQLCODE ||' -ERROR- '|| SQLERRM);
169: END IF;
170: END FORMAT_DATE;
171:
172:

Line 188: FND_FILE.put_line( FND_FILE.LOG,'AN ERROR IS ENCOUNTERED WHEN VALIDATING NUMBER'|| SQLCODE ||' -ERROR- '|| SQLERRM);

184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: IF p_debug_log = 'Y' THEN
188: FND_FILE.put_line( FND_FILE.LOG,'AN ERROR IS ENCOUNTERED WHEN VALIDATING NUMBER'|| SQLCODE ||' -ERROR- '|| SQLERRM);
189: END IF;
190: RETURN FALSE;
191: END VALID_NUMBER;
192:

Line 257: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING DATE CHECK VALIDATION');

253:
254: IF (l_PUBLISH_DATE < l_PUBLISHDATE_ALL) AND (l_START_DATE > l_END_DATE) THEN
255: valid_flag := 'N';
256: IF p_debug_log = 'Y' THEN
257: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING DATE CHECK VALIDATION');
258: END IF;
259: END IF;
260:
261: EXCEPTION

Line 264: FND_FILE.PUT_LINE( FND_FILE.LOG,'NO PREVIOUS RECORD IN JL_AR_TURN_UPL');

260:
261: EXCEPTION
262: WHEN OTHERS THEN
263: IF p_debug_log = 'Y' THEN
264: FND_FILE.PUT_LINE( FND_FILE.LOG,'NO PREVIOUS RECORD IN JL_AR_TURN_UPL');
265: END IF;
266: END;
267:
268: IF VALID_NUMBER(P_TEMPREC.TAXPAYER_ID) THEN

Line 273: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED IN TAXPAYER ID (NUMBER) CHECK VALIDATION');

269: l_TAXPAYER_ID := TO_NUMBER(P_TEMPREC.TAXPAYER_ID, '99999999999');
270: ELSE
271: valid_flag := 'N';
272: IF p_debug_log = 'Y' THEN
273: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED IN TAXPAYER ID (NUMBER) CHECK VALIDATION');
274: END IF;
275: END IF;
276:
277:

Line 320: FND_FILE.PUT_LINE( FND_FILE.LOG,'AN ERROR WAS ENCOUNTERED IN TAX_PAYER VALIDATION FOR AP '|| SQLCODE || 'ERROR' || SQLERRM);

316: -- Bug 14563117 End
317:
318: WHEN OTHERS THEN
319: IF p_debug_log = 'Y' THEN
320: FND_FILE.PUT_LINE( FND_FILE.LOG,'AN ERROR WAS ENCOUNTERED IN TAX_PAYER VALIDATION FOR AP '|| SQLCODE || 'ERROR' || SQLERRM);
321: END IF;
322: RETURN FALSE; -- fetch next record
323:
324: END;

Line 347: FND_FILE.PUT_LINE( FND_FILE.LOG,'AN ERROR WAS ENCOUNTERED IN TAX_PAYER VALIDATION FOR AR'|| SQLCODE || 'ERROR' || SQLERRM);

343: l_taxpayer_ar := 'N';
344:
345: WHEN OTHERS THEN
346: IF p_debug_log = 'Y' THEN
347: FND_FILE.PUT_LINE( FND_FILE.LOG,'AN ERROR WAS ENCOUNTERED IN TAX_PAYER VALIDATION FOR AR'|| SQLCODE || 'ERROR' || SQLERRM);
348: END IF;
349: RETURN FALSE; -- fetch next record
350:
351: END;

Line 357: FND_FILE.put_line( FND_FILE.LOG,'TAXPAYER ID IS NOT AVAILABLE');

353:
354:
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;

Line 373: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING CONTRIBUTOR TYPE CHECK VALIDATION');

369:
370: IF (l_CONTRIBUTOR_TYPE_CODE NOT IN ('D', 'C')) THEN
371: valid_flag := 'N';
372: IF p_debug_log = 'Y' THEN
373: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING CONTRIBUTOR TYPE CHECK VALIDATION');
374: END IF;
375:
376: ELSIF (l_NEW_CONTRIBUTOR_FLAG NOT IN ('S', 'N', 'B')) THEN
377: valid_flag := 'N';

Line 379: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING NEW CONTRIBUTOR CHECK VALIDATION');

375:
376: ELSIF (l_NEW_CONTRIBUTOR_FLAG NOT IN ('S', 'N', 'B')) THEN
377: valid_flag := 'N';
378: IF p_debug_log = 'Y' THEN
379: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING NEW CONTRIBUTOR CHECK VALIDATION');
380: END IF;
381:
382: ELSIF (l_RATE_CHANGE_FLAG NOT IN ('S', 'N')) THEN
383: valid_flag := 'N';

Line 385: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING RATE CHANGE FLAG CHECK VALIDATION');

381:
382: ELSIF (l_RATE_CHANGE_FLAG NOT IN ('S', 'N')) THEN
383: valid_flag := 'N';
384: IF p_debug_log = 'Y' THEN
385: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING RATE CHANGE FLAG CHECK VALIDATION');
386: END IF;
387:
388: ELSE
389: valid_flag := 'Y';

Line 399: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING PERCEPTION_RATE CHECK VALIDATION');

395:
396: ELSE
397: valid_flag := 'N';
398: IF p_debug_log = 'Y' THEN
399: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING PERCEPTION_RATE CHECK VALIDATION');
400: END IF;
401:
402: END IF;
403:

Line 411: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING WHT_RATE CHECK VALIDATION');

407:
408: ELSE
409: valid_flag := 'N';
410: IF p_debug_log = 'Y' THEN
411: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING WHT_RATE CHECK VALIDATION');
412: END IF;
413:
414: END IF;
415:

Line 423: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING PERCEPTION_GROUP_NUM CHECK VALIDATION');

419:
420: ELSE
421: valid_flag := 'N';
422: IF p_debug_log = 'Y' THEN
423: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING PERCEPTION_GROUP_NUM CHECK VALIDATION');
424: END IF;
425:
426: END IF;
427:

Line 435: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING WHT_GROUP_NUM CHECK VALIDATION');

431:
432: ELSE
433: valid_flag := 'N';
434: IF p_debug_log = 'Y' THEN
435: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING WHT_GROUP_NUM CHECK VALIDATION');
436: END IF;
437:
438: END IF;
439:

Line 446: FND_FILE.PUT_LINE( FND_FILE.LOG,'RECORD FAILED DURING BASIC CHECK VALIDATION, PLEASE REFER LOG FILE/REPORT ');

442: RETURN TRUE;
443:
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:

Line 463: FND_FILE.PUT_LINE( FND_FILE.LOG,'AN ERROR WAS ENCOUNTERED DURING BASIC CHECK VALIDATION'|| SQLCODE || 'ERROR' || SQLERRM);

459:
460: EXCEPTION
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:

Line 604: FND_FILE.put_line( FND_FILE.LOG,'1 .Found more than one set of START_DATE or END_DATE');

600:
601: IF duplicate_check_count > 1 THEN
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);

Line 640: FND_FILE.PUT_LINE( FND_FILE.LOG,'2 .RECORD PASSED IN BASIC VALIDATION FOR TAXPAYER: '|| l_TAXPAYER_ID);

636: -- Bug 14563117 Start
637: IF BASIC_VALIDATION(V_TEMPREC) THEN
638: -- Bug 14563117 End
639: IF p_debug_log = 'Y' THEN
640: FND_FILE.PUT_LINE( FND_FILE.LOG,'2 .RECORD PASSED IN BASIC VALIDATION FOR TAXPAYER: '|| l_TAXPAYER_ID);
641: END IF;
642: ELSE
643: IF p_debug_log = 'Y' THEN
644: FND_FILE.put_line( FND_FILE.LOG,'3 .RECORD FAILED DURING BASIC VALIDATION FOR TAXPAYER : '|| l_TAXPAYER_ID);

Line 644: FND_FILE.put_line( FND_FILE.LOG,'3 .RECORD FAILED DURING BASIC VALIDATION FOR TAXPAYER : '|| l_TAXPAYER_ID);

640: FND_FILE.PUT_LINE( FND_FILE.LOG,'2 .RECORD PASSED IN BASIC VALIDATION FOR TAXPAYER: '|| l_TAXPAYER_ID);
641: END IF;
642: ELSE
643: IF p_debug_log = 'Y' THEN
644: FND_FILE.put_line( FND_FILE.LOG,'3 .RECORD FAILED DURING BASIC VALIDATION FOR TAXPAYER : '|| l_TAXPAYER_ID);
645: END IF;
646: GOTO L3;
647: END IF; -- AR Code Hook
648:

Line 653: FND_FILE.put_line( FND_FILE.LOG,'3 A .GOING TO START THE AR VALIDATION FOR TAXPAYER: '|| l_TAXPAYER_ID);

649:
650: IF l_taxpayer_ar = 'Y' THEN
651:
652: IF p_debug_log = 'Y' THEN
653: FND_FILE.put_line( FND_FILE.LOG,'3 A .GOING TO START THE AR VALIDATION FOR TAXPAYER: '|| l_TAXPAYER_ID);
654: END IF;
655:
656: BEGIN
657:

Line 668: FND_FILE.put_line(FND_FILE.LOG,'58. AR validation completed successfully');

664: l_END_DATE,
665: l_RETURN_STATUS ); -- out parameter for status
666:
667: IF l_RETURN_STATUS = 'S' THEN --bug 9907885
668: FND_FILE.put_line(FND_FILE.LOG,'58. AR validation completed successfully');
669: END IF;
670:
671: EXCEPTION
672: WHEN OTHERS THEN

Line 674: FND_FILE.put_line(FND_FILE.LOG,'AR VALIDATION FAILED WITH RETUN STATUS'|| l_RETURN_STATUS || SQLCODE || 'ERROR' || SQLERRM);

670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: IF p_debug_log = 'Y' THEN
674: FND_FILE.put_line(FND_FILE.LOG,'AR VALIDATION FAILED WITH RETUN STATUS'|| l_RETURN_STATUS || SQLCODE || 'ERROR' || SQLERRM);
675: END IF;
676: RAISE_APPLICATION_ERROR(- 20999,'AR VALIDATION FAILED'|| SQLCODE ||' -ERROR- '|| SQLERRM);
677: END;
678:

Line 687: FND_FILE.put_line( FND_FILE.LOG,'3 B .GOING TO START THE AP VALIDATION FOR TAXPAYER: '|| l_TAXPAYER_ID);

683:
684: IF l_taxpayer = 'Y' THEN
685:
686: IF p_debug_log = 'Y' THEN
687: FND_FILE.put_line( FND_FILE.LOG,'3 B .GOING TO START THE AP VALIDATION FOR TAXPAYER: '|| l_TAXPAYER_ID);
688: END IF;
689:
690: BEGIN
691:

Line 703: FND_FILE.PUT_LINE( FND_FILE.LOG,'4 .NO PREVIOUS RECORD AVAILABLE IN JL_AR_TURN_UPL TABLE');

699: EXCEPTION
700:
701: WHEN OTHERS THEN
702: IF p_debug_log = 'Y' THEN
703: FND_FILE.PUT_LINE( FND_FILE.LOG,'4 .NO PREVIOUS RECORD AVAILABLE IN JL_AR_TURN_UPL TABLE');
704: END IF;
705: END;
706:
707: l_START_DATE_SEC_MAX := NVL(l_START_DATE_SEC_MAX, l_START_DATE);

Line 739: FND_FILE.PUT_LINE( FND_FILE.LOG,'4 .MORE THAN ONE WHT_RATE AND WHT_GROUP_NUM FOUND FOR A TAX_PAYER_ID');

735: EXCEPTION
736:
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);

Line 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.');

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
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);

Line 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.');

754:
755:
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);

Line 788: FND_FILE.PUT_LINE( FND_FILE.LOG,'7 .THE VALUE FOR SAME_PREV_RECORD_FLAG:'||same_prev_rec_flag);

784: AND WHT_GROUP_NUM = l_WHT_GROUP_NUM;
785:
786:
787: IF p_debug_log = 'Y' THEN
788: FND_FILE.PUT_LINE( FND_FILE.LOG,'7 .THE VALUE FOR SAME_PREV_RECORD_FLAG:'||same_prev_rec_flag);
789: END IF;
790:
791: EXCEPTION
792: WHEN NO_DATA_FOUND THEN

Line 794: FND_FILE.PUT_LINE( FND_FILE.LOG,'7A .NO CORRESPONDING DATA IN JL_AR_TURN_UPL');

790:
791: EXCEPTION
792: WHEN NO_DATA_FOUND THEN
793: IF p_debug_log = 'Y' THEN
794: FND_FILE.PUT_LINE( FND_FILE.LOG,'7A .NO CORRESPONDING DATA IN JL_AR_TURN_UPL');
795: END IF;
796: WHEN OTHERS THEN
797: IF p_debug_log = 'Y' THEN
798: FND_FILE.PUT_LINE( FND_FILE.LOG,'8 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN JL_AR_TURN_UPL');

Line 798: FND_FILE.PUT_LINE( FND_FILE.LOG,'8 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN JL_AR_TURN_UPL');

794: FND_FILE.PUT_LINE( FND_FILE.LOG,'7A .NO CORRESPONDING DATA IN JL_AR_TURN_UPL');
795: END IF;
796: WHEN OTHERS THEN
797: IF p_debug_log = 'Y' THEN
798: FND_FILE.PUT_LINE( FND_FILE.LOG,'8 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN JL_AR_TURN_UPL');
799: END IF;
800: END;
801:
802: IF p_debug_log = 'Y' THEN

Line 803: FND_FILE.PUT_LINE( FND_FILE.LOG,'9 .VALUE OF SAME_PREV_RECORD_FLAG :'|| same_prev_rec_flag);

799: END IF;
800: END;
801:
802: IF p_debug_log = 'Y' THEN
803: FND_FILE.PUT_LINE( FND_FILE.LOG,'9 .VALUE OF SAME_PREV_RECORD_FLAG :'|| same_prev_rec_flag);
804: END IF;
805:
806: -- For exactly same records simply copying that to ALL table FROM TMP and fetching next record (TDD 3.1)
807:

Line 809: FND_FILE.PUT_LINE( FND_FILE.LOG,'10. Going to fetch next record as Taxpayer Id was already present');

805:
806: -- For exactly same records simply copying that to ALL table FROM TMP and fetching next record (TDD 3.1)
807:
808: IF same_prev_rec_flag = 'Y' then
809: FND_FILE.PUT_LINE( FND_FILE.LOG,'10. Going to fetch next record as Taxpayer Id was already present');
810: GOTO L3; -- If the same exact Taxpayer value was already present in final table then simply fetch next record
811: END IF;
812:
813: ---/*

Line 835: FND_FILE.PUT_LINE( FND_FILE.LOG,'10 .INSERTED DATA IN JL_AR_TURN_UPL SAME_REC_FLAG IS Y AND DELETED FROM TMP TABLE');

831:
832: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
833:
834: IF p_debug_log = 'Y' THEN
835: FND_FILE.PUT_LINE( FND_FILE.LOG,'10 .INSERTED DATA IN JL_AR_TURN_UPL SAME_REC_FLAG IS Y AND DELETED FROM TMP TABLE');
836: END IF;
837:
838: GOTO L3;
839: --fetching next record

Line 856: FND_FILE.PUT_LINE( FND_FILE.LOG,'12 .NO CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');

852:
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: IF p_debug_log = 'Y' THEN
856: FND_FILE.PUT_LINE( FND_FILE.LOG,'12 .NO CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');
857: END IF;
858:
859: WHEN OTHERS THEN
860: IF p_debug_log = 'Y' THEN

Line 861: FND_FILE.PUT_LINE( FND_FILE.LOG,'13 .FAILED WHILE CHECKING THE CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');

857: END IF;
858:
859: WHEN OTHERS THEN
860: IF p_debug_log = 'Y' THEN
861: FND_FILE.PUT_LINE( FND_FILE.LOG,'13 .FAILED WHILE CHECKING THE CORRESPONDING TAXPAYER_ID IN JL_AR_TURN_UPL');
862: END IF;
863:
864: END;
865:

Line 884: FND_FILE.PUT_LINE( FND_FILE.LOG,'14. NO CORRESPONDING DATA FOR l_WHT_GROUP_NUM AND l_WHT_RATE');

880:
881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN
883: IF p_debug_log = 'Y' THEN
884: FND_FILE.PUT_LINE( FND_FILE.LOG,'14. NO CORRESPONDING DATA FOR l_WHT_GROUP_NUM AND l_WHT_RATE');
885: END IF;
886: WHEN OTHERS THEN
887: IF p_debug_log = 'Y' THEN
888: FND_FILE.PUT_LINE( FND_FILE.LOG,'15 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN l_WHT_GROUP_NUM AND l_WHT_RATE');

Line 888: FND_FILE.PUT_LINE( FND_FILE.LOG,'15 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN l_WHT_GROUP_NUM AND l_WHT_RATE');

884: FND_FILE.PUT_LINE( FND_FILE.LOG,'14. NO CORRESPONDING DATA FOR l_WHT_GROUP_NUM AND l_WHT_RATE');
885: END IF;
886: WHEN OTHERS THEN
887: IF p_debug_log = 'Y' THEN
888: FND_FILE.PUT_LINE( FND_FILE.LOG,'15 .FAILED WHILE CHECKING THE CORRESPONDING DATA IN l_WHT_GROUP_NUM AND l_WHT_RATE');
889: END IF;
890: END;
891:
892: -- for records of same wht group/wht rate, simply copy (TDD 3.2.1.1)

Line 912: FND_FILE.PUT_LINE( FND_FILE.LOG,'16 .INSERTED DATA IN TABLE JL_AR_TURN_UPL WHEN WHT_CHECK_FLAG IS Y ');

908:
909: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
910:
911: IF p_debug_log = 'Y' THEN
912: FND_FILE.PUT_LINE( FND_FILE.LOG,'16 .INSERTED DATA IN TABLE JL_AR_TURN_UPL WHEN WHT_CHECK_FLAG IS Y ');
913: END IF;
914: GOTO L3;
915:
916: -- If the wht rate and wht group are different (3.2.1.2) then UPDATE the tax SETups

Line 944: FND_FILE.put_line( FND_FILE.LOG,'17. EFFECTIVE_END_DATE (l_START_DATE-1) : '|| l_START_DATE);

940: ) ||
941: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
942:
943: IF p_debug_log = 'Y' THEN
944: FND_FILE.put_line( FND_FILE.LOG,'17. EFFECTIVE_END_DATE (l_START_DATE-1) : '|| l_START_DATE);
945: FND_FILE.put_line( FND_FILE.LOG,'17. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
946: END IF;
947:
948:

Line 945: FND_FILE.put_line( FND_FILE.LOG,'17. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);

941: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
942:
943: IF p_debug_log = 'Y' THEN
944: FND_FILE.put_line( FND_FILE.LOG,'17. EFFECTIVE_END_DATE (l_START_DATE-1) : '|| l_START_DATE);
945: FND_FILE.put_line( FND_FILE.LOG,'17. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
946: END IF;
947:
948:
949: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

Line 952: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);

948:
949: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
950:
951: IF p_debug_log = 'Y' THEN
952: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
953: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);
954: END IF;
955:
956:

Line 953: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);

949: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
950:
951: IF p_debug_log = 'Y' THEN
952: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
953: FND_FILE.put_line( FND_FILE.LOG,'18. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);
954: END IF;
955:
956:
957: BEGIN

Line 972: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Error occured while fetching data in JL_ZZ_AP_SUP_AWT_CD');

968: WHEN NO_DATA_FOUND THEN
969: taxtype_code_check := 'N';
970: WHEN OTHERS THEN
971: taxtype_code_check := 'N';
972: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Error occured while fetching data in JL_ZZ_AP_SUP_AWT_CD');
973: END;
974:
975: EXCEPTION
976: WHEN OTHERS THEN

Line 977: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. No records fetched from JL_ZZ_AP_SUP_AWT_CD for Taxpayer Id :||l_TAXPAYER_ID');

973: END;
974:
975: EXCEPTION
976: WHEN OTHERS THEN
977: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. No records fetched from JL_ZZ_AP_SUP_AWT_CD for Taxpayer Id :||l_TAXPAYER_ID');
978:
979: END;
980:
981:

Line 984: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Records already present in JL_ZZ_AP_SUP_AWT_CD table, no modifications');

980:
981:
982: IF taxtype_code_check = 'Y' THEN
983:
984: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Records already present in JL_ZZ_AP_SUP_AWT_CD table, no modifications');
985: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_TAX_ID'|| L_TAX_ID || 'l_SUPP_AWT_TYPE_ID_CD' || l_SUPP_AWT_TYPE_ID_CD);
986: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_EFFECTIVE_START_DATE'|| l_START_DATE || 'EFFECTIVE_END_DATE' || l_END_DATE);
987:
988: ELSE

Line 985: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_TAX_ID'|| L_TAX_ID || 'l_SUPP_AWT_TYPE_ID_CD' || l_SUPP_AWT_TYPE_ID_CD);

981:
982: IF taxtype_code_check = 'Y' THEN
983:
984: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Records already present in JL_ZZ_AP_SUP_AWT_CD table, no modifications');
985: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_TAX_ID'|| L_TAX_ID || 'l_SUPP_AWT_TYPE_ID_CD' || l_SUPP_AWT_TYPE_ID_CD);
986: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_EFFECTIVE_START_DATE'|| l_START_DATE || 'EFFECTIVE_END_DATE' || l_END_DATE);
987:
988: ELSE
989:

Line 986: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_EFFECTIVE_START_DATE'|| l_START_DATE || 'EFFECTIVE_END_DATE' || l_END_DATE);

982: IF taxtype_code_check = 'Y' THEN
983:
984: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. Records already present in JL_ZZ_AP_SUP_AWT_CD table, no modifications');
985: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_TAX_ID'|| L_TAX_ID || 'l_SUPP_AWT_TYPE_ID_CD' || l_SUPP_AWT_TYPE_ID_CD);
986: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . L_EFFECTIVE_START_DATE'|| l_START_DATE || 'EFFECTIVE_END_DATE' || l_END_DATE);
987:
988: ELSE
989:
990: BEGIN

Line 1001: FND_FILE.PUT_LINE( FND_FILE.LOG,'19 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

997: AND SAWTC.EFFECTIVE_END_DATE IS NULL;
998:
999:
1000: IF p_debug_log = 'Y' THEN
1001: FND_FILE.PUT_LINE( FND_FILE.LOG,'19 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1002: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1003: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. L_TAX_ID : '|| L_TAX_ID || ' L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1004: END IF;
1005:

Line 1002: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);

998:
999:
1000: IF p_debug_log = 'Y' THEN
1001: FND_FILE.PUT_LINE( FND_FILE.LOG,'19 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1002: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1003: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. L_TAX_ID : '|| L_TAX_ID || ' L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1004: END IF;
1005:
1006:

Line 1003: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. L_TAX_ID : '|| L_TAX_ID || ' L_TAXPAYER_ID : '|| L_TAXPAYER_ID);

999:
1000: IF p_debug_log = 'Y' THEN
1001: FND_FILE.PUT_LINE( FND_FILE.LOG,'19 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1002: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1003: FND_FILE.PUT_LINE( FND_FILE.LOG,'19. L_TAX_ID : '|| L_TAX_ID || ' L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1004: END IF;
1005:
1006:
1007:

Line 1037: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

1033: NULL); --EFFECTIVE_END_DATE
1034:
1035:
1036: IF p_debug_log = 'Y' THEN
1037: FND_FILE.PUT_LINE( FND_FILE.LOG,'21 . INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1038: END IF;
1039:
1040:
1041: EXCEPTION

Line 1045: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. INSERT NOT DONE IN JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1041: EXCEPTION
1042: WHEN OTHERS THEN
1043:
1044: IF p_debug_log = 'Y' THEN
1045: FND_FILE.PUT_LINE( FND_FILE.LOG,'21. INSERT NOT DONE IN JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1046: END IF;
1047: END;
1048:
1049: END IF;

Line 1087: FND_FILE.PUT_LINE( FND_FILE.LOG,'22 B SELECT TAX CODE NOT DONE FOR JL_ZZ_AP_INV_DIS_WH_ALL - '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: IF p_debug_log = 'Y' THEN
1087: FND_FILE.PUT_LINE( FND_FILE.LOG,'22 B SELECT TAX CODE NOT DONE FOR JL_ZZ_AP_INV_DIS_WH_ALL - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1088: END IF;
1089: END;
1090:
1091: OPEN CUR3(l_TAXPAYER_ID);

Line 1116: FND_FILE.put_line( FND_FILE.LOG,'22 B No earlier same tax code id in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);

1112:
1113: EXCEPTION
1114: WHEN NO_DATA_FOUND THEN
1115: AWT_CODE_INV_AVAIL_FLAG := 'N';
1116: FND_FILE.put_line( FND_FILE.LOG,'22 B No earlier same tax code id in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);
1117:
1118: WHEN OTHERS THEN
1119: AWT_CODE_INV_AVAIL_FLAG := 'N';
1120: FND_FILE.put_line( FND_FILE.LOG,'22 B Error in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);

Line 1120: FND_FILE.put_line( FND_FILE.LOG,'22 B Error in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);

1116: FND_FILE.put_line( FND_FILE.LOG,'22 B No earlier same tax code id in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);
1117:
1118: WHEN OTHERS THEN
1119: AWT_CODE_INV_AVAIL_FLAG := 'N';
1120: FND_FILE.put_line( FND_FILE.LOG,'22 B Error in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);
1121: END;
1122:
1123:
1124:

Line 1128: FND_FILE.put_line( FND_FILE.LOG,'22 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);

1124:
1125: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
1126:
1127: IF p_debug_log = 'Y' THEN
1128: FND_FILE.put_line( FND_FILE.LOG,'22 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1129: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1130: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1131: FND_FILE.put_line( FND_FILE.LOG,'22 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1132: FND_FILE.put_line( FND_FILE.LOG,'22 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

Line 1129: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);

1125: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
1126:
1127: IF p_debug_log = 'Y' THEN
1128: FND_FILE.put_line( FND_FILE.LOG,'22 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1129: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1130: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1131: FND_FILE.put_line( FND_FILE.LOG,'22 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1132: FND_FILE.put_line( FND_FILE.LOG,'22 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1133: END IF;

Line 1130: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);

1126:
1127: IF p_debug_log = 'Y' THEN
1128: FND_FILE.put_line( FND_FILE.LOG,'22 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1129: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1130: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1131: FND_FILE.put_line( FND_FILE.LOG,'22 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1132: FND_FILE.put_line( FND_FILE.LOG,'22 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1133: END IF;
1134:

Line 1131: FND_FILE.put_line( FND_FILE.LOG,'22 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);

1127: IF p_debug_log = 'Y' THEN
1128: FND_FILE.put_line( FND_FILE.LOG,'22 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1129: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1130: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1131: FND_FILE.put_line( FND_FILE.LOG,'22 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1132: FND_FILE.put_line( FND_FILE.LOG,'22 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1133: END IF;
1134:
1135: BEGIN ---code to insert data INTO jl_zz_ap_inv_dis_wh_all

Line 1132: FND_FILE.put_line( FND_FILE.LOG,'22 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

1128: FND_FILE.put_line( FND_FILE.LOG,'22 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1129: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1130: FND_FILE.put_line( FND_FILE.LOG,'22 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1131: FND_FILE.put_line( FND_FILE.LOG,'22 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1132: FND_FILE.put_line( FND_FILE.LOG,'22 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1133: END IF;
1134:
1135: BEGIN ---code to insert data INTO jl_zz_ap_inv_dis_wh_all
1136:

Line 1167: FND_FILE.put_line( FND_FILE.LOG,'22. C '|| SQL%ROWCOUNT ||'Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1163:
1164: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
1165:
1166: IF p_debug_log = 'Y' THEN
1167: FND_FILE.put_line( FND_FILE.LOG,'22. C '|| SQL%ROWCOUNT ||'Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1168: END IF;
1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN

Line 1173: FND_FILE.put_line( FND_FILE.LOG,'22. C Failed while Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: IF p_debug_log = 'Y' THEN
1173: FND_FILE.put_line( FND_FILE.LOG,'22. C Failed while Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1174: END IF;
1175: END;
1176:
1177: ELSE

Line 1181: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);

1177: ELSE
1178:
1179: BEGIN
1180: IF p_debug_log = 'Y' THEN
1181: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1182: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1183: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1184: FND_FILE.put_line( FND_FILE.LOG,'23 A l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1185: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);

Line 1182: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);

1178:
1179: BEGIN
1180: IF p_debug_log = 'Y' THEN
1181: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1182: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1183: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1184: FND_FILE.put_line( FND_FILE.LOG,'23 A l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1185: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1186: FND_FILE.put_line( FND_FILE.LOG,'23 A INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

Line 1183: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);

1179: BEGIN
1180: IF p_debug_log = 'Y' THEN
1181: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1182: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1183: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1184: FND_FILE.put_line( FND_FILE.LOG,'23 A l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1185: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1186: FND_FILE.put_line( FND_FILE.LOG,'23 A INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1187: END IF;

Line 1184: FND_FILE.put_line( FND_FILE.LOG,'23 A l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);

1180: IF p_debug_log = 'Y' THEN
1181: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1182: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1183: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1184: FND_FILE.put_line( FND_FILE.LOG,'23 A l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1185: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1186: FND_FILE.put_line( FND_FILE.LOG,'23 A INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1187: END IF;
1188:

Line 1185: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);

1181: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1182: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1183: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1184: FND_FILE.put_line( FND_FILE.LOG,'23 A l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1185: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1186: FND_FILE.put_line( FND_FILE.LOG,'23 A INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1187: END IF;
1188:
1189: /*SELECT INV_DISTRIB_AWT_ID INTO l_INV_DISTRIB_AWT_ID_DIS

Line 1186: FND_FILE.put_line( FND_FILE.LOG,'23 A INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

1182: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1183: FND_FILE.put_line( FND_FILE.LOG,'23 A INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1184: FND_FILE.put_line( FND_FILE.LOG,'23 A l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1185: FND_FILE.put_line( FND_FILE.LOG,'23 A l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1186: FND_FILE.put_line( FND_FILE.LOG,'23 A INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1187: END IF;
1188:
1189: /*SELECT INV_DISTRIB_AWT_ID INTO l_INV_DISTRIB_AWT_ID_DIS
1190: FROM JL_ZZ_AP_INV_DIS_WH

Line 1206: FND_FILE.put_line( FND_FILE.LOG,'23 B. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1202: UPDATE JL_ZZ_AP_INV_DIS_WH SET SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD
1203: WHERE INV_DISTRIB_AWT_ID = l_INV_DISTRIB_AWT_ID_DIS;
1204:
1205: IF p_debug_log = 'Y' THEN
1206: FND_FILE.put_line( FND_FILE.LOG,'23 B. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1207: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);
1208: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);
1209: END IF;
1210:

Line 1207: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);

1203: WHERE INV_DISTRIB_AWT_ID = l_INV_DISTRIB_AWT_ID_DIS;
1204:
1205: IF p_debug_log = 'Y' THEN
1206: FND_FILE.put_line( FND_FILE.LOG,'23 B. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1207: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);
1208: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);
1209: END IF;
1210:
1211: EXCEPTION

Line 1208: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);

1204:
1205: IF p_debug_log = 'Y' THEN
1206: FND_FILE.put_line( FND_FILE.LOG,'23 B. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1207: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);
1208: FND_FILE.put_line( FND_FILE.LOG,'23 B. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);
1209: END IF;
1210:
1211: EXCEPTION
1212: WHEN OTHERS THEN

Line 1214: FND_FILE.put_line( FND_FILE.LOG,'23 B. Failed while updating records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1210:
1211: EXCEPTION
1212: WHEN OTHERS THEN
1213: IF p_debug_log = 'Y' THEN
1214: FND_FILE.put_line( FND_FILE.LOG,'23 B. Failed while updating records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1215: END IF;
1216: END;
1217:
1218: END IF;

Line 1224: FND_FILE.PUT_LINE( FND_FILE.LOG,'24. UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID ');

1220: END LOOP;
1221: CLOSE CUR3;
1222:
1223: IF p_debug_log = 'Y' THEN
1224: FND_FILE.PUT_LINE( FND_FILE.LOG,'24. UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID ');
1225: END IF;
1226:
1227:
1228:

Line 1246: FND_FILE.put_line( FND_FILE.LOG,'26 . Inserted data in JL_AR_TURN_UPL for All Records ');

1242:
1243: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1244:
1245: IF p_debug_log = 'Y' THEN
1246: FND_FILE.put_line( FND_FILE.LOG,'26 . Inserted data in JL_AR_TURN_UPL for All Records ');
1247: END IF;
1248:
1249: END IF;
1250:

Line 1272: FND_FILE.put_line( FND_FILE.LOG,'28. Inserted data in JL_AR_TURN_UPL when same_rec_flag is N AND l_RATE_CHANGE_FLAG is N');

1268: l_WHT_DEFAULT_FLAG,
1269: 'AP');
1270:
1271: IF p_debug_log = 'Y' THEN
1272: FND_FILE.put_line( FND_FILE.LOG,'28. Inserted data in JL_AR_TURN_UPL when same_rec_flag is N AND l_RATE_CHANGE_FLAG is N');
1273: FND_FILE.put_line( FND_FILE.LOG,'Fetching Record Record after Taxpayer Id '|| l_TAXPAYER_ID);
1274: END IF;
1275: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1276: --GOTO L3;

Line 1273: FND_FILE.put_line( FND_FILE.LOG,'Fetching Record Record after Taxpayer Id '|| l_TAXPAYER_ID);

1269: 'AP');
1270:
1271: IF p_debug_log = 'Y' THEN
1272: FND_FILE.put_line( FND_FILE.LOG,'28. Inserted data in JL_AR_TURN_UPL when same_rec_flag is N AND l_RATE_CHANGE_FLAG is N');
1273: FND_FILE.put_line( FND_FILE.LOG,'Fetching Record Record after Taxpayer Id '|| l_TAXPAYER_ID);
1274: END IF;
1275: --delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1276: --GOTO L3;
1277:

Line 1295: FND_FILE.PUT_LINE( FND_FILE.LOG,' 29 . NO DATA EXIST IN TMP TABLE OTHER THAN ALL TABLE DATA');

1291:
1292: WHEN NO_DATA_FOUND THEN
1293: exist_check_flag := 'Y';
1294: IF p_debug_log = 'Y' THEN
1295: FND_FILE.PUT_LINE( FND_FILE.LOG,' 29 . NO DATA EXIST IN TMP TABLE OTHER THAN ALL TABLE DATA');
1296: END IF;
1297: WHEN OTHERS THEN
1298: exist_check_flag := 'Y';
1299: IF p_debug_log = 'Y' THEN

Line 1300: FND_FILE.PUT_LINE( FND_FILE.LOG,' 30 .FAILED IN EXIST_CHECK_FLAG VALIDATION'|| EXIST_CHECK_FLAG);

1296: END IF;
1297: WHEN OTHERS THEN
1298: exist_check_flag := 'Y';
1299: IF p_debug_log = 'Y' THEN
1300: FND_FILE.PUT_LINE( FND_FILE.LOG,' 30 .FAILED IN EXIST_CHECK_FLAG VALIDATION'|| EXIST_CHECK_FLAG);
1301: END IF;
1302:
1303: END;
1304:

Line 1306: FND_FILE.PUT_LINE( FND_FILE.LOG,' 31 . EXIST_CHECK_FLAG'|| EXIST_CHECK_FLAG);

1302:
1303: END;
1304:
1305: IF p_debug_log = 'Y' THEN
1306: FND_FILE.PUT_LINE( FND_FILE.LOG,' 31 . EXIST_CHECK_FLAG'|| EXIST_CHECK_FLAG);
1307: END IF;
1308:
1309: SELECT MAX(START_DATE) INTO l_START_DATE_SEC_MAX FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID AND
1310: START_DATE NOT IN (SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL WHERE TAXPAYER_ID = l_TAXPAYER_ID);

Line 1334: FND_FILE.PUT_LINE( FND_FILE.LOG,' 32 .NO DATA IN WHT_CHECK_FLAG IN JL_AR_TURN_UPL');

1330: WHEN NO_DATA_FOUND THEN
1331: wht_check_unique := 'N';
1332:
1333: IF p_debug_log = 'Y' THEN
1334: FND_FILE.PUT_LINE( FND_FILE.LOG,' 32 .NO DATA IN WHT_CHECK_FLAG IN JL_AR_TURN_UPL');
1335: END IF;
1336:
1337: WHEN OTHERS THEN
1338: wht_check_unique := 'Y';

Line 1340: FND_FILE.PUT_LINE( FND_FILE.LOG,'33 .FAILED IN WHT_CHECK_FLAG VALIDATION');

1336:
1337: WHEN OTHERS THEN
1338: wht_check_unique := 'Y';
1339: IF p_debug_log = 'Y' THEN
1340: FND_FILE.PUT_LINE( FND_FILE.LOG,'33 .FAILED IN WHT_CHECK_FLAG VALIDATION');
1341: END IF;
1342: RAISE_APPLICATION_ERROR(- 20999,'FAILED IN WHT_CHECK_FLAG VALIDATION '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1343: END;
1344:

Line 1348: FND_FILE.PUT_LINE( FND_FILE.LOG,' 31 . WHT_CHECK_UNIQUE'|| WHT_CHECK_UNIQUE);

1344:
1345:
1346: END IF;
1347: IF p_debug_log = 'Y' THEN
1348: FND_FILE.PUT_LINE( FND_FILE.LOG,' 31 . WHT_CHECK_UNIQUE'|| WHT_CHECK_UNIQUE);
1349: END IF;
1350: -- If the wht_rate/WHT_GROUP_NUM in TMP were not unique then raise error (3.3.1)
1351:
1352: IF wht_check_unique = 'Y' THEN

Line 1355: FND_FILE.put_line( FND_FILE.LOG,' 33 WHT_rate and WHT_GROUP_NUM FROM government file was not unique');

1351:
1352: IF wht_check_unique = 'Y' THEN
1353:
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;

Line 1387: FND_FILE.put_line( FND_FILE.LOG,'34 . l_SUPP_AWT_TYPE_ID_TYPES'|| l_SUPP_AWT_TYPE_ID_TYPES || 'and' || 'l_VENDOR_ID' || l_VENDOR_ID);

1383: ) ||
1384: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
1385:
1386: IF p_debug_log = 'Y' THEN
1387: FND_FILE.put_line( FND_FILE.LOG,'34 . l_SUPP_AWT_TYPE_ID_TYPES'|| l_SUPP_AWT_TYPE_ID_TYPES || 'and' || 'l_VENDOR_ID' || l_VENDOR_ID);
1388: END IF;
1389:
1390: INSERT INTO JL_ZZ_AP_SUPP_AWT_TYPES(
1391: SUPP_AWT_TYPE_ID,

Line 1412: FND_FILE.put_line( FND_FILE.LOG,'34 . Inserted data in JL_ZZ_AP_SUPP_AWT_TYPES for '|| SQL%ROWCOUNT ||' Records');

1408: l_last_UPDATE_DATE, --LAST_UPDATE_DATE
1409: l_last_UPDATE_login); --LAST_UPDATE_LOGIN
1410:
1411: IF p_debug_log = 'Y' THEN
1412: FND_FILE.put_line( FND_FILE.LOG,'34 . Inserted data in JL_ZZ_AP_SUPP_AWT_TYPES for '|| SQL%ROWCOUNT ||' Records');
1413: END IF;
1414:
1415: EXCEPTION
1416: WHEN OTHERS THEN

Line 1419: FND_FILE.put_line( FND_FILE.LOG,'35 .Insert in JL_ZZ_AP_SUPP_AWT_TYPES not done - '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1415: EXCEPTION
1416: WHEN OTHERS THEN
1417:
1418: IF p_debug_log = 'Y' THEN
1419: FND_FILE.put_line( FND_FILE.LOG,'35 .Insert in JL_ZZ_AP_SUPP_AWT_TYPES not done - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1420: END IF;
1421:
1422: END;
1423:

Line 1452: FND_FILE.put_line( FND_FILE.LOG,'36. EFFECTIVE_END_DATE (l_START_DATE-1) : '|| l_START_DATE);

1448: ) ||
1449: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
1450:
1451: IF p_debug_log = 'Y' THEN
1452: FND_FILE.put_line( FND_FILE.LOG,'36. EFFECTIVE_END_DATE (l_START_DATE-1) : '|| l_START_DATE);
1453: FND_FILE.put_line( FND_FILE.LOG,'36. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
1454: END IF;
1455:
1456:

Line 1453: FND_FILE.put_line( FND_FILE.LOG,'36. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);

1449: substr(pv.global_attribute12,1,1) = TO_CHAR(l_TAXPAYER_ID);
1450:
1451: IF p_debug_log = 'Y' THEN
1452: FND_FILE.put_line( FND_FILE.LOG,'36. EFFECTIVE_END_DATE (l_START_DATE-1) : '|| l_START_DATE);
1453: FND_FILE.put_line( FND_FILE.LOG,'36. l_tax_id : '|| l_tax_id || 'l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
1454: END IF;
1455:
1456:
1457: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

Line 1460: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);

1456:
1457: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
1458:
1459: IF p_debug_log = 'Y' THEN
1460: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
1461: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);
1462: END IF;
1463: -- code to UPDATE the EFFECTIVE_END_DATE for other primary_tax_flag = 'Y' and other l_tax_id
1464:

Line 1461: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);

1457: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;
1458:
1459: IF p_debug_log = 'Y' THEN
1460: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_CODE_ID_SEQ'|| l_SUPP_AWT_CODE_ID_SEQ);
1461: FND_FILE.put_line( FND_FILE.LOG,'37. l_SUPP_AWT_TYPE_ID_CD'|| l_SUPP_AWT_TYPE_ID_CD);
1462: END IF;
1463: -- code to UPDATE the EFFECTIVE_END_DATE for other primary_tax_flag = 'Y' and other l_tax_id
1464:
1465: UPDATE JL_ZZ_AP_SUP_AWT_CD SAWTC SET SAWTC.EFFECTIVE_END_DATE = l_START_DATE - 1

Line 1473: FND_FILE.PUT_LINE( FND_FILE.LOG,'38 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

1469: --AND SAWTC.TAX_ID <> l_tax_id -- other l_tax_id
1470: AND SAWTC.EFFECTIVE_END_DATE IS NULL;
1471:
1472: IF p_debug_log = 'Y' THEN
1473: FND_FILE.PUT_LINE( FND_FILE.LOG,'38 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1474: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1475: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. L_TAX_ID : '|| L_TAX_ID || 'for L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1476:
1477: END IF;

Line 1474: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);

1470: AND SAWTC.EFFECTIVE_END_DATE IS NULL;
1471:
1472: IF p_debug_log = 'Y' THEN
1473: FND_FILE.PUT_LINE( FND_FILE.LOG,'38 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1474: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1475: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. L_TAX_ID : '|| L_TAX_ID || 'for L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1476:
1477: END IF;
1478:

Line 1475: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. L_TAX_ID : '|| L_TAX_ID || 'for L_TAXPAYER_ID : '|| L_TAXPAYER_ID);

1471:
1472: IF p_debug_log = 'Y' THEN
1473: FND_FILE.PUT_LINE( FND_FILE.LOG,'38 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
1474: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. EFFECTIVE_END_DATE (L_START_DATE-1) : '|| L_START_DATE);
1475: FND_FILE.PUT_LINE( FND_FILE.LOG,'38. L_TAX_ID : '|| L_TAX_ID || 'for L_TAXPAYER_ID : '|| L_TAXPAYER_ID);
1476:
1477: END IF;
1478:
1479:

Line 1509: FND_FILE.put_line( FND_FILE.LOG,'38 . Inserted data in JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);

1505: NULL); --EFFECTIVE_END_DATE
1506:
1507:
1508: IF p_debug_log = 'Y' THEN
1509: FND_FILE.put_line( FND_FILE.LOG,'38 . Inserted data in JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);
1510: END IF;
1511:
1512: COMMIT;
1513:

Line 1519: FND_FILE.put_line( FND_FILE.LOG,'39 . Failed to INSERT into JL_ZZ_AP_SUP_AWT_CD Insert not done '|| SQLCODE || 'ERROR' || SQLERRM);

1515: EXCEPTION
1516: WHEN OTHERS THEN
1517:
1518: IF p_debug_log = 'Y' THEN
1519: FND_FILE.put_line( FND_FILE.LOG,'39 . Failed to INSERT into JL_ZZ_AP_SUP_AWT_CD Insert not done '|| SQLCODE || 'ERROR' || SQLERRM);
1520: END IF;
1521:
1522:
1523: IF p_debug_log = 'Y' THEN

Line 1524: FND_FILE.put_line( FND_FILE.LOG,'39. l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);

1520: END IF;
1521:
1522:
1523: IF p_debug_log = 'Y' THEN
1524: FND_FILE.put_line( FND_FILE.LOG,'39. l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1525: END IF;
1526:
1527: BEGIN
1528: SELECT 'Y', SAWTC.SUPP_AWT_CODE_ID INTO taxtype_code_check, l_SUPP_AWT_CODE_ID_CD

Line 1544: FND_FILE.PUT_LINE( FND_FILE.LOG,'40 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);

1540: IF taxtype_code_check = 'Y' THEN
1541:
1542: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
1543: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
1544: FND_FILE.PUT_LINE( FND_FILE.LOG,'40 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
1545: FND_FILE.PUT_LINE( FND_FILE.LOG,'40. l_tax_id'|| l_tax_id || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
1546:
1547:
1548: NULL;

Line 1545: FND_FILE.PUT_LINE( FND_FILE.LOG,'40. l_tax_id'|| l_tax_id || 'L_EFFECTIVE_START_DATE' || L_START_DATE);

1541:
1542: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
1543: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
1544: FND_FILE.PUT_LINE( FND_FILE.LOG,'40 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
1545: FND_FILE.PUT_LINE( FND_FILE.LOG,'40. l_tax_id'|| l_tax_id || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
1546:
1547:
1548: NULL;
1549: ELSE

Line 1561: FND_FILE.put_line( FND_FILE.LOG,'41 . l_tax_id'|| l_tax_id || 'l_EFFECTIVE_START_DATE' || l_START_DATE);

1557:
1558: END IF;
1559:
1560: IF p_debug_log = 'Y' THEN
1561: FND_FILE.put_line( FND_FILE.LOG,'41 . l_tax_id'|| l_tax_id || 'l_EFFECTIVE_START_DATE' || l_START_DATE);
1562: FND_FILE.PUT_LINE( FND_FILE.LOG,'41 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);
1563: END IF;
1564:
1565: END;

Line 1562: FND_FILE.PUT_LINE( FND_FILE.LOG,'41 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);

1558: END IF;
1559:
1560: IF p_debug_log = 'Y' THEN
1561: FND_FILE.put_line( FND_FILE.LOG,'41 . l_tax_id'|| l_tax_id || 'l_EFFECTIVE_START_DATE' || l_START_DATE);
1562: FND_FILE.PUT_LINE( FND_FILE.LOG,'41 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD for '|| SQL%ROWCOUNT ||' Records and code id is :'|| l_SUPP_AWT_TYPE_ID_CD);
1563: END IF;
1564:
1565: END;
1566:

Line 1569: FND_FILE.put_line( FND_FILE.LOG,'42 . l_tax_id'|| l_tax_id || 'l_SUPP_AWT_CODE_ID_CD' || l_SUPP_AWT_CODE_ID_CD || 'l_EFFECTIVE_START_DATE-1' || l_START_DATE);

1565: END;
1566:
1567:
1568: IF p_debug_log = 'Y' THEN
1569: FND_FILE.put_line( FND_FILE.LOG,'42 . l_tax_id'|| l_tax_id || 'l_SUPP_AWT_CODE_ID_CD' || l_SUPP_AWT_CODE_ID_CD || 'l_EFFECTIVE_START_DATE-1' || l_START_DATE);
1570: FND_FILE.PUT_LINE( FND_FILE.LOG,'42 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR PRIMARY_TAX_FLAG AS N AND EFFECTIVE_START_DATE FOR '|| SQL%ROWCOUNT ||' RECORDS');
1571: END IF;
1572:
1573: -- Code to insert/UPDATE JL_ZZ_AP_INV_DIS_WH (TDD 3.3.2)

Line 1570: FND_FILE.PUT_LINE( FND_FILE.LOG,'42 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR PRIMARY_TAX_FLAG AS N AND EFFECTIVE_START_DATE FOR '|| SQL%ROWCOUNT ||' RECORDS');

1566:
1567:
1568: IF p_debug_log = 'Y' THEN
1569: FND_FILE.put_line( FND_FILE.LOG,'42 . l_tax_id'|| l_tax_id || 'l_SUPP_AWT_CODE_ID_CD' || l_SUPP_AWT_CODE_ID_CD || 'l_EFFECTIVE_START_DATE-1' || l_START_DATE);
1570: FND_FILE.PUT_LINE( FND_FILE.LOG,'42 . UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR PRIMARY_TAX_FLAG AS N AND EFFECTIVE_START_DATE FOR '|| SQL%ROWCOUNT ||' RECORDS');
1571: END IF;
1572:
1573: -- Code to insert/UPDATE JL_ZZ_AP_INV_DIS_WH (TDD 3.3.2)
1574:

Line 1613: FND_FILE.PUT_LINE( FND_FILE.LOG,'43 UPDATE NOT DONE FOR JL_ZZ_AP_INV_DIS_WH - '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: IF p_debug_log = 'Y' THEN
1613: FND_FILE.PUT_LINE( FND_FILE.LOG,'43 UPDATE NOT DONE FOR JL_ZZ_AP_INV_DIS_WH - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1614: END IF;
1615: END;
1616:
1617: OPEN CUR3(l_TAXPAYER_ID);

Line 1640: FND_FILE.put_line( FND_FILE.LOG,'44 No earlier data in Inv Dist for this Invoice'|| SQLCODE ||' -ERROR- '|| SQLERRM);

1636:
1637: EXCEPTION
1638: WHEN NO_DATA_FOUND THEN
1639: AWT_CODE_INV_AVAIL_FLAG := 'N';
1640: FND_FILE.put_line( FND_FILE.LOG,'44 No earlier data in Inv Dist for this Invoice'|| SQLCODE ||' -ERROR- '|| SQLERRM);
1641:
1642: WHEN OTHERS THEN
1643: AWT_CODE_INV_AVAIL_FLAG := 'N';
1644: FND_FILE.put_line( FND_FILE.LOG,'44 Error in Inv Dist select'|| SQLCODE ||' -ERROR- '|| SQLERRM);

Line 1644: FND_FILE.put_line( FND_FILE.LOG,'44 Error in Inv Dist select'|| SQLCODE ||' -ERROR- '|| SQLERRM);

1640: FND_FILE.put_line( FND_FILE.LOG,'44 No earlier data in Inv Dist for this Invoice'|| SQLCODE ||' -ERROR- '|| SQLERRM);
1641:
1642: WHEN OTHERS THEN
1643: AWT_CODE_INV_AVAIL_FLAG := 'N';
1644: FND_FILE.put_line( FND_FILE.LOG,'44 Error in Inv Dist select'|| SQLCODE ||' -ERROR- '|| SQLERRM);
1645: END;
1646:
1647: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
1648:

Line 1650: FND_FILE.put_line( FND_FILE.LOG,'45 l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);

1646:
1647: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
1648:
1649: IF p_debug_log = 'Y' THEN
1650: FND_FILE.put_line( FND_FILE.LOG,'45 l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1651: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1652: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1653: FND_FILE.put_line( FND_FILE.LOG,'45 l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1654: FND_FILE.put_line( FND_FILE.LOG,'45 INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

Line 1651: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);

1647: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
1648:
1649: IF p_debug_log = 'Y' THEN
1650: FND_FILE.put_line( FND_FILE.LOG,'45 l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1651: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1652: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1653: FND_FILE.put_line( FND_FILE.LOG,'45 l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1654: FND_FILE.put_line( FND_FILE.LOG,'45 INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1655: END IF;

Line 1652: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);

1648:
1649: IF p_debug_log = 'Y' THEN
1650: FND_FILE.put_line( FND_FILE.LOG,'45 l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1651: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1652: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1653: FND_FILE.put_line( FND_FILE.LOG,'45 l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1654: FND_FILE.put_line( FND_FILE.LOG,'45 INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1655: END IF;
1656: ---code to insert data INTO jl_zz_ap_inv_dis_wh_all

Line 1653: FND_FILE.put_line( FND_FILE.LOG,'45 l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);

1649: IF p_debug_log = 'Y' THEN
1650: FND_FILE.put_line( FND_FILE.LOG,'45 l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1651: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1652: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1653: FND_FILE.put_line( FND_FILE.LOG,'45 l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1654: FND_FILE.put_line( FND_FILE.LOG,'45 INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1655: END IF;
1656: ---code to insert data INTO jl_zz_ap_inv_dis_wh_all
1657: BEGIN

Line 1654: FND_FILE.put_line( FND_FILE.LOG,'45 INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

1650: FND_FILE.put_line( FND_FILE.LOG,'45 l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1651: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1652: FND_FILE.put_line( FND_FILE.LOG,'45 INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1653: FND_FILE.put_line( FND_FILE.LOG,'45 l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1654: FND_FILE.put_line( FND_FILE.LOG,'45 INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1655: END IF;
1656: ---code to insert data INTO jl_zz_ap_inv_dis_wh_all
1657: BEGIN
1658:

Line 1690: FND_FILE.put_line( FND_FILE.LOG,'45 A. '|| SQL%ROWCOUNT ||'Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1686:
1687: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
1688:
1689: IF p_debug_log = 'Y' THEN
1690: FND_FILE.put_line( FND_FILE.LOG,'45 A. '|| SQL%ROWCOUNT ||'Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1691: END IF;
1692:
1693: EXCEPTION
1694: WHEN OTHERS THEN

Line 1696: FND_FILE.put_line( FND_FILE.LOG,'45 A. Failed while Inserting records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1692:
1693: EXCEPTION
1694: WHEN OTHERS THEN
1695: IF p_debug_log = 'Y' THEN
1696: FND_FILE.put_line( FND_FILE.LOG,'45 A. Failed while Inserting records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1697: END IF;
1698: END;
1699: ELSE
1700: BEGIN

Line 1702: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);

1698: END;
1699: ELSE
1700: BEGIN
1701: IF p_debug_log = 'Y' THEN
1702: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1703: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1704: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1705: FND_FILE.put_line( FND_FILE.LOG,'45 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1706: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);

Line 1703: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);

1699: ELSE
1700: BEGIN
1701: IF p_debug_log = 'Y' THEN
1702: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1703: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1704: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1705: FND_FILE.put_line( FND_FILE.LOG,'45 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1706: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1707: FND_FILE.put_line( FND_FILE.LOG,'45 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

Line 1704: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);

1700: BEGIN
1701: IF p_debug_log = 'Y' THEN
1702: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1703: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1704: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1705: FND_FILE.put_line( FND_FILE.LOG,'45 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1706: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1707: FND_FILE.put_line( FND_FILE.LOG,'45 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1708: END IF;

Line 1705: FND_FILE.put_line( FND_FILE.LOG,'45 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);

1701: IF p_debug_log = 'Y' THEN
1702: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1703: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1704: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1705: FND_FILE.put_line( FND_FILE.LOG,'45 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1706: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1707: FND_FILE.put_line( FND_FILE.LOG,'45 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1708: END IF;
1709:

Line 1706: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);

1702: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
1703: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1704: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1705: FND_FILE.put_line( FND_FILE.LOG,'45 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1706: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1707: FND_FILE.put_line( FND_FILE.LOG,'45 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1708: END IF;
1709:
1710: /*SELECT INV_DISTRIB_AWT_ID INTO l_INV_DISTRIB_AWT_ID_DIS

Line 1707: FND_FILE.put_line( FND_FILE.LOG,'45 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

1703: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
1704: FND_FILE.put_line( FND_FILE.LOG,'45 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
1705: FND_FILE.put_line( FND_FILE.LOG,'45 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
1706: FND_FILE.put_line( FND_FILE.LOG,'45 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
1707: FND_FILE.put_line( FND_FILE.LOG,'45 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
1708: END IF;
1709:
1710: /*SELECT INV_DISTRIB_AWT_ID INTO l_INV_DISTRIB_AWT_ID_DIS
1711: FROM JL_ZZ_AP_INV_DIS_WH

Line 1727: FND_FILE.put_line( FND_FILE.LOG,'46 A. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1723: UPDATE JL_ZZ_AP_INV_DIS_WH SET SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD
1724: WHERE INV_DISTRIB_AWT_ID = l_INV_DISTRIB_AWT_ID_DIS;
1725:
1726: IF p_debug_log = 'Y' THEN
1727: FND_FILE.put_line( FND_FILE.LOG,'46 A. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1728: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);
1729: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);
1730: END IF;
1731:

Line 1728: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);

1724: WHERE INV_DISTRIB_AWT_ID = l_INV_DISTRIB_AWT_ID_DIS;
1725:
1726: IF p_debug_log = 'Y' THEN
1727: FND_FILE.put_line( FND_FILE.LOG,'46 A. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1728: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);
1729: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);
1730: END IF;
1731:
1732: EXCEPTION

Line 1729: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);

1725:
1726: IF p_debug_log = 'Y' THEN
1727: FND_FILE.put_line( FND_FILE.LOG,'46 A. Updated '|| SQL%ROWCOUNT ||' records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1728: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_SUPP_AWT_CODE_ID_CD:'|| l_SUPP_AWT_CODE_ID_CD);
1729: FND_FILE.put_line( FND_FILE.LOG,'46 A. l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS);
1730: END IF;
1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN

Line 1735: FND_FILE.put_line( FND_FILE.LOG,'46 B. Failed while updating records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: IF p_debug_log = 'Y' THEN
1735: FND_FILE.put_line( FND_FILE.LOG,'46 B. Failed while updating records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
1736: END IF;
1737: END;
1738:
1739: END IF;

Line 1745: FND_FILE.PUT_LINE( FND_FILE.LOG,'46 C. UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID ');

1741: END LOOP;
1742: CLOSE CUR3;
1743:
1744: IF p_debug_log = 'Y' THEN
1745: FND_FILE.PUT_LINE( FND_FILE.LOG,'46 C. UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID ');
1746: END IF;
1747:
1748:
1749:

Line 1767: FND_FILE.put_line( FND_FILE.LOG,'47 . Inserted data in JL_AR_TURN_UPL for All Records ');

1763:
1764: -- delete JL_AR_TURN_UPL_T WHERE TAXPAYER_ID = l_TAXPAYER_ID;
1765:
1766: IF p_debug_log = 'Y' THEN
1767: FND_FILE.put_line( FND_FILE.LOG,'47 . Inserted data in JL_AR_TURN_UPL for All Records ');
1768: END IF;
1769:
1770: END IF;
1771:

Line 1798: FND_FILE.PUT_LINE( FND_FILE.LOG,'49 .TAXPAYER ID FAILED IN FINAL VALIDATION, FETCHING NEXT RECORD - '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1794:
1795: EXCEPTION
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:

Line 1817: FND_FILE.PUT_LINE( FND_FILE.LOG,'49 .AN ERROR WAS ENCOUNTERED WHEN FINAL VALIDATION - '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1813:
1814: EXCEPTION
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:

Line 1961: FND_FILE.PUT_LINE( FND_FILE.LOG,'50 .AN ERROR WAS ENCOUNTERED WHILE CHECKING DEFAULT AP TAX CODE FOR PREV MONTH- '|| SQLCODE ||' -ERROR- '|| SQLERRM);

1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: IF p_debug_log = 'Y' THEN
1961: FND_FILE.PUT_LINE( FND_FILE.LOG,'50 .AN ERROR WAS ENCOUNTERED WHILE CHECKING DEFAULT AP TAX CODE FOR PREV MONTH- '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1962: END IF;
1963: END;
1964: IF p_debug_log = 'Y' THEN
1965: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_START_DATE_CURR_MAX' || l_START_DATE_CURR_MAX);

Line 1965: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_START_DATE_CURR_MAX' || l_START_DATE_CURR_MAX);

1961: FND_FILE.PUT_LINE( FND_FILE.LOG,'50 .AN ERROR WAS ENCOUNTERED WHILE CHECKING DEFAULT AP TAX CODE FOR PREV MONTH- '|| SQLCODE ||' -ERROR- '|| SQLERRM);
1962: END IF;
1963: END;
1964: IF p_debug_log = 'Y' THEN
1965: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_START_DATE_CURR_MAX' || l_START_DATE_CURR_MAX);
1966: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_END_DATE_CURR_MAX' || l_END_DATE_SEC_MAX);
1967: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_ATC' || l_WHT_GROUP_NUM_DEF_ATC);
1968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_TAX_ID_DEF_ATC' || l_TAX_ID_DEF_ATC);
1969: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_RATE_DEF_ATR' || l_WHT_RATE_DEF_ATR);

Line 1966: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_END_DATE_CURR_MAX' || l_END_DATE_SEC_MAX);

1962: END IF;
1963: END;
1964: IF p_debug_log = 'Y' THEN
1965: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_START_DATE_CURR_MAX' || l_START_DATE_CURR_MAX);
1966: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_END_DATE_CURR_MAX' || l_END_DATE_SEC_MAX);
1967: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_ATC' || l_WHT_GROUP_NUM_DEF_ATC);
1968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_TAX_ID_DEF_ATC' || l_TAX_ID_DEF_ATC);
1969: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_RATE_DEF_ATR' || l_WHT_RATE_DEF_ATR);
1970: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_NO' || l_WHT_GROUP_NUM_DEF_NO);

Line 1967: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_ATC' || l_WHT_GROUP_NUM_DEF_ATC);

1963: END;
1964: IF p_debug_log = 'Y' THEN
1965: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_START_DATE_CURR_MAX' || l_START_DATE_CURR_MAX);
1966: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_END_DATE_CURR_MAX' || l_END_DATE_SEC_MAX);
1967: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_ATC' || l_WHT_GROUP_NUM_DEF_ATC);
1968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_TAX_ID_DEF_ATC' || l_TAX_ID_DEF_ATC);
1969: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_RATE_DEF_ATR' || l_WHT_RATE_DEF_ATR);
1970: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_NO' || l_WHT_GROUP_NUM_DEF_NO);
1971: END IF;

Line 1968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_TAX_ID_DEF_ATC' || l_TAX_ID_DEF_ATC);

1964: IF p_debug_log = 'Y' THEN
1965: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_START_DATE_CURR_MAX' || l_START_DATE_CURR_MAX);
1966: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_END_DATE_CURR_MAX' || l_END_DATE_SEC_MAX);
1967: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_ATC' || l_WHT_GROUP_NUM_DEF_ATC);
1968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_TAX_ID_DEF_ATC' || l_TAX_ID_DEF_ATC);
1969: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_RATE_DEF_ATR' || l_WHT_RATE_DEF_ATR);
1970: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_NO' || l_WHT_GROUP_NUM_DEF_NO);
1971: END IF;
1972:

Line 1969: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_RATE_DEF_ATR' || l_WHT_RATE_DEF_ATR);

1965: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_START_DATE_CURR_MAX' || l_START_DATE_CURR_MAX);
1966: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_END_DATE_CURR_MAX' || l_END_DATE_SEC_MAX);
1967: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_ATC' || l_WHT_GROUP_NUM_DEF_ATC);
1968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_TAX_ID_DEF_ATC' || l_TAX_ID_DEF_ATC);
1969: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_RATE_DEF_ATR' || l_WHT_RATE_DEF_ATR);
1970: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_NO' || l_WHT_GROUP_NUM_DEF_NO);
1971: END IF;
1972:
1973:

Line 1970: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_NO' || l_WHT_GROUP_NUM_DEF_NO);

1966: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_END_DATE_CURR_MAX' || l_END_DATE_SEC_MAX);
1967: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_ATC' || l_WHT_GROUP_NUM_DEF_ATC);
1968: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_TAX_ID_DEF_ATC' || l_TAX_ID_DEF_ATC);
1969: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_RATE_DEF_ATR' || l_WHT_RATE_DEF_ATR);
1970: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_WHT_GROUP_NUM_DEF_NO' || l_WHT_GROUP_NUM_DEF_NO);
1971: END IF;
1972:
1973:
1974: OPEN C4(l_START_DATE_CURR_MAX);

Line 1995: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing for TAXPAYER_ID'|| l_TAXPAYER_ID || SQLCODE || 'ERROR' || SQLERRM);

1991: l_WHT_GROUP_NUM := V_ALLREC.WHT_GROUP_NUM;
1992:
1993:
1994: IF p_debug_log = 'Y' THEN
1995: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing for TAXPAYER_ID'|| l_TAXPAYER_ID || SQLCODE || 'ERROR' || SQLERRM);
1996: END IF;
1997: -- AP tax payer id available check
1998:
1999: BEGIN

Line 2058: FND_FILE.put_line(FND_FILE.LOG,'58. AR validtion completed successfully');

2054: l_END_DATE_CURR_MAX,
2055: l_RETURN_STATUS ); -- out parameter for status
2056:
2057: IF l_RETURN_STATUS = 'S' THEN --bug 9907885
2058: FND_FILE.put_line(FND_FILE.LOG,'58. AR validtion completed successfully');
2059: END IF;
2060:
2061: EXCEPTION
2062: WHEN OTHERS THEN

Line 2064: FND_FILE.put_line(FND_FILE.LOG,'58. AR validation failed with return status'|| l_RETURN_STATUS || SQLCODE || 'ERROR' || SQLERRM);

2060:
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: IF p_debug_log = 'Y' THEN
2064: FND_FILE.put_line(FND_FILE.LOG,'58. AR validation failed with return status'|| l_RETURN_STATUS || SQLCODE || 'ERROR' || SQLERRM);
2065: END IF;
2066: RAISE_APPLICATION_ERROR(- 20999,'AR validation failed'|| SQLCODE ||' -ERROR- '|| SQLERRM);
2067: END;
2068:

Line 2084: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 . NO DATA FOUND FOR TAXPAYER ID FOR PREV MONTH '|| L_TAXPAYER_ID);

2080:
2081: EXCEPTION
2082: WHEN NO_DATA_FOUND THEN
2083: IF p_debug_log = 'Y' THEN
2084: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 . NO DATA FOUND FOR TAXPAYER ID FOR PREV MONTH '|| L_TAXPAYER_ID);
2085: END IF;
2086: --GOTO L4; --For current month data, will get no data found and fetching next record
2087: WHEN OTHERS THEN
2088: IF p_debug_log = 'Y' THEN

Line 2089: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 .FAILED IN CHECKING TAXPAYER ID AND DEF ATC FOR PREV MONTH- '|| SQLCODE ||' -ERROR- '|| SQLERRM);

2085: END IF;
2086: --GOTO L4; --For current month data, will get no data found and fetching next record
2087: WHEN OTHERS THEN
2088: IF p_debug_log = 'Y' THEN
2089: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 .FAILED IN CHECKING TAXPAYER ID AND DEF ATC FOR PREV MONTH- '|| SQLCODE ||' -ERROR- '|| SQLERRM);
2090: END IF;
2091: END;
2092:
2093: IF p_debug_log = 'Y' THEN

Line 2094: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 l_START_DATE_SEC_MAX'|| l_START_DATE_SEC_MAX ||'l_END_DATE_SEC_MAX '|| l_END_DATE_SEC_MAX);

2090: END IF;
2091: END;
2092:
2093: IF p_debug_log = 'Y' THEN
2094: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 l_START_DATE_SEC_MAX'|| l_START_DATE_SEC_MAX ||'l_END_DATE_SEC_MAX '|| l_END_DATE_SEC_MAX);
2095: END IF;
2096:
2097: IF p_debug_log = 'Y' THEN
2098: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 . TAXPAYER ID FOR PREV MONTH '|| L_TAXPAYER_ID);

Line 2098: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 . TAXPAYER ID FOR PREV MONTH '|| L_TAXPAYER_ID);

2094: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 l_START_DATE_SEC_MAX'|| l_START_DATE_SEC_MAX ||'l_END_DATE_SEC_MAX '|| l_END_DATE_SEC_MAX);
2095: END IF;
2096:
2097: IF p_debug_log = 'Y' THEN
2098: FND_FILE.PUT_LINE( FND_FILE.LOG,'51 . TAXPAYER ID FOR PREV MONTH '|| L_TAXPAYER_ID);
2099: END IF;
2100:
2101:
2102: --- To process only the last month data and to avoid the current month taxpayer id if any

Line 2144: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');

2140: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = l_END_DATE_SEC_MAX
2141: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2142:
2143: IF p_debug_log = 'Y' THEN
2144: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
2145: FND_FILE.PUT_LINE( FND_FILE.LOG,'52. EFFECTIVE_END_DATE (l_END_DATE_SEC_MAX-1) :'||l_END_DATE_SEC_MAX||' FOR CODE_ID :'||l_SUPP_AWT_CODE_ID_CD);
2146: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 l_TAX_ID_DEF_ATC : '|| l_TAX_ID_DEF_ATC || ' l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
2147: END IF;
2148:

Line 2145: FND_FILE.PUT_LINE( FND_FILE.LOG,'52. EFFECTIVE_END_DATE (l_END_DATE_SEC_MAX-1) :'||l_END_DATE_SEC_MAX||' FOR CODE_ID :'||l_SUPP_AWT_CODE_ID_CD);

2141: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2142:
2143: IF p_debug_log = 'Y' THEN
2144: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
2145: FND_FILE.PUT_LINE( FND_FILE.LOG,'52. EFFECTIVE_END_DATE (l_END_DATE_SEC_MAX-1) :'||l_END_DATE_SEC_MAX||' FOR CODE_ID :'||l_SUPP_AWT_CODE_ID_CD);
2146: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 l_TAX_ID_DEF_ATC : '|| l_TAX_ID_DEF_ATC || ' l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
2147: END IF;
2148:
2149:

Line 2146: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 l_TAX_ID_DEF_ATC : '|| l_TAX_ID_DEF_ATC || ' l_TAXPAYER_ID : '|| l_TAXPAYER_ID);

2142:
2143: IF p_debug_log = 'Y' THEN
2144: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR '|| SQL%ROWCOUNT || 'RECORDS');
2145: FND_FILE.PUT_LINE( FND_FILE.LOG,'52. EFFECTIVE_END_DATE (l_END_DATE_SEC_MAX-1) :'||l_END_DATE_SEC_MAX||' FOR CODE_ID :'||l_SUPP_AWT_CODE_ID_CD);
2146: FND_FILE.PUT_LINE( FND_FILE.LOG,'52 l_TAX_ID_DEF_ATC : '|| l_TAX_ID_DEF_ATC || ' l_TAXPAYER_ID : '|| l_TAXPAYER_ID);
2147: END IF;
2148:
2149:
2150: SELECT jl_zz_ap_sup_awt_cd_s.nextval INTO l_SUPP_AWT_CODE_ID_SEQ FROM dual;

Line 2182: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 .INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID '|| L_SUPP_AWT_CODE_ID_SEQ);

2178: NULL); --EFFECTIVE_END_DATE
2179:
2180:
2181: IF p_debug_log = 'Y' THEN
2182: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 .INSERTED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID '|| L_SUPP_AWT_CODE_ID_SEQ);
2183: END IF;
2184:
2185: EXCEPTION
2186: WHEN OTHERS THEN

Line 2189: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. INSERTED NOT DONE FOR JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);

2185: EXCEPTION
2186: WHEN OTHERS THEN
2187:
2188: IF p_debug_log = 'Y' THEN
2189: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. INSERTED NOT DONE FOR JL_ZZ_AP_SUP_AWT_CD '|| SQLCODE ||' -ERROR- '|| SQLERRM);
2190: END IF;
2191: --If insertion fails, then will check already present in JL_ZZ_AP_SUP_AWT_CD
2192:
2193: BEGIN

Line 2208: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);

2204: IF def_taxtype_code_check = 'Y' THEN
2205: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
2206: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2207:
2208: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
2209: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. l_TAX_ID_DEF_ATC'|| l_TAX_ID_DEF_ATC || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
2210:
2211: ELSE
2212: ----If insertion fails, then will do the UPDATE in awt_cd_all

Line 2209: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. l_TAX_ID_DEF_ATC'|| l_TAX_ID_DEF_ATC || 'L_EFFECTIVE_START_DATE' || L_START_DATE);

2205: UPDATE JL_ZZ_AP_SUP_AWT_CD SET EFFECTIVE_END_DATE = NULL
2206: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2207:
2208: FND_FILE.PUT_LINE( FND_FILE.LOG,'53 Records already present in JL_ZZ_AP_SUP_AWT_CD table TYPE ID'|| l_SUPP_AWT_TYPE_ID_CD);
2209: FND_FILE.PUT_LINE( FND_FILE.LOG,'53. l_TAX_ID_DEF_ATC'|| l_TAX_ID_DEF_ATC || 'L_EFFECTIVE_START_DATE' || L_START_DATE);
2210:
2211: ELSE
2212: ----If insertion fails, then will do the UPDATE in awt_cd_all
2213: UPDATE JL_ZZ_AP_SUP_AWT_CD SET

Line 2221: FND_FILE.PUT_LINE( FND_FILE.LOG,'54 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID WITH OLD TAX_ID for CODE ID'|| l_SUPP_AWT_CODE_ID_CD);

2217: EFFECTIVE_END_DATE = NULL
2218: WHERE SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD;
2219:
2220: IF p_debug_log = 'Y' THEN
2221: FND_FILE.PUT_LINE( FND_FILE.LOG,'54 .UPDATED DATA IN JL_ZZ_AP_SUP_AWT_CD FOR SUPP_AWT_CODE_ID WITH OLD TAX_ID for CODE ID'|| l_SUPP_AWT_CODE_ID_CD);
2222: END IF;
2223: END IF;
2224:
2225: END;

Line 2266: FND_FILE.PUT_LINE( FND_FILE.LOG,'54 UPDATE NOT DONE FOR JL_ZZ_AP_INV_DIS_WH - '|| SQLCODE ||' -ERROR- '|| SQLERRM);

2262:
2263: EXCEPTION
2264: WHEN OTHERS THEN
2265: IF p_debug_log = 'Y' THEN
2266: FND_FILE.PUT_LINE( FND_FILE.LOG,'54 UPDATE NOT DONE FOR JL_ZZ_AP_INV_DIS_WH - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
2267: END IF;
2268: END;
2269:
2270: OPEN CUR4(l_TAXPAYER_ID);

Line 2294: FND_FILE.put_line( FND_FILE.LOG,'54 A No earlier data in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);

2290:
2291: EXCEPTION
2292: WHEN NO_DATA_FOUND THEN
2293: AWT_CODE_INV_AVAIL_FLAG := 'N';
2294: FND_FILE.put_line( FND_FILE.LOG,'54 A No earlier data in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);
2295:
2296: WHEN OTHERS THEN
2297: AWT_CODE_INV_AVAIL_FLAG := 'N';
2298: FND_FILE.put_line( FND_FILE.LOG,'54 A Error in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);

Line 2298: FND_FILE.put_line( FND_FILE.LOG,'54 A Error in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);

2294: FND_FILE.put_line( FND_FILE.LOG,'54 A No earlier data in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);
2295:
2296: WHEN OTHERS THEN
2297: AWT_CODE_INV_AVAIL_FLAG := 'N';
2298: FND_FILE.put_line( FND_FILE.LOG,'54 A Error in Inv Dist'|| SQLCODE ||' -ERROR- '|| SQLERRM);
2299: END;
2300:
2301: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
2302:

Line 2304: FND_FILE.put_line( FND_FILE.LOG,'54 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);

2300:
2301: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
2302:
2303: IF p_debug_log = 'Y' THEN
2304: FND_FILE.put_line( FND_FILE.LOG,'54 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2305: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2306: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2307: FND_FILE.put_line( FND_FILE.LOG,'54 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2308: FND_FILE.put_line( FND_FILE.LOG,'54 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

Line 2305: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);

2301: IF AWT_CODE_INV_AVAIL_FLAG = 'N' THEN
2302:
2303: IF p_debug_log = 'Y' THEN
2304: FND_FILE.put_line( FND_FILE.LOG,'54 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2305: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2306: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2307: FND_FILE.put_line( FND_FILE.LOG,'54 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2308: FND_FILE.put_line( FND_FILE.LOG,'54 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2309: END IF;

Line 2306: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);

2302:
2303: IF p_debug_log = 'Y' THEN
2304: FND_FILE.put_line( FND_FILE.LOG,'54 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2305: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2306: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2307: FND_FILE.put_line( FND_FILE.LOG,'54 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2308: FND_FILE.put_line( FND_FILE.LOG,'54 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2309: END IF;
2310:

Line 2307: FND_FILE.put_line( FND_FILE.LOG,'54 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);

2303: IF p_debug_log = 'Y' THEN
2304: FND_FILE.put_line( FND_FILE.LOG,'54 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2305: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2306: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2307: FND_FILE.put_line( FND_FILE.LOG,'54 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2308: FND_FILE.put_line( FND_FILE.LOG,'54 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2309: END IF;
2310:
2311: BEGIN

Line 2308: FND_FILE.put_line( FND_FILE.LOG,'54 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

2304: FND_FILE.put_line( FND_FILE.LOG,'54 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2305: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2306: FND_FILE.put_line( FND_FILE.LOG,'54 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2307: FND_FILE.put_line( FND_FILE.LOG,'54 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2308: FND_FILE.put_line( FND_FILE.LOG,'54 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2309: END IF;
2310:
2311: BEGIN
2312:

Line 2342: FND_FILE.PUT_LINE( FND_FILE.LOG,'55 A. INSERTED RECORDS INTO JL_ZZ_AP_INV_DIS_WH_S '|| SQL%ROWCOUNT || 'RECORDS' || SQLCODE ||' -ERROR- '|| SQLERRM);

2338:
2339: SELECT JL_ZZ_AP_INV_DIS_WH_S.NEXTVAL INTO l_INV_DISTRIB_AWT_ID_INV FROM dual;
2340:
2341: IF p_debug_log = 'Y' THEN
2342: FND_FILE.PUT_LINE( FND_FILE.LOG,'55 A. INSERTED RECORDS INTO JL_ZZ_AP_INV_DIS_WH_S '|| SQL%ROWCOUNT || 'RECORDS' || SQLCODE ||' -ERROR- '|| SQLERRM);
2343: END IF;
2344:
2345: EXCEPTION
2346: WHEN OTHERS THEN

Line 2348: FND_FILE.put_line( FND_FILE.LOG,'55 A. Failed while Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

2344:
2345: EXCEPTION
2346: WHEN OTHERS THEN
2347: IF p_debug_log = 'Y' THEN
2348: FND_FILE.put_line( FND_FILE.LOG,'55 A. Failed while Inserted records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
2349: END IF;
2350: END;
2351:
2352: ELSE

Line 2356: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);

2352: ELSE
2353:
2354: BEGIN
2355: IF p_debug_log = 'Y' THEN
2356: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2357: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2358: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2359: FND_FILE.put_line( FND_FILE.LOG,'55 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2360: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);

Line 2357: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);

2353:
2354: BEGIN
2355: IF p_debug_log = 'Y' THEN
2356: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2357: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2358: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2359: FND_FILE.put_line( FND_FILE.LOG,'55 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2360: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
2361: FND_FILE.put_line( FND_FILE.LOG,'55 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

Line 2358: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);

2354: BEGIN
2355: IF p_debug_log = 'Y' THEN
2356: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2357: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2358: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2359: FND_FILE.put_line( FND_FILE.LOG,'55 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2360: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
2361: FND_FILE.put_line( FND_FILE.LOG,'55 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2362: END IF;

Line 2359: FND_FILE.put_line( FND_FILE.LOG,'55 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);

2355: IF p_debug_log = 'Y' THEN
2356: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2357: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2358: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2359: FND_FILE.put_line( FND_FILE.LOG,'55 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2360: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
2361: FND_FILE.put_line( FND_FILE.LOG,'55 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2362: END IF;
2363:

Line 2360: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);

2356: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_INV'|| l_INV_DISTRIB_AWT_ID_INV);
2357: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2358: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2359: FND_FILE.put_line( FND_FILE.LOG,'55 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2360: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
2361: FND_FILE.put_line( FND_FILE.LOG,'55 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2362: END IF;
2363:
2364: /*SELECT INV_DISTRIB_AWT_ID INTO l_INV_DISTRIB_AWT_ID_DIS

Line 2361: FND_FILE.put_line( FND_FILE.LOG,'55 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);

2357: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.INVOICE_ID'|| INV_REC.INVOICE_ID);
2358: FND_FILE.put_line( FND_FILE.LOG,'55 B INV_REC.DISTRIBUTION_LINE_NUMBER'|| INV_REC.DISTRIBUTION_LINE_NUMBER);
2359: FND_FILE.put_line( FND_FILE.LOG,'55 B l_SUPP_AWT_CODE_ID_CD'|| l_SUPP_AWT_CODE_ID_CD);
2360: FND_FILE.put_line( FND_FILE.LOG,'55 B l_INV_DISTRIB_AWT_ID_DIS'|| l_INV_DISTRIB_AWT_ID_DIS);
2361: FND_FILE.put_line( FND_FILE.LOG,'55 B INVOICE_DISTRIBUTION_ID'|| INV_REC.INVOICE_DISTRIBUTION_ID);
2362: END IF;
2363:
2364: /*SELECT INV_DISTRIB_AWT_ID INTO l_INV_DISTRIB_AWT_ID_DIS
2365: FROM JL_ZZ_AP_INV_DIS_WH

Line 2380: FND_FILE.PUT_LINE( FND_FILE.LOG,'55 C.UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID WITH CURRENT (DEF) TAX_ID for'|| SQL%ROWCOUNT || 'RECORD' || SQLCODE ||' -ERROR- '|| SQLERRM);

2376: UPDATE JL_ZZ_AP_INV_DIS_WH SET SUPP_AWT_CODE_ID = l_SUPP_AWT_CODE_ID_CD
2377: WHERE INV_DISTRIB_AWT_ID = l_INV_DISTRIB_AWT_ID_DIS;
2378:
2379: IF p_debug_log = 'Y' THEN
2380: FND_FILE.PUT_LINE( FND_FILE.LOG,'55 C.UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID WITH CURRENT (DEF) TAX_ID for'|| SQL%ROWCOUNT || 'RECORD' || SQLCODE ||' -ERROR- '|| SQLERRM);
2381: FND_FILE.put_line( FND_FILE.LOG,'55 C l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS || 'l_SUPP_AWT_CODE_ID_CD:' || l_SUPP_AWT_CODE_ID_CD);
2382: END IF;
2383:
2384:

Line 2381: FND_FILE.put_line( FND_FILE.LOG,'55 C l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS || 'l_SUPP_AWT_CODE_ID_CD:' || l_SUPP_AWT_CODE_ID_CD);

2377: WHERE INV_DISTRIB_AWT_ID = l_INV_DISTRIB_AWT_ID_DIS;
2378:
2379: IF p_debug_log = 'Y' THEN
2380: FND_FILE.PUT_LINE( FND_FILE.LOG,'55 C.UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID WITH CURRENT (DEF) TAX_ID for'|| SQL%ROWCOUNT || 'RECORD' || SQLCODE ||' -ERROR- '|| SQLERRM);
2381: FND_FILE.put_line( FND_FILE.LOG,'55 C l_INV_DISTRIB_AWT_ID_DIS:'|| l_INV_DISTRIB_AWT_ID_DIS || 'l_SUPP_AWT_CODE_ID_CD:' || l_SUPP_AWT_CODE_ID_CD);
2382: END IF;
2383:
2384:
2385: EXCEPTION

Line 2388: FND_FILE.put_line( FND_FILE.LOG,'56. Failed while updating records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);

2384:
2385: EXCEPTION
2386: WHEN OTHERS THEN
2387: IF p_debug_log = 'Y' THEN
2388: FND_FILE.put_line( FND_FILE.LOG,'56. Failed while updating records in JL_ZZ_AP_INV_DIS_WH '|| SQLCODE || 'ERROR' || SQLERRM);
2389: END IF;
2390: END;
2391:
2392: END IF;

Line 2398: FND_FILE.PUT_LINE( FND_FILE.LOG,'56. UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID ');

2394: END LOOP;
2395: CLOSE CUR4;
2396:
2397: IF p_debug_log = 'Y' THEN
2398: FND_FILE.PUT_LINE( FND_FILE.LOG,'56. UPDATED DATA IN JL_ZZ_AP_INV_DIS_WH FOR SUPP_AWT_CODE_ID ');
2399: END IF;
2400:
2401:
2402:

Line 2424: FND_FILE.put_line( FND_FILE.LOG,'57 .Fetching Record Record after Taxpayer Id '|| l_TAXPAYER_ID);

2420: 'Y',
2421: 'AP');
2422:
2423: IF p_debug_log = 'Y' THEN
2424: FND_FILE.put_line( FND_FILE.LOG,'57 .Fetching Record Record after Taxpayer Id '|| l_TAXPAYER_ID);
2425: END IF;
2426:
2427: END IF;
2428:

Line 2453: FND_FILE.PUT_LINE( FND_FILE.LOG,'58 .AN ERROR WAS ENCOUNTERED IN VALIDATION_AWT_SETUP - '|| SQLCODE ||' -ERROR- '|| SQLERRM);

2449:
2450: EXCEPTION
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:

Line 2478: FND_FILE.put_line( FND_FILE.LOG,'Starting PKG JL_AR_APPLICABLE_TAXES.beforeReport');

2474: P_START_DATE := to_DATE(P_START_DATE);
2475: P_END_DATE := to_DATE(P_END_DATE);
2476:
2477: IF p_debug_log = 'Y' THEN
2478: FND_FILE.put_line( FND_FILE.LOG,'Starting PKG JL_AR_APPLICABLE_TAXES.beforeReport');
2479: FND_FILE.put_line( FND_FILE.LOG,'P_REV_TEMP_DATA :'|| P_REV_TEMP_DATA);
2480: FND_FILE.put_line( FND_FILE.LOG,'P_VALIDATION_DATA :'|| P_VALIDATION_DATA);
2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);
2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);

Line 2479: FND_FILE.put_line( FND_FILE.LOG,'P_REV_TEMP_DATA :'|| P_REV_TEMP_DATA);

2475: P_END_DATE := to_DATE(P_END_DATE);
2476:
2477: IF p_debug_log = 'Y' THEN
2478: FND_FILE.put_line( FND_FILE.LOG,'Starting PKG JL_AR_APPLICABLE_TAXES.beforeReport');
2479: FND_FILE.put_line( FND_FILE.LOG,'P_REV_TEMP_DATA :'|| P_REV_TEMP_DATA);
2480: FND_FILE.put_line( FND_FILE.LOG,'P_VALIDATION_DATA :'|| P_VALIDATION_DATA);
2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);
2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);
2483: FND_FILE.put_line( FND_FILE.LOG,'P_END_DATE :'|| P_END_DATE);

Line 2480: FND_FILE.put_line( FND_FILE.LOG,'P_VALIDATION_DATA :'|| P_VALIDATION_DATA);

2476:
2477: IF p_debug_log = 'Y' THEN
2478: FND_FILE.put_line( FND_FILE.LOG,'Starting PKG JL_AR_APPLICABLE_TAXES.beforeReport');
2479: FND_FILE.put_line( FND_FILE.LOG,'P_REV_TEMP_DATA :'|| P_REV_TEMP_DATA);
2480: FND_FILE.put_line( FND_FILE.LOG,'P_VALIDATION_DATA :'|| P_VALIDATION_DATA);
2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);
2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);
2483: FND_FILE.put_line( FND_FILE.LOG,'P_END_DATE :'|| P_END_DATE);
2484: END IF;

Line 2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);

2477: IF p_debug_log = 'Y' THEN
2478: FND_FILE.put_line( FND_FILE.LOG,'Starting PKG JL_AR_APPLICABLE_TAXES.beforeReport');
2479: FND_FILE.put_line( FND_FILE.LOG,'P_REV_TEMP_DATA :'|| P_REV_TEMP_DATA);
2480: FND_FILE.put_line( FND_FILE.LOG,'P_VALIDATION_DATA :'|| P_VALIDATION_DATA);
2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);
2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);
2483: FND_FILE.put_line( FND_FILE.LOG,'P_END_DATE :'|| P_END_DATE);
2484: END IF;
2485: FND_FILE.put_line( FND_FILE.LOG,'ORG_ID :'|| l_org_id);

Line 2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);

2478: FND_FILE.put_line( FND_FILE.LOG,'Starting PKG JL_AR_APPLICABLE_TAXES.beforeReport');
2479: FND_FILE.put_line( FND_FILE.LOG,'P_REV_TEMP_DATA :'|| P_REV_TEMP_DATA);
2480: FND_FILE.put_line( FND_FILE.LOG,'P_VALIDATION_DATA :'|| P_VALIDATION_DATA);
2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);
2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);
2483: FND_FILE.put_line( FND_FILE.LOG,'P_END_DATE :'|| P_END_DATE);
2484: END IF;
2485: FND_FILE.put_line( FND_FILE.LOG,'ORG_ID :'|| l_org_id);
2486: IF (P_REV_TEMP_DATA = 'Y') AND (P_VALIDATION_DATA = 'N') AND (P_FINALIZE_DATA = 'N') THEN

Line 2483: FND_FILE.put_line( FND_FILE.LOG,'P_END_DATE :'|| P_END_DATE);

2479: FND_FILE.put_line( FND_FILE.LOG,'P_REV_TEMP_DATA :'|| P_REV_TEMP_DATA);
2480: FND_FILE.put_line( FND_FILE.LOG,'P_VALIDATION_DATA :'|| P_VALIDATION_DATA);
2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);
2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);
2483: FND_FILE.put_line( FND_FILE.LOG,'P_END_DATE :'|| P_END_DATE);
2484: END IF;
2485: FND_FILE.put_line( FND_FILE.LOG,'ORG_ID :'|| l_org_id);
2486: IF (P_REV_TEMP_DATA = 'Y') AND (P_VALIDATION_DATA = 'N') AND (P_FINALIZE_DATA = 'N') THEN
2487:

Line 2485: FND_FILE.put_line( FND_FILE.LOG,'ORG_ID :'|| l_org_id);

2481: FND_FILE.put_line( FND_FILE.LOG,'P_FINALIZE_DATA :'|| P_FINALIZE_DATA);
2482: FND_FILE.put_line( FND_FILE.LOG,'P_START_DATE :'|| P_START_DATE);
2483: FND_FILE.put_line( FND_FILE.LOG,'P_END_DATE :'|| P_END_DATE);
2484: END IF;
2485: FND_FILE.put_line( FND_FILE.LOG,'ORG_ID :'|| l_org_id);
2486: IF (P_REV_TEMP_DATA = 'Y') AND (P_VALIDATION_DATA = 'N') AND (P_FINALIZE_DATA = 'N') THEN
2487:
2488: table_name := 'JL_AR_TURN_UPL_T'; -- will goto xml file and print the Temp Table Data output directly
2489:

Line 2502: FND_FILE.put_line( FND_FILE.LOG,'Starting the FINAL_VALIDATION procedure');

2498: table_name := 'JL_AR_TURN_UPL'; -- will do validation for the govt flat file data and shows the valid and invalid records
2499:
2500:
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

Line 2509: FND_FILE.put_line( FND_FILE.LOG,'After the FINAL_VALIDATION procedure');

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');
2510: END IF;
2511:
2512: ELSIF (P_FINALIZE_DATA = 'Y') AND (P_REV_TEMP_DATA = 'N') AND (P_VALIDATION_DATA = 'N') THEN
2513:

Line 2517: FND_FILE.put_line( FND_FILE.LOG,'Starting the VALIDATE_AWT_SETUP procedure');

2513:
2514: table_name := 'JL_AR_TURN_UPL'; -- will do final validation for the govt flat file data and defaulting will happens for missing taxpayerid
2515:
2516: IF p_debug_log = 'Y' THEN
2517: FND_FILE.put_line( FND_FILE.LOG,'Starting the VALIDATE_AWT_SETUP procedure');
2518: END IF;
2519:
2520: VALIDATE_AWT_SETUP; -- will goto VALIDATE_AWT_SETUP package and valiDATE and then print xml data
2521:

Line 2523: FND_FILE.put_line( FND_FILE.LOG,'After the VALIDATE_AWT_SETUP procedure');

2519:
2520: VALIDATE_AWT_SETUP; -- will goto VALIDATE_AWT_SETUP package and valiDATE and then print xml data
2521:
2522: IF p_debug_log = 'Y' THEN
2523: FND_FILE.put_line( FND_FILE.LOG,'After the VALIDATE_AWT_SETUP procedure');
2524: END IF;
2525:
2526: ELSE
2527:

Line 2531: FND_FILE.put_line( FND_FILE.LOG,' ');

2527:
2528: table_name := 'JL_AR_TURN_UPL';
2529:
2530: IF p_debug_log = 'Y' THEN
2531: FND_FILE.put_line( FND_FILE.LOG,' ');
2532: FND_FILE.put_line( FND_FILE.LOG,' ');
2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');
2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2532: FND_FILE.put_line( FND_FILE.LOG,' ');

2528: table_name := 'JL_AR_TURN_UPL';
2529:
2530: IF p_debug_log = 'Y' THEN
2531: FND_FILE.put_line( FND_FILE.LOG,' ');
2532: FND_FILE.put_line( FND_FILE.LOG,' ');
2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');
2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');

Line 2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');

2529:
2530: IF p_debug_log = 'Y' THEN
2531: FND_FILE.put_line( FND_FILE.LOG,' ');
2532: FND_FILE.put_line( FND_FILE.LOG,' ');
2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');
2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2534: FND_FILE.put_line( FND_FILE.LOG,' ');

2530: IF p_debug_log = 'Y' THEN
2531: FND_FILE.put_line( FND_FILE.LOG,' ');
2532: FND_FILE.put_line( FND_FILE.LOG,' ');
2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');
2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2535: FND_FILE.put_line( FND_FILE.LOG,' ');

2531: FND_FILE.put_line( FND_FILE.LOG,' ');
2532: FND_FILE.put_line( FND_FILE.LOG,' ');
2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');
2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');

2532: FND_FILE.put_line( FND_FILE.LOG,' ');
2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');
2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');

Line 2537: FND_FILE.put_line( FND_FILE.LOG,' ');

2533: FND_FILE.put_line( FND_FILE.LOG,'--------------------------------------------------------------------------------------------------------');
2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2538: FND_FILE.put_line( FND_FILE.LOG,' ');

2534: FND_FILE.put_line( FND_FILE.LOG,' ');
2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2539: FND_FILE.put_line( FND_FILE.LOG,' ');

2535: FND_FILE.put_line( FND_FILE.LOG,' ');
2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');

Line 2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');

2536: FND_FILE.put_line( FND_FILE.LOG,' -------------- E R R O R : P A R A M E T E R W R O N G L Y S E L E C T E D -------------');
2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2541: FND_FILE.put_line( FND_FILE.LOG,' ');

2537: FND_FILE.put_line( FND_FILE.LOG,' ');
2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2542: FND_FILE.put_line( FND_FILE.LOG,' ');

2538: FND_FILE.put_line( FND_FILE.LOG,' ');
2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');

Line 2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');

2539: FND_FILE.put_line( FND_FILE.LOG,' ');
2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');

Line 2544: FND_FILE.put_line( FND_FILE.LOG,' ');

2540: FND_FILE.put_line( FND_FILE.LOG,'--------------- PLEASE MAKE SURE TO RUN THE ARGENTINA AWT REPORT WITH VALID PARAMETERS -------------');
2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');

Line 2545: FND_FILE.put_line( FND_FILE.LOG,' ');

2541: FND_FILE.put_line( FND_FILE.LOG,' ');
2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');

Line 2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');

2542: FND_FILE.put_line( FND_FILE.LOG,' ');
2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');

2543: FND_FILE.put_line( FND_FILE.LOG,'------------------------------- VALID PARAMETER SELECTION CRITERIA ---------------------------------');
2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');

2544: FND_FILE.put_line( FND_FILE.LOG,' ');
2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');
2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');

Line 2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');

2545: FND_FILE.put_line( FND_FILE.LOG,' ');
2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');
2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');
2553: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2550: FND_FILE.put_line( FND_FILE.LOG,' ');

2546: FND_FILE.put_line( FND_FILE.LOG,' To Review the Temporary Upload Data (without validation), Enter the Review Temporary Data as YES, Validate Temporary Data as NO, Finalize Data as NO');
2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');
2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');
2553: FND_FILE.put_line( FND_FILE.LOG,' ');
2554: FND_FILE.put_line( FND_FILE.LOG,' ');

Line 2551: FND_FILE.put_line( FND_FILE.LOG,' ');

2547: FND_FILE.put_line( FND_FILE.LOG,' To Validate the Temporary Upload Data, Enter the Review Temporary Data as YES, Validate Temporary Data as YES, Finalize Data as NO');
2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');
2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');
2553: FND_FILE.put_line( FND_FILE.LOG,' ');
2554: FND_FILE.put_line( FND_FILE.LOG,' ');
2555: END IF;

Line 2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');

2548: FND_FILE.put_line( FND_FILE.LOG,' To Finalize the Temporary Upload Data, Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as YES');
2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');
2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');
2553: FND_FILE.put_line( FND_FILE.LOG,' ');
2554: FND_FILE.put_line( FND_FILE.LOG,' ');
2555: END IF;
2556:

Line 2553: FND_FILE.put_line( FND_FILE.LOG,' ');

2549: FND_FILE.put_line( FND_FILE.LOG,' To view only the Valid Data (After validation), Enter the Review Temporary Data as NO, Validate Temporary Data as NO, Finalize Data as NO and select the Responsibility and Dates Appropriately');
2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');
2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');
2553: FND_FILE.put_line( FND_FILE.LOG,' ');
2554: FND_FILE.put_line( FND_FILE.LOG,' ');
2555: END IF;
2556:
2557: END IF;

Line 2554: FND_FILE.put_line( FND_FILE.LOG,' ');

2550: FND_FILE.put_line( FND_FILE.LOG,' ');
2551: FND_FILE.put_line( FND_FILE.LOG,' ');
2552: FND_FILE.put_line( FND_FILE.LOG,'----------------------------------------------------------------------------------------------------------');
2553: FND_FILE.put_line( FND_FILE.LOG,' ');
2554: FND_FILE.put_line( FND_FILE.LOG,' ');
2555: END IF;
2556:
2557: END IF;
2558:

Line 2561: FND_FILE.put_line( FND_FILE.LOG,'Closing the PKG JL_AR_APPLICABLE_TAXES.beforeReport');

2557: END IF;
2558:
2559:
2560: IF p_debug_log = 'Y' THEN
2561: FND_FILE.put_line( FND_FILE.LOG,'Closing the PKG JL_AR_APPLICABLE_TAXES.beforeReport');
2562: END IF;
2563:
2564: IF (P_START_DATE IS NULL) THEN
2565: SELECT MAX(start_DATE) INTO P_START_DATE FROM JL_AR_TURN_UPL;

Line 2572: FND_FILE.put_line( FND_FILE.LOG,'Before Report P_START_DATE :'|| P_START_DATE ||'P_END_DATE :'|| P_END_DATE);

2568: IF (P_END_DATE IS NULL) THEN
2569: SELECT MAX(end_DATE) INTO P_END_DATE FROM JL_AR_TURN_UPL;
2570: END IF;
2571: IF p_debug_log = 'Y' THEN
2572: FND_FILE.put_line( FND_FILE.LOG,'Before Report P_START_DATE :'|| P_START_DATE ||'P_END_DATE :'|| P_END_DATE);
2573: FND_FILE.put_line( FND_FILE.LOG,' ');
2574: FND_FILE.put_line( FND_FILE.LOG,' ');
2575: END IF;
2576:

Line 2573: FND_FILE.put_line( FND_FILE.LOG,' ');

2569: SELECT MAX(end_DATE) INTO P_END_DATE FROM JL_AR_TURN_UPL;
2570: END IF;
2571: IF p_debug_log = 'Y' THEN
2572: FND_FILE.put_line( FND_FILE.LOG,'Before Report P_START_DATE :'|| P_START_DATE ||'P_END_DATE :'|| P_END_DATE);
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

Line 2574: FND_FILE.put_line( FND_FILE.LOG,' ');

2570: END IF;
2571: IF p_debug_log = 'Y' THEN
2572: FND_FILE.put_line( FND_FILE.LOG,'Before Report P_START_DATE :'|| P_START_DATE ||'P_END_DATE :'|| P_END_DATE);
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;