eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_NOTIFICATIONS_PKG dependencies on FND_API

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: IF l_receiver_found THEN
82: -- Check if receiver is valid for the current date
83: IF TRUNC(r_fnd_user.start_date) > TRUNC(SYSDATE) THEN
84: -- The receiver is not yet valid
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
87: ( p_message => 'CSL_MAIL_RECEIVER_NOT_YET'
88: , p_token_name1 => 'MAIL_RECEIVER'
89: , p_token_value1 => p_record.recipient_role

Line 96: x_return_status := FND_API.G_RET_STS_ERROR;

92: );
93: ELSIF TRUNC(r_fnd_user.end_date) < TRUNC(SYSDATE)
94: THEN
95: -- The receiver is no longer valid
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
98: ( p_message => 'CSL_MAIL_RECEIVER_OUTDATED'
99: , p_token_name1 => 'MAIL_RECEIVER'
100: , p_token_value1 => p_record.recipient_role

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: l_valid_receiver := TRUE;
107: END IF;
108: ELSE
109: -- The receiver is unknown
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
112: ( p_message => 'CSL_MAIL_RECEIVER_UNKNOWN'
113: , p_token_name1 => 'MAIL_RECEIVER'
114: , p_token_value1 => p_record.recipient_role

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: , r_notification_attr.text_value
170: );
171: END LOOP;
172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: END IF;
176:
177: /*** Call Concurrent Program to push new Notification and Attributes to mobile ***/

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
208: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
209: END IF;
210:
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END APPLY_INSERT;
213:
214: /***
215: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
230: END IF;
231:
232: -- No update possible ( is done in attributes ) so return success
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: /*** exception occurred in API -> return errmsg ***/
237: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

231:
232: -- No update possible ( is done in attributes ) so return success
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
236: /*** exception occurred in API -> return errmsg ***/
237: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
238: (
239: p_api_error => TRUE

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
271: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
272: END IF;
273:
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: END APPLY_UPDATE;
276:
277: /***
278: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: x_return_status IN OUT NOCOPY VARCHAR2
286: ) IS
287: BEGIN
288: /*** initialize return status and message list ***/
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: FND_MSG_PUB.INITIALIZE;
291:
292: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
293: jtm_message_log_pkg.Log_Msg

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: , p_token_name1 => 'DML'
340: , p_token_value1 => p_record.dmltype$$
341: );
342:
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: ELSE
345: -- invalid dml type
346: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
347: jtm_message_log_pkg.Log_Msg

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: , p_token_name1 => 'DML'
358: , p_token_value1 => p_record.dmltype$$
359: );
360:
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: END IF;
363:
364: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
365: jtm_message_log_pkg.Log_Msg

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
392: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
393: END IF;
394:
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: END APPLY_RECORD;
397:
398: /***
399: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item WF_NOTIFICATIONS

Line 416: x_return_status := FND_API.G_RET_STS_SUCCESS;

412: l_process_status VARCHAR2(1);
413: l_error_msg VARCHAR2(4000);
414: BEGIN
415: g_debug_level := p_debug_level;
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417:
418: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
419: jtm_message_log_pkg.Log_Msg
420: ( v_object_id => null

Line 441: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

437: , l_process_status
438: );
439:
440: /*** was record processed successfully? ***/
441: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
442: /*** Yes -> reject record because of changed pk ***/
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_notification.notification_id

Line 463: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

459: l_error_msg,
460: l_process_status
461: );
462:
463: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
464: /*** Reject successfull than reject matching attributes ***/
465: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
466: jtm_message_log_pkg.Log_Msg
467: ( v_object_id => r_notification.notification_id

Line 509: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

505: l_error_msg,
506: l_process_status
507: );
508: /*** was delete successful? ***/
509: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
510: /*** no -> rollback ***/
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_notification.notification_id

Line 548: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

544:
545: END LOOP;
546: END IF;
547:
548: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
549: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
550: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
551: jtm_message_log_pkg.Log_Msg
552: ( v_object_id => r_notification.notification_id

Line 571: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

567: , l_process_status
568: );
569:
570: /*** Was defer successful? ***/
571: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
572: /*** no -> rollback ***/
573: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
574: jtm_message_log_pkg.Log_Msg
575: ( v_object_id => r_notification.notification_id

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: , v_object_name => g_object_name
625: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
626: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
627: END IF;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: END APPLY_CLIENT_CHANGES;
630:
631: END CSL_NOTIFICATIONS_PKG;