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

Line 92: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

88:
89: Procedure SCHEDULE_LIST(errbuf OUT NOCOPY varchar2,
90: retcode OUT NOCOPY number,
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_list_header_id IN NUMBER,
96: p_list_used_by_id IN VARCHAR2 := NULL,

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

89: Procedure SCHEDULE_LIST(errbuf OUT NOCOPY varchar2,
90: retcode OUT NOCOPY number,
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_list_header_id IN NUMBER,
96: p_list_used_by_id IN VARCHAR2 := NULL,
97: p_arc_list_used_by IN VARCHAR2 := NULL,

Line 94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

90: retcode OUT NOCOPY number,
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
93: p_commit IN VARCHAR2 := FND_API.G_FALSE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: p_list_header_id IN NUMBER,
96: p_list_used_by_id IN VARCHAR2 := NULL,
97: p_arc_list_used_by IN VARCHAR2 := NULL,
98: p_new_list_name IN VARCHAR2 := NULL,

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

131: x_msg_count => l_msg_count,
132: x_msg_data => l_msg_data);
133:
134:
135: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)THEN
136: retcode :=0;
137: ELSE
138: retcode :=1;
139: END IF;

Line 190: p_init_msg_list => FND_API.G_TRUE,

186:
187: IF (p_time IS NOT NULL)
188: THEN
189: AMS_UTILITY_PVT.Convert_Timezone(
190: p_init_msg_list => FND_API.G_TRUE,
191: x_return_status => l_return_status,
192: x_msg_count => l_msg_count,
193: x_msg_data => l_msg_data,
194:

Line 203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

199: x_out_time => l_start_time
200: );
201:
202: -- If any errors happen let start time be sysdate
203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: l_start_time := sysdate;
205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
206: l_start_time := sysdate;
207: END IF;

Line 205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

201:
202: -- If any errors happen let start time be sysdate
203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: l_start_time := sysdate;
205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
206: l_start_time := sysdate;
207: END IF;
208: END IF;
209:

Line 219: argument2 => FND_API.G_TRUE,

215: x_schedule_id := FND_REQUEST.SUBMIT_REQUEST(application => 'AMS',
216: program => 'AMSLISTGEN',
217: start_time => to_char(l_start_time,'DD-MON-YYYY HH24:MI'),
218: argument1 => 1.0,
219: argument2 => FND_API.G_TRUE,
220: argument3 => FND_API.G_FALSE,
221: argument4 => FND_API.G_VALID_LEVEL_FULL,
222:
223: argument5 => p_list_header_id,

Line 220: argument3 => FND_API.G_FALSE,

216: program => 'AMSLISTGEN',
217: start_time => to_char(l_start_time,'DD-MON-YYYY HH24:MI'),
218: argument1 => 1.0,
219: argument2 => FND_API.G_TRUE,
220: argument3 => FND_API.G_FALSE,
221: argument4 => FND_API.G_VALID_LEVEL_FULL,
222:
223: argument5 => p_list_header_id,
224: argument6 => p_list_used_by_id,

Line 221: argument4 => FND_API.G_VALID_LEVEL_FULL,

217: start_time => to_char(l_start_time,'DD-MON-YYYY HH24:MI'),
218: argument1 => 1.0,
219: argument2 => FND_API.G_TRUE,
220: argument3 => FND_API.G_FALSE,
221: argument4 => FND_API.G_VALID_LEVEL_FULL,
222:
223: argument5 => p_list_header_id,
224: argument6 => p_list_used_by_id,
225: argument7 => p_arc_list_used_by,

Line 262: l_return_status := FND_API.G_TRUE;

258: Begin
259:
260: null;
261: /*
262: l_return_status := FND_API.G_TRUE;
263:
264: IF(p_arc_list_used_by = 'CSCH')THEN
265: IF AMS_Utility_PVT.check_fk_exists(
266: 'ams_campaign_schedules',

Line 268: p_list_used_by_id) = FND_API.g_false

264: IF(p_arc_list_used_by = 'CSCH')THEN
265: IF AMS_Utility_PVT.check_fk_exists(
266: 'ams_campaign_schedules',
267: 'campaign_schedule_id',
268: p_list_used_by_id) = FND_API.g_false
269: THEN
270: l_return_status := FND_API.G_FALSE;
271: RETURN l_return_status;
272:

Line 270: l_return_status := FND_API.G_FALSE;

266: 'ams_campaign_schedules',
267: 'campaign_schedule_id',
268: p_list_used_by_id) = FND_API.g_false
269: THEN
270: l_return_status := FND_API.G_FALSE;
271: RETURN l_return_status;
272:
273: END IF;
274: ELSIF(p_arc_list_used_by = 'CAMP')THEN

Line 278: p_list_used_by_id) = FND_API.g_false

274: ELSIF(p_arc_list_used_by = 'CAMP')THEN
275: IF AMS_Utility_PVT.check_fk_exists(
276: 'ams_campaigns_all_b',
277: 'campaign_id',
278: p_list_used_by_id) = FND_API.g_false
279: THEN
280: l_return_status := FND_API.G_FALSE;
281: RETURN l_return_status;
282: END IF;

Line 280: l_return_status := FND_API.G_FALSE;

276: 'ams_campaigns_all_b',
277: 'campaign_id',
278: p_list_used_by_id) = FND_API.g_false
279: THEN
280: l_return_status := FND_API.G_FALSE;
281: RETURN l_return_status;
282: END IF;
283: ELSIF(p_arc_list_used_by = 'EVEO')THEN
284: IF AMS_Utility_PVT.check_fk_exists(

Line 287: p_list_used_by_id) = FND_API.g_false

283: ELSIF(p_arc_list_used_by = 'EVEO')THEN
284: IF AMS_Utility_PVT.check_fk_exists(
285: 'ams_event_offers_all_b',
286: 'event_offer_id',
287: p_list_used_by_id) = FND_API.g_false
288: THEN
289: l_return_status := FND_API.G_FALSE;
290: RETURN l_return_status;
291: END IF;

Line 289: l_return_status := FND_API.G_FALSE;

285: 'ams_event_offers_all_b',
286: 'event_offer_id',
287: p_list_used_by_id) = FND_API.g_false
288: THEN
289: l_return_status := FND_API.G_FALSE;
290: RETURN l_return_status;
291: END IF;
292: ELSIF(p_arc_list_used_by = 'EVEH')THEN
293: IF AMS_Utility_PVT.check_fk_exists(

Line 296: p_list_used_by_id) = FND_API.g_false

292: ELSIF(p_arc_list_used_by = 'EVEH')THEN
293: IF AMS_Utility_PVT.check_fk_exists(
294: 'ams_event_headers_all_b',
295: 'event_header_id',
296: p_list_used_by_id) = FND_API.g_false
297: THEN
298: l_return_status := FND_API.G_FALSE;
299: RETURN l_return_status ;
300: END IF;

Line 298: l_return_status := FND_API.G_FALSE;

294: 'ams_event_headers_all_b',
295: 'event_header_id',
296: p_list_used_by_id) = FND_API.g_false
297: THEN
298: l_return_status := FND_API.G_FALSE;
299: RETURN l_return_status ;
300: END IF;
301: ELSE
302: l_return_status := FND_API.G_FALSE;

Line 302: l_return_status := FND_API.G_FALSE;

298: l_return_status := FND_API.G_FALSE;
299: RETURN l_return_status ;
300: END IF;
301: ELSE
302: l_return_status := FND_API.G_FALSE;
303: RETURN l_return_status ;
304: END IF;
305:
306: */

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

345: -----------------------------------------------------------------------------------------------
346: -- End of Comments
347:
348: Procedure Create_Source_View(p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
350: p_commit IN VARCHAR2 := FND_API.g_false,
351: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
352:
353: p_user_id IN NUMBER,

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

346: -- End of Comments
347:
348: Procedure Create_Source_View(p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
350: p_commit IN VARCHAR2 := FND_API.g_false,
351: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
352:
353: p_user_id IN NUMBER,
354: p_resp_id IN NUMBER,

Line 351: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

347:
348: Procedure Create_Source_View(p_api_version IN NUMBER,
349: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
350: p_commit IN VARCHAR2 := FND_API.g_false,
351: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
352:
353: p_user_id IN NUMBER,
354: p_resp_id IN NUMBER,
355: p_resp_appl_id IN NUMBER,

Line 415: IF NOT FND_API.Compatible_API_Call ( l_api_version,

411: -- Standard Start of API savepoint
412: SAVEPOINT Create_Source_View;
413:
414: -- Standard call to check for call compatibility.
415: IF NOT FND_API.Compatible_API_Call ( l_api_version,
416: p_api_version,
417: l_api_name,
418: G_PKG_NAME)
419: THEN

Line 420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416: p_api_version,
417: l_api_name,
418: G_PKG_NAME)
419: THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:
423:
424: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 425: IF FND_API.to_Boolean( p_init_msg_list ) THEN

421: END IF;
422:
423:
424: -- Initialize message list IF p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: -- Debug Message

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433: FND_MSG_PUB.Add;
434: END IF;
435:
436: -- Initialize API return status to success
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439:
440: fnd_global.apps_initialize(p_user_id,p_resp_id,p_resp_appl_id);
441:

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

514: ||' and alt.source_type_code = '|| ''''||
515: upper(p_source_type_code) ||''''
516: ||' and ale.import_list_header_id = ail.import_list_header_id ';
517: else
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519:
520: end if;
521:
522:

Line 531: IF FND_API.To_Boolean ( p_commit )

527:
528:
529:
530: -- Standard check of p_commit.
531: IF FND_API.To_Boolean ( p_commit )
532: THEN
533: COMMIT WORK;
534: END IF;
535:

Line 557: p_encoded => FND_API.G_FALSE

553: -- Standard call to get message count AND IF count is 1, get message info.
554: FND_MSG_PUB.Count_AND_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data,
557: p_encoded => FND_API.G_FALSE
558: );
559:
560:
561:

Line 564: WHEN FND_API.G_EXC_ERROR THEN

560:
561:
562: EXCEPTION
563:
564: WHEN FND_API.G_EXC_ERROR THEN
565:
566: ROLLBACK TO Create_Source_View;
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: g_sqlerrm := SQLERRM;

Line 567: x_return_status := FND_API.G_RET_STS_ERROR ;

563:
564: WHEN FND_API.G_EXC_ERROR THEN
565:
566: ROLLBACK TO Create_Source_View;
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: g_sqlerrm := SQLERRM;
569: g_sqlcode := SQLCODE;
570: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);
571:

Line 575: p_encoded => FND_API.G_FALSE

571:
572: FND_MSG_PUB.Count_AND_Get
573: ( p_count => x_msg_count,
574: p_data => x_msg_data,
575: p_encoded => FND_API.G_FALSE
576: );
577:
578:
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

575: p_encoded => FND_API.G_FALSE
576: );
577:
578:
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580:
581: ROLLBACK TO Create_Source_View;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583:

Line 582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

578:
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580:
581: ROLLBACK TO Create_Source_View;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583:
584: g_sqlerrm := SQLERRM;
585: g_sqlcode := SQLCODE;
586: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);

Line 591: p_encoded => FND_API.G_FALSE

587:
588: FND_MSG_PUB.Count_AND_Get
589: ( p_count => x_msg_count,
590: p_data => x_msg_data,
591: p_encoded => FND_API.G_FALSE
592: );
593:
594: WHEN OTHERS THEN
595:

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

593:
594: WHEN OTHERS THEN
595:
596: ROLLBACK TO Create_Source_View;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598:
599: g_sqlerrm := SQLERRM;
600: g_sqlcode := SQLCODE;
601: --dbms_output.put_line('AMS_List_Maint_PVT.Create_Source_View:'||g_sqlerrm||g_sqlcode);

Line 611: p_encoded => FND_API.G_FALSE

607:
608: FND_MSG_PUB.Count_AND_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data,
611: p_encoded => FND_API.G_FALSE
612: );
613:
614: End Create_Source_View;
615:

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

643: -- 10/27/1999 tdonohoe created
644: -- 06/22/2000 tdonohoe modified cursors to explicitly name columns
645: ---------------------------------------------------------------------
646: Procedure Copy_List (p_api_version IN NUMBER,
647: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
648: p_commit IN VARCHAR2 := FND_API.g_false,
649: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
650:
651: x_return_status OUT NOCOPY VARCHAR2,

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

644: -- 06/22/2000 tdonohoe modified cursors to explicitly name columns
645: ---------------------------------------------------------------------
646: Procedure Copy_List (p_api_version IN NUMBER,
647: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
648: p_commit IN VARCHAR2 := FND_API.g_false,
649: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
650:
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,

Line 649: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

645: ---------------------------------------------------------------------
646: Procedure Copy_List (p_api_version IN NUMBER,
647: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
648: p_commit IN VARCHAR2 := FND_API.g_false,
649: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
650:
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2,

Line 850: IF NOT FND_API.Compatible_API_Call ( l_api_version,

846: -- Standard Start of API savepoint
847: SAVEPOINT Copy_List;
848:
849: -- Standard call to check for call compatibility.
850: IF NOT FND_API.Compatible_API_Call ( l_api_version,
851: p_api_version,
852: l_api_name,
853: G_PKG_NAME)
854: THEN

Line 855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

851: p_api_version,
852: l_api_name,
853: G_PKG_NAME)
854: THEN
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
856: END IF;
857:
858:
859: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 860: IF FND_API.to_Boolean( p_init_msg_list ) THEN

856: END IF;
857:
858:
859: -- Initialize message list IF p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list ) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Debug Message

Line 873: x_return_status := FND_API.G_RET_STS_SUCCESS;

869: FND_MSG_PUB.Add;
870: END IF;
871:
872: -- Initialize API return status to success
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: --------------------------------------------------------------------------------
876: --Check that(if specified) the entity to associate the list with is valid. --
877: --------------------------------------------------------------------------------

Line 879: IF ( Check_List_Association(p_arc_list_used_by,p_list_used_by_id) = FND_API.g_false )THEN

875: --------------------------------------------------------------------------------
876: --Check that(if specified) the entity to associate the list with is valid. --
877: --------------------------------------------------------------------------------
878: IF(p_list_used_by_id IS NOT NULL and p_arc_list_used_by IS NOT NULL)THEN
879: IF ( Check_List_Association(p_arc_list_used_by,p_list_used_by_id) = FND_API.g_false )THEN
880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
881: THEN
882: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_USED_BY_ID');
883: FND_MSG_PUB.add;

Line 885: x_return_status := FND_API.g_ret_sts_error;

881: THEN
882: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_USED_BY_ID');
883: FND_MSG_PUB.add;
884: END IF;
885: x_return_status := FND_API.g_ret_sts_error;
886: RETURN;
887: END IF;
888: END IF;--P_ARC_LIST_USED_BY AND P_LIST_USED_BY_ID CHECK
889:

Line 896: p_lookup_code => p_list_type) = FND_API.g_false THEN

892: --------------------------------------------------------------------------------
893: IF(p_list_type IS NOT NULL)THEN
894: IF AMS_Utility_PVT.check_lookup_exists(
895: p_lookup_type => 'AMS_LIST_TYPE',
896: p_lookup_code => p_list_type) = FND_API.g_false THEN
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
899: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_TYPE');
900: FND_MSG_PUB.add;

Line 903: x_return_status := FND_API.g_ret_sts_error;

899: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_TYPE');
900: FND_MSG_PUB.add;
901: END IF;
902:
903: x_return_status := FND_API.g_ret_sts_error;
904: RETURN;
905: END IF;
906: END IF;
907:

Line 920: x_return_status := FND_API.G_RET_STS_ERROR;

916: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
917: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ID_NOT_EXIST');
918: FND_MSG_PUB.Add;
919: END IF;
920: x_return_status := FND_API.G_RET_STS_ERROR;
921: RETURN;
922: END IF;
923: CLOSE C_ListHeader_Dets;
924:

Line 930: x_return_status := FND_API.G_RET_STS_ERROR;

926: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
927: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_BAD_COPY_INC');
928: FND_MSG_PUB.Add;
929: END IF;
930: x_return_status := FND_API.G_RET_STS_ERROR;
931: RETURN;
932: END IF;
933:
934: -------------------------------------------------------------------------

Line 988: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN

984: x_msg_data => l_msg_data,
985: p_listheader_rec => g_listheader_rec,
986: x_listheader_id => l_list_header_id);
987:
988: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
989: Raise FND_API.G_EXC_ERROR;
990: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: END IF;

Line 989: Raise FND_API.G_EXC_ERROR;

985: p_listheader_rec => g_listheader_rec,
986: x_listheader_id => l_list_header_id);
987:
988: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
989: Raise FND_API.G_EXC_ERROR;
990: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: END IF;
993:

Line 990: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

986: x_listheader_id => l_list_header_id);
987:
988: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
989: Raise FND_API.G_EXC_ERROR;
990: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: END IF;
993:
994: x_list_id := l_list_header_id;

Line 991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

987:
988: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
989: Raise FND_API.G_EXC_ERROR;
990: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: END IF;
993:
994: x_list_id := l_list_header_id;
995:

Line 1022: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN

1018: x_msg_data => l_msg_data,
1019: p_action_rec => g_listaction_rec,
1020: x_action_id => l_action_id);
1021:
1022: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
1023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1024: END IF;
1025:
1026: END LOOP;

Line 1023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1019: p_action_rec => g_listaction_rec,
1020: x_action_id => l_action_id);
1021:
1022: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
1023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1024: END IF;
1025:
1026: END LOOP;
1027: CLOSE c_listaction_dets;

Line 1048: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN

1044: x_msg_data => l_msg_data,
1045: p_action_rec => g_listaction_rec,
1046: x_action_id => l_action_id);
1047:
1048: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
1049: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1050: END IF;
1051: END IF;--P_COPY_OPTION CHECK.
1052:

Line 1049: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1045: p_action_rec => g_listaction_rec,
1046: x_action_id => l_action_id);
1047:
1048: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
1049: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1050: END IF;
1051: END IF;--P_COPY_OPTION CHECK.
1052:
1053: -----------------------------------------------------------------------------------

Line 1095: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN

1091: x_msg_data => l_msg_data,
1092: p_action_rec => g_listaction_rec,
1093: x_action_id => l_action_id);
1094:
1095: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
1096: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098: END LOOP;
1099: END IF; --REPEAT LIST COUNT CHECK;

Line 1096: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1092: p_action_rec => g_listaction_rec,
1093: x_action_id => l_action_id);
1094:
1095: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
1096: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098: END LOOP;
1099: END IF; --REPEAT LIST COUNT CHECK;
1100: END IF; --REPEAT LIST CHECK.

Line 1103: IF FND_API.To_Boolean ( p_commit )

1099: END IF; --REPEAT LIST COUNT CHECK;
1100: END IF; --REPEAT LIST CHECK.
1101:
1102: -- Standard check of p_commit.
1103: IF FND_API.To_Boolean ( p_commit )
1104: THEN
1105: COMMIT WORK;
1106: END IF;
1107:

Line 1127: p_encoded => FND_API.G_FALSE);

1123: -- Standard call to get message count AND IF count is 1, get message info.
1124: FND_MSG_PUB.Count_AND_Get
1125: ( p_count => x_msg_count,
1126: p_data => x_msg_data,
1127: p_encoded => FND_API.G_FALSE);
1128:
1129:
1130: EXCEPTION
1131: WHEN FND_API.G_EXC_ERROR THEN

Line 1131: WHEN FND_API.G_EXC_ERROR THEN

1127: p_encoded => FND_API.G_FALSE);
1128:
1129:
1130: EXCEPTION
1131: WHEN FND_API.G_EXC_ERROR THEN
1132:
1133: ROLLBACK TO Copy_List;
1134: x_return_status := FND_API.G_RET_STS_ERROR ;
1135: g_sqlerrm := SQLERRM;

Line 1134: x_return_status := FND_API.G_RET_STS_ERROR ;

1130: EXCEPTION
1131: WHEN FND_API.G_EXC_ERROR THEN
1132:
1133: ROLLBACK TO Copy_List;
1134: x_return_status := FND_API.G_RET_STS_ERROR ;
1135: g_sqlerrm := SQLERRM;
1136: g_sqlcode := SQLCODE;
1137: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);
1138:

Line 1142: p_encoded => FND_API.G_FALSE

1138:
1139: FND_MSG_PUB.Count_AND_Get
1140: ( p_count => x_msg_count,
1141: p_data => x_msg_data,
1142: p_encoded => FND_API.G_FALSE
1143: );
1144:
1145:
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1142: p_encoded => FND_API.G_FALSE
1143: );
1144:
1145:
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147:
1148: ROLLBACK TO Copy_List;
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1150:

Line 1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1145:
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147:
1148: ROLLBACK TO Copy_List;
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1150:
1151: g_sqlerrm := SQLERRM;
1152: g_sqlcode := SQLCODE;
1153: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);

Line 1158: p_encoded => FND_API.G_FALSE

1154:
1155: FND_MSG_PUB.Count_AND_Get
1156: ( p_count => x_msg_count,
1157: p_data => x_msg_data,
1158: p_encoded => FND_API.G_FALSE
1159: );
1160:
1161: WHEN OTHERS THEN
1162:

Line 1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1160:
1161: WHEN OTHERS THEN
1162:
1163: ROLLBACK TO Copy_List;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165:
1166: g_sqlerrm := SQLERRM;
1167: g_sqlcode := SQLCODE;
1168: --dbms_output.put_line('AMS_List_Maint_PVT.Copy_List:'||g_sqlerrm||g_sqlcode);

Line 1178: p_encoded => FND_API.G_FALSE

1174:
1175: FND_MSG_PUB.Count_AND_Get
1176: ( p_count => x_msg_count,
1177: p_data => x_msg_data,
1178: p_encoded => FND_API.G_FALSE
1179: );
1180:
1181:
1182: */

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

1200: -- created vbhandar 2/16/2000
1201: ---------------------------------------------------------------------
1202: PROCEDURE Get_PinCodeData_Rec (
1203: p_api_version IN NUMBER,
1204: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1206:
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,

Line 1205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1201: ---------------------------------------------------------------------
1202: PROCEDURE Get_PinCodeData_Rec (
1203: p_api_version IN NUMBER,
1204: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1205: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1206:
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,

Line 1248: IF FND_API.to_boolean (p_init_msg_list) THEN

1244: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1245:
1246: END IF;
1247:
1248: IF FND_API.to_boolean (p_init_msg_list) THEN
1249: FND_MSG_PUB.initialize;
1250: END IF;
1251:
1252: IF NOT FND_API.compatible_api_call (

Line 1252: IF NOT FND_API.compatible_api_call (

1248: IF FND_API.to_boolean (p_init_msg_list) THEN
1249: FND_MSG_PUB.initialize;
1250: END IF;
1251:
1252: IF NOT FND_API.compatible_api_call (
1253: l_api_version,
1254: p_api_version,
1255: l_api_name,
1256: g_pkg_name

Line 1258: RAISE FND_API.g_exc_unexpected_error;

1254: p_api_version,
1255: l_api_name,
1256: g_pkg_name
1257: ) THEN
1258: RAISE FND_API.g_exc_unexpected_error;
1259: END IF;
1260:
1261: x_return_status := FND_API.g_ret_sts_success;
1262:

Line 1261: x_return_status := FND_API.g_ret_sts_success;

1257: ) THEN
1258: RAISE FND_API.g_exc_unexpected_error;
1259: END IF;
1260:
1261: x_return_status := FND_API.g_ret_sts_success;
1262:
1263: ------------------------ select ------------------------
1264: OPEN C_ListEntry_Dets;
1265: FETCH C_ListEntry_Dets INTO x_listentry_rec;

Line 1272: RAISE FND_API.g_exc_error;

1268: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1269: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1270: FND_MSG_PUB.add;
1271: END IF;
1272: RAISE FND_API.g_exc_error;
1273: END IF;
1274: CLOSE C_ListEntry_Dets;
1275:
1276: END Get_PinCodeData_Rec;