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_SOD_DATA dependencies on FND_FILE

Line 149: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstfunc_rec.cst_interface_id );

145:
146: for cstfunc_rec in invalid_func LOOP
147: v_error_msg := 'Not a valid Incompatible Function';
148: update_interface_with_error(v_error_msg,cstfunc_rec.cst_interface_id);
149: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstfunc_rec.cst_interface_id );
150: end loop;
151:
152: for cstresp_rec in invalid_resp LOOP
153: v_error_msg := 'Not a valid Incompatible Responsibility';

Line 155: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstresp_rec.cst_interface_id );

151:
152: for cstresp_rec in invalid_resp LOOP
153: v_error_msg := 'Not a valid Incompatible Responsibility';
154: update_interface_with_error(v_error_msg,cstresp_rec.cst_interface_id);
155: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstresp_rec.cst_interface_id );
156: end loop;
157:
158: for typecode_rec in invalid_type_code LOOP
159: v_error_msg := 'Not a valid Constraint Type Code';

Line 161: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || typecode_rec.cst_interface_id );

157:
158: for typecode_rec in invalid_type_code LOOP
159: v_error_msg := 'Not a valid Constraint Type Code';
160: update_interface_with_error(v_error_msg,typecode_rec.cst_interface_id);
161: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || typecode_rec.cst_interface_id );
162: end loop;
163:
164: for cstresptype_rec in invalid_resptype LOOP
165: if cstresptype_rec.cst_entries_resp_id is null then

Line 172: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstresptype_rec.cst_interface_id );

168: v_error_msg := 'Object type is for Responsibility. But function is defined';
169: end if;
170: end if;
171: update_interface_with_error(v_error_msg,cstresptype_rec.cst_interface_id);
172: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstresptype_rec.cst_interface_id );
173: end loop;
174:
175: for cstfunctype_rec in invalid_functype LOOP
176: if cstfunctype_rec.cst_entries_function_id is null then

Line 183: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstfunctype_rec.cst_interface_id );

179: v_error_msg := 'Object type is for Function. But responsibility is defined';
180: end if;
181: end if;
182: update_interface_with_error(v_error_msg,cstfunctype_rec.cst_interface_id);
183: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || cstfunctype_rec.cst_interface_id );
184: end loop;
185:
186: for objtype_rec in invalid_obj_type LOOP
187: v_error_msg := 'Not a valid Constraint Object Type';

Line 189: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || objtype_rec.cst_interface_id );

185:
186: for objtype_rec in invalid_obj_type LOOP
187: v_error_msg := 'Not a valid Constraint Object Type';
188: update_interface_with_error(v_error_msg,objtype_rec.cst_interface_id);
189: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || objtype_rec.cst_interface_id );
190: end loop;
191:
192: for grpcode_rec in invalid_group_code LOOP
193: v_error_msg := 'Not a valid Constraint Function Set';

Line 195: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || grpcode_rec.cst_interface_id );

191:
192: for grpcode_rec in invalid_group_code LOOP
193: v_error_msg := 'Not a valid Constraint Function Set';
194: update_interface_with_error(v_error_msg,grpcode_rec.cst_interface_id);
195: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || grpcode_rec.cst_interface_id );
196: end loop;
197:
198: IF (v_error_msg is NULL OR v_error_msg = NULL) THEN
199: AMW_LOAD_CONSTRAINT_DATA.create_constraints

Line 209: fnd_file.put_line (fnd_file.LOG, 'After Calling the webadi procedure');

205: errbuf := v_error_msg;
206: retcode := v_err_msg;
207: END IF;
208:
209: fnd_file.put_line (fnd_file.LOG, 'After Calling the webadi procedure');
210: EXCEPTION
211: WHEN OTHERS
212: THEN
213: v_err_msg := 'Error during package processing '

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

211: WHEN OTHERS
212: THEN
213: v_err_msg := 'Error during package processing '
214: || SUBSTR (SQLERRM, 1, 100);
215: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
216: END;
217:
218: END insert_data;
219: --

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

245: WHEN OTHERS
246: THEN
247: v_err_msg := 'Error during package processing ' || ' interface_id: = '
248: || p_interface_id || SUBSTR (SQLERRM, 1, 100);
249: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
250: END;
251:
252:
253: END update_interface_with_error;

Line 787: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldcst_rec.interface_id);

783: FOR invldcst_rec IN c_invld_cst_name_batch
784: LOOP
785: v_error_msg := 'Invalid Constraint Name ';
786: update_waiver_intf_with_error(v_error_msg,invldcst_rec.interface_id);
787: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldcst_rec.interface_id);
788: END LOOP;
789:
790: -- ptulasi : 06/01/2007 : Bug 6067714 :
791: -- Update all the invalid start date in amw_cst_waiver_interface

Line 806: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldrespcst_rec.interface_id);

802: FOR invldrespcst_rec IN c_invalid_resp_cst_batch
803: LOOP
804: v_error_msg := 'Responsibility Type Constraint cannot have Responsibility waivers';
805: update_waiver_intf_with_error(v_error_msg,invldrespcst_rec.interface_id);
806: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldrespcst_rec.interface_id);
807: END LOOP;
808:
809: /*
810: Identify the invalid user waiver

Line 816: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invlduser_rec.interface_id);

812: FOR invlduser_rec IN c_invalid_user_waiver_batch
813: LOOP
814: v_error_msg := 'Invalid User Name ';
815: update_waiver_intf_with_error(v_error_msg,invlduser_rec.interface_id);
816: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invlduser_rec.interface_id);
817: END LOOP;
818:
819: /*
820: Identify the invalid responsibility waiver

Line 826: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldresp_rec.interface_id);

822: FOR invldresp_rec IN c_invalid_resp_waiver_batch
823: LOOP
824: v_error_msg := 'Invalid Application Short Name/Responsibility Name ';
825: update_waiver_intf_with_error(v_error_msg,invldresp_rec.interface_id);
826: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldresp_rec.interface_id);
827: END LOOP;
828:
829: /* Commenting this check as the customer may populate the constraint waiver
830: interface and the run the concurren ptogram on different days

Line 836: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldstdate_rec.interface_id);

832: FOR invldstdate_rec IN c_invalid_start_date_batch
833: LOOP
834: v_error_msg := 'The Start Date should be greater than or equal to System Date';
835: update_waiver_intf_with_error(v_error_msg,invldstdate_rec.interface_id);
836: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldstdate_rec.interface_id);
837: END LOOP;
838: */
839:
840: /*

Line 847: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldenddate_rec.interface_id);

843: FOR invldenddate_rec IN c_invalid_end_date_batch
844: LOOP
845: v_error_msg := 'The End Date should not be less than System date/Start Date';
846: update_waiver_intf_with_error(v_error_msg,invldenddate_rec.interface_id);
847: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldenddate_rec.interface_id);
848: END LOOP;
849:
850: /*
851: Identify the duplicate user waivers

Line 859: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || dupuserwaiv_rec.interface_id);

855: v_error_msg := 'The User Wiaver is either defined more than once '
856: ||' in the interface table for the constraint / It is allready defined '
857: ||' in the constraint';
858: update_waiver_intf_with_error(v_error_msg,dupuserwaiv_rec.interface_id);
859: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || dupuserwaiv_rec.interface_id);
860: END LOOP;
861:
862: /*
863: Identify the duplicate responsibility waivers

Line 871: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || duprespwaiv_rec.interface_id);

867: v_error_msg := 'The Responsibility Wiaver is either defined more than once '
868: ||' in the interface table for the constraint / It is allready defined '
869: ||' in the constraint ';
870: update_waiver_intf_with_error(v_error_msg,duprespwaiv_rec.interface_id);
871: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || duprespwaiv_rec.interface_id);
872: END LOOP;
873:
874: /*
875: Should not upload the constraint waivers for a constraint, if any waiver

Line 1155: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldcst_rec.interface_id);

1151: FOR invldcst_rec IN c_invld_cst_name
1152: LOOP
1153: v_error_msg := 'Invalid Constraint Name ';
1154: update_waiver_intf_with_error(v_error_msg,invldcst_rec.interface_id);
1155: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldcst_rec.interface_id);
1156: END LOOP;
1157:
1158: -- ptulasi : 06/01/2007 : Bug 6067714 :
1159: -- Update all the invalid start date in amw_cst_waiver_interface

Line 1174: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldrespcst_rec.interface_id);

1170: FOR invldrespcst_rec IN c_invalid_resp_cst
1171: LOOP
1172: v_error_msg := 'Responsibility Type Constraint cannot have Responsibility waivers';
1173: update_waiver_intf_with_error(v_error_msg,invldrespcst_rec.interface_id);
1174: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldrespcst_rec.interface_id);
1175: END LOOP;
1176:
1177: /*
1178: Identify the invalid user waiver

Line 1184: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invlduser_rec.interface_id);

1180: FOR invlduser_rec IN c_invalid_user_waiver
1181: LOOP
1182: v_error_msg := 'Invalid User Name ';
1183: update_waiver_intf_with_error(v_error_msg,invlduser_rec.interface_id);
1184: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invlduser_rec.interface_id);
1185: END LOOP;
1186:
1187: /*
1188: Identify the invalid responsibility waiver

Line 1194: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldresp_rec.interface_id);

1190: FOR invldresp_rec IN c_invalid_resp_waiver
1191: LOOP
1192: v_error_msg := 'Invalid Application Short Name/Responsibility Name ';
1193: update_waiver_intf_with_error(v_error_msg,invldresp_rec.interface_id);
1194: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldresp_rec.interface_id);
1195: END LOOP;
1196:
1197: /*
1198: Commenting this check as the customer may populate the constraint waiver

Line 1206: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldstdate_rec.interface_id);

1202: FOR invldstdate_rec IN c_invalid_start_date
1203: LOOP
1204: v_error_msg := 'The Start Date should be greater than or equal to System Date';
1205: update_waiver_intf_with_error(v_error_msg,invldstdate_rec.interface_id);
1206: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldstdate_rec.interface_id);
1207: END LOOP; */
1208:
1209: /*
1210: Identify the invalid end_date

Line 1216: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldenddate_rec.interface_id);

1212: FOR invldenddate_rec IN c_invalid_end_date
1213: LOOP
1214: v_error_msg := 'The End Date should not be less than System date/Start Date';
1215: update_waiver_intf_with_error(v_error_msg,invldenddate_rec.interface_id);
1216: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || invldenddate_rec.interface_id);
1217: END LOOP;
1218:
1219: /*
1220: Identify the duplicate user waivers

Line 1228: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || dupuserwaiv_rec.interface_id);

1224: v_error_msg := 'The User Wiaver is either defined more than once '
1225: ||' in the interface table for the constraint / It is allready defined '
1226: ||' in the constraint';
1227: update_waiver_intf_with_error(v_error_msg,dupuserwaiv_rec.interface_id);
1228: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || dupuserwaiv_rec.interface_id);
1229: END LOOP;
1230:
1231: /*
1232: Identify the duplicate responsibility waivers

Line 1240: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || duprespwaiv_rec.interface_id);

1236: v_error_msg := 'The Responsibility Wiaver is either defined more than once '
1237: ||' in the interface table for the constraint / It is allready defined '
1238: ||' in the constraint ';
1239: update_waiver_intf_with_error(v_error_msg,duprespwaiv_rec.interface_id);
1240: fnd_file.put_line (fnd_file.LOG, v_error_msg || ' for interface id ' || duprespwaiv_rec.interface_id);
1241: END LOOP;
1242:
1243: /*
1244: Should not upload the constraint waivers for a constraint, if any waiver

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

1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: ROLLBACK;
1366: v_err_msg := 'Error during package processing '||SUBSTR (SQLERRM, 1, 100);
1367: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1368: END create_constraint_waivers;
1369:
1370: -- ===============================================================
1371: -- Procedure name

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

1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: v_err_msg := 'Error during package processing ' || ' interface_id: = '
1403: || p_interface_id || SUBSTR (SQLERRM, 1, 100);
1404: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1405:
1406: END update_waiver_intf_with_error;
1407:
1408: -- ===============================================================

Line 1555: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1551: AND (resp.END_DATE >= SYSDATE or resp.END_DATE IS NULL)
1552: AND resp.RESPONSIBILITY_ID=acwb.PK1);
1553:
1554: BEGIN
1555: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1556: fnd_file.put_line(fnd_file.LOG,'| |');
1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1558: fnd_file.put_line(fnd_file.LOG,'| |');
1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1556: fnd_file.put_line(fnd_file.LOG,'| |');

1552: AND resp.RESPONSIBILITY_ID=acwb.PK1);
1553:
1554: BEGIN
1555: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1556: fnd_file.put_line(fnd_file.LOG,'| |');
1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1558: fnd_file.put_line(fnd_file.LOG,'| |');
1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1560: fnd_file.put_line(fnd_file.LOG,'Please Re-Run the violation check for Constraints');

Line 1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');

1553:
1554: BEGIN
1555: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1556: fnd_file.put_line(fnd_file.LOG,'| |');
1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1558: fnd_file.put_line(fnd_file.LOG,'| |');
1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1560: fnd_file.put_line(fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1561:

Line 1558: fnd_file.put_line(fnd_file.LOG,'| |');

1554: BEGIN
1555: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1556: fnd_file.put_line(fnd_file.LOG,'| |');
1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1558: fnd_file.put_line(fnd_file.LOG,'| |');
1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1560: fnd_file.put_line(fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1561:
1562: l_cst_rev_id_list.delete();

Line 1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1555: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1556: fnd_file.put_line(fnd_file.LOG,'| |');
1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1558: fnd_file.put_line(fnd_file.LOG,'| |');
1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1560: fnd_file.put_line(fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1561:
1562: l_cst_rev_id_list.delete();
1563: l_cst_name_list.delete();

Line 1560: fnd_file.put_line(fnd_file.LOG,'Please Re-Run the violation check for Constraints');

1556: fnd_file.put_line(fnd_file.LOG,'| |');
1557: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1558: fnd_file.put_line(fnd_file.LOG,'| |');
1559: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1560: fnd_file.put_line(fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1561:
1562: l_cst_rev_id_list.delete();
1563: l_cst_name_list.delete();
1564: l_resp_id_list.delete();

Line 1576: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');

1572:
1573: IF ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1574: FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1575: LOOP
1576: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1577: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1578: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));
1579:
1580: l_appl_id_list.delete();

Line 1577: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));

1573: IF ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1574: FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1575: LOOP
1576: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1577: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1578: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));
1579:
1580: l_appl_id_list.delete();
1581: l_resp_name_list.delete();

Line 1578: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));

1574: FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1575: LOOP
1576: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1577: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1578: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));
1579:
1580: l_appl_id_list.delete();
1581: l_resp_name_list.delete();
1582: l_appl_name_list.delete();

Line 1597: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));

1593: AND RESP.APPLICATION_ID=APPL.APPLICATION_ID;
1594: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1595: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1596: LOOP
1597: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1598: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1599: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));
1600: END LOOP;
1601: END IF;

Line 1598: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));

1594: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1595: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1596: LOOP
1597: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1598: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1599: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));
1600: END LOOP;
1601: END IF;
1602: END LOOP;

Line 1599: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));

1595: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1596: LOOP
1597: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1598: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1599: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));
1600: END LOOP;
1601: END IF;
1602: END LOOP;
1603: END IF;

Line 1604: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1600: END LOOP;
1601: END IF;
1602: END LOOP;
1603: END IF;
1604: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1605: fnd_file.put_line(fnd_file.LOG,'| |');
1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1605: fnd_file.put_line(fnd_file.LOG,'| |');

1601: END IF;
1602: END LOOP;
1603: END IF;
1604: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1605: fnd_file.put_line(fnd_file.LOG,'| |');
1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:

Line 1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');

1602: END LOOP;
1603: END IF;
1604: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1605: fnd_file.put_line(fnd_file.LOG,'| |');
1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1607: fnd_file.put_line(fnd_file.LOG,'| |');

1603: END IF;
1604: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1605: fnd_file.put_line(fnd_file.LOG,'| |');
1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');

Line 1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1604: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1605: fnd_file.put_line(fnd_file.LOG,'| |');
1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');
1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');

Line 1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1606: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_USER_ENTRIES.APPLICATION_ID |');
1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');
1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1613: fnd_file.put_line(fnd_file.LOG,'| |');
1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1611: fnd_file.put_line(fnd_file.LOG,'| |');

1607: fnd_file.put_line(fnd_file.LOG,'| |');
1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');
1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1613: fnd_file.put_line(fnd_file.LOG,'| |');
1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1615:

Line 1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');

1608: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');
1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1613: fnd_file.put_line(fnd_file.LOG,'| |');
1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1615:
1616: -- Data fix for AMW_CONSTRAINT_ENTRIES

Line 1613: fnd_file.put_line(fnd_file.LOG,'| |');

1609:
1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');
1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1613: fnd_file.put_line(fnd_file.LOG,'| |');
1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1615:
1616: -- Data fix for AMW_CONSTRAINT_ENTRIES
1617: -- Cleaning the lists

Line 1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1610: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1611: fnd_file.put_line(fnd_file.LOG,'| |');
1612: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1613: fnd_file.put_line(fnd_file.LOG,'| |');
1614: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1615:
1616: -- Data fix for AMW_CONSTRAINT_ENTRIES
1617: -- Cleaning the lists
1618: l_cst_rev_id_list.delete();

Line 1623: fnd_file.put_line (fnd_file.LOG,'Please Manaully verify the following Constraints ');

1619: l_cst_name_list.delete();
1620: l_function_id_list.delete();
1621: l_object_type_list.delete();
1622:
1623: fnd_file.put_line (fnd_file.LOG,'Please Manaully verify the following Constraints ');
1624:
1625: OPEN c_cst_entries;
1626: FETCH c_cst_entries
1627: BULK COLLECT INTO l_cst_rev_id_list,

Line 1636: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');

1632:
1633: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1634: FOR i IN l_function_id_list.FIRST .. l_function_id_list.LAST
1635: LOOP
1636: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1637: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1638:
1639: IF l_object_type_list(i)='RESP' THEN
1640: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));

Line 1637: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));

1633: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1634: FOR i IN l_function_id_list.FIRST .. l_function_id_list.LAST
1635: LOOP
1636: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1637: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1638:
1639: IF l_object_type_list(i)='RESP' THEN
1640: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1641: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities to be included in the contraint : ');

Line 1640: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));

1636: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1637: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1638:
1639: IF l_object_type_list(i)='RESP' THEN
1640: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1641: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities to be included in the contraint : ');
1642:
1643: -- Clear the List
1644: l_appl_id_list.delete();

Line 1641: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities to be included in the contraint : ');

1637: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1638:
1639: IF l_object_type_list(i)='RESP' THEN
1640: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1641: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities to be included in the contraint : ');
1642:
1643: -- Clear the List
1644: l_appl_id_list.delete();
1645: l_appl_name_list.delete();

Line 1663: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));

1659:
1660: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1661: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1662: LOOP
1663: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1664: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1665: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1666: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');

Line 1664: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));

1660: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1661: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1662: LOOP
1663: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1664: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1665: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1666: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');
1668: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));

Line 1665: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));

1661: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1662: LOOP
1663: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1664: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1665: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1666: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');
1668: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1669: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));

Line 1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');

1663: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1664: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1665: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1666: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');
1668: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1669: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1670: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1671: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN

Line 1668: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));

1664: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1665: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1666: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');
1668: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1669: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1670: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1671: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1672: ELSE

Line 1669: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));

1665: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1666: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');
1668: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1669: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1670: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1671: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1672: ELSE
1673: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));

Line 1670: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));

1666: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1667: fnd_file.put_line(fnd_file.LOG,'Responsibility automatically migrated for the Constraint : ');
1668: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1669: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1670: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1671: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1672: ELSE
1673: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1674: fnd_file.put_line(fnd_file.LOG,'Possible Conc. Programs to be included in the Contraint : ');

Line 1673: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));

1669: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1670: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1671: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1672: ELSE
1673: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1674: fnd_file.put_line(fnd_file.LOG,'Possible Conc. Programs to be included in the Contraint : ');
1675:
1676: l_appl_id_list.delete();
1677: l_cp_name_list.delete();

Line 1674: fnd_file.put_line(fnd_file.LOG,'Possible Conc. Programs to be included in the Contraint : ');

1670: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1671: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1672: ELSE
1673: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1674: fnd_file.put_line(fnd_file.LOG,'Possible Conc. Programs to be included in the Contraint : ');
1675:
1676: l_appl_id_list.delete();
1677: l_cp_name_list.delete();
1678: l_appl_name_list.delete();

Line 1694: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));

1690:
1691: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1692: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1693: LOOP
1694: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1695: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1696: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1697: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1698:

Line 1695: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));

1691: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1692: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1693: LOOP
1694: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1695: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1696: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1697: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1698:
1699: fnd_file.put_line(fnd_file.LOG,'Concurrent Program automatically migrated for the Constraint : ');

Line 1696: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));

1692: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1693: LOOP
1694: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1695: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1696: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1697: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1698:
1699: fnd_file.put_line(fnd_file.LOG,'Concurrent Program automatically migrated for the Constraint : ');
1700: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(1));

Line 1699: fnd_file.put_line(fnd_file.LOG,'Concurrent Program automatically migrated for the Constraint : ');

1695: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1696: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1697: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1698:
1699: fnd_file.put_line(fnd_file.LOG,'Concurrent Program automatically migrated for the Constraint : ');
1700: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(1));
1701: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1702: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1703: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN

Line 1700: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(1));

1696: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1697: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1698:
1699: fnd_file.put_line(fnd_file.LOG,'Concurrent Program automatically migrated for the Constraint : ');
1700: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(1));
1701: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1702: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1703: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1704: END IF; -- IF l_object_type_list(i)='RESP' THEN

Line 1701: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));

1697: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1698:
1699: fnd_file.put_line(fnd_file.LOG,'Concurrent Program automatically migrated for the Constraint : ');
1700: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(1));
1701: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1702: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1703: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1704: END IF; -- IF l_object_type_list(i)='RESP' THEN
1705: END LOOP; -- FOR i IN l_function_id_list.FIRST .. l_function_id_list.LAST

Line 1702: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));

1698:
1699: fnd_file.put_line(fnd_file.LOG,'Concurrent Program automatically migrated for the Constraint : ');
1700: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(1));
1701: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1702: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1703: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1704: END IF; -- IF l_object_type_list(i)='RESP' THEN
1705: END LOOP; -- FOR i IN l_function_id_list.FIRST .. l_function_id_list.LAST
1706: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN

Line 1708: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1704: END IF; -- IF l_object_type_list(i)='RESP' THEN
1705: END LOOP; -- FOR i IN l_function_id_list.FIRST .. l_function_id_list.LAST
1706: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1707:
1708: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1709: fnd_file.put_line(fnd_file.LOG,'| |');
1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1709: fnd_file.put_line(fnd_file.LOG,'| |');

1705: END LOOP; -- FOR i IN l_function_id_list.FIRST .. l_function_id_list.LAST
1706: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1707:
1708: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1709: fnd_file.put_line(fnd_file.LOG,'| |');
1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:

Line 1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');

1706: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1707:
1708: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1709: fnd_file.put_line(fnd_file.LOG,'| |');
1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1711: fnd_file.put_line(fnd_file.LOG,'| |');

1707:
1708: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1709: fnd_file.put_line(fnd_file.LOG,'| |');
1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');

Line 1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1708: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1709: fnd_file.put_line(fnd_file.LOG,'| |');
1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');
1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');

Line 1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1710: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_ENTRIES.APPLICATION_ID |');
1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');
1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');
1717: fnd_file.put_line(fnd_file.LOG,'| |');
1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1715: fnd_file.put_line(fnd_file.LOG,'| |');

1711: fnd_file.put_line(fnd_file.LOG,'| |');
1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');
1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');
1717: fnd_file.put_line(fnd_file.LOG,'| |');
1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1719:

Line 1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');

1712: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');
1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');
1717: fnd_file.put_line(fnd_file.LOG,'| |');
1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1719:
1720: fnd_file.put_line (fnd_file.LOG,'Please Re-Run the violation check for Constraints');

Line 1717: fnd_file.put_line(fnd_file.LOG,'| |');

1713:
1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');
1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');
1717: fnd_file.put_line(fnd_file.LOG,'| |');
1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1719:
1720: fnd_file.put_line (fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1721:

Line 1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1714: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1715: fnd_file.put_line(fnd_file.LOG,'| |');
1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');
1717: fnd_file.put_line(fnd_file.LOG,'| |');
1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1719:
1720: fnd_file.put_line (fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1721:
1722: -- Data fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID

Line 1720: fnd_file.put_line (fnd_file.LOG,'Please Re-Run the violation check for Constraints');

1716: fnd_file.put_line(fnd_file.LOG,'|Starting Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID|');
1717: fnd_file.put_line(fnd_file.LOG,'| |');
1718: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1719:
1720: fnd_file.put_line (fnd_file.LOG,'Please Re-Run the violation check for Constraints');
1721:
1722: -- Data fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID
1723: -- Clear the List
1724: l_cst_rev_id_list.delete();

Line 1737: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');

1733:
1734: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1735: FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1736: LOOP
1737: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1738: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1739: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1740:
1741: l_appl_id_list.delete();

Line 1738: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));

1734: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1735: FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1736: LOOP
1737: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1738: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1739: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1740:
1741: l_appl_id_list.delete();
1742: l_cp_name_list.delete();

Line 1739: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));

1735: FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1736: LOOP
1737: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1738: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1739: fnd_file.put_line(fnd_file.LOG,'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1740:
1741: l_appl_id_list.delete();
1742: l_cp_name_list.delete();
1743: l_appl_name_list.delete();

Line 1758: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));

1754:
1755: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1756: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1757: LOOP
1758: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1759: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1760: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));
1761: END LOOP;
1762: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN

Line 1759: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));

1755: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1756: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1757: LOOP
1758: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1759: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1760: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));
1761: END LOOP;
1762: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1763: END LOOP; -- FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST

Line 1760: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));

1756: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1757: LOOP
1758: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1759: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1760: fnd_file.put_line(fnd_file.LOG,' Application_Id : '||l_appl_id_list(k));
1761: END LOOP;
1762: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1763: END LOOP; -- FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1764: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN

Line 1766: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1762: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1763: END LOOP; -- FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1764: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1765:
1766: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1767: fnd_file.put_line(fnd_file.LOG,'| |');
1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');
1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1767: fnd_file.put_line(fnd_file.LOG,'| |');

1763: END LOOP; -- FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1764: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1765:
1766: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1767: fnd_file.put_line(fnd_file.LOG,'| |');
1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');
1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:

Line 1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');

1764: END IF; -- IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1765:
1766: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1767: fnd_file.put_line(fnd_file.LOG,'| |');
1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');
1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1769: fnd_file.put_line(fnd_file.LOG,'| |');

1765:
1766: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1767: fnd_file.put_line(fnd_file.LOG,'| |');
1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');
1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');

Line 1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1766: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1767: fnd_file.put_line(fnd_file.LOG,'| |');
1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');
1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');
1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');

Line 1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1768: fnd_file.put_line(fnd_file.LOG,'| Ending Data Fix for AMW_VIOLAT_USER_ENTRIES.PROGRAM_APPLICATION_ID |');
1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');
1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1775: fnd_file.put_line(fnd_file.LOG,'| |');
1776: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1773: fnd_file.put_line(fnd_file.LOG,'| |');

1769: fnd_file.put_line(fnd_file.LOG,'| |');
1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');
1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1775: fnd_file.put_line(fnd_file.LOG,'| |');
1776: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1777:

Line 1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');

1770: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');
1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1775: fnd_file.put_line(fnd_file.LOG,'| |');
1776: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1777:
1778: -- Clear the list

Line 1775: fnd_file.put_line(fnd_file.LOG,'| |');

1771:
1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');
1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1775: fnd_file.put_line(fnd_file.LOG,'| |');
1776: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1777:
1778: -- Clear the list
1779: l_cst_rev_id_list.delete();

Line 1776: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1772: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1773: fnd_file.put_line(fnd_file.LOG,'| |');
1774: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1775: fnd_file.put_line(fnd_file.LOG,'| |');
1776: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1777:
1778: -- Clear the list
1779: l_cst_rev_id_list.delete();
1780: l_cst_name_list.delete();

Line 1791: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');

1787:
1788: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1789: FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1790: LOOP
1791: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1792: fnd_file.put_line(fnd_file.LOG, 'Constraint Name : '||l_cst_name_list(i));
1793: fnd_file.put_line(fnd_file.LOG, 'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1794:
1795: l_appl_id_list.delete();

Line 1792: fnd_file.put_line(fnd_file.LOG, 'Constraint Name : '||l_cst_name_list(i));

1788: IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1789: FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1790: LOOP
1791: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1792: fnd_file.put_line(fnd_file.LOG, 'Constraint Name : '||l_cst_name_list(i));
1793: fnd_file.put_line(fnd_file.LOG, 'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1794:
1795: l_appl_id_list.delete();
1796: l_cp_name_list.delete();

Line 1793: fnd_file.put_line(fnd_file.LOG, 'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));

1789: FOR i in l_function_id_list.FIRST .. l_function_id_list.LAST
1790: LOOP
1791: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1792: fnd_file.put_line(fnd_file.LOG, 'Constraint Name : '||l_cst_name_list(i));
1793: fnd_file.put_line(fnd_file.LOG, 'Conc Program Id that mapping to more than 1 Application_Id : '||l_function_id_list(i));
1794:
1795: l_appl_id_list.delete();
1796: l_cp_name_list.delete();
1797: l_appl_name_list.delete();

Line 1812: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));

1808:
1809: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1810: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1811: LOOP
1812: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1813: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1814: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1815: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1816: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN

Line 1813: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));

1809: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1810: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1811: LOOP
1812: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1813: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1814: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1815: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1816: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1817: END LOOP; -- end of FOR j in l_function_id_list.FIRST .. l_function_id_list.LAST

Line 1814: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));

1810: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1811: LOOP
1812: fnd_file.put_line(fnd_file.LOG,' Concurrent Program Name : '||l_cp_name_list(k));
1813: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1814: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1815: END LOOP; -- FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1816: END IF; -- IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1817: END LOOP; -- end of FOR j in l_function_id_list.FIRST .. l_function_id_list.LAST
1818: END IF; -- end of IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN

Line 1821: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1817: END LOOP; -- end of FOR j in l_function_id_list.FIRST .. l_function_id_list.LAST
1818: END IF; -- end of IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1819:
1820:
1821: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1822: fnd_file.put_line(fnd_file.LOG,'| |');
1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1822: fnd_file.put_line(fnd_file.LOG,'| |');

1818: END IF; -- end of IF ((l_function_id_list IS NOT NULL) and (l_function_id_list.FIRST IS NOT NULL)) THEN
1819:
1820:
1821: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1822: fnd_file.put_line(fnd_file.LOG,'| |');
1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:

Line 1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');

1819:
1820:
1821: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1822: fnd_file.put_line(fnd_file.LOG,'| |');
1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1824: fnd_file.put_line(fnd_file.LOG,'| |');

1820:
1821: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1822: fnd_file.put_line(fnd_file.LOG,'| |');
1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');

Line 1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1821: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1822: fnd_file.put_line(fnd_file.LOG,'| |');
1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');
1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');

Line 1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1823: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_VIOLAT_RESP_ENTRIES.APPLICATION_ID |');
1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');
1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1830: fnd_file.put_line(fnd_file.LOG,'| |');
1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1828: fnd_file.put_line(fnd_file.LOG,'| |');

1824: fnd_file.put_line(fnd_file.LOG,'| |');
1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');
1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1830: fnd_file.put_line(fnd_file.LOG,'| |');
1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1832:

Line 1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');

1825: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');
1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1830: fnd_file.put_line(fnd_file.LOG,'| |');
1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1832:
1833: fnd_file.put_line(fnd_file.LOG, 'Please Manaully verify the following Constraints Responsibility Waiver .');

Line 1830: fnd_file.put_line(fnd_file.LOG,'| |');

1826:
1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');
1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1830: fnd_file.put_line(fnd_file.LOG,'| |');
1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1832:
1833: fnd_file.put_line(fnd_file.LOG, 'Please Manaully verify the following Constraints Responsibility Waiver .');
1834:

Line 1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1827: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1828: fnd_file.put_line(fnd_file.LOG,'| |');
1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1830: fnd_file.put_line(fnd_file.LOG,'| |');
1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1832:
1833: fnd_file.put_line(fnd_file.LOG, 'Please Manaully verify the following Constraints Responsibility Waiver .');
1834:
1835: -- clean up the list

Line 1833: fnd_file.put_line(fnd_file.LOG, 'Please Manaully verify the following Constraints Responsibility Waiver .');

1829: fnd_file.put_line(fnd_file.LOG,'| Start Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1830: fnd_file.put_line(fnd_file.LOG,'| |');
1831: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1832:
1833: fnd_file.put_line(fnd_file.LOG, 'Please Manaully verify the following Constraints Responsibility Waiver .');
1834:
1835: -- clean up the list
1836: l_cst_rev_id_list.delete();
1837: l_resp_id_list.delete();

Line 1848: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');

1844:
1845: IF ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1846: FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1847: LOOP
1848: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1849: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1850:
1851: -- Clear the List.
1852: l_appl_id_list.delete();

Line 1849: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));

1845: IF ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1846: FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1847: LOOP
1848: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------------------------');
1849: fnd_file.put_line(fnd_file.LOG,'Constraint Name : '||l_cst_name_list(i));
1850:
1851: -- Clear the List.
1852: l_appl_id_list.delete();
1853: l_appl_name_list.delete();

Line 1873: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));

1869: ORDER BY APPLICATION_ID;
1870:
1871: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1872:
1873: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));
1874: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities Waivers to be included in the contraint :');
1875: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1876: LOOP
1877: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));

Line 1874: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities Waivers to be included in the contraint :');

1870:
1871: IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1872:
1873: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));
1874: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities Waivers to be included in the contraint :');
1875: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1876: LOOP
1877: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1878: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));

Line 1877: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));

1873: fnd_file.put_line(fnd_file.LOG,'Responsibility Id that mapping to more than 1 Application_Id : '||l_resp_id_list(i));
1874: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities Waivers to be included in the contraint :');
1875: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1876: LOOP
1877: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1878: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1879: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1880: END LOOP;
1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');

Line 1878: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));

1874: fnd_file.put_line(fnd_file.LOG,'Possible Responsibilities Waivers to be included in the contraint :');
1875: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1876: LOOP
1877: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1878: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1879: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1880: END LOOP;
1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');
1882: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));

Line 1879: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));

1875: FOR k in l_appl_id_list.FIRST .. l_appl_id_list.LAST
1876: LOOP
1877: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1878: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1879: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1880: END LOOP;
1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');
1882: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1883: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));

Line 1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');

1877: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(k));
1878: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1879: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1880: END LOOP;
1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');
1882: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1883: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1884: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1885: END IF;-- End of IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN

Line 1882: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));

1878: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(k));
1879: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1880: END LOOP;
1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');
1882: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1883: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1884: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1885: END IF;-- End of IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1886: END LOOP; -- FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST

Line 1883: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));

1879: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(k));
1880: END LOOP;
1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');
1882: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1883: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1884: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1885: END IF;-- End of IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1886: END LOOP; -- FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1887: END IF; -- end of ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN

Line 1884: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));

1880: END LOOP;
1881: fnd_file.put_line(fnd_file.LOG,'Responsibility Waiver automatically migrated for the Constraint:');
1882: fnd_file.put_line(fnd_file.LOG,' Responsibility Name : '||l_resp_name_list(1));
1883: fnd_file.put_line(fnd_file.LOG,' Application Name : '||l_appl_name_list(1));
1884: fnd_file.put_line(fnd_file.LOG,' Application Id : '||l_appl_id_list(1));
1885: END IF;-- End of IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1886: END LOOP; -- FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1887: END IF; -- end of ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1888:

Line 1889: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1885: END IF;-- End of IF ((l_appl_id_list IS NOT NULL) and (l_appl_id_list.FIRST IS NOT NULL)) THEN
1886: END LOOP; -- FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1887: END IF; -- end of ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1888:
1889: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1890: fnd_file.put_line(fnd_file.LOG,'| |');
1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1892: fnd_file.put_line(fnd_file.LOG,'| |');
1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

Line 1890: fnd_file.put_line(fnd_file.LOG,'| |');

1886: END LOOP; -- FOR i in l_resp_id_list.FIRST .. l_resp_id_list.LAST
1887: END IF; -- end of ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1888:
1889: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1890: fnd_file.put_line(fnd_file.LOG,'| |');
1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1892: fnd_file.put_line(fnd_file.LOG,'| |');
1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1894: EXCEPTION

Line 1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');

1887: END IF; -- end of ((l_resp_id_list IS NOT NULL) and (l_resp_id_list.FIRST IS NOT NULL)) THEN
1888:
1889: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1890: fnd_file.put_line(fnd_file.LOG,'| |');
1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1892: fnd_file.put_line(fnd_file.LOG,'| |');
1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1894: EXCEPTION
1895: WHEN OTHERS THEN

Line 1892: fnd_file.put_line(fnd_file.LOG,'| |');

1888:
1889: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1890: fnd_file.put_line(fnd_file.LOG,'| |');
1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1892: fnd_file.put_line(fnd_file.LOG,'| |');
1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: fnd_file.put_line (fnd_file.LOG, SUBSTR (SQLERRM, 1, 200));

Line 1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');

1889: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1890: fnd_file.put_line(fnd_file.LOG,'| |');
1891: fnd_file.put_line(fnd_file.LOG,'| End Data Fix for AMW_CONSTRAINT_WAIVERS_B.PK2 |');
1892: fnd_file.put_line(fnd_file.LOG,'| |');
1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: fnd_file.put_line (fnd_file.LOG, SUBSTR (SQLERRM, 1, 200));
1897: END;

Line 1896: fnd_file.put_line (fnd_file.LOG, SUBSTR (SQLERRM, 1, 200));

1892: fnd_file.put_line(fnd_file.LOG,'| |');
1893: fnd_file.put_line(fnd_file.LOG,'+====================================================================+');
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: fnd_file.put_line (fnd_file.LOG, SUBSTR (SQLERRM, 1, 200));
1897: END;
1898:
1899:
1900: END AMW_LOAD_SOD_DATA;