585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588: END IF;
589: --dbms_output.put_line('csf_debrief_lines_iuhk ');
590:
591: csf_debrief_lines_iuhk.Create_debrief_line_Pre
592: ( x_return_status => l_return_status
593: ) ;
587: END IF;
588: END IF;
589: --dbms_output.put_line('csf_debrief_lines_iuhk ');
590:
591: csf_debrief_lines_iuhk.Create_debrief_line_Pre
592: ( x_return_status => l_return_status
593: ) ;
594:
595: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);
591: csf_debrief_lines_iuhk.Create_debrief_line_Pre
592: ( x_return_status => l_return_status
593: ) ;
594:
595: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);
596: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
597: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
598: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
599: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;
857: END IF;
858:
859: csf_debrief_lines_iuhk.Create_debrief_line_post
860: ( x_return_status => l_return_status
861: ) ;
862:
863: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247: END IF;
1248: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;
1249: csf_debrief_lines_iuhk.update_debrief_line_Pre
1250: ( x_return_status => l_return_status
1251: ) ;
1252:
1253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1398: END IF;
1399:
1400: csf_debrief_lines_iuhk.update_debrief_line_post
1401: ( x_return_status => l_return_status
1402: ) ;
1403:
1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: END IF;
1472: user_hooks_rec.DEBRIEF_LINE_ID := p_DEBRIEF_LINE_ID;
1473: csf_debrief_lines_iuhk.delete_debrief_line_Pre
1474: ( x_return_status => l_return_status
1475: ) ;
1476:
1477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1536: END IF;
1537: END IF;
1538:
1539: csf_debrief_lines_iuhk.delete_debrief_line_post
1540: ( x_return_status => l_return_status
1541: ) ;
1542:
1543: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN