eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on FND_API

Line 346: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

342: , p_msg_count => l_msg_count
343: , p_msg_data => l_msg_data
344: , p_return_status => l_return_status
345: );
346: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
347: RAISE FND_API.G_EXC_ERROR ;
348: END IF ;
349: -- org_context changes end
350: log_pvt('MAIN','before create_project ');

Line 347: RAISE FND_API.G_EXC_ERROR ;

343: , p_msg_data => l_msg_data
344: , p_return_status => l_return_status
345: );
346: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
347: RAISE FND_API.G_EXC_ERROR ;
348: END IF ;
349: -- org_context changes end
350: log_pvt('MAIN','before create_project ');
351:

Line 353: P_COMMIT => fnd_api.g_false,

349: -- org_context changes end
350: log_pvt('MAIN','before create_project ');
351:
352: PA_PROJECT_PUB.CREATE_PROJECT( P_API_VERSION_NUMBER => 1.0,
353: P_COMMIT => fnd_api.g_false,
354: P_INIT_MSG_LIST => 'T',
355: P_MSG_COUNT => X_MSG_COUNT,
356: P_MSG_DATA => X_MSG_DATA,
357: P_RETURN_STATUS => l_RETURN_STATUS,

Line 454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

450: , p_msg_count => l_msg_count
451: , p_msg_data => l_msg_data
452: , p_return_status => l_return_status
453: );
454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
455: RAISE FND_API.G_EXC_ERROR ;
456: END IF ;
457: -- org_context changes end
458: PA_PROJECT_PUB.UPDATE_PROJECT( P_API_VERSION_NUMBER => 1.0,

Line 455: RAISE FND_API.G_EXC_ERROR ;

451: , p_msg_data => l_msg_data
452: , p_return_status => l_return_status
453: );
454: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
455: RAISE FND_API.G_EXC_ERROR ;
456: END IF ;
457: -- org_context changes end
458: PA_PROJECT_PUB.UPDATE_PROJECT( P_API_VERSION_NUMBER => 1.0,
459: P_COMMIT => fnd_api.g_false,

Line 459: P_COMMIT => fnd_api.g_false,

455: RAISE FND_API.G_EXC_ERROR ;
456: END IF ;
457: -- org_context changes end
458: PA_PROJECT_PUB.UPDATE_PROJECT( P_API_VERSION_NUMBER => 1.0,
459: P_COMMIT => fnd_api.g_false,
460: P_INIT_MSG_LIST => 'T',
461: P_MSG_COUNT => X_MSG_COUNT,
462: P_MSG_DATA => X_MSG_DATA,
463: P_RETURN_STATUS => l_RETURN_STATUS,

Line 497: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

493: if ( x_msg_count > 10 ) then
494: x_msg_count := 10;
495: end if;
496: for i in 1..x_msg_count loop
497: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
498: ,p_msg_index => x_msg_count
499: ,p_data => l_data
500: ,p_msg_index_out => l_msg_index_out
501: );

Line 788: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

784: --L_PROJECT_OUT_OBJ.msg_data := 'PA_PLAN_MC_NOT_ENABLED';
785: --RAISE;
786: for i in 1..x_msg_count loop
787:
788: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
789: ,p_msg_index => x_msg_count
790: ,p_data => l_data
791: ,p_msg_index_out => l_msg_index_out
792: );

Line 996: ,p_commit => fnd_api.g_false

992: PA_TASK_ASSIGNMENTS_PUB.Init_Task_Assignments;
993:
994: PA_TASK_ASSIGNMENTS_PUB.Load_Task_Assignments
995: ( p_api_version_number => 1.0
996: ,p_commit => fnd_api.g_false
997: ,p_init_msg_list => FND_API.G_TRUE
998: ,p_pm_project_reference => c_res_pm_project_reference
999: ,p_pa_project_id => c_res_pa_project_id
1000: ,p_pa_structure_version_id => c_res_pa_struct_version_id

Line 997: ,p_init_msg_list => FND_API.G_TRUE

993:
994: PA_TASK_ASSIGNMENTS_PUB.Load_Task_Assignments
995: ( p_api_version_number => 1.0
996: ,p_commit => fnd_api.g_false
997: ,p_init_msg_list => FND_API.G_TRUE
998: ,p_pm_project_reference => c_res_pm_project_reference
999: ,p_pa_project_id => c_res_pa_project_id
1000: ,p_pa_structure_version_id => c_res_pa_struct_version_id
1001: ,p_pm_task_reference => c_res_pm_task_reference

Line 1029: ,p_commit => fnd_api.g_false

1025: if ( l_RETURN_STATUS = 'S' ) then
1026:
1027: PA_TASK_ASSIGNMENTS_PUB.Execute_Create_Task_Asgmts
1028: ( p_api_version_number => 1.0
1029: ,p_commit => fnd_api.g_false
1030: ,p_init_msg_list => FND_API.G_TRUE
1031: ,p_pm_product_code => 'P6PROJECT'
1032: ,p_pm_project_reference => L_PROJECT_IN_REC.PM_PROJECT_REFERENCE
1033: ,p_pa_project_id => L_PROJECT_OUT_OBJ.PA_PROJECT_ID

Line 1030: ,p_init_msg_list => FND_API.G_TRUE

1026:
1027: PA_TASK_ASSIGNMENTS_PUB.Execute_Create_Task_Asgmts
1028: ( p_api_version_number => 1.0
1029: ,p_commit => fnd_api.g_false
1030: ,p_init_msg_list => FND_API.G_TRUE
1031: ,p_pm_product_code => 'P6PROJECT'
1032: ,p_pm_project_reference => L_PROJECT_IN_REC.PM_PROJECT_REFERENCE
1033: ,p_pa_project_id => L_PROJECT_OUT_OBJ.PA_PROJECT_ID
1034: ,p_pa_structure_version_id => L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID

Line 1061: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

1057: x_msg_count := 10;
1058: end if;
1059: for i in 1..x_msg_count loop
1060:
1061: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
1062: ,p_msg_index => x_msg_count
1063: ,p_data => l_data
1064: ,p_msg_index_out => l_msg_index_out
1065: );

Line 1096: ,p_init_msg_list => FND_API.G_TRUE

1092: o_cbs_element_id.extend(c_res_pm_project_reference.count);
1093:
1094: PA_TASK_ASSIGNMENTS_PUB.Fetch_Task_Assignments
1095: ( p_api_version_number => 1.0
1096: ,p_init_msg_list => FND_API.G_TRUE
1097: ,p_task_asgmt_index => o_task_asgmt_index
1098: ,p_pm_task_asgmt_reference => o_pm_task_asgmt_reference
1099: ,p_pa_task_assignment_id => o_pa_task_assignment_id
1100: ,p_pm_task_reference => o_pm_task_reference

Line 1212: ,p_commit => fnd_api.g_false

1208: PA_TASK_ASSIGNMENTS_PUB.Init_Task_Assignments;
1209:
1210: PA_TASK_ASSIGNMENTS_PUB.Load_Task_Assignments
1211: ( p_api_version_number => 1.0
1212: ,p_commit => fnd_api.g_false
1213: ,p_init_msg_list => FND_API.G_TRUE
1214: ,p_pm_project_reference => u_res_pm_project_reference
1215: ,p_pa_project_id => u_res_pa_project_id
1216: ,p_pa_structure_version_id => u_res_pa_struct_version_id

Line 1213: ,p_init_msg_list => FND_API.G_TRUE

1209:
1210: PA_TASK_ASSIGNMENTS_PUB.Load_Task_Assignments
1211: ( p_api_version_number => 1.0
1212: ,p_commit => fnd_api.g_false
1213: ,p_init_msg_list => FND_API.G_TRUE
1214: ,p_pm_project_reference => u_res_pm_project_reference
1215: ,p_pa_project_id => u_res_pa_project_id
1216: ,p_pa_structure_version_id => u_res_pa_struct_version_id
1217: ,p_pm_task_reference => u_res_pm_task_reference

Line 1246: ,p_commit => fnd_api.g_false

1242: if ( l_RETURN_STATUS = 'S' ) then
1243:
1244: PA_TASK_ASSIGNMENTS_PUB.Execute_Update_Task_Asgmts
1245: ( p_api_version_number => 1.0
1246: ,p_commit => fnd_api.g_false
1247: ,p_init_msg_list => FND_API.G_TRUE
1248: ,p_pm_product_code => 'P6PROJECT'
1249: ,p_pm_project_reference => L_PROJECT_IN_REC.PM_PROJECT_REFERENCE
1250: ,p_pa_project_id => L_PROJECT_IN_REC.PA_PROJECT_ID

Line 1247: ,p_init_msg_list => FND_API.G_TRUE

1243:
1244: PA_TASK_ASSIGNMENTS_PUB.Execute_Update_Task_Asgmts
1245: ( p_api_version_number => 1.0
1246: ,p_commit => fnd_api.g_false
1247: ,p_init_msg_list => FND_API.G_TRUE
1248: ,p_pm_product_code => 'P6PROJECT'
1249: ,p_pm_project_reference => L_PROJECT_IN_REC.PM_PROJECT_REFERENCE
1250: ,p_pa_project_id => L_PROJECT_IN_REC.PA_PROJECT_ID
1251: ,p_pa_structure_version_id => L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID

Line 1265: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

1261: x_msg_count := 10;
1262: end if;
1263: for i in 1..x_msg_count loop
1264:
1265: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
1266: ,p_msg_index => x_msg_count
1267: ,p_data => l_data
1268: ,p_msg_index_out => l_msg_index_out
1269: );

Line 1287: ,p_init_msg_list => FND_API.G_TRUE

1283:
1284:
1285: PA_TASK_ASSIGNMENTS_PUB.Fetch_Task_Assignments
1286: ( p_api_version_number => 1.0
1287: ,p_init_msg_list => FND_API.G_TRUE
1288: ,p_task_asgmt_index => ou_task_asgmt_index
1289: ,p_pm_task_asgmt_reference => ou_pm_task_asgmt_reference
1290: ,p_pa_task_assignment_id => ou_pa_task_assignment_id
1291: ,p_pm_task_reference => ou_pm_task_reference

Line 1525: --------START Convert fnd_api.g_miss* to pa g_miss -----------------------------

1521: T_TASK_IN_OBJ_TABLE := L_STRUCTURE_IN_OBJ.TASK_IN_OBJ_TABLE;
1522:
1523:
1524:
1525: --------START Convert fnd_api.g_miss* to pa g_miss -----------------------------
1526:
1527: if ( l_project_in_obj.PA_PROJECT_ID = FND_API.G_MISS_NUM ) then
1528:
1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

Line 1527: if ( l_project_in_obj.PA_PROJECT_ID = FND_API.G_MISS_NUM ) then

1523:
1524:
1525: --------START Convert fnd_api.g_miss* to pa g_miss -----------------------------
1526:
1527: if ( l_project_in_obj.PA_PROJECT_ID = FND_API.G_MISS_NUM ) then
1528:
1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1530:
1531: end if;

Line 1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then

1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1530:
1531: end if;
1532:
1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1534:
1535: l_project_in_obj.PA_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1536:
1537: end if;

Line 1540: if ( l_project_in_obj.PROJECT_NAME = FND_API.G_MISS_CHAR ) then

1536:
1537: end if;
1538:
1539:
1540: if ( l_project_in_obj.PROJECT_NAME = FND_API.G_MISS_CHAR ) then
1541:
1542: l_project_in_obj.PROJECT_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1543:
1544: end if;

Line 1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then

1542: l_project_in_obj.PROJECT_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1543:
1544: end if;
1545:
1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then
1547:
1548: l_project_in_obj.pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1549:
1550: end if;

Line 1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then

1548: l_project_in_obj.pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1549:
1550: end if;
1551:
1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then
1553:
1554: l_project_in_obj.DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1555:
1556: end if;

Line 1560: if ( l_project_in_obj.PROJECT_STATUS = FND_API.G_MISS_CHAR ) then

1556: end if;
1557:
1558: --log_pvt('LOAD_PROEJCT','init 01 ');
1559:
1560: if ( l_project_in_obj.PROJECT_STATUS = FND_API.G_MISS_CHAR ) then
1561:
1562: l_project_in_obj.PROJECT_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1563:
1564: end if;

Line 1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then

1562: l_project_in_obj.PROJECT_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1563:
1564: end if;
1565:
1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then
1567:
1568: l_project_in_obj.START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1569:
1570: end if;

Line 1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then

1568: l_project_in_obj.START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1569:
1570: end if;
1571:
1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then
1573:
1574: l_project_in_obj.COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1575:
1576: end if;

Line 1580: if ( l_project_in_obj.ACTUAL_START_DATE = FND_API.G_MISS_DATE ) then

1576: end if;
1577:
1578: --log_pvt('LOAD_PROEJCT','init 02 ');
1579:
1580: if ( l_project_in_obj.ACTUAL_START_DATE = FND_API.G_MISS_DATE ) then
1581:
1582: l_project_in_obj.ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1583:
1584: end if;

Line 1587: if ( l_project_in_obj.ACTUAL_FINISH_DATE = FND_API.G_MISS_DATE ) then

1583:
1584: end if;
1585:
1586:
1587: if ( l_project_in_obj.ACTUAL_FINISH_DATE = FND_API.G_MISS_DATE ) then
1588:
1589: l_project_in_obj.ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1590:
1591: end if;

Line 1594: if ( l_project_in_obj.EARLY_START_DATE = FND_API.G_MISS_DATE ) then

1590:
1591: end if;
1592:
1593:
1594: if ( l_project_in_obj.EARLY_START_DATE = FND_API.G_MISS_DATE ) then
1595:
1596: l_project_in_obj.EARLY_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1597:
1598: end if;

Line 1601: if ( l_project_in_obj.EARLY_FINISH_DATE = FND_API.G_MISS_DATE ) then

1597:
1598: end if;
1599:
1600:
1601: if ( l_project_in_obj.EARLY_FINISH_DATE = FND_API.G_MISS_DATE ) then
1602:
1603: l_project_in_obj.EARLY_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1604:
1605: end if;

Line 1609: if ( l_project_in_obj.MAX_WBS_LEVEL = FND_API.G_MISS_NUM ) then

1605: end if;
1606:
1607:
1608: --log_pvt('LOAD_PROEJCT','init 03 ');
1609: if ( l_project_in_obj.MAX_WBS_LEVEL = FND_API.G_MISS_NUM ) then
1610:
1611: l_project_in_obj.MAX_WBS_LEVEL := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1612:
1613: end if;

Line 1617: if ( l_project_in_obj.COST_CHG_QTY_INDICATOR = FND_API.G_MISS_CHAR ) then

1613: end if;
1614:
1615: --log_pvt('LOAD_PROEJCT','init 03a ');
1616:
1617: if ( l_project_in_obj.COST_CHG_QTY_INDICATOR = FND_API.G_MISS_CHAR ) then
1618:
1619: l_project_in_obj.COST_CHG_QTY_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1620:
1621: end if;

Line 1625: if ( l_project_in_obj.CREATED_FROM_PROJECT_ID = FND_API.G_MISS_NUM ) then

1621: end if;
1622:
1623: --log_pvt('LOAD_PROEJCT','init 03b ');
1624:
1625: if ( l_project_in_obj.CREATED_FROM_PROJECT_ID = FND_API.G_MISS_NUM ) then
1626:
1627: l_project_in_obj.CREATED_FROM_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1628:
1629: end if;

Line 1632: if ( l_project_in_obj.CREATED_FROM_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then

1628:
1629: end if;
1630:
1631: --log_pvt('LOAD_PROEJCT','init 03 c');
1632: if ( l_project_in_obj.CREATED_FROM_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1633:
1634: l_project_in_obj.CREATED_FROM_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1635:
1636: end if;

Line 1639: if ( l_project_in_obj.PROJECT_ORGANIZATION_ID = FND_API.G_MISS_NUM ) then

1635:
1636: end if;
1637:
1638: --log_pvt('LOAD_PROEJCT','init 03 d');
1639: if ( l_project_in_obj.PROJECT_ORGANIZATION_ID = FND_API.G_MISS_NUM ) then
1640:
1641: l_project_in_obj.PROJECT_ORGANIZATION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1642:
1643: end if;

Line 1646: if ( l_project_in_obj.ORG_ID = FND_API.G_MISS_NUM ) then

1642:
1643: end if;
1644:
1645: --log_pvt('LOAD_PROEJCT','init 03 e');
1646: if ( l_project_in_obj.ORG_ID = FND_API.G_MISS_NUM ) then
1647:
1648: l_project_in_obj.ORG_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1649:
1650: end if;

Line 1654: if ( l_project_in_obj.EPS_CLASS_CODE = FND_API.G_MISS_CHAR ) then

1650: end if;
1651:
1652: --log_pvt('LOAD_PROEJCT','init 03 fa');
1653:
1654: if ( l_project_in_obj.EPS_CLASS_CODE = FND_API.G_MISS_CHAR ) then
1655:
1656: l_project_in_obj.EPS_CLASS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1657:
1658: end if;

Line 1662: if ( l_project_in_obj.PROJECT_TYPE_CODE = FND_API.G_MISS_CHAR ) then

1658: end if;
1659:
1660:
1661: --log_pvt('LOAD_PROEJCT','init 03 ');
1662: if ( l_project_in_obj.PROJECT_TYPE_CODE = FND_API.G_MISS_CHAR ) then
1663:
1664: l_project_in_obj.PROJECT_TYPE_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1665:
1666: end if;

Line 1669: if ( l_project_in_obj.ORIGINAL_BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then

1665:
1666: end if;
1667:
1668: --log_pvt('LOAD_PROEJCT','init 04 ');
1669: if ( l_project_in_obj.ORIGINAL_BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1670:
1671: l_project_in_obj.ORIGINAL_BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1672:
1673: end if;

Line 1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then

1671: l_project_in_obj.ORIGINAL_BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1672:
1673: end if;
1674:
1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1676:
1677: l_project_in_obj.BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1678:
1679: end if;

Line 1682: if ( l_project_in_obj.PROJECT_CURRENCY_CODE = FND_API.G_MISS_CHAR ) then

1678:
1679: end if;
1680:
1681:
1682: if ( l_project_in_obj.PROJECT_CURRENCY_CODE = FND_API.G_MISS_CHAR ) then
1683:
1684: l_project_in_obj.PROJECT_CURRENCY_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1685:
1686: end if;

Line 1689: if ( l_project_in_obj.ACTIVITY_TRACKING_INDICATOR = FND_API.G_MISS_CHAR ) then

1685:
1686: end if;
1687:
1688:
1689: if ( l_project_in_obj.ACTIVITY_TRACKING_INDICATOR = FND_API.G_MISS_CHAR ) then
1690:
1691: l_project_in_obj.ACTIVITY_TRACKING_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1692:
1693: end if;

Line 1696: if ( l_project_in_obj.RES_ASS_TRACK_LEV_CODE = FND_API.G_MISS_CHAR ) then

1692:
1693: end if;
1694:
1695:
1696: if ( l_project_in_obj.RES_ASS_TRACK_LEV_CODE = FND_API.G_MISS_CHAR ) then
1697:
1698: l_project_in_obj.RES_ASS_TRACK_LEV_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1699:
1700: end if;

Line 1706: --------END Convert fnd_api.g_miss* to pa g_miss -----------------------------

1702: --log_pvt('LOAD_PROEJCT','init 05 ');
1703:
1704: --STRUCTURE_IN_OBJECT STRUCTURE_IN_OBJ
1705:
1706: --------END Convert fnd_api.g_miss* to pa g_miss -----------------------------
1707:
1708: log_pvt('LOAD_PROEJCT','Before created_from_poroject_number'|| l_PROJECT_IN_OBJ.created_from_project_number );
1709:
1710: l_return_status := 'S';

Line 1846: if ( L_STRUCTURE_IN_REC.DESCRIPTION = FND_API.G_MISS_CHAR ) then

1842:
1843:
1844: L_STRUCTURE_IN_REC.STRUCTURE_TYPE := l_struct_type;
1845:
1846: if ( L_STRUCTURE_IN_REC.DESCRIPTION = FND_API.G_MISS_CHAR ) then
1847:
1848: L_STRUCTURE_IN_REC.DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1849:
1850: end if;

Line 1952: if ( L_TASK_in_obj.PA_TASK_ID = FND_API.G_MISS_NUM ) then

1948: --
1949:
1950: /**
1951:
1952: if ( L_TASK_in_obj.PA_TASK_ID = FND_API.G_MISS_NUM ) then
1953: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1954: else
1955: L_TASK_IN_REC.PA_TASK_ID := L_TASK_IN_OBJ.PA_TASK_ID;
1956: end if;

Line 1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then

1958:
1959: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1960:
1961:
1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then
1963: L_TASK_IN_REC.TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1964: else
1965: L_TASK_IN_REC.TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1966: L_TASK_IN_REC.LONG_TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;

Line 1971: if ( L_TASK_in_obj.PA_TASK_NUMBER = FND_API.G_MISS_CHAR ) then

1967: end if;
1968:
1969: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_NAME '|| L_TASK_IN_REC.TASK_NAME);
1970:
1971: if ( L_TASK_in_obj.PA_TASK_NUMBER = FND_API.G_MISS_CHAR ) then
1972: L_TASK_IN_REC.PA_TASK_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1973: else
1974: L_TASK_IN_REC.PA_TASK_NUMBER := L_TASK_IN_OBJ.PA_TASK_NUMBER;
1975: end if;

Line 1978: if ( L_TASK_in_obj.TASK_DESCRIPTION = FND_API.G_MISS_CHAR ) then

1974: L_TASK_IN_REC.PA_TASK_NUMBER := L_TASK_IN_OBJ.PA_TASK_NUMBER;
1975: end if;
1976:
1977: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PA_TASK_NUMBER '|| L_TASK_IN_REC.PA_TASK_NUMBER);
1978: if ( L_TASK_in_obj.TASK_DESCRIPTION = FND_API.G_MISS_CHAR ) then
1979: L_TASK_IN_REC.TASK_DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1980: else
1981: L_TASK_IN_REC.TASK_DESCRIPTION := L_TASK_IN_OBJ.TASK_DESCRIPTION;
1982: end if;

Line 1985: if ( L_TASK_in_obj.PM_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then

1981: L_TASK_IN_REC.TASK_DESCRIPTION := L_TASK_IN_OBJ.TASK_DESCRIPTION;
1982: end if;
1983:
1984: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_DESCRIPTION '|| L_TASK_IN_REC.TASK_DESCRIPTION);
1985: if ( L_TASK_in_obj.PM_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1986: L_TASK_IN_REC.PM_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1987: else
1988: L_TASK_IN_REC.PM_TASK_REFERENCE := L_TASK_IN_OBJ.PM_TASK_REFERENCE;
1989: end if;

Line 1992: if ( L_TASK_in_obj.PM_PARENT_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then

1988: L_TASK_IN_REC.PM_TASK_REFERENCE := L_TASK_IN_OBJ.PM_TASK_REFERENCE;
1989: end if;
1990:
1991: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_TASK_REFERENCE '|| L_TASK_IN_REC.PM_TASK_REFERENCE);
1992: if ( L_TASK_in_obj.PM_PARENT_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1993: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1994: else
1995: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := L_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
1996: end if;

Line 2000: if ( L_TASK_in_obj.PA_PARENT_TASK_ID = FND_API.G_MISS_NUM ) then

1996: end if;
1997:
1998: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE '||L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE);
1999: /**
2000: if ( L_TASK_in_obj.PA_PARENT_TASK_ID = FND_API.G_MISS_NUM ) then
2001: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2002: else
2003: L_TASK_IN_REC.PA_PARENT_TASK_ID := L_TASK_IN_OBJ.PA_PARENT_TASK_ID;
2004: end if;

Line 2010: if ( L_TASK_in_obj.TASK_START_DATE = FND_API.G_MISS_DATE ) then

2006:
2007: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2008:
2009:
2010: if ( L_TASK_in_obj.TASK_START_DATE = FND_API.G_MISS_DATE ) then
2011: L_TASK_IN_REC.TASK_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2012: else
2013: L_TASK_IN_REC.TASK_START_DATE := trunc(L_TASK_IN_OBJ.TASK_START_DATE);
2014: end if;

Line 2018: if ( L_TASK_in_obj.TASK_COMPLETION_DATE = FND_API.G_MISS_DATE ) then

2014: end if;
2015:
2016: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_START_DATE '|| L_TASK_IN_REC.TASK_START_DATE);
2017:
2018: if ( L_TASK_in_obj.TASK_COMPLETION_DATE = FND_API.G_MISS_DATE ) then
2019: L_TASK_IN_REC.TASK_COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2020: else
2021: L_TASK_IN_REC.TASK_COMPLETION_DATE := trunc(nvl(trunc(L_TASK_IN_OBJ.TASK_COMPLETION_DATE), L_PROJECT_IN_REC.COMPLETION_DATE));
2022: end if;

Line 2043: if ( trunc(l_planned_object.early_start_date) = FND_API.G_MISS_DATE ) then

2039:
2040: /* Bug 12986544: Added trunc for Early Start Date, Early Finish Date,
2041: Late Start Date and Late Finish Date since these were showing incorrect dates in Ebiz*/
2042:
2043: if ( trunc(l_planned_object.early_start_date) = FND_API.G_MISS_DATE ) then
2044: L_TASK_IN_REC.early_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2045: else
2046: L_TASK_IN_REC.early_start_date := trunc(l_planned_object.EARLY_START_DATE);
2047: end if;

Line 2050: if ( trunc(l_planned_object.early_finish_date) = FND_API.G_MISS_DATE ) then

2046: L_TASK_IN_REC.early_start_date := trunc(l_planned_object.EARLY_START_DATE);
2047: end if;
2048:
2049: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.early_start_date '|| L_TASK_IN_REC.early_start_date);
2050: if ( trunc(l_planned_object.early_finish_date) = FND_API.G_MISS_DATE ) then
2051: L_TASK_IN_REC.early_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2052: else
2053: L_TASK_IN_REC.early_finish_date := trunc(l_planned_object.early_finish_date);
2054: end if;

Line 2057: if ( trunc(l_planned_object.late_start_date) = FND_API.G_MISS_DATE ) then

2053: L_TASK_IN_REC.early_finish_date := trunc(l_planned_object.early_finish_date);
2054: end if;
2055:
2056: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.early_finish_date '|| L_TASK_IN_REC.early_finish_date);
2057: if ( trunc(l_planned_object.late_start_date) = FND_API.G_MISS_DATE ) then
2058: L_TASK_IN_REC.late_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2059: else
2060: L_TASK_IN_REC.late_start_date := trunc(l_planned_object.late_start_date);
2061: end if;

Line 2064: if ( trunc(l_planned_object.late_finish_date) = FND_API.G_MISS_DATE ) then

2060: L_TASK_IN_REC.late_start_date := trunc(l_planned_object.late_start_date);
2061: end if;
2062:
2063: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.late_start_date '|| L_TASK_IN_REC.late_start_date);
2064: if ( trunc(l_planned_object.late_finish_date) = FND_API.G_MISS_DATE ) then
2065: L_TASK_IN_REC.late_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2066: else
2067: L_TASK_IN_REC.late_finish_date := trunc(l_planned_object.late_finish_date);
2068: end if;

Line 2071: if ( l_planned_object.PLANNED_START_DATE = FND_API.G_MISS_DATE ) then

2067: L_TASK_IN_REC.late_finish_date := trunc(l_planned_object.late_finish_date);
2068: end if;
2069:
2070: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.late_finish_date '|| L_TASK_IN_REC.late_finish_date);
2071: if ( l_planned_object.PLANNED_START_DATE = FND_API.G_MISS_DATE ) then
2072: L_TASK_IN_REC.scheduled_start_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2073: else
2074: L_TASK_IN_REC.scheduled_start_date := trunc(nvl(nvl(trunc(l_planned_object.PLANNED_START_DATE),L_TASK_IN_REC.TASK_START_DATE),L_PROJECT_IN_REC.START_DATE));
2075: end if;

Line 2078: if ( l_planned_object.PLANNED_COMPL_DATE = FND_API.G_MISS_DATE ) then

2074: L_TASK_IN_REC.scheduled_start_date := trunc(nvl(nvl(trunc(l_planned_object.PLANNED_START_DATE),L_TASK_IN_REC.TASK_START_DATE),L_PROJECT_IN_REC.START_DATE));
2075: end if;
2076:
2077: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.scheduled_start_date '|| L_TASK_IN_REC.scheduled_start_date);
2078: if ( l_planned_object.PLANNED_COMPL_DATE = FND_API.G_MISS_DATE ) then
2079: L_TASK_IN_REC.scheduled_finish_date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2080: else
2081: L_TASK_IN_REC.scheduled_finish_date := trunc(nvl(nvl(trunc(l_planned_object.PLANNED_COMPL_DATE),L_TASK_IN_REC.TASK_COMPLETION_DATE),L_PROJECT_IN_REC.COMPLETION_DATE));
2082: end if;

Line 2085: if ( l_planned_object.BASELINE_START_DATE = FND_API.G_MISS_DATE ) then

2081: L_TASK_IN_REC.scheduled_finish_date := trunc(nvl(nvl(trunc(l_planned_object.PLANNED_COMPL_DATE),L_TASK_IN_REC.TASK_COMPLETION_DATE),L_PROJECT_IN_REC.COMPLETION_DATE));
2082: end if;
2083:
2084: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.scheduled_finish_date '|| L_TASK_IN_REC.scheduled_finish_date);
2085: if ( l_planned_object.BASELINE_START_DATE = FND_API.G_MISS_DATE ) then
2086: L_TASK_IN_REC.BASELINE_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2087: else
2088: L_TASK_IN_REC.BASELINE_START_DATE := TRUNC(NVL(trunc(l_planned_object.BASELINE_START_DATE), L_TASK_IN_REC.TASK_START_DATE));
2089: end if;

Line 2092: if ( l_planned_object.BASELINE_FINISH_DATE = FND_API.G_MISS_DATE ) then

2088: L_TASK_IN_REC.BASELINE_START_DATE := TRUNC(NVL(trunc(l_planned_object.BASELINE_START_DATE), L_TASK_IN_REC.TASK_START_DATE));
2089: end if;
2090:
2091: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.BASELINE_START_DATE '|| L_TASK_IN_REC.BASELINE_START_DATE);
2092: if ( l_planned_object.BASELINE_FINISH_DATE = FND_API.G_MISS_DATE ) then
2093: L_TASK_IN_REC.BASELINE_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2094: else
2095: L_TASK_IN_REC.BASELINE_FINISH_DATE := trunc(nvl(trunc(l_planned_object.BASELINE_FINISH_DATE), L_TASK_IN_REC.TASK_COMPLETION_DATE));
2096: end if;

Line 2100: if ( l_planned_object.planned_duration = FND_API.G_MISS_NUM ) then

2096: end if;
2097:
2098:
2099: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.BASELINE_FINISH_DATE '|| L_TASK_IN_REC.BASELINE_FINISH_DATE);
2100: if ( l_planned_object.planned_duration = FND_API.G_MISS_NUM ) then
2101: L_TASK_IN_REC.ext_act_duration := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2102: else
2103: L_TASK_IN_REC.ext_act_duration := l_planned_object.planned_duration;
2104: end if;

Line 2108: if ( l_task_est_object.remaining_duration = FND_API.G_MISS_NUM ) then

2104: end if;
2105:
2106:
2107: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.ext_act_duration '|| L_TASK_IN_REC.ext_act_duration);
2108: if ( l_task_est_object.remaining_duration = FND_API.G_MISS_NUM ) then
2109: L_TASK_IN_REC.ext_remain_duration := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2110: else
2111: L_TASK_IN_REC.ext_remain_duration := l_task_est_object.remaining_duration;
2112: end if;

Line 2115: if ( l_task_est_object.etc_labor_qty = FND_API.G_MISS_NUM ) then

2111: L_TASK_IN_REC.ext_remain_duration := l_task_est_object.remaining_duration;
2112: end if;
2113:
2114: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.ext_remain_duration '|| L_TASK_IN_REC.ext_remain_duration);
2115: if ( l_task_est_object.etc_labor_qty = FND_API.G_MISS_NUM ) then
2116: L_TASK_IN_REC.etc_effort := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2117: else
2118: L_TASK_IN_REC.etc_effort := l_task_est_object.etc_labor_qty;
2119: end if;

Line 2122: if ( l_task_per_comp_object.physical_percent_comp = FND_API.G_MISS_NUM ) then

2118: L_TASK_IN_REC.etc_effort := l_task_est_object.etc_labor_qty;
2119: end if;
2120:
2121: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.etc_effort '|| L_TASK_IN_REC.etc_effort);
2122: if ( l_task_per_comp_object.physical_percent_comp = FND_API.G_MISS_NUM ) then
2123: L_TASK_IN_REC.percent_complete := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2124: else
2125: L_TASK_IN_REC.percent_complete := l_task_per_comp_object.physical_percent_comp;
2126: end if;

Line 2190: if ( l_res_assign.PM_RES_ASSIGN_REFERENCE = FND_API.G_MISS_CHAR ) then

2186: g_res_pa_task_elem_ver_id(g_res_counter) := null;
2187:
2188:
2189:
2190: if ( l_res_assign.PM_RES_ASSIGN_REFERENCE = FND_API.G_MISS_CHAR ) then
2191: g_res_pm_task_asgmt_reference(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
2192: else
2193: g_res_pm_task_asgmt_reference(g_res_counter) := l_res_assign.PM_RES_ASSIGN_REFERENCE;
2194: end if;

Line 2196: if ( l_res_assign.RESOURCE_ASSIGNMENT_ID = FND_API.G_MISS_NUM ) then

2192: else
2193: g_res_pm_task_asgmt_reference(g_res_counter) := l_res_assign.PM_RES_ASSIGN_REFERENCE;
2194: end if;
2195:
2196: if ( l_res_assign.RESOURCE_ASSIGNMENT_ID = FND_API.G_MISS_NUM ) then
2197: g_res_pa_task_assignment_id(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2198: else
2199: g_res_pa_task_assignment_id(g_res_counter) := l_res_assign.RESOURCE_ASSIGNMENT_ID;
2200: end if;

Line 2204: if ( l_res_assign.RESOURCE_NAME = FND_API.G_MISS_CHAR ) then

2200: end if;
2201:
2202: log_pvt('LOAD_PROJECT',' g_res_pa_task_assignment_id(g_res_counter) '||g_res_pa_task_assignment_id(g_res_counter));
2203:
2204: if ( l_res_assign.RESOURCE_NAME = FND_API.G_MISS_CHAR ) then
2205: g_res_resource_alias(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
2206: else
2207: g_res_resource_alias(g_res_counter) := l_res_assign.RESOURCE_NAME;
2208: end if;

Line 2212: if ( l_res_assign.RESOURCE_LIST_MEMBER_ID = FND_API.G_MISS_NUM ) then

2208: end if;
2209:
2210: log_pvt('LOAD_PROJECT',' g_res_resource_alias(g_res_counter) '||g_res_resource_alias(g_res_counter));
2211:
2212: if ( l_res_assign.RESOURCE_LIST_MEMBER_ID = FND_API.G_MISS_NUM ) then
2213: g_res_resource_list_member_id(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2214: else
2215: g_res_resource_list_member_id(g_res_counter) := l_res_assign.RESOURCE_LIST_MEMBER_ID;
2216: end if;

Line 2220: if ( l_res_assign.PLANNED_QTY = FND_API.G_MISS_NUM ) then

2216: end if;
2217:
2218: log_pvt('LOAD_PROJECT',' g_res_resource_list_member_id(g_res_counter) '||g_res_resource_list_member_id(g_res_counter));
2219:
2220: if ( l_res_assign.PLANNED_QTY = FND_API.G_MISS_NUM ) then
2221: g_res_planned_quantity(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2222: else
2223: g_res_planned_quantity(g_res_counter) := l_res_assign.PLANNED_QTY;
2224: end if;

Line 2227: if ( l_res_assign.PLANNED_START_DATE = FND_API.G_MISS_DATE ) then

2223: g_res_planned_quantity(g_res_counter) := l_res_assign.PLANNED_QTY;
2224: end if;
2225: log_pvt('LOAD_PROJECT',' g_res_planned_quantity(g_res_counter) '||g_res_planned_quantity(g_res_counter));
2226:
2227: if ( l_res_assign.PLANNED_START_DATE = FND_API.G_MISS_DATE ) then
2228: g_res_start_date(g_res_counter) := null;
2229: else
2230: g_res_start_date(g_res_counter) := trunc(l_res_assign.PLANNED_START_DATE);
2231: end if;

Line 2233: if ( l_res_assign.PLANNED_COMPL_DATE = FND_API.G_MISS_DATE ) then

2229: else
2230: g_res_start_date(g_res_counter) := trunc(l_res_assign.PLANNED_START_DATE);
2231: end if;
2232:
2233: if ( l_res_assign.PLANNED_COMPL_DATE = FND_API.G_MISS_DATE ) then
2234: g_res_end_date(g_res_counter) := null;
2235: else
2236: g_res_end_date(g_res_counter) := trunc(l_res_assign.PLANNED_COMPL_DATE);
2237: end if;

Line 2240: if ( l_res_assign.START_DATE = FND_API.G_MISS_DATE ) then

2236: g_res_end_date(g_res_counter) := trunc(l_res_assign.PLANNED_COMPL_DATE);
2237: end if;
2238:
2239:
2240: if ( l_res_assign.START_DATE = FND_API.G_MISS_DATE ) then
2241: g_res_start_date(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2242: else
2243: g_res_start_date(g_res_counter) := trunc(nvl(g_res_start_date(g_res_counter),l_res_assign.START_DATE));
2244: end if;

Line 2246: if ( l_res_assign.COMPLETION_DATE = FND_API.G_MISS_DATE ) then

2242: else
2243: g_res_start_date(g_res_counter) := trunc(nvl(g_res_start_date(g_res_counter),l_res_assign.START_DATE));
2244: end if;
2245:
2246: if ( l_res_assign.COMPLETION_DATE = FND_API.G_MISS_DATE ) then
2247: g_res_end_date(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2248: else
2249: g_res_end_date(g_res_counter) := trunc(nvl(g_res_end_date(g_res_counter),l_res_assign.COMPLETION_DATE));
2250: end if;

Line 2256: if ( l_res_assign.PLANNED_COST = FND_API.G_MISS_NUM ) then

2252:
2253: log_pvt('LOAD_PROJECT',' g_res_start_date(g_res_counter) '||g_res_start_date(g_res_counter));
2254: log_pvt('LOAD_PROJECT',' g_res_end_date(g_res_counter) '||g_res_end_date(g_res_counter));
2255:
2256: if ( l_res_assign.PLANNED_COST = FND_API.G_MISS_NUM ) then
2257: g_res_planned_total_raw_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2258: g_res_planned_total_bur_cost(g_res_counter) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2259: else
2260: g_res_planned_total_raw_cost(g_res_counter) := l_res_assign.PLANNED_COST;

Line 2631: ,p_commit => fnd_api.g_false

2627:
2628:
2629: PA_TASK_ASSIGNMENTS_PUB.Delete_Task_Assignments
2630: ( p_api_version_number => 1.0
2631: ,p_commit => fnd_api.g_false
2632: ,p_init_msg_list => FND_API.G_TRUE
2633: ,p_pa_project_id => p_project_in_rec.pa_project_id
2634: ,p_pa_structure_version_id => P_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
2635: ,p_task_assignments_in => l_del_res_asgmt_rec_tbl

Line 2632: ,p_init_msg_list => FND_API.G_TRUE

2628:
2629: PA_TASK_ASSIGNMENTS_PUB.Delete_Task_Assignments
2630: ( p_api_version_number => 1.0
2631: ,p_commit => fnd_api.g_false
2632: ,p_init_msg_list => FND_API.G_TRUE
2633: ,p_pa_project_id => p_project_in_rec.pa_project_id
2634: ,p_pa_structure_version_id => P_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
2635: ,p_task_assignments_in => l_del_res_asgmt_rec_tbl
2636: ,x_msg_count => x_msg_count

Line 2655: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

2651: x_msg_count := 10;
2652: end if;
2653: for i in 1..x_msg_count loop
2654:
2655: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
2656: ,p_msg_index => x_msg_count
2657: ,p_data => l_data
2658: ,p_msg_index_out => l_msg_index_out
2659: );

Line 2727: ,p_commit => fnd_api.g_false

2723: begin
2724:
2725:
2726: pa_project_pub.delete_task ( p_api_version_number => 1.0 -- for bug# 3802319
2727: ,p_commit => fnd_api.g_false
2728: ,p_init_msg_list => 'T'
2729: ,p_msg_count => x_msg_count
2730: ,p_msg_data => x_msg_data
2731: ,p_return_status => l_return_status

Line 2754: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

2750: x_msg_count := 10;
2751: end if;
2752: for i in 1..x_msg_count loop
2753:
2754: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
2755: ,p_msg_index => x_msg_count
2756: ,p_data => l_data
2757: ,p_msg_index_out => l_msg_index_out
2758: );

Line 2948: if ( p_CREATED_FROM_PROJECT_NUMBER <> FND_API.G_MISS_CHAR ) then

2944: Begin
2945:
2946: x_return_status := 'S';
2947:
2948: if ( p_CREATED_FROM_PROJECT_NUMBER <> FND_API.G_MISS_CHAR ) then
2949: l_from_project_number := p_CREATED_FROM_PROJECT_NUMBER ;
2950: end if;
2951:
2952: if ( P_pa_project_id <> FND_API.G_MISS_NUM ) then

Line 2952: if ( P_pa_project_id <> FND_API.G_MISS_NUM ) then

2948: if ( p_CREATED_FROM_PROJECT_NUMBER <> FND_API.G_MISS_CHAR ) then
2949: l_from_project_number := p_CREATED_FROM_PROJECT_NUMBER ;
2950: end if;
2951:
2952: if ( P_pa_project_id <> FND_API.G_MISS_NUM ) then
2953: l_project_id := P_pa_project_id ;
2954: end if;
2955:
2956: select a.name

Line 2977: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

2973: ,p_value1 => p_CREATED_FROM_PROJECT_NUMBER
2974: );
2975: X_MSG_COUNT := FND_MSG_PUB.count_msg ;
2976: for i in 1..x_msg_count loop
2977: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
2978: ,p_msg_index => x_msg_count
2979: ,p_data => l_data
2980: ,p_msg_index_out => l_msg_index_out
2981: );

Line 3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3101: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_BURDENED_COST '||l_budget_in_obj.TOTAL_BURDENED_COST);
3102: log_pvt('BUDGET_DATA',' BEFORE HEAD TOTAL_RAW_COST '||l_budget_in_obj.TOTAL_RAW_COST);
3103: log_pvt('BUDGET_DATA',' BEFORE HEAD BUDGET_ID '||l_budget_in_obj.BUDGET_ID);
3104:
3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3105: if ( nvl(l_budget_in_obj.PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3106: l_budget_in_obj.PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3107: end if;
3108:
3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3109: if ( nvl(l_budget_in_obj.Plan_Class_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3110: l_budget_in_obj.Plan_Class_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3111: end if;
3112:
3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3113: if ( nvl(l_budget_in_obj.Currency_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3114: l_budget_in_obj.Currency_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3115: end if;
3116:
3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3117: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3118: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3119: end if;
3120:
3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3121: if ( nvl(l_budget_in_obj.Status,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3122: l_budget_in_obj.Status := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3123: end if;
3124:
3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3125: if ( nvl(l_budget_in_obj.Baselined_Date,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3126: l_budget_in_obj.Baselined_Date := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3127: end if;
3128:
3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3129: if ( nvl(l_budget_in_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3130: l_budget_in_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3131: end if;
3132:
3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3133: if ( nvl(l_budget_in_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3134: l_budget_in_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3135: end if;
3136:
3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3137: if ( nvl(l_budget_in_obj.BUDGET_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3138: l_budget_in_obj.BUDGET_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3139: end if;
3140:
3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3141: if ( nvl(l_budget_in_obj.Type_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3142: l_budget_in_obj.Type_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3143: end if;
3144:
3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3145: if ( nvl(l_budget_in_obj.Level_Code,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3146: l_budget_in_obj.Level_Code := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3147: end if;
3148:
3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3149: if ( nvl(l_budget_in_obj.Name,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3150: l_budget_in_obj.Name := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3151: end if;
3152:
3153: if ( nvl(l_budget_in_obj.Description,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3154: l_budget_in_obj.Description := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3155: end if;
3156:
3157: l_budget_out_obj.AIA_COMMON_ID := l_budget_in_obj.AIA_COMMON_ID;

Line 3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3340:
3341: l_plan_task_obj := l_Plan_Task_OBJ_tbl(j);
3342: l_task_line_OBJ_tbl := l_Plan_Task_OBJ.task_line_tbl;
3343:
3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3344: if ( nvl(l_plan_task_obj.plan_task_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3345: l_plan_task_obj.plan_task_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3346: end if;
3347:
3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3348: if ( nvl(l_plan_task_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3349: l_plan_task_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3350: end if;
3351:
3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3352: if ( nvl(l_plan_task_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3353: l_plan_task_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3354: end if;
3355:
3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3356: if ( nvl(l_plan_task_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3357: l_plan_task_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3358: end if;
3359:
3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3360: if ( nvl(l_plan_task_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3361: l_plan_task_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3362: end if;
3363:
3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3364: if ( nvl(l_plan_task_obj.TASK_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3365: l_plan_task_obj.TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3366: end if;
3367:
3368: if ( nvl(l_budget_in_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3369: l_budget_in_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3370: end if;
3371:
3372: log_pvt('BUDGET_DATA',' AFTER LINE task_id '||l_plan_task_obj.task_id);

Line 3431: if ( nvl(l_task_line_obj.task_line_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3427: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_RAW_COST '||l_task_line_obj.TOTAL_RAW_COST);
3428: log_pvt('BUDGET_DATA',' BEFORE LINE TOTAL_BURDENED_COST '||l_task_line_obj.TOTAL_BURDENED_COST);
3429:
3430:
3431: if ( nvl(l_task_line_obj.task_line_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3432: l_task_line_obj.task_line_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3433: end if;
3434:
3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3431: if ( nvl(l_task_line_obj.task_line_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3432: l_task_line_obj.task_line_id := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3433: end if;
3434:
3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3436: l_task_line_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3437: end if;
3438:
3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

Line 3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then

3435: if ( nvl(l_task_line_obj.StartDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3436: l_task_line_obj.StartDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3437: end if;
3438:
3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3440: l_task_line_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3441: end if;
3442:
3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3439: if ( nvl(l_task_line_obj.EndDate,PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE) = FND_API.G_MISS_DATE ) then
3440: l_task_line_obj.EndDate := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
3441: end if;
3442:
3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3444: l_task_line_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3445: end if;
3446:
3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3443: if ( nvl(l_task_line_obj.TOTAL_BURDENED_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3444: l_task_line_obj.TOTAL_BURDENED_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3445: end if;
3446:
3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3448: l_task_line_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3449: end if;
3450:
3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

Line 3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then

3447: if ( nvl(l_task_line_obj.TOTAL_RAW_COST,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3448: l_task_line_obj.TOTAL_RAW_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3449: end if;
3450:
3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3452: l_task_line_obj.RESOURCE_LIST_MEMBER_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3453: end if;
3454:
3455: if ( nvl(l_task_line_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

Line 3455: if ( nvl(l_task_line_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then

3451: if ( nvl(l_task_line_obj.RESOURCE_LIST_MEMBER_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = FND_API.G_MISS_NUM ) then
3452: l_task_line_obj.RESOURCE_LIST_MEMBER_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
3453: end if;
3454:
3455: if ( nvl(l_task_line_obj.Update_Reason,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = FND_API.G_MISS_CHAR ) then
3456: l_task_line_obj.Update_Reason := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
3457: end if;
3458:
3459:

Line 3561: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

3557: if ( x_msg_count > 10 ) then
3558: x_msg_count := 10;
3559: end if;
3560: for i in 1..x_msg_count loop
3561: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
3562: ,p_msg_index => x_msg_count
3563: ,p_data => l_data
3564: ,p_msg_index_out => l_msg_index_out
3565: );

Line 3581: ,p_init_msg_list => FND_API.G_TRUE

3577: log_pvt('BUDGET_CALL','Before update_draft_budget ');
3578:
3579: pa_budget_pub.update_budget
3580: ( p_api_version_number => 1.1
3581: ,p_init_msg_list => FND_API.G_TRUE
3582: ,p_msg_count => x_msg_count
3583: ,p_msg_data => x_msg_data
3584: ,p_return_status => l_return_status
3585: ,p_pm_product_code => 'PRIMAVERA'

Line 3610: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false

3606: if ( x_msg_count > 10 ) then
3607: x_msg_count := 10;
3608: end if;
3609: for i in 1..x_msg_count loop
3610: pa_interface_utils_pub.get_messages ( p_encoded => fnd_api.g_false
3611: ,p_msg_index => x_msg_count
3612: ,p_data => l_data
3613: ,p_msg_index_out => l_msg_index_out
3614: );