APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 35: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_I for location_id: ' || p_location_id,

31: l_error_msg VARCHAR2(4000);
32: l_return_status VARCHAR2(2000);
33:
34: BEGIN
35: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_I for location_id: ' || p_location_id,
36: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
37:
38: CSM_ACC_PKG.Insert_Acc
39: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 49: CSM_UTIL_PKG.LOG('Leaving CSP_SHIP_TO_ADDR_MDIRTY_I for location_id: ' || p_location_id,

45: ,P_PK2_NUM_VALUE => p_site_use_id
46: ,P_USER_ID => p_user_id
47: );
48:
49: CSM_UTIL_PKG.LOG('Leaving CSP_SHIP_TO_ADDR_MDIRTY_I for location_id: ' || p_location_id,
50: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
51: EXCEPTION
52: WHEN OTHERS THEN
53: l_sqlerrno := to_char(SQLCODE);

Line 57: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

53: l_sqlerrno := to_char(SQLCODE);
54: l_sqlerrmsg := substr(SQLERRM, 1,2000);
55: l_error_msg := ' Exception in CSP_SHIP_TO_ADDR_MDIRTY_I for location_id:'
56: || to_char(p_location_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
57: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
58: RAISE;
59: END CSP_SHIP_TO_ADDR_MDIRTY_I;
60:
61: PROCEDURE CSP_SHIP_TO_ADDR_MDIRTY_U(p_location_id IN NUMBER,

Line 72: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,

68: l_return_status VARCHAR2(2000);
69: l_access_id NUMBER;
70:
71: BEGIN
72: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,
73: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
74:
75: l_access_id := CSM_ACC_PKG.Get_Acc_Id
76: ( P_ACC_TABLE_NAME => g_acc_table_name1

Line 91: CSM_UTIL_PKG.LOG('Leaving CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,

87: ,P_ACCESS_ID => l_access_id
88: ,P_USER_ID => p_user_id
89: );
90:
91: CSM_UTIL_PKG.LOG('Leaving CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,
92: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
93: EXCEPTION
94: WHEN OTHERS THEN
95: l_sqlerrno := to_char(SQLCODE);

Line 99: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);

95: l_sqlerrno := to_char(SQLCODE);
96: l_sqlerrmsg := substr(SQLERRM, 1,2000);
97: l_error_msg := ' Exception in CSP_SHIP_TO_ADDR_MDIRTY_U for location_id:'
98: || to_char(p_location_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
99: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);
100: RAISE;
101: END CSP_SHIP_TO_ADDR_MDIRTY_U;
102:
103: FUNCTION CUST_ACCT_SITE_UPD_WF_EVENT(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

Line 145: CSM_UTIL_PKG.LOG('Entering CUST_ACCT_SITE_UPD_WF_EVENT',

141: AND site_use_id = p_site_use_id
142: AND user_id = p_user_id;
143:
144: BEGIN
145: CSM_UTIL_PKG.LOG('Entering CUST_ACCT_SITE_UPD_WF_EVENT',
146: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);
147:
148: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
149: RETURN 'SUCCESS';

Line 148: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

144: BEGIN
145: CSM_UTIL_PKG.LOG('Entering CUST_ACCT_SITE_UPD_WF_EVENT',
146: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);
147:
148: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
149: RETURN 'SUCCESS';
150: END IF;
151:
152: l_cust_acct_site_id := p_event.GetValueForParameter('CUST_ACCT_SITE_ID');

Line 155: IF csm_util_pkg.is_palm_resource(r_cust_acc_site_upd_rec.resource_id) THEN

151:
152: l_cust_acct_site_id := p_event.GetValueForParameter('CUST_ACCT_SITE_ID');
153:
154: FOR r_cust_acc_site_upd_rec IN l_cust_acc_site_upd_csr(l_cust_acct_site_id) LOOP
155: IF csm_util_pkg.is_palm_resource(r_cust_acc_site_upd_rec.resource_id) THEN
156: OPEN l_location_access_csr(r_cust_acc_site_upd_rec.location_id, r_cust_acc_site_upd_rec.site_use_id, r_cust_acc_site_upd_rec.user_id);
157: FETCH l_location_access_csr INTO l_dummy;
158: IF l_location_access_csr%FOUND THEN
159: IF r_cust_acc_site_upd_rec.status <> 'A' THEN

Line 168: csm_util_pkg.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.SPAWN_CUST_ACCT_SITE_DEL', FND_LOG.LEVEL_ERROR);

164: p_error_msg => l_error_msg,
165: x_return_status => l_return_status);
166:
167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: csm_util_pkg.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.SPAWN_CUST_ACCT_SITE_DEL', FND_LOG.LEVEL_ERROR);
169: END IF;
170:
171: -- process delete of csm_po_loc_ass_all
172: CSM_ACC_PKG.Delete_Acc

Line 206: CSM_UTIL_PKG.LOG('Leaving CUST_ACCT_SITE_UPD_WF_EVENT for cust_acct_site_id: ' || TO_CHAR(l_cust_acct_site_id),

202: CLOSE l_location_access_csr;
203: END IF; -- end of palm resource
204: END LOOP;
205:
206: CSM_UTIL_PKG.LOG('Leaving CUST_ACCT_SITE_UPD_WF_EVENT for cust_acct_site_id: ' || TO_CHAR(l_cust_acct_site_id),
207: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);
208:
209: RETURN 'SUCCESS';
210:

Line 217: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_EXCEPTION);

213: l_sqlerrno := to_char(SQLCODE);
214: l_sqlerrmsg := substr(SQLERRM, 1,2000);
215: l_error_msg := ' Exception in CUST_ACCT_SITE_UPD_WF_EVENT for party_id:' || to_char(l_cust_acct_site_id)
216: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
217: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_EXCEPTION);
218: RETURN 'ERROR';
219: END CUST_ACCT_SITE_UPD_WF_EVENT;
220:
221: END CSM_PO_LOCATIONS_EVENT_PKG;