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.OKS_CHANGE_STATUS_PVT dependencies on FND_LOG

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

69: begin
70:
71: OKC_CVM_PVT.clear_g_transaction_id; /*Added for bug6418582*/
72:
73: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
74: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
75: '100: Entered UPDATE_HEADER_STATUS');
76: END IF;
77:

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

70:
71: OKC_CVM_PVT.clear_g_transaction_id; /*Added for bug6418582*/
72:
73: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
74: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
75: '100: Entered UPDATE_HEADER_STATUS');
76: END IF;
77:
78: if ((p_new_sts_code is NULL) OR (p_id is null) OR (p_canc_reason_code is NULL)) then

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

85:
86: l_new_sts_code := p_new_sts_code;
87: l_old_sts_code := p_old_sts_code;
88:
89: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
91: '110: Parameter Values ' ||
92: 'contract_id - '|| p_id ||
93: 'new_sts_code - '||l_new_sts_code ||

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

86: l_new_sts_code := p_new_sts_code;
87: l_old_sts_code := p_old_sts_code;
88:
89: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
91: '110: Parameter Values ' ||
92: 'contract_id - '|| p_id ||
93: 'new_sts_code - '||l_new_sts_code ||
94: 'old_sts_code - '||l_old_sts_code );

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

134: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
135: raise FND_API.G_EXC_UNEXPECTED_ERROR;
136: end if;
137:
138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
140: '120: Completed check_allowed_status() ');
141: END IF;
142:

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

135: raise FND_API.G_EXC_UNEXPECTED_ERROR;
136: end if;
137:
138: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
140: '120: Completed check_allowed_status() ');
141: END IF;
142:
143: l_chrv_tbl(1).id := p_id;

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

155: l_chrv_tbl(1).trn_code := NULL;
156: l_chrv_tbl(1).term_cancel_source := NULL;
157: end if;
158:
159: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
160: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
161: '130: Calling Update_Header_status with chrv_tbl populated');
162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
163: '140: l_chrv_tbl(1).id '|| l_chrv_tbl(1).id);

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

156: l_chrv_tbl(1).term_cancel_source := NULL;
157: end if;
158:
159: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
160: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
161: '130: Calling Update_Header_status with chrv_tbl populated');
162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
163: '140: l_chrv_tbl(1).id '|| l_chrv_tbl(1).id);
164: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

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

158:
159: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
160: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
161: '130: Calling Update_Header_status with chrv_tbl populated');
162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
163: '140: l_chrv_tbl(1).id '|| l_chrv_tbl(1).id);
164: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
165: '150: l_chrv_tbl(1).old_sts_code '|| l_chrv_tbl(1).old_sts_code);
166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

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

160: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
161: '130: Calling Update_Header_status with chrv_tbl populated');
162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
163: '140: l_chrv_tbl(1).id '|| l_chrv_tbl(1).id);
164: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
165: '150: l_chrv_tbl(1).old_sts_code '|| l_chrv_tbl(1).old_sts_code);
166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
167: '160: l_chrv_tbl(1).new_sts_code '|| l_chrv_tbl(1).new_sts_code);
168: END IF;

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

162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
163: '140: l_chrv_tbl(1).id '|| l_chrv_tbl(1).id);
164: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
165: '150: l_chrv_tbl(1).old_sts_code '|| l_chrv_tbl(1).old_sts_code);
166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
167: '160: l_chrv_tbl(1).new_sts_code '|| l_chrv_tbl(1).new_sts_code);
168: END IF;
169:
170: Update_header_status( x_return_status => x_return_status,

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

182: elsif (x_return_status = FND_API.G_RET_STS_ERROR) then
183: raise FND_API.G_EXC_ERROR;
184: end if;
185:
186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
188: '170: Completed Update_header_status succesfully');
189: END IF;
190:

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

183: raise FND_API.G_EXC_ERROR;
184: end if;
185:
186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
188: '170: Completed Update_header_status succesfully');
189: END IF;
190:
191: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

193: Exception
194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
199: END IF;
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
199: END IF;
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203:
204: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
206: END IF;
207:
208: WHEN OTHERS THEN

Line 205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203:
204: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
206: END IF;
207:
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

207:
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
210:
211: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
212: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
213: END IF;
214:
215: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 212: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
210:
211: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
212: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
213: END IF;
214:
215: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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

262: if (p_init_msg_list = FND_API.G_TRUE) then
263: fnd_msg_pub.initialize();
264: end if;
265:
266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
267: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
268: '400: Entere Update_Header_Status');
269: END IF;
270:

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

263: fnd_msg_pub.initialize();
264: end if;
265:
266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
267: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
268: '400: Entere Update_Header_Status');
269: END IF;
270:
271: for i in p_chrv_tbl.first .. p_chrv_tbl.last

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

281: p_chrv_tbl(i).trn_code := NULL;
282: p_chrv_tbl(i).term_cancel_source := NULL;
283: end if;
284:
285: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
286: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
287: '410: Calling validate_Status p_chrv_tbl(i).id - '||p_chrv_tbl(i).id);
288: END IF;
289:

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

282: p_chrv_tbl(i).term_cancel_source := NULL;
283: end if;
284:
285: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
286: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
287: '410: Calling validate_Status p_chrv_tbl(i).id - '||p_chrv_tbl(i).id);
288: END IF;
289:
290: if (p_validate_status = 'Y') then

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

309:
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR then
312: l_valid_flag := 'N';
313: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name, FND_MSG_PUB.Get('F', 1));
315: END IF;
316: End;
317: end if; -- p_validate_status

Line 314: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name, FND_MSG_PUB.Get('F', 1));

310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR then
312: l_valid_flag := 'N';
313: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
314: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name, FND_MSG_PUB.Get('F', 1));
315: END IF;
316: End;
317: end if; -- p_validate_status
318:

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

315: END IF;
316: End;
317: end if; -- p_validate_status
318:
319: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
321: '420: l_valid_flag - '|| l_valid_flag );
322: END IF;
323:

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

316: End;
317: end if; -- p_validate_status
318:
319: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
321: '420: l_valid_flag - '|| l_valid_flag );
322: END IF;
323:
324: if l_valid_flag = 'Y' then

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

332:
333: p_control_rec.code := p_canc_reason_code;
334: p_control_rec.comments := p_comments;
335:
336: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
338: '430: calling okc_contract_pub.update_contract_header');
339: END IF;
340:

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

333: p_control_rec.code := p_canc_reason_code;
334: p_control_rec.comments := p_comments;
335:
336: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
338: '430: calling okc_contract_pub.update_contract_header');
339: END IF;
340:
341: --bug 5710909

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

373: elsif (x_return_status = FND_API.G_RET_STS_ERROR) Then
374: RAISE FND_API.G_EXC_ERROR;
375: end if;
376:
377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
379: '440: Calling oks_change_status_pvt.update_line_status ');
380: END IF;
381:

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

374: RAISE FND_API.G_EXC_ERROR;
375: end if;
376:
377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
379: '440: Calling oks_change_status_pvt.update_line_status ');
380: END IF;
381:
382: -- cgopinee bugfix for 9259068

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

412: if (p_chrv_tbl(i).old_ste_code = 'ENTERED' and p_chrv_tbl(i).new_ste_code = 'CANCELLED') then
413:
414: -- Check if the contract is a renewed contract
415: IF (Renewed_YN(p_chrv_tbl(i).id)) then
416: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
418: '450: Calling okc_contract_pvt.clean_ren_links, Entered => Canceled ');
419: END IF;
420:

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

413:
414: -- Check if the contract is a renewed contract
415: IF (Renewed_YN(p_chrv_tbl(i).id)) then
416: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
418: '450: Calling okc_contract_pvt.clean_ren_links, Entered => Canceled ');
419: END IF;
420:
421: OKC_CONTRACT_PVT.CLEAN_REN_LINKS(p_target_chr_id => p_chrv_tbl(i).id,

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

437: open csr_k_item_key(p_chrv_tbl(i).id);
438: fetch csr_k_item_key into l_wf_item_key;
439: close csr_k_item_key;
440:
441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
443: '460: Calling oks_wf_k_process_pvt.cancel_contract
444: for l_wf_item_key - ' || l_wf_item_key);
445: END IF;

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

438: fetch csr_k_item_key into l_wf_item_key;
439: close csr_k_item_key;
440:
441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
443: '460: Calling oks_wf_k_process_pvt.cancel_contract
444: for l_wf_item_key - ' || l_wf_item_key);
445: END IF;
446:

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

469: elsif (p_chrv_tbl(i).old_ste_code = 'CANCELLED' and p_chrv_tbl(i).new_ste_code = 'ENTERED') then
470:
471: -- Check if the contract is renewed
472: IF (Renewed_YN(p_chrv_tbl(i).id)) then
473: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
475: '470: okc_contract_pvt.relink_renew, Canceled => Entered ');
476: END IF;
477: -- Reinstantiate the renewal link as the contract is getting into 'Entererd' status

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

470:
471: -- Check if the contract is renewed
472: IF (Renewed_YN(p_chrv_tbl(i).id)) then
473: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
474: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
475: '470: okc_contract_pvt.relink_renew, Canceled => Entered ');
476: END IF;
477: -- Reinstantiate the renewal link as the contract is getting into 'Entererd' status
478:

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

505: -- l_wf_attr_details.ITEM_KEY := l_chrv_tbl(i).id || to_char(sysdate, 'YYYYMMDDHH24MISS');
506:
507: -- End of Changed by MKS/SKK
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: '480: Launching workflow process ');
512: END IF;
513:

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

506:
507: -- End of Changed by MKS/SKK
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: '480: Launching workflow process ');
512: END IF;
513:
514: OKS_WF_K_PROCESS_PVT.launch_k_process_wf (

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

528: end if;
529: end if; -- l_validate_flag
530: end loop;
531:
532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
534: '485: exiting Update_header_status ');
535: END IF;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

529: end if; -- l_validate_flag
530: end loop;
531:
532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
534: '485: exiting Update_header_status ');
535: END IF;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:

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

538: EXCEPTION
539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541:
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
544: END IF;
545:
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');

539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541:
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
544: END IF;
545:
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

545:
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
551: END IF;
552:
553: WHEN OTHERS THEN

Line 550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
551: END IF;
552:
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

552:
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
555:
556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
558: END IF;
559:
560: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
555:
556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
558: END IF;
559:
560: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
561: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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

657: ------------------------------
658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
663: END IF;
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
665:

Line 662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
663: END IF;
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
670: END IF;
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
672:

Line 669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
670: END IF;
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
672:
673: WHEN OKC_API.G_EXC_WARNING THEN

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

671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
672:
673: WHEN OKC_API.G_EXC_WARNING THEN
674: x_return_status := OKC_API.G_RET_STS_WARNING;
675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'320: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
677: END IF;
678:
679: WHEN OTHERS THEN

Line 676: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'320: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');

672:
673: WHEN OKC_API.G_EXC_WARNING THEN
674: x_return_status := OKC_API.G_RET_STS_WARNING;
675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'320: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
677: END IF;
678:
679: WHEN OTHERS THEN
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

676: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'320: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
677: END IF;
678:
679: WHEN OTHERS THEN
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'330: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
682: END IF;
683:
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'330: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

677: END IF;
678:
679: WHEN OTHERS THEN
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'330: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
682: END IF;
683:
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

1231: END;
1232:
1233: Begin
1234:
1235: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1237: '600: Entered UPDATE_LINE_STATUS');
1238: END IF;
1239:

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

1232:
1233: Begin
1234:
1235: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1237: '600: Entered UPDATE_LINE_STATUS');
1238: END IF;
1239:
1240: if (p_init_msg_list = FND_API.G_TRUE) then

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

1256: OPEN c_top_line_chk;
1257: FETCH c_top_line_chk INTO l_top_line;
1258: CLOSE c_top_line_chk;
1259:
1260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1261: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1262: '610: value of l_type - '|| l_type );
1263: END IF;
1264:

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

1257: FETCH c_top_line_chk INTO l_top_line;
1258: CLOSE c_top_line_chk;
1259:
1260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1261: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1262: '610: value of l_type - '|| l_type );
1263: END IF;
1264:
1265: If (l_type='ACTIVE') then

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

1276:
1277:
1278: if (p_cle_id is null) then
1279:
1280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1282: '620: p_cle_id is null');
1283: END IF;
1284: -- Added the following IF ELSE condition and modified the cursor for bug # 6144856 --

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

1277:
1278: if (p_cle_id is null) then
1279:
1280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1282: '620: p_cle_id is null');
1283: END IF;
1284: -- Added the following IF ELSE condition and modified the cursor for bug # 6144856 --
1285: IF ( l_type='HOLD' or l_type='CANCELLED') THEN

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

1314: -- end of bug# 6144856 --
1315:
1316: else --No need of checking the status here as we know this action is possible only for 'Entered' or 'Cancelled' lines
1317:
1318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1320: '630: p_cle_id is NOT null - '||p_cle_id );
1321: END IF;
1322:

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

1315:
1316: else --No need of checking the status here as we know this action is possible only for 'Entered' or 'Cancelled' lines
1317:
1318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1320: '630: p_cle_id is NOT null - '||p_cle_id );
1321: END IF;
1322:
1323: -- Added the following IF ELSE condition and modified the cursor for bug # 6144856 --

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

1392: END IF;
1393:
1394: if((p_validate_status = 'Y') and (p_cle_id IS NOT NULL)) then
1395:
1396: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1398: '640: Calling validate_status ' || l_clev_tbl(x_num).id);
1399: END IF;
1400:

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

1393:
1394: if((p_validate_status = 'Y') and (p_cle_id IS NOT NULL)) then
1395:
1396: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1398: '640: Calling validate_status ' || l_clev_tbl(x_num).id);
1399: END IF;
1400:
1401: VALIDATE_STATUS( x_return_status,

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

1417: Raise OKC_API.G_EXC_WARNING;
1418: end if;
1419: end if; -- l_clev_tbl(x_num).lse_id
1420:
1421: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1422: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1423: '640: Completed validate_status ' || l_clev_tbl(x_num).id);
1424: END IF;
1425:

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

1418: end if;
1419: end if; -- l_clev_tbl(x_num).lse_id
1420:
1421: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1422: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1423: '640: Completed validate_status ' || l_clev_tbl(x_num).id);
1424: END IF;
1425:
1426: l_clev_tbl(x_num).new_ste_code := p_new_ste_code ;

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

1450:
1451: END LOOP;
1452: close c_lines;
1453:
1454: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1456: '650: Calling OKC_CONTRACT_PUB.update_contract_line ');
1457: END IF;
1458:

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

1451: END LOOP;
1452: close c_lines;
1453:
1454: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1456: '650: Calling OKC_CONTRACT_PUB.update_contract_line ');
1457: END IF;
1458:
1459: --bug 5710909

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

1490: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1491: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: End if;
1493:
1494: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1495: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1496: '660: Succesfully completed OKC_CONTRACT_PUB.update_contract_line ');
1497: END IF;
1498:

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

1491: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1492: End if;
1493:
1494: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1495: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1496: '660: Succesfully completed OKC_CONTRACT_PUB.update_contract_line ');
1497: END IF;
1498:
1499: -- Calling the API to Clean OR Relink the Contract Line if it was

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

1500: -- a renewed contract.
1501:
1502: if(p_old_ste_code = 'ENTERED' and p_new_ste_code = 'CANCELLED') then
1503:
1504: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1505: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1506: '670: calling okc_contract_pvt.Line_renewal_links, ENTERED => CANCELLED ');
1507: END IF;
1508:

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

1501:
1502: if(p_old_ste_code = 'ENTERED' and p_new_ste_code = 'CANCELLED') then
1503:
1504: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1505: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1506: '670: calling okc_contract_pvt.Line_renewal_links, ENTERED => CANCELLED ');
1507: END IF;
1508:
1509: OKC_CONTRACT_PVT.Line_Renewal_links (

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

1522: End if;
1523:
1524: elsif (p_old_ste_code = 'CANCELLED' and p_new_ste_code = 'ENTERED') then
1525:
1526: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1527: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1528: '680: calling okc_contract_pvt.Line_renewal_links, CANCELLED => ENTERED ');
1529: END IF;
1530:

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

1523:
1524: elsif (p_old_ste_code = 'CANCELLED' and p_new_ste_code = 'ENTERED') then
1525:
1526: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1527: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1528: '680: calling okc_contract_pvt.Line_renewal_links, CANCELLED => ENTERED ');
1529: END IF;
1530:
1531: OKC_CONTRACT_PVT.Line_Renewal_links (

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

1558:
1559: IF (l_scs_code IN ('SERVICE', 'SUBSCRIPTION', 'WARRANTY') ) THEN
1560:
1561: if (p_cle_id is NOT NULL) then
1562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1564: '690: calling okc_contract_pvt.update_contract_amount, p_cle_id is not null '||p_cle_id);
1565: END IF;
1566:

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

1559: IF (l_scs_code IN ('SERVICE', 'SUBSCRIPTION', 'WARRANTY') ) THEN
1560:
1561: if (p_cle_id is NOT NULL) then
1562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1564: '690: calling okc_contract_pvt.update_contract_amount, p_cle_id is not null '||p_cle_id);
1565: END IF;
1566:
1567: OKC_CONTRACT_PVT.Update_contract_amount(

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

1581: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
1582: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1583: End if;
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: '695: calling update_contract_tax_amount, p_cle_id is not null '||p_cle_id);
1588: END IF;
1589:

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

1582: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1583: End if;
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: '695: calling update_contract_tax_amount, p_cle_id is not null '||p_cle_id);
1588: END IF;
1589:
1590: UPDATE_CONTRACT_TAX_AMOUNT(

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

1606: End if;
1607:
1608: else
1609:
1610: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1612: '700: calling okc_contract_pvt.update_contract_amount, p_cle_id is null ');
1613: END IF;
1614:

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

1607:
1608: else
1609:
1610: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1612: '700: calling okc_contract_pvt.update_contract_amount, p_cle_id is null ');
1613: END IF;
1614:
1615: OKC_CONTRACT_PVT.Update_contract_amount(

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

1629: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1630: End if;
1631:
1632:
1633: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1634: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1635: '705: calling update_contract_tax_amount, p_cle_id is null');
1636: END IF;
1637:

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

1630: End if;
1631:
1632:
1633: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1634: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1635: '705: calling update_contract_tax_amount, p_cle_id is null');
1636: END IF;
1637:
1638: UPDATE_CONTRACT_TAX_AMOUNT (

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

1660: -- is taken on the subline.
1661:
1662: if (p_cle_id is NOT NULL) then
1663:
1664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1666: '710: calling oks_bill_sch.sts_change_subline_lvl_rule');
1667: END IF;
1668:

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

1661:
1662: if (p_cle_id is NOT NULL) then
1663:
1664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1666: '710: calling oks_bill_sch.sts_change_subline_lvl_rule');
1667: END IF;
1668:
1669: OKS_BILL_SCH.Sts_change_subline_lvl_rule(

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

1714: close version_csr;
1715:
1716: l_hstv_rec.contract_version := l_version;
1717:
1718: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1719: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1720: '720: calling okc_k_history_pvt.create_k_history, l_version - '||l_version);
1721: END IF;
1722:

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

1715:
1716: l_hstv_rec.contract_version := l_version;
1717:
1718: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1719: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1720: '720: calling okc_k_history_pvt.create_k_history, l_version - '||l_version);
1721: END IF;
1722:
1723: OKC_K_HISTORY_PVT.create_k_history(

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

1737: end if; -- call history API
1738:
1739: x_return_status := FND_API.G_RET_STS_SUCCESS;
1740:
1741: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1743: '730: succesfully complete update_line_status ');
1744: END IF;
1745:

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

1738:
1739: x_return_status := FND_API.G_RET_STS_SUCCESS;
1740:
1741: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1742: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1743: '730: succesfully complete update_line_status ');
1744: END IF;
1745:
1746: EXCEPTION

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

1745:
1746: EXCEPTION
1747: WHEN FND_API.G_EXC_ERROR THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1751: END IF;
1752: if (c_lines%ISOPEN) then
1753: close c_lines;

Line 1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

1746: EXCEPTION
1747: WHEN FND_API.G_EXC_ERROR THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1751: END IF;
1752: if (c_lines%ISOPEN) then
1753: close c_lines;
1754: end if;

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

1755:
1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1760: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
1761: END IF;
1762:
1763: if (c_lines%ISOPEN) then

Line 1760: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1760: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
1761: END IF;
1762:
1763: if (c_lines%ISOPEN) then
1764: close c_lines;

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

1766:
1767: WHEN OKC_API.G_EXC_WARNING then
1768: x_return_status := OKC_API.G_RET_STS_WARNING;
1769:
1770: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'760: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
1772: END IF;
1773:
1774: if(c_lines%ISOPEN) then

Line 1771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'760: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');

1767: WHEN OKC_API.G_EXC_WARNING then
1768: x_return_status := OKC_API.G_RET_STS_WARNING;
1769:
1770: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'760: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
1772: END IF;
1773:
1774: if(c_lines%ISOPEN) then
1775: close c_lines;

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

1775: close c_lines;
1776: end if;
1777:
1778: WHEN OTHERS THEN
1779: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'770: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1781: END IF;
1782:
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'770: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

1776: end if;
1777:
1778: WHEN OTHERS THEN
1779: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'770: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1781: END IF;
1782:
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1784: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

1916: exception
1917:
1918: WHEN FND_API.G_EXC_ERROR then
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1922: END IF;
1923:
1924: WHEN NO_DATA_FOUND then

Line 1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

1917:
1918: WHEN FND_API.G_EXC_ERROR then
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1922: END IF;
1923:
1924: WHEN NO_DATA_FOUND then
1925: x_return_status := FND_API.G_RET_STS_ERROR;

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

1925: x_return_status := FND_API.G_RET_STS_ERROR;
1926: FND_MESSAGE.set_name('OKS','OKS_CHANGE_STAT_NOT_ALLOWED'); -- set the message here
1927: fnd_msg_pub.add;
1928:
1929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1930: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT : NO_DATA_FOUND');
1931: END IF;
1932:
1933: WHEN OTHERS then

Line 1930: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT : NO_DATA_FOUND');

1926: FND_MESSAGE.set_name('OKS','OKS_CHANGE_STAT_NOT_ALLOWED'); -- set the message here
1927: fnd_msg_pub.add;
1928:
1929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1930: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT : NO_DATA_FOUND');
1931: END IF;
1932:
1933: WHEN OTHERS then
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1931: END IF;
1932:
1933: WHEN OTHERS then
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1936: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'520: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1937: END IF;
1938:
1939: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1936: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'520: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

1932:
1933: WHEN OTHERS then
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1936: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'520: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1937: END IF;
1938:
1939: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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

2058:
2059:
2060: BEGIN
2061:
2062: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2063: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2064: '800: Entered UPDATE_CONTRACT_TAX_AMOUNT ');
2065: END IF;
2066:

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

2059:
2060: BEGIN
2061:
2062: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2063: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2064: '800: Entered UPDATE_CONTRACT_TAX_AMOUNT ');
2065: END IF;
2066:
2067: IF ((p_from_ste_code is NULL) OR (p_to_ste_code is NULL) OR (p_id is null)) THEN

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

2067: IF ((p_from_ste_code is NULL) OR (p_to_ste_code is NULL) OR (p_id is null)) THEN
2068: raise FND_API.G_EXC_ERROR;
2069: END IF;
2070:
2071: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2073: '810: Parameter Values ' ||
2074: 'p_id - '|| p_id ||
2075: 'p_from_ste_code - '||p_from_ste_code ||

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

2068: raise FND_API.G_EXC_ERROR;
2069: END IF;
2070:
2071: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2073: '810: Parameter Values ' ||
2074: 'p_id - '|| p_id ||
2075: 'p_from_ste_code - '||p_from_ste_code ||
2076: 'p_to_ste_code - '||p_to_ste_code ||

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

2078: END IF;
2079:
2080: IF (p_cle_id is NOT NULL) THEN -- implies line or sub-line level
2081:
2082: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2083: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2084: '900: p_cle_id is not null; Change Status called from line/subline level ');
2085: END IF;
2086:

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

2079:
2080: IF (p_cle_id is NOT NULL) THEN -- implies line or sub-line level
2081:
2082: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2083: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2084: '900: p_cle_id is not null; Change Status called from line/subline level ');
2085: END IF;
2086:
2087: Open get_line_lvl_csr;

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

2089: Close get_line_lvl_csr;
2090:
2091: IF (l_cle_id is NOT NULL) THEN --p_cle_id is a subline
2092:
2093: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2095: '910: Updating tax_amount of topline of the subline due to status change of the subline ');
2096: END IF;
2097:

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

2090:
2091: IF (l_cle_id is NOT NULL) THEN --p_cle_id is a subline
2092:
2093: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2095: '910: Updating tax_amount of topline of the subline due to status change of the subline ');
2096: END IF;
2097:
2098: Open get_subline_tax_amt_csr(p_cle_id);

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

2100: Close get_subline_tax_amt_csr;
2101:
2102: IF ((p_from_ste_code = 'ENTERED' ) AND (p_to_ste_code = 'CANCELLED')) THEN
2103:
2104: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2106: '920: ENTERED -> CANCELLED; Updating tax_amount of the topline of the subline ');
2107: END IF;
2108:

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

2101:
2102: IF ((p_from_ste_code = 'ENTERED' ) AND (p_to_ste_code = 'CANCELLED')) THEN
2103:
2104: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2106: '920: ENTERED -> CANCELLED; Updating tax_amount of the topline of the subline ');
2107: END IF;
2108:
2109: -- updating tax_amount for the topline (l_cle_id) of this subline (p_cle_id)

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

2121: --Bug:6765336
2122:
2123: ELSIF ((p_from_ste_code = 'CANCELLED' ) AND (p_to_ste_code = 'ENTERED')) THEN
2124:
2125: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2127: '930: CANCELLED -> ENTERED; Updating tax_amount of the topline of the subline ');
2128: END IF;
2129: /*Added for bug:8775250*/

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

2122:
2123: ELSIF ((p_from_ste_code = 'CANCELLED' ) AND (p_to_ste_code = 'ENTERED')) THEN
2124:
2125: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2126: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2127: '930: CANCELLED -> ENTERED; Updating tax_amount of the topline of the subline ');
2128: END IF;
2129: /*Added for bug:8775250*/
2130: g_cle_id :=p_cle_id;

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

2157:
2158: ELSE --l_cle_id is NULL --p_cle_id is a top line
2159:
2160:
2161: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2163: '1000: Updating tax_amount of the topline');
2164: END IF;
2165:

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

2158: ELSE --l_cle_id is NULL --p_cle_id is a top line
2159:
2160:
2161: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2163: '1000: Updating tax_amount of the topline');
2164: END IF;
2165:
2166: IF ((p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')) THEN

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

2164: END IF;
2165:
2166: IF ((p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')) THEN
2167:
2168: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2170: '1010: ENTERED -> CANCELLED; Updating tax_amount of topline ');
2171: END IF;
2172:

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

2165:
2166: IF ((p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')) THEN
2167:
2168: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2170: '1010: ENTERED -> CANCELLED; Updating tax_amount of topline ');
2171: END IF;
2172:
2173: -- updating tax_amount for the topline (p_cle_id)

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

2195: Close get_lse_id_csr;
2196:
2197: IF (l_lse_id = 46 ) THEN --Checking if top line is of SUBSCRIPTION type
2198:
2199: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2200: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2201: '1020: Calling FUNCTION get_tax_for_subs_line: Contract ID ' || p_id || ' Topline ID '|| p_cle_id);
2202: END IF;
2203:

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

2196:
2197: IF (l_lse_id = 46 ) THEN --Checking if top line is of SUBSCRIPTION type
2198:
2199: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2200: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2201: '1020: Calling FUNCTION get_tax_for_subs_line: Contract ID ' || p_id || ' Topline ID '|| p_cle_id);
2202: END IF;
2203:
2204: -- Calling function get_tax_for_subs_line to get tax_amount of this subscription line

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

2204: -- Calling function get_tax_for_subs_line to get tax_amount of this subscription line
2205:
2206: l_Tax_Value := get_tax_for_subs_line (p_id, p_cle_id);
2207:
2208: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2209: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2210: '1030: Successfully called FUNCTION get_tax_for_subs_line ');
2211: END IF;
2212:

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

2205:
2206: l_Tax_Value := get_tax_for_subs_line (p_id, p_cle_id);
2207:
2208: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2209: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2210: '1030: Successfully called FUNCTION get_tax_for_subs_line ');
2211: END IF;
2212:
2213:

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

2210: '1030: Successfully called FUNCTION get_tax_for_subs_line ');
2211: END IF;
2212:
2213:
2214: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2215: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2216: '1040: CANCELLED -> ENTERED; Updating tax_amount for SUBSCRIPTION topline ');
2217: END IF;
2218:

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

2211: END IF;
2212:
2213:
2214: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2215: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2216: '1040: CANCELLED -> ENTERED; Updating tax_amount for SUBSCRIPTION topline ');
2217: END IF;
2218:
2219: -- updating tax_amount for top line for SUBSCRIPTION line type due to change in the status of top line

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

2225:
2226:
2227: ELSE -- top line is not of SUBSCRIPTION type
2228:
2229: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2230: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2231: '1050: CANCELLED -> ENTERED; Updating tax_amount for NON-SUBSCRIPTION topline ');
2232: END IF;
2233:

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

2226:
2227: ELSE -- top line is not of SUBSCRIPTION type
2228:
2229: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2230: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2231: '1050: CANCELLED -> ENTERED; Updating tax_amount for NON-SUBSCRIPTION topline ');
2232: END IF;
2233:
2234: FOR get_subline_csr_rec IN get_subline_csr(p_cle_id)

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

2277: END IF; -- l_cle_id is NOT NULL
2278:
2279: ELSE -- p_cle_id is NULL --implies Change Status action is taken at header Level
2280:
2281: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2282: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2283: '1100: Updating Header ');
2284: END IF;
2285:

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

2278:
2279: ELSE -- p_cle_id is NULL --implies Change Status action is taken at header Level
2280:
2281: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2282: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2283: '1100: Updating Header ');
2284: END IF;
2285:
2286: IF ((p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')) THEN

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

2284: END IF;
2285:
2286: IF ((p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')) THEN
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: '1110: ENTERED -> CANCELLED; Updating tax_amount for all toplines of contract ');
2291: END IF;
2292:

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

2285:
2286: IF ((p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')) THEN
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: '1110: ENTERED -> CANCELLED; Updating tax_amount for all toplines of contract ');
2291: END IF;
2292:
2293: FOR get_lines_id_rec IN get_lines_id(p_id)

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

2314: );
2315:
2316: ELSIF ((p_from_ste_code = 'CANCELLED' ) AND (p_to_ste_code = 'ENTERED')) THEN
2317:
2318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2320: '1120: CANCELLED -> ENTERED; Updating tax_amount for all toplines of contract ');
2321: END IF;
2322:

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

2315:
2316: ELSIF ((p_from_ste_code = 'CANCELLED' ) AND (p_to_ste_code = 'ENTERED')) THEN
2317:
2318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2320: '1120: CANCELLED -> ENTERED; Updating tax_amount for all toplines of contract ');
2321: END IF;
2322:
2323: FOR get_lines_id_rec IN get_lines_id(p_id)

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

2367: and okc1.dnz_chr_id = p_id
2368: and okc1.date_cancelled IS NULL -- Bug 5474479.
2369: );
2370:
2371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2372: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2373: '1130: Calling UPDATE_SUBSCRIPTION_TAX_AMOUNT ' || p_id);
2374: END IF;
2375:

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

2368: and okc1.date_cancelled IS NULL -- Bug 5474479.
2369: );
2370:
2371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2372: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2373: '1130: Calling UPDATE_SUBSCRIPTION_TAX_AMOUNT ' || p_id);
2374: END IF;
2375:
2376: --Calling procudure to update tax_amount for subscription line type of the contract, if any

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

2388: elsif (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2389: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2390: End if;
2391:
2392: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2393: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2394: '1140: Succesfully completed UPDATE_SUBSCRIPTION_TAX_AMOUNT ');
2395: END IF;
2396:

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

2389: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2390: End if;
2391:
2392: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2393: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2394: '1140: Succesfully completed UPDATE_SUBSCRIPTION_TAX_AMOUNT ');
2395: END IF;
2396:
2397: END IF; --(p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')

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

2397: END IF; --(p_from_ste_code = 'ENTERED') AND (p_to_ste_code = 'CANCELLED')
2398:
2399: END IF; --p_cle_id is NULL
2400:
2401: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2403: '1200: Updating header tax_amount ');
2404: END IF;
2405:

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

2398:
2399: END IF; --p_cle_id is NULL
2400:
2401: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2402: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2403: '1200: Updating header tax_amount ');
2404: END IF;
2405:
2406: -- updating tax_amount for header level of the contract due to change in the status of line/subline/contract

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

2422:
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2428: END IF;
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2428: END IF;
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432:
2433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2435: END IF;
2436:
2437: WHEN OTHERS THEN

Line 2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432:
2433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2434: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2435: END IF;
2436:
2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2436:
2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2439:
2440: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1320: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2442: END IF;
2443:
2444: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 2441: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1320: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2439:
2440: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1320: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2442: END IF;
2443:
2444: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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

2477: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SUBSCRIPTION_TAX_AMOUNT';
2478: --
2479: BEGIN
2480:
2481: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2482: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2483: '1150: Entered UPDATE_SUBSCRIPTION_TAX_AMOUNT ');
2484: END IF;
2485:

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

2478: --
2479: BEGIN
2480:
2481: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2482: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2483: '1150: Entered UPDATE_SUBSCRIPTION_TAX_AMOUNT ');
2484: END IF;
2485:
2486: Open get_K_subscription_lines;

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

2499: FOR i IN l_id_Tbl.FIRST .. l_id_Tbl.LAST
2500:
2501: LOOP
2502:
2503: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2504: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2505: '1155: Callling procedure get_tax_for_subs_line for topline '|| l_id_Tbl(i));
2506: END IF;
2507:

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

2500:
2501: LOOP
2502:
2503: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2504: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2505: '1155: Callling procedure get_tax_for_subs_line for topline '|| l_id_Tbl(i));
2506: END IF;
2507:
2508: l_subs_tax_Tbl(i) := get_tax_for_subs_line (p_id, l_id_Tbl(i));

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

2519:
2520: --
2521: IF (l_id_Tbl.COUNT > 0) THEN
2522:
2523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2524: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2525: '1160: Trying to bulk updat tax_amount of toplines of type subscription of contract '|| p_id);
2526: END IF;
2527:

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

2520: --
2521: IF (l_id_Tbl.COUNT > 0) THEN
2522:
2523: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2524: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2525: '1160: Trying to bulk updat tax_amount of toplines of type subscription of contract '|| p_id);
2526: END IF;
2527:
2528: FORALL I IN l_id_Tbl.FIRST .. l_id_Tbl.LAST

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

2533: and cle_id = l_id_Tbl(I);
2534:
2535: END IF;
2536:
2537: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2538: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2539: '1165: Successfully bulk updated tax_amount of toplines of type subscription of contract '|| p_id);
2540: END IF;
2541:

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

2534:
2535: END IF;
2536:
2537: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2538: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2539: '1165: Successfully bulk updated tax_amount of toplines of type subscription of contract '|| p_id);
2540: END IF;
2541:
2542: ---

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

2548:
2549: WHEN FND_API.G_EXC_ERROR THEN
2550: x_return_status := FND_API.G_RET_STS_ERROR;
2551:
2552: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2554: END IF;
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

2549: WHEN FND_API.G_EXC_ERROR THEN
2550: x_return_status := FND_API.G_RET_STS_ERROR;
2551:
2552: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2554: END IF;
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2561: END IF;
2562:
2563: WHEN OTHERS THEN

Line 2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2561: END IF;
2562:
2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2562:
2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2565:
2566: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1190: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2568: END IF;
2569:
2570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 2567: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1190: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2565:
2566: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1190: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2568: END IF;
2569:
2570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );