10: FND_MESSAGE.Set_Name('PV', p_msg_type);
11: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
12:
13: IF (g_log_to_file = 'N') THEN
14: FND_MSG_PUB.Add;
15:
16: ELSIF (g_log_to_file = 'Y') THEN
17: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
18: END IF;
216: IF (g_log_to_file = 'Y') THEN
217: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
218: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
219: ELSE
220: FND_MSG_PUB.Add;
221: END IF;
222:
223: g_common_currency := NVL(FND_PROFILE.Value('PV_COMMON_CURRENCY'), 'USD');
224: Debug('The common currency is: ' || g_common_currency);
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);
559: IF (g_log_to_file = 'Y') THEN
560: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
561: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
562: ELSE
563: FND_MSG_PUB.Add;
564: END IF;
565:
566: -- ------------------------------------------------------------------
567: -- update the profile value so the