DBA Data[Home] [Help]

APPS.PO_PROJECT_DETAILS_SV dependencies on FND_API

Line 30: -- FND_API.g_ret_sts_success - if the procedure completed successfully

26: --p_project_id
27: --p_task_id
28: --OUT:
29: --x_return_status
30: -- FND_API.g_ret_sts_success - if the procedure completed successfully
31: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
32: --x_project_num
33: -- The project number. If not found, this will be NULL.
34: --x_task_num

Line 31: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

27: --p_task_id
28: --OUT:
29: --x_return_status
30: -- FND_API.g_ret_sts_success - if the procedure completed successfully
31: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
32: --x_project_num
33: -- The project number. If not found, this will be NULL.
34: --x_task_num
35: -- The task number. If not found, this will be NULL.

Line 59: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

55: all_proj_idtonum_wpr(x_return_status => l_return_status,
56: p_project_id => p_project_id,
57: x_project_number => x_project_num);
58:
59: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
60: RAISE FND_API.g_exc_unexpected_error;
61: END IF;
62:
63: IF (p_task_id IS NOT NULL) THEN

Line 60: RAISE FND_API.g_exc_unexpected_error;

56: p_project_id => p_project_id,
57: x_project_number => x_project_num);
58:
59: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
60: RAISE FND_API.g_exc_unexpected_error;
61: END IF;
62:
63: IF (p_task_id IS NOT NULL) THEN
64: l_progress := '020';

Line 81: WHEN FND_API.g_exc_unexpected_error THEN

77:
78: END IF; --< if project id not null >
79:
80: EXCEPTION
81: WHEN FND_API.g_exc_unexpected_error THEN
82: x_return_status := FND_API.g_ret_sts_unexp_error;
83: IF g_debug_unexp THEN
84: PO_DEBUG.debug_exc
85: (p_log_head => g_module_prefix||'get_project_task_num',

Line 82: x_return_status := FND_API.g_ret_sts_unexp_error;

78: END IF; --< if project id not null >
79:
80: EXCEPTION
81: WHEN FND_API.g_exc_unexpected_error THEN
82: x_return_status := FND_API.g_ret_sts_unexp_error;
83: IF g_debug_unexp THEN
84: PO_DEBUG.debug_exc
85: (p_log_head => g_module_prefix||'get_project_task_num',
86: p_progress => l_progress);

Line 89: x_return_status := FND_API.g_ret_sts_unexp_error;

85: (p_log_head => g_module_prefix||'get_project_task_num',
86: p_progress => l_progress);
87: END IF;
88: WHEN OTHERS THEN
89: x_return_status := FND_API.g_ret_sts_unexp_error;
90: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
91: p_procedure_name => 'get_project_task_num',
92: p_error_text => 'Progress: '||l_progress||
93: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 176: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

172: p_task_id => p_task_id,
173: x_project_num => p_project_num,
174: x_task_num => p_task_num);
175:
176: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
177: RAISE APP_EXCEPTION.application_exception;
178: END IF;
179: --< Bug 3265539 End >
180:

Line 210: -- FND_API.g_ret_sts_success - if the procedure completed successfully

206: --IN:
207: --p_project_id
208: --OUT:
209: --x_return_status
210: -- FND_API.g_ret_sts_success - if the procedure completed successfully
211: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
212: --x_project_number
213: -- The project number. If not found, this will be NULL.
214: --End of Comments

Line 211: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

207: --p_project_id
208: --OUT:
209: --x_return_status
210: -- FND_API.g_ret_sts_success - if the procedure completed successfully
211: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
212: --x_project_number
213: -- The project number. If not found, this will be NULL.
214: --End of Comments
215: --------------------------------------------------------------------------------

Line 224: x_return_status := FND_API.g_ret_sts_success;

220: x_project_number OUT NOCOPY VARCHAR2
221: )
222: IS
223: BEGIN
224: x_return_status := FND_API.g_ret_sts_success;
225:
226: x_project_number := PJM_PROJECT.all_proj_idtonum
227: (x_project_id => p_project_id);
228:

Line 233: x_return_status := FND_API.g_ret_sts_unexp_error;

229: EXCEPTION
230: WHEN NO_DATA_FOUND THEN
231: x_project_number := NULL;
232: WHEN OTHERS THEN
233: x_return_status := FND_API.g_ret_sts_unexp_error;
234: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
235: p_procedure_name => 'all_proj_idtonum_wpr');
236: IF g_debug_unexp THEN
237: PO_DEBUG.debug_exc

Line 330: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

326: PO_CORE_S.get_inv_org_ou_id(x_return_status => l_return_status,
327: p_inv_org_id => p_inventory_org_id,
328: x_ou_id => l_pjm_org_id);
329:
330: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
331: RAISE FND_API.g_exc_unexpected_error;
332: END IF;
333: ELSE
334: l_pjm_org_id := p_operating_unit;

Line 331: RAISE FND_API.g_exc_unexpected_error;

327: p_inv_org_id => p_inventory_org_id,
328: x_ou_id => l_pjm_org_id);
329:
330: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
331: RAISE FND_API.g_exc_unexpected_error;
332: END IF;
333: ELSE
334: l_pjm_org_id := p_operating_unit;
335: END IF;

Line 361: WHEN FND_API.g_exc_unexpected_error THEN

357: p_message => 'return code: '||x_return_code||' error code: '||
358: x_error_code);
359: END IF;
360: EXCEPTION
361: WHEN FND_API.g_exc_unexpected_error THEN
362: x_return_code := pjm_validate_failure;
363: IF g_debug_unexp THEN
364: PO_DEBUG.debug_exc
365: (p_log_head => g_module_prefix||'validate_proj_references_wpr',