DBA Data[Home] [Help]

APPS.QA_SEQUENCE_API dependencies on FND_API

Line 497: p_return_status := FND_API.G_RET_STS_SUCCESS;

493: -- CLOSE c;
494: -- END IF;
495:
496: -- Initialize return status to success
497: p_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: --
500: -- Bug 5228667
501: -- Commented out this check because although

Line 552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

548: update_record(l_row_count);
549:
550: EXCEPTION
551: WHEN OTHERS THEN
552: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: fnd_message.set_name('QA', 'QA_SEQ_GENERATION_ERROR');
554: fnd_msg_pub.add();
555:
556: END generate_seq_for_txn;

Line 602: p_return_status := FND_API.G_RET_STS_SUCCESS;

598: -- CLOSE c;
599: -- END IF;
600:
601: -- Initialize return status to success
602: p_return_status := FND_API.G_RET_STS_SUCCESS;
603:
604: IF get_eres_profile() AND eres_resubmit(p_txn_header_id,null) THEN
605:
606: -- eRes is enabled and same records are resubmitted.

Line 643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: EXCEPTION
640: WHEN OTHERS THEN
641: -- Bug 3160651. If any error happens, should return error
642:
643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644:
645: END generate_seq_for_DDE;
646:
647: FUNCTION get_all_record_info(p_collection_id NUMBER,

Line 2910: p_return_status := fnd_api.g_ret_sts_success;

2906: 'Generating sequence for collection_id = ' || p_collection_id);
2907: END IF;
2908:
2909: -- Initialize return status to success
2910: p_return_status := fnd_api.g_ret_sts_success;
2911: -- initialize fnd message table, this is used by self-service api
2912: fnd_msg_pub.initialize;
2913:
2914: -- flush off any unnecessary values from sequence message array

Line 2982: p_return_status := fnd_api.g_ret_sts_unexp_error;

2978: commit;
2979:
2980: EXCEPTION
2981: WHEN others THEN
2982: p_return_status := fnd_api.g_ret_sts_unexp_error;
2983: fnd_message.set_name('QA', 'QA_SEQ_GENERATION_ERROR');
2984: fnd_msg_pub.ADD();
2985:
2986: END generate_seq_for_txninteg;