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

Line 78: FND_MSG_PUB.initialize;

74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API return status to success
82: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

128:
129: END IF;
130:
131: -- Standard call to get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
133:
134: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
135: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
136: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party');

Line 149: FND_MSG_PUB.Count_And_Get(

145: --close cursors
146: IF (party_csr%ISOPEN) THEN
147: CLOSE party_csr ;
148: END IF;
149: FND_MSG_PUB.Count_And_Get(
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153:

Line 165: FND_MSG_PUB.Count_And_Get(

161:
162: IF (party_csr%ISOPEN) THEN
163: CLOSE party_csr ;
164: END IF;
165: FND_MSG_PUB.Count_And_Get(
166: p_count => x_msg_count,
167: p_data => x_msg_data
168: );
169:

Line 188: FND_MSG_PUB.Count_And_Get(

184: IF (party_csr%ISOPEN) THEN
185: CLOSE party_csr ;
186: END IF;
187: x_return_status := G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Count_And_Get(
189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );
192: END check_no_external_party;

Line 266: FND_MSG_PUB.initialize;

262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: open c_get_doctype;
270: fetch c_get_doctype into l_doc_type;

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

306:
307: END IF; -- p_effective_date IS NULL
308:
309: -- Standard call to get message count and if count is 1, get message info.
310: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
311:
312: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
314: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date');

Line 324: FND_MSG_PUB.Count_And_Get(

320: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_ERROR');
321: END IF;
322: x_return_status := G_RET_STS_ERROR;
323:
324: FND_MSG_PUB.Count_And_Get(
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328:

Line 336: FND_MSG_PUB.Count_And_Get(

332: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_UNEXPECTED_ERROR');
333: END IF;
334:
335: x_return_status := G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get(
337: p_count => x_msg_count,
338: p_data => x_msg_data
339: );
340:

Line 355: FND_MSG_PUB.Count_And_Get(

351: p_token1_value => sqlcode,
352: p_token2 => G_SQLERRM_TOKEN,
353: p_token2_value => sqlerrm);
354: x_return_status := G_RET_STS_UNEXP_ERROR;
355: FND_MSG_PUB.Count_And_Get(
356: p_count => x_msg_count,
357: p_data => x_msg_data
358: );
359: END check_no_eff_date;

Line 433: FND_MSG_PUB.initialize;

429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: -- Initialize message list if p_init_msg_list is set to TRUE.
432: IF FND_API.to_Boolean( p_init_msg_list ) THEN
433: FND_MSG_PUB.initialize;
434: END IF;
435:
436: open c_get_doctype;
437: fetch c_get_doctype into l_doc_type;

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

473:
474: END IF;
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
478:
479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
480: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
481: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check');

Line 491: FND_MSG_PUB.Count_And_Get(

487: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check with G_EXC_ERROR');
488: END IF;
489: x_return_status := G_RET_STS_ERROR;
490:
491: FND_MSG_PUB.Count_And_Get(
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );
495:

Line 503: FND_MSG_PUB.Count_And_Get(

499: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check with G_EXC_UNEXPECTED_ERROR');
500: END IF;
501:
502: x_return_status := G_RET_STS_UNEXP_ERROR;
503: FND_MSG_PUB.Count_And_Get(
504: p_count => x_msg_count,
505: p_data => x_msg_data
506: );
507:

Line 522: FND_MSG_PUB.Count_And_Get(

518: p_token1_value => sqlcode,
519: p_token2 => G_SQLERRM_TOKEN,
520: p_token2_value => sqlerrm);
521: x_return_status := G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_And_Get(
523: p_count => x_msg_count,
524: p_data => x_msg_data
525: );
526: END check_expiry_check;

Line 640: FND_MSG_PUB.initialize;

636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list ) THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:
643: -- Initialize API return status to success
644: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

757:
758:
759:
760: -- Standard call to get message count and if count is 1, get message info.
761: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
762:
763: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
765: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type');

Line 777: FND_MSG_PUB.Count_And_Get(

773: IF (contract_type_csr%ISOPEN) THEN
774: CLOSE contract_type_csr ;
775: END IF;
776: x_return_status := G_RET_STS_ERROR;
777: FND_MSG_PUB.Count_And_Get(
778: p_count => x_msg_count,
779: p_data => x_msg_data
780: );
781:

Line 791: FND_MSG_PUB.Count_And_Get(

787: IF (contract_type_csr%ISOPEN) THEN
788: CLOSE contract_type_csr ;
789: END IF;
790: x_return_status := G_RET_STS_UNEXP_ERROR;
791: FND_MSG_PUB.Count_And_Get(
792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );
795:

Line 812: FND_MSG_PUB.Count_And_Get(

808: p_token1_value => sqlcode,
809: p_token2 => G_SQLERRM_TOKEN,
810: p_token2_value => sqlerrm);
811: x_return_status := G_RET_STS_UNEXP_ERROR;
812: FND_MSG_PUB.Count_And_Get(
813: p_count => x_msg_count,
814: p_data => x_msg_data
815: );
816: END validate_E_Signature;

Line 881: FND_MSG_PUB.initialize;

877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
881: FND_MSG_PUB.initialize;
882: END IF;
883:
884: -- Initialize API return status to success
885: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

923: p_token1 => G_CONTRACT_TYPE_TOKEN,
924: p_token1_value => l_contract_type_name);
925: END IF; -- l_valid_contract_type_flag = 'N'
926: -- Standard call to get message count and if count is 1, get message info.
927: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
928:
929: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
931: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type');

Line 943: FND_MSG_PUB.Count_And_Get(

939: IF (contract_type_csr%ISOPEN) THEN
940: CLOSE contract_type_csr ;
941: END IF;
942: x_return_status := G_RET_STS_ERROR;
943: FND_MSG_PUB.Count_And_Get(
944: p_count => x_msg_count,
945: p_data => x_msg_data
946: );
947:

Line 957: FND_MSG_PUB.Count_And_Get(

953: IF (contract_type_csr%ISOPEN) THEN
954: CLOSE contract_type_csr ;
955: END IF;
956: x_return_status := G_RET_STS_UNEXP_ERROR;
957: FND_MSG_PUB.Count_And_Get(
958: p_count => x_msg_count,
959: p_data => x_msg_data
960: );
961:

Line 978: FND_MSG_PUB.Count_And_Get(

974: p_token1_value => sqlcode,
975: p_token2 => G_SQLERRM_TOKEN,
976: p_token2_value => sqlerrm);
977: x_return_status := G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get(
979: p_count => x_msg_count,
980: p_data => x_msg_data
981: );
982: END validate_contract_type;

Line 1058: FND_MSG_PUB.initialize;

1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056: -- Initialize message list if p_init_msg_list is set to TRUE.
1057: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061: -- Initialize API return status to success
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1117: p_token1_value => l_party_name);
1118: END IF; -- l_valid_external_party_flag = 'N'
1119:
1120: -- Standard call to get message count and if count is 1, get message info.
1121: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1122:
1123: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1125: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party');

Line 1140: FND_MSG_PUB.Count_And_Get(

1136: IF (vendor_csr%ISOPEN) THEN
1137: CLOSE vendor_csr ;
1138: END IF;
1139: x_return_status := G_RET_STS_ERROR;
1140: FND_MSG_PUB.Count_And_Get(
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144:

Line 1157: FND_MSG_PUB.Count_And_Get(

1153: IF (vendor_csr%ISOPEN) THEN
1154: CLOSE vendor_csr ;
1155: END IF;
1156: x_return_status := G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get(
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );
1161:

Line 1181: FND_MSG_PUB.Count_And_Get(

1177: p_token1_value => sqlcode,
1178: p_token2 => G_SQLERRM_TOKEN,
1179: p_token2_value => sqlerrm);
1180: x_return_status := G_RET_STS_UNEXP_ERROR;
1181: FND_MSG_PUB.Count_And_Get(
1182: p_count => x_msg_count,
1183: p_data => x_msg_data
1184: );
1185: END validate_external_party;

Line 1297: FND_MSG_PUB.initialize;

1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1297: FND_MSG_PUB.initialize;
1298: END IF;
1299:
1300: -- Initialize API return status to success
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1394: p_token1_value => l_contact_name);
1395: END IF; -- _valid_external_party_flag = 'N'
1396:
1397: -- Standard call to get message count and if count is 1, get message info.
1398: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1399:
1400: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1401: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1402: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact');

Line 1423: FND_MSG_PUB.Count_And_Get(

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

Line 1446: FND_MSG_PUB.Count_And_Get(

1442: IF (employee_name_csr%ISOPEN) THEN
1443: CLOSE employee_name_csr ;
1444: END IF;
1445: x_return_status := 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 1476: FND_MSG_PUB.Count_And_Get(

1472: p_token1_value => sqlcode,
1473: p_token2 => G_SQLERRM_TOKEN,
1474: p_token2_value => sqlerrm);
1475: x_return_status := G_RET_STS_UNEXP_ERROR;
1476: FND_MSG_PUB.Count_And_Get(
1477: p_count => x_msg_count,
1478: p_data => x_msg_data
1479: );
1480: END validate_contact;

Line 1547: FND_MSG_PUB.initialize;

1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: END IF;
1545: -- Initialize message list if p_init_msg_list is set to TRUE.
1546: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1547: FND_MSG_PUB.initialize;
1548: END IF;
1549:
1550: -- Initialize API return status to success
1551: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1588: p_token1 => G_CONTACT_ROLE_TOKEN,
1589: p_token1_value => l_contact_role_name);
1590: END IF; -- l_valid_contact_role_flag = 'N'
1591: -- Standard call to get message count and if count is 1, get message info.
1592: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1593:
1594: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1595: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1596: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role');

Line 1608: FND_MSG_PUB.Count_And_Get(

1604: IF (contact_role_csr%ISOPEN) THEN
1605: CLOSE contact_role_csr ;
1606: END IF;
1607: x_return_status := G_RET_STS_ERROR;
1608: FND_MSG_PUB.Count_And_Get(
1609: p_count => x_msg_count,
1610: p_data => x_msg_data
1611: );
1612:

Line 1622: FND_MSG_PUB.Count_And_Get(

1618: IF (contact_role_csr%ISOPEN) THEN
1619: CLOSE contact_role_csr ;
1620: END IF;
1621: x_return_status := G_RET_STS_UNEXP_ERROR;
1622: FND_MSG_PUB.Count_And_Get(
1623: p_count => x_msg_count,
1624: p_data => x_msg_data
1625: );
1626:

Line 1643: FND_MSG_PUB.Count_And_Get(

1639: p_token1_value => sqlcode,
1640: p_token2 => G_SQLERRM_TOKEN,
1641: p_token2_value => sqlerrm);
1642: x_return_status := G_RET_STS_UNEXP_ERROR;
1643: FND_MSG_PUB.Count_And_Get(
1644: p_count => x_msg_count,
1645: p_data => x_msg_data
1646: );
1647: END validate_contact_role;

Line 1713: FND_MSG_PUB.initialize;

1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711: -- Initialize message list if p_init_msg_list is set to TRUE.
1712: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1713: FND_MSG_PUB.initialize;
1714: END IF;
1715:
1716: -- Initialize API return status to success
1717: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1754: p_token1 => G_RISK_EVENT_TOKEN,
1755: p_token1_value => l_risk_event_name);
1756: END IF; -- l_valid_risk_event_flag = 'N'
1757: -- Standard call to get message count and if count is 1, get message info.
1758: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1759:
1760: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1761: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1762: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event');

Line 1774: FND_MSG_PUB.Count_And_Get(

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

Line 1788: FND_MSG_PUB.Count_And_Get(

1784: IF (risk_event_csr%ISOPEN) THEN
1785: CLOSE risk_event_csr ;
1786: END IF;
1787: x_return_status := G_RET_STS_UNEXP_ERROR;
1788: FND_MSG_PUB.Count_And_Get(
1789: p_count => x_msg_count,
1790: p_data => x_msg_data
1791: );
1792:

Line 1809: FND_MSG_PUB.Count_And_Get(

1805: p_token1_value => sqlcode,
1806: p_token2 => G_SQLERRM_TOKEN,
1807: p_token2_value => sqlerrm);
1808: x_return_status := G_RET_STS_UNEXP_ERROR;
1809: FND_MSG_PUB.Count_And_Get(
1810: p_count => x_msg_count,
1811: p_data => x_msg_data
1812: );
1813: END validate_risk_event;

Line 1898: FND_MSG_PUB.initialize;

1894: x_return_status := G_RET_STS_SUCCESS;
1895:
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: --Validations for Closeout Checklist Template Contract Type
1902: IF (p_contract_type = 'REP_CCT') THEN

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

2129:
2130: END IF;--p_contract_type = 'REP_SBCR'
2131:
2132: -- Standard call to get message count and if count is 1, get message info.
2133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2134: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2135: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
2136: G_MODULE||l_api_name,'leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat');
2137: END IF;

Line 2154: FND_MSG_PUB.Count_And_Get(

2150: IF (c_contact_role_count%ISOPEN) THEN
2151: CLOSE c_contact_role_count ;
2152: END IF;
2153:
2154: FND_MSG_PUB.Count_And_Get(
2155: p_count => x_msg_count,
2156: p_data => x_msg_data
2157: );
2158:

Line 2173: FND_MSG_PUB.Count_And_Get(

2169: IF (c_contact_role_count%ISOPEN) THEN
2170: CLOSE c_contact_role_count ;
2171: END IF;
2172:
2173: FND_MSG_PUB.Count_And_Get(
2174: p_count => x_msg_count,
2175: p_data => x_msg_data
2176: );
2177:

Line 2199: FND_MSG_PUB.Count_And_Get(

2195: CLOSE c_contact_role_count ;
2196: END IF;
2197:
2198: x_return_status := G_RET_STS_UNEXP_ERROR;
2199: FND_MSG_PUB.Count_And_Get(
2200: p_count => x_msg_count,
2201: p_data => x_msg_data
2202: );
2203:

Line 2271: FND_MSG_PUB.initialize;

2267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2268: END IF;
2269: -- Initialize message list if p_init_msg_list is set to TRUE.
2270: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2271: FND_MSG_PUB.initialize;
2272: END IF;
2273:
2274: -- Initialize API return status to success
2275: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2305:
2306: END IF;
2307:
2308: -- Standard call to get message count and if count is 1, get message info.
2309: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2310:
2311: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2313: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow');

Line 2328: FND_MSG_PUB.Count_And_Get(

2324: END IF;
2325:
2326: x_return_status := G_RET_STS_ERROR;
2327:
2328: FND_MSG_PUB.Count_And_Get(
2329: p_count => x_msg_count,
2330: p_data => x_msg_data
2331: );
2332:

Line 2343: FND_MSG_PUB.Count_And_Get(

2339: IF (contract_type_csr%ISOPEN) THEN
2340: CLOSE contract_type_csr ;
2341: END IF;
2342: x_return_status := G_RET_STS_UNEXP_ERROR;
2343: FND_MSG_PUB.Count_And_Get(
2344: p_count => x_msg_count,
2345: p_data => x_msg_data
2346: );
2347:

Line 2367: FND_MSG_PUB.Count_And_Get(

2363: p_token1_value => sqlcode,
2364: p_token2 => G_SQLERRM_TOKEN,
2365: p_token2_value => sqlerrm);
2366: x_return_status := G_RET_STS_UNEXP_ERROR;
2367: FND_MSG_PUB.Count_And_Get(
2368: p_count => x_msg_count,
2369: p_data => x_msg_data
2370: );
2371: END validate_Approval_Workflow;

Line 2476: FND_MSG_PUB.initialize;

2472: END IF;
2473:
2474: -- Initialize message list if p_init_msg_list is set to TRUE.
2475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2476: FND_MSG_PUB.initialize;
2477: END IF;
2478:
2479: --Check for external party
2480: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2846:
2847: -- Close all cursors.
2848: CLOSE contract_csr;
2849: -- Standard call to get message count and if count is 1, get message info.
2850: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2851: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2852: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
2853: G_MODULE||l_api_name,'leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa');
2854: END IF;

Line 2867: FND_MSG_PUB.Count_And_Get(

2863: --close cursors
2864: IF (contract_csr%ISOPEN) THEN
2865: CLOSE contract_csr ;
2866: END IF;
2867: FND_MSG_PUB.Count_And_Get(
2868: p_count => x_msg_count,
2869: p_data => x_msg_data
2870: );
2871:

Line 2882: FND_MSG_PUB.Count_And_Get(

2878: --close cursors
2879: IF (contract_csr%ISOPEN) THEN
2880: CLOSE contract_csr ;
2881: END IF;
2882: FND_MSG_PUB.Count_And_Get(
2883: p_count => x_msg_count,
2884: p_data => x_msg_data
2885: );
2886:

Line 2904: FND_MSG_PUB.Count_And_Get(

2900: IF (contract_csr%ISOPEN) THEN
2901: CLOSE contract_csr ;
2902: END IF;
2903: x_return_status := G_RET_STS_UNEXP_ERROR;
2904: FND_MSG_PUB.Count_And_Get(
2905: p_count => x_msg_count,
2906: p_data => x_msg_data
2907: );
2908:

Line 2988: FND_MSG_PUB.initialize;

2984: END IF;
2985:
2986: -- Initialize message list if p_init_msg_list is set to TRUE.
2987: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2988: FND_MSG_PUB.initialize;
2989: END IF;
2990:
2991: -- Get effective dates and contract_type of the contract.
2992: OPEN contract_csr;

Line 3022: FND_MSG_PUB.initialize;

3018: 'Calling OKC_TERMS_QA_GRP.QA_Doc API');
3019: END IF;
3020:
3021:
3022: FND_MSG_PUB.initialize;
3023: OKC_TERMS_QA_GRP.QA_Doc (p_api_version => 1,
3024: p_init_msg_list => 'T',
3025: x_return_status => x_return_status,
3026: x_msg_data => x_msg_data,

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

3170:
3171: CLOSE contract_csr;
3172:
3173: -- Standard call to get message count and if count is 1, get message info.
3174: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3175:
3176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3177: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
3178: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check');

Line 3193: FND_MSG_PUB.Count_And_Get(

3189: IF (contract_csr%ISOPEN) THEN
3190: CLOSE contract_csr ;
3191: END IF;
3192: x_return_status := G_RET_STS_ERROR;
3193: FND_MSG_PUB.Count_And_Get(
3194: p_count => x_msg_count,
3195: p_data => x_msg_data
3196: );
3197:

Line 3209: FND_MSG_PUB.Count_And_Get(

3205: IF (contract_csr%ISOPEN) THEN
3206: CLOSE contract_csr ;
3207: END IF;
3208: x_return_status := G_RET_STS_UNEXP_ERROR;
3209: FND_MSG_PUB.Count_And_Get(
3210: p_count => x_msg_count,
3211: p_data => x_msg_data
3212: );
3213:

Line 3231: FND_MSG_PUB.Count_And_Get(

3227: p_token1 => G_SQLCODE_TOKEN,
3228: p_token1_value => sqlcode,
3229: p_token2 => G_SQLERRM_TOKEN,
3230: p_token2_value => sqlerrm);
3231: FND_MSG_PUB.Count_And_Get(
3232: p_count => x_msg_count,
3233: p_data => x_msg_data
3234: );
3235:

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

3348:
3349: END LOOP;
3350:
3351: -- Standard call to get message count and if count is 1, get message info.
3352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3353:
3354: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3355: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
3356: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks');

Line 3369: FND_MSG_PUB.Count_And_Get(

3365: END IF;
3366:
3367: x_return_status := G_RET_STS_ERROR;
3368:
3369: FND_MSG_PUB.Count_And_Get(
3370: p_count => x_msg_count,
3371: p_data => x_msg_data
3372: );
3373:

Line 3383: FND_MSG_PUB.Count_And_Get(

3379: END IF;
3380:
3381: x_return_status := G_RET_STS_UNEXP_ERROR;
3382:
3383: FND_MSG_PUB.Count_And_Get(
3384: p_count => x_msg_count,
3385: p_data => x_msg_data
3386: );
3387:

Line 3404: FND_MSG_PUB.Count_And_Get(

3400: p_token1_value => sqlcode,
3401: p_token2 => G_SQLERRM_TOKEN,
3402: p_token2_value => sqlerrm);
3403:
3404: FND_MSG_PUB.Count_And_Get(
3405: p_count => x_msg_count,
3406: p_data => x_msg_data
3407: );
3408: