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 1206: -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

1202: -- Parameters :
1203: -- p_object_id IN NUMBER
1204: -- p_object_type IN VARCHAR2
1205: -- p_class_category IN VARCHAR2
1206: -- p_rowid IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
1207: -- p_code_percentage IN NUMBER
1208: -- x_return_status OUT VARCHAR2
1209: -- x_error_msg_code OUT VARCHAR2
1210: --

Line 1219: p_rowid VARCHAR2 := FND_API.G_MISS_CHAR,

1215: --
1216: PROCEDURE CHECK_CATEGORY_TOTAL_VALID (p_object_id NUMBER,
1217: p_object_type VARCHAR2,
1218: p_class_category VARCHAR2,
1219: p_rowid VARCHAR2 := FND_API.G_MISS_CHAR,
1220: p_code_percentage NUMBER,
1221: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1222: x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1223: IS

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

1247: OPEN get_sum;
1248: FETCH get_sum INTO l_sum;
1249: CLOSE get_sum;
1250:
1251: if((p_rowid is not null) AND (p_rowid <> FND_API.G_MISS_CHAR)) then
1252: OPEN get_old_percentage;
1253: FETCH get_old_percentage INTO l_old_category, l_old_percentage;
1254: CLOSE get_old_percentage;
1255:

Line 1499: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1495: AND nvl(enabled_flag, 'Y') = 'Y'
1496: AND sysdate between decode(start_date_active, null, sysdate, start_date_active)
1497: AND decode (end_date_active, null, sysdate, end_date_active);
1498: END IF;
1499: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1500: EXCEPTION
1501: WHEN no_data_found THEN
1502: x_return_status:= FND_API.G_RET_STS_ERROR;
1503: x_error_msg_code:= 'PA_AGREEMENT_CURR_INVALID';

Line 1502: x_return_status:= FND_API.G_RET_STS_ERROR;

1498: END IF;
1499: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1500: EXCEPTION
1501: WHEN no_data_found THEN
1502: x_return_status:= FND_API.G_RET_STS_ERROR;
1503: x_error_msg_code:= 'PA_AGREEMENT_CURR_INVALID';
1504: -- 4537865
1505: x_agreement_currency := NULL ;
1506:

Line 1508: x_return_status:= FND_API.G_RET_STS_ERROR;

1504: -- 4537865
1505: x_agreement_currency := NULL ;
1506:
1507: WHEN too_many_rows THEN
1508: x_return_status:= FND_API.G_RET_STS_ERROR;
1509: x_error_msg_code:= 'PA_CURR_NAME_NOT UNIQUE';
1510: -- 4537865
1511: x_agreement_currency := NULL ;
1512:

Line 1514: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1510: -- 4537865
1511: x_agreement_currency := NULL ;
1512:
1513: WHEN OTHERS THEN
1514: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1515: -- 4537865
1516: x_agreement_currency := NULL ;
1517: x_error_msg_code:= SQLCODE ;
1518:

Line 1564: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1560: INTO x_agreement_org_id
1561: FROM pa_organizations_project_v
1562: WHERE name = p_agreement_org_name;
1563: END IF;
1564: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1565: EXCEPTION
1566: WHEN no_data_found THEN
1567: x_return_status:= FND_API.G_RET_STS_ERROR;
1568: x_error_msg_code:= 'PA_INVALID_ORG';

Line 1567: x_return_status:= FND_API.G_RET_STS_ERROR;

1563: END IF;
1564: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1565: EXCEPTION
1566: WHEN no_data_found THEN
1567: x_return_status:= FND_API.G_RET_STS_ERROR;
1568: x_error_msg_code:= 'PA_INVALID_ORG';
1569: -- 4537865
1570: x_agreement_org_id := NULL ;
1571:

Line 1573: x_return_status:= FND_API.G_RET_STS_ERROR;

1569: -- 4537865
1570: x_agreement_org_id := NULL ;
1571:
1572: WHEN too_many_rows THEN
1573: x_return_status:= FND_API.G_RET_STS_ERROR;
1574: x_error_msg_code:= 'PA_ORG_NOT UNIQUE';
1575: -- 4537865
1576: x_agreement_org_id := NULL ;
1577: WHEN OTHERS THEN

Line 1578: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1574: x_error_msg_code:= 'PA_ORG_NOT UNIQUE';
1575: -- 4537865
1576: x_agreement_org_id := NULL ;
1577: WHEN OTHERS THEN
1578: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1579: -- 4537865
1580: x_agreement_org_id := NULL ;
1581: x_error_msg_code:= SQLCODE ;
1582:

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

1883: l_error_msg_code VARCHAR2(250);
1884: BEGIN
1885:
1886: -- First check if the organization has changed
1887: IF (p_organization_id is not null AND p_organization_id <> FND_API.G_MISS_NUM) OR
1888: (p_organization_name is not null AND p_organization_name <> FND_API.G_MISS_CHAR) THEN
1889:
1890: pa_hr_org_utils.Check_OrgName_Or_Id
1891: (p_organization_id => p_organization_id

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

1884: BEGIN
1885:
1886: -- First check if the organization has changed
1887: IF (p_organization_id is not null AND p_organization_id <> FND_API.G_MISS_NUM) OR
1888: (p_organization_name is not null AND p_organization_name <> FND_API.G_MISS_CHAR) THEN
1889:
1890: pa_hr_org_utils.Check_OrgName_Or_Id
1891: (p_organization_id => p_organization_id
1892: ,p_organization_name => p_organization_name

Line 1898: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1894: ,x_organization_id => l_organization_id
1895: ,x_return_status => l_return_status
1896: ,x_error_msg_code => l_error_msg_code);
1897:
1898: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1899: return 'N';
1900: END IF;
1901: END IF;
1902:

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

2004: BEGIN
2005:
2006: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCode_Name_Or_Id');
2007:
2008: IF p_classcode_id IS NOT NULL AND p_classcode_id <> FND_API.G_MISS_NUM THEN
2009:
2010: IF p_check_id_flag = 'Y' THEN
2011: SELECT class_code_id
2012: INTO x_classcode_id

Line 2067: x_return_status := FND_API.G_RET_STS_SUCCESS;

2063: x_classcode_id := NULL;
2064: END IF;
2065: END IF;
2066:
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068: pa_debug.reset_err_stack;
2069:
2070: EXCEPTION
2071:

Line 2074: x_return_status := FND_API.G_RET_STS_ERROR;

2070: EXCEPTION
2071:
2072: WHEN NO_DATA_FOUND THEN
2073: x_classcode_id := null;
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: x_error_message_code := 'PA_CLASS_CATG_CODE_INVALID';
2076:
2077: WHEN TOO_MANY_ROWS THEN
2078: x_classcode_id := null;

Line 2079: x_return_status := FND_API.G_RET_STS_ERROR;

2075: x_error_message_code := 'PA_CLASS_CATG_CODE_INVALID';
2076:
2077: WHEN TOO_MANY_ROWS THEN
2078: x_classcode_id := null;
2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: x_error_message_code := 'PA_CLASS_CATG_CODE_INVALID';
2081:
2082: WHEN OTHERS THEN
2083: x_classcode_id := null;

Line 2087: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2083: x_classcode_id := null;
2084: fnd_msg_pub.add_exc_msg
2085: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2086: p_procedure_name => pa_debug.g_err_stack );
2087: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2088: -- 4537865
2089: x_error_message_code := SQLCODE ;
2090: RAISE;
2091:

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

2122: BEGIN
2123:
2124: pa_debug.init_err_stack ('pa_projects_maint_utils.Check_ClassCategory_Name_Or_Id');
2125:
2126: IF p_class_category_id IS NOT NULL AND p_class_category_id <> FND_API.G_MISS_NUM THEN
2127:
2128: IF p_check_id_flag = 'Y' THEN
2129: SELECT class_category_id
2130: INTO x_class_category_id

Line 2183: x_return_status := FND_API.G_RET_STS_SUCCESS;

2179: x_class_category_id := NULL;
2180: END IF;
2181: END IF;
2182:
2183: x_return_status := FND_API.G_RET_STS_SUCCESS;
2184: pa_debug.reset_err_stack;
2185:
2186: EXCEPTION
2187:

Line 2190: x_return_status := FND_API.G_RET_STS_ERROR;

2186: EXCEPTION
2187:
2188: WHEN NO_DATA_FOUND THEN
2189: x_class_category_id := null;
2190: x_return_status := FND_API.G_RET_STS_ERROR;
2191: x_error_message_code := 'PA_CLASS_CATG_INVALID';
2192:
2193: WHEN TOO_MANY_ROWS THEN
2194: x_class_category_id := null;

Line 2195: x_return_status := FND_API.G_RET_STS_ERROR;

2191: x_error_message_code := 'PA_CLASS_CATG_INVALID';
2192:
2193: WHEN TOO_MANY_ROWS THEN
2194: x_class_category_id := null;
2195: x_return_status := FND_API.G_RET_STS_ERROR;
2196: x_error_message_code := 'PA_CLASS_CATG_INVALID';
2197:
2198: WHEN OTHERS THEN
2199: x_class_category_id := null;

Line 2203: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

2199: x_class_category_id := null;
2200: fnd_msg_pub.add_exc_msg
2201: (p_pkg_name => 'PA_PROJECTS_MAINT_UTILS',
2202: p_procedure_name => pa_debug.g_err_stack );
2203: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2204: -- 4537865
2205: x_error_message_code := SQLCODE ;
2206: RAISE;
2207: