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 AMS_ADI_COMMON_PVT

Line 55: -- 1. call AMS_ADI_COMMON_PVT.init

51: -- Updates Campaign Schedules from Web ADI
52: -- Purpose
53: -- Updates Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE
54: -- The algorithm is as follows :
55: -- 1. call AMS_ADI_COMMON_PVT.init
56: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
57: -- each batch do the following :
58: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
59: -- 2.2 repeat the following Steps for each Row

Line 56: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for

52: -- Purpose
53: -- Updates Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE
54: -- The algorithm is as follows :
55: -- 1. call AMS_ADI_COMMON_PVT.init
56: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
57: -- each batch do the following :
58: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
59: -- 2.2 repeat the following Steps for each Row
60: -- 2.2.1 call Schedule UpdateAPI for each ROW

Line 58: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch

54: -- The algorithm is as follows :
55: -- 1. call AMS_ADI_COMMON_PVT.init
56: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
57: -- each batch do the following :
58: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
59: -- 2.2 repeat the following Steps for each Row
60: -- 2.2.1 call Schedule UpdateAPI for each ROW
61: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
62: -- else call AMS_ADI_COMMON_PVT.handleErrorRow

Line 61: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow

57: -- each batch do the following :
58: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
59: -- 2.2 repeat the following Steps for each Row
60: -- 2.2.1 call Schedule UpdateAPI for each ROW
61: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
62: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
63: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
64: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
65: -- HISTORY

Line 62: -- else call AMS_ADI_COMMON_PVT.handleErrorRow

58: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
59: -- 2.2 repeat the following Steps for each Row
60: -- 2.2.1 call Schedule UpdateAPI for each ROW
61: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
62: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
63: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
64: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
65: -- HISTORY
66: --

Line 63: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch

59: -- 2.2 repeat the following Steps for each Row
60: -- 2.2.1 call Schedule UpdateAPI for each ROW
61: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
62: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
63: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
64: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
65: -- HISTORY
66: --
67: --========================================================================

Line 64: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows

60: -- 2.2.1 call Schedule UpdateAPI for each ROW
61: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
62: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
63: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
64: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
65: -- HISTORY
66: --
67: --========================================================================
68: PROCEDURE update_campaign_schedules(

Line 79: l_error_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t := AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();

75: PRAGMA AUTONOMOUS_TRANSACTION;
76: L_API_NAME CONSTANT VARCHAR2(30) := 'update_campaign_schedules';
77: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
78: l_schedule_rec AMS_Camp_Schedule_PUB.schedule_rec_type;
79: l_error_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t := AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
80: l_batch_size PLS_INTEGER := AMS_ADI_COMMON_PVT.g_batch_size;
81: l_return_status VARCHAR2(1);
82: l_msg_count NUMBER;
83: l_msg_data VARCHAR2(4000);

Line 80: l_batch_size PLS_INTEGER := AMS_ADI_COMMON_PVT.g_batch_size;

76: L_API_NAME CONSTANT VARCHAR2(30) := 'update_campaign_schedules';
77: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
78: l_schedule_rec AMS_Camp_Schedule_PUB.schedule_rec_type;
79: l_error_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t := AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
80: l_batch_size PLS_INTEGER := AMS_ADI_COMMON_PVT.g_batch_size;
81: l_return_status VARCHAR2(1);
82: l_msg_count NUMBER;
83: l_msg_data VARCHAR2(4000);
84: l_object_version_number NUMBER;

Line 172: AMS_ADI_COMMON_PVT.init();

168: and system_status_code = 'AVAILABLE'
169: and default_flag = 'Y';
170:
171:
172: AMS_ADI_COMMON_PVT.init();
173:
174: -- Debug Message
175: IF (AMS_DEBUG_HIGH_ON) THEN
176: AMS_UTILITY_PVT.debug_message('Start to read feom ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

Line 176: AMS_UTILITY_PVT.debug_message('Start to read feom ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

172: AMS_ADI_COMMON_PVT.init();
173:
174: -- Debug Message
175: IF (AMS_DEBUG_HIGH_ON) THEN
176: AMS_UTILITY_PVT.debug_message('Start to read feom ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);
177: END IF;
178:
179: open c(p_upload_batch_id);
180:

Line 181: --fetches data using BULK COLLECT but limited to AMS_ADI_COMMON_PVT.g_batch_size each time

177: END IF;
178:
179: open c(p_upload_batch_id);
180:
181: --fetches data using BULK COLLECT but limited to AMS_ADI_COMMON_PVT.g_batch_size each time
182: loop
183: fetch c BULK COLLECT
184: into l_objectIds,l_objectNames,l_parentIds,l_srcCodes,l_startDates,l_endDates,l_startTimes,l_endTimes,l_mktMediumIds,
185: l_countryIds,l_ownerIds,l_timezoneIds,l_objectives,l_apprActionCodes,l_nextStatusIds,l_nextStatusCodes,

Line 191: limit AMS_ADI_COMMON_PVT.g_batch_size;

187: l_attribute9s,l_attribute10s,l_attribute11s,l_attribute12s,l_attribute13s,l_attribute14s,l_attribute15s,
188: l_actAttribute1s,l_actAttribute2s,l_actAttribute3s,l_actAttribute4s,l_actAttribute5s,l_actAttribute6s,l_actAttribute7s,
189: l_actAttribute8s,l_actAttribute9s,l_actAttribute10s,l_actAttribute11s,l_actAttribute12s,l_actAttribute13s,l_actAttribute14s,
190: l_actAttribute15s,l_actContexts,l_objVersionNos,l_currencyCodes,l_activityIds,l_activityTypes
191: limit AMS_ADI_COMMON_PVT.g_batch_size;
192:
193:
194: -- Debug Message
195: IF (AMS_DEBUG_HIGH_ON) THEN

Line 204: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs); --initialize batch operation

200: IF (AMS_DEBUG_HIGH_ON) THEN
201: AMS_UTILITY_PVT.debug_message('calling init_for_batch');
202: END IF;
203:
204: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs); --initialize batch operation
205:
206: -- Debug Message
207: IF (AMS_DEBUG_HIGH_ON) THEN
208: AMS_UTILITY_PVT.debug_message('Done init_for_batch with loopsize '||l_objectIds.COUNT);

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 357: AMS_ADI_COMMON_PVT.handle_error_row(

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(
358: FND_API.G_TRUE,
359: FND_API.G_FALSE, -- do not need a rollback from procedure
360: NULL,
361: NULL,

Line 380: AMS_ADI_COMMON_PVT.complete_batch(

376: IF (AMS_DEBUG_HIGH_ON) THEN
377: AMS_UTILITY_PVT.debug_message('Calling Complete batch');
378: END IF;
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

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 417: AMS_ADI_COMMON_PVT.handle_fatal_error();

413: THEN
414: CLOSE c;
415: END IF;
416:
417: AMS_ADI_COMMON_PVT.handle_fatal_error();
418: x_retcode := 2;
419: x_errbuf := SQLERRM;
420:
421: RAISE;

Line 431: AMS_ADI_COMMON_PVT.handle_fatal_error();

427: THEN
428: CLOSE c;
429: END IF;
430:
431: AMS_ADI_COMMON_PVT.handle_fatal_error();
432: RAISE;
433:
434: WHEN OTHERS THEN
435: ROLLBACK TO EXPORT_SCHEDULE; --rollback to save_point if errors

Line 442: AMS_ADI_COMMON_PVT.handle_fatal_error();

438: THEN
439: CLOSE c;
440: END IF;
441:
442: AMS_ADI_COMMON_PVT.handle_fatal_error();
443: RAISE;
444: END update_campaign_schedules;
445:
446: --========================================================================

Line 459: p_error_records IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,

455: procedure Handle_Ret_Status_For_Import (
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:

Line 544: -- 1. call AMS_ADI_COMMON_PVT.init

540: -- Imports New Campaign Schedules from Web ADI
541: -- Purpose
542: -- Imports New Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE
543: -- The algorithm is as follows :
544: -- 1. call AMS_ADI_COMMON_PVT.init
545: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
546: -- each batch do the following :
547: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
548: -- 2.2 repeat the following Steps for each Row

Line 545: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for

541: -- Purpose
542: -- Imports New Campaign Schedules based on Web ADI input in staging table AMS_ADI_CAMPAIGNS_INTERFACE
543: -- The algorithm is as follows :
544: -- 1. call AMS_ADI_COMMON_PVT.init
545: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
546: -- each batch do the following :
547: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
548: -- 2.2 repeat the following Steps for each Row
549: -- 2.2.1 call Schedule Create API for each ROW

Line 547: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch

543: -- The algorithm is as follows :
544: -- 1. call AMS_ADI_COMMON_PVT.init
545: -- 2. BULK COLLECT data from staging table in batches of AMS_ADI_COMMON_PVT.g_batch_size(set as 100). Then for
546: -- each batch do the following :
547: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
548: -- 2.2 repeat the following Steps for each Row
549: -- 2.2.1 call Schedule Create API for each ROW
550: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
551: -- else call AMS_ADI_COMMON_PVT.handleErrorRow

Line 550: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow

546: -- each batch do the following :
547: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
548: -- 2.2 repeat the following Steps for each Row
549: -- 2.2.1 call Schedule Create API for each ROW
550: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
551: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
552: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
553: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
554: -- HISTORY

Line 551: -- else call AMS_ADI_COMMON_PVT.handleErrorRow

547: -- 2.1. call AMS_ADI_COMMON_PVT.init_for_batch
548: -- 2.2 repeat the following Steps for each Row
549: -- 2.2.1 call Schedule Create API for each ROW
550: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
551: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
552: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
553: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
554: -- HISTORY
555: --

Line 552: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch

548: -- 2.2 repeat the following Steps for each Row
549: -- 2.2.1 call Schedule Create API for each ROW
550: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
551: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
552: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
553: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
554: -- HISTORY
555: --
556: --========================================================================

Line 553: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows

549: -- 2.2.1 call Schedule Create API for each ROW
550: -- 2.2.2 if successful, call AMS_ADI_COMMON_PVT.handleSuccesRow
551: -- else call AMS_ADI_COMMON_PVT.handleErrorRow
552: -- 2.3 when done with batch, call AMS_ADI_COMMON_PVT.done_with_batch
553: -- 3. call AMS_ADI_COMMON_PVT.done_with_all_rows
554: -- HISTORY
555: --
556: --========================================================================
557:

Line 569: l_error_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t := AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();

565:
566: L_API_NAME CONSTANT VARCHAR2(30) := 'IMPORT_CAMPAIGN_SCHEDULES';
567: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
568: l_schedule_rec AMS_Camp_Schedule_PUB.schedule_rec_type;
569: l_error_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t := AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
570: l_batch_size PLS_INTEGER := AMS_ADI_COMMON_PVT.g_batch_size;
571: l_return_status VARCHAR2(1);
572: l_msg_count NUMBER;
573: l_msg_data VARCHAR2(4000);

Line 570: l_batch_size PLS_INTEGER := AMS_ADI_COMMON_PVT.g_batch_size;

566: L_API_NAME CONSTANT VARCHAR2(30) := 'IMPORT_CAMPAIGN_SCHEDULES';
567: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
568: l_schedule_rec AMS_Camp_Schedule_PUB.schedule_rec_type;
569: l_error_recs AMS_ADI_COMMON_PVT.ams_adi_error_rec_t := AMS_ADI_COMMON_PVT.ams_adi_error_rec_t();
570: l_batch_size PLS_INTEGER := AMS_ADI_COMMON_PVT.g_batch_size;
571: l_return_status VARCHAR2(1);
572: l_msg_count NUMBER;
573: l_msg_data VARCHAR2(4000);
574: l_start_date_time DATE;

Line 733: AMS_ADI_COMMON_PVT.init();

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
736: IF (AMS_DEBUG_HIGH_ON) THEN
737: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start to read from ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

Line 737: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start to read from ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);

733: AMS_ADI_COMMON_PVT.init();
734:
735: -- Debug Message
736: IF (AMS_DEBUG_HIGH_ON) THEN
737: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Start to read from ams_adi_campaigns_interface with limit '||AMS_ADI_COMMON_PVT.g_batch_size);
738: END IF;
739:
740: OPEN C_IMPORT_BATCH(p_upload_batch_id);
741: LOOP -- C_IMPORT_BATCH loop

Line 762: LIMIT AMS_ADI_COMMON_PVT.g_batch_size;

758: l_attribute12s , l_attribute13s , l_attribute14s , l_attribute15s ,
759: l_actAttribute1s , l_actAttribute2s , l_actAttribute3s , l_actAttribute4s , l_actAttribute5s ,
760: l_actAttribute6s , l_actAttribute7s , l_actAttribute8s , l_actAttribute9s , l_actAttribute10s ,
761: l_actAttribute11s , l_actAttribute12s , l_actAttribute13s , l_actAttribute14s , l_actAttribute15s
762: LIMIT AMS_ADI_COMMON_PVT.g_batch_size;
763:
764: -- Debug Message
765: IF (AMS_DEBUG_HIGH_ON) THEN
766: AMS_UTILITY_PVT.Write_Conc_Log('Private API: '|| pkg_name || '.' || l_api_name ||'done with fetch');

Line 775: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs);

771: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'calling init_for_batch');
772: END IF;
773:
774: --initialize batch operation
775: AMS_ADI_COMMON_PVT.init_for_batch(l_error_recs);
776:
777: -- Debug Message
778: IF (AMS_DEBUG_HIGH_ON) THEN
779: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Done init_for_batch with loopsize'||l_objectNames.COUNT);

Line 1762: AMS_ADI_COMMON_PVT.handle_fatal_error();

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',
1766: p_object_name => l_objectNames(i),

Line 1775: AMS_ADI_COMMON_PVT.handle_fatal_error();

1771:
1772: RAISE;
1773:
1774: WHEN OTHERS THEN
1775: AMS_ADI_COMMON_PVT.handle_fatal_error();
1776:
1777: AMS_ADI_MEDIA_PLANNER_PVT.purge_import_metrics(
1778: p_object_type => 'CSCH',
1779: p_object_name => l_objectNames(i),

Line 1797: AMS_ADI_COMMON_PVT.complete_batch(

1793: AMS_UTILITY_PVT.debug_message('Calling Complete batch');
1794: END IF;
1795:
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,

Line 1815: AMS_ADI_COMMON_PVT.complete_all();

1811: IF (AMS_DEBUG_HIGH_ON) THEN
1812: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Calling Complete all');
1813: END IF;
1814:
1815: AMS_ADI_COMMON_PVT.complete_all();
1816:
1817: -- Debug Message
1818: IF (AMS_DEBUG_HIGH_ON) THEN
1819: AMS_UTILITY_PVT.Write_Conc_Log('Private API: ' || pkg_name || '.' || l_api_name ||'Done with all');

Line 1897: p_error_records IN OUT NOCOPY AMS_ADI_COMMON_PVT.ams_adi_error_rec_t,

1893: procedure Handle_Ret_Status_For_Import (
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

Line 1915: AMS_ADI_COMMON_PVT.handle_success_row(p_commit);

1911: p_parent_id => p_parent_object_id
1912: );
1913: END IF;
1914:
1915: AMS_ADI_COMMON_PVT.handle_success_row(p_commit);
1916:
1917: ELSE
1918: ROLLBACK to Import_Schedule_PVT;
1919:

Line 1920: AMS_ADI_COMMON_PVT.handle_error_row(

1916:
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,