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_CSP_REQ_LINES_EVENT_PKG dependencies on CSM_CSP_REQ_LINES_EVENT_PKG

Line 1: PACKAGE BODY CSM_CSP_REQ_LINES_EVENT_PKG

1: PACKAGE BODY CSM_CSP_REQ_LINES_EVENT_PKG
2: /* $Header: csmerlb.pls 120.1.12010000.3 2008/11/18 08:02:39 trajasek ship $*/
3: AS
4: --
5: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE

Line 31: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

27: l_return_status VARCHAR2(2000);
28:
29: BEGIN
30: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,
31: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
32:
33: CSM_ACC_PKG.Insert_Acc
34: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
35: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 43: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

39: ,P_USER_ID => p_user_id
40: );
41:
42: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,
43: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
44: EXCEPTION
45: WHEN OTHERS THEN
46: l_sqlerrno := to_char(SQLCODE);
47: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 50: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

46: l_sqlerrno := to_char(SQLCODE);
47: l_sqlerrmsg := substr(SQLERRM, 1,2000);
48: l_error_msg := ' Exception in CSP_REQ_LINES_MDIRTY_I for requirement_line_id:'
49: || to_char(p_requirement_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
50: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
51: RAISE;
52: END CSP_REQ_LINES_MDIRTY_I;
53:
54: PROCEDURE CSP_REQ_LINES_MDIRTY_D(p_requirement_line_id IN NUMBER, p_user_id IN NUMBER)

Line 63: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

59: l_return_status VARCHAR2(2000);
60:
61: BEGIN
62: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,
63: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
64:
65: CSM_ACC_PKG.Delete_Acc
66: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
67: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 74: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

70: ,P_USER_ID => p_user_id
71: );
72:
73: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,
74: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
75: EXCEPTION
76: WHEN OTHERS THEN
77: l_sqlerrno := to_char(SQLCODE);
78: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 81: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

77: l_sqlerrno := to_char(SQLCODE);
78: l_sqlerrmsg := substr(SQLERRM, 1,2000);
79: l_error_msg := ' Exception in CSP_REQ_LINES_MDIRTY_D for requirement_line_id:'
80: || to_char(p_requirement_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
81: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
82: RAISE;
83: END CSP_REQ_LINES_MDIRTY_D;
84:
85: PROCEDURE CSP_REQ_LINES_MDIRTY_U(p_requirement_line_id IN NUMBER, p_user_id IN NUMBER)

Line 95: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

91: l_access_id NUMBER;
92:
93: BEGIN
94: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,
95: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
96:
97: l_access_id := CSM_ACC_PKG.Get_Acc_Id
98: ( P_ACC_TABLE_NAME => g_acc_table_name1
99: ,P_PK1_NAME => g_pk1_name1

Line 114: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

110: );
111: END IF;
112:
113: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,
114: 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
115: EXCEPTION
116: WHEN OTHERS THEN
117: l_sqlerrno := to_char(SQLCODE);
118: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 121: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);

117: l_sqlerrno := to_char(SQLCODE);
118: l_sqlerrmsg := substr(SQLERRM, 1,2000);
119: l_error_msg := ' Exception in CSP_REQ_LINES_MDIRTY_U for requirement_line_id:'
120: || to_char(p_requirement_line_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
121: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_LINES_EVENT_PKG.CSP_REQ_LINES_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);
122: RAISE;
123: END CSP_REQ_LINES_MDIRTY_U;
124:
125:

Line 136: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'

132: CURSOR c_LastRundate
133: IS
134: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
135: FROM JTM_CON_REQUEST_DATA
136: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'
137: AND procedure_name = 'CONC_ORDER_UPDATE';
138:
139: r_LastRundate c_LastRundate%ROWTYPE;
140:

Line 210: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'

206:
207:
208: UPDATE JTM_CON_REQUEST_DATA
209: SET LAST_RUN_DATE = l_current_run_date
210: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'
211: AND procedure_name = 'CONC_ORDER_UPDATE';
212:
213: COMMIT;
214:

Line 224: p_message := 'CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE Executed successfully';

220: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
221: END IF;
222:
223: p_status := 'FINE';
224: p_message := 'CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE Executed successfully';
225:
226: RETURN;
227: EXCEPTION WHEN OTHERS THEN
228: p_status := 'ERROR';

Line 229: p_message := 'Error in CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE: ' || substr(SQLERRM, 1, 2000);

225:
226: RETURN;
227: EXCEPTION WHEN OTHERS THEN
228: p_status := 'ERROR';
229: p_message := 'Error in CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE: ' || substr(SQLERRM, 1, 2000);
230: /*** hook failed -> log error ***/
231: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
232: jtm_message_log_pkg.Log_Msg
233: ( 1

Line 238: fnd_msg_pub.Add_Exc_Msg('CSM_CSP_REQ_LINES_EVENT_PKG','CONC_ORDER_UPDATE',sqlerrm);

234: , g_table_name1
235: , 'Caught exception in CONC_ORDER_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
236: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
237: END IF;
238: fnd_msg_pub.Add_Exc_Msg('CSM_CSP_REQ_LINES_EVENT_PKG','CONC_ORDER_UPDATE',sqlerrm);
239: END CONC_ORDER_UPDATE;
240:
241: END CSM_CSP_REQ_LINES_EVENT_PKG;

Line 241: END CSM_CSP_REQ_LINES_EVENT_PKG;

237: END IF;
238: fnd_msg_pub.Add_Exc_Msg('CSM_CSP_REQ_LINES_EVENT_PKG','CONC_ORDER_UPDATE',sqlerrm);
239: END CONC_ORDER_UPDATE;
240:
241: END CSM_CSP_REQ_LINES_EVENT_PKG;