170:
171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row)
175: AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row(
176: px_stylesheet_id => l_stylesheet_id,
177: p_content_type => p_iba_pl_stylesheets_rec.content_type,
178: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,
171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row)
175: AMS_IBA_PL_STYLESHTS_B_PKG.Insert_Row(
176: px_stylesheet_id => l_stylesheet_id,
177: p_content_type => p_iba_pl_stylesheets_rec.content_type,
178: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,
179: p_status_code => 'Active',
391:
392: -- Debug Message
393: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
394:
395: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row)
396: AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row(
397: p_stylesheet_id => p_iba_pl_stylesheets_rec.stylesheet_id,
398: p_content_type => p_iba_pl_stylesheets_rec.content_type,
399: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,
392: -- Debug Message
393: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
394:
395: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row)
396: AMS_IBA_PL_STYLESHTS_B_PKG.Update_Row(
397: p_stylesheet_id => p_iba_pl_stylesheets_rec.stylesheet_id,
398: p_content_type => p_iba_pl_stylesheets_rec.content_type,
399: p_stylesheet_filename => p_iba_pl_stylesheets_rec.stylesheet_filename,
400: p_status_code => p_iba_pl_stylesheets_rec.status_code,
544: FND_MSG_PUB.add;
545: END IF;
546: RAISE FND_API.g_exc_error;
547: ELSE
548: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row)
549: AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row(
550: p_STYLESHEET_ID => p_STYLESHEET_ID);
551: --
552: -- End of API body
545: END IF;
546: RAISE FND_API.g_exc_error;
547: ELSE
548: -- Invoke table handler(AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row)
549: AMS_IBA_PL_STYLESHTS_B_PKG.Delete_Row(
550: p_STYLESHEET_ID => p_STYLESHEET_ID);
551: --
552: -- End of API body
553: --