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

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: x_return_status IN OUT NOCOPY VARCHAR2
94: ) IS
95: l_index BINARY_INTEGER;
96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
100: jtm_message_log_pkg.Log_Msg
101: ( v_object_id => null

Line 379: x_return_status := FND_API.G_RET_STS_ERROR;

375: , v_object_name => g_object_name
376: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'
377: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
378: END IF;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: END APPLY_DIRTY_PUBITEMS;
381:
382: /***
383: This procedure is called by ASG_APPLY.PROCESS_UPLOAD when a publication item for publication SERVICEL

Line 424: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN

420: l_pubitems_tbl,
421: l_return_status);
422:
423: /*** successfully retrieved item names? ***/
424: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
425: /*** No -> log that no items were retrieved ***/
426: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
427: jtm_message_log_pkg.Log_Msg
428: ( v_object_id => null

Line 460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN

456: l_return_status);
457: */
458:
459: /*** successfully retrieved item names? ***/
460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
461: /*** No -> log that no items were retrieved ***/
462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
463: jtm_message_log_pkg.Log_Msg
464: ( v_object_id => null

Line 580: , p_encoded => FND_API.G_FALSE

576: /*** API error -> retrieve error from message stack ***/
577: IF FND_MSG_PUB.Count_Msg > 0 THEN
578: FND_MSG_PUB.Get
579: ( p_msg_index => 1
580: , p_encoded => FND_API.G_FALSE
581: , p_data => l_msg_data
582: , p_msg_index_out => l_msg_dummy
583: );
584: l_fnd_message := l_msg_data;

Line 590: , p_encoded => FND_API.G_FALSE

586: IN 2 .. FND_MSG_PUB.Count_Msg
587: LOOP
588: FND_MSG_PUB.Get
589: ( p_msg_index => l_counter
590: , p_encoded => FND_API.G_FALSE
591: , p_data => l_msg_data
592: , p_msg_index_out => l_msg_dummy
593: );
594: l_fnd_message := l_fnd_message || FND_GLOBAL.Newline || l_msg_data;

Line 644: x_return_status := FND_API.G_RET_STS_SUCCESS;

640: p_error_msg OUT NOCOPY VARCHAR2,
641: x_return_status IN OUT NOCOPY VARCHAR2
642: ) IS
643: BEGIN
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:
646: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
647: jtm_message_log_pkg.Log_Msg
648: ( v_object_id => p_pk

Line 660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

656: p_pub_name,
657: p_seqno,
658: x_return_status);
659:
660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
661: /*** error occurred ***/
662: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DELETE_RECORD', 'Unknown error');
663: p_error_msg := GET_ERROR_MESSAGE_TEXT
664: (

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: , v_object_name => p_object_name
696: , v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'
697: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
698: END IF;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: END DELETE_RECORD;
701:
702: /***
703: This procedure is called by APPLY_CLIENT_CHANGES wrapper procedure

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

715: x_return_status IN OUT NOCOPY VARCHAR2,
716: p_dml_type IN VARCHAR2 --DEFAULT 'I'
717: ) IS
718: BEGIN
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
722: jtm_message_log_pkg.Log_Msg
723: ( v_object_id => p_pk

Line 736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

732: p_seqno,
733: p_error_msg,
734: x_return_status);
735: /*** check if defer was successfull ***/
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: /*** no -> log and return error ***/
738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
739: jtm_message_log_pkg.Log_Msg
740: ( v_object_id => p_pk

Line 773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

769: p_seqno,
770: p_error_msg,
771: x_return_status);
772: /*** check if reject was successfull ***/
773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: /*** no -> log error ***/
775: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
776: jtm_message_log_pkg.Log_Msg
777: ( v_object_id => p_pk

Line 810: x_return_status := FND_API.G_RET_STS_ERROR;

806: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'
807: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
808: END IF;
809:
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: END DEFER_RECORD;
812:
813: /***
814: This procedure gets called when a record needs to be rejected when e.g. the api provides its own pk

Line 828: x_return_status := FND_API.G_RET_STS_SUCCESS;

824: p_error_msg IN VARCHAR2,
825: x_return_status IN OUT NOCOPY VARCHAR2
826: )IS
827: BEGIN
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
831: jtm_message_log_pkg.Log_Msg
832: ( v_object_id => p_pk

Line 847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

843: p_error_msg,
844: x_return_status);
845:
846: /*** check if reject was successfull ***/
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: /*** no -> log error ***/
849: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
850: jtm_message_log_pkg.Log_Msg
851: ( v_object_id => p_pk

Line 882: x_return_status := FND_API.G_RET_STS_ERROR;

878: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'
879: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
880: END IF;
881:
882: x_return_status := FND_API.G_RET_STS_ERROR;
883: END REJECT_RECORD;
884:
885: /***
886: This procedure gets called when a user gets created

Line 908: IF x_status <> FND_API.G_RET_STS_SUCCESS THEN

904: END IF;
905: CLOSE c_user;
906:
907: /*** if create_user returned error then raise exception ***/
908: IF x_status <> FND_API.G_RET_STS_SUCCESS THEN
909: ROLLBACK;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912:

Line 910: RAISE FND_API.G_EXC_ERROR;

906:
907: /*** if create_user returned error then raise exception ***/
908: IF x_status <> FND_API.G_RET_STS_SUCCESS THEN
909: ROLLBACK;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912:
913: COMMIT;
914: END POPULATE_ACCESS_RECORDS;

Line 939: IF x_status <> FND_API.G_RET_STS_SUCCESS THEN

935: END IF;
936: CLOSE c_user;
937:
938: /*** if delete user returned error then raise exception ***/
939: IF x_status <> FND_API.G_RET_STS_SUCCESS THEN
940: ROLLBACK;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943:

Line 941: RAISE FND_API.G_EXC_ERROR;

937:
938: /*** if delete user returned error then raise exception ***/
939: IF x_status <> FND_API.G_RET_STS_SUCCESS THEN
940: ROLLBACK;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943:
944: COMMIT;
945: END DELETE_ACCESS_RECORDS;