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.POS_AP_SUPPLIER_SITE_BO_PKG dependencies on FND_API

Line 65: x_return_status := fnd_api.g_ret_sts_success;

61: l_payee_msg_data VARCHAR2(4000);
62: l_error_code VARCHAR2(4000);
63:
64: BEGIN
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67: fnd_file.put_line(fnd_file.log,
68: ' Message: Inside PROCEDURE CREATE_VENDOR_SITE' ||
69: ' Parameters vendor_id: ' || p_site_rec.vendor_id ||

Line 76: p_init_msg_list => fnd_api.g_false,

72:
73: SAVEPOINT import_vendor_sites_pub2;
74:
75: ap_vendor_pub_pkg.create_vendor_site(p_api_version => 1.0,
76: p_init_msg_list => fnd_api.g_false,
77: p_commit => fnd_api.g_false,
78: p_validation_level => fnd_api.g_valid_level_full,
79: x_return_status => l_return_status,
80: x_msg_count => l_msg_count,

Line 77: p_commit => fnd_api.g_false,

73: SAVEPOINT import_vendor_sites_pub2;
74:
75: ap_vendor_pub_pkg.create_vendor_site(p_api_version => 1.0,
76: p_init_msg_list => fnd_api.g_false,
77: p_commit => fnd_api.g_false,
78: p_validation_level => fnd_api.g_valid_level_full,
79: x_return_status => l_return_status,
80: x_msg_count => l_msg_count,
81: x_msg_data => l_msg_data,

Line 78: p_validation_level => fnd_api.g_valid_level_full,

74:
75: ap_vendor_pub_pkg.create_vendor_site(p_api_version => 1.0,
76: p_init_msg_list => fnd_api.g_false,
77: p_commit => fnd_api.g_false,
78: p_validation_level => fnd_api.g_valid_level_full,
79: x_return_status => l_return_status,
80: x_msg_count => l_msg_count,
81: x_msg_data => l_msg_data,
82: p_vendor_site_rec => p_site_rec,

Line 87: IF l_return_status = fnd_api.g_ret_sts_success THEN

83: x_vendor_site_id => l_vendor_site_id,
84: x_party_site_id => l_party_site_id,
85: x_location_id => l_location_id);
86:
87: IF l_return_status = fnd_api.g_ret_sts_success THEN
88:
89: ext_payee_rec.supplier_site_id := l_vendor_site_id;
90: ext_payee_rec.payee_party_site_id := l_party_site_id;
91:

Line 106: p_init_msg_list => fnd_api.g_false,

102: WHERE vendor_id = p_site_rec.vendor_id;
103:
104: /* Calling IBY Payee Validation API */
105: iby_disbursement_setup_pub.validate_external_payee(p_api_version => 1.0,
106: p_init_msg_list => fnd_api.g_false,
107: p_ext_payee_rec => ext_payee_rec,
108: x_return_status => l_return_status,
109: x_msg_count => l_msg_count,
110: x_msg_data => l_msg_data);

Line 112: IF l_return_status = fnd_api.g_ret_sts_success THEN

108: x_return_status => l_return_status,
109: x_msg_count => l_msg_count,
110: x_msg_data => l_msg_data);
111:
112: IF l_return_status = fnd_api.g_ret_sts_success THEN
113: ext_payee_tab(1) := ext_payee_rec;
114:
115: /* Calling IBY Payee Creation API */
116: iby_disbursement_setup_pub.create_external_payee(p_api_version => 1.0,

Line 117: p_init_msg_list => fnd_api.g_false,

113: ext_payee_tab(1) := ext_payee_rec;
114:
115: /* Calling IBY Payee Creation API */
116: iby_disbursement_setup_pub.create_external_payee(p_api_version => 1.0,
117: p_init_msg_list => fnd_api.g_false,
118: p_ext_payee_tab => ext_payee_tab,
119: x_return_status => l_return_status,
120: x_msg_count => l_msg_count,
121: x_msg_data => l_msg_data,

Line 125: IF l_return_status = fnd_api.g_ret_sts_success THEN

121: x_msg_data => l_msg_data,
122: x_ext_payee_id_tab => ext_payee_id_tab,
123: x_ext_payee_status_tab => ext_payee_create_tab);
124:
125: IF l_return_status = fnd_api.g_ret_sts_success THEN
126: l_ext_payee_id := ext_payee_id_tab(1).ext_payee_id;
127:
128: UPDATE iby_temp_ext_bank_accts
129: SET ext_payee_id = l_ext_payee_id,

Line 144: p_init_msg_list => fnd_api.g_false,

140: EXIT WHEN iby_ext_accts_cur%NOTFOUND;
141:
142: /* Calling IBY Bank Account Validation API */
143: iby_disbursement_setup_pub.validate_temp_ext_bank_acct(p_api_version => 1.0,
144: p_init_msg_list => fnd_api.g_false,
145: x_return_status => l_return_status,
146: x_msg_count => l_msg_count,
147: x_msg_data => l_msg_data,
148: p_temp_ext_acct_id => l_temp_ext_acct_id);

Line 150: IF l_return_status = fnd_api.g_ret_sts_success THEN

146: x_msg_count => l_msg_count,
147: x_msg_data => l_msg_data,
148: p_temp_ext_acct_id => l_temp_ext_acct_id);
149:
150: IF l_return_status = fnd_api.g_ret_sts_success THEN
151: /* Calling IBY Bank Account Creation API */
152:
153: iby_disbursement_setup_pub.create_temp_ext_bank_acct(p_api_version => 1.0,
154: p_init_msg_list => fnd_api.g_false,

Line 154: p_init_msg_list => fnd_api.g_false,

150: IF l_return_status = fnd_api.g_ret_sts_success THEN
151: /* Calling IBY Bank Account Creation API */
152:
153: iby_disbursement_setup_pub.create_temp_ext_bank_acct(p_api_version => 1.0,
154: p_init_msg_list => fnd_api.g_false,
155: x_return_status => l_return_status,
156: x_msg_count => l_msg_count,
157: x_msg_data => l_msg_data,
158: p_temp_ext_acct_id => l_temp_ext_acct_id,

Line 167: IF l_return_status = fnd_api.g_ret_sts_success THEN

163: p_org_type => 'OPERATING_UNIT',
164: x_bank_acc_id => l_bank_acct_id,
165: x_response => ext_response_rec);
166:
167: IF l_return_status = fnd_api.g_ret_sts_success THEN
168: UPDATE iby_temp_ext_bank_accts
169: SET status = 'PROCESSED'
170: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
171:

Line 206: x_return_status := fnd_api.g_ret_sts_unexp_error;

202: END IF;
203: END IF; -- Supplier Site Creation API
204: EXCEPTION
205: WHEN OTHERS THEN
206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207:
208: fnd_msg_pub.count_and_get(p_count => x_msg_count,
209: p_data => x_msg_data);
210: END;

Line 480: WHEN fnd_api.g_exc_error THEN

476: x_ap_supplier_sites_bo.p_pos_supplier_sites_obj := l_pos_ap_supplier_sites_bo_tbl;*/
477:
478: -- SELECT pos_supplier_sites_all_object(l_pos_ap_supplier_sites_bo_tbl) INTO x_ap_supplier_sites_bo FROM dual;
479: EXCEPTION
480: WHEN fnd_api.g_exc_error THEN
481:
482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count,
484: p_data => x_msg_data);

Line 482: x_return_status := fnd_api.g_ret_sts_error;

478: -- SELECT pos_supplier_sites_all_object(l_pos_ap_supplier_sites_bo_tbl) INTO x_ap_supplier_sites_bo FROM dual;
479: EXCEPTION
480: WHEN fnd_api.g_exc_error THEN
481:
482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count,
484: p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN
486:

Line 485: WHEN fnd_api.g_exc_unexpected_error THEN

481:
482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get(p_count => x_msg_count,
484: p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN
486:
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get(p_count => x_msg_count,
489: p_data => x_msg_data);

Line 487: x_return_status := fnd_api.g_ret_sts_unexp_error;

483: fnd_msg_pub.count_and_get(p_count => x_msg_count,
484: p_data => x_msg_data);
485: WHEN fnd_api.g_exc_unexpected_error THEN
486:
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get(p_count => x_msg_count,
489: p_data => x_msg_data);
490: WHEN OTHERS THEN
491:

Line 492: x_return_status := fnd_api.g_ret_sts_unexp_error;

488: fnd_msg_pub.count_and_get(p_count => x_msg_count,
489: p_data => x_msg_data);
490: WHEN OTHERS THEN
491:
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493:
494: fnd_msg_pub.count_and_get(p_count => x_msg_count,
495: p_data => x_msg_data);
496:

Line 519: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

515: */
516: PROCEDURE create_pos_supplier_site_bo
517: (
518: p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
520: p_pos_supp_sites_all_bo_tbl IN pos_supplier_sites_all_bo_tbl,
521: p_party_id IN NUMBER,
522: p_orig_system IN VARCHAR2,
523: p_orig_system_reference IN VARCHAR2,

Line 622: x_return_status := fnd_api.g_ret_sts_error;

618: WHERE supp.party_id = l_party_id;
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: x_return_status := fnd_api.g_ret_sts_error;
623: x_msg_count := 1;
624: x_msg_data := SQLCODE || SQLERRM;
625: RETURN;
626: END;

Line 793: x_return_status := fnd_api.g_ret_sts_error;

789: AND nvl(hr.end_date_active, SYSDATE) >= SYSDATE;
790:
791: EXCEPTION
792: WHEN OTHERS THEN
793: x_return_status := fnd_api.g_ret_sts_error;
794: x_msg_count := 1;
795: x_msg_data := 'Party Site ID Invalid';
796: RETURN;
797: END;

Line 957: fnd_api.g_false,

953:
954: ELSIF p_create_update_flag = 'U' THEN
955: ap_vendor_pub_pkg.update_vendor_site(p_api_version,
956: p_init_msg_list,
957: fnd_api.g_false,
958: fnd_api.g_valid_level_full,
959: x_return_status,
960: x_msg_count,
961: x_msg_data,

Line 958: fnd_api.g_valid_level_full,

954: ELSIF p_create_update_flag = 'U' THEN
955: ap_vendor_pub_pkg.update_vendor_site(p_api_version,
956: p_init_msg_list,
957: fnd_api.g_false,
958: fnd_api.g_valid_level_full,
959: x_return_status,
960: x_msg_count,
961: x_msg_data,
962: vendor_site_rec,

Line 966: x_return_status := fnd_api.g_ret_sts_unexp_error;

962: vendor_site_rec,
963: vendor_site_rec.vendor_site_id,
964: 'NOT ISETUP');
965: ELSE
966: x_return_status := fnd_api.g_ret_sts_unexp_error;
967: x_msg_data := 'Create update flag is neither C nor U, exiting';
968: RETURN;
969: END IF;
970: END LOOP;

Line 973: WHEN fnd_api.g_exc_error THEN

969: END IF;
970: END LOOP;
971:
972: EXCEPTION
973: WHEN fnd_api.g_exc_error THEN
974:
975: x_return_status := fnd_api.g_ret_sts_error;
976: fnd_msg_pub.count_and_get(p_count => x_msg_count,
977: p_data => x_msg_data);

Line 975: x_return_status := fnd_api.g_ret_sts_error;

971:
972: EXCEPTION
973: WHEN fnd_api.g_exc_error THEN
974:
975: x_return_status := fnd_api.g_ret_sts_error;
976: fnd_msg_pub.count_and_get(p_count => x_msg_count,
977: p_data => x_msg_data);
978: WHEN fnd_api.g_exc_unexpected_error THEN
979:

Line 978: WHEN fnd_api.g_exc_unexpected_error THEN

974:
975: x_return_status := fnd_api.g_ret_sts_error;
976: fnd_msg_pub.count_and_get(p_count => x_msg_count,
977: p_data => x_msg_data);
978: WHEN fnd_api.g_exc_unexpected_error THEN
979:
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: fnd_msg_pub.count_and_get(p_count => x_msg_count,
982: p_data => x_msg_data);

Line 980: x_return_status := fnd_api.g_ret_sts_unexp_error;

976: fnd_msg_pub.count_and_get(p_count => x_msg_count,
977: p_data => x_msg_data);
978: WHEN fnd_api.g_exc_unexpected_error THEN
979:
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: fnd_msg_pub.count_and_get(p_count => x_msg_count,
982: p_data => x_msg_data);
983: WHEN OTHERS THEN
984:

Line 985: x_return_status := fnd_api.g_ret_sts_unexp_error;

981: fnd_msg_pub.count_and_get(p_count => x_msg_count,
982: p_data => x_msg_data);
983: WHEN OTHERS THEN
984:
985: x_return_status := fnd_api.g_ret_sts_unexp_error;
986:
987: fnd_msg_pub.count_and_get(p_count => x_msg_count,
988: p_data => x_msg_data);
989: END create_pos_supplier_site_bo;