DBA Data[Home] [Help]

APPS.CSL_NOTES_PKG dependencies on FND_API

Line 41: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

37:
38: -- Create a note
39: jtf_notes_pub.Create_note
40: ( p_api_version => 1.0
41: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
42: , p_init_msg_list => FND_API.G_TRUE
43: , p_commit => FND_API.G_FALSE
44: , x_return_status => x_return_status
45: , x_msg_count => l_msg_count

Line 42: , p_init_msg_list => FND_API.G_TRUE

38: -- Create a note
39: jtf_notes_pub.Create_note
40: ( p_api_version => 1.0
41: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
42: , p_init_msg_list => FND_API.G_TRUE
43: , p_commit => FND_API.G_FALSE
44: , x_return_status => x_return_status
45: , x_msg_count => l_msg_count
46: , x_msg_data => l_msg_data

Line 43: , p_commit => FND_API.G_FALSE

39: jtf_notes_pub.Create_note
40: ( p_api_version => 1.0
41: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
42: , p_init_msg_list => FND_API.G_TRUE
43: , p_commit => FND_API.G_FALSE
44: , x_return_status => x_return_status
45: , x_msg_count => l_msg_count
46: , x_msg_data => l_msg_data
47: , p_jtf_note_id => p_record.jtf_note_id

Line 64: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

60: , p_last_update_login => FND_GLOBAL.LOGIN_ID
61: , x_jtf_note_id => l_note_id
62: );
63:
64: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
65: /*** exception occurred in API -> return errmsg ***/
66: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
67: (
68: p_api_error => TRUE

Line 103: x_return_status := FND_API.G_RET_STS_ERROR;

99: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
100: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
101: END IF;
102:
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: END APPLY_INSERT;
105:
106: /***
107: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 129: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

125:
126: -- Update the note
127: jtf_notes_pub.Update_note
128: ( p_api_version => 1.0
129: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
130: , p_init_msg_list => FND_API.G_TRUE
131: , p_commit => FND_API.G_FALSE
132: , x_return_status => x_return_status
133: , x_msg_count => l_msg_count

Line 130: , p_init_msg_list => FND_API.G_TRUE

126: -- Update the note
127: jtf_notes_pub.Update_note
128: ( p_api_version => 1.0
129: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
130: , p_init_msg_list => FND_API.G_TRUE
131: , p_commit => FND_API.G_FALSE
132: , x_return_status => x_return_status
133: , x_msg_count => l_msg_count
134: , x_msg_data => l_msg_data

Line 131: , p_commit => FND_API.G_FALSE

127: jtf_notes_pub.Update_note
128: ( p_api_version => 1.0
129: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
130: , p_init_msg_list => FND_API.G_TRUE
131: , p_commit => FND_API.G_FALSE
132: , x_return_status => x_return_status
133: , x_msg_count => l_msg_count
134: , x_msg_data => l_msg_data
135: , p_jtf_note_id => p_record.jtf_note_id

Line 145: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

141: , p_last_update_date => SYSDATE
142: , p_last_update_login => FND_GLOBAL.LOGIN_ID
143: );
144:
145: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
146: /*** exception occurred in API -> return errmsg ***/
147: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
148: (
149: p_api_error => TRUE

Line 184: x_return_status := FND_API.G_RET_STS_ERROR;

180: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
181: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
182: END IF;
183:
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: END APPLY_UPDATE;
186:
187: /***
188: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 198: x_return_status := FND_API.G_RET_STS_SUCCESS;

194: x_return_status IN OUT NOCOPY VARCHAR2
195: ) IS
196: BEGIN
197: /*** initialize return status and message list ***/
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199: FND_MSG_PUB.INITIALIZE;
200:
201: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
202: jtm_message_log_pkg.Log_Msg

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: , p_token_name1 => 'DML'
248: , p_token_value1 => p_record.dmltype$$
249: );
250:
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: ELSE
253: -- invalid dml type
254: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
255: jtm_message_log_pkg.Log_Msg

Line 269: x_return_status := FND_API.G_RET_STS_ERROR;

265: , p_token_name1 => 'DML'
266: , p_token_value1 => p_record.dmltype$$
267: );
268:
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: END IF;
271:
272: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
273: jtm_message_log_pkg.Log_Msg

Line 303: x_return_status := FND_API.G_RET_STS_ERROR;

299: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
300: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
301: END IF;
302:
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: END APPLY_RECORD;
305:
306: /***
307: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item JTF_NOTES_VL

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: l_process_status VARCHAR2(1);
321: l_error_msg VARCHAR2(4000);
322: BEGIN
323: g_debug_level := p_debug_level;
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
327: jtm_message_log_pkg.Log_Msg
328: ( v_object_id => null

Line 348: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

344: , l_process_status
345: );
346:
347: /*** was record processed successfully? ***/
348: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
349: /*** Yes -> delete record from inqueue ***/
350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
351: jtm_message_log_pkg.Log_Msg
352: ( v_object_id => r_note.jtf_note_id

Line 371: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

367: l_process_status
368: );
369:
370: /*** was delete successful? ***/
371: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
372: /*** no -> rollback ***/
373: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
374: jtm_message_log_pkg.Log_Msg
375: ( v_object_id => r_note.jtf_note_id

Line 384: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

380: ROLLBACK TO save_rec;
381: END IF;
382: END IF;
383:
384: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
385: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
386: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
387: jtm_message_log_pkg.Log_Msg
388: ( v_object_id => r_note.jtf_note_id

Line 407: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

403: , l_process_status
404: );
405:
406: /*** Was defer successful? ***/
407: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
408: /*** no -> rollback ***/
409: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
410: jtm_message_log_pkg.Log_Msg
411: ( v_object_id => r_note.jtf_note_id

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435: , v_object_name => g_object_name
436: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
437: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
438: END IF;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: END APPLY_CLIENT_CHANGES;
441:
442: END CSL_NOTES_PKG;