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 121: PA_UTILS.Add_Message( p_app_short_name => 'PA'

117: from fnd_currencies_tl
118: where currency_code = p_price_currency_code
119: AND language = USERENV('LANG');
120: exception when OTHERS then
121: PA_UTILS.Add_Message( p_app_short_name => 'PA'
122: ,p_msg_name => 'PA_CURRENCY_CODE_INV');
123: x_return_status := 'E';
124: end;
125: END IF;

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

141: open c_item_type;
142: fetch c_item_type into cp_type;
143: if (c_item_type%notfound) then
144: close c_item_type;
145: PA_UTILS.Add_Message( p_app_short_name => 'PA'
146: ,p_msg_name => 'PA_CI_INVALID_TYPE_ID');
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: --PA_DEBUG.RESET_ERR_STACK;
149: -- return;

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

158: open c_system_stat;
159: fetch c_system_stat into cp_stat_code;
160: if (c_system_stat%notfound) then
161: close c_system_stat;
162: PA_UTILS.Add_Message( p_app_short_name => 'PA'
163: ,p_msg_name => 'PA_CI_INVALID_STATUS_CODE');
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: -- PA_DEBUG.RESET_ERR_STACK;
166: -- return;

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

210: ELSE
211: l_ci_number_char := p_ci_number;
212:
213: if ci_number_exists(p_project_id, l_ci_number_char ,p_ci_type_id) = TRUE then
214: PA_UTILS.Add_Message( p_app_short_name => 'PA'
215: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: PA_DEBUG.RESET_ERR_STACK;
218: return;

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

221: END IF;
222:
223:
224: IF l_ci_number_char is NULL and l_system_status_code <> DRAFT_STATUS THEN
225: PA_UTILS.Add_Message( p_app_short_name => 'PA'
226: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: PA_DEBUG.Reset_Err_Stack;
229: RETURN;

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

466: OPEN curr_row;
467: FETCH curr_row INTO cp;
468: if curr_row%NOTFOUND then
469: close curr_row;
470: PA_UTILS.Add_Message( p_app_short_name => 'PA'
471: ,p_msg_name => 'PA_CI_INVALID_ITEM');
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: return;
474: PA_DEBUG.Reset_Err_Stack;

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

509: from fnd_currencies_tl
510: where currency_code = p_price_currency_code
511: AND language = USERENV('LANG');
512: exception when OTHERS then
513: PA_UTILS.Add_Message( p_app_short_name => 'PA'
514: ,p_msg_name => 'PA_CURRENCY_CODE_INV');
515: x_return_status := 'E';
516: end;
517: END IF;

Line 522: PA_UTILS.Add_Message(

518:
519: OPEN c_auto_num;
520: FETCH c_auto_num INTO l_auto_numbers;
521: if c_auto_num%NOTFOUND then
522: PA_UTILS.Add_Message(
523: p_app_short_name => 'PA'
524: ,p_msg_name => 'PA_CI_INVALID_TYPE_ID');
525: x_return_status := 'E';
526: close c_auto_num;

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

538: if (C%notfound) then
539: close C;
540: else
541: close C;
542: PA_UTILS.Add_Message( p_app_short_name => 'PA'
543: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: PA_DEBUG.Reset_Err_Stack;
546: return;

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

548: else
549: -- ci number may not be NULL in non CI_DRAFT status
550: l_ci_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_status_code);
551: if l_ci_system_status is NULL then
552: PA_UTILS.Add_Message( p_app_short_name => 'PA'
553: ,p_msg_name => 'PA_CI_NO_STATUS');
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: PA_DEBUG.Reset_Err_Stack;
556: return;

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

555: PA_DEBUG.Reset_Err_Stack;
556: return;
557: end if;
558: if 'CI_DRAFT' <> l_ci_system_status then
559: PA_UTILS.Add_Message( p_app_short_name => 'PA'
560: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: PA_DEBUG.Reset_Err_Stack;
563: return;

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

704: SAVEPOINT delete_control_item;
705: END IF;
706:
707: IF p_ci_id is NULL THEN
708: PA_UTILS.Add_Message( p_app_short_name => 'PA'
709: ,p_msg_name => 'PA_CI_INVALID_ITEM');
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: ELSE
712: open valid_ci;

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

712: open valid_ci;
713: fetch valid_ci into l_status_code;
714: if (valid_ci%notfound) then
715: --- invalid ci_id error
716: PA_UTILS.Add_Message( p_app_short_name => 'PA'
717: ,p_msg_name => 'PA_CI_INVALID_ITEM');
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: else
720: if (l_status_code <> 'CI_DRAFT') then

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

718: x_return_status := FND_API.G_RET_STS_ERROR;
719: else
720: if (l_status_code <> 'CI_DRAFT') then
721: --- invalid status error
722: PA_UTILS.Add_Message( p_app_short_name => 'PA'
723: ,p_msg_name => 'PA_CI_ONLY_DRAFT_DEL');
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: end if;
726: end if;

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

990: OPEN c_from_item;
991: FETCH c_from_item INTO copy_from_row;
992: if c_from_item%NOTFOUND then
993: close c_from_item;
994: PA_UTILS.Add_Message( p_app_short_name => 'PA'
995: ,p_msg_name => 'PA_CI_NO_FROM_ITEM');
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: end if;
998:

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

999: ---- check that impacts of source ci_id_from should be less than or equalto the
1000: ---- impacts of the destination ci_type_id. (i.e. new ci)
1001: if (x_return_status = 'S' and p_include = 'Y') then
1002: if (pa_control_items_utils.IsImpactOkToInclude(p_ci_type_id, null, p_ci_id_from) <> 'Y') then
1003: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1004: ,p_msg_name => 'PA_CI_NO_IMP_INCLUDE');
1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006: end if;
1007: end if;

Line 1253: PA_UTILS.Add_Message(

1249: l_ci_id := p_from_ci_id;
1250: OPEN check_params;
1251: FETCH check_params INTO cp;
1252: if check_params%NOTFOUND then
1253: PA_UTILS.Add_Message(
1254: p_app_short_name => 'PA'
1255: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1256: else
1257: l_project_id := cp.project_id;

Line 1259: PA_UTILS.Add_Message(

1255: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1256: else
1257: l_project_id := cp.project_id;
1258: if (cp.ci_type_class_code <> 'CHANGE_ORDER') then
1259: PA_UTILS.Add_Message(
1260: p_app_short_name => 'PA'
1261: ,p_msg_name => 'PA_CI_INCL_CR_IN_CO');
1262: end if;
1263: l_ci_type_id_to := cp.ci_type_id;

Line 1272: PA_UTILS.Add_Message(

1268: l_ci_id := p_to_ci_id;
1269: OPEN check_params;
1270: FETCH check_params INTO cp;
1271: if check_params%NOTFOUND then
1272: PA_UTILS.Add_Message(
1273: p_app_short_name => 'PA'
1274: ,p_msg_name => 'PA_CI_NO_INCLUDE_ITEM');
1275: else
1276: if (l_project_id <> cp.project_id) then

Line 1277: PA_UTILS.Add_Message(

1273: p_app_short_name => 'PA'
1274: ,p_msg_name => 'PA_CI_NO_INCLUDE_ITEM');
1275: else
1276: if (l_project_id <> cp.project_id) then
1277: PA_UTILS.Add_Message(
1278: p_app_short_name => 'PA'
1279: ,p_msg_name => 'PA_CI_INC_DIFF_PROJ');
1280: x_return_status := 'E';
1281: end if;

Line 1284: PA_UTILS.Add_Message(

1280: x_return_status := 'E';
1281: end if;
1282:
1283: if (cp.project_system_status_code <> 'CI_APPROVED') then
1284: PA_UTILS.Add_Message(
1285: p_app_short_name => 'PA'
1286: ,p_msg_name => 'PA_CI_INC_STAT_INV');
1287: x_return_status := 'E';
1288: end if;

Line 1291: PA_UTILS.Add_Message(

1287: x_return_status := 'E';
1288: end if;
1289:
1290: if (cp.ci_type_class_code <> 'CHANGE_REQUEST') then
1291: PA_UTILS.Add_Message(
1292: p_app_short_name => 'PA'
1293: ,p_msg_name => 'PA_CI_INCL_CR_IN_CO');
1294: end if;
1295: l_ci_type_id_from := cp.ci_type_id;

Line 1440: PA_UTILS.Add_Message(

1436: x_return_status := 'S';
1437: OPEN curr_number;
1438: FETCH curr_number INTO cp;
1439: if curr_number%NOTFOUND then
1440: PA_UTILS.Add_Message(
1441: p_app_short_name => 'PA'
1442: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1443: x_return_status := 'E';
1444: else

Line 1608: PA_UTILS.Add_Message(

1604:
1605: OPEN c_curr_item ;
1606: FETCH c_curr_item INTO cp;
1607: if c_curr_item%NOTFOUND then
1608: PA_UTILS.Add_Message(
1609: p_app_short_name => 'PA'
1610: ,p_msg_name => 'PA_CI_INVALID_ITEM');
1611: x_return_status := 'E';
1612: close c_curr_item;

Line 1621: PA_UTILS.Add_Message(

1617:
1618: OPEN c_auto_num;
1619: FETCH c_auto_num INTO l_auto_numbers, l_type_id, l_type_class;
1620: if c_auto_num%NOTFOUND then
1621: PA_UTILS.Add_Message(
1622: p_app_short_name => 'PA'
1623: ,p_msg_name => 'PA_CI_INVALID_TYPE_ID');
1624: x_return_status := 'E';
1625: close c_auto_num;

Line 1645: PA_UTILS.Add_Message(

1641:
1642: if l_new_system_status_code is not NULL and l_new_system_status_code = 'CI_WORKING' then
1643: if l_curr_system_status_code is not null and l_curr_system_status_code = 'CI_DRAFT' then
1644: if l_ci_number_char is NULL AND l_auto_numbers <> 'Y' then
1645: PA_UTILS.Add_Message(
1646: p_app_short_name => 'PA'
1647: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
1648: x_return_status := 'E';
1649: PA_DEBUG.Reset_Err_Stack;

Line 1693: PA_UTILS.Add_Message(

1689: ,l_type_id) = FALSE;
1690: END LOOP;
1691:
1692: if l_ci_number_char is NULL THEN
1693: PA_UTILS.Add_Message(
1694: p_app_short_name => 'PA'
1695: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
1696: x_return_status := 'E';
1697: PA_DEBUG.Reset_Err_Stack;

Line 1707: -- PA_UTILS.Add_Message(

1703:
1704: if l_new_system_status_code is not NULL and l_new_system_status_code = 'CI_CLOSED' then
1705: if l_curr_system_status_code is not null and l_curr_system_status_code <> 'CI_CLOSED' then
1706: -- IF PA_CI_ACTIONS_UTILS.CHECK_OPEN_ACTIONS_EXIST = 'Y' then
1707: -- PA_UTILS.Add_Message(
1708: -- p_app_short_name => 'PA'
1709: -- ,p_msg_name => 'PA_CI_OPEN_ACTION_EXISTS');--for SUBMIT!!!
1710: -- x_return_status := 'E';
1711: -- PA_DEBUG.Reset_Err_Stack;

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

1835: l_null_data BOOLEAN := FALSE;
1836: BEGIN
1837:
1838: IF p_ci_type_id is NULL THEN
1839: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1840: ,p_msg_name => 'PA_CI_NO_TYPE');
1841: l_null_data := TRUE;
1842: END IF;
1843: IF p_project_id is NULL THEN

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

1840: ,p_msg_name => 'PA_CI_NO_TYPE');
1841: l_null_data := TRUE;
1842: END IF;
1843: IF p_project_id is NULL THEN
1844: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1845: ,p_msg_name => 'PA_CI_NO_PROJECT_ID');
1846: l_null_data := TRUE;
1847: END IF;
1848: IF p_status_code is NULL THEN

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

1845: ,p_msg_name => 'PA_CI_NO_PROJECT_ID');
1846: l_null_data := TRUE;
1847: END IF;
1848: IF p_status_code is NULL THEN
1849: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1850: ,p_msg_name => 'PA_CI_NO_STATUS');
1851: l_null_data := TRUE;
1852: END IF;
1853: IF p_owner_id is NULL THEN

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

1850: ,p_msg_name => 'PA_CI_NO_STATUS');
1851: l_null_data := TRUE;
1852: END IF;
1853: IF p_owner_id is NULL THEN
1854: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1855: ,p_msg_name => 'PA_CI_NO_OWNER');
1856: l_null_data := TRUE;
1857: END IF;
1858:

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

1856: l_null_data := TRUE;
1857: END IF;
1858:
1859: IF p_summary is NULL THEN
1860: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1861: ,p_msg_name => 'PA_CI_NO_SUMMARY');
1862: l_null_data := TRUE;
1863: END IF;
1864:

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

1970: ,x_msg_count => x_msg_count
1971: ,x_msg_data => x_msg_data);
1972:
1973: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1974: PA_UTILS.Add_Message (p_app_short_name => 'PA'
1975: ,p_msg_name => x_msg_data);
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;
1978: END LOOP;