2168: * See bug 4945922.
2169: */
2170: print_debuginfo(l_module_name, 'Setting apps context .. ');
2171:
2172: fnd_global.APPS_INITIALIZE(
2173: user_id => fnd_global.user_id,
2174: resp_id => fnd_global.resp_id,
2175: resp_appl_id => fnd_global.resp_appl_id
2176: );
2169: */
2170: print_debuginfo(l_module_name, 'Setting apps context .. ');
2171:
2172: fnd_global.APPS_INITIALIZE(
2173: user_id => fnd_global.user_id,
2174: resp_id => fnd_global.resp_id,
2175: resp_appl_id => fnd_global.resp_appl_id
2176: );
2177:
2170: print_debuginfo(l_module_name, 'Setting apps context .. ');
2171:
2172: fnd_global.APPS_INITIALIZE(
2173: user_id => fnd_global.user_id,
2174: resp_id => fnd_global.resp_id,
2175: resp_appl_id => fnd_global.resp_appl_id
2176: );
2177:
2178: mo_global.init(fnd_global.application_short_name);
2171:
2172: fnd_global.APPS_INITIALIZE(
2173: user_id => fnd_global.user_id,
2174: resp_id => fnd_global.resp_id,
2175: resp_appl_id => fnd_global.resp_appl_id
2176: );
2177:
2178: mo_global.init(fnd_global.application_short_name);
2179:
2174: resp_id => fnd_global.resp_id,
2175: resp_appl_id => fnd_global.resp_appl_id
2176: );
2177:
2178: mo_global.init(fnd_global.application_short_name);
2179:
2180: print_debuginfo(l_module_name, 'Apps context set [user: '
2181: || fnd_global.user_id
2182: || ', responsbility id: '
2177:
2178: mo_global.init(fnd_global.application_short_name);
2179:
2180: print_debuginfo(l_module_name, 'Apps context set [user: '
2181: || fnd_global.user_id
2182: || ', responsbility id: '
2183: || fnd_global.resp_id
2184: || ', responsibility application id: '
2185: || fnd_global.resp_appl_id
2179:
2180: print_debuginfo(l_module_name, 'Apps context set [user: '
2181: || fnd_global.user_id
2182: || ', responsbility id: '
2183: || fnd_global.resp_id
2184: || ', responsibility application id: '
2185: || fnd_global.resp_appl_id
2186: || ']'
2187: );
2181: || fnd_global.user_id
2182: || ', responsbility id: '
2183: || fnd_global.resp_id
2184: || ', responsibility application id: '
2185: || fnd_global.resp_appl_id
2186: || ']'
2187: );
2188:
2189: print_debuginfo(l_module_name, 'Apps context [app short name: '
2186: || ']'
2187: );
2188:
2189: print_debuginfo(l_module_name, 'Apps context [app short name: '
2190: || fnd_global.application_short_name
2191: || ']'
2192: );
2193:
2194: /*--- RYAN TEST CODE ---*/
5432: p_pmt_doc_id,
5433: p_old_ppr_docs_list(i),
5434: sysdate,
5435: DOC_USE_SPOILED,
5436: fnd_global.user_id,
5437: sysdate,
5438: fnd_global.user_id,
5439: sysdate,
5440: fnd_global.login_id,
5434: sysdate,
5435: DOC_USE_SPOILED,
5436: fnd_global.user_id,
5437: sysdate,
5438: fnd_global.user_id,
5439: sysdate,
5440: fnd_global.login_id,
5441: 1
5442: );
5436: fnd_global.user_id,
5437: sysdate,
5438: fnd_global.user_id,
5439: sysdate,
5440: fnd_global.login_id,
5441: 1
5442: );
5443:
5444: END LOOP;
6299: p_pmt_doc_id,
6300: p_used_docs_list(i),
6301: sysdate,
6302: DOC_USE_SPOILED,
6303: fnd_global.user_id,
6304: sysdate,
6305: fnd_global.user_id,
6306: sysdate,
6307: fnd_global.login_id,
6301: sysdate,
6302: DOC_USE_SPOILED,
6303: fnd_global.user_id,
6304: sysdate,
6305: fnd_global.user_id,
6306: sysdate,
6307: fnd_global.login_id,
6308: 1
6309: );
6303: fnd_global.user_id,
6304: sysdate,
6305: fnd_global.user_id,
6306: sysdate,
6307: fnd_global.login_id,
6308: 1
6309: );
6310:
6311: END LOOP;
6807: p_pmt_doc_id,
6808: p_used_docs_list(i),
6809: sysdate,
6810: decode(l_payment_status_list(i),'REMOVED_DOCUMENT_SPOILED','SPOILED','ISSUED'),
6811: fnd_global.user_id,
6812: sysdate,
6813: fnd_global.user_id,
6814: sysdate,
6815: fnd_global.login_id,
6809: sysdate,
6810: decode(l_payment_status_list(i),'REMOVED_DOCUMENT_SPOILED','SPOILED','ISSUED'),
6811: fnd_global.user_id,
6812: sysdate,
6813: fnd_global.user_id,
6814: sysdate,
6815: fnd_global.login_id,
6816: 1
6817: );
6811: fnd_global.user_id,
6812: sysdate,
6813: fnd_global.user_id,
6814: sysdate,
6815: fnd_global.login_id,
6816: 1
6817: );
6818:
6819: print_debuginfo(l_module_name, 'Document number not found, inserting new');
6889: p_pmt_doc_id,
6890: i,
6891: sysdate,
6892: 'SKIPPED',
6893: fnd_global.user_id,
6894: sysdate,
6895: fnd_global.user_id,
6896: sysdate,
6897: fnd_global.login_id,
6891: sysdate,
6892: 'SKIPPED',
6893: fnd_global.user_id,
6894: sysdate,
6895: fnd_global.user_id,
6896: sysdate,
6897: fnd_global.login_id,
6898: 1
6899: );
6893: fnd_global.user_id,
6894: sysdate,
6895: fnd_global.user_id,
6896: sysdate,
6897: fnd_global.login_id,
6898: 1
6899: );
6900: END;
6901: END IF;
7453: l_pmt_doc_id,
7454: l_pmtDocsTab(i),
7455: sysdate,
7456: DOC_USE_ISSUED,
7457: fnd_global.user_id,
7458: sysdate,
7459: fnd_global.user_id,
7460: sysdate,
7461: fnd_global.login_id,
7455: sysdate,
7456: DOC_USE_ISSUED,
7457: fnd_global.user_id,
7458: sysdate,
7459: fnd_global.user_id,
7460: sysdate,
7461: fnd_global.login_id,
7462: 1
7463: );
7457: fnd_global.user_id,
7458: sysdate,
7459: fnd_global.user_id,
7460: sysdate,
7461: fnd_global.login_id,
7462: 1
7463: );
7464:
7465: print_debuginfo(l_module_name, 'Document number not found, inserting new');
9625: p_object_id, /* 1 */
9626: p_object_type,
9627: p_conc_request_id,
9628: p_completed_flag,
9629: fnd_global.user_id, /* 5 */
9630: sysdate,
9631: fnd_global.user_id,
9632: sysdate,
9633: fnd_global.login_id,
9627: p_conc_request_id,
9628: p_completed_flag,
9629: fnd_global.user_id, /* 5 */
9630: sysdate,
9631: fnd_global.user_id,
9632: sysdate,
9633: fnd_global.login_id,
9634: 1 /* 10 */
9635: )
9629: fnd_global.user_id, /* 5 */
9630: sysdate,
9631: fnd_global.user_id,
9632: sysdate,
9633: fnd_global.login_id,
9634: 1 /* 10 */
9635: )
9636: ;
9637:
9692: | PAYMENT_INSTRUCTION
9693: |
9694: | p_conc_request_id The concurrent request id to stamp the payment
9695: | entity with. If NULL is provided, the value of
9696: | FND_GLOBAL.CONC_REQUEST_ID will be used.
9697: |
9698: | OUT
9699: | x_return_status Return status (S, E, U)
9700: |
9742: print_debuginfo(l_module_name, 'Concurrent request id not '
9743: || 'provided. Deriving from context ..'
9744: );
9745:
9746: l_conc_request_id := FND_GLOBAL.conc_request_id;
9747:
9748: ELSE
9749:
9750: print_debuginfo(l_module_name, 'Concurrent request id '
10079: null,
10080: null,
10081: null,
10082: null,
10083: fnd_global.user_name);
10084:
10085: if(l_bool) then
10086: --print_debuginfo(l_module_name, 'User has access to:' || l_func);
10087: insert into IBY_USER_PAY_FUNS_GT(payment_function)