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

Line 57: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

53: l_api_version := 1.0;
54: -- Standard Start of API savepoint
55: SAVEPOINT copy_deliverables_PVT;
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: -- Standard Start of API savepoint
55: SAVEPOINT copy_deliverables_PVT;
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN
62: FND_MSG_PUB.initialize;

Line 61: IF FND_API.to_Boolean( p_init_msg_list ) THEN

57: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list ) THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- Initialize API return status to success

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: -- Initialize API return status to success
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68:
69: -- Get contract_type of target contract, required for deliverables and documents APIs
70: OPEN target_contract_csr;

Line 82: RAISE FND_API.G_EXC_ERROR;

78: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
79: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
80: p_token1 => G_CONTRACT_ID_TOKEN,
81: p_token1_value => to_char(p_source_contract_id));
82: RAISE FND_API.G_EXC_ERROR;
83: END IF;
84:
85: -- Get internal party_id. Needed for deliverables api
86: OPEN party_csr;

Line 94: RAISE FND_API.G_EXC_ERROR;

90: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
91: G_MODULE||l_api_name,
92: 'No internal party for the contract');
93: END IF;
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97:
98: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (

Line 100: p_init_msg_list => FND_API.G_FALSE,

96:
97:
98: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
99: p_api_version => 1.0,
100: p_init_msg_list => FND_API.G_FALSE,
101: p_source_doc_id => p_source_contract_id,
102: p_source_doc_type => p_source_contract_type,
103: p_target_doc_id => p_target_contract_id,
104: p_target_doc_type => p_target_contract_type,

Line 133: IF FND_API.To_Boolean( p_commit ) THEN

129: -- close open cursors
130: CLOSE target_contract_csr;
131: CLOSE party_csr;
132: -- Standard check of p_commit
133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;
135: END IF;
136:
137: -- Standard call to get message count and if count is 1, get message info.

Line 147: WHEN FND_API.G_EXC_ERROR THEN

143: END IF;
144:
145:
146: EXCEPTION
147: WHEN FND_API.G_EXC_ERROR THEN
148: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
149: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
150: g_module || l_api_name,
151: 'Leaving copy_deliverables:FND_API.G_EXC_ERROR Exception');

Line 151: 'Leaving copy_deliverables:FND_API.G_EXC_ERROR Exception');

147: WHEN FND_API.G_EXC_ERROR THEN
148: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
149: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
150: g_module || l_api_name,
151: 'Leaving copy_deliverables:FND_API.G_EXC_ERROR Exception');
152: END IF;
153: --close cursors
154: IF (target_contract_csr%ISOPEN) THEN
155: CLOSE target_contract_csr ;

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: IF (party_csr%ISOPEN) THEN
158: CLOSE party_csr ;
159: END IF;
160: ROLLBACK TO copy_deliverables_PVT;
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MSG_PUB.Count_And_Get(
163: p_count => x_msg_count,
164: p_data => x_msg_data
165: );

Line 167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

163: p_count => x_msg_count,
164: p_data => x_msg_data
165: );
166:
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
170: g_module || l_api_name,
171: 'Leaving copy_deliverables:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 171: 'Leaving copy_deliverables:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
170: g_module || l_api_name,
171: 'Leaving copy_deliverables:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
172: END IF;
173: --close cursors
174: IF (target_contract_csr%ISOPEN) THEN
175: CLOSE target_contract_csr ;

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: IF (party_csr%ISOPEN) THEN
178: CLOSE party_csr ;
179: END IF;
180: ROLLBACK TO copy_deliverables_PVT;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get(
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203: END IF;
204: IF (party_csr%ISOPEN) THEN
205: CLOSE party_csr ;
206: END IF;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: FND_MSG_PUB.Count_And_Get(
209: p_count => x_msg_count,
210: p_data => x_msg_data
211: );

Line 263: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

259: -- Standard Start of API savepoint
260: SAVEPOINT revise_checklist_PVT;
261:
262: -- Standard call to check for call compatibility.
263: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

260: SAVEPOINT revise_checklist_PVT;
261:
262: -- Standard call to check for call compatibility.
263: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 268: IF FND_API.to_Boolean( p_init_msg_list ) THEN

264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list ) THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: -- Initialize API return status to success

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: -- Initialize API return status to success
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: -- Get business document details to which this closeout Contract is associated
276: OPEN c_get_doc_details;
277: FETCH c_get_doc_details INTO l_document_rec.business_document_type, l_document_rec.business_document_id;

Line 288: RAISE FND_API.G_EXC_ERROR;

284: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
285: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
286: p_token1 => G_CONTRACT_ID_TOKEN,
287: p_token1_value => to_char(p_contract_id));
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290:
291: create_new_contract_version( p_api_version => p_api_version,
292: p_document_rec => l_document_rec,

Line 324: IF FND_API.To_Boolean( p_commit ) THEN

320: AND contract_type = p_contract_type;
321: END IF;
322:
323: -- Standard check of p_commit
324: IF FND_API.To_Boolean( p_commit ) THEN
325: COMMIT WORK;
326: END IF;
327:
328: -- Standard call to get message count and if count is 1, get message info.

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.revise_checklist');
334: END IF;
335:
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
340: g_module || l_api_name,
341: 'Leaving revise_checklist:FND_API.G_EXC_ERROR Exception');

Line 341: 'Leaving revise_checklist:FND_API.G_EXC_ERROR Exception');

337: WHEN FND_API.G_EXC_ERROR THEN
338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
340: g_module || l_api_name,
341: 'Leaving revise_checklist:FND_API.G_EXC_ERROR Exception');
342: END IF;
343: --close cursors
344: IF (c_get_doc_details%ISOPEN) THEN
345: CLOSE c_get_doc_details ;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344: IF (c_get_doc_details%ISOPEN) THEN
345: CLOSE c_get_doc_details ;
346: END IF;
347: ROLLBACK TO revise_checklist_PVT;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MSG_PUB.Count_And_Get(
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
357: g_module || l_api_name,
358: 'Leaving revise_checklist:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 358: 'Leaving revise_checklist:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
357: g_module || l_api_name,
358: 'Leaving revise_checklist:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
359: END IF;
360: --close cursors
361: IF (c_get_doc_details%ISOPEN) THEN
362: CLOSE c_get_doc_details ;

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: CLOSE c_get_doc_details ;
363: END IF;
364:
365: ROLLBACK TO revise_checklist_PVT;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: FND_MSG_PUB.Count_And_Get(
368: p_count => x_msg_count,
369: p_data => x_msg_data
370: );

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

385: --close cursors
386: IF (c_get_doc_details%ISOPEN) THEN
387: CLOSE c_get_doc_details ;
388: END IF;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.Count_And_Get(
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );

Line 448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

444: -- Standard Start of API savepoint
445: SAVEPOINT freeze_checklist_PVT;
446:
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: SAVEPOINT freeze_checklist_PVT;
446:
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.
453: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 453: IF FND_API.to_Boolean( p_init_msg_list ) THEN

449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE.
453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:
457: -- Initialize API return status to success

Line 458: x_return_status := FND_API.G_RET_STS_SUCCESS;

454: FND_MSG_PUB.initialize;
455: END IF;
456:
457: -- Initialize API return status to success
458: x_return_status := FND_API.G_RET_STS_SUCCESS;
459:
460: -- Get business document details to which this closeout Contract is associated
461: OPEN c_get_doc_details;
462: FETCH c_get_doc_details INTO l_document_rec.business_document_type, l_document_rec.business_document_id, l_physical_completion_date;

Line 473: RAISE FND_API.G_EXC_ERROR;

469: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
470: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
471: p_token1 => G_CONTRACT_ID_TOKEN,
472: p_token1_value => to_char(p_contract_id));
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475:
476: Activate_tasks_closeout(p_api_version => 1.0,
477: p_document_rec => l_document_rec,

Line 502: IF FND_API.To_Boolean( p_commit ) THEN

498: -- close open cursors
499: CLOSE c_get_doc_details;
500:
501: -- Standard check of p_commit
502: IF FND_API.To_Boolean( p_commit ) THEN
503: COMMIT WORK;
504: END IF;
505:
506: -- Standard call to get message count and if count is 1, get message info.

Line 515: WHEN FND_API.G_EXC_ERROR THEN

511: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.freeze_checklist');
512: END IF;
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
518: g_module || l_api_name,
519: 'Leaving freeze_checklist:FND_API.G_EXC_ERROR Exception');

Line 519: 'Leaving freeze_checklist:FND_API.G_EXC_ERROR Exception');

515: WHEN FND_API.G_EXC_ERROR THEN
516: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
518: g_module || l_api_name,
519: 'Leaving freeze_checklist:FND_API.G_EXC_ERROR Exception');
520: END IF;
521: --close cursors
522: IF (c_get_doc_details%ISOPEN) THEN
523: CLOSE c_get_doc_details ;

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522: IF (c_get_doc_details%ISOPEN) THEN
523: CLOSE c_get_doc_details ;
524: END IF;
525: ROLLBACK TO freeze_checklist_PVT;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: FND_MSG_PUB.Count_And_Get(
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );

Line 532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );
531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
535: g_module || l_api_name,
536: 'Leaving freeze_checklist:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 536: 'Leaving freeze_checklist:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
535: g_module || l_api_name,
536: 'Leaving freeze_checklist:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
537: END IF;
538: --close cursors
539: IF (c_get_doc_details%ISOPEN) THEN
540: CLOSE c_get_doc_details ;

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

540: CLOSE c_get_doc_details ;
541: END IF;
542:
543: ROLLBACK TO freeze_checklist_PVT;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MSG_PUB.Count_And_Get(
546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );

Line 567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

563: --close cursors
564: IF (c_get_doc_details%ISOPEN) THEN
565: CLOSE c_get_doc_details ;
566: END IF;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.Count_And_Get(
569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );

Line 628: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

624: -- Standard Start of API savepoint
625: SAVEPOINT val_closeout_tasks_PVT;
626:
627: -- Standard call to check for call compatibility.
628: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

625: SAVEPOINT val_closeout_tasks_PVT;
626:
627: -- Standard call to check for call compatibility.
628: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632: -- Initialize message list if p_init_msg_list is set to TRUE.
633: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 633: IF FND_API.to_Boolean( p_init_msg_list ) THEN

629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631:
632: -- Initialize message list if p_init_msg_list is set to TRUE.
633: IF FND_API.to_Boolean( p_init_msg_list ) THEN
634: FND_MSG_PUB.initialize;
635: END IF;
636:
637: -- Initialize API return status to success

Line 638: x_return_status := FND_API.G_RET_STS_SUCCESS;

634: FND_MSG_PUB.initialize;
635: END IF;
636:
637: -- Initialize API return status to success
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: -- Get business document details to which this closeout Contract is associated
641: OPEN c_get_doc_details;
642: FETCH c_get_doc_details INTO contract_rec;

Line 653: RAISE FND_API.G_EXC_ERROR;

649: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
650: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
651: p_token1 => G_CONTRACT_ID_TOKEN,
652: p_token1_value => to_char(p_contract_id));
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655:
656: l_bus_doc_date_events_tbl(1).event_code := G_PO_PHYSICAL_COMPLETE_EVENT;
657: l_bus_doc_date_events_tbl(1).event_date := contract_rec.contract_effective_date;

Line 662: p_init_msg_list => FND_API.G_FALSE,

658:
659:
660: OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa (
661: p_api_version => 1,
662: p_init_msg_list => FND_API.G_FALSE,
663: p_doc_type => p_contract_type,
664: p_doc_id => p_contract_id,
665: p_mode => G_NORMAL_QA,
666: p_bus_doc_date_events_tbl => l_bus_doc_date_events_tbl,

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

737: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
738: END IF;
739: --------------------------------------------
740: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
742: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
743: RAISE FND_API.G_EXC_ERROR ;
744: END IF;
745: --------------------------------------------

Line 743: RAISE FND_API.G_EXC_ERROR ;

739: --------------------------------------------
740: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
742: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
743: RAISE FND_API.G_EXC_ERROR ;
744: END IF;
745: --------------------------------------------
746:
747: -- close open cursors

Line 751: IF FND_API.To_Boolean( p_commit ) THEN

747: -- close open cursors
748: CLOSE c_get_doc_details;
749:
750: -- Standard check of p_commit
751: IF FND_API.To_Boolean( p_commit ) THEN
752: COMMIT WORK;
753: END IF;
754:
755: -- Standard call to get message count and if count is 1, get message info.

Line 764: WHEN FND_API.G_EXC_ERROR THEN

760: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
761: END IF;
762:
763: EXCEPTION
764: WHEN FND_API.G_EXC_ERROR THEN
765: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
766: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
767: g_module || l_api_name,
768: 'Leaving validate_closeout_tasks:FND_API.G_EXC_ERROR Exception');

Line 768: 'Leaving validate_closeout_tasks:FND_API.G_EXC_ERROR Exception');

764: WHEN FND_API.G_EXC_ERROR THEN
765: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
766: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
767: g_module || l_api_name,
768: 'Leaving validate_closeout_tasks:FND_API.G_EXC_ERROR Exception');
769: END IF;
770: --close cursors
771: IF (c_get_doc_details%ISOPEN) THEN
772: CLOSE c_get_doc_details ;

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: IF (c_get_doc_details%ISOPEN) THEN
772: CLOSE c_get_doc_details ;
773: END IF;
774: ROLLBACK TO val_closeout_tasks_PVT;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.Count_And_Get(
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );

Line 781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
783: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
784: g_module || l_api_name,
785: 'Leaving validate_closeout_tasks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 785: 'Leaving validate_closeout_tasks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
783: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
784: g_module || l_api_name,
785: 'Leaving validate_closeout_tasks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
786: END IF;
787: --close cursors
788: IF (c_get_doc_details%ISOPEN) THEN
789: CLOSE c_get_doc_details ;

Line 794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

790: END IF;
791:
792: ROLLBACK TO val_closeout_tasks_PVT;
793:
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,
797: p_data => x_msg_data
798: );

Line 819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

815: --close cursors
816: IF (c_get_doc_details%ISOPEN) THEN
817: CLOSE c_get_doc_details ;
818: END IF;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: FND_MSG_PUB.Count_And_Get(
821: p_count => x_msg_count,
822: p_data => x_msg_data
823: );

Line 875: l_phy_complete_date_match_flag := FND_API.G_FALSE;

871: AND ROWNUM = 1;
872:
873: BEGIN
874:
875: l_phy_complete_date_match_flag := FND_API.G_FALSE;
876:
877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
879: 'Entered OKC_REP_CLOSEOUT_PVT.Activate_tasks_closeout');

Line 890: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

886: -- Standard Start of API savepoint
887: SAVEPOINT Act_tasks_closeout_PVT;
888:
889: -- Standard call to check for call compatibility.
890: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893: -- Initialize message list if p_init_msg_list is set to TRUE.
894: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

887: SAVEPOINT Act_tasks_closeout_PVT;
888:
889: -- Standard call to check for call compatibility.
890: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893: -- Initialize message list if p_init_msg_list is set to TRUE.
894: IF FND_API.to_Boolean( p_init_msg_list ) THEN
895: FND_MSG_PUB.initialize;

Line 894: IF FND_API.to_Boolean( p_init_msg_list ) THEN

890: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893: -- Initialize message list if p_init_msg_list is set to TRUE.
894: IF FND_API.to_Boolean( p_init_msg_list ) THEN
895: FND_MSG_PUB.initialize;
896: END IF;
897:
898: -- Initialize API return status to success

Line 899: x_return_status := FND_API.G_RET_STS_SUCCESS;

895: FND_MSG_PUB.initialize;
896: END IF;
897:
898: -- Initialize API return status to success
899: x_return_status := FND_API.G_RET_STS_SUCCESS;
900: x_task_status := G_TASK_STATUS_INIT;
901:
902: --find the contract associated to this business document
903: OPEN c_get_contract_id_csr;

Line 919: RAISE FND_API.G_EXC_ERROR;

915: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
916: p_msg_name => G_INVALID_BUS_DOC_ID_MSG,
917: p_token1 => 'BUS_DOC_ID',
918: p_token1_value => to_char(p_document_rec.business_document_id));
919: RAISE FND_API.G_EXC_ERROR;
920: -- RAISE NO_DATA_FOUND;
921: END IF;
922:
923: -- Get effective dates and version of the contract.

Line 936: RAISE FND_API.G_EXC_ERROR;

932: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
933: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
934: p_token1 => 'CONTRACT_ID',
935: p_token1_value => to_char(l_contract_id));
936: RAISE FND_API.G_EXC_ERROR;
937: -- RAISE NO_DATA_FOUND;
938: END IF;
939:
940: -- Lock the contract header

Line 973: p_init_msg_list => FND_API.G_FALSE,

969: END IF;
970: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
971: OKC_REP_UTIL_PVT.change_contract_status(
972: p_api_version => 1.0,
973: p_init_msg_list => FND_API.G_FALSE,
974: p_contract_id => l_contract_id,
975: p_contract_version => contract_rec.contract_version_num,
976: p_status_code => G_STATUS_SIGNED,
977: p_user_id => fnd_global.user_id,

Line 1004: p_init_msg_list => FND_API.G_FALSE,

1000: END IF;
1001:
1002: OKC_DELIVERABLE_PROCESS_PVT.version_deliverables (
1003: p_api_version => 1.0,
1004: p_init_msg_list => FND_API.G_FALSE,
1005: p_doc_id => l_contract_id,
1006: p_doc_version => contract_rec.contract_version_num,
1007: p_doc_type => contract_rec.contract_type,
1008: x_return_status => x_return_status,

Line 1033: l_sync_flag := FND_API.G_FALSE;

1029: || contract_rec.latest_signed_ver_number);
1030: END IF;
1031: -- Now we need to activate deliverables
1032: if (contract_rec.latest_signed_ver_number IS NULL) THEN
1033: l_sync_flag := FND_API.G_FALSE;
1034: ELSE
1035: l_sync_flag := FND_API.G_TRUE;
1036: END IF;
1037:

Line 1035: l_sync_flag := FND_API.G_TRUE;

1031: -- Now we need to activate deliverables
1032: if (contract_rec.latest_signed_ver_number IS NULL) THEN
1033: l_sync_flag := FND_API.G_FALSE;
1034: ELSE
1035: l_sync_flag := FND_API.G_TRUE;
1036: END IF;
1037:
1038: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1039: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1053: p_init_msg_list => FND_API.G_FALSE,

1049: END IF;
1050:
1051: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (
1052: p_api_version => 1.0,
1053: p_init_msg_list => FND_API.G_FALSE,
1054: p_commit => FND_API.G_FALSE,
1055: p_bus_doc_id => l_contract_id,
1056: p_bus_doc_type => contract_rec.contract_type,
1057: p_bus_doc_version => contract_rec.contract_version_num,

Line 1054: p_commit => FND_API.G_FALSE,

1050:
1051: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (
1052: p_api_version => 1.0,
1053: p_init_msg_list => FND_API.G_FALSE,
1054: p_commit => FND_API.G_FALSE,
1055: p_bus_doc_id => l_contract_id,
1056: p_bus_doc_type => contract_rec.contract_type,
1057: p_bus_doc_version => contract_rec.contract_version_num,
1058: p_event_code => 'PO_PHYSICAL_COMPLETE',

Line 1080: IF (l_sync_flag = FND_API.G_TRUE) THEN

1076: END IF;
1077: --------------------------------------------------------
1078:
1079: -- Checking if we need to call deliverable's APIs for synch-ing
1080: IF (l_sync_flag = FND_API.G_TRUE) THEN
1081:
1082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1083: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1084: 'Before checking if we need to call updateDeliverable and disableDeliverable()');

Line 1098: p_init_msg_list => FND_API.G_FALSE,

1094: 'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
1095: END IF;
1096: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
1097: p_api_version => 1.0,
1098: p_init_msg_list => FND_API.G_FALSE,
1099: p_commit => FND_API.G_FALSE,
1100: p_bus_doc_id => l_contract_id,
1101: p_bus_doc_type => contract_rec.contract_type,
1102: p_bus_doc_version => contract_rec.contract_version_num,

Line 1099: p_commit => FND_API.G_FALSE,

1095: END IF;
1096: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
1097: p_api_version => 1.0,
1098: p_init_msg_list => FND_API.G_FALSE,
1099: p_commit => FND_API.G_FALSE,
1100: p_bus_doc_id => l_contract_id,
1101: p_bus_doc_type => contract_rec.contract_type,
1102: p_bus_doc_version => contract_rec.contract_version_num,
1103: p_bus_doc_date_events_tbl => l_update_event_tbl,

Line 1129: p_init_msg_list => FND_API.G_FALSE,

1125: 'Calling OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables');
1126: END IF;
1127: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
1128: p_api_version => 1.0,
1129: p_init_msg_list => FND_API.G_FALSE,
1130: p_commit => FND_API.G_FALSE,
1131: p_bus_doc_id => l_contract_id,
1132: p_bus_doc_type => contract_rec.contract_type,
1133: p_bus_doc_version => contract_rec.latest_signed_ver_number,

Line 1130: p_commit => FND_API.G_FALSE,

1126: END IF;
1127: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
1128: p_api_version => 1.0,
1129: p_init_msg_list => FND_API.G_FALSE,
1130: p_commit => FND_API.G_FALSE,
1131: p_bus_doc_id => l_contract_id,
1132: p_bus_doc_type => contract_rec.contract_type,
1133: p_bus_doc_version => contract_rec.latest_signed_ver_number,
1134: x_msg_data => x_msg_data,

Line 1172: IF FND_API.To_Boolean( p_commit ) THEN

1168: END IF;
1169: CLOSE c_del_status_csr;
1170:
1171: -- Standard check of p_commit
1172: IF FND_API.To_Boolean( p_commit ) THEN
1173: COMMIT WORK;
1174: END IF;
1175:
1176: -- Standard call to get message count and if count is 1, get message info.

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181: 'Leaving OKC_REP_CLOSEOUT_PVT.Activate_tasks_closeout');
1182: END IF;
1183:
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1187: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1188: g_module || l_api_name,
1189: 'Leaving Activate_tasks_closeout:FND_API.G_EXC_ERROR Exception');

Line 1189: 'Leaving Activate_tasks_closeout:FND_API.G_EXC_ERROR Exception');

1185: WHEN FND_API.G_EXC_ERROR THEN
1186: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1187: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1188: g_module || l_api_name,
1189: 'Leaving Activate_tasks_closeout:FND_API.G_EXC_ERROR Exception');
1190: END IF;
1191: --close cursors
1192: IF (contract_csr%ISOPEN) THEN
1193: CLOSE contract_csr ;

Line 1202: x_return_status := FND_API.G_RET_STS_ERROR;

1198: IF (c_del_status_csr%ISOPEN) THEN
1199: CLOSE c_del_status_csr ;
1200: END IF;
1201: ROLLBACK TO Act_tasks_closeout_PVT;
1202: x_return_status := FND_API.G_RET_STS_ERROR;
1203: FND_MSG_PUB.Count_And_Get(
1204: p_count => x_msg_count,
1205: p_data => x_msg_data
1206: );

Line 1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1204: p_count => x_msg_count,
1205: p_data => x_msg_data
1206: );
1207:
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1210: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1211: g_module || l_api_name,
1212: 'Leaving Activate_tasks_closeout:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 1212: 'Leaving Activate_tasks_closeout:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1210: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1211: g_module || l_api_name,
1212: 'Leaving Activate_tasks_closeout:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1213: END IF;
1214: --close cursors
1215: IF (contract_csr%ISOPEN) THEN
1216: CLOSE contract_csr ;

Line 1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1221: IF (c_del_status_csr%ISOPEN) THEN
1222: CLOSE c_del_status_csr ;
1223: END IF;
1224: ROLLBACK TO Act_tasks_closeout_PVT;
1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226: FND_MSG_PUB.Count_And_Get(
1227: p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );

Line 1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1250: END IF;
1251: IF (c_del_status_csr%ISOPEN) THEN
1252: CLOSE c_del_status_csr ;
1253: END IF;
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: FND_MSG_PUB.Count_And_Get(
1256: p_count => x_msg_count,
1257: p_data => x_msg_data
1258: );

Line 1268: p_commit IN VARCHAR2 := fnd_api.g_false,

1264: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1265: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1266: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1267: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1268: p_commit IN VARCHAR2 := fnd_api.g_false,
1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: x_msg_count OUT NOCOPY NUMBER,
1271: x_return_status OUT NOCOPY VARCHAR2
1272: ) IS

Line 1295: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1291: -- Standard Start of API savepoint
1292: SAVEPOINT create_contract_PVT;
1293:
1294: -- Standard call to check for call compatibility.
1295: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;
1298:
1299: l_document_rec := p_document_rec;

Line 1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1292: SAVEPOINT create_contract_PVT;
1293:
1294: -- Standard call to check for call compatibility.
1295: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;
1298:
1299: l_document_rec := p_document_rec;
1300:

Line 1348: IF FND_API.To_Boolean( p_commit ) THEN

1344: x_msg_count => x_msg_count,
1345: x_return_status => x_return_status);
1346:
1347: -- Standard check of p_commit
1348: IF FND_API.To_Boolean( p_commit ) THEN
1349: COMMIT WORK;
1350: END IF;
1351:
1352: -- Standard call to get message count and if count is 1, get message info.

Line 1361: WHEN FND_API.G_EXC_ERROR THEN

1357: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1358: END IF;
1359:
1360: EXCEPTION
1361: WHEN FND_API.G_EXC_ERROR THEN
1362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1363: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1364: g_module || l_api_name,
1365: 'Leaving create_contract:FND_API.G_EXC_ERROR Exception');

Line 1365: 'Leaving create_contract:FND_API.G_EXC_ERROR Exception');

1361: WHEN FND_API.G_EXC_ERROR THEN
1362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1363: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1364: g_module || l_api_name,
1365: 'Leaving create_contract:FND_API.G_EXC_ERROR Exception');
1366: END IF;
1367:
1368: ROLLBACK TO create_contract_PVT;
1369: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1369: x_return_status := FND_API.G_RET_STS_ERROR;

1365: 'Leaving create_contract:FND_API.G_EXC_ERROR Exception');
1366: END IF;
1367:
1368: ROLLBACK TO create_contract_PVT;
1369: x_return_status := FND_API.G_RET_STS_ERROR;
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count,
1372: p_data => x_msg_data
1373: );

Line 1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1371: p_count => x_msg_count,
1372: p_data => x_msg_data
1373: );
1374:
1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1377: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1378: g_module || l_api_name,
1379: 'Leaving create_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 1379: 'Leaving create_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1377: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1378: g_module || l_api_name,
1379: 'Leaving create_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1380: END IF;
1381:
1382: ROLLBACK TO create_contract_PVT;
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1379: 'Leaving create_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1380: END IF;
1381:
1382: ROLLBACK TO create_contract_PVT;
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: FND_MSG_PUB.Count_And_Get(
1385: p_count => x_msg_count,
1386: p_data => x_msg_data
1387: );

Line 1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1399: p_token2 => G_SQLERRM_TOKEN,
1400: p_token2_value => sqlerrm);
1401: ROLLBACK TO create_contract_PVT;
1402:
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: FND_MSG_PUB.Count_And_Get(
1405: p_count => x_msg_count,
1406: p_data => x_msg_data
1407: );

Line 1419: p_commit IN VARCHAR2 := fnd_api.g_false,

1415: Procedure delete_contract(p_api_version IN NUMBER,
1416: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1417: p_contract_type IN VARCHAR2 DEFAULT NULL,
1418: p_contract_id IN NUMBER DEFAULT NULL,
1419: p_commit IN VARCHAR2 := fnd_api.g_false,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: x_msg_count OUT NOCOPY NUMBER,
1422: x_return_status OUT NOCOPY VARCHAR2
1423: )

Line 1441: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1437: -- Standard Start of API savepoint
1438: SAVEPOINT delete_contract_PVT;
1439:
1440: -- Standard call to check for call compatibility.
1441: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1443: END IF;
1444:
1445: OKC_REP_CONTRACT_IMP_PVT.delete_contract( p_api_version => p_api_version,

Line 1442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1438: SAVEPOINT delete_contract_PVT;
1439:
1440: -- Standard call to check for call compatibility.
1441: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1443: END IF;
1444:
1445: OKC_REP_CONTRACT_IMP_PVT.delete_contract( p_api_version => p_api_version,
1446: p_document_rec => p_document_rec,

Line 1455: IF FND_API.To_Boolean( p_commit ) THEN

1451: x_msg_count => x_msg_count,
1452: x_return_status => x_return_status);
1453:
1454: -- Standard check of p_commit
1455: IF FND_API.To_Boolean( p_commit ) THEN
1456: COMMIT WORK;
1457: END IF;
1458:
1459: -- Standard call to get message count and if count is 1, get message info.

Line 1468: WHEN FND_API.G_EXC_ERROR THEN

1464: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1465: END IF;
1466:
1467: EXCEPTION
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1471: g_module || l_api_name,
1472: 'Leaving delete_contract:FND_API.G_EXC_ERROR Exception');

Line 1472: 'Leaving delete_contract:FND_API.G_EXC_ERROR Exception');

1468: WHEN FND_API.G_EXC_ERROR THEN
1469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1471: g_module || l_api_name,
1472: 'Leaving delete_contract:FND_API.G_EXC_ERROR Exception');
1473: END IF;
1474:
1475: ROLLBACK TO delete_contract_PVT;
1476: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1476: x_return_status := FND_API.G_RET_STS_ERROR;

1472: 'Leaving delete_contract:FND_API.G_EXC_ERROR Exception');
1473: END IF;
1474:
1475: ROLLBACK TO delete_contract_PVT;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: FND_MSG_PUB.Count_And_Get(
1478: p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );

Line 1482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1478: p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );
1481:
1482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1483: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1484: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1485: g_module || l_api_name,
1486: 'Leaving delete_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 1486: 'Leaving delete_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1483: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1484: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1485: g_module || l_api_name,
1486: 'Leaving delete_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1487: END IF;
1488:
1489: ROLLBACK TO delete_contract_PVT;
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1486: 'Leaving delete_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1487: END IF;
1488:
1489: ROLLBACK TO delete_contract_PVT;
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1491: FND_MSG_PUB.Count_And_Get(
1492: p_count => x_msg_count,
1493: p_data => x_msg_data
1494: );

Line 1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1506: p_token2 => G_SQLERRM_TOKEN,
1507: p_token2_value => sqlerrm);
1508: ROLLBACK TO delete_contract_PVT;
1509:
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: FND_MSG_PUB.Count_And_Get(
1512: p_count => x_msg_count,
1513: p_data => x_msg_data
1514: );

Line 1529: p_commit IN VARCHAR2 := fnd_api.g_false,

1525: Procedure create_new_contract_version(p_api_version IN NUMBER,
1526: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1527: p_contract_type IN VARCHAR2 DEFAULT NULL,
1528: p_contract_id IN NUMBER DEFAULT NULL,
1529: p_commit IN VARCHAR2 := fnd_api.g_false,
1530: x_msg_data OUT NOCOPY VARCHAR2,
1531: x_msg_count OUT NOCOPY NUMBER,
1532: x_return_status OUT NOCOPY VARCHAR2
1533: )

Line 1558: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1554: -- Standard Start of API savepoint
1555: SAVEPOINT create_contract_vers_PVT;
1556:
1557: -- Standard call to check for call compatibility.
1558: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: END IF;
1561:
1562: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;

Line 1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1555: SAVEPOINT create_contract_vers_PVT;
1556:
1557: -- Standard call to check for call compatibility.
1558: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: END IF;
1561:
1562: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
1563:

Line 1578: IF FND_API.To_Boolean( p_commit ) THEN

1574: x_msg_count => x_msg_count,
1575: x_return_status => x_return_status);
1576:
1577: -- Standard check of p_commit
1578: IF FND_API.To_Boolean( p_commit ) THEN
1579: COMMIT WORK;
1580: END IF;
1581:
1582: -- Standard call to get message count and if count is 1, get message info.

Line 1591: WHEN FND_API.G_EXC_ERROR THEN

1587: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1588: END IF;
1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1593: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1594: g_module || l_api_name,
1595: 'Leaving create_new_contract_version:FND_API.G_EXC_ERROR Exception');

Line 1595: 'Leaving create_new_contract_version:FND_API.G_EXC_ERROR Exception');

1591: WHEN FND_API.G_EXC_ERROR THEN
1592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1593: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1594: g_module || l_api_name,
1595: 'Leaving create_new_contract_version:FND_API.G_EXC_ERROR Exception');
1596: END IF;
1597:
1598: ROLLBACK TO create_contract_vers_PVT;
1599: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1599: x_return_status := FND_API.G_RET_STS_ERROR;

1595: 'Leaving create_new_contract_version:FND_API.G_EXC_ERROR Exception');
1596: END IF;
1597:
1598: ROLLBACK TO create_contract_vers_PVT;
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FND_MSG_PUB.Count_And_Get(
1601: p_count => x_msg_count,
1602: p_data => x_msg_data
1603: );

Line 1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1601: p_count => x_msg_count,
1602: p_data => x_msg_data
1603: );
1604:
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1608: g_module || l_api_name,
1609: 'Leaving create_new_contract_version:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 1609: 'Leaving create_new_contract_version:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1607: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1608: g_module || l_api_name,
1609: 'Leaving create_new_contract_version:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1610: END IF;
1611:
1612: ROLLBACK TO create_contract_vers_PVT;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1609: 'Leaving create_new_contract_version:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1610: END IF;
1611:
1612: ROLLBACK TO create_contract_vers_PVT;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: FND_MSG_PUB.Count_And_Get(
1615: p_count => x_msg_count,
1616: p_data => x_msg_data
1617: );

Line 1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1630: p_token2_value => sqlerrm);
1631:
1632: ROLLBACK TO create_contract_vers_PVT;
1633:
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1635: FND_MSG_PUB.Count_And_Get(
1636: p_count => x_msg_count,
1637: p_data => x_msg_data
1638: );

Line 1675: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1671: -- Standard Start of API savepoint
1672: SAVEPOINT check_contract_exists_PVT;
1673:
1674: -- Standard call to check for call compatibility.
1675: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END IF;
1678:
1679: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1672: SAVEPOINT check_contract_exists_PVT;
1673:
1674: -- Standard call to check for call compatibility.
1675: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END IF;
1678:
1679: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1680: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1702: WHEN FND_API.G_EXC_ERROR THEN

1698: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1699: END IF;
1700:
1701: EXCEPTION
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1704: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1705: g_module || l_api_name,
1706: 'Leaving check_contract_exists:FND_API.G_EXC_ERROR Exception');

Line 1706: 'Leaving check_contract_exists:FND_API.G_EXC_ERROR Exception');

1702: WHEN FND_API.G_EXC_ERROR THEN
1703: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1704: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1705: g_module || l_api_name,
1706: 'Leaving check_contract_exists:FND_API.G_EXC_ERROR Exception');
1707: END IF;
1708:
1709: ROLLBACK TO check_contract_exists_PVT;
1710: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1710: x_return_status := FND_API.G_RET_STS_ERROR;

1706: 'Leaving check_contract_exists:FND_API.G_EXC_ERROR Exception');
1707: END IF;
1708:
1709: ROLLBACK TO check_contract_exists_PVT;
1710: x_return_status := FND_API.G_RET_STS_ERROR;
1711: FND_MSG_PUB.Count_And_Get(
1712: p_count => x_msg_count,
1713: p_data => x_msg_data
1714: );

Line 1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1712: p_count => x_msg_count,
1713: p_data => x_msg_data
1714: );
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1719: g_module || l_api_name,
1720: 'Leaving check_contract_exists:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 1720: 'Leaving check_contract_exists:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1719: g_module || l_api_name,
1720: 'Leaving check_contract_exists:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1721: END IF;
1722:
1723: ROLLBACK TO check_contract_exists_PVT;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1720: 'Leaving check_contract_exists:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1721: END IF;
1722:
1723: ROLLBACK TO check_contract_exists_PVT;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: FND_MSG_PUB.Count_And_Get(
1726: p_count => x_msg_count,
1727: p_data => x_msg_data
1728: );

Line 1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1741: p_token2_value => sqlerrm);
1742:
1743: ROLLBACK TO check_contract_exists_PVT;
1744:
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746: FND_MSG_PUB.Count_And_Get(
1747: p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );

Line 1825: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1821: AND orc.contract_version_num = orcu.contract_version;
1822:
1823: -- calling package
1824: po_clm_okc_integ_pkg.start_closeout_wf_process(p_doc_id => l_po_header_id, x_return_status => l_return_status);
1825: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'po_clm_okc_integ_pkg.start_closeout_wf_process return status is not success');
1828: END IF;
1829: rollback;

Line 1830: RAISE FND_API.G_EXC_ERROR;

1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'po_clm_okc_integ_pkg.start_closeout_wf_process return status is not success');
1828: END IF;
1829: rollback;
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;
1832: END IF;
1833: END IF;
1834: commit;

Line 1845: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name, 'Leaving deliverable_completed_event:FND_API.G_EXC_ERROR Exception');

1841:
1842: EXCEPTION
1843: WHEN OTHERS THEN
1844: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1845: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name, 'Leaving deliverable_completed_event:FND_API.G_EXC_ERROR Exception');
1846: END IF;
1847: rollback;
1848: WF_CORE.CONTEXT('OKC_DELIVERABLE_WF_PVT', 'deliverable_completed_event', p_event.getEventName(), p_subscription_guid);
1849: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 1906: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1902: -- Standard Start of API savepoint
1903: SAVEPOINT val_closeout_tasks_PVT;
1904:
1905: -- Standard call to check for call compatibility.
1906: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END IF;
1909:
1910: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1903: SAVEPOINT val_closeout_tasks_PVT;
1904:
1905: -- Standard call to check for call compatibility.
1906: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END IF;
1909:
1910: -- Initialize message list if p_init_msg_list is set to TRUE.
1911: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1911: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908: END IF;
1909:
1910: -- Initialize message list if p_init_msg_list is set to TRUE.
1911: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1912: FND_MSG_PUB.initialize;
1913: END IF;
1914:
1915: -- Initialize API return status to success

Line 1916: x_return_status := FND_API.G_RET_STS_SUCCESS;

1912: FND_MSG_PUB.initialize;
1913: END IF;
1914:
1915: -- Initialize API return status to success
1916: x_return_status := FND_API.G_RET_STS_SUCCESS;
1917:
1918: -- Get contract document details which is associated to this PO Closeout
1919: OPEN c_get_doc_details;
1920: FETCH c_get_doc_details INTO contract_rec;

Line 1931: RAISE FND_API.G_EXC_ERROR;

1927: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1928: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
1929: p_token1 => G_CONTRACT_ID_TOKEN,
1930: p_token1_value => to_char(p_document_rec.business_document_id));
1931: RAISE FND_API.G_EXC_ERROR;
1932: END IF;
1933:
1934: l_bus_doc_date_events_tbl(1).event_code := G_PO_PHYSICAL_COMPLETE_EVENT;
1935: l_bus_doc_date_events_tbl(1).event_date := SYSDATE ;

Line 1940: p_init_msg_list => FND_API.G_FALSE,

1936:
1937:
1938: OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa (
1939: p_api_version => 1,
1940: p_init_msg_list => FND_API.G_FALSE,
1941: p_doc_type => contract_rec.contract_type,
1942: p_doc_id => contract_rec.contract_id,
1943: p_mode => G_NORMAL_QA,
1944: p_bus_doc_date_events_tbl => l_bus_doc_date_events_tbl,

Line 2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2009: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
2010: END IF;
2011: --------------------------------------------
2012: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2014: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2015: RAISE FND_API.G_EXC_ERROR ;
2016: END IF;
2017: --------------------------------------------

Line 2015: RAISE FND_API.G_EXC_ERROR ;

2011: --------------------------------------------
2012: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2014: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2015: RAISE FND_API.G_EXC_ERROR ;
2016: END IF;
2017: --------------------------------------------
2018:
2019: -- close open cursors

Line 2023: IF FND_API.To_Boolean( p_commit ) THEN

2019: -- close open cursors
2020: CLOSE c_get_doc_details;
2021:
2022: -- Standard check of p_commit
2023: IF FND_API.To_Boolean( p_commit ) THEN
2024: COMMIT WORK;
2025: END IF;
2026:
2027: -- Standard call to get message count and if count is 1, get message info.

Line 2036: WHEN FND_API.G_EXC_ERROR THEN

2032: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
2033: END IF;
2034:
2035: EXCEPTION
2036: WHEN FND_API.G_EXC_ERROR THEN
2037: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2039: g_module || l_api_name,
2040: 'Leaving validate_closeout_tasks:FND_API.G_EXC_ERROR Exception');

Line 2040: 'Leaving validate_closeout_tasks:FND_API.G_EXC_ERROR Exception');

2036: WHEN FND_API.G_EXC_ERROR THEN
2037: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2039: g_module || l_api_name,
2040: 'Leaving validate_closeout_tasks:FND_API.G_EXC_ERROR Exception');
2041: END IF;
2042: --close cursors
2043: IF (c_get_doc_details%ISOPEN) THEN
2044: CLOSE c_get_doc_details ;

Line 2047: x_return_status := FND_API.G_RET_STS_ERROR;

2043: IF (c_get_doc_details%ISOPEN) THEN
2044: CLOSE c_get_doc_details ;
2045: END IF;
2046: ROLLBACK TO val_closeout_tasks_PVT;
2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: FND_MSG_PUB.Count_And_Get(
2049: p_count => x_msg_count,
2050: p_data => x_msg_data
2051: );

Line 2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2049: p_count => x_msg_count,
2050: p_data => x_msg_data
2051: );
2052:
2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2054: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2055: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2056: g_module || l_api_name,
2057: 'Leaving validate_closeout_tasks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 2057: 'Leaving validate_closeout_tasks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2054: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2055: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2056: g_module || l_api_name,
2057: 'Leaving validate_closeout_tasks:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2058: END IF;
2059: --close cursors
2060: IF (c_get_doc_details%ISOPEN) THEN
2061: CLOSE c_get_doc_details ;

Line 2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2062: END IF;
2063:
2064: ROLLBACK TO val_closeout_tasks_PVT;
2065:
2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: FND_MSG_PUB.Count_And_Get(
2068: p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );

Line 2091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2087: --close cursors
2088: IF (c_get_doc_details%ISOPEN) THEN
2089: CLOSE c_get_doc_details ;
2090: END IF;
2091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2092: FND_MSG_PUB.Count_And_Get(
2093: p_count => x_msg_count,
2094: p_data => x_msg_data
2095: );

Line 2165: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2161: -- Standard Start of API savepoint
2162: SAVEPOINT copy_tasks_to_each_po_PVT;
2163:
2164: -- Standard call to check for call compatibility.
2165: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2167: END IF;
2168:
2169: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2162: SAVEPOINT copy_tasks_to_each_po_PVT;
2163:
2164: -- Standard call to check for call compatibility.
2165: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2167: END IF;
2168:
2169: -- Initialize message list if p_init_msg_list is set to TRUE.
2170: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2170: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2167: END IF;
2168:
2169: -- Initialize message list if p_init_msg_list is set to TRUE.
2170: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2171: FND_MSG_PUB.initialize;
2172: END IF;
2173:
2174: -- Initialize API return status to success

Line 2175: x_return_status := FND_API.G_RET_STS_SUCCESS;

2171: FND_MSG_PUB.initialize;
2172: END IF;
2173:
2174: -- Initialize API return status to success
2175: x_return_status := FND_API.G_RET_STS_SUCCESS;
2176:
2177: l_document_rec := p_tgt_document_rec;
2178:
2179: l_document_rec.source_code := 'INTERNAL';

Line 2245: p_init_msg_list => FND_API.G_FALSE,

2241: CLOSE c_get_tgt_contract;
2242:
2243: --copy the deliverables from source to target contract(i.e from mass closeout contract to individual PO contract)
2244: copy_deliverables( p_api_version => 1.0,
2245: p_init_msg_list => FND_API.G_FALSE,
2246: p_commit => p_commit,
2247: p_source_contract_type => 'REP_CCC',
2248: p_source_contract_id => l_source_contract_id,
2249: p_target_contract_type => 'REP_CCC',

Line 2281: IF FND_API.To_Boolean( p_commit ) THEN

2277: END IF;
2278: --------------------------------------------------------
2279:
2280: -- Standard check of p_commit
2281: IF FND_API.To_Boolean( p_commit ) THEN
2282: COMMIT WORK;
2283: END IF;
2284:
2285: -- Standard call to get message count and if count is 1, get message info.

Line 2294: WHEN FND_API.G_EXC_ERROR THEN

2290: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_set_tasks_to_each_po');
2291: END IF;
2292:
2293: EXCEPTION
2294: WHEN FND_API.G_EXC_ERROR THEN
2295: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2296: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2297: g_module || l_api_name,
2298: 'Leaving copy_set_tasks_to_each_po:FND_API.G_EXC_ERROR Exception');

Line 2298: 'Leaving copy_set_tasks_to_each_po:FND_API.G_EXC_ERROR Exception');

2294: WHEN FND_API.G_EXC_ERROR THEN
2295: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2296: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2297: g_module || l_api_name,
2298: 'Leaving copy_set_tasks_to_each_po:FND_API.G_EXC_ERROR Exception');
2299: END IF;
2300: --close cursors
2301: IF (c_get_src_contract%ISOPEN) THEN
2302: CLOSE c_get_src_contract ;

Line 2309: x_return_status := FND_API.G_RET_STS_ERROR;

2305: CLOSE c_get_tgt_contract ;
2306: END IF;
2307:
2308: ROLLBACK TO copy_tasks_to_each_po_PVT;
2309: x_return_status := FND_API.G_RET_STS_ERROR;
2310: FND_MSG_PUB.Count_And_Get(
2311: p_count => x_msg_count,
2312: p_data => x_msg_data
2313: );

Line 2315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2311: p_count => x_msg_count,
2312: p_data => x_msg_data
2313: );
2314:
2315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2316: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2317: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2318: g_module || l_api_name,
2319: 'Leaving copy_set_tasks_to_each_po:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

Line 2319: 'Leaving copy_set_tasks_to_each_po:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

2315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2316: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2317: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2318: g_module || l_api_name,
2319: 'Leaving copy_set_tasks_to_each_po:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2320: END IF;
2321: --close cursors
2322: IF (c_get_src_contract%ISOPEN) THEN
2323: CLOSE c_get_src_contract ;

Line 2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2327: END IF;
2328:
2329: ROLLBACK TO copy_tasks_to_each_po_PVT;
2330:
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2332: FND_MSG_PUB.Count_And_Get(
2333: p_count => x_msg_count,
2334: p_data => x_msg_data
2335: );

Line 2360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2356: IF (c_get_tgt_contract%ISOPEN) THEN
2357: CLOSE c_get_tgt_contract ;
2358: END IF;
2359:
2360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2361: FND_MSG_PUB.Count_And_Get(
2362: p_count => x_msg_count,
2363: p_data => x_msg_data
2364: );

Line 2409: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2405: -- Standard Start of API savepoint
2406: SAVEPOINT check_tasks_exists_PVT;
2407:
2408: -- Standard call to check for call compatibility.
2409: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2411: END IF;
2412:
2413: OPEN c_get_tasks_exists_csr;

Line 2410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2406: SAVEPOINT check_tasks_exists_PVT;
2407:
2408: -- Standard call to check for call compatibility.
2409: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2411: END IF;
2412:
2413: OPEN c_get_tasks_exists_csr;
2414: FETCH c_get_tasks_exists_csr INTO x_del_count;

Line 2417: x_return_status := FND_API.G_RET_STS_ERROR;

2413: OPEN c_get_tasks_exists_csr;
2414: FETCH c_get_tasks_exists_csr INTO x_del_count;
2415:
2416: IF c_get_tasks_exists_csr%NOTFOUND THEN
2417: x_return_status := FND_API.G_RET_STS_ERROR;
2418: END IF;
2419:
2420: CLOSE c_get_tasks_exists_csr;
2421:

Line 2431: WHEN FND_API.G_EXC_ERROR THEN

2427: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
2428: END IF;
2429:
2430: EXCEPTION
2431: WHEN FND_API.G_EXC_ERROR THEN
2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2433: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2434: g_module || l_api_name,
2435: 'Leaving check_tasks_exists:FND_API.G_EXC_ERROR Exception');

Line 2435: 'Leaving check_tasks_exists:FND_API.G_EXC_ERROR Exception');

2431: WHEN FND_API.G_EXC_ERROR THEN
2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2433: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2434: g_module || l_api_name,
2435: 'Leaving check_tasks_exists:FND_API.G_EXC_ERROR Exception');
2436: END IF;
2437:
2438: ROLLBACK TO check_tasks_exists_PVT;
2439: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2439: x_return_status := FND_API.G_RET_STS_ERROR;

2435: 'Leaving check_tasks_exists:FND_API.G_EXC_ERROR Exception');
2436: END IF;
2437:
2438: ROLLBACK TO check_tasks_exists_PVT;
2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: FND_MSG_PUB.Count_And_Get(
2441: p_count => x_msg_count,
2442: p_data => x_msg_data
2443: );

Line 2460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2456: p_token2_value => sqlerrm);
2457:
2458: ROLLBACK TO check_tasks_exists_PVT;
2459:
2460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2461: FND_MSG_PUB.Count_And_Get(
2462: p_count => x_msg_count,
2463: p_data => x_msg_data
2464: );