DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_DOCUMENT_FUNDS_GRP

Line 12561: po_document_funds_grp.populate_encumbrance_gt(

12557:
12558: CLOSE l_changed_req_dists_csr;
12559: l_progress := '004';
12560:
12561: po_document_funds_grp.populate_encumbrance_gt(
12562: p_api_version => 1.0,
12563: x_return_status => l_return_status,
12564: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
12565: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

Line 12564: p_doc_type => po_document_funds_grp.g_doc_type_requisition,

12560:
12561: po_document_funds_grp.populate_encumbrance_gt(
12562: p_api_version => 1.0,
12563: x_return_status => l_return_status,
12564: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
12565: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
12566: p_doc_level_id_tbl => l_distribution_id_tbl,
12567: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
12568: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

Line 12565: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

12561: po_document_funds_grp.populate_encumbrance_gt(
12562: p_api_version => 1.0,
12563: x_return_status => l_return_status,
12564: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
12565: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
12566: p_doc_level_id_tbl => l_distribution_id_tbl,
12567: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
12568: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
12569: p_check_only_flag => po_document_funds_grp.g_parameter_NO);

Line 12567: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,

12563: x_return_status => l_return_status,
12564: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
12565: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
12566: p_doc_level_id_tbl => l_distribution_id_tbl,
12567: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
12568: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
12569: p_check_only_flag => po_document_funds_grp.g_parameter_NO);
12570:
12571: l_progress := '005';

Line 12568: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

12564: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
12565: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
12566: p_doc_level_id_tbl => l_distribution_id_tbl,
12567: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
12568: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
12569: p_check_only_flag => po_document_funds_grp.g_parameter_NO);
12570:
12571: l_progress := '005';
12572:

Line 12569: p_check_only_flag => po_document_funds_grp.g_parameter_NO);

12565: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
12566: p_doc_level_id_tbl => l_distribution_id_tbl,
12567: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
12568: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
12569: p_check_only_flag => po_document_funds_grp.g_parameter_NO);
12570:
12571: l_progress := '005';
12572:
12573: -- error handling after calling populate_encumbrance_gt

Line 12633: adjustment_status = po_document_funds_grp.g_adjustment_status_new;

12629: price = l_new_price,
12630: nonrecoverable_tax = l_new_tax
12631: WHERE
12632: distribution_id = l_req_dist_id AND
12633: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
12634:
12635: l_progress := '009';
12636: IF g_debug_stmt THEN
12637: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');

Line 12649: po_document_funds_grp.do_adjust(

12645:
12646: l_progress := '010';
12647: --Execute PO Funds Check API
12648:
12649: po_document_funds_grp.do_adjust(
12650: p_api_version => 1.0,
12651: x_return_status => l_fc_result_status,
12652: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
12653: p_doc_subtype => NULL,

Line 12652: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,

12648:
12649: po_document_funds_grp.do_adjust(
12650: p_api_version => 1.0,
12651: x_return_status => l_fc_result_status,
12652: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
12653: p_doc_subtype => NULL,
12654: p_employee_id => l_preparer_id,
12655: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
12656: p_use_gl_date => po_document_funds_grp.g_parameter_YES,

Line 12655: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,

12651: x_return_status => l_fc_result_status,
12652: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
12653: p_doc_subtype => NULL,
12654: p_employee_id => l_preparer_id,
12655: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
12656: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
12657: p_override_date => sysdate,
12658: p_report_successes => po_document_funds_grp.g_parameter_NO,
12659: x_po_return_code => l_po_return_code,

Line 12656: p_use_gl_date => po_document_funds_grp.g_parameter_YES,

12652: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
12653: p_doc_subtype => NULL,
12654: p_employee_id => l_preparer_id,
12655: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
12656: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
12657: p_override_date => sysdate,
12658: p_report_successes => po_document_funds_grp.g_parameter_NO,
12659: x_po_return_code => l_po_return_code,
12660: x_detailed_results => l_fc_out_tbl);

Line 12658: p_report_successes => po_document_funds_grp.g_parameter_NO,

12654: p_employee_id => l_preparer_id,
12655: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
12656: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
12657: p_override_date => sysdate,
12658: p_report_successes => po_document_funds_grp.g_parameter_NO,
12659: x_po_return_code => l_po_return_code,
12660: x_detailed_results => l_fc_out_tbl);
12661:
12662: l_progress := '011';

Line 12681: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN

12677: IF g_debug_stmt THEN
12678: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');
12679: END IF;
12680:
12681: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
12682: x_return_status := fnd_api.g_ret_sts_success;
12683: ELSE
12684: x_return_status := fnd_api.g_ret_sts_error;
12685: RAISE fnd_api.g_exc_unexpected_error;

Line 12936: PO_DOCUMENT_FUNDS_GRP.do_cancel(

12932: x_progress := '012';
12933:
12934: -- cancel the encumbered funds
12935:
12936: PO_DOCUMENT_FUNDS_GRP.do_cancel(
12937: p_api_version => 1.0
12938: , p_commit => fnd_api.g_true
12939: , p_init_msg_list => fnd_api.g_false
12940: , p_validation_level=> FND_API.G_VALID_LEVEL_FULL

Line 12946: , p_override_funds =>PO_DOCUMENT_FUNDS_GRP.g_parameter_USE_PROFILE

12942: , p_doc_type =>PO_CORE_S.g_doc_type_REQUISITION
12943: , p_doc_subtype =>null
12944: , p_doc_level =>'LINE'
12945: , p_doc_level_id => p_req_line_id
12946: , p_override_funds =>PO_DOCUMENT_FUNDS_GRP.g_parameter_USE_PROFILE
12947: , p_use_gl_date => PO_DOCUMENT_FUNDS_GRP.g_parameter_YES
12948: , p_override_date => SYSDATE
12949: , p_report_successes => PO_DOCUMENT_FUNDS_GRP.g_parameter_NO
12950: , x_po_return_code => l_po_return_code

Line 12947: , p_use_gl_date => PO_DOCUMENT_FUNDS_GRP.g_parameter_YES

12943: , p_doc_subtype =>null
12944: , p_doc_level =>'LINE'
12945: , p_doc_level_id => p_req_line_id
12946: , p_override_funds =>PO_DOCUMENT_FUNDS_GRP.g_parameter_USE_PROFILE
12947: , p_use_gl_date => PO_DOCUMENT_FUNDS_GRP.g_parameter_YES
12948: , p_override_date => SYSDATE
12949: , p_report_successes => PO_DOCUMENT_FUNDS_GRP.g_parameter_NO
12950: , x_po_return_code => l_po_return_code
12951: , x_detailed_results=> L_detailed_results

Line 12949: , p_report_successes => PO_DOCUMENT_FUNDS_GRP.g_parameter_NO

12945: , p_doc_level_id => p_req_line_id
12946: , p_override_funds =>PO_DOCUMENT_FUNDS_GRP.g_parameter_USE_PROFILE
12947: , p_use_gl_date => PO_DOCUMENT_FUNDS_GRP.g_parameter_YES
12948: , p_override_date => SYSDATE
12949: , p_report_successes => PO_DOCUMENT_FUNDS_GRP.g_parameter_NO
12950: , x_po_return_code => l_po_return_code
12951: , x_detailed_results=> L_detailed_results
12952: );
12953:

Line 13430: po_document_funds_grp.populate_encumbrance_gt(

13426:
13427: CLOSE l_changed_req_dists_csr;
13428: l_progress := '004';
13429:
13430: po_document_funds_grp.populate_encumbrance_gt(
13431: p_api_version => 1.0,
13432: x_return_status => l_return_status,
13433: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
13434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

Line 13433: p_doc_type => po_document_funds_grp.g_doc_type_requisition,

13429:
13430: po_document_funds_grp.populate_encumbrance_gt(
13431: p_api_version => 1.0,
13432: x_return_status => l_return_status,
13433: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
13434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
13435: p_doc_level_id_tbl => l_distribution_id_tbl,
13436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
13437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

Line 13434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

13430: po_document_funds_grp.populate_encumbrance_gt(
13431: p_api_version => 1.0,
13432: x_return_status => l_return_status,
13433: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
13434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
13435: p_doc_level_id_tbl => l_distribution_id_tbl,
13436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
13437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
13438: p_check_only_flag => po_document_funds_grp.g_parameter_NO);

Line 13436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,

13432: x_return_status => l_return_status,
13433: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
13434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
13435: p_doc_level_id_tbl => l_distribution_id_tbl,
13436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
13437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
13438: p_check_only_flag => po_document_funds_grp.g_parameter_NO);
13439:
13440: l_progress := '005';

Line 13437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

13433: p_doc_type => po_document_funds_grp.g_doc_type_requisition,
13434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
13435: p_doc_level_id_tbl => l_distribution_id_tbl,
13436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
13437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
13438: p_check_only_flag => po_document_funds_grp.g_parameter_NO);
13439:
13440: l_progress := '005';
13441:

Line 13438: p_check_only_flag => po_document_funds_grp.g_parameter_NO);

13434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
13435: p_doc_level_id_tbl => l_distribution_id_tbl,
13436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
13437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
13438: p_check_only_flag => po_document_funds_grp.g_parameter_NO);
13439:
13440: l_progress := '005';
13441:
13442: -- error handling after calling populate_encumbrance_gt

Line 13501: adjustment_status = po_document_funds_grp.g_adjustment_status_new;

13497: price = l_new_price,
13498: nonrecoverable_tax = l_new_tax
13499: WHERE
13500: distribution_id = l_req_dist_id AND
13501: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
13502:
13503: l_progress := '009';
13504: IF g_debug_stmt THEN
13505: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');

Line 13515: po_document_funds_grp.do_adjust(

13511:
13512: l_progress := '010';
13513: --Execute PO Funds Check API
13514:
13515: po_document_funds_grp.do_adjust(
13516: p_api_version => 1.0,
13517: x_return_status => l_fc_result_status,
13518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
13519: p_doc_subtype => NULL,

Line 13518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,

13514:
13515: po_document_funds_grp.do_adjust(
13516: p_api_version => 1.0,
13517: x_return_status => l_fc_result_status,
13518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
13519: p_doc_subtype => NULL,
13520: p_employee_id => l_preparer_id,
13521: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
13522: p_use_gl_date => po_document_funds_grp.g_parameter_YES,

Line 13521: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,

13517: x_return_status => l_fc_result_status,
13518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
13519: p_doc_subtype => NULL,
13520: p_employee_id => l_preparer_id,
13521: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
13522: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
13523: p_override_date => sysdate,
13524: p_report_successes => po_document_funds_grp.g_parameter_NO,
13525: x_po_return_code => l_po_return_code,

Line 13522: p_use_gl_date => po_document_funds_grp.g_parameter_YES,

13518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
13519: p_doc_subtype => NULL,
13520: p_employee_id => l_preparer_id,
13521: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
13522: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
13523: p_override_date => sysdate,
13524: p_report_successes => po_document_funds_grp.g_parameter_NO,
13525: x_po_return_code => l_po_return_code,
13526: x_detailed_results => l_fc_out_tbl);

Line 13524: p_report_successes => po_document_funds_grp.g_parameter_NO,

13520: p_employee_id => l_preparer_id,
13521: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
13522: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
13523: p_override_date => sysdate,
13524: p_report_successes => po_document_funds_grp.g_parameter_NO,
13525: x_po_return_code => l_po_return_code,
13526: x_detailed_results => l_fc_out_tbl);
13527:
13528: l_progress := '011';

Line 13547: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN

13543: IF g_debug_stmt THEN
13544: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');
13545: END IF;
13546:
13547: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
13548: x_return_status := fnd_api.g_ret_sts_success;
13549: ELSE
13550: x_return_status := fnd_api.g_ret_sts_error;
13551: RAISE fnd_api.g_exc_unexpected_error;