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.ZX_TDS_TAX_LINES_POPU_PKG dependencies on FND_API

Line 47: p_return_status := FND_API.G_RET_STS_SUCCESS;

43:
44: --
45: -- init error buffer and return status
46: --
47: p_return_status := FND_API.G_RET_STS_SUCCESS;
48: p_error_buffer := NULL;
49:
50: --
51: -- check if begin_index and end_index have values

Line 530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

526: END IF;
527:
528: EXCEPTION
529: WHEN OTHERS THEN
530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
532:
533: IF (g_level_unexpected >= g_current_runtime_level ) THEN
534: FND_LOG.STRING(g_level_unexpected,

Line 567: p_return_status := FND_API.G_RET_STS_SUCCESS;

563: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_tax_lines.BEGIN',
564: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_tax_lines(+)');
565: END IF;
566:
567: p_return_status := FND_API.G_RET_STS_SUCCESS;
568: p_error_buffer := NULL;
569:
570:
571: /*

Line 591: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

587: populate_mandatory_columns(p_tax_line_rec,
588: p_return_status,
589: p_error_buffer);
590:
591: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
592: RETURN;
593: END IF;
594:
595: check_mandatory_columns(p_tax_line_rec,

Line 608: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

604: END IF;
605:
606: EXCEPTION
607: WHEN OTHERS THEN
608: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
610:
611: IF (g_level_unexpected >= g_current_runtime_level ) THEN
612: FND_LOG.STRING(g_level_unexpected,

Line 719: p_return_status := FND_API.G_RET_STS_SUCCESS;

715: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns.BEGIN',
716: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_mandatory_columns(+)');
717: END IF;
718:
719: p_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: --
722: -- populate tax_line_id if it is null
723: --

Line 772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: END IF;
769:
770: EXCEPTION
771: WHEN OTHERS THEN
772: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
774:
775: IF (g_level_unexpected >= g_current_runtime_level ) THEN
776: FND_LOG.STRING(g_level_unexpected,

Line 809: p_return_status := FND_API.G_RET_STS_SUCCESS;

805: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns.BEGIN',
806: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns(+)');
807: END IF;
808:
809: p_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: --
812: -- check mandatory columns for all tax lines
813: --

Line 817: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

813: --
814: check_mandatory_columns_all(p_tax_line_rec,
815: p_return_status,
816: p_error_buffer);
817: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
818: NVL(p_tax_line_rec.Manually_Entered_Flag,'N') = 'N') THEN
819: check_non_manual_tax_line(p_tax_line_rec,
820: p_return_status,
821: p_error_buffer);

Line 838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: END IF;
835:
836: EXCEPTION
837: WHEN OTHERS THEN
838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
840:
841: IF (g_level_unexpected >= g_current_runtime_level ) THEN
842: FND_LOG.STRING(g_level_unexpected,

Line 875: p_return_status := FND_API.G_RET_STS_SUCCESS;

871: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all.BEGIN',
872: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns_all(+)');
873: END IF;
874:
875: p_return_status := FND_API.G_RET_STS_SUCCESS;
876:
877: IF p_tax_line_rec.application_id IS NULL THEN
878: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: p_error_buffer := 'application_id can not be NULL';

Line 878: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

874:
875: p_return_status := FND_API.G_RET_STS_SUCCESS;
876:
877: IF p_tax_line_rec.application_id IS NULL THEN
878: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: p_error_buffer := 'application_id can not be NULL';
880: ELSIF p_tax_line_rec.entity_code IS NULL THEN
881: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: p_error_buffer := 'entity_code can not be NULL';

Line 881: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

877: IF p_tax_line_rec.application_id IS NULL THEN
878: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: p_error_buffer := 'application_id can not be NULL';
880: ELSIF p_tax_line_rec.entity_code IS NULL THEN
881: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: p_error_buffer := 'entity_code can not be NULL';
883: ELSIF p_tax_line_rec.event_class_code IS NULL THEN
884: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: p_error_buffer := 'event_class_code can not be NULL';

Line 884: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

880: ELSIF p_tax_line_rec.entity_code IS NULL THEN
881: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: p_error_buffer := 'entity_code can not be NULL';
883: ELSIF p_tax_line_rec.event_class_code IS NULL THEN
884: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: p_error_buffer := 'event_class_code can not be NULL';
886: ELSIF p_tax_line_rec.event_type_code IS NULL THEN
887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: p_error_buffer := 'event_type_code can not be NULL';

Line 887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

883: ELSIF p_tax_line_rec.event_class_code IS NULL THEN
884: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: p_error_buffer := 'event_class_code can not be NULL';
886: ELSIF p_tax_line_rec.event_type_code IS NULL THEN
887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: p_error_buffer := 'event_type_code can not be NULL';
889: ELSIF p_tax_line_rec.trx_id IS NULL THEN
890: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
891: p_error_buffer := 'trx_id can not be NULL';

Line 890: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

886: ELSIF p_tax_line_rec.event_type_code IS NULL THEN
887: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: p_error_buffer := 'event_type_code can not be NULL';
889: ELSIF p_tax_line_rec.trx_id IS NULL THEN
890: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
891: p_error_buffer := 'trx_id can not be NULL';
892: ELSIF p_tax_line_rec.trx_line_id IS NULL THEN
893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: p_error_buffer := 'trx_line_id can not be NULL';

Line 893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

889: ELSIF p_tax_line_rec.trx_id IS NULL THEN
890: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
891: p_error_buffer := 'trx_id can not be NULL';
892: ELSIF p_tax_line_rec.trx_line_id IS NULL THEN
893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: p_error_buffer := 'trx_line_id can not be NULL';
895: ELSIF p_tax_line_rec.trx_level_type IS NULL THEN
896: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: p_error_buffer := 'trx_level_type can not be NULL';

Line 896: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

892: ELSIF p_tax_line_rec.trx_line_id IS NULL THEN
893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: p_error_buffer := 'trx_line_id can not be NULL';
895: ELSIF p_tax_line_rec.trx_level_type IS NULL THEN
896: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: p_error_buffer := 'trx_level_type can not be NULL';
898:
899: -- Bug#4572001- content_owner_id can be NULL
900: -- ELSIF p_tax_line_rec.content_owner_id IS NULL THEN

Line 901: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

897: p_error_buffer := 'trx_level_type can not be NULL';
898:
899: -- Bug#4572001- content_owner_id can be NULL
900: -- ELSIF p_tax_line_rec.content_owner_id IS NULL THEN
901: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- p_error_buffer := 'content_owner_id can not be NULL';
903:
904: ELSIF p_tax_line_rec.tax_regime_id IS NULL THEN
905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

901: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- p_error_buffer := 'content_owner_id can not be NULL';
903:
904: ELSIF p_tax_line_rec.tax_regime_id IS NULL THEN
905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: p_error_buffer := 'tax_regime_id can not be NULL';
907: ELSIF p_tax_line_rec.tax_regime_code IS NULL THEN
908: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: p_error_buffer := 'tax_regime_code can not be NULL';

Line 908: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

904: ELSIF p_tax_line_rec.tax_regime_id IS NULL THEN
905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: p_error_buffer := 'tax_regime_id can not be NULL';
907: ELSIF p_tax_line_rec.tax_regime_code IS NULL THEN
908: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: p_error_buffer := 'tax_regime_code can not be NULL';
910: ELSIF p_tax_line_rec.tax_id IS NULL THEN
911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: p_error_buffer := 'tax_id can not be NULL';

Line 911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: ELSIF p_tax_line_rec.tax_regime_code IS NULL THEN
908: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: p_error_buffer := 'tax_regime_code can not be NULL';
910: ELSIF p_tax_line_rec.tax_id IS NULL THEN
911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: p_error_buffer := 'tax_id can not be NULL';
913: ELSIF p_tax_line_rec.tax IS NULL THEN
914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: p_error_buffer := 'tax can not be NULL';

Line 914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

910: ELSIF p_tax_line_rec.tax_id IS NULL THEN
911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: p_error_buffer := 'tax_id can not be NULL';
913: ELSIF p_tax_line_rec.tax IS NULL THEN
914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: p_error_buffer := 'tax can not be NULL';
916: ELSIF p_tax_line_rec.tax_status_id IS NULL THEN
917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: p_error_buffer := 'tax_status_id can not be NULL';

Line 917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: ELSIF p_tax_line_rec.tax IS NULL THEN
914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: p_error_buffer := 'tax can not be NULL';
916: ELSIF p_tax_line_rec.tax_status_id IS NULL THEN
917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: p_error_buffer := 'tax_status_id can not be NULL';
919: ELSIF p_tax_line_rec.tax_status_code IS NULL THEN
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: p_error_buffer := 'tax_status_code can not be NULL';

Line 920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

916: ELSIF p_tax_line_rec.tax_status_id IS NULL THEN
917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: p_error_buffer := 'tax_status_id can not be NULL';
919: ELSIF p_tax_line_rec.tax_status_code IS NULL THEN
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: p_error_buffer := 'tax_status_code can not be NULL';
922: END IF;
923:
924: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 938: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

934: END IF;
935:
936: EXCEPTION
937: WHEN OTHERS THEN
938: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
940:
941: IF (g_level_unexpected >= g_current_runtime_level ) THEN
942: FND_LOG.STRING(g_level_unexpected,

Line 977: p_return_status := FND_API.G_RET_STS_SUCCESS;

973: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line.BEGIN',
974: 'ZX_TDS_TAX_LINES_POPU_PKG: check_non_manual_tax_line(+)');
975: END IF;
976:
977: p_return_status := FND_API.G_RET_STS_SUCCESS;
978:
979: IF p_tax_line_rec.trx_date IS NULL THEN
980: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: p_error_buffer := 'trx_date can not be NULL';

Line 980: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

976:
977: p_return_status := FND_API.G_RET_STS_SUCCESS;
978:
979: IF p_tax_line_rec.trx_date IS NULL THEN
980: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: p_error_buffer := 'trx_date can not be NULL';
982: --ELSIF p_tax_line_rec.trx_line_date IS NULL THEN
983: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: -- p_error_buffer := 'trx_line_date can not be NULL';

Line 983: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

979: IF p_tax_line_rec.trx_date IS NULL THEN
980: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: p_error_buffer := 'trx_date can not be NULL';
982: --ELSIF p_tax_line_rec.trx_line_date IS NULL THEN
983: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: -- p_error_buffer := 'trx_line_date can not be NULL';
985: ELSIF p_tax_line_rec.ledger_id IS NULL THEN
986: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: p_error_buffer := 'ledger_id can not be NULL';

Line 986: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

982: --ELSIF p_tax_line_rec.trx_line_date IS NULL THEN
983: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: -- p_error_buffer := 'trx_line_date can not be NULL';
985: ELSIF p_tax_line_rec.ledger_id IS NULL THEN
986: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: p_error_buffer := 'ledger_id can not be NULL';
988:
989: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
990: ELSIF p_tax_line_rec.establishment_id IS NULL THEN

Line 991: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

987: p_error_buffer := 'ledger_id can not be NULL';
988:
989: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
990: ELSIF p_tax_line_rec.establishment_id IS NULL THEN
991: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
992: p_error_buffer := 'establishment_id can not be NULL';
993: */
994: ELSIF p_tax_line_rec.legal_entity_id IS NULL THEN
995: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 995: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

991: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
992: p_error_buffer := 'establishment_id can not be NULL';
993: */
994: ELSIF p_tax_line_rec.legal_entity_id IS NULL THEN
995: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: p_error_buffer := 'legal_entity_id can not be NULL';
997: ELSIF p_tax_line_rec.tax_rate_id IS NULL THEN
998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999: p_error_buffer := 'tax_rate_id can not be NULL';

Line 998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

994: ELSIF p_tax_line_rec.legal_entity_id IS NULL THEN
995: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: p_error_buffer := 'legal_entity_id can not be NULL';
997: ELSIF p_tax_line_rec.tax_rate_id IS NULL THEN
998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999: p_error_buffer := 'tax_rate_id can not be NULL';
1000: ELSIF p_tax_line_rec.tax_rate_code IS NULL THEN
1001: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002: p_error_buffer := 'tax_rate_code can not be NULL';

Line 1001: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

997: ELSIF p_tax_line_rec.tax_rate_id IS NULL THEN
998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
999: p_error_buffer := 'tax_rate_id can not be NULL';
1000: ELSIF p_tax_line_rec.tax_rate_code IS NULL THEN
1001: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002: p_error_buffer := 'tax_rate_code can not be NULL';
1003: ELSIF p_tax_line_rec.tax_rate IS NULL THEN
1004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: p_error_buffer := 'tax_rate can not be NULL';

Line 1004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1000: ELSIF p_tax_line_rec.tax_rate_code IS NULL THEN
1001: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1002: p_error_buffer := 'tax_rate_code can not be NULL';
1003: ELSIF p_tax_line_rec.tax_rate IS NULL THEN
1004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: p_error_buffer := 'tax_rate can not be NULL';
1006:
1007: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1008: ELSIF p_tax_line_rec.tax_apportionment_line_number IS NULL THEN

Line 1009: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1005: p_error_buffer := 'tax_rate can not be NULL';
1006:
1007: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1008: ELSIF p_tax_line_rec.tax_apportionment_line_number IS NULL THEN
1009: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: p_error_buffer := 'tax_apportionment_line_number can not be NULL';
1011: */
1012: ELSIF p_tax_line_rec.tax_date IS NULL THEN
1013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1009: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: p_error_buffer := 'tax_apportionment_line_number can not be NULL';
1011: */
1012: ELSIF p_tax_line_rec.tax_date IS NULL THEN
1013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: p_error_buffer := 'tax_date can not be NULL';
1015: ELSIF p_tax_line_rec.tax_determine_date IS NULL THEN
1016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: p_error_buffer := 'tax_determine_date can not be NULL';

Line 1016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1012: ELSIF p_tax_line_rec.tax_date IS NULL THEN
1013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: p_error_buffer := 'tax_date can not be NULL';
1015: ELSIF p_tax_line_rec.tax_determine_date IS NULL THEN
1016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: p_error_buffer := 'tax_determine_date can not be NULL';
1018: ELSIF p_tax_line_rec.tax_point_date IS NULL THEN
1019: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: p_error_buffer := 'tax_point_date can not be NULL';

Line 1019: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1015: ELSIF p_tax_line_rec.tax_determine_date IS NULL THEN
1016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: p_error_buffer := 'tax_determine_date can not be NULL';
1018: ELSIF p_tax_line_rec.tax_point_date IS NULL THEN
1019: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: p_error_buffer := 'tax_point_date can not be NULL';
1021:
1022: END IF;
1023:

Line 1038: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034: END IF;
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1040:
1041: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1042: FND_LOG.STRING(g_level_unexpected,

Line 1087: p_return_status := FND_API.G_RET_STS_SUCCESS;

1083: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',
1084: 'p_end_index = ' || to_char(p_end_index));
1085: END IF;
1086:
1087: p_return_status := FND_API.G_RET_STS_SUCCESS;
1088: p_error_buffer := NULL;
1089:
1090: --
1091: -- check if begin_index and end_index have values

Line 1110: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1106: p_end_index,
1107: p_return_status,
1108: p_error_buffer);
1109:
1110: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1111: RETURN;
1112: END IF;
1113:
1114: chk_mandatory_col_for_trx_line(

Line 1120: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1116: p_end_index,
1117: p_return_status,
1118: p_error_buffer);
1119:
1120: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1121: RETURN;
1122: END IF;
1123:
1124: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1134: END IF;
1135:
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1140:
1141: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1142: FND_LOG.STRING(g_level_unexpected,

Line 1186: p_return_status := FND_API.G_RET_STS_SUCCESS;

1182: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1183: 'p_end_index = ' || to_char(p_end_index));
1184: END IF;
1185:
1186: p_return_status := FND_API.G_RET_STS_SUCCESS;
1187:
1188: --bug8517610
1189: l_process_offset_flag := 'N';
1190:

Line 1330: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1326: END IF;
1327:
1328: EXCEPTION
1329: WHEN OTHERS THEN
1330: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1332:
1333: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1334: FND_LOG.STRING(g_level_unexpected,

Line 1376: p_return_status := FND_API.G_RET_STS_SUCCESS;

1372: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1373: 'p_end_index = ' || to_char(p_end_index));
1374: END IF;
1375:
1376: p_return_status := FND_API.G_RET_STS_SUCCESS;
1377:
1378: --
1379: -- check if begin_index and end_index have values
1380: --

Line 1401: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1397: p_end_index,
1398: p_return_status,
1399: p_error_buffer);
1400:
1401: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1402: RETURN;
1403: END IF;
1404:
1405: --

Line 1414: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1410: p_begin_index,
1411: p_end_index,
1412: p_return_status,
1413: p_error_buffer);
1414: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1415: RETURN;
1416: END IF;
1417:
1418: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1432: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1428: END IF;
1429:
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1434:
1435: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1436: FND_LOG.STRING(g_level_unexpected,

Line 1476: p_return_status := FND_API.G_RET_STS_SUCCESS;

1472: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1473: 'p_end_index = ' || to_char(p_end_index));
1474: END IF;
1475:
1476: p_return_status := FND_API.G_RET_STS_SUCCESS;
1477:
1478: --
1479: -- check if begin_index and end_index have values
1480: --

Line 1501: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1497: 'processing detail line index = ' || to_char(i));
1498: END IF;
1499:
1500: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).application_id IS NULL THEN
1501: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: p_error_buffer := 'application_id can not be NULL';
1503: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).entity_code IS NULL THEN
1504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: p_error_buffer := 'entity_code can not be NULL';

Line 1504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1500: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).application_id IS NULL THEN
1501: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: p_error_buffer := 'application_id can not be NULL';
1503: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).entity_code IS NULL THEN
1504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: p_error_buffer := 'entity_code can not be NULL';
1506: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_class_code IS NULL THEN
1507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: p_error_buffer := 'event_class_code can not be NULL';

Line 1507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1503: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).entity_code IS NULL THEN
1504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: p_error_buffer := 'entity_code can not be NULL';
1506: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_class_code IS NULL THEN
1507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: p_error_buffer := 'event_class_code can not be NULL';
1509: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_type_code IS NULL THEN
1510: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: p_error_buffer := 'event_type_code can not be NULL';

Line 1510: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1506: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_class_code IS NULL THEN
1507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: p_error_buffer := 'event_class_code can not be NULL';
1509: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_type_code IS NULL THEN
1510: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: p_error_buffer := 'event_type_code can not be NULL';
1512: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_id IS NULL THEN
1513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: p_error_buffer := 'trx_id can not be NULL';

Line 1513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1509: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_type_code IS NULL THEN
1510: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: p_error_buffer := 'event_type_code can not be NULL';
1512: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_id IS NULL THEN
1513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: p_error_buffer := 'trx_id can not be NULL';
1515: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id IS NULL THEN
1516: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: p_error_buffer := 'trx_line_id can not be NULL';

Line 1516: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1512: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_id IS NULL THEN
1513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: p_error_buffer := 'trx_id can not be NULL';
1515: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id IS NULL THEN
1516: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: p_error_buffer := 'trx_line_id can not be NULL';
1518: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type IS NULL THEN
1519: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: p_error_buffer := 'trx_level_type can not be NULL';

Line 1519: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1515: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id IS NULL THEN
1516: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: p_error_buffer := 'trx_line_id can not be NULL';
1518: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type IS NULL THEN
1519: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: p_error_buffer := 'trx_level_type can not be NULL';
1521: /*
1522: -- Bug#4572001- content_owner_id can be NULL
1523: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).content_owner_id IS NULL THEN

Line 1524: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1520: p_error_buffer := 'trx_level_type can not be NULL';
1521: /*
1522: -- Bug#4572001- content_owner_id can be NULL
1523: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).content_owner_id IS NULL THEN
1524: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1525: p_error_buffer := 'content_owner_id can not be NULL';
1526: */
1527: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_id IS NULL THEN
1528: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1528: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1524: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1525: p_error_buffer := 'content_owner_id can not be NULL';
1526: */
1527: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_id IS NULL THEN
1528: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529: p_error_buffer := 'tax_regime_id can not be NULL';
1530: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code IS NULL THEN
1531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1532: p_error_buffer := 'tax_regime_code can not be NULL';

Line 1531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1527: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_id IS NULL THEN
1528: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529: p_error_buffer := 'tax_regime_id can not be NULL';
1530: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code IS NULL THEN
1531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1532: p_error_buffer := 'tax_regime_code can not be NULL';
1533: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id IS NULL THEN
1534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: p_error_buffer := 'tax_id can not be NULL';

Line 1534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1530: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code IS NULL THEN
1531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1532: p_error_buffer := 'tax_regime_code can not be NULL';
1533: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id IS NULL THEN
1534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: p_error_buffer := 'tax_id can not be NULL';
1536: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax IS NULL THEN
1537: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1538: p_error_buffer := 'tax can not be NULL';

Line 1537: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1533: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id IS NULL THEN
1534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: p_error_buffer := 'tax_id can not be NULL';
1536: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax IS NULL THEN
1537: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1538: p_error_buffer := 'tax can not be NULL';
1539: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id IS NULL THEN
1540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1541: p_error_buffer := 'tax_status_id can not be NULL';

Line 1540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1536: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax IS NULL THEN
1537: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1538: p_error_buffer := 'tax can not be NULL';
1539: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id IS NULL THEN
1540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1541: p_error_buffer := 'tax_status_id can not be NULL';
1542: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code IS NULL THEN
1543: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: p_error_buffer := 'tax_status_code can not be NULL';

Line 1543: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1539: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id IS NULL THEN
1540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1541: p_error_buffer := 'tax_status_id can not be NULL';
1542: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code IS NULL THEN
1543: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: p_error_buffer := 'tax_status_code can not be NULL';
1545: END IF;
1546:
1547: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1547: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1543: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544: p_error_buffer := 'tax_status_code can not be NULL';
1545: END IF;
1546:
1547: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: EXIT;
1549: END IF;
1550:
1551: END LOOP;

Line 1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1563: END IF;
1564:
1565: EXCEPTION
1566: WHEN OTHERS THEN
1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1569:
1570: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1571: FND_LOG.STRING(g_level_unexpected,

Line 1613: p_return_status := FND_API.G_RET_STS_SUCCESS;

1609: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1610: 'p_end_index = ' || to_char(p_end_index));
1611: END IF;
1612:
1613: p_return_status := FND_API.G_RET_STS_SUCCESS;
1614:
1615: --
1616: -- check if begin_index and end_index have values
1617: --

Line 1640: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1636:
1637: IF (NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag,'N') = 'N') THEN
1638:
1639: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date IS NULL THEN
1640: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: p_error_buffer := 'trx_date can not be NULL';
1642: -- ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_date IS NULL THEN
1643: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: -- p_error_buffer := 'trx_line_date can not be NULL';

Line 1643: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1639: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date IS NULL THEN
1640: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: p_error_buffer := 'trx_date can not be NULL';
1642: -- ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_date IS NULL THEN
1643: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: -- p_error_buffer := 'trx_line_date can not be NULL';
1645: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).ledger_id IS NULL THEN
1646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: p_error_buffer := 'ledger_id can not be NULL';

Line 1646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1642: -- ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_date IS NULL THEN
1643: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: -- p_error_buffer := 'trx_line_date can not be NULL';
1645: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).ledger_id IS NULL THEN
1646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: p_error_buffer := 'ledger_id can not be NULL';
1648:
1649: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1650: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).establishment_id IS NULL THEN

Line 1651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1647: p_error_buffer := 'ledger_id can not be NULL';
1648:
1649: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1650: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).establishment_id IS NULL THEN
1651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: p_error_buffer := 'establishment_id can not be NULL';
1653: */
1654: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_entity_id IS NULL THEN
1655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: p_error_buffer := 'establishment_id can not be NULL';
1653: */
1654: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_entity_id IS NULL THEN
1655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1656: p_error_buffer := 'legal_entity_id can not be NULL';
1657: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id IS NULL THEN
1658: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1659: p_error_buffer := 'tax_rate_id can not be NULL';

Line 1658: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1654: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_entity_id IS NULL THEN
1655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1656: p_error_buffer := 'legal_entity_id can not be NULL';
1657: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id IS NULL THEN
1658: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1659: p_error_buffer := 'tax_rate_id can not be NULL';
1660: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NULL THEN
1661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: p_error_buffer := 'tax_rate_code can not be NULL';

Line 1661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1657: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id IS NULL THEN
1658: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1659: p_error_buffer := 'tax_rate_id can not be NULL';
1660: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NULL THEN
1661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: p_error_buffer := 'tax_rate_code can not be NULL';
1663: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL THEN
1664: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: p_error_buffer := 'tax_rate can not be NULL';

Line 1664: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1660: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NULL THEN
1661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: p_error_buffer := 'tax_rate_code can not be NULL';
1663: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL THEN
1664: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: p_error_buffer := 'tax_rate can not be NULL';
1666:
1667: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1668: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_apportionment_line_number IS NULL THEN

Line 1669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1665: p_error_buffer := 'tax_rate can not be NULL';
1666:
1667: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1668: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_apportionment_line_number IS NULL THEN
1669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: p_error_buffer := 'tax_apportionment_line_number can not be NULL';
1671: */
1672: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date IS NULL THEN
1673: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1673: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1669: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: p_error_buffer := 'tax_apportionment_line_number can not be NULL';
1671: */
1672: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date IS NULL THEN
1673: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674: p_error_buffer := 'tax_date can not be NULL';
1675: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date IS NULL THEN
1676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: p_error_buffer := 'tax_determine_date can not be NULL';

Line 1676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1672: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date IS NULL THEN
1673: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674: p_error_buffer := 'tax_date can not be NULL';
1675: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date IS NULL THEN
1676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: p_error_buffer := 'tax_determine_date can not be NULL';
1678: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_point_date IS NULL THEN
1679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1680: p_error_buffer := 'tax_point_date can not be NULL';

Line 1679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1675: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date IS NULL THEN
1676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677: p_error_buffer := 'tax_determine_date can not be NULL';
1678: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_point_date IS NULL THEN
1679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1680: p_error_buffer := 'tax_point_date can not be NULL';
1681: END IF;
1682:
1683: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1683: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1679: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1680: p_error_buffer := 'tax_point_date can not be NULL';
1681: END IF;
1682:
1683: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1684: EXIT;
1685: END IF;
1686: END IF; -- non manual tax line
1687: END LOOP;

Line 1703: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1699: END IF;
1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1705:
1706: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1707: FND_LOG.STRING(g_level_unexpected,

Line 1742: p_return_status := FND_API.G_RET_STS_SUCCESS;

1738: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines.BEGIN',
1739: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_tax_lines(+)');
1740: END IF;
1741:
1742: p_return_status := FND_API.G_RET_STS_SUCCESS;
1743:
1744: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
1745: INSERT INTO zx_detail_tax_lines_gt
1746: ( tax_line_id,

Line 2404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2400: END IF;
2401:
2402: EXCEPTION
2403: WHEN OTHERS THEN
2404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2405: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2406:
2407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2408: FND_LOG.STRING(g_level_unexpected,

Line 2443: p_return_status := FND_API.G_RET_STS_SUCCESS;

2439: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines.BEGIN',
2440: 'ZX_TDS_TAX_LINES_POPU_PKG: process_frozen_tax_lines(+)');
2441: END IF;
2442:
2443: p_return_status := FND_API.G_RET_STS_SUCCESS;
2444:
2445: -- bug 6906427: 1. Add code to handle OVERRIDE_TAX
2446: -- 2. Make changes for UPDATE
2447: --

Line 3910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3906: END IF;
3907:
3908: EXCEPTION
3909: WHEN OTHERS THEN
3910: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3911: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3912:
3913: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3914: FND_LOG.STRING(g_level_unexpected,

Line 3948: p_return_status := FND_API.G_RET_STS_SUCCESS;

3944: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines.BEGIN',
3945: 'ZX_TDS_TAX_LINES_POPU_PKG: process_discard_tax_lines(+)');
3946: END IF;
3947:
3948: p_return_status := FND_API.G_RET_STS_SUCCESS;
3949:
3950: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
3951: INSERT INTO zx_detail_tax_lines_gt
3952: ( tax_line_id,

Line 4610: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4606: END IF;
4607:
4608: EXCEPTION
4609: WHEN OTHERS THEN
4610: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4611: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4612:
4613: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4614: FND_LOG.STRING(g_level_unexpected,

Line 4649: p_return_status := FND_API.G_RET_STS_SUCCESS;

4645: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines.BEGIN',
4646: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_trx_lines(+)');
4647: END IF;
4648:
4649: p_return_status := FND_API.G_RET_STS_SUCCESS;
4650:
4651: -- bug 8470599 forcing the driving table in select clause from zx_lines_det_factors
4652: INSERT INTO zx_detail_tax_lines_gt
4653: ( tax_line_id,

Line 5286: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5282: END IF;
5283:
5284: EXCEPTION
5285: WHEN OTHERS THEN
5286: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5287: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5288:
5289: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5290: FND_LOG.STRING(g_level_unexpected,

Line 5473: p_return_status := FND_API.G_RET_STS_SUCCESS;

5469: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance.BEGIN',
5470: 'ZX_TDS_TAX_LINES_POPU_PKG: process_tax_tolerance(+)');
5471: END IF;
5472:
5473: p_return_status := FND_API.G_RET_STS_SUCCESS;
5474:
5475: IF p_event_class_rec.tax_tolerance IS NOT NULL OR
5476: p_event_class_rec.tax_tol_amt_range IS NOT NULL
5477: THEN

Line 5532: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5528: l_tax_precision,
5529: p_return_status,
5530: p_error_buffer);
5531:
5532: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5533: EXIT;
5534: END IF;
5535:
5536: l_tax_high_boundary:= ZX_TDS_TAX_ROUNDING_PKG.ROUND_TAX(

Line 5543: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5539: l_tax_min_acct_unit,
5540: l_tax_precision,
5541: p_return_status,
5542: p_error_buffer);
5543: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5544: EXIT;
5545: END IF;
5546:
5547: IF (ABS(l_tax_amt_tax_curr_tbl(i)) < ABS(l_tax_low_boundary) OR

Line 5661: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5657: l_tax_precision,
5658: p_return_status,
5659: p_error_buffer);
5660:
5661: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5662: EXIT;
5663: END IF;
5664:
5665: l_tax_high_boundary:= ZX_TDS_TAX_ROUNDING_PKG.ROUND_TAX(

Line 5672: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5668: l_tax_min_acct_unit,
5669: l_tax_precision,
5670: p_return_status,
5671: p_error_buffer);
5672: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5673: EXIT;
5674: END IF;
5675:
5676: IF (ABS(l_tax_amt_tax_curr_tbl(i)) < ABS(l_tax_low_boundary) OR

Line 5790: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5786: l_tax_precision,
5787: p_return_status,
5788: p_error_buffer);
5789:
5790: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5791: EXIT;
5792: END IF;
5793:
5794: l_tax_high_boundary:= ZX_TDS_TAX_ROUNDING_PKG.ROUND_TAX(

Line 5801: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5797: l_tax_min_acct_unit,
5798: l_tax_precision,
5799: p_return_status,
5800: p_error_buffer);
5801: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5802: EXIT;
5803: END IF;
5804:
5805: IF (ABS(l_tax_amt_tax_curr_tbl(i)) < ABS(l_tax_low_boundary) OR

Line 5919: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5915: l_tax_precision,
5916: p_return_status,
5917: p_error_buffer);
5918:
5919: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5920: EXIT;
5921: END IF;
5922:
5923: l_tax_high_boundary:= ZX_TDS_TAX_ROUNDING_PKG.ROUND_TAX(

Line 5930: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5926: l_tax_min_acct_unit,
5927: l_tax_precision,
5928: p_return_status,
5929: p_error_buffer);
5930: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5931: EXIT;
5932: END IF;
5933:
5934: IF (ABS(l_tax_amt_tax_curr_tbl(i)) < ABS(l_tax_low_boundary) OR

Line 6048: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6044: l_tax_precision,
6045: p_return_status,
6046: p_error_buffer);
6047:
6048: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6049: EXIT;
6050: END IF;
6051:
6052: l_tax_high_boundary:= ZX_TDS_TAX_ROUNDING_PKG.ROUND_TAX(

Line 6059: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6055: l_tax_min_acct_unit,
6056: l_tax_precision,
6057: p_return_status,
6058: p_error_buffer);
6059: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6060: EXIT;
6061: END IF;
6062:
6063: IF (ABS(l_tax_amt_tax_curr_tbl(i)) < ABS(l_tax_low_boundary) OR

Line 6146: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6142: END IF;
6143:
6144: EXCEPTION
6145: WHEN OTHERS THEN
6146: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6147: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6148:
6149: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6150: FND_LOG.STRING(g_level_unexpected,

Line 6190: p_return_status := FND_API.G_RET_STS_SUCCESS;

6186: 'begin_index = ' || to_char(p_begin_index) || ' end_index= '
6187: || to_char(p_end_index));
6188: END IF;
6189:
6190: p_return_status := FND_API.G_RET_STS_SUCCESS;
6191:
6192: --
6193: -- check if begin_index and end_index have values
6194: --

Line 6233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6229: END IF;
6230:
6231: EXCEPTION
6232: WHEN OTHERS THEN
6233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6234: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
6235: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6236: FND_LOG.STRING(g_level_unexpected,
6237: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg',