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.PV_GE_NOTIF_RULES_PVT dependencies on PVX_UTILITY_PVT

Line 135: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

131:
132: -- Debug Message
133: IF (PV_DEBUG_HIGH_ON) THEN
134:
135: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
136: END IF;
137:
138:
139:

Line 173: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

169: -- =========================================================================
170:
171: IF FND_GLOBAL.USER_ID IS NULL
172: THEN
173: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177:

Line 184: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Notif_Rules');

180: THEN
181: -- Debug message
182: IF (PV_DEBUG_HIGH_ON) THEN
183:
184: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Notif_Rules');
185: END IF;
186:
187: -- Anubhav added to populate default values for not null columns
188:

Line 223: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

219:
220: -- Debug Message
221: IF (PV_DEBUG_HIGH_ON) THEN
222:
223: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
224: END IF;
225:
226: -- Invoke table handler(Pv_Ge_Notif_Rules_Pkg.Insert_Row)
227: Pv_Ge_Notif_Rules_Pkg.Insert_Row(

Line 274: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

270:
271: -- Debug Message
272: IF (PV_DEBUG_HIGH_ON) THEN
273:
274: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
275: END IF;
276:
277:
278: -- Standard call to get message count and if count is 1, get message info.

Line 285: WHEN PVX_UTILITY_PVT.resource_locked THEN

281: p_data => x_msg_data
282: );
283: EXCEPTION
284:
285: WHEN PVX_UTILITY_PVT.resource_locked THEN
286: x_return_status := FND_API.g_ret_sts_error;
287: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
288:
289: WHEN FND_API.G_EXC_ERROR THEN

Line 287: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

283: EXCEPTION
284:
285: WHEN PVX_UTILITY_PVT.resource_locked THEN
286: x_return_status := FND_API.g_ret_sts_error;
287: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
288:
289: WHEN FND_API.G_EXC_ERROR THEN
290: ROLLBACK TO CREATE_Ge_Notif_Rules_PVT;
291: x_return_status := FND_API.G_RET_STS_ERROR;

Line 424: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

420: END IF;
421:
422: -- Debug Message
423: IF (PV_DEBUG_HIGH_ON) THEN
424: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
425: END IF;
426:
427:
428: -- Initialize API return status to SUCCESS

Line 441: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : inside loop');

437:
438: OPEN c_get_notif_rules_rec (p_src_object_id);
439: LOOP
440: IF (PV_DEBUG_HIGH_ON) THEN
441: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : inside loop');
442: END IF;
443: FETCH c_get_notif_rules_rec bulk collect into
444: wf_item_type_code_array, notif_type_code_array, active_flag_array,
445: repeat_freq_unit_array, repeat_freq_value_array, send_notif_before_unit_array, send_notif_before_value_array,

Line 449: PVX_UTILITY_PVT.debug_message(l_api_name || 'notif_rule_id_array.count =' || to_char(notif_rule_id_array.count));

445: repeat_freq_unit_array, repeat_freq_value_array, send_notif_before_unit_array, send_notif_before_value_array,
446: send_notif_after_unit_array, send_notif_after_value_array, repeat_until_unit_array, repeat_until_value_array
447: LIMIT 100;
448: IF (PV_DEBUG_HIGH_ON) THEN
449: PVX_UTILITY_PVT.debug_message(l_api_name || 'notif_rule_id_array.count =' || to_char(notif_rule_id_array.count));
450:
451: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');
452: END IF;
453:

Line 451: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');

447: LIMIT 100;
448: IF (PV_DEBUG_HIGH_ON) THEN
449: PVX_UTILITY_PVT.debug_message(l_api_name || 'notif_rule_id_array.count =' || to_char(notif_rule_id_array.count));
450:
451: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');
452: END IF;
453:
454: forall i in 1..wf_item_type_code_array.count
455: update pv_ge_notif_rules_b

Line 490: PVX_UTILITY_PVT.debug_message(l_api_name || 'k = ' || to_char(k));

486: if ((k <> 1) and (old_notif_rule_id_array(k) <> old_notif_rule_id_array(k-1))) then
487: elmt_count := elmt_count + 1;
488: end if;
489: IF (PV_DEBUG_HIGH_ON) THEN
490: PVX_UTILITY_PVT.debug_message(l_api_name || 'k = ' || to_char(k));
491: PVX_UTILITY_PVT.debug_message(l_api_name || 'elmt_count = ' || to_char(elmt_count));
492: END IF;
493: new_notif_rule_id_array(k) := notif_rule_id_array(elmt_count);
494:

Line 491: PVX_UTILITY_PVT.debug_message(l_api_name || 'elmt_count = ' || to_char(elmt_count));

487: elmt_count := elmt_count + 1;
488: end if;
489: IF (PV_DEBUG_HIGH_ON) THEN
490: PVX_UTILITY_PVT.debug_message(l_api_name || 'k = ' || to_char(k));
491: PVX_UTILITY_PVT.debug_message(l_api_name || 'elmt_count = ' || to_char(elmt_count));
492: END IF;
493: new_notif_rule_id_array(k) := notif_rule_id_array(elmt_count);
494:
495: end loop;

Line 526: WHEN PVX_Utility_PVT.resource_locked THEN

522: );
523:
524: EXCEPTION
525:
526: WHEN PVX_Utility_PVT.resource_locked THEN
527: x_return_status := FND_API.g_ret_sts_error;
528: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
529:
530: WHEN FND_API.G_EXC_ERROR THEN

Line 528: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

524: EXCEPTION
525:
526: WHEN PVX_Utility_PVT.resource_locked THEN
527: x_return_status := FND_API.g_ret_sts_error;
528: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO Copy_Row;
532: x_return_status := FND_API.G_RET_STS_ERROR;

Line 657: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

653:
654: -- Debug Message
655: IF (PV_DEBUG_HIGH_ON) THEN
656:
657: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
658: END IF;
659:
660:
661:

Line 668: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

664:
665: -- Debug Message
666: IF (PV_DEBUG_HIGH_ON) THEN
667:
668: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
669: END IF;
670:
671: OPEN c_get_Ge_Notif_Rules( l_tar_ge_notif_rules_rec.notif_rule_id);
672:

Line 676: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

672:
673: FETCH c_get_Ge_Notif_Rules INTO l_ref_ge_notif_rules_rec ;
674:
675: If ( c_get_Ge_Notif_Rules%NOTFOUND) THEN
676: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
677: p_token_name => 'INFO',
678: p_token_value => 'Ge_Notif_Rules') ;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;

Line 684: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');

680: END IF;
681: -- Debug Message
682: IF (PV_DEBUG_HIGH_ON) THEN
683:
684: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
685: END IF;
686: CLOSE c_get_Ge_Notif_Rules;
687:
688:

Line 691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

687:
688:
689: If (l_tar_ge_notif_rules_rec.object_version_number is NULL or
690: l_tar_ge_notif_rules_rec.object_version_number = FND_API.G_MISS_NUM ) Then
691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
692: p_token_name => 'COLUMN',
693: p_token_value => 'Last_Update_Date') ;
694: raise FND_API.G_EXC_ERROR;
695: End if;

Line 698: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

694: raise FND_API.G_EXC_ERROR;
695: End if;
696: -- Check Whether record has been changed by someone else
697: If (l_tar_ge_notif_rules_rec.object_version_number <> l_ref_ge_notif_rules_rec.object_version_number) Then
698: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
699: p_token_name => 'INFO',
700: p_token_value => 'Ge_Notif_Rules') ;
701: raise FND_API.G_EXC_ERROR;
702: End if;

Line 710: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Notif_Rules');

706: THEN
707: -- Debug message
708: IF (PV_DEBUG_HIGH_ON) THEN
709:
710: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Notif_Rules');
711: END IF;
712:
713: -- Invoke validation procedures
714: Validate_ge_notif_rules(

Line 731: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;

727: END IF;
728:
729:
730: -- Debug Message
731: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
732:
733: -- Invoke table handler(Pv_Ge_Notif_Rules_Pkg.Update_Row)
734: Pv_Ge_Notif_Rules_Pkg.Update_Row(
735: p_notif_rule_id => p_ge_notif_rules_rec.notif_rule_id,

Line 771: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

767:
768: -- Debug Message
769: IF (PV_DEBUG_HIGH_ON) THEN
770:
771: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
772: END IF;
773:
774:
775: -- Standard call to get message count and if count is 1, get message info.

Line 782: WHEN PVX_UTILITY_PVT.resource_locked THEN

778: p_data => x_msg_data
779: );
780: EXCEPTION
781:
782: WHEN PVX_UTILITY_PVT.resource_locked THEN
783: x_return_status := FND_API.g_ret_sts_error;
784: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
785:
786: WHEN FND_API.G_EXC_ERROR THEN

Line 784: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

780: EXCEPTION
781:
782: WHEN PVX_UTILITY_PVT.resource_locked THEN
783: x_return_status := FND_API.g_ret_sts_error;
784: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
785:
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO UPDATE_Ge_Notif_Rules_PVT;
788: x_return_status := FND_API.G_RET_STS_ERROR;

Line 898: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

894:
895: -- Debug Message
896: IF (PV_DEBUG_HIGH_ON) THEN
897:
898: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
899: END IF;
900:
901:
902:

Line 912: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

908: --
909: -- Debug Message
910: IF (PV_DEBUG_HIGH_ON) THEN
911:
912: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
913: END IF;
914:
915: -- Invoke table handler(Pv_Ge_Notif_Rules_Pkg.Delete_Row)
916: Pv_Ge_Notif_Rules_Pkg.Delete_Row(

Line 933: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

929:
930: -- Debug Message
931: IF (PV_DEBUG_HIGH_ON) THEN
932:
933: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
934: END IF;
935:
936:
937: -- Standard call to get message count and if count is 1, get message info.

Line 944: WHEN PVX_UTILITY_PVT.resource_locked THEN

940: p_data => x_msg_data
941: );
942: EXCEPTION
943:
944: WHEN PVX_UTILITY_PVT.resource_locked THEN
945: x_return_status := FND_API.g_ret_sts_error;
946: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
947:
948: WHEN FND_API.G_EXC_ERROR THEN

Line 946: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

942: EXCEPTION
943:
944: WHEN PVX_UTILITY_PVT.resource_locked THEN
945: x_return_status := FND_API.g_ret_sts_error;
946: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
947:
948: WHEN FND_API.G_EXC_ERROR THEN
949: ROLLBACK TO DELETE_Ge_Notif_Rules_PVT;
950: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1042: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1038:
1039: -- Debug Message
1040: IF (PV_DEBUG_HIGH_ON) THEN
1041:
1042: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1043: END IF;
1044:
1045:
1046: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1080: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');

1076: p_count => x_msg_count,
1077: p_data => x_msg_data);
1078: IF (PV_DEBUG_HIGH_ON) THEN
1079:
1080: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
1081: END IF;
1082: EXCEPTION
1083:
1084: WHEN PVX_UTILITY_PVT.resource_locked THEN

Line 1084: WHEN PVX_UTILITY_PVT.resource_locked THEN

1080: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
1081: END IF;
1082: EXCEPTION
1083:
1084: WHEN PVX_UTILITY_PVT.resource_locked THEN
1085: x_return_status := FND_API.g_ret_sts_error;
1086: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1087:
1088: WHEN FND_API.G_EXC_ERROR THEN

Line 1086: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1082: EXCEPTION
1083:
1084: WHEN PVX_UTILITY_PVT.resource_locked THEN
1085: x_return_status := FND_API.g_ret_sts_error;
1086: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1087:
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO LOCK_Ge_Notif_Rules_PVT;
1090: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1138: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

1134: x_return_status := FND_API.g_ret_sts_success;
1135: IF p_validation_mode = JTF_PLSQL_API.g_create
1136: AND p_ge_notif_rules_rec.notif_rule_id IS NOT NULL
1137: THEN
1138: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1139: 'pv_ge_notif_rules_b',
1140: 'notif_rule_id = ''' || p_ge_notif_rules_rec.notif_rule_id ||''''
1141: );
1142: END IF;

Line 1145: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_notif_rule_id_DUPLICATE');

1141: );
1142: END IF;
1143:
1144: IF l_valid_flag = FND_API.g_false THEN
1145: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_notif_rule_id_DUPLICATE');
1146: x_return_status := FND_API.g_ret_sts_error;
1147: END IF;
1148:
1149: END check_Ge_Notif_Rules_Uk_Items;

Line 1166: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_RULE_ID' );

1162: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1163:
1164:
1165: IF p_ge_notif_rules_rec.notif_rule_id = FND_API.G_MISS_NUM OR p_ge_notif_rules_rec.notif_rule_id IS NULL THEN
1166: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_RULE_ID' );
1167: x_return_status := FND_API.g_ret_sts_error;
1168: END IF;
1169:
1170:

Line 1172: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

1168: END IF;
1169:
1170:
1171: IF p_ge_notif_rules_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_notif_rules_rec.object_version_number IS NULL THEN
1172: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1173: x_return_status := FND_API.g_ret_sts_error;
1174: END IF;
1175:
1176:

Line 1178: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_NOTIF_FOR_ENTITY_CODE' );

1174: END IF;
1175:
1176:
1177: IF p_ge_notif_rules_rec.arc_notif_for_entity_code = FND_API.g_miss_char OR p_ge_notif_rules_rec.arc_notif_for_entity_code IS NULL THEN
1178: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_NOTIF_FOR_ENTITY_CODE' );
1179: x_return_status := FND_API.g_ret_sts_error;
1180: END IF;
1181:
1182:

Line 1184: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );

1180: END IF;
1181:
1182:
1183: IF p_ge_notif_rules_rec.notif_for_entity_id = FND_API.G_MISS_NUM OR p_ge_notif_rules_rec.notif_for_entity_id IS NULL THEN
1184: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );
1185: x_return_status := FND_API.g_ret_sts_error;
1186: END IF;
1187:
1188:

Line 1190: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_TYPE_CODE' );

1186: END IF;
1187:
1188:
1189: IF p_ge_notif_rules_rec.notif_type_code = FND_API.g_miss_char OR p_ge_notif_rules_rec.notif_type_code IS NULL THEN
1190: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_TYPE_CODE' );
1191: x_return_status := FND_API.g_ret_sts_error;
1192: END IF;
1193:
1194:

Line 1196: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );

1192: END IF;
1193:
1194:
1195: IF p_ge_notif_rules_rec.active_flag = FND_API.g_miss_char OR p_ge_notif_rules_rec.active_flag IS NULL THEN
1196: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );
1197: x_return_status := FND_API.g_ret_sts_error;
1198: END IF;
1199:
1200:

Line 1205: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_RULE_ID' );

1201: ELSE
1202:
1203:
1204: IF p_ge_notif_rules_rec.notif_rule_id = FND_API.G_MISS_NUM THEN
1205: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_RULE_ID' );
1206: x_return_status := FND_API.g_ret_sts_error;
1207: END IF;
1208:
1209:

Line 1211: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

1207: END IF;
1208:
1209:
1210: IF p_ge_notif_rules_rec.object_version_number = FND_API.G_MISS_NUM THEN
1211: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1212: x_return_status := FND_API.g_ret_sts_error;
1213: END IF;
1214:
1215:

Line 1217: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_NOTIF_FOR_ENTITY_CODE' );

1213: END IF;
1214:
1215:
1216: IF p_ge_notif_rules_rec.arc_notif_for_entity_code = FND_API.g_miss_char THEN
1217: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_NOTIF_FOR_ENTITY_CODE' );
1218: x_return_status := FND_API.g_ret_sts_error;
1219: END IF;
1220:
1221:

Line 1223: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );

1219: END IF;
1220:
1221:
1222: IF p_ge_notif_rules_rec.notif_for_entity_id = FND_API.G_MISS_NUM THEN
1223: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );
1224: x_return_status := FND_API.g_ret_sts_error;
1225: END IF;
1226:
1227:

Line 1229: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_TYPE_CODE' );

1225: END IF;
1226:
1227:
1228: IF p_ge_notif_rules_rec.notif_type_code = FND_API.g_miss_char THEN
1229: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_TYPE_CODE' );
1230: x_return_status := FND_API.g_ret_sts_error;
1231: END IF;
1232:
1233:

Line 1235: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );

1231: END IF;
1232:
1233:
1234: IF p_ge_notif_rules_rec.active_flag = FND_API.g_miss_char THEN
1235: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );
1236: x_return_status := FND_API.g_ret_sts_error;
1237: END IF;
1238: END IF;
1239:

Line 1553: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1549:
1550: -- Debug Message
1551: IF (PV_DEBUG_HIGH_ON) THEN
1552:
1553: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1554: END IF;
1555:
1556:
1557:

Line 1565: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1561:
1562: -- Debug Message
1563: IF (PV_DEBUG_HIGH_ON) THEN
1564:
1565: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1566: END IF;
1567:
1568:
1569: -- Standard call to get message count and if count is 1, get message info.

Line 1576: WHEN PVX_UTILITY_PVT.resource_locked THEN

1572: p_data => x_msg_data
1573: );
1574: EXCEPTION
1575:
1576: WHEN PVX_UTILITY_PVT.resource_locked THEN
1577: x_return_status := FND_API.g_ret_sts_error;
1578: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1579:
1580: WHEN FND_API.G_EXC_ERROR THEN

Line 1578: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1574: EXCEPTION
1575:
1576: WHEN PVX_UTILITY_PVT.resource_locked THEN
1577: x_return_status := FND_API.g_ret_sts_error;
1578: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1579:
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: ROLLBACK TO VALIDATE_Ge_Notif_Rules_;
1582: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1645: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1641:
1642: -- Debug Message
1643: IF (PV_DEBUG_HIGH_ON) THEN
1644:
1645: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1646: END IF;
1647: -- Standard call to get message count and if count is 1, get message info.
1648: FND_MSG_PUB.Count_And_Get
1649: (p_count => x_msg_count,