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.

[Home] [Help]

APPS.OKC_REPORT_PVT dependencies on FND_MESSAGE

Line 165: fnd_message.clear;

161: begin
162: open profile_option_csr(p_prof_name);
163: fetch profile_option_csr into l_token;
164: close profile_option_csr;
165: fnd_message.clear;
166: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_PROFILE_CHECK');
167: fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>'"'||l_token||'"');
168: return fnd_message.get;
169: end;

Line 166: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_PROFILE_CHECK');

162: open profile_option_csr(p_prof_name);
163: fetch profile_option_csr into l_token;
164: close profile_option_csr;
165: fnd_message.clear;
166: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_PROFILE_CHECK');
167: fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>'"'||l_token||'"');
168: return fnd_message.get;
169: end;
170:

Line 167: fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>'"'||l_token||'"');

163: fetch profile_option_csr into l_token;
164: close profile_option_csr;
165: fnd_message.clear;
166: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_PROFILE_CHECK');
167: fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>'"'||l_token||'"');
168: return fnd_message.get;
169: end;
170:
171: --

Line 168: return fnd_message.get;

164: close profile_option_csr;
165: fnd_message.clear;
166: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_PROFILE_CHECK');
167: fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>'"'||l_token||'"');
168: return fnd_message.get;
169: end;
170:
171: --
172: -- PROCEDURE/Function

Line 311: fnd_message.clear;

307: is
308: l_message varchar2(2000);
309: l_token varchar2(240);
310: begin
311: fnd_message.clear;
312: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_NOT_CACHED_TRANSF');
313: fnd_message.set_token(TOKEN=>'METHOD',VALUE=>'"'||p_proc_name||'"');
314: return fnd_message.get;
315: end;

Line 312: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_NOT_CACHED_TRANSF');

308: l_message varchar2(2000);
309: l_token varchar2(240);
310: begin
311: fnd_message.clear;
312: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_NOT_CACHED_TRANSF');
313: fnd_message.set_token(TOKEN=>'METHOD',VALUE=>'"'||p_proc_name||'"');
314: return fnd_message.get;
315: end;
316:

Line 313: fnd_message.set_token(TOKEN=>'METHOD',VALUE=>'"'||p_proc_name||'"');

309: l_token varchar2(240);
310: begin
311: fnd_message.clear;
312: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_NOT_CACHED_TRANSF');
313: fnd_message.set_token(TOKEN=>'METHOD',VALUE=>'"'||p_proc_name||'"');
314: return fnd_message.get;
315: end;
316:
317: --

Line 314: return fnd_message.get;

310: begin
311: fnd_message.clear;
312: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_NOT_CACHED_TRANSF');
313: fnd_message.set_token(TOKEN=>'METHOD',VALUE=>'"'||p_proc_name||'"');
314: return fnd_message.get;
315: end;
316:
317: --
318: -- PROCEDURE/Function

Line 330: fnd_message.clear;

326: is
327: l_message varchar2(2000);
328: l_token varchar2(240);
329: begin
330: fnd_message.clear;
331: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_CACHE_LOCKED');
332: fnd_message.set_token(TOKEN=>'CACHE_TYPE',VALUE=>'"'||p_cache||'"');
333: return fnd_message.get;
334: end;

Line 331: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_CACHE_LOCKED');

327: l_message varchar2(2000);
328: l_token varchar2(240);
329: begin
330: fnd_message.clear;
331: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_CACHE_LOCKED');
332: fnd_message.set_token(TOKEN=>'CACHE_TYPE',VALUE=>'"'||p_cache||'"');
333: return fnd_message.get;
334: end;
335:

Line 332: fnd_message.set_token(TOKEN=>'CACHE_TYPE',VALUE=>'"'||p_cache||'"');

328: l_token varchar2(240);
329: begin
330: fnd_message.clear;
331: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_CACHE_LOCKED');
332: fnd_message.set_token(TOKEN=>'CACHE_TYPE',VALUE=>'"'||p_cache||'"');
333: return fnd_message.get;
334: end;
335:
336: --

Line 333: return fnd_message.get;

329: begin
330: fnd_message.clear;
331: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_CACHE_LOCKED');
332: fnd_message.set_token(TOKEN=>'CACHE_TYPE',VALUE=>'"'||p_cache||'"');
333: return fnd_message.get;
334: end;
335:
336: --
337: -- PROCEDURE/Function

Line 782: fnd_message.clear;

778: function failed_lock return varchar2
779: is
780: l_message varchar2(2000);
781: begin
782: fnd_message.clear;
783: fnd_message.set_name(APPLICATION=>OKC_API.G_FND_APP,NAME=>OKC_API.G_FORM_UNABLE_TO_RESERVE_REC);
784: return fnd_message.get;
785: end;
786:

Line 783: fnd_message.set_name(APPLICATION=>OKC_API.G_FND_APP,NAME=>OKC_API.G_FORM_UNABLE_TO_RESERVE_REC);

779: is
780: l_message varchar2(2000);
781: begin
782: fnd_message.clear;
783: fnd_message.set_name(APPLICATION=>OKC_API.G_FND_APP,NAME=>OKC_API.G_FORM_UNABLE_TO_RESERVE_REC);
784: return fnd_message.get;
785: end;
786:
787: --

Line 784: return fnd_message.get;

780: l_message varchar2(2000);
781: begin
782: fnd_message.clear;
783: fnd_message.set_name(APPLICATION=>OKC_API.G_FND_APP,NAME=>OKC_API.G_FORM_UNABLE_TO_RESERVE_REC);
784: return fnd_message.get;
785: end;
786:
787: --
788: -- PROCEDURE/Function

Line 798: fnd_message.clear;

794: function failed_session return varchar2
795: is
796: l_message varchar2(2000);
797: begin
798: fnd_message.clear;
799: fnd_message.set_name(APPLICATION=>'FND',NAME=>'FND_SESSION_FAILED');
800: return fnd_message.get;
801: end;
802:

Line 799: fnd_message.set_name(APPLICATION=>'FND',NAME=>'FND_SESSION_FAILED');

795: is
796: l_message varchar2(2000);
797: begin
798: fnd_message.clear;
799: fnd_message.set_name(APPLICATION=>'FND',NAME=>'FND_SESSION_FAILED');
800: return fnd_message.get;
801: end;
802:
803: --

Line 800: return fnd_message.get;

796: l_message varchar2(2000);
797: begin
798: fnd_message.clear;
799: fnd_message.set_name(APPLICATION=>'FND',NAME=>'FND_SESSION_FAILED');
800: return fnd_message.get;
801: end;
802:
803: --
804: -- PROCEDURE/Function

Line 1179: fnd_message.clear;

1175: in 0;
1176: end if;
1177: exception
1178: when OTHERS then
1179: fnd_message.clear;
1180: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1181: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1182: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1183: x_return_status := 'U';

Line 1180: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');

1176: end if;
1177: exception
1178: when OTHERS then
1179: fnd_message.clear;
1180: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1181: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1182: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1183: x_return_status := 'U';
1184: x_msg_count := 1;

Line 1181: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);

1177: exception
1178: when OTHERS then
1179: fnd_message.clear;
1180: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1181: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1182: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1183: x_return_status := 'U';
1184: x_msg_count := 1;
1185: x_msg_data := fnd_message.get;

Line 1182: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);

1178: when OTHERS then
1179: fnd_message.clear;
1180: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1181: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1182: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1183: x_return_status := 'U';
1184: x_msg_count := 1;
1185: x_msg_data := fnd_message.get;
1186: end;

Line 1185: x_msg_data := fnd_message.get;

1181: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1182: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1183: x_return_status := 'U';
1184: x_msg_count := 1;
1185: x_msg_data := fnd_message.get;
1186: end;
1187:
1188: --
1189: -- PROCEDURE/Function

Line 1257: fnd_message.clear;

1253: in 0;
1254: end if;
1255: exception
1256: when OTHERS then
1257: fnd_message.clear;
1258: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1259: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1260: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1261: x_return_status := 'U';

Line 1258: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');

1254: end if;
1255: exception
1256: when OTHERS then
1257: fnd_message.clear;
1258: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1259: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1260: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1261: x_return_status := 'U';
1262: x_msg_count := 1;

Line 1259: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);

1255: exception
1256: when OTHERS then
1257: fnd_message.clear;
1258: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1259: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1260: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1261: x_return_status := 'U';
1262: x_msg_count := 1;
1263: x_msg_data := fnd_message.get;

Line 1260: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);

1256: when OTHERS then
1257: fnd_message.clear;
1258: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_UNEXPECTED_ERROR');
1259: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1260: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1261: x_return_status := 'U';
1262: x_msg_count := 1;
1263: x_msg_data := fnd_message.get;
1264: end;

Line 1263: x_msg_data := fnd_message.get;

1259: fnd_message.set_token(TOKEN=>'ERROR_CODE',VALUE=>sqlcode);
1260: fnd_message.set_token(TOKEN=>'ERROR_MESSAGE',VALUE=>sqlerrm);
1261: x_return_status := 'U';
1262: x_msg_count := 1;
1263: x_msg_data := fnd_message.get;
1264: end;
1265:
1266:
1267: --

Line 1431: fnd_message.clear;

1427: open c_xsl(p_id);
1428: fetch c_xsl into l_token;
1429: close c_xsl;
1430: end if;
1431: fnd_message.clear;
1432: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_TRANSF_ERROR');
1433: fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>p_type);
1434: fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token||'"');
1435: return fnd_message.get;

Line 1432: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_TRANSF_ERROR');

1428: fetch c_xsl into l_token;
1429: close c_xsl;
1430: end if;
1431: fnd_message.clear;
1432: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_TRANSF_ERROR');
1433: fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>p_type);
1434: fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token||'"');
1435: return fnd_message.get;
1436: end;

Line 1433: fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>p_type);

1429: close c_xsl;
1430: end if;
1431: fnd_message.clear;
1432: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_TRANSF_ERROR');
1433: fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>p_type);
1434: fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token||'"');
1435: return fnd_message.get;
1436: end;
1437:

Line 1434: fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token||'"');

1430: end if;
1431: fnd_message.clear;
1432: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_TRANSF_ERROR');
1433: fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>p_type);
1434: fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token||'"');
1435: return fnd_message.get;
1436: end;
1437:
1438: function return_mess(p_mess varchar2) return varchar2 is

Line 1435: return fnd_message.get;

1431: fnd_message.clear;
1432: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_TRANSF_ERROR');
1433: fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>p_type);
1434: fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token||'"');
1435: return fnd_message.get;
1436: end;
1437:
1438: function return_mess(p_mess varchar2) return varchar2 is
1439: begin

Line 1440: fnd_message.clear;

1436: end;
1437:
1438: function return_mess(p_mess varchar2) return varchar2 is
1439: begin
1440: fnd_message.clear;
1441: fnd_message.set_name(APPLICATION => 'OKC',NAME => p_mess);
1442: return 'Error

```
'||fnd_message.get||'
```

';
1443: end;
1444:

Line 1441: fnd_message.set_name(APPLICATION => 'OKC',NAME => p_mess);

1437:
1438: function return_mess(p_mess varchar2) return varchar2 is
1439: begin
1440: fnd_message.clear;
1441: fnd_message.set_name(APPLICATION => 'OKC',NAME => p_mess);
1442: return 'Error

```
'||fnd_message.get||'
```

';
1443: end;
1444:
1445:

Line 1442: return 'Error

```
'||fnd_message.get||'
```

1438: function return_mess(p_mess varchar2) return varchar2 is
1439: begin
1440: fnd_message.clear;
1441: fnd_message.set_name(APPLICATION => 'OKC',NAME => p_mess);
1442: return 'Error

```
'||fnd_message.get||'
```

';
1443: end;
1444:
1445:
1446: --

Line 1508: fnd_message.clear;

1504: if (fnd_profile.value('OKC_WEB_REPORT') is NULL) then
1505: -- open profile_options_csr;
1506: -- fetch profile_options_csr into l_token3;
1507: -- close profile_options_csr;
1508: fnd_message.clear;
1509: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1510: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1511: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1512: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);

Line 1509: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');

1505: -- open profile_options_csr;
1506: -- fetch profile_options_csr into l_token3;
1507: -- close profile_options_csr;
1508: fnd_message.clear;
1509: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1510: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1511: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1512: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1513: return fnd_message.get;

Line 1510: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);

1506: -- fetch profile_options_csr into l_token3;
1507: -- close profile_options_csr;
1508: fnd_message.clear;
1509: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1510: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1511: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1512: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1513: return fnd_message.get;
1514: end if;

Line 1511: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');

1507: -- close profile_options_csr;
1508: fnd_message.clear;
1509: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1510: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1511: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1512: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1513: return fnd_message.get;
1514: end if;
1515: open report_exists;

Line 1512: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);

1508: fnd_message.clear;
1509: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1510: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1511: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1512: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1513: return fnd_message.get;
1514: end if;
1515: open report_exists;
1516: fetch report_exists into l_dummy;

Line 1513: return fnd_message.get;

1509: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1510: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1511: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1512: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1513: return fnd_message.get;
1514: end if;
1515: open report_exists;
1516: fetch report_exists into l_dummy;
1517: close report_exists;

Line 1522: fnd_message.clear;

1518: if (l_dummy = '?') then
1519: -- open profile_options_csr;
1520: -- fetch profile_options_csr into l_token3;
1521: -- close profile_options_csr;
1522: fnd_message.clear;
1523: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1524: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1525: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1526: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);

Line 1523: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');

1519: -- open profile_options_csr;
1520: -- fetch profile_options_csr into l_token3;
1521: -- close profile_options_csr;
1522: fnd_message.clear;
1523: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1524: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1525: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1526: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1527: return fnd_message.get;

Line 1524: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);

1520: -- fetch profile_options_csr into l_token3;
1521: -- close profile_options_csr;
1522: fnd_message.clear;
1523: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1524: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1525: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1526: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1527: return fnd_message.get;
1528: end if;

Line 1525: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');

1521: -- close profile_options_csr;
1522: fnd_message.clear;
1523: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1524: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1525: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1526: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1527: return fnd_message.get;
1528: end if;
1529:

Line 1526: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);

1522: fnd_message.clear;
1523: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1524: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1525: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1526: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1527: return fnd_message.get;
1528: end if;
1529:
1530: open template_csr;

Line 1527: return fnd_message.get;

1523: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1524: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1525: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1526: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1527: return fnd_message.get;
1528: end if;
1529:
1530: open template_csr;
1531: fetch template_csr into l_token1, l_token2;

Line 1537: fnd_message.clear;

1533: if (l_token1 is not null) then
1534: open profile_options_csr;
1535: fetch profile_options_csr into l_token3;
1536: close profile_options_csr;
1537: fnd_message.clear;
1538: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1539: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1540: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1541: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);

Line 1538: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');

1534: open profile_options_csr;
1535: fetch profile_options_csr into l_token3;
1536: close profile_options_csr;
1537: fnd_message.clear;
1538: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1539: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1540: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1541: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1542: return fnd_message.get;

Line 1539: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);

1535: fetch profile_options_csr into l_token3;
1536: close profile_options_csr;
1537: fnd_message.clear;
1538: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1539: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1540: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1541: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1542: return fnd_message.get;
1543: else

Line 1540: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');

1536: close profile_options_csr;
1537: fnd_message.clear;
1538: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1539: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1540: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1541: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1542: return fnd_message.get;
1543: else
1544: return 'S';

Line 1541: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);

1537: fnd_message.clear;
1538: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1539: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1540: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1541: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1542: return fnd_message.get;
1543: else
1544: return 'S';
1545: end if;

Line 1542: return fnd_message.get;

1538: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_INACTIVE_TRANSF');
1539: -- fnd_message.set_token(TOKEN=>'TRANSF_TYPE',VALUE=>l_token1);
1540: -- fnd_message.set_token(TOKEN=>'TRANSF_NAME',VALUE=>'"'||l_token2||'"');
1541: -- fnd_message.set_token(TOKEN=>'PROFILE',VALUE=>l_token3);
1542: return fnd_message.get;
1543: else
1544: return 'S';
1545: end if;
1546: end;

Line 1595: fnd_message.clear;

1591: --
1592:
1593: function data_required_msg(p_data_name varchar2) return varchar2 is
1594: begin
1595: fnd_message.clear;
1596: FND_MESSAGE.SET_NAME(application => 'OKC',
1597: name => 'OKC_DATA_REQUIRED');
1598: FND_MESSAGE.SET_TOKEN(token => 'DATA_NAME',
1599: value => p_data_name,

Line 1596: FND_MESSAGE.SET_NAME(application => 'OKC',

1592:
1593: function data_required_msg(p_data_name varchar2) return varchar2 is
1594: begin
1595: fnd_message.clear;
1596: FND_MESSAGE.SET_NAME(application => 'OKC',
1597: name => 'OKC_DATA_REQUIRED');
1598: FND_MESSAGE.SET_TOKEN(token => 'DATA_NAME',
1599: value => p_data_name,
1600: translate => TRUE);

Line 1598: FND_MESSAGE.SET_TOKEN(token => 'DATA_NAME',

1594: begin
1595: fnd_message.clear;
1596: FND_MESSAGE.SET_NAME(application => 'OKC',
1597: name => 'OKC_DATA_REQUIRED');
1598: FND_MESSAGE.SET_TOKEN(token => 'DATA_NAME',
1599: value => p_data_name,
1600: translate => TRUE);
1601: FND_MESSAGE.SET_TOKEN(token => 'OPERATION',
1602: value => 'OKC_PRINT_CONTRACT',

Line 1601: FND_MESSAGE.SET_TOKEN(token => 'OPERATION',

1597: name => 'OKC_DATA_REQUIRED');
1598: FND_MESSAGE.SET_TOKEN(token => 'DATA_NAME',
1599: value => p_data_name,
1600: translate => TRUE);
1601: FND_MESSAGE.SET_TOKEN(token => 'OPERATION',
1602: value => 'OKC_PRINT_CONTRACT',
1603: translate => TRUE);
1604: return fnd_message.get;
1605: end;

Line 1604: return fnd_message.get;

1600: translate => TRUE);
1601: FND_MESSAGE.SET_TOKEN(token => 'OPERATION',
1602: value => 'OKC_PRINT_CONTRACT',
1603: translate => TRUE);
1604: return fnd_message.get;
1605: end;
1606:
1607: --
1608: -- PROCEDURE/Function

Line 1647: fnd_message.clear;

1643: close articles_diff_csr;
1644: if (l_dummy is not NULL) then
1645: x_return_status := 'E';
1646: x_msg_count := 1;
1647: fnd_message.clear;
1648: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_ARTICLES_WARNING');
1649: x_msg_data := fnd_message.get;
1650: return;
1651: end if;

Line 1648: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_ARTICLES_WARNING');

1644: if (l_dummy is not NULL) then
1645: x_return_status := 'E';
1646: x_msg_count := 1;
1647: fnd_message.clear;
1648: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_ARTICLES_WARNING');
1649: x_msg_data := fnd_message.get;
1650: return;
1651: end if;
1652: x_return_status := 'S';

Line 1649: x_msg_data := fnd_message.get;

1645: x_return_status := 'E';
1646: x_msg_count := 1;
1647: fnd_message.clear;
1648: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_ARTICLES_WARNING');
1649: x_msg_data := fnd_message.get;
1650: return;
1651: end if;
1652: x_return_status := 'S';
1653: end;

Line 1830: fnd_message.clear;

1826: fetch xsl_csr into l_name;
1827: close xsl_csr;
1828: end if;
1829: if (l_name is not null) then
1830: fnd_message.clear;
1831: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_VALUE_NOT_UNIQUE');
1832: fnd_message.set_token(TOKEN=>'COL_NAME',VALUE=>l_name);
1833: return fnd_message.get;
1834: else

Line 1831: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_VALUE_NOT_UNIQUE');

1827: close xsl_csr;
1828: end if;
1829: if (l_name is not null) then
1830: fnd_message.clear;
1831: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_VALUE_NOT_UNIQUE');
1832: fnd_message.set_token(TOKEN=>'COL_NAME',VALUE=>l_name);
1833: return fnd_message.get;
1834: else
1835: return null;

Line 1832: fnd_message.set_token(TOKEN=>'COL_NAME',VALUE=>l_name);

1828: end if;
1829: if (l_name is not null) then
1830: fnd_message.clear;
1831: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_VALUE_NOT_UNIQUE');
1832: fnd_message.set_token(TOKEN=>'COL_NAME',VALUE=>l_name);
1833: return fnd_message.get;
1834: else
1835: return null;
1836: end if;

Line 1833: return fnd_message.get;

1829: if (l_name is not null) then
1830: fnd_message.clear;
1831: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_VALUE_NOT_UNIQUE');
1832: fnd_message.set_token(TOKEN=>'COL_NAME',VALUE=>l_name);
1833: return fnd_message.get;
1834: else
1835: return null;
1836: end if;
1837: end;

Line 1907: -- validate types, dependencies, spawn fnd_messages

1903:
1904: begin
1905: fnd_msg_pub.initialize;
1906: --
1907: -- validate types, dependencies, spawn fnd_messages
1908: --
1909: set_sql_id;
1910: if (G_sql_id is NULL) then
1911: return -1;

Line 2035: fnd_message.clear;

2031: end;
2032:
2033: function get_zero_mess return varchar2 is
2034: begin
2035: fnd_message.clear;
2036: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');
2037: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2038: end;
2039:

Line 2036: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');

2032:
2033: function get_zero_mess return varchar2 is
2034: begin
2035: fnd_message.clear;
2036: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');
2037: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2038: end;
2039:
2040: function get_much_mess return varchar2 is

Line 2037: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2033: function get_zero_mess return varchar2 is
2034: begin
2035: fnd_message.clear;
2036: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');
2037: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2038: end;
2039:
2040: function get_much_mess return varchar2 is
2041: begin

Line 2042: fnd_message.clear;

2038: end;
2039:
2040: function get_much_mess return varchar2 is
2041: begin
2042: fnd_message.clear;
2043: fnd_message.set_name(APPLICATION=>'PER',NAME=>'HR_WEB_RETRIEVE_LIMIT_EXCEEDED');
2044: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2045: end;
2046:

Line 2043: fnd_message.set_name(APPLICATION=>'PER',NAME=>'HR_WEB_RETRIEVE_LIMIT_EXCEEDED');

2039:
2040: function get_much_mess return varchar2 is
2041: begin
2042: fnd_message.clear;
2043: fnd_message.set_name(APPLICATION=>'PER',NAME=>'HR_WEB_RETRIEVE_LIMIT_EXCEEDED');
2044: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2045: end;
2046:
2047: procedure get_labels(

Line 2044: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2040: function get_much_mess return varchar2 is
2041: begin
2042: fnd_message.clear;
2043: fnd_message.set_name(APPLICATION=>'PER',NAME=>'HR_WEB_RETRIEVE_LIMIT_EXCEEDED');
2044: return replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2045: end;
2046:
2047: procedure get_labels(
2048: x_title out nocopy varchar2,

Line 2084: fnd_message.clear;

2080: open c3;
2081: fetch c3 into x_description;
2082: close c3;
2083: if (fnd_profile.value('OKC_WEB_REPORT') is NULL) then
2084: fnd_message.clear;
2085: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');
2086: x_message := fnd_message.get;
2087: return;
2088: else

Line 2085: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');

2081: fetch c3 into x_description;
2082: close c3;
2083: if (fnd_profile.value('OKC_WEB_REPORT') is NULL) then
2084: fnd_message.clear;
2085: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');
2086: x_message := fnd_message.get;
2087: return;
2088: else
2089: open c1;

Line 2086: x_message := fnd_message.get;

2082: close c3;
2083: if (fnd_profile.value('OKC_WEB_REPORT') is NULL) then
2084: fnd_message.clear;
2085: fnd_message.set_name(APPLICATION=>'CN',NAME=>'CN_NO_RECS_FOUND');
2086: x_message := fnd_message.get;
2087: return;
2088: else
2089: open c1;
2090: fetch c1 into x_prompt,x_sql;

Line 2100: fnd_message.clear;

2096: x_run1 out nocopy varchar2,
2097: x_run2 out nocopy varchar2,
2098: x_close out nocopy varchar2) is
2099: begin
2100: fnd_message.clear;
2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');

Line 2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');

2097: x_run2 out nocopy varchar2,
2098: x_close out nocopy varchar2) is
2099: begin
2100: fnd_message.clear;
2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

Line 2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2098: x_close out nocopy varchar2) is
2099: begin
2100: fnd_message.clear;
2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;

Line 2103: fnd_message.clear;

2099: begin
2100: fnd_message.clear;
2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');

Line 2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');

2100: fnd_message.clear;
2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');
2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

Line 2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2101: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN1');
2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');
2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2109: end;

Line 2106: fnd_message.clear;

2102: x_run1 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');
2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2109: end;
2110:

Line 2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');

2103: fnd_message.clear;
2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');
2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2109: end;
2110:
2111: procedure document_link(

Line 2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');

2104: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_RUN2');
2105: x_run2 := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2106: fnd_message.clear;
2107: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_CLOSE');
2108: x_close := replace(fnd_message.get,'<',fnd_global.local_chr(38)||'lt;');
2109: end;
2110:
2111: procedure document_link(
2112: p_kid in NUMBER,

Line 2348: fnd_message.clear;

2344: open c2(p_xst_id);
2345: fetch c2 into l_q,l_x;
2346: close c2;
2347:
2348: fnd_message.clear;
2349: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR_SUBJECT');
2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);

Line 2349: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR_SUBJECT');

2345: fetch c2 into l_q,l_x;
2346: close c2;
2347:
2348: fnd_message.clear;
2349: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR_SUBJECT');
2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);

Line 2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);

2346: close c2;
2347:
2348: fnd_message.clear;
2349: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR_SUBJECT');
2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2354: l_s := fnd_message.get;

Line 2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);

2347:
2348: fnd_message.clear;
2349: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR_SUBJECT');
2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2354: l_s := fnd_message.get;
2355:

Line 2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);

2348: fnd_message.clear;
2349: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR_SUBJECT');
2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2354: l_s := fnd_message.get;
2355:
2356: fnd_message.clear;

Line 2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);

2349: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR_SUBJECT');
2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2354: l_s := fnd_message.get;
2355:
2356: fnd_message.clear;
2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');

Line 2354: l_s := fnd_message.get;

2350: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2351: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2354: l_s := fnd_message.get;
2355:
2356: fnd_message.clear;
2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');
2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);

Line 2356: fnd_message.clear;

2352: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2354: l_s := fnd_message.get;
2355:
2356: fnd_message.clear;
2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');
2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);

Line 2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');

2353: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2354: l_s := fnd_message.get;
2355:
2356: fnd_message.clear;
2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');
2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2361: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);

Line 2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);

2354: l_s := fnd_message.get;
2355:
2356: fnd_message.clear;
2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');
2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2361: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2362: l_b := fnd_message.get;

Line 2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);

2355:
2356: fnd_message.clear;
2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');
2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2361: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2362: l_b := fnd_message.get;
2363:

Line 2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);

2356: fnd_message.clear;
2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');
2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2361: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2362: l_b := fnd_message.get;
2363:
2364: OKC_ASYNC_PUB.msg_call(

Line 2361: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);

2357: fnd_message.set_name(APPLICATION=>'OKC',NAME=>'OKC_XML_ERROR');
2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2361: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2362: l_b := fnd_message.get;
2363:
2364: OKC_ASYNC_PUB.msg_call(
2365: p_api_version => 1,

Line 2362: l_b := fnd_message.get;

2358: fnd_message.set_token(TOKEN => 'NAME' ,VALUE => l_q);
2359: fnd_message.set_token(TOKEN => 'DESCRIPTION',VALUE => l_x);
2360: fnd_message.set_token(TOKEN => 'NUMBER' ,VALUE => l_n);
2361: fnd_message.set_token(TOKEN => 'MODIFIER' ,VALUE => l_m);
2362: l_b := fnd_message.get;
2363:
2364: OKC_ASYNC_PUB.msg_call(
2365: p_api_version => 1,
2366: x_return_status => x_return_status,