DBA Data[Home] [Help]

APPS.RLM_CORE_SV dependencies on FND_GLOBAL

Line 176: g_FileHandle := utl_file.fopen(v_directory, C_PREFIX||fnd_global.conc_request_id, 'w', 32760);

172: fnd_profile.get('ECE_OUT_FILE_PATH',v_Directory);
173: if file_number IS NOT NULL THEN
174: g_FileHandle := utl_file.fopen(v_directory, C_PREFIX||file_number, 'w', 32760);
175: else
176: g_FileHandle := utl_file.fopen(v_directory, C_PREFIX||fnd_global.conc_request_id, 'w', 32760);
177: end if;
178: dlog('file name','debug'||fnd_global.conc_request_id);
179: END IF;
180: dlog('Starting debugger',sysdate);

Line 178: dlog('file name','debug'||fnd_global.conc_request_id);

174: g_FileHandle := utl_file.fopen(v_directory, C_PREFIX||file_number, 'w', 32760);
175: else
176: g_FileHandle := utl_file.fopen(v_directory, C_PREFIX||fnd_global.conc_request_id, 'w', 32760);
177: end if;
178: dlog('file name','debug'||fnd_global.conc_request_id);
179: END IF;
180: dlog('Starting debugger',sysdate);
181:
182: EXCEPTION

Line 1468: last_update_login = fnd_global.login_id ,

1464: dlog('Header_id', x_header_id);
1465: --
1466: UPDATE rlm_interface_headers
1467: SET process_status = rlm_core_sv.k_PS_ERROR,
1468: last_update_login = fnd_global.login_id ,
1469: request_id = fnd_global.conc_REQUEST_ID ,
1470: program_application_id = fnd_global.PROG_APPL_ID ,
1471: program_id = fnd_global.conc_program_id,
1472: program_update_date = sysdate

Line 1469: request_id = fnd_global.conc_REQUEST_ID ,

1465: --
1466: UPDATE rlm_interface_headers
1467: SET process_status = rlm_core_sv.k_PS_ERROR,
1468: last_update_login = fnd_global.login_id ,
1469: request_id = fnd_global.conc_REQUEST_ID ,
1470: program_application_id = fnd_global.PROG_APPL_ID ,
1471: program_id = fnd_global.conc_program_id,
1472: program_update_date = sysdate
1473: WHERE header_id = x_header_id;

Line 1470: program_application_id = fnd_global.PROG_APPL_ID ,

1466: UPDATE rlm_interface_headers
1467: SET process_status = rlm_core_sv.k_PS_ERROR,
1468: last_update_login = fnd_global.login_id ,
1469: request_id = fnd_global.conc_REQUEST_ID ,
1470: program_application_id = fnd_global.PROG_APPL_ID ,
1471: program_id = fnd_global.conc_program_id,
1472: program_update_date = sysdate
1473: WHERE header_id = x_header_id;
1474: --

Line 1471: program_id = fnd_global.conc_program_id,

1467: SET process_status = rlm_core_sv.k_PS_ERROR,
1468: last_update_login = fnd_global.login_id ,
1469: request_id = fnd_global.conc_REQUEST_ID ,
1470: program_application_id = fnd_global.PROG_APPL_ID ,
1471: program_id = fnd_global.conc_program_id,
1472: program_update_date = sysdate
1473: WHERE header_id = x_header_id;
1474: --
1475: dlog('No of interface headers Updated ', SQL%ROWCOUNT);

Line 1479: last_update_login = fnd_global.login_id ,

1475: dlog('No of interface headers Updated ', SQL%ROWCOUNT);
1476: --
1477: UPDATE rlm_interface_lines
1478: SET process_status = rlm_core_sv.k_PS_ERROR,
1479: last_update_login = fnd_global.login_id ,
1480: request_id = fnd_global.conc_REQUEST_ID ,
1481: program_application_id = fnd_global.PROG_APPL_ID ,
1482: program_id = fnd_global.conc_program_id,
1483: program_update_date = sysdate

Line 1480: request_id = fnd_global.conc_REQUEST_ID ,

1476: --
1477: UPDATE rlm_interface_lines
1478: SET process_status = rlm_core_sv.k_PS_ERROR,
1479: last_update_login = fnd_global.login_id ,
1480: request_id = fnd_global.conc_REQUEST_ID ,
1481: program_application_id = fnd_global.PROG_APPL_ID ,
1482: program_id = fnd_global.conc_program_id,
1483: program_update_date = sysdate
1484: WHERE header_id = x_header_id;

Line 1481: program_application_id = fnd_global.PROG_APPL_ID ,

1477: UPDATE rlm_interface_lines
1478: SET process_status = rlm_core_sv.k_PS_ERROR,
1479: last_update_login = fnd_global.login_id ,
1480: request_id = fnd_global.conc_REQUEST_ID ,
1481: program_application_id = fnd_global.PROG_APPL_ID ,
1482: program_id = fnd_global.conc_program_id,
1483: program_update_date = sysdate
1484: WHERE header_id = x_header_id;
1485: --

Line 1482: program_id = fnd_global.conc_program_id,

1478: SET process_status = rlm_core_sv.k_PS_ERROR,
1479: last_update_login = fnd_global.login_id ,
1480: request_id = fnd_global.conc_REQUEST_ID ,
1481: program_application_id = fnd_global.PROG_APPL_ID ,
1482: program_id = fnd_global.conc_program_id,
1483: program_update_date = sysdate
1484: WHERE header_id = x_header_id;
1485: --
1486: dlog('No of interface Lines Updated ', SQL%ROWCOUNT);

Line 1492: last_update_login = fnd_global.login_id ,

1488: IF x_sch_header_id is NOT NULL THEN
1489: --
1490: UPDATE rlm_schedule_headers
1491: SET process_status = rlm_core_sv.k_PS_ERROR,
1492: last_update_login = fnd_global.login_id ,
1493: request_id = fnd_global.conc_REQUEST_ID ,
1494: program_application_id = fnd_global.PROG_APPL_ID ,
1495: program_id = fnd_global.conc_program_id,
1496: program_update_date = sysdate

Line 1493: request_id = fnd_global.conc_REQUEST_ID ,

1489: --
1490: UPDATE rlm_schedule_headers
1491: SET process_status = rlm_core_sv.k_PS_ERROR,
1492: last_update_login = fnd_global.login_id ,
1493: request_id = fnd_global.conc_REQUEST_ID ,
1494: program_application_id = fnd_global.PROG_APPL_ID ,
1495: program_id = fnd_global.conc_program_id,
1496: program_update_date = sysdate
1497: WHERE header_id = x_sch_header_id;

Line 1494: program_application_id = fnd_global.PROG_APPL_ID ,

1490: UPDATE rlm_schedule_headers
1491: SET process_status = rlm_core_sv.k_PS_ERROR,
1492: last_update_login = fnd_global.login_id ,
1493: request_id = fnd_global.conc_REQUEST_ID ,
1494: program_application_id = fnd_global.PROG_APPL_ID ,
1495: program_id = fnd_global.conc_program_id,
1496: program_update_date = sysdate
1497: WHERE header_id = x_sch_header_id;
1498: --

Line 1495: program_id = fnd_global.conc_program_id,

1491: SET process_status = rlm_core_sv.k_PS_ERROR,
1492: last_update_login = fnd_global.login_id ,
1493: request_id = fnd_global.conc_REQUEST_ID ,
1494: program_application_id = fnd_global.PROG_APPL_ID ,
1495: program_id = fnd_global.conc_program_id,
1496: program_update_date = sysdate
1497: WHERE header_id = x_sch_header_id;
1498: --
1499: dlog('No of schedule headers Updated ', SQL%ROWCOUNT);

Line 1503: last_update_login = fnd_global.login_id ,

1499: dlog('No of schedule headers Updated ', SQL%ROWCOUNT);
1500: --
1501: UPDATE rlm_schedule_lines
1502: SET process_status = rlm_core_sv.k_PS_ERROR,
1503: last_update_login = fnd_global.login_id ,
1504: request_id = fnd_global.conc_REQUEST_ID ,
1505: program_application_id = fnd_global.PROG_APPL_ID ,
1506: program_id = fnd_global.conc_program_id,
1507: program_update_date = sysdate

Line 1504: request_id = fnd_global.conc_REQUEST_ID ,

1500: --
1501: UPDATE rlm_schedule_lines
1502: SET process_status = rlm_core_sv.k_PS_ERROR,
1503: last_update_login = fnd_global.login_id ,
1504: request_id = fnd_global.conc_REQUEST_ID ,
1505: program_application_id = fnd_global.PROG_APPL_ID ,
1506: program_id = fnd_global.conc_program_id,
1507: program_update_date = sysdate
1508: WHERE header_id = x_sch_header_id;

Line 1505: program_application_id = fnd_global.PROG_APPL_ID ,

1501: UPDATE rlm_schedule_lines
1502: SET process_status = rlm_core_sv.k_PS_ERROR,
1503: last_update_login = fnd_global.login_id ,
1504: request_id = fnd_global.conc_REQUEST_ID ,
1505: program_application_id = fnd_global.PROG_APPL_ID ,
1506: program_id = fnd_global.conc_program_id,
1507: program_update_date = sysdate
1508: WHERE header_id = x_sch_header_id;
1509: --

Line 1506: program_id = fnd_global.conc_program_id,

1502: SET process_status = rlm_core_sv.k_PS_ERROR,
1503: last_update_login = fnd_global.login_id ,
1504: request_id = fnd_global.conc_REQUEST_ID ,
1505: program_application_id = fnd_global.PROG_APPL_ID ,
1506: program_id = fnd_global.conc_program_id,
1507: program_update_date = sysdate
1508: WHERE header_id = x_sch_header_id;
1509: --
1510: dlog('No of schedule Lines Updated ', SQL%ROWCOUNT);