DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PKG dependencies on FND_MSG_PUB

Line 120: FND_MSG_PUB.Add;

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

Line 142: FND_MSG_PUB.Add;

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

Line 154: FND_MSG_PUB.Add;

150: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
151: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
152: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
153: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
154: FND_MSG_PUB.Add;
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157: If (l_requirement_header.REQUIREMENT_HEADER_ID IS NULL) OR (l_requirement_header.REQUIREMENT_HEADER_ID = FND_API.G_MISS_NUM) then
158: OPEN C2;

Line 263: FND_MSG_PUB.Add;

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

Line 285: FND_MSG_PUB.Add;

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

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 Vertical 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: END IF;
300: End Insert_Row;

Line 407: FND_MSG_PUB.Add;

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

Line 429: FND_MSG_PUB.Add;

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

Line 441: FND_MSG_PUB.Add;

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

Line 507: FND_MSG_PUB.Add;

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

Line 529: FND_MSG_PUB.Add;

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

Line 540: FND_MSG_PUB.Add;

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

Line 576: FND_MSG_PUB.Add;

572: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
573: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
574: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
575: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
576: FND_MSG_PUB.Add;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579: END IF;
580:

Line 599: FND_MSG_PUB.Add;

595: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
596: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
597: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
598: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
599: FND_MSG_PUB.Add;
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602: END IF;
603: user_hooks_rec.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;

Line 611: FND_MSG_PUB.Add;

607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
608: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
609: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
610: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
611: FND_MSG_PUB.Add;
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614: END IF;
615:

Line 640: FND_MSG_PUB.Add;

636: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
637: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
638: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
639: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
640: FND_MSG_PUB.Add;
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: END IF;
644:

Line 663: FND_MSG_PUB.Add;

659: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
660: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
661: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
662: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
663: FND_MSG_PUB.Add;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666: END IF;
667: csp_requirement_headers_iuhk.delete_requirement_header_post

Line 674: FND_MSG_PUB.Add;

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