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 FND_API

Line 74: p_init_msg_list => FND_API.G_TRUE,

70: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
71: l_joint_acct_owner_id NUMBER;
72: BEGIN
73: IBY_EXT_BANKACCT_PUB.add_joint_account_owner(p_api_version => 1.0,
74: p_init_msg_list => FND_API.G_TRUE,
75: p_bank_account_id => p_bank_account_id,
76: p_acct_owner_party_id => p_account_owner_party_id,
77: x_joint_acct_owner_id=>l_joint_acct_owner_id,
78: x_return_status=>l_return_status,

Line 84: p_init_msg_list => FND_API.G_TRUE,

80: x_msg_data => l_msg_data,
81: x_response => l_response);
82: IF (l_joint_acct_owner_id IS NOT NULL) THEN
83: IBY_EXT_BANKACCT_PUB.change_primary_acct_owner (p_api_version => 1.0,
84: p_init_msg_list => FND_API.G_TRUE,
85: p_bank_acct_id => p_bank_account_id,
86: p_acct_owner_party_id => p_account_owner_party_id,
87: x_return_status=>l_return_status,
88: x_msg_count => l_msg_count,

Line 582: l_init_msg_list := fnd_api.g_true;

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:
584:
585: l_duns:='';
586: IF(nvl(p_vendor_id,0)=0) THEN

Line 607: if(nvl(l_return_status,'E')<>FND_API.G_RET_STS_SUCCESS) THEN

603: x_msg_data => l_msg_data,
604: x_federal => x_federal,
605: x_error_code => l_error_code
606: );
607: if(nvl(l_return_status,'E')<>FND_API.G_RET_STS_SUCCESS) THEN
608: if(l_msg_count=1) THEN
609: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,l_module_name,
610: 'Get Federal Indicator:' || l_msg_data);
611: else

Line 780: x_return_status := FND_API.G_RET_STS_ERROR ;

776: NULL;
777: WHEN OTHERS THEN
778: l_msg_text := l_module_name||': When others error: Error Code:'||SQLCODE||' Error Text:'||SQLERRM;
779: FV_UTILITY.LOG_MESG(l_msg_text);
780: x_return_status := FND_API.G_RET_STS_ERROR ;
781: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
782: RETURN;
783: END;
784:

Line 817: x_return_status := FND_API.G_RET_STS_SUCCESS;

813: FND_MSG_PUB.initialize;
814:
815:
816: -- Initialize API return status to success
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:
819:
820: -- Get the site id if they exist
821:

Line 1734: WHEN FND_API.G_EXC_ERROR THEN

1730: p_count => x_msg_count ,
1731: p_data => x_msg_data
1732: );
1733: EXCEPTION
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: IF(x_vendor_id IS NULL) THEN
1736: x_vendor_id := p_prev_vendor_id;
1737: END IF;
1738:

Line 1739: x_return_status := FND_API.G_RET_STS_ERROR ;

1735: IF(x_vendor_id IS NULL) THEN
1736: x_vendor_id := p_prev_vendor_id;
1737: END IF;
1738:
1739: x_return_status := FND_API.G_RET_STS_ERROR ;
1740: FND_MSG_PUB.Count_And_Get
1741: ( p_count => x_msg_count ,
1742: p_data => x_msg_data
1743: );

Line 1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1740: FND_MSG_PUB.Count_And_Get
1741: ( p_count => x_msg_count ,
1742: p_data => x_msg_data
1743: );
1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1745: IF(x_vendor_id IS NULL) THEN
1746: x_vendor_id := p_prev_vendor_id;
1747: END IF;
1748:

Line 1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1745: IF(x_vendor_id IS NULL) THEN
1746: x_vendor_id := p_prev_vendor_id;
1747: END IF;
1748:
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1750: FND_MSG_PUB.Count_And_Get
1751: ( p_count => x_msg_count ,
1752: p_data => x_msg_data
1753: );

Line 1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1755: IF(x_vendor_id IS NULL) THEN
1756: x_vendor_id := p_prev_vendor_id;
1757: END IF;
1758:
1759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1760: IF FND_MSG_PUB.Check_Msg_Level
1761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1762: THEN
1763: FND_MSG_PUB.Add_Exc_Msg

Line 2026: p_init_msg_list => FND_API.G_TRUE,

2022:
2023:
2024: AP_VENDOR_PUB_PKG.create_vendor(
2025: p_api_version => l_version,
2026: p_init_msg_list => FND_API.G_TRUE,
2027: p_commit=> FND_API.G_FALSE,
2028: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2029: x_return_status => l_ret_stat,
2030: x_msg_count=>l_msg_count,

Line 2027: p_commit=> FND_API.G_FALSE,

2023:
2024: AP_VENDOR_PUB_PKG.create_vendor(
2025: p_api_version => l_version,
2026: p_init_msg_list => FND_API.G_TRUE,
2027: p_commit=> FND_API.G_FALSE,
2028: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2029: x_return_status => l_ret_stat,
2030: x_msg_count=>l_msg_count,
2031: x_msg_data=>l_msg_data,

Line 2028: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

2024: AP_VENDOR_PUB_PKG.create_vendor(
2025: p_api_version => l_version,
2026: p_init_msg_list => FND_API.G_TRUE,
2027: p_commit=> FND_API.G_FALSE,
2028: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2029: x_return_status => l_ret_stat,
2030: x_msg_count=>l_msg_count,
2031: x_msg_data=>l_msg_data,
2032: p_vendor_rec=>l_vendor_rec,

Line 2172: p_init_msg_list => FND_API.G_TRUE,

2168: end if;
2169:
2170: AP_VENDOR_PUB_PKG.create_vendor_site(
2171: p_api_version => l_version,
2172: p_init_msg_list => FND_API.G_TRUE,
2173: p_commit=> FND_API.G_FALSE,
2174: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2175: x_return_status => l_ret_stat,
2176: x_msg_count=>l_msg_count,

Line 2173: p_commit=> FND_API.G_FALSE,

2169:
2170: AP_VENDOR_PUB_PKG.create_vendor_site(
2171: p_api_version => l_version,
2172: p_init_msg_list => FND_API.G_TRUE,
2173: p_commit=> FND_API.G_FALSE,
2174: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2175: x_return_status => l_ret_stat,
2176: x_msg_count=>l_msg_count,
2177: x_msg_data=>l_msg_data,

Line 2174: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

2170: AP_VENDOR_PUB_PKG.create_vendor_site(
2171: p_api_version => l_version,
2172: p_init_msg_list => FND_API.G_TRUE,
2173: p_commit=> FND_API.G_FALSE,
2174: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2175: x_return_status => l_ret_stat,
2176: x_msg_count=>l_msg_count,
2177: x_msg_data=>l_msg_data,
2178: p_vendor_site_rec=>l_vendor_site_rec,

Line 2287: p_init_msg_list => FND_API.G_TRUE,

2283: l_vendor_site_rec.pay_site_flag := p_pay_site_flag;
2284:
2285: AP_VENDOR_PUB_PKG.update_vendor_site(
2286: p_api_version => l_version,
2287: p_init_msg_list => FND_API.G_TRUE,
2288: p_commit=> FND_API.G_FALSE,
2289: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2290: x_return_status => l_ret_stat,
2291: x_msg_count=>l_msg_count,

Line 2288: p_commit=> FND_API.G_FALSE,

2284:
2285: AP_VENDOR_PUB_PKG.update_vendor_site(
2286: p_api_version => l_version,
2287: p_init_msg_list => FND_API.G_TRUE,
2288: p_commit=> FND_API.G_FALSE,
2289: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2290: x_return_status => l_ret_stat,
2291: x_msg_count=>l_msg_count,
2292: x_msg_data=>l_msg_data,

Line 2289: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

2285: AP_VENDOR_PUB_PKG.update_vendor_site(
2286: p_api_version => l_version,
2287: p_init_msg_list => FND_API.G_TRUE,
2288: p_commit=> FND_API.G_FALSE,
2289: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
2290: x_return_status => l_ret_stat,
2291: x_msg_count=>l_msg_count,
2292: x_msg_data=>l_msg_data,
2293: p_vendor_site_rec=>l_vendor_site_rec,

Line 2340: FND_API.G_TRUE,

2336:
2337: l_location_rec.location_id := l_location_id;
2338:
2339: hz_location_v2pub.update_location(
2340: FND_API.G_TRUE,
2341: l_location_rec,
2342: l_object_version_number,
2343: l_ret_stat,
2344: l_msg_count,

Line 2378: FND_API.G_TRUE,

2374: where party_site_id = l_party_site_id;
2375:
2376:
2377: hz_party_site_v2pub.update_party_site(
2378: FND_API.G_TRUE,
2379: l_party_site_rec,
2380: l_object_version_number,
2381: l_ret_stat,
2382: l_msg_count,

Line 2443: x_return_status := FND_API.G_RET_STS_SUCCESS;

2439: l_object_version_number NUMBER;
2440: BANK_EXCEPTION EXCEPTION;
2441: BEGIN
2442:
2443: x_return_status := FND_API.G_RET_STS_SUCCESS;
2444:
2445: if(nvl(p_created_bank_branch_id,0)=0) THEN
2446:
2447: -- Creation of Bank

Line 2452: p_init_msg_list => FND_API.G_FALSE,

2448: -- Check if bank exists
2449:
2450: IBY_EXT_BANKACCT_PUB.check_bank_exist(
2451: p_api_version => l_api_version,
2452: p_init_msg_list => FND_API.G_FALSE,
2453: p_country_code=> p_country_code,
2454: p_bank_name =>p_bank_name,
2455: p_bank_number => p_bank_num,
2456: x_return_status => l_return_status,

Line 2467: p_init_msg_list => FND_API.G_FALSE,

2463: if(l_bank_id IS NOT NULL) THEN
2464: if(l_end_date IS NOT NULL) THEN
2465: IBY_EXT_BANKACCT_PUB.set_bank_end_date(
2466: p_api_version => l_api_version,
2467: p_init_msg_list => FND_API.G_FALSE,
2468: p_bank_id => l_bank_id,
2469: p_end_date => null,
2470: x_return_status => l_return_status,
2471: x_msg_count => l_msg_count,

Line 2475: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2471: x_msg_count => l_msg_count,
2472: x_msg_data => l_msg_data,
2473: x_response => l_response);
2474:
2475: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2476: RAISE BANK_EXCEPTION;
2477: end if;
2478: end if; -- l_end_date
2479: ELSE -- l_bank_id

Line 2487: p_init_msg_list => FND_API.G_FALSE,

2483: l_bank_rec.country_code := p_country_code;
2484:
2485: IBY_EXT_BANKACCT_PUB.create_ext_bank(
2486: p_api_version => l_api_version,
2487: p_init_msg_list => FND_API.G_FALSE,
2488: p_ext_bank_rec => l_bank_rec,
2489: x_bank_id => l_bank_id,
2490: x_return_status => l_return_status,
2491: x_msg_count => l_msg_count,

Line 2495: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2491: x_msg_count => l_msg_count,
2492: x_msg_data => l_msg_data,
2493: x_response => l_response);
2494:
2495: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2496: RAISE BANK_EXCEPTION;
2497: end if;
2498: END IF;
2499:

Line 2509: p_init_msg_list => FND_API.G_FALSE,

2505: -- Check if Bank Branch Exists
2506:
2507: IBY_EXT_BANKACCT_PUB.check_ext_bank_branch_exist(
2508: p_api_version => l_api_version,
2509: p_init_msg_list => FND_API.G_FALSE,
2510: p_bank_id => l_bank_id,
2511: p_branch_name => p_branch_name,
2512: p_branch_number => p_bank_num,
2513: x_return_status => l_return_status,

Line 2524: p_init_msg_list => FND_API.G_FALSE,

2520: if(l_bank_branch_id IS NOT NULL) THEN
2521: if(l_end_date IS NOT NULL) THEN
2522: IBY_EXT_BANKACCT_PUB.set_ext_bank_branch_end_date(
2523: p_api_version => l_api_version,
2524: p_init_msg_list => FND_API.G_FALSE,
2525: p_branch_id => l_bank_branch_id,
2526: p_end_date => null,
2527: x_return_status => l_return_status,
2528: x_msg_count => l_msg_count,

Line 2532: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2528: x_msg_count => l_msg_count,
2529: x_msg_data => l_msg_data,
2530: x_response => l_response);
2531:
2532: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2533: RAISE BANK_EXCEPTION;
2534: end if;
2535: end if; -- l_end_date
2536:

Line 2550: p_init_msg_list => FND_API.G_FALSE,

2546: end if;
2547:
2548: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch(
2549: p_api_version => l_api_version,
2550: p_init_msg_list => FND_API.G_FALSE,
2551: p_ext_bank_branch_rec => l_bank_branch_rec,
2552: x_branch_id => l_bank_branch_id,
2553: x_return_status => l_return_status,
2554: x_msg_count => l_msg_count,

Line 2558: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2554: x_msg_count => l_msg_count,
2555: x_msg_data => l_msg_data,
2556: x_response => l_response);
2557:
2558: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2559: RAISE BANK_EXCEPTION;
2560: end if;
2561: END IF; -- l_bank_branch_id
2562:

Line 2576: p_init_msg_list => FND_API.G_FALSE,

2572: -- Create Bank Account
2573:
2574: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(
2575: p_api_version => l_api_version,
2576: p_init_msg_list => FND_API.G_FALSE,
2577: p_bank_id => l_bank_id,
2578: p_branch_id => l_bank_branch_id,
2579: p_acct_number => p_bank_acct_num,
2580: p_acct_name => p_bank_acct_name,

Line 2600: p_init_msg_list => FND_API.G_FALSE,

2596: l_object_version_number := -1;
2597:
2598: IBY_EXT_BANKACCT_PUB.set_ext_bank_acct_dates(
2599: p_api_version => l_api_version,
2600: p_init_msg_list => FND_API.G_FALSE,
2601: p_acct_id => l_bank_account_id,
2602: p_start_date => l_start_date,
2603: p_end_date => null,
2604: p_object_version_number => l_object_version_number,

Line 2610: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2606: x_msg_count => l_msg_count,
2607: x_msg_data => l_msg_data,
2608: x_response => l_response);
2609:
2610: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2611: RAISE BANK_EXCEPTION;
2612: end if;
2613: end if; -- l_end_date
2614:

Line 2640: p_init_msg_list => FND_API.G_FALSE,

2636: end if;
2637:
2638: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(
2639: p_api_version => l_api_version,
2640: p_init_msg_list => FND_API.G_FALSE,
2641: p_ext_bank_acct_rec => l_bank_acct_rec,
2642: x_acct_id => l_bank_account_id,
2643: x_return_status => l_return_status,
2644: x_msg_count => l_msg_count,

Line 2648: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2644: x_msg_count => l_msg_count,
2645: x_msg_data => l_msg_data,
2646: x_response => l_response);
2647:
2648: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2649: RAISE BANK_EXCEPTION;
2650: end if;
2651: END IF; -- l_bank_account_id
2652:

Line 2663: x_return_status := fnd_api.g_ret_sts_error;

2659: x_bank_account_id := l_bank_account_id;
2660:
2661: EXCEPTION
2662: WHEN BANK_EXCEPTION THEN
2663: x_return_status := fnd_api.g_ret_sts_error;
2664:
2665: -- Print the messages from l_msg_data in log file
2666: WHEN OTHERS THEN
2667: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2667: x_return_status := fnd_api.g_ret_sts_unexp_error;

2663: x_return_status := fnd_api.g_ret_sts_error;
2664:
2665: -- Print the messages from l_msg_data in log file
2666: WHEN OTHERS THEN
2667: x_return_status := fnd_api.g_ret_sts_unexp_error;
2668: -- Print SQLERRM in log file
2669:
2670: END create_bank_account;
2671:

Line 2693: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2689: UPDATE iby_ext_bank_accounts
2690: set BANK_ACCOUNT_TYPE = l_bank_account_type
2691: where EXT_BANK_ACCOUNT_ID = p_bank_account_id;
2692:
2693: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2694: EXCEPTION
2695: WHEN OTHERS THEN
2696: x_return_status := fnd_api.g_ret_sts_unexp_error;
2697: -- Print SQLERRM in log file

Line 2696: x_return_status := fnd_api.g_ret_sts_unexp_error;

2692:
2693: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2694: EXCEPTION
2695: WHEN OTHERS THEN
2696: x_return_status := fnd_api.g_ret_sts_unexp_error;
2697: -- Print SQLERRM in log file
2698: fv_utility.log_mesg('When others error in update_bank_account.');
2699: END update_bank_account;
2700:

Line 2790: p_init_msg_list => FND_API.G_FALSE,

2786:
2787:
2788: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
2789: p_api_version => l_api_version,
2790: p_init_msg_list => FND_API.G_FALSE,
2791: p_commit => FND_API.G_FALSE,
2792: x_return_status => l_return_status,
2793: x_msg_count => l_msg_count,
2794: x_msg_data => l_msg_data,

Line 2791: p_commit => FND_API.G_FALSE,

2787:
2788: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
2789: p_api_version => l_api_version,
2790: p_init_msg_list => FND_API.G_FALSE,
2791: p_commit => FND_API.G_FALSE,
2792: x_return_status => l_return_status,
2793: x_msg_count => l_msg_count,
2794: x_msg_data => l_msg_data,
2795: p_payee => l_payee,

Line 2800: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2796: p_assignment_attribs => l_assignment,
2797: x_assign_id => l_assign_id,
2798: x_response => l_response);
2799:
2800: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2801: RAISE BANK_USES_EXCEPTION;
2802: end if;
2803: END IF;
2804:

Line 2828: p_init_msg_list => FND_API.G_FALSE,

2824: IF(p_account_uses_insert_flag = 'U') THEN
2825:
2826: IBY_DISBURSEMENT_SETUP_PUB.Get_Payee_Instr_Assignments(
2827: p_api_version => l_api_version,
2828: p_init_msg_list => FND_API.G_FALSE,
2829: x_return_status => l_return_status,
2830: x_msg_count => l_msg_count,
2831: x_msg_data => l_msg_data,
2832: p_payee => l_payee,

Line 2881: p_init_msg_list => FND_API.G_FALSE,

2877: l_assignment.end_date := null;
2878:
2879: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
2880: p_api_version => l_api_version,
2881: p_init_msg_list => FND_API.G_FALSE,
2882: p_commit => FND_API.G_FALSE,
2883: x_return_status => l_return_status,
2884: x_msg_count => l_msg_count,
2885: x_msg_data => l_msg_data,

Line 2882: p_commit => FND_API.G_FALSE,

2878:
2879: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
2880: p_api_version => l_api_version,
2881: p_init_msg_list => FND_API.G_FALSE,
2882: p_commit => FND_API.G_FALSE,
2883: x_return_status => l_return_status,
2884: x_msg_count => l_msg_count,
2885: x_msg_data => l_msg_data,
2886: p_payee => l_payee,

Line 2892: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2888: x_assign_id => l_assign_id,
2889: x_response => l_response);
2890:
2891:
2892: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2893: RAISE BANK_USES_EXCEPTION;
2894: end if;
2895: END IF;
2896: END IF;