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_PARTS_REQUIREMENT dependencies on FND_MSG_PUB

Line 222: FND_MSG_PUB.initialize;

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

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

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

Line 287: fnd_msg_pub.get(

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

Line 343: FND_MSG_PUB.ADD;

339: ELSE
340: -- raise error, either ship to location or resource must be specified
341: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'resource or task assignment or ship to location', FALSE);
343: FND_MSG_PUB.ADD;
344: RAISE EXCP_USER_DEFINED;
345: END If;
346: ELSE
347: BEGIN

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

387: px_header_rec.order_header_id := l_header_Rec.order_header_id;
388: l_order_msg := null;
389: ELSE
390: l_rqmt_header_rec.open_requirement := 'E';
391: for j in 1..fnd_msg_pub.count_msg loop
392: fnd_msg_pub.get(
393: j,
394: FND_API.G_FALSE,
395: l_msg_data,

Line 392: fnd_msg_pub.get(

388: l_order_msg := null;
389: ELSE
390: l_rqmt_header_rec.open_requirement := 'E';
391: for j in 1..fnd_msg_pub.count_msg loop
392: fnd_msg_pub.get(
393: j,
394: FND_API.G_FALSE,
395: l_msg_data,
396: l_msg_dummy);

Line 410: FND_MSG_PUB.ADD;

406: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
407: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
408: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
409: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);
410: FND_MSG_PUB.ADD;
411: RAISE EXCP_USER_DEFINED;
412: ELSE
413: BEGIN
414: select requirement_header_id

Line 423: FND_MSG_PUB.ADD;

419: WHEN NO_DATA_FOUND THEN
420: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
421: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
422:
423: FND_MSG_PUB.ADD;
424: RAISE EXCP_USER_DEFINED;
425: WHEN OTHERS THEN
426: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
427: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);

Line 430: FND_MSG_PUB.ADD;

426: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
427: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
428: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
429: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
430: FND_MSG_PUB.ADD;
431: RAISE EXCP_USER_DEFINED;
432: END;
433: END IF;
434: END IF;

Line 487: FND_MSG_PUB.ADD;

483: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
484:
485: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
486: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
487: FND_MSG_PUB.ADD;
488: RAISE EXCP_USER_DEFINED;
489: ELSE
490: BEGIN
491: select requirement_line_id

Line 500: FND_MSG_PUB.ADD;

496: WHEN NO_DATA_FOUND THEN
497: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
498: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
499:
500: FND_MSG_PUB.ADD;
501: RAISE EXCP_USER_DEFINED;
502: WHEN OTHERS THEN
503: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

Line 507: FND_MSG_PUB.ADD;

503: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
505: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
507: FND_MSG_PUB.ADD;
508: RAISE EXCP_USER_DEFINED;
509: END;
510: END IF;
511: END IF;

Line 742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

738: WHEN FND_API.G_EXC_ERROR THEN
739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
740: P_API_NAME => L_API_NAME
741: ,P_PKG_NAME => G_PKG_NAME
742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
749: P_API_NAME => L_API_NAME
750: ,P_PKG_NAME => G_PKG_NAME
751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
752: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
753: ,X_MSG_COUNT => X_MSG_COUNT
754: ,X_MSG_DATA => X_MSG_DATA
755: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 761: FND_MSG_PUB.ADD;

757: Rollback to process_requirement_pub;
758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
761: FND_MSG_PUB.ADD;
762: fnd_msg_pub.count_and_get
763: ( p_count => x_msg_count
764: , p_data => x_msg_data);
765: x_return_status := FND_API.G_RET_STS_ERROR;

Line 762: fnd_msg_pub.count_and_get

758: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
759: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
760: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
761: FND_MSG_PUB.ADD;
762: fnd_msg_pub.count_and_get
763: ( p_count => x_msg_count
764: , p_data => x_msg_data);
765: x_return_status := FND_API.G_RET_STS_ERROR;
766:

Line 834: FND_MSG_PUB.initialize;

830: SAVEPOINT csptrreq_fm_order_PUB;
831:
832: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
833: -- initialize message list
834: FND_MSG_PUB.initialize;
835: END IF;
836:
837: -- Standard call to check for call compatibility.
838: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 949: FND_MSG_PUB.ADD;

945:
946: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
948:
949: FND_MSG_PUB.ADD;
950: RAISE EXCP_USER_DEFINED;
951: ELSE
952: BEGIN
953: select requirement_line_id

Line 961: FND_MSG_PUB.ADD;

957: EXCEPTION
958: WHEN NO_DATA_FOUND THEN
959: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
960: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
961: FND_MSG_PUB.ADD;
962: RAISE EXCP_USER_DEFINED;
963: WHEN OTHERS THEN
964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

Line 968: FND_MSG_PUB.ADD;

964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
966: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
968: FND_MSG_PUB.ADD;
969: RAISE EXCP_USER_DEFINED;
970: END;
971: END IF;
972:

Line 1015: FND_MSG_PUB.ADD;

1011:
1012: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1013: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
1014:
1015: FND_MSG_PUB.ADD;
1016: RAISE EXCP_USER_DEFINED;
1017: ELSE
1018: BEGIN
1019: select requirement_line_id

Line 1027: FND_MSG_PUB.ADD;

1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');
1026: fnd_message.set_token ('LINE_ID', to_char(l_line_rec.requirement_line_id), FALSE);
1027: FND_MSG_PUB.ADD;
1028: RAISE EXCP_USER_DEFINED;
1029: WHEN OTHERS THEN
1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);

Line 1034: FND_MSG_PUB.ADD;

1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1032: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1034: FND_MSG_PUB.ADD;
1035: RAISE EXCP_USER_DEFINED;
1036: END;
1037: END IF;
1038:

Line 1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1079: WHEN FND_API.G_EXC_ERROR THEN
1080: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1081: P_API_NAME => L_API_NAME
1082: ,P_PKG_NAME => G_PKG_NAME
1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1084: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1085: ,X_MSG_COUNT => X_MSG_COUNT
1086: ,X_MSG_DATA => X_MSG_DATA
1087: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1090: P_API_NAME => L_API_NAME
1091: ,P_PKG_NAME => G_PKG_NAME
1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1093: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1094: ,X_MSG_COUNT => X_MSG_COUNT
1095: ,X_MSG_DATA => X_MSG_DATA
1096: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1102: FND_MSG_PUB.ADD;

1098: Rollback to csptrreq_fm_order_PUB;
1099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1102: FND_MSG_PUB.ADD;
1103: fnd_msg_pub.count_and_get
1104: ( p_count => x_msg_count
1105: , p_data => x_msg_data);
1106: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1103: fnd_msg_pub.count_and_get

1099: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1100: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1101: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1102: FND_MSG_PUB.ADD;
1103: fnd_msg_pub.count_and_get
1104: ( p_count => x_msg_count
1105: , p_data => x_msg_data);
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107:

Line 1155: FND_MSG_PUB.initialize;

1151: SAVEPOINT csptrreq_fm_order_PUB;
1152:
1153: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1154: -- initialize message list
1155: FND_MSG_PUB.initialize;
1156: END IF;
1157:
1158: -- Standard call to check for call compatibility.
1159: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1303: WHEN FND_API.G_EXC_ERROR THEN
1304: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1305: P_API_NAME => L_API_NAME
1306: ,P_PKG_NAME => G_PKG_NAME
1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1308: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1309: ,X_MSG_COUNT => X_MSG_COUNT
1310: ,X_MSG_DATA => X_MSG_DATA
1311: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1316: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1313: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1314: P_API_NAME => L_API_NAME
1315: ,P_PKG_NAME => G_PKG_NAME
1316: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1317: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1318: ,X_MSG_COUNT => X_MSG_COUNT
1319: ,X_MSG_DATA => X_MSG_DATA
1320: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1326: FND_MSG_PUB.ADD;

1322: Rollback to csptrreq_fm_order_PUB;
1323: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1324: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1325: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1326: FND_MSG_PUB.ADD;
1327: fnd_msg_pub.count_and_get
1328: ( p_count => x_msg_count
1329: , p_data => x_msg_data);
1330: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1327: fnd_msg_pub.count_and_get

1323: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1324: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
1325: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
1326: FND_MSG_PUB.ADD;
1327: fnd_msg_pub.count_and_get
1328: ( p_count => x_msg_count
1329: , p_data => x_msg_data);
1330: x_return_status := FND_API.G_RET_STS_ERROR;
1331: END;

Line 1351: FND_MSG_PUB.initialize;

1347: SAVEPOINT delete_rqmt_header_PUB;
1348:
1349: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1350: -- initialize message list
1351: FND_MSG_PUB.initialize;
1352: END IF;
1353:
1354: -- Standard call to check for call compatibility.
1355: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1376: FND_MSG_PUB.ADD;

1372:
1373: IF l_count > 0 THEN
1374: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
1375: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1376: FND_MSG_PUB.ADD;
1377: RAISE EXCP_USER_DEFINED;
1378: ELSE
1379: DELETE FROM csp_requirement_lines
1380: WHERE requirement_header_id = p_header_id;

Line 1395: fnd_msg_pub.count_and_get

1391: EXCEPTION
1392: WHEN EXCP_USER_DEFINED THEN
1393: Rollback to delete_rqmt_header_PUB;
1394: x_return_status := FND_API.G_RET_STS_ERROR;
1395: fnd_msg_pub.count_and_get
1396: ( p_count => x_msg_count
1397: , p_data => x_msg_data);
1398:
1399: WHEN FND_API.G_EXC_ERROR THEN

Line 1403: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1399: WHEN FND_API.G_EXC_ERROR THEN
1400: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1401: P_API_NAME => L_API_NAME
1402: ,P_PKG_NAME => G_PKG_NAME
1403: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1404: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1405: ,X_MSG_COUNT => X_MSG_COUNT
1406: ,X_MSG_DATA => X_MSG_DATA
1407: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1410: P_API_NAME => L_API_NAME
1411: ,P_PKG_NAME => G_PKG_NAME
1412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1414: ,X_MSG_COUNT => X_MSG_COUNT
1415: ,X_MSG_DATA => X_MSG_DATA
1416: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1422: FND_MSG_PUB.ADD;

1418: Rollback to delete_rqmt_header_PUB;
1419: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1420: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1421: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1422: FND_MSG_PUB.ADD;
1423: fnd_msg_pub.count_and_get
1424: ( p_count => x_msg_count
1425: , p_data => x_msg_data);
1426: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1423: fnd_msg_pub.count_and_get

1419: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1420: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1421: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1422: FND_MSG_PUB.ADD;
1423: fnd_msg_pub.count_and_get
1424: ( p_count => x_msg_count
1425: , p_data => x_msg_data);
1426: x_return_status := FND_API.G_RET_STS_ERROR;
1427: END;

Line 1498: FND_MSG_PUB.initialize;

1494: SAVEPOINT save_rqmt_line_PUB;
1495:
1496: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1497: -- initialize message list
1498: FND_MSG_PUB.initialize;
1499: END IF;
1500:
1501: -- Standard call to check for call compatibility.
1502: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1533: FND_MSG_PUB.ADD;

1529: WHERE user_id = l_user_id;
1530: EXCEPTION
1531: WHEN no_Data_found THEN
1532: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RS_USER_NOT_DEFINED');
1533: FND_MSG_PUB.ADD;
1534: RAISE EXCP_USER_DEFINED;
1535: END;
1536:
1537: /* BEGIN

Line 1545: FND_MSG_PUB.ADD;

1541: WHERE resource_id = l_header_rec.resource_id;
1542: EXCEPTION
1543: WHEN no_Data_found THEN
1544: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_RES_ID_TYPE');
1545: FND_MSG_PUB.ADD;
1546: RAISE EXCP_USER_DEFINED;
1547: END;
1548: */
1549: -- Since wireless deals with employee type resources only, hardcode resource type

Line 1565: FND_MSG_PUB.ADD;

1561:
1562: FND_MESSAGE.SET_NAME ('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1563: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE', l_header_rec.resource_type);
1564: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME', l_resource_name);
1565: FND_MSG_PUB.ADD;
1566: RAISE EXCP_USER_DEFINED;
1567: WHEN TOO_MANY_ROWS THEN
1568:
1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ONE_DEFAULT_IN_ALLOWED');

Line 1570: FND_MSG_PUB.ADD;

1566: RAISE EXCP_USER_DEFINED;
1567: WHEN TOO_MANY_ROWS THEN
1568:
1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_ONE_DEFAULT_IN_ALLOWED');
1570: FND_MSG_PUB.ADD;
1571: RAISE EXCP_USER_DEFINED;
1572: END;
1573:
1574: IF (l_header_rec.task_id IS NOT NULL) THEN

Line 1585: FND_MSG_PUB.ADD;

1581: WHEN NO_DATA_FOUND THEN
1582:
1583: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETER');
1584: FND_MESSAGE.SET_TOKEN('PARAMETER', 'Service Request');
1585: FND_MSG_PUB.ADD;
1586: RAISE EXCP_USER_DEFINED;
1587: END;
1588: END IF;
1589:

Line 1682: --FND_MSG_PUB.ADD;

1678:
1679: IF (l_requirement_header_id IS NOT NULL) THEN
1680: Rollback to save_rqmt_line_PUB;
1681: --FND_MESSAGE.SET_NAME('CSP', 'CSP_TASK_RQMT_EXISTS');
1682: --FND_MSG_PUB.ADD;
1683: --fnd_msg_pub.count_and_get
1684: -- ( p_count => x_msg_count
1685: -- , p_data => x_msg_data);
1686: x_msg_data := fnd_message.get_string('CSP', 'CSP_TASK_RQMT_EXISTS');

Line 1683: --fnd_msg_pub.count_and_get

1679: IF (l_requirement_header_id IS NOT NULL) THEN
1680: Rollback to save_rqmt_line_PUB;
1681: --FND_MESSAGE.SET_NAME('CSP', 'CSP_TASK_RQMT_EXISTS');
1682: --FND_MSG_PUB.ADD;
1683: --fnd_msg_pub.count_and_get
1684: -- ( p_count => x_msg_count
1685: -- , p_data => x_msg_data);
1686: x_msg_data := fnd_message.get_string('CSP', 'CSP_TASK_RQMT_EXISTS');
1687: x_return_status := 'E';

Line 1706: fnd_msg_pub.count_and_get

1702: X_Msg_Data => l_msg_data
1703: );
1704:
1705: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1706: fnd_msg_pub.count_and_get
1707: ( p_count => x_msg_count
1708: , p_data => x_msg_data);
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: return;

Line 1749: FND_MSG_PUB.ADD;

1745: EXCEPTION
1746: WHEN NO_DATA_FOUND THEN
1747: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
1748: fnd_message.set_token('HEADER_ID', to_char(l_header_rec.requirement_header_id), FALSE);
1749: FND_MSG_PUB.ADD;
1750: RAISE EXCP_USER_DEFINED;
1751: WHEN OTHERS THEN
1752: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1753: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);

Line 1756: FND_MSG_PUB.ADD;

1752: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1753: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1754: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1755: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1756: FND_MSG_PUB.ADD;
1757: RAISE EXCP_USER_DEFINED;
1758: END;
1759:
1760: l_rqmt_header_Rec.requirement_header_id := l_header_rec.requirement_header_id;

Line 1803: FND_MSG_PUB.ADD;

1799: from csp_requirement_lines
1800: where requirement_line_id = l_rqmt_line_rec.requirement_line_id;
1801: IF l_count > 0 THEN
1802: fnd_message.set_name('CSP', 'CSP_DUPLICATE_RQMT_LINE');
1803: FND_MSG_PUB.ADD;
1804: RAISE EXCP_USER_DEFINED;
1805: END IF;
1806: EXCEPTION
1807: WHEN NO_DATA_FOUND THEN

Line 1883: fnd_msg_pub.count_and_get

1879: EXCEPTION
1880: WHEN EXCP_USER_DEFINED THEN
1881: Rollback to save_rqmt_line_PUB;
1882: x_return_status := FND_API.G_RET_STS_ERROR;
1883: fnd_msg_pub.count_and_get
1884: ( p_count => x_msg_count
1885: , p_data => x_msg_data);
1886:
1887: WHEN FND_API.G_EXC_ERROR THEN

Line 1891: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1887: WHEN FND_API.G_EXC_ERROR THEN
1888: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1889: P_API_NAME => L_API_NAME
1890: ,P_PKG_NAME => G_PKG_NAME
1891: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1892: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1893: ,X_MSG_COUNT => X_MSG_COUNT
1894: ,X_MSG_DATA => X_MSG_DATA
1895: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1899: P_API_NAME => L_API_NAME
1900: ,P_PKG_NAME => G_PKG_NAME
1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1903: ,X_MSG_COUNT => X_MSG_COUNT
1904: ,X_MSG_DATA => X_MSG_DATA
1905: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1911: FND_MSG_PUB.ADD;

1907: Rollback to save_rqmt_line_PUB;
1908: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1911: FND_MSG_PUB.ADD;
1912: fnd_msg_pub.count_and_get
1913: ( p_count => x_msg_count
1914: , p_data => x_msg_data);
1915: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1912: fnd_msg_pub.count_and_get

1908: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1911: FND_MSG_PUB.ADD;
1912: fnd_msg_pub.count_and_get
1913: ( p_count => x_msg_count
1914: , p_data => x_msg_data);
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: END;

Line 1935: FND_MSG_PUB.initialize;

1931: SAVEPOINT delete_rqmt_line_PUB;
1932:
1933: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1934: -- initialize message list
1935: FND_MSG_PUB.initialize;
1936: END IF;
1937:
1938: -- Standard call to check for call compatibility.
1939: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1968: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1964: WHEN FND_API.G_EXC_ERROR THEN
1965: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1966: P_API_NAME => L_API_NAME
1967: ,P_PKG_NAME => G_PKG_NAME
1968: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1969: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1970: ,X_MSG_COUNT => X_MSG_COUNT
1971: ,X_MSG_DATA => X_MSG_DATA
1972: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1977: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1975: P_API_NAME => L_API_NAME
1976: ,P_PKG_NAME => G_PKG_NAME
1977: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1978: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1979: ,X_MSG_COUNT => X_MSG_COUNT
1980: ,X_MSG_DATA => X_MSG_DATA
1981: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1987: FND_MSG_PUB.ADD;

1983: Rollback to delete_rqmt_line_PUB;
1984: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1985: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1986: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1987: FND_MSG_PUB.ADD;
1988: fnd_msg_pub.count_and_get
1989: ( p_count => x_msg_count
1990: , p_data => x_msg_data);
1991: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1988: fnd_msg_pub.count_and_get

1984: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1985: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1986: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1987: FND_MSG_PUB.ADD;
1988: fnd_msg_pub.count_and_get
1989: ( p_count => x_msg_count
1990: , p_data => x_msg_data);
1991: x_return_status := FND_API.G_RET_STS_ERROR;
1992: END;

Line 2038: FND_MSG_PUB.initialize;

2034: SAVEPOINT check_Availability_PUB;
2035:
2036: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2037: -- initialize message list
2038: FND_MSG_PUB.initialize;
2039: END IF;
2040:
2041: -- Standard call to check for call compatibility.
2042: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2081: FND_MSG_PUB.ADD;

2077: EXCEPTION
2078: WHEN no_data_found THEN
2079: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2080: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2081: FND_MSG_PUB.ADD;
2082: RAISE EXCP_USER_DEFINED;
2083: END;
2084:
2085: OPEN rqmt_line_cur;

Line 2103: FND_MSG_PUB.initialize;

2099: I := I + 1;
2100: END LOOP;
2101:
2102: IF (l_parts_list_Tbl.count > 0) THEN
2103: FND_MSG_PUB.initialize;
2104: -- call csp_sch_int_pvt.check_parts_availability()
2105: csp_sch_int_pvt.check_parts_availability(
2106: p_resource => null,
2107: p_organization_id => l_header_rec.dest_organization_id,

Line 2212: fnd_msg_pub.count_and_get

2208: EXCEPTION
2209: WHEN EXCP_USER_DEFINED THEN
2210: Rollback to check_Availability_PUB;
2211: x_return_status := FND_API.G_RET_STS_ERROR;
2212: fnd_msg_pub.count_and_get
2213: ( p_count => x_msg_count
2214: , p_data => x_msg_data);
2215:
2216: WHEN FND_API.G_EXC_ERROR THEN

Line 2220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2216: WHEN FND_API.G_EXC_ERROR THEN
2217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2218: P_API_NAME => L_API_NAME
2219: ,P_PKG_NAME => G_PKG_NAME
2220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2222: ,X_MSG_COUNT => X_MSG_COUNT
2223: ,X_MSG_DATA => X_MSG_DATA
2224: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2227: P_API_NAME => L_API_NAME
2228: ,P_PKG_NAME => G_PKG_NAME
2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2231: ,X_MSG_COUNT => X_MSG_COUNT
2232: ,X_MSG_DATA => X_MSG_DATA
2233: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2239: FND_MSG_PUB.ADD;

2235: Rollback to check_Availability_pub;
2236: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2237: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2238: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2239: FND_MSG_PUB.ADD;
2240: fnd_msg_pub.count_and_get
2241: ( p_count => x_msg_count
2242: , p_data => x_msg_data);
2243: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2240: fnd_msg_pub.count_and_get

2236: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2237: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2238: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2239: FND_MSG_PUB.ADD;
2240: fnd_msg_pub.count_and_get
2241: ( p_count => x_msg_count
2242: , p_data => x_msg_data);
2243: x_return_status := FND_API.G_RET_STS_ERROR;
2244: END;

Line 2306: FND_MSG_PUB.initialize;

2302: SAVEPOINT create_order_PUB;
2303:
2304: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2305: -- initialize message list
2306: FND_MSG_PUB.initialize;
2307: END IF;
2308:
2309: -- Standard call to check for call compatibility.
2310: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2386: FND_MSG_PUB.ADD;

2382: EXCEPTION
2383: WHEN no_data_found THEN
2384: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');
2385: fnd_message.set_token('HEADER_ID', to_char(p_header_id), FALSE);
2386: FND_MSG_PUB.ADD;
2387: RAISE EXCP_USER_DEFINED;
2388: END;
2389:
2390: OPEN rqmt_line_cur;

Line 2425: fnd_msg_pub.add;

2421:
2422: EXIT WHEN rqmt_line_cur%NOTFOUND;
2423: IF (l_line_rec.sourced_From = 'IO' and l_line_rec.source_organization_id IS NULL) THEN
2424: fnd_message.set_name('CSP', 'CSP_NULL_SRC_ORGN');
2425: fnd_msg_pub.add;
2426: RAISE EXCP_USER_DEFINED;
2427: END If;
2428: l_line_rec.ordered_quantity := l_line_Rec.quantity;
2429: IF (l_line_rec.sourced_from = 'IO') THEN

Line 2593: fnd_msg_pub.count_and_get

2589: EXCEPTION
2590: WHEN EXCP_USER_DEFINED THEN
2591: Rollback to create_order_PUB;
2592: x_return_status := FND_API.G_RET_STS_ERROR;
2593: fnd_msg_pub.count_and_get
2594: ( p_count => x_msg_count
2595: , p_data => x_msg_data);
2596:
2597: WHEN FND_API.G_EXC_ERROR THEN

Line 2601: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2597: WHEN FND_API.G_EXC_ERROR THEN
2598: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2599: P_API_NAME => L_API_NAME
2600: ,P_PKG_NAME => G_PKG_NAME
2601: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2602: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2603: ,X_MSG_COUNT => X_MSG_COUNT
2604: ,X_MSG_DATA => X_MSG_DATA
2605: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2607: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2608: P_API_NAME => L_API_NAME
2609: ,P_PKG_NAME => G_PKG_NAME
2610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2611: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2612: ,X_MSG_COUNT => X_MSG_COUNT
2613: ,X_MSG_DATA => X_MSG_DATA
2614: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2620: FND_MSG_PUB.ADD;

2616: Rollback to create_order_PUB;
2617: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2618: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2619: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2620: FND_MSG_PUB.ADD;
2621: fnd_msg_pub.count_and_get
2622: ( p_count => x_msg_count
2623: , p_data => x_msg_data);
2624: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2621: fnd_msg_pub.count_and_get

2617: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2618: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
2619: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
2620: FND_MSG_PUB.ADD;
2621: fnd_msg_pub.count_and_get
2622: ( p_count => x_msg_count
2623: , p_data => x_msg_data);
2624: x_return_status := FND_API.G_RET_STS_ERROR;
2625: END;