DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_PKG dependencies on FND_MSG_PUB

Line 117: FND_MSG_PUB.Add;

113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
114: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
115: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
116: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
117: FND_MSG_PUB.Add;
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120: END IF;
121:

Line 139: FND_MSG_PUB.Add;

135: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
136: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
137: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
138: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
139: FND_MSG_PUB.Add;
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: END IF;
143: csp_requirement_lines_iuhk.Create_requirement_line_Pre

Line 150: FND_MSG_PUB.Add;

146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
148: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
149: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
150: FND_MSG_PUB.Add;
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153: If (l_requirement_line.REQUIREMENT_LINE_ID IS NULL) OR (l_requirement_line.REQUIREMENT_LINE_ID = FND_API.G_MISS_NUM) then
154: OPEN C2;

Line 262: FND_MSG_PUB.Add;

258: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
259: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
260: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
261: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: END IF;
266:

Line 284: FND_MSG_PUB.Add;

280: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
281: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
282: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
283: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
284: FND_MSG_PUB.Add;
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287: END IF;
288: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;

Line 296: FND_MSG_PUB.Add;

292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
293: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
294: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
295: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END IF;
299:
300: End Insert_Row;

Line 406: FND_MSG_PUB.Add;

402: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
403: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
404: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
405: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
406: FND_MSG_PUB.Add;
407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
408: END IF;
409: END IF;
410:

Line 428: FND_MSG_PUB.Add;

424: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
425: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
426: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
427: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
428: FND_MSG_PUB.Add;
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: END IF;
432: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;

Line 440: FND_MSG_PUB.Add;

436: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
437: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
438: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
439: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
440: FND_MSG_PUB.Add;
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443:
444: Update CSP_REQUIREMENT_LINES

Line 504: FND_MSG_PUB.Add;

500: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
501: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
502: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
503: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
504: FND_MSG_PUB.Add;
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507: END IF;
508:

Line 525: FND_MSG_PUB.Add;

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_POST_VERT_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: END IF;
529: csp_requirement_lines_iuhk.update_requirement_line_post

Line 536: FND_MSG_PUB.Add;

532: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
533: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
534: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
535: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
536: FND_MSG_PUB.Add;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539:
540: END Update_Row;

Line 564: FND_MSG_PUB.Add;

560: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
561: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
562: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
563: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566: END IF;
567: END IF;
568:

Line 586: FND_MSG_PUB.Add;

582: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
583: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
584: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
585: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
588: END IF;
589: END IF;
590: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;

Line 598: FND_MSG_PUB.Add;

594: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
596: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
597: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601:
602: DELETE FROM CSP_REQUIREMENT_LINES

Line 621: FND_MSG_PUB.Add;

617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
618: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
619: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
620: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
621: FND_MSG_PUB.Add;
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624: END IF;
625:

Line 643: FND_MSG_PUB.Add;

639: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
640: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
641: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
642: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
643: FND_MSG_PUB.Add;
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: END IF;
646: END IF;
647: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;

Line 655: FND_MSG_PUB.Add;

651: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
652: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
653: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
654: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
655: FND_MSG_PUB.Add;
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659: END Delete_Row;