307:
308: FOR l_Admission_Test_Type IN c_Assessment_Test_Type ( p_ACT_Batch_Id, p_Reporting_Year,
309: p_Test_Type , p_Test_Date , p_ACT_Id)
310: LOOP
311: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TEST_TYPE_SETUP');
312: FND_MESSAGE.SET_TOKEN('SETUP', l_Admission_Test_Type.ADMISSION_TEST_TYPE);
313: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
314: l_return := 1;
315: END LOOP;
308: FOR l_Admission_Test_Type IN c_Assessment_Test_Type ( p_ACT_Batch_Id, p_Reporting_Year,
309: p_Test_Type , p_Test_Date , p_ACT_Id)
310: LOOP
311: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TEST_TYPE_SETUP');
312: FND_MESSAGE.SET_TOKEN('SETUP', l_Admission_Test_Type.ADMISSION_TEST_TYPE);
313: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
314: l_return := 1;
315: END LOOP;
316:
309: p_Test_Type , p_Test_Date , p_ACT_Id)
310: LOOP
311: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TEST_TYPE_SETUP');
312: FND_MESSAGE.SET_TOKEN('SETUP', l_Admission_Test_Type.ADMISSION_TEST_TYPE);
313: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
314: l_return := 1;
315: END LOOP;
316:
317: FOR l_Test_Segments IN c_Test_Segments (p_ACT_Batch_Id, p_Reporting_Year,p_Test_Type , p_Test_Date , p_ACT_Id)
481:
482: -- The following code is added for disabling of OSS in R12.IGS.A - Bug 4955192
483: igs_ge_gen_003.set_org_id(null);
484:
485: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_IMPORT');
486: FND_MESSAGE.SET_TOKEN('ACT_BATCH_ID', p_ACT_Batch_Id);
487: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
488: FND_FILE.PUT_LINE(Fnd_File.LOG,'Source Type ID : '|| p_Source_Type_Id||' MatchSet Id : ' ||p_Match_Set_Id);
489: FND_FILE.PUT_LINE(Fnd_File.LOG,'Reporting Year : '|| p_Reporting_Year||' Test Type : ' ||p_Test_Type);
482: -- The following code is added for disabling of OSS in R12.IGS.A - Bug 4955192
483: igs_ge_gen_003.set_org_id(null);
484:
485: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_IMPORT');
486: FND_MESSAGE.SET_TOKEN('ACT_BATCH_ID', p_ACT_Batch_Id);
487: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
488: FND_FILE.PUT_LINE(Fnd_File.LOG,'Source Type ID : '|| p_Source_Type_Id||' MatchSet Id : ' ||p_Match_Set_Id);
489: FND_FILE.PUT_LINE(Fnd_File.LOG,'Reporting Year : '|| p_Reporting_Year||' Test Type : ' ||p_Test_Type);
490: FND_FILE.PUT_LINE(Fnd_File.LOG,'Test_Date : '|| p_Test_Date||' ACT_Id : ' ||p_ACT_Id);
483: igs_ge_gen_003.set_org_id(null);
484:
485: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_IMPORT');
486: FND_MESSAGE.SET_TOKEN('ACT_BATCH_ID', p_ACT_Batch_Id);
487: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
488: FND_FILE.PUT_LINE(Fnd_File.LOG,'Source Type ID : '|| p_Source_Type_Id||' MatchSet Id : ' ||p_Match_Set_Id);
489: FND_FILE.PUT_LINE(Fnd_File.LOG,'Reporting Year : '|| p_Reporting_Year||' Test Type : ' ||p_Test_Type);
490: FND_FILE.PUT_LINE(Fnd_File.LOG,'Test_Date : '|| p_Test_Date||' ACT_Id : ' ||p_ACT_Id);
491: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------');
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: -- Insert a log message that Person Record failed to populate into Interface Tables.
1303:
1304: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_INS_FAIL');
1305: FND_MESSAGE.SET_TOKEN('ACT_ID', Act_Assessment_Rec.ACT_Identifier);
1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);
1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);
1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);
1301: WHEN OTHERS THEN
1302: -- Insert a log message that Person Record failed to populate into Interface Tables.
1303:
1304: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_INS_FAIL');
1305: FND_MESSAGE.SET_TOKEN('ACT_ID', Act_Assessment_Rec.ACT_Identifier);
1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);
1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);
1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);
1309: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1302: -- Insert a log message that Person Record failed to populate into Interface Tables.
1303:
1304: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_INS_FAIL');
1305: FND_MESSAGE.SET_TOKEN('ACT_ID', Act_Assessment_Rec.ACT_Identifier);
1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);
1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);
1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);
1309: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1310: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1303:
1304: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_INS_FAIL');
1305: FND_MESSAGE.SET_TOKEN('ACT_ID', Act_Assessment_Rec.ACT_Identifier);
1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);
1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);
1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);
1309: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1310: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1311: ROLLBACK TO Transact_spoint;
1304: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_INS_FAIL');
1305: FND_MESSAGE.SET_TOKEN('ACT_ID', Act_Assessment_Rec.ACT_Identifier);
1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);
1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);
1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);
1309: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1310: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1311: ROLLBACK TO Transact_spoint;
1312: l_rec_fail_count := l_rec_fail_count + 1;
1305: FND_MESSAGE.SET_TOKEN('ACT_ID', Act_Assessment_Rec.ACT_Identifier);
1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);
1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);
1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);
1309: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1310: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1311: ROLLBACK TO Transact_spoint;
1312: l_rec_fail_count := l_rec_fail_count + 1;
1313: END; -- END of Inserting a Single Transaction
1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);
1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);
1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);
1309: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1310: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1311: ROLLBACK TO Transact_spoint;
1312: l_rec_fail_count := l_rec_fail_count + 1;
1313: END; -- END of Inserting a Single Transaction
1314:
1322:
1323: END; -- END Loading the Data to Interface Tables.
1324:
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------------------------------------------------------------------');
1326: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_COUNT');
1327: FND_MESSAGE.SET_TOKEN('COUNT', l_rec_count - l_rec_fail_count);
1328: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1329: FND_FILE.PUT_LINE(Fnd_File.LOG,l_rec_fail_count || ' ACT records have failed to insert into the interface tables');
1330: FND_FILE.PUT_LINE(Fnd_File.LOG,'Total Records Processed : '||l_rec_count);
1323: END; -- END Loading the Data to Interface Tables.
1324:
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------------------------------------------------------------------');
1326: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_COUNT');
1327: FND_MESSAGE.SET_TOKEN('COUNT', l_rec_count - l_rec_fail_count);
1328: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1329: FND_FILE.PUT_LINE(Fnd_File.LOG,l_rec_fail_count || ' ACT records have failed to insert into the interface tables');
1330: FND_FILE.PUT_LINE(Fnd_File.LOG,'Total Records Processed : '||l_rec_count);
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------------------------------------------------------------------');
1324:
1325: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------------------------------------------------------------------');
1326: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_COUNT');
1327: FND_MESSAGE.SET_TOKEN('COUNT', l_rec_count - l_rec_fail_count);
1328: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
1329: FND_FILE.PUT_LINE(Fnd_File.LOG,l_rec_fail_count || ' ACT records have failed to insert into the interface tables');
1330: FND_FILE.PUT_LINE(Fnd_File.LOG,'Total Records Processed : '||l_rec_count);
1331: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------------------------------------------------------------------');
1332: