DBA Data[Home] [Help]

APPS.PO_INTG_DOCUMENT_FUNDS_GRP dependencies on FND_API

Line 73: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

69: --OUT:
70: --x_packet_id
71: -- GL PACKET ID, if gl entries are made otherwise null
72: --x_return_status
73: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
74: -- FND_API.G_RET_STS_ERROR if validation fails
75: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
76: --Testing:
77: --

Line 74: -- FND_API.G_RET_STS_ERROR if validation fails

70: --x_packet_id
71: -- GL PACKET ID, if gl entries are made otherwise null
72: --x_return_status
73: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
74: -- FND_API.G_RET_STS_ERROR if validation fails
75: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
76: --Testing:
77: --
78: --End of Comments

Line 75: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

71: -- GL PACKET ID, if gl entries are made otherwise null
72: --x_return_status
73: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
74: -- FND_API.G_RET_STS_ERROR if validation fails
75: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
76: --Testing:
77: --
78: --End of Comments
79: -------------------------------------------------------------------------------

Line 82: p_commit IN VARCHAR2 default FND_API.G_FALSE,

78: --End of Comments
79: -------------------------------------------------------------------------------
80: PROCEDURE reinstate_po_encumbrance(
81: p_api_version IN NUMBER,
82: p_commit IN VARCHAR2 default FND_API.G_FALSE,
83: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
84: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
85: p_distribution_id IN NUMBER,
86: p_invoice_id IN NUMBER,

Line 83: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

79: -------------------------------------------------------------------------------
80: PROCEDURE reinstate_po_encumbrance(
81: p_api_version IN NUMBER,
82: p_commit IN VARCHAR2 default FND_API.G_FALSE,
83: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
84: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
85: p_distribution_id IN NUMBER,
86: p_invoice_id IN NUMBER,
87: p_encumbrance_amt IN NUMBER,

Line 84: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

80: PROCEDURE reinstate_po_encumbrance(
81: p_api_version IN NUMBER,
82: p_commit IN VARCHAR2 default FND_API.G_FALSE,
83: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
84: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
85: p_distribution_id IN NUMBER,
86: p_invoice_id IN NUMBER,
87: p_encumbrance_amt IN NUMBER,
88: p_qty_cancelled IN NUMBER,

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

146: EXCEPTION
147:
148: WHEN OTHERS THEN
149: ROLLBACK TO REINSTATE_PO_ENCUMBRANCE_SP;
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
152: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
153: END IF;
154:

Line 201: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

197: -- Unique id of row from either po_req_distributions_all or
198: -- po_distributions_all table, depending on p_doc_type
199: --OUT:
200: --x_return_status
201: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
202: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
203: --x_active_enc_amount
204: -- The current active encumbrance on the distribution identified
205: -- by p_distribution_id

Line 202: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

198: -- po_distributions_all table, depending on p_doc_type
199: --OUT:
200: --x_return_status
201: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
202: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
203: --x_active_enc_amount
204: -- The current active encumbrance on the distribution identified
205: -- by p_distribution_id
206: --Testing:

Line 212: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

208: --End of Comments
209: -------------------------------------------------------------------------------
210: PROCEDURE get_active_encumbrance_amount(
211: p_api_version IN NUMBER
212: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
213: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
214: , x_return_status OUT NOCOPY VARCHAR2
215: , p_doc_type IN VARCHAR2
216: , p_distribution_id IN NUMBER

Line 213: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL

209: -------------------------------------------------------------------------------
210: PROCEDURE get_active_encumbrance_amount(
211: p_api_version IN NUMBER
212: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
213: , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
214: , x_return_status OUT NOCOPY VARCHAR2
215: , p_doc_type IN VARCHAR2
216: , p_distribution_id IN NUMBER
217: , x_active_enc_amount OUT NOCOPY NUMBER

Line 254: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

250: END IF;
251: END IF;
252:
253: -- Standard call to check for call compatibility
254: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
255: G_PKG_NAME) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252:
253: -- Standard call to check for call compatibility
254: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
255: G_PKG_NAME) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259: l_progress := '010';
260:

Line 262: IF FND_API.to_Boolean( p_init_msg_list ) THEN

258:
259: l_progress := '010';
260:
261: -- Initialize message list if p_init_msg_list is set to TRUE.
262: IF FND_API.to_Boolean( p_init_msg_list ) THEN
263: FND_MSG_PUB.initialize;
264: END IF;
265:
266: l_progress := '020';

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265:
266: l_progress := '020';
267:
268: -- Initialize API return status to success
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: l_progress := '030';
272: IF g_fnd_debug = 'Y' THEN
273: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

328: ||'.'|| l_progress, 'Internal Reqs are not supported');
329: END IF;
330: END IF;
331:
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END IF;
334:
335: ELSIF p_doc_type = g_doc_type_PA THEN
336:

Line 439: p_init_msg_list => FND_API.G_FALSE,

435: -- bug5058165
436: -- Changed the package name from AP_UTILITIES_PKG to PSA_AP_BC_GRP
437: PSA_AP_BC_GRP.get_po_reversed_encumb_amount(
438: p_api_version =>1.0,
439: p_init_msg_list => FND_API.G_FALSE,
440: x_return_status => l_return_status,
441: x_msg_count=>l_msg_count,
442: x_msg_data=>l_msg_data,
443: p_po_distribution_id => p_distribution_id,

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: ||l_api_name ||'.' || l_progress,
485: 'Invalid value for doc type: ' || p_doc_type);
486: END IF;
487: END IF;
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489:
490: END IF; -- check on p_doc_type
491:
492: EXCEPTION

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491:
492: EXCEPTION
493:
494: WHEN OTHERS THEN
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
497: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
498: END IF;
499:

Line 523: , p_init_msg_list => FND_API.G_FALSE

519: BEGIN
520:
521: get_active_encumbrance_amount(
522: p_api_version => 1.0
523: , p_init_msg_list => FND_API.G_FALSE
524: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
525: , x_return_status => l_return_status
526: , p_doc_type => p_doc_type
527: , p_distribution_id => p_distribution_id

Line 524: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

520:
521: get_active_encumbrance_amount(
522: p_api_version => 1.0
523: , p_init_msg_list => FND_API.G_FALSE
524: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
525: , x_return_status => l_return_status
526: , p_doc_type => p_doc_type
527: , p_distribution_id => p_distribution_id
528: , x_active_enc_amount => l_active_enc_amt