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.20.12010000.2 2008/08/04 11:10:16 gnrajago ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30):='FV_CCR_UTIL_PVT';
4:
5: function existing_org_context

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.20.12010000.2 2008/08/04 11:10:16 gnrajago ship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30):='FV_CCR_UTIL_PVT';
4:
5: function existing_org_context
6: RETURN VARCHAR2
7: IS

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

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

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

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

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

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

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

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

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

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

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

299:
300:
301: BEGIN
302:
303: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_id';
304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
305:
306: fv_utility.log_mesg('p_taxpayer_number: '||p_taxpayer_number);
307: fv_utility.log_mesg('p_legal_bus_name: '||p_legal_bus_name);

Line 383: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_id';

379: l_bank_branch_id NUMBER;
380: l_module_name VARCHAR2(60);
381: BEGIN
382:
383: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_id';
384: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
385:
386: SELECT bank_account_id,aba.bank_branch_id
387: INTO x_bank_account_id,l_bank_branch_id

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

430: WHERE branch_number = p_routing
431: AND branch_number IS NOT NULL;
432: BEGIN
433:
434: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_branch_information';
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
436:
437: IF(nvl(p_bank_branch_id,0)<>0) THEN
438: BEGIN

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

507: l_bank_account_type VARCHAR2(25);
508: l_module_name VARCHAR2(60);
509: BEGIN
510: x_update_account:='N';
511: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_bank_account_information';
512: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
513:
514: BEGIN
515:

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

575: l_vendor_id NUMBER;
576: l_vendor_name VARCHAR2(120);
577: l_supp_num_exist VARCHAR2(1);
578: BEGIN
579: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_federal_indicator';
580: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
581:
582: l_init_msg_list := fnd_api.g_true;
583:

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

783: END;
784:
785:
786:
787: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.fv_process_vendor';
788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
789: l_dup_site_code:='F';
790: l_user_id := fnd_global.user_id;
791: l_login_id := fnd_global.login_id;

Line 962: FV_CCR_UTIL_PVT.update_vendor(

958: BEGIN
959: l_msg := null;
960:
961:
962: FV_CCR_UTIL_PVT.update_vendor(
963: p_vendor_id=>l_vendor_id,
964: p_taxpayer_id=>p_taxpayer_number,
965: x_status =>l_status,
966: x_exception_msg=>l_msg);

Line 1072: FV_CCR_UTIL_PVT.insert_vendor

1068:
1069: BEGIN
1070: l_msg := null;
1071: fv_utility.log_mesg('before calling insert_vendor');
1072: FV_CCR_UTIL_PVT.insert_vendor
1073: (
1074: --p_vendor_name => p_legal_bus_name,
1075: p_vendor_name => l_legal_bus_name,
1076: p_taxpayer_id => p_taxpayer_number,

Line 1218: FV_CCR_UTIL_PVT.insert_vendor_site(

1214: ,null,null);
1215: ELSE
1216: l_msg := null;
1217:
1218: FV_CCR_UTIL_PVT.insert_vendor_site(
1219: p_vendor_site_code=>l_plus4,
1220: p_vendor_id=>l_vendor_id ,
1221: p_org_id =>p_org_id,
1222: p_address_line1=>p_main_address_line1,

Line 1268: FV_CCR_UTIL_PVT.update_vendor_site(

1264: ELSIF (p_main_address_flag = 'Y' AND nvl(l_main_add_site_id,0) <> 0) THEN
1265:
1266: l_msg := null;
1267:
1268: FV_CCR_UTIL_PVT.update_vendor_site(
1269: p_vendor_site_code =>null,
1270: p_vendor_site_id=>l_main_add_site_id,
1271: p_org_id => p_org_id,
1272: p_address_line1=>p_main_address_line1,

Line 1381: FV_CCR_UTIL_PVT.insert_vendor_site(

1377: ELSE
1378: l_pay_site_flag := 'Y';
1379: l_msg := null;
1380:
1381: FV_CCR_UTIL_PVT.insert_vendor_site(
1382: p_vendor_site_code=>l_plus4,
1383: p_vendor_id=>l_vendor_id ,
1384: p_org_id =>p_org_id,
1385: p_address_line1=>p_pay_address_line1,

Line 1464: FV_CCR_UTIL_PVT.update_vendor_site(

1460: l_account_uses_insert_flag := 'U';
1461: END IF;
1462: l_msg := null;
1463:
1464: FV_CCR_UTIL_PVT.update_vendor_site(
1465: p_vendor_site_code =>null,
1466: p_vendor_site_id=>p_pay_site_id,
1467: p_org_id => p_org_id,
1468: p_address_line1=>p_pay_address_line1,

Line 1599: FV_CCR_UTIL_PVT.update_vendor_site(

1595: BEGIN
1596: l_msg := null;
1597:
1598:
1599: FV_CCR_UTIL_PVT.update_vendor_site(
1600: p_vendor_site_code =>null,
1601: p_vendor_site_id=>p_pay_site_id,
1602: p_org_id => p_org_id,
1603: p_address_line1=>p_pay_address_line1,

Line 1659: FV_CCR_UTIL_PVT.update_vendor_site(

1655: END IF;
1656: BEGIN
1657: l_msg := null;
1658:
1659: FV_CCR_UTIL_PVT.update_vendor_site(
1660: p_vendor_site_code =>null,
1661: p_vendor_site_id=>p_main_add_site_id,
1662: p_org_id => p_org_id,
1663: p_address_line1=>p_main_address_line1,

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

1786: as
1787: v_plus_four varchar2(100);
1788: l_module_name VARCHAR2(60);
1789: BEGIN
1790: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.delete_plusfour_assignments';
1791:
1792: --unassign plus_four's vendor_id (supplier)
1793: update fv_ccr_vendors
1794: set vendor_id = null

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

1823: v_count number := 0;
1824: v_org_id number := null;
1825: BEGIN
1826:
1827: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
1828: IF p_org_id is NOT NULL THEN
1829: for crec in (select pay_site_id
1830: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs
1831: where o.pay_site_id is not null

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

1855: v_count number := 0;
1856: v_org_id number := null;
1857: BEGIN
1858:
1859: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
1860: IF p_org_id is NOT NULL THEN
1861: for crec in (select main_address_site_id
1862: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs
1863: where o.main_address_site_id is not null

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

1912: WHEN NO_DATA_FOUND THEN
1913: RETURN p_lookup_code;
1914: WHEN OTHERS THEN
1915: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1916: 'fv_ccr_util_pvt.get_lookup_desc',SQLERRM);
1917: RETURN p_lookup_code;
1918:
1919: END get_lookup_desc;
1920:

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

2051: fv_utility.log_mesg('x_exception_msg: '||x_exception_msg);
2052:
2053: exception
2054: when others then
2055: fv_utility.log_mesg('Exception in fv_ccr_util_pvt.insert_vendor.');
2056: fv_utility.log_mesg(sqlcode||': '||sqlerrm);
2057:
2058: END insert_vendor;
2059:

Line 2904: END FV_CCR_UTIL_PVT;

2900: RAISE ;
2901:
2902: END process_bank_account_uses;
2903:
2904: END FV_CCR_UTIL_PVT;