eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_ETAX_UTIL_PKG dependencies on IGC_ETAX_UTIL_PKG

Line 1: PACKAGE BODY IGC_ETAX_UTIL_PKG AS

1: PACKAGE BODY IGC_ETAX_UTIL_PKG AS
2: /* $Header: IGCETXUB.pls 120.7.12010000.2 2008/11/25 16:07:17 sasukuma ship $ */
3:
4:
5: -- Create global variables to maintain the session info

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_ETAX_UTIL_PKG';

6: l_user_id igc_cc_headers.created_by%TYPE := FND_GLOBAL.user_id;
7: l_login_id igc_cc_headers.last_update_login%TYPE := FND_GLOBAL.login_id;
8: l_sysdate DATE := sysdate;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGC_ETAX_UTIL_PKG';
11: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
12: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
13: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
14: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 26: G_MODULE_NAME CONSTANT VARCHAR2(64) := 'IGC.PLSQL.ICETXUB.IGC_ETAX_UTIL_PKG.';

22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(64) := 'IGC.PLSQL.ICETXUB.IGC_ETAX_UTIL_PKG.';
27: G_ORG_LOC_ID HR_ALL_ORGANIZATION_UNITS.location_id%TYPE;
28:
29: FUNCTION Populate_Dist_GT(
30: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,

Line 86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IGC_ETAX_UTIL_PKG.set_tax_security_context');

82: EXCEPTION
83: WHEN OTHERS THEN
84: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IGC_ETAX_UTIL_PKG.set_tax_security_context');
87: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_org_id: ' || p_org_id ||
88: 'p_legal_entity_id: ' || p_legal_entity_id ||
89: 'p_transaction_date: ' || p_transaction_date ||
90: 'p_related_doc_date: ' || p_related_doc_date ||

Line 137: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID

133: WHERE currency_code = l_ledger_currency;
134:
135:
136: DELETE FROM zx_trx_headers_gt
137: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
138: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
139: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
140: AND trx_id = P_CC_Header_Rec.cc_header_id;
141:

Line 138: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE

134:
135:
136: DELETE FROM zx_trx_headers_gt
137: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
138: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
139: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
140: AND trx_id = P_CC_Header_Rec.cc_header_id;
141:
142: IF g_org_loc_id is NOT NULL THEN -- Bug#6647075

Line 139: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE

135:
136: DELETE FROM zx_trx_headers_gt
137: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
138: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
139: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
140: AND trx_id = P_CC_Header_Rec.cc_header_id;
141:
142: IF g_org_loc_id is NOT NULL THEN -- Bug#6647075
143: l_rounding_bill_to_party_id := P_CC_Header_Rec.org_id;

Line 232: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID, --application_id

228: VALUES
229: (
230: P_CC_Header_Rec.org_id, --internal_organization_id
231: NULL, --P_CC_Header_Rec.location_id, --internal_org_location_id ^^
232: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID, --application_id
233: IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE, --entity_code
234: IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE, --event_class_code
235: IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE, --event_type_code
236: P_CC_Header_Rec.cc_header_id, --trx_id

Line 233: IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE, --entity_code

229: (
230: P_CC_Header_Rec.org_id, --internal_organization_id
231: NULL, --P_CC_Header_Rec.location_id, --internal_org_location_id ^^
232: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID, --application_id
233: IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE, --entity_code
234: IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE, --event_class_code
235: IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE, --event_type_code
236: P_CC_Header_Rec.cc_header_id, --trx_id
237: NULL, --hdr_trx_user_key1

Line 234: IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE, --event_class_code

230: P_CC_Header_Rec.org_id, --internal_organization_id
231: NULL, --P_CC_Header_Rec.location_id, --internal_org_location_id ^^
232: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID, --application_id
233: IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE, --entity_code
234: IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE, --event_class_code
235: IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE, --event_type_code
236: P_CC_Header_Rec.cc_header_id, --trx_id
237: NULL, --hdr_trx_user_key1
238: NULL, --hdr_trx_user_key2

Line 235: IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE, --event_type_code

231: NULL, --P_CC_Header_Rec.location_id, --internal_org_location_id ^^
232: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID, --application_id
233: IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE, --entity_code
234: IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE, --event_class_code
235: IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE, --event_type_code
236: P_CC_Header_Rec.cc_header_id, --trx_id
237: NULL, --hdr_trx_user_key1
238: NULL, --hdr_trx_user_key2
239: NULL, --hdr_trx_user_key3

Line 276: IGC_ETAX_UTIL_PKG.IGC_TAX_QUOTE_FLAG, --quote_flag

272: NULL, --rel_doc_hdr_trx_user_key6
273: NULL, --related_doc_number *CC*
274: NULL, --related_doc_date *CC*
275: NULL, --*check* p_invoice_header_rec.taxation_country, --default_taxation_country
276: IGC_ETAX_UTIL_PKG.IGC_TAX_QUOTE_FLAG, --quote_flag
277: NULL, --ctrl_total_hdr_tx_amt *CC*
278: P_CC_Header_Rec.cc_num, --trx_number *CC*
279: NULL, --trx_description
280: NULL, --trx_communicated_date

Line 295: IGC_ETAX_UTIL_PKG.IGC_TAX_EVENT_TYPE_CODE, --tax_event_type_code

291: NULL, --supplier_exchange_rate *CC*
292: NULL, --tax_invoice_date *CC*
293: NULL, --tax_invoice_number *CC*
294: NULL, --tax_event_class_code
295: IGC_ETAX_UTIL_PKG.IGC_TAX_EVENT_TYPE_CODE, --tax_event_type_code
296: NULL, --doc_event_status
297: NULL, --rdng_ship_to_pty_tx_prof_id
298: NULL, --rdng_ship_from_pty_tx_prof_id
299: NULL, --rdng_bill_to_pty_tx_prof_id

Line 314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Application_id: '|| IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID);

310: );
311:
312: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_trx_headers_gt values ');
314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Application_id: '|| IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID);
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Entity_code: ' || IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE);
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_class_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE);
317: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_type_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CC Header Id: '|| P_CC_Header_Rec.cc_header_id);

Line 315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Entity_code: ' || IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE);

311:
312: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_trx_headers_gt values ');
314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Application_id: '|| IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID);
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Entity_code: ' || IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE);
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_class_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE);
317: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_type_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CC Header Id: '|| P_CC_Header_Rec.cc_header_id);
319: END IF;

Line 316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_class_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE);

312: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_trx_headers_gt values ');
314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Application_id: '|| IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID);
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Entity_code: ' || IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE);
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_class_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE);
317: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_type_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CC Header Id: '|| P_CC_Header_Rec.cc_header_id);
319: END IF;
320: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 317: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_type_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE);

313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'zx_trx_headers_gt values ');
314: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Application_id: '|| IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID);
315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Entity_code: ' || IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE);
316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_class_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE);
317: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Event_type_code: ' || IGC_ETAX_UTIL_PKG.IGC_EVENT_TYPE_CODE);
318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'CC Header Id: '|| P_CC_Header_Rec.cc_header_id);
319: END IF;
320: l_return_status := FND_API.G_RET_STS_SUCCESS;
321: l_debug_info := 'Populating zx header table after insert before retunr';

Line 369: l_calling_sequence := 'IGC_ETAX_UTIL_PKG.Populate_Lines_GT';

365: FROM igc_cc_acct_lines
366: WHERE cc_acct_line_id = c_line_id;
367:
368: BEGIN
369: l_calling_sequence := 'IGC_ETAX_UTIL_PKG.Populate_Lines_GT';
370: IF (l_cc_line_list.COUNT <> 0) THEN
371: l_cc_line_list.DELETE;
372: ELSE
373: OPEN CC_Acct_Lines (P_Line_Id);

Line 381: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID

377: END IF;
378:
379: /* Bug 6719456 - Deleting all records instead of just passed line*/
380: DELETE FROM zx_transaction_lines_gt
381: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
382: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
383: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
384: AND trx_id = P_CC_Header_Rec.cc_header_id
385: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;

Line 382: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE

378:
379: /* Bug 6719456 - Deleting all records instead of just passed line*/
380: DELETE FROM zx_transaction_lines_gt
381: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
382: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
383: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
384: AND trx_id = P_CC_Header_Rec.cc_header_id
385: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
386:

Line 383: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE

379: /* Bug 6719456 - Deleting all records instead of just passed line*/
380: DELETE FROM zx_transaction_lines_gt
381: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
382: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
383: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
384: AND trx_id = P_CC_Header_Rec.cc_header_id
385: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
386:
387: /* --*CC* Set l_debug variable across for debug information */

Line 385: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;

381: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
382: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
383: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
384: AND trx_id = P_CC_Header_Rec.cc_header_id
385: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
386:
387: /* --*CC* Set l_debug variable across for debug information */
388: IF ( l_cc_line_list.COUNT > 0) THEN
389: l_trans_lines.EXTEND(l_cc_line_list.COUNT);

Line 391: l_trans_lines(i).application_id := IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID;

387: /* --*CC* Set l_debug variable across for debug information */
388: IF ( l_cc_line_list.COUNT > 0) THEN
389: l_trans_lines.EXTEND(l_cc_line_list.COUNT);
390: FOR i IN l_cc_line_list.FIRST .. l_cc_line_list.LAST LOOP
391: l_trans_lines(i).application_id := IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID;
392: l_trans_lines(i).entity_code := IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE;
393: l_trans_lines(i).event_class_code := IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE;
394: l_trans_lines(i).trx_id := P_CC_Header_Rec.cc_header_id;
395: l_trans_lines(i).trx_line_id := l_cc_line_list(i).cc_acct_line_id;

Line 392: l_trans_lines(i).entity_code := IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE;

388: IF ( l_cc_line_list.COUNT > 0) THEN
389: l_trans_lines.EXTEND(l_cc_line_list.COUNT);
390: FOR i IN l_cc_line_list.FIRST .. l_cc_line_list.LAST LOOP
391: l_trans_lines(i).application_id := IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID;
392: l_trans_lines(i).entity_code := IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE;
393: l_trans_lines(i).event_class_code := IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE;
394: l_trans_lines(i).trx_id := P_CC_Header_Rec.cc_header_id;
395: l_trans_lines(i).trx_line_id := l_cc_line_list(i).cc_acct_line_id;
396: l_trans_lines(i).line_amt := NVL(P_Amount,0);

Line 393: l_trans_lines(i).event_class_code := IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE;

389: l_trans_lines.EXTEND(l_cc_line_list.COUNT);
390: FOR i IN l_cc_line_list.FIRST .. l_cc_line_list.LAST LOOP
391: l_trans_lines(i).application_id := IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID;
392: l_trans_lines(i).entity_code := IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE;
393: l_trans_lines(i).event_class_code := IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE;
394: l_trans_lines(i).trx_id := P_CC_Header_Rec.cc_header_id;
395: l_trans_lines(i).trx_line_id := l_cc_line_list(i).cc_acct_line_id;
396: l_trans_lines(i).line_amt := NVL(P_Amount,0);
397: l_trans_lines(i).trx_level_type := IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE;

Line 397: l_trans_lines(i).trx_level_type := IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE;

393: l_trans_lines(i).event_class_code := IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE;
394: l_trans_lines(i).trx_id := P_CC_Header_Rec.cc_header_id;
395: l_trans_lines(i).trx_line_id := l_cc_line_list(i).cc_acct_line_id;
396: l_trans_lines(i).line_amt := NVL(P_Amount,0);
397: l_trans_lines(i).trx_level_type := IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE;
398: l_trans_lines(i).line_level_action := IGC_ETAX_UTIL_PKG.IGC_LINE_LEVEL_ACTION;
399: l_trans_lines(i).line_class := IGC_ETAX_UTIL_PKG.IGC_LINE_CLASS;
400: l_trans_lines(i).line_amt_includes_tax_flag := 'S';
401: l_trans_lines(i).trx_line_date := P_CC_Header_Rec.cc_acct_date;

Line 398: l_trans_lines(i).line_level_action := IGC_ETAX_UTIL_PKG.IGC_LINE_LEVEL_ACTION;

394: l_trans_lines(i).trx_id := P_CC_Header_Rec.cc_header_id;
395: l_trans_lines(i).trx_line_id := l_cc_line_list(i).cc_acct_line_id;
396: l_trans_lines(i).line_amt := NVL(P_Amount,0);
397: l_trans_lines(i).trx_level_type := IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE;
398: l_trans_lines(i).line_level_action := IGC_ETAX_UTIL_PKG.IGC_LINE_LEVEL_ACTION;
399: l_trans_lines(i).line_class := IGC_ETAX_UTIL_PKG.IGC_LINE_CLASS;
400: l_trans_lines(i).line_amt_includes_tax_flag := 'S';
401: l_trans_lines(i).trx_line_date := P_CC_Header_Rec.cc_acct_date;
402: l_trans_lines(i).ship_from_location_id := P_CC_Header_Rec.location_id;

Line 399: l_trans_lines(i).line_class := IGC_ETAX_UTIL_PKG.IGC_LINE_CLASS;

395: l_trans_lines(i).trx_line_id := l_cc_line_list(i).cc_acct_line_id;
396: l_trans_lines(i).line_amt := NVL(P_Amount,0);
397: l_trans_lines(i).trx_level_type := IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE;
398: l_trans_lines(i).line_level_action := IGC_ETAX_UTIL_PKG.IGC_LINE_LEVEL_ACTION;
399: l_trans_lines(i).line_class := IGC_ETAX_UTIL_PKG.IGC_LINE_CLASS;
400: l_trans_lines(i).line_amt_includes_tax_flag := 'S';
401: l_trans_lines(i).trx_line_date := P_CC_Header_Rec.cc_acct_date;
402: l_trans_lines(i).ship_from_location_id := P_CC_Header_Rec.location_id;
403: l_trans_lines(i).ship_to_location_id := P_CC_Header_Rec.location_id;

Line 557: l_calling_sequence := 'IGC_ETAX_UTIL_PKG.Populate_Dist_GT';

553: l_debug_info VARCHAR2(240);
554: BEGIN
555:
556: /* First Delete from zx_itm_distributions_gt table */
557: l_calling_sequence := 'IGC_ETAX_UTIL_PKG.Populate_Dist_GT';
558: IF (g_debug_mode = 'Y') THEN
559: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deleting records from zx_itm_distributions_gt table');
560: END IF;
561:

Line 563: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID

559: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deleting records from zx_itm_distributions_gt table');
560: END IF;
561:
562: DELETE FROM zx_itm_distributions_gt
563: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
564: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
565: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
566: AND trx_id = P_CC_Header_Rec.cc_header_id
567: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;

Line 564: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE

560: END IF;
561:
562: DELETE FROM zx_itm_distributions_gt
563: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
564: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
565: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
566: AND trx_id = P_CC_Header_Rec.cc_header_id
567: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
568:

Line 565: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE

561:
562: DELETE FROM zx_itm_distributions_gt
563: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
564: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
565: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
566: AND trx_id = P_CC_Header_Rec.cc_header_id
567: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
568:
569: IF (g_debug_mode = 'Y') THEN

Line 567: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;

563: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
564: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
565: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
566: AND trx_id = P_CC_Header_Rec.cc_header_id
567: AND TRX_LEVEL_TYPE = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE ;
568:
569: IF (g_debug_mode = 'Y') THEN
570: Put_Debug_Msg (l_full_path,p_debug_msg => 'Deletion from zx_itm_distributions_gt complete');
571: Put_Debug_Msg (l_full_path,p_debug_msg => 'Calling insert into zx_itm_distributions_gt');

Line 602: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --application_id

598: ,overriding_recovery_rate
599: )
600: Values
601: (
602: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --application_id
603: ,IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --entity_code
604: ,IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --event_class_code
605: ,P_CC_Header_Rec.cc_header_id --trx_id
606: ,l_cc_lines.cc_acct_line_id --trx_line_id

Line 603: ,IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --entity_code

599: )
600: Values
601: (
602: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --application_id
603: ,IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --entity_code
604: ,IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --event_class_code
605: ,P_CC_Header_Rec.cc_header_id --trx_id
606: ,l_cc_lines.cc_acct_line_id --trx_line_id
607: ,IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --trx_level_type

Line 604: ,IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --event_class_code

600: Values
601: (
602: IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --application_id
603: ,IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --entity_code
604: ,IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --event_class_code
605: ,P_CC_Header_Rec.cc_header_id --trx_id
606: ,l_cc_lines.cc_acct_line_id --trx_line_id
607: ,IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --trx_level_type
608: ,1 --trx_line_dist_id /* We cal always insert trx_line_dist_id as 1. Only one distribution is required for each call */

Line 607: ,IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --trx_level_type

603: ,IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --entity_code
604: ,IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --event_class_code
605: ,P_CC_Header_Rec.cc_header_id --trx_id
606: ,l_cc_lines.cc_acct_line_id --trx_line_id
607: ,IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --trx_level_type
608: ,1 --trx_line_dist_id /* We cal always insert trx_line_dist_id as 1. Only one distribution is required for each call */
609: ,'CREATE' --dist_level_action
610: ,sysdate --trx_line_dist_date
611: ,l_cc_lines.cc_acct_line_num --item_dist_number

Line 681: l_calling_sequence := 'IGC.IGC_ETAX_UTIL_PKG.Calculate_Tax';

677: where hrop.organization_id=p_org_id;
678:
679: BEGIN
680:
681: l_calling_sequence := 'IGC.IGC_ETAX_UTIL_PKG.Calculate_Tax';
682:
683: --fetch legal entity
684: l_debug_info := 'Fetching legal entity';
685: open get_legal_entity(P_CC_Header_Rec.ORG_ID);

Line 779: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID

775:
776: /* Update zx_trx_headers_gt to set event code to "DISTRIBUTED" */
777: UPDATE zx_trx_headers_gt
778: set event_type_code = 'DISTRIBUTED'
779: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
780: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
781: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
782: AND trx_id = P_CC_Header_Rec.cc_header_id;
783:

Line 780: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE

776: /* Update zx_trx_headers_gt to set event code to "DISTRIBUTED" */
777: UPDATE zx_trx_headers_gt
778: set event_type_code = 'DISTRIBUTED'
779: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
780: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
781: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
782: AND trx_id = P_CC_Header_Rec.cc_header_id;
783:
784: l_debug_info := 'Populate Distribution table Tax API';

Line 781: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE

777: UPDATE zx_trx_headers_gt
778: set event_type_code = 'DISTRIBUTED'
779: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID
780: AND entity_code = IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE
781: AND event_class_code = IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE
782: AND trx_id = P_CC_Header_Rec.cc_header_id;
783:
784: l_debug_info := 'Populate Distribution table Tax API';
785: l_return_status := Populate_dist_GT

Line 838: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --'8407'

834: */
835: SELECT nvl(SUM(rec_nrec_tax_amt),0)
836: INTO l_tax_amount
837: FROM ZX_REC_NREC_DIST_GT
838: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --'8407'
839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'
840: AND event_class_code =IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --'PURCHASE_TRANSACTION_TAX_QUOTE'
841: AND trx_id = P_CC_Header_Rec.cc_header_id
842: AND trx_line_id = p_line_id

Line 839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'

835: SELECT nvl(SUM(rec_nrec_tax_amt),0)
836: INTO l_tax_amount
837: FROM ZX_REC_NREC_DIST_GT
838: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --'8407'
839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'
840: AND event_class_code =IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --'PURCHASE_TRANSACTION_TAX_QUOTE'
841: AND trx_id = P_CC_Header_Rec.cc_header_id
842: AND trx_line_id = p_line_id
843: AND trx_level_type = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --'LINE'

Line 840: AND event_class_code =IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --'PURCHASE_TRANSACTION_TAX_QUOTE'

836: INTO l_tax_amount
837: FROM ZX_REC_NREC_DIST_GT
838: WHERE application_id = IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID --'8407'
839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'
840: AND event_class_code =IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --'PURCHASE_TRANSACTION_TAX_QUOTE'
841: AND trx_id = P_CC_Header_Rec.cc_header_id
842: AND trx_line_id = p_line_id
843: AND trx_level_type = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --'LINE'
844: AND recoverable_flag = 'N';

Line 843: AND trx_level_type = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --'LINE'

839: AND entity_code =IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE --'IGC_CC_HEADERS'
840: AND event_class_code =IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE --'PURCHASE_TRANSACTION_TAX_QUOTE'
841: AND trx_id = P_CC_Header_Rec.cc_header_id
842: AND trx_line_id = p_line_id
843: AND trx_level_type = IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE --'LINE'
844: AND recoverable_flag = 'N';
845:
846: IF (g_debug_mode = 'Y') THEN
847: Put_Debug_Msg (l_full_path,p_debug_msg => 'Calculated Tax amount : '||l_tax_amount);

Line 898: p_ref_doc_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,

894:
895: BEGIN
896:
897: ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification(
898: p_ref_doc_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,
899: p_ref_doc_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,
900: p_ref_doc_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,
901: p_ref_doc_trx_id => p_cc_header_id,
902: p_ref_doc_line_id => p_cc_line_id,

Line 899: p_ref_doc_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,

895: BEGIN
896:
897: ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification(
898: p_ref_doc_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,
899: p_ref_doc_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,
900: p_ref_doc_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,
901: p_ref_doc_trx_id => p_cc_header_id,
902: p_ref_doc_line_id => p_cc_line_id,
903: p_ref_doc_trx_level_type => IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE,

Line 900: p_ref_doc_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,

896:
897: ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification(
898: p_ref_doc_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,
899: p_ref_doc_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,
900: p_ref_doc_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,
901: p_ref_doc_trx_id => p_cc_header_id,
902: p_ref_doc_line_id => p_cc_line_id,
903: p_ref_doc_trx_level_type => IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE,
904: p_vendor_id => p_vendor_id,

Line 903: p_ref_doc_trx_level_type => IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE,

899: p_ref_doc_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,
900: p_ref_doc_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,
901: p_ref_doc_trx_id => p_cc_header_id,
902: p_ref_doc_line_id => p_cc_line_id,
903: p_ref_doc_trx_level_type => IGC_ETAX_UTIL_PKG.IGC_TRX_LEVEL_TYPE,
904: p_vendor_id => p_vendor_id,
905: p_vendor_site_id => p_vendor_site_id,
906: p_code_combination_id => p_code_combination_id,
907: p_concatenated_segments => p_concatenated_segments,

Line 921: p_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,

917: p_legal_entity_id => p_legal_entity_id,
918: APPL_SHORT_NAME => 'IGC',
919: FUNC_SHORT_NAME => 'NONE',
920: p_calling_sequence => p_calling_sequence,
921: p_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,
922: p_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,
923: p_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,
924: p_internal_organization_id => p_internal_organization_id);
925:

Line 922: p_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,

918: APPL_SHORT_NAME => 'IGC',
919: FUNC_SHORT_NAME => 'NONE',
920: p_calling_sequence => p_calling_sequence,
921: p_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,
922: p_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,
923: p_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,
924: p_internal_organization_id => p_internal_organization_id);
925:
926:

Line 923: p_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,

919: FUNC_SHORT_NAME => 'NONE',
920: p_calling_sequence => p_calling_sequence,
921: p_event_class_code => IGC_ETAX_UTIL_PKG.IGC_EVENT_CLASS_CODE,
922: p_entity_code => IGC_ETAX_UTIL_PKG.IGC_ENTITY_CODE,
923: p_application_id => IGC_ETAX_UTIL_PKG.IGC_APPLICATION_ID,
924: p_internal_organization_id => p_internal_organization_id);
925:
926:
927: EXCEPTION

Line 954: END IGC_ETAX_UTIL_PKG;

950: END IF;
951: END Put_Debug_Msg;
952:
953:
954: END IGC_ETAX_UTIL_PKG;