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.JTF_TERR_SERVICE_PUB dependencies on FND_LOG

Line 115: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

111: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
112: BEGIN
113:
114: -- debug message
115: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
117: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
118: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
119: END IF;

Line 116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

112: BEGIN
113:
114: -- debug message
115: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
117: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
118: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
119: END IF;
120:

Line 141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

137: -- API body
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- debug message
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
143: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
144: 'Country : ' || p_TerrServReq_Rec.COUNTRY || ' City : ' || upper(p_TerrServReq_Rec.CITY) ||
145: ' Postal Code : ' || p_TerrServReq_Rec.POSTAL_CODE || ' State : ' || p_TerrServReq_Rec.STATE ||

Line 142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- debug message
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
143: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
144: 'Country : ' || p_TerrServReq_Rec.COUNTRY || ' City : ' || upper(p_TerrServReq_Rec.CITY) ||
145: ' Postal Code : ' || p_TerrServReq_Rec.POSTAL_CODE || ' State : ' || p_TerrServReq_Rec.STATE ||
146: ' Area Code : ' || p_TerrServReq_Rec.AREA_CODE || ' County : ' || p_TerrServReq_Rec.COUNTY ||

Line 499: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

495: ,x_msg_count => x_msg_count
496: ,x_msg_data => x_msg_data);
497:
498: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
499: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
501: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
502: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
503: END IF;

Line 500: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

496: ,x_msg_data => x_msg_data);
497:
498: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
499: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
501: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
502: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
503: END IF;
504: RAISE FND_API.G_EXC_ERROR;

Line 508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: -- debug message
508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.string(FND_LOG.LEVEL_EVENT,
510: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
511: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
512: END IF;

Line 509: FND_LOG.string(FND_LOG.LEVEL_EVENT,

505: END IF;
506:
507: -- debug message
508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.string(FND_LOG.LEVEL_EVENT,
510: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
511: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
512: END IF;
513:

Line 529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

525: ,x_msg_data => x_msg_data
526: ,x_winners_rec => lx_winners_rec);
527:
528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
532: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
533: END IF;

Line 530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

526: ,x_winners_rec => lx_winners_rec);
527:
528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
531: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
532: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
533: END IF;
534: RAISE FND_API.G_EXC_ERROR;

Line 538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
537: -- debug message
538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FND_LOG.string(FND_LOG.LEVEL_EVENT,
540: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
541: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
542: END IF;

Line 539: FND_LOG.string(FND_LOG.LEVEL_EVENT,

535: END IF;
536:
537: -- debug message
538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FND_LOG.string(FND_LOG.LEVEL_EVENT,
540: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
541: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
542: END IF;
543:

Line 573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

569:
570: END LOOP;
571:
572: -- debug message
573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
575: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
576: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
577: END IF;

Line 574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

570: END LOOP;
571:
572: -- debug message
573: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
575: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
576: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
577: END IF;
578:

Line 581: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

577: END IF;
578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN
581: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
583: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
584: substr(x_msg_data, 1, 4000));
585: END IF;

Line 582: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN
581: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
583: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
584: substr(x_msg_data, 1, 4000));
585: END IF;
586:

Line 591: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

587: WHEN OTHERS THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
589: x_msg_data := SQLCODE || ' : ' || SQLERRM;
590: x_msg_count := 1;
591: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
592: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
593: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
594: substr(x_msg_data, 1, 4000));
595: END IF;

Line 592: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
589: x_msg_data := SQLCODE || ' : ' || SQLERRM;
590: x_msg_count := 1;
591: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
592: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
593: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
594: substr(x_msg_data, 1, 4000));
595: END IF;
596:

Line 659: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

655:
656: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
657: BEGIN
658: -- debug message
659: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
660: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
661: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
662: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
663: END IF;

Line 660: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

656: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
657: BEGIN
658: -- debug message
659: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
660: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
661: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
662: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
663: END IF;
664:

Line 686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

682: --
683: x_return_status := FND_API.G_RET_STS_SUCCESS;
684:
685: -- debug message
686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
688: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
689: 'Country : ' || p_TerrSrvTask_Rec.COUNTRY || ' City : ' || upper(p_TerrSrvTask_Rec.CITY) ||
690: ' Postal Code : ' || p_TerrSrvTask_Rec.POSTAL_CODE || ' State : ' || p_TerrSrvTask_Rec.STATE ||

Line 687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

683: x_return_status := FND_API.G_RET_STS_SUCCESS;
684:
685: -- debug message
686: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
688: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
689: 'Country : ' || p_TerrSrvTask_Rec.COUNTRY || ' City : ' || upper(p_TerrSrvTask_Rec.CITY) ||
690: ' Postal Code : ' || p_TerrSrvTask_Rec.POSTAL_CODE || ' State : ' || p_TerrSrvTask_Rec.STATE ||
691: ' Area Code : ' || p_TerrSrvTask_Rec.AREA_CODE || ' County : ' || p_TerrSrvTask_Rec.COUNTY ||

Line 1068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1064: ,x_msg_count => x_msg_count
1065: ,x_msg_data => x_msg_data);
1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1070: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1071: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
1072: END IF;

Line 1069: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1065: ,x_msg_data => x_msg_data);
1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1070: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1071: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
1072: END IF;
1073: RAISE FND_API.G_EXC_ERROR;

Line 1077: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075:
1076: -- debug message
1077: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1079: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1080: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
1081: END IF;

Line 1078: FND_LOG.string(FND_LOG.LEVEL_EVENT,

1074: END IF;
1075:
1076: -- debug message
1077: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1079: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1080: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
1081: END IF;
1082:

Line 1098: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1094: ,x_msg_data => x_msg_data
1095: ,x_winners_rec => lx_winners_rec);
1096:
1097: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1098: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1099: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1100: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1101: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
1102: END IF;

Line 1099: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1095: ,x_winners_rec => lx_winners_rec);
1096:
1097: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1098: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1099: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1100: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1101: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
1102: END IF;
1103: RAISE FND_API.G_EXC_ERROR;

Line 1107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: -- debug message
1107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1108: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1109: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1110: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
1111: END IF;

Line 1108: FND_LOG.string(FND_LOG.LEVEL_EVENT,

1104: END IF;
1105:
1106: -- debug message
1107: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1108: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1109: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1110: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
1111: END IF;
1112:

Line 1142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1138:
1139: END LOOP;
1140:
1141: -- debug message
1142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1144: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1145: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1146: END IF;

Line 1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1139: END LOOP;
1140:
1141: -- debug message
1142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1144: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1145: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1146: END IF;
1147:

Line 1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
1154: substr(x_msg_data, 1, 4000));
1155: END IF;

Line 1152: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1153: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
1154: substr(x_msg_data, 1, 4000));
1155: END IF;
1156:

Line 1161: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1157: WHEN OTHERS THEN
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1159: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1160: x_msg_count := 1;
1161: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1163: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
1164: substr(x_msg_data, 1, 4000));
1165: END IF;

Line 1162: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1159: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1160: x_msg_count := 1;
1161: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1163: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
1164: substr(x_msg_data, 1, 4000));
1165: END IF;
1166: