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.OKS_AUTO_REMINDER dependencies on FND_API

Line 11: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;

7: := 'oks.plsql.' ||
8: g_pkg_name ||
9: '.';
10: g_application_id CONSTANT NUMBER := 515; -- OKS Application
11: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
12: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
13: g_ret_sts_success CONSTANT VARCHAR2 (1)
14: := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1)

Line 12: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;

8: g_pkg_name ||
9: '.';
10: g_application_id CONSTANT NUMBER := 515; -- OKS Application
11: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
12: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
13: g_ret_sts_success CONSTANT VARCHAR2 (1)
14: := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1)
16: := fnd_api.g_ret_sts_error;

Line 14: := fnd_api.g_ret_sts_success;

10: g_application_id CONSTANT NUMBER := 515; -- OKS Application
11: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
12: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
13: g_ret_sts_success CONSTANT VARCHAR2 (1)
14: := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1)
16: := fnd_api.g_ret_sts_error;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
18: := fnd_api.g_ret_sts_unexp_error;

Line 16: := fnd_api.g_ret_sts_error;

12: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
13: g_ret_sts_success CONSTANT VARCHAR2 (1)
14: := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1)
16: := fnd_api.g_ret_sts_error;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
18: := fnd_api.g_ret_sts_unexp_error;
19:
20: FUNCTION get_org_context

Line 18: := fnd_api.g_ret_sts_unexp_error;

14: := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1)
16: := fnd_api.g_ret_sts_error;
17: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
18: := fnd_api.g_ret_sts_unexp_error;
19:
20: FUNCTION get_org_context
21: RETURN NUMBER
22: IS

Line 315: RAISE FND_API.G_EXC_ERROR;

311: Note : Call FND_CRYPTO for generating the password (track bug 4358822)
312: FND_USER_RESP_GROUPS_API.insert_assignment with responsibility as 'OKS_ERN_WEB'
313: ELSE -- l_test_user <> 0 ,3
314: -- error, raise exception
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: */
319: PROCEDURE create_user (

Line 431: x_return_status := fnd_api.g_ret_sts_success;

427: );
428: END IF;
429:
430: -- Initialize API return status to success
431: x_return_status := fnd_api.g_ret_sts_success;
432:
433: OPEN csr_qtc_person_party_id;
434:
435: FETCH csr_qtc_person_party_id

Line 551: RAISE fnd_api.g_exc_error;

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
555: fnd_message.set_name ('OKS', 'OKS_SSO_USER_ID_NULL');

Line 557: RAISE fnd_api.g_exc_error;

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
561: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');

Line 564: RAISE fnd_api.g_exc_error;

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 := '******';
568: IF l_fnd_person_party_id IS NULL

Line 582: RAISE fnd_api.g_exc_error;

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;
586: END IF; -- person_party_id check

Line 602: WHEN fnd_api.g_exc_error

598: l_api_name
599: );
600: END IF;
601: EXCEPTION
602: WHEN fnd_api.g_exc_error
603: THEN
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
605: THEN
606: fnd_log.STRING (fnd_log.level_procedure,

Line 617: WHEN fnd_api.g_exc_unexpected_error

613: );
614: END IF;
615:
616: x_return_status := g_ret_sts_error;
617: WHEN fnd_api.g_exc_unexpected_error
618: THEN
619: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
620: THEN
621: fnd_log.STRING (fnd_log.level_procedure,

Line 868: RAISE fnd_api.g_exc_unexpected_error;

864: END IF;
865:
866: IF l_return_status = g_ret_sts_unexp_error
867: THEN
868: RAISE fnd_api.g_exc_unexpected_error;
869: ELSIF l_return_status = g_ret_sts_error
870: THEN
871: RAISE fnd_api.g_exc_error;
872: END IF;

Line 871: RAISE fnd_api.g_exc_error;

867: THEN
868: RAISE fnd_api.g_exc_unexpected_error;
869: ELSIF l_return_status = g_ret_sts_error
870: THEN
871: RAISE fnd_api.g_exc_error;
872: END IF;
873:
874: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
875: THEN

Line 925: RAISE fnd_api.g_exc_unexpected_error;

921: END IF;
922:
923: IF l_return_status = g_ret_sts_unexp_error
924: THEN
925: RAISE fnd_api.g_exc_unexpected_error;
926: ELSIF l_return_status = g_ret_sts_error
927: THEN
928: RAISE fnd_api.g_exc_error;
929: END IF;

Line 928: RAISE fnd_api.g_exc_error;

924: THEN
925: RAISE fnd_api.g_exc_unexpected_error;
926: ELSIF l_return_status = g_ret_sts_error
927: THEN
928: RAISE fnd_api.g_exc_error;
929: END IF;
930: END LOOP;
931: ELSE
932: FOR l_lines_rec IN l_lines_csr

Line 990: RAISE fnd_api.g_exc_unexpected_error;

986: END IF;
987:
988: IF l_return_status = g_ret_sts_unexp_error
989: THEN
990: RAISE fnd_api.g_exc_unexpected_error;
991: ELSIF l_return_status = g_ret_sts_error
992: THEN
993: RAISE fnd_api.g_exc_error;
994: END IF;

Line 993: RAISE fnd_api.g_exc_error;

989: THEN
990: RAISE fnd_api.g_exc_unexpected_error;
991: ELSIF l_return_status = g_ret_sts_error
992: THEN
993: RAISE fnd_api.g_exc_error;
994: END IF;
995: END LOOP;
996: END IF; /*IF NVL(l_status_code,'X') = 'ENTERED' THEN*/
997:

Line 1008: WHEN fnd_api.g_exc_error

1004: 'OKC_CONTRACT_PUB.update_contract_line - loop end'
1005: );
1006: END IF;
1007: EXCEPTION
1008: WHEN fnd_api.g_exc_error
1009: THEN
1010: fnd_msg_pub.count_and_get (p_encoded => 'F',
1011: p_count => l_msg_count,
1012: p_data => l_msg_data

Line 1034: WHEN fnd_api.g_exc_unexpected_error

1030: );
1031: END IF;
1032:
1033: x_return_status := g_ret_sts_error;
1034: WHEN fnd_api.g_exc_unexpected_error
1035: THEN
1036: fnd_msg_pub.count_and_get (p_encoded => 'F',
1037: p_count => l_msg_count,
1038: p_data => l_msg_data

Line 1733: IF fnd_api.to_boolean (p_init_msg_list)

1729: );
1730: END IF;
1731:
1732: -- Initialize message list if p_init_msg_list is set to TRUE.
1733: IF fnd_api.to_boolean (p_init_msg_list)
1734: THEN
1735: fnd_msg_pub.initialize;
1736: END IF;
1737:

Line 1756: RAISE fnd_api.g_exc_error;

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:
1759: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1760: THEN

Line 1791: RAISE fnd_api.g_exc_error;

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:
1794: -- Get Salesrep user name which will be used as performer
1795: IF fnd_log.level_event >= fnd_log.g_current_runtime_level

Line 1845: RAISE fnd_api.g_exc_unexpected_error;

1841: END IF;
1842:
1843: IF x_return_status = g_ret_sts_unexp_error
1844: THEN
1845: RAISE fnd_api.g_exc_unexpected_error;
1846: ELSIF x_return_status = g_ret_sts_error
1847: THEN
1848: RAISE fnd_api.g_exc_error;
1849: END IF;

Line 1848: RAISE fnd_api.g_exc_error;

1844: THEN
1845: RAISE fnd_api.g_exc_unexpected_error;
1846: ELSIF x_return_status = g_ret_sts_error
1847: THEN
1848: RAISE fnd_api.g_exc_error;
1849: END IF;
1850:
1851: OPEN l_userres_csr (l_salesrep_id);
1852:

Line 1865: RAISE fnd_api.g_exc_error;

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:
1868: IF p_subject IS NULL
1869: THEN

Line 1893: RAISE fnd_api.g_exc_error;

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:
1896: fnd_message.set_token ('TOKEN3', l_qto_email);
1897: ELSE

Line 1973: RAISE fnd_api.g_exc_unexpected_error;

1969: END IF;
1970:
1971: IF x_return_status = g_ret_sts_unexp_error
1972: THEN
1973: RAISE fnd_api.g_exc_unexpected_error;
1974: ELSIF x_return_status = g_ret_sts_error
1975: THEN
1976: RAISE fnd_api.g_exc_error;
1977: END IF;

Line 1976: RAISE fnd_api.g_exc_error;

1972: THEN
1973: RAISE fnd_api.g_exc_unexpected_error;
1974: ELSIF x_return_status = g_ret_sts_error
1975: THEN
1976: RAISE fnd_api.g_exc_error;
1977: END IF;
1978: EXCEPTION
1979: WHEN fnd_api.g_exc_error
1980: THEN

Line 1979: WHEN fnd_api.g_exc_error

1975: THEN
1976: RAISE fnd_api.g_exc_error;
1977: END IF;
1978: EXCEPTION
1979: WHEN fnd_api.g_exc_error
1980: THEN
1981: fnd_msg_pub.count_and_get (p_encoded => 'F',
1982: p_count => x_msg_count,
1983: p_data => x_msg_data

Line 2005: WHEN fnd_api.g_exc_unexpected_error

2001: );
2002: END IF;
2003:
2004: x_return_status := g_ret_sts_error;
2005: WHEN fnd_api.g_exc_unexpected_error
2006: THEN
2007: fnd_msg_pub.count_and_get (p_encoded => 'F',
2008: p_count => x_msg_count,
2009: p_data => x_msg_data

Line 2360: p_init_msg_list => FND_API.G_FALSE,

2356: -- check if the current contract is ONLINE or MANUAL
2357: OKS_WF_K_PROCESS_PVT.is_online_k_yn
2358: (
2359: p_api_version => 1.0,
2360: p_init_msg_list => FND_API.G_FALSE,
2361: p_contract_id => p_chr_id ,
2362: p_item_key => l_item_key ,
2363: x_online_yn => l_online_yn ,
2364: x_return_status => x_return_status,

Line 2620: WHEN FND_API.G_EXC_ERROR THEN

2616: x_msg_data := get_fnd_message;
2617: END IF;
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';

Line 2710: RAISE FND_API.G_EXC_ERROR;

2706: FND_USER_RESP_GROUPS_API.insert_assignment with responsibility as 'OKS_ERN_WEB'
2707:
2708: ELSE -- l_test_user <> 0 ,3
2709: -- error, raise exception
2710: RAISE FND_API.G_EXC_ERROR;
2711: END IF;
2712:
2713:
2714: CASE B: Record Found in fnd_user

Line 2890: x_return_status := fnd_api.g_ret_sts_success;

2886: (fnd_file.LOG,
2887: '---------------------------------------------------------- ');
2888: fnd_file.put_line (fnd_file.LOG, ' ');
2889: -- Initialize API return status to success
2890: x_return_status := fnd_api.g_ret_sts_success;
2891:
2892: -- Get the Person Party Id and quote_to_contact_id from oks_k_headers_b
2893: OPEN csr_person_party_id;
2894:

Line 3110: RAISE fnd_api.g_exc_error;

3106:
3107: -- log file
3108: fnd_file.put_line (fnd_file.LOG, 'error in fnd_profile.save ');
3109: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3110: RAISE fnd_api.g_exc_error;
3111: END IF; -- l_return_value
3112: END IF; -- assignment_exists
3113: END IF; -- x_user_name IS NOT NULL THEN
3114:

Line 3454: RAISE fnd_api.g_exc_error;

3450: -- log file
3451: fnd_file.put_line (fnd_file.LOG,
3452: 'error in fnd_profile.save ');
3453: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3454: RAISE fnd_api.g_exc_error;
3455: END IF;
3456: ELSE
3457: -- l_user_id is null, raise exception
3458: -- debug log

Line 3473: RAISE fnd_api.g_exc_error;

3469: -- log file
3470: fnd_file.put_line (fnd_file.LOG,
3471: 'l_user_id is null, raise exception ');
3472: fnd_file.put_line (fnd_file.LOG, SQLERRM);
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');

Line 3484: RAISE fnd_api.g_exc_error;

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: ' ||
3483: l_test_user);
3484: RAISE fnd_api.g_exc_error;
3485: END IF; -- l_test_user check
3486: ELSE -- csr_chk_qtc_fnd_user%FOUND
3487: -- check if the above fnd_user is valid
3488: IF SYSDATE BETWEEN l_start_date AND NVL (l_end_date, SYSDATE +

Line 3574: RAISE fnd_api.g_exc_error;

3570: fnd_msg_pub.ADD;
3571:
3572: -- log file
3573: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_PERSON_PARTY_ERROR');
3574: RAISE fnd_api.g_exc_error;
3575: END IF; --profile value check
3576:
3577: END IF; -- person_party_id check
3578:

Line 3592: RAISE fnd_api.g_exc_error;

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;
3593: END IF;
3594: END IF;
3595:
3596: CLOSE csr_chk_qtc_fnd_user;

Line 3628: WHEN fnd_api.g_exc_error

3624: l_api_name
3625: );
3626: END IF;
3627: EXCEPTION
3628: WHEN fnd_api.g_exc_error
3629: THEN
3630: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3631: THEN
3632: fnd_log.STRING (fnd_log.level_procedure,

Line 3649: WHEN fnd_api.g_exc_unexpected_error

3645: fnd_msg_pub.count_and_get (p_encoded => 'F',
3646: p_count => x_msg_count,
3647: p_data => x_msg_data
3648: );
3649: WHEN fnd_api.g_exc_unexpected_error
3650: THEN
3651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
3652: THEN
3653: fnd_log.STRING (fnd_log.level_procedure,