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.OKC_XPRT_QUESTION_PVT dependencies on OKC_API

Line 9: g_fnd_app CONSTANT VARCHAR2 (200) := okc_api.g_fnd_app;

5: := NVL (fnd_profile.VALUE ('AFLOG_ENABLED'), 'N');
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: g_fnd_app CONSTANT VARCHAR2 (200) := okc_api.g_fnd_app;
10: g_invalid_value CONSTANT VARCHAR2 (200) := okc_api.g_invalid_value;
11: g_col_name_token CONSTANT VARCHAR2 (200)
12: := okc_api.g_col_name_token;
13: ---------------------------------------------------------------------------

Line 10: g_invalid_value CONSTANT VARCHAR2 (200) := okc_api.g_invalid_value;

6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: g_fnd_app CONSTANT VARCHAR2 (200) := okc_api.g_fnd_app;
10: g_invalid_value CONSTANT VARCHAR2 (200) := okc_api.g_invalid_value;
11: g_col_name_token CONSTANT VARCHAR2 (200)
12: := okc_api.g_col_name_token;
13: ---------------------------------------------------------------------------
14: -- GLOBAL VARIABLES

Line 12: := okc_api.g_col_name_token;

8: ---------------------------------------------------------------------------
9: g_fnd_app CONSTANT VARCHAR2 (200) := okc_api.g_fnd_app;
10: g_invalid_value CONSTANT VARCHAR2 (200) := okc_api.g_invalid_value;
11: g_col_name_token CONSTANT VARCHAR2 (200)
12: := okc_api.g_col_name_token;
13: ---------------------------------------------------------------------------
14: -- GLOBAL VARIABLES
15: ---------------------------------------------------------------------------
16: g_pkg_name CONSTANT VARCHAR2 (200) := 'OKC_XPRT_QUESTION_PVT';

Line 17: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;

13: ---------------------------------------------------------------------------
14: -- GLOBAL VARIABLES
15: ---------------------------------------------------------------------------
16: g_pkg_name CONSTANT VARCHAR2 (200) := 'OKC_XPRT_QUESTION_PVT';
17: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;

Line 75: okc_api.set_message (p_app_name => g_app_name,

71:
72: IF p_question_type = 'Q'
73: THEN
74: x_return_status := g_ret_sts_error;
75: okc_api.set_message (p_app_name => g_app_name,
76: p_msg_name => 'OKC_XPRT_DUP_QST_NAME'
77: );
78: RETURN;
79: ELSE

Line 81: okc_api.set_message (p_app_name => g_app_name,

77: );
78: RETURN;
79: ELSE
80: x_return_status := g_ret_sts_error;
81: okc_api.set_message (p_app_name => g_app_name,
82: p_msg_name => 'OKC_XPRT_DUP_CON_NAME'
83: );
84: RETURN;
85: END IF;

Line 93: okc_api.set_message (p_app_name => g_app_name,

89: EXCEPTION
90: WHEN OTHERS
91: THEN
92: x_return_status := g_ret_sts_unexp_error;
93: okc_api.set_message (p_app_name => g_app_name,
94: p_msg_name => g_unexpected_error,
95: p_token1 => g_sqlcode_token,
96: p_token1_value => SQLCODE,
97: p_token2 => g_sqlerrm_token,

Line 135: okc_api.set_message (p_app_name => g_app_name,

131: IF NVL (l_validate_flag, 'Y') = 'X'
132: THEN
133: x_return_status := g_ret_sts_error;
134:
135: okc_api.set_message (p_app_name => g_app_name,
136: p_msg_name => 'OKC_XPRT_DUP_QST_PROMPT'
137: );
138: RETURN;
139: END IF;

Line 146: okc_api.set_message (p_app_name => g_app_name,

142: EXCEPTION
143: WHEN OTHERS
144: THEN
145: x_return_status := g_ret_sts_unexp_error;
146: okc_api.set_message (p_app_name => g_app_name,
147: p_msg_name => g_unexpected_error,
148: p_token1 => g_sqlcode_token,
149: p_token1_value => SQLCODE,
150: p_token2 => g_sqlerrm_token,

Line 163: IF p_xprt_question_rec.QN_CONST_id = okc_api.g_miss_num

159: )
160: IS
161: BEGIN
162:
163: IF p_xprt_question_rec.QN_CONST_id = okc_api.g_miss_num
164: THEN
165: p_xprt_question_rec.QN_CONST_id := NULL;
166: END IF;
167:

Line 169: IF p_xprt_question_rec.QN_CONST_type = okc_api.g_miss_char

165: p_xprt_question_rec.QN_CONST_id := NULL;
166: END IF;
167:
168:
169: IF p_xprt_question_rec.QN_CONST_type = okc_api.g_miss_char
170: THEN
171: p_xprt_question_rec.QN_CONST_type := NULL;
172: END IF;
173:

Line 174: IF p_xprt_question_rec.QN_CONST_intent = okc_api.g_miss_char

170: THEN
171: p_xprt_question_rec.QN_CONST_type := NULL;
172: END IF;
173:
174: IF p_xprt_question_rec.QN_CONST_intent = okc_api.g_miss_char
175: THEN
176: p_xprt_question_rec.QN_CONST_intent := NULL;
177: END IF;
178:

Line 179: IF (p_xprt_question_rec.disabled_flag = okc_api.g_miss_char)

175: THEN
176: p_xprt_question_rec.QN_CONST_intent := NULL;
177: END IF;
178:
179: IF (p_xprt_question_rec.disabled_flag = okc_api.g_miss_char)
180: THEN
181: p_xprt_question_rec.disabled_flag := 'N';
182: END IF;
183:

Line 185: IF p_xprt_question_rec.question_datatype = okc_api.g_miss_char

181: p_xprt_question_rec.disabled_flag := 'N';
182: END IF;
183:
184:
185: IF p_xprt_question_rec.question_datatype = okc_api.g_miss_char
186: THEN
187: p_xprt_question_rec.question_datatype := NULL;
188: END IF;
189:

Line 206: IF p_xprt_question_rec.value_set_name = okc_api.g_miss_char THEN

202: THEN
203: p_xprt_question_rec.value_set_name := NULL;
204: END IF;
205:
206: IF p_xprt_question_rec.value_set_name = okc_api.g_miss_char THEN
207: p_xprt_question_rec.value_set_name := NULL;
208: END IF;
209:
210:

Line 211: IF p_xprt_question_rec.default_value = okc_api.g_miss_num

207: p_xprt_question_rec.value_set_name := NULL;
208: END IF;
209:
210:
211: IF p_xprt_question_rec.default_value = okc_api.g_miss_num
212: OR p_xprt_question_rec.QN_CONST_type = 'Q'
213: THEN
214: p_xprt_question_rec.default_value := NULL;
215: END IF;

Line 217: IF p_xprt_question_rec.minimum_value = okc_api.g_miss_num

213: THEN
214: p_xprt_question_rec.default_value := NULL;
215: END IF;
216:
217: IF p_xprt_question_rec.minimum_value = okc_api.g_miss_num
218:
219: THEN
220: p_xprt_question_rec.minimum_value := NULL;
221: END IF;

Line 223: IF p_xprt_question_rec.maximum_value = okc_api.g_miss_num

219: THEN
220: p_xprt_question_rec.minimum_value := NULL;
221: END IF;
222:
223: IF p_xprt_question_rec.maximum_value = okc_api.g_miss_num
224:
225: THEN
226: p_xprt_question_rec.maximum_value := NULL;
227: END IF;

Line 230: IF (p_xprt_question_rec.question_sync_flag = okc_api.g_miss_char)

226: p_xprt_question_rec.maximum_value := NULL;
227: END IF;
228:
229:
230: IF (p_xprt_question_rec.question_sync_flag = okc_api.g_miss_char)
231: THEN
232: IF (p_xprt_question_rec.qn_const_type = 'Q')
233: THEN
234: p_xprt_question_rec.question_sync_flag := 'Y';

Line 240: IF (p_xprt_question_rec.object_version_number = okc_api.g_miss_num)

236: p_xprt_question_rec.question_sync_flag := 'N';
237: END IF;
238: END IF;
239:
240: IF (p_xprt_question_rec.object_version_number = okc_api.g_miss_num)
241: THEN
242: p_xprt_question_rec.object_version_number := 1;
243: END IF;
244:

Line 246: IF p_xprt_question_rec.created_by = okc_api.g_miss_num

242: p_xprt_question_rec.object_version_number := 1;
243: END IF;
244:
245: -- Default who columns
246: IF p_xprt_question_rec.created_by = okc_api.g_miss_num
247: THEN
248: p_xprt_question_rec.created_by := fnd_global.user_id;
249: END IF;
250:

Line 251: IF p_xprt_question_rec.creation_date = okc_api.g_miss_date

247: THEN
248: p_xprt_question_rec.created_by := fnd_global.user_id;
249: END IF;
250:
251: IF p_xprt_question_rec.creation_date = okc_api.g_miss_date
252: THEN
253: p_xprt_question_rec.creation_date := SYSDATE;
254: END IF;
255:

Line 287: IF (p_xprt_question_rec.source_lang = okc_api.g_miss_char)

283: p_xprt_question_rec.program_application_id :=
284: fnd_global.prog_appl_id;
285: END IF;
286:
287: IF (p_xprt_question_rec.source_lang = okc_api.g_miss_char)
288: THEN
289: p_xprt_question_rec.source_lang := USERENV ('LANG');
290: END IF;
291:

Line 292: IF p_xprt_question_rec.QN_CONST_name = okc_api.g_miss_char

288: THEN
289: p_xprt_question_rec.source_lang := USERENV ('LANG');
290: END IF;
291:
292: IF p_xprt_question_rec.QN_CONST_name = okc_api.g_miss_char
293: THEN
294: p_xprt_question_rec.QN_CONST_name := NULL;
295: END IF;
296:

Line 297: IF p_xprt_question_rec.lang = okc_api.g_miss_char

293: THEN
294: p_xprt_question_rec.QN_CONST_name := NULL;
295: END IF;
296:
297: IF p_xprt_question_rec.lang = okc_api.g_miss_char
298: THEN
299: p_xprt_question_rec.lang := NULL;
300: END IF;
301:

Line 302: IF p_xprt_question_rec.source_lang = okc_api.g_miss_char

298: THEN
299: p_xprt_question_rec.lang := NULL;
300: END IF;
301:
302: IF p_xprt_question_rec.source_lang = okc_api.g_miss_char
303: THEN
304: p_xprt_question_rec.source_lang := NULL;
305: END IF;
306:

Line 307: IF p_xprt_question_rec.description = okc_api.g_miss_char

303: THEN
304: p_xprt_question_rec.source_lang := NULL;
305: END IF;
306:
307: IF p_xprt_question_rec.description = okc_api.g_miss_char
308: THEN
309: p_xprt_question_rec.description := NULL;
310: END IF;
311:

Line 312: IF p_xprt_question_rec.prompt = okc_api.g_miss_char

308: THEN
309: p_xprt_question_rec.description := NULL;
310: END IF;
311:
312: IF p_xprt_question_rec.prompt = okc_api.g_miss_char
313: THEN
314: p_xprt_question_rec.prompt := NULL;
315: END IF;
316:

Line 323: okc_api.set_message (p_app_name => g_app_name,

319: EXCEPTION
320: WHEN OTHERS
321: THEN
322: x_returns_status := g_ret_sts_unexp_error;
323: okc_api.set_message (p_app_name => g_app_name,
324: p_msg_name => g_unexpected_error,
325: p_token1 => g_sqlcode_token,
326: p_token1_value => SQLCODE,
327: p_token2 => g_sqlerrm_token,

Line 380: okc_api.set_message (p_app_name => g_app_name,

376: **/
377: IF p_xprt_question_rec.QN_CONST_type IS NULL
378: THEN
379: x_error_count := x_error_count + 1;
380: okc_api.set_message (p_app_name => g_app_name,
381: p_msg_name => l_okc_i_not_null,
382: p_token1 => l_field,
383: p_token1_value => 'QUESTION_TYPE'
384: );

Line 398: okc_api.set_message (p_app_name => g_app_name,

394:
395: IF NVL (l_validate_flag, 'Y') <> 'X'
396: THEN
397: x_error_count := x_error_count + 1;
398: okc_api.set_message (p_app_name => g_app_name,
399: p_msg_name => l_okc_i_invalid_value,
400: p_token1 => l_field,
401: p_token1_value => 'QUESTION_TYPE'
402: );

Line 412: okc_api.set_message (p_app_name => g_app_name,

408: **/
409: IF p_xprt_question_rec.QN_CONST_intent IS NULL
410: THEN
411: x_error_count := x_error_count + 1;
412: okc_api.set_message (p_app_name => g_app_name,
413: p_msg_name => l_OKC_I_NOT_NULL,
414: p_token1 => l_field,
415: p_token1_value => 'INTENT'
416: );

Line 421: okc_api.set_message (p_app_name => g_app_name,

417: ELSE
418: IF p_xprt_question_rec.QN_CONST_intent NOT IN ('B', 'S')
419: THEN
420: x_error_count := x_error_count + 1;
421: okc_api.set_message (p_app_name => g_app_name,
422: p_msg_name => l_okc_i_invalid_value,
423: p_token1 => l_field,
424: p_token1_value => 'INTENT'
425: );

Line 432: okc_api.set_message (p_app_name => g_app_name,

428:
429: IF p_xprt_question_rec.disabled_flag IS NULL
430: THEN
431: x_error_count := x_error_count + 1;
432: okc_api.set_message (p_app_name => g_app_name,
433: p_msg_name => l_okc_i_not_null,
434: p_token1 => l_field,
435: p_token1_value => 'DISABLED_FLAG'
436: );

Line 442: okc_api.set_message (p_app_name => g_app_name,

438:
439: IF p_xprt_question_rec.question_sync_flag IS NULL
440: THEN
441: x_error_count := x_error_count + 1;
442: okc_api.set_message (p_app_name => g_app_name,
443: p_msg_name => l_okc_i_not_null,
444: p_token1 => l_field,
445: p_token1_value => 'QUESTION_SYNC_FLAG'
446: );

Line 452: okc_api.set_message (p_app_name => g_app_name,

448:
449: IF p_xprt_question_rec.object_version_number IS NULL
450: THEN
451: x_error_count := x_error_count + 1;
452: okc_api.set_message (p_app_name => g_app_name,
453: p_msg_name => l_okc_i_not_null,
454: p_token1 => l_field,
455: p_token1_value => 'OBJECT_VERSION_NUMBER'
456: );

Line 462: okc_api.set_message (p_app_name => g_app_name,

458:
459: IF p_xprt_question_rec.question_datatype IS NULL
460: THEN
461: x_error_count := x_error_count + 1;
462: okc_api.set_message (p_app_name => g_app_name,
463: p_msg_name => l_okc_i_not_null,
464: p_token1 => l_field,
465: p_token1_value => 'RESPONSE_TYPE'
466: );

Line 472: okc_api.set_message (p_app_name => g_app_name,

468:
469: IF p_xprt_question_rec.QN_CONST_name IS NULL
470: THEN
471: x_error_count := x_error_count + 1;
472: okc_api.set_message (p_app_name => g_app_name,
473: p_msg_name => l_OKC_I_NOT_NULL,
474: p_token1 => l_field,
475: p_token1_value => 'NAME'
476: );

Line 482: okc_api.set_message (p_app_name => g_app_name,

478:
479: IF p_xprt_question_rec.source_lang IS NULL
480: THEN
481: x_error_count := x_error_count + 1;
482: okc_api.set_message (p_app_name => g_app_name,
483: p_msg_name => l_okc_i_not_null,
484: p_token1 => l_field,
485: p_token1_value => 'SOURCE_LANG'
486: );

Line 518: okc_api.set_message (p_app_name => g_app_name,

514: -- Check Question Prompt
515: IF p_xprt_question_rec.prompt IS NULL
516: THEN
517: x_error_count := x_error_count + 1;
518: okc_api.set_message (p_app_name => g_app_name,
519: p_msg_name => l_okc_i_not_null,
520: p_token1 => l_field,
521: p_token1_value => 'QUESTION_PROMPT'
522: );

Line 561: okc_api.set_message (p_app_name => g_app_name,

557:
558: IF NVL (l_validate_flag, 'Y') <> 'X'
559: THEN
560: x_error_count := x_error_count + 1;
561: okc_api.set_message (p_app_name => g_app_name,
562: p_msg_name => l_okc_i_invalid_value,
563: p_token1 => l_field,
564: p_token1_value => 'RESPONSE_TYPE'
565: );

Line 572: okc_api.set_message (p_app_name => g_app_name,

568: THEN
569: IF p_xprt_question_rec.value_set_name IS NULL
570: THEN
571: x_error_count := x_error_count + 1;
572: okc_api.set_message (p_app_name => g_app_name,
573: p_msg_name => l_okc_i_not_null,
574: p_token1 => l_field,
575: p_token1_value => 'VALUE_SET_NAME'
576: );

Line 590: okc_api.set_message

586:
587: IF NVL (l_validate_flag, 'Y') <> 'X'
588: THEN
589: x_error_count := x_error_count + 1;
590: okc_api.set_message
591: (p_app_name => g_app_name,
592: p_msg_name => l_okc_i_invalid_value,
593: p_token1 => l_field,
594: p_token1_value => 'VALUE_SET_NAME'

Line 606: okc_api.set_message (p_app_name => g_app_name,

602: THEN
603: IF p_xprt_question_rec.DEFAULT_VALUE IS NULL
604: THEN
605: x_error_count := x_error_count + 1;
606: okc_api.set_message (p_app_name => g_app_name,
607: p_msg_name => l_okc_i_not_null,
608: p_token1 => l_field,
609: p_token1_value => 'DEFAULT_VALUE'
610: );

Line 622: okc_api.set_message (p_app_name => g_app_name,

618: EXCEPTION
619: WHEN OTHERS
620: THEN
621: x_return_status := g_ret_sts_unexp_error;
622: okc_api.set_message (p_app_name => g_app_name,
623: p_msg_name => g_unexpected_error,
624: p_token1 => g_sqlcode_token,
625: p_token1_value => SQLCODE,
626: p_token2 => g_sqlerrm_token,

Line 713: okc_api.set_message (p_app_name => g_app_name,

709: EXCEPTION
710: WHEN OTHERS
711: THEN
712: x_return_status := g_ret_sts_unexp_error;
713: okc_api.set_message (p_app_name => g_app_name,
714: p_msg_name => g_unexpected_error,
715: p_token1 => g_sqlcode_token,
716: p_token1_value => SQLCODE,
717: p_token2 => g_sqlerrm_token,

Line 764: okc_api.set_message(p_app_name => g_app_name,

760:
761: fnd_msg_pub.initialize;
762:
763: IF p_action = 'CREATE' THEN
764: okc_api.set_message(p_app_name => g_app_name,
765: p_msg_name => 'OKC_I_CREATION_ENTITY_FAIL',
766: p_token1 => 'ENTITY',
767: p_token1_value => l_entity
768: );

Line 770: okc_api.set_message(p_app_name => g_app_name,

766: p_token1 => 'ENTITY',
767: p_token1_value => l_entity
768: );
769: ELSIF p_action ='UPDATE' THEN
770: okc_api.set_message(p_app_name => g_app_name,
771: p_msg_name => 'OKC_I_UPDATE_ENTITY_FAIL',
772: p_token1 => 'ENTITY',
773: p_token1_value => l_entity
774: );

Line 777: okc_api.set_message(p_app_name => g_app_name,

773: p_token1_value => l_entity
774: );
775: END IF;
776:
777: okc_api.set_message(p_app_name => g_app_name,
778: p_msg_name => 'OKC_I_ERROR_PROCEDURE',
779: p_token1 => 'PROCEDURE',
780: p_token1_value => p_process
781: );

Line 910: okc_api.set_message (p_app_name => g_app_name,

906: EXCEPTION
907: WHEN OTHERS
908: THEN
909: x_return_status := g_ret_sts_unexp_error;
910: okc_api.set_message (p_app_name => g_app_name,
911: p_msg_name => g_unexpected_error,
912: p_token1 => g_sqlcode_token,
913: p_token1_value => SQLCODE,
914: p_token2 => g_sqlerrm_token,

Line 992: Decode(p_xprt_update_question_rec.lang,OKC_API.G_MISS_CHAR, UserEnv('lang'),

988: INTO l_question_name, l_lang, l_source_lang, l_description, l_prompt
989: FROM okc_xprt_questions_tl
990: WHERE question_id = p_xprt_update_question_rec.qn_const_id
991: AND language =
992: Decode(p_xprt_update_question_rec.lang,OKC_API.G_MISS_CHAR, UserEnv('lang'),
993: NULL,UserEnv('lang')
994: ,p_xprt_update_question_rec.lang)
995: AND question_type = p_xprt_update_question_rec.qn_const_type
996: ;

Line 1001: okc_api.set_message

997:
998: EXCEPTION
999: WHEN No_Data_Found THEN
1000: x_return_status := g_ret_sts_error;
1001: okc_api.set_message
1002: (p_app_name => g_app_name,
1003: p_msg_name => l_okc_i_invalid_value,
1004: p_token1 => l_field,
1005: p_token1_value => 'QUESTION_ID'

Line 1014: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1010:
1011: WHEN OTHERS THEN
1012: x_return_status := g_ret_sts_unexp_error;
1013: -- x_msg_count := 1;
1014: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1015: p_msg_name => G_UNEXPECTED_ERROR,
1016: p_token1 => G_SQLCODE_TOKEN,
1017: p_token1_value => sqlcode,
1018: p_token2 => G_SQLERRM_TOKEN,

Line 1026: ( p_xprt_update_question_rec.qn_const_type <> OKC_API.G_MISS_CHAR

1022: RETURN;
1023: END;
1024:
1025: IF
1026: ( p_xprt_update_question_rec.qn_const_type <> OKC_API.G_MISS_CHAR
1027: AND p_xprt_update_question_rec.qn_const_type <> l_question_type)
1028: OR p_xprt_update_question_rec.qn_const_type IS NULL
1029: THEN
1030: x_return_status := G_RET_STS_ERROR;

Line 1031: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1027: AND p_xprt_update_question_rec.qn_const_type <> l_question_type)
1028: OR p_xprt_update_question_rec.qn_const_type IS NULL
1029: THEN
1030: x_return_status := G_RET_STS_ERROR;
1031: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1032: p_msg_name => 'OKC_I_NO_CHANGE',
1033: p_token1 => 'FIELD',
1034: p_token1_value => 'QUESTION_TYPE' );
1035: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

Line 1061: (p_xprt_update_question_rec.qn_const_intent <> OKC_API.G_MISS_CHAR

1057: -- Question/Constant Used in a Rule
1058:
1059: IF p_xprt_update_question_rec.qn_const_intent IS NULL
1060: OR
1061: (p_xprt_update_question_rec.qn_const_intent <> OKC_API.G_MISS_CHAR
1062: AND
1063: p_xprt_update_question_rec.qn_const_intent <> l_question_intent
1064: )
1065: THEN

Line 1067: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1063: p_xprt_update_question_rec.qn_const_intent <> l_question_intent
1064: )
1065: THEN
1066: l_return_status := G_RET_STS_ERROR;
1067: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1068: p_msg_name => 'OKC_I_QC_USED_IN_RULE',
1069: p_token1 => 'ENTITY' ,
1070: p_token1_value => l_entity,
1071: p_token2 => 'FIELD',

Line 1077: (p_xprt_update_question_rec.qn_const_name <> OKC_API.G_MISS_CHAR AND

1073: END IF;
1074:
1075: IF p_xprt_update_question_rec.qn_const_name IS NULL
1076: OR
1077: (p_xprt_update_question_rec.qn_const_name <> OKC_API.G_MISS_CHAR AND
1078: p_xprt_update_question_rec.qn_const_name <> l_question_name) THEN
1079: l_return_status := G_RET_STS_ERROR;
1080: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1081: p_msg_name => 'OKC_I_QC_USED_IN_RULE',

Line 1080: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1076: OR
1077: (p_xprt_update_question_rec.qn_const_name <> OKC_API.G_MISS_CHAR AND
1078: p_xprt_update_question_rec.qn_const_name <> l_question_name) THEN
1079: l_return_status := G_RET_STS_ERROR;
1080: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1081: p_msg_name => 'OKC_I_QC_USED_IN_RULE',
1082: p_token1 => 'ENTITY' ,
1083: p_token1_value => l_entity,
1084: p_token2 => 'FIELD',

Line 1095: OKC_API.G_MISS_CHAR AND p_xprt_update_question_rec.question_datatype <>

1091: -- VALIDATE Response Type/ Value Set
1092: IF p_xprt_update_question_rec.question_datatype IS NULL
1093: OR
1094: (p_xprt_update_question_rec.question_datatype <>
1095: OKC_API.G_MISS_CHAR AND p_xprt_update_question_rec.question_datatype <>
1096: l_question_datatype)
1097:
1098: THEN
1099: l_return_status := G_RET_STS_ERROR;

Line 1100: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1096: l_question_datatype)
1097:
1098: THEN
1099: l_return_status := G_RET_STS_ERROR;
1100: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1101: p_msg_name => 'OKC_I_QC_USED_IN_RULE',
1102: p_token1 => 'ENTITY' ,
1103: p_token1_value => l_entity,
1104: p_token2 => 'FIELD',

Line 1111: OKC_API.G_MISS_CHAR AND

1107: END IF;
1108:
1109: IF p_xprt_update_question_rec.value_set_name IS NULL OR
1110: (p_xprt_update_question_rec.value_set_name <>
1111: OKC_API.G_MISS_CHAR AND
1112: p_xprt_update_question_rec.value_set_name <> l_value_set_name) THEN
1113: l_return_status := G_RET_STS_ERROR;
1114: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1115: p_msg_name => 'OKC_I_QC_USED_IN_RULE',

Line 1114: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1110: (p_xprt_update_question_rec.value_set_name <>
1111: OKC_API.G_MISS_CHAR AND
1112: p_xprt_update_question_rec.value_set_name <> l_value_set_name) THEN
1113: l_return_status := G_RET_STS_ERROR;
1114: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1115: p_msg_name => 'OKC_I_QC_USED_IN_RULE',
1116: p_token1 => 'ENTITY' ,
1117: p_token1_value => l_entity,
1118: p_token2 => 'FIELD',

Line 1139: (p_xprt_update_question_rec.qn_const_name <> OKC_API.G_MISS_CHAR

1135: -- Record whether intent or question/constant name is changed
1136: -- If changed need to validate for duplicates
1137: IF p_xprt_update_question_rec.qn_const_name IS NULL
1138: OR
1139: (p_xprt_update_question_rec.qn_const_name <> OKC_API.G_MISS_CHAR
1140: AND
1141: p_xprt_update_question_rec.qn_const_name <> l_question_name) THEN
1142: l_val_question_name_flag := 'Y';
1143: END IF;

Line 1152: IF p_xprt_update_question_rec.qn_const_type = OKC_API.G_MISS_CHAR THEN

1148: p_xprt_update_question_rec.last_updated_by := fnd_global.user_id;
1149: p_xprt_update_question_rec.last_update_date := SYSDATE;
1150: p_xprt_update_question_rec.last_update_login := fnd_global.login_id;
1151:
1152: IF p_xprt_update_question_rec.qn_const_type = OKC_API.G_MISS_CHAR THEN
1153: p_xprt_update_question_rec.qn_const_type := l_question_type;
1154: END IF;
1155:
1156: IF p_xprt_update_question_rec.qn_const_type = 'Q' THEN

Line 1162: IF p_xprt_update_question_rec.qn_const_intent = OKC_API.G_MISS_CHAR THEN

1158: ELSE
1159: p_xprt_update_question_rec.question_sync_flag := 'N';
1160: END IF;
1161:
1162: IF p_xprt_update_question_rec.qn_const_intent = OKC_API.G_MISS_CHAR THEN
1163: p_xprt_update_question_rec.qn_const_intent := l_question_intent;
1164: END IF;
1165:
1166: IF p_xprt_update_question_rec.disabled_flag = OKC_API.G_MISS_CHAR THEN

Line 1166: IF p_xprt_update_question_rec.disabled_flag = OKC_API.G_MISS_CHAR THEN

1162: IF p_xprt_update_question_rec.qn_const_intent = OKC_API.G_MISS_CHAR THEN
1163: p_xprt_update_question_rec.qn_const_intent := l_question_intent;
1164: END IF;
1165:
1166: IF p_xprt_update_question_rec.disabled_flag = OKC_API.G_MISS_CHAR THEN
1167: p_xprt_update_question_rec.disabled_flag := l_disabled_flag;
1168: END IF;
1169:
1170: IF p_xprt_update_question_rec.qn_const_type = 'C' THEN

Line 1175: IF p_xprt_update_question_rec.question_datatype = OKC_API.G_MISS_CHAR THEN

1171: p_xprt_update_question_rec.question_datatype := 'N';
1172: END IF;
1173:
1174:
1175: IF p_xprt_update_question_rec.question_datatype = OKC_API.G_MISS_CHAR THEN
1176: p_xprt_update_question_rec.question_datatype := l_question_datatype;
1177: ELSE
1178: IF p_xprt_update_question_rec.question_datatype = 'B' THEN
1179: p_xprt_update_question_rec.value_set_name := 'OKC_XPRT_YES_NO';

Line 1185: IF p_xprt_update_question_rec.value_set_name = OKC_API.G_MISS_CHAR THEN

1181: p_xprt_update_question_rec.value_set_name := NULL;
1182: END IF;
1183: END IF;
1184:
1185: IF p_xprt_update_question_rec.value_set_name = OKC_API.G_MISS_CHAR THEN
1186: p_xprt_update_question_rec.value_set_name := l_value_set_name;
1187: END IF;
1188:
1189: IF p_xprt_update_question_rec.default_value = OKC_API.G_MISS_NUM THEN

Line 1189: IF p_xprt_update_question_rec.default_value = OKC_API.G_MISS_NUM THEN

1185: IF p_xprt_update_question_rec.value_set_name = OKC_API.G_MISS_CHAR THEN
1186: p_xprt_update_question_rec.value_set_name := l_value_set_name;
1187: END IF;
1188:
1189: IF p_xprt_update_question_rec.default_value = OKC_API.G_MISS_NUM THEN
1190: p_xprt_update_question_rec.default_value := l_default_value;
1191: END IF;
1192:
1193: IF p_xprt_update_question_rec.qn_const_name = OKC_API.G_MISS_CHAR THEN

Line 1193: IF p_xprt_update_question_rec.qn_const_name = OKC_API.G_MISS_CHAR THEN

1189: IF p_xprt_update_question_rec.default_value = OKC_API.G_MISS_NUM THEN
1190: p_xprt_update_question_rec.default_value := l_default_value;
1191: END IF;
1192:
1193: IF p_xprt_update_question_rec.qn_const_name = OKC_API.G_MISS_CHAR THEN
1194: p_xprt_update_question_rec.qn_const_name := l_question_name;
1195: END IF;
1196:
1197: IF p_xprt_update_question_rec.lang = OKC_API.G_MISS_CHAR THEN

Line 1197: IF p_xprt_update_question_rec.lang = OKC_API.G_MISS_CHAR THEN

1193: IF p_xprt_update_question_rec.qn_const_name = OKC_API.G_MISS_CHAR THEN
1194: p_xprt_update_question_rec.qn_const_name := l_question_name;
1195: END IF;
1196:
1197: IF p_xprt_update_question_rec.lang = OKC_API.G_MISS_CHAR THEN
1198: p_xprt_update_question_rec.lang := l_lang;
1199: END IF;
1200:
1201: IF p_xprt_update_question_rec.source_lang = OKC_API.G_MISS_CHAR THEN

Line 1201: IF p_xprt_update_question_rec.source_lang = OKC_API.G_MISS_CHAR THEN

1197: IF p_xprt_update_question_rec.lang = OKC_API.G_MISS_CHAR THEN
1198: p_xprt_update_question_rec.lang := l_lang;
1199: END IF;
1200:
1201: IF p_xprt_update_question_rec.source_lang = OKC_API.G_MISS_CHAR THEN
1202: p_xprt_update_question_rec.source_lang := l_source_lang;
1203: END IF;
1204:
1205:

Line 1206: IF p_xprt_update_question_rec.description = OKC_API.G_MISS_CHAR THEN

1202: p_xprt_update_question_rec.source_lang := l_source_lang;
1203: END IF;
1204:
1205:
1206: IF p_xprt_update_question_rec.description = OKC_API.G_MISS_CHAR THEN
1207: p_xprt_update_question_rec.description := l_description;
1208: END IF;
1209:
1210: IF p_xprt_update_question_rec.prompt = OKC_API.G_MISS_CHAR THEN

Line 1210: IF p_xprt_update_question_rec.prompt = OKC_API.G_MISS_CHAR THEN

1206: IF p_xprt_update_question_rec.description = OKC_API.G_MISS_CHAR THEN
1207: p_xprt_update_question_rec.description := l_description;
1208: END IF;
1209:
1210: IF p_xprt_update_question_rec.prompt = OKC_API.G_MISS_CHAR THEN
1211: p_xprt_update_question_rec.prompt := l_prompt;
1212: END IF;
1213:
1214:

Line 1266: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: x_return_status := g_ret_sts_unexp_error;
1265:
1266: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1267: p_msg_name => G_UNEXPECTED_ERROR,
1268: p_token1 => G_SQLCODE_TOKEN,
1269: p_token1_value => sqlcode,
1270: p_token2 => G_SQLERRM_TOKEN,