63: IF l_dml_mode <> 'POST' THEN
64: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
65: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
66: l_module_name,
67: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Pre...');
68: end if;
69:
70: csp_req_line_details_iuhk.Create_req_line_detail_Pre
71: ( x_return_status => l_return_status
66: l_module_name,
67: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Pre...');
68: end if;
69:
70: csp_req_line_details_iuhk.Create_req_line_detail_Pre
71: ( x_return_status => l_return_status
72: ) ;
73: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
74: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
72: ) ;
73: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
74: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
75: l_module_name,
76: 'after calling csp_req_line_details_iuhk.Create_req_line_detail_Pre. l_return_status = ' || l_return_status);
77: end if;
78: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
79: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
80: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
123:
124: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
125: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
126: l_module_name,
127: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Post...');
128: end if;
129:
130: csp_req_line_details_iuhk.Create_req_line_detail_Post
131: ( x_return_status => l_return_status
126: l_module_name,
127: 'before calling csp_req_line_details_iuhk.Create_req_line_detail_Post...');
128: end if;
129:
130: csp_req_line_details_iuhk.Create_req_line_detail_Post
131: ( x_return_status => l_return_status
132: ) ;
133:
134: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
133:
134: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
135: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
136: l_module_name,
137: 'after calling csp_req_line_details_iuhk.Create_req_line_detail_Post. l_return_status = ' || l_return_status);
138: end if;
139:
140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
181:
182: IF l_dml_mode <> 'POST' THEN
183:
184: user_hook_rec.REQ_LINE_DETAIL_ID := l_req_line_details.REQ_LINE_DETAIL_ID;
185: csp_req_line_details_iuhk.Update_req_line_detail_Pre
186: ( x_return_status => l_return_status
187: ) ;
188: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
189: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
209: where REQ_LINE_DETAIL_ID = l_req_line_details.REQ_LINE_DETAIL_ID;
210: END IF;
211:
212: IF l_dml_mode <> 'PRE' THEN
213: csp_req_line_details_iuhk.Update_req_line_detail_post
214: ( x_return_status => l_return_status
215: ) ;
216: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
217: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
242: END IF;
243:
244: IF l_dml_mode <> 'POST' THEN
245: user_hook_rec.REQ_LINE_DETAIL_ID := px_REQ_LINE_DETAIL_ID;
246: csp_req_line_details_iuhk.delete_req_line_detail_Pre
247: ( x_return_status => l_return_status
248: ) ;
249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
260: WHERE REQ_LINE_DETAIL_ID = px_REQ_LINE_DETAIL_ID;
261: END IF;
262:
263: IF l_dml_mode <> 'PRE' THEN
264: csp_req_line_details_iuhk.delete_req_line_detail_Post
265: ( x_return_status => l_return_status
266: ) ;
267: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
268: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');