104: x_msg_data => l_msg_data
105: ) ;
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;
105: ) ;
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;
126: ) ;
127:
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;
127:
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;
138: ( x_return_status => l_return_status
139: ) ;
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;
139: ) ;
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
240:
241:
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;
241:
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;
262: x_msg_data => l_msg_data
263: ) ;
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;
263: ) ;
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;
273: ( x_return_status => l_return_status
274: ) ;
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;
274: ) ;
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:
374: x_msg_data => l_msg_data
375: ) ;
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;
375: ) ;
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;
396: ) ;
397:
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;
397:
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;
408: ( x_return_status => l_return_status
409: ) ;
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;
409: ) ;
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
467: x_msg_data => l_msg_data
468: ) ;
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;
468: ) ;
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;
489: ) ;
490:
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;
490:
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;
500: ( x_return_status => l_return_status
501: ) ;
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;
501: ) ;
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;
528: x_msg_data => l_msg_data
529: ) ;
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;
529: ) ;
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;
551: ) ;
552:
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;
552:
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;
563: ( x_return_status => l_return_status
564: ) ;
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;
564: ) ;
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
586: x_msg_data => l_msg_data
587: ) ;
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;
587: ) ;
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;
609: ) ;
610:
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;
610:
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;
620: ( x_return_status => l_return_status
621: ) ;
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;
621: ) ;
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;
677: OPEN C;
678: FETCH C INTO Recinfo;
679: If (C%NOTFOUND) then
680: CLOSE C;
681: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
682: APP_EXCEPTION.RAISE_EXCEPTION;
683: End If;
684: CLOSE C;
685: if (
791: AND ( p_DESTINATION_SUBINVENTORY IS NULL )))
792: ) then
793: return;
794: else
795: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
796: APP_EXCEPTION.RAISE_EXCEPTION;
797: End If;
798: END Lock_Row;
799: