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.JTF_IH_PUB_PS dependencies on JTF_IH_CORE_UTIL_PVT

Line 27: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time),

23: IF((p_start_date_time IS NOT NULL) AND (p_end_date_time IS NOT NULL) AND
24: (p_end_date_time - p_start_date_time < 0) )THEN
25: ----DBMS_OUTPUT.PUT_LINE('end_date is less than start_date in JTF_IH_PUB_PS.Validate_StartEnd_Date');
26: x_return_status := fnd_api.g_ret_sts_error;
27: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time),
28: 'end_date_time');
29: END IF;
30: END Validate_StartEnd_Date;
31:

Line 64: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.handler_id),

60: FROM fnd_application
61: WHERE application_id = p_int_val_rec.handler_id;
62: IF (l_count <= 0) THEN
63: x_return_status := fnd_api.g_ret_sts_error;
64: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.handler_id),
65: 'Handler_id');
66: RETURN;
67: END IF;
68: END;

Line 71: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.handler_id),

67: END IF;
68: END;
69: ELSE
70: x_return_status := fnd_api.g_ret_sts_error;
71: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.handler_id),
72: 'handler_id');
73: RETURN;
74: END IF;
75: ----DBMS_OUTPUT.PUT_LINE('PAST Validate handler_id in JTF_IH_PUB_PS.Validate_Interaction_Record');

Line 85: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.party_id),

81: FROM hz_parties
82: WHERE party_id = p_int_val_rec.party_id;
83: IF (l_count <= 0) THEN
84: x_return_status := fnd_api.g_ret_sts_error;
85: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.party_id),
86: 'party_id');
87: RETURN;
88: END IF;
89: END;

Line 92: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.party_id),

88: END IF;
89: END;
90: ELSE
91: x_return_status := fnd_api.g_ret_sts_error;
92: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.party_id),
93: 'party_id');
94: RETURN;
95: END IF;
96: ----DBMS_OUTPUT.PUT_LINE('PAST Validate party_id in JTF_IH_PUB_PS.Validate_Interaction_Record');

Line 106: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),

102: FROM jtf_rs_resource_extns
103: WHERE resource_id = p_int_val_rec.resource_id;
104: IF (l_count <= 0) THEN
105: x_return_status := fnd_api.g_ret_sts_error;
106: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),
107: 'resource_id');
108: RETURN;
109: END IF;
110: END;

Line 113: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),

109: END IF;
110: END;
111: ELSE
112: x_return_status := fnd_api.g_ret_sts_error;
113: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),
114: 'resource_id');
115: RETURN;
116: END IF;
117: ----DBMS_OUTPUT.PUT_LINE('PAST Validate resource_id in JTF_IH_PUB_PS.Validate_Interaction_Record');

Line 127: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.outcome_id),

123: FROM jtf_ih_outcomes_B
124: WHERE outcome_id = p_int_val_rec.outcome_id;
125: IF (l_count <= 0) THEN
126: x_return_status := fnd_api.g_ret_sts_error;
127: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.outcome_id),
128: 'outcome_id');
129: RETURN;
130: END IF;
131:

Line 144: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.result_id),

140: FROM jtf_ih_results_B
141: WHERE result_id = p_int_val_rec.result_id;
142: IF (l_count <= 0) THEN
143: x_return_status := fnd_api.g_ret_sts_error;
144: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.result_id),
145: 'result_id');
146: RETURN;
147: END IF;
148:

Line 161: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.reason_id),

157: FROM jtf_ih_reasons_B
158: WHERE reason_id = p_int_val_rec.reason_id;
159: IF (l_count <= 0) THEN
160: x_return_status := fnd_api.g_ret_sts_error;
161: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.reason_id),
162: 'reason_id');
163: RETURN;
164: END IF;
165: END;

Line 177: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.script_id),

173: FROM jtf_ih_scripts
174: WHERE script_id = p_int_val_rec.script_id;
175: IF (l_count <= 0) THEN
176: x_return_status := fnd_api.g_ret_sts_error;
177: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.script_id),
178: 'Script_id');
179: RETURN;
180: END IF;
181: END;

Line 194: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.source_code_id),

190: FROM ams_source_codes
191: WHERE source_code_id = p_int_val_rec.source_code_id;
192: IF (l_count <= 0) THEN
193: x_return_status := fnd_api.g_ret_sts_error;
194: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.source_code_id),
195: 'source_code_id');
196: RETURN;
197: END IF;
198: END;

Line 210: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.parent_id),

206: FROM jtf_ih_interactions
207: WHERE interaction_id = p_int_val_rec.parent_id;
208: IF (l_count <= 0) THEN
209: x_return_status := fnd_api.g_ret_sts_error;
210: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.parent_id),
211: 'interaction_id');
212: RETURN;
213: END IF;
214: END;

Line 236: jtf_ih_core_util_pvt.validate_desc_flex

232: (p_int_val_rec.attribute13 <> fnd_api.g_miss_char) OR
233: (p_int_val_rec.attribute14 <> fnd_api.g_miss_char) OR
234: (p_int_val_rec.attribute15 <> fnd_api.g_miss_char) OR
235: (p_int_val_rec.attribute_category <> fnd_api.g_miss_char)) THEN
236: jtf_ih_core_util_pvt.validate_desc_flex
237: ( p_api_name => p_api_name,
238: p_desc_flex_name => 'JTF_IH',
239: p_column_name1 => 'ATTRIBUTE1',
240: p_column_name2 => 'ATTRIBUTE2',

Line 393: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),

389: FROM jtf_ih_interactions
390: WHERE interaction_id = p_act_val_rec.interaction_id;
391: IF (l_count <= 0) THEN
392: x_return_status := fnd_api.g_ret_sts_error;
393: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),
394: 'interaction_id');
395: RETURN;
396: END IF;
397: END;

Line 400: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),

396: END IF;
397: END;
398: ELSE
399: x_return_status := fnd_api.g_ret_sts_error;
400: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),
401: 'interaction_id');
402: RETURN;
403: END IF;
404: ----DBMS_OUTPUT.PUT_LINE('PAST Validate interaction_id in JTF_IH_PUB_PS.Validate_Activity_Record');

Line 414: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.action_item_id),

410: FROM jtf_ih_action_items_b
411: WHERE action_item_id = p_act_val_rec.action_item_id;
412: IF (l_count <= 0) THEN
413: x_return_status := fnd_api.g_ret_sts_error;
414: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.action_item_id),
415: 'action_item_id');
416: RETURN;
417: END IF;
418: END;

Line 430: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.outcome_id),

426: FROM jtf_ih_outcomes_B
427: WHERE outcome_id = p_act_val_rec.outcome_id;
428: IF (l_count <= 0) THEN
429: x_return_status := fnd_api.g_ret_sts_error;
430: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.outcome_id),
431: 'outcome_id');
432: RETURN;
433: END IF;
434:

Line 448: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.action_id),

444: FROM jtf_ih_actions_b
445: WHERE action_id = p_act_val_rec.action_id;
446: IF (l_count <= 0) THEN
447: x_return_status := fnd_api.g_ret_sts_error;
448: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.action_id),
449: 'action_id');
450: RETURN;
451: END IF;
452: END;

Line 463: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.result_id),

459: FROM jtf_ih_results_B
460: WHERE result_id = p_act_val_rec.result_id;
461: IF (l_count <= 0) THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.result_id),
464: 'result_id');
465: RETURN;
466: END IF;
467:

Line 480: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.reason_id),

476: FROM jtf_ih_reasons_B
477: WHERE reason_id = p_act_val_rec.reason_id;
478: IF (l_count <= 0) THEN
479: x_return_status := fnd_api.g_ret_sts_error;
480: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.reason_id),
481: 'reason_id');
482: RETURN;
483: END IF;
484: END;

Line 497: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.source_code_id),

493: FROM ams_source_codes
494: WHERE source_code_id = p_act_val_rec.source_code_id;
495: IF (l_count <= 0) THEN
496: x_return_status := fnd_api.g_ret_sts_error;
497: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.source_code_id),
498: 'source_code_id');
499: RETURN;
500: END IF;
501: END;

Line 513: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.media_id),

509: FROM jtf_ih_media_items
510: WHERE media_id = p_act_val_rec.media_id;
511: IF (l_count <= 0) THEN
512: x_return_status := fnd_api.g_ret_sts_error;
513: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.media_id),
514: 'media_id');
515: RETURN;
516: END IF;
517: END;

Line 588: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_item_val.source_id),

584: FROM jtf_ih_sources
585: WHERE source_id = p_media_item_val.source_id;
586: IF (l_count <= 0) THEN
587: x_return_status := fnd_api.g_ret_sts_error;
588: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_item_val.source_id),
589: 'Source_id');
590: RETURN;
591: END IF;
592: ELSE

Line 594: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_item_val.source_id),

590: RETURN;
591: END IF;
592: ELSE
593: x_return_status := fnd_api.g_ret_sts_error;
594: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_item_val.source_id),
595: 'Source_id');
596: RETURN;
597: END IF;
598:

Line 601: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_item_val.media_item_type,

597: END IF;
598:
599: IF ((p_media_item_val.media_item_type IS NULL) OR (p_media_item_val.media_item_type = fnd_api.g_miss_char)) THEN
600: x_return_status := fnd_api.g_ret_sts_error;
601: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_item_val.media_item_type,
602: 'media_item_type');
603: RETURN;
604: END IF;
605:

Line 654: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.milcs_type_id),

650: l_count := 0;
651:
652: IF ((p_media_lc_rec.milcs_type_id IS NULL) OR (p_media_lc_rec.milcs_type_id = fnd_api.g_miss_num)) THEN
653: x_return_status := fnd_api.g_ret_sts_error;
654: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.milcs_type_id),
655: 'milcs_type_id');
656: RETURN;
657: END IF;
658: IF ((p_media_lc_rec.handler_id IS NOT NULL) AND (p_media_lc_rec.handler_id <> fnd_api.g_miss_num)) THEN

Line 664: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),

660: FROM fnd_application
661: WHERE application_id = p_media_lc_rec.handler_id;
662: IF (l_count <= 0) THEN
663: x_return_status := fnd_api.g_ret_sts_error;
664: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),
665: 'handler_id');
666: RETURN;
667: END IF;
668: ELSE

Line 670: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),

666: RETURN;
667: END IF;
668: ELSE
669: x_return_status := fnd_api.g_ret_sts_error;
670: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),
671: 'handler_id');
672: RETURN;
673: END IF;
674: l_count := 0;

Line 681: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.media_id),

677: FROM jtf_ih_media_items
678: WHERE media_id = p_media_lc_rec.media_id;
679: IF (l_count <= 0) THEN
680: x_return_status := fnd_api.g_ret_sts_error;
681: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.media_id),
682: 'media_id');
683: RETURN;
684: END IF;
685: ELSE

Line 687: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),

683: RETURN;
684: END IF;
685: ELSE
686: x_return_status := fnd_api.g_ret_sts_error;
687: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),
688: 'handler_id');
689: RETURN;
690: END IF;
691: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

Line 795: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

791: --
792: -- Validate user and login session IDs
793: --
794: IF (p_user_id IS NULL) THEN
795: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
796: RAISE fnd_api.g_exc_error;
797: ELSE
798: jtf_ih_core_util_pvt.validate_who_info
799: ( p_api_name => l_api_name_full,

Line 798: jtf_ih_core_util_pvt.validate_who_info

794: IF (p_user_id IS NULL) THEN
795: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
796: RAISE fnd_api.g_exc_error;
797: ELSE
798: jtf_ih_core_util_pvt.validate_who_info
799: ( p_api_name => l_api_name_full,
800: p_parameter_name_usr => 'p_user_id',
801: p_parameter_name_log => 'p_login_id',
802: p_user_id => p_user_id,

Line 1000: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

996: --
997: -- Validate user and login session IDs
998: --
999: IF (p_user_id IS NULL) THEN
1000: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1001: RAISE fnd_api.g_exc_error;
1002: ELSE
1003: jtf_ih_core_util_pvt.validate_who_info
1004: ( p_api_name => l_api_name_full,

Line 1003: jtf_ih_core_util_pvt.validate_who_info

999: IF (p_user_id IS NULL) THEN
1000: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1001: RAISE fnd_api.g_exc_error;
1002: ELSE
1003: jtf_ih_core_util_pvt.validate_who_info
1004: ( p_api_name => l_api_name_full,
1005: p_parameter_name_usr => 'p_user_id',
1006: p_parameter_name_log => 'p_login_id',
1007: p_user_id => p_user_id,

Line 1014: ----DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Create_MediaItem');

1010: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1011: RAISE fnd_api.g_exc_error;
1012: END IF;
1013: END IF;
1014: ----DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Create_MediaItem');
1015:
1016: Validate_Media_Item
1017: ( p_api_name => l_api_name_full,
1018: p_media_item_val => p_media_rec,

Line 1155: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

1151: --
1152: -- Validate user and login session IDs
1153: --
1154: IF (p_user_id IS NULL) THEN
1155: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1156: RAISE fnd_api.g_exc_error;
1157: ELSE
1158: jtf_ih_core_util_pvt.validate_who_info
1159: ( p_api_name => l_api_name_full,

Line 1158: jtf_ih_core_util_pvt.validate_who_info

1154: IF (p_user_id IS NULL) THEN
1155: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1156: RAISE fnd_api.g_exc_error;
1157: ELSE
1158: jtf_ih_core_util_pvt.validate_who_info
1159: ( p_api_name => l_api_name_full,
1160: p_parameter_name_usr => 'p_user_id',
1161: p_parameter_name_log => 'p_login_id',
1162: p_user_id => p_user_id,

Line 1169: ----DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Create_MediaLifecycle');

1165: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1166: RAISE fnd_api.g_exc_error;
1167: END IF;
1168: END IF;
1169: ----DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Create_MediaLifecycle');
1170: Validate_Mlcs_Record
1171: ( p_api_name => l_api_name_full,
1172: p_media_lc_rec => p_media_lc_rec,
1173: p_resp_appl_id => p_resp_appl_id,

Line 1307: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

1303: --
1304: -- Validate user and login session IDs
1305: --
1306: IF (p_user_id IS NULL) THEN
1307: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1308: RAISE fnd_api.g_exc_error;
1309: ELSE
1310: jtf_ih_core_util_pvt.validate_who_info
1311: ( p_api_name => l_api_name_full,

Line 1310: jtf_ih_core_util_pvt.validate_who_info

1306: IF (p_user_id IS NULL) THEN
1307: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1308: RAISE fnd_api.g_exc_error;
1309: ELSE
1310: jtf_ih_core_util_pvt.validate_who_info
1311: ( p_api_name => l_api_name_full,
1312: p_parameter_name_usr => 'p_user_id',
1313: p_parameter_name_log => 'p_login_id',
1314: p_user_id => p_user_id,

Line 1321: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Create_Interaction');

1317: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1318: RAISE fnd_api.g_exc_error;
1319: END IF;
1320: END IF;
1321: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Create_Interaction');
1322:
1323: --
1324: -- Validate all non-missing attributes by calling the utility procedure.
1325: --

Line 1623: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

1619: --
1620: -- Validate user and login session IDs
1621: --
1622: IF (p_user_id IS NULL) THEN
1623: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1624: RAISE fnd_api.g_exc_error;
1625: ELSE
1626: jtf_ih_core_util_pvt.validate_who_info
1627: ( p_api_name => l_api_name_full,

Line 1626: jtf_ih_core_util_pvt.validate_who_info

1622: IF (p_user_id IS NULL) THEN
1623: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1624: RAISE fnd_api.g_exc_error;
1625: ELSE
1626: jtf_ih_core_util_pvt.validate_who_info
1627: ( p_api_name => l_api_name_full,
1628: p_parameter_name_usr => 'p_user_id',
1629: p_parameter_name_log => 'p_login_id',
1630: p_user_id => p_user_id,

Line 1731: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

1727: --
1728: -- Validate user and login session IDs
1729: --
1730: IF (p_user_id IS NULL) THEN
1731: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1732: RAISE fnd_api.g_exc_error;
1733: ELSE
1734: jtf_ih_core_util_pvt.validate_who_info
1735: ( p_api_name => l_api_name_full,

Line 1734: jtf_ih_core_util_pvt.validate_who_info

1730: IF (p_user_id IS NULL) THEN
1731: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1732: RAISE fnd_api.g_exc_error;
1733: ELSE
1734: jtf_ih_core_util_pvt.validate_who_info
1735: ( p_api_name => l_api_name_full,
1736: p_parameter_name_usr => 'p_user_id',
1737: p_parameter_name_log => 'p_login_id',
1738: p_user_id => p_user_id,

Line 1845: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

1841: --
1842: -- Validate user and login session IDs
1843: --
1844: IF (p_user_id IS NULL) THEN
1845: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1846: RAISE fnd_api.g_exc_error;
1847: ELSE
1848: jtf_ih_core_util_pvt.validate_who_info
1849: ( p_api_name => l_api_name_full,

Line 1848: jtf_ih_core_util_pvt.validate_who_info

1844: IF (p_user_id IS NULL) THEN
1845: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1846: RAISE fnd_api.g_exc_error;
1847: ELSE
1848: jtf_ih_core_util_pvt.validate_who_info
1849: ( p_api_name => l_api_name_full,
1850: p_parameter_name_usr => 'p_user_id',
1851: p_parameter_name_log => 'p_login_id',
1852: p_user_id => p_user_id,

Line 1859: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Open_Interaction');

1855: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1856: RAISE fnd_api.g_exc_error;
1857: END IF;
1858: END IF;
1859: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Open_Interaction');
1860:
1861: --
1862: -- Validate all non-missing attributes by calling the utility procedure.
1863: --

Line 1911: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,

1907: IF(p_interaction_rec.non_productive_time_amount IS NOT NULL) THEN
1908: l_productive_time_amount := l_duration - p_interaction_rec.non_productive_time_amount;
1909: IF(l_productive_time_amount < 0) THEN
1910: x_return_status := fnd_api.g_ret_sts_error;
1911: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,
1912: to_char(p_interaction_rec.non_productive_time_amount),'non_productive_time_amount');
1913: RETURN;
1914: END IF;
1915: ELSE

Line 2128: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

2124: --
2125: -- Validate user and login session IDs
2126: --
2127: IF (p_user_id IS NULL) THEN
2128: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2129: RAISE fnd_api.g_exc_error;
2130: ELSE
2131: jtf_ih_core_util_pvt.validate_who_info
2132: ( p_api_name => l_api_name_full,

Line 2131: jtf_ih_core_util_pvt.validate_who_info

2127: IF (p_user_id IS NULL) THEN
2128: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2129: RAISE fnd_api.g_exc_error;
2130: ELSE
2131: jtf_ih_core_util_pvt.validate_who_info
2132: ( p_api_name => l_api_name_full,
2133: p_parameter_name_usr => 'p_user_id',
2134: p_parameter_name_log => 'p_login_id',
2135: p_user_id => p_user_id,

Line 2142: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_Interaction');

2138: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2139: RAISE fnd_api.g_exc_error;
2140: END IF;
2141: END IF;
2142: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_Interaction');
2143:
2144: --
2145: -- Validate all non-missing attributes by calling the utility procedure.
2146: --

Line 2164: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'interaction_id');

2160: --
2161: -- Update table JTF_IH_INTERACTIONS
2162: --
2163: IF (p_interaction_rec.interaction_id IS NULL) THEN
2164: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'interaction_id');
2165: RAISE fnd_api.g_exc_error;
2166: ELSE
2167: l_count := 0;
2168: SELECT count(*) into l_count

Line 2173: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.interaction_id),

2169: FROM jtf_ih_interactions
2170: WHERE interaction_id = p_interaction_rec.interaction_id;
2171: IF(l_count <> 1) THEN
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.interaction_id),
2174: 'interaction_id');
2175: RETURN;
2176: ELSE
2177: SELECT active into l_active

Line 2212: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,

2208: IF(p_interaction_rec.non_productive_time_amount IS NOT NULL) THEN
2209: l_productive_time_amount := l_duration - p_interaction_rec.non_productive_time_amount;
2210: IF(l_productive_time_amount < 0) THEN
2211: x_return_status := fnd_api.g_ret_sts_error;
2212: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,
2213: to_char(p_interaction_rec.non_productive_time_amount),'non_productive_time_amount');
2214: RETURN;
2215: END IF;
2216: ELSE

Line 2478: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

2474: --
2475: -- Validate user and login session IDs
2476: --
2477: IF (p_user_id IS NULL) THEN
2478: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2479: RAISE fnd_api.g_exc_error;
2480: ELSE
2481: jtf_ih_core_util_pvt.validate_who_info
2482: ( p_api_name => l_api_name_full,

Line 2481: jtf_ih_core_util_pvt.validate_who_info

2477: IF (p_user_id IS NULL) THEN
2478: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2479: RAISE fnd_api.g_exc_error;
2480: ELSE
2481: jtf_ih_core_util_pvt.validate_who_info
2482: ( p_api_name => l_api_name_full,
2483: p_parameter_name_usr => 'p_user_id',
2484: p_parameter_name_log => 'p_login_id',
2485: p_user_id => p_user_id,

Line 2492: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Close_Interaction');

2488: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2489: RAISE fnd_api.g_exc_error;
2490: END IF;
2491: END IF;
2492: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Close_Interaction');
2493:
2494: --
2495: -- Update interaction
2496: --

Line 2516: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),

2512: FROM jtf_ih_interactions
2513: WHERE interaction_id = p_interaction_rec.interaction_id;
2514: IF (l_outcome_id IS NULL) THEN
2515: x_return_status := fnd_api.g_ret_sts_error;
2516: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),
2517: 'outcome_id');
2518: RETURN;
2519: END IF;
2520:

Line 2540: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

2536: FROM jtf_ih_activities
2537: WHERE activity_id = v_activity_id_c.activity_id;
2538: IF (l_outcome_id IS NULL) THEN
2539: x_return_status := fnd_api.g_ret_sts_error;
2540: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
2541: 'outcome_id');
2542: RETURN;
2543: END IF;
2544:

Line 2551: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),

2547: FROM jtf_ih_activities
2548: WHERE activity_id = v_activity_id_c.activity_id;
2549: IF (l_action_item_id IS NULL) THEN
2550: x_return_status := fnd_api.g_ret_sts_error;
2551: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),
2552: 'action_item_id');
2553: RETURN;
2554: END IF;
2555:

Line 2648: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

2644: --
2645: -- Validate user and login session IDs
2646: --
2647: IF (p_user_id IS NULL) THEN
2648: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2649: RAISE fnd_api.g_exc_error;
2650: ELSE
2651: jtf_ih_core_util_pvt.validate_who_info
2652: ( p_api_name => l_api_name_full,

Line 2651: jtf_ih_core_util_pvt.validate_who_info

2647: IF (p_user_id IS NULL) THEN
2648: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2649: RAISE fnd_api.g_exc_error;
2650: ELSE
2651: jtf_ih_core_util_pvt.validate_who_info
2652: ( p_api_name => l_api_name_full,
2653: p_parameter_name_usr => 'p_user_id',
2654: p_parameter_name_log => 'p_login_id',
2655: p_user_id => p_user_id,

Line 2662: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Add_Activity');

2658: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2659: RAISE fnd_api.g_exc_error;
2660: END IF;
2661: END IF;
2662: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Add_Activity');
2663:
2664: --
2665: -- Validate all non-missing attributes by calling the utility procedure.
2666: --

Line 2851: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

2847: --
2848: -- Validate user and login session IDs
2849: --
2850: IF (p_user_id IS NULL) THEN
2851: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2852: RAISE fnd_api.g_exc_error;
2853: ELSE
2854: jtf_ih_core_util_pvt.validate_who_info
2855: ( p_api_name => l_api_name_full,

Line 2854: jtf_ih_core_util_pvt.validate_who_info

2850: IF (p_user_id IS NULL) THEN
2851: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2852: RAISE fnd_api.g_exc_error;
2853: ELSE
2854: jtf_ih_core_util_pvt.validate_who_info
2855: ( p_api_name => l_api_name_full,
2856: p_parameter_name_usr => 'p_user_id',
2857: p_parameter_name_log => 'p_login_id',
2858: p_user_id => p_user_id,

Line 2865: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_Activity');

2861: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2862: RAISE fnd_api.g_exc_error;
2863: END IF;
2864: END IF;
2865: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_Activity');
2866:
2867: --
2868: -- Validate all non-missing attributes by calling the utility procedure.
2869: --

Line 2886: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');

2882: --
2883: -- Update table JTF_IH_INTERACTIONS
2884: --
2885: IF (p_activity_rec.activity_id IS NULL) THEN
2886: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');
2887: RAISE fnd_api.g_exc_error;
2888: ELSE
2889: l_count := 0;
2890: SELECT count(*) into l_count

Line 2895: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),

2891: FROM jtf_ih_activities
2892: WHERE activity_id = p_activity_rec.activity_id;
2893: IF (l_count <> 1) THEN
2894: x_return_status := fnd_api.g_ret_sts_error;
2895: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),
2896: 'activity_id');
2897: RETURN;
2898: ELSE
2899: SELECT active into l_active FROM jtf_ih_activities

Line 3091: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

3087: --
3088: -- Validate user and login session IDs
3089: --
3090: IF (p_user_id IS NULL) THEN
3091: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3092: RAISE fnd_api.g_exc_error;
3093: ELSE
3094: jtf_ih_core_util_pvt.validate_who_info
3095: ( p_api_name => l_api_name_full,

Line 3094: jtf_ih_core_util_pvt.validate_who_info

3090: IF (p_user_id IS NULL) THEN
3091: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3092: RAISE fnd_api.g_exc_error;
3093: ELSE
3094: jtf_ih_core_util_pvt.validate_who_info
3095: ( p_api_name => l_api_name_full,
3096: p_parameter_name_usr => 'p_user_id',
3097: p_parameter_name_log => 'p_login_id',
3098: p_user_id => p_user_id,

Line 3105: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Close_Interaction_2');

3101: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3102: RAISE fnd_api.g_exc_error;
3103: END IF;
3104: END IF;
3105: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Close_Interaction_2');
3106:
3107: SELECT outcome_id into l_outcome_id
3108: FROM jtf_ih_interactions
3109: WHERE interaction_id = p_interaction_id;

Line 3112: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

3108: FROM jtf_ih_interactions
3109: WHERE interaction_id = p_interaction_id;
3110: IF (l_outcome_id IS NULL) THEN
3111: x_return_status := fnd_api.g_ret_sts_error;
3112: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
3113: 'outcome_id');
3114: RETURN;
3115: END IF;
3116:

Line 3136: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

3132: FROM jtf_ih_activities
3133: WHERE activity_id = v_activity_id_c.activity_id;
3134: IF (l_outcome_id IS NULL) THEN
3135: x_return_status := fnd_api.g_ret_sts_error;
3136: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
3137: 'outcome_id');
3138: RETURN;
3139: END IF;
3140:

Line 3147: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),

3143: FROM jtf_ih_activities
3144: WHERE activity_id = v_activity_id_c.activity_id;
3145: IF (l_action_item_id IS NULL) THEN
3146: x_return_status := fnd_api.g_ret_sts_error;
3147: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),
3148: 'action_item_id');
3149: RETURN;
3150: END IF;
3151:

Line 3245: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');

3241: --
3242: -- Validate user and login session IDs
3243: --
3244: IF (p_user_id IS NULL) THEN
3245: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3246: RAISE fnd_api.g_exc_error;
3247: ELSE
3248: jtf_ih_core_util_pvt.validate_who_info
3249: ( p_api_name => l_api_name_full,

Line 3248: jtf_ih_core_util_pvt.validate_who_info

3244: IF (p_user_id IS NULL) THEN
3245: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3246: RAISE fnd_api.g_exc_error;
3247: ELSE
3248: jtf_ih_core_util_pvt.validate_who_info
3249: ( p_api_name => l_api_name_full,
3250: p_parameter_name_usr => 'p_user_id',
3251: p_parameter_name_log => 'p_login_id',
3252: p_user_id => p_user_id,

Line 3259: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_ActivityDuration');

3255: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3256: RAISE fnd_api.g_exc_error;
3257: END IF;
3258: END IF;
3259: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_ActivityDuration');
3260:
3261: --
3262: -- Update table JTF_IH_INTERACTIONS
3263: --

Line 3265: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');

3261: --
3262: -- Update table JTF_IH_INTERACTIONS
3263: --
3264: IF (p_activity_id IS NULL) THEN
3265: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');
3266: RAISE fnd_api.g_exc_error;
3267: ELSIF(p_end_date_time IS NULL) THEN RETURN;
3268: ELSE
3269: SELECT start_date_time into l_start_date_time