93: ) ;
94:
95: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
96: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
97: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
98: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
94:
95: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
96: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
97: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
98: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102: END IF;
113: ) ;
114:
115: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
116: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
117: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
118: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
119: FND_MSG_PUB.Add;
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
114:
115: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
116: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
117: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
118: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
119: FND_MSG_PUB.Add;
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: 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_INT_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_INT_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:
215: ) ;
216:
217: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
218: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
219: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
220: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
221: FND_MSG_PUB.Add;
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
216:
217: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
218: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
219: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
220: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
221: FND_MSG_PUB.Add;
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: END IF;
235: ) ;
236:
237: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
238: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
239: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
240: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
236:
237: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
238: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
239: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
240: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: END IF;
247: ) ;
248:
249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
251: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
253: FND_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
248:
249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
251: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
253: FND_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: End Insert_Row;
338: ) ;
339:
340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
341: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
342: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
343: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
344: FND_MSG_PUB.Add;
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
339:
340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
341: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
342: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
343: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
344: FND_MSG_PUB.Add;
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
347: END IF;
358: ) ;
359:
360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
361: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
362: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
363: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
364: FND_MSG_PUB.Add;
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
359:
360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
361: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
362: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
363: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
364: FND_MSG_PUB.Add;
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367: END IF;
371: ) ;
372:
373: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
374: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
375: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
376: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
372:
373: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
374: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
375: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
376: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380:
426: ) ;
427:
428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
429: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
430: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
431: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
432: FND_MSG_PUB.Add;
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
434: END IF;
427:
428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
429: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
430: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
431: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
432: FND_MSG_PUB.Add;
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
434: END IF;
435: END IF;
446: ) ;
447:
448: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
449: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
450: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
451: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
447:
448: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
449: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
450: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
451: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455: END IF;
458: ) ;
459:
460: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
461: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
462: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
463: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
464: FND_MSG_PUB.Add;
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
459:
460: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
461: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
462: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
463: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
464: FND_MSG_PUB.Add;
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467: END Update_Row;
487: ) ;
488:
489: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
490: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
491: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
492: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
493: FND_MSG_PUB.Add;
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
488:
489: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
490: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
491: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
492: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
493: FND_MSG_PUB.Add;
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496: END IF;
507: ) ;
508:
509: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
510: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
511: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
512: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
508:
509: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
510: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
511: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
512: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;
519: ) ;
520:
521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
523: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
524: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
525: FND_MSG_PUB.Add;
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
520:
521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
523: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
524: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
525: FND_MSG_PUB.Add;
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
543: ) ;
544:
545: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
546: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
547: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
548: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
549: FND_MSG_PUB.Add;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
544:
545: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
546: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
547: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
548: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
549: FND_MSG_PUB.Add;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552: END IF;
563: ) ;
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_POST_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_POST_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: END IF;
576: ) ;
577:
578: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
579: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
580: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
581: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
582: FND_MSG_PUB.Add;
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
577:
578: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
579: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
580: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
581: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
582: FND_MSG_PUB.Add;
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
585:
628: OPEN C;
629: FETCH C INTO Recinfo;
630: If (C%NOTFOUND) then
631: CLOSE C;
632: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
633: APP_EXCEPTION.RAISE_EXCEPTION;
634: End If;
635: CLOSE C;
636: if (
724: AND ( p_ATTRIBUTE15 IS NULL )))
725: ) then
726: return;
727: else
728: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
729: APP_EXCEPTION.RAISE_EXCEPTION;
730: End If;
731: END Lock_Row;
732: