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 1450: FND_MSG_PUB.add;

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

Line 1464: FND_MSG_PUB.add;

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

Line 1489: FND_MSG_PUB.ADD;

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

Line 1531: FND_MSG_PUB.ADD;

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

Line 1549: FND_MSG_PUB.add;

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

Line 1578: FND_MSG_PUB.add;

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

Line 1598: FND_MSG_PUB.add;

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

Line 1619: FND_MSG_PUB.add;

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

Line 1712: FND_MSG_PUB.add;

1708: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE_DIST');
1709: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1710: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_rev_type_dist', FALSE);
1711: END IF;
1712: FND_MSG_PUB.add;
1713: RAISE FND_API.g_exc_error;
1714: END IF;
1715:
1716: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

1854: --first log the sqlerrm
1855: l_error_text := substr (SQLERRM, 1, 240);
1856: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1857: --then add it to the message api list
1858: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1859: END IF;
1860: IF ( c_res_salesrep%isopen ) THEN
1861: CLOSE c_res_salesrep;
1862: END IF;

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

2021: --first log the sqlerrm
2022: l_error_text := substr (SQLERRM, 1, 240);
2023: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2024: --then add it to the message api list
2025: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2026: END IF;
2027: IF ( c_subscr_service_lines%isopen ) THEN
2028: CLOSE c_subscr_service_lines;
2029: END IF;

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

2190: --first log the sqlerrm
2191: l_error_text := substr (SQLERRM, 1, 240);
2192: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2193: --then add it to the message api list
2194: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2195: END IF;
2196: IF ( c_get_usage_price_locks%isopen ) THEN
2197: CLOSE c_get_usage_price_locks;
2198: END IF;

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

2361: --first log the sqlerrm
2362: l_error_text := substr (SQLERRM, 1, 240);
2363: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2364: --then add it to the message api list
2365: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2366: END IF;
2367: IF (c_hdr_strlvl%isopen) THEN
2368: CLOSE c_hdr_strlvl;
2369: END IF;

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

2574: --first log the sqlerrm
2575: l_error_text := substr (SQLERRM, 1, 240);
2576: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2577: --then add it to the message api list
2578: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2579: END IF;
2580: IF (c_get_top_lines%isopen) THEN
2581: CLOSE c_get_top_lines;
2582: END IF;

Line 2801: FND_MSG_PUB.ADD;

2797: FND_MESSAGE.set_token('INVOICE_RULE_ID', l_invoice_rule_id);
2798: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2799: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_invoice_rule', FALSE);
2800: END IF;
2801: FND_MSG_PUB.ADD;
2802: RAISE FND_API.g_exc_error;
2803: END IF;
2804:
2805: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2820: FND_MSG_PUB.ADD;

2816: FND_MESSAGE.set_token('ACCTG_RULE_ID', l_account_rule_id);
2817: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2818: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_accounting_rule', FALSE);
2819: END IF;
2820: FND_MSG_PUB.ADD;
2821: RAISE FND_API.g_exc_error;
2822: END IF;
2823:
2824: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

2898: --first log the sqlerrm
2899: l_error_text := substr (SQLERRM, 1, 240);
2900: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2901: --then add it to the message api list
2902: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2903: END IF;
2904: IF (c_bp_toplines%isopen) THEN
2905: CLOSE c_bp_toplines;
2906: END IF;

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

3152: --first log the sqlerrm
3153: l_error_text := substr (SQLERRM, 1, 240);
3154: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3155: --then add it to the message api list
3156: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3157: END IF;
3158: IF (c_hdr_dates%isopen) THEN
3159: CLOSE c_hdr_dates;
3160: END IF;

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

3278: --first log the sqlerrm
3279: l_error_text := substr (SQLERRM, 1, 240);
3280: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3281: --then add it to the message api list
3282: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3283: END IF;
3284: IF (c_group_csr%isopen) THEN
3285: CLOSE c_group_csr;
3286: END IF;

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

3442: --first log the sqlerrm
3443: l_error_text := substr (SQLERRM, 1, 240);
3444: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3445: --then add it to the message api list
3446: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3447: END IF;
3448: IF (c_pdf%isopen) THEN
3449: CLOSE c_pdf;
3450: END IF;

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

3881: --first log the sqlerrm
3882: l_error_text := substr (SQLERRM, 1, 240);
3883: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
3884: --then add it to the message api list
3885: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
3886: END IF;
3887: IF (c_k_hdr%isopen) THEN
3888: CLOSE c_k_hdr;
3889: END IF;

Line 4069: FND_MSG_PUB.initialize;

4065: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: END IF;
4068: IF FND_API.to_boolean(p_init_msg_list ) THEN
4069: FND_MSG_PUB.initialize;
4070: END IF;
4071: x_return_status := FND_API.G_RET_STS_SUCCESS;
4072: x_validation_status := G_VALID_STS_SUCCESS;
4073:

Line 4085: FND_MSG_PUB.ADD;

4081: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4082: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4083: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_values', FALSE);
4084: END IF;
4085: FND_MSG_PUB.ADD;
4086: CLOSE c_k_hdr;
4087: RAISE FND_API.g_exc_error;
4088: END IF;
4089: CLOSE c_k_hdr;

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

4381: END LOOP;
4382: END IF;
4383: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_validation_status=' || x_validation_status ||', x_return_status='|| x_return_status);
4384: END IF;
4385: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4386:
4387: EXCEPTION
4388: WHEN FND_API.g_exc_error THEN
4389: x_return_status := FND_API.g_ret_sts_error ;

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

4390:
4391: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4392: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
4393: END IF;
4394: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4395:
4396: IF (c_k_hdr%isopen) THEN
4397: CLOSE c_k_hdr;
4398: END IF;

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

4420:
4421: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4422: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
4423: END IF;
4424: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4425:
4426: IF (c_k_hdr%isopen) THEN
4427: CLOSE c_k_hdr;
4428: END IF;

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

4452: --first log the sqlerrm
4453: l_error_text := substr (SQLERRM, 1, 240);
4454: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4455: --then add it to the message api list
4456: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4457: END IF;
4458: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4459:
4460: IF (c_k_hdr%isopen) THEN

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

4454: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4455: --then add it to the message api list
4456: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4457: END IF;
4458: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4459:
4460: IF (c_k_hdr%isopen) THEN
4461: CLOSE c_k_hdr;
4462: END IF;

Line 4666: FND_MSG_PUB.initialize;

4662: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4664: END IF;
4665: IF FND_API.to_boolean(p_init_msg_list ) THEN
4666: FND_MSG_PUB.initialize;
4667: END IF;
4668: x_return_status := FND_API.G_RET_STS_SUCCESS;
4669:
4670: --we will first get and update the topline invoice text

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

4782: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
4783: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
4784: END IF;
4785: END IF;
4786: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4787:
4788: EXCEPTION
4789: WHEN FND_API.g_exc_error THEN
4790: ROLLBACK TO update_invoice_text_PVT;

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

4792:
4793: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4794: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
4795: END IF;
4796: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4797:
4798: WHEN FND_API.g_exc_unexpected_error THEN
4799: ROLLBACK TO update_invoice_text_PVT;
4800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4801:
4802: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4803: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
4804: END IF;
4805: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4806:
4807: WHEN OTHERS THEN
4808: ROLLBACK TO update_invoice_text_PVT;
4809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4812: --first log the sqlerrm
4813: l_error_text := substr (SQLERRM, 1, 240);
4814: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4815: --then add it to the message api list
4816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4817: END IF;
4818: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4819:
4820: END UPDATE_INVOICE_TEXT;

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

4814: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4815: --then add it to the message api list
4816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4817: END IF;
4818: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4819:
4820: END UPDATE_INVOICE_TEXT;
4821:
4822: /*

Line 4904: FND_MSG_PUB.initialize;

4900: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
4901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4902: END IF;
4903: IF FND_API.to_boolean(p_init_msg_list ) THEN
4904: FND_MSG_PUB.initialize;
4905: END IF;
4906: x_return_status := FND_API.G_RET_STS_SUCCESS;
4907:
4908: --first get the contract org and id for the merchant/vendor record in okc_k_party_roles_b

Line 4919: FND_MSG_PUB.ADD;

4915: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4916: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4917: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
4918: END IF;
4919: FND_MSG_PUB.ADD;
4920: RAISE FND_API.g_exc_error;
4921: END IF;
4922:
4923: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 4989: FND_MSG_PUB.ADD;

4985: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_HELPDESK');
4986: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4987: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_helpdesk_user', FALSE);
4988: END IF;
4989: FND_MSG_PUB.ADD;
4990: RAISE FND_API.g_exc_error;
4991: END IF;
4992: */
4993:

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

5005:
5006: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
5007: 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);
5008: END IF;
5009: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5010:
5011: EXCEPTION
5012: WHEN FND_API.g_exc_error THEN
5013: x_return_status := FND_API.g_ret_sts_error ;

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

5023: END IF;
5024: IF (c_fnd_user%isopen) THEN
5025: CLOSE c_fnd_user;
5026: END IF;
5027: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5028:
5029: WHEN FND_API.g_exc_unexpected_error THEN
5030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5031:

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

5040: END IF;
5041: IF (c_fnd_user%isopen) THEN
5042: CLOSE c_fnd_user;
5043: END IF;
5044: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5045:
5046: WHEN OTHERS THEN
5047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5048:

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

5050: --first log the sqlerrm
5051: l_error_text := substr (SQLERRM, 1, 240);
5052: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5053: --then add it to the message api list
5054: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5055: END IF;
5056: IF (c_k_hdr%isopen) THEN
5057: CLOSE c_k_hdr;
5058: END IF;

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

5061: END IF;
5062: IF (c_fnd_user%isopen) THEN
5063: CLOSE c_fnd_user;
5064: END IF;
5065: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5066:
5067: END GET_USER_NAME;
5068:
5069:

Line 5202: FND_MSG_PUB.initialize;

5198: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
5199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5200: END IF;
5201: IF FND_API.to_boolean(p_init_msg_list ) THEN
5202: FND_MSG_PUB.initialize;
5203: END IF;
5204: x_return_status := FND_API.G_RET_STS_SUCCESS;
5205:
5206: /*

Line 5230: FND_MSG_PUB.ADD;

5226: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
5227: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5228: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation1', FALSE);
5229: END IF;
5230: FND_MSG_PUB.ADD;
5231: CLOSE c_k_hdr;
5232: RAISE FND_API.g_exc_error;
5233: END IF;
5234: CLOSE c_k_hdr;

Line 5242: FND_MSG_PUB.ADD;

5238: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_END');
5239: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5240: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation2', FALSE);
5241: END IF;
5242: FND_MSG_PUB.ADD;
5243: RAISE FND_API.g_exc_error;
5244: END IF;
5245:
5246: --new end date < new start date, if new start date is null use old end date + 1

Line 5254: FND_MSG_PUB.ADD;

5250: FND_MESSAGE.set_token('END_DATE', to_char(p_new_end_date));
5251: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5252: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation3', FALSE);
5253: END IF;
5254: FND_MSG_PUB.ADD;
5255: RAISE FND_API.g_exc_error;
5256: END IF;
5257: --end basic parameter validation
5258:

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

5309: IF ( (l_validation_status = G_VALID_STS_ERROR) OR
5310: ( (l_validation_status = G_VALID_STS_WARNING) AND
5311: (p_renewal_called_from_ui = 'N') )
5312: ) THEN
5313: --add all validation messages to the FND_MSG_PUB stack
5314: FOR i in l_validation_tbl.FIRST..l_validation_tbl.LAST LOOP
5315: --OKS_USER_DEFINED_MESSAGE is a special message, with the message body = MESSAGE
5316: --This is a workaround, because we can't directly add messages to the msg API list
5317: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)

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

5313: --add all validation messages to the FND_MSG_PUB stack
5314: FOR i in l_validation_tbl.FIRST..l_validation_tbl.LAST LOOP
5315: --OKS_USER_DEFINED_MESSAGE is a special message, with the message body = MESSAGE
5316: --This is a workaround, because we can't directly add messages to the msg API list
5317: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)
5318: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');
5319: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);
5320: FND_MSG_PUB.add;
5321: END LOOP;

Line 5320: FND_MSG_PUB.add;

5316: --This is a workaround, because we can't directly add messages to the msg API list
5317: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)
5318: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');
5319: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);
5320: FND_MSG_PUB.add;
5321: END LOOP;
5322: RAISE FND_API.g_exc_error;
5323: END IF;
5324: --end renewal validation

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

5880: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
5881: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_chr_id=' || x_chr_id ||', x_return_status='|| x_return_status);
5882: END IF;
5883: END IF;
5884: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5885:
5886: EXCEPTION
5887: WHEN FND_API.g_exc_error THEN
5888: ROLLBACK TO renew_contract_PVT;

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

5890:
5891: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5892: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
5893: END IF;
5894: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5895: IF (c_k_hdr%isopen) THEN
5896: CLOSE c_k_hdr;
5897: END IF;
5898: IF (c_renk_hdr%isopen) THEN

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

5905:
5906: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
5907: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
5908: END IF;
5909: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5910: IF (c_k_hdr%isopen) THEN
5911: CLOSE c_k_hdr;
5912: END IF;
5913: IF (c_renk_hdr%isopen) THEN

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

5922: --first log the sqlerrm
5923: l_error_text := substr (SQLERRM, 1, 240);
5924: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5925: --then add it to the message api list
5926: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5927: END IF;
5928: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5929: IF (c_k_hdr%isopen) THEN
5930: CLOSE c_k_hdr;

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

5924: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
5925: --then add it to the message api list
5926: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
5927: END IF;
5928: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5929: IF (c_k_hdr%isopen) THEN
5930: CLOSE c_k_hdr;
5931: END IF;
5932: IF (c_renk_hdr%isopen) THEN