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 : ' || 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 : ' || 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 473: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

469: ,x_msg_count => x_msg_count
470: ,x_msg_data => x_msg_data);
471:
472: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
473: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
475: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
476: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
477: END IF;

Line 474: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

470: ,x_msg_data => x_msg_data);
471:
472: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
473: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
475: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
476: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
477: END IF;
478: RAISE FND_API.G_EXC_ERROR;

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

478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:
481: -- debug message
482: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.string(FND_LOG.LEVEL_EVENT,
484: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
485: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
486: END IF;

Line 483: FND_LOG.string(FND_LOG.LEVEL_EVENT,

479: END IF;
480:
481: -- debug message
482: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.string(FND_LOG.LEVEL_EVENT,
484: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
485: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
486: END IF;
487:

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

499: ,x_msg_data => x_msg_data
500: ,x_winners_rec => lx_winners_rec);
501:
502: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
503: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
504: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
505: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
506: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
507: END IF;

Line 504: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

500: ,x_winners_rec => lx_winners_rec);
501:
502: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
503: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
504: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
505: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
506: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
507: END IF;
508: RAISE FND_API.G_EXC_ERROR;

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

508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: -- debug message
512: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
513: FND_LOG.string(FND_LOG.LEVEL_EVENT,
514: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
515: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
516: END IF;

Line 513: FND_LOG.string(FND_LOG.LEVEL_EVENT,

509: END IF;
510:
511: -- debug message
512: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
513: FND_LOG.string(FND_LOG.LEVEL_EVENT,
514: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
515: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
516: END IF;
517:

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

543:
544: END LOOP;
545:
546: -- debug message
547: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
548: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
549: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
550: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
551: END IF;

Line 548: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

544: END LOOP;
545:
546: -- debug message
547: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
548: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
549: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
550: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
551: END IF;
552:

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

551: END IF;
552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
557: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
558: substr(x_msg_data, 1, 4000));
559: END IF;

Line 556: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
557: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
558: substr(x_msg_data, 1, 4000));
559: END IF;
560:

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

561: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: x_msg_data := SQLCODE || ' : ' || SQLERRM;
564: x_msg_count := 1;
565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
567: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
568: substr(x_msg_data, 1, 4000));
569: END IF;

Line 566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: x_msg_data := SQLCODE || ' : ' || SQLERRM;
564: x_msg_count := 1;
565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
567: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
568: substr(x_msg_data, 1, 4000));
569: END IF;
570:

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

629:
630: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
631: BEGIN
632: -- debug message
633: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
635: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
636: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
637: END IF;

Line 634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

630: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
631: BEGIN
632: -- debug message
633: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
635: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.start',
636: 'Start of the procedure jtf_terr_service_pub.get_winningterrmembers');
637: END IF;
638:

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

656: --
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: -- debug message
660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
662: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
663: 'Country : ' || p_TerrSrvTask_Rec.COUNTRY || ' City : ' || p_TerrSrvTask_Rec.CITY ||
664: ' Postal Code : ' || p_TerrSrvTask_Rec.POSTAL_CODE || ' State : ' || p_TerrSrvTask_Rec.STATE ||

Line 661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: -- debug message
660: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
662: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.parameters',
663: 'Country : ' || p_TerrSrvTask_Rec.COUNTRY || ' City : ' || p_TerrSrvTask_Rec.CITY ||
664: ' Postal Code : ' || p_TerrSrvTask_Rec.POSTAL_CODE || ' State : ' || p_TerrSrvTask_Rec.STATE ||
665: ' Area Code : ' || p_TerrSrvTask_Rec.AREA_CODE || ' County : ' || p_TerrSrvTask_Rec.COUNTY ||

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

1013: ,x_msg_count => x_msg_count
1014: ,x_msg_data => x_msg_data);
1015:
1016: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1017: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1019: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1020: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
1021: END IF;

Line 1018: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1014: ,x_msg_data => x_msg_data);
1015:
1016: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1017: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1019: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1020: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
1021: END IF;
1022: RAISE FND_API.G_EXC_ERROR;

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

1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024:
1025: -- debug message
1026: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1028: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1029: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
1030: END IF;

Line 1027: FND_LOG.string(FND_LOG.LEVEL_EVENT,

1023: END IF;
1024:
1025: -- debug message
1026: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1028: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_match',
1029: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
1030: END IF;
1031:

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

1043: ,x_msg_data => x_msg_data
1044: ,x_winners_rec => lx_winners_rec);
1045:
1046: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1049: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1050: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
1051: END IF;

Line 1048: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1044: ,x_winners_rec => lx_winners_rec);
1045:
1046: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1047: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1049: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1050: 'API JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
1051: END IF;
1052: RAISE FND_API.G_EXC_ERROR;

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

1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: -- debug message
1056: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1058: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1059: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
1060: END IF;

Line 1057: FND_LOG.string(FND_LOG.LEVEL_EVENT,

1053: END IF;
1054:
1055: -- debug message
1056: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.string(FND_LOG.LEVEL_EVENT,
1058: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.process_winners',
1059: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
1060: END IF;
1061:

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

1087:
1088: END LOOP;
1089:
1090: -- debug message
1091: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1092: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1093: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1094: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1095: END IF;

Line 1092: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

1088: END LOOP;
1089:
1090: -- debug message
1091: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1092: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
1093: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.end',
1094: 'End of the procedure jtf_terr_service_pub.get_winningterrmembers');
1095: END IF;
1096:

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

1096:
1097: EXCEPTION
1098: WHEN FND_API.G_EXC_ERROR THEN
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1100: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1102: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
1103: substr(x_msg_data, 1, 4000));
1104: END IF;

Line 1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1097: EXCEPTION
1098: WHEN FND_API.G_EXC_ERROR THEN
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1100: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1102: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.g_exc_error',
1103: substr(x_msg_data, 1, 4000));
1104: END IF;
1105:

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

1106: WHEN OTHERS THEN
1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1108: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1109: x_msg_count := 1;
1110: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1111: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1112: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
1113: substr(x_msg_data, 1, 4000));
1114: END IF;

Line 1111: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1108: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1109: x_msg_count := 1;
1110: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1111: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1112: 'jtf.plsql.jtf_terr_service_pub.get_winningterrmembers.other',
1113: substr(x_msg_data, 1, 4000));
1114: END IF;
1115: