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 1520: fnd_msg_pub.initialize;

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

Line 1604: fnd_msg_pub.add;

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

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

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

Line 1622: fnd_msg_pub.add;

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

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

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

Line 1734: fnd_msg_pub.add;

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

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

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

Line 1744: fnd_msg_pub.add;

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

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

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

Line 1875: fnd_msg_pub.add;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2364: fnd_msg_pub.add;

2360: IF l_return_status <> fnd_api.g_ret_sts_success
2361: THEN
2362: retcode := 2;
2363: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2364: fnd_msg_pub.add;
2365: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2366: END IF;
2367:
2368: cn_message_pkg.end_batch(l_proc_audit_id);

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

2361: THEN
2362: retcode := 2;
2363: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2364: fnd_msg_pub.add;
2365: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2366: END IF;
2367:
2368: cn_message_pkg.end_batch(l_proc_audit_id);
2369: COMMIT;

Line 2460: fnd_msg_pub.initialize;

2456: -- Initialize message list if p_init_msg_list is set to TRUE.
2457: --
2458: IF fnd_api.to_boolean(p_init_msg_list)
2459: THEN
2460: fnd_msg_pub.initialize;
2461: END IF;
2462:
2463: --
2464: -- Initialize API return status to success

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

2475:
2476: --This part is added for OA.
2477: IF wksht_rec.ovn <> x_ovn
2478: THEN
2479: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error))
2480: THEN
2481: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2482: fnd_msg_pub.add;
2483: END IF;

Line 2482: fnd_msg_pub.add;

2478: THEN
2479: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error))
2480: THEN
2481: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2482: fnd_msg_pub.add;
2483: END IF;
2484:
2485: RAISE fnd_api.g_exc_error;
2486: END IF;

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

3514: COMMIT WORK;
3515: END IF;
3516:
3517: -- Standard call to get message count and if count is 1, get message info.
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3519: EXCEPTION
3520: WHEN fnd_api.g_exc_error THEN
3521: ROLLBACK TO update_worksheet;
3522: x_return_status := fnd_api.g_ret_sts_error;

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

3519: EXCEPTION
3520: WHEN fnd_api.g_exc_error THEN
3521: ROLLBACK TO update_worksheet;
3522: x_return_status := fnd_api.g_ret_sts_error;
3523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3524: WHEN fnd_api.g_exc_unexpected_error THEN
3525: ROLLBACK TO update_worksheet;
3526: x_loading_status := 'UNEXPECTED_ERR';
3527: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3524: WHEN fnd_api.g_exc_unexpected_error THEN
3525: ROLLBACK TO update_worksheet;
3526: x_loading_status := 'UNEXPECTED_ERR';
3527: x_return_status := fnd_api.g_ret_sts_unexp_error;
3528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3529: WHEN OTHERS THEN
3530: ROLLBACK TO update_worksheet;
3531: x_loading_status := 'UNEXPECTED_ERR';
3532: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3530: ROLLBACK TO update_worksheet;
3531: x_loading_status := 'UNEXPECTED_ERR';
3532: x_return_status := fnd_api.g_ret_sts_unexp_error;
3533:
3534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3535: THEN
3536: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3537: END IF;
3538:

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

3532: x_return_status := fnd_api.g_ret_sts_unexp_error;
3533:
3534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3535: THEN
3536: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3537: END IF;
3538:
3539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3540: END update_worksheet;

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

3535: THEN
3536: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3537: END IF;
3538:
3539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3540: END update_worksheet;
3541:
3542: -- ===========================================================================
3543: -- Procedure : delete_worksheet

Line 3597: fnd_msg_pub.initialize;

3593: -- Initialize message list if p_init_msg_list is set to TRUE.
3594: --
3595: IF fnd_api.to_boolean(p_init_msg_list)
3596: THEN
3597: fnd_msg_pub.initialize;
3598: END IF;
3599:
3600: --
3601: -- Initialize API return status to success

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

3707:
3708: --
3709: -- Standard call to get message count and if count is 1, get message info.
3710: --
3711: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3712: EXCEPTION
3713: WHEN fnd_api.g_exc_error THEN
3714: ROLLBACK TO delete_worksheet;
3715: x_return_status := fnd_api.g_ret_sts_error;

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

3712: EXCEPTION
3713: WHEN fnd_api.g_exc_error THEN
3714: ROLLBACK TO delete_worksheet;
3715: x_return_status := fnd_api.g_ret_sts_error;
3716: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3717: WHEN fnd_api.g_exc_unexpected_error THEN
3718: ROLLBACK TO delete_worksheet;
3719: x_loading_status := 'UNEXPECTED_ERR';
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3717: WHEN fnd_api.g_exc_unexpected_error THEN
3718: ROLLBACK TO delete_worksheet;
3719: x_loading_status := 'UNEXPECTED_ERR';
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;
3721: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3722: WHEN OTHERS THEN
3723: ROLLBACK TO delete_worksheet;
3724: x_loading_status := 'UNEXPECTED_ERR';
3725: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3723: ROLLBACK TO delete_worksheet;
3724: x_loading_status := 'UNEXPECTED_ERR';
3725: x_return_status := fnd_api.g_ret_sts_unexp_error;
3726:
3727: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3728: THEN
3729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3730: END IF;
3731:

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

3725: x_return_status := fnd_api.g_ret_sts_unexp_error;
3726:
3727: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3728: THEN
3729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3730: END IF;
3731:
3732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3733: END delete_worksheet;

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

3728: THEN
3729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3730: END IF;
3731:
3732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3733: END delete_worksheet;
3734:
3735:
3736: PROCEDURE get_ced_and_bb

Line 3785: fnd_msg_pub.initialize;

3781:
3782: -- Initialize message list if p_init_msg_list is set to TRUE.
3783: IF fnd_api.to_boolean(p_init_msg_list)
3784: THEN
3785: fnd_msg_pub.initialize;
3786: END IF;
3787:
3788: -- Initialize API return status to success
3789: x_return_status := fnd_api.g_ret_sts_success;

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

3801: INTO l_wksht_rec;
3802:
3803: IF c_wksht_csr%ROWCOUNT = 0
3804: THEN
3805: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
3806: THEN
3807: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3808: fnd_msg_pub.add;
3809: END IF;

Line 3808: fnd_msg_pub.add;

3804: THEN
3805: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
3806: THEN
3807: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3808: fnd_msg_pub.add;
3809: END IF;
3810:
3811: RAISE fnd_api.g_exc_error;
3812: END IF;

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

3897: END IF;
3898:
3899: --
3900: -- Standard call to get message count and if count is 1, get message info.
3901: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3902: EXCEPTION
3903: WHEN fnd_api.g_exc_error THEN
3904: ROLLBACK TO get_ced_and_bb;
3905: x_return_status := fnd_api.g_ret_sts_error;

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

3902: EXCEPTION
3903: WHEN fnd_api.g_exc_error THEN
3904: ROLLBACK TO get_ced_and_bb;
3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN
3908: ROLLBACK TO get_ced_and_bb;
3909: x_return_status := fnd_api.g_ret_sts_unexp_error;
3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN
3908: ROLLBACK TO get_ced_and_bb;
3909: x_return_status := fnd_api.g_ret_sts_unexp_error;
3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3911: WHEN OTHERS THEN
3912: ROLLBACK TO get_ced_and_bb;
3913: x_return_status := fnd_api.g_ret_sts_unexp_error;
3914:

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

3911: WHEN OTHERS THEN
3912: ROLLBACK TO get_ced_and_bb;
3913: x_return_status := fnd_api.g_ret_sts_unexp_error;
3914:
3915: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3916: THEN
3917: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3918: END IF;
3919:

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

3913: x_return_status := fnd_api.g_ret_sts_unexp_error;
3914:
3915: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3916: THEN
3917: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3918: END IF;
3919:
3920: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3921: END get_ced_and_bb;

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

3916: THEN
3917: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3918: END IF;
3919:
3920: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3921: END get_ced_and_bb;
3922:
3923: --============================================================================
3924: --Name :set_ced_and_bb

Line 3991: fnd_msg_pub.initialize;

3987:
3988: -- Initialize message list if p_init_msg_list is set to TRUE.
3989: IF fnd_api.to_boolean(p_init_msg_list)
3990: THEN
3991: fnd_msg_pub.initialize;
3992: END IF;
3993:
3994: -- Initialize API return status to success
3995: x_return_status := fnd_api.g_ret_sts_success;

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

4002: INTO l_status_rec;
4003:
4004: IF c_status_csr%ROWCOUNT = 0
4005: THEN
4006: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
4007: THEN
4008: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
4009: fnd_msg_pub.add;
4010: END IF;

Line 4009: fnd_msg_pub.add;

4005: THEN
4006: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
4007: THEN
4008: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
4009: fnd_msg_pub.add;
4010: END IF;
4011:
4012: RAISE fnd_api.g_exc_error;
4013: END IF;

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

4085: END IF;
4086:
4087: --
4088: -- Standard call to get message count and if count is 1, get message info.
4089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4090: EXCEPTION
4091: WHEN fnd_api.g_exc_error THEN
4092: ROLLBACK TO set_ced_and_bb;
4093: x_return_status := fnd_api.g_ret_sts_error;

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

4090: EXCEPTION
4091: WHEN fnd_api.g_exc_error THEN
4092: ROLLBACK TO set_ced_and_bb;
4093: x_return_status := fnd_api.g_ret_sts_error;
4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN
4096: ROLLBACK TO set_ced_and_bb;
4097: x_return_status := fnd_api.g_ret_sts_unexp_error;
4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN
4096: ROLLBACK TO set_ced_and_bb;
4097: x_return_status := fnd_api.g_ret_sts_unexp_error;
4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4099: WHEN OTHERS THEN
4100: ROLLBACK TO set_ced_and_bb;
4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:

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

4099: WHEN OTHERS THEN
4100: ROLLBACK TO set_ced_and_bb;
4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:
4103: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4104: THEN
4105: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4106: END IF;
4107:

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

4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:
4103: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4104: THEN
4105: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4106: END IF;
4107:
4108: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4109: END set_ced_and_bb;

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

4104: THEN
4105: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4106: END IF;
4107:
4108: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4109: END set_ced_and_bb;
4110:
4111:
4112:

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

4538: fnd_file.put_line(fnd_file.log,'Failed to refresh worksheet for ' || l_worksheet_rec.salesrep_id);
4539:
4540: FOR i IN 1 .. x_msg_count
4541: LOOP
4542: fnd_file.put_line(fnd_file.log, 'msg: ' || fnd_msg_pub.get(i, 'F'));
4543: END LOOP;
4544: fnd_file.put_line(fnd_file.log, '+------------------------------+');
4545: ROLLBACK;
4546: