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.PO_DOCUMENT_CANCEL_PVT dependencies on FND_LOG

Line 491: FND_LOG.STRING(

487: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
488:
489: WHEN OTHERS THEN
490: IF (G_DEBUG_UNEXP) THEN
491: FND_LOG.STRING(
492: FND_LOG.LEVEL_UNEXPECTED,
493: d_module || '.OTHERS_EXCEPTION',
494: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
495: END IF;

Line 492: FND_LOG.LEVEL_UNEXPECTED,

488:
489: WHEN OTHERS THEN
490: IF (G_DEBUG_UNEXP) THEN
491: FND_LOG.STRING(
492: FND_LOG.LEVEL_UNEXPECTED,
493: d_module || '.OTHERS_EXCEPTION',
494: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
495: END IF;
496: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2012: FND_LOG.STRING(

2008: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2009:
2010: WHEN OTHERS THEN
2011: IF (G_DEBUG_UNEXP) THEN
2012: FND_LOG.STRING(
2013: FND_LOG.LEVEL_UNEXPECTED,
2014: d_module || '.OTHERS_EXCEPTION',
2015: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2016: END IF;

Line 2013: FND_LOG.LEVEL_UNEXPECTED,

2009:
2010: WHEN OTHERS THEN
2011: IF (G_DEBUG_UNEXP) THEN
2012: FND_LOG.STRING(
2013: FND_LOG.LEVEL_UNEXPECTED,
2014: d_module || '.OTHERS_EXCEPTION',
2015: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2016: END IF;
2017:

Line 2217: FND_LOG.STRING(

2213: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2214:
2215: WHEN OTHERS THEN
2216: IF (G_DEBUG_UNEXP) THEN
2217: FND_LOG.STRING(
2218: FND_LOG.LEVEL_UNEXPECTED,
2219: d_module || '.OTHERS_EXCEPTION',
2220: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2221: END IF;

Line 2218: FND_LOG.LEVEL_UNEXPECTED,

2214:
2215: WHEN OTHERS THEN
2216: IF (G_DEBUG_UNEXP) THEN
2217: FND_LOG.STRING(
2218: FND_LOG.LEVEL_UNEXPECTED,
2219: d_module || '.OTHERS_EXCEPTION',
2220: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2221: END IF;
2222:

Line 2343: FND_LOG.string(FND_LOG.level_unexpected,d_module ||'---at '||l_progress || 'UnExpected Error', SQLERRM);

2339: P_ENCODED => 'F');
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2341: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2342: IF (g_debug_unexp) THEN
2343: FND_LOG.string(FND_LOG.level_unexpected,d_module ||'---at '||l_progress || 'UnExpected Error', SQLERRM);
2344: END IF;
2345:
2346:
2347: WHEN FND_API.G_EXC_ERROR THEN

Line 2354: FND_LOG.string(FND_LOG.level_unexpected,d_module ||'---at '||l_progress || 'UnExpected Error', SQLERRM);

2350: P_ENCODED => 'F');
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2353: IF (g_debug_unexp) THEN
2354: FND_LOG.string(FND_LOG.level_unexpected,d_module ||'---at '||l_progress || 'UnExpected Error', SQLERRM);
2355: END IF;
2356:
2357:
2358: WHEN OTHERS THEN

Line 2360: FND_LOG.STRING(

2356:
2357:
2358: WHEN OTHERS THEN
2359: IF (G_DEBUG_UNEXP) THEN
2360: FND_LOG.STRING(
2361: FND_LOG.LEVEL_UNEXPECTED,
2362: d_module || '.OTHERS_EXCEPTION',
2363: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2364: END IF;

Line 2361: FND_LOG.LEVEL_UNEXPECTED,

2357:
2358: WHEN OTHERS THEN
2359: IF (G_DEBUG_UNEXP) THEN
2360: FND_LOG.STRING(
2361: FND_LOG.LEVEL_UNEXPECTED,
2362: d_module || '.OTHERS_EXCEPTION',
2363: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2364: END IF;
2365: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2584: FND_LOG.STRING(

2580: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2581:
2582: WHEN OTHERS THEN
2583: IF (G_DEBUG_UNEXP) THEN
2584: FND_LOG.STRING(
2585: FND_LOG.LEVEL_UNEXPECTED,
2586: d_module || '.OTHERS_EXCEPTION',
2587: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2588: END IF;

Line 2585: FND_LOG.LEVEL_UNEXPECTED,

2581:
2582: WHEN OTHERS THEN
2583: IF (G_DEBUG_UNEXP) THEN
2584: FND_LOG.STRING(
2585: FND_LOG.LEVEL_UNEXPECTED,
2586: d_module || '.OTHERS_EXCEPTION',
2587: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
2588: END IF;
2589: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 2760: FND_LOG.STRING(

2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2758: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2759: IF(G_DEBUG_UNEXP) THEN
2760: FND_LOG.STRING(
2761: FND_LOG.LEVEL_UNEXPECTED,
2762: d_module || '.UNEXPECTED',
2763: 'ERROR: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE|| ' SQL ERRM IS '||SQLERRM);
2764: END IF;

Line 2761: FND_LOG.LEVEL_UNEXPECTED,

2757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2758: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2759: IF(G_DEBUG_UNEXP) THEN
2760: FND_LOG.STRING(
2761: FND_LOG.LEVEL_UNEXPECTED,
2762: d_module || '.UNEXPECTED',
2763: 'ERROR: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE|| ' SQL ERRM IS '||SQLERRM);
2764: END IF;
2765:

Line 2771: FND_LOG.STRING(

2767: WHEN FND_API.G_EXC_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_ERROR;
2769: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2770: IF (G_DEBUG_UNEXP) THEN
2771: FND_LOG.STRING(
2772: FND_LOG.LEVEL_UNEXPECTED,
2773: d_module || '.ERROR ERROR',
2774: 'ERROR: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE|| ' SQL ERRM IS '||SQLERRM);
2775: END IF;

Line 2772: FND_LOG.LEVEL_UNEXPECTED,

2768: x_return_status := FND_API.G_RET_STS_ERROR;
2769: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
2770: IF (G_DEBUG_UNEXP) THEN
2771: FND_LOG.STRING(
2772: FND_LOG.LEVEL_UNEXPECTED,
2773: d_module || '.ERROR ERROR',
2774: 'ERROR: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE|| ' SQL ERRM IS '||SQLERRM);
2775: END IF;
2776:

Line 2779: FND_LOG.STRING(

2775: END IF;
2776:
2777: WHEN OTHERS THEN
2778: IF (G_DEBUG_UNEXP) THEN
2779: FND_LOG.STRING(
2780: FND_LOG.LEVEL_UNEXPECTED,
2781: d_module || '.OTHERS_EXCEPTION',
2782: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE|| ' SQL ERRM IS '||SQLERRM);
2783: END IF;

Line 2780: FND_LOG.LEVEL_UNEXPECTED,

2776:
2777: WHEN OTHERS THEN
2778: IF (G_DEBUG_UNEXP) THEN
2779: FND_LOG.STRING(
2780: FND_LOG.LEVEL_UNEXPECTED,
2781: d_module || '.OTHERS_EXCEPTION',
2782: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE|| ' SQL ERRM IS '||SQLERRM);
2783: END IF;
2784: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 3365: FND_LOG.STRING(

3361: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3362:
3363: WHEN OTHERS THEN
3364: IF (G_DEBUG_UNEXP) THEN
3365: FND_LOG.STRING(
3366: FND_LOG.LEVEL_UNEXPECTED,
3367: d_module || '.OTHERS_EXCEPTION',
3368: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3369: END IF;

Line 3366: FND_LOG.LEVEL_UNEXPECTED,

3362:
3363: WHEN OTHERS THEN
3364: IF (G_DEBUG_UNEXP) THEN
3365: FND_LOG.STRING(
3366: FND_LOG.LEVEL_UNEXPECTED,
3367: d_module || '.OTHERS_EXCEPTION',
3368: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3369: END IF;
3370:

Line 3815: FND_LOG.STRING(

3811: x_return_status := FND_API.G_RET_STS_ERROR;
3812: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3813: WHEN OTHERS THEN
3814: IF (G_DEBUG_UNEXP) THEN
3815: FND_LOG.STRING(
3816: FND_LOG.LEVEL_UNEXPECTED,
3817: d_module || '.OTHERS_EXCEPTION',
3818: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3819: END IF;

Line 3816: FND_LOG.LEVEL_UNEXPECTED,

3812: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
3813: WHEN OTHERS THEN
3814: IF (G_DEBUG_UNEXP) THEN
3815: FND_LOG.STRING(
3816: FND_LOG.LEVEL_UNEXPECTED,
3817: d_module || '.OTHERS_EXCEPTION',
3818: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
3819: END IF;
3820: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 4080: FND_LOG.STRING(

4076: x_return_status := FND_API.G_RET_STS_ERROR;
4077: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4078: WHEN OTHERS THEN
4079: IF (G_DEBUG_UNEXP) THEN
4080: FND_LOG.STRING(
4081: FND_LOG.LEVEL_UNEXPECTED,
4082: d_module || '.OTHERS_EXCEPTION',
4083: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
4084: END IF;

Line 4081: FND_LOG.LEVEL_UNEXPECTED,

4077: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4078: WHEN OTHERS THEN
4079: IF (G_DEBUG_UNEXP) THEN
4080: FND_LOG.STRING(
4081: FND_LOG.LEVEL_UNEXPECTED,
4082: d_module || '.OTHERS_EXCEPTION',
4083: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
4084: END IF;
4085:

Line 4624: FND_LOG.STRING(

4620: P_ENCODED => 'F');
4621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4622: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4623: IF (g_debug_unexp) THEN
4624: FND_LOG.STRING(
4625: FND_LOG.LEVEL_UNEXPECTED,
4626: d_module || '.Error',
4627: 'Error: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4628: END IF;

Line 4625: FND_LOG.LEVEL_UNEXPECTED,

4621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4622: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4623: IF (g_debug_unexp) THEN
4624: FND_LOG.STRING(
4625: FND_LOG.LEVEL_UNEXPECTED,
4626: d_module || '.Error',
4627: 'Error: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4628: END IF;
4629:

Line 4638: FND_LOG.STRING(

4634: P_ENCODED => 'F');
4635: x_return_status := FND_API.G_RET_STS_ERROR;
4636: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4637: IF (g_debug_unexp) THEN
4638: FND_LOG.STRING(
4639: FND_LOG.LEVEL_UNEXPECTED,
4640: d_module || '.UnExpected',
4641: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4642: END IF;

Line 4639: FND_LOG.LEVEL_UNEXPECTED,

4635: x_return_status := FND_API.G_RET_STS_ERROR;
4636: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4637: IF (g_debug_unexp) THEN
4638: FND_LOG.STRING(
4639: FND_LOG.LEVEL_UNEXPECTED,
4640: d_module || '.UnExpected',
4641: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4642: END IF;
4643:

Line 4646: FND_LOG.STRING(

4642: END IF;
4643:
4644: WHEN OTHERS THEN
4645: IF (g_debug_unexp) THEN
4646: FND_LOG.STRING(
4647: FND_LOG.LEVEL_UNEXPECTED,
4648: d_module || '.OTHERS',
4649: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4650: END IF;

Line 4647: FND_LOG.LEVEL_UNEXPECTED,

4643:
4644: WHEN OTHERS THEN
4645: IF (g_debug_unexp) THEN
4646: FND_LOG.STRING(
4647: FND_LOG.LEVEL_UNEXPECTED,
4648: d_module || '.OTHERS',
4649: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
4650: END IF;
4651: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 4897: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);

4893:
4894:
4895: WHEN OTHERS THEN
4896: IF (G_DEBUG_UNEXP) THEN
4897: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
4898: END IF;
4899: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
4900: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
4901: P_ENCODED => 'F');

Line 5070: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);

5066: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5067:
5068: WHEN OTHERS THEN
5069: IF (G_DEBUG_UNEXP) THEN
5070: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
5071: END IF;
5072:
5073: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
5074: P_ENCODED => 'F');

Line 5231: FND_LOG.STRING(

5227: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5228:
5229: WHEN OTHERS THEN
5230: IF (g_debug_unexp) THEN
5231: FND_LOG.STRING(
5232: FND_LOG.LEVEL_UNEXPECTED,
5233: d_module || '.OTHERS',
5234: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5235: END IF;

Line 5232: FND_LOG.LEVEL_UNEXPECTED,

5228:
5229: WHEN OTHERS THEN
5230: IF (g_debug_unexp) THEN
5231: FND_LOG.STRING(
5232: FND_LOG.LEVEL_UNEXPECTED,
5233: d_module || '.OTHERS',
5234: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5235: END IF;
5236: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5594: FND_LOG.STRING(

5590: x_return_status := FND_API.G_RET_STS_ERROR;
5591: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5592: WHEN OTHERS THEN
5593: IF (g_debug_unexp) THEN
5594: FND_LOG.STRING(
5595: FND_LOG.LEVEL_UNEXPECTED,
5596: d_module || '.OTHERS',
5597: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5598: END IF;

Line 5595: FND_LOG.LEVEL_UNEXPECTED,

5591: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5592: WHEN OTHERS THEN
5593: IF (g_debug_unexp) THEN
5594: FND_LOG.STRING(
5595: FND_LOG.LEVEL_UNEXPECTED,
5596: d_module || '.OTHERS',
5597: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5598: END IF;
5599: x_msg_data := FND_MSG_PUB.GET(

Line 5743: FND_LOG.STRING(

5739:
5740:
5741: WHEN OTHERS THEN
5742: IF (g_debug_unexp) THEN
5743: FND_LOG.STRING(
5744: FND_LOG.LEVEL_UNEXPECTED,
5745: d_module || '.OTHERS',
5746: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5747: END IF;

Line 5744: FND_LOG.LEVEL_UNEXPECTED,

5740:
5741: WHEN OTHERS THEN
5742: IF (g_debug_unexp) THEN
5743: FND_LOG.STRING(
5744: FND_LOG.LEVEL_UNEXPECTED,
5745: d_module || '.OTHERS',
5746: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
5747: END IF;
5748: x_msg_data := FND_MSG_PUB.GET(

Line 6089: FND_LOG.STRING(

6085: WHEN FND_API.g_exc_error THEN
6086: ROLLBACK TO process_cancel_action_SP;
6087: x_return_status := FND_API.g_ret_sts_error;
6088: IF (g_debug_unexp) THEN
6089: FND_LOG.STRING(
6090: FND_LOG.LEVEL_UNEXPECTED,
6091: d_module || '.Error',
6092: 'Error: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6093: END IF;

Line 6090: FND_LOG.LEVEL_UNEXPECTED,

6086: ROLLBACK TO process_cancel_action_SP;
6087: x_return_status := FND_API.g_ret_sts_error;
6088: IF (g_debug_unexp) THEN
6089: FND_LOG.STRING(
6090: FND_LOG.LEVEL_UNEXPECTED,
6091: d_module || '.Error',
6092: 'Error: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6093: END IF;
6094: WHEN FND_API.g_exc_unexpected_error THEN

Line 6098: FND_LOG.STRING(

6094: WHEN FND_API.g_exc_unexpected_error THEN
6095: ROLLBACK TO process_cancel_action_SP;
6096: x_return_status := FND_API.g_ret_sts_unexp_error;
6097: IF (g_debug_unexp) THEN
6098: FND_LOG.STRING(
6099: FND_LOG.LEVEL_UNEXPECTED,
6100: d_module || '.UnExpected',
6101: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6102: END IF;

Line 6099: FND_LOG.LEVEL_UNEXPECTED,

6095: ROLLBACK TO process_cancel_action_SP;
6096: x_return_status := FND_API.g_ret_sts_unexp_error;
6097: IF (g_debug_unexp) THEN
6098: FND_LOG.STRING(
6099: FND_LOG.LEVEL_UNEXPECTED,
6100: d_module || '.UnExpected',
6101: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6102: END IF;
6103:

Line 6108: FND_LOG.STRING(

6104: WHEN OTHERS THEN
6105: ROLLBACK TO process_cancel_action_SP;
6106: x_return_status := FND_API.g_ret_sts_unexp_error;
6107: IF (g_debug_unexp) THEN
6108: FND_LOG.STRING(
6109: FND_LOG.LEVEL_UNEXPECTED,
6110: d_module || '.OTHERS',
6111: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6112: END IF;

Line 6109: FND_LOG.LEVEL_UNEXPECTED,

6105: ROLLBACK TO process_cancel_action_SP;
6106: x_return_status := FND_API.g_ret_sts_unexp_error;
6107: IF (g_debug_unexp) THEN
6108: FND_LOG.STRING(
6109: FND_LOG.LEVEL_UNEXPECTED,
6110: d_module || '.OTHERS',
6111: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6112: END IF;
6113: END;

Line 6134: FND_LOG.STRING(

6130: x_return_status := FND_API.G_RET_STS_ERROR;
6131: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6132: WHEN OTHERS THEN
6133: IF (g_debug_unexp) THEN
6134: FND_LOG.STRING(
6135: FND_LOG.LEVEL_UNEXPECTED,
6136: d_module || '.OTHERS',
6137: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6138: END IF;

Line 6135: FND_LOG.LEVEL_UNEXPECTED,

6131: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6132: WHEN OTHERS THEN
6133: IF (g_debug_unexp) THEN
6134: FND_LOG.STRING(
6135: FND_LOG.LEVEL_UNEXPECTED,
6136: d_module || '.OTHERS',
6137: 'EXCEPTION: LOCATION IS '|| l_progress || ' SQL CODE IS '||SQLCODE);
6138: END IF;
6139: x_msg_data := FND_MSG_PUB.GET(

Line 6259: FND_LOG.STRING(

6255: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
6256:
6257: WHEN OTHERS THEN
6258: IF (G_DEBUG_UNEXP) THEN
6259: FND_LOG.STRING(
6260: FND_LOG.LEVEL_UNEXPECTED,
6261: d_module || '.OTHERS_EXCEPTION',
6262: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6263: END IF;

Line 6260: FND_LOG.LEVEL_UNEXPECTED,

6256:
6257: WHEN OTHERS THEN
6258: IF (G_DEBUG_UNEXP) THEN
6259: FND_LOG.STRING(
6260: FND_LOG.LEVEL_UNEXPECTED,
6261: d_module || '.OTHERS_EXCEPTION',
6262: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6263: END IF;
6264: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 6497: FND_LOG.STRING(

6493: x_return_status := FND_API.g_ret_sts_error;
6494: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);
6495: ROLLBACK TO cancel_document_PVT;
6496: IF (g_debug_unexp) THEN
6497: FND_LOG.STRING(
6498: FND_LOG.LEVEL_UNEXPECTED,
6499: d_module || '.ERROR',
6500: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6501: END IF;

Line 6498: FND_LOG.LEVEL_UNEXPECTED,

6494: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);
6495: ROLLBACK TO cancel_document_PVT;
6496: IF (g_debug_unexp) THEN
6497: FND_LOG.STRING(
6498: FND_LOG.LEVEL_UNEXPECTED,
6499: d_module || '.ERROR',
6500: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6501: END IF;
6502: WHEN FND_API.g_exc_unexpected_error THEN

Line 6508: FND_LOG.STRING(

6504: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);
6505: ROLLBACK TO cancel_document_PVT;
6506:
6507: IF (g_debug_unexp) THEN
6508: FND_LOG.STRING(
6509: FND_LOG.LEVEL_UNEXPECTED,
6510: d_module || '.UNEXPECTED ERROR',
6511: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6512: END IF;

Line 6509: FND_LOG.LEVEL_UNEXPECTED,

6505: ROLLBACK TO cancel_document_PVT;
6506:
6507: IF (g_debug_unexp) THEN
6508: FND_LOG.STRING(
6509: FND_LOG.LEVEL_UNEXPECTED,
6510: d_module || '.UNEXPECTED ERROR',
6511: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6512: END IF;
6513:

Line 6521: FND_LOG.STRING(

6517: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress);
6518: ROLLBACK TO cancel_document_PVT;
6519:
6520: IF (g_debug_unexp) THEN
6521: FND_LOG.STRING(
6522: FND_LOG.LEVEL_UNEXPECTED,
6523: d_module || '.OTHERS EXCEPTION',
6524: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6525: END IF;

Line 6522: FND_LOG.LEVEL_UNEXPECTED,

6518: ROLLBACK TO cancel_document_PVT;
6519:
6520: IF (g_debug_unexp) THEN
6521: FND_LOG.STRING(
6522: FND_LOG.LEVEL_UNEXPECTED,
6523: d_module || '.OTHERS EXCEPTION',
6524: 'EXCEPTION: LOCATION IS ' || l_progress || ' SQL CODE IS '||SQLCODE);
6525: END IF;
6526:

Line 6633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

6629: x_return_status := FND_API.g_ret_sts_success;
6630: -- End standard API initialization
6631:
6632: IF (g_fnd_debug = 'Y') THEN
6633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
6634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
6635: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
6636: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
6637: END IF;

Line 6634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

6630: -- End standard API initialization
6631:
6632: IF (g_fnd_debug = 'Y') THEN
6633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
6634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||
6635: '.invoked', 'Type: ' || NVL(p_doc_type,'null') ||
6636: ', ID: ' || NVL(TO_CHAR(p_doc_id),'null'));
6637: END IF;
6638: END IF;

Line 6680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN

6676: WHEN FND_API.g_exc_error THEN
6677: x_return_status := FND_API.g_ret_sts_error;
6678: FND_MESSAGE.set_name('PO','PO_CANCEL_REQ_DISALLOWED');
6679: IF (g_fnd_debug = 'Y') THEN
6680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
6681: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name
6682: || '.cancel_req_disallowed', FALSE);
6683: END IF;
6684: END IF;

Line 6681: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name

6677: x_return_status := FND_API.g_ret_sts_error;
6678: FND_MESSAGE.set_name('PO','PO_CANCEL_REQ_DISALLOWED');
6679: IF (g_fnd_debug = 'Y') THEN
6680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
6681: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name
6682: || '.cancel_req_disallowed', FALSE);
6683: END IF;
6684: END IF;
6685: FND_MSG_PUB.add;

Line 6693: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

6689: x_return_status := FND_API.g_ret_sts_unexp_error;
6690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6691: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6692: IF (g_fnd_debug = 'Y') THEN
6693: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
6694: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
6695: l_api_name || '.others_exception', 'Exception');
6696: END IF;
6697: END IF;

Line 6694: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

6690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6691: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6692: IF (g_fnd_debug = 'Y') THEN
6693: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
6694: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
6695: l_api_name || '.others_exception', 'Exception');
6696: END IF;
6697: END IF;
6698: END IF;