eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AWARD_APPROVAL_PKG dependencies on PON_AWARD_APPROVAL_PKG

Line 1: PACKAGE BODY PON_AWARD_APPROVAL_PKG AS

1: PACKAGE BODY PON_AWARD_APPROVAL_PKG AS
2: /* $Header: PONAWAPB.pls 120.20.12020000.3 2013/02/09 07:47:34 hvutukur ship $ */
3: /*=======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 11: | PL/SQL body for package PON_AWARD_APPROVAL_PKG

Line 109: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SETUP_OAM_TRANSACTION';

105:
106: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
107: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
108: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
109: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SETUP_OAM_TRANSACTION';
110: BEGIN
111:
112: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'marking award ' || p_auction_header_id || ' as OAM transaction ' || p_transaction_id);
113:

Line 203: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.VALIDATE_TRANSACTION';

199:
200: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
201: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
202: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
203: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.VALIDATE_TRANSACTION';
204: BEGIN
205:
206: -- lock the transaction based on the p_lock_transaction parameter
207: IF p_lock_transaction THEN

Line 905: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';

901:
902: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
903: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
904: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
905: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
906: BEGIN
907:
908: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
909: itemkey => itemkey,

Line 1212: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';

1208:
1209: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1210: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1211: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1212: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1213: BEGIN
1214:
1215: BEGIN
1216: -- determine the OAM administrator

Line 1402: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';

1398:
1399: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1400: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1401: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1402: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1403:
1404: l_preparer_resp_id NUMBER;
1405: l_preparer_appl_id NUMBER;
1406:

Line 1818: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';

1814:
1815: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1816: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1817: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1818: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1819: BEGIN
1820:
1821: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'adding to approver list for award transaction ' || p_auction_header_id || '-' || p_transaction_id);
1822:

Line 1935: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';

1931:
1932: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1933: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1934: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1935: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1936: BEGIN
1937:
1938: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'deleting from approver list for award transaction ' || p_auction_header_id || '-' || p_transaction_id);
1939:

Line 2008: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';

2004:
2005: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2006: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2007: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2008: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
2009: BEGIN
2010:
2011: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'changing first authority approver for award transaction ' || p_auction_header_id || '-' || p_transaction_id);
2012:

Line 2150: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';

2146:
2147: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2148: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2149: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2150: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2151: BEGIN
2152:
2153: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'resetting approver list for award transaction ' || p_auction_header_id || '-' || p_transaction_id);
2154:

Line 2245: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';

2241:
2242: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2243: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2244: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2245: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2246:
2247: -- Unsolicited Lines Project
2248: l_allow_unsol_lines VARCHAR2(1);
2249: l_neg_has_unsol_lines VARCHAR2(1);

Line 2290: ,module => 'pon_award_approval_pkg.submit_for_approval'

2286: ELSE
2287: -- call pvt API to lock scoring
2288: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2289: fnd_log.string(log_level => fnd_log.level_unexpected
2290: ,module => 'pon_award_approval_pkg.submit_for_approval'
2291: ,message => 'before calling private API to lock team scoring');
2292: END IF;
2293:
2294: PON_TEAM_SCORING_UTIL_PVT.lock_scoring(p_api_version => 1

Line 2304: ,module => 'pon_award_approval_pkg.submit_for_approval'

2300:
2301: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2302: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2303: fnd_log.string(log_level => fnd_log.level_unexpected
2304: ,module => 'pon_award_approval_pkg.submit_for_approval'
2305: ,message => 'Error while locking team scoring');
2306: END IF;
2307: END IF;
2308: END IF;

Line 2401: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';

2397:
2398: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2399: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2400: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2401: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2402: BEGIN
2403:
2404: SELECT wf_award_approval_item_key
2405: INTO l_item_key

Line 2814: Converts the specified PON_AWARD_APPROVAL_PKG api_insertion code to a corresponding ame_util api_insertion code.

2810: END format_ame_approver_list;
2811:
2812:
2813: /*
2814: Converts the specified PON_AWARD_APPROVAL_PKG api_insertion code to a corresponding ame_util api_insertion code.
2815: */
2816: FUNCTION convert_to_ame_api_insertion(p_pon_api_insertion IN NUMBER) RETURN VARCHAR2 IS
2817: BEGIN
2818: IF p_pon_api_insertion = API_AUTHORITY_INSERTION THEN

Line 2830: Converts the specified ame_util api_insertion code to a corresponding PON_AWARD_APPROVAL_PKG api_insertion code.

2826: END IF;
2827: END convert_to_ame_api_insertion;
2828:
2829: /*
2830: Converts the specified ame_util api_insertion code to a corresponding PON_AWARD_APPROVAL_PKG api_insertion code.
2831: */
2832: FUNCTION convert_to_pon_api_insertion(p_ame_api_insertion IN VARCHAR2) RETURN NUMBER IS
2833: BEGIN
2834: IF p_ame_api_insertion = ame_util.apiAuthorityInsertion THEN

Line 2846: Converts the specified PON_AWARD_APPROVAL_PKG authority code to a corresponding ame_util authority code.

2842: END IF;
2843: END convert_to_pon_api_insertion;
2844:
2845: /*
2846: Converts the specified PON_AWARD_APPROVAL_PKG authority code to a corresponding ame_util authority code.
2847: */
2848: FUNCTION convert_to_ame_authority(p_pon_authority IN NUMBER) RETURN VARCHAR2 IS
2849: BEGIN
2850: IF p_pon_authority = PRE_APPROVER THEN

Line 2862: Converts the specified ame_util authority code to a corresponding PON_AWARD_APPROVAL_PKG authority code.

2858: END IF;
2859: END convert_to_ame_authority;
2860:
2861: /*
2862: Converts the specified ame_util authority code to a corresponding PON_AWARD_APPROVAL_PKG authority code.
2863: */
2864: FUNCTION convert_to_pon_authority(p_ame_authority IN VARCHAR2) RETURN NUMBER IS
2865: BEGIN
2866: IF p_ame_authority = ame_util.preApprover THEN

Line 2878: Converts the specified PON_AWARD_APPROVAL_PKG approval_status code to a corresponding ame_util approval_status code.

2874: END IF;
2875: END convert_to_pon_authority;
2876:
2877: /*
2878: Converts the specified PON_AWARD_APPROVAL_PKG approval_status code to a corresponding ame_util approval_status code.
2879: */
2880: FUNCTION convert_to_ame_approval_status(p_pon_approval_status IN NUMBER) RETURN VARCHAR2 IS
2881: BEGIN
2882: IF p_pon_approval_status = APPROVE_AND_FORWARD_STATUS THEN

Line 2914: Converts the specified ame_util approval_status code to a corresponding PON_AWARD_APPROVAL_PKG approval_status code.

2910: END IF;
2911: END convert_to_ame_approval_status;
2912:
2913: /*
2914: Converts the specified ame_util approval_status code to a corresponding PON_AWARD_APPROVAL_PKG approval_status code.
2915: */
2916: FUNCTION convert_to_pon_approval_status(p_ame_approval_status IN VARCHAR2) RETURN NUMBER IS
2917: BEGIN
2918: IF p_ame_approval_status = ame_util.approveAndForwardStatus THEN

Line 3413: END PON_AWARD_APPROVAL_PKG;

3409: --RETURN(fnd_global.local_chr(ascii_chr => 12));
3410: RETURN(fnd_global.local_chr(ascii_chr => 13));
3411: END getAMERecordDelimiter;
3412:
3413: END PON_AWARD_APPROVAL_PKG;