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

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

405:
406: EXCEPTION WHEN OTHERS THEN
407:
408: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
409: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
410:
411: FND_MESSAGE.SET_NAME('IGS',v_message_name);
412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
413:

Line 412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

408: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CAND_COPY_FAIL');
409: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
410:
411: FND_MESSAGE.SET_NAME('IGS',v_message_name);
412: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
413:
414: RETURN FALSE;
415:
416: END copy_candidacy_records;

Line 741: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(p_person_id,15,' ') || '; Admission Application Number: ' ||

737: RETURN TRUE;
738:
739: EXCEPTION WHEN OTHERS THEN
740:
741: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(p_person_id,15,' ') || '; Admission Application Number: ' ||
742: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
743: RPAD(p_sequence_number,6,' ') || ' Reason: ');
744:
745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');

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

742: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
743: RPAD(p_sequence_number,6,' ') || ' Reason: ');
744:
745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
746: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
747:
748: FND_MESSAGE.SET_NAME('IGS',l_last_error);
749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
750:

Line 749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

745: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
746: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
747:
748: FND_MESSAGE.SET_NAME('IGS',l_last_error);
749: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
750:
751: RETURN FALSE;
752: END copy_application_child_records;
753:

Line 1382: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(p_person_id,15,' ') || '; Admission Application Number: ' ||

1378: RETURN TRUE;
1379:
1380: EXCEPTION WHEN OTHERS THEN
1381:
1382: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(p_person_id,15,' ') || '; Admission Application Number: ' ||
1383: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
1384: RPAD(p_old_sequence_number,6,' ') || ' Reason: ');
1385:
1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');

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

1383: RPAD(p_old_admission_appl_number,2,' ') || '; Course Code: ' || RPAD(p_nominated_course_cd,6,' ') || '; Sequence Number: '||
1384: RPAD(p_old_sequence_number,6,' ') || ' Reason: ');
1385:
1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
1387: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1388:
1389: FND_MESSAGE.SET_NAME('IGS',l_last_error);
1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
1391:

Line 1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);

1386: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CHILD_COPY_FAILED');
1387: Fnd_File.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1388:
1389: FND_MESSAGE.SET_NAME('IGS',l_last_error);
1390: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET || SQLERRM);
1391:
1392: RETURN FALSE;
1393: END copy_instance_child_records;
1394:

Line 1726: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

1722: l_application_created := FALSE;
1723: l_failed_records := l_failed_records + 1;
1724:
1725: ROLLBACK TO c_create_application;
1726: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
1727: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
1728: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
1729:
1730: IF (l_message_name IS NULL) THEN

Line 1739: fnd_file.put_line(fnd_file.log, l_msg_data);

1735: p_msg_data => l_msg_data,
1736: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1737:
1738: IF (l_msg_count > 0) THEN
1739: fnd_file.put_line(fnd_file.log, l_msg_data);
1740: ELSE
1741: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
1742: END IF;
1743: ELSE

Line 1741: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');

1737:
1738: IF (l_msg_count > 0) THEN
1739: fnd_file.put_line(fnd_file.log, l_msg_data);
1740: ELSE
1741: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
1742: END IF;
1743: ELSE
1744: fnd_file.put_line(fnd_file.log, l_message_name);
1745: END IF;

Line 1744: fnd_file.put_line(fnd_file.log, l_message_name);

1740: ELSE
1741: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
1742: END IF;
1743: ELSE
1744: fnd_file.put_line(fnd_file.log, l_message_name);
1745: END IF;
1746:
1747: END IF;
1748:

Line 1755: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

1751: l_application_created := FALSE;
1752: l_failed_records := l_failed_records + 1;
1753:
1754: ROLLBACK TO c_create_application;
1755: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
1756: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
1757: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
1758:
1759: IF (l_message_name IS NULL) THEN

Line 1768: fnd_file.put_line(fnd_file.log, l_msg_data);

1764: p_msg_data => l_msg_data,
1765: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1766:
1767: IF (l_msg_count > 0) THEN
1768: fnd_file.put_line(fnd_file.log, l_msg_data);
1769: ELSE
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
1771: END IF;
1772: ELSE

Line 1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');

1766:
1767: IF (l_msg_count > 0) THEN
1768: fnd_file.put_line(fnd_file.log, l_msg_data);
1769: ELSE
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
1771: END IF;
1772: ELSE
1773: fnd_file.put_line(fnd_file.log, l_message_name);
1774: END IF;

Line 1773: fnd_file.put_line(fnd_file.log, l_message_name);

1769: ELSE
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
1771: END IF;
1772: ELSE
1773: fnd_file.put_line(fnd_file.log, l_message_name);
1774: END IF;
1775: END;
1776:
1777: END IF;

Line 1830: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

1826: EXCEPTION
1827: WHEN OTHERS THEN
1828:
1829: ROLLBACK TO c_create_application;
1830: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
1831: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
1832: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
1833: fnd_message.set_name('IGS', 'Failed to update the Request for Reconsideration Checkbox: ' || SQLERRM );
1834: l_program_created := FALSE;

Line 1847: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

1843:
1844: l_failed_records := l_failed_records + 1;
1845:
1846: ROLLBACK TO c_create_application;
1847: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
1848: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
1849: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
1850:
1851:

Line 1861: fnd_file.put_line(fnd_file.log, l_msg_data);

1857: p_msg_data => l_msg_data,
1858: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1859:
1860: IF (l_msg_count > 0) THEN
1861: fnd_file.put_line(fnd_file.log, l_msg_data);
1862: ELSE
1863: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
1864: END IF;
1865: ELSE

Line 1863: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');

1859:
1860: IF (l_msg_count > 0) THEN
1861: fnd_file.put_line(fnd_file.log, l_msg_data);
1862: ELSE
1863: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
1864: END IF;
1865: ELSE
1866: fnd_file.put_line(fnd_file.log, l_message_name);
1867: END IF;

Line 1866: fnd_file.put_line(fnd_file.log, l_message_name);

1862: ELSE
1863: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
1864: END IF;
1865: ELSE
1866: fnd_file.put_line(fnd_file.log, l_message_name);
1867: END IF;
1868: END IF;
1869:
1870: EXCEPTION

Line 1877: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

1873:
1874: l_failed_records := l_failed_records + 1;
1875:
1876: ROLLBACK TO c_create_application;
1877: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
1878: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
1879: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
1880: IF (l_message_name IS NULL) THEN
1881: igs_ad_gen_016.extract_msg_from_stack (

Line 1889: fnd_file.put_line(fnd_file.log, l_msg_data);

1885: p_msg_data => l_msg_data,
1886: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1887:
1888: IF (l_msg_count > 0) THEN
1889: fnd_file.put_line(fnd_file.log, l_msg_data);
1890: ELSE
1891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
1892: END IF;
1893: ELSE

Line 1891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');

1887:
1888: IF (l_msg_count > 0) THEN
1889: fnd_file.put_line(fnd_file.log, l_msg_data);
1890: ELSE
1891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
1892: END IF;
1893: ELSE
1894: fnd_file.put_line(fnd_file.log, l_message_name);
1895: END IF;

Line 1894: fnd_file.put_line(fnd_file.log, l_message_name);

1890: ELSE
1891: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
1892: END IF;
1893: ELSE
1894: fnd_file.put_line(fnd_file.log, l_message_name);
1895: END IF;
1896: END;
1897:
1898: END IF;

Line 2312: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

2308: END IF;
2309:
2310: ELSE
2311:
2312: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2313: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2314: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2315:
2316: IF (l_message_name IS NULL) THEN

Line 2325: fnd_file.put_line(fnd_file.log, l_msg_data);

2321: p_msg_data => l_msg_data,
2322: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2323:
2324: IF (l_msg_count > 0) THEN
2325: fnd_file.put_line(fnd_file.log, l_msg_data);
2326: ELSE
2327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');
2328: END IF;
2329: ELSE

Line 2327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');

2323:
2324: IF (l_msg_count > 0) THEN
2325: fnd_file.put_line(fnd_file.log, l_msg_data);
2326: ELSE
2327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');
2328: END IF;
2329: ELSE
2330: fnd_file.put_line(fnd_file.log, l_message_name);
2331: END IF;

Line 2330: fnd_file.put_line(fnd_file.log, l_message_name);

2326: ELSE
2327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');
2328: END IF;
2329: ELSE
2330: fnd_file.put_line(fnd_file.log, l_message_name);
2331: END IF;
2332:
2333: l_failed_records := l_failed_records + 1;
2334: ROLLBACK TO c_create_application;

Line 2340: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

2336: END IF;
2337: --ELSE -- Else of Application Instance
2338: EXCEPTION
2339: WHEN OTHERS THEN
2340: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2341: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2342: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2343:
2344: l_failed_records := l_failed_records + 1;

Line 2357: fnd_file.put_line(fnd_file.log, fnd_message.get);

2353: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
2354: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
2355: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
2356: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
2357: fnd_file.put_line(fnd_file.log, fnd_message.get);
2358:
2359: ELSE
2360:
2361: fnd_message.set_name('IGS', l_message_name);

Line 2362: fnd_file.put_line(fnd_file.log, fnd_message.get);

2358:
2359: ELSE
2360:
2361: fnd_message.set_name('IGS', l_message_name);
2362: fnd_file.put_line(fnd_file.log, fnd_message.get);
2363:
2364: END IF;
2365: ROLLBACK TO c_create_application;
2366:

Line 2449: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

2445: l_application_created := FALSE;
2446: l_failed_records := l_failed_records + 1;
2447: ROLLBACK TO c_create_application;
2448:
2449: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2450: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2451: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2452: IF (l_message_name IS NULL) THEN
2453: igs_ad_gen_016.extract_msg_from_stack (

Line 2461: fnd_file.put_line(fnd_file.log, l_msg_data);

2457: p_msg_data => l_msg_data,
2458: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2459:
2460: IF (l_msg_count > 0) THEN
2461: fnd_file.put_line(fnd_file.log, l_msg_data);
2462: ELSE
2463: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
2464: END IF;
2465: ELSE

Line 2463: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');

2459:
2460: IF (l_msg_count > 0) THEN
2461: fnd_file.put_line(fnd_file.log, l_msg_data);
2462: ELSE
2463: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
2464: END IF;
2465: ELSE
2466: fnd_file.put_line(fnd_file.log, l_message_name);
2467: END IF;

Line 2466: fnd_file.put_line(fnd_file.log, l_message_name);

2462: ELSE
2463: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
2464: END IF;
2465: ELSE
2466: fnd_file.put_line(fnd_file.log, l_message_name);
2467: END IF;
2468: END IF;
2469: EXCEPTION
2470: WHEN OTHERS THEN

Line 2475: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

2471: l_application_created := FALSE;
2472: l_failed_records := l_failed_records + 1;
2473:
2474: ROLLBACK TO c_create_application;
2475: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2476: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2477: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2478:
2479: IF (l_message_name IS NULL) THEN

Line 2488: fnd_file.put_line(fnd_file.log, l_msg_data);

2484: p_msg_data => l_msg_data,
2485: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2486:
2487: IF (l_msg_count > 0) THEN
2488: fnd_file.put_line(fnd_file.log, l_msg_data);
2489: ELSE
2490: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
2491: END IF;
2492: ELSE

Line 2490: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');

2486:
2487: IF (l_msg_count > 0) THEN
2488: fnd_file.put_line(fnd_file.log, l_msg_data);
2489: ELSE
2490: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
2491: END IF;
2492: ELSE
2493: fnd_file.put_line(fnd_file.log, l_message_name);
2494: END IF;

Line 2493: fnd_file.put_line(fnd_file.log, l_message_name);

2489: ELSE
2490: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating the new application');
2491: END IF;
2492: ELSE
2493: fnd_file.put_line(fnd_file.log, l_message_name);
2494: END IF;
2495: END;
2496:
2497: END IF;

Line 2550: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

2546:
2547: EXCEPTION
2548: WHEN OTHERS THEN
2549: ROLLBACK TO c_create_application;
2550: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2551: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2552: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2553: fnd_message.set_name('IGS', 'Failed to update the Request for Reconsideration Checkbox: ' || SQLERRM );
2554: l_program_created:= FALSE;

Line 2567: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

2563:
2564: l_failed_records := l_failed_records + 1;
2565:
2566: ROLLBACK TO c_create_application;
2567: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2568: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2569: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2570:
2571: IF (l_message_name IS NULL) THEN

Line 2580: fnd_file.put_line(fnd_file.log, l_msg_data);

2576: p_msg_data => l_msg_data,
2577: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2578:
2579: IF (l_msg_count > 0) THEN
2580: fnd_file.put_line(fnd_file.log, l_msg_data);
2581: ELSE
2582: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
2583: END IF;
2584: ELSE

Line 2582: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');

2578:
2579: IF (l_msg_count > 0) THEN
2580: fnd_file.put_line(fnd_file.log, l_msg_data);
2581: ELSE
2582: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
2583: END IF;
2584: ELSE
2585: fnd_file.put_line(fnd_file.log, l_message_name);
2586: END IF;

Line 2585: fnd_file.put_line(fnd_file.log, l_message_name);

2581: ELSE
2582: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
2583: END IF;
2584: ELSE
2585: fnd_file.put_line(fnd_file.log, l_message_name);
2586: END IF;
2587: END IF;
2588: EXCEPTION
2589:

Line 2596: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

2592:
2593: l_failed_records := l_failed_records + 1;
2594:
2595: ROLLBACK TO c_create_application;
2596: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
2597: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
2598: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
2599: IF (l_message_name IS NULL) THEN
2600: igs_ad_gen_016.extract_msg_from_stack (

Line 2608: fnd_file.put_line(fnd_file.log, l_msg_data);

2604: p_msg_data => l_msg_data,
2605: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2606:
2607: IF (l_msg_count > 0) THEN
2608: fnd_file.put_line(fnd_file.log, l_msg_data);
2609: ELSE
2610: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
2611: END IF;
2612: ELSE

Line 2610: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');

2606:
2607: IF (l_msg_count > 0) THEN
2608: fnd_file.put_line(fnd_file.log, l_msg_data);
2609: ELSE
2610: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
2611: END IF;
2612: ELSE
2613: fnd_file.put_line(fnd_file.log, l_message_name);
2614: END IF;

Line 2613: fnd_file.put_line(fnd_file.log, l_message_name);

2609: ELSE
2610: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application program for the new application');
2611: END IF;
2612: ELSE
2613: fnd_file.put_line(fnd_file.log, l_message_name);
2614: END IF;
2615: END;
2616:
2617:

Line 3033: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

3029: END IF;
3030:
3031: ELSE -- Else of Application Instance
3032:
3033: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
3034: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
3035: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
3036:
3037: IF (l_message_name IS NULL) THEN

Line 3046: fnd_file.put_line(fnd_file.log, l_msg_data);

3042: p_msg_data => l_msg_data,
3043: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
3044:
3045: IF (l_msg_count > 0) THEN
3046: fnd_file.put_line(fnd_file.log, l_msg_data);
3047: ELSE
3048: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');
3049: END IF;
3050: ELSE

Line 3048: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');

3044:
3045: IF (l_msg_count > 0) THEN
3046: fnd_file.put_line(fnd_file.log, l_msg_data);
3047: ELSE
3048: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');
3049: END IF;
3050: ELSE
3051: fnd_file.put_line(fnd_file.log, l_message_name);
3052: END IF;

Line 3051: fnd_file.put_line(fnd_file.log, l_message_name);

3047: ELSE
3048: FND_FILE.PUT_LINE(FND_FILE.LOG,'Failed while creating application instance of the new program');
3049: END IF;
3050: ELSE
3051: fnd_file.put_line(fnd_file.log, l_message_name);
3052: END IF;
3053: l_failed_records := l_failed_records + 1;
3054:
3055: ROLLBACK TO c_create_application;

Line 3060: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||

3056: END IF;
3057: EXCEPTION
3058: WHEN OTHERS THEN
3059:
3060: fnd_file.put_line(fnd_file.log, 'Application Instance Creation Failed for Person ID: '|| RPAD(l_appl_inst_rec.person_id,15,' ') || '; Admission Application Number: ' ||
3061: RPAD(l_appl_inst_rec.admission_appl_number,2,' ') || '; Course Code: ' || RPAD(l_appl_inst_rec.nominated_course_cd,6,' ') || '; Sequence Number: '||
3062: RPAD(l_appl_inst_rec.sequence_number,6,' ') || ' Reason: ');
3063:
3064: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN

Line 3072: fnd_file.put_line(fnd_file.log, fnd_message.get);

3068: fnd_message.set_token('ALTCODE',l_appl_inst_rec.future_acad_cal_type||','||
3069: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_acad_ci_sequence_number)
3070: ||'/'||l_appl_inst_rec.future_adm_cal_type||','||
3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);
3073: ELSE
3074: fnd_message.set_name('IGS', l_message_name);
3075: fnd_file.put_line(fnd_file.log, fnd_message.get);
3076:

Line 3075: fnd_file.put_line(fnd_file.log, fnd_message.get);

3071: IGS_GE_NUMBER.TO_CANN(l_appl_inst_rec.future_adm_ci_sequence_number));
3072: fnd_file.put_line(fnd_file.log, fnd_message.get);
3073: ELSE
3074: fnd_message.set_name('IGS', l_message_name);
3075: fnd_file.put_line(fnd_file.log, fnd_message.get);
3076:
3077: END IF;
3078: ROLLBACK TO c_create_application;
3079: END;

Line 3087: fnd_file.put_line(fnd_file.log,'Total Number of Records Processed: ' || l_total_records);

3083: END LOOP;
3084:
3085: END IF;
3086:
3087: fnd_file.put_line(fnd_file.log,'Total Number of Records Processed: ' || l_total_records);
3088: fnd_file.put_line(fnd_file.log,'Total Number of Successful Records: ' || l_successful_records);
3089: fnd_file.put_line(fnd_file.log,'Total Number of Unsucessful Records: ' || l_failed_records);
3090:
3091: EXCEPTION WHEN OTHERS THEN

Line 3088: fnd_file.put_line(fnd_file.log,'Total Number of Successful Records: ' || l_successful_records);

3084:
3085: END IF;
3086:
3087: fnd_file.put_line(fnd_file.log,'Total Number of Records Processed: ' || l_total_records);
3088: fnd_file.put_line(fnd_file.log,'Total Number of Successful Records: ' || l_successful_records);
3089: fnd_file.put_line(fnd_file.log,'Total Number of Unsucessful Records: ' || l_failed_records);
3090:
3091: EXCEPTION WHEN OTHERS THEN
3092:

Line 3089: fnd_file.put_line(fnd_file.log,'Total Number of Unsucessful Records: ' || l_failed_records);

3085: END IF;
3086:
3087: fnd_file.put_line(fnd_file.log,'Total Number of Records Processed: ' || l_total_records);
3088: fnd_file.put_line(fnd_file.log,'Total Number of Successful Records: ' || l_successful_records);
3089: fnd_file.put_line(fnd_file.log,'Total Number of Unsucessful Records: ' || l_failed_records);
3090:
3091: EXCEPTION WHEN OTHERS THEN
3092:
3093: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || l_message_name);

Line 3093: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || l_message_name);

3089: fnd_file.put_line(fnd_file.log,'Total Number of Unsucessful Records: ' || l_failed_records);
3090:
3091: EXCEPTION WHEN OTHERS THEN
3092:
3093: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || l_message_name);
3094: retcode:=2;
3095:
3096: END admp_init_reconsider;
3097: