APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on FND_LOG

Line 36: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

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
40: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 50: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

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);
54: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 73: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

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
77: ,P_PK1_NAME => g_pk1_name1

Line 92: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

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);
96: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 146: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);

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';
150: END IF;

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 207: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);

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:
211: EXCEPTION

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;