APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on AMW_VIOLATIONS

Line 194: -- update violations' status in AMW_VIOLATIONS

190: -- ===============================================================
191: -- Private Procedure name
192: -- update_violations
193: -- Purpose
194: -- update violations' status in AMW_VIOLATIONS
195: -- for specified constraint_rev_id
196: -- Params
197: -- p_constraint_rev_id := specified constraint_rev_id
198: -- p_violation_status := new violation status

Line 200: -- this is to update the status_code in AMW_VIOLATIONS

196: -- Params
197: -- p_constraint_rev_id := specified constraint_rev_id
198: -- p_violation_status := new violation status
199: -- Notes
200: -- this is to update the status_code in AMW_VIOLATIONS
201: -- if p_violation_status = null, then use default 'NA' (Not Applicable)
202: -- ===============================================================
203: PROCEDURE update_violations (
204: x_return_status OUT NOCOPY VARCHAR2,

Line 224: UPDATE amw_violations

220: IF (p_violation_status is not NULL) THEN
221: l_violation_status := p_violation_status;
222: END IF;
223:
224: UPDATE amw_violations
225: SET status_code = l_violation_status
226: WHERE constraint_rev_id = p_constraint_rev_id;
227:
228: if (sql%notfound) then

Line 1235: ,'AMW_VIOLATIONS'

1231: || ' '
1232: || SUBSTR (SQLERRM, 1, 100);
1233: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1234: update_interface_with_error (v_err_msg
1235: ,'AMW_VIOLATIONS'
1236: ,l_interface_id);
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: END IF;
1239: