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_LOG

Line 40: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

36: AND party_role_code = 'INTERNAL_ORG';
37:
38: BEGIN
39:
40: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
41: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
42: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_deliverables');
43: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
44: 'Source Contract Id is: ' || p_source_contract_id);

Line 41: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

37:
38: BEGIN
39:
40: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
41: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
42: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_deliverables');
43: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
44: 'Source Contract Id is: ' || p_source_contract_id);
45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 43: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

39:
40: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
41: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
42: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_deliverables');
43: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
44: 'Source Contract Id is: ' || p_source_contract_id);
45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
46: 'Target Contract Id is: ' || p_target_contract_id);
47: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

41: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
42: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_deliverables');
43: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
44: 'Source Contract Id is: ' || p_source_contract_id);
45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
46: 'Target Contract Id is: ' || p_target_contract_id);
47: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
48: 'Source Contract Type is: ' || p_source_contract_type);
49: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 47: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

43: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
44: 'Source Contract Id is: ' || p_source_contract_id);
45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
46: 'Target Contract Id is: ' || p_target_contract_id);
47: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
48: 'Source Contract Type is: ' || p_source_contract_type);
49: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
50: 'Target Contract Type is: ' || p_target_contract_type);
51: END IF;

Line 49: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

45: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
46: 'Target Contract Id is: ' || p_target_contract_id);
47: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
48: 'Source Contract Type is: ' || p_source_contract_type);
49: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
50: 'Target Contract Type is: ' || p_target_contract_type);
51: END IF;
52: l_api_name := 'copy_deliverables';
53: l_api_version := 1.0;

Line 73: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

69: -- Get contract_type of target contract, required for deliverables and documents APIs
70: OPEN target_contract_csr;
71: FETCH target_contract_csr INTO target_contract_rec;
72: IF(target_contract_csr%NOTFOUND) THEN
73: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
75: G_MODULE||l_api_name,
76: 'Invalid Contract Id: '|| p_source_contract_id);
77: END IF;

Line 74: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

70: OPEN target_contract_csr;
71: FETCH target_contract_csr INTO target_contract_rec;
72: IF(target_contract_csr%NOTFOUND) THEN
73: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
74: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
75: G_MODULE||l_api_name,
76: 'Invalid Contract Id: '|| p_source_contract_id);
77: END IF;
78: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 89: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

85: -- Get internal party_id. Needed for deliverables api
86: OPEN party_csr;
87: FETCH party_csr INTO l_internal_party_id;
88: IF(party_csr%NOTFOUND) THEN
89: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
91: G_MODULE||l_api_name,
92: 'No internal party for the contract');
93: END IF;

Line 90: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

86: OPEN party_csr;
87: FETCH party_csr INTO l_internal_party_id;
88: IF(party_csr%NOTFOUND) THEN
89: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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;

Line 116: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data
114: );
115:
116: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
118: 'OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables return status is : '
119: || x_return_status);
120: END IF;

Line 117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

113: x_msg_data => x_msg_data
114: );
115:
116: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
117: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
118: 'OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables return status is : '
119: || x_return_status);
120: END IF;
121: -----------------------------------------------------

Line 140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

136:
137: -- Standard call to get message count and if count is 1, get message info.
138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
139:
140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
142: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_deliverables');
143: END IF;
144:

Line 141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

137: -- Standard call to get message count and if count is 1, get message info.
138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
139:
140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
142: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_deliverables');
143: END IF;
144:
145:

Line 148: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
152: END IF;

Line 149: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
152: END IF;
153: --close cursors

Line 168: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
172: END IF;

Line 169: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
172: END IF;
173: --close cursors

Line 188: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

184: p_data => x_msg_data
185: );
186:
187: WHEN OTHERS THEN
188: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
190: g_module || l_api_name,
191: 'Leaving copy_deliverables because of EXCEPTION: ' || sqlerrm);
192: END IF;

Line 189: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

185: );
186:
187: WHEN OTHERS THEN
188: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
190: g_module || l_api_name,
191: 'Leaving copy_deliverables because of EXCEPTION: ' || sqlerrm);
192: END IF;
193: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

243: AND contract_version = p_contract_version_num;
244:
245: BEGIN
246:
247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
249: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.revise_checklist');
250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
251: ' Contract Id is: ' || p_contract_id);

Line 248: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

244:
245: BEGIN
246:
247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
249: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.revise_checklist');
250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
251: ' Contract Id is: ' || p_contract_id);
252: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

246:
247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
249: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.revise_checklist');
250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
251: ' Contract Id is: ' || p_contract_id);
252: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
253: ' Contract Type is: ' || p_contract_type);
254: END IF;

Line 252: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

248: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
249: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.revise_checklist');
250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
251: ' Contract Id is: ' || p_contract_id);
252: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
253: ' Contract Type is: ' || p_contract_type);
254: END IF;
255:
256: l_api_name := 'revise_checklist';

Line 279: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
278: IF(c_get_doc_details%NOTFOUND) THEN
279: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
281: G_MODULE||l_api_name,
282: 'Invalid Contract Id: '|| p_contract_id);
283: END IF;

Line 280: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

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;
278: IF(c_get_doc_details%NOTFOUND) THEN
279: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
281: G_MODULE||l_api_name,
282: 'Invalid Contract Id: '|| p_contract_id);
283: END IF;
284: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 300: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

296: x_msg_data => x_msg_data,
297: x_msg_count => x_msg_count,
298: x_return_status => x_return_status);
299:
300: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
301: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
302: 'OKC_REP_CONTRACT_IMP_PVT.create_new_contract_version return status is : '
303: || x_return_status);
304: END IF;

Line 301: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

297: x_msg_count => x_msg_count,
298: x_return_status => x_return_status);
299:
300: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
301: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
302: 'OKC_REP_CONTRACT_IMP_PVT.create_new_contract_version return status is : '
303: || x_return_status);
304: END IF;
305: -----------------------------------------------------

Line 331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

327:
328: -- Standard call to get message count and if count is 1, get message info.
329: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
330:
331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
333: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.revise_checklist');
334: END IF;
335:

Line 332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

328: -- Standard call to get message count and if count is 1, get message info.
329: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
330:
331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
333: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.revise_checklist');
334: END IF;
335:
336: EXCEPTION

Line 338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
342: END IF;

Line 339: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
342: END IF;
343: --close cursors

Line 355: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
359: END IF;

Line 356: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
359: END IF;
360: --close cursors

Line 373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

369: p_data => x_msg_data
370: );
371:
372: WHEN OTHERS THEN
373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
374: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
375: g_module || l_api_name,
376: 'Leaving revise_checklist because of EXCEPTION: ' || sqlerrm);
377: END IF;

Line 374: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

370: );
371:
372: WHEN OTHERS THEN
373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
374: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
375: g_module || l_api_name,
376: 'Leaving revise_checklist because of EXCEPTION: ' || sqlerrm);
377: END IF;
378: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

428: AND orca.contract_id = orcu.contract_id;
429:
430: BEGIN
431:
432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
434: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.freeze_checklist');
435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
436: ' Contract Id is: ' || p_contract_id);

Line 433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

429:
430: BEGIN
431:
432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
434: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.freeze_checklist');
435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
436: ' Contract Id is: ' || p_contract_id);
437: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

431:
432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
434: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.freeze_checklist');
435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
436: ' Contract Id is: ' || p_contract_id);
437: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
438: ' Contract Type is: ' || p_contract_type);
439: END IF;

Line 437: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
434: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.freeze_checklist');
435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
436: ' Contract Id is: ' || p_contract_id);
437: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
438: ' Contract Type is: ' || p_contract_type);
439: END IF;
440:
441: l_api_name := 'freeze_checklist';

Line 464: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
463: IF(c_get_doc_details%NOTFOUND) THEN
464: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
466: G_MODULE||l_api_name,
467: 'Invalid Contract Id: '|| p_contract_id);
468: END IF;

Line 465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

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;
463: IF(c_get_doc_details%NOTFOUND) THEN
464: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
466: G_MODULE||l_api_name,
467: 'Invalid Contract Id: '|| p_contract_id);
468: END IF;
469: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 485: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

481: x_task_status => l_task_status,
482: x_msg_data => x_msg_data,
483: x_msg_count => x_msg_count,
484: x_return_status => x_return_status);
485: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
487: 'OKC_REP_CONTRACT_IMP_PVT.Activate_tasks_closeout return status is : '
488: || x_return_status);
489: END IF;

Line 486: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

482: x_msg_data => x_msg_data,
483: x_msg_count => x_msg_count,
484: x_return_status => x_return_status);
485: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
487: 'OKC_REP_CONTRACT_IMP_PVT.Activate_tasks_closeout return status is : '
488: || x_return_status);
489: END IF;
490: -----------------------------------------------------

Line 509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

505:
506: -- Standard call to get message count and if count is 1, get message info.
507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
508:
509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
511: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.freeze_checklist');
512: END IF;
513:

Line 510: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

506: -- Standard call to get message count and if count is 1, get message info.
507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
508:
509: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
511: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.freeze_checklist');
512: END IF;
513:
514: EXCEPTION

Line 516: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
520: END IF;

Line 517: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
520: END IF;
521: --close cursors

Line 533: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
537: END IF;

Line 534: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
537: END IF;
538: --close cursors

Line 551: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

547: p_data => x_msg_data
548: );
549:
550: WHEN OTHERS THEN
551: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
553: g_module || l_api_name,
554: 'Leaving freeze_checklist because of EXCEPTION: ' || sqlerrm);
555: END IF;

Line 552: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

548: );
549:
550: WHEN OTHERS THEN
551: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
553: g_module || l_api_name,
554: 'Leaving freeze_checklist because of EXCEPTION: ' || sqlerrm);
555: END IF;
556: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

608: contract_rec c_get_doc_details%ROWTYPE;
609:
610: BEGIN
611:
612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: ' Contract Id is: ' || p_contract_id);

Line 613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

609:
610: BEGIN
611:
612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: ' Contract Id is: ' || p_contract_id);
617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

611:
612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: ' Contract Id is: ' || p_contract_id);
617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
618: ' Contract Type is: ' || p_contract_type);
619: END IF;

Line 617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: ' Contract Id is: ' || p_contract_id);
617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
618: ' Contract Type is: ' || p_contract_type);
619: END IF;
620:
621: l_api_name := 'validate_closeout_tasks';

Line 644: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
643: IF(c_get_doc_details%NOTFOUND) THEN
644: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
646: G_MODULE||l_api_name,
647: 'Invalid Contract Id: '|| p_contract_id);
648: END IF;

Line 645: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

641: OPEN c_get_doc_details;
642: FETCH c_get_doc_details INTO contract_rec;
643: IF(c_get_doc_details%NOTFOUND) THEN
644: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
646: G_MODULE||l_api_name,
647: 'Invalid Contract Id: '|| p_contract_id);
648: END IF;
649: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 673: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

669: x_msg_count => x_msg_count,
670: x_return_status => x_return_status,
671: x_qa_return_status => x_qa_return_status);
672:
673: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
674: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
675: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
676: END IF;
677:

Line 674: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,

670: x_return_status => x_return_status,
671: x_qa_return_status => x_qa_return_status);
672:
673: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
674: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
675: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
676: END IF;
677:
678: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 690: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

686: -- Now insert into Temp table.
687: --------------------------------------------
688: -- Save result from PLSQL table into DB table
689: --------------------------------------------
690: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
692: G_MODULE||l_api_name,'1015: Save result from PLSQL table into DB table');
693: END IF;
694:

Line 691: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

687: --------------------------------------------
688: -- Save result from PLSQL table into DB table
689: --------------------------------------------
690: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
692: G_MODULE||l_api_name,'1015: Save result from PLSQL table into DB table');
693: END IF;
694:
695:

Line 700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

696: -- After calling the validation APIs we need to find out about the x_qa_return_status. We should loop through
697: -- this only if we get
698: IF l_qa_result_tbl.COUNT > 0 THEN
699: FOR i IN l_qa_result_tbl.FIRST..l_qa_result_tbl.LAST LOOP
700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
702: 'Updating pl/sql table record: ' || i);
703: END IF;
704: l_qa_result_tbl(i).error_record_type_name := okc_util.decode_lookup('OKC_ERROR_RECORD_TYPE',l_qa_result_tbl(i).error_record_type);

Line 701: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

697: -- this only if we get
698: IF l_qa_result_tbl.COUNT > 0 THEN
699: FOR i IN l_qa_result_tbl.FIRST..l_qa_result_tbl.LAST LOOP
700: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
702: 'Updating pl/sql table record: ' || i);
703: END IF;
704: l_qa_result_tbl(i).error_record_type_name := okc_util.decode_lookup('OKC_ERROR_RECORD_TYPE',l_qa_result_tbl(i).error_record_type);
705: l_qa_result_tbl(i).error_severity_name := okc_util.decode_lookup('OKC_QA_SEVERITY',l_qa_result_tbl(i).error_severity);

Line 724: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

720: x_qa_return_status := G_QA_STS_WARNING;
721: END IF;
722: END IF; -- l_qa_result_tbl.COUNT > 0 THEN
723:
724: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
726: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
727: END IF;
728: -- Load eror in the DB table

Line 725: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

721: END IF;
722: END IF; -- l_qa_result_tbl.COUNT > 0 THEN
723:
724: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
726: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
727: END IF;
728: -- Load eror in the DB table
729: OKC_TERMS_QA_PVT.Log_QA_Messages(

Line 735: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

731:
732: p_qa_result_tbl => l_qa_result_tbl,
733: x_sequence_id => x_sequence_id
734: );
735: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
736: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
737: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
738: END IF;
739: --------------------------------------------

Line 736: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

732: p_qa_result_tbl => l_qa_result_tbl,
733: x_sequence_id => x_sequence_id
734: );
735: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
736: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
737: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
738: END IF;
739: --------------------------------------------
740: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

754:
755: -- Standard call to get message count and if count is 1, get message info.
756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
757:
758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
759: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
760: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
761: END IF;
762:

Line 759: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

755: -- Standard call to get message count and if count is 1, get message info.
756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
757:
758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
759: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
760: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
761: END IF;
762:
763: EXCEPTION

Line 765: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
769: END IF;

Line 766: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
769: END IF;
770: --close cursors

Line 782: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
786: END IF;

Line 783: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
786: END IF;
787: --close cursors

Line 801: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

797: p_data => x_msg_data
798: );
799:
800: WHEN OTHERS THEN
801: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
803: g_module || l_api_name,
804: 'Leaving validate_closeout_tasks because of EXCEPTION: ' || sqlerrm);
805: END IF;

Line 802: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

798: );
799:
800: WHEN OTHERS THEN
801: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
803: g_module || l_api_name,
804: 'Leaving validate_closeout_tasks because of EXCEPTION: ' || sqlerrm);
805: END IF;
806: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
880: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
881: 'Business Document Id is: ' || p_document_rec.business_document_id);

Line 878: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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');
880: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
881: 'Business Document Id is: ' || p_document_rec.business_document_id);
882: END IF;

Line 880: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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');
880: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
881: 'Business Document Id is: ' || p_document_rec.business_document_id);
882: END IF;
883: l_api_name := 'Activate_tasks_closeout';
884: l_api_version := 1.0;

Line 906: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

902: --find the contract associated to this business document
903: OPEN c_get_contract_id_csr;
904: FETCH c_get_contract_id_csr INTO l_contract_type, l_contract_id;
905: IF(c_get_contract_id_csr%NOTFOUND) THEN
906: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
907: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
908: G_MODULE||l_api_name,
909: 'Invalid Business Document Type: '|| p_document_rec.business_document_type);
910: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

Line 907: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

903: OPEN c_get_contract_id_csr;
904: FETCH c_get_contract_id_csr INTO l_contract_type, l_contract_id;
905: IF(c_get_contract_id_csr%NOTFOUND) THEN
906: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
907: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
908: G_MODULE||l_api_name,
909: 'Invalid Business Document Type: '|| p_document_rec.business_document_type);
910: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
911: G_MODULE||l_api_name,

Line 910: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

906: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
907: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
908: G_MODULE||l_api_name,
909: 'Invalid Business Document Type: '|| p_document_rec.business_document_type);
910: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
911: G_MODULE||l_api_name,
912: 'Invalid Business Document Id: '|| p_document_rec.business_document_id);
913:
914: END IF;

Line 927: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

923: -- Get effective dates and version of the contract.
924: OPEN contract_csr(l_contract_type, l_contract_id);
925: FETCH contract_csr INTO contract_rec;
926: IF(contract_csr%NOTFOUND) THEN
927: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
928: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
929: G_MODULE||l_api_name,
930: 'Invalid Contract Id: '|| l_contract_id);
931: END IF;

Line 928: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

924: OPEN contract_csr(l_contract_type, l_contract_id);
925: FETCH contract_csr INTO contract_rec;
926: IF(contract_csr%NOTFOUND) THEN
927: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
928: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
929: G_MODULE||l_api_name,
930: 'Invalid Contract Id: '|| l_contract_id);
931: END IF;
932: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 941: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

937: -- RAISE NO_DATA_FOUND;
938: END IF;
939:
940: -- Lock the contract header
941: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
942: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
943: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
944: END IF;
945: -- Lock the contract header

Line 942: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

938: END IF;
939:
940: -- Lock the contract header
941: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
942: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
943: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
944: END IF;
945: -- Lock the contract header
946: okc_rep_contract_process_pvt.Lock_Contract_Header(

Line 952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

948: p_object_version_number => NULL,
949: x_return_status => x_return_status
950: );
951:
952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
954: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
955: || x_return_status);
956: END IF;

Line 953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

949: x_return_status => x_return_status
950: );
951:
952: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
953: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
954: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
955: || x_return_status);
956: END IF;
957:

Line 966: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

962: RAISE OKC_API.G_EXCEPTION_ERROR;
963: END IF;
964: -----------------------------------------------------
965:
966: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
968: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
969: END IF;
970: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.

Line 967: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

963: END IF;
964: -----------------------------------------------------
965:
966: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
968: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
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(

Line 983: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

979: x_msg_data => x_msg_data,
980: x_msg_count => x_msg_count,
981: x_return_status => x_return_status);
982:
983: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
984: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
985: g_module || l_api_name,
986: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
987: END IF;

Line 984: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

980: x_msg_count => x_msg_count,
981: x_return_status => x_return_status);
982:
983: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
984: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
985: g_module || l_api_name,
986: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
987: END IF;
988: -----------------------------------------------------

Line 997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

993: END IF;
994: ------------------------------------------------------
995:
996: -- We need to first version the deliverables
997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
999: 'Calling OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');
1000: END IF;
1001:

Line 998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

994: ------------------------------------------------------
995:
996: -- We need to first version the deliverables
997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
999: 'Calling OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');
1000: END IF;
1001:
1002: OKC_DELIVERABLE_PROCESS_PVT.version_deliverables (

Line 1013: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1009: x_msg_count => x_msg_count,
1010: x_msg_data => x_msg_data
1011: );
1012:
1013: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1014: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1015: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
1016: || x_return_status);
1017: END IF;

Line 1014: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1010: x_msg_data => x_msg_data
1011: );
1012:
1013: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1014: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1015: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
1016: || x_return_status);
1017: END IF;
1018: -----------------------------------------------------

Line 1026: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1022: RAISE OKC_API.G_EXCEPTION_ERROR;
1023: END IF;
1024: --------------------------------------------------------
1025:
1026: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1028: 'Latest signed version number is : '
1029: || contract_rec.latest_signed_ver_number);
1030: END IF;

Line 1027: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1023: END IF;
1024: --------------------------------------------------------
1025:
1026: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1028: 'Latest signed version number is : '
1029: || contract_rec.latest_signed_ver_number);
1030: END IF;
1031: -- Now we need to activate deliverables

Line 1038: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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,
1040: 'l_sync_flag is : ' || l_sync_flag);
1041: END IF;
1042:

Line 1039: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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,
1040: 'l_sync_flag is : ' || l_sync_flag);
1041: END IF;
1042:
1043: l_activate_event_tbl(1).event_code := 'PO_PHYSICAL_COMPLETE';

Line 1046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1042:
1043: l_activate_event_tbl(1).event_code := 'PO_PHYSICAL_COMPLETE';
1044: l_activate_event_tbl(1).event_date := p_physical_completion_date;
1045:
1046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1048: 'Calling OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
1049: END IF;
1050:

Line 1047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1043: l_activate_event_tbl(1).event_code := 'PO_PHYSICAL_COMPLETE';
1044: l_activate_event_tbl(1).event_date := p_physical_completion_date;
1045:
1046: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1048: 'Calling OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
1049: END IF;
1050:
1051: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (

Line 1066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1062: x_msg_data => x_msg_data,
1063: x_msg_count => x_msg_count,
1064: x_return_status => x_return_status);
1065:
1066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1068: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
1069: || x_return_status);
1070: END IF;

Line 1067: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1063: x_msg_count => x_msg_count,
1064: x_return_status => x_return_status);
1065:
1066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1068: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
1069: || x_return_status);
1070: END IF;
1071: -----------------------------------------------------

Line 1082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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()');
1085: END IF;
1086:

Line 1083: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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()');
1085: END IF;
1086:
1087: l_update_event_tbl(1).event_code := 'PO_PHYSICAL_COMPLETE';

Line 1092: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1088: l_update_event_tbl(1).event_date := p_physical_completion_date;
1089:
1090: -- we need to call deliverables API for synching previous signed deliverables.
1091:
1092: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1093: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1094: 'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
1095: END IF;
1096: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (

Line 1093: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1089:
1090: -- we need to call deliverables API for synching previous signed deliverables.
1091:
1092: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1093: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1094: 'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
1095: END IF;
1096: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
1097: p_api_version => 1.0,

Line 1109: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1105: x_msg_count => x_msg_count,
1106: x_return_status => x_return_status);
1107:
1108:
1109: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1110: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1111: 'OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables return status is : '
1112: || x_return_status);
1113: END IF;

Line 1110: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1106: x_return_status => x_return_status);
1107:
1108:
1109: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1110: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1111: 'OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables return status is : '
1112: || x_return_status);
1113: END IF;
1114: -----------------------------------------------------

Line 1123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1119: END IF;
1120: --------------------------------------------------------
1121:
1122: -- Disable prev. version deliverables
1123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1125: 'Calling OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables');
1126: END IF;
1127: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (

Line 1124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1120: --------------------------------------------------------
1121:
1122: -- Disable prev. version deliverables
1123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1125: 'Calling OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables');
1126: END IF;
1127: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
1128: p_api_version => 1.0,

Line 1138: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1134: x_msg_data => x_msg_data,
1135: x_msg_count => x_msg_count,
1136: x_return_status => x_return_status);
1137:
1138: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1139: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1140: 'OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables return status is : '
1141: || x_return_status);
1142: END IF;

Line 1139: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1135: x_msg_count => x_msg_count,
1136: x_return_status => x_return_status);
1137:
1138: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1139: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1140: 'OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables return status is : '
1141: || x_return_status);
1142: END IF;
1143: -----------------------------------------------------

Line 1152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1148: END IF;
1149: --------------------------------------------------------
1150: END IF; -- (l_sync_flag = 'Y')
1151:
1152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1154: 'Updating latest_signed_ver_number column');
1155: END IF;
1156:

Line 1153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1149: --------------------------------------------------------
1150: END IF; -- (l_sync_flag = 'Y')
1151:
1152: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1154: 'Updating latest_signed_ver_number column');
1155: END IF;
1156:
1157: UPDATE okc_rep_contracts_all

Line 1179: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1175:
1176: -- Standard call to get message count and if count is 1, get message info.
1177: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1178:
1179: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1180: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1181: 'Leaving OKC_REP_CLOSEOUT_PVT.Activate_tasks_closeout');
1182: END IF;
1183:

Line 1180: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1176: -- Standard call to get message count and if count is 1, get message info.
1177: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1178:
1179: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1180: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1181: 'Leaving OKC_REP_CLOSEOUT_PVT.Activate_tasks_closeout');
1182: END IF;
1183:
1184: EXCEPTION

Line 1186: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1190: END IF;

Line 1187: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1190: END IF;
1191: --close cursors

Line 1209: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1213: END IF;

Line 1210: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1213: END IF;
1214: --close cursors

Line 1232: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1228: p_data => x_msg_data
1229: );
1230:
1231: WHEN OTHERS THEN
1232: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1233: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1234: g_module || l_api_name,
1235: 'Leaving sign_contract because of EXCEPTION: ' || sqlerrm);
1236: END IF;

Line 1233: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1229: );
1230:
1231: WHEN OTHERS THEN
1232: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1233: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1234: g_module || l_api_name,
1235: 'Leaving sign_contract because of EXCEPTION: ' || sqlerrm);
1236: END IF;
1237: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1286: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1282:
1283: BEGIN
1284: l_api_name := 'create_contract';
1285:
1286: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1288: 'Entered OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1289: END IF;
1290:

Line 1287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1283: BEGIN
1284: l_api_name := 'create_contract';
1285:
1286: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1288: 'Entered OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1289: END IF;
1290:
1291: -- Standard Start of API savepoint

Line 1355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1351:
1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1354:
1355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1356: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1357: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1358: END IF;
1359:

Line 1356: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1354:
1355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1356: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1357: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1358: END IF;
1359:
1360: EXCEPTION

Line 1362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1366: END IF;

Line 1363: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1366: END IF;
1367:

Line 1376: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1380: END IF;

Line 1377: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1380: END IF;
1381:

Line 1390: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1386: p_data => x_msg_data
1387: );
1388:
1389: WHEN OTHERS THEN
1390: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1392: g_module || l_api_name,
1393: 'Leaving create_contract because of EXCEPTION: ' || sqlerrm);
1394: END IF;

Line 1391: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1387: );
1388:
1389: WHEN OTHERS THEN
1390: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1392: g_module || l_api_name,
1393: 'Leaving create_contract because of EXCEPTION: ' || sqlerrm);
1394: END IF;
1395: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1428:
1429: BEGIN
1430: l_api_name := 'delete_contract';
1431:
1432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1434: 'Entered OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1435: END IF;
1436:

Line 1433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1429: BEGIN
1430: l_api_name := 'delete_contract';
1431:
1432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1434: 'Entered OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1435: END IF;
1436:
1437: -- Standard Start of API savepoint

Line 1462: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1458:
1459: -- Standard call to get message count and if count is 1, get message info.
1460: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1461:
1462: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1464: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1465: END IF;
1466:

Line 1463: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1459: -- Standard call to get message count and if count is 1, get message info.
1460: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1461:
1462: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1464: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1465: END IF;
1466:
1467: EXCEPTION

Line 1469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1473: END IF;

Line 1470: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1473: END IF;
1474:

Line 1483: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1487: END IF;

Line 1484: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1487: END IF;
1488:

Line 1497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1493: p_data => x_msg_data
1494: );
1495:
1496: WHEN OTHERS THEN
1497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1499: g_module || l_api_name,
1500: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
1501: END IF;

Line 1498: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1494: );
1495:
1496: WHEN OTHERS THEN
1497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1499: g_module || l_api_name,
1500: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
1501: END IF;
1502: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1543: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1539:
1540: BEGIN
1541: l_api_name := 'create_new_contract_version';
1542:
1543: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1545: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1547: 'p_contract_id: '||p_contract_id);

Line 1544: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1540: BEGIN
1541: l_api_name := 'create_new_contract_version';
1542:
1543: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1545: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1547: 'p_contract_id: '||p_contract_id);
1548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1542:
1543: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1545: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1547: 'p_contract_id: '||p_contract_id);
1548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1549: 'p_contract_type: '||p_contract_type);
1550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1544: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1545: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1547: 'p_contract_id: '||p_contract_id);
1548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1549: 'p_contract_type: '||p_contract_type);
1550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1551: 'p_commit : '||p_commit);
1552: END IF;

Line 1550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1547: 'p_contract_id: '||p_contract_id);
1548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1549: 'p_contract_type: '||p_contract_type);
1550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1551: 'p_commit : '||p_commit);
1552: END IF;
1553:
1554: -- Standard Start of API savepoint

Line 1564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1560: END IF;
1561:
1562: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
1563:
1564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'l_run_id : '||l_run_id);
1567: END IF;
1568:

Line 1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1561:
1562: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
1563:
1564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'l_run_id : '||l_run_id);
1567: END IF;
1568:
1569: OKC_REP_CONTRACT_IMP_PVT.create_new_contract_version( p_api_version => p_api_version,

Line 1585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1581:
1582: -- Standard call to get message count and if count is 1, get message info.
1583: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1584:
1585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1587: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1588: END IF;
1589:

Line 1586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1582: -- Standard call to get message count and if count is 1, get message info.
1583: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1584:
1585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1587: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1588: END IF;
1589:
1590: EXCEPTION

Line 1592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1596: END IF;

Line 1593: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1596: END IF;
1597:

Line 1606: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1610: END IF;

Line 1607: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1610: END IF;
1611:

Line 1620: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1616: p_data => x_msg_data
1617: );
1618:
1619: WHEN OTHERS THEN
1620: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1621: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1622: g_module || l_api_name,
1623: 'Leaving create_new_contract_version because of EXCEPTION: ' || sqlerrm);
1624: END IF;

Line 1621: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1617: );
1618:
1619: WHEN OTHERS THEN
1620: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1621: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1622: g_module || l_api_name,
1623: 'Leaving create_new_contract_version because of EXCEPTION: ' || sqlerrm);
1624: END IF;
1625: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1660: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1656:
1657: BEGIN
1658: l_api_name := 'check_contract_exists';
1659:
1660: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1661: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1662: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1664: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);

Line 1661: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1657: BEGIN
1658: l_api_name := 'check_contract_exists';
1659:
1660: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1661: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1662: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1664: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1659:
1660: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1661: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1662: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1664: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1666: 'p_document_rec.business_document_id '||p_document_rec.business_document_id);
1667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1661: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1662: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);
1663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1664: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1666: 'p_document_rec.business_document_id '||p_document_rec.business_document_id);
1667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1668: 'p_document_rec.business_document_version '||p_document_rec.business_document_version);
1669: END IF;

Line 1667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1664: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1666: 'p_document_rec.business_document_id '||p_document_rec.business_document_id);
1667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1668: 'p_document_rec.business_document_version '||p_document_rec.business_document_version);
1669: END IF;
1670:
1671: -- Standard Start of API savepoint

Line 1679: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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,
1681: 'l_run_id : '||l_run_id);
1682: END IF;
1683:

Line 1680: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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,
1681: 'l_run_id : '||l_run_id);
1682: END IF;
1683:
1684: OKC_REP_CONTRACT_IMP_PVT.check_contract_exists(p_api_version => 1.0,

Line 1696: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1692:
1693: -- Standard call to get message count and if count is 1, get message info.
1694: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1695:
1696: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1697: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1698: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1699: END IF;
1700:

Line 1697: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1693: -- Standard call to get message count and if count is 1, get message info.
1694: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1695:
1696: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1697: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1698: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
1699: END IF;
1700:
1701: EXCEPTION

Line 1703: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1707: END IF;

Line 1704: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1707: END IF;
1708:

Line 1717: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
1721: END IF;

Line 1718: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
1721: END IF;
1722:

Line 1731: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1727: p_data => x_msg_data
1728: );
1729:
1730: WHEN OTHERS THEN
1731: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1732: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1733: g_module || l_api_name,
1734: 'Leaving check_contract_exists because of EXCEPTION: ' || sqlerrm);
1735: END IF;

Line 1732: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1728: );
1729:
1730: WHEN OTHERS THEN
1731: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1732: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1733: g_module || l_api_name,
1734: 'Leaving check_contract_exists because of EXCEPTION: ' || sqlerrm);
1735: END IF;
1736: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1780: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1776: BEGIN
1777:
1778: l_api_name := 'deliverable_completed_event';
1779:
1780: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'Entered OKC_REP_CLOSEOUT_PVT.deliverable_completed_event');
1782: END IF;
1783:
1784: l_deliverable_id := p_event.GetValueForParameter('DELIVERABLE_ID');

Line 1781: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'Entered OKC_REP_CLOSEOUT_PVT.deliverable_completed_event');

1777:
1778: l_api_name := 'deliverable_completed_event';
1779:
1780: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'Entered OKC_REP_CLOSEOUT_PVT.deliverable_completed_event');
1782: END IF;
1783:
1784: l_deliverable_id := p_event.GetValueForParameter('DELIVERABLE_ID');
1785:

Line 1790: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1786: OPEN del_cur;
1787: FETCH del_cur into l_del_rec;
1788: CLOSE del_cur;
1789:
1790: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1791: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'DeliverableId is: ' || l_deliverable_id);
1792: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'business_document_type is: ' || l_del_rec.business_document_type);
1793: END IF;
1794:

Line 1791: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'DeliverableId is: ' || l_deliverable_id);

1787: FETCH del_cur into l_del_rec;
1788: CLOSE del_cur;
1789:
1790: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1791: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'DeliverableId is: ' || l_deliverable_id);
1792: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'business_document_type is: ' || l_del_rec.business_document_type);
1793: END IF;
1794:
1795: --checking whether the contract_type is CLOSE OUT OR NOT

Line 1792: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'business_document_type is: ' || l_del_rec.business_document_type);

1788: CLOSE del_cur;
1789:
1790: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1791: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'DeliverableId is: ' || l_deliverable_id);
1792: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'business_document_type is: ' || l_del_rec.business_document_type);
1793: END IF;
1794:
1795: --checking whether the contract_type is CLOSE OUT OR NOT
1796: IF (l_del_rec.business_document_type = 'REP_CCC') THEN

Line 1826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
1830: RAISE FND_API.G_EXC_ERROR;

Line 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');

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;
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;

Line 1836: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1832: END IF;
1833: END IF;
1834: commit;
1835:
1836: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1837: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'all_dels_completed is: ' || all_dels_completed);
1838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'Leaving OKC_REP_CLOSEOUT_PVT.deliverable_completed_event');
1839: END IF;
1840: RETURN 'SUCCESS';

Line 1837: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'all_dels_completed is: ' || all_dels_completed);

1833: END IF;
1834: commit;
1835:
1836: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1837: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'all_dels_completed is: ' || all_dels_completed);
1838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'Leaving OKC_REP_CLOSEOUT_PVT.deliverable_completed_event');
1839: END IF;
1840: RETURN 'SUCCESS';
1841:

Line 1838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'Leaving OKC_REP_CLOSEOUT_PVT.deliverable_completed_event');

1834: commit;
1835:
1836: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1837: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'all_dels_completed is: ' || all_dels_completed);
1838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, 'Leaving OKC_REP_CLOSEOUT_PVT.deliverable_completed_event');
1839: END IF;
1840: RETURN 'SUCCESS';
1841:
1842: EXCEPTION

Line 1844: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1840: RETURN 'SUCCESS';
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);

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 1890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1886: contract_rec c_get_doc_details%ROWTYPE;
1887:
1888: BEGIN
1889:
1890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1892: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
1893: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1894: ' Business Document Id is: ' || p_document_rec.business_document_id);

Line 1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1887:
1888: BEGIN
1889:
1890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1892: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
1893: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1894: ' Business Document Id is: ' || p_document_rec.business_document_id);
1895: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1893: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1889:
1890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1892: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
1893: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1894: ' Business Document Id is: ' || p_document_rec.business_document_id);
1895: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1896: ' Business Document Type is: ' || p_document_rec.business_document_type);
1897: END IF;

Line 1895: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1892: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
1893: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1894: ' Business Document Id is: ' || p_document_rec.business_document_id);
1895: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1896: ' Business Document Type is: ' || p_document_rec.business_document_type);
1897: END IF;
1898:
1899: l_api_name := 'validate_closeout_tasks';

Line 1922: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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;
1921: IF(c_get_doc_details%NOTFOUND) THEN
1922: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1923: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1924: G_MODULE||l_api_name,
1925: 'Invalid Business Document Id: '|| p_document_rec.business_document_id);
1926: END IF;

Line 1923: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,

1919: OPEN c_get_doc_details;
1920: FETCH c_get_doc_details INTO contract_rec;
1921: IF(c_get_doc_details%NOTFOUND) THEN
1922: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1923: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1924: G_MODULE||l_api_name,
1925: 'Invalid Business Document Id: '|| p_document_rec.business_document_id);
1926: END IF;
1927: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1951: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1947: x_msg_count => x_msg_count,
1948: x_return_status => x_return_status,
1949: x_qa_return_status => x_qa_return_status);
1950:
1951: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1952: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1953: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
1954: END IF;
1955:

Line 1952: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,

1948: x_return_status => x_return_status,
1949: x_qa_return_status => x_qa_return_status);
1950:
1951: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1952: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1953: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
1954: END IF;
1955:
1956: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1968: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1964: -- Now insert into Temp table.
1965: --------------------------------------------
1966: -- Save result from PLSQL table into DB table
1967: --------------------------------------------
1968: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1969: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1970: G_MODULE||l_api_name,'1015: Save result from PLSQL table into DB table');
1971: END IF;
1972:

Line 1969: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

1965: --------------------------------------------
1966: -- Save result from PLSQL table into DB table
1967: --------------------------------------------
1968: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1969: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1970: G_MODULE||l_api_name,'1015: Save result from PLSQL table into DB table');
1971: END IF;
1972:
1973:

Line 1978: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1974: -- After calling the validation APIs we need to find out about the x_qa_return_status. We should loop through
1975: -- this only if we get
1976: IF x_qa_result_tbl.COUNT > 0 THEN
1977: FOR i IN l_qa_result_tbl.FIRST..l_qa_result_tbl.LAST LOOP
1978: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1979: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1980: 'Updating pl/sql table record: ' || i);
1981: END IF;
1982: x_qa_result_tbl(i).error_record_type_name := okc_util.decode_lookup('OKC_ERROR_RECORD_TYPE',x_qa_result_tbl(i).error_record_type);

Line 1979: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1975: -- this only if we get
1976: IF x_qa_result_tbl.COUNT > 0 THEN
1977: FOR i IN l_qa_result_tbl.FIRST..l_qa_result_tbl.LAST LOOP
1978: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1979: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1980: 'Updating pl/sql table record: ' || i);
1981: END IF;
1982: x_qa_result_tbl(i).error_record_type_name := okc_util.decode_lookup('OKC_ERROR_RECORD_TYPE',x_qa_result_tbl(i).error_record_type);
1983: x_qa_result_tbl(i).error_severity_name := okc_util.decode_lookup('OKC_QA_SEVERITY',x_qa_result_tbl(i).error_severity);

Line 2002: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1998: x_qa_return_status := G_QA_STS_WARNING;
1999: END IF;
2000: END IF; -- l_qa_result_tbl.COUNT > 0 THEN
2001:
2002: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2003: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2004: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
2005: END IF;
2006:

Line 2003: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1999: END IF;
2000: END IF; -- l_qa_result_tbl.COUNT > 0 THEN
2001:
2002: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2003: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2004: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
2005: END IF;
2006:
2007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2003: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2004: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
2005: END IF;
2006:
2007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2009: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
2010: END IF;
2011: --------------------------------------------

Line 2008: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

2004: 'Calling OKC_TERMS_QA_PVT.Log_QA_Messages');
2005: END IF;
2006:
2007: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2009: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
2010: END IF;
2011: --------------------------------------------
2012: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2030: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2026:
2027: -- Standard call to get message count and if count is 1, get message info.
2028: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2029:
2030: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2031: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2032: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
2033: END IF;
2034:

Line 2031: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2027: -- Standard call to get message count and if count is 1, get message info.
2028: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2029:
2030: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2031: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2032: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
2033: END IF;
2034:
2035: EXCEPTION

Line 2037: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
2041: END IF;

Line 2038: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
2041: END IF;
2042: --close cursors

Line 2054: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
2058: END IF;

Line 2055: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
2058: END IF;
2059: --close cursors

Line 2073: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2069: p_data => x_msg_data
2070: );
2071:
2072: WHEN OTHERS THEN
2073: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2074: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2075: g_module || l_api_name,
2076: 'Leaving validate_closeout_tasks because of EXCEPTION: ' || sqlerrm);
2077: END IF;

Line 2074: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2070: );
2071:
2072: WHEN OTHERS THEN
2073: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2074: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2075: g_module || l_api_name,
2076: 'Leaving validate_closeout_tasks because of EXCEPTION: ' || sqlerrm);
2077: END IF;
2078: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2144: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2140: AND orca.contract_id = orcu.contract_id;
2141:
2142: BEGIN
2143:
2144: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2146: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
2147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2148: ' Business Document Id is: ' || p_src_document_rec.business_document_id);

Line 2145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2141:
2142: BEGIN
2143:
2144: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2146: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
2147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2148: ' Business Document Id is: ' || p_src_document_rec.business_document_id);
2149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2143:
2144: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2146: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
2147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2148: ' Business Document Id is: ' || p_src_document_rec.business_document_id);
2149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2150: ' Business Document Type is: ' || p_src_document_rec.business_document_type);
2151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2146: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.validate_closeout_tasks');
2147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2148: ' Business Document Id is: ' || p_src_document_rec.business_document_id);
2149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2150: ' Business Document Type is: ' || p_src_document_rec.business_document_type);
2151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2152: ' Business Document Id is: ' || p_tgt_document_rec.business_document_id);
2153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2148: ' Business Document Id is: ' || p_src_document_rec.business_document_id);
2149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2150: ' Business Document Type is: ' || p_src_document_rec.business_document_type);
2151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2152: ' Business Document Id is: ' || p_tgt_document_rec.business_document_id);
2153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2154: ' Business Document Type is: ' || p_tgt_document_rec.business_document_type);
2155:

Line 2153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2150: ' Business Document Type is: ' || p_src_document_rec.business_document_type);
2151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2152: ' Business Document Id is: ' || p_tgt_document_rec.business_document_id);
2153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2154: ' Business Document Type is: ' || p_tgt_document_rec.business_document_type);
2155:
2156: END IF;
2157:

Line 2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2284:
2285: -- Standard call to get message count and if count is 1, get message info.
2286: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2287:
2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2290: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_set_tasks_to_each_po');
2291: END IF;
2292:

Line 2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2285: -- Standard call to get message count and if count is 1, get message info.
2286: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2287:
2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2290: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_set_tasks_to_each_po');
2291: END IF;
2292:
2293: EXCEPTION

Line 2295: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
2299: END IF;

Line 2296: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
2299: END IF;
2300: --close cursors

Line 2316: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
2320: END IF;

Line 2317: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
2320: END IF;
2321: --close cursors

Line 2338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2334: p_data => x_msg_data
2335: );
2336:
2337: WHEN OTHERS THEN
2338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2339: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2340: g_module || l_api_name,
2341: 'Leaving copy_set_tasks_to_each_po because of EXCEPTION: ' || sqlerrm);
2342: END IF;

Line 2339: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2335: );
2336:
2337: WHEN OTHERS THEN
2338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2339: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2340: g_module || l_api_name,
2341: 'Leaving copy_set_tasks_to_each_po because of EXCEPTION: ' || sqlerrm);
2342: END IF;
2343: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2390: BEGIN
2391:
2392: l_api_name := 'check_tasks_exists';
2393:
2394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2396: 'Entered okc_rep_closeout_pvt.'||l_api_name);
2397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2398: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);

Line 2395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2391:
2392: l_api_name := 'check_tasks_exists';
2393:
2394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2396: 'Entered okc_rep_closeout_pvt.'||l_api_name);
2397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2398: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
2399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2393:
2394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2396: 'Entered okc_rep_closeout_pvt.'||l_api_name);
2397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2398: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
2399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2400: 'p_document_rec.business_document_id '||p_document_rec.business_document_id);
2401: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2396: 'Entered okc_rep_closeout_pvt.'||l_api_name);
2397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2398: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
2399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2400: 'p_document_rec.business_document_id '||p_document_rec.business_document_id);
2401: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2402: 'p_document_rec.business_document_version '||p_document_rec.business_document_version);
2403: END IF;

Line 2401: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2398: 'p_document_rec.business_document_type '||p_document_rec.business_document_type);
2399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2400: 'p_document_rec.business_document_id '||p_document_rec.business_document_id);
2401: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2402: 'p_document_rec.business_document_version '||p_document_rec.business_document_version);
2403: END IF;
2404:
2405: -- Standard Start of API savepoint

Line 2425: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2421:
2422: -- Standard call to get message count and if count is 1, get message info.
2423: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2424:
2425: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2426: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2427: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
2428: END IF;
2429:

Line 2426: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

2422: -- Standard call to get message count and if count is 1, get message info.
2423: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2424:
2425: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2426: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2427: 'Leaving OKC_REP_CLOSEOUT_PVT.'||l_api_name);
2428: END IF;
2429:
2430: EXCEPTION

Line 2432: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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');
2436: END IF;

Line 2433: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

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');
2436: END IF;
2437:

Line 2446: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2442: p_data => x_msg_data
2443: );
2444:
2445: WHEN OTHERS THEN
2446: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2448: g_module || l_api_name,
2449: 'Leaving check_tasks_exists because of EXCEPTION: ' || sqlerrm);
2450: END IF;

Line 2447: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

2443: );
2444:
2445: WHEN OTHERS THEN
2446: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2448: g_module || l_api_name,
2449: 'Leaving check_tasks_exists because of EXCEPTION: ' || sqlerrm);
2450: END IF;
2451: Okc_Api.Set_Message(p_app_name => G_APP_NAME,