eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPFMACONSTRAINTS_PVT dependencies on OKL_API

Line 30: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN

26: CREATED_BY,
27: CREATION_DATE,
28: LAST_UPDATED_BY,
29: LAST_UPDATE_DATE,
30: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
31: FROM Okl_Fmla_Oprnds_V
32: WHERE okl_Fmla_Oprnds_V.id = p_id;
33: l_okl_fodv_pk okl_fodv_pk_csr%ROWTYPE;
34: l_fodv_rec fodv_rec_type;

Line 36: x_return_status := OKL_API.G_RET_STS_SUCCESS;

32: WHERE okl_Fmla_Oprnds_V.id = p_id;
33: l_okl_fodv_pk okl_fodv_pk_csr%ROWTYPE;
34: l_fodv_rec fodv_rec_type;
35: BEGIN
36: x_return_status := OKL_API.G_RET_STS_SUCCESS;
37: x_no_data_found := TRUE;
38:
39: -- Get current database values
40: OPEN okl_fodv_pk_csr (p_fodv_rec.id);

Line 58: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

54: x_fodv_rec := l_fodv_rec;
55: EXCEPTION
56: WHEN OTHERS THEN
57: -- store SQL error message on message stack
58: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
59: p_msg_name => G_UNEXPECTED_ERROR,
60: p_token1 => G_SQLCODE_TOKEN,
61: p_token1_value => sqlcode,
62: p_token2 => G_SQLERRM_TOKEN,

Line 65: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

61: p_token1_value => sqlcode,
62: p_token2 => G_SQLERRM_TOKEN,
63: p_token2_value => sqlerrm);
64: -- notify UNEXPECTED error for calling API.
65: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
66:
67: IF (okl_fodv_pk_csr%ISOPEN) THEN
68: CLOSE okl_fodv_pk_csr;
69: END IF;

Line 93: NVL(opd.END_DATE, NVL(fma.END_DATE, OKL_API.G_MISS_DATE)) < NVL(fma.END_DATE, OKL_API.G_MISS_DATE));

89: Okl_Formulae_V fma
90: WHERE opd.ID = p_opd_id
91: AND fma.ID = p_fma_id
92: AND (opd.START_DATE > fma.START_DATE OR
93: NVL(opd.END_DATE, NVL(fma.END_DATE, OKL_API.G_MISS_DATE)) < NVL(fma.END_DATE, OKL_API.G_MISS_DATE));
94:
95: l_check VARCHAR2(1) := '?';
96: l_row_not_found BOOLEAN := FALSE;
97: BEGIN

Line 99: x_return_status := OKL_API.G_RET_STS_SUCCESS;

95: l_check VARCHAR2(1) := '?';
96: l_row_not_found BOOLEAN := FALSE;
97: BEGIN
98: x_valid := TRUE;
99: x_return_status := OKL_API.G_RET_STS_SUCCESS;
100:
101: -- Check for operand dates
102: OPEN okl_opdv_pk_csr (p_fodv_rec.opd_id,
103: p_fodv_rec.fma_id);

Line 109: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

105: l_row_not_found := okl_opdv_pk_csr%NOTFOUND;
106: CLOSE okl_opdv_pk_csr;
107:
108: IF l_row_not_found = FALSE then
109: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
110: p_msg_name => G_DATES_MISMATCH,
111: p_token1 => G_PARENT_TABLE_TOKEN,
112: p_token1_value => 'Okl_Operands_V',
113: p_token2 => G_CHILD_TABLE_TOKEN,

Line 116: x_return_status := OKL_API.G_RET_STS_ERROR;

112: p_token1_value => 'Okl_Operands_V',
113: p_token2 => G_CHILD_TABLE_TOKEN,
114: p_token2_value => 'Okl_Fmla_Oprnds_V');
115: x_valid := FALSE;
116: x_return_status := OKL_API.G_RET_STS_ERROR;
117: END IF;
118:
119: EXCEPTION
120: WHEN OTHERS THEN

Line 122: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: -- store SQL error message on message stack
122: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
123: p_msg_name => G_UNEXPECTED_ERROR,
124: p_token1 => G_SQLCODE_TOKEN,
125: p_token1_value => sqlcode,
126: p_token2 => G_SQLERRM_TOKEN,

Line 129: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

125: p_token1_value => sqlcode,
126: p_token2 => G_SQLERRM_TOKEN,
127: p_token2_value => sqlerrm);
128: x_valid := FALSE;
129: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
130:
131: IF (okl_opdv_pk_csr%ISOPEN) THEN
132: CLOSE okl_opdv_pk_csr;
133: END IF;

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

138: ---------------------------------------------------------------------------
139: -- PROCEDURE insert_fmaconstraints for: OKL_FMLA_OPRNDS_V
140: ---------------------------------------------------------------------------
141: PROCEDURE insert_fmaconstraints(p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_fmav_rec IN fmav_rec_type,

Line 180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

176: check_operands(p_fmav_rec => l_fmav_rec,
177: p_fodv_rec => l_fodv_rec,
178: x_return_status => l_return_status,
179: x_valid => l_valid);
180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
183: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
184: l_valid <> TRUE) THEN

Line 182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

178: x_return_status => l_return_status,
179: x_valid => l_valid);
180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
183: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
184: l_valid <> TRUE) THEN
185: x_return_status := OKL_API.G_RET_STS_ERROR;
186: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 183: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

179: x_valid => l_valid);
180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
183: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
184: l_valid <> TRUE) THEN
185: x_return_status := OKL_API.G_RET_STS_ERROR;
186: RAISE OKC_API.G_EXCEPTION_ERROR;
187: END IF;

Line 185: x_return_status := OKL_API.G_RET_STS_ERROR;

181: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
183: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
184: l_valid <> TRUE) THEN
185: x_return_status := OKL_API.G_RET_STS_ERROR;
186: RAISE OKC_API.G_EXCEPTION_ERROR;
187: END IF;
188:
189: /* public api to insert formulae constraints */

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

247: ---------------------------------------------------------------------------
248: -- PROCEDURE update_fmaconstraints for: OKL_FMLA_OPRNDS_V
249: ---------------------------------------------------------------------------
250: PROCEDURE update_fmaconstraints(p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_fmav_rec IN fmav_rec_type,

Line 288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

284: check_operands(p_fmav_rec => l_fmav_rec,
285: p_fodv_rec => l_fodv_rec,
286: x_return_status => l_return_status,
287: x_valid => l_valid);
288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
289: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
291: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
292: l_valid <> TRUE) THEN

Line 290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR

286: x_return_status => l_return_status,
287: x_valid => l_valid);
288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
289: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
291: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
292: l_valid <> TRUE) THEN
293: x_return_status := OKL_API.G_RET_STS_ERROR;
294: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 291: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

287: x_valid => l_valid);
288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
289: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
291: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
292: l_valid <> TRUE) THEN
293: x_return_status := OKL_API.G_RET_STS_ERROR;
294: RAISE OKC_API.G_EXCEPTION_ERROR;
295: END IF;

Line 293: x_return_status := OKL_API.G_RET_STS_ERROR;

289: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
291: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
292: l_valid <> TRUE) THEN
293: x_return_status := OKL_API.G_RET_STS_ERROR;
294: RAISE OKC_API.G_EXCEPTION_ERROR;
295: END IF;
296:
297: /* public api to insert formulae constraints */

Line 362: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

358: -- This allows the user to delete table of records
359: ---------------------------------------------------------------------------
360: PROCEDURE delete_fmaconstraints(
361: p_api_version IN NUMBER
362: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
363: ,x_return_status OUT NOCOPY VARCHAR2
364: ,x_msg_count OUT NOCOPY NUMBER
365: ,x_msg_data OUT NOCOPY VARCHAR2
366: ,p_fodv_tbl IN fodv_tbl_type

Line 451: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

447: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FMLA_OPRNDS - TBL : begin
448:
449: PROCEDURE insert_fmaconstraints(
450: p_api_version IN NUMBER
451: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER
454: ,x_msg_data OUT NOCOPY VARCHAR2
455: ,p_fmav_rec IN fmav_rec_type

Line 546: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

542:
543: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_FMLA_OPRNDS - TBL : begin
544: PROCEDURE update_fmaconstraints(
545: p_api_version IN NUMBER
546: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
547: ,x_return_status OUT NOCOPY VARCHAR2
548: ,x_msg_count OUT NOCOPY NUMBER
549: ,x_msg_data OUT NOCOPY VARCHAR2
550: ,p_fmav_rec IN fmav_rec_type

Line 578: ,p_init_msg_list => OKL_API.G_FALSE

574: p_api_version => p_api_version
575: --start:| 20-Nov-08 cklee/smadhava Bug# 7439737/7298457
576: -- ,p_init_msg_list => p_init_msg_list
577: -- Bug# 7298457 - Donot reset message list- passing 'T' overwrites the error messages of previous operands
578: ,p_init_msg_list => OKL_API.G_FALSE
579: --end:| 20-Nov-08 cklee/smadhava Bug# 7439737/7298457
580: ,x_return_status => x_return_status
581: ,x_msg_count => x_msg_count
582: ,x_msg_data => x_msg_data