DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_PKG dependencies on FND_MSG_PUB

Line 125: FND_MSG_PUB.Add;

121: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
122: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
123: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
124: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
125: FND_MSG_PUB.Add;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: END IF;
129:

Line 147: FND_MSG_PUB.Add;

143: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
144: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
145: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
146: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
147: FND_MSG_PUB.Add;
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150: END IF;
151: csp_requirement_lines_iuhk.Create_requirement_line_Pre

Line 158: FND_MSG_PUB.Add;

154: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
155: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
156: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_INT_CUST_USR_HK');
157: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
158: FND_MSG_PUB.Add;
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161: If (l_requirement_line.REQUIREMENT_LINE_ID IS NULL) OR (l_requirement_line.REQUIREMENT_LINE_ID = FND_API.G_MISS_NUM) then
162: OPEN C2;

Line 275: FND_MSG_PUB.Add;

271: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
272: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
273: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
274: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278: END IF;
279:

Line 297: FND_MSG_PUB.Add;

293: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
294: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
295: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
296: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
297: FND_MSG_PUB.Add;
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300: END IF;
301: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;

Line 309: FND_MSG_PUB.Add;

305: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
306: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
307: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
308: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
309: FND_MSG_PUB.Add;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: END IF;
313: End Insert_Row;

Line 425: FND_MSG_PUB.Add;

421: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
422: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
423: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_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:

Line 447: FND_MSG_PUB.Add;

443: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
444: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
445: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
446: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
447: FND_MSG_PUB.Add;
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450: END IF;
451: user_hook_rec.REQUIREMENT_LINE_ID := l_requirement_line.REQUIREMENT_LINE_ID;

Line 459: FND_MSG_PUB.Add;

455: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
456: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
457: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
458: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
459: FND_MSG_PUB.Add;
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: END IF;
463: IF l_dml_mode = 'BOTH' THEN

Line 527: FND_MSG_PUB.Add;

523: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
524: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
525: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
526: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
527: FND_MSG_PUB.Add;
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: END IF;
531:

Line 548: FND_MSG_PUB.Add;

544: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
545: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
546: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
547: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: END IF;
551: END IF;
552: csp_requirement_lines_iuhk.update_requirement_line_post

Line 559: FND_MSG_PUB.Add;

555: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
556: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
557: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
558: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
559: FND_MSG_PUB.Add;
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562: END IF;
563: END Update_Row;

Line 593: FND_MSG_PUB.Add;

589: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
590: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
591: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
592: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
593: FND_MSG_PUB.Add;
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596: END IF;
597:

Line 615: FND_MSG_PUB.Add;

611: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
612: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
613: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
614: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618: END IF;
619: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;

Line 627: FND_MSG_PUB.Add;

623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
624: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
625: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
626: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630: END IF;
631: IF l_dml_mode = 'BOTH' THEN

Line 654: FND_MSG_PUB.Add;

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

Line 676: FND_MSG_PUB.Add;

672: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
673: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
674: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
675: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
676: FND_MSG_PUB.Add;
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;
679: END IF;
680: user_hook_rec.REQUIREMENT_LINE_ID := p_REQUIREMENT_LINE_ID;

Line 688: FND_MSG_PUB.Add;

684: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
685: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
686: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
687: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
688: FND_MSG_PUB.Add;
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
690: END IF;
691: END IF;
692: END Delete_Row;