APPS.JTF_TERR_ASSIGN_PUB dependencies on FND_LOG

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

120:
121: BEGIN
122:
123: -- debug message
124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
126: 'jtf.plsql.jtf_terr_assign_pub.get_winners.begin',
127: 'Start of the procedure jtf_terr_assign_pub.get_winners');
128: END IF;

Line 125: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

121: BEGIN
122:
123: -- debug message
124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
126: 'jtf.plsql.jtf_terr_assign_pub.get_winners.begin',
127: 'Start of the procedure jtf_terr_assign_pub.get_winners');
128: END IF;
129:

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

815: ,x_msg_count => x_msg_count
816: ,x_msg_data => x_msg_data);
817:
818: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
819: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
820: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
821: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
822: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
823: END IF;

Line 820: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

816: ,x_msg_data => x_msg_data);
817:
818: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
819: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
820: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
821: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
822: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
823: END IF;
824: RAISE FND_API.G_EXC_ERROR;

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

824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826:
827: -- debug message
828: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
829: FND_LOG.string(FND_LOG.LEVEL_EVENT,
830: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
831: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
832: END IF;

Line 829: FND_LOG.string(FND_LOG.LEVEL_EVENT,

825: END IF;
826:
827: -- debug message
828: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
829: FND_LOG.string(FND_LOG.LEVEL_EVENT,
830: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_match',
831: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
832: END IF;
833:

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

843: ,x_msg_data => x_msg_data
844: ,x_winners_rec => lx_winners_rec);
845:
846: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
847: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
849: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
850: 'JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
851: END IF;

Line 848: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

844: ,x_winners_rec => lx_winners_rec);
845:
846: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
847: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
849: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
850: 'JTY_ASSIGN_REALTIME_PUB.process_winners has failed');
851: END IF;
852: RAISE FND_API.G_EXC_ERROR;

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

852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: -- debug message
856: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.string(FND_LOG.LEVEL_EVENT,
858: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
859: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
860: END IF;

Line 857: FND_LOG.string(FND_LOG.LEVEL_EVENT,

853: END IF;
854:
855: -- debug message
856: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.string(FND_LOG.LEVEL_EVENT,
858: 'jtf.plsql.jtf_terr_assign_pub.get_winners.process_winners',
859: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_winners');
860: END IF;
861:

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

896:
897: END IF; /* IF ( l_num_of_terr > 0 ) THEN */
898:
899: -- debug message
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
902: 'jtf.plsql.jtf_terr_assign_pub.get_winners.end',
903: 'End of the procedure jtf_terr_assign_pub.get_winners');
904: END IF;

Line 901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

897: END IF; /* IF ( l_num_of_terr > 0 ) THEN */
898:
899: -- debug message
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
902: 'jtf.plsql.jtf_terr_assign_pub.get_winners.end',
903: 'End of the procedure jtf_terr_assign_pub.get_winners');
904: END IF;
905:

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

904: END IF;
905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
910: 'jtf.plsql.jtf_terr_assign_pub.get_winners.g_exc_error',
911: substr(x_msg_data, 1, 4000));
912: END IF;

Line 909: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
910: 'jtf.plsql.jtf_terr_assign_pub.get_winners.g_exc_error',
911: substr(x_msg_data, 1, 4000));
912: END IF;
913:

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

914: WHEN OTHERS THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916: x_msg_data := SQLCODE || ' : ' || SQLERRM;
917: x_msg_count := 1;
918: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
920: 'jtf.plsql.jtf_terr_assign_pub.get_winners.other',
921: substr(x_msg_data, 1, 4000));
922: END IF;

Line 919: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916: x_msg_data := SQLCODE || ' : ' || SQLERRM;
917: x_msg_count := 1;
918: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
920: 'jtf.plsql.jtf_terr_assign_pub.get_winners.other',
921: substr(x_msg_data, 1, 4000));
922: END IF;
923: