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.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on FND_FILE

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This Concurrent Request is not available for non-US Country Profile');

238:
239: -- This process is available only if the IGS: Country Code profile value is 'US'
240: /* FND_PROFILE.GET('OSS_COUNTRY_CODE',l_Country_code);
241: IF l_Country_code <> 'US' THEN
242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This Concurrent Request is not available for non-US Country Profile');
243: return 1;
244: END IF; */
245:
246:

Line 251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Social Security Number Person ID Type is not Setup in Person Data Setup.');

247: OPEN c_ssn_Person_Id_Type;
248: FETCH c_ssn_Person_Id_Type INTO G_SSN_Person_Id_Type;
249: IF c_ssn_Person_Id_Type%NOTFOUND THEN
250: CLOSE c_ssn_Person_Id_Type;
251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Social Security Number Person ID Type is not Setup in Person Data Setup.');
252: l_return := 1;
253: ELSE
254: CLOSE c_ssn_Person_Id_Type;
255: END IF;

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACT Identifier Person ID Type is not Setup in Person Data Setup.');

258: OPEN c_Act_Person_Id_Type;
259: FETCH c_Act_Person_Id_Type INTO G_ACT_Person_Id_Type;
260: IF c_Act_Person_Id_Type%NOTFOUND THEN
261: CLOSE c_Act_Person_Id_Type;
262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACT Identifier Person ID Type is not Setup in Person Data Setup.');
263: l_return := 1;
264: ELSE
265: CLOSE c_Act_Person_Id_Type;
266: END IF;

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Test Score Source of ELEC is not defined in Test Result Information Setup.');

268: OPEN c_Test_Score_Source;
269: FETCH c_Test_Score_Source INTO G_Score_Source_id;
270: IF c_Test_Score_Source%NOTFOUND THEN
271: CLOSE c_Test_Score_Source;
272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Test Score Source of ELEC is not defined in Test Result Information Setup.');
273: l_return := 1;
274: ELSE
275: CLOSE c_Test_Score_Source;
276: END IF;

Line 282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transcript Source of ACT is not defined in Transcript Information Setup.');

278: OPEN c_Transcript_Source;
279: FETCH c_Transcript_Source INTO G_Transcript_Source;
280: IF c_Transcript_Source%NOTFOUND THEN
281: CLOSE c_Transcript_Source;
282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transcript Source of ACT is not defined in Transcript Information Setup.');
283: l_return := 1;
284: ELSE
285: CLOSE c_Transcript_Source;
286: END IF;

Line 292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Grading Scale Type of 4 POINT is not defined in Transcript Information Setup.');

288: OPEN c_Grading_Scale;
289: FETCH c_Grading_Scale INTO G_Grading_Scale;
290: IF c_Grading_Scale%NOTFOUND THEN
291: CLOSE c_Grading_Scale;
292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Grading Scale Type of 4 POINT is not defined in Transcript Information Setup.');
293: l_return := 1;
294: ELSE
295: CLOSE c_Grading_Scale;
296: END IF;

Line 302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unit Difficulty of STANDARD is not defined in Transcript Information Setup.');

298: OPEN c_Unit_Difficulty;
299: FETCH c_Unit_Difficulty INTO G_Unit_Difficulty;
300: IF c_Unit_Difficulty%NOTFOUND THEN
301: CLOSE c_Unit_Difficulty;
302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unit Difficulty of STANDARD is not defined in Transcript Information Setup.');
303: l_return := 1;
304: ELSE
305: CLOSE c_Unit_Difficulty;
306: END IF;

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 319: FND_FILE.PUT_LINE(Fnd_File.LOG,'FOR Admission Test Type :'||l_Test_Segments.ADMISSION_TEST_TYPE||' Test Segment Name : '||l_Test_Segments.TEST_SEGMENT_NAME ||

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)
318: LOOP
319: FND_FILE.PUT_LINE(Fnd_File.LOG,'FOR Admission Test Type :'||l_Test_Segments.ADMISSION_TEST_TYPE||' Test Segment Name : '||l_Test_Segments.TEST_SEGMENT_NAME ||
320: ' Segment Type : '|| l_Test_Segments.SEGMENT_TYPE || ' is not/incorrect setup');
321: l_return := 1;
322: END LOOP;
323:

Line 326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Level of Qualification : '||l_Assessment_grade_level.LEVEL_OF_QUAL ||' is not/incorrect Setup in Application Detail Codes Data Setup.');

322: END LOOP;
323:
324: FOR l_Assessment_grade_level IN c_Assessment_grade_level (p_ACT_Batch_Id, p_Reporting_Year,p_Test_Type , p_Test_Date , p_ACT_Id)
325: LOOP
326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Level of Qualification : '||l_Assessment_grade_level.LEVEL_OF_QUAL ||' is not/incorrect Setup in Application Detail Codes Data Setup.');
327: l_return := 1;
328: END LOOP;
329:
330: FOR l_Assessment_Institution_code IN c_Assessment_Institution_code (p_ACT_Batch_Id, p_Reporting_Year,p_Test_Type , p_Test_Date , p_ACT_Id)

Line 332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Institution Code : '||l_Assessment_Institution_code.INSTITUTION_CD ||' is not/incorrect Setup in Organization Structure Setup.');

328: END LOOP;
329:
330: FOR l_Assessment_Institution_code IN c_Assessment_Institution_code (p_ACT_Batch_Id, p_Reporting_Year,p_Test_Type , p_Test_Date , p_ACT_Id)
331: LOOP
332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Institution Code : '||l_Assessment_Institution_code.INSTITUTION_CD ||' is not/incorrect Setup in Organization Structure Setup.');
333: l_return := 1;
334: END LOOP;
335:
336: RETURN l_return;

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 488: FND_FILE.PUT_LINE(Fnd_File.LOG,'Source Type ID : '|| p_Source_Type_Id||' MatchSet Id : ' ||p_Match_Set_Id);

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

Line 489: FND_FILE.PUT_LINE(Fnd_File.LOG,'Reporting Year : '|| p_Reporting_Year||' Test Type : ' ||p_Test_Type);

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, '---------------------------------------------------------------------------------------');
492:
493: retcode := 0;

Line 490: FND_FILE.PUT_LINE(Fnd_File.LOG,'Test_Date : '|| p_Test_Date||' ACT_Id : ' ||p_ACT_Id);

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, '---------------------------------------------------------------------------------------');
492:
493: retcode := 0;
494: errbuf := NULL;

Line 491: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------');

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, '---------------------------------------------------------------------------------------');
492:
493: retcode := 0;
494: errbuf := NULL;
495: retcode := Check_Setups(p_ACT_Batch_Id,

Line 530: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------------------');

526: FND_GLOBAL.LOGIN_ID
527: ) returning BATCH_ID into l_Batch_Id
528: ;
529: commit;
530: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------------------');
531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Created a Bacth Record with following details :');
532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID : ' || l_Batch_Id || ' Batch Description : '||l_Batch_Desc);
533: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------------------------');
534:

Line 531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Created a Bacth Record with following details :');

527: ) returning BATCH_ID into l_Batch_Id
528: ;
529: commit;
530: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------------------');
531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Created a Bacth Record with following details :');
532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID : ' || l_Batch_Id || ' Batch Description : '||l_Batch_Desc);
533: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------------------------');
534:
535:

Line 532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID : ' || l_Batch_Id || ' Batch Description : '||l_Batch_Desc);

528: ;
529: commit;
530: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------------------');
531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Created a Bacth Record with following details :');
532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID : ' || l_Batch_Id || ' Batch Description : '||l_Batch_Desc);
533: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------------------------');
534:
535:
536: BEGIN -- Loading the Data to Interface Tables.

Line 533: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------------------------');

529: commit;
530: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------------------');
531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Created a Bacth Record with following details :');
532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID : ' || l_Batch_Id || ' Batch Description : '||l_Batch_Desc);
533: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------------------------');
534:
535:
536: BEGIN -- Loading the Data to Interface Tables.
537:

Line 568: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

564:
565: -- Count Failure Transactions
566: l_rec_fail_count:=0;
567:
568: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Loading the values into Interface tables from the ACT Data Store');
570:
571: FOR Act_Assessment_rec IN c_Act_Assessment( p_ACT_Batch_Id ,p_Reporting_Year,
572: p_Test_Type , p_Test_Date , p_ACT_Id )

Line 569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Loading the values into Interface tables from the ACT Data Store');

565: -- Count Failure Transactions
566: l_rec_fail_count:=0;
567:
568: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
569: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Loading the values into Interface tables from the ACT Data Store');
570:
571: FOR Act_Assessment_rec IN c_Act_Assessment( p_ACT_Batch_Id ,p_Reporting_Year,
572: p_Test_Type , p_Test_Date , p_ACT_Id )
573: LOOP

Line 580: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for loop : l_ACT_Exist ' || l_ACT_Exist);

576: SAVEPOINT Transact_spoint; -- Save Point at the start of the transaction,
577: -- is used to Rollback complete transaction for any failure in the transaction
578:
579: --debug
580: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for loop : l_ACT_Exist ' || l_ACT_Exist);
581:
582: -- Insert Person Details of Latest Record
583: IF ((l_ACT_Exist IS NULL ) OR ( l_ACT_Exist <> Act_Assessment_rec.act_identifier))
584: THEN

Line 587: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of loop : l_ACT Exist ' || l_ACT_Exist);

583: IF ((l_ACT_Exist IS NULL ) OR ( l_ACT_Exist <> Act_Assessment_rec.act_identifier))
584: THEN
585:
586: --debug
587: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of loop : l_ACT Exist ' || l_ACT_Exist);
588:
589: -- Inserting the Latest Record in to the Main Interface Table (IGS_AD_INTERFACE_ALL)
590: INSERT
591: INTO IGS_AD_INTERFACE_ALL

Line 632: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id : 1' || l_interface_id);

628: FND_GLOBAL.LOGIN_ID
629: ) returning INTERFACE_ID into l_interface_id;
630:
631: --debug
632: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id : 1' || l_interface_id);
633:
634: -- Inserting the Latest Record in to the Child (IGS_AD_ADDR_INT_ALL) of Interface Table (IGS_AD_INTERFACE_ALL).
635: INSERT
636: INTO IGS_AD_ADDR_INT_ALL

Line 804: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id : 2 ' || l_interface_id);

800: );
801: END IF;
802:
803: --debug
804: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id : 2 ' || l_interface_id);
805:
806: -- Inserting ACT Person_id_type
807: INSERT
808: INTO IGS_AD_API_INT_ALL

Line 843: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id 3: ' || l_interface_id);

839: -- Loading Test Detials in to Interface Tables.
840: -- Multiple Records
841: -- For each Test Type :
842: --debug
843: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id 3: ' || l_interface_id);
844: INSERT
845: INTO IGS_AD_TEST_INT
846: (
847: INTERFACE_TEST_ID ,

Line 894: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Interface Id 4: ' || l_interface_id);

890: LOOP
891:
892:
893: --debug
894: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Interface Id 4: ' || l_interface_id);
895: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record l_admission_test_type ' || l_admission_test_type);
896: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_category ' || Act_Statistic_rec.statistic_category );
897: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_type ' || Act_Statistic_rec.statistic_type);
898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record get_lookup_meaning() ' || get_lookup_meaning(Act_Statistic_rec.statistic_category));

Line 895: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record l_admission_test_type ' || l_admission_test_type);

891:
892:
893: --debug
894: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Interface Id 4: ' || l_interface_id);
895: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record l_admission_test_type ' || l_admission_test_type);
896: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_category ' || Act_Statistic_rec.statistic_category );
897: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_type ' || Act_Statistic_rec.statistic_type);
898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record get_lookup_meaning() ' || get_lookup_meaning(Act_Statistic_rec.statistic_category));
899:

Line 896: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_category ' || Act_Statistic_rec.statistic_category );

892:
893: --debug
894: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Interface Id 4: ' || l_interface_id);
895: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record l_admission_test_type ' || l_admission_test_type);
896: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_category ' || Act_Statistic_rec.statistic_category );
897: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_type ' || Act_Statistic_rec.statistic_type);
898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record get_lookup_meaning() ' || get_lookup_meaning(Act_Statistic_rec.statistic_category));
899:
900: l_test_segment_id := NULL;

Line 897: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_type ' || Act_Statistic_rec.statistic_type);

893: --debug
894: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Interface Id 4: ' || l_interface_id);
895: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record l_admission_test_type ' || l_admission_test_type);
896: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_category ' || Act_Statistic_rec.statistic_category );
897: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_type ' || Act_Statistic_rec.statistic_type);
898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record get_lookup_meaning() ' || get_lookup_meaning(Act_Statistic_rec.statistic_category));
899:
900: l_test_segment_id := NULL;
901: l_test_score := NULL;

Line 898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record get_lookup_meaning() ' || get_lookup_meaning(Act_Statistic_rec.statistic_category));

894: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Interface Id 4: ' || l_interface_id);
895: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record l_admission_test_type ' || l_admission_test_type);
896: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_category ' || Act_Statistic_rec.statistic_category );
897: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record Act_Statistic_rec.statistic_type ' || Act_Statistic_rec.statistic_type);
898: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside for of Statistic record get_lookup_meaning() ' || get_lookup_meaning(Act_Statistic_rec.statistic_category));
899:
900: l_test_segment_id := NULL;
901: l_test_score := NULL;
902: l_national_percentile := NULL;

Line 1072: FND_FILE.PUT_LINE(Fnd_File.LOG,'Academic History for the follwing Records will not be imported as High School Graduation Institution Code is not defined.');

1068: END LOOP; --- End Inserting multiple records of Test Details for a Person
1069:
1070: -- Enter Acad History Details into IGS_AD_ACADHIS_INT_ALL from ACT Statistics
1071: IF Act_Assessment_Rec.high_school_code IS NULL THEN
1072: FND_FILE.PUT_LINE(Fnd_File.LOG,'Academic History for the follwing Records will not be imported as High School Graduation Institution Code is not defined.');
1073: FND_FILE.PUT_LINE(Fnd_File.LOG,'ACT_ID : '|| Act_Assessment_Rec.ACT_Identifier ||' REPORTING_YEAR :'|| Act_Assessment_Rec.Reporting_Year||' TEST_DATE : '||Act_Assessment_Rec.Test_Date_Txt||' TEST_TYPE : '||Act_Assessment_Rec.Test_Type);
1074: ELSE
1075: IF (((l_Interface_Id_exist IS NULL ) OR ( l_Interface_Id_exist <> l_interface_id)) OR NOT
1076: (( l_High_School_Code = Act_Assessment_Rec.high_school_code)

Line 1073: FND_FILE.PUT_LINE(Fnd_File.LOG,'ACT_ID : '|| Act_Assessment_Rec.ACT_Identifier ||' REPORTING_YEAR :'|| Act_Assessment_Rec.Reporting_Year||' TEST_DATE : '||Act_Assessment_Rec.Test_Date_Txt||' TEST_TYPE : '||Act_Assessment_Rec.Test_Type);

1069:
1070: -- Enter Acad History Details into IGS_AD_ACADHIS_INT_ALL from ACT Statistics
1071: IF Act_Assessment_Rec.high_school_code IS NULL THEN
1072: FND_FILE.PUT_LINE(Fnd_File.LOG,'Academic History for the follwing Records will not be imported as High School Graduation Institution Code is not defined.');
1073: FND_FILE.PUT_LINE(Fnd_File.LOG,'ACT_ID : '|| Act_Assessment_Rec.ACT_Identifier ||' REPORTING_YEAR :'|| Act_Assessment_Rec.Reporting_Year||' TEST_DATE : '||Act_Assessment_Rec.Test_Date_Txt||' TEST_TYPE : '||Act_Assessment_Rec.Test_Type);
1074: ELSE
1075: IF (((l_Interface_Id_exist IS NULL ) OR ( l_Interface_Id_exist <> l_interface_id)) OR NOT
1076: (( l_High_School_Code = Act_Assessment_Rec.high_school_code)
1077: AND( l_High_School_Graduation = Act_Assessment_Rec.high_school_graduation))) THEN

Line 1080: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details record Interface Id 5: ' || l_interface_id);

1076: (( l_High_School_Code = Act_Assessment_Rec.high_school_code)
1077: AND( l_High_School_Graduation = Act_Assessment_Rec.high_school_graduation))) THEN
1078:
1079: --debug
1080: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details record Interface Id 5: ' || l_interface_id);
1081:
1082: INSERT
1083: INTO IGS_AD_ACADHIS_INT_ALL
1084: (

Line 1128: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TXCPT_INT record Interface Id 5: ' || l_interface_id);

1124:
1125: -- Enter Test Details into IGS_AD_TXCPT_INT from ACT Statistics
1126:
1127: --debug
1128: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TXCPT_INT record Interface Id 5: ' || l_interface_id);
1129:
1130: INSERT
1131: INTO IGS_AD_TXCPT_INT
1132: (

Line 1169: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TRMDT_INT record Interface Id 5: ' || l_interface_id);

1165: to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD')
1166: ) returning INTERFACE_TRANSCRIPT_ID into l_Interface_Transcript_Id ;
1167:
1168: --debug
1169: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TRMDT_INT record Interface Id 5: ' || l_interface_id);
1170:
1171: INSERT
1172: INTO IGS_AD_TRMDT_INT
1173: (

Line 1216: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside FOR of History Details: IGS_AD_TUNDT_INT record Interface Id 5: ' || l_interface_id);

1212: FETCH c_Statistic_Category_desc INTO l_Statistic_Category_desc;
1213: CLOSE c_Statistic_Category_desc;
1214:
1215: --debug
1216: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside FOR of History Details: IGS_AD_TUNDT_INT record Interface Id 5: ' || l_interface_id);
1217:
1218:
1219: IF Act_Statistic_HS_Rec.statistic_category IN ('ENGLISH','MATHS','NATSCI','SOCSCI') THEN
1220: -- If Numeric Grade is 'NN' not NULL not '--'

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 1325: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------------------------------------------------------------------');

1321: COMMIT;
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');

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:

Line 1329: FND_FILE.PUT_LINE(Fnd_File.LOG,l_rec_fail_count || ' ACT records have failed to insert into the interface tables');

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:
1333: -- Call to Import Process only if any success records.

Line 1330: FND_FILE.PUT_LINE(Fnd_File.LOG,'Total Records Processed : '||l_rec_count);

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:
1333: -- Call to Import Process only if any success records.
1334: IF ((l_rec_count - l_rec_fail_count) <> 0) THEN

Line 1331: FND_FILE.PUT_LINE(FND_FILE.LOG, '---------------------------------------------------------------------------------------------------------------------------------------------------');

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:
1333: -- Call to Import Process only if any success records.
1334: IF ((l_rec_count - l_rec_fail_count) <> 0) THEN
1335: igs_ad_imp_001.imp_adm_data(

Line 1346: FND_FILE.PUT_LINE(Fnd_File.LOG,' Following Error Occured during the Import Process : ');

1342: P_ENABLE_LOG => 'Y' );
1343: END IF;
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: FND_FILE.PUT_LINE(Fnd_File.LOG,' Following Error Occured during the Import Process : ');
1347: FND_FILE.PUT_LINE(Fnd_File.LOG,SQLERRM);
1348: retcode :=2;
1349: errbuf:=SQLERRM;
1350:

Line 1347: FND_FILE.PUT_LINE(Fnd_File.LOG,SQLERRM);

1343: END IF;
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: FND_FILE.PUT_LINE(Fnd_File.LOG,' Following Error Occured during the Import Process : ');
1347: FND_FILE.PUT_LINE(Fnd_File.LOG,SQLERRM);
1348: retcode :=2;
1349: errbuf:=SQLERRM;
1350:
1351: END Insert_ACT_to_Interface;-- End of Procedure