DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_DOCUMENT_FUNDS_GRP

Line 4377: po_document_funds_grp.populate_encumbrance_gt(

4373: INTO l_distribution_id_tbl;
4374:
4375: CLOSE l_changed_po_dists_csr;
4376:
4377: po_document_funds_grp.populate_encumbrance_gt(
4378: p_api_version => 1.0,
4379: x_return_status => x_return_status,
4380: p_doc_type => po_document_funds_grp.g_doc_type_po,
4381: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

Line 4380: p_doc_type => po_document_funds_grp.g_doc_type_po,

4376:
4377: po_document_funds_grp.populate_encumbrance_gt(
4378: p_api_version => 1.0,
4379: x_return_status => x_return_status,
4380: p_doc_type => po_document_funds_grp.g_doc_type_po,
4381: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4382: p_doc_level_id_tbl => l_distribution_id_tbl,
4383: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4384: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

Line 4381: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

4377: po_document_funds_grp.populate_encumbrance_gt(
4378: p_api_version => 1.0,
4379: x_return_status => x_return_status,
4380: p_doc_type => po_document_funds_grp.g_doc_type_po,
4381: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4382: p_doc_level_id_tbl => l_distribution_id_tbl,
4383: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4384: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4385: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

Line 4383: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,

4379: x_return_status => x_return_status,
4380: p_doc_type => po_document_funds_grp.g_doc_type_po,
4381: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4382: p_doc_level_id_tbl => l_distribution_id_tbl,
4383: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4384: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4385: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4386:
4387: -- error handling after calling populate_encumbrance_gt

Line 4384: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

4380: p_doc_type => po_document_funds_grp.g_doc_type_po,
4381: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4382: p_doc_level_id_tbl => l_distribution_id_tbl,
4383: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4384: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4385: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4386:
4387: -- error handling after calling populate_encumbrance_gt
4388: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

Line 4385: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

4381: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4382: p_doc_level_id_tbl => l_distribution_id_tbl,
4383: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4384: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4385: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4386:
4387: -- error handling after calling populate_encumbrance_gt
4388: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
4389: x_retmsg := 'After calling populate_encumbrance_gt';

Line 4407: po_document_funds_grp.populate_encumbrance_gt(

4403: INTO l_distribution_id_tbl;
4404:
4405: CLOSE l_changed_rel_dists_csr;
4406:
4407: po_document_funds_grp.populate_encumbrance_gt(
4408: p_api_version => 1.0,
4409: x_return_status => x_return_status,
4410: p_doc_type => po_document_funds_grp.g_doc_type_release,
4411: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

Line 4410: p_doc_type => po_document_funds_grp.g_doc_type_release,

4406:
4407: po_document_funds_grp.populate_encumbrance_gt(
4408: p_api_version => 1.0,
4409: x_return_status => x_return_status,
4410: p_doc_type => po_document_funds_grp.g_doc_type_release,
4411: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4412: p_doc_level_id_tbl => l_distribution_id_tbl,
4413: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4414: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

Line 4411: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

4407: po_document_funds_grp.populate_encumbrance_gt(
4408: p_api_version => 1.0,
4409: x_return_status => x_return_status,
4410: p_doc_type => po_document_funds_grp.g_doc_type_release,
4411: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4412: p_doc_level_id_tbl => l_distribution_id_tbl,
4413: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4414: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4415: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

Line 4413: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,

4409: x_return_status => x_return_status,
4410: p_doc_type => po_document_funds_grp.g_doc_type_release,
4411: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4412: p_doc_level_id_tbl => l_distribution_id_tbl,
4413: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4414: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4415: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4416:
4417: -- error handling after calling populate_encumbrance_gt

Line 4414: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

4410: p_doc_type => po_document_funds_grp.g_doc_type_release,
4411: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4412: p_doc_level_id_tbl => l_distribution_id_tbl,
4413: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4414: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4415: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4416:
4417: -- error handling after calling populate_encumbrance_gt
4418: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

Line 4415: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

4411: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
4412: p_doc_level_id_tbl => l_distribution_id_tbl,
4413: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
4414: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
4415: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
4416:
4417: -- error handling after calling populate_encumbrance_gt
4418: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
4419: x_retmsg := 'After calling populate_encumbrance_gt (release)';

Line 4639: adjustment_status = po_document_funds_grp.g_adjustment_status_new;

4635: price = l_new_price,
4636: nonrecoverable_tax = l_new_tax
4637: WHERE
4638: distribution_id = l_distribution_id AND
4639: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
4640:
4641: END LOOP;
4642: CLOSE l_dist_qty_price_chn_csr;
4643:

Line 4648: po_document_funds_grp.check_adjust(

4644:
4645: x_retmsg := 'SMRCH0032';
4646: --Execute PO Funds Check API
4647:
4648: po_document_funds_grp.check_adjust(
4649: p_api_version => 1.0,
4650: x_return_status => l_fc_result_status,
4651: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4652: p_doc_subtype => NULL,

Line 4651: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,

4647:
4648: po_document_funds_grp.check_adjust(
4649: p_api_version => 1.0,
4650: x_return_status => l_fc_result_status,
4651: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4652: p_doc_subtype => NULL,
4653: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4654: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4655: p_override_date => SYSDATE,

Line 4653: p_override_funds => po_document_funds_grp.g_parameter_use_profile,

4649: p_api_version => 1.0,
4650: x_return_status => l_fc_result_status,
4651: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4652: p_doc_subtype => NULL,
4653: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4654: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4655: p_override_date => SYSDATE,
4656: p_report_successes => po_document_funds_grp.g_parameter_no,
4657: x_po_return_code => l_po_return_code,

Line 4654: p_use_gl_date => po_document_funds_grp.g_parameter_yes,

4650: x_return_status => l_fc_result_status,
4651: p_doc_type => po_document_funds_grp.g_doc_type_mixed_po_release,
4652: p_doc_subtype => NULL,
4653: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4654: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4655: p_override_date => SYSDATE,
4656: p_report_successes => po_document_funds_grp.g_parameter_no,
4657: x_po_return_code => l_po_return_code,
4658: x_detailed_results => l_fc_out_tbl);

Line 4656: p_report_successes => po_document_funds_grp.g_parameter_no,

4652: p_doc_subtype => NULL,
4653: p_override_funds => po_document_funds_grp.g_parameter_use_profile,
4654: p_use_gl_date => po_document_funds_grp.g_parameter_yes,
4655: p_override_date => SYSDATE,
4656: p_report_successes => po_document_funds_grp.g_parameter_no,
4657: x_po_return_code => l_po_return_code,
4658: x_detailed_results => l_fc_out_tbl);
4659:
4660: x_retmsg := 'SMRCH004';

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

4673: RETURN;
4674:
4675: ELSE
4676:
4677: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
4678: x_return_status := fnd_api.g_ret_sts_success;
4679:
4680: ELSE -- there can be warning/error message for other cases
4681: IF (l_po_return_code = po_document_funds_grp.g_return_WARNING) THEN

Line 4681: IF (l_po_return_code = po_document_funds_grp.g_return_WARNING) THEN

4677: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
4678: x_return_status := fnd_api.g_ret_sts_success;
4679:
4680: ELSE -- there can be warning/error message for other cases
4681: IF (l_po_return_code = po_document_funds_grp.g_return_WARNING) THEN
4682: x_errCode := 'FC_WARN';
4683: ELSE
4684: x_errcode := 'FC_FAIL';
4685: END IF;

Line 6481: po_document_funds_grp.populate_encumbrance_gt(

6477: INTO l_distribution_id_tbl;
6478:
6479: CLOSE l_changed_req_dists_csr;
6480:
6481: po_document_funds_grp.populate_encumbrance_gt(
6482: p_api_version => 1.0,
6483: x_return_status => x_return_status,
6484: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6485: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

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

6480:
6481: po_document_funds_grp.populate_encumbrance_gt(
6482: p_api_version => 1.0,
6483: x_return_status => x_return_status,
6484: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6485: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6486: p_doc_level_id_tbl => l_distribution_id_tbl,
6487: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6488: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

Line 6485: p_doc_level => po_document_funds_grp.g_doc_level_distribution,

6481: po_document_funds_grp.populate_encumbrance_gt(
6482: p_api_version => 1.0,
6483: x_return_status => x_return_status,
6484: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6485: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6486: p_doc_level_id_tbl => l_distribution_id_tbl,
6487: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6488: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6489: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

Line 6487: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,

6483: x_return_status => x_return_status,
6484: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6485: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6486: p_doc_level_id_tbl => l_distribution_id_tbl,
6487: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6488: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6489: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
6490:
6491: -- error handling after calling populate_encumbrance_gt

Line 6488: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,

6484: p_doc_type => po_document_funds_grp.g_doc_type_requisition, --call with req type at dist level
6485: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6486: p_doc_level_id_tbl => l_distribution_id_tbl,
6487: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6488: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6489: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
6490:
6491: -- error handling after calling populate_encumbrance_gt
6492: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

Line 6489: p_check_only_flag => po_document_funds_grp.g_parameter_yes);

6485: p_doc_level => po_document_funds_grp.g_doc_level_distribution,
6486: p_doc_level_id_tbl => l_distribution_id_tbl,
6487: p_make_old_copies_flag => po_document_funds_grp.g_parameter_yes,
6488: p_make_new_copies_flag => po_document_funds_grp.g_parameter_yes,
6489: p_check_only_flag => po_document_funds_grp.g_parameter_yes);
6490:
6491: -- error handling after calling populate_encumbrance_gt
6492: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
6493: x_retmsg := 'After calling populate_encumbrance_gt';

Line 6557: adjustment_status = po_document_funds_grp.g_adjustment_status_new;

6553: price = l_new_price,
6554: nonrecoverable_tax = l_new_tax
6555: WHERE
6556: distribution_id = l_distribution_id AND
6557: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
6558:
6559: END LOOP;
6560: CLOSE l_dist_tax_csr;
6561:

Line 6566: po_document_funds_grp.check_adjust(

6562:
6563: x_retmsg := 'SMRCH0032';
6564: --Execute PO Funds Check API
6565:
6566: po_document_funds_grp.check_adjust(
6567: p_api_version => 1.0,
6568: x_return_status => l_fc_result_status,
6569: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6570: p_doc_subtype => NULL,

Line 6569: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,

6565:
6566: po_document_funds_grp.check_adjust(
6567: p_api_version => 1.0,
6568: x_return_status => l_fc_result_status,
6569: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6570: p_doc_subtype => NULL,
6571: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6572: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6573: p_override_date => sysdate,

Line 6571: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,

6567: p_api_version => 1.0,
6568: x_return_status => l_fc_result_status,
6569: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6570: p_doc_subtype => NULL,
6571: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6572: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6573: p_override_date => sysdate,
6574: p_report_successes => po_document_funds_grp.g_parameter_NO,
6575: x_po_return_code => l_po_return_code,

Line 6572: p_use_gl_date => po_document_funds_grp.g_parameter_YES,

6568: x_return_status => l_fc_result_status,
6569: p_doc_type => po_document_funds_grp.g_doc_type_REQUISITION,
6570: p_doc_subtype => NULL,
6571: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6572: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6573: p_override_date => sysdate,
6574: p_report_successes => po_document_funds_grp.g_parameter_NO,
6575: x_po_return_code => l_po_return_code,
6576: x_detailed_results => l_fc_out_tbl);

Line 6574: p_report_successes => po_document_funds_grp.g_parameter_NO,

6570: p_doc_subtype => NULL,
6571: p_override_funds => po_document_funds_grp.g_parameter_USE_PROFILE,
6572: p_use_gl_date => po_document_funds_grp.g_parameter_YES,
6573: p_override_date => sysdate,
6574: p_report_successes => po_document_funds_grp.g_parameter_NO,
6575: x_po_return_code => l_po_return_code,
6576: x_detailed_results => l_fc_out_tbl);
6577:
6578: x_retMsg := 'SMRCH004';

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

6595: po_debug.debug_STmt(l_log_head, x_retmsg, 'after check adjust of funds check');
6596: END IF;
6597:
6598:
6599: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
6600: x_return_status := fnd_api.g_ret_sts_success;
6601:
6602: ELSE -- there can be warning/error message for other cases
6603: