APPS.CSL_NOTIFICATION_ATTR_PKG dependencies on FND_API

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
38: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
39: END IF;
40:
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: OPEN c_attr( b_notification_id => p_record.notification_id
44: , b_name => p_record.name );
45: FETCH c_attr INTO r_attr;

Line 94: x_return_status := FND_API.G_RET_STS_ERROR;

90: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
91: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
92: END IF;
93:
94: x_return_status := FND_API.G_RET_STS_ERROR;
95: END APPLY_INSERT;
96:
97: /***
98: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

112: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
113: END IF;
114:
115: /*** Updating is done by inserting the READ or DELETE _FLAG attribute ***/
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: /*** exception occurred in API -> return errmsg ***/
120: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

114:
115: /*** Updating is done by inserting the READ or DELETE _FLAG attribute ***/
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: /*** exception occurred in API -> return errmsg ***/
120: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
121: (
122: p_api_error => TRUE

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

153: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
154: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
155: END IF;
156:
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: END APPLY_UPDATE;
159:
160: /***
161: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: x_return_status IN OUT NOCOPY VARCHAR2
168: ) IS
169: BEGIN
170: /*** initialize return status and message list ***/
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: FND_MSG_PUB.INITIALIZE;
173:
174: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
175: jtm_message_log_pkg.Log_Msg

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: , p_token_name1 => 'DML'
221: , p_token_value1 => p_record.dmltype$$
222: );
223:
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: ELSE
226: -- invalid dml type
227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
228: jtm_message_log_pkg.Log_Msg

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: , p_token_name1 => 'DML'
239: , p_token_value1 => p_record.dmltype$$
240: );
241:
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: END IF;
244:
245: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
246: jtm_message_log_pkg.Log_Msg

Line 276: x_return_status := FND_API.G_RET_STS_ERROR;

272: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
273: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
274: END IF;
275:
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: END APPLY_RECORD;
278:
279: /***
280: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item WF_NOTIFICATION_ATTR

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: l_process_status VARCHAR2(1);
294: l_error_msg VARCHAR2(4000);
295: BEGIN
296: g_debug_level := p_debug_level;
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
300: jtm_message_log_pkg.Log_Msg
301: ( v_object_id => null

Line 321: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

317: , l_process_status
318: );
319:
320: /*** was record processed successfully? ***/
321: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
322: /*** Yes -> delete record from inqueue ***/
323: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
324: jtm_message_log_pkg.Log_Msg
325: ( v_object_id => r_not_attr.notification_id

Line 344: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

340: l_process_status
341: );
342:
343: /*** was delete successful? ***/
344: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
345: /*** no -> rollback ***/
346: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
347: jtm_message_log_pkg.Log_Msg
348: ( v_object_id => r_not_attr.notification_id

Line 357: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

353: ROLLBACK TO save_rec;
354: END IF;
355: END IF;
356:
357: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
358: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
359: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
360: jtm_message_log_pkg.Log_Msg
361: ( v_object_id => r_not_attr.notification_id

Line 380: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

376: , l_process_status
377: );
378:
379: /*** Was defer successful? ***/
380: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
381: /*** no -> rollback ***/
382: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
383: jtm_message_log_pkg.Log_Msg
384: ( v_object_id => r_not_attr.notification_id

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: , v_object_name => g_object_name
409: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
410: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
411: END IF;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: END APPLY_CLIENT_CHANGES;
414:
415: END CSL_NOTIFICATION_ATTR_PKG;