APPS.CSL_MTL_SYSTEM_ITEMS_ACC_PKG dependencies on FND_API

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532:
533: /*Reduce rollback segments*/
534: COMMIT;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
539: jtm_message_log_pkg.Log_Msg
540: ( p_resource_id

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: , g_table_name
551: , 'DELETE_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
552: 'Error: '||sqlerrm
553: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: /*Reduce rollback segments*/
556: ROLLBACK;
557: RAISE;
558: END DELETE_ALL_ACC_RECORDS;

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: , 'Resource_id = ' || p_resource_id || ' does not have any active mobile responsibilities'
617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
618: );
619: END IF;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: ELSE
622: /*** Found active mobile responsibility for user ***/
623:
624: /*Get inventory org and category profiles */

Line 736: x_return_status := FND_API.G_RET_STS_SUCCESS;

732: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
733: );
734: END IF;
735:
736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737: EXCEPTION
738: WHEN OTHERS THEN
739: ROLLBACK;
740: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 748: x_return_status := FND_API.G_RET_STS_ERROR;

744: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
745: 'Error: '||sqlerrm
746: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
747: END IF;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: RAISE;
750: END INSERT_ALL_ACC_RECORDS;
751:
752: /*

Line 1494: IF NVL( l_profile_org_id, FND_API.G_MISS_NUM ) <>

1490: END IF;
1491: END IF;
1492:
1493: /*** did system item org or category filter change? ***/
1494: IF NVL( l_profile_org_id, FND_API.G_MISS_NUM ) <>
1495: NVL( r_org.organization_id, FND_API.G_MISS_NUM )
1496: OR l_cat_filter_changed THEN
1497: /*
1498: organization or category profile changed ->

Line 1495: NVL( r_org.organization_id, FND_API.G_MISS_NUM )

1491: END IF;
1492:
1493: /*** did system item org or category filter change? ***/
1494: IF NVL( l_profile_org_id, FND_API.G_MISS_NUM ) <>
1495: NVL( r_org.organization_id, FND_API.G_MISS_NUM )
1496: OR l_cat_filter_changed THEN
1497: /*
1498: organization or category profile changed ->
1499: delete all old system items and insert new items with markdirty