APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on AMW_CONSTRAINT_ENTRIES

Line 26: -- insert Incompatible Functions/Responsiblities to AMW_CONSTRAINT_ENTRIES

22: -- ===============================================================
23: -- Procedure name
24: -- insert_constraint_entries
25: -- Purpose
26: -- insert Incompatible Functions/Responsiblities to AMW_CONSTRAINT_ENTRIES
27: -- History
28: -- 09.13.2005 tsho: consider group_code, object_type of constraint entries
29: -- ===============================================================
30: procedure insert_constraint_entries(

Line 74: insert into AMW_CONSTRAINT_ENTRIES (

70: FETCH c_resp_appl_id INTO l_application_id;
71: CLOSE c_resp_appl_id;
72: END IF;
73:
74: insert into AMW_CONSTRAINT_ENTRIES (
75: CONSTRAINT_REV_ID,
76: FUNCTION_ID,
77: LAST_UPDATED_BY,
78: LAST_UPDATE_DATE,

Line 117: -- delete Incompatible Functions/Responsiblities from AMW_CONSTRAINT_ENTRIES

113: -- ===============================================================
114: -- Procedure name
115: -- delete_constraint_entries
116: -- Purpose
117: -- delete Incompatible Functions/Responsiblities from AMW_CONSTRAINT_ENTRIES
118: -- for specified constraint_rev_id
119: -- ===============================================================
120: procedure delete_constraint_entries(
121: p_constraint_rev_id IN NUMBER,

Line 130: delete from amw_constraint_entries

126: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
127: BEGIN
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: delete from amw_constraint_entries
131: where constraint_rev_id = p_constraint_rev_id;
132:
133: if (sql%notfound) then
134: raise no_data_found;

Line 1102: ,'AMW_CONSTRAINT_ENTRIES'

1098: || ' '
1099: || SUBSTR (SQLERRM, 1, 100);
1100: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1101: update_interface_with_error (v_err_msg
1102: ,'AMW_CONSTRAINT_ENTRIES'
1103: ,constraint_entries_rec.cst_interface_id);
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106: END LOOP; -- end of for: constraint_entries_rec, RESPSET constraint type

Line 1128: ,'AMW_CONSTRAINT_ENTRIES'

1124: || ' '
1125: || SUBSTR (SQLERRM, 1, 100);
1126: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1127: update_interface_with_error (v_err_msg
1128: ,'AMW_CONSTRAINT_ENTRIES'
1129: ,constraint_entries_rec.cst_interface_id);
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132: END LOOP; -- end of for: constraint_entries_rec, RESPALL, RESPME constraint type

Line 1156: ,'AMW_CONSTRAINT_ENTRIES'

1152: || ' '
1153: || SUBSTR (SQLERRM, 1, 100);
1154: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1155: update_interface_with_error (v_err_msg
1156: ,'AMW_CONSTRAINT_ENTRIES'
1157: ,constraint_entries_rec.cst_interface_id);
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: END IF;
1160: END LOOP; -- end of for: constraint_entries_rec, Function Constraint (SET) type

Line 1181: ,'AMW_CONSTRAINT_ENTRIES'

1177: || ' '
1178: || SUBSTR (SQLERRM, 1, 100);
1179: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1180: update_interface_with_error (v_err_msg
1181: ,'AMW_CONSTRAINT_ENTRIES'
1182: ,constraint_entries_rec.cst_interface_id);
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185: END LOOP; -- end of for: constraint_entries_rec, Function Constraint (ALL, ME) type

Line 1270: ,'AMW_CONSTRAINT_ENTRIES'

1266: || ' '
1267: || SUBSTR (SQLERRM, 1, 100);
1268: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1269: update_interface_with_error (v_err_msg
1270: ,'AMW_CONSTRAINT_ENTRIES'
1271: ,l_interface_id);
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:

Line 1299: ,'AMW_CONSTRAINT_ENTRIES'

1295: || ' '
1296: || SUBSTR (SQLERRM, 1, 100);
1297: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1298: update_interface_with_error (v_err_msg
1299: ,'AMW_CONSTRAINT_ENTRIES'
1300: ,constraint_entries_rec.cst_interface_id);
1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1302: END IF;
1303: END LOOP; -- end of for: constraint_entries_rec, RESPSET constraint type

Line 1325: ,'AMW_CONSTRAINT_ENTRIES'

1321: || ' '
1322: || SUBSTR (SQLERRM, 1, 100);
1323: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1324: update_interface_with_error (v_err_msg
1325: ,'AMW_CONSTRAINT_ENTRIES'
1326: ,constraint_entries_rec.cst_interface_id);
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329: END LOOP; -- end of for: constraint_entries_rec, RESPALL, RESPME constraint type

Line 1353: ,'AMW_CONSTRAINT_ENTRIES'

1349: || ' '
1350: || SUBSTR (SQLERRM, 1, 100);
1351: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1352: update_interface_with_error (v_err_msg
1353: ,'AMW_CONSTRAINT_ENTRIES'
1354: ,constraint_entries_rec.cst_interface_id);
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: END IF;
1357: END LOOP; -- end of for: constraint_entries_rec, Function Constraint (SET) type

Line 1378: ,'AMW_CONSTRAINT_ENTRIES'

1374: || ' '
1375: || SUBSTR (SQLERRM, 1, 100);
1376: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1377: update_interface_with_error (v_err_msg
1378: ,'AMW_CONSTRAINT_ENTRIES'
1379: ,constraint_entries_rec.cst_interface_id);
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1381: END IF;
1382: END LOOP; -- end of for: constraint_entries_rec, Function Constraint (ALL, ME) type