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 ZX_REPORT_CODES_ASSOC

Line 219: G_INTF_RCA_TABLE_NAME := 'ZX_REPORT_CODES_ASSOC_INT';

215: --
216: G_INTF_PTP_TABLE_NAME := 'ZX_PARTY_TAX_PROFILE_INT';
217: G_INTF_REG_TABLE_NAME := 'ZX_REGISTRATIONS_INT';
218: G_INTF_EXE_TABLE_NAME := 'ZX_EXEMPTIONS_INT';
219: G_INTF_RCA_TABLE_NAME := 'ZX_REPORT_CODES_ASSOC_INT';
220: G_INTF_CUS_TABLE_NAME := 'RA_CUSTOMERS_INTERFACE_ALL';
221: G_INTF_SUP_TABLE_NAME := 'AP_SUPPLIERS_INT';
222: G_INTF_SUP_SITE_TABLE_NAME := 'AP_SUPPLIER_SITES_INT';
223:

Line 481: DELETE zx_report_codes_assoc_int

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
483: AND record_status = G_RS_VALID;
484:
485: G_DEBUG_STATEMENT:='Deleted '||SQL%ROWCOUNT||' records from '||G_INTF_RCA_TABLE_NAME;

Line 579: UPDATE zx_report_codes_assoc_int rca_int

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
581: WHERE request_id = G_REQUEST_ID
582: AND record_status = G_RS_VALID
583: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1

Line 863: FROM ZX_REPORT_CODES_ASSOC_INT

859:
860: BEGIN
861: SELECT G_INTF_RCA_TABLE_NAME
862: INTO l_temp_char_30
863: FROM ZX_REPORT_CODES_ASSOC_INT
864: WHERE NVL(record_status,G_RS_ERROR) <> G_RS_VALID
865: AND NVL(batch_id,G_MISS_NUM) =
866: NVL(G_BATCH_ID,NVL(batch_id,G_MISS_NUM))
867: AND ROWNUM = 1;

Line 5565: UPDATE zx_report_codes_assoc_int

5561:
5562: -------------------------
5563: -- Populate default values
5564: -------------------------
5565: UPDATE zx_report_codes_assoc_int
5566: SET request_id = G_REQUEST_ID
5567: ,record_status = G_RS_IN_PROCESS
5568: ,dml_type = UPPER(dml_type)
5569: ,prog_int_char1 = NULL

Line 5585: UPDATE zx_report_codes_assoc_int

5581: -------------------------
5582: -- Check Mandatory Paramters
5583: -------------------------
5584: -- party_tax_profile_id is considered in case of Update Scenario.
5585: UPDATE zx_report_codes_assoc_int
5586: SET error_number = G_ES_RCA_MAND_PARAM_MISSING
5587: WHERE request_id = G_REQUEST_ID
5588: AND record_status = G_RS_IN_PROCESS
5589: AND reporting_type_id IS NULL

Line 5601: UPDATE zx_report_codes_assoc_int orig

5597: -------------------------
5598: -- Duplicate records checking
5599: -------------------------
5600:
5601: UPDATE zx_report_codes_assoc_int orig
5602: SET error_number = error_number + G_ES_RCA_DUP_INTF_RECORD,
5603: record_status = G_RS_ERROR
5604: WHERE request_id = G_REQUEST_ID
5605: AND record_status = G_RS_IN_PROCESS

Line 5609: FROM zx_report_codes_assoc_int dup

5605: AND record_status = G_RS_IN_PROCESS
5606: AND error_number <> G_ES_RCA_MAND_PARAM_MISSING
5607: AND EXISTS (
5608: SELECT /*+ FIRST_ROWS(1) */ 1
5609: FROM zx_report_codes_assoc_int dup
5610: WHERE dup.rowid <> orig.rowid
5611: AND dup.request_id = G_REQUEST_ID
5612: AND dup.record_status = G_RS_IN_PROCESS
5613: AND NVL(dup.entity_id,G_MISS_NUM) = NVL(orig.entity_id,G_MISS_NUM)

Line 5644: UPDATE zx_report_codes_assoc_int orig

5640: -------------------------
5641:
5642: -- Validation to check rca with overlapping date ranges.
5643:
5644: UPDATE zx_report_codes_assoc_int orig
5645: SET error_number = error_number + G_ES_RCA_DATE_OVERLAP
5646: WHERE orig.record_status = G_RS_IN_PROCESS
5647: AND orig.request_id = G_REQUEST_ID
5648: AND EXISTS (

Line 5650: FROM zx_report_codes_assoc_int dup

5646: WHERE orig.record_status = G_RS_IN_PROCESS
5647: AND orig.request_id = G_REQUEST_ID
5648: AND EXISTS (
5649: SELECT /*+ FIRST_ROWS(1) */ 1
5650: FROM zx_report_codes_assoc_int dup
5651: WHERE dup.rowid <> orig.rowid
5652: AND dup.request_id = G_REQUEST_ID
5653: AND dup.record_status = G_RS_IN_PROCESS
5654: AND BITAND(dup.error_number,G_ES_RCA_REP_TYPE_INVALID) = 0

Line 5675: UPDATE zx_report_codes_assoc_int rca_int

5671:
5672: -------------------------
5673: -- NO Other Validations
5674: -------------------------
5675: UPDATE zx_report_codes_assoc_int rca_int
5676: SET record_status = DECODE(error_number,0,G_RS_VALID,G_RS_ERROR)
5677: WHERE request_id = G_REQUEST_ID
5678: AND record_status = G_RS_IN_PROCESS;
5679:

Line 5686: FROM zx_report_codes_assoc_int rca_int

5682: SET record_status = NULL
5683: WHERE request_id = G_REQUEST_ID
5684: AND record_status = G_RS_VALID
5685: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
5686: FROM zx_report_codes_assoc_int rca_int
5687: WHERE request_id = G_REQUEST_ID
5688: AND record_status = G_RS_ERROR
5689: AND rca_int.intf_ptp_reference = ptp_int.intf_ptp_reference);
5690:

Line 5746: UPDATE zx_report_codes_assoc_int

5742:
5743: -- Field Validations
5744:
5745: -- Validate the field dml_type
5746: UPDATE zx_report_codes_assoc_int
5747: SET error_number = error_number + G_ES_RCA_TRANS_TYPE_INVALID
5748: WHERE record_status = G_RS_IN_PROCESS
5749: AND request_id = G_REQUEST_ID
5750: AND dml_type <> 'CREATE';

Line 5758: UPDATE zx_report_codes_assoc_int

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
5759: SET error_number = error_number + G_ES_RCA_ENTY_CD_INVALID
5760: WHERE record_status = G_RS_IN_PROCESS
5761: AND request_id = G_REQUEST_ID
5762: AND NVL(batch_id,G_MISS_NUM) =

Line 5772: UPDATE zx_report_codes_assoc_int

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
5773: SET error_number = error_number + G_ES_RCA_DATE_RANGE_INVALID
5774: WHERE record_status = G_RS_IN_PROCESS
5775: AND request_id = G_REQUEST_ID
5776: AND effective_to IS NOT NULL

Line 5785: UPDATE zx_report_codes_assoc_int rca_int

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
5786: SET error_number = error_number + G_ES_RCA_REP_TYPE_INVALID
5787: WHERE (( reporting_type_id IS NOT NULL
5788: AND NOT EXISTS
5789: (

Line 5831: UPDATE zx_report_codes_assoc_int rca_int

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
5832: SET reporting_type_id =
5833: (
5834: SELECT RepType.Reporting_Type_Id
5835: FROM Zx_Reporting_Types_VL RepType,

Line 5858: UPDATE zx_report_codes_assoc_int rca_int

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
5859: SET error_number = error_number + G_ES_RCA_REP_CODE_INVALID
5860: WHERE (( reporting_code_id IS NOT NULL
5861: AND NOT EXISTS
5862: (

Line 5895: UPDATE zx_report_codes_assoc_int rca_int

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
5896: SET reporting_code_id =
5897: (
5898: SELECT Reporting_Code_Id
5899: FROM ZX_REPORTING_CODES_VL RepCode

Line 5918: UPDATE zx_report_codes_assoc_int rca_int

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
5919: SET error_number = error_number + G_ES_RCA_REP_CODE_VAL_INVALID
5920: WHERE record_status = G_RS_IN_PROCESS
5921: AND request_id = G_REQUEST_ID
5922: AND BITAND(error_number,G_ES_RCA_REP_TYPE_INVALID+

Line 6011: UPDATE zx_report_codes_assoc_int rca_int

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) =
6013: (
6014: SELECT party_tax_profile_id,party_tax_profile_id
6015: FROM zx_party_tax_profile_int ptp_int

Line 6421: INSERT INTO zx_report_codes_assoc(

6417: log_now (p_log_level => FND_FILE.LOG
6418: ,p_message => G_DEBUG_STATEMENT
6419: );
6420:
6421: INSERT INTO zx_report_codes_assoc(
6422: REPORTING_CODE_ASSOC_ID,
6423: ENTITY_CODE,
6424: ENTITY_ID,
6425: EXCEPTION_CODE,

Line 6441: SELECT ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID,

6437: REPORTING_CODE_ID,
6438: OBJECT_VERSION_NUMBER
6439: )
6440: (
6441: SELECT ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID,
6442: ENTITY_CODE,
6443: ENTITY_ID,
6444: NULL, --EXCEPTION_CODE,
6445: EFFECTIVE_FROM,

Line 6458: FROM zx_report_codes_assoc_int

6454: REPORTING_CODE_NUM_VALUE,
6455: REPORTING_TYPE_ID,
6456: REPORTING_CODE_ID,
6457: 1 --OBJECT_VERSION_NUMBER
6458: FROM zx_report_codes_assoc_int
6459: WHERE record_status = G_RS_VALID
6460: AND request_id = G_REQUEST_ID
6461: AND error_number = 0
6462: );

Line 6464: G_DEBUG_STATEMENT:= 'Inserted '||SQL%ROWCOUNT||' records into zx_report_codes_assoc ';

6460: AND request_id = G_REQUEST_ID
6461: AND error_number = 0
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

Line 6516: FROM zx_report_codes_assoc_int rca_int, zx_party_tax_profile_int ptp_int

6512: AND ptp_int.request_id = exe_int.request_id;
6513:
6514: CURSOR c_rca_errors IS
6515: SELECT ptp_int.party_type_code, ptp_int.party_id, rca_int.*
6516: FROM zx_report_codes_assoc_int rca_int, zx_party_tax_profile_int ptp_int
6517: WHERE rca_int.request_id = G_REQUEST_ID
6518: AND rca_int.record_status = G_RS_ERROR
6519: AND ptp_int.intf_ptp_reference = rca_int.intf_ptp_reference
6520: AND ptp_int.request_id = rca_int.request_id;

Line 8207: FROM zx_report_codes_assoc_int

8203: l_msg_header_unit_length,' ');
8204:
8205: SELECT NVL(SUM(DECODE(record_status,G_RS_ERROR,1,0)),0), NVL(SUM(1),0)
8206: INTO l_count_exception_records, l_count_success_records
8207: FROM zx_report_codes_assoc_int
8208: WHERE request_id = G_REQUEST_ID;
8209: l_message_line1 := l_message_line1
8210: || l_tot_records_msg||' '||l_count_success_records;
8211: l_message_line2 := l_message_line2