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_PS_USEC_SCHEDULE dependencies on FND_MESSAGE

Line 738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_EXISTS');

734:
735: OPEN usec_x_grp_name(p_uoo_cur_rec.uoo_id);
736: FETCH usec_x_grp_name INTO l_usec_x_grp_name;
737: IF usec_x_grp_name%NOTFOUND THEN
738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_EXISTS');
739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
740: l_usec_x_grp_name := NULL;
741: ROLLBACK;
742: retcode := 2;

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

735: OPEN usec_x_grp_name(p_uoo_cur_rec.uoo_id);
736: FETCH usec_x_grp_name INTO l_usec_x_grp_name;
737: IF usec_x_grp_name%NOTFOUND THEN
738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_EXISTS');
739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
740: l_usec_x_grp_name := NULL;
741: ROLLBACK;
742: retcode := 2;
743: RETURN;

Line 750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_MAX_EXISTS');

746:
747: OPEN max_enr_x_grp(p_uoo_cur_rec.uoo_id);
748: FETCH max_enr_x_grp INTO l_max_enr_x_grp;
749: IF max_enr_x_grp%NOTFOUND THEN
750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_MAX_EXISTS');
751: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
752: l_max_enr_x_grp := NULL;
753: ROLLBACK;
754: retcode := 2;

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

747: OPEN max_enr_x_grp(p_uoo_cur_rec.uoo_id);
748: FETCH max_enr_x_grp INTO l_max_enr_x_grp;
749: IF max_enr_x_grp%NOTFOUND THEN
750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_GRP_MAX_EXISTS');
751: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
752: l_max_enr_x_grp := NULL;
753: ROLLBACK;
754: retcode := 2;
755: RETURN;

Line 832: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_EXISTS');

828:
829: OPEN meet_with_grp_name(p_uoo_cur_rec.uoo_id);
830: FETCH meet_with_grp_name INTO l_meet_with_grp_name;
831: IF meet_with_grp_name%NOTFOUND THEN
832: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_EXISTS');
833: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
834: ROLLBACK;
835: RETCODE := 2;
836: RETURN;

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

829: OPEN meet_with_grp_name(p_uoo_cur_rec.uoo_id);
830: FETCH meet_with_grp_name INTO l_meet_with_grp_name;
831: IF meet_with_grp_name%NOTFOUND THEN
832: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_EXISTS');
833: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
834: ROLLBACK;
835: RETCODE := 2;
836: RETURN;
837: END IF;

Line 843: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_MAX_EXISTS');

839:
840: OPEN max_enr_meet_grp(p_uoo_cur_rec.uoo_id);
841: FETCH max_enr_meet_grp INTO l_max_enr_meet_grp;
842: IF max_enr_meet_grp%NOTFOUND THEN
843: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_MAX_EXISTS');
844: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
845: ROLLBACK;
846: RETCODE := 2;
847: RETURN;

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

840: OPEN max_enr_meet_grp(p_uoo_cur_rec.uoo_id);
841: FETCH max_enr_meet_grp INTO l_max_enr_meet_grp;
842: IF max_enr_meet_grp%NOTFOUND THEN
843: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_MEET_GRP_MAX_EXISTS');
844: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
845: ROLLBACK;
846: RETCODE := 2;
847: RETURN;
848: END IF;

Line 1343: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_NAMES_EXISTS');

1339: --function get_instructor_info populates lead instructor identifier, given name(first name), middle name
1340: --and last name in the local variables l_lead_instructor_id, l_given_names ,l_middle_name and l_surname respectively.
1341: -- returns false only when lead instructor is set at unit section and could not fetch instructor details.
1342: IF NOT get_instructor_info(uoo_cur_rec.uoo_id) THEN
1343: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_NAMES_EXISTS');
1344: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1345: ROLLBACK;
1346: RETCODE := 2;
1347: RETURN;

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

1340: --and last name in the local variables l_lead_instructor_id, l_given_names ,l_middle_name and l_surname respectively.
1341: -- returns false only when lead instructor is set at unit section and could not fetch instructor details.
1342: IF NOT get_instructor_info(uoo_cur_rec.uoo_id) THEN
1343: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_NAMES_EXISTS');
1344: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1345: ROLLBACK;
1346: RETCODE := 2;
1347: RETURN;
1348: END IF;

Line 1634: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_SOFT_NOT_INSTLD');

1630: -- Profile name (IGS: Indicates whether Scheduling Software is installed.)
1631: -- Give a message to user if the software is not installed and
1632: -- stop the further processing
1633: IF (NVL(FND_PROFILE.VALUE('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN
1634: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_SOFT_NOT_INSTLD');
1635: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1636: retcode := 2;
1637: RETURN;
1638: END IF;

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

1631: -- Give a message to user if the software is not installed and
1632: -- stop the further processing
1633: IF (NVL(FND_PROFILE.VALUE('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN
1634: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_SOFT_NOT_INSTLD');
1635: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1636: retcode := 2;
1637: RETURN;
1638: END IF;
1639:

Line 1643: FND_MESSAGE.SET_NAME('IGS','IGS_GE_NOT_ENGH_PARAM');

1639:
1640:
1641: -- Not enough parameters condition
1642: IF ( (p_teach_prd IS NULL) AND (p_uoo_id IS NULL) AND (p_usec_id IS NULL ) AND (p_sch_type IS NULL) ) THEN
1643: FND_MESSAGE.SET_NAME('IGS','IGS_GE_NOT_ENGH_PARAM');
1644: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1645: retcode := 2;
1646: RETURN;
1647: END IF;

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

1640:
1641: -- Not enough parameters condition
1642: IF ( (p_teach_prd IS NULL) AND (p_uoo_id IS NULL) AND (p_usec_id IS NULL ) AND (p_sch_type IS NULL) ) THEN
1643: FND_MESSAGE.SET_NAME('IGS','IGS_GE_NOT_ENGH_PARAM');
1644: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1645: retcode := 2;
1646: RETURN;
1647: END IF;
1648:

Line 1657: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');

1653: OPEN c_end_dt(p_uoo_id);
1654: FETCH c_end_dt INTO rec_end_dt;
1655: CLOSE c_end_dt;
1656: IF TRUNC(rec_end_dt.cal_end_dt) < TRUNC(sysdate) THEN
1657: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');
1658: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1659: ROLLBACK;
1660: retcode := 2;
1661: RETURN;

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

1654: FETCH c_end_dt INTO rec_end_dt;
1655: CLOSE c_end_dt;
1656: IF TRUNC(rec_end_dt.cal_end_dt) < TRUNC(sysdate) THEN
1657: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');
1658: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1659: ROLLBACK;
1660: retcode := 2;
1661: RETURN;
1662: END IF;

Line 1669: FND_MESSAGE.SET_NAME('IGS','IGS_PS_INVALID_SCHTYPE');

1665:
1666: -- check the valid values for the sch_type
1667: IF p_sch_type IS NOT NULL AND p_sch_type NOT IN ('REQUEST', 'UPDATE', 'CANCEL' ) THEN
1668:
1669: FND_MESSAGE.SET_NAME('IGS','IGS_PS_INVALID_SCHTYPE');
1670: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1671: retcode := 2;
1672: RETURN;
1673: END IF;

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

1666: -- check the valid values for the sch_type
1667: IF p_sch_type IS NOT NULL AND p_sch_type NOT IN ('REQUEST', 'UPDATE', 'CANCEL' ) THEN
1668:
1669: FND_MESSAGE.SET_NAME('IGS','IGS_PS_INVALID_SCHTYPE');
1670: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1671: retcode := 2;
1672: RETURN;
1673: END IF;
1674:

Line 1689: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');

1685:
1686: -- Check for End date is <= sysdate
1687: -- Thus avoiding scheduling of past teaching periods.
1688: IF TRUNC(l_end_date) < TRUNC(sysdate) THEN
1689: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');
1690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1691: ROLLBACK;
1692: retcode := 2;
1693: RETURN;

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

1686: -- Check for End date is <= sysdate
1687: -- Thus avoiding scheduling of past teaching periods.
1688: IF TRUNC(l_end_date) < TRUNC(sysdate) THEN
1689: FND_MESSAGE.SET_NAME('IGS','IGS_PS_CANT_SCH_PAST_TP');
1690: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1691: ROLLBACK;
1692: retcode := 2;
1693: RETURN;
1694: END IF;

Line 1738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_DATA_TRANSFER');

1734: END IF;
1735:
1736: -- if there exist no valid USO then transfer of data should not take place and rollback should take place for the earlier inserted records
1737: IF l_data_found = FALSE THEN
1738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_DATA_TRANSFER');
1739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1740: ROLLBACK;
1741: RETURN;
1742: END IF;

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

1735:
1736: -- if there exist no valid USO then transfer of data should not take place and rollback should take place for the earlier inserted records
1737: IF l_data_found = FALSE THEN
1738: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_DATA_TRANSFER');
1739: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1740: ROLLBACK;
1741: RETURN;
1742: END IF;
1743:

Line 1750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_PRS_INIT_SUCCESS');

1746:
1747:
1748: -- End of Procedure
1749: retcode := 0;
1750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_PRS_INIT_SUCCESS');
1751: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1752: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1753:
1754: EXCEPTION

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

1748: -- End of Procedure
1749: retcode := 0;
1750: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_PRS_INIT_SUCCESS');
1751: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1752: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1753:
1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: ROLLBACK;

Line 1759: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') ;

1755: WHEN OTHERS THEN
1756: ROLLBACK;
1757: retcode:=2;
1758: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
1759: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') ;
1760: Igs_Ge_Msg_Stack.CONC_EXCEPTION_HNDL;
1761:
1762: END prgp_init_prs_sched;
1763:

Line 1857: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

1853: END IF;
1854:
1855: EXCEPTION
1856: WHEN OTHERS THEN
1857: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1858: IGS_GE_MSG_STACK.ADD;
1859: App_Exception.Raise_Exception;
1860: END prgp_get_schd_status;
1861:

Line 1910: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

1906:
1907: EXCEPTION
1908: WHEN OTHERS THEN
1909: retcode :=2;
1910: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
1911: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1912: ROLLBACK;
1913: END prgp_schd_purge_data;
1914:

Line 2054: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2050: END LOOP;
2051:
2052: EXCEPTION
2053: WHEN OTHERS THEN
2054: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2055: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls:upd_usec_occurs_schd_status');
2056: IGS_GE_MSG_STACK.ADD;
2057: APP_EXCEPTION.RAISE_EXCEPTION;
2058:

Line 2055: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls:upd_usec_occurs_schd_status');

2051:
2052: EXCEPTION
2053: WHEN OTHERS THEN
2054: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2055: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls:upd_usec_occurs_schd_status');
2056: IGS_GE_MSG_STACK.ADD;
2057: APP_EXCEPTION.RAISE_EXCEPTION;
2058:
2059: END upd_usec_occurs_schd_status;

Line 2128: FND_MESSAGE.RETRIEVE(p_message_name);

2124: argument83 => '', argument84 => '', argument85 => '', argument86 => '', argument87 => '', argument88 => '', argument89 => '',
2125: argument90 => '', argument91 => '', argument92 => '', argument93 => '', argument94 => '', argument95 => '', argument96 => '',
2126: argument97 => '', argument98 => '', argument99 => '', argument100 => '');
2127: IF p_request_id = 0 THEN
2128: FND_MESSAGE.RETRIEVE(p_message_name);
2129: RETURN FALSE;
2130: END IF;
2131: p_message_name := 'IGS_PS_SCST_CAN';
2132: RETURN TRUE;

Line 2135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2131: p_message_name := 'IGS_PS_SCST_CAN';
2132: RETURN TRUE;
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2136: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2137: igs_ge_msg_stack.add;
2138: APP_EXCEPTION.RAISE_EXCEPTION;
2139: END;

Line 2136: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');

2132: RETURN TRUE;
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2136: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2137: igs_ge_msg_stack.add;
2138: APP_EXCEPTION.RAISE_EXCEPTION;
2139: END;
2140: --

Line 2157: FND_MESSAGE.SET_NAME('IGS',l_message);

2153: p_usec_occur_id => NULL,
2154: p_event_type => 'CNCL',
2155: p_message => l_message);
2156: IF l_message IS NOT NULL THEN
2157: FND_MESSAGE.SET_NAME('IGS',l_message);
2158: IGS_GE_MSG_STACK.ADD;
2159: APP_EXCEPTION.RAISE_EXCEPTION;
2160: END IF;
2161: END IF;

Line 2179: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2175: p_message_name := 'IGS_PS_SCST_UPD';
2176: RETURN TRUE;
2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2180: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2181: igs_ge_msg_stack.add;
2182: APP_EXCEPTION.RAISE_EXCEPTION;
2183: END;

Line 2180: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');

2176: RETURN TRUE;
2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2180: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2181: igs_ge_msg_stack.add;
2182: APP_EXCEPTION.RAISE_EXCEPTION;
2183: END;
2184: ELSIF ( p_max_enrollments IS NOT NULL or p_override_enrollment_max IS NOT NULL or p_enrollment_expected IS NOT NULL) THEN -- Maximum Enrollment case

Line 2199: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2195: p_message_name := 'IGS_PS_SCST_UPD';
2196: RETURN TRUE;
2197: EXCEPTION
2198: WHEN OTHERS THEN
2199: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2200: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2201: igs_ge_msg_stack.add;
2202: APP_EXCEPTION.RAISE_EXCEPTION;
2203: END;

Line 2200: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');

2196: RETURN TRUE;
2197: EXCEPTION
2198: WHEN OTHERS THEN
2199: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2200: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2201: igs_ge_msg_stack.add;
2202: APP_EXCEPTION.RAISE_EXCEPTION;
2203: END;
2204: END IF;

Line 2207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2203: END;
2204: END IF;
2205: EXCEPTION
2206: WHEN OTHERS THEN
2207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2208: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2209: igs_ge_msg_stack.add;
2210: APP_EXCEPTION.RAISE_EXCEPTION;
2211:

Line 2208: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');

2204: END IF;
2205: EXCEPTION
2206: WHEN OTHERS THEN
2207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2208: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls');
2209: igs_ge_msg_stack.add;
2210: APP_EXCEPTION.RAISE_EXCEPTION;
2211:
2212:

Line 2548: errbuf:=FND_MESSAGE.GET_STRING('IGS',l_message);

2544: EXCEPTION
2545:
2546: WHEN VALID THEN
2547: retcode:=0;
2548: errbuf:=FND_MESSAGE.GET_STRING('IGS',l_message);
2549: WHEN INVALID THEN
2550: retcode:=2;
2551: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);
2552: WHEN dirnotfound THEN

Line 2551: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);

2547: retcode:=0;
2548: errbuf:=FND_MESSAGE.GET_STRING('IGS',l_message);
2549: WHEN INVALID THEN
2550: retcode:=2;
2551: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);
2552: WHEN dirnotfound THEN
2553: retcode:=2;
2554: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);
2555: WHEN OTHERS THEN

Line 2554: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);

2550: retcode:=2;
2551: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);
2552: WHEN dirnotfound THEN
2553: retcode:=2;
2554: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);
2555: WHEN OTHERS THEN
2556: retcode:=2;
2557: errbuf:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2558: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

Line 2557: errbuf:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

2553: retcode:=2;
2554: errbuf :=FND_MESSAGE.GET_STRING('IGS',l_message);
2555: WHEN OTHERS THEN
2556: retcode:=2;
2557: errbuf:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2558: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2559:
2560: END prgp_write_ref_file;
2561:

Line 2980: fnd_message.set_name('IGS','IGS_PS_SCH_TBA_USO_NSD_USEC');

2976: IF rec_prd_uso.to_be_announced = 'Y' AND p_c_sch_status = 'SCHEDULED' THEN
2977: OPEN c_nstd_us(p_n_prd_uso_id);
2978: FETCH c_nstd_us INTO l_c_exists;
2979: IF c_nstd_us%FOUND THEN
2980: fnd_message.set_name('IGS','IGS_PS_SCH_TBA_USO_NSD_USEC');
2981: fnd_file.put_line(fnd_file.LOG,' ' ||fnd_message.get);
2982: END IF;
2983: CLOSE c_nstd_us;
2984: END IF;

Line 2981: fnd_file.put_line(fnd_file.LOG,' ' ||fnd_message.get);

2977: OPEN c_nstd_us(p_n_prd_uso_id);
2978: FETCH c_nstd_us INTO l_c_exists;
2979: IF c_nstd_us%FOUND THEN
2980: fnd_message.set_name('IGS','IGS_PS_SCH_TBA_USO_NSD_USEC');
2981: fnd_file.put_line(fnd_file.LOG,' ' ||fnd_message.get);
2982: END IF;
2983: CLOSE c_nstd_us;
2984: END IF;
2985:

Line 2990: l_c_err_text:=fnd_message.get || sqlerrm;

2986: EXCEPTION
2987: WHEN OTHERS THEN
2988: l_c_sch_status := 'ERROR' ;
2989: l_c_trans_type := 'INCOMPLETE';
2990: l_c_err_text:=fnd_message.get || sqlerrm;
2991: -- Update production table with exception error(i.e. error text and schedule status)
2992: igs_ps_usec_occurs_pkg.update_row
2993: (
2994: X_Mode => 'R',

Line 3134: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');

3130: FETCH c_get_originator INTO l_originator;
3131: IF (c_get_originator%NOTFOUND) THEN
3132: CLOSE c_get_originator;
3133: retcode:=2;
3134: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');
3135: fnd_file.put_line(fnd_file.log,fnd_message.get);
3136: app_exception.raise_exception;
3137: END IF;
3138: CLOSE c_get_originator; -- closing cursor for originator id

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

3131: IF (c_get_originator%NOTFOUND) THEN
3132: CLOSE c_get_originator;
3133: retcode:=2;
3134: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');
3135: fnd_file.put_line(fnd_file.log,fnd_message.get);
3136: app_exception.raise_exception;
3137: END IF;
3138: CLOSE c_get_originator; -- closing cursor for originator id
3139:

Line 3173: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');

3169: FETCH c_ipsuo INTO l_ipsuo;
3170: IF (c_ipsuo%NOTFOUND) THEN
3171: CLOSE c_ipsuo;
3172: retcode:=2;
3173: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');
3174: fnd_file.put_line(fnd_file.log,fnd_message.get);
3175: app_exception.raise_exception;
3176: END IF;
3177: -- This is added as part of bug#4287940

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

3170: IF (c_ipsuo%NOTFOUND) THEN
3171: CLOSE c_ipsuo;
3172: retcode:=2;
3173: fnd_message.set_name('IGS','IGS_GE_VAL_DOES_NOT_XS');
3174: fnd_file.put_line(fnd_file.log,fnd_message.get);
3175: app_exception.raise_exception;
3176: END IF;
3177: -- This is added as part of bug#4287940
3178: l_tba_status := l_ipsuo.to_be_announced;

Line 3193: fnd_message.set_name('IGS','IGS_PS_USO_SCHED');

3189: -- Also set the values of variables l_set_scheduled_status and l_transaction_type to be used to update interface table
3190: l_status:=l_ipsuo.schedule_status;
3191: IF l_status = 'SCHEDULED' OR (l_originator = 'EXTERNAL' AND l_status IN ('PROCESSING','USER_UPDATE','USER_CANCEL')) THEN
3192: IF l_status = 'SCHEDULED' THEN
3193: fnd_message.set_name('IGS','IGS_PS_USO_SCHED');
3194: l_error_text:= fnd_message.get;
3195: l_set_scheduled_status := 'SCHEDULED';
3196: l_set_transaction_type := 'COMPLETE';
3197: ELSE

Line 3194: l_error_text:= fnd_message.get;

3190: l_status:=l_ipsuo.schedule_status;
3191: IF l_status = 'SCHEDULED' OR (l_originator = 'EXTERNAL' AND l_status IN ('PROCESSING','USER_UPDATE','USER_CANCEL')) THEN
3192: IF l_status = 'SCHEDULED' THEN
3193: fnd_message.set_name('IGS','IGS_PS_USO_SCHED');
3194: l_error_text:= fnd_message.get;
3195: l_set_scheduled_status := 'SCHEDULED';
3196: l_set_transaction_type := 'COMPLETE';
3197: ELSE
3198: fnd_message.set_name('IGS','IGS_PS_CONFLICT_SCHD');

Line 3198: fnd_message.set_name('IGS','IGS_PS_CONFLICT_SCHD');

3194: l_error_text:= fnd_message.get;
3195: l_set_scheduled_status := 'SCHEDULED';
3196: l_set_transaction_type := 'COMPLETE';
3197: ELSE
3198: fnd_message.set_name('IGS','IGS_PS_CONFLICT_SCHD');
3199: l_error_text:= fnd_message.get;
3200: l_set_scheduled_status := 'ERROR';
3201: l_set_transaction_type := 'INCOMPLETE';
3202: END IF;

Line 3199: l_error_text:= fnd_message.get;

3195: l_set_scheduled_status := 'SCHEDULED';
3196: l_set_transaction_type := 'COMPLETE';
3197: ELSE
3198: fnd_message.set_name('IGS','IGS_PS_CONFLICT_SCHD');
3199: l_error_text:= fnd_message.get;
3200: l_set_scheduled_status := 'ERROR';
3201: l_set_transaction_type := 'INCOMPLETE';
3202: END IF;
3203:

Line 3208: fnd_message.set_name('IGS','IGS_PS_REF_3RD_PRTY_SW_ERR');

3204: -- if the scheduling software could not schedules a unit section occurrence (schedule_status ='ERROR') then scheduling software
3205: -- should provide the error message. if error message is not provided then set the default error message 'IGS_PS_REF_3RD_PRTY_SW_ERR'
3206: ELSIF l_schedule_status = 'ERROR' THEN
3207: IF l_inter_error_text IS NULL THEN
3208: fnd_message.set_name('IGS','IGS_PS_REF_3RD_PRTY_SW_ERR');
3209: l_error_text:= fnd_message.get;
3210: ELSE
3211: l_error_text:=l_inter_error_text;
3212: END IF; -- end of l_inter_error_text

Line 3209: l_error_text:= fnd_message.get;

3205: -- should provide the error message. if error message is not provided then set the default error message 'IGS_PS_REF_3RD_PRTY_SW_ERR'
3206: ELSIF l_schedule_status = 'ERROR' THEN
3207: IF l_inter_error_text IS NULL THEN
3208: fnd_message.set_name('IGS','IGS_PS_REF_3RD_PRTY_SW_ERR');
3209: l_error_text:= fnd_message.get;
3210: ELSE
3211: l_error_text:=l_inter_error_text;
3212: END IF; -- end of l_inter_error_text
3213: --Added to get the values of variables to be set in interface table

Line 3277: fnd_message.set_name('IGS','IGS_PS_USO_TBA_STATUS');

3273: ( (NVL(l_sunday,'N') = 'N') AND (NVL(l_monday,'N') = 'N') AND (NVL(l_tuesday,'N') = 'N') AND (NVL(l_wednesday,'N') = 'N')
3274: AND (NVL(l_thursday,'N') = 'N') AND (NVL(l_friday,'N') = 'N') AND (NVL(l_saturday,'N') = 'N') ) THEN
3275: --check for the value of tba_status,If 'Y' then set the corresponding error textwith scheduled status = 'TBA'
3276: IF fetch_records_inter.tba_status = 'Y' THEN
3277: fnd_message.set_name('IGS','IGS_PS_USO_TBA_STATUS');
3278: l_error_text:= fnd_message.get;
3279: l_set_scheduled_status := 'TBA' ;
3280: ELSE
3281: IF l_inter_error_text IS NULL THEN

Line 3278: l_error_text:= fnd_message.get;

3274: AND (NVL(l_thursday,'N') = 'N') AND (NVL(l_friday,'N') = 'N') AND (NVL(l_saturday,'N') = 'N') ) THEN
3275: --check for the value of tba_status,If 'Y' then set the corresponding error textwith scheduled status = 'TBA'
3276: IF fetch_records_inter.tba_status = 'Y' THEN
3277: fnd_message.set_name('IGS','IGS_PS_USO_TBA_STATUS');
3278: l_error_text:= fnd_message.get;
3279: l_set_scheduled_status := 'TBA' ;
3280: ELSE
3281: IF l_inter_error_text IS NULL THEN
3282: fnd_message.set_name('IGS','IGS_PS_VALUES_NULL');

Line 3282: fnd_message.set_name('IGS','IGS_PS_VALUES_NULL');

3278: l_error_text:= fnd_message.get;
3279: l_set_scheduled_status := 'TBA' ;
3280: ELSE
3281: IF l_inter_error_text IS NULL THEN
3282: fnd_message.set_name('IGS','IGS_PS_VALUES_NULL');
3283: l_error_text:= fnd_message.get;
3284: ELSE
3285: l_error_text:=l_inter_error_text;
3286: END IF;

Line 3283: l_error_text:= fnd_message.get;

3279: l_set_scheduled_status := 'TBA' ;
3280: ELSE
3281: IF l_inter_error_text IS NULL THEN
3282: fnd_message.set_name('IGS','IGS_PS_VALUES_NULL');
3283: l_error_text:= fnd_message.get;
3284: ELSE
3285: l_error_text:=l_inter_error_text;
3286: END IF;
3287: l_set_scheduled_status := 'ERROR';

Line 3304: fnd_message.set_name('IGS', 'IGS_GE_ST_TIME_LT_END_TIME');

3300:
3301: IF l_start_time IS NOT NULL AND l_end_time IS NOT NULL THEN
3302: IF TO_CHAR(l_start_time,'HH24:MI:SS') > TO_CHAR(l_end_time,'HH24:MI:SS') THEN
3303: -- start time should be less than end time.
3304: fnd_message.set_name('IGS', 'IGS_GE_ST_TIME_LT_END_TIME');
3305: l_error_text := fnd_message.get;
3306: END IF;
3307: END IF;
3308:

Line 3305: l_error_text := fnd_message.get;

3301: IF l_start_time IS NOT NULL AND l_end_time IS NOT NULL THEN
3302: IF TO_CHAR(l_start_time,'HH24:MI:SS') > TO_CHAR(l_end_time,'HH24:MI:SS') THEN
3303: -- start time should be less than end time.
3304: fnd_message.set_name('IGS', 'IGS_GE_ST_TIME_LT_END_TIME');
3305: l_error_text := fnd_message.get;
3306: END IF;
3307: END IF;
3308:
3309: -- if the unit section occurrence start / end date is not provided by user in the system then it would be

Line 3320: fnd_message.set_name('IGS','IGS_PE_EDT_LT_SDT');

3316: IF l_d_uso_start_date IS NOT NULL AND l_d_uso_end_date IS NOT NULL THEN
3317:
3318: -- Unit section occurrence start date should be less than end date
3319: IF l_d_uso_end_date < l_d_uso_start_date THEN
3320: fnd_message.set_name('IGS','IGS_PE_EDT_LT_SDT');
3321: l_error_text := fnd_message.get;
3322: END IF;
3323:
3324: IF l_d_uso_start_date IS NOT NULL THEN

Line 3321: l_error_text := fnd_message.get;

3317:
3318: -- Unit section occurrence start date should be less than end date
3319: IF l_d_uso_end_date < l_d_uso_start_date THEN
3320: fnd_message.set_name('IGS','IGS_PE_EDT_LT_SDT');
3321: l_error_text := fnd_message.get;
3322: END IF;
3323:
3324: IF l_d_uso_start_date IS NOT NULL THEN
3325: IF rec_date.us_start_date IS NOT NULL THEN

Line 3327: fnd_message.set_name ('IGS','IGS_PS_USO_STDT_GE_US_STDT');

3323:
3324: IF l_d_uso_start_date IS NOT NULL THEN
3325: IF rec_date.us_start_date IS NOT NULL THEN
3326: IF l_d_uso_start_date < rec_date.us_start_date THEN
3327: fnd_message.set_name ('IGS','IGS_PS_USO_STDT_GE_US_STDT');
3328: l_error_text := fnd_message.get;
3329: END IF;
3330: ELSE
3331: IF l_d_uso_start_date < rec_date.tp_start_date THEN

Line 3328: l_error_text := fnd_message.get;

3324: IF l_d_uso_start_date IS NOT NULL THEN
3325: IF rec_date.us_start_date IS NOT NULL THEN
3326: IF l_d_uso_start_date < rec_date.us_start_date THEN
3327: fnd_message.set_name ('IGS','IGS_PS_USO_STDT_GE_US_STDT');
3328: l_error_text := fnd_message.get;
3329: END IF;
3330: ELSE
3331: IF l_d_uso_start_date < rec_date.tp_start_date THEN
3332: fnd_message.set_name ('IGS','IGS_PS_USO_STDT_GE_TP_STDT');

Line 3332: fnd_message.set_name ('IGS','IGS_PS_USO_STDT_GE_TP_STDT');

3328: l_error_text := fnd_message.get;
3329: END IF;
3330: ELSE
3331: IF l_d_uso_start_date < rec_date.tp_start_date THEN
3332: fnd_message.set_name ('IGS','IGS_PS_USO_STDT_GE_TP_STDT');
3333: l_error_text := fnd_message.get;
3334: END IF;
3335: END IF;
3336:

Line 3333: l_error_text := fnd_message.get;

3329: END IF;
3330: ELSE
3331: IF l_d_uso_start_date < rec_date.tp_start_date THEN
3332: fnd_message.set_name ('IGS','IGS_PS_USO_STDT_GE_TP_STDT');
3333: l_error_text := fnd_message.get;
3334: END IF;
3335: END IF;
3336:
3337: IF rec_date.us_end_date IS NOT NULL THEN

Line 3339: fnd_message.set_name ('IGS','IGS_PS_USO_ST_DT_UOO_END_DT');

3335: END IF;
3336:
3337: IF rec_date.us_end_date IS NOT NULL THEN
3338: IF l_d_uso_start_date > rec_date.us_end_date THEN
3339: fnd_message.set_name ('IGS','IGS_PS_USO_ST_DT_UOO_END_DT');
3340: l_error_text := fnd_message.get;
3341: END IF;
3342: ELSE
3343: IF l_d_uso_start_date > rec_date.tp_end_date THEN

Line 3340: l_error_text := fnd_message.get;

3336:
3337: IF rec_date.us_end_date IS NOT NULL THEN
3338: IF l_d_uso_start_date > rec_date.us_end_date THEN
3339: fnd_message.set_name ('IGS','IGS_PS_USO_ST_DT_UOO_END_DT');
3340: l_error_text := fnd_message.get;
3341: END IF;
3342: ELSE
3343: IF l_d_uso_start_date > rec_date.tp_end_date THEN
3344: fnd_message.set_name ('IGS','IGS_PS_USO_ST_DT_TP_END_DT');

Line 3344: fnd_message.set_name ('IGS','IGS_PS_USO_ST_DT_TP_END_DT');

3340: l_error_text := fnd_message.get;
3341: END IF;
3342: ELSE
3343: IF l_d_uso_start_date > rec_date.tp_end_date THEN
3344: fnd_message.set_name ('IGS','IGS_PS_USO_ST_DT_TP_END_DT');
3345: l_error_text := fnd_message.get;
3346: END IF;
3347: END IF;
3348: END IF;

Line 3345: l_error_text := fnd_message.get;

3341: END IF;
3342: ELSE
3343: IF l_d_uso_start_date > rec_date.tp_end_date THEN
3344: fnd_message.set_name ('IGS','IGS_PS_USO_ST_DT_TP_END_DT');
3345: l_error_text := fnd_message.get;
3346: END IF;
3347: END IF;
3348: END IF;
3349:

Line 3353: fnd_message.set_name ('IGS','IGS_PS_USO_END_DT_UOO_ST_DT');

3349:
3350: IF l_d_uso_end_date IS NOT NULL THEN
3351: IF rec_date.us_start_date IS NOT NULL THEN
3352: IF l_d_uso_end_date < rec_date.us_start_date THEN
3353: fnd_message.set_name ('IGS','IGS_PS_USO_END_DT_UOO_ST_DT');
3354: l_error_text := fnd_message.get;
3355: END IF;
3356: ELSE
3357: IF l_d_uso_end_date < rec_date.tp_start_date THEN

Line 3354: l_error_text := fnd_message.get;

3350: IF l_d_uso_end_date IS NOT NULL THEN
3351: IF rec_date.us_start_date IS NOT NULL THEN
3352: IF l_d_uso_end_date < rec_date.us_start_date THEN
3353: fnd_message.set_name ('IGS','IGS_PS_USO_END_DT_UOO_ST_DT');
3354: l_error_text := fnd_message.get;
3355: END IF;
3356: ELSE
3357: IF l_d_uso_end_date < rec_date.tp_start_date THEN
3358: fnd_message.set_name ('IGS','IGS_PS_USO_END_DT_TP_ST_DT');

Line 3358: fnd_message.set_name ('IGS','IGS_PS_USO_END_DT_TP_ST_DT');

3354: l_error_text := fnd_message.get;
3355: END IF;
3356: ELSE
3357: IF l_d_uso_end_date < rec_date.tp_start_date THEN
3358: fnd_message.set_name ('IGS','IGS_PS_USO_END_DT_TP_ST_DT');
3359: l_error_text := fnd_message.get;
3360: END IF;
3361: END IF;
3362:

Line 3359: l_error_text := fnd_message.get;

3355: END IF;
3356: ELSE
3357: IF l_d_uso_end_date < rec_date.tp_start_date THEN
3358: fnd_message.set_name ('IGS','IGS_PS_USO_END_DT_TP_ST_DT');
3359: l_error_text := fnd_message.get;
3360: END IF;
3361: END IF;
3362:
3363: IF rec_date.us_end_date IS NOT NULL THEN

Line 3365: fnd_message.set_name ('IGS','IGS_PS_USO_ENDT_LE_US_ENDT');

3361: END IF;
3362:
3363: IF rec_date.us_end_date IS NOT NULL THEN
3364: IF l_d_uso_end_date > rec_date.us_end_date THEN
3365: fnd_message.set_name ('IGS','IGS_PS_USO_ENDT_LE_US_ENDT');
3366: l_error_text := fnd_message.get;
3367: END IF;
3368: ELSE
3369: IF l_d_uso_end_date > rec_date.tp_end_date THEN

Line 3366: l_error_text := fnd_message.get;

3362:
3363: IF rec_date.us_end_date IS NOT NULL THEN
3364: IF l_d_uso_end_date > rec_date.us_end_date THEN
3365: fnd_message.set_name ('IGS','IGS_PS_USO_ENDT_LE_US_ENDT');
3366: l_error_text := fnd_message.get;
3367: END IF;
3368: ELSE
3369: IF l_d_uso_end_date > rec_date.tp_end_date THEN
3370: fnd_message.set_name ('IGS','IGS_PS_USO_ENDT_LE_TP_ENDT');

Line 3370: fnd_message.set_name ('IGS','IGS_PS_USO_ENDT_LE_TP_ENDT');

3366: l_error_text := fnd_message.get;
3367: END IF;
3368: ELSE
3369: IF l_d_uso_end_date > rec_date.tp_end_date THEN
3370: fnd_message.set_name ('IGS','IGS_PS_USO_ENDT_LE_TP_ENDT');
3371: l_error_text := fnd_message.get;
3372:
3373: END IF;
3374: END IF;

Line 3371: l_error_text := fnd_message.get;

3367: END IF;
3368: ELSE
3369: IF l_d_uso_end_date > rec_date.tp_end_date THEN
3370: fnd_message.set_name ('IGS','IGS_PS_USO_ENDT_LE_TP_ENDT');
3371: l_error_text := fnd_message.get;
3372:
3373: END IF;
3374: END IF;
3375:

Line 3402: fnd_message.set_name ('IGS','IGS_PS_BUILDING_ID_INVALID');

3398: -- validate the building identifier
3399: OPEN c_bldg_exists(l_building_code);
3400: FETCH c_bldg_exists INTO l_c_exists;
3401: IF c_bldg_exists%NOTFOUND THEN
3402: fnd_message.set_name ('IGS','IGS_PS_BUILDING_ID_INVALID');
3403: l_error_text := fnd_message.get;
3404: END IF;
3405: CLOSE c_bldg_exists;
3406:

Line 3403: l_error_text := fnd_message.get;

3399: OPEN c_bldg_exists(l_building_code);
3400: FETCH c_bldg_exists INTO l_c_exists;
3401: IF c_bldg_exists%NOTFOUND THEN
3402: fnd_message.set_name ('IGS','IGS_PS_BUILDING_ID_INVALID');
3403: l_error_text := fnd_message.get;
3404: END IF;
3405: CLOSE c_bldg_exists;
3406:
3407: IF l_room_code IS NOT NULL THEN

Line 3412: fnd_message.set_name ('IGS','IGS_PS_ROOM_ID_INVALID');

3408: -- validate the room identifier
3409: OPEN c_room_exists(l_room_code);
3410: FETCH c_room_exists INTO l_c_exists;
3411: IF c_room_exists%NOTFOUND THEN
3412: fnd_message.set_name ('IGS','IGS_PS_ROOM_ID_INVALID');
3413: l_error_text := fnd_message.get;
3414: END IF;
3415: CLOSE c_room_exists;
3416:

Line 3413: l_error_text := fnd_message.get;

3409: OPEN c_room_exists(l_room_code);
3410: FETCH c_room_exists INTO l_c_exists;
3411: IF c_room_exists%NOTFOUND THEN
3412: fnd_message.set_name ('IGS','IGS_PS_ROOM_ID_INVALID');
3413: l_error_text := fnd_message.get;
3414: END IF;
3415: CLOSE c_room_exists;
3416:
3417: -- validate the building / room identifier

Line 3421: fnd_message.set_name ('IGS','IGS_PS_ROOM_INV_FOR_BLD');

3417: -- validate the building / room identifier
3418: OPEN c_bldg_room_exists(l_building_code,l_room_code);
3419: FETCH c_bldg_room_exists INTO l_c_exists;
3420: IF c_bldg_room_exists%NOTFOUND THEN
3421: fnd_message.set_name ('IGS','IGS_PS_ROOM_INV_FOR_BLD');
3422: l_error_text := fnd_message.get;
3423: END IF;
3424: CLOSE c_bldg_room_exists;
3425: END IF;

Line 3422: l_error_text := fnd_message.get;

3418: OPEN c_bldg_room_exists(l_building_code,l_room_code);
3419: FETCH c_bldg_room_exists INTO l_c_exists;
3420: IF c_bldg_room_exists%NOTFOUND THEN
3421: fnd_message.set_name ('IGS','IGS_PS_ROOM_INV_FOR_BLD');
3422: l_error_text := fnd_message.get;
3423: END IF;
3424: CLOSE c_bldg_room_exists;
3425: END IF;
3426:

Line 3438: fnd_message.set_name('IGS','IGS_PS_VALUES_NOT_NULL');

3434: l_set_transaction_type := 'COMPLETE';
3435: l_error_text := NULL;
3436: ELSE
3437: IF l_inter_error_text IS NULL THEN
3438: fnd_message.set_name('IGS','IGS_PS_VALUES_NOT_NULL');
3439: l_error_text:= fnd_message.get;
3440: ELSE
3441: l_error_text:=l_inter_error_text;
3442: END IF;

Line 3439: l_error_text:= fnd_message.get;

3435: l_error_text := NULL;
3436: ELSE
3437: IF l_inter_error_text IS NULL THEN
3438: fnd_message.set_name('IGS','IGS_PS_VALUES_NOT_NULL');
3439: l_error_text:= fnd_message.get;
3440: ELSE
3441: l_error_text:=l_inter_error_text;
3442: END IF;
3443: l_set_scheduled_status := 'ERROR';

Line 3513: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_GET_SCHD_SUCCESS');

3509: -- Modified to show the success messsage only if some valid records are transfered from
3510: -- interface table to production table, otherwise log the message ' NO valid record exists
3511: -- to import into the production table', added as a part of Bug # 2427725
3512: IF l_valid_rec_for_prod THEN
3513: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_GET_SCHD_SUCCESS');
3514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3515: ELSE
3516: -- Message is logged when there exists no scheduled records in interface table that needs to be
3517: -- transfer from Interface tables

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

3510: -- interface table to production table, otherwise log the message ' NO valid record exists
3511: -- to import into the production table', added as a part of Bug # 2427725
3512: IF l_valid_rec_for_prod THEN
3513: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_GET_SCHD_SUCCESS');
3514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3515: ELSE
3516: -- Message is logged when there exists no scheduled records in interface table that needs to be
3517: -- transfer from Interface tables
3518: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_SHD_REC_FRM_INT');

Line 3518: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_SHD_REC_FRM_INT');

3514: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3515: ELSE
3516: -- Message is logged when there exists no scheduled records in interface table that needs to be
3517: -- transfer from Interface tables
3518: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_SHD_REC_FRM_INT');
3519: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3520: END IF;
3521:
3522: EXCEPTION

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

3515: ELSE
3516: -- Message is logged when there exists no scheduled records in interface table that needs to be
3517: -- transfer from Interface tables
3518: FND_MESSAGE.SET_NAME('IGS','IGS_PS_NO_SHD_REC_FRM_INT');
3519: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3520: END IF;
3521:
3522: EXCEPTION
3523: WHEN OTHERS THEN

Line 3526: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

3522: EXCEPTION
3523: WHEN OTHERS THEN
3524: RETCODE:=2;
3525: fnd_file.put_line(fnd_file.log, SQLERRM);
3526: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
3527: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3528: ROLLBACK;
3529: END prgp_get_schd_records ;
3530:

Line 3653: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

3649:
3650: igs_ge_gen_003.set_org_id (NULL);
3651: retcode:=0;
3652:
3653: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3655: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3656: fnd_file.put_line(fnd_file.log,fnd_message.get);
3657:

Line 3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));

3650: igs_ge_gen_003.set_org_id (NULL);
3651: retcode:=0;
3652:
3653: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3655: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3656: fnd_file.put_line(fnd_file.log,fnd_message.get);
3657:
3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

Line 3655: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);

3651: retcode:=0;
3652:
3653: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3655: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3656: fnd_file.put_line(fnd_file.log,fnd_message.get);
3657:
3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3659: || ' : ' || p_unit_cd );

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

3652:
3653: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3654: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3655: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3656: fnd_file.put_line(fnd_file.log,fnd_message.get);
3657:
3658: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3659: || ' : ' || p_unit_cd );
3660: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

Line 3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

3663: || ' : ' || p_location );
3664: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3665: || ' : ' || p_unit_class );
3666:
3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));
3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);
3670: fnd_file.put_line(fnd_file.log,fnd_message.get);
3671: fnd_file.put_line(fnd_file.log,' ');

Line 3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));

3664: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3665: || ' : ' || p_unit_class );
3666:
3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));
3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);
3670: fnd_file.put_line(fnd_file.log,fnd_message.get);
3671: fnd_file.put_line(fnd_file.log,' ');
3672: fnd_file.put_line(fnd_file.log,' ');

Line 3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);

3665: || ' : ' || p_unit_class );
3666:
3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));
3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);
3670: fnd_file.put_line(fnd_file.log,fnd_message.get);
3671: fnd_file.put_line(fnd_file.log,' ');
3672: fnd_file.put_line(fnd_file.log,' ');
3673:

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

3666:
3667: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3668: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CANCEL_OCCUR_ONLY','IGS_PS_LOG_PARAMETERS'));
3669: fnd_message.set_token('PARAMETER_VAL' ,p_cancel_only);
3670: fnd_file.put_line(fnd_file.log,fnd_message.get);
3671: fnd_file.put_line(fnd_file.log,' ');
3672: fnd_file.put_line(fnd_file.log,' ');
3673:
3674:

Line 3684: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');

3680:
3681: l_abort_count := 0;
3682: l_proc_count := 0;
3683:
3684: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3685: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3686: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3687: fnd_file.put_line(fnd_file.log,' ');
3688:

Line 3685: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));

3681: l_abort_count := 0;
3682: l_proc_count := 0;
3683:
3684: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3685: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3686: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3687: fnd_file.put_line(fnd_file.log,' ');
3688:
3689: FOR c_int_uso_ss_rec IN c_int_uso_ss(l_ci_sequence_number,l_cal_type) LOOP

Line 3686: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );

3682: l_proc_count := 0;
3683:
3684: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3685: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3686: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3687: fnd_file.put_line(fnd_file.log,' ');
3688:
3689: FOR c_int_uso_ss_rec IN c_int_uso_ss(l_ci_sequence_number,l_cal_type) LOOP
3690:

Line 3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

3695: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
3696: || ' : ' || c_int_uso_ss_rec.location_code );
3697: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3698: || ' : ' || c_int_uso_ss_rec.unit_cls );
3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);
3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );

Line 3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));

3696: || ' : ' || c_int_uso_ss_rec.location_code );
3697: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3698: || ' : ' || c_int_uso_ss_rec.unit_cls );
3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);
3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );
3704: fnd_file.put_line(fnd_file.log,' ');

Line 3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);

3697: fnd_file.put_line ( fnd_file.LOG,igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CLASS' )
3698: || ' : ' || c_int_uso_ss_rec.unit_cls );
3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);
3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );
3704: fnd_file.put_line(fnd_file.log,' ');
3705:

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

3698: || ' : ' || c_int_uso_ss_rec.unit_cls );
3699: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3700: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('USEC_OCCRS_ID','IGS_PS_LOG_PARAMETERS'));
3701: fnd_message.set_token('PARAMETER_VAL' ,c_int_uso_ss_rec.occurrence_identifier);
3702: fnd_file.put_line(fnd_file.log,fnd_message.get);
3703: fnd_file.put_line ( fnd_file.LOG, 'Int Occurs Id'|| ' : ' || c_int_uso_ss_rec.int_occurs_id );
3704: fnd_file.put_line(fnd_file.log,' ');
3705:
3706: UPDATE igs_ps_sch_int_all SET abort_flag = 'Y'

Line 3773: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');

3769: CLOSE c_int_uso_prod;
3770: l_abort_count := l_abort_count +1;
3771: END LOOP;
3772:
3773: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));

Line 3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));

3770: l_abort_count := l_abort_count +1;
3771: END LOOP;
3772:
3773: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

Line 3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3771: END LOOP;
3772:
3773: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3779:

Line 3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');

3772:
3773: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3779:
3780: l_abort_count:= 0;

Line 3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));

3773: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3779:
3780: l_abort_count:= 0;
3781: l_proc_count := 0;

Line 3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3774: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3775: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3776: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3777: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('OCCURRENCES','IGS_PS_TABLE_NAME'));
3778: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3779:
3780: l_abort_count:= 0;
3781: l_proc_count := 0;
3782:

Line 3784: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');

3780: l_abort_count:= 0;
3781: l_proc_count := 0;
3782:
3783: fnd_file.put_line ( fnd_file.LOG, ' ' );
3784: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3787: fnd_file.put_line ( fnd_file.LOG, ' ' );
3788:

Line 3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));

3781: l_proc_count := 0;
3782:
3783: fnd_file.put_line ( fnd_file.LOG, ' ' );
3784: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3787: fnd_file.put_line ( fnd_file.LOG, ' ' );
3788:
3789: FOR c_int_usec_ss_rec IN c_int_usec_ss(l_ci_sequence_number,l_cal_type) LOOP

Line 3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );

3782:
3783: fnd_file.put_line ( fnd_file.LOG, ' ' );
3784: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3785: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3786: fnd_file.put_line ( fnd_file.LOG,fnd_message.get );
3787: fnd_file.put_line ( fnd_file.LOG, ' ' );
3788:
3789: FOR c_int_usec_ss_rec IN c_int_usec_ss(l_ci_sequence_number,l_cal_type) LOOP
3790: l_uso_count := NULL;

Line 3878: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');

3874: CLOSE c_prod_usec;
3875: l_proc_count := l_proc_count +1;
3876: END LOOP;
3877:
3878: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));

Line 3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));

3875: l_proc_count := l_proc_count +1;
3876: END LOOP;
3877:
3878: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

Line 3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );

3876: END LOOP;
3877:
3878: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3884:

Line 3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');

3877:
3878: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3884:
3885: l_abort_count := 0;

Line 3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));

3878: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3884:
3885: l_abort_count := 0;
3886: l_proc_count := 0;

Line 3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3879: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3880: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3881: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3882: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('SECTIONS','IGS_PS_TABLE_NAME'));
3883: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3884:
3885: l_abort_count := 0;
3886: l_proc_count := 0;
3887:

Line 3889: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');

3885: l_abort_count := 0;
3886: l_proc_count := 0;
3887:
3888: fnd_file.put_line ( fnd_file.LOG, ' ' );
3889: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3892: fnd_file.put_line ( fnd_file.LOG, ' ' );
3893:

Line 3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));

3886: l_proc_count := 0;
3887:
3888: fnd_file.put_line ( fnd_file.LOG, ' ' );
3889: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3892: fnd_file.put_line ( fnd_file.LOG, ' ' );
3893:
3894: FOR c_int_pat_ss_rec IN c_int_pat_ss(l_ci_sequence_number,l_cal_type) LOOP

Line 3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

3887:
3888: fnd_file.put_line ( fnd_file.LOG, ' ' );
3889: fnd_message.set_name('IGS','IGS_PS_ABORT_OCCURS_SEC_PAT');
3890: fnd_message.set_token('TABLENAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3891: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
3892: fnd_file.put_line ( fnd_file.LOG, ' ' );
3893:
3894: FOR c_int_pat_ss_rec IN c_int_pat_ss(l_ci_sequence_number,l_cal_type) LOOP
3895: l_uso_count:=null;

Line 3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

3905: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
3906: || ' : ' || c_int_pat_ss_rec.unit_cd );
3907: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3908: || ' : ' || TO_CHAR (c_int_pat_ss_rec.version_number) );
3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );

Line 3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));

3906: || ' : ' || c_int_pat_ss_rec.unit_cd );
3907: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3908: || ' : ' || TO_CHAR (c_int_pat_ss_rec.version_number) );
3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );
3914: fnd_file.put_line ( fnd_file.LOG, ' ' );

Line 3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);

3907: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
3908: || ' : ' || TO_CHAR (c_int_pat_ss_rec.version_number) );
3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );
3914: fnd_file.put_line ( fnd_file.LOG, ' ' );
3915:

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

3908: || ' : ' || TO_CHAR (c_int_pat_ss_rec.version_number) );
3909: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
3910: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('TEACHING_PERIOD','IGS_PS_LOG_PARAMETERS'));
3911: fnd_message.set_token('PARAMETER_VAL' ,p_teach_calendar);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.put_line ( fnd_file.LOG, 'Int Pat Id'|| ' : ' || c_int_pat_ss_rec.int_pat_id );
3914: fnd_file.put_line ( fnd_file.LOG, ' ' );
3915:
3916: ELSE

Line 3946: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');

3942: CLOSE c_prod_pat;
3943: l_proc_count := l_proc_count +1;
3944: END LOOP;
3945:
3946: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));

Line 3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));

3943: l_proc_count := l_proc_count +1;
3944: END LOOP;
3945:
3946: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

Line 3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );

3944: END LOOP;
3945:
3946: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3952:

Line 3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');

3945:
3946: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3952:
3953: EXCEPTION

Line 3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));

3946: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_PROCESS');
3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3952:
3953: EXCEPTION
3954: WHEN OTHERS THEN

Line 3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );

3947: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3948: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_proc_count );
3949: fnd_message.set_name('IGS','IGS_PS_TOT_RECORDS_ABORTED');
3950: fnd_message.set_token('TABLE',igs_ps_validate_lgcy_pkg.get_lkup_meaning('PATTERNS','IGS_PS_TABLE_NAME'));
3951: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get||l_abort_count );
3952:
3953: EXCEPTION
3954: WHEN OTHERS THEN
3955: RETCODE:=2;

Line 3957: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

3953: EXCEPTION
3954: WHEN OTHERS THEN
3955: RETCODE:=2;
3956: fnd_file.put_line ( fnd_file.LOG, ' ');
3957: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
3958: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3959: ROLLBACK;
3960: END abort_sched;
3961:

Line 4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

4077:
4078: /*Log the Teaching Calendar information */
4079: fnd_file.put_line(fnd_file.log,' ');
4080: fnd_file.put_line(fnd_file.log,' ');
4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

Line 4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));

4078: /*Log the Teaching Calendar information */
4079: fnd_file.put_line(fnd_file.log,' ');
4080: fnd_file.put_line(fnd_file.log,' ');
4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));

Line 4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);

4079: fnd_file.put_line(fnd_file.log,' ');
4080: fnd_file.put_line(fnd_file.log,' ');
4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));

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

4080: fnd_file.put_line(fnd_file.log,' ');
4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

4081: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

Line 4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));

4082: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('CAL_TYPE','LEGACY_TOKENS'));
4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));

Line 4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));

4083: fnd_message.set_token('PARAMETER_VAL' ,p_c_cal_type);
4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));

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

4084: fnd_file.put_line(fnd_file.log,fnd_message.get);
4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

4085: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');

Line 4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));

4086: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('START_DT','IGS_FI_LOCKBOX'));
4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');

Line 4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));

4087: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_start_date)));
4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');
4095: fnd_file.put_line(fnd_file.log,' ');

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

4088: fnd_file.put_line(fnd_file.log,fnd_message.get);
4089: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
4090: fnd_message.set_token('PARAMETER_NAME',igs_ps_validate_lgcy_pkg.get_lkup_meaning('END_DT','IGS_FI_LOCKBOX'));
4091: fnd_message.set_token('PARAMETER_VAL' ,TO_CHAR(TRUNC(l_end_date)));
4092: fnd_file.put_line(fnd_file.log,fnd_message.get);
4093: fnd_file.put_line(fnd_file.log,'--------------------------------------------------------');
4094: fnd_file.put_line(fnd_file.log,' ');
4095: fnd_file.put_line(fnd_file.log,' ');
4096:

Line 4290: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');

4286: l_c_str VARCHAR2(50);
4287:
4288: BEGIN
4289:
4290: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
4291: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
4292: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val);
4293: FOR i IN 1..p_val LOOP
4294: l_c_str := l_c_str || ' ';

Line 4291: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);

4287:
4288: BEGIN
4289:
4290: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
4291: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
4292: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val);
4293: FOR i IN 1..p_val LOOP
4294: l_c_str := l_c_str || ' ';
4295: END LOOP;

Line 4292: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val);

4288: BEGIN
4289:
4290: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
4291: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
4292: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val);
4293: FOR i IN 1..p_val LOOP
4294: l_c_str := l_c_str || ' ';
4295: END LOOP;
4296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_c_str||FND_MESSAGE.GET);

Line 4296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_c_str||FND_MESSAGE.GET);

4292: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val);
4293: FOR i IN 1..p_val LOOP
4294: l_c_str := l_c_str || ' ';
4295: END LOOP;
4296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_c_str||FND_MESSAGE.GET);
4297:
4298: END log_messages;
4299:
4300: PROCEDURE log_teach_cal (p_c_cal_type IN VARCHAR2,

Line 4628: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

4624: );
4625:
4626: EXCEPTION
4627: WHEN OTHERS THEN
4628: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4629: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls:igs_ps_usec_schedule');
4630: IGS_GE_MSG_STACK.ADD;
4631: APP_EXCEPTION.RAISE_EXCEPTION;
4632: END;

Line 4629: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls:igs_ps_usec_schedule');

4625:
4626: EXCEPTION
4627: WHEN OTHERS THEN
4628: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4629: FND_MESSAGE.SET_TOKEN('NAME','prgp_upd_usec_dtls:igs_ps_usec_schedule');
4630: IGS_GE_MSG_STACK.ADD;
4631: APP_EXCEPTION.RAISE_EXCEPTION;
4632: END;
4633: