DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_TAX_INTERFACE_PVT

Line 2102: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => NULL,

2098: -- Check 8:
2099: --
2100: -----------------------------------------------------------------------------
2101:
2102: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => NULL,
2103: p_po_release_id => NULL,
2104: p_req_header_id => p_document_id);
2105: IF g_debug_stmt THEN
2106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2121: po_tax_interface_pvt.calculate_tax_requisition( x_return_status => l_return_status,

2117: 'REQ 9: Calculate tax as the current one is not correct');
2118: END IF;
2119: END IF;
2120: l_progress := '010';
2121: po_tax_interface_pvt.calculate_tax_requisition( x_return_status => l_return_status,
2122: p_requisition_header_id => p_document_id,
2123: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
2124:
2125: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2137: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT

2133: END IF;
2134:
2135: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
2136:
2137: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
2138: INSERT INTO po_online_report_text_gt
2139: (
2140: online_report_id,
2141: last_update_login,

Line 2162: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),

2158: p_user_id,
2159: sysdate,
2160: p_user_id,
2161: sysdate,
2162: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
2163: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
2164: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
2165: p_sequence + ROWNUM,
2166: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

Line 2163: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),

2159: sysdate,
2160: p_user_id,
2161: sysdate,
2162: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
2163: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
2164: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
2165: p_sequence + ROWNUM,
2166: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
2167: 'PO_TAX_CALCULATION_FAILED',

Line 2164: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),

2160: p_user_id,
2161: sysdate,
2162: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
2163: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
2164: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
2165: p_sequence + ROWNUM,
2166: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
2167: 'PO_TAX_CALCULATION_FAILED',
2168: 'E'

Line 2166: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

2162: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
2163: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
2164: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
2165: p_sequence + ROWNUM,
2166: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
2167: 'PO_TAX_CALCULATION_FAILED',
2168: 'E'
2169: );
2170: l_progress := '012';

Line 2181: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN

2177: 'REQ 11: Calculate tax raised unexpected error');
2178: END IF;
2179: END IF;
2180: l_textline := l_progress ||' - ';
2181: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
2182: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
2183: ELSE
2184: l_textline := l_textline || SQLERRM();
2185: END IF;

Line 2182: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);

2178: END IF;
2179: END IF;
2180: l_textline := l_progress ||' - ';
2181: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
2182: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
2183: ELSE
2184: l_textline := l_textline || SQLERRM();
2185: END IF;
2186: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');

Line 3760: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => NULL,

3756:
3757: --
3758: -----------------------------------------------------------------------------
3759:
3760: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => NULL,
3761: p_po_release_id => p_document_id,
3762: p_req_header_id => NULL);
3763: l_progress := '021';
3764: IF g_debug_stmt THEN

Line 3780: po_tax_interface_pvt.calculate_tax( x_return_status => l_return_status,

3776: 'Rel 22: Calculate tax as the current one is not correct');
3777: END IF;
3778: END IF;
3779: l_progress := '021';
3780: po_tax_interface_pvt.calculate_tax( x_return_status => l_return_status,
3781: p_po_header_id => NULL,
3782: p_po_release_id => p_document_id,
3783: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
3784: l_progress := '022';

Line 3797: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT

3793: l_progress := '023';
3794:
3795: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
3796:
3797: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
3798: INSERT INTO po_online_report_text_gt
3799: (
3800: online_report_id,
3801: last_update_login,

Line 3822: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),

3818: p_user_id,
3819: sysdate,
3820: p_user_id,
3821: sysdate,
3822: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3823: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3824: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3825: p_sequence + ROWNUM,
3826: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

Line 3823: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),

3819: sysdate,
3820: p_user_id,
3821: sysdate,
3822: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3823: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3824: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3825: p_sequence + ROWNUM,
3826: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
3827: 'PO_TAX_CALCULATION_FAILED',

Line 3824: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),

3820: p_user_id,
3821: sysdate,
3822: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3823: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3824: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3825: p_sequence + ROWNUM,
3826: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
3827: 'PO_TAX_CALCULATION_FAILED',
3828: 'E'

Line 3826: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

3822: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3823: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3824: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3825: p_sequence + ROWNUM,
3826: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
3827: 'PO_TAX_CALCULATION_FAILED',
3828: 'E'
3829: );
3830: l_progress := '024';

Line 3840: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN

3836: 'Rel 24: Calculate tax raised unexpected error');
3837: END IF;
3838: END IF;
3839: l_textline := l_progress ||' - ';
3840: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
3841: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
3842: ELSE
3843: l_textline := l_textline || SQLERRM();
3844: END IF;

Line 3841: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);

3837: END IF;
3838: END IF;
3839: l_textline := l_progress ||' - ';
3840: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
3841: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
3842: ELSE
3843: l_textline := l_textline || SQLERRM();
3844: END IF;
3845: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');

Line 6881: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => p_document_id,

6877: l_progress := '021';
6878: --
6879: -----------------------------------------------------------------------------
6880:
6881: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => p_document_id,
6882: p_po_release_id => NULL,
6883: p_req_header_id => NULL);
6884: l_progress := '022';
6885: IF g_debug_stmt THEN

Line 6901: po_tax_interface_pvt.calculate_tax( x_return_status => l_return_status,

6897: 'PO 22: Calculate tax as the current one is not correct');
6898: END IF;
6899: END IF;
6900: l_progress := '023';
6901: po_tax_interface_pvt.calculate_tax( x_return_status => l_return_status,
6902: p_po_header_id => p_document_id,
6903: p_po_release_id => NULL,
6904: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
6905:

Line 6915: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT

6911: 'PO 23: Calculate tax has errored out');
6912: END IF;
6913: END IF;
6914: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
6915: FORALL i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
6916: INSERT INTO po_online_report_text_gt
6917: (
6918: online_report_id,
6919: last_update_login,

Line 6940: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),

6936: p_user_id,
6937: sysdate,
6938: p_user_id,
6939: sysdate,
6940: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
6941: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
6942: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
6943: p_sequence + ROWNUM,
6944: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

Line 6941: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),

6937: sysdate,
6938: p_user_id,
6939: sysdate,
6940: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
6941: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
6942: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
6943: p_sequence + ROWNUM,
6944: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
6945: 'PO_TAX_CALCULATION_FAILED',

Line 6942: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),

6938: p_user_id,
6939: sysdate,
6940: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
6941: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
6942: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
6943: p_sequence + ROWNUM,
6944: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
6945: 'PO_TAX_CALCULATION_FAILED',
6946: 'E'

Line 6944: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

6940: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
6941: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
6942: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
6943: p_sequence + ROWNUM,
6944: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
6945: 'PO_TAX_CALCULATION_FAILED',
6946: 'E'
6947: );
6948: l_progress := '024';

Line 6958: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN

6954: 'PO 24: Calculate tax raised unexpected error');
6955: END IF;
6956: END IF;
6957: l_textline := l_progress ||' - ';
6958: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
6959: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
6960: ELSE
6961: l_textline := l_textline || SQLERRM();
6962: END IF;

Line 6959: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);

6955: END IF;
6956: END IF;
6957: l_textline := l_progress ||' - ';
6958: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
6959: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
6960: ELSE
6961: l_textline := l_textline || SQLERRM();
6962: END IF;
6963: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');