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_HEADERS_EVENT_PKG dependencies on FND_LOG

Line 44: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

40: l_return_status VARCHAR2(2000);
41: l_ps_id NUMBER;
42: BEGIN
43: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_I for requirement_header_id: ' || p_requirement_header_id,
44: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
45:
46: CSM_ACC_PKG.Insert_Acc
47: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
48: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 71: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);

67: x_return_status => l_return_status);
68: END IF;
69:
70: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_HEADERS_MDIRTY_I for requirement_header_id: ' || p_requirement_header_id,
71: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
72: EXCEPTION
73: WHEN OTHERS THEN
74: l_sqlerrno := to_char(SQLCODE);
75: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 78: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

74: l_sqlerrno := to_char(SQLCODE);
75: l_sqlerrmsg := substr(SQLERRM, 1,2000);
76: l_error_msg := ' Exception in CSP_REQ_HEADERS_MDIRTY_I for requirement_header_id:'
77: || to_char(p_requirement_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
78: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
79: RAISE;
80: END CSP_REQ_HEADERS_MDIRTY_I;
81:
82: PROCEDURE CSP_REQ_HEADERS_MDIRTY_D(p_requirement_header_id IN NUMBER,

Line 92: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

88: l_return_status VARCHAR2(2000);
89:
90: BEGIN
91: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_D for requirement_header_id: ' || p_requirement_header_id,
92: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
93:
94: CSM_ACC_PKG.Delete_Acc
95: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
96: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 103: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);

99: ,P_USER_ID => p_user_id
100: );
101:
102: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_HEADERS_MDIRTY_D for requirement_header_id: ' || p_requirement_header_id,
103: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
104: EXCEPTION
105: WHEN OTHERS THEN
106: l_sqlerrno := to_char(SQLCODE);
107: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 110: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

106: l_sqlerrno := to_char(SQLCODE);
107: l_sqlerrmsg := substr(SQLERRM, 1,2000);
108: l_error_msg := ' Exception in CSP_REQ_HEADERS_MDIRTY_D for requirement_header_id:'
109: || to_char(p_requirement_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
110: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
111: RAISE;
112: END CSP_REQ_HEADERS_MDIRTY_D;
113:
114: PROCEDURE CSP_REQ_HEADERS_MDIRTY_U(p_requirement_header_id IN NUMBER,

Line 125: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

121: l_access_id NUMBER;
122: l_ps_id NUMBER;
123: BEGIN
124: CSM_UTIL_PKG.LOG('Entering CSP_REQ_HEADERS_MDIRTY_U for requirement_header_id: ' || p_requirement_header_id,
125: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
126:
127: l_access_id := CSM_ACC_PKG.Get_Acc_Id
128: ( P_ACC_TABLE_NAME => g_acc_table_name1
129: ,P_PK1_NAME => g_pk1_name1

Line 160: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);

156: x_return_status => l_return_status);
157: END IF;
158:
159: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_HEADERS_MDIRTY_U for requirement_header_id: ' || p_requirement_header_id,
160: 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
161: EXCEPTION
162: WHEN OTHERS THEN
163: l_sqlerrno := to_char(SQLCODE);
164: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 167: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);

163: l_sqlerrno := to_char(SQLCODE);
164: l_sqlerrmsg := substr(SQLERRM, 1,2000);
165: l_error_msg := ' Exception in CSP_REQ_HEADERS_MDIRTY_U for requirement_header_id:'
166: || to_char(p_requirement_header_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
167: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_CSP_REQ_HEADERS_EVENT_PKG.CSP_REQ_HEADERS_MDIRTY_U',FND_LOG.LEVEL_EXCEPTION);
168: RAISE;
169: END CSP_REQ_HEADERS_MDIRTY_U;
170:
171: END CSM_CSP_REQ_HEADERS_EVENT_PKG;