PACKAGE BODY: APPS.CSM_CONCURRENT_JOBS_PKG

Source

1 PACKAGE BODY CSM_CONCURRENT_JOBS_PKG AS
2 /* $Header: csmconcb.pls 120.1 2005/07/22 02:41:57 trajasek noship $ */
3 
4 
5 --
6 -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
7 -- directory of SQL Navigator
8 --
9 -- Purpose: Briefly explain the functionality of the package body
10 --
11 -- MODIFICATION HISTORY
12 -- Person      Date    Comments
13 -- ---------   ------  ------------------------------------------
14    -- Enter procedure, function bodies as shown below
15 
16 PROCEDURE refresh_all_acc( x_retcode OUT NOCOPY NUMBER,
17                            x_return_status OUT NOCOPY VARCHAR2)
18 IS
19 l_sqlerrno VARCHAR2(20);
20 l_sqlerrmsg VARCHAR2(2000);
21 l_status  VARCHAR2(2000);
22 l_message VARCHAR2(2000);
23 
24 BEGIN
25 
26   -- Do not run if the Palm application is not enabled
27   IF NOT csm_util_pkg.is_field_service_palm_enabled THEN
28     csm_util_pkg.log('Attempt made to start Concurrent Program while Field Service Palm Application Disabled'
29                      ,'CSM_CONCURRENT_JOBS_PKG.refresh_all_acc',FND_LOG.LEVEL_PROCEDURE );
30     RETURN;
31   END IF;
32 
33   x_retcode := 0;
34   -- refresh all acc tables
35 
36   csm_bus_process_txns_event_pkg.refresh_acc(l_status, l_message);
37 
38   csm_currency_event_pkg.refresh_acc(l_status, l_message);
39 
40   csm_lookup_event_pkg.refresh_acc(l_status, l_message);
41 
42   csm_messages_event_pkg.refresh_acc(l_status, l_message);
43 
44   csm_profile_event_pkg.refresh_acc(l_status, l_message);
45 
46   csm_state_transition_event_pkg.refresh_acc(l_status, l_message);
47 
48   csm_system_item_event_pkg.refresh_acc(l_status, l_message);
49 
50   csm_txn_bill_types_event_pkg.refresh_acc(l_status, l_message);
51 
52   csm_system_item_event_pkg.refresh_mtl_onhand_quantity(l_status, l_message);
53 
54   csm_uom_event_pkg.refresh_acc(l_status, l_message);
55 
56   csm_probcode_mapping_event_pkg.refresh_probcode_mapping_acc(l_status, l_message);
57 
58   csm_util_pkg.refresh_all_app_level_acc(l_status, l_message);
59 
60   csm_mtl_sec_inv_event_pkg.refresh_acc(l_status, l_message);
61 
62   csm_mtl_item_subinv_event_pkg.refresh_acc(l_status, l_message);
63 
64   csm_mtl_item_loc_event_pkg.refresh_acc(l_status, l_message);
65 
66   csm_mtl_sec_locators_event_pkg.refresh_acc(l_status, l_message);
67 
68   csm_mtl_parameters_event_pkg.refresh_acc(l_status, l_message);
69 
70   csm_csi_item_attr_event_pkg.refresh_acc(l_status, l_message);
71 
72   csm_lobs_event_pkg.conc_download_attachments(l_status, l_message);
73 
74   csm_notes_event_pkg.object_mappings_acc_processor;
75 
76 EXCEPTION
77   WHEN others THEN
78      l_sqlerrno := to_char(SQLCODE);
79      l_sqlerrmsg := substr(SQLERRM, 1,2000);
80      x_retcode := 2;
81      fnd_file.put_line(fnd_file.log, 'CSM_CONCURRENT_JOBS_PKG.REFRESH_ALL_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
82      csm_util_pkg.log(l_sqlerrmsg,'CSM_CONCURRENT_JOBS_PKG.REFRESH_ALL_ACC',FND_LOG.LEVEL_EXCEPTION);
83 END refresh_all_acc;
84 
85 END CSM_CONCURRENT_JOBS_PKG;