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.AMS_MANUAL_LIST_GEN dependencies on AMS_UTILITY_PVT

Line 13: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);

9: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
10: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
11: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;
12:
13: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);
14: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);
15: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);
16:
17: G_module_name constant varchar2(100):='oracle.apps.ams.plsql.'||g_pkg_name;

Line 14: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);

10: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
11: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;
12:
13: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);
14: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);
15: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);
16:
17: G_module_name constant varchar2(100):='oracle.apps.ams.plsql.'||g_pkg_name;
18:

Line 15: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);

11: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;
12:
13: AMS_LOG_PROCEDURE_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_PROCEDURE);
14: AMS_LOG_EXCEPTION_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_EXCEPTION);
15: AMS_LOG_STATEMENT_ON boolean := AMS_UTILITY_PVT.logging_enabled(AMS_LOG_STATEMENT);
16:
17: G_module_name constant varchar2(100):='oracle.apps.ams.plsql.'||g_pkg_name;
18:
19: PROCEDURE WRITE_TO_ACT_LOG(p_msg_data in VARCHAR2,

Line 26: AMS_UTILITY_PVT.CREATE_LOG(

22: IS
23: PRAGMA AUTONOMOUS_TRANSACTION;
24: l_return_status VARCHAR2(1);
25: BEGIN
26: AMS_UTILITY_PVT.CREATE_LOG(
27: x_return_status => l_return_status,
28: p_arc_log_used_by => 'LIST',
29: p_log_used_by_id => g_list_header_id,
30: p_msg_data => p_msg_data);

Line 87: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');

83: WRITE_TO_ACT_LOG(' manual list ->p_master_type'
84: || p_master_type,'LIST',p_list_header_id);
85:
86: IF (AMS_LOG_PROCEDURE_ON) THEN
87: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
88: END IF;
89:
90: open c_master_source_type;
91: fetch c_master_source_type into l_master_object_name , l_master_primary_key;

Line 228: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');

224: loop
225: WRITE_TO_ACT_LOG(substr(l_final_sql,(2000*i) - 1999,2000),'LIST',p_list_header_id);
226: end loop;
227: IF (AMS_LOG_PROCEDURE_ON) THEN
228: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');
229: END IF;
230:
231: exception
232: WHEN OTHERS THEN

Line 253: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');

249: BEGIN
250:
251: x_return_status := FND_API.G_RET_STS_SUCCESS ;
252: IF (AMS_LOG_PROCEDURE_ON) THEN
253: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
254: END IF;
255:
256: IF (AMS_LOG_STATEMENT_ON) THEN
257: AMS_UTILITY_PVT.debug_message(

Line 257: AMS_UTILITY_PVT.debug_message(

253: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
254: END IF;
255:
256: IF (AMS_LOG_STATEMENT_ON) THEN
257: AMS_UTILITY_PVT.debug_message(
258: AMS_LOG_STATEMENT ,g_module_name||'.'||l_api_name
259: ,' P_list_header_id :'||p_list_header_id||' ,p_primary_key_tbl count :'||p_primary_key_tbl.count);
260: END IF;
261:

Line 282: AMS_UTILITY_PVT.debug_message(

278: --x_added_entry_count := SQL%ROWCOUNT;
279: --WRITE_TO_ACT_LOG('MARZIA ADDED ENTRY SQL%ROWCOUNT' || x_added_entry_count,'LIST',p_list_header_id);
280:
281: IF (AMS_LOG_STATEMENT_ON) THEN
282: AMS_UTILITY_PVT.debug_message(
283: AMS_LOG_STATEMENT ,g_module_name||'.'||l_api_name
284: ,' ADDED ENTRY SQL%ROWCOUNT :'||x_added_entry_count);
285: END IF;
286:

Line 288: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');

284: ,' ADDED ENTRY SQL%ROWCOUNT :'||x_added_entry_count);
285: END IF;
286:
287: IF (AMS_LOG_PROCEDURE_ON) THEN
288: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');
289: END IF;
290:
291:
292: EXCEPTION

Line 310: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');

306: );
307: WHEN OTHERS THEN
308: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
309: IF (AMS_LOG_PROCEDURE_ON) THEN
310: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
311: END IF;
312:
313: IF (AMS_LOG_EXCEPTION_ON) THEN
314: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

Line 314: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);

310: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,' In Others exception handling ');
311: END IF;
312:
313: IF (AMS_LOG_EXCEPTION_ON) THEN
314: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
315: END IF; WRITE_TO_ACT_LOG('Error : '|| sqlerrm,'LIST',p_list_header_id);
316:
317:
318: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 444: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');

440: FND_MSG_PUB.initialize;
441: END IF;
442:
443: IF (AMS_LOG_PROCEDURE_ON) THEN
444: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
445: END IF;
446:
447:
448: IF NOT FND_API.compatible_api_call

Line 469: AMS_UTILITY_PVT.debug_message(

465: FETCH c_get_max_entries INTO l_allowed_spaces;
466: CLOSE c_get_max_entries;
467:
468: IF (AMS_LOG_STATEMENT_ON) THEN
469: AMS_UTILITY_PVT.debug_message(
470: AMS_LOG_STATEMENT ,g_module_name||'.'||l_api_name
471: ,' l_allowed_spaces :'||l_allowed_spaces);
472: END IF;
473:

Line 559: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name

555: l_start_counter := 1;
556: l_end_counter := l_remaining_Spaces;
557:
558: IF (AMS_LOG_STATEMENT_ON) THEN
559: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name
560: ,'FIRST TIME ::l_remaining_Spaces :'||l_remaining_Spaces||', l_start_counter:'||l_start_counter||',l_end_counter:'||l_end_counter );
561: END IF;
562:
563: WHILE l_remaining_Spaces >0 LOOP

Line 583: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name

579:
580: x_added_entry_count := x_added_entry_count + l_added_entry_count;
581:
582: IF (AMS_LOG_STATEMENT_ON) THEN
583: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name
584: ,'IN THE LOOP before reset ::l_remaining_Spaces :'||l_remaining_Spaces||
585: ', l_start_counter:'||l_start_counter||',l_end_counter:'||l_end_counter );
586: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name
587: ,'x_added_entry_count :'||x_added_entry_count );

Line 586: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name

582: IF (AMS_LOG_STATEMENT_ON) THEN
583: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name
584: ,'IN THE LOOP before reset ::l_remaining_Spaces :'||l_remaining_Spaces||
585: ', l_start_counter:'||l_start_counter||',l_end_counter:'||l_end_counter );
586: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name
587: ,'x_added_entry_count :'||x_added_entry_count );
588: END IF;
589:
590: IF l_remaining_spaces = l_added_entry_count THEN

Line 610: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name

606: l_end_counter := l_rows_to_add;
607: END IF;
608: END IF;
609: IF (AMS_LOG_STATEMENT_ON) THEN
610: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name
611: ,'IN THE LOOP after reset ::l_remaining_Spaces :'||l_remaining_Spaces||', l_start_counter:'||l_start_counter||',l_end_counter:'||l_end_counter );
612: END IF;
613:
614: END LOOP;

Line 717: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');

713: p_data => x_msg_data,
714: p_encoded => FND_API.G_FALSE );
715:
716: IF (AMS_LOG_PROCEDURE_ON) THEN
717: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||': END ');
718: END IF;
719:
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN

Line 741: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name

737: WHEN OTHERS THEN
738: x_return_status := FND_API.g_ret_sts_unexp_erroR ;
739: ROLLBACK TO process_manual_list;
740: IF (AMS_LOG_PROCEDURE_ON) THEN
741: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name
742: ,' In Others exception handling ');
743: END IF;
744:
745: IF (AMS_LOG_EXCEPTION_ON) THEN

Line 746: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name

742: ,' In Others exception handling ');
743: END IF;
744:
745: IF (AMS_LOG_EXCEPTION_ON) THEN
746: AMS_UTILITY_PVT.debug_message(AMS_LOG_EXCEPTION,g_module_name||'.'||l_api_name
747: ,'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
748: END IF;
749: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
750: THEN