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 1753: fnd_message.set_name (g_app_name, 'OKS_INVD_CONTRACT_ID');

1749: CLOSE l_kdetails_csr;
1750:
1751: IF l_rownotfound
1752: THEN
1753: fnd_message.set_name (g_app_name, 'OKS_INVD_CONTRACT_ID');
1754: fnd_message.set_token ('HDR_ID', p_chr_id);
1755: fnd_msg_pub.ADD;
1756: RAISE fnd_api.g_exc_error;
1757: END IF;

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

1750:
1751: IF l_rownotfound
1752: THEN
1753: fnd_message.set_name (g_app_name, 'OKS_INVD_CONTRACT_ID');
1754: fnd_message.set_token ('HDR_ID', p_chr_id);
1755: fnd_msg_pub.ADD;
1756: RAISE fnd_api.g_exc_error;
1757: END IF;
1758:

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

1785: END IF;
1786:
1787: IF l_party_id IS NULL
1788: THEN
1789: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_CONTACT');
1790: fnd_msg_pub.ADD;
1791: RAISE fnd_api.g_exc_error;
1792: END IF;
1793:

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

1859:
1860: IF l_rownotfound
1861: OR l_salesrep_resource_id IS NULL
1862: THEN
1863: fnd_message.set_name (g_app_name, 'OKS_INTERACTION_FAILED');
1864: fnd_msg_pub.ADD;
1865: RAISE fnd_api.g_exc_error;
1866: END IF;
1867:

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

1866: END IF;
1867:
1868: IF p_subject IS NULL
1869: THEN
1870: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_SUBJECT');
1871: l_subject := fnd_message.get;
1872: ELSE
1873: l_subject := p_subject;
1874: END IF;

Line 1871: l_subject := fnd_message.get;

1867:
1868: IF p_subject IS NULL
1869: THEN
1870: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_SUBJECT');
1871: l_subject := fnd_message.get;
1872: ELSE
1873: l_subject := p_subject;
1874: END IF;
1875:

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

1875:
1876: IF p_msg_body IS NULL
1877: THEN
1878: -- assemble interaction history body
1879: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_MSG_BODY');
1880: fnd_message.set_token ('TOKEN1', l_kdetails_rec.contract_number);
1881: fnd_message.set_token ('TOKEN2',
1882: l_kdetails_rec.contract_number_modifier);
1883:

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

1876: IF p_msg_body IS NULL
1877: THEN
1878: -- assemble interaction history body
1879: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_MSG_BODY');
1880: fnd_message.set_token ('TOKEN1', l_kdetails_rec.contract_number);
1881: fnd_message.set_token ('TOKEN2',
1882: l_kdetails_rec.contract_number_modifier);
1883:
1884: IF p_sent2_email IS NULL

Line 1881: fnd_message.set_token ('TOKEN2',

1877: THEN
1878: -- assemble interaction history body
1879: fnd_message.set_name ('OKS', 'OKS_INT_HISTORY_MSG_BODY');
1880: fnd_message.set_token ('TOKEN1', l_kdetails_rec.contract_number);
1881: fnd_message.set_token ('TOKEN2',
1882: l_kdetails_rec.contract_number_modifier);
1883:
1884: IF p_sent2_email IS NULL
1885: THEN

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

1887: x_qto_email => l_qto_email);
1888:
1889: IF l_qto_email = okc_api.g_miss_char
1890: THEN
1891: fnd_message.set_name (g_app_name, 'OKS_NO_QTO_EMAIL');
1892: fnd_msg_pub.ADD;
1893: RAISE fnd_api.g_exc_error;
1894: END IF;
1895:

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

1892: fnd_msg_pub.ADD;
1893: RAISE fnd_api.g_exc_error;
1894: END IF;
1895:
1896: fnd_message.set_token ('TOKEN3', l_qto_email);
1897: ELSE
1898: fnd_message.set_token ('TOKEN3', p_sent2_email);
1899: END IF;
1900:

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

1894: END IF;
1895:
1896: fnd_message.set_token ('TOKEN3', l_qto_email);
1897: ELSE
1898: fnd_message.set_token ('TOKEN3', p_sent2_email);
1899: END IF;
1900:
1901: l_interaction_body := fnd_message.get;
1902: ELSE

Line 1901: l_interaction_body := fnd_message.get;

1897: ELSE
1898: fnd_message.set_token ('TOKEN3', p_sent2_email);
1899: END IF;
1900:
1901: l_interaction_body := fnd_message.get;
1902: ELSE
1903: l_interaction_body := p_msg_body;
1904: END IF;
1905:

Line 2063: FUNCTION get_fnd_message RETURN VARCHAR2 IS

2059: );
2060: x_return_status := g_ret_sts_unexp_error;
2061: END log_interaction;
2062:
2063: FUNCTION get_fnd_message RETURN VARCHAR2 IS
2064: i NUMBER := 0;
2065: l_return_status VARCHAR2(1);
2066: l_msg_count NUMBER;
2067: l_msg_data VARCHAR2(2000);

Line 2087: END get_fnd_message;

2083: l_mesg := l_mesg || ':' || i || ':' || l_msg_data;
2084: END IF;
2085: END LOOP;
2086: RETURN l_mesg;
2087: END get_fnd_message;
2088:
2089: PROCEDURE validate_autoreminder_k (
2090: p_chr_id IN VARCHAR2,
2091: x_is_eligible OUT NOCOPY VARCHAR2,

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

2278: FETCH l_k_details_csr INTO l_k_details_rec;
2279: IF l_k_details_csr%NOTFOUND THEN
2280: CLOSE l_k_details_csr;
2281: x_is_eligible := 'N';
2282: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
2283: FND_MESSAGE.SET_TOKEN('HDR_ID',p_chr_id);
2284: FND_MSG_PUB.add;
2285: ELSE
2286: CLOSE l_k_details_csr;

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

2279: IF l_k_details_csr%NOTFOUND THEN
2280: CLOSE l_k_details_csr;
2281: x_is_eligible := 'N';
2282: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
2283: FND_MESSAGE.SET_TOKEN('HDR_ID',p_chr_id);
2284: FND_MSG_PUB.add;
2285: ELSE
2286: CLOSE l_k_details_csr;
2287: IF l_k_details_rec.contract_number_modifier IS NULL THEN

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

2334:
2335: -- If error, skip this contract and proceed with the next
2336: IF x_return_status <> g_ret_sts_success OR l_wf_name IS NOT NULL OR l_cust_accept_flag = 'Y' THEN
2337: x_is_eligible := 'N';
2338: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_K_IN_APPROVAL_PROCESS');
2339: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2340: FND_MSG_PUB.add;
2341: END IF;
2342: END IF;

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

2335: -- If error, skip this contract and proceed with the next
2336: IF x_return_status <> g_ret_sts_success OR l_wf_name IS NOT NULL OR l_cust_accept_flag = 'Y' THEN
2337: x_is_eligible := 'N';
2338: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_K_IN_APPROVAL_PROCESS');
2339: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2340: FND_MSG_PUB.add;
2341: END IF;
2342: END IF;
2343:

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

2397: l_template_set_id||')');
2398: END IF;
2399: IF l_template_set_id IS NULL THEN
2400: x_is_eligible := 'N';
2401: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_TEMPLATE_SET');
2402: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2403: FND_MSG_PUB.add;
2404: END IF;
2405: EXCEPTION

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

2398: END IF;
2399: IF l_template_set_id IS NULL THEN
2400: x_is_eligible := 'N';
2401: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_TEMPLATE_SET');
2402: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2403: FND_MSG_PUB.add;
2404: END IF;
2405: EXCEPTION
2406: WHEN OTHERS THEN

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

2509: END IF;
2510:
2511: IF NVL(x_quote_id, x_cover_id) IS NULL THEN
2512: x_is_eligible := 'N';
2513: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QUAL_NOTICE');
2514: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2515: FND_MSG_PUB.add;
2516: END IF;
2517: END IF;

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

2510:
2511: IF NVL(x_quote_id, x_cover_id) IS NULL THEN
2512: x_is_eligible := 'N';
2513: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QUAL_NOTICE');
2514: FND_MESSAGE.SET_TOKEN('K_NUMBER',l_concat_k_number);
2515: FND_MSG_PUB.add;
2516: END IF;
2517: END IF;
2518:

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

2535: x_qto_email||')');
2536: END IF;
2537: IF x_qto_email IS NULL OR x_qto_email = okc_api.g_miss_char THEN
2538: x_is_eligible := 'N';
2539: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NO_QTO_EMAIL');
2540: FND_MSG_PUB.add;
2541: END IF;
2542: EXCEPTION
2543: WHEN OTHERS THEN

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

2588: 'x_sender: ' ||x_sender);
2589: END IF;
2590: IF x_sender IS NULL THEN
2591: x_is_eligible := 'N';
2592: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_EMAIL_NOT_FOUND');
2593: FND_MSG_PUB.add;
2594: END IF;
2595: END IF;
2596:

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

2596:
2597: -- STEP 6: Get email subject
2598: IF x_sender IS NOT NULL AND x_is_eligible = 'Y' THEN
2599: IF l_report_type = 'RMN' THEN
2600: fnd_message.set_name ('OKS','OKS_AREM_RNT_SUBJECT');
2601: ELSE
2602: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2603: END IF;
2604: fnd_message.set_token('TOKEN1',l_concat_k_number);

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

2598: IF x_sender IS NOT NULL AND x_is_eligible = 'Y' THEN
2599: IF l_report_type = 'RMN' THEN
2600: fnd_message.set_name ('OKS','OKS_AREM_RNT_SUBJECT');
2601: ELSE
2602: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2603: END IF;
2604: fnd_message.set_token('TOKEN1',l_concat_k_number);
2605: x_subject := fnd_message.get;
2606: END IF;

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

2600: fnd_message.set_name ('OKS','OKS_AREM_RNT_SUBJECT');
2601: ELSE
2602: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2603: END IF;
2604: fnd_message.set_token('TOKEN1',l_concat_k_number);
2605: x_subject := fnd_message.get;
2606: END IF;
2607:
2608: -- if attachment name is NULL then get template name from xdo_templates_vl

Line 2605: x_subject := fnd_message.get;

2601: ELSE
2602: fnd_message.set_name ('OKS','OKS_AREM_CNT_SUBJECT');
2603: END IF;
2604: fnd_message.set_token('TOKEN1',l_concat_k_number);
2605: x_subject := fnd_message.get;
2606: END IF;
2607:
2608: -- if attachment name is NULL then get template name from xdo_templates_vl
2609: IF x_is_eligible = 'Y' AND x_quote_id IS NOT NULL AND

Line 2616: x_msg_data := get_fnd_message;

2612: FETCH csr_xdo_template_name INTO x_attachment_name;
2613: CLOSE csr_xdo_template_name;
2614: END IF;
2615: IF x_is_eligible = 'N' THEN
2616: x_msg_data := get_fnd_message;
2617: END IF;
2618:
2619: EXCEPTION
2620: WHEN FND_API.G_EXC_ERROR THEN

Line 2622: x_msg_data := get_fnd_message;

2618:
2619: EXCEPTION
2620: WHEN FND_API.G_EXC_ERROR THEN
2621: x_is_eligible := 'N';
2622: x_msg_data := get_fnd_message;
2623: WHEN OTHERS THEN
2624: x_is_eligible := 'N';
2625: x_msg_data := 'Exception: ' || SQLERRM;
2626: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

3473: RAISE fnd_api.g_exc_error;
3474: END IF; -- l_user_id is not null
3475: ELSE -- l_test_user <> 0 ,3
3476: -- error, raise exception
3477: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
3478: fnd_message.set_token ('RETURN_VAL', l_test_user);
3479: fnd_msg_pub.ADD;
3480: -- log file
3481: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_TEST_USER_ERROR');

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

3474: END IF; -- l_user_id is not null
3475: ELSE -- l_test_user <> 0 ,3
3476: -- error, raise exception
3477: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
3478: fnd_message.set_token ('RETURN_VAL', l_test_user);
3479: fnd_msg_pub.ADD;
3480: -- log file
3481: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_TEST_USER_ERROR');
3482: fnd_file.put_line (fnd_file.LOG, 'l_test_user: ' ||

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

3556: fnd_file.put_line (fnd_file.LOG,'FND Party Name: '||l_fnd_party_name);
3557: fnd_file.put_line (fnd_file.LOG,'FND Party ID: '||l_fnd_party_id);
3558:
3559: -- set error message
3560: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3561: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3562: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);

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

3557: fnd_file.put_line (fnd_file.LOG,'FND Party ID: '||l_fnd_party_id);
3558:
3559: -- set error message
3560: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3561: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3562: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);

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

3558:
3559: -- set error message
3560: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3561: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3562: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);

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

3559: -- set error message
3560: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3561: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3562: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3567: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);

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

3560: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3561: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3562: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3567: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3568: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286

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

3561: fnd_message.set_token ('OKS_USER_NAME', p_user_name);
3562: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3567: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3568: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3569: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286

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

3562: fnd_message.set_token ('OKS_PARTY_ID', l_oks_party_id);
3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3567: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3568: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3569: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3570: fnd_msg_pub.ADD;

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

3563: fnd_message.set_token ('OKS_PARTY_NAME', l_oks_party_name);
3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3567: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3568: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3569: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3570: fnd_msg_pub.ADD;
3571:

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

3564: fnd_message.set_token ('FND_PARTY_ID', l_fnd_party_id);
3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3567: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3568: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3569: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3570: fnd_msg_pub.ADD;
3571:
3572: -- log file

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

3565: fnd_message.set_token ('FND_PARTY_NAME', l_fnd_party_name);
3566: fnd_message.set_token ('OKS_PERSON_PARTY_ID', l_person_party_id);
3567: fnd_message.set_token ('FND_PERSON_PARTY_ID', l_fnd_person_party_id);
3568: fnd_message.set_token ('OKS_PERSON_PARTY_NAME', l_oks_per_party_name); -- bug 6338286
3569: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3570: fnd_msg_pub.ADD;
3571:
3572: -- log file
3573: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_PERSON_PARTY_ERROR');

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

3583:
3584: RETURN;
3585: ELSE
3586: -- fnd user has expired RAISE exception;
3587: fnd_message.set_name ('OKS', 'OKS_SSO_USER_EXPIRED');
3588: fnd_message.set_token ('USER_NAME', UPPER (TRIM (p_user_name)));
3589: fnd_msg_pub.ADD;
3590: -- log file
3591: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_USER_EXPIRED ');

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

3584: RETURN;
3585: ELSE
3586: -- fnd user has expired RAISE exception;
3587: fnd_message.set_name ('OKS', 'OKS_SSO_USER_EXPIRED');
3588: fnd_message.set_token ('USER_NAME', UPPER (TRIM (p_user_name)));
3589: fnd_msg_pub.ADD;
3590: -- log file
3591: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_USER_EXPIRED ');
3592: RAISE fnd_api.g_exc_error;