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.POA_BIS_ALERTS dependencies on POA_LOG

Line 66: POA_LOG.put_line('Error getting target values:');

62: CLOSE cr_target;
63:
64: EXCEPTION
65: WHEN others THEN
66: POA_LOG.put_line('Error getting target values:');
67: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
68: RAISE;
69: END get_target_value;
70:

Line 67: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);

63:
64: EXCEPTION
65: WHEN others THEN
66: POA_LOG.put_line('Error getting target values:');
67: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
68: RAISE;
69: END get_target_value;
70:
71: PROCEDURE get_target_orgs(

Line 90: POA_LOG.put_line('Error getting organizations with targets defined:');

86: END LOOP;
87:
88: EXCEPTION
89: WHEN others THEN
90: POA_LOG.put_line('Error getting organizations with targets defined:');
91: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
92: RAISE;
93: END get_target_orgs;
94:

Line 91: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);

87:
88: EXCEPTION
89: WHEN others THEN
90: POA_LOG.put_line('Error getting organizations with targets defined:');
91: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
92: RAISE;
93: END get_target_orgs;
94:
95: PROCEDURE get_gl_info(

Line 124: POA_LOG.put_line('Error getting GL information:');

120: WHERE set_of_books_id = l_sob_id;
121:
122: EXCEPTION
123: WHEN others THEN
124: POA_LOG.put_line('Error getting GL information:');
125: POA_LOG.put_line(sqlcode || ': ' || sqlerrm || ': ' || x_progress);
126: RAISE;
127: END get_gl_info;
128:

Line 125: POA_LOG.put_line(sqlcode || ': ' || sqlerrm || ': ' || x_progress);

121:
122: EXCEPTION
123: WHEN others THEN
124: POA_LOG.put_line('Error getting GL information:');
125: POA_LOG.put_line(sqlcode || ': ' || sqlerrm || ': ' || x_progress);
126: RAISE;
127: END get_gl_info;
128:
129: PROCEDURE get_period_info(

Line 152: POA_LOG.put_line('Error getting period information:');

148: END IF;
149:
150: EXCEPTION
151: WHEN others THEN
152: POA_LOG.put_line('Error getting period information:');
153: POA_LOG.put_line(sqlcode);
154: RAISE;
155: END get_period_info;
156:

Line 153: POA_LOG.put_line(sqlcode);

149:
150: EXCEPTION
151: WHEN others THEN
152: POA_LOG.put_line('Error getting period information:');
153: POA_LOG.put_line(sqlcode);
154: RAISE;
155: END get_period_info;
156:
157: PROCEDURE get_current_period_info(

Line 183: POA_LOG.put_line('Error getting current GL period:');

179: AND per.end_date >= TRUNC(sysdate);
180:
181: EXCEPTION
182: WHEN others THEN
183: POA_LOG.put_line('Error getting current GL period:');
184: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
185: RAISE;
186: END get_current_period_info;
187:

Line 184: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);

180:
181: EXCEPTION
182: WHEN others THEN
183: POA_LOG.put_line('Error getting current GL period:');
184: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
185: RAISE;
186: END get_current_period_info;
187:
188: PROCEDURE get_previous_period_info(

Line 218: POA_LOG.put_line('Error getting previous GL period:');

214: AND per2.end_date < TRUNC(sysdate));
215:
216: EXCEPTION
217: WHEN others THEN
218: POA_LOG.put_line('Error getting previous GL period:');
219: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
220: RAISE;
221: END get_previous_period_info;
222:

Line 219: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);

215:
216: EXCEPTION
217: WHEN others THEN
218: POA_LOG.put_line('Error getting previous GL period:');
219: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
220: RAISE;
221: END get_previous_period_info;
222:
223: PROCEDURE get_value(

Line 245: POA_LOG.put_line('Error in get_value procedure:');

241: p_value := FND_API.G_MISS_CHAR;
242:
243: EXCEPTION
244: WHEN others THEN
245: POA_LOG.put_line('Error in get_value procedure:');
246: POA_LOG.put_line(sqlcode);
247: RAISE;
248: END get_value;
249:

Line 246: POA_LOG.put_line(sqlcode);

242:
243: EXCEPTION
244: WHEN others THEN
245: POA_LOG.put_line('Error in get_value procedure:');
246: POA_LOG.put_line(sqlcode);
247: RAISE;
248: END get_value;
249:
250: PROCEDURE set_value(

Line 266: POA_LOG.put_line('Error getting period information:');

262: END IF;
263: END LOOP;
264: EXCEPTION
265: WHEN others THEN
266: POA_LOG.put_line('Error getting period information:');
267: POA_LOG.put_line(sqlcode);
268: RAISE;
269: END set_value;
270:

Line 267: POA_LOG.put_line(sqlcode);

263: END LOOP;
264: EXCEPTION
265: WHEN others THEN
266: POA_LOG.put_line('Error getting period information:');
267: POA_LOG.put_line(sqlcode);
268: RAISE;
269: END set_value;
270:
271: PROCEDURE insert_row(

Line 284: POA_LOG.put_line('Error getting period information:');

280: p_value_tbl(l_index).heading := p_heading;
281: p_value_tbl(l_index).value := p_value;
282: EXCEPTION
283: WHEN others THEN
284: POA_LOG.put_line('Error getting period information:');
285: POA_LOG.put_line(sqlcode);
286: RAISE;
287: END insert_row;
288:

Line 285: POA_LOG.put_line(sqlcode);

281: p_value_tbl(l_index).value := p_value;
282: EXCEPTION
283: WHEN others THEN
284: POA_LOG.put_line('Error getting period information:');
285: POA_LOG.put_line(sqlcode);
286: RAISE;
287: END insert_row;
288:
289: PROCEDURE get_actual_poactlkg_all_m(

Line 340: POA_LOG.put_line('Error getting Actual:');

336: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
337:
338: EXCEPTION
339: WHEN others THEN
340: POA_LOG.put_line('Error getting Actual:');
341: POA_LOG.put_line('POACTLKG_ALL_M:' || sqlcode || ': ' || sqlerrm);
342: RAISE;
343: END get_actual_poactlkg_all_m;
344:

Line 341: POA_LOG.put_line('POACTLKG_ALL_M:' || sqlcode || ': ' || sqlerrm);

337:
338: EXCEPTION
339: WHEN others THEN
340: POA_LOG.put_line('Error getting Actual:');
341: POA_LOG.put_line('POACTLKG_ALL_M:' || sqlcode || ': ' || sqlerrm);
342: RAISE;
343: END get_actual_poactlkg_all_m;
344:
345: PROCEDURE get_actual_poactlkg_ou_m(

Line 398: POA_LOG.put_line('Error getting Actual:');

394: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
395:
396: EXCEPTION
397: WHEN others THEN
398: POA_LOG.put_line('Error getting Actual:');
399: POA_LOG.put_line('POACTLKG_OU_M:' || sqlcode || ': ' || sqlerrm);
400: RAISE;
401: END get_actual_poactlkg_ou_m;
402:

Line 399: POA_LOG.put_line('POACTLKG_OU_M:' || sqlcode || ': ' || sqlerrm);

395:
396: EXCEPTION
397: WHEN others THEN
398: POA_LOG.put_line('Error getting Actual:');
399: POA_LOG.put_line('POACTLKG_OU_M:' || sqlcode || ': ' || sqlerrm);
400: RAISE;
401: END get_actual_poactlkg_ou_m;
402:
403: PROCEDURE get_actual_poactlkg_org_m(

Line 456: POA_LOG.put_line('Error getting Actual:');

452: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
453:
454: EXCEPTION
455: WHEN others THEN
456: POA_LOG.put_line('Error getting Actual:');
457: POA_LOG.put_line('POACTLKG_ORG_M:' || sqlcode || ': ' || sqlerrm);
458: RAISE;
459: END get_actual_poactlkg_org_m;
460:

Line 457: POA_LOG.put_line('POACTLKG_ORG_M:' || sqlcode || ': ' || sqlerrm);

453:
454: EXCEPTION
455: WHEN others THEN
456: POA_LOG.put_line('Error getting Actual:');
457: POA_LOG.put_line('POACTLKG_ORG_M:' || sqlcode || ': ' || sqlerrm);
458: RAISE;
459: END get_actual_poactlkg_org_m;
460:
461: PROCEDURE get_actual_poaspsal_ou_m(

Line 494: POA_LOG.put_line('Error getting Actual:');

490: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
491:
492: EXCEPTION
493: WHEN others THEN
494: POA_LOG.put_line('Error getting Actual:');
495: POA_LOG.put_line('POASPSAL_OU_M:' || sqlcode || ': ' || sqlerrm);
496: RAISE;
497: END get_actual_poaspsal_ou_m;
498:

Line 495: POA_LOG.put_line('POASPSAL_OU_M:' || sqlcode || ': ' || sqlerrm);

491:
492: EXCEPTION
493: WHEN others THEN
494: POA_LOG.put_line('Error getting Actual:');
495: POA_LOG.put_line('POASPSAL_OU_M:' || sqlcode || ': ' || sqlerrm);
496: RAISE;
497: END get_actual_poaspsal_ou_m;
498:
499: PROCEDURE get_actual_poaspsal_all_m(

Line 530: POA_LOG.put_line('Error getting Actual:');

526: fnd_message.get_string('POA', 'POA_CURRENCY'), p_currency, p_value_tbl);
527:
528: EXCEPTION
529: WHEN others THEN
530: POA_LOG.put_line('Error getting Actual:');
531: POA_LOG.put_line('POASPSAL_ALL_M:' || sqlcode || ': ' || sqlerrm);
532: RAISE;
533: END get_actual_poaspsal_all_m;
534:

Line 531: POA_LOG.put_line('POASPSAL_ALL_M:' || sqlcode || ': ' || sqlerrm);

527:
528: EXCEPTION
529: WHEN others THEN
530: POA_LOG.put_line('Error getting Actual:');
531: POA_LOG.put_line('POASPSAL_ALL_M:' || sqlcode || ': ' || sqlerrm);
532: RAISE;
533: END get_actual_poaspsal_all_m;
534:
535: PROCEDURE get_actual(

Line 564: POA_LOG.put_line('Error in get_actual procedure:');

560: END IF;
561:
562: EXCEPTION
563: WHEN others THEN
564: POA_LOG.put_line('Error in get_actual procedure:');
565: POA_LOG.put_line(sqlcode);
566: RAISE;
567: END get_actual;
568:

Line 565: POA_LOG.put_line(sqlcode);

561:
562: EXCEPTION
563: WHEN others THEN
564: POA_LOG.put_line('Error in get_actual procedure:');
565: POA_LOG.put_line(sqlcode);
566: RAISE;
567: END get_actual;
568:
569: PROCEDURE get_report_param(

Line 633: POA_LOG.put_line('Error in get_report_param procedure:');

629: END IF;
630:
631: EXCEPTION
632: WHEN others THEN
633: POA_LOG.put_line('Error in get_report_param procedure:');
634: POA_LOG.put_line(sqlcode);
635: RAISE;
636: END get_report_param;
637:

Line 634: POA_LOG.put_line(sqlcode);

630:
631: EXCEPTION
632: WHEN others THEN
633: POA_LOG.put_line('Error in get_report_param procedure:');
634: POA_LOG.put_line(sqlcode);
635: RAISE;
636: END get_report_param;
637:
638: PROCEDURE get_org_name(

Line 656: POA_LOG.put_line('Error getting Organization Name:');

652: END IF;
653:
654: EXCEPTION
655: WHEN others THEN
656: POA_LOG.put_line('Error getting Organization Name:');
657: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
658: p_org_name := NULL;
659: RAISE;
660: END get_org_name;

Line 657: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);

653:
654: EXCEPTION
655: WHEN others THEN
656: POA_LOG.put_line('Error getting Organization Name:');
657: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
658: p_org_name := NULL;
659: RAISE;
660: END get_org_name;
661:

Line 685: POA_LOG.put_line('Posting actual values...');

681: l_value VARCHAR2(120);
682: l_found_index NUMBER;
683: l_heading VARCHAR2(250);
684: BEGIN
685: POA_LOG.put_line('Posting actual values...');
686: l_target_level_rec.target_level_short_name := p_target_level_short_name;
687:
688: BIS_ACTUAL_PUB.Retrieve_User_Selections
689: (p_api_version => 1.0,

Line 704: POA_LOG.debug_line('Processing ORG_ID: ' ||

700: /** DEBUG: Loop 1 record for testing purposes **/
701: FOR l_index IN 1..l_user_selection_tbl.COUNT LOOP
702: -- FOR l_index IN 1..1 LOOP
703: BEGIN
704: POA_LOG.debug_line('Processing ORG_ID: ' ||
705: l_user_selection_tbl(l_index).org_level_value_id);
706: get_period_info(
707: to_number(l_user_selection_tbl(l_index).org_level_value_id),
708: p_for_current_period, l_start_date, l_end_date, l_period_name,

Line 711: POA_LOG.debug_line('Period: ' || l_period_name);

707: to_number(l_user_selection_tbl(l_index).org_level_value_id),
708: p_for_current_period, l_start_date, l_end_date, l_period_name,
709: l_period_set_name, l_currency, l_period_type);
710:
711: POA_LOG.debug_line('Period: ' || l_period_name);
712: POA_LOG.debug_line('Currency: ' || l_currency);
713:
714: get_actual(p_target_level_short_name,
715: to_number(l_user_selection_tbl(l_index).org_level_value_id),

Line 712: POA_LOG.debug_line('Currency: ' || l_currency);

708: p_for_current_period, l_start_date, l_end_date, l_period_name,
709: l_period_set_name, l_currency, l_period_type);
710:
711: POA_LOG.debug_line('Period: ' || l_period_name);
712: POA_LOG.debug_line('Currency: ' || l_currency);
713:
714: get_actual(p_target_level_short_name,
715: to_number(l_user_selection_tbl(l_index).org_level_value_id),
716: l_start_date, l_end_date, l_currency, l_value_tbl);

Line 728: POA_LOG.debug_line('Actual: ' || l_actual_rec.actual);

724: l_period_set_name || '+' || l_period_name;
725:
726: l_actual_rec.target_level_id := l_user_selection_tbl(l_index).target_level_id;
727:
728: POA_LOG.debug_line('Actual: ' || l_actual_rec.actual);
729:
730: poa_log.debug_line('p_Actual_Rec='|| 'actual_id='||l_actual_rec.actual_id || ' ' ||
731: 'target_level_id='||l_actual_rec.target_level_id || ' ' ||
732: 'target_level_name='||l_actual_rec.target_level_name ||' ' ||

Line 730: poa_log.debug_line('p_Actual_Rec='|| 'actual_id='||l_actual_rec.actual_id || ' ' ||

726: l_actual_rec.target_level_id := l_user_selection_tbl(l_index).target_level_id;
727:
728: POA_LOG.debug_line('Actual: ' || l_actual_rec.actual);
729:
730: poa_log.debug_line('p_Actual_Rec='|| 'actual_id='||l_actual_rec.actual_id || ' ' ||
731: 'target_level_id='||l_actual_rec.target_level_id || ' ' ||
732: 'target_level_name='||l_actual_rec.target_level_name ||' ' ||
733: 'target_level_shortname='||l_actual_rec.Target_Level_Short_Name ||' ' ||
734: 'org_level_id='||l_actual_rec.Org_Level_value_ID ||' ' ||

Line 749: POA_LOG.debug_line('Posted Actual: ' || l_return_status);

745: x_msg_count => l_msg_count,
746: x_msg_data => l_msg_data,
747: x_error_tbl => l_error_tbl);
748:
749: POA_LOG.debug_line('Posted Actual: ' || l_return_status);
750: POA_LOG.debug_line('End Processing ORG_ID: ' ||
751: l_user_selection_tbl(l_index).org_level_value_id);
752: EXCEPTION
753: WHEN others THEN

Line 750: POA_LOG.debug_line('End Processing ORG_ID: ' ||

746: x_msg_data => l_msg_data,
747: x_error_tbl => l_error_tbl);
748:
749: POA_LOG.debug_line('Posted Actual: ' || l_return_status);
750: POA_LOG.debug_line('End Processing ORG_ID: ' ||
751: l_user_selection_tbl(l_index).org_level_value_id);
752: EXCEPTION
753: WHEN others THEN
754: POA_LOG.put_line('Failed to post actual for organization:');

Line 754: POA_LOG.put_line('Failed to post actual for organization:');

750: POA_LOG.debug_line('End Processing ORG_ID: ' ||
751: l_user_selection_tbl(l_index).org_level_value_id);
752: EXCEPTION
753: WHEN others THEN
754: POA_LOG.put_line('Failed to post actual for organization:');
755: POA_LOG.put_line(l_user_selection_tbl(l_index).org_level_value_id ||
756: sqlcode || ': ' || sqlerrm);
757: END;
758: END LOOP;

Line 755: POA_LOG.put_line(l_user_selection_tbl(l_index).org_level_value_id ||

751: l_user_selection_tbl(l_index).org_level_value_id);
752: EXCEPTION
753: WHEN others THEN
754: POA_LOG.put_line('Failed to post actual for organization:');
755: POA_LOG.put_line(l_user_selection_tbl(l_index).org_level_value_id ||
756: sqlcode || ': ' || sqlerrm);
757: END;
758: END LOOP;
759:

Line 760: POA_LOG.put_line('Done.');

756: sqlcode || ': ' || sqlerrm);
757: END;
758: END LOOP;
759:
760: POA_LOG.put_line('Done.');
761:
762: EXCEPTION
763: WHEN others THEN
764: POA_LOG.put_line('Error in post_actual procedure:');

Line 764: POA_LOG.put_line('Error in post_actual procedure:');

760: POA_LOG.put_line('Done.');
761:
762: EXCEPTION
763: WHEN others THEN
764: POA_LOG.put_line('Error in post_actual procedure:');
765: POA_LOG.put_line(sqlcode);
766: RAISE;
767: END post_actual;
768:

Line 765: POA_LOG.put_line(sqlcode);

761:
762: EXCEPTION
763: WHEN others THEN
764: POA_LOG.put_line('Error in post_actual procedure:');
765: POA_LOG.put_line(sqlcode);
766: RAISE;
767: END post_actual;
768:
769: PROCEDURE compare_targets(

Line 801: POA_LOG.put_line('Comparing actual against target values...');

797: l_org_name VARCHAR2(80);
798: l_app_name VARCHAR2(240);
799: l_heading VARCHAR2(250);
800: BEGIN
801: POA_LOG.put_line('Comparing actual against target values...');
802:
803: -- Get Application Name
804: SELECT application_name INTO l_app_name
805: FROM fnd_application_vl

Line 826: POA_LOG.debug_line('Processing ORG_ID: ' ||

822: l_target_orgs);
823:
824: FOR l_index IN 1..l_target_orgs.COUNT LOOP
825: BEGIN
826: POA_LOG.debug_line('Processing ORG_ID: ' ||
827: l_target_orgs(l_index).org_level_value_id);
828:
829: get_period_info(
830: to_number(l_target_orgs(l_index).org_level_value_id),

Line 834: POA_LOG.debug_line('Period: '||l_period_set_name || '+' || l_period_name);

830: to_number(l_target_orgs(l_index).org_level_value_id),
831: p_for_current_period, l_start_date, l_end_date, l_period_name,
832: l_period_set_name, l_currency, l_period_type);
833:
834: POA_LOG.debug_line('Period: '||l_period_set_name || '+' || l_period_name);
835: POA_LOG.debug_line('Currency: ' || l_currency);
836:
837: get_target_value(p_target_level_short_name, p_plan_short_name,
838: l_period_set_name || '+' || l_period_name,

Line 835: POA_LOG.debug_line('Currency: ' || l_currency);

831: p_for_current_period, l_start_date, l_end_date, l_period_name,
832: l_period_set_name, l_currency, l_period_type);
833:
834: POA_LOG.debug_line('Period: '||l_period_set_name || '+' || l_period_name);
835: POA_LOG.debug_line('Currency: ' || l_currency);
836:
837: get_target_value(p_target_level_short_name, p_plan_short_name,
838: l_period_set_name || '+' || l_period_name,
839: to_number(l_target_orgs(l_index).org_level_value_id),

Line 842: POA_LOG.debug_line('Target: ' || l_target_rec.target);

838: l_period_set_name || '+' || l_period_name,
839: to_number(l_target_orgs(l_index).org_level_value_id),
840: l_found, l_target_rec);
841:
842: POA_LOG.debug_line('Target: ' || l_target_rec.target);
843:
844: IF (l_found) THEN
845: -- Clear value table
846: l_value_tbl.DELETE;

Line 857: POA_LOG.debug_line('Actual: ' || l_actual);

853: -- need to get the 'real' actual
854: get_value('L_ACTUAL', l_value_tbl, l_found_index, l_heading, l_value);
855: l_actual := TO_NUMBER(l_value);
856:
857: POA_LOG.debug_line('Actual: ' || l_actual);
858:
859: IF (l_target_rec.range1_low <> FND_API.g_miss_num AND
860: l_target_rec.range1_high <> FND_API.g_miss_num) THEN
861: l_range_low := l_target_rec.target*(1-l_target_rec.range1_low/100);

Line 865: POA_LOG.debug_line('Outside Range 1');

861: l_range_low := l_target_rec.target*(1-l_target_rec.range1_low/100);
862: l_range_high := l_target_rec.target*(1+l_target_rec.range1_high/100);
863:
864: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
865: POA_LOG.debug_line('Outside Range 1');
866: insert_row('L_SUBJECT', fnd_message.get_string('POA',
867: 'POA_' || UPPER(l_measure_short_name) || '_SUBJECT'), '(' ||
868: fnd_message.get_string('PO','POA_ACTUAL') || ': ' || l_value ||
869: ' ' || fnd_message.get_string('PO','POA_TARGET') || ': ' ||

Line 914: POA_LOG.debug_line('Outside Range 2');

910: l_range_low := l_target_rec.target*(1-l_target_rec.range2_low/100);
911: l_range_high := l_target_rec.target*(1+l_target_rec.range2_high/100);
912:
913: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
914: POA_LOG.debug_line('Outside Range 2');
915: set_value('L_TARGET_RANGE',
916: fnd_message.get_string('POA','POA_TARGET_RANGE'),
917: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
918: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);

Line 940: POA_LOG.debug_line('Outside Range 3');

936: l_range_low := l_target_rec.target*(1-l_target_rec.range3_low/100);
937: l_range_high := l_target_rec.target*(1+l_target_rec.range3_high/100);
938:
939: IF (l_actual NOT BETWEEN l_range_low AND l_range_high) THEN
940: POA_LOG.debug_line('Outside Range 3');
941: set_value('L_TARGET_RANGE',
942: fnd_message.get_string('POA','POA_TARGET_RANGE'),
943: to_char(l_range_low, POA_BIS_ALERTS.g_percent_mask) || ' - ' ||
944: to_char(l_range_high,POA_BIS_ALERTS.g_percent_mask),l_value_tbl);

Line 960: POA_LOG.debug_line('No target defined');

956:
957: END IF;
958:
959: ELSE
960: POA_LOG.debug_line('No target defined');
961: END IF;
962:
963: POA_LOG.debug_line('End Processing ORG_ID: ' ||
964: l_target_orgs(l_index).org_level_value_id);

Line 963: POA_LOG.debug_line('End Processing ORG_ID: ' ||

959: ELSE
960: POA_LOG.debug_line('No target defined');
961: END IF;
962:
963: POA_LOG.debug_line('End Processing ORG_ID: ' ||
964: l_target_orgs(l_index).org_level_value_id);
965:
966: EXCEPTION
967: WHEN others THEN

Line 968: POA_LOG.put_line('Failed to compare target for organization:' ||

964: l_target_orgs(l_index).org_level_value_id);
965:
966: EXCEPTION
967: WHEN others THEN
968: POA_LOG.put_line('Failed to compare target for organization:' ||
969: l_target_orgs(l_index).org_level_value_id);
970: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
971: END;
972: END LOOP;

Line 970: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);

966: EXCEPTION
967: WHEN others THEN
968: POA_LOG.put_line('Failed to compare target for organization:' ||
969: l_target_orgs(l_index).org_level_value_id);
970: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
971: END;
972: END LOOP;
973:
974: POA_LOG.put_line('Done.');

Line 974: POA_LOG.put_line('Done.');

970: POA_LOG.put_line(sqlcode || ': ' || sqlerrm);
971: END;
972: END LOOP;
973:
974: POA_LOG.put_line('Done.');
975:
976: END compare_targets;
977:
978: PROCEDURE process_alert_current_period(

Line 998: POA_LOG.setup('POAALRTS');

994: p_plan_short_name IN VARCHAR2,
995: p_for_current_period IN BOOLEAN) IS
996: x_progress VARCHAR2(3);
997: BEGIN
998: POA_LOG.setup('POAALRTS');
999: POA_LOG.debug_line('In Process Alerts');
1000:
1001: post_actual(p_target_level_short_name, p_plan_short_name,
1002: p_for_current_period);

Line 999: POA_LOG.debug_line('In Process Alerts');

995: p_for_current_period IN BOOLEAN) IS
996: x_progress VARCHAR2(3);
997: BEGIN
998: POA_LOG.setup('POAALRTS');
999: POA_LOG.debug_line('In Process Alerts');
1000:
1001: post_actual(p_target_level_short_name, p_plan_short_name,
1002: p_for_current_period);
1003: compare_targets(p_target_level_short_name, p_plan_short_name,

Line 1006: POA_LOG.wrapup('SUCCESS');

1002: p_for_current_period);
1003: compare_targets(p_target_level_short_name, p_plan_short_name,
1004: p_for_current_period);
1005:
1006: POA_LOG.wrapup('SUCCESS');
1007:
1008: EXCEPTION WHEN OTHERS THEN
1009: POA_LOG.put_line('Process Alerts: ' || sqlcode || ': ' ||
1010: sqlerrm || ': ' || x_progress);

Line 1009: POA_LOG.put_line('Process Alerts: ' || sqlcode || ': ' ||

1005:
1006: POA_LOG.wrapup('SUCCESS');
1007:
1008: EXCEPTION WHEN OTHERS THEN
1009: POA_LOG.put_line('Process Alerts: ' || sqlcode || ': ' ||
1010: sqlerrm || ': ' || x_progress);
1011: POA_LOG.put_line(' ');
1012: POA_LOG.wrapup('ERROR');
1013: END process_alert;

Line 1011: POA_LOG.put_line(' ');

1007:
1008: EXCEPTION WHEN OTHERS THEN
1009: POA_LOG.put_line('Process Alerts: ' || sqlcode || ': ' ||
1010: sqlerrm || ': ' || x_progress);
1011: POA_LOG.put_line(' ');
1012: POA_LOG.wrapup('ERROR');
1013: END process_alert;
1014:
1015: PROCEDURE start_workflow(

Line 1012: POA_LOG.wrapup('ERROR');

1008: EXCEPTION WHEN OTHERS THEN
1009: POA_LOG.put_line('Process Alerts: ' || sqlcode || ': ' ||
1010: sqlerrm || ': ' || x_progress);
1011: POA_LOG.put_line(' ');
1012: POA_LOG.wrapup('ERROR');
1013: END process_alert;
1014:
1015: PROCEDURE start_workflow(
1016: p_wf_item_type IN VARCHAR2,

Line 1030: POA_LOG.debug_line('Starting Workflow Notification');

1026: SELECT name
1027: FROM wf_roles
1028: WHERE name = p_role;
1029: BEGIN
1030: POA_LOG.debug_line('Starting Workflow Notification');
1031:
1032: x_return_status := FND_API.G_RET_STS_SUCCESS;
1033: IF p_wf_process is NULL or p_role is NULL THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1046: POA_LOG.debug_line('Notifying: ' || l_role_name);

1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: return;
1044: END IF;
1045:
1046: POA_LOG.debug_line('Notifying: ' || l_role_name);
1047:
1048: -- Generate workflow process key
1049: SELECT bis_excpt_wf_s.nextval
1050: INTO l_wf_item_key

Line 1074: POA_LOG.debug_line('Label: ' || p_value_tbl(l_index).label);

1070: l_string := nvl(p_value_tbl(l_index).heading, p_value_tbl(l_index).label)
1071: || ': ' || p_value_tbl(l_index).value;
1072: END IF;
1073:
1074: POA_LOG.debug_line('Label: ' || p_value_tbl(l_index).label);
1075: POA_LOG.debug_line('Value: ' || l_string);
1076:
1077: wf_engine.SetItemAttrText(itemtype => p_wf_item_type,
1078: itemkey => l_wf_item_key,

Line 1075: POA_LOG.debug_line('Value: ' || l_string);

1071: || ': ' || p_value_tbl(l_index).value;
1072: END IF;
1073:
1074: POA_LOG.debug_line('Label: ' || p_value_tbl(l_index).label);
1075: POA_LOG.debug_line('Value: ' || l_string);
1076:
1077: wf_engine.SetItemAttrText(itemtype => p_wf_item_type,
1078: itemkey => l_wf_item_key,
1079: aname=> p_value_tbl(l_index).label,

Line 1088: POA_LOG.debug_line('Exit POA_STRT_WF_PROCESS');

1084: wf_engine.StartProcess(itemtype => p_wf_item_type,
1085: itemkey => l_wf_item_key);
1086:
1087: COMMIT;
1088: POA_LOG.debug_line('Exit POA_STRT_WF_PROCESS');
1089:
1090: EXCEPTION
1091: WHEN others THEN
1092: POA_LOG.put_line('Error in start_workflow procedure:');

Line 1092: POA_LOG.put_line('Error in start_workflow procedure:');

1088: POA_LOG.debug_line('Exit POA_STRT_WF_PROCESS');
1089:
1090: EXCEPTION
1091: WHEN others THEN
1092: POA_LOG.put_line('Error in start_workflow procedure:');
1093: POA_LOG.put_line(sqlcode);
1094: RAISE;
1095: END start_workflow;
1096:

Line 1093: POA_LOG.put_line(sqlcode);

1089:
1090: EXCEPTION
1091: WHEN others THEN
1092: POA_LOG.put_line('Error in start_workflow procedure:');
1093: POA_LOG.put_line(sqlcode);
1094: RAISE;
1095: END start_workflow;
1096:
1097: END POA_BIS_ALERTS;