DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on FND_MSG_PUB

Line 66: FND_MSG_PUB.initialize;

62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list ) THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: -- Initialize API return status to success
70: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

88: px_qa_result_tbl(l_index).problem_short_desc := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_REP_NO_EXT_PARTY_SD);
89: px_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_REP_NO_EXT_PARTY);
90: END IF;
91: -- Standard call to get message count and if count is 1, get message info.
92: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
93:
94: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
95: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
96: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party');

Line 109: FND_MSG_PUB.Count_And_Get(

105: --close cursors
106: IF (party_csr%ISOPEN) THEN
107: CLOSE party_csr ;
108: END IF;
109: FND_MSG_PUB.Count_And_Get(
110: p_count => x_msg_count,
111: p_data => x_msg_data
112: );
113:

Line 124: FND_MSG_PUB.Count_And_Get(

120: --close cursors
121: IF (party_csr%ISOPEN) THEN
122: CLOSE party_csr ;
123: END IF;
124: FND_MSG_PUB.Count_And_Get(
125: p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128:

Line 146: FND_MSG_PUB.Count_And_Get(

142: IF (party_csr%ISOPEN) THEN
143: CLOSE party_csr ;
144: END IF;
145: x_return_status := G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Count_And_Get(
147: p_count => x_msg_count,
148: p_data => x_msg_data
149: );
150: END check_no_external_party;

Line 209: FND_MSG_PUB.initialize;

205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207: -- Initialize message list if p_init_msg_list is set to TRUE.
208: IF FND_API.to_Boolean( p_init_msg_list ) THEN
209: FND_MSG_PUB.initialize;
210: END IF;
211:
212: -- Initialize API return status to success
213: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

229: px_qa_result_tbl(l_index).problem_short_desc := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_REP_NO_EFF_DATE_SD);
230: px_qa_result_tbl(l_index).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_REP_NO_EFF_DATE);
231: END IF; -- p_effective_date IS NULL
232: -- Standard call to get message count and if count is 1, get message info.
233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
234:
235: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
237: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date');

Line 246: FND_MSG_PUB.Count_And_Get(

242: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
243: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_ERROR');
244: END IF;
245: x_return_status := G_RET_STS_ERROR;
246: FND_MSG_PUB.Count_And_Get(
247: p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250:

Line 257: FND_MSG_PUB.Count_And_Get(

253: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
254: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_UNEXPECTED_ERROR');
255: END IF;
256: x_return_status := G_RET_STS_UNEXP_ERROR;
257: FND_MSG_PUB.Count_And_Get(
258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261:

Line 275: FND_MSG_PUB.Count_And_Get(

271: p_token1_value => sqlcode,
272: p_token2 => G_SQLERRM_TOKEN,
273: p_token2_value => sqlerrm);
274: x_return_status := G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_And_Get(
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279: END check_no_eff_date;

Line 342: FND_MSG_PUB.initialize;

338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340: -- Initialize message list if p_init_msg_list is set to TRUE.
341: IF FND_API.to_Boolean( p_init_msg_list ) THEN
342: FND_MSG_PUB.initialize;
343: END IF;
344:
345: -- Initialize API return status to success
346: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

384: p_token1 => G_CONTRACT_TYPE_TOKEN,
385: p_token1_value => l_contract_type_name);
386: END IF; -- l_valid_contract_type_flag = 'N'
387: -- Standard call to get message count and if count is 1, get message info.
388: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
389:
390: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
392: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type');

Line 404: FND_MSG_PUB.Count_And_Get(

400: IF (contract_type_csr%ISOPEN) THEN
401: CLOSE contract_type_csr ;
402: END IF;
403: x_return_status := G_RET_STS_ERROR;
404: FND_MSG_PUB.Count_And_Get(
405: p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408:

Line 418: FND_MSG_PUB.Count_And_Get(

414: IF (contract_type_csr%ISOPEN) THEN
415: CLOSE contract_type_csr ;
416: END IF;
417: x_return_status := G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.Count_And_Get(
419: p_count => x_msg_count,
420: p_data => x_msg_data
421: );
422:

Line 439: FND_MSG_PUB.Count_And_Get(

435: p_token1_value => sqlcode,
436: p_token2 => G_SQLERRM_TOKEN,
437: p_token2_value => sqlerrm);
438: x_return_status := G_RET_STS_UNEXP_ERROR;
439: FND_MSG_PUB.Count_And_Get(
440: p_count => x_msg_count,
441: p_data => x_msg_data
442: );
443: END validate_contract_type;

Line 519: FND_MSG_PUB.initialize;

515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517: -- Initialize message list if p_init_msg_list is set to TRUE.
518: IF FND_API.to_Boolean( p_init_msg_list ) THEN
519: FND_MSG_PUB.initialize;
520: END IF;
521:
522: -- Initialize API return status to success
523: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

578: p_token1_value => l_party_name);
579: END IF; -- l_valid_external_party_flag = 'N'
580:
581: -- Standard call to get message count and if count is 1, get message info.
582: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
583:
584: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
586: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party');

Line 601: FND_MSG_PUB.Count_And_Get(

597: IF (vendor_csr%ISOPEN) THEN
598: CLOSE vendor_csr ;
599: END IF;
600: x_return_status := G_RET_STS_ERROR;
601: FND_MSG_PUB.Count_And_Get(
602: p_count => x_msg_count,
603: p_data => x_msg_data
604: );
605:

Line 618: FND_MSG_PUB.Count_And_Get(

614: IF (vendor_csr%ISOPEN) THEN
615: CLOSE vendor_csr ;
616: END IF;
617: x_return_status := G_RET_STS_UNEXP_ERROR;
618: FND_MSG_PUB.Count_And_Get(
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
622:

Line 642: FND_MSG_PUB.Count_And_Get(

638: p_token1_value => sqlcode,
639: p_token2 => G_SQLERRM_TOKEN,
640: p_token2_value => sqlerrm);
641: x_return_status := G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get(
643: p_count => x_msg_count,
644: p_data => x_msg_data
645: );
646: END validate_external_party;

Line 758: FND_MSG_PUB.initialize;

754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756: -- Initialize message list if p_init_msg_list is set to TRUE.
757: IF FND_API.to_Boolean( p_init_msg_list ) THEN
758: FND_MSG_PUB.initialize;
759: END IF;
760:
761: -- Initialize API return status to success
762: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

855: p_token1_value => l_contact_name);
856: END IF; -- _valid_external_party_flag = 'N'
857:
858: -- Standard call to get message count and if count is 1, get message info.
859: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
860:
861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
862: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
863: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact');

Line 884: FND_MSG_PUB.Count_And_Get(

880: IF (employee_name_csr%ISOPEN) THEN
881: CLOSE employee_name_csr ;
882: END IF;
883: x_return_status := G_RET_STS_ERROR;
884: FND_MSG_PUB.Count_And_Get(
885: p_count => x_msg_count,
886: p_data => x_msg_data
887: );
888:

Line 907: FND_MSG_PUB.Count_And_Get(

903: IF (employee_name_csr%ISOPEN) THEN
904: CLOSE employee_name_csr ;
905: END IF;
906: x_return_status := G_RET_STS_UNEXP_ERROR;
907: FND_MSG_PUB.Count_And_Get(
908: p_count => x_msg_count,
909: p_data => x_msg_data
910: );
911:

Line 937: FND_MSG_PUB.Count_And_Get(

933: p_token1_value => sqlcode,
934: p_token2 => G_SQLERRM_TOKEN,
935: p_token2_value => sqlerrm);
936: x_return_status := G_RET_STS_UNEXP_ERROR;
937: FND_MSG_PUB.Count_And_Get(
938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941: END validate_contact;

Line 1008: FND_MSG_PUB.initialize;

1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006: -- Initialize message list if p_init_msg_list is set to TRUE.
1007: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1008: FND_MSG_PUB.initialize;
1009: END IF;
1010:
1011: -- Initialize API return status to success
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1049: p_token1 => G_CONTACT_ROLE_TOKEN,
1050: p_token1_value => l_contact_role_name);
1051: END IF; -- l_valid_contact_role_flag = 'N'
1052: -- Standard call to get message count and if count is 1, get message info.
1053: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1054:
1055: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1057: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role');

Line 1069: FND_MSG_PUB.Count_And_Get(

1065: IF (contact_role_csr%ISOPEN) THEN
1066: CLOSE contact_role_csr ;
1067: END IF;
1068: x_return_status := 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:

Line 1083: FND_MSG_PUB.Count_And_Get(

1079: IF (contact_role_csr%ISOPEN) THEN
1080: CLOSE contact_role_csr ;
1081: END IF;
1082: x_return_status := G_RET_STS_UNEXP_ERROR;
1083: FND_MSG_PUB.Count_And_Get(
1084: p_count => x_msg_count,
1085: p_data => x_msg_data
1086: );
1087:

Line 1104: FND_MSG_PUB.Count_And_Get(

1100: p_token1_value => sqlcode,
1101: p_token2 => G_SQLERRM_TOKEN,
1102: p_token2_value => sqlerrm);
1103: x_return_status := G_RET_STS_UNEXP_ERROR;
1104: FND_MSG_PUB.Count_And_Get(
1105: p_count => x_msg_count,
1106: p_data => x_msg_data
1107: );
1108: END validate_contact_role;

Line 1174: FND_MSG_PUB.initialize;

1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1171: END IF;
1172: -- Initialize message list if p_init_msg_list is set to TRUE.
1173: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1174: FND_MSG_PUB.initialize;
1175: END IF;
1176:
1177: -- Initialize API return status to success
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1215: p_token1 => G_RISK_EVENT_TOKEN,
1216: p_token1_value => l_risk_event_name);
1217: END IF; -- l_valid_risk_event_flag = 'N'
1218: -- Standard call to get message count and if count is 1, get message info.
1219: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1220:
1221: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1222: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1223: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event');

Line 1235: FND_MSG_PUB.Count_And_Get(

1231: IF (risk_event_csr%ISOPEN) THEN
1232: CLOSE risk_event_csr ;
1233: END IF;
1234: x_return_status := G_RET_STS_ERROR;
1235: FND_MSG_PUB.Count_And_Get(
1236: p_count => x_msg_count,
1237: p_data => x_msg_data
1238: );
1239:

Line 1249: FND_MSG_PUB.Count_And_Get(

1245: IF (risk_event_csr%ISOPEN) THEN
1246: CLOSE risk_event_csr ;
1247: END IF;
1248: x_return_status := G_RET_STS_UNEXP_ERROR;
1249: FND_MSG_PUB.Count_And_Get(
1250: p_count => x_msg_count,
1251: p_data => x_msg_data
1252: );
1253:

Line 1270: FND_MSG_PUB.Count_And_Get(

1266: p_token1_value => sqlcode,
1267: p_token2 => G_SQLERRM_TOKEN,
1268: p_token2_value => sqlerrm);
1269: x_return_status := G_RET_STS_UNEXP_ERROR;
1270: FND_MSG_PUB.Count_And_Get(
1271: p_count => x_msg_count,
1272: p_data => x_msg_data
1273: );
1274: END validate_risk_event;

Line 1379: FND_MSG_PUB.initialize;

1375: END IF;
1376:
1377: -- Initialize message list if p_init_msg_list is set to TRUE.
1378: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1379: FND_MSG_PUB.initialize;
1380: END IF;
1381:
1382: --Check for external party
1383: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1590:
1591: -- Close all cursors.
1592: CLOSE contract_csr;
1593: -- Standard call to get message count and if count is 1, get message info.
1594: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1595: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1596: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
1597: G_MODULE||l_api_name,'leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa');
1598: END IF;

Line 1611: FND_MSG_PUB.Count_And_Get(

1607: --close cursors
1608: IF (contract_csr%ISOPEN) THEN
1609: CLOSE contract_csr ;
1610: END IF;
1611: FND_MSG_PUB.Count_And_Get(
1612: p_count => x_msg_count,
1613: p_data => x_msg_data
1614: );
1615:

Line 1626: FND_MSG_PUB.Count_And_Get(

1622: --close cursors
1623: IF (contract_csr%ISOPEN) THEN
1624: CLOSE contract_csr ;
1625: END IF;
1626: FND_MSG_PUB.Count_And_Get(
1627: p_count => x_msg_count,
1628: p_data => x_msg_data
1629: );
1630:

Line 1648: FND_MSG_PUB.Count_And_Get(

1644: IF (contract_csr%ISOPEN) THEN
1645: CLOSE contract_csr ;
1646: END IF;
1647: x_return_status := G_RET_STS_UNEXP_ERROR;
1648: FND_MSG_PUB.Count_And_Get(
1649: p_count => x_msg_count,
1650: p_data => x_msg_data
1651: );
1652:

Line 1732: FND_MSG_PUB.initialize;

1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1732: FND_MSG_PUB.initialize;
1733: END IF;
1734:
1735: -- Get effective dates and contract_type of the contract.
1736: OPEN contract_csr;

Line 1766: FND_MSG_PUB.initialize;

1762: 'Calling OKC_TERMS_QA_GRP.QA_Doc API');
1763: END IF;
1764:
1765:
1766: FND_MSG_PUB.initialize;
1767: OKC_TERMS_QA_GRP.QA_Doc (p_api_version => 1,
1768: p_init_msg_list => 'T',
1769: x_return_status => x_return_status,
1770: x_msg_data => x_msg_data,

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

1914:
1915: CLOSE contract_csr;
1916:
1917: -- Standard call to get message count and if count is 1, get message info.
1918: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1919:
1920: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
1922: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check');

Line 1937: FND_MSG_PUB.Count_And_Get(

1933: IF (contract_csr%ISOPEN) THEN
1934: CLOSE contract_csr ;
1935: END IF;
1936: x_return_status := G_RET_STS_ERROR;
1937: FND_MSG_PUB.Count_And_Get(
1938: p_count => x_msg_count,
1939: p_data => x_msg_data
1940: );
1941:

Line 1953: FND_MSG_PUB.Count_And_Get(

1949: IF (contract_csr%ISOPEN) THEN
1950: CLOSE contract_csr ;
1951: END IF;
1952: x_return_status := G_RET_STS_UNEXP_ERROR;
1953: FND_MSG_PUB.Count_And_Get(
1954: p_count => x_msg_count,
1955: p_data => x_msg_data
1956: );
1957:

Line 1975: FND_MSG_PUB.Count_And_Get(

1971: p_token1 => G_SQLCODE_TOKEN,
1972: p_token1_value => sqlcode,
1973: p_token2 => G_SQLERRM_TOKEN,
1974: p_token2_value => sqlerrm);
1975: FND_MSG_PUB.Count_And_Get(
1976: p_count => x_msg_count,
1977: p_data => x_msg_data
1978: );
1979:

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

2092:
2093: END LOOP;
2094:
2095: -- Standard call to get message count and if count is 1, get message info.
2096: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2097:
2098: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2099: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
2100: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks');

Line 2113: FND_MSG_PUB.Count_And_Get(

2109: END IF;
2110:
2111: x_return_status := G_RET_STS_ERROR;
2112:
2113: FND_MSG_PUB.Count_And_Get(
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );
2117:

Line 2127: FND_MSG_PUB.Count_And_Get(

2123: END IF;
2124:
2125: x_return_status := G_RET_STS_UNEXP_ERROR;
2126:
2127: FND_MSG_PUB.Count_And_Get(
2128: p_count => x_msg_count,
2129: p_data => x_msg_data
2130: );
2131:

Line 2148: FND_MSG_PUB.Count_And_Get(

2144: p_token1_value => sqlcode,
2145: p_token2 => G_SQLERRM_TOKEN,
2146: p_token2_value => sqlerrm);
2147:
2148: FND_MSG_PUB.Count_And_Get(
2149: p_count => x_msg_count,
2150: p_data => x_msg_data
2151: );
2152: