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

Line 42: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)

38: --
39: --
40: -- Parameters :
41: -- IN : p_api_version NUMBER Require
42: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
43: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
44: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
45: -- OUT : x_return_status VARCHAR2(1)
46: -- x_msg_count NUMBER

Line 43: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)

39: --
40: -- Parameters :
41: -- IN : p_api_version NUMBER Require
42: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
43: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
44: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
45: -- OUT : x_return_status VARCHAR2(1)
46: -- x_msg_count NUMBER
47: -- x_msg_data VARCHAR2(2000)

Line 44: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)

40: -- Parameters :
41: -- IN : p_api_version NUMBER Require
42: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
43: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
44: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
45: -- OUT : x_return_status VARCHAR2(1)
46: -- x_msg_count NUMBER
47: -- x_msg_data VARCHAR2(2000)
48: -- IN : p_srp_subledger srp_subledger_rec_type Required

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

57: -- End of comments
58:
59: PROCEDURE update_srp_subledger
60: ( p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
64:
65: x_return_status OUT NOCOPY VARCHAR2,

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

58:
59: PROCEDURE update_srp_subledger
60: ( p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,

Line 63: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

59: PROCEDURE update_srp_subledger
60: ( p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62: p_commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,

Line 275: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

271: -- Standard Start of API savepoint
272: SAVEPOINT update_srp_subledger;
273:
274: -- Standard call to check for call compatibility.
275: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
276: p_api_version ,
277: l_api_name ,
278: G_PKG_NAME )
279: THEN

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: p_api_version ,
277: l_api_name ,
278: G_PKG_NAME )
279: THEN
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: -- Initialize message list if p_init_msg_list is set to TRUE.
284: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 284: IF FND_API.to_Boolean( p_init_msg_list ) THEN

280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: -- Initialize message list if p_init_msg_list is set to TRUE.
284: IF FND_API.to_Boolean( p_init_msg_list ) THEN
285: FND_MSG_PUB.initialize;
286: END IF;
287:
288: -- Initialize API return status to success

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: FND_MSG_PUB.initialize;
286: END IF;
287:
288: -- Initialize API return status to success
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
293: 'cn.plsql.cn_calc_subledger_pvt.update_srp_subledger.begin',

Line 334: RAISE FND_API.g_exc_error;

330: FETCH bonus_cr INTO l_earnings;
331: CLOSE bonus_cr;
332: ELSE
333: -- wrong calc_type, raise an error
334: RAISE FND_API.g_exc_error;
335: END IF;
336:
337: -- clku, 2655685, change cn_quotas to cn_quotas_all
338: -- to handle the deleted PE

Line 360: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

356: x_msg_data => l_msg_data,
357: p_del_srp_prd_rec => l_delta_subledger,
358: x_loading_status => l_loading_status
359: );
360: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
361: cn_message_pkg.debug('Exception occurs in cn_srp_periods_pvt.update_delta_srp_periods:');
362: cn_message_pkg.debug(l_msg_data);
363: raise FND_API.g_exc_error;
364: end if;

Line 363: raise FND_API.g_exc_error;

359: );
360: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
361: cn_message_pkg.debug('Exception occurs in cn_srp_periods_pvt.update_delta_srp_periods:');
362: cn_message_pkg.debug(l_msg_data);
363: raise FND_API.g_exc_error;
364: end if;
365:
366: if sync_needed = false then
367: sync_needed := true;

Line 428: IF FND_API.To_Boolean( p_commit ) THEN

424: 'End of update_srp_subledger ...');
425: end if;
426:
427: -- Standard check of p_commit.
428: IF FND_API.To_Boolean( p_commit ) THEN
429: COMMIT WORK;
430: END IF;
431:
432: cn_message_pkg.debug('Finish updating payment subledgers ');

Line 438: p_encoded => FND_API.G_FALSE

434: -- Standard call to get message count and if count is 1, get message info.
435: FND_MSG_PUB.Count_And_Get
436: ( p_count => x_msg_count ,
437: p_data => x_msg_data ,
438: p_encoded => FND_API.G_FALSE
439: );
440:
441: EXCEPTION
442:

Line 443: WHEN FND_API.G_EXC_ERROR THEN

439: );
440:
441: EXCEPTION
442:
443: WHEN FND_API.G_EXC_ERROR THEN
444: ROLLBACK TO update_srp_subledger;
445: x_return_status := FND_API.G_RET_STS_ERROR ;
446: FND_MSG_PUB.Count_And_Get
447: (p_count => x_msg_count ,

Line 445: x_return_status := FND_API.G_RET_STS_ERROR ;

441: EXCEPTION
442:
443: WHEN FND_API.G_EXC_ERROR THEN
444: ROLLBACK TO update_srp_subledger;
445: x_return_status := FND_API.G_RET_STS_ERROR ;
446: FND_MSG_PUB.Count_And_Get
447: (p_count => x_msg_count ,
448: p_data => x_msg_data ,
449: p_encoded => FND_API.G_FALSE

Line 449: p_encoded => FND_API.G_FALSE

445: x_return_status := FND_API.G_RET_STS_ERROR ;
446: FND_MSG_PUB.Count_And_Get
447: (p_count => x_msg_count ,
448: p_data => x_msg_data ,
449: p_encoded => FND_API.G_FALSE
450: );
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: ROLLBACK TO update_srp_subledger;

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448: p_data => x_msg_data ,
449: p_encoded => FND_API.G_FALSE
450: );
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: ROLLBACK TO update_srp_subledger;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: FND_MSG_PUB.Count_And_Get
456: (p_count => x_msg_count ,

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

450: );
451:
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: ROLLBACK TO update_srp_subledger;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: FND_MSG_PUB.Count_And_Get
456: (p_count => x_msg_count ,
457: p_data => x_msg_data ,
458: p_encoded => FND_API.G_FALSE

Line 458: p_encoded => FND_API.G_FALSE

454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455: FND_MSG_PUB.Count_And_Get
456: (p_count => x_msg_count ,
457: p_data => x_msg_data ,
458: p_encoded => FND_API.G_FALSE
459: );
460:
461: WHEN OTHERS THEN
462: ROLLBACK TO update_srp_subledger;

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

459: );
460:
461: WHEN OTHERS THEN
462: ROLLBACK TO update_srp_subledger;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
464: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
467: END IF;

Line 471: p_encoded => FND_API.G_FALSE

467: END IF;
468: FND_MSG_PUB.Count_And_Get
469: (p_count => x_msg_count ,
470: p_data => x_msg_data ,
471: p_encoded => FND_API.G_FALSE
472: );
473:
474: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
475: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 496: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)

492: --
493: --
494: -- Parameters :
495: -- IN : p_api_version NUMBER Require
496: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
497: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
498: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
499: -- OUT : x_return_status VARCHAR2(1)
500: -- x_msg_count NUMBER

Line 497: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)

493: --
494: -- Parameters :
495: -- IN : p_api_version NUMBER Require
496: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
497: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
498: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
499: -- OUT : x_return_status VARCHAR2(1)
500: -- x_msg_count NUMBER
501: -- x_msg_data VARCHAR2(2000)

Line 498: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)

494: -- Parameters :
495: -- IN : p_api_version NUMBER Require
496: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
497: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
498: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
499: -- OUT : x_return_status VARCHAR2(1)
500: -- x_msg_count NUMBER
501: -- x_msg_data VARCHAR2(2000)
502: -- IN : p_srp_pe_subledger srp_pe_subledger_rec_type Require

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

511: -- End of comments
512:
513: PROCEDURE update_srp_pe_subledger
514: ( p_api_version IN NUMBER,
515: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
517: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
518:
519: x_return_status OUT NOCOPY VARCHAR2,

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

512:
513: PROCEDURE update_srp_pe_subledger
514: ( p_api_version IN NUMBER,
515: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
517: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
518:
519: x_return_status OUT NOCOPY VARCHAR2,
520: x_msg_count OUT NOCOPY NUMBER,

Line 517: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

513: PROCEDURE update_srp_pe_subledger
514: ( p_api_version IN NUMBER,
515: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
516: p_commit IN VARCHAR2 := FND_API.G_FALSE,
517: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
518:
519: x_return_status OUT NOCOPY VARCHAR2,
520: x_msg_count OUT NOCOPY NUMBER,
521: x_msg_data OUT NOCOPY VARCHAR2,

Line 653: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

649: -- Standard Start of API savepoint
650: SAVEPOINT update_srp_pe_subledger;
651:
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
654: p_api_version ,
655: l_api_name ,
656: G_PKG_NAME )
657: THEN

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654: p_api_version ,
655: l_api_name ,
656: G_PKG_NAME )
657: THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: -- Initialize message list if p_init_msg_list is set to TRUE.
662: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 662: IF FND_API.to_Boolean( p_init_msg_list ) THEN

658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: -- Initialize message list if p_init_msg_list is set to TRUE.
662: IF FND_API.to_Boolean( p_init_msg_list ) THEN
663: FND_MSG_PUB.initialize;
664: END IF;
665:
666: -- Initialize API return status to success

Line 667: x_return_status := FND_API.G_RET_STS_SUCCESS;

663: FND_MSG_PUB.initialize;
664: END IF;
665:
666: -- Initialize API return status to success
667: x_return_status := FND_API.G_RET_STS_SUCCESS;
668:
669: -- Codes start here
670: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
671: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 976: IF FND_API.To_Boolean( p_commit ) THEN

972: 'End of update_srp_pe_subledger ...');
973: end if;
974:
975: -- Standard check of p_commit.
976: IF FND_API.To_Boolean( p_commit ) THEN
977: COMMIT WORK;
978: END IF;
979:
980:

Line 985: p_encoded => FND_API.G_FALSE

981: -- Standard call to get message count and if count is 1, get message info.
982: FND_MSG_PUB.Count_And_Get
983: ( p_count => x_msg_count ,
984: p_data => x_msg_data ,
985: p_encoded => FND_API.G_FALSE
986: );
987: cn_message_pkg.debug('Finish updating calculation subledgers ');
988: EXCEPTION
989:

Line 990: WHEN FND_API.G_EXC_ERROR THEN

986: );
987: cn_message_pkg.debug('Finish updating calculation subledgers ');
988: EXCEPTION
989:
990: WHEN FND_API.G_EXC_ERROR THEN
991: ROLLBACK TO update_srp_pe_subledger;
992: x_return_status := FND_API.G_RET_STS_ERROR ;
993: FND_MSG_PUB.Count_And_Get
994: (p_count => x_msg_count ,

Line 992: x_return_status := FND_API.G_RET_STS_ERROR ;

988: EXCEPTION
989:
990: WHEN FND_API.G_EXC_ERROR THEN
991: ROLLBACK TO update_srp_pe_subledger;
992: x_return_status := FND_API.G_RET_STS_ERROR ;
993: FND_MSG_PUB.Count_And_Get
994: (p_count => x_msg_count ,
995: p_data => x_msg_data ,
996: p_encoded => FND_API.G_FALSE

Line 996: p_encoded => FND_API.G_FALSE

992: x_return_status := FND_API.G_RET_STS_ERROR ;
993: FND_MSG_PUB.Count_And_Get
994: (p_count => x_msg_count ,
995: p_data => x_msg_data ,
996: p_encoded => FND_API.G_FALSE
997: );
998:
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: ROLLBACK TO update_srp_pe_subledger;

Line 999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

995: p_data => x_msg_data ,
996: p_encoded => FND_API.G_FALSE
997: );
998:
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: ROLLBACK TO update_srp_pe_subledger;
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,

Line 1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

997: );
998:
999: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1000: ROLLBACK TO update_srp_pe_subledger;
1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,
1004: p_data => x_msg_data ,
1005: p_encoded => FND_API.G_FALSE

Line 1005: p_encoded => FND_API.G_FALSE

1001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count ,
1004: p_data => x_msg_data ,
1005: p_encoded => FND_API.G_FALSE
1006: );
1007:
1008: WHEN OTHERS THEN
1009: ROLLBACK TO update_srp_pe_subledger;

Line 1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1006: );
1007:
1008: WHEN OTHERS THEN
1009: ROLLBACK TO update_srp_pe_subledger;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1012: THEN
1013: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1014: END IF;

Line 1018: p_encoded => FND_API.G_FALSE

1014: END IF;
1015: FND_MSG_PUB.Count_And_Get
1016: (p_count => x_msg_count ,
1017: p_data => x_msg_data ,
1018: p_encoded => FND_API.G_FALSE
1019: );
1020:
1021: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1022: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

1033:
1034:
1035: PROCEDURE post_je_batch
1036: ( p_api_version IN NUMBER,
1037: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1038: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1039: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
1040:
1041: x_return_status OUT NOCOPY VARCHAR2,

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

1034:
1035: PROCEDURE post_je_batch
1036: ( p_api_version IN NUMBER,
1037: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1038: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1039: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
1040:
1041: x_return_status OUT NOCOPY VARCHAR2,
1042: x_msg_count OUT NOCOPY NUMBER,

Line 1039: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

1035: PROCEDURE post_je_batch
1036: ( p_api_version IN NUMBER,
1037: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1038: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1039: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
1040:
1041: x_return_status OUT NOCOPY VARCHAR2,
1042: x_msg_count OUT NOCOPY NUMBER,
1043: x_msg_data OUT NOCOPY VARCHAR2,