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

Line 118: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

114: IF (c1%ISOPEN) THEN
115: CLOSE c1;
116: END IF;
117:
118: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
119: THEN
120: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
121: END IF;
122: RAISE;

Line 120: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

116: END IF;
117:
118: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
119: THEN
120: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
121: END IF;
122: RAISE;
123: END;
124:

Line 166: FND_MSG_PUB.add;

162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
164: FND_MESSAGE.set_token('ARG_NAME', 'p_art_ver_tbl');
165: FND_MESSAGE.set_token('ARG_VALUE', 'NULL');
166: FND_MSG_PUB.add;
167: RAISE fnd_api.g_exc_error;
168: END IF;
169:
170: IF (p_org_id IS NULL) THEN

Line 174: FND_MSG_PUB.add;

170: IF (p_org_id IS NULL) THEN
171: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
172: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
173: FND_MESSAGE.set_token('ARG_VALUE', 'p_org_id');
174: FND_MSG_PUB.add;
175: RAISE fnd_api.g_exc_error;
176: END IF;
177:
178:

Line 284: FND_MSG_PUB.add;

280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
282: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
283: FND_MESSAGE.set_token('ARG_VALUE', p_org_id);
284: FND_MSG_PUB.add;
285: RAISE fnd_api.g_exc_error;
286: END IF;
287:
288: IF (l_debug = 'Y') THEN

Line 314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

310: IF (l_debug = 'Y') THEN
311: okc_debug.log('202: Leaving get_version_details: Unknown error');
312: END IF;
313:
314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
317: END IF;
318:

Line 316: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

312: END IF;
313:
314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
317: END IF;
318:
319: END get_version_details;
320:

Line 427: FND_MSG_PUB.add;

423: x_return_status := FND_API.G_RET_STS_ERROR;
424: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
425: FND_MESSAGE.set_token('ARG_NAME', 'p_to_status');
426: FND_MESSAGE.set_token('ARG_VALUE', p_to_status);
427: FND_MSG_PUB.add;
428: RAISE FND_API.G_EXC_ERROR;
429:
430: END IF;
431:

Line 510: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

506: IF (l_status_csr%ISOPEN) THEN
507: CLOSE l_status_csr;
508: END IF;
509:
510: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
511: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
512: END IF;
513:
514: END status_check_blk;

Line 511: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

507: CLOSE l_status_csr;
508: END IF;
509:
510: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
511: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
512: END IF;
513:
514: END status_check_blk;
515:

Line 660: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

656: IF (l_invalid_valueset_csr%ISOPEN) THEN
657: CLOSE l_invalid_valueset_csr;
658: END IF;
659:
660: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
661: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
662: END IF;
663:
664: END variable_check_blk;

Line 661: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

657: CLOSE l_invalid_valueset_csr;
658: END IF;
659:
660: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
661: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
662: END IF;
663:
664: END variable_check_blk;
665:

Line 801: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

797: IF (l_def_sec_csr%ISOPEN) THEN
798: CLOSE l_def_sec_csr;
799: END IF;
800:
801: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
802: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
803: END IF;
804:
805: END section_type_check_blk;

Line 802: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

798: CLOSE l_def_sec_csr;
799: END IF;
800:
801: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
802: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
803: END IF;
804:
805: END section_type_check_blk;
806:

Line 869: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

865: IF (l_debug = 'Y') THEN
866: okc_debug.log('201: Leaving update_art_version_status_blk: Unknown Error');
867: END IF;
868:
869: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
870: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
871: END IF;
872:
873: END update_art_version_status_blk;

Line 870: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

866: okc_debug.log('201: Leaving update_art_version_status_blk: Unknown Error');
867: END IF;
868:
869: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
870: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
871: END IF;
872:
873: END update_art_version_status_blk;
874:

Line 935: FND_MSG_PUB.add;

931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
933: FND_MESSAGE.set_token('ARG_NAME', 'p_type');
934: FND_MESSAGE.set_token('ARG_VALUE', p_type);
935: FND_MSG_PUB.add;
936: RAISE FND_API.G_EXC_ERROR;
937:
938: END IF;
939:

Line 958: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

954: IF (l_debug = 'Y') THEN
955: okc_debug.log('202: Leaving update_adp_status_type_blk: Unknown Error');
956: END IF;
957:
958: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
959: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
960: END IF;
961:
962: END update_adp_status_type_blk;

Line 959: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

955: okc_debug.log('202: Leaving update_adp_status_type_blk: Unknown Error');
956: END IF;
957:
958: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
959: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
960: END IF;
961:
962: END update_adp_status_type_blk;
963:

Line 1041: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

1037: IF (l_debug = 'Y') THEN
1038: okc_debug.log('201: Leaving update_prev_vers_enddate_blk: Unknown Error');
1039: END IF;
1040:
1041: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1042: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
1043: END IF;
1044:
1045: END update_prev_vers_enddate_blk;

Line 1042: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );

1038: okc_debug.log('201: Leaving update_prev_vers_enddate_blk: Unknown Error');
1039: END IF;
1040:
1041: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1042: FND_MSG_PUB.add_exc_msg(G_PKG_NAME ,l_api_name );
1043: END IF;
1044:
1045: END update_prev_vers_enddate_blk;
1046:

Line 1170: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1166: IF (l_debug = 'Y') THEN
1167: okc_debug.log('201: Leaving adopt_relationships_blk: Unknown Error');
1168: END IF;
1169:
1170: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1171: THEN
1172: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1173: END IF;
1174: END adopt_relationships_blk;

Line 1172: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

1168: END IF;
1169:
1170: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1171: THEN
1172: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1173: END IF;
1174: END adopt_relationships_blk;
1175:
1176: -----------------------------------------------------------------------------

Line 1266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

1262: IF (l_debug = 'Y') THEN
1263: okc_debug.log('201: Leaving delete_relationships_blk: Unknown error');
1264: END IF;
1265:
1266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1267: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1268: END IF;
1269:
1270: END delete_relationships_blk;

Line 1267: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

1263: okc_debug.log('201: Leaving delete_relationships_blk: Unknown error');
1264: END IF;
1265:
1266: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1267: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1268: END IF;
1269:
1270: END delete_relationships_blk;
1271:

Line 1348: fnd_msg_pub.initialize;

1344: IF NOT fnd_api.compatible_api_call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1346: END IF;
1347: IF fnd_api.to_boolean( p_init_msg_list ) THEN
1348: fnd_msg_pub.initialize;
1349: END IF;
1350: x_return_status := FND_API.G_RET_STS_SUCCESS;
1351: x_qa_return_status := FND_API.G_RET_STS_SUCCESS;
1352:

Line 1426: l_curr_msg_count := fnd_msg_pub.count_msg;

1422: -- reset all loop variables
1423: -- get the current message count, only new messages should be fetched and
1424: -- put in the x_validation_results table;
1425:
1426: l_curr_msg_count := fnd_msg_pub.count_msg;
1427: l_local_result_status := FND_API.G_RET_STS_SUCCESS;
1428: l_msg_count := 0;
1429: l_msg_data := 0;
1430: l_earlier_local_version_id := 0;

Line 1463: x_validation_results(l_err_num).error_message := fnd_msg_pub.get(p_msg_index => l_curr_msg_count +j, p_encoded => 'F');

1459: x_validation_results(l_err_num).article_version_id := l_adopt_asis_art_ver_id_tbl(i);
1460: x_validation_results(l_err_num).article_title := l_adopt_asis_art_title_tbl(i);
1461: x_validation_results(l_err_num).error_code := G_CHK_INVALID_ADOPTION;
1462: -- get the new messages
1463: x_validation_results(l_err_num).error_message := fnd_msg_pub.get(p_msg_index => l_curr_msg_count +j, p_encoded => 'F');
1464: END LOOP;
1465:
1466: ELSIF (l_local_result_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1467: -- for unexpected error get the error messages, put a different code

Line 1479: x_validation_results(l_err_num).error_message := fnd_msg_pub.get(p_msg_index => l_curr_msg_count +j, p_encoded => 'F');

1475: x_validation_results(l_err_num).article_version_id := l_adopt_asis_art_ver_id_tbl(i);
1476: x_validation_results(l_err_num).article_title := l_adopt_asis_art_title_tbl(i);
1477: x_validation_results(l_err_num).error_code := G_CHK_ADOPTION_UNEXP_ERROR;
1478: -- get the new messages
1479: x_validation_results(l_err_num).error_message := fnd_msg_pub.get(p_msg_index => l_curr_msg_count +j, p_encoded => 'F');
1480: END LOOP;
1481:
1482: END IF;
1483:

Line 1502: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1498: IF (x_validation_results.COUNT >0 ) THEN
1499: x_qa_return_status := FND_API.G_RET_STS_ERROR;
1500: END IF;
1501:
1502: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1503: IF fnd_api.to_boolean( p_commit ) THEN
1504: COMMIT WORK;
1505: END IF;
1506:

Line 1526: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1522:
1523: IF (l_adopt_as_is_csr%ISOPEN) THEN
1524: CLOSE l_adopt_as_is_csr;
1525: END IF;
1526: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1527:
1528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1529:
1530: ROLLBACK TO val_article_versions_blk_PVT;

Line 1540: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1536:
1537: IF (l_adopt_as_is_csr%ISOPEN) THEN
1538: CLOSE l_adopt_as_is_csr;
1539: END IF;
1540: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1541:
1542: WHEN OTHERS THEN
1543:
1544: ROLLBACK TO val_article_versions_blk_PVT;

Line 1555: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1551: IF (l_adopt_as_is_csr%ISOPEN) THEN
1552: CLOSE l_adopt_as_is_csr;
1553: END IF;
1554:
1555: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1556: THEN
1557: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1558: END IF;
1559: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

Line 1557: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

1553: END IF;
1554:
1555: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1556: THEN
1557: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1558: END IF;
1559: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1560:
1561: END validate_article_versions_blk;

Line 1559: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1555: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1556: THEN
1557: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1558: END IF;
1559: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1560:
1561: END validate_article_versions_blk;
1562:
1563: -----------------------------------------------------------------------------

Line 1622: fnd_msg_pub.initialize;

1618: IF NOT fnd_api.compatible_api_call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: END IF;
1621: IF fnd_api.to_boolean( p_init_msg_list ) THEN
1622: fnd_msg_pub.initialize;
1623: END IF;
1624: x_return_status := FND_API.G_RET_STS_SUCCESS;
1625:
1626: OPEN l_org_info_csr(G_GLOBAL_ORG_ID);

Line 1722: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1718:
1719: l_org_id_tbl.DELETE;
1720: l_adp_typ_tbl.DELETE;
1721:
1722: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1723: IF fnd_api.to_boolean( p_commit ) THEN
1724: COMMIT;
1725: END IF;
1726:

Line 1746: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1742: END IF;
1743: IF (l_non_uniq_title_csr%ISOPEN) THEN
1744: CLOSE l_non_uniq_title_csr;
1745: END IF;
1746: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1747:
1748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1749: ROLLBACK TO auto_adopt_articles_blk_PVT;
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1761: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1757: END IF;
1758: IF (l_non_uniq_title_csr%ISOPEN) THEN
1759: CLOSE l_non_uniq_title_csr;
1760: END IF;
1761: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1762:
1763: WHEN OTHERS THEN
1764: ROLLBACK TO auto_adopt_articles_blk_PVT;
1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1777: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1773: IF (l_non_uniq_title_csr%ISOPEN) THEN
1774: CLOSE l_non_uniq_title_csr;
1775: END IF;
1776:
1777: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1778: THEN
1779: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1780: END IF;
1781: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

Line 1779: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

1775: END IF;
1776:
1777: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1778: THEN
1779: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1780: END IF;
1781: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1782:
1783: END auto_adopt_articles_blk;

Line 1781: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

1777: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1778: THEN
1779: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
1780: END IF;
1781: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
1782:
1783: END auto_adopt_articles_blk;
1784:
1785: -----------------------------------------------------------------------------

Line 1841: fnd_msg_pub.initialize;

1837: IF NOT fnd_api.compatible_api_call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: END IF;
1840: IF fnd_api.to_boolean( p_init_msg_list ) THEN
1841: fnd_msg_pub.initialize;
1842: END IF;
1843: x_return_status := FND_API.G_RET_STS_SUCCESS;
1844:
1845:

Line 2014: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2010: -- delete rows created in the temp table
2011: DELETE FROM OKC_ART_BLK_TEMP
2012: WHERE id IN (l_id, l_rel_id);
2013:
2014: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2015: IF(FND_API.to_boolean(p_commit)) THEN
2016: COMMIT;
2017: END IF;
2018:

Line 2032: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2028:
2029: IF (l_debug = 'Y') THEN
2030: okc_debug.log('201: Leaving pending_approval_blk: Error');
2031: END IF;
2032: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2033:
2034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2035: ROLLBACK TO pending_approval_blk_PVT;
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2042: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2038: IF (l_debug = 'Y') THEN
2039: okc_debug.log('202: Leaving pending_approval_blk: Unexpected Error');
2040: END IF;
2041:
2042: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2043:
2044: WHEN OTHERS THEN
2045: ROLLBACK TO pending_approval_blk_PVT;
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2048: IF (l_debug = 'Y') THEN
2049: okc_debug.log('203: Leaving pending_approval_blk: Unknown Error');
2050: END IF;
2051:
2052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2053: THEN
2054: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2055: END IF;
2056: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

Line 2054: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

2050: END IF;
2051:
2052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2053: THEN
2054: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2055: END IF;
2056: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2057:
2058: END pending_approval_blk;

Line 2056: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2053: THEN
2054: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2055: END IF;
2056: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2057:
2058: END pending_approval_blk;
2059:
2060: ---------------------------------------------------------------------

Line 2111: fnd_msg_pub.initialize;

2107: IF NOT fnd_api.compatible_api_call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2109: END IF;
2110: IF fnd_api.to_boolean( p_init_msg_list ) THEN
2111: fnd_msg_pub.initialize;
2112: END IF;
2113: x_return_status := FND_API.G_RET_STS_SUCCESS;
2114:
2115:

Line 2251: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2247: -- delete rows created in the temp table
2248: DELETE FROM OKC_ART_BLK_TEMP
2249: WHERE id = l_id;
2250:
2251: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2252: IF(FND_API.to_boolean(p_commit)) THEN
2253: COMMIT;
2254: END IF;
2255:

Line 2270: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2266:
2267: IF (l_debug = 'Y') THEN
2268: okc_debug.log('201: Leaving approve_blk: Error');
2269: END IF;
2270: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2271:
2272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2273: ROLLBACK TO approve_blk_PVT;
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2279: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2275:
2276: IF (l_debug = 'Y') THEN
2277: okc_debug.log('202: Leaving approve_blk: Unexpected Error');
2278: END IF;
2279: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2280:
2281: WHEN OTHERS THEN
2282: ROLLBACK TO approve_blk_PVT;
2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2285: IF (l_debug = 'Y') THEN
2286: okc_debug.log('203: Leaving approve_blk: Unknown Error');
2287: END IF;
2288:
2289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2290: THEN
2291: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2292: END IF;
2293: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

Line 2291: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

2287: END IF;
2288:
2289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2290: THEN
2291: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2292: END IF;
2293: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2294:
2295: END approve_blk;

Line 2293: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2290: THEN
2291: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2292: END IF;
2293: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2294:
2295: END approve_blk;
2296:
2297: ---------------------------------------------------------------------

Line 2348: fnd_msg_pub.initialize;

2344: IF NOT fnd_api.compatible_api_call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2346: END IF;
2347: IF fnd_api.to_boolean( p_init_msg_list ) THEN
2348: fnd_msg_pub.initialize;
2349: END IF;
2350: x_return_status := FND_API.G_RET_STS_SUCCESS;
2351:
2352: -- first populate the the temp table with all the relevant details

Line 2466: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2462: -- delete rows created in the temp table
2463: DELETE FROM OKC_ART_BLK_TEMP
2464: WHERE id = l_id;
2465:
2466: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2467: IF(FND_API.to_boolean(p_commit)) THEN
2468: COMMIT;
2469: END IF;
2470:

Line 2486: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2482: IF (l_debug = 'Y') THEN
2483: okc_debug.log('201: Leaving reject_blk: Error');
2484: END IF;
2485:
2486: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2487:
2488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2489: ROLLBACK TO reject_blk_PVT;
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2496: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2492: IF (l_debug = 'Y') THEN
2493: okc_debug.log('202: Leaving reject_blk: Unexpected Error');
2494: END IF;
2495:
2496: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2497:
2498: WHEN OTHERS THEN
2499: ROLLBACK TO reject_blk_PVT;
2500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2502: IF (l_debug = 'Y') THEN
2503: okc_debug.log('203: Leaving reject_blk: Unknown Error');
2504: END IF;
2505:
2506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2507: THEN
2508: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2509: END IF;
2510: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

Line 2508: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );

2504: END IF;
2505:
2506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2507: THEN
2508: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2509: END IF;
2510: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2511:
2512: END reject_blk;

Line 2510: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);

2506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2507: THEN
2508: fnd_msg_pub.add_exc_msg(G_PKG_NAME ,l_api_name );
2509: END IF;
2510: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2511:
2512: END reject_blk;
2513:
2514: -----------------------------------------------------------------------------