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_MSG_PUB

Line 98: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

94: x_qto_email := l_email_address;
95: EXCEPTION
96: WHEN OTHERS
97: THEN
98: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
99: END;
100:
101: -- Traverse thru the global defaults and get the template set id
102: -- associated for this contract

Line 647: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

643: );
644: END IF;
645:
646: x_return_status := okc_api.g_ret_sts_unexp_error;
647: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
648: END create_user;
649:
650: PROCEDURE update_contract_status (
651: p_chr_id IN VARCHAR2,

Line 697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

693: EXCEPTION
694: WHEN OTHERS
695: THEN
696: x_return_status := okc_api.g_ret_sts_unexp_error;
697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
698: END;
699:
700: PROCEDURE update_contract_status (
701: p_chr_id IN NUMBER,

Line 1010: fnd_msg_pub.count_and_get (p_encoded => 'F',

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
1013: );
1014:

Line 1036: fnd_msg_pub.count_and_get (p_encoded => 'F',

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
1039: );
1040:

Line 1076: fnd_msg_pub.add_exc_msg (g_pkg_name,

1072: SQLCODE ||
1073: ', sqlerrm = ' ||
1074: SQLERRM
1075: );
1076: fnd_msg_pub.add_exc_msg (g_pkg_name,
1077: l_api_name,
1078: SUBSTR (SQLERRM,
1079: 1,
1080: 240

Line 1085: fnd_msg_pub.count_and_get (p_encoded => 'F',

1081: )
1082: );
1083: END IF;
1084:
1085: fnd_msg_pub.count_and_get (p_encoded => 'F',
1086: p_count => l_msg_count,
1087: p_data => l_msg_data
1088: );
1089: x_return_status := g_ret_sts_unexp_error;

Line 1140: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1136: EXCEPTION
1137: WHEN OTHERS
1138: THEN
1139: x_return_status := okc_api.g_ret_sts_error;
1140: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1141: END;
1142:
1143: PROCEDURE get_duration (
1144: p_start_date IN DATE,

Line 1175: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1171: EXCEPTION
1172: WHEN OTHERS
1173: THEN
1174: x_duration := okc_api.g_miss_num;
1175: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1176: END;
1177:
1178: PROCEDURE update_renewal_status (
1179: p_chr_id IN NUMBER,

Line 1228: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1224: x_return_status := l_return_status;
1225: WHEN OTHERS
1226: THEN
1227: x_return_status := l_return_status;
1228: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1229: END;
1230:
1231: FUNCTION get_product_name (
1232: p_lse_id IN NUMBER,

Line 1735: fnd_msg_pub.initialize;

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:
1738: -- Initialize API return status to success
1739: x_return_status := g_ret_sts_success;

Line 1755: fnd_msg_pub.ADD;

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

Line 1790: fnd_msg_pub.ADD;

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:
1794: -- Get Salesrep user name which will be used as performer

Line 1864: fnd_msg_pub.ADD;

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

Line 1892: fnd_msg_pub.ADD;

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

Line 1981: fnd_msg_pub.count_and_get (p_encoded => 'F',

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
1984: );
1985:

Line 2007: fnd_msg_pub.count_and_get (p_encoded => 'F',

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
2010: );
2011:

Line 2047: fnd_msg_pub.add_exc_msg (g_pkg_name,

2043: SQLCODE ||
2044: ', sqlerrm = ' ||
2045: SQLERRM
2046: );
2047: fnd_msg_pub.add_exc_msg (g_pkg_name,
2048: l_api_name,
2049: SUBSTR (SQLERRM,
2050: 1,
2051: 240

Line 2056: fnd_msg_pub.count_and_get (p_encoded => 'F',

2052: )
2053: );
2054: END IF;
2055:
2056: fnd_msg_pub.count_and_get (p_encoded => 'F',
2057: p_count => x_msg_count,
2058: p_data => x_msg_data
2059: );
2060: x_return_status := g_ret_sts_unexp_error;

Line 2071: FOR i in 1..fnd_msg_pub.count_msg

2067: l_msg_data VARCHAR2(2000);
2068: l_msg_index_out NUMBER;
2069: l_mesg VARCHAR2(2000) := NULL;
2070: BEGIN
2071: FOR i in 1..fnd_msg_pub.count_msg
2072: LOOP
2073: fnd_msg_pub.get
2074: (
2075: p_msg_index => i,

Line 2073: fnd_msg_pub.get

2069: l_mesg VARCHAR2(2000) := NULL;
2070: BEGIN
2071: FOR i in 1..fnd_msg_pub.count_msg
2072: LOOP
2073: fnd_msg_pub.get
2074: (
2075: p_msg_index => i,
2076: p_encoded => 'F',
2077: p_data => l_msg_data,

Line 2275: FND_MSG_PUB.initialize;

2271: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
2272: 'Entered with p_chr_id '||p_chr_id);
2273: END IF;
2274: -- Initialize message stack
2275: FND_MSG_PUB.initialize;
2276:
2277: OPEN l_k_details_csr (TO_NUMBER (p_chr_id));
2278: FETCH l_k_details_csr INTO l_k_details_rec;
2279: IF l_k_details_csr%NOTFOUND THEN

Line 2284: FND_MSG_PUB.add;

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
2288: l_concat_k_number := l_k_details_rec.contract_number;

Line 2340: FND_MSG_PUB.add;

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:
2344: -- STEP 2: Get template set

Line 2403: FND_MSG_PUB.add;

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
2407: x_is_eligible := 'N';

Line 2409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2405: EXCEPTION
2406: WHEN OTHERS THEN
2407: x_is_eligible := 'N';
2408: x_return_status := g_ret_sts_unexp_error;
2409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2410: END;
2411: END IF;
2412:
2413: -- STEP 3: Check if the contract qualifies for a reminder / cancelation notice

Line 2515: FND_MSG_PUB.add;

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:
2519: -- STEP 4: Get Quote to contact email address

Line 2540: FND_MSG_PUB.add;

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
2544: x_is_eligible := 'N';

Line 2546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2542: EXCEPTION
2543: WHEN OTHERS THEN
2544: x_is_eligible := 'N';
2545: x_return_status := g_ret_sts_unexp_error;
2546: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2547: END;
2548: END IF;
2549:
2550: -- STEP 5: Get Sender email address

Line 2593: FND_MSG_PUB.add;

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:
2597: -- STEP 6: Get email subject

Line 2626: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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);
2627: END validate_autoreminder_k;
2628:
2629: /*added for bug10018402*/
2630: /*following function is used to issue explicit commit once we make a call to

Line 3479: fnd_msg_pub.ADD;

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: ' ||
3483: l_test_user);

Line 3570: fnd_msg_pub.ADD;

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');
3574: RAISE fnd_api.g_exc_error;

Line 3589: fnd_msg_pub.ADD;

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;
3593: END IF;

Line 3609: fnd_msg_pub.count_and_get (p_encoded => 'F',

3605: (fnd_file.LOG,
3606: '---------------------------------------------------------- ');
3607: fnd_file.put_line (fnd_file.LOG, ' ');
3608: -- Standard call to get message count and if count is 1, get message info.
3609: fnd_msg_pub.count_and_get (p_encoded => 'F',
3610: p_count => x_msg_count,
3611: p_data => x_msg_data
3612: );
3613:

Line 3645: fnd_msg_pub.count_and_get (p_encoded => 'F',

3641:
3642: fnd_file.put_line (fnd_file.LOG, '2000: Leaving create_sso_user');
3643:
3644: x_return_status := g_ret_sts_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

Line 3666: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3662:
3663: fnd_file.put_line (fnd_file.LOG, '3000: Leaving create_sso_user');
3664:
3665: x_return_status := g_ret_sts_unexp_error;
3666: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3667: fnd_msg_pub.count_and_get (p_encoded => 'F',
3668: p_count => x_msg_count,
3669: p_data => x_msg_data
3670: );

Line 3667: fnd_msg_pub.count_and_get (p_encoded => 'F',

3663: fnd_file.put_line (fnd_file.LOG, '3000: Leaving create_sso_user');
3664:
3665: x_return_status := g_ret_sts_unexp_error;
3666: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3667: fnd_msg_pub.count_and_get (p_encoded => 'F',
3668: p_count => x_msg_count,
3669: p_data => x_msg_data
3670: );
3671: WHEN OTHERS

Line 3688: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3684:
3685: fnd_file.put_line (fnd_file.LOG, '4000: Leaving create_sso_user');
3686:
3687: x_return_status := g_ret_sts_error;
3688: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3689: fnd_msg_pub.count_and_get (p_encoded => 'F',
3690: p_count => x_msg_count,
3691: p_data => x_msg_data
3692: );

Line 3689: fnd_msg_pub.count_and_get (p_encoded => 'F',

3685: fnd_file.put_line (fnd_file.LOG, '4000: Leaving create_sso_user');
3686:
3687: x_return_status := g_ret_sts_error;
3688: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3689: fnd_msg_pub.count_and_get (p_encoded => 'F',
3690: p_count => x_msg_count,
3691: p_data => x_msg_data
3692: );
3693: END create_sso_user;