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.IES_SVY_DEPLOYMENT_PVT dependencies on FND_API

Line 30: -- Modified vacharya 03/19/01 Need to provide value of p_commit as FND_API.G_TRUE when you call Submit_Deployment

26: -- list_entry_id - list entry identifier
27: -- template_id - fulfillment template identifier
28: -- NOTES
29: -- created rrsundar 05/03/2000
30: -- Modified vacharya 03/19/01 Need to provide value of p_commit as FND_API.G_TRUE when you call Submit_Deployment
31: -- the file has been modified to allow for PL/SQL Commits if certain conditions are met
32: ---------------------------------------------------------------------------------------------------------
33: Procedure Submit_Deployment
34: (

Line 36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

32: ---------------------------------------------------------------------------------------------------------
33: Procedure Submit_Deployment
34: (
35: p_api_version IN NUMBER ,
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
37: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
39: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
40: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,

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

33: Procedure Submit_Deployment
34: (
35: p_api_version IN NUMBER ,
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
37: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
39: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
40: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
41: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

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

34: (
35: p_api_version IN NUMBER ,
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
37: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
39: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
40: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
41: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
42: x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

Line 91: IF NOT FND_API.Compatible_API_Call (

87:
88:
89: -- Check API Compatability
90:
91: IF NOT FND_API.Compatible_API_Call (
92: l_api_version,
93: p_api_version,
94: l_api_name,
95: G_PKG_NAME)

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: p_api_version,
94: l_api_name,
95: G_PKG_NAME)
96: THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: -- Create a Savepoint for Rollback
101:

Line 115: p_init_msg_list => FND_API.G_TRUE,

111: -- Populate Survey List Entries table
112:
113: Populate_Survey_List_Entries
114: (p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_TRUE,
116: p_commit => FND_API.G_FALSE,
117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
118: x_return_status => l_return_status,
119: x_msg_count => l_msg_count,

Line 116: p_commit => FND_API.G_FALSE,

112:
113: Populate_Survey_List_Entries
114: (p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_TRUE,
116: p_commit => FND_API.G_FALSE,
117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
118: x_return_status => l_return_status,
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data,

Line 117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

113: Populate_Survey_List_Entries
114: (p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_TRUE,
116: p_commit => FND_API.G_FALSE,
117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
118: x_return_status => l_return_status,
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data,
121: x_message => l_Error_Msg,

Line 134: IF FND_API.To_Boolean (p_init_msg_list) THEN

130: return;
131: END IF;
132:
133: --Initialize message list if p_init_msg_list is TRUE.
134: IF FND_API.To_Boolean (p_init_msg_list) THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137:
138: -- Initialize API return status to success

Line 140: x_return_status := FND_API.G_RET_STS_SUCCESS;

136: END IF;
137:
138: -- Initialize API return status to success
139:
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141: x_message := NULL;
142: x_msg_count := 0;
143: x_msg_data := NULL;
144:

Line 150: FND_API.G_FALSE,

146:
147: IF ((p_list_entry_id is not NULL) AND ( p_deployment_id is not NULL)) THEN
148: FM_Single_Request(
149: l_api_version ,
150: FND_API.G_FALSE,
151: FND_API.G_FALSE,
152: FND_API.G_VALID_LEVEL_FULL,
153: x_return_status,
154: x_msg_count,

Line 151: FND_API.G_FALSE,

147: IF ((p_list_entry_id is not NULL) AND ( p_deployment_id is not NULL)) THEN
148: FM_Single_Request(
149: l_api_version ,
150: FND_API.G_FALSE,
151: FND_API.G_FALSE,
152: FND_API.G_VALID_LEVEL_FULL,
153: x_return_status,
154: x_msg_count,
155: x_msg_data,

Line 152: FND_API.G_VALID_LEVEL_FULL,

148: FM_Single_Request(
149: l_api_version ,
150: FND_API.G_FALSE,
151: FND_API.G_FALSE,
152: FND_API.G_VALID_LEVEL_FULL,
153: x_return_status,
154: x_msg_count,
155: x_msg_data,
156: x_message,

Line 250: RAISE FND_API.G_EXC_ERROR;

246: argument7 => l_reminder_type,
247: argument8 => p_user_id,
248: argument9 => l_reminder_hst_id);
249: IF (l_schedule_id = 0) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSE
252: UPDATE ies_svy_reminder_hst_v
253: SET CONCURRENT_REQ_ID = l_schedule_id
254: WHERE SURVEY_REMINDER_HST_ID = l_reminder_hst_id;

Line 262: WHEN FND_API.G_EXC_ERROR THEN

258: END LOOP;
259: END IF;
260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263: ROLLBACK TO Submit_Deployment;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: x_message := SQLERRM;
266: FND_MSG_PUB.Count_And_Get

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263: ROLLBACK TO Submit_Deployment;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: x_message := SQLERRM;
266: FND_MSG_PUB.Count_And_Get
267: ( p_count => x_msg_count,
268: p_data => x_msg_data

Line 270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

266: FND_MSG_PUB.Count_And_Get
267: ( p_count => x_msg_count,
268: p_data => x_msg_data
269: );
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: ROLLBACK TO Submit_Deployment;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: x_message := SQLERRM;
274: FND_MSG_PUB.Count_And_Get

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

268: p_data => x_msg_data
269: );
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: ROLLBACK TO Submit_Deployment;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: x_message := SQLERRM;
274: FND_MSG_PUB.Count_And_Get
275: ( p_count => x_msg_count ,
276: p_data => x_msg_data

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276: p_data => x_msg_data
277: );
278: WHEN OTHERS THEN
279: rollback to Submit_Deployment;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: x_message := SQLERRM;
282: FND_MSG_PUB.Count_And_Get
283: (p_count => x_msg_count ,
284: p_data => x_msg_data

Line 301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

297: -- created kpandey 05/02/2000
298: ---------------------------------------------------------------------------------------------------------
299: PROCEDURE FM_Single_Request(
300: p_api_version IN NUMBER ,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
304: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
305: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,

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

298: ---------------------------------------------------------------------------------------------------------
299: PROCEDURE FM_Single_Request(
300: p_api_version IN NUMBER ,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
304: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
305: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
306: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

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

299: PROCEDURE FM_Single_Request(
300: p_api_version IN NUMBER ,
301: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
302: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
304: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
305: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
306: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
307: x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

Line 317: l_commit VARCHAR2(5) := FND_API.G_FALSE;

313:
314: IS
315: l_api_version NUMBER := 1.0;
316: l_api_name CONSTANT VARCHAR2(30) := 'FM_Request_From_Survey';
317: l_commit VARCHAR2(5) := FND_API.G_FALSE;
318: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
319: l_Error_Msg VARCHAR2(2000) ;
320: l_content_id VARCHAR2(30);
321: l_media_type VARCHAR2(30);

Line 375: IF NOT FND_API.Compatible_API_Call (

371: SAVEPOINT FM_Request_From_Survey;
372:
373: -- Check API Compatibility
374:
375: IF NOT FND_API.Compatible_API_Call (
376: l_api_version,
377: p_api_version,
378: l_api_name,
379: G_PKG_NAME) THEN

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

377: p_api_version,
378: l_api_name,
379: G_PKG_NAME) THEN
380: x_message := 'API not compatible';
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: --Initialize message list if p_init_msg_list is TRUE.
385: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 385: IF FND_API.To_Boolean (p_init_msg_list) THEN

381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: --Initialize message list if p_init_msg_list is TRUE.
385: IF FND_API.To_Boolean (p_init_msg_list) THEN
386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: -- Debug Message

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: FND_MSG_PUB.Add;
394: END IF;
395:
396: -- Initialize API return status to success
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399:
400: OPEN CEMAILADD;
401: FETCH CEMAILADD into l_email;

Line 410: RAISE FND_API.G_EXC_ERROR;

406: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
407: FND_MSG_PUB.Add;
408: END IF;
409: x_message := l_Error_Msg;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412: CLOSE CEMAILADD;
413:
414:

Line 425: RAISE FND_API.G_EXC_ERROR;

421: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
422: FND_MSG_PUB.Add;
423: END IF;
424: x_message := l_Error_Msg;
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: CLOSE CEMAILSUBJECTHEADING;
428:
429:

Line 450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

446: x_msg_data => l_msg_data,
447: x_request_id => l_request_id
448: );
449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;

Line 451: RAISE FND_API.G_EXC_ERROR;

447: x_request_id => l_request_id
448: );
449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:

Line 452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

448: );
449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456:

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456:
457: -- Check if a template has contents (MD or collateral)

Line 505: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

501: p_bind_var_type => l_bind_var_type,
502: p_request_id => l_request_id,
503: x_content_xml => l_content_xml1);
504:
505: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
506: RAISE FND_API.G_EXC_ERROR;
507: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;

Line 506: RAISE FND_API.G_EXC_ERROR;

502: p_request_id => l_request_id,
503: x_content_xml => l_content_xml1);
504:
505: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
506: RAISE FND_API.G_EXC_ERROR;
507: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510:

Line 507: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

503: x_content_xml => l_content_xml1);
504:
505: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
506: RAISE FND_API.G_EXC_ERROR;
507: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510:
511: -- The output XML string is stored in a local variable

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504:
505: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
506: RAISE FND_API.G_EXC_ERROR;
507: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510:
511: -- The output XML string is stored in a local variable
512: l_content_xml := l_content_xml || l_content_xml1;

Line 525: RAISE FND_API.G_EXC_ERROR;

521: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
522: FND_MSG_PUB.Add;
523: END IF;
524: x_message := l_Error_Msg;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527:
528: CLOSE CCONTENT;
529:

Line 545: p_queue_response => FND_API.G_TRUE,

541: p_subject => l_subject,
542: p_party_id => l_party_id,
543: p_user_id => l_user_id,
544: p_server_id => l_server_id,
545: p_queue_response => FND_API.G_TRUE,
546: p_content_xml => l_content_xml,
547: p_request_id => l_request_id
548: );
549:

Line 550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

546: p_content_xml => l_content_xml,
547: p_request_id => l_request_id
548: );
549:
550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;

Line 551: RAISE FND_API.G_EXC_ERROR;

547: p_request_id => l_request_id
548: );
549:
550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:

Line 552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

548: );
549:
550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:
556:

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

549:
550: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:
556:
557: FND_MESSAGE.Set_Name('IES','IES_SVY_SUCCESS_REMINDER');

Line 598: WHEN FND_API.G_EXC_ERROR THEN

594: ,l_request_id);
595:
596: x_message := x_message || ' ,Entry inserted in ies_svy_entrs_remind_hst';
597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: ROLLBACK TO FM_Request_From_Survey;
600: x_return_status := FND_API.G_RET_STS_ERROR ;
601: x_message := x_message || ' ' ||SQLERRM;
602: -- write the error msg to log, if conc request is executing this code then

Line 600: x_return_status := FND_API.G_RET_STS_ERROR ;

596: x_message := x_message || ' ,Entry inserted in ies_svy_entrs_remind_hst';
597: EXCEPTION
598: WHEN FND_API.G_EXC_ERROR THEN
599: ROLLBACK TO FM_Request_From_Survey;
600: x_return_status := FND_API.G_RET_STS_ERROR ;
601: x_message := x_message || ' ' ||SQLERRM;
602: -- write the error msg to log, if conc request is executing this code then
603: -- the log is viewable in concurrent manger log for that specific request
604: if(l_msg_count is not null) then

Line 608: p_encoded => FND_API.G_FALSE);

604: if(l_msg_count is not null) then
605: for l_index IN 1..l_msg_count loop
606: l_msg_data :=FND_MSG_PUB.Get(
607: p_msg_index => l_index,
608: p_encoded => FND_API.G_FALSE);
609: x_msg_data := l_msg_data;
610: end loop;
611: end if;
612: JTF_FM_REQUEST_GRP.Cancel_Request

Line 615: p_init_msg_list => FND_API.G_FALSE,

611: end if;
612: JTF_FM_REQUEST_GRP.Cancel_Request
613: (p_api_version => l_api_version,
614: p_commit => l_commit,
615: p_init_msg_list => FND_API.G_FALSE,
616: x_return_status => l_return_status,
617: x_msg_count => l_msg_count,
618: x_msg_data => l_msg_data,
619: p_request_id => l_request_id);

Line 620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

616: x_return_status => l_return_status,
617: x_msg_count => l_msg_count,
618: x_msg_data => l_msg_data,
619: p_request_id => l_request_id);
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621: ROLLBACK TO FM_Request_From_Survey;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
623: x_message := x_message || ' ' || SQLERRM;
624: -- write the error msg to log, if conc request is executing this code then

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

618: x_msg_data => l_msg_data,
619: p_request_id => l_request_id);
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621: ROLLBACK TO FM_Request_From_Survey;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
623: x_message := x_message || ' ' || SQLERRM;
624: -- write the error msg to log, if conc request is executing this code then
625: -- the log is viewable in concurrent manger log for that specific request
626: if(l_msg_count is not null) then

Line 630: p_encoded => FND_API.G_FALSE);

626: if(l_msg_count is not null) then
627: for l_index IN 1..l_msg_count loop
628: l_msg_data :=FND_MSG_PUB.Get(
629: p_msg_index => l_index,
630: p_encoded => FND_API.G_FALSE);
631: x_msg_data := l_msg_data;
632: end loop;
633: end if;
634:

Line 638: p_init_msg_list => FND_API.G_FALSE,

634:
635: JTF_FM_REQUEST_GRP.Cancel_Request
636: (p_api_version => l_api_version,
637: p_commit => l_commit,
638: p_init_msg_list => FND_API.G_FALSE,
639: x_return_status => l_return_status,
640: x_msg_count => l_msg_count,
641: x_msg_data => l_msg_data,
642: p_request_id => l_request_id);

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

642: p_request_id => l_request_id);
643: WHEN OTHERS THEN
644: -- rollback all the database actions
645: ROLLBACK to FM_Request_From_Survey;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647: x_message := x_message || ' ' || SQLERRM;
648: -- write the error msg to log, if conc request is executing this code then
649: -- the log is viewable in concurrent manger log for that specific request
650: if(l_msg_count is not null) then

Line 654: p_encoded => FND_API.G_FALSE);

650: if(l_msg_count is not null) then
651: for l_index IN 1..l_msg_count loop
652: l_msg_data :=FND_MSG_PUB.Get(
653: p_msg_index => l_index,
654: p_encoded => FND_API.G_FALSE);
655: x_msg_data := l_msg_data;
656: end loop;
657: end if;
658: -- cancel the request just sent

Line 662: p_init_msg_list => FND_API.G_FALSE,

658: -- cancel the request just sent
659: JTF_FM_REQUEST_GRP.Cancel_Request
660: (p_api_version => l_api_version,
661: p_commit => l_commit,
662: p_init_msg_list => FND_API.G_FALSE,
663: x_return_status => l_return_status,
664: x_msg_count => l_msg_count,
665: x_msg_data => l_msg_data,
666: p_request_id => l_request_id);

Line 685: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

681: PROCEDURE FM_Group_Request(
682: errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
683: retcode OUT NOCOPY /* file.sql.39 change */ NUMBER,
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
686: p_commit IN VARCHAR2 := FND_API.G_FALSE,
687: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688: p_deployment_id IN NUMBER,
689: p_template_id IN NUMBER,

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

682: errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
683: retcode OUT NOCOPY /* file.sql.39 change */ NUMBER,
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
686: p_commit IN VARCHAR2 := FND_API.G_FALSE,
687: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688: p_deployment_id IN NUMBER,
689: p_template_id IN NUMBER,
690: p_reminder_type IN VARCHAR2,

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

683: retcode OUT NOCOPY /* file.sql.39 change */ NUMBER,
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
686: p_commit IN VARCHAR2 := FND_API.G_FALSE,
687: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688: p_deployment_id IN NUMBER,
689: p_template_id IN NUMBER,
690: p_reminder_type IN VARCHAR2,
691: p_user_id IN NUMBER,

Line 707: l_commit VARCHAR2(5) := FND_API.G_FALSE;

703: x_msg_data VARCHAR2(1000) := '';
704: x_message VARCHAR2(1000) := '';
705: l_api_version NUMBER := 1.0;
706: l_api_name CONSTANT VARCHAR2(30) := 'FM_Request_From_Survey';
707: l_commit VARCHAR2(5) := FND_API.G_FALSE;
708: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
709: l_Error_Msg VARCHAR2(2000);
710:
711: l_content_id VARCHAR2(30);

Line 774: IF NOT FND_API.Compatible_API_Call (

770:
771:
772: BEGIN
773: SAVEPOINT FM_Request_From_Survey;
774: IF NOT FND_API.Compatible_API_Call (
775: l_api_version,
776: p_api_version,
777: l_api_name,
778: G_PKG_NAME)

Line 780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

776: p_api_version,
777: l_api_name,
778: G_PKG_NAME)
779: THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:
783: --Initialize message list if p_init_msg_list is TRUE.
784: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 784: IF FND_API.To_Boolean (p_init_msg_list) THEN

780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:
783: --Initialize message list if p_init_msg_list is TRUE.
784: IF FND_API.To_Boolean (p_init_msg_list) THEN
785: FND_MSG_PUB.initialize;
786: END IF;
787:
788: -- Debug Message

Line 796: x_return_status := FND_API.G_RET_STS_SUCCESS;

792: FND_MSG_PUB.Add;
793: END IF;
794:
795: -- Initialize API return status to success
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797: IF (p_deployment_id IS NULL) THEN
798: l_Error_Msg := 'Must pass p_deployment_id parameter';
799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
800: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_DEPLOYMENT_ID');

Line 804: RAISE FND_API.G_EXC_ERROR;

800: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_DEPLOYMENT_ID');
801: FND_MSG_PUB.Add;
802: END IF;
803: x_message := l_Error_Msg;
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806:
807: IF (p_template_id IS NULL) THEN
808: l_Error_Msg := 'Must pass p_template_id parameter';

Line 814: RAISE FND_API.G_EXC_ERROR;

810: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_TEMPLATE_ID');
811: FND_MSG_PUB.Add;
812: END IF;
813: x_message := l_Error_Msg;
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816:
817: if (p_reminder_type = 'REMINDER') then
818: SELECT REMINDER_EMAIL_SUBJECT

Line 833: RAISE FND_API.G_EXC_ERROR;

829: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_EMAIL_ID');
830: FND_MSG_PUB.Add;
831: END IF;
832: x_message := l_Error_Msg;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835: CLOSE CEMAILSUBJECTHEADING;
836: end if;
837:

Line 849: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

845: x_msg_data => l_msg_data,
846: x_request_id => l_request_id
847: );
848:
849: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
850: RAISE FND_API.G_EXC_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;

Line 850: RAISE FND_API.G_EXC_ERROR;

846: x_request_id => l_request_id
847: );
848:
849: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
850: RAISE FND_API.G_EXC_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;
854:

Line 851: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

847: );
848:
849: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
850: RAISE FND_API.G_EXC_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;
854:
855:

Line 852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

848:
849: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
850: RAISE FND_API.G_EXC_ERROR;
851: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;
854:
855:
856: --Check if a template has contents (MD or collateral)

Line 907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

903: p_bind_var_type => l_bind_var_type,
904: p_request_id => l_request_id,
905: x_content_xml => l_content_xml1);
906:
907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;

Line 908: RAISE FND_API.G_EXC_ERROR;

904: p_request_id => l_request_id,
905: x_content_xml => l_content_xml1);
906:
907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912:

Line 909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

905: x_content_xml => l_content_xml1);
906:
907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912:
913: -- The output XML string is stored in a local variable

Line 910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

906:
907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
908: RAISE FND_API.G_EXC_ERROR;
909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912:
913: -- The output XML string is stored in a local variable
914: l_content_xml := l_content_xml || l_content_xml1;

Line 925: RAISE FND_API.G_EXC_ERROR;

921: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
922: FND_MSG_PUB.Add;
923: END IF;
924: x_message := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927: CLOSE CCONTENT;
928: /*
929: SELECT QUERY_ID

Line 943: p_init_msg_list=> FND_API.G_TRUE,

939: -- Submit the fulfillment request
940:
941: JTF_FM_REQUEST_GRP.Submit_Mass_Request
942: ( p_api_version =>l_api_version,
943: p_init_msg_list=> FND_API.G_TRUE,
944: p_commit =>FND_API.G_FALSE,
945: p_validation_level=>FND_API.G_VALID_LEVEL_FULL,
946: x_return_status =>l_return_status,
947: x_msg_count =>l_msg_count,

Line 944: p_commit =>FND_API.G_FALSE,

940:
941: JTF_FM_REQUEST_GRP.Submit_Mass_Request
942: ( p_api_version =>l_api_version,
943: p_init_msg_list=> FND_API.G_TRUE,
944: p_commit =>FND_API.G_FALSE,
945: p_validation_level=>FND_API.G_VALID_LEVEL_FULL,
946: x_return_status =>l_return_status,
947: x_msg_count =>l_msg_count,
948: x_msg_data =>l_msg_data,

Line 945: p_validation_level=>FND_API.G_VALID_LEVEL_FULL,

941: JTF_FM_REQUEST_GRP.Submit_Mass_Request
942: ( p_api_version =>l_api_version,
943: p_init_msg_list=> FND_API.G_TRUE,
944: p_commit =>FND_API.G_FALSE,
945: p_validation_level=>FND_API.G_VALID_LEVEL_FULL,
946: x_return_status =>l_return_status,
947: x_msg_count =>l_msg_count,
948: x_msg_data =>l_msg_data,
949: p_template_id =>l_template_id,

Line 952: p_source_code_id =>FND_API.G_MISS_NUM,

948: x_msg_data =>l_msg_data,
949: p_template_id =>l_template_id,
950: p_subject => l_subject,
951: p_user_id =>l_user_id,
952: p_source_code_id =>FND_API.G_MISS_NUM,
953: p_source_code => FND_API.G_MISS_CHAR,
954: p_object_type =>FND_API.G_MISS_CHAR,
955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,

Line 953: p_source_code => FND_API.G_MISS_CHAR,

949: p_template_id =>l_template_id,
950: p_subject => l_subject,
951: p_user_id =>l_user_id,
952: p_source_code_id =>FND_API.G_MISS_NUM,
953: p_source_code => FND_API.G_MISS_CHAR,
954: p_object_type =>FND_API.G_MISS_CHAR,
955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,

Line 954: p_object_type =>FND_API.G_MISS_CHAR,

950: p_subject => l_subject,
951: p_user_id =>l_user_id,
952: p_source_code_id =>FND_API.G_MISS_NUM,
953: p_source_code => FND_API.G_MISS_CHAR,
954: p_object_type =>FND_API.G_MISS_CHAR,
955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,

Line 955: p_object_id =>FND_API.G_MISS_NUM,

951: p_user_id =>l_user_id,
952: p_source_code_id =>FND_API.G_MISS_NUM,
953: p_source_code => FND_API.G_MISS_CHAR,
954: p_object_type =>FND_API.G_MISS_CHAR,
955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,

Line 956: p_order_id =>FND_API.G_MISS_NUM,

952: p_source_code_id =>FND_API.G_MISS_NUM,
953: p_source_code => FND_API.G_MISS_CHAR,
954: p_object_type =>FND_API.G_MISS_CHAR,
955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,
960: p_server_id =>FND_API.G_MISS_NUM,

Line 957: p_doc_id => FND_API.G_MISS_NUM,

953: p_source_code => FND_API.G_MISS_CHAR,
954: p_object_type =>FND_API.G_MISS_CHAR,
955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,
960: p_server_id =>FND_API.G_MISS_NUM,
961: p_queue_response =>FND_API.G_FALSE,

Line 958: p_doc_ref => FND_API.G_MISS_CHAR,

954: p_object_type =>FND_API.G_MISS_CHAR,
955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,
960: p_server_id =>FND_API.G_MISS_NUM,
961: p_queue_response =>FND_API.G_FALSE,
962: p_extended_header =>FND_API.G_MISS_CHAR,

Line 959: p_view_nm =>FND_API.G_MISS_CHAR,

955: p_object_id =>FND_API.G_MISS_NUM,
956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,
960: p_server_id =>FND_API.G_MISS_NUM,
961: p_queue_response =>FND_API.G_FALSE,
962: p_extended_header =>FND_API.G_MISS_CHAR,
963: p_content_xml =>l_content_xml,

Line 960: p_server_id =>FND_API.G_MISS_NUM,

956: p_order_id =>FND_API.G_MISS_NUM,
957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,
960: p_server_id =>FND_API.G_MISS_NUM,
961: p_queue_response =>FND_API.G_FALSE,
962: p_extended_header =>FND_API.G_MISS_CHAR,
963: p_content_xml =>l_content_xml,
964: p_request_id =>l_request_id,

Line 961: p_queue_response =>FND_API.G_FALSE,

957: p_doc_id => FND_API.G_MISS_NUM,
958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,
960: p_server_id =>FND_API.G_MISS_NUM,
961: p_queue_response =>FND_API.G_FALSE,
962: p_extended_header =>FND_API.G_MISS_CHAR,
963: p_content_xml =>l_content_xml,
964: p_request_id =>l_request_id,
965: p_per_user_history =>FND_API.G_TRUE,

Line 962: p_extended_header =>FND_API.G_MISS_CHAR,

958: p_doc_ref => FND_API.G_MISS_CHAR,
959: p_view_nm =>FND_API.G_MISS_CHAR,
960: p_server_id =>FND_API.G_MISS_NUM,
961: p_queue_response =>FND_API.G_FALSE,
962: p_extended_header =>FND_API.G_MISS_CHAR,
963: p_content_xml =>l_content_xml,
964: p_request_id =>l_request_id,
965: p_per_user_history =>FND_API.G_TRUE,
966: p_mass_query_id =>0,

Line 965: p_per_user_history =>FND_API.G_TRUE,

961: p_queue_response =>FND_API.G_FALSE,
962: p_extended_header =>FND_API.G_MISS_CHAR,
963: p_content_xml =>l_content_xml,
964: p_request_id =>l_request_id,
965: p_per_user_history =>FND_API.G_TRUE,
966: p_mass_query_id =>0,
967: p_list_type => 'NO_LIST_TYPE');
968:
969:

Line 970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

966: p_mass_query_id =>0,
967: p_list_type => 'NO_LIST_TYPE');
968:
969:
970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;

Line 971: RAISE FND_API.G_EXC_ERROR;

967: p_list_type => 'NO_LIST_TYPE');
968:
969:
970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:

Line 972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

968:
969:
970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: -- if p_reminder_type is null then its from the deploy button so update

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969:
970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
971: RAISE FND_API.G_EXC_ERROR;
972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: -- if p_reminder_type is null then its from the deploy button so update
977: -- ies_svy_deplyments_all and populate the ies_svy_list_entries with the survey sent date else

Line 1007: WHEN FND_API.G_EXC_ERROR THEN

1003:
1004: END IF;
1005:
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: ROLLBACK TO FM_Request_From_Survey;
1009: x_return_status := FND_API.G_RET_STS_ERROR ;
1010: fnd_file.put_line(fnd_file.log, x_message);
1011: x_message := x_message || ' ' ||SQLERRM;

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR ;

1005:
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: ROLLBACK TO FM_Request_From_Survey;
1009: x_return_status := FND_API.G_RET_STS_ERROR ;
1010: fnd_file.put_line(fnd_file.log, x_message);
1011: x_message := x_message || ' ' ||SQLERRM;
1012: -- write the error msg to log, if conc request is executing this code then
1013: -- the log is viewable in concurrent manger log for that specific request

Line 1018: p_encoded => FND_API.G_FALSE);

1014: if(l_msg_count is not null) then
1015: for l_index IN 1..l_msg_count loop
1016: l_msg_data :=FND_MSG_PUB.Get(
1017: p_msg_index => l_index,
1018: p_encoded => FND_API.G_FALSE);
1019: x_msg_data := l_msg_data;
1020: fnd_file.put_line(fnd_file.log, l_msg_data);
1021: end loop;
1022: end if;

Line 1031: p_init_msg_list => FND_API.G_FALSE,

1027: );
1028: JTF_FM_REQUEST_GRP.Cancel_Request
1029: (p_api_version => l_api_version,
1030: p_commit => l_commit,
1031: p_init_msg_list => FND_API.G_FALSE,
1032: x_return_status => l_return_status,
1033: x_msg_count => l_msg_count,
1034: x_msg_data => l_msg_data,
1035: p_request_id => l_request_id);

Line 1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1036: Update_Dep_Status(p_dep_id => p_deployment_id,
1037: p_status => 'ERROR',
1038: p_reminder_type => p_reminder_type,
1039: p_update_flag => 'Y');
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: ROLLBACK TO FM_Request_From_Survey;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1043: fnd_file.put_line(fnd_file.log, x_message);
1044: x_message := x_message || ' ' ||SQLERRM;

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1038: p_reminder_type => p_reminder_type,
1039: p_update_flag => 'Y');
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: ROLLBACK TO FM_Request_From_Survey;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1043: fnd_file.put_line(fnd_file.log, x_message);
1044: x_message := x_message || ' ' ||SQLERRM;
1045: -- write the error msg to log, if conc request is executing this code then
1046: -- the log is viewable in concurrent manger log for that specific request

Line 1051: p_encoded => FND_API.G_FALSE);

1047: if(l_msg_count is not null) then
1048: for l_index IN 1..l_msg_count loop
1049: l_msg_data :=FND_MSG_PUB.Get(
1050: p_msg_index => l_index,
1051: p_encoded => FND_API.G_FALSE);
1052: x_msg_data := l_msg_data;
1053: fnd_file.put_line(fnd_file.log, l_msg_data);
1054: end loop;
1055: end if;

Line 1060: p_init_msg_list => FND_API.G_FALSE,

1056: fnd_file.put_line(fnd_file.log, SQLERRM);
1057: JTF_FM_REQUEST_GRP.Cancel_Request
1058: (p_api_version => l_api_version,
1059: p_commit => l_commit,
1060: p_init_msg_list => FND_API.G_FALSE,
1061: x_return_status => l_return_status,
1062: x_msg_count => l_msg_count,
1063: x_msg_data => l_msg_data,
1064: p_request_id => l_request_id);

Line 1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1068: p_update_flag => 'Y');
1069:
1070: WHEN OTHERS THEN
1071: rollback to FM_Request_From_Survey;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1073: fnd_file.put_line(fnd_file.log, x_message);
1074: x_message := x_message || ' ' ||SQLERRM;
1075: -- write the error msg to log, if conc request is executing this code then
1076: -- the log is viewable in concurrent manger log for that specific request

Line 1081: p_encoded => FND_API.G_FALSE);

1077: if(l_msg_count is not null) then
1078: for l_index IN 1..l_msg_count loop
1079: l_msg_data :=FND_MSG_PUB.Get(
1080: p_msg_index => l_index,
1081: p_encoded => FND_API.G_FALSE);
1082: x_msg_data := l_msg_data;
1083: fnd_file.put_line(fnd_file.log, l_msg_data);
1084: end loop;
1085: end if;

Line 1092: p_init_msg_list => FND_API.G_FALSE,

1088: -- cancel the request just sent
1089: JTF_FM_REQUEST_GRP.Cancel_Request
1090: (p_api_version => l_api_version,
1091: p_commit => l_commit,
1092: p_init_msg_list => FND_API.G_FALSE,
1093: x_return_status => l_return_status,
1094: x_msg_count => l_msg_count,
1095: x_msg_data => l_msg_data,
1096: p_request_id => l_request_id);

Line 1118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

1114:
1115: PROCEDURE Populate_Survey_List_Entries
1116: (
1117: p_api_version IN NUMBER ,
1118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1119: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1121: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
1122: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,

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

1115: PROCEDURE Populate_Survey_List_Entries
1116: (
1117: p_api_version IN NUMBER ,
1118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1119: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1121: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
1122: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
1123: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

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

1116: (
1117: p_api_version IN NUMBER ,
1118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1119: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1120: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1121: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
1122: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
1123: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
1124: x_message OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

Line 1133: l_commit VARCHAR2(5) := FND_API.G_FALSE ;

1129:
1130: --PRAGMA AUTONOMOUS_TRANSACTION;
1131:
1132: l_api_version NUMBER := 1.0 ;
1133: l_commit VARCHAR2(5) := FND_API.G_FALSE ;
1134: l_msg_count NUMBER ;
1135: l_msg_data VARCHAR2(1000) ;
1136: l_return_status VARCHAR2(1000) ;
1137: l_Error_Msg VARCHAR2(2000) ;

Line 1158: IF NOT FND_API.Compatible_API_Call (

1154:
1155: SAVEPOINT Populate_Survey_List_Entries;
1156: -- Submit the fulfillment request
1157: -- l_api_name := 'Populate_Survey_List_Entries';
1158: IF NOT FND_API.Compatible_API_Call (
1159: l_api_version,
1160: p_api_version,
1161: l_api_name,
1162: G_PKG_NAME)

Line 1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1160: p_api_version,
1161: l_api_name,
1162: G_PKG_NAME)
1163: THEN
1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;
1166:
1167: --Initialize message list if p_init_msg_list is TRUE.
1168: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 1168: IF FND_API.To_Boolean (p_init_msg_list) THEN

1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;
1166:
1167: --Initialize message list if p_init_msg_list is TRUE.
1168: IF FND_API.To_Boolean (p_init_msg_list) THEN
1169: FND_MSG_PUB.initialize;
1170: END IF;
1171: -- Debug Message
1172: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

1174: FND_MESSAGE.Set_Token('ARG1',l_full_name||': Start');
1175: FND_MSG_PUB.Add;
1176: END IF;
1177: -- Initialize API return status to success
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179:
1180: IF (p_survey_deployment_id IS NULL) THEN
1181: l_Error_Msg := 'Must pass p_survey_deployment_id parameter';
1182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1187: RAISE FND_API.G_EXC_ERROR;

1183: FND_MESSAGE.set_name('IES', 'IES__SVY_API_MISSING_DEPLOYMENT_ID');
1184: FND_MSG_PUB.Add;
1185: END IF;
1186: x_message := l_Error_Msg;
1187: RAISE FND_API.G_EXC_ERROR;
1188: END IF;
1189:
1190: BEGIN
1191: SELECT LIST_HEADER_ID INTO l_list_header_id

Line 1203: RAISE FND_API.G_EXC_ERROR;

1199: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');
1200: FND_MSG_PUB.Add;
1201: END IF;
1202: x_message := l_Error_Msg;
1203: RAISE FND_API.G_EXC_ERROR;
1204: END;
1205:
1206: BEGIN
1207: SELECT COUNT(*) INTO l_total_list_entries

Line 1219: RAISE FND_API.G_EXC_ERROR;

1215: FND_MESSAGE.set_name('IES', 'IES_SVY_API_MISSING_HEADER_ID');
1216: FND_MSG_PUB.Add;
1217: END IF;
1218: x_message := l_Error_Msg;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END;
1221:
1222: IF l_total_list_entries > 0 THEN
1223: l_time_in_sec := dbms_utility.get_time();

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: END IF;
1273: ELSIF l_total_list_entries = 0 THEN
1274: -- vacharya: Hard Coded x_message 'IES_SVY_EMPTY_AMS_LIST' remember to enter it in FND_NEW_MESSAGE
1275: x_message := 'IES_SVY_EMPTY_AMS_LIST';
1276: RAISE FND_API.G_EXC_ERROR;
1277:
1278: END IF;
1279:
1280:

Line 1286: WHEN FND_API.G_EXC_ERROR THEN

1282: -- DBMS_OUTPUT.PUT_LINE('Message_Count: '||l_msg_count);
1283: -- DBMS_OUTPUT.PUT_LINE('Message Data: '||l_msg_data);
1284:
1285: EXCEPTION
1286: WHEN FND_API.G_EXC_ERROR THEN
1287:
1288: ROLLBACK TO Populate_Survey_List_Entries;
1289: x_return_status := FND_API.G_RET_STS_ERROR ;
1290: --vacharya: Commented out until the message 'IES_SVY_EMPTY_AMS_LIST' is inserted in the FND_NEW_MESSAGES table

Line 1289: x_return_status := FND_API.G_RET_STS_ERROR ;

1285: EXCEPTION
1286: WHEN FND_API.G_EXC_ERROR THEN
1287:
1288: ROLLBACK TO Populate_Survey_List_Entries;
1289: x_return_status := FND_API.G_RET_STS_ERROR ;
1290: --vacharya: Commented out until the message 'IES_SVY_EMPTY_AMS_LIST' is inserted in the FND_NEW_MESSAGES table
1291: x_message := x_message || SQLERRM;
1292: FND_MSG_PUB.Count_And_Get
1293: ( p_count => x_msg_count ,

Line 1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1292: FND_MSG_PUB.Count_And_Get
1293: ( p_count => x_msg_count ,
1294: p_data => x_msg_data
1295: );
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: ROLLBACK TO Populate_Survey_List_Entries;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1299: x_message := x_message || SQLERRM;
1300: FND_MSG_PUB.Count_And_Get

Line 1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1294: p_data => x_msg_data
1295: );
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: ROLLBACK TO Populate_Survey_List_Entries;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1299: x_message := x_message || SQLERRM;
1300: FND_MSG_PUB.Count_And_Get
1301: ( p_count => x_msg_count ,
1302: p_data => x_msg_data

Line 1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1302: p_data => x_msg_data
1303: );
1304: WHEN OTHERS THEN
1305: rollback to Populate_Survey_List_Entries;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: x_message := x_message || SQLERRM;
1308:
1309: FND_MSG_PUB.Count_And_Get
1310: ( p_count => x_msg_count ,