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.IGF_AW_GEN_004 dependencies on FND_MESSAGE

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

872: RETURN l_data_rec;
873:
874: EXCEPTION
875: WHEN OTHERS THEN
876: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
877: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.get_award_data_wrap');
878: IGS_GE_MSG_STACK.ADD;
879: App_Exception.Raise_Exception;
880: END get_award_data_wrap;

Line 877: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.get_award_data_wrap');

873:
874: EXCEPTION
875: WHEN OTHERS THEN
876: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
877: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.get_award_data_wrap');
878: IGS_GE_MSG_STACK.ADD;
879: App_Exception.Raise_Exception;
880: END get_award_data_wrap;
881:

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

1004: RETURN l_data_rec;
1005:
1006: EXCEPTION
1007: WHEN OTHERS THEN
1008: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1009: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.GET_TERM_TOTAL_WRAP');
1010: IGS_GE_MSG_STACK.ADD;
1011: App_Exception.Raise_Exception;
1012: END get_term_total_wrap;

Line 1009: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.GET_TERM_TOTAL_WRAP');

1005:
1006: EXCEPTION
1007: WHEN OTHERS THEN
1008: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1009: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.GET_TERM_TOTAL_WRAP');
1010: IGS_GE_MSG_STACK.ADD;
1011: App_Exception.Raise_Exception;
1012: END get_term_total_wrap;
1013:

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

1253:
1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1258: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.award_letter_matrix' || SQLERRM);
1259: IGS_GE_MSG_STACK.ADD;
1260: App_Exception.Raise_Exception;
1261: END award_letter_matrix;

Line 1258: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.award_letter_matrix' || SQLERRM);

1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1258: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.award_letter_matrix' || SQLERRM);
1259: IGS_GE_MSG_STACK.ADD;
1260: App_Exception.Raise_Exception;
1261: END award_letter_matrix;
1262:

Line 1381: fnd_message.set_name('IGF','IGF_AW_NOTI_LTR_NO_PERS_NUM');

1377: IF p_sys_ltr_code = 'FAAWARD' THEN -- Process FAAWARD Letter
1378: p_person := '-9999999' ;
1379: IF p_select_type = 'S' THEN -- Select Type - S-Person/G-Group/A-Auto select
1380: IF p_person_id IS NULL THEN
1381: fnd_message.set_name('IGF','IGF_AW_NOTI_LTR_NO_PERS_NUM');
1382: fnd_file.put_line(fnd_file.log,fnd_message.get);
1383: p_exception := 'Y';
1384: RETURN;
1385: END IF;

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

1378: p_person := '-9999999' ;
1379: IF p_select_type = 'S' THEN -- Select Type - S-Person/G-Group/A-Auto select
1380: IF p_person_id IS NULL THEN
1381: fnd_message.set_name('IGF','IGF_AW_NOTI_LTR_NO_PERS_NUM');
1382: fnd_file.put_line(fnd_file.log,fnd_message.get);
1383: p_exception := 'Y';
1384: RETURN;
1385: END IF;
1386: OPEN l_query_desc FOR select DISTINCT p_person_id person_id FROM DUAL;

Line 1389: fnd_message.set_name('IGF','IGF_AW_NOTI_LTR_NO_PERS_GRP');

1385: END IF;
1386: OPEN l_query_desc FOR select DISTINCT p_person_id person_id FROM DUAL;
1387: ELSIF p_select_type = 'G' THEN -- Select Type - S-Person/G-Group/A-Auto select
1388: IF p_list_id IS NULL THEN
1389: fnd_message.set_name('IGF','IGF_AW_NOTI_LTR_NO_PERS_GRP');
1390: fnd_file.put_line(fnd_file.log,fnd_message.get);
1391: p_exception := 'Y';
1392: RETURN;
1393: END IF;

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

1386: OPEN l_query_desc FOR select DISTINCT p_person_id person_id FROM DUAL;
1387: ELSIF p_select_type = 'G' THEN -- Select Type - S-Person/G-Group/A-Auto select
1388: IF p_list_id IS NULL THEN
1389: fnd_message.set_name('IGF','IGF_AW_NOTI_LTR_NO_PERS_GRP');
1390: fnd_file.put_line(fnd_file.log,fnd_message.get);
1391: p_exception := 'Y';
1392: RETURN;
1393: END IF;
1394:

Line 1399: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');

1395: --Bug #5021084. Replaced function IGS_GET_DYNAMIC_SQL with GET_DYNAMIC_SQL
1396: l_query_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_list_id ,lv_status,lv_group_type);
1397:
1398: IF lv_status <> 'S' THEN
1399: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1401: p_exception := 'Y';
1402: RETURN;
1403: END IF;

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

1396: l_query_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_list_id ,lv_status,lv_group_type);
1397:
1398: IF lv_status <> 'S' THEN
1399: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
1400: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1401: p_exception := 'Y';
1402: RETURN;
1403: END IF;
1404:

Line 1534: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');

1530: FETCH c_att_id INTO l_attach_fid;
1531: CLOSE c_att_id;
1532:
1533: IF c_att_id%NOTFOUND OR l_attach_fid IS NULL THEN
1534: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');
1535: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);
1536: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1537: p_exception := 'Y';
1538: RETURN;

Line 1535: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);

1531: CLOSE c_att_id;
1532:
1533: IF c_att_id%NOTFOUND OR l_attach_fid IS NULL THEN
1534: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');
1535: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);
1536: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1537: p_exception := 'Y';
1538: RETURN;
1539: END IF;

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

1532:
1533: IF c_att_id%NOTFOUND OR l_attach_fid IS NULL THEN
1534: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');
1535: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);
1536: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1537: p_exception := 'Y';
1538: RETURN;
1539: END IF;
1540:

Line 1546: FND_MESSAGE.SET_NAME('IGF','IGF_AW_SF_PARAM_ERR_DTL');--Bug ID 2539299

1542: IGS_CO_GEN_004.get_list_query(l_attach_fid,l_query_text);
1543:
1544: IF p_flag='N' AND p_sys_ltr_code = 'FAAWARD' THEN
1545: IF p_parameter_2 IS NULL THEN
1546: FND_MESSAGE.SET_NAME('IGF','IGF_AW_SF_PARAM_ERR_DTL');--Bug ID 2539299
1547: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1548: p_exception := 'Y';
1549: RETURN;
1550: END IF;

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

1543:
1544: IF p_flag='N' AND p_sys_ltr_code = 'FAAWARD' THEN
1545: IF p_parameter_2 IS NULL THEN
1546: FND_MESSAGE.SET_NAME('IGF','IGF_AW_SF_PARAM_ERR_DTL');--Bug ID 2539299
1547: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1548: p_exception := 'Y';
1549: RETURN;
1550: END IF;
1551: END IF;

Line 1555: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');

1551: END IF;
1552:
1553: IF l_query_text IS NULL
1554: THEN
1555: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');
1556: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);
1557: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1558: p_exception := 'Y';
1559: RETURN;

Line 1556: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);

1552:
1553: IF l_query_text IS NULL
1554: THEN
1555: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');
1556: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);
1557: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1558: p_exception := 'Y';
1559: RETURN;
1560: END IF;

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

1553: IF l_query_text IS NULL
1554: THEN
1555: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_LIST');
1556: FND_MESSAGE.SET_TOKEN('LIST', l_list_name);
1557: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1558: p_exception := 'Y';
1559: RETURN;
1560: END IF;
1561:

Line 1630: FND_MESSAGE.SET_NAME('IGF','IGF_AW_WRNG_PRAM_PG_ID');

1626: --Logic for Person Id Group
1627: ELSIF p_select_type = 'G' THEN
1628:
1629: IF p_list_id IS NULL OR p_person_id IS NOT NULL THEN
1630: FND_MESSAGE.SET_NAME('IGF','IGF_AW_WRNG_PRAM_PG_ID');
1631: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1632: p_exception := 'Y';
1633: RETURN;
1634: END IF;

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

1627: ELSIF p_select_type = 'G' THEN
1628:
1629: IF p_list_id IS NULL OR p_person_id IS NOT NULL THEN
1630: FND_MESSAGE.SET_NAME('IGF','IGF_AW_WRNG_PRAM_PG_ID');
1631: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1632: p_exception := 'Y';
1633: RETURN;
1634: END IF;
1635:

Line 1652: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');

1648: lv_group_type := NULL;
1649: l_query_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_list_id ,lv_status,lv_group_type);
1650:
1651: IF lv_status <> 'S' THEN
1652: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
1653: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1654: p_exception := 'Y';
1655: RETURN;
1656: END IF;

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

1649: l_query_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_list_id ,lv_status,lv_group_type);
1650:
1651: IF lv_status <> 'S' THEN
1652: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
1653: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1654: p_exception := 'Y';
1655: RETURN;
1656: END IF;
1657: ELSE

Line 1666: FND_MESSAGE.SET_NAME('IGF','IGF_AW_SF_PARAM_ERR_DTL');--Bug ID 2539299

1662:
1663:
1664: IF p_flag='N' AND p_sys_ltr_code = 'FAAWARD' THEN
1665: IF p_parameter_2 IS NULL THEN
1666: FND_MESSAGE.SET_NAME('IGF','IGF_AW_SF_PARAM_ERR_DTL');--Bug ID 2539299
1667: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1668: p_exception := 'Y';
1669: RETURN;
1670: END IF;

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

1663:
1664: IF p_flag='N' AND p_sys_ltr_code = 'FAAWARD' THEN
1665: IF p_parameter_2 IS NULL THEN
1666: FND_MESSAGE.SET_NAME('IGF','IGF_AW_SF_PARAM_ERR_DTL');--Bug ID 2539299
1667: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1668: p_exception := 'Y';
1669: RETURN;
1670: END IF;
1671: END IF;

Line 1746: fnd_message.set_name('IGF','IGF_AW_PERS_OVFLOW');

1742: EXCEPTION
1743: WHEN OTHERS THEN
1744: lv_sql_code := SQLCODE;
1745: IF lv_sql_code = -06502 THEN
1746: fnd_message.set_name('IGF','IGF_AW_PERS_OVFLOW');
1747: ELSE
1748: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1749: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.corp_pre_process - ' || SQLERRM);
1750: END IF;

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

1744: lv_sql_code := SQLCODE;
1745: IF lv_sql_code = -06502 THEN
1746: fnd_message.set_name('IGF','IGF_AW_PERS_OVFLOW');
1747: ELSE
1748: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1749: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.corp_pre_process - ' || SQLERRM);
1750: END IF;
1751: IGS_GE_MSG_STACK.ADD;
1752: App_Exception.Raise_Exception;

Line 1749: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.corp_pre_process - ' || SQLERRM);

1745: IF lv_sql_code = -06502 THEN
1746: fnd_message.set_name('IGF','IGF_AW_PERS_OVFLOW');
1747: ELSE
1748: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1749: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.corp_pre_process - ' || SQLERRM);
1750: END IF;
1751: IGS_GE_MSG_STACK.ADD;
1752: App_Exception.Raise_Exception;
1753:

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

1857: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_004.missing_items.debug','p_return_status:'||p_return_status);
1858: END IF;
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1862: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.missing_items');
1863: IGS_GE_MSG_STACK.ADD;
1864: App_Exception.Raise_Exception;
1865: END missing_items;

Line 1862: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.missing_items');

1858: END IF;
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1862: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.missing_items');
1863: IGS_GE_MSG_STACK.ADD;
1864: App_Exception.Raise_Exception;
1865: END missing_items;
1866:

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

1942: END LOOP;
1943: CLOSE cur_loan_disb_rec;
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1947: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.loan_disbursement_update');
1948: IGS_GE_MSG_STACK.ADD;
1949: App_Exception.Raise_Exception;
1950:

Line 1947: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.loan_disbursement_update');

1943: CLOSE cur_loan_disb_rec;
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1947: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_gen_004.loan_disbursement_update');
1948: IGS_GE_MSG_STACK.ADD;
1949: App_Exception.Raise_Exception;
1950:
1951: END loan_disbursement_update;

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

2053: CLOSE cur_incomp_items;
2054:
2055: EXCEPTION
2056: WHEN OTHERS THEN
2057: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2058: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.mising_items_update');
2059: IGS_GE_MSG_STACK.ADD;
2060: App_Exception.Raise_Exception;
2061: END missing_items_update;

Line 2058: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.mising_items_update');

2054:
2055: EXCEPTION
2056: WHEN OTHERS THEN
2057: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2058: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.mising_items_update');
2059: IGS_GE_MSG_STACK.ADD;
2060: App_Exception.Raise_Exception;
2061: END missing_items_update;
2062:

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

2162: ) ;
2163:
2164: EXCEPTION
2165: WHEN OTHERS THEN
2166: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2167: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.AWARD_LETTER_UPDATE');
2168: IGS_GE_MSG_STACK.ADD;
2169: App_Exception.Raise_Exception;
2170:

Line 2167: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.AWARD_LETTER_UPDATE');

2163:
2164: EXCEPTION
2165: WHEN OTHERS THEN
2166: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2167: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_GEN_004.AWARD_LETTER_UPDATE');
2168: IGS_GE_MSG_STACK.ADD;
2169: App_Exception.Raise_Exception;
2170:
2171: END award_letter_update ;