DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_API_PUB

Line 133: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

129: );
130:
131: PROCEDURE determine_round_level_and_rule(
132: p_Party_Type_Code IN VARCHAR2,
133: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
134: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
135: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
136: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
137: p_return_status OUT NOCOPY VARCHAR2,

Line 150: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

146: );
147:
148: PROCEDURE determine_rounding_rule(
149: p_trx_line_index IN BINARY_INTEGER,
150: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
151: p_party_type_code IN VARCHAR2,
152: p_tax_regime_code IN VARCHAR2,
153: p_tax IN VARCHAR2,
154: p_jurisdiction_code IN VARCHAR2,

Line 367: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

363: p_sum_unrnd_tax_amt OUT NOCOPY NUMBER,
364: p_sum_rnd_tax_amt OUT NOCOPY NUMBER,
365: p_sum_rnd_tax_curr OUT NOCOPY NUMBER,
366: p_sum_rnd_funcl_curr OUT NOCOPY NUMBER,
367: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
368: p_return_status OUT NOCOPY VARCHAR2,
369: p_error_buffer OUT NOCOPY VARCHAR2
370: );
371:

Line 462: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

458: PROCEDURE convert_and_round_lin_lvl_curr(
459: p_conversion_rate IN NUMBER,
460: p_conversion_type IN VARCHAR2,
461: p_conversion_date IN DATE,
462: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
463: p_return_status OUT NOCOPY VARCHAR2,
464: p_error_buffer OUT NOCOPY VARCHAR2
465: );
466:

Line 471: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

467: PROCEDURE convert_and_round_hdr_lvl_curr(
468: p_conversion_rate IN NUMBER,
469: p_conversion_type IN VARCHAR2,
470: p_conversion_date IN DATE,
471: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
472: p_return_status OUT NOCOPY VARCHAR2,
473: p_error_buffer OUT NOCOPY VARCHAR2
474: );
475:

Line 478: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

474: );
475:
476: PROCEDURE get_round_level_ptp_id(
477: p_Party_Type_Code IN VARCHAR2,
478: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
479: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_error_buffer OUT NOCOPY VARCHAR2
482: );

Line 1103: ZX_API_PUB.add_msg(

1099: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1100: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);
1101: FND_MESSAGE.SET_TOKEN('TRX_CURRENCY_CONV_DATE',p_trx_conversion_date);
1102: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1103: ZX_API_PUB.add_msg(
1104: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1105: ELSE
1106: FND_MSG_PUB.Add;
1107: END IF;

Line 1188: ZX_API_PUB.add_msg(

1184: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: p_error_buffer := 'EURO code not found in FND_CURRENCIES';
1186: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1187: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1188: ZX_API_PUB.add_msg(
1189: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1190: ELSE
1191: FND_MSG_PUB.Add;
1192: END IF;

Line 1433: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

1429: -- rounding level code and rounding rule code from zx_party_tax_profile
1430: --
1431: PROCEDURE determine_round_level_and_rule(
1432: p_Party_Type_Code IN VARCHAR2,
1433: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1434: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
1435: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
1436: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1437: p_return_status OUT NOCOPY VARCHAR2,

Line 1667: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

1663: --
1664: --
1665: PROCEDURE determine_rounding_rule(
1666: p_trx_line_index IN BINARY_INTEGER,
1667: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1668: p_party_type_code IN VARCHAR2,
1669: p_tax_regime_code IN VARCHAR2,
1670: p_tax IN VARCHAR2,
1671: p_jurisdiction_code IN VARCHAR2,

Line 1900: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

1896: -- This procedure gets the rounding rule through party hierachy
1897: --
1898: PROCEDURE get_rounding_rule(
1899: p_trx_line_index IN BINARY_INTEGER,
1900: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1901: p_tax_regime_code IN VARCHAR2,
1902: p_tax IN VARCHAR2,
1903: p_jurisdiction_code IN VARCHAR2,
1904: p_tax_determine_date IN DATE,

Line 2042: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

2038: -- This procedure determines the party_tax_profile_id.
2039: --
2040: PROCEDURE get_round_level_ptp_id(
2041: p_Party_Type_Code IN VARCHAR2,
2042: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2043: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
2044: p_return_status OUT NOCOPY VARCHAR2,
2045: p_error_buffer OUT NOCOPY VARCHAR2
2046: )

Line 2135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

2131: -- and the rounding_rule based on rounding party hierarchy
2132: --
2133:
2134: PROCEDURE get_rounding_level_and_rule(
2135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2136: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2137: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2138: p_rnd_lvl_party_tax_prof_id
2139: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,

Line 2364: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN

2360:
2361: -- determine account, account_site, account_site_use information
2362: -- from first transaction line
2363: --
2364: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN
2365: OPEN get_acct_site_info_csr;
2366: FETCH get_acct_site_info_csr INTO
2367: l_ship_third_pty_acct_id, l_bill_third_pty_acct_id,
2368: l_ship_third_pty_acct_site_id, l_bill_third_pty_acct_site_id,

Line 2374: IF ( ZX_API_PUB.G_DATA_TRANSFER_MODE = 'WIN' ) THEN --Bug 5103375

2370: l_tax_determine_date;
2371: CLOSE get_acct_site_info_csr;
2372: ELSE
2373:
2374: IF ( ZX_API_PUB.G_DATA_TRANSFER_MODE = 'WIN' ) THEN --Bug 5103375
2375: OPEN get_lines_det_factors;
2376: FETCH get_lines_det_factors INTO
2377: l_ship_third_pty_acct_id, l_bill_third_pty_acct_id,
2378: l_ship_third_pty_acct_site_id, l_bill_third_pty_acct_site_id,

Line 5101: -- ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

5097: -- FND_MESSAGE.SET_TOKEN('TO_CURRENCY', l_funcl_currency_code);
5098: -- FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_currency_conversion_date);
5099:
5100: -- IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5101: -- ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5102: -- ELSE
5103: -- FND_MSG_PUB.Add;
5104: -- END IF;
5105:

Line 5366: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

5362: p_sum_unrnd_tax_amt OUT NOCOPY NUMBER,
5363: p_sum_rnd_tax_amt OUT NOCOPY NUMBER,
5364: p_sum_rnd_tax_curr OUT NOCOPY NUMBER,
5365: p_sum_rnd_funcl_curr OUT NOCOPY NUMBER,
5366: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5367: p_return_status OUT NOCOPY VARCHAR2,
5368: p_error_buffer OUT NOCOPY VARCHAR2
5369: )
5370: IS

Line 5656: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

5652: p_error_buffer := 'Tax Amount can not be NULL';
5653: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
5654: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',p_error_buffer);
5655: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5656: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5657: ELSE
5658: FND_MSG_PUB.Add;
5659: END IF;
5660: ELSIF p_taxable_amt IS NULL THEN

Line 5666: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

5662: p_error_buffer := 'Taxable Amount can not be NULL';
5663: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
5664: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',p_error_buffer);
5665: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5666: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5667: ELSE
5668: FND_MSG_PUB.Add;
5669: END IF;
5670: END IF;

Line 5679: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

5675: p_error_buffer := 'Trx Currency Code can not be NULL';
5676: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
5677: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',p_error_buffer);
5678: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5679: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5680: ELSE
5681: FND_MSG_PUB.Add;
5682: END IF;
5683: ELSIF p_tax_currency_code IS NULL THEN

Line 5689: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

5685: p_error_buffer := 'Tax Currency Code can not be NULL';
5686: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_TEXT');
5687: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',p_error_buffer);
5688: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5689: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5690: ELSE
5691: FND_MSG_PUB.Add;
5692: END IF;
5693: ELSIF p_tax_amt_tax_curr IS NULL THEN

Line 5702: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

5698: p_return_status := FND_API.G_RET_STS_ERROR;
5699: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5700: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5701: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5702: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5703: ELSE
5704: FND_MSG_PUB.Add;
5705: END IF;
5706: p_error_buffer := 'tax_amt_tax_curr can not be NULL';

Line 5717: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

5713: p_return_status := FND_API.G_RET_STS_ERROR;
5714: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5715: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5716: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5717: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5718: ELSE
5719: FND_MSG_PUB.Add;
5720: END IF;
5721: p_error_buffer := 'taxable_amt_tax_curr can not be NULL';

Line 5972: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

5968: --
5969: -- Rewritten by lxzhang for bug fix 5417887
5970:
5971: PROCEDURE perform_rounding(
5972: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5973: p_return_status OUT NOCOPY VARCHAR2,
5974: p_error_buffer OUT NOCOPY VARCHAR2
5975: )
5976: IS

Line 6902: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

6898: PROCEDURE convert_and_round_lin_lvl_curr(
6899: p_conversion_rate IN NUMBER,
6900: p_conversion_type IN VARCHAR2,
6901: p_conversion_date IN DATE,
6902: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6903: p_return_status OUT NOCOPY VARCHAR2,
6904: p_error_buffer OUT NOCOPY VARCHAR2
6905: )
6906: IS

Line 7114: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

7110: PROCEDURE convert_and_round_hdr_lvl_curr(
7111: p_conversion_rate IN NUMBER,
7112: p_conversion_type IN VARCHAR2,
7113: p_conversion_date IN DATE,
7114: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7115: p_return_status OUT NOCOPY VARCHAR2,
7116: p_error_buffer OUT NOCOPY VARCHAR2
7117: )
7118: IS

Line 7667: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

7663: PROCEDURE convert_and_round_curr(
7664: p_conversion_rate IN OUT NOCOPY NUMBER,
7665: p_conversion_type IN VARCHAR2,
7666: p_conversion_date IN DATE,
7667: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7668: p_return_status OUT NOCOPY VARCHAR2,
7669: p_error_buffer OUT NOCOPY VARCHAR2
7670: )
7671: IS

Line 7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;

7768: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7769: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7775: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7776: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;