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 525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

521: END IF;
522:
523: EXCEPTION
524: WHEN OTHERS THEN
525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
527:
528: IF (g_level_unexpected >= g_current_runtime_level ) THEN
529: FND_LOG.STRING(g_level_unexpected,

Line 562: p_return_status := FND_API.G_RET_STS_SUCCESS;

558: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_tax_lines.BEGIN',
559: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_tax_lines(+)');
560: END IF;
561:
562: p_return_status := FND_API.G_RET_STS_SUCCESS;
563: p_error_buffer := NULL;
564:
565:
566: /*

Line 586: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

582: populate_mandatory_columns(p_tax_line_rec,
583: p_return_status,
584: p_error_buffer);
585:
586: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
587: RETURN;
588: END IF;
589:
590: check_mandatory_columns(p_tax_line_rec,

Line 603: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

599: END IF;
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
605:
606: IF (g_level_unexpected >= g_current_runtime_level ) THEN
607: FND_LOG.STRING(g_level_unexpected,

Line 714: p_return_status := FND_API.G_RET_STS_SUCCESS;

710: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns.BEGIN',
711: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_mandatory_columns(+)');
712: END IF;
713:
714: p_return_status := FND_API.G_RET_STS_SUCCESS;
715:
716: --
717: -- populate tax_line_id if it is null
718: --

Line 767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

763: END IF;
764:
765: EXCEPTION
766: WHEN OTHERS THEN
767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
769:
770: IF (g_level_unexpected >= g_current_runtime_level ) THEN
771: FND_LOG.STRING(g_level_unexpected,

Line 804: p_return_status := FND_API.G_RET_STS_SUCCESS;

800: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns.BEGIN',
801: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns(+)');
802: END IF;
803:
804: p_return_status := FND_API.G_RET_STS_SUCCESS;
805:
806: --
807: -- check mandatory columns for all tax lines
808: --

Line 812: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND

808: --
809: check_mandatory_columns_all(p_tax_line_rec,
810: p_return_status,
811: p_error_buffer);
812: IF (p_return_status = FND_API.G_RET_STS_SUCCESS AND
813: NVL(p_tax_line_rec.Manually_Entered_Flag,'N') = 'N') THEN
814: check_non_manual_tax_line(p_tax_line_rec,
815: p_return_status,
816: p_error_buffer);

Line 833: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: END IF;
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
835:
836: IF (g_level_unexpected >= g_current_runtime_level ) THEN
837: FND_LOG.STRING(g_level_unexpected,

Line 870: p_return_status := FND_API.G_RET_STS_SUCCESS;

866: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all.BEGIN',
867: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns_all(+)');
868: END IF;
869:
870: p_return_status := FND_API.G_RET_STS_SUCCESS;
871:
872: IF p_tax_line_rec.application_id IS NULL THEN
873: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: p_error_buffer := 'application_id can not be NULL';

Line 873: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

869:
870: p_return_status := FND_API.G_RET_STS_SUCCESS;
871:
872: IF p_tax_line_rec.application_id IS NULL THEN
873: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: p_error_buffer := 'application_id can not be NULL';
875: ELSIF p_tax_line_rec.entity_code IS NULL THEN
876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: p_error_buffer := 'entity_code can not be NULL';

Line 876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 879: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

875: ELSIF p_tax_line_rec.entity_code IS NULL THEN
876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: p_error_buffer := 'entity_code can not be NULL';
878: ELSIF p_tax_line_rec.event_class_code IS NULL THEN
879: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880: p_error_buffer := 'event_class_code can not be NULL';
881: ELSIF p_tax_line_rec.event_type_code IS NULL THEN
882: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883: p_error_buffer := 'event_type_code can not be NULL';

Line 882: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 885: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 888: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 891: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

887: ELSIF p_tax_line_rec.trx_line_id IS NULL THEN
888: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
889: p_error_buffer := 'trx_line_id can not be NULL';
890: ELSIF p_tax_line_rec.trx_level_type IS NULL THEN
891: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: p_error_buffer := 'trx_level_type can not be NULL';
893:
894: -- Bug#4572001- content_owner_id can be NULL
895: -- ELSIF p_tax_line_rec.content_owner_id IS NULL THEN

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

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

Line 900: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 903: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

899: ELSIF p_tax_line_rec.tax_regime_id IS NULL THEN
900: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
901: p_error_buffer := 'tax_regime_id can not be NULL';
902: ELSIF p_tax_line_rec.tax_regime_code IS NULL THEN
903: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: p_error_buffer := 'tax_regime_code can not be NULL';
905: ELSIF p_tax_line_rec.tax_id IS NULL THEN
906: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: p_error_buffer := 'tax_id can not be NULL';

Line 906: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 909: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 912: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

911: ELSIF p_tax_line_rec.tax_status_id IS NULL THEN
912: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: p_error_buffer := 'tax_status_id can not be NULL';
914: ELSIF p_tax_line_rec.tax_status_code IS NULL THEN
915: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: p_error_buffer := 'tax_status_code can not be NULL';
917: END IF;
918:
919: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

929: END IF;
930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
935:
936: IF (g_level_unexpected >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_unexpected,

Line 972: p_return_status := FND_API.G_RET_STS_SUCCESS;

968: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line.BEGIN',
969: 'ZX_TDS_TAX_LINES_POPU_PKG: check_non_manual_tax_line(+)');
970: END IF;
971:
972: p_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: IF p_tax_line_rec.trx_date IS NULL THEN
975: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: p_error_buffer := 'trx_date can not be NULL';

Line 975: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

971:
972: p_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: IF p_tax_line_rec.trx_date IS NULL THEN
975: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976: p_error_buffer := 'trx_date can not be NULL';
977: --ELSIF p_tax_line_rec.trx_line_date IS NULL THEN
978: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: -- p_error_buffer := 'trx_line_date can not be NULL';

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

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

Line 981: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 986: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 990: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

986: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: p_error_buffer := 'establishment_id can not be NULL';
988: */
989: ELSIF p_tax_line_rec.legal_entity_id IS NULL THEN
990: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: p_error_buffer := 'legal_entity_id can not be NULL';
992: ELSIF p_tax_line_rec.tax_rate_id IS NULL THEN
993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
994: p_error_buffer := 'tax_rate_id can not be NULL';

Line 993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

989: ELSIF p_tax_line_rec.legal_entity_id IS NULL THEN
990: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: p_error_buffer := 'legal_entity_id can not be NULL';
992: ELSIF p_tax_line_rec.tax_rate_id IS NULL THEN
993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
994: p_error_buffer := 'tax_rate_id can not be NULL';
995: ELSIF p_tax_line_rec.tax_rate_code IS NULL THEN
996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: p_error_buffer := 'tax_rate_code can not be NULL';

Line 996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 999: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

995: ELSIF p_tax_line_rec.tax_rate_code IS NULL THEN
996: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: p_error_buffer := 'tax_rate_code can not be NULL';
998: ELSIF p_tax_line_rec.tax_rate IS NULL THEN
999: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: p_error_buffer := 'tax_rate can not be NULL';
1001:
1002: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1003: ELSIF p_tax_line_rec.tax_apportionment_line_number IS NULL THEN

Line 1004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1008: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: p_error_buffer := 'tax_apportionment_line_number can not be NULL';
1006: */
1007: ELSIF p_tax_line_rec.tax_date IS NULL THEN
1008: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: p_error_buffer := 'tax_date can not be NULL';
1010: ELSIF p_tax_line_rec.tax_determine_date IS NULL THEN
1011: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012: p_error_buffer := 'tax_determine_date can not be NULL';

Line 1011: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1007: ELSIF p_tax_line_rec.tax_date IS NULL THEN
1008: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: p_error_buffer := 'tax_date can not be NULL';
1010: ELSIF p_tax_line_rec.tax_determine_date IS NULL THEN
1011: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012: p_error_buffer := 'tax_determine_date can not be NULL';
1013: ELSIF p_tax_line_rec.tax_point_date IS NULL THEN
1014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: p_error_buffer := 'tax_point_date can not be NULL';

Line 1014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1010: ELSIF p_tax_line_rec.tax_determine_date IS NULL THEN
1011: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012: p_error_buffer := 'tax_determine_date can not be NULL';
1013: ELSIF p_tax_line_rec.tax_point_date IS NULL THEN
1014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: p_error_buffer := 'tax_point_date can not be NULL';
1016:
1017: END IF;
1018:

Line 1033: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1029: END IF;
1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1035:
1036: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1037: FND_LOG.STRING(g_level_unexpected,

Line 1082: p_return_status := FND_API.G_RET_STS_SUCCESS;

1078: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',
1079: 'p_end_index = ' || to_char(p_end_index));
1080: END IF;
1081:
1082: p_return_status := FND_API.G_RET_STS_SUCCESS;
1083: p_error_buffer := NULL;
1084:
1085: --
1086: -- check if begin_index and end_index have values

Line 1105: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1101: p_end_index,
1102: p_return_status,
1103: p_error_buffer);
1104:
1105: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1106: RETURN;
1107: END IF;
1108:
1109: chk_mandatory_col_for_trx_line(

Line 1115: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1111: p_end_index,
1112: p_return_status,
1113: p_error_buffer);
1114:
1115: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1116: RETURN;
1117: END IF;
1118:
1119: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1129: END IF;
1130:
1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1135:
1136: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1137: FND_LOG.STRING(g_level_unexpected,

Line 1178: p_return_status := FND_API.G_RET_STS_SUCCESS;

1174: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1175: 'p_end_index = ' || to_char(p_end_index));
1176: END IF;
1177:
1178: p_return_status := FND_API.G_RET_STS_SUCCESS;
1179:
1180: --
1181: -- check if begin_index and end_index have values
1182: --

Line 1271: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1267: END IF;
1268:
1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1273:
1274: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1275: FND_LOG.STRING(g_level_unexpected,

Line 1316: p_return_status := FND_API.G_RET_STS_SUCCESS;

1312: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1313: 'p_end_index = ' || to_char(p_end_index));
1314: END IF;
1315:
1316: p_return_status := FND_API.G_RET_STS_SUCCESS;
1317:
1318: --
1319: -- check if begin_index and end_index have values
1320: --

Line 1341: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1337: p_end_index,
1338: p_return_status,
1339: p_error_buffer);
1340:
1341: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1342: RETURN;
1343: END IF;
1344:
1345: --

Line 1354: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1350: p_begin_index,
1351: p_end_index,
1352: p_return_status,
1353: p_error_buffer);
1354: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1355: RETURN;
1356: END IF;
1357:
1358: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1372: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1368: END IF;
1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN
1372: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1374:
1375: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1376: FND_LOG.STRING(g_level_unexpected,

Line 1416: p_return_status := FND_API.G_RET_STS_SUCCESS;

1412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1413: 'p_end_index = ' || to_char(p_end_index));
1414: END IF;
1415:
1416: p_return_status := FND_API.G_RET_STS_SUCCESS;
1417:
1418: --
1419: -- check if begin_index and end_index have values
1420: --

Line 1441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1437: 'processing detail line index = ' || to_char(i));
1438: END IF;
1439:
1440: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).application_id IS NULL THEN
1441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: p_error_buffer := 'application_id can not be NULL';
1443: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).entity_code IS NULL THEN
1444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: p_error_buffer := 'entity_code can not be NULL';

Line 1444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1440: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).application_id IS NULL THEN
1441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: p_error_buffer := 'application_id can not be NULL';
1443: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).entity_code IS NULL THEN
1444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: p_error_buffer := 'entity_code can not be NULL';
1446: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_class_code IS NULL THEN
1447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: p_error_buffer := 'event_class_code can not be NULL';

Line 1447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1443: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).entity_code IS NULL THEN
1444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445: p_error_buffer := 'entity_code can not be NULL';
1446: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_class_code IS NULL THEN
1447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: p_error_buffer := 'event_class_code can not be NULL';
1449: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_type_code IS NULL THEN
1450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: p_error_buffer := 'event_type_code can not be NULL';

Line 1450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1446: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_class_code IS NULL THEN
1447: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: p_error_buffer := 'event_class_code can not be NULL';
1449: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_type_code IS NULL THEN
1450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: p_error_buffer := 'event_type_code can not be NULL';
1452: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_id IS NULL THEN
1453: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: p_error_buffer := 'trx_id can not be NULL';

Line 1453: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1449: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).event_type_code IS NULL THEN
1450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: p_error_buffer := 'event_type_code can not be NULL';
1452: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_id IS NULL THEN
1453: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: p_error_buffer := 'trx_id can not be NULL';
1455: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id IS NULL THEN
1456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457: p_error_buffer := 'trx_line_id can not be NULL';

Line 1456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1452: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_id IS NULL THEN
1453: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: p_error_buffer := 'trx_id can not be NULL';
1455: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id IS NULL THEN
1456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457: p_error_buffer := 'trx_line_id can not be NULL';
1458: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type IS NULL THEN
1459: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: p_error_buffer := 'trx_level_type can not be NULL';

Line 1459: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1455: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_id IS NULL THEN
1456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457: p_error_buffer := 'trx_line_id can not be NULL';
1458: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_level_type IS NULL THEN
1459: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: p_error_buffer := 'trx_level_type can not be NULL';
1461: /*
1462: -- Bug#4572001- content_owner_id can be NULL
1463: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).content_owner_id IS NULL THEN

Line 1464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1460: p_error_buffer := 'trx_level_type can not be NULL';
1461: /*
1462: -- Bug#4572001- content_owner_id can be NULL
1463: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).content_owner_id IS NULL THEN
1464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: p_error_buffer := 'content_owner_id can not be NULL';
1466: */
1467: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_id IS NULL THEN
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1464: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: p_error_buffer := 'content_owner_id can not be NULL';
1466: */
1467: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_id IS NULL THEN
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: p_error_buffer := 'tax_regime_id can not be NULL';
1470: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code IS NULL THEN
1471: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1472: p_error_buffer := 'tax_regime_code can not be NULL';

Line 1471: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1467: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_id IS NULL THEN
1468: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: p_error_buffer := 'tax_regime_id can not be NULL';
1470: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code IS NULL THEN
1471: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1472: p_error_buffer := 'tax_regime_code can not be NULL';
1473: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id IS NULL THEN
1474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: p_error_buffer := 'tax_id can not be NULL';

Line 1474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1470: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_regime_code IS NULL THEN
1471: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1472: p_error_buffer := 'tax_regime_code can not be NULL';
1473: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id IS NULL THEN
1474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: p_error_buffer := 'tax_id can not be NULL';
1476: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax IS NULL THEN
1477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: p_error_buffer := 'tax can not be NULL';

Line 1477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1473: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id IS NULL THEN
1474: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: p_error_buffer := 'tax_id can not be NULL';
1476: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax IS NULL THEN
1477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: p_error_buffer := 'tax can not be NULL';
1479: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id IS NULL THEN
1480: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: p_error_buffer := 'tax_status_id can not be NULL';

Line 1480: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1476: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax IS NULL THEN
1477: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: p_error_buffer := 'tax can not be NULL';
1479: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id IS NULL THEN
1480: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: p_error_buffer := 'tax_status_id can not be NULL';
1482: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code IS NULL THEN
1483: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: p_error_buffer := 'tax_status_code can not be NULL';

Line 1483: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1479: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id IS NULL THEN
1480: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: p_error_buffer := 'tax_status_id can not be NULL';
1482: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code IS NULL THEN
1483: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: p_error_buffer := 'tax_status_code can not be NULL';
1485: END IF;
1486:
1487: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1487: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1483: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: p_error_buffer := 'tax_status_code can not be NULL';
1485: END IF;
1486:
1487: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1488: EXIT;
1489: END IF;
1490:
1491: END LOOP;

Line 1507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1503: END IF;
1504:
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1509:
1510: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1511: FND_LOG.STRING(g_level_unexpected,

Line 1553: p_return_status := FND_API.G_RET_STS_SUCCESS;

1549: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1550: 'p_end_index = ' || to_char(p_end_index));
1551: END IF;
1552:
1553: p_return_status := FND_API.G_RET_STS_SUCCESS;
1554:
1555: --
1556: -- check if begin_index and end_index have values
1557: --

Line 1580: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1576:
1577: IF (NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Manually_Entered_Flag,'N') = 'N') THEN
1578:
1579: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date IS NULL THEN
1580: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: p_error_buffer := 'trx_date can not be NULL';
1582: -- ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_date IS NULL THEN
1583: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: -- p_error_buffer := 'trx_line_date can not be NULL';

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

1579: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date IS NULL THEN
1580: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: p_error_buffer := 'trx_date can not be NULL';
1582: -- ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_date IS NULL THEN
1583: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: -- p_error_buffer := 'trx_line_date can not be NULL';
1585: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).ledger_id IS NULL THEN
1586: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: p_error_buffer := 'ledger_id can not be NULL';

Line 1586: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1582: -- ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_line_date IS NULL THEN
1583: -- p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: -- p_error_buffer := 'trx_line_date can not be NULL';
1585: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).ledger_id IS NULL THEN
1586: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: p_error_buffer := 'ledger_id can not be NULL';
1588:
1589: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1590: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).establishment_id IS NULL THEN

Line 1591: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1587: p_error_buffer := 'ledger_id can not be NULL';
1588:
1589: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1590: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).establishment_id IS NULL THEN
1591: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1592: p_error_buffer := 'establishment_id can not be NULL';
1593: */
1594: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_entity_id IS NULL THEN
1595: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1595: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1591: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1592: p_error_buffer := 'establishment_id can not be NULL';
1593: */
1594: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_entity_id IS NULL THEN
1595: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596: p_error_buffer := 'legal_entity_id can not be NULL';
1597: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id IS NULL THEN
1598: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1599: p_error_buffer := 'tax_rate_id can not be NULL';

Line 1598: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1594: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_entity_id IS NULL THEN
1595: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596: p_error_buffer := 'legal_entity_id can not be NULL';
1597: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id IS NULL THEN
1598: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1599: p_error_buffer := 'tax_rate_id can not be NULL';
1600: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NULL THEN
1601: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: p_error_buffer := 'tax_rate_code can not be NULL';

Line 1601: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1597: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id IS NULL THEN
1598: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1599: p_error_buffer := 'tax_rate_id can not be NULL';
1600: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NULL THEN
1601: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: p_error_buffer := 'tax_rate_code can not be NULL';
1603: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL THEN
1604: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: p_error_buffer := 'tax_rate can not be NULL';

Line 1604: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1600: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NULL THEN
1601: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: p_error_buffer := 'tax_rate_code can not be NULL';
1603: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL THEN
1604: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: p_error_buffer := 'tax_rate can not be NULL';
1606:
1607: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1608: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_apportionment_line_number IS NULL THEN

Line 1609: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1605: p_error_buffer := 'tax_rate can not be NULL';
1606:
1607: /* comment out only for AP uptake testing purpose. Change to reversed later. chku
1608: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_apportionment_line_number IS NULL THEN
1609: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: p_error_buffer := 'tax_apportionment_line_number can not be NULL';
1611: */
1612: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date IS NULL THEN
1613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1609: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: p_error_buffer := 'tax_apportionment_line_number can not be NULL';
1611: */
1612: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date IS NULL THEN
1613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: p_error_buffer := 'tax_date can not be NULL';
1615: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date IS NULL THEN
1616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: p_error_buffer := 'tax_determine_date can not be NULL';

Line 1616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1612: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date IS NULL THEN
1613: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: p_error_buffer := 'tax_date can not be NULL';
1615: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date IS NULL THEN
1616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: p_error_buffer := 'tax_determine_date can not be NULL';
1618: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_point_date IS NULL THEN
1619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1620: p_error_buffer := 'tax_point_date can not be NULL';

Line 1619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1615: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date IS NULL THEN
1616: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: p_error_buffer := 'tax_determine_date can not be NULL';
1618: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_point_date IS NULL THEN
1619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1620: p_error_buffer := 'tax_point_date can not be NULL';
1621: END IF;
1622:
1623: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1623: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1620: p_error_buffer := 'tax_point_date can not be NULL';
1621: END IF;
1622:
1623: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1624: EXIT;
1625: END IF;
1626: END IF; -- non manual tax line
1627: END LOOP;

Line 1643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1639: END IF;
1640:
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1645:
1646: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1647: FND_LOG.STRING(g_level_unexpected,

Line 1682: p_return_status := FND_API.G_RET_STS_SUCCESS;

1678: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines.BEGIN',
1679: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_tax_lines(+)');
1680: END IF;
1681:
1682: p_return_status := FND_API.G_RET_STS_SUCCESS;
1683:
1684: INSERT INTO zx_detail_tax_lines_gt
1685: ( tax_line_id,
1686: internal_organization_id,

Line 2343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2339: END IF;
2340:
2341: EXCEPTION
2342: WHEN OTHERS THEN
2343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2344: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2345:
2346: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2347: FND_LOG.STRING(g_level_unexpected,

Line 2382: p_return_status := FND_API.G_RET_STS_SUCCESS;

2378: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines.BEGIN',
2379: 'ZX_TDS_TAX_LINES_POPU_PKG: process_frozen_tax_lines(+)');
2380: END IF;
2381:
2382: p_return_status := FND_API.G_RET_STS_SUCCESS;
2383:
2384: -- bug 6906427: 1. Add code to handle OVERRIDE_TAX
2385: -- 2. Make changes for UPDATE
2386: --

Line 3843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3839: END IF;
3840:
3841: EXCEPTION
3842: WHEN OTHERS THEN
3843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3844: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3845:
3846: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3847: FND_LOG.STRING(g_level_unexpected,

Line 3881: p_return_status := FND_API.G_RET_STS_SUCCESS;

3877: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines.BEGIN',
3878: 'ZX_TDS_TAX_LINES_POPU_PKG: process_discard_tax_lines(+)');
3879: END IF;
3880:
3881: p_return_status := FND_API.G_RET_STS_SUCCESS;
3882:
3883: INSERT INTO zx_detail_tax_lines_gt
3884: ( tax_line_id,
3885: internal_organization_id,

Line 4538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4534: END IF;
4535:
4536: EXCEPTION
4537: WHEN OTHERS THEN
4538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4540:
4541: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4542: FND_LOG.STRING(g_level_unexpected,

Line 4577: p_return_status := FND_API.G_RET_STS_SUCCESS;

4573: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines.BEGIN',
4574: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_trx_lines(+)');
4575: END IF;
4576:
4577: p_return_status := FND_API.G_RET_STS_SUCCESS;
4578:
4579: INSERT INTO zx_detail_tax_lines_gt
4580: ( tax_line_id,
4581: internal_organization_id,

Line 5212: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5208: END IF;
5209:
5210: EXCEPTION
5211: WHEN OTHERS THEN
5212: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5214:
5215: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5216: FND_LOG.STRING(g_level_unexpected,

Line 5401: p_return_status := FND_API.G_RET_STS_SUCCESS;

5397: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance.BEGIN',
5398: 'ZX_TDS_TAX_LINES_POPU_PKG: process_tax_tolerance(+)');
5399: END IF;
5400:
5401: p_return_status := FND_API.G_RET_STS_SUCCESS;
5402:
5403: -- Start Bugfix: 5617541
5404: -- bug 5684123
5405: IF p_event_class_rec.tax_event_type_code = 'OVERRIDE_TAX'

Line 5507: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5503: l_tax_precision,
5504: p_return_status,
5505: p_error_buffer);
5506:
5507: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5508: EXIT;
5509: END IF;
5510:
5511: l_tax_high_boundary:= ZX_TDS_TAX_ROUNDING_PKG.ROUND_TAX(

Line 5518: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5514: l_tax_min_acct_unit,
5515: l_tax_precision,
5516: p_return_status,
5517: p_error_buffer);
5518: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5519: EXIT;
5520: END IF;
5521:
5522: IF (ABS(l_tax_amt_tax_curr_tbl(i)) < ABS(l_tax_low_boundary) OR

Line 5555: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5551: nvl(l_tax_hold_released_code_tbl(i), 0) ) ;
5552:
5553: END LOOP; -- end FOR LOOP
5554:
5555: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5556: EXIT;
5557: END IF;
5558:
5559: --

Line 5597: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5593: EXIT;
5594: END IF;
5595: END LOOP;
5596:
5597: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5598: -- Start Bugfix: 5617541
5599: IF p_event_class_rec.tax_event_type_code = 'OVERRIDE_TAX' THEN
5600: CLOSE get_tax_tolerance_csr;
5601: ELSIF ZX_TDS_CALC_SERVICES_PUB_PKG.g_ctrl_total_line_tx_amt_flg = 'Y' THEN

Line 5628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5624: END IF;
5625:
5626: EXCEPTION
5627: WHEN OTHERS THEN
5628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5629: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5630:
5631: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5632: FND_LOG.STRING(g_level_unexpected,

Line 5672: p_return_status := FND_API.G_RET_STS_SUCCESS;

5668: 'begin_index = ' || to_char(p_begin_index) || ' end_index= '
5669: || to_char(p_end_index));
5670: END IF;
5671:
5672: p_return_status := FND_API.G_RET_STS_SUCCESS;
5673:
5674: --
5675: -- check if begin_index and end_index have values
5676: --

Line 5719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5715: END IF;
5716:
5717: EXCEPTION
5718: WHEN OTHERS THEN
5719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5720: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5721: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5722: FND_LOG.STRING(g_level_unexpected,
5723: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg',