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_PROJECTS_MAINT_UTILS dependencies on FND_API

Line 42: x_return_status:= FND_API.G_RET_STS_SUCCESS;

38: INTO x_organization_id
39: FROM hr_organization_units
40: WHERE name = p_name;
41: END IF;
42: x_return_status:= FND_API.G_RET_STS_SUCCESS;
43: EXCEPTION
44: WHEN no_data_found THEN
45: x_organization_id := NULL ; -- 4537865
46: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 46: x_return_status:= FND_API.G_RET_STS_ERROR;

42: x_return_status:= FND_API.G_RET_STS_SUCCESS;
43: EXCEPTION
44: WHEN no_data_found THEN
45: x_organization_id := NULL ; -- 4537865
46: x_return_status:= FND_API.G_RET_STS_ERROR;
47: x_error_msg_code:= 'PA_INVALID_ORG';
48: WHEN too_many_rows THEN
49: x_organization_id := NULL ; -- 4537865
50: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 50: x_return_status:= FND_API.G_RET_STS_ERROR;

46: x_return_status:= FND_API.G_RET_STS_ERROR;
47: x_error_msg_code:= 'PA_INVALID_ORG';
48: WHEN too_many_rows THEN
49: x_organization_id := NULL ; -- 4537865
50: x_return_status:= FND_API.G_RET_STS_ERROR;
51: x_error_msg_code:= 'PA_ORG_NOT_UNIQUE';
52: WHEN OTHERS THEN
53: x_organization_id := NULL ; -- 4537865
54: x_error_msg_code := SQLCODE ; -- 4537865

Line 55: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

51: x_error_msg_code:= 'PA_ORG_NOT_UNIQUE';
52: WHEN OTHERS THEN
53: x_organization_id := NULL ; -- 4537865
54: x_error_msg_code := SQLCODE ; -- 4537865
55: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
56: RAISE;
57: END Check_org_name_Or_Id;
58:
59: -- API name : check_check_project_status_or_id

Line 99: x_return_status:= FND_API.G_RET_STS_SUCCESS;

95: INTO x_project_status_code
96: FROM pa_project_statuses
97: WHERE project_status_name = p_project_status_name;
98: END IF;
99: x_return_status:= FND_API.G_RET_STS_SUCCESS;
100: EXCEPTION
101: WHEN no_data_found THEN
102: -- 4537865 : RESET x_project_status_code value also
103: x_project_status_code := NULL ;

Line 105: x_return_status:= FND_API.G_RET_STS_ERROR;

101: WHEN no_data_found THEN
102: -- 4537865 : RESET x_project_status_code value also
103: x_project_status_code := NULL ;
104:
105: x_return_status:= FND_API.G_RET_STS_ERROR;
106: x_error_msg_code:= 'PA_PROJECT_STATUS_INVALID';
107: WHEN too_many_rows THEN
108: -- 4537865 : RESET x_project_status_code value also
109: x_project_status_code := NULL ;

Line 110: x_return_status:= FND_API.G_RET_STS_ERROR;

106: x_error_msg_code:= 'PA_PROJECT_STATUS_INVALID';
107: WHEN too_many_rows THEN
108: -- 4537865 : RESET x_project_status_code value also
109: x_project_status_code := NULL ;
110: x_return_status:= FND_API.G_RET_STS_ERROR;
111: x_error_msg_code:= 'PA_PROJECT_STATUS_NOT_UNIQUE';
112: WHEN OTHERS THEN
113: -- 4537865 : RESET x_project_status_code and x_error_msg_code value also
114: x_project_status_code := NULL ;

Line 117: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

113: -- 4537865 : RESET x_project_status_code and x_error_msg_code value also
114: x_project_status_code := NULL ;
115: x_error_msg_code := SQLCODE ;
116:
117: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
118: RAISE;
119: END Check_project_status_Or_Id;
120:
121: -- API name : check_customer_name_or_id

Line 192: x_return_status:= FND_API.G_RET_STS_SUCCESS;

188:
189: -- 4363092 end
190:
191: END IF;
192: x_return_status:= FND_API.G_RET_STS_SUCCESS;
193: EXCEPTION
194: WHEN no_data_found THEN
195:
196: -- 4537865 : RESET x_customer_id also

Line 199: x_return_status:= FND_API.G_RET_STS_ERROR;

195:
196: -- 4537865 : RESET x_customer_id also
197: x_customer_id := NULL ;
198:
199: x_return_status:= FND_API.G_RET_STS_ERROR;
200: x_error_msg_code:= 'PA_CUSTOMER_ID_INVALID';
201: WHEN too_many_rows THEN
202:
203: -- 4537865 : RESET x_customer_id also

Line 206: x_return_status:= FND_API.G_RET_STS_ERROR;

202:
203: -- 4537865 : RESET x_customer_id also
204: x_customer_id := NULL ;
205:
206: x_return_status:= FND_API.G_RET_STS_ERROR;
207: x_error_msg_code:= 'PA_CUS_NAME_NOT UNIQUE';
208: WHEN OTHERS THEN
209:
210: -- 4537865 : RESET x_customer_id and x_error_msg_code also

Line 214: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

210: -- 4537865 : RESET x_customer_id and x_error_msg_code also
211: x_customer_id := NULL ;
212: x_error_msg_code := SQLCODE;
213:
214: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
215: RAISE;
216: END Check_customer_name_Or_Id;
217:
218: -- API name : check_probability_code_or_id

Line 364: x_return_status:= FND_API.G_RET_STS_SUCCESS;

360: x_probability_member_id := NULL;
361: END IF;
362:
363: END IF;
364: x_return_status:= FND_API.G_RET_STS_SUCCESS;
365:
366: EXCEPTION
367: WHEN no_data_found THEN
368: x_probability_member_id := NULL;

Line 369: x_return_status:= FND_API.G_RET_STS_ERROR;

365:
366: EXCEPTION
367: WHEN no_data_found THEN
368: x_probability_member_id := NULL;
369: x_return_status:= FND_API.G_RET_STS_ERROR;
370: x_error_msg_code:= 'PA_PROBABILITY_ID_INVALID';
371: WHEN too_many_rows THEN
372: x_probability_member_id := NULL;
373: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 373: x_return_status:= FND_API.G_RET_STS_ERROR;

369: x_return_status:= FND_API.G_RET_STS_ERROR;
370: x_error_msg_code:= 'PA_PROBABILITY_ID_INVALID';
371: WHEN too_many_rows THEN
372: x_probability_member_id := NULL;
373: x_return_status:= FND_API.G_RET_STS_ERROR;
374: x_error_msg_code:= 'PA_PROBABILITY_NOT_UNIQUE';
375: WHEN OTHERS THEN
376: -- 4537865 : RESET x_error_msg_code also
377: x_error_msg_code := SQLCODE ;

Line 380: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

376: -- 4537865 : RESET x_error_msg_code also
377: x_error_msg_code := SQLCODE ;
378:
379: x_probability_member_id := NULL;
380: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_UTILS', p_procedure_name => 'CHECK_PROBABILITY_CODE_OR_ID');
382: RAISE;
383: END CHECK_PROBABILITY_CODE_OR_ID;
384:

Line 425: x_return_status:= FND_API.G_RET_STS_SUCCESS;

421: INTO x_calendar_id
422: FROM jtf_calendars_vl
423: WHERE calendar_name = p_calendar_name;
424: END IF;
425: x_return_status:= FND_API.G_RET_STS_SUCCESS;
426: EXCEPTION
427: WHEN no_data_found THEN
428: -- 4537865 : RESET x_calendar_id also
429: x_calendar_id := NULL ;

Line 431: x_return_status:= FND_API.G_RET_STS_ERROR;

427: WHEN no_data_found THEN
428: -- 4537865 : RESET x_calendar_id also
429: x_calendar_id := NULL ;
430:
431: x_return_status:= FND_API.G_RET_STS_ERROR;
432: x_error_msg_code:= 'PA_CALENDAR_ID_INVALID';
433: WHEN too_many_rows THEN
434:
435: -- 4537865 : RESET x_calendar_id also

Line 438: x_return_status:= FND_API.G_RET_STS_ERROR;

434:
435: -- 4537865 : RESET x_calendar_id also
436: x_calendar_id := NULL ;
437:
438: x_return_status:= FND_API.G_RET_STS_ERROR;
439: x_error_msg_code:= 'PA_CALENDAR_NOT_UNIQUE';
440: WHEN OTHERS THEN
441:
442: -- 4537865 : RESET x_calendar_id and x_error_msg_code: also

Line 446: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

442: -- 4537865 : RESET x_calendar_id and x_error_msg_code: also
443: x_calendar_id := NULL ;
444: x_error_msg_code := SQLCODE ;
445:
446: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
447: RAISE;
448: END CHECK_CALENDAR_NAME_OR_ID;
449:
450: -- API name : get_project_manager

Line 1193: -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

1189: -- Parameters :
1190: -- p_object_id IN NUMBER
1191: -- p_object_type IN VARCHAR2
1192: -- p_class_category IN VARCHAR2
1193: -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
1194: -- p_code_percentage IN NUMBER
1195: -- x_return_status OUT VARCHAR2
1196: -- x_error_msg_code OUT VARCHAR2
1197: --

Line 1206: p_rowid VARCHAR2 := FND_API.G_MISS_CHAR,

1202: --
1203: PROCEDURE CHECK_CATEGORY_TOTAL_VALID (p_object_id NUMBER,
1204: p_object_type VARCHAR2,
1205: p_class_category VARCHAR2,
1206: p_rowid VARCHAR2 := FND_API.G_MISS_CHAR,
1207: p_code_percentage NUMBER,
1208: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1209: x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1210: IS

Line 1238: if((p_rowid is not null) AND (p_rowid <> FND_API.G_MISS_CHAR)) then

1234: OPEN get_sum;
1235: FETCH get_sum INTO l_sum;
1236: CLOSE get_sum;
1237:
1238: if((p_rowid is not null) AND (p_rowid <> FND_API.G_MISS_CHAR)) then
1239: OPEN get_old_percentage;
1240: FETCH get_old_percentage INTO l_old_category, l_old_percentage;
1241: CLOSE get_old_percentage;
1242:

Line 1486: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1482: AND nvl(enabled_flag, 'Y') = 'Y'
1483: AND sysdate between decode(start_date_active, null, sysdate, start_date_active)
1484: AND decode (end_date_active, null, sysdate, end_date_active);
1485: END IF;
1486: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1487: EXCEPTION
1488: WHEN no_data_found THEN
1489: x_return_status:= FND_API.G_RET_STS_ERROR;
1490: x_error_msg_code:= 'PA_AGREEMENT_CURR_INVALID';

Line 1489: x_return_status:= FND_API.G_RET_STS_ERROR;

1485: END IF;
1486: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1487: EXCEPTION
1488: WHEN no_data_found THEN
1489: x_return_status:= FND_API.G_RET_STS_ERROR;
1490: x_error_msg_code:= 'PA_AGREEMENT_CURR_INVALID';
1491: -- 4537865
1492: x_agreement_currency := NULL ;
1493:

Line 1495: x_return_status:= FND_API.G_RET_STS_ERROR;

1491: -- 4537865
1492: x_agreement_currency := NULL ;
1493:
1494: WHEN too_many_rows THEN
1495: x_return_status:= FND_API.G_RET_STS_ERROR;
1496: x_error_msg_code:= 'PA_CURR_NAME_NOT UNIQUE';
1497: -- 4537865
1498: x_agreement_currency := NULL ;
1499:

Line 1501: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1497: -- 4537865
1498: x_agreement_currency := NULL ;
1499:
1500: WHEN OTHERS THEN
1501: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1502: -- 4537865
1503: x_agreement_currency := NULL ;
1504: x_error_msg_code:= SQLCODE ;
1505:

Line 1551: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1547: INTO x_agreement_org_id
1548: FROM pa_organizations_project_v
1549: WHERE name = p_agreement_org_name;
1550: END IF;
1551: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1552: EXCEPTION
1553: WHEN no_data_found THEN
1554: x_return_status:= FND_API.G_RET_STS_ERROR;
1555: x_error_msg_code:= 'PA_INVALID_ORG';

Line 1554: x_return_status:= FND_API.G_RET_STS_ERROR;

1550: END IF;
1551: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1552: EXCEPTION
1553: WHEN no_data_found THEN
1554: x_return_status:= FND_API.G_RET_STS_ERROR;
1555: x_error_msg_code:= 'PA_INVALID_ORG';
1556: -- 4537865
1557: x_agreement_org_id := NULL ;
1558:

Line 1560: x_return_status:= FND_API.G_RET_STS_ERROR;

1556: -- 4537865
1557: x_agreement_org_id := NULL ;
1558:
1559: WHEN too_many_rows THEN
1560: x_return_status:= FND_API.G_RET_STS_ERROR;
1561: x_error_msg_code:= 'PA_ORG_NOT UNIQUE';
1562: -- 4537865
1563: x_agreement_org_id := NULL ;
1564: WHEN OTHERS THEN

Line 1565: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1561: x_error_msg_code:= 'PA_ORG_NOT UNIQUE';
1562: -- 4537865
1563: x_agreement_org_id := NULL ;
1564: WHEN OTHERS THEN
1565: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1566: -- 4537865
1567: x_agreement_org_id := NULL ;
1568: x_error_msg_code:= SQLCODE ;
1569:

Line 1874: IF (p_organization_id is not null AND p_organization_id <> FND_API.G_MISS_NUM) OR

1870: l_error_msg_code VARCHAR2(250);
1871: BEGIN
1872:
1873: -- First check if the organization has changed
1874: IF (p_organization_id is not null AND p_organization_id <> FND_API.G_MISS_NUM) OR
1875: (p_organization_name is not null AND p_organization_name <> FND_API.G_MISS_CHAR) THEN
1876:
1877: pa_hr_org_utils.Check_OrgName_Or_Id
1878: (p_organization_id => p_organization_id

Line 1875: (p_organization_name is not null AND p_organization_name <> FND_API.G_MISS_CHAR) THEN

1871: BEGIN
1872:
1873: -- First check if the organization has changed
1874: IF (p_organization_id is not null AND p_organization_id <> FND_API.G_MISS_NUM) OR
1875: (p_organization_name is not null AND p_organization_name <> FND_API.G_MISS_CHAR) THEN
1876:
1877: pa_hr_org_utils.Check_OrgName_Or_Id
1878: (p_organization_id => p_organization_id
1879: ,p_organization_name => p_organization_name

Line 1885: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1881: ,x_organization_id => l_organization_id
1882: ,x_return_status => l_return_status
1883: ,x_error_msg_code => l_error_msg_code);
1884:
1885: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1886: return 'N';
1887: END IF;
1888: END IF;
1889:

Line 1995: IF p_classcode_id IS NOT NULL AND p_classcode_id <> FND_API.G_MISS_NUM THEN

1991: BEGIN
1992:
1993: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCode_Name_Or_Id');
1994:
1995: IF p_classcode_id IS NOT NULL AND p_classcode_id <> FND_API.G_MISS_NUM THEN
1996:
1997: IF p_check_id_flag = 'Y' THEN
1998: SELECT class_code_id
1999: INTO x_classcode_id

Line 2054: x_return_status := FND_API.G_RET_STS_SUCCESS;

2050: x_classcode_id := NULL;
2051: END IF;
2052: END IF;
2053:
2054: x_return_status := FND_API.G_RET_STS_SUCCESS;
2055: pa_debug.reset_err_stack;
2056:
2057: EXCEPTION
2058:

Line 2061: x_return_status := FND_API.G_RET_STS_ERROR;

2057: EXCEPTION
2058:
2059: WHEN NO_DATA_FOUND THEN
2060: x_classcode_id := null;
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: x_error_message_code := 'PA_CLASS_CATG_CODE_INVALID';
2063:
2064: WHEN TOO_MANY_ROWS THEN
2065: x_classcode_id := null;

Line 2066: x_return_status := FND_API.G_RET_STS_ERROR;

2062: x_error_message_code := 'PA_CLASS_CATG_CODE_INVALID';
2063:
2064: WHEN TOO_MANY_ROWS THEN
2065: x_classcode_id := null;
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067: x_error_message_code := 'PA_CLASS_CATG_CODE_INVALID';
2068:
2069: WHEN OTHERS THEN
2070: x_classcode_id := null;

Line 2074: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2070: x_classcode_id := null;
2071: fnd_msg_pub.add_exc_msg
2072: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2073: p_procedure_name => pa_debug.g_err_stack );
2074: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2075: -- 4537865
2076: x_error_message_code := SQLCODE ;
2077: RAISE;
2078:

Line 2113: IF p_class_category_id IS NOT NULL AND p_class_category_id <> FND_API.G_MISS_NUM THEN

2109: BEGIN
2110:
2111: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCategory_Name_Or_Id');
2112:
2113: IF p_class_category_id IS NOT NULL AND p_class_category_id <> FND_API.G_MISS_NUM THEN
2114:
2115: IF p_check_id_flag = 'Y' THEN
2116: SELECT class_category_id
2117: INTO x_class_category_id

Line 2170: x_return_status := FND_API.G_RET_STS_SUCCESS;

2166: x_class_category_id := NULL;
2167: END IF;
2168: END IF;
2169:
2170: x_return_status := FND_API.G_RET_STS_SUCCESS;
2171: pa_debug.reset_err_stack;
2172:
2173: EXCEPTION
2174:

Line 2177: x_return_status := FND_API.G_RET_STS_ERROR;

2173: EXCEPTION
2174:
2175: WHEN NO_DATA_FOUND THEN
2176: x_class_category_id := null;
2177: x_return_status := FND_API.G_RET_STS_ERROR;
2178: x_error_message_code := 'PA_CLASS_CATG_INVALID';
2179:
2180: WHEN TOO_MANY_ROWS THEN
2181: x_class_category_id := null;

Line 2182: x_return_status := FND_API.G_RET_STS_ERROR;

2178: x_error_message_code := 'PA_CLASS_CATG_INVALID';
2179:
2180: WHEN TOO_MANY_ROWS THEN
2181: x_class_category_id := null;
2182: x_return_status := FND_API.G_RET_STS_ERROR;
2183: x_error_message_code := 'PA_CLASS_CATG_INVALID';
2184:
2185: WHEN OTHERS THEN
2186: x_class_category_id := null;

Line 2190: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2186: x_class_category_id := null;
2187: fnd_msg_pub.add_exc_msg
2188: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2189: p_procedure_name => pa_debug.g_err_stack );
2190: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2191: -- 4537865
2192: x_error_message_code := SQLCODE ;
2193: RAISE;
2194: