DBA Data[Home] [Help]

APPS.PO_INVOICES_SV1 dependencies on FND_API

Line 47: l_consumption_comp_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

43: X_invoice_date DATE;
44:
45:
46: /* */
47: l_consumption_comp_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
48:
49:
50: BEGIN
51:

Line 130: IF (l_consumption_comp_status <> FND_API.G_RET_STS_SUCCESS) THEN

126: found during the execution of this program, X_completion_code will
127: be FALSE. **/
128:
129: /* */
130: IF (l_consumption_comp_status <> FND_API.G_RET_STS_SUCCESS) THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133: /* */
134:

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: be FALSE. **/
128:
129: /* */
130: IF (l_consumption_comp_status <> FND_API.G_RET_STS_SUCCESS) THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133: /* */
134:
135: EXCEPTION

Line 137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

133: /* */
134:
135: EXCEPTION
136: /* */
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: RAISE; /* Error has been printed. No need to print error here */
139: /* */
140: WHEN others THEN
141: po_message_s.sql_error('create_ap_invoices', x_progress,sqlcode);

Line 234: , p_init_msg_list => FND_API.G_FALSE

230: AND otl.language = userenv('LANG');
231:
232: IBY_DISBURSEMENT_COMP_PUB.Get_Default_Payment_Attributes(
233: p_api_version => 1.0
234: , p_init_msg_list => FND_API.G_FALSE
235: , p_ignore_payee_pref => 'N'
236: , p_trxn_attributes_rec => x_txn_attributes_rec
237: , x_return_status => x_return_status
238: , x_msg_count => x_msg_count

Line 774: x_return_status := FND_API.G_RET_STS_SUCCESS;

770: x_request_id OUT NOCOPY NUMBER)
771: IS
772: l_api_name VARCHAR2(50) := 'submit_invoice_import';
773: BEGIN
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:
776: x_request_id := fnd_request.submit_request(
777: 'SQLAP',
778: 'APXIIMPT',

Line 817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

813: WHEN OTHERS THEN
814: IF (g_asn_debug = 'Y') THEN
815: ASN_DEBUG.put_line('Error in submit invoice import.');
816: END IF;
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
819: END submit_invoice_import;
820:
821: PROCEDURE delete_interface_records(

Line 827: x_return_status := FND_API.G_RET_STS_SUCCESS;

823: p_group_id IN VARCHAR2)
824: IS
825: l_api_name VARCHAR2(50) := 'delete_interface_records';
826: BEGIN
827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828:
829: DELETE FROM ap_invoice_lines_interface aili
830: WHERE EXISTS (SELECT 1
831: FROM ap_invoices_interface aii

Line 839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

835: DELETE FROM ap_invoices_interface aii
836: WHERE aii.group_id = p_group_id;
837: EXCEPTION
838: WHEN OTHERS THEN
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
841: END delete_interface_records;
842:
843: /* */