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_CRITERIA

Line 1572: from AK_CRITERIA

1568: p_nls_language IN VARCHAR2
1569: ) is
1570: cursor l_get_criteria_csr is
1571: select *
1572: from AK_CRITERIA
1573: where REGION_APPLICATION_ID = p_region_application_id
1574: and REGION_CODE = p_region_code
1575: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
1576: and CUSTOMIZATION_CODE = p_custom_code;

Line 1580: l_criteria_rec AK_CRITERIA%ROWTYPE;

1576: and CUSTOMIZATION_CODE = p_custom_code;
1577: l_api_name CONSTANT varchar2(30) := 'Write_Criteria_to_buffer';
1578: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1579: l_index NUMBER;
1580: l_criteria_rec AK_CRITERIA%ROWTYPE;
1581: l_return_status varchar2(1);
1582: begin
1583: -- Retrieve customization criteria information from the database
1584:

Line 1610: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_DOWNLOADED');

1606: p_end_date_active => l_criteria_rec.end_date_active,
1607: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1608: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1609: close l_get_criteria_csr;
1610: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_DOWNLOADED');
1611: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1612: p_region_code ||' '||
1613: to_char(p_custom_application_id) ||' '||
1614: p_custom_code);

Line 1715: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');

1711: p_return_status := FND_API.G_RET_STS_SUCCESS;
1712: EXCEPTION
1713: WHEN VALUE_ERROR THEN
1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
1716: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1717: ' ' || p_region_code ||
1718: ' ' || to_char(p_custom_application_id) ||
1719: ' ' || p_custom_code || ' ' ||

Line 3637: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_EXISTS');

3633: p_attribute_appl_id => p_attr_appl_id,
3634: p_attribute_code => p_attr_code,
3635: p_sequence_number => p_sequence_number) then
3636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3637: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_EXISTS');
3638: FND_MSG_PUB.Add;
3639: end if;
3640: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3641: raise FND_API.G_EXC_ERROR;

Line 3734: insert into AK_CRITERIA (

3730:
3731: select userenv('LANG') into l_lang
3732: from dual;
3733:
3734: insert into AK_CRITERIA (
3735: CUSTOMIZATION_APPLICATION_ID,
3736: CUSTOMIZATION_CODE,
3737: REGION_APPLICATION_ID,
3738: REGION_CODE,

Line 3777: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_CREATED');

3773: -- /** commit the insert **/
3774: commit;
3775:
3776: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3777: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_CREATED');
3778: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CRITERIA',TRUE);
3779: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3780: ' ' || p_custom_code || ' ' ||
3781: to_char(p_region_appl_id) || ' ' ||

Line 3797: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');

3793:
3794: EXCEPTION
3795: WHEN VALUE_ERROR THEN
3796: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3797: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
3798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3799: ' ' || p_custom_code || ' ' ||
3800: to_char(p_region_appl_id) || ' ' ||
3801: p_region_code || ' ' ||

Line 3813: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_CREATED');

3809: p_count => p_msg_count,
3810: p_data => p_msg_data);
3811: WHEN FND_API.G_EXC_ERROR THEN
3812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3813: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_CREATED');
3814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3815: ' ' || p_custom_code || ' ' ||
3816: to_char(p_region_appl_id) || ' ' ||
3817: p_region_code || ' ' ||

Line 4104: from AK_CRITERIA

4100: p_sequence_number IN NUMBER
4101: ) return BOOLEAN is
4102: cursor l_check_csr is
4103: select 1
4104: from AK_CRITERIA
4105: where region_application_id = p_region_application_id
4106: and region_code = p_region_code
4107: and customization_application_id = p_custom_appl_id
4108: and customization_code = p_custom_code

Line 5248: from AK_CRITERIA

5244: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
5245: ) is
5246: cursor l_get_row_csr is
5247: select *
5248: from AK_CRITERIA
5249: where CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
5250: and CUSTOMIZATION_CODE = p_custom_code
5251: and REGION_APPLICATION_ID = p_region_application_id
5252: and REGION_CODE = p_region_code

Line 5261: l_criteria_rec ak_criteria%ROWTYPE;

5257: l_api_version_number CONSTANT number := 1.0;
5258: l_api_name CONSTANT varchar2(30) := 'Update_Criteria';
5259: l_created_by number;
5260: l_creation_date date;
5261: l_criteria_rec ak_criteria%ROWTYPE;
5262: l_error boolean;
5263: l_last_update_date date;
5264: l_last_update_login number;
5265: l_last_updated_by number;

Line 5285: -- retrieve ak_criteria row if it exists

5281: end if;
5282:
5283: savepoint start_update_criteria;
5284:
5285: --** retrieve ak_criteria row if it exists **
5286: open l_get_row_csr;
5287: fetch l_get_row_csr into l_criteria_rec;
5288: if (l_get_row_csr%notfound) then
5289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 5290: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_DOES_NOT_EXIST');

5286: open l_get_row_csr;
5287: fetch l_get_row_csr into l_criteria_rec;
5288: if (l_get_row_csr%notfound) then
5289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5290: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_DOES_NOT_EXIST');
5291: FND_MSG_PUB.Add;
5292: end if;
5293: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5294: close l_get_row_csr;

Line 5401: update AK_CRITERIA set

5397: p_create_or_update => 'UPDATE') then
5398: null;
5399: end if;
5400:
5401: update AK_CRITERIA set
5402: OPERATION = l_criteria_rec.operation,
5403: VALUE_VARCHAR2 = l_criteria_rec.value_varchar2,
5404: VALUE_NUMBER = l_criteria_rec.value_number,
5405: VALUE_DATE = l_criteria_rec.value_date,

Line 5420: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATE_FAILED');

5416: and ATTRIBUTE_CODE = p_attribute_code
5417: and SEQUENCE_NUMBER = p_sequence_number;
5418: if (sql%notfound) then
5419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5420: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATE_FAILED');
5421: FND_MSG_PUB.Add;
5422: end if;
5423: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
5424: raise FND_API.G_EXC_ERROR;

Line 5431: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATED');

5427: -- /** commit the update **/
5428: -- commit;
5429:
5430: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5431: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATED');
5432: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5433: ' ' || p_region_code ||
5434: ' ' || to_char(p_custom_appl_id) ||
5435: ' ' || p_custom_code || ' ' ||

Line 5449: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');

5445:
5446: EXCEPTION
5447: WHEN VALUE_ERROR THEN
5448: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5449: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
5450: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5451: ' ' || p_region_code ||
5452: ' ' || to_char(p_custom_appl_id) ||
5453: ' ' || p_custom_code || ' ' ||

Line 5464: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_UPDATED');

5460: p_count => p_msg_count,
5461: p_data => p_msg_data);
5462: WHEN FND_API.G_EXC_ERROR THEN
5463: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5464: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_UPDATED');
5465: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5466: ' ' || p_region_code ||
5467: ' ' || to_char(p_custom_appl_id) ||
5468: ' ' || p_custom_code || ' ' ||