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.MSC_ASK_ORACLE dependencies on MSC_UTIL

Line 19: msc_util.msc_debug(' Start of Program ');

15: x_copy_question IN VARCHAR2 DEFAULT NULL)
16: IS
17: x_question_id number := null;
18: BEGIN
19: msc_util.msc_debug('******** Start of Program ********');
20: msc_util.msc_debug('Mode:'|| to_char(x_mode));
21: msc_util.msc_debug('QuestionType:'|| x_question_type);
22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);

Line 20: msc_util.msc_debug('Mode:'|| to_char(x_mode));

16: IS
17: x_question_id number := null;
18: BEGIN
19: msc_util.msc_debug('******** Start of Program ********');
20: msc_util.msc_debug('Mode:'|| to_char(x_mode));
21: msc_util.msc_debug('QuestionType:'|| x_question_type);
22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);

Line 21: msc_util.msc_debug('QuestionType:'|| x_question_type);

17: x_question_id number := null;
18: BEGIN
19: msc_util.msc_debug('******** Start of Program ********');
20: msc_util.msc_debug('Mode:'|| to_char(x_mode));
21: msc_util.msc_debug('QuestionType:'|| x_question_type);
22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);
25: msc_util.msc_debug('PackageName:'|| x_package_name);

Line 22: msc_util.msc_debug('QuestionCode:'|| x_question_code);

18: BEGIN
19: msc_util.msc_debug('******** Start of Program ********');
20: msc_util.msc_debug('Mode:'|| to_char(x_mode));
21: msc_util.msc_debug('QuestionType:'|| x_question_type);
22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);
25: msc_util.msc_debug('PackageName:'|| x_package_name);
26: msc_util.msc_debug('Copy Question:'|| x_copy_question);

Line 23: msc_util.msc_debug('Question:'|| x_question);

19: msc_util.msc_debug('******** Start of Program ********');
20: msc_util.msc_debug('Mode:'|| to_char(x_mode));
21: msc_util.msc_debug('QuestionType:'|| x_question_type);
22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);
25: msc_util.msc_debug('PackageName:'|| x_package_name);
26: msc_util.msc_debug('Copy Question:'|| x_copy_question);
27: msc_util.msc_debug('**********************************');

Line 24: msc_util.msc_debug('Language:'|| x_lang_code);

20: msc_util.msc_debug('Mode:'|| to_char(x_mode));
21: msc_util.msc_debug('QuestionType:'|| x_question_type);
22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);
25: msc_util.msc_debug('PackageName:'|| x_package_name);
26: msc_util.msc_debug('Copy Question:'|| x_copy_question);
27: msc_util.msc_debug('**********************************');
28: -- There are multiple modes

Line 25: msc_util.msc_debug('PackageName:'|| x_package_name);

21: msc_util.msc_debug('QuestionType:'|| x_question_type);
22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);
25: msc_util.msc_debug('PackageName:'|| x_package_name);
26: msc_util.msc_debug('Copy Question:'|| x_copy_question);
27: msc_util.msc_debug('**********************************');
28: -- There are multiple modes
29: -- (1) new question, so insert data

Line 26: msc_util.msc_debug('Copy Question:'|| x_copy_question);

22: msc_util.msc_debug('QuestionCode:'|| x_question_code);
23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);
25: msc_util.msc_debug('PackageName:'|| x_package_name);
26: msc_util.msc_debug('Copy Question:'|| x_copy_question);
27: msc_util.msc_debug('**********************************');
28: -- There are multiple modes
29: -- (1) new question, so insert data
30: -- (2) copy question from a existing question, so insert data

Line 27: msc_util.msc_debug('**********************************');

23: msc_util.msc_debug('Question:'|| x_question);
24: msc_util.msc_debug('Language:'|| x_lang_code);
25: msc_util.msc_debug('PackageName:'|| x_package_name);
26: msc_util.msc_debug('Copy Question:'|| x_copy_question);
27: msc_util.msc_debug('**********************************');
28: -- There are multiple modes
29: -- (1) new question, so insert data
30: -- (2) copy question from a existing question, so insert data
31: -- (3) update question, so update data

Line 40: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));

36: -- greater than 5001
37: SELECT msc_questions_s.nextval
38: INTO x_question_id
39: FROM dual;
40: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
41:
42: INSERT INTO MSC_QUESTIONS_B(
43: QUESTION_ID
44: ,ANSWER_ID

Line 68: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);

64: FROM dual
65: WHERE not exists (select 'already exists'
66: from msc_questions_b
67: where question_code = x_question_code);
68: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);
69:
70: INSERT INTO MSC_QUESTIONS_TL(
71: QUESTION_ID
72: ,LANGUAGE

Line 103: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));

99: from msc_questions_b
100: where question_code = x_question_code)
101: and language = x_lang_code);
102:
103: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));
104: ELSIF (x_mode = 2) THEN -- copy mode
105: SELECT msc_questions_s.nextval
106: INTO x_question_id
107: FROM dual;

Line 108: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));

104: ELSIF (x_mode = 2) THEN -- copy mode
105: SELECT msc_questions_s.nextval
106: INTO x_question_id
107: FROM dual;
108: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
109:
110: INSERT INTO MSC_QUESTIONS_B(
111: QUESTION_ID
112: ,ANSWER_ID

Line 137: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);

133: WHERE q.question_code = x_copy_question
134: AND not exists (select 'already exists'
135: from msc_questions_b
136: where question_code = x_question_code);
137: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);
138:
139: INSERT INTO MSC_QUESTIONS_TL(
140: QUESTION_ID
141: ,LANGUAGE

Line 176: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));

172: from msc_questions_b
173: where question_code = x_question_code)
174: and language = x_lang_code);
175:
176: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));
177: ELSIF (x_mode = 3) THEN -- update mode
178: update msc_questions_b
179: set package_name = x_package_name
180: where question_code = x_question_code;

Line 181: msc_util.msc_debug('Updated msc_questions_b:' || to_char(sql%rowcount) ||

177: ELSIF (x_mode = 3) THEN -- update mode
178: update msc_questions_b
179: set package_name = x_package_name
180: where question_code = x_question_code;
181: msc_util.msc_debug('Updated msc_questions_b:' || to_char(sql%rowcount) ||
182: ':'|| x_question_code ||'with package name value:' ||
183: x_package_name);
184:
185: update msc_questions_tl

Line 191: msc_util.msc_debug('Updated msc_questions_tl:' || to_char(sql%rowcount) ||

187: where question_id = (select question_id
188: from msc_questions_b
189: where question_code = x_question_code)
190: and language = x_lang_code;
191: msc_util.msc_debug('Updated msc_questions_tl:' || to_char(sql%rowcount) ||
192: ':' || x_question_code || 'with user question:' ||
193: x_question);
194: ELSIF (x_mode = 4) THEN -- delete mode
195: delete msc_questions_tl

Line 199: msc_util.msc_debug('Deleted msc_questions_tl:'|| to_char(sql%rowcount) ||

195: delete msc_questions_tl
196: where question_id = (select question_id
197: from msc_questions_b
198: where question_code = x_question_code);
199: msc_util.msc_debug('Deleted msc_questions_tl:'|| to_char(sql%rowcount) ||
200: ':' || x_question_code);
201:
202: delete msc_questions_b
203: where question_code = x_question_code;

Line 204: msc_util.msc_debug('Deleted msc_questions_b:'|| to_char(sql%rowcount) ||

200: ':' || x_question_code);
201:
202: delete msc_questions_b
203: where question_code = x_question_code;
204: msc_util.msc_debug('Deleted msc_questions_b:'|| to_char(sql%rowcount) ||
205: ':' || x_question_code);
206: END IF;
207: COMMIT WORK;
208: retcode := 0;