APPS.CSD_MIGRATE_FROM_115X_PKG4 dependencies on CSD_GENERIC_ERRMSGS

Line 9: /* description : procedure for migrating CSD_GENERIC_ERRMSGS table data */

5: /*-------------------------------------------------------------------------------*/
6:
7: /* procedure name: CSD_GENERIC_MESSAGES_MIG4 */
8:
9: /* description : procedure for migrating CSD_GENERIC_ERRMSGS table data */
10:
11: /* from 11.5.9 to 11.5.10 */
12:
13: /* */

Line 81: FROM CSD_GENERIC_ERRMSGS

77: FROM csd_mass_ro_sn_errors;
78:
79: CURSOR cur_check_exists(p_rep_line_id NUMBER, p_id2 NUMBER) IS
80: SELECT 'x'
81: FROM CSD_GENERIC_ERRMSGS
82: WHERE MODULE_CODE ='SN'
83: AND SOURCE_ENTITY_ID1= p_rep_line_id
84: AND SOURCE_ENTITY_ID2 = p_id2
85: AND SOURCE_ENTITY_TYPE_CODE = 'SERIAL_NUMBER';

Line 129: APPS.CSD_GENERIC_ERRMSGS_PKG.INSERT_ROW(PX_GENERIC_ERRMSGS_ID => l_generic_errmsgs_id,

125: parameter. Without re initialization it would retain the value from last call and
126: would cause the unique constraint violation error.
127: */
128: l_generic_errmsgs_id :=NULL;
129: APPS.CSD_GENERIC_ERRMSGS_PKG.INSERT_ROW(PX_GENERIC_ERRMSGS_ID => l_generic_errmsgs_id,
130: P_MODULE_CODE => 'SN',
131: --P_SOURCE_ENTITY_ID1 => sn_errors_arr(j).repair_line_id,
132: P_SOURCE_ENTITY_ID1 => repair_line_id_arr(j),
133: --P_SOURCE_ENTITY_ID2 => sn_errors_arr(j).mass_ro_sn_id,

Line 171: 'CSD_GENERIC_ERRMSGS',

167: UPGRADE_DATETIME,
168: ERROR_MESSAGE,
169: MIGRATION_PHASE)
170: VALUES ('CSD_MASS_RO_SN_ERRORS',
171: 'CSD_GENERIC_ERRMSGS',
172: --sn_errors_arr(j).mass_ro_sn_error_id,
173: mrs_error_id_arr(j),
174: sysdate,
175: v_error_text,

Line 180: raise_application_error( -20000, 'Error while migrating CSD_GENERIC_ERRMSGS table data: Error while inserting into CSD_GENERIC_ERRMSGS. '|| v_error_text);

176: '11.5.10');
177:
178: commit;
179:
180: raise_application_error( -20000, 'Error while migrating CSD_GENERIC_ERRMSGS table data: Error while inserting into CSD_GENERIC_ERRMSGS. '|| v_error_text);
181:
182: END;
183: END LOOP;
184: COMMIT;