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.RLM_CORE_SV dependencies on RLM_CORE_SV

Line 1: PACKAGE BODY RLM_CORE_SV as

1: PACKAGE BODY RLM_CORE_SV as
2: /* $Header: RLMCOREB.pls 120.7 2006/04/17 18:33:01 rvishnuv noship $ */
3: /*========================== rlm_core_sv ============================*/
4:
5: g_debug_flag BOOLEAN := FALSE;

Line 3: /========================== rlm_core_sv ============================/

1: PACKAGE BODY RLM_CORE_SV as
2: /* $Header: RLMCOREB.pls 120.7 2006/04/17 18:33:01 rvishnuv noship $ */
3: /*========================== rlm_core_sv ============================*/
4:
5: g_debug_flag BOOLEAN := FALSE;
6:
7: /*===========================================================================

Line 134: rlm_message_sv.sql_error('rlm_core_sv.level_defined', v_Progress);

130: RETURN(FALSE);
131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: rlm_message_sv.sql_error('rlm_core_sv.level_defined', v_Progress);
135:
136: END level_defined;
137:
138: /*===========================================================================

Line 188: rlm_message_sv.sql_error('rlm_core_sv.start_debug', v_Progress);

184: IF utl_file.is_open(g_FileHandle) THEN
185: utl_file.fclose(g_FileHandle);
186: END IF;
187: g_Debug := FALSE;
188: rlm_message_sv.sql_error('rlm_core_sv.start_debug', v_Progress);
189:
190: END start_debug;
191:
192:

Line 219: rlm_message_sv.sql_error('rlm_core_sv.stop_debug', v_Progress);

215:
216: EXCEPTION
217: WHEN OTHERS THEN
218: g_Debug := FALSE;
219: rlm_message_sv.sql_error('rlm_core_sv.stop_debug', v_Progress);
220:
221: END stop_debug;
222:
223:

Line 259: rlm_message_sv.sql_error('rlm_core_sv.tstart', v_Progress);

255: END IF;
256:
257: EXCEPTION
258: WHEN OTHERS THEN
259: rlm_message_sv.sql_error('rlm_core_sv.tstart', v_Progress);
260:
261: END tstart;
262:
263:

Line 297: rlm_message_sv.sql_error('rlm_core_sv.tstart', v_Progress);

293: END IF;
294:
295: EXCEPTION
296: WHEN OTHERS THEN
297: rlm_message_sv.sql_error('rlm_core_sv.tstart', v_Progress);
298:
299: END tstart;
300:
301:

Line 330: rlm_message_sv.sql_error('rlm_core_sv.tstop', v_Progress);

326: END IF;
327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: rlm_message_sv.sql_error('rlm_core_sv.tstop', v_Progress);
331:
332: END tstop;
333:
334:

Line 363: rlm_message_sv.sql_error('rlm_core_sv.tstop', v_Progress);

359: END IF;
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: rlm_message_sv.sql_error('rlm_core_sv.tstop', v_Progress);
364:
365: END tstop;
366:
367:

Line 394: rlm_message_sv.sql_error('rlm_core_sv.tprint', v_Progress);

390: END IF;
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: rlm_message_sv.sql_error('rlm_core_sv.tprint', v_Progress);
395:
396: END tprint;
397:
398:

Line 424: rlm_message_sv.sql_error('rlm_core_sv.tdump', v_Progress);

420: END IF;
421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: rlm_message_sv.sql_error('rlm_core_sv.tdump', v_Progress);
425:
426: END tdump;
427:
428:

Line 456: rlm_message_sv.sql_error('rlm_core_sv.tdump', v_Progress);

452: END IF;
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: rlm_message_sv.sql_error('rlm_core_sv.tdump', v_Progress);
457:
458: END tdump;
459:
460:

Line 500: rlm_message_sv.sql_error('rlm_core_sv.start_time', v_Progress);

496: END IF;
497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: rlm_message_sv.sql_error('rlm_core_sv.start_time', v_Progress);
501:
502: END start_time;
503:
504:

Line 542: rlm_message_sv.sql_error('rlm_core_sv.start_time', v_Progress);

538: END IF;
539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: rlm_message_sv.sql_error('rlm_core_sv.start_time', v_Progress);
543:
544: END start_time;
545:
546:

Line 581: rlm_message_sv.sql_error('rlm_core_sv.stop_time', v_Progress);

577: END IF;
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: rlm_message_sv.sql_error('rlm_core_sv.stop_time', v_Progress);
582:
583: END stop_time;
584:
585:

Line 618: rlm_message_sv.sql_error('rlm_core_sv.stop_time', v_Progress);

614: END IF;
615:
616: EXCEPTION
617: WHEN OTHERS THEN
618: rlm_message_sv.sql_error('rlm_core_sv.stop_time', v_Progress);
619:
620: END stop_time;
621:
622: /*===========================================================================

Line 641: RAISE_APPLICATION_ERROR(E_PIPE_FAILURE,'rlm_core_sv.write_output: failed to write to debugging pipe');

637: /*
638: IF g_DebugAll or level_defined(C_PIPE) THEN
639: dbms_pipe.pack_message(x_Line);
640: IF dbms_pipe.send_message(C_DEBUG_PIPE,60) <> 0 THEN
641: RAISE_APPLICATION_ERROR(E_PIPE_FAILURE,'rlm_core_sv.write_output: failed to write to debugging pipe');
642: END IF;
643: END IF;
644: */
645: IF g_DebugAll or level_defined(C_SCREEN) THEN

Line 652: rlm_message_sv.sql_error('rlm_core_sv.write_output', v_Progress);

648: END IF;
649:
650: EXCEPTION
651: WHEN OTHERS THEN
652: rlm_message_sv.sql_error('rlm_core_sv.write_output', v_Progress);
653:
654: END write_output;
655:
656:

Line 953: rlm_message_sv.sql_error('rlm_core_sv.dpush', v_Progress);

949: END IF;
950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: rlm_message_sv.sql_error('rlm_core_sv.dpush', v_Progress);
954:
955: END dpush;
956:
957:

Line 978: rlm_message_sv.sql_error('rlm_core_sv.dpush', v_Progress);

974: END IF;
975:
976: EXCEPTION
977: WHEN OTHERS THEN
978: rlm_message_sv.sql_error('rlm_core_sv.dpush', v_Progress);
979:
980: END dpush;
981:
982:

Line 1011: rlm_message_sv.sql_error('rlm_core_sv.dpop', v_Progress);

1007: END IF;
1008:
1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: rlm_message_sv.sql_error('rlm_core_sv.dpop', v_Progress);
1012:
1013: END dpop;
1014:
1015:

Line 1042: rlm_message_sv.sql_error('rlm_core_sv.dpop', v_Progress);

1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: rlm_message_sv.sql_error('rlm_core_sv.dpop', v_Progress);
1043:
1044: END dpop;
1045:
1046:

Line 1069: rlm_message_sv.sql_error('rlm_core_sv.make_space', v_Progress);

1065: RETURN(v_Temp);
1066:
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: rlm_message_sv.sql_error('rlm_core_sv.make_space', v_Progress);
1070:
1071: END make_space;
1072:
1073: /*===========================================================================

Line 1325: rlm_message_sv.sql_error('rlm_core_sv.get_customer_name', x_progress);

1321: --
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: --
1325: rlm_message_sv.sql_error('rlm_core_sv.get_customer_name', x_progress);
1326: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
1327: RAISE;
1328: --
1329: END get_customer_name;

Line 1361: rlm_message_sv.sql_error('rlm_core_sv.get_item_number', x_progress);

1357: --
1358: EXCEPTION
1359: WHEN OTHERS THEN
1360: --
1361: rlm_message_sv.sql_error('rlm_core_sv.get_item_number', x_progress);
1362: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
1363: RAISE;
1364: --
1365: END get_item_number;

Line 1403: rlm_message_sv.sql_error('rlm_core_sv.get_ship_from', x_progress);

1399: --
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: --
1403: rlm_message_sv.sql_error('rlm_core_sv.get_ship_from', x_progress);
1404: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
1405: RAISE;
1406: --
1407: END get_ship_from;

Line 1443: rlm_message_sv.sql_error('rlm_core_sv.get_ship_to', x_progress);

1439: --
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: --
1443: rlm_message_sv.sql_error('rlm_core_sv.get_ship_to', x_progress);
1444: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
1445: RAISE;
1446: --
1447: END get_ship_to;

Line 1467: SET process_status = rlm_core_sv.k_PS_ERROR,

1463: dpush('SetSchedulePSError');
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,

Line 1478: SET process_status = rlm_core_sv.k_PS_ERROR,

1474: --
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,

Line 1491: SET process_status = rlm_core_sv.k_PS_ERROR,

1487: --
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,

Line 1502: SET process_status = rlm_core_sv.k_PS_ERROR,

1498: --
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,

Line 1520: rlm_message_sv.sql_error('rlm_core_sv.SetSchedulePSError:',v_Progress);

1516: EXCEPTION
1517: --
1518: WHEN OTHERS THEN
1519: --
1520: rlm_message_sv.sql_error('rlm_core_sv.SetSchedulePSError:',v_Progress);
1521: dpop('EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1522: raise;
1523: --
1524: END SetSchedulePSError;

Line 1561: rlm_message_sv.sql_error('rlm_core_sv.get_schedule_reference_num', x_progress);

1557: --
1558: EXCEPTION
1559: WHEN OTHERS THEN
1560: --
1561: rlm_message_sv.sql_error('rlm_core_sv.get_schedule_reference_num', x_progress);
1562: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
1563: RAISE;
1564: --
1565: END get_schedule_reference_num;

Line 34063: rlm_message_sv.sql_error('rlm_core_sv.get_scheule_line_number', x_progress);

34059: --
34060: EXCEPTION
34061: WHEN OTHERS THEN
34062: --
34063: rlm_message_sv.sql_error('rlm_core_sv.get_scheule_line_number', x_progress);
34064: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
34065: RAISE;
34066: --
34067: END get_schedule_line_number;

Line 34101: rlm_message_sv.sql_error('rlm_core_sv.get_order_line_number', x_progress);

34097: --
34098: EXCEPTION
34099: WHEN OTHERS THEN
34100: --
34101: rlm_message_sv.sql_error('rlm_core_sv.get_order_line_number', x_progress);
34102: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
34103: RAISE;
34104: --
34105: END get_order_line_number;

Line 34137: rlm_message_sv.sql_error('rlm_core_sv.get_order_number', x_progress);

34133: --
34134: EXCEPTION
34135: WHEN OTHERS THEN
34136: --
34137: rlm_message_sv.sql_error('rlm_core_sv.get_order_number', x_progress);
34138: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
34139: RAISE;
34140: --
34141: END get_order_number;

Line 34174: rlm_message_sv.sql_error('rlm_core_sv.get_proc_status_meaning', x_progress);

34170: --
34171: EXCEPTION
34172: WHEN OTHERS THEN
34173: --
34174: rlm_message_sv.sql_error('rlm_core_sv.get_proc_status_meaning', x_progress);
34175: dlog('EXECPTION: '|| SUBSTR(SQLERRM,1,200));
34176: RAISE;
34177: --
34178: END get_proc_status_meaning;

Line 34180: END rlm_core_sv;

34176: RAISE;
34177: --
34178: END get_proc_status_meaning;
34179:
34180: END rlm_core_sv;