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

Line 1518: fnd_msg_pub.initialize;

1514:
1515: -- Initialize message list if p_init_msg_list is set to TRUE.
1516: IF fnd_api.to_boolean(p_init_msg_list)
1517: THEN
1518: fnd_msg_pub.initialize;
1519: END IF;
1520:
1521: -- Initialize API return status to success
1522: x_return_status := fnd_api.g_ret_sts_success;

Line 1602: fnd_msg_pub.add;

1598:
1599: IF err_num = -54
1600: THEN
1601: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
1602: fnd_msg_pub.add;
1603: RAISE fnd_api.g_exc_error;
1604: ELSE
1605: RAISE;
1606: END IF;

Line 1617: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

1613: CLOSE get_worksheet;
1614:
1615: IF l_found = 1
1616: THEN
1617: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1618: THEN
1619: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
1620: fnd_msg_pub.add;
1621: END IF;

Line 1620: fnd_msg_pub.add;

1616: THEN
1617: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1618: THEN
1619: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
1620: fnd_msg_pub.add;
1621: END IF;
1622:
1623: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
1624: RAISE fnd_api.g_exc_error;

Line 1729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

1725: AND org_id = p_worksheet_rec.org_id;
1726:
1727: IF l_calc_status NOT IN ('CALCULATED', 'CLEAN', 'ROLLED_UP')
1728: THEN
1729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1730: THEN
1731: fnd_message.set_name('CN', 'CN_CALC_NOT_COMPLETE');
1732: fnd_msg_pub.add;
1733: END IF;

Line 1732: fnd_msg_pub.add;

1728: THEN
1729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1730: THEN
1731: fnd_message.set_name('CN', 'CN_CALC_NOT_COMPLETE');
1732: fnd_msg_pub.add;
1733: END IF;
1734:
1735: x_loading_status := 'CN_CALC_NOT_COMPLETE';
1736: RAISE fnd_api.g_exc_error;

Line 1739: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

1735: x_loading_status := 'CN_CALC_NOT_COMPLETE';
1736: RAISE fnd_api.g_exc_error;
1737: END IF;
1738:
1739: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1740: THEN
1741: fnd_message.set_name('CN', 'CN_WKSHT_SRP_COMM_MISMATCH');
1742: fnd_msg_pub.add;
1743: END IF;

Line 1742: fnd_msg_pub.add;

1738:
1739: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1740: THEN
1741: fnd_message.set_name('CN', 'CN_WKSHT_SRP_COMM_MISMATCH');
1742: fnd_msg_pub.add;
1743: END IF;
1744:
1745: x_loading_status := 'CN_WKSHT_SRP_COMM_MISMATCH';
1746: RAISE fnd_api.g_exc_error;

Line 1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

1866:
1867: IF l_tmp <> 0
1868: THEN
1869: --Error condition
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1871: THEN
1872: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
1873: fnd_msg_pub.add;
1874: END IF;

Line 1873: fnd_msg_pub.add;

1869: --Error condition
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1871: THEN
1872: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
1873: fnd_msg_pub.add;
1874: END IF;
1875:
1876: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
1877: RAISE fnd_api.g_exc_error;

Line 2042: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2038:
2039: --
2040: -- Standard call to get message count and if count is 1, get message info.
2041: --
2042: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2043: EXCEPTION
2044: WHEN fnd_api.g_exc_error THEN
2045: ROLLBACK TO create_worksheet;
2046: x_return_status := fnd_api.g_ret_sts_error;

Line 2047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2043: EXCEPTION
2044: WHEN fnd_api.g_exc_error THEN
2045: ROLLBACK TO create_worksheet;
2046: x_return_status := fnd_api.g_ret_sts_error;
2047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2048: WHEN fnd_api.g_exc_unexpected_error THEN
2049: ROLLBACK TO create_worksheet;
2050: x_loading_status := 'UNEXPECTED_ERR';
2051: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2048: WHEN fnd_api.g_exc_unexpected_error THEN
2049: ROLLBACK TO create_worksheet;
2050: x_loading_status := 'UNEXPECTED_ERR';
2051: x_return_status := fnd_api.g_ret_sts_unexp_error;
2052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2053: WHEN OTHERS THEN
2054: ROLLBACK TO create_worksheet;
2055: x_loading_status := 'UNEXPECTED_ERR';
2056: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2058: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

2054: ROLLBACK TO create_worksheet;
2055: x_loading_status := 'UNEXPECTED_ERR';
2056: x_return_status := fnd_api.g_ret_sts_unexp_error;
2057:
2058: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2059: THEN
2060: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2061: END IF;
2062:

Line 2060: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2056: x_return_status := fnd_api.g_ret_sts_unexp_error;
2057:
2058: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2059: THEN
2060: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2061: END IF;
2062:
2063: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2064: END create_worksheet;

Line 2063: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2059: THEN
2060: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2061: END IF;
2062:
2063: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2064: END create_worksheet;
2065:
2066: -- ===========================================================================
2067: -- Procedure : Create_Multiple_Worksheets

Line 2144: fnd_file.put_line(fnd_file.log, 'msg: ' || fnd_msg_pub.get(i, 'F'));

2140: cn_message_pkg.debug('Error when creating Worksheet for : ' || l_worksheet_rec.salesrep_id);
2141: fnd_file.put_line(fnd_file.log, 'Failed to create worksheet for ' || l_worksheet_rec.salesrep_id);
2142: FOR i IN 1 .. x_msg_count
2143: LOOP
2144: fnd_file.put_line(fnd_file.log, 'msg: ' || fnd_msg_pub.get(i, 'F'));
2145: END LOOP;
2146: fnd_file.put_line(fnd_file.log, '+------------------------------+');
2147: ROLLBACK;
2148: ELSE

Line 2318: fnd_msg_pub.add;

2314: IF l_return_status <> fnd_api.g_ret_sts_success
2315: THEN
2316: retcode := 2;
2317: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2318: fnd_msg_pub.add;
2319: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2320: END IF;
2321:
2322: cn_message_pkg.end_batch(l_proc_audit_id);

Line 2319: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

2315: THEN
2316: retcode := 2;
2317: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2318: fnd_msg_pub.add;
2319: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2320: END IF;
2321:
2322: cn_message_pkg.end_batch(l_proc_audit_id);
2323: COMMIT;

Line 2414: fnd_msg_pub.initialize;

2410: -- Initialize message list if p_init_msg_list is set to TRUE.
2411: --
2412: IF fnd_api.to_boolean(p_init_msg_list)
2413: THEN
2414: fnd_msg_pub.initialize;
2415: END IF;
2416:
2417: --
2418: -- Initialize API return status to success

Line 2433: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error))

2429:
2430: --This part is added for OA.
2431: IF wksht_rec.ovn <> x_ovn
2432: THEN
2433: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error))
2434: THEN
2435: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2436: fnd_msg_pub.add;
2437: END IF;

Line 2436: fnd_msg_pub.add;

2432: THEN
2433: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error))
2434: THEN
2435: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2436: fnd_msg_pub.add;
2437: END IF;
2438:
2439: RAISE fnd_api.g_exc_error;
2440: END IF;

Line 3472: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3468: COMMIT WORK;
3469: END IF;
3470:
3471: -- Standard call to get message count and if count is 1, get message info.
3472: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3473: EXCEPTION
3474: WHEN fnd_api.g_exc_error THEN
3475: ROLLBACK TO update_worksheet;
3476: x_return_status := fnd_api.g_ret_sts_error;

Line 3477: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3473: EXCEPTION
3474: WHEN fnd_api.g_exc_error THEN
3475: ROLLBACK TO update_worksheet;
3476: x_return_status := fnd_api.g_ret_sts_error;
3477: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479: ROLLBACK TO update_worksheet;
3480: x_loading_status := 'UNEXPECTED_ERR';
3481: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3482: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479: ROLLBACK TO update_worksheet;
3480: x_loading_status := 'UNEXPECTED_ERR';
3481: x_return_status := fnd_api.g_ret_sts_unexp_error;
3482: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3483: WHEN OTHERS THEN
3484: ROLLBACK TO update_worksheet;
3485: x_loading_status := 'UNEXPECTED_ERR';
3486: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

3484: ROLLBACK TO update_worksheet;
3485: x_loading_status := 'UNEXPECTED_ERR';
3486: x_return_status := fnd_api.g_ret_sts_unexp_error;
3487:
3488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3489: THEN
3490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3491: END IF;
3492:

Line 3490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3486: x_return_status := fnd_api.g_ret_sts_unexp_error;
3487:
3488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3489: THEN
3490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3491: END IF;
3492:
3493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3494: END update_worksheet;

Line 3493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3489: THEN
3490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3491: END IF;
3492:
3493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3494: END update_worksheet;
3495:
3496: -- ===========================================================================
3497: -- Procedure : delete_worksheet

Line 3551: fnd_msg_pub.initialize;

3547: -- Initialize message list if p_init_msg_list is set to TRUE.
3548: --
3549: IF fnd_api.to_boolean(p_init_msg_list)
3550: THEN
3551: fnd_msg_pub.initialize;
3552: END IF;
3553:
3554: --
3555: -- Initialize API return status to success

Line 3665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3661:
3662: --
3663: -- Standard call to get message count and if count is 1, get message info.
3664: --
3665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3666: EXCEPTION
3667: WHEN fnd_api.g_exc_error THEN
3668: ROLLBACK TO delete_worksheet;
3669: x_return_status := fnd_api.g_ret_sts_error;

Line 3670: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3666: EXCEPTION
3667: WHEN fnd_api.g_exc_error THEN
3668: ROLLBACK TO delete_worksheet;
3669: x_return_status := fnd_api.g_ret_sts_error;
3670: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3671: WHEN fnd_api.g_exc_unexpected_error THEN
3672: ROLLBACK TO delete_worksheet;
3673: x_loading_status := 'UNEXPECTED_ERR';
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3671: WHEN fnd_api.g_exc_unexpected_error THEN
3672: ROLLBACK TO delete_worksheet;
3673: x_loading_status := 'UNEXPECTED_ERR';
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3676: WHEN OTHERS THEN
3677: ROLLBACK TO delete_worksheet;
3678: x_loading_status := 'UNEXPECTED_ERR';
3679: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

3677: ROLLBACK TO delete_worksheet;
3678: x_loading_status := 'UNEXPECTED_ERR';
3679: x_return_status := fnd_api.g_ret_sts_unexp_error;
3680:
3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3682: THEN
3683: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3684: END IF;
3685:

Line 3683: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3679: x_return_status := fnd_api.g_ret_sts_unexp_error;
3680:
3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3682: THEN
3683: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3684: END IF;
3685:
3686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3687: END delete_worksheet;

Line 3686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3682: THEN
3683: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3684: END IF;
3685:
3686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3687: END delete_worksheet;
3688:
3689:
3690: PROCEDURE get_ced_and_bb

Line 3739: fnd_msg_pub.initialize;

3735:
3736: -- Initialize message list if p_init_msg_list is set to TRUE.
3737: IF fnd_api.to_boolean(p_init_msg_list)
3738: THEN
3739: fnd_msg_pub.initialize;
3740: END IF;
3741:
3742: -- Initialize API return status to success
3743: x_return_status := fnd_api.g_ret_sts_success;

Line 3759: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

3755: INTO l_wksht_rec;
3756:
3757: IF c_wksht_csr%ROWCOUNT = 0
3758: THEN
3759: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
3760: THEN
3761: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3762: fnd_msg_pub.add;
3763: END IF;

Line 3762: fnd_msg_pub.add;

3758: THEN
3759: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
3760: THEN
3761: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3762: fnd_msg_pub.add;
3763: END IF;
3764:
3765: RAISE fnd_api.g_exc_error;
3766: END IF;

Line 3855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3851: END IF;
3852:
3853: --
3854: -- Standard call to get message count and if count is 1, get message info.
3855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3856: EXCEPTION
3857: WHEN fnd_api.g_exc_error THEN
3858: ROLLBACK TO get_ced_and_bb;
3859: x_return_status := fnd_api.g_ret_sts_error;

Line 3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3856: EXCEPTION
3857: WHEN fnd_api.g_exc_error THEN
3858: ROLLBACK TO get_ced_and_bb;
3859: x_return_status := fnd_api.g_ret_sts_error;
3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO get_ced_and_bb;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO get_ced_and_bb;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3865: WHEN OTHERS THEN
3866: ROLLBACK TO get_ced_and_bb;
3867: x_return_status := fnd_api.g_ret_sts_unexp_error;
3868:

Line 3869: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

3865: WHEN OTHERS THEN
3866: ROLLBACK TO get_ced_and_bb;
3867: x_return_status := fnd_api.g_ret_sts_unexp_error;
3868:
3869: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3870: THEN
3871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3872: END IF;
3873:

Line 3871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3867: x_return_status := fnd_api.g_ret_sts_unexp_error;
3868:
3869: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3870: THEN
3871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3872: END IF;
3873:
3874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3875: END get_ced_and_bb;

Line 3874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3870: THEN
3871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3872: END IF;
3873:
3874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3875: END get_ced_and_bb;
3876:
3877: --============================================================================
3878: --Name :set_ced_and_bb

Line 3945: fnd_msg_pub.initialize;

3941:
3942: -- Initialize message list if p_init_msg_list is set to TRUE.
3943: IF fnd_api.to_boolean(p_init_msg_list)
3944: THEN
3945: fnd_msg_pub.initialize;
3946: END IF;
3947:
3948: -- Initialize API return status to success
3949: x_return_status := fnd_api.g_ret_sts_success;

Line 3960: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

3956: INTO l_status_rec;
3957:
3958: IF c_status_csr%ROWCOUNT = 0
3959: THEN
3960: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
3961: THEN
3962: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3963: fnd_msg_pub.add;
3964: END IF;

Line 3963: fnd_msg_pub.add;

3959: THEN
3960: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
3961: THEN
3962: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3963: fnd_msg_pub.add;
3964: END IF;
3965:
3966: RAISE fnd_api.g_exc_error;
3967: END IF;

Line 4043: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4039: END IF;
4040:
4041: --
4042: -- Standard call to get message count and if count is 1, get message info.
4043: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4044: EXCEPTION
4045: WHEN fnd_api.g_exc_error THEN
4046: ROLLBACK TO set_ced_and_bb;
4047: x_return_status := fnd_api.g_ret_sts_error;

Line 4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4044: EXCEPTION
4045: WHEN fnd_api.g_exc_error THEN
4046: ROLLBACK TO set_ced_and_bb;
4047: x_return_status := fnd_api.g_ret_sts_error;
4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4049: WHEN fnd_api.g_exc_unexpected_error THEN
4050: ROLLBACK TO set_ced_and_bb;
4051: x_return_status := fnd_api.g_ret_sts_unexp_error;
4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4049: WHEN fnd_api.g_exc_unexpected_error THEN
4050: ROLLBACK TO set_ced_and_bb;
4051: x_return_status := fnd_api.g_ret_sts_unexp_error;
4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4053: WHEN OTHERS THEN
4054: ROLLBACK TO set_ced_and_bb;
4055: x_return_status := fnd_api.g_ret_sts_unexp_error;
4056:

Line 4057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

4053: WHEN OTHERS THEN
4054: ROLLBACK TO set_ced_and_bb;
4055: x_return_status := fnd_api.g_ret_sts_unexp_error;
4056:
4057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4058: THEN
4059: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4060: END IF;
4061:

Line 4059: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

4055: x_return_status := fnd_api.g_ret_sts_unexp_error;
4056:
4057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4058: THEN
4059: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4060: END IF;
4061:
4062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4063: END set_ced_and_bb;

Line 4062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4058: THEN
4059: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4060: END IF;
4061:
4062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4063: END set_ced_and_bb;
4064:
4065:
4066:

Line 4475: fnd_file.put_line(fnd_file.log, 'msg: ' || fnd_msg_pub.get(i, 'F'));

4471: fnd_file.put_line(fnd_file.log,'Failed to refresh worksheet for ' || l_worksheet_rec.salesrep_id);
4472:
4473: FOR i IN 1 .. x_msg_count
4474: LOOP
4475: fnd_file.put_line(fnd_file.log, 'msg: ' || fnd_msg_pub.get(i, 'F'));
4476: END LOOP;
4477: fnd_file.put_line(fnd_file.log, '+------------------------------+');
4478: ROLLBACK;
4479: