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.OZF_WEBADI_INTERFACE_PVT dependencies on UTL_FILE

Line 662: WHERE name = 'utl_file_dir';

658: CURSOR C
659: IS
660: SELECT value
661: FROM v$parameter
662: WHERE name = 'utl_file_dir';
663:
664: CURSOR csr_get_party_site_id(cv_site_number IN VARCHAR2) IS
665: SELECT party_site_id
666: FROM hz_party_sites

Line 695: l_file utl_file.file_type;

691: l_resale_line_int_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
692: l_object_version_no_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
693: l_total_claimed_amount NUMBER := 0;
694: j NUMBER;
695: l_file utl_file.file_type;
696: l_file_dir VARCHAR2(500);
697: l_file_name VARCHAR2(3200);
698: l_text VARCHAR2(32000);
699: l_error_message VARCHAR2(3200);

Line 837: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);

833: IF l_file_dir IS NOT NULL THEN
834:
835: l_file_name := 'ozfrsladi-'||p_batch_number||'.log';
836: BEGIN
837: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
838: EXCEPTION
839: WHEN UTL_FILE.INVALID_PATH THEN
840: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
841: INTO l_file_dir

Line 839: WHEN UTL_FILE.INVALID_PATH THEN

835: l_file_name := 'ozfrsladi-'||p_batch_number||'.log';
836: BEGIN
837: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
838: EXCEPTION
839: WHEN UTL_FILE.INVALID_PATH THEN
840: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
841: INTO l_file_dir
842: FROM v$parameter
843: WHERE name = 'utl_file_dir';

Line 843: WHERE name = 'utl_file_dir';

839: WHEN UTL_FILE.INVALID_PATH THEN
840: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
841: INTO l_file_dir
842: FROM v$parameter
843: WHERE name = 'utl_file_dir';
844: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
845: END;
846: END IF;
847:

Line 844: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);

840: SELECT decode(instr(value,',',1,1), 0, value, substr(value,1,instr(value,',',1,1)-1))
841: INTO l_file_dir
842: FROM v$parameter
843: WHERE name = 'utl_file_dir';
844: l_file := utl_file.fopen( l_file_dir, l_file_name, 'w' , 32000);
845: END;
846: END IF;
847:
848:

Line 1603: UTL_FILE.PUTF(l_file,l_text);

1599: END IF;
1600:
1601: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1602: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1603: UTL_FILE.PUTF(l_file,l_text);
1604: UTL_FILE.FCLOSE(l_file);
1605:
1606: EXCEPTION
1607: WHEN ozf_webadi_error THEN

Line 1604: UTL_FILE.FCLOSE(l_file);

1600:
1601: OZF_UTILITY_PVT.debug_message('length of text '||length(l_text));
1602: OZF_UTILITY_PVT.debug_message('length of text '||length(substr(l_text,1001,1000)));
1603: UTL_FILE.PUTF(l_file,l_text);
1604: UTL_FILE.FCLOSE(l_file);
1605:
1606: EXCEPTION
1607: WHEN ozf_webadi_error THEN
1608: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1610: WHEN UTL_FILE.INVALID_PATH THEN

1606: EXCEPTION
1607: WHEN ozf_webadi_error THEN
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: raise_application_error( -20000, l_error_message);
1610: WHEN UTL_FILE.INVALID_PATH THEN
1611: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
1612: WHEN UTL_FILE.INVALID_MODE THEN
1613: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
1614: WHEN UTL_FILE.INVALID_OPERATION then

Line 1612: WHEN UTL_FILE.INVALID_MODE THEN

1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: raise_application_error( -20000, l_error_message);
1610: WHEN UTL_FILE.INVALID_PATH THEN
1611: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
1612: WHEN UTL_FILE.INVALID_MODE THEN
1613: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
1614: WHEN UTL_FILE.INVALID_OPERATION then
1615: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
1616: WHEN UTL_FILE.INVALID_FILEHANDLE then

Line 1614: WHEN UTL_FILE.INVALID_OPERATION then

1610: WHEN UTL_FILE.INVALID_PATH THEN
1611: RAISE_APPLICATION_ERROR(-20100,'Invalid Path');
1612: WHEN UTL_FILE.INVALID_MODE THEN
1613: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
1614: WHEN UTL_FILE.INVALID_OPERATION then
1615: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
1616: WHEN UTL_FILE.INVALID_FILEHANDLE then
1617: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
1618: WHEN UTL_FILE.WRITE_ERROR then

Line 1616: WHEN UTL_FILE.INVALID_FILEHANDLE then

1612: WHEN UTL_FILE.INVALID_MODE THEN
1613: RAISE_APPLICATION_ERROR(-20101,'Invalid Mode');
1614: WHEN UTL_FILE.INVALID_OPERATION then
1615: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
1616: WHEN UTL_FILE.INVALID_FILEHANDLE then
1617: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
1618: WHEN UTL_FILE.WRITE_ERROR then
1619: RAISE_APPLICATION_ERROR(-20104,'Write Error');
1620: WHEN UTL_FILE.READ_ERROR then

Line 1618: WHEN UTL_FILE.WRITE_ERROR then

1614: WHEN UTL_FILE.INVALID_OPERATION then
1615: RAISE_APPLICATION_ERROR(-20102,'Invalid Operation');
1616: WHEN UTL_FILE.INVALID_FILEHANDLE then
1617: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
1618: WHEN UTL_FILE.WRITE_ERROR then
1619: RAISE_APPLICATION_ERROR(-20104,'Write Error');
1620: WHEN UTL_FILE.READ_ERROR then
1621: RAISE_APPLICATION_ERROR(-20105,'Read Error');
1622: WHEN UTL_FILE.INTERNAL_ERROR then

Line 1620: WHEN UTL_FILE.READ_ERROR then

1616: WHEN UTL_FILE.INVALID_FILEHANDLE then
1617: RAISE_APPLICATION_ERROR(-20103,'Invalid Filehandle');
1618: WHEN UTL_FILE.WRITE_ERROR then
1619: RAISE_APPLICATION_ERROR(-20104,'Write Error');
1620: WHEN UTL_FILE.READ_ERROR then
1621: RAISE_APPLICATION_ERROR(-20105,'Read Error');
1622: WHEN UTL_FILE.INTERNAL_ERROR then
1623: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1622: WHEN UTL_FILE.INTERNAL_ERROR then

1618: WHEN UTL_FILE.WRITE_ERROR then
1619: RAISE_APPLICATION_ERROR(-20104,'Write Error');
1620: WHEN UTL_FILE.READ_ERROR then
1621: RAISE_APPLICATION_ERROR(-20105,'Read Error');
1622: WHEN UTL_FILE.INTERNAL_ERROR then
1623: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: UTL_FILE.FCLOSE(l_file);
1626: IF length( SQLERRM) > 30 THEN

Line 1625: UTL_FILE.FCLOSE(l_file);

1621: RAISE_APPLICATION_ERROR(-20105,'Read Error');
1622: WHEN UTL_FILE.INTERNAL_ERROR then
1623: RAISE_APPLICATION_ERROR(-20106,'Internal Error');
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: UTL_FILE.FCLOSE(l_file);
1626: IF length( SQLERRM) > 30 THEN
1627: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1628: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1629: ELSE

Line 1634: UTL_FILE.FCLOSE(l_file);

1630: fnd_message.set_name ('OZF', SQLERRM);
1631: END IF;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: WHEN OTHERS THEN
1634: UTL_FILE.FCLOSE(l_file);
1635: IF length( SQLERRM) > 30 THEN
1636: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1637: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1638: ELSE