[Home] [Help]
1: PACKAGE BODY JTY_TERR_SPARES_PVT AS
2: /* $Header: jtftsprmgb.pls 120.2 2010/09/21 11:08:43 sseshaiy noship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_SPARES_PVT
1: PACKAGE BODY JTY_TERR_SPARES_PVT AS
2: /* $Header: jtftsprmgb.pls 120.2 2010/09/21 11:08:43 sseshaiy noship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTY_TERR_SPARES_PVT
6: -- PURPOSE
7: --
8: -- Procedures:
9: -- (see below for specification)
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 ||
378: ' Company Name Range : ' || p_TerrServReq_Rec.COMP_NAME_RANGE || ' Province : ' || p_TerrServReq_Rec.PROVINCE ||
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;
669: END IF;
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;
692:
689: substr(x_msg_data, 1, 4000));
690: END IF;
691: END process_match_terr_spares;
692:
693: END JTY_TERR_SPARES_PVT;