306: when others then
307: Debug('Error encountered executing sql_text for attribute: ' || lc_attr_rec.name);
308:
309: l_warning_count := l_warning_count + 1;
310: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
311:
312: while (l_message is not null) loop
313: debug(substr(l_message,1,200));
314: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
310: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
311:
312: while (l_message is not null) loop
313: debug(substr(l_message,1,200));
314: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
315: end loop;
316:
317: Debug('Error code: ' || sqlcode);
318: Debug('Error msg: ' || sqlerrm);
359: exception
360: when others then
361: Debug('Error encountered adding to partner trend table for partner_id: ' || l_new_pt_rec.partner_id);
362: l_warning_count := l_warning_count + 1;
363: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
364:
365: while (l_message is not null) loop
366: debug(substr(l_message,1,200));
367: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
363: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
364:
365: while (l_message is not null) loop
366: debug(substr(l_message,1,200));
367: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
368: end loop;
369:
370: Debug('Error code: ' || sqlcode);
371: Debug('Error msg: ' || sqlerrm);
528: when others then
529: Debug('Error encountered executing batch_sql_text for attribute: ' || lc_attr_rec.name);
530:
531: l_warning_count := l_warning_count + 1;
532: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
533:
534: while (l_message is not null) loop
535: debug(substr(l_message,1,200));
536: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
532: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
533:
534: while (l_message is not null) loop
535: debug(substr(l_message,1,200));
536: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
537: end loop;
538:
539: Debug('Error code: ' || sqlcode);
540: Debug('Error msg: ' || sqlerrm);