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.ZX_PTP_IMPORT dependencies on FND_LOG

Line 47: G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER(1):= FND_LOG.LEVEL_EXCEPTION;

43:
44: --
45: -- debug parameter constants
46: --
47: G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER(1):= FND_LOG.LEVEL_EXCEPTION;
48: G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER(1):= FND_LOG.LEVEL_PROCEDURE;
49: G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER(1):= FND_LOG.LEVEL_STATEMENT;
50: G_CURRENT_DEBUG_LEVEL_SET NUMBER(5):= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: G_DEBUG_LOG_HEADER VARCHAR2(30):= 'ZX.PLSQL.'||G_PKG_NAME||'.';

Line 48: G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER(1):= FND_LOG.LEVEL_PROCEDURE;

44: --
45: -- debug parameter constants
46: --
47: G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER(1):= FND_LOG.LEVEL_EXCEPTION;
48: G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER(1):= FND_LOG.LEVEL_PROCEDURE;
49: G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER(1):= FND_LOG.LEVEL_STATEMENT;
50: G_CURRENT_DEBUG_LEVEL_SET NUMBER(5):= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: G_DEBUG_LOG_HEADER VARCHAR2(30):= 'ZX.PLSQL.'||G_PKG_NAME||'.';
52: G_DEBUG_STATEMENT VARCHAR2(2000);

Line 49: G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER(1):= FND_LOG.LEVEL_STATEMENT;

45: -- debug parameter constants
46: --
47: G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER(1):= FND_LOG.LEVEL_EXCEPTION;
48: G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER(1):= FND_LOG.LEVEL_PROCEDURE;
49: G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER(1):= FND_LOG.LEVEL_STATEMENT;
50: G_CURRENT_DEBUG_LEVEL_SET NUMBER(5):= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: G_DEBUG_LOG_HEADER VARCHAR2(30):= 'ZX.PLSQL.'||G_PKG_NAME||'.';
52: G_DEBUG_STATEMENT VARCHAR2(2000);
53:

Line 50: G_CURRENT_DEBUG_LEVEL_SET NUMBER(5):= FND_LOG.G_CURRENT_RUNTIME_LEVEL;

46: --
47: G_DEBUG_LEVEL_EXCEPTION CONSTANT NUMBER(1):= FND_LOG.LEVEL_EXCEPTION;
48: G_DEBUG_LEVEL_PROCEDURE CONSTANT NUMBER(1):= FND_LOG.LEVEL_PROCEDURE;
49: G_DEBUG_LEVEL_STATEMENT CONSTANT NUMBER(1):= FND_LOG.LEVEL_STATEMENT;
50: G_CURRENT_DEBUG_LEVEL_SET NUMBER(5):= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: G_DEBUG_LOG_HEADER VARCHAR2(30):= 'ZX.PLSQL.'||G_PKG_NAME||'.';
52: G_DEBUG_STATEMENT VARCHAR2(2000);
53:
54: G_RS_IN_PROCESS NUMBER(2);

Line 194: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetGlobals','SetGlobals(+)');

190: PROCEDURE SetGlobals IS
191: BEGIN
192:
193: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
194: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetGlobals','SetGlobals(+)');
195: END IF;
196:
197: --
198: -- user values

Line 233: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetGlobals','SetGlobals(-)');

229: G_CONC_RET_STS_ERROR := FND_API.G_RET_STS_ERROR;
230: G_CONC_RET_STS_UNEXP_ERROR := FND_API.G_RET_STS_UNEXP_ERROR;
231:
232: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
233: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetGlobals','SetGlobals(-)');
234: END IF;
235:
236: EXCEPTION
237: WHEN OTHERS THEN

Line 242: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'SetGlobals',' Unable to intialize Globals'||SQLERRM);

238: log_now (p_log_level => FND_FILE.LOG
239: ,p_message => ' Unable to intialize Globals'||SQLERRM
240: );
241: IF (G_DEBUG_LEVEL_EXCEPTION >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
242: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'SetGlobals',' Unable to intialize Globals'||SQLERRM);
243: END IF;
244: RAISE;
245: END SetGlobals;
246:

Line 256: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetProcessConstants','SetProcessConstants(+)');

252: PROCEDURE SetProcessConstants IS
253: BEGIN
254:
255: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
256: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetProcessConstants','SetProcessConstants(+)');
257: END IF;
258:
259: --
260: -- record status values

Line 352: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetProcessConstants','SetProcessConstants(-)');

348: G_ES_EXE_INV_ITM_INVALID := POWER(2,20);
349: G_ES_EXE_TAX_AUT_INVALID := POWER(2,21);
350:
351: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
352: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SetProcessConstants','SetProcessConstants(-)');
353: END IF;
354:
355: EXCEPTION
356: WHEN OTHERS THEN

Line 410: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_PROC_NAME||'(+)');

406: log_now (p_log_level => FND_FILE.LOG
407: ,p_message => G_PROC_NAME||'(+)'
408: );
409: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
410: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_PROC_NAME||'(+)');
411: END IF;
412:
413: SetGlobals();
414: SetProcessConstants();

Line 436: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);

432: END IF;
433:
434: G_DEBUG_STATEMENT:='Validated mandatory API parameters';
435: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
436: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);
437: END IF;
438:
439: -- create save point
440: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 453: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);

449: log_now (p_log_level => FND_FILE.LOG
450: ,p_message => G_DEBUG_STATEMENT
451: );
452: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
453: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);
454: END IF;
455:
456:
457: DELETE zx_registrations_int

Line 466: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);

462: log_now (p_log_level => FND_FILE.LOG
463: ,p_message => G_DEBUG_STATEMENT
464: );
465: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
466: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);
467: END IF;
468:
469: DELETE zx_exemptions_int
470: WHERE request_id = G_REQUEST_ID

Line 478: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);

474: log_now (p_log_level => FND_FILE.LOG
475: ,p_message => G_DEBUG_STATEMENT
476: );
477: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
478: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);
479: END IF;
480:
481: DELETE zx_report_codes_assoc_int
482: WHERE request_id = G_REQUEST_ID

Line 490: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);

486: log_now (p_log_level => FND_FILE.LOG
487: ,p_message => G_DEBUG_STATEMENT
488: );
489: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
490: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_DEBUG_STATEMENT);
491: END IF;
492:
493: IF FND_API.TO_BOOLEAN(p_commit) THEN
494: COMMIT WORK;

Line 501: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_PROC_NAME||'(-)');

497: log_now (p_log_level => FND_FILE.LOG
498: ,p_message => G_PROC_NAME||'(-)'
499: );
500: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
501: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||G_PROC_NAME,G_PROC_NAME||'(-)');
502: END IF;
503:
504:
505: EXCEPTION

Line 525: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables','ResetRecStatusForChildTables(+)');

521: PROCEDURE ResetRecStatusForChildTables IS
522: BEGIN
523:
524: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
525: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables','ResetRecStatusForChildTables(+)');
526: END IF;
527:
528: UPDATE zx_party_tax_profile_int ptp_int
529: SET record_status = NULL

Line 542: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);

538: );
539:
540: G_DEBUG_STATEMENT:='Updated Record Status for '||SQL%ROWCOUNT||' records from '||G_INTF_PTP_TABLE_NAME;
541: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
542: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);
543: END IF;
544:
545: UPDATE zx_registrations_int reg_int
546: SET record_status = NULL

Line 559: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);

555: );
556:
557: G_DEBUG_STATEMENT:='Updated Record Status for '||SQL%ROWCOUNT||' records from '||G_INTF_REG_TABLE_NAME;
558: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
559: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);
560: END IF;
561:
562: UPDATE zx_exemptions_int exe_int
563: SET record_status = NULL

Line 576: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);

572: );
573:
574: G_DEBUG_STATEMENT:='Updated Record Status for '||SQL%ROWCOUNT||' records from '||G_INTF_EXE_TABLE_NAME;
575: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
576: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);
577: END IF;
578:
579: UPDATE zx_report_codes_assoc_int rca_int
580: SET record_status = NULL

Line 593: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);

589: );
590:
591: G_DEBUG_STATEMENT:='Updated Record Status for '||SQL%ROWCOUNT||' records from '||G_INTF_RCA_TABLE_NAME;
592: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
593: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);
594: END IF;
595:
596: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
597: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables','ResetRecStatusForChildTables(-)');

Line 597: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables','ResetRecStatusForChildTables(-)');

593: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables',G_DEBUG_STATEMENT);
594: END IF;
595:
596: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
597: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ResetRecStatusForChildTables','ResetRecStatusForChildTables(-)');
598: END IF;
599:
600: EXCEPTION
601: WHEN OTHERS THEN

Line 660: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_PTP','IMPORT_PTP(+)');

656: --
657: ---------------------------------------
658:
659: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
660: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_PTP','IMPORT_PTP(+)');
661: END IF;
662:
663: x_return_status := G_CONC_RET_STS_SUCCESS;
664:

Line 689: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

685: RAISE NO_ROWS_IN_INTF_TABLE;
686: END;
687: G_DEBUG_STATEMENT:='Validate Mode : There are records to Process in PTP';
688: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
689: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
690: END IF;
691:
692: END IF;
693:

Line 713: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

709: RAISE NO_ROWS_IN_INTF_TABLE;
710: END;
711: G_DEBUG_STATEMENT:='Insert Mode : There are records to Process in PTP';
712: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
713: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
714: END IF;
715: END IF;
716:
717: -- collect stats on the tables

Line 739: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

735: ,tabname => 'ZX_ERRORS_INT');
736:
737: G_DEBUG_STATEMENT:='Completed Gathering Stats on interface tables';
738: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
739: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
740: END IF;
741:
742: END IF;
743:

Line 753: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

749: ProcessPtyTxProfileRecord();
750:
751: G_DEBUG_STATEMENT:='Completed Processing Party Tax Profile Records';
752: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
753: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
754: END IF;
755:
756: END IF;
757:

Line 786: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

782: END;
783:
784: G_DEBUG_STATEMENT:='Completed Processing Registration Records';
785: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
786: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
787: END IF;
788:
789: END IF;
790:

Line 802: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

798: END IF;
799:
800: G_DEBUG_STATEMENT:='Completed Sync Default Registration Number onto PTP';
801: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
802: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
803: END IF;
804:
805: END IF;
806:

Line 817: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

813: DupTRNValidation();
814:
815: G_DEBUG_STATEMENT:='Completed Duplicate Tax Registration Validation';
816: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
817: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
818: END IF;
819:
820: END IF;
821:

Line 850: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

846: END;
847:
848: G_DEBUG_STATEMENT:='Completed Exemptions record processing';
849: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
850: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
851: END IF;
852:
853: END IF;
854:

Line 883: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

879: END;
880:
881: G_DEBUG_STATEMENT:='Completed Reporting Code Association record processing';
882: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
883: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
884: END IF;
885:
886: END IF;
887:

Line 897: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

893: LogErrorToTable();
894:
895: G_DEBUG_STATEMENT:='Populated Errors onto ZX_ERRORS_INT record processing';
896: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
897: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
898: END IF;
899:
900: END IF;
901:

Line 911: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

907: ResetRecStatusForChildTables();
908:
909: G_DEBUG_STATEMENT:='Populated Errors onto ZX_ERRORS_INT record processing';
910: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
911: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
912: END IF;
913:
914: END IF;
915: -------------------------------------

Line 924: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

920: PopulateProductionTables();
921:
922: G_DEBUG_STATEMENT:='Populated all production tables';
923: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
924: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
925: END IF;
926:
927: END IF;
928:

Line 935: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);

931: COMMIT WORK;
932:
933: G_DEBUG_STATEMENT:='All Data Committed';
934: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
935: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_PTP',G_DEBUG_STATEMENT);
936: END IF;
937:
938: END IF;
939:

Line 941: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_PTP','IMPORT_PTP(-)');

937:
938: END IF;
939:
940: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
941: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_PTP','IMPORT_PTP(-)');
942: END IF;
943:
944: EXCEPTION
945: WHEN NO_ROWS_IN_INTF_TABLE THEN

Line 988: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord','ProcessPtyTxProfileRecord(+)');

984:
985: BEGIN
986:
987: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
988: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord','ProcessPtyTxProfileRecord(+)');
989: END IF;
990:
991: l_date1 := SYSDATE;
992:

Line 1009: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);

1005: NVL(G_BATCH_ID,NVL(batch_id,G_MISS_NUM));
1006:
1007: G_DEBUG_STATEMENT:='Populated default values onto '||SQL%ROWCOUNT||' records';
1008: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1009: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);
1010: END IF;
1011:
1012: -------------------------
1013: -- Check Mandatory Paramters

Line 1026: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);

1022: AND intf_party_site_reference IS NULL;
1023:
1024: G_DEBUG_STATEMENT:='Mandatory Parameters not populated onto '||SQL%ROWCOUNT||' records';
1025: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1026: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);
1027: END IF;
1028:
1029: -------------------------
1030: -- Duplicate records checking

Line 1053: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);

1049: );
1050:
1051: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Duplicate records found';
1052: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1053: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);
1054: END IF;
1055:
1056: -------------------------
1057: -- Value to Id Conversion

Line 1066: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);

1062: l_date3 := SYSDATE;
1063:
1064: G_DEBUG_STATEMENT:='Completed Value to Id Conversion for PTP';
1065: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1066: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);
1067: END IF;
1068:
1069: ------------------
1070: -- TRN Validations

Line 1104: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);

1100: l_date4 := SYSDATE;
1101:
1102: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid TRN found';
1103: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1104: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord',G_DEBUG_STATEMENT);
1105: END IF;
1106:
1107: ---------------------------
1108: -- Record level validations

Line 1143: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord','ProcessPtyTxProfileRecord(-)');

1139: ,p_message => '+--------------------------------------------------------------------'
1140: );
1141:
1142: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1143: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessPtyTxProfileRecord','ProcessPtyTxProfileRecord(-)');
1144: END IF;
1145:
1146: EXCEPTION
1147: WHEN OTHERS THEN

Line 1163: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion','PtpValueToIdConversion(+)');

1159: PROCEDURE PtpValueToIdConversion IS
1160: BEGIN
1161:
1162: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1163: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion','PtpValueToIdConversion(+)');
1164: END IF;
1165:
1166: UPDATE zx_party_tax_profile_int
1167: SET error_number = error_number + G_ES_PTP_TRANS_TYPE_INVALID

Line 1174: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1170: AND dml_type <> 'CREATE';
1171:
1172: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid dml_type found';
1173: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1174: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1175: END IF;
1176:
1177: UPDATE zx_party_tax_profile_int
1178: SET error_number = error_number + G_ES_PTP_PARTY_TYPE_INVALID

Line 1185: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1181: AND party_type_code NOT IN ('THIRD_PARTY','THIRD_PARTY_SITE');
1182:
1183: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid party_type_code found';
1184: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1185: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1186: END IF;
1187:
1188: -- value to id conversion for party_id Only for DML TYpe = 'UPDATE'
1189: -- written for future use at the time of creation

Line 1218: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1214: );
1215:
1216: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid party_id found';
1217: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1218: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1219: END IF;
1220:
1221: UPDATE zx_party_tax_profile_int intf
1222: SET party_id = CASE WHEN party_id IS NULL AND party_name IS NOT NULL

Line 1288: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1284: AND request_id = G_REQUEST_ID;
1285:
1286: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid country found';
1287: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1288: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1289: END IF;
1290:
1291: -- value to id conversion for registration_type_code
1292: UPDATE zx_party_tax_profile_int ptp_int

Line 1306: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1302: AND country_name IS NOT NULL;
1303:
1304: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with country_code';
1305: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1306: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1307: END IF;
1308:
1309: -- validating the fields registration_type_code and registration_type_name
1310: UPDATE zx_party_tax_profile_int ptp_int

Line 1343: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1339: AND request_id = G_REQUEST_ID;
1340:
1341: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid registration type found';
1342: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1343: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1344: END IF;
1345:
1346: -- value to id conversion for registration_type_code
1347: UPDATE zx_party_tax_profile_int ptp_int

Line 1365: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1361: AND ptp_int.registration_type_name IS NOT NULL;
1362:
1363: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with registration_type_code';
1364: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1365: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1366: END IF;
1367:
1368: -- validating the fields rounding_level_code and rounding_level_name
1369: UPDATE zx_party_tax_profile_int ptp_int

Line 1402: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1398: AND request_id = G_REQUEST_ID;
1399:
1400: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid rounding level found';
1401: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1402: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1403: END IF;
1404:
1405: -- value to id conversion for rounding_level_code
1406: UPDATE zx_party_tax_profile_int ptp_int

Line 1425: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1421: AND rounding_level_name IS NOT NULL;
1422:
1423: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with rounding_level_code';
1424: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1425: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1426: END IF;
1427:
1428: -- validating the fields rounding_rule_code and rounding_rule_name
1429: UPDATE zx_party_tax_profile_int ptp_int

Line 1462: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1458: AND request_id = G_REQUEST_ID;
1459:
1460: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid rounding rule found';
1461: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1462: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1463: END IF;
1464:
1465: -- value to id conversion for rounding_rule_code
1466: UPDATE zx_party_tax_profile_int ptp_int

Line 1484: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1480: AND rounding_rule_name IS NOT NULL;
1481:
1482: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with rounding_rule_code';
1483: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1484: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1485: END IF;
1486:
1487: -- validating the fields tax_classification_code and tax_classification_name
1488: UPDATE zx_party_tax_profile_int ptp_int

Line 1534: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1530: AND request_id = G_REQUEST_ID;
1531:
1532: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid Tax Classification found';
1533: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1534: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1535: END IF;
1536:
1537: -- value to id conversion for rounding_rule_code
1538: UPDATE zx_party_tax_profile_int ptp_int

Line 1562: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);

1558: AND tax_classification_name IS NOT NULL;
1559:
1560: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with Tax Classification code';
1561: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1562: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1563: END IF;
1564:
1565: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1566: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion','PtpValueToIdConversion(-)');

Line 1566: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion','PtpValueToIdConversion(-)');

1562: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion',G_DEBUG_STATEMENT);
1563: END IF;
1564:
1565: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1566: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PtpValueToIdConversion','PtpValueToIdConversion(-)');
1567: END IF;
1568:
1569: EXCEPTION
1570: WHEN OTHERS THEN

Line 1592: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'TRNValidation','TRNValidation(+)');

1588:
1589: BEGIN
1590:
1591: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1592: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'TRNValidation','TRNValidation(+)');
1593: END IF;
1594:
1595:
1596: l_const_sql :=

Line 1613: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1609: l_dynamic_sql := l_const_sql||
1610: q'# AND REGEXP_LIKE(registration_number,'^[[:digit:]]{9}$') #' ;
1611:
1612: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1613: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1614: END IF;
1615:
1616: EXECUTE IMMEDIATE l_dynamic_sql
1617: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1630: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1626: OR ( REGEXP_LIKE(registration_number,'^[[:digit:]]{9,12}$')
1627: AND NOT REGEXP_LIKE(registration_number,'^[[:digit:]]{11}$'))) #' ;
1628:
1629: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1630: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1631: END IF;
1632:
1633: EXECUTE IMMEDIATE l_dynamic_sql
1634: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1645: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1641: l_dynamic_sql := l_const_sql||
1642: q'# AND REGEXP_LIKE(registration_number,'^(SI)?[[:digit:]]{8}$') #' ;
1643:
1644: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1645: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1646: END IF;
1647:
1648: EXECUTE IMMEDIATE l_dynamic_sql
1649: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1660: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1656: l_dynamic_sql := l_const_sql||
1657: q'# AND REGEXP_LIKE(registration_number,'^(SE)?[[:digit:]]{10}(01)$') #' ;
1658:
1659: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1660: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1661: END IF;
1662:
1663: EXECUTE IMMEDIATE l_dynamic_sql
1664: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1675: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1671: l_dynamic_sql := l_const_sql||
1672: q'# AND LENGTH(registration_number) IN (9,10,12) #' ;
1673:
1674: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1675: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1676: END IF;
1677:
1678: EXECUTE IMMEDIATE l_dynamic_sql
1679: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1697: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1693: ELSE :G_MISS_NUM END
1694: ) = substr(registration_number,11,1) #' ;
1695:
1696: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1697: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1698: END IF;
1699:
1700: EXECUTE IMMEDIATE l_dynamic_sql
1701: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1721: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1717: )
1718: ) #' ;
1719:
1720: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1721: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1722: END IF;
1723:
1724: EXECUTE IMMEDIATE l_dynamic_sql
1725: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1742: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1738: ELSE :G_MISS_NUM END
1739: ) = substr(registration_number,11,1) #' ;
1740:
1741: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1742: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1743: END IF;
1744:
1745: EXECUTE IMMEDIATE l_dynamic_sql
1746: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1757: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1753: l_dynamic_sql := l_const_sql||
1754: q'# AND REGEXP_LIKE(registration_number,'^(MT)?[[:digit:]]{8}$') #' ;
1755:
1756: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1757: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1758: END IF;
1759:
1760: EXECUTE IMMEDIATE l_dynamic_sql
1761: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1772: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1768: l_dynamic_sql := l_const_sql||
1769: q'# AND REGEXP_LIKE(registration_number,'^(LV)?[[:digit:]]{11}$') #' ;
1770:
1771: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1772: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1773: END IF;
1774:
1775: EXECUTE IMMEDIATE l_dynamic_sql
1776: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1786: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1782: l_dynamic_sql := l_const_sql||
1783: q'# AND REGEXP_LIKE(registration_number,'^(LU)[[:digit:]]{8}$') #' ;
1784:
1785: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1786: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1787: END IF;
1788:
1789: EXECUTE IMMEDIATE l_dynamic_sql
1790: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1805: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1801: REGEXP_LIKE(registration_number,'^(LT)?[[:digit:]]{12}$')
1802: ) #' ;
1803:
1804: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1805: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1806: END IF;
1807:
1808: EXECUTE IMMEDIATE l_dynamic_sql
1809: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1828: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1824: substr(registration_number,5,1) + substr(registration_number,7,1) + substr(registration_number,9,1)
1825: ELSE :G_MISS_NUM END) = Decode(substr(registration_number,11,1),0,0,10-substr(registration_number,11,1)) #' ;
1826:
1827: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1828: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1829: END IF;
1830:
1831: EXECUTE IMMEDIATE l_dynamic_sql
1832: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1847: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1843: REGEXP_LIKE(registration_number,'^(IE)((..[0-9]{5}))[A-HJ-NP-Z]$')
1844: ) #' ;
1845:
1846: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1847: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1848: END IF;
1849:
1850: EXECUTE IMMEDIATE l_dynamic_sql
1851: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1872: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1868: ELSE :G_MISS_NUM END
1869: ) = 0 #' ;
1870:
1871: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1872: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1873: END IF;
1874:
1875: EXECUTE IMMEDIATE l_dynamic_sql
1876: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1896: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1892: (substr(registration_number,10,1) * power(2,1))),11),10)
1893: ELSE :G_MISS_NUM END) = substr(registration_number,11,1) #' ;
1894:
1895: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1896: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1897: END IF;
1898:
1899: EXECUTE IMMEDIATE l_dynamic_sql
1900: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1916: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1912: AND substr(registration_number,5) BETWEEN 500 AND 999)
1913: ) #' ;
1914:
1915: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1916: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1917: END IF;
1918:
1919: EXECUTE IMMEDIATE l_dynamic_sql
1920: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1937: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1933: ELSE :G_MISS_NUM END
1934: ) #' ;
1935:
1936: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1937: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1938: END IF;
1939:
1940: EXECUTE IMMEDIATE l_dynamic_sql
1941: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1952: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1948: l_dynamic_sql := l_const_sql||
1949: q'# AND REGEXP_LIKE(registration_number,'^(FR)[A-HJ-NP-Z0-9]{2}[[:digit:]]{9}$') #' ;
1950:
1951: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1952: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1953: END IF;
1954:
1955: EXECUTE IMMEDIATE l_dynamic_sql
1956: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1967: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1963: l_dynamic_sql := l_const_sql||
1964: q'# AND REGEXP_LIKE(registration_number,'^(FI)[[:digit:]]{8}$') #' ;
1965:
1966: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1967: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1968: END IF;
1969:
1970: EXECUTE IMMEDIATE l_dynamic_sql
1971: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1983: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1979: l_dynamic_sql := l_const_sql||
1980: q'# AND (REGEXP_LIKE(registration_number,'^(EST)[.]*$') OR REGEXP_LIKE(registration_number,'^(ESN)[.]*[A-Za-z]$')) #' ;
1981:
1982: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1983: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1984: END IF;
1985:
1986: EXECUTE IMMEDIATE l_dynamic_sql
1987: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 1997: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

1993: substr('A-HJ-NP-TV-Z',mod(substr(registration_number,3,length(registration_number)-3),23) + 1,1)
1994: ELSE :G_MISS_CHAR END) = substr(registration_number, -1,1) #' ;
1995:
1996: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
1997: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
1998: END IF;
1999:
2000: EXECUTE IMMEDIATE l_dynamic_sql
2001: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2011: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2007: substr('TRWAGMYFPDXBNJZSQVHLCKE',mod(Decode(SubStr(registration_number,3,1),'Y',1,2)||SubStr(registration_number,4,length(registration_number)-4),23) + 1,1)
2008: ELSE :G_MISS_CHAR END) = substr(registration_number, -1,1) #' ;
2009:
2010: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2011: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2012: END IF;
2013:
2014: EXECUTE IMMEDIATE l_dynamic_sql
2015: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2025: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2021: substr('TRWAGMYFPDXBNJZSQVHLCKE',mod(substr(registration_number,4,length(registration_number)-4),23) + 1,1)
2022: ELSE :G_MISS_CHAR END) = substr(registration_number, -1,1) #' ;
2023:
2024: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2025: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2026: END IF;
2027:
2028: EXECUTE IMMEDIATE l_dynamic_sql
2029: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2058: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2054: ELSE :G_MISS_CHAR
2055: END) = substr(registration_number, -1,1) #' ;
2056:
2057: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2058: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2059: END IF;
2060:
2061: EXECUTE IMMEDIATE l_dynamic_sql
2062: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2091: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2087: ELSE :G_MISS_NUM
2088: END) = substr(registration_number, -1,1) #' ;
2089:
2090: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2091: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2092: END IF;
2093:
2094: EXECUTE IMMEDIATE l_dynamic_sql
2095: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2106: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2102: l_dynamic_sql := l_const_sql||
2103: q'# AND REGEXP_LIKE(registration_number,'^(EE)[[:digit:]]{9}$') #' ;
2104:
2105: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2106: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2107: END IF;
2108:
2109: EXECUTE IMMEDIATE l_dynamic_sql
2110: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2121: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2117: l_dynamic_sql := l_const_sql||
2118: q'# AND REGEXP_LIKE(registration_number,'^(DK)[[:digit:]]{8}$') #' ;
2119:
2120: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2121: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2122: END IF;
2123:
2124: EXECUTE IMMEDIATE l_dynamic_sql
2125: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2136: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2132: l_dynamic_sql := l_const_sql||
2133: q'# AND REGEXP_LIKE(registration_number,'^(DE)[[:digit:]]{9}$') #' ;
2134:
2135: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2136: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2137: END IF;
2138:
2139: EXECUTE IMMEDIATE l_dynamic_sql
2140: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2151: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2147: l_dynamic_sql := l_const_sql||
2148: q'# AND REGEXP_LIKE(registration_number,'^(CY)[[:digit:]]{8}[A-Z]$') #' ;
2149:
2150: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2151: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2152: END IF;
2153:
2154: EXECUTE IMMEDIATE l_dynamic_sql
2155: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2189: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2185: AND prog_int_num1 <> :G_PROG_INT_VAL'||
2186: q'# AND REGEXP_LIKE(registration_number,'^[[:digit:]]{0,16}$') #';
2187:
2188: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2189: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2190: END IF;
2191:
2192: EXECUTE IMMEDIATE l_dynamic_sql
2193: USING G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2210: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2206: AND prog_int_num1 <> :G_PROG_INT_VAL'||
2207: q'# AND REGEXP_LIKE(registration_number,'^[[:digit:]]{0,16}$') #';
2208:
2209: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2210: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2211: END IF;
2212:
2213: EXECUTE IMMEDIATE l_dynamic_sql
2214: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2238: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2234: nvl(TO_NUMBER(SUBSTR(registration_number,-13,1)),0) *7),11))
2235: ELSE :G_MISS_NUM END) = Decode(substr(registration_number,-1,1),'K',10,'0',11,substr(registration_number,-1,1)) #' ;
2236:
2237: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2238: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2239: END IF;
2240:
2241: EXECUTE IMMEDIATE l_dynamic_sql
2242: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2294: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2290: )
2291: #' ;
2292:
2293: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2294: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2295: END IF;
2296:
2297: EXECUTE IMMEDIATE l_dynamic_sql
2298: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2321: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2317: (TO_NUMBER(SUBSTR(registration_number,1,1))) *5),11))
2318: ELSE :G_MISS_NUM END) = Decode(TO_NUMBER(SUBSTR(registration_number,11,1)),9,10,11,0,TO_NUMBER(SUBSTR(registration_number,11,1))) #' ;
2319:
2320: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2321: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2322: END IF;
2323:
2324: EXECUTE IMMEDIATE l_dynamic_sql
2325: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2346: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2342: (TO_NUMBER(SUBSTR(registration_number,1,1))) *5),11))
2343: ELSE :G_MISS_NUM END) = Decode(TO_NUMBER(SUBSTR(registration_number,9,1)),9,10,11,0,TO_NUMBER(SUBSTR(registration_number,9,1))) #' ;
2344:
2345: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2346: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2347: END IF;
2348:
2349: EXECUTE IMMEDIATE l_dynamic_sql
2350: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2367: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2363: substr(registration_number,8,1) + substr(registration_number,10,1)+4)-1,1)
2364: ELSE :G_MISS_CHAR END) = substr(registration_number,11,1) #' ;
2365:
2366: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2367: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2368: END IF;
2369:
2370: EXECUTE IMMEDIATE l_dynamic_sql
2371: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2384: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2380: (97-mod(substr(registration_number,2,7),97))
2381: ELSE :G_MISS_NUM END) = substr(registration_number,9,2) #' ;
2382:
2383: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2384: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2385: END IF;
2386:
2387: EXECUTE IMMEDIATE l_dynamic_sql
2388: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2397: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2393: (97-mod(substr(registration_number,3,7),97))
2394: ELSE :G_MISS_NUM END) = substr(registration_number,10,2) #' ;
2395:
2396: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2397: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2398: END IF;
2399:
2400: EXECUTE IMMEDIATE l_dynamic_sql
2401: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2410: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2406: (97-mod(substr(registration_number,3,7),97))
2407: ELSE :G_MISS_NUM END) = substr(registration_number,11,2) #' ;
2408:
2409: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2410: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2411: END IF;
2412:
2413: EXECUTE IMMEDIATE l_dynamic_sql
2414: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2425: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2421: l_dynamic_sql := l_const_sql||
2422: q'# AND NVL(REGISTRATION_TYPE_CODE,'CNPJ') = 'OTHERS' #' ;
2423:
2424: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2425: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2426: END IF;
2427:
2428: EXECUTE IMMEDIATE l_dynamic_sql
2429: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2464: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2460: q'# AND NVL(REGISTRATION_TYPE_CODE,'CNPJ') = 'CPF'
2461: AND REGEXP_LIKE(REGISTRATION_NUMBER,'^(0000)*[[:digit:]]{11}$') #' ;
2462:
2463: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2464: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2465: END IF;
2466:
2467: EXECUTE IMMEDIATE l_dynamic_sql
2468: USING G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2505: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2501: to_number(substr(registration_number,1,1)) * 11),11)))),1,1)
2502: = substr(registration_number,-1,1) #' ;
2503:
2504: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2505: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2506: END IF;
2507:
2508: EXECUTE IMMEDIATE l_dynamic_sql
2509: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2550: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2546: q'# AND NVL(REGISTRATION_TYPE_CODE,'CNPJ') = 'CNPJ'
2547: AND REGEXP_LIKE(registration_number,'^[[:digit:]]?[[:digit:]]{14}$') #' ;
2548:
2549: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2550: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2551: END IF;
2552:
2553: EXECUTE IMMEDIATE l_dynamic_sql
2554: USING G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2598: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);

2594: to_number(substr(registration_number,-14,1)) * 6),11)))),1,1)
2595: = substr(registration_number,-1,1) #' ;
2596:
2597: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2598: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'TRNValidation',L_DYNAMIC_SQL);
2599: END IF;
2600:
2601: EXECUTE IMMEDIATE l_dynamic_sql
2602: USING G_PROG_INT_VAL,G_REQUEST_ID,G_RS_IN_PROCESS,

Line 2608: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'TRNValidation','TRNValidation(-)');

2604:
2605: END IF;
2606:
2607: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2608: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'TRNValidation','TRNValidation(-)');
2609: END IF;
2610:
2611: EXCEPTION
2612: WHEN OTHERS THEN

Line 2650: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord','ProcessRegistrationRecord(+)');

2646:
2647: l_date1 := SYSDATE;
2648:
2649: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2650: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord','ProcessRegistrationRecord(+)');
2651: END IF;
2652:
2653: -------------------------
2654: -- Populate default values

Line 2669: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2665: NVL(G_BATCH_ID,NVL(batch_id,G_MISS_NUM));
2666:
2667: G_DEBUG_STATEMENT:='Populated default values onto '||SQL%ROWCOUNT||' records';
2668: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2669: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2670: END IF;
2671:
2672: -------------------------
2673: -- Check Mandatory Paramters

Line 2684: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2680: AND NVL(tax_regime_code,tax_regime_name) IS NULL;
2681:
2682: G_DEBUG_STATEMENT:='Mandatory Parameters not populated for '||SQL%ROWCOUNT||' records';
2683: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2684: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2685: END IF;
2686:
2687: -------------------------
2688: -- Duplicate records checking

Line 2721: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2717: );
2718:
2719: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' duplicate records exists';
2720: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2721: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2722: END IF;
2723:
2724: -------------------------
2725: -- Value to Id Conversion

Line 2734: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2730: l_date3 := SYSDATE;
2731:
2732: G_DEBUG_STATEMENT:= 'Value to Id Conversion completed for reg records';
2733: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2734: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2735: END IF;
2736:
2737: -------------------------
2738: -- Record level validations

Line 2774: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2770: );
2771:
2772: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Registrations with overlapping date ranges.';
2773: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2774: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2775: END IF;
2776:
2777: -----------------
2778: -- TRN Validation

Line 2822: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2818: AND record_status = G_RS_IN_PROCESS;
2819:
2820: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records exists with invalid TRN';
2821: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2822: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2823: END IF;
2824:
2825: l_date4 := SYSDATE;
2826:

Line 2852: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2848: );
2849:
2850: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records exists with multiple default_registration_flag defined for a ptp';
2851: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2852: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2853: END IF;
2854:
2855: -- Validation to check when REGISTRATION_STATUS_CODE = 'REGISTERED'
2856: -- and REGISTRATION_SOURCE_CODE = 'EXPLICIT', tax authority is required

Line 2868: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2864: AND tax_authority_id IS NULL;
2865:
2866: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records exists with Tax Authority req Check';
2867: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2868: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2869: END IF;
2870:
2871:
2872: -------------------------

Line 2893: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);

2889: AND reg_int.intf_ptp_reference = ptp_int.intf_ptp_reference);
2890:
2891: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' PTP records updated with NULL record_status';
2892: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2893: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord',G_DEBUG_STATEMENT);
2894: END IF;
2895:
2896:
2897: l_date5 := SYSDATE;

Line 2919: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord','ProcessRegistrationRecord(-)');

2915: ,p_message => '+--------------------------------------------------------------------'
2916: );
2917:
2918: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2919: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRegistrationRecord','ProcessRegistrationRecord(-)');
2920: END IF;
2921:
2922: EXCEPTION
2923: WHEN OTHERS THEN

Line 2944: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'RegValueToIdConversion','RegValueToIdConversion(+)');

2940: --
2941: BEGIN
2942:
2943: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2944: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'RegValueToIdConversion','RegValueToIdConversion(+)');
2945: END IF;
2946:
2947: -- Records with invalid dml_type
2948: UPDATE zx_registrations_int

Line 2956: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

2952: AND dml_type <> 'CREATE';
2953:
2954: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid dml_type';
2955: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2956: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
2957: END IF;
2958:
2959: -- Validate the fields effective_to and effective_from
2960: UPDATE zx_registrations_int

Line 2969: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

2965: AND effective_to < effective_from;
2966:
2967: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid date ';
2968: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
2969: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
2970: END IF;
2971:
2972: -- validating the fields registration_type_code and registration_type_name
2973: UPDATE zx_registrations_int reg_int

Line 3006: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3002: AND request_id = G_REQUEST_ID;
3003:
3004: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid registration_type ';
3005: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3006: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3007: END IF;
3008:
3009: -- value to id conversion for registration_type_code
3010: UPDATE zx_registrations_int reg_int

Line 3028: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3024: AND reg_int.REGISTRATION_TYPE_NAME IS NOT NULL;
3025:
3026: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid registration_type_code ';
3027: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3028: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3029: END IF;
3030:
3031: -- validating the fields registration_status_code and registration_status_name
3032: UPDATE zx_registrations_int reg_int

Line 3065: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3061: AND request_id = G_REQUEST_ID;
3062:
3063: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid registration_status ';
3064: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3065: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3066: END IF;
3067:
3068: -- value to id conversion for registration_status_code
3069: UPDATE zx_registrations_int reg_int

Line 3087: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3083: AND reg_int.registration_status_name IS NOT NULL;
3084:
3085: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid registration_status_code ';
3086: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3087: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3088: END IF;
3089:
3090: -- validating the fields registration_source_code and registration_source_name
3091: UPDATE zx_registrations_int reg_int

Line 3124: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3120: AND request_id = G_REQUEST_ID;
3121:
3122: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid registration_source ';
3123: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3124: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3125: END IF;
3126:
3127: -- value to id conversion for registration_source_code
3128: UPDATE zx_registrations_int reg_int

Line 3146: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3142: AND registration_source_name IS NOT NULL;
3143:
3144: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid registration_source_code ';
3145: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3146: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3147: END IF;
3148:
3149: -- validating the fields registration_reason_code and registration_reason_name
3150: UPDATE zx_registrations_int reg_int

Line 3183: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3179: AND request_id = G_REQUEST_ID;
3180:
3181: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid registration_reason ';
3182: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3183: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3184: END IF;
3185:
3186: -- value to id conversion for registration_reason_code
3187: UPDATE zx_registrations_int reg_int

Line 3205: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3201: AND reg_int.registration_reason_name IS NOT NULL;
3202:
3203: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid registration_reason_code ';
3204: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3205: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3206: END IF;
3207:
3208: -- validating the fields tax_authority_id and tax_authority_name
3209: UPDATE zx_registrations_int reg_int

Line 3241: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3237: AND request_id = G_REQUEST_ID;
3238:
3239: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid tax authority ';
3240: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3241: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3242: END IF;
3243:
3244: -- value to id conversion for tax_authority_id
3245: UPDATE zx_registrations_int reg_int

Line 3262: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3258: AND tax_authority_name IS NOT NULL;
3259:
3260: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid tax_authority_id ';
3261: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3262: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3263: END IF;
3264:
3265: -- validating the field inclusive_tax_flag
3266: UPDATE zx_registrations_int

Line 3274: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3270: AND inclusive_tax_flag NOT IN ('Y','N',NULL);
3271:
3272: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid inclusive_tax_flag ';
3273: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3274: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3275: END IF;
3276:
3277: -- validating the fields rounding_rule_code and rounding_rule_name
3278: UPDATE zx_registrations_int reg_int

Line 3311: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3307: AND request_id = G_REQUEST_ID;
3308:
3309: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid rounding_rule ';
3310: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3311: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3312: END IF;
3313:
3314: -- value to id conversion for rounding_rule_code
3315: UPDATE zx_registrations_int reg_int

Line 3333: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3329: AND rounding_rule_name IS NOT NULL;
3330:
3331: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid rounding_rule_code ';
3332: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3333: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3334: END IF;
3335:
3336: -- validating the fields legal_location_id and other asccociated columns
3337: UPDATE zx_registrations_int reg_int

Line 3374: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3370: AND request_id = G_REQUEST_ID;
3371:
3372: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid legal_location_id ';
3373: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3374: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3375: END IF;
3376:
3377: -- value to id conversion for legal_location_id
3378: UPDATE zx_registrations_int reg_int

Line 3404: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3400: );
3401:
3402: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid legal_location_id ';
3403: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3404: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3405: END IF;
3406:
3407: -- validating the field default_registration_flag
3408: UPDATE zx_registrations_int

Line 3416: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3412: AND default_registration_flag NOT IN ('Y','N');
3413:
3414: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid default_registration_flag ';
3415: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3416: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3417: END IF;
3418:
3419: -- validating the fields tax_regime_name snd tax_regime_code
3420: UPDATE zx_registrations_int reg_int

Line 3448: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3444: AND request_id = G_REQUEST_ID;
3445:
3446: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid tax_regime ';
3447: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3448: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3449: END IF;
3450:
3451: -- value to id conversion for tax_regime_code
3452: UPDATE zx_registrations_int reg_int

Line 3468: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3464: AND tax_regime_name IS NOT NULL;
3465:
3466: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid tax_regime_code ';
3467: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3468: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3469: END IF;
3470:
3471: -- validating the fields tax and tax_name
3472: UPDATE zx_registrations_int reg_int

Line 3501: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3497: AND BITAND(error_number,G_ES_REG_TAX_REG_INVALID) = 0;
3498:
3499: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid tax ';
3500: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3501: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3502: END IF;
3503:
3504: -- value to id conversion for tax
3505: UPDATE zx_registrations_int reg_int

Line 3522: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3518: AND tax_name IS NOT NULL;
3519:
3520: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid tax_code ';
3521: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3522: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3523: END IF;
3524:
3525: -- validating the fields tax_jurisdiction_code and tax_jurisdiction_name
3526: UPDATE zx_registrations_int reg_int

Line 3539: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3535: AND tax_code IS NULL;
3536:
3537: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid tax_jurisdiction ';
3538: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3539: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3540: END IF;
3541:
3542: -- validating the fields TAX_JURISDICTION_CODE and tax_jurisdiction_name
3543: UPDATE zx_registrations_int reg_int

Line 3579: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3575: AND tax_code IS NOT NULL;
3576:
3577: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with invalid tax_jurisdiction ';
3578: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3579: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3580: END IF;
3581:
3582: -- value to id conversion for tax_jurisdiction_code
3583: UPDATE zx_registrations_int reg_int

Line 3603: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);

3599: AND tax_jurisdiction_name IS NOT NULL;
3600:
3601: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' REG records updated with valid tax_jurisdiction_code ';
3602: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3603: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3604: END IF;
3605:
3606: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3607: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'RegValueToIdConversion','RegValueToIdConversion(-)');

Line 3607: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'RegValueToIdConversion','RegValueToIdConversion(-)');

3603: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'RegValueToIdConversion',G_DEBUG_STATEMENT);
3604: END IF;
3605:
3606: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3607: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'RegValueToIdConversion','RegValueToIdConversion(-)');
3608: END IF;
3609:
3610: EXCEPTION
3611: WHEN OTHERS THEN

Line 3628: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'DupTRNValidation','DupTRNValidation(+)');

3624:
3625: BEGIN
3626:
3627: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3628: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'DupTRNValidation','DupTRNValidation(+)');
3629: END IF;
3630:
3631: -- Store Party Info in prog_int_char1
3632: UPDATE zx_registrations_int reg_int

Line 3643: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3639: AND NVL(record_status,G_RS_ERROR) = G_RS_VALID;
3640:
3641: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with Party Info in prog_int_char1';
3642: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3643: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3644: END IF;
3645:
3646: -- Ignore Records having allow_dup_regn_num_flag enables at Tax Level.
3647: UPDATE zx_registrations_int reg_int

Line 3663: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3659: );
3660:
3661: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with allow_dup_regn_num_flag ';
3662: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3663: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3664: END IF;
3665:
3666: -- TRN duplicate against other Party/sites
3667: UPDATE zx_party_tax_profile_int ptp_int

Line 3695: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3691: );
3692:
3693: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate against other Party/sites ';
3694: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3695: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3696: END IF;
3697:
3698: -- TRN duplicate for Party Sites Siblings
3699: UPDATE zx_party_tax_profile_int ptp_int

Line 3749: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3745: );
3746:
3747: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate for Party Sites Siblings ';
3748: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3749: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3750: END IF;
3751:
3752: UPDATE zx_party_tax_profile_int ptp_int
3753: SET error_number = error_number + G_ES_PTP_REG_NUM_DUP

Line 3766: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3762: );
3763:
3764: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate against Production';
3765: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3766: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3767: END IF;
3768:
3769: UPDATE zx_party_tax_profile_int ptp_int
3770: SET error_number = error_number + G_ES_PTP_REG_NUM_DUP

Line 3783: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3779: );
3780:
3781: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate against REG Production';
3782: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3783: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3784: END IF;
3785:
3786: -- TRN duplicate for Third Party and Third Party Site against Diff Party/Sites
3787: UPDATE zx_registrations_int reg_int

Line 3814: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3810: );
3811:
3812: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate for Third Party and Third Party Site against Diff Party/Sites';
3813: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3814: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3815: END IF;
3816:
3817: -- TRN duplicate for Third Party Sites Siblings
3818: UPDATE zx_registrations_int reg_int

Line 3878: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3874: );
3875:
3876: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate for Third Party Sites Siblings';
3877: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3878: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3879: END IF;
3880:
3881: -- TRN duplicate against Prod Tables
3882: UPDATE zx_registrations_int reg_int

Line 3897: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3893: );
3894:
3895: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate against Prod Tables';
3896: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3897: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3898: END IF;
3899:
3900: -- TRN duplicate against Prod Tables
3901: UPDATE zx_registrations_int reg_int

Line 3916: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3912: );
3913:
3914: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with TRN duplicate against Prod Tables';
3915: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3916: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3917: END IF;
3918:
3919:
3920: UPDATE zx_party_tax_profile_int ptp_int

Line 3928: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3924: AND error_number > 0;
3925:
3926: G_DEBUG_STATEMENT:='Updated Record Status for '||SQL%ROWCOUNT||' records from '||G_INTF_PTP_TABLE_NAME;
3927: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3928: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3929: END IF;
3930:
3931: UPDATE zx_registrations_int reg_int
3932: SET record_status = G_RS_ERROR

Line 3939: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3935: AND error_number > 0;
3936:
3937: G_DEBUG_STATEMENT:='Updated Record Status for '||SQL%ROWCOUNT||' records from '||G_INTF_REG_TABLE_NAME;
3938: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3939: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3940: END IF;
3941:
3942: UPDATE zx_party_tax_profile_int ptp_int
3943: SET record_status = NULL

Line 3954: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);

3950: AND reg_int.intf_ptp_reference = ptp_int.intf_ptp_reference);
3951:
3952: G_DEBUG_STATEMENT:='Reset Record Status for '||SQL%ROWCOUNT||' records from '||G_INTF_PTP_TABLE_NAME;
3953: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3954: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3955: END IF;
3956:
3957: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3958: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'DupTRNValidation','DupTRNValidation(-)');

Line 3958: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'DupTRNValidation','DupTRNValidation(-)');

3954: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'DupTRNValidation',G_DEBUG_STATEMENT);
3955: END IF;
3956:
3957: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3958: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'DupTRNValidation','DupTRNValidation(-)');
3959: END IF;
3960:
3961: EXCEPTION
3962: WHEN OTHERS THEN

Line 3980: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP','SyncUpRegNumberToPTP(+)');

3976:
3977: BEGIN
3978:
3979: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
3980: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP','SyncUpRegNumberToPTP(+)');
3981: END IF;
3982:
3983: UPDATE zx_party_tax_profile_int ptp_int
3984: SET registration_number = (

Line 4007: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP',G_DEBUG_STATEMENT);

4003: );
4004:
4005: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records synced up with TRN in PTP from REG';
4006: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4007: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP',G_DEBUG_STATEMENT);
4008: END IF;
4009:
4010: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4011: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP','SyncUpRegNumberToPTP(-)');

Line 4011: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP','SyncUpRegNumberToPTP(-)');

4007: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP',G_DEBUG_STATEMENT);
4008: END IF;
4009:
4010: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4011: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'SyncUpRegNumberToPTP','SyncUpRegNumberToPTP(-)');
4012: END IF;
4013:
4014: EXCEPTION
4015: WHEN OTHERS THEN

Line 4041: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord','ProcessExemptionRecord(+)');

4037:
4038: l_date1 := SYSDATE;
4039:
4040: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4041: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord','ProcessExemptionRecord(+)');
4042: END IF;
4043:
4044: -------------------------
4045: -- Populate default values

Line 4060: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);

4056: NVL(G_BATCH_ID,NVL(batch_id,G_MISS_NUM));
4057:
4058: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Populated default values';
4059: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4060: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);
4061: END IF;
4062:
4063: -------------------------
4064: -- Check Mandatory Paramters

Line 4077: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);

4073: rate_modifier IS NULL);
4074:
4075: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with Mandatory Paramters NULL';
4076: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4077: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);
4078: END IF;
4079:
4080: -------------------------
4081: -- Duplicate records checking

Line 4096: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);

4092: l_date3 := SYSDATE;
4093:
4094: G_DEBUG_STATEMENT:= ' Value to Conversion complete for Exemptions';
4095: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4096: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);
4097: END IF;
4098:
4099: -------------------------
4100: -- Record level validations

Line 4139: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);

4135: );
4136:
4137: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with Exemptions overlapping date ranges.';
4138: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4139: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);
4140: END IF;
4141:
4142: ----------------------------
4143: -- Exemption DFF Validation

Line 4152: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);

4148: l_date5 := SYSDATE;
4149:
4150: G_DEBUG_STATEMENT:= 'Exemptions DFF validation Complete';
4151: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4152: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);
4153: END IF;
4154:
4155: ----------------------------
4156: -- Tail End Activities

Line 4176: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);

4172: AND exe_int.intf_ptp_reference = ptp_int.intf_ptp_reference);
4173:
4174: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with record_status NULL';
4175: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4176: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord',G_DEBUG_STATEMENT);
4177: END IF;
4178:
4179: l_date6 := SYSDATE;
4180:

Line 4204: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord','ProcessExemptionRecord(-)');

4200: ,p_message => '+--------------------------------------------------------------------'
4201: );
4202:
4203: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4204: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessExemptionRecord','ProcessExemptionRecord(-)');
4205: END IF;
4206:
4207: EXCEPTION
4208: WHEN OTHERS THEN

Line 4224: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion','ExemptValueToIdConversion(+)');

4220: PROCEDURE ExemptValueToIdConversion IS
4221: BEGIN
4222:
4223: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4224: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion','ExemptValueToIdConversion(+)');
4225: END IF;
4226:
4227: -- Field Validations
4228:

Line 4238: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4234: AND dml_type <> 'CREATE';
4235:
4236: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid dml_type';
4237: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4238: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4239: END IF;
4240:
4241: -- validating the fields exempt_reason_name and exempt_reason_code
4242: UPDATE zx_exemptions_int exe_int

Line 4275: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4271: AND request_id = G_REQUEST_ID;
4272:
4273: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid exempt_reason';
4274: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4275: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4276: END IF;
4277:
4278: -- value to id conversion for registration_reason_code
4279: UPDATE zx_exemptions_int exe_int

Line 4297: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4293: AND exempt_reason_name IS NOT NULL;
4294:
4295: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid exempt_reason_code';
4296: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4297: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4298: END IF;
4299:
4300: -- validating the fields exemption_status_name and exemption_status_code
4301: UPDATE zx_exemptions_int exe_int

Line 4334: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4330: AND request_id = G_REQUEST_ID;
4331:
4332: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid exemption_status';
4333: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4334: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4335: END IF;
4336:
4337: -- value to id conversion for exempt_status_code
4338: UPDATE zx_exemptions_int exe_int

Line 4356: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4352: AND exemption_status_name IS NOT NULL;
4353:
4354: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid exemption_status_code';
4355: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4356: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4357: END IF;
4358:
4359: -- validating the fields tax_regime_name snd tax_regime_code
4360: UPDATE zx_exemptions_int exe_int

Line 4389: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4385: AND request_id = G_REQUEST_ID;
4386:
4387: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid tax_regime';
4388: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4389: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4390: END IF;
4391:
4392: -- value to id conversion for tax_regime_code
4393: UPDATE zx_exemptions_int exe_int

Line 4408: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4404: AND tax_regime_name IS NOT NULL;
4405:
4406: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid tax_regime_code';
4407: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4408: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4409: END IF;
4410:
4411: -- validating the fields content_owner_id snd content_owner_name
4412: UPDATE zx_exemptions_int exe_int

Line 4459: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4455: AND BITAND(error_number,G_ES_EXE_TAX_REG_INVALID) = 0;
4456:
4457: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid content_owner';
4458: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4459: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4460: END IF;
4461:
4462: -- value to id conversion for content_owner_id
4463: UPDATE zx_exemptions_int exe_int

Line 4488: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4484: AND content_owner_name IS NOT NULL;
4485:
4486: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid content_owner_id';
4487: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4488: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4489: END IF;
4490:
4491: -- validating the fields tax and tax_name
4492: UPDATE zx_exemptions_int exe_int

Line 4556: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4552: G_ES_EXE_CNT_OWN_INVALID) = 0;
4553:
4554: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid tax';
4555: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4556: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4557: END IF;
4558:
4559: -- value to id conversion for tax
4560: UPDATE zx_exemptions_int exe_int

Line 4594: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4590: AND tax_name IS NOT NULL;
4591:
4592: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid tax_code';
4593: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4594: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4595: END IF;
4596:
4597: -- validating the fields tax_status_code and tax_status_name
4598: UPDATE zx_exemptions_int exe_int

Line 4665: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4661: G_ES_EXE_TAX_PARAM_INVALID) = 0;
4662:
4663: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid tax status';
4664: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4665: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4666: END IF;
4667:
4668: -- value to id conversion for tax_status_code
4669: UPDATE zx_exemptions_int exe_int

Line 4705: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4701: AND tax_status_name IS NOT NULL;
4702:
4703: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid tax_status_code';
4704: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4705: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4706: END IF;
4707:
4708: -- validating the fields tax_jurisdictin_code and tax_jurisdiction_name
4709: UPDATE zx_exemptions_int exe_int

Line 4720: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4716: AND tax_code IS NULL;
4717:
4718: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid tax_jurisdictin';
4719: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4720: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4721: END IF;
4722:
4723: -- validating the fields tax_jurisdiction_id and tax_jurisdiction_name
4724: UPDATE zx_exemptions_int exe_int

Line 4758: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4754: AND tax_code IS NOT NULL;
4755:
4756: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid tax_jurisdictin';
4757: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4758: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4759: END IF;
4760:
4761: -- value to id conversion for tax_jurisdictin_code
4762: UPDATE zx_exemptions_int exe_int

Line 4780: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4776: AND tax_jurisdiction_name IS NOT NULL;
4777:
4778: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid tax_jurisdiction_id';
4779: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4780: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4781: END IF;
4782:
4783: -- validating the fields tax_rate_code and tax_rate_name
4784: UPDATE zx_exemptions_int exe_int

Line 4852: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4848: G_ES_EXE_TAX_STS_INVALID) = 0;
4849:
4850: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid tax_rate';
4851: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4852: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4853: END IF;
4854:
4855: -- value to id conversion for tax_rate_code
4856: UPDATE zx_exemptions_int exe_int

Line 4893: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4889: AND tax_rate_name IS NOT NULL;
4890:
4891: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid tax_rate_code';
4892: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4893: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4894: END IF;
4895:
4896: -- Validate the fields apply_to_lower_levels_flag
4897: UPDATE zx_exemptions_int exe_int

Line 4905: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4901: AND apply_to_lower_levels_flag NOT IN ('Y','N');
4902:
4903: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid apply_to_lower_levels_flag';
4904: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4905: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4906: END IF;
4907:
4908: -- Validate the fields effective_to and effective_from
4909: UPDATE zx_exemptions_int exe_int

Line 4918: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4914: AND effective_to < effective_from;
4915:
4916: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid effective date';
4917: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4918: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4919: END IF;
4920:
4921: -- validating the fields inventory_org_id, inventory_org_name
4922: UPDATE zx_exemptions_int exe_int

Line 4970: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4966: AND request_id = G_REQUEST_ID;
4967:
4968: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid inventory org';
4969: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4970: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
4971: END IF;
4972:
4973: -- value to id conversion for inventory_org_id
4974: UPDATE zx_exemptions_int exe_int

Line 4999: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

4995: AND Inventory_Org_name IS NOT NULL;
4996:
4997: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid Inventory_Org_id';
4998: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
4999: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5000: END IF;
5001:
5002: -- validating the fields item_number, inventory_item_id
5003: UPDATE zx_exemptions_int exe_int

Line 5032: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

5028: AND BITAND(error_number,G_ES_EXE_INV_ORG_INVALID) = 0;
5029:
5030: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid inventory item';
5031: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5032: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5033: END IF;
5034:
5035: -- value to id conversion for inventory_item_id
5036: UPDATE zx_exemptions_int exe_int

Line 5053: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

5049: AND item_number IS NOT NULL;
5050:
5051: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid inventory_item_id';
5052: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5053: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5054: END IF;
5055:
5056: -- validating the fields issuing_tax_authority_id, issuing_tax_authority_name
5057: UPDATE zx_exemptions_int exe_int

Line 5089: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

5085: AND request_id = G_REQUEST_ID;
5086:
5087: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid issuing_tax_authority';
5088: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5089: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5090: END IF;
5091:
5092: -- value to id conversion for issuing_tax_authority_id
5093: UPDATE zx_exemptions_int exe_int

Line 5111: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

5107: AND issuing_tax_authority_name IS NOT NULL;
5108:
5109: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid issuing_tax_authority_id';
5110: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5111: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5112: END IF;
5113:
5114: -- validating the fields exemption_type_code and exemption_type_name
5115: UPDATE zx_exemptions_int exe_int

Line 5149: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

5145: AND request_id = G_REQUEST_ID;
5146:
5147: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with invalid exemption_type';
5148: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5149: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5150: END IF;
5151:
5152: -- value to id conversion for exemption_type_code
5153: UPDATE zx_exemptions_int exe_int

Line 5171: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);

5167: AND exemption_type_name IS NOT NULL;
5168:
5169: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Records with valid exemption_type_code';
5170: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5171: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5172: END IF;
5173:
5174: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5175: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion','ExemptValueToIdConversion(-)');

Line 5175: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion','ExemptValueToIdConversion(-)');

5171: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion',G_DEBUG_STATEMENT);
5172: END IF;
5173:
5174: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5175: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ExemptValueToIdConversion','ExemptValueToIdConversion(-)');
5176: END IF;
5177:
5178: EXCEPTION
5179: WHEN OTHERS THEN

Line 5196: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'resetDFFFieldUsage','resetDFFFieldUsage(+)');

5192: PROCEDURE resetDFFFieldUsage IS
5193: BEGIN
5194:
5195: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5196: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'resetDFFFieldUsage','resetDFFFieldUsage(+)');
5197: END IF;
5198:
5199: g_dff_usage_record.attribute1 := G_FALSE;
5200: g_dff_usage_record.attribute2 := G_FALSE;

Line 5216: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'resetDFFFieldUsage','resetDFFFieldUsage(-)');

5212: g_dff_usage_record.attribute14 := G_FALSE;
5213: g_dff_usage_record.attribute15 := G_FALSE;
5214:
5215: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5216: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'resetDFFFieldUsage','resetDFFFieldUsage(-)');
5217: END IF;
5218:
5219: EXCEPTION
5220: WHEN OTHERS THEN

Line 5335: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'performDFFValidation','performDFFValidation(+)');

5331:
5332: BEGIN
5333:
5334: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5335: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'performDFFValidation','performDFFValidation(+)');
5336: END IF;
5337:
5338: -- validate the flex field
5339: G_DEBUG_STATEMENT:= ' Validating the Flx fields';

Line 5341: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'performDFFValidation',G_DEBUG_STATEMENT);

5337:
5338: -- validate the flex field
5339: G_DEBUG_STATEMENT:= ' Validating the Flx fields';
5340: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5341: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'performDFFValidation',G_DEBUG_STATEMENT);
5342: END IF;
5343:
5344: FND_DFLEX.get_flexfield
5345: (appl_short_name => 'ZX'

Line 5519: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'performDFFValidation',G_DEBUG_STATEMENT);

5515: );
5516:
5517: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records flagged all record where customer has populated data into attributes';
5518: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5519: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'performDFFValidation',G_DEBUG_STATEMENT);
5520: END IF;
5521:
5522: END IF;
5523: --

Line 5527: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'performDFFValidation','performDFFValidation(-)');

5523: --
5524: -- DFF validation is complete
5525: --
5526: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5527: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'performDFFValidation','performDFFValidation(-)');
5528: END IF;
5529:
5530: EXCEPTION
5531: WHEN OTHERS THEN

Line 5559: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord','ProcessRepCodeAssocRecord(+)');

5555:
5556: l_date1 := SYSDATE;
5557:
5558: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5559: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord','ProcessRepCodeAssocRecord(+)');
5560: END IF;
5561:
5562: -------------------------
5563: -- Populate default values

Line 5578: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);

5574: NVL(G_BATCH_ID,NVL(batch_id,G_MISS_NUM));
5575:
5576: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records populated with default values';
5577: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5578: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);
5579: END IF;
5580:
5581: -------------------------
5582: -- Check Mandatory Paramters

Line 5594: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);

5590: AND reporting_type_name IS NULL;
5591:
5592: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with Mandatory Paramters values NULL';
5593: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5594: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);
5595: END IF;
5596:
5597: -------------------------
5598: -- Duplicate records checking

Line 5622: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);

5618: );
5619:
5620: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' Duplicate records found';
5621: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5622: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);
5623: END IF;
5624:
5625: -------------------------
5626: -- Value to Id Conversion

Line 5635: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);

5631: l_date3 := SYSDATE;
5632:
5633: G_DEBUG_STATEMENT:= ' Value to ID Conversions Complete ';
5634: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5635: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);
5636: END IF;
5637:
5638: -------------------------
5639: -- Record level validations

Line 5667: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);

5663: );
5664:
5665: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' rca records with overlapping date ranges.';
5666: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5667: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);
5668: END IF;
5669:
5670: l_date4 := SYSDATE;
5671:

Line 5693: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);

5689: AND rca_int.intf_ptp_reference = ptp_int.intf_ptp_reference);
5690:
5691: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' ptp records with record_status updated to NULL';
5692: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5693: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord',G_DEBUG_STATEMENT);
5694: END IF;
5695:
5696: l_date5 := SYSDATE;
5697:

Line 5718: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord','ProcessRepCodeAssocRecord(-)');

5714: ,p_message => '+--------------------------------------------------------------------'
5715: );
5716:
5717: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5718: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'ProcessRepCodeAssocRecord','ProcessRepCodeAssocRecord(-)');
5719: END IF;
5720:
5721: EXCEPTION
5722: WHEN OTHERS THEN

Line 5740: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion','AssocValueToIdConversion(+)');

5736:
5737: BEGIN
5738:
5739: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5740: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion','AssocValueToIdConversion(+)');
5741: END IF;
5742:
5743: -- Field Validations
5744:

Line 5754: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5750: AND dml_type <> 'CREATE';
5751:
5752: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid dml_type found';
5753: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5754: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5755: END IF;
5756:
5757: -- Validate the fields entity_code
5758: UPDATE zx_report_codes_assoc_int

Line 5768: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5764: AND entity_code <> 'ZX_PARTY_TAX_PROFILE';
5765:
5766: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid entity_code found';
5767: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5768: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5769: END IF;
5770:
5771: -- Validate the fields effective_to and effective_from
5772: UPDATE zx_report_codes_assoc_int

Line 5781: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5777: AND effective_to < effective_from;
5778:
5779: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid effective dates found';
5780: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5781: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5782: END IF;
5783:
5784: -- validating the fields reporting_type_id and reporting_type_name
5785: UPDATE zx_report_codes_assoc_int rca_int

Line 5827: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5823: AND request_id = G_REQUEST_ID;
5824:
5825: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid reporting_type found';
5826: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5827: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5828: END IF;
5829:
5830: -- value to id conversion for reporting_type_id
5831: UPDATE zx_report_codes_assoc_int rca_int

Line 5854: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5850: AND reporting_type_name IS NOT NULL;
5851:
5852: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with valid reporting_type_id';
5853: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5854: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5855: END IF;
5856:
5857: -- validating the fields reporting_code_id and reporting_code_name
5858: UPDATE zx_report_codes_assoc_int rca_int

Line 5891: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5887: AND BITAND(error_number,G_ES_RCA_REP_TYPE_INVALID) = 0;
5888:
5889: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid reporting_code found';
5890: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5891: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5892: END IF;
5893:
5894: -- value to id conversion for reporting_code_id
5895: UPDATE zx_report_codes_assoc_int rca_int

Line 5914: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5910: AND reporting_code_name IS NOT NULL;
5911:
5912: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records updated with valid reporting_code_id';
5913: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5914: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5915: END IF;
5916:
5917: -- validating the fields reporting_code_char_value/reporting_code_num_value/reporting_code_date_value
5918: UPDATE zx_report_codes_assoc_int rca_int

Line 5941: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);

5937: );
5938:
5939: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' records with invalid reporting_code__value found';
5940: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5941: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5942: END IF;
5943:
5944: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5945: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion','AssocValueToIdConversion(-)');

Line 5945: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion','AssocValueToIdConversion(-)');

5941: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion',G_DEBUG_STATEMENT);
5942: END IF;
5943:
5944: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5945: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'AssocValueToIdConversion','AssocValueToIdConversion(-)');
5946: END IF;
5947:
5948: EXCEPTION
5949: WHEN OTHERS THEN

Line 5962: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PopulateProductionTables','PopulateProductionTables(-)');

5958: PROCEDURE PopulateProductionTables IS
5959: BEGIN
5960:
5961: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5962: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PopulateProductionTables','PopulateProductionTables(-)');
5963: END IF;
5964:
5965: UPDATE zx_party_tax_profile_int ptp_int
5966: SET party_tax_profile_id = zx_party_tax_profile_s.nextval

Line 5974: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

5970: AND dml_type = 'CREATE';
5971:
5972: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' ptp records updated with valid party_tax_profile_id';
5973: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5974: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
5975: END IF;
5976:
5977: UPDATE zx_registrations_int reg_int
5978: SET party_tax_profile_id =

Line 5991: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

5987: AND request_id = G_REQUEST_ID;
5988:
5989: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' reg records updated with valid party_tax_profile_id';
5990: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
5991: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
5992: END IF;
5993:
5994: UPDATE zx_exemptions_int exe_int
5995: SET party_tax_profile_id =

Line 6008: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

6004: AND request_id = G_REQUEST_ID;
6005:
6006: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' exe records updated with valid party_tax_profile_id';
6007: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6008: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
6009: END IF;
6010:
6011: UPDATE zx_report_codes_assoc_int rca_int
6012: SET (party_tax_profile_id,entity_id) =

Line 6025: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

6021: AND request_id = G_REQUEST_ID;
6022:
6023: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' rca records updated with valid party_tax_profile_id';
6024: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6025: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
6026: END IF;
6027:
6028: INSERT INTO zx_party_tax_profile(
6029: PARTY_TYPE_CODE,

Line 6163: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

6159: );
6160:
6161: G_DEBUG_STATEMENT:= 'Inserted '||SQL%ROWCOUNT||' records into zx_party_tax_profile ';
6162: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6163: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
6164: END IF;
6165: log_now (p_log_level => FND_FILE.LOG
6166: ,p_message => G_DEBUG_STATEMENT
6167: );

Line 6299: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

6295: AND error_number = 0);
6296:
6297: G_DEBUG_STATEMENT:= 'Inserted '||SQL%ROWCOUNT||' records into zx_registrations ';
6298: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6299: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
6300: END IF;
6301: log_now (p_log_level => FND_FILE.LOG
6302: ,p_message => G_DEBUG_STATEMENT
6303: );

Line 6415: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

6411: AND error_number = 0);
6412:
6413: G_DEBUG_STATEMENT:= 'Inserted '||SQL%ROWCOUNT||' records into zx_exemptions ';
6414: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6415: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
6416: END IF;
6417: log_now (p_log_level => FND_FILE.LOG
6418: ,p_message => G_DEBUG_STATEMENT
6419: );

Line 6466: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);

6462: );
6463:
6464: G_DEBUG_STATEMENT:= 'Inserted '||SQL%ROWCOUNT||' records into zx_report_codes_assoc ';
6465: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6466: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'PopulateProductionTables',G_DEBUG_STATEMENT);
6467: END IF;
6468: log_now (p_log_level => FND_FILE.LOG
6469: ,p_message => G_DEBUG_STATEMENT
6470: );

Line 6473: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PopulateProductionTables','PopulateProductionTables(-)');

6469: ,p_message => G_DEBUG_STATEMENT
6470: );
6471:
6472: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6473: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'PopulateProductionTables','PopulateProductionTables(-)');
6474: END IF;
6475:
6476: EXCEPTION
6477: WHEN OTHERS THEN

Line 6542: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'LogErrorToTable','LogErrorToTable(+)');

6538:
6539: BEGIN
6540:
6541: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
6542: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'LogErrorToTable','LogErrorToTable(+)');
6543: END IF;
6544:
6545: UPDATE zx_party_tax_profile_int
6546: SET intf_ptp_reference = G_REQUEST_ID||'**'||ROWNUM

Line 7540: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'LogErrorToTable','LogErrorToTable(-)');

7536: --
7537: l_error_table.DELETE();
7538:
7539: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7540: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'LogErrorToTable','LogErrorToTable(-)');
7541: END IF;
7542:
7543:
7544: EXCEPTION

Line 7610: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER','IMPORT_WRAPPER(+)');

7606: log_now (p_log_level => FND_FILE.LOG
7607: ,p_message => G_PROC_NAME||'(+)'
7608: );
7609: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7610: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER','IMPORT_WRAPPER(+)');
7611: END IF;
7612:
7613: SetGlobals();
7614: SetProcessConstants();

Line 7677: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7673: END IF;
7674:
7675: G_DEBUG_STATEMENT:= 'Completed validating mandatory API parameters';
7676: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7677: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7678: END IF;
7679:
7680: IF p_interface_table_name = G_CUST_INTF_TABLE THEN
7681: -- processing data specific to customers interface table of TCA

Line 7754: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7750: ,p_message => l_dynamic_sql
7751: );
7752: G_DEBUG_STATEMENT:= 'error executing Populate PTP Intf SQL :'||SQLERRM;
7753: IF (G_DEBUG_LEVEL_EXCEPTION >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7754: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7755: END IF;
7756:
7757: RAISE;
7758: END;

Line 7761: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7757: RAISE;
7758: END;
7759: G_DEBUG_STATEMENT:= 'Completed executing Populate PTP Intf SQL ';
7760: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7761: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7762: END IF;
7763: END IF;
7764:
7765: l_date3 := SYSDATE;

Line 7796: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7792: END IF;
7793:
7794: G_DEBUG_STATEMENT:= 'Completed Validate Mode for IMPORT_WRAPPER ';
7795: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7796: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7797: END IF;
7798:
7799: END IF; -- end p_validate_only
7800: l_date5 := SYSDATE;

Line 7837: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7833: ,p_message => l_dynamic_sql
7834: );
7835: G_DEBUG_STATEMENT:= 'Error Executing below Party ID SQL :'||SQLERRM;
7836: IF (G_DEBUG_LEVEL_EXCEPTION >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7837: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7838: END IF;
7839: RAISE;
7840: END;
7841: G_DEBUG_STATEMENT:= 'Completed executing below Party ID SQL ';

Line 7843: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7839: RAISE;
7840: END;
7841: G_DEBUG_STATEMENT:= 'Completed executing below Party ID SQL ';
7842: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7843: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7844: END IF;
7845: END IF;
7846: l_date7 := SYSDATE;
7847:

Line 7856: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7852: AND party_id IS NULL;
7853:
7854: G_DEBUG_STATEMENT:= SQL%ROWCOUNT||' PTP records updated with record_status = NULL';
7855: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7856: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7857: END IF;
7858:
7859: ResetRecStatusForChildTables();
7860:

Line 7913: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7909: ,p_message => l_dynamic_sql
7910: );
7911: G_DEBUG_STATEMENT:= 'Error Executing hz_customer_int.sync_tax_reference API :'||SQLERRM;
7912: IF (G_DEBUG_LEVEL_EXCEPTION >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7913: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7914: END IF;
7915: RAISE;
7916: END IF;
7917: END;

Line 7958: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7954: ,p_message => l_dynamic_sql
7955: );
7956: G_DEBUG_STATEMENT:= 'Error Executing below Populate PTP Table SQL :'||SQLERRM;
7957: IF (G_DEBUG_LEVEL_EXCEPTION >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7958: FND_LOG.STRING(G_DEBUG_LEVEL_EXCEPTION,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7959: END IF;
7960: RAISE;
7961: END;
7962: l_date11 := SYSDATE;

Line 7966: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);

7962: l_date11 := SYSDATE;
7963:
7964: G_DEBUG_STATEMENT:= 'Completed Insert Mode for IMPORT_WRAPPER';
7965: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
7966: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER',G_DEBUG_STATEMENT);
7967: END IF;
7968:
7969: END IF; -- end p_insert_only
7970: l_date12 := SYSDATE;

Line 8019: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER','IMPORT_WRAPPER(-)');

8015: log_now (p_log_level => FND_FILE.LOG
8016: ,p_message => G_PROC_NAME||'(-)'
8017: );
8018: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
8019: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'IMPORT_WRAPPER','IMPORT_WRAPPER(-)');
8020: END IF;
8021:
8022: EXCEPTION
8023: WHEN OTHERS THEN

Line 8095: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'MESSAGE_WRAPPER','MESSAGE_WRAPPER(+)');

8091: log_now (p_log_level => FND_FILE.LOG
8092: ,p_message => G_PROC_NAME||'(+)'
8093: );
8094: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
8095: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'MESSAGE_WRAPPER','MESSAGE_WRAPPER(+)');
8096: END IF;
8097:
8098: SetGlobals();
8099: SetProcessConstants();

Line 8131: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'MESSAGE_WRAPPER',G_DEBUG_STATEMENT);

8127: END IF;
8128:
8129: G_DEBUG_STATEMENT:= 'Completed validating mandatory API parameters';
8130: IF (G_DEBUG_LEVEL_STATEMENT >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
8131: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,G_DEBUG_LOG_HEADER||'MESSAGE_WRAPPER',G_DEBUG_STATEMENT);
8132: END IF;
8133:
8134: IF FND_API.to_boolean (p_display_stats) THEN
8135: IF p_interface_table_name = G_CUST_INTF_TABLE THEN

Line 8357: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'MESSAGE_WRAPPER','MESSAGE_WRAPPER(-)');

8353: log_now (p_log_level => FND_FILE.LOG
8354: ,p_message => G_PROC_NAME||'(-)'
8355: );
8356: IF (G_DEBUG_LEVEL_PROCEDURE >= G_CURRENT_DEBUG_LEVEL_SET ) THEN
8357: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,G_DEBUG_LOG_HEADER||'MESSAGE_WRAPPER','MESSAGE_WRAPPER(-)');
8358: END IF;
8359:
8360: EXCEPTION
8361: WHEN OTHERS THEN