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;
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:
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 ||
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 ||
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;
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;
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;
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:
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;
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;