DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on POR_UTIL_PKG

Line 1: PACKAGE BODY POR_UTIL_PKG AS

1: PACKAGE BODY POR_UTIL_PKG AS
2: /* $Header: PORUTILB.pls 120.28.12010000.2 2008/08/02 14:39:53 kkram ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 16: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_UTIL_PKG';

12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_UTIL_PKG';
17:
18: FUNCTION bool_to_varchar(b IN BOOLEAN) RETURN VARCHAR2 IS
19: BEGIN
20: IF(b) THEN

Line 487: 'Exception at POR_UTIL_PKG.get_document_number: Exceeding limit for Negative header number generation');

483: END IF;
484: l_inc_val := l_inc_val + 1;
485: IF (l_inc_val > 3) THEN
486: RAISE_APPLICATION_ERROR(-20000,
487: 'Exception at POR_UTIL_PKG.get_document_number: Exceeding limit for Negative header number generation');
488: END IF;
489: ELSE
490: l_cannotread := FALSE;
491: END IF;

Line 1779: 'Exception at POR_UTIL_PKG.validate_pjm_project_info ' || l_progress ||

1775:
1776: EXCEPTION
1777: WHEN OTHERS THEN
1778: RAISE_APPLICATION_ERROR(-20000,
1779: 'Exception at POR_UTIL_PKG.validate_pjm_project_info ' || l_progress ||
1780: 'SQLERRM:' || SQLERRM);
1781:
1782: END validate_pjm_project_info;
1783:

Line 2396: 'Exception at POR_UTIL_PKG.check_transaction_flow ' || l_progress ||

2392: EXCEPTION
2393: WHEN OTHERS THEN
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: RAISE_APPLICATION_ERROR(-20000,
2396: 'Exception at POR_UTIL_PKG.check_transaction_flow ' || l_progress ||
2397: 'SQLERRM:' || SQLERRM);
2398:
2399: END check_transaction_flow;
2400:

Line 2415: 'Exception at POR_UTIL_PKG.truncate_po_encumbrance_gt ' || l_progress ||

2411:
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: RAISE_APPLICATION_ERROR(-20000,
2415: 'Exception at POR_UTIL_PKG.truncate_po_encumbrance_gt ' || l_progress ||
2416: 'SQLERRM:' || SQLERRM);
2417:
2418: END truncate_po_encumbrance_gt;
2419:

Line 2515: 'Exception at POR_UTIL_PKG.populate_po_encumbrance_gt ' || l_progress ||

2511:
2512: EXCEPTION
2513: WHEN OTHERS THEN
2514: RAISE_APPLICATION_ERROR(-20000,
2515: 'Exception at POR_UTIL_PKG.populate_po_encumbrance_gt ' || l_progress ||
2516: 'SQLERRM:' || SQLERRM);
2517:
2518: END populate_po_encumbrance_gt;
2519:

Line 2575: 'Exception at POR_UTIL_PKG.check_reserve ' || l_progress ||

2571: EXCEPTION
2572: WHEN OTHERS THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2574: RAISE_APPLICATION_ERROR(-20000,
2575: 'Exception at POR_UTIL_PKG.check_reserve ' || l_progress ||
2576: 'SQLERRM:' || SQLERRM);
2577:
2578: END check_reserve;
2579:

Line 2654: 'Exception at POR_UTIL_PKG.check_adjust ' || l_progress ||

2650: EXCEPTION
2651: WHEN OTHERS THEN
2652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2653: RAISE_APPLICATION_ERROR(-20000,
2654: 'Exception at POR_UTIL_PKG.check_adjust ' || l_progress ||
2655: 'SQLERRM:' || SQLERRM);
2656:
2657: END check_adjust;
2658:

Line 2752: 'Exception at POR_UTIL_PKG.do_reserve_contractor ' || l_progress ||

2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2751: RAISE_APPLICATION_ERROR(-20000,
2752: 'Exception at POR_UTIL_PKG.do_reserve_contractor ' || l_progress ||
2753: 'SQLERRM:' || SQLERRM);
2754:
2755: END do_reserve_contractor;
2756:

Line 2850: 'Exception at POR_UTIL_PKG.do_unreserve_contractor ' || l_progress ||

2846: EXCEPTION
2847: WHEN OTHERS THEN
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849: RAISE_APPLICATION_ERROR(-20000,
2850: 'Exception at POR_UTIL_PKG.do_unreserve_contractor ' || l_progress ||
2851: 'SQLERRM:' || SQLERRM);
2852:
2853: END do_unreserve_contractor;
2854:

Line 3000: p_pkg_name => 'POR_UTIL_PKG')

2996: IF NOT FND_API.Compatible_API_Call(
2997: p_current_version_number => l_api_version,
2998: p_caller_version_number => p_api_version,
2999: p_api_name => l_api_name,
3000: p_pkg_name => 'POR_UTIL_PKG')
3001: THEN
3002: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3003: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3004: module => l_api_name || '.begin',

Line 3234: END POR_UTIL_PKG;

3230: || p_req_header_id || ') ' || l_progress || ' SQLERRM:' || SQLERRM);
3231:
3232: END update_attachment_to_standard;
3233:
3234: END POR_UTIL_PKG;