[Home] [Help]
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;