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.AHL_RA_SETUPS_PVT dependencies on STANDARD

Line 16: -- Standard IN Parameters :

12: -- Type : Private
13: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_SETUPS table
14: -- Pre-reqs :
15: --
16: -- Standard IN Parameters :
17: -- p_api_version IN NUMBER Required
18: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 22: -- Standard OUT Parameters :

18: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
19: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
20: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
21: --
22: -- Standard OUT Parameters :
23: -- x_return_status OUT VARCHAR2 Required
24: -- x_msg_count OUT NUMBER Required
25: -- x_msg_data OUT VARCHAR2 Required
26: --

Line 59: -- Standard start of API savepoint

55: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
56: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
57: END IF;
58:
59: -- Standard start of API savepoint
60: SAVEPOINT CREATE_SETUP_DATA_SP;
61:
62: -- Standard call to check for call compatibility
63: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version, l_api_name, G_PKG_NAME) THEN

Line 62: -- Standard call to check for call compatibility

58:
59: -- Standard start of API savepoint
60: SAVEPOINT CREATE_SETUP_DATA_SP;
61:
62: -- Standard call to check for call compatibility
63: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version, l_api_name, G_PKG_NAME) THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:

Line 287: -- Standard check for p_commit

283:
284: -- Set the Out Param
285: p_x_setup_data_rec := l_setup_data_rec;
286:
287: -- Standard check for p_commit
288: IF FND_API.To_Boolean (p_commit) THEN
289: COMMIT;
290: END IF;
291:

Line 296: -- Standard call to get message count and if count is 1, get message

292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
293: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- CREATE_SETUP_DATA -------END-----------');
294: END IF;
295:
296: -- Standard call to get message count and if count is 1, get message
297: FND_MSG_PUB.Count_And_Get
298: ( p_count => x_msg_count,
299: p_data => x_msg_data,
300: p_encoded => fnd_api.g_false);

Line 342: -- Standard IN Parameters :

338: -- Type : Private
339: -- Function : This API would dalete the setup data for Reliability Framework in AHL_RA_SETUPS table
340: -- Pre-reqs :
341: --
342: -- Standard IN Parameters :
343: -- p_api_version IN NUMBER Required
344: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
345: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
346: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 348: -- Standard OUT Parameters :

344: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
345: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
346: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
347: --
348: -- Standard OUT Parameters :
349: -- x_return_status OUT VARCHAR2 Required
350: -- x_msg_count OUT NUMBER Required
351: -- x_msg_data OUT VARCHAR2 Required
352: --

Line 384: -- Standard start of API savepoint

380: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
381: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
382: END IF;
383:
384: -- Standard start of API savepoint
385: SAVEPOINT DELETE_SETUP_DATA_SP;
386:
387: -- Standard call to check for call compatibility
388: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 387: -- Standard call to check for call compatibility

383:
384: -- Standard start of API savepoint
385: SAVEPOINT DELETE_SETUP_DATA_SP;
386:
387: -- Standard call to check for call compatibility
388: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:

Line 460: -- Standard check for p_commit

456: -- Delete Record from AHL_RA_SETUPS
457: DELETE AHL_RA_SETUPS
458: WHERE RA_SETUP_ID = p_setup_data_rec.RA_SETUP_ID;
459:
460: -- Standard check for p_commit
461: IF FND_API.To_Boolean (p_commit) THEN
462: COMMIT;
463: END IF;
464:

Line 469: -- Standard call to get message count and if count is 1, get message

465: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
466: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- DELETE_SETUP_DATA -------END-----------');
467: END IF;
468:
469: -- Standard call to get message count and if count is 1, get message
470: FND_MSG_PUB.Count_And_Get
471: ( p_count => x_msg_count,
472: p_data => x_msg_data,
473: p_encoded => fnd_api.g_false);

Line 515: -- Standard IN Parameters :

511: -- Type : Private
512: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR
513: -- Pre-reqs :
514: --
515: -- Standard IN Parameters :
516: -- p_api_version IN NUMBER Required
517: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
518: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
519: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 521: -- Standard OUT Parameters :

517: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
518: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
519: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
520: --
521: -- Standard OUT Parameters :
522: -- x_return_status OUT VARCHAR2 Required
523: -- x_msg_count OUT NUMBER Required
524: -- x_msg_data OUT VARCHAR2 Required
525: --

Line 557: -- Standard start of API savepoint

553: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
554: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
555: END IF;
556:
557: -- Standard start of API savepoint
558: SAVEPOINT CREATE_RELIABILITY_DATA_SP;
559:
560: -- Standard call to check for call compatibility
561: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 560: -- Standard call to check for call compatibility

556:
557: -- Standard start of API savepoint
558: SAVEPOINT CREATE_RELIABILITY_DATA_SP;
559:
560: -- Standard call to check for call compatibility
561: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:

Line 809: -- Standard check for p_commit

805: l_ra_def_hdr_rec.LAST_UPDATE_LOGIN -- LAST_UPDATE_LOGIN
806: );
807:
808: p_x_reliability_data_rec := l_ra_def_hdr_rec;
809: -- Standard check for p_commit
810: IF FND_API.To_Boolean (p_commit) THEN
811: COMMIT;
812: END IF;
813:

Line 818: -- Standard call to get message count and if count is 1, get message

814: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
815: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- CREATE_RELIABILITY_DATA -------END-----------');
816: END IF;
817:
818: -- Standard call to get message count and if count is 1, get message
819: FND_MSG_PUB.Count_And_Get
820: ( p_count => x_msg_count,
821: p_data => x_msg_data,
822: p_encoded => fnd_api.g_false);

Line 864: -- Standard IN Parameters :

860: -- Type : Private
861: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR
862: -- Pre-reqs :
863: --
864: -- Standard IN Parameters :
865: -- p_api_version IN NUMBER Required
866: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
867: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
868: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 870: -- Standard OUT Parameters :

866: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
867: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
868: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
869: --
870: -- Standard OUT Parameters :
871: -- x_return_status OUT VARCHAR2 Required
872: -- x_msg_count OUT NUMBER Required
873: -- x_msg_data OUT VARCHAR2 Required
874: --

Line 905: -- Standard start of API savepoint

901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
902: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
903: END IF;
904:
905: -- Standard start of API savepoint
906: SAVEPOINT DELETE_RELIABILITY_DATA_SP;
907:
908: -- Standard call to check for call compatibility
909: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 908: -- Standard call to check for call compatibility

904:
905: -- Standard start of API savepoint
906: SAVEPOINT DELETE_RELIABILITY_DATA_SP;
907:
908: -- Standard call to check for call compatibility
909: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912:

Line 1004: -- Standard check for p_commit

1000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master Record has been deleted --');
1002: END IF;
1003:
1004: -- Standard check for p_commit
1005: IF FND_API.To_Boolean (p_commit) THEN
1006: COMMIT;
1007: END IF;
1008:

Line 1013: -- Standard call to get message count and if count is 1, get message

1009: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1010: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- DELETE_RELIABILITY_DATA -------END-----------');
1011: END IF;
1012:
1013: -- Standard call to get message count and if count is 1, get message
1014: FND_MSG_PUB.Count_And_Get
1015: ( p_count => x_msg_count,
1016: p_data => x_msg_data,
1017: p_encoded => fnd_api.g_false);

Line 1060: -- Standard IN Parameters :

1056: -- Type : Private
1057: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
1058: -- Pre-reqs :
1059: --
1060: -- Standard IN Parameters :
1061: -- p_api_version IN NUMBER Required
1062: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1063: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1064: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1066: -- Standard OUT Parameters :

1062: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1063: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1064: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1065: --
1066: -- Standard OUT Parameters :
1067: -- x_return_status OUT VARCHAR2 Required
1068: -- x_msg_count OUT NUMBER Required
1069: -- x_msg_data OUT VARCHAR2 Required
1070: --

Line 1106: -- Standard start of API savepoint

1102: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1103: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
1104: END IF;
1105:
1106: -- Standard start of API savepoint
1107: SAVEPOINT CREATE_MTBF_DATA_SP;
1108:
1109: -- Standard call to check for call compatibility
1110: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 1109: -- Standard call to check for call compatibility

1105:
1106: -- Standard start of API savepoint
1107: SAVEPOINT CREATE_MTBF_DATA_SP;
1108:
1109: -- Standard call to check for call compatibility
1110: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: END IF;
1113:

Line 1385: -- Standard check for p_commit

1381: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID;
1382:
1383: p_x_reliability_data_rec := l_ra_def_hdr_rec;
1384:
1385: -- Standard check for p_commit
1386: IF FND_API.To_Boolean (p_commit) THEN
1387: COMMIT;
1388: END IF;
1389:

Line 1394: -- Standard call to get message count and if count is 1, get message

1390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1391: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- CREATE_MTBF_DATA -------END-----------');
1392: END IF;
1393:
1394: -- Standard call to get message count and if count is 1, get message
1395: FND_MSG_PUB.Count_And_Get
1396: ( p_count => x_msg_count,
1397: p_data => x_msg_data,
1398: p_encoded => fnd_api.g_false);

Line 1441: -- Standard IN Parameters :

1437: -- Type : Private
1438: -- Function : This API would update the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
1439: -- Pre-reqs :
1440: --
1441: -- Standard IN Parameters :
1442: -- p_api_version IN NUMBER Required
1443: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1444: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1445: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1447: -- Standard OUT Parameters :

1443: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1444: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1445: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1446: --
1447: -- Standard OUT Parameters :
1448: -- x_return_status OUT VARCHAR2 Required
1449: -- x_msg_count OUT NUMBER Required
1450: -- x_msg_data OUT VARCHAR2 Required
1451: --

Line 1496: -- Standard start of API savepoint

1492: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1493: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
1494: END IF;
1495:
1496: -- Standard start of API savepoint
1497: SAVEPOINT UPDATE_MTBF_DATA_SP;
1498:
1499: -- Standard call to check for call compatibility
1500: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 1499: -- Standard call to check for call compatibility

1495:
1496: -- Standard start of API savepoint
1497: SAVEPOINT UPDATE_MTBF_DATA_SP;
1498:
1499: -- Standard call to check for call compatibility
1500: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502: END IF;
1503:

Line 1765: -- Standard check for p_commit

1761: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID;
1762:
1763: p_x_reliability_data_rec := l_ra_def_hdr_rec;
1764:
1765: -- Standard check for p_commit
1766: IF FND_API.To_Boolean (p_commit) THEN
1767: COMMIT;
1768: END IF;
1769:

Line 1774: -- Standard call to get message count and if count is 1, get message

1770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1771: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- UPDATE_MTBF_DATA -------END-----------');
1772: END IF;
1773:
1774: -- Standard call to get message count and if count is 1, get message
1775: FND_MSG_PUB.Count_And_Get
1776: ( p_count => x_msg_count,
1777: p_data => x_msg_data,
1778: p_encoded => fnd_api.g_false);

Line 1821: -- Standard IN Parameters :

1817: -- Type : Private
1818: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
1819: -- Pre-reqs :
1820: --
1821: -- Standard IN Parameters :
1822: -- p_api_version IN NUMBER Required
1823: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1824: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1825: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1827: -- Standard OUT Parameters :

1823: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1824: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1825: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1826: --
1827: -- Standard OUT Parameters :
1828: -- x_return_status OUT VARCHAR2 Required
1829: -- x_msg_count OUT NUMBER Required
1830: -- x_msg_data OUT VARCHAR2 Required
1831: --

Line 1866: -- Standard start of API savepoint

1862: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1863: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
1864: END IF;
1865:
1866: -- Standard start of API savepoint
1867: SAVEPOINT DELETE_MTBF_DATA_SP;
1868:
1869: -- Standard call to check for call compatibility
1870: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 1869: -- Standard call to check for call compatibility

1865:
1866: -- Standard start of API savepoint
1867: SAVEPOINT DELETE_MTBF_DATA_SP;
1868:
1869: -- Standard call to check for call compatibility
1870: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: END IF;
1873:

Line 2019: -- Standard check for p_commit

2015: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID;
2016:
2017: p_x_reliability_data_rec := l_ra_def_hdr_rec;
2018:
2019: -- Standard check for p_commit
2020: IF FND_API.To_Boolean (p_commit) THEN
2021: COMMIT;
2022: END IF;
2023:

Line 2028: -- Standard call to get message count and if count is 1, get message

2024: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2025: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- DELETE_MTBF_DATA -------END-----------');
2026: END IF;
2027:
2028: -- Standard call to get message count and if count is 1, get message
2029: FND_MSG_PUB.Count_And_Get
2030: ( p_count => x_msg_count,
2031: p_data => x_msg_data,
2032: p_encoded => fnd_api.g_false);

Line 2076: -- Standard IN Parameters :

2072: -- Type : Private
2073: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS
2074: -- Pre-reqs :
2075: --
2076: -- Standard IN Parameters :
2077: -- p_api_version IN NUMBER Required
2078: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2079: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2080: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2082: -- Standard OUT Parameters :

2078: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2079: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2080: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2081: --
2082: -- Standard OUT Parameters :
2083: -- x_return_status OUT VARCHAR2 Required
2084: -- x_msg_count OUT NUMBER Required
2085: -- x_msg_data OUT VARCHAR2 Required
2086: --

Line 2122: -- Standard start of API savepoint

2118: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2119: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
2120: END IF;
2121:
2122: -- Standard start of API savepoint
2123: SAVEPOINT CREATE_COUNTER_ASSOC_SP;
2124:
2125: -- Standard call to check for call compatibility
2126: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2125: -- Standard call to check for call compatibility

2121:
2122: -- Standard start of API savepoint
2123: SAVEPOINT CREATE_COUNTER_ASSOC_SP;
2124:
2125: -- Standard call to check for call compatibility
2126: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2128: END IF;
2129:

Line 2425: -- Standard check for p_commit

2421:
2422: -- Set the Out Param
2423: p_x_counter_assoc_rec := l_counter_assoc_rec;
2424:
2425: -- Standard check for p_commit
2426: IF FND_API.To_Boolean (p_commit) THEN
2427: COMMIT;
2428: END IF;
2429:

Line 2436: -- Standard call to get message count and if count is 1, get message

2432: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- CREATE_COUNTER_ASSOC --END--');
2433: END IF;
2434:
2435:
2436: -- Standard call to get message count and if count is 1, get message
2437: FND_MSG_PUB.Count_And_Get
2438: ( p_count => x_msg_count,
2439: p_data => x_msg_data,
2440: p_encoded => fnd_api.g_false);

Line 2482: -- Standard IN Parameters :

2478: -- Type : Private
2479: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS
2480: -- Pre-reqs :
2481: --
2482: -- Standard IN Parameters :
2483: -- p_api_version IN NUMBER Required
2484: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2485: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2486: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2488: -- Standard OUT Parameters :

2484: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2485: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2486: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2487: --
2488: -- Standard OUT Parameters :
2489: -- x_return_status OUT VARCHAR2 Required
2490: -- x_msg_count OUT NUMBER Required
2491: -- x_msg_data OUT VARCHAR2 Required
2492: --

Line 2523: -- Standard start of API savepoint

2519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2520: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
2521: END IF;
2522:
2523: -- Standard start of API savepoint
2524: SAVEPOINT DELETE_COUNTER_ASSOC_SP;
2525:
2526: -- Standard call to check for call compatibility
2527: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2526: -- Standard call to check for call compatibility

2522:
2523: -- Standard start of API savepoint
2524: SAVEPOINT DELETE_COUNTER_ASSOC_SP;
2525:
2526: -- Standard call to check for call compatibility
2527: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2529: END IF;
2530:

Line 2604: -- Standard check for p_commit

2600: -- Delete Record from AHL_RA_CTR_ASSOCIATIONS
2601: DELETE AHL_RA_CTR_ASSOCIATIONS
2602: WHERE RA_COUNTER_ASSOCIATION_ID = p_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID;
2603:
2604: -- Standard check for p_commit
2605: IF FND_API.To_Boolean (p_commit) THEN
2606: COMMIT;
2607: END IF;
2608:

Line 2613: -- Standard call to get message count and if count is 1, get message

2609: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2610: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- DELETE_COUNTER_ASSOC -------END-----------');
2611: END IF;
2612:
2613: -- Standard call to get message count and if count is 1, get message
2614: FND_MSG_PUB.Count_And_Get
2615: ( p_count => x_msg_count,
2616: p_data => x_msg_data,
2617: p_encoded => fnd_api.g_false);

Line 2659: -- Standard IN Parameters :

2655: -- Type : Private
2656: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
2657: -- Pre-reqs :
2658: --
2659: -- Standard IN Parameters :
2660: -- p_api_version IN NUMBER Required
2661: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2662: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2663: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2665: -- Standard OUT Parameters :

2661: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2662: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2663: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2664: --
2665: -- Standard OUT Parameters :
2666: -- x_return_status OUT VARCHAR2 Required
2667: -- x_msg_count OUT NUMBER Required
2668: -- x_msg_data OUT VARCHAR2 Required
2669: --

Line 2701: -- Standard start of API savepoint

2697: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2698: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
2699: END IF;
2700:
2701: -- Standard start of API savepoint
2702: SAVEPOINT CREATE_FCT_ASSOC_DATA_SP;
2703:
2704: -- Standard call to check for call compatibility
2705: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 2704: -- Standard call to check for call compatibility

2700:
2701: -- Standard start of API savepoint
2702: SAVEPOINT CREATE_FCT_ASSOC_DATA_SP;
2703:
2704: -- Standard call to check for call compatibility
2705: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2707: END IF;
2708:

Line 2992: -- Standard check for p_commit

2988:
2989: -- Set the Out Param
2990: p_x_fct_assoc_rec := l_fct_assoc_rec;
2991:
2992: -- Standard check for p_commit
2993: IF FND_API.To_Boolean (p_commit) THEN
2994: COMMIT;
2995: END IF;
2996:

Line 3001: -- Standard call to get message count and if count is 1, get message

2997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2998: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- CREATE_FCT_ASSOC_DATA -------END-----------');
2999: END IF;
3000:
3001: -- Standard call to get message count and if count is 1, get message
3002: FND_MSG_PUB.Count_And_Get
3003: ( p_count => x_msg_count,
3004: p_data => x_msg_data,
3005: p_encoded => fnd_api.g_false);

Line 3052: -- Standard IN Parameters :

3048: -- G_MISS_XXXX : Nullify
3049: -- Valid Values : Update
3050: -- Pre-reqs :
3051: --
3052: -- Standard IN Parameters :
3053: -- p_api_version IN NUMBER Required
3054: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3055: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3056: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3058: -- Standard OUT Parameters :

3054: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3055: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3056: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3057: --
3058: -- Standard OUT Parameters :
3059: -- x_return_status OUT VARCHAR2 Required
3060: -- x_msg_count OUT NUMBER Required
3061: -- x_msg_data OUT VARCHAR2 Required
3062: --

Line 3095: -- Standard start of API savepoint

3091: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3092: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
3093: END IF;
3094:
3095: -- Standard start of API savepoint
3096: SAVEPOINT UPDATE_FCT_ASSOC_DATA_SP;
3097:
3098: -- Standard call to check for call compatibility
3099: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3098: -- Standard call to check for call compatibility

3094:
3095: -- Standard start of API savepoint
3096: SAVEPOINT UPDATE_FCT_ASSOC_DATA_SP;
3097:
3098: -- Standard call to check for call compatibility
3099: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101: END IF;
3102:

Line 3461: -- Standard check for p_commit

3457:
3458: -- Set the Out Param
3459: p_x_fct_assoc_rec := l_fct_assoc_rec;
3460:
3461: -- Standard check for p_commit
3462: IF FND_API.To_Boolean (p_commit) THEN
3463: COMMIT;
3464: END IF;
3465:

Line 3470: -- Standard call to get message count and if count is 1, get message

3466: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3467: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- UPDATE_FCT_ASSOC_DATA -------END-----------');
3468: END IF;
3469:
3470: -- Standard call to get message count and if count is 1, get message
3471: FND_MSG_PUB.Count_And_Get
3472: ( p_count => x_msg_count,
3473: p_data => x_msg_data,
3474: p_encoded => fnd_api.g_false);

Line 3518: -- Standard IN Parameters :

3514: -- Type : Private
3515: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
3516: -- Pre-reqs :
3517: --
3518: -- Standard IN Parameters :
3519: -- p_api_version IN NUMBER Required
3520: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3521: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3522: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 3524: -- Standard OUT Parameters :

3520: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
3521: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
3522: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
3523: --
3524: -- Standard OUT Parameters :
3525: -- x_return_status OUT VARCHAR2 Required
3526: -- x_msg_count OUT NUMBER Required
3527: -- x_msg_data OUT VARCHAR2 Required
3528: --

Line 3559: -- Standard start of API savepoint

3555: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3556: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
3557: END IF;
3558:
3559: -- Standard start of API savepoint
3560: SAVEPOINT DELETE_FCT_ASSOC_DATA_SP;
3561:
3562: -- Standard call to check for call compatibility
3563: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 3562: -- Standard call to check for call compatibility

3558:
3559: -- Standard start of API savepoint
3560: SAVEPOINT DELETE_FCT_ASSOC_DATA_SP;
3561:
3562: -- Standard call to check for call compatibility
3563: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3565: END IF;
3566:

Line 3633: -- Standard check for p_commit

3629: -- Delete Record from AHL_RA_FCT_ASSOCIATIONS
3630: DELETE AHL_RA_FCT_ASSOCIATIONS
3631: WHERE RA_FCT_ASSOCIATION_ID = p_fct_assoc_rec.RA_FCT_ASSOCIATION_ID;
3632:
3633: -- Standard check for p_commit
3634: IF FND_API.To_Boolean (p_commit) THEN
3635: COMMIT;
3636: END IF;
3637:

Line 3642: -- Standard call to get message count and if count is 1, get message

3638: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3639: fnd_log.string(fnd_log.level_statement,l_full_name,'DS -- PVT -- DELETE_FCT_ASSOC_DATA -------END-----------');
3640: END IF;
3641:
3642: -- Standard call to get message count and if count is 1, get message
3643: FND_MSG_PUB.Count_And_Get
3644: ( p_count => x_msg_count,
3645: p_data => x_msg_data,
3646: p_encoded => fnd_api.g_false);