APPS.CSL_LOBS_PKG dependencies on FND_API

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72: l_signature_size number;
73:
74: BEGIN
75:
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: l_error_msg := 'Entering ' || g_object_name || '.APPLY_INSERT'
79: || ' for PK ' || to_char( p_record.FILE_ID);
80:

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

112: --verify that the record does not already exist
113: OPEN l_lobs_fileid_csr(p_record.file_id) ;
114: FETCH l_lobs_fileid_csr into l_dummy;
115: IF l_lobs_fileid_csr%found THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: p_error_msg := 'Duplicate Record: File id ' || to_char(p_record.file_id)
118: || ' already exists in fnd_lobs table';
119:
120: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: --the record exists. Dont show any error.
152: null;
153: else
154: --record could not be inserted, throw the exception
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: raise;
157: end if;
158: close l_lobs_fileid_csr;
159:

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: , v_message => l_error_msg
222: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
223: END IF;
224:
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: END APPLY_INSERT;
227:
228:
229: /***

Line 243: x_return_status := FND_API.G_RET_STS_SUCCESS;

239: ) IS
240: l_error_msg varchar(1024);
241: BEGIN
242: /*** initialize return status and message list ***/
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244: FND_MSG_PUB.INITIALIZE;
245:
246:
247: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: , p_token_name1 => 'DML'
291: , p_token_value1 => p_record.dmltype$$
292: );
293:
294: x_return_status := FND_API.G_RET_STS_ERROR;
295:
296: ELSIF p_record.dmltype$$='D' THEN
297: -- Process delete; not supported for this entity
298:

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: , p_token_name1 => 'DML'
311: , p_token_value1 => p_record.dmltype$$
312: );
313:
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: ELSE
316: -- invalid dml type
317:
318: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: , p_token_name1 => 'DML'
330: , p_token_value1 => p_record.dmltype$$
331: );
332:
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335:
336: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
337: jtm_message_log_pkg.Log_Msg

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
367: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
368: END IF;
369:
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: END APPLY_RECORD;
372:
373:
374: /***

Line 394: x_return_status := FND_API.G_RET_STS_SUCCESS;

390: l_process_status VARCHAR2(1);
391: l_error_msg VARCHAR2(4000);
392: BEGIN
393: g_debug_level := p_debug_level;
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395:
396: jtm_message_log_pkg.Log_Msg
397: ( v_object_id => null
398: , v_object_name => g_object_name

Line 417: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

413: , l_process_status
414: );
415:
416: /*** was record processed successfully? ***/
417: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
418: /*** Yes -> delete record from inqueue ***/
419: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
420: jtm_message_log_pkg.Log_Msg
421: ( v_object_id => r_fnd_lobs.task_assignment_id

Line 441: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

437: l_process_status
438: );
439:
440: /*** was delete successful? ***/
441: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
442: /*** no -> rollback ***/
443: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
444: jtm_message_log_pkg.Log_Msg
445: ( v_object_id => r_FND_LOBS.task_assignment_id

Line 455: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

451: ROLLBACK TO save_rec;
452: END IF;
453: END IF;
454:
455: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
456: /*** Record was not processed successfully or delete failed
457: -> defer and reject record ***/
458:
459: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 481: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

477: , r_FND_LOBS.dmltype$$
478: );
479:
480: /*** Was defer successful? ***/
481: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
482: /*** no -> rollback ***/
483: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
484: jtm_message_log_pkg.Log_Msg
485: ( v_object_id => r_FND_LOBS.task_assignment_id

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
514: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
515: END IF;
516:
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: END APPLY_CLIENT_CHANGES;
519:
520: END CSL_LOBS_PKG;