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

Line 13: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

9: --
10: procedure CHECK_LOOPED_PROJECT
11: (
12: p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
16: p_debug_mode IN VARCHAR2 := 'N',
17: p_task_id IN NUMBER,

Line 14: p_commit IN VARCHAR2 := FND_API.G_FALSE,

10: procedure CHECK_LOOPED_PROJECT
11: (
12: p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
16: p_debug_mode IN VARCHAR2 := 'N',
17: p_task_id IN NUMBER,
18: p_project_id IN NUMBER,

Line 15: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

11: (
12: p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
16: p_debug_mode IN VARCHAR2 := 'N',
17: p_task_id IN NUMBER,
18: p_project_id IN NUMBER,
19: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

72: END;
73: end if;
74:
75: IF (l_looped = 'Y') THEN --There is a loop
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: elsif (l_looped = 'N') THEN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: else
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74:
75: IF (l_looped = 'Y') THEN --There is a loop
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: elsif (l_looped = 'N') THEN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: else
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: end if;
82:

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

76: x_return_status := FND_API.G_RET_STS_ERROR;
77: elsif (l_looped = 'N') THEN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: else
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: end if;
82:
83: x_msg_count := 0;
84: x_msg_data := null;

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

85:
86: pa_debug.reset_err_stack;
87: EXCEPTION
88: When OTHERS Then
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: RAISE;
91: END CHECK_LOOPED_PROJECT;
92:
93:

Line 98: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

94:
95: procedure CHECK_MERGED_PROJECT
96: (
97: p_api_version IN NUMBER := 1.0,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
101: p_debug_mode IN VARCHAR2 := 'N',
102: p_task_id IN NUMBER,

Line 99: p_commit IN VARCHAR2 := FND_API.G_FALSE,

95: procedure CHECK_MERGED_PROJECT
96: (
97: p_api_version IN NUMBER := 1.0,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
101: p_debug_mode IN VARCHAR2 := 'N',
102: p_task_id IN NUMBER,
103: p_project_id IN NUMBER,

Line 100: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

96: (
97: p_api_version IN NUMBER := 1.0,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
101: p_debug_mode IN VARCHAR2 := 'N',
102: p_task_id IN NUMBER,
103: p_project_id IN NUMBER,
104: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: END LOOP;
206: CLOSE get_merged_projects;
207:
208: IF(l_linked_id IS NULL) THEN
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: ELSE
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;
213:

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207:
208: IF(l_linked_id IS NULL) THEN
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: ELSE
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;
213:
214: EXCEPTION
215: When NO_DATA_FOUND Then

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: When NO_DATA_FOUND Then
216: l_linked := 'N';
217: End;
218: ELSE
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: END IF;
221: END;
222:
223: x_msg_count := 0;

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: x_msg_data := null;
225: pa_debug.reset_err_stack;
226: EXCEPTION
227: When OTHERS Then
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: RAISE;
230: END CHECK_MERGED_PROJECT;
231:
232:

Line 246: retval := FND_API.G_RET_STS_SUCCESS;

242: msg_data VARCHAR2(2000);
243: ret_status VARCHAR2(10);
244: BEGIN
245: pa_debug.set_err_stack('CHECK_PROJECT_CONTRACT_EXISTS');
246: retval := FND_API.G_RET_STS_SUCCESS;
247:
248: /*
249: -- Old code
250: output := OKE_UTILS.Project_Used(p_project_id);

Line 254: p_commit => FND_API.G_TRUE,

250: output := OKE_UTILS.Project_Used(p_project_id);
251: */
252:
253: OKE_PA_CHECKS_PUB.Project_Used(p_api_version => 1.0,
254: p_commit => FND_API.G_TRUE,
255: p_init_msg_list => FND_API.G_FALSE,
256: x_msg_count => msg_count,
257: x_msg_data => msg_data,
258: x_return_status => ret_status,

Line 255: p_init_msg_list => FND_API.G_FALSE,

251: */
252:
253: OKE_PA_CHECKS_PUB.Project_Used(p_api_version => 1.0,
254: p_commit => FND_API.G_TRUE,
255: p_init_msg_list => FND_API.G_FALSE,
256: x_msg_count => msg_count,
257: x_msg_data => msg_data,
258: x_return_status => ret_status,
259: Project_ID => p_project_id,

Line 264: retval := FND_API.G_RET_STS_ERROR;

260: X_Result => output
261: ); --Commented the call to OKE_PA_CHECKS_PUB.Project_Used
262: IF (output = 'Y') THEN
263: -- project is used, association exists, return error
264: retval := FND_API.G_RET_STS_ERROR;
265: ELSE
266: -- no association exists, return success
267: retval := FND_API.G_RET_STS_SUCCESS;
268: END IF;

Line 267: retval := FND_API.G_RET_STS_SUCCESS;

263: -- project is used, association exists, return error
264: retval := FND_API.G_RET_STS_ERROR;
265: ELSE
266: -- no association exists, return success
267: retval := FND_API.G_RET_STS_SUCCESS;
268: END IF;
269:
270:
271: pa_debug.reset_err_stack;

Line 275: return FND_API.G_RET_STS_UNEXP_ERROR;

271: pa_debug.reset_err_stack;
272: return retval;
273: EXCEPTION
274: When OTHERS Then
275: return FND_API.G_RET_STS_UNEXP_ERROR;
276: END CHECK_PROJECT_CONTRACT_EXISTS;
277:
278:
279: function CHECK_TASK_CONTRACT_EXISTS

Line 292: retval := FND_API.G_RET_STS_SUCCESS;

288: msg_data VARCHAR2(2000);
289: ret_status VARCHAR2(10);
290: BEGIN
291: pa_debug.set_err_stack('CHECK_TASK_CONTRACT_EXISTS');
292: retval := FND_API.G_RET_STS_SUCCESS;
293:
294: /*
295: -- Old code
296: output := OKE_UTILS.Task_Used(p_task_id);

Line 299: p_commit => FND_API.G_TRUE,

295: -- Old code
296: output := OKE_UTILS.Task_Used(p_task_id);
297: */
298: OKE_PA_CHECKS_PUB.Task_Used(p_api_version => 1.0,
299: p_commit => FND_API.G_TRUE,
300: p_init_msg_list => FND_API.G_FALSE,
301: x_msg_count => msg_count,
302: x_msg_data => msg_data,
303: x_return_status => ret_status,

Line 300: p_init_msg_list => FND_API.G_FALSE,

296: output := OKE_UTILS.Task_Used(p_task_id);
297: */
298: OKE_PA_CHECKS_PUB.Task_Used(p_api_version => 1.0,
299: p_commit => FND_API.G_TRUE,
300: p_init_msg_list => FND_API.G_FALSE,
301: x_msg_count => msg_count,
302: x_msg_data => msg_data,
303: x_return_status => ret_status,
304: Task_ID => p_task_id,

Line 309: retval := FND_API.G_RET_STS_ERROR;

305: x_Result => output
306: ); --Commented the call to OKE_PA_CHECKS_PUB.Project_Used
307: IF (output = 'Y') THEN
308: -- project is used, association exists, return error
309: retval := FND_API.G_RET_STS_ERROR;
310: ELSE
311: -- no association exists, return success
312: retval := FND_API.G_RET_STS_SUCCESS;
313: END IF;

Line 312: retval := FND_API.G_RET_STS_SUCCESS;

308: -- project is used, association exists, return error
309: retval := FND_API.G_RET_STS_ERROR;
310: ELSE
311: -- no association exists, return success
312: retval := FND_API.G_RET_STS_SUCCESS;
313: END IF;
314:
315: pa_debug.reset_err_stack;
316: return retval;

Line 319: return FND_API.G_RET_STS_UNEXP_ERROR;

315: pa_debug.reset_err_stack;
316: return retval;
317: EXCEPTION
318: When OTHERS Then
319: return FND_API.G_RET_STS_UNEXP_ERROR;
320: END CHECK_TASK_CONTRACT_EXISTS;
321: -- FP M: Project Execution Workflow Changes
322: FUNCTION IS_WF_ENABLED_FOR_STRUCTURE(
323: p_project_id IN NUMBER

Line 482: --Begin: 6046307: commented out the following IF condition that 'RAISE FND_API.G_EXC_ERROR' when 'p_project_id' or 'p_budget_version_id' are NULL

478: p_budget_version_id IN NUMBER) IS
479:
480: BEGIN
481:
482: --Begin: 6046307: commented out the following IF condition that 'RAISE FND_API.G_EXC_ERROR' when 'p_project_id' or 'p_budget_version_id' are NULL
483: /*
484: IF p_project_id IS NULL OR p_budget_version_id IS NULL THEN
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;

Line 485: RAISE FND_API.G_EXC_ERROR;

481:
482: --Begin: 6046307: commented out the following IF condition that 'RAISE FND_API.G_EXC_ERROR' when 'p_project_id' or 'p_budget_version_id' are NULL
483: /*
484: IF p_project_id IS NULL OR p_budget_version_id IS NULL THEN
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;
487: */
488: --End: 6046307
489: