106: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
107: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
108: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
109: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: END IF;
114:
128: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
129: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
130: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
131: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
132: FND_MSG_PUB.Add;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135: END IF;
136:
140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
142: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_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: If (l_requirement_header.REQUIREMENT_HEADER_ID IS NULL) OR (l_requirement_header.REQUIREMENT_HEADER_ID = FND_API.G_MISS_NUM) then
148: OPEN C2;
242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
244: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
245: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: END IF;
250:
264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
265: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
266: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
267: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
268: FND_MSG_PUB.Add;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: END IF;
272: csp_requirement_headers_iuhk.Create_requirement_header_post
275: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
276: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
277: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
278: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: End Insert_Row;
376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
378: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
379: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383: END IF;
384:
398: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
399: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
400: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
401: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
402: FND_MSG_PUB.Add;
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405: END IF;
406: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;
410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
412: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
413: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
414: FND_MSG_PUB.Add;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: Update CSP_REQUIREMENT_HEADERS
418: SET
469: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
470: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
471: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
472: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
473: FND_MSG_PUB.Add;
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: END IF;
477:
491: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
492: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
493: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
494: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: END IF;
499: csp_requirement_headers_iuhk.update_requirement_header_post
502: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
503: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
504: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
505: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
506: FND_MSG_PUB.Add;
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509: END Update_Row;
510:
530: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
531: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
532: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
533: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536: END IF;
537: END IF;
538:
553: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
554: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
555: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
556: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
557: FND_MSG_PUB.Add;
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END IF;
560: END IF;
561: user_hooks_rec.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
565: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
566: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
567: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
568: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
569: FND_MSG_PUB.Add;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: DELETE FROM CSP_REQUIREMENT_HEADERS
573: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID;
588: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
589: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
590: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
591: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
592: FND_MSG_PUB.Add;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595: END IF;
596:
611: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
612: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
613: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
614: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618: END IF;
619: csp_requirement_headers_iuhk.delete_requirement_header_post
622: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
623: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
624: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
625: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
626: FND_MSG_PUB.Add;
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629: END Delete_Row;
630: