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 4744: cn_utils.appendcr(body_code, ' x_return_status := fnd_api.g_ret_sts_success; ');

4740: cn_utils.appindcr(body_code, ' l_rate_tier_id NUMBER;');
4741: cn_utils.appindcr(body_code, ' l_tier_split NUMBER;');
4742: cn_utils.appindcr(body_code, ' l_amount NUMBER; ');
4743: cn_utils.appendcr(body_code, 'BEGIN');
4744: cn_utils.appendcr(body_code, ' x_return_status := fnd_api.g_ret_sts_success; ');
4745:
4746: OPEN input;
4747: FETCH input INTO l_calc_sql_exp_id;
4748: CLOSE input;

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

4797: cn_utils.appindcr(body_code, 'EXCEPTION ' );
4798: cn_utils.appindcr(body_code, ' when zero_divide then ');
4799: cn_utils.appindcr(body_code, ' x_return_status := ''Z''; ');
4800: cn_utils.appindcr(body_code, ' when others then ');
4801: cn_utils.appindcr(body_code, ' x_return_status := fnd_api.g_ret_sts_error; ');
4802: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
4803: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4804: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_estimated_payout.exception'', ');
4805: cn_utils.appindcr(body_code, ' sqlerrm); ');

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

4996: -- spool the code to a file and get it compiled against the database.
4997: --
4998: -- Parameters :
4999: -- IN : p_api_version NUMBER Require
5000: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
5001: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
5002: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
5003: -- OUT : x_return_status VARCHAR2(1)
5004: -- x_msg_count NUMBER

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

4997: --
4998: -- Parameters :
4999: -- IN : p_api_version NUMBER Require
5000: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
5001: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
5002: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
5003: -- OUT : x_return_status VARCHAR2(1)
5004: -- x_msg_count NUMBER
5005: -- x_msg_data VARCHAR2(2000)

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

4998: -- Parameters :
4999: -- IN : p_api_version NUMBER Require
5000: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
5001: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
5002: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
5003: -- OUT : x_return_status VARCHAR2(1)
5004: -- x_msg_count NUMBER
5005: -- x_msg_data VARCHAR2(2000)
5006: -- IN : p_formula_id NUMBER(15) Require

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

5015: --
5016: -- End of comments
5017: PROCEDURE generate_formula
5018: ( p_api_version IN NUMBER,
5019: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5020: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5021: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
5022: x_return_status OUT NOCOPY VARCHAR2,
5023: x_msg_count OUT NOCOPY NUMBER,

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

5016: -- End of comments
5017: PROCEDURE generate_formula
5018: ( p_api_version IN NUMBER,
5019: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5020: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5021: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
5022: x_return_status OUT NOCOPY VARCHAR2,
5023: x_msg_count OUT NOCOPY NUMBER,
5024: x_msg_data OUT NOCOPY VARCHAR2,

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

5017: PROCEDURE generate_formula
5018: ( p_api_version IN NUMBER,
5019: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5020: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5021: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
5022: x_return_status OUT NOCOPY VARCHAR2,
5023: x_msg_count OUT NOCOPY NUMBER,
5024: x_msg_data OUT NOCOPY VARCHAR2,
5025: p_formula_id IN NUMBER,

Line 5115: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

5111: RETURN;
5112: END IF;
5113:
5114: -- Standard call to check for call compatibility.
5115: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5116: p_api_version ,
5117: l_api_name ,
5118: G_PKG_NAME )
5119: THEN

Line 5120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5116: p_api_version ,
5117: l_api_name ,
5118: G_PKG_NAME )
5119: THEN
5120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5121: END IF;
5122:
5123: -- Initialize message list if p_init_msg_list is set to TRUE.
5124: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 5124: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5121: END IF;
5122:
5123: -- Initialize message list if p_init_msg_list is set to TRUE.
5124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5125: FND_MSG_PUB.initialize;
5126: END IF;
5127:
5128: -- Initialize API return status to success

Line 5129: x_return_status := FND_API.G_RET_STS_SUCCESS;

5125: FND_MSG_PUB.initialize;
5126: END IF;
5127:
5128: -- Initialize API return status to success
5129: x_return_status := FND_API.G_RET_STS_SUCCESS;
5130:
5131:
5132: -- Codes start here
5133:

Line 5225: x_return_status := FND_API.g_ret_sts_error;

5221: SET formula_status = 'INCOMPLETE'
5222: WHERE calc_formula_id = p_formula_id
5223: AND org_id = g_org_id;
5224:
5225: x_return_status := FND_API.g_ret_sts_error;
5226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5227: THEN
5228: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5229: FND_MSG_PUB.ADD;

Line 5257: x_return_status := FND_API.g_ret_sts_error;

5253: SET formula_status = 'INCOMPLETE'
5254: WHERE calc_formula_id = p_formula_id
5255: AND org_id = g_org_id;
5256:
5257: x_return_status := FND_API.g_ret_sts_error;
5258:
5259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5260: THEN
5261: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');

Line 5275: IF FND_API.To_Boolean( p_commit ) THEN

5271: 'End of generate_formula');
5272: end if;
5273:
5274: -- Standard check of p_commit.
5275: IF FND_API.To_Boolean( p_commit ) THEN
5276: COMMIT WORK;
5277: END IF;
5278:
5279: -- Standard call to get message count and if count is 1, get message info.

Line 5283: p_encoded => FND_API.G_FALSE

5279: -- Standard call to get message count and if count is 1, get message info.
5280: FND_MSG_PUB.Count_And_Get
5281: ( p_count => x_msg_count ,
5282: p_data => x_msg_data ,
5283: p_encoded => FND_API.G_FALSE
5284: );
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: ROLLBACK TO generate_formula;

Line 5286: WHEN FND_API.G_EXC_ERROR THEN

5282: p_data => x_msg_data ,
5283: p_encoded => FND_API.G_FALSE
5284: );
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: ROLLBACK TO generate_formula;
5288: x_return_status := FND_API.G_RET_STS_ERROR ;
5289: FND_MSG_PUB.Count_And_Get
5290: (p_count => x_msg_count ,

Line 5288: x_return_status := FND_API.G_RET_STS_ERROR ;

5284: );
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: ROLLBACK TO generate_formula;
5288: x_return_status := FND_API.G_RET_STS_ERROR ;
5289: FND_MSG_PUB.Count_And_Get
5290: (p_count => x_msg_count ,
5291: p_data => x_msg_data ,
5292: p_encoded => FND_API.G_FALSE

Line 5292: p_encoded => FND_API.G_FALSE

5288: x_return_status := FND_API.G_RET_STS_ERROR ;
5289: FND_MSG_PUB.Count_And_Get
5290: (p_count => x_msg_count ,
5291: p_data => x_msg_data ,
5292: p_encoded => FND_API.G_FALSE
5293: );
5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5295: ROLLBACK TO generate_formula;
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5290: (p_count => x_msg_count ,
5291: p_data => x_msg_data ,
5292: p_encoded => FND_API.G_FALSE
5293: );
5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5295: ROLLBACK TO generate_formula;
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5297: FND_MSG_PUB.Count_And_Get
5298: (p_count => x_msg_count ,

Line 5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5292: p_encoded => FND_API.G_FALSE
5293: );
5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5295: ROLLBACK TO generate_formula;
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5297: FND_MSG_PUB.Count_And_Get
5298: (p_count => x_msg_count ,
5299: p_data => x_msg_data ,
5300: p_encoded => FND_API.G_FALSE

Line 5300: p_encoded => FND_API.G_FALSE

5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5297: FND_MSG_PUB.Count_And_Get
5298: (p_count => x_msg_count ,
5299: p_data => x_msg_data ,
5300: p_encoded => FND_API.G_FALSE
5301: );
5302: WHEN OTHERS THEN
5303: ROLLBACK TO generate_formula;
5304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5300: p_encoded => FND_API.G_FALSE
5301: );
5302: WHEN OTHERS THEN
5303: ROLLBACK TO generate_formula;
5304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5306: THEN
5307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5308: END IF;

Line 5312: p_encoded => FND_API.G_FALSE

5308: END IF;
5309: FND_MSG_PUB.Count_And_Get
5310: (p_count => x_msg_count ,
5311: p_data => x_msg_data ,
5312: p_encoded => FND_API.G_FALSE
5313: );
5314:
5315: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5316: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,