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.50.12020000.3 2013/03/05 02:35:43 pla 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 360: SAVEPOINT PO_DOCUMENT_UPDATE_PVT_SP;

356: END IF;
357: log_changes(p_changes); -- Print the changes for statement-level logging.
358: END IF;
359:
360: SAVEPOINT PO_DOCUMENT_UPDATE_PVT_SP;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: -- Standard API initialization:
364: IF NOT FND_API.compatible_api_call (

Line 475: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;

471: log_changes(p_changes); -- Print the changes for statement-level logging.
472: END IF;
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: x_api_errors := g_api_errors;
478: log_changes(p_changes); -- Print the changes for statement-level logging.
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 480: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;

476: x_return_status := FND_API.G_RET_STS_ERROR;
477: x_api_errors := g_api_errors;
478: log_changes(p_changes); -- Print the changes for statement-level logging.
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;
481: -- Add the errors on the API message list to g_api_errors.
482: add_message_list_errors ( p_api_errors => g_api_errors,
483: x_return_status => x_return_status,
484: p_start_index => l_last_msg_list_index + 1 );

Line 489: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;

485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: x_api_errors := g_api_errors;
487: log_changes(p_changes); -- Print the changes for statement-level logging.
488: WHEN OTHERS THEN
489: ROLLBACK TO PO_DOCUMENT_UPDATE_PVT_SP;
490: -- Add the unexpected error to the API message list.
491: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
492: p_proc_name => l_api_name );
493: -- Add the errors on the API message list to g_api_errors.

Line 1888: PO_DOCUMENT_UPDATE_PVT.add_error (

1884: p_entity_id => i );
1885:
1886:
1887: ELSIF (l_secondary_default_ind = 'F') THEN
1888: PO_DOCUMENT_UPDATE_PVT.add_error (
1889: p_api_errors => g_api_errors,
1890: x_return_status => l_return_status,
1891: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
1892: p_token_name1 => 'PQTY',

Line 3547: PO_DOCUMENT_UPDATE_PVT.add_error (

3543: IF (l_return_status = 0) THEN
3544:
3545: x_data := FND_MSG_PUB.Get( 1,'F');
3546:
3547: PO_DOCUMENT_UPDATE_PVT.add_error (
3548: p_api_errors => g_api_errors,
3549: x_return_status => l_return_status,
3550: p_message_name => NULL,
3551: p_message_text => x_data);

Line 3604: PO_DOCUMENT_UPDATE_PVT.add_error (

3600: p_uom_code2 => NULL
3601: );
3602: IF (l_return_status = 0) THEN
3603: x_data := FND_MSG_PUB.Get( 1,'F');
3604: PO_DOCUMENT_UPDATE_PVT.add_error (
3605: p_api_errors => g_api_errors,
3606: x_return_status => l_return_status,
3607: p_message_name => NULL,
3608: p_message_text => x_data);

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

3704: /* sschinch INVCONV added this line to clear secondary quantity if a value is passed */
3705:
3706: IF (l_secondary_default_ind IS NULL AND p_chg.shipment_changes.secondary_quantity(i) IS NOT NULL) THEN
3707: p_chg.shipment_changes.secondary_quantity(i) := NULL;
3708: PO_DOCUMENT_UPDATE_PVT.add_error(p_api_errors => g_api_errors,
3709: x_return_status => l_return_status,
3710: p_message_name => 'PO_SECONDARY_QTY_NOT_REQUIRED');
3711: x_return_Status := FND_API.G_RET_STS_ERROR;
3712: RETURN;

Line 3720: PO_DOCUMENT_UPDATE_PVT.add_error (

3716: IF (l_secondary_default_ind IS NOT NULL) THEN
3717:
3718: IF (l_new_qty IS NULL AND l_new_secondary_qty IS NOT NULL AND
3719: l_secondary_default_ind = 'F') THEN
3720: PO_DOCUMENT_UPDATE_PVT.add_error (
3721: p_api_errors => g_api_errors,
3722: x_return_status => l_return_status,
3723: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
3724: p_token_name1 => 'PQTY',

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 3809: PO_DOCUMENT_UPDATE_PVT.add_error (

3805: );
3806: IF (l_return_status = 0) THEN
3807: x_data := FND_MSG_PUB.Get( 1,'F');
3808:
3809: PO_DOCUMENT_UPDATE_PVT.add_error (
3810: p_api_errors => g_api_errors,
3811: x_return_status => l_return_status,
3812: p_message_name => NULL,
3813: p_message_text => x_data);

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

9011: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
9012: l_allow_delete VARCHAR2(1);
9013: d_pos NUMBER := 0;
9014: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';
9015: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.validate_delete_action';
9016:
9017: BEGIN
9018: IF (PO_LOG.d_proc) THEN
9019: 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 9241: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';

9237: l_error_message VARCHAR2(2000);
9238: l_entity_row_id ROWID := NULL;
9239: d_pos NUMBER := 0;
9240: l_api_name CONSTANT VARCHAR2(30) := 'process_delete_action';
9241: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_UPDATE_PVT.process_delete_action';
9242:
9243: BEGIN
9244: IF (PO_LOG.d_proc) THEN
9245: 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 9391: END PO_DOCUMENT_UPDATE_PVT;

9387: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in ' || SQLCODE||':'||SQLERRM);
9388: END IF;
9389: END process_delete_action;
9390:
9391: END PO_DOCUMENT_UPDATE_PVT;