DBA Data[Home] [Help]

APPS.PA_STATUS_LISTS_PVT dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.add_exc_msg

98: WHEN OTHERS THEN
99: x_msg_count := 1;
100: x_msg_data := substr(SQLERRM,1,240);
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MSG_PUB.add_exc_msg
103: (p_pkg_name => 'PA_STTUS_LISTS_PVT'
104: , p_procedure_name => PA_DEBUG.G_Err_Stack
105: , p_error_text => substr(SQLERRM,1,240));
106: RETURN;

Line 187: l_msg_count := FND_MSG_PUB.count_msg;

183: pa_debug.g_err_stage:= 'lock row method called';
184: pa_debug.write(g_module_name,pa_debug.g_err_stage,
185: l_debug_level3);
186: END IF;
187: l_msg_count := FND_MSG_PUB.count_msg;
188: if(l_msg_count<>0) then
189: Raise Invalid_Ret_Status;
190: end if;
191: IF l_debug_mode = 'Y' THEN

Line 215: l_msg_count := FND_MSG_PUB.count_msg;

211:
212: EXCEPTION
213: WHEN Invalid_Ret_Status THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: l_msg_count := FND_MSG_PUB.count_msg;
216:
217: IF l_msg_count = 1 and x_msg_data IS NULL THEN
218: PA_INTERFACE_UTILS_PUB.get_messages
219: (p_encoded => FND_API.G_TRUE

Line 236: FND_MSG_PUB.add_exc_msg

232: WHEN OTHERS THEN
233: x_msg_count := 1;
234: x_msg_data := substr(SQLERRM,1,240);
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.add_exc_msg
237: (p_pkg_name => 'PA_STATUS_LISTS_PVT'
238: , p_procedure_name => PA_DEBUG.G_Err_Stack
239: , p_error_text => substr(SQLERRM,1,240));
240: rollback to UpdateSL;

Line 293: l_msg_count := FND_MSG_PUB.count_msg;

289: X_STATUS_LIST_ID => P_STATUS_LIST_ID,
290: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER
291: );
292:
293: l_msg_count := FND_MSG_PUB.count_msg;
294: if(l_msg_count<>0) then
295: Raise Invalid_Ret_Status;
296: end if;
297:

Line 310: l_msg_count := FND_MSG_PUB.count_msg;

306:
307: EXCEPTION
308: WHEN Invalid_Ret_Status THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: l_msg_count := FND_MSG_PUB.count_msg;
311:
312: IF l_msg_count = 1 and x_msg_data IS NULL THEN
313: PA_INTERFACE_UTILS_PUB.get_messages
314: (p_encoded => FND_API.G_TRUE

Line 331: FND_MSG_PUB.add_exc_msg

327: WHEN OTHERS THEN
328: x_msg_count := 1;
329: x_msg_data := substr(SQLERRM,1,240);
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331: FND_MSG_PUB.add_exc_msg
332: (p_pkg_name => 'PA_STATUS_LISTS_PVT'
333: , p_procedure_name => PA_DEBUG.G_Err_Stack
334: , p_error_text => substr(SQLERRM,1,240));
335: rollback to DeleteSL;