DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on PO_DOCUMENT_UPDATE_PVT

Line 1: PACKAGE BODY PO_DOCUMENT_UPDATE_PVT AS

1: PACKAGE BODY PO_DOCUMENT_UPDATE_PVT AS
2: /* $Header: POXVCPOB.pls 120.43.12010000.2 2008/08/22 21:00:55 rarajar ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DOCUMENT_UPDATE_PVT';

4: -- Read the profile option that enables/disables the debug log
5: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6:
7: g_application_id CONSTANT NUMBER := 201;
8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DOCUMENT_UPDATE_PVT';
9: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
10:
11: -- Submission Checks rounds to 10 places, so we will round to 10 as well:
12: g_qty_precision CONSTANT NUMBER := 10;

Line 353: SAVEPOINT PO_DOCUMENT_UPDATE_PVT_SP;

349: END IF;
350: log_changes(p_changes); -- Print the changes for statement-level logging.
351: END IF;
352:
353: SAVEPOINT PO_DOCUMENT_UPDATE_PVT_SP;
354: x_return_status := FND_API.G_RET_STS_SUCCESS;
355:
356: -- Standard API initialization:
357: IF NOT FND_API.compatible_api_call (

Line 468: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;

464: log_changes(p_changes); -- Print the changes for statement-level logging.
465: END IF;
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: x_api_errors := g_api_errors;
471: log_changes(p_changes); -- Print the changes for statement-level logging.
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 473: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;

469: x_return_status := FND_API.G_RET_STS_ERROR;
470: x_api_errors := g_api_errors;
471: log_changes(p_changes); -- Print the changes for statement-level logging.
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;
474: -- Add the errors on the API message list to g_api_errors.
475: add_message_list_errors ( p_api_errors => g_api_errors,
476: x_return_status => x_return_status,
477: p_start_index => l_last_msg_list_index + 1 );

Line 482: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;

478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: x_api_errors := g_api_errors;
480: log_changes(p_changes); -- Print the changes for statement-level logging.
481: WHEN OTHERS THEN
482: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;
483: -- Add the unexpected error to the API message list.
484: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
485: p_proc_name => l_api_name );
486: -- Add the errors on the API message list to g_api_errors.

Line 1865: PO_DOCUMENT_UPDATE_PVT.add_error (

1861: p_entity_id => i );
1862:
1863:
1864: ELSIF (l_secondary_default_ind = 'F') THEN
1865: PO_DOCUMENT_UPDATE_PVT.add_error (
1866: p_api_errors => g_api_errors,
1867: x_return_status => l_return_status,
1868: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
1869: p_token_name1 => 'PQTY',

Line 3524: PO_DOCUMENT_UPDATE_PVT.add_error (

3520: IF (l_return_status = 0) THEN
3521:
3522: x_data := FND_MSG_PUB.Get( 1,'F');
3523:
3524: PO_DOCUMENT_UPDATE_PVT.add_error (
3525: p_api_errors => g_api_errors,
3526: x_return_status => l_return_status,
3527: p_message_name => NULL,
3528: p_message_text => x_data);

Line 3582: PO_DOCUMENT_UPDATE_PVT.add_error (

3578: p_uom_code2 => NULL
3579: );
3580: IF (l_return_status = 0) THEN
3581: x_data := FND_MSG_PUB.Get( 1,'F');
3582: PO_DOCUMENT_UPDATE_PVT.add_error (
3583: p_api_errors => g_api_errors,
3584: x_return_status => l_return_status,
3585: p_message_name => NULL,
3586: p_message_text => x_data);

Line 3671: PO_DOCUMENT_UPDATE_PVT.add_error(p_api_errors => g_api_errors,

3667: /* sschinch INVCONV added this line to clear secondary quantity if a value is passed */
3668:
3669: IF (l_secondary_default_ind IS NULL AND p_chg.shipment_changes.secondary_quantity(i) IS NOT NULL) THEN
3670: p_chg.shipment_changes.secondary_quantity(i) := NULL;
3671: PO_DOCUMENT_UPDATE_PVT.add_error(p_api_errors => g_api_errors,
3672: x_return_status => l_return_status,
3673: p_message_name => 'PO_SECONDARY_QTY_NOT_REQUIRED');
3674: x_return_Status := FND_API.G_RET_STS_ERROR;
3675: RETURN;

Line 3683: PO_DOCUMENT_UPDATE_PVT.add_error (

3679: IF (l_secondary_default_ind IS NOT NULL) THEN
3680:
3681: IF (l_new_qty IS NULL AND l_new_secondary_qty IS NOT NULL AND
3682: l_secondary_default_ind = 'F') THEN
3683: PO_DOCUMENT_UPDATE_PVT.add_error (
3684: p_api_errors => g_api_errors,
3685: x_return_status => l_return_status,
3686: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
3687: p_token_name1 => 'PQTY',

Line 3735: PO_DOCUMENT_UPDATE_PVT.add_error (

3731: );
3732: IF (l_return_status = 0) THEN
3733: x_data := FND_MSG_PUB.Get( 1,'F');
3734:
3735: PO_DOCUMENT_UPDATE_PVT.add_error (
3736: p_api_errors => g_api_errors,
3737: x_return_status => l_return_status,
3738: p_message_name => NULL,
3739: p_message_text => x_data);

Line 3772: PO_DOCUMENT_UPDATE_PVT.add_error (

3768: );
3769: IF (l_return_status = 0) THEN
3770: x_data := FND_MSG_PUB.Get( 1,'F');
3771:
3772: PO_DOCUMENT_UPDATE_PVT.add_error (
3773: p_api_errors => g_api_errors,
3774: x_return_status => l_return_status,
3775: p_message_name => NULL,
3776: p_message_text => x_data);

Line 8880: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.validate_delete_action';

8876: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
8877: l_allow_delete VARCHAR2(1);
8878: d_pos NUMBER := 0;
8879: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';
8880: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.validate_delete_action';
8881:
8882: BEGIN
8883: IF (PO_LOG.d_proc) THEN
8884: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_entity', p_entity); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id);

Line 9106: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';

9102: l_error_message VARCHAR2(2000);
9103: l_entity_row_id ROWID := NULL;
9104: d_pos NUMBER := 0;
9105: l_api_name CONSTANT VARCHAR2(30) := 'process_delete_action';
9106: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';
9107:
9108: BEGIN
9109: IF (PO_LOG.d_proc) THEN
9110: PO_LOG.proc_begin(d_module, 'p_init_msg_list', p_init_msg_list); PO_LOG.proc_begin(d_module, 'p_entity', p_entity); PO_LOG.proc_begin(d_module, 'p_entity_row_id', p_entity_row_id);

Line 9256: END PO_DOCUMENT_UPDATE_PVT;

9252: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9253: END IF;
9254: END process_delete_action;
9255:
9256: END PO_DOCUMENT_UPDATE_PVT;