APPS.AK_DELETE_GRP dependencies on FND_MSG_PUB

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

50: --
51: if (p_primary_key is not null and p_primary_key <> FND_API.G_MISS_CHAR) then
52: l_object_pk := p_primary_key;
53: else
54: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
55: FND_MESSAGE.SET_NAME('AK','AK_PRIMARY_KEY_INVALID');
56: FND_MESSAGE.SET_TOKEN('PRIMARY_KEY', p_primary_key);
57: FND_MSG_PUB.Add;
58: end if;

Line 57: FND_MSG_PUB.Add;

53: else
54: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
55: FND_MESSAGE.SET_NAME('AK','AK_PRIMARY_KEY_INVALID');
56: FND_MESSAGE.SET_TOKEN('PRIMARY_KEY', p_primary_key);
57: FND_MSG_PUB.Add;
58: end if;
59: end if;
60:
61: --

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

60:
61: --
62: -- Set what error messages are to be displayed
63: --
64: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
65: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;
66:
67: -- Get application id from application short name
68: --

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

61: --
62: -- Set what error messages are to be displayed
63: --
64: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
65: FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_ERROR;
66:
67: -- Get application id from application short name
68: --
69: open l_get_appl_id_csr(l_appl_short_name);

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

68: --
69: open l_get_appl_id_csr(l_appl_short_name);
70: fetch l_get_appl_id_csr into l_appl_id;
71: if (l_get_appl_id_csr%notfound) then
72: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
73: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
74: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
75: FND_MSG_PUB.Add;
76: end if;

Line 75: FND_MSG_PUB.Add;

71: if (l_get_appl_id_csr%notfound) then
72: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
73: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
74: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
75: FND_MSG_PUB.Add;
76: end if;
77: close l_get_appl_id_csr;
78: raise FND_API.G_EXC_ERROR;
79: end if;

Line 153: FND_MSG_PUB.Add;

149: --dbms_output.put_line(upper(l_by_object) ||
150: -- ' is invalid - it must be FLOW, REGION, OBJECT, ATTRIBUTE or SECURITY');
151: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BUSINESS_OBJECT');
152: FND_MESSAGE.SET_TOKEN('INVALID',l_by_object);
153: FND_MSG_PUB.Add;
154: end if;
155:
156: p_return_status := l_return_status;
157: --dbms_output.put_line('Finish downloading at:' ||

Line 163: if FND_MSG_PUB.Count_Msg > 0 then

159:
160: --dbms_output.put_line('Return status is: ' || l_return_status);
161: --dbms_output.put_line('Return message: ' || l_msg_data);
162:
163: if FND_MSG_PUB.Count_Msg > 0 then
164: FND_MSG_PUB.Reset;
165: --dbms_output.put_line('Messages: ');
166: for i in 1 .. FND_MSG_PUB.Count_Msg loop
167: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

Line 164: FND_MSG_PUB.Reset;

160: --dbms_output.put_line('Return status is: ' || l_return_status);
161: --dbms_output.put_line('Return message: ' || l_msg_data);
162:
163: if FND_MSG_PUB.Count_Msg > 0 then
164: FND_MSG_PUB.Reset;
165: --dbms_output.put_line('Messages: ');
166: for i in 1 .. FND_MSG_PUB.Count_Msg loop
167: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
168: end loop;

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

162:
163: if FND_MSG_PUB.Count_Msg > 0 then
164: FND_MSG_PUB.Reset;
165: --dbms_output.put_line('Messages: ');
166: for i in 1 .. FND_MSG_PUB.Count_Msg loop
167: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
168: end loop;
169: FND_MSG_PUB.Initialize;
170: end if;

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

163: if FND_MSG_PUB.Count_Msg > 0 then
164: FND_MSG_PUB.Reset;
165: --dbms_output.put_line('Messages: ');
166: for i in 1 .. FND_MSG_PUB.Count_Msg loop
167: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
168: end loop;
169: FND_MSG_PUB.Initialize;
170: end if;
171:

Line 169: FND_MSG_PUB.Initialize;

165: --dbms_output.put_line('Messages: ');
166: for i in 1 .. FND_MSG_PUB.Count_Msg loop
167: l_buffer_tbl(i + l_index) := FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
168: end loop;
169: FND_MSG_PUB.Initialize;
170: end if;
171:
172: --
173: -- Add ending to log file

Line 212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

208: WHEN NO_DATA_FOUND THEN
209: p_return_status := FND_API.G_RET_STS_ERROR;
210: WHEN OTHERS THEN
211: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
213: SUBSTR (SQLERRM, 1, 240) );
214:
215: end DELETE;
216: