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');
81: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
82: FND_MSG_PUB.Add;
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
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');
81: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
82: FND_MSG_PUB.Add;
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
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');
142: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
143: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: 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');
142: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
143: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147: END IF;
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');
190: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
191: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
192: FND_MSG_PUB.Add;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
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');
190: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
191: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
192: FND_MSG_PUB.Add;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195: END IF;
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');
218: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
219: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
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');
218: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
219: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223:
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');
251: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
253: FND_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
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');
251: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
253: FND_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: END IF;
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');
269: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
270: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
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');
269: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
270: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: If (SQL%NOTFOUND) then
298: OPEN C;
299: FETCH C INTO Recinfo;
300: If (C%NOTFOUND) then
301: CLOSE C;
302: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
303: APP_EXCEPTION.RAISE_EXCEPTION;
304: End If;
305: CLOSE C;
306: if (
331: AND ( p_SOURCE_ID IS NULL )))
332: ) then
333: return;
334: else
335: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
336: APP_EXCEPTION.RAISE_EXCEPTION;
337: End If;
338: END Lock_Row;
339: End CSP_REQ_LINE_DETAILS_PKG;