200: open l_get_appl_id_csr(l_appl_short_name);
201: fetch l_get_appl_id_csr into l_appl_id;
202: if (l_get_appl_id_csr%notfound) then
203: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
204: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
205: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
206: FND_MSG_PUB.Add;
207: end if;
208: close l_get_appl_id_csr;
201: fetch l_get_appl_id_csr into l_appl_id;
202: if (l_get_appl_id_csr%notfound) then
203: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
204: FND_MESSAGE.SET_NAME('AK','AK_APPL_SHORT_NAME_INVALID');
205: FND_MESSAGE.SET_TOKEN('APPL_SHORT_NAME', l_appl_short_name);
206: FND_MSG_PUB.Add;
207: end if;
208: close l_get_appl_id_csr;
209: raise FND_API.G_EXC_ERROR;
249: l_index := 1;
250: l_buffer_tbl(l_index) := '**********';
251:
252: l_index := l_index + 1;
253: FND_MESSAGE.SET_NAME('AK','AK_START_DOWNLOAD_SESSION');
254: l_buffer_tbl(l_index) := FND_MESSAGE.GET;
255: l_index := l_index + 1;
256: l_buffer_tbl(l_index) := to_char(sysdate, 'DY MON DD YYYY HH24:MI:SS');
257: l_index := l_index + 1;
250: l_buffer_tbl(l_index) := '**********';
251:
252: l_index := l_index + 1;
253: FND_MESSAGE.SET_NAME('AK','AK_START_DOWNLOAD_SESSION');
254: l_buffer_tbl(l_index) := FND_MESSAGE.GET;
255: l_index := l_index + 1;
256: l_buffer_tbl(l_index) := to_char(sysdate, 'DY MON DD YYYY HH24:MI:SS');
257: l_index := l_index + 1;
258: l_buffer_tbl(l_index) := '**********';
382: fetch l_get_resp_id into l_level_id_pk;
383: if (l_get_resp_id%notfound) then
384: l_level_id_pk := null;
385: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
386: -- FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');
387: -- FND_MSG_PUB.Add;
388: -- end if;
389: -- RAISE FND_API.G_EXC_ERROR;
390: end if;
427: fetch l_get_org_id into l_level_id_pk;
428: if (l_get_org_id%notfound) then
429: l_level_id_pk := null;
430: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
431: -- FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');
432: -- FND_MSG_PUB.Add;
433: -- end if;
434: -- RAISE FND_API.G_EXC_ERROR;
435: end if;
690:
691: else
692: --dbms_output.put_line(upper(l_by_object) ||
693: -- ' is invalid - it must be FLOW, REGION, OBJECT, ATTRIBUTE or SECURITY');
694: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BUSINESS_OBJECT');
695: FND_MESSAGE.SET_TOKEN('INVALID',l_by_object);
696: FND_MSG_PUB.Add;
697: end if;
698:
691: else
692: --dbms_output.put_line(upper(l_by_object) ||
693: -- ' is invalid - it must be FLOW, REGION, OBJECT, ATTRIBUTE or SECURITY');
694: FND_MESSAGE.SET_NAME('AK','AK_INVALID_BUSINESS_OBJECT');
695: FND_MESSAGE.SET_TOKEN('INVALID',l_by_object);
696: FND_MSG_PUB.Add;
697: end if;
698:
699: p_return_status := l_return_status;
725: l_index := l_index + 1;
726: l_buffer_tbl(l_index) := 'Primary key: '||p_primary_key;
727: end if;
728: l_index := l_index + 1;
729: FND_MESSAGE.SET_NAME('AK','AK_END_DOWNLOAD_SESSION');
730: l_buffer_tbl(l_index) := FND_MESSAGE.GET;
731:
732: --
733: -- Write all messages and ending to a log file
726: l_buffer_tbl(l_index) := 'Primary key: '||p_primary_key;
727: end if;
728: l_index := l_index + 1;
729: FND_MESSAGE.SET_NAME('AK','AK_END_DOWNLOAD_SESSION');
730: l_buffer_tbl(l_index) := FND_MESSAGE.GET;
731:
732: --
733: -- Write all messages and ending to a log file
734: --
780: l_index := l_index + 1;
781: l_buffer_tbl(l_index) := 'Primary key: '||p_primary_key;
782: end if;
783: l_index := l_index + 1;
784: FND_MESSAGE.SET_NAME('AK','AK_END_DOWNLOAD_SESSION');
785: l_buffer_tbl(l_index) := FND_MESSAGE.GET;
786: --
787: -- Write all messages and ending to a log file
788: --
781: l_buffer_tbl(l_index) := 'Primary key: '||p_primary_key;
782: end if;
783: l_index := l_index + 1;
784: FND_MESSAGE.SET_NAME('AK','AK_END_DOWNLOAD_SESSION');
785: l_buffer_tbl(l_index) := FND_MESSAGE.GET;
786: --
787: -- Write all messages and ending to a log file
788: --
789: