APPS.IBW_PAGES_PUB dependencies on DBMS_OUTPUT

Line 53: dbms_output.put_line('Insert row called');

49: l_prog_appl_id ibw_pages_b.program_application_id%TYPE; -- Code Added, Notgenerated by AFTBLGEN
50: l_program_id ibw_pages_b.program_id%TYPE; -- Code Added, Not generated by AFTBLGEN
51: BEGIN
52:
53: dbms_output.put_line('Insert row called');
54: l_prog_appl_id := fnd_global.prog_appl_id; -- Code Added,Not generatedby AFTBLGEN
55: l_program_id := fnd_global.conc_program_id; -- Code Added,Not generated by AFTBLGEN
56:
57: IF (IBW_PAGES_PUB.GET_SITEAREA_STATUS (x_site_area_id) = 'N')

Line 59: dbms_output.put_line('Inside the sitearea condition');

55: l_program_id := fnd_global.conc_program_id; -- Code Added,Not generated by AFTBLGEN
56:
57: IF (IBW_PAGES_PUB.GET_SITEAREA_STATUS (x_site_area_id) = 'N')
58: THEN
59: dbms_output.put_line('Inside the sitearea condition');
60: IBW_PAGES_PUB.FORCE_UPDATE_SITEAREA (x_site_area_id,
61: x_last_update_date,
62: x_last_updated_by,
63: x_last_update_login

Line 66: dbms_output.put_line('Site area found');

62: x_last_updated_by,
63: x_last_update_login
64: );
65: END IF;
66: dbms_output.put_line('Site area found');
67: INSERT INTO IBW_PAGES_B
68: (page_id, page_code, page_status,
69: application_context, business_context, REFERENCE,
70: page_matching_criteria, site_area_id,

Line 97: dbms_output.put_line('Site area found');

93: M.program_id, M.program_login_id, M.program_application_id, M.request_id
94: FROM ibw_pages_b M, fnd_languages l, fnd_languages b
95: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.page_id=x_page_id;
96:
97: dbms_output.put_line('Site area found');
98:
99: OPEN c;
100: FETCH c INTO x_rowid;
101:

Line 487: dbms_output.put_line('An Error Occured in load row');

483: END IF;
484: EXCEPTION
485: WHEN NO_DATA_FOUND
486: THEN
487: dbms_output.put_line('An Error Occured in load row');
488: IBW_PAGES_PUB.INSERT_ROW (x_rowid => row_id,
489: x_page_id => x_page_id,
490: x_page_code => x_page_code,
491: x_page_status => x_page_status,

Line 616: dbms_output.put_line('force update');

612: last_update_date DATE;
613: last_updated_by NUMBER;
614: last_update_login NUMBER;
615: BEGIN
616: dbms_output.put_line('force update');
617: SELECT lookup_type, security_group_id, view_application_id,
618: lookup_code, tag, attribute_category, attribute1, attribute2,
619: attribute3, attribute4, enabled_flag, start_date_active,
620: end_date_active, territory_code, attribute5, attribute6,

Line 635: dbms_output.put_line('tryin to update lookups');

631: FROM FND_LOOKUP_VALUES
632: WHERE lookup_type = 'IBW_SITE_AREA'
633: AND lookup_code = TO_CHAR (x_site_area_id)
634: and language=userenv('Lang');
635: dbms_output.put_line('tryin to update lookups');
636: FND_LOOKUP_VALUES_PKG.UPDATE_ROW (lookup_type,
637: security_group_id,
638: view_application_id,
639: lookup_code,