APPS.AK_DELETE_GRP dependencies on FND_MSG_PUB

Line 60: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

56: --
57: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then
58: l_object_pk := p_primary_key;
59: else
60: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
61: FND_MESSAGE.SET_NAME('AK','AK_PRIMARY_KEY_INVALID');
62: FND_MESSAGE.SET_TOKEN('PRIMARY_KEY', p_primary_key);
63: FND_MSG_PUB.Add;
64: end if;

Line 63: FND_MSG_PUB.Add;

59: else
60: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
61: FND_MESSAGE.SET_NAME('AK','AK_PRIMARY_KEY_INVALID');
62: FND_MESSAGE.SET_TOKEN('PRIMARY_KEY', p_primary_key);
63: FND_MSG_PUB.Add;
64: end if;
65: end if;
66:
67: --

Line 70: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

66:
67: --
68: -- Set what error messages are to be displayed
69: --
70: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
71: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;
72:
73: -- Get application id from application short name
74: --

Line 71: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;

67: --
68: -- Set what error messages are to be displayed
69: --
70: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
71: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;
72:
73: -- Get application id from application short name
74: --
75: open l_get_appl_id_csr(l_appl_short_name);

Line 78: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

74: --
75: open l_get_appl_id_csr(l_appl_short_name);
76: fetch l_get_appl_id_csr into l_appl_id;
77: if (l_get_appl_id_csr%notfound) then
78: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
79: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
80: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
81: FND_MSG_PUB.Add;
82: end if;

Line 81: FND_MSG_PUB.Add;

77: if (l_get_appl_id_csr%notfound) then
78: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
79: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
80: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
81: FND_MSG_PUB.Add;
82: end if;
83: close l_get_appl_id_csr;
84: raise FND_API.G_EXC_ERROR;
85: end if;

Line 170: FND_MSG_PUB.Add;

166: --dbms_output.put_line(upper(l_by_object) ||
167: -- ' is invalid - it must be FLOW, REGION, OBJECT, ATTRIBUTE or SECURITY');
168: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BUSINESS_OBJECT');
169: FND_MESSAGE.SET_TOKEN('INVALID',l_by_object);
170: FND_MSG_PUB.Add;
171: end if;
172:
173: p_return_status := l_return_status;
174: --dbms_output.put_line('Finish downloading at:' ||

Line 180: if FND_MSG_PUB.Count_Msg > 0 then

176:
177: --dbms_output.put_line('Return status is: ' || l_return_status);
178: --dbms_output.put_line('Return message: ' || l_msg_data);
179:
180: if FND_MSG_PUB.Count_Msg > 0 then
181: FND_MSG_PUB.Reset;
182: --dbms_output.put_line('Messages: ');
183: for i in 1 .. FND_MSG_PUB.Count_Msg loop
184: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 181: FND_MSG_PUB.Reset;

177: --dbms_output.put_line('Return status is: ' || l_return_status);
178: --dbms_output.put_line('Return message: ' || l_msg_data);
179:
180: if FND_MSG_PUB.Count_Msg > 0 then
181: FND_MSG_PUB.Reset;
182: --dbms_output.put_line('Messages: ');
183: for i in 1 .. FND_MSG_PUB.Count_Msg loop
184: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
185: end loop;

Line 183: for i in 1 .. FND_MSG_PUB.Count_Msg loop

179:
180: if FND_MSG_PUB.Count_Msg > 0 then
181: FND_MSG_PUB.Reset;
182: --dbms_output.put_line('Messages: ');
183: for i in 1 .. FND_MSG_PUB.Count_Msg loop
184: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
185: end loop;
186: FND_MSG_PUB.Initialize;
187: end if;

Line 184: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

180: if FND_MSG_PUB.Count_Msg > 0 then
181: FND_MSG_PUB.Reset;
182: --dbms_output.put_line('Messages: ');
183: for i in 1 .. FND_MSG_PUB.Count_Msg loop
184: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
185: end loop;
186: FND_MSG_PUB.Initialize;
187: end if;
188:

Line 186: FND_MSG_PUB.Initialize;

182: --dbms_output.put_line('Messages: ');
183: for i in 1 .. FND_MSG_PUB.Count_Msg loop
184: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
185: end loop;
186: FND_MSG_PUB.Initialize;
187: end if;
188:
189: --
190: -- Add ending to log file

Line 229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

225: WHEN NO_DATA_FOUND THEN
226: p_return_status := FND_API.G_RET_STS_ERROR;
227: WHEN OTHERS THEN
228: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
230: SUBSTR (SQLERRM, 1, 240) );
231:
232: end DELETE;
233: