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_API

Line 7: p_primary_key IN VARCHAR2 := FND_API.G_MISS_CHAR,

3:
4: procedure DOWNLOAD (
5: p_business_object IN VARCHAR2,
6: p_appl_short_name IN VARCHAR2,
7: p_primary_key IN VARCHAR2 := FND_API.G_MISS_CHAR,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_download_attr IN VARCHAR2 := 'Y',

Line 9: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

5: p_business_object IN VARCHAR2,
6: p_appl_short_name IN VARCHAR2,
7: p_primary_key IN VARCHAR2 := FND_API.G_MISS_CHAR,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_download_attr IN VARCHAR2 := 'Y',
12: p_download_reg IN VARCHAR2 := 'Y'
13: ) is

Line 10: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR,

6: p_appl_short_name IN VARCHAR2,
7: p_primary_key IN VARCHAR2 := FND_API.G_MISS_CHAR,
8: p_return_status OUT NOCOPY VARCHAR2,
9: p_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
10: p_levelpk IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_download_attr IN VARCHAR2 := 'Y',
12: p_download_reg IN VARCHAR2 := 'Y'
13: ) is
14: cursor l_get_appl_id_csr (short_name_param varchar2) is

Line 161: l_object_pk varchar2(240) := FND_API.G_MISS_CHAR;

157: l_return_status VARCHAR2(1);
158: l_string_pos number;
159: l_table_index number;
160: l_dum NUMBER;
161: l_object_pk varchar2(240) := FND_API.G_MISS_CHAR;
162: l_flow_pk_tbl AK_FLOW_PUB.Flow_PK_Tbl_Type;
163: l_region_pk_tbl AK_REGION_PUB.Region_PK_Tbl_Type;
164: l_custom_pk_tbl AK_CUSTOM_PUB.Custom_PK_Tbl_Type;
165: l_object_pk_tbl AK_OBJECT_PUB.Object_PK_Tbl_Type;

Line 188: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then

184:
185: --
186: -- Get Primary key for the object
187: --
188: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then
189: l_object_pk := p_primary_key;
190: end if;
191:
192: --

Line 209: raise FND_API.G_EXC_ERROR;

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;
211: close l_get_appl_id_csr;
212:
213: -- set Loading mode

Line 287: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

283: --
284: -- Download data from database
285: --
286: if (upper(l_by_object) = 'FLOW') then
287: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
288: open l_check_percent(l_object_pk);
289: fetch l_check_percent into l_percent;
290: if l_percent <> 0 then
291: l_index := 1;

Line 312: --p_validation_level => FND_API.G_VALID_LEVEL_NONE,

308: end if;
309: close l_check_percent;
310: end if;
311: AK_FLOW_GRP.DOWNLOAD_FLOW (
312: --p_validation_level => FND_API.G_VALID_LEVEL_NONE,
313: p_api_version_number => 1.0,
314: p_init_msg_tbl => TRUE,
315: p_msg_count => l_msg_count,
316: p_msg_data => l_msg_data,

Line 324: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

320: p_flow_pk_tbl => l_flow_pk_tbl
321: );
322:
323: elsif (upper(l_by_object) = 'REGION') then
324: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
325: open l_check_percent(l_object_pk);
326: fetch l_check_percent into l_percent;
327: if l_percent <> 0 then
328: l_index := 1;

Line 349: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,

345: end if;
346: close l_check_percent;
347: end if;
348: AK_REGION_GRP.DOWNLOAD_REGION (
349: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,
350: p_api_version_number => 1.0,
351: p_init_msg_tbl => TRUE,
352: p_msg_count => l_msg_count,
353: p_msg_data => l_msg_data,

Line 361: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

357: p_region_pk_tbl => l_region_pk_tbl
358: );
359:
360: elsif (upper(l_by_object) = 'CUSTOM_REGION') then
361: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
362: l_index := 1;
363: if (p_level is null or p_level = FND_API.G_MISS_CHAR) then
364: open l_get_custom_list_csr(l_appl_id, l_object_pk);
365: loop

Line 363: if (p_level is null or p_level = FND_API.G_MISS_CHAR) then

359:
360: elsif (upper(l_by_object) = 'CUSTOM_REGION') then
361: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
362: l_index := 1;
363: if (p_level is null or p_level = FND_API.G_MISS_CHAR) then
364: open l_get_custom_list_csr(l_appl_id, l_object_pk);
365: loop
366: fetch l_get_custom_list_csr into
367: l_custom_pk_tbl(l_index).custom_appl_id,

Line 380: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then

376: exit when l_get_custom_list_csr%notfound;
377: end loop;
378: close l_get_custom_list_csr;
379: elsif (p_level = 'RESPONSIBILITY') then
380: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) 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;

Line 389: -- RAISE FND_API.G_EXC_ERROR;

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;
392: open l_get_custom_resp_list_csr(l_appl_id, l_object_pk, l_level_id_pk);
393: loop

Line 425: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then

421: end loop;
422: close l_get_custom_resp_list2_csr;
423: end if;
424: elsif (p_level = 'ORGANIZATION') then
425: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) 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;

Line 434: -- RAISE FND_API.G_EXC_ERROR;

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;
437: open l_get_custom_org_list_csr(l_appl_id, l_object_pk, l_level_id_pk);
438: loop

Line 470: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then

466: end loop;
467: close l_get_custom_org_list2_csr;
468: end if;
469: elsif (p_level = 'FUNCTION') then
470: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then
471: open l_get_custom_fun_list_csr(l_appl_id, l_object_pk, p_levelpk);
472: loop
473: fetch l_get_custom_fun_list_csr into
474: l_custom_pk_tbl(l_index).custom_appl_id,

Line 504: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then

500: end loop;
501: close l_get_custom_fun_list2_csr;
502: end if;
503: elsif (p_level = 'LOCALIZATION') then
504: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then
505: open l_get_custom_local_list_csr(l_appl_id, l_object_pk, p_levelpk);
506: loop
507: fetch l_get_custom_local_list_csr into
508: l_custom_pk_tbl(l_index).custom_appl_id,

Line 538: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then

534: end loop;
535: close l_get_custom_local_list2_csr;
536: end if;
537: elsif (p_level = 'SITE') then
538: if (p_levelpk is not null and p_levelpk <> FND_API.G_MISS_CHAR) then
539: open l_get_custom_site_list_csr(l_appl_id, l_object_pk, p_levelpk);
540: loop
541: fetch l_get_custom_site_list_csr into
542: l_custom_pk_tbl(l_index).custom_appl_id,

Line 575: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,

571: end if;
572: end if;
573: if (l_index > 1) then
574: AK_CUSTOM_GRP.DOWNLOAD_CUSTOM (
575: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,
576: p_api_version_number => 1.0,
577: p_init_msg_tbl => TRUE,
578: p_msg_count => l_msg_count,
579: p_msg_data => l_msg_data,

Line 590: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

586: );
587: end if;
588:
589: elsif (upper(l_by_object) = 'OBJECT') then
590: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
591: open l_check_percent(l_object_pk);
592: fetch l_check_percent into l_percent;
593: if l_percent <> 0 then
594: l_index := 1;

Line 613: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,

609: close l_check_percent;
610: end if;
611:
612: AK_OBJECT_GRP.DOWNLOAD_OBJECT (
613: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,
614: p_api_version_number => 1.0,
615: p_init_msg_tbl => TRUE,
616: p_msg_count => l_msg_count,
617: p_msg_data => l_msg_data,

Line 626: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

622: );
623:
624: -- percent code didn't work here, it's in akdvatrb.pls
625: elsif (upper(l_by_object) = 'ATTRIBUTE') then
626: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
627: l_attr_pk_tbl(1).attribute_appl_id := l_appl_id;
628: l_attr_pk_tbl(1).attribute_code := l_object_pk;
629: end if;
630:

Line 632: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,

628: l_attr_pk_tbl(1).attribute_code := l_object_pk;
629: end if;
630:
631: AK_ATTRIBUTE_GRP.DOWNLOAD_ATTRIBUTE (
632: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,
633: p_api_version_number => 1.0,
634: p_init_msg_tbl => TRUE,
635: p_msg_count => l_msg_count,
636: p_msg_data => l_msg_data,

Line 644: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

640: p_attribute_pk_tbl => l_attr_pk_tbl
641: );
642:
643: elsif (upper(l_by_object) = 'SECURITY') then
644: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
645: l_sec_pk_tbl(1).responsibility_id := to_number(l_object_pk);
646: l_sec_pk_tbl(1).responsibility_appl_id := l_appl_id;
647: end if;
648: AK_SECURITY_GRP.DOWNLOAD_RESP (

Line 649: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,

645: l_sec_pk_tbl(1).responsibility_id := to_number(l_object_pk);
646: l_sec_pk_tbl(1).responsibility_appl_id := l_appl_id;
647: end if;
648: AK_SECURITY_GRP.DOWNLOAD_RESP (
649: -- p_validation_level => FND_API.G_VALID_LEVEL_NONE,
650: p_api_version_number => 1.0,
651: p_init_msg_tbl => TRUE,
652: p_msg_count => l_msg_count,
653: p_msg_data => l_msg_data,

Line 662: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

658: p_resp_pk_tbl => l_sec_pk_tbl
659: );
660:
661: elsif (upper(l_by_object) = 'QUERYOBJ') then
662: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
663: l_queryobj_pk_tbl(1).query_code := l_object_pk;
664: end if;
665: AK_QUERYOBJ_GRP.DOWNLOAD_QUERY_OBJECT (
666: p_api_version_number => 1.0,

Line 677: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then

673: p_queryobj_pk_tbl => l_queryobj_pk_tbl
674: );
675:
676: elsif (upper(l_by_object) = 'AMPARAM_REGISTRY') then
677: if (l_object_pk is not null and l_object_pk <> FND_API.G_MISS_CHAR) then
678: l_amparamreg_pk_tbl(1).applicationmodule_defn_name := l_object_pk;
679: end if;
680: AK_AMPARAM_REGISTRY_GRP.DOWNLOAD_AMPARAM_REGISTRY (
681: p_api_version_number => 1.0,

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 724: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then

720: l_index := l_index + 1;
721: l_buffer_tbl(l_index) := to_char(sysdate, 'DY MON DD YYYY HH24:MI:SS');
722: l_index := l_index + 1;
723: l_buffer_tbl(l_index) := 'Finished processing application: '||l_appl_short_name;
724: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then
725: l_index := l_index + 1;
726: l_buffer_tbl(l_index) := 'Primary key: '||p_primary_key;
727: end if;
728: l_index := l_index + 1;

Line 742: --if (l_return_status = FND_API.G_RET_STS_SUCCESS) then

738: p_buffer_tbl => l_buffer_tbl,
739: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
740: );
741:
742: --if (l_return_status = FND_API.G_RET_STS_SUCCESS) then
743: -- dbms_output.put_line('Log file has been printed out to screen');
744: --else
745: -- dbms_output.put_line('Failed to write log file to Global PL/SQL table');
746: --end if;

Line 749: WHEN FND_API.G_EXC_ERROR THEN

745: -- dbms_output.put_line('Failed to write log file to Global PL/SQL table');
746: --end if;
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

Line 750: p_return_status := FND_API.G_RET_STS_ERROR;

746: --end if;
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;

Line 754: p_return_status := FND_API.G_RET_STS_ERROR;

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,
756: SUBSTR (SQLERRM, 1, 240)||' no data found' );
757: WHEN OTHERS THEN
758: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 758: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
760: SUBSTR (SQLERRM, 1, 240) );
761: if FND_MSG_PUB.Count_Msg > 0 then
762: FND_MSG_PUB.Reset;

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 779: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then

775: l_index := l_index + 1;
776: l_buffer_tbl(l_index) := to_char(sysdate, 'DY MON DD YYYY HH24:MI:SS');
777: l_index := l_index + 1;
778: l_buffer_tbl(l_index) := 'Finished processing application: '||l_appl_short_name;
779: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then
780: l_index := l_index + 1;
781: l_buffer_tbl(l_index) := 'Primary key: '||p_primary_key;
782: end if;
783: l_index := l_index + 1;