DBA Data[Home] [Help]

APPS.CSI_JAVA_INTERFACE_PKG dependencies on FND_PROFILE

Line 151: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

147: l_debug_level NUMBER;
148:
149: Begin
150: -- Check the profile option debug_level for debug message reporting
151: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
152:
153: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );
154: l_flag := nvl(l_flag, 'N');
155: l_inp_rec.validate_flag := l_flag;

Line 153: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );

149: Begin
150: -- Check the profile option debug_level for debug message reporting
151: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
152:
153: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );
154: l_flag := nvl(l_flag, 'N');
155: l_inp_rec.validate_flag := l_flag;
156: l_inp_rec.product_id := product_id;
157: l_inp_rec.calc_resptime_flag := 'N';

Line 571: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );

567: and rownum <= 1
568: For Update NoWait;
569:
570: BEGIN
571: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );
572:
573: -- Check the profile option debug_level for debug message reporting
574: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
575:

Line 574: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

570: BEGIN
571: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );
572:
573: -- Check the profile option debug_level for debug message reporting
574: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
575:
576: l_flag := nvl(l_flag, 'N');
577:
578: l_inp_rec.contract_number := contract_number;

Line 752: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );

748: l_inp_rec OKS_ENTITLEMENTS_PUB.inp_cont_rec;
749: l_debug_level NUMBER;
750: l_instance_table_name VARCHAR2(200);
751: BEGIN
752: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );
753:
754: -- Check the profile option debug_level for debug message reporting
755: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
756:

Line 755: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

751: BEGIN
752: fnd_profile.get('CSI_IB_SHOW_ALL_CONTRACTS', l_flag );
753:
754: -- Check the profile option debug_level for debug message reporting
755: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
756:
757: l_flag := nvl(l_flag, 'N');
758:
759: l_inp_rec.contract_number := contract_number;

Line 1102: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

1098: -- Initialize API return status to success
1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1100: /** bug 3304439
1101: -- Check for the profile option and enable trace
1102: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1103: dbms_session.set_sql_trace(TRUE);
1104: END IF;
1105: **/
1106:

Line 1386: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

1382: COMMIT WORK;
1383: END IF;
1384: /** bug 3304439
1385: -- Check for the profile option and disable the trace
1386: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
1387: dbms_session.set_sql_trace(false);
1388: END IF;
1389: **/
1390: -- End disable trace

Line 1458: l_resp_id := fnd_profile.value('RESP_ID');

1454: -- Initialize API rturn status to success
1455: x_return_status := FND_API.g_ret_sts_success;
1456:
1457:
1458: l_resp_id := fnd_profile.value('RESP_ID');
1459: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
1460:
1461: -- get icx session ticket
1462: x_icx_sessn_tkt := CZ_CF_API.ICX_SESSION_TICKET;

Line 1459: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

1455: x_return_status := FND_API.g_ret_sts_success;
1456:
1457:
1458: l_resp_id := fnd_profile.value('RESP_ID');
1459: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
1460:
1461: -- get icx session ticket
1462: x_icx_sessn_tkt := CZ_CF_API.ICX_SESSION_TICKET;
1463:

Line 1468: x_servlet_url := fnd_profile.value('CZ_UIMGR_URL');

1464: -- get the dbc file name
1465: x_db_id := FND_WEB_CONFIG.DATABASE_ID;
1466:
1467: -- get the URL for servlet
1468: x_servlet_url := fnd_profile.value('CZ_UIMGR_URL');
1469:
1470: -- get the SYSDATE
1471: x_sysdate := to_char(sysdate,'mm-dd-yyyy-hh24-mi-ss');
1472: