DBA Data[Home] [Help]

APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on FND_MESSAGE

Line 311: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TEST_TYPE_SETUP');

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;

Line 312: FND_MESSAGE.SET_TOKEN('SETUP', l_Admission_Test_Type.ADMISSION_TEST_TYPE);

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:

Line 313: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);

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)

Line 485: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_IMPORT');

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

Line 486: FND_MESSAGE.SET_TOKEN('ACT_BATCH_ID', p_ACT_Batch_Id);

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

Line 487: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);

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, '---------------------------------------------------------------------------------------');

Line 1304: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_INS_FAIL');

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

Line 1305: FND_MESSAGE.SET_TOKEN('ACT_ID', Act_Assessment_Rec.ACT_Identifier);

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

Line 1306: FND_MESSAGE.SET_TOKEN('REPORTING_YEAR', Act_Assessment_Rec.Reporting_Year);

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

Line 1307: FND_MESSAGE.SET_TOKEN('TEST_DATE', Act_Assessment_Rec.Test_Date_Txt);

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;

Line 1308: FND_MESSAGE.SET_TOKEN('TEST_TYPE',' - '|| Act_Assessment_Rec.Test_Type);

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;

Line 1309: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

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

Line 1310: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);

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:

Line 1326: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACT_COUNT');

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

Line 1327: FND_MESSAGE.SET_TOKEN('COUNT', l_rec_count - l_rec_fail_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, '---------------------------------------------------------------------------------------------------------------------------------------------------');

Line 1328: FND_FILE.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);

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: