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 670: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

666: 'Deleting data and dropping indexes from ' || l_trans_target);
667: END IF;
668:
669: /* Drop the indexes on the TRANS table */
670: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
671: p_table_name => l_trans_target
672: ,x_return_status => x_return_status );
673:
674: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

672: ,x_return_status => x_return_status );
673:
674: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
675: -- debug message
676: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_trans_target;
677: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
678: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
679: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
680: x_msg_data);

Line 687: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686: /* Truncate the TRANS table */
687: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
688: p_table_name => l_trans_target
689: ,x_return_status => x_return_status );
690:
691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

689: ,x_return_status => x_return_status );
690:
691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
692: -- debug message
693: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_trans_target;
694: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
695: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
696: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
697: x_msg_data);

Line 716: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

712: 'Deleting data and dropping indexes from ' || l_match_target);
713: END IF;
714:
715: /* Drop the indexes on the MATCH table */
716: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
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 723: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_match_target;

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

Line 734: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

730: RAISE FND_API.G_EXC_ERROR;
731: END IF;
732:
733: /* Truncate the MATCH table */
734: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
735: p_table_name => l_match_target
736: ,x_return_status => x_return_status );
737:
738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

736: ,x_return_status => x_return_status );
737:
738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
739: -- debug message
740: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_match_target;
741: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
743: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
744: x_msg_data);

Line 763: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

759: 'Deleting data and dropping indexes from ' || l_umatch_target);
760: END IF;
761:
762: /* Drop the indexes on the UMATCH table */
763: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
764: p_table_name => l_umatch_target
765: ,x_return_status => x_return_status );
766:
767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

766:
767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
768:
769: -- debug message
770: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_umatch_target;
771: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
772: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
773: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
774: x_msg_data);

Line 781: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

777: RAISE FND_API.G_EXC_ERROR;
778: END IF;
779:
780: /* Truncate the UMATCH table */
781: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
782: p_table_name => l_umatch_target
783: ,x_return_status => x_return_status );
784:
785: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

783: ,x_return_status => x_return_status );
784:
785: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
786: -- debug message
787: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_umatch_target;
788: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
790: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
791: x_msg_data);

Line 810: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

806: 'Deleting data and dropping indexes from ' || l_winner_target);
807: END IF;
808:
809: /* Drop the indexes on the WINNER table */
810: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
811: p_table_name => l_winner_target
812: ,x_return_status => x_return_status );
813:
814: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

813:
814: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
815:
816: -- debug message
817: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_winner_target;
818: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
819: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
820: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
821: x_msg_data);

Line 828: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826:
827: /* Truncate the WINNER table */
828: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
829: p_table_name => l_winner_target
830: ,x_return_status => x_return_status );
831:
832: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

830: ,x_return_status => x_return_status );
831:
832: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
833: -- debug message
834: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_winner_target;
835: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
837: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
838: x_msg_data);

Line 857: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

853: 'Deleting data and dropping indexes from ' || l_uwinner_target);
854: END IF;
855:
856: /* Drop the indexes on the UWINNER table */
857: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
858: p_table_name => l_uwinner_target
859: ,x_return_status => x_return_status );
860:
861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

860:
861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
862:
863: -- debug message
864: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_uwinner_target;
865: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
866: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
867: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
868: x_msg_data);

Line 875: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873:
874: /* Truncate the UWINNER table */
875: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
876: p_table_name => l_uwinner_target
877: ,x_return_status => x_return_status );
878:
879: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

877: ,x_return_status => x_return_status );
878:
879: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
880: -- debug message
881: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_uwinner_target;
882: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
884: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
885: x_msg_data);

Line 904: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

900: 'Deleting data and dropping indexes from ' || l_l1_target);
901: END IF;
902:
903: /* Drop the indexes on the L1 table */
904: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
905: p_table_name => l_l1_target
906: ,x_return_status => x_return_status );
907:
908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

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

Line 922: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

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

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

Line 951: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

947: 'Deleting data and dropping indexes from ' || l_l2_target);
948: END IF;
949:
950: /* Drop the indexes on the L2 table */
951: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
952: p_table_name => l_l2_target
953: ,x_return_status => x_return_status );
954:
955: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

954:
955: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
956:
957: -- debug message
958: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l2_target;
959: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
961: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
962: x_msg_data);

Line 969: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:
968: /* Truncate the L2 table */
969: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
970: p_table_name => l_l2_target
971: ,x_return_status => x_return_status );
972:
973: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

971: ,x_return_status => x_return_status );
972:
973: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
974: -- debug message
975: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l2_target;
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
978: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
979: x_msg_data);

Line 998: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

994: 'Deleting data and dropping indexes from ' || l_l3_target);
995: END IF;
996:
997: /* Drop the indexes on the L3 table */
998: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
999: p_table_name => l_l3_target
1000: ,x_return_status => x_return_status );
1001:
1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1001:
1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1003:
1004: -- debug message
1005: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l3_target;
1006: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1007: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1008: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1009: x_msg_data);

Line 1016: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:
1015: /* Truncate the L3 table */
1016: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1017: p_table_name => l_l3_target
1018: ,x_return_status => x_return_status );
1019:
1020: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1018: ,x_return_status => x_return_status );
1019:
1020: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1021: -- debug message
1022: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l3_target;
1023: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1025: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1026: x_msg_data);

Line 1045: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1041: 'Deleting data and dropping indexes from ' || l_l4_target);
1042: END IF;
1043:
1044: /* Drop the indexes on the L4 table */
1045: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1046: p_table_name => l_l4_target
1047: ,x_return_status => x_return_status );
1048:
1049: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1048:
1049: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1050:
1051: -- debug message
1052: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l4_target;
1053: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1055: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1056: x_msg_data);

Line 1063: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1059: RAISE FND_API.G_EXC_ERROR;
1060: END IF;
1061:
1062: /* Truncate the L4 table */
1063: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1064: p_table_name => l_l4_target
1065: ,x_return_status => x_return_status );
1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1065: ,x_return_status => x_return_status );
1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: -- debug message
1069: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l4_target;
1070: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1072: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1073: x_msg_data);

Line 1092: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1088: 'Deleting data and dropping indexes from ' || l_l5_target);
1089: END IF;
1090:
1091: /* Drop the indexes on the L5 table */
1092: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1093: p_table_name => l_l5_target
1094: ,x_return_status => x_return_status );
1095:
1096: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1095:
1096: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1097:
1098: -- debug message
1099: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l5_target;
1100: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1102: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1103: x_msg_data);

Line 1110: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108:
1109: /* Truncate the L5 table */
1110: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1111: p_table_name => l_l5_target
1112: ,x_return_status => x_return_status );
1113:
1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1112: ,x_return_status => x_return_status );
1113:
1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1115: -- debug message
1116: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l5_target;
1117: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1118: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1119: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1120: x_msg_data);

Line 1139: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

1135: 'Deleting data and dropping indexes from ' || l_wt_target);
1136: END IF;
1137:
1138: /* Drop the indexes on the WT table */
1139: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1140: p_table_name => l_wt_target
1141: ,x_return_status => x_return_status );
1142:
1143: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1142:
1143: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1144:
1145: -- debug message
1146: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_wt_target;
1147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1149: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1150: x_msg_data);

Line 1157: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155:
1156: /* Truncate the WT table */
1157: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1158: p_table_name => l_wt_target
1159: ,x_return_status => x_return_status );
1160:
1161: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

1159: ,x_return_status => x_return_status );
1160:
1161: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1162: -- debug message
1163: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_wt_target;
1164: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1165: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1166: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1167: x_msg_data);

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

1425: -- debug message
1426: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1428: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',
1429: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);
1430: END IF;
1431:
1432: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1433: p_table_name => l_trans_target

Line 1432: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

1428: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',
1429: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);
1430: END IF;
1431:
1432: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1433: p_table_name => l_trans_target
1434: , p_percent => p_percent_analyzed
1435: , x_return_status => x_return_status );
1436:

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

1435: , x_return_status => x_return_status );
1436:
1437: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1438: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1439: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' || l_trans_target;
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;
1442:
1443: -- debug message

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

1473: -- debug message
1474: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1476: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_matches',
1477: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);
1478: END IF;
1479:
1480: /* Build Index on Matches table */
1481: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1481: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1477: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);
1478: END IF;
1479:
1480: /* Build Index on Matches table */
1481: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1482: ( p_table_name => l_match_target,
1483: p_trans_id => p_trans_id,
1484: p_source_id => p_source_id,
1485: p_program_name => p_program_name,

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

1487: x_Return_Status => x_return_status,
1488: p_run_mode => 'MATCH');
1489:
1490: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_match_target;
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:
1495: -- debug message

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

1495: -- debug message
1496: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1497: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1498: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_winners',
1499: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);
1500: END IF;
1501:
1502: /* Build Index on Winners table */
1503: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1503: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1499: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);
1500: END IF;
1501:
1502: /* Build Index on Winners table */
1503: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1504: ( p_table_name => l_winner_target,
1505: p_trans_id => p_trans_id,
1506: p_source_id => p_source_id,
1507: p_program_name => p_program_name,

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

1509: x_Return_Status => x_return_status,
1510: p_run_mode => 'WINNER');
1511:
1512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1513: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_winner_target;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:
1517: -- debug message

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

1517: -- debug message
1518: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1520: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l1',
1521: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);
1522: END IF;
1523:
1524: /* Build Index on L1 table */
1525: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1525: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1521: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);
1522: END IF;
1523:
1524: /* Build Index on L1 table */
1525: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1526: ( p_table_name => l_l1_target,
1527: p_trans_id => p_trans_id,
1528: p_source_id => p_source_id,
1529: p_program_name => p_program_name,

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

1531: x_Return_Status => x_return_status,
1532: p_run_mode => 'TEMP_WINNER');
1533:
1534: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1535: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l1_target;
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539: -- debug message

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

1539: -- debug message
1540: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1542: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l2',
1543: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);
1544: END IF;
1545:
1546: /* Build Index on L2 table */
1547: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1547: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1543: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);
1544: END IF;
1545:
1546: /* Build Index on L2 table */
1547: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1548: ( p_table_name => l_l2_target,
1549: p_trans_id => p_trans_id,
1550: p_source_id => p_source_id,
1551: p_program_name => p_program_name,

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

1553: x_Return_Status => x_return_status,
1554: p_run_mode => 'TEMP_WINNER');
1555:
1556: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1557: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l2_target;
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;
1560:
1561:

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

1562: -- debug message
1563: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1564: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1565: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l3',
1566: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);
1567: END IF;
1568:
1569: /* Build Index on L3 table */
1570: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1570: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1566: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);
1567: END IF;
1568:
1569: /* Build Index on L3 table */
1570: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1571: ( p_table_name => l_l3_target,
1572: p_trans_id => p_trans_id,
1573: p_source_id => p_source_id,
1574: p_program_name => p_program_name,

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

1576: x_Return_Status => x_return_status,
1577: p_run_mode => 'TEMP_WINNER');
1578:
1579: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1580: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l3_target;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583:
1584: -- debug message

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

1584: -- debug message
1585: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1587: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l4',
1588: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);
1589: END IF;
1590:
1591: /* Build Index on L4 table */
1592: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1592: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1588: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);
1589: END IF;
1590:
1591: /* Build Index on L4 table */
1592: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1593: ( p_table_name => l_l4_target,
1594: p_trans_id => p_trans_id,
1595: p_source_id => p_source_id,
1596: p_program_name => p_program_name,

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

1598: x_Return_Status => x_return_status,
1599: p_run_mode => 'TEMP_WINNER');
1600:
1601: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l4_target;
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605:
1606: -- debug message

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

1606: -- debug message
1607: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1608: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1609: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l5',
1610: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);
1611: END IF;
1612:
1613: /* Build Index on L5 table */
1614: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1614: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1610: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);
1611: END IF;
1612:
1613: /* Build Index on L5 table */
1614: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1615: ( p_table_name => l_l5_target,
1616: p_trans_id => p_trans_id,
1617: p_source_id => p_source_id,
1618: p_program_name => p_program_name,

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

1620: x_Return_Status => x_return_status,
1621: p_run_mode => 'TEMP_WINNER');
1622:
1623: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1624: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l5_target;
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: -- debug message

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

1628: -- debug message
1629: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1631: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_wt',
1632: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);
1633: END IF;
1634:
1635: /* Build Index on WT table */
1636: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1636: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

1632: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);
1633: END IF;
1634:
1635: /* Build Index on WT table */
1636: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX
1637: ( p_table_name => l_wt_target,
1638: p_trans_id => p_trans_id,
1639: p_source_id => p_source_id,
1640: p_program_name => p_program_name,

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

1642: x_Return_Status => x_return_status,
1643: p_run_mode => 'TEMP_WINNER');
1644:
1645: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1646: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_wt_target;
1647: RAISE FND_API.G_EXC_ERROR;
1648: END IF;
1649:
1650: /* if mode is incremental, update the worker_id column for the TRANS table */

Line 3261: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3257:
3258: COMMIT;
3259:
3260: /*
3261: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3262: p_table_name => l_L1_target
3263: , p_percent => p_percent_analyzed
3264: , x_return_status => x_return_status );
3265:

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

3263: , p_percent => p_percent_analyzed
3264: , x_return_status => x_return_status );
3265:
3266: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3267: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L1_target;
3268: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3269: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3270: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',
3271: x_msg_data);

Line 3303: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3299:
3300: COMMIT;
3301:
3302: /*
3303: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3304: p_table_name => l_L2_target
3305: , p_percent => p_percent_analyzed
3306: , x_return_status => x_return_status );
3307:

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

3305: , p_percent => p_percent_analyzed
3306: , x_return_status => x_return_status );
3307:
3308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3309: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L2_target;
3310: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3311: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3312: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',
3313: x_msg_data);

Line 3345: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3341:
3342: COMMIT;
3343:
3344: /*
3345: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3346: p_table_name => l_L3_target
3347: , p_percent => p_percent_analyzed
3348: , x_return_status => x_return_status );
3349:

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

3347: , p_percent => p_percent_analyzed
3348: , x_return_status => x_return_status );
3349:
3350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3351: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L3_target;
3352: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3354: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',
3355: x_msg_data);

Line 3387: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3383:
3384: COMMIT;
3385:
3386: /*
3387: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3388: p_table_name => l_L4_target
3389: , p_percent => p_percent_analyzed
3390: , x_return_status => x_return_status );
3391:

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

3389: , p_percent => p_percent_analyzed
3390: , x_return_status => x_return_status );
3391:
3392: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3393: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L4_target;
3394: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3395: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',
3397: x_msg_data);

Line 3429: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3425:
3426: COMMIT;
3427:
3428: /*
3429: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3430: p_table_name => l_L5_target
3431: , p_percent => p_percent_analyzed
3432: , x_return_status => x_return_status );
3433:

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

3431: , p_percent => p_percent_analyzed
3432: , x_return_status => x_return_status );
3433:
3434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3435: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L5_target;
3436: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3437: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3438: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',
3439: x_msg_data);

Line 3469: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3465:
3466: COMMIT;
3467:
3468: /*
3469: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3470: p_table_name => l_wt_target
3471: , p_percent => p_percent_analyzed
3472: , x_return_status => x_return_status );
3473:

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

3471: , p_percent => p_percent_analyzed
3472: , x_return_status => x_return_status );
3473:
3474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3475: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_wt_target;
3476: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3477: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3478: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',
3479: x_msg_data);

Line 3786: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

3782: END;
3783: END IF; /* end IF (l_multi_level_winning_flag <> 'Y') */
3784:
3785: /* Analyze Winners table */
3786: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
3787: p_table_name => l_winner_target
3788: , p_percent => p_percent_analyzed
3789: , x_return_status => x_return_status );
3790:

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

3788: , p_percent => p_percent_analyzed
3789: , x_return_status => x_return_status );
3790:
3791: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3792: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;
3793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3795: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',
3796: x_msg_data);

Line 4016: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

4012: END LOOP;
4013:
4014: END IF;
4015:
4016: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
4017: p_table_name => l_match_target
4018: , p_percent => p_percent_analyzed
4019: , x_return_status => x_return_status );
4020:

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

4021: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4022: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4023: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
4025: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);
4026: END IF;
4027:
4028: RAISE FND_API.G_EXC_ERROR;
4029: RETCODE := 2;

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

4027:
4028: RAISE FND_API.G_EXC_ERROR;
4029: RETCODE := 2;
4030: x_msg_count := 1;
4031: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target;
4032: errbuf := x_msg_data;
4033: END IF;
4034:
4035: -- debug message