DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on PA_DELIVERABLE_UTILS

Line 303: Pa_Deliverable_Utils.Validate_Deliverable

299: --End Bug Number 3861930
300:
301: /*==============3435905 : FP M : Deliverables Changes For AMG - START ==============================*/
302: IF (p_calling_module = 'AMG') THEN
303: Pa_Deliverable_Utils.Validate_Deliverable
304: (
305: p_deliverable_id => null
306: , p_deliverable_reference => p_deliverable_reference
307: , p_dlvr_number => p_dlvr_number

Line 377: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_carrying_out_org called ',

373: l_debug_level3);
374: END IF;
375:
376: IF l_debug_mode = 'Y' THEN
377: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_carrying_out_org called ',
378: l_debug_level3);
379: END IF;
380:
381: -- retrieve carrying_out_organization_id

Line 383: l_carrying_out_org := PA_DELIVERABLE_UTILS.get_carrying_out_org

379: END IF;
380:
381: -- retrieve carrying_out_organization_id
382:
383: l_carrying_out_org := PA_DELIVERABLE_UTILS.get_carrying_out_org
384: (
385: p_project_id => p_project_id
386: ,p_task_id => p_task_id
387: );

Line 398: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',

394: RAISE Invalid_Arg_Exc_WP;
395: END IF;
396:
397: IF l_debug_mode = 'Y' THEN
398: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',
399: l_debug_level3);
400: END IF;
401:
402: IF l_debug_mode = 'Y' THEN

Line 408: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',

404: l_debug_level3);
405: END IF;
406:
407: IF l_debug_mode = 'Y' THEN
408: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',
409: l_debug_level3);
410: END IF;
411:
412: -- retrieve structure information

Line 414: PA_DELIVERABLE_UTILS.get_structure_info

410: END IF;
411:
412: -- retrieve structure information
413:
414: PA_DELIVERABLE_UTILS.get_structure_info
415: (
416: p_project_id => p_project_id
417: ,P_structure_type => l_structure_type
418: ,X_proj_element_id => l_structure_id

Line 426: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',

422: ,x_msg_data => x_msg_data
423: );
424:
425: IF l_debug_mode = 'Y' THEN
426: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',
427: l_debug_level3);
428: END IF;
429:
430:

Line 437: -- call PA_DELIVERABLE_UTILS.get_dlvr_type_info to retrieve default status code

433: -- retrieve default status code, if not passed
434:
435: IF l_status_code IS NULL THEN
436:
437: -- call PA_DELIVERABLE_UTILS.get_dlvr_type_info to retrieve default status code
438:
439: IF l_debug_mode = 'Y' THEN
440: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_dlvr_type_info called ',
441: l_debug_level3);

Line 440: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_dlvr_type_info called ',

436:
437: -- call PA_DELIVERABLE_UTILS.get_dlvr_type_info to retrieve default status code
438:
439: IF l_debug_mode = 'Y' THEN
440: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_dlvr_type_info called ',
441: l_debug_level3);
442: END IF;
443:
444: PA_DELIVERABLE_UTILS.get_dlvr_type_info

Line 444: PA_DELIVERABLE_UTILS.get_dlvr_type_info

440: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_dlvr_type_info called ',
441: l_debug_level3);
442: END IF;
443:
444: PA_DELIVERABLE_UTILS.get_dlvr_type_info
445: (
446: p_dlvr_type_id => p_dlvr_type_id,
447: x_dlvr_prg_enabled => l_dlvr_prg_enabled,
448: x_dlvr_action_enabled => l_dlvr_action_enabled,

Line 453: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_dlvr_type_info ',

449: x_dlvr_default_status_code => l_status_code
450: );
451:
452: IF l_debug_mode = 'Y' THEN
453: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_dlvr_type_info ',
454: l_debug_level3);
455: END IF;
456:
457: END IF;

Line 591: SELECT Pa_Deliverable_Utils.IS_Dlvr_Item_Based(element_version_id), element_version_id

587: IF (p_calling_module = 'AMG') THEN
588:
589: -- 3630378 changed below cursor to retrieve deliverable element version id
590:
591: SELECT Pa_Deliverable_Utils.IS_Dlvr_Item_Based(element_version_id), element_version_id
592: INTO l_item_dlv, l_dlv_elem_ver_id
593: FROM Pa_Proj_Element_Versions
594: WHERE proj_element_id = p_dlvr_item_id
595: AND project_id = p_project_id;

Line 1078: Pa_Deliverable_Utils.Validate_Deliverable

1074: l_currency_code := C_oke_rec.currency_code ;
1075: END LOOP;
1076:
1077: -- Validating the input parameters passed through AMG
1078: Pa_Deliverable_Utils.Validate_Deliverable
1079: (
1080: p_deliverable_id => p_dlvr_item_id
1081: , p_deliverable_reference => l_deliverable_reference -- changed for bug# 3749447
1082: , p_dlvr_number => p_dlvr_number

Line 1165: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',

1161: RAISE Invalid_Arg_Exc_WP;
1162: END IF;
1163:
1164: IF l_debug_mode = 'Y' THEN
1165: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',
1166: l_debug_level3);
1167: END IF;
1168:
1169: IF l_debug_mode = 'Y' THEN

Line 1175: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',

1171: l_debug_level3);
1172: END IF;
1173:
1174: IF l_debug_mode = 'Y' THEN
1175: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',
1176: l_debug_level3);
1177: END IF;
1178:
1179: -- retrieve structure information

Line 1181: PA_DELIVERABLE_UTILS.get_structure_info

1177: END IF;
1178:
1179: -- retrieve structure information
1180:
1181: PA_DELIVERABLE_UTILS.get_structure_info
1182: (
1183: p_project_id => p_project_id
1184: ,P_structure_type => l_structure_type
1185: ,X_proj_element_id => l_structure_id

Line 1193: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',

1189: ,x_msg_data => x_msg_data
1190: );
1191:
1192: IF l_debug_mode = 'Y' THEN
1193: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',
1194: l_debug_level3);
1195: END IF;
1196:
1197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1315: SELECT Pa_Deliverable_Utils.IS_Dlvr_Item_Based(element_version_id), element_version_id

1311:
1312: -- 3651542 added element_version_id column in select statement
1313: -- this retrieved element_version_id will be passed to oke
1314:
1315: SELECT Pa_Deliverable_Utils.IS_Dlvr_Item_Based(element_version_id), element_version_id
1316: INTO l_item_dlv, l_dlv_elem_ver_id
1317: FROM Pa_Proj_Element_Versions
1318: WHERE proj_element_id = p_dlvr_item_id
1319: AND project_id = p_project_id;