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.BIS_TARGET_PVT dependencies on HTP

Line 285: htp.p('BIS_TARGET_PVT.Create_Target:G_EXC_ERROR'); htp.para;

281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: x_return_status:= FND_API.G_RET_STS_ERROR;
284: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
285: htp.p('BIS_TARGET_PVT.Create_Target:G_EXC_ERROR'); htp.para;
286: END IF;
287: --RAISE;
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 291: htp.p('BIS_TARGET_PVT.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

287: --RAISE;
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
290: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
291: htp.p('BIS_TARGET_PVT.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
292: END IF;
293: --RAISE;
294: WHEN OTHERS THEN
295: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 304: htp.p('BIS_TARGET_PVT.Create_Target:OTHERS'); htp.para;

300: , p_error_description => SQLERRM
301: , x_error_table => x_error_Tbl
302: );
303: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
304: htp.p('BIS_TARGET_PVT.Create_Target:OTHERS'); htp.para;
305: END IF;
306: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: --
308: END Create_Target;

Line 526: htp.p('BIS_TARGET_PVT.Retrieve_Targets:G_EXC_ERROR'); htp.para;

522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: x_return_status:= FND_API.G_RET_STS_ERROR;
525: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
526: htp.p('BIS_TARGET_PVT.Retrieve_Targets:G_EXC_ERROR'); htp.para;
527: END IF;
528: --RAISE;
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 532: htp.p('BIS_TARGET_PVT.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR');

528: --RAISE;
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
531: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
532: htp.p('BIS_TARGET_PVT.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR');
533: htp.para;
534: END IF;
535: --RAISE;
536: WHEN OTHERS THEN

Line 533: htp.para;

529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
531: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
532: htp.p('BIS_TARGET_PVT.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR');
533: htp.para;
534: END IF;
535: --RAISE;
536: WHEN OTHERS THEN
537: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 546: htp.p('BIS_TARGET_PVT.Retrieve_Targets:OTHERS'); htp.para;

542: , p_error_description => SQLERRM
543: , x_error_table => x_error_Tbl
544: );
545: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
546: htp.p('BIS_TARGET_PVT.Retrieve_Targets:OTHERS'); htp.para;
547: END IF;
548: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: --
550: END Retrieve_Targets;

Line 1069: htp.p('BIS_TARGET_PVT.Retrieve_Target:G_EXC_ERROR'); htp.para;

1065: x_return_status := FND_API.G_RET_STS_ERROR ;
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: x_return_status:= FND_API.G_RET_STS_ERROR;
1068: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1069: htp.p('BIS_TARGET_PVT.Retrieve_Target:G_EXC_ERROR'); htp.para;
1070: END IF;
1071: -- RAISE;
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1075: htp.p('BIS_TARGET_PVT.Retrieve_Target:G_EXC_UNEXPECTED_ERROR');

1071: -- RAISE;
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1074: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1075: htp.p('BIS_TARGET_PVT.Retrieve_Target:G_EXC_UNEXPECTED_ERROR');
1076: htp.para;
1077: END IF;
1078: -- RAISE;
1079: WHEN OTHERS THEN

Line 1076: htp.para;

1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1074: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1075: htp.p('BIS_TARGET_PVT.Retrieve_Target:G_EXC_UNEXPECTED_ERROR');
1076: htp.para;
1077: END IF;
1078: -- RAISE;
1079: WHEN OTHERS THEN
1080: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1089: htp.p('BIS_TARGET_PVT.Retrieve_Target:OTHERS'); htp.para;

1085: , p_error_description => SQLERRM
1086: , x_error_table => x_error_Tbl
1087: );
1088: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1089: htp.p('BIS_TARGET_PVT.Retrieve_Target:OTHERS'); htp.para;
1090: END IF;
1091: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: --
1093: END Retrieve_Target;

Line 1152: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_ERROR');

1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status:= FND_API.G_RET_STS_ERROR;
1151: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1152: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_ERROR');
1153: htp.para;
1154: END IF;
1155: -- RAISE;
1156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1153: htp.para;

1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status:= FND_API.G_RET_STS_ERROR;
1151: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1152: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_ERROR');
1153: htp.para;
1154: END IF;
1155: -- RAISE;
1156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1157: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1159: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_UNEXPECTED_ERROR');

1155: -- RAISE;
1156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1157: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1158: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1159: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_UNEXPECTED_ERROR');
1160: htp.para;
1161: END IF;
1162: -- RAISE;
1163: WHEN OTHERS THEN

Line 1160: htp.para;

1156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1157: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1158: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1159: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_UNEXPECTED_ERROR');
1160: htp.para;
1161: END IF;
1162: -- RAISE;
1163: WHEN OTHERS THEN
1164: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1173: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:OTHERS'); htp.para;

1169: , p_error_description => SQLERRM
1170: , x_error_table => x_error_Tbl
1171: );
1172: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1173: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:OTHERS'); htp.para;
1174: END IF;
1175: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176:
1177: END Retrieve_Target_Owners;

Line 1343: htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_ERROR'); htp.para;

1339: EXCEPTION
1340: WHEN FND_API.G_EXC_ERROR THEN
1341: x_return_status:= FND_API.G_RET_STS_ERROR;
1342: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1343: htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_ERROR'); htp.para;
1344: END IF;
1345: --RAISE;
1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1347: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1349: htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

1345: --RAISE;
1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1347: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1349: htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
1350: END IF;
1351: --RAISE;
1352: WHEN OTHERS THEN
1353: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1362: htp.p('BIS_TARGET_PVT.Update_Target:OTHERS'); htp.para;

1358: , p_error_description => SQLERRM
1359: , x_error_table => x_error_Tbl
1360: );
1361: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1362: htp.p('BIS_TARGET_PVT.Update_Target:OTHERS'); htp.para;
1363: END IF;
1364: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: --
1366: END Update_Target;

Line 1465: htp.p('BIS_TARGET_PVT.GetID:NO_DATA_FOUND'); htp.para;

1461: , p_error_table => l_error_tbl
1462: , x_error_table => x_error_tbl
1463: );
1464: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1465: htp.p('BIS_TARGET_PVT.GetID:NO_DATA_FOUND'); htp.para;
1466: END IF;
1467: -- RAISE FND_API.G_EXC_ERROR;
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 1471: htp.p('BIS_TARGET_PVT.GetID:G_EXC_ERROR'); htp.para;

1467: -- RAISE FND_API.G_EXC_ERROR;
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: x_return_status:= FND_API.G_RET_STS_ERROR;
1470: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1471: htp.p('BIS_TARGET_PVT.GetID:G_EXC_ERROR'); htp.para;
1472: END IF;
1473: -- RAISE;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1477: htp.p('BIS_TARGET_PVT.GetID:G_EXC_UNEXPECTED_ERROR'); htp.para;

1473: -- RAISE;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1476: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1477: htp.p('BIS_TARGET_PVT.GetID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1478: END IF;
1479: -- RAISE;
1480: WHEN OTHERS THEN
1481: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1490: htp.p('BIS_TARGET_PVT.GetID:OTHERS'); htp.para;

1486: , p_error_description => SQLERRM
1487: , x_error_table => x_error_Tbl
1488: );
1489: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1490: htp.p('BIS_TARGET_PVT.GetID:OTHERS'); htp.para;
1491: END IF;
1492: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1493: --
1494: END GetID;

Line 1552: htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_ERROR'); htp.para;

1548: );
1549: WHEN FND_API.G_EXC_ERROR THEN
1550: x_return_status:= FND_API.G_RET_STS_ERROR;
1551: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1552: htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_ERROR'); htp.para;
1553: END IF;
1554: -- RAISE;
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1558: htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;

1554: -- RAISE;
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1558: htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
1559: END IF;
1560: -- RAISE;
1561: WHEN OTHERS THEN
1562: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1571: htp.p('BIS_TARGET_PVT.Delete_Target:OTHERS'); htp.para;

1567: , p_error_description => SQLERRM
1568: , x_error_table => x_error_Tbl
1569: );
1570: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1571: htp.p('BIS_TARGET_PVT.Delete_Target:OTHERS'); htp.para;
1572: END IF;
1573: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574: --
1575: END Delete_Target;

Line 1597: -- htp.header(5,'in validate target '||p_target_rec.target_level_id||'
');

1593: --
1594: BEGIN
1595: x_return_status := FND_API.G_RET_STS_SUCCESS;
1596: --
1597: -- htp.header(5,'in validate target '||p_target_rec.target_level_id||'
');
1598: BEGIN
1599:
1600: -- dbms_output.put_line( ' Inside pvt : 41 ' || l_error );
1601:

Line 1608: -- htp.header(5,'target level: '||l_return_status||'
');

1604: , p_Target_Rec => p_Target_Rec
1605: , x_return_status => l_return_status
1606: , x_error_Tbl => x_error_Tbl
1607: );
1608: -- htp.header(5,'target level: '||l_return_status||'
');
1609: --
1610:
1611: -- dbms_output.put_line( ' Inside pvt : 42 ' || l_error );
1612:

Line 2122: htp.p('BIS_TARGET_PVT.Validate_Target:G_EXC_ERROR'); htp.para;

2118: EXCEPTION
2119: WHEN FND_API.G_EXC_ERROR THEN
2120: x_return_status:= FND_API.G_RET_STS_ERROR;
2121: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2122: htp.p('BIS_TARGET_PVT.Validate_Target:G_EXC_ERROR'); htp.para;
2123: END IF;
2124: --RAISE;
2125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2128: htp.p('BIS_TARGET_PVT.Validate_Target:G_EXC_UNEXPECTED_ERROR');

2124: --RAISE;
2125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2128: htp.p('BIS_TARGET_PVT.Validate_Target:G_EXC_UNEXPECTED_ERROR');
2129: htp.para;
2130: END IF;
2131: -- RAISE;
2132: WHEN OTHERS THEN

Line 2129: htp.para;

2125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2128: htp.p('BIS_TARGET_PVT.Validate_Target:G_EXC_UNEXPECTED_ERROR');
2129: htp.para;
2130: END IF;
2131: -- RAISE;
2132: WHEN OTHERS THEN
2133: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2142: htp.p('BIS_TARGET_PVT.Validate_Target:OTHERS'); htp.para;

2138: , p_error_description => SQLERRM
2139: , x_error_table => x_error_Tbl
2140: );
2141: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2142: htp.p('BIS_TARGET_PVT.Validate_Target:OTHERS'); htp.para;
2143: END IF;
2144: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END Validate_Target;
2146: --

Line 2167: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:G_EXC_ERROR'); htp.para;

2163: EXCEPTION
2164: WHEN FND_API.G_EXC_ERROR THEN
2165: x_return_status:= FND_API.G_RET_STS_ERROR;
2166: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2167: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:G_EXC_ERROR'); htp.para;
2168: END IF;
2169: -- RAISE;
2170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2171: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2173: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:G_EXC_UNEXPECTED_ERROR');

2169: -- RAISE;
2170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2171: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2172: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2173: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:G_EXC_UNEXPECTED_ERROR');
2174: htp.para;
2175: END IF;
2176: -- RAISE;
2177: WHEN OTHERS THEN

Line 2174: htp.para;

2170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2171: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2172: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2173: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:G_EXC_UNEXPECTED_ERROR');
2174: htp.para;
2175: END IF;
2176: -- RAISE;
2177: WHEN OTHERS THEN
2178: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2187: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:OTHERS'); htp.para;

2183: , p_error_description => SQLERRM
2184: , x_error_table => x_error_Tbl
2185: );
2186: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2187: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:OTHERS'); htp.para;
2188: END IF;
2189: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: END Value_ID_Conversion;
2191: --

Line 2307: htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_ERROR'); htp.para;

2303: EXCEPTION
2304: WHEN FND_API.G_EXC_ERROR THEN
2305: x_return_status:= FND_API.G_RET_STS_ERROR;
2306: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2307: htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_ERROR'); htp.para;
2308: END IF;
2309: --RAISE;
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2313: htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_UNEXPECTED_ERROR');

2309: --RAISE;
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2312: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2313: htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_UNEXPECTED_ERROR');
2314: htp.para;
2315: END IF;
2316: --RAISE;
2317: WHEN OTHERS THEN

Line 2314: htp.para;

2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2312: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2313: htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_UNEXPECTED_ERROR');
2314: htp.para;
2315: END IF;
2316: --RAISE;
2317: WHEN OTHERS THEN
2318: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2327: htp.p('BIS_TARGET_PVT.Update_db_Target:OTHERS'); htp.para;

2323: , p_error_description => SQLERRM
2324: , x_error_table => x_error_Tbl
2325: );
2326: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2327: htp.p('BIS_TARGET_PVT.Update_db_Target:OTHERS'); htp.para;
2328: END IF;
2329: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2330: --
2331: END Update_db_Target;

Line 2375: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:NO_DATA_FOUND');

2371: , x_error_table => x_error_tbl
2372: );
2373: x_return_status := FND_API.G_RET_STS_ERROR;
2374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2375: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:NO_DATA_FOUND');
2376: htp.para;
2377: END IF;
2378: --RAISE FND_API.G_EXC_ERROR;
2379: WHEN FND_API.G_EXC_ERROR THEN

Line 2376: htp.para;

2372: );
2373: x_return_status := FND_API.G_RET_STS_ERROR;
2374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2375: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:NO_DATA_FOUND');
2376: htp.para;
2377: END IF;
2378: --RAISE FND_API.G_EXC_ERROR;
2379: WHEN FND_API.G_EXC_ERROR THEN
2380: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 2382: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_ERROR');

2378: --RAISE FND_API.G_EXC_ERROR;
2379: WHEN FND_API.G_EXC_ERROR THEN
2380: x_return_status:= FND_API.G_RET_STS_ERROR;
2381: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2382: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_ERROR');
2383: htp.para;
2384: END IF;
2385: -- RAISE;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2383: htp.para;

2379: WHEN FND_API.G_EXC_ERROR THEN
2380: x_return_status:= FND_API.G_RET_STS_ERROR;
2381: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2382: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_ERROR');
2383: htp.para;
2384: END IF;
2385: -- RAISE;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2389: htp.p

2385: -- RAISE;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2388: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2389: htp.p
2390: ('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_UNEXPECTED_ERROR');
2391: htp.para;
2392: END IF;
2393: -- RAISE;

Line 2391: htp.para;

2387: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2388: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2389: htp.p
2390: ('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_UNEXPECTED_ERROR');
2391: htp.para;
2392: END IF;
2393: -- RAISE;
2394: WHEN OTHERS THEN
2395: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2404: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:OTHERS'); htp.para;

2400: , p_error_description => SQLERRM
2401: , x_error_table => x_error_Tbl
2402: );
2403: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2404: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:OTHERS'); htp.para;
2405: END IF;
2406: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: --
2408: END Retrieve_Last_Update_Date;

Line 2455: htp.p('BIS_TARGET_PVT.Lock_Record:G_EXC_ERROR'); htp.para;

2451: WHEN FND_API.G_EXC_ERROR THEN
2452: x_return_status:= FND_API.G_RET_STS_ERROR;
2453: x_result := FND_API.G_FALSE;
2454: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2455: htp.p('BIS_TARGET_PVT.Lock_Record:G_EXC_ERROR'); htp.para;
2456: END IF;
2457: -- RAISE;
2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2459: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2462: htp.p('BIS_TARGET_PVT.Lock_Record:G_EXC_UNEXPECTED_ERROR');

2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2459: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2460: x_result := FND_API.G_FALSE;
2461: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2462: htp.p('BIS_TARGET_PVT.Lock_Record:G_EXC_UNEXPECTED_ERROR');
2463: htp.para;
2464: END IF;
2465: -- RAISE;
2466: WHEN OTHERS THEN

Line 2463: htp.para;

2459: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2460: x_result := FND_API.G_FALSE;
2461: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2462: htp.p('BIS_TARGET_PVT.Lock_Record:G_EXC_UNEXPECTED_ERROR');
2463: htp.para;
2464: END IF;
2465: -- RAISE;
2466: WHEN OTHERS THEN
2467: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2477: htp.p('BIS_TARGET_PVT.Lock_Record:OTHERS'); htp.para;

2473: , x_error_table => x_error_Tbl
2474: );
2475: x_result := FND_API.G_FALSE;
2476: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2477: htp.p('BIS_TARGET_PVT.Lock_Record:OTHERS'); htp.para;
2478: END IF;
2479: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: --
2481: END Lock_Record;

Line 2563: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:NO_DATA_FOUND');

2559: EXCEPTION
2560: WHEN NO_DATA_FOUND THEN
2561: x_return_status:= FND_API.G_RET_STS_ERROR;
2562: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2563: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:NO_DATA_FOUND');
2564: htp.para;
2565: END IF;
2566: -- RAISE FND_API.G_EXC_ERROR;
2567: WHEN FND_API.G_EXC_ERROR THEN

Line 2564: htp.para;

2560: WHEN NO_DATA_FOUND THEN
2561: x_return_status:= FND_API.G_RET_STS_ERROR;
2562: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2563: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:NO_DATA_FOUND');
2564: htp.para;
2565: END IF;
2566: -- RAISE FND_API.G_EXC_ERROR;
2567: WHEN FND_API.G_EXC_ERROR THEN
2568: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 2570: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_ERROR');

2566: -- RAISE FND_API.G_EXC_ERROR;
2567: WHEN FND_API.G_EXC_ERROR THEN
2568: x_return_status:= FND_API.G_RET_STS_ERROR;
2569: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2570: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_ERROR');
2571: htp.para;
2572: END IF;
2573: -- RAISE;
2574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2571: htp.para;

2567: WHEN FND_API.G_EXC_ERROR THEN
2568: x_return_status:= FND_API.G_RET_STS_ERROR;
2569: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2570: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_ERROR');
2571: htp.para;
2572: END IF;
2573: -- RAISE;
2574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2575: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 2577: htp.p

2573: -- RAISE;
2574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2575: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2576: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2577: htp.p
2578: ('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_UNEXPECTED_ERROR');
2579: htp.para;
2580:
2581: END IF;

Line 2579: htp.para;

2575: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2576: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2577: htp.p
2578: ('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_UNEXPECTED_ERROR');
2579: htp.para;
2580:
2581: END IF;
2582: -- RAISE;
2583: WHEN OTHERS THEN

Line 2593: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:OTHERS'); htp.para;

2589: , p_error_description => SQLERRM
2590: , x_error_table => x_error_Tbl
2591: );
2592: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2593: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:OTHERS'); htp.para;
2594: END IF;
2595: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2596: --
2597: END Retrieve_Measure_Dim_Values;

Line 2618: htp.p('BIS_TARGET_PVT.GetQueryStatement'); htp.para;

2614: --commented RAISE
2615: EXCEPTION
2616: WHEN OTHERS THEN
2617: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2618: htp.p('BIS_TARGET_PVT.GetQueryStatement'); htp.para;
2619: END IF;
2620: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2621: END GetQueryStatement;
2622: --

Line 2741: htp.p('BIS_TARGET_PVT.GetViewNames'); htp.para;

2737: --commented RAISE
2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2741: htp.p('BIS_TARGET_PVT.GetViewNames'); htp.para;
2742: END IF;
2743: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2744: END GetViewNames;
2745: --

Line 2778: htp.p('BIS_TARGET_PVT.GetComputingUserFunctionName:OTHERS');

2774: --commented RAISE
2775: EXCEPTION
2776: WHEN OTHERS THEN
2777: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2778: htp.p('BIS_TARGET_PVT.GetComputingUserFunctionName:OTHERS');
2779: htp.para;
2780: END IF;
2781: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2782: END GetComputingUserFunctionName;

Line 2779: htp.para;

2775: EXCEPTION
2776: WHEN OTHERS THEN
2777: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2778: htp.p('BIS_TARGET_PVT.GetComputingUserFunctionName:OTHERS');
2779: htp.para;
2780: END IF;
2781: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2782: END GetComputingUserFunctionName;
2783: --

Line 2810: htp.p('BIS_TARGET_PVT.GetNotifyResponsibilityName:OTHERS');

2806: --commented RAISE
2807: EXCEPTION
2808: WHEN OTHERS THEN
2809: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2810: htp.p('BIS_TARGET_PVT.GetNotifyResponsibilityName:OTHERS');
2811: htp.para;
2812: END IF;
2813: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2814: END GetNotifyResponsibilityName;

Line 2811: htp.para;

2807: EXCEPTION
2808: WHEN OTHERS THEN
2809: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2810: htp.p('BIS_TARGET_PVT.GetNotifyResponsibilityName:OTHERS');
2811: htp.para;
2812: END IF;
2813: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2814: END GetNotifyResponsibilityName;
2815: --

Line 3012: -- htp.header(5,'Exception in Get Target');

3008:
3009: --commented RAISE
3010: EXCEPTION
3011: WHEN OTHERS THEN
3012: -- htp.header(5,'Exception in Get Target');
3013: htp.p(SQLERRM);
3014: -- RAISE;
3015:
3016: END Get_Target;

Line 3013: htp.p(SQLERRM);

3009: --commented RAISE
3010: EXCEPTION
3011: WHEN OTHERS THEN
3012: -- htp.header(5,'Exception in Get Target');
3013: htp.p(SQLERRM);
3014: -- RAISE;
3015:
3016: END Get_Target;
3017: --