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

Line 64: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

60: -- Previous version 1.0
61: -- Initial version 1.0
62: ------------------------------------------------------------------------------*/
63: PROCEDURE get_inter_intra_account (p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
65: p_ledger_id IN NUMBER,
66: p_to_ledger_id IN NUMBER,
67: p_from_bsv IN VARCHAR2,
68: p_to_bsv IN VARCHAR2,

Line 103: IF NOT FND_API.Compatible_API_Call ( l_api_version,

99: 'begin');
100: END IF;
101:
102: -- Standard call to check for call compatibility.
103: IF NOT FND_API.Compatible_API_Call ( l_api_version,
104: p_api_version,
105: l_api_name,
106: g_package_name )
107: THEN

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: p_api_version,
105: l_api_name,
106: g_package_name )
107: THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )

Line 112: IF FND_API.to_Boolean( p_init_msg_list )

108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list )
113: THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:

Line 118: x_status := FND_API.G_RET_STS_SUCCESS;

114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- Initialize API return status to success
118: x_status := FND_API.G_RET_STS_SUCCESS;
119:
120: OPEN c_get_le_id (p_ledger_id => p_ledger_id,
121: p_bsv => p_from_bsv,
122: p_gl_date => p_gl_date);

Line 164: x_status := FND_API.G_RET_STS_ERROR;

160: THEN
161: -- This is an error situation
162: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTER_BSV_NOT_ASSIGNED');
163: FND_MSG_PUB.Add;
164: x_status := FND_API.G_RET_STS_ERROR;
165: END IF;
166:
167: IF l_inter_txn
168: THEN

Line 240: WHEN FND_API.G_EXC_ERROR

236: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.end', 'end');
237: END IF;
238:
239: EXCEPTION
240: WHEN FND_API.G_EXC_ERROR
241: THEN
242: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
243: THEN
244: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 249: x_status := FND_API.G_RET_STS_ERROR ;

245: 'fun.plsql.fun_bal_pkg.get_inter_intra_account.error',
246: SUBSTR(SQLERRM,1, 4000));
247: END IF;
248:
249: x_status := FND_API.G_RET_STS_ERROR ;
250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
251: p_data => x_msg_data);
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

249: x_status := FND_API.G_RET_STS_ERROR ;
250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
251: p_data => x_msg_data);
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
254: THEN
255: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
256: THEN
257: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 262: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

258: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.unexpected_error_norm',
259: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
260: END IF;
261:
262: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
264: p_data => x_msg_data);
265:
266: WHEN OTHERS

Line 280: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276: THEN
277: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
278: END IF;
279:
280: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
282: p_data => x_msg_data);
283:
284: END get_inter_intra_account;

Line 501: IF NOT FND_API.Compatible_API_Call ( l_api_version,

497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.begin', 'begin');
498: END IF;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call ( l_api_version,
502: p_api_version,
503: l_api_name,
504: g_package_name )
505: THEN

Line 506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502: p_api_version,
503: l_api_name,
504: g_package_name )
505: THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: -- Initialize message list if p_init_msg_list is set to TRUE.
510: IF FND_API.to_Boolean( p_init_msg_list )

Line 510: IF FND_API.to_Boolean( p_init_msg_list )

506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509: -- Initialize message list if p_init_msg_list is set to TRUE.
510: IF FND_API.to_Boolean( p_init_msg_list )
511: THEN
512: FND_MSG_PUB.initialize;
513: END IF;
514:

Line 516: x_status := FND_API.G_RET_STS_SUCCESS;

512: FND_MSG_PUB.initialize;
513: END IF;
514:
515: -- Initialize API return status to success
516: x_status := FND_API.G_RET_STS_SUCCESS;
517:
518: IF p_from_le IS NULL OR p_to_le IS NULL
519: THEN
520: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTER_BSV_NOT_ASSIGNED');

Line 522: x_status := FND_API.G_RET_STS_ERROR;

518: IF p_from_le IS NULL OR p_to_le IS NULL
519: THEN
520: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTER_BSV_NOT_ASSIGNED');
521: FND_MSG_PUB.Add;
522: x_status := FND_API.G_RET_STS_ERROR;
523: END IF;
524:
525: IF x_status = FND_API.G_RET_STS_SUCCESS
526: THEN

Line 525: IF x_status = FND_API.G_RET_STS_SUCCESS

521: FND_MSG_PUB.Add;
522: x_status := FND_API.G_RET_STS_ERROR;
523: END IF;
524:
525: IF x_status = FND_API.G_RET_STS_SUCCESS
526: THEN
527: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
528: THEN
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 611: x_status := FND_API.G_RET_STS_ERROR;

607: FND_MESSAGE.SET_TOKEN('FROM_LE_ID', l_from_le_name);
608: FND_MESSAGE.SET_TOKEN('TO_LE_ID', l_to_le_name);
609:
610: FND_MSG_PUB.Add;
611: x_status := FND_API.G_RET_STS_ERROR;
612: END IF;
613:
614: IF (x_status = FND_API.G_RET_STS_SUCCESS) THEN
615:

Line 614: IF (x_status = FND_API.G_RET_STS_SUCCESS) THEN

610: FND_MSG_PUB.Add;
611: x_status := FND_API.G_RET_STS_ERROR;
612: END IF;
613:
614: IF (x_status = FND_API.G_RET_STS_SUCCESS) THEN
615:
616: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
617: THEN
618: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 785: x_status := FND_API.G_RET_STS_ERROR;

781: IF (l_check_ccid = 0)
782: THEN
783: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_VALID');
784: FND_MSG_PUB.Add;
785: x_status := FND_API.G_RET_STS_ERROR;
786:
787: ELSE
788: l_check_ccid := 0;
789: END IF;

Line 848: x_status := FND_API.G_RET_STS_ERROR;

844: IF (l_check_ccid = 0)
845: THEN
846: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_VALID');
847: FND_MSG_PUB.Add;
848: x_status := FND_API.G_RET_STS_ERROR;
849:
850: ELSE
851: l_check_ccid := 0;
852: END IF;

Line 973: x_status := FND_API.G_RET_STS_ERROR;

969: IF Nvl(x_ccid,0) <= 0
970: THEN
971: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_CREATED');
972: FND_MSG_PUB.Add;
973: x_status := FND_API.G_RET_STS_ERROR;
974:
975: END IF;
976:
977: SELECT count(1)

Line 994: x_status := FND_API.G_RET_STS_ERROR;

990: IF (l_check_ccid = 0)
991: THEN
992: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_VALID');
993: FND_MSG_PUB.Add;
994: x_status := FND_API.G_RET_STS_ERROR;
995:
996: ELSE
997: l_check_ccid := 0;
998: END IF;

Line 1017: x_status := FND_API.G_RET_STS_ERROR;

1013: IF (l_check_ccid = 0)
1014: THEN
1015: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_VALID');
1016: FND_MSG_PUB.Add;
1017: x_status := FND_API.G_RET_STS_ERROR;
1018:
1019: ELSE
1020: l_check_ccid := 0;
1021: END IF;

Line 1033: WHEN FND_API.G_EXC_ERROR

1029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.end', 'end');
1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR
1034: THEN
1035: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1036: THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 1042: x_status := FND_API.G_RET_STS_ERROR ;

1038: 'fun.plsql.fun_bal_pkg.get_intercompany_account.error',
1039: SUBSTR(SQLERRM,1, 4000));
1040: END IF;
1041:
1042: x_status := FND_API.G_RET_STS_ERROR ;
1043:
1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1045: p_data => x_msg_data);
1046:

Line 1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1043:
1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1045: p_data => x_msg_data);
1046:
1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1048: THEN
1049: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1050: THEN
1051: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 1056: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1052: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.unexpected_error_norm',
1053: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1054: END IF;
1055:
1056: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1057: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1058: p_data => x_msg_data);
1059:
1060: WHEN OTHERS

Line 1074: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1070: THEN
1071: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
1072: END IF;
1073:
1074: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075:
1076: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1077: p_data => x_msg_data);
1078:

Line 1238: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.begin', 'begin');
1235: END IF;
1236:
1237: -- Standard call to check for call compatibility.
1238: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1239: p_api_version,
1240: l_api_name,
1241: g_package_name )
1242: THEN

Line 1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1239: p_api_version,
1240: l_api_name,
1241: g_package_name )
1242: THEN
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: END IF;
1245:
1246: -- Initialize message list if p_init_msg_list is set to TRUE.
1247: IF FND_API.to_Boolean( p_init_msg_list )

Line 1247: IF FND_API.to_Boolean( p_init_msg_list )

1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: END IF;
1245:
1246: -- Initialize message list if p_init_msg_list is set to TRUE.
1247: IF FND_API.to_Boolean( p_init_msg_list )
1248: THEN
1249: FND_MSG_PUB.initialize;
1250: END IF;
1251:

Line 1253: x_status := FND_API.G_RET_STS_SUCCESS;

1249: FND_MSG_PUB.initialize;
1250: END IF;
1251:
1252: -- Initialize API return status to success
1253: x_status := FND_API.G_RET_STS_SUCCESS;
1254:
1255: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1257: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_template',

Line 1288: x_status := FND_API.G_RET_STS_ERROR;

1284: IF l_template_id IS NULL
1285: THEN
1286: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_RULE_NOT_ASSIGNED');
1287: FND_MSG_PUB.Add;
1288: x_status := FND_API.G_RET_STS_ERROR;
1289: END IF;
1290:
1291: IF x_status = FND_API.G_RET_STS_SUCCESS
1292: THEN

Line 1291: IF x_status = FND_API.G_RET_STS_SUCCESS

1287: FND_MSG_PUB.Add;
1288: x_status := FND_API.G_RET_STS_ERROR;
1289: END IF;
1290:
1291: IF x_status = FND_API.G_RET_STS_SUCCESS
1292: THEN
1293: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1295: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_ccid',

Line 1445: x_status := FND_API.G_RET_STS_ERROR;

1441: IF Nvl(x_ccid,0) <= 0
1442: THEN
1443: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_CREATED');
1444: FND_MSG_PUB.Add;
1445: x_status := FND_API.G_RET_STS_ERROR;
1446: END IF;
1447:
1448: SELECT count(1)
1449: INTO l_check_ccid

Line 1465: x_status := FND_API.G_RET_STS_ERROR;

1461: IF (l_check_ccid = 0)
1462: THEN
1463: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_VALID');
1464: FND_MSG_PUB.Add;
1465: x_status := FND_API.G_RET_STS_ERROR;
1466: ELSE
1467: l_check_ccid := 0;
1468: END IF;
1469:

Line 1487: x_status := FND_API.G_RET_STS_ERROR;

1483: IF (l_check_ccid = 0)
1484: THEN
1485: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_VALID');
1486: FND_MSG_PUB.Add;
1487: x_status := FND_API.G_RET_STS_ERROR;
1488: ELSE
1489: l_check_ccid := 0;
1490: END IF;
1491:

Line 1501: WHEN FND_API.G_EXC_ERROR

1497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.end', 'end');
1498: END IF;
1499:
1500: EXCEPTION
1501: WHEN FND_API.G_EXC_ERROR
1502: THEN
1503: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1504: THEN
1505: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 1510: x_status := FND_API.G_RET_STS_ERROR ;

1506: 'fun.plsql.fun_bal_pkg.Get_Intracompany_Account.error',
1507: SUBSTR(SQLERRM,1, 4000));
1508: END IF;
1509:
1510: x_status := FND_API.G_RET_STS_ERROR ;
1511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1512: p_data => x_msg_data);
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1510: x_status := FND_API.G_RET_STS_ERROR ;
1511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1512: p_data => x_msg_data);
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1515: THEN
1516: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1517: THEN
1518: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 1523: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1519: 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.unexpected_error_norm',
1520: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1521: END IF;
1522:
1523: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1524: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1525: p_data => x_msg_data);
1526:
1527: WHEN OTHERS

Line 1541: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1537: THEN
1538: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
1539: END IF;
1540:
1541: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1542: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1543: p_data => x_msg_data);
1544:
1545: END get_intracompany_account;