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.AMS_DM_BINVALUES_PVT dependencies on AMS_UTILITY_PVT

Line 90: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

86:
87: -- Debug Message
88: IF (AMS_DEBUG_HIGH_ON) THEN
89:
90: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
91: END IF;
92:
93:
94: -- Initialize API return status to SUCCESS

Line 117: AMS_UTILITY_PVT.debug_message( l_api_name || ' New Bin Value ID to Insert = ' || l_dm_binvalues_rec.BIN_VALUE_ID);

113: IF (AMS_DEBUG_HIGH_ON) THEN
114:
115:
116:
117: AMS_UTILITY_PVT.debug_message( l_api_name || ' New Bin Value ID to Insert = ' || l_dm_binvalues_rec.BIN_VALUE_ID);
118:
119: END IF;
120:
121: -- =========================================================================

Line 127: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

123: -- =========================================================================
124:
125: IF FND_GLOBAL.User_Id IS NULL
126: THEN
127: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 136: AMS_UTILITY_PVT.debug_message('Private API: Calling Validate_Dm_Binvalues');

132: THEN
133: -- Debug message
134: IF (AMS_DEBUG_HIGH_ON) THEN
135:
136: AMS_UTILITY_PVT.debug_message('Private API: Calling Validate_Dm_Binvalues');
137: END IF;
138:
139: -- Invoke validation procedures
140: Validate_dm_binvalues(

Line 159: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

155:
156: -- Debug Message
157: IF (AMS_DEBUG_HIGH_ON) THEN
158:
159: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
160: END IF;
161:
162: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Insert_Row)
163: AMS_DM_BIN_VALUES_PKG.Insert_Row(

Line 196: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

192:
193: -- Debug Message
194: IF (AMS_DEBUG_HIGH_ON) THEN
195:
196: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
197: END IF;
198:
199: -- Standard call to get message count and if count is 1, get message info.
200: FND_MSG_PUB.Count_And_Get

Line 207: WHEN AMS_Utility_PVT.resource_locked THEN

203: );
204:
205: EXCEPTION
206:
207: WHEN AMS_Utility_PVT.resource_locked THEN
208: x_return_status := FND_API.g_ret_sts_error;
209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
210:
211: WHEN FND_API.G_EXC_ERROR THEN

Line 209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

205: EXCEPTION
206:
207: WHEN AMS_Utility_PVT.resource_locked THEN
208: x_return_status := FND_API.g_ret_sts_error;
209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Dm_Binvalues_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;

Line 302: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

298:
299: -- Debug Message
300: IF (AMS_DEBUG_HIGH_ON) THEN
301:
302: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
303: END IF;
304:
305:
306: -- Initialize API return status to SUCCESS

Line 312: AMS_UTILITY_PVT.debug_message('Private API: - Going to Complete Record');

308:
309: -- Debug Message
310: IF (AMS_DEBUG_HIGH_ON) THEN
311:
312: AMS_UTILITY_PVT.debug_message('Private API: - Going to Complete Record');
313: END IF;
314:
315:
316: -- Complete missing entries in the record before updating

Line 325: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

321:
322: -- Debug Message
323: IF (AMS_DEBUG_HIGH_ON) THEN
324:
325: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
326: END IF;
327:
328:
329: -- get the reference bin value, which contains

Line 335: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

331: OPEN c_get_Dm_Binvalues( l_tar_dm_binvalues_rec.bin_value_id);
332: FETCH c_get_Dm_Binvalues INTO l_ref_dm_binvalues_rec ;
333:
334: If ( c_get_Dm_Binvalues%NOTFOUND) THEN
335: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
336: p_token_name => 'INFO',
337: p_token_value => 'Dm_Binvalues') ;
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;

Line 344: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

340:
341: -- Debug Message
342: IF (AMS_DEBUG_HIGH_ON) THEN
343:
344: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
345: END IF;
346: CLOSE c_get_Dm_Binvalues;
347:
348:

Line 351: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

347:
348:
349: If (l_tar_dm_binvalues_rec.object_version_number is NULL or
350: l_tar_dm_binvalues_rec.object_version_number = FND_API.G_MISS_NUM ) Then
351: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
352: p_token_name => 'COLUMN',
353: p_token_value => 'Last_Update_Date') ;
354: raise FND_API.G_EXC_ERROR;
355: End if;

Line 358: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

354: raise FND_API.G_EXC_ERROR;
355: End if;
356: -- Check Whether record has been changed by someone else
357: If (l_tar_dm_binvalues_rec.object_version_number <> l_ref_dm_binvalues_rec.object_version_number) Then
358: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
359: p_token_name => 'INFO',
360: p_token_value => 'Dm_Binvalues') ;
361: raise FND_API.G_EXC_ERROR;
362: End if;

Line 369: AMS_UTILITY_PVT.debug_message('Private API: Calling Validate_Dm_Binvalues');

365: THEN
366: -- Debug message
367: IF (AMS_DEBUG_HIGH_ON) THEN
368:
369: AMS_UTILITY_PVT.debug_message('Private API: Calling Validate_Dm_Binvalues');
370: END IF;
371:
372: IF (AMS_DEBUG_HIGH_ON) THEN
373:

Line 376: AMS_UTILITY_PVT.debug_message('bin_value_id = ' || l_tar_dm_binvalues_rec.bin_value_id);

372: IF (AMS_DEBUG_HIGH_ON) THEN
373:
374:
375:
376: AMS_UTILITY_PVT.debug_message('bin_value_id = ' || l_tar_dm_binvalues_rec.bin_value_id);
377:
378: END IF;
379: IF (AMS_DEBUG_HIGH_ON) THEN
380:

Line 381: AMS_UTILITY_PVT.debug_message('object_version_number = ' || l_tar_dm_binvalues_rec.object_version_number);

377:
378: END IF;
379: IF (AMS_DEBUG_HIGH_ON) THEN
380:
381: AMS_UTILITY_PVT.debug_message('object_version_number = ' || l_tar_dm_binvalues_rec.object_version_number);
382: END IF;
383: IF (AMS_DEBUG_HIGH_ON) THEN
384:
385: AMS_UTILITY_PVT.debug_message('source_field_id = ' || l_tar_dm_binvalues_rec.source_field_id);

Line 385: AMS_UTILITY_PVT.debug_message('source_field_id = ' || l_tar_dm_binvalues_rec.source_field_id);

381: AMS_UTILITY_PVT.debug_message('object_version_number = ' || l_tar_dm_binvalues_rec.object_version_number);
382: END IF;
383: IF (AMS_DEBUG_HIGH_ON) THEN
384:
385: AMS_UTILITY_PVT.debug_message('source_field_id = ' || l_tar_dm_binvalues_rec.source_field_id);
386: END IF;
387: IF (AMS_DEBUG_HIGH_ON) THEN
388:
389: AMS_UTILITY_PVT.debug_message('bucket = ' || l_tar_dm_binvalues_rec.bucket);

Line 389: AMS_UTILITY_PVT.debug_message('bucket = ' || l_tar_dm_binvalues_rec.bucket);

385: AMS_UTILITY_PVT.debug_message('source_field_id = ' || l_tar_dm_binvalues_rec.source_field_id);
386: END IF;
387: IF (AMS_DEBUG_HIGH_ON) THEN
388:
389: AMS_UTILITY_PVT.debug_message('bucket = ' || l_tar_dm_binvalues_rec.bucket);
390: END IF;
391: IF (AMS_DEBUG_HIGH_ON) THEN
392:
393: AMS_UTILITY_PVT.debug_message('bin_value = ' || l_tar_dm_binvalues_rec.bin_value);

Line 393: AMS_UTILITY_PVT.debug_message('bin_value = ' || l_tar_dm_binvalues_rec.bin_value);

389: AMS_UTILITY_PVT.debug_message('bucket = ' || l_tar_dm_binvalues_rec.bucket);
390: END IF;
391: IF (AMS_DEBUG_HIGH_ON) THEN
392:
393: AMS_UTILITY_PVT.debug_message('bin_value = ' || l_tar_dm_binvalues_rec.bin_value);
394: END IF;
395: IF (AMS_DEBUG_HIGH_ON) THEN
396:
397: AMS_UTILITY_PVT.debug_message('start_value = ' || l_tar_dm_binvalues_rec.start_value);

Line 397: AMS_UTILITY_PVT.debug_message('start_value = ' || l_tar_dm_binvalues_rec.start_value);

393: AMS_UTILITY_PVT.debug_message('bin_value = ' || l_tar_dm_binvalues_rec.bin_value);
394: END IF;
395: IF (AMS_DEBUG_HIGH_ON) THEN
396:
397: AMS_UTILITY_PVT.debug_message('start_value = ' || l_tar_dm_binvalues_rec.start_value);
398: END IF;
399: IF (AMS_DEBUG_HIGH_ON) THEN
400:
401: AMS_UTILITY_PVT.debug_message('end_value = ' || l_tar_dm_binvalues_rec.end_value);

Line 401: AMS_UTILITY_PVT.debug_message('end_value = ' || l_tar_dm_binvalues_rec.end_value);

397: AMS_UTILITY_PVT.debug_message('start_value = ' || l_tar_dm_binvalues_rec.start_value);
398: END IF;
399: IF (AMS_DEBUG_HIGH_ON) THEN
400:
401: AMS_UTILITY_PVT.debug_message('end_value = ' || l_tar_dm_binvalues_rec.end_value);
402: END IF;
403:
404: -- Invoke validation procedures
405: Validate_dm_binvalues(

Line 420: AMS_UTILITY_PVT.debug_message('Private API: AFTER Calling Validate_Dm_Binvalues');

416: IF (AMS_DEBUG_HIGH_ON) THEN
417:
418:
419:
420: AMS_UTILITY_PVT.debug_message('Private API: AFTER Calling Validate_Dm_Binvalues');
421:
422: END IF;
423:
424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 427: AMS_UTILITY_PVT.debug_message('Error while validating ---------');

423:
424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
425: IF (AMS_DEBUG_HIGH_ON) THEN
426:
427: AMS_UTILITY_PVT.debug_message('Error while validating ---------');
428: END IF;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:

Line 436: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');

432:
433: -- Debug Message
434: IF (AMS_DEBUG_HIGH_ON) THEN
435:
436: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
437: END IF;
438:
439: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Update_Row)
440: AMS_DM_BIN_VALUES_PKG.Update_Row(

Line 471: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

467:
468: -- Debug Message
469: IF (AMS_DEBUG_HIGH_ON) THEN
470:
471: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
472: END IF;
473:
474: -- Standard call to get message count and if count is 1, get message info.
475: FND_MSG_PUB.Count_And_Get

Line 481: WHEN AMS_Utility_PVT.resource_locked THEN

477: p_data => x_msg_data
478: );
479: EXCEPTION
480:
481: WHEN AMS_Utility_PVT.resource_locked THEN
482: x_return_status := FND_API.g_ret_sts_error;
483: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
484:
485: WHEN FND_API.G_EXC_ERROR THEN

Line 483: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

479: EXCEPTION
480:
481: WHEN AMS_Utility_PVT.resource_locked THEN
482: x_return_status := FND_API.g_ret_sts_error;
483: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
484:
485: WHEN FND_API.G_EXC_ERROR THEN
486: ROLLBACK TO UPDATE_Dm_Binvalues_PVT;
487: x_return_status := FND_API.G_RET_STS_ERROR;

Line 534: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

530:
531: -- Debug Message
532: IF (AMS_DEBUG_HIGH_ON) THEN
533:
534: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
535: END IF;
536:
537: --
538: -- Api body

Line 550: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

546:
547: -- Debug Message
548: IF (AMS_DEBUG_HIGH_ON) THEN
549:
550: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
551: END IF;
552:
553: EXCEPTION
554:

Line 555: WHEN AMS_Utility_PVT.resource_locked THEN

551: END IF;
552:
553: EXCEPTION
554:
555: WHEN AMS_Utility_PVT.resource_locked THEN
556: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
557:
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO Delete_TgtValues_For_Target;

Line 556: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

552:
553: EXCEPTION
554:
555: WHEN AMS_Utility_PVT.resource_locked THEN
556: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
557:
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO Delete_TgtValues_For_Target;
560:

Line 609: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

605:
606: -- Debug Message
607: IF (AMS_DEBUG_HIGH_ON) THEN
608:
609: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
610: END IF;
611:
612:
613: -- Initialize API return status to SUCCESS

Line 622: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

618: --
619: -- Debug Message
620: IF (AMS_DEBUG_HIGH_ON) THEN
621:
622: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
623: END IF;
624:
625: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Delete_Row)
626: AMS_DM_BIN_VALUES_PKG.Delete_Row(

Line 642: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

638:
639: -- Debug Message
640: IF (AMS_DEBUG_HIGH_ON) THEN
641:
642: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
643: END IF;
644:
645: -- Standard call to get message count and if count is 1, get message info.
646: FND_MSG_PUB.Count_And_Get

Line 653: WHEN AMS_Utility_PVT.resource_locked THEN

649: );
650:
651: EXCEPTION
652:
653: WHEN AMS_Utility_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN

Line 655: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

651: EXCEPTION
652:
653: WHEN AMS_Utility_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO DELETE_Dm_Binvalues_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;

Line 724: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

720:
721: -- Debug Message
722: IF (AMS_DEBUG_HIGH_ON) THEN
723:
724: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
725: END IF;
726:
727: -- Initialize message list if p_init_msg_list is set to TRUE.
728: IF FND_API.to_Boolean( p_init_msg_list )

Line 753: AMS_Utility_PVT.debug_message(l_full_name||': start');

749: IF (AMS_DEBUG_HIGH_ON) THEN
750:
751:
752:
753: AMS_Utility_PVT.debug_message(l_full_name||': start');
754:
755: END IF;
756: OPEN c_Dm_Binvalues;
757:

Line 778: AMS_Utility_PVT.debug_message(l_full_name ||': end');

774: p_count => x_msg_count,
775: p_data => x_msg_data);
776: IF (AMS_DEBUG_HIGH_ON) THEN
777:
778: AMS_Utility_PVT.debug_message(l_full_name ||': end');
779: END IF;
780:
781: EXCEPTION
782:

Line 783: WHEN AMS_Utility_PVT.resource_locked THEN

779: END IF;
780:
781: EXCEPTION
782:
783: WHEN AMS_Utility_PVT.resource_locked THEN
784: x_return_status := FND_API.g_ret_sts_error;
785: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
786:
787: WHEN FND_API.G_EXC_ERROR THEN

Line 785: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

781: EXCEPTION
782:
783: WHEN AMS_Utility_PVT.resource_locked THEN
784: x_return_status := FND_API.g_ret_sts_error;
785: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
786:
787: WHEN FND_API.G_EXC_ERROR THEN
788: ROLLBACK TO LOCK_Dm_Binvalues_PVT;
789: x_return_status := FND_API.G_RET_STS_ERROR;

Line 835: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

831: BEGIN
832:
833: x_return_status := FND_API.g_ret_sts_success;
834: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
835: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
836: 'AMS_DM_BIN_VALUES',
837: 'BIN_VALUE_ID = ''' || p_dm_binvalues_rec.BIN_VALUE_ID ||''''
838: );
839: ELSE

Line 840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

836: 'AMS_DM_BIN_VALUES',
837: 'BIN_VALUE_ID = ''' || p_dm_binvalues_rec.BIN_VALUE_ID ||''''
838: );
839: ELSE
840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
841: 'AMS_DM_BIN_VALUES',
842: 'BIN_VALUE_ID = ''' || p_dm_binvalues_rec.BIN_VALUE_ID ||
843: ''' AND BIN_VALUE_ID <> ' || p_dm_binvalues_rec.BIN_VALUE_ID
844: );

Line 848: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','BIN_VALUE_ID');

844: );
845: END IF;
846:
847: IF l_valid_flag = FND_API.g_false THEN
848: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','BIN_VALUE_ID');
849: x_return_status := FND_API.g_ret_sts_error;
850: RETURN;
851: END IF;
852:

Line 868: ams_utility_pvt.debug_message('Private API:check_req_items for CREATE');

864:
865: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
866: IF (AMS_DEBUG_HIGH_ON) THEN
867:
868: ams_utility_pvt.debug_message('Private API:check_req_items for CREATE');
869: END IF;
870:
871: IF p_dm_binvalues_rec.bin_value_id = FND_API.g_miss_num OR p_dm_binvalues_rec.bin_value_id IS NULL THEN
872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');

Line 872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');

868: ams_utility_pvt.debug_message('Private API:check_req_items for CREATE');
869: END IF;
870:
871: IF p_dm_binvalues_rec.bin_value_id = FND_API.g_miss_num OR p_dm_binvalues_rec.bin_value_id IS NULL THEN
872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');
873: x_return_status := FND_API.g_ret_sts_error;
874: END IF;
875: IF p_dm_binvalues_rec.source_field_id = FND_API.g_miss_num OR p_dm_binvalues_rec.source_field_id IS NULL THEN
876: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

Line 876: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');
873: x_return_status := FND_API.g_ret_sts_error;
874: END IF;
875: IF p_dm_binvalues_rec.source_field_id = FND_API.g_miss_num OR p_dm_binvalues_rec.source_field_id IS NULL THEN
876: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');
877: x_return_status := FND_API.g_ret_sts_error;
878: END IF;
879: IF p_dm_binvalues_rec.bucket = FND_API.g_miss_num OR p_dm_binvalues_rec.bucket IS NULL THEN
880: --changed rosharma 07-may-2003 Bug # 2943269

Line 881: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BUCKET');

877: x_return_status := FND_API.g_ret_sts_error;
878: END IF;
879: IF p_dm_binvalues_rec.bucket = FND_API.g_miss_num OR p_dm_binvalues_rec.bucket IS NULL THEN
880: --changed rosharma 07-may-2003 Bug # 2943269
881: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BUCKET');
882: AMS_Utility_PVT.Error_Message('AMS_DM_NO_BUCKET');
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885: ELSE

Line 882: AMS_Utility_PVT.Error_Message('AMS_DM_NO_BUCKET');

878: END IF;
879: IF p_dm_binvalues_rec.bucket = FND_API.g_miss_num OR p_dm_binvalues_rec.bucket IS NULL THEN
880: --changed rosharma 07-may-2003 Bug # 2943269
881: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BUCKET');
882: AMS_Utility_PVT.Error_Message('AMS_DM_NO_BUCKET');
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885: ELSE
886: IF (AMS_DEBUG_HIGH_ON) THEN

Line 888: ams_utility_pvt.debug_message('Private API:check_req_items for UPDATE');

884: END IF;
885: ELSE
886: IF (AMS_DEBUG_HIGH_ON) THEN
887:
888: ams_utility_pvt.debug_message('Private API:check_req_items for UPDATE');
889: END IF;
890:
891: IF p_dm_binvalues_rec.bin_value_id IS NULL THEN
892: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');

Line 892: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');

888: ams_utility_pvt.debug_message('Private API:check_req_items for UPDATE');
889: END IF;
890:
891: IF p_dm_binvalues_rec.bin_value_id IS NULL THEN
892: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');
893: x_return_status := FND_API.g_ret_sts_error;
894: END IF;
895: IF p_dm_binvalues_rec.last_update_date IS NULL THEN
896: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');

Line 896: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');

892: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BIN_VALUE_ID');
893: x_return_status := FND_API.g_ret_sts_error;
894: END IF;
895: IF p_dm_binvalues_rec.last_update_date IS NULL THEN
896: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');
897: x_return_status := FND_API.g_ret_sts_error;
898: END IF;
899: IF p_dm_binvalues_rec.last_updated_by IS NULL THEN
900: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');

Line 900: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');

896: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');
897: x_return_status := FND_API.g_ret_sts_error;
898: END IF;
899: IF p_dm_binvalues_rec.last_updated_by IS NULL THEN
900: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903: IF p_dm_binvalues_rec.creation_date IS NULL THEN
904: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');

Line 904: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');

900: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903: IF p_dm_binvalues_rec.creation_date IS NULL THEN
904: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');
905: x_return_status := FND_API.g_ret_sts_error;
906: END IF;
907: IF p_dm_binvalues_rec.created_by IS NULL THEN
908: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');

Line 908: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');

904: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');
905: x_return_status := FND_API.g_ret_sts_error;
906: END IF;
907: IF p_dm_binvalues_rec.created_by IS NULL THEN
908: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');
909: x_return_status := FND_API.g_ret_sts_error;
910: END IF;
911: IF p_dm_binvalues_rec.source_field_id IS NULL THEN
912: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

Line 912: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');

908: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');
909: x_return_status := FND_API.g_ret_sts_error;
910: END IF;
911: IF p_dm_binvalues_rec.source_field_id IS NULL THEN
912: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','SOURCE_FIELD_ID');
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: IF p_dm_binvalues_rec.bucket IS NULL THEN
916: --changed rosharma 07-may-2003 Bug # 2943269

Line 917: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BUCKET');

913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: IF p_dm_binvalues_rec.bucket IS NULL THEN
916: --changed rosharma 07-may-2003 Bug # 2943269
917: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BUCKET');
918: AMS_Utility_PVT.Error_Message('AMS_DM_NO_BUCKET');
919: --end change rosharma 07-may-2003 Bug # 2943269
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;

Line 918: AMS_Utility_PVT.Error_Message('AMS_DM_NO_BUCKET');

914: END IF;
915: IF p_dm_binvalues_rec.bucket IS NULL THEN
916: --changed rosharma 07-may-2003 Bug # 2943269
917: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','BUCKET');
918: AMS_Utility_PVT.Error_Message('AMS_DM_NO_BUCKET');
919: --end change rosharma 07-may-2003 Bug # 2943269
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;
922: END IF;

Line 936: IF AMS_Utility_PVT.check_fk_exists(

932: x_return_status := FND_API.g_ret_sts_success;
933:
934: --------------------source_field_id---------------------------
935: IF p_dm_binvalues_rec.source_field_id <> FND_API.g_miss_num THEN
936: IF AMS_Utility_PVT.check_fk_exists(
937: 'ams_list_src_fields',
938: 'list_source_field_id',
939: p_dm_binvalues_rec.source_field_id
940: ) = FND_API.g_false

Line 942: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'SOURCE_FIELD_ID');

938: 'list_source_field_id',
939: p_dm_binvalues_rec.source_field_id
940: ) = FND_API.g_false
941: THEN
942: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'SOURCE_FIELD_ID');
943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;
945: END IF;
946:

Line 1114: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

1110:
1111: -- Debug Message
1112: IF (AMS_DEBUG_HIGH_ON) THEN
1113:
1114: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1115: END IF;
1116:
1117: -- Standard call to check for call compatibility.
1118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1158: AMS_UTILITY_PVT.debug_message('After Validate_dm_binvalues_Rec return status = ' || x_return_status);

1154: IF (AMS_DEBUG_HIGH_ON) THEN
1155:
1156:
1157:
1158: AMS_UTILITY_PVT.debug_message('After Validate_dm_binvalues_Rec return status = ' || x_return_status);
1159:
1160: END IF;
1161:
1162: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1173: AMS_UTILITY_PVT.debug_message('After Validate_dm_binvalues_Rec return status = ' || x_return_status);

1169: IF (AMS_DEBUG_HIGH_ON) THEN
1170:
1171:
1172:
1173: AMS_UTILITY_PVT.debug_message('After Validate_dm_binvalues_Rec return status = ' || x_return_status);
1174:
1175: END IF;
1176:
1177: -- Initialize API return status to SUCCESS

Line 1184: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' return status = ' || x_return_status);

1180:
1181: -- Debug Message
1182: IF (AMS_DEBUG_HIGH_ON) THEN
1183:
1184: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' return status = ' || x_return_status);
1185: END IF;
1186:
1187: -- Standard call to get message count and if count is 1, get message info.
1188: FND_MSG_PUB.Count_And_Get

Line 1194: WHEN AMS_Utility_PVT.resource_locked THEN

1190: p_data => x_msg_data
1191: );
1192: EXCEPTION
1193:
1194: WHEN AMS_Utility_PVT.resource_locked THEN
1195: x_return_status := FND_API.g_ret_sts_error;
1196: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1197:
1198: WHEN FND_API.G_EXC_ERROR THEN

Line 1196: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1192: EXCEPTION
1193:
1194: WHEN AMS_Utility_PVT.resource_locked THEN
1195: x_return_status := FND_API.g_ret_sts_error;
1196: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1197:
1198: WHEN FND_API.G_EXC_ERROR THEN
1199: ROLLBACK TO VALIDATE_Dm_Binvalues_;
1200: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1247: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_binvalues_rec start');

1243: BEGIN
1244: -- Debug Message
1245: IF (AMS_DEBUG_HIGH_ON) THEN
1246:
1247: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_binvalues_rec start');
1248: END IF;
1249:
1250: -- Initialize message list if p_init_msg_list is set to TRUE.
1251: IF FND_API.to_Boolean( p_init_msg_list )

Line 1273: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_binvalues_rec end status = ' || x_return_status);

1269:
1270: -- Debug Message
1271: IF (AMS_DEBUG_HIGH_ON) THEN
1272:
1273: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_binvalues_rec end status = ' || x_return_status);
1274: END IF;
1275:
1276: END Validate_dm_binvalues_Rec;
1277: