DBA Data[Home] [Help]

APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on FND_FILE

Line 15: fnd_file.put_line( fnd_file.log, pBUFF);

11: is
12: begin
13:
14: if C_MSC_DEBUG = 'Y' then
15: fnd_file.put_line( fnd_file.log, pBUFF);
16: else
17: null;
18: --dbms_output.put_line( pBUFF);
19: end if;

Line 27: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);

23: PROCEDURE LOG_MESSAGE( pBUFF IN VARCHAR2)
24: IS
25: BEGIN
26:
27: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
28:
29: END LOG_MESSAGE;
30:
31: Procedure ins( a in varchar2) is

Line 494: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

490: exception
491: when NO_DATA_FOUND then
492: null;
493: WHEN others THEN
494: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
495: errbuf := substr(SQLERRM,1,150);
496: end ;
497:
498:

Line 594: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

590: ins('ERROR ' || v_sql_stmt);
591: debug_line('ERROR ' || v_sql_stmt);
592: ins('ERROR ' || errbuf);
593: debug_line('ERROR ' || errbuf);
594: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
595: fnd_file.put_line(fnd_file.log, 'The offending sql is:');
596: fnd_file.put_line(fnd_file.log, v_sql_stmt);
597: rollback;
598: -- rollback to Savepoint Before_Delete ;

Line 595: fnd_file.put_line(fnd_file.log, 'The offending sql is:');

591: debug_line('ERROR ' || v_sql_stmt);
592: ins('ERROR ' || errbuf);
593: debug_line('ERROR ' || errbuf);
594: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
595: fnd_file.put_line(fnd_file.log, 'The offending sql is:');
596: fnd_file.put_line(fnd_file.log, v_sql_stmt);
597: rollback;
598: -- rollback to Savepoint Before_Delete ;
599:

Line 596: fnd_file.put_line(fnd_file.log, v_sql_stmt);

592: ins('ERROR ' || errbuf);
593: debug_line('ERROR ' || errbuf);
594: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
595: fnd_file.put_line(fnd_file.log, 'The offending sql is:');
596: fnd_file.put_line(fnd_file.log, v_sql_stmt);
597: rollback;
598: -- rollback to Savepoint Before_Delete ;
599:
600: End translate_level_parent_values ;

Line 757: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

753: EXCEPTION
754: when others then
755: errbuf := substr(SQLERRM,1,150);
756: retcode := -1;
757: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
758:
759:
760: END PROCESS_LEVEL_VALUE_PER_ROW;
761:

Line 833: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

829: EXCEPTION
830: when others then
831: errbuf := substr(SQLERRM,1,150);
832: retcode := -1;
833: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
834:
835:
836:
837: END CREATE_DELETED_LEVEL_VALUES;

Line 950: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

946: EXCEPTION
947: when others then
948: errbuf := substr(SQLERRM,1,150);
949: retcode := -1;
950: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
951:
952:
953: END PROCESS_LEVEL_ASSOCIATION;
954:

Line 1009: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1005: EXCEPTION
1006: when others then
1007: errbuf := substr(SQLERRM,1,150);
1008: retcode := -1;
1009: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1010:
1011:
1012:
1013: END CREATE_DELETED_LEVEL_ASSOCI;

Line 1109: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1105: EXCEPTION
1106: when others then
1107: errbuf := substr(SQLERRM,1,150);
1108: retcode := -1;
1109: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1110:
1111:
1112:
1113: END PROCESS_TOP_LEVEL_VALUES;

Line 1216: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1212: EXCEPTION
1213: when others then
1214: errbuf := substr(SQLERRM,1,150);
1215: retcode := -1;
1216: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1217:
1218:
1219:
1220: END CREATE_ITEM_LIST_PRICE;

Line 1274: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1270: EXCEPTION
1271: when others then
1272: errbuf := substr(SQLERRM,1,150);
1273: retcode := -1;
1274: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1275:
1276:
1277:
1278: END DELETED_ITEM_LIST_PRICE;

Line 1388: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1384: EXCEPTION
1385: when others then
1386: errbuf := substr(SQLERRM,1,150);
1387: retcode := -1;
1388: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1389:
1390:
1391: END UPDATE_ITEM_LIST_PRICE;
1392:

Line 1430: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1426:
1427:
1428: EXCEPTION
1429: when others then
1430: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1431: errbuf := substr(SQLERRM,1,150);
1432: retcode := -1;
1433:
1434: END CLEAN_DELETED_LEVEL_VALUES;

Line 1558: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));

1554: EXCEPTION
1555: when others then
1556: errbuf := substr(SQLERRM,1,150);
1557: retcode := -1;
1558: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1559: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1560: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1561:
1562: end;

Line 1559: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));

1555: when others then
1556: errbuf := substr(SQLERRM,1,150);
1557: retcode := -1;
1558: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1559: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1560: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1561:
1562: end;
1563:

Line 1560: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1556: errbuf := substr(SQLERRM,1,150);
1557: retcode := -1;
1558: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1559: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1560: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1561:
1562: end;
1563:
1564:

Line 1717: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));

1713: EXCEPTION
1714: when others then
1715: errbuf := substr(SQLERRM,1,150);
1716: retcode := -1;
1717: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1718: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1719: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1720:
1721: end;

Line 1718: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));

1714: when others then
1715: errbuf := substr(SQLERRM,1,150);
1716: retcode := -1;
1717: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1718: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1719: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1720:
1721: end;
1722:

Line 1719: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));

1715: errbuf := substr(SQLERRM,1,150);
1716: retcode := -1;
1717: fnd_file.put_line(fnd_file.log, substr(v_stmt, 1, 100));
1718: fnd_file.put_line(fnd_file.log, substr(v_stmt,100, 200));
1719: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
1720:
1721: end;
1722:
1723:

Line 1805: fnd_file.put_line(fnd_file.log,substr(p_sql, i, 255));

1801: Begin
1802: while i<= length(p_sql)
1803: loop
1804: -- dbms_output.put_line (substr(p_sql, i, 255));
1805: fnd_file.put_line(fnd_file.log,substr(p_sql, i, 255));
1806: null;
1807: i := i+255;
1808: end loop;
1809: End;