DBA Data[Home] [Help]

APPS.OKC_QA_GENERAL_CHECKLISTS dependencies on OKC_API

Line 47: OKC_API.set_message(

43: l_euro_currency_code := OKC_CURRENCY_API.GET_EURO_CURRENCY_CODE(l_currency_code);
44: CLOSE csr_contracts;
45: if (l_euro_currency_code <> l_currency_code) and
46: l_sts_code = 'ENTERED' then
47: OKC_API.set_message(
48: p_app_name => G_APP_NAME,
49: p_msg_name => 'OKC_EURO_CHECK_FAIL');
50: x_return_status := OKC_API.G_RET_STS_ERROR;
51: ELSE

Line 50: x_return_status := OKC_API.G_RET_STS_ERROR;

46: l_sts_code = 'ENTERED' then
47: OKC_API.set_message(
48: p_app_name => G_APP_NAME,
49: p_msg_name => 'OKC_EURO_CHECK_FAIL');
50: x_return_status := OKC_API.G_RET_STS_ERROR;
51: ELSE
52: OKC_API.set_message(
53: p_app_name => G_APP_NAME,
54: p_msg_name => G_QA_SUCCESS);

Line 52: OKC_API.set_message(

48: p_app_name => G_APP_NAME,
49: p_msg_name => 'OKC_EURO_CHECK_FAIL');
50: x_return_status := OKC_API.G_RET_STS_ERROR;
51: ELSE
52: OKC_API.set_message(
53: p_app_name => G_APP_NAME,
54: p_msg_name => G_QA_SUCCESS);
55: END IF;
56: IF (l_debug = 'Y') THEN

Line 70: OKC_API.SET_MESSAGE(

66: END IF;
67: if csr_contracts%ISOPEN then
68: close csr_contracts;
69: end if;
70: OKC_API.SET_MESSAGE(
71: p_app_name => G_APP_NAME,
72: p_msg_name => G_UNEXPECTED_ERROR,
73: p_token1 => G_SQLCODE_TOKEN,
74: p_token1_value => SQLCODE,

Line 77: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

73: p_token1 => G_SQLCODE_TOKEN,
74: p_token1_value => SQLCODE,
75: p_token2 => G_SQLERRM_TOKEN,
76: p_token2_value => SQLERRM);
77: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
78: end check_euro_currency;
79:
80: -- Bug 2041448, skekkar
81:

Line 212: OKC_API.set_message(

208: --
209: -- issue a warning if no records with email address
210: --
211: IF l_email_found = 'N' THEN
212: OKC_API.set_message(
213: p_app_name => G_APP_NAME,
214: p_msg_name => 'OKC_EMAIL_ADD_WARN');
215: -- notify caller of an error
216: -- x_return_status := OKC_API.G_RET_STS_WARNING;

Line 216: -- x_return_status := OKC_API.G_RET_STS_WARNING;

212: OKC_API.set_message(
213: p_app_name => G_APP_NAME,
214: p_msg_name => 'OKC_EMAIL_ADD_WARN');
215: -- notify caller of an error
216: -- x_return_status := OKC_API.G_RET_STS_WARNING;
217: x_return_status := OKC_API.G_RET_STS_ERROR;
218: ELSE
219: OKC_API.set_message(
220: p_app_name => G_APP_NAME,

Line 217: x_return_status := OKC_API.G_RET_STS_ERROR;

213: p_app_name => G_APP_NAME,
214: p_msg_name => 'OKC_EMAIL_ADD_WARN');
215: -- notify caller of an error
216: -- x_return_status := OKC_API.G_RET_STS_WARNING;
217: x_return_status := OKC_API.G_RET_STS_ERROR;
218: ELSE
219: OKC_API.set_message(
220: p_app_name => G_APP_NAME,
221: p_msg_name => G_QA_SUCCESS);

Line 219: OKC_API.set_message(

215: -- notify caller of an error
216: -- x_return_status := OKC_API.G_RET_STS_WARNING;
217: x_return_status := OKC_API.G_RET_STS_ERROR;
218: ELSE
219: OKC_API.set_message(
220: p_app_name => G_APP_NAME,
221: p_msg_name => G_QA_SUCCESS);
222: END IF; -- l_email_found = 'N'
223:

Line 238: OKC_API.SET_MESSAGE(

234: END IF;
235: if csr_contacts%ISOPEN then
236: close csr_contacts;
237: end if;
238: OKC_API.SET_MESSAGE(
239: p_app_name => G_APP_NAME,
240: p_msg_name => G_UNEXPECTED_ERROR,
241: p_token1 => G_SQLCODE_TOKEN,
242: p_token1_value => SQLCODE,

Line 245: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

241: p_token1 => G_SQLCODE_TOKEN,
242: p_token1_value => SQLCODE,
243: p_token2 => G_SQLERRM_TOKEN,
244: p_token2_value => SQLERRM);
245: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
246: end check_email_address;
247: --
248: --
249: -- Bug 2077501 , skekkar

Line 354: OKC_API.set_message(p_app_name => G_APP_NAME,

350: --
351: -- Set the error message if no role for the contract
352: --
353: If l_rle_not_found Then
354: OKC_API.set_message(p_app_name => G_APP_NAME,
355: p_msg_name => 'OKC_EMAIL_NO_ROLE',
356: p_token1 => 'ROLE',
357: p_token1_value => okc_util.decode_lookup('OKC_ROLE',p_rle_code));
358: -- notify caller of an warning

Line 359: x_return_status := OKC_API.G_RET_STS_WARNING;

355: p_msg_name => 'OKC_EMAIL_NO_ROLE',
356: p_token1 => 'ROLE',
357: p_token1_value => okc_util.decode_lookup('OKC_ROLE',p_rle_code));
358: -- notify caller of an warning
359: x_return_status := OKC_API.G_RET_STS_WARNING;
360: Raise G_EXCEPTION_HALT_VALIDATION;
361: END IF; -- role exists
362: --
363: -- Set the error messages if no contact for the role

Line 366: OKC_API.set_message(p_app_name => G_APP_NAME,

362: --
363: -- Set the error messages if no contact for the role
364: --
365: If l_ctc_not_found Then
366: OKC_API.set_message(p_app_name => G_APP_NAME,
367: p_msg_name => 'OKC_EMAIL_NO_CONTACT',
368: p_token1 => 'ROLE',
369: p_token1_value => okc_util.decode_lookup('OKC_ROLE',p_rle_code));
370: -- notify caller of an warning

Line 371: x_return_status := OKC_API.G_RET_STS_WARNING;

367: p_msg_name => 'OKC_EMAIL_NO_CONTACT',
368: p_token1 => 'ROLE',
369: p_token1_value => okc_util.decode_lookup('OKC_ROLE',p_rle_code));
370: -- notify caller of an warning
371: x_return_status := OKC_API.G_RET_STS_WARNING;
372: Raise G_EXCEPTION_HALT_VALIDATION;
373: END IF; -- contact exists
374: --
375: -- issue a warning if no records with email address

Line 378: OKC_API.set_message(p_app_name => G_APP_NAME,

374: --
375: -- issue a warning if no records with email address
376: --
377: IF l_email_found = 'N' THEN
378: OKC_API.set_message(p_app_name => G_APP_NAME,
379: p_msg_name => 'OKC_EMAIL_ADD_WARN_RLE',
380: p_token1 => 'ROLE',
381: p_token1_value => okc_util.decode_lookup('OKC_ROLE',p_rle_code));
382: -- notify caller of an error

Line 383: x_return_status := OKC_API.G_RET_STS_ERROR;

379: p_msg_name => 'OKC_EMAIL_ADD_WARN_RLE',
380: p_token1 => 'ROLE',
381: p_token1_value => okc_util.decode_lookup('OKC_ROLE',p_rle_code));
382: -- notify caller of an error
383: x_return_status := OKC_API.G_RET_STS_ERROR;
384: Raise G_EXCEPTION_HALT_VALIDATION;
385: END IF; -- l_email_found = 'N'
386: -- QA passed
387: OKC_API.set_message(p_app_name => G_APP_NAME,

Line 387: OKC_API.set_message(p_app_name => G_APP_NAME,

383: x_return_status := OKC_API.G_RET_STS_ERROR;
384: Raise G_EXCEPTION_HALT_VALIDATION;
385: END IF; -- l_email_found = 'N'
386: -- QA passed
387: OKC_API.set_message(p_app_name => G_APP_NAME,
388: p_msg_name => 'OKC_EMAIL_ADD_SUCC_RLE',
389: p_token1 => 'ROLE',
390: p_token1_value => okc_util.decode_lookup('OKC_ROLE',p_rle_code));
391:

Line 414: OKC_API.SET_MESSAGE(

410: end if;
411: if csr_contacts%ISOPEN then
412: close csr_contacts;
413: end if;
414: OKC_API.SET_MESSAGE(
415: p_app_name => G_APP_NAME,
416: p_msg_name => G_UNEXPECTED_ERROR,
417: p_token1 => G_SQLCODE_TOKEN,
418: p_token1_value => SQLCODE,

Line 421: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

417: p_token1 => G_SQLCODE_TOKEN,
418: p_token1_value => SQLCODE,
419: p_token2 => G_SQLERRM_TOKEN,
420: p_token2_value => SQLERRM);
421: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
422: end check_email_address_role;
423:
424: -- skekkar
425: --