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.DPP_TRANSACTION_PVT dependencies on FND_PROFILE

Line 44: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

40: )
41: AS
42:
43: l_api_name constant VARCHAR2(30) := 'Update_InterfaceErrSts';
44: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
45: BEGIN
46: -- Initialize API return status to sucess
47: x_return_status := fnd_api.g_ret_sts_success;
48: IF DPP_DEBUG_HIGH_ON THEN

Line 111: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;

107: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_NULL';
108: RAISE Fnd_Api.G_EXC_ERROR;
109: END IF;
110:
111: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
112:
113: mo_global.set_org_access( null,l_value,'M');
114:
115:

Line 883: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

879: ,x_return_status OUT nocopy VARCHAR2)
880: AS
881: l_api_name constant VARCHAR2(30) := 'Create_Header';
882: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
883: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
884: l_transaction_number VARCHAR2(55);
885: l_error_message VARCHAR2(4000) := NULL;
886: BEGIN
887: IF DPP_DEBUG_HIGH_ON THEN

Line 1725: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

1721: AS
1722: l_api_name constant VARCHAR2(30) := 'Create_lines';
1723: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1724: l_transaction_line_id NUMBER;
1725: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
1726: l_error_message VARCHAR2(4000);
1727: l_rounding NUMBER;
1728: BEGIN
1729: -- Initialize API return status to sucess

Line 1736: SELECT fnd_profile.VALUE('DPP_NEW_PRICE_DECIMAL_PRECISION')

1732: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Create Lines');
1733: END IF;
1734:
1735:
1736: SELECT fnd_profile.VALUE('DPP_NEW_PRICE_DECIMAL_PRECISION')
1737: INTO l_rounding
1738: FROM dual;
1739:
1740: IF l_rounding IS NULL THEN

Line 1939: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

1935: --Declaration for Covered Inventory Calculation
1936: l_header_rec_type dpp_coveredinventory_pvt.dpp_inv_hdr_rec_type;
1937: l_line_tbl_type dpp_coveredinventory_pvt.dpp_inv_cov_tbl_type;
1938: l_inv_cov_wh_tbl_type dpp_coveredinventory_pvt.dpp_inv_cov_wh_tbl_type;
1939: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
1940:
1941: l_price_change_flag VARCHAR2(20);
1942:
1943: BEGIN

Line 2147: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2143: AS
2144: l_api_name constant VARCHAR2(30) := 'Update_Approval';
2145: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2146: l_approved_by VARCHAR2(55);
2147: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2148: l_claim_id VARCHAR2(240);
2149: l_error_message VARCHAR2(4000) := NULL;
2150: BEGIN
2151: -- Initialize API return status to sucess

Line 2282: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2278: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2279: l_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
2280: l_commit VARCHAR2(30) := FND_API.G_FALSE;
2281: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2282: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2283: l_count_lines NUMBER;
2284: l_count_approved_lines NUMBER;
2285: l_claim_txn_hdr_rec_type dpp_businessevents_pvt.dpp_txn_hdr_rec_type;
2286: l_claim_txn_line_tbl_type dpp_businessevents_pvt.dpp_txn_line_tbl_type;

Line 2411: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2407: ,x_return_status OUT nocopy VARCHAR2)
2408: AS
2409: l_api_name constant VARCHAR2(30) := 'form_line_tbl';
2410: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2411: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2412: l_txn_lines_rec_type txn_lines_rec;
2413:
2414: l_line_number NUMBER;
2415: l_duplicate_lines NUMBER;

Line 2551: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2547: l_return_status VARCHAR2(30);
2548: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
2549: l_commit VARCHAR2(30) := FND_API.G_FALSE;
2550: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2551: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2552:
2553: l_txn_hdr_hist_rec dpp_log_pvt.dpp_cst_hdr_rec_type;
2554: l_txn_hdr_rec dpp_log_pvt.dpp_cst_hdr_rec_type;
2555: BEGIN

Line 2797: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2793: , x_return_status OUT nocopy VARCHAR2)
2794: AS
2795: l_date DATE;
2796: l_api_name constant VARCHAR2(30) := 'Update_InterfaceTbl';
2797: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2798: BEGIN
2799: -- Initialize API return status to sucess
2800: x_return_status := fnd_api.g_ret_sts_success;
2801:

Line 2864: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2860: )
2861: AS
2862:
2863: l_api_name constant VARCHAR2(30) := 'Update_InterfaceErrSts';
2864: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2865: BEGIN
2866: -- Initialize API return status to sucess
2867: x_return_status := fnd_api.g_ret_sts_success;
2868: IF DPP_DEBUG_HIGH_ON THEN

Line 2944: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

2940: l_api_version constant NUMBER := 1.0;
2941: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2942:
2943: l_return_status VARCHAR2(30);
2944: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2945: l_transaction_status VARCHAR2(55);
2946: l_status_cancelled VARCHAR2(55);
2947: l_transaction_type VARCHAR2(100);
2948: l_log_enabled VARCHAR2(20);

Line 2993: SELECT fnd_profile.VALUE('DPP_AUDIT_ENABLED')

2989: IF DPP_DEBUG_HIGH_ON THEN
2990: fnd_file.put_line(fnd_file.log, 'Begin Insert Transaction ' );
2991: END IF;
2992:
2993: SELECT fnd_profile.VALUE('DPP_AUDIT_ENABLED')
2994: INTO l_log_enabled
2995: FROM dual;
2996:
2997: IF DPP_DEBUG_HIGH_ON THEN

Line 3985: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

3981: AS
3982: l_api_name constant VARCHAR2(20) := 'Create_IntLines';
3983: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
3984:
3985: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
3986: create_IntLines_exception EXCEPTION;
3987: l_error_message VARCHAR2(4000);
3988: x_msg_data VARCHAR2(4000);
3989:

Line 4492: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

4488: l_return_status VARCHAR2(30);
4489: l_msg_count NUMBER;
4490: l_msg_data VARCHAR2(2000);
4491: l_user_name VARCHAR2(30);
4492: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
4493: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
4494: l_commit VARCHAR2(30) := fnd_api.g_false;
4495: l_validation_level NUMBER := fnd_api.g_valid_level_full;
4496: l_transaction_int_header_id NUMBER;

Line 5014: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

5010:
5011: l_return_status VARCHAR2(30);
5012: l_msg_count NUMBER;
5013: l_msg_data VARCHAR2(4000);
5014: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
5015:
5016: l_request_id NUMBER :=FND_GLOBAL.conc_request_id;
5017: l_program_id NUMBER :=FND_GLOBAL.conc_program_id;
5018: l_prog_app_id NUMBER :=FND_GLOBAL.prog_appl_id;

Line 5081: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;

5077: ||'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
5078: --BUG 6806974
5079:
5080:
5081: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
5082:
5083: mo_global.set_org_access( null,l_value,'M');
5084:
5085: