APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on CSM_UTIL_PKG

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

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

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

49: ,P_PK3_CHAR_VALUE => p_res_type
50: ,P_USER_ID => p_user_id
51: );
52:
53: CSM_UTIL_PKG.LOG('Leaving CSP_SHIP_TO_ADDR_MDIRTY_I for location_id: ' || p_location_id,
54: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
55: EXCEPTION
56: WHEN OTHERS THEN
57: l_sqlerrno := to_char(SQLCODE);

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

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

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

73: l_return_status VARCHAR2(2000);
74: l_access_id NUMBER;
75:
76: BEGIN
77: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,
78: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
79:
80: l_access_id := CSM_ACC_PKG.Get_Acc_Id
81: ( P_ACC_TABLE_NAME => g_acc_table_name1

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

93: ,P_ACCESS_ID => l_access_id
94: ,P_USER_ID => p_user_id
95: );
96:
97: CSM_UTIL_PKG.LOG('Leaving CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,
98: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
99: EXCEPTION
100: WHEN OTHERS THEN
101: l_sqlerrno := to_char(SQLCODE);

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

101: l_sqlerrno := to_char(SQLCODE);
102: l_sqlerrmsg := substr(SQLERRM, 1,2000);
103: l_error_msg := ' Exception in CSP_SHIP_TO_ADDR_MDIRTY_U for location_id:'
104: || to_char(p_location_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
105: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);
106: RAISE;
107: END CSP_SHIP_TO_ADDR_MDIRTY_U;
108:
109: FUNCTION CUST_ACCT_SITE_UPD_WF_EVENT(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

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

148: WHERE location_id = p_location_id
149: AND user_id = p_user_id;
150:
151: BEGIN
152: CSM_UTIL_PKG.LOG('Entering CUST_ACCT_SITE_UPD_WF_EVENT',
153: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);
154:
155: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
156: RETURN 'SUCCESS';

Line 155: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

151: BEGIN
152: CSM_UTIL_PKG.LOG('Entering CUST_ACCT_SITE_UPD_WF_EVENT',
153: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);
154:
155: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
156: RETURN 'SUCCESS';
157: END IF;
158:
159: l_cust_acct_site_id := p_event.GetValueForParameter('CUST_ACCT_SITE_ID');

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

170: p_error_msg => l_error_msg,
171: x_return_status => l_return_status);
172:
173: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
174: csm_util_pkg.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.SPAWN_CUST_ACCT_SITE_DEL', FND_LOG.LEVEL_ERROR);
175: END IF;
176:
177: -- process delete of csm_po_loc_ass_all
178: CSM_ACC_PKG.Delete_Acc

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

210: END IF; -- if l_location_access_csr found
211: CLOSE l_location_access_csr;
212: END LOOP;
213:
214: CSM_UTIL_PKG.LOG('Leaving CUST_ACCT_SITE_UPD_WF_EVENT for cust_acct_site_id: ' || TO_CHAR(l_cust_acct_site_id),
215: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);
216:
217: RETURN 'SUCCESS';
218:

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

221: l_sqlerrno := to_char(SQLCODE);
222: l_sqlerrmsg := substr(SQLERRM, 1,2000);
223: l_error_msg := ' Exception in CUST_ACCT_SITE_UPD_WF_EVENT for party_id:' || to_char(l_cust_acct_site_id)
224: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
225: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_EXCEPTION);
226: RETURN 'ERROR';
227: END CUST_ACCT_SITE_UPD_WF_EVENT;
228:
229: PROCEDURE GRP_ADDRESS_I(p_group_id IN jtf_rs_group_members.group_id%TYPE,p_resource_id IN jtf_rs_group_members.resource_id%TYPE)