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.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 886: IF zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index) is NULL then

882: /* -- Commented out the logic that raises error when default taxation country is not available.
883: -- Instead, the calling API will verify that default_taxation_country is available before
884: -- calling this API.
885:
886: IF zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index) is NULL then
887: -- Check with TSRM that default_taxation_country is always populated;
888:
889: IF (g_level_unexpected >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_unexpected,

Line 907: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);

903: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
904: -- If the line is a memo line, then populate Transaction Business Category and
905: -- Product Category from ar_memo_lines.
906:
907: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);
908:
909: IF (g_level_statement >= g_current_runtime_level ) THEN
910: FND_LOG.STRING(g_level_statement,
911: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',

Line 917: IF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL

913: Defaulting for Transaction Business Category and Product Category,
914: Product Fiscal Classification');
915: END IF;
916:
917: IF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL
918: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NOT NULL THEN
919:
920: -- It is an inveontory item; Populate product_fisc_classification and trx_business_category
921: -- from mtl_system_items.

Line 918: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NOT NULL THEN

914: Product Fiscal Classification');
915: END IF;
916:
917: IF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL
918: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NOT NULL THEN
919:
920: -- It is an inveontory item; Populate product_fisc_classification and trx_business_category
921: -- from mtl_system_items.
922: If zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) is NULL then

Line 922: If zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) is NULL then

918: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NOT NULL THEN
919:
920: -- It is an inveontory item; Populate product_fisc_classification and trx_business_category
921: -- from mtl_system_items.
922: If zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) is NULL then
923:
924: IF g_delimiter is NULL then
925: OPEN c_delimiter;
926: FETCH c_delimiter INTO g_delimiter;

Line 934: ' Tax Event Class Code = '||zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)||

930: IF (g_level_statement >= g_current_runtime_level ) THEN
931: FND_LOG.STRING(g_level_statement,
932: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
933: 'Transaction Business Category is NULL. Defaulting Transaction Business Category'||
934: ' Tax Event Class Code = '||zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)||
935: ' Delimiter = '||g_delimiter);
936: END IF;
937:
938:

Line 941: zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)

937:
938:
939: SELECT
940: DECODE(items.global_attribute2, NULL, items.global_attribute2,
941: zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)
942: ||g_delimiter||items.global_attribute2) trx_business_category
943: INTO
944: l_trx_business_category
945: FROM

Line 948: AND inventory_item_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);

944: l_trx_business_category
945: FROM
946: mtl_system_items items
947: WHERE organization_id = l_organization_id
948: AND inventory_item_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
949:
950:
951: IF (g_level_statement >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_statement,

Line 957: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=

953: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
954: 'After defaulting: l_trx_business_category = '||l_trx_business_category);
955: END IF;
956:
957: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=
958: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),
959: l_trx_business_category);
960: End If;
961:

Line 958: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),

954: 'After defaulting: l_trx_business_category = '||l_trx_business_category);
955: END IF;
956:
957: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=
958: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),
959: l_trx_business_category);
960: End If;
961:
962: Begin

Line 963: If zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) is NULL then

959: l_trx_business_category);
960: End If;
961:
962: Begin
963: If zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) is NULL then
964:
965:
966: IF (g_level_statement >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_statement,

Line 970: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index));

966: IF (g_level_statement >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_statement,
968: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
969: 'Country code: '||
970: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index));
971: END IF;
972:
973:
974: SELECT

Line 983: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index)

979: zx_fc_product_fiscal_v fc,
980: mtl_item_categories mic
981: WHERE
982: ((fc.country_code =
983: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index)
984: AND fc.country_code in ('AR', 'BR', 'CO'))
985: or
986: fc.country_code is NULL
987: )

Line 988: AND zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index)

984: AND fc.country_code in ('AR', 'BR', 'CO'))
985: or
986: fc.country_code is NULL
987: )
988: AND zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index)
989: = mic.inventory_item_id
990: AND mic.organization_id = l_organization_id
991: AND mic.category_id = fc.category_id
992: AND mic.category_set_id = fc.category_set_id

Line 1002: zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) :=

998: WHERE fiscal_classification_code = fc.classification_code
999: AND enabled_flag = 'Y')
1000: AND rownum = 1; -- Bug 5701599
1001:
1002: zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) :=
1003: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index),
1004: l_product_fisc_class);
1005: End If;
1006: Exception

Line 1003: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index),

999: AND enabled_flag = 'Y')
1000: AND rownum = 1; -- Bug 5701599
1001:
1002: zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) :=
1003: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index),
1004: l_product_fisc_class);
1005: End If;
1006: Exception
1007: when no_data_found then

Line 1017: ELSIF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL

1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: -- app_exception.raise_exception;
1015: End;
1016:
1017: ELSIF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL
1018: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NULL THEN
1019:
1020: -- In case where the line is a memo line, default the Transaction Business Category
1021: -- and Product Category from ar_memo_lines.

Line 1018: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NULL THEN

1014: -- app_exception.raise_exception;
1015: End;
1016:
1017: ELSIF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL
1018: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NULL THEN
1019:
1020: -- In case where the line is a memo line, default the Transaction Business Category
1021: -- and Product Category from ar_memo_lines.
1022:

Line 1023: IF (zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) IS NULL

1019:
1020: -- In case where the line is a memo line, default the Transaction Business Category
1021: -- and Product Category from ar_memo_lines.
1022:
1023: IF (zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) IS NULL
1024: OR zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) IS NULL)
1025: then
1026:
1027: Begin

Line 1024: OR zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) IS NULL)

1020: -- In case where the line is a memo line, default the Transaction Business Category
1021: -- and Product Category from ar_memo_lines.
1022:
1023: IF (zx_global_structures_pkg.trx_line_dist_tbl.product_fisc_classification(p_trx_line_index) IS NULL
1024: OR zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) IS NULL)
1025: then
1026:
1027: Begin
1028:

Line 1038: zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)

1034:
1035:
1036: SELECT
1037: DECODE(Memo.global_attribute2, NULL, Memo.global_attribute2,
1038: zx_global_structures_pkg.trx_line_dist_tbl.tax_event_class_code(p_trx_line_index)
1039: ||g_delimiter||Memo.global_attribute2) trx_business_category,
1040: Memo.tax_product_category product_category
1041: INTO
1042: l_trx_business_category,

Line 1046: WHERE memo_line_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);

1042: l_trx_business_category,
1043: l_product_category
1044: FROM
1045: ar_memo_lines Memo
1046: WHERE memo_line_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
1047:
1048: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=
1049: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),
1050: l_trx_business_category);

Line 1048: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=

1044: FROM
1045: ar_memo_lines Memo
1046: WHERE memo_line_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
1047:
1048: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=
1049: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),
1050: l_trx_business_category);
1051:
1052: zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index) :=

Line 1049: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),

1045: ar_memo_lines Memo
1046: WHERE memo_line_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
1047:
1048: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=
1049: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),
1050: l_trx_business_category);
1051:
1052: zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index) :=
1053: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index),

Line 1052: zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index) :=

1048: zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) :=
1049: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),
1050: l_trx_business_category);
1051:
1052: zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index) :=
1053: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index),
1054: l_product_category);
1055:
1056: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1053: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index),

1049: nvl(zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index),
1050: l_trx_business_category);
1051:
1052: zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index) :=
1053: nvl(zx_global_structures_pkg.trx_line_dist_tbl.product_category(p_trx_line_index),
1054: l_product_category);
1055:
1056: IF (g_level_statement >= g_current_runtime_level ) THEN
1057: FND_LOG.STRING(g_level_statement,