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.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_TMP_ERRORS

Line 257: insert into hz_imp_tmp_errors

253: OPEN dup_rel(P_BATCH_ID, P_BATCH_MODE_FLAG);
254: FETCH dup_rel BULK COLLECT INTO l_int_row_id, l_table_name, l_err_id;
255:
256: forall j in 1..l_table_name.count
257: insert into hz_imp_tmp_errors
258: (
259: request_id,
260: batch_id,
261: int_row_id,

Line 326: insert into hz_imp_tmp_errors

322: OPEN dup_addr_uses(P_BATCH_ID, P_BATCH_MODE_FLAG);
323: FETCH dup_addr_uses BULK COLLECT INTO l_int_row_id, l_err_id;
324:
325: ForAll j in 1..l_int_row_id.count
326: insert into hz_imp_tmp_errors
327: (
328: request_id,
329: batch_id,
330: int_row_id,

Line 375: insert into hz_imp_tmp_errors

371: OPEN dup_code_assignments(P_BATCH_ID, P_BATCH_MODE_FLAG);
372: FETCH dup_code_assignments BULK COLLECT INTO l_int_row_id, l_err, l_err_id;
373:
374: ForAll j in 1..l_int_row_id.count
375: insert into hz_imp_tmp_errors
376: (
377: request_id,
378: batch_id,
379: int_row_id,

Line 470: from hz_imp_tmp_errors

466: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_DUP_ADDRUSE_IN_INT',
467: 'HZ_IMP_CLASSIFICS_INT', decode(e38_flag, 'M', 'HZ_API_ALLOW_MUL_ASSIGN_FG',
468: 'HZ_IMP_DUP_CLASSIFIC_IN_INT')
469: )
470: from hz_imp_tmp_errors
471: where batch_id = P_BATCH_ID
472: and request_id = P_REQUEST_ID
473: and interface_table_name in ('HZ_IMP_RELSHIPS_INT', 'HZ_IMP_CONTACTS_INT',
474: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_CLASSIFICS_INT');

Line 749: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err

745: AND psosr.owner_table_name = ''HZ_PARTY_SITES''
746: AND psosr.owner_table_id = site_sg.party_site_id
747: AND psosr.party_id <> posr.owner_table_id
748: AND NOT EXISTS
749: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err
750: WHERE err.batch_id = :CP_BATCH_ID
751: AND err.request_id = :REQ_ID
752: AND err.interface_table_name = ''HZ_IMP_ADDRESSES_INT''
753: AND err.int_row_id = site_sg.int_row_id)

Line 775: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err

771: AND cposr.owner_table_name = ''HZ_CONTACT_POINTS''
772: AND cposr.party_id <> posr.owner_table_id
773: AND cpi.rowid = cpt_sg.int_row_id
774: AND NOT EXISTS
775: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err
776: WHERE err.batch_id = :CP_BATCH_ID
777: AND err.request_id = :REQ_ID
778: AND err.interface_table_name = ''HZ_IMP_CONTACTPTS_INT''
779: AND err.int_row_id = cpt_sg.int_row_id)

Line 1269: from hz_imp_tmp_errors

1265: ) IS
1266:
1267: CURSOR c_err(p_batch_id number, p_request_id number) IS
1268: select int_row_id, interface_table_name, error_id
1269: from hz_imp_tmp_errors
1270: where batch_id = p_batch_id
1271: and request_id = p_request_id;
1272:
1273: l_row_id T_ROWID;

Line 1662: from hz_imp_tmp_errors e

1658: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG,
1659: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG, E10_FLAG,
1660: E11_FLAG, DUP_VAL_IDX_EXCEP_FLAG,
1661: ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG, FND_GLOBAL.USER_NAME
1662: from hz_imp_tmp_errors e
1663: where e.batch_id = P_BATCH_ID
1664: and e.request_id = P_REQUEST_ID
1665: and e.interface_table_name = 'HZ_IMP_ADDRESSES_INT';
1666:

Line 1837: from hz_imp_tmp_errors e,

1833: E10_FLAG, E11_FLAG, E12_FLAG, E13_FLAG, E14_FLAG, E15_FLAG, E16_FLAG,
1834: E17_FLAG,
1835: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG,
1836: INT.REPORT_START_DATE, INT.REPORT_END_DATE
1837: from hz_imp_tmp_errors e,
1838: HZ_IMP_FINREPORTS_INT int
1839: where e.batch_id = P_BATCH_ID
1840: and e.request_id = P_REQUEST_ID
1841: and e.int_row_id = int.rowid

Line 1891: from hz_imp_tmp_errors e

1887: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_FINNUMBERS_INT',
1888: 'HZ_IMP_FINREPORT_NOT_FOUND')
1889: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG,
1890: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
1891: from hz_imp_tmp_errors e
1892: where e.batch_id = P_BATCH_ID
1893: and e.request_id = P_REQUEST_ID
1894: and e.interface_table_name = 'HZ_IMP_FINNUMBERS_INT';
1895:

Line 2237: from hz_imp_tmp_errors e,

2233: E28_FLAG, E29_FLAG, E30_FLAG, E31_FLAG, E32_FLAG, E33_FLAG,
2234: E34_FLAG, E35_FLAG, E36_FLAG, E37_FLAG, E38_FLAG, E39_FLAG,
2235: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG,
2236: INT.DATE_OF_BIRTH, INT.DATE_OF_DEATH, FND_GLOBAL.USER_NAME
2237: from hz_imp_tmp_errors e,
2238: HZ_IMP_PARTIES_INT int
2239: where e.batch_id = P_BATCH_ID
2240: and e.request_id = P_REQUEST_ID
2241: and e.int_row_id = int.rowid

Line 2339: from hz_imp_tmp_errors e,

2335: e.program_id, e.program_update_date, e.error_id, e.batch_id, e.request_id, e.interface_table_name, E1_FLAG, E2_FLAG,
2336: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG,
2337: E10_FLAG, E11_FLAG, DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG,
2338: FND_GLOBAL.USER_NAME, INT.START_DATE, INT.END_DATE
2339: from hz_imp_tmp_errors e,
2340: HZ_IMP_RELSHIPS_INT int
2341: where e.batch_id = P_BATCH_ID
2342: and e.request_id = P_REQUEST_ID
2343: and e.int_row_id = int.rowid

Line 2500: from hz_imp_tmp_errors e,

2496: E16_FLAG, E17_FLAG , /* Bug 4156586 */
2497: E18_FLAG, DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG,
2498: FND_GLOBAL.USER_NAME, INT.SUB_ORIG_SYSTEM_REFERENCE,
2499: INT.OBJ_ORIG_SYSTEM_REFERENCE, INT.END_DATE, INT.START_DATE
2500: from hz_imp_tmp_errors e,
2501: HZ_IMP_CONTACTS_INT int
2502: where e.batch_id = P_BATCH_ID
2503: and e.request_id = P_REQUEST_ID
2504: and e.int_row_id = int.rowid

Line 2606: from hz_imp_tmp_errors e,

2602: e.program_id, e.program_update_date, e.error_id, e.batch_id, e.request_id, e.interface_table_name, E2_FLAG, E3_FLAG,
2603: E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG, E10_FLAG,
2604: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG, FND_GLOBAL.USER_NAME,
2605: INT.END_DATE_ACTIVE, INT.START_DATE_ACTIVE
2606: from hz_imp_tmp_errors e,
2607: HZ_IMP_CLASSIFICS_INT int
2608: where e.batch_id = P_BATCH_ID
2609: and e.request_id = P_REQUEST_ID
2610: and e.int_row_id = int.rowid

Line 2907: from hz_imp_tmp_errors e

2903: E23_FLAG, E24_FLAG, E25_FLAG, E26_FLAG, E27_FLAG, E28_FLAG,
2904: E29_FLAG, E30_FLAG, E31_FLAG, E32_FLAG, E33_FLAG,
2905: DUP_VAL_IDX_EXCEP_FLAG,
2906: ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
2907: from hz_imp_tmp_errors e
2908: where e.batch_id = P_BATCH_ID
2909: and e.request_id = P_REQUEST_ID
2910: and e.interface_table_name = 'HZ_IMP_CREDITRTNGS_INT';
2911:

Line 2964: from hz_imp_tmp_errors e

2960: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2961: 'HZ_IMP_ADDR_NOT_FOUND')
2962: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG, E3_FLAG, E4_FLAG,
2963: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
2964: from hz_imp_tmp_errors e
2965: where e.batch_id = P_BATCH_ID
2966: and e.request_id = P_REQUEST_ID
2967: and e.interface_table_name = 'HZ_IMP_ADDRESSUSES_INT';
2968:

Line 3023: from hz_imp_tmp_errors

3019: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CONTACTROLES_INT',
3020: 'HZ_IMP_CONTACT_NOT_FOUND')
3021: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG,
3022: E3_FLAG, DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
3023: from hz_imp_tmp_errors
3024: where batch_id = P_BATCH_ID
3025: and request_id = P_REQUEST_ID
3026: and interface_table_name = 'HZ_IMP_CONTACTROLES_INT';
3027:

Line 3217: from hz_imp_tmp_errors e

3213: E10_FLAG, E11_FLAG, E12_FLAG, E13_FLAG, E15_FLAG,
3214: E16_FLAG, E17_FLAG, E18_FLAG, E19_FLAG, E20_FLAG /* Bug 4079902 */,
3215: E21_FLAG, DUP_VAL_IDX_EXCEP_FLAG,
3216: ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
3217: from hz_imp_tmp_errors e
3218: where e.batch_id = P_BATCH_ID
3219: and request_id = P_REQUEST_ID
3220: and e.interface_table_name = 'HZ_IMP_CONTACTPTS_INT';
3221:

Line 3643: FROM hz_imp_tmp_errors

3639: AND rownum = 1;
3640:
3641: CURSOR c_error(p_batch_id number, p_main_req_id number) IS
3642: SELECT 'Y'
3643: FROM hz_imp_tmp_errors
3644: WHERE batch_id = p_batch_id
3645: and request_id = p_main_req_id
3646: AND rownum = 1;
3647: