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
1744: ROLLBACK TO trx_relieve_sa;
1745: x_return_status := fnd_api.g_ret_sts_error;
1746:
1747: l_stmt := 'Stmt' || l_stmt;
1748: fnd_message.set_name('INV', 'INV-Request failed');
1749: fnd_message.set_token('ENTITY',l_api_name);
1750: fnd_message.set_token('ERRORCODE',l_stmt);
1751: fnd_msg_pub.add;
1752:
1745: x_return_status := fnd_api.g_ret_sts_error;
1746:
1747: l_stmt := 'Stmt' || l_stmt;
1748: fnd_message.set_name('INV', 'INV-Request failed');
1749: fnd_message.set_token('ENTITY',l_api_name);
1750: fnd_message.set_token('ERRORCODE',l_stmt);
1751: fnd_msg_pub.add;
1752:
1753: -- Get message count and data
1746:
1747: l_stmt := 'Stmt' || l_stmt;
1748: fnd_message.set_name('INV', 'INV-Request failed');
1749: fnd_message.set_token('ENTITY',l_api_name);
1750: fnd_message.set_token('ERRORCODE',l_stmt);
1751: fnd_msg_pub.add;
1752:
1753: -- Get message count and data
1754: fnd_msg_pub.count_and_get
1759: ROLLBACK TO trx_relieve_sa;
1760: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1761:
1762: l_stmt := 'Stmt' || l_stmt;
1763: fnd_message.set_name('INV', 'INV-Request failed');
1764: fnd_message.set_token('ENTITY',l_api_name);
1765: fnd_message.set_token('ERRORCODE',l_stmt);
1766: fnd_msg_pub.add;
1767:
1760: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1761:
1762: l_stmt := 'Stmt' || l_stmt;
1763: fnd_message.set_name('INV', 'INV-Request failed');
1764: fnd_message.set_token('ENTITY',l_api_name);
1765: fnd_message.set_token('ERRORCODE',l_stmt);
1766: fnd_msg_pub.add;
1767:
1768: -- Get message count and data
1761:
1762: l_stmt := 'Stmt' || l_stmt;
1763: fnd_message.set_name('INV', 'INV-Request failed');
1764: fnd_message.set_token('ENTITY',l_api_name);
1765: fnd_message.set_token('ERRORCODE',l_stmt);
1766: fnd_msg_pub.add;
1767:
1768: -- Get message count and data
1769: fnd_msg_pub.count_and_get
1774: ROLLBACK TO trx_relieve_sa;
1775: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1776:
1777: l_stmt := 'Stmt' || l_stmt;
1778: fnd_message.set_name('INV', 'INV-Request failed');
1779: fnd_message.set_token('ENTITY',l_api_name);
1780: fnd_message.set_token('ERRORCODE',l_stmt);
1781: fnd_msg_pub.add;
1782:
1775: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1776:
1777: l_stmt := 'Stmt' || l_stmt;
1778: fnd_message.set_name('INV', 'INV-Request failed');
1779: fnd_message.set_token('ENTITY',l_api_name);
1780: fnd_message.set_token('ERRORCODE',l_stmt);
1781: fnd_msg_pub.add;
1782:
1783: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1776:
1777: l_stmt := 'Stmt' || l_stmt;
1778: fnd_message.set_name('INV', 'INV-Request failed');
1779: fnd_message.set_token('ENTITY',l_api_name);
1780: fnd_message.set_token('ERRORCODE',l_stmt);
1781: fnd_msg_pub.add;
1782:
1783: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1784: THEN