DBA Data[Home] [Help]

APPS.AS_FOUNDATION_PVT dependencies on FND_MESSAGE

Line 32: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');

28: or (p_col_choice is NOT NULL and p_col_name is NULL)
29: then
30: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
31: then
32: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
33: fnd_msg_pub.add;
34: end if;
35: raise fnd_api.g_exc_error;
36: end if;

Line 45: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');

41: -- only one digit
42: then
43: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
44: then
45: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
46: fnd_message.set_token('PARAM',p_col_choice, false);
47: fnd_msg_pub.add;
48: end if;
49: raise fnd_api.g_exc_error;

Line 46: fnd_message.set_token('PARAM',p_col_choice, false);

42: then
43: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
44: then
45: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
46: fnd_message.set_token('PARAM',p_col_choice, false);
47: fnd_msg_pub.add;
48: end if;
49: raise fnd_api.g_exc_error;
50: return '';

Line 68: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');

64: return(l_col_name || ' DESC, ');
65: else
66: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
67: then
68: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
69: fnd_message.set_token('PARAM',p_col_choice, false);
70: fnd_msg_pub.add;
71: end if;
72: raise fnd_api.g_exc_error;

Line 69: fnd_message.set_token('PARAM',p_col_choice, false);

65: else
66: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
67: then
68: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
69: fnd_message.set_token('PARAM',p_col_choice, false);
70: fnd_msg_pub.add;
71: end if;
72: raise fnd_api.g_exc_error;
73: return '';

Line 105: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');

101: G_PKG_NAME)
102: THEN
103: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
104: THEN
105: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
106: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
107: FND_MSG_PUB.ADD;
108: END IF;
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 106: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);

102: THEN
103: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
104: THEN
105: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
106: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
107: FND_MSG_PUB.ADD;
108: END IF;
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;

Line 132: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');

128: IF FND_GLOBAL.User_Id IS NULL
129: THEN
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
131: THEN
132: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
133: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
134: FND_MSG_PUB.ADD;
135: END IF;
136: END IF;

Line 133: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

129: THEN
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
131: THEN
132: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
133: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
134: FND_MSG_PUB.ADD;
135: END IF;
136: END IF;
137:

Line 329: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');

325: G_PKG_NAME)
326: THEN
327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
328: THEN
329: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
330: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
331: FND_MSG_PUB.ADD;
332: END IF;
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 330: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);

326: THEN
327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
328: THEN
329: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
330: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
331: FND_MSG_PUB.ADD;
332: END IF;
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;

Line 356: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');

352: IF FND_GLOBAL.User_Id IS NULL
353: THEN
354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
355: THEN
356: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
357: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
358: FND_MSG_PUB.ADD;
359: END IF;
360: END IF;

Line 357: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

353: THEN
354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
355: THEN
356: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
357: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
358: FND_MSG_PUB.ADD;
359: END IF;
360: END IF;
361:

Line 819: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');

815:
816: -- Success Message
817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
818: THEN
819: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
820: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
821: FND_MSG_PUB.Add;
822: END IF;
823:

Line 820: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);

816: -- Success Message
817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
818: THEN
819: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
820: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
821: FND_MSG_PUB.Add;
822: END IF;
823:
824:

Line 1098: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');

1094:
1095: -- Success Message
1096: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1097: THEN
1098: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1099: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1100: FND_MSG_PUB.Add;
1101: END IF;
1102:

Line 1099: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);

1095: -- Success Message
1096: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1097: THEN
1098: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1099: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1100: FND_MSG_PUB.Add;
1101: END IF;
1102:
1103:

Line 1257: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');

1253:
1254: -- Success Message
1255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1256: THEN
1257: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1258: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1259: FND_MSG_PUB.Add;
1260: END IF;
1261:

Line 1258: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);

1254: -- Success Message
1255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1256: THEN
1257: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1258: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1259: FND_MSG_PUB.Add;
1260: END IF;
1261:
1262: -- Debug Message

Line 1404: FND_MESSAGE.Set_Name('AS','FC_SEC_NO_LIST_PRICE');

1400: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1401: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_Info - Cannot find price');
1402: -- END IF;
1403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1404: FND_MESSAGE.Set_Name('AS','FC_SEC_NO_LIST_PRICE');
1405: FND_MSG_PUB.ADD;
1406: END IF;
1407: l_price := NULL;
1408: -- close l_secondary_price_csr;

Line 1417: FND_MESSAGE.Set_Name('AS','API_UNEXP_ERROR_IN_PROCESSING');

1413: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1414: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_Info - Wrong Parameter');
1415: -- END IF;
1416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1417: FND_MESSAGE.Set_Name('AS','API_UNEXP_ERROR_IN_PROCESSING');
1418: FND_MESSAGE.Set_Token('ROW','AS_FOUNDATION');
1419: FND_MSG_PUB.ADD;
1420: END IF;
1421: raise FND_API.G_EXC_ERROR;

Line 1418: FND_MESSAGE.Set_Token('ROW','AS_FOUNDATION');

1414: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_Info - Wrong Parameter');
1415: -- END IF;
1416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1417: FND_MESSAGE.Set_Name('AS','API_UNEXP_ERROR_IN_PROCESSING');
1418: FND_MESSAGE.Set_Token('ROW','AS_FOUNDATION');
1419: FND_MSG_PUB.ADD;
1420: END IF;
1421: raise FND_API.G_EXC_ERROR;
1422: END IF;

Line 1428: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');

1424: x_price := l_price;
1425: -- Success Message
1426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1427: THEN
1428: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1429: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1430: FND_MSG_PUB.Add;
1431: END IF;
1432:

Line 1429: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);

1425: -- Success Message
1426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1427: THEN
1428: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1429: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1430: FND_MSG_PUB.Add;
1431: END IF;
1432:
1433: -- Debug Message

Line 1645: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

1641: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1642: -- dbms_output.put_line('AS_FOUNDATION_PVT - Price : Not Found');
1643: -- END IF;
1644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1645: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1646: FND_MESSAGE.Set_Token('COLUMN','Price', FALSE);
1647: FND_MSG_PUB.ADD;
1648: END IF;
1649: raise FND_API.G_EXC_ERROR;

Line 1646: FND_MESSAGE.Set_Token('COLUMN','Price', FALSE);

1642: -- dbms_output.put_line('AS_FOUNDATION_PVT - Price : Not Found');
1643: -- END IF;
1644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1645: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1646: FND_MESSAGE.Set_Token('COLUMN','Price', FALSE);
1647: FND_MSG_PUB.ADD;
1648: END IF;
1649: raise FND_API.G_EXC_ERROR;
1650: END IF;

Line 1691: FND_MESSAGE.Set_Name('AS', 'API_EXCEED_MARGIN');

1687: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1688: -- dbms_output.put_line('AS_FOUNDATION_PVT - Validate volume, amount : Exceeds Margin');
1689: -- END IF;
1690: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1691: FND_MESSAGE.Set_Name('AS', 'API_EXCEED_MARGIN');
1692: FND_MSG_PUB.ADD;
1693: END IF;
1694: raise FND_API.G_EXC_ERROR;
1695: END IF;

Line 1713: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');

1709: x_price_list_id := l_price_list_id;
1710: x_price := l_price;
1711: -- Success Message
1712: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1713: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1714: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1715: FND_MSG_PUB.Add;
1716: END IF;
1717:

Line 1714: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);

1710: x_price := l_price;
1711: -- Success Message
1712: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1713: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
1714: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
1715: FND_MSG_PUB.Add;
1716: END IF;
1717:
1718: -- Debug Message

Line 1861: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);

1857: BEGIN
1858: FOR l_count in 1..p_message_count LOOP
1859:
1860: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
1861: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
1862: OPEN Get_Appl_Id (l_appl_short_name);
1863: FETCH Get_Appl_Id into l_id;
1864: CLOSE Get_Appl_Id;
1865: