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.FV_CCR_UTIL_PVT dependencies on FV_CCR_UTIL_PVT

Line 1: PACKAGE BODY FV_CCR_UTIL_PVT as

1: PACKAGE BODY FV_CCR_UTIL_PVT as
2: /* $Header: FVCCRCRB.pls 120.39.12020000.4 2013/02/12 21:08:50 snama ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30):='FV_CCR_UTIL_PVT.';
4:
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30):='FV_CCR_UTIL_PVT.';

1: PACKAGE BODY FV_CCR_UTIL_PVT as
2: /* $Header: FVCCRCRB.pls 120.39.12020000.4 2013/02/12 21:08:50 snama ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30):='FV_CCR_UTIL_PVT.';
4:
5:
6: function existing_org_context
7: RETURN VARCHAR2

Line 15: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.existing_org_context';

11:
12:
13: BEGIN
14:
15: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.existing_org_context';
16: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
17:
18: -- Retrieve CLIENT_INFO org_id value in the performant method recommended by ATG
19: SELECT DECODE(

Line 46: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.insert_for_report';

42: )
43: IS
44: l_module_name VARCHAR2(60);
45: BEGIN
46: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.insert_for_report';
47: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
48:
49: INSERT INTO fv_ccr_process_report
50: (duns_info,record_type,reference1,reference2,reference3,reference4,reference5)

Line 152: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_name';

148: IS
149: l_vendor_name VARCHAR2(120);
150: l_module_name VARCHAR2(60);
151: BEGIN
152: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_name';
153: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
154:
155: --SELECT vendor_name,num_1099 INTO x_vendor_name,x_num_1099
156: --FROM po_vendors WHERE vendor_id = p_vendor_id;

Line 234: l_module_name:='fv.plsql.FV_CCR_UTIL_PVT.duplicate_vendor_site_code';

230: AND pavs.party_site_id = hps.party_site_id;
231:
232: BEGIN
233: x_dup_site_code:='F';
234: l_module_name:='fv.plsql.FV_CCR_UTIL_PVT.duplicate_vendor_site_code';
235: OPEN site_code_dup_csr(p_vendor_id,p_site_code,p_org_id);
236: FETCH site_code_dup_csr INTO x_vendor_site_id,x_duns;
237: IF(site_code_dup_csr%FOUND) THEN
238: x_dup_site_code:='T';

Line 257: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_site_code';

253: )
254: IS
255: l_module_name VARCHAR2(60);
256: BEGIN
257: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_site_code';
258: SELECT vendor_site_code INTO x_site_code
259: --FROM po_vendor_sites_all
260: FROM ap_supplier_sites_all
261: WHERE vendor_site_id = p_vendor_site_id;

Line 306: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';

302:
303:
304: BEGIN
305:
306: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
307: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
308:
309: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_taxpayer_number: '||p_taxpayer_number);

Line 388: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_branch_information';

384: WHERE branch_number = p_routing
385: AND branch_number IS NOT NULL;
386: BEGIN
387:
388: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_branch_information';
389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
390:
391: IF(nvl(p_bank_branch_id,0)<>0) THEN
392: BEGIN

Line 467: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';

463: l_bank_account_type VARCHAR2(25);
464: l_module_name VARCHAR2(60);
465: BEGIN
466: x_update_account:='N';
467: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';
468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_branch_id->'||p_bank_branch_id);
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_bank_account_number->'||p_bank_account_number);

Line 549: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_federal_indicator';

545: l_vendor_id NUMBER;
546: l_vendor_name VARCHAR2(120);
547: l_supp_num_exist VARCHAR2(1);
548: BEGIN
549: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_federal_indicator';
550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
551:
552: l_init_msg_list := fnd_api.g_true;
553:

Line 764: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.fv_process_vendor';

760: l_update_tin_flg varchar2(3) := 'No';
761:
762: BEGIN
763:
764: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.fv_process_vendor';
765: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
766: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'----------------------------------------------');
767: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Some of the Parameters: ');
768:

Line 1040: FV_CCR_UTIL_PVT.update_vendor(

1036: IF l_update_tin_flg = 'Yes' then
1037: BEGIN
1038: l_msg := null;
1039:
1040: FV_CCR_UTIL_PVT.update_vendor(
1041: p_vendor_id=>l_vendor_id,
1042: p_taxpayer_id=>p_taxpayer_number,
1043: x_status =>l_status,
1044: x_exception_msg=>l_msg);

Line 1151: FV_CCR_UTIL_PVT.insert_vendor

1147:
1148: BEGIN
1149: l_msg := null;
1150: fv_utility.log_mesg('before calling insert_vendor');
1151: FV_CCR_UTIL_PVT.insert_vendor
1152: (
1153: --p_vendor_name => p_legal_bus_name,
1154: p_vendor_name => l_legal_bus_name,
1155: p_taxpayer_id => p_taxpayer_number,

Line 1297: FV_CCR_UTIL_PVT.insert_vendor_site(

1293: ,null,null);
1294: ELSE
1295: l_msg := null;
1296:
1297: FV_CCR_UTIL_PVT.insert_vendor_site(
1298: p_vendor_site_code=>l_plus4,
1299: p_vendor_id=>l_vendor_id ,
1300: p_org_id =>p_org_id,
1301: p_address_line1=>p_main_address_line1,

Line 1347: FV_CCR_UTIL_PVT.update_vendor_site(

1343: ELSIF (p_main_address_flag = 'Y' AND nvl(l_main_add_site_id,0) <> 0) THEN
1344:
1345: l_msg := null;
1346:
1347: FV_CCR_UTIL_PVT.update_vendor_site(
1348: p_vendor_site_code =>null,
1349: p_vendor_site_id=>l_main_add_site_id,
1350: p_org_id => p_org_id,
1351: p_address_line1=>p_main_address_line1,

Line 1551: FV_CCR_UTIL_PVT.insert_vendor_site(

1547: ELSE
1548: l_pay_site_flag := 'Y';
1549: l_msg := null;
1550:
1551: FV_CCR_UTIL_PVT.insert_vendor_site(
1552: p_vendor_site_code=>l_plus4,
1553: p_vendor_id=>l_vendor_id ,
1554: p_org_id =>p_org_id,
1555: p_address_line1=>p_pay_address_line1,

Line 1634: FV_CCR_UTIL_PVT.update_vendor_site(

1630: l_account_uses_insert_flag := 'U';
1631: END IF;
1632: l_msg := null;
1633:
1634: FV_CCR_UTIL_PVT.update_vendor_site(
1635: p_vendor_site_code =>null,
1636: p_vendor_site_id=>p_pay_site_id,
1637: p_org_id => p_org_id,
1638: p_address_line1=>p_pay_address_line1,

Line 1816: FV_CCR_UTIL_PVT.update_vendor_site(

1812: BEGIN
1813: l_msg := null;
1814:
1815:
1816: FV_CCR_UTIL_PVT.update_vendor_site(
1817: p_vendor_site_code =>null,
1818: p_vendor_site_id=>p_pay_site_id,
1819: p_org_id => p_org_id,
1820: p_address_line1=>p_pay_address_line1,

Line 1878: FV_CCR_UTIL_PVT.update_vendor_site(

1874: END IF;
1875: BEGIN
1876: l_msg := null;
1877:
1878: FV_CCR_UTIL_PVT.update_vendor_site(
1879: p_vendor_site_code =>null,
1880: p_vendor_site_id=>p_main_add_site_id,
1881: p_org_id => p_org_id,
1882: p_address_line1=>p_main_address_line1,

Line 2011: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.delete_plusfour_assignments';

2007: as
2008: v_plus_four varchar2(100);
2009: l_module_name VARCHAR2(60);
2010: BEGIN
2011: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.delete_plusfour_assignments';
2012:
2013: --unassign plus_four's vendor_id (supplier)
2014: update fv_ccr_vendors
2015: set vendor_id = null

Line 2048: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');

2044: v_count number := 0;
2045: v_org_id number := null;
2046: BEGIN
2047:
2048: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
2049: IF p_org_id is NOT NULL THEN
2050: for crec in (select pay_site_id
2051: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs
2052: where o.pay_site_id is not null

Line 2080: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');

2076: v_count number := 0;
2077: v_org_id number := null;
2078: BEGIN
2079:
2080: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
2081: IF p_org_id is NOT NULL THEN
2082: for crec in (select main_address_site_id
2083: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs
2084: where o.main_address_site_id is not null

Line 2137: 'fv_ccr_util_pvt.get_lookup_desc',SQLERRM);

2133: WHEN NO_DATA_FOUND THEN
2134: RETURN p_lookup_code;
2135: WHEN OTHERS THEN
2136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
2137: 'fv_ccr_util_pvt.get_lookup_desc',SQLERRM);
2138: RETURN p_lookup_code;
2139:
2140: END get_lookup_desc;
2141:

Line 2276: fv_utility.log_mesg('Exception in fv_ccr_util_pvt.insert_vendor.');

2272: fv_utility.log_mesg('x_exception_msg: '||x_exception_msg);
2273:
2274: exception
2275: when others then
2276: fv_utility.log_mesg('Exception in fv_ccr_util_pvt.insert_vendor.');
2277: fv_utility.log_mesg(sqlcode||': '||sqlerrm);
2278:
2279: END insert_vendor;
2280:

Line 3224: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.check_taxpayerid_diff';

3220: l_different_tin varchar2(1) := 'N';
3221:
3222: l_module_name varchar2(60);
3223: begin
3224: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.check_taxpayerid_diff';
3225: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3226:
3227: begin
3228: select nvl(taxpayer_id, null) into l_ccr_tin from fv_ccr_vendors where duns = p_duns;

Line 3256: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ext_cert_val';

3252: l_ext_cert_val varchar2(200);
3253: l_module_name VARCHAR2(60);
3254:
3255: begin
3256: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ext_cert_val';
3257: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3258:
3259: if (p_code = 'DFD') then
3260: begin

Line 3307: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_flag_code';

3303: l_flagtype varchar2(60);
3304: l_flagval varchar2(60);
3305:
3306: begin
3307: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_flag_code';
3308: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3309: select flagtype, flagval into l_flagtype, l_flagval
3310: from fv_ccr_flags where duns = p_duns and rownum<=1;
3311:

Line 3361: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_numerics';

3357: l_pg number;
3358: l_pt number;
3359:
3360: begin
3361: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_numerics';
3362:
3363: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns: '||p_duns);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_code: '||p_code);

Line 3468: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_disaster_code';

3464: l_dis_code_val varchar2(200) := ' ';
3465: l_module_name VARCHAR2(60);
3466:
3467: begin
3468: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_disaster_code';
3469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_duns : '||p_duns);
3470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'p_code : '||p_code);
3471:
3472: if (substr(p_code, 1, 3) = 'STA') then

Line 3551: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_supplier_debarred';

3547: l_module_name VARCHAR2(60);
3548: l_debar_code fv_ccr_class_codes.code%type;
3549:
3550: begin
3551: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_supplier_debarred';
3552: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3553:
3554: select fcc.code into l_debar_code
3555: from fv_ccr_vendors fcv, fv_ccr_class_codes fcc, fv_ccr_orgs fco

Line 3576: END FV_CCR_UTIL_PVT;

3572: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,sqlerrm);
3573: return false;
3574: end get_supplier_debarred;
3575:
3576: END FV_CCR_UTIL_PVT;
3577: