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.JTY_ASSIGN_BULK_PUB dependencies on JTY_TAE_INDEX_CREATION_PVT

Line 660: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

656: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
657: 'Deleting data and dropping indexes from ' || l_trans_target);
658:
659: /* Drop the indexes on the TRANS table */
660: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
661: p_table_name => l_trans_target
662: ,x_return_status => x_return_status );
663:
664: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 666: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_trans_target;

662: ,x_return_status => x_return_status );
663:
664: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
665: -- debug message
666: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_trans_target;
667: jty_log(FND_LOG.LEVEL_EXCEPTION,
668: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
669: x_msg_data);
670:

Line 675: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:
674: /* Truncate the TRANS table */
675: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
676: p_table_name => l_trans_target
677: ,x_return_status => x_return_status );
678:
679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 681: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_trans_target;

677: ,x_return_status => x_return_status );
678:
679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
680: -- debug message
681: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_trans_target;
682: jty_log(FND_LOG.LEVEL_EXCEPTION,
683: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
684: x_msg_data);
685:

Line 700: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

696: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
697: 'Deleting data and dropping indexes from ' || l_match_target);
698:
699: /* Drop the indexes on the MATCH table */
700: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
701: p_table_name => l_match_target
702: ,x_return_status => x_return_status );
703:
704: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 707: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_match_target;

703:
704: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
705:
706: -- debug message
707: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_match_target;
708: jty_log(FND_LOG.LEVEL_EXCEPTION,
709: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
710: x_msg_data);
711:

Line 716: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: /* Truncate the MATCH table */
716: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
717: p_table_name => l_match_target
718: ,x_return_status => x_return_status );
719:
720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 722: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_match_target;

718: ,x_return_status => x_return_status );
719:
720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
721: -- debug message
722: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_match_target;
723: jty_log(FND_LOG.LEVEL_EXCEPTION,
724: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
725: x_msg_data);
726:

Line 741: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

737: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
738: 'Deleting data and dropping indexes from ' || l_umatch_target);
739:
740: /* Drop the indexes on the UMATCH table */
741: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
742: p_table_name => l_umatch_target
743: ,x_return_status => x_return_status );
744:
745: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 748: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_umatch_target;

744:
745: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
746:
747: -- debug message
748: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_umatch_target;
749: jty_log(FND_LOG.LEVEL_EXCEPTION,
750: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
751: x_msg_data);
752:

Line 757: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755:
756: /* Truncate the UMATCH table */
757: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
758: p_table_name => l_umatch_target
759: ,x_return_status => x_return_status );
760:
761: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 763: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_umatch_target;

759: ,x_return_status => x_return_status );
760:
761: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
762: -- debug message
763: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_umatch_target;
764: jty_log(FND_LOG.LEVEL_EXCEPTION,
765: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
766: x_msg_data);
767:

Line 782: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

778: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
779: 'Deleting data and dropping indexes from ' || l_winner_target);
780:
781: /* Drop the indexes on the WINNER table */
782: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
783: p_table_name => l_winner_target
784: ,x_return_status => x_return_status );
785:
786: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 789: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_winner_target;

785:
786: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
787:
788: -- debug message
789: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_winner_target;
790: jty_log(FND_LOG.LEVEL_EXCEPTION,
791: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
792: x_msg_data);
793:

Line 798: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797: /* Truncate the WINNER table */
798: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
799: p_table_name => l_winner_target
800: ,x_return_status => x_return_status );
801:
802: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 804: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_winner_target;

800: ,x_return_status => x_return_status );
801:
802: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
803: -- debug message
804: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_winner_target;
805: jty_log(FND_LOG.LEVEL_EXCEPTION,
806: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
807: x_msg_data);
808:

Line 823: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

819: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
820: 'Deleting data and dropping indexes from ' || l_uwinner_target);
821:
822: /* Drop the indexes on the UWINNER table */
823: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
824: p_table_name => l_uwinner_target
825: ,x_return_status => x_return_status );
826:
827: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 830: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_uwinner_target;

826:
827: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
828:
829: -- debug message
830: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_uwinner_target;
831: jty_log(FND_LOG.LEVEL_EXCEPTION,
832: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
833: x_msg_data);
834:

Line 839: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838: /* Truncate the UWINNER table */
839: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
840: p_table_name => l_uwinner_target
841: ,x_return_status => x_return_status );
842:
843: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 845: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_uwinner_target;

841: ,x_return_status => x_return_status );
842:
843: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
844: -- debug message
845: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_uwinner_target;
846: jty_log(FND_LOG.LEVEL_EXCEPTION,
847: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
848: x_msg_data);
849:

Line 864: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

860: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
861: 'Deleting data and dropping indexes from ' || l_l1_target);
862:
863: /* Drop the indexes on the L1 table */
864: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
865: p_table_name => l_l1_target
866: ,x_return_status => x_return_status );
867:
868: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 871: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l1_target;

867:
868: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
869:
870: -- debug message
871: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l1_target;
872: jty_log(FND_LOG.LEVEL_EXCEPTION,
873: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
874: x_msg_data);
875:

Line 880: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: /* Truncate the L1 table */
880: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
881: p_table_name => l_l1_target
882: ,x_return_status => x_return_status );
883:
884: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 886: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l1_target;

882: ,x_return_status => x_return_status );
883:
884: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
885: -- debug message
886: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l1_target;
887: jty_log(FND_LOG.LEVEL_EXCEPTION,
888: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
889: x_msg_data);
890:

Line 905: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

901: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
902: 'Deleting data and dropping indexes from ' || l_l2_target);
903:
904: /* Drop the indexes on the L2 table */
905: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
906: p_table_name => l_l2_target
907: ,x_return_status => x_return_status );
908:
909: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 912: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l2_target;

908:
909: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
910:
911: -- debug message
912: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l2_target;
913: jty_log(FND_LOG.LEVEL_EXCEPTION,
914: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
915: x_msg_data);
916:

Line 921: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919:
920: /* Truncate the L2 table */
921: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
922: p_table_name => l_l2_target
923: ,x_return_status => x_return_status );
924:
925: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 927: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l2_target;

923: ,x_return_status => x_return_status );
924:
925: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
926: -- debug message
927: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l2_target;
928: jty_log(FND_LOG.LEVEL_EXCEPTION,
929: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
930: x_msg_data);
931:

Line 946: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

942: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
943: 'Deleting data and dropping indexes from ' || l_l3_target);
944:
945: /* Drop the indexes on the L3 table */
946: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
947: p_table_name => l_l3_target
948: ,x_return_status => x_return_status );
949:
950: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 953: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l3_target;

949:
950: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
951:
952: -- debug message
953: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l3_target;
954: jty_log(FND_LOG.LEVEL_EXCEPTION,
955: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
956: x_msg_data);
957:

Line 962: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:
961: /* Truncate the L3 table */
962: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
963: p_table_name => l_l3_target
964: ,x_return_status => x_return_status );
965:
966: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 968: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l3_target;

964: ,x_return_status => x_return_status );
965:
966: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
967: -- debug message
968: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l3_target;
969: jty_log(FND_LOG.LEVEL_EXCEPTION,
970: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
971: x_msg_data);
972:

Line 987: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

983: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
984: 'Deleting data and dropping indexes from ' || l_l4_target);
985:
986: /* Drop the indexes on the L4 table */
987: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
988: p_table_name => l_l4_target
989: ,x_return_status => x_return_status );
990:
991: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 994: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l4_target;

990:
991: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
992:
993: -- debug message
994: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l4_target;
995: jty_log(FND_LOG.LEVEL_EXCEPTION,
996: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
997: x_msg_data);
998:

Line 1003: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: /* Truncate the L4 table */
1003: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1004: p_table_name => l_l4_target
1005: ,x_return_status => x_return_status );
1006:
1007: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1009: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l4_target;

1005: ,x_return_status => x_return_status );
1006:
1007: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1008: -- debug message
1009: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l4_target;
1010: jty_log(FND_LOG.LEVEL_EXCEPTION,
1011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1012: x_msg_data);
1013:

Line 1028: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1025: 'Deleting data and dropping indexes from ' || l_l5_target);
1026:
1027: /* Drop the indexes on the L5 table */
1028: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1029: p_table_name => l_l5_target
1030: ,x_return_status => x_return_status );
1031:
1032: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1035: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l5_target;

1031:
1032: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1033:
1034: -- debug message
1035: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l5_target;
1036: jty_log(FND_LOG.LEVEL_EXCEPTION,
1037: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1038: x_msg_data);
1039:

Line 1044: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;
1042:
1043: /* Truncate the L5 table */
1044: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1045: p_table_name => l_l5_target
1046: ,x_return_status => x_return_status );
1047:
1048: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1050: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l5_target;

1046: ,x_return_status => x_return_status );
1047:
1048: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1049: -- debug message
1050: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l5_target;
1051: jty_log(FND_LOG.LEVEL_EXCEPTION,
1052: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1053: x_msg_data);
1054:

Line 1069: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1065: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1066: 'Deleting data and dropping indexes from ' || l_wt_target);
1067:
1068: /* Drop the indexes on the WT table */
1069: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1070: p_table_name => l_wt_target
1071: ,x_return_status => x_return_status );
1072:
1073: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1076: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_wt_target;

1072:
1073: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1074:
1075: -- debug message
1076: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_wt_target;
1077: jty_log(FND_LOG.LEVEL_EXCEPTION,
1078: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1079: x_msg_data);
1080:

Line 1085: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: /* Truncate the WT table */
1085: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1086: p_table_name => l_wt_target
1087: ,x_return_status => x_return_status );
1088:
1089: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1091: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_wt_target;

1087: ,x_return_status => x_return_status );
1088:
1089: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1090: -- debug message
1091: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_wt_target;
1092: jty_log(FND_LOG.LEVEL_EXCEPTION,
1093: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1094: x_msg_data);
1095:

Line 1338: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);

1334:
1335: -- debug message
1336: jty_log(FND_LOG.LEVEL_STATEMENT,
1337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',
1338: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);
1339:
1340: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1341: p_table_name => l_trans_target
1342: , p_percent => p_percent_analyzed

Line 1340: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

1336: jty_log(FND_LOG.LEVEL_STATEMENT,
1337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',
1338: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);
1339:
1340: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1341: p_table_name => l_trans_target
1342: , p_percent => p_percent_analyzed
1343: , x_return_status => x_return_status );
1344:

Line 1347: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' || l_trans_target;

1343: , x_return_status => x_return_status );
1344:
1345: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1346: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1347: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' || l_trans_target;
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351: -- debug message

Line 1382: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);

1378:
1379: -- debug message
1380: jty_log(FND_LOG.LEVEL_STATEMENT,
1381: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_matches',
1382: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);
1383:
1384: /* Build Index on Matches table */
1385: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1386: ( p_table_name => l_match_target,

Line 1385: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1381: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_matches',
1382: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);
1383:
1384: /* Build Index on Matches table */
1385: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1386: ( p_table_name => l_match_target,
1387: p_trans_id => p_trans_id,
1388: p_source_id => p_source_id,
1389: p_program_name => p_program_name,

Line 1395: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_match_target;

1391: x_Return_Status => x_return_status,
1392: p_run_mode => 'MATCH');
1393:
1394: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1395: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_match_target;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: -- debug message

Line 1402: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);

1398:
1399: -- debug message
1400: jty_log(FND_LOG.LEVEL_STATEMENT,
1401: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_winners',
1402: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);
1403:
1404: /* Build Index on Winners table */
1405: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1406: ( p_table_name => l_winner_target,

Line 1405: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1401: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_winners',
1402: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);
1403:
1404: /* Build Index on Winners table */
1405: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1406: ( p_table_name => l_winner_target,
1407: p_trans_id => p_trans_id,
1408: p_source_id => p_source_id,
1409: p_program_name => p_program_name,

Line 1415: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_winner_target;

1411: x_Return_Status => x_return_status,
1412: p_run_mode => 'WINNER');
1413:
1414: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1415: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_winner_target;
1416: RAISE FND_API.G_EXC_ERROR;
1417: END IF;
1418:
1419: -- debug message

Line 1422: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);

1418:
1419: -- debug message
1420: jty_log(FND_LOG.LEVEL_STATEMENT,
1421: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l1',
1422: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);
1423:
1424: /* Build Index on L1 table */
1425: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1426: ( p_table_name => l_l1_target,

Line 1425: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1421: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l1',
1422: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);
1423:
1424: /* Build Index on L1 table */
1425: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1426: ( p_table_name => l_l1_target,
1427: p_trans_id => p_trans_id,
1428: p_source_id => p_source_id,
1429: p_program_name => p_program_name,

Line 1435: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l1_target;

1431: x_Return_Status => x_return_status,
1432: p_run_mode => 'TEMP_WINNER');
1433:
1434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1435: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l1_target;
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438:
1439: -- debug message

Line 1442: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);

1438:
1439: -- debug message
1440: jty_log(FND_LOG.LEVEL_STATEMENT,
1441: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l2',
1442: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);
1443:
1444: /* Build Index on L2 table */
1445: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1446: ( p_table_name => l_l2_target,

Line 1445: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1441: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l2',
1442: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);
1443:
1444: /* Build Index on L2 table */
1445: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1446: ( p_table_name => l_l2_target,
1447: p_trans_id => p_trans_id,
1448: p_source_id => p_source_id,
1449: p_program_name => p_program_name,

Line 1455: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l2_target;

1451: x_Return_Status => x_return_status,
1452: p_run_mode => 'TEMP_WINNER');
1453:
1454: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1455: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l2_target;
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458:
1459:

Line 1463: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);

1459:
1460: -- debug message
1461: jty_log(FND_LOG.LEVEL_STATEMENT,
1462: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l3',
1463: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);
1464:
1465: /* Build Index on L3 table */
1466: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1467: ( p_table_name => l_l3_target,

Line 1466: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1462: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l3',
1463: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);
1464:
1465: /* Build Index on L3 table */
1466: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1467: ( p_table_name => l_l3_target,
1468: p_trans_id => p_trans_id,
1469: p_source_id => p_source_id,
1470: p_program_name => p_program_name,

Line 1476: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l3_target;

1472: x_Return_Status => x_return_status,
1473: p_run_mode => 'TEMP_WINNER');
1474:
1475: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1476: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l3_target;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480: -- debug message

Line 1483: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);

1479:
1480: -- debug message
1481: jty_log(FND_LOG.LEVEL_STATEMENT,
1482: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l4',
1483: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);
1484:
1485: /* Build Index on L4 table */
1486: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1487: ( p_table_name => l_l4_target,

Line 1486: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1482: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l4',
1483: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);
1484:
1485: /* Build Index on L4 table */
1486: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1487: ( p_table_name => l_l4_target,
1488: p_trans_id => p_trans_id,
1489: p_source_id => p_source_id,
1490: p_program_name => p_program_name,

Line 1496: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l4_target;

1492: x_Return_Status => x_return_status,
1493: p_run_mode => 'TEMP_WINNER');
1494:
1495: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1496: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l4_target;
1497: RAISE FND_API.G_EXC_ERROR;
1498: END IF;
1499:
1500: -- debug message

Line 1503: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);

1499:
1500: -- debug message
1501: jty_log(FND_LOG.LEVEL_STATEMENT,
1502: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l5',
1503: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);
1504:
1505: /* Build Index on L5 table */
1506: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1507: ( p_table_name => l_l5_target,

Line 1506: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1502: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l5',
1503: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);
1504:
1505: /* Build Index on L5 table */
1506: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1507: ( p_table_name => l_l5_target,
1508: p_trans_id => p_trans_id,
1509: p_source_id => p_source_id,
1510: p_program_name => p_program_name,

Line 1516: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l5_target;

1512: x_Return_Status => x_return_status,
1513: p_run_mode => 'TEMP_WINNER');
1514:
1515: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1516: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l5_target;
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:
1520: -- debug message

Line 1523: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);

1519:
1520: -- debug message
1521: jty_log(FND_LOG.LEVEL_STATEMENT,
1522: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_wt',
1523: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);
1524:
1525: /* Build Index on WT table */
1526: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1527: ( p_table_name => l_wt_target,

Line 1526: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1522: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_wt',
1523: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);
1524:
1525: /* Build Index on WT table */
1526: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1527: ( p_table_name => l_wt_target,
1528: p_trans_id => p_trans_id,
1529: p_source_id => p_source_id,
1530: p_program_name => p_program_name,

Line 1536: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_wt_target;

1532: x_Return_Status => x_return_status,
1533: p_run_mode => 'TEMP_WINNER');
1534:
1535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1536: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_wt_target;
1537: RAISE FND_API.G_EXC_ERROR;
1538: END IF;
1539:
1540: /* if mode is incremental, update the worker_id column for the TRANS table */

Line 3088: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3084:
3085: COMMIT;
3086:
3087: /*
3088: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3089: p_table_name => l_L1_target
3090: , p_percent => p_percent_analyzed
3091: , x_return_status => x_return_status );
3092:

Line 3094: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L1_target;

3090: , p_percent => p_percent_analyzed
3091: , x_return_status => x_return_status );
3092:
3093: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3094: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L1_target;
3095: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3096: jty_log(FND_LOG.LEVEL_EXCEPTION,
3097: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',
3098: x_msg_data);

Line 3128: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3124:
3125: COMMIT;
3126:
3127: /*
3128: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3129: p_table_name => l_L2_target
3130: , p_percent => p_percent_analyzed
3131: , x_return_status => x_return_status );
3132:

Line 3134: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L2_target;

3130: , p_percent => p_percent_analyzed
3131: , x_return_status => x_return_status );
3132:
3133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3134: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L2_target;
3135: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3136: jty_log(FND_LOG.LEVEL_EXCEPTION,
3137: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',
3138: x_msg_data);

Line 3168: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3164:
3165: COMMIT;
3166:
3167: /*
3168: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3169: p_table_name => l_L3_target
3170: , p_percent => p_percent_analyzed
3171: , x_return_status => x_return_status );
3172:

Line 3174: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L3_target;

3170: , p_percent => p_percent_analyzed
3171: , x_return_status => x_return_status );
3172:
3173: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3174: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L3_target;
3175: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3176: jty_log(FND_LOG.LEVEL_EXCEPTION,
3177: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',
3178: x_msg_data);

Line 3208: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3204:
3205: COMMIT;
3206:
3207: /*
3208: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3209: p_table_name => l_L4_target
3210: , p_percent => p_percent_analyzed
3211: , x_return_status => x_return_status );
3212:

Line 3214: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L4_target;

3210: , p_percent => p_percent_analyzed
3211: , x_return_status => x_return_status );
3212:
3213: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3214: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L4_target;
3215: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3216: jty_log(FND_LOG.LEVEL_EXCEPTION,
3217: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',
3218: x_msg_data);

Line 3248: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3244:
3245: COMMIT;
3246:
3247: /*
3248: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3249: p_table_name => l_L5_target
3250: , p_percent => p_percent_analyzed
3251: , x_return_status => x_return_status );
3252:

Line 3254: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L5_target;

3250: , p_percent => p_percent_analyzed
3251: , x_return_status => x_return_status );
3252:
3253: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3254: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L5_target;
3255: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3256: jty_log(FND_LOG.LEVEL_EXCEPTION,
3257: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',
3258: x_msg_data);

Line 3286: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3282:
3283: COMMIT;
3284:
3285: /*
3286: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3287: p_table_name => l_wt_target
3288: , p_percent => p_percent_analyzed
3289: , x_return_status => x_return_status );
3290:

Line 3292: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_wt_target;

3288: , p_percent => p_percent_analyzed
3289: , x_return_status => x_return_status );
3290:
3291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3292: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_wt_target;
3293: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3294: jty_log(FND_LOG.LEVEL_EXCEPTION,
3295: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',
3296: x_msg_data);

Line 3601: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3597:
3598: IF p_oic_mode = 'WINNER/POST' OR p_oic_mode = 'NOOIC'
3599: THEN
3600: /* Analyze Winners table */
3601: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3602: p_table_name => l_winner_target
3603: , p_percent => p_percent_analyzed
3604: , x_return_status => x_return_status );
3605:

Line 3607: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;

3603: , p_percent => p_percent_analyzed
3604: , x_return_status => x_return_status );
3605:
3606: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3607: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;
3608: jty_log(FND_LOG.LEVEL_EXCEPTION,
3609: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',
3610: x_msg_data);
3611: RAISE FND_API.G_EXC_ERROR;

Line 3843: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3839: END IF; -- End of addition for p_oic_mode check
3840:
3841: IF p_oic_mode = 'MATCH/POST' or p_oic_mode ='NOOIC'
3842: THEN
3843: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3844: p_table_name => l_match_target
3845: , p_percent => p_percent_analyzed
3846: , x_return_status => x_return_status );
3847:

Line 3851: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);

3847:
3848: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3849: jty_log(FND_LOG.LEVEL_EXCEPTION,
3850: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
3851: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);
3852:
3853: RAISE FND_API.G_EXC_ERROR;
3854: RETCODE := 2;
3855: x_msg_count := 1;

Line 3856: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target;

3852:
3853: RAISE FND_API.G_EXC_ERROR;
3854: RETCODE := 2;
3855: x_msg_count := 1;
3856: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target;
3857: errbuf := x_msg_data;
3858: END IF;
3859: END IF;
3860: -- debug message