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.FUN_SEQ dependencies on FND_LOG

Line 96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

92: BEGIN
93: --
94: -- Debug Information
95: --
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.STRING(
98: FND_LOG.LEVEL_PROCEDURE,
99: 'fun.plsql.fun_seq.get_sequence_number.begin',
100: 'p_context_type: ' || p_context_type ||', '||

Line 97: FND_LOG.STRING(

93: --
94: -- Debug Information
95: --
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.STRING(
98: FND_LOG.LEVEL_PROCEDURE,
99: 'fun.plsql.fun_seq.get_sequence_number.begin',
100: 'p_context_type: ' || p_context_type ||', '||
101: 'p_context_value: ' || p_context_value ||', '||

Line 98: FND_LOG.LEVEL_PROCEDURE,

94: -- Debug Information
95: --
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.STRING(
98: FND_LOG.LEVEL_PROCEDURE,
99: 'fun.plsql.fun_seq.get_sequence_number.begin',
100: 'p_context_type: ' || p_context_type ||', '||
101: 'p_context_value: ' || p_context_value ||', '||
102: 'p_application_id: ' || p_application_id ||', '||

Line 157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

153:
154: --
155: -- Debug Information
156: --
157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.STRING(
159: FND_LOG.LEVEL_PROCEDURE,
160: 'fun.plsql.fun_seq.get_sequence_number.end',
161: 'p_context_type: ' || p_context_type ||', '||

Line 158: FND_LOG.STRING(

154: --
155: -- Debug Information
156: --
157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.STRING(
159: FND_LOG.LEVEL_PROCEDURE,
160: 'fun.plsql.fun_seq.get_sequence_number.end',
161: 'p_context_type: ' || p_context_type ||', '||
162: 'p_context_value: ' || p_context_value ||', '||

Line 159: FND_LOG.LEVEL_PROCEDURE,

155: -- Debug Information
156: --
157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.STRING(
159: FND_LOG.LEVEL_PROCEDURE,
160: 'fun.plsql.fun_seq.get_sequence_number.end',
161: 'p_context_type: ' || p_context_type ||', '||
162: 'p_context_value: ' || p_context_value ||', '||
163: 'p_application_id: ' || p_application_id ||', '||

Line 174: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

170: WHEN OTHERS THEN
171: --
172: -- Debug Information
173: --
174: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
175: fnd_log.string(
176: fnd_log.level_exception,
177: 'fun.plsql.fun_seq.get_sequence_Number.exception',
178: 'p_context_type: ' || p_context_type ||', '||

Line 175: fnd_log.string(

171: --
172: -- Debug Information
173: --
174: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
175: fnd_log.string(
176: fnd_log.level_exception,
177: 'fun.plsql.fun_seq.get_sequence_Number.exception',
178: 'p_context_type: ' || p_context_type ||', '||
179: 'p_context_value: ' || p_context_value ||', '||

Line 176: fnd_log.level_exception,

172: -- Debug Information
173: --
174: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
175: fnd_log.string(
176: fnd_log.level_exception,
177: 'fun.plsql.fun_seq.get_sequence_Number.exception',
178: 'p_context_type: ' || p_context_type ||', '||
179: 'p_context_value: ' || p_context_value ||', '||
180: 'p_application_id: ' || p_application_id ||', '||

Line 258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

254: BEGIN
255: --
256: -- Debug Information
257: --
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(
260: FND_LOG.LEVEL_PROCEDURE,
261: 'fun.plsql.fun_seq.get_assigned_sequence_info.begin',
262: 'p_context_type: ' || p_context_type ||', '||

Line 259: FND_LOG.STRING(

255: --
256: -- Debug Information
257: --
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(
260: FND_LOG.LEVEL_PROCEDURE,
261: 'fun.plsql.fun_seq.get_assigned_sequence_info.begin',
262: 'p_context_type: ' || p_context_type ||', '||
263: 'p_context_value: ' || p_context_value ||', '||

Line 260: FND_LOG.LEVEL_PROCEDURE,

256: -- Debug Information
257: --
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(
260: FND_LOG.LEVEL_PROCEDURE,
261: 'fun.plsql.fun_seq.get_assigned_sequence_info.begin',
262: 'p_context_type: ' || p_context_type ||', '||
263: 'p_context_value: ' || p_context_value ||', '||
264: 'p_application_id: ' || p_application_id ||', '||

Line 379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

375: x_seq_version_id := l_seq_version_id;
376: --
377: -- Debug Information
378: --
379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(
381: FND_LOG.LEVEL_PROCEDURE,
382: 'fun.plsql.fun_seq.get_assigned_sequence_info.end',
383: 'x_sequence_type: ' || x_sequence_type || ', ' ||

Line 380: FND_LOG.STRING(

376: --
377: -- Debug Information
378: --
379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(
381: FND_LOG.LEVEL_PROCEDURE,
382: 'fun.plsql.fun_seq.get_assigned_sequence_info.end',
383: 'x_sequence_type: ' || x_sequence_type || ', ' ||
384: 'x_assignment_id: ' || x_assignment_id || ', ' ||

Line 381: FND_LOG.LEVEL_PROCEDURE,

377: -- Debug Information
378: --
379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(
381: FND_LOG.LEVEL_PROCEDURE,
382: 'fun.plsql.fun_seq.get_assigned_sequence_info.end',
383: 'x_sequence_type: ' || x_sequence_type || ', ' ||
384: 'x_assignment_id: ' || x_assignment_id || ', ' ||
385: 'x_control_date_value: '|| x_control_date_value ||', '||

Line 393: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

389: WHEN no_assignment_found THEN
390: --
391: -- Debug Information
392: --
393: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(
395: FND_LOG.LEVEL_EXCEPTION,
396: 'fun.plsql.fun_seq.get_assigned_sequence_info.no_assign',
397: 'No Assignment Found (Require Assignment = Y)' ||', '||

Line 394: FND_LOG.STRING(

390: --
391: -- Debug Information
392: --
393: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(
395: FND_LOG.LEVEL_EXCEPTION,
396: 'fun.plsql.fun_seq.get_assigned_sequence_info.no_assign',
397: 'No Assignment Found (Require Assignment = Y)' ||', '||
398: 'l_seq_context_id :' || l_seq_context_id);

Line 395: FND_LOG.LEVEL_EXCEPTION,

391: -- Debug Information
392: --
393: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING(
395: FND_LOG.LEVEL_EXCEPTION,
396: 'fun.plsql.fun_seq.get_assigned_sequence_info.no_assign',
397: 'No Assignment Found (Require Assignment = Y)' ||', '||
398: 'l_seq_context_id :' || l_seq_context_id);
399: END IF;

Line 409: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

405: IF p_suppress_error = 'N' THEN
406: app_exception.raise_exception;
407: END IF;
408: WHEN OTHERS THEN
409: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(
411: fnd_log.level_exception,
412: 'fun.plsql.fun_seq.get_assigned_sequence_info.exception',
413: 'l_seq_context_id :' || l_seq_context_id ||', ' ||

Line 410: fnd_log.string(

406: app_exception.raise_exception;
407: END IF;
408: WHEN OTHERS THEN
409: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(
411: fnd_log.level_exception,
412: 'fun.plsql.fun_seq.get_assigned_sequence_info.exception',
413: 'l_seq_context_id :' || l_seq_context_id ||', ' ||
414: 'SQLERRM: ' || SQLERRM);

Line 411: fnd_log.level_exception,

407: END IF;
408: WHEN OTHERS THEN
409: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(
411: fnd_log.level_exception,
412: 'fun.plsql.fun_seq.get_assigned_sequence_info.exception',
413: 'l_seq_context_id :' || l_seq_context_id ||', ' ||
414: 'SQLERRM: ' || SQLERRM);
415: END IF;

Line 493: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

489: -- Invalid_Seq_Type is a critical programming error.
490: -- So, you cannot suppress this.
491: --
492: WHEN invalid_seq_type THEN
493: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(
495: log_level => fnd_log.level_exception,
496: module => 'fun.plsql.fun_seq.generate_sequence_number',
497: message => 'Invalid Sequence Type: ' || ', ' ||

Line 494: fnd_log.string(

490: -- So, you cannot suppress this.
491: --
492: WHEN invalid_seq_type THEN
493: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(
495: log_level => fnd_log.level_exception,
496: module => 'fun.plsql.fun_seq.generate_sequence_number',
497: message => 'Invalid Sequence Type: ' || ', ' ||
498: 'SQLERRM: ' || SQLERRM);

Line 495: log_level => fnd_log.level_exception,

491: --
492: WHEN invalid_seq_type THEN
493: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(
495: log_level => fnd_log.level_exception,
496: module => 'fun.plsql.fun_seq.generate_sequence_number',
497: message => 'Invalid Sequence Type: ' || ', ' ||
498: 'SQLERRM: ' || SQLERRM);
499: END IF;

Line 502: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

498: 'SQLERRM: ' || SQLERRM);
499: END IF;
500: app_exception.raise_exception;
501: WHEN OTHERS THEN
502: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
503: fnd_log.string(
504: log_level => fnd_log.level_exception,
505: module => 'fun.plsql.fun_seq.generate_sequence_number',
506: message =>

Line 503: fnd_log.string(

499: END IF;
500: app_exception.raise_exception;
501: WHEN OTHERS THEN
502: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
503: fnd_log.string(
504: log_level => fnd_log.level_exception,
505: module => 'fun.plsql.fun_seq.generate_sequence_number',
506: message =>
507: 'SQLERRM: ' || SQLERRM);

Line 504: log_level => fnd_log.level_exception,

500: app_exception.raise_exception;
501: WHEN OTHERS THEN
502: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
503: fnd_log.string(
504: log_level => fnd_log.level_exception,
505: module => 'fun.plsql.fun_seq.generate_sequence_number',
506: message =>
507: 'SQLERRM: ' || SQLERRM);
508: END IF;

Line 531: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

527: SET sv.current_value = p_sequence_number
528: WHERE sv.seq_version_id = p_seq_version_id;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_exception,
534: module => 'fun.plsql.fun_seq.reset',
535: message =>

Line 532: fnd_log.string(

528: WHERE sv.seq_version_id = p_seq_version_id;
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_exception,
534: module => 'fun.plsql.fun_seq.reset',
535: message =>
536: 'SQLERRM: ' || SQLERRM);

Line 533: log_level => fnd_log.level_exception,

529: EXCEPTION
530: WHEN OTHERS THEN
531: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
532: fnd_log.string(
533: log_level => fnd_log.level_exception,
534: module => 'fun.plsql.fun_seq.reset',
535: message =>
536: 'SQLERRM: ' || SQLERRM);
537: END IF;

Line 567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

563: BEGIN
564: --
565: -- Debug Information
566: --
567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.STRING(
569: FND_LOG.LEVEL_PROCEDURE,
570: 'fun.plsql.fun_seq.get_assign_context_info.begin',
571: 'Beginning of get_assign_context_info');

Line 568: FND_LOG.STRING(

564: --
565: -- Debug Information
566: --
567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.STRING(
569: FND_LOG.LEVEL_PROCEDURE,
570: 'fun.plsql.fun_seq.get_assign_context_info.begin',
571: 'Beginning of get_assign_context_info');
572: END IF;

Line 569: FND_LOG.LEVEL_PROCEDURE,

565: -- Debug Information
566: --
567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.STRING(
569: FND_LOG.LEVEL_PROCEDURE,
570: 'fun.plsql.fun_seq.get_assign_context_info.begin',
571: 'Beginning of get_assign_context_info');
572: END IF;
573: --

Line 625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

621: END IF;
622: --
623: -- Debug Information
624: --
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(
627: FND_LOG.LEVEL_PROCEDURE,
628: 'fun.plsql.fun_seq.get_assign_context_info.end',
629: 'Get_assign_context_info completes successfully.' ||', ' ||

Line 626: FND_LOG.STRING(

622: --
623: -- Debug Information
624: --
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(
627: FND_LOG.LEVEL_PROCEDURE,
628: 'fun.plsql.fun_seq.get_assign_context_info.end',
629: 'Get_assign_context_info completes successfully.' ||', ' ||
630: 'x_seq_context_id: ' || x_seq_context_id || ', ' ||

Line 627: FND_LOG.LEVEL_PROCEDURE,

623: -- Debug Information
624: --
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(
627: FND_LOG.LEVEL_PROCEDURE,
628: 'fun.plsql.fun_seq.get_assign_context_info.end',
629: 'Get_assign_context_info completes successfully.' ||', ' ||
630: 'x_seq_context_id: ' || x_seq_context_id || ', ' ||
631: 'x_control_date_type: ' || x_control_date_type || ', ' ||

Line 639: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

635: EXCEPTION
636: WHEN NO_DATA_FOUND THEN
637: x_seq_context_id := NULL;
638: WHEN OTHERS THEN
639: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
640: fnd_log.string(
641: log_level => fnd_log.level_exception,
642: module => 'fun.plsql.get_assign_context_info',
643: message =>

Line 640: fnd_log.string(

636: WHEN NO_DATA_FOUND THEN
637: x_seq_context_id := NULL;
638: WHEN OTHERS THEN
639: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
640: fnd_log.string(
641: log_level => fnd_log.level_exception,
642: module => 'fun.plsql.get_assign_context_info',
643: message =>
644: 'SQLERRM: ' || SQLERRM);

Line 641: log_level => fnd_log.level_exception,

637: x_seq_context_id := NULL;
638: WHEN OTHERS THEN
639: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
640: fnd_log.string(
641: log_level => fnd_log.level_exception,
642: module => 'fun.plsql.get_assign_context_info',
643: message =>
644: 'SQLERRM: ' || SQLERRM);
645: END IF;

Line 802: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

798: WHEN no_assigned_seq_info THEN
799: --
800: -- Logging
801: --
802: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
803: fnd_log.string(
804: log_level => fnd_log.level_exception,
805: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
806: message =>

Line 803: fnd_log.string(

799: --
800: -- Logging
801: --
802: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
803: fnd_log.string(
804: log_level => fnd_log.level_exception,
805: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
806: message =>
807: 'l_debug_loc: ' || l_debug_loc ||', '||

Line 804: log_level => fnd_log.level_exception,

800: -- Logging
801: --
802: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
803: fnd_log.string(
804: log_level => fnd_log.level_exception,
805: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
806: message =>
807: 'l_debug_loc: ' || l_debug_loc ||', '||
808: 'p_context_type: ' || p_context_type ||', '||

Line 839: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

835: WHEN OTHERS THEN
836: --
837: -- Logging
838: --
839: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
840: fnd_log.string(
841: log_level => fnd_log.level_exception,
842: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
843: message =>

Line 840: fnd_log.string(

836: --
837: -- Logging
838: --
839: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
840: fnd_log.string(
841: log_level => fnd_log.level_exception,
842: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
843: message =>
844: 'l_debug_loc: ' || l_debug_loc ||', '||

Line 841: log_level => fnd_log.level_exception,

837: -- Logging
838: --
839: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
840: fnd_log.string(
841: log_level => fnd_log.level_exception,
842: module => 'fun.plsql.fun_seq.get_sequence_number_no_commit',
843: message =>
844: 'l_debug_loc: ' || l_debug_loc ||', '||
845: 'p_context_type: ' || p_context_type ||', '||

Line 1734: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1730:
1731: RETURN l_as_index;
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(
1736: log_level => fnd_log.level_exception,
1737: module => 'fun.plsql.fun_seq.find_seq_head_assign_in_cache',
1738: message => 'SQLERRM: ' || SQLERRM);

Line 1735: fnd_log.string(

1731: RETURN l_as_index;
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(
1736: log_level => fnd_log.level_exception,
1737: module => 'fun.plsql.fun_seq.find_seq_head_assign_in_cache',
1738: message => 'SQLERRM: ' || SQLERRM);
1739: END IF;

Line 1736: log_level => fnd_log.level_exception,

1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(
1736: log_level => fnd_log.level_exception,
1737: module => 'fun.plsql.fun_seq.find_seq_head_assign_in_cache',
1738: message => 'SQLERRM: ' || SQLERRM);
1739: END IF;
1740: END find_seq_head_assign_in_cache;