DBA Data[Home] [Help]

APPS.AS_TCA_PVT dependencies on FND_MSG_PUB

Line 48: FND_MSG_PUB.initialize;

44:
45: -- initialize message list if p_init_msg_list is set to TRUE;
46:
47: IF FND_API.to_Boolean(p_init_msg_list) THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50:
51: l_return_status := FND_API.G_RET_STS_SUCCESS;
52: open C_Party_Exists(p_party_id);

Line 56: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

52: open C_Party_Exists(p_party_id);
53: fetch C_Party_Exists into l_val;
54: IF (C_Party_Exists%NOTFOUND) THEN
55: x_return_status := FND_API.G_RET_STS_ERROR;
56: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
57: THEN
58: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
59: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
60: FND_MESSAGE.Set_Token('VALUE',p_party_id,FALSE);

Line 61: FND_MSG_PUB.ADD;

57: THEN
58: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
59: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
60: FND_MESSAGE.Set_Token('VALUE',p_party_id,FALSE);
61: FND_MSG_PUB.ADD;
62: END IF;
63: END IF;
64: close C_Party_Exists;
65:

Line 66: FND_MSG_PUB.Count_And_Get

62: END IF;
63: END IF;
64: close C_Party_Exists;
65:
66: FND_MSG_PUB.Count_And_Get
67: ( p_count => x_msg_count,
68: p_data => x_msg_data
69: );
70:

Line 103: FND_MSG_PUB.initialize;

99:
100: -- initialize message list if p_init_msg_list is set to TRUE;
101:
102: IF FND_API.to_Boolean(p_init_msg_list) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: l_return_status := FND_API.G_RET_STS_SUCCESS;
107: open C_Party_Site_Exists(p_party_id, p_party_site_id);

Line 111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

107: open C_Party_Site_Exists(p_party_id, p_party_site_id);
108: fetch C_Party_Site_Exists into l_val;
109: IF (C_Party_Site_Exists%NOTFOUND) THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
114: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_SITE_ID', FALSE);
115: FND_MSG_PUB.ADD;

Line 115: FND_MSG_PUB.ADD;

111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
114: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_SITE_ID', FALSE);
115: FND_MSG_PUB.ADD;
116: END IF;
117: END IF;
118: close C_Party_Site_Exists;
119:

Line 120: FND_MSG_PUB.Count_And_Get

116: END IF;
117: END IF;
118: close C_Party_Site_Exists;
119:
120: FND_MSG_PUB.Count_And_Get
121: ( p_count => x_msg_count,
122: p_data => x_msg_data
123: );
124:

Line 164: FND_MSG_PUB.initialize;

160:
161: -- initialize message list if p_init_msg_list is set to TRUE;
162:
163: IF FND_API.to_Boolean(p_init_msg_list) THEN
164: FND_MSG_PUB.initialize;
165: END IF;
166:
167: l_return_status := FND_API.G_RET_STS_SUCCESS;
168:

Line 174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

170: open C_Party_Cnt_Point_Exists(p_party_id, p_contact_point_id);
171: fetch C_Party_Cnt_Point_Exists into l_val;
172: IF (C_Party_Cnt_Point_Exists%NOTFOUND) THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
175: THEN
176: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
177: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
178: FND_MSG_PUB.ADD;

Line 178: FND_MSG_PUB.ADD;

174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
175: THEN
176: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
177: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
178: FND_MSG_PUB.ADD;
179: END IF;
180: END IF;
181: close C_Party_Cnt_Point_Exists;
182: elsIf(p_party_id is NULL)then

Line 187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

183: open C_Org_Contact_Cnt_Point_Exists(p_org_contact_id, p_contact_point_id);
184: fetch C_Org_Contact_Cnt_Point_Exists into l_val;
185: IF (C_Org_Contact_Cnt_Point_Exists%NOTFOUND) THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
188: THEN
189: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
191: FND_MSG_PUB.ADD;

Line 191: FND_MSG_PUB.ADD;

187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
188: THEN
189: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
190: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
191: FND_MSG_PUB.ADD;
192: END IF;
193: END IF;
194: close C_Org_Contact_Cnt_Point_Exists;
195: else

Line 197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

193: END IF;
194: close C_Org_Contact_Cnt_Point_Exists;
195: else
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
201: FND_MSG_PUB.ADD;

Line 201: FND_MSG_PUB.ADD;

197: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
201: FND_MSG_PUB.ADD;
202: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
203: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
204: FND_MSG_PUB.ADD;
205: END IF;

Line 204: FND_MSG_PUB.ADD;

200: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
201: FND_MSG_PUB.ADD;
202: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
203: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT_ID', FALSE);
204: FND_MSG_PUB.ADD;
205: END IF;
206: end if;
207:
208:

Line 209: FND_MSG_PUB.Count_And_Get

205: END IF;
206: end if;
207:
208:
209: FND_MSG_PUB.Count_And_Get
210: ( p_count => x_msg_count,
211: p_data => x_msg_data
212: );
213:

Line 245: FND_MSG_PUB.initialize;

241:
242: -- initialize message list if p_init_msg_list is set to TRUE;
243:
244: IF FND_API.to_Boolean(p_init_msg_list) THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: l_return_status := FND_API.G_RET_STS_SUCCESS;
249: open C_Contact_Exists(p_contact_id, p_party_id);

Line 253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

249: open C_Contact_Exists(p_contact_id, p_party_id);
250: fetch C_Contact_Exists into l_val;
251: IF (C_Contact_Exists%NOTFOUND) THEN
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
256: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
257: FND_MSG_PUB.ADD;

Line 257: FND_MSG_PUB.ADD;

253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
256: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
257: FND_MSG_PUB.ADD;
258: END IF;
259: END IF;
260: close C_Contact_Exists;
261:

Line 262: FND_MSG_PUB.Count_And_Get

258: END IF;
259: END IF;
260: close C_Contact_Exists;
261:
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266: