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 273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 282: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 332: RAISE FND_API.g_exc_error;

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

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

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

Line 361: raise FND_API.g_exc_error;

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

Line 426: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 436: p_encoded => FND_API.G_FALSE

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

Line 441: WHEN FND_API.G_EXC_ERROR THEN

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

Line 443: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 447: p_encoded => FND_API.G_FALSE

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

Line 450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 456: p_encoded => FND_API.G_FALSE

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

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 469: p_encoded => FND_API.G_FALSE

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 651: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 660: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 665: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 974: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 983: p_encoded => FND_API.G_FALSE

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

Line 988: WHEN FND_API.G_EXC_ERROR THEN

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

Line 990: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 994: p_encoded => FND_API.G_FALSE

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

Line 997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1003: p_encoded => FND_API.G_FALSE

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

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1016: p_encoded => FND_API.G_FALSE

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

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

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

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

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

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

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