eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on FND_FILE

Line 107: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

103: v_err_msg :='Error working in procedure: '
104: || L_API_NAME
105: || ' '
106: || SUBSTR (SQLERRM, 1, 100);
107: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
108: END insert_constraint_entries;
109:
110:
111:

Line 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);

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: '

Line 147: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

143: v_err_msg :='Error working in procedure: '
144: || L_API_NAME
145: || ' '
146: || SUBSTR (SQLERRM, 1, 100);
147: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
148: END delete_constraint_entries;
149:
150:
151:

Line 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);

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: '

Line 186: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

182: v_err_msg :='Error working in procedure: '
183: || L_API_NAME
184: || ' '
185: || SUBSTR (SQLERRM, 1, 100);
186: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
187: END delete_constraint_waivers;
188:
189:
190: -- ===============================================================

Line 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);

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: '

Line 242: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

238: v_err_msg :='Error working in procedure: '
239: || L_API_NAME
240: || ' '
241: || SUBSTR (SQLERRM, 1, 100);
242: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
243:
244: END update_violations;
245:
246:

Line 332: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);

328: ||' FROM '||G_AMW_USER ||' u '
329: ||' WHERE u.user_id = :1 ';
330:
331: BEGIN
332: --FND_FILE.put_line(fnd_file.log,'inside api '||L_API_NAME);
333: -- 12.12.2003 tsho: use static sql for AMW for the time being
334: -- 04.30.2004 tsho: enable dynamic sql in AMW.C with 5.10
335: OPEN c_user_dynamic_sql FOR l_user_dynamic_sql USING
336: p_user_id;

Line 387: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

383: 'interface_id: = '
384: || p_interface_id
385: || ' '
386: || SUBSTR (SQLERRM, 1, 100);
387: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
388: END;
389:
390: BEGIN
391: UPDATE amw_constraint_interface

Line 398: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));

394: || p_err_msg
395: || '**'
396: ,error_flag = 'Y'
397: WHERE cst_interface_id = p_interface_id;
398: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));
399: COMMIT;
400: EXCEPTION
401: WHEN OTHERS THEN
402: v_err_msg :=

Line 407: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

403: 'Error during package processing '
404: || ' interface_id: = '
405: || p_interface_id
406: || SUBSTR (SQLERRM, 1, 100);
407: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
408: END;
409:
410: COMMIT;
411: END update_interface_with_error;

Line 517: --fnd_file.put_line(fnd_file.LOG,'Done with AMW_CONSTRAINTS_PKG.INSERT_ROW');

513: X_OBJECTIVE_CODE => p_objective_code -- 09.13.2005 tsho added
514: );
515:
516: x_CONSTRAINT_REV_ID := l_constraint_rev_id;
517: --fnd_file.put_line(fnd_file.LOG,'Done with AMW_CONSTRAINTS_PKG.INSERT_ROW');
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 526: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

522: v_err_msg :='Error working in procedure: '
523: || L_API_NAME
524: || ' '
525: || SUBSTR (SQLERRM, 1, 100);
526: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
527: END insert_constraint;
528:
529:
530:

Line 630: --fnd_file.put_line(fnd_file.LOG,'Done with AMW_CONSTRAINTS_PKG.UPDATE_ROW');

626: X_CLASSIFICATION => l_classification, -- 09.13.2005 tsho added
627: X_OBJECTIVE_CODE => l_objective_code -- 09.13.2005 tsho added
628: );
629:
630: --fnd_file.put_line(fnd_file.LOG,'Done with AMW_CONSTRAINTS_PKG.UPDATE_ROW');
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 639: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

635: v_err_msg :='Error working in procedure: '
636: || L_API_NAME
637: || ' '
638: || SUBSTR (SQLERRM, 1, 100);
639: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
640: END update_constraint;
641:
642:
643: -- ===============================================================

Line 838: --fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);

834:
835: x_return_status VARCHAR2(30);
836:
837: BEGIN
838: --fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
839: --fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: -- use party_id as entered_by_id in AMW_CONSTRAINTS_B

Line 839: --fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);

835: x_return_status VARCHAR2(30);
836:
837: BEGIN
838: --fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
839: --fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: -- use party_id as entered_by_id in AMW_CONSTRAINTS_B
843: l_entered_by_id := Get_Party_Id(p_user_id);

Line 869: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INSUFFICIENT CST ENTRIES UPLOAD FOUND');

865: exception
866: -- found there is not sufficient constraint entries for the same constraint name
867: WHEN E_INV_CST_ENTRIES_UPL THEN
868: BEGIN
869: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INSUFFICIENT CST ENTRIES UPLOAD FOUND');
870:
871: -- ptulasi : 10/11/2007
872: -- bug : 6494262 : Modified the below code to display different messages for set type
873: -- and me type constraint

Line 879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_check_inv_func*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);

875: v_err_msg := AMW_UTILITY_PVT.get_message_text('AMW_CONSTRAINT_UPL_NUM_ERROR');
876: ELSE
877: v_err_msg := AMW_UTILITY_PVT.get_message_text('AMW_CST_FUNCSET_NUM_ERROR');
878: END IF;
879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_check_inv_func*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
880: update_interface_with_error(
881: p_ERR_MSG => v_err_msg
882: ,p_table_name => 'AMW_CONSTRAINTS_B'
883: ,P_INTERFACE_ID => L_INTERFACE_ID);

Line 886: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

882: ,p_table_name => 'AMW_CONSTRAINTS_B'
883: ,P_INTERFACE_ID => L_INTERFACE_ID);
884: EXCEPTION
885: WHEN OTHERS THEN
886: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);
887: END;
888: WHEN NO_DATA_FOUND THEN
889: NULL;
890: end;

Line 903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INSUFFICIENT CST ENTRIES UPLOAD FOUND');

899: exception
900: -- found there is not sufficient constraint entries for the same constraint name
901: WHEN E_INV_CST_ENTRIES_UPL THEN
902: BEGIN
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INSUFFICIENT CST ENTRIES UPLOAD FOUND');
904: -- ptulasi : 10/11/2007
905: -- bug : 6494262 : Modified the below code to display different messages for respset
906: -- type and respme type constraint
907: IF c_inv_resp_rec.cst_type_code = 'RESPME' THEN

Line 912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_check_inv_resp*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);

908: v_err_msg := AMW_UTILITY_PVT.get_message_text('AMW_CONSTRAINT_UPL_NUM_ERROR');
909: ELSE
910: v_err_msg := AMW_UTILITY_PVT.get_message_text('AMW_CST_RESPSET_NUM_ERROR');
911: END IF;
912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_check_inv_resp*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
913: update_interface_with_error(
914: p_ERR_MSG => v_err_msg
915: ,p_table_name => 'AMW_CONSTRAINTS_B'
916: ,P_INTERFACE_ID => L_INTERFACE_ID);

Line 919: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

915: ,p_table_name => 'AMW_CONSTRAINTS_B'
916: ,P_INTERFACE_ID => L_INTERFACE_ID);
917: EXCEPTION
918: WHEN OTHERS THEN
919: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);
920: END;
921: WHEN NO_DATA_FOUND THEN
922: NULL;
923: end;

Line 938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INCONSISTENT CST UPLOAD FOUND' );

934: exception
935: -- found there is not sufficient constraint entries for the same constraint name
936: WHEN E_INCONSIST_CST_UPL THEN
937: BEGIN
938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INCONSISTENT CST UPLOAD FOUND' );
939: v_err_msg := AMW_UTILITY_PVT.get_message_text('AMW_CONSTRAINT_UPL_INCONSIST');
940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_chk_dup_csts*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
941: update_interface_with_error(
942: p_ERR_MSG => v_err_msg

Line 940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_chk_dup_csts*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);

936: WHEN E_INCONSIST_CST_UPL THEN
937: BEGIN
938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INCONSISTENT CST UPLOAD FOUND' );
939: v_err_msg := AMW_UTILITY_PVT.get_message_text('AMW_CONSTRAINT_UPL_INCONSIST');
940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_chk_dup_csts*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
941: update_interface_with_error(
942: p_ERR_MSG => v_err_msg
943: ,p_table_name => 'AMW_CONSTRAINTS_B'
944: ,P_INTERFACE_ID => L_INTERFACE_ID);

Line 947: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

943: ,p_table_name => 'AMW_CONSTRAINTS_B'
944: ,P_INTERFACE_ID => L_INTERFACE_ID);
945: EXCEPTION
946: WHEN OTHERS THEN
947: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);
948: END;
949: WHEN NO_DATA_FOUND THEN
950: NULL;
951: end;

Line 964: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FOUND NON-UNIQUE CONC. PROGRAM ID' );

960: END IF;
961: exception
962: WHEN E_AMBIGUOUS_CP_UPL THEN
963: BEGIN
964: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FOUND NON-UNIQUE CONC. PROGRAM ID' );
965: v_err_msg := 'Concurrent Program ID is not unique. Please create this constraint from Self-Service UI.';
966: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
967: update_interface_with_error(
968: p_ERR_MSG => v_err_msg

Line 966: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);

962: WHEN E_AMBIGUOUS_CP_UPL THEN
963: BEGIN
964: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FOUND NON-UNIQUE CONC. PROGRAM ID' );
965: v_err_msg := 'Concurrent Program ID is not unique. Please create this constraint from Self-Service UI.';
966: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
967: update_interface_with_error(
968: p_ERR_MSG => v_err_msg
969: ,p_table_name => 'AMW_CONSTRAINTS_B'
970: ,P_INTERFACE_ID => L_INTERFACE_ID);

Line 973: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

969: ,p_table_name => 'AMW_CONSTRAINTS_B'
970: ,P_INTERFACE_ID => L_INTERFACE_ID);
971: EXCEPTION
972: WHEN OTHERS THEN
973: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);
974: END;
975: WHEN NO_DATA_FOUND THEN
976: NULL;
977: end;

Line 990: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FOUND NON-UNIQUE RESPONSIBILITY ID' );

986: exception
987: -- found there is not sufficient constraint entries for the same constraint name
988: WHEN E_AMBIGUOUS_RESP_UPL THEN
989: BEGIN
990: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FOUND NON-UNIQUE RESPONSIBILITY ID' );
991: v_err_msg := 'Responsibility ID is not unique. Please create this constraint from Self-Service UI.';
992: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
993: update_interface_with_error(
994: p_ERR_MSG => v_err_msg

Line 992: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);

988: WHEN E_AMBIGUOUS_RESP_UPL THEN
989: BEGIN
990: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FOUND NON-UNIQUE RESPONSIBILITY ID' );
991: v_err_msg := 'Responsibility ID is not unique. Please create this constraint from Self-Service UI.';
992: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
993: update_interface_with_error(
994: p_ERR_MSG => v_err_msg
995: ,p_table_name => 'AMW_CONSTRAINTS_B'
996: ,P_INTERFACE_ID => L_INTERFACE_ID);

Line 999: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

995: ,p_table_name => 'AMW_CONSTRAINTS_B'
996: ,P_INTERFACE_ID => L_INTERFACE_ID);
997: EXCEPTION
998: WHEN OTHERS THEN
999: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);
1000: END;
1001: WHEN NO_DATA_FOUND THEN
1002: NULL;
1003: end;

Line 1039: --fnd_file.put_line(fnd_file.LOG,'processing interface_id = '||l_interface_id);

1035: l_interface_id := constraint_rec.cst_interface_id;
1036: l_constraint_id := NULL;
1037: l_constraint_rev_id := NULL;
1038:
1039: --fnd_file.put_line(fnd_file.LOG,'processing interface_id = '||l_interface_id);
1040:
1041: -- check if the constraint already existed
1042: OPEN c_constraint_exists(constraint_rec.cst_name);
1043: FETCH c_constraint_exists INTO l_constraint_id, l_constraint_rev_id, l_approval_status;

Line 1048: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% Before AMW_LOAD_CONSTRIANT_DATA.insert_constraint %%%%%%%%%%%%');

1044: CLOSE c_constraint_exists;
1045:
1046: IF (l_constraint_id is NULL) THEN
1047: -- create new constraint
1048: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% Before AMW_LOAD_CONSTRIANT_DATA.insert_constraint %%%%%%%%%%%%');
1049: --fnd_file.put_line(fnd_file.LOG,'constraint_rec.cst_name: '||constraint_rec.cst_name);
1050: insert_constraint(
1051: x_return_status => x_return_status,
1052: x_CONSTRAINT_REV_ID => l_constraint_rev_id,

Line 1049: --fnd_file.put_line(fnd_file.LOG,'constraint_rec.cst_name: '||constraint_rec.cst_name);

1045:
1046: IF (l_constraint_id is NULL) THEN
1047: -- create new constraint
1048: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% Before AMW_LOAD_CONSTRIANT_DATA.insert_constraint %%%%%%%%%%%%');
1049: --fnd_file.put_line(fnd_file.LOG,'constraint_rec.cst_name: '||constraint_rec.cst_name);
1050: insert_constraint(
1051: x_return_status => x_return_status,
1052: x_CONSTRAINT_REV_ID => l_constraint_rev_id,
1053: p_START_DATE => constraint_rec.cst_start_date,

Line 1063: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% After AMW_LOAD_CONSTRIANT_DATA.insert_constraint %%%%%%%%%%%%');

1059: p_CONSTRAINT_NAME => constraint_rec.cst_name,
1060: p_CONSTRAINT_DESCRIPTION => constraint_rec.cst_description,
1061: p_user_id => p_user_id
1062: );
1063: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% After AMW_LOAD_CONSTRIANT_DATA.insert_constraint %%%%%%%%%%%%');
1064:
1065: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1066: v_err_msg :='Error working in procedure: '
1067: || L_API_NAME

Line 1070: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1066: v_err_msg :='Error working in procedure: '
1067: || L_API_NAME
1068: || ' '
1069: || SUBSTR (SQLERRM, 1, 100);
1070: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1071: update_interface_with_error (v_err_msg
1072: ,'AMW_CONSTRAINTS'
1073: ,l_interface_id);
1074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1100: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1096: v_err_msg :='Error working in procedure: '
1097: || L_API_NAME
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;

Line 1126: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1122: v_err_msg :='Error working in procedure: '
1123: || L_API_NAME
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;

Line 1154: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1150: v_err_msg :='Error working in procedure: '
1151: || L_API_NAME
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;

Line 1179: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1175: v_err_msg :='Error working in procedure: '
1176: || L_API_NAME
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;

Line 1193: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% Before AMW_LOAD_CONSTRIANT_DATA.update_constraint %%%%%%%%%%%%');

1189: END IF; -- end of if: substr(constraint_rec.cst_type_code,1,4) = 'RESP'
1190:
1191: ELSE
1192: -- update existing constraint with specified constraint_rev_id
1193: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% Before AMW_LOAD_CONSTRIANT_DATA.update_constraint %%%%%%%%%%%%');
1194: --fnd_file.put_line(fnd_file.LOG,'constraint_rec.cst_name: '||constraint_rec.cst_name);
1195: update_constraint(
1196: x_return_status => x_return_status,
1197: p_CONSTRAINT_REV_ID => l_constraint_rev_id,

Line 1194: --fnd_file.put_line(fnd_file.LOG,'constraint_rec.cst_name: '||constraint_rec.cst_name);

1190:
1191: ELSE
1192: -- update existing constraint with specified constraint_rev_id
1193: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% Before AMW_LOAD_CONSTRIANT_DATA.update_constraint %%%%%%%%%%%%');
1194: --fnd_file.put_line(fnd_file.LOG,'constraint_rec.cst_name: '||constraint_rec.cst_name);
1195: update_constraint(
1196: x_return_status => x_return_status,
1197: p_CONSTRAINT_REV_ID => l_constraint_rev_id,
1198: p_START_DATE => constraint_rec.cst_start_date,

Line 1208: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% After AMW_LOAD_CONSTRIANT_DATA.update_constraint %%%%%%%%%%%%');

1204: p_CONSTRAINT_NAME => constraint_rec.cst_name,
1205: p_CONSTRAINT_DESCRIPTION => constraint_rec.cst_description,
1206: p_user_id => p_user_id
1207: );
1208: --fnd_file.put_line(fnd_file.LOG,'%%%%%%%%%%%% After AMW_LOAD_CONSTRIANT_DATA.update_constraint %%%%%%%%%%%%');
1209:
1210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1211: v_err_msg :='Error working in procedure: '
1212: || L_API_NAME

Line 1215: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1211: v_err_msg :='Error working in procedure: '
1212: || L_API_NAME
1213: || ' '
1214: || SUBSTR (SQLERRM, 1, 100);
1215: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1216: update_interface_with_error (v_err_msg
1217: ,'AMW_CONSTRAINTS'
1218: ,l_interface_id);
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1233: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1229: v_err_msg :='Error working in procedure: '
1230: || L_API_NAME
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;

Line 1251: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1247: v_err_msg :='Error working in procedure: '
1248: || L_API_NAME
1249: || ' '
1250: || SUBSTR (SQLERRM, 1, 100);
1251: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1252: update_interface_with_error (v_err_msg
1253: ,'AMW_CONSTRAINT_WAIVERS'
1254: ,l_interface_id);
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1268: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1264: v_err_msg :='Error working in procedure: '
1265: || L_API_NAME
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;

Line 1297: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1293: v_err_msg :='Error working in procedure: '
1294: || L_API_NAME
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;

Line 1323: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1319: v_err_msg :='Error working in procedure: '
1320: || L_API_NAME
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;

Line 1351: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1347: v_err_msg :='Error working in procedure: '
1348: || L_API_NAME
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;

Line 1376: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1372: v_err_msg :='Error working in procedure: '
1373: || L_API_NAME
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;

Line 1417: fnd_file.put_line (fnd_file.LOG,'err in update process flag: '||SUBSTR (SQLERRM, 1, 200));

1413: WHERE batch_id = p_batch_id
1414: AND error_flag IS NULL;
1415: EXCEPTION
1416: WHEN OTHERS THEN
1417: fnd_file.put_line (fnd_file.LOG,'err in update process flag: '||SUBSTR (SQLERRM, 1, 200));
1418: END;
1419: ELSE
1420:
1421: -- delete records from interface table if no error found

Line 1429: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));

1425: WHERE batch_id = p_batch_id
1426: AND error_flag IS NULL;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));
1430: END;
1431: END IF;
1432: END IF; -- end of if: l_amw_delt_constraint_intf
1433:

Line 1439: fnd_file.put_line (fnd_file.LOG, 'Invalid entered_by_id.');

1435: -- invalid entered_by_id
1436: WHEN e_invalid_entered_by_id THEN
1437: BEGIN
1438: v_err_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
1439: fnd_file.put_line (fnd_file.LOG, 'Invalid entered_by_id.');
1440: UPDATE amw_constraint_interface
1441: SET error_flag = 'Y',
1442: interface_status = v_err_msg
1443: WHERE batch_id = p_batch_id;

Line 1446: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_invalid_entered_by_id: '||sqlerrm);

1442: interface_status = v_err_msg
1443: WHERE batch_id = p_batch_id;
1444: EXCEPTION
1445: WHEN OTHERS THEN
1446: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_invalid_entered_by_id: '||sqlerrm);
1447: END;
1448:
1449: -- no import privilege
1450: WHEN e_no_import_access THEN

Line 1453: fnd_file.put_line (fnd_file.LOG, 'no import privilege');

1449: -- no import privilege
1450: WHEN e_no_import_access THEN
1451: BEGIN
1452: v_err_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
1453: fnd_file.put_line (fnd_file.LOG, 'no import privilege');
1454: UPDATE amw_ap_interface
1455: SET error_flag = 'Y',
1456: interface_status = v_err_msg
1457: WHERE batch_id = p_batch_id;

Line 1460: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_no_import_access: '||sqlerrm);

1456: interface_status = v_err_msg
1457: WHERE batch_id = p_batch_id;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_no_import_access: '||sqlerrm);
1461: END;
1462:
1463: -- other exceptions
1464: WHEN others THEN

Line 1466: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in create_constraints: '||sqlerrm);

1462:
1463: -- other exceptions
1464: WHEN others THEN
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;