DBA Data[Home] [Help]

APPS.OKS_AUTO_REMINDER dependencies on FND_MESSAGE

Line 549: fnd_message.set_name ('OKS', 'OKS_SSO_FND_PROFILE_ERROR');

545: THEN
546: RETURN;
547: ELSE
548: -- error in fnd_profile.save
549: fnd_message.set_name ('OKS', 'OKS_SSO_FND_PROFILE_ERROR');
550: x_err_msg (l_count).description := fnd_message.get;
551: RAISE fnd_api.g_exc_error;
552: END IF;
553: ELSE

Line 550: x_err_msg (l_count).description := fnd_message.get;

546: RETURN;
547: ELSE
548: -- error in fnd_profile.save
549: fnd_message.set_name ('OKS', 'OKS_SSO_FND_PROFILE_ERROR');
550: x_err_msg (l_count).description := fnd_message.get;
551: RAISE fnd_api.g_exc_error;
552: END IF;
553: ELSE
554: -- l_user_id is null, raise exception

Line 555: fnd_message.set_name ('OKS', 'OKS_SSO_USER_ID_NULL');

551: RAISE fnd_api.g_exc_error;
552: END IF;
553: ELSE
554: -- l_user_id is null, raise exception
555: fnd_message.set_name ('OKS', 'OKS_SSO_USER_ID_NULL');
556: x_err_msg (l_count).description := fnd_message.get;
557: RAISE fnd_api.g_exc_error;
558: END IF; -- l_user_id is not null
559: ELSE -- l_test_user <> 0 ,3

Line 556: x_err_msg (l_count).description := fnd_message.get;

552: END IF;
553: ELSE
554: -- l_user_id is null, raise exception
555: fnd_message.set_name ('OKS', 'OKS_SSO_USER_ID_NULL');
556: x_err_msg (l_count).description := fnd_message.get;
557: RAISE fnd_api.g_exc_error;
558: END IF; -- l_user_id is not null
559: ELSE -- l_test_user <> 0 ,3
560: -- error, raise exception

Line 561: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');

557: RAISE fnd_api.g_exc_error;
558: END IF; -- l_user_id is not null
559: ELSE -- l_test_user <> 0 ,3
560: -- error, raise exception
561: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
562: fnd_message.set_token ('RETURN_VAL', l_test_user);
563: x_err_msg (l_count).description := fnd_message.get;
564: RAISE fnd_api.g_exc_error;
565: END IF; -- l_test_user check

Line 562: fnd_message.set_token ('RETURN_VAL', l_test_user);

558: END IF; -- l_user_id is not null
559: ELSE -- l_test_user <> 0 ,3
560: -- error, raise exception
561: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
562: fnd_message.set_token ('RETURN_VAL', l_test_user);
563: x_err_msg (l_count).description := fnd_message.get;
564: RAISE fnd_api.g_exc_error;
565: END IF; -- l_test_user check
566: ELSE -- l_row_notfound is false i.e record exists in fnd_user

Line 563: x_err_msg (l_count).description := fnd_message.get;

559: ELSE -- l_test_user <> 0 ,3
560: -- error, raise exception
561: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
562: fnd_message.set_token ('RETURN_VAL', l_test_user);
563: x_err_msg (l_count).description := fnd_message.get;
564: RAISE fnd_api.g_exc_error;
565: END IF; -- l_test_user check
566: ELSE -- l_row_notfound is false i.e record exists in fnd_user
567: x_password := '******';

Line 580: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');

576: );
577: ELSIF l_fnd_person_party_id <> l_qtc_person_party_id
578: THEN
579: -- fnd_user.person_party_id does NOT match oks_person_party_id
580: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
581: x_err_msg (l_count).description := fnd_message.get;
582: RAISE fnd_api.g_exc_error;
583: ELSE
584: -- l_fnd_person_party_id = l_qtc_person_party_id

Line 581: x_err_msg (l_count).description := fnd_message.get;

577: ELSIF l_fnd_person_party_id <> l_qtc_person_party_id
578: THEN
579: -- fnd_user.person_party_id does NOT match oks_person_party_id
580: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
581: x_err_msg (l_count).description := fnd_message.get;
582: RAISE fnd_api.g_exc_error;
583: ELSE
584: -- l_fnd_person_party_id = l_qtc_person_party_id
585: RETURN;

Line 1676: fnd_message.set_name (g_app_name, 'OKS_INVD_CONTRACT_ID');

1672: CLOSE l_kdetails_csr;
1673:
1674: IF l_rownotfound
1675: THEN
1676: fnd_message.set_name (g_app_name, 'OKS_INVD_CONTRACT_ID');
1677: fnd_message.set_token ('HDR_ID', p_chr_id);
1678: fnd_msg_pub.ADD;
1679: RAISE fnd_api.g_exc_error;
1680: END IF;

Line 1677: fnd_message.set_token ('HDR_ID', p_chr_id);

1673:
1674: IF l_rownotfound
1675: THEN
1676: fnd_message.set_name (g_app_name, 'OKS_INVD_CONTRACT_ID');
1677: fnd_message.set_token ('HDR_ID', p_chr_id);
1678: fnd_msg_pub.ADD;
1679: RAISE fnd_api.g_exc_error;
1680: END IF;
1681:

Line 1712: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_CONTACT');

1708: END IF;
1709:
1710: IF l_party_id IS NULL
1711: THEN
1712: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_CONTACT');
1713: fnd_msg_pub.ADD;
1714: RAISE fnd_api.g_exc_error;
1715: END IF;
1716:

Line 1786: fnd_message.set_name (g_app_name, 'OKS_INTERACTION_FAILED');

1782:
1783: IF l_rownotfound
1784: OR l_salesrep_resource_id IS NULL
1785: THEN
1786: fnd_message.set_name (g_app_name, 'OKS_INTERACTION_FAILED');
1787: fnd_msg_pub.ADD;
1788: RAISE fnd_api.g_exc_error;
1789: END IF;
1790:

Line 1793: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_SUBJECT');

1789: END IF;
1790:
1791: IF p_subject IS NULL
1792: THEN
1793: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_SUBJECT');
1794: l_subject := fnd_message.get;
1795: ELSE
1796: l_subject := p_subject;
1797: END IF;

Line 1794: l_subject := fnd_message.get;

1790:
1791: IF p_subject IS NULL
1792: THEN
1793: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_SUBJECT');
1794: l_subject := fnd_message.get;
1795: ELSE
1796: l_subject := p_subject;
1797: END IF;
1798:

Line 1802: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_MSG_BODY');

1798:
1799: IF p_msg_body IS NULL
1800: THEN
1801: -- assemble interaction history body
1802: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_MSG_BODY');
1803: fnd_message.set_token ('TOKEN1', l_kdetails_rec.contract_number);
1804: fnd_message.set_token ('TOKEN2',
1805: l_kdetails_rec.contract_number_modifier);
1806:

Line 1803: fnd_message.set_token ('TOKEN1', l_kdetails_rec.contract_number);

1799: IF p_msg_body IS NULL
1800: THEN
1801: -- assemble interaction history body
1802: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_MSG_BODY');
1803: fnd_message.set_token ('TOKEN1', l_kdetails_rec.contract_number);
1804: fnd_message.set_token ('TOKEN2',
1805: l_kdetails_rec.contract_number_modifier);
1806:
1807: IF p_sent2_email IS NULL

Line 1804: fnd_message.set_token ('TOKEN2',

1800: THEN
1801: -- assemble interaction history body
1802: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_MSG_BODY');
1803: fnd_message.set_token ('TOKEN1', l_kdetails_rec.contract_number);
1804: fnd_message.set_token ('TOKEN2',
1805: l_kdetails_rec.contract_number_modifier);
1806:
1807: IF p_sent2_email IS NULL
1808: THEN

Line 1814: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_EMAIL');

1810: x_qto_email => l_qto_email);
1811:
1812: IF l_qto_email = okc_api.g_miss_char
1813: THEN
1814: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_EMAIL');
1815: fnd_msg_pub.ADD;
1816: RAISE fnd_api.g_exc_error;
1817: END IF;
1818:

Line 1819: fnd_message.set_token ('TOKEN3', l_qto_email);

1815: fnd_msg_pub.ADD;
1816: RAISE fnd_api.g_exc_error;
1817: END IF;
1818:
1819: fnd_message.set_token ('TOKEN3', l_qto_email);
1820: ELSE
1821: fnd_message.set_token ('TOKEN3', p_sent2_email);
1822: END IF;
1823:

Line 1821: fnd_message.set_token ('TOKEN3', p_sent2_email);

1817: END IF;
1818:
1819: fnd_message.set_token ('TOKEN3', l_qto_email);
1820: ELSE
1821: fnd_message.set_token ('TOKEN3', p_sent2_email);
1822: END IF;
1823:
1824: l_interaction_body := fnd_message.get;
1825: ELSE

Line 1824: l_interaction_body := fnd_message.get;

1820: ELSE
1821: fnd_message.set_token ('TOKEN3', p_sent2_email);
1822: END IF;
1823:
1824: l_interaction_body := fnd_message.get;
1825: ELSE
1826: l_interaction_body := p_msg_body;
1827: END IF;
1828:

Line 1986: FUNCTION get_fnd_message RETURN VARCHAR2 IS

1982: );
1983: x_return_status := g_ret_sts_unexp_error;
1984: END log_interaction;
1985:
1986: FUNCTION get_fnd_message RETURN VARCHAR2 IS
1987: i NUMBER := 0;
1988: l_return_status VARCHAR2(1);
1989: l_msg_count NUMBER;
1990: l_msg_data VARCHAR2(2000);

Line 2010: END get_fnd_message;

2006: l_mesg := l_mesg || ':' || i || ':' || l_msg_data;
2007: END IF;
2008: END LOOP;
2009: RETURN l_mesg;
2010: END get_fnd_message;
2011:
2012: PROCEDURE validate_autoreminder_k (
2013: p_chr_id IN VARCHAR2,
2014: x_is_eligible OUT NOCOPY VARCHAR2,

Line 2195: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');

2191: FETCH l_k_details_csr INTO l_k_details_rec;
2192: IF l_k_details_csr%NOTFOUND THEN
2193: CLOSE l_k_details_csr;
2194: x_is_eligible := 'N';
2195: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
2196: FND_MESSAGE.SET_TOKEN('HDR_ID',p_chr_id);
2197: FND_MSG_PUB.add;
2198: ELSE
2199: CLOSE l_k_details_csr;

Line 2196: FND_MESSAGE.SET_TOKEN('HDR_ID',p_chr_id);

2192: IF l_k_details_csr%NOTFOUND THEN
2193: CLOSE l_k_details_csr;
2194: x_is_eligible := 'N';
2195: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
2196: FND_MESSAGE.SET_TOKEN('HDR_ID',p_chr_id);
2197: FND_MSG_PUB.add;
2198: ELSE
2199: CLOSE l_k_details_csr;
2200: IF l_k_details_rec.contract_number_modifier IS NULL THEN

Line 2240: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_K_IN_APPROVAL_PROCESS');

2236:
2237: -- If error, skip this contract and proceed with the next
2238: IF x_return_status <> g_ret_sts_success OR l_wf_name IS NOT NULL THEN
2239: x_is_eligible := 'N';
2240: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_K_IN_APPROVAL_PROCESS');
2241: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2242: FND_MSG_PUB.add;
2243: END IF;
2244: END IF;

Line 2241: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

2237: -- If error, skip this contract and proceed with the next
2238: IF x_return_status <> g_ret_sts_success OR l_wf_name IS NOT NULL THEN
2239: x_is_eligible := 'N';
2240: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_K_IN_APPROVAL_PROCESS');
2241: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2242: FND_MSG_PUB.add;
2243: END IF;
2244: END IF;
2245:

Line 2303: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_TEMPLATE_SET');

2299: l_template_set_id||')');
2300: END IF;
2301: IF l_template_set_id IS NULL THEN
2302: x_is_eligible := 'N';
2303: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_TEMPLATE_SET');
2304: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2305: FND_MSG_PUB.add;
2306: END IF;
2307: EXCEPTION

Line 2304: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

2300: END IF;
2301: IF l_template_set_id IS NULL THEN
2302: x_is_eligible := 'N';
2303: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_TEMPLATE_SET');
2304: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2305: FND_MSG_PUB.add;
2306: END IF;
2307: EXCEPTION
2308: WHEN OTHERS THEN

Line 2415: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QUAL_NOTICE');

2411: END IF;
2412:
2413: IF NVL(x_quote_id, x_cover_id) IS NULL THEN
2414: x_is_eligible := 'N';
2415: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QUAL_NOTICE');
2416: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2417: FND_MSG_PUB.add;
2418: END IF;
2419: END IF;

Line 2416: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);

2412:
2413: IF NVL(x_quote_id, x_cover_id) IS NULL THEN
2414: x_is_eligible := 'N';
2415: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QUAL_NOTICE');
2416: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2417: FND_MSG_PUB.add;
2418: END IF;
2419: END IF;
2420:

Line 2441: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QTO_EMAIL');

2437: x_qto_email||')');
2438: END IF;
2439: IF x_qto_email IS NULL OR x_qto_email = okc_api.g_miss_char THEN
2440: x_is_eligible := 'N';
2441: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QTO_EMAIL');
2442: FND_MSG_PUB.add;
2443: END IF;
2444: EXCEPTION
2445: WHEN OTHERS THEN

Line 2494: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_EMAIL_NOT_FOUND');

2490: 'x_sender: ' ||x_sender);
2491: END IF;
2492: IF x_sender IS NULL THEN
2493: x_is_eligible := 'N';
2494: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_EMAIL_NOT_FOUND');
2495: FND_MSG_PUB.add;
2496: END IF;
2497: END IF;
2498:

Line 2502: fnd_message.set_name ('OKS','OKS_AREM_RNT_SUBJECT');

2498:
2499: -- STEP 6: Get email subject
2500: IF x_sender IS NOT NULL AND x_is_eligible = 'Y' THEN
2501: IF l_report_type = 'RMN' THEN
2502: fnd_message.set_name ('OKS','OKS_AREM_RNT_SUBJECT');
2503: ELSE
2504: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2505: END IF;
2506: fnd_message.set_token('TOKEN1',l_concat_k_number);

Line 2504: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');

2500: IF x_sender IS NOT NULL AND x_is_eligible = 'Y' THEN
2501: IF l_report_type = 'RMN' THEN
2502: fnd_message.set_name ('OKS','OKS_AREM_RNT_SUBJECT');
2503: ELSE
2504: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2505: END IF;
2506: fnd_message.set_token('TOKEN1',l_concat_k_number);
2507: x_subject := fnd_message.get;
2508: END IF;

Line 2506: fnd_message.set_token('TOKEN1',l_concat_k_number);

2502: fnd_message.set_name ('OKS','OKS_AREM_RNT_SUBJECT');
2503: ELSE
2504: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2505: END IF;
2506: fnd_message.set_token('TOKEN1',l_concat_k_number);
2507: x_subject := fnd_message.get;
2508: END IF;
2509:
2510: -- if attachment name is NULL then get template name from xdo_templates_vl

Line 2507: x_subject := fnd_message.get;

2503: ELSE
2504: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2505: END IF;
2506: fnd_message.set_token('TOKEN1',l_concat_k_number);
2507: x_subject := fnd_message.get;
2508: END IF;
2509:
2510: -- if attachment name is NULL then get template name from xdo_templates_vl
2511: IF x_is_eligible = 'Y' AND x_quote_id IS NOT NULL AND

Line 2518: x_msg_data := get_fnd_message;

2514: FETCH csr_xdo_template_name INTO x_attachment_name;
2515: CLOSE csr_xdo_template_name;
2516: END IF;
2517: IF x_is_eligible = 'N' THEN
2518: x_msg_data := get_fnd_message;
2519: END IF;
2520:
2521: EXCEPTION
2522: WHEN FND_API.G_EXC_ERROR THEN

Line 2524: x_msg_data := get_fnd_message;

2520:
2521: EXCEPTION
2522: WHEN FND_API.G_EXC_ERROR THEN
2523: x_is_eligible := 'N';
2524: x_msg_data := get_fnd_message;
2525: WHEN OTHERS THEN
2526: x_is_eligible := 'N';
2527: x_msg_data := 'Exception: ' || SQLERRM;
2528: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 3294: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');

3290: RAISE fnd_api.g_exc_error;
3291: END IF; -- l_user_id is not null
3292: ELSE -- l_test_user <> 0 ,3
3293: -- error, raise exception
3294: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
3295: fnd_message.set_token ('RETURN_VAL', l_test_user);
3296: fnd_msg_pub.ADD;
3297: -- log file
3298: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_TEST_USER_ERROR');

Line 3295: fnd_message.set_token ('RETURN_VAL', l_test_user);

3291: END IF; -- l_user_id is not null
3292: ELSE -- l_test_user <> 0 ,3
3293: -- error, raise exception
3294: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
3295: fnd_message.set_token ('RETURN_VAL', l_test_user);
3296: fnd_msg_pub.ADD;
3297: -- log file
3298: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_TEST_USER_ERROR');
3299: fnd_file.put_line (fnd_file.LOG, 'l_test_user: ' ||

Line 3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');

3359: fnd_file.put_line (fnd_file.LOG,'FND Party Name: '||l_fnd_party_name);
3360: fnd_file.put_line (fnd_file.LOG,'FND Party ID: '||l_fnd_party_id);
3361:
3362: -- set error message
3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);

Line 3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);

3360: fnd_file.put_line (fnd_file.LOG,'FND Party ID: '||l_fnd_party_id);
3361:
3362: -- set error message
3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);

Line 3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);

3361:
3362: -- set error message
3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);

Line 3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);

3362: -- set error message
3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);

Line 3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);

3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3371: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286

Line 3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);

3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3371: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3372: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286

Line 3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);

3365: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3371: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3372: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3373: fnd_msg_pub.ADD;

Line 3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);

3366: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3371: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3372: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3373: fnd_msg_pub.ADD;
3374:

Line 3371: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286

3367: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3371: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3372: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3373: fnd_msg_pub.ADD;
3374:
3375: -- log file

Line 3372: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286

3368: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3369: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3370: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3371: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3372: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3373: fnd_msg_pub.ADD;
3374:
3375: -- log file
3376: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_PERSON_PARTY_ERROR');

Line 3388: fnd_message.set_name ('OKS', 'OKS_SSO_USER_EXPIRED');

3384:
3385: RETURN;
3386: ELSE
3387: -- fnd user has expired RAISE exception;
3388: fnd_message.set_name ('OKS', 'OKS_SSO_USER_EXPIRED');
3389: fnd_message.set_token ('USER_NAME', UPPER (TRIM (p_user_name)));
3390: fnd_msg_pub.ADD;
3391: -- log file
3392: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_USER_EXPIRED ');

Line 3389: fnd_message.set_token ('USER_NAME', UPPER (TRIM (p_user_name)));

3385: RETURN;
3386: ELSE
3387: -- fnd user has expired RAISE exception;
3388: fnd_message.set_name ('OKS', 'OKS_SSO_USER_EXPIRED');
3389: fnd_message.set_token ('USER_NAME', UPPER (TRIM (p_user_name)));
3390: fnd_msg_pub.ADD;
3391: -- log file
3392: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_USER_EXPIRED ');
3393: RAISE fnd_api.g_exc_error;