DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_DOCUMENT_FUNDS_GRP

Line 4294: po_document_funds_grp.populate_encumbrance_gt(

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,

Line 4297: p_doc_type => po_document_funds_grp.g_doc_type_po,

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,

Line 4298: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

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);

Line 4300: p_make_old_copies_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

Line 4301: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

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

Line 4302: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

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';

Line 4324: po_document_funds_grp.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,

Line 4327: p_doc_type => po_document_funds_grp.g_doc_type_release,

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,

Line 4328: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

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);

Line 4330: p_make_old_copies_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

Line 4331: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

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

Line 4332: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

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)';

Line 4506: adjustment_status = po_document_funds_grp.g_adjustment_status_new;

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:

Line 4515: po_document_funds_grp.check_adjust(

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,

Line 4518: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,

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,

Line 4520: p_override_funds => po_document_funds_grp.g_parameter_use_profile,

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,

Line 4521: p_use_gl_date => po_document_funds_grp.g_parameter_yes,

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);

Line 4523: p_report_successes => po_document_funds_grp.g_parameter_no,

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';

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

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:

Line 6430: po_document_funds_grp.populate_encumbrance_gt(

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,

Line 6433: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level

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,

Line 6434: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

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);

Line 6436: p_make_old_copies_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

Line 6437: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

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

Line 6438: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

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';

Line 6506: adjustment_status = po_document_funds_grp.g_adjustment_status_new;

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:

Line 6515: po_document_funds_grp.check_adjust(

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,

Line 6518: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,

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,

Line 6520: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,

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,

Line 6521: p_use_gl_date => po_document_funds_grp.g_parameter_YES,

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);

Line 6523: p_report_successes => po_document_funds_grp.g_parameter_NO,

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';

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

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: