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

Line 211: FND_MSG_PUB.initialize;

207: SAVEPOINT Create_Move_Order_Header_PUB;
208:
209: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
210: -- initialize message list
211: FND_MSG_PUB.initialize;
212: END IF;
213:
214: -- Standard call to check for call compatibility.
215: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 230: FND_MSG_PUB.ADD;

226: -- check organization
227: IF p_organization_id IS NULL THEN
228: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
229: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
230: FND_MSG_PUB.ADD;
231: RAISE EXCP_USER_DEFINED;
232: END IF;
233:
234: IF (px_header_id IS NOT NULL) THEN

Line 244: FND_MSG_PUB.ADD;

240: AND organization_id = p_organization_id;
241:
242: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
243: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_header_id' , TRUE);
244: FND_MSG_PUB.ADD;
245: RAISE EXCP_USER_DEFINED;
246:
247: EXCEPTION
248: WHEN no_data_found THEN

Line 349: fnd_msg_pub.count_and_get

345: IF fnd_api.to_boolean(p_commit) THEN
346: commit work;
347: END IF;
348:
349: fnd_msg_pub.count_and_get
350: ( p_count => x_msg_count
351: , p_data => x_msg_data);
352: /* Exception Block */
353: EXCEPTION

Line 357: fnd_msg_pub.count_and_get

353: EXCEPTION
354: WHEN EXCP_USER_DEFINED THEN
355: Rollback to Create_Move_Order_Header_PUB;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: fnd_msg_pub.count_and_get
358: ( p_count => x_msg_count
359: , p_data => x_msg_data);
360: WHEN FND_API.G_EXC_ERROR THEN
361: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 364: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

360: WHEN FND_API.G_EXC_ERROR THEN
361: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
362: P_API_NAME => L_API_NAME
363: ,P_PKG_NAME => G_PKG_NAME
364: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
365: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
366: ,X_MSG_COUNT => X_MSG_COUNT
367: ,X_MSG_DATA => X_MSG_DATA
368: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
371: P_API_NAME => L_API_NAME
372: ,P_PKG_NAME => G_PKG_NAME
373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
374: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
375: ,X_MSG_COUNT => X_MSG_COUNT
376: ,X_MSG_DATA => X_MSG_DATA
377: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 383: FND_MSG_PUB.ADD;

379: Rollback to Create_Move_Order_Header_PUB;
380: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
381: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
382: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
383: FND_MSG_PUB.ADD;
384: fnd_msg_pub.count_and_get
385: ( p_count => x_msg_count
386: , p_data => x_msg_data);
387: x_return_status := FND_API.G_RET_STS_ERROR;

Line 384: fnd_msg_pub.count_and_get

380: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
381: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
382: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
383: FND_MSG_PUB.ADD;
384: fnd_msg_pub.count_and_get
385: ( p_count => x_msg_count
386: , p_data => x_msg_data);
387: x_return_status := FND_API.G_RET_STS_ERROR;
388:

Line 451: FND_MSG_PUB.initialize;

447: SAVEPOINT Create_Move_Order_Line_PUB;
448:
449: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
450: -- initialize message list
451: FND_MSG_PUB.initialize;
452: END IF;
453:
454: -- Standard call to check for call compatibility.
455: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 470: FND_MSG_PUB.ADD;

466: -- check organization
467: IF p_organization_id IS NULL THEN
468: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
469: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
470: FND_MSG_PUB.ADD;
471: RAISE EXCP_USER_DEFINED;
472: END IF;
473:
474: IF p_header_id IS NULL THEN

Line 477: FND_MSG_PUB.ADD;

473:
474: IF p_header_id IS NULL THEN
475: FND_MESSAGE.SET_NAME('CSP', 'CSP_MISSING_PARAMETERS');
476: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_header_id', TRUE);
477: FND_MSG_PUB.ADD;
478: RAISE EXCP_USER_DEFINED;
479: END IF;
480:
481: IF (px_line_id IS NOT NULL) THEN

Line 491: FND_MSG_PUB.ADD;

487: AND organization_id = p_organization_id;
488:
489: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
490: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_line_id' , TRUE);
491: FND_MSG_PUB.ADD;
492: RAISE EXCP_USER_DEFINED;
493:
494: EXCEPTION
495: WHEN no_data_found THEN

Line 605: fnd_msg_pub.count_and_get

601:
602: IF fnd_api.to_boolean(p_commit) THEN
603: commit work;
604: END IF;
605: fnd_msg_pub.count_and_get
606: ( p_count => x_msg_count
607: , p_data => x_msg_data);
608: /* Exception Block */
609: EXCEPTION

Line 613: fnd_msg_pub.count_and_get

609: EXCEPTION
610: WHEN EXCP_USER_DEFINED THEN
611: Rollback to Create_Move_Order_Line_PUB;
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: fnd_msg_pub.count_and_get
614: ( p_count => x_msg_count
615: , p_data => x_msg_data);
616: WHEN FND_API.G_EXC_ERROR THEN
617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

616: WHEN FND_API.G_EXC_ERROR THEN
617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
622: ,X_MSG_COUNT => X_MSG_COUNT
623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

625: WHEN FND_API.G_EXC_UNEXPECTED_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 639: FND_MSG_PUB.ADD;

635: Rollback to Create_Move_Order_Line_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count
642: , p_data => x_msg_data);
643: x_return_status := FND_API.G_RET_STS_ERROR;

Line 640: fnd_msg_pub.count_and_get

636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count
642: , p_data => x_msg_data);
643: x_return_status := FND_API.G_RET_STS_ERROR;
644:

Line 858: FND_MSG_PUB.initialize;

854: Savepoint Transact_Material_PUB;
855:
856: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
857: -- initialize message list
858: FND_MSG_PUB.initialize;
859: END IF;
860:
861: -- Standard call to check for call compatibility.
862: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 874: FND_MSG_PUB.ADD;

870: -- validating transaction_type_id
871: IF p_transaction_type_id IS NULL THEN
872: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
873: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_type_id', TRUE);
874: FND_MSG_PUB.ADD;
875: RAISE EXCP_USER_DEFINED;
876: END IF;
877:
878: -- validating organization

Line 882: FND_MSG_PUB.ADD;

878: -- validating organization
879: IF p_organization_id IS NULL THEN
880: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
881: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
882: FND_MSG_PUB.ADD;
883: RAISE EXCP_USER_DEFINED;
884: END IF;
885:
886: -- Check that item is an inventory_item, stockable, transactable and reservable

Line 891: FND_MSG_PUB.ADD;

887: --
888: IF p_inventory_item_id IS NULL THEN
889: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
890: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);
891: FND_MSG_PUB.ADD;
892: RAISE EXCP_USER_DEFINED;
893: ELSE
894: BEGIN
895: -- validate whether the inventory_item_id exists in the given oranization_id

Line 903: fnd_msg_pub.add;

899: and organization_id = p_organization_id;
900: EXCEPTION
901: WHEN NO_DATA_FOUND THEN
902: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
903: fnd_msg_pub.add;
904: RAISE EXCP_USER_DEFINED;
905: WHEN OTHERS THEN
906: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
907: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);

Line 910: FND_MSG_PUB.ADD;

906: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
907: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
908: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
909: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
910: FND_MSG_PUB.ADD;
911: RAISE EXCP_USER_DEFINED;
912: END;
913: END IF;
914:

Line 919: fnd_msg_pub.add;

915: --validating transaction_quantity
916: IF p_quantity IS NULL OR p_quantity < 0 THEN
917: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
918: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_quantity', TRUE);
919: fnd_msg_pub.add;
920: RAISE EXCP_USER_DEFINED;
921: END IF;
922:
923: --validating transaction_uom

Line 927: fnd_msg_pub.add;

923: --validating transaction_uom
924: IF p_uom IS NULL THEN
925: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
926: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_uom', TRUE);
927: fnd_msg_pub.add;
928: RAISE EXCP_USER_DEFINED;
929: END IF;
930:
931: -- Validating Account ID

Line 953: fnd_msg_pub.add;

949:
950: EXCEPTION
951: WHEN NO_DATA_FOUND THEN
952: fnd_message.set_name('CSP', 'CSP_INVALID_ACCOUNT');
953: fnd_msg_pub.add;
954: RAISE EXCP_USER_DEFINED;
955: WHEN OTHERS THEN
956: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
957: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);

Line 960: FND_MSG_PUB.ADD;

956: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
957: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
958: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
959: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
960: FND_MSG_PUB.ADD;
961: RAISE EXCP_USER_DEFINED;
962: END;
963: END IF;
964:

Line 972: fnd_msg_pub.add;

968: --validating subinventory_code
969: IF p_subinventory_code IS NULL THEN
970: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
971: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_subinventory_code', TRUE);
972: fnd_msg_pub.add;
973: RAISE EXCP_USER_DEFINED;
974: END IF;
975: */
976:

Line 1040: fnd_msg_pub.add;

1036: End;
1037:
1038: If l_ship_number is Not Null then
1039: fnd_message.set_name('INV','INV_SHIP_USED');
1040: fnd_msg_pub.add;
1041: RAISE EXCP_USER_DEFINED;
1042: End if;
1043:
1044: Begin

Line 1055: fnd_msg_pub.add;

1051: End;
1052:
1053: If l_ship_number is Not Null then
1054: fnd_message.set_name('INV','INV_SHIP_USED');
1055: fnd_msg_pub.add;
1056: RAISE EXCP_USER_DEFINED;
1057: End if;
1058:
1059: Begin

Line 1070: fnd_msg_pub.add;

1066: End;
1067:
1068: If l_ship_number is Not Null then
1069: fnd_message.set_name('INV','INV_SHIP_USED');
1070: fnd_msg_pub.add;
1071: RAISE EXCP_USER_DEFINED;
1072: End if;
1073:
1074:

Line 1357: FND_MSG_PUB.ADD;

1353: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1354: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1355: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1356: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1357: FND_MSG_PUB.ADD;
1358: RAISE EXCP_USER_DEFINED;
1359: else
1360: OPEN transaction_id_cur;
1361: FETCH transaction_id_cur INTO px_transaction_id;

Line 1517: fnd_msg_pub.count_and_get

1513: x_return_status := FND_API.G_RET_STS_SUCCESS;
1514: x_msg_data := l_msg_data;
1515: -- dbms_output.put_line('TRANSACT_MATERIAL: returning successfully');
1516: /*
1517: fnd_msg_pub.count_and_get
1518: ( p_count => x_msg_count
1519: , p_data => x_msg_data); */
1520: EXCEPTION
1521: WHEN EXCP_USER_DEFINED THEN

Line 1526: fnd_msg_pub.count_and_get

1522: If l_outcome = true then -- i.e. process_online has not been called.
1523: Rollback to Transact_Material_Pub;
1524: end if;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: fnd_msg_pub.count_and_get
1527: ( p_count => x_msg_count
1528: , p_data => x_msg_data);
1529: WHEN FND_API.G_EXC_ERROR THEN
1530: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1529: WHEN FND_API.G_EXC_ERROR THEN
1530: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1531: P_API_NAME => L_API_NAME
1532: ,P_PKG_NAME => G_PKG_NAME
1533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1534: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1535: ,X_MSG_COUNT => X_MSG_COUNT
1536: ,X_MSG_DATA => X_MSG_DATA
1537: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1542: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1539: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1540: P_API_NAME => L_API_NAME
1541: ,P_PKG_NAME => G_PKG_NAME
1542: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1543: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1544: ,X_MSG_COUNT => X_MSG_COUNT
1545: ,X_MSG_DATA => X_MSG_DATA
1546: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1554: fnd_msg_pub.add;

1550: end if;
1551: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1552: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1553: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1554: fnd_msg_pub.add;
1555: fnd_msg_pub.count_and_get
1556: ( p_count => x_msg_count
1557: , p_data => x_msg_data);
1558: x_return_status := fnd_api.g_ret_sts_error;

Line 1555: fnd_msg_pub.count_and_get

1551: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1552: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1553: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1554: fnd_msg_pub.add;
1555: fnd_msg_pub.count_and_get
1556: ( p_count => x_msg_count
1557: , p_data => x_msg_data);
1558: x_return_status := fnd_api.g_ret_sts_error;
1559:

Line 1712: FND_MSG_PUB.initialize;

1708: Savepoint transact_temp_record_pub;
1709:
1710: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1711: -- initialize message list
1712: FND_MSG_PUB.initialize;
1713: END IF;
1714:
1715: -- Standard call to check for call compatibility.
1716: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1728: FND_MSG_PUB.ADD;

1724: IF p_validation_level = fnd_api.g_valid_level_full THEN
1725: IF p_transaction_temp_id IS NULL THEN
1726: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1727: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
1728: FND_MSG_PUB.ADD;
1729: RAISE EXCP_USER_DEFINED;
1730: ELSE
1731: BEGIN
1732: select transaction_temp_id into l_check_existence

Line 1739: fnd_msg_pub.add;

1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN
1737: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1738: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1739: fnd_msg_pub.add;
1740: RAISE EXCP_USER_DEFINED;
1741: WHEN OTHERS THEN
1742: RAISE TOO_MANY_ROWS; -- this will really go to OTHERS exception.
1743: END;

Line 1763: fnd_msg_pub.add;

1759: If l_Get_Temp_Csr%NOTFOUND Then
1760: Close l_Get_Temp_Csr;
1761: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1762: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1763: fnd_msg_pub.add;
1764: RAISE EXCP_USER_DEFINED;
1765: Else
1766: Close l_Get_Temp_Csr;
1767: End If;

Line 1777: fnd_msg_pub.add;

1773: If l_Get_Mo_header_id_csr%NOTFOUND THEN
1774: Close l_Get_Mo_header_id_csr;
1775: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1776: fnd_message.set_token ('LINE_ID', to_char(l_mtl_txn_temp_rec.move_order_line_id), FALSE);
1777: fnd_msg_pub.add;
1778: End If;
1779:
1780: Close l_Get_Mo_header_id_csr;
1781: Else

Line 1843: fnd_msg_pub.add;

1839:
1840: If l_Get_Lot_Temp_Csr%rowcount = 0 Then
1841: Close l_Get_Lot_Temp_Csr;
1842: fnd_message.set_name('CSP', 'CSP_NO_LOT_TXN_RECORD');
1843: fnd_msg_pub.add;
1844: RAISE EXCP_USER_DEFINED;
1845: End if;
1846:
1847: If l_Get_Lot_Temp_Csr%ISOPEN Then

Line 1916: fnd_msg_pub.add;

1912: If l_Get_Serial_Temp_Csr%rowcount = 0 Then
1913: Close l_Get_Lot_Temp_Csr;
1914: Close l_Get_Serial_Temp_Csr;
1915: fnd_message.set_name('CSP', 'CSP_NO_SERIAL_TXN_RECORD');
1916: fnd_msg_pub.add;
1917: RAISE EXCP_USER_DEFINED;
1918: End If;
1919:
1920: If l_Get_Serial_Temp_Csr%ISOPEN Then

Line 2030: fnd_msg_pub.count_and_get

2026: IF fnd_api.to_boolean(p_commit) THEN
2027: commit work;
2028: END IF;
2029: x_return_status := l_return_status;
2030: fnd_msg_pub.count_and_get
2031: ( p_count => x_msg_count
2032: , p_data => x_msg_data);
2033: EXCEPTION
2034: WHEN EXCP_USER_DEFINED THEN

Line 2037: fnd_msg_pub.count_and_get

2033: EXCEPTION
2034: WHEN EXCP_USER_DEFINED THEN
2035: Rollback to transact_temp_record_pub;
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: fnd_msg_pub.count_and_get
2038: ( p_count => x_msg_count
2039: , p_data => x_msg_data);
2040: WHEN FND_API.G_EXC_ERROR THEN
2041: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 2044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2040: WHEN FND_API.G_EXC_ERROR THEN
2041: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2042: P_API_NAME => L_API_NAME
2043: ,P_PKG_NAME => G_PKG_NAME
2044: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2045: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2046: ,X_MSG_COUNT => X_MSG_COUNT
2047: ,X_MSG_DATA => X_MSG_DATA
2048: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2053: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2050: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2051: P_API_NAME => L_API_NAME
2052: ,P_PKG_NAME => G_PKG_NAME
2053: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2054: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2055: ,X_MSG_COUNT => X_MSG_COUNT
2056: ,X_MSG_DATA => X_MSG_DATA
2057: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2063: fnd_msg_pub.add;

2059: Rollback to transact_temp_record_pub;
2060: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2061: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2062: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2063: fnd_msg_pub.add;
2064: fnd_msg_pub.count_and_get
2065: ( p_count => x_msg_count
2066: , p_data => x_msg_data);
2067: x_return_status := fnd_api.g_ret_sts_error;

Line 2064: fnd_msg_pub.count_and_get

2060: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
2061: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
2062: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
2063: fnd_msg_pub.add;
2064: fnd_msg_pub.count_and_get
2065: ( p_count => x_msg_count
2066: , p_data => x_msg_data);
2067: x_return_status := fnd_api.g_ret_sts_error;
2068: END transact_temp_record;

Line 2251: fnd_msg_pub.get

2247: ,x_msg_data => x_msg_data );
2248:
2249:
2250: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2251: fnd_msg_pub.get
2252: ( p_msg_index => x_msg_count
2253: , p_encoded => FND_API.G_FALSE
2254: , p_data => x_msg_data
2255: , p_msg_index_out => x_msg_count

Line 2291: fnd_msg_pub.get

2287: ,x_msg_count => x_msg_count
2288: ,x_msg_data => x_msg_data );
2289:
2290: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2291: fnd_msg_pub.get
2292: ( p_msg_index => x_msg_count
2293: , p_encoded => FND_API.G_FALSE
2294: , p_data => x_msg_data
2295: , p_msg_index_out => x_msg_count

Line 2601: fnd_msg_pub.count_and_get

2597: ,x_primary_relieved_quantity => l_relieved_quantity1
2598: ,x_primary_remain_quantity => l_remaining_quantity
2599: );
2600:
2601: fnd_msg_pub.count_and_get
2602: ( p_count => x_msg_count
2603: , p_data => x_msg_data);
2604:
2605: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then