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 682: IF NOT FND_API.Compatible_API_Call

678: /* Standard Start of API savepoint */
679: SAVEPOINT EAM_ASSET_LOG_PVT;
680:
681: /* Standard call to check for call compatibility. */
682: IF NOT FND_API.Compatible_API_Call
683: ( l_api_version ,
684: p_api_version ,
685: l_api_name ,
686: G_PKG_NAME

Line 689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

685: l_api_name ,
686: G_PKG_NAME
687: )
688: THEN
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
690: END IF;
691:
692: /* Initialize message list if p_init_msg_list is set to TRUE. */
693: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 693: IF FND_API.to_Boolean( p_init_msg_list ) THEN

689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
690: END IF;
691:
692: /* Initialize message list if p_init_msg_list is set to TRUE. */
693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
694: fnd_msg_pub.initialize;
695: END IF;
696:
697: /* Initialize API return status to success */

Line 698: x_return_status := FND_API.G_RET_STS_SUCCESS;

694: fnd_msg_pub.initialize;
695: END IF;
696:
697: /* Initialize API return status to success */
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700: BEGIN
701: SELECT mp.maint_organization_id INTO l_organization_id
702: FROM mtl_parameters mp, csi_item_instances cii

Line 714: x_return_status:= fnd_api.g_ret_sts_error;

710: , name => 'EAM_INSTANCE_ID_INVALID'
711: );
712:
713: fnd_msg_pub.add;
714: x_return_status:= fnd_api.g_ret_sts_error;
715: fnd_msg_pub.Count_And_Get
716: ( p_count => x_msg_count,
717: p_data => x_msg_data
718: );

Line 1140: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN

1136: END IF;
1137:
1138: /* Standard check of p_commit. */
1139:
1140: IF FND_API.TO_BOOLEAN( P_COMMIT ) THEN
1141: COMMIT WORK;
1142: END IF;
1143:
1144: -- Standard call to get message count and if count is 1, get message info.

Line 1151: WHEN FND_API.G_EXC_ERROR THEN

1147: ( p_msg_index_out => x_msg_count ,
1148: p_data => x_msg_data
1149: );
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: ROLLBACK TO EAM_ASSET_LOG_PVT;
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: fnd_msg_pub.get
1155: ( p_msg_index_out => x_msg_count ,

Line 1153: x_return_status := FND_API.G_RET_STS_ERROR ;

1149: );
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: ROLLBACK TO EAM_ASSET_LOG_PVT;
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: fnd_msg_pub.get
1155: ( p_msg_index_out => x_msg_count ,
1156: p_data => x_msg_data
1157: );

Line 1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1154: fnd_msg_pub.get
1155: ( p_msg_index_out => x_msg_count ,
1156: p_data => x_msg_data
1157: );
1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1159: ROLLBACK TO EAM_ASSET_LOG_PVT;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: fnd_msg_pub.get
1162: ( p_msg_index_out => x_msg_count ,

Line 1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1156: p_data => x_msg_data
1157: );
1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1159: ROLLBACK TO EAM_ASSET_LOG_PVT;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: fnd_msg_pub.get
1162: ( p_msg_index_out => x_msg_count ,
1163: p_data => x_msg_data
1164: );

Line 1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1163: p_data => x_msg_data
1164: );
1165: WHEN OTHERS THEN
1166: ROLLBACK TO EAM_ASSET_LOG_PVT;
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168:
1169: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1170: fnd_msg_pub.add_exc_msg
1171: ( G_PKG_NAME ,

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

1177:
1178: -- Procedure to Log Meter Transactions
1179: PROCEDURE insert_meter_log(
1180: p_api_version IN number := 1.0,
1181: p_init_msg_list IN varchar2 := fnd_api.g_false,
1182: p_commit IN varchar2 := fnd_api.g_false,
1183: p_validation_level IN number := fnd_api.g_valid_level_full,
1184: p_event_date IN date := sysdate,
1185: p_instance_id IN number := NULL,

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

1178: -- Procedure to Log Meter Transactions
1179: PROCEDURE insert_meter_log(
1180: p_api_version IN number := 1.0,
1181: p_init_msg_list IN varchar2 := fnd_api.g_false,
1182: p_commit IN varchar2 := fnd_api.g_false,
1183: p_validation_level IN number := fnd_api.g_valid_level_full,
1184: p_event_date IN date := sysdate,
1185: p_instance_id IN number := NULL,
1186: p_ref_id IN number,

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

1179: PROCEDURE insert_meter_log(
1180: p_api_version IN number := 1.0,
1181: p_init_msg_list IN varchar2 := fnd_api.g_false,
1182: p_commit IN varchar2 := fnd_api.g_false,
1183: p_validation_level IN number := fnd_api.g_valid_level_full,
1184: p_event_date IN date := sysdate,
1185: p_instance_id IN number := NULL,
1186: p_ref_id IN number,
1187: p_attribute_category IN varchar2 := NULL,

Line 1231: IF NOT fnd_api.compatible_api_call(

1227: -- Standard Start of API savepoint
1228: SAVEPOINT EAM_ASSET_LOG_PVT_SV;
1229:
1230: -- Standard call to check for call compatibility.
1231: IF NOT fnd_api.compatible_api_call(
1232: l_api_version
1233: ,p_api_version
1234: ,l_api_name
1235: ,g_pkg_name) THEN

Line 1236: RAISE fnd_api.g_exc_unexpected_error;

1232: l_api_version
1233: ,p_api_version
1234: ,l_api_name
1235: ,g_pkg_name) THEN
1236: RAISE fnd_api.g_exc_unexpected_error;
1237: END IF;
1238:
1239: IF fnd_api.to_boolean(p_init_msg_list) THEN
1240: fnd_msg_pub.initialize;

Line 1239: IF fnd_api.to_boolean(p_init_msg_list) THEN

1235: ,g_pkg_name) THEN
1236: RAISE fnd_api.g_exc_unexpected_error;
1237: END IF;
1238:
1239: IF fnd_api.to_boolean(p_init_msg_list) THEN
1240: fnd_msg_pub.initialize;
1241: END IF;
1242:
1243: x_return_status := fnd_api.g_ret_sts_success;

Line 1243: x_return_status := fnd_api.g_ret_sts_success;

1239: IF fnd_api.to_boolean(p_init_msg_list) THEN
1240: fnd_msg_pub.initialize;
1241: END IF;
1242:
1243: x_return_status := fnd_api.g_ret_sts_success;
1244: BEGIN
1245: SELECT counter_id INTO l_status
1246: FROM csi_counters_b
1247: WHERE counter_id = p_ref_id AND

Line 1260: x_return_status:= fnd_api.g_ret_sts_error;

1256: , name => 'EAM_COUNTER_ID_INVALID'
1257: );
1258:
1259: fnd_msg_pub.add;
1260: x_return_status:= fnd_api.g_ret_sts_error;
1261: fnd_msg_pub.count_and_get(
1262: p_count => x_msg_count,
1263: p_data => x_msg_data);
1264: RETURN;

Line 1281: x_return_status:= fnd_api.g_ret_sts_error;

1277: , name => 'EAM_COUNTER_ID_INVALID'
1278: );
1279:
1280: fnd_msg_pub.add;
1281: x_return_status:= fnd_api.g_ret_sts_error;
1282: fnd_msg_pub.count_and_get(
1283: p_count => x_msg_count,
1284: p_data => x_msg_data);
1285: RETURN;

Line 1308: IF x_return_status = fnd_api.g_ret_sts_success THEN

1304: x_msg_count => x_msg_count,
1305: x_msg_data => x_msg_data);
1306:
1307:
1308: IF x_return_status = fnd_api.g_ret_sts_success THEN
1309:
1310: SELECT eam_asset_log_s.nextval INTO l_log_id FROM dual;
1311:
1312: EAM_ASSET_LOG_PVT.insert_row(

Line 1330: IF fnd_api.to_boolean(p_commit) THEN

1326: END LOOP;
1327:
1328: -- End of API body.
1329: -- Standard check of p_commit.
1330: IF fnd_api.to_boolean(p_commit) THEN
1331: COMMIT WORK;
1332: END IF;
1333:
1334: fnd_msg_pub.count_and_get(

Line 1339: WHEN fnd_api.g_exc_error THEN

1335: p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337:
1338: EXCEPTION
1339: WHEN fnd_api.g_exc_error THEN
1340: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: fnd_msg_pub.count_and_get(
1343: p_count => x_msg_count

Line 1341: x_return_status := fnd_api.g_ret_sts_error;

1337:
1338: EXCEPTION
1339: WHEN fnd_api.g_exc_error THEN
1340: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: fnd_msg_pub.count_and_get(
1343: p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1345: WHEN fnd_api.g_exc_unexpected_error THEN

1341: x_return_status := fnd_api.g_ret_sts_error;
1342: fnd_msg_pub.count_and_get(
1343: p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1347: x_return_status := fnd_api.g_ret_sts_unexp_error;
1348: fnd_msg_pub.count_and_get(
1349: p_count => x_msg_count

Line 1347: x_return_status := fnd_api.g_ret_sts_unexp_error;

1343: p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1347: x_return_status := fnd_api.g_ret_sts_unexp_error;
1348: fnd_msg_pub.count_and_get(
1349: p_count => x_msg_count
1350: ,p_data => x_msg_data);
1351: WHEN OTHERS THEN

Line 1353: x_return_status := fnd_api.g_ret_sts_unexp_error;

1349: p_count => x_msg_count
1350: ,p_data => x_msg_data);
1351: WHEN OTHERS THEN
1352: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1353: x_return_status := fnd_api.g_ret_sts_unexp_error;
1354:
1355: IF fnd_msg_pub.check_msg_level(
1356: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1357: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);