DBA Data[Home] [Help]

APPS.PON_AWARD_APPROVAL_PKG dependencies on FND_GLOBAL

Line 383: avalue => fnd_global.RESP_ID);

379: --bug 9555176
380: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
381: itemkey => p_item_key,
382: aname => 'PREPARER_RESP_ID',
383: avalue => fnd_global.RESP_ID);
384:
385: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
386: itemkey => p_item_key,
387: aname => 'PREPARER_APPL_ID',

Line 388: avalue => fnd_global.RESP_APPL_ID);

384:
385: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
386: itemkey => p_item_key,
387: aname => 'PREPARER_APPL_ID',
388: avalue => fnd_global.RESP_APPL_ID);
389:
390: --9555176 End
391:
392:

Line 455: avalue => fnd_global.user_name);

451:
452: wf_engine.SetItemAttrText(itemtype => p_item_type,
453: itemkey => p_item_key,
454: aname => 'ORIGIN_USER_NAME',
455: avalue => fnd_global.user_name);
456:
457: END set_core_attributes;
458:
459: /*

Line 923: 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));

919: transactionTypeIn => AWARD_TRANSACTION_TYPE,
920: approvalProcessCompleteYNOut => l_process_out,
921: nextApproversOut => l_next_approver_list);
922:
923: 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));
924:
925: EXCEPTION
926: WHEN OTHERS THEN
927: resultout := 'OAM_API_ERROR';

Line 1222: 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));

1218: ame_api2.getAdminApprover(applicationIdIn => APPLICATION_ID,
1219: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1220: adminApproverOut => l_admin_approver);
1221:
1222: 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));
1223:
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: l_admin_approver := ame_util.emptyApproverRecord2;

Line 1420: fnd_global.apps_initialize(fnd_global.user_id, l_preparer_resp_id, l_preparer_appl_id);

1416: aname => 'PREPARER_APPL_ID');
1417:
1418: --Intialize the context of the approver as that of the preparer
1419:
1420: fnd_global.apps_initialize(fnd_global.user_id, l_preparer_resp_id, l_preparer_appl_id);
1421:
1422:
1423:
1424: --Bug 9555176 End

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

1726: -- update the approval status for the approver
1727: log_string(l_statement_log_level,
1728: l_current_log_level,
1729: l_module_name,
1730: 'calling ame_api2.updateApprovalStatus on workflow item key ' || itemkey || fnd_global.newline ||
1731: 'with approver' || fnd_global.newline || format_ame_approver(l_approver) || fnd_global.newline ||
1732: 'and forwardee' || fnd_global.newline || format_ame_approver(l_forwardee));
1733:
1734: ame_api2.updateApprovalStatus(applicationIdIn => APPLICATION_ID,

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

1727: log_string(l_statement_log_level,
1728: l_current_log_level,
1729: l_module_name,
1730: 'calling ame_api2.updateApprovalStatus on workflow item key ' || itemkey || fnd_global.newline ||
1731: 'with approver' || fnd_global.newline || format_ame_approver(l_approver) || fnd_global.newline ||
1732: 'and forwardee' || fnd_global.newline || format_ame_approver(l_forwardee));
1733:
1734: ame_api2.updateApprovalStatus(applicationIdIn => APPLICATION_ID,
1735: transactionIdIn => l_transaction_id,

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

1728: l_current_log_level,
1729: l_module_name,
1730: 'calling ame_api2.updateApprovalStatus on workflow item key ' || itemkey || fnd_global.newline ||
1731: 'with approver' || fnd_global.newline || format_ame_approver(l_approver) || fnd_global.newline ||
1732: 'and forwardee' || fnd_global.newline || format_ame_approver(l_forwardee));
1733:
1734: ame_api2.updateApprovalStatus(applicationIdIn => APPLICATION_ID,
1735: transactionIdIn => l_transaction_id,
1736: approverIn => l_approver,

Line 1787: owner => fnd_global.user_name);

1783:
1784: -- Bug 4295915: Set the workflow owner
1785: wf_engine.SetItemOwner(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1786: itemkey => p_item_key,
1787: owner => fnd_global.user_name);
1788:
1789: -- start workflow process
1790: wf_engine.StartProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1791: itemkey => p_item_key);

Line 1837: 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));

1833: positionIn => p_position,
1834: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1835: availableInsertionsOut => l_available_insertion_list);
1836:
1837: 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));
1838:
1839: -- select an absolute-order, after-approver, before-approver insertion in the list of available insertions
1840: -- that corresponds to the api insertion and authority value of the approver to be inserted into the approver list
1841:

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

1871: log_string(
1872: l_statement_log_level,
1873: l_current_log_level,
1874: l_module_name,
1875: 'calling ame_api3.insertApprover with approver insertion ' || fnd_global.newline || get_insertion_string(l_approver, l_insertion_order) || ' at position ' || p_position);
1876:
1877: ame_api3.insertApprover( applicationIdIn => APPLICATION_ID,
1878: transactionIdIn => p_transaction_id,
1879: approverIn => l_approver,

Line 1891: 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));

1887: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1888: approvalProcessCompleteYNOut => l_process_out,
1889: approversOut => l_approver_list);
1890:
1891: 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));
1892:
1893: p_approver_list_string := format_ame_approver_list(l_approver_list);
1894:
1895: p_error_message := NULL;

Line 1946: 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));

1942:
1943: parse_ame_approver( p_approver_string, l_approver );
1944:
1945: -- delete approver from approver list
1946: 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));
1947:
1948: ame_api3.suppressApprover(applicationIdIn => APPLICATION_ID,
1949: transactionIdIn => p_transaction_id,
1950: approverIn => l_approver,

Line 1960: 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));

1956: transactionTypeIn => AWARD_TRANSACTION_TYPE,
1957: approvalProcessCompleteYNOut => l_process_out,
1958: approversOut => l_approver_list);
1959:
1960: 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));
1961:
1962: p_approver_list_string := format_ame_approver_list( l_approver_list);
1963:
1964: p_error_message := NULL;

Line 2081: 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));

2077: l_approver.action_type_id := l_current_first_approver.action_type_id ;
2078: l_approver.group_or_chain_id := l_current_first_approver.group_or_chain_id ;
2079:
2080: -- set first authority approver
2081: 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));
2082:
2083: SELECT name into l_approver.name FROM wf_roles
2084: WHERE orig_system = l_approver.orig_system and orig_system_id = l_approver.orig_system_id and rownum = 1;
2085:

Line 2104: 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));

2100: transactionTypeIn => AWARD_TRANSACTION_TYPE,
2101: approvalProcessCompleteYNOut => l_process_out,
2102: approversOut => l_approver_list);
2103:
2104: 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));
2105:
2106: p_approver_list_string := format_ame_approver_list( l_approver_list);
2107:
2108: p_error_message := NULL;

Line 2171: 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));

2167: transactionTypeIn => AWARD_TRANSACTION_TYPE,
2168: approvalProcessCompleteYNOut => l_process_out,
2169: approversOut => l_approver_list);
2170:
2171: 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));
2172:
2173: p_approver_list_string := format_ame_approver_list(l_approver_list);
2174:
2175: -- determine whether OAM-generated approvers can be deleted

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

3197: get_order_type_string(p_insertion_list(i).order_type) || ', ' ||
3198: get_parameter_string(p_insertion_list(i).parameter) || ')';
3199:
3200: IF i < p_insertion_list.COUNT THEN
3201: l_insertion_list_string := l_insertion_list_string || fnd_global.newline;
3202: END IF;
3203:
3204: END LOOP;
3205:

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

3399:
3400:
3401: FUNCTION getAMEFieldDelimiter return VARCHAR2 as
3402: BEGIN
3403: --RETURN(fnd_global.local_chr(ascii_chr => 11));
3404: RETURN(fnd_global.local_chr(ascii_chr => 10));
3405: END getAMEFieldDelimiter;
3406:
3407: FUNCTION getAMERecordDelimiter return VARCHAR2 as

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

3400:
3401: FUNCTION getAMEFieldDelimiter return VARCHAR2 as
3402: BEGIN
3403: --RETURN(fnd_global.local_chr(ascii_chr => 11));
3404: RETURN(fnd_global.local_chr(ascii_chr => 10));
3405: END getAMEFieldDelimiter;
3406:
3407: FUNCTION getAMERecordDelimiter return VARCHAR2 as
3408: BEGIN

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

3405: END getAMEFieldDelimiter;
3406:
3407: FUNCTION getAMERecordDelimiter return VARCHAR2 as
3408: BEGIN
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;

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

3406:
3407: FUNCTION getAMERecordDelimiter return VARCHAR2 as
3408: BEGIN
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;