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

Line 245: FND_MSG_PUB.initialize;

241: BEGIN
242: SAVEPOINT Validate_And_Write_PUB;
243: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
244: -- initialize message list
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: -- Standard call to check for call compatibility.
249: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 261: FND_MSG_PUB.ADD;

257: -- validate p_organization_id
258: IF p_organization_id IS NULL THEN
259: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
260: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
261: FND_MSG_PUB.ADD;
262: RAISE EXCP_USER_DEFINED;
263: ELSE
264: BEGIN
265: select organization_id into l_check_existence

Line 271: FND_MSG_PUB.ADD;

267: where organization_id = p_organization_id;
268: EXCEPTION
269: WHEN NO_DATA_FOUND THEN
270: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
271: FND_MSG_PUB.ADD;
272: RAISE EXCP_USER_DEFINED;
273: WHEN OTHERS THEN
274: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
275: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 278: FND_MSG_PUB.ADD;

274: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
275: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
276: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
277: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
278: FND_MSG_PUB.ADD;
279: RAISE EXCP_USER_DEFINED;
280: END;
281: END IF;
282:

Line 286: fnd_msg_pub.add;

282:
283: IF p_action_code NOT IN (0, 1, 2) OR p_action_code IS NULL THEN
284: fnd_message.set_name ('INV', 'INV-INVALID ACTION');
285: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
286: fnd_msg_pub.add;
287: RAISE EXCP_USER_DEFINED;
288: END IF;
289:
290: IF p_action_code = 0 AND px_transaction_temp_id IS NOT NULL THEN

Line 300: fnd_msg_pub.add;

296: WHERE transaction_temp_id = px_transaction_temp_id
297: AND organization_id = p_organization_id;
298:
299: fnd_message.set_name ('CSP', 'CSP_DUPLICATE_RECORD');
300: fnd_msg_pub.add;
301: RAISE EXCP_USER_DEFINED;
302:
303: EXCEPTION
304: WHEN NO_DATA_FOUND THEN

Line 311: FND_MSG_PUB.ADD;

307: ELSIF p_action_code IN (1, 2) THEN
308: IF px_transaction_temp_id IS NULL THEN
309: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
310: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'px_transaction_temp_id', TRUE);
311: FND_MSG_PUB.ADD;
312: RAISE EXCP_USER_DEFINED;
313: ELSE
314: BEGIN
315: select transaction_temp_id into l_check_existence

Line 323: fnd_msg_pub.add;

319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: fnd_message.set_name ('CSP', 'CSP_INVALID_TEMP_ID');
322: fnd_message.set_token ('ID', to_char(px_transaction_temp_id), TRUE);
323: fnd_msg_pub.add;
324: RAISE EXCP_USER_DEFINED;
325: WHEN EXCP_USER_DEFINED THEN
326: RAISE EXCP_USER_DEFINED;
327: WHEN OTHERS THEN

Line 332: FND_MSG_PUB.ADD;

328: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
329: fnd_message.set_token('ERR_FIELD', 'px_transaction_temp_id', TRUE);
330: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
331: fnd_message.set_token('TABLE', 'mtl_material_transactions_temp', TRUE);
332: FND_MSG_PUB.ADD;
333: RAISE EXCP_USER_DEFINED;
334: END;
335: END IF;
336: ELSE NULL;

Line 343: FND_MSG_PUB.ADD;

339: --validating inventory_item_id
340: IF p_inventory_item_id IS NULL THEN
341: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
342: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id', TRUE);
343: FND_MSG_PUB.ADD;
344: RAISE EXCP_USER_DEFINED;
345: ELSE
346: BEGIN
347: -- validate whether the inventory_item_is exists in the given oranization_id

Line 355: fnd_msg_pub.add;

351: and organization_id = p_organization_id;
352: EXCEPTION
353: WHEN NO_DATA_FOUND THEN
354: fnd_message.set_name ('INV', 'INV-NO ITEM RECORD');
355: fnd_msg_pub.add;
356: RAISE EXCP_USER_DEFINED;
357: WHEN OTHERS THEN
358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);

Line 362: fnd_msg_pub.add;

358: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
359: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
360: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
361: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
362: fnd_msg_pub.add;
363: RAISE EXCP_USER_DEFINED;
364: END;
365: END IF;
366:

Line 621: fnd_msg_pub.count_and_get

617: EXCEPTION
618: WHEN EXCP_USER_DEFINED THEN
619: Rollback to Validate_And_Write_PUB;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: fnd_msg_pub.count_and_get
622: ( p_count => x_msg_count
623: , p_data => x_msg_data);
624:
625: WHEN FND_API.G_EXC_ERROR THEN

Line 629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

625: WHEN FND_API.G_EXC_ERROR THEN
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
627: P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
630: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
639: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
640: ,X_MSG_COUNT => X_MSG_COUNT
641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 648: fnd_msg_pub.add;

644: Rollback to Validate_And_Write_PUB;
645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count
651: , p_data => x_msg_data);
652: x_return_status := fnd_api.g_ret_sts_error;

Line 649: fnd_msg_pub.count_and_get

645: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
646: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
647: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
648: fnd_msg_pub.add;
649: fnd_msg_pub.count_and_get
650: ( p_count => x_msg_count
651: , p_data => x_msg_data);
652: x_return_status := fnd_api.g_ret_sts_error;
653:

Line 925: FND_MSG_PUB.initialize;

921: SAVEPOINT CSP_MO_LINES_MANUAL_PUB;
922:
923: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
924: -- initialize message list
925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Standard call to check for call compatibility.
929: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 948: FND_MSG_PUB.ADD;

944: -- validate p_organization_id
945: IF p_organization_id IS NULL THEN
946: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
947: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
948: FND_MSG_PUB.ADD;
949: RAISE EXCP_USER_DEFINED;
950: ELSE
951: BEGIN
952: select organization_id into l_check_existence

Line 958: FND_MSG_PUB.ADD;

954: where organization_id = p_organization_id;
955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
957: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
958: FND_MSG_PUB.ADD;
959: RAISE EXCP_USER_DEFINED;
960: WHEN OTHERS THEN
961: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
962: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 965: FND_MSG_PUB.ADD;

961: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
962: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
963: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
964: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
965: FND_MSG_PUB.ADD;
966: RAISE EXCP_USER_DEFINED;
967: END;
968: END IF;
969:

Line 993: fnd_msg_pub.add;

989:
990: EXCEPTION
991: WHEN NO_DATA_FOUND THEN
992: fnd_message.set_name ('CSP', 'CSP_INVALID_INTRANSIT_SUB');
993: fnd_msg_pub.add;
994: --l_msg_data := 'Validation of intransit subinventory failed. Please make sure a subinventory under the working organizatin is assigned to the CSP_INTRANSIT_SUBINVENTORY profile.';
995: RAISE EXCP_USER_DEFINED;
996: WHEN OTHERS THEN
997: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');

Line 1001: FND_MSG_PUB.ADD;

997: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
998: fnd_message.set_token('ERR_FIELD', 'profile_option_value', TRUE);
999: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1000: fnd_message.set_token('TABLE', 'fnd_profile_option_values', TRUE);
1001: FND_MSG_PUB.ADD;
1002: RAISE EXCP_USER_DEFINED;
1003: END;
1004:
1005:

Line 1027: fnd_msg_pub.add;

1023:
1024: IF c_ml_records%NOTFOUND THEN
1025: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1026: fnd_message.set_token ('ID', to_char(p_transaction_temp_id), TRUE);
1027: fnd_msg_pub.add;
1028: close c_ml_records;
1029: RAISE EXCP_USER_DEFINED;
1030: END IF;
1031:

Line 1132: FND_MSG_PUB.ADD;

1128: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1129: fnd_message.set_token('ERR_FIELD', 'secondary_inventory', TRUE);
1130: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1131: fnd_message.set_token('TABLE', 'mtl_item_sub_inventories', TRUE);
1132: FND_MSG_PUB.ADD;
1133:
1134: IF c_ml_records%ISOPEN THEN
1135: close c_ml_records;
1136: END IF;

Line 1163: fnd_msg_pub.add;

1159:
1160:
1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1162: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');
1163: fnd_msg_pub.add;
1164: IF c_ml_records%ISOPEN THEN
1165: close c_ml_records;
1166: END IF;
1167: RAISE FND_API.G_EXC_ERROR;

Line 1229: fnd_msg_pub.add;

1225: );
1226:
1227: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1228: fnd_message.set_name ('CSP', 'CSP_SUB_TXFER_ERROR');
1229: fnd_msg_pub.add;
1230: IF c_ml_records%ISOPEN THEN
1231: close c_ml_records;
1232: END IF;
1233: RAISE FND_API.G_EXC_ERROR;

Line 1246: fnd_msg_pub.count_and_get

1242: -- Finally, call the process_online to perform the underneath material transactions
1243: IF NOT CSP_Mo_Mtltxns_Util.Call_Online (p_transaction_header_id => l_transaction_header_id) THEN
1244: l_outcome := FALSE;
1245: x_return_status := FND_API.G_RET_STS_ERROR;
1246: fnd_msg_pub.count_and_get
1247: ( p_count => x_msg_count
1248: , p_data => x_msg_data);
1249: Return;
1250: END IF;

Line 1263: fnd_msg_pub.count_and_get

1259: EXCEPTION
1260: WHEN EXCP_USER_DEFINED THEN
1261: Rollback to CSP_MO_LINES_MANUAL_PUB;
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: fnd_msg_pub.count_and_get
1264: ( p_count => x_msg_count
1265: , p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_ERROR THEN
1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1266: WHEN FND_API.G_EXC_ERROR THEN
1267: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1268: P_API_NAME => L_API_NAME
1269: ,P_PKG_NAME => G_PKG_NAME
1270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1271: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1272: ,X_MSG_COUNT => X_MSG_COUNT
1273: ,X_MSG_DATA => X_MSG_DATA
1274: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1279: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1277: P_API_NAME => L_API_NAME
1278: ,P_PKG_NAME => G_PKG_NAME
1279: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1280: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1281: ,X_MSG_COUNT => X_MSG_COUNT
1282: ,X_MSG_DATA => X_MSG_DATA
1283: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1289: fnd_msg_pub.add;

1285: Rollback to CSP_MO_LINES_MANUAL_PUB;
1286: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1287: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1288: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1289: fnd_msg_pub.add;
1290: fnd_msg_pub.count_and_get
1291: ( p_count => x_msg_count
1292: , p_data => x_msg_data);
1293: x_return_status := fnd_api.g_ret_sts_error;

Line 1290: fnd_msg_pub.count_and_get

1286: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1287: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1288: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1289: fnd_msg_pub.add;
1290: fnd_msg_pub.count_and_get
1291: ( p_count => x_msg_count
1292: , p_data => x_msg_data);
1293: x_return_status := fnd_api.g_ret_sts_error;
1294:

Line 1548: FND_MSG_PUB.initialize;

1544: SAVEPOINT CSP_MO_Lines_Auto_PUB;
1545:
1546: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1547: -- initialize message list
1548: FND_MSG_PUB.initialize;
1549: END IF;
1550:
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1571: FND_MSG_PUB.ADD;

1567: -- validate p_organization_id
1568: IF p_organization_id IS NULL THEN
1569: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1570: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
1571: FND_MSG_PUB.ADD;
1572: RAISE EXCP_USER_DEFINED;
1573: ELSE
1574: BEGIN
1575: select organization_id into l_check_existence

Line 1581: FND_MSG_PUB.ADD;

1577: where organization_id = p_organization_id;
1578: EXCEPTION
1579: WHEN NO_DATA_FOUND THEN
1580: FND_MESSAGE.SET_NAME ('INV', 'INVALID ORGANIZATION');
1581: FND_MSG_PUB.ADD;
1582: RAISE EXCP_USER_DEFINED;
1583: WHEN OTHERS THEN
1584: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1585: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);

Line 1588: FND_MSG_PUB.ADD;

1584: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1585: fnd_message.set_token('ERR_FIELD', 'p_organization_id', TRUE);
1586: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1587: fnd_message.set_token('TABLE', 'mtl_organizations', TRUE);
1588: FND_MSG_PUB.ADD;
1589: RAISE EXCP_USER_DEFINED;
1590: END;
1591: END IF;
1592:

Line 1597: FND_MSG_PUB.ADD;

1593: -- validate p_move_order_line_id
1594: IF p_transaction_temp_id IS NULL THEN
1595: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1596: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', TRUE);
1597: FND_MSG_PUB.ADD;
1598: RAISE EXCP_USER_DEFINED;
1599: ELSE
1600: DECLARE
1601: l_header_id NUMBER;

Line 1624: fnd_msg_pub.add;

1620: where header_id = l_header_id;
1621:
1622: IF l_autoreceipt_flag <> 'Y' THEN
1623: fnd_message.set_name ('CSP', 'CSP_INVALID_AUTORECEIPT');
1624: fnd_msg_pub.add;
1625: RAISE EXCP_USER_DEFINED;
1626: END IF;
1627:
1628: EXCEPTION

Line 1633: fnd_msg_pub.add;

1629: WHEN EXCP_USER_DEFINED THEN
1630: RAISE EXCP_USER_DEFINED;
1631: WHEN NO_DATA_FOUND THEN
1632: fnd_message.set_name ('CSP', 'CSP_NO_MO_TXN_RECORD');
1633: fnd_msg_pub.add;
1634: RAISE EXCP_USER_DEFINED;
1635: WHEN OTHERS THEN
1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);

Line 1640: FND_MSG_PUB.ADD;

1636: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1637: fnd_message.set_token('ERR_FIELD', 'autoreceipt_flag', TRUE);
1638: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1639: fnd_message.set_token('TABLE', 'csp_moveorder_headers', TRUE);
1640: FND_MSG_PUB.ADD;
1641: RAISE EXCP_USER_DEFINED;
1642: END;
1643: END IF;
1644:

Line 1703: fnd_msg_pub.count_and_get

1699: EXCEPTION
1700: WHEN EXCP_USER_DEFINED THEN
1701: Rollback to CSP_MO_Lines_Auto_PUB;
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: fnd_msg_pub.count_and_get
1704: ( p_count => x_msg_count
1705: , p_data => x_msg_data);
1706:
1707: WHEN FND_API.G_EXC_ERROR THEN

Line 1711: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1707: WHEN FND_API.G_EXC_ERROR THEN
1708: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1709: P_API_NAME => L_API_NAME
1710: ,P_PKG_NAME => G_PKG_NAME
1711: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1712: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1713: ,X_MSG_COUNT => X_MSG_COUNT
1714: ,X_MSG_DATA => X_MSG_DATA
1715: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1720: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1718: P_API_NAME => L_API_NAME
1719: ,P_PKG_NAME => G_PKG_NAME
1720: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1721: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1722: ,X_MSG_COUNT => X_MSG_COUNT
1723: ,X_MSG_DATA => X_MSG_DATA
1724: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1730: fnd_msg_pub.add;

1726: Rollback to CSP_MO_Lines_Auto_PUB;
1727: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1728: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1729: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1730: fnd_msg_pub.add;
1731: fnd_msg_pub.count_and_get
1732: ( p_count => x_msg_count
1733: , p_data => x_msg_data);
1734: x_return_status := fnd_api.g_ret_sts_error;

Line 1731: fnd_msg_pub.count_and_get

1727: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1728: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1729: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1730: fnd_msg_pub.add;
1731: fnd_msg_pub.count_and_get
1732: ( p_count => x_msg_count
1733: , p_data => x_msg_data);
1734: x_return_status := fnd_api.g_ret_sts_error;
1735: