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

Line 29: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(x_source_code_id), 'SOUREC_CODE');

25: FROM ams_source_codes
26: WHERE source_code_id = x_source_code_id;
27: IF (SQL%NOTFOUND) THEN
28: x_return_status := fnd_api.g_ret_sts_error;
29: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(x_source_code_id), 'SOUREC_CODE');
30: RETURN ;
31: END IF;
32: END;
33: END IF;

Line 45: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, x_source_code, 'SOURCE_CODE');

41: FROM ams_source_codes
42: WHERE source_code = x_source_code;
43: IF (SQL%NOTFOUND) THEN
44: x_return_status := fnd_api.g_ret_sts_error;
45: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, x_source_code, 'SOURCE_CODE');
46: RETURN;
47: END IF;
48: END;
49: END IF;

Line 91: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-YYYY'),

87: -- (p_end_date_time - p_start_date_time < 0) )THEN
88: (p_end_date_time < p_start_date_time) )THEN
89: -- DBMS_OUTPUT.PUT_LINE('end_date is less than start_date in JTF_IH_PUB.Validate_StartEnd_Date');
90: x_return_status := fnd_api.g_ret_sts_error;
91: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-YYYY'),
92: -- 'end_date_time');
93: -- Enh# 2999069
94: --jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'),'end_date_time');
95: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_END_DATE');

Line 94: --jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'),'end_date_time');

90: x_return_status := fnd_api.g_ret_sts_error;
91: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-YYYY'),
92: -- 'end_date_time');
93: -- Enh# 2999069
94: --jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'),'end_date_time');
95: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_END_DATE');
96: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'));
97: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(p_start_date_time, 'DD-MON-RRRR HH:MI:SS'));
98: FND_MSG_PUB.Add;

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

568: FROM jtf_rs_resource_extns
569: WHERE resource_id = p_int_val_rec.party_id;
570: IF (l_count <= 0) THEN
571: x_return_status := fnd_api.g_ret_sts_error;
572: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),
573: 'resource_id touchpoint1_type');
574: RETURN;
575: END IF;
576: END;

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

590: FROM fnd_application
591: WHERE application_id = p_int_val_rec.handler_id;
592: IF (l_count <= 0) THEN
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_int_val_rec.handler_id),
595: 'Handler_id');
596: RETURN;
597: END IF;
598: END;

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

597: END IF;
598: END;
599: ELSE
600: x_return_status := fnd_api.g_ret_sts_error;
601: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.handler_id),
602: 'handler_id');
603: RETURN;
604: END IF;
605: -- DBMS_OUTPUT.PUT_LINE('PAST Validate handler_id in JTF_IH_PUB.Validate_Interaction_Record');

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

612: FROM jtf_rs_resource_extns
613: WHERE resource_id = p_int_val_rec.resource_id;
614: IF (l_count <= 0) THEN
615: x_return_status := fnd_api.g_ret_sts_error;
616: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),
617: 'resource_id touchpoint2_type');
618: RETURN;
619: END IF;
620: END;

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

624: FROM hz_parties
625: WHERE party_id = p_int_val_rec.resource_id;
626: IF (l_count <= 0) THEN
627: x_return_status := fnd_api.g_ret_sts_error;
628: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),
629: 'party_id touchpoint2_type');
630: RETURN;
631: END IF;
632: END;

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

632: END;
633: END IF;
634: ELSE
635: x_return_status := fnd_api.g_ret_sts_error;
636: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),
637: 'resource_id');
638: RETURN;
639: END IF;
640: -- DBMS_OUTPUT.PUT_LINE('PAST Validate resource_id in JTF_IH_PUB.Validate_Interaction_Record');

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

646: FROM jtf_ih_outcomes_B
647: WHERE outcome_id = p_int_val_rec.outcome_id;
648: IF (l_count <= 0) THEN
649: x_return_status := fnd_api.g_ret_sts_error;
650: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.outcome_id),
651: 'outcome_id');
652: RETURN;
653: END IF;
654: END;

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

662: FROM jtf_ih_results_B
663: WHERE result_id = p_int_val_rec.result_id;
664: IF (l_count <= 0) THEN
665: x_return_status := fnd_api.g_ret_sts_error;
666: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.result_id),
667: 'result_id');
668: RETURN;
669: END IF;
670:

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

679: FROM jtf_ih_reasons_B
680: WHERE reason_id = p_int_val_rec.reason_id;
681: IF (l_count <= 0) THEN
682: x_return_status := fnd_api.g_ret_sts_error;
683: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.reason_id),
684: 'reason_id');
685: RETURN;
686: END IF;
687: END;

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

695: FROM jtf_ih_scripts
696: WHERE script_id = p_int_val_rec.script_id;
697: IF (l_count <= 0) THEN
698: x_return_status := fnd_api.g_ret_sts_error;
699: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.script_id),
700: 'Script_id');
701: RETURN;
702: END IF;
703: END;

Line 726: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.source_code_id), 'SOURCE_CODE_ID');

722: WHERE
723: source_code_id = p_int_val_rec.source_code_id;
724: IF (l_count <= 0) THEN
725: x_return_status := fnd_api.g_ret_sts_error;
726: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.source_code_id), 'SOURCE_CODE_ID');
727: RETURN;
728: END IF;
729: END;
730: END IF;

Line 751: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_int_val_rec.source_code, 'SOURCE_CODE');

747: WHERE
748: source_code = p_int_val_rec.source_code;
749: IF (l_count <= 0) THEN
750: x_return_status := fnd_api.g_ret_sts_error;
751: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_int_val_rec.source_code, 'SOURCE_CODE');
752: RETURN;
753: END IF;
754: END;
755: END IF;

Line 776: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_int_val_rec.source_code || ' ' || to_char(p_int_val_rec.source_code_id),

772: source_code = p_int_val_rec.source_code AND
773: source_code_id = p_int_val_rec.source_code_id;
774: IF (l_count <= 0) THEN
775: x_return_status := fnd_api.g_ret_sts_error;
776: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_int_val_rec.source_code || ' ' || to_char(p_int_val_rec.source_code_id),
777: 'SOURCE_CODE, SOURCE_CODE_ID');
778: RETURN;
779: END IF;
780: END;

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

789: FROM jtf_ih_interactions
790: WHERE interaction_id = p_int_val_rec.parent_id;
791: IF (l_count <= 0) THEN
792: x_return_status := fnd_api.g_ret_sts_error;
793: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.parent_id),
794: 'interaction_id');
795: RETURN;
796: END IF;
797: END;

Line 819: jtf_ih_core_util_pvt.validate_desc_flex

815: (p_int_val_rec.attribute13 <> fnd_api.g_miss_char) OR
816: (p_int_val_rec.attribute14 <> fnd_api.g_miss_char) OR
817: (p_int_val_rec.attribute15 <> fnd_api.g_miss_char) OR
818: (p_int_val_rec.attribute_category <> fnd_api.g_miss_char)) THEN
819: jtf_ih_core_util_pvt.validate_desc_flex
820: ( p_api_name => p_api_name,
821: p_desc_flex_name => 'JTF_IH',
822: p_column_name1 => 'ATTRIBUTE1',
823: p_column_name2 => 'ATTRIBUTE2',

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

981: FROM jtf_ih_interactions
982: WHERE interaction_id = p_act_val_rec.interaction_id;
983: IF (l_count <= 0) THEN
984: x_return_status := fnd_api.g_ret_sts_error;
985: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),
986: 'interaction_id');
987: RETURN;
988: END IF;
989: END;

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

988: END IF;
989: END;
990: ELSE
991: x_return_status := fnd_api.g_ret_sts_error;
992: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),
993: 'interaction_id');
994: RETURN;
995: END IF;
996: -- DBMS_OUTPUT.PUT_LINE('PAST Validate interaction_id in JTF_IH_PUB.Validate_Activity_Record');

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

1002: FROM jtf_ih_action_items_b
1003: WHERE action_item_id = p_act_val_rec.action_item_id;
1004: IF (l_count <= 0) THEN
1005: x_return_status := fnd_api.g_ret_sts_error;
1006: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.action_item_id),
1007: 'action_item_id');
1008: RETURN;
1009: END IF;
1010: END;

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

1018: FROM jtf_ih_outcomes_B
1019: WHERE outcome_id = p_act_val_rec.outcome_id;
1020: IF (l_count <= 0) THEN
1021: x_return_status := fnd_api.g_ret_sts_error;
1022: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.outcome_id),
1023: 'outcome_id');
1024: RETURN;
1025: END IF;
1026:

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

1036: FROM jtf_ih_actions_b
1037: WHERE action_id = p_act_val_rec.action_id;
1038: IF (l_count <= 0) THEN
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.action_id),
1041: 'action_id');
1042: RETURN;
1043: END IF;
1044: END;

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

1051: FROM jtf_ih_results_B
1052: WHERE result_id = p_act_val_rec.result_id;
1053: IF (l_count <= 0) THEN
1054: x_return_status := fnd_api.g_ret_sts_error;
1055: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.result_id),
1056: 'result_id');
1057: RETURN;
1058: END IF;
1059:

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

1068: FROM jtf_ih_reasons_B
1069: WHERE reason_id = p_act_val_rec.reason_id;
1070: IF (l_count <= 0) THEN
1071: x_return_status := fnd_api.g_ret_sts_error;
1072: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.reason_id),
1073: 'reason_id');
1074: RETURN;
1075: END IF;
1076: END;

Line 1100: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.source_code_id), 'SOURCE_CODE_ID');

1096: WHERE
1097: source_code_id = p_act_val_rec.source_code_id;
1098: IF (l_count <= 0) THEN
1099: x_return_status := fnd_api.g_ret_sts_error;
1100: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.source_code_id), 'SOURCE_CODE_ID');
1101: RETURN;
1102: END IF;
1103: END;
1104: END IF;

Line 1125: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_act_val_rec.source_code, 'SOURCE_CODE');

1121: WHERE
1122: source_code = p_act_val_rec.source_code;
1123: IF (l_count <= 0) THEN
1124: x_return_status := fnd_api.g_ret_sts_error;
1125: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_act_val_rec.source_code, 'SOURCE_CODE');
1126: RETURN;
1127: END IF;
1128: END;
1129: END IF;

Line 1150: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_act_val_rec.source_code || ' ' || to_char(p_act_val_rec.source_code_id), 'SOURCE_CODE, SOURCE_CODE_ID');

1146: source_code = p_act_val_rec.source_code AND
1147: source_code_id = p_act_val_rec.source_code_id;
1148: IF (l_count <= 0) THEN
1149: x_return_status := fnd_api.g_ret_sts_error;
1150: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_act_val_rec.source_code || ' ' || to_char(p_act_val_rec.source_code_id), 'SOURCE_CODE, SOURCE_CODE_ID');
1151: RETURN;
1152: END IF;
1153: END;
1154: END IF;

Line 1167: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.cust_account_id),

1163: FROM hz_cust_accounts
1164: WHERE cust_account_id = p_act_val_rec.cust_account_id;
1165: IF (l_count <= 0) THEN
1166: x_return_status := fnd_api.g_ret_sts_error;
1167: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.cust_account_id),
1168: 'cust_account_id');
1169: RETURN;
1170: END IF;
1171: END;

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

1179: FROM jtf_ih_media_items
1180: WHERE media_id = p_act_val_rec.media_id;
1181: IF (l_count <= 0) THEN
1182: x_return_status := fnd_api.g_ret_sts_error;
1183: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.media_id),
1184: 'media_id');
1185: RETURN;
1186: END IF;
1187: END;

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

1262: -- FROM jtf_ih_sources
1263: -- WHERE source_id = p_media_item_val.source_id;
1264: -- IF (l_count <= 0) THEN
1265: -- x_return_status := fnd_api.g_ret_sts_error;
1266: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_item_val.source_id),
1267: -- 'Source_id');
1268: -- RETURN;
1269: -- END IF;
1270: -- ELSE

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

1268: -- RETURN;
1269: -- END IF;
1270: -- ELSE
1271: -- x_return_status := fnd_api.g_ret_sts_error;
1272: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_item_val.source_id),
1273: -- 'Source_id');
1274: -- RETURN;
1275: -- END IF;
1276:

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

1275: -- END IF;
1276:
1277: IF ((p_media_item_val.media_item_type IS NULL) OR (p_media_item_val.media_item_type = fnd_api.g_miss_char)) THEN
1278: x_return_status := fnd_api.g_ret_sts_error;
1279: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_item_val.media_item_type,
1280: 'media_item_type');
1281: RETURN;
1282: END IF;
1283:

Line 1347: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, 'NULL or Missing',

1343: IF (((p_media_lc_rec.milcs_type_id IS NULL) OR (p_media_lc_rec.milcs_type_id = fnd_api.g_miss_num))
1344: AND
1345: ((p_media_lc_rec.milcs_code IS NULL) OR (p_media_lc_rec.milcs_code = fnd_api.g_miss_char))) THEN
1346: x_return_status := fnd_api.g_ret_sts_error;
1347: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, 'NULL or Missing',
1348: 'milcs_code');
1349: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, 'Null or Missing',
1350: 'milcs_type_id');
1351: RETURN;

Line 1349: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, 'Null or Missing',

1345: ((p_media_lc_rec.milcs_code IS NULL) OR (p_media_lc_rec.milcs_code = fnd_api.g_miss_char))) THEN
1346: x_return_status := fnd_api.g_ret_sts_error;
1347: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, 'NULL or Missing',
1348: 'milcs_code');
1349: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, 'Null or Missing',
1350: 'milcs_type_id');
1351: RETURN;
1352: END IF;
1353: IF ((p_media_lc_rec.milcs_type_id IS NOT NULL) AND (p_media_lc_rec.milcs_type_id <> fnd_api.g_miss_num)

Line 1361: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_type_id,

1357: FROM jtf_ih_media_itm_lc_seg_tys
1358: WHERE milcs_type_id = p_media_lc_rec.milcs_type_id;
1359: IF (l_count <= 0) THEN
1360: x_return_status := fnd_api.g_ret_sts_error;
1361: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_type_id,
1362: 'milcs_type_id');
1363: END IF;
1364: SELECT count(milcs_type_id) into l_count
1365: FROM jtf_ih_media_itm_lc_seg_tys

Line 1369: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_code,

1365: FROM jtf_ih_media_itm_lc_seg_tys
1366: WHERE milcs_code = p_media_lc_rec.milcs_code;
1367: IF (l_count <= 0) THEN
1368: x_return_status := fnd_api.g_ret_sts_error;
1369: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_code,
1370: 'milcs_code');
1371: END IF;
1372: IF x_return_status = fnd_api.g_ret_sts_error THEN
1373: RETURN;

Line 1383: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_type_id,

1379: FROM jtf_ih_media_itm_lc_seg_tys
1380: WHERE milcs_type_id = p_media_lc_rec.milcs_type_id;
1381: IF (l_count <= 0) THEN
1382: x_return_status := fnd_api.g_ret_sts_error;
1383: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_type_id,
1384: 'milcs_type_id');
1385: RETURN;
1386: END IF;
1387: END IF;

Line 1394: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_code,

1390: FROM jtf_ih_media_itm_lc_seg_tys
1391: WHERE milcs_code = p_media_lc_rec.milcs_code;
1392: IF (l_count <= 0) THEN
1393: x_return_status := fnd_api.g_ret_sts_error;
1394: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_code,
1395: 'milcs_code');
1396: RETURN;
1397: END IF;
1398: END IF;

Line 1406: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.handler_id,

1402: FROM fnd_application
1403: WHERE application_id = p_media_lc_rec.handler_id;
1404: IF (l_count <= 0) THEN
1405: x_return_status := fnd_api.g_ret_sts_error;
1406: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.handler_id,
1407: 'handler_id');
1408: RETURN;
1409: END IF;
1410: ELSE

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

1408: RETURN;
1409: END IF;
1410: ELSE
1411: x_return_status := fnd_api.g_ret_sts_error;
1412: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),
1413: 'handler_id');
1414: RETURN;
1415: END IF;
1416: l_count := 0;

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

1419: FROM jtf_ih_media_items
1420: WHERE media_id = p_media_lc_rec.media_id;
1421: IF (l_count <= 0) THEN
1422: x_return_status := fnd_api.g_ret_sts_error;
1423: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.media_id),
1424: 'media_id');
1425: RETURN;
1426: END IF;
1427: /* ELSE

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

1425: RETURN;
1426: END IF;
1427: /* ELSE
1428: x_return_status := fnd_api.g_ret_sts_error;
1429: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.handler_id),
1430: 'handler_id');
1431: RETURN;*/
1432: END IF;
1433: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

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

1751: --
1752: -- Validate user and login session IDs
1753: --
1754: IF (p_user_id IS NULL) THEN
1755: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1756: RAISE fnd_api.g_exc_error;
1757: ELSE
1758: jtf_ih_core_util_pvt.validate_who_info
1759: ( p_api_name => l_api_name_full,

Line 1758: jtf_ih_core_util_pvt.validate_who_info

1754: IF (p_user_id IS NULL) THEN
1755: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
1756: RAISE fnd_api.g_exc_error;
1757: ELSE
1758: jtf_ih_core_util_pvt.validate_who_info
1759: ( p_api_name => l_api_name_full,
1760: p_parameter_name_usr => 'p_user_id',
1761: p_parameter_name_log => 'p_login_id',
1762: p_user_id => p_user_id,

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

2172: --
2173: -- Validate user and login session IDs
2174: --
2175: IF (p_user_id IS NULL) THEN
2176: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2177: RAISE fnd_api.g_exc_error;
2178: ELSE
2179: jtf_ih_core_util_pvt.validate_who_info
2180: ( p_api_name => l_api_name_full,

Line 2179: jtf_ih_core_util_pvt.validate_who_info

2175: IF (p_user_id IS NULL) THEN
2176: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2177: RAISE fnd_api.g_exc_error;
2178: ELSE
2179: jtf_ih_core_util_pvt.validate_who_info
2180: ( p_api_name => l_api_name_full,
2181: p_parameter_name_usr => 'p_user_id',
2182: p_parameter_name_log => 'p_login_id',
2183: p_user_id => p_user_id,

Line 2190: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Create_MediaItem');

2186: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2187: RAISE fnd_api.g_exc_error;
2188: END IF;
2189: END IF;
2190: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Create_MediaItem');
2191:
2192: Validate_Media_Item
2193: ( p_api_name => l_api_name_full,
2194: p_media_item_val => p_media_rec,

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

2517: --
2518: -- Validate user and login session IDs
2519: --
2520: IF (p_user_id IS NULL) THEN
2521: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2522: RAISE fnd_api.g_exc_error;
2523: ELSE
2524: jtf_ih_core_util_pvt.validate_who_info
2525: ( p_api_name => l_api_name_full,

Line 2524: jtf_ih_core_util_pvt.validate_who_info

2520: IF (p_user_id IS NULL) THEN
2521: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2522: RAISE fnd_api.g_exc_error;
2523: ELSE
2524: jtf_ih_core_util_pvt.validate_who_info
2525: ( p_api_name => l_api_name_full,
2526: p_parameter_name_usr => 'p_user_id',
2527: p_parameter_name_log => 'p_login_id',
2528: p_user_id => p_user_id,

Line 2535: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Create_MediaLifecycle' || p_user_id);

2531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2532: RAISE fnd_api.g_exc_error;
2533: END IF;
2534: END IF;
2535: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Create_MediaLifecycle' || p_user_id);
2536: -- DBMS_OUTPUT.PUT_LINE('milcs_type_id:= ' || p_media_lc_rec.milcs_type_id);
2537: -- DBMS_OUTPUT.PUT_LINE('milcs_type_code:= ' || p_media_lc_rec.milcs_code);
2538: Validate_Mlcs_Record
2539: ( p_api_name => l_api_name_full,

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

2857: --
2858: -- Validate user and login session IDs
2859: --
2860: IF (p_user_id IS NULL) THEN
2861: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2862: RAISE fnd_api.g_exc_error;
2863: ELSE
2864: jtf_ih_core_util_pvt.validate_who_info
2865: ( p_api_name => l_api_name_full,

Line 2864: jtf_ih_core_util_pvt.validate_who_info

2860: IF (p_user_id IS NULL) THEN
2861: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
2862: RAISE fnd_api.g_exc_error;
2863: ELSE
2864: jtf_ih_core_util_pvt.validate_who_info
2865: ( p_api_name => l_api_name_full,
2866: p_parameter_name_usr => 'p_user_id',
2867: p_parameter_name_log => 'p_login_id',
2868: p_user_id => p_user_id,

Line 2875: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Create_Interaction');

2871: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2872: RAISE fnd_api.g_exc_error;
2873: END IF;
2874: END IF;
2875: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Create_Interaction');
2876:
2877: --
2878: -- Validate all non-missing attributes by calling the utility procedure.
2879: --

Line 3116: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activities(idx).resource_id),'resource_id');

3112: FROM jtf_rs_resource_extns
3113: WHERE resource_id = p_activities(idx).resource_id;
3114: IF (l_count <= 0) THEN
3115: x_return_status := fnd_api.g_ret_sts_error;
3116: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activities(idx).resource_id),'resource_id');
3117: RETURN;
3118: END IF;
3119: l_activities(idx).resource_id := p_activities(idx).resource_id;
3120: ELSE

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

3450: --
3451: -- Validate user and login session IDs
3452: --
3453: IF (p_user_id IS NULL) THEN
3454: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3455: RAISE fnd_api.g_exc_error;
3456: ELSE
3457: jtf_ih_core_util_pvt.validate_who_info
3458: ( p_api_name => l_api_name_full,

Line 3457: jtf_ih_core_util_pvt.validate_who_info

3453: IF (p_user_id IS NULL) THEN
3454: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3455: RAISE fnd_api.g_exc_error;
3456: ELSE
3457: jtf_ih_core_util_pvt.validate_who_info
3458: ( p_api_name => l_api_name_full,
3459: p_parameter_name_usr => 'p_user_id',
3460: p_parameter_name_log => 'p_login_id',
3461: p_user_id => p_user_id,

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

3826: --
3827: -- Validate user and login session IDs
3828: --
3829: IF (p_user_id IS NULL) THEN
3830: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3831: RAISE fnd_api.g_exc_error;
3832: ELSE
3833: jtf_ih_core_util_pvt.validate_who_info
3834: ( p_api_name => l_api_name_full,

Line 3833: jtf_ih_core_util_pvt.validate_who_info

3829: IF (p_user_id IS NULL) THEN
3830: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
3831: RAISE fnd_api.g_exc_error;
3832: ELSE
3833: jtf_ih_core_util_pvt.validate_who_info
3834: ( p_api_name => l_api_name_full,
3835: p_parameter_name_usr => 'p_user_id',
3836: p_parameter_name_log => 'p_login_id',
3837: p_user_id => p_user_id,

Line 4017: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,

4013: -- Standard call to check for call compatibility
4014: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
4015: l_api_name, g_pkg_name) THEN
4016: x_return_status := fnd_api.g_ret_sts_error;
4017: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,
4018: to_char(p_interaction_rec.interaction_id),'fnd_api.compatible_api_call');
4019:
4020: RAISE fnd_api.g_exc_unexpected_error;
4021: END IF;

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

4035: --
4036: -- Validate user and login session IDs
4037: --
4038: IF (p_user_id IS NULL) THEN
4039: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
4040: RAISE fnd_api.g_exc_error;
4041: ELSE
4042: jtf_ih_core_util_pvt.validate_who_info
4043: ( p_api_name => l_api_name_full,

Line 4042: jtf_ih_core_util_pvt.validate_who_info

4038: IF (p_user_id IS NULL) THEN
4039: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
4040: RAISE fnd_api.g_exc_error;
4041: ELSE
4042: jtf_ih_core_util_pvt.validate_who_info
4043: ( p_api_name => l_api_name_full,
4044: p_parameter_name_usr => 'p_user_id',
4045: p_parameter_name_log => 'p_login_id',
4046: p_user_id => p_user_id,

Line 4054: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Open_Interaction');

4050: RAISE fnd_api.g_exc_error;
4051: END IF;
4052: END IF;
4053:
4054: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Open_Interaction');
4055:
4056: --
4057: -- Validate all non-missing attributes by calling the utility procedure.
4058: --

Line 4127: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,

4123: --l_productive_time_amount := l_duration - p_interaction_rec.non_productive_time_amount;
4124: l_interaction_rec.productive_time_amount := l_interaction_rec.duration - p_interaction_rec.non_productive_time_amount;
4125: IF(l_interaction_rec.productive_time_amount < 0) THEN
4126: x_return_status := fnd_api.g_ret_sts_error;
4127: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,
4128: to_char(p_interaction_rec.non_productive_time_amount),'non_productive_time_amount');
4129: -- # 1937894
4130: fnd_msg_pub.count_and_get
4131: ( p_count => x_msg_count,

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

4516: --
4517: -- Validate user and login session IDs
4518: --
4519: IF (p_user_id IS NULL) THEN
4520: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
4521: RAISE fnd_api.g_exc_error;
4522: ELSE
4523: jtf_ih_core_util_pvt.validate_who_info
4524: ( p_api_name => l_api_name_full,

Line 4523: jtf_ih_core_util_pvt.validate_who_info

4519: IF (p_user_id IS NULL) THEN
4520: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
4521: RAISE fnd_api.g_exc_error;
4522: ELSE
4523: jtf_ih_core_util_pvt.validate_who_info
4524: ( p_api_name => l_api_name_full,
4525: p_parameter_name_usr => 'p_user_id',
4526: p_parameter_name_log => 'p_login_id',
4527: p_user_id => p_user_id,

Line 4534: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_Interaction');

4530: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
4531: RAISE fnd_api.g_exc_error;
4532: END IF;
4533: END IF;
4534: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_Interaction');
4535:
4536: --
4537: -- Restore existing column values if manadatory paramaters passed are
4538: -- NULL or of FND_API.G_MISS types

Line 4557: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),

4553: OPEN c_Interaction_csr;
4554: FETCH c_Interaction_csr INTO l_Interaction_rec;
4555: IF (c_Interaction_csr%notfound) THEN
4556: x_return_status := fnd_api.g_ret_sts_error;
4557: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),
4558: 'Interaction_id');
4559: -- # 1937894
4560: fnd_msg_pub.count_and_get
4561: ( p_count => x_msg_count,

Line 4572: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(l_object_version),'The Object_Version_Number set to NULL for interaction');

4568: -- Check if Object_Version_Number was passed
4569: -- Bug# 2012159
4570: --
4571: --IF(p_object_version is null) THEN
4572: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(l_object_version),'The Object_Version_Number set to NULL for interaction');
4573: --RAISE fnd_api.g_exc_error;
4574: --END IF;
4575:
4576: --

Line 4585: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),'Active set to N for interaction');

4581: -- If yes then allow update on closed interaction
4582: fnd_profile.get('JTF_IH_ALLOW_INT_UPDATE_AFTER_CLOSE',l_profile_id);
4583: IF nvl(l_profile_id,'N') <> 'Y' THEN
4584: --x_return_status := fnd_api.g_ret_sts_error;
4585: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),'Active set to N for interaction');
4586: --Bug# 4477761 new error msg
4587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4588: fnd_message.set_name('JTF', 'JTF_IH_INT_UPDATE_NOT_ALLOW');
4589: fnd_message.set_token('INT_ID', to_char(p_Interaction_rec.interaction_id));

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

5137: --
5138: -- Update table JTF_IH_INTERACTIONS
5139: --
5140: IF (p_interaction_rec.interaction_id IS NULL) THEN
5141: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'interaction_id');
5142: RAISE fnd_api.g_exc_error;
5143: ELSE
5144: l_count := 0;
5145: SELECT count(*) into l_count

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

5146: FROM jtf_ih_interactions
5147: WHERE interaction_id = p_interaction_rec.interaction_id;
5148: IF(l_count <> 1) THEN
5149: x_return_status := fnd_api.g_ret_sts_error;
5150: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.interaction_id),
5151: 'interaction_id');
5152: -- # 1937894
5153: fnd_msg_pub.count_and_get
5154: ( p_count => x_msg_count,

Line 5345: la_out_act_list jtf_ih_core_util_pvt.param_tbl_type;

5341: la_duration NUMBER := 0;
5342:
5343: -- Bug# 3779487
5344: msg_code VARCHAR2(50);
5345: la_out_act_list jtf_ih_core_util_pvt.param_tbl_type;
5346:
5347: -- Perf fix for literal Usage
5348: l_active_perf VARCHAR2(1);
5349:

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

5403: --
5404: -- Validate user and login session IDs
5405: --
5406: IF (p_user_id IS NULL) THEN
5407: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
5408: RAISE fnd_api.g_exc_error;
5409: ELSE
5410: jtf_ih_core_util_pvt.validate_who_info
5411: ( p_api_name => l_api_name_full,

Line 5410: jtf_ih_core_util_pvt.validate_who_info

5406: IF (p_user_id IS NULL) THEN
5407: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
5408: RAISE fnd_api.g_exc_error;
5409: ELSE
5410: jtf_ih_core_util_pvt.validate_who_info
5411: ( p_api_name => l_api_name_full,
5412: p_parameter_name_usr => 'p_user_id',
5413: p_parameter_name_log => 'p_login_id',
5414: p_user_id => p_user_id,

Line 5421: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Close_Interaction');

5417: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5418: RAISE fnd_api.g_exc_error;
5419: END IF;
5420: END IF;
5421: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Close_Interaction');
5422: SELECT count(*) into l_count
5423: FROM jtf_ih_activities
5424: WHERE interaction_id = p_interaction_rec.interaction_id;
5425: -- DBMS_OUTPUT.PUT_LINE('lcount = ' || l_count);

Line 5430: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_interaction_rec.interaction_id),

5426: IF (l_count <= 0) THEN
5427: x_return_status := fnd_api.g_ret_sts_error;
5428: -- DBMS_OUTPUT.PUT_LINE('x_return_status = ' || x_return_status);
5429: -- Bug# 1937894
5430: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_interaction_rec.interaction_id),
5431: -- 'activity_id');
5432: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
5433: fnd_message.set_name('JTF', 'JTF_IH_NO_ACTIVITY');
5434: fnd_message.set_token('API_NAME', l_api_name);

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

5474: FROM jtf_ih_interactions
5475: WHERE interaction_id = p_interaction_rec.interaction_id;
5476: IF (l_interaction_rec.outcome_id IS NULL) or (l_interaction_rec.outcome_id = fnd_api.g_miss_num) THEN
5477: x_return_status := fnd_api.g_ret_sts_error;
5478: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),
5479: 'outcome_id');
5480: -- # 1937894
5481: --
5482: fnd_msg_pub.count_and_get

Line 5568: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(la_outcome_id),

5564: msg_code := 'JTF_API_ALL_INVALID_OUTCOME';
5565: --end Bug# 3779487
5566:
5567: -- Bug# 3779487 changed l_outcome_id to la_outcome_id
5568: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(la_outcome_id),
5569: -- 'outcome_id');
5570: -- Bug# 3779487 added by nchouras 4-AUG-2004
5571: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,
5572: la_out_act_list);

Line 5571: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,

5567: -- Bug# 3779487 changed l_outcome_id to la_outcome_id
5568: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(la_outcome_id),
5569: -- 'outcome_id');
5570: -- Bug# 3779487 added by nchouras 4-AUG-2004
5571: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,
5572: la_out_act_list);
5573:
5574: fnd_msg_pub.count_and_get
5575: ( p_count => x_msg_count,

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

5578: END IF;
5579:
5580: IF (l_action_item_id IS NULL) OR (l_action_item_id = fnd_api.g_miss_num) THEN
5581: x_return_status := fnd_api.g_ret_sts_error;
5582: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),
5583: 'action_item_id');
5584: RETURN;
5585: END IF;
5586:

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

5616: FROM jtf_ih_activities
5617: WHERE activity_id = v_activity_id_c.activity_id;
5618: IF (l_outcome_id IS NULL) THEN
5619: x_return_status := fnd_api.g_ret_sts_error;
5620: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
5621: 'outcome_id');
5622: -- # 1937894
5623: --
5624: fnd_msg_pub.count_and_get

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

5629: END IF;
5630:
5631: IF (l_action_item_id IS NULL) THEN
5632: x_return_status := fnd_api.g_ret_sts_error;
5633: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),
5634: 'action_item_id');
5635: -- # 2281489
5636: fnd_msg_pub.count_and_get
5637: ( p_count => x_msg_count,

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

5645: FROM jtf_ih_activities
5646: WHERE activity_id = v_activity_id_c.activity_id;
5647: IF (l_outcome_id IS NULL) or (l_outcome_id = fnd_api.g_miss_num) THEN
5648: x_return_status := fnd_api.g_ret_sts_error;
5649: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),
5650: 'outcome_id');
5651: -- Bug# 1937894
5652: --
5653: fnd_msg_pub.count_and_get

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

5849: --
5850: -- Validate user and login session IDs
5851: --
5852: IF (p_user_id IS NULL) THEN
5853: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
5854: RAISE fnd_api.g_exc_error;
5855: ELSE
5856: jtf_ih_core_util_pvt.validate_who_info
5857: ( p_api_name => l_api_name_full,

Line 5856: jtf_ih_core_util_pvt.validate_who_info

5852: IF (p_user_id IS NULL) THEN
5853: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
5854: RAISE fnd_api.g_exc_error;
5855: ELSE
5856: jtf_ih_core_util_pvt.validate_who_info
5857: ( p_api_name => l_api_name_full,
5858: p_parameter_name_usr => 'p_user_id',
5859: p_parameter_name_log => 'p_login_id',
5860: p_user_id => p_user_id,

Line 5867: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Add_Activity');

5863: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5864: RAISE fnd_api.g_exc_error;
5865: END IF;
5866: END IF;
5867: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Add_Activity');
5868:
5869: --
5870: -- Validate all non-missing attributes by calling the utility procedure.
5871: --

Line 5949: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.resource_id),'resource_id');

5945: FROM jtf_rs_resource_extns
5946: WHERE resource_id = p_activity_rec.resource_id;
5947: IF (l_count <= 0) THEN
5948: x_return_status := fnd_api.g_ret_sts_error;
5949: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.resource_id),'resource_id');
5950: RETURN;
5951: END IF;
5952: l_activity_rec.resource_id := p_activity_rec.resource_id;
5953: ELSE

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

6297: --
6298: -- Validate user and login session IDs
6299: --
6300: IF (p_user_id IS NULL) THEN
6301: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
6302: RAISE fnd_api.g_exc_error;
6303: ELSE
6304: jtf_ih_core_util_pvt.validate_who_info
6305: ( p_api_name => l_api_name_full,

Line 6304: jtf_ih_core_util_pvt.validate_who_info

6300: IF (p_user_id IS NULL) THEN
6301: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
6302: RAISE fnd_api.g_exc_error;
6303: ELSE
6304: jtf_ih_core_util_pvt.validate_who_info
6305: ( p_api_name => l_api_name_full,
6306: p_parameter_name_usr => 'p_user_id',
6307: p_parameter_name_log => 'p_login_id',
6308: p_user_id => p_user_id,

Line 6315: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_Activity');

6311: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
6312: RAISE fnd_api.g_exc_error;
6313: END IF;
6314: END IF;
6315: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_Activity');
6316:
6317: --
6318: -- Validate all non-missing attributes by calling the utility procedure.
6319: --

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

6332: --
6333: -- Update table JTF_IH_INTERACTIONS
6334: --
6335: IF (p_activity_rec.activity_id IS NULL) THEN
6336: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');
6337: RAISE fnd_api.g_exc_error;
6338: ELSE
6339: l_count := 0;
6340: SELECT count(*) into l_count

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

6341: FROM jtf_ih_activities
6342: WHERE activity_id = p_activity_rec.activity_id;
6343: IF (l_count <> 1) THEN
6344: x_return_status := fnd_api.g_ret_sts_error;
6345: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),
6346: 'activity_id');
6347: RETURN;
6348: ELSE
6349:

Line 6354: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_activity_rec.activity_id),

6350: OPEN c_Activity_crs;
6351: FETCH c_Activity_crs INTO rc_Activity;
6352: IF (c_Activity_crs%notfound) THEN
6353: x_return_status := fnd_api.g_ret_sts_error;
6354: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_activity_rec.activity_id),
6355: 'Activity_id');
6356: RETURN;
6357: END IF;
6358: l_active := rc_Activity.Active;

Line 6755: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.resource_id),'resource_id');

6751: FROM jtf_rs_resource_extns
6752: WHERE resource_id = p_activity_rec.resource_id;
6753: IF (l_count <= 0) THEN
6754: x_return_status := fnd_api.g_ret_sts_error;
6755: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.resource_id),'resource_id');
6756: RETURN;
6757: END IF;
6758: l_resource_id := p_activity_rec.resource_id;
6759: END IF;*/

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

6812: -- resource_id = l_resource_id
6813: WHERE Activity_id = p_activity_rec.activity_id;
6814: CLOSE c_Activity_crs;
6815: ELSE
6816: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),
6817: -- 'activity is currently set to N');
6818: --Bug# 4477761 new error msg
6819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6820: fnd_message.set_name('JTF', 'JTF_IH_ACT_UPDATE_NOT_ALLOW');

Line 6944: la_out_act_list jtf_ih_core_util_pvt.param_tbl_type;

6940: la_start_date_time DATE := NULL;
6941: la_duration NUMBER := NULL;
6942: -- Bug# 3779487
6943: msg_code VARCHAR2(50);
6944: la_out_act_list jtf_ih_core_util_pvt.param_tbl_type;
6945:
6946: -- Perf fix for literal Usage
6947: l_duration_perf NUMBER;
6948: l_active_perf VARCHAR2(1);

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

7003: --
7004: -- Validate user and login session IDs
7005: --
7006: IF (p_user_id IS NULL) THEN
7007: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7008: RAISE fnd_api.g_exc_error;
7009: ELSE
7010: jtf_ih_core_util_pvt.validate_who_info
7011: ( p_api_name => l_api_name_full,

Line 7010: jtf_ih_core_util_pvt.validate_who_info

7006: IF (p_user_id IS NULL) THEN
7007: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7008: RAISE fnd_api.g_exc_error;
7009: ELSE
7010: jtf_ih_core_util_pvt.validate_who_info
7011: ( p_api_name => l_api_name_full,
7012: p_parameter_name_usr => 'p_user_id',
7013: p_parameter_name_log => 'p_login_id',
7014: p_user_id => p_user_id,

Line 7021: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Close_Interaction_2');

7017: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
7018: RAISE fnd_api.g_exc_error;
7019: END IF;
7020: END IF;
7021: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Close_Interaction_2');
7022:
7023: SELECT outcome_id, end_date_time, start_date_time, duration
7024: INTO l_outcome_id, l_end_date_time, l_start_date_time, l_duration
7025: FROM jtf_ih_interactions

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

7025: FROM jtf_ih_interactions
7026: WHERE interaction_id = p_interaction_id;
7027: IF ((l_outcome_id IS NULL) OR (l_outcome_id = fnd_api.g_miss_num)) THEN
7028: x_return_status := fnd_api.g_ret_sts_error;
7029: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
7030: 'outcome_id');
7031: RETURN;
7032: END IF;
7033:

Line 7084: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),

7080: la_out_act_list(6).token_value := v_activity_id_c.activity_id;
7081: msg_code := 'JTF_API_ALL_INVALID_OUTCOME';
7082: --end Bug# 3779487
7083:
7084: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
7085: -- 'outcome_id');
7086: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,
7087: la_out_act_list);
7088: fnd_msg_pub.count_and_get

Line 7086: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,

7082: --end Bug# 3779487
7083:
7084: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
7085: -- 'outcome_id');
7086: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,
7087: la_out_act_list);
7088: fnd_msg_pub.count_and_get
7089: ( p_count => x_msg_count,
7090: p_data => x_msg_data );

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

7092: END IF;
7093:
7094: IF (l_action_item_id IS NULL) OR (l_action_item_id = fnd_api.g_miss_num) THEN
7095: x_return_status := fnd_api.g_ret_sts_error;
7096: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),
7097: 'action_item_id');
7098: RETURN;
7099: END IF;
7100:

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

7124: FROM jtf_ih_activities
7125: WHERE activity_id = v_activity_id_c.activity_id;
7126: IF (l_outcome_id IS NULL) THEN
7127: x_return_status := fnd_api.g_ret_sts_error;
7128: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
7129: 'outcome_id');
7130: RETURN;
7131: END IF;
7132:

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

7135: FROM jtf_ih_activities
7136: WHERE activity_id = v_activity_id_c.activity_id;
7137: IF (l_action_item_id IS NULL) THEN
7138: x_return_status := fnd_api.g_ret_sts_error;
7139: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),
7140: 'action_item_id');
7141: RETURN;
7142: END IF;
7143:

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

7284: SAVEPOINT update_activityDuration;
7285:
7286: -- No Activity ID - No Update possible
7287: IF (p_activity_id IS NULL) THEN
7288: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');
7289: RAISE fnd_api.g_exc_error;
7290: END IF;
7291:
7292: -- If duration and end_date are null or have g_miss values then raise an exception

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

7357: --
7358: -- Validate user and login session IDs
7359: --
7360: IF (p_user_id IS NULL) THEN
7361: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7362: RAISE fnd_api.g_exc_error;
7363: ELSE
7364: jtf_ih_core_util_pvt.validate_who_info
7365: ( p_api_name => l_api_name_full,

Line 7364: jtf_ih_core_util_pvt.validate_who_info

7360: IF (p_user_id IS NULL) THEN
7361: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7362: RAISE fnd_api.g_exc_error;
7363: ELSE
7364: jtf_ih_core_util_pvt.validate_who_info
7365: ( p_api_name => l_api_name_full,
7366: p_parameter_name_usr => 'p_user_id',
7367: p_parameter_name_log => 'p_login_id',
7368: p_user_id => p_user_id,

Line 7375: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_ActivityDuration');

7371: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
7372: RAISE fnd_api.g_exc_error;
7373: END IF;
7374: END IF;
7375: --DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_ActivityDuration');
7376:
7377: --
7378: -- Get the current activity values
7379: --

Line 7390: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, l_active,

7386: -- If the activity is not active, then refuse the update.
7387: --
7388: If l_active = 'N' then
7389: x_return_status := fnd_api.g_ret_sts_error;
7390: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, l_active,
7391: 'ACTIVE');
7392: RAISE fnd_api.g_exc_error;
7393: END IF;
7394:

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

7613: --
7614: -- Validate user and login session IDs
7615: --
7616: IF (p_user_id IS NULL) THEN
7617: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7618: RAISE fnd_api.g_exc_error;
7619: ELSE
7620: jtf_ih_core_util_pvt.validate_who_info
7621: ( p_api_name => l_api_name_full,

Line 7620: jtf_ih_core_util_pvt.validate_who_info

7616: IF (p_user_id IS NULL) THEN
7617: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7618: RAISE fnd_api.g_exc_error;
7619: ELSE
7620: jtf_ih_core_util_pvt.validate_who_info
7621: ( p_api_name => l_api_name_full,
7622: p_parameter_name_usr => 'p_user_id',
7623: p_parameter_name_log => 'p_login_id',
7624: p_user_id => p_user_id,

Line 7631: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Open_MediaItem');

7627: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
7628: RAISE fnd_api.g_exc_error;
7629: END IF;
7630: END IF;
7631: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Open_MediaItem');
7632:
7633: --
7634: -- Validate all non-missing attributes by calling the utility procedure.
7635: --

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

7978: --
7979: -- Validate user and login session IDs
7980: --
7981: IF (p_user_id IS NULL) THEN
7982: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7983: RAISE fnd_api.g_exc_error;
7984: ELSE
7985: jtf_ih_core_util_pvt.validate_who_info
7986: ( p_api_name => l_api_name_full,

Line 7985: jtf_ih_core_util_pvt.validate_who_info

7981: IF (p_user_id IS NULL) THEN
7982: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
7983: RAISE fnd_api.g_exc_error;
7984: ELSE
7985: jtf_ih_core_util_pvt.validate_who_info
7986: ( p_api_name => l_api_name_full,
7987: p_parameter_name_usr => 'p_user_id',
7988: p_parameter_name_log => 'p_login_id',
7989: p_user_id => p_user_id,

Line 7996: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_MediaItem');

7992: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
7993: RAISE fnd_api.g_exc_error;
7994: END IF;
7995: END IF;
7996: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_MediaItem');
7997:
7998:
7999: OPEN c_MediaItem_csr;
8000: FETCH c_MediaItem_csr INTO l_MediaItem_rec;

Line 8003: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_rec.media_id),

7999: OPEN c_MediaItem_csr;
8000: FETCH c_MediaItem_csr INTO l_MediaItem_rec;
8001: IF (c_MediaItem_csr%notfound) THEN
8002: x_return_status := fnd_api.g_ret_sts_error;
8003: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_rec.media_id),
8004: 'media_id');
8005: RETURN;
8006: END IF;
8007: --

Line 8012: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_rec.media_id),'Active set to N for mediaitem');

8008: -- Check if Active is set to 'N'
8009: --
8010: IF (l_MediaItem_rec.active = 'N') then
8011: --x_return_status := fnd_api.g_ret_sts_error;
8012: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_rec.media_id),'Active set to N for mediaitem');
8013: RAISE fnd_api.g_exc_error;
8014: END IF;
8015: --
8016: -- Check if source_id requies updating

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

8491: --
8492: -- Validate user and login session IDs
8493: --
8494: IF (p_user_id IS NULL) THEN
8495: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
8496: RAISE fnd_api.g_exc_error;
8497: ELSE
8498: jtf_ih_core_util_pvt.validate_who_info(
8499: p_api_name => l_api_name_full,

Line 8498: jtf_ih_core_util_pvt.validate_who_info(

8494: IF (p_user_id IS NULL) THEN
8495: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
8496: RAISE fnd_api.g_exc_error;
8497: ELSE
8498: jtf_ih_core_util_pvt.validate_who_info(
8499: p_api_name => l_api_name_full,
8500: p_parameter_name_usr => 'p_user_id',
8501: p_parameter_name_log => 'p_login_id',
8502: p_user_id => p_user_id,

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

8776: --
8777: -- Validate user and login session IDs
8778: --
8779: IF (p_user_id IS NULL) THEN
8780: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
8781: RAISE fnd_api.g_exc_error;
8782: ELSE
8783: jtf_ih_core_util_pvt.validate_who_info
8784: ( p_api_name => l_api_name_full,

Line 8783: jtf_ih_core_util_pvt.validate_who_info

8779: IF (p_user_id IS NULL) THEN
8780: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
8781: RAISE fnd_api.g_exc_error;
8782: ELSE
8783: jtf_ih_core_util_pvt.validate_who_info
8784: ( p_api_name => l_api_name_full,
8785: p_parameter_name_usr => 'p_user_id',
8786: p_parameter_name_log => 'p_login_id',
8787: p_user_id => p_user_id,

Line 8794: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Add_MediaLifeCycle');

8790: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
8791: RAISE fnd_api.g_exc_error;
8792: END IF;
8793: END IF;
8794: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Add_MediaLifeCycle');
8795:
8796: --
8797: -- Validate all non-missing attributes by calling the utility procedure.
8798: --

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

9118: --
9119: -- Validate user and login session IDs
9120: --
9121: IF (p_user_id IS NULL) THEN
9122: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
9123: RAISE fnd_api.g_exc_error;
9124: ELSE
9125: jtf_ih_core_util_pvt.validate_who_info
9126: ( p_api_name => l_api_name_full,

Line 9125: jtf_ih_core_util_pvt.validate_who_info

9121: IF (p_user_id IS NULL) THEN
9122: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
9123: RAISE fnd_api.g_exc_error;
9124: ELSE
9125: jtf_ih_core_util_pvt.validate_who_info
9126: ( p_api_name => l_api_name_full,
9127: p_parameter_name_usr => 'p_user_id',
9128: p_parameter_name_log => 'p_login_id',
9129: p_user_id => p_user_id,

Line 9136: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_MediaLifecycle');

9132: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
9133: RAISE fnd_api.g_exc_error;
9134: END IF;
9135: END IF;
9136: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_MediaLifecycle');
9137:
9138: IF (p_media_lc_rec.milcs_id IS NULL) THEN
9139: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'milcs_id');
9140: RAISE fnd_api.g_exc_error;

Line 9139: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'milcs_id');

9135: END IF;
9136: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_MediaLifecycle');
9137:
9138: IF (p_media_lc_rec.milcs_id IS NULL) THEN
9139: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'milcs_id');
9140: RAISE fnd_api.g_exc_error;
9141: ELSE
9142:
9143: OPEN c_Update_MediaLifecycle_csr;

Line 9147: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_lc_rec.milcs_id),

9143: OPEN c_Update_MediaLifecycle_csr;
9144: FETCH c_Update_MediaLifecycle_csr INTO v_Update_MediaLifecycle_rec;
9145: IF (c_Update_MediaLifecycle_csr%notfound) THEN
9146: x_return_status := fnd_api.g_ret_sts_error;
9147: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_lc_rec.milcs_id),
9148: 'media_id');
9149: RETURN;
9150: END IF;
9151: -- DBMS_OUTPUT.PUT_LINE('PAST OPEN c_Update_MediaLifecycle_csr in JTF_IH_PUB.Update_MediaLifecycle');

Line 9209: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_lc_rec.milcs_id),'Active set to N for medialifecycle');

9205: --
9206: --DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB.Update_MediaLifecycle');
9207: ELSE
9208: -- DBMS_OUTPUT.PUT_LINE('hello active error in JTF_IH_PUB.Update_MediaLifecycle');
9209: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_media_lc_rec.milcs_id),'Active set to N for medialifecycle');
9210: RAISE fnd_api.g_exc_error;
9211: END IF;
9212: --
9213: -- Check if type_type requies updating