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 3015: l_open_period := FND_API.G_FALSE;

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

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

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

Line 3240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3247: RAISE FND_API.G_EXC_ERROR;

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

Line 3251: IF FND_API.to_Boolean(p_commit) THEN

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

Line 3270: WHEN FND_API.g_exc_error THEN

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

Line 3272: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3285: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 3287: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

Line 3302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

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

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

Line 3454: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

Line 3458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3462: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 3467: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3592: IF FND_API.to_Boolean(p_commit) THEN

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

Line 3611: WHEN FND_API.g_exc_error THEN

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

Line 3613: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3626: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 3628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

Line 3690: -- FND_API.G_VALID_LEVEL_FULL

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

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

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

Line 3809: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

Line 3813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3817: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 3822: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3853: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 3876: RAISE FND_API.G_EXC_ERROR;

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

Line 3920: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3926: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 3953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3988: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3994: RAISE FND_API.G_EXC_ERROR;

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

Line 4011: RAISE FND_API.G_EXC_ERROR;

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

Line 4056: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 4063: RAISE FND_API.G_EXC_ERROR;

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

Line 4074: IF FND_API.to_Boolean(p_commit) THEN

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

Line 4094: WHEN FND_API.g_exc_error THEN

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

Line 4096: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4109: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 4111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4294: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 4299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4302: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 4309: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4403: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 4425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4526: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

Line 4531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4534: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 4546: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4560: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 4581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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