179: ) ;
180: --dbms_output.put_line('csf_debrief_lines_cuhk.Create_debrief_line_Pre Status '||l_return_status);
181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
182: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
183: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
184: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
185: FND_MSG_PUB.Add;
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
180: --dbms_output.put_line('csf_debrief_lines_cuhk.Create_debrief_line_Pre Status '||l_return_status);
181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
182: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
183: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
184: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
185: FND_MSG_PUB.Add;
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188: END IF;
204:
205: --dbms_output.put_line('PRE CALLED STATUS '||l_return_status);
206: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
207: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
208: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
209: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
210: FND_MSG_PUB.Add;
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
205: --dbms_output.put_line('PRE CALLED STATUS '||l_return_status);
206: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
207: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
208: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
209: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
210: FND_MSG_PUB.Add;
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: END IF;
219:
220: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);
221: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
222: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
223: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
224: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
220: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);
221: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
222: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
223: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
224: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:
397: ) ;
398: --dbms_output.put_line('POST '||l_return_status);
399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
400: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
401: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
402: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
403: FND_MSG_PUB.Add;
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
398: --dbms_output.put_line('POST '||l_return_status);
399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
400: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
401: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
402: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
403: FND_MSG_PUB.Add;
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406: END IF;
419: ) ;
420:
421: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
422: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
423: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
424: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
425: FND_MSG_PUB.Add;
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
420:
421: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
422: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
423: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
424: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
425: FND_MSG_PUB.Add;
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428: END IF;
432: ) ;
433:
434: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
435: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
436: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
437: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
438: FND_MSG_PUB.Add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
433:
434: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
435: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
436: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
437: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
438: FND_MSG_PUB.Add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441: end if;
610: x_msg_data => l_msg_data
611: ) ;
612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
613: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
614: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
615: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
616: FND_MSG_PUB.Add;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
611: ) ;
612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
613: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
614: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
615: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
616: FND_MSG_PUB.Add;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619: END IF;
632: ) ;
633:
634: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
635: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
636: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
637: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
633:
634: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
635: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
636: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
637: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
641: END IF;
645: ) ;
646:
647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
648: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
649: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
650: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
646:
647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
648: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
649: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
650: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
748: x_msg_data => l_msg_data
749: ) ;
750: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
751: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
752: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
753: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
754: FND_MSG_PUB.Add;
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
749: ) ;
750: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
751: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
752: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
753: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
754: FND_MSG_PUB.Add;
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: END IF;
770: ) ;
771:
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
774: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
775: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
776: FND_MSG_PUB.Add;
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
771:
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
774: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
775: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
776: FND_MSG_PUB.Add;
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779: END IF;
783: ) ;
784:
785: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
786: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
787: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
788: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
784:
785: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
786: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
787: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
788: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792:
821: x_msg_data => l_msg_data
822: ) ;
823: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
824: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
825: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
826: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
827: FND_MSG_PUB.Add;
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
822: ) ;
823: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
824: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
825: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
826: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
827: FND_MSG_PUB.Add;
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
843: ) ;
844:
845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
847: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
848: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
849: FND_MSG_PUB.Add;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
844:
845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
847: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
848: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
849: FND_MSG_PUB.Add;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;
856: ) ;
857:
858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
859: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
860: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
861: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
862: FND_MSG_PUB.Add;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
857:
858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
859: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
860: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
861: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
862: FND_MSG_PUB.Add;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:
887: x_msg_data => l_msg_data
888: ) ;
889: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
890: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
891: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
892: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
893: FND_MSG_PUB.Add;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END IF;
888: ) ;
889: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
890: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
891: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
892: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
893: FND_MSG_PUB.Add;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END IF;
896: END IF;
909: ) ;
910:
911: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
912: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
913: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
914: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
915: FND_MSG_PUB.Add;
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
910:
911: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
912: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
913: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
914: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
915: FND_MSG_PUB.Add;
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: END IF;
922: ) ;
923:
924: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
925: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
926: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
927: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
928: FND_MSG_PUB.Add;
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
923:
924: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
925: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
926: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
927: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
928: FND_MSG_PUB.Add;
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931: end if;
1014: OPEN C;
1015: FETCH C INTO Recinfo;
1016: If (C%NOTFOUND) then
1017: CLOSE C;
1018: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1019: APP_EXCEPTION.RAISE_EXCEPTION;
1020: End If;
1021: CLOSE C;
1022: if (
1224: AND ( p_RETURN_DATE IS NULL )))
1225: ) then
1226: return;
1227: else
1228: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1229: APP_EXCEPTION.RAISE_EXCEPTION;
1230: End If;
1231: END Lock_Row;
1232: