DBA Data[Home] [Help]

APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on FND_API

Line 268: IF NOT FND_API.Compatible_API_Call(

264: print_debuginfo(l_module_name, 'p_exchange_date: '||p_exchange_date,
265: G_LEVEL_PROCEDURE);
266:
267: /* standard call to check for api compatibility */
268: IF NOT FND_API.Compatible_API_Call(
269: l_api_version,
270: p_api_version,
271: l_api_name,
272: G_PKG_NAME) THEN

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: p_api_version,
271: l_api_name,
272: G_PKG_NAME) THEN
273:
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275:
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277:
278: END IF;

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: G_PKG_NAME) THEN
273:
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275:
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277:
278: END IF;
279:
280: /* initialize message list if p_init_msg_list is set to TRUE. */

Line 281: IF FND_API.to_Boolean(p_init_msg_list) THEN

277:
278: END IF;
279:
280: /* initialize message list if p_init_msg_list is set to TRUE. */
281: IF FND_API.to_Boolean(p_init_msg_list) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284:
285: /* initialize API return status to success */

Line 286: x_return_status := FND_API.G_RET_STS_SUCCESS;

282: FND_MSG_PUB.initialize;
283: END IF;
284:
285: /* initialize API return status to success */
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287: l_temp_status := 'S';
288:
289: l_debug_info := 'Get invoice_info';
290: print_debuginfo(l_module_name, l_debug_info,

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

380: -- in a TRUE value for the P_called_Online parameter (the last param)
381: -- because we don't want the ap debug pkg to get it off the stack at
382: -- the same time.
383:
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385:
386: FND_MESSAGE.SET_NAME('SQLAP', 'AP_PERIOD_NOT_OPEN');
387: FND_MSG_PUB.ADD;
388:

Line 431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

427:
428: EXCEPTION
429: WHEN NO_DATA_FOUND THEN
430:
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432:
433: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CE_INVALID_BANK_ACCT');
434: FND_MSG_PUB.ADD;
435:

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

460: -- State that we need to to have an exchange rate if the
461: -- type is USER this is irrespective of the value of the
462: -- make_rate_mandatory_flag on AP_SYSTEM_PARAMETERS
463:
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
466: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_USER_XRATE');
467: FND_MSG_PUB.ADD;
468:

Line 502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

498:
499: IF (l_check_rec.xrate is NULL
500: AND l_asp_rec.make_rate_mandatory_flag = 'Y') THEN
501:
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503:
504: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_XRATE');
505: FND_MSG_PUB.ADD;
506:

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: EXCEPTION
523:
524: WHEN NO_DATA_FOUND THEN
525:
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527:
528: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INVOICE_CANNOT_BE_PAID');
529: FND_MSG_PUB.ADD;
530:

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

542: -- This means that the payment schedules for the one invoice may
543: -- have different payment methods. If that is the case, we cannot
544: -- handle in one payment.
545:
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547:
548: FND_MESSAGE.SET_NAME('SQLAP', 'AP_MISMATCHED_PMT_SCHEDS');
549: FND_MSG_PUB.ADD;
550:

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

570: WHERE invoice_id = P_invoice_id;
571:
572: IF (l_num_invs_sel_for_pmt > 0) THEN
573:
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575:
576: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INV_PAY_FAIL_SEL_BY_BATCH');
577: FND_MSG_PUB.ADD;
578:

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

785: -- The Vendor Site that was on the invoice does not exist or
786: -- we cannot pay invoices for this vendor or the vendor has no
787: -- active pay sites
788:
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790:
791: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_VENDOR_SITE');
792: FND_MSG_PUB.ADD;
793:

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

827:
828: EXCEPTION
829: WHEN NO_DATA_FOUND THEN
830:
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832:
833: FND_MESSAGE.SET_NAME('SQLAP', 'AP_IBY_INVALID_PAYMENT_PROF');
834: FND_MSG_PUB.ADD;
835:

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

847: -- Verify payment document is needed or not
848: IF l_processing_type = 'PRINTED' THEN
849: IF p_payment_document_id IS NULL THEN
850:
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852:
853: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CE_PAYMENT_DOC_NEEDED');
854: FND_MSG_PUB.ADD;
855:

Line 896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

892: x_msg_count => x_msg_count,
893: x_msg_data => x_msg_data,
894: show_warn_msgs_flag => 'T');
895:
896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
897:
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: print_debuginfo(l_module_name, 'EXIT',
900: G_LEVEL_PROCEDURE);

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

894: show_warn_msgs_flag => 'T');
895:
896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
897:
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: print_debuginfo(l_module_name, 'EXIT',
900: G_LEVEL_PROCEDURE);
901: l_temp_status := 'E';
902:

Line 908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

904:
905: EXCEPTION
906:
907: WHEN NO_DATA_FOUND THEN
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909:
910: FND_MESSAGE.SET_NAME('SQLAP', 'AP_PAY_DOCUMENT_ALREADY_IN_USE');
911: FND_MSG_PUB.ADD;
912:

Line 952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

948: EXCEPTION
949:
950: WHEN NO_DATA_FOUND THEN
951:
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953:
954: FND_MESSAGE.SET_NAME('SQLAP', 'AP_PAY_NO_VENDOR');
955: FND_MSG_PUB.ADD;
956:

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034:
1035: EXCEPTION
1036: WHEN NO_DATA_FOUND THEN
1037:
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039:
1040: FND_MESSAGE.SET_NAME('SQLAP', 'AP_IBY_INVALID_PAYMENT_METHOD');
1041: FND_MSG_PUB.ADD;
1042:

Line 1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1078: AND table_name IN ('AP_CHECKS','AP_CHECKS_ALL');
1079: exception
1080: when no_data_found then
1081:
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: FND_MESSAGE.SET_NAME('SQLAP', 'AP_SEQ_NO_DOC_CAT');
1084: FND_MSG_PUB.ADD;
1085: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1086: p_data => x_msg_data);

Line 1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1106:
1107:
1108: if l_doc_category_code = '-1' and l_seq_num_profile = 'A' then
1109:
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1111: FND_MESSAGE.SET_NAME('SQLAP', 'AP_SEQ_DOC_CAT_NO_FOUND');
1112: FND_MSG_PUB.ADD;
1113: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1114: p_data => x_msg_data);

Line 1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1122: if l_doc_category_code <> '-1' and
1123: l_asp_rec.pay_doc_override <> 'Y' and
1124: l_doc_category_code <> p_doc_category_code then
1125:
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: FND_MESSAGE.SET_NAME('SQLAP', 'AP_SEQ_DOC_NO_REQ');
1128: FND_MSG_PUB.ADD;
1129: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1130: p_data => x_msg_data);

Line 1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1157:
1158: --reject if invalid and seq numbering is always used
1159: if (l_return_code <> 0 or l_docseq_type = 'M') and l_seq_num_profile = 'A' then
1160:
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: FND_MESSAGE.SET_NAME('SQLAP', 'AP_SEQ_CREATE_ERROR');
1163: FND_MSG_PUB.ADD;
1164: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1165: p_data => x_msg_data);

Line 1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1182: 'N');
1183:
1184: if l_return_code <> 0 and l_seq_num_profile = 'A' then
1185:
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: FND_MESSAGE.SET_NAME('SQLAP', 'AP_SEQ_CREATE_ERROR');
1188: FND_MSG_PUB.ADD;
1189: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
1190: p_data => x_msg_data);

Line 1605: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1601: x_msg_count => x_msg_count,
1602: x_msg_data => x_msg_data
1603: );
1604:
1605: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1606:
1607: UPDATE AP_CHECKS_ALL
1608: SET payment_id = l_payment_id
1609: WHERE check_id = l_check_rec.check_id;

Line 1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1635:
1636:
1637: ELSE
1638:
1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640:
1641: END IF; -- l_temp_status
1642:
1643: EXCEPTION

Line 1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1653: G_LEVEL_PROCEDURE);
1654: print_debuginfo(l_module_name, 'SQLERRM: ' || SQLERRM,
1655: G_LEVEL_PROCEDURE);
1656:
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: print_debuginfo(l_module_name, 'EXIT',
1659: G_LEVEL_PROCEDURE);
1660:
1661: RETURN;