APPS.ENG_CHANGE_IMPORT_UTIL dependencies on MTL_INTERFACE_ERRORS

Line 364: -- In R12, MESSAGE_TYPE in MTL_INTERFACE_ERRORS Table

360: END IF ;
361:
362:
363: /***************************************************
364: -- In R12, MESSAGE_TYPE in MTL_INTERFACE_ERRORS Table
365: -- is VARCHAR2(1), so following does not work
366: IF p_msg_type = ERROR OR p_msg_type = SEVERE
367: THEN
368:

Line 808: INSERT INTO MTL_INTERFACE_ERRORS

804: PRAGMA AUTONOMOUS_TRANSACTION;
805:
806: BEGIN
807:
808: INSERT INTO MTL_INTERFACE_ERRORS
809: ( ORGANIZATION_ID
810: , UNIQUE_ID
811: , LAST_UPDATE_DATE
812: , LAST_UPDATED_BY

Line 1213: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';

1209: END IF ;
1210:
1211:
1212: l_dyn_sql := '';
1213: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
1214: l_dyn_sql := l_dyn_sql || '( ';
1215: l_dyn_sql := l_dyn_sql || ' ORGANIZATION_ID , ';
1216: l_dyn_sql := l_dyn_sql || ' UNIQUE_ID , ';
1217: l_dyn_sql := l_dyn_sql || ' TRANSACTION_ID , ';

Line 3024: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';

3020: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3021: l_error_msg := FND_MESSAGE.GET;
3022:
3023: l_dyn_sql := '';
3024: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
3025: l_dyn_sql := l_dyn_sql || '( ';
3026: l_dyn_sql := l_dyn_sql || ' ORGANIZATION_ID , ';
3027: l_dyn_sql := l_dyn_sql || ' UNIQUE_ID , ';
3028: l_dyn_sql := l_dyn_sql || ' TRANSACTION_ID , ';

Line 3427: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';

3423: FND_MESSAGE.SET_TOKEN('BATCH_ID', to_char(p_batch_id));
3424: l_error_msg := FND_MESSAGE.GET;
3425:
3426: l_dyn_sql := '';
3427: l_dyn_sql := 'INSERT INTO MTL_INTERFACE_ERRORS ';
3428: l_dyn_sql := l_dyn_sql || '( ';
3429: l_dyn_sql := l_dyn_sql || ' ORGANIZATION_ID , ';
3430: l_dyn_sql := l_dyn_sql || ' UNIQUE_ID , ';
3431: l_dyn_sql := l_dyn_sql || ' TRANSACTION_ID , ';