DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on IBY_DISBURSEMENT_SETUP_PUB

Line 1643: ext_payee_rec IN OUT NOCOPY iby_disbursement_setup_pub.external_payee_rec_type,

1639: PROCEDURE create_vendor
1640: (
1641: p_batch_id IN NUMBER,
1642: p_vendor_rec IN ap_vendor_pub_pkg.r_vendor_rec_type,
1643: ext_payee_rec IN OUT NOCOPY iby_disbursement_setup_pub.external_payee_rec_type,
1644: x_return_status OUT NOCOPY VARCHAR2,
1645: x_msg_count OUT NOCOPY NUMBER,
1646: x_msg_data OUT NOCOPY VARCHAR2
1647: ) IS

Line 1663: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;

1659: FROM iby_temp_ext_bank_accts
1660: WHERE calling_app_unique_ref1 = p_unique_ref
1661: AND status <> 'PROCESSED';
1662:
1663: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
1664: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
1665: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
1666:
1667: l_temp_ext_acct_id NUMBER;

Line 1664: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;

1660: WHERE calling_app_unique_ref1 = p_unique_ref
1661: AND status <> 'PROCESSED';
1662:
1663: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
1664: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
1665: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
1666:
1667: l_temp_ext_acct_id NUMBER;
1668: ext_response_rec iby_fndcpt_common_pub.result_rec_type;

Line 1665: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;

1661: AND status <> 'PROCESSED';
1662:
1663: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
1664: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
1665: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
1666:
1667: l_temp_ext_acct_id NUMBER;
1668: ext_response_rec iby_fndcpt_common_pub.result_rec_type;
1669:

Line 1735: iby_disbursement_setup_pub.validate_external_payee(p_api_version => 1.0,

1731:
1732: ext_payee_rec.payee_party_id := nvl(l_party_id, p_vendor_rec.party_id);
1733:
1734: /* Calling IBY Payee Validation API */
1735: iby_disbursement_setup_pub.validate_external_payee(p_api_version => 1.0,
1736: p_init_msg_list => fnd_api.g_true,
1737: p_ext_payee_rec => ext_payee_rec,
1738: x_return_status => l_return_status,
1739: x_msg_count => l_msg_count,

Line 1744: ' from iby_disbursement_setup_pub.validate_external_payee' ||

1740: x_msg_data => l_msg_data);
1741:
1742: fnd_file.put_line(fnd_file.log,
1743: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1744: ' from iby_disbursement_setup_pub.validate_external_payee' ||
1745: ' l_return_status: ' || l_return_status);
1746:
1747: IF l_return_status = fnd_api.g_ret_sts_success THEN
1748:

Line 1752: iby_disbursement_setup_pub.create_external_payee(p_api_version => 1.0,

1748:
1749: ext_payee_tab(1) := ext_payee_rec;
1750:
1751: /*Calling IBY Payee Creation API */
1752: iby_disbursement_setup_pub.create_external_payee(p_api_version => 1.0,
1753: p_init_msg_list => fnd_api.g_true,
1754: p_ext_payee_tab => ext_payee_tab,
1755: x_return_status => l_return_status,
1756: x_msg_count => l_msg_count,

Line 1782: iby_disbursement_setup_pub.validate_temp_ext_bank_acct(p_api_version => 1.0,

1778: INTO l_temp_ext_acct_id;
1779: EXIT WHEN iby_ext_accts_cur%NOTFOUND;
1780:
1781: /* Calling IBY Bank Account Validation API */
1782: iby_disbursement_setup_pub.validate_temp_ext_bank_acct(p_api_version => 1.0,
1783: p_init_msg_list => fnd_api.g_true,
1784: x_return_status => l_return_status,
1785: x_msg_count => l_msg_count,
1786: x_msg_data => l_msg_data,

Line 1791: iby_disbursement_setup_pub.create_temp_ext_bank_acct(p_api_version => 1.0,

1787: p_temp_ext_acct_id => l_temp_ext_acct_id);
1788:
1789: IF l_return_status = fnd_api.g_ret_sts_success THEN
1790: /* Calling IBY Bank Account Creation API */
1791: iby_disbursement_setup_pub.create_temp_ext_bank_acct(p_api_version => 1.0,
1792: p_init_msg_list => fnd_api.g_true,
1793: x_return_status => l_return_status,
1794: x_msg_count => l_msg_count,
1795: x_msg_data => l_msg_data,

Line 1841: ' failed in iby_disbursement_setup_pub.create_temp_ext_bank_acct ' ||

1837: fnd_msg_pub.add;
1838:
1839: fnd_file.put_line(fnd_file.log,
1840: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1841: ' failed in iby_disbursement_setup_pub.create_temp_ext_bank_acct ' ||
1842: ' vendor_interface_id: ' ||
1843: p_vendor_rec.vendor_interface_id ||
1844: ' temp_ext_bank_acct_id: ' ||
1845: l_temp_ext_acct_id);

Line 1879: ' failed in iby_disbursement_setup_pub.validate_temp_ext_bank_acct ' ||

1875: fnd_msg_pub.add;
1876:
1877: fnd_file.put_line(fnd_file.log,
1878: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1879: ' failed in iby_disbursement_setup_pub.validate_temp_ext_bank_acct ' ||
1880: ' vendor_interface_id: ' ||
1881: p_vendor_rec.vendor_interface_id ||
1882: ' temp_ext_bank_acct_id: ' ||
1883: l_temp_ext_acct_id);

Line 1916: ' failed in iby_disbursement_setup_pub.create_external_payee ' ||

1912: fnd_msg_pub.add;
1913:
1914: fnd_file.put_line(fnd_file.log,
1915: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1916: ' failed in iby_disbursement_setup_pub.create_external_payee ' ||
1917: ' vendor_interface_id: ' ||
1918: p_vendor_rec.vendor_interface_id ||
1919: ' temp_ext_bank_acct_id: ' ||
1920: l_temp_ext_acct_id);

Line 1950: ' failed in iby_disbursement_setup_pub.validate_external_payee ' ||

1946: fnd_msg_pub.add;
1947:
1948: fnd_file.put_line(fnd_file.log,
1949: ' Message: Inside PROCEDURE CREATE_VENDOR' ||
1950: ' failed in iby_disbursement_setup_pub.validate_external_payee ' ||
1951: ' vendor_interface_id: ' ||
1952: p_vendor_rec.vendor_interface_id ||
1953: ' temp_ext_bank_acct_id: ' || l_temp_ext_acct_id);
1954:

Line 2078: ext_payee_rec iby_disbursement_setup_pub.external_payee_rec_type;

2074: l_vendor_num_code financials_system_parameters.user_defined_vendor_num_code%TYPE;
2075: l_insert_update_flag VARCHAR2(1);
2076:
2077: /* Variable Declaration for IBY */
2078: ext_payee_rec iby_disbursement_setup_pub.external_payee_rec_type;
2079:
2080: CURSOR check_vendor_exsists(cp_party_id IN NUMBER) IS
2081: SELECT 1,
2082: vendor_id

Line 2602: ext_payee_rec IN OUT NOCOPY iby_disbursement_setup_pub.external_payee_rec_type,

2598: PROCEDURE create_vendor_site
2599: (
2600: p_batch_id IN NUMBER,
2601: p_site_rec IN ap_vendor_pub_pkg.r_vendor_site_rec_type,
2602: ext_payee_rec IN OUT NOCOPY iby_disbursement_setup_pub.external_payee_rec_type,
2603: x_return_status OUT NOCOPY VARCHAR2,
2604: x_msg_count OUT NOCOPY NUMBER,
2605: x_msg_data OUT NOCOPY VARCHAR2
2606: ) IS

Line 2619: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;

2615: l_location_id NUMBER;
2616:
2617: /* Variable Declaration for IBY */
2618:
2619: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
2620:
2621: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
2622:
2623: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;

Line 2621: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;

2617: /* Variable Declaration for IBY */
2618:
2619: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
2620:
2621: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
2622:
2623: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
2624: l_temp_ext_acct_id NUMBER;
2625: ext_response_rec iby_fndcpt_common_pub.result_rec_type;

Line 2623: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;

2619: ext_payee_tab iby_disbursement_setup_pub.external_payee_tab_type;
2620:
2621: ext_payee_id_tab iby_disbursement_setup_pub.ext_payee_id_tab_type;
2622:
2623: ext_payee_create_tab iby_disbursement_setup_pub.ext_payee_create_tab_type;
2624: l_temp_ext_acct_id NUMBER;
2625: ext_response_rec iby_fndcpt_common_pub.result_rec_type;
2626:
2627: l_ext_payee_id NUMBER;

Line 2706: iby_disbursement_setup_pub.validate_external_payee(p_api_version => 1.0,

2702: fnd_msg_pub.count_and_get(p_count => l_payee_msg_count,
2703: p_data => l_payee_msg_data);
2704:
2705: /* Calling IBY Payee Validation API */
2706: iby_disbursement_setup_pub.validate_external_payee(p_api_version => 1.0,
2707: p_init_msg_list => fnd_api.g_true,
2708: p_ext_payee_rec => ext_payee_rec,
2709: x_return_status => l_return_status,
2710: x_msg_count => l_msg_count,

Line 2717: iby_disbursement_setup_pub.create_external_payee(p_api_version => 1.0,

2713: IF l_return_status = fnd_api.g_ret_sts_success THEN
2714: ext_payee_tab(1) := ext_payee_rec;
2715:
2716: /* Calling IBY Payee Creation API */
2717: iby_disbursement_setup_pub.create_external_payee(p_api_version => 1.0,
2718: p_init_msg_list => fnd_api.g_true,
2719: p_ext_payee_tab => ext_payee_tab,
2720: x_return_status => l_return_status,
2721: x_msg_count => l_msg_count,

Line 2744: iby_disbursement_setup_pub.validate_temp_ext_bank_acct(p_api_version => 1.0,

2740: INTO l_temp_ext_acct_id;
2741: EXIT WHEN iby_ext_accts_cur%NOTFOUND;
2742:
2743: /* Calling IBY Bank Account Validation API */
2744: iby_disbursement_setup_pub.validate_temp_ext_bank_acct(p_api_version => 1.0,
2745: p_init_msg_list => fnd_api.g_true,
2746: x_return_status => l_return_status,
2747: x_msg_count => l_msg_count,
2748: x_msg_data => l_msg_data,

Line 2754: iby_disbursement_setup_pub.create_temp_ext_bank_acct(p_api_version => 1.0,

2750:
2751: IF l_return_status = fnd_api.g_ret_sts_success THEN
2752: /* Calling IBY Bank Account Creation API */
2753:
2754: iby_disbursement_setup_pub.create_temp_ext_bank_acct(p_api_version => 1.0,
2755: p_init_msg_list => fnd_api.g_true,
2756: x_return_status => l_return_status,
2757: x_msg_count => l_msg_count,
2758: x_msg_data => l_msg_data,

Line 3058: ext_payee_rec iby_disbursement_setup_pub.external_payee_rec_type;

3054: site_int_rec site_int_cur%ROWTYPE;
3055: site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
3056:
3057: /* Variable Declaration for IBY */
3058: ext_payee_rec iby_disbursement_setup_pub.external_payee_rec_type;
3059:
3060: CURSOR check_vendor_site_exsists
3061: (
3062: cp_vendor_id IN NUMBER,

Line 8086: l_payee_context_rec IBY_DISBURSEMENT_SETUP_PUB.PayeeContext_rec_type;

8082: l_msg_data VARCHAR2(2000);
8083:
8084: ---Bug 11819545
8085: l_assign_id NUMBER;
8086: l_payee_context_rec IBY_DISBURSEMENT_SETUP_PUB.PayeeContext_rec_type;
8087: l_assign IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
8088: l_payment_function CONSTANT VARCHAR2(30) := 'PAYABLES_DISB';
8089: l_instrument_type CONSTANT VARCHAR2(30) := 'BANKACCOUNT';
8090:

Line 9246: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(

9242: x_msg_count => l_msg_count,
9243: X_MSG_DATA => L_MSG_DATA,
9244: x_response => l_add_account_owner_resp);
9245:
9246: IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment(
9247: p_api_version => 1,
9248: p_init_msg_list => NULL,
9249: p_commit => NULL,
9250: x_return_status => l_ret_status,