DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_LINES_PKG dependencies on FND_MSG_PUB

Line 178: fnd_msg_pub.add;

174: if l_reservation_id <= 0 then
175: log('create_reservations', 'Error creating reservation');
176: x_return_status := fnd_api.g_ret_sts_error;
177: fnd_message.set_name('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
178: fnd_msg_pub.add;
179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
180: else
181: log('create_reservations', 'Reservation created successfully');
182: if l_req_line_id_to_link is not null and l_req_line_id_to_link > 0 then

Line 179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

175: log('create_reservations', 'Error creating reservation');
176: x_return_status := fnd_api.g_ret_sts_error;
177: fnd_message.set_name('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
178: fnd_msg_pub.add;
179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
180: else
181: log('create_reservations', 'Reservation created successfully');
182: if l_req_line_id_to_link is not null and l_req_line_id_to_link > 0 then
183: log('create_reservations', 'Creating requirement line detail record now...');

Line 560: --FND_MSG_PUB.Add;

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

Line 585: FND_MSG_PUB.Add;

581: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
582: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
583: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
584: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
585: FND_MSG_PUB.Add;
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588: END IF;
589: --dbms_output.put_line('csf_debrief_lines_iuhk ');

Line 600: FND_MSG_PUB.Add;

596: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
597: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
598: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
599: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
600: FND_MSG_PUB.Add;
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: end if;

Line 808: --fnd_msg_pub.add;

804: log('insert_row', 'Reservation creation failed');
805:
806: --fnd_message.set_name('CSF', 'CSF_RESERVATION_FAILED');
807: --fnd_message.set_token('API_NAME', l_api_name_full);
808: --fnd_msg_pub.add;
809: --raise fnd_api.g_exc_unexpected_error;
810:
811: else
812: log('insert_row', 'Reservation created successfully');

Line 832: FND_MSG_PUB.Add;

828: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
829: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
830: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
831: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835: END IF;
836:

Line 854: FND_MSG_PUB.Add;

850: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
851: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
852: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
853: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
854: FND_MSG_PUB.Add;
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;
857: END IF;
858:

Line 867: FND_MSG_PUB.Add;

863: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
864: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
865: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
866: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
867: FND_MSG_PUB.Add;
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: end if;
871: --dbms_output.put_line('END INSERT ROW ');

Line 1222: --FND_MSG_PUB.Add;

1218: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1219: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
1220: --FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
1221: --FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1222: --FND_MSG_PUB.Add;
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225: END IF;
1226:

Line 1244: FND_MSG_PUB.Add;

1240: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1241: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1242: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
1243: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1244: FND_MSG_PUB.Add;
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247: END IF;
1248: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;

Line 1257: FND_MSG_PUB.Add;

1253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1254: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1255: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
1256: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1257: FND_MSG_PUB.Add;
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;
1260:
1261: end if;

Line 1373: FND_MSG_PUB.Add;

1369: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1370: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
1371: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
1372: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1373: FND_MSG_PUB.Add;
1374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1375: END IF;
1376: END IF;
1377:

Line 1395: FND_MSG_PUB.Add;

1391: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1392: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1393: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
1394: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1395: FND_MSG_PUB.Add;
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1398: END IF;
1399:

Line 1408: FND_MSG_PUB.Add;

1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1405: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1406: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
1407: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1408: FND_MSG_PUB.Add;
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411:
1412: end if;

Line 1446: FND_MSG_PUB.Add;

1442: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1443: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
1444: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
1445: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1446: FND_MSG_PUB.Add;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449: END IF;
1450:

Line 1468: FND_MSG_PUB.Add;

1464: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1465: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1466: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
1467: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1468: FND_MSG_PUB.Add;
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471: END IF;
1472: user_hooks_rec.DEBRIEF_LINE_ID := p_DEBRIEF_LINE_ID;

Line 1481: FND_MSG_PUB.Add;

1477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1478: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1479: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
1480: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1481: FND_MSG_PUB.Add;
1482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1483: END IF;
1484:
1485: end if;

Line 1512: FND_MSG_PUB.Add;

1508: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1509: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
1510: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
1511: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515: END IF;
1516:

Line 1534: FND_MSG_PUB.Add;

1530: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1531: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1532: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
1533: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1534: FND_MSG_PUB.Add;
1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1536: END IF;
1537: END IF;
1538:

Line 1547: FND_MSG_PUB.Add;

1543: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1544: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
1545: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
1546: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
1547: FND_MSG_PUB.Add;
1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1549: END IF;
1550: end if;
1551: