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_NR_PROFILE_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_RA_NR_PROFILE_PVT AS
2: /* $Header: AHLVNRPB.pls 120.0.12020000.2 2012/12/07 00:53:55 sareepar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_RA_NR_PROFILE_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: G_DEBUG_LINE_NUM NUMBER;
8:
9:

Line 107: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );

103: BEGIN
104:
105: -- Add debug mesg.
106: IF G_DEBUG = 'Y' THEN
107: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
108: END IF;
109:
110: SAVEPOINT sp_populate_prof_mat_req;
111:

Line 122: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Nonroutine MR Profile Not Exist' );

118: FETCH get_profile_ident_seqs INTO l_nr_profile_header_id, l_ident_seq_third, l_ident_seq_fourth;
119: IF (get_profile_ident_seqs%NOTFOUND)
120: THEN
121: IF G_DEBUG = 'Y' THEN
122: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Nonroutine MR Profile Not Exist' );
123: END IF;
124: CLOSE get_profile_ident_seqs;
125:
126: GOTO end_of_mat_procedure;

Line 140: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid plan_id' || p_plan_id );

136: FETCH get_primary_plan_flag INTO l_primary_plan_flag;
137: IF (get_primary_plan_flag%NOTFOUND)
138: THEN
139: IF G_DEBUG = 'Y' THEN
140: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid plan_id' || p_plan_id );
141: END IF;
142: CLOSE get_primary_plan_flag;
143: GOTO end_of_mat_procedure;
144: END IF;

Line 156: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Unit Effectivities table' );

152: FETCH get_ue_item_instance INTO l_fleet_header_id;
153: IF (get_ue_item_instance%NOTFOUND)
154: THEN
155: IF G_DEBUG = 'Y' THEN
156: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Unit Effectivities table' );
157: END IF;
158: CLOSE get_ue_item_instance;
159: GOTO end_of_mat_procedure;
160: END IF;

Line 169: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Simulatin plan table');

165: FETCH get_ue_item_instance_sim INTO l_fleet_header_id;
166: IF (get_ue_item_instance_sim%NOTFOUND)
167: THEN
168: IF G_DEBUG = 'Y' THEN
169: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Simulatin plan table');
170: END IF;
171: CLOSE get_ue_item_instance_sim;
172: GOTO end_of_mat_procedure;
173: END IF;

Line 189: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid Fleet Header Id ::' || l_fleet_header_id);

185: IF (get_fleet_details%NOTFOUND)
186: THEN
187: CLOSE get_fleet_details;
188: IF G_DEBUG = 'Y' THEN
189: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid Fleet Header Id ::' || l_fleet_header_id);
190: END IF;
191: GOTO end_of_mat_procedure;
192: END IF;
193:

Line 195: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Fleet Details l_fleet_header_id:'||l_fleet_header_id||', l_operating_org_id:'||l_operating_org_id||', l_operations_type_code:'||l_operations_type_code);

191: GOTO end_of_mat_procedure;
192: END IF;
193:
194: IF G_DEBUG = 'Y' THEN
195: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Fleet Details l_fleet_header_id:'||l_fleet_header_id||', l_operating_org_id:'||l_operating_org_id||', l_operations_type_code:'||l_operations_type_code);
196: END IF;
197: CLOSE get_fleet_details;
198:
199: /*

Line 324: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );

320: x_prof_mat_req_tbl := l_prof_mat_req_tbl;
321:
322: -- End of API
323: IF G_DEBUG = 'Y' THEN
324: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );
325: END IF;
326:
327: EXCEPTION
328: WHEN OTHERS THEN

Line 443: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );

439: BEGIN
440:
441: -- Add debug mesg.
442: IF G_DEBUG = 'Y' THEN
443: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
444: END IF;
445:
446: SAVEPOINT sp_populate_prof_res_req;
447:

Line 458: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.No NR Profile exist for a given Maintenance Requirement');

454: FETCH get_profile_ident_seqs INTO l_nr_profile_header_id, l_ident_seq_third, l_ident_seq_fourth;
455: IF get_profile_ident_seqs%NOTFOUND
456: THEN
457: IF G_DEBUG = 'Y' THEN
458: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '.No NR Profile exist for a given Maintenance Requirement');
459: END IF;
460:
461: CLOSE get_profile_ident_seqs;
462: GOTO end_of_res_procedure;

Line 476: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid plan_id' || p_plan_id );

472: FETCH get_primary_plan_flag INTO l_primary_plan_flag;
473: IF (get_primary_plan_flag%NOTFOUND)
474: THEN
475: IF G_DEBUG = 'Y' THEN
476: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid plan_id' || p_plan_id );
477: END IF;
478: CLOSE get_primary_plan_flag;
479: GOTO end_of_res_procedure;
480: END IF;

Line 492: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Unit Effectivities table' );

488: FETCH get_ue_item_instance INTO l_fleet_header_id;
489: IF (get_ue_item_instance%NOTFOUND)
490: THEN
491: IF G_DEBUG = 'Y' THEN
492: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Unit Effectivities table' );
493: END IF;
494: CLOSE get_ue_item_instance;
495: GOTO end_of_res_procedure;
496: END IF;

Line 505: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Simulatin plan table');

501: FETCH get_ue_item_instance_sim INTO l_fleet_header_id;
502: IF (get_ue_item_instance_sim%NOTFOUND)
503: THEN
504: IF G_DEBUG = 'Y' THEN
505: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid UE_ID and ITEM_INSTANCE_ID Combination for Simulatin plan table');
506: END IF;
507: CLOSE get_ue_item_instance_sim;
508: GOTO end_of_res_procedure;
509: END IF;

Line 523: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid Fleet Id ::'|| l_fleet_header_id);

519: IF get_fleet_details%NOTFOUND
520: THEN
521: CLOSE get_fleet_details;
522: IF G_DEBUG = 'Y' THEN
523: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Invalid Fleet Id ::'|| l_fleet_header_id);
524: END IF;
525: GOTO end_of_res_procedure;
526: END IF;
527: IF G_DEBUG = 'Y' THEN

Line 528: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Fleet Details l_fleet_header_id:'||l_fleet_header_id||', l_operating_org_id:'||l_operating_org_id||', l_operations_type_code:'||l_operations_type_code);

524: END IF;
525: GOTO end_of_res_procedure;
526: END IF;
527: IF G_DEBUG = 'Y' THEN
528: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'Fleet Details l_fleet_header_id:'||l_fleet_header_id||', l_operating_org_id:'||l_operating_org_id||', l_operations_type_code:'||l_operations_type_code);
529: END IF;
530: CLOSE get_fleet_details;
531:
532: /* Get all the items for a given nr_profile_header_id order by stage type , cmro resource id

Line 647: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );

643: x_prof_res_req_tbl := l_prof_res_req_tbl;
644:
645: -- End of API
646: IF G_DEBUG = 'Y' THEN
647: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End private API:' );
648: END IF;
649:
650:
651: EXCEPTION

Line 845: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );

841: BEGIN
842:
843: -- Add debug mesg.
844: IF G_DEBUG = 'Y' THEN
845: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
846: END IF;
847:
848: -- Initialize API return status to success
849: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1194: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End of private API:' );

1190: END IF;
1191:
1192: -- End of API
1193: IF G_DEBUG = 'Y' THEN
1194: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::End of private API:' );
1195: END IF;
1196:
1197: EXCEPTION
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1298: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );

1294:
1295: BEGIN
1296:
1297: IF G_DEBUG = 'Y' THEN
1298: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
1299: END IF;
1300:
1301: -- Initialize API return status to success
1302: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1711: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':End of Private api ');

1707:
1708: END IF; --Table Count
1709:
1710: IF G_DEBUG='Y' THEN
1711: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':End of Private api ');
1712: END IF;
1713:
1714:
1715: EXCEPTION

Line 1852: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' ::Begin API' );

1848: FND_MSG_PUB.initialize;
1849: END IF;
1850:
1851: IF G_DEBUG = 'Y' THEN
1852: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' ::Begin API' );
1853: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' :: NR_PROFILE_HEADER_ID::'||
1854: p_x_nr_profile_header_rec.nr_profile_header_id || ' : OBJECT_VERSION_NUMBER::'||
1855: p_x_nr_profile_header_rec.object_version_number || ' : MR_TITLE::'||
1856: p_x_nr_profile_header_rec.mr_title || ' : STATUS_CODE::'||

Line 1853: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' :: NR_PROFILE_HEADER_ID::'||

1849: END IF;
1850:
1851: IF G_DEBUG = 'Y' THEN
1852: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' ::Begin API' );
1853: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' :: NR_PROFILE_HEADER_ID::'||
1854: p_x_nr_profile_header_rec.nr_profile_header_id || ' : OBJECT_VERSION_NUMBER::'||
1855: p_x_nr_profile_header_rec.object_version_number || ' : MR_TITLE::'||
1856: p_x_nr_profile_header_rec.mr_title || ' : STATUS_CODE::'||
1857: p_x_nr_profile_header_rec.status_code || ' :DML_OPERATION::'||

Line 2159: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );

2155: COMMIT;
2156: END IF;
2157:
2158: IF G_DEBUG='Y' THEN
2159: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : End API' );
2160: END IF;
2161:
2162: EXCEPTION
2163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN