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_SETUPCGRPARAMETERS_PVT dependencies on OKL_API

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

19: CREATED_BY,
20: CREATION_DATE,
21: LAST_UPDATED_BY,
22: LAST_UPDATE_DATE,
23: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
24: FROM Okl_Cntx_Grp_Prmtrs_V
25: WHERE okl_Cntx_Grp_Prmtrs_V.id = p_id;
26: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
27: l_cgmv_rec cgmv_rec_type;

Line 29: x_return_status := OKL_API.G_RET_STS_SUCCESS;

25: WHERE okl_Cntx_Grp_Prmtrs_V.id = p_id;
26: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
27: l_cgmv_rec cgmv_rec_type;
28: BEGIN
29: x_return_status := OKL_API.G_RET_STS_SUCCESS;
30: x_no_data_found := TRUE;
31:
32: -- Get current database values
33: OPEN okl_cgmv_pk_csr (p_cgmv_rec.id);

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

46: x_cgmv_rec := l_cgmv_rec;
47: EXCEPTION
48: WHEN OTHERS THEN
49: -- store SQL error message on message stack
50: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
51: p_msg_name => G_UNEXPECTED_ERROR,
52: p_token1 => G_SQLCODE_TOKEN,
53: p_token1_value => sqlcode,
54: p_token2 => G_SQLERRM_TOKEN,

Line 57: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

53: p_token1_value => sqlcode,
54: p_token2 => G_SQLERRM_TOKEN,
55: p_token2_value => sqlerrm);
56: -- notify UNEXPECTED error for calling API.
57: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
58:
59: IF (okl_cgmv_pk_csr%ISOPEN) THEN
60: CLOSE okl_cgmv_pk_csr;
61: END IF;

Line 85: x_return_status := OKL_API.G_RET_STS_SUCCESS;

81: l_check VARCHAR2(1) := '?';
82: l_row_not_found BOOLEAN := FALSE;
83: BEGIN
84: x_valid := TRUE;
85: x_return_status := OKL_API.G_RET_STS_SUCCESS;
86:
87: -- Check for related formulae
88: OPEN okl_fmav_fk_csr (p_cgmv_rec.cgr_id);
89: FETCH okl_fmav_fk_csr INTO l_check;

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

90: l_row_not_found := okl_fmav_fk_csr%NOTFOUND;
91: CLOSE okl_fmav_fk_csr;
92:
93: IF l_row_not_found = FALSE then
94: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
95: p_msg_name => G_IN_USE,
96: p_token1 => G_PARENT_TABLE_TOKEN,
97: p_token1_value => 'Okl_Formulae_V',
98: p_token2 => G_CHILD_TABLE_TOKEN,

Line 101: x_return_status := OKL_API.G_RET_STS_ERROR;

97: p_token1_value => 'Okl_Formulae_V',
98: p_token2 => G_CHILD_TABLE_TOKEN,
99: p_token2_value => 'Okl_Context_Groups_V');
100: x_valid := FALSE;
101: x_return_status := OKL_API.G_RET_STS_ERROR;
102: END IF;
103:
104: EXCEPTION
105: WHEN OTHERS THEN

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

103:
104: EXCEPTION
105: WHEN OTHERS THEN
106: -- store SQL error message on message stack
107: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
108: p_msg_name => G_UNEXPECTED_ERROR,
109: p_token1 => G_SQLCODE_TOKEN,
110: p_token1_value => sqlcode,
111: p_token2 => G_SQLERRM_TOKEN,

Line 114: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

110: p_token1_value => sqlcode,
111: p_token2 => G_SQLERRM_TOKEN,
112: p_token2_value => sqlerrm);
113: x_valid := FALSE;
114: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
115:
116: IF (okl_fmav_fk_csr%ISOPEN) THEN
117: CLOSE okl_fmav_fk_csr;
118: END IF;

Line 127: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

123: ---------------------------------------------------------------------------
124: -- PROCEDURE insert_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
125: ---------------------------------------------------------------------------
126: PROCEDURE insert_cgrparameters(p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_cgmv_rec IN cgmv_rec_type,

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

197: ---------------------------------------------------------------------------
198: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
199: ---------------------------------------------------------------------------
200: PROCEDURE update_cgrparameters(p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_cgmv_rec IN cgmv_rec_type,

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

230: /* call check_context_groups to check whether it is affecting existing formulae */
231: check_context_groups(p_cgmv_rec => l_cgmv_rec,
232: x_return_status => l_return_status,
233: x_valid => l_valid);
234: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
237: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
238: l_valid <> TRUE) THEN

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

232: x_return_status => l_return_status,
233: x_valid => l_valid);
234: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
237: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
238: l_valid <> TRUE) THEN
239: x_return_status := OKL_API.G_RET_STS_ERROR;
240: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 237: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

233: x_valid => l_valid);
234: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
235: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
237: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
238: l_valid <> TRUE) THEN
239: x_return_status := OKL_API.G_RET_STS_ERROR;
240: RAISE OKC_API.G_EXCEPTION_ERROR;
241: END IF;

Line 239: x_return_status := OKL_API.G_RET_STS_ERROR;

235: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
236: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
237: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
238: l_valid <> TRUE) THEN
239: x_return_status := OKL_API.G_RET_STS_ERROR;
240: RAISE OKC_API.G_EXCEPTION_ERROR;
241: END IF;
242:
243: /* public api to update context groups */

Line 291: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

287: -- PROCEDURE delete_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
288: -- This allows the user to delete table of records
289: ---------------------------------------------------------------------------
290: PROCEDURE delete_cgrparameters(p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_cgmv_tbl IN cgmv_tbl_type

Line 329: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

325: check_context_groups(p_cgmv_rec => l_cgmv_tbl(i),
326: x_return_status => l_return_status,
327: x_valid => l_valid);
328: -- store the highest degree of error
329: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
330: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
331: l_overall_status := l_return_status;
332: END IF;
333: END IF;

Line 330: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

326: x_return_status => l_return_status,
327: x_valid => l_valid);
328: -- store the highest degree of error
329: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
330: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
331: l_overall_status := l_return_status;
332: END IF;
333: END IF;
334: EXIT WHEN (i = l_cgmv_tbl.LAST);

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

339:
340: -- return overall status
341: l_return_status := l_overall_status;
342: END IF;
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
346: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
347: l_valid <> TRUE) THEN

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

341: l_return_status := l_overall_status;
342: END IF;
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
346: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
347: l_valid <> TRUE) THEN
348: x_return_status := OKL_API.G_RET_STS_ERROR;
349: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 346: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

342: END IF;
343: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
346: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
347: l_valid <> TRUE) THEN
348: x_return_status := OKL_API.G_RET_STS_ERROR;
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;

Line 348: x_return_status := OKL_API.G_RET_STS_ERROR;

344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
346: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
347: l_valid <> TRUE) THEN
348: x_return_status := OKL_API.G_RET_STS_ERROR;
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;
351:
352: /* delete context group parameters */

Line 398: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

394: ---------------------------------------------------------------------------
395: -- PROCEDURE insert_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
396: ---------------------------------------------------------------------------
397: PROCEDURE insert_cgrparameters(p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_cgmv_tbl IN cgmv_tbl_type,

Line 484: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

480: ---------------------------------------------------------------------------
481: -- PROCEDURE update_cgrparameters for: OKL_CNTX_GRP_PRMTRS_V
482: ---------------------------------------------------------------------------
483: PROCEDURE update_cgrparameters(p_api_version IN NUMBER,
484: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
485: x_return_status OUT NOCOPY VARCHAR2,
486: x_msg_count OUT NOCOPY NUMBER,
487: x_msg_data OUT NOCOPY VARCHAR2,
488: p_cgmv_tbl IN cgmv_tbl_type,

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

519: /* call check_context_groups to check whether it is affecting existing formulae */
520: check_context_groups(p_cgmv_rec => l_cgmv_rec,
521: x_return_status => l_return_status,
522: x_valid => l_valid);
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
526: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
527: l_valid <> TRUE) THEN

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

521: x_return_status => l_return_status,
522: x_valid => l_valid);
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
526: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
527: l_valid <> TRUE) THEN
528: x_return_status := OKL_API.G_RET_STS_ERROR;
529: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 526: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND

522: x_valid => l_valid);
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
526: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
527: l_valid <> TRUE) THEN
528: x_return_status := OKL_API.G_RET_STS_ERROR;
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;

Line 528: x_return_status := OKL_API.G_RET_STS_ERROR;

524: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) OR
526: (l_return_status = OKL_API.G_RET_STS_SUCCESS AND
527: l_valid <> TRUE) THEN
528: x_return_status := OKL_API.G_RET_STS_ERROR;
529: RAISE OKC_API.G_EXCEPTION_ERROR;
530: END IF;
531:
532: /* public api to update context groups */