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.18 2007/07/10 14:08:03 pchintap 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 891: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';

887:
888: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
889: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
890: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
891: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
892: BEGIN
893:
894: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
895: itemkey => itemkey,

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

1194:
1195: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1196: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1197: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1198: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.IS_OAM_ADMIN_AVAILABLE';
1199: BEGIN
1200:
1201: BEGIN
1202: -- determine the OAM administrator

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

1384:
1385: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1386: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1387: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1388: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.PROCESS_APPROVER_RESPONSE';
1389: BEGIN
1390:
1391: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1392: itemkey => itemkey,

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

1779:
1780: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1781: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1782: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1783: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.ADD_APPROVER';
1784: BEGIN
1785:
1786: 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);
1787:

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

1896:
1897: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1898: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1899: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1900: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.DELETE_APPROVER';
1901: BEGIN
1902:
1903: 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);
1904:

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

1969:
1970: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1971: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
1972: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1973: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.CHANGE_FIRST_APPROVER';
1974: BEGIN
1975:
1976: 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);
1977:

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

2111:
2112: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2113: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2114: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2115: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.RESET_APPROVER_LIST';
2116: BEGIN
2117:
2118: 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);
2119:

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

2206:
2207: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2208: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2209: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2210: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.SUBMIT_FOR_APPROVAL';
2211: BEGIN
2212:
2213: -- reject all active responses without an award decision
2214: IF p_reject_unawarded_responses = 'Y' THEN

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

2228: ELSE
2229: -- call pvt API to lock scoring
2230: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2231: fnd_log.string(log_level => fnd_log.level_unexpected
2232: ,module => 'pon_award_approval_pkg.submit_for_approval'
2233: ,message => 'before calling private API to lock team scoring');
2234: END IF;
2235:
2236: PON_TEAM_SCORING_UTIL_PVT.lock_scoring(p_api_version => 1

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

2242:
2243: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2244: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2245: fnd_log.string(log_level => fnd_log.level_unexpected
2246: ,module => 'pon_award_approval_pkg.submit_for_approval'
2247: ,message => 'Error while locking team scoring');
2248: END IF;
2249: END IF;
2250: END IF;

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

2340:
2341: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2342: l_exception_log_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
2343: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
2344: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.MAKE_APPROVAL_DECISION';
2345: BEGIN
2346:
2347: SELECT wf_award_approval_item_key
2348: INTO l_item_key

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

2753: END format_ame_approver_list;
2754:
2755:
2756: /*
2757: Converts the specified PON_AWARD_APPROVAL_PKG api_insertion code to a corresponding ame_util api_insertion code.
2758: */
2759: FUNCTION convert_to_ame_api_insertion(p_pon_api_insertion IN NUMBER) RETURN VARCHAR2 IS
2760: BEGIN
2761: IF p_pon_api_insertion = API_AUTHORITY_INSERTION THEN

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

2769: END IF;
2770: END convert_to_ame_api_insertion;
2771:
2772: /*
2773: Converts the specified ame_util api_insertion code to a corresponding PON_AWARD_APPROVAL_PKG api_insertion code.
2774: */
2775: FUNCTION convert_to_pon_api_insertion(p_ame_api_insertion IN VARCHAR2) RETURN NUMBER IS
2776: BEGIN
2777: IF p_ame_api_insertion = ame_util.apiAuthorityInsertion THEN

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

2785: END IF;
2786: END convert_to_pon_api_insertion;
2787:
2788: /*
2789: Converts the specified PON_AWARD_APPROVAL_PKG authority code to a corresponding ame_util authority code.
2790: */
2791: FUNCTION convert_to_ame_authority(p_pon_authority IN NUMBER) RETURN VARCHAR2 IS
2792: BEGIN
2793: IF p_pon_authority = PRE_APPROVER THEN

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

2801: END IF;
2802: END convert_to_ame_authority;
2803:
2804: /*
2805: Converts the specified ame_util authority code to a corresponding PON_AWARD_APPROVAL_PKG authority code.
2806: */
2807: FUNCTION convert_to_pon_authority(p_ame_authority IN VARCHAR2) RETURN NUMBER IS
2808: BEGIN
2809: IF p_ame_authority = ame_util.preApprover THEN

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

2817: END IF;
2818: END convert_to_pon_authority;
2819:
2820: /*
2821: Converts the specified PON_AWARD_APPROVAL_PKG approval_status code to a corresponding ame_util approval_status code.
2822: */
2823: FUNCTION convert_to_ame_approval_status(p_pon_approval_status IN NUMBER) RETURN VARCHAR2 IS
2824: BEGIN
2825: IF p_pon_approval_status = APPROVE_AND_FORWARD_STATUS THEN

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

2853: END IF;
2854: END convert_to_ame_approval_status;
2855:
2856: /*
2857: Converts the specified ame_util approval_status code to a corresponding PON_AWARD_APPROVAL_PKG approval_status code.
2858: */
2859: FUNCTION convert_to_pon_approval_status(p_ame_approval_status IN VARCHAR2) RETURN NUMBER IS
2860: BEGIN
2861: IF p_ame_approval_status = ame_util.approveAndForwardStatus THEN

Line 3353: END PON_AWARD_APPROVAL_PKG;

3349: --RETURN(fnd_global.local_chr(ascii_chr => 12));
3350: RETURN(fnd_global.local_chr(ascii_chr => 13));
3351: END getAMERecordDelimiter;
3352:
3353: END PON_AWARD_APPROVAL_PKG;