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

Line 103: FND_MSG_PUB.ADD;

99:
100: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
101: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.derive_end_date', FALSE);
102: END IF;
103: FND_MSG_PUB.ADD;
104: RAISE FND_API.g_exc_error;
105:
106: END IF;
107:

Line 146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

142: --first log the sqlerrm
143: l_error_text := substr (SQLERRM, 1, 240);
144: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
145: --then add it to the message api list
146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
147: END IF;
148: RAISE;
149:
150: END GET_END_DATE;

Line 392: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

388: --first log the sqlerrm
389: l_error_text := substr (SQLERRM, 1, 240);
390: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.delete_dnr_lines.end_other_error', l_error_text);
391: --then add it to the message api list
392: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
393: END IF;
394: IF (c_dnr_lines%isopen) THEN
395: CLOSE c_dnr_lines;
396: END IF;

Line 661: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

657: --first log the sqlerrm
658: l_error_text := substr (SQLERRM, 1, 240);
659: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
660: --then add it to the message api list
661: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
662: END IF;
663: IF (c_lines%isopen) THEN
664: CLOSE c_lines;
665: END IF;

Line 762: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

758: x_return_status := FND_API.g_ret_sts_unexp_error ;
759: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
760: l_error_text := substr (SQLERRM, 1, 240);
761: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
762: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
763: END IF;
764: IF (c_old_lines%isopen) THEN
765: CLOSE c_old_lines;
766: END IF;

Line 882: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

878: x_return_status := FND_API.g_ret_sts_unexp_error ;
879: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
880: l_error_text := substr (SQLERRM, 1, 240);
881: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
882: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
883: END IF;
884: IF (c_condition_headers%isopen) THEN
885: CLOSE c_condition_headers;
886: END IF;

Line 1066: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1062: --first log the sqlerrm
1063: l_error_text := substr (SQLERRM, 1, 240);
1064: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1065: --then add it to the message api list
1066: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1067: END IF;
1068: IF (c_top_lines%isopen) THEN
1069: CLOSE c_top_lines;
1070: END IF;

Line 1256: FND_MSG_PUB.add;

1252: FND_MESSAGE.set_token('STATE', l_state_code);
1253: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1254: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_winners_error', FALSE);
1255: END IF;
1256: FND_MSG_PUB.add;
1257: RAISE FND_API.g_exc_error;
1258: END IF;
1259:
1260: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 1298: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1294: --first log the sqlerrm
1295: l_error_text := substr (SQLERRM, 1, 240);
1296: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1297: --then add it to the message api list
1298: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1299: END IF;
1300: IF (c_vendor_details%isopen) THEN
1301: CLOSE c_vendor_details;
1302: END IF;

Line 1449: FND_MSG_PUB.add;

1445: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');
1446: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1447: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.rev_type_chk', FALSE);
1448: END IF;
1449: FND_MSG_PUB.add;
1450: RAISE FND_API.g_exc_error;
1451: ELSE
1452: DELETE FROM oks_k_sales_credits
1453: WHERE chr_id = p_chr_id;

Line 1463: FND_MSG_PUB.add;

1459: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');
1460: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1461: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.rev_type_chk', FALSE);
1462: END IF;
1463: FND_MSG_PUB.add;
1464: RAISE FND_API.g_exc_error;
1465: ELSE
1466: DELETE FROM oks_k_sales_credits
1467: WHERE chr_id = p_chr_id AND sales_credit_type_id1 = l_prof_rev_type;

Line 1488: FND_MSG_PUB.ADD;

1484: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1485: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1486: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_org_party', FALSE);
1487: END IF;
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.g_exc_error;
1490: END IF;
1491:
1492: --get the winning salesrep either from JTF or profile option

Line 1530: FND_MSG_PUB.ADD;

1526: FND_MESSAGE.set_token('RESOURCE_ID', l_resource_id);
1527: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1528: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_jtf_salesrep', FALSE);
1529: END IF;
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.g_exc_error;
1532: END IF;
1533:
1534: ELSE

Line 1548: FND_MSG_PUB.add;

1544: FND_MESSAGE.set_token('PROFILE', 'OKS_SALESPERSON_ID');
1545: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1546: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_prof_salesrep', FALSE);
1547: END IF;
1548: FND_MSG_PUB.add;
1549: RAISE FND_API.g_exc_error;
1550: END IF;
1551:
1552: END IF; --of IF (l_prof_use_jtf = 'YES') THEN

Line 1577: FND_MSG_PUB.add;

1573: FND_MESSAGE.set_token('ORG_NAME', l_org_name);
1574: IF (FND_LOG.level_event >= FND_LOG.g_current_runtime_level) THEN
1575: FND_LOG.message(FND_LOG.level_event, l_mod_name || '.org_id_match', FALSE);
1576: END IF;
1577: FND_MSG_PUB.add;
1578: x_return_status := OKC_API.g_ret_sts_warning;
1579: RETURN;
1580: END IF;
1581:

Line 1597: FND_MSG_PUB.add;

1593: FND_MESSAGE.set_token('CONTRACT_ID', to_char(p_chr_id));
1594: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1595: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_ven_mer_id', FALSE);
1596: END IF;
1597: FND_MSG_PUB.add;
1598: RAISE FND_API.g_exc_error;
1599: END IF;
1600:
1601: --get the first cro_code from vendor/merchant contact sources that are based on the

Line 1618: FND_MSG_PUB.add;

1614: FND_MESSAGE.set_token('RLE_CODE', l_rle_code);
1615: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1616: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_cro_code', FALSE);
1617: END IF;
1618: FND_MSG_PUB.add;
1619: RAISE FND_API.g_exc_error;
1620: END IF;
1621:
1622: --get the sales group id for the salesrep

Line 1704: FND_MSG_PUB.add;

1700: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE_DIST');
1701: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1702: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_rev_type_dist', FALSE);
1703: END IF;
1704: FND_MSG_PUB.add;
1705: RAISE FND_API.g_exc_error;
1706: END IF;
1707:
1708: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1850: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1846: --first log the sqlerrm
1847: l_error_text := substr (SQLERRM, 1, 240);
1848: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1849: --then add it to the message api list
1850: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1851: END IF;
1852: IF ( c_res_salesrep%isopen ) THEN
1853: CLOSE c_res_salesrep;
1854: END IF;

Line 2017: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2013: --first log the sqlerrm
2014: l_error_text := substr (SQLERRM, 1, 240);
2015: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2016: --then add it to the message api list
2017: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2018: END IF;
2019: IF ( c_subscr_service_lines%isopen ) THEN
2020: CLOSE c_subscr_service_lines;
2021: END IF;

Line 2186: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2182: --first log the sqlerrm
2183: l_error_text := substr (SQLERRM, 1, 240);
2184: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2185: --then add it to the message api list
2186: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2187: END IF;
2188: IF ( c_get_usage_price_locks%isopen ) THEN
2189: CLOSE c_get_usage_price_locks;
2190: END IF;

Line 2356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2352: --first log the sqlerrm
2353: l_error_text := substr (SQLERRM, 1, 240);
2354: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2355: --then add it to the message api list
2356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2357: END IF;
2358: IF (c_hdr_strlvl%isopen) THEN
2359: CLOSE c_hdr_strlvl;
2360: END IF;

Line 2567: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2563: --first log the sqlerrm
2564: l_error_text := substr (SQLERRM, 1, 240);
2565: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2566: --then add it to the message api list
2567: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2568: END IF;
2569: IF (c_get_top_lines%isopen) THEN
2570: CLOSE c_get_top_lines;
2571: END IF;

Line 2790: FND_MSG_PUB.ADD;

2786: FND_MESSAGE.set_token('INVOICE_RULE_ID', l_invoice_rule_id);
2787: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2788: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_invoice_rule', FALSE);
2789: END IF;
2790: FND_MSG_PUB.ADD;
2791: RAISE FND_API.g_exc_error;
2792: END IF;
2793:
2794: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2809: FND_MSG_PUB.ADD;

2805: FND_MESSAGE.set_token('ACCTG_RULE_ID', l_account_rule_id);
2806: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2807: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_accounting_rule', FALSE);
2808: END IF;
2809: FND_MSG_PUB.ADD;
2810: RAISE FND_API.g_exc_error;
2811: END IF;
2812:
2813: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2891: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2887: --first log the sqlerrm
2888: l_error_text := substr (SQLERRM, 1, 240);
2889: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2890: --then add it to the message api list
2891: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2892: END IF;
2893: IF (c_bp_toplines%isopen) THEN
2894: CLOSE c_bp_toplines;
2895: END IF;

Line 3145: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

3141: --first log the sqlerrm
3142: l_error_text := substr (SQLERRM, 1, 240);
3143: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3144: --then add it to the message api list
3145: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3146: END IF;
3147: IF (c_hdr_dates%isopen) THEN
3148: CLOSE c_hdr_dates;
3149: END IF;

Line 3271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

3267: --first log the sqlerrm
3268: l_error_text := substr (SQLERRM, 1, 240);
3269: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3270: --then add it to the message api list
3271: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3272: END IF;
3273: IF (c_group_csr%isopen) THEN
3274: CLOSE c_group_csr;
3275: END IF;

Line 3435: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

3431: --first log the sqlerrm
3432: l_error_text := substr (SQLERRM, 1, 240);
3433: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3434: --then add it to the message api list
3435: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3436: END IF;
3437: IF (c_pdf%isopen) THEN
3438: CLOSE c_pdf;
3439: END IF;

Line 3850: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

3846: --first log the sqlerrm
3847: l_error_text := substr (SQLERRM, 1, 240);
3848: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3849: --then add it to the message api list
3850: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3851: END IF;
3852: IF (c_k_hdr%isopen) THEN
3853: CLOSE c_k_hdr;
3854: END IF;

Line 4034: FND_MSG_PUB.initialize;

4030: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4032: END IF;
4033: IF FND_API.to_boolean(p_init_msg_list ) THEN
4034: FND_MSG_PUB.initialize;
4035: END IF;
4036: x_return_status := FND_API.G_RET_STS_SUCCESS;
4037: x_validation_status := G_VALID_STS_SUCCESS;
4038:

Line 4050: FND_MSG_PUB.ADD;

4046: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4047: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4048: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_values', FALSE);
4049: END IF;
4050: FND_MSG_PUB.ADD;
4051: CLOSE c_k_hdr;
4052: RAISE FND_API.g_exc_error;
4053: END IF;
4054: CLOSE c_k_hdr;

Line 4350: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4346: END LOOP;
4347: END IF;
4348: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_validation_status=' || x_validation_status ||', x_return_status='|| x_return_status);
4349: END IF;
4350: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4351:
4352: EXCEPTION
4353: WHEN FND_API.g_exc_error THEN
4354: x_return_status := FND_API.g_ret_sts_error ;

Line 4359: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4355:
4356: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4357: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
4358: END IF;
4359: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4360:
4361: IF (c_k_hdr%isopen) THEN
4362: CLOSE c_k_hdr;
4363: END IF;

Line 4389: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4385:
4386: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4387: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
4388: END IF;
4389: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4390:
4391: IF (c_k_hdr%isopen) THEN
4392: CLOSE c_k_hdr;
4393: END IF;

Line 4421: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

4417: --first log the sqlerrm
4418: l_error_text := substr (SQLERRM, 1, 240);
4419: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4420: --then add it to the message api list
4421: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4422: END IF;
4423: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4424:
4425: IF (c_k_hdr%isopen) THEN

Line 4423: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4419: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4420: --then add it to the message api list
4421: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4422: END IF;
4423: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4424:
4425: IF (c_k_hdr%isopen) THEN
4426: CLOSE c_k_hdr;
4427: END IF;

Line 4631: FND_MSG_PUB.initialize;

4627: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4629: END IF;
4630: IF FND_API.to_boolean(p_init_msg_list ) THEN
4631: FND_MSG_PUB.initialize;
4632: END IF;
4633: x_return_status := FND_API.G_RET_STS_SUCCESS;
4634:
4635: --we will first get and update the topline invoice text

Line 4751: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4747: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4748: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
4749: END IF;
4750: END IF;
4751: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4752:
4753: EXCEPTION
4754: WHEN FND_API.g_exc_error THEN
4755: ROLLBACK TO update_invoice_text_PVT;

Line 4761: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4757:
4758: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4759: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
4760: END IF;
4761: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4762:
4763: WHEN FND_API.g_exc_unexpected_error THEN
4764: ROLLBACK TO update_invoice_text_PVT;
4765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4770: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4766:
4767: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4768: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
4769: END IF;
4770: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4771:
4772: WHEN OTHERS THEN
4773: ROLLBACK TO update_invoice_text_PVT;
4774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4781: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

4777: --first log the sqlerrm
4778: l_error_text := substr (SQLERRM, 1, 240);
4779: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4780: --then add it to the message api list
4781: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4782: END IF;
4783: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4784:
4785: END UPDATE_INVOICE_TEXT;

Line 4783: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4779: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4780: --then add it to the message api list
4781: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4782: END IF;
4783: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4784:
4785: END UPDATE_INVOICE_TEXT;
4786:
4787: /*

Line 4869: FND_MSG_PUB.initialize;

4865: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4867: END IF;
4868: IF FND_API.to_boolean(p_init_msg_list ) THEN
4869: FND_MSG_PUB.initialize;
4870: END IF;
4871: x_return_status := FND_API.G_RET_STS_SUCCESS;
4872:
4873: --first get the contract org and id for the merchant/vendor record in okc_k_party_roles_b

Line 4884: FND_MSG_PUB.ADD;

4880: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4881: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4882: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
4883: END IF;
4884: FND_MSG_PUB.ADD;
4885: RAISE FND_API.g_exc_error;
4886: END IF;
4887:
4888: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 4954: FND_MSG_PUB.ADD;

4950: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_HELPDESK');
4951: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4952: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_helpdesk_user', FALSE);
4953: END IF;
4954: FND_MSG_PUB.ADD;
4955: RAISE FND_API.g_exc_error;
4956: END IF;
4957: */
4958:

Line 4974: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4970:
4971: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4972: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_user_id='||x_user_id||' ,x_user_name='||x_user_name);
4973: END IF;
4974: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4975:
4976: EXCEPTION
4977: WHEN FND_API.g_exc_error THEN
4978: x_return_status := FND_API.g_ret_sts_error ;

Line 4992: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

4988: END IF;
4989: IF (c_fnd_user%isopen) THEN
4990: CLOSE c_fnd_user;
4991: END IF;
4992: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4993:
4994: WHEN FND_API.g_exc_unexpected_error THEN
4995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4996:

Line 5009: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

5005: END IF;
5006: IF (c_fnd_user%isopen) THEN
5007: CLOSE c_fnd_user;
5008: END IF;
5009: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5010:
5011: WHEN OTHERS THEN
5012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5013:

Line 5019: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

5015: --first log the sqlerrm
5016: l_error_text := substr (SQLERRM, 1, 240);
5017: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5018: --then add it to the message api list
5019: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5020: END IF;
5021: IF (c_k_hdr%isopen) THEN
5022: CLOSE c_k_hdr;
5023: END IF;

Line 5030: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

5026: END IF;
5027: IF (c_fnd_user%isopen) THEN
5028: CLOSE c_fnd_user;
5029: END IF;
5030: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5031:
5032: END GET_USER_NAME;
5033:
5034:

Line 5167: FND_MSG_PUB.initialize;

5163: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
5164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5165: END IF;
5166: IF FND_API.to_boolean(p_init_msg_list ) THEN
5167: FND_MSG_PUB.initialize;
5168: END IF;
5169: x_return_status := FND_API.G_RET_STS_SUCCESS;
5170:
5171: /*

Line 5195: FND_MSG_PUB.ADD;

5191: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
5192: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5193: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation1', FALSE);
5194: END IF;
5195: FND_MSG_PUB.ADD;
5196: CLOSE c_k_hdr;
5197: RAISE FND_API.g_exc_error;
5198: END IF;
5199: CLOSE c_k_hdr;

Line 5207: FND_MSG_PUB.ADD;

5203: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_END');
5204: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5205: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation2', FALSE);
5206: END IF;
5207: FND_MSG_PUB.ADD;
5208: RAISE FND_API.g_exc_error;
5209: END IF;
5210:
5211: --new end date < new start date, if new start date is null use old end date + 1

Line 5219: FND_MSG_PUB.ADD;

5215: FND_MESSAGE.set_token('END_DATE', to_char(p_new_end_date));
5216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5217: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation3', FALSE);
5218: END IF;
5219: FND_MSG_PUB.ADD;
5220: RAISE FND_API.g_exc_error;
5221: END IF;
5222: --end basic parameter validation
5223:

Line 5278: --add all validation messages to the FND_MSG_PUB stack

5274: IF ( (l_validation_status = G_VALID_STS_ERROR) OR
5275: ( (l_validation_status = G_VALID_STS_WARNING) AND
5276: (p_renewal_called_from_ui = 'N') )
5277: ) THEN
5278: --add all validation messages to the FND_MSG_PUB stack
5279: FOR i in l_validation_tbl.FIRST..l_validation_tbl.LAST LOOP
5280: --OKS_USER_DEFINED_MESSAGE is a special message, with the message body = MESSAGE
5281: --This is a workaround, because we can't directly add messages to the msg API list
5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)

Line 5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)

5278: --add all validation messages to the FND_MSG_PUB stack
5279: FOR i in l_validation_tbl.FIRST..l_validation_tbl.LAST LOOP
5280: --OKS_USER_DEFINED_MESSAGE is a special message, with the message body = MESSAGE
5281: --This is a workaround, because we can't directly add messages to the msg API list
5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)
5283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');
5284: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);
5285: FND_MSG_PUB.add;
5286: END LOOP;

Line 5285: FND_MSG_PUB.add;

5281: --This is a workaround, because we can't directly add messages to the msg API list
5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)
5283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');
5284: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);
5285: FND_MSG_PUB.add;
5286: END LOOP;
5287: RAISE FND_API.g_exc_error;
5288: END IF;
5289: --end renewal validation

Line 5849: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

5845: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
5846: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_chr_id=' || x_chr_id ||', x_return_status='|| x_return_status);
5847: END IF;
5848: END IF;
5849: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5850:
5851: EXCEPTION
5852: WHEN FND_API.g_exc_error THEN
5853: ROLLBACK TO renew_contract_PVT;

Line 5859: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

5855:
5856: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5857: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5858: END IF;
5859: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5860: IF (c_k_hdr%isopen) THEN
5861: CLOSE c_k_hdr;
5862: END IF;
5863: IF (c_renk_hdr%isopen) THEN

Line 5874: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

5870:
5871: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5872: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5873: END IF;
5874: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5875: IF (c_k_hdr%isopen) THEN
5876: CLOSE c_k_hdr;
5877: END IF;
5878: IF (c_renk_hdr%isopen) THEN

Line 5891: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

5887: --first log the sqlerrm
5888: l_error_text := substr (SQLERRM, 1, 240);
5889: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5890: --then add it to the message api list
5891: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5892: END IF;
5893: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5894: IF (c_k_hdr%isopen) THEN
5895: CLOSE c_k_hdr;

Line 5893: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

5889: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5890: --then add it to the message api list
5891: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5892: END IF;
5893: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5894: IF (c_k_hdr%isopen) THEN
5895: CLOSE c_k_hdr;
5896: END IF;
5897: IF (c_renk_hdr%isopen) THEN