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_CONTRACT_IMP_PVT dependencies on FND_MSG_PUB

Line 153: FND_MSG_PUB.Count_And_Get(

149: p_token2 => G_SQLERRM_TOKEN,
150: p_token2_value => sqlerrm);
151:
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157:

Line 697: FND_MSG_PUB.Count_And_Get(

693: IF (c_get_contract_status%ISOPEN) THEN
694: CLOSE c_get_contract_status ;
695: END IF;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.Count_And_Get(
698: p_count => x_msg_count,
699: p_data => x_msg_data
700: );
701:

Line 754: FND_MSG_PUB.initialize;

750: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
751: 'Entered OKC_REP_CONTRACT_IMP_PVT.'||l_api_name);
752: END IF;
753:
754: FND_MSG_PUB.initialize;
755: retcode := 0;
756:
757: -- First determine whether the orgid passed is a valid org defined in HR Org definitions.
758: IF p_org_name IS NOT NULL THEN

Line 769: FND_MSG_PUB.add;

765: IF (l_debug = 'Y') THEN
766: okc_debug.log('200: Org row not found', 2);
767: END IF;
768: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_INV_ORG');
769: FND_MSG_PUB.add;
770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
771: retcode := 2;
772: return;
773: END IF;

Line 770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

766: okc_debug.log('200: Org row not found', 2);
767: END IF;
768: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_INV_ORG');
769: FND_MSG_PUB.add;
770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
771: retcode := 2;
772: return;
773: END IF;
774: END IF;

Line 788: FND_MSG_PUB.add;

784: IF (l_debug = 'Y') THEN
785: okc_debug.log('300: Contract Type not found', 2);
786: END IF;
787: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_INV_CONTRACT_TYPE');
788: FND_MSG_PUB.add;
789: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
790: retcode := 2;
791: return;
792: END IF;

Line 789: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

785: okc_debug.log('300: Contract Type not found', 2);
786: END IF;
787: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_INV_CONTRACT_TYPE');
788: FND_MSG_PUB.add;
789: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
790: retcode := 2;
791: return;
792: END IF;
793: END IF;

Line 840: FND_MSG_PUB.add;

836: IF (l_debug = 'Y') THEN
837: okc_debug.log('600: No Rows found to import');
838: END IF;
839: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_NO_VALID_ROWS');
840: FND_MSG_PUB.add;
841: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
842: retcode := 1;
843: return;
844: END IF;

Line 841: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

837: okc_debug.log('600: No Rows found to import');
838: END IF;
839: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_NO_VALID_ROWS');
840: FND_MSG_PUB.add;
841: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));
842: retcode := 1;
843: return;
844: END IF;
845:

Line 1374: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1370: COMMIT;
1371: END IF;
1372:
1373: -- Standard call to get message count and if count is 1, get message info.
1374: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1375:
1376: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1377: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1378: 'Leaving OKC_REP_CONTRACT_IMP_PVT.'||l_api_name);

Line 1401: FND_MSG_PUB.Count_And_Get(

1397: IF (c_contract_id_cur%ISOPEN) THEN
1398: CLOSE c_contract_id_cur ;
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_ERROR;
1401: FND_MSG_PUB.Count_And_Get(
1402: p_count => x_msg_count,
1403: p_data => x_msg_data
1404: );
1405:

Line 1424: FND_MSG_PUB.Count_And_Get(

1420: IF (c_contract_id_cur%ISOPEN) THEN
1421: CLOSE c_contract_id_cur ;
1422: END IF;
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.Count_And_Get(
1425: p_count => x_msg_count,
1426: p_data => x_msg_data
1427: );
1428:

Line 1446: FND_MSG_PUB.Count_And_Get(

1442: IF (c_contract_id_cur%ISOPEN) THEN
1443: CLOSE c_contract_id_cur ;
1444: END IF;
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: FND_MSG_PUB.Count_And_Get(
1447: p_count => x_msg_count,
1448: p_data => x_msg_data
1449: );
1450:

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

1581: 'Leaving '||l_api_name||':FND_API.G_EXC_ERROR Exception');
1582: END IF;
1583:
1584: x_return_status := FND_API.G_RET_STS_ERROR;
1585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1586: p_data => x_msg_data);
1587:
1588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1589:

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

1596: 'Leaving '||l_api_name||':FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1597: END IF;
1598:
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1601: p_data => x_msg_data);
1602:
1603: WHEN OTHERS THEN
1604:

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

1617: p_token1_value => sqlcode,
1618: p_token2 => G_SQLERRM_TOKEN,
1619: p_token2_value => sqlerrm);
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1622: p_data => x_msg_data);
1623:
1624: END create_new_contract_version;
1625:

Line 1774: FND_MSG_PUB.Count_And_Get(

1770: IF (c_contract_id_cur%ISOPEN) THEN
1771: CLOSE c_contract_id_cur ;
1772: END IF;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: FND_MSG_PUB.Count_And_Get(
1775: p_count => x_msg_count,
1776: p_data => x_msg_data
1777: );
1778: END create_new_contract_version;

Line 1898: FND_MSG_PUB.initialize;

1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: END IF;
1896: -- Initialize message list if p_init_msg_list is set to TRUE.
1897: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1898: FND_MSG_PUB.initialize;
1899: END IF;
1900:
1901: -- Initialize API return status to success
1902: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2164: COMMIT WORK;
2165: END IF;
2166:
2167: -- Standard call to get message count and if count is 1, get message info.
2168: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2169:
2170: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2172: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');

Line 2192: FND_MSG_PUB.Count_And_Get(

2188: CLOSE c_get_contract_id_csr ;
2189: END IF;
2190: ROLLBACK TO sign_contract_PVT;
2191: x_return_status := FND_API.G_RET_STS_ERROR;
2192: FND_MSG_PUB.Count_And_Get(
2193: p_count => x_msg_count,
2194: p_data => x_msg_data
2195: );
2196:

Line 2212: FND_MSG_PUB.Count_And_Get(

2208: CLOSE c_get_contract_id_csr ;
2209: END IF;
2210: ROLLBACK TO sign_contract_PVT;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2212: FND_MSG_PUB.Count_And_Get(
2213: p_count => x_msg_count,
2214: p_data => x_msg_data
2215: );
2216:

Line 2238: FND_MSG_PUB.Count_And_Get(

2234: IF (c_get_contract_id_csr%ISOPEN) THEN
2235: CLOSE c_get_contract_id_csr ;
2236: END IF;
2237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2238: FND_MSG_PUB.Count_And_Get(
2239: p_count => x_msg_count,
2240: p_data => x_msg_data
2241: );
2242: END Activate_tasks_closeout;

Line 2509: FND_MSG_PUB.Count_And_Get(

2505: IF (c_contract_id_cur%ISOPEN) THEN
2506: CLOSE c_contract_id_cur ;
2507: END IF;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: FND_MSG_PUB.Count_And_Get(
2510: p_count => x_msg_count,
2511: p_data => x_msg_data
2512: );
2513:

Line 2629: FND_MSG_PUB.Count_And_Get(

2625: CLOSE c_get_contract_status ;
2626: END IF;
2627: ROLLBACK TO cancel_contract_PVT;
2628: x_return_status := FND_API.G_RET_STS_ERROR;
2629: FND_MSG_PUB.Count_And_Get(
2630: p_count => x_msg_count,
2631: p_data => x_msg_data
2632: );
2633:

Line 2651: FND_MSG_PUB.Count_And_Get(

2647: IF (c_get_contract_status%ISOPEN) THEN
2648: CLOSE c_get_contract_status ;
2649: END IF;
2650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2651: FND_MSG_PUB.Count_And_Get(
2652: p_count => x_msg_count,
2653: p_data => x_msg_data
2654: );
2655:

Line 2808: FND_MSG_PUB.Count_And_Get(

2804: CLOSE c_contract_id_cur ;
2805: END IF;
2806: ROLLBACK TO cancel_contract_PVT;
2807: x_return_status := FND_API.G_RET_STS_ERROR;
2808: FND_MSG_PUB.Count_And_Get(
2809: p_count => x_msg_count,
2810: p_data => x_msg_data
2811: );
2812:

Line 2830: FND_MSG_PUB.Count_And_Get(

2826: IF (c_contract_id_cur%ISOPEN) THEN
2827: CLOSE c_contract_id_cur ;
2828: END IF;
2829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2830: FND_MSG_PUB.Count_And_Get(
2831: p_count => x_msg_count,
2832: p_data => x_msg_data
2833: );
2834: