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 365: FND_MSG_PUB.ADD;

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

Line 366: fnd_msg_pub.count_and_get

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);
369: return;
370: end if;

Line 425: FND_MSG_PUB.ADD;

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

Line 426: fnd_msg_pub.count_and_get

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);
429: return;
430: end if;

Line 501: FND_MSG_PUB.ADD;

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

Line 502: fnd_msg_pub.count_and_get

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);
505: return;
506: end if;

Line 554: FND_MSG_PUB.ADD;

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

Line 555: fnd_msg_pub.count_and_get

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);
558: return;
559: end if;

Line 684: FND_MSG_PUB.ADD;

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

Line 685: fnd_msg_pub.count_and_get

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);
688: return;
689: else

Line 719: FND_MSG_PUB.ADD;

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

Line 720: fnd_msg_pub.count_and_get

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);
723: return;
724: end if;

Line 763: FND_MSG_PUB.ADD;

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

Line 764: fnd_msg_pub.count_and_get

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);
767: return;
768: end if;

Line 1173: FND_MSG_PUB.ADD;

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

Line 1174: fnd_msg_pub.count_and_get

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

Line 1182: FND_MSG_PUB.ADD;

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

Line 1183: fnd_msg_pub.count_and_get

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);
1186: END IF;
1187: ELSE

Line 1203: FND_MSG_PUB.ADD;

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);
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1204: fnd_msg_pub.count_and_get

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);
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208: return;

Line 1371: FND_MSG_PUB.ADD;

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;
1375: return;

Line 1372: fnd_msg_pub.count_and_get( p_count => x_msg_count

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;
1375: return;
1376: end if;

Line 1431: FND_MSG_PUB.ADD;

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);
1435: end if;

Line 1432: fnd_msg_pub.count_and_get

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);
1435: end if;
1436: return;

Line 1496: FND_MSG_PUB.ADD;

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

Line 1497: fnd_msg_pub.count_and_get

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);
1500: return;
1501: end if;

Line 1557: FND_MSG_PUB.ADD;

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

Line 1558: fnd_msg_pub.count_and_get

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);
1561: return;
1562: end if;

Line 1626: FND_MSG_PUB.ADD;

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

Line 1627: fnd_msg_pub.count_and_get

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);
1630: return;
1631: end if;

Line 1716: FND_MSG_PUB.ADD;

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

Line 1717: fnd_msg_pub.count_and_get

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);
1720: return;
1721: end if;

Line 1791: FND_MSG_PUB.ADD;

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

Line 1792: fnd_msg_pub.count_and_get

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);
1795: return;
1796: end if;

Line 1855: FND_MSG_PUB.ADD;

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

Line 1856: fnd_msg_pub.count_and_get

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);
1859: return;
1860: end if;

Line 1928: FND_MSG_PUB.ADD;

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

Line 1929: fnd_msg_pub.count_and_get

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);
1932: return;
1933: END IF;

Line 1950: FND_MSG_PUB.ADD;

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

Line 1951: fnd_msg_pub.count_and_get

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);
1954: return;
1955: END IF;

Line 2074: FND_MSG_PUB.ADD;

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

Line 2075: fnd_msg_pub.count_and_get

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);
2078: return;
2079: END IF;

Line 2135: FND_MSG_PUB.ADD;

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

Line 2136: fnd_msg_pub.count_and_get

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);
2139: return;
2140: ELSE

Line 2214: FND_MSG_PUB.ADD;

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);
2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2215: fnd_msg_pub.count_and_get

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);
2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2219: END CHOOSE_OPTION;

Line 2275: FND_MSG_PUB.ADD;

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);
2279: exit;

Line 2276: fnd_msg_pub.count_and_get

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);
2279: exit;
2280: ELSE

Line 2328: FND_MSG_PUB.ADD;

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);
2332: exit;

Line 2329: fnd_msg_pub.count_and_get

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);
2332: exit;
2333: ELSE

Line 2379: FND_MSG_PUB.ADD;

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);
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2380: fnd_msg_pub.count_and_get

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);
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2384:

Line 2764: FND_MSG_PUB.ADD;

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);
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2765: fnd_msg_pub.count_and_get

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);
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2769:

Line 2801: FND_MSG_PUB.ADD;

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);
2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2802: fnd_msg_pub.count_and_get

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);
2805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2806: END CANCEL_ORDER;

Line 2864: FND_MSG_PUB.ADD;

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);
2868: exit;

Line 2865: fnd_msg_pub.count_and_get

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);
2868: exit;
2869: END IF;

Line 3057: FND_MSG_PUB.ADD;

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

Line 3058: fnd_msg_pub.count_and_get

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);
3061: return;
3062: ELSE

Line 3102: FND_MSG_PUB.ADD;

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);
3106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3103: fnd_msg_pub.count_and_get

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);
3106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3107: END CREATE_ORDERS;*/

Line 3158: FND_MSG_PUB.ADD;

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 ;
3162: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3159: fnd_msg_pub.count_and_get( p_count => x_msg_count

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 ;
3162: x_return_status := FND_API.G_RET_STS_ERROR;
3163: return;

Line 3177: FND_MSG_PUB.ADD;

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);
3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3178: fnd_msg_pub.count_and_get

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);
3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182: END GET_ORGANIZATION_SUBINV;

Line 3234: FND_MSG_PUB.ADD;

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);
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3235: fnd_msg_pub.count_and_get

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);
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3239: return;

Line 3402: FND_MSG_PUB.ADD;

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);
3406: else

Line 3403: fnd_msg_pub.count_and_get

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);
3406: else
3407: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 3437: FND_MSG_PUB.ADD;

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);
3441: else

Line 3438: fnd_msg_pub.count_and_get

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);
3441: else
3442: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 3510: FND_MSG_PUB.ADD;

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);
3514: else

Line 3511: fnd_msg_pub.count_and_get

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);
3514: else
3515: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 3547: FND_MSG_PUB.ADD;

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);
3551: else

Line 3548: fnd_msg_pub.count_and_get

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);
3551: else
3552: l_res_ids(l_res_ids.count+1) := l_reservation_id;

Line 3600: FND_MSG_PUB.ADD;

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);
3604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3601: fnd_msg_pub.count_and_get

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);
3604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3605: return;

Line 4149: FND_MSG_PUB.ADD;

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);
4153: end if;

Line 4150: fnd_msg_pub.count_and_get

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);
4153: end if;
4154: end;

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

4287: log('do_atp_check', 'after MRP_ATP_PUB.CALL_ATP');
4288: log('do_atp_check', 'x_return_status: '||x_return_status);
4289: log('do_atp_check', 'x_msg_data: '||x_msg_data);
4290: log('do_atp_check', 'x_msg_count: '||x_msg_count);
4291: l_msg := FND_MSG_PUB.Get(1,FND_API.G_FALSE) ;
4292:
4293: rollback to csp_msc_atp_check;
4294: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
4295: l_unavailable := 'Y';

Line 4317: FND_MSG_PUB.ADD;

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

Line 4318: fnd_msg_pub.count_and_get

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

Line 4335: FND_MSG_PUB.ADD;

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

Line 4336: fnd_msg_pub.count_and_get

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);
4339: END IF;
4340: ELSE

Line 4349: FND_MSG_PUB.ADD;

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

Line 4350: fnd_msg_pub.count_and_get

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

Line 4367: FND_MSG_PUB.ADD;

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);
4371: ELSE

Line 4368: fnd_msg_pub.count_and_get

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);
4371: ELSE
4372: l_unavailable := 'N';

Line 4462: FND_MSG_PUB.ADD;

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);
4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4463: fnd_msg_pub.count_and_get

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);
4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4467: return;

Line 4522: FND_MSG_PUB.ADD;

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);
4526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4523: fnd_msg_pub.count_and_get

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);
4526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4527: return;

Line 4706: FND_MSG_PUB.ADD;

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);
4710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4707: fnd_msg_pub.count_and_get

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);
4710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4711: return;

Line 4747: FND_MSG_PUB.ADD;

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);
4751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4748: fnd_msg_pub.count_and_get

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);
4751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4752: return;

Line 5230: FND_MSG_PUB.ADD;

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);
5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5231: fnd_msg_pub.count_and_get

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);
5234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5235: return;

Line 5292: FND_MSG_PUB.ADD;

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);
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5293: fnd_msg_pub.count_and_get

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);
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5297: return;

Line 5616: FND_MSG_PUB.ADD;

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);
5620: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5617: fnd_msg_pub.count_and_get

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);
5620: x_return_status := FND_API.G_RET_STS_ERROR;
5621: return;

Line 5643: FND_MSG_PUB.ADD;

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);
5647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5644: fnd_msg_pub.count_and_get

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);
5647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5648: return;

Line 5719: FND_MSG_PUB.ADD;

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);
5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5720: fnd_msg_pub.count_and_get

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);
5723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5724: return;

Line 5826: FND_MSG_PUB.INITIALIZE;

5822: IF l_source_type_id IS NULL THEN
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

Line 5828: FND_MSG_PUB.ADD;

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);
5832: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5829: fnd_msg_pub.count_and_get

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);
5832: x_return_status := FND_API.G_RET_STS_ERROR;
5833: RETURN 0;

Line 5937: FND_MSG_PUB.INITIALIZE;

5933: log('create_reservation','Created reservation ID:'||x_reservation_id);
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

Line 5939: FND_MSG_PUB.ADD;

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);
5943: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5940: fnd_msg_pub.count_and_get

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);
5943: x_return_status := FND_API.G_RET_STS_ERROR;
5944: return 0;

Line 5949: FND_MSG_PUB.ADD;

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);
5953: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5950: fnd_msg_pub.count_and_get

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);
5953: x_return_status := FND_API.G_RET_STS_ERROR;
5954: return 0;

Line 6108: FND_MSG_PUB.ADD;

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);
6112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6109: fnd_msg_pub.count_and_get

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);
6112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6113: return;

Line 6284: fnd_msg_pub.initialize;

6280: l_check_alternates BOOLEAN := FALSE;
6281: BEGIN
6282: log('check_parts_availability', 'BEGIN');
6283: g_schedular_call := 'N';
6284: fnd_msg_pub.initialize;
6285: IF p_timezone_id IS NOT NULL THEN
6286: g_shipto_timezone_id := p_timezone_id;
6287: END IF;
6288: l_resources := CSP_SCH_INT_PVT.csp_sch_resource_tbl_typ();

Line 6453: FND_MSG_PUB.ADD;

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');
6457: l_res_ids(l_res_ids.count+1) := l_reservation_id ;

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

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');
6457: l_res_ids(l_res_ids.count+1) := l_reservation_id ;
6458: log('check_parts_availability', 'l_res_ids.count: '||l_res_ids.count);

Line 6607: FND_MSG_PUB.ADD;

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

Line 6608: fnd_msg_pub.count_and_get ( p_count => x_msg_count , p_data => 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 ;
6611: END IF;
6612: END IF;

Line 6747: FND_MSG_PUB.ADD;

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

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

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;
6751: END IF;
6752: ELSE

Line 6982: FND_MSG_PUB.ADD;

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;
6986: END check_parts_availability;

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

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;
6986: END check_parts_availability;
6987:

Line 7062: FND_MSG_PUB.ADD;

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);
7066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7063: fnd_msg_pub.count_and_get

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);
7066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7067: return;

Line 7697: FND_MSG_PUB.ADD;

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

Line 7698: fnd_msg_pub.count_and_get

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

Line 8326: FND_MSG_PUB.ADD;

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);
8330: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8327: fnd_msg_pub.count_and_get

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);
8330: x_return_status := FND_API.G_RET_STS_ERROR;
8331: WHEN OTHERS THEN

Line 8439: FND_MSG_PUB.ADD;

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

Line 8440: fnd_msg_pub.count_and_get

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);
8443: return;
8444: end if;

Line 8465: FND_MSG_PUB.ADD;

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

Line 8466: fnd_msg_pub.count_and_get

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);
8469: return;
8470: end if;

Line 8495: FND_MSG_PUB.ADD;

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

Line 8496: fnd_msg_pub.count_and_get

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);
8499: return;
8500: end if;

Line 8514: FND_MSG_PUB.ADD;

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

Line 8515: fnd_msg_pub.count_and_get

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);
8518: return;
8519: end if;

Line 8543: FND_MSG_PUB.ADD;

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

Line 8544: fnd_msg_pub.count_and_get

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);
8547: return;
8548: end if;

Line 8601: FND_MSG_PUB.ADD;

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

Line 8602: fnd_msg_pub.count_and_get

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);
8605: return;
8606: end if;