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

Line 71: fnd_msg_pub.add;

67: BEGIN
68: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
69: fnd_message.set_token('API_NAME', p_api_name);
70: fnd_message.set_token('MISSING_PARAM', p_param_name);
71: fnd_msg_pub.add;
72:
73: END AddMissingArgMsg;
74:
75: /**Name AddFailMsg

Line 89: fnd_msg_pub.add;

85: fnd_message.set_name('OKL', 'OKL_FAILED_OPERATION');
86: fnd_message.set_token('UPDATE', p_operation);
87: fnd_message.set_token('OBJECT', p_object);
88: fnd_message.set_token('OPERATION', p_operation);
89: fnd_msg_pub.add;
90:
91: END AddfailMsg;
92:
93: PROCEDURE Get_Messages (

Line 123: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

119:
120: BEGIN
121: FOR l_count in 1..p_message_count LOOP
122:
123: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
124: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
125: OPEN Get_Appl_Id (l_appl_short_name);
126: FETCH Get_Appl_Id into l_id;
127: CLOSE Get_Appl_Id;

Line 138: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

134: FETCH Get_Message_Num into l_message_num;
135: CLOSE Get_Message_Num;
136: END IF;
137:
138: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
139:
140: IF NVL(l_message_num, 0) <> 0
141: THEN
142: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

Line 150: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

146:
147: IF l_count = 1
148: THEN
149: l_msg_list := l_msg_list || l_temp_msg ||
150: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
151: ELSE
152: l_msg_list := l_msg_list || l_temp_msg ||
153: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
154: END IF;

Line 153: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

149: l_msg_list := l_msg_list || l_temp_msg ||
150: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
151: ELSE
152: l_msg_list := l_msg_list || l_temp_msg ||
153: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
154: END IF;
155:
156: l_msg_list := l_msg_list || '';
157:

Line 243: FND_MSG_PUB.initialize;

239: IF (G_IS_DEBUG_STATEMENT_ON = true)
240: THEN
241: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
242: END IF;
243: FND_MSG_PUB.initialize;
244: END IF;
245:
246: FND_MSG_PUB.Count_And_Get
247: ( p_count => x_msg_count,

Line 246: FND_MSG_PUB.Count_And_Get

242: END IF;
243: FND_MSG_PUB.initialize;
244: END IF;
245:
246: FND_MSG_PUB.Count_And_Get
247: ( p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250:

Line 266: Fnd_Msg_Pub.count_and_get(

262: ROLLBACK TO UPDATE_CRT;
263: x_return_status := Fnd_Api.G_RET_STS_ERROR;
264: x_msg_count := l_msg_count ;
265: x_msg_data := l_msg_data ;
266: Fnd_Msg_Pub.count_and_get(
267: p_count => x_msg_count
268: ,p_data => x_msg_data);
269: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
270: ROLLBACK TO UPDATE_CRT;

Line 274: Fnd_Msg_Pub.count_and_get(

270: ROLLBACK TO UPDATE_CRT;
271: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
272: x_msg_count := l_msg_count ;
273: x_msg_data := l_msg_data ;
274: Fnd_Msg_Pub.count_and_get(
275: p_count => x_msg_count
276: ,p_data => x_msg_data);
277: WHEN OTHERS THEN
278: ROLLBACK TO UPDATE_CRT;

Line 282: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CRT');

278: ROLLBACK TO UPDATE_CRT;
279: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
280: x_msg_count := l_msg_count ;
281: x_msg_data := l_msg_data ;
282: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CRT');
283: Fnd_Msg_Pub.count_and_get(
284: p_count => x_msg_count
285: ,p_data => x_msg_data);
286:

Line 283: Fnd_Msg_Pub.count_and_get(

279: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
280: x_msg_count := l_msg_count ;
281: x_msg_data := l_msg_data ;
282: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CRT');
283: Fnd_Msg_Pub.count_and_get(
284: p_count => x_msg_count
285: ,p_data => x_msg_data);
286:
287: END UPDATE_CRT;

Line 432: FND_MSG_PUB.initialize;

428: END IF;
429: END IF;
430:
431: END LOOP;
432: FND_MSG_PUB.initialize;
433:
434: FND_MSG_PUB.Count_And_Get
435: ( p_count => x_msg_count,
436: p_data => x_msg_data

Line 434: FND_MSG_PUB.Count_And_Get

430:
431: END LOOP;
432: FND_MSG_PUB.initialize;
433:
434: FND_MSG_PUB.Count_And_Get
435: ( p_count => x_msg_count,
436: p_data => x_msg_data
437: );
438:

Line 454: Fnd_Msg_Pub.count_and_get(

450: ROLLBACK TO UPDATE_CAM;
451: x_return_status := Fnd_Api.G_RET_STS_ERROR;
452: x_msg_count := l_msg_count ;
453: x_msg_data := l_msg_data ;
454: Fnd_Msg_Pub.count_and_get(
455: p_count => x_msg_count
456: ,p_data => x_msg_data);
457: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
458: ROLLBACK TO UPDATE_CAM;

Line 462: Fnd_Msg_Pub.count_and_get(

458: ROLLBACK TO UPDATE_CAM;
459: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
460: x_msg_count := l_msg_count ;
461: x_msg_data := l_msg_data ;
462: Fnd_Msg_Pub.count_and_get(
463: p_count => x_msg_count
464: ,p_data => x_msg_data);
465: WHEN OTHERS THEN
466: ROLLBACK TO UPDATE_CAM;

Line 470: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CAM');

466: ROLLBACK TO UPDATE_CAM;
467: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
468: x_msg_count := l_msg_count ;
469: x_msg_data := l_msg_data ;
470: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CAM');
471: Fnd_Msg_Pub.count_and_get(
472: p_count => x_msg_count
473: ,p_data => x_msg_data);
474:

Line 471: Fnd_Msg_Pub.count_and_get(

467: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
468: x_msg_count := l_msg_count ;
469: x_msg_data := l_msg_data ;
470: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_CAM');
471: Fnd_Msg_Pub.count_and_get(
472: p_count => x_msg_count
473: ,p_data => x_msg_data);
474:
475: END UPDATE_CAM;

Line 583: FND_MSG_PUB.initialize;

579: ,'Error in updating okl_trx_ar_invoices_b '||l_message);
580: END IF;
581: raise FND_API.G_EXC_ERROR;
582: ELSE
583: FND_MSG_PUB.initialize;
584: -- update okl_txl_ar_inv_lns set error message,so this will be prefixed before
585: -- the actual message, so it makes more sense than displaying an OKL message.
586:
587: AddfailMsg(

Line 621: FND_MSG_PUB.initialize;

617: ,'Error in updating okl_txl_ar_inv_lns '||l_message);
618: END IF;
619: raise FND_API.G_EXC_ERROR;
620: ELSE
621: FND_MSG_PUB.initialize;
622: -- R12 CHANGE- START
623: AddfailMsg(
624: p_object => 'RECORD IN OKL_TXL_AR_LN_DTLS ',
625: p_operation => 'UPDATE' );

Line 654: FND_MSG_PUB.initialize;

650: x_return_status := l_return_status;
651: END IF;
652: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
653: ELSE
654: FND_MSG_PUB.initialize;
655: END IF; -- for okl_tld_pvt
656:
657: -- R12 CHANGE- END
658:

Line 663: FND_MSG_PUB.Count_And_Get

659: END IF; -- for okl_txl_ar_inv_lns
660:
661: END IF; -- for okl_trx_ar_invoices
662:
663: FND_MSG_PUB.Count_And_Get
664: ( p_count => x_msg_count,
665: p_data => x_msg_data
666: );
667:

Line 684: Fnd_Msg_Pub.count_and_get(

680: ROLLBACK TO UPDATE_INVOICE_HDR_LINES;
681: x_return_status := Fnd_Api.G_RET_STS_ERROR;
682: x_msg_count := l_msg_count ;
683: x_msg_data := l_msg_data ;
684: Fnd_Msg_Pub.count_and_get(
685: p_count => x_msg_count
686: ,p_data => x_msg_data);
687: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR
688: THEN

Line 693: Fnd_Msg_Pub.count_and_get(

689: ROLLBACK TO UPDATE_INVOICE_HDR_LINES;
690: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
691: x_msg_count := l_msg_count ;
692: x_msg_data := l_msg_data ;
693: Fnd_Msg_Pub.count_and_get(
694: p_count => x_msg_count
695: ,p_data => x_msg_data);
696: WHEN OTHERS
697: THEN

Line 702: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICE_HDR_LINES');

698: ROLLBACK TO UPDATE_INVOICE_HDR_LINES;
699: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
700: x_msg_count := l_msg_count ;
701: x_msg_data := l_msg_data ;
702: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICE_HDR_LINES');
703: Fnd_Msg_Pub.count_and_get(
704: p_count => x_msg_count
705: ,p_data => x_msg_data);
706:

Line 703: Fnd_Msg_Pub.count_and_get(

699: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
700: x_msg_count := l_msg_count ;
701: x_msg_data := l_msg_data ;
702: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICE_HDR_LINES');
703: Fnd_Msg_Pub.count_and_get(
704: p_count => x_msg_count
705: ,p_data => x_msg_data);
706:
707: END update_invoice_hdr_lines;

Line 778: FND_MSG_PUB.initialize;

774:
775: -- Initialize message list if requested
776: IF (FND_API.to_Boolean(p_init_msg_list))
777: THEN
778: FND_MSG_PUB.initialize;
779: END IF;
780:
781: -- Initialize API status to success
782: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 845: FND_MSG_PUB.Count_And_Get

841: --TIL
842: /*** End API body ******************************************************/
843:
844: -- Get message count and if count is 1, get message info
845: FND_MSG_PUB.Count_And_Get
846: (p_count => x_msg_count,
847: p_data => x_msg_data);
848:
849: EXCEPTION

Line 853: FND_MSG_PUB.Count_And_Get

849: EXCEPTION
850: WHEN OKL_API.G_EXCEPTION_ERROR THEN
851: ROLLBACK TO additional_tld_attr;
852: x_return_status := OKL_API.G_RET_STS_ERROR;
853: FND_MSG_PUB.Count_And_Get
854: (p_count => x_msg_count,
855: p_data => x_msg_data);
856:
857: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 860: FND_MSG_PUB.Count_And_Get

856:
857: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
858: ROLLBACK TO additional_tld_attr;
859: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
860: FND_MSG_PUB.Count_And_Get
861: (p_count => x_msg_count,
862: p_data => x_msg_data);
863:
864: WHEN OTHERS THEN

Line 873: FND_MSG_PUB.Count_And_Get

869: p_token1 => G_SQLCODE_TOKEN,
870: p_token1_value => SQLCODE,
871: p_token2 => G_SQLERRM_TOKEN,
872: p_token2_value => SQLERRM);
873: FND_MSG_PUB.Count_And_Get
874: (p_count => x_msg_count,
875: p_data => x_msg_data);
876:
877: end additional_tld_attr;

Line 1359: FND_MSG_PUB.initialize;

1355: 'Error in updating okl_trx_ar_invoices_b '||l_message);
1356: END IF;
1357: raise FND_API.G_EXC_ERROR;
1358: ELSE
1359: FND_MSG_PUB.initialize;
1360:
1361: --INSERT okl_txl_ar_inv_lns set error message,so this will be prefixed before
1362: --the actual message, so it makes more sense than displaying an OKL message.
1363:

Line 1408: FND_MSG_PUB.initialize;

1404: 'Error in updating okl_txl_ar_inv_lns '||l_message);
1405: END IF;
1406: raise FND_API.G_EXC_ERROR;
1407: ELSE
1408: FND_MSG_PUB.initialize;
1409:
1410: -- R12 Change - START
1411: -- Ashim's instructions for TXD table
1412: -- populate sty_id, kle_id(NULL), khr_id, amount, til_id_details, txl_ar_line_number

Line 1488: FND_MSG_PUB.initialize;

1484: x_return_status := l_return_status;
1485: END IF;
1486: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1487: ELSE
1488: FND_MSG_PUB.initialize;
1489: END IF; -- for okl_tld_pvt
1490: -- R12 Change - END
1491:
1492: END IF; -- for okl_txl_ar_inv_lns

Line 1496: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1492: END IF; -- for okl_txl_ar_inv_lns
1493:
1494: END IF; -- for okl_trx_ar_invoices
1495:
1496: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1497: p_data => x_msg_data );
1498:
1499: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1500: OKL_DEBUG_PUB.LOG_DEBUG( FND_LOG.LEVEL_STATEMENT

Line 1514: Fnd_Msg_Pub.count_and_get(

1510: ROLLBACK TO INSERT_INVOICE_HDR_LINES;
1511: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1512: x_msg_count := l_msg_count ;
1513: x_msg_data := l_msg_data ;
1514: Fnd_Msg_Pub.count_and_get(
1515: p_count => x_msg_count
1516: ,p_data => x_msg_data);
1517:
1518: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 1523: Fnd_Msg_Pub.count_and_get(

1519: ROLLBACK TO INSERT_INVOICE_HDR_LINES;
1520: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1521: x_msg_count := l_msg_count ;
1522: x_msg_data := l_msg_data ;
1523: Fnd_Msg_Pub.count_and_get(
1524: p_count => x_msg_count
1525: ,p_data => x_msg_data);
1526:
1527: WHEN OTHERS THEN

Line 1532: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','INSERT_INVOICE_HDR_LINES');

1528: ROLLBACK TO INSERT_INVOICE_HDR_LINES;
1529: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1530: x_msg_count := l_msg_count ;
1531: x_msg_data := l_msg_data ;
1532: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','INSERT_INVOICE_HDR_LINES');
1533: Fnd_Msg_Pub.count_and_get(
1534: p_count => x_msg_count
1535: ,p_data => x_msg_data);
1536:

Line 1533: Fnd_Msg_Pub.count_and_get(

1529: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1530: x_msg_count := l_msg_count ;
1531: x_msg_data := l_msg_data ;
1532: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','INSERT_INVOICE_HDR_LINES');
1533: Fnd_Msg_Pub.count_and_get(
1534: p_count => x_msg_count
1535: ,p_data => x_msg_data);
1536:
1537: END insert_invoice_hdr_lines;

Line 1615: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1611: END IF;
1612: raise FND_API.G_EXC_ERROR;
1613: END IF;
1614:
1615: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1616: p_data => x_msg_data );
1617: IF (G_IS_DEBUG_STATEMENT_ON = true)
1618: THEN
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

Line 1632: Fnd_Msg_Pub.count_and_get(

1628: ROLLBACK TO TERMINATE_QUOTE;
1629: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1630: x_msg_count := l_msg_count ;
1631: x_msg_data := l_msg_data ;
1632: Fnd_Msg_Pub.count_and_get(
1633: p_count => x_msg_count
1634: ,p_data => x_msg_data);
1635: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1636: ROLLBACK TO TERMINATE_QUOTE;

Line 1640: Fnd_Msg_Pub.count_and_get(

1636: ROLLBACK TO TERMINATE_QUOTE;
1637: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1638: x_msg_count := l_msg_count ;
1639: x_msg_data := l_msg_data ;
1640: Fnd_Msg_Pub.count_and_get(
1641: p_count => x_msg_count
1642: ,p_data => x_msg_data);
1643: WHEN OTHERS THEN
1644: ROLLBACK TO TERMINATE_QUOTE;

Line 1648: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','TERMINATE_QUOTE');

1644: ROLLBACK TO TERMINATE_QUOTE;
1645: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1646: x_msg_count := l_msg_count ;
1647: x_msg_data := l_msg_data ;
1648: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','TERMINATE_QUOTE');
1649: Fnd_Msg_Pub.count_and_get(
1650: p_count => x_msg_count
1651: ,p_data => x_msg_data);
1652:

Line 1649: Fnd_Msg_Pub.count_and_get(

1645: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1646: x_msg_count := l_msg_count ;
1647: x_msg_data := l_msg_data ;
1648: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','TERMINATE_QUOTE');
1649: Fnd_Msg_Pub.count_and_get(
1650: p_count => x_msg_count
1651: ,p_data => x_msg_data);
1652:
1653: END TERMINATE_QUOTE;

Line 1786: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1782: END IF; --if process is CURE
1783:
1784: END LOOP;
1785:
1786: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1787: p_data => x_msg_data);
1788:
1789: IF (G_IS_DEBUG_STATEMENT_ON = true)
1790: THEN

Line 1804: Fnd_Msg_Pub.count_and_get(

1800: ROLLBACK TO UPDATE_TAI_TIL;
1801: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1802: x_msg_count := l_msg_count ;
1803: x_msg_data := l_msg_data ;
1804: Fnd_Msg_Pub.count_and_get(
1805: p_count => x_msg_count
1806: ,p_data => x_msg_data);
1807: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1808: ROLLBACK TO UPDATE_TAI_TIL;

Line 1812: Fnd_Msg_Pub.count_and_get(

1808: ROLLBACK TO UPDATE_TAI_TIL;
1809: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1810: x_msg_count := l_msg_count ;
1811: x_msg_data := l_msg_data ;
1812: Fnd_Msg_Pub.count_and_get(
1813: p_count => x_msg_count
1814: ,p_data => x_msg_data);
1815: WHEN OTHERS THEN
1816: ROLLBACK TO UPDATE_TAI_TIL;

Line 1820: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_TAI_TIL');

1816: ROLLBACK TO UPDATE_TAI_TIL;
1817: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1818: x_msg_count := l_msg_count ;
1819: x_msg_data := l_msg_data ;
1820: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_TAI_TIL');
1821: Fnd_Msg_Pub.count_and_get(
1822: p_count => x_msg_count
1823: ,p_data => x_msg_data);
1824:

Line 1821: Fnd_Msg_Pub.count_and_get(

1817: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1818: x_msg_count := l_msg_count ;
1819: x_msg_data := l_msg_data ;
1820: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_TAI_TIL');
1821: Fnd_Msg_Pub.count_and_get(
1822: p_count => x_msg_count
1823: ,p_data => x_msg_data);
1824:
1825: END UPDATE_TAI_TIL;

Line 1925: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1921: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
1922: END IF;
1923: END IF;
1924:
1925: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1926: p_data => x_msg_data );
1927:
1928: IF (G_IS_DEBUG_STATEMENT_ON = true)
1929: THEN

Line 1943: Fnd_Msg_Pub.count_and_get(

1939: ROLLBACK TO UPDATE_INVOICES;
1940: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1941: x_msg_count := l_msg_count ;
1942: x_msg_data := l_msg_data ;
1943: Fnd_Msg_Pub.count_and_get(
1944: p_count => x_msg_count
1945: ,p_data => x_msg_data);
1946: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1947: ROLLBACK TO UPDATE_INVOICES;

Line 1951: Fnd_Msg_Pub.count_and_get(

1947: ROLLBACK TO UPDATE_INVOICES;
1948: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1949: x_msg_count := l_msg_count ;
1950: x_msg_data := l_msg_data ;
1951: Fnd_Msg_Pub.count_and_get(
1952: p_count => x_msg_count
1953: ,p_data => x_msg_data);
1954: WHEN OTHERS THEN
1955: ROLLBACK TO UPDATE_INVOICES;

Line 1959: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICES');

1955: ROLLBACK TO UPDATE_INVOICES;
1956: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1957: x_msg_count := l_msg_count ;
1958: x_msg_data := l_msg_data ;
1959: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICES');
1960: Fnd_Msg_Pub.count_and_get(
1961: p_count => x_msg_count
1962: ,p_data => x_msg_data);
1963:

Line 1960: Fnd_Msg_Pub.count_and_get(

1956: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1957: x_msg_count := l_msg_count ;
1958: x_msg_data := l_msg_data ;
1959: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','UPDATE_INVOICES');
1960: Fnd_Msg_Pub.count_and_get(
1961: p_count => x_msg_count
1962: ,p_data => x_msg_data);
1963:
1964: END UPDATE_INVOICES;

Line 2284: FND_MSG_PUB.initialize;

2280: --||l_acc_gen_primary_key_tbl(1).count
2281: ||l_acc_gen_primary_key_tbl(1).primary_key_column
2282: ||l_acc_gen_primary_key_tbl(1).source_table );
2283: END IF;
2284: FND_MSG_PUB.initialize;
2285: END IF;
2286: */
2287:
2288: l_acc_gen_primary_key_tbl(1).source_table := 'FINANCIALS_SYSTEM_PARAMETERS';

Line 2420: FND_MSG_PUB.initialize;

2416: THEN
2417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_template_tbl'||l_template_tbl.count);
2418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'count of l_amount_tbl'||l_amount_tbl.count);
2419: END IF;
2420: FND_MSG_PUB.initialize;
2421: END IF;
2422: END IF ;-- IF p.cam.tbl(i).Process ='CURE'
2423: END LOOP;
2424:

Line 2432: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2428: G_MODULE,
2429: 'after accounting dist '||l_return_status);
2430: END IF;
2431:
2432: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2433: p_data => x_msg_data );
2434: IF (G_IS_DEBUG_STATEMENT_ON = true)
2435: THEN
2436: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT,

Line 2449: Fnd_Msg_Pub.count_and_get(

2445: ROLLBACK TO CREATE_ACCOUNTING;
2446: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2447: x_msg_count := l_msg_count ;
2448: x_msg_data := l_msg_data ;
2449: Fnd_Msg_Pub.count_and_get(
2450: p_count => x_msg_count
2451: ,p_data => x_msg_data);
2452: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2453: ROLLBACK TO CREATE_ACCOUNTING;

Line 2457: Fnd_Msg_Pub.count_and_get(

2453: ROLLBACK TO CREATE_ACCOUNTING;
2454: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2455: x_msg_count := l_msg_count ;
2456: x_msg_data := l_msg_data ;
2457: Fnd_Msg_Pub.count_and_get(
2458: p_count => x_msg_count
2459: ,p_data => x_msg_data);
2460: WHEN OTHERS THEN
2461: ROLLBACK TO CREATE_ACCOUNTING;

Line 2465: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','CREATE_ACCOUNTING');

2461: ROLLBACK TO CREATE_ACCOUNTING;
2462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2463: x_msg_count := l_msg_count ;
2464: x_msg_data := l_msg_data ;
2465: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','CREATE_ACCOUNTING');
2466: Fnd_Msg_Pub.count_and_get(
2467: p_count => x_msg_count
2468: ,p_data => x_msg_data);
2469:

Line 2466: Fnd_Msg_Pub.count_and_get(

2462: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2463: x_msg_count := l_msg_count ;
2464: x_msg_data := l_msg_data ;
2465: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','CREATE_ACCOUNTING');
2466: Fnd_Msg_Pub.count_and_get(
2467: p_count => x_msg_count
2468: ,p_data => x_msg_data);
2469:
2470: END CREATE_ACCOUNTING;

Line 2585: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2581: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updated cure reports table ');
2582: END IF;
2583: END IF;
2584:
2585: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2586: p_data => x_msg_data );
2587:
2588: IF (G_IS_DEBUG_STATEMENT_ON = true)
2589: THEN

Line 2604: Fnd_Msg_Pub.count_and_get(

2600: ROLLBACK TO SUBMIT_INVOICES;
2601: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2602: x_msg_count := l_msg_count ;
2603: x_msg_data := l_msg_data ;
2604: Fnd_Msg_Pub.count_and_get(
2605: p_count => x_msg_count
2606: ,p_data => x_msg_data);
2607: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2608: ROLLBACK TO SUBMIT_INVOICES;

Line 2612: Fnd_Msg_Pub.count_and_get(

2608: ROLLBACK TO SUBMIT_INVOICES;
2609: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2610: x_msg_count := l_msg_count ;
2611: x_msg_data := l_msg_data ;
2612: Fnd_Msg_Pub.count_and_get(
2613: p_count => x_msg_count
2614: ,p_data => x_msg_data);
2615: WHEN OTHERS THEN
2616: ROLLBACK TO SUBMIT_INVOICES;

Line 2620: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','SUBMIT_INVOICES');

2616: ROLLBACK TO SUBMIT_INVOICES;
2617: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2618: x_msg_count := l_msg_count ;
2619: x_msg_data := l_msg_data ;
2620: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','SUBMIT_INVOICES');
2621: Fnd_Msg_Pub.count_and_get(
2622: p_count => x_msg_count
2623: ,p_data => x_msg_data);
2624:

Line 2621: Fnd_Msg_Pub.count_and_get(

2617: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2618: x_msg_count := l_msg_count ;
2619: x_msg_data := l_msg_data ;
2620: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RECON_PVT','SUBMIT_INVOICES');
2621: Fnd_Msg_Pub.count_and_get(
2622: p_count => x_msg_count
2623: ,p_data => x_msg_data);
2624:
2625: END SUBMIT_INVOICES;

Line 2702: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Invoices updated');
2699: END IF;
2700: END IF;
2701:
2702: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2703: p_data => x_msg_data);
2704:
2705: IF (G_IS_DEBUG_STATEMENT_ON = true)
2706: THEN

Line 2720: Fnd_Msg_Pub.count_and_get(

2716: ROLLBACK TO UPDATE_CURE_INVOICE_PVT;
2717: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2718: x_msg_count := l_msg_count ;
2719: x_msg_data := l_msg_data ;
2720: Fnd_Msg_Pub.count_and_get(
2721: p_count => x_msg_count
2722: ,p_data => x_msg_data);
2723: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2724: ROLLBACK TO UPDATE_CURE_INVOICE_PVT;

Line 2728: Fnd_Msg_Pub.count_and_get(

2724: ROLLBACK TO UPDATE_CURE_INVOICE_PVT;
2725: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2726: x_msg_count := l_msg_count ;
2727: x_msg_data := l_msg_data ;
2728: Fnd_Msg_Pub.count_and_get(
2729: p_count => x_msg_count
2730: ,p_data => x_msg_data);
2731: WHEN OTHERS THEN
2732: ROLLBACK TO UPDATE_CURE_INVOICE_PVT;

Line 2736: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_RECON_PVT','UPDATE_CURE_INVOICE');

2732: ROLLBACK TO UPDATE_CURE_INVOICE_PVT;
2733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2734: x_msg_count := l_msg_count ;
2735: x_msg_data := l_msg_data ;
2736: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_RECON_PVT','UPDATE_CURE_INVOICE');
2737: Fnd_Msg_Pub.count_and_get(
2738: p_count => x_msg_count
2739: ,p_data => x_msg_data);
2740:

Line 2737: Fnd_Msg_Pub.count_and_get(

2733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2734: x_msg_count := l_msg_count ;
2735: x_msg_data := l_msg_data ;
2736: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_RECON_PVT','UPDATE_CURE_INVOICE');
2737: Fnd_Msg_Pub.count_and_get(
2738: p_count => x_msg_count
2739: ,p_data => x_msg_data);
2740:
2741: END UPDATE_CURE_INVOICE;