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.PA_CONTROL_ITEMS_PVT dependencies on PA_UTILS

Line 134: PA_UTILS.Add_Message( p_app_short_name => 'PA'

130: from fnd_currencies_tl
131: where currency_code = p_price_currency_code
132: AND language = USERENV('LANG');
133: exception when OTHERS then
134: PA_UTILS.Add_Message( p_app_short_name => 'PA'
135: ,p_msg_name => 'PA_CURRENCY_CODE_INV');
136: x_return_status := 'E';
137: end;
138: END IF;

Line 158: PA_UTILS.Add_Message( p_app_short_name => 'PA'

154: open c_item_type;
155: fetch c_item_type into cp_type;
156: if (c_item_type%notfound) then
157: close c_item_type;
158: PA_UTILS.Add_Message( p_app_short_name => 'PA'
159: ,p_msg_name => 'PA_CI_INVALID_TYPE_ID');
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: --PA_DEBUG.RESET_ERR_STACK;
162: -- return;

Line 175: PA_UTILS.Add_Message( p_app_short_name => 'PA'

171: open c_system_stat;
172: fetch c_system_stat into cp_stat_code;
173: if (c_system_stat%notfound) then
174: close c_system_stat;
175: PA_UTILS.Add_Message( p_app_short_name => 'PA'
176: ,p_msg_name => 'PA_CI_INVALID_STATUS_CODE');
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: -- PA_DEBUG.RESET_ERR_STACK;
179: -- return;

Line 227: PA_UTILS.Add_Message( p_app_short_name => 'PA'

223: ELSE
224: l_ci_number_char := p_ci_number;
225:
226: if ci_number_exists(p_project_id, l_ci_number_char ,p_ci_type_id) = TRUE then
227: PA_UTILS.Add_Message( p_app_short_name => 'PA'
228: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: PA_DEBUG.RESET_ERR_STACK;
231: return;

Line 238: PA_UTILS.Add_Message( p_app_short_name => 'PA'

234: END IF;
235:
236:
237: IF l_ci_number_char is NULL and l_system_status_code <> DRAFT_STATUS THEN
238: PA_UTILS.Add_Message( p_app_short_name => 'PA'
239: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: PA_DEBUG.Reset_Err_Stack;
242: RETURN;

Line 514: PA_UTILS.Add_Message( p_app_short_name => 'PA'

510: OPEN curr_row;
511: FETCH curr_row INTO cp;
512: if curr_row%NOTFOUND then
513: close curr_row;
514: PA_UTILS.Add_Message( p_app_short_name => 'PA'
515: ,p_msg_name => 'PA_CI_INVALID_ITEM');
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: return;
518: PA_DEBUG.Reset_Err_Stack;

Line 557: PA_UTILS.Add_Message( p_app_short_name => 'PA'

553: from fnd_currencies_tl
554: where currency_code = p_price_currency_code
555: AND language = USERENV('LANG');
556: exception when OTHERS then
557: PA_UTILS.Add_Message( p_app_short_name => 'PA'
558: ,p_msg_name => 'PA_CURRENCY_CODE_INV');
559: x_return_status := 'E';
560: end;
561: END IF;

Line 566: PA_UTILS.Add_Message(

562:
563: OPEN c_auto_num;
564: FETCH c_auto_num INTO l_auto_numbers;
565: if c_auto_num%NOTFOUND then
566: PA_UTILS.Add_Message(
567: p_app_short_name => 'PA'
568: ,p_msg_name => 'PA_CI_INVALID_TYPE_ID');
569: x_return_status := 'E';
570: close c_auto_num;

Line 579: PA_UTILS.Add_Message(

575:
576:
577: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
578: IF nvl(cp.LOCKED_FLAG, 'N') = 'Y' AND p_LOCKED_FLAG <> 'X' THEN
579: PA_UTILS.Add_Message(
580: p_app_short_name => 'PA'
581: ,p_msg_name => 'PA_CI_CONTROL_ITEM_IS_LOCKED'
582: ,p_token1 => 'TOKEN'
583: ,p_value1 => cp.ci_number);

Line 605: PA_UTILS.Add_Message( p_app_short_name => 'PA'

601: if (C%notfound) then
602: close C;
603: else
604: close C;
605: PA_UTILS.Add_Message( p_app_short_name => 'PA'
606: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: PA_DEBUG.Reset_Err_Stack;
609: return;

Line 615: PA_UTILS.Add_Message( p_app_short_name => 'PA'

611: else
612: -- ci number may not be NULL in non CI_DRAFT status
613: l_ci_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_status_code);
614: if l_ci_system_status is NULL then
615: PA_UTILS.Add_Message( p_app_short_name => 'PA'
616: ,p_msg_name => 'PA_CI_NO_STATUS');
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: PA_DEBUG.Reset_Err_Stack;
619: return;

Line 622: PA_UTILS.Add_Message( p_app_short_name => 'PA'

618: PA_DEBUG.Reset_Err_Stack;
619: return;
620: end if;
621: if 'CI_DRAFT' <> l_ci_system_status then
622: PA_UTILS.Add_Message( p_app_short_name => 'PA'
623: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: PA_DEBUG.Reset_Err_Stack;
626: return;

Line 784: PA_UTILS.Add_Message( p_app_short_name => 'PA'

780: SAVEPOINT delete_control_item;
781: END IF;
782:
783: IF p_ci_id is NULL THEN
784: PA_UTILS.Add_Message( p_app_short_name => 'PA'
785: ,p_msg_name => 'PA_CI_INVALID_ITEM');
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: ELSE
788: open valid_ci;

Line 792: PA_UTILS.Add_Message( p_app_short_name => 'PA'

788: open valid_ci;
789: fetch valid_ci into l_status_code;
790: if (valid_ci%notfound) then
791: --- invalid ci_id error
792: PA_UTILS.Add_Message( p_app_short_name => 'PA'
793: ,p_msg_name => 'PA_CI_INVALID_ITEM');
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: else
796: if (l_status_code <> 'CI_DRAFT') then

Line 798: PA_UTILS.Add_Message( p_app_short_name => 'PA'

794: x_return_status := FND_API.G_RET_STS_ERROR;
795: else
796: if (l_status_code <> 'CI_DRAFT') then
797: --- invalid status error
798: PA_UTILS.Add_Message( p_app_short_name => 'PA'
799: ,p_msg_name => 'PA_CI_ONLY_DRAFT_DEL');
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: end if;
802: end if;

Line 1082: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1078: OPEN c_from_item;
1079: FETCH c_from_item INTO copy_from_row;
1080: if c_from_item%NOTFOUND then
1081: close c_from_item;
1082: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1083: ,p_msg_name => 'PA_CI_NO_FROM_ITEM');
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085: end if;
1086:

Line 1091: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1087: ---- check that impacts of source ci_id_from should be less than or equalto the
1088: ---- impacts of the destination ci_type_id. (i.e. new ci)
1089: if (x_return_status = 'S' and p_include = 'Y') then
1090: if (pa_control_items_utils.IsImpactOkToInclude(p_ci_type_id, null, p_ci_id_from) <> 'Y') then
1091: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1092: ,p_msg_name => 'PA_CI_NO_IMP_INCLUDE');
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: end if;
1095: end if;

Line 1386: PA_UTILS.Add_Message(

1382: l_ci_id := p_from_ci_id;
1383: OPEN check_params;
1384: FETCH check_params INTO cp;
1385: if check_params%NOTFOUND then
1386: PA_UTILS.Add_Message(
1387: p_app_short_name => 'PA'
1388: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1389: else
1390: l_project_id := cp.project_id;

Line 1392: PA_UTILS.Add_Message(

1388: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1389: else
1390: l_project_id := cp.project_id;
1391: if (cp.ci_type_class_code <> 'CHANGE_ORDER') then
1392: PA_UTILS.Add_Message(
1393: p_app_short_name => 'PA'
1394: ,p_msg_name => 'PA_CI_INCL_CR_IN_CO');
1395: end if;
1396: l_ci_type_id_to := cp.ci_type_id;

Line 1405: PA_UTILS.Add_Message(

1401: l_ci_id := p_to_ci_id;
1402: OPEN check_params;
1403: FETCH check_params INTO cp;
1404: if check_params%NOTFOUND then
1405: PA_UTILS.Add_Message(
1406: p_app_short_name => 'PA'
1407: ,p_msg_name => 'PA_CI_NO_INCLUDE_ITEM');
1408: else
1409: if (l_project_id <> cp.project_id) then

Line 1410: PA_UTILS.Add_Message(

1406: p_app_short_name => 'PA'
1407: ,p_msg_name => 'PA_CI_NO_INCLUDE_ITEM');
1408: else
1409: if (l_project_id <> cp.project_id) then
1410: PA_UTILS.Add_Message(
1411: p_app_short_name => 'PA'
1412: ,p_msg_name => 'PA_CI_INC_DIFF_PROJ');
1413: x_return_status := 'E';
1414: end if;

Line 1417: PA_UTILS.Add_Message(

1413: x_return_status := 'E';
1414: end if;
1415:
1416: if (cp.project_system_status_code <> 'CI_APPROVED') then
1417: PA_UTILS.Add_Message(
1418: p_app_short_name => 'PA'
1419: ,p_msg_name => 'PA_CI_INC_STAT_INV');
1420: x_return_status := 'E';
1421: end if;

Line 1424: PA_UTILS.Add_Message(

1420: x_return_status := 'E';
1421: end if;
1422:
1423: if (cp.ci_type_class_code <> 'CHANGE_REQUEST') then
1424: PA_UTILS.Add_Message(
1425: p_app_short_name => 'PA'
1426: ,p_msg_name => 'PA_CI_INCL_CR_IN_CO');
1427: end if;
1428: l_ci_type_id_from := cp.ci_type_id;

Line 1573: PA_UTILS.Add_Message(

1569: x_return_status := 'S';
1570: OPEN curr_number;
1571: FETCH curr_number INTO cp;
1572: if curr_number%NOTFOUND then
1573: PA_UTILS.Add_Message(
1574: p_app_short_name => 'PA'
1575: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1576: x_return_status := 'E';
1577: else

Line 1757: PA_UTILS.Add_Message(

1753:
1754: OPEN c_curr_item ;
1755: FETCH c_curr_item INTO cp;
1756: if c_curr_item%NOTFOUND then
1757: PA_UTILS.Add_Message(
1758: p_app_short_name => 'PA'
1759: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1760: x_return_status := 'E';
1761: close c_curr_item;

Line 1770: PA_UTILS.Add_Message(

1766:
1767: OPEN c_auto_num;
1768: FETCH c_auto_num INTO l_auto_numbers, l_type_id, l_type_class;
1769: if c_auto_num%NOTFOUND then
1770: PA_UTILS.Add_Message(
1771: p_app_short_name => 'PA'
1772: ,p_msg_name => 'PA_CI_INVALID_TYPE_ID');
1773: x_return_status := 'E';
1774: close c_auto_num;

Line 1794: PA_UTILS.Add_Message(

1790:
1791: if l_new_system_status_code is not NULL and l_new_system_status_code = 'CI_WORKING' then
1792: if l_curr_system_status_code is not null and l_curr_system_status_code = 'CI_DRAFT' then
1793: if l_ci_number_char is NULL AND l_auto_numbers <> 'Y' then
1794: PA_UTILS.Add_Message(
1795: p_app_short_name => 'PA'
1796: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
1797: x_return_status := 'E';
1798: PA_DEBUG.Reset_Err_Stack;

Line 1842: PA_UTILS.Add_Message(

1838: ,l_type_id) = FALSE;
1839: END LOOP;
1840:
1841: if l_ci_number_char is NULL THEN
1842: PA_UTILS.Add_Message(
1843: p_app_short_name => 'PA'
1844: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
1845: x_return_status := 'E';
1846: PA_DEBUG.Reset_Err_Stack;

Line 1856: -- PA_UTILS.Add_Message(

1852:
1853: if l_new_system_status_code is not NULL and l_new_system_status_code = 'CI_CLOSED' then
1854: if l_curr_system_status_code is not null and l_curr_system_status_code <> 'CI_CLOSED' then
1855: -- IF PA_CI_ACTIONS_UTILS.CHECK_OPEN_ACTIONS_EXIST = 'Y' then
1856: -- PA_UTILS.Add_Message(
1857: -- p_app_short_name => 'PA'
1858: -- ,p_msg_name => 'PA_CI_OPEN_ACTION_EXISTS');--for SUBMIT!!!
1859: -- x_return_status := 'E';
1860: -- PA_DEBUG.Reset_Err_Stack;

Line 2004: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2000: l_null_data BOOLEAN := FALSE;
2001: BEGIN
2002:
2003: IF p_ci_type_id is NULL THEN
2004: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2005: ,p_msg_name => 'PA_CI_NO_TYPE');
2006: l_null_data := TRUE;
2007: END IF;
2008: IF p_project_id is NULL THEN

Line 2009: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2005: ,p_msg_name => 'PA_CI_NO_TYPE');
2006: l_null_data := TRUE;
2007: END IF;
2008: IF p_project_id is NULL THEN
2009: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2010: ,p_msg_name => 'PA_CI_NO_PROJECT_ID');
2011: l_null_data := TRUE;
2012: END IF;
2013: IF p_status_code is NULL THEN

Line 2014: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2010: ,p_msg_name => 'PA_CI_NO_PROJECT_ID');
2011: l_null_data := TRUE;
2012: END IF;
2013: IF p_status_code is NULL THEN
2014: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2015: ,p_msg_name => 'PA_CI_NO_STATUS');
2016: l_null_data := TRUE;
2017: END IF;
2018: IF p_owner_id is NULL THEN

Line 2019: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2015: ,p_msg_name => 'PA_CI_NO_STATUS');
2016: l_null_data := TRUE;
2017: END IF;
2018: IF p_owner_id is NULL THEN
2019: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2020: ,p_msg_name => 'PA_CI_NO_OWNER');
2021: l_null_data := TRUE;
2022: END IF;
2023:

Line 2025: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2021: l_null_data := TRUE;
2022: END IF;
2023:
2024: IF p_summary is NULL THEN
2025: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2026: ,p_msg_name => 'PA_CI_NO_SUMMARY');
2027: l_null_data := TRUE;
2028: END IF;
2029:

Line 2139: PA_UTILS.Add_Message (p_app_short_name => 'PA'

2135: ,x_msg_count => x_msg_count
2136: ,x_msg_data => x_msg_data);
2137:
2138: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2139: PA_UTILS.Add_Message (p_app_short_name => 'PA'
2140: ,p_msg_name => x_msg_data);
2141: RAISE FND_API.G_EXC_ERROR;
2142: END IF;
2143: END LOOP;

Line 2702: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2698: SAVEPOINT lock_control_item;
2699: END IF;
2700:
2701: IF p_ci_id is NULL THEN
2702: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2703: ,p_msg_name => 'PA_CI_INVALID_ITEM');
2704: x_return_status := FND_API.G_RET_STS_ERROR;
2705: ELSE
2706: open valid_ci;

Line 2710: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2706: open valid_ci;
2707: fetch valid_ci into l_status_code;
2708: if (valid_ci%notfound) then
2709: --- invalid ci_id error
2710: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2711: ,p_msg_name => 'PA_CI_INVALID_ITEM');
2712: x_return_status := FND_API.G_RET_STS_ERROR;
2713: end if;
2714: close valid_ci;

Line 2722: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2718: OPEN curr_row;
2719: FETCH curr_row INTO cp;
2720: if curr_row%NOTFOUND then
2721: close curr_row;
2722: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2723: ,p_msg_name => 'PA_CI_INVALID_ITEM');
2724: x_return_status := FND_API.G_RET_STS_ERROR;
2725: return;
2726: PA_DEBUG.Reset_Err_Stack;