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

Line 47: -- p_init_msg_list Default FND_API.g_false; indicate whether to

43: -- Parameters
44: --
45: -- IN
46: -- p_api_version
47: -- p_init_msg_list Default FND_API.g_false; indicate whether to
48: -- initialize the message buffer.
49: -- p_commit Default FND_API.g_false; indicate whether to
50: -- commit the transaction.
51: -- p_upload_batch_id Batch ID used to identify the records belonging

Line 49: -- p_commit Default FND_API.g_false; indicate whether to

45: -- IN
46: -- p_api_version
47: -- p_init_msg_list Default FND_API.g_false; indicate whether to
48: -- initialize the message buffer.
49: -- p_commit Default FND_API.g_false; indicate whether to
50: -- commit the transaction.
51: -- p_upload_batch_id Batch ID used to identify the records belonging
52: -- in the same upload batch.
53: -- p_object_type Default 'CSCH'; the type of object the metrics

Line 87: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

83: --
84: -- ==========================================================================
85: PROCEDURE load_metrics (
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
88: p_commit IN VARCHAR2 := FND_API.g_false,
89: p_upload_batch_id IN NUMBER,
90: p_object_type IN VARCHAR2 := 'CSCH',
91: p_object_name IN VARCHAR2,

Line 88: p_commit IN VARCHAR2 := FND_API.g_false,

84: -- ==========================================================================
85: PROCEDURE load_metrics (
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
88: p_commit IN VARCHAR2 := FND_API.g_false,
89: p_upload_batch_id IN NUMBER,
90: p_object_type IN VARCHAR2 := 'CSCH',
91: p_object_name IN VARCHAR2,
92: -- p_parent_type IN VARCHAR2 := 'CAMP',

Line 107: IF fnd_api.to_boolean (p_init_msg_list) THEN

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;
110:
111: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,

Line 111: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,

107: IF fnd_api.to_boolean (p_init_msg_list) THEN
108: fnd_msg_pub.initialize;
109: END IF;
110:
111: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,
112: p_api_version, l_API_NAME, G_PKG_NAME)
113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110:
111: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,
112: p_api_version, l_API_NAME, G_PKG_NAME)
113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: x_return_status := FND_API.g_ret_sts_success;
118:

Line 117: x_return_status := FND_API.g_ret_sts_success;

113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: x_return_status := FND_API.g_ret_sts_success;
118:
119: BEGIN
120: SELECT *
121: INTO l_interface_rec

Line 130: x_return_status := FND_API.g_ret_sts_error;

126: AND parent_type = p_parent_type
127: AND parent_id = p_parent_id;
128: EXCEPTION
129: WHEN TOO_MANY_ROWS THEN
130: x_return_status := FND_API.g_ret_sts_error;
131: FND_MESSAGE.set_name ('AMS', 'AMS_CSCH_NOT_UNIQUE');
132: FND_MSG_PUB.add;
133: RETURN;
134: WHEN NO_DATA_FOUND THEN

Line 135: x_return_status := FND_API.g_ret_sts_error;

131: FND_MESSAGE.set_name ('AMS', 'AMS_CSCH_NOT_UNIQUE');
132: FND_MSG_PUB.add;
133: RETURN;
134: WHEN NO_DATA_FOUND THEN
135: x_return_status := FND_API.g_ret_sts_error;
136: FND_MESSAGE.set_name ('AMS', 'AMS_CSCH_NOT_FOUND');
137: FND_MSG_PUB.add;
138: RETURN;
139: END;

Line 158: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

154: x_msg_count => x_msg_count,
155: x_msg_data => x_msg_data
156: );
157:
158: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
159: COMMIT;
160: END IF;
161:
162: IF (AMS_DEBUG_HIGH_ON) THEN

Line 168: WHEN fnd_api.G_EXC_ERROR THEN

164: ': upload batch id : '||p_upload_batch_id||'. Done load');
165: END IF;
166:
167: EXCEPTION
168: WHEN fnd_api.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
171: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: END IF;
166:
167: EXCEPTION
168: WHEN fnd_api.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
171: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);

Line 171: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

167: EXCEPTION
168: WHEN fnd_api.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
171: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168: WHEN fnd_api.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
171: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
177: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);
178: END IF;
179: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);

Line 191: -- p_init_msg_list Default FND_API.g_false; indicate whether to

187: -- Parameters
188: --
189: -- IN
190: -- p_api_version
191: -- p_init_msg_list Default FND_API.g_false; indicate whether to
192: -- initialize the message buffer.
193: -- p_commit Default FND_API.g_false; indicate whether to
194: -- commit the transaction.
195: -- p_media_planner_rec ###### description here #######

Line 193: -- p_commit Default FND_API.g_false; indicate whether to

189: -- IN
190: -- p_api_version
191: -- p_init_msg_list Default FND_API.g_false; indicate whether to
192: -- initialize the message buffer.
193: -- p_commit Default FND_API.g_false; indicate whether to
194: -- commit the transaction.
195: -- p_media_planner_rec ###### description here #######
196: -- x_return_status Status of the API execution.
197: -- x_msg_count Number of messages in the message buffer.

Line 213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

209: --
210: -- ==========================================================================
211: PROCEDURE load_metrics (
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,

Line 214: p_commit IN VARCHAR2 := FND_API.g_false,

210: -- ==========================================================================
211: PROCEDURE load_metrics (
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,

Line 224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

220: )
221: IS
222: L_API_VERSION_NUMBER CONSTANT NUMBER := 1;
223: L_API_NAME CONSTANT VARCHAR2(30) := 'LOAD_METRICS';
224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
225: l_msg_count NUMBER;
226: l_msg_data VARCHAR2(4000);
227: l_table_of_metrics actmetrics_tab_t;
228:

Line 251: IF fnd_api.to_boolean (p_init_msg_list) THEN

247: l_object_version_number NUMBER;
248: l_display_type VARCHAR2(30);
249:
250: BEGIN
251: IF fnd_api.to_boolean (p_init_msg_list) THEN
252: fnd_msg_pub.initialize;
253: END IF;
254:
255: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,

Line 255: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,

251: IF fnd_api.to_boolean (p_init_msg_list) THEN
252: fnd_msg_pub.initialize;
253: END IF;
254:
255: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,
256: p_api_version, L_API_NAME, G_PKG_NAME)
257: THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

254:
255: IF NOT FND_API.Compatible_API_Call(L_API_VERSION_NUMBER,
256: p_api_version, L_API_NAME, G_PKG_NAME)
257: THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260:
261: x_return_status := FND_API.g_ret_sts_success;
262:

Line 261: x_return_status := FND_API.g_ret_sts_success;

257: THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END IF;
260:
261: x_return_status := FND_API.g_ret_sts_success;
262:
263: IF (AMS_DEBUG_HIGH_ON) THEN
264: AMS_UTILITY_PVT.Write_Conc_Log('Private API : load_metrics object_name:'||
265: p_media_planner_rec.object_name||

Line 329: Fnd_Api.G_MISS_NUM THEN

325: -- invoke create metric API
326: l_act_metric_rec.metric_id := l_table_of_metrics(i).metric_id;
327:
328: IF l_table_of_metrics(i).trans_forecasted_value <>
329: Fnd_Api.G_MISS_NUM THEN
330: l_act_metric_rec.trans_forecasted_value :=
331: l_table_of_metrics(i).trans_forecasted_value;
332: END IF;
333:

Line 335: Fnd_Api.G_MISS_NUM THEN

331: l_table_of_metrics(i).trans_forecasted_value;
332: END IF;
333:
334: IF l_table_of_metrics(i).trans_actual_value <>
335: Fnd_Api.G_MISS_NUM THEN
336: l_act_metric_rec.trans_actual_value :=
337: l_table_of_metrics(i).trans_actual_value;
338: END IF;
339:

Line 341: Fnd_Api.G_MISS_NUM THEN

337: l_table_of_metrics(i).trans_actual_value;
338: END IF;
339:
340: IF l_table_of_metrics(i).func_forecasted_value <>
341: Fnd_Api.G_MISS_NUM THEN
342: l_act_metric_rec.func_forecasted_value :=
343: l_table_of_metrics(i).func_forecasted_value;
344: END IF;
345:

Line 347: Fnd_Api.G_MISS_NUM THEN

343: l_table_of_metrics(i).func_forecasted_value;
344: END IF;
345:
346: IF l_table_of_metrics(i).forecasted_variable_value <>
347: Fnd_Api.G_MISS_NUM THEN
348: l_act_metric_rec.forecasted_variable_value :=
349: l_table_of_metrics(i).forecasted_variable_value;
350: END IF;
351:

Line 361: p_init_msg_list => FND_API.G_FALSE,

357: x_activity_metric_id := NULL;
358:
359: AMS_ActMetric_PVT.Create_ActMetric (
360: p_api_version => 1.0,
361: p_init_msg_list => FND_API.G_FALSE,
362: p_commit => FND_API.G_FALSE,
363: p_validation_level => Fnd_Api.G_Valid_Level_Full,
364: x_return_status => l_return_status,
365: x_msg_count => l_msg_count,

Line 362: p_commit => FND_API.G_FALSE,

358:
359: AMS_ActMetric_PVT.Create_ActMetric (
360: p_api_version => 1.0,
361: p_init_msg_list => FND_API.G_FALSE,
362: p_commit => FND_API.G_FALSE,
363: p_validation_level => Fnd_Api.G_Valid_Level_Full,
364: x_return_status => l_return_status,
365: x_msg_count => l_msg_count,
366: x_msg_data => l_msg_data,

Line 363: p_validation_level => Fnd_Api.G_Valid_Level_Full,

359: AMS_ActMetric_PVT.Create_ActMetric (
360: p_api_version => 1.0,
361: p_init_msg_list => FND_API.G_FALSE,
362: p_commit => FND_API.G_FALSE,
363: p_validation_level => Fnd_Api.G_Valid_Level_Full,
364: x_return_status => l_return_status,
365: x_msg_count => l_msg_count,
366: x_msg_data => l_msg_data,
367: p_act_metric_rec => l_act_metric_rec,

Line 375: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

371: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
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,

Line 377: p_write_conc_log => FND_API.G_TRUE,

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,
381: p_object_id => p_media_planner_rec.object_id,

Line 378: p_rollback => FND_API.G_FALSE,

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,
381: p_object_id => p_media_planner_rec.object_id,
382: p_object_name => NULL,

Line 403: p_init_msg_list => FND_API.G_FALSE,

399: ELSE
400: -- invoke update metric API
401: Ams_Actmetric_Pvt.update_actmetric (
402: p_api_version => 1.0,
403: p_init_msg_list => FND_API.G_FALSE,
404: p_commit => FND_API.G_FALSE,
405: p_act_metric_rec => l_table_of_metrics(i),
406: x_return_status => l_return_status,
407: x_msg_count => l_msg_count,

Line 404: p_commit => FND_API.G_FALSE,

400: -- invoke update metric API
401: Ams_Actmetric_Pvt.update_actmetric (
402: p_api_version => 1.0,
403: p_init_msg_list => FND_API.G_FALSE,
404: p_commit => FND_API.G_FALSE,
405: p_act_metric_rec => l_table_of_metrics(i),
406: x_return_status => l_return_status,
407: x_msg_count => l_msg_count,
408: x_msg_data => l_msg_data);

Line 422: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

418: AMS_UTILITY_PVT.debug_message('Private API : load_metric '||
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,

Line 424: p_write_conc_log => FND_API.G_TRUE,

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,
428: p_object_id => p_media_planner_rec.object_id,

Line 425: p_rollback => FND_API.G_FALSE,

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,
428: p_object_id => p_media_planner_rec.object_id,
429: p_object_name => NULL,

Line 440: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

436: END LOOP;
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;

Line 451: WHEN fnd_api.G_EXC_ERROR THEN

447: AMS_UTILITY_PVT.Write_Conc_Log('Private API :AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS. x_return_status = '||x_return_status);
448: END IF;
449:
450: EXCEPTION
451: WHEN fnd_api.G_EXC_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: x_msg_count := l_msg_count;
454: x_msg_data := l_msg_data;
455: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448: END IF;
449:
450: EXCEPTION
451: WHEN fnd_api.G_EXC_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: x_msg_count := l_msg_count;
454: x_msg_data := l_msg_data;
455: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
456: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

Line 456: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

452: x_return_status := FND_API.G_RET_STS_ERROR;
453: x_msg_count := l_msg_count;
454: x_msg_data := l_msg_data;
455: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
456: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: x_msg_count := l_msg_count;
459: x_msg_data := l_msg_data;
460: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);

Line 457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

453: x_msg_count := l_msg_count;
454: x_msg_data := l_msg_data;
455: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
456: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: x_msg_count := l_msg_count;
459: x_msg_data := l_msg_data;
460: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
461: WHEN OTHERS THEN

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

458: x_msg_count := l_msg_count;
459: x_msg_data := l_msg_data;
460: FND_MSG_PUB.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
461: WHEN OTHERS THEN
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: x_msg_count := l_msg_count;
464: x_msg_data := l_msg_data;
465: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
466: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, L_API_NAME);

Line 528: p_commit => FND_API.G_TRUE,

524:
525: FOR l_interface_recs IN c_interface LOOP
526: load_metrics (
527: p_api_version => 1.0,
528: p_commit => FND_API.G_TRUE,
529: p_media_planner_rec => l_interface_recs,
530: p_err_recs => l_err_recs,
531: x_return_status => l_return_status,
532: x_msg_count => l_msg_count,

Line 535: IF l_return_status <> FND_API.g_ret_sts_success THEN

531: x_return_status => l_return_status,
532: x_msg_count => l_msg_count,
533: x_msg_data => l_msg_data
534: );
535: IF l_return_status <> FND_API.g_ret_sts_success THEN
536: -- Return error code should be success for the web adi to show the
537: -- messages on the Sheet.
538: -- retcode := 2; -- error code is 2
539: AMS_Utility_PVT.write_conc_log;

Line 554: FND_API.G_TRUE,

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,
556: l_err_recs
557: );
558:

Line 555: FND_API.G_TRUE,

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,
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);

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;

Line 566: WHEN Fnd_Api.G_EXC_ERROR THEN

562: AMS_UTILITY_PVT.Write_Conc_Log('Public API: load_request retcode : '||x_retcode||' Done load');
563: END IF;
564:
565: EXCEPTION
566: WHEN Fnd_Api.G_EXC_ERROR THEN
567: x_retcode := 1;
568: RAISE;
569: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
570: x_retcode := 1;

Line 569: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

565: EXCEPTION
566: WHEN Fnd_Api.G_EXC_ERROR THEN
567: x_retcode := 1;
568: RAISE;
569: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
570: x_retcode := 1;
571: RAISE;
572: WHEN OTHERS THEN
573: x_errbuf := SQLERRM;