806: ROLLBACK TO trx_relieve_sa;
807: x_return_status := fnd_api.g_ret_sts_error;
808:
809: l_stmt := 'Stmt' || l_stmt;
810: fnd_message.set_name('INV', 'INV-Request failed');
811: fnd_message.set_token('ENTITY',l_api_name);
812: fnd_message.set_token('ERRORCODE',l_stmt);
813: fnd_msg_pub.add;
814:
807: x_return_status := fnd_api.g_ret_sts_error;
808:
809: l_stmt := 'Stmt' || l_stmt;
810: fnd_message.set_name('INV', 'INV-Request failed');
811: fnd_message.set_token('ENTITY',l_api_name);
812: fnd_message.set_token('ERRORCODE',l_stmt);
813: fnd_msg_pub.add;
814:
815: -- Get message count and data
808:
809: l_stmt := 'Stmt' || l_stmt;
810: fnd_message.set_name('INV', 'INV-Request failed');
811: fnd_message.set_token('ENTITY',l_api_name);
812: fnd_message.set_token('ERRORCODE',l_stmt);
813: fnd_msg_pub.add;
814:
815: -- Get message count and data
816: fnd_msg_pub.count_and_get
821: ROLLBACK TO trx_relieve_sa;
822: x_return_status := fnd_api.g_ret_sts_unexp_error ;
823:
824: l_stmt := 'Stmt' || l_stmt;
825: fnd_message.set_name('INV', 'INV-Request failed');
826: fnd_message.set_token('ENTITY',l_api_name);
827: fnd_message.set_token('ERRORCODE',l_stmt);
828: fnd_msg_pub.add;
829:
822: x_return_status := fnd_api.g_ret_sts_unexp_error ;
823:
824: l_stmt := 'Stmt' || l_stmt;
825: fnd_message.set_name('INV', 'INV-Request failed');
826: fnd_message.set_token('ENTITY',l_api_name);
827: fnd_message.set_token('ERRORCODE',l_stmt);
828: fnd_msg_pub.add;
829:
830: -- Get message count and data
823:
824: l_stmt := 'Stmt' || l_stmt;
825: fnd_message.set_name('INV', 'INV-Request failed');
826: fnd_message.set_token('ENTITY',l_api_name);
827: fnd_message.set_token('ERRORCODE',l_stmt);
828: fnd_msg_pub.add;
829:
830: -- Get message count and data
831: fnd_msg_pub.count_and_get
836: ROLLBACK TO trx_relieve_sa;
837: x_return_status := fnd_api.g_ret_sts_unexp_error ;
838:
839: l_stmt := 'Stmt' || l_stmt;
840: fnd_message.set_name('INV', 'INV-Request failed');
841: fnd_message.set_token('ENTITY',l_api_name);
842: fnd_message.set_token('ERRORCODE',l_stmt);
843: fnd_msg_pub.add;
844:
837: x_return_status := fnd_api.g_ret_sts_unexp_error ;
838:
839: l_stmt := 'Stmt' || l_stmt;
840: fnd_message.set_name('INV', 'INV-Request failed');
841: fnd_message.set_token('ENTITY',l_api_name);
842: fnd_message.set_token('ERRORCODE',l_stmt);
843: fnd_msg_pub.add;
844:
845: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
838:
839: l_stmt := 'Stmt' || l_stmt;
840: fnd_message.set_name('INV', 'INV-Request failed');
841: fnd_message.set_token('ENTITY',l_api_name);
842: fnd_message.set_token('ERRORCODE',l_stmt);
843: fnd_msg_pub.add;
844:
845: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
846: THEN
1741: ROLLBACK TO trx_relieve_sa;
1742: x_return_status := fnd_api.g_ret_sts_error;
1743:
1744: l_stmt := 'Stmt' || l_stmt;
1745: fnd_message.set_name('INV', 'INV-Request failed');
1746: fnd_message.set_token('ENTITY',l_api_name);
1747: fnd_message.set_token('ERRORCODE',l_stmt);
1748: fnd_msg_pub.add;
1749:
1742: x_return_status := fnd_api.g_ret_sts_error;
1743:
1744: l_stmt := 'Stmt' || l_stmt;
1745: fnd_message.set_name('INV', 'INV-Request failed');
1746: fnd_message.set_token('ENTITY',l_api_name);
1747: fnd_message.set_token('ERRORCODE',l_stmt);
1748: fnd_msg_pub.add;
1749:
1750: -- Get message count and data
1743:
1744: l_stmt := 'Stmt' || l_stmt;
1745: fnd_message.set_name('INV', 'INV-Request failed');
1746: fnd_message.set_token('ENTITY',l_api_name);
1747: fnd_message.set_token('ERRORCODE',l_stmt);
1748: fnd_msg_pub.add;
1749:
1750: -- Get message count and data
1751: fnd_msg_pub.count_and_get
1756: ROLLBACK TO trx_relieve_sa;
1757: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1758:
1759: l_stmt := 'Stmt' || l_stmt;
1760: fnd_message.set_name('INV', 'INV-Request failed');
1761: fnd_message.set_token('ENTITY',l_api_name);
1762: fnd_message.set_token('ERRORCODE',l_stmt);
1763: fnd_msg_pub.add;
1764:
1757: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1758:
1759: l_stmt := 'Stmt' || l_stmt;
1760: fnd_message.set_name('INV', 'INV-Request failed');
1761: fnd_message.set_token('ENTITY',l_api_name);
1762: fnd_message.set_token('ERRORCODE',l_stmt);
1763: fnd_msg_pub.add;
1764:
1765: -- Get message count and data
1758:
1759: l_stmt := 'Stmt' || l_stmt;
1760: fnd_message.set_name('INV', 'INV-Request failed');
1761: fnd_message.set_token('ENTITY',l_api_name);
1762: fnd_message.set_token('ERRORCODE',l_stmt);
1763: fnd_msg_pub.add;
1764:
1765: -- Get message count and data
1766: fnd_msg_pub.count_and_get
1771: ROLLBACK TO trx_relieve_sa;
1772: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1773:
1774: l_stmt := 'Stmt' || l_stmt;
1775: fnd_message.set_name('INV', 'INV-Request failed');
1776: fnd_message.set_token('ENTITY',l_api_name);
1777: fnd_message.set_token('ERRORCODE',l_stmt);
1778: fnd_msg_pub.add;
1779:
1772: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1773:
1774: l_stmt := 'Stmt' || l_stmt;
1775: fnd_message.set_name('INV', 'INV-Request failed');
1776: fnd_message.set_token('ENTITY',l_api_name);
1777: fnd_message.set_token('ERRORCODE',l_stmt);
1778: fnd_msg_pub.add;
1779:
1780: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1773:
1774: l_stmt := 'Stmt' || l_stmt;
1775: fnd_message.set_name('INV', 'INV-Request failed');
1776: fnd_message.set_token('ENTITY',l_api_name);
1777: fnd_message.set_token('ERRORCODE',l_stmt);
1778: fnd_msg_pub.add;
1779:
1780: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1781: THEN