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

Line 163: l_return_status := FND_API.G_RET_STS_SUCCESS;

159: END IF;
160:
161:
162: -- Initialize API return status to SUCCESS
163: l_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: select user_status_id into l_avail_default_user_status
166: from ams_user_statuses_vl
167: where system_status_type = 'AMS_CAMPAIGN_SCHEDULE_STATUS'

Line 307: FND_API.G_FALSE,

303: END IF;
304:
305: AMS_Camp_Schedule_PUB.Update_Camp_Schedule(
306: 1.0,
307: FND_API.G_FALSE,
308: FND_API.G_FALSE,
309: FND_API.g_valid_level_full,
310: l_return_status,
311: l_msg_count,

Line 308: FND_API.G_FALSE,

304:
305: AMS_Camp_Schedule_PUB.Update_Camp_Schedule(
306: 1.0,
307: FND_API.G_FALSE,
308: FND_API.G_FALSE,
309: FND_API.g_valid_level_full,
310: l_return_status,
311: l_msg_count,
312: l_msg_data,

Line 309: FND_API.g_valid_level_full,

305: AMS_Camp_Schedule_PUB.Update_Camp_Schedule(
306: 1.0,
307: FND_API.G_FALSE,
308: FND_API.G_FALSE,
309: FND_API.g_valid_level_full,
310: l_return_status,
311: l_msg_count,
312: l_msg_data,
313: l_schedule_rec,

Line 323: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

319: AMS_UTILITY_PVT.debug_message('Return Status from Update_Camp_Schedule '||l_return_status);
320: END IF;
321:
322: -- Approvals Integration Starts here
323: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
324: IF (l_apprActionCodes(i) = 'COMPLETE') THEN
325: IF (AMS_DEBUG_HIGH_ON) THEN
326: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Schedule Update before Approval was successful '||TO_CHAR(l_objectIds(i)));
327: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name || ' Now proceeding with Approval');

Line 340: WHEN FND_API.G_EXC_ERROR THEN

336: p_status_code => 'AVAILABLE'),
337: p_budget_amount => null
338: );
339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: l_return_status := FND_API.G_RET_STS_ERROR;
342: END;
343:
344: IF (AMS_DEBUG_HIGH_ON) THEN

Line 341: l_return_status := FND_API.G_RET_STS_ERROR;

337: p_budget_amount => null
338: );
339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: l_return_status := FND_API.G_RET_STS_ERROR;
342: END;
343:
344: IF (AMS_DEBUG_HIGH_ON) THEN
345: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 352: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

348: END IF;
349: END IF;
350: -- Approvals Integration Ends here
351:
352: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
353: AMS_ADI_COMMON_PVT.handle_success_row(FND_API.G_FALSE); -- do not need commit for every row
354: ELSE
355: ROLLBACK TO EXPORT_SCHEDULE; --rollback to save_point if errors
356:

Line 353: AMS_ADI_COMMON_PVT.handle_success_row(FND_API.G_FALSE); -- do not need commit for every row

349: END IF;
350: -- Approvals Integration Ends here
351:
352: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
353: AMS_ADI_COMMON_PVT.handle_success_row(FND_API.G_FALSE); -- do not need commit for every row
354: ELSE
355: ROLLBACK TO EXPORT_SCHEDULE; --rollback to save_point if errors
356:
357: AMS_ADI_COMMON_PVT.handle_error_row(

Line 358: FND_API.G_TRUE,

354: ELSE
355: ROLLBACK TO EXPORT_SCHEDULE; --rollback to save_point if errors
356:
357: AMS_ADI_COMMON_PVT.handle_error_row(
358: FND_API.G_TRUE,
359: FND_API.G_FALSE, -- do not need a rollback from procedure
360: NULL,
361: NULL,
362: l_objectIds(i),

Line 359: FND_API.G_FALSE, -- do not need a rollback from procedure

355: ROLLBACK TO EXPORT_SCHEDULE; --rollback to save_point if errors
356:
357: AMS_ADI_COMMON_PVT.handle_error_row(
358: FND_API.G_TRUE,
359: FND_API.G_FALSE, -- do not need a rollback from procedure
360: NULL,
361: NULL,
362: l_objectIds(i),
363: NULL,

Line 383: FND_API.G_TRUE,

379:
380: AMS_ADI_COMMON_PVT.complete_batch(
381: 'AMS_ADI_CAMPAIGNS_INTERFACE',
382: p_upload_batch_id,
383: FND_API.G_TRUE,
384: FND_API.G_FALSE, -- do not need COMMIT for batches as well
385: l_error_recs
386: );
387:

Line 384: FND_API.G_FALSE, -- do not need COMMIT for batches as well

380: AMS_ADI_COMMON_PVT.complete_batch(
381: 'AMS_ADI_CAMPAIGNS_INTERFACE',
382: p_upload_batch_id,
383: FND_API.G_TRUE,
384: FND_API.G_FALSE, -- do not need COMMIT for batches as well
385: l_error_recs
386: );
387:
388: exit when c%notfound;

Line 399: AMS_ADI_COMMON_PVT.complete_all(FND_API.G_TRUE,FND_API.G_TRUE,p_upload_batch_id); --commit everything here only!

395: IF (AMS_DEBUG_HIGH_ON) THEN
396: AMS_UTILITY_PVT.debug_message('Calling Complete all');
397: END IF;
398:
399: AMS_ADI_COMMON_PVT.complete_all(FND_API.G_TRUE,FND_API.G_TRUE,p_upload_batch_id); --commit everything here only!
400:
401: -- Debug Message
402: IF (AMS_DEBUG_HIGH_ON) THEN
403: AMS_UTILITY_PVT.debug_message('Done with all');

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: END IF;
405:
406: EXCEPTION
407:
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO EXPORT_SCHEDULE; --rollback to save_point if errors
410:
411:
412: IF (c%ISOPEN)

Line 423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

419: x_errbuf := SQLERRM;
420:
421: RAISE;
422:
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: ROLLBACK TO EXPORT_SCHEDULE; --rollback to save_point if errors
425:
426: IF (c%ISOPEN)
427: THEN

Line 460: p_commit IN VARCHAR2 := FND_API.G_FALSE,

456: p_return_status IN VARCHAR2,
457: p_object_name IN VARCHAR2,
458: p_parent_object_id IN NUMBER,
459: p_error_records IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,
460: p_commit IN VARCHAR2 := FND_API.G_FALSE,
461: p_purge_metrics IN VARCHAR2 := FND_API.G_FALSE
462: );
463:
464: --========================================================================

Line 461: p_purge_metrics IN VARCHAR2 := FND_API.G_FALSE

457: p_object_name IN VARCHAR2,
458: p_parent_object_id IN NUMBER,
459: p_error_records IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,
460: p_commit IN VARCHAR2 := FND_API.G_FALSE,
461: p_purge_metrics IN VARCHAR2 := FND_API.G_FALSE
462: );
463:
464: --========================================================================
465: -- PROCEDURE Associate_Product_Category

Line 731: l_return_status := FND_API.G_RET_STS_SUCCESS;

727: END IF;
728:
729:
730: -- Initialize API return status to SUCCESS
731: l_return_status := FND_API.G_RET_STS_SUCCESS;
732:
733: AMS_ADI_COMMON_PVT.init();
734:
735: -- Debug Message

Line 792: l_return_status := FND_API.G_RET_STS_SUCCESS;

788: SAVEPOINT Import_Schedule_PVT;
789: --init the schedule rec type with a gmiss record;
790: --l_schedule_rec := AMS_Camp_Schedule_PUB.g_miss_schedule_rec;
791:
792: l_return_status := FND_API.G_RET_STS_SUCCESS;
793: --check for duplicate schedules in the interface table
794: BEGIN
795: SELECT
796: 1 into l_temp_num

Line 810: l_return_status := FND_API.G_RET_STS_ERROR;

806: object_name = l_objectNames(i);
807: EXCEPTION
808: WHEN TOO_MANY_ROWS THEN
809: AMS_Utility_PVT.Error_Message('AMS_CSCH_DUPLICATE_ID');
810: l_return_status := FND_API.G_RET_STS_ERROR;
811: Handle_Ret_Status_For_Import (
812: p_return_status => l_return_status,
813: p_object_name => l_objectNames(i),
814: p_parent_object_id => l_campIds(i),

Line 819: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

815: p_error_records => l_error_recs
816: );
817: END;
818:
819: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
820: THEN
821: --populate the schedule record start
822: l_schedule_rec.last_update_date := sysdate;
823: l_schedule_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line 1011: FND_API.G_FALSE,

1007: END IF;
1008:
1009: AMS_Camp_Schedule_PUB.Create_Camp_Schedule(
1010: 1.0,
1011: FND_API.G_FALSE,
1012: FND_API.G_FALSE,
1013: FND_API.g_valid_level_full,
1014: l_return_status,
1015: l_msg_count,

Line 1012: FND_API.G_FALSE,

1008:
1009: AMS_Camp_Schedule_PUB.Create_Camp_Schedule(
1010: 1.0,
1011: FND_API.G_FALSE,
1012: FND_API.G_FALSE,
1013: FND_API.g_valid_level_full,
1014: l_return_status,
1015: l_msg_count,
1016: l_msg_data,

Line 1013: FND_API.g_valid_level_full,

1009: AMS_Camp_Schedule_PUB.Create_Camp_Schedule(
1010: 1.0,
1011: FND_API.G_FALSE,
1012: FND_API.G_FALSE,
1013: FND_API.g_valid_level_full,
1014: l_return_status,
1015: l_msg_count,
1016: l_msg_data,
1017: l_schedule_rec,

Line 1034: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1030: );
1031: END IF;
1032:
1033: -- Metrics Integration starts here
1034: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1035: THEN
1036: IF (AMS_DEBUG_HIGH_ON) THEN
1037: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1038: ' Association before Metrics association was successful '||TO_CHAR(l_schedule_id));

Line 1047: p_init_msg_list => FND_API.G_FALSE,

1043: END IF;
1044:
1045: AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS(
1046: p_api_version => 1.0,
1047: p_init_msg_list => FND_API.G_FALSE,
1048: p_commit => FND_API.G_FALSE,
1049: x_return_status => l_return_status,
1050: x_msg_count => l_msg_count,
1051: x_msg_data => l_msg_data,

Line 1048: p_commit => FND_API.G_FALSE,

1044:
1045: AMS_ADI_MEDIA_PLANNER_PVT.LOAD_METRICS(
1046: p_api_version => 1.0,
1047: p_init_msg_list => FND_API.G_FALSE,
1048: p_commit => FND_API.G_FALSE,
1049: x_return_status => l_return_status,
1050: x_msg_count => l_msg_count,
1051: x_msg_data => l_msg_data,
1052: p_upload_batch_id => 1, -- workaround

Line 1070: p_purge_metrics => FND_API.G_TRUE

1066: p_return_status => l_return_status,
1067: p_object_name => l_objectNames(i),
1068: p_parent_object_id => l_campIds(i),
1069: p_error_records => l_error_recs,
1070: p_purge_metrics => FND_API.G_TRUE
1071: );
1072:
1073: END IF;
1074: -- Metrics Integration end here

Line 1077: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1073: END IF;
1074: -- Metrics Integration end here
1075:
1076: -- Repeat Schedule Integration Start
1077: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1078: THEN
1079: IF ( (l_repschedFreqCodes(i) is not null) AND (l_repschedFreqCodes(i) <> 'NONE') AND
1080: (l_repschedFreqs(i) is not null) AND (l_repschedFreqs(i) > 0) AND
1081: (l_repschedTgFlags(i) is not null) AND

Line 1117: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1113:
1114: -- Repeat Schedule Integration End
1115:
1116: -- Cover Letter Integration start
1117: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1118: THEN
1119: IF (AMS_DEBUG_HIGH_ON) THEN
1120: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation successful '||TO_CHAR(l_schedule_id));
1121: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with cover letter association for cover letter '||TO_CHAR(l_covLettIds (i)));

Line 1140: ,p_commit => FND_API.g_false

1136: IBC_CITEM_ADMIN_GRP.insert_associations(
1137: p_content_item_id => l_covLettIds(i)
1138: ,p_assoc_type_codes => l_assoc_type_codes
1139: ,p_assoc_objects1 => l_assoc_objects1
1140: ,p_commit => FND_API.g_false
1141: ,x_return_status => l_return_status
1142: ,x_msg_count => l_msg_count
1143: ,x_msg_data => l_msg_data
1144: );

Line 1162: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1158: -- Cover Letter Integration end
1159:
1160: l_ctd_act_product_id := null;
1161: -- Product Integration starts here
1162: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1163: THEN
1164: IF (AMS_DEBUG_HIGH_ON) THEN
1165: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Cover letter associaiton successful '||TO_CHAR(l_schedule_id));
1166: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');

Line 1204: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1200: END IF;
1201:
1202: END IF;
1203:
1204: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1205: THEN
1206: IF (AMS_DEBUG_HIGH_ON) THEN
1207: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));
1208: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with product/category association ');

Line 1263: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1259: -- Collaboration Integration Starts here
1260: IF (l_schedule_rec.activity_type_code <> 'INTERNET')
1261: THEN
1262: -- Content Item 1
1263: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1264: THEN
1265: IF (AMS_DEBUG_HIGH_ON) THEN
1266: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 1 association successful '||TO_CHAR(l_schedule_id));
1267: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 1 association ');

Line 1299: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1295: END IF;
1296: -- Content Item 1
1297:
1298: -- Content Item 2
1299: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1300: THEN
1301: IF (AMS_DEBUG_HIGH_ON) THEN
1302: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 2 association successful '||TO_CHAR(l_schedule_id));
1303: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 2 association ');

Line 1335: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1331: END IF;
1332: -- Content Item 2
1333:
1334: -- Content Item 3
1335: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1336: THEN
1337: IF (AMS_DEBUG_HIGH_ON) THEN
1338: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Product 3 association successful '||TO_CHAR(l_schedule_id));
1339: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');

Line 1371: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1367: END IF;
1368: -- Content Item 3
1369:
1370: -- Script
1371: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1372: THEN
1373: IF (AMS_DEBUG_HIGH_ON) THEN
1374: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Schedule Creation/Content Item 3 association successful '||TO_CHAR(l_schedule_id));
1375: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||' Now proceeding with Collaboration CItem 3 association ');

Line 1410: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1406: -- Collaboration Integration Ends here
1407:
1408:
1409: -- Web Planner Integration Starts here
1410: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1411: THEN
1412: IF (AMS_DEBUG_HIGH_ON) THEN
1413: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1414: ' Association before Web Planner association was successful '||TO_CHAR(l_schedule_id));

Line 1468: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1464:
1465:
1466:
1467: -- CTD Integration for Web Starts here
1468: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1469: THEN
1470: IF (l_ctdActions(i) is not null)
1471: THEN
1472: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1532: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1528: END IF;
1529: -- Web Planner Integration Ends here
1530:
1531: -- Pretty URL Association Starts here
1532: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1533: THEN
1534: IF (l_puWebsites(i) is not null)
1535: THEN
1536: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1611: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1607:
1608: END IF; -- (l_ctdActions(i) is not null)
1609:
1610: -- Now call Pretty URL API
1611: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1612: THEN
1613: IF (AMS_DEBUG_HIGH_ON) THEN
1614: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||
1615: ' Pretty URL CTD association was successful '||TO_CHAR(l_schedule_id));

Line 1654: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1650: -- Pretty URL Association Ends here
1651:
1652:
1653: -- Notes Integration starts here
1654: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1655: THEN
1656: IF (l_notes(i) is not null)
1657: THEN
1658: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1702: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)

1698:
1699: -- Notes Integration ends here
1700:
1701: -- Approvals Integration Starts here
1702: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)
1703: THEN
1704: IF (l_apprActionCodes(i) = 'COMPLETE')
1705: THEN
1706: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1726: WHEN FND_API.G_EXC_ERROR THEN

1722: p_status_code => 'AVAILABLE'),
1723: p_budget_amount => null
1724: );
1725: EXCEPTION
1726: WHEN FND_API.G_EXC_ERROR THEN
1727: l_return_status := FND_API.G_RET_STS_ERROR;
1728: END;
1729:
1730: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1727: l_return_status := FND_API.G_RET_STS_ERROR;

1723: p_budget_amount => null
1724: );
1725: EXCEPTION
1726: WHEN FND_API.G_EXC_ERROR THEN
1727: l_return_status := FND_API.G_RET_STS_ERROR;
1728: END;
1729:
1730: IF (AMS_DEBUG_HIGH_ON) THEN
1731: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||

Line 1744: p_commit => FND_API.G_TRUE

1740: p_return_status => l_return_status,
1741: p_object_name => l_objectNames(i),
1742: p_parent_object_id => l_campIds(i),
1743: p_error_records => l_error_recs,
1744: p_commit => FND_API.G_TRUE
1745: );
1746:
1747: FND_MSG_PUB.initialize; --initializes message table for next loop
1748: EXCEPTION

Line 1750: WHEN FND_API.G_EXC_ERROR THEN

1746:
1747: FND_MSG_PUB.initialize; --initializes message table for next loop
1748: EXCEPTION
1749:
1750: WHEN FND_API.G_EXC_ERROR THEN
1751: l_return_status := FND_API.G_RET_STS_ERROR;
1752:
1753: Handle_Ret_Status_For_Import (
1754: p_return_status => l_return_status,

Line 1751: l_return_status := FND_API.G_RET_STS_ERROR;

1747: FND_MSG_PUB.initialize; --initializes message table for next loop
1748: EXCEPTION
1749:
1750: WHEN FND_API.G_EXC_ERROR THEN
1751: l_return_status := FND_API.G_RET_STS_ERROR;
1752:
1753: Handle_Ret_Status_For_Import (
1754: p_return_status => l_return_status,
1755: p_object_name => l_objectNames(i),

Line 1758: p_purge_metrics => FND_API.G_TRUE

1754: p_return_status => l_return_status,
1755: p_object_name => l_objectNames(i),
1756: p_parent_object_id => l_campIds(i),
1757: p_error_records => l_error_recs,
1758: p_purge_metrics => FND_API.G_TRUE
1759: );
1760:
1761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1762: AMS_ADI_COMMON_PVT.handle_fatal_error();

Line 1761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1757: p_error_records => l_error_recs,
1758: p_purge_metrics => FND_API.G_TRUE
1759: );
1760:
1761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1762: AMS_ADI_COMMON_PVT.handle_fatal_error();
1763:
1764: AMS_ADI_MEDIA_PLANNER_PVT.purge_import_metrics(
1765: p_object_type => 'CSCH',

Line 1800: FND_API.G_FALSE,

1796:
1797: AMS_ADI_COMMON_PVT.complete_batch(
1798: 'AMS_ADI_CAMPAIGNS_INTERFACE',
1799: p_upload_batch_id,
1800: FND_API.G_FALSE,
1801: FND_API.G_TRUE,
1802: l_error_recs
1803: );
1804:

Line 1801: FND_API.G_TRUE,

1797: AMS_ADI_COMMON_PVT.complete_batch(
1798: 'AMS_ADI_CAMPAIGNS_INTERFACE',
1799: p_upload_batch_id,
1800: FND_API.G_FALSE,
1801: FND_API.G_TRUE,
1802: l_error_recs
1803: );
1804:
1805:

Line 1825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1821:
1822: x_retcode := 0;
1823: EXCEPTION
1824:
1825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1826: IF (C_IMPORT_BATCH%ISOPEN)
1827: THEN
1828: CLOSE C_IMPORT_BATCH;
1829: END IF;

Line 1898: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1894: p_return_status IN VARCHAR2,
1895: p_object_name IN VARCHAR2,
1896: p_parent_object_id IN NUMBER,
1897: p_error_records IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,
1898: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1899: p_purge_metrics IN VARCHAR2 := FND_API.G_FALSE
1900: )
1901: IS
1902: BEGIN

Line 1899: p_purge_metrics IN VARCHAR2 := FND_API.G_FALSE

1895: p_object_name IN VARCHAR2,
1896: p_parent_object_id IN NUMBER,
1897: p_error_records IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,
1898: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1899: p_purge_metrics IN VARCHAR2 := FND_API.G_FALSE
1900: )
1901: IS
1902: BEGIN
1903: IF(p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 1903: IF(p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1899: p_purge_metrics IN VARCHAR2 := FND_API.G_FALSE
1900: )
1901: IS
1902: BEGIN
1903: IF(p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1904:
1905: IF (FND_API.To_Boolean(p_purge_metrics))
1906: THEN
1907: AMS_ADI_MEDIA_PLANNER_PVT.purge_import_metrics(

Line 1905: IF (FND_API.To_Boolean(p_purge_metrics))

1901: IS
1902: BEGIN
1903: IF(p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1904:
1905: IF (FND_API.To_Boolean(p_purge_metrics))
1906: THEN
1907: AMS_ADI_MEDIA_PLANNER_PVT.purge_import_metrics(
1908: p_object_type => 'CSCH',
1909: p_object_name => p_object_name,

Line 1921: FND_API.G_TRUE,

1917: ELSE
1918: ROLLBACK to Import_Schedule_PVT;
1919:
1920: AMS_ADI_COMMON_PVT.handle_error_row(
1921: FND_API.G_TRUE,
1922: FND_API.G_FALSE,
1923: NULL,
1924: NULL,
1925: NULL,

Line 1922: FND_API.G_FALSE,

1918: ROLLBACK to Import_Schedule_PVT;
1919:
1920: AMS_ADI_COMMON_PVT.handle_error_row(
1921: FND_API.G_TRUE,
1922: FND_API.G_FALSE,
1923: NULL,
1924: NULL,
1925: NULL,
1926: p_object_name,

Line 1981: p_init_msg_list => FND_API.G_FALSE,

1977: END IF;
1978:
1979: AMS_ActProduct_PVT.Create_Act_Product
1980: ( p_api_version => 1.0,
1981: p_init_msg_list => FND_API.G_FALSE,
1982: p_commit => FND_API.G_FALSE,
1983: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1984: x_return_status => x_return_status,
1985: x_msg_count => x_msg_count,

Line 1982: p_commit => FND_API.G_FALSE,

1978:
1979: AMS_ActProduct_PVT.Create_Act_Product
1980: ( p_api_version => 1.0,
1981: p_init_msg_list => FND_API.G_FALSE,
1982: p_commit => FND_API.G_FALSE,
1983: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1984: x_return_status => x_return_status,
1985: x_msg_count => x_msg_count,
1986: x_msg_data => x_msg_data,

Line 1983: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1979: AMS_ActProduct_PVT.Create_Act_Product
1980: ( p_api_version => 1.0,
1981: p_init_msg_list => FND_API.G_FALSE,
1982: p_commit => FND_API.G_FALSE,
1983: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1984: x_return_status => x_return_status,
1985: x_msg_count => x_msg_count,
1986: x_msg_data => x_msg_data,
1987: p_act_Product_rec => l_act_Product_rec,

Line 2031: p_init_msg_list => FND_API.G_FALSE,

2027: END IF;
2028:
2029: AMS_Collab_assoc_PVT.Create_collab_Assoc(
2030: p_api_version_number => 1.0,
2031: p_init_msg_list => FND_API.G_FALSE,
2032: p_commit => FND_API.G_FALSE,
2033: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2034: x_return_status => x_return_status,
2035: x_msg_count => x_msg_count,

Line 2032: p_commit => FND_API.G_FALSE,

2028:
2029: AMS_Collab_assoc_PVT.Create_collab_Assoc(
2030: p_api_version_number => 1.0,
2031: p_init_msg_list => FND_API.G_FALSE,
2032: p_commit => FND_API.G_FALSE,
2033: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2034: x_return_status => x_return_status,
2035: x_msg_count => x_msg_count,
2036: x_msg_data => x_msg_data,

Line 2033: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2029: AMS_Collab_assoc_PVT.Create_collab_Assoc(
2030: p_api_version_number => 1.0,
2031: p_init_msg_list => FND_API.G_FALSE,
2032: p_commit => FND_API.G_FALSE,
2033: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2034: x_return_status => x_return_status,
2035: x_msg_count => x_msg_count,
2036: x_msg_data => x_msg_data,
2037: p_collab_assoc_rec_type => l_collab_assoc_rec_type,

Line 2091: p_init_msg_list => FND_API.G_FALSE,

2087: END IF;
2088:
2089: AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC(
2090: p_api_version_number => 1.0,
2091: p_init_msg_list => FND_API.G_FALSE,
2092: p_commit => FND_API.G_FALSE,
2093: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2094: p_web_mp_rec => l_web_mp_rec,
2095: x_placement_mp_id => x_placement_mp_id,

Line 2092: p_commit => FND_API.G_FALSE,

2088:
2089: AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC(
2090: p_api_version_number => 1.0,
2091: p_init_msg_list => FND_API.G_FALSE,
2092: p_commit => FND_API.G_FALSE,
2093: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2094: p_web_mp_rec => l_web_mp_rec,
2095: x_placement_mp_id => x_placement_mp_id,
2096: x_placement_citem_id_tbl => x_placement_citem_id_tbl,

Line 2093: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2089: AMS_WEBMARKETING_PVT.CREATE_WEB_PLCE_ASSOC(
2090: p_api_version_number => 1.0,
2091: p_init_msg_list => FND_API.G_FALSE,
2092: p_commit => FND_API.G_FALSE,
2093: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2094: p_web_mp_rec => l_web_mp_rec,
2095: x_placement_mp_id => x_placement_mp_id,
2096: x_placement_citem_id_tbl => x_placement_citem_id_tbl,
2097: x_msg_count => x_msg_count,