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 BIS_TARGET_PVT

Line 1: PACKAGE BODY BIS_TARGET_PVT AS

1: PACKAGE BODY BIS_TARGET_PVT AS
2: /* $Header: BISVTARB.pls 120.1 2006/04/10 07:59:05 psomesul noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |

Line 191: , p_error_proc_name => 'BIS_TARGET_PVT.Create_Target'

187: l_error_tbl := x_error_tbl;
188: BIS_UTILITIES_PVT.Add_Error_Message
189: ( p_error_msg_name => 'BIS_RECORD_EXISTS'
190: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
191: , p_error_proc_name => 'BIS_TARGET_PVT.Create_Target'
192: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
193: , p_error_table => l_error_tbl
194: , x_error_table => x_error_tbl
195: );

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 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 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 1121: BIS_TARGET_PVT.Retrieve_Target

1117: l_target_rec := p_target_rec;
1118: l_target_owners_rec := x_target_owners_rec;
1119:
1120: l_Target_Rec_p := l_Target_Rec;
1121: BIS_TARGET_PVT.Retrieve_Target
1122: ( p_api_version => 1.0
1123: , p_Target_Rec => l_Target_Rec_p
1124: , p_all_info => p_all_info
1125: , x_Target_rec => l_Target_rec

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 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 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 1272: , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'

1268: l_error_tbl := x_error_tbl;
1269: BIS_UTILITIES_PVT.Add_Error_Message
1270: ( p_error_msg_name => 'BIS_UNIQUE_INDEX_VIOLATION'
1271: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1272: , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'
1273: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1274: , p_error_table => l_error_tbl
1275: , x_error_table => x_error_tbl
1276: );

Line 1287: , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'

1283: l_error_tbl := x_error_tbl;
1284: BIS_UTILITIES_PVT.Add_Error_Message
1285: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
1286: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1287: , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'
1288: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1289: , p_error_table => l_error_tbl
1290: , x_error_table => x_error_tbl
1291: );

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 1459: , p_error_proc_name => 'BIS_TARGET_PVT.GetID'

1455: l_error_tbl := x_error_tbl;
1456: BIS_UTILITIES_PVT.Add_Error_Message
1457: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
1458: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1459: , p_error_proc_name => 'BIS_TARGET_PVT.GetID'
1460: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1461: , p_error_table => l_error_tbl
1462: , x_error_table => x_error_tbl
1463: );

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 1544: , p_error_proc_name => 'BIS_TARGET_PVT.Delete_Target'

1540: l_error_tbl := x_error_tbl;
1541: BIS_UTILITIES_PVT.Add_Error_Message
1542: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
1543: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1544: , p_error_proc_name => 'BIS_TARGET_PVT.Delete_Target'
1545: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1546: , p_error_table => l_error_tbl
1547: , x_error_table => x_error_tbl
1548: );

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 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 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 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 2207: BIS_TARGET_PVT.Retrieve_Target

2203: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2204: --
2205: BEGIN
2206: -- retrieve record from db
2207: BIS_TARGET_PVT.Retrieve_Target
2208: ( p_api_version => 1.0
2209: , p_Target_Rec => p_Target_Rec
2210: , x_Target_Rec => l_Target_Rec
2211: , x_return_status => l_return_status

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 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 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 2390: ('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_UNEXPECTED_ERROR');

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;
2394: WHEN OTHERS THEN

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 2430: BIS_TARGET_PVT.Retrieve_Last_Update_Date

2426: BEGIN
2427: x_return_status := FND_API.G_RET_STS_SUCCESS;
2428: --
2429: l_Target_Rec.Target_ID := p_Target_Rec.Target_ID;
2430: BIS_TARGET_PVT.Retrieve_Last_Update_Date
2431: ( p_api_version => 1.0
2432: , p_Target_Rec => l_Target_Rec
2433: , x_last_update_date => l_last_update_date
2434: , x_return_status => x_return_status

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 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 2551: , p_error_proc_name => 'BIS_TARGET_PVT.Retrieve_Measure_Dim_Values'

2547: l_error_tbl := x_error_tbl;
2548: BIS_UTILITIES_PVT.Add_Error_Message
2549: ( p_error_msg_name => 'BIS_NO_DIMX_ACCESS'
2550: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2551: , p_error_proc_name => 'BIS_TARGET_PVT.Retrieve_Measure_Dim_Values'
2552: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2553: , p_error_table => l_error_tbl
2554: , x_error_table => x_error_tbl
2555: );

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 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 2578: ('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_UNEXPECTED_ERROR');

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;
2582: -- RAISE;

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 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 2822: Return BIS_TARGET_PVT.G_SET_OF_BOOK_ID;

2818: RETURN VARCHAR2
2819: IS
2820: BEGIN
2821:
2822: Return BIS_TARGET_PVT.G_SET_OF_BOOK_ID;
2823:
2824: END GetSetOfBookID;
2825: --
2826: --

Line 4124: END BIS_TARGET_PVT;

4120: --
4121: BEGIN
4122: G_SET_OF_BOOK_ID := NULL;
4123:
4124: END BIS_TARGET_PVT;