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 1450: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||

1446: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1447: jtm_message_log_pkg.Log_Msg
1448: ( 0
1449: , g_table_name
1450: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||
1451: 'Inserting all system item records without calling markdirty.'
1452: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1453: );
1454: END IF;

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

1502: jtm_message_log_pkg.Log_Msg
1503: ( 0
1504: , g_table_name
1505: , 'Inventory organization or category profiles changed.'
1506: || fnd_global.local_chr(10)||
1507: 'original organization_id = ' || r_org.organization_id
1508: || ', new organization_id = ' || l_profile_org_id
1509: || fnd_global.local_chr(10)||
1510: 'original category_set_id = ' || r_org.category_set_id

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

1505: , 'Inventory organization or category profiles changed.'
1506: || fnd_global.local_chr(10)||
1507: 'original organization_id = ' || r_org.organization_id
1508: || ', new organization_id = ' || l_profile_org_id
1509: || fnd_global.local_chr(10)||
1510: 'original category_set_id = ' || r_org.category_set_id
1511: || ', new category_set_id = ' || l_profile_category_set_id
1512: || fnd_global.local_chr(10)||
1513: 'original category_id = ' || r_org.category_id

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

1508: || ', new organization_id = ' || l_profile_org_id
1509: || fnd_global.local_chr(10)||
1510: 'original category_set_id = ' || r_org.category_set_id
1511: || ', new category_set_id = ' || l_profile_category_set_id
1512: || fnd_global.local_chr(10)||
1513: 'original category_id = ' || r_org.category_id
1514: || ', new category_id = ' || l_profile_category_id
1515: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1516: );

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

1571: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1572: jtm_message_log_pkg.Log_Msg
1573: ( p_resource_id
1574: , g_table_name
1575: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1576: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1577: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1578: 'category_id = ' || l_profile_category_id
1579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

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

1572: jtm_message_log_pkg.Log_Msg
1573: ( p_resource_id
1574: , g_table_name
1575: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1576: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1577: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1578: 'category_id = ' || l_profile_category_id
1579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1580: END IF;

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

1573: ( p_resource_id
1574: , g_table_name
1575: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1576: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1577: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1578: 'category_id = ' || l_profile_category_id
1579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1580: END IF;
1581:

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

1605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1606: jtm_message_log_pkg.Log_Msg
1607: ( 0
1608: , g_table_name
1609: , 'Caught exception in CONCURRENT_PROCESS_USER'||fnd_global.local_chr(10)||
1610: 'Error: '||sqlerrm
1611: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1612: END IF;
1613: ROLLBACK;

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

1744: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1745: jtm_message_log_pkg.Log_Msg
1746: ( 0
1747: , g_table_name
1748: , 'CON_REQUEST_MTL_SYSTEM_ITEMS'||fnd_global.local_chr(10)||
1749: 'Error: '||sqlerrm
1750: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1751: END IF;
1752: ROLLBACK;