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_MSG_PUB

Line 83: fnd_msg_pub.initialize();

79: raise FND_API.G_EXC_ERROR;
80: end if;
81:
82: if (p_init_msg_list = FND_API.G_TRUE) then
83: fnd_msg_pub.initialize();
84: end if;
85:
86: l_new_sts_code := p_new_sts_code;
87: l_old_sts_code := p_old_sts_code;

Line 215: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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 );
217: END IF;
218: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
219: end;

Line 216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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 );
217: END IF;
218: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
219: end;
220:

Line 218: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 );
217: END IF;
218: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
219: end;
220:
221: /*
222: ** This procedure accepts multiple contracts for status change.

Line 263: fnd_msg_pub.initialize();

259: begin
260: p_count := p_chrv_tbl.count;
261:
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,

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 560: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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 );
562: END IF;
563: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
564: end;

Line 561: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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 );
562: END IF;
563: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
564: end;
565:

Line 563: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 );
562: END IF;
563: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
564: end;
565:
566:
567: PROCEDURE populate_table(x_chrv_tbl in out NOCOPY chrv_tbl_type, i in number) IS

Line 626: fnd_msg_pub.add;

622: If Is_Entered(l_chr_id, p_cle_id) then
623: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_1');
624: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));
625: fnd_message.set_token('RENEW_K',get_target_list(l_chr_id, p_cle_id));
626: fnd_msg_pub.add;
627: Raise FND_API.G_EXC_ERROR;
628: Elsif Is_Not_Entered_Cancelled(l_chr_id, p_cle_id) then
629: l_validate := 'N';
630: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_2');

Line 633: fnd_msg_pub.add;

629: l_validate := 'N';
630: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_2');
631: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));
632: fnd_message.set_token('RENEW_K',get_target_list(l_chr_id, p_cle_id));
633: fnd_msg_pub.add;
634: Raise FND_API.G_EXC_ERROR;
635: Else
636: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_3');
637: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));

Line 638: fnd_msg_pub.add;

634: Raise FND_API.G_EXC_ERROR;
635: Else
636: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_3');
637: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id, p_cle_id));
638: fnd_msg_pub.add;
639: Raise OKC_API.G_EXC_WARNING;
640: End If; -- Is_entered
641: -- Even if any other target contract does not exist, the contract is still being resurrected
642: Else -- target_exists

Line 645: fnd_msg_pub.add;

641: -- Even if any other target contract does not exist, the contract is still being resurrected
642: Else -- target_exists
643: fnd_message.set_name('OKC', 'OKC_CONT_CAN_ENT_3');
644: fnd_message.set_token('PARENT_K',get_source_list(l_chr_id,p_cle_id));
645: fnd_msg_pub.add;
646: Raise OKC_API.G_EXC_WARNING;
647: End If; -- target_exists
648: End If; -- p_cancelled to entered
649: END IF; -- Renewed_YN

Line 664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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
674: x_return_status := OKC_API.G_RET_STS_WARNING;
675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 685: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) 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
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );
687: END IF;
688:
689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, 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
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );
687: END IF;
688:
689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
690: end;

Line 689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

685: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );
687: END IF;
688:
689: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
690: end;
691:
692: function RENEWED_YN(p_id in number) return boolean is
693: l_chr_id number := p_id;

Line 1241: fnd_msg_pub.initialize();

1237: '600: Entered UPDATE_LINE_STATUS');
1238: END IF;
1239:
1240: if (p_init_msg_list = FND_API.G_TRUE) then
1241: fnd_msg_pub.initialize();
1242: end if;
1243:
1244: if (p_count = 0) then
1245: p_count := 1;

Line 1784: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) 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
1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1786: END IF;
1787: if (c_lines%ISOPEN) then
1788: close c_lines;

Line 1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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
1785: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1786: END IF;
1787: if (c_lines%ISOPEN) then
1788: close c_lines;
1789: end if;

Line 1790: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1786: END IF;
1787: if (c_lines%ISOPEN) then
1788: close c_lines;
1789: end if;
1790: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1791: end;
1792:
1793: procedure check_allowed_status( x_return_status OUT NOCOPY VARCHAR2,
1794: x_msg_count OUT NOCOPY NUMBER,

Line 1863: fnd_msg_pub.add();

1859:
1860: /* skuchima bug12418261 */
1861: If ( p_old_ste_code = 'EXPIRED' AND l_new_ste_code <> 'EXPIRED' ) then
1862: fnd_message.set_name('OKS','OKS_CHANGE_STAT_NOT_ALLOWED'); -- Add a message name here and throw a exception
1863: fnd_msg_pub.add();
1864: raise FND_API.G_EXC_ERROR;
1865: end if;
1866:
1867: select 'Y' INTO l_allowed_status from dual where (l_new_sts_code,l_new_ste_code) in

Line 1927: fnd_msg_pub.add;

1923:
1924: WHEN NO_DATA_FOUND 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;

Line 1939: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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 );
1941: END IF;
1942:
1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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 );
1941: END IF;
1942:
1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1944:

Line 1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 );
1941: END IF;
1942:
1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1944:
1945: end check_allowed_status;
1946:
1947:

Line 2444: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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 );
2446: END IF;
2447:
2448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 2445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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 );
2446: END IF;
2447:
2448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2449:

Line 2448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 );
2446: END IF;
2447:
2448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2449:
2450: END UPDATE_CONTRACT_TAX_AMOUNT;
2451:
2452:

Line 2570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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 );
2572: END IF;
2573:
2574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 2571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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 );
2572: END IF;
2573:
2574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2575:

Line 2574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 );
2572: END IF;
2573:
2574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2575:
2576:
2577: END UPDATE_SUBSCRIPTION_TAX_AMOUNT;
2578: ---