APPS.HZ_IMP_LOAD_CREDITRATINGS_PKG dependencies on HZ_CREDIT_RATINGS

Line 757: * hz_credit_ratings and errors tbl

753: *
754: * DESCRIPTION
755: * processes recs identified for
756: * insertion and does dml on
757: * hz_credit_ratings and errors tbl
758: *
759: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
760: *
761: * MODIFICATION HISTORY

Line 811: into hz_credit_ratings (

807: and max_credit_curr_code_err is not null
808: and action_mismatch_error is not null
809: and createdby_error is not null
810: and missing_parent_err is not null) then
811: into hz_credit_ratings (
812: ACTUAL_CONTENT_SOURCE,
813: application_id,
814: content_source_type,
815: created_by,

Line 1800: * hz_credit_ratings and errors tbl

1796: *
1797: * DESCRIPTION
1798: * processes recs identified for
1799: * updation and does dml on
1800: * hz_credit_ratings and errors tbl
1801: *
1802: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1803: *
1804: * MODIFICATION HISTORY

Line 1998: UPDATE HZ_CREDIT_RATINGS SET

1994: p_prefix =>l_debug_prefix,
1995: p_msg_level=>fnd_log.level_statement);
1996: END IF;
1997: forall j in 1..l_CREDIT_RATING_ID.count
1998: UPDATE HZ_CREDIT_RATINGS SET
1999: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
2000: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
2001: LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,
2002: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,

Line 2217: hz_utility_v2pub.debug(p_message=>'CR:HZ_CREDIT_RATINGS_U1 violated',

2213: IF(P_DUP_VAL_EXP = 'Y') then
2214: other_exp_val := null;
2215: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN
2216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2217: hz_utility_v2pub.debug(p_message=>'CR:HZ_CREDIT_RATINGS_U1 violated',
2218: p_prefix =>l_debug_prefix,
2219: p_msg_level=>fnd_log.level_statement);
2220: END IF;
2221: dup_val_exp_val := 'A';

Line 2224: hz_utility_v2pub.debug(p_message=>'CR:HZ_CREDIT_RATINGS_U2 violated',

2220: END IF;
2221: dup_val_exp_val := 'A';
2222: ELSE -- '_U2'
2223: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2224: hz_utility_v2pub.debug(p_message=>'CR:HZ_CREDIT_RATINGS_U2 violated',
2225: p_prefix =>l_debug_prefix,
2226: p_msg_level=>fnd_log.level_statement);
2227: END IF;
2228: dup_val_exp_val := 'B';