APPS.JTY_ASSIGN_REALTIME_PUB dependencies on JTY_ASSIGN_BULK_PUB

Line 911: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (

907: DELETE FROM JTF_TERR_RESULTS_GT_L4;
908: DELETE FROM JTF_TERR_RESULTS_GT_L5;
909: DELETE FROM JTF_TERR_RESULTS_GT_WT;
910:
911: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (
912: p_terr_LEVEL_target_tbl => l_terr_L1_target,
913: p_terr_PARENT_LEVEL_tbl => l_terr_L1_target,
914: p_UPPER_LEVEL_FROM_ROOT => 1,
915: p_LOWER_LEVEL_FROM_ROOT => 1,

Line 926: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 1';

922: );
923:
924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
925: -- debug message
926: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 1';
927: x_msg_count := 1;
928: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
929: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
930: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l1',

Line 948: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (

944: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l1',
945: 'Number of records inserted into jtf_terr_results_gt_l1 table : ' || l_winner_no_of_records);
946: END IF;
947:
948: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (
949: p_terr_LEVEL_target_tbl => l_terr_L2_target,
950: p_terr_PARENT_LEVEL_tbl => l_terr_L1_target,
951: p_UPPER_LEVEL_FROM_ROOT => 1,
952: p_LOWER_LEVEL_FROM_ROOT => 2,

Line 963: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 2';

959: );
960:
961: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
962: -- debug message
963: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 2';
964: x_msg_count := 1;
965: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
967: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l2',

Line 985: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (

981: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l2',
982: 'Number of records inserted into jtf_terr_results_gt_l2 table : ' || l_winner_no_of_records);
983: END IF;
984:
985: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (
986: p_terr_LEVEL_target_tbl => l_terr_L3_target,
987: p_terr_PARENT_LEVEL_tbl => l_terr_L2_target,
988: p_UPPER_LEVEL_FROM_ROOT => 2,
989: p_LOWER_LEVEL_FROM_ROOT => 3,

Line 1000: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 3';

996: );
997:
998: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
999: -- debug message
1000: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 3';
1001: x_msg_count := 1;
1002: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1003: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1004: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l3',

Line 1022: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (

1018: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l3',
1019: 'Number of records inserted into jtf_terr_results_gt_l3 table : ' || l_winner_no_of_records);
1020: END IF;
1021:
1022: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (
1023: p_terr_LEVEL_target_tbl => l_terr_L4_target,
1024: p_terr_PARENT_LEVEL_tbl => l_terr_L3_target,
1025: p_UPPER_LEVEL_FROM_ROOT => 3,
1026: p_LOWER_LEVEL_FROM_ROOT => 4,

Line 1037: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 4';

1033: );
1034:
1035: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1036: -- debug message
1037: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 4';
1038: x_msg_count := 1;
1039: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1040: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1041: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l4',

Line 1059: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (

1055: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l4',
1056: 'Number of records inserted into jtf_terr_results_gt_l4 table : ' || l_winner_no_of_records);
1057: END IF;
1058:
1059: JTY_ASSIGN_BULK_PUB.Process_Level_Winners (
1060: p_terr_LEVEL_target_tbl => l_terr_L5_target,
1061: p_terr_PARENT_LEVEL_tbl => l_terr_L4_target,
1062: p_UPPER_LEVEL_FROM_ROOT => 4,
1063: p_LOWER_LEVEL_FROM_ROOT => 5,

Line 1074: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 5';

1070: );
1071:
1072: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1073: -- debug message
1074: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed for level 5';
1075: x_msg_count := 1;
1076: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1077: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1078: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l5',

Line 1096: JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners (

1092: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.l5',
1093: 'Number of records inserted into jtf_terr_results_gt_l5 table : ' || l_winner_no_of_records);
1094: END IF;
1095:
1096: JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners (
1097: p_terr_LEVEL_target_tbl => l_terr_WT_target,
1098: p_terr_L5_target_tbl => l_terr_L5_target,
1099: p_matches_target => l_matches_target,
1100: p_source_id => p_source_id,

Line 1109: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners has failed';

1105: );
1106:
1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1108: -- debug message
1109: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners has failed';
1110: x_msg_count := 1;
1111: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1112: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1113: 'jtf.plsql.JTY_ASSIGN_REALTIME_PUB.multi_level_winning_process.wt',