APPS.AMS_ADI_MEDIA_PLANNER_PVT dependencies on AMS_ADI_COMMON_PVT

Line 104: l_err_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t :=

100: IS
101: L_API_NAME CONSTANT VARCHAR2(30) := 'load_metrics';
102: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
103: l_interface_rec ams_adi_media_planner%ROWTYPE;
104: l_err_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t :=
105: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
106: BEGIN
107: IF fnd_api.to_boolean (p_init_msg_list) THEN
108: fnd_msg_pub.initialize;

Line 105: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();

101: L_API_NAME CONSTANT VARCHAR2(30) := 'load_metrics';
102: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
103: l_interface_rec ams_adi_media_planner%ROWTYPE;
104: l_err_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t :=
105: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
106: BEGIN
107: IF fnd_api.to_boolean (p_init_msg_list) THEN
108: fnd_msg_pub.initialize;
109: END IF;

Line 216: p_err_recs IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,

212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_media_planner_rec IN ams_adi_media_planner%ROWTYPE,
216: p_err_recs IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2
220: )

Line 376: AMS_ADI_COMMON_PVT.handle_error_row(

372: 'Return Status Create_ActMetric: '||l_return_status);
373: END IF;
374:
375: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
376: AMS_ADI_COMMON_PVT.handle_error_row(
377: p_write_conc_log => FND_API.G_TRUE,
378: p_rollback => FND_API.G_FALSE,
379: p_error_code => NULL,
380: p_error_message => NULL,

Line 423: AMS_ADI_COMMON_PVT.handle_error_row(

419: ': OVN='||l_table_of_metrics(i).object_version_number);
420: END IF;
421:
422: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: AMS_ADI_COMMON_PVT.handle_error_row(
424: p_write_conc_log => FND_API.G_TRUE,
425: p_rollback => FND_API.G_FALSE,
426: p_error_code => NULL,
427: p_error_message => NULL,

Line 441: AMS_ADI_COMMON_PVT.handle_success_row(p_commit);

437:
438: END IF; -- COUNT >0
439:
440: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
441: AMS_ADI_COMMON_PVT.handle_success_row(p_commit);
442: ELSE
443: ROLLBACK TO LOAD_METRICS_SP;
444: END IF;
445:

Line 502: l_err_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t :=

498: L_API_NAME CONSTANT VARCHAR2(30) := 'LOAD_REQUEST';
499: l_return_status VARCHAR2(1);
500: l_msg_count NUMBER;
501: l_msg_data VARCHAR2(4000);
502: l_err_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t :=
503: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
504:
505: CURSOR c_interface IS
506: SELECT *

Line 503: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();

499: l_return_status VARCHAR2(1);
500: l_msg_count NUMBER;
501: l_msg_data VARCHAR2(4000);
502: l_err_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t :=
503: AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
504:
505: CURSOR c_interface IS
506: SELECT *
507: FROM ams_adi_media_planner

Line 523: AMS_ADI_COMMON_PVT.init();

519: -- : bulk load metrics from interface table
520: -- bulk_interface_into_recs (l_interface_recs);
521:
522: --Call init method to initialize
523: AMS_ADI_COMMON_PVT.init();
524:
525: FOR l_interface_recs IN c_interface LOOP
526: load_metrics (
527: p_api_version => 1.0,

Line 551: AMS_ADI_COMMON_PVT.complete_batch(

547: AMS_UTILITY_PVT.Write_Conc_Log('Public API: load_request upload '||
548: 'batch id : '||p_upload_batch_id||'. Done load');
549: END IF;
550:
551: AMS_ADI_COMMON_PVT.complete_batch(
552: 'AMS_ADI_MEDIA_PLANNER',
553: p_upload_batch_id,
554: FND_API.G_TRUE,
555: FND_API.G_TRUE,

Line 559: AMS_ADI_COMMON_PVT.complete_all(FND_API.G_TRUE,FND_API.G_TRUE,p_upload_batch_id);

555: FND_API.G_TRUE,
556: l_err_recs
557: );
558:
559: AMS_ADI_COMMON_PVT.complete_all(FND_API.G_TRUE,FND_API.G_TRUE,p_upload_batch_id);
560:
561: IF (AMS_DEBUG_HIGH_ON) THEN
562: AMS_UTILITY_PVT.Write_Conc_Log('Public API: load_request retcode : '||x_retcode||' Done load');
563: END IF;