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_CUSTOM_PVT dependencies on AK_CUSTOM_PVT

Line 1: package body AK_CUSTOM_PVT as

1: package body AK_CUSTOM_PVT as
2: /* $Header: akdvcreb.pls 120.5 2006/04/14 13:52:05 tshort noship $ */
3:
4: --=======================================================
5: -- Procedure DOWNLOAD_CUSTOM

Line 410: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

406: if (p_level is null or p_level = FND_API.G_MISS_CHAR) then
407: for l_custom_rec in l_get_custom_list_csr (
408: l_region_pk_tbl(l_index).region_appl_id,
409: l_region_pk_tbl(l_index).region_code) LOOP
410: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
411: p_return_status => l_return_status,
412: p_region_application_id => l_custom_rec.region_application_id,
413: p_region_code => l_custom_rec.region_code,
414: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 423: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

419: for l_custom_rec in l_get_custom_resp_list_csr (
420: l_region_pk_tbl(l_index).region_appl_id,
421: l_region_pk_tbl(l_index).region_code,
422: l_resp_id_pk) LOOP
423: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
424: p_return_status => l_return_status,
425: p_region_application_id => l_custom_rec.region_application_id,
426: p_region_code => l_custom_rec.region_code,
427: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 435: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

431: elsif (p_level = 'RESPONSIBILITY' and l_resp_id_pk is null) then
432: for l_custom_rec in l_get_custom_resp_list2_csr (
433: l_region_pk_tbl(l_index).region_appl_id,
434: l_region_pk_tbl(l_index).region_code) LOOP
435: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
436: p_return_status => l_return_status,
437: p_region_application_id => l_custom_rec.region_application_id,
438: p_region_code => l_custom_rec.region_code,
439: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 448: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

444: for l_custom_rec in l_get_custom_org_list_csr (
445: l_region_pk_tbl(l_index).region_appl_id,
446: l_region_pk_tbl(l_index).region_code,
447: l_org_id_pk) LOOP
448: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
449: p_return_status => l_return_status,
450: p_region_application_id => l_custom_rec.region_application_id,
451: p_region_code => l_custom_rec.region_code,
452: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 460: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

456: elsif (p_level = 'ORGANIZATION' and l_org_id_pk is null) then
457: for l_custom_rec in l_get_custom_org_list2_csr (
458: l_region_pk_tbl(l_index).region_appl_id,
459: l_region_pk_tbl(l_index).region_code) LOOP
460: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
461: p_return_status => l_return_status,
462: p_region_application_id => l_custom_rec.region_application_id,
463: p_region_code => l_custom_rec.region_code,
464: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 473: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

469: for l_custom_rec in l_get_custom_fun_list_csr (
470: l_region_pk_tbl(l_index).region_appl_id,
471: l_region_pk_tbl(l_index).region_code,
472: l_fun_pk) LOOP
473: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
474: p_return_status => l_return_status,
475: p_region_application_id => l_custom_rec.region_application_id,
476: p_region_code => l_custom_rec.region_code,
477: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 485: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

481: elsif (p_level = 'FUNCTION' and l_fun_pk is null) then
482: for l_custom_rec in l_get_custom_fun_list2_csr (
483: l_region_pk_tbl(l_index).region_appl_id,
484: l_region_pk_tbl(l_index).region_code) LOOP
485: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
486: p_return_status => l_return_status,
487: p_region_application_id => l_custom_rec.region_application_id,
488: p_region_code => l_custom_rec.region_code,
489: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 499: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

495: for l_custom_rec in l_get_custom_site_list_csr (
496: l_region_pk_tbl(l_index).region_appl_id,
497: l_region_pk_tbl(l_index).region_code,
498: p_levelpk) LOOP
499: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
500: p_return_status => l_return_status,
501: p_region_application_id => l_custom_rec.region_application_id,
502: p_region_code => l_custom_rec.region_code,
503: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 512: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

508: p_levelpk = FND_API.G_MISS_CHAR)) then
509: for l_custom_rec in l_get_custom_site_list2_csr (
510: l_region_pk_tbl(l_index).region_appl_id,
511: l_region_pk_tbl(l_index).region_code) LOOP
512: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
513: p_return_status => l_return_status,
514: p_region_application_id => l_custom_rec.region_application_id,
515: p_region_code => l_custom_rec.region_code,
516: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 526: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

522: for l_custom_rec in l_get_custom_local_list_csr (
523: l_region_pk_tbl(l_index).region_appl_id,
524: l_region_pk_tbl(l_index).region_code,
525: p_levelpk) LOOP
526: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
527: p_return_status => l_return_status,
528: p_region_application_id => l_custom_rec.region_application_id,
529: p_region_code => l_custom_rec.region_code,
530: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 539: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(

535: p_levelpk = FND_API.G_MISS_CHAR)) then
536: for l_custom_rec in l_get_custom_local_list2_csr (
537: l_region_pk_tbl(l_index).region_appl_id,
538: l_region_pk_tbl(l_index).region_code) LOOP
539: AK_CUSTOM_PVT.INSERT_CUSTOM_PK_TABLE(
540: p_return_status => l_return_status,
541: p_region_application_id => l_custom_rec.region_application_id,
542: p_region_code => l_custom_rec.region_code,
543: p_custom_appl_id => l_custom_rec.customization_application_id,

Line 823: if not AK_CUSTOM_PVT.VALIDATE_CUSTOM (

819: close l_get_custom_tl_csr;
820:
821: -- Customization must be validated before it is written to the file
822: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
823: if not AK_CUSTOM_PVT.VALIDATE_CUSTOM (
824: p_validation_level => p_validation_level,
825: p_api_version_number => 1.0,
826: p_return_status => l_return_status,
827: p_region_application_id => l_custom_rec.region_application_id,

Line 860: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUSTOM */

856: p_custom_code);
857: FND_MSG_PUB.Add;
858: end if;
859: raise FND_API.G_EXC_ERROR;
860: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUSTOM */
861: end if; /* if p_validation_level */
862:
863: -- Write customization into buffer
864: l_index := 1;

Line 1180: not AK_CUSTOM_PVT.VALIDATE_CUST_REGION (

1176: RAISE FND_API.G_EXC_ERROR;
1177: else
1178: -- write this customized region if it is validated
1179: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
1180: not AK_CUSTOM_PVT.VALIDATE_CUST_REGION (
1181: p_validation_level => p_validation_level,
1182: p_api_version_number => 1.0,
1183: p_return_status => l_return_status,
1184: p_region_application_id => l_cust_region_rec.region_application_id,

Line 1204: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUST_REGION */

1200: to_char(p_custom_application_id) ||' '||
1201: p_custom_code);
1202: FND_MSG_PUB.Add;
1203: raise FND_API.G_EXC_ERROR;
1204: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUST_REGION */
1205:
1206:
1207: else
1208: l_index := 1;

Line 1398: not AK_CUSTOM_PVT.VALIDATE_CUST_REGION_ITEM (

1394: RAISE FND_API.G_EXC_ERROR;
1395: else
1396: -- write this customized region item if it is validated
1397: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
1398: not AK_CUSTOM_PVT.VALIDATE_CUST_REGION_ITEM (
1399: p_validation_level => p_validation_level,
1400: p_api_version_number => 1.0,
1401: p_return_status => l_return_status,
1402: p_region_application_id => l_cust_region_item_rec.region_application_id,

Line 1424: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUST_REGION_ITEM */

1420: to_char(p_custom_application_id) ||' '||
1421: p_custom_code);
1422: FND_MSG_PUB.Add;
1423: raise FND_API.G_EXC_ERROR;
1424: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUST_REGION_ITEM */
1425:
1426: else
1427: l_index := 1;
1428: l_databuffer_tbl(l_index) := ' ';

Line 1590: not AK_CUSTOM_PVT.VALIDATE_CRITERIA (

1586: loop
1587: fetch l_get_criteria_csr into l_criteria_rec;
1588: exit when l_get_criteria_csr%notfound;
1589: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
1590: not AK_CUSTOM_PVT.VALIDATE_CRITERIA (
1591: p_validation_level => p_validation_level,
1592: p_api_version_number => 1.0,
1593: p_return_status => l_return_status,
1594: p_region_application_id => l_criteria_rec.region_application_id,

Line 1617: end if; /* if AK_CUSTOM_PVT.VALIDATE_CRITERIA */

1613: to_char(p_custom_application_id) ||' '||
1614: p_custom_code);
1615: FND_MSG_PUB.Add;
1616: raise FND_API.G_EXC_ERROR;
1617: end if; /* if AK_CUSTOM_PVT.VALIDATE_CRITERIA */
1618:
1619: else
1620: l_index := 1;
1621: l_databuffer_tbl(l_index) := ' ';

Line 2570: if AK_CUSTOM_PVT.CUSTOM_EXISTS (

2566:
2567: savepoint start_create_custom;
2568:
2569: --** check to see if row already exists **
2570: if AK_CUSTOM_PVT.CUSTOM_EXISTS (
2571: p_api_version_number => 1.0,
2572: p_return_status => l_return_status,
2573: p_custom_appl_id => p_custom_appl_id,
2574: p_custom_code => p_custom_code,

Line 2753: if NOT AK_CUSTOM_PVT.CUSTOM_EXISTS (

2749: p_start_date_active,
2750: l_end_date_active);
2751:
2752: --** row should exists before inserting rows for other languages **
2753: if NOT AK_CUSTOM_PVT.CUSTOM_EXISTS (
2754: p_api_version_number => 1.0,
2755: p_return_status => l_return_status,
2756: p_custom_appl_id => p_custom_appl_id,
2757: p_custom_code => p_custom_code,

Line 2947: if AK_CUSTOM_PVT.CUST_REGION_EXISTS (

2943:
2944: savepoint start_create_cust_region;
2945:
2946: --** check to see if row already exists **
2947: if AK_CUSTOM_PVT.CUST_REGION_EXISTS (
2948: p_api_version_number => 1.0,
2949: p_return_status => l_return_status,
2950: p_custom_appl_id => p_custom_appl_id,
2951: p_custom_code => p_custom_code,

Line 3075: if NOT AK_CUSTOM_PVT.CUST_REGION_EXISTS (

3071: l_last_update_date,
3072: l_last_update_login);
3073:
3074: --** row should exists before inserting rows for other languages **
3075: if NOT AK_CUSTOM_PVT.CUST_REGION_EXISTS (
3076: p_api_version_number => 1.0,
3077: p_return_status => l_return_status,
3078: p_custom_appl_id => p_custom_appl_id,
3079: p_custom_code => p_custom_code,

Line 3275: if AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (

3271:
3272: savepoint start_create_cust_reg_item;
3273:
3274: --** check to see if row already exists **
3275: if AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (
3276: p_api_version_number => 1.0,
3277: p_return_status => l_return_status,
3278: p_custom_appl_id => p_custom_appl_id,
3279: p_custom_code => p_custom_code,

Line 3411: if NOT AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (

3407: l_last_update_date,
3408: l_last_update_login);
3409:
3410: --** row should exists before inserting rows for other languages **
3411: if NOT AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (
3412: p_api_version_number => 1.0,
3413: p_return_status => l_return_status,
3414: p_custom_appl_id => p_custom_appl_id,
3415: p_custom_code => p_custom_code,

Line 3626: if AK_CUSTOM_PVT.CRITERIA_EXISTS (

3622:
3623: savepoint start_create_criteria;
3624:
3625: --** check to see if row already exists **
3626: if AK_CUSTOM_PVT.CRITERIA_EXISTS (
3627: p_api_version_number => 1.0,
3628: p_return_status => l_return_status,
3629: p_custom_appl_id => p_custom_appl_id,
3630: p_custom_code => p_custom_code,

Line 5482: end AK_CUSTOM_PVT;

5478: p_count => p_msg_count,
5479: p_data => p_msg_data);
5480: end UPDATE_CRITERIA;
5481:
5482: end AK_CUSTOM_PVT;