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.CSI_T_TXN_DETAILS_PVT dependencies on FND_MSG_PUB

Line 186: FND_MSG_PUB.Initialize;

182: SAVEPOINT create_transaction_dtls;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE.
185: IF FND_API.To_Boolean( p_init_msg_list ) THEN
186: FND_MSG_PUB.Initialize;
187: END IF;
188:
189: -- Initialize API return status to success
190: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 275: FND_MSG_PUB.add;

271:
272: FND_MESSAGE.set_name('CSI','CSI_TXN_DETAIL_DUPLICATE');
273: FND_MESSAGE.set_token('SRC_TABLE',px_txn_line_rec.source_transaction_table);
274: FND_MESSAGE.set_token('SRC_ID',px_txn_line_rec.source_transaction_id);
275: FND_MSG_PUB.add;
276:
277: RAISE FND_API.g_exc_error;
278:
279: END IF;

Line 313: FND_MSG_PUB.add;

309:
310: IF px_txn_line_detail_tbl.COUNT = 0 THEN
311: FND_MESSAGE.set_name('CSI','CSI_TXN_MISSING_ENTITY');
312: FND_MESSAGE.set_token('ENTITY','Line Detail Info');
313: FND_MSG_PUB.add;
314: RAISE FND_API.g_exc_error;
315:
316: END IF;
317:

Line 417: fnd_msg_pub.add;

413: EXCEPTION
414: WHEN others THEN
415: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');
416: fnd_message.set_token('MESSAGE','insert_row failed '||sqlerrm);
417: fnd_msg_pub.add;
418: raise fnd_api.g_exc_error;
419: END;
420:
421: END IF;

Line 448: FND_MSG_PUB.add;

444:
445: FND_MESSAGE.set_name('FND','FND_GENERIC_MESSAGE');
446: FND_MESSAGE.set_token('MESSAGE',
447: 'csi_t_txn_systems_grp.create_txn_system API failed.');
448: FND_MSG_PUB.add;
449: RAISE fnd_api.g_exc_error;
450: END IF;
451:
452: px_txn_systems_tbl(l_ind).transaction_line_id := l_txn_line_id;

Line 500: FND_MSG_PUB.add;

496: IF l_return_status <> fnd_api.g_ret_sts_success THEN
497:
498: FND_MESSAGE.set_name('FND','FND_GENERIC_MESSAGE');
499: FND_MESSAGE.set_token('MESSAGE','Failed to convert txn system index to ID');
500: FND_MSG_PUB.add;
501: RAISE FND_API.g_exc_error;
502:
503: END IF;
504:

Line 739: FND_MSG_PUB.Count_And_Get(

735: csi_t_gen_utility_pvt.add('Transaction details created successfully.');
736: csi_t_gen_utility_pvt.set_debug_off;
737:
738: -- Standard call to get message count and if count is get message info.
739: FND_MSG_PUB.Count_And_Get(
740: p_count => x_msg_count,
741: p_data => x_msg_data);
742:
743: EXCEPTION

Line 748: FND_MSG_PUB.Count_And_Get (

744: WHEN FND_API.G_EXC_ERROR THEN
745:
746: ROLLBACK TO create_transaction_dtls;
747: x_return_status := FND_API.G_RET_STS_ERROR ;
748: FND_MSG_PUB.Count_And_Get (
749: p_count => x_msg_count,
750: p_data => x_msg_data);
751: csi_t_gen_utility_pvt.set_debug_off;
752:

Line 758: FND_MSG_PUB.Count_And_Get(

754:
755: ROLLBACK TO create_transaction_dtls;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757:
758: FND_MSG_PUB.Count_And_Get(
759: p_count => x_msg_count,
760: p_data => x_msg_data);
761: csi_t_gen_utility_pvt.set_debug_off;
762:

Line 768: IF FND_MSG_PUB.Check_Msg_Level(

764:
765: ROLLBACK TO create_transaction_dtls;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767:
768: IF FND_MSG_PUB.Check_Msg_Level(
769: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
770:
771: FND_MSG_PUB.Add_Exc_Msg(
772: p_pkg_name => G_PKG_NAME,

Line 769: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

765: ROLLBACK TO create_transaction_dtls;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767:
768: IF FND_MSG_PUB.Check_Msg_Level(
769: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
770:
771: FND_MSG_PUB.Add_Exc_Msg(
772: p_pkg_name => G_PKG_NAME,
773: p_procedure_name => l_api_name);

Line 771: FND_MSG_PUB.Add_Exc_Msg(

767:
768: IF FND_MSG_PUB.Check_Msg_Level(
769: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
770:
771: FND_MSG_PUB.Add_Exc_Msg(
772: p_pkg_name => G_PKG_NAME,
773: p_procedure_name => l_api_name);
774:
775: END IF;

Line 777: FND_MSG_PUB.Count_And_Get(

773: p_procedure_name => l_api_name);
774:
775: END IF;
776:
777: FND_MSG_PUB.Count_And_Get(
778: p_count => x_msg_count,
779: p_data => x_msg_data);
780: csi_t_gen_utility_pvt.set_debug_off;
781:

Line 868: FND_MSG_PUB.Initialize;

864: SAVEPOINT update_transaction_dtls;
865:
866: -- Initialize message list if p_init_msg_list is set to TRUE.
867: IF FND_API.To_Boolean( p_init_msg_list ) THEN
868: FND_MSG_PUB.Initialize;
869: END IF;
870:
871: -- Initialize API return status to success
872: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1585: FND_MSG_PUB.Count_And_Get(

1581: csi_t_gen_utility_pvt.add('Transaction details updated successfully.');
1582: csi_t_gen_utility_pvt.set_debug_off;
1583:
1584: -- Standard call to get message count and if count is get message info.
1585: FND_MSG_PUB.Count_And_Get(
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588:
1589: EXCEPTION

Line 1594: FND_MSG_PUB.Count_And_Get (

1590: WHEN FND_API.G_EXC_ERROR THEN
1591:
1592: ROLLBACK TO update_transaction_dtls;
1593: x_return_status := FND_API.G_RET_STS_ERROR ;
1594: FND_MSG_PUB.Count_And_Get (
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: csi_t_gen_utility_pvt.set_debug_off;
1598:

Line 1604: FND_MSG_PUB.Count_And_Get(

1600:
1601: ROLLBACK TO update_transaction_dtls;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1603:
1604: FND_MSG_PUB.Count_And_Get(
1605: p_count => x_msg_count,
1606: p_data => x_msg_data);
1607: csi_t_gen_utility_pvt.set_debug_off;
1608:

Line 1614: IF FND_MSG_PUB.Check_Msg_Level(

1610:
1611: ROLLBACK TO update_transaction_dtls;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1613:
1614: IF FND_MSG_PUB.Check_Msg_Level(
1615: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1616:
1617: FND_MSG_PUB.Add_Exc_Msg(
1618: p_pkg_name => G_PKG_NAME,

Line 1615: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1611: ROLLBACK TO update_transaction_dtls;
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1613:
1614: IF FND_MSG_PUB.Check_Msg_Level(
1615: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1616:
1617: FND_MSG_PUB.Add_Exc_Msg(
1618: p_pkg_name => G_PKG_NAME,
1619: p_procedure_name => l_api_name);

Line 1617: FND_MSG_PUB.Add_Exc_Msg(

1613:
1614: IF FND_MSG_PUB.Check_Msg_Level(
1615: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1616:
1617: FND_MSG_PUB.Add_Exc_Msg(
1618: p_pkg_name => G_PKG_NAME,
1619: p_procedure_name => l_api_name);
1620:
1621: END IF;

Line 1623: FND_MSG_PUB.Count_And_Get(

1619: p_procedure_name => l_api_name);
1620:
1621: END IF;
1622:
1623: FND_MSG_PUB.Count_And_Get(
1624: p_count => x_msg_count,
1625: p_data => x_msg_data);
1626: csi_t_gen_utility_pvt.set_debug_off;
1627:

Line 1739: FND_MSG_PUB.initialize;

1735: SAVEPOINT delete_transaction_dtls;
1736:
1737: -- Initialize message list if p_init_msg_list is set to TRUE.
1738: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1739: FND_MSG_PUB.initialize;
1740: END IF;
1741:
1742: -- Initialize API return status to success
1743: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1788: fnd_msg_pub.add;

1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1785:
1786: fnd_message.set_name('CSI','CSI_TXN_LINE_ID_INVALID');
1787: fnd_message.set_token('TXN_LINE_ID', p_transaction_line_id);
1788: fnd_msg_pub.add;
1789: RAISE fnd_api.g_exc_error;
1790:
1791: END IF;
1792:

Line 1814: fnd_msg_pub.add;

1810: IF l_return_status = fnd_api.g_true THEN
1811:
1812: fnd_message.set_name('CSI','CSI_TXN_DELETION_NOT_ALLOWED');
1813: fnd_message.set_token('TXN_LINE_ID', p_transaction_line_id);
1814: fnd_msg_pub.add;
1815: RAISE fnd_api.g_exc_error;
1816:
1817: END IF;
1818: END IF;

Line 1907: FND_MSG_PUB.add;

1903:
1904: IF l_return_status = fnd_api.g_true THEN
1905: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_ID_PROCESSED');
1906: FND_MESSAGE.set_token('TXN_LINE_ID',l_transaction_line_id);
1907: FND_MSG_PUB.add;
1908: exit; -- if a relationship is found and that has already been processed to IB then skip it else mark it for deletion
1909: END IF;
1910:
1911: l_ii_ind := l_ii_ind + 1;

Line 1933: FND_MSG_PUB.add;

1929:
1930: IF l_return_status = fnd_api.g_true THEN
1931: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_ID_PROCESSED');
1932: FND_MESSAGE.set_token('TXN_LINE_ID',l_transaction_line_id);
1933: FND_MSG_PUB.add;
1934: exit; -- if a relationship is found and that has already been processed to IB then skip it else mark it for deletion
1935: END IF;
1936: l_ii_ind := l_ii_ind + 1;
1937:

Line 2088: FND_MSG_PUB.Count_And_Get(

2084: for Transaction Line ID:'||to_char(p_transaction_line_id)||
2085: ' Txn line detail ID:'||to_char(p_txn_line_detail_id));
2086:
2087: -- Standard call to get message count and if count is get message info.
2088: FND_MSG_PUB.Count_And_Get(
2089: p_count => x_msg_count,
2090: p_data => x_msg_data);
2091:
2092: EXCEPTION

Line 2097: FND_MSG_PUB.Count_And_Get (

2093: WHEN FND_API.G_EXC_ERROR THEN
2094:
2095: ROLLBACK TO delete_transaction_dtls;
2096: x_return_status := FND_API.G_RET_STS_ERROR ;
2097: FND_MSG_PUB.Count_And_Get (
2098: p_count => x_msg_count,
2099: p_data => x_msg_data);
2100:
2101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2106: FND_MSG_PUB.Count_And_Get(

2102:
2103: ROLLBACK TO delete_transaction_dtls;
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2105:
2106: FND_MSG_PUB.Count_And_Get(
2107: p_count => x_msg_count,
2108: p_data => x_msg_data);
2109:
2110: WHEN OTHERS THEN

Line 2115: IF FND_MSG_PUB.Check_Msg_Level(

2111:
2112: ROLLBACK TO delete_transaction_dtls;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2114:
2115: IF FND_MSG_PUB.Check_Msg_Level(
2116: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2117:
2118: FND_MSG_PUB.Add_Exc_Msg(
2119: p_pkg_name => G_PKG_NAME,

Line 2116: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2112: ROLLBACK TO delete_transaction_dtls;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2114:
2115: IF FND_MSG_PUB.Check_Msg_Level(
2116: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2117:
2118: FND_MSG_PUB.Add_Exc_Msg(
2119: p_pkg_name => G_PKG_NAME,
2120: p_procedure_name => l_api_name);

Line 2118: FND_MSG_PUB.Add_Exc_Msg(

2114:
2115: IF FND_MSG_PUB.Check_Msg_Level(
2116: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2117:
2118: FND_MSG_PUB.Add_Exc_Msg(
2119: p_pkg_name => G_PKG_NAME,
2120: p_procedure_name => l_api_name);
2121:
2122: END IF;

Line 2124: FND_MSG_PUB.Count_And_Get(

2120: p_procedure_name => l_api_name);
2121:
2122: END IF;
2123:
2124: FND_MSG_PUB.Count_And_Get(
2125: p_count => x_msg_count,
2126: p_data => x_msg_data);
2127:
2128: END delete_transaction_dtls;

Line 2445: FND_MSG_PUB.initialize;

2441: SAVEPOINT Get_Transaction_Dtls;
2442:
2443: -- Initialize message list if p_init_msg_list is set to TRUE.
2444: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2445: FND_MSG_PUB.initialize;
2446: END IF;
2447:
2448: -- Initialize API return status to success
2449: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2776: FND_MSG_PUB.Count_And_Get(

2772:
2773: csi_t_gen_utility_pvt.add('Get Transaction Details Successful');
2774:
2775: -- Standard call to get message count and if count is get message info.
2776: FND_MSG_PUB.Count_And_Get(
2777: p_count => x_msg_count,
2778: p_data => x_msg_data);
2779:
2780: EXCEPTION

Line 2786: FND_MSG_PUB.Count_And_Get (

2782:
2783: ROLLBACK TO Get_Transaction_Dtls;
2784: x_return_status := FND_API.G_RET_STS_ERROR ;
2785:
2786: FND_MSG_PUB.Count_And_Get (
2787: p_count => x_msg_count,
2788: p_data => x_msg_data);
2789:
2790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2795: FND_MSG_PUB.Count_And_Get(

2791:
2792: ROLLBACK TO Get_Transaction_Dtls;
2793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2794:
2795: FND_MSG_PUB.Count_And_Get(
2796: p_count => x_msg_count,
2797: p_data => x_msg_data);
2798:
2799: WHEN OTHERS THEN

Line 2804: IF FND_MSG_PUB.Check_Msg_Level(

2800:
2801: ROLLBACK TO Get_Transaction_Dtls;
2802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2803:
2804: IF FND_MSG_PUB.Check_Msg_Level(
2805: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2806:
2807: FND_MSG_PUB.Add_Exc_Msg(
2808: p_pkg_name => G_PKG_NAME,

Line 2805: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2801: ROLLBACK TO Get_Transaction_Dtls;
2802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2803:
2804: IF FND_MSG_PUB.Check_Msg_Level(
2805: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2806:
2807: FND_MSG_PUB.Add_Exc_Msg(
2808: p_pkg_name => G_PKG_NAME,
2809: p_procedure_name => l_api_name);

Line 2807: FND_MSG_PUB.Add_Exc_Msg(

2803:
2804: IF FND_MSG_PUB.Check_Msg_Level(
2805: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2806:
2807: FND_MSG_PUB.Add_Exc_Msg(
2808: p_pkg_name => G_PKG_NAME,
2809: p_procedure_name => l_api_name);
2810:
2811: END IF;

Line 2813: FND_MSG_PUB.Count_And_Get(

2809: p_procedure_name => l_api_name);
2810:
2811: END IF;
2812:
2813: FND_MSG_PUB.Count_And_Get(
2814: p_count => x_msg_count,
2815: p_data => x_msg_data);
2816:
2817: END get_transaction_details;

Line 2904: FND_MSG_PUB.Initialize;

2900: SAVEPOINT split_transaction_dtls;
2901:
2902: -- Initialize message list if p_init_msg_list is set to TRUE.
2903: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2904: FND_MSG_PUB.Initialize;
2905: END IF;
2906:
2907: -- Initialize API return status to success
2908: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3148: FND_MSG_PUB.Count_And_Get(

3144: COMMIT WORK;
3145: END IF;
3146:
3147: -- Standard call to get message count and if count is get message info.
3148: FND_MSG_PUB.Count_And_Get(
3149: p_count => x_msg_count,
3150: p_data => x_msg_data);
3151:
3152: EXCEPTION

Line 3157: FND_MSG_PUB.Count_And_Get (

3153: WHEN fnd_api.g_exc_error THEN
3154:
3155: ROLLBACK TO split_transaction_dtls;
3156: x_return_status := FND_API.G_RET_STS_ERROR ;
3157: FND_MSG_PUB.Count_And_Get (
3158: p_count => x_msg_count,
3159: p_data => x_msg_data);
3160:
3161: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3166: FND_MSG_PUB.Count_And_Get(

3162:
3163: ROLLBACK TO split_transaction_dtls;
3164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3165:
3166: FND_MSG_PUB.Count_And_Get(
3167: p_count => x_msg_count,
3168: p_data => x_msg_data);
3169:
3170: WHEN others THEN

Line 3175: IF FND_MSG_PUB.Check_Msg_Level(

3171:
3172: ROLLBACK TO split_transaction_dtls;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3174:
3175: IF FND_MSG_PUB.Check_Msg_Level(
3176: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3177:
3178: FND_MSG_PUB.Add_Exc_Msg(
3179: p_pkg_name => G_PKG_NAME,

Line 3176: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3172: ROLLBACK TO split_transaction_dtls;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3174:
3175: IF FND_MSG_PUB.Check_Msg_Level(
3176: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3177:
3178: FND_MSG_PUB.Add_Exc_Msg(
3179: p_pkg_name => G_PKG_NAME,
3180: p_procedure_name => l_api_name);

Line 3178: FND_MSG_PUB.Add_Exc_Msg(

3174:
3175: IF FND_MSG_PUB.Check_Msg_Level(
3176: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3177:
3178: FND_MSG_PUB.Add_Exc_Msg(
3179: p_pkg_name => G_PKG_NAME,
3180: p_procedure_name => l_api_name);
3181:
3182: END IF;

Line 3184: FND_MSG_PUB.Count_And_Get(

3180: p_procedure_name => l_api_name);
3181:
3182: END IF;
3183:
3184: FND_MSG_PUB.Count_And_Get(
3185: p_count => x_msg_count,
3186: p_data => x_msg_data);
3187:
3188: END split_transaction_dtls;

Line 3237: FND_MSG_PUB.Initialize;

3233: SAVEPOINT copy_transaction_dtls;
3234:
3235: -- Initialize message list if p_init_msg_list is set to TRUE.
3236: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3237: FND_MSG_PUB.Initialize;
3238: END IF;
3239:
3240: -- Initialize API return status to success
3241: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3391: FND_MSG_PUB.Count_And_Get(

3387: COMMIT WORK;
3388: END IF;
3389:
3390: -- Standard call to get message count and if count is get message info.
3391: FND_MSG_PUB.Count_And_Get(
3392: p_count => x_msg_count,
3393: p_data => x_msg_data);
3394:
3395: EXCEPTION

Line 3400: FND_MSG_PUB.Count_And_Get (

3396: WHEN FND_API.G_EXC_ERROR THEN
3397:
3398: ROLLBACK TO copy_transaction_dtls;
3399: x_return_status := FND_API.G_RET_STS_ERROR ;
3400: FND_MSG_PUB.Count_And_Get (
3401: p_count => x_msg_count,
3402: p_data => x_msg_data);
3403:
3404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3409: FND_MSG_PUB.Count_And_Get(

3405:
3406: ROLLBACK TO copy_transaction_dtls;
3407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3408:
3409: FND_MSG_PUB.Count_And_Get(
3410: p_count => x_msg_count,
3411: p_data => x_msg_data);
3412:
3413: WHEN OTHERS THEN

Line 3418: IF FND_MSG_PUB.Check_Msg_Level(

3414:
3415: ROLLBACK TO copy_transaction_dtls;
3416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3417:
3418: IF FND_MSG_PUB.Check_Msg_Level(
3419: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3420:
3421: FND_MSG_PUB.Add_Exc_Msg(
3422: p_pkg_name => G_PKG_NAME,

Line 3419: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3415: ROLLBACK TO copy_transaction_dtls;
3416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3417:
3418: IF FND_MSG_PUB.Check_Msg_Level(
3419: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3420:
3421: FND_MSG_PUB.Add_Exc_Msg(
3422: p_pkg_name => G_PKG_NAME,
3423: p_procedure_name => l_api_name);

Line 3421: FND_MSG_PUB.Add_Exc_Msg(

3417:
3418: IF FND_MSG_PUB.Check_Msg_Level(
3419: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3420:
3421: FND_MSG_PUB.Add_Exc_Msg(
3422: p_pkg_name => G_PKG_NAME,
3423: p_procedure_name => l_api_name);
3424:
3425: END IF;

Line 3427: FND_MSG_PUB.Count_And_Get(

3423: p_procedure_name => l_api_name);
3424:
3425: END IF;
3426:
3427: FND_MSG_PUB.Count_And_Get(
3428: p_count => x_msg_count,
3429: p_data => x_msg_data);
3430:
3431: END copy_transaction_dtls;

Line 3481: FND_MSG_PUB.Initialize;

3477: SAVEPOINT split_transaction_details;
3478:
3479: -- Initialize message list if p_init_msg_list is set to TRUE.
3480: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3481: FND_MSG_PUB.Initialize;
3482: END IF;
3483:
3484: -- Initialize API return status to success
3485: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3759: FND_MSG_PUB.Count_And_Get(

3755: COMMIT WORK;
3756: END IF;
3757:
3758: -- Standard call to get message count and if count is get message info.
3759: FND_MSG_PUB.Count_And_Get(
3760: p_count => x_msg_count,
3761: p_data => x_msg_data);
3762:
3763: EXCEPTION

Line 3768: FND_MSG_PUB.Count_And_Get (

3764: WHEN FND_API.G_EXC_ERROR THEN
3765:
3766: ROLLBACK TO split_transaction_details;
3767: x_return_status := FND_API.G_RET_STS_ERROR ;
3768: FND_MSG_PUB.Count_And_Get (
3769: p_count => x_msg_count,
3770: p_data => x_msg_data);
3771:
3772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3777: FND_MSG_PUB.Count_And_Get(

3773:
3774: ROLLBACK TO split_transaction_details;
3775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3776:
3777: FND_MSG_PUB.Count_And_Get(
3778: p_count => x_msg_count,
3779: p_data => x_msg_data);
3780:
3781: WHEN OTHERS THEN

Line 3786: IF FND_MSG_PUB.Check_Msg_Level(

3782:
3783: ROLLBACK TO split_transaction_details;
3784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3785:
3786: IF FND_MSG_PUB.Check_Msg_Level(
3787: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3788:
3789: FND_MSG_PUB.Add_Exc_Msg(
3790: p_pkg_name => G_PKG_NAME,

Line 3787: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3783: ROLLBACK TO split_transaction_details;
3784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3785:
3786: IF FND_MSG_PUB.Check_Msg_Level(
3787: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3788:
3789: FND_MSG_PUB.Add_Exc_Msg(
3790: p_pkg_name => G_PKG_NAME,
3791: p_procedure_name => l_api_name);

Line 3789: FND_MSG_PUB.Add_Exc_Msg(

3785:
3786: IF FND_MSG_PUB.Check_Msg_Level(
3787: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3788:
3789: FND_MSG_PUB.Add_Exc_Msg(
3790: p_pkg_name => G_PKG_NAME,
3791: p_procedure_name => l_api_name);
3792:
3793: END IF;

Line 3795: FND_MSG_PUB.Count_And_Get(

3791: p_procedure_name => l_api_name);
3792:
3793: END IF;
3794:
3795: FND_MSG_PUB.Count_And_Get(
3796: p_count => x_msg_count,
3797: p_data => x_msg_data);
3798: END split_transaction_details;
3799: