eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on CSM_PO_LOCATIONS_EVENT_PKG

Line 1: PACKAGE BODY CSM_PO_LOCATIONS_EVENT_PKG

1: PACKAGE BODY CSM_PO_LOCATIONS_EVENT_PKG
2: /* $Header: csmepolb.pls 120.1.12020000.2 2013/04/09 10:57:43 saradhak ship $*/
3: AS
4: --
5: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE

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

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

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

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

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

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

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

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

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

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

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 203: csm_po_locations_event_pkg.csp_ship_to_addr_mdirty_i

199: p_error_msg=>l_error_msg,
200: x_return_status=>l_return_status);
201:
202: -- insert into csm_po_loc_ass_all_acc
203: csm_po_locations_event_pkg.csp_ship_to_addr_mdirty_i
204: (p_location_id=>r_cust_acc_site_upd_rec.location_id,
205: p_org_id=>r_cust_acc_site_upd_rec.org_id,
206: p_res_type=>r_cust_acc_site_upd_rec.resource_type,
207: p_user_id=>r_cust_acc_site_upd_rec.user_id);

Line 215: 'CSM_PO_LOCATIONS_EVENT_PKG.CUST_ACCT_SITE_UPD_WF_EVENT',FND_LOG.LEVEL_PROCEDURE);

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

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)

Line 272: csm_po_locations_event_pkg.csp_ship_to_addr_mdirty_i

268: p_error_msg=>l_error_msg,
269: x_return_status=>l_return_status);
270:
271: -- insert into csm_po_loc_ass_all_acc
272: csm_po_locations_event_pkg.csp_ship_to_addr_mdirty_i
273: (p_location_id=>r_cust_acc_site_upd_rec.location_id,
274: p_org_id=>r_cust_acc_site_upd_rec.org_id,
275: p_res_type=>r_cust_acc_site_upd_rec.resource_type,
276: p_user_id=>r_cust_acc_site_upd_rec.user_id);

Line 336: END CSM_PO_LOCATIONS_EVENT_PKG;

332:
333: END LOOP;
334: END GRP_ADDRESS_D;
335:
336: END CSM_PO_LOCATIONS_EVENT_PKG;