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 933: fnd_msg_pub.count_and_get (p_encoded => 'F',

929: END IF;
930: EXCEPTION
931: WHEN fnd_api.g_exc_error
932: THEN
933: fnd_msg_pub.count_and_get (p_encoded => 'F',
934: p_count => l_msg_count,
935: p_data => l_msg_data
936: );
937:

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

955:
956: x_return_status := g_ret_sts_error;
957: WHEN fnd_api.g_exc_unexpected_error
958: THEN
959: fnd_msg_pub.count_and_get (p_encoded => 'F',
960: p_count => l_msg_count,
961: p_data => l_msg_data
962: );
963:

Line 999: fnd_msg_pub.add_exc_msg (g_pkg_name,

995: SQLCODE ||
996: ', sqlerrm = ' ||
997: SQLERRM
998: );
999: fnd_msg_pub.add_exc_msg (g_pkg_name,
1000: l_api_name,
1001: SUBSTR (SQLERRM,
1002: 1,
1003: 240

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

1004: )
1005: );
1006: END IF;
1007:
1008: fnd_msg_pub.count_and_get (p_encoded => 'F',
1009: p_count => l_msg_count,
1010: p_data => l_msg_data
1011: );
1012: x_return_status := g_ret_sts_unexp_error;

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

1059: EXCEPTION
1060: WHEN OTHERS
1061: THEN
1062: x_return_status := okc_api.g_ret_sts_error;
1063: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1064: END;
1065:
1066: PROCEDURE get_duration (
1067: p_start_date IN DATE,

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

1094: EXCEPTION
1095: WHEN OTHERS
1096: THEN
1097: x_duration := okc_api.g_miss_num;
1098: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1099: END;
1100:
1101: PROCEDURE update_renewal_status (
1102: p_chr_id IN NUMBER,

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

1147: x_return_status := l_return_status;
1148: WHEN OTHERS
1149: THEN
1150: x_return_status := l_return_status;
1151: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1152: END;
1153:
1154: FUNCTION get_product_name (
1155: p_lse_id IN NUMBER,

Line 1658: fnd_msg_pub.initialize;

1654:
1655: -- Initialize message list if p_init_msg_list is set to TRUE.
1656: IF fnd_api.to_boolean (p_init_msg_list)
1657: THEN
1658: fnd_msg_pub.initialize;
1659: END IF;
1660:
1661: -- Initialize API return status to success
1662: x_return_status := g_ret_sts_success;

Line 1678: fnd_msg_pub.ADD;

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

Line 1713: fnd_msg_pub.ADD;

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

Line 1787: fnd_msg_pub.ADD;

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

Line 1815: fnd_msg_pub.ADD;

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

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

1900: END IF;
1901: EXCEPTION
1902: WHEN fnd_api.g_exc_error
1903: THEN
1904: fnd_msg_pub.count_and_get (p_encoded => 'F',
1905: p_count => x_msg_count,
1906: p_data => x_msg_data
1907: );
1908:

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

1926:
1927: x_return_status := g_ret_sts_error;
1928: WHEN fnd_api.g_exc_unexpected_error
1929: THEN
1930: fnd_msg_pub.count_and_get (p_encoded => 'F',
1931: p_count => x_msg_count,
1932: p_data => x_msg_data
1933: );
1934:

Line 1970: fnd_msg_pub.add_exc_msg (g_pkg_name,

1966: SQLCODE ||
1967: ', sqlerrm = ' ||
1968: SQLERRM
1969: );
1970: fnd_msg_pub.add_exc_msg (g_pkg_name,
1971: l_api_name,
1972: SUBSTR (SQLERRM,
1973: 1,
1974: 240

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

1975: )
1976: );
1977: END IF;
1978:
1979: fnd_msg_pub.count_and_get (p_encoded => 'F',
1980: p_count => x_msg_count,
1981: p_data => x_msg_data
1982: );
1983: x_return_status := g_ret_sts_unexp_error;

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

1990: l_msg_data VARCHAR2(2000);
1991: l_msg_index_out NUMBER;
1992: l_mesg VARCHAR2(2000) := NULL;
1993: BEGIN
1994: FOR i in 1..fnd_msg_pub.count_msg
1995: LOOP
1996: fnd_msg_pub.get
1997: (
1998: p_msg_index => i,

Line 1996: fnd_msg_pub.get

1992: l_mesg VARCHAR2(2000) := NULL;
1993: BEGIN
1994: FOR i in 1..fnd_msg_pub.count_msg
1995: LOOP
1996: fnd_msg_pub.get
1997: (
1998: p_msg_index => i,
1999: p_encoded => 'F',
2000: p_data => l_msg_data,

Line 2188: FND_MSG_PUB.initialize;

2184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
2185: 'Entered with p_chr_id '||p_chr_id);
2186: END IF;
2187: -- Initialize message stack
2188: FND_MSG_PUB.initialize;
2189:
2190: OPEN l_k_details_csr (TO_NUMBER (p_chr_id));
2191: FETCH l_k_details_csr INTO l_k_details_rec;
2192: IF l_k_details_csr%NOTFOUND THEN

Line 2197: FND_MSG_PUB.add;

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

Line 2242: FND_MSG_PUB.add;

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

Line 2305: FND_MSG_PUB.add;

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

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

2307: EXCEPTION
2308: WHEN OTHERS THEN
2309: x_is_eligible := 'N';
2310: x_return_status := g_ret_sts_unexp_error;
2311: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2312: END;
2313: END IF;
2314:
2315: -- STEP 3: Check if the contract qualifies for a reminder / cancelation notice

Line 2417: FND_MSG_PUB.add;

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

Line 2442: FND_MSG_PUB.add;

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

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

2444: EXCEPTION
2445: WHEN OTHERS THEN
2446: x_is_eligible := 'N';
2447: x_return_status := g_ret_sts_unexp_error;
2448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2449: END;
2450: END IF;
2451:
2452: -- STEP 5: Get Sender email address

Line 2495: FND_MSG_PUB.add;

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

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

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);
2529: END validate_autoreminder_k;
2530:
2531: /*
2532:

Line 3296: fnd_msg_pub.ADD;

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

Line 3373: fnd_msg_pub.ADD;

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

Line 3390: fnd_msg_pub.ADD;

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

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

3406: (fnd_file.LOG,
3407: '---------------------------------------------------------- ');
3408: fnd_file.put_line (fnd_file.LOG, ' ');
3409: -- Standard call to get message count and if count is 1, get message info.
3410: fnd_msg_pub.count_and_get (p_encoded => 'F',
3411: p_count => x_msg_count,
3412: p_data => x_msg_data
3413: );
3414:

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

3442:
3443: fnd_file.put_line (fnd_file.LOG, '2000: Leaving create_sso_user');
3444:
3445: x_return_status := g_ret_sts_error;
3446: fnd_msg_pub.count_and_get (p_encoded => 'F',
3447: p_count => x_msg_count,
3448: p_data => x_msg_data
3449: );
3450: WHEN fnd_api.g_exc_unexpected_error

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

3463:
3464: fnd_file.put_line (fnd_file.LOG, '3000: Leaving create_sso_user');
3465:
3466: x_return_status := g_ret_sts_unexp_error;
3467: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3468: fnd_msg_pub.count_and_get (p_encoded => 'F',
3469: p_count => x_msg_count,
3470: p_data => x_msg_data
3471: );

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

3464: fnd_file.put_line (fnd_file.LOG, '3000: Leaving create_sso_user');
3465:
3466: x_return_status := g_ret_sts_unexp_error;
3467: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3468: fnd_msg_pub.count_and_get (p_encoded => 'F',
3469: p_count => x_msg_count,
3470: p_data => x_msg_data
3471: );
3472: WHEN OTHERS

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

3485:
3486: fnd_file.put_line (fnd_file.LOG, '4000: Leaving create_sso_user');
3487:
3488: x_return_status := g_ret_sts_error;
3489: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3490: fnd_msg_pub.count_and_get (p_encoded => 'F',
3491: p_count => x_msg_count,
3492: p_data => x_msg_data
3493: );

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

3486: fnd_file.put_line (fnd_file.LOG, '4000: Leaving create_sso_user');
3487:
3488: x_return_status := g_ret_sts_error;
3489: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3490: fnd_msg_pub.count_and_get (p_encoded => 'F',
3491: p_count => x_msg_count,
3492: p_data => x_msg_data
3493: );
3494: END create_sso_user;