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 39: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');

35: )
36: AS
37:
38: l_api_name constant VARCHAR2(30) := 'Update_InterfaceErrSts';
39: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
40: BEGIN
41: -- Initialize API return status to sucess
42: x_return_status := fnd_api.g_ret_sts_success;
43: IF DPP_DEBUG_HIGH_ON THEN

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

102: p_txn_header_rec_type.error_code := 'DPP_TXN_OPERATING_UNIT_NULL';
103: RAISE Fnd_Api.G_EXC_ERROR;
104: END IF;
105:
106: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
107:
108: mo_global.set_org_access( null,l_value,'M');
109:
110:

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

696: ,x_return_status OUT nocopy VARCHAR2)
697: AS
698: l_api_name constant VARCHAR2(30) := 'Create_Header';
699: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
700: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
701: l_transaction_number VARCHAR2(55);
702: l_error_message VARCHAR2(4000) := NULL;
703: BEGIN
704: IF DPP_DEBUG_HIGH_ON THEN

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

1516: AS
1517: l_api_name constant VARCHAR2(30) := 'Create_lines';
1518: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1519: l_transaction_line_id NUMBER;
1520: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
1521: l_error_message VARCHAR2(4000);
1522: l_rounding NUMBER;
1523: BEGIN
1524: -- Initialize API return status to sucess

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

1527: FND_FILE.PUT_LINE(FND_FILE.LOG,' Begin Create Lines');
1528: END IF;
1529:
1530:
1531: SELECT fnd_profile.VALUE('DPP_NEW_PRICE_DECIMAL_PRECISION')
1532: INTO l_rounding
1533: FROM dual;
1534:
1535: IF l_rounding IS NULL THEN

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

1730: --Declaration for Covered Inventory Calculation
1731: l_header_rec_type dpp_coveredinventory_pvt.dpp_inv_hdr_rec_type;
1732: l_line_tbl_type dpp_coveredinventory_pvt.dpp_inv_cov_tbl_type;
1733: l_inv_cov_wh_tbl_type dpp_coveredinventory_pvt.dpp_inv_cov_wh_tbl_type;
1734: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
1735:
1736: l_price_change_flag VARCHAR2(20);
1737:
1738: BEGIN

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

1934: AS
1935: l_api_name constant VARCHAR2(30) := 'Update_Approval';
1936: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1937: l_approved_by VARCHAR2(55);
1938: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
1939: l_claim_id VARCHAR2(240);
1940: l_error_message VARCHAR2(4000) := NULL;
1941: BEGIN
1942: -- Initialize API return status to sucess

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

2069: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2070: l_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
2071: l_commit VARCHAR2(30) := FND_API.G_FALSE;
2072: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2073: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2074: l_count_lines NUMBER;
2075: l_count_approved_lines NUMBER;
2076: l_claim_txn_hdr_rec_type dpp_businessevents_pvt.dpp_txn_hdr_rec_type;
2077: l_claim_txn_line_tbl_type dpp_businessevents_pvt.dpp_txn_line_tbl_type;

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

2198: ,x_return_status OUT nocopy VARCHAR2)
2199: AS
2200: l_api_name constant VARCHAR2(30) := 'form_line_tbl';
2201: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2202: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2203: l_txn_lines_rec_type txn_lines_rec;
2204:
2205: l_line_number NUMBER;
2206: l_duplicate_lines NUMBER;

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

2337: l_return_status VARCHAR2(30);
2338: l_init_msg_list VARCHAR2(30) := FND_API.G_FALSE;
2339: l_commit VARCHAR2(30) := FND_API.G_FALSE;
2340: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2341: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2342:
2343: l_txn_hdr_hist_rec dpp_log_pvt.dpp_cst_hdr_rec_type;
2344: l_txn_hdr_rec dpp_log_pvt.dpp_cst_hdr_rec_type;
2345: BEGIN

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

2583: , x_return_status OUT nocopy VARCHAR2)
2584: AS
2585: l_date DATE;
2586: l_api_name constant VARCHAR2(30) := 'Update_InterfaceTbl';
2587: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2588: BEGIN
2589: -- Initialize API return status to sucess
2590: x_return_status := fnd_api.g_ret_sts_success;
2591:

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

2650: )
2651: AS
2652:
2653: l_api_name constant VARCHAR2(30) := 'Update_InterfaceErrSts';
2654: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2655: BEGIN
2656: -- Initialize API return status to sucess
2657: x_return_status := fnd_api.g_ret_sts_success;
2658: IF DPP_DEBUG_HIGH_ON THEN

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

2730: l_api_version constant NUMBER := 1.0;
2731: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2732:
2733: l_return_status VARCHAR2(30);
2734: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
2735: l_transaction_status VARCHAR2(55);
2736: l_status_cancelled VARCHAR2(55);
2737: l_transaction_type VARCHAR2(100);
2738: l_log_enabled VARCHAR2(20);

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

2778: IF DPP_DEBUG_HIGH_ON THEN
2779: fnd_file.put_line(fnd_file.log, 'Begin Insert Transaction ' );
2780: END IF;
2781:
2782: SELECT fnd_profile.VALUE('DPP_AUDIT_ENABLED')
2783: INTO l_log_enabled
2784: FROM dual;
2785:
2786: IF DPP_DEBUG_HIGH_ON THEN

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

3691: p_transaction_lines_rec IN OUT nocopy txn_lines_rec,
3692: x_msg_count OUT nocopy NUMBER,
3693: x_return_status OUT nocopy VARCHAR2)
3694: AS
3695: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
3696: create_IntLines_exception EXCEPTION;
3697: l_error_message VARCHAR2(4000);
3698: x_msg_data VARCHAR2(4000);
3699:

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

4198: l_return_status VARCHAR2(30);
4199: l_msg_count NUMBER;
4200: l_msg_data VARCHAR2(2000);
4201: l_user_name VARCHAR2(30);
4202: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
4203: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
4204: l_commit VARCHAR2(30) := fnd_api.g_false;
4205: l_validation_level NUMBER := fnd_api.g_valid_level_full;
4206: l_transaction_int_header_id NUMBER;

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

4723:
4724: l_return_status VARCHAR2(30);
4725: l_msg_count NUMBER;
4726: l_msg_data VARCHAR2(4000);
4727: l_user_id NUMBER :=FND_PROFILE.VALUE('USER_ID');
4728:
4729: l_request_id NUMBER :=FND_GLOBAL.conc_request_id;
4730: l_program_id NUMBER :=FND_GLOBAL.conc_program_id;
4731: l_prog_app_id NUMBER :=FND_GLOBAL.prog_appl_id;

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

4790: ||'DPP_INBOUND_PVT_BODY unit: '||p_operating_unit);
4791: --BUG 6806974
4792:
4793:
4794: SELECT fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') into l_value from dual;
4795:
4796: mo_global.set_org_access( null,l_value,'M');
4797:
4798: