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.OKC_REP_UTIL_PVT dependencies on FND_MSG_PUB

Line 148: FND_MSG_PUB.initialize;

144: '102: Contract Type is: ' || p_contract_type);
145: END IF;
146: -- Initialize message list if p_init_msg_list is set to TRUE.
147: IF FND_API.to_Boolean( p_init_msg_list ) THEN
148: FND_MSG_PUB.initialize;
149: END IF;
150:
151: IF (p_contract_type = 'PA_BLANKET')
152: OR (p_contract_type = 'PA_CONTRACT')

Line 320: FND_MSG_PUB.Count_And_Get(

316: g_module || l_api_name || '.exception',
317: '115: Leaving check_contract_access:FND_API.G_EXC_ERROR Exception');
318: END IF;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: FND_MSG_PUB.Count_And_Get(
321: p_count => x_msg_count,
322: p_data => x_msg_data
323: );
324:

Line 358: FND_MSG_PUB.Count_And_Get(

354: g_module || l_api_name || '.exception',
355: '116:Leaving check_contract_access:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
356: END IF;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: FND_MSG_PUB.Count_And_Get(
359: p_count => x_msg_count,
360: p_data => x_msg_data
361: );
362:

Line 403: FND_MSG_PUB.Count_And_Get(

399: p_token1_value => sqlcode,
400: p_token2 => G_SQLERRM_TOKEN,
401: p_token2_value => sqlerrm);
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: FND_MSG_PUB.Count_And_Get(
404: p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407: END check_contract_access_external;

Line 536: FND_MSG_PUB.initialize;

532: '102: Fucntion Name is: ' || p_function_name);
533: END IF;
534: -- Initialize message list if p_init_msg_list is set to TRUE.
535: IF FND_API.to_Boolean( p_init_msg_list ) THEN
536: FND_MSG_PUB.initialize;
537: END IF;
538:
539: OPEN contract_csr(p_contract_id);
540: FETCH contract_csr INTO l_org_id, l_owner_id, l_use_acl_flag, l_contract_type;

Line 716: FND_MSG_PUB.Count_And_Get(

712: g_module || l_api_name || '.exception',
713: '115: Leaving check_contract_access:FND_API.G_EXC_ERROR Exception');
714: END IF;
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MSG_PUB.Count_And_Get(
717: p_count => x_msg_count,
718: p_data => x_msg_data
719: );
720:

Line 739: FND_MSG_PUB.Count_And_Get(

735: g_module || l_api_name || '.exception',
736: '116:Leaving check_contract_access:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
737: END IF;
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: FND_MSG_PUB.Count_And_Get(
740: p_count => x_msg_count,
741: p_data => x_msg_data
742: );
743:

Line 768: FND_MSG_PUB.Count_And_Get(

764: p_token1_value => sqlcode,
765: p_token2 => G_SQLERRM_TOKEN,
766: p_token2_value => sqlerrm);
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: FND_MSG_PUB.Count_And_Get(
769: p_count => x_msg_count,
770: p_data => x_msg_data
771: );
772: END check_contract_access;

Line 984: FND_MSG_PUB.initialize;

980: END IF;
981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list ) THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986:
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988:

Line 1069: FND_MSG_PUB.Count_And_Get(

1065: g_module || l_api_name || '.exception',
1066: 'Leaving change_contract_status:FND_API.G_EXC_ERROR Exception');
1067: END IF;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get(
1070: p_count => x_msg_count,
1071: p_data => x_msg_data
1072: );
1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1080: FND_MSG_PUB.Count_And_Get(

1076: g_module || l_api_name || '.exception',
1077: 'Leaving change_contract_status: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1078: END IF;
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: FND_MSG_PUB.Count_And_Get(
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );
1084: WHEN OTHERS THEN

Line 1097: FND_MSG_PUB.Count_And_Get(

1093: p_token1_value => sqlcode,
1094: p_token2 => G_SQLERRM_TOKEN,
1095: p_token2_value => sqlerrm);
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: FND_MSG_PUB.Count_And_Get(
1098: p_count => x_msg_count,
1099: p_data => x_msg_data
1100: );
1101: END change_contract_status;

Line 1163: FND_MSG_PUB.initialize;

1159: '305: Note is: ' || p_note);
1160: END IF;
1161: -- Initialize message list if p_init_msg_list is set to TRUE.
1162: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1163: FND_MSG_PUB.initialize;
1164: END IF;
1165:
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167:

Line 1215: FND_MSG_PUB.Count_And_Get(

1211: g_module || l_api_name || '.exception',
1212: 'Leaving add_approval_hist_record:FND_API.G_EXC_ERROR Exception');
1213: END IF;
1214: x_return_status := FND_API.G_RET_STS_ERROR;
1215: FND_MSG_PUB.Count_And_Get(
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1226: FND_MSG_PUB.Count_And_Get(

1222: g_module || l_api_name || '.exception',
1223: 'Leaving add_approval_hist_record: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226: FND_MSG_PUB.Count_And_Get(
1227: p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );
1230: WHEN OTHERS THEN

Line 1243: FND_MSG_PUB.Count_And_Get(

1239: p_token1_value => sqlcode,
1240: p_token2 => G_SQLERRM_TOKEN,
1241: p_token2_value => sqlerrm);
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: FND_MSG_PUB.Count_And_Get(
1244: p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );
1247: END add_approval_hist_record;

Line 1434: FND_MSG_PUB.initialize;

1430: END IF;
1431:
1432: -- Initialize message list if p_init_msg_list is set to TRUE.
1433: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:
1437: -- Initialize API return status to success
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1476: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1472: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1473: 'x_error_code: ' || x_error_code);
1474: END IF;
1475:
1476: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1477: p_data => x_msg_data);
1478:
1479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1480: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1522: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1518: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1519: 'x_error_code: ' || x_error_code);
1520: END IF;
1521:
1522: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1523: p_data => x_msg_data);
1524:
1525: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1526: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1569: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1565: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1566: 'x_error_code: ' || x_error_code);
1567: END IF;
1568:
1569: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1570: p_data => x_msg_data);
1571:
1572: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1573: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1602: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1603: 'x_error_code: ' || x_error_code);
1604: END IF;
1605:
1606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1607: p_data => x_msg_data);
1608:
1609: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1610: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1637: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1633: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1634: 'x_error_code: ' || x_error_code);
1635: END IF;
1636:
1637: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1638: p_data => x_msg_data);
1639:
1640: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1695: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1691: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1692: 'x_error_code: ' || x_error_code);
1693: END IF;
1694:
1695: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1696: p_data => x_msg_data);
1697:
1698: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1699: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1731: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1732: 'x_error_code: ' || x_error_code);
1733: END IF;
1734:
1735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1736: p_data => x_msg_data);
1737:
1738: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1739: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1787: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1783: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1784: 'x_error_code: ' || x_error_code);
1785: END IF;
1786:
1787: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1788: p_data => x_msg_data);
1789:
1790: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1791: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1825: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1821: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1822: 'x_error_code: ' || x_error_code);
1823: END IF;
1824:
1825: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1826: p_data => x_msg_data);
1827:
1828: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1862: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1858: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1859: 'x_error_code: ' || x_error_code);
1860: END IF;
1861:
1862: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1863: p_data => x_msg_data);
1864:
1865: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1866: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1916: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1912: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1913: 'x_error_code: ' || x_error_code);
1914: END IF;
1915:
1916: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1917: p_data => x_msg_data);
1918:
1919: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1920: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1954: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1950: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1951: 'x_error_code: ' || x_error_code);
1952: END IF;
1953:
1954: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1958: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2021: 'Leaving validate_contract_party:FND_API.G_EXC_ERROR Exception');
2022: END IF;
2023:
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2026: p_data => x_msg_data);
2027:
2028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2029:

Line 2074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2070: 'Leaving validate_contract_party:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2071: END IF;
2072:
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2075: p_data => x_msg_data);
2076:
2077: WHEN OTHERS THEN
2078:

Line 2129: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2125: p_token1_value => sqlcode,
2126: p_token2 => G_SQLERRM_TOKEN,
2127: p_token2_value => sqlerrm);
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2130: p_data => x_msg_data);
2131:
2132: END validate_contract_party;
2133:

Line 2254: FND_MSG_PUB.initialize;

2250: END IF;
2251:
2252: -- Initialize message list if p_init_msg_list is set to TRUE.
2253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2254: FND_MSG_PUB.initialize;
2255: END IF;
2256:
2257: -- Initialize API return status to success
2258: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2286: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2287: 'x_error_code: ' || x_error_code);
2288: END IF;
2289:
2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2291: p_data => x_msg_data);
2292:
2293: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2294: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2336: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2332: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2333: 'x_error_code: ' || x_error_code);
2334: END IF;
2335:
2336: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2337: p_data => x_msg_data);
2338:
2339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2375: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2371: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2372: 'x_error_code: ' || x_error_code);
2373: END IF;
2374:
2375: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2376: p_data => x_msg_data);
2377:
2378: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2379: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2413: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2409: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2410: 'x_error_code: ' || x_error_code);
2411: END IF;
2412:
2413: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2414: p_data => x_msg_data);
2415:
2416: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 2459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2455: 'Leaving validate_party_contact:FND_API.G_EXC_ERROR Exception');
2456: END IF;
2457:
2458: x_return_status := FND_API.G_RET_STS_ERROR;
2459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2460: p_data => x_msg_data);
2461:
2462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2463:

Line 2484: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2480: 'Leaving validate_party_contact:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2481: END IF;
2482:
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2485: p_data => x_msg_data);
2486:
2487: WHEN OTHERS THEN
2488:

Line 2515: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2511: p_token1_value => sqlcode,
2512: p_token2 => G_SQLERRM_TOKEN,
2513: p_token2_value => sqlerrm);
2514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2515: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2516: p_data => x_msg_data);
2517:
2518: END validate_party_contact;
2519:

Line 2607: FND_MSG_PUB.initialize;

2603: END IF;
2604:
2605: -- Initialize message list if p_init_msg_list is set to TRUE.
2606: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2607: FND_MSG_PUB.initialize;
2608: END IF;
2609:
2610: -- Initialize API return status to success
2611: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2670: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2666: 'Leaving populate_import_errors:FND_API.G_EXC_ERROR Exception');
2667: END IF;
2668:
2669: x_return_status := FND_API.G_RET_STS_ERROR;
2670: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2671: p_data => x_msg_data);
2672:
2673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2674:

Line 2690: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2686: 'Leaving populate_import_errors:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2687: END IF;
2688:
2689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2690: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2691: p_data => x_msg_data);
2692:
2693: WHEN OTHERS THEN
2694:

Line 2716: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2712: p_token1_value => sqlcode,
2713: p_token2 => G_SQLERRM_TOKEN,
2714: p_token2_value => sqlerrm);
2715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2716: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2717: p_data => x_msg_data);
2718:
2719: END populate_import_errors;
2720:

Line 2805: FND_MSG_PUB.initialize;

2801: END IF;
2802:
2803: -- Initialize message list if p_init_msg_list is set to TRUE.
2804: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2805: FND_MSG_PUB.initialize;
2806: END IF;
2807:
2808: -- Initialize API return status to success
2809: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3033: 'Leaving '||l_api_name||':FND_API.G_EXC_ERROR Exception');
3034: END IF;
3035:
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3038: p_data => x_msg_data);
3039:
3040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3041: IF IMPORT_DOCUMENTS_CSR%ISOPEN THEN

Line 3054: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3050: 'Leaving '||l_api_name||':FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3051: END IF;
3052:
3053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3054: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3055: p_data => x_msg_data);
3056:
3057: WHEN OTHERS THEN
3058: IF IMPORT_DOCUMENTS_CSR%ISOPEN THEN

Line 3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3073: p_token1_value => sqlcode,
3074: p_token2 => G_SQLERRM_TOKEN,
3075: p_token2_value => sqlerrm);
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3078: p_data => x_msg_data);
3079:
3080: END validate_import_documents;
3081:

Line 3168: FND_MSG_PUB.initialize;

3164: END IF;
3165:
3166: -- Initialize message list if p_init_msg_list is set to TRUE.
3167: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3168: FND_MSG_PUB.initialize;
3169: END IF;
3170:
3171: -- Initialize API return status to success
3172: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3532: 'Leaving '||l_api_name||':FND_API.G_EXC_ERROR Exception');
3533: END IF;
3534:
3535: x_return_status := FND_API.G_RET_STS_ERROR;
3536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3537: p_data => x_msg_data);
3538:
3539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3540:

Line 3555: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3551: 'Leaving '||l_api_name||':FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3552: END IF;
3553:
3554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3555: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3556: p_data => x_msg_data);
3557:
3558: WHEN OTHERS THEN
3559:

Line 3580: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

3576: p_token1_value => sqlcode,
3577: p_token2 => G_SQLERRM_TOKEN,
3578: p_token2_value => sqlerrm);
3579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3580: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3581: p_data => x_msg_data);
3582:
3583: END validate_import_parties;
3584:

Line 3802: FND_MSG_PUB.initialize;

3798: END IF;
3799:
3800: -- Initialize message list if p_init_msg_list is set to TRUE.
3801: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3802: FND_MSG_PUB.initialize;
3803: END IF;
3804:
3805: -- Initialize API return status to success
3806: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

4752: 'Leaving '||l_api_name||':FND_API.G_EXC_ERROR Exception');
4753: END IF;
4754:
4755: x_return_status := FND_API.G_RET_STS_ERROR;
4756: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4757: p_data => x_msg_data);
4758:
4759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4760: IF CONTRACT_ID_CSR%ISOPEN THEN

Line 4815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

4811: 'Leaving '||l_api_name||':FND_API.G_EXC_UNEXPECTED_ERROR Exception');
4812: END IF;
4813:
4814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4816: p_data => x_msg_data);
4817:
4818: WHEN OTHERS THEN
4819: IF CONTRACT_ID_CSR%ISOPEN THEN

Line 4882: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

4878: p_token1_value => sqlcode,
4879: p_token2 => G_SQLERRM_TOKEN,
4880: p_token2_value => sqlerrm);
4881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4882: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
4883: p_data => x_msg_data);
4884:
4885: END validate_import_contracts;
4886:

Line 4973: FND_MSG_PUB.initialize;

4969: END IF;
4970:
4971: -- Initialize message list if p_init_msg_list is set to TRUE.
4972: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4973: FND_MSG_PUB.initialize;
4974: END IF;
4975:
4976: -- Initialize API return status to success
4977: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5227:
5228: x_return_status := FND_API.G_RET_STS_ERROR;
5229: x_number_inserted := 0;
5230:
5231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5232: p_data => x_msg_data);
5233:
5234: --rollback to the
5235: ROLLBACK TO before_insert_contracts;

Line 5301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5297:
5298: x_return_status := FND_API.G_RET_STS_ERROR;
5299: x_number_inserted := 0;
5300:
5301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5302: p_data => x_msg_data);
5303:
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305:

Line 5321: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5317:
5318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5319: x_number_inserted := 0;
5320:
5321: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5322: p_data => x_msg_data);
5323:
5324: WHEN OTHERS THEN
5325:

Line 5347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5343: p_token2_value => sqlerrm);
5344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5345: x_number_inserted := 0;
5346:
5347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5348: p_data => x_msg_data);
5349:
5350: END insert_prod_data;
5351:

Line 5401: FND_MSG_PUB.initialize;

5397: END IF;
5398:
5399: -- Initialize message list if p_init_msg_list is set to TRUE.
5400: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5401: FND_MSG_PUB.initialize;
5402: END IF;
5403:
5404: -- Initialize API return status to success
5405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5467: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5463: END IF;
5464:
5465: x_return_status := FND_API.G_RET_STS_ERROR;
5466:
5467: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5468: p_data => x_msg_data);
5469:
5470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5471: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5478: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5474: END IF;
5475:
5476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5477:
5478: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5479: p_data => x_msg_data);
5480:
5481: WHEN OTHERS THEN
5482: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5495: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5491: p_token2 => G_SQLERRM_TOKEN,
5492: p_token2_value => sqlerrm);
5493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5494:
5495: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5496: p_data => x_msg_data);
5497:
5498:
5499: END validate_and_insert_contracts;

Line 5588: FND_MSG_PUB.initialize;

5584: END IF;
5585:
5586: -- Initialize message list if p_init_msg_list is set to TRUE.
5587: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5588: FND_MSG_PUB.initialize;
5589: END IF;
5590:
5591: -- Initialize API return status to success
5592: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5661: 'Leaving delete_import_contract:FND_API.G_EXC_ERROR Exception');
5662: END IF;
5663:
5664: x_return_status := FND_API.G_RET_STS_ERROR;
5665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5666: p_data => x_msg_data);
5667:
5668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5669:

Line 5676: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5672: 'Leaving delete_import_contract:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
5673: END IF;
5674:
5675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5676: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5677: p_data => x_msg_data);
5678:
5679: WHEN OTHERS THEN
5680:

Line 5693: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

5689: p_token1_value => sqlcode,
5690: p_token2 => G_SQLERRM_TOKEN,
5691: p_token2_value => sqlerrm);
5692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5693: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5694: p_data => x_msg_data);
5695:
5696: END delete_import_contract;
5697:

Line 6178: FND_MSG_PUB.initialize;

6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6175: END IF;
6176: -- Initialize message list if p_init_msg_list is set to TRUE.
6177: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6178: FND_MSG_PUB.initialize;
6179: END IF;
6180:
6181: -- Initialize API return status to success
6182: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6205: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

6201: END IF; -- (l_contact_email_address <> NULL)
6202: END LOOP;
6203:
6204: -- Standard call to get message count and if count is 1, get message info.
6205: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6206:
6207: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6209: 'Leaving OKC_REP_UTIL_PVT.get_vendor_userlist');

Line 6228: FND_MSG_PUB.Count_And_Get(

6224: IF (vendor_email_csr%ISOPEN) THEN
6225: CLOSE vendor_email_csr ;
6226: END IF;
6227: x_return_status := FND_API.G_RET_STS_ERROR;
6228: FND_MSG_PUB.Count_And_Get(
6229: p_count => x_msg_count,
6230: p_data => x_msg_data
6231: );
6232:

Line 6247: FND_MSG_PUB.Count_And_Get(

6243: IF (vendor_email_csr%ISOPEN) THEN
6244: CLOSE vendor_email_csr ;
6245: END IF;
6246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6247: FND_MSG_PUB.Count_And_Get(
6248: p_count => x_msg_count,
6249: p_data => x_msg_data
6250: );
6251:

Line 6272: FND_MSG_PUB.Count_And_Get(

6268: p_token1_value => sqlcode,
6269: p_token2 => G_SQLERRM_TOKEN,
6270: p_token2_value => sqlerrm);
6271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6272: FND_MSG_PUB.Count_And_Get(
6273: p_count => x_msg_count,
6274: p_data => x_msg_data
6275: );
6276: END get_vendor_userlist;

Line 6346: FND_MSG_PUB.initialize;

6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: END IF;
6344: -- Initialize message list if p_init_msg_list is set to TRUE.
6345: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6346: FND_MSG_PUB.initialize;
6347: END IF;
6348:
6349: -- Initialize API return status to success
6350: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6372: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

6368: END IF; -- (l_contact_email_address <> NULL)
6369: END LOOP;
6370:
6371: -- Standard call to get message count and if count is 1, get message info.
6372: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6373:
6374: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6375: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6376: 'Leaving OKC_REP_UTIL_PVT.get_customer_userlist');

Line 6394: FND_MSG_PUB.Count_And_Get(

6390: IF (tca_email_csr%ISOPEN) THEN
6391: CLOSE tca_email_csr ;
6392: END IF;
6393: x_return_status := FND_API.G_RET_STS_ERROR;
6394: FND_MSG_PUB.Count_And_Get(
6395: p_count => x_msg_count,
6396: p_data => x_msg_data
6397: );
6398:

Line 6412: FND_MSG_PUB.Count_And_Get(

6408: IF (tca_email_csr%ISOPEN) THEN
6409: CLOSE tca_email_csr ;
6410: END IF;
6411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6412: FND_MSG_PUB.Count_And_Get(
6413: p_count => x_msg_count,
6414: p_data => x_msg_data
6415: );
6416:

Line 6436: FND_MSG_PUB.Count_And_Get(

6432: p_token1_value => sqlcode,
6433: p_token2 => G_SQLERRM_TOKEN,
6434: p_token2_value => sqlerrm);
6435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6436: FND_MSG_PUB.Count_And_Get(
6437: p_count => x_msg_count,
6438: p_data => x_msg_data
6439: );
6440: END get_customer_userlist;

Line 6504: FND_MSG_PUB.initialize;

6500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6501: END IF;
6502: -- Initialize message list if p_init_msg_list is set to TRUE.
6503: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6504: FND_MSG_PUB.initialize;
6505: END IF;
6506:
6507: -- Initialize API return status to success
6508: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6534: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

6530: END IF;
6531:
6532:
6533: -- Standard call to get message count and if count is 1, get message info.
6534: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6535:
6536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6537: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6538: 'Leaving OKC_REP_UTIL_PVT.get_external_userlist');

Line 6550: FND_MSG_PUB.Count_And_Get(

6546: g_module || l_api_name,
6547: 'Leaving get_external_userlist:FND_API.G_EXC_ERROR Exception');
6548: END IF;
6549: x_return_status := FND_API.G_RET_STS_ERROR;
6550: FND_MSG_PUB.Count_And_Get(
6551: p_count => x_msg_count,
6552: p_data => x_msg_data
6553: );
6554:

Line 6562: FND_MSG_PUB.Count_And_Get(

6558: g_module || l_api_name,
6559: 'Leaving get_external_userlist:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
6560: END IF;
6561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6562: FND_MSG_PUB.Count_And_Get(
6563: p_count => x_msg_count,
6564: p_data => x_msg_data
6565: );
6566:

Line 6580: FND_MSG_PUB.Count_And_Get(

6576: p_token1_value => sqlcode,
6577: p_token2 => G_SQLERRM_TOKEN,
6578: p_token2_value => sqlerrm);
6579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6580: FND_MSG_PUB.Count_And_Get(
6581: p_count => x_msg_count,
6582: p_data => x_msg_data
6583: );
6584: END get_external_userlist;

Line 6658: FND_MSG_PUB.initialize;

6654: END IF;
6655:
6656: -- Initialize message list if p_init_msg_list is set to TRUE.
6657: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6658: FND_MSG_PUB.initialize;
6659: END IF;
6660:
6661: -- Initialize API return status to success
6662: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

6704: CLOSE l_contract_updatable_csr;
6705: END IF; -- (l_contract_updatable_csr%NOTFOUND)
6706: END IF; -- (p_validation_string is NULL)
6707: -- Standard call to get message count and if count is 1, get message info.
6708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6709: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6710: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6711: '110: Leaving OKC_REP_UTIL_PVT.ok_to_commit');
6712: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 7108: FND_MSG_PUB.initialize;

7104: END IF;
7105:
7106: -- Initialize message list if p_init_msg_list is set to TRUE.
7107: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7108: FND_MSG_PUB.initialize;
7109: END IF;
7110:
7111: -- Initialize API return status to success
7112: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

7151:
7152: COMMIT WORK;
7153:
7154: -- Standard call to get message count and if count is 1, get message info.
7155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7156:
7157: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7158: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7159: 'Leaving OKC_REP_UTIL_PVT.sync_con_header_attributes');

Line 7248: FND_MSG_PUB.Count_And_Get(

7244: p_token1_value => sqlcode,
7245: p_token2 => G_SQLERRM_TOKEN,
7246: p_token2_value => sqlerrm);
7247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7248: FND_MSG_PUB.Count_And_Get(
7249: p_count => x_msg_count,
7250: p_data => x_msg_data
7251: );
7252: