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_MESSAGE

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

360: end if;
361:
362: if l_partial_line > 0 then
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
365: FND_MSG_PUB.ADD;
366: fnd_msg_pub.count_and_get
367: ( p_count => x_msg_count
368: , p_data => x_msg_data);

Line 423: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');

419: and oola.header_id = ooha.header_id
420: AND rownum = 1;
421:
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
424: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
425: FND_MSG_PUB.ADD;
426: fnd_msg_pub.count_and_get
427: ( p_count => x_msg_count

Line 424: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);

420: AND rownum = 1;
421:
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
424: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
425: FND_MSG_PUB.ADD;
426: fnd_msg_pub.count_and_get
427: ( p_count => x_msg_count
428: , p_data => x_msg_data);

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

496: end if;
497:
498: if l_fl_rcvd_multi_source > 0 then
499: x_return_status := FND_API.G_RET_STS_ERROR;
500: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
501: FND_MSG_PUB.ADD;
502: fnd_msg_pub.count_and_get
503: ( p_count => x_msg_count
504: , p_data => x_msg_data);

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

549: end if;
550:
551: if l_oth_req_line > 0 then
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
554: FND_MSG_PUB.ADD;
555: fnd_msg_pub.count_and_get
556: ( p_count => x_msg_count
557: , p_data => x_msg_data);

Line 682: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');

678: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) IN ('SHIPPED', 'EXPECTED')
679: AND rownum = 1;
680:
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
683: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
684: FND_MSG_PUB.ADD;
685: fnd_msg_pub.count_and_get
686: ( p_count => x_msg_count

Line 683: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);

679: AND rownum = 1;
680:
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
683: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
684: FND_MSG_PUB.ADD;
685: fnd_msg_pub.count_and_get
686: ( p_count => x_msg_count
687: , p_data => x_msg_data);

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

714: end if;
715:
716: if l_ship_multi_src > 0 then
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
719: FND_MSG_PUB.ADD;
720: fnd_msg_pub.count_and_get
721: ( p_count => x_msg_count
722: , p_data => x_msg_data);

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

758: end if;
759:
760: if l_oth_req_line > 0 then
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
763: FND_MSG_PUB.ADD;
764: fnd_msg_pub.count_and_get
765: ( p_count => x_msg_count
766: , p_data => x_msg_data);

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

1167: /*ELSE
1168: IF x_options.count = 0 THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: l_del_date := to_char(g_earliest_delivery_date,'MM-DD-YYYY HH24:MI:SS');
1171: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEL');
1172: FND_MESSAGE.SET_TOKEN('DDATE', l_del_date, TRUE);
1173: FND_MSG_PUB.ADD;
1174: fnd_msg_pub.count_and_get
1175: ( p_count => x_msg_count

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

1168: IF x_options.count = 0 THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: l_del_date := to_char(g_earliest_delivery_date,'MM-DD-YYYY HH24:MI:SS');
1171: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEL');
1172: FND_MESSAGE.SET_TOKEN('DDATE', l_del_date, TRUE);
1173: FND_MSG_PUB.ADD;
1174: fnd_msg_pub.count_and_get
1175: ( p_count => x_msg_count
1176: , p_data => x_msg_data);

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

1177: END IF;*/
1178: END IF;
1179: ELSE
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NO_PARTS');
1182: FND_MSG_PUB.ADD;
1183: fnd_msg_pub.count_and_get
1184: ( p_count => x_msg_count
1185: , p_data => x_msg_data);

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

1196: END LOOP;
1197: END IF;
1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1201: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1202: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1203: FND_MSG_PUB.ADD;
1204: fnd_msg_pub.count_and_get

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

1197: END IF;
1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1201: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1202: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1203: FND_MSG_PUB.ADD;
1204: fnd_msg_pub.count_and_get
1205: ( p_count => x_msg_count

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

1198: EXCEPTION
1199: WHEN OTHERS THEN
1200: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1201: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1202: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1203: FND_MSG_PUB.ADD;
1204: fnd_msg_pub.count_and_get
1205: ( p_count => x_msg_count
1206: , p_data => x_msg_data);

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

1364: INTO l_resource_type_name
1365: FROM JTF_OBJECTS_VL
1366: WHERE OBJECT_CODE = p_options.resource_type;
1367: l_resource_name := csp_pick_utils.get_object_name(p_options.resource_type, p_options.resource_id);
1368: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1369: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name, FALSE);
1370: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
1371: FND_MSG_PUB.ADD;
1372: fnd_msg_pub.count_and_get( p_count => x_msg_count

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

1365: FROM JTF_OBJECTS_VL
1366: WHERE OBJECT_CODE = p_options.resource_type;
1367: l_resource_name := csp_pick_utils.get_object_name(p_options.resource_type, p_options.resource_id);
1368: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1369: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name, FALSE);
1370: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
1371: FND_MSG_PUB.ADD;
1372: fnd_msg_pub.count_and_get( p_count => x_msg_count
1373: , p_data => x_msg_data);

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

1366: WHERE OBJECT_CODE = p_options.resource_type;
1367: l_resource_name := csp_pick_utils.get_object_name(p_options.resource_type, p_options.resource_id);
1368: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1369: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name, FALSE);
1370: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
1371: FND_MSG_PUB.ADD;
1372: fnd_msg_pub.count_and_get( p_count => x_msg_count
1373: , p_data => x_msg_data);
1374: x_return_status := FND_API.G_RET_STS_ERROR;

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

1426: );
1427: log('choose_option', 'after calling move_parts_on_reassign...x_return_status=' || x_return_status);
1428: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1429: x_return_status := FND_API.G_RET_STS_ERROR;
1430: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
1431: FND_MSG_PUB.ADD;
1432: fnd_msg_pub.count_and_get
1433: ( p_count => x_msg_count
1434: , p_data => x_msg_data);

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

1491: log('choose_option', 'before calling Update_requirement_headers...x_return_status=' || x_return_status);
1492:
1493: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
1496: FND_MSG_PUB.ADD;
1497: fnd_msg_pub.count_and_get
1498: ( p_count => x_msg_count
1499: , p_data => x_msg_data);

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

1552: log('choose_option', 'before calling Update_requirement_headers...x_return_status=' || x_return_status);
1553:
1554: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
1557: FND_MSG_PUB.ADD;
1558: fnd_msg_pub.count_and_get
1559: ( p_count => x_msg_count
1560: , p_data => x_msg_data);

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

1621:
1622:
1623: if(x_options.count = 0) then
1624: x_return_status := FND_API.G_RET_STS_ERROR;
1625: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
1626: FND_MSG_PUB.ADD;
1627: fnd_msg_pub.count_and_get
1628: ( p_count => x_msg_count
1629: , p_data => x_msg_data);

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

1711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1712: log('choose_option','Order Creation failed');
1713: ROLLBACK TO CHOOSE_OPTIONS;
1714: x_return_status := FND_API.G_RET_STS_ERROR;
1715: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1716: FND_MSG_PUB.ADD;
1717: fnd_msg_pub.count_and_get
1718: ( p_count => x_msg_count
1719: , p_data => x_msg_data);

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

1786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: log('choose_option','Order Creation failed');
1788: ROLLBACK TO CHOOSE_OPTIONS;
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1791: FND_MSG_PUB.ADD;
1792: fnd_msg_pub.count_and_get
1793: ( p_count => x_msg_count
1794: , p_data => x_msg_data);

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

1850: );
1851:
1852: else
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
1855: FND_MSG_PUB.ADD;
1856: fnd_msg_pub.count_and_get
1857: ( p_count => x_msg_count
1858: , p_data => x_msg_data);

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

1923: --CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,l_options,x_return_status);
1924: 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);
1925: ELSE
1926: x_return_status := FND_API.G_RET_STS_ERROR;
1927: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
1928: FND_MSG_PUB.ADD;
1929: fnd_msg_pub.count_and_get
1930: ( p_count => x_msg_count
1931: , p_data => x_msg_data);

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

1945: END IF;
1946: END LOOP;
1947: IF l_temp_options.count = 0 then
1948: x_return_status := FND_API.G_RET_STS_ERROR;
1949: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
1950: FND_MSG_PUB.ADD;
1951: fnd_msg_pub.count_and_get
1952: ( p_count => x_msg_count
1953: , p_data => x_msg_data);

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

2069: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
2070: IF l_reservation_id <= 0 THEN
2071: ROLLBACK TO choose_options;
2072: x_return_status := FND_API.G_RET_STS_ERROR;
2073: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
2074: FND_MSG_PUB.ADD;
2075: fnd_msg_pub.count_and_get
2076: ( p_count => x_msg_count
2077: , p_data => x_msg_data);

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

2130: END IF;
2131: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2132: ROLLBACK TO CHOOSE_OPTIONS;
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
2135: FND_MSG_PUB.ADD;
2136: fnd_msg_pub.count_and_get
2137: ( p_count => x_msg_count
2138: , p_data => x_msg_data);

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

2207:
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: ROLLBACK TO choose_options;
2211: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2212: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2213: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2214: FND_MSG_PUB.ADD;
2215: fnd_msg_pub.count_and_get

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

2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: ROLLBACK TO choose_options;
2211: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2212: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2213: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2214: FND_MSG_PUB.ADD;
2215: fnd_msg_pub.count_and_get
2216: ( p_count => x_msg_count

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

2209: WHEN OTHERS THEN
2210: ROLLBACK TO choose_options;
2211: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2212: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2213: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2214: FND_MSG_PUB.ADD;
2215: fnd_msg_pub.count_and_get
2216: ( p_count => x_msg_count
2217: , p_data => x_msg_data);

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

2270: END IF;
2271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
2273: x_return_status := FND_API.G_RET_STS_ERROR;
2274: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_RESERV');
2275: FND_MSG_PUB.ADD;
2276: fnd_msg_pub.count_and_get
2277: ( p_count => x_msg_count
2278: , p_data => x_msg_data);

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

2323: x_return_status := FND_API.G_RET_STS_SUCCESS;
2324: END IF;
2325: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
2328: FND_MSG_PUB.ADD;
2329: fnd_msg_pub.count_and_get
2330: ( p_count => x_msg_count
2331: , p_data => x_msg_data);

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

2372: END IF;
2373: EXCEPTION
2374: WHEN OTHERS THEN
2375: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
2376: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2377: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2378: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2379: FND_MSG_PUB.ADD;
2380: fnd_msg_pub.count_and_get

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

2373: EXCEPTION
2374: WHEN OTHERS THEN
2375: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
2376: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2377: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2378: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2379: FND_MSG_PUB.ADD;
2380: fnd_msg_pub.count_and_get
2381: ( p_count => x_msg_count

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

2374: WHEN OTHERS THEN
2375: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
2376: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2377: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2378: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2379: FND_MSG_PUB.ADD;
2380: fnd_msg_pub.count_and_get
2381: ( p_count => x_msg_count
2382: , p_data => x_msg_data);

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

2757: ,l_serial_number);
2758: EXCEPTION
2759: WHEN OTHERS THEN
2760: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
2761: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2762: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2763: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2764: FND_MSG_PUB.ADD;
2765: fnd_msg_pub.count_and_get

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

2758: EXCEPTION
2759: WHEN OTHERS THEN
2760: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
2761: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2762: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2763: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2764: FND_MSG_PUB.ADD;
2765: fnd_msg_pub.count_and_get
2766: ( p_count => x_msg_count

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

2759: WHEN OTHERS THEN
2760: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
2761: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2762: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2763: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2764: FND_MSG_PUB.ADD;
2765: fnd_msg_pub.count_and_get
2766: ( p_count => x_msg_count
2767: , p_data => x_msg_data);

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

2794: );
2795:
2796: EXCEPTION
2797: WHEN OTHERS THEN
2798: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2799: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
2800: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
2801: FND_MSG_PUB.ADD;
2802: fnd_msg_pub.count_and_get

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

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

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

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

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

2859: );
2860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2861: ROLLBACK TO CREATE_ORDERS;
2862: x_return_status := FND_API.G_RET_STS_ERROR;
2863: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
2864: FND_MSG_PUB.ADD;
2865: fnd_msg_pub.count_and_get
2866: ( p_count => x_msg_count
2867: , p_data => x_msg_data);

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

3052: );
3053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3054: ROLLBACK TO CREATE_ORDERS;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
3057: FND_MSG_PUB.ADD;
3058: fnd_msg_pub.count_and_get
3059: ( p_count => x_msg_count
3060: , p_data => x_msg_data);

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

3095: END IF;
3096: END IF;
3097: EXCEPTION
3098: WHEN OTHERS THEN
3099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
3101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
3102: FND_MSG_PUB.ADD;
3103: fnd_msg_pub.count_and_get

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

3096: END IF;
3097: EXCEPTION
3098: WHEN OTHERS THEN
3099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
3101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
3102: FND_MSG_PUB.ADD;
3103: fnd_msg_pub.count_and_get
3104: ( p_count => x_msg_count

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

3097: EXCEPTION
3098: WHEN OTHERS THEN
3099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
3101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
3102: FND_MSG_PUB.ADD;
3103: fnd_msg_pub.count_and_get
3104: ( p_count => x_msg_count
3105: , p_data => x_msg_data);

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

3151: EXIT WHEN csp_resource_type_name%NOTFOUND;
3152: END LOOP;
3153: CLOSE csp_resource_type_name;
3154: l_resource_name := csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id);
3155: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3156: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
3157: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3158: FND_MSG_PUB.ADD;
3159: fnd_msg_pub.count_and_get( p_count => x_msg_count

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

3152: END LOOP;
3153: CLOSE csp_resource_type_name;
3154: l_resource_name := csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id);
3155: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3156: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
3157: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3158: FND_MSG_PUB.ADD;
3159: fnd_msg_pub.count_and_get( p_count => x_msg_count
3160: , p_data => x_msg_data);

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

3153: CLOSE csp_resource_type_name;
3154: l_resource_name := csp_pick_utils.get_object_name(p_resources(I).resource_type,p_resources(I).resource_id);
3155: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3156: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
3157: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3158: FND_MSG_PUB.ADD;
3159: fnd_msg_pub.count_and_get( p_count => x_msg_count
3160: , p_data => x_msg_data);
3161: -- x_msg_data := 'Default organization and subinventory not defined for ' || l_resource_type_name || ' ' || l_resource_name ;

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

3170: x_resource_org_subinv(I).sub_inv_code := l_sub_inventory;
3171: END LOOP;
3172: EXCEPTION
3173: WHEN OTHERS THEN
3174: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3175: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3176: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm,FALSE);
3177: FND_MSG_PUB.ADD;
3178: fnd_msg_pub.count_and_get

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

3171: END LOOP;
3172: EXCEPTION
3173: WHEN OTHERS THEN
3174: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3175: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3176: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm,FALSE);
3177: FND_MSG_PUB.ADD;
3178: fnd_msg_pub.count_and_get
3179: ( p_count => x_msg_count

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

3172: EXCEPTION
3173: WHEN OTHERS THEN
3174: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3175: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3176: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm,FALSE);
3177: FND_MSG_PUB.ADD;
3178: fnd_msg_pub.count_and_get
3179: ( p_count => x_msg_count
3180: , p_data => x_msg_data);

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

3227: END LOOP;
3228: CLOSE parts_list;
3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3232: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3233: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3234: FND_MSG_PUB.ADD;
3235: fnd_msg_pub.count_and_get

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

3228: CLOSE parts_list;
3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3232: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3233: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3234: FND_MSG_PUB.ADD;
3235: fnd_msg_pub.count_and_get
3236: ( p_count => x_msg_count

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

3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3232: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3233: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3234: FND_MSG_PUB.ADD;
3235: fnd_msg_pub.count_and_get
3236: ( p_count => x_msg_count
3237: , p_data => x_msg_data);

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

3397: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
3398: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
3399:
3400: IF l_reservation_id <= 0 THEN
3401: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
3402: FND_MSG_PUB.ADD;
3403: fnd_msg_pub.count_and_get
3404: ( p_count => x_msg_count
3405: , p_data => x_msg_data);

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

3432: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
3433: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
3434:
3435: IF l_reservation_id <= 0 THEN
3436: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
3437: FND_MSG_PUB.ADD;
3438: fnd_msg_pub.count_and_get
3439: ( p_count => x_msg_count
3440: , p_data => x_msg_data);

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

3505: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
3506: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
3507:
3508: IF l_reservation_id <= 0 THEN
3509: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
3510: FND_MSG_PUB.ADD;
3511: fnd_msg_pub.count_and_get
3512: ( p_count => x_msg_count
3513: , p_data => x_msg_data);

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

3542: l_reservation_parts.revision := x_available_list(x_available_list.count).revision;
3543: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
3544:
3545: IF l_reservation_id <= 0 THEN
3546: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
3547: FND_MSG_PUB.ADD;
3548: fnd_msg_pub.count_and_get
3549: ( p_count => x_msg_count
3550: , p_data => x_msg_data);

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

3593: CSP_SCH_INT_PVT.DELETE_RESERVATION(l_res_ids(i),x_return_status,x_msg_data);
3594: end loop;
3595: EXCEPTION
3596: WHEN OTHERS THEN
3597: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3598: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3599: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3600: FND_MSG_PUB.ADD;
3601: fnd_msg_pub.count_and_get

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

3594: end loop;
3595: EXCEPTION
3596: WHEN OTHERS THEN
3597: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3598: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3599: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3600: FND_MSG_PUB.ADD;
3601: fnd_msg_pub.count_and_get
3602: ( p_count => x_msg_count

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

3595: EXCEPTION
3596: WHEN OTHERS THEN
3597: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
3598: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
3599: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
3600: FND_MSG_PUB.ADD;
3601: fnd_msg_pub.count_and_get
3602: ( p_count => x_msg_count
3603: , p_data => x_msg_data);

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

4144: end if;*/
4145: end loop;
4146: if p_mandatory and l_available <> 'Y' then
4147: x_return_status := fnd_api.g_ret_sts_error;
4148: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NO_PARTS');
4149: FND_MSG_PUB.ADD;
4150: fnd_msg_pub.count_and_get
4151: ( p_count => x_msg_count
4152: , p_data => x_msg_data);

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

4311: OPEN error_message(23);
4312: FETCH error_message INTO l_message;
4313: CLOSE error_message;
4314:
4315: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4316: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4317: FND_MSG_PUB.ADD;
4318: fnd_msg_pub.count_and_get
4319: ( p_count => x_msg_count

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

4312: FETCH error_message INTO l_message;
4313: CLOSE error_message;
4314:
4315: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4316: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4317: FND_MSG_PUB.ADD;
4318: fnd_msg_pub.count_and_get
4319: ( p_count => x_msg_count
4320: , p_data => x_msg_data);

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

4329: FETCH get_item_segments INTO l_item_segments;
4330: CLOSE get_item_segments;
4331: l_error := true;
4332: l_message := l_item_segments || ' : '|| l_message;
4333: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4334: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4335: FND_MSG_PUB.ADD;
4336: fnd_msg_pub.count_and_get
4337: ( p_count => x_msg_count

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

4330: CLOSE get_item_segments;
4331: l_error := true;
4332: l_message := l_item_segments || ' : '|| l_message;
4333: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4334: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4335: FND_MSG_PUB.ADD;
4336: fnd_msg_pub.count_and_get
4337: ( p_count => x_msg_count
4338: , p_data => x_msg_data);

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

4343: OPEN error_message(23);
4344: FETCH error_message INTO l_message;
4345: CLOSE error_message;
4346:
4347: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4348: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4349: FND_MSG_PUB.ADD;
4350: fnd_msg_pub.count_and_get
4351: ( p_count => x_msg_count

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

4344: FETCH error_message INTO l_message;
4345: CLOSE error_message;
4346:
4347: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4348: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4349: FND_MSG_PUB.ADD;
4350: fnd_msg_pub.count_and_get
4351: ( p_count => x_msg_count
4352: , p_data => x_msg_data);

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

4361: FETCH get_item_segments INTO l_item_segments;
4362: CLOSE get_item_segments;
4363: l_error := true;
4364: l_message := l_item_segments || ' : '|| l_message;
4365: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4366: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4367: FND_MSG_PUB.ADD;
4368: fnd_msg_pub.count_and_get
4369: ( p_count => x_msg_count

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

4362: CLOSE get_item_segments;
4363: l_error := true;
4364: l_message := l_item_segments || ' : '|| l_message;
4365: FND_MESSAGE.SET_NAME('CSP', 'CSP_ATP');
4366: FND_MESSAGE.SET_TOKEN('ERROR', l_message, FALSE);
4367: FND_MSG_PUB.ADD;
4368: fnd_msg_pub.count_and_get
4369: ( p_count => x_msg_count
4370: , p_data => x_msg_data);

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

4455: END IF;
4456: log('do_atp_check', 'End');
4457: EXCEPTION
4458: WHEN OTHERS THEN
4459: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4460: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4461: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4462: FND_MSG_PUB.ADD;
4463: fnd_msg_pub.count_and_get

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

4456: log('do_atp_check', 'End');
4457: EXCEPTION
4458: WHEN OTHERS THEN
4459: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4460: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4461: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4462: FND_MSG_PUB.ADD;
4463: fnd_msg_pub.count_and_get
4464: ( p_count => x_msg_count

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

4457: EXCEPTION
4458: WHEN OTHERS THEN
4459: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4460: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4461: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4462: FND_MSG_PUB.ADD;
4463: fnd_msg_pub.count_and_get
4464: ( p_count => x_msg_count
4465: , p_data => x_msg_data);

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

4515: END IF;
4516: END LOOP;
4517: EXCEPTION
4518: WHEN OTHERS THEN
4519: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4520: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4521: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4522: FND_MSG_PUB.ADD;
4523: fnd_msg_pub.count_and_get

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

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

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

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

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

4699: end if;
4700:
4701: EXCEPTION
4702: WHEN OTHERS THEN
4703: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4704: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4705: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4706: FND_MSG_PUB.ADD;
4707: fnd_msg_pub.count_and_get

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

4700:
4701: EXCEPTION
4702: WHEN OTHERS THEN
4703: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4704: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4705: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4706: FND_MSG_PUB.ADD;
4707: fnd_msg_pub.count_and_get
4708: ( p_count => x_msg_count

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

4701: EXCEPTION
4702: WHEN OTHERS THEN
4703: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4704: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4705: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4706: FND_MSG_PUB.ADD;
4707: fnd_msg_pub.count_and_get
4708: ( p_count => x_msg_count
4709: , p_data => x_msg_data);

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

4740: END IF;*/
4741: END LOOP;
4742: EXCEPTION
4743: WHEN OTHERS THEN
4744: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4745: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4746: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4747: FND_MSG_PUB.ADD;
4748: fnd_msg_pub.count_and_get

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

4741: END LOOP;
4742: EXCEPTION
4743: WHEN OTHERS THEN
4744: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4745: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4746: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4747: FND_MSG_PUB.ADD;
4748: fnd_msg_pub.count_and_get
4749: ( p_count => x_msg_count

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

4742: EXCEPTION
4743: WHEN OTHERS THEN
4744: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
4745: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
4746: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
4747: FND_MSG_PUB.ADD;
4748: fnd_msg_pub.count_and_get
4749: ( p_count => x_msg_count
4750: , p_data => x_msg_data);

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

5223: END LOOP;
5224: END IF;
5225: EXCEPTION
5226: WHEN OTHERS THEN
5227: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5228: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5229: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5230: FND_MSG_PUB.ADD;
5231: fnd_msg_pub.count_and_get

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

5224: END IF;
5225: EXCEPTION
5226: WHEN OTHERS THEN
5227: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5228: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5229: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5230: FND_MSG_PUB.ADD;
5231: fnd_msg_pub.count_and_get
5232: ( p_count => x_msg_count

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

5225: EXCEPTION
5226: WHEN OTHERS THEN
5227: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5228: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5229: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5230: FND_MSG_PUB.ADD;
5231: fnd_msg_pub.count_and_get
5232: ( p_count => x_msg_count
5233: , p_data => x_msg_data);

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

5285: END IF;
5286: END LOOP;
5287: EXCEPTION
5288: WHEN OTHERS THEN
5289: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5290: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5291: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5292: FND_MSG_PUB.ADD;
5293: fnd_msg_pub.count_and_get

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

5286: END LOOP;
5287: EXCEPTION
5288: WHEN OTHERS THEN
5289: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5290: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5291: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5292: FND_MSG_PUB.ADD;
5293: fnd_msg_pub.count_and_get
5294: ( p_count => x_msg_count

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

5287: EXCEPTION
5288: WHEN OTHERS THEN
5289: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5290: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5291: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5292: FND_MSG_PUB.ADD;
5293: fnd_msg_pub.count_and_get
5294: ( p_count => x_msg_count
5295: , p_data => x_msg_data);

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

5609: FETCH get_organization_code INTO l_to_org_code;
5610: EXIT WHEN get_organization_code % NOTFOUND;
5611: END LOOP;
5612: CLOSE get_organization_code;
5613: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_SHIPMETHOD_NOT_DEFINED');
5614: FND_MESSAGE.SET_TOKEN('FROM_ORG', l_from_org_code, TRUE);
5615: FND_MESSAGE.SET_TOKEN('TO_ORG', l_to_org_code, TRUE);
5616: FND_MSG_PUB.ADD;
5617: fnd_msg_pub.count_and_get

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

5610: EXIT WHEN get_organization_code % NOTFOUND;
5611: END LOOP;
5612: CLOSE get_organization_code;
5613: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_SHIPMETHOD_NOT_DEFINED');
5614: FND_MESSAGE.SET_TOKEN('FROM_ORG', l_from_org_code, TRUE);
5615: FND_MESSAGE.SET_TOKEN('TO_ORG', l_to_org_code, TRUE);
5616: FND_MSG_PUB.ADD;
5617: fnd_msg_pub.count_and_get
5618: ( p_count => x_msg_count

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

5611: END LOOP;
5612: CLOSE get_organization_code;
5613: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_SHIPMETHOD_NOT_DEFINED');
5614: FND_MESSAGE.SET_TOKEN('FROM_ORG', l_from_org_code, TRUE);
5615: FND_MESSAGE.SET_TOKEN('TO_ORG', l_to_org_code, TRUE);
5616: FND_MSG_PUB.ADD;
5617: fnd_msg_pub.count_and_get
5618: ( p_count => x_msg_count
5619: , p_data => x_msg_data);

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

5636: END LOOP;
5637:
5638: EXCEPTION
5639: WHEN OTHERS THEN
5640: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5641: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
5642: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
5643: FND_MSG_PUB.ADD;
5644: fnd_msg_pub.count_and_get

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

5637:
5638: EXCEPTION
5639: WHEN OTHERS THEN
5640: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5641: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
5642: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
5643: FND_MSG_PUB.ADD;
5644: fnd_msg_pub.count_and_get
5645: ( p_count => x_msg_count

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

5638: EXCEPTION
5639: WHEN OTHERS THEN
5640: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5641: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
5642: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
5643: FND_MSG_PUB.ADD;
5644: fnd_msg_pub.count_and_get
5645: ( p_count => x_msg_count
5646: , p_data => x_msg_data);

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

5712: END IF;
5713: x_delivery_date := l_delivery_date;
5714: EXCEPTION
5715: WHEN OTHERS THEN
5716: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5717: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5718: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5719: FND_MSG_PUB.ADD;
5720: fnd_msg_pub.count_and_get

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

5713: x_delivery_date := l_delivery_date;
5714: EXCEPTION
5715: WHEN OTHERS THEN
5716: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5717: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5718: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5719: FND_MSG_PUB.ADD;
5720: fnd_msg_pub.count_and_get
5721: ( p_count => x_msg_count

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

5714: EXCEPTION
5715: WHEN OTHERS THEN
5716: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
5717: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
5718: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
5719: FND_MSG_PUB.ADD;
5720: fnd_msg_pub.count_and_get
5721: ( p_count => x_msg_count
5722: , p_data => x_msg_data);

Line 5827: FND_MESSAGE.SET_NAME('CSP', 'CSP_RES_SUBINV_NULL');

5823: raise NO_DATA_FOUND ;
5824: END IF;
5825: /* IF p_reservation_parts.sub_inventory_code IS NULL THEN
5826: FND_MSG_PUB.INITIALIZE;
5827: FND_MESSAGE.SET_NAME('CSP', 'CSP_RES_SUBINV_NULL');
5828: FND_MSG_PUB.ADD;
5829: fnd_msg_pub.count_and_get
5830: ( p_count => x_msg_count
5831: , p_data => x_msg_data);

Line 5938: FND_MESSAGE.SET_NAME('CSP', 'CSP_INSUFFICIENT_QTY');

5934: return x_reservation_id;
5935: END IF;
5936: ELSE
5937: FND_MSG_PUB.INITIALIZE;
5938: FND_MESSAGE.SET_NAME('CSP', 'CSP_INSUFFICIENT_QTY');
5939: FND_MSG_PUB.ADD;
5940: fnd_msg_pub.count_and_get
5941: ( p_count => x_msg_count
5942: , p_data => x_msg_data);

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

5944: return 0;
5945: END IF;
5946: EXCEPTION
5947: WHEN NO_DATA_FOUND THEN
5948: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');
5949: FND_MSG_PUB.ADD;
5950: fnd_msg_pub.count_and_get
5951: ( p_count => x_msg_count
5952: , p_data => x_msg_data);

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

6101: END IF;
6102: END LOOP;
6103: EXCEPTION
6104: WHEN OTHERS THEN
6105: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
6106: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
6107: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
6108: FND_MSG_PUB.ADD;
6109: fnd_msg_pub.count_and_get

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

6102: END LOOP;
6103: EXCEPTION
6104: WHEN OTHERS THEN
6105: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
6106: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
6107: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
6108: FND_MSG_PUB.ADD;
6109: fnd_msg_pub.count_and_get
6110: ( p_count => x_msg_count

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

6103: EXCEPTION
6104: WHEN OTHERS THEN
6105: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
6106: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
6107: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
6108: FND_MSG_PUB.ADD;
6109: fnd_msg_pub.count_and_get
6110: ( p_count => x_msg_count
6111: , p_data => x_msg_data);

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

6448: l_reservation_id := csp_sch_int_pvt.create_reservation(l_reservation_parts,x_return_status,x_msg_data);
6449: log('check_parts_availability', 'l_reservation_id: '||l_reservation_id);
6450: IF l_reservation_id <= 0 THEN
6451: x_return_status := FND_API.G_RET_STS_ERROR;
6452: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
6453: FND_MSG_PUB.ADD;
6454: fnd_msg_pub.count_and_get ( p_count => x_msg_count , p_data => x_msg_data);
6455: ELSE
6456: log('check_parts_availability', 'l_res_ids.count: ||l_res_ids.count');

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

6602: l_reservation_parts.revision := l_final_available_list(l_final_available_list.count).revision;
6603: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
6604: IF l_reservation_id <= 0 THEN
6605: x_return_status := FND_API.G_RET_STS_ERROR;
6606: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
6607: FND_MSG_PUB.ADD;
6608: fnd_msg_pub.count_and_get ( p_count => x_msg_count , p_data => x_msg_data);
6609: ELSE
6610: l_res_ids(l_res_ids.count+1) := l_reservation_id ;

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

6742: l_atleast_one_rec_per_line := TRUE;
6743: END IF;
6744: END LOOP;
6745: IF NOT l_atleast_one_rec_per_line THEN
6746: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');
6747: FND_MSG_PUB.ADD;
6748: fnd_msg_pub.count_and_get ( p_count => x_msg_count , p_data => x_msg_data);
6749: END IF;
6750: END LOOP;

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

6975: END LOOP;
6976: log('check_parts_availability', 'END');
6977: EXCEPTION
6978: WHEN OTHERS THEN
6979: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
6980: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
6981: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
6982: FND_MSG_PUB.ADD;
6983: fnd_msg_pub.count_and_get ( p_count => x_msg_count , p_data => x_msg_data);

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

6976: log('check_parts_availability', 'END');
6977: EXCEPTION
6978: WHEN OTHERS THEN
6979: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
6980: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
6981: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
6982: FND_MSG_PUB.ADD;
6983: fnd_msg_pub.count_and_get ( p_count => x_msg_count , p_data => x_msg_data);
6984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6977: EXCEPTION
6978: WHEN OTHERS THEN
6979: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
6980: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
6981: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
6982: FND_MSG_PUB.ADD;
6983: fnd_msg_pub.count_and_get ( p_count => x_msg_count , p_data => x_msg_data);
6984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6985: RETURN;

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

7055: END LOOP;
7056: CLOSE reservation_check;*/
7057: EXCEPTION
7058: WHEN OTHERS THEN
7059: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
7060: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
7061: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
7062: FND_MSG_PUB.ADD;
7063: fnd_msg_pub.count_and_get

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

7056: CLOSE reservation_check;*/
7057: EXCEPTION
7058: WHEN OTHERS THEN
7059: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
7060: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
7061: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
7062: FND_MSG_PUB.ADD;
7063: fnd_msg_pub.count_and_get
7064: ( p_count => x_msg_count

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

7057: EXCEPTION
7058: WHEN OTHERS THEN
7059: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
7060: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
7061: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
7062: FND_MSG_PUB.ADD;
7063: fnd_msg_pub.count_and_get
7064: ( p_count => x_msg_count
7065: , p_data => x_msg_data);

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

7692: l_available_list(J).item_id := NULL;
7693: END IF;
7694: END LOOP;
7695: IF not l_atleast_one_rec THEN
7696: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNABLE_NEED_BY_DATE');
7697: FND_MSG_PUB.ADD;
7698: fnd_msg_pub.count_and_get
7699: ( p_count => x_msg_count
7700: , p_data => x_msg_data);

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

8321: , l_rsv_rec
8322: , l_serial_number);
8323: EXCEPTION
8324: WHEN NO_DATA_FOUND THEN
8325: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_TRANSACTION');
8326: FND_MSG_PUB.ADD;
8327: fnd_msg_pub.count_and_get
8328: ( p_count => x_msg_count
8329: , p_data => x_msg_data);

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

8432: SELECT NAME
8433: into l_resource_type_name
8434: FROM JTF_OBJECTS_VL
8435: WHERE OBJECT_CODE = p_new_resource_type;
8436: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
8437: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
8438: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
8439: FND_MSG_PUB.ADD;
8440: fnd_msg_pub.count_and_get

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

8433: into l_resource_type_name
8434: FROM JTF_OBJECTS_VL
8435: WHERE OBJECT_CODE = p_new_resource_type;
8436: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
8437: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
8438: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
8439: FND_MSG_PUB.ADD;
8440: fnd_msg_pub.count_and_get
8441: ( p_count => x_msg_count

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

8434: FROM JTF_OBJECTS_VL
8435: WHERE OBJECT_CODE = p_new_resource_type;
8436: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
8437: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
8438: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
8439: FND_MSG_PUB.ADD;
8440: fnd_msg_pub.count_and_get
8441: ( p_count => x_msg_count
8442: , p_data => x_msg_data);

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

8460: log('move_parts_on_reassign', 'x_return_status=' || x_return_status);
8461:
8462: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
8463: x_return_status := FND_API.G_RET_STS_ERROR;
8464: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
8465: FND_MSG_PUB.ADD;
8466: fnd_msg_pub.count_and_get
8467: ( p_count => x_msg_count
8468: , p_data => x_msg_data);

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

8490: );
8491: log('move_parts_on_reassign', 'after calling transact_intorg_transfer... x_return_status=' || x_return_status);
8492: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
8493: x_return_status := FND_API.G_RET_STS_ERROR;
8494: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
8495: FND_MSG_PUB.ADD;
8496: fnd_msg_pub.count_and_get
8497: ( p_count => x_msg_count
8498: , p_data => x_msg_data);

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

8509: );
8510: log('move_parts_on_reassign', 'after calling transact_subinv_transfer... x_return_status=' || x_return_status);
8511: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
8512: x_return_status := FND_API.G_RET_STS_ERROR;
8513: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
8514: FND_MSG_PUB.ADD;
8515: fnd_msg_pub.count_and_get
8516: ( p_count => x_msg_count
8517: , p_data => x_msg_data);

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

8538: log('move_parts_on_reassign', 'l_new_reservation_id=' || l_new_reservation_id);
8539:
8540: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
8541: x_return_status := FND_API.G_RET_STS_ERROR;
8542: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
8543: FND_MSG_PUB.ADD;
8544: fnd_msg_pub.count_and_get
8545: ( p_count => x_msg_count
8546: , p_data => x_msg_data);

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

8596: log('move_parts_on_reassign', 'before calling Update_requirement_headers...x_return_status=' || x_return_status);
8597:
8598: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
8599: x_return_status := FND_API.G_RET_STS_ERROR;
8600: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
8601: FND_MSG_PUB.ADD;
8602: fnd_msg_pub.count_and_get
8603: ( p_count => x_msg_count
8604: , p_data => x_msg_data);