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

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

11: -- R12 ERES Support in Service Family. Bug 4345768 End
12:
13: PROCEDURE Purge
14: ( p_api_version IN NUMBER ,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
17: p_validation_level IN NUMBER :=
18: FND_API.G_VALID_LEVEL_FULL ,
19: p_collection_id IN NUMBER ,

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

12:
13: PROCEDURE Purge
14: ( p_api_version IN NUMBER ,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
17: p_validation_level IN NUMBER :=
18: FND_API.G_VALID_LEVEL_FULL ,
19: p_collection_id IN NUMBER ,
20: p_return_status OUT NOCOPY VARCHAR2 ,

Line 18: FND_API.G_VALID_LEVEL_FULL ,

14: ( p_api_version IN NUMBER ,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
17: p_validation_level IN NUMBER :=
18: FND_API.G_VALID_LEVEL_FULL ,
19: p_collection_id IN NUMBER ,
20: p_return_status OUT NOCOPY VARCHAR2 ,
21: p_msg_count OUT NOCOPY NUMBER ,
22: p_msg_data OUT NOCOPY VARCHAR2

Line 35: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

31:
32: -- Standard Start of API savepoint
33: SAVEPOINT Purge_GRP;
34: -- Standard call to check for call compatibility.
35: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
36: p_api_version ,
37: l_api_name ,
38: G_PKG_NAME )
39: THEN

Line 40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

36: p_api_version ,
37: l_api_name ,
38: G_PKG_NAME )
39: THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.initialize;

Line 43: IF FND_API.to_Boolean( p_init_msg_list ) THEN

39: THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46: -- Initialize API return status to success
47: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 47: p_return_status := FND_API.G_RET_STS_SUCCESS;

43: IF FND_API.to_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46: -- Initialize API return status to success
47: p_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: IF p_collection_id is not null THEN
50:
51: DELETE qa_results

Line 72: IF FND_API.To_Boolean( p_commit ) THEN

68: END IF;
69: -- R12 ERES Support in Service Family. Bug 4345768 End
70:
71: -- Standard check of p_commit.
72: IF FND_API.To_Boolean( p_commit ) THEN
73: COMMIT WORK;
74: END IF;
75: -- Standard call to get message count and if count is 1, get message info.
76: FND_MSG_PUB.Count_And_Get

Line 82: WHEN FND_API.G_EXC_ERROR THEN

78: p_data => p_msg_data
79: );
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO Purge_GRP;
84: p_return_status := FND_API.G_RET_STS_ERROR ;
85: FND_MSG_PUB.Count_And_Get
86: ( p_count => p_msg_count ,

Line 84: p_return_status := FND_API.G_RET_STS_ERROR ;

80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO Purge_GRP;
84: p_return_status := FND_API.G_RET_STS_ERROR ;
85: FND_MSG_PUB.Count_And_Get
86: ( p_count => p_msg_count ,
87: p_data => p_msg_data
88: );

Line 89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

85: FND_MSG_PUB.Count_And_Get
86: ( p_count => p_msg_count ,
87: p_data => p_msg_data
88: );
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO Purge_GRP;
91: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: FND_MSG_PUB.Count_And_Get
93: ( p_count => p_msg_count ,

Line 91: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

87: p_data => p_msg_data
88: );
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO Purge_GRP;
91: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: FND_MSG_PUB.Count_And_Get
93: ( p_count => p_msg_count ,
94: p_data => p_msg_data
95: );

Line 98: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

94: p_data => p_msg_data
95: );
96: WHEN OTHERS THEN
97: ROLLBACK TO Purge_GRP;
98: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: IF FND_MSG_PUB.Check_Msg_Level
100: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
101: THEN
102: FND_MSG_PUB.Add_Exc_Msg

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

117: --
118:
119: PROCEDURE Enable
120: ( p_api_version IN NUMBER ,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123: p_validation_level IN NUMBER :=
124: FND_API.G_VALID_LEVEL_FULL ,
125: p_collection_id IN NUMBER ,

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

118:
119: PROCEDURE Enable
120: ( p_api_version IN NUMBER ,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123: p_validation_level IN NUMBER :=
124: FND_API.G_VALID_LEVEL_FULL ,
125: p_collection_id IN NUMBER ,
126: p_return_status OUT NOCOPY VARCHAR2 ,

Line 124: FND_API.G_VALID_LEVEL_FULL ,

120: ( p_api_version IN NUMBER ,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
123: p_validation_level IN NUMBER :=
124: FND_API.G_VALID_LEVEL_FULL ,
125: p_collection_id IN NUMBER ,
126: p_return_status OUT NOCOPY VARCHAR2 ,
127: p_msg_count OUT NOCOPY NUMBER ,
128: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 152: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

148:
149: -- Standard Start of API savepoint
150: SAVEPOINT Enable_GRP;
151: -- Standard call to check for call compatibility.
152: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
153: p_api_version ,
154: l_api_name ,
155: G_PKG_NAME )
156: THEN

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153: p_api_version ,
154: l_api_name ,
155: G_PKG_NAME )
156: THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159: -- Initialize message list if p_init_msg_list is set to TRUE.
160: IF FND_API.to_Boolean( p_init_msg_list ) THEN
161: FND_MSG_PUB.initialize;

Line 160: IF FND_API.to_Boolean( p_init_msg_list ) THEN

156: THEN
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: END IF;
159: -- Initialize message list if p_init_msg_list is set to TRUE.
160: IF FND_API.to_Boolean( p_init_msg_list ) THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163: -- Initialize API return status to success
164: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 164: p_return_status := FND_API.G_RET_STS_SUCCESS;

160: IF FND_API.to_Boolean( p_init_msg_list ) THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163: -- Initialize API return status to success
164: p_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: IF p_collection_id is not null THEN
167:
168: --

Line 201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

197: QA_SEQUENCE_API.Generate_Seq_for_Txn(
198: p_collection_id,
199: l_return_status);
200:
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: -- in case of failure raise error.
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: END IF;

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

199: l_return_status);
200:
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: -- in case of failure raise error.
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: END IF;
206:
207: -- launch quality actions

Line 249: IF FND_API.To_Boolean( p_commit ) THEN

245: END IF ;
246:
247:
248: -- Standard check of p_commit.
249: IF FND_API.To_Boolean( p_commit ) THEN
250: COMMIT WORK;
251: END IF;
252:
253: -- Standard call to get message count and if count is 1, get message info.

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: p_data => p_msg_data
257: );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Enable_GRP;
262: p_return_status := FND_API.G_RET_STS_ERROR ;
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => p_msg_count ,

Line 262: p_return_status := FND_API.G_RET_STS_ERROR ;

258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Enable_GRP;
262: p_return_status := FND_API.G_RET_STS_ERROR ;
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => p_msg_count ,
265: p_data => p_msg_data
266: );

Line 268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

264: ( p_count => p_msg_count ,
265: p_data => p_msg_data
266: );
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ROLLBACK TO Enable_GRP;
270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
271: FND_MSG_PUB.Count_And_Get
272: ( p_count => p_msg_count ,

Line 270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

266: );
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ROLLBACK TO Enable_GRP;
270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
271: FND_MSG_PUB.Count_And_Get
272: ( p_count => p_msg_count ,
273: p_data => p_msg_data
274: );

Line 277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

273: p_data => p_msg_data
274: );
275: WHEN OTHERS THEN
276: -- ROLLBACK TO Enable_GRP;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: IF FND_MSG_PUB.Check_Msg_Level
279: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg

Line 372: IF NOT FND_API.Compatible_API_Call (l_api_version,

368: -- Standard Start of API savepoint
369: SAVEPOINT enable_and_fire_action_grp;
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call (l_api_version,
373: NVL( p_api_version, 1.0 ),
374: l_api_name,
375: G_PKG_NAME ) THEN
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

372: IF NOT FND_API.Compatible_API_Call (l_api_version,
373: NVL( p_api_version, 1.0 ),
374: l_api_name,
375: G_PKG_NAME ) THEN
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: END IF;
378:
379: -- Initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 380: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: END IF;
378:
379: -- Initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: -- Initialize API return status to error

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: -- Initialize API return status to error
385: x_return_status := FND_API.G_RET_STS_ERROR;
386:
387: qa_results_api.enable(p_collection_id);
388: actions_request_id := fnd_request.submit_request('QA', 'QLTACTWB', NULL,
389: NULL, FALSE, to_char(-p_collection_id));

Line 391: x_return_status := FND_API.G_RET_STS_SUCCESS;

387: qa_results_api.enable(p_collection_id);
388: actions_request_id := fnd_request.submit_request('QA', 'QLTACTWB', NULL,
389: NULL, FALSE, to_char(-p_collection_id));
390:
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392:
393: -- Standard check of p_commit.
394: IF FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE ) ) THEN
395: COMMIT;

Line 394: IF FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE ) ) THEN

390:
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392:
393: -- Standard check of p_commit.
394: IF FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE ) ) THEN
395: COMMIT;
396: END IF;
397:
398: EXCEPTION

Line 400: WHEN FND_API.G_EXC_ERROR THEN

396: END IF;
397:
398: EXCEPTION
399:
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO enable_and_fire_action_grp;
402: x_return_status := FND_API.G_RET_STS_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count,

Line 402: x_return_status := FND_API.G_RET_STS_ERROR ;

398: EXCEPTION
399:
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO enable_and_fire_action_grp;
402: x_return_status := FND_API.G_RET_STS_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count,
405: p_data => x_msg_data
406: );

Line 408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

404: (p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407:
408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
409: ROLLBACK TO enable_and_fire_action_grp;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: (p_count => x_msg_count,

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

406: );
407:
408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
409: ROLLBACK TO enable_and_fire_action_grp;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: (p_count => x_msg_count,
413: p_data => x_msg_data
414: );

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

414: );
415:
416: WHEN OTHERS THEN
417: ROLLBACK TO enable_and_fire_action_grp;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
420: FND_MSG_PUB.Add_Exc_Msg
421: (G_PKG_NAME,
422: l_api_name

Line 525: IF NOT FND_API.Compatible_API_Call

521: );
522: END IF;
523:
524: -- Standard call to check for call compatibility.
525: IF NOT FND_API.Compatible_API_Call
526: (
527: l_api_version,
528: NVL( p_api_version, 1.0 ),
529: l_api_name,

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

528: NVL( p_api_version, 1.0 ),
529: l_api_name,
530: g_pkg_name
531: ) THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 536: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
537: FND_MSG_PUB.initialize;
538: END IF;
539:
540: -- Initialize API return status to success

Line 541: x_return_status := FND_API.G_RET_STS_SUCCESS;

537: FND_MSG_PUB.initialize;
538: END IF;
539:
540: -- Initialize API return status to success
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
544: FND_LOG.string
545: (

Line 651: WHEN FND_API.G_EXC_ERROR THEN

647: END IF;
648:
649: EXCEPTION
650:
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get
654: (
655: p_count => x_msg_count,

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648:
649: EXCEPTION
650:
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get
654: (
655: p_count => x_msg_count,
656: p_data => x_msg_data

Line 668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

664: 'Exiting Procedure: Error'
665: );
666: END IF;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_And_Get
671: (
672: p_count => x_msg_count,

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

665: );
666: END IF;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_And_Get
671: (
672: p_count => x_msg_count,
673: p_data => x_msg_data

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682: );
683: END IF;
684:
685: WHEN OTHERS THEN
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
688: FND_MSG_PUB.Add_Exc_Msg
689: (
690: p_pkg_name => g_pkg_name,

Line 809: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );

805: collection_id_tab num_tab_typ;
806: occurrence_tab num_tab_typ;
807:
808: BEGIN
809: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
810:
811: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
812: FND_LOG.string
813: (

Line 824: IF NOT FND_API.Compatible_API_Call

820: -- Standard Start of API savepoint
821: SAVEPOINT enable_results_erecords_GRP;
822:
823: -- Standard call to check for call compatibility.
824: IF NOT FND_API.Compatible_API_Call
825: (
826: l_api_version,
827: NVL( p_api_version, 1.0 ),
828: l_api_name,

Line 831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

827: NVL( p_api_version, 1.0 ),
828: l_api_name,
829: g_pkg_name
830: ) THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 835: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
836: FND_MSG_PUB.initialize;
837: END IF;
838:
839: -- Initialize API return status to success

Line 840: x_return_status := FND_API.G_RET_STS_SUCCESS;

836: FND_MSG_PUB.initialize;
837: END IF;
838:
839: -- Initialize API return status to success
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: IF ( FND_PROFILE.value('EDR_ERES_ENABLED') = 'Y' ) THEN
843:
844: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 857: p_init_msg_list => FND_API.G_FALSE,

853: -- Get all the QA Results E-Records for the given collection
854: get_qa_results_erecords
855: (
856: p_api_version => 1.0,
857: p_init_msg_list => FND_API.G_FALSE,
858: p_commit => FND_API.G_FALSE,
859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
860: p_collection_id => p_collection_id,
861: x_qa_erecord_tbl => l_erec_tbl,

Line 858: p_commit => FND_API.G_FALSE,

854: get_qa_results_erecords
855: (
856: p_api_version => 1.0,
857: p_init_msg_list => FND_API.G_FALSE,
858: p_commit => FND_API.G_FALSE,
859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
860: p_collection_id => p_collection_id,
861: x_qa_erecord_tbl => l_erec_tbl,
862: x_return_status => l_return_status,

Line 859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

855: (
856: p_api_version => 1.0,
857: p_init_msg_list => FND_API.G_FALSE,
858: p_commit => FND_API.G_FALSE,
859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
860: p_collection_id => p_collection_id,
861: x_qa_erecord_tbl => l_erec_tbl,
862: x_return_status => l_return_status,
863: x_msg_count => l_msg_count,

Line 901: p_autonomous_commit => FND_API.G_FALSE

897: p_erecord_id => l_erec_tbl(i).erec_id,
898: p_trans_status => g_erec_success,
899: p_ackn_by => g_ackn_by,
900: p_ackn_note => '',
901: p_autonomous_commit => FND_API.G_FALSE
902: );
903:
904: END LOOP;
905: END IF;

Line 958: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

954: QA_SEQUENCE_API.Generate_Seq_for_Txn(
955: p_collection_id,
956: l_return_status);
957:
958: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
959: -- in case of failure raise error.
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962: END IF;

Line 960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

956: l_return_status);
957:
958: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
959: -- in case of failure raise error.
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: END IF;
962: END IF;
963:
964: -- launch quality actions for the most recent txn_header_id

Line 993: raise FND_API.G_EXC_UNEXPECTED_ERROR;

989: p_occurrence => occurrence_tab(cntr),
990: p_plan_id => plan_id_tab(cntr),
991: x_argument => NULL
992: ) = FALSE ) THEN
993: raise FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF ;
995: END LOOP;
996: END IF;
997: -- Bug 5508639. SHKALYAN 13-Sep-2006.

Line 1023: WHEN FND_API.G_EXC_ERROR THEN

1019: END IF;
1020:
1021: EXCEPTION
1022:
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO enable_results_erecords_GRP;
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026: FND_MSG_PUB.Count_And_Get
1027: (

Line 1025: x_return_status := FND_API.G_RET_STS_ERROR;

1021: EXCEPTION
1022:
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO enable_results_erecords_GRP;
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026: FND_MSG_PUB.Count_And_Get
1027: (
1028: p_count => x_msg_count,
1029: p_data => x_msg_data

Line 1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1037: 'Exiting Procedure: Error'
1038: );
1039: END IF;
1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO enable_results_erecords_GRP;
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.Count_And_Get
1045: (

Line 1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1039: END IF;
1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO enable_results_erecords_GRP;
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.Count_And_Get
1045: (
1046: p_count => x_msg_count,
1047: p_data => x_msg_data

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1057: END IF;
1058:
1059: WHEN OTHERS THEN
1060: ROLLBACK TO enable_results_erecords_GRP;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1063: FND_MSG_PUB.Add_Exc_Msg
1064: (
1065: p_pkg_name => g_pkg_name,

Line 1115: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );

1111: l_msg_count NUMBER;
1112: l_msg_data VARCHAR2(5000);
1113:
1114: BEGIN
1115: l_commit := FND_API.To_Boolean( NVL(p_commit, FND_API.G_FALSE) );
1116:
1117: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
1118: FND_LOG.string
1119: (

Line 1130: IF NOT FND_API.Compatible_API_Call

1126: -- Standard Start of API savepoint
1127: SAVEPOINT purge_results_erecords_GRP;
1128:
1129: -- Standard call to check for call compatibility.
1130: IF NOT FND_API.Compatible_API_Call
1131: (
1132: l_api_version,
1133: NVL( p_api_version, 1.0 ),
1134: l_api_name,

Line 1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1133: NVL( p_api_version, 1.0 ),
1134: l_api_name,
1135: g_pkg_name
1136: ) THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139:
1140: -- Initialize message list if p_init_msg_list is set to TRUE.
1141: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

Line 1141: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN

1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139:
1140: -- Initialize message list if p_init_msg_list is set to TRUE.
1141: IF FND_API.to_Boolean( NVL( p_init_msg_list, FND_API.G_FALSE ) ) THEN
1142: FND_MSG_PUB.initialize;
1143: END IF;
1144:
1145: -- Initialize API return status to success

Line 1146: x_return_status := FND_API.G_RET_STS_SUCCESS;

1142: FND_MSG_PUB.initialize;
1143: END IF;
1144:
1145: -- Initialize API return status to success
1146: x_return_status := FND_API.G_RET_STS_SUCCESS;
1147:
1148: IF ( FND_PROFILE.value('EDR_ERES_ENABLED') = 'Y' ) THEN
1149:
1150: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

Line 1163: p_init_msg_list => FND_API.G_FALSE,

1159: -- Get all the QA Results E-Records for the given collection
1160: get_qa_results_erecords
1161: (
1162: p_api_version => 1.0,
1163: p_init_msg_list => FND_API.G_FALSE,
1164: p_commit => FND_API.G_FALSE,
1165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1166: p_collection_id => p_collection_id,
1167: x_qa_erecord_tbl => l_erec_tbl,

Line 1164: p_commit => FND_API.G_FALSE,

1160: get_qa_results_erecords
1161: (
1162: p_api_version => 1.0,
1163: p_init_msg_list => FND_API.G_FALSE,
1164: p_commit => FND_API.G_FALSE,
1165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1166: p_collection_id => p_collection_id,
1167: x_qa_erecord_tbl => l_erec_tbl,
1168: x_return_status => l_return_status,

Line 1165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1161: (
1162: p_api_version => 1.0,
1163: p_init_msg_list => FND_API.G_FALSE,
1164: p_commit => FND_API.G_FALSE,
1165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1166: p_collection_id => p_collection_id,
1167: x_qa_erecord_tbl => l_erec_tbl,
1168: x_return_status => l_return_status,
1169: x_msg_count => l_msg_count,

Line 1207: p_autonomous_commit => FND_API.G_FALSE

1203: p_erecord_id => l_erec_tbl(i).erec_id,
1204: p_trans_status => g_erec_error,
1205: p_ackn_by => g_ackn_by,
1206: p_ackn_note => '',
1207: p_autonomous_commit => FND_API.G_FALSE
1208: );
1209:
1210: END LOOP;
1211: END IF;

Line 1228: p_init_msg_list => FND_API.G_FALSE,

1224: -- Purge the Quality Results for the Collection
1225: purge
1226: (
1227: p_api_version => 1.0,
1228: p_init_msg_list => FND_API.G_FALSE,
1229: p_commit => FND_API.G_FALSE,
1230: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1231: p_collection_id => p_collection_id,
1232: p_return_status => l_return_status,

Line 1229: p_commit => FND_API.G_FALSE,

1225: purge
1226: (
1227: p_api_version => 1.0,
1228: p_init_msg_list => FND_API.G_FALSE,
1229: p_commit => FND_API.G_FALSE,
1230: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1231: p_collection_id => p_collection_id,
1232: p_return_status => l_return_status,
1233: p_msg_count => l_msg_count,

Line 1230: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1226: (
1227: p_api_version => 1.0,
1228: p_init_msg_list => FND_API.G_FALSE,
1229: p_commit => FND_API.G_FALSE,
1230: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1231: p_collection_id => p_collection_id,
1232: p_return_status => l_return_status,
1233: p_msg_count => l_msg_count,
1234: p_msg_data => l_msg_data

Line 1260: WHEN FND_API.G_EXC_ERROR THEN

1256: END IF;
1257:
1258: EXCEPTION
1259:
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO purge_results_erecords_GRP;
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: FND_MSG_PUB.Count_And_Get
1264: (

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR;

1258: EXCEPTION
1259:
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO purge_results_erecords_GRP;
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: FND_MSG_PUB.Count_And_Get
1264: (
1265: p_count => x_msg_count,
1266: p_data => x_msg_data

Line 1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1274: 'Exiting Procedure: Error'
1275: );
1276: END IF;
1277:
1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1279: ROLLBACK TO purge_results_erecords_GRP;
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: FND_MSG_PUB.Count_And_Get
1282: (

Line 1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1276: END IF;
1277:
1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1279: ROLLBACK TO purge_results_erecords_GRP;
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: FND_MSG_PUB.Count_And_Get
1282: (
1283: p_count => x_msg_count,
1284: p_data => x_msg_data

Line 1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1294: END IF;
1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO purge_results_erecords_GRP;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF ( FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) ) THEN
1300: FND_MSG_PUB.Add_Exc_Msg
1301: (
1302: p_pkg_name => g_pkg_name,