4290: INTO l_distribution_id_tbl;
4291:
4292: CLOSE l_changed_po_dists_csr;
4293:
4294: po_document_funds_grp.populate_encumbrance_gt(
4295: p_api_version => 1.0,
4296: x_return_status => x_return_status,
4297: p_doc_type => po_document_funds_grp.g_doc_type_po,
4298: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4293:
4294: po_document_funds_grp.populate_encumbrance_gt(
4295: p_api_version => 1.0,
4296: x_return_status => x_return_status,
4297: p_doc_type => po_document_funds_grp.g_doc_type_po,
4298: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4299: p_doc_level_id_tbl => l_distribution_id_tbl,
4300: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4301: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4294: po_document_funds_grp.populate_encumbrance_gt(
4295: p_api_version => 1.0,
4296: x_return_status => x_return_status,
4297: p_doc_type => po_document_funds_grp.g_doc_type_po,
4298: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4299: p_doc_level_id_tbl => l_distribution_id_tbl,
4300: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4301: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4302: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4296: x_return_status => x_return_status,
4297: p_doc_type => po_document_funds_grp.g_doc_type_po,
4298: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4299: p_doc_level_id_tbl => l_distribution_id_tbl,
4300: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4301: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4302: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4303:
4304: -- error handling after calling populate_encumbrance_gt
4297: p_doc_type => po_document_funds_grp.g_doc_type_po,
4298: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4299: p_doc_level_id_tbl => l_distribution_id_tbl,
4300: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4301: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4302: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4303:
4304: -- error handling after calling populate_encumbrance_gt
4305: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
4298: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4299: p_doc_level_id_tbl => l_distribution_id_tbl,
4300: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4301: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4302: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4303:
4304: -- error handling after calling populate_encumbrance_gt
4305: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
4306: x_retmsg := 'After calling populate_encumbrance_gt';
4320: INTO l_distribution_id_tbl;
4321:
4322: CLOSE l_changed_rel_dists_csr;
4323:
4324: po_document_funds_grp.populate_encumbrance_gt(
4325: p_api_version => 1.0,
4326: x_return_status => x_return_status,
4327: p_doc_type => po_document_funds_grp.g_doc_type_release,
4328: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4323:
4324: po_document_funds_grp.populate_encumbrance_gt(
4325: p_api_version => 1.0,
4326: x_return_status => x_return_status,
4327: p_doc_type => po_document_funds_grp.g_doc_type_release,
4328: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4329: p_doc_level_id_tbl => l_distribution_id_tbl,
4330: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4331: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4324: po_document_funds_grp.populate_encumbrance_gt(
4325: p_api_version => 1.0,
4326: x_return_status => x_return_status,
4327: p_doc_type => po_document_funds_grp.g_doc_type_release,
4328: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4329: p_doc_level_id_tbl => l_distribution_id_tbl,
4330: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4331: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4332: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4326: x_return_status => x_return_status,
4327: p_doc_type => po_document_funds_grp.g_doc_type_release,
4328: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4329: p_doc_level_id_tbl => l_distribution_id_tbl,
4330: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4331: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4332: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4333:
4334: -- error handling after calling populate_encumbrance_gt
4327: p_doc_type => po_document_funds_grp.g_doc_type_release,
4328: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4329: p_doc_level_id_tbl => l_distribution_id_tbl,
4330: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4331: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4332: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4333:
4334: -- error handling after calling populate_encumbrance_gt
4335: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
4328: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4329: p_doc_level_id_tbl => l_distribution_id_tbl,
4330: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4331: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4332: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4333:
4334: -- error handling after calling populate_encumbrance_gt
4335: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
4336: x_retmsg := 'After calling populate_encumbrance_gt (release)';
4502: price = l_new_price,
4503: nonrecoverable_tax = l_new_tax
4504: WHERE
4505: distribution_id = l_distribution_id AND
4506: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
4507:
4508: END LOOP;
4509: CLOSE l_dist_qty_price_chn_csr;
4510:
4511:
4512: x_retmsg := 'SMRCH0032';
4513: --Execute PO Funds Check API
4514:
4515: po_document_funds_grp.check_adjust(
4516: p_api_version => 1.0,
4517: x_return_status => l_fc_result_status,
4518: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4519: p_doc_subtype => NULL,
4514:
4515: po_document_funds_grp.check_adjust(
4516: p_api_version => 1.0,
4517: x_return_status => l_fc_result_status,
4518: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4519: p_doc_subtype => NULL,
4520: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4521: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4522: p_override_date => SYSDATE,
4516: p_api_version => 1.0,
4517: x_return_status => l_fc_result_status,
4518: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4519: p_doc_subtype => NULL,
4520: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4521: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4522: p_override_date => SYSDATE,
4523: p_report_successes => po_document_funds_grp.g_parameter_no,
4524: x_po_return_code => l_po_return_code,
4517: x_return_status => l_fc_result_status,
4518: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4519: p_doc_subtype => NULL,
4520: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4521: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4522: p_override_date => SYSDATE,
4523: p_report_successes => po_document_funds_grp.g_parameter_no,
4524: x_po_return_code => l_po_return_code,
4525: x_detailed_results => l_fc_out_tbl);
4519: p_doc_subtype => NULL,
4520: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4521: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4522: p_override_date => SYSDATE,
4523: p_report_successes => po_document_funds_grp.g_parameter_no,
4524: x_po_return_code => l_po_return_code,
4525: x_detailed_results => l_fc_out_tbl);
4526:
4527: x_retmsg := 'SMRCH004';
4540: RETURN;
4541:
4542: ELSE
4543:
4544: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
4545: x_return_status := fnd_api.g_ret_sts_success;
4546:
4547: ELSE -- there can be warning/error message for other cases
4548:
6426: INTO l_distribution_id_tbl;
6427:
6428: CLOSE l_changed_req_dists_csr;
6429:
6430: po_document_funds_grp.populate_encumbrance_gt(
6431: p_api_version => 1.0,
6432: x_return_status => x_return_status,
6433: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6429:
6430: po_document_funds_grp.populate_encumbrance_gt(
6431: p_api_version => 1.0,
6432: x_return_status => x_return_status,
6433: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6435: p_doc_level_id_tbl => l_distribution_id_tbl,
6436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6430: po_document_funds_grp.populate_encumbrance_gt(
6431: p_api_version => 1.0,
6432: x_return_status => x_return_status,
6433: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6435: p_doc_level_id_tbl => l_distribution_id_tbl,
6436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6438: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
6432: x_return_status => x_return_status,
6433: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6435: p_doc_level_id_tbl => l_distribution_id_tbl,
6436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6438: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
6439:
6440: -- error handling after calling populate_encumbrance_gt
6433: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6435: p_doc_level_id_tbl => l_distribution_id_tbl,
6436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6438: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
6439:
6440: -- error handling after calling populate_encumbrance_gt
6441: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
6434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6435: p_doc_level_id_tbl => l_distribution_id_tbl,
6436: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6438: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
6439:
6440: -- error handling after calling populate_encumbrance_gt
6441: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
6442: x_retmsg := 'After calling populate_encumbrance_gt';
6502: price = l_new_price,
6503: nonrecoverable_tax = l_new_tax
6504: WHERE
6505: distribution_id = l_distribution_id AND
6506: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
6507:
6508: END LOOP;
6509: CLOSE l_dist_tax_csr;
6510:
6511:
6512: x_retmsg := 'SMRCH0032';
6513: --Execute PO Funds Check API
6514:
6515: po_document_funds_grp.check_adjust(
6516: p_api_version => 1.0,
6517: x_return_status => l_fc_result_status,
6518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6519: p_doc_subtype => NULL,
6514:
6515: po_document_funds_grp.check_adjust(
6516: p_api_version => 1.0,
6517: x_return_status => l_fc_result_status,
6518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6519: p_doc_subtype => NULL,
6520: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6521: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6522: p_override_date => sysdate,
6516: p_api_version => 1.0,
6517: x_return_status => l_fc_result_status,
6518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6519: p_doc_subtype => NULL,
6520: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6521: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6522: p_override_date => sysdate,
6523: p_report_successes => po_document_funds_grp.g_parameter_NO,
6524: x_po_return_code => l_po_return_code,
6517: x_return_status => l_fc_result_status,
6518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6519: p_doc_subtype => NULL,
6520: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6521: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6522: p_override_date => sysdate,
6523: p_report_successes => po_document_funds_grp.g_parameter_NO,
6524: x_po_return_code => l_po_return_code,
6525: x_detailed_results => l_fc_out_tbl);
6519: p_doc_subtype => NULL,
6520: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6521: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6522: p_override_date => sysdate,
6523: p_report_successes => po_document_funds_grp.g_parameter_NO,
6524: x_po_return_code => l_po_return_code,
6525: x_detailed_results => l_fc_out_tbl);
6526:
6527: x_retMsg := 'SMRCH004';
6544: po_debug.debug_STmt(l_log_head, x_retmsg, 'after check adjust of funds check');
6545: END IF;
6546:
6547:
6548: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
6549: x_return_status := fnd_api.g_ret_sts_success;
6550:
6551: ELSE -- there can be warning/error message for other cases
6552: