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_FORMULA_GEN_PKG dependencies on FND_API

Line 4731: cn_utils.appendcr(body_code, ' x_return_status := fnd_api.g_ret_sts_success; ');

4727: cn_utils.appindcr(body_code, ' l_rate_tier_id NUMBER;');
4728: cn_utils.appindcr(body_code, ' l_tier_split NUMBER;');
4729: cn_utils.appindcr(body_code, ' l_amount NUMBER; ');
4730: cn_utils.appendcr(body_code, 'BEGIN');
4731: cn_utils.appendcr(body_code, ' x_return_status := fnd_api.g_ret_sts_success; ');
4732:
4733: OPEN input;
4734: FETCH input INTO l_calc_sql_exp_id;
4735: CLOSE input;

Line 4788: cn_utils.appindcr(body_code, ' x_return_status := fnd_api.g_ret_sts_error; ');

4784: cn_utils.appindcr(body_code, 'EXCEPTION ' );
4785: cn_utils.appindcr(body_code, ' when zero_divide then ');
4786: cn_utils.appindcr(body_code, ' x_return_status := ''Z''; ');
4787: cn_utils.appindcr(body_code, ' when others then ');
4788: cn_utils.appindcr(body_code, ' x_return_status := fnd_api.g_ret_sts_error; ');
4789: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
4790: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4791: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_estimated_payout.exception'', ');
4792: cn_utils.appindcr(body_code, ' sqlerrm); ');

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

4972: -- spool the code to a file and get it compiled against the database.
4973: --
4974: -- Parameters :
4975: -- IN : p_api_version NUMBER Require
4976: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
4977: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
4978: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
4979: -- OUT : x_return_status VARCHAR2(1)
4980: -- x_msg_count NUMBER

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

4973: --
4974: -- Parameters :
4975: -- IN : p_api_version NUMBER Require
4976: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
4977: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
4978: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
4979: -- OUT : x_return_status VARCHAR2(1)
4980: -- x_msg_count NUMBER
4981: -- x_msg_data VARCHAR2(2000)

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

4974: -- Parameters :
4975: -- IN : p_api_version NUMBER Require
4976: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
4977: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
4978: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
4979: -- OUT : x_return_status VARCHAR2(1)
4980: -- x_msg_count NUMBER
4981: -- x_msg_data VARCHAR2(2000)
4982: -- IN : p_formula_id NUMBER(15) Require

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

4991: --
4992: -- End of comments
4993: PROCEDURE generate_formula
4994: ( p_api_version IN NUMBER,
4995: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4996: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4997: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
4998: x_return_status OUT NOCOPY VARCHAR2,
4999: x_msg_count OUT NOCOPY NUMBER,

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

4992: -- End of comments
4993: PROCEDURE generate_formula
4994: ( p_api_version IN NUMBER,
4995: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4996: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4997: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
4998: x_return_status OUT NOCOPY VARCHAR2,
4999: x_msg_count OUT NOCOPY NUMBER,
5000: x_msg_data OUT NOCOPY VARCHAR2,

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

4993: PROCEDURE generate_formula
4994: ( p_api_version IN NUMBER,
4995: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4996: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4997: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
4998: x_return_status OUT NOCOPY VARCHAR2,
4999: x_msg_count OUT NOCOPY NUMBER,
5000: x_msg_data OUT NOCOPY VARCHAR2,
5001: p_formula_id IN NUMBER,

Line 5036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

5032: -- Standard Start of API savepoint
5033: SAVEPOINT generate_formula;
5034:
5035: -- Standard call to check for call compatibility.
5036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5037: p_api_version ,
5038: l_api_name ,
5039: G_PKG_NAME )
5040: THEN

Line 5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5037: p_api_version ,
5038: l_api_name ,
5039: G_PKG_NAME )
5040: THEN
5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END IF;
5043:
5044: -- Initialize message list if p_init_msg_list is set to TRUE.
5045: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 5045: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5042: END IF;
5043:
5044: -- Initialize message list if p_init_msg_list is set to TRUE.
5045: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5046: FND_MSG_PUB.initialize;
5047: END IF;
5048:
5049: -- Initialize API return status to success

Line 5050: x_return_status := FND_API.G_RET_STS_SUCCESS;

5046: FND_MSG_PUB.initialize;
5047: END IF;
5048:
5049: -- Initialize API return status to success
5050: x_return_status := FND_API.G_RET_STS_SUCCESS;
5051:
5052:
5053: -- Codes start here
5054:

Line 5142: x_return_status := FND_API.g_ret_sts_error;

5138: SET formula_status = 'INCOMPLETE'
5139: WHERE calc_formula_id = p_formula_id
5140: AND org_id = g_org_id;
5141:
5142: x_return_status := FND_API.g_ret_sts_error;
5143: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5144: THEN
5145: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5146: FND_MSG_PUB.ADD;

Line 5174: x_return_status := FND_API.g_ret_sts_error;

5170: SET formula_status = 'INCOMPLETE'
5171: WHERE calc_formula_id = p_formula_id
5172: AND org_id = g_org_id;
5173:
5174: x_return_status := FND_API.g_ret_sts_error;
5175:
5176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5177: THEN
5178: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');

Line 5192: IF FND_API.To_Boolean( p_commit ) THEN

5188: 'End of generate_formula');
5189: end if;
5190:
5191: -- Standard check of p_commit.
5192: IF FND_API.To_Boolean( p_commit ) THEN
5193: COMMIT WORK;
5194: END IF;
5195:
5196: -- Standard call to get message count and if count is 1, get message info.

Line 5200: p_encoded => FND_API.G_FALSE

5196: -- Standard call to get message count and if count is 1, get message info.
5197: FND_MSG_PUB.Count_And_Get
5198: ( p_count => x_msg_count ,
5199: p_data => x_msg_data ,
5200: p_encoded => FND_API.G_FALSE
5201: );
5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: ROLLBACK TO generate_formula;

Line 5203: WHEN FND_API.G_EXC_ERROR THEN

5199: p_data => x_msg_data ,
5200: p_encoded => FND_API.G_FALSE
5201: );
5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: ROLLBACK TO generate_formula;
5205: x_return_status := FND_API.G_RET_STS_ERROR ;
5206: FND_MSG_PUB.Count_And_Get
5207: (p_count => x_msg_count ,

Line 5205: x_return_status := FND_API.G_RET_STS_ERROR ;

5201: );
5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: ROLLBACK TO generate_formula;
5205: x_return_status := FND_API.G_RET_STS_ERROR ;
5206: FND_MSG_PUB.Count_And_Get
5207: (p_count => x_msg_count ,
5208: p_data => x_msg_data ,
5209: p_encoded => FND_API.G_FALSE

Line 5209: p_encoded => FND_API.G_FALSE

5205: x_return_status := FND_API.G_RET_STS_ERROR ;
5206: FND_MSG_PUB.Count_And_Get
5207: (p_count => x_msg_count ,
5208: p_data => x_msg_data ,
5209: p_encoded => FND_API.G_FALSE
5210: );
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: ROLLBACK TO generate_formula;
5213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5207: (p_count => x_msg_count ,
5208: p_data => x_msg_data ,
5209: p_encoded => FND_API.G_FALSE
5210: );
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: ROLLBACK TO generate_formula;
5213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5214: FND_MSG_PUB.Count_And_Get
5215: (p_count => x_msg_count ,

Line 5213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5209: p_encoded => FND_API.G_FALSE
5210: );
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: ROLLBACK TO generate_formula;
5213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5214: FND_MSG_PUB.Count_And_Get
5215: (p_count => x_msg_count ,
5216: p_data => x_msg_data ,
5217: p_encoded => FND_API.G_FALSE

Line 5217: p_encoded => FND_API.G_FALSE

5213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5214: FND_MSG_PUB.Count_And_Get
5215: (p_count => x_msg_count ,
5216: p_data => x_msg_data ,
5217: p_encoded => FND_API.G_FALSE
5218: );
5219: WHEN OTHERS THEN
5220: ROLLBACK TO generate_formula;
5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5217: p_encoded => FND_API.G_FALSE
5218: );
5219: WHEN OTHERS THEN
5220: ROLLBACK TO generate_formula;
5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5223: THEN
5224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5225: END IF;

Line 5229: p_encoded => FND_API.G_FALSE

5225: END IF;
5226: FND_MSG_PUB.Count_And_Get
5227: (p_count => x_msg_count ,
5228: p_data => x_msg_data ,
5229: p_encoded => FND_API.G_FALSE
5230: );
5231:
5232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5233: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,