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 771: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 824: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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