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;
189:
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;
214: --dbms_output.put_line('csf_debrief_lines_iuhk ');
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:
229: end if;
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;
407:
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;
429:
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;
442: --dbms_output.put_line('END INSERT ROW ');
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;
620:
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;
642: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;
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:
655: end if;
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;
758:
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;
780:
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:
793: end if;
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;
831:
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;
853: user_hooks_rec.DEBRIEF_LINE_ID := p_DEBRIEF_LINE_ID;
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:
866: end if;
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;
897:
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;
919:
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;
932: