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.EAM_METERASSOC_PUB dependencies on FND_LOG

Line 93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

89: l_exists_primary_flag varchar2(1);
90: l_required_flag varchar2(1) := 'N';
91:
92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97: l_exists NUMBER := 0;

Line 94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

90: l_required_flag varchar2(1) := 'N';
91:
92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97: l_exists NUMBER := 0;
98: l_association_id NUMBER;

Line 95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

91:
92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97: l_exists NUMBER := 0;
98: l_association_id NUMBER;
99: l_object_version_number NUMBER;

Line 96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97: l_exists NUMBER := 0;
98: l_association_id NUMBER;
99: l_object_version_number NUMBER;
100:

Line 109: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

105: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
106: END IF;
107:
108: IF (l_plog) THEN
109: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
110: '==================== Entered EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');
111: END IF;
112: /* Standard call to check for call compatibility. */
113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

129:
130: /* API body */
131:
132: IF (l_plog) THEN
133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
134: 'x_return_status: '||x_return_status);
135: END IF;
136:
137: IF (p_start_date_active IS NULL) THEN

Line 192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

188: l_ctr_item_association_rec.attribute15 := p_attribute15;
189: -- l_ctr_item_association_rec.maint_organization_id := p_organization_id;
190:
191: IF (l_plog) THEN
192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
193: '==================== Calling csi_counter_template_pub.create_item_association ===================='
194: ||'x_return_status:'||x_return_status
195: ||' x_msg_count:'||x_msg_count
196: ||'x_msg_data:'||x_msg_data);

Line 208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

204: x_return_status,
205: x_msg_count,
206: x_msg_data);
207: IF (l_plog) THEN
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
209: '==================== Returned from csi_counter_template_pub.create_item_association ===================='
210: ||'x_return_status:'||x_return_status
211: ||' x_msg_count:'||x_msg_count
212: ||'x_msg_data:'||x_msg_data);

Line 228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

224: WHERE serial_number = p_asset_number
225: AND inventory_item_id = p_asset_group_id;
226:
227: IF (l_plog) THEN
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
229: 'l_maintenance_object_id:'||l_maintenance_object_id);
230: END IF;
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN

Line 296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

292: l_exists := 0;
293: END;
294:
295: IF (l_plog) THEN
296: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
297: '==================== Calling csi_counter_pub.create_ctr_associations ===================='
298: ||'x_return_status:'||x_return_status
299: ||' x_msg_count:'||x_msg_count
300: ||'x_msg_data:'||x_msg_data);

Line 336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

332: l_instance_association_id);
333: end if;
334:
335: IF (l_plog) THEN
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
337: '==================== Returned from csi_counter_pub.create_ctr_associations ===================='
338: ||'x_return_status:'||x_return_status
339: ||' x_msg_count:'||x_msg_count
340: ||'x_msg_data:'||x_msg_data);

Line 352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');

348: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
349:
350: COMMIT WORK;
351: IF (l_plog) THEN
352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');
353: END IF;
354: END IF;
355:
356: IF (l_plog) THEN

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

353: END IF;
354: END IF;
355:
356: IF (l_plog) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
358: '==================== Calling FND_MSG_PUB.get ====================');
359: END IF;
360:
361: -- Standard call to get message count and if count is 1, get message info.

Line 368: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

364: p_data => x_msg_data
365: );
366:
367: IF (l_plog) THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
369: '==================== Returned from FND_MSG_PUB.get ====================');
370:
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
372: '==================== Exiting EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');

Line 371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

367: IF (l_plog) THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
369: '==================== Returned from FND_MSG_PUB.get ====================');
370:
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
372: '==================== Exiting EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');
373: END IF;
374:
375: EXCEPTION

Line 380: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');

376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: IF (l_plog) THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');
381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
382: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||
383: '==================== Calling FND_MSG_PUB.get ====================');
384: END IF;

Line 381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

377: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: IF (l_plog) THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');
381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
382: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||
383: '==================== Calling FND_MSG_PUB.get ====================');
384: END IF;
385: FND_MSG_PUB.get

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

386: ( p_msg_index_out => x_msg_count ,
387: p_data => x_msg_data
388: );
389: IF (l_plog) THEN
390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
391: '==================== Returned from FND_MSG_PUB.get ====================');
392: END IF;
393:
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 398: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');

394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: IF (l_plog) THEN
398: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');
399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
400: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||
401: '==================== Calling FND_MSG_PUB.get ====================');
402: END IF;

Line 399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

395: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397: IF (l_plog) THEN
398: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');
399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
400: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||
401: '==================== Calling FND_MSG_PUB.get ====================');
402: END IF;
403: FND_MSG_PUB.get

Line 408: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

404: ( p_msg_index_out => x_msg_count ,
405: p_data => x_msg_data
406: );
407: IF (l_plog) THEN
408: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
409: '==================== Returned from FND_MSG_PUB.get ====================');
410: END IF;
411:
412: WHEN OTHERS THEN

Line 416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

412: WHEN OTHERS THEN
413: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
415: IF (l_plog) THEN
416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
418: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');
419: END IF;
420:

Line 417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

413: ROLLBACK TO Insert_AssetMeterAssoc_PUB;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
415: IF (l_plog) THEN
416: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
418: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');
419: END IF;
420:
421: IF FND_MSG_PUB.Check_Msg_Level

Line 425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

421: IF FND_MSG_PUB.Check_Msg_Level
422: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
423: THEN
424: IF (l_plog) THEN
425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
426: '==================== Calling FND_MSG_PUB.Add_Exc_Msg ====================');
427: END IF;
428: FND_MSG_PUB.Add_Exc_Msg
429: ( G_PKG_NAME ,

Line 433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

429: ( G_PKG_NAME ,
430: l_api_name
431: );
432: IF (l_plog) THEN
433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
434: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
435: END IF;
436:
437: END IF;

Line 440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

436:
437: END IF;
438:
439: IF (l_plog) THEN
440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
441: '==================== Calling FND_MSG_PUB.get ====================');
442: END IF;
443:
444: FND_MSG_PUB.get

Line 449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

445: ( p_msg_index_out => x_msg_count ,
446: p_data => x_msg_data
447: );
448: IF (l_plog) THEN
449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
450: '==================== Returned from FND_MSG_PUB.get ====================');
451: END IF;
452:
453: END Insert_AssetMeterAssoc;

Line 521: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

517: l_maint_object_id Number;
518: l_exists_primary_flag varchar2(1);
519:
520: l_module varchar2(200);
521: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
522: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
523: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
524: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
525: BEGIN

Line 522: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

518: l_exists_primary_flag varchar2(1);
519:
520: l_module varchar2(200);
521: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
522: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
523: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
524: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
525: BEGIN
526: /* Standard Start of API savepoint */

Line 523: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

519:
520: l_module varchar2(200);
521: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
522: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
523: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
524: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
525: BEGIN
526: /* Standard Start of API savepoint */
527: SAVEPOINT Update_AssetMeterAssoc_PUB;

Line 524: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

520: l_module varchar2(200);
521: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
522: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
523: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
524: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
525: BEGIN
526: /* Standard Start of API savepoint */
527: SAVEPOINT Update_AssetMeterAssoc_PUB;
528: IF (l_ulog) THEN

Line 533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

529: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
530: END IF;
531:
532: IF (l_plog) THEN
533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
534: '==================== Entered EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');
535: END IF;
536:
537: /* Standard call to check for call compatibility. */

Line 555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

551:
552: /* Initialize API return status to success */
553: x_return_status := FND_API.G_RET_STS_SUCCESS;
554: IF (l_plog) THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
556: 'x_return_status:'||x_return_status);
557: END IF;
558: /* API body */
559:

Line 568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

564: FROM csi_ctr_item_associations ccia
565: WHERE ccia.ctr_association_id = p_association_id;
566:
567: IF (l_plog) THEN
568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
569: 'l_object_version_number:'||l_object_version_number);
570: END IF;
571:
572: begin

Line 621: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

617: l_ctr_item_association_rec.attribute14 := p_attribute14;
618: l_ctr_item_association_rec.attribute15 := p_attribute15;
619:
620: IF (l_plog) THEN
621: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
622: '==================== Calling csi_counter_template_pub.update_item_association ===================='
623: ||'x_return_status:'||x_return_status
624: ||' x_msg_count:'||x_msg_count
625: ||'x_msg_data:'||x_msg_data);

Line 636: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

632: x_return_status,
633: x_msg_count,
634: x_msg_data);
635: IF (l_plog) THEN
636: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
637: '==================== Returned from csi_counter_template_pub.update_item_association ===================='
638: ||'x_return_status:'||x_return_status
639: ||' x_msg_count:'||x_msg_count
640: ||'x_msg_data:'||x_msg_data);

Line 650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

646: FROM csi_counter_associations cca
647: WHERE cca.instance_association_id = p_association_id;
648:
649: IF (l_plog) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
651: 'l_object_version_number:'||l_object_version_number);
652: END IF;
653:
654:

Line 703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

699: l_counter_associations_tbl(1).attribute14 := p_attribute14;
700: l_counter_associations_tbl(1).attribute15 := p_attribute15;
701:
702: IF (l_plog) THEN
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
704: '==================== Calling csi_counter_template_pub.update_ctr_associations ===================='
705: ||'x_return_status:'||x_return_status
706: ||' x_msg_count:'||x_msg_count
707: ||'x_msg_data:'||x_msg_data);

Line 718: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

714: x_return_status,
715: x_msg_count,
716: x_msg_data);
717: IF (l_plog) THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
719: '==================== Returned from csi_counter_template_pub.update_ctr_associations ===================='
720: ||'x_return_status:'||x_return_status
721: ||' x_msg_count:'||x_msg_count
722: ||'x_msg_data:'||x_msg_data);

Line 731: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');

727: /* Standard check of p_commit. */
728: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
729: COMMIT WORK;
730: IF (l_plog) THEN
731: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'Commiting Work');
732: END IF;
733: END IF;
734:
735: IF (l_plog) THEN

Line 736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

732: END IF;
733: END IF;
734:
735: IF (l_plog) THEN
736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
737: '==================== Calling FND_MSG_PUB.get ====================');
738: END IF;
739:
740: -- Standard call to get message count and if count is 1, get message info.

Line 746: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

742: ( p_msg_index_out => x_msg_count ,
743: p_data => x_msg_data
744: );
745: IF (l_plog) THEN
746: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
747: '==================== Returned from FND_MSG_PUB.get ====================');
748:
749: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
750: '==================== Exiting EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');

Line 749: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

745: IF (l_plog) THEN
746: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
747: '==================== Returned from FND_MSG_PUB.get ====================');
748:
749: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
750: '==================== Exiting EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');
751: END IF;
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN

Line 759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

755:
756: x_return_status := FND_API.G_RET_STS_ERROR ;
757:
758: IF (l_plog) THEN
759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
761: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||
762: '==================== Calling FND_MSG_PUB.get ====================');
763: END IF;

Line 760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

756: x_return_status := FND_API.G_RET_STS_ERROR ;
757:
758: IF (l_plog) THEN
759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
760: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
761: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||
762: '==================== Calling FND_MSG_PUB.get ====================');
763: END IF;
764:

Line 771: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

767: p_data => x_msg_data
768: );
769:
770: IF (l_plog) THEN
771: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
772: '==================== Returned from FND_MSG_PUB.get ====================');
773: END IF;
774:
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 780: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

776:
777: ROLLBACK TO Update_AssetMeterAssoc_PUB;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779: IF (l_plog) THEN
780: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
782: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||
783: '==================== Calling FND_MSG_PUB.get ====================');
784: END IF;

Line 781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

777: ROLLBACK TO Update_AssetMeterAssoc_PUB;
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779: IF (l_plog) THEN
780: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
782: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||
783: '==================== Calling FND_MSG_PUB.get ====================');
784: END IF;
785: FND_MSG_PUB.get

Line 790: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

786: ( p_msg_index_out => x_msg_count ,
787: p_data => x_msg_data
788: );
789: IF (l_plog) THEN
790: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
791: '==================== Returned from FND_MSG_PUB.get ====================');
792: END IF;
793:
794: WHEN OTHERS THEN

Line 799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

795: ROLLBACK TO Update_AssetMeterAssoc_PUB;
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
797:
798: IF (l_plog) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
801: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');
802: END IF;
803:

Line 800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
797:
798: IF (l_plog) THEN
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
801: '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');
802: END IF;
803:
804: IF FND_MSG_PUB.Check_Msg_Level

Line 808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

804: IF FND_MSG_PUB.Check_Msg_Level
805: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: IF (l_plog) THEN
808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
809: '==================== Calling FND_MSG_PUB.Add_Exc_Msg ====================');
810: END IF;
811:
812: FND_MSG_PUB.Add_Exc_Msg

Line 818: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

814: l_api_name
815: );
816:
817: IF (l_plog) THEN
818: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
819: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
820: END IF;
821: END IF;
822: IF (l_plog) THEN

Line 823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

819: '==================== Returned from FND_MSG_PUB.Add_Exc_Msg ====================');
820: END IF;
821: END IF;
822: IF (l_plog) THEN
823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
824: '==================== Calling FND_MSG_PUB.get ====================');
825: END IF;
826: FND_MSG_PUB.get
827: ( p_msg_index_out => x_msg_count ,

Line 831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

827: ( p_msg_index_out => x_msg_count ,
828: p_data => x_msg_data
829: );
830: IF (l_plog) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
832: '==================== Returned from FND_MSG_PUB.get ====================');
833: END IF;
834: END Update_AssetMeterAssoc;
835:

Line 842: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

838: PROCEDURE RAISE_ERROR (ERROR VARCHAR2)
839: IS
840: l_api_name CONSTANT VARCHAR2(30) :='Insert_AssetMeterAssoc';
841: l_module varchar2(200);
842: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
843: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
844: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
845: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
846:

Line 843: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

839: IS
840: l_api_name CONSTANT VARCHAR2(30) :='Insert_AssetMeterAssoc';
841: l_module varchar2(200);
842: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
843: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
844: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
845: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
846:
847: BEGIN

Line 844: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

840: l_api_name CONSTANT VARCHAR2(30) :='Insert_AssetMeterAssoc';
841: l_module varchar2(200);
842: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
843: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
844: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
845: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
846:
847: BEGIN
848: /* debugging */

Line 845: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

841: l_module varchar2(200);
842: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
843: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
844: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
845: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
846:
847: BEGIN
848: /* debugging */
849: IF (l_ulog) THEN

Line 854: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

850: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
851: END IF;
852:
853: IF (l_plog) THEN
854: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
855: '==================== Entered EAM_MeterAssoc_PUB.RAISE_ERROR ====================');
856: END IF;
857: FND_MESSAGE.SET_NAME ('EAM', ERROR);
858: FND_MSG_PUB.ADD;

Line 861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

857: FND_MESSAGE.SET_NAME ('EAM', ERROR);
858: FND_MSG_PUB.ADD;
859:
860: IF (l_plog) THEN
861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
862: '==================== Exiting EAM_MeterAssoc_PUB.RAISE_ERROR ====================');
863: END IF;
864: RAISE FND_API.G_EXC_ERROR;
865: