DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_TAX_INTERFACE_PVT

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

3897: -- Check 8:
3898: --
3899: -----------------------------------------------------------------------------
3900:
3901: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => NULL,
3902: p_po_release_id => NULL,
3903: p_req_header_id => p_document_id);
3904: IF g_debug_stmt THEN
3905: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

3916: 'REQ 9: Calculate tax as the current one is not correct');
3917: END IF;
3918: END IF;
3919: l_progress := '010';
3920: po_tax_interface_pvt.calculate_tax_requisition( x_return_status => l_return_status,
3921: p_requisition_header_id => p_document_id,
3922: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
3923:
3924: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3936: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT

3932: END IF;
3933:
3934: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
3935:
3936: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
3937: LOOP
3938: INSERT INTO po_online_report_text_gt
3939: (
3940: online_report_id,

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

3958: p_user_id,
3959: sysdate,
3960: p_user_id,
3961: sysdate,
3962: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3963: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3964: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3965: p_sequence + i, /* 11851142 replaced with rownum */
3966: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

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

3959: sysdate,
3960: p_user_id,
3961: sysdate,
3962: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3963: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3964: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3965: p_sequence + i, /* 11851142 replaced with rownum */
3966: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
3967: 'PO_TAX_CALCULATION_FAILED',

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

3960: p_user_id,
3961: sysdate,
3962: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3963: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3964: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3965: p_sequence + i, /* 11851142 replaced with rownum */
3966: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
3967: 'PO_TAX_CALCULATION_FAILED',
3968: 'E'

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

3962: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
3963: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
3964: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
3965: p_sequence + i, /* 11851142 replaced with rownum */
3966: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
3967: 'PO_TAX_CALCULATION_FAILED',
3968: 'E'
3969: );
3970: END LOOP;

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

3978: 'REQ 11: Calculate tax raised unexpected error');
3979: END IF;
3980: END IF;
3981: l_textline := l_progress ||' - ';
3982: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
3983: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
3984: ELSE
3985: l_textline := l_textline || SQLERRM();
3986: END IF;

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

3979: END IF;
3980: END IF;
3981: l_textline := l_progress ||' - ';
3982: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
3983: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
3984: ELSE
3985: l_textline := l_textline || SQLERRM();
3986: END IF;
3987: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');

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

5620:
5621: --
5622: -----------------------------------------------------------------------------
5623:
5624: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => NULL,
5625: p_po_release_id => p_document_id,
5626: p_req_header_id => NULL);
5627: l_progress := '021';
5628: IF g_debug_stmt THEN

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

5640: 'Rel 22: Calculate tax as the current one is not correct');
5641: END IF;
5642: END IF;
5643: l_progress := '021';
5644: po_tax_interface_pvt.calculate_tax( x_return_status => l_return_status,
5645: p_po_header_id => NULL,
5646: p_po_release_id => p_document_id,
5647: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
5648: l_progress := '022';

Line 5661: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT

5657: l_progress := '023';
5658:
5659: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
5660:
5661: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
5662: LOOP
5663: INSERT INTO po_online_report_text_gt
5664: (
5665: online_report_id,

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

5683: p_user_id,
5684: sysdate,
5685: p_user_id,
5686: sysdate,
5687: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
5688: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
5689: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
5690: p_sequence + i, /* 11851142 Replaced with i from ROWNUM */
5691: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

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

5684: sysdate,
5685: p_user_id,
5686: sysdate,
5687: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
5688: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
5689: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
5690: p_sequence + i, /* 11851142 Replaced with i from ROWNUM */
5691: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
5692: 'PO_TAX_CALCULATION_FAILED',

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

5685: p_user_id,
5686: sysdate,
5687: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
5688: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
5689: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
5690: p_sequence + i, /* 11851142 Replaced with i from ROWNUM */
5691: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
5692: 'PO_TAX_CALCULATION_FAILED',
5693: 'E'

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

5687: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
5688: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
5689: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
5690: p_sequence + i, /* 11851142 Replaced with i from ROWNUM */
5691: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
5692: 'PO_TAX_CALCULATION_FAILED',
5693: 'E'
5694: );
5695: END LOOP;

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

5702: 'Rel 24: Calculate tax raised unexpected error');
5703: END IF;
5704: END IF;
5705: l_textline := l_progress ||' - ';
5706: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
5707: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
5708: ELSE
5709: l_textline := l_textline || SQLERRM();
5710: END IF;

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

5703: END IF;
5704: END IF;
5705: l_textline := l_progress ||' - ';
5706: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
5707: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
5708: ELSE
5709: l_textline := l_textline || SQLERRM();
5710: END IF;
5711: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');

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

9542: l_progress := '021';
9543: --
9544: -----------------------------------------------------------------------------
9545:
9546: l_tax_status := po_tax_interface_pvt.calculate_tax_yes_no(p_po_header_id => p_document_id,
9547: p_po_release_id => NULL,
9548: p_req_header_id => NULL);
9549: l_progress := '022';
9550: IF g_debug_stmt THEN

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

9562: 'PO 22: Calculate tax as the current one is not correct');
9563: END IF;
9564: END IF;
9565: l_progress := '023';
9566: po_tax_interface_pvt.calculate_tax( x_return_status => l_return_status,
9567: p_po_header_id => p_document_id,
9568: p_po_release_id => NULL,
9569: p_calling_program => g_action_DOC_SUBMISSION_CHECK);
9570:

Line 9580: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT

9576: 'PO 23: Calculate tax has errored out');
9577: END IF;
9578: END IF;
9579: l_tax_message := fnd_message.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
9580: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT
9581: LOOP
9582: INSERT INTO po_online_report_text_gt
9583: (
9584: online_report_id,

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

9602: p_user_id,
9603: sysdate,
9604: p_user_id,
9605: sysdate,
9606: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
9607: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
9608: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
9609: p_sequence + i, /* 11851142 replaced from ROWNUM */
9610: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),

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

9603: sysdate,
9604: p_user_id,
9605: sysdate,
9606: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
9607: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
9608: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
9609: p_sequence + i, /* 11851142 replaced from ROWNUM */
9610: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
9611: 'PO_TAX_CALCULATION_FAILED',

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

9604: p_user_id,
9605: sysdate,
9606: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
9607: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
9608: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
9609: p_sequence + i, /* 11851142 replaced from ROWNUM */
9610: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
9611: 'PO_TAX_CALCULATION_FAILED',
9612: 'E'

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

9606: po_tax_interface_pvt.G_TAX_ERRORS_TBL.line_num(i),
9607: po_tax_interface_pvt.G_TAX_ERRORS_TBL.shipment_num(i),
9608: po_tax_interface_pvt.G_TAX_ERRORS_TBL.distribution_num(i),
9609: p_sequence + i, /* 11851142 replaced from ROWNUM */
9610: l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i),
9611: 'PO_TAX_CALCULATION_FAILED',
9612: 'E'
9613: );
9614: END LOOP;

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

9621: 'PO 24: Calculate tax raised unexpected error');
9622: END IF;
9623: END IF;
9624: l_textline := l_progress ||' - ';
9625: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
9626: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
9627: ELSE
9628: l_textline := l_textline || SQLERRM();
9629: END IF;

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

9622: END IF;
9623: END IF;
9624: l_textline := l_progress ||' - ';
9625: IF po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT > 0 THEN
9626: l_textline := l_textline || po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT(1);
9627: ELSE
9628: l_textline := l_textline || SQLERRM();
9629: END IF;
9630: fnd_message.set_name('PO','PO_TAX_CALC_UNEXPECTED_ERROR');