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_ASSET_LOG_PVT dependencies on FND_API

Line 9: p_init_msg_list IN varchar2 := fnd_api.g_false,

5:
6: PROCEDURE insert_row(
7: p_log_id IN number := NULL,
8: p_api_version IN number := 1.0,
9: p_init_msg_list IN varchar2 := fnd_api.g_false,
10: p_commit IN varchar2 := fnd_api.g_false,
11: p_validation_level IN number := fnd_api.g_valid_level_full,
12: p_event_date IN date := sysdate,
13: p_event_type IN varchar2 := NULL,

Line 10: p_commit IN varchar2 := fnd_api.g_false,

6: PROCEDURE insert_row(
7: p_log_id IN number := NULL,
8: p_api_version IN number := 1.0,
9: p_init_msg_list IN varchar2 := fnd_api.g_false,
10: p_commit IN varchar2 := fnd_api.g_false,
11: p_validation_level IN number := fnd_api.g_valid_level_full,
12: p_event_date IN date := sysdate,
13: p_event_type IN varchar2 := NULL,
14: p_event_id IN number := NULL,

Line 11: p_validation_level IN number := fnd_api.g_valid_level_full,

7: p_log_id IN number := NULL,
8: p_api_version IN number := 1.0,
9: p_init_msg_list IN varchar2 := fnd_api.g_false,
10: p_commit IN varchar2 := fnd_api.g_false,
11: p_validation_level IN number := fnd_api.g_valid_level_full,
12: p_event_date IN date := sysdate,
13: p_event_type IN varchar2 := NULL,
14: p_event_id IN number := NULL,
15: p_organization_id IN number := NULL,

Line 67: IF NOT fnd_api.compatible_api_call(

63: -- Standard Start of API savepoint
64: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT fnd_api.compatible_api_call(
68: l_api_version
69: ,p_api_version
70: ,l_api_name
71: ,g_pkg_name) THEN

Line 72: RAISE fnd_api.g_exc_unexpected_error;

68: l_api_version
69: ,p_api_version
70: ,l_api_name
71: ,g_pkg_name) THEN
72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
74:
75: IF fnd_api.to_boolean(p_init_msg_list) THEN
76: fnd_msg_pub.initialize;

Line 75: IF fnd_api.to_boolean(p_init_msg_list) THEN

71: ,g_pkg_name) THEN
72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
74:
75: IF fnd_api.to_boolean(p_init_msg_list) THEN
76: fnd_msg_pub.initialize;
77: END IF;
78:
79: x_return_status := fnd_api.g_ret_sts_success;

Line 79: x_return_status := fnd_api.g_ret_sts_success;

75: IF fnd_api.to_boolean(p_init_msg_list) THEN
76: fnd_msg_pub.initialize;
77: END IF;
78:
79: x_return_status := fnd_api.g_ret_sts_success;
80:
81: -- VALIDATION Loggable Asset for System Events
82: IF p_event_type='EAM_SYSTEM_EVENTS' THEN
83: BEGIN

Line 101: x_return_status:= fnd_api.g_ret_sts_error;

97: , name => 'EAM_INSTANCE_ID_INVALID'
98: );
99:
100: fnd_msg_pub.add;
101: x_return_status:= fnd_api.g_ret_sts_error;
102: fnd_msg_pub.Count_And_Get
103: ( p_count => x_msg_count,
104: p_data => x_msg_data
105: );

Line 138: IF x_return_status = fnd_api.g_ret_sts_success THEN

134: x_return_status => x_return_status,
135: x_msg_count => x_msg_count,
136: x_msg_data => x_msg_data);
137:
138: IF x_return_status = fnd_api.g_ret_sts_success THEN
139:
140: IF (p_log_id IS NULL) THEN
141: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;
142: ELSE

Line 239: IF fnd_api.to_boolean(p_commit) THEN

235: END IF;
236:
237: -- End of API body.
238: -- Standard check of p_commit.
239: IF fnd_api.to_boolean(p_commit) THEN
240: COMMIT WORK;
241: END IF;
242: fnd_msg_pub.count_and_get(
243: p_count => x_msg_count

Line 246: WHEN fnd_api.g_exc_error THEN

242: fnd_msg_pub.count_and_get(
243: p_count => x_msg_count
244: ,p_data => x_msg_data);
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
247: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get(
250: p_count => x_msg_count

Line 248: x_return_status := fnd_api.g_ret_sts_error;

244: ,p_data => x_msg_data);
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
247: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get(
250: p_count => x_msg_count
251: ,p_data => x_msg_data);
252: WHEN fnd_api.g_exc_unexpected_error THEN

Line 252: WHEN fnd_api.g_exc_unexpected_error THEN

248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get(
250: p_count => x_msg_count
251: ,p_data => x_msg_data);
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get(
256: p_count => x_msg_count

Line 254: x_return_status := fnd_api.g_ret_sts_unexp_error;

250: p_count => x_msg_count
251: ,p_data => x_msg_data);
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get(
256: p_count => x_msg_count
257: ,p_data => x_msg_data);
258: WHEN OTHERS THEN

Line 260: x_return_status := fnd_api.g_ret_sts_unexp_error;

256: p_count => x_msg_count
257: ,p_data => x_msg_data);
258: WHEN OTHERS THEN
259: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: IF fnd_msg_pub.check_msg_level(
263: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
264: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 275: p_init_msg_list IN varchar2 := fnd_api.g_false,

271: END insert_row;
272:
273: PROCEDURE validate_event(
274: p_api_version IN number := 1.0,
275: p_init_msg_list IN varchar2 := fnd_api.g_false,
276: p_commit IN varchar2 := fnd_api.g_false,
277: p_validation_level IN number := fnd_api.g_valid_level_full,
278: p_event_date IN date := sysdate,
279: p_event_type IN varchar2 := NULL,

Line 276: p_commit IN varchar2 := fnd_api.g_false,

272:
273: PROCEDURE validate_event(
274: p_api_version IN number := 1.0,
275: p_init_msg_list IN varchar2 := fnd_api.g_false,
276: p_commit IN varchar2 := fnd_api.g_false,
277: p_validation_level IN number := fnd_api.g_valid_level_full,
278: p_event_date IN date := sysdate,
279: p_event_type IN varchar2 := NULL,
280: p_event_id IN number := NULL,

Line 277: p_validation_level IN number := fnd_api.g_valid_level_full,

273: PROCEDURE validate_event(
274: p_api_version IN number := 1.0,
275: p_init_msg_list IN varchar2 := fnd_api.g_false,
276: p_commit IN varchar2 := fnd_api.g_false,
277: p_validation_level IN number := fnd_api.g_valid_level_full,
278: p_event_date IN date := sysdate,
279: p_event_type IN varchar2 := NULL,
280: p_event_id IN number := NULL,
281: p_instance_id IN number := NULL,

Line 305: IF NOT fnd_api.compatible_api_call(

301: -- Standard Start of API savepoint
302: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT fnd_api.compatible_api_call(
306: l_api_version
307: ,p_api_version
308: ,l_api_name
309: ,g_pkg_name) THEN

Line 310: RAISE fnd_api.g_exc_unexpected_error;

306: l_api_version
307: ,p_api_version
308: ,l_api_name
309: ,g_pkg_name) THEN
310: RAISE fnd_api.g_exc_unexpected_error;
311: END IF;
312:
313: IF fnd_api.to_boolean(p_init_msg_list) THEN
314: fnd_msg_pub.initialize;

Line 313: IF fnd_api.to_boolean(p_init_msg_list) THEN

309: ,g_pkg_name) THEN
310: RAISE fnd_api.g_exc_unexpected_error;
311: END IF;
312:
313: IF fnd_api.to_boolean(p_init_msg_list) THEN
314: fnd_msg_pub.initialize;
315: END IF;
316:
317: x_return_status := fnd_api.g_ret_sts_success;

Line 317: x_return_status := fnd_api.g_ret_sts_success;

313: IF fnd_api.to_boolean(p_init_msg_list) THEN
314: fnd_msg_pub.initialize;
315: END IF;
316:
317: x_return_status := fnd_api.g_ret_sts_success;
318:
319: -- VALIDATION 1 Event Type
320:
321: IF (p_event_type IS NULL OR p_event_type NOT IN ('EAM_USER_EVENTS','EAM_OPERATIONAL_EVENTS'

Line 328: x_return_status:= fnd_api.g_ret_sts_error;

324: ( application => 'EAM'
325: , name => 'EAM_EVENT_TYPE_INVALID'
326: );
327: fnd_msg_pub.add;
328: x_return_status:= fnd_api.g_ret_sts_error;
329: fnd_msg_pub.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data
332: );

Line 346: x_return_status:= fnd_api.g_ret_sts_error;

342: , name => 'EAM_EVENT_DATE_INVALID'
343: );
344:
345: fnd_msg_pub.add;
346: x_return_status:= fnd_api.g_ret_sts_error;
347: fnd_msg_pub.Count_And_Get
348: ( p_count => x_msg_count,
349: p_data => x_msg_data
350: );

Line 373: x_return_status:= fnd_api.g_ret_sts_error;

369: , name => 'EAM_EVENT_ID_INVALID'
370: );
371:
372: fnd_msg_pub.add;
373: x_return_status:= fnd_api.g_ret_sts_error;
374: fnd_msg_pub.Count_And_Get
375: ( p_count => x_msg_count,
376: p_data => x_msg_data
377: );

Line 396: x_return_status:= fnd_api.g_ret_sts_error;

392: , name => 'EAM_INSTANCE_ID_INVALID'
393: );
394:
395: fnd_msg_pub.add;
396: x_return_status:= fnd_api.g_ret_sts_error;
397: fnd_msg_pub.Count_And_Get
398: ( p_count => x_msg_count,
399: p_data => x_msg_data
400: );

Line 425: x_return_status:= fnd_api.g_ret_sts_error;

421: , name => 'EAM_OPERABLE_INVALID'
422: );
423:
424: fnd_msg_pub.add;
425: x_return_status:= fnd_api.g_ret_sts_error;
426: fnd_msg_pub.Count_And_Get
427: ( p_count => x_msg_count,
428: p_data => x_msg_data
429: );

Line 453: x_return_status:= fnd_api.g_ret_sts_error;

449: , name => 'EAM_RET_MAT_INVALID_REASON'
450: );
451:
452: fnd_msg_pub.add;
453: x_return_status:= fnd_api.g_ret_sts_error;
454: fnd_msg_pub.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data
457: );

Line 480: x_return_status:= fnd_api.g_ret_sts_error;

476: ( application => 'EAM'
477: , name => 'EAM_RI_INSTANCE_INVALID'
478: );
479: fnd_msg_pub.add;
480: x_return_status:= fnd_api.g_ret_sts_error;
481: fnd_msg_pub.Count_And_Get
482: ( p_count => x_msg_count,
483: p_data => x_msg_data
484: );

Line 504: x_return_status:= fnd_api.g_ret_sts_error;

500: , name => 'EAM_DOWNCODE_INVALID'
501: );
502:
503: fnd_msg_pub.add;
504: x_return_status:= fnd_api.g_ret_sts_error;
505: fnd_msg_pub.Count_And_Get
506: ( p_count => x_msg_count,
507: p_data => x_msg_data
508: );

Line 517: WHEN fnd_api.g_exc_error THEN

513: */
514: END IF;
515:
516: EXCEPTION
517: WHEN fnd_api.g_exc_error THEN
518: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
519: x_return_status := fnd_api.g_ret_sts_error;
520: fnd_msg_pub.count_and_get(
521: p_count => x_msg_count

Line 519: x_return_status := fnd_api.g_ret_sts_error;

515:
516: EXCEPTION
517: WHEN fnd_api.g_exc_error THEN
518: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
519: x_return_status := fnd_api.g_ret_sts_error;
520: fnd_msg_pub.count_and_get(
521: p_count => x_msg_count
522: ,p_data => x_msg_data);
523: WHEN fnd_api.g_exc_unexpected_error THEN

Line 523: WHEN fnd_api.g_exc_unexpected_error THEN

519: x_return_status := fnd_api.g_ret_sts_error;
520: fnd_msg_pub.count_and_get(
521: p_count => x_msg_count
522: ,p_data => x_msg_data);
523: WHEN fnd_api.g_exc_unexpected_error THEN
524: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
525: x_return_status := fnd_api.g_ret_sts_unexp_error;
526: fnd_msg_pub.count_and_get(
527: p_count => x_msg_count

Line 525: x_return_status := fnd_api.g_ret_sts_unexp_error;

521: p_count => x_msg_count
522: ,p_data => x_msg_data);
523: WHEN fnd_api.g_exc_unexpected_error THEN
524: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
525: x_return_status := fnd_api.g_ret_sts_unexp_error;
526: fnd_msg_pub.count_and_get(
527: p_count => x_msg_count
528: ,p_data => x_msg_data);
529: WHEN OTHERS THEN

Line 531: x_return_status := fnd_api.g_ret_sts_unexp_error;

527: p_count => x_msg_count
528: ,p_data => x_msg_data);
529: WHEN OTHERS THEN
530: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: IF fnd_msg_pub.check_msg_level(
533: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
535: END IF;

Line 622: WHEN FND_API.G_EXC_ERROR THEN

618:
619: COMMIT;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
624: fnd_message.set_name('EAM','EAM_PURGE_EVENT_LOG_FAILURE');
625: errbuf := fnd_message.get();
626: retcode := 2;

Line 628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

624: fnd_message.set_name('EAM','EAM_PURGE_EVENT_LOG_FAILURE');
625: errbuf := fnd_message.get();
626: retcode := 2;
627: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
630: fnd_message.set_name('EAM','EAM_PURGE_EVENT_LOG_FAILURE');
631: errbuf := fnd_message.get();
632: retcode := 2;

Line 644: p_init_msg_list IN varchar2 := fnd_api.g_false,

640:
641: -- Procedure to Insert Log for Inventory Transactions
642: PROCEDURE instance_update_event(
643: p_api_version IN number := 1.0,
644: p_init_msg_list IN varchar2 := fnd_api.g_false,
645: p_commit IN varchar2 := fnd_api.g_false,
646: p_validation_level IN number := fnd_api.g_valid_level_full,
647: p_event_date IN date,
648: p_event_type IN varchar2 := 'EAM_SYSTEM_EVENTS',

Line 645: p_commit IN varchar2 := fnd_api.g_false,

641: -- Procedure to Insert Log for Inventory Transactions
642: PROCEDURE instance_update_event(
643: p_api_version IN number := 1.0,
644: p_init_msg_list IN varchar2 := fnd_api.g_false,
645: p_commit IN varchar2 := fnd_api.g_false,
646: p_validation_level IN number := fnd_api.g_valid_level_full,
647: p_event_date IN date,
648: p_event_type IN varchar2 := 'EAM_SYSTEM_EVENTS',
649: p_event_id IN number := NULL,

Line 646: p_validation_level IN number := fnd_api.g_valid_level_full,

642: PROCEDURE instance_update_event(
643: p_api_version IN number := 1.0,
644: p_init_msg_list IN varchar2 := fnd_api.g_false,
645: p_commit IN varchar2 := fnd_api.g_false,
646: p_validation_level IN number := fnd_api.g_valid_level_full,
647: p_event_date IN date,
648: p_event_type IN varchar2 := 'EAM_SYSTEM_EVENTS',
649: p_event_id IN number := NULL,
650: p_instance_id IN number,

Line 677: IF NOT FND_API.Compatible_API_Call

673: /* Standard Start of API savepoint */
674: SAVEPOINT EAM_ASSET_LOG_PVT;
675:
676: /* Standard call to check for call compatibility. */
677: IF NOT FND_API.Compatible_API_Call
678: ( l_api_version ,
679: p_api_version ,
680: l_api_name ,
681: G_PKG_NAME

Line 684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

680: l_api_name ,
681: G_PKG_NAME
682: )
683: THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687: /* Initialize message list if p_init_msg_list is set to TRUE. */
688: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 688: IF FND_API.to_Boolean( p_init_msg_list ) THEN

684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687: /* Initialize message list if p_init_msg_list is set to TRUE. */
688: IF FND_API.to_Boolean( p_init_msg_list ) THEN
689: fnd_msg_pub.initialize;
690: END IF;
691:
692: /* Initialize API return status to success */

Line 693: x_return_status := FND_API.G_RET_STS_SUCCESS;

689: fnd_msg_pub.initialize;
690: END IF;
691:
692: /* Initialize API return status to success */
693: x_return_status := FND_API.G_RET_STS_SUCCESS;
694:
695: BEGIN
696: SELECT mp.maint_organization_id INTO l_organization_id
697: FROM mtl_parameters mp, csi_item_instances cii

Line 709: x_return_status:= fnd_api.g_ret_sts_error;

705: , name => 'EAM_INSTANCE_ID_INVALID'
706: );
707:
708: fnd_msg_pub.add;
709: x_return_status:= fnd_api.g_ret_sts_error;
710: fnd_msg_pub.Count_And_Get
711: ( p_count => x_msg_count,
712: p_data => x_msg_data
713: );

Line 796: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

792: END IF;
793:
794: /* Standard check of p_commit. */
795:
796: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
797: COMMIT WORK;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.

Line 807: WHEN FND_API.G_EXC_ERROR THEN

803: ( p_msg_index_out => x_msg_count ,
804: p_data => x_msg_data
805: );
806: EXCEPTION
807: WHEN FND_API.G_EXC_ERROR THEN
808: ROLLBACK TO EAM_ASSET_LOG_PVT;
809: x_return_status := FND_API.G_RET_STS_ERROR ;
810: fnd_msg_pub.get
811: ( p_msg_index_out => x_msg_count ,

Line 809: x_return_status := FND_API.G_RET_STS_ERROR ;

805: );
806: EXCEPTION
807: WHEN FND_API.G_EXC_ERROR THEN
808: ROLLBACK TO EAM_ASSET_LOG_PVT;
809: x_return_status := FND_API.G_RET_STS_ERROR ;
810: fnd_msg_pub.get
811: ( p_msg_index_out => x_msg_count ,
812: p_data => x_msg_data
813: );

Line 814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

810: fnd_msg_pub.get
811: ( p_msg_index_out => x_msg_count ,
812: p_data => x_msg_data
813: );
814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
815: ROLLBACK TO EAM_ASSET_LOG_PVT;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: fnd_msg_pub.get
818: ( p_msg_index_out => x_msg_count ,

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

812: p_data => x_msg_data
813: );
814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
815: ROLLBACK TO EAM_ASSET_LOG_PVT;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: fnd_msg_pub.get
818: ( p_msg_index_out => x_msg_count ,
819: p_data => x_msg_data
820: );

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

819: p_data => x_msg_data
820: );
821: WHEN OTHERS THEN
822: ROLLBACK TO EAM_ASSET_LOG_PVT;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824:
825: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
826: fnd_msg_pub.add_exc_msg
827: ( G_PKG_NAME ,

Line 837: p_init_msg_list IN varchar2 := fnd_api.g_false,

833:
834: -- Procedure to Log Meter Transactions
835: PROCEDURE insert_meter_log(
836: p_api_version IN number := 1.0,
837: p_init_msg_list IN varchar2 := fnd_api.g_false,
838: p_commit IN varchar2 := fnd_api.g_false,
839: p_validation_level IN number := fnd_api.g_valid_level_full,
840: p_event_date IN date := sysdate,
841: p_instance_id IN number := NULL,

Line 838: p_commit IN varchar2 := fnd_api.g_false,

834: -- Procedure to Log Meter Transactions
835: PROCEDURE insert_meter_log(
836: p_api_version IN number := 1.0,
837: p_init_msg_list IN varchar2 := fnd_api.g_false,
838: p_commit IN varchar2 := fnd_api.g_false,
839: p_validation_level IN number := fnd_api.g_valid_level_full,
840: p_event_date IN date := sysdate,
841: p_instance_id IN number := NULL,
842: p_ref_id IN number,

Line 839: p_validation_level IN number := fnd_api.g_valid_level_full,

835: PROCEDURE insert_meter_log(
836: p_api_version IN number := 1.0,
837: p_init_msg_list IN varchar2 := fnd_api.g_false,
838: p_commit IN varchar2 := fnd_api.g_false,
839: p_validation_level IN number := fnd_api.g_valid_level_full,
840: p_event_date IN date := sysdate,
841: p_instance_id IN number := NULL,
842: p_ref_id IN number,
843: p_attribute_category IN varchar2 := NULL,

Line 887: IF NOT fnd_api.compatible_api_call(

883: -- Standard Start of API savepoint
884: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
885:
886: -- Standard call to check for call compatibility.
887: IF NOT fnd_api.compatible_api_call(
888: l_api_version
889: ,p_api_version
890: ,l_api_name
891: ,g_pkg_name) THEN

Line 892: RAISE fnd_api.g_exc_unexpected_error;

888: l_api_version
889: ,p_api_version
890: ,l_api_name
891: ,g_pkg_name) THEN
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;
894:
895: IF fnd_api.to_boolean(p_init_msg_list) THEN
896: fnd_msg_pub.initialize;

Line 895: IF fnd_api.to_boolean(p_init_msg_list) THEN

891: ,g_pkg_name) THEN
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;
894:
895: IF fnd_api.to_boolean(p_init_msg_list) THEN
896: fnd_msg_pub.initialize;
897: END IF;
898:
899: x_return_status := fnd_api.g_ret_sts_success;

Line 899: x_return_status := fnd_api.g_ret_sts_success;

895: IF fnd_api.to_boolean(p_init_msg_list) THEN
896: fnd_msg_pub.initialize;
897: END IF;
898:
899: x_return_status := fnd_api.g_ret_sts_success;
900: BEGIN
901: SELECT counter_id INTO l_status
902: FROM csi_counters_b
903: WHERE counter_id = p_ref_id AND

Line 916: x_return_status:= fnd_api.g_ret_sts_error;

912: , name => 'EAM_COUNTER_ID_INVALID'
913: );
914:
915: fnd_msg_pub.add;
916: x_return_status:= fnd_api.g_ret_sts_error;
917: fnd_msg_pub.count_and_get(
918: p_count => x_msg_count,
919: p_data => x_msg_data);
920: RETURN;

Line 937: x_return_status:= fnd_api.g_ret_sts_error;

933: , name => 'EAM_COUNTER_ID_INVALID'
934: );
935:
936: fnd_msg_pub.add;
937: x_return_status:= fnd_api.g_ret_sts_error;
938: fnd_msg_pub.count_and_get(
939: p_count => x_msg_count,
940: p_data => x_msg_data);
941: RETURN;

Line 964: IF x_return_status = fnd_api.g_ret_sts_success THEN

960: x_msg_count => x_msg_count,
961: x_msg_data => x_msg_data);
962:
963:
964: IF x_return_status = fnd_api.g_ret_sts_success THEN
965:
966: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;
967:
968: EAM_ASSET_LOG_PVT.insert_row(

Line 986: IF fnd_api.to_boolean(p_commit) THEN

982: END LOOP;
983:
984: -- End of API body.
985: -- Standard check of p_commit.
986: IF fnd_api.to_boolean(p_commit) THEN
987: COMMIT WORK;
988: END IF;
989:
990: fnd_msg_pub.count_and_get(

Line 995: WHEN fnd_api.g_exc_error THEN

991: p_count => x_msg_count
992: ,p_data => x_msg_data);
993:
994: EXCEPTION
995: WHEN fnd_api.g_exc_error THEN
996: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
997: x_return_status := fnd_api.g_ret_sts_error;
998: fnd_msg_pub.count_and_get(
999: p_count => x_msg_count

Line 997: x_return_status := fnd_api.g_ret_sts_error;

993:
994: EXCEPTION
995: WHEN fnd_api.g_exc_error THEN
996: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
997: x_return_status := fnd_api.g_ret_sts_error;
998: fnd_msg_pub.count_and_get(
999: p_count => x_msg_count
1000: ,p_data => x_msg_data);
1001: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1001: WHEN fnd_api.g_exc_unexpected_error THEN

997: x_return_status := fnd_api.g_ret_sts_error;
998: fnd_msg_pub.count_and_get(
999: p_count => x_msg_count
1000: ,p_data => x_msg_data);
1001: WHEN fnd_api.g_exc_unexpected_error THEN
1002: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_msg_pub.count_and_get(
1005: p_count => x_msg_count

Line 1003: x_return_status := fnd_api.g_ret_sts_unexp_error;

999: p_count => x_msg_count
1000: ,p_data => x_msg_data);
1001: WHEN fnd_api.g_exc_unexpected_error THEN
1002: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_msg_pub.count_and_get(
1005: p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007: WHEN OTHERS THEN

Line 1009: x_return_status := fnd_api.g_ret_sts_unexp_error;

1005: p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007: WHEN OTHERS THEN
1008: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010:
1011: IF fnd_msg_pub.check_msg_level(
1012: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1013: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);