DBA Data[Home] [Help]

APPS.PO_SOURCING_PVT dependencies on PO_SOURCING_PVT

Line 1: PACKAGE BODY PO_SOURCING_PVT AS

1: PACKAGE BODY PO_SOURCING_PVT AS
2: /* $Header: POXVCPAB.pls 120.4 2006/04/27 15:28:03 bao noship $*/
3:
4:
5: ---

Line 29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_PVT';

25: ---
26:
27: --------------------------------------------------------------------------------
28:
29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_PVT';
30: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_PVT.';
31: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
32: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
33:

Line 30: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_PVT.';

26:
27: --------------------------------------------------------------------------------
28:
29: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SOURCING_PVT';
30: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SOURCING_PVT.';
31: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
32: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
33:
34:

Line 284: p_pkg_name => 'PO_SOURCING_PVT',

280: p_message => SQLERRM);
281: END IF;
282:
283: FND_MSG_PUB.add_exc_msg(
284: p_pkg_name => 'PO_SOURCING_PVT',
285: p_procedure_name => l_api_name,
286: p_error_text => NULL);
287: END get_system_defaults;
288:

Line 568: p_pkg_name => 'PO_SOURCING_PVT',

564: p_token => g_progress,
565: p_message => SQLERRM);
566: END IF;
567: FND_MSG_PUB.add_exc_msg(
568: p_pkg_name => 'PO_SOURCING_PVT',
569: p_procedure_name => l_api_name,
570: p_error_text => NULL);
571:
572: END DEFAULT_CPA;

Line 781: p_pkg_name => 'PO_SOURCING_PVT',

777: p_token => g_progress,
778: p_message => SQLERRM);
779: END IF;
780: FND_MSG_PUB.add_exc_msg(
781: p_pkg_name => 'PO_SOURCING_PVT',
782: p_procedure_name => l_api_name,
783: p_error_text => NULL);
784: END VALIDATE_CPA;
785:

Line 1323: p_pkg_name => 'PO_SOURCING_PVT',

1319: p_token => g_progress,
1320: p_message => SQLERRM);
1321: END IF;
1322: FND_MSG_PUB.add_exc_msg(
1323: p_pkg_name => 'PO_SOURCING_PVT',
1324: p_procedure_name => l_api_name,
1325: p_error_text => NULL);
1326: END INSERT_CPA;
1327:

Line 1423: p_message => 'Before calling po_sourcing_pvt.default_cpa');

1419: g_progress := '501';
1420: IF g_debug_stmt THEN
1421: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1422: p_token => g_progress,
1423: p_message => 'Before calling po_sourcing_pvt.default_cpa');
1424: END IF;
1425: -- Default the required fields in the record
1426: DEFAULT_CPA(
1427: x_return_status => l_return_status

Line 1434: p_message => 'After calling po_sourcing_pvt.default_cpa');

1430: g_progress := '502';
1431: IF g_debug_stmt THEN
1432: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1433: p_token => g_progress,
1434: p_message => 'After calling po_sourcing_pvt.default_cpa');
1435: END IF;
1436:
1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1450: p_message => 'Before calling po_sourcing_pvt.validate_cpa');

1446: g_progress := '503';
1447: IF g_debug_stmt THEN
1448: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1449: p_token => g_progress,
1450: p_message => 'Before calling po_sourcing_pvt.validate_cpa');
1451: END IF;
1452:
1453: VALIDATE_CPA(
1454: x_return_status => l_return_status

Line 1461: p_message => 'After calling po_sourcing_pvt.validate_cpa');

1457: g_progress := '504';
1458: IF g_debug_stmt THEN
1459: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1460: p_token => g_progress,
1461: p_message => 'After calling po_sourcing_pvt.validate_cpa');
1462: END IF;
1463:
1464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1477: p_message => 'Before calling po_sourcing_pvt.insert_cpa');

1473: g_progress := '505';
1474: IF g_debug_stmt THEN
1475: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1476: p_token => g_progress,
1477: p_message => 'Before calling po_sourcing_pvt.insert_cpa');
1478: END IF;
1479:
1480: INSERT_CPA (
1481: p_auction_header_id => p_auction_header_id,

Line 1495: p_message => 'After calling po_sourcing_pvt.insert_cpa');

1491: g_progress := '506';
1492: IF g_debug_stmt THEN
1493: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1494: p_token => g_progress,
1495: p_message => 'After calling po_sourcing_pvt.insert_cpa');
1496: END IF;
1497:
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1569: p_pkg_name => 'PO_SOURCING_PVT',

1565: p_message => SQLERRM);
1566: END IF;
1567:
1568: FND_MSG_PUB.add_exc_msg(
1569: p_pkg_name => 'PO_SOURCING_PVT',
1570: p_procedure_name => l_api_name,
1571: p_error_text => NULL);
1572: END CREATE_CPA;
1573:

Line 1630: p_pkg_name => 'PO_SOURCING_PVT',

1626: p_token => g_progress,
1627: p_message => SQLERRM);
1628: END IF;
1629: FND_MSG_PUB.add_exc_msg(
1630: p_pkg_name => 'PO_SOURCING_PVT',
1631: p_procedure_name => l_api_name,
1632: p_error_text => NULL);
1633: END DELETE_INTERFACE_HEADER;
1634:

Line 1636: END PO_SOURCING_PVT;

1632: p_error_text => NULL);
1633: END DELETE_INTERFACE_HEADER;
1634:
1635:
1636: END PO_SOURCING_PVT;