[Home] [Help]
46: ,x_job_id OUT NOCOPY pa_resource_assignments.job_id%TYPE
47: )
48: IS
49: l_person_id pa_resource_assignments.person_id%TYPE;
50: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
51:
52:
53: BEGIN
54: IF p_person_id IS NULL AND p_resource_assignment_id IS NOT NULL THEN
279:
280: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
281: l_debug_mode := NVL(l_debug_mode, 'N');
282: x_msg_count := 0;
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284: IF l_debug_mode = 'Y' THEN
285: PA_DEBUG.Set_Curr_Function( p_function => 'plan_txn_pub.drv_prms_for_calc',
286: p_debug_mode => l_debug_mode );
287: END IF;
397: l_rate_based_flag_tbl.extend(p_resource_assignment_id_tbl.COUNT);
398: l_non_labor_resource_tbl.extend(p_resource_assignment_id_tbl.COUNT);
399: l_task_id_tbl.extend(p_resource_assignment_id_tbl.COUNT);
400:
401: --Added the check for FND_API.G_MISS_XXX in the below decodes as the UI can pass input parameters
402: --as FND_API.G_MISS_XXX even if the existing value of the attribute is NULL. NOTE: The input parameter
403: --to update_planning_transactions should be NULL if the corresponding column in pa_resource_assignments
404: --should not be changed and the input parameter should be FND_API.G_MISS_XXX if thhe corresponding column
405: --in pa_resource_assignments should be nulled out.
398: l_non_labor_resource_tbl.extend(p_resource_assignment_id_tbl.COUNT);
399: l_task_id_tbl.extend(p_resource_assignment_id_tbl.COUNT);
400:
401: --Added the check for FND_API.G_MISS_XXX in the below decodes as the UI can pass input parameters
402: --as FND_API.G_MISS_XXX even if the existing value of the attribute is NULL. NOTE: The input parameter
403: --to update_planning_transactions should be NULL if the corresponding column in pa_resource_assignments
404: --should not be changed and the input parameter should be FND_API.G_MISS_XXX if thhe corresponding column
405: --in pa_resource_assignments should be nulled out.
406: FOR i IN p_resource_assignment_id_tbl.FIRST .. p_resource_assignment_id_tbl.LAST LOOP
400:
401: --Added the check for FND_API.G_MISS_XXX in the below decodes as the UI can pass input parameters
402: --as FND_API.G_MISS_XXX even if the existing value of the attribute is NULL. NOTE: The input parameter
403: --to update_planning_transactions should be NULL if the corresponding column in pa_resource_assignments
404: --should not be changed and the input parameter should be FND_API.G_MISS_XXX if thhe corresponding column
405: --in pa_resource_assignments should be nulled out.
406: FOR i IN p_resource_assignment_id_tbl.FIRST .. p_resource_assignment_id_tbl.LAST LOOP
407:
408: --dbms_output.put_line('6.2 '||p_resource_assignment_id_tbl(i) );
468: ELSE
469:
470: SELECT
471: DECODE(DECODE(NVL(p_project_role_id_tbl(i),project_role_id),
472: FND_API.G_MISS_NUM, decode(project_role_id,null,0,1),
473: project_role_id,0,
474: 1)+
475: DECODE(NVL(p_resource_list_member_id_tbl(i),resource_list_member_id),
476: FND_API.G_MISS_NUM, decode(resource_list_member_id,null,0,1),
472: FND_API.G_MISS_NUM, decode(project_role_id,null,0,1),
473: project_role_id,0,
474: 1)+
475: DECODE(NVL(p_resource_list_member_id_tbl(i),resource_list_member_id),
476: FND_API.G_MISS_NUM, decode(resource_list_member_id,null,0,1),
477: resource_list_member_id, 0,
478: 1),
479: 0, 'N',
480: 'Y'),--Indicates whether the rbs mapping api should be called or not
484: NVL(p_spread_curve_id_tbl(i),spread_curve_id),
485: sp_fixed_date,
486: DECODE(nvl(p_spread_curve_id_tbl(i),spread_curve_id),
487: p_fixed_date_sp_id,DECODE(DECODE(p_sp_fixed_date_tbl(i),
488: FND_API.G_MISS_DATE,to_date(null),
489: nvl(p_sp_fixed_date_tbl(i),sp_fixed_date))
490: ,to_date(null),DECODE (p_planning_start_date_tbl(i),
491: FND_API.G_MISS_DATE,to_date(null),
492: nvl(p_planning_start_date_tbl(i),planning_start_date))
487: p_fixed_date_sp_id,DECODE(DECODE(p_sp_fixed_date_tbl(i),
488: FND_API.G_MISS_DATE,to_date(null),
489: nvl(p_sp_fixed_date_tbl(i),sp_fixed_date))
490: ,to_date(null),DECODE (p_planning_start_date_tbl(i),
491: FND_API.G_MISS_DATE,to_date(null),
492: nvl(p_planning_start_date_tbl(i),planning_start_date))
493: ,nvl(p_sp_fixed_date_tbl(i),sp_fixed_date))
494: ,to_date(null)),
495: planning_start_date,
495: planning_start_date,
496: NVL(p_planning_start_date_tbl(i),planning_start_date),
497: planning_end_date,
498: NVL(p_planning_end_date_tbl(i),planning_end_date),
499: DECODE (p_txn_currency_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_txn_currency_code_tbl(i),pbl.txn_currency_code)),
500: DECODE (p_inventory_item_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_inventory_item_id_tbl(i),inventory_item_id)) ,
501: DECODE (p_expenditure_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_type_tbl(i),expenditure_type)),
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
496: NVL(p_planning_start_date_tbl(i),planning_start_date),
497: planning_end_date,
498: NVL(p_planning_end_date_tbl(i),planning_end_date),
499: DECODE (p_txn_currency_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_txn_currency_code_tbl(i),pbl.txn_currency_code)),
500: DECODE (p_inventory_item_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_inventory_item_id_tbl(i),inventory_item_id)) ,
501: DECODE (p_expenditure_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_type_tbl(i),expenditure_type)),
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
497: planning_end_date,
498: NVL(p_planning_end_date_tbl(i),planning_end_date),
499: DECODE (p_txn_currency_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_txn_currency_code_tbl(i),pbl.txn_currency_code)),
500: DECODE (p_inventory_item_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_inventory_item_id_tbl(i),inventory_item_id)) ,
501: DECODE (p_expenditure_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_type_tbl(i),expenditure_type)),
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
498: NVL(p_planning_end_date_tbl(i),planning_end_date),
499: DECODE (p_txn_currency_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_txn_currency_code_tbl(i),pbl.txn_currency_code)),
500: DECODE (p_inventory_item_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_inventory_item_id_tbl(i),inventory_item_id)) ,
501: DECODE (p_expenditure_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_type_tbl(i),expenditure_type)),
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
499: DECODE (p_txn_currency_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_txn_currency_code_tbl(i),pbl.txn_currency_code)),
500: DECODE (p_inventory_item_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_inventory_item_id_tbl(i),inventory_item_id)) ,
501: DECODE (p_expenditure_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_type_tbl(i),expenditure_type)),
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
500: DECODE (p_inventory_item_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_inventory_item_id_tbl(i),inventory_item_id)) ,
501: DECODE (p_expenditure_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_type_tbl(i),expenditure_type)),
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
501: DECODE (p_expenditure_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_type_tbl(i),expenditure_type)),
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
502: DECODE (p_person_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_person_id_tbl(i),person_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
503: DECODE (p_job_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_job_id_tbl(i),job_id)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
511: DECODE (p_person_type_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_person_type_code_tbl(i),person_type_code)) ,
504: DECODE (p_organization_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_organization_id_tbl(i),organization_id)) ,
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
511: DECODE (p_person_type_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_person_type_code_tbl(i),person_type_code)) ,
512: DECODE (p_supplier_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_supplier_id_tbl(i),supplier_id)),
505: DECODE (p_event_type_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_event_type_tbl(i),event_type)) ,
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
511: DECODE (p_person_type_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_person_type_code_tbl(i),person_type_code)) ,
512: DECODE (p_supplier_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_supplier_id_tbl(i),supplier_id)),
513: DECODE (p_named_role_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_named_role_tbl(i),named_role )),
506: DECODE (p_expenditure_category_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_expenditure_category_tbl(i),expenditure_category)) ,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
511: DECODE (p_person_type_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_person_type_code_tbl(i),person_type_code)) ,
512: DECODE (p_supplier_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_supplier_id_tbl(i),supplier_id)),
513: DECODE (p_named_role_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_named_role_tbl(i),named_role )),
514: resource_class_code,
507: DECODE (p_revenue_category_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_revenue_category_code_tbl(i),revenue_category_code)) ,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
511: DECODE (p_person_type_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_person_type_code_tbl(i),person_type_code)) ,
512: DECODE (p_supplier_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_supplier_id_tbl(i),supplier_id)),
513: DECODE (p_named_role_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_named_role_tbl(i),named_role )),
514: resource_class_code,
515: rate_based_flag,
508: DECODE (p_item_category_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_item_category_id_tbl(i),item_category_id)) ,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
511: DECODE (p_person_type_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_person_type_code_tbl(i),person_type_code)) ,
512: DECODE (p_supplier_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_supplier_id_tbl(i),supplier_id)),
513: DECODE (p_named_role_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_named_role_tbl(i),named_role )),
514: resource_class_code,
515: rate_based_flag,
516: rbs_element_id,
509: DECODE (p_bom_resource_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_bom_resource_id_tbl(i),bom_resource_id)) ,
510: DECODE (p_project_role_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_project_role_id_tbl(i),project_role_id)) ,
511: DECODE (p_person_type_code_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_person_type_code_tbl(i),person_type_code)) ,
512: DECODE (p_supplier_id_tbl(i), FND_API.G_MISS_NUM,null,nvl(p_supplier_id_tbl(i),supplier_id)),
513: DECODE (p_named_role_tbl(i), FND_API.G_MISS_CHAR,null,nvl(p_named_role_tbl(i),named_role )),
514: resource_class_code,
515: rate_based_flag,
516: rbs_element_id,
517: non_labor_resource,
588:
589: END IF;--IF l_debug_mode = 'Y' THEN
590:
591: --Added Validation for planning_start_date and planning end date
592: IF ((x_plan_start_date_new_tbl(i)=FND_API.G_MISS_DATE) OR
593: (x_plan_end_date_new_tbl(i) =FND_API.G_MISS_DATE) OR
594: (NVL(x_plan_start_date_new_tbl(i),trunc(sysdate))>NVL(x_plan_end_date_new_tbl(i),trunc(sysdate)))) THEN
595:
596: IF l_debug_mode = 'Y' THEN
589: END IF;--IF l_debug_mode = 'Y' THEN
590:
591: --Added Validation for planning_start_date and planning end date
592: IF ((x_plan_start_date_new_tbl(i)=FND_API.G_MISS_DATE) OR
593: (x_plan_end_date_new_tbl(i) =FND_API.G_MISS_DATE) OR
594: (NVL(x_plan_start_date_new_tbl(i),trunc(sysdate))>NVL(x_plan_end_date_new_tbl(i),trunc(sysdate)))) THEN
595:
596: IF l_debug_mode = 'Y' THEN
597:
632: /* end of bug fix: 5752337 */
633:
634:
635: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
636: END IF;--IF ((x_plan_start_date_new_tbl(i)=FND_API.G_MISS_DATE) OR
637:
638: --Bug 4083605. This block of code makes sure that the planning start date is not changed to a date
639: --which falls after the date where actuals exist. Similar validations are done for planning end date too
640:
711: --Modified Logic below for Bug 3762278 -- l_spread_curve_id_tbl is the final value of
712: --spread curve id that will be existing in db
713: IF (x_spread_curve_id_new_tbl(i) = p_fixed_date_sp_id) THEN
714:
715: IF p_sp_fixed_date_tbl(i) = FND_API.G_MISS_DATE THEN
716:
717: IF l_debug_mode = 'Y' THEN
718: pa_debug.g_err_stage:='Error - cannot nullify sp_fixed_date for Fixed Date Spread curve';
719: print_msg(pa_debug.g_err_stage,l_module_name);
782: p_token5 => 'L_LINE_END_DATE',
783: p_value5 => x_plan_start_date_old_tbl(i));
784: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
785:
786: END IF;--IF x_sp_fixed_date_new_tbl(i) = FND_API.G_MISS_DATE THEN
787:
788: ELSE
789: -- if the Final Value of spread curve id is either null or not equal to fixed date
790: -- spread curve then the sp fixed date should be nulled out if it is not already null.
796: END IF;
797:
798: IF x_sp_fixed_date_old_tbl(i) IS NOT NULL THEN
799:
800: x_sp_fixed_date_new_tbl(i) := FND_API.G_MISS_DATE;
801:
802: ELSE
803:
804: x_sp_fixed_date_new_tbl(i) := NULL;
904: pa_debug.g_err_stage:='Deriving Amts/Qty for rbs element id change';
905: print_msg(pa_debug.g_err_stage,l_module_name);
906: END IF;
907:
908: IF px_total_qty_tbl(i) IS NOT NULL AND px_total_qty_tbl(i) <> FND_API.G_MISS_NUM THEN
909:
910: IF l_debug_mode = 'Y' THEN
911: pa_debug.g_err_stage:='RBS Input Quantity Exists Set Amts to NULL';
912: print_msg(pa_debug.g_err_stage,l_module_name);
923: * the new rate overrides entered by user, if not changed then set it to null
924: * so that, rate api derives the new rates for new planning resource
925: */
926: IF px_raw_cost_override_rate_tbl(i) is NOT NULL AND
927: px_raw_cost_override_rate_tbl(i) <> FND_API.G_MISS_NUM Then
928: IF px_raw_cost_override_rate_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_raw_cost_rate_override,0) Then
929: px_raw_cost_override_rate_tbl(i) := NULL;
930: END IF;
931: End IF;
930: END IF;
931: End IF;
932:
933: IF px_b_cost_rate_override_tbl(i) is NOT NULL AND
934: px_b_cost_rate_override_tbl(i) <> FND_API.G_MISS_NUM Then
935: IF px_b_cost_rate_override_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_burden_cost_rate_override,0) Then
936: px_b_cost_rate_override_tbl(i) := NULL;
937: END IF;
938: END IF;
936: px_b_cost_rate_override_tbl(i) := NULL;
937: END IF;
938: END IF;
939:
940: ELSIF px_total_qty_tbl(i) = FND_API.G_MISS_NUM THEN
941:
942: IF l_debug_mode = 'Y' THEN
943: pa_debug.g_err_stage:='RBS Input Quantity IS G_MISS_NUM Set Amts to G_MISS_NUM';
944: print_msg(pa_debug.g_err_stage,l_module_name);
943: pa_debug.g_err_stage:='RBS Input Quantity IS G_MISS_NUM Set Amts to G_MISS_NUM';
944: print_msg(pa_debug.g_err_stage,l_module_name);
945: END IF;
946:
947: px_total_raw_cost_tbl(i) := FND_API.G_MISS_NUM;
948: px_total_burdened_cost_tbl(i) := FND_API.G_MISS_NUM;
949: px_total_revenue_tbl(i) := FND_API.G_MISS_NUM;
950: px_raw_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
951: px_b_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
944: print_msg(pa_debug.g_err_stage,l_module_name);
945: END IF;
946:
947: px_total_raw_cost_tbl(i) := FND_API.G_MISS_NUM;
948: px_total_burdened_cost_tbl(i) := FND_API.G_MISS_NUM;
949: px_total_revenue_tbl(i) := FND_API.G_MISS_NUM;
950: px_raw_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
951: px_b_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
952: px_bill_rate_tbl(i) := FND_API.G_MISS_NUM;
945: END IF;
946:
947: px_total_raw_cost_tbl(i) := FND_API.G_MISS_NUM;
948: px_total_burdened_cost_tbl(i) := FND_API.G_MISS_NUM;
949: px_total_revenue_tbl(i) := FND_API.G_MISS_NUM;
950: px_raw_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
951: px_b_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
952: px_bill_rate_tbl(i) := FND_API.G_MISS_NUM;
953:
946:
947: px_total_raw_cost_tbl(i) := FND_API.G_MISS_NUM;
948: px_total_burdened_cost_tbl(i) := FND_API.G_MISS_NUM;
949: px_total_revenue_tbl(i) := FND_API.G_MISS_NUM;
950: px_raw_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
951: px_b_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
952: px_bill_rate_tbl(i) := FND_API.G_MISS_NUM;
953:
954: /* Bug fix: 5759413 */
947: px_total_raw_cost_tbl(i) := FND_API.G_MISS_NUM;
948: px_total_burdened_cost_tbl(i) := FND_API.G_MISS_NUM;
949: px_total_revenue_tbl(i) := FND_API.G_MISS_NUM;
950: px_raw_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
951: px_b_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
952: px_bill_rate_tbl(i) := FND_API.G_MISS_NUM;
953:
954: /* Bug fix: 5759413 */
955: IF px_raw_cost_override_rate_tbl(i) is NOT NULL AND
948: px_total_burdened_cost_tbl(i) := FND_API.G_MISS_NUM;
949: px_total_revenue_tbl(i) := FND_API.G_MISS_NUM;
950: px_raw_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
951: px_b_cost_rate_tbl(i) := FND_API.G_MISS_NUM;
952: px_bill_rate_tbl(i) := FND_API.G_MISS_NUM;
953:
954: /* Bug fix: 5759413 */
955: IF px_raw_cost_override_rate_tbl(i) is NOT NULL AND
956: px_raw_cost_override_rate_tbl(i) <> FND_API.G_MISS_NUM Then
952: px_bill_rate_tbl(i) := FND_API.G_MISS_NUM;
953:
954: /* Bug fix: 5759413 */
955: IF px_raw_cost_override_rate_tbl(i) is NOT NULL AND
956: px_raw_cost_override_rate_tbl(i) <> FND_API.G_MISS_NUM Then
957: IF px_raw_cost_override_rate_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_raw_cost_rate_override,0) Then
958: px_raw_cost_override_rate_tbl(i) := NULL;
959: END IF;
960: End IF;
959: END IF;
960: End IF;
961:
962: IF px_b_cost_rate_override_tbl(i) is NOT NULL AND
963: px_b_cost_rate_override_tbl(i) <> FND_API.G_MISS_NUM Then
964: IF px_b_cost_rate_override_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_burden_cost_rate_override,0) Then px_b_cost_rate_override_tbl(i) := NULL;
965: END IF;
966: END IF;
967:
992: px_b_cost_rate_tbl(i) := NULL;
993: px_bill_rate_tbl(i) := NULL;
994: /* Bug fix: 5759413 */
995: IF px_raw_cost_override_rate_tbl(i) is NOT NULL AND
996: px_raw_cost_override_rate_tbl(i) <> FND_API.G_MISS_NUM Then
997: IF px_raw_cost_override_rate_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_raw_cost_rate_override,0) Then
998: px_raw_cost_override_rate_tbl(i) := NULL;
999: END IF;
1000: End IF;
999: END IF;
1000: End IF;
1001:
1002: IF px_b_cost_rate_override_tbl(i) is NOT NULL AND
1003: px_b_cost_rate_override_tbl(i) <> FND_API.G_MISS_NUM Then
1004: IF px_b_cost_rate_override_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_burden_cost_rate_override,0) Then px_b_cost_rate_override_tbl(i) := NULL;
1005: END IF;
1006: END IF;
1007:
1021: px_bill_rate_tbl(i) := NULL;
1022:
1023: /* Bug fix: 5759413 */
1024: IF px_raw_cost_override_rate_tbl(i) is NOT NULL AND
1025: px_raw_cost_override_rate_tbl(i) <> FND_API.G_MISS_NUM Then
1026: IF px_raw_cost_override_rate_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_raw_cost_rate_override,0) Then
1027: px_raw_cost_override_rate_tbl(i) := NULL;
1028: END IF;
1029: End IF;
1028: END IF;
1029: End IF;
1030:
1031: IF px_b_cost_rate_override_tbl(i) is NOT NULL AND
1032: px_b_cost_rate_override_tbl(i) <> FND_API.G_MISS_NUM Then
1033: IF px_b_cost_rate_override_tbl(i) = nvl(l_rtx_rateOvrds_rec.txn_burden_cost_rate_override,0) Then px_b_cost_rate_override_tbl(i) := NULL;
1034: END IF;
1035: END IF;
1036:
1038:
1039: CLOSE c_data_in_db_csr;
1040: --dbms_output.put_line('7.4');
1041:
1042: END IF;--IF px_total_qty_tbl(i) IS NOT NULL AND px_total_qty_tbl(i) <> FND_API.G_MISS_NUM THEN
1043:
1044: END IF;--IF x_rlm_id_change_flag_tbl(i)='Y' THEN
1045:
1046: END IF;--IF p_project_role_id_tbl(i) IS NULL AND
1085: ,x_msg_count => x_msg_count
1086: ,x_msg_data => x_msg_data
1087: );
1088:
1089: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090:
1091: IF l_debug_mode = 'Y' THEN
1092: pa_debug.g_err_stage:='Called API delete_planning_transactions returned error';
1093: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1151: ,x_return_status => x_return_status
1152: ,x_msg_count => x_msg_count
1153: ,x_msg_data => x_msg_data);
1154:
1155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1156:
1157: IF l_debug_mode = 'Y' THEN
1158: pa_debug.g_err_stage:='Called API PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs returned error';
1159: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1209: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1210: l_msg_count := FND_MSG_PUB.count_msg;
1211: IF l_msg_count = 1 THEN
1212: PA_INTERFACE_UTILS_PUB.get_messages
1213: (p_encoded => FND_API.G_TRUE
1214: ,p_msg_index => 1
1215: ,p_msg_count => l_msg_count
1216: ,p_msg_data => l_msg_data
1217: ,p_data => l_data
1220: x_msg_count := l_msg_count;
1221: ELSE
1222: x_msg_count := l_msg_count;
1223: END IF;
1224: x_return_status := FND_API.G_RET_STS_ERROR;
1225: IF l_debug_mode = 'Y' THEN
1226: pa_debug.reset_curr_function;
1227: END IF;
1228: WHEN OTHERS THEN
1225: IF l_debug_mode = 'Y' THEN
1226: pa_debug.reset_curr_function;
1227: END IF;
1228: WHEN OTHERS THEN
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1230: x_msg_count := 1;
1231: x_msg_data := SQLERRM;
1232: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
1233: ,p_procedure_name => 'Process_res_chg_Derv_calc_prms');
1653:
1654:
1655:
1656: x_msg_count := 0;
1657: x_return_status := FND_API.G_RET_STS_SUCCESS;
1658: IF l_debug_mode = 'Y' THEN
1659: PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_PLAN_TXN_PUB.add_planning_transactions',
1660: p_debug_mode => l_debug_mode );
1661: END IF;
2328: l_trace_stage := 100;
2329: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2330:
2331: -- 4504452.Added this if codition to get the return status.
2332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2333: IF l_debug_mode = 'Y' THEN
2334: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_wp_plan_type api returned error';
2335: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2336: END IF;
2409:
2410: l_trace_stage := 130;
2411: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2412:
2413: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2414: IF l_debug_mode = 'Y' THEN
2415: pa_debug.g_err_stage:='Called API pa_fin_plan_pub.create_version api returned error';
2416: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2417: END IF;
2552: x_msg_count => l_msg_count,
2553: x_msg_data => l_msg_data);
2554: l_trace_stage := 230;
2555: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2556: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2557: IF l_debug_mode = 'Y' THEN
2558: pa_debug.g_err_stage:='Called API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids api returned error';
2559: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2560: END IF;
2586: FOR i IN l_eligible_rlm_ids_tbl.FIRST .. l_eligible_rlm_ids_tbl.LAST LOOP
2587: If (NOT p_pm_product_code.EXISTS(i))
2588: then
2589: l_pm_product_code_tbl(i) := null;
2590: elsif ( p_pm_product_code(i) = fnd_api.g_miss_char)
2591: Then
2592: l_pm_product_code_tbl(i) := null;
2593: Else
2594: l_pm_product_code_tbl(i) := p_pm_product_code(i);
2596:
2597: If (NOT p_pm_res_asgmt_ref.EXISTS(i))
2598: then
2599: l_pm_res_asgmt_ref_tbl(i) := null;
2600: elsif (p_pm_res_asgmt_ref(i) = fnd_api.g_miss_char)
2601: Then
2602: l_pm_res_asgmt_ref_tbl(i) := null;
2603: Else
2604: l_pm_res_asgmt_ref_tbl(i) := p_pm_res_asgmt_ref(i);
2667: x_return_status => l_return_status);
2668: l_trace_stage := 310;
2669: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2670:
2671: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2672:
2673: IF l_debug_mode = 'Y' THEN
2674: pa_debug.g_err_stage:='Called APIPA_PLANNING_RESOURCE_UTILS.get_resource_defaults api returned error';
2675: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2833: ,x_return_status => x_return_status
2834: ,x_msg_count => x_msg_count
2835: ,x_msg_data => x_msg_data);
2836:
2837: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2838:
2839: IF l_debug_mode = 'Y' THEN
2840: pa_debug.g_err_stage:='Called API PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs returned error';
2841: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3242: x_return_status => l_return_status);
3243: --dbms_output.put_line('qty aft is '||l_resource_rec_tbl(1).planning_start_date);
3244: --dbms_output.put_line('qty aft is '||l_resource_rec_tbl(1).planning_end_date);
3245:
3246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3247: IF l_debug_mode = 'Y' THEN
3248: pa_debug.g_err_stage:='Called API pa_task_assignment_utils.Validate_Create_Assignment returned error';
3249: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3250: END IF;
3296: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3297:
3298: IF l_resource_rec_tbl.EXISTS(i) THEN
3299:
3300: IF l_resource_rec_tbl(i).resource_list_member_id = FND_API.G_MISS_NUM THEN
3301: l_eligible_rlm_ids_tbl(i) := NULL;
3302: ELSE
3303: l_eligible_rlm_ids_tbl(i) := l_resource_rec_tbl(i).resource_list_member_id;
3304: END IF;
3302: ELSE
3303: l_eligible_rlm_ids_tbl(i) := l_resource_rec_tbl(i).resource_list_member_id;
3304: END IF;
3305:
3306: IF l_resource_rec_tbl(i).resource_class_flag = FND_API.G_MISS_CHAR THEN
3307: l_resource_class_flag_tbl(i) := NULL;
3308: ELSE
3309: l_resource_class_flag_tbl(i) := l_resource_rec_tbl(i).resource_class_flag;
3310: END IF;
3308: ELSE
3309: l_resource_class_flag_tbl(i) := l_resource_rec_tbl(i).resource_class_flag;
3310: END IF;
3311:
3312: IF l_resource_rec_tbl(i).resource_class_code = FND_API.G_MISS_CHAR THEN
3313: l_resource_class_code_tbl(i) := NULL;
3314: ELSE
3315: l_resource_class_code_tbl(i) := l_resource_rec_tbl(i).resource_class_code;
3316: END IF;
3314: ELSE
3315: l_resource_class_code_tbl(i) := l_resource_rec_tbl(i).resource_class_code;
3316: END IF;
3317:
3318: IF l_resource_rec_tbl(i).resource_class_id = FND_API.G_MISS_NUM THEN
3319: l_resource_class_id_tbl(i) := NULL;
3320: ELSE
3321: l_resource_class_id_tbl(i) := l_resource_rec_tbl(i).resource_class_id;
3322: END IF;
3320: ELSE
3321: l_resource_class_id_tbl(i) := l_resource_rec_tbl(i).resource_class_id;
3322: END IF;
3323:
3324: IF l_resource_rec_tbl(i).res_type_code = FND_API.G_MISS_CHAR THEN
3325: l_res_type_code_tbl(i) := NULL;
3326: ELSE
3327: l_res_type_code_tbl(i) := l_resource_rec_tbl(i).res_type_code;
3328: END IF;
3326: ELSE
3327: l_res_type_code_tbl(i) := l_resource_rec_tbl(i).res_type_code;
3328: END IF;
3329:
3330: IF l_resource_rec_tbl(i).person_id = FND_API.G_MISS_NUM THEN
3331: l_person_id_tbl(i) := NULL;
3332: ELSE
3333: l_person_id_tbl(i) := l_resource_rec_tbl(i).person_id;
3334: END IF;
3332: ELSE
3333: l_person_id_tbl(i) := l_resource_rec_tbl(i).person_id;
3334: END IF;
3335:
3336: IF l_resource_rec_tbl(i).job_id = FND_API.G_MISS_NUM THEN
3337: l_job_id_tbl(i) := NULL;
3338: ELSE
3339: l_job_id_tbl(i) := l_resource_rec_tbl(i).job_id;
3340: END IF;
3338: ELSE
3339: l_job_id_tbl(i) := l_resource_rec_tbl(i).job_id;
3340: END IF;
3341:
3342: IF l_resource_rec_tbl(i).person_type_code = FND_API.G_MISS_CHAR THEN
3343: l_person_type_code_tbl(i) := NULL;
3344: ELSE
3345: l_person_type_code_tbl(i) := l_resource_rec_tbl(i).person_type_code;
3346: END IF;
3344: ELSE
3345: l_person_type_code_tbl(i) := l_resource_rec_tbl(i).person_type_code;
3346: END IF;
3347:
3348: IF l_resource_rec_tbl(i).bom_resource_id = FND_API.G_MISS_NUM THEN
3349: l_bom_resource_id_tbl(i) := NULL;
3350: ELSE
3351: l_bom_resource_id_tbl(i) := l_resource_rec_tbl(i).bom_resource_id;
3352: END IF;
3350: ELSE
3351: l_bom_resource_id_tbl(i) := l_resource_rec_tbl(i).bom_resource_id;
3352: END IF;
3353:
3354: IF l_resource_rec_tbl(i).inventory_item_id = FND_API.G_MISS_NUM THEN
3355: l_inventory_item_id_tbl(i) := NULL;
3356: ELSE
3357: l_inventory_item_id_tbl(i) := l_resource_rec_tbl(i).inventory_item_id;
3358: END IF;
3356: ELSE
3357: l_inventory_item_id_tbl(i) := l_resource_rec_tbl(i).inventory_item_id;
3358: END IF;
3359:
3360: IF l_resource_rec_tbl(i).item_category_id = FND_API.G_MISS_NUM THEN
3361: l_item_category_id_tbl(i) := NULL;
3362: ELSE
3363: l_item_category_id_tbl(i) := l_resource_rec_tbl(i).item_category_id;
3364: END IF;
3362: ELSE
3363: l_item_category_id_tbl(i) := l_resource_rec_tbl(i).item_category_id;
3364: END IF;
3365:
3366: IF l_resource_rec_tbl(i).project_role_id = FND_API.G_MISS_NUM THEN
3367: l_project_role_id_tbl(i) := NULL;
3368: ELSE
3369: l_project_role_id_tbl(i) := l_resource_rec_tbl(i).project_role_id;
3370: END IF;
3368: ELSE
3369: l_project_role_id_tbl(i) := l_resource_rec_tbl(i).project_role_id;
3370: END IF;
3371:
3372: IF l_resource_rec_tbl(i).organization_id = FND_API.G_MISS_NUM THEN
3373: l_organization_id_tbl(i) := NULL;
3374: ELSE
3375: l_organization_id_tbl(i) := l_resource_rec_tbl(i).organization_id;
3376: END IF;
3374: ELSE
3375: l_organization_id_tbl(i) := l_resource_rec_tbl(i).organization_id;
3376: END IF;
3377:
3378: IF l_resource_rec_tbl(i).fc_res_type_code = FND_API.G_MISS_CHAR THEN
3379: l_fc_res_type_code_tbl(i) := NULL;
3380: ELSE
3381: l_fc_res_type_code_tbl(i) := l_resource_rec_tbl(i).fc_res_type_code;
3382: END IF;
3380: ELSE
3381: l_fc_res_type_code_tbl(i) := l_resource_rec_tbl(i).fc_res_type_code;
3382: END IF;
3383:
3384: IF l_resource_rec_tbl(i).expenditure_type = FND_API.G_MISS_CHAR THEN
3385: l_expenditure_type_tbl(i) := NULL;
3386: ELSE
3387: l_expenditure_type_tbl(i) := l_resource_rec_tbl(i).expenditure_type;
3388: END IF;
3386: ELSE
3387: l_expenditure_type_tbl(i) := l_resource_rec_tbl(i).expenditure_type;
3388: END IF;
3389:
3390: IF l_resource_rec_tbl(i).expenditure_category = FND_API.G_MISS_CHAR THEN
3391: l_expenditure_category_tbl(i) := NULL;
3392: ELSE
3393: l_expenditure_category_tbl(i) := l_resource_rec_tbl(i).expenditure_category;
3394: END IF;
3392: ELSE
3393: l_expenditure_category_tbl(i) := l_resource_rec_tbl(i).expenditure_category;
3394: END IF;
3395:
3396: IF l_resource_rec_tbl(i).event_type = FND_API.G_MISS_CHAR THEN
3397: l_event_type_tbl(i) := NULL;
3398: ELSE
3399: l_event_type_tbl(i) := l_resource_rec_tbl(i).event_type;
3400: END IF;
3398: ELSE
3399: l_event_type_tbl(i) := l_resource_rec_tbl(i).event_type;
3400: END IF;
3401:
3402: IF l_resource_rec_tbl(i).revenue_category_code = FND_API.G_MISS_CHAR THEN
3403: l_revenue_category_code_tbl(i) := NULL;
3404: ELSE
3405: l_revenue_category_code_tbl(i) := l_resource_rec_tbl(i).revenue_category_code;
3406: END IF;
3404: ELSE
3405: l_revenue_category_code_tbl(i) := l_resource_rec_tbl(i).revenue_category_code;
3406: END IF;
3407:
3408: IF l_resource_rec_tbl(i).supplier_id = FND_API.G_MISS_NUM THEN
3409: l_supplier_id_tbl(i) := NULL;
3410: ELSE
3411: l_supplier_id_tbl(i) := l_resource_rec_tbl(i).supplier_id;
3412: END IF;
3410: ELSE
3411: l_supplier_id_tbl(i) := l_resource_rec_tbl(i).supplier_id;
3412: END IF;
3413:
3414: IF l_resource_rec_tbl(i).unit_of_measure = FND_API.G_MISS_CHAR THEN
3415: l_unit_of_measure_tbl(i) := NULL;
3416: ELSE
3417: l_unit_of_measure_tbl(i) := l_resource_rec_tbl(i).unit_of_measure;
3418: END IF;
3416: ELSE
3417: l_unit_of_measure_tbl(i) := l_resource_rec_tbl(i).unit_of_measure;
3418: END IF;
3419:
3420: IF l_resource_rec_tbl(i).spread_curve_id = FND_API.G_MISS_NUM THEN
3421: l_spread_curve_id_tbl(i) := NULL;
3422: ELSE
3423: l_spread_curve_id_tbl(i) := l_resource_rec_tbl(i).spread_curve_id;
3424: END IF;
3422: ELSE
3423: l_spread_curve_id_tbl(i) := l_resource_rec_tbl(i).spread_curve_id;
3424: END IF;
3425:
3426: IF l_resource_rec_tbl(i).etc_method_code = FND_API.G_MISS_CHAR THEN
3427: l_etc_method_code_tbl(i) := NULL;
3428: ELSE
3429: l_etc_method_code_tbl(i) := l_resource_rec_tbl(i).etc_method_code;
3430: END IF;
3428: ELSE
3429: l_etc_method_code_tbl(i) := l_resource_rec_tbl(i).etc_method_code;
3430: END IF;
3431:
3432: IF l_resource_rec_tbl(i).mfc_cost_type_id = FND_API.G_MISS_NUM THEN
3433: l_mfc_cost_type_id_tbl(i) := NULL;
3434: ELSE
3435: l_mfc_cost_type_id_tbl(i) := l_resource_rec_tbl(i).mfc_cost_type_id;
3436: END IF;
3434: ELSE
3435: l_mfc_cost_type_id_tbl(i) := l_resource_rec_tbl(i).mfc_cost_type_id;
3436: END IF;
3437:
3438: IF l_resource_rec_tbl(i).procure_resource_flag = FND_API.G_MISS_CHAR THEN
3439: l_procure_resource_flag_tbl(i) := NULL;
3440: ELSE
3441: l_procure_resource_flag_tbl(i) := l_resource_rec_tbl(i).procure_resource_flag;
3442: END IF;
3440: ELSE
3441: l_procure_resource_flag_tbl(i) := l_resource_rec_tbl(i).procure_resource_flag;
3442: END IF;
3443:
3444: IF l_resource_rec_tbl(i).incurred_by_res_flag = FND_API.G_MISS_CHAR THEN
3445: l_incurred_by_res_flag_tbl(i) := NULL;
3446: ELSE
3447: l_incurred_by_res_flag_tbl(i) := l_resource_rec_tbl(i).incurred_by_res_flag;
3448: END IF;
3446: ELSE
3447: l_incurred_by_res_flag_tbl(i) := l_resource_rec_tbl(i).incurred_by_res_flag;
3448: END IF;
3449:
3450: IF l_resource_rec_tbl(i).Incur_by_res_class_code = FND_API.G_MISS_CHAR THEN
3451: l_Incur_by_res_class_code_tbl(i) := NULL;
3452: ELSE
3453: l_Incur_by_res_class_code_tbl(i) := l_resource_rec_tbl(i).Incur_by_res_class_code;
3454: END IF;
3452: ELSE
3453: l_Incur_by_res_class_code_tbl(i) := l_resource_rec_tbl(i).Incur_by_res_class_code;
3454: END IF;
3455:
3456: IF l_resource_rec_tbl(i).Incur_by_role_id = FND_API.G_MISS_NUM THEN
3457: l_Incur_by_role_id_tbl(i) := NULL;
3458: ELSE
3459: l_Incur_by_role_id_tbl(i) := l_resource_rec_tbl(i).Incur_by_role_id;
3460: END IF;
3458: ELSE
3459: l_Incur_by_role_id_tbl(i) := l_resource_rec_tbl(i).Incur_by_role_id;
3460: END IF;
3461:
3462: IF l_resource_rec_tbl(i).named_role = FND_API.G_MISS_CHAR THEN
3463: l_named_role_tbl(i) := NULL;
3464: ELSE
3465: l_named_role_tbl(i) := l_resource_rec_tbl(i).named_role;
3466: END IF;
3464: ELSE
3465: l_named_role_tbl(i) := l_resource_rec_tbl(i).named_role;
3466: END IF;
3467:
3468: IF l_resource_rec_tbl(i).non_labor_resource = FND_API.G_MISS_CHAR THEN
3469: l_non_labor_resource_tbl(i) := NULL;
3470: ELSE
3471: l_non_labor_resource_tbl(i) := l_resource_rec_tbl(i).non_labor_resource;
3472: END IF;
3470: ELSE
3471: l_non_labor_resource_tbl(i) := l_resource_rec_tbl(i).non_labor_resource;
3472: END IF;
3473:
3474: IF l_resource_rec_tbl(i).resource_assignment_id = FND_API.G_MISS_NUM THEN
3475: l_resource_assignment_id_tbl(i) := NULL;
3476: ELSE
3477: l_resource_assignment_id_tbl(i) := l_resource_rec_tbl(i).resource_assignment_id;
3478: END IF;
3476: ELSE
3477: l_resource_assignment_id_tbl(i) := l_resource_rec_tbl(i).resource_assignment_id;
3478: END IF;
3479:
3480: IF l_resource_rec_tbl(i).assignment_description = FND_API.G_MISS_CHAR THEN
3481: l_assignment_description_tbl(i) := NULL;
3482: ELSE
3483: l_assignment_description_tbl(i) := l_resource_rec_tbl(i).assignment_description;
3484: END IF;
3482: ELSE
3483: l_assignment_description_tbl(i) := l_resource_rec_tbl(i).assignment_description;
3484: END IF;
3485:
3486: IF l_resource_rec_tbl(i).planning_resource_alias = FND_API.G_MISS_CHAR THEN
3487: l_planning_resource_alias_tbl(i) := NULL;
3488: ELSE
3489: l_planning_resource_alias_tbl(i) := l_resource_rec_tbl(i).planning_resource_alias;
3490: END IF;
3488: ELSE
3489: l_planning_resource_alias_tbl(i) := l_resource_rec_tbl(i).planning_resource_alias;
3490: END IF;
3491:
3492: IF l_resource_rec_tbl(i).resource_name = FND_API.G_MISS_CHAR THEN
3493: l_resource_name_tbl(i) := NULL;
3494: ELSE
3495: l_resource_name_tbl(i) := l_resource_rec_tbl(i).resource_name;
3496: END IF;
3494: ELSE
3495: l_resource_name_tbl(i) := l_resource_rec_tbl(i).resource_name;
3496: END IF;
3497:
3498: IF l_resource_rec_tbl(i).project_role_name = FND_API.G_MISS_CHAR THEN
3499: l_project_role_name_tbl(i) := NULL;
3500: ELSE
3501: l_project_role_name_tbl(i) := l_resource_rec_tbl(i).project_role_name;
3502: END IF;
3500: ELSE
3501: l_project_role_name_tbl(i) := l_resource_rec_tbl(i).project_role_name;
3502: END IF;
3503:
3504: IF l_resource_rec_tbl(i).organization_name = FND_API.G_MISS_CHAR THEN
3505: l_organization_name_tbl(i) := NULL;
3506: ELSE
3507: l_organization_name_tbl(i) := l_resource_rec_tbl(i).organization_name;
3508: END IF;
3506: ELSE
3507: l_organization_name_tbl(i) := l_resource_rec_tbl(i).organization_name;
3508: END IF;
3509:
3510: IF l_resource_rec_tbl(i).financial_category_code = FND_API.G_MISS_CHAR THEN
3511: l_financial_category_code_tbl(i) := NULL;
3512: ELSE
3513: l_financial_category_code_tbl(i) := l_resource_rec_tbl(i).financial_category_code;
3514: END IF;
3512: ELSE
3513: l_financial_category_code_tbl(i) := l_resource_rec_tbl(i).financial_category_code;
3514: END IF;
3515:
3516: IF l_resource_rec_tbl(i).project_assignment_id = FND_API.G_MISS_NUM THEN
3517: l_project_assignment_id_tbl(i) := NULL;
3518: ELSE
3519: l_project_assignment_id_tbl(i) := l_resource_rec_tbl(i).project_assignment_id;
3520: END IF;
3519: l_project_assignment_id_tbl(i) := l_resource_rec_tbl(i).project_assignment_id;
3520: END IF;
3521:
3522: -- gboomina modified for bug 8586393 - start
3523: /*IF l_resource_rec_tbl(i).use_task_schedule_flag = FND_API.G_MISS_CHAR THEN
3524: l_use_task_schedule_flag_tbl(i) := NULL;
3525: ELSE
3526: l_use_task_schedule_flag_tbl(i) := l_resource_rec_tbl(i).use_task_schedule_flag;
3527: END IF; */
3533:
3534: -- rbruno bug 9468665 - start
3535: -- set the default value only if use_task_schedule_flag value is G_MISS_CHAR
3536: -- SPOKANAT for Bug 9759832 - start
3537: IF l_resource_rec_tbl(i).use_task_schedule_flag = FND_API.G_MISS_CHAR then
3538: l_use_task_schedule_flag_tbl(i) := NULL;
3539: ELSE
3540: l_use_task_schedule_flag_tbl(i) := l_resource_rec_tbl(i).use_task_schedule_flag;
3541: END IF;
3541: END IF;
3542: -- SPOKANAT for Bug 9759832 - end
3543: -- rbruno bug 9468665 - end
3544:
3545: IF l_resource_rec_tbl(i).planning_start_date = FND_API.G_MISS_DATE THEN
3546: l_planning_start_date_tbl(i) := NULL;
3547: ELSE
3548: l_planning_start_date_tbl(i) := l_resource_rec_tbl(i).planning_start_date;
3549: END IF;
3547: ELSE
3548: l_planning_start_date_tbl(i) := l_resource_rec_tbl(i).planning_start_date;
3549: END IF;
3550:
3551: IF l_resource_rec_tbl(i).planning_end_date = FND_API.G_MISS_DATE THEN
3552: l_planning_end_date_tbl(i) := NULL;
3553: ELSE
3554: l_planning_end_date_tbl(i) := l_resource_rec_tbl(i).planning_end_date;
3555: END IF;
3553: ELSE
3554: l_planning_end_date_tbl(i) := l_resource_rec_tbl(i).planning_end_date;
3555: END IF;
3556:
3557: IF l_resource_rec_tbl(i).schedule_start_date = FND_API.G_MISS_DATE THEN
3558: l_schedule_start_date_tbl(i) := NULL;
3559: ELSE
3560: l_schedule_start_date_tbl(i) := l_resource_rec_tbl(i).schedule_start_date;
3561: END IF;
3559: ELSE
3560: l_schedule_start_date_tbl(i) := l_resource_rec_tbl(i).schedule_start_date;
3561: END IF;
3562:
3563: IF l_resource_rec_tbl(i).schedule_end_date = FND_API.G_MISS_DATE THEN
3564: l_schedule_end_date_tbl(i) := NULL;
3565: ELSE
3566: l_schedule_end_date_tbl(i) := l_resource_rec_tbl(i).schedule_end_date;
3567: END IF;
3565: ELSE
3566: l_schedule_end_date_tbl(i) := l_resource_rec_tbl(i).schedule_end_date;
3567: END IF;
3568:
3569: IF l_resource_rec_tbl(i).supplier_name = FND_API.G_MISS_CHAR THEN
3570: l_supplier_name_tbl(i) := NULL;
3571: ELSE
3572: l_supplier_name_tbl(i) := l_resource_rec_tbl(i).supplier_name;
3573: END IF;
3571: ELSE
3572: l_supplier_name_tbl(i) := l_resource_rec_tbl(i).supplier_name;
3573: END IF;
3574:
3575: IF l_resource_rec_tbl(i).financial_category_name = FND_API.G_MISS_CHAR THEN
3576: l_financial_category_name_tbl(i) := NULL;
3577: ELSE
3578: l_financial_category_name_tbl(i) := l_resource_rec_tbl(i).financial_category_name;
3579: END IF;
3577: ELSE
3578: l_financial_category_name_tbl(i) := l_resource_rec_tbl(i).financial_category_name;
3579: END IF;
3580:
3581: IF l_resource_rec_tbl(i).sp_fixed_date = FND_API.G_MISS_DATE THEN
3582: l_sp_fixed_date_tbl(i) := NULL;
3583: ELSE
3584: l_sp_fixed_date_tbl(i) := l_resource_rec_tbl(i).sp_fixed_date;
3585: -- Added validation rule for sp_fixed_date to lie between planning start date and planning end date for
3613: END IF;
3614: -- Bug 3607061 Ends
3615: END IF;
3616:
3617: IF l_resource_rec_tbl(i).burdened_rate_override = FND_API.G_MISS_NUM THEN
3618: l_burdened_rate_override_tbl(i) := NULL;
3619: ELSE
3620: l_burdened_rate_override_tbl(i) := l_resource_rec_tbl(i).burdened_rate_override;
3621: END IF;
3619: ELSE
3620: l_burdened_rate_override_tbl(i) := l_resource_rec_tbl(i).burdened_rate_override;
3621: END IF;
3622:
3623: IF l_resource_rec_tbl(i).cost_rate_override = FND_API.G_MISS_NUM THEN
3624: l_cost_rate_override_tbl(i) := NULL;
3625: ELSE
3626: l_cost_rate_override_tbl(i) := l_resource_rec_tbl(i).cost_rate_override;
3627: END IF;
3625: ELSE
3626: l_cost_rate_override_tbl(i) := l_resource_rec_tbl(i).cost_rate_override;
3627: END IF;
3628:
3629: IF l_resource_rec_tbl(i).billable_percent = FND_API.G_MISS_NUM THEN
3630: l_billable_percent_tbl(i) := NULL;
3631: ELSE
3632: l_billable_percent_tbl(i) := l_resource_rec_tbl(i).billable_percent;
3633: END IF;
3631: ELSE
3632: l_billable_percent_tbl(i) := l_resource_rec_tbl(i).billable_percent;
3633: END IF;
3634:
3635: IF l_resource_rec_tbl(i).override_currency_code = FND_API.G_MISS_CHAR THEN
3636: l_override_currency_code_tbl(i) := NULL;
3637: ELSE
3638: l_override_currency_code_tbl(i) := l_resource_rec_tbl(i).override_currency_code;
3639: END IF;
3637: ELSE
3638: l_override_currency_code_tbl(i) := l_resource_rec_tbl(i).override_currency_code;
3639: END IF;
3640:
3641: IF l_resource_rec_tbl(i).total_quantity = FND_API.G_MISS_NUM THEN
3642: l_total_quantity_tbl(i) := NULL;
3643: ELSE
3644: l_total_quantity_tbl(i) := l_resource_rec_tbl(i).total_quantity;
3645: END IF;
3643: ELSE
3644: l_total_quantity_tbl(i) := l_resource_rec_tbl(i).total_quantity;
3645: END IF;
3646:
3647: IF l_resource_rec_tbl(i).ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR THEN
3648: l_ATTRIBUTE_CATEGORY_tbl(i) := NULL;
3649: ELSE
3650: l_ATTRIBUTE_CATEGORY_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE_CATEGORY;
3651: END IF;
3649: ELSE
3650: l_ATTRIBUTE_CATEGORY_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE_CATEGORY;
3651: END IF;
3652:
3653: IF l_resource_rec_tbl(i).ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
3654: l_ATTRIBUTE1_tbl(i) := NULL;
3655: ELSE
3656: l_ATTRIBUTE1_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE1;
3657: END IF;
3655: ELSE
3656: l_ATTRIBUTE1_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE1;
3657: END IF;
3658:
3659: IF l_resource_rec_tbl(i).ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN
3660: l_ATTRIBUTE2_tbl(i) := NULL;
3661: ELSE
3662: l_ATTRIBUTE2_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE2;
3663: END IF;
3661: ELSE
3662: l_ATTRIBUTE2_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE2;
3663: END IF;
3664:
3665: IF l_resource_rec_tbl(i).ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN
3666: l_ATTRIBUTE3_tbl(i) := NULL;
3667: ELSE
3668: l_ATTRIBUTE3_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE3;
3669: END IF;
3667: ELSE
3668: l_ATTRIBUTE3_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE3;
3669: END IF;
3670:
3671: IF l_resource_rec_tbl(i).ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN
3672: l_ATTRIBUTE4_tbl(i) := NULL;
3673: ELSE
3674: l_ATTRIBUTE4_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE4;
3675: END IF;
3673: ELSE
3674: l_ATTRIBUTE4_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE4;
3675: END IF;
3676:
3677: IF l_resource_rec_tbl(i).ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN
3678: l_ATTRIBUTE5_tbl(i) := NULL;
3679: ELSE
3680: l_ATTRIBUTE5_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE5;
3681: END IF;
3679: ELSE
3680: l_ATTRIBUTE5_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE5;
3681: END IF;
3682:
3683: IF l_resource_rec_tbl(i).ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN
3684: l_ATTRIBUTE6_tbl(i) := NULL;
3685: ELSE
3686: l_ATTRIBUTE6_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE6;
3687: END IF;
3685: ELSE
3686: l_ATTRIBUTE6_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE6;
3687: END IF;
3688:
3689: IF l_resource_rec_tbl(i).ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN
3690: l_ATTRIBUTE7_tbl(i) := NULL;
3691: ELSE
3692: l_ATTRIBUTE7_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE7;
3693: END IF;
3691: ELSE
3692: l_ATTRIBUTE7_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE7;
3693: END IF;
3694:
3695: IF l_resource_rec_tbl(i).ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN
3696: l_ATTRIBUTE8_tbl(i) := NULL;
3697: ELSE
3698: l_ATTRIBUTE8_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE8;
3699: END IF;
3697: ELSE
3698: l_ATTRIBUTE8_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE8;
3699: END IF;
3700:
3701: IF l_resource_rec_tbl(i).ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN
3702: l_ATTRIBUTE9_tbl(i) := NULL;
3703: ELSE
3704: l_ATTRIBUTE9_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE9;
3705: END IF;
3703: ELSE
3704: l_ATTRIBUTE9_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE9;
3705: END IF;
3706:
3707: IF l_resource_rec_tbl(i).ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN
3708: l_ATTRIBUTE10_tbl(i) := NULL;
3709: ELSE
3710: l_ATTRIBUTE10_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE10;
3711: END IF;
3709: ELSE
3710: l_ATTRIBUTE10_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE10;
3711: END IF;
3712:
3713: IF l_resource_rec_tbl(i).ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN
3714: l_ATTRIBUTE11_tbl(i) := NULL;
3715: ELSE
3716: l_ATTRIBUTE11_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE11;
3717: END IF;
3715: ELSE
3716: l_ATTRIBUTE11_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE11;
3717: END IF;
3718:
3719: IF l_resource_rec_tbl(i).ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN
3720: l_ATTRIBUTE12_tbl(i) := NULL;
3721: ELSE
3722: l_ATTRIBUTE12_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE12;
3723: END IF;
3721: ELSE
3722: l_ATTRIBUTE12_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE12;
3723: END IF;
3724:
3725: IF l_resource_rec_tbl(i).ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN
3726: l_ATTRIBUTE13_tbl(i) := NULL;
3727: ELSE
3728: l_ATTRIBUTE13_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE13;
3729: END IF;
3727: ELSE
3728: l_ATTRIBUTE13_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE13;
3729: END IF;
3730:
3731: IF l_resource_rec_tbl(i).ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN
3732: l_ATTRIBUTE14_tbl(i) := NULL;
3733: ELSE
3734: l_ATTRIBUTE14_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE14;
3735: END IF;
3733: ELSE
3734: l_ATTRIBUTE14_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE14;
3735: END IF;
3736:
3737: IF l_resource_rec_tbl(i).ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN
3738: l_ATTRIBUTE15_tbl(i) := NULL;
3739: ELSE
3740: l_ATTRIBUTE15_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE15;
3741: END IF;
3739: ELSE
3740: l_ATTRIBUTE15_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE15;
3741: END IF;
3742:
3743: IF l_resource_rec_tbl(i).ATTRIBUTE16 = FND_API.G_MISS_CHAR THEN
3744: l_ATTRIBUTE16_tbl(i) := NULL;
3745: ELSE
3746: l_ATTRIBUTE16_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE16;
3747: END IF;
3745: ELSE
3746: l_ATTRIBUTE16_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE16;
3747: END IF;
3748:
3749: IF l_resource_rec_tbl(i).ATTRIBUTE17 = FND_API.G_MISS_CHAR THEN
3750: l_ATTRIBUTE17_tbl(i) := NULL;
3751: ELSE
3752: l_ATTRIBUTE17_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE17;
3753: END IF;
3751: ELSE
3752: l_ATTRIBUTE17_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE17;
3753: END IF;
3754:
3755: IF l_resource_rec_tbl(i).ATTRIBUTE18 = FND_API.G_MISS_CHAR THEN
3756: l_ATTRIBUTE18_tbl(i) := NULL;
3757: ELSE
3758: l_ATTRIBUTE18_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE18;
3759: END IF;
3757: ELSE
3758: l_ATTRIBUTE18_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE18;
3759: END IF;
3760:
3761: IF l_resource_rec_tbl(i).ATTRIBUTE19 = FND_API.G_MISS_CHAR THEN
3762: l_ATTRIBUTE19_tbl(i) := NULL;
3763: ELSE
3764: l_ATTRIBUTE19_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE19;
3765: END IF;
3763: ELSE
3764: l_ATTRIBUTE19_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE19;
3765: END IF;
3766:
3767: IF l_resource_rec_tbl(i).ATTRIBUTE20 = FND_API.G_MISS_CHAR THEN
3768: l_ATTRIBUTE20_tbl(i) := NULL;
3769: ELSE
3770: l_ATTRIBUTE20_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE20;
3771: END IF;
3768: l_ATTRIBUTE20_tbl(i) := NULL;
3769: ELSE
3770: l_ATTRIBUTE20_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE20;
3771: END IF;
3772: IF l_resource_rec_tbl(i).ATTRIBUTE21 = FND_API.G_MISS_CHAR THEN
3773: l_ATTRIBUTE21_tbl(i) := NULL;
3774: ELSE
3775: l_ATTRIBUTE21_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE21;
3776: END IF;
3774: ELSE
3775: l_ATTRIBUTE21_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE21;
3776: END IF;
3777:
3778: IF l_resource_rec_tbl(i).ATTRIBUTE22 = FND_API.G_MISS_CHAR THEN
3779: l_ATTRIBUTE22_tbl(i) := NULL;
3780: ELSE
3781: l_ATTRIBUTE22_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE22;
3782: END IF;
3780: ELSE
3781: l_ATTRIBUTE22_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE22;
3782: END IF;
3783:
3784: IF l_resource_rec_tbl(i).ATTRIBUTE23 = FND_API.G_MISS_CHAR THEN
3785: l_ATTRIBUTE23_tbl(i) := NULL;
3786: ELSE
3787: l_ATTRIBUTE23_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE23;
3788: END IF;
3786: ELSE
3787: l_ATTRIBUTE23_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE23;
3788: END IF;
3789:
3790: IF l_resource_rec_tbl(i).ATTRIBUTE24 = FND_API.G_MISS_CHAR THEN
3791: l_ATTRIBUTE24_tbl(i) := NULL;
3792: ELSE
3793: l_ATTRIBUTE24_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE24;
3794: END IF;
3792: ELSE
3793: l_ATTRIBUTE24_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE24;
3794: END IF;
3795:
3796: IF l_resource_rec_tbl(i).ATTRIBUTE25 = FND_API.G_MISS_CHAR THEN
3797: l_ATTRIBUTE25_tbl(i) := NULL;
3798: ELSE
3799: l_ATTRIBUTE25_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE25;
3800: END IF;
3798: ELSE
3799: l_ATTRIBUTE25_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE25;
3800: END IF;
3801:
3802: IF l_resource_rec_tbl(i).ATTRIBUTE26 = FND_API.G_MISS_CHAR THEN
3803: l_ATTRIBUTE26_tbl(i) := NULL;
3804: ELSE
3805: l_ATTRIBUTE26_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE26;
3806: END IF;
3804: ELSE
3805: l_ATTRIBUTE26_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE26;
3806: END IF;
3807:
3808: IF l_resource_rec_tbl(i).ATTRIBUTE27 = FND_API.G_MISS_CHAR THEN
3809: l_ATTRIBUTE27_tbl(i) := NULL;
3810: ELSE
3811: l_ATTRIBUTE27_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE27;
3812: END IF;
3810: ELSE
3811: l_ATTRIBUTE27_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE27;
3812: END IF;
3813:
3814: IF l_resource_rec_tbl(i).ATTRIBUTE28 = FND_API.G_MISS_CHAR THEN
3815: l_ATTRIBUTE28_tbl(i) := NULL;
3816: ELSE
3817: l_ATTRIBUTE28_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE28;
3818: END IF;
3816: ELSE
3817: l_ATTRIBUTE28_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE28;
3818: END IF;
3819:
3820: IF l_resource_rec_tbl(i).ATTRIBUTE29 = FND_API.G_MISS_CHAR THEN
3821: l_ATTRIBUTE29_tbl(i) := NULL;
3822: ELSE
3823: l_ATTRIBUTE29_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE29;
3824: END IF;
3822: ELSE
3823: l_ATTRIBUTE29_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE29;
3824: END IF;
3825:
3826: IF l_resource_rec_tbl(i).ATTRIBUTE30 = FND_API.G_MISS_CHAR THEN
3827: l_ATTRIBUTE30_tbl(i) := NULL;
3828: ELSE
3829: l_ATTRIBUTE30_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE30;
3830: END IF;
3828: ELSE
3829: l_ATTRIBUTE30_tbl(i) := l_resource_rec_tbl(i).ATTRIBUTE30;
3830: END IF;
3831:
3832: IF l_resource_rec_tbl(i).UNPLANNED_FLAG = FND_API.G_MISS_CHAR THEN
3833: l_UNPLANNED_FLAG_TBL(i) := NULL;
3834: ELSE
3835: l_UNPLANNED_FLAG_TBL(i) := l_resource_rec_tbl(i).UNPLANNED_FLAG;
3836: END IF;
3834: ELSE
3835: l_UNPLANNED_FLAG_TBL(i) := l_resource_rec_tbl(i).UNPLANNED_FLAG;
3836: END IF;
3837:
3838: IF l_resource_rec_tbl(i).scheduled_delay = FND_API.G_MISS_NUM THEN
3839: l_scheduled_delay(i) := NULL;
3840: ELSE
3841: l_scheduled_delay(i) := l_resource_rec_tbl(i).scheduled_delay;
3842: END IF;
3981: ,x_msg_data => x_msg_data
3982: ,x_msg_count => x_msg_count
3983: ,x_return_status => x_return_status );
3984:
3985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3986:
3987: IF l_debug_mode = 'Y' THEN
3988: pa_debug.g_err_stage:='Called API pafpptub.get_default_planning_dates returned error';
3989: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ',pa_debug.g_err_stage, 3);
4256: -- gboomina Bug 8586393 - end
4257:
4258: FOR i IN p_task_elem_version_id_tbl.FIRST .. p_task_elem_version_id_tbl.LAST LOOP
4259: IF ((p_planned_people_effort_tbl.EXISTS(i)) AND
4260: (nvl(p_planned_people_effort_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
4261: /* bug fix:5726773 (p_planned_people_effort_tbl(i) > 0)) THEN*/
4262: (p_planned_people_effort_tbl(i) is NOT NULL)) THEN
4263: l_ins_proj_element_id_tbl(l_ins_index) := l_proj_element_id_tbl(i);
4264: l_ins_task_elem_version_id_tbl(l_ins_index) := p_task_elem_version_id_tbl(i);
4517: l_spread_amount_flags_tbl(l_index) := 'Y';
4518: l_currency_code_tbl(l_index) := l_proj_curr_code;
4519: -- END IF;
4520: IF l_ins_cal_raw_cost_tbl.EXISTS(k) AND
4521: NVL(l_ins_cal_raw_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
4522: /* bug fix:Bug fix:5726773 l_ins_cal_raw_cost_tbl(k) <> 0 THEN */
4523: l_ins_cal_raw_cost_tbl(k) is NOT NULL THEN
4524: l_raw_cost_tbl(l_index) := l_ins_cal_raw_cost_tbl(k);
4525: END IF;
4523: l_ins_cal_raw_cost_tbl(k) is NOT NULL THEN
4524: l_raw_cost_tbl(l_index) := l_ins_cal_raw_cost_tbl(k);
4525: END IF;
4526: IF l_ins_cal_burdened_cost_tbl.EXISTS(k) AND
4527: NVL(l_ins_cal_burdened_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
4528: /* bug fix:Bug fix:5726773 l_ins_cal_burdened_cost_tbl(k) <> 0 THEN */
4529: l_ins_cal_burdened_cost_tbl(k) is NOT NULL THEN
4530: l_burdened_cost_tbl(l_index) := l_ins_cal_burdened_cost_tbl(k);
4531: END IF;
4775: FOR i IN l_orig_count+1 .. l_orig_count+l_res_assignment_id_temp_tbl.COUNT LOOP -- bug 5003827 issue 22
4776: l_ra_id_temp_tbl(i) := l_res_assignment_id_temp_tbl(i-l_orig_count); -- bug 5003827 issue 22
4777: -- Bug 5003827 issue 1
4778: IF p_currency_code_tbl.EXISTS(i-l_orig_count) AND
4779: NVL(p_currency_code_tbl(i-l_orig_count),FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
4780: l_curr_code_temp_tbl(i) := p_currency_code_tbl(i-l_orig_count);
4781: ELSE
4782: l_curr_code_temp_tbl(i) := l_proj_curr_code;
4783: END IF;
4816: -- Bug 8370812 - Moved inside the IF loop
4817: -- l_res_assignment_id_tbl(l_index) := l_res_assignment_id_temp_tbl(k);
4818:
4819: IF (((l_total_quantity_tbl.EXISTS(k)) AND (l_total_quantity_tbl.COUNT > 0))
4820: AND ((nvl(l_total_quantity_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
4821: /* bug fix:Bug fix:5726773 AND (l_total_quantity_tbl(k) <> 0))) OR */
4822: AND (l_total_quantity_tbl(k) is NOT NULL ))) OR
4823: (((p_raw_cost_tbl.EXISTS(k)) AND (p_raw_cost_tbl.COUNT > 0))
4824: AND ((nvl(p_raw_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
4820: AND ((nvl(l_total_quantity_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
4821: /* bug fix:Bug fix:5726773 AND (l_total_quantity_tbl(k) <> 0))) OR */
4822: AND (l_total_quantity_tbl(k) is NOT NULL ))) OR
4823: (((p_raw_cost_tbl.EXISTS(k)) AND (p_raw_cost_tbl.COUNT > 0))
4824: AND ((nvl(p_raw_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
4825: /* bug fix:Bug fix:5726773 AND (p_raw_cost_tbl(k) <> 0))) OR */
4826: AND (p_raw_cost_tbl(k) is NOT NULL))) OR
4827: (((p_burdened_cost_tbl.EXISTS(k)) AND (p_burdened_cost_tbl.COUNT > 0))
4828: AND ((nvl(p_burdened_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
4824: AND ((nvl(p_raw_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
4825: /* bug fix:Bug fix:5726773 AND (p_raw_cost_tbl(k) <> 0))) OR */
4826: AND (p_raw_cost_tbl(k) is NOT NULL))) OR
4827: (((p_burdened_cost_tbl.EXISTS(k)) AND (p_burdened_cost_tbl.COUNT > 0))
4828: AND ((nvl(p_burdened_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)
4829: /* bug fix:Bug fix:5726773 AND (p_burdened_cost_tbl(k) <> 0))) THEN */
4830: AND (p_burdened_cost_tbl(k) is NOT NULL))) THEN
4831:
4832: IF l_debug_mode = 'Y' THEN
4841: l_call_calc_api := 'Y';
4842:
4843: -- Bug 3861653
4844: IF p_currency_code_tbl.EXISTS(k) AND
4845: NVL(p_currency_code_tbl(k),FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
4846:
4847: l_currency_code_tbl(l_index) := p_currency_code_tbl(k);
4848: ELSE
4849: l_currency_code_tbl(l_index) := l_proj_curr_code;
4849: l_currency_code_tbl(l_index) := l_proj_curr_code;
4850: END IF;
4851:
4852: IF l_total_quantity_tbl.EXISTS(k) AND
4853: NVL(l_total_quantity_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
4854: /* bug fix:Bug fix:5726773 l_total_quantity_tbl(k) <> 0 THEN */
4855: l_total_quantity_tbl(k) is NOT NULL THEN
4856:
4857: l_quantity_tbl(l_index) := l_total_quantity_tbl(k);
4860: l_cost_rate_tbl(l_index) := l_cost_rate_override_tbl(k);
4861: l_burden_multiplier_tbl(l_index) := l_burdened_rate_override_tbl(k);
4862:
4863: IF p_raw_cost_tbl.EXISTS(k) AND
4864: NVL(p_raw_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
4865: /* bug fix:Bug fix:5726773 p_raw_cost_tbl(k) <> 0 THEN */
4866: p_raw_cost_tbl(k) is NOT NULL THEN
4867:
4868: l_raw_cost_tbl(l_index) := p_raw_cost_tbl(k);
4868: l_raw_cost_tbl(l_index) := p_raw_cost_tbl(k);
4869: END IF;
4870:
4871: IF p_burdened_cost_tbl.EXISTS(k) AND
4872: NVL(p_burdened_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
4873: /* bug fix:Bug fix:5726773 P_burdened_cost_tbl(k) <> 0 THEN */
4874: P_burdened_cost_tbl(k) is NOT NULL THEN
4875:
4876: l_burdened_cost_tbl(l_index) := p_burdened_cost_tbl(k);
4883: l_curr_code_rollup_tbl.extend;
4884: l_ra_id_rollup_tbl(l_rollup_index) := l_res_assignment_id_temp_tbl(k);
4885:
4886: IF p_currency_code_tbl.EXISTS(k) AND
4887: NVL(p_currency_code_tbl(k),FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
4888:
4889: l_curr_code_rollup_tbl(l_rollup_index) := p_currency_code_tbl(k);
4890: ELSE
4891: l_curr_code_rollup_tbl(l_rollup_index) := l_proj_curr_code;
5539: l_res_assignment_id_tbl(l_index) := l_bf_ra_id_tbl(k);
5540: l_amount_exists :='N';
5541:
5542: IF l_bf_quantity_tbl.EXISTS(k) AND
5543: NVL(l_bf_quantity_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
5544: /* bug fix:Bug fix:5726773 l_bf_quantity_tbl(k) <> 0 THEN */
5545: l_bf_quantity_tbl(k) is NOT NULL THEN
5546: l_quantity_tbl(l_index) := l_bf_quantity_tbl(k);
5547: l_amount_exists := 'Y';
5547: l_amount_exists := 'Y';
5548: END IF;
5549:
5550: IF l_bf_raw_cost_tbl.EXISTS(k) AND
5551: NVL(l_bf_raw_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
5552: /* bug fix:Bug fix:5726773 l_bf_raw_cost_tbl(k) <> 0 THEN */
5553: l_bf_raw_cost_tbl(k) is NOT NULL THEN
5554: l_raw_cost_tbl(l_index) := l_bf_raw_cost_tbl(k);
5555: l_amount_exists := 'Y';
5555: l_amount_exists := 'Y';
5556: END IF;
5557:
5558: IF l_bf_burdened_cost_tbl.EXISTS(k) AND
5559: NVL(l_bf_burdened_cost_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
5560: /* bug fix:Bug fix:5726773 l_bf_burdened_cost_tbl(k) <> 0 THEN */
5561: l_bf_burdened_cost_tbl(k) is NOT NULL THEN
5562: l_burdened_cost_tbl(l_index) := l_bf_burdened_cost_tbl(k);
5563: l_amount_exists := 'Y';
5563: l_amount_exists := 'Y';
5564: END IF;
5565:
5566: IF l_bf_revenue_tbl.EXISTS(k) AND
5567: NVL(l_bf_revenue_tbl(k),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
5568: /* bug fix:Bug fix:5726773 l_bf_revenue_tbl(k) <> 0 THEN */
5569: l_bf_revenue_tbl(k) is NOT NULL THEN
5570: l_revenue_tbl(l_index) := l_bf_revenue_tbl(k);
5571: l_amount_exists := 'Y';
5577: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5578: END IF;
5579:
5580: IF l_bf_currency_code_tbl.EXISTS(k) AND
5581: NVL(l_bf_currency_code_tbl(k),FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
5582: l_currency_code_tbl(l_index) := l_bf_currency_code_tbl(k);
5583: ELSE
5584:
5585: IF l_debug_mode = 'Y' THEN
5704: ,x_return_status => l_return_status
5705: ,x_msg_count => l_msg_count
5706: ,x_msg_data => l_msg_data);
5707:
5708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5709: IF l_debug_mode = 'Y' THEN
5710: pa_debug.g_err_stage:='Called API PA_FP_CALC_PLAN_PKG.calculate api returned error';
5711: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5712: END IF;
5751: /* Bug 13419867 End */
5752:
5753: END IF;
5754:
5755: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5756: IF l_debug_mode = 'Y' THEN
5757: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
5758: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5759: END IF;
5792: x_msg_data => x_msg_data
5793: );
5794: END IF;
5795:
5796: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5797: IF l_debug_mode = 'Y' THEN
5798: pa_debug.g_err_stage:='Called API PA_FIN_PLAN_PUB.create_default_plan_txn_rec returned error';
5799: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5800: END IF;
5817: -- hr_utility.trace('x_return_status IS : ' || x_return_status);
5818: -- hr_utility.trace('x_msg_count IS : ' || x_msg_count);
5819: -- hr_utility.trace('x_msg_data IS : ' || x_msg_data);
5820:
5821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5822:
5823: IF l_debug_mode = 'Y' THEN
5824: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
5825: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5884: x_msg_count => x_msg_count,
5885: x_msg_data => x_msg_data
5886: );
5887:
5888: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5889:
5890: IF l_debug_mode = 'Y' THEN
5891: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
5892: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5905: ROLLBACK TO SAVEPOINT ADD_PLANNING_TRANS_SP;
5906: l_msg_count := FND_MSG_PUB.count_msg;
5907: IF l_msg_count = 1 THEN
5908: PA_INTERFACE_UTILS_PUB.get_messages
5909: (p_encoded => FND_API.G_TRUE
5910: ,p_msg_index => 1
5911: ,p_msg_count => l_msg_count
5912: ,p_msg_data => l_msg_data
5913: ,p_data => l_data
5918: ELSE
5919:
5920: x_msg_count := l_msg_count;
5921: END IF;
5922: x_return_status := FND_API.G_RET_STS_ERROR;
5923: IF l_debug_mode = 'Y' THEN
5924: pa_debug.reset_curr_function;
5925: END IF;
5926: WHEN OTHERS THEN
5925: END IF;
5926: WHEN OTHERS THEN
5927:
5928: ROLLBACK TO SAVEPOINT ADD_PLANNING_TRANS_SP;
5929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5930: x_msg_count := 1;
5931: x_msg_data := SQLERRM;
5932: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
5933: ,p_procedure_name => 'add_planning_transactions');
6242: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6243: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6244:
6245: --Added for Bug 4200168
6246: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
6247: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
6248: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;
6249:
6250: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
6243: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6244:
6245: --Added for Bug 4200168
6246: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
6247: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
6248: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;
6249:
6250: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
6251:
6244:
6245: --Added for Bug 4200168
6246: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;
6247: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;
6248: l_g_miss_date CONSTANT DATE := FND_API.G_MISS_DATE;
6249:
6250: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
6251:
6252: -- Bug 5906826
6266: --hr_utility.trace('PA_FP_PLAN_TXN_PUB.update_planning_transactions: '||to_char(l_trace_stage));
6267:
6268:
6269: x_msg_count := 0;
6270: x_return_status := FND_API.G_RET_STS_SUCCESS;
6271: l_debug_mode := 'Y'; --NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6272:
6273: --Added for Bug 4200168
6274: IF p_pji_rollup_required = 'Y' THEN
6386: ,p_struct_elem_version_id => p_struct_elem_version_id
6387: ,x_return_status => l_return_status
6388: ,x_msg_data => l_msg_data
6389: ,x_msg_count => l_msg_count);
6390: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6391: IF l_debug_mode = 'Y' THEN
6392: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_planning_transaction api returned error';
6393: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6394: END IF;
6437: RAISE;
6438: END;
6439:
6440: /* Bug 3817356 - We to cannot pass negative date from Java to PLSql hence we are not
6441: able to pass FND_API.G_MISS_DATE ('01-Jan--4712') to this API when called from Java.
6442: Instead when this API is called from Java instead of G_MISS_DATE '01-Jan-4712' is passed.
6443: Added code below to Replace '01-Jan-4712' by FND_API.G_MISS_DATE
6444: */
6445: IF l_debug_mode = 'Y' THEN
6439:
6440: /* Bug 3817356 - We to cannot pass negative date from Java to PLSql hence we are not
6441: able to pass FND_API.G_MISS_DATE ('01-Jan--4712') to this API when called from Java.
6442: Instead when this API is called from Java instead of G_MISS_DATE '01-Jan-4712' is passed.
6443: Added code below to Replace '01-Jan-4712' by FND_API.G_MISS_DATE
6444: */
6445: IF l_debug_mode = 'Y' THEN
6446: pa_debug.g_err_stage:='Processing IN Date Tables for G_MISS_DATE';
6447: pa_debug.write('PA_FP_PLANNING_TXN_PUB.update_planning_transactions:'||l_module_name,pa_debug.g_err_stage,3);
6460: IF p_task_elem_version_id_tbl.COUNT > 0 THEN
6461: FOR i IN p_task_elem_version_id_tbl.FIRST .. p_task_elem_version_id_tbl.LAST LOOP
6462: IF p_start_date_tbl.EXISTS(i)
6463: AND p_start_date_tbl(i) = l_temp_gmiss_date THEN
6464: l_in_start_date_tbl(i) := FND_API.G_MISS_DATE;
6465: END IF;
6466: IF p_end_date_tbl.EXISTS(i)
6467: AND p_end_date_tbl(i) = l_temp_gmiss_date THEN
6468: l_in_end_date_tbl(i) := FND_API.G_MISS_DATE;
6464: l_in_start_date_tbl(i) := FND_API.G_MISS_DATE;
6465: END IF;
6466: IF p_end_date_tbl.EXISTS(i)
6467: AND p_end_date_tbl(i) = l_temp_gmiss_date THEN
6468: l_in_end_date_tbl(i) := FND_API.G_MISS_DATE;
6469: END IF;
6470: IF p_planning_start_date_tbl.EXISTS(i)
6471: AND p_planning_start_date_tbl(i) = l_temp_gmiss_date THEN
6472: l_in_planning_start_date_tbl(i) := FND_API.G_MISS_DATE;
6468: l_in_end_date_tbl(i) := FND_API.G_MISS_DATE;
6469: END IF;
6470: IF p_planning_start_date_tbl.EXISTS(i)
6471: AND p_planning_start_date_tbl(i) = l_temp_gmiss_date THEN
6472: l_in_planning_start_date_tbl(i) := FND_API.G_MISS_DATE;
6473: END IF;
6474: IF p_planning_end_date_tbl.EXISTS(i)
6475: AND p_planning_end_date_tbl(i) = l_temp_gmiss_date THEN
6476: l_in_planning_end_date_tbl(i) := FND_API.G_MISS_DATE;
6472: l_in_planning_start_date_tbl(i) := FND_API.G_MISS_DATE;
6473: END IF;
6474: IF p_planning_end_date_tbl.EXISTS(i)
6475: AND p_planning_end_date_tbl(i) = l_temp_gmiss_date THEN
6476: l_in_planning_end_date_tbl(i) := FND_API.G_MISS_DATE;
6477: END IF;
6478: IF p_schedule_start_date_tbl.EXISTS(i)
6479: AND p_schedule_start_date_tbl(i) = l_temp_gmiss_date THEN
6480: l_in_schedule_start_date_tbl(i) := FND_API.G_MISS_DATE;
6476: l_in_planning_end_date_tbl(i) := FND_API.G_MISS_DATE;
6477: END IF;
6478: IF p_schedule_start_date_tbl.EXISTS(i)
6479: AND p_schedule_start_date_tbl(i) = l_temp_gmiss_date THEN
6480: l_in_schedule_start_date_tbl(i) := FND_API.G_MISS_DATE;
6481: END IF;
6482: IF p_schedule_end_date_tbl.EXISTS(i)
6483: AND p_schedule_end_date_tbl(i) = l_temp_gmiss_date THEN
6484: l_in_schedule_end_date_tbl(i) := FND_API.G_MISS_DATE;
6480: l_in_schedule_start_date_tbl(i) := FND_API.G_MISS_DATE;
6481: END IF;
6482: IF p_schedule_end_date_tbl.EXISTS(i)
6483: AND p_schedule_end_date_tbl(i) = l_temp_gmiss_date THEN
6484: l_in_schedule_end_date_tbl(i) := FND_API.G_MISS_DATE;
6485: END IF;
6486: IF p_sp_fixed_date_tbl.EXISTS(i)
6487: AND p_sp_fixed_date_tbl(i) = l_temp_gmiss_date THEN
6488: l_in_sp_fixed_date_tbl(i) := FND_API.G_MISS_DATE;
6484: l_in_schedule_end_date_tbl(i) := FND_API.G_MISS_DATE;
6485: END IF;
6486: IF p_sp_fixed_date_tbl.EXISTS(i)
6487: AND p_sp_fixed_date_tbl(i) = l_temp_gmiss_date THEN
6488: l_in_sp_fixed_date_tbl(i) := FND_API.G_MISS_DATE;
6489: END IF;
6490: END LOOP;
6491: END IF;
6492: ELSE
6493: IF p_resource_assignment_id_tbl.COUNT > 0 THEN
6494: FOR i IN p_resource_assignment_id_tbl.FIRST .. p_resource_assignment_id_tbl.LAST LOOP
6495: IF p_start_date_tbl.EXISTS(i)
6496: AND p_start_date_tbl(i) = l_temp_gmiss_date THEN
6497: l_in_start_date_tbl(i) := FND_API.G_MISS_DATE;
6498: END IF;
6499: IF p_end_date_tbl.EXISTS(i)
6500: AND p_end_date_tbl(i) = l_temp_gmiss_date THEN
6501: l_in_end_date_tbl(i) := FND_API.G_MISS_DATE;
6497: l_in_start_date_tbl(i) := FND_API.G_MISS_DATE;
6498: END IF;
6499: IF p_end_date_tbl.EXISTS(i)
6500: AND p_end_date_tbl(i) = l_temp_gmiss_date THEN
6501: l_in_end_date_tbl(i) := FND_API.G_MISS_DATE;
6502: END IF;
6503: IF p_planning_start_date_tbl.EXISTS(i)
6504: AND p_planning_start_date_tbl(i) = l_temp_gmiss_date THEN
6505: l_in_planning_start_date_tbl(i) := FND_API.G_MISS_DATE;
6501: l_in_end_date_tbl(i) := FND_API.G_MISS_DATE;
6502: END IF;
6503: IF p_planning_start_date_tbl.EXISTS(i)
6504: AND p_planning_start_date_tbl(i) = l_temp_gmiss_date THEN
6505: l_in_planning_start_date_tbl(i) := FND_API.G_MISS_DATE;
6506: END IF;
6507: IF p_planning_end_date_tbl.EXISTS(i)
6508: AND p_planning_end_date_tbl(i) = l_temp_gmiss_date THEN
6509: l_in_planning_end_date_tbl(i) := FND_API.G_MISS_DATE;
6505: l_in_planning_start_date_tbl(i) := FND_API.G_MISS_DATE;
6506: END IF;
6507: IF p_planning_end_date_tbl.EXISTS(i)
6508: AND p_planning_end_date_tbl(i) = l_temp_gmiss_date THEN
6509: l_in_planning_end_date_tbl(i) := FND_API.G_MISS_DATE;
6510: END IF;
6511: IF p_schedule_start_date_tbl.EXISTS(i)
6512: AND p_schedule_start_date_tbl(i) = l_temp_gmiss_date THEN
6513: l_in_schedule_start_date_tbl(i) := FND_API.G_MISS_DATE;
6509: l_in_planning_end_date_tbl(i) := FND_API.G_MISS_DATE;
6510: END IF;
6511: IF p_schedule_start_date_tbl.EXISTS(i)
6512: AND p_schedule_start_date_tbl(i) = l_temp_gmiss_date THEN
6513: l_in_schedule_start_date_tbl(i) := FND_API.G_MISS_DATE;
6514: END IF;
6515: IF p_schedule_end_date_tbl.EXISTS(i)
6516: AND p_schedule_end_date_tbl(i) = l_temp_gmiss_date THEN
6517: l_in_schedule_end_date_tbl(i) := FND_API.G_MISS_DATE;
6513: l_in_schedule_start_date_tbl(i) := FND_API.G_MISS_DATE;
6514: END IF;
6515: IF p_schedule_end_date_tbl.EXISTS(i)
6516: AND p_schedule_end_date_tbl(i) = l_temp_gmiss_date THEN
6517: l_in_schedule_end_date_tbl(i) := FND_API.G_MISS_DATE;
6518: END IF;
6519: IF p_sp_fixed_date_tbl.EXISTS(i)
6520: AND p_sp_fixed_date_tbl(i) = l_temp_gmiss_date THEN
6521: l_in_sp_fixed_date_tbl(i) := FND_API.G_MISS_DATE;
6517: l_in_schedule_end_date_tbl(i) := FND_API.G_MISS_DATE;
6518: END IF;
6519: IF p_sp_fixed_date_tbl.EXISTS(i)
6520: AND p_sp_fixed_date_tbl(i) = l_temp_gmiss_date THEN
6521: l_in_sp_fixed_date_tbl(i) := FND_API.G_MISS_DATE;
6522: END IF;
6523: END LOOP;
6524: END IF;
6525: END IF;
6550: ,x_return_status => l_return_status
6551: ,x_msg_data => l_msg_data
6552: ,x_msg_count => l_msg_count);
6553:
6554: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6555: IF l_debug_mode = 'Y' THEN
6556: pa_debug.g_err_stage:='Called API pa_planning_transaction_pub.check_and_create_task_rec_info api returned error';
6557: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6558: END IF;
6813:
6814:
6815: -- Assiging all the passed tbls to record type . This is done because
6816: -- 1. TA validation API expects a pl/sql table of records
6817: -- 2. BULK update will possible since the values that are not passed will be defaulted to FND_API.G_MISS_XXX
6818:
6819:
6820: IF l_debug_mode = 'Y' THEN
6821: pa_debug.g_err_stage:='About to loop thru for assigning to rec types';
7158: --dbms_output.put_line(' l_resource_rec_tbl(i).cost_rate_override is '|| l_resource_rec_tbl(1).cost_rate_override);
7159:
7160: --hr_utility.trace('PA_FP_PLAN_TXN_PUB.update_planning_transactions: after calling validate_update_assignment');
7161:
7162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7163: IF l_debug_mode = 'Y' THEN
7164: pa_debug.g_err_stage:='Called API PA_TASK_ASSIGNMENT_UTILS.Validate_Update_Assignment returned error';
7165: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
7166: END IF;
7183:
7184:
7185: /*------------------------------------------------------------------------
7186: -- Repopulating all the resource data tables from the table l_resource_rec_tbl
7187: -- Now all the parameters not passed will be initialized to FND_API.G_MISS_XXX
7188: ------------------------------------------------------------------------ */
7189: FOR i IN l_resource_rec_tbl.FIRST .. l_resource_rec_tbl.LAST LOOP
7190:
7191: IF l_resource_rec_tbl.EXISTS(i) THEN
7336: IF l_debug_mode = 'Y' THEN
7337: pa_debug.g_err_stage:='Spread Curve Id is of FIXED_DATE';
7338: print_msg(pa_debug.g_err_stage,l_module_name);
7339: END IF;
7340: IF l_sp_fixed_date_tbl(i) = FND_API.G_MISS_DATE THEN
7341: IF l_debug_mode = 'Y' THEN
7342: pa_debug.g_err_stage:='Error - cannot nullify sp_fixed_date for Fixed Date Spread curve';
7343: print_msg(pa_debug.g_err_stage,l_module_name);
7344: END IF;
7364: , x_msg_count => x_msg_count
7365: , x_msg_data => x_msg_data
7366: , x_return_status => x_return_status);
7367: --dbms_output.put_line('4');
7368: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7369: IF l_debug_mode = 'Y' THEN
7370: pa_debug.g_err_stage:='Cpa_budget_utils.Get_Project_Currency_Info returned error';
7371: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
7372: END IF;
7545: ,x_return_status => x_return_status
7546: ,x_msg_data => x_msg_data
7547: ,x_msg_count => x_msg_count );
7548:
7549: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7550: IF l_debug_mode = 'Y' THEN
7551: pa_debug.g_err_stage:='Derive_Parameters_For_Calc_Api returned error';
7552: print_msg(pa_debug.g_err_stage,l_module_name);
7553: END IF;
7993: --dbms_output.put_line( pa_debug.g_err_stage);
7994: pa_debug.g_err_stage:='l_sp_fixed_date_old_tbl('||i||') is '||l_sp_fixed_date_old_tbl(i);
7995: print_msg(pa_debug.g_err_stage,l_module_name);
7996: --dbms_output.put_line( pa_debug.g_err_stage);
7997: if l_sp_fixed_date_new_tbl(i) = fnd_api.g_miss_date then
7998: pa_debug.g_err_stage:='l_sp_fixed_date_new_tbl('||i||') is g miss date';
7999: else
8000: pa_debug.g_err_stage:='l_sp_fixed_date_new_tbl('||i||') is '||l_sp_fixed_date_new_tbl(i);
8001: end if;
8003: --dbms_output.put_line( pa_debug.g_err_stage);
8004: pa_debug.g_err_stage:='l_plan_start_date_old_tbl('||i||') is '||l_plan_start_date_old_tbl(i);
8005: print_msg(pa_debug.g_err_stage,l_module_name);
8006: --dbms_output.put_line( pa_debug.g_err_stage);
8007: if l_plan_start_date_new_tbl(i) = fnd_api.g_miss_date then
8008: pa_debug.g_err_stage:='l_plan_start_date_new_tbl('||i||') is g miss date';
8009: else
8010: pa_debug.g_err_stage:='l_plan_start_date_new_tbl('||i||') is '||l_plan_start_date_new_tbl(i);
8011: end if;
8013: --dbms_output.put_line( pa_debug.g_err_stage);
8014: pa_debug.g_err_stage:='l_plan_end_date_old_tbl('||i||') is '||l_plan_end_date_old_tbl(i);
8015: print_msg(pa_debug.g_err_stage,l_module_name);
8016: --dbms_output.put_line( pa_debug.g_err_stage);
8017: if l_plan_end_date_new_tbl(i) = fnd_api.g_miss_date then
8018: pa_debug.g_err_stage:='l_plan_end_date_new_tbl('||i||') is g miss date';
8019: else
8020: pa_debug.g_err_stage:='l_plan_end_date_new_tbl('||i||') is '||l_plan_end_date_new_tbl(i);
8021: end if;
8089: ,x_return_status => x_return_status
8090: ,x_msg_count => x_msg_count
8091: ,x_msg_data => x_msg_data);
8092:
8093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8094:
8095: IF l_debug_mode = 'Y' THEN
8096: pa_debug.g_err_stage:='Called API PA_FP_CALC_PLAN_PKG.calculate returned error';
8097: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
8129: x_return_status => x_return_status,
8130: x_msg_count => x_msg_count,
8131: x_msg_data => x_msg_data);
8132:
8133: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8134:
8135: IF l_debug_mode = 'Y' THEN
8136: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
8137: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
8185: x_msg_count => x_msg_count,
8186: x_msg_data => x_msg_data
8187: );
8188:
8189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8190:
8191: IF l_debug_mode = 'Y' THEN
8192: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
8193: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
8215: pa_task_assignment_utils.g_require_progress_rollup := 'N';
8216: END IF;
8217:
8218:
8219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8220: IF l_debug_mode = 'Y' THEN
8221: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
8222: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.update_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
8223: END IF;
8245: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
8246: END IF;
8247:
8248: PA_INTERFACE_UTILS_PUB.get_messages
8249: ( p_encoded => FND_API.G_TRUE
8250: ,p_msg_index => 1
8251: ,p_msg_count => l_msg_count
8252: ,p_msg_data => l_msg_data
8253: ,p_data => l_data
8263: x_msg_count := l_msg_count;
8264:
8265: END IF;
8266: ROLLBACK TO Update_Planning_Transactions;
8267: x_return_status := FND_API.G_RET_STS_ERROR;
8268: IF l_debug_mode = 'Y' THEN
8269: pa_debug.g_err_stage:='In invalid args exception 3';
8270: pa_debug.write(l_module_name,pa_debug.g_err_stage, l_debug_level3);
8271: pa_debug.reset_curr_function;
8276: END IF;
8277:
8278:
8279: WHEN OTHERS THEN
8280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8281: x_msg_count := 1;
8282: x_msg_data := SQLERRM;
8283: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
8284: ,p_procedure_name => 'Update_Planning_Transactions');
8414: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
8415: END IF;
8416: --dbms_output.put_line('in copy plan txn1');
8417: x_msg_count := 0;
8418: x_return_status := FND_API.G_RET_STS_SUCCESS;
8419:
8420: SAVEPOINT copy_plan_txn;
8421:
8422: --Added this if for the bug 4200168
8579: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
8580:
8581: END IF;
8582:
8583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8584:
8585: IF l_debug_mode = 'Y' THEN
8586:
8587: pa_debug.g_err_stage:='validate_copy_assignment returned error';
8653: ,x_msg_data => x_msg_data);
8654:
8655:
8656:
8657: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8658:
8659: IF l_debug_mode = 'Y' THEN
8660:
8661: pa_debug.g_err_stage:='create_res_task_maps returned error';
8684: ,x_return_status => x_return_status
8685: ,x_msg_count => x_msg_count
8686: ,x_msg_data => x_msg_data);
8687:
8688: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8689:
8690: IF l_debug_mode = 'Y' THEN
8691:
8692: pa_debug.g_err_stage:='Copy_Resource_Assignments returned error';
8708: x_return_status => x_return_status,
8709: x_msg_count => x_msg_count,
8710: x_msg_data => x_msg_data);
8711:
8712: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8713:
8714: IF l_debug_mode = 'Y' THEN
8715: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
8716: print_msg(pa_debug.g_err_stage,l_module_name);
8761: x_msg_count => x_msg_count,
8762: x_msg_data => x_msg_data
8763: );
8764:
8765: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8766:
8767: IF l_debug_mode = 'Y' THEN
8768: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
8769: print_msg(pa_debug.g_err_stage,l_module_name);
8852: , x_msg_count => x_msg_count
8853: , x_msg_data => x_msg_data
8854: , x_return_status => x_return_status);
8855:
8856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8857: IF l_debug_mode = 'Y' THEN
8858: pa_debug.g_err_stage:='Cpa_budget_utils.Get_Project_Currency_Info returned error';
8859: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
8860: END IF;
8944: ,x_return_status => x_return_status
8945: ,x_msg_count => x_msg_count
8946: ,x_msg_data => x_msg_data);
8947:
8948: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8949:
8950: IF l_debug_mode = 'Y' THEN
8951:
8952: pa_debug.g_err_stage:='PA_FP_CALC_PLAN_PKG.calculate returned error';
8975: ,x_msg_data => x_msg_data);
8976:
8977:
8978:
8979: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8980:
8981: IF l_debug_mode = 'Y' THEN
8982:
8983: pa_debug.g_err_stage:='Copy_Budget_Lines returned error';
9101: ,x_return_status => x_return_status
9102: ,x_msg_count => x_msg_count
9103: ,x_msg_data => x_msg_data );
9104:
9105: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9106:
9107: IF l_debug_mode = 'Y' THEN
9108:
9109: pa_debug.g_err_stage:='convert_txn_currency returned error';
9128: ,x_return_status => x_return_status
9129: ,x_msg_data => x_msg_data
9130: ,x_msg_count => x_msg_count);
9131:
9132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9133:
9134: IF l_debug_mode = 'Y' THEN
9135: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
9136: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
9158: pa_task_assignment_utils.g_require_progress_rollup := 'N';
9159:
9160: END IF;
9161:
9162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9163: IF l_debug_mode = 'Y' THEN
9164: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
9165: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.copy_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
9166: END IF;
9213: x_msg_count => x_msg_count,
9214: x_msg_data => x_msg_data
9215: );
9216:
9217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9218:
9219: IF l_debug_mode = 'Y' THEN
9220: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
9221: print_msg(pa_debug.g_err_stage,l_module_name);
9234: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9235: l_msg_count := FND_MSG_PUB.count_msg;
9236: IF l_msg_count = 1 THEN
9237: PA_INTERFACE_UTILS_PUB.get_messages
9238: (p_encoded => FND_API.G_TRUE
9239: ,p_msg_index => 1
9240: ,p_msg_count => l_msg_count
9241: ,p_msg_data => l_msg_data
9242: ,p_data => l_data
9247: ELSE
9248: x_msg_count := l_msg_count;
9249: END IF;
9250:
9251: x_return_status := FND_API.G_RET_STS_ERROR;
9252: ROLLBACK TO copy_plan_txn;
9253:
9254: IF l_debug_mode = 'Y' THEN
9255: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
9259: END IF;
9260: RETURN;
9261: WHEN Others THEN
9262: ROLLBACK TO copy_plan_txn;
9263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9264: x_msg_count := 1;
9265: x_msg_data := SQLERRM;
9266:
9267: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
9421: BEGIN
9422:
9423: delete pa_resource_asgn_curr_tmp;
9424: x_msg_count := 0;
9425: x_return_status := FND_API.G_RET_STS_SUCCESS;
9426:
9427: pa_task_assignment_utils.g_require_progress_rollup := 'N';
9428:
9429: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
9624: pa_debug.g_err_stage:= pa_debug.g_err_stage||'RetSts['||x_return_status||']';
9625: print_msg(pa_debug.g_err_stage,l_module_name);
9626: End If;
9627:
9628: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9629: IF l_debug_mode = 'Y' THEN
9630: pa_debug.g_err_stage:='The calling context is task assignment. Calling the validation API';
9631: print_msg(pa_debug.g_err_stage,l_module_name);
9632: END IF;
9645:
9646: If p_task_or_res = 'TASKS' --- bug 6076066: added the checking of p_task_res to the existing IF loop
9647: and p_element_version_id_tbl.count > 0
9648: and NVL(p_element_version_id_tbl(1),0) <> 0
9649: and p_element_version_id_tbl(1) <> fnd_api.g_miss_num then
9650:
9651: /* Bug fix: LOOP is required to get the budget version id. when multiple tasks are deleted
9652: * some of the task may not have assignments, but some may have assignments
9653: * without loop, the process skips all the records
9723:
9724: IF l_budget_version_id is NULL -- Bug 5408333
9725: and p_resource_assignment_tbl.COUNT > 0
9726: and NVL(p_resource_assignment_tbl(1),0) <> 0
9727: and p_resource_assignment_tbl(1) <> fnd_api.g_miss_num Then
9728:
9729: BEGIN
9730:
9731: IF l_debug_mode = 'Y' THEN
10509: x_return_status => x_return_status,
10510: x_msg_count => x_msg_count,
10511: x_msg_data => x_msg_data);
10512:
10513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10514:
10515: IF l_debug_mode = 'Y' THEN
10516: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
10517: print_msg(pa_debug.g_err_stage,l_module_name);
10536: x_msg_count => x_msg_count,
10537: x_msg_data => x_msg_data
10538: );
10539:
10540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10541:
10542: IF l_debug_mode = 'Y' THEN
10543: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
10544: print_msg(pa_debug.g_err_stage,l_module_name);
10574: ,x_return_status => x_return_status
10575: ,x_msg_count => l_msg_count
10576: ,x_msg_data => l_msg_data);
10577:
10578: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10579: IF l_debug_mode = 'Y' THEN
10580: pa_debug.g_err_stage:='The API PA_FP_ROLLUP_PKG.ROLLUP_BUDGET_VERSION returned error';
10581: print_msg(pa_debug.g_err_stage,l_module_name);
10582: END IF;
10698: pa_debug.g_err_stage:='Error in preparing pl/sql tables for rbs element id and task id ';
10699: print_msg(pa_debug.g_err_stage,l_module_name);
10700: END IF;
10701:
10702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10703:
10704: END IF;
10705:
10706: IF l_debug_mode = 'Y' THEN
10742: ,x_return_status => x_return_status
10743: ,x_msg_data => x_msg_data
10744: ,x_msg_count => x_msg_count );
10745:
10746: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10747: IF l_debug_mode = 'Y' THEN
10748: pa_debug.g_err_stage:='The API pa_planning_transaction_utils.call_update_rep_lines_api returned error';
10749: print_msg(pa_debug.g_err_stage,l_module_name);
10750: END IF;
10784:
10785: pa_task_assignment_utils.g_require_progress_rollup := 'N';
10786:
10787: END IF;
10788: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10789: IF l_debug_mode = 'Y' THEN
10790: pa_debug.g_err_stage:='After Called process_wbs_updates_wrp:retSts['||x_return_status||']';
10791: print_msg(pa_debug.g_err_stage,l_module_name);
10792: END IF;
10806: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10807: l_msg_count := FND_MSG_PUB.count_msg;
10808: IF l_msg_count = 1 THEN
10809: PA_INTERFACE_UTILS_PUB.get_messages
10810: (p_encoded => FND_API.G_TRUE
10811: ,p_msg_index => 1
10812: ,p_msg_count => l_msg_count
10813: ,p_msg_data => l_msg_data
10814: ,p_data => l_data
10819: ELSE
10820: x_msg_count := l_msg_count;
10821: END IF;
10822:
10823: x_return_status := FND_API.G_RET_STS_ERROR;
10824:
10825: IF l_debug_mode = 'Y' THEN
10826: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
10827: print_msg(pa_debug.g_err_stage,l_module_name);
10829: pa_debug.reset_curr_function;
10830: END IF;
10831: RETURN;
10832: WHEN OTHERS THEN
10833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10834: x_msg_count := 1;
10835: x_msg_data := SQLERRM;
10836:
10837: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
10891:
10892: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
10893: l_debug_mode := NVL(l_debug_mode, 'N');
10894: x_msg_count := 0;
10895: x_return_status := FND_API.G_RET_STS_SUCCESS;
10896: IF l_debug_mode = 'Y' THEN
10897: PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type',
10898: p_debug_mode => l_debug_mode );
10899: END IF;
11032: ,x_return_status => l_return_status
11033: ,x_msg_count => l_msg_count
11034: ,x_msg_data => l_msg_data);
11035:
11036: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11037: IF l_debug_mode = 'Y' THEN
11038: pa_debug.g_err_stage:='Called API pa_proj_fp_options_pub.Create_FP_Option returned error';
11039: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
11040: END IF;
11059: ,x_return_status => l_return_status
11060: ,x_msg_count => l_msg_count
11061: ,x_msg_data => l_msg_data );
11062:
11063: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11064: IF l_debug_mode = 'Y' THEN
11065: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES returned error';
11066: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
11067: END IF;
11078: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
11079: l_msg_count := FND_MSG_PUB.count_msg;
11080: IF l_msg_count = 1 THEN
11081: PA_INTERFACE_UTILS_PUB.get_messages
11082: (p_encoded => FND_API.G_TRUE
11083: ,p_msg_index => 1
11084: ,p_msg_count => l_msg_count
11085: ,p_msg_data => l_msg_data
11086: ,p_data => l_data
11089: x_msg_count := l_msg_count;
11090: ELSE
11091: x_msg_count := l_msg_count;
11092: END IF;
11093: x_return_status := FND_API.G_RET_STS_ERROR;
11094: IF l_debug_mode = 'Y' THEN
11095: pa_debug.reset_curr_function;
11096: END IF;
11097: WHEN OTHERS THEN
11094: IF l_debug_mode = 'Y' THEN
11095: pa_debug.reset_curr_function;
11096: END IF;
11097: WHEN OTHERS THEN
11098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11099: x_msg_count := 1;
11100: x_msg_data := SQLERRM;
11101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
11102: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');
11196:
11197: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
11198: l_debug_mode := NVL(l_debug_mode, 'N');
11199: x_msg_count := 0;
11200: x_return_status := FND_API.G_RET_STS_SUCCESS;
11201: IF l_debug_mode = 'Y' THEN
11202: PA_DEBUG.Set_Curr_Function( p_function => 'fp_planning_txn_pub.chk_and_create_task',
11203: p_debug_mode => l_debug_mode );
11204: END IF;
11295:
11296: IF p_planning_end_date_tbl.EXISTS(i) THEN
11297: x_planning_end_date_tbl(l_out_tbl_index) := p_planning_end_date_tbl(i);
11298: END IF;
11299: /* In Update Flow for Workplan Context FND_API.G_MISS_XXXX will be considered
11300: as a valid value for effort/Quantity -- Bug 3640498*/
11301: IF (p_raw_cost_tbl.EXISTS(i)) THEN --AND
11302: -- NVL(p_raw_cost_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
11303: -- p_raw_cost_tbl(i) <> 0) THEN
11298: END IF;
11299: /* In Update Flow for Workplan Context FND_API.G_MISS_XXXX will be considered
11300: as a valid value for effort/Quantity -- Bug 3640498*/
11301: IF (p_raw_cost_tbl.EXISTS(i)) THEN --AND
11302: -- NVL(p_raw_cost_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
11303: -- p_raw_cost_tbl(i) <> 0) THEN
11304: x_raw_cost_tbl(l_out_tbl_index) := p_raw_cost_tbl(i);
11305: END IF;
11306:
11304: x_raw_cost_tbl(l_out_tbl_index) := p_raw_cost_tbl(i);
11305: END IF;
11306:
11307: IF (p_burdened_cost_tbl.EXISTS(i)) THEN -- AND
11308: -- NVL(p_burdened_cost_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
11309: -- p_burdened_cost_tbl(i) <> 0) THEN
11310: x_burdened_cost_tbl(l_out_tbl_index) := p_burdened_cost_tbl(i);
11311: END IF;
11312:
11312:
11313: x_element_version_id_tbl(l_out_tbl_index) := p_element_version_id_tbl(i);
11314: IF l_res_class_code_tbl(j) = PA_FP_CONSTANTS_PKG.G_RESOURCE_CLASS_CODE_PPL THEN
11315: IF (p_planned_people_effort_tbl.EXISTS(i)) THEN --AND
11316: -- (nvl(p_planned_people_effort_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
11317: -- (p_planned_people_effort_tbl(i) > 0)) THEN
11318: x_planned_effort_tbl(l_out_tbl_index) := p_planned_people_effort_tbl(i);
11319: END IF;
11320: END IF;
11328: IF l_rec_exsists = 'N' THEN
11329:
11330: --Add the record only if either people or equipment effort exists
11331: IF ((p_planned_people_effort_tbl.EXISTS(i)) AND
11332: (nvl(p_planned_people_effort_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
11333: /*Bug fix:5726773 (p_planned_people_effort_tbl(i) > 0))*/
11334: (p_planned_people_effort_tbl(i) is NOT NULL))
11335: OR
11336: (p_raw_cost_tbl.EXISTS(i) AND
11333: /*Bug fix:5726773 (p_planned_people_effort_tbl(i) > 0))*/
11334: (p_planned_people_effort_tbl(i) is NOT NULL))
11335: OR
11336: (p_raw_cost_tbl.EXISTS(i) AND
11337: NVL(p_raw_cost_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
11338: /* bug fix:Bug fix:5726773 p_raw_cost_tbl(i) <> 0) */
11339: p_raw_cost_tbl(i) is NOT NULL )
11340: OR
11341: (p_burdened_cost_tbl.EXISTS(i) AND
11338: /* bug fix:Bug fix:5726773 p_raw_cost_tbl(i) <> 0) */
11339: p_raw_cost_tbl(i) is NOT NULL )
11340: OR
11341: (p_burdened_cost_tbl.EXISTS(i) AND
11342: NVL(p_burdened_cost_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
11343: /* bug fix:Bug fix:5726773 P_burdened_cost_tbl(i) <> 0) THEN */
11344: P_burdened_cost_tbl(i) is NOT NULL) THEN
11345:
11346: l_element_version_id_tbl(l_add_tbl_index) := p_element_version_id_tbl(i);
11352: l_planning_end_date_tbl(l_add_tbl_index) := p_planning_end_date_tbl(i);
11353: END IF;
11354:
11355: IF ((p_planned_people_effort_tbl.EXISTS(i)) AND
11356: (nvl(p_planned_people_effort_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
11357: /* bug fix:5726773 (p_planned_people_effort_tbl(i) > 0)) THEN */
11358: (p_planned_people_effort_tbl(i) is NOT NULL )) THEN
11359: l_planned_people_effort_tbl(l_add_tbl_index) := p_planned_people_effort_tbl(i);
11360: END IF;
11359: l_planned_people_effort_tbl(l_add_tbl_index) := p_planned_people_effort_tbl(i);
11360: END IF;
11361:
11362: IF (p_raw_cost_tbl.EXISTS(i) AND
11363: NVL(p_raw_cost_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
11364: /* bug fix:Bug fix:5726773 p_raw_cost_tbl(i) <> 0) THEN */
11365: p_raw_cost_tbl(i) is NOT NULL ) THEN
11366: l_raw_cost_tbl(l_add_tbl_index) := p_raw_cost_tbl(i);
11367: END IF;
11366: l_raw_cost_tbl(l_add_tbl_index) := p_raw_cost_tbl(i);
11367: END IF;
11368:
11369: IF (p_burdened_cost_tbl.EXISTS(i) AND
11370: NVL(p_burdened_cost_tbl(i),FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
11371: /* bug fix:Bug fix:572677312/29/2006 P_burdened_cost_tbl(i) <> 0) THEN */
11372: P_burdened_cost_tbl(i) is NOT NULL) THEN
11373: l_burdened_cost_tbl(l_add_tbl_index) := p_burdened_cost_tbl(i);
11374: END IF;
11489: ,x_msg_count => l_msg_count
11490: ,x_msg_data => l_msg_data
11491: );
11492:
11493: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11494: IF l_debug_mode = 'Y' THEN
11495: pa_debug.g_err_stage:='Called API PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions ,api returned error';
11496: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
11497: END IF;
11507: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
11508: l_msg_count := FND_MSG_PUB.count_msg;
11509: IF l_msg_count = 1 THEN
11510: PA_INTERFACE_UTILS_PUB.get_messages
11511: (p_encoded => FND_API.G_TRUE
11512: ,p_msg_index => 1
11513: ,p_msg_count => l_msg_count
11514: ,p_msg_data => l_msg_data
11515: ,p_data => l_data
11518: x_msg_count := l_msg_count;
11519: ELSE
11520: x_msg_count := l_msg_count;
11521: END IF;
11522: x_return_status := FND_API.G_RET_STS_ERROR;
11523: IF l_debug_mode = 'Y' THEN
11524: pa_debug.reset_curr_function;
11525: END IF;
11526: WHEN OTHERS THEN
11523: IF l_debug_mode = 'Y' THEN
11524: pa_debug.reset_curr_function;
11525: END IF;
11526: WHEN OTHERS THEN
11527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11528: x_msg_count := 1;
11529: x_msg_data := SQLERRM;
11530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
11531: ,p_procedure_name => 'check_and_create_task_rec_info');
11631: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
11632: BEGIN
11633:
11634: x_msg_count := 0;
11635: x_return_status := FND_API.G_RET_STS_SUCCESS;
11636:
11637: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
11638: l_debug_mode := NVL(l_debug_mode, 'Y');
11639:
11715: x_return_status => x_return_status,
11716: x_msg_count => x_msg_count,
11717: x_msg_data => x_msg_data);
11718:
11719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11720:
11721: IF l_debug_mode = 'Y' THEN
11722: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11723: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11750: x_msg_count => x_msg_count,
11751: x_msg_data => x_msg_data
11752: );
11753:
11754: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11755:
11756: IF l_debug_mode = 'Y' THEN
11757: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
11758: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11801: x_return_status => x_return_status,
11802: x_msg_count => x_msg_count,
11803: x_msg_data => x_msg_data);
11804:
11805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11806:
11807: IF l_debug_mode = 'Y' THEN
11808: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11809: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11825: x_msg_count => x_msg_count,
11826: x_msg_data => x_msg_data
11827: );
11828:
11829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11830:
11831: IF l_debug_mode = 'Y' THEN
11832: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
11833: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11881: ,x_return_status => x_return_status
11882: ,x_msg_count => x_msg_count
11883: ,x_msg_data => x_msg_data );
11884:
11885: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11886: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11887: END IF;
11888:
11889: END IF; -- end bug 4724017
11936: ,x_return_status => l_return_status
11937: ,x_msg_count => l_msg_count
11938: ,x_msg_data => l_msg_data);
11939:
11940: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11941: IF l_debug_mode = 'Y' THEN
11942: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
11943: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);
11944: END IF;
11968: x_return_status => x_return_status,
11969: x_msg_count => x_msg_count,
11970: x_msg_data => x_msg_data);
11971:
11972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11973:
11974: IF l_debug_mode = 'Y' THEN
11975: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11976: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11992: x_msg_count => x_msg_count,
11993: x_msg_data => x_msg_data
11994: );
11995:
11996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11997:
11998: IF l_debug_mode = 'Y' THEN
11999: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
12000: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
12013: ,x_return_status => l_return_status
12014: ,x_msg_count => l_msg_count
12015: ,x_msg_data => l_msg_data);
12016:
12017: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12018: IF l_debug_mode = 'Y' THEN
12019: pa_debug.g_err_stage:='Called API PA_FP_ROLLUP_PKG.rollup_budget_version returned error';
12020: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);
12021: END IF;
12038: ,x_return_status => l_return_status
12039: ,x_msg_count => l_msg_count
12040: ,x_msg_data => l_msg_data);
12041:
12042: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12043: IF l_debug_mode = 'Y' THEN
12044: pa_debug.g_err_stage:='Called API Refresh_rbs_for_versions returned error';
12045: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);
12046: END IF;
12070: p_fp_version_ids => l_budget_version_id_tbl,
12071: x_return_status => l_return_status,
12072: x_msg_code => l_error_msg_code);
12073:
12074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12075: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
12076: p_msg_name => l_error_msg_code);
12077: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12078: END IF;
12092: p_fp_version_ids => l_budget_version_id_tbl,
12093: x_return_status => l_return_status,
12094: x_msg_code => l_error_msg_code);
12095:
12096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12097: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
12098: p_msg_name => l_error_msg_code);
12099: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12100: END IF;
12118: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
12119: l_msg_count := FND_MSG_PUB.count_msg;
12120: IF l_msg_count = 1 THEN
12121: PA_INTERFACE_UTILS_PUB.get_messages
12122: (p_encoded => FND_API.G_TRUE
12123: ,p_msg_index => 1
12124: ,p_msg_count => l_msg_count
12125: ,p_msg_data => l_msg_data
12126: ,p_data => l_data
12131: ELSE
12132: x_msg_count := l_msg_count;
12133: END IF;
12134:
12135: x_return_status := FND_API.G_RET_STS_ERROR;
12136:
12137: IF l_debug_mode = 'Y' THEN
12138: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
12139: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,5);
12142: END IF;
12143:
12144: RETURN;
12145: WHEN Others THEN
12146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12147: x_msg_count := 1;
12148: x_msg_data := SQLERRM;
12149:
12150: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
12272: pa_debug.set_curr_function( p_function => 'Create_Default_Task_Plan_Txns',
12273: p_debug_mode => l_debug_mode );
12274: END IF;
12275: x_msg_count := 0;
12276: x_return_status := FND_API.G_RET_STS_SUCCESS;
12277:
12278:
12279: -- Check for business rules violations
12280:
12351: x_msg_count => l_msg_count,
12352: x_msg_data => l_msg_data);
12353: --hr_utility.trace('G_BUDGET_ENTRY_LEVEL_LOWEST -> rlmids'|| l_people_res_class_rlm_id || 'x' || l_equip_res_class_rlm_id || 'x' || l_fin_res_class_rlm_id || 'x' || l_mat_res_class_rlm_id);
12354:
12355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12356: IF l_debug_mode = 'Y' THEN
12357: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12359: END IF;
12421: ,x_return_status => l_return_status
12422: ,x_msg_count => l_msg_count
12423: ,x_msg_data => l_msg_data );
12424:
12425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12426: IF l_debug_mode = 'Y' THEN
12427: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12428: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12429: END IF;
12460: ,x_msg_count => l_msg_count
12461: ,x_msg_data => l_msg_data );
12462: END IF;
12463:
12464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12465: IF l_debug_mode = 'Y' THEN
12466: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12468: END IF;
12506: ,x_return_status => l_return_status
12507: ,x_msg_count => l_msg_count
12508: ,x_msg_data => l_msg_data );
12509:
12510: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12511: IF l_debug_mode = 'Y' THEN
12512: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12513: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12514: END IF;
12533: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
12534: l_msg_count := FND_MSG_PUB.count_msg;
12535: IF l_msg_count = 1 THEN
12536: PA_INTERFACE_UTILS_PUB.get_messages
12537: (p_encoded => FND_API.G_TRUE
12538: ,p_msg_index => 1
12539: ,p_msg_count => l_msg_count
12540: ,p_msg_data => l_msg_data
12541: ,p_data => l_data
12544: x_msg_count := l_msg_count;
12545: ELSE
12546: x_msg_count := l_msg_count;
12547: END IF;
12548: x_return_status := FND_API.G_RET_STS_ERROR;
12549: -- pa_debug.g_err_stage:='Invalid Arguments Passed';
12550: -- pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
12551: IF l_debug_mode = 'Y' THEN
12552: pa_debug.reset_curr_function;
12553: END IF;
12554: RETURN;
12555:
12556: WHEN Others THEN
12557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12558: x_msg_count := 1;
12559: x_msg_data := SQLERRM;
12560: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
12561: ,p_procedure_name => 'CREATE_DEFAULT_TASK_PLAN_TXNS');
12764:
12765: BEGIN
12766:
12767: x_msg_count := 0;
12768: x_return_status := FND_API.G_RET_STS_SUCCESS;
12769:
12770: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
12771: l_debug_mode := NVL(l_debug_mode, 'Y');
12772:
12857: ,x_return_status => x_return_status
12858: ,x_msg_data => x_msg_data
12859: ,x_msg_count => x_msg_count);
12860:
12861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12862:
12863: IF l_debug_mode = 'Y' THEN
12864: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
12865: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
12896: ,x_return_status => x_return_status
12897: ,x_msg_count => x_msg_count
12898: ,x_msg_data => x_msg_data);
12899:
12900: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12901: IF l_debug_mode = 'Y' THEN
12902: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12903: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
12904: END IF;
13028: ,x_return_status => x_return_status
13029: ,x_msg_count => x_msg_count
13030: ,x_msg_data => x_msg_data);
13031:
13032: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13033: IF l_debug_mode = 'Y' THEN
13034: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
13035: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13036: END IF;
13052: ,x_return_status => x_return_status
13053: ,x_msg_count => x_msg_count
13054: ,x_msg_data => x_msg_data );
13055:
13056: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13057: IF l_debug_mode = 'Y' THEN
13058: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies api returned error';
13059: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13060: END IF;
13107: ,x_return_status => x_return_status
13108: ,x_msg_count => x_msg_count
13109: ,x_msg_data => x_msg_data );
13110:
13111: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13112: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13113: END IF;
13114: END IF;
13115:
13174: ,x_return_status => x_return_status
13175: ,x_msg_count => x_msg_count
13176: ,x_msg_data => x_msg_data);
13177:
13178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13179: IF l_debug_mode = 'Y' THEN
13180: pa_debug.g_err_stage:='Called API PA_FP_CALC_PLAN_PKG.calculate api returned error';
13181: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13182: END IF;
13195: ,x_return_status => x_return_status
13196: ,x_msg_count => x_msg_count
13197: ,x_msg_data => x_msg_data);
13198:
13199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13200: IF l_debug_mode = 'Y' THEN
13201: pa_debug.g_err_stage:='Called API PA_FP_ROLLUP_PKG.rollup_budget_version api returned error';
13202: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13203: END IF;
13277: ,x_msg_count => x_msg_count
13278: ,x_msg_data => x_msg_data);
13279:
13280: -- Check return status
13281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13282: IF l_debug_mode = 'Y' THEN
13283: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';
13284: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13285: END IF;
13372: ,x_return_status => x_return_status
13373: ,x_msg_data => x_msg_data
13374: ,x_msg_count => x_msg_count);
13375:
13376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13377: IF l_debug_mode = 'Y' THEN
13378: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
13379: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
13380: END IF; RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13391: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (
13392: x_return_status => x_return_status,
13393: x_msg_code => l_error_msg_code);
13394:
13395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13396: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
13397: p_msg_name => l_error_msg_code);
13398: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13399: END IF;
13413: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
13414: l_msg_count := FND_MSG_PUB.count_msg;
13415: IF l_msg_count = 1 THEN
13416: PA_INTERFACE_UTILS_PUB.get_messages
13417: (p_encoded => FND_API.G_TRUE
13418: ,p_msg_index => 1
13419: ,p_msg_count => l_msg_count
13420: ,p_msg_data => l_msg_data
13421: ,p_data => l_data
13426: ELSE
13427: x_msg_count := l_msg_count;
13428: END IF;
13429:
13430: x_return_status := FND_API.G_RET_STS_ERROR;
13431:
13432: IF l_debug_mode = 'Y' THEN
13433: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
13434: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13437: END IF;
13438:
13439: RETURN;
13440: WHEN Others THEN
13441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13442: x_msg_count := 1;
13443: x_msg_data := SQLERRM;
13444:
13445: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
13536:
13537: BEGIN
13538:
13539: x_msg_count := 0;
13540: x_return_status := FND_API.G_RET_STS_SUCCESS;
13541:
13542: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
13543: l_debug_mode := NVL(l_debug_mode, 'Y');
13544:
13673: ,x_msg_count => x_msg_count
13674: ,x_msg_data => x_msg_data);
13675:
13676: -- Check return status
13677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13678: IF l_debug_mode = 'Y' THEN
13679: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';
13680: pa_debug.write('REFRESH_WP_SETTINGS: ' || g_module_name,pa_debug.g_err_stage,5);
13681: END IF;
13736: p_fp_version_ids => l_budget_version_id_tbl,
13737: x_return_status => x_return_status,
13738: x_msg_code => l_error_msg_code);
13739:
13740: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13741: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
13742: p_msg_name => l_error_msg_code);
13743: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13744: END IF;
13748: p_fp_version_ids => l_budget_version_id_tbl,
13749: x_return_status => x_return_status,
13750: x_msg_code => l_error_msg_code);
13751:
13752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13753: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
13754: p_msg_name => l_error_msg_code);
13755: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13756: END IF;
13767: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
13768: l_msg_count := FND_MSG_PUB.count_msg;
13769: IF l_msg_count = 1 THEN
13770: PA_INTERFACE_UTILS_PUB.get_messages
13771: (p_encoded => FND_API.G_TRUE
13772: ,p_msg_index => 1
13773: ,p_msg_count => l_msg_count
13774: ,p_msg_data => l_msg_data
13775: ,p_data => l_data
13780: ELSE
13781: x_msg_count := l_msg_count;
13782: END IF;
13783:
13784: x_return_status := FND_API.G_RET_STS_ERROR;
13785:
13786: IF l_debug_mode = 'Y' THEN
13787: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
13788: pa_debug.write('Refresh_rbs_for_versions: ' || g_module_name,pa_debug.g_err_stage,5);
13790: pa_debug.reset_curr_function();
13791: END IF;
13792: RETURN;
13793: WHEN Others THEN
13794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13795: x_msg_count := 1;
13796: x_msg_data := SQLERRM;
13797:
13798: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'