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 659: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

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

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

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

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

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

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

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

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

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

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

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

Line 934: FND_MSG_PUB.add;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1347: fnd_msg_pub.initialize;

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

Line 1425: l_curr_msg_count := fnd_msg_pub.count_msg;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1621: fnd_msg_pub.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1840: fnd_msg_pub.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2110: fnd_msg_pub.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2347: fnd_msg_pub.initialize;

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

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

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

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

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

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

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

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

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

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

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

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

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