DBA Data[Home] [Help]

APPS.JTY_TERR_SPARES_PVT dependencies on FND_LOG

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

342: lx_winners_rec JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type;
343: BEGIN
344:
345: -- debug message
346: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
347: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
348: 'jtf.plsql.jtf_terr_service_pub.process_match_terr_spares.start',
349: 'Start of the procedure jtf_terr_service_pub.process_match_terr_spares');
350: END IF;

Line 347: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

343: BEGIN
344:
345: -- debug message
346: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
347: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,
348: 'jtf.plsql.jtf_terr_service_pub.process_match_terr_spares.start',
349: 'Start of the procedure jtf_terr_service_pub.process_match_terr_spares');
350: END IF;
351:

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

368: -- API body
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: -- debug message
372: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
374: 'jtf.plsql.JTY_TERR_SPARES_PVT.process_match_terr_spares.parameters',
375: 'Country : ' || p_TerrServReq_Rec.COUNTRY || ' City : ' || p_TerrServReq_Rec.CITY ||
376: ' Postal Code : ' || p_TerrServReq_Rec.POSTAL_CODE || ' State : ' || p_TerrServReq_Rec.STATE ||

Line 373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: -- debug message
372: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
374: 'jtf.plsql.JTY_TERR_SPARES_PVT.process_match_terr_spares.parameters',
375: 'Country : ' || p_TerrServReq_Rec.COUNTRY || ' City : ' || p_TerrServReq_Rec.CITY ||
376: ' Postal Code : ' || p_TerrServReq_Rec.POSTAL_CODE || ' State : ' || p_TerrServReq_Rec.STATE ||
377: ' Area Code : ' || p_TerrServReq_Rec.AREA_CODE || ' County : ' || p_TerrServReq_Rec.COUNTY ||

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

659: ,x_msg_count => x_msg_count
660: ,x_msg_data => x_msg_data);
661:
662: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
663: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
664: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
665: 'jtf.plsql.JTY_TERR_SPARES_PVT.process_match_terr_spares.process_match',
666: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
667: END IF;

Line 664: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

660: ,x_msg_data => x_msg_data);
661:
662: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
663: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
664: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
665: 'jtf.plsql.JTY_TERR_SPARES_PVT.process_match_terr_spares.process_match',
666: 'API JTY_ASSIGN_REALTIME_PUB.process_match has failed');
667: END IF;
668: RAISE FND_API.G_EXC_ERROR;

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

668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: -- debug message
672: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.string(FND_LOG.LEVEL_EVENT,
674: 'jtf.plsql.jtf_terr_service_pub.process_match_terr_spares.process_match',
675: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
676: END IF;

Line 673: FND_LOG.string(FND_LOG.LEVEL_EVENT,

669: END IF;
670:
671: -- debug message
672: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.string(FND_LOG.LEVEL_EVENT,
674: 'jtf.plsql.jtf_terr_service_pub.process_match_terr_spares.process_match',
675: 'Finish calling procedure JTY_ASSIGN_REALTIME_PUB.process_match');
676: END IF;
677:

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

682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684: x_msg_data := SQLCODE || ' : ' || SQLERRM;
685: x_msg_count := 1;
686: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
688: 'jtf.plsql.JTY_TERR_SPARES_PVT.process_match_terr_spares.other',
689: substr(x_msg_data, 1, 4000));
690: END IF;

Line 687: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684: x_msg_data := SQLCODE || ' : ' || SQLERRM;
685: x_msg_count := 1;
686: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
687: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
688: 'jtf.plsql.JTY_TERR_SPARES_PVT.process_match_terr_spares.other',
689: substr(x_msg_data, 1, 4000));
690: END IF;
691: END process_match_terr_spares;