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.FND_GFM dependencies on FND_LOG

Line 587: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

583: l_doc_cnt number;
584: l_module_source varchar2(256) := 'FND_GFM.PURGE_EXPIRED';
585:
586: begin
587: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
588: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'Begin');
589: end if;
590:
591: -- For performance a check for orphaned attachment lobs will be done when

Line 588: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'Begin');

584: l_module_source varchar2(256) := 'FND_GFM.PURGE_EXPIRED';
585:
586: begin
587: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
588: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'Begin');
589: end if;
590:
591: -- For performance a check for orphaned attachment lobs will be done when
592: -- explicitly purging FNDATTCH program data

Line 595: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

591: -- For performance a check for orphaned attachment lobs will be done when
592: -- explicitly purging FNDATTCH program data
593:
594: if (program_name = 'FNDATTCH') then
595: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
596: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'PROGRAM_NAME=FNDATTCH - set expiration date for orphaned Attachment lobs');
597: end if;
598:
599: -- Set expiration_date for orphaned lobs

Line 596: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'PROGRAM_NAME=FNDATTCH - set expiration date for orphaned Attachment lobs');

592: -- explicitly purging FNDATTCH program data
593:
594: if (program_name = 'FNDATTCH') then
595: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
596: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'PROGRAM_NAME=FNDATTCH - set expiration date for orphaned Attachment lobs');
597: end if;
598:
599: -- Set expiration_date for orphaned lobs
600: -- Limiting to One time documents (for now)

Line 613: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

609: where datatype_id = 6
610: and media_id = l_file_id;
611:
612: if (l_doc_cnt = 0) then -- set expiration date
613: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
614: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Found orphaned fnd_lobs record: '||l_file_id);
615: end if;
616:
617: update fnd_lobs fl

Line 614: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Found orphaned fnd_lobs record: '||l_file_id);

610: and media_id = l_file_id;
611:
612: if (l_doc_cnt = 0) then -- set expiration date
613: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
614: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Found orphaned fnd_lobs record: '||l_file_id);
615: end if;
616:
617: update fnd_lobs fl
618: set expiration_date = sysdate-1

Line 639: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

635: and sysdate > expiration_date;
636: commit;
637: end if;
638:
639: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
640: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'End');
641: end if;
642:
643: exception

Line 640: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'End');

636: commit;
637: end if;
638:
639: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
640: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'End');
641: end if;
642:
643: exception
644: when others then

Line 1209: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1205: l_module_source varchar2(256);
1206: begin
1207: l_module_source := 'FND_GFM.GET';
1208:
1209: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1210: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Begin');
1211: end if;
1212:
1213: bool := icx_sec.validatesession();

Line 1210: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Begin');

1206: begin
1207: l_module_source := 'FND_GFM.GET';
1208:
1209: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1210: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Begin');
1211: end if;
1212:
1213: bool := icx_sec.validatesession();
1214: access := substr(p_path,instr(p_path,'/',1)+1,instr(p_path,'/',2)-2);

Line 1221: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1217: if (fnd_gfm.authenticate(access, l_file_id) = FALSE) then
1218: htp.p(Fnd_Message.Get_String('PAY','HR_51401_WEB_NOT_AUTHORIZED'));
1219: else
1220:
1221: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1222: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Downloading file_id '||to_char(l_file_id));
1223: end if;
1224:
1225: fnd_gfm.download_blob(l_file_id);

Line 1222: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Downloading file_id '||to_char(l_file_id));

1218: htp.p(Fnd_Message.Get_String('PAY','HR_51401_WEB_NOT_AUTHORIZED'));
1219: else
1220:
1221: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1222: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Downloading file_id '||to_char(l_file_id));
1223: end if;
1224:
1225: fnd_gfm.download_blob(l_file_id);
1226:

Line 1227: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1223: end if;
1224:
1225: fnd_gfm.download_blob(l_file_id);
1226:
1227: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1228: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Done downloading file. Determine if this was an export that needs to be purged');
1229: end if;
1230:
1231: select lower(program_name),expiration_date

Line 1228: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Done downloading file. Determine if this was an export that needs to be purged');

1224:
1225: fnd_gfm.download_blob(l_file_id);
1226:
1227: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1228: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Done downloading file. Determine if this was an export that needs to be purged');
1229: end if;
1230:
1231: select lower(program_name),expiration_date
1232: into prog_name, exp_date

Line 1239: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1235:
1236: if (prog_name = 'export' and exp_date is not null) then
1237: fnd_profile.get('FND_EXPORT_PURGE_ON_VIEW',p_purge_on_view);
1238:
1239: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1240: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Export - purge on view: '||p_purge_on_view);
1241: end if;
1242:
1243: if (p_purge_on_view = 'Y') then

Line 1240: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Export - purge on view: '||p_purge_on_view);

1236: if (prog_name = 'export' and exp_date is not null) then
1237: fnd_profile.get('FND_EXPORT_PURGE_ON_VIEW',p_purge_on_view);
1238:
1239: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1240: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Export - purge on view: '||p_purge_on_view);
1241: end if;
1242:
1243: if (p_purge_on_view = 'Y') then
1244: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

Line 1244: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1240: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Export - purge on view: '||p_purge_on_view);
1241: end if;
1242:
1243: if (p_purge_on_view = 'Y') then
1244: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1245: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Deleting lob');
1246: end if;
1247:
1248: fnd_gfm.delete_lob(l_file_id);

Line 1245: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Deleting lob');

1241: end if;
1242:
1243: if (p_purge_on_view = 'Y') then
1244: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1245: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Deleting lob');
1246: end if;
1247:
1248: fnd_gfm.delete_lob(l_file_id);
1249: end if;

Line 1253: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1249: end if;
1250: end if;
1251: end if;
1252:
1253: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1254: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'End');
1255: end if;
1256:
1257: exception

Line 1254: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'End');

1250: end if;
1251: end if;
1252:
1253: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1254: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'End');
1255: end if;
1256:
1257: exception
1258: when others then

Line 1596: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1592:
1593: l_module_source := 'FND_GFM.VERIFY_FILE_TYPE';
1594: l_file_ext := file_ext;
1595:
1596: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1597: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Begin');
1598: end if;
1599:
1600: l_dflt_allow := fnd_profile.value('FND_SECURITY_FILETYPE_RESTRICT_DFLT');

Line 1597: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Begin');

1593: l_module_source := 'FND_GFM.VERIFY_FILE_TYPE';
1594: l_file_ext := file_ext;
1595:
1596: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1597: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Begin');
1598: end if;
1599:
1600: l_dflt_allow := fnd_profile.value('FND_SECURITY_FILETYPE_RESTRICT_DFLT');
1601:

Line 1602: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1598: end if;
1599:
1600: l_dflt_allow := fnd_profile.value('FND_SECURITY_FILETYPE_RESTRICT_DFLT');
1601:
1602: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1603: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Profile value is: '||nvl(l_dflt_allow,'Profile not set'));
1604: end if;
1605:
1606:

Line 1603: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Profile value is: '||nvl(l_dflt_allow,'Profile not set'));

1599:
1600: l_dflt_allow := fnd_profile.value('FND_SECURITY_FILETYPE_RESTRICT_DFLT');
1601:
1602: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1603: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Profile value is: '||nvl(l_dflt_allow,'Profile not set'));
1604: end if;
1605:
1606:
1607: if (l_dflt_allow is null) then

Line 1612: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1608:
1609: -- Profile not defined default to allow
1610: l_dflt_allow := 'Y';
1611:
1612: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1613: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Profile value is null...default to Y');
1614: end if;
1615:
1616: end if;

Line 1613: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Profile value is null...default to Y');

1609: -- Profile not defined default to allow
1610: l_dflt_allow := 'Y';
1611:
1612: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1613: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Profile value is null...default to Y');
1614: end if;
1615:
1616: end if;
1617:

Line 1623: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1619: return l_dflt_allow;
1620: elsif (file_ext is null and file_name is not null) then
1621: l_ext_pos := instr(file_name,'.',-1);
1622:
1623: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1624: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'extension position is: '||l_ext_pos);
1625: end if;
1626:
1627: if (l_ext_pos > 0) then

Line 1624: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'extension position is: '||l_ext_pos);

1620: elsif (file_ext is null and file_name is not null) then
1621: l_ext_pos := instr(file_name,'.',-1);
1622:
1623: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1624: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'extension position is: '||l_ext_pos);
1625: end if;
1626:
1627: if (l_ext_pos > 0) then
1628: l_file_ext := substr(file_name,instr(file_name,'.',-1)+1);

Line 1630: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1626:
1627: if (l_ext_pos > 0) then
1628: l_file_ext := substr(file_name,instr(file_name,'.',-1)+1);
1629:
1630: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1631: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Get extension from filename');
1632: end if;
1633: else
1634: l_file_ext := 'null';

Line 1631: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Get extension from filename');

1627: if (l_ext_pos > 0) then
1628: l_file_ext := substr(file_name,instr(file_name,'.',-1)+1);
1629:
1630: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1631: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Get extension from filename');
1632: end if;
1633: else
1634: l_file_ext := 'null';
1635:

Line 1636: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1632: end if;
1633: else
1634: l_file_ext := 'null';
1635:
1636: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1637: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'No file extension - default extension to null');
1638: end if;
1639:
1640: end if;

Line 1637: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'No file extension - default extension to null');

1633: else
1634: l_file_ext := 'null';
1635:
1636: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1637: fnd_Log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'No file extension - default extension to null');
1638: end if;
1639:
1640: end if;
1641: end if;

Line 1643: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1639:
1640: end if;
1641: end if;
1642:
1643: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1644: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'file extension is: '||l_file_ext);
1645: end if;
1646:
1647: select count(distinct(upper(allow_file_upload))) into l_cnt

Line 1644: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'file extension is: '||l_file_ext);

1640: end if;
1641: end if;
1642:
1643: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1644: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'file extension is: '||l_file_ext);
1645: end if;
1646:
1647: select count(distinct(upper(allow_file_upload))) into l_cnt
1648: from fnd_mime_types where lower(file_ext) = lower(l_file_ext);

Line 1652: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1648: from fnd_mime_types where lower(file_ext) = lower(l_file_ext);
1649:
1650: if (l_cnt > 1) then
1651:
1652: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1653: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Same filetype exists with conflicting values - most restricted takes precedence');
1654: end if;
1655:
1656: select distinct upper(allow_file_upload) into l_allow

Line 1653: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Same filetype exists with conflicting values - most restricted takes precedence');

1649:
1650: if (l_cnt > 1) then
1651:
1652: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1653: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Same filetype exists with conflicting values - most restricted takes precedence');
1654: end if;
1655:
1656: select distinct upper(allow_file_upload) into l_allow
1657: from fnd_mime_types where lower(file_ext) = lower(l_file_ext)

Line 1667: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1663: from fnd_mime_types where lower(file_ext) = lower(l_file_ext);
1664:
1665: end if;
1666:
1667: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1668: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'File type: '||l_file_ext||' allowed: '||l_allow);
1669: end if;
1670:
1671: if (l_allow in ('Y','N')) then

Line 1668: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'File type: '||l_file_ext||' allowed: '||l_allow);

1664:
1665: end if;
1666:
1667: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1668: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'File type: '||l_file_ext||' allowed: '||l_allow);
1669: end if;
1670:
1671: if (l_allow in ('Y','N')) then
1672: return l_allow;

Line 1675: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1671: if (l_allow in ('Y','N')) then
1672: return l_allow;
1673: else
1674:
1675: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1676: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'allow_file_upload is null or an invalid value...default to profile value');
1677: end if;
1678:
1679: return l_dflt_allow;

Line 1676: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'allow_file_upload is null or an invalid value...default to profile value');

1672: return l_allow;
1673: else
1674:
1675: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1676: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'allow_file_upload is null or an invalid value...default to profile value');
1677: end if;
1678:
1679: return l_dflt_allow;
1680:

Line 1685: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1681: end if;
1682:
1683: exception
1684: when no_data_found then
1685: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1686: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Default to profile value - No data found for file type: '||l_file_ext);
1687: end if;
1688:
1689: return l_dflt_allow;

Line 1686: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Default to profile value - No data found for file type: '||l_file_ext);

1682:
1683: exception
1684: when no_data_found then
1685: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1686: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'Default to profile value - No data found for file type: '||l_file_ext);
1687: end if;
1688:
1689: return l_dflt_allow;
1690: when others then

Line 1691: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

1687: end if;
1688:
1689: return l_dflt_allow;
1690: when others then
1691: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1692: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'When others exception occurred');
1693: end if;
1694:
1695: fnd_gfm.err_msg('verify_file_type');

Line 1692: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'When others exception occurred');

1688:
1689: return l_dflt_allow;
1690: when others then
1691: if (fnd_log.level_statement >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1692: fnd_log.string(fnd_log.LEVEL_STATEMENT,l_module_source,'When others exception occurred');
1693: end if;
1694:
1695: fnd_gfm.err_msg('verify_file_type');
1696: raise;