APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 30: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,

26: l_error_msg VARCHAR2(4000);
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

Line 42: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_I for requirement_line_id: ' || p_requirement_line_id,

38: ,P_PK1_NUM_VALUE => p_requirement_line_id
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);

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 62: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,

58: l_error_msg VARCHAR2(4000);
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

Line 73: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_D for requirement_line_id: ' || p_requirement_line_id,

69: ,P_PK1_NUM_VALUE => p_requirement_line_id
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);

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 94: CSM_UTIL_PKG.LOG('Entering CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,

90: l_return_status VARCHAR2(2000);
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

Line 113: CSM_UTIL_PKG.LOG('Leaving CSP_REQ_LINES_MDIRTY_U for requirement_line_id: ' || p_requirement_line_id,

109: ,P_USER_ID => p_user_id
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);

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: