DBA Data[Home] [Help]

APPS.CSL_TASKS_PKG dependencies on FND_API

Line 40: p_init_msg_list => FND_API.g_true,

36: END IF;
37:
38: JTF_TASKS_PUB.create_task (
39: p_api_version => 1.0,
40: p_init_msg_list => FND_API.g_true,
41: p_commit => fnd_api.g_false,
42: p_task_id => p_record.TASK_ID,
43: p_task_name => p_record.TASK_NAME,
44: p_task_type_id => p_record.TASK_TYPE_ID,

Line 41: p_commit => fnd_api.g_false,

37:
38: JTF_TASKS_PUB.create_task (
39: p_api_version => 1.0,
40: p_init_msg_list => FND_API.g_true,
41: p_commit => fnd_api.g_false,
42: p_task_id => p_record.TASK_ID,
43: p_task_name => p_record.TASK_NAME,
44: p_task_type_id => p_record.TASK_TYPE_ID,
45: p_description => p_record.DESCRIPTION,

Line 83: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

79: x_msg_data => l_msg_data,
80: x_task_id => l_task_id
81: );
82:
83: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
84: /*** exception occurred in API -> return errmsg ***/
85: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
86: (
87: p_api_error => TRUE

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_INSERT'
119: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
120: END IF;
121:
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: END APPLY_INSERT;
124:
125: /***
126: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 167: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_object_name, p_record.seqno$$) <> FND_API.G_TRUE then

163:
164: -- Check for Stale data
165: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
166: if l_profile_value = 'SERVER_WINS' AND
167: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_object_name, p_record.seqno$$) <> FND_API.G_TRUE then
168: open c_last_update_date(b_task_id => p_record.task_id);
169: fetch c_last_update_date into r_last_update_date;
170: if c_last_update_date%found then
171: if r_last_update_date.last_update_date <> p_record.last_update_date then

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
190: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
191: END IF;
192:
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: return;
195: end if;
196: else
197: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 217: p_init_msg_list => FND_API.G_TRUE,

213:
214: -- Update the task.
215: JTF_TASKS_PUB.Update_Task (
216: p_api_version => 1.0,
217: p_init_msg_list => FND_API.G_TRUE,
218: p_commit => FND_API.G_FALSE,
219: p_task_id => p_record.TASK_ID,
220: p_object_version_number => r_task.object_version_number,
221: p_planned_start_date => p_record.PLANNED_START_DATE,

Line 218: p_commit => FND_API.G_FALSE,

214: -- Update the task.
215: JTF_TASKS_PUB.Update_Task (
216: p_api_version => 1.0,
217: p_init_msg_list => FND_API.G_TRUE,
218: p_commit => FND_API.G_FALSE,
219: p_task_id => p_record.TASK_ID,
220: p_object_version_number => r_task.object_version_number,
221: p_planned_start_date => p_record.PLANNED_START_DATE,
222: p_planned_end_date => p_record.PLANNED_END_DATE,

Line 226: NVL(p_record.TASK_PRIORITY_ID,FND_API.G_MISS_NUM),

222: p_planned_end_date => p_record.PLANNED_END_DATE,
223: p_scheduled_start_date => p_record.SCHEDULED_START_DATE,
224: p_scheduled_end_date => p_record.SCHEDULED_END_DATE,
225: p_task_priority_id =>
226: NVL(p_record.TASK_PRIORITY_ID,FND_API.G_MISS_NUM),
227: p_planned_effort => p_record.PLANNED_EFFORT,
228: p_planned_effort_uom => p_record.PLANNED_EFFORT_UOM,
229: p_attribute1 => p_record.attribute1,
230: p_attribute2 => p_record.attribute2,

Line 252: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

248: x_msg_count => l_msg_count,
249: x_msg_data => l_msg_data
250: );
251:
252: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
253: /*** exception occurred in API -> return errmsg ***/
254: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
255: (
256: p_api_error => TRUE

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_UPDATE'
288: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
289: END IF;
290:
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END APPLY_UPDATE;
293:
294: /***
295: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 307: x_return_status := FND_API.G_RET_STS_SUCCESS;

303: l_rc BOOLEAN;
304: l_access_id NUMBER;
305: BEGIN
306: /*** initialize return status and message list ***/
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: FND_MSG_PUB.INITIALIZE;
309:
310: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
311: jtm_message_log_pkg.Log_Msg

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356: , p_token_name1 => 'DML'
357: , p_token_value1 => p_record.dmltype$$
358: );
359:
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: ELSE
362: -- invalid dml type
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
364: jtm_message_log_pkg.Log_Msg

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: , p_token_name1 => 'DML'
375: , p_token_value1 => p_record.dmltype$$
376: );
377:
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
382: l_access_id := jtm_hook_util_pkg.get_acc_id(

Line 381: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

377:
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
382: l_access_id := jtm_hook_util_pkg.get_acc_id(
383: p_acc_table_name => 'CSL_JTF_TASKS_ACC',
384: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
385: p_pk1_name => 'TASK_ID',

Line 428: x_return_status := FND_API.G_RET_STS_ERROR;

424: , v_message => 'Leaving CSL_TASKS_PKG.APPLY_RECORD'
425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
426: END IF;
427:
428: x_return_status := FND_API.G_RET_STS_ERROR;
429: END APPLY_RECORD;
430:
431: /***
432: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item CSL_JTF_TASKS_VL

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: l_process_status VARCHAR2(1);
446: l_error_msg VARCHAR2(4000);
447: BEGIN
448: g_debug_level := p_debug_level;
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
452: jtm_message_log_pkg.Log_Msg
453: ( v_object_id => null

Line 473: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

469: , l_process_status
470: );
471:
472: /*** was record processed successfully? ***/
473: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
474: /*** Yes -> delete record from inqueue ***/
475: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
476: jtm_message_log_pkg.Log_Msg
477: ( v_object_id => r_task.task_id

Line 496: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

492: l_process_status
493: );
494:
495: /*** was delete successful? ***/
496: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
497: /*** no -> rollback ***/
498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_task.task_id

Line 509: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

505: ROLLBACK TO save_rec;
506: END IF;
507: END IF;
508:
509: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
510: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
511: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
512: jtm_message_log_pkg.Log_Msg
513: ( v_object_id => r_task.task_id

Line 533: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

529: , r_task.dmltype$$
530: );
531:
532: /*** Was defer successful? ***/
533: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
534: /*** no -> rollback ***/
535: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
536: jtm_message_log_pkg.Log_Msg
537: ( v_object_id => r_task.task_id

Line 565: x_return_status := FND_API.G_RET_STS_ERROR;

561: , v_object_name => g_object_name
562: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
563: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
564: END IF;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: END APPLY_CLIENT_CHANGES;
567:
568: END CSL_TASKS_PKG;