DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PKG dependencies on FND_MSG_PUB

Line 110: FND_MSG_PUB.Add;

106: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
107: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
108: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
109: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: END IF;
114:

Line 132: FND_MSG_PUB.Add;

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_VERT_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: END IF;
136:

Line 144: FND_MSG_PUB.Add;

140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
142: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
143: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147: If (l_requirement_header.REQUIREMENT_HEADER_ID IS NULL) OR (l_requirement_header.REQUIREMENT_HEADER_ID = FND_API.G_MISS_NUM) then
148: OPEN C2;

Line 246: FND_MSG_PUB.Add;

242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
244: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
245: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: END IF;
250:

Line 268: FND_MSG_PUB.Add;

264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
265: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
266: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
267: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
268: FND_MSG_PUB.Add;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: END IF;
272: csp_requirement_headers_iuhk.Create_requirement_header_post

Line 279: FND_MSG_PUB.Add;

275: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
276: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
277: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
278: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: End Insert_Row;

Line 380: FND_MSG_PUB.Add;

376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
378: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
379: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383: END IF;
384:

Line 402: FND_MSG_PUB.Add;

398: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
399: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
400: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
401: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
402: FND_MSG_PUB.Add;
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405: END IF;
406: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;

Line 414: FND_MSG_PUB.Add;

410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
412: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
413: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
414: FND_MSG_PUB.Add;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: Update CSP_REQUIREMENT_HEADERS
418: SET

Line 473: FND_MSG_PUB.Add;

469: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
470: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
471: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
472: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
473: FND_MSG_PUB.Add;
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: END IF;
477:

Line 495: FND_MSG_PUB.Add;

491: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
492: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
493: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
494: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: END IF;
499: csp_requirement_headers_iuhk.update_requirement_header_post

Line 506: FND_MSG_PUB.Add;

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

Line 534: FND_MSG_PUB.Add;

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

Line 557: FND_MSG_PUB.Add;

553: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
554: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
555: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
556: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
557: FND_MSG_PUB.Add;
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END IF;
560: END IF;
561: user_hooks_rec.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;

Line 569: FND_MSG_PUB.Add;

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_PRE_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: DELETE FROM CSP_REQUIREMENT_HEADERS
573: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID;

Line 592: FND_MSG_PUB.Add;

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

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_POST_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: csp_requirement_headers_iuhk.delete_requirement_header_post

Line 626: FND_MSG_PUB.Add;

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