1: PACKAGE BODY AMW_LOAD_CONSTRAINT_DATA as
2: /* $Header: amwcstlb.pls 120.9 2007/10/12 11:09:29 ptulasi ship $ */
3:
4: -- ===============================================================
5: -- Package name
2: /* $Header: amwcstlb.pls 120.9 2007/10/12 11:09:29 ptulasi ship $ */
3:
4: -- ===============================================================
5: -- Package name
6: -- AMW_LOAD_CONSTRAINT_DATA
7: -- Purpose
8: --
9: -- History
10: -- 10/01/2004 tsho Creates
135: end if;
136:
137: EXCEPTION
138: WHEN no_data_found THEN
139: fnd_file.put_line (fnd_file.LOG, 'No data found for AMW_LOAD_CONSTRAINT_DATA.delete_constraint_entries: constraint_rev_id = '||p_constraint_rev_id);
140:
141: WHEN OTHERS THEN
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: v_err_msg :='Error working in procedure: '
174: end if;
175:
176: EXCEPTION
177: WHEN no_data_found THEN
178: fnd_file.put_line (fnd_file.LOG, 'No data found for AMW_LOAD_CONSTRAINT_DATA.delete_constraint_waivers: constraint_rev_id = '||p_constraint_rev_id);
179:
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: v_err_msg :='Error working in procedure: '
230: end if;
231:
232: EXCEPTION
233: WHEN no_data_found THEN
234: fnd_file.put_line (fnd_file.LOG, 'No data found for AMW_LOAD_CONSTRAINT_DATA.update_violations: constraint_rev_id = '||p_constraint_rev_id);
235:
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: v_err_msg :='Error working in procedure: '
1465: rollback;
1466: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in create_constraints: '||sqlerrm);
1467: END create_constraints;
1468: -- ----------------------------------------------------------------------
1469: END AMW_LOAD_CONSTRAINT_DATA;