DBA Data[Home] [Help]

APPS.PON_AWARD_APPROVAL_PKG dependencies on FND_GLOBAL

Line 441: avalue => fnd_global.user_name);

437:
438: wf_engine.SetItemAttrText(itemtype => p_item_type,
439: itemkey => p_item_key,
440: aname => 'ORIGIN_USER_NAME',
441: avalue => fnd_global.user_name);
442:
443: END set_core_attributes;
444:
445: /*

Line 909: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getNextApprovers4 returns ' || fnd_global.newline || format_ame_approver_list(l_next_approver_list));

905: transactionTypeIn => AWARD_TRANSACTION_TYPE,
906: approvalProcessCompleteYNOut => l_process_out,
907: nextApproversOut => l_next_approver_list);
908:
909: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getNextApprovers4 returns ' || fnd_global.newline || format_ame_approver_list(l_next_approver_list));
910:
911: EXCEPTION
912: WHEN OTHERS THEN
913: resultout := 'OAM_API_ERROR';

Line 1208: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAdminApprover returns ' || fnd_global.newline || format_ame_approver(l_admin_approver));

1204: ame_api2.getAdminApprover(applicationIdIn => APPLICATION_ID,
1205: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1206: adminApproverOut => l_admin_approver);
1207:
1208: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAdminApprover returns ' || fnd_global.newline || format_ame_approver(l_admin_approver));
1209:
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: l_admin_approver := ame_util.emptyApproverRecord2;

Line 1695: 'calling ame_api2.updateApprovalStatus on workflow item key ' || itemkey || fnd_global.newline ||

1691: -- update the approval status for the approver
1692: log_string(l_statement_log_level,
1693: l_current_log_level,
1694: l_module_name,
1695: 'calling ame_api2.updateApprovalStatus on workflow item key ' || itemkey || fnd_global.newline ||
1696: 'with approver' || fnd_global.newline || format_ame_approver(l_approver) || fnd_global.newline ||
1697: 'and forwardee' || fnd_global.newline || format_ame_approver(l_forwardee));
1698:
1699: ame_api2.updateApprovalStatus(applicationIdIn => APPLICATION_ID,

Line 1696: 'with approver' || fnd_global.newline || format_ame_approver(l_approver) || fnd_global.newline ||

1692: log_string(l_statement_log_level,
1693: l_current_log_level,
1694: l_module_name,
1695: 'calling ame_api2.updateApprovalStatus on workflow item key ' || itemkey || fnd_global.newline ||
1696: 'with approver' || fnd_global.newline || format_ame_approver(l_approver) || fnd_global.newline ||
1697: 'and forwardee' || fnd_global.newline || format_ame_approver(l_forwardee));
1698:
1699: ame_api2.updateApprovalStatus(applicationIdIn => APPLICATION_ID,
1700: transactionIdIn => l_transaction_id,

Line 1697: 'and forwardee' || fnd_global.newline || format_ame_approver(l_forwardee));

1693: l_current_log_level,
1694: l_module_name,
1695: 'calling ame_api2.updateApprovalStatus on workflow item key ' || itemkey || fnd_global.newline ||
1696: 'with approver' || fnd_global.newline || format_ame_approver(l_approver) || fnd_global.newline ||
1697: 'and forwardee' || fnd_global.newline || format_ame_approver(l_forwardee));
1698:
1699: ame_api2.updateApprovalStatus(applicationIdIn => APPLICATION_ID,
1700: transactionIdIn => l_transaction_id,
1701: approverIn => l_approver,

Line 1752: owner => fnd_global.user_name);

1748:
1749: -- Bug 4295915: Set the workflow owner
1750: wf_engine.SetItemOwner(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1751: itemkey => p_item_key,
1752: owner => fnd_global.user_name);
1753:
1754: -- start workflow process
1755: wf_engine.StartProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1756: itemkey => p_item_key);

Line 1802: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api3.getAvailableInsertions returns ' || fnd_global.newline || get_insertion_list_string(l_available_insertion_list));

1798: positionIn => p_position,
1799: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1800: availableInsertionsOut => l_available_insertion_list);
1801:
1802: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api3.getAvailableInsertions returns ' || fnd_global.newline || get_insertion_list_string(l_available_insertion_list));
1803:
1804: -- select an absolute-order, after-approver, before-approver insertion in the list of available insertions
1805: -- that corresponds to the api insertion and authority value of the approver to be inserted into the approver list
1806:

Line 1840: 'calling ame_api3.insertApprover with approver insertion ' || fnd_global.newline || get_insertion_string(l_approver, l_insertion_order) || ' at position ' || p_position);

1836: log_string(
1837: l_statement_log_level,
1838: l_current_log_level,
1839: l_module_name,
1840: 'calling ame_api3.insertApprover with approver insertion ' || fnd_global.newline || get_insertion_string(l_approver, l_insertion_order) || ' at position ' || p_position);
1841:
1842: ame_api3.insertApprover( applicationIdIn => APPLICATION_ID,
1843: transactionIdIn => p_transaction_id,
1844: approverIn => l_approver,

Line 1856: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));

1852: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1853: approvalProcessCompleteYNOut => l_process_out,
1854: approversOut => l_approver_list);
1855:
1856: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));
1857:
1858: p_approver_list_string := format_ame_approver_list(l_approver_list);
1859:
1860: p_error_message := NULL;

Line 1911: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api3.suppressApprover with ' || fnd_global.newline || format_ame_approver(l_approver));

1907:
1908: parse_ame_approver( p_approver_string, l_approver );
1909:
1910: -- delete approver from approver list
1911: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api3.suppressApprover with ' || fnd_global.newline || format_ame_approver(l_approver));
1912:
1913: ame_api3.suppressApprover(applicationIdIn => APPLICATION_ID,
1914: transactionIdIn => p_transaction_id,
1915: approverIn => l_approver,

Line 1925: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));

1921: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1922: approvalProcessCompleteYNOut => l_process_out,
1923: approversOut => l_approver_list);
1924:
1925: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));
1926:
1927: p_approver_list_string := format_ame_approver_list( l_approver_list);
1928:
1929: p_error_message := NULL;

Line 2046: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.setFirstAuthorityApprover with ' || fnd_global.newline || format_ame_approver(l_approver));

2042: l_approver.action_type_id := l_current_first_approver.action_type_id ;
2043: l_approver.group_or_chain_id := l_current_first_approver.group_or_chain_id ;
2044:
2045: -- set first authority approver
2046: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.setFirstAuthorityApprover with ' || fnd_global.newline || format_ame_approver(l_approver));
2047:
2048: SELECT name into l_approver.name FROM wf_roles
2049: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
2050:

Line 2069: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));

2065: transactionTypeIn => AWARD_TRANSACTION_TYPE,
2066: approvalProcessCompleteYNOut => l_process_out,
2067: approversOut => l_approver_list);
2068:
2069: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));
2070:
2071: p_approver_list_string := format_ame_approver_list( l_approver_list);
2072:
2073: p_error_message := NULL;

Line 2136: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));

2132: transactionTypeIn => AWARD_TRANSACTION_TYPE,
2133: approvalProcessCompleteYNOut => l_process_out,
2134: approversOut => l_approver_list);
2135:
2136: log_string(l_statement_log_level, l_current_log_level, l_module_name, 'calling ame_api2.getAllApprovers7 returns ' || fnd_global.newline || format_ame_approver_list(l_approver_list));
2137:
2138: p_approver_list_string := format_ame_approver_list(l_approver_list);
2139:
2140: -- determine whether OAM-generated approvers can be deleted

Line 3141: l_insertion_list_string := l_insertion_list_string || fnd_global.newline;

3137: get_order_type_string(p_insertion_list(i).order_type) || ', ' ||
3138: get_parameter_string(p_insertion_list(i).parameter) || ')';
3139:
3140: IF i < p_insertion_list.COUNT THEN
3141: l_insertion_list_string := l_insertion_list_string || fnd_global.newline;
3142: END IF;
3143:
3144: END LOOP;
3145:

Line 3343: --RETURN(fnd_global.local_chr(ascii_chr => 11));

3339:
3340:
3341: FUNCTION getAMEFieldDelimiter return VARCHAR2 as
3342: BEGIN
3343: --RETURN(fnd_global.local_chr(ascii_chr => 11));
3344: RETURN(fnd_global.local_chr(ascii_chr => 10));
3345: END getAMEFieldDelimiter;
3346:
3347: FUNCTION getAMERecordDelimiter return VARCHAR2 as

Line 3344: RETURN(fnd_global.local_chr(ascii_chr => 10));

3340:
3341: FUNCTION getAMEFieldDelimiter return VARCHAR2 as
3342: BEGIN
3343: --RETURN(fnd_global.local_chr(ascii_chr => 11));
3344: RETURN(fnd_global.local_chr(ascii_chr => 10));
3345: END getAMEFieldDelimiter;
3346:
3347: FUNCTION getAMERecordDelimiter return VARCHAR2 as
3348: BEGIN

Line 3349: --RETURN(fnd_global.local_chr(ascii_chr => 12));

3345: END getAMEFieldDelimiter;
3346:
3347: FUNCTION getAMERecordDelimiter return VARCHAR2 as
3348: BEGIN
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;

Line 3350: RETURN(fnd_global.local_chr(ascii_chr => 13));

3346:
3347: FUNCTION getAMERecordDelimiter return VARCHAR2 as
3348: BEGIN
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;