eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_SCH_INT_PVT dependencies on FND_MSG_PUB

Line 301: FND_MSG_PUB.ADD;

297: x_return_status := FND_API.G_RET_STS_ERROR;
298: l_del_date := to_char(g_earliest_delivery_date,'MM-DD-YYYY HH24:MI:SS');
299: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEL');
300: FND_MESSAGE.SET_TOKEN('DDATE', l_del_date, TRUE);
301: FND_MSG_PUB.ADD;
302: fnd_msg_pub.count_and_get
303: ( p_count => x_msg_count
304: , p_data => x_msg_data);
305: END IF;*/

Line 302: fnd_msg_pub.count_and_get

298: l_del_date := to_char(g_earliest_delivery_date,'MM-DD-YYYY HH24:MI:SS');
299: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEL');
300: FND_MESSAGE.SET_TOKEN('DDATE', l_del_date, TRUE);
301: FND_MSG_PUB.ADD;
302: fnd_msg_pub.count_and_get
303: ( p_count => x_msg_count
304: , p_data => x_msg_data);
305: END IF;*/
306: END IF;

Line 310: FND_MSG_PUB.ADD;

306: END IF;
307: ELSE
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NO_PARTS');
310: FND_MSG_PUB.ADD;
311: fnd_msg_pub.count_and_get
312: ( p_count => x_msg_count
313: , p_data => x_msg_data);
314: END IF;

Line 311: fnd_msg_pub.count_and_get

307: ELSE
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NO_PARTS');
310: FND_MSG_PUB.ADD;
311: fnd_msg_pub.count_and_get
312: ( p_count => x_msg_count
313: , p_data => x_msg_data);
314: END IF;
315: ELSE

Line 329: FND_MSG_PUB.ADD;

325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
327: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
328: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
329: FND_MSG_PUB.ADD;
330: fnd_msg_pub.count_and_get
331: ( p_count => x_msg_count
332: , p_data => x_msg_data);
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 330: fnd_msg_pub.count_and_get

326: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
327: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
328: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
329: FND_MSG_PUB.ADD;
330: fnd_msg_pub.count_and_get
331: ( p_count => x_msg_count
332: , p_data => x_msg_data);
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: return;

Line 473: FND_MSG_PUB.ADD;

469: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_eligible_resources_list,l_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
470: ELSE
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
473: FND_MSG_PUB.ADD;
474: fnd_msg_pub.count_and_get
475: ( p_count => x_msg_count
476: , p_data => x_msg_data);
477: return;

Line 474: fnd_msg_pub.count_and_get

470: ELSE
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
473: FND_MSG_PUB.ADD;
474: fnd_msg_pub.count_and_get
475: ( p_count => x_msg_count
476: , p_data => x_msg_data);
477: return;
478: END IF;

Line 495: FND_MSG_PUB.ADD;

491: END LOOP;
492: IF l_temp_options.count = 0 then
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
495: FND_MSG_PUB.ADD;
496: fnd_msg_pub.count_and_get
497: ( p_count => x_msg_count
498: , p_data => x_msg_data);
499: return;

Line 496: fnd_msg_pub.count_and_get

492: IF l_temp_options.count = 0 then
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
495: FND_MSG_PUB.ADD;
496: fnd_msg_pub.count_and_get
497: ( p_count => x_msg_count
498: , p_data => x_msg_data);
499: return;
500: END IF;

Line 619: FND_MSG_PUB.ADD;

615: IF l_reservation_id <= 0 THEN
616: ROLLBACK TO choose_options;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get
621: ( p_count => x_msg_count
622: , p_data => x_msg_data);
623: return;

Line 620: fnd_msg_pub.count_and_get

616: ROLLBACK TO choose_options;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get
621: ( p_count => x_msg_count
622: , p_data => x_msg_data);
623: return;
624: END IF;

Line 673: FND_MSG_PUB.ADD;

669: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
670: ROLLBACK TO CHOOSE_OPTIONS;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
673: FND_MSG_PUB.ADD;
674: fnd_msg_pub.count_and_get
675: ( p_count => x_msg_count
676: , p_data => x_msg_data);
677: return;

Line 674: fnd_msg_pub.count_and_get

670: ROLLBACK TO CHOOSE_OPTIONS;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
673: FND_MSG_PUB.ADD;
674: fnd_msg_pub.count_and_get
675: ( p_count => x_msg_count
676: , p_data => x_msg_data);
677: return;
678: ELSE

Line 745: FND_MSG_PUB.ADD;

741: ROLLBACK TO choose_options;
742: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
743: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
744: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
745: FND_MSG_PUB.ADD;
746: fnd_msg_pub.count_and_get
747: ( p_count => x_msg_count
748: , p_data => x_msg_data);
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 746: fnd_msg_pub.count_and_get

742: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
743: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
744: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
745: FND_MSG_PUB.ADD;
746: fnd_msg_pub.count_and_get
747: ( p_count => x_msg_count
748: , p_data => x_msg_data);
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: END CHOOSE_OPTION;

Line 806: FND_MSG_PUB.ADD;

802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
803: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_RESERV');
806: FND_MSG_PUB.ADD;
807: fnd_msg_pub.count_and_get
808: ( p_count => x_msg_count
809: , p_data => x_msg_data);
810: exit;

Line 807: fnd_msg_pub.count_and_get

803: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_RESERV');
806: FND_MSG_PUB.ADD;
807: fnd_msg_pub.count_and_get
808: ( p_count => x_msg_count
809: , p_data => x_msg_data);
810: exit;
811: ELSE

Line 859: FND_MSG_PUB.ADD;

855: END IF;
856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
859: FND_MSG_PUB.ADD;
860: fnd_msg_pub.count_and_get
861: ( p_count => x_msg_count
862: , p_data => x_msg_data);
863: exit;

Line 860: fnd_msg_pub.count_and_get

856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
859: FND_MSG_PUB.ADD;
860: fnd_msg_pub.count_and_get
861: ( p_count => x_msg_count
862: , p_data => x_msg_data);
863: exit;
864: ELSE

Line 910: FND_MSG_PUB.ADD;

906: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
907: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
908: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
909: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
910: FND_MSG_PUB.ADD;
911: fnd_msg_pub.count_and_get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data);
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 911: fnd_msg_pub.count_and_get

907: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
908: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
909: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
910: FND_MSG_PUB.ADD;
911: fnd_msg_pub.count_and_get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data);
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915:

Line 1079: FND_MSG_PUB.ADD;

1075: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
1076: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1077: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1078: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1079: FND_MSG_PUB.ADD;
1080: fnd_msg_pub.count_and_get
1081: ( p_count => x_msg_count
1082: , p_data => x_msg_data);
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1080: fnd_msg_pub.count_and_get

1076: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1077: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1078: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1079: FND_MSG_PUB.ADD;
1080: fnd_msg_pub.count_and_get
1081: ( p_count => x_msg_count
1082: , p_data => x_msg_data);
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084:

Line 1114: FND_MSG_PUB.ADD;

1110: WHEN OTHERS THEN
1111: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1112: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1113: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1114: FND_MSG_PUB.ADD;
1115: fnd_msg_pub.count_and_get
1116: ( p_count => x_msg_count
1117: , p_data => x_msg_data);
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1115: fnd_msg_pub.count_and_get

1111: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1112: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1113: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1114: FND_MSG_PUB.ADD;
1115: fnd_msg_pub.count_and_get
1116: ( p_count => x_msg_count
1117: , p_data => x_msg_data);
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: END CANCEL_ORDER;

Line 1177: FND_MSG_PUB.ADD;

1173: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1174: ROLLBACK TO CREATE_ORDERS;
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1177: FND_MSG_PUB.ADD;
1178: fnd_msg_pub.count_and_get
1179: ( p_count => x_msg_count
1180: , p_data => x_msg_data);
1181: exit;

Line 1178: fnd_msg_pub.count_and_get

1174: ROLLBACK TO CREATE_ORDERS;
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1177: FND_MSG_PUB.ADD;
1178: fnd_msg_pub.count_and_get
1179: ( p_count => x_msg_count
1180: , p_data => x_msg_data);
1181: exit;
1182: END IF;

Line 1370: FND_MSG_PUB.ADD;

1366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1367: ROLLBACK TO CREATE_ORDERS;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1370: FND_MSG_PUB.ADD;
1371: fnd_msg_pub.count_and_get
1372: ( p_count => x_msg_count
1373: , p_data => x_msg_data);
1374: return;

Line 1371: fnd_msg_pub.count_and_get

1367: ROLLBACK TO CREATE_ORDERS;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1370: FND_MSG_PUB.ADD;
1371: fnd_msg_pub.count_and_get
1372: ( p_count => x_msg_count
1373: , p_data => x_msg_data);
1374: return;
1375: ELSE

Line 1415: FND_MSG_PUB.ADD;

1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1413: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1414: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1415: FND_MSG_PUB.ADD;
1416: fnd_msg_pub.count_and_get
1417: ( p_count => x_msg_count
1418: , p_data => x_msg_data);
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1416: fnd_msg_pub.count_and_get

1412: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1413: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1414: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1415: FND_MSG_PUB.ADD;
1416: fnd_msg_pub.count_and_get
1417: ( p_count => x_msg_count
1418: , p_data => x_msg_data);
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1420: END CREATE_ORDERS;*/

Line 1469: FND_MSG_PUB.ADD;

1465: l_resource_name := csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id);
1466: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1467: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
1468: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
1469: FND_MSG_PUB.ADD;
1470: fnd_msg_pub.count_and_get( p_count => x_msg_count
1471: , p_data => x_msg_data);
1472: -- x_msg_data := 'Default organization and subinventory not defined for ' || l_resource_type_name || ' ' || l_resource_name ;
1473: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1470: fnd_msg_pub.count_and_get( p_count => x_msg_count

1466: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1467: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
1468: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
1469: FND_MSG_PUB.ADD;
1470: fnd_msg_pub.count_and_get( p_count => x_msg_count
1471: , p_data => x_msg_data);
1472: -- x_msg_data := 'Default organization and subinventory not defined for ' || l_resource_type_name || ' ' || l_resource_name ;
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: return;

Line 1488: FND_MSG_PUB.ADD;

1484: WHEN OTHERS THEN
1485: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1486: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1487: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm,FALSE);
1488: FND_MSG_PUB.ADD;
1489: fnd_msg_pub.count_and_get
1490: ( p_count => x_msg_count
1491: , p_data => x_msg_data);
1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1489: fnd_msg_pub.count_and_get

1485: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1486: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1487: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm,FALSE);
1488: FND_MSG_PUB.ADD;
1489: fnd_msg_pub.count_and_get
1490: ( p_count => x_msg_count
1491: , p_data => x_msg_data);
1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1493: END GET_ORGANIZATION_SUBINV;

Line 1545: FND_MSG_PUB.ADD;

1541: WHEN OTHERS THEN
1542: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1543: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1544: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1545: FND_MSG_PUB.ADD;
1546: fnd_msg_pub.count_and_get
1547: ( p_count => x_msg_count
1548: , p_data => x_msg_data);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1546: fnd_msg_pub.count_and_get

1542: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1543: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1544: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1545: FND_MSG_PUB.ADD;
1546: fnd_msg_pub.count_and_get
1547: ( p_count => x_msg_count
1548: , p_data => x_msg_data);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: return;

Line 1711: FND_MSG_PUB.ADD;

1707: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
1708:
1709: IF l_reservation_id <= 0 THEN
1710: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1711: FND_MSG_PUB.ADD;
1712: fnd_msg_pub.count_and_get
1713: ( p_count => x_msg_count
1714: , p_data => x_msg_data);
1715: else

Line 1712: fnd_msg_pub.count_and_get

1708:
1709: IF l_reservation_id <= 0 THEN
1710: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1711: FND_MSG_PUB.ADD;
1712: fnd_msg_pub.count_and_get
1713: ( p_count => x_msg_count
1714: , p_data => x_msg_data);
1715: else
1716: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 1746: FND_MSG_PUB.ADD;

1742: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
1743:
1744: IF l_reservation_id <= 0 THEN
1745: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1746: FND_MSG_PUB.ADD;
1747: fnd_msg_pub.count_and_get
1748: ( p_count => x_msg_count
1749: , p_data => x_msg_data);
1750: else

Line 1747: fnd_msg_pub.count_and_get

1743:
1744: IF l_reservation_id <= 0 THEN
1745: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1746: FND_MSG_PUB.ADD;
1747: fnd_msg_pub.count_and_get
1748: ( p_count => x_msg_count
1749: , p_data => x_msg_data);
1750: else
1751: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 1819: FND_MSG_PUB.ADD;

1815: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
1816:
1817: IF l_reservation_id <= 0 THEN
1818: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1819: FND_MSG_PUB.ADD;
1820: fnd_msg_pub.count_and_get
1821: ( p_count => x_msg_count
1822: , p_data => x_msg_data);
1823: else

Line 1820: fnd_msg_pub.count_and_get

1816:
1817: IF l_reservation_id <= 0 THEN
1818: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1819: FND_MSG_PUB.ADD;
1820: fnd_msg_pub.count_and_get
1821: ( p_count => x_msg_count
1822: , p_data => x_msg_data);
1823: else
1824: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 1856: FND_MSG_PUB.ADD;

1852: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
1853:
1854: IF l_reservation_id <= 0 THEN
1855: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1856: FND_MSG_PUB.ADD;
1857: fnd_msg_pub.count_and_get
1858: ( p_count => x_msg_count
1859: , p_data => x_msg_data);
1860: else

Line 1857: fnd_msg_pub.count_and_get

1853:
1854: IF l_reservation_id <= 0 THEN
1855: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
1856: FND_MSG_PUB.ADD;
1857: fnd_msg_pub.count_and_get
1858: ( p_count => x_msg_count
1859: , p_data => x_msg_data);
1860: else
1861: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 1909: FND_MSG_PUB.ADD;

1905: WHEN OTHERS THEN
1906: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1907: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1908: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1909: FND_MSG_PUB.ADD;
1910: fnd_msg_pub.count_and_get
1911: ( p_count => x_msg_count
1912: , p_data => x_msg_data);
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1910: fnd_msg_pub.count_and_get

1906: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1907: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1908: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1909: FND_MSG_PUB.ADD;
1910: fnd_msg_pub.count_and_get
1911: ( p_count => x_msg_count
1912: , p_data => x_msg_data);
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1914: return;

Line 2038: l_msg := FND_MSG_PUB.Get(1,FND_API.G_FALSE) ;

2034: l_atp_details,
2035: x_return_status,
2036: x_msg_data,
2037: x_msg_count);
2038: l_msg := FND_MSG_PUB.Get(1,FND_API.G_FALSE) ;
2039:
2040: rollback to csp_msc_atp_check;
2041: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2042: l_unavailable := 'Y';

Line 2058: FND_MSG_PUB.ADD;

2054: CLOSE error_message;
2055:
2056: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2057: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2058: FND_MSG_PUB.ADD;
2059: fnd_msg_pub.count_and_get
2060: ( p_count => x_msg_count
2061: , p_data => x_msg_data);
2062:

Line 2059: fnd_msg_pub.count_and_get

2055:
2056: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2057: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2058: FND_MSG_PUB.ADD;
2059: fnd_msg_pub.count_and_get
2060: ( p_count => x_msg_count
2061: , p_data => x_msg_data);
2062:
2063: END IF;

Line 2076: FND_MSG_PUB.ADD;

2072: l_error := true;
2073: l_message := l_item_segments || ' : '|| l_message;
2074: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2075: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2076: FND_MSG_PUB.ADD;
2077: fnd_msg_pub.count_and_get
2078: ( p_count => x_msg_count
2079: , p_data => x_msg_data);
2080: END IF;

Line 2077: fnd_msg_pub.count_and_get

2073: l_message := l_item_segments || ' : '|| l_message;
2074: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2075: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2076: FND_MSG_PUB.ADD;
2077: fnd_msg_pub.count_and_get
2078: ( p_count => x_msg_count
2079: , p_data => x_msg_data);
2080: END IF;
2081: ELSE

Line 2090: FND_MSG_PUB.ADD;

2086: CLOSE error_message;
2087:
2088: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2089: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2090: FND_MSG_PUB.ADD;
2091: fnd_msg_pub.count_and_get
2092: ( p_count => x_msg_count
2093: , p_data => x_msg_data);
2094:

Line 2091: fnd_msg_pub.count_and_get

2087:
2088: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2089: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2090: FND_MSG_PUB.ADD;
2091: fnd_msg_pub.count_and_get
2092: ( p_count => x_msg_count
2093: , p_data => x_msg_data);
2094:
2095: END IF;

Line 2108: FND_MSG_PUB.ADD;

2104: l_error := true;
2105: l_message := l_item_segments || ' : '|| l_message;
2106: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2107: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2108: FND_MSG_PUB.ADD;
2109: fnd_msg_pub.count_and_get
2110: ( p_count => x_msg_count
2111: , p_data => x_msg_data);
2112: ELSE

Line 2109: fnd_msg_pub.count_and_get

2105: l_message := l_item_segments || ' : '|| l_message;
2106: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
2107: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
2108: FND_MSG_PUB.ADD;
2109: fnd_msg_pub.count_and_get
2110: ( p_count => x_msg_count
2111: , p_data => x_msg_data);
2112: ELSE
2113: l_unavailable := 'N';

Line 2198: FND_MSG_PUB.ADD;

2194: WHEN OTHERS THEN
2195: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2196: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2197: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2198: FND_MSG_PUB.ADD;
2199: fnd_msg_pub.count_and_get
2200: ( p_count => x_msg_count
2201: , p_data => x_msg_data);
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2199: fnd_msg_pub.count_and_get

2195: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2196: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2197: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2198: FND_MSG_PUB.ADD;
2199: fnd_msg_pub.count_and_get
2200: ( p_count => x_msg_count
2201: , p_data => x_msg_data);
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: return;

Line 2255: FND_MSG_PUB.ADD;

2251: WHEN OTHERS THEN
2252: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2253: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2254: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2255: FND_MSG_PUB.ADD;
2256: fnd_msg_pub.count_and_get
2257: ( p_count => x_msg_count
2258: , p_data => x_msg_data);
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2256: fnd_msg_pub.count_and_get

2252: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2253: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2254: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2255: FND_MSG_PUB.ADD;
2256: fnd_msg_pub.count_and_get
2257: ( p_count => x_msg_count
2258: , p_data => x_msg_data);
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2260: return;

Line 2375: FND_MSG_PUB.ADD;

2371: WHEN OTHERS THEN
2372: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2373: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2374: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2375: FND_MSG_PUB.ADD;
2376: fnd_msg_pub.count_and_get
2377: ( p_count => x_msg_count
2378: , p_data => x_msg_data);
2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2376: fnd_msg_pub.count_and_get

2372: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2373: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2374: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2375: FND_MSG_PUB.ADD;
2376: fnd_msg_pub.count_and_get
2377: ( p_count => x_msg_count
2378: , p_data => x_msg_data);
2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2380: return;

Line 2415: FND_MSG_PUB.ADD;

2411: WHEN OTHERS THEN
2412: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2413: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2414: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2415: FND_MSG_PUB.ADD;
2416: fnd_msg_pub.count_and_get
2417: ( p_count => x_msg_count
2418: , p_data => x_msg_data);
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2416: fnd_msg_pub.count_and_get

2412: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2413: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2414: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2415: FND_MSG_PUB.ADD;
2416: fnd_msg_pub.count_and_get
2417: ( p_count => x_msg_count
2418: , p_data => x_msg_data);
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2420: return;

Line 2799: FND_MSG_PUB.ADD;

2795: WHEN OTHERS THEN
2796: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2797: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2798: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2799: FND_MSG_PUB.ADD;
2800: fnd_msg_pub.count_and_get
2801: ( p_count => x_msg_count
2802: , p_data => x_msg_data);
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2800: fnd_msg_pub.count_and_get

2796: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2797: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2798: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2799: FND_MSG_PUB.ADD;
2800: fnd_msg_pub.count_and_get
2801: ( p_count => x_msg_count
2802: , p_data => x_msg_data);
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2804: return;

Line 2861: FND_MSG_PUB.ADD;

2857: WHEN OTHERS THEN
2858: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2859: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2860: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2861: FND_MSG_PUB.ADD;
2862: fnd_msg_pub.count_and_get
2863: ( p_count => x_msg_count
2864: , p_data => x_msg_data);
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2862: fnd_msg_pub.count_and_get

2858: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2859: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2860: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2861: FND_MSG_PUB.ADD;
2862: fnd_msg_pub.count_and_get
2863: ( p_count => x_msg_count
2864: , p_data => x_msg_data);
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: return;

Line 3222: FND_MSG_PUB.ADD;

3218: CLOSE get_organization_code;
3219: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_SHIPMETHOD_NOT_DEFINED');
3220: FND_MESSAGE.SET_TOKEN('FROM_ORG', l_from_org_code, TRUE);
3221: FND_MESSAGE.SET_TOKEN('TO_ORG', l_to_org_code, TRUE);
3222: FND_MSG_PUB.ADD;
3223: fnd_msg_pub.count_and_get
3224: ( p_count => x_msg_count
3225: , p_data => x_msg_data);
3226: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3223: fnd_msg_pub.count_and_get

3219: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_SHIPMETHOD_NOT_DEFINED');
3220: FND_MESSAGE.SET_TOKEN('FROM_ORG', l_from_org_code, TRUE);
3221: FND_MESSAGE.SET_TOKEN('TO_ORG', l_to_org_code, TRUE);
3222: FND_MSG_PUB.ADD;
3223: fnd_msg_pub.count_and_get
3224: ( p_count => x_msg_count
3225: , p_data => x_msg_data);
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: return;

Line 3249: FND_MSG_PUB.ADD;

3245: WHEN OTHERS THEN
3246: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3247: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
3248: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
3249: FND_MSG_PUB.ADD;
3250: fnd_msg_pub.count_and_get
3251: ( p_count => x_msg_count
3252: , p_data => x_msg_data);
3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3250: fnd_msg_pub.count_and_get

3246: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3247: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
3248: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
3249: FND_MSG_PUB.ADD;
3250: fnd_msg_pub.count_and_get
3251: ( p_count => x_msg_count
3252: , p_data => x_msg_data);
3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3254: return;

Line 3325: FND_MSG_PUB.ADD;

3321: WHEN OTHERS THEN
3322: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3323: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3324: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3325: FND_MSG_PUB.ADD;
3326: fnd_msg_pub.count_and_get
3327: ( p_count => x_msg_count
3328: , p_data => x_msg_data);
3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3326: fnd_msg_pub.count_and_get

3322: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3323: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3324: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3325: FND_MSG_PUB.ADD;
3326: fnd_msg_pub.count_and_get
3327: ( p_count => x_msg_count
3328: , p_data => x_msg_data);
3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3330: return;

Line 3524: FND_MSG_PUB.ADD;

3520: END IF;
3521: EXCEPTION
3522: WHEN NO_DATA_FOUND THEN
3523: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');
3524: FND_MSG_PUB.ADD;
3525: fnd_msg_pub.count_and_get
3526: ( p_count => x_msg_count
3527: , p_data => x_msg_data);
3528: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3525: fnd_msg_pub.count_and_get

3521: EXCEPTION
3522: WHEN NO_DATA_FOUND THEN
3523: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');
3524: FND_MSG_PUB.ADD;
3525: fnd_msg_pub.count_and_get
3526: ( p_count => x_msg_count
3527: , p_data => x_msg_data);
3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: return 0;

Line 3683: FND_MSG_PUB.ADD;

3679: WHEN OTHERS THEN
3680: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3681: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3682: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3683: FND_MSG_PUB.ADD;
3684: fnd_msg_pub.count_and_get
3685: ( p_count => x_msg_count
3686: , p_data => x_msg_data);
3687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3684: fnd_msg_pub.count_and_get

3680: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3681: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3682: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3683: FND_MSG_PUB.ADD;
3684: fnd_msg_pub.count_and_get
3685: ( p_count => x_msg_count
3686: , p_data => x_msg_data);
3687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3688: return;

Line 3844: fnd_msg_pub.initialize;

3840: l_primary_uom_code varchar2(10);
3841:
3842: BEGIN
3843: g_schedular_call := 'N';
3844: fnd_msg_pub.initialize;
3845: IF p_timezone_id is not null THEN
3846: g_shipto_timezone_id := p_timezone_id;
3847: END IF;
3848: l_resources := CSP_SCH_INT_PVT.csp_sch_resource_tbl_typ();

Line 3987: FND_MSG_PUB.ADD;

3983:
3984: IF l_reservation_id <= 0 THEN
3985: x_return_status := FND_API.G_RET_STS_ERROR;
3986: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
3987: FND_MSG_PUB.ADD;
3988: fnd_msg_pub.count_and_get
3989: ( p_count => x_msg_count
3990: , p_data => x_msg_data);
3991: else

Line 3988: fnd_msg_pub.count_and_get

3984: IF l_reservation_id <= 0 THEN
3985: x_return_status := FND_API.G_RET_STS_ERROR;
3986: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
3987: FND_MSG_PUB.ADD;
3988: fnd_msg_pub.count_and_get
3989: ( p_count => x_msg_count
3990: , p_data => x_msg_data);
3991: else
3992: l_res_ids(l_res_ids.count+1) := l_reservation_id ;

Line 4118: FND_MSG_PUB.ADD;

4114:
4115: IF l_reservation_id <= 0 THEN
4116: x_return_status := FND_API.G_RET_STS_ERROR;
4117: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
4118: FND_MSG_PUB.ADD;
4119: fnd_msg_pub.count_and_get
4120: ( p_count => x_msg_count
4121: , p_data => x_msg_data);
4122: else

Line 4119: fnd_msg_pub.count_and_get

4115: IF l_reservation_id <= 0 THEN
4116: x_return_status := FND_API.G_RET_STS_ERROR;
4117: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
4118: FND_MSG_PUB.ADD;
4119: fnd_msg_pub.count_and_get
4120: ( p_count => x_msg_count
4121: , p_data => x_msg_data);
4122: else
4123: l_res_ids(l_res_ids.count+1) := l_reservation_id ;

Line 4240: FND_MSG_PUB.ADD;

4236: END IF;
4237: END LOOP;
4238: IF not l_atleast_one_rec_per_line THEN
4239: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');
4240: FND_MSG_PUB.ADD;
4241: fnd_msg_pub.count_and_get
4242: ( p_count => x_msg_count
4243: , p_data => x_msg_data);
4244: END IF;

Line 4241: fnd_msg_pub.count_and_get

4237: END LOOP;
4238: IF not l_atleast_one_rec_per_line THEN
4239: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');
4240: FND_MSG_PUB.ADD;
4241: fnd_msg_pub.count_and_get
4242: ( p_count => x_msg_count
4243: , p_data => x_msg_data);
4244: END IF;
4245: END LOOP;

Line 4439: FND_MSG_PUB.ADD;

4435: WHEN OTHERS THEN
4436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4439: FND_MSG_PUB.ADD;
4440: fnd_msg_pub.count_and_get
4441: ( p_count => x_msg_count
4442: , p_data => x_msg_data);
4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4440: fnd_msg_pub.count_and_get

4436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4439: FND_MSG_PUB.ADD;
4440: fnd_msg_pub.count_and_get
4441: ( p_count => x_msg_count
4442: , p_data => x_msg_data);
4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4444: return;

Line 4520: FND_MSG_PUB.ADD;

4516: WHEN OTHERS THEN
4517: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4518: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4519: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4520: FND_MSG_PUB.ADD;
4521: fnd_msg_pub.count_and_get
4522: ( p_count => x_msg_count
4523: , p_data => x_msg_data);
4524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4521: fnd_msg_pub.count_and_get

4517: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4518: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4519: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4520: FND_MSG_PUB.ADD;
4521: fnd_msg_pub.count_and_get
4522: ( p_count => x_msg_count
4523: , p_data => x_msg_data);
4524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4525: return;

Line 5155: FND_MSG_PUB.ADD;

5151: END IF;
5152: END LOOP;
5153: IF not l_atleast_one_rec THEN
5154: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');
5155: FND_MSG_PUB.ADD;
5156: fnd_msg_pub.count_and_get
5157: ( p_count => x_msg_count
5158: , p_data => x_msg_data);
5159: END IF;

Line 5156: fnd_msg_pub.count_and_get

5152: END LOOP;
5153: IF not l_atleast_one_rec THEN
5154: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');
5155: FND_MSG_PUB.ADD;
5156: fnd_msg_pub.count_and_get
5157: ( p_count => x_msg_count
5158: , p_data => x_msg_data);
5159: END IF;
5160: END IF;

Line 5784: FND_MSG_PUB.ADD;

5780: , l_serial_number);
5781: EXCEPTION
5782: WHEN NO_DATA_FOUND THEN
5783: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');
5784: FND_MSG_PUB.ADD;
5785: fnd_msg_pub.count_and_get
5786: ( p_count => x_msg_count
5787: , p_data => x_msg_data);
5788: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5785: fnd_msg_pub.count_and_get

5781: EXCEPTION
5782: WHEN NO_DATA_FOUND THEN
5783: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');
5784: FND_MSG_PUB.ADD;
5785: fnd_msg_pub.count_and_get
5786: ( p_count => x_msg_count
5787: , p_data => x_msg_data);
5788: x_return_status := FND_API.G_RET_STS_ERROR;
5789: WHEN OTHERS THEN