DBA Data[Home] [Help]

APPS.CST_INVENTORY_PUB dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.Initialize;

65:
66: -- Initialize API message list if necessary
67: IF FND_API.To_Boolean(p_init_msg_list)
68: THEN
69: FND_MSG_PUB.Initialize;
70: END IF;
71:
72: -- Check for message level threshold
73: l_msg_level_threshold := FND_PROFILE.Value('FND_AS_MSG_LEVEL_THRESHOLD');

Line 79: FND_MSG_PUB.Add_Exc_Msg(

75:
76: -- Check for the value of p_commit
77: IF NOT FND_API.To_Boolean(p_commit)
78: THEN
79: FND_MSG_PUB.Add_Exc_Msg(
80: p_pkg_name => G_PKG_NAME,
81: p_procedure_name => l_api_name,
82: p_error_text => 'This API should not be called with p_commit set to false'
83: );

Line 87: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH

83: );
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86:
87: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
88: THEN
89: FND_MSG_PUB.Add_Exc_Msg(
90: p_pkg_name => G_PKG_NAME,
91: p_procedure_name => l_api_name,

Line 89: FND_MSG_PUB.Add_Exc_Msg(

85: END IF;
86:
87: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH
88: THEN
89: FND_MSG_PUB.Add_Exc_Msg(
90: p_pkg_name => G_PKG_NAME,
91: p_procedure_name => l_api_name,
92: p_error_text => SUBSTR(
93: l_stmt_num||':'||

Line 335: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS

331: END IF;
332: END IF;
333:
334: l_stmt_num := 80;
335: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg(
338: p_pkg_name => G_PKG_NAME,
339: p_procedure_name => l_api_name,

Line 337: FND_MSG_PUB.Add_Exc_Msg(

333:
334: l_stmt_num := 80;
335: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_SUCCESS
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg(
338: p_pkg_name => G_PKG_NAME,
339: p_procedure_name => l_api_name,
340: p_error_text => l_stmt_num||': Finished calculating inventory value'
341: );

Line 354: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: WHEN OTHERS THEN
352: ROLLBACK TO Calculate_InventoryValue_PUB;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg(
357: p_pkg_name => G_PKG_NAME,
358: p_procedure_name => l_api_name,

Line 356: FND_MSG_PUB.Add_Exc_Msg(

352: ROLLBACK TO Calculate_InventoryValue_PUB;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF l_msg_level_threshold <= FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg(
357: p_pkg_name => G_PKG_NAME,
358: p_procedure_name => l_api_name,
359: p_error_text => SUBSTR(l_stmt_num||SQLERRM,1,240)
360: );