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_REQUIREMENTS_PKG dependencies on FND_API

Line 151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

147: , X_MSG_COUNT => l_msg_count
148: , X_MSG_DATA => l_msg_data
149: );
150:
151: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
152: /*** exception occurred in API -> return errmsg ***/
153: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
154: (
155: p_api_error => TRUE

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
187: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
188: END IF;
189:
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: END APPLY_INSERT;
192:
193: /***
194: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
209: END IF;
210:
211: -- No update possible so return success
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
215: /*** exception occurred in API -> return errmsg ***/
216: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

210:
211: -- No update possible so return success
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
215: /*** exception occurred in API -> return errmsg ***/
216: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
217: (
218: p_api_error => TRUE

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
250: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
251: END IF;
252:
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: END APPLY_UPDATE;
255:
256: /***
257: This procedure is called by APPLY_CLIENT_CHANGES for every record in inqueue that needs to be processed.

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: , x_return_status IN OUT NOCOPY VARCHAR2
267: ) IS
268: BEGIN
269: /*** initialize return status and message list ***/
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
273: jtm_message_log_pkg.Log_Msg
274: ( v_object_id => p_record.requirement_line_id -- put PK column here

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: , p_token_name1 => 'DML'
322: , p_token_value1 => p_record.dmltype$$
323: );
324:
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: ELSE
327: -- invalid dml type
328: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
329: 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: END IF;
345:
346: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
347: jtm_message_log_pkg.Log_Msg

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
374: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
375: END IF;
376:
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: END APPLY_RECORD;
379:
380: /***
381: This procedure is called by PROCESS_REQS and deletes all requirement headers from the inqueue,

Line 430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

426: x_return_status
427: );
428:
429: /*** was delete successful? ***/
430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
431: /*** no -> rollback ***/
432: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
433: jtm_message_log_pkg.Log_Msg
434: ( v_object_id => r_get_req_headers_from_inq.requirement_header_id -- put PK column here

Line 442: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

438: END IF;
439: ROLLBACK TO save_rec;
440: END IF;
441:
442: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
443: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
444: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
445: jtm_message_log_pkg.Log_Msg
446: ( v_object_id => r_get_req_headers_from_inq.requirement_header_id -- put PK column here

Line 465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

461: , x_return_status
462: );
463:
464: /*** Was defer successful? ***/
465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
466: /*** no -> rollback ***/
467: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
468: jtm_message_log_pkg.Log_Msg
469: ( v_object_id => r_get_req_headers_from_inq.requirement_header_id -- put PK column here

Line 497: x_return_status := FND_API.G_RET_STS_ERROR;

493: , v_message => 'Exception occurred in DELETE_REQ_HEADERS_FROM_INQ:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
494: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
495: END IF;
496:
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: END DELETE_REQ_HEADERS_FROM_INQ;
499:
500: /***
501: This procedure is called by APPLY_CLIENT_CHANGES and processes all inqueue requirement lines,

Line 540: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

536: , x_return_status
537: );
538:
539: /*** was record processed successfully? ***/
540: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
541: /*** Yes -> delete record from inqueue ***/
542: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
543: jtm_message_log_pkg.Log_Msg
544: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

560: x_return_status
561: );
562:
563: /*** was delete successful? ***/
564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
565: /*** no -> rollback ***/
566: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
567: jtm_message_log_pkg.Log_Msg
568: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

573: ROLLBACK TO save_rec;
574: END IF;
575: END IF;
576:
577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
579: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
580: jtm_message_log_pkg.Log_Msg
581: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

596: , x_return_status
597: );
598:
599: /*** Was defer successful? ***/
600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
601: /*** no -> rollback ***/
602: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
603: jtm_message_log_pkg.Log_Msg
604: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
632: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
633: END IF;
634:
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END PROCESS_REQS;
637:
638: /***
639: This procedure is called by APPLY_CLIENT_CHANGES and processes all inqueue requirement lines,

Line 678: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

674: , x_return_status
675: );
676:
677: /*** was record processed successfully? ***/
678: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
679: /*** Yes -> delete record from inqueue ***/
680: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
681: jtm_message_log_pkg.Log_Msg
682: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 701: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

697: x_return_status
698: );
699:
700: /*** was delete successful? ***/
701: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
702: /*** no -> rollback ***/
703: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
704: jtm_message_log_pkg.Log_Msg
705: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 714: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

710: ROLLBACK TO save_rec;
711: END IF;
712: END IF;
713:
714: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
715: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
716: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
717: jtm_message_log_pkg.Log_Msg
718: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

733: , x_return_status
734: );
735:
736: /*** Was defer successful? ***/
737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
738: /*** no -> rollback ***/
739: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
740: jtm_message_log_pkg.Log_Msg
741: ( v_object_id => r_requirements.requirement_line_id -- put PK column here

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
766: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
767: END IF;
768:
769: x_return_status := FND_API.G_RET_STS_ERROR;
770:
771: END PROCESS_REQS_NO_HEADERS;
772:
773: /***

Line 793: x_return_status := FND_API.G_RET_STS_SUCCESS;

789:
790: BEGIN
791:
792: g_debug_level := p_debug_level;
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
796: jtm_message_log_pkg.Log_Msg
797: ( v_object_id => null