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.IBE_LEAD_IMPORT_PVT dependencies on IBE_LEAD_IMPORT_DETAILS

Line 109: printDebug('error inserting to ibe_lead_import_details', 'write_log');

105:
106: x_log_id := l_log_id;
107: EXCEPTION
108: when OTHERS then
109: printDebug('error inserting to ibe_lead_import_details', 'write_log');
110: End write_log;
111:
112: procedure update_log(
113: p_status IN NUMBER,

Line 161: select ibe_lead_import_details_s1.nextval

157:
158:
159: if( p_status_flag <> FND_API.G_RET_STS_SUCCESS OR nvl(l_write_detail_log, 'Y') = 'Y' ) then
160: BEGIN
161: select ibe_lead_import_details_s1.nextval
162: into l_detail_id
163: From dual;
164: Exception
165: when NO_DATA_FOUND THEN

Line 166: printDebug('Error in getting ibe_lead_import_details_s1.nextval ', 'write_log');

162: into l_detail_id
163: From dual;
164: Exception
165: when NO_DATA_FOUND THEN
166: printDebug('Error in getting ibe_lead_import_details_s1.nextval ', 'write_log');
167: return;
168: End;
169:
170: -- this is for workaround of unique index on IBE_LEAD_IMPORT_DETAILS_U2 on column quote_header_id.

Line 170: -- this is for workaround of unique index on IBE_LEAD_IMPORT_DETAILS_U2 on column quote_header_id.

166: printDebug('Error in getting ibe_lead_import_details_s1.nextval ', 'write_log');
167: return;
168: End;
169:
170: -- this is for workaround of unique index on IBE_LEAD_IMPORT_DETAILS_U2 on column quote_header_id.
171: -- we need to fix the index to be non unique, then this workaround can be removed.
172: /*
173: BEGIN
174: select detail_id

Line 176: From ibe_lead_import_details

172: /*
173: BEGIN
174: select detail_id
175: into l_old_detail_id
176: From ibe_lead_import_details
177: where quote_header_id = p_header_rec.quote_header_id;
178:
179: delete from ibe_lead_import_details
180: where quote_header_id = p_header_rec.quote_header_id;

Line 179: delete from ibe_lead_import_details

175: into l_old_detail_id
176: From ibe_lead_import_details
177: where quote_header_id = p_header_rec.quote_header_id;
178:
179: delete from ibe_lead_import_details
180: where quote_header_id = p_header_rec.quote_header_id;
181:
182:
183: EXCEPTION

Line 190: insert into IBE_LEAD_IMPORT_DETAILS

186: END;
187:
188: */
189:
190: insert into IBE_LEAD_IMPORT_DETAILS
191: (
192: Detail_Id,
193: Log_Id,
194: Quote_Header_id,

Line 252: printDebug('error inserting to ibe_lead_import_details', 'insert_log_details');

248: );
249: end if;
250: EXCEPTION
251: when OTHERS then
252: printDebug('error inserting to ibe_lead_import_details', 'insert_log_details');
253: printDebug(sqlerrm, 'insert_log_details');
254: End insert_log_details;
255:
256: function formatInput (p_inString VARCHAR2 )

Line 806: delete From ibe_lead_import_details

802: From ibe_lead_import_log
803: where lead_type = G_ORDER_LEAD;
804:
805:
806: delete From ibe_lead_import_details
807: where log_id < G_LAST_LOG_ID;
808:
809:
810:

Line 1097: delete From ibe_lead_import_details

1093: into G_LAST_LOG_ID
1094: From ibe_lead_import_log
1095: where lead_type = G_QUOTE_LEAD;
1096:
1097: delete From ibe_lead_import_details
1098: where log_id < G_LAST_LOG_ID;
1099:
1100: EXCEPTION
1101: when no_data_found then