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.AK_DOWNLOAD_GRP dependencies on FND_MSG_PUB

Line 195: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

191:
192: --
193: -- Set what error messages are to be displayed
194: --
195: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
196: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;
197:
198: -- Get application id from application short name
199: --

Line 196: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;

192: --
193: -- Set what error messages are to be displayed
194: --
195: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
196: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;
197:
198: -- Get application id from application short name
199: --
200: open l_get_appl_id_csr(l_appl_short_name);

Line 203: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

199: --
200: open l_get_appl_id_csr(l_appl_short_name);
201: fetch l_get_appl_id_csr into l_appl_id;
202: if (l_get_appl_id_csr%notfound) then
203: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
204: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
205: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
206: FND_MSG_PUB.Add;
207: end if;

Line 206: FND_MSG_PUB.Add;

202: if (l_get_appl_id_csr%notfound) then
203: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
204: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
205: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
206: FND_MSG_PUB.Add;
207: end if;
208: close l_get_appl_id_csr;
209: raise FND_API.G_EXC_ERROR;
210: end if;

Line 385: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

381: open l_get_resp_id(p_levelpk);
382: fetch l_get_resp_id into l_level_id_pk;
383: if (l_get_resp_id%notfound) then
384: l_level_id_pk := null;
385: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
386: -- FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');
387: -- FND_MSG_PUB.Add;
388: -- end if;
389: -- RAISE FND_API.G_EXC_ERROR;

Line 387: -- FND_MSG_PUB.Add;

383: if (l_get_resp_id%notfound) then
384: l_level_id_pk := null;
385: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
386: -- FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');
387: -- FND_MSG_PUB.Add;
388: -- end if;
389: -- RAISE FND_API.G_EXC_ERROR;
390: end if;
391: close l_get_resp_id;

Line 430: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

426: open l_get_org_id(p_levelpk);
427: fetch l_get_org_id into l_level_id_pk;
428: if (l_get_org_id%notfound) then
429: l_level_id_pk := null;
430: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
431: -- FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');
432: -- FND_MSG_PUB.Add;
433: -- end if;
434: -- RAISE FND_API.G_EXC_ERROR;

Line 432: -- FND_MSG_PUB.Add;

428: if (l_get_org_id%notfound) then
429: l_level_id_pk := null;
430: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
431: -- FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');
432: -- FND_MSG_PUB.Add;
433: -- end if;
434: -- RAISE FND_API.G_EXC_ERROR;
435: end if;
436: close l_get_org_id;

Line 696: FND_MSG_PUB.Add;

692: --dbms_output.put_line(upper(l_by_object) ||
693: -- ' is invalid - it must be FLOW, REGION, OBJECT, ATTRIBUTE or SECURITY');
694: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BUSINESS_OBJECT');
695: FND_MESSAGE.SET_TOKEN('INVALID',l_by_object);
696: FND_MSG_PUB.Add;
697: end if;
698:
699: p_return_status := l_return_status;
700: --dbms_output.put_line('Finish downloading at:' ||

Line 706: if FND_MSG_PUB.Count_Msg > 0 then

702:
703: --dbms_output.put_line('Return status is: ' || l_return_status);
704: --dbms_output.put_line('Return message: ' || l_msg_data);
705:
706: if FND_MSG_PUB.Count_Msg > 0 then
707: FND_MSG_PUB.Reset;
708: --dbms_output.put_line('Messages: ');
709: for i in 1 .. FND_MSG_PUB.Count_Msg loop
710: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 707: FND_MSG_PUB.Reset;

703: --dbms_output.put_line('Return status is: ' || l_return_status);
704: --dbms_output.put_line('Return message: ' || l_msg_data);
705:
706: if FND_MSG_PUB.Count_Msg > 0 then
707: FND_MSG_PUB.Reset;
708: --dbms_output.put_line('Messages: ');
709: for i in 1 .. FND_MSG_PUB.Count_Msg loop
710: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
711: end loop;

Line 709: for i in 1 .. FND_MSG_PUB.Count_Msg loop

705:
706: if FND_MSG_PUB.Count_Msg > 0 then
707: FND_MSG_PUB.Reset;
708: --dbms_output.put_line('Messages: ');
709: for i in 1 .. FND_MSG_PUB.Count_Msg loop
710: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
711: end loop;
712: FND_MSG_PUB.Initialize;
713: end if;

Line 710: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

706: if FND_MSG_PUB.Count_Msg > 0 then
707: FND_MSG_PUB.Reset;
708: --dbms_output.put_line('Messages: ');
709: for i in 1 .. FND_MSG_PUB.Count_Msg loop
710: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
711: end loop;
712: FND_MSG_PUB.Initialize;
713: end if;
714:

Line 712: FND_MSG_PUB.Initialize;

708: --dbms_output.put_line('Messages: ');
709: for i in 1 .. FND_MSG_PUB.Count_Msg loop
710: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
711: end loop;
712: FND_MSG_PUB.Initialize;
713: end if;
714:
715: --
716: -- Add ending to log file

Line 751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

747:
748: EXCEPTION
749: WHEN FND_API.G_EXC_ERROR THEN
750: p_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
752: SUBSTR (SQLERRM, 1, 240)||' exec error' );
753: WHEN NO_DATA_FOUND THEN
754: p_return_status := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

Line 755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

751: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
752: SUBSTR (SQLERRM, 1, 240)||' exec error' );
753: WHEN NO_DATA_FOUND THEN
754: p_return_status := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
756: SUBSTR (SQLERRM, 1, 240)||' no data found' );
757: WHEN OTHERS THEN
758: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

Line 759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
756: SUBSTR (SQLERRM, 1, 240)||' no data found' );
757: WHEN OTHERS THEN
758: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
760: SUBSTR (SQLERRM, 1, 240) );
761: if FND_MSG_PUB.Count_Msg > 0 then
762: FND_MSG_PUB.Reset;
763: --dbms_output.put_line('Messages: ');

Line 761: if FND_MSG_PUB.Count_Msg > 0 then

757: WHEN OTHERS THEN
758: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
760: SUBSTR (SQLERRM, 1, 240) );
761: if FND_MSG_PUB.Count_Msg > 0 then
762: FND_MSG_PUB.Reset;
763: --dbms_output.put_line('Messages: ');
764: for i in 1 .. FND_MSG_PUB.Count_Msg loop
765: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 762: FND_MSG_PUB.Reset;

758: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
760: SUBSTR (SQLERRM, 1, 240) );
761: if FND_MSG_PUB.Count_Msg > 0 then
762: FND_MSG_PUB.Reset;
763: --dbms_output.put_line('Messages: ');
764: for i in 1 .. FND_MSG_PUB.Count_Msg loop
765: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
766: end loop;

Line 764: for i in 1 .. FND_MSG_PUB.Count_Msg loop

760: SUBSTR (SQLERRM, 1, 240) );
761: if FND_MSG_PUB.Count_Msg > 0 then
762: FND_MSG_PUB.Reset;
763: --dbms_output.put_line('Messages: ');
764: for i in 1 .. FND_MSG_PUB.Count_Msg loop
765: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
766: end loop;
767: FND_MSG_PUB.Initialize;
768: end if;

Line 765: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

761: if FND_MSG_PUB.Count_Msg > 0 then
762: FND_MSG_PUB.Reset;
763: --dbms_output.put_line('Messages: ');
764: for i in 1 .. FND_MSG_PUB.Count_Msg loop
765: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
766: end loop;
767: FND_MSG_PUB.Initialize;
768: end if;
769:

Line 767: FND_MSG_PUB.Initialize;

763: --dbms_output.put_line('Messages: ');
764: for i in 1 .. FND_MSG_PUB.Count_Msg loop
765: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
766: end loop;
767: FND_MSG_PUB.Initialize;
768: end if;
769:
770: --
771: -- Add ending to log file