APPS.IGF_AW_GEN_004 dependencies on FND_FILE

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