APPS.CSP_PARTS_REQUIREMENT dependencies on FND_MSG_PUB

Line 225: FND_MSG_PUB.initialize;

221: SAVEPOINT Process_Requirement_PUB;
222:
223: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
224: -- initialize message list
225: FND_MSG_PUB.initialize;
226: END IF;
227:
228: -- Standard call to check for call compatibility.
229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 289: for j in 1..fnd_msg_pub.count_msg loop

285: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
286: null; --RAISE FND_API.G_EXC_ERROR;
287: END IF;
288: if l_msg_count > 0 THEN
289: for j in 1..fnd_msg_pub.count_msg loop
290: fnd_msg_pub.get(
291: j,
292: FND_API.G_FALSE,
293: l_msg_data,

Line 290: fnd_msg_pub.get(

286: null; --RAISE FND_API.G_EXC_ERROR;
287: END IF;
288: if l_msg_count > 0 THEN
289: for j in 1..fnd_msg_pub.count_msg loop
290: fnd_msg_pub.get(
291: j,
292: FND_API.G_FALSE,
293: l_msg_data,
294: l_msg_dummy);

Line 349: FND_MSG_PUB.ADD;

345: ELSE
346: -- raise error, either ship to location or resource must be specified
347: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
348: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'resource or task assignment or ship to location', FALSE);
349: FND_MSG_PUB.ADD;
350: RAISE EXCP_USER_DEFINED;
351: END If;
352: ELSE
353: BEGIN

Line 397: for j in 1..fnd_msg_pub.count_msg loop

393: px_header_rec.order_header_id := l_header_Rec.order_header_id;
394: l_order_msg := null;
395: ELSE
396: l_rqmt_header_rec.open_requirement := 'E';
397: for j in 1..fnd_msg_pub.count_msg loop
398: fnd_msg_pub.get(
399: j,
400: FND_API.G_FALSE,
401: l_msg_data,

Line 398: fnd_msg_pub.get(

394: l_order_msg := null;
395: ELSE
396: l_rqmt_header_rec.open_requirement := 'E';
397: for j in 1..fnd_msg_pub.count_msg loop
398: fnd_msg_pub.get(
399: j,
400: FND_API.G_FALSE,
401: l_msg_data,
402: l_msg_dummy);

Line 416: FND_MSG_PUB.ADD;

412: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
413: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
414: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
415: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);
416: FND_MSG_PUB.ADD;
417: RAISE EXCP_USER_DEFINED;
418: ELSE
419: BEGIN
420: select requirement_header_id

Line 429: FND_MSG_PUB.ADD;

425: WHEN NO_DATA_FOUND THEN
426: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
427: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
428:
429: FND_MSG_PUB.ADD;
430: RAISE EXCP_USER_DEFINED;
431: WHEN OTHERS THEN
432: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
433: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);

Line 436: FND_MSG_PUB.ADD;

432: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
433: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
434: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
435: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
436: FND_MSG_PUB.ADD;
437: RAISE EXCP_USER_DEFINED;
438: END;
439: END IF;
440: END IF;

Line 481: FND_MSG_PUB.ADD;

477: and (l_header_Rec.resource_id is null
478: or l_header_rec.resource_type is null) then
479: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
480: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_Rec.resource_id', FALSE);
481: FND_MSG_PUB.ADD;
482: RAISE EXCP_USER_DEFINED;
483: end if;
484:
485: --IF (l_header_Rec.task_assignment_id IS NULL) THEN

Line 502: FND_MSG_PUB.ADD;

498: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
499:
500: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
501: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
502: FND_MSG_PUB.ADD;
503: RAISE EXCP_USER_DEFINED;
504: ELSE
505: BEGIN
506: select requirement_line_id

Line 515: FND_MSG_PUB.ADD;

511: WHEN NO_DATA_FOUND THEN
512: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
513: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
514:
515: FND_MSG_PUB.ADD;
516: RAISE EXCP_USER_DEFINED;
517: WHEN OTHERS THEN
518: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
519: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

Line 522: FND_MSG_PUB.ADD;

518: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
519: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
520: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
521: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
522: FND_MSG_PUB.ADD;
523: RAISE EXCP_USER_DEFINED;
524: END;
525: END IF;
526: END IF;

Line 757: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

753: WHEN FND_API.G_EXC_ERROR THEN
754: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
755: P_API_NAME => L_API_NAME
756: ,P_PKG_NAME => G_PKG_NAME
757: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
758: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
759: ,X_MSG_COUNT => X_MSG_COUNT
760: ,X_MSG_DATA => X_MSG_DATA
761: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
764: P_API_NAME => L_API_NAME
765: ,P_PKG_NAME => G_PKG_NAME
766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
767: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
768: ,X_MSG_COUNT => X_MSG_COUNT
769: ,X_MSG_DATA => X_MSG_DATA
770: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 776: FND_MSG_PUB.ADD;

772: Rollback to process_requirement_pub;
773: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
774: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
775: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
776: FND_MSG_PUB.ADD;
777: fnd_msg_pub.count_and_get
778: ( p_count => x_msg_count
779: , p_data => x_msg_data);
780: x_return_status := FND_API.G_RET_STS_ERROR;

Line 777: fnd_msg_pub.count_and_get

773: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
774: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
775: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
776: FND_MSG_PUB.ADD;
777: fnd_msg_pub.count_and_get
778: ( p_count => x_msg_count
779: , p_data => x_msg_data);
780: x_return_status := FND_API.G_RET_STS_ERROR;
781:

Line 849: FND_MSG_PUB.initialize;

845: SAVEPOINT csptrreq_fm_order_PUB;
846:
847: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
848: -- initialize message list
849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: -- Standard call to check for call compatibility.
853: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 964: FND_MSG_PUB.ADD;

960:
961: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
962: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
963:
964: FND_MSG_PUB.ADD;
965: RAISE EXCP_USER_DEFINED;
966: ELSE
967: BEGIN
968: select requirement_line_id

Line 976: FND_MSG_PUB.ADD;

972: EXCEPTION
973: WHEN NO_DATA_FOUND THEN
974: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
975: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
976: FND_MSG_PUB.ADD;
977: RAISE EXCP_USER_DEFINED;
978: WHEN OTHERS THEN
979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
980: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

Line 983: FND_MSG_PUB.ADD;

979: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
980: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
981: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
982: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
983: FND_MSG_PUB.ADD;
984: RAISE EXCP_USER_DEFINED;
985: END;
986: END IF;
987:

Line 1030: FND_MSG_PUB.ADD;

1026:
1027: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1028: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
1029:
1030: FND_MSG_PUB.ADD;
1031: RAISE EXCP_USER_DEFINED;
1032: ELSE
1033: BEGIN
1034: select requirement_line_id

Line 1042: FND_MSG_PUB.ADD;

1038: EXCEPTION
1039: WHEN NO_DATA_FOUND THEN
1040: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
1041: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1042: FND_MSG_PUB.ADD;
1043: RAISE EXCP_USER_DEFINED;
1044: WHEN OTHERS THEN
1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1046: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

Line 1049: FND_MSG_PUB.ADD;

1045: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1046: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1047: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1048: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1049: FND_MSG_PUB.ADD;
1050: RAISE EXCP_USER_DEFINED;
1051: END;
1052: END IF;
1053:

Line 1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1094: WHEN FND_API.G_EXC_ERROR THEN
1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1096: P_API_NAME => L_API_NAME
1097: ,P_PKG_NAME => G_PKG_NAME
1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1100: ,X_MSG_COUNT => X_MSG_COUNT
1101: ,X_MSG_DATA => X_MSG_DATA
1102: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1107: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1104: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1105: P_API_NAME => L_API_NAME
1106: ,P_PKG_NAME => G_PKG_NAME
1107: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1108: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1109: ,X_MSG_COUNT => X_MSG_COUNT
1110: ,X_MSG_DATA => X_MSG_DATA
1111: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1117: FND_MSG_PUB.ADD;

1113: Rollback to csptrreq_fm_order_PUB;
1114: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1115: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1116: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1117: FND_MSG_PUB.ADD;
1118: fnd_msg_pub.count_and_get
1119: ( p_count => x_msg_count
1120: , p_data => x_msg_data);
1121: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1118: fnd_msg_pub.count_and_get

1114: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1115: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1116: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1117: FND_MSG_PUB.ADD;
1118: fnd_msg_pub.count_and_get
1119: ( p_count => x_msg_count
1120: , p_data => x_msg_data);
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122:

Line 1184: FND_MSG_PUB.initialize;

1180: SAVEPOINT csptrreq_fm_order_PUB;
1181:
1182: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1183: -- initialize message list
1184: FND_MSG_PUB.initialize;
1185: END IF;
1186:
1187: -- Standard call to check for call compatibility.
1188: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1416: WHEN FND_API.G_EXC_ERROR THEN
1417: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1418: P_API_NAME => L_API_NAME
1419: ,P_PKG_NAME => G_PKG_NAME
1420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1421: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1422: ,X_MSG_COUNT => X_MSG_COUNT
1423: ,X_MSG_DATA => X_MSG_DATA
1424: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1429: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1426: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1427: P_API_NAME => L_API_NAME
1428: ,P_PKG_NAME => G_PKG_NAME
1429: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1430: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1431: ,X_MSG_COUNT => X_MSG_COUNT
1432: ,X_MSG_DATA => X_MSG_DATA
1433: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1439: FND_MSG_PUB.ADD;

1435: Rollback to csptrreq_fm_order_PUB;
1436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1439: FND_MSG_PUB.ADD;
1440: fnd_msg_pub.count_and_get
1441: ( p_count => x_msg_count
1442: , p_data => x_msg_data);
1443: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1440: fnd_msg_pub.count_and_get

1436: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1437: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1438: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1439: FND_MSG_PUB.ADD;
1440: fnd_msg_pub.count_and_get
1441: ( p_count => x_msg_count
1442: , p_data => x_msg_data);
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END;

Line 1464: FND_MSG_PUB.initialize;

1460: SAVEPOINT delete_rqmt_header_PUB;
1461:
1462: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1463: -- initialize message list
1464: FND_MSG_PUB.initialize;
1465: END IF;
1466:
1467: -- Standard call to check for call compatibility.
1468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1489: FND_MSG_PUB.ADD;

1485:
1486: IF l_count > 0 THEN
1487: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
1488: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1489: FND_MSG_PUB.ADD;
1490: RAISE EXCP_USER_DEFINED;
1491: ELSE
1492: DELETE FROM csp_requirement_lines
1493: WHERE requirement_header_id = p_header_id;

Line 1508: fnd_msg_pub.count_and_get

1504: EXCEPTION
1505: WHEN EXCP_USER_DEFINED THEN
1506: Rollback to delete_rqmt_header_PUB;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: fnd_msg_pub.count_and_get
1509: ( p_count => x_msg_count
1510: , p_data => x_msg_data);
1511:
1512: WHEN FND_API.G_EXC_ERROR THEN

Line 1516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1512: WHEN FND_API.G_EXC_ERROR THEN
1513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1514: P_API_NAME => L_API_NAME
1515: ,P_PKG_NAME => G_PKG_NAME
1516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1518: ,X_MSG_COUNT => X_MSG_COUNT
1519: ,X_MSG_DATA => X_MSG_DATA
1520: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1523: P_API_NAME => L_API_NAME
1524: ,P_PKG_NAME => G_PKG_NAME
1525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1527: ,X_MSG_COUNT => X_MSG_COUNT
1528: ,X_MSG_DATA => X_MSG_DATA
1529: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1535: FND_MSG_PUB.ADD;

1531: Rollback to delete_rqmt_header_PUB;
1532: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1533: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1534: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1535: FND_MSG_PUB.ADD;
1536: fnd_msg_pub.count_and_get
1537: ( p_count => x_msg_count
1538: , p_data => x_msg_data);
1539: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1536: fnd_msg_pub.count_and_get

1532: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1533: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1534: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1535: FND_MSG_PUB.ADD;
1536: fnd_msg_pub.count_and_get
1537: ( p_count => x_msg_count
1538: , p_data => x_msg_data);
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: END;

Line 1612: FND_MSG_PUB.initialize;

1608: SAVEPOINT save_rqmt_line_PUB;
1609:
1610: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1611: -- initialize message list
1612: FND_MSG_PUB.initialize;
1613: END IF;
1614:
1615: -- Standard call to check for call compatibility.
1616: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1647: FND_MSG_PUB.ADD;

1643: WHERE user_id = l_user_id;
1644: EXCEPTION
1645: WHEN no_Data_found THEN
1646: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RS_USER_NOT_DEFINED');
1647: FND_MSG_PUB.ADD;
1648: RAISE EXCP_USER_DEFINED;
1649: END;
1650:
1651: /* BEGIN

Line 1659: FND_MSG_PUB.ADD;

1655: WHERE resource_id = l_header_rec.resource_id;
1656: EXCEPTION
1657: WHEN no_Data_found THEN
1658: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_RES_ID_TYPE');
1659: FND_MSG_PUB.ADD;
1660: RAISE EXCP_USER_DEFINED;
1661: END;
1662: */
1663: -- Since wireless deals with employee type resources only, hardcode resource type

Line 1679: FND_MSG_PUB.ADD;

1675:
1676: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1677: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1678: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1679: FND_MSG_PUB.ADD;
1680: RAISE EXCP_USER_DEFINED;
1681: WHEN TOO_MANY_ROWS THEN
1682:
1683: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ONE_DEFAULT_IN_ALLOWED');

Line 1684: FND_MSG_PUB.ADD;

1680: RAISE EXCP_USER_DEFINED;
1681: WHEN TOO_MANY_ROWS THEN
1682:
1683: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ONE_DEFAULT_IN_ALLOWED');
1684: FND_MSG_PUB.ADD;
1685: RAISE EXCP_USER_DEFINED;
1686: END;
1687:
1688: IF (l_header_rec.task_id IS NOT NULL) THEN

Line 1699: FND_MSG_PUB.ADD;

1695: WHEN NO_DATA_FOUND THEN
1696:
1697: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETER');
1698: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Service Request');
1699: FND_MSG_PUB.ADD;
1700: RAISE EXCP_USER_DEFINED;
1701: END;
1702: END IF;
1703:

Line 1798: --FND_MSG_PUB.ADD;

1794:
1795: IF (l_requirement_header_id IS NOT NULL) THEN
1796: Rollback to save_rqmt_line_PUB;
1797: --FND_MESSAGE.SET_NAME('CSP', 'CSP_TASK_RQMT_EXISTS');
1798: --FND_MSG_PUB.ADD;
1799: --fnd_msg_pub.count_and_get
1800: -- ( p_count => x_msg_count
1801: -- , p_data => x_msg_data);
1802: x_msg_data := fnd_message.get_string('CSP', 'CSP_TASK_RQMT_EXISTS');

Line 1799: --fnd_msg_pub.count_and_get

1795: IF (l_requirement_header_id IS NOT NULL) THEN
1796: Rollback to save_rqmt_line_PUB;
1797: --FND_MESSAGE.SET_NAME('CSP', 'CSP_TASK_RQMT_EXISTS');
1798: --FND_MSG_PUB.ADD;
1799: --fnd_msg_pub.count_and_get
1800: -- ( p_count => x_msg_count
1801: -- , p_data => x_msg_data);
1802: x_msg_data := fnd_message.get_string('CSP', 'CSP_TASK_RQMT_EXISTS');
1803: x_return_status := 'E';

Line 1822: fnd_msg_pub.count_and_get

1818: X_Msg_Data => l_msg_data
1819: );
1820:
1821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1822: fnd_msg_pub.count_and_get
1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data);
1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826: return;

Line 1865: FND_MSG_PUB.ADD;

1861: EXCEPTION
1862: WHEN NO_DATA_FOUND THEN
1863: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
1864: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1865: FND_MSG_PUB.ADD;
1866: RAISE EXCP_USER_DEFINED;
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1869: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);

Line 1872: FND_MSG_PUB.ADD;

1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1869: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1870: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1871: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1872: FND_MSG_PUB.ADD;
1873: RAISE EXCP_USER_DEFINED;
1874: END;
1875:
1876: l_rqmt_header_Rec.requirement_header_id := l_header_rec.requirement_header_id;

Line 1919: FND_MSG_PUB.ADD;

1915: from csp_requirement_lines
1916: where requirement_line_id = l_rqmt_line_rec.requirement_line_id;
1917: IF l_count > 0 THEN
1918: fnd_message.set_name('CSP', 'CSP_DUPLICATE_RQMT_LINE');
1919: FND_MSG_PUB.ADD;
1920: RAISE EXCP_USER_DEFINED;
1921: END IF;
1922: EXCEPTION
1923: WHEN NO_DATA_FOUND THEN

Line 1999: fnd_msg_pub.count_and_get

1995: EXCEPTION
1996: WHEN EXCP_USER_DEFINED THEN
1997: Rollback to save_rqmt_line_PUB;
1998: x_return_status := FND_API.G_RET_STS_ERROR;
1999: fnd_msg_pub.count_and_get
2000: ( p_count => x_msg_count
2001: , p_data => x_msg_data);
2002:
2003: WHEN FND_API.G_EXC_ERROR THEN

Line 2007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2003: WHEN FND_API.G_EXC_ERROR THEN
2004: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2005: P_API_NAME => L_API_NAME
2006: ,P_PKG_NAME => G_PKG_NAME
2007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2008: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2009: ,X_MSG_COUNT => X_MSG_COUNT
2010: ,X_MSG_DATA => X_MSG_DATA
2011: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2017: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2014: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2015: P_API_NAME => L_API_NAME
2016: ,P_PKG_NAME => G_PKG_NAME
2017: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2018: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2019: ,X_MSG_COUNT => X_MSG_COUNT
2020: ,X_MSG_DATA => X_MSG_DATA
2021: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2027: FND_MSG_PUB.ADD;

2023: Rollback to save_rqmt_line_PUB;
2024: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2025: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2026: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2027: FND_MSG_PUB.ADD;
2028: fnd_msg_pub.count_and_get
2029: ( p_count => x_msg_count
2030: , p_data => x_msg_data);
2031: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2028: fnd_msg_pub.count_and_get

2024: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2025: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2026: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2027: FND_MSG_PUB.ADD;
2028: fnd_msg_pub.count_and_get
2029: ( p_count => x_msg_count
2030: , p_data => x_msg_data);
2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032: END;

Line 2051: FND_MSG_PUB.initialize;

2047: SAVEPOINT delete_rqmt_line_PUB;
2048:
2049: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2050: -- initialize message list
2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:
2054: -- Standard call to check for call compatibility.
2055: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2080: WHEN FND_API.G_EXC_ERROR THEN
2081: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2082: P_API_NAME => L_API_NAME
2083: ,P_PKG_NAME => G_PKG_NAME
2084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2085: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2086: ,X_MSG_COUNT => X_MSG_COUNT
2087: ,X_MSG_DATA => X_MSG_DATA
2088: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2093: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2090: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2091: P_API_NAME => L_API_NAME
2092: ,P_PKG_NAME => G_PKG_NAME
2093: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2094: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2095: ,X_MSG_COUNT => X_MSG_COUNT
2096: ,X_MSG_DATA => X_MSG_DATA
2097: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2103: FND_MSG_PUB.ADD;

2099: Rollback to delete_rqmt_line_PUB;
2100: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2101: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2102: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2103: FND_MSG_PUB.ADD;
2104: fnd_msg_pub.count_and_get
2105: ( p_count => x_msg_count
2106: , p_data => x_msg_data);
2107: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2104: fnd_msg_pub.count_and_get

2100: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2101: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2102: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2103: FND_MSG_PUB.ADD;
2104: fnd_msg_pub.count_and_get
2105: ( p_count => x_msg_count
2106: , p_data => x_msg_data);
2107: x_return_status := FND_API.G_RET_STS_ERROR;
2108: END;

Line 2154: FND_MSG_PUB.initialize;

2150: SAVEPOINT check_Availability_PUB;
2151:
2152: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2153: -- initialize message list
2154: FND_MSG_PUB.initialize;
2155: END IF;
2156:
2157: -- Standard call to check for call compatibility.
2158: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2197: FND_MSG_PUB.ADD;

2193: EXCEPTION
2194: WHEN no_data_found THEN
2195: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2196: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2197: FND_MSG_PUB.ADD;
2198: RAISE EXCP_USER_DEFINED;
2199: END;
2200:
2201: OPEN rqmt_line_cur;

Line 2219: FND_MSG_PUB.initialize;

2215: I := I + 1;
2216: END LOOP;
2217:
2218: IF (l_parts_list_Tbl.count > 0) THEN
2219: FND_MSG_PUB.initialize;
2220: -- call csp_sch_int_pvt.check_parts_availability()
2221: csp_sch_int_pvt.check_parts_availability(
2222: p_resource => null,
2223: p_organization_id => l_header_rec.dest_organization_id,

Line 2332: fnd_msg_pub.count_and_get

2328: EXCEPTION
2329: WHEN EXCP_USER_DEFINED THEN
2330: Rollback to check_Availability_PUB;
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332: fnd_msg_pub.count_and_get
2333: ( p_count => x_msg_count
2334: , p_data => x_msg_data);
2335:
2336: WHEN FND_API.G_EXC_ERROR THEN

Line 2340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2336: WHEN FND_API.G_EXC_ERROR THEN
2337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2338: P_API_NAME => L_API_NAME
2339: ,P_PKG_NAME => G_PKG_NAME
2340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2342: ,X_MSG_COUNT => X_MSG_COUNT
2343: ,X_MSG_DATA => X_MSG_DATA
2344: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2347: P_API_NAME => L_API_NAME
2348: ,P_PKG_NAME => G_PKG_NAME
2349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2350: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2351: ,X_MSG_COUNT => X_MSG_COUNT
2352: ,X_MSG_DATA => X_MSG_DATA
2353: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2359: FND_MSG_PUB.ADD;

2355: Rollback to check_Availability_pub;
2356: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2357: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2358: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2359: FND_MSG_PUB.ADD;
2360: fnd_msg_pub.count_and_get
2361: ( p_count => x_msg_count
2362: , p_data => x_msg_data);
2363: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2360: fnd_msg_pub.count_and_get

2356: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2357: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2358: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2359: FND_MSG_PUB.ADD;
2360: fnd_msg_pub.count_and_get
2361: ( p_count => x_msg_count
2362: , p_data => x_msg_data);
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: END;

Line 2426: FND_MSG_PUB.initialize;

2422: SAVEPOINT create_order_PUB;
2423:
2424: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2425: -- initialize message list
2426: FND_MSG_PUB.initialize;
2427: END IF;
2428:
2429: -- Standard call to check for call compatibility.
2430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2506: FND_MSG_PUB.ADD;

2502: EXCEPTION
2503: WHEN no_data_found THEN
2504: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2505: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2506: FND_MSG_PUB.ADD;
2507: RAISE EXCP_USER_DEFINED;
2508: END;
2509:
2510: OPEN rqmt_line_cur;

Line 2545: fnd_msg_pub.add;

2541:
2542: EXIT WHEN rqmt_line_cur%NOTFOUND;
2543: IF (l_line_rec.sourced_From = 'IO' and l_line_rec.source_organization_id IS NULL) THEN
2544: fnd_message.set_name('CSP', 'CSP_NULL_SRC_ORGN');
2545: fnd_msg_pub.add;
2546: RAISE EXCP_USER_DEFINED;
2547: END If;
2548: l_line_rec.ordered_quantity := l_line_Rec.quantity;
2549: IF (l_line_rec.sourced_from = 'IO') THEN

Line 2713: fnd_msg_pub.count_and_get

2709: EXCEPTION
2710: WHEN EXCP_USER_DEFINED THEN
2711: Rollback to create_order_PUB;
2712: x_return_status := FND_API.G_RET_STS_ERROR;
2713: fnd_msg_pub.count_and_get
2714: ( p_count => x_msg_count
2715: , p_data => x_msg_data);
2716:
2717: WHEN FND_API.G_EXC_ERROR THEN

Line 2721: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2717: WHEN FND_API.G_EXC_ERROR THEN
2718: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2719: P_API_NAME => L_API_NAME
2720: ,P_PKG_NAME => G_PKG_NAME
2721: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2722: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2723: ,X_MSG_COUNT => X_MSG_COUNT
2724: ,X_MSG_DATA => X_MSG_DATA
2725: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2727: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2728: P_API_NAME => L_API_NAME
2729: ,P_PKG_NAME => G_PKG_NAME
2730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2731: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2732: ,X_MSG_COUNT => X_MSG_COUNT
2733: ,X_MSG_DATA => X_MSG_DATA
2734: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2740: FND_MSG_PUB.ADD;

2736: Rollback to create_order_PUB;
2737: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2738: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2739: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2740: FND_MSG_PUB.ADD;
2741: fnd_msg_pub.count_and_get
2742: ( p_count => x_msg_count
2743: , p_data => x_msg_data);
2744: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2741: fnd_msg_pub.count_and_get

2737: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2738: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2739: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2740: FND_MSG_PUB.ADD;
2741: fnd_msg_pub.count_and_get
2742: ( p_count => x_msg_count
2743: , p_data => x_msg_data);
2744: x_return_status := FND_API.G_RET_STS_ERROR;
2745: END;

Line 2982: FND_MSG_PUB.ADD;

2978:
2979: if l_dummy > 0 then
2980: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_ORDER_MSG');
2981: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
2982: FND_MSG_PUB.ADD;
2983: raise EXCP_USER_DEFINED;
2984: end if;
2985: end loop;
2986: close check_IO_booked;

Line 3016: FND_MSG_PUB.ADD;

3012: if l_ship_to_type = 'R' or l_ship_to_type = 'S' then
3013: -- raise an error message
3014: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_SHIP_MSG');
3015: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3016: FND_MSG_PUB.ADD;
3017: raise EXCP_USER_DEFINED;
3018: end if;
3019:
3020: -- check new and old INV org in same OU

Line 3037: FND_MSG_PUB.ADD;

3033:
3034: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
3035: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_resource_type_name, TRUE);
3036: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name, TRUE);
3037: FND_MSG_PUB.ADD;
3038: raise EXCP_USER_DEFINED;
3039: end if;
3040:
3041: SELECT operating_unit

Line 3050: FND_MSG_PUB.ADD;

3046: if l_old_dest_OU <> l_new_dest_OU then
3047: -- raise an error message
3048: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASGN_OU_MSG');
3049: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3050: FND_MSG_PUB.ADD;
3051: raise EXCP_USER_DEFINED;
3052: end if;
3053:
3054: UPDATE po_requisition_lines_all

Line 3085: FND_MSG_PUB.ADD;

3081: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3082: rollback to csp_correct_req_record;
3083: FND_MESSAGE.SET_NAME('CSP', 'CSP_MAN_NOT_CANCEL_RESERV');
3084: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3085: FND_MSG_PUB.ADD;
3086: raise EXCP_USER_DEFINED;
3087: else
3088: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_dtl_id);
3089: end if;

Line 3201: FND_MSG_PUB.ADD;

3197: -- then stop reassignment
3198: if l_booking_start_date is null or l_booking_start_date <= sysdate then
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DATE_PST_ASSGN');
3201: FND_MSG_PUB.ADD;
3202: fnd_msg_pub.count_and_get
3203: ( p_count => x_msg_count
3204: , p_data => x_msg_data);
3205: return;

Line 3202: fnd_msg_pub.count_and_get

3198: if l_booking_start_date is null or l_booking_start_date <= sysdate then
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DATE_PST_ASSGN');
3201: FND_MSG_PUB.ADD;
3202: fnd_msg_pub.count_and_get
3203: ( p_count => x_msg_count
3204: , p_data => x_msg_data);
3205: return;
3206: end if;

Line 3233: FND_MSG_PUB.ADD;

3229:
3230: if l_partial_line > 0 then
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3233: FND_MSG_PUB.ADD;
3234: fnd_msg_pub.count_and_get
3235: ( p_count => x_msg_count
3236: , p_data => x_msg_data);
3237: return;

Line 3234: fnd_msg_pub.count_and_get

3230: if l_partial_line > 0 then
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3233: FND_MSG_PUB.ADD;
3234: fnd_msg_pub.count_and_get
3235: ( p_count => x_msg_count
3236: , p_data => x_msg_data);
3237: return;
3238: end if;

Line 3292: FND_MSG_PUB.ADD;

3288:
3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3291: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3292: FND_MSG_PUB.ADD;
3293: fnd_msg_pub.count_and_get
3294: ( p_count => x_msg_count
3295: , p_data => x_msg_data);
3296: return;

Line 3293: fnd_msg_pub.count_and_get

3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3291: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3292: FND_MSG_PUB.ADD;
3293: fnd_msg_pub.count_and_get
3294: ( p_count => x_msg_count
3295: , p_data => x_msg_data);
3296: return;
3297: end if;

Line 3366: FND_MSG_PUB.ADD;

3362:
3363: if l_fl_rcvd_multi_source > 0 then
3364: x_return_status := FND_API.G_RET_STS_ERROR;
3365: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3366: FND_MSG_PUB.ADD;
3367: fnd_msg_pub.count_and_get
3368: ( p_count => x_msg_count
3369: , p_data => x_msg_data);
3370: return;

Line 3367: fnd_msg_pub.count_and_get

3363: if l_fl_rcvd_multi_source > 0 then
3364: x_return_status := FND_API.G_RET_STS_ERROR;
3365: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3366: FND_MSG_PUB.ADD;
3367: fnd_msg_pub.count_and_get
3368: ( p_count => x_msg_count
3369: , p_data => x_msg_data);
3370: return;
3371: end if;

Line 3418: FND_MSG_PUB.ADD;

3414:
3415: if l_oth_req_line > 0 then
3416: x_return_status := FND_API.G_RET_STS_ERROR;
3417: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3418: FND_MSG_PUB.ADD;
3419: fnd_msg_pub.count_and_get
3420: ( p_count => x_msg_count
3421: , p_data => x_msg_data);
3422: return;

Line 3419: fnd_msg_pub.count_and_get

3415: if l_oth_req_line > 0 then
3416: x_return_status := FND_API.G_RET_STS_ERROR;
3417: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3418: FND_MSG_PUB.ADD;
3419: fnd_msg_pub.count_and_get
3420: ( p_count => x_msg_count
3421: , p_data => x_msg_data);
3422: return;
3423: end if;

Line 3493: FND_MSG_PUB.ADD;

3489: end if;
3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3493: FND_MSG_PUB.ADD;
3494: fnd_msg_pub.count_and_get
3495: ( p_count => x_msg_count
3496: , p_data => x_msg_data);
3497: end if;

Line 3494: fnd_msg_pub.count_and_get

3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3493: FND_MSG_PUB.ADD;
3494: fnd_msg_pub.count_and_get
3495: ( p_count => x_msg_count
3496: , p_data => x_msg_data);
3497: end if;
3498: return;

Line 3558: FND_MSG_PUB.ADD;

3554:
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3557: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3558: FND_MSG_PUB.ADD;
3559: fnd_msg_pub.count_and_get
3560: ( p_count => x_msg_count
3561: , p_data => x_msg_data);
3562: return;

Line 3559: fnd_msg_pub.count_and_get

3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3557: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3558: FND_MSG_PUB.ADD;
3559: fnd_msg_pub.count_and_get
3560: ( p_count => x_msg_count
3561: , p_data => x_msg_data);
3562: return;
3563: else

Line 3592: FND_MSG_PUB.ADD;

3588:
3589: if l_ship_multi_src > 0 then
3590: x_return_status := FND_API.G_RET_STS_ERROR;
3591: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3592: FND_MSG_PUB.ADD;
3593: fnd_msg_pub.count_and_get
3594: ( p_count => x_msg_count
3595: , p_data => x_msg_data);
3596: return;

Line 3593: fnd_msg_pub.count_and_get

3589: if l_ship_multi_src > 0 then
3590: x_return_status := FND_API.G_RET_STS_ERROR;
3591: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3592: FND_MSG_PUB.ADD;
3593: fnd_msg_pub.count_and_get
3594: ( p_count => x_msg_count
3595: , p_data => x_msg_data);
3596: return;
3597: end if;

Line 3635: FND_MSG_PUB.ADD;

3631:
3632: if l_oth_req_line > 0 then
3633: x_return_status := FND_API.G_RET_STS_ERROR;
3634: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3635: FND_MSG_PUB.ADD;
3636: fnd_msg_pub.count_and_get
3637: ( p_count => x_msg_count
3638: , p_data => x_msg_data);
3639: return;

Line 3636: fnd_msg_pub.count_and_get

3632: if l_oth_req_line > 0 then
3633: x_return_status := FND_API.G_RET_STS_ERROR;
3634: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3635: FND_MSG_PUB.ADD;
3636: fnd_msg_pub.count_and_get
3637: ( p_count => x_msg_count
3638: , p_data => x_msg_data);
3639: return;
3640: end if;

Line 3723: FND_MSG_PUB.ADD;

3719:
3720: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3721: x_return_status := FND_API.G_RET_STS_ERROR;
3722: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3723: FND_MSG_PUB.ADD;
3724: fnd_msg_pub.count_and_get
3725: ( p_count => x_msg_count
3726: , p_data => x_msg_data);
3727: return;

Line 3724: fnd_msg_pub.count_and_get

3720: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3721: x_return_status := FND_API.G_RET_STS_ERROR;
3722: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3723: FND_MSG_PUB.ADD;
3724: fnd_msg_pub.count_and_get
3725: ( p_count => x_msg_count
3726: , p_data => x_msg_data);
3727: return;
3728: end if;

Line 3734: FND_MSG_PUB.ADD;

3730: else
3731: x_return_status := FND_API.G_RET_STS_ERROR;
3732: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3733: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3734: FND_MSG_PUB.ADD;
3735: fnd_msg_pub.count_and_get
3736: ( p_count => x_msg_count
3737: , p_data => x_msg_data);
3738: return;

Line 3735: fnd_msg_pub.count_and_get

3731: x_return_status := FND_API.G_RET_STS_ERROR;
3732: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3733: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3734: FND_MSG_PUB.ADD;
3735: fnd_msg_pub.count_and_get
3736: ( p_count => x_msg_count
3737: , p_data => x_msg_data);
3738: return;
3739: end if;

Line 3816: FND_MSG_PUB.initialize;

3812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3813: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3814: end if;
3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3816: FND_MSG_PUB.initialize;
3817: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');
3819: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3820: FND_MSG_PUB.ADD;

Line 3820: FND_MSG_PUB.ADD;

3816: FND_MSG_PUB.initialize;
3817: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');
3819: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3820: FND_MSG_PUB.ADD;
3821: fnd_msg_pub.count_and_get
3822: ( p_count => x_msg_count
3823: , p_data => x_msg_data);
3824: end if;

Line 3821: fnd_msg_pub.count_and_get

3817: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');
3819: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);
3820: FND_MSG_PUB.ADD;
3821: fnd_msg_pub.count_and_get
3822: ( p_count => x_msg_count
3823: , p_data => x_msg_data);
3824: end if;
3825: end if;

Line 3873: FND_MSG_PUB.ADD;

3869:
3870: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3871: x_return_status := FND_API.G_RET_STS_ERROR;
3872: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3873: FND_MSG_PUB.ADD;
3874: fnd_msg_pub.count_and_get
3875: ( p_count => x_msg_count
3876: , p_data => x_msg_data);
3877: return;

Line 3874: fnd_msg_pub.count_and_get

3870: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3871: x_return_status := FND_API.G_RET_STS_ERROR;
3872: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3873: FND_MSG_PUB.ADD;
3874: fnd_msg_pub.count_and_get
3875: ( p_count => x_msg_count
3876: , p_data => x_msg_data);
3877: return;
3878: end if;

Line 3884: FND_MSG_PUB.ADD;

3880: else
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3883: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get
3886: ( p_count => x_msg_count
3887: , p_data => x_msg_data);
3888: return;

Line 3885: fnd_msg_pub.count_and_get

3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3883: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get
3886: ( p_count => x_msg_count
3887: , p_data => x_msg_data);
3888: return;
3889: end if;

Line 3894: FND_MSG_PUB.ADD;

3890: return;
3891: else
3892: x_return_status := FND_API.G_RET_STS_ERROR;
3893: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3894: FND_MSG_PUB.ADD;
3895: fnd_msg_pub.count_and_get
3896: ( p_count => x_msg_count
3897: , p_data => x_msg_data);
3898: END IF;

Line 3895: fnd_msg_pub.count_and_get

3891: else
3892: x_return_status := FND_API.G_RET_STS_ERROR;
3893: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3894: FND_MSG_PUB.ADD;
3895: fnd_msg_pub.count_and_get
3896: ( p_count => x_msg_count
3897: , p_data => x_msg_data);
3898: END IF;
3899: return;

Line 4034: FND_MSG_PUB.ADD;

4030: from oe_order_headers_all where header_id = l_oe_header_id;
4031:
4032: FND_MESSAGE.SET_NAME('CSP', 'CSP_IO_BOOK_ERROR');
4033: FND_MESSAGE.SET_TOKEN('ORDER_NUM', l_oe_order_num, TRUE);
4034: FND_MSG_PUB.ADD;
4035: raise EXCP_USER_DEFINED;
4036: end if;
4037:
4038: end if;

Line 4567: FND_MSG_PUB.ADD;

4563:
4564: if l_dtl_count > 0 then
4565: x_return_status := FND_API.G_RET_STS_ERROR;
4566: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
4567: FND_MSG_PUB.ADD;
4568: fnd_msg_pub.count_and_get
4569: ( p_count => x_msg_count
4570: , p_data => x_msg_data);
4571: raise EXCP_USER_DEFINED;

Line 4568: fnd_msg_pub.count_and_get

4564: if l_dtl_count > 0 then
4565: x_return_status := FND_API.G_RET_STS_ERROR;
4566: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
4567: FND_MSG_PUB.ADD;
4568: fnd_msg_pub.count_and_get
4569: ( p_count => x_msg_count
4570: , p_data => x_msg_data);
4571: raise EXCP_USER_DEFINED;
4572: end if;