DBA Data[Home] [Help]

APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LISTGENERATION_PKG

Line 136: if nvl(ams_listgeneration_pkg.g_log_level,'HIGH') = 'HIGH' and p_level = 'LOW' then

132: --PRAGMA AUTONOMOUS_TRANSACTION;
133:
134: BEGIN
135:
136: if nvl(ams_listgeneration_pkg.g_log_level,'HIGH') = 'HIGH' and p_level = 'LOW' then
137: return;
138: end if;
139:
140: ams_listgeneration_pkg.write_to_act_log(p_msg_data,'LIST',p_list_header_id,p_level);

Line 140: ams_listgeneration_pkg.write_to_act_log(p_msg_data,'LIST',p_list_header_id,p_level);

136: if nvl(ams_listgeneration_pkg.g_log_level,'HIGH') = 'HIGH' and p_level = 'LOW' then
137: return;
138: end if;
139:
140: ams_listgeneration_pkg.write_to_act_log(p_msg_data,'LIST',p_list_header_id,p_level);
141:
142: /*
143: ams_listgeneration_pkg.g_message_table(ams_listgeneration_pkg.g_count) := p_msg_data;
144: ams_listgeneration_pkg.g_date(ams_listgeneration_pkg.g_count) := sysdate;

Line 143: ams_listgeneration_pkg.g_message_table(ams_listgeneration_pkg.g_count) := p_msg_data;

139:
140: ams_listgeneration_pkg.write_to_act_log(p_msg_data,'LIST',p_list_header_id,p_level);
141:
142: /*
143: ams_listgeneration_pkg.g_message_table(ams_listgeneration_pkg.g_count) := p_msg_data;
144: ams_listgeneration_pkg.g_date(ams_listgeneration_pkg.g_count) := sysdate;
145: ams_listgeneration_pkg.g_count := ams_listgeneration_pkg.g_count + 1;
146: */
147:

Line 144: ams_listgeneration_pkg.g_date(ams_listgeneration_pkg.g_count) := sysdate;

140: ams_listgeneration_pkg.write_to_act_log(p_msg_data,'LIST',p_list_header_id,p_level);
141:
142: /*
143: ams_listgeneration_pkg.g_message_table(ams_listgeneration_pkg.g_count) := p_msg_data;
144: ams_listgeneration_pkg.g_date(ams_listgeneration_pkg.g_count) := sysdate;
145: ams_listgeneration_pkg.g_count := ams_listgeneration_pkg.g_count + 1;
146: */
147:
148: /* INSERT INTO ams_act_logs

Line 145: ams_listgeneration_pkg.g_count := ams_listgeneration_pkg.g_count + 1;

141:
142: /*
143: ams_listgeneration_pkg.g_message_table(ams_listgeneration_pkg.g_count) := p_msg_data;
144: ams_listgeneration_pkg.g_date(ams_listgeneration_pkg.g_count) := sysdate;
145: ams_listgeneration_pkg.g_count := ams_listgeneration_pkg.g_count + 1;
146: */
147:
148: /* INSERT INTO ams_act_logs
149: ( activity_log_id