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 62: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

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

Line 101: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 110: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 116: x_status := FND_API.G_RET_STS_SUCCESS;

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

Line 162: x_status := FND_API.G_RET_STS_ERROR;

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

Line 236: WHEN FND_API.G_EXC_ERROR

232: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.end', 'end');
233: END IF;
234:
235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR
237: THEN
238: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
239: THEN
240: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 245: x_status := FND_API.G_RET_STS_ERROR ;

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

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

245: x_status := FND_API.G_RET_STS_ERROR ;
246: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
247: p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
250: THEN
251: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
252: THEN
253: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 258: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 276: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

272: THEN
273: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
274: END IF;
275:
276: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
278: p_data => x_msg_data);
279:
280: END get_inter_intra_account;

Line 422: IF NOT FND_API.Compatible_API_Call ( l_api_version,

418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.begin', 'begin');
419: END IF;
420:
421: -- Standard call to check for call compatibility.
422: IF NOT FND_API.Compatible_API_Call ( l_api_version,
423: p_api_version,
424: l_api_name,
425: g_package_name )
426: THEN

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423: p_api_version,
424: l_api_name,
425: g_package_name )
426: THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.
431: IF FND_API.to_Boolean( p_init_msg_list )

Line 431: IF FND_API.to_Boolean( p_init_msg_list )

427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.
431: IF FND_API.to_Boolean( p_init_msg_list )
432: THEN
433: FND_MSG_PUB.initialize;
434: END IF;
435:

Line 437: x_status := FND_API.G_RET_STS_SUCCESS;

433: FND_MSG_PUB.initialize;
434: END IF;
435:
436: -- Initialize API return status to success
437: x_status := FND_API.G_RET_STS_SUCCESS;
438:
439: IF p_from_le IS NULL OR p_to_le IS NULL
440: THEN
441: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTER_BSV_NOT_ASSIGNED');

Line 443: x_status := FND_API.G_RET_STS_ERROR;

439: IF p_from_le IS NULL OR p_to_le IS NULL
440: THEN
441: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTER_BSV_NOT_ASSIGNED');
442: FND_MSG_PUB.Add;
443: x_status := FND_API.G_RET_STS_ERROR;
444: END IF;
445:
446: IF x_status = FND_API.G_RET_STS_SUCCESS
447: THEN

Line 446: IF x_status = FND_API.G_RET_STS_SUCCESS

442: FND_MSG_PUB.Add;
443: x_status := FND_API.G_RET_STS_ERROR;
444: END IF;
445:
446: IF x_status = FND_API.G_RET_STS_SUCCESS
447: THEN
448: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
449: THEN
450: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 709: x_status := FND_API.G_RET_STS_ERROR;

705: IF Nvl(x_ccid,0) <= 0
706: THEN
707: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_CREATED');
708: FND_MSG_PUB.Add;
709: x_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711:
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 721: WHEN FND_API.G_EXC_ERROR

717: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.end', 'end');
718: END IF;
719:
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR
722: THEN
723: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
724: THEN
725: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 730: x_status := FND_API.G_RET_STS_ERROR ;

726: 'fun.plsql.fun_bal_pkg.get_intercompany_account.error',
727: SUBSTR(SQLERRM,1, 4000));
728: END IF;
729:
730: x_status := FND_API.G_RET_STS_ERROR ;
731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
732: p_data => x_msg_data);
733:
734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

730: x_status := FND_API.G_RET_STS_ERROR ;
731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
732: p_data => x_msg_data);
733:
734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
735: THEN
736: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
737: THEN
738: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 743: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

739: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.unexpected_error_norm',
740: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
741: END IF;
742:
743: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
745: p_data => x_msg_data);
746:
747: WHEN OTHERS

Line 761: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

757: THEN
758: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
759: END IF;
760:
761: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
763: p_data => x_msg_data);
764:
765: END get_intercompany_account;

Line 922: IF NOT FND_API.Compatible_API_Call ( l_api_version,

918: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.begin', 'begin');
919: END IF;
920:
921: -- Standard call to check for call compatibility.
922: IF NOT FND_API.Compatible_API_Call ( l_api_version,
923: p_api_version,
924: l_api_name,
925: g_package_name )
926: THEN

Line 927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

923: p_api_version,
924: l_api_name,
925: g_package_name )
926: THEN
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929:
930: -- Initialize message list if p_init_msg_list is set to TRUE.
931: IF FND_API.to_Boolean( p_init_msg_list )

Line 931: IF FND_API.to_Boolean( p_init_msg_list )

927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929:
930: -- Initialize message list if p_init_msg_list is set to TRUE.
931: IF FND_API.to_Boolean( p_init_msg_list )
932: THEN
933: FND_MSG_PUB.initialize;
934: END IF;
935:

Line 937: x_status := FND_API.G_RET_STS_SUCCESS;

933: FND_MSG_PUB.initialize;
934: END IF;
935:
936: -- Initialize API return status to success
937: x_status := FND_API.G_RET_STS_SUCCESS;
938:
939: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
940: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
941: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_template',

Line 972: x_status := FND_API.G_RET_STS_ERROR;

968: IF l_template_id IS NULL
969: THEN
970: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_RULE_NOT_ASSIGNED');
971: FND_MSG_PUB.Add;
972: x_status := FND_API.G_RET_STS_ERROR;
973: END IF;
974:
975: IF x_status = FND_API.G_RET_STS_SUCCESS
976: THEN

Line 975: IF x_status = FND_API.G_RET_STS_SUCCESS

971: FND_MSG_PUB.Add;
972: x_status := FND_API.G_RET_STS_ERROR;
973: END IF;
974:
975: IF x_status = FND_API.G_RET_STS_SUCCESS
976: THEN
977: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
979: 'fun.plsql.fun_bal_utils_grp.get_intracompany_account.get_ccid',

Line 1096: x_status := FND_API.G_RET_STS_ERROR;

1092: IF Nvl(x_ccid,0) <= 0
1093: THEN
1094: FND_MESSAGE.SET_NAME('FUN', 'FUN_INTRA_CC_NOT_CREATED');
1095: FND_MSG_PUB.Add;
1096: x_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098:
1099: -- Standard call to get message count and if count is 1, get message info.
1100: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 1108: WHEN FND_API.G_EXC_ERROR

1104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.end', 'end');
1105: END IF;
1106:
1107: EXCEPTION
1108: WHEN FND_API.G_EXC_ERROR
1109: THEN
1110: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1111: THEN
1112: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 1117: x_status := FND_API.G_RET_STS_ERROR ;

1113: 'fun.plsql.fun_bal_pkg.Get_Intracompany_Account.error',
1114: SUBSTR(SQLERRM,1, 4000));
1115: END IF;
1116:
1117: x_status := FND_API.G_RET_STS_ERROR ;
1118: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1119: p_data => x_msg_data);
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1117: x_status := FND_API.G_RET_STS_ERROR ;
1118: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1119: p_data => x_msg_data);
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1122: THEN
1123: IF (FND_LOG.LEVEL_ERROR>= g_debug_level)
1124: THEN
1125: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,

Line 1130: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1126: 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.unexpected_error_norm',
1127: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1128: END IF;
1129:
1130: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1132: p_data => x_msg_data);
1133:
1134: WHEN OTHERS

Line 1148: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1144: THEN
1145: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
1146: END IF;
1147:
1148: x_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1149: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1150: p_data => x_msg_data);
1151:
1152: END get_intracompany_account;