DBA Data[Home] [Help]

APPS.PA_MASS_ADDITIONS_CREATE_PKG dependencies on FND_API

Line 162: p_init_msg_list IN varchar2 default FND_API.G_FALSE,

158: -- Procedure: Insert_Mass
159: -- Purpose : Generate assets for project adjustments
160: --
161: PROCEDURE Insert_Mass( p_api_version IN number,
162: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
163: p_commit IN varchar2 default FND_API.G_FALSE,
164: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
165: x_return_status OUT NOCOPY varchar2,
166: x_msg_count OUT NOCOPY number,

Line 163: p_commit IN varchar2 default FND_API.G_FALSE,

159: -- Purpose : Generate assets for project adjustments
160: --
161: PROCEDURE Insert_Mass( p_api_version IN number,
162: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
163: p_commit IN varchar2 default FND_API.G_FALSE,
164: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
165: x_return_status OUT NOCOPY varchar2,
166: x_msg_count OUT NOCOPY number,
167: x_msg_data OUT NOCOPY varchar2,

Line 164: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

160: --
161: PROCEDURE Insert_Mass( p_api_version IN number,
162: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
163: p_commit IN varchar2 default FND_API.G_FALSE,
164: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
165: x_return_status OUT NOCOPY varchar2,
166: x_msg_count OUT NOCOPY number,
167: x_msg_data OUT NOCOPY varchar2,
168: x_count OUT NOCOPY number,

Line 194: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

190: l_count number;
191: l_api_name CONSTANT varchar2(100) := 'PA INSERT_MASS';
192: l_msg_count number ;
193: l_msg_data varchar2(2000) ;
194: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
195: l_assets_tracking_flag varchar2(1) ;
196: --
197: -- Bug 5532231 R12.PJ:XB3:QA:APL:PREPARE MASS ADDITIONS SHOWS DUPLICATE ROWS
198: -- line type lookup code is populated null for item type lines.

Line 343: IF NOT FND_API.Compatible_API_Call( G_api_version,

339: G_debug_mode := NVL(G_debug_mode, 'N');
340:
341: write_to_log(FND_LOG.LEVEL_STATEMENT, '10:PA Insert_mass', '*** 10 : ORACLE PROJECTS INSERT MASS PROCESSING ***') ;
342: -- Standrad call to check API compatibility.
343: IF NOT FND_API.Compatible_API_Call( G_api_version,
344: p_api_version,
345: 'INSERT_MASS',
346: G_pkg_name) THEN
347:

Line 348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

344: p_api_version,
345: 'INSERT_MASS',
346: G_pkg_name) THEN
347:
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
349: END IF ;
350:
351: -- Initialize message list if p_init_msg_list is set to TRUE
352: --

Line 353: IF FND_API.to_boolean( p_init_msg_list) THEN

349: END IF ;
350:
351: -- Initialize message list if p_init_msg_list is set to TRUE
352: --
353: IF FND_API.to_boolean( p_init_msg_list) THEN
354: FND_MSG_PUB.initialize ;
355: END IF ;
356: -- Initialize API return status to success.
357: --

Line 358: l_return_status := FND_API.G_RET_STS_SUCCESS ;

354: FND_MSG_PUB.initialize ;
355: END IF ;
356: -- Initialize API return status to success.
357: --
358: l_return_status := FND_API.G_RET_STS_SUCCESS ;
359: write_to_log(FND_LOG.LEVEL_STATEMENT, '10:PA Insert_mass', 'INSERT MASS Processing begins.') ;
360:
361: write_to_log(FND_LOG.LEVEL_STATEMENT, '10:PA Insert_mass', 'Calling Insert_Receipts processing.') ;
362:

Line 821: p_init_msg_list IN varchar2 default FND_API.G_FALSE,

817: -- Procedure will Insert Discount related to distributions that are tracked
818: -- as asset in FA_MASS_ADDITIONS_GT table
819: --
820: PROCEDURE Insert_Discounts(p_api_version IN number,
821: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
822: p_commit IN varchar2 default FND_API.G_FALSE,
823: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
824: x_return_status OUT NOCOPY varchar2,
825: x_msg_count OUT NOCOPY number,

Line 822: p_commit IN varchar2 default FND_API.G_FALSE,

818: -- as asset in FA_MASS_ADDITIONS_GT table
819: --
820: PROCEDURE Insert_Discounts(p_api_version IN number,
821: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
822: p_commit IN varchar2 default FND_API.G_FALSE,
823: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
824: x_return_status OUT NOCOPY varchar2,
825: x_msg_count OUT NOCOPY number,
826: x_msg_data OUT NOCOPY varchar2,

Line 823: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

819: --
820: PROCEDURE Insert_Discounts(p_api_version IN number,
821: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
822: p_commit IN varchar2 default FND_API.G_FALSE,
823: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
824: x_return_status OUT NOCOPY varchar2,
825: x_msg_count OUT NOCOPY number,
826: x_msg_data OUT NOCOPY varchar2,
827: x_count OUT NOCOPY number,

Line 853: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

849: l_dummy number ;
850:
851: l_msg_count number ;
852: l_msg_data varchar2(2000) ;
853: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
854: l_assets_tracking_flag varchar2(1) ;
855: --
856: -- Bug 5532231 R12.PJ:XB3:QA:APL:PREPARE MASS ADDITIONS SHOWS DUPLICATE ROWS
857: -- line type lookup code was changed to DISCOUNTS

Line 1000: IF NOT FND_API.Compatible_API_Call( G_api_version,

996: fnd_profile.get('PA_DEBUG_MODE',G_debug_mode);
997: G_debug_mode := NVL(G_debug_mode, 'N');
998:
999: -- Standrad call to check API compatibility.
1000: IF NOT FND_API.Compatible_API_Call( G_api_version,
1001: p_api_version,
1002: 'INSERT_DISCOUNTS',
1003: G_pkg_name) THEN
1004:

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1001: p_api_version,
1002: 'INSERT_DISCOUNTS',
1003: G_pkg_name) THEN
1004:
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1006: END IF ;
1007:
1008: -- Initialize message list if p_init_msg_list is set to TRUE
1009: --

Line 1010: IF FND_API.to_boolean( p_init_msg_list) THEN

1006: END IF ;
1007:
1008: -- Initialize message list if p_init_msg_list is set to TRUE
1009: --
1010: IF FND_API.to_boolean( p_init_msg_list) THEN
1011:
1012: FND_MSG_PUB.initialize ;
1013:
1014: END IF ;

Line 1018: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1014: END IF ;
1015:
1016: -- Initialize API return status to success.
1017: --
1018: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1019: write_to_log(FND_LOG.LEVEL_STATEMENT, '40:INSERT_DISCOUNTS', 'Begin discount processing.') ;
1020:
1021: write_to_log(FND_LOG.LEVEL_STATEMENT, '40:INSERT_DISCOUNTS', 'Begin Main LOOP.') ;
1022: open c_apinv ;

Line 1428: l_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1424: x_return_status := l_return_status ;
1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: write_to_log(FND_LOG.LEVEL_STATEMENT, '40:INSERT_DISCOUNTS', 'EXCEPTION:'||SQLERRM) ;
1428: l_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1429: APP_EXCEPTION.RAISE_EXCEPTION;
1430: END Insert_Discounts;
1431:
1432: -- Start of comments

Line 1445: p_init_msg_list IN varchar2 default FND_API.G_FALSE,

1441: --
1442: -- Code hook called from AP mass addition Program.
1443: --
1444: PROCEDURE update_mass (p_api_version IN number,
1445: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
1446: p_commit IN varchar2 default FND_API.G_FALSE,
1447: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
1448: x_return_status OUT NOCOPY varchar2,
1449: x_msg_count OUT NOCOPY number,

Line 1446: p_commit IN varchar2 default FND_API.G_FALSE,

1442: -- Code hook called from AP mass addition Program.
1443: --
1444: PROCEDURE update_mass (p_api_version IN number,
1445: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
1446: p_commit IN varchar2 default FND_API.G_FALSE,
1447: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
1448: x_return_status OUT NOCOPY varchar2,
1449: x_msg_count OUT NOCOPY number,
1450: x_msg_data OUT NOCOPY varchar2,

Line 1447: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

1443: --
1444: PROCEDURE update_mass (p_api_version IN number,
1445: p_init_msg_list IN varchar2 default FND_API.G_FALSE,
1446: p_commit IN varchar2 default FND_API.G_FALSE,
1447: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
1448: x_return_status OUT NOCOPY varchar2,
1449: x_msg_count OUT NOCOPY number,
1450: x_msg_data OUT NOCOPY varchar2,
1451: p_request_id IN number ) is

Line 1455: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;

1451: p_request_id IN number ) is
1452:
1453: l_msg_count number ;
1454: l_msg_data varchar2(2000) ;
1455: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
1456:
1457: BEGIN
1458:
1459: fnd_profile.get('PA_DEBUG_MODE',G_debug_mode);

Line 1463: IF NOT FND_API.Compatible_API_Call( G_api_version,

1459: fnd_profile.get('PA_DEBUG_MODE',G_debug_mode);
1460: G_debug_mode := NVL(G_debug_mode, 'N');
1461:
1462: -- Standrad call to check API compatibility.
1463: IF NOT FND_API.Compatible_API_Call( G_api_version,
1464: p_api_version,
1465: 'UPDATE_MASS',
1466: G_pkg_name) THEN
1467:

Line 1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1464: p_api_version,
1465: 'UPDATE_MASS',
1466: G_pkg_name) THEN
1467:
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1469: END IF ;
1470:
1471: -- Initialize message list if p_init_msg_list is set to TRUE
1472: --

Line 1473: IF FND_API.to_boolean( p_init_msg_list) THEN

1469: END IF ;
1470:
1471: -- Initialize message list if p_init_msg_list is set to TRUE
1472: --
1473: IF FND_API.to_boolean( p_init_msg_list) THEN
1474:
1475: FND_MSG_PUB.initialize ;
1476:
1477: END IF ;

Line 1481: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1477: END IF ;
1478:
1479: -- Initialize API return status to success.
1480: --
1481: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1482:
1483: IF (g_debug_mode = 'Y') THEN
1484: write_to_log(FND_LOG.LEVEL_STATEMENT,'50:UPDATE_MASS','UPDATE MASS Processing begins.') ;
1485: END IF;