DBA Data[Home] [Help]

APPS.CSL_MTL_SYSTEM_ITEMS_ACC_PKG dependencies on FND_GLOBAL

Line 156: , 'INSERT_ACC_REC_MARKDIRTY_EXP'||fnd_global.local_chr(10)||

152: WHEN OTHERS THEN
153: jtm_message_log_pkg.Log_Msg
154: ( p_organization_id
155: , g_table_name
156: , 'INSERT_ACC_REC_MARKDIRTY_EXP'||fnd_global.local_chr(10)||
157: 'Error: '||sqlerrm
158: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
159: RAISE;
160: END INSERT_ACC_REC_MARKDIRTY_EXP;

Line 452: FND_GLOBAL.APPS_INITIALIZE( USER_ID => p_user_id

448: , x_category_id OUT NOCOPY NUMBER )
449: IS
450: BEGIN
451: /*Set the environment*/
452: FND_GLOBAL.APPS_INITIALIZE( USER_ID => p_user_id
453: , RESP_ID => p_responsibility_id
454: , RESP_APPL_ID => p_application_id
455: );
456: /*Get the profile values*/

Line 551: , 'DELETE_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||

547: WHEN OTHERS THEN
548: jtm_message_log_pkg.Log_Msg
549: ( p_resource_id
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*/

Line 744: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||

740: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
741: jtm_message_log_pkg.Log_Msg
742: ( p_resource_id
743: , g_table_name
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;

Line 1185: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||

1181: WHEN OTHERS THEN
1182: jtm_message_log_pkg.Log_Msg
1183: ( p_organization_id
1184: , g_table_name
1185: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1186: 'Error: '||sqlerrm
1187: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1188: RAISE;
1189: END INSERT_ACC_REC_MARKDIRTY;

Line 1368: , 'UPDATE_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||

1364:
1365: jtm_message_log_pkg.Log_Msg
1366: ( 0
1367: , g_table_name
1368: , 'UPDATE_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1369: 'Error: '||sqlerrm
1370: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1371: RAISE;
1372: END UPDATE_ACC_REC_MARKDIRTY;

Line 1573: , 'DELETE_ALL_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||

1569: WHEN OTHERS THEN
1570: jtm_message_log_pkg.Log_Msg
1571: ( p_organization_id
1572: , g_table_name
1573: , 'DELETE_ALL_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1574: 'Error: '||sqlerrm
1575: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1576: RAISE;
1577: END DELETE_ALL_ACC_REC_MARKDIRTY;

Line 1634: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||

1630: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1631: jtm_message_log_pkg.Log_Msg
1632: ( 0
1633: , g_table_name
1634: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||
1635: 'Inserting all system item records without calling markdirty.'
1636: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1637: );
1638: END IF;

Line 1690: || fnd_global.local_chr(10)||

1686: jtm_message_log_pkg.Log_Msg
1687: ( 0
1688: , g_table_name
1689: , 'Inventory organization or category profiles changed.'
1690: || fnd_global.local_chr(10)||
1691: 'original organization_id = ' || r_org.organization_id
1692: || ', new organization_id = ' || l_profile_org_id
1693: || fnd_global.local_chr(10)||
1694: 'original category_set_id = ' || r_org.category_set_id

Line 1693: || fnd_global.local_chr(10)||

1689: , 'Inventory organization or category profiles changed.'
1690: || fnd_global.local_chr(10)||
1691: 'original organization_id = ' || r_org.organization_id
1692: || ', new organization_id = ' || l_profile_org_id
1693: || fnd_global.local_chr(10)||
1694: 'original category_set_id = ' || r_org.category_set_id
1695: || ', new category_set_id = ' || l_profile_category_set_id
1696: || fnd_global.local_chr(10)||
1697: 'original category_id = ' || r_org.category_id

Line 1696: || fnd_global.local_chr(10)||

1692: || ', new organization_id = ' || l_profile_org_id
1693: || fnd_global.local_chr(10)||
1694: 'original category_set_id = ' || r_org.category_set_id
1695: || ', new category_set_id = ' || l_profile_category_set_id
1696: || fnd_global.local_chr(10)||
1697: 'original category_id = ' || r_org.category_id
1698: || ', new category_id = ' || l_profile_category_id
1699: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1700: );

Line 1759: , 'Pushing inserted records for'||fnd_global.local_chr(10)||

1755: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1756: jtm_message_log_pkg.Log_Msg
1757: ( p_resource_id
1758: , g_table_name
1759: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1760: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1761: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1762: 'category_id = ' || l_profile_category_id
1763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1760: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||

1756: jtm_message_log_pkg.Log_Msg
1757: ( p_resource_id
1758: , g_table_name
1759: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1760: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1761: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1762: 'category_id = ' || l_profile_category_id
1763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1764: END IF;

Line 1761: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||

1757: ( p_resource_id
1758: , g_table_name
1759: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1760: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1761: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1762: 'category_id = ' || l_profile_category_id
1763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1764: END IF;
1765:

Line 1793: , 'Caught exception in CONCURRENT_PROCESS_USER'||fnd_global.local_chr(10)||

1789: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1790: jtm_message_log_pkg.Log_Msg
1791: ( 0
1792: , g_table_name
1793: , 'Caught exception in CONCURRENT_PROCESS_USER'||fnd_global.local_chr(10)||
1794: 'Error: '||sqlerrm
1795: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1796: END IF;
1797: ROLLBACK;

Line 1932: , 'CON_REQUEST_MTL_SYSTEM_ITEMS'||fnd_global.local_chr(10)||

1928: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1929: jtm_message_log_pkg.Log_Msg
1930: ( 0
1931: , g_table_name
1932: , 'CON_REQUEST_MTL_SYSTEM_ITEMS'||fnd_global.local_chr(10)||
1933: 'Error: '||sqlerrm
1934: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1935: END IF;
1936: ROLLBACK;