DBA Data[Home] [Help]

APPS.FUN_BAL_UTILS_GRP dependencies on FND_MSG_PUB

Line 114: FND_MSG_PUB.initialize;

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:
117: -- Initialize API return status to success
118: x_status := FND_API.G_RET_STS_SUCCESS;

Line 163: FND_MSG_PUB.Add;

159: IF NOT(l_inter_txn) AND NOT(l_intra_txn)
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

Line 232: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

228:
229: END IF;
230:
231: -- Standard call to get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
233: p_data => x_msg_data);
234:
235: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
236: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.end', 'end');

Line 250: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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
254: THEN

Line 263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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
267: THEN

Line 275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

271: 'fun.plsql.fun_bal_utils_grp.get_inter_intra_account.unexpected_error_others',
272: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
273: END IF;
274:
275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
278: END IF;
279:

Line 277: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);

273: END IF;
274:
275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_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,

Line 281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
285:

Line 512: FND_MSG_PUB.initialize;

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:
515: -- Initialize API return status to success
516: x_status := FND_API.G_RET_STS_SUCCESS;

Line 521: FND_MSG_PUB.Add;

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');
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

Line 610: FND_MSG_PUB.Add;

606: END IF;
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

Line 784: FND_MSG_PUB.Add;

780:
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;

Line 847: FND_MSG_PUB.Add;

843:
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;

Line 972: FND_MSG_PUB.Add;

968:
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:

Line 993: FND_MSG_PUB.Add;

989:
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;

Line 1016: FND_MSG_PUB.Add;

1012:
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;

Line 1025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1021: END IF;
1022: END IF;
1023:
1024: -- Standard call to get message count and if count is 1, get message info.
1025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:
1028: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.end', 'end');

Line 1044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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:
1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1048: THEN

Line 1057: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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
1061: THEN

Line 1069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1065: 'fun.plsql.fun_bal_utils_grp.get_intercompany_account.unexpected_error_others',
1066: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1067: END IF;
1068:
1069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1070: THEN
1071: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
1072: END IF;
1073:

Line 1071: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);

1067: END IF;
1068:
1069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_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:

Line 1076: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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:
1079: END get_intercompany_account;
1080:

Line 1249: FND_MSG_PUB.initialize;

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:
1252: -- Initialize API return status to success
1253: x_status := FND_API.G_RET_STS_SUCCESS;

Line 1287: FND_MSG_PUB.Add;

1283:
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

Line 1444: FND_MSG_PUB.Add;

1440:
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)

Line 1464: FND_MSG_PUB.Add;

1460:
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;

Line 1486: FND_MSG_PUB.Add;

1482:
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;

Line 1493: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1489: l_check_ccid := 0;
1490: END IF;
1491:
1492: -- Standard call to get message count and if count is 1, get message info.
1493: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1494: p_data => x_msg_data);
1495:
1496: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
1497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.end', 'end');

Line 1511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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
1515: THEN

Line 1524: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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
1528: THEN

Line 1536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1532: 'fun.plsql.fun_bal_utils_grp.Get_Intracompany_Account.unexpected_error_others',
1533: SUBSTR(SQLCODE ||' : ' || SQLERRM,1, 4000));
1534: END IF;
1535:
1536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1537: THEN
1538: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);
1539: END IF;
1540:

Line 1538: FND_MSG_PUB.Add_Exc_Msg(g_package_name, l_api_name);

1534: END IF;
1535:
1536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_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,

Line 1542: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
1546: