DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on FND_MESSAGE

Line 299: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEL');

295: /*ELSE
296: IF x_options.count = 0 THEN
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

Line 300: FND_MESSAGE.SET_TOKEN('DDATE', l_del_date, TRUE);

296: IF x_options.count = 0 THEN
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);

Line 309: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NO_PARTS');

305: END IF;*/
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);

Line 326: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

322: END LOOP;
323: END IF;
324: EXCEPTION
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

Line 327: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

323: END IF;
324: EXCEPTION
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

Line 328: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

324: EXCEPTION
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);

Line 472: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');

468: --CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,l_options,x_return_status);
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);

Line 494: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');

490: END IF;
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);

Line 618: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');

614: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
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);

Line 672: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');

668: END IF;
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);

Line 742: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

738: END IF;
739: EXCEPTION
740: WHEN OTHERS THEN
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

Line 743: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

739: EXCEPTION
740: WHEN OTHERS THEN
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

Line 744: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

740: WHEN OTHERS THEN
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);

Line 805: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_RESERV');

801: END IF;
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);

Line 858: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

854: x_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 907: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

903: END IF;
904: EXCEPTION
905: WHEN OTHERS THEN
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

Line 908: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

904: EXCEPTION
905: WHEN OTHERS THEN
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

Line 909: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

905: WHEN OTHERS THEN
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);

Line 1076: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1072: ,l_serial_number);
1073: EXCEPTION
1074: WHEN OTHERS THEN
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

Line 1077: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1073: EXCEPTION
1074: WHEN OTHERS THEN
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

Line 1078: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

1074: WHEN OTHERS THEN
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);

Line 1111: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1107: ,x_msg_data => x_msg_data
1108: );
1109: EXCEPTION
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

Line 1112: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1108: );
1109: EXCEPTION
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

Line 1113: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

1109: EXCEPTION
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);

Line 1176: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');

1172: );
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);

Line 1369: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');

1365: );
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);

Line 1412: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1408: END IF;
1409: END IF;
1410: EXCEPTION
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

Line 1413: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

1409: END IF;
1410: EXCEPTION
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

Line 1414: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

1410: EXCEPTION
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);

Line 1466: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');

1462: EXIT WHEN csp_resource_type_name%NOTFOUND;
1463: END LOOP;
1464: CLOSE csp_resource_type_name;
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

Line 1467: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);

1463: END LOOP;
1464: CLOSE csp_resource_type_name;
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);

Line 1468: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);

1464: CLOSE csp_resource_type_name;
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 ;

Line 1485: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1481: x_resource_org_subinv(I).sub_inv_code := l_sub_inventory;
1482: END LOOP;
1483: EXCEPTION
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

Line 1486: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1482: END LOOP;
1483: EXCEPTION
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

Line 1487: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm,FALSE);

1483: EXCEPTION
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);

Line 1542: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1538: END LOOP;
1539: CLOSE parts_list;
1540: EXCEPTION
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

Line 1543: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1539: CLOSE parts_list;
1540: EXCEPTION
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

Line 1544: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

1540: EXCEPTION
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);

Line 1710: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');

1706: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
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);

Line 1745: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');

1741: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
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);

Line 1818: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');

1814: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
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);

Line 1855: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');

1851: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
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);

Line 1906: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

1902: CSP_SCH_INT_PVT.DELETE_RESERVATION(l_res_ids(i),x_return_status,x_msg_data);
1903: end loop;
1904: EXCEPTION
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

Line 1907: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

1903: end loop;
1904: EXCEPTION
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

Line 1908: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

1904: EXCEPTION
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);

Line 2056: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');

2052: OPEN error_message(23);
2053: FETCH error_message INTO l_message;
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

Line 2057: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);

2053: FETCH error_message INTO l_message;
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);

Line 2074: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');

2070: FETCH get_item_segments INTO l_item_segments;
2071: CLOSE get_item_segments;
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

Line 2075: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);

2071: CLOSE get_item_segments;
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);

Line 2088: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');

2084: OPEN error_message(23);
2085: FETCH error_message INTO l_message;
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

Line 2089: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);

2085: FETCH error_message INTO l_message;
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);

Line 2106: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');

2102: FETCH get_item_segments INTO l_item_segments;
2103: CLOSE get_item_segments;
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

Line 2107: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);

2103: CLOSE get_item_segments;
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);

Line 2195: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2191: return;
2192: END IF;
2193: EXCEPTION
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

Line 2196: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

2192: END IF;
2193: EXCEPTION
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

Line 2197: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

2193: EXCEPTION
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);

Line 2252: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2248: END IF;
2249: END LOOP;
2250: EXCEPTION
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

Line 2253: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

2249: END LOOP;
2250: EXCEPTION
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

Line 2254: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

2250: EXCEPTION
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);

Line 2372: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2368: loop_count := loop_count + 1 ;
2369: END LOOP;
2370: EXCEPTION
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

Line 2373: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

2369: END LOOP;
2370: EXCEPTION
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

Line 2374: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

2370: EXCEPTION
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);

Line 2412: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2408: END IF;*/
2409: END LOOP;
2410: EXCEPTION
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

Line 2413: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

2409: END LOOP;
2410: EXCEPTION
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

Line 2414: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

2410: EXCEPTION
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);

Line 2796: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2792: END LOOP;
2793: END IF;
2794: EXCEPTION
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

Line 2797: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

2793: END IF;
2794: EXCEPTION
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

Line 2798: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

2794: EXCEPTION
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);

Line 2858: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

2854: END IF;
2855: END LOOP;
2856: EXCEPTION
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

Line 2859: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

2855: END LOOP;
2856: EXCEPTION
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

Line 2860: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

2856: EXCEPTION
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);

Line 3219: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_SHIPMETHOD_NOT_DEFINED');

3215: FETCH get_organization_code INTO l_to_org_code;
3216: EXIT WHEN get_organization_code % NOTFOUND;
3217: END LOOP;
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

Line 3220: FND_MESSAGE.SET_TOKEN('FROM_ORG', l_from_org_code, TRUE);

3216: EXIT WHEN get_organization_code % NOTFOUND;
3217: END LOOP;
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

Line 3221: FND_MESSAGE.SET_TOKEN('TO_ORG', l_to_org_code, TRUE);

3217: END LOOP;
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);

Line 3246: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

3242: END LOOP;
3243:
3244: EXCEPTION
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

Line 3247: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

3243:
3244: EXCEPTION
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

Line 3248: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

3244: EXCEPTION
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);

Line 3322: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

3318: END IF;
3319: x_delivery_date := l_delivery_date;
3320: EXCEPTION
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

Line 3323: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

3319: x_delivery_date := l_delivery_date;
3320: EXCEPTION
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

Line 3324: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

3320: EXCEPTION
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);

Line 3523: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');

3519: return x_reservation_id;
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);

Line 3680: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

3676: END IF;
3677: END LOOP;
3678: EXCEPTION
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

Line 3681: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

3677: END LOOP;
3678: EXCEPTION
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

Line 3682: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

3678: EXCEPTION
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);

Line 3986: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');

3982: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
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);

Line 4117: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');

4113: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
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);

Line 4239: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');

4235: l_atleast_one_rec_per_line := TRUE;
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);

Line 4436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

4432: END IF;
4433: END LOOP;
4434: EXCEPTION
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

Line 4437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

4433: END LOOP;
4434: EXCEPTION
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

Line 4438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

4434: EXCEPTION
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);

Line 4517: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

4513: END LOOP;
4514: CLOSE reservation_check;*/
4515: EXCEPTION
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

Line 4518: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);

4514: CLOSE reservation_check;*/
4515: EXCEPTION
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

Line 4519: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);

4515: EXCEPTION
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);

Line 5154: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');

5150: l_available_list(J).item_id := NULL;
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);

Line 5783: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');

5779: , l_rsv_rec
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);