113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
114: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
115: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
116: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
117: FND_MSG_PUB.Add;
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120: END IF;
121:
135: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
136: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
137: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
138: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
139: FND_MSG_PUB.Add;
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: END IF;
143: csp_requirement_lines_iuhk.Create_requirement_line_Pre
146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
148: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
149: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
150: FND_MSG_PUB.Add;
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153: If (l_requirement_line.REQUIREMENT_LINE_ID IS NULL) OR (l_requirement_line.REQUIREMENT_LINE_ID = FND_API.G_MISS_NUM) then
154: OPEN C2;
258: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
259: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
260: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
261: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: END IF;
266:
280: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
281: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
282: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
283: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
284: FND_MSG_PUB.Add;
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287: END IF;
288: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
293: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
294: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
295: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END IF;
299:
300: End Insert_Row;
402: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
403: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
404: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
405: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
406: FND_MSG_PUB.Add;
407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408: END IF;
409: END IF;
410:
424: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
425: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
426: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
427: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
428: FND_MSG_PUB.Add;
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: END IF;
432: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;
436: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
437: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
438: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
439: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
440: FND_MSG_PUB.Add;
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443:
444: Update CSP_REQUIREMENT_LINES
500: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
501: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
502: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
503: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
504: FND_MSG_PUB.Add;
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507: END IF;
508:
521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
523: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
524: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
525: FND_MSG_PUB.Add;
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: END IF;
529: csp_requirement_lines_iuhk.update_requirement_line_post
532: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
533: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
534: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
535: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
536: FND_MSG_PUB.Add;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539:
540: END Update_Row;
560: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
561: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
562: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
563: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566: END IF;
567: END IF;
568:
582: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
583: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
584: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
585: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: END IF;
589: END IF;
590: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;
594: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
596: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
597: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601:
602: DELETE FROM CSP_REQUIREMENT_LINES
617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
618: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
619: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
620: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
621: FND_MSG_PUB.Add;
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624: END IF;
625:
639: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
640: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
641: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
642: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
643: FND_MSG_PUB.Add;
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: END IF;
646: END IF;
647: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;
651: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
652: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
653: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
654: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
655: FND_MSG_PUB.Add;
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659: END Delete_Row;