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.CST_PACEAMCOST_GRP dependencies on FND_API

Line 134: l_conc_warning_flag := FND_API.G_FALSE;

130: 'Estimate_PAC_WipJobs <<');
131: END IF;
132:
133: -- Initializing Variables
134: l_conc_warning_flag := FND_API.G_FALSE;
135:
136: -- Initialize API return status to success
137: l_return_status := FND_API.G_RET_STS_SUCCESS;
138: l_msg_return_status := FND_API.G_RET_STS_SUCCESS;

Line 137: l_return_status := FND_API.G_RET_STS_SUCCESS;

133: -- Initializing Variables
134: l_conc_warning_flag := FND_API.G_FALSE;
135:
136: -- Initialize API return status to success
137: l_return_status := FND_API.G_RET_STS_SUCCESS;
138: l_msg_return_status := FND_API.G_RET_STS_SUCCESS;
139: l_stmt_num := 5;
140:
141: -- retrieving concurrent program information

Line 138: l_msg_return_status := FND_API.G_RET_STS_SUCCESS;

134: l_conc_warning_flag := FND_API.G_FALSE;
135:
136: -- Initialize API return status to success
137: l_return_status := FND_API.G_RET_STS_SUCCESS;
138: l_msg_return_status := FND_API.G_RET_STS_SUCCESS;
139: l_stmt_num := 5;
140:
141: -- retrieving concurrent program information
142: l_request_id := FND_GLOBAL.conc_request_id;

Line 426: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

422: x_msg_data => l_msg_data);
423:
424: l_stmt_num := 65;
425:
426: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
427: l_api_message := 'CST_PacEamCost_GRP.delete_PacEamPerBal() failed';
428: l_msg_data := l_api_message;
429: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
430: l_api_name,

Line 432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- ERROR rollback and exit

428: l_msg_data := l_api_message;
429: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
430: l_api_name,
431: '('|| to_char(l_stmt_num) || '): '|| l_api_message);
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- ERROR rollback and exit
433: END IF;
434:
435: -- statement level logging
436: IF (l_sLog) THEN

Line 451: p_init_msg_list => FND_API.G_FALSE,

447: eAM enhancements Project - R12 */
448:
449: Delete_PAC_eamBalAcct (
450: p_api_version => 1.0,
451: p_init_msg_list => FND_API.G_FALSE,
452: p_commit => FND_API.G_FALSE,
453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
454: p_wip_entity_id_tab => l_wip_entity_id_tab,
455: p_legal_entity_id => p_legal_entity_id,

Line 452: p_commit => FND_API.G_FALSE,

448:
449: Delete_PAC_eamBalAcct (
450: p_api_version => 1.0,
451: p_init_msg_list => FND_API.G_FALSE,
452: p_commit => FND_API.G_FALSE,
453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
454: p_wip_entity_id_tab => l_wip_entity_id_tab,
455: p_legal_entity_id => p_legal_entity_id,
456: p_cost_group_id => p_cost_group_id,

Line 453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

449: Delete_PAC_eamBalAcct (
450: p_api_version => 1.0,
451: p_init_msg_list => FND_API.G_FALSE,
452: p_commit => FND_API.G_FALSE,
453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
454: p_wip_entity_id_tab => l_wip_entity_id_tab,
455: p_legal_entity_id => p_legal_entity_id,
456: p_cost_group_id => p_cost_group_id,
457: p_cost_type_id => p_cost_type_id,

Line 464: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

460: x_msg_data => l_msg_data);
461:
462: l_stmt_num := 66;
463:
464: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
465: l_api_message := 'CST_PacEamCost_GRP.delete_PAC_EamBalAcct() failed';
466: l_msg_data := l_api_message;
467: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name,
468: '('|| to_char(l_stmt_num) || '): '|| l_api_message);

Line 469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- ERROR rollback and exit

465: l_api_message := 'CST_PacEamCost_GRP.delete_PAC_EamBalAcct() failed';
466: l_msg_data := l_api_message;
467: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name,
468: '('|| to_char(l_stmt_num) || '): '|| l_api_message);
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- ERROR rollback and exit
470: END IF;
471:
472: -- statement level logging
473: IF (l_sLog) THEN

Line 506: IF l_return_status <> FND_API.g_ret_sts_success THEN

502: x_msg_data => l_msg_data,
503: p_entity_id_tab => l_entity_id_tab
504: );
505:
506: IF l_return_status <> FND_API.g_ret_sts_success THEN
507:
508: l_api_message := 'Error: CST_eamCost_PUB.Insert_tempEstimateDetails()';
509:
510: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('

Line 513: RAISE FND_API.g_exc_error;

509:
510: FND_MSG_PUB.ADD_EXC_MSG('CSTPECEP', 'ESTIMATE_WORKORDER('
511: ||TO_CHAR(l_stmt_num)
512: ||'): ', l_api_message);
513: RAISE FND_API.g_exc_error;
514:
515: END IF;
516:
517: -- statement level logging

Line 571: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

567: p_login_id => l_login_id);
568:
569: l_stmt_num := 80;
570:
571: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
572: l_api_message := 'CST_PacEamCost_GRP.Compute_PAC_JobEstimates failed';
573: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
574: l_api_name,
575: '('|| to_char(l_stmt_num) || '): '|| l_api_message);

Line 619: l_conc_warning_flag := FND_API.G_TRUE; -- When even one has failed. Display a warning.

615: AND legal_entity_id = p_legal_entity_id
616: AND cost_type_id = p_cost_type_id
617: AND cost_group_id = p_cost_group_id;
618:
619: l_conc_warning_flag := FND_API.G_TRUE; -- When even one has failed. Display a warning.
620:
621: l_stmt_num := 90;
622:
623: -- statement level logging

Line 641: IF FND_API.to_boolean(l_conc_warning_flag) THEN

637:
638: END LOOP; -- WHILE (l_index IS NOT NULL) LOOP
639:
640: -- Set status to warning if even one failed. If no Error, default is Success.
641: IF FND_API.to_boolean(l_conc_warning_flag) THEN
642: l_stmt_num := 95;
643: IF p_job_option = 2 THEN
644: l_api_message := 'Estimation of the job failed';
645: ELSE

Line 732: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

728: --
729: -- Pre-reqs : None.
730: -- Parameters :
731: -- IN : p_api_version IN NUMBER Required
732: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
733: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
734: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
735: -- p_legal_entity_id IN NUMBER Required
736: -- p_cost_group_id IN NUMBER Required

Line 733: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

729: -- Pre-reqs : None.
730: -- Parameters :
731: -- IN : p_api_version IN NUMBER Required
732: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
733: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
734: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
735: -- p_legal_entity_id IN NUMBER Required
736: -- p_cost_group_id IN NUMBER Required
737: -- p_cost_type_id IN NUMBER Required

Line 734: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

730: -- Parameters :
731: -- IN : p_api_version IN NUMBER Required
732: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
733: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
734: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
735: -- p_legal_entity_id IN NUMBER Required
736: -- p_cost_group_id IN NUMBER Required
737: -- p_cost_type_id IN NUMBER Required
738: -- p_organization_id IN NUMBER Required

Line 844: IF NOT FND_API.Compatible_API_Call (l_api_version,

840: /* Standard Start of API savepoint */
841: SAVEPOINT Delete_PAC_EamPerBal_PUB;
842:
843: /* Standard call to check for call compatibility */
844: IF NOT FND_API.Compatible_API_Call (l_api_version,
845: p_api_version,
846: l_api_name,
847: G_PKG_NAME ) THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

844: IF NOT FND_API.Compatible_API_Call (l_api_version,
845: p_api_version,
846: l_api_name,
847: G_PKG_NAME ) THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;
850:
851: /* Initialize message list if p_init_msg_list is set to TRUE */
852: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 852: IF FND_API.to_Boolean(p_init_msg_list) THEN

848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;
850:
851: /* Initialize message list if p_init_msg_list is set to TRUE */
852: IF FND_API.to_Boolean(p_init_msg_list) THEN
853: FND_MSG_PUB.initialize;
854: END IF;
855:
856: /* Initialize API return status to success */

Line 857: l_return_status := FND_API.G_RET_STS_SUCCESS;

853: FND_MSG_PUB.initialize;
854: END IF;
855:
856: /* Initialize API return status to success */
857: l_return_status := FND_API.G_RET_STS_SUCCESS;
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859:
860: /* Get asset group and asset number of job */
861: l_stmt_num := 100;

Line 858: x_return_status := FND_API.G_RET_STS_SUCCESS;

854: END IF;
855:
856: /* Initialize API return status to success */
857: l_return_status := FND_API.G_RET_STS_SUCCESS;
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859:
860: /* Get asset group and asset number of job */
861: l_stmt_num := 100;
862:

Line 1010: WHEN FND_API.G_EXC_ERROR THEN

1006: END IF;
1007:
1008: EXCEPTION
1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1012: x_return_status := FND_API.g_ret_sts_error;
1013: /* Get message count and data */
1014: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 1012: x_return_status := FND_API.g_ret_sts_error;

1008: EXCEPTION
1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1012: x_return_status := FND_API.g_ret_sts_error;
1013: /* Get message count and data */
1014: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1015: p_data => x_msg_data);
1016:

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: /* Get message count and data */
1014: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1015: p_data => x_msg_data);
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020:
1021: /* Get message count and data */

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1015: p_data => x_msg_data);
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020:
1021: /* Get message count and data */
1022: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1023: p_data => x_msg_data);

Line 1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1023: p_data => x_msg_data);
1024:
1025: WHEN OTHERS THEN
1026: ROLLBACK TO Delete_PAC_EamPerBal_PUB;
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028:
1029: IF (l_uLog) THEN
1030: FND_LOG.STRING(
1031: FND_LOG.LEVEL_UNEXPECTED,

Line 1097: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

1093: --
1094: -- Pre-reqs : None.
1095: -- Parameters :
1096: -- IN : p_api_version IN NUMBER Required
1097: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1098: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1099: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1100: -- p_cost_group_id IN NUMBER Required
1101: -- p_legal_entity_id IN NUMBER Required

Line 1098: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1094: -- Pre-reqs : None.
1095: -- Parameters :
1096: -- IN : p_api_version IN NUMBER Required
1097: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1098: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1099: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1100: -- p_cost_group_id IN NUMBER Required
1101: -- p_legal_entity_id IN NUMBER Required
1102: -- p_Period_id IN NUMBER Required

Line 1099: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

1095: -- Parameters :
1096: -- IN : p_api_version IN NUMBER Required
1097: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1098: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1099: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1100: -- p_cost_group_id IN NUMBER Required
1101: -- p_legal_entity_id IN NUMBER Required
1102: -- p_Period_id IN NUMBER Required
1103: -- p_wip_entity_id IN NUMBER Required

Line 1121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1117: -- End of comments
1118:
1119: PROCEDURE Compute_PAC_JobEstimates (
1120: p_api_version IN NUMBER,
1121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,

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

1118:
1119: PROCEDURE Compute_PAC_JobEstimates (
1120: p_api_version IN NUMBER,
1121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,
1126: x_msg_data OUT NOCOPY VARCHAR2,

Line 1123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1119: PROCEDURE Compute_PAC_JobEstimates (
1120: p_api_version IN NUMBER,
1121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,
1126: x_msg_data OUT NOCOPY VARCHAR2,
1127: p_legal_entity_id IN NUMBER,

Line 1145: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;

1141:
1142: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1143: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1144:
1145: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
1146: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1147: l_msg_count NUMBER := 0;
1148: l_msg_data VARCHAR2(8000);
1149:

Line 1146: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1142: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1143: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1144:
1145: l_return_status VARCHAR(1) := FND_API.G_RET_STS_SUCCESS;
1146: l_msg_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1147: l_msg_count NUMBER := 0;
1148: l_msg_data VARCHAR2(8000);
1149:
1150: l_api_message VARCHAR2(250);

Line 1549: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,

1545: -- standard start of API savepoint
1546: SAVEPOINT Compute_PAC_JobEstimates_PUB;
1547:
1548: -- standard call to check for call compatibility
1549: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
1550: p_api_version,
1551: l_api_name,
1552: G_PKG_NAME ) THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1549: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version,
1550: p_api_version,
1551: l_api_name,
1552: G_PKG_NAME ) THEN
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE
1557: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1557: IF FND_API.to_Boolean(p_init_msg_list) THEN

1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE
1557: IF FND_API.to_Boolean(p_init_msg_list) THEN
1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- initialize api return status to success

Line 1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

1558: FND_MSG_PUB.initialize;
1559: END IF;
1560:
1561: -- initialize api return status to success
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;
1563:
1564: -- assign to local variables
1565: l_stmt_num := 200;
1566:

Line 1580: RAISE FND_API.G_EXC_ERROR;

1576:
1577: IF (l_entity_type <> 6 ) THEN
1578: l_msg_data := 'Invalid WIP entity type: ' || TO_CHAR(l_entity_type)
1579: ||' WIP Entity: ' || TO_CHAR(p_wip_entity_id);
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;
1582:
1583: SELECT start_quantity,
1584: scheduled_completion_date

Line 1606: RAISE FND_API.G_EXC_ERROR;

1602: x_msg_data => l_msg_data);
1603: EXCEPTION
1604: WHEN OTHERS THEN
1605: l_msg_data := 'CST_EAMCOST_PUB.get_charge_asset() failed';
1606: RAISE FND_API.G_EXC_ERROR;
1607: END;
1608:
1609: l_stmt_num := 215;
1610:

Line 1614: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1610:
1611: l_api_message := 'l_asset_group_item_id : '|| TO_CHAR(l_asset_group_item_id)
1612: || ' l_asset_number : '|| l_asset_number;
1613:
1614: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1615: l_api_message := 'CST_EAMCOST_PUB.get_charge_asset() returned error ' || l_api_message;
1616: l_msg_data := l_api_message;
1617: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1618: l_api_name,

Line 1621: RAISE FND_API.G_EXC_ERROR;

1617: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1618: l_api_name,
1619: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1620: || SUBSTRB (SQLERRM , 1 , 240));
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: -- statement level logging
1625: IF (l_sLog) THEN

Line 1707: RAISE FND_API.G_EXC_ERROR;

1703: AND (l_period_set_name IS NULL OR l_period_name IS NULL)) THEN
1704:
1705: l_msg_data := 'Cannot Find Period for Date: '
1706: ||TO_CHAR(l_trunc_le_sched_comp_date);
1707: RAISE FND_API.G_EXC_ERROR;
1708: END IF;
1709:
1710: -- Derive the currency extended precision for the organization
1711: CSTPUTIL.CSTPUGCI(l_organization_id,

Line 1742: RAISE FND_API.G_EXC_ERROR;

1738: l_stmt_num := 250;
1739:
1740: IF (l_pac_rates_id = -1) THEN
1741: l_msg_data := 'PAC Rates Type is not defined for Cost Type: '|| TO_CHAR(p_cost_type_id);
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: /* Fetch the WAC account information for this wip job */
1746: open c_acct(p_wip_entity_id);

Line 1777: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1773: x_owning_dept => l_owning_dept_id,
1774: x_maint_cost_cat => l_maint_cost_category);
1775:
1776: l_stmt_num := 260;
1777: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1778: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
1779: l_msg_data := l_api_message;
1780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1781: l_api_name,

Line 1784: RAISE FND_API.G_EXC_ERROR;

1780: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1781: l_api_name,
1782: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1783: || SUBSTRB (SQLERRM , 1 , 240));
1784: RAISE FND_API.G_EXC_ERROR;
1785: END IF;
1786:
1787: -- Get the eAM cost element by calling API
1788: l_eam_cost_element := CST_EAMCOST_PUB.Get_eamCostElement(

Line 1802: RAISE FND_API.G_EXC_ERROR;

1798: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1799: l_api_name,
1800: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1801: || SUBSTRB (SQLERRM , 1 , 240));
1802: RAISE FND_API.G_EXC_ERROR;
1803: END IF;
1804:
1805: /* Insert estimated resource values into WPEPB and CPEAPB */
1806: InsertUpdate_PAC_eamPerBal(p_api_version => 1.0,

Line 1835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1831: p_login_id => p_login_id);
1832:
1833: l_stmt_num := 270;
1834:
1835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1836: l_api_message := 'insertupdate_PAC_eamperbal() returned error ';
1837: l_msg_data := l_api_message;
1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1839: l_api_name,

Line 1842: RAISE FND_API.G_EXC_ERROR;

1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1839: l_api_name,
1840: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1841: || SUBSTRB (SQLERRM , 1 , 240));
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845: IF c_wor_rec.resource_value <> 0 then
1846:

Line 1860: p_init_msg_list => FND_API.G_FALSE,

1856: end case;
1857:
1858: Insert_PAC_eamBalAcct(
1859: p_api_version => 1.0,
1860: p_init_msg_list => FND_API.G_FALSE,
1861: p_commit => FND_API.G_FALSE,
1862: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1863: x_return_status => l_return_status,
1864: x_msg_count => l_msg_count,

Line 1861: p_commit => FND_API.G_FALSE,

1857:
1858: Insert_PAC_eamBalAcct(
1859: p_api_version => 1.0,
1860: p_init_msg_list => FND_API.G_FALSE,
1861: p_commit => FND_API.G_FALSE,
1862: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1863: x_return_status => l_return_status,
1864: x_msg_count => l_msg_count,
1865: x_msg_data => l_msg_data,

Line 1862: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1858: Insert_PAC_eamBalAcct(
1859: p_api_version => 1.0,
1860: p_init_msg_list => FND_API.G_FALSE,
1861: p_commit => FND_API.G_FALSE,
1862: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1863: x_return_status => l_return_status,
1864: x_msg_count => l_msg_count,
1865: x_msg_data => l_msg_data,
1866: p_legal_entity_id => p_legal_entity_id,

Line 1890: IF l_return_status <> FND_API.g_ret_sts_success THEN

1886: p_prog_id => p_prog_id,
1887: p_prog_app_id => p_prog_app_id,
1888: p_login_id => p_login_id);
1889:
1890: IF l_return_status <> FND_API.g_ret_sts_success THEN
1891:
1892: l_api_message := 'Insert_PAC_eamBalAcct error';
1893: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
1894: ||TO_CHAR(l_stmt_num)

Line 1896: RAISE FND_API.g_exc_error;

1892: l_api_message := 'Insert_PAC_eamBalAcct error';
1893: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
1894: ||TO_CHAR(l_stmt_num)
1895: ||'): ', l_api_message);
1896: RAISE FND_API.g_exc_error;
1897:
1898: END IF;
1899:
1900: END IF; -- if c_wor_rec.resource_value !=0

Line 1948: IF l_return_status <> FND_API.g_ret_sts_success THEN

1944: p_login_id => p_login_id);
1945:
1946: l_stmt_num := 280;
1947:
1948: IF l_return_status <> FND_API.g_ret_sts_success THEN
1949: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
1950: l_msg_data := l_api_message;
1951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1952: l_api_name,

Line 1955: RAISE FND_API.G_EXC_ERROR;

1951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1952: l_api_name,
1953: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
1954: || SUBSTRB (SQLERRM , 1 , 240));
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:
1958: END LOOP; /* c_rbo_rec */
1959:

Line 1967: p_init_msg_list => FND_API.G_FALSE,

1963: l_stmt_num := 283;
1964:
1965: Insert_PAC_eamBalAcct(
1966: p_api_version => 1.0,
1967: p_init_msg_list => FND_API.G_FALSE,
1968: p_commit => FND_API.G_FALSE,
1969: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1970: x_return_status => l_return_status,
1971: x_msg_count => l_msg_count,

Line 1968: p_commit => FND_API.G_FALSE,

1964:
1965: Insert_PAC_eamBalAcct(
1966: p_api_version => 1.0,
1967: p_init_msg_list => FND_API.G_FALSE,
1968: p_commit => FND_API.G_FALSE,
1969: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1970: x_return_status => l_return_status,
1971: x_msg_count => l_msg_count,
1972: x_msg_data => l_msg_data,

Line 1969: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1965: Insert_PAC_eamBalAcct(
1966: p_api_version => 1.0,
1967: p_init_msg_list => FND_API.G_FALSE,
1968: p_commit => FND_API.G_FALSE,
1969: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1970: x_return_status => l_return_status,
1971: x_msg_count => l_msg_count,
1972: x_msg_data => l_msg_data,
1973: p_legal_entity_id => p_legal_entity_id,

Line 1997: IF l_return_status <> FND_API.g_ret_sts_success THEN

1993: p_prog_id => p_prog_id,
1994: p_prog_app_id => p_prog_app_id,
1995: p_login_id => p_login_id);
1996:
1997: IF l_return_status <> FND_API.g_ret_sts_success THEN
1998:
1999: l_api_message := 'Insert_PAC_eamBalAcct error';
2000: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2001: ||TO_CHAR(l_stmt_num)

Line 2003: RAISE FND_API.g_exc_error;

1999: l_api_message := 'Insert_PAC_eamBalAcct error';
2000: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2001: ||TO_CHAR(l_stmt_num)
2002: ||'): ', l_api_message);
2003: RAISE FND_API.g_exc_error;
2004:
2005: END IF;
2006:
2007: END IF; -- if l_sum_rbo != 0

Line 2037: IF l_return_status <> FND_API.g_ret_sts_success THEN

2033: x_maint_cost_cat => l_maint_cost_category);
2034:
2035: l_stmt_num := 290;
2036:
2037: IF l_return_status <> FND_API.g_ret_sts_success THEN
2038: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2039: l_msg_data := l_api_message;
2040: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2041: l_api_name,

Line 2044: RAISE FND_API.G_EXC_ERROR;

2040: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2041: l_api_name,
2042: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2043: || SUBSTRB (SQLERRM , 1 , 240));
2044: RAISE FND_API.G_EXC_ERROR;
2045: END IF;
2046:
2047: l_stmt_num := 295;
2048:

Line 2063: RAISE FND_API.G_EXC_ERROR;

2059: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2060: l_api_name,
2061: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2062: || SUBSTRB (SQLERRM , 1 , 240));
2063: RAISE FND_API.G_EXC_ERROR;
2064: END IF;
2065:
2066: -- Insert estimated material values into WPEPB and CPEAPB
2067: InsertUpdate_PAC_eamPerBal(p_api_version => 1.0,

Line 2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2092: p_login_id => p_login_id);
2093:
2094: l_stmt_num := 305;
2095:
2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2097: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2098: l_msg_data := l_api_message;
2099: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2100: l_api_name,

Line 2103: RAISE FND_API.G_EXC_ERROR;

2099: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2100: l_api_name,
2101: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2102: || SUBSTRB (SQLERRM , 1 , 240));
2103: RAISE FND_API.G_EXC_ERROR;
2104: END IF;
2105:
2106: l_stmt_num := 308;
2107:

Line 2177: p_init_msg_list => FND_API.G_FALSE,

2173: If (l_exec_flag = 1) then
2174:
2175: Insert_PAC_eamBalAcct(
2176: p_api_version => 1.0,
2177: p_init_msg_list => FND_API.G_FALSE,
2178: p_commit => FND_API.G_FALSE,
2179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2180: x_return_status => l_return_status,
2181: x_msg_count => l_msg_count,

Line 2178: p_commit => FND_API.G_FALSE,

2174:
2175: Insert_PAC_eamBalAcct(
2176: p_api_version => 1.0,
2177: p_init_msg_list => FND_API.G_FALSE,
2178: p_commit => FND_API.G_FALSE,
2179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2180: x_return_status => l_return_status,
2181: x_msg_count => l_msg_count,
2182: x_msg_data => l_msg_data,

Line 2179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2175: Insert_PAC_eamBalAcct(
2176: p_api_version => 1.0,
2177: p_init_msg_list => FND_API.G_FALSE,
2178: p_commit => FND_API.G_FALSE,
2179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2180: x_return_status => l_return_status,
2181: x_msg_count => l_msg_count,
2182: x_msg_data => l_msg_data,
2183: p_legal_entity_id => p_legal_entity_id,

Line 2207: IF l_return_status <> FND_API.g_ret_sts_success THEN

2203: p_prog_id => p_prog_id,
2204: p_prog_app_id => p_prog_app_id,
2205: p_login_id => p_login_id);
2206:
2207: IF l_return_status <> FND_API.g_ret_sts_success THEN
2208:
2209: l_api_message := 'Insert_PAC_eamBalAcct error';
2210: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2211: ||TO_CHAR(l_stmt_num)

Line 2213: RAISE FND_API.g_exc_error;

2209: l_api_message := 'Insert_PAC_eamBalAcct error';
2210: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2211: ||TO_CHAR(l_stmt_num)
2212: ||'): ', l_api_message);
2213: RAISE FND_API.g_exc_error;
2214:
2215: END IF;
2216: End If;
2217:

Line 2251: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2247: x_maint_cost_cat => l_maint_cost_category);
2248:
2249: l_stmt_num := 320;
2250:
2251: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2252: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2253: l_msg_data := l_api_message;
2254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2255: l_api_name,

Line 2258: RAISE FND_API.g_exc_error;

2254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2255: l_api_name,
2256: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2257: || SUBSTRB (SQLERRM , 1 , 240));
2258: RAISE FND_API.g_exc_error;
2259: END IF;
2260:
2261: BEGIN
2262: select cceea.mnt_cost_element_id, cceea.mfg_cost_element_id

Line 2284: RAISE FND_API.g_exc_error;

2280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2281: l_api_name,
2282: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2283: || SUBSTRB (SQLERRM , 1 , 240));
2284: RAISE FND_API.g_exc_error;
2285: END IF;
2286:
2287: l_stmt_num := 330;
2288:

Line 2319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2315: p_login_id => p_login_id);
2316:
2317: l_stmt_num := 335;
2318:
2319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2320: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2321: l_msg_data := l_api_message;
2322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2323: l_api_name,

Line 2326: RAISE FND_API.G_EXC_ERROR;

2322: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2323: l_api_name,
2324: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2325: || SUBSTRB (SQLERRM , 1 , 240));
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;
2328:
2329: IF c_wrodi_rec.mat_value <> 0 THEN
2330:

Line 2348: p_init_msg_list => FND_API.G_FALSE,

2344: end case;
2345:
2346: Insert_PAC_eamBalAcct(
2347: p_api_version => 1.0,
2348: p_init_msg_list => FND_API.G_FALSE,
2349: p_commit => FND_API.G_FALSE,
2350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2351: x_return_status => l_return_status,
2352: x_msg_count => l_msg_count,

Line 2349: p_commit => FND_API.G_FALSE,

2345:
2346: Insert_PAC_eamBalAcct(
2347: p_api_version => 1.0,
2348: p_init_msg_list => FND_API.G_FALSE,
2349: p_commit => FND_API.G_FALSE,
2350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2351: x_return_status => l_return_status,
2352: x_msg_count => l_msg_count,
2353: x_msg_data => l_msg_data,

Line 2350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2346: Insert_PAC_eamBalAcct(
2347: p_api_version => 1.0,
2348: p_init_msg_list => FND_API.G_FALSE,
2349: p_commit => FND_API.G_FALSE,
2350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2351: x_return_status => l_return_status,
2352: x_msg_count => l_msg_count,
2353: x_msg_data => l_msg_data,
2354: p_legal_entity_id => p_legal_entity_id,

Line 2378: IF l_return_status <> FND_API.g_ret_sts_success THEN

2374: p_prog_id => p_prog_id,
2375: p_prog_app_id => p_prog_app_id,
2376: p_login_id => p_login_id);
2377:
2378: IF l_return_status <> FND_API.g_ret_sts_success THEN
2379:
2380: l_api_message := 'Insert_PAC_eamBalAcct error';
2381: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2382: ||TO_CHAR(l_stmt_num)

Line 2384: RAISE FND_API.g_exc_error;

2380: l_api_message := 'Insert_PAC_eamBalAcct error';
2381: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2382: ||TO_CHAR(l_stmt_num)
2383: ||'): ', l_api_message);
2384: RAISE FND_API.g_exc_error;
2385:
2386: END IF;
2387: End If;
2388:

Line 2419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2415: x_maint_cost_cat => l_maint_cost_category);
2416:
2417: l_stmt_num := 350;
2418:
2419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2420: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2421: l_msg_data := l_api_message;
2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2423: l_api_name,

Line 2426: RAISE FND_API.G_EXC_ERROR;

2422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2423: l_api_name,
2424: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2425: || SUBSTRB (SQLERRM , 1 , 240));
2426: RAISE FND_API.G_EXC_ERROR;
2427: END IF;
2428:
2429: BEGIN
2430: SELECT cceea.mnt_cost_element_id, cceea.mfg_cost_element_id

Line 2473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2469: p_login_id => p_login_id);
2470:
2471: l_stmt_num := 360;
2472:
2473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2474: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2475: l_msg_data := l_api_message;
2476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2477: l_api_name,

Line 2480: RAISE FND_API.G_EXC_ERROR;

2476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2477: l_api_name,
2478: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2479: || SUBSTRB (SQLERRM , 1 , 240));
2480: RAISE FND_API.G_EXC_ERROR;
2481: END IF;
2482:
2483:
2484: If c_wedi_rec.wedi_value <> 0 then

Line 2503: p_init_msg_list => FND_API.G_FALSE,

2499: end case;
2500:
2501: Insert_PAC_eamBalAcct(
2502: p_api_version => 1.0,
2503: p_init_msg_list => FND_API.G_FALSE,
2504: p_commit => FND_API.G_FALSE,
2505: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2506: x_return_status => l_return_status,
2507: x_msg_count => l_msg_count,

Line 2504: p_commit => FND_API.G_FALSE,

2500:
2501: Insert_PAC_eamBalAcct(
2502: p_api_version => 1.0,
2503: p_init_msg_list => FND_API.G_FALSE,
2504: p_commit => FND_API.G_FALSE,
2505: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2506: x_return_status => l_return_status,
2507: x_msg_count => l_msg_count,
2508: x_msg_data => l_msg_data,

Line 2505: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2501: Insert_PAC_eamBalAcct(
2502: p_api_version => 1.0,
2503: p_init_msg_list => FND_API.G_FALSE,
2504: p_commit => FND_API.G_FALSE,
2505: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2506: x_return_status => l_return_status,
2507: x_msg_count => l_msg_count,
2508: x_msg_data => l_msg_data,
2509: p_legal_entity_id => p_legal_entity_id,

Line 2533: IF l_return_status <> FND_API.g_ret_sts_success THEN

2529: p_prog_id => p_prog_id,
2530: p_prog_app_id => p_prog_app_id,
2531: p_login_id => p_login_id);
2532:
2533: IF l_return_status <> FND_API.g_ret_sts_success THEN
2534:
2535: l_api_message := 'Insert_PAC_eamBalAcct error';
2536: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2537: ||TO_CHAR(l_stmt_num)

Line 2539: RAISE FND_API.g_exc_error;

2535: l_api_message := 'Insert_PAC_eamBalAcct error';
2536: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2537: ||TO_CHAR(l_stmt_num)
2538: ||'): ', l_api_message);
2539: RAISE FND_API.g_exc_error;
2540:
2541: END IF;
2542: End If;
2543: END LOOP; /* end c_wedi_rec */

Line 2582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2578: x_maint_cost_cat => l_maint_cost_category);
2579:
2580: l_stmt_num := 380;
2581:
2582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2583: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat() returned error';
2584: l_msg_data := l_api_message;
2585: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2586: l_api_name,

Line 2589: RAISE FND_API.G_EXC_ERROR;

2585: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2586: l_api_name,
2587: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2588: || SUBSTRB (SQLERRM , 1 , 240));
2589: RAISE FND_API.G_EXC_ERROR;
2590: END IF;
2591:
2592: BEGIN
2593: SELECT cceea.mnt_cost_element_id, cceea.mfg_cost_element_id

Line 2638: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2634: p_login_id => p_login_id);
2635:
2636: l_stmt_num := 390;
2637:
2638: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2639: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
2640: l_msg_data := l_api_message;
2641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2642: l_api_name,

Line 2645: RAISE FND_API.G_EXC_ERROR;

2641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2642: l_api_name,
2643: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
2644: || SUBSTRB (SQLERRM , 1 , 240));
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;
2647:
2648: If c_pda_rec.pda_value <> 0 then
2649:

Line 2667: p_init_msg_list => FND_API.G_FALSE,

2663: end case;
2664:
2665: Insert_PAC_eamBalAcct(
2666: p_api_version => 1.0,
2667: p_init_msg_list => FND_API.G_FALSE,
2668: p_commit => FND_API.G_FALSE,
2669: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2670: x_return_status => l_return_status,
2671: x_msg_count => l_msg_count,

Line 2668: p_commit => FND_API.G_FALSE,

2664:
2665: Insert_PAC_eamBalAcct(
2666: p_api_version => 1.0,
2667: p_init_msg_list => FND_API.G_FALSE,
2668: p_commit => FND_API.G_FALSE,
2669: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2670: x_return_status => l_return_status,
2671: x_msg_count => l_msg_count,
2672: x_msg_data => l_msg_data,

Line 2669: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2665: Insert_PAC_eamBalAcct(
2666: p_api_version => 1.0,
2667: p_init_msg_list => FND_API.G_FALSE,
2668: p_commit => FND_API.G_FALSE,
2669: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2670: x_return_status => l_return_status,
2671: x_msg_count => l_msg_count,
2672: x_msg_data => l_msg_data,
2673: p_legal_entity_id => p_legal_entity_id,

Line 2697: IF l_return_status <> FND_API.g_ret_sts_success THEN

2693: p_prog_id => p_prog_id,
2694: p_prog_app_id => p_prog_app_id,
2695: p_login_id => p_login_id);
2696:
2697: IF l_return_status <> FND_API.g_ret_sts_success THEN
2698:
2699: l_api_message := 'Insert_PAC_eamBalAcct error';
2700: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2701: ||TO_CHAR(l_stmt_num)

Line 2703: RAISE FND_API.g_exc_error;

2699: l_api_message := 'Insert_PAC_eamBalAcct error';
2700: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMCOST_PUB', 'Insert_PAC_eamBalAcct('
2701: ||TO_CHAR(l_stmt_num)
2702: ||'): ', l_api_message);
2703: RAISE FND_API.g_exc_error;
2704:
2705: END IF;
2706: End If;
2707:

Line 2722: IF FND_API.to_Boolean(p_commit) THEN

2718: || '): PO/REQ Cost Calc completed successfully');
2719: END IF;
2720:
2721: -- Standard check of p_commit
2722: IF FND_API.to_Boolean(p_commit) THEN
2723: COMMIT WORK;
2724: END IF;
2725:
2726: -- Standard Call to get message count and if count = 1, get message info

Line 2741: WHEN FND_API.G_EXC_ERROR THEN

2737: END IF;
2738:
2739: EXCEPTION
2740:
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: ROLLBACK TO Compute_PAC_JobEstimates_PUB;
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744:
2745: -- statement level logging

Line 2743: x_return_status := FND_API.G_RET_STS_ERROR;

2739: EXCEPTION
2740:
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: ROLLBACK TO Compute_PAC_JobEstimates_PUB;
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744:
2745: -- statement level logging
2746: IF (l_uLog) THEN
2747: FND_LOG.STRING(

Line 2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2753: -- Get message count and data
2754: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
2755: p_data => x_msg_data);
2756:
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: ROLLBACK TO Compute_PAC_JobEstimates_PUB;
2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2760:
2761: -- statement level logging

Line 2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2755: p_data => x_msg_data);
2756:
2757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2758: ROLLBACK TO Compute_PAC_JobEstimates_PUB;
2759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2760:
2761: -- statement level logging
2762: IF (l_uLog) THEN
2763: FND_LOG.STRING(

Line 2775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2771: p_data => x_msg_data);
2772:
2773: WHEN OTHERS THEN
2774: ROLLBACK TO Compute_PAC_JobEstimates_PUB;
2775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2776:
2777: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
2779: l_api_name,

Line 2835: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

2831: --
2832: -- Pre-reqs : None.
2833: -- Parameters :
2834: -- IN : p_api_version IN NUMBER Required
2835: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2836: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2837: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2838: -- p_legal_entity_id IN NUMBER
2839: -- p_cost_group_id IN NUMBER

Line 2836: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

2832: -- Pre-reqs : None.
2833: -- Parameters :
2834: -- IN : p_api_version IN NUMBER Required
2835: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2836: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2837: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2838: -- p_legal_entity_id IN NUMBER
2839: -- p_cost_group_id IN NUMBER
2840: -- p_cost_type_id IN NUMBER

Line 2837: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

2833: -- Parameters :
2834: -- IN : p_api_version IN NUMBER Required
2835: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2836: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2837: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
2838: -- p_legal_entity_id IN NUMBER
2839: -- p_cost_group_id IN NUMBER
2840: -- p_cost_type_id IN NUMBER
2841: -- p_period_id IN NUMBER Optional Default = null

Line 2907: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2903:
2904: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2905: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2906:
2907: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2908: l_msg_count NUMBER := 0;
2909: l_msg_data VARCHAR2(8000);
2910: l_stmt_num NUMBER;
2911: l_api_message VARCHAR2(1000);

Line 2925: l_open_period VARCHAR2(1) := FND_API.G_TRUE;

2921: l_period_id NUMBER;
2922: l_period_set_name VARCHAR2(15);
2923: l_period_name VARCHAR2(15);
2924: l_period_start_date DATE;
2925: l_open_period VARCHAR2(1) := FND_API.G_TRUE;
2926: l_maint_obj_id NUMBER;
2927: l_maint_obj_type NUMBER;
2928:
2929: /* Log Severities*/

Line 2966: IF NOT FND_API.Compatible_API_Call(l_api_version,

2962: SAVEPOINT InsertUpdate_PAC_eamPerBal_PUB;
2963:
2964:
2965: -- Standard call to check for call compatibility
2966: IF NOT FND_API.Compatible_API_Call(l_api_version,
2967: p_api_version,
2968: l_api_name,
2969: G_PKG_NAME ) THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2966: IF NOT FND_API.Compatible_API_Call(l_api_version,
2967: p_api_version,
2968: l_api_name,
2969: G_PKG_NAME ) THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END IF;
2972:
2973: -- Initialize message list if p_init_msg_list is set to TRUE
2974: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2974: IF FND_API.to_Boolean(p_init_msg_list) THEN

2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END IF;
2972:
2973: -- Initialize message list if p_init_msg_list is set to TRUE
2974: IF FND_API.to_Boolean(p_init_msg_list) THEN
2975: FND_MSG_PUB.initialize;
2976: END IF;
2977:
2978: -- Initialize API return status to success

Line 2979: x_return_status := FND_API.G_RET_STS_SUCCESS;

2975: FND_MSG_PUB.initialize;
2976: END IF;
2977:
2978: -- Initialize API return status to success
2979: x_return_status := FND_API.G_RET_STS_SUCCESS;
2980:
2981: l_stmt_num := 400;
2982:
2983: -------------------------------------------------------------------------------

Line 2992: RAISE FND_API.G_EXC_ERROR;

2988: IF (p_period_id is null OR p_period_id = 0)
2989: AND (p_period_set_name is null OR p_period_name is null) THEN
2990: l_msg_data := 'Must pass period id, or period set name and period name. '
2991: || 'Job id: ' || TO_CHAR(p_wip_entity_id);
2992: RAISE FND_API.G_EXC_ERROR;
2993: END IF;
2994:
2995:
2996: BEGIN

Line 3014: l_open_period := FND_API.G_FALSE;

3010: OR (period_set_name = p_period_set_name
3011: AND period_name = p_period_name));
3012: EXCEPTION
3013: WHEN NO_DATA_FOUND THEN -- no open period
3014: l_open_period := FND_API.G_FALSE;
3015: END;
3016:
3017: -- Get data from gl_periods if it is a future period.
3018: IF NOT FND_API.to_boolean(l_open_period) THEN

Line 3018: IF NOT FND_API.to_boolean(l_open_period) THEN

3014: l_open_period := FND_API.G_FALSE;
3015: END;
3016:
3017: -- Get data from gl_periods if it is a future period.
3018: IF NOT FND_API.to_boolean(l_open_period) THEN
3019: l_stmt_num := 410;
3020:
3021: l_period_set_name := p_period_set_name;
3022: l_period_name := p_period_name;

Line 3239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3235: p_login_id => p_login_id);
3236:
3237: l_stmt_num := 445;
3238:
3239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3240: l_api_message := 'insertupdate_PAC_assetperbal() returned error';
3241: l_msg_data := l_api_message;
3242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3243: l_api_name,

Line 3246: RAISE FND_API.G_EXC_ERROR;

3242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3243: l_api_name,
3244: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
3245: || SUBSTRB (SQLERRM , 1 , 240));
3246: RAISE FND_API.G_EXC_ERROR;
3247: END IF;
3248:
3249: -- Standard check of p_commit
3250: IF FND_API.to_Boolean(p_commit) THEN

Line 3250: IF FND_API.to_Boolean(p_commit) THEN

3246: RAISE FND_API.G_EXC_ERROR;
3247: END IF;
3248:
3249: -- Standard check of p_commit
3250: IF FND_API.to_Boolean(p_commit) THEN
3251: COMMIT WORK;
3252: END IF;
3253:
3254: -- Standard Call to get message count and if count = 1, get message info

Line 3269: WHEN FND_API.g_exc_error THEN

3265: END IF;
3266:
3267: EXCEPTION
3268:
3269: WHEN FND_API.g_exc_error THEN
3270: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272:
3273: IF (l_uLog) THEN

Line 3271: x_return_status := FND_API.G_RET_STS_ERROR;

3267: EXCEPTION
3268:
3269: WHEN FND_API.g_exc_error THEN
3270: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272:
3273: IF (l_uLog) THEN
3274: FND_LOG.STRING(
3275: FND_LOG.LEVEL_UNEXPECTED,

Line 3284: WHEN FND_API.g_exc_unexpected_error THEN

3280: -- Get message count and data
3281: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
3282: p_data => x_msg_data);
3283:
3284: WHEN FND_API.g_exc_unexpected_error THEN
3285: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3286: x_return_status := FND_API.g_ret_sts_unexp_error ;
3287:
3288: IF (l_uLog) THEN

Line 3286: x_return_status := FND_API.g_ret_sts_unexp_error ;

3282: p_data => x_msg_data);
3283:
3284: WHEN FND_API.g_exc_unexpected_error THEN
3285: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3286: x_return_status := FND_API.g_ret_sts_unexp_error ;
3287:
3288: IF (l_uLog) THEN
3289: FND_LOG.STRING(
3290: FND_LOG.LEVEL_UNEXPECTED,

Line 3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3297: p_data => x_msg_data);
3298:
3299: WHEN OTHERS THEN
3300: ROLLBACK TO InsertUpdate_PAC_eamPerBal_PUB;
3301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3302:
3303: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3305: l_api_name,

Line 3337: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

3333: --
3334: -- Pre-reqs : None.
3335: -- Parameters :
3336: -- IN : p_api_version IN NUMBER Required
3337: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
3338: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
3339: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
3340: -- p_legal_entity_id IN NUMBER,
3341: -- p_cost_group_id IN NUMBER,

Line 3338: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

3334: -- Pre-reqs : None.
3335: -- Parameters :
3336: -- IN : p_api_version IN NUMBER Required
3337: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
3338: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
3339: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
3340: -- p_legal_entity_id IN NUMBER,
3341: -- p_cost_group_id IN NUMBER,
3342: -- p_cost_type_id IN NUMBER,

Line 3339: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

3335: -- Parameters :
3336: -- IN : p_api_version IN NUMBER Required
3337: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
3338: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
3339: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
3340: -- p_legal_entity_id IN NUMBER,
3341: -- p_cost_group_id IN NUMBER,
3342: -- p_cost_type_id IN NUMBER,
3343: -- p_period_id IN NUMBER Default = null,

Line 3407: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3403:
3404: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
3405: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
3406:
3407: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3408: l_msg_count NUMBER := 0;
3409: l_msg_data VARCHAR2(8000);
3410: l_api_message VARCHAR2(1000);
3411:

Line 3453: IF NOT FND_API.Compatible_API_Call (l_api_version,

3449: -- Standard Start of API savepoint
3450: SAVEPOINT InsertUpdate_PAC_astPerBal_PUB;
3451:
3452: -- Standard call to check for call compatibility
3453: IF NOT FND_API.Compatible_API_Call (l_api_version,
3454: p_api_version,
3455: l_api_name,
3456: G_PKG_NAME ) THEN
3457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3453: IF NOT FND_API.Compatible_API_Call (l_api_version,
3454: p_api_version,
3455: l_api_name,
3456: G_PKG_NAME ) THEN
3457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3458: END IF;
3459:
3460: -- Initialize message list if p_init_msg_list is set to TRUE
3461: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3461: IF FND_API.to_Boolean(p_init_msg_list) THEN

3457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3458: END IF;
3459:
3460: -- Initialize message list if p_init_msg_list is set to TRUE
3461: IF FND_API.to_Boolean(p_init_msg_list) THEN
3462: FND_MSG_PUB.initialize;
3463: END IF;
3464:
3465: -- Initialize API return status to success

Line 3466: x_return_status := FND_API.G_RET_STS_SUCCESS;

3462: FND_MSG_PUB.initialize;
3463: END IF;
3464:
3465: -- Initialize API return status to success
3466: x_return_status := FND_API.G_RET_STS_SUCCESS;
3467:
3468: -- Check if records already exist for the asset
3469: SELECT count(*)
3470: INTO l_count

Line 3591: IF FND_API.to_Boolean(p_commit) THEN

3587:
3588: l_stmt_num := 525;
3589:
3590: -- Standard check of p_commit
3591: IF FND_API.to_Boolean(p_commit) THEN
3592: COMMIT WORK;
3593: END IF;
3594:
3595: -- Standard Call to get message count and if count = 1, get message info

Line 3610: WHEN FND_API.g_exc_error THEN

3606: END IF;
3607:
3608: EXCEPTION
3609:
3610: WHEN FND_API.g_exc_error THEN
3611: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3612: x_return_status := FND_API.G_RET_STS_ERROR;
3613:
3614: IF (l_uLog) THEN

Line 3612: x_return_status := FND_API.G_RET_STS_ERROR;

3608: EXCEPTION
3609:
3610: WHEN FND_API.g_exc_error THEN
3611: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3612: x_return_status := FND_API.G_RET_STS_ERROR;
3613:
3614: IF (l_uLog) THEN
3615: FND_LOG.STRING(
3616: FND_LOG.LEVEL_UNEXPECTED,

Line 3625: WHEN FND_API.g_exc_unexpected_error THEN

3621: -- Get message count and data
3622: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
3623: p_data => x_msg_data);
3624:
3625: WHEN FND_API.g_exc_unexpected_error THEN
3626: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3628:
3629: IF (l_uLog) THEN

Line 3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3623: p_data => x_msg_data);
3624:
3625: WHEN FND_API.g_exc_unexpected_error THEN
3626: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3628:
3629: IF (l_uLog) THEN
3630: FND_LOG.STRING(
3631: FND_LOG.LEVEL_UNEXPECTED,

Line 3642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3638: p_data => x_msg_data);
3639:
3640: WHEN OTHERS THEN
3641: ROLLBACK TO InsertUpdate_PAC_astPerBal_PUB;
3642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3643:
3644: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
3646: l_api_name,

Line 3686: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

3682: --
3683: -- Pre-reqs : None.
3684: -- Parameters :
3685: -- IN : p_api_version IN NUMBER Required
3686: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
3687: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
3688: -- p_validation_level IN NUMBER Optional Default =
3689: -- FND_API.G_VALID_LEVEL_FULL
3690: -- p_legal_entity_id IN NUMBER,

Line 3687: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

3683: -- Pre-reqs : None.
3684: -- Parameters :
3685: -- IN : p_api_version IN NUMBER Required
3686: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
3687: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
3688: -- p_validation_level IN NUMBER Optional Default =
3689: -- FND_API.G_VALID_LEVEL_FULL
3690: -- p_legal_entity_id IN NUMBER,
3691: -- p_cost_group_id IN NUMBER,

Line 3689: -- FND_API.G_VALID_LEVEL_FULL

3685: -- IN : p_api_version IN NUMBER Required
3686: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
3687: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
3688: -- p_validation_level IN NUMBER Optional Default =
3689: -- FND_API.G_VALID_LEVEL_FULL
3690: -- p_legal_entity_id IN NUMBER,
3691: -- p_cost_group_id IN NUMBER,
3692: -- p_cost_type_id IN NUMBER,
3693: -- p_period_id IN NUMBER Default = null,

Line 3751: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3747:
3748: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
3749: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
3750:
3751: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3752: l_msg_count NUMBER := 0;
3753: l_msg_data VARCHAR2(8000);
3754: l_api_message VARCHAR2(1000);
3755:

Line 3808: IF NOT FND_API.Compatible_API_Call (l_api_version,

3804: -- Standard Start of API savepoint
3805: SAVEPOINT Compute_PAC_JobActuals_PUB;
3806:
3807: -- Standard call to check for call compatibility
3808: IF NOT FND_API.Compatible_API_Call (l_api_version,
3809: p_api_version,
3810: l_api_name,
3811: G_PKG_NAME ) THEN
3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3808: IF NOT FND_API.Compatible_API_Call (l_api_version,
3809: p_api_version,
3810: l_api_name,
3811: G_PKG_NAME ) THEN
3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3813: END IF;
3814:
3815: -- Initialize message list if p_init_msg_list is set to TRUE
3816: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3816: IF FND_API.to_Boolean(p_init_msg_list) THEN

3812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3813: END IF;
3814:
3815: -- Initialize message list if p_init_msg_list is set to TRUE
3816: IF FND_API.to_Boolean(p_init_msg_list) THEN
3817: FND_MSG_PUB.initialize;
3818: END IF;
3819:
3820: -- Initialize API return status to success

Line 3821: x_return_status := FND_API.G_RET_STS_SUCCESS;

3817: FND_MSG_PUB.initialize;
3818: END IF;
3819:
3820: -- Initialize API return status to success
3821: x_return_status := FND_API.G_RET_STS_SUCCESS;
3822: l_stmt_num := 0;
3823:
3824: -- Get period details from period id
3825: SELECT cpp.PAC_PERIOD_ID,

Line 3852: RAISE FND_API.G_EXC_ERROR;

3848: l_msg_data := l_api_message;
3849: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3850: l_api_name,
3851: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
3852: RAISE FND_API.G_EXC_ERROR;
3853: END IF;
3854:
3855: -- Get the associated asset item
3856: CST_EAMCOST_PUB.GET_CHARGE_ASSET (

Line 3868: IF (L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

3864: x_msg_data => l_msg_data);
3865:
3866: l_stmt_num := 10;
3867:
3868: IF (L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
3869: l_api_message := 'CST_EAMCOST_PUB.GET_CHARGE_ASSET() returned error';
3870: l_msg_data := l_api_message;
3871: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3872: FND_MESSAGE.set_token('TEXT', 'CST_PacEamCost_GRP.Compute_PAC_JobActuals('

Line 3875: RAISE FND_API.G_EXC_ERROR;

3871: FND_MESSAGE.SET_NAME ('BOM', 'CST_API_MESSAGE');
3872: FND_MESSAGE.set_token('TEXT', 'CST_PacEamCost_GRP.Compute_PAC_JobActuals('
3873: || to_char(l_stmt_num) || '): '|| l_api_message);
3874: FND_MSG_PUB.ADD;
3875: RAISE FND_API.G_EXC_ERROR;
3876: END IF;
3877:
3878: -- statement level logging
3879: IF (l_sLog) THEN

Line 3919: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3915: x_maint_cost_cat => l_maint_cost_category);
3916:
3917: l_stmt_num := 20;
3918:
3919: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3920: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat returned error';
3921: l_msg_data := l_api_message;
3922: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3923: l_api_name,

Line 3925: RAISE FND_API.G_EXC_ERROR;

3921: l_msg_data := l_api_message;
3922: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3923: l_api_name,
3924: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
3925: RAISE FND_API.G_EXC_ERROR;
3926: END IF;
3927:
3928:
3929: -- Get direct item cost element

Line 3945: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

3941: x_cost_element_id => l_eam_cost_element);
3942:
3943: l_stmt_num := 25;
3944:
3945: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
3946: l_api_message := 'CST_EAMCOST_PUB.get_CostEle_for_DirectItem returned error';
3947: l_msg_data := l_api_message;
3948: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
3949: FND_MESSAGE.set_token('TEXT', 'CST_PacEamCost_GRP.Compute_PAC_JobActuals('

Line 3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3948: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
3949: FND_MESSAGE.set_token('TEXT', 'CST_PacEamCost_GRP.Compute_PAC_JobActuals('
3950: || to_char(l_stmt_num) || '): ' || l_api_message);
3951: FND_MSG_PUB.ADD;
3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3953: END IF;
3954:
3955: -- statement level logging
3956: IF (l_sLog) THEN

Line 3987: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3983: x_maint_cost_cat => l_maint_cost_category);
3984:
3985: l_stmt_num := 20;
3986:
3987: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3988: l_api_message := 'CST_EAMCOST_PUB.Get_MaintCostCat returned error';
3989: l_msg_data := l_api_message;
3990: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3991: l_api_name,

Line 3993: RAISE FND_API.G_EXC_ERROR;

3989: l_msg_data := l_api_message;
3990: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
3991: l_api_name,
3992: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
3993: RAISE FND_API.G_EXC_ERROR;
3994: END IF;
3995:
3996: -- Get eam cost element
3997: l_eam_cost_element := CST_EAMCOST_PUB.Get_eamCostElement(

Line 4010: RAISE FND_API.G_EXC_ERROR;

4006: l_msg_data := l_api_message;
4007: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,
4008: l_api_name,
4009: '(' || TO_CHAR(l_stmt_num) ||'): ' || l_api_message);
4010: RAISE FND_API.G_EXC_ERROR;
4011: END IF;
4012:
4013: -- statement level logging
4014: IF (l_sLog) THEN

Line 4055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4051: p_login_id => p_login_id);
4052:
4053: l_stmt_num := 35;
4054:
4055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4056: l_api_message := 'insertupdate_PAC_eamperbal() returned error';
4057: l_msg_data := l_api_message;
4058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4059: l_api_name,

Line 4062: RAISE FND_API.G_EXC_ERROR;

4058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4059: l_api_name,
4060: '(' || TO_CHAR(l_stmt_num) || '): ' || l_api_message
4061: || SUBSTRB (SQLERRM , 1 , 240));
4062: RAISE FND_API.G_EXC_ERROR;
4063: END IF;
4064:
4065: -- statement level logging
4066: IF (l_sLog) THEN

Line 4073: IF FND_API.to_Boolean(p_commit) THEN

4069: l_module || '.' || l_stmt_num,
4070: 'Insert/Update successful for Actuals');
4071: END IF;
4072:
4073: IF FND_API.to_Boolean(p_commit) THEN
4074: COMMIT WORK;
4075: END IF;
4076: l_stmt_num := 40;
4077:

Line 4093: WHEN FND_API.g_exc_error THEN

4089: END IF;
4090:
4091: EXCEPTION
4092:
4093: WHEN FND_API.g_exc_error THEN
4094: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4095: x_return_status := FND_API.G_RET_STS_ERROR;
4096:
4097: IF (l_uLog) THEN

Line 4095: x_return_status := FND_API.G_RET_STS_ERROR;

4091: EXCEPTION
4092:
4093: WHEN FND_API.g_exc_error THEN
4094: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4095: x_return_status := FND_API.G_RET_STS_ERROR;
4096:
4097: IF (l_uLog) THEN
4098: FND_LOG.STRING(
4099: FND_LOG.LEVEL_UNEXPECTED,

Line 4108: WHEN FND_API.g_exc_unexpected_error THEN

4104: -- Get message count and data
4105: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count,
4106: p_data => x_msg_data);
4107:
4108: WHEN FND_API.g_exc_unexpected_error THEN
4109: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4111:
4112: IF (l_uLog) THEN

Line 4110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4106: p_data => x_msg_data);
4107:
4108: WHEN FND_API.g_exc_unexpected_error THEN
4109: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4111:
4112: IF (l_uLog) THEN
4113: FND_LOG.STRING(
4114: FND_LOG.LEVEL_UNEXPECTED,

Line 4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4121: p_data => x_msg_data);
4122:
4123: WHEN OTHERS THEN
4124: ROLLBACK TO Compute_PAC_JobActuals_PUB;
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4126:
4127: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4128: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
4129: l_api_name,

Line 4293: IF NOT FND_API.Compatible_API_Call ( l_api_version,

4289: ')');
4290: end if;
4291:
4292: -- Standard call to check for call compatibility.
4293: IF NOT FND_API.Compatible_API_Call ( l_api_version,
4294: p_api_version,
4295: l_api_name ,
4296: 'CST_eamCost_PUB')
4297: THEN

Line 4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4294: p_api_version,
4295: l_api_name ,
4296: 'CST_eamCost_PUB')
4297: THEN
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.
4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4302: FND_MSG_PUB.initialize;

Line 4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4297: THEN
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.
4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4302: FND_MSG_PUB.initialize;
4303: END IF;
4304:
4305: l_stmt_num := 10;

Line 4308: x_return_status := FND_API.G_RET_STS_SUCCESS;

4304:
4305: l_stmt_num := 10;
4306:
4307: -- Initialize API return status to success
4308: x_return_status := FND_API.G_RET_STS_SUCCESS;
4309:
4310:
4311: /* Update the record if already exists else insert a new one */
4312:

Line 4402: IF FND_API.To_Boolean( p_commit ) THEN

4398: );
4399: end if;
4400:
4401: -- Standard check of p_commit.
4402: IF FND_API.To_Boolean( p_commit ) THEN
4403: COMMIT WORK;
4404: END IF;
4405:
4406:

Line 4424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4420: );
4421:
4422: EXCEPTION
4423:
4424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4425: ROLLBACK TO Insert_PAC_eamBalAcct_PUB;
4426:
4427: IF (l_uLog) THEN
4428: FND_LOG.STRING(

Line 4435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4431: l_full_name ||'('|| l_stmt_num ||') :' || SUBSTRB (SQLERRM , 1 , 240)
4432: );
4433: END IF;
4434:
4435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4436: FND_MSG_PUB.Count_And_Get
4437: ( p_count => x_msg_count ,
4438: p_data => x_msg_data
4439: );

Line 4442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4438: p_data => x_msg_data
4439: );
4440: WHEN OTHERS THEN
4441: ROLLBACK TO Insert_PAC_eamBalAcct_PUB;
4442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4443:
4444: IF (l_uLog) THEN
4445: FND_LOG.STRING(
4446: FND_LOG.LEVEL_UNEXPECTED,

Line 4525: IF NOT FND_API.Compatible_API_Call (l_api_version,

4521: BEGIN
4522: -- Standard Start of API savepoint
4523: SAVEPOINT Delete_PAC_eamBalAcct_PUB;
4524: -- Standard call to check for call compatibility.
4525: IF NOT FND_API.Compatible_API_Call (l_api_version,
4526: p_api_version,
4527: l_api_name ,
4528: 'CST_eamCost_PUB')
4529: THEN

Line 4530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4526: p_api_version,
4527: l_api_name ,
4528: 'CST_eamCost_PUB')
4529: THEN
4530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4531: END IF;
4532: -- Initialize message list if p_init_msg_list is set to TRUE.
4533: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4534: FND_MSG_PUB.initialize;

Line 4533: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4529: THEN
4530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4531: END IF;
4532: -- Initialize message list if p_init_msg_list is set to TRUE.
4533: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4534: FND_MSG_PUB.initialize;
4535: END IF;
4536:
4537: if( l_pLog ) then

Line 4545: x_return_status := FND_API.G_RET_STS_SUCCESS;

4541: end if;
4542:
4543:
4544: -- Initialize API return status to success
4545: x_return_status := FND_API.G_RET_STS_SUCCESS;
4546:
4547: l_stmt_num := 10;
4548:
4549: /* Delete data from CST_PAC_EAM_BALANCE_BY_ACCTS */

Line 4559: IF FND_API.To_Boolean( p_commit ) THEN

4555: and cost_group_id = p_cost_group_id
4556: and cost_type_id = p_cost_type_id;
4557:
4558: -- Standard check of p_commit.
4559: IF FND_API.To_Boolean( p_commit ) THEN
4560: COMMIT WORK;
4561: END IF;
4562:
4563: /* Procedure level log message for Exit point */

Line 4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4576: );
4577:
4578: EXCEPTION
4579:
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: ROLLBACK TO Delete_PAC_eamBalAcct_PUB;
4582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4583:
4584: IF (l_uLog) THEN

Line 4582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4578: EXCEPTION
4579:
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: ROLLBACK TO Delete_PAC_eamBalAcct_PUB;
4582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4583:
4584: IF (l_uLog) THEN
4585: FND_LOG.STRING(
4586: FND_LOG.LEVEL_UNEXPECTED,

Line 4598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4594: p_data => x_msg_data
4595: );
4596: WHEN OTHERS THEN
4597: ROLLBACK TO Delete_PAC_eamBalAcct_PUB;
4598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4599:
4600: IF (l_uLog) THEN
4601: FND_LOG.STRING(
4602: FND_LOG.LEVEL_UNEXPECTED,