APPS.PO_ORGS_SV dependencies on DBMS_OUTPUT

Line 493: dbms_output.put_line('All Blanks');

489:
490: /* bao */
491: IF (p_org_record.organization_code IS NULL AND
492: p_org_record.organization_id IS NULL) THEN
493: dbms_output.put_line('All Blanks');
494: p_org_record.error_record.error_message := 'All blanks';
495: p_org_record.error_record.error_status := 'E';
496: RETURN;
497: END IF;

Line 543: dbms_output.put_line('Not Active');

539: IF NOT x_sysdate BETWEEN
540: NVL(x_date_table(x_organization_id).v_enable_date, X_sysdate-1) AND
541: NVL(x_date_table(x_organization_id).v_disable_date, X_sysdate+1) THEN
542:
543: dbms_output.put_line('Not Active');
544: p_org_record.error_record.error_status := 'E';
545: p_org_record.error_record.error_message := 'ORG_DISABLED';
546: END IF;
547:

Line 550: dbms_output.put_line('Invalid Organization Code');

546: END IF;
547:
548: EXCEPTION
549: WHEN NO_DATA_FOUND THEN
550: dbms_output.put_line('Invalid Organization Code');
551: p_org_record.error_record.error_status := 'E';
552: p_org_record.error_record.error_message := 'ORG_ID';
553: WHEN TOO_MANY_ROWS THEN
554: dbms_output.put_line('Too many rows');

Line 554: dbms_output.put_line('Too many rows');

550: dbms_output.put_line('Invalid Organization Code');
551: p_org_record.error_record.error_status := 'E';
552: p_org_record.error_record.error_message := 'ORG_ID';
553: WHEN TOO_MANY_ROWS THEN
554: dbms_output.put_line('Too many rows');
555: p_org_record.error_record.error_status := 'E';
556: p_org_record.error_record.error_message := 'TOOMANYROWS';
557: WHEN OTHERS THEN
558: p_org_record.error_record.error_status := 'U';

Line 574: dbms_output.put_line('All Blanks');

570:
571: IF p_org_record.organization_code IS NULL and
572: p_org_record.organization_id IS NULL THEN
573:
574: dbms_output.put_line('All Blanks');
575: p_org_record.error_record.error_message := 'All blanks';
576: p_org_record.error_record.error_status := 'E';
577: RETURN;
578:

Line 597: dbms_output.put_line(substr(X_sql_str,1,255));

593: END IF;
594:
595: X_sql_str := substr(X_sql_str,1,length(X_sql_str)-3);
596:
597: dbms_output.put_line(substr(X_sql_str,1,255));
598: dbms_output.put_line(substr(X_sql_str,256,255));
599: dbms_output.put_line(substr(X_sql_str,513,255));
600:
601: X_cid := dbms_sql.open_cursor;

Line 598: dbms_output.put_line(substr(X_sql_str,256,255));

594:
595: X_sql_str := substr(X_sql_str,1,length(X_sql_str)-3);
596:
597: dbms_output.put_line(substr(X_sql_str,1,255));
598: dbms_output.put_line(substr(X_sql_str,256,255));
599: dbms_output.put_line(substr(X_sql_str,513,255));
600:
601: X_cid := dbms_sql.open_cursor;
602:

Line 599: dbms_output.put_line(substr(X_sql_str,513,255));

595: X_sql_str := substr(X_sql_str,1,length(X_sql_str)-3);
596:
597: dbms_output.put_line(substr(X_sql_str,1,255));
598: dbms_output.put_line(substr(X_sql_str,256,255));
599: dbms_output.put_line(substr(X_sql_str,513,255));
600:
601: X_cid := dbms_sql.open_cursor;
602:
603: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);

Line 633: dbms_output.put_line('Not Active');

629: IF NOT X_sysdate BETWEEN
630: nvl(X_user_definition_enable_date,X_sysdate - 1) and
631: nvl(X_disable_date,X_sysdate + 1) THEN
632:
633: dbms_output.put_line('Not Active');
634: p_org_record.error_record.error_status := 'E';
635: p_org_record.error_record.error_message := 'ORG_DISABLED';
636:
637: IF dbms_sql.is_open(X_cid) THEN

Line 651: dbms_output.put_line('Invalid Organization Code');

647:
648:
649: ELSIF X_rows_processed = 0 THEN
650:
651: dbms_output.put_line('Invalid Organization Code');
652: p_org_record.error_record.error_status := 'E';
653: p_org_record.error_record.error_message := 'ORG_ID';
654:
655: IF dbms_sql.is_open(X_cid) THEN

Line 663: dbms_output.put_line('Too many rows');

659: RETURN;
660:
661: ELSE
662:
663: dbms_output.put_line('Too many rows');
664: p_org_record.error_record.error_status := 'E';
665: p_org_record.error_record.error_message := 'TOOMANYROWS';
666:
667: IF dbms_sql.is_open(X_cid) THEN