[Home] [Help]
1657: 'HZ_CREATED_BY_MODULES')
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';
2232: E22_FLAG, E23_FLAG, E24_FLAG, E25_FLAG, E26_FLAG, E27_FLAG,
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
2334: select /*+ leading(e) use_nl(int) rowid(int) */ e.creation_date, e.created_by, e.last_update_date, e.last_updated_by, e.last_update_login, e.program_application_id,
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
2494: E3_FLAG, E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG,
2495: E10_FLAG, E11_FLAG, E12_FLAG, E13_FLAG, E14_FLAG, E15_FLAG,
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
2600: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
2601: select /*+ leading(e) use_nl(int) rowid(int) */ e.creation_date, e.created_by, e.last_update_date, e.last_updated_by, e.last_update_login, e.program_application_id,
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
3838: RETURN;
3839: end if;
3840:
3841: /* Save who column values in variables for performance */
3842: l_user_id := NVL(FND_GLOBAL.user_id,-1);
3843: l_resp_appl_id := hz_utility_v2pub.application_id;
3844: l_last_update_login := hz_utility_v2pub.last_update_login;
3845: l_g_miss_num := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_NUM'), -9999);
3846: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');