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 156: FND_MSG_PUB.initialize;

152: SAVEPOINT Create_Move_Order_Header_PUB;
153:
154: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
155: -- initialize message list
156: FND_MSG_PUB.initialize;
157: END IF;
158:
159: -- Standard call to check for call compatibility.
160: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 175: FND_MSG_PUB.ADD;

171: -- check organization
172: IF p_organization_id IS NULL THEN
173: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
174: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
175: FND_MSG_PUB.ADD;
176: RAISE EXCP_USER_DEFINED;
177: END IF;
178:
179: IF (px_header_id IS NOT NULL) THEN

Line 189: FND_MSG_PUB.ADD;

185: AND organization_id = p_organization_id;
186:
187: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
188: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_header_id' , TRUE);
189: FND_MSG_PUB.ADD;
190: RAISE EXCP_USER_DEFINED;
191:
192: EXCEPTION
193: WHEN no_data_found THEN

Line 294: fnd_msg_pub.count_and_get

290: IF fnd_api.to_boolean(p_commit) THEN
291: commit work;
292: END IF;
293:
294: fnd_msg_pub.count_and_get
295: ( p_count => x_msg_count
296: , p_data => x_msg_data);
297: /* Exception Block */
298: EXCEPTION

Line 302: fnd_msg_pub.count_and_get

298: EXCEPTION
299: WHEN EXCP_USER_DEFINED THEN
300: Rollback to Create_Move_Order_Header_PUB;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: fnd_msg_pub.count_and_get
303: ( p_count => x_msg_count
304: , p_data => x_msg_data);
305: WHEN FND_API.G_EXC_ERROR THEN
306: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 309: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

305: WHEN FND_API.G_EXC_ERROR THEN
306: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
307: P_API_NAME => L_API_NAME
308: ,P_PKG_NAME => G_PKG_NAME
309: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
310: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
311: ,X_MSG_COUNT => X_MSG_COUNT
312: ,X_MSG_DATA => X_MSG_DATA
313: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 318: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
316: P_API_NAME => L_API_NAME
317: ,P_PKG_NAME => G_PKG_NAME
318: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
319: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
320: ,X_MSG_COUNT => X_MSG_COUNT
321: ,X_MSG_DATA => X_MSG_DATA
322: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 328: FND_MSG_PUB.ADD;

324: Rollback to Create_Move_Order_Header_PUB;
325: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
326: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
327: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
328: FND_MSG_PUB.ADD;
329: fnd_msg_pub.count_and_get
330: ( p_count => x_msg_count
331: , p_data => x_msg_data);
332: x_return_status := FND_API.G_RET_STS_ERROR;

Line 329: fnd_msg_pub.count_and_get

325: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
326: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
327: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
328: FND_MSG_PUB.ADD;
329: fnd_msg_pub.count_and_get
330: ( p_count => x_msg_count
331: , p_data => x_msg_data);
332: x_return_status := FND_API.G_RET_STS_ERROR;
333:

Line 396: FND_MSG_PUB.initialize;

392: SAVEPOINT Create_Move_Order_Line_PUB;
393:
394: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
395: -- initialize message list
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 415: FND_MSG_PUB.ADD;

411: -- check organization
412: IF p_organization_id IS NULL THEN
413: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
414: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
415: FND_MSG_PUB.ADD;
416: RAISE EXCP_USER_DEFINED;
417: END IF;
418:
419: IF p_header_id IS NULL THEN

Line 422: FND_MSG_PUB.ADD;

418:
419: IF p_header_id IS NULL THEN
420: FND_MESSAGE.SET_NAME('CSP', 'CSP_MISSING_PARAMETERS');
421: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_header_id', TRUE);
422: FND_MSG_PUB.ADD;
423: RAISE EXCP_USER_DEFINED;
424: END IF;
425:
426: IF (px_line_id IS NOT NULL) THEN

Line 436: FND_MSG_PUB.ADD;

432: AND organization_id = p_organization_id;
433:
434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');
435: FND_MESSAGE.SET_TOKEN('PARAMETER', 'px_line_id' , TRUE);
436: FND_MSG_PUB.ADD;
437: RAISE EXCP_USER_DEFINED;
438:
439: EXCEPTION
440: WHEN no_data_found THEN

Line 550: fnd_msg_pub.count_and_get

546:
547: IF fnd_api.to_boolean(p_commit) THEN
548: commit work;
549: END IF;
550: fnd_msg_pub.count_and_get
551: ( p_count => x_msg_count
552: , p_data => x_msg_data);
553: /* Exception Block */
554: EXCEPTION

Line 558: fnd_msg_pub.count_and_get

554: EXCEPTION
555: WHEN EXCP_USER_DEFINED THEN
556: Rollback to Create_Move_Order_Line_PUB;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: fnd_msg_pub.count_and_get
559: ( p_count => x_msg_count
560: , p_data => x_msg_data);
561: WHEN FND_API.G_EXC_ERROR THEN
562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

561: WHEN FND_API.G_EXC_ERROR THEN
562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
567: ,X_MSG_COUNT => X_MSG_COUNT
568: ,X_MSG_DATA => X_MSG_DATA
569: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 574: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
572: P_API_NAME => L_API_NAME
573: ,P_PKG_NAME => G_PKG_NAME
574: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
575: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
576: ,X_MSG_COUNT => X_MSG_COUNT
577: ,X_MSG_DATA => X_MSG_DATA
578: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 584: FND_MSG_PUB.ADD;

580: Rollback to Create_Move_Order_Line_PUB;
581: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
582: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
583: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
584: FND_MSG_PUB.ADD;
585: fnd_msg_pub.count_and_get
586: ( p_count => x_msg_count
587: , p_data => x_msg_data);
588: x_return_status := FND_API.G_RET_STS_ERROR;

Line 585: fnd_msg_pub.count_and_get

581: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
582: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
583: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
584: FND_MSG_PUB.ADD;
585: fnd_msg_pub.count_and_get
586: ( p_count => x_msg_count
587: , p_data => x_msg_data);
588: x_return_status := FND_API.G_RET_STS_ERROR;
589:

Line 733: FND_MSG_PUB.initialize;

729: Savepoint Transact_Material_PUB;
730:
731: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
732: -- initialize message list
733: FND_MSG_PUB.initialize;
734: END IF;
735:
736: -- Standard call to check for call compatibility.
737: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 749: FND_MSG_PUB.ADD;

745: -- validating transaction_type_id
746: IF p_transaction_type_id IS NULL THEN
747: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
748: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_type_id', TRUE);
749: FND_MSG_PUB.ADD;
750: RAISE EXCP_USER_DEFINED;
751: END IF;
752:
753: -- validating organization

Line 757: FND_MSG_PUB.ADD;

753: -- validating organization
754: IF p_organization_id IS NULL THEN
755: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
756: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_organization_id', TRUE);
757: FND_MSG_PUB.ADD;
758: RAISE EXCP_USER_DEFINED;
759: END IF;
760:
761: -- Check that item is an inventory_item, stockable, transactable and reservable

Line 766: FND_MSG_PUB.ADD;

762: --
763: IF p_inventory_item_id IS NULL THEN
764: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
765: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_inventory_item_id ', TRUE);
766: FND_MSG_PUB.ADD;
767: RAISE EXCP_USER_DEFINED;
768: ELSE
769: BEGIN
770: -- validate whether the inventory_item_id exists in the given oranization_id

Line 778: fnd_msg_pub.add;

774: and organization_id = p_organization_id;
775: EXCEPTION
776: WHEN NO_DATA_FOUND THEN
777: fnd_message.set_name('INV', 'INV-NO ITEM RECROD');
778: fnd_msg_pub.add;
779: RAISE EXCP_USER_DEFINED;
780: WHEN OTHERS THEN
781: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
782: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);

Line 785: FND_MSG_PUB.ADD;

781: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
782: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
783: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
784: fnd_message.set_token('TABLE', 'mtl_system_items', TRUE);
785: FND_MSG_PUB.ADD;
786: RAISE EXCP_USER_DEFINED;
787: END;
788: END IF;
789:

Line 794: fnd_msg_pub.add;

790: --validating transaction_quantity
791: IF p_quantity IS NULL OR p_quantity < 0 THEN
792: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
793: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_quantity', TRUE);
794: fnd_msg_pub.add;
795: RAISE EXCP_USER_DEFINED;
796: END IF;
797:
798: --validating transaction_uom

Line 802: fnd_msg_pub.add;

798: --validating transaction_uom
799: IF p_uom IS NULL THEN
800: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
801: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_uom', TRUE);
802: fnd_msg_pub.add;
803: RAISE EXCP_USER_DEFINED;
804: END IF;
805:
806: -- Validating Account ID

Line 828: fnd_msg_pub.add;

824:
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: fnd_message.set_name('CSP', 'CSP_INVALID_ACCOUNT');
828: fnd_msg_pub.add;
829: RAISE EXCP_USER_DEFINED;
830: WHEN OTHERS THEN
831: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
832: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);

Line 835: FND_MSG_PUB.ADD;

831: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
832: fnd_message.set_token('ERR_FIELD', 'p_account_id', TRUE);
833: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
834: fnd_message.set_token('TABLE', 'GL_code_combinations', TRUE);
835: FND_MSG_PUB.ADD;
836: RAISE EXCP_USER_DEFINED;
837: END;
838: END IF;
839:

Line 847: fnd_msg_pub.add;

843: --validating subinventory_code
844: IF p_subinventory_code IS NULL THEN
845: fnd_message.set_name ('CSP', 'CSP_MISSING_PARAMETERS');
846: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_subinventory_code', TRUE);
847: fnd_msg_pub.add;
848: RAISE EXCP_USER_DEFINED;
849: END IF;
850: */
851:

Line 915: fnd_msg_pub.add;

911: End;
912:
913: If l_ship_number is Not Null then
914: fnd_message.set_name('INV','INV_SHIP_USED');
915: fnd_msg_pub.add;
916: RAISE EXCP_USER_DEFINED;
917: End if;
918:
919: Begin

Line 930: fnd_msg_pub.add;

926: End;
927:
928: If l_ship_number is Not Null then
929: fnd_message.set_name('INV','INV_SHIP_USED');
930: fnd_msg_pub.add;
931: RAISE EXCP_USER_DEFINED;
932: End if;
933:
934: Begin

Line 945: fnd_msg_pub.add;

941: End;
942:
943: If l_ship_number is Not Null then
944: fnd_message.set_name('INV','INV_SHIP_USED');
945: fnd_msg_pub.add;
946: RAISE EXCP_USER_DEFINED;
947: End if;
948:
949:

Line 1232: FND_MSG_PUB.ADD;

1228: delete from mtl_transactions_interface where transaction_header_id = l_transaction_header_id;
1229: FND_MESSAGE.SET_NAME('CSP', 'CSP_TRANSACT_ERRORS');
1230: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code, TRUE);
1231: FND_MESSAGE.SET_TOKEN('ERROR_EXPLANATION', l_error_explanation, FALSE);
1232: FND_MSG_PUB.ADD;
1233: RAISE EXCP_USER_DEFINED;
1234: END IF;
1235: END IF;
1236:

Line 1243: fnd_msg_pub.count_and_get

1239: END IF;
1240:
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242: -- dbms_output.put_line('TRANSACT_MATERIAL: returning successfully');
1243: fnd_msg_pub.count_and_get
1244: ( p_count => x_msg_count
1245: , p_data => x_msg_data);
1246: EXCEPTION
1247: WHEN EXCP_USER_DEFINED THEN

Line 1252: fnd_msg_pub.count_and_get

1248: If l_outcome = true then -- i.e. process_online has not been called.
1249: Rollback to Transact_Material_Pub;
1250: end if;
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: fnd_msg_pub.count_and_get
1253: ( p_count => x_msg_count
1254: , p_data => x_msg_data);
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1259: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1255: WHEN FND_API.G_EXC_ERROR THEN
1256: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1257: P_API_NAME => L_API_NAME
1258: ,P_PKG_NAME => G_PKG_NAME
1259: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1260: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1261: ,X_MSG_COUNT => X_MSG_COUNT
1262: ,X_MSG_DATA => X_MSG_DATA
1263: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1266: P_API_NAME => L_API_NAME
1267: ,P_PKG_NAME => G_PKG_NAME
1268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1269: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1270: ,X_MSG_COUNT => X_MSG_COUNT
1271: ,X_MSG_DATA => X_MSG_DATA
1272: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1280: fnd_msg_pub.add;

1276: end if;
1277: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1278: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1279: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1280: fnd_msg_pub.add;
1281: fnd_msg_pub.count_and_get
1282: ( p_count => x_msg_count
1283: , p_data => x_msg_data);
1284: x_return_status := fnd_api.g_ret_sts_error;

Line 1281: fnd_msg_pub.count_and_get

1277: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1278: fnd_message.set_token ('ROUTINE', l_api_name, TRUE);
1279: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1280: fnd_msg_pub.add;
1281: fnd_msg_pub.count_and_get
1282: ( p_count => x_msg_count
1283: , p_data => x_msg_data);
1284: x_return_status := fnd_api.g_ret_sts_error;
1285:

Line 1438: FND_MSG_PUB.initialize;

1434: Savepoint transact_temp_record_pub;
1435:
1436: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1437: -- initialize message list
1438: FND_MSG_PUB.initialize;
1439: END IF;
1440:
1441: -- Standard call to check for call compatibility.
1442: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1454: FND_MSG_PUB.ADD;

1450: IF p_validation_level = fnd_api.g_valid_level_full THEN
1451: IF p_transaction_temp_id IS NULL THEN
1452: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1453: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_transaction_temp_id', FALSE);
1454: FND_MSG_PUB.ADD;
1455: RAISE EXCP_USER_DEFINED;
1456: ELSE
1457: BEGIN
1458: select transaction_temp_id into l_check_existence

Line 1465: fnd_msg_pub.add;

1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1464: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1465: fnd_msg_pub.add;
1466: RAISE EXCP_USER_DEFINED;
1467: WHEN OTHERS THEN
1468: RAISE TOO_MANY_ROWS; -- this will really go to OTHERS exception.
1469: END;

Line 1489: fnd_msg_pub.add;

1485: If l_Get_Temp_Csr%NOTFOUND Then
1486: Close l_Get_Temp_Csr;
1487: fnd_message.set_name ('CSP', 'CSP_INVALID_TXN_TEMP_ID');
1488: fnd_message.set_token('ID', to_char(p_transaction_temp_id), FALSE);
1489: fnd_msg_pub.add;
1490: RAISE EXCP_USER_DEFINED;
1491: Else
1492: Close l_Get_Temp_Csr;
1493: End If;

Line 1503: fnd_msg_pub.add;

1499: If l_Get_Mo_header_id_csr%NOTFOUND THEN
1500: Close l_Get_Mo_header_id_csr;
1501: fnd_message.set_name ('CSP', 'CSP_MOVEORDER_LINE_NO_PARENT');
1502: fnd_message.set_token ('LINE_ID', to_char(l_mtl_txn_temp_rec.move_order_line_id), FALSE);
1503: fnd_msg_pub.add;
1504: End If;
1505:
1506: Close l_Get_Mo_header_id_csr;
1507: Else

Line 1569: fnd_msg_pub.add;

1565:
1566: If l_Get_Lot_Temp_Csr%rowcount = 0 Then
1567: Close l_Get_Lot_Temp_Csr;
1568: fnd_message.set_name('CSP', 'CSP_NO_LOT_TXN_RECORD');
1569: fnd_msg_pub.add;
1570: RAISE EXCP_USER_DEFINED;
1571: End if;
1572:
1573: If l_Get_Lot_Temp_Csr%ISOPEN Then

Line 1642: fnd_msg_pub.add;

1638: If l_Get_Serial_Temp_Csr%rowcount = 0 Then
1639: Close l_Get_Lot_Temp_Csr;
1640: Close l_Get_Serial_Temp_Csr;
1641: fnd_message.set_name('CSP', 'CSP_NO_SERIAL_TXN_RECORD');
1642: fnd_msg_pub.add;
1643: RAISE EXCP_USER_DEFINED;
1644: End If;
1645:
1646: If l_Get_Serial_Temp_Csr%ISOPEN Then

Line 1756: fnd_msg_pub.count_and_get

1752: IF fnd_api.to_boolean(p_commit) THEN
1753: commit work;
1754: END IF;
1755: x_return_status := l_return_status;
1756: fnd_msg_pub.count_and_get
1757: ( p_count => x_msg_count
1758: , p_data => x_msg_data);
1759: EXCEPTION
1760: WHEN EXCP_USER_DEFINED THEN

Line 1763: fnd_msg_pub.count_and_get

1759: EXCEPTION
1760: WHEN EXCP_USER_DEFINED THEN
1761: Rollback to transact_temp_record_pub;
1762: x_return_status := FND_API.G_RET_STS_ERROR;
1763: fnd_msg_pub.count_and_get
1764: ( p_count => x_msg_count
1765: , p_data => x_msg_data);
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1766: WHEN FND_API.G_EXC_ERROR THEN
1767: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1768: P_API_NAME => L_API_NAME
1769: ,P_PKG_NAME => G_PKG_NAME
1770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1771: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1772: ,X_MSG_COUNT => X_MSG_COUNT
1773: ,X_MSG_DATA => X_MSG_DATA
1774: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1779: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1776: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1777: P_API_NAME => L_API_NAME
1778: ,P_PKG_NAME => G_PKG_NAME
1779: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1780: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1781: ,X_MSG_COUNT => X_MSG_COUNT
1782: ,X_MSG_DATA => X_MSG_DATA
1783: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1789: fnd_msg_pub.add;

1785: Rollback to transact_temp_record_pub;
1786: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1787: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1788: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1789: fnd_msg_pub.add;
1790: fnd_msg_pub.count_and_get
1791: ( p_count => x_msg_count
1792: , p_data => x_msg_data);
1793: x_return_status := fnd_api.g_ret_sts_error;

Line 1790: fnd_msg_pub.count_and_get

1786: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
1787: fnd_message.set_token ('ROUTINE', l_api_name, FALSE);
1788: fnd_message.set_token ('SQLERRM', sqlerrm, TRUE);
1789: fnd_msg_pub.add;
1790: fnd_msg_pub.count_and_get
1791: ( p_count => x_msg_count
1792: , p_data => x_msg_data);
1793: x_return_status := fnd_api.g_ret_sts_error;
1794: END transact_temp_record;