663:
664: BEGIN
665: -- Update the calling sequence
666: --
667: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
668:
669: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY<-' ||
670: X_calling_sequence;
671:
733: APP_EXCEPTION.RAISE_EXCEPTION;
734: END IF;
735:
736: IF (g_level_procedure >= g_current_runtime_level ) THEN
737: FND_LOG.STRING(g_level_procedure,
738: 'JL.PLSQL.JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY',
739: 'New Category created in MTL_CATEGORIES_B. '||
740: 'Category_Id : '||l_category_id);
741: END IF;
741: END IF;
742:
743: ELSE -- Category already exists
744: IF (g_level_procedure >= g_current_runtime_level ) THEN
745: FND_LOG.STRING(g_level_procedure,
746: 'JL.PLSQL.JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY',
747: 'Category Already Exists in MTL_CATEGORIES_B. '||
748: 'Category_Id : '||l_category_id);
749: END IF;
934: END Update_Category;
935:
936: -- Constructor
937: BEGIN
938: g_level_statement := FND_LOG.LEVEL_STATEMENT;
939: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
940: g_level_event := FND_LOG.LEVEL_EVENT;
941: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
942: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
935:
936: -- Constructor
937: BEGIN
938: g_level_statement := FND_LOG.LEVEL_STATEMENT;
939: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
940: g_level_event := FND_LOG.LEVEL_EVENT;
941: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
942: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
943:
936: -- Constructor
937: BEGIN
938: g_level_statement := FND_LOG.LEVEL_STATEMENT;
939: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
940: g_level_event := FND_LOG.LEVEL_EVENT;
941: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
942: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
943:
944: END JL_ZZ_AR_TX_FSC_CLS_PKG;
937: BEGIN
938: g_level_statement := FND_LOG.LEVEL_STATEMENT;
939: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
940: g_level_event := FND_LOG.LEVEL_EVENT;
941: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
942: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
943:
944: END JL_ZZ_AR_TX_FSC_CLS_PKG;
938: g_level_statement := FND_LOG.LEVEL_STATEMENT;
939: g_level_procedure := FND_LOG.LEVEL_PROCEDURE;
940: g_level_event := FND_LOG.LEVEL_EVENT;
941: g_level_exception := FND_LOG.LEVEL_EXCEPTION;
942: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
943:
944: END JL_ZZ_AR_TX_FSC_CLS_PKG;