APPS.QP_COPY_DEBUG_PVT dependencies on QP_PREQ_GRP

Line 7: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

3: l_debug VARCHAR2(3);
4: PROCEDURE Insert_Request IS
5: PRAGMA AUTONOMOUS_TRANSACTION;
6: BEGIN
7: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
8: INSERT INTO
9: qp_debug_req( REQUEST_ID,
10: REQUEST_NAME,
11: ORDER_NUMBER, -- sfiresto 2374448

Line 56: QP_PREQ_GRP.engine_debug('***Inserted 1 Record into QP_DEBUG_REQ***');

52: g_control_rec.currency_code
53: );
54:
55: IF l_debug = FND_API.G_TRUE THEN
56: QP_PREQ_GRP.engine_debug('***Inserted 1 Record into QP_DEBUG_REQ***');
57: END IF;
58: -- dbms_output.put_line('***Inserted 1 Record into QP_DEBUG_REQ***');
59: COMMIT;
60:

Line 67: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

63: PROCEDURE Insert_Line IS
64: PRAGMA AUTONOMOUS_TRANSACTION;
65: Tbl_Index NUMBER;
66: BEGIN
67: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
68: IF LINE_ID_T.COUNT >= 1 then
69: FORALL Tbl_Index IN LINE_ID_T.FIRST .. LINE_ID_T.LAST
70: INSERT INTO
71: QP_DEBUG_REQ_LINES( REQUEST_ID,

Line 164: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_ID_T.COUNT || ' Records into QP_DEBUG_REQ_LINES***');

160: USAGE_PRICING_TYPE_T(Tbl_Index)
161: );
162:
163: IF l_debug = FND_API.G_TRUE THEN
164: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_ID_T.COUNT || ' Records into QP_DEBUG_REQ_LINES***');
165: END IF;
166: -- dbms_output.put_line('***Inserted 1 Record into QP_DEBUG_REQ_LINES***');
167: COMMIT;
168: REQUEST_ID_T.delete;

Line 218: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

214: PROCEDURE Insert_LDet IS
215: PRAGMA AUTONOMOUS_TRANSACTION;
216: Tbl_Index NUMBER;
217: BEGIN
218: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
219: IF LINE_DETAIL_INDEX_T.COUNT >= 1 then
220: FORALL Tbl_Index IN LINE_DETAIL_INDEX_T.FIRST .. LINE_DETAIL_INDEX_T.LAST
221: INSERT INTO
222: QP_DEBUG_REQ_LDETS( REQUEST_ID,

Line 333: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_DETAIL_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LDETS***');

329: nvl(LINE_LIMIT_EXISTS_T(Tbl_Index),'N')
330: );
331:
332: IF l_debug = FND_API.G_TRUE THEN
333: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_DETAIL_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LDETS***');
334: END IF;
335: -- dbms_output.put_line('***Inserted ' || LINE_DETAIL_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LDETS***');
336:
337: COMMIT;

Line 399: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

395: PROCEDURE Insert_Line_Attr IS
396: PRAGMA AUTONOMOUS_TRANSACTION;
397: Tbl_Index NUMBER;
398: BEGIN
399: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
400: IF LINE_INDEX_T.COUNT >= 1 then
401: -- dbms_output.put_line('***attrs - 5***');
402: FORALL Tbl_Index IN LINE_INDEX_T.FIRST .. LINE_INDEX_T.LAST
403: INSERT INTO

Line 480: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LINE_ATTRS***');

476: MODIFIER_LEVEL_CODE_T(Tbl_Index),
477: nvl(PRIMARY_UOM_FLAG_T(Tbl_Index),'N')
478: );
479: IF l_debug = FND_API.G_TRUE THEN
480: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LINE_ATTRS***');
481: END IF;
482: -- dbms_output.put_line('***Inserted ' || LINE_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LINE_ATTRS***');
483: COMMIT;
484: -- dbms_output.put_line('***attrs - 6***');

Line 528: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

524: PROCEDURE Insert_RLTD_Line IS
525: PRAGMA AUTONOMOUS_TRANSACTION;
526: Tbl_Index NUMBER;
527: BEGIN
528: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
529: IF LINE_INDEX_T.COUNT >= 1 then
530: FORALL Tbl_Index IN LINE_INDEX_T.FIRST .. LINE_INDEX_T.LAST
531: INSERT INTO
532: QP_DEBUG_REQ_RLTD_LINES( REQUEST_ID,

Line 579: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_REQ_RLTD_LINES***');

575: SATISFIED_RANGE_VALUE_T(Tbl_Index)
576: );
577:
578: IF l_debug = FND_API.G_TRUE THEN
579: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_REQ_RLTD_LINES***');
580: END IF;
581: -- dbms_output.put_line('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_REQ_RLTD_LINES***');
582:
583: COMMIT;

Line 613: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

609: PROCEDURE Insert_Step_Values IS
610: PRAGMA AUTONOMOUS_TRANSACTION;
611: Tbl_Index NUMBER;
612: BEGIN
613: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
614: IF LINE_INDEX_T.COUNT >= 1 then
615: FORALL Tbl_Index IN LINE_INDEX_T.FIRST .. LINE_INDEX_T.LAST
616: INSERT INTO
617: QP_DEBUG_FORMULA_STEP_VALUES( REQUEST_ID,

Line 640: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_FORMULA_STEP_VALUES***');

636: LIST_LINE_ID_T(Tbl_Index)
637: );
638:
639: IF l_debug = FND_API.G_TRUE THEN
640: QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_FORMULA_STEP_VALUES***');
641: END IF;
642: -- dbms_output.put_line('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_FORMULA_STEP_VALUES***');
643:
644: COMMIT;

Line 668: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

664: IS
665: PRAGMA AUTONOMOUS_TRANSACTION;
666:
667: BEGIN
668: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
669: IF (G_DEBUG_TEXT_LINE_NO is null) or (G_DEBUG_REQUEST_ID is null) then
670: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| 'This line cannot be written into QP_DEBUG_TEXT');
671: return;
672: else

Line 715: PROCEDURE WRITE_TO_DEBUG_TABLES(p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,

711: BEGIN
712: G_DEBUG_REQUEST_ID := null;
713: END SET_REQUEST_TO_NULL;
714:
715: PROCEDURE WRITE_TO_DEBUG_TABLES(p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_return_status_text OUT NOCOPY VARCHAR2)
718: IS
719:

Line 1159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

1155: ORDER_NUMBER_NOT_FOUND EXCEPTION; -- sfiresto 2374448
1156: l_Rec_Count Number;
1157:
1158: BEGIN
1159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1160: IF l_debug = FND_API.G_TRUE THEN
1161: QP_PREQ_GRP.engine_debug('***Begin Duplicating Temp Table Records ***');
1162: END IF;
1163: -- dbms_output.put_line('***Begin Duplicating Temp Table Records ***');

Line 1161: QP_PREQ_GRP.engine_debug('***Begin Duplicating Temp Table Records ***');

1157:
1158: BEGIN
1159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1160: IF l_debug = FND_API.G_TRUE THEN
1161: QP_PREQ_GRP.engine_debug('***Begin Duplicating Temp Table Records ***');
1162: END IF;
1163: -- dbms_output.put_line('***Begin Duplicating Temp Table Records ***');
1164:
1165: OPEN LINE_ID_CUR;

Line 1225: QP_PREQ_GRP.engine_debug('***Inside lines_cur Loop***');

1221:
1222: OPEN lines_cur;
1223: LOOP
1224: IF l_debug = FND_API.G_TRUE THEN
1225: QP_PREQ_GRP.engine_debug('***Inside lines_cur Loop***');
1226: END IF;
1227: -- dbms_output.put_line('***Inside lines_cur Loop***');
1228: FETCH lines_cur
1229: BULK COLLECT INTO

Line 1304: QP_PREQ_GRP.engine_debug('***Repeat lines_cur loop for next 1000 lines - if any***');

1300:
1301: Insert_Line;
1302:
1303: IF l_debug = FND_API.G_TRUE THEN
1304: QP_PREQ_GRP.engine_debug('***Repeat lines_cur loop for next 1000 lines - if any***');
1305: END IF;
1306: -- dbms_output.put_line('***Repeat lines_cur loop for next 1000 lines - if any***');
1307: EXIT WHEN lines_cur%NOTFOUND;
1308:

Line 1315: QP_PREQ_GRP.engine_debug('***Inside ldets_cur Loop***');

1311:
1312: OPEN ldets_cur;
1313: LOOP
1314: IF l_debug = FND_API.G_TRUE THEN
1315: QP_PREQ_GRP.engine_debug('***Inside ldets_cur Loop***');
1316: END IF;
1317: -- dbms_output.put_line('***Inside ldets_cur Loop***');
1318: FETCH ldets_cur
1319: BULK COLLECT INTO

Line 1391: QP_PREQ_GRP.engine_debug('***Repeat ldets_cur loop for next 1000 lines - if any***');

1387:
1388: Insert_LDet;
1389:
1390: IF l_debug = FND_API.G_TRUE THEN
1391: QP_PREQ_GRP.engine_debug('***Repeat ldets_cur loop for next 1000 lines - if any***');
1392: END IF;
1393: -- dbms_output.put_line('***Repeat ldets_cur loop for next 1000 lines - if any***');
1394:
1395: EXIT WHEN ldets_cur%NOTFOUND;

Line 1403: QP_PREQ_GRP.engine_debug('***Inside line_attrs_cur Loop***');

1399:
1400: OPEN line_attrs_cur;
1401: LOOP
1402: IF l_debug = FND_API.G_TRUE THEN
1403: QP_PREQ_GRP.engine_debug('***Inside line_attrs_cur Loop***');
1404: END IF;
1405: -- dbms_output.put_line('***Inside line_attrs_cur Loop***');
1406: FETCH line_attrs_cur
1407: BULK COLLECT INTO

Line 1460: QP_PREQ_GRP.engine_debug('***Repeat line_attrs_cur loop for next 1000 lines - if any***');

1456: -- dbms_output.put_line('***attrs - 4***');
1457: Insert_Line_Attr;
1458:
1459: IF l_debug = FND_API.G_TRUE THEN
1460: QP_PREQ_GRP.engine_debug('***Repeat line_attrs_cur loop for next 1000 lines - if any***');
1461: END IF;
1462: -- dbms_output.put_line('***Repeat line_attrs_cur loop for next 1000 lines - if any***');
1463: EXIT WHEN line_attrs_cur%NOTFOUND;
1464: END LOOP; -- --loop over main line_attrs_cur

Line 1470: QP_PREQ_GRP.engine_debug('***Record count in qp_npreq_rltd_lines_tmp : ' || l_Rec_Count);

1466:
1467: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
1468: select count(*) into l_Rec_Count from qp_npreq_rltd_lines_tmp;
1469: IF l_debug = FND_API.G_TRUE THEN
1470: QP_PREQ_GRP.engine_debug('***Record count in qp_npreq_rltd_lines_tmp : ' || l_Rec_Count);
1471: END IF;
1472: ELSE
1473: select count(*) into l_Rec_Count from qp_int_rltd_lines;
1474: IF l_debug = FND_API.G_TRUE THEN

Line 1475: QP_PREQ_GRP.engine_debug('***Record count in qp_int_rltd_lines : ' || l_Rec_Count);

1471: END IF;
1472: ELSE
1473: select count(*) into l_Rec_Count from qp_int_rltd_lines;
1474: IF l_debug = FND_API.G_TRUE THEN
1475: QP_PREQ_GRP.engine_debug('***Record count in qp_int_rltd_lines : ' || l_Rec_Count);
1476: END IF;
1477: END IF;
1478: OPEN rltd_lines_cur;
1479: LOOP

Line 1481: QP_PREQ_GRP.engine_debug('***Inside rltd_lines_cur Loop***');

1477: END IF;
1478: OPEN rltd_lines_cur;
1479: LOOP
1480: IF l_debug = FND_API.G_TRUE THEN
1481: QP_PREQ_GRP.engine_debug('***Inside rltd_lines_cur Loop***');
1482: END IF;
1483: -- dbms_output.put_line('***Inside rltd_lines_cur Loop***');
1484: FETCH rltd_lines_cur
1485: BULK COLLECT INTO

Line 1509: QP_PREQ_GRP.engine_debug('***Inside rltd_lines_cur Loop : After Fetch***');

1505: SATISFIED_RANGE_VALUE_T
1506: LIMIT 1000;
1507:
1508: IF l_debug = FND_API.G_TRUE THEN
1509: QP_PREQ_GRP.engine_debug('***Inside rltd_lines_cur Loop : After Fetch***');
1510:
1511: QP_PREQ_GRP.engine_debug('LINE_INDEX_T.COUNT:' || LINE_INDEX_T.COUNT);
1512:
1513: END IF;

Line 1511: QP_PREQ_GRP.engine_debug('LINE_INDEX_T.COUNT:' || LINE_INDEX_T.COUNT);

1507:
1508: IF l_debug = FND_API.G_TRUE THEN
1509: QP_PREQ_GRP.engine_debug('***Inside rltd_lines_cur Loop : After Fetch***');
1510:
1511: QP_PREQ_GRP.engine_debug('LINE_INDEX_T.COUNT:' || LINE_INDEX_T.COUNT);
1512:
1513: END IF;
1514: IF LINE_INDEX_T.COUNT <> 0 then
1515: IF l_debug = FND_API.G_TRUE THEN

Line 1516: QP_PREQ_GRP.engine_debug('inside loop');

1512:
1513: END IF;
1514: IF LINE_INDEX_T.COUNT <> 0 then
1515: IF l_debug = FND_API.G_TRUE THEN
1516: QP_PREQ_GRP.engine_debug('inside loop');
1517: END IF;
1518: FOR Tbl_Index in LINE_INDEX_T.FIRST .. LINE_INDEX_T.LAST LOOP
1519: --REQUEST_ID_T(Tbl_Index):= l_request_id;
1520: REQUEST_ID_T(Tbl_Index):= G_DEBUG_REQUEST_ID;

Line 1527: QP_PREQ_GRP.engine_debug('***Repeat rltd_lines_cur loop for next 1000 lines - if any***');

1523:
1524: Insert_RLTD_Line;
1525:
1526: IF l_debug = FND_API.G_TRUE THEN
1527: QP_PREQ_GRP.engine_debug('***Repeat rltd_lines_cur loop for next 1000 lines - if any***');
1528: END IF;
1529: -- dbms_output.put_line('***Repeat rltd_lines_cur loop for next 1000 lines - if any***');
1530: EXIT WHEN rltd_lines_cur%NOTFOUND;
1531: END LOOP; -- --loop over main rltd_lines_cur

Line 1538: QP_PREQ_GRP.engine_debug('***Inside step_values_cur Loop***');

1534:
1535: OPEN step_values_cur;
1536: LOOP
1537: IF l_debug = FND_API.G_TRUE THEN
1538: QP_PREQ_GRP.engine_debug('***Inside step_values_cur Loop***');
1539: END IF;
1540: -- dbms_output.put_line('***Inside step_values_cur Loop***');
1541: FETCH step_values_cur
1542: BULK COLLECT INTO

Line 1563: QP_PREQ_GRP.engine_debug('***Repeat step_values_cur loop for next 1000 lines - if any***');

1559:
1560: Insert_Step_Values;
1561:
1562: IF l_debug = FND_API.G_TRUE THEN
1563: QP_PREQ_GRP.engine_debug('***Repeat step_values_cur loop for next 1000 lines - if any***');
1564: END IF;
1565: -- dbms_output.put_line('***Repeat step_values_cur loop for next 1000 lines - if any***');
1566: EXIT WHEN step_values_cur%NOTFOUND;
1567: END LOOP; -- --loop over main step_values_cur

Line 1571: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES successfully completed ***');

1567: END LOOP; -- --loop over main step_values_cur
1568: CLOSE step_values_cur;
1569:
1570: IF l_debug = FND_API.G_TRUE THEN
1571: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES successfully completed ***');
1572: END IF;
1573: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES successfully completed ***');
1574: IF l_debug = FND_API.G_TRUE THEN
1575: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

Line 1575: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

1571: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES successfully completed ***');
1572: END IF;
1573: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES successfully completed ***');
1574: IF l_debug = FND_API.G_TRUE THEN
1575: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');
1576: END IF;
1577: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579: x_return_status_text := 'Procedure WRITE_TO_DEBUG_TABLES successfully completed';

Line 1583: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);

1579: x_return_status_text := 'Procedure WRITE_TO_DEBUG_TABLES successfully completed';
1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN
1582: IF l_debug = FND_API.G_TRUE THEN
1583: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);
1584: END IF;
1585: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: x_return_status_text := substr(SQLERRM,1,240);

Line 1589: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');

1585: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: x_return_status_text := substr(SQLERRM,1,240);
1588: IF l_debug = FND_API.G_TRUE THEN
1589: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1590: END IF;
1591: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1592: IF l_debug = FND_API.G_TRUE THEN
1593: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

Line 1593: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

1589: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1590: END IF;
1591: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1592: IF l_debug = FND_API.G_TRUE THEN
1593: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');
1594: END IF;
1595: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1596:
1597: WHEN REQUEST_TYPE_CODE_NOT_FOUND THEN

Line 1599: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: REQUEST_TYPE_CODE Not Found'|| SQLERRM);

1595: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1596:
1597: WHEN REQUEST_TYPE_CODE_NOT_FOUND THEN
1598: IF l_debug = FND_API.G_TRUE THEN
1599: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: REQUEST_TYPE_CODE Not Found'|| SQLERRM);
1600: END IF;
1601: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: REQUEST_TYPE_CODE Not Found: '|| SQLERRM);
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: x_return_status_text := 'REQUEST_TYPE_CODE Not Found - ' || substr(SQLERRM,1,200);

Line 1605: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');

1601: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: REQUEST_TYPE_CODE Not Found: '|| SQLERRM);
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: x_return_status_text := 'REQUEST_TYPE_CODE Not Found - ' || substr(SQLERRM,1,200);
1604: IF l_debug = FND_API.G_TRUE THEN
1605: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1606: END IF;
1607: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1608: IF l_debug = FND_API.G_TRUE THEN
1609: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

Line 1609: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

1605: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1606: END IF;
1607: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1608: IF l_debug = FND_API.G_TRUE THEN
1609: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');
1610: END IF;
1611: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1612:
1613: WHEN CURRENCY_CODE_NOT_FOUND THEN

Line 1615: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: CURRENCY_CODE Not Found'|| SQLERRM);

1611: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1612:
1613: WHEN CURRENCY_CODE_NOT_FOUND THEN
1614: IF l_debug = FND_API.G_TRUE THEN
1615: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: CURRENCY_CODE Not Found'|| SQLERRM);
1616: END IF;
1617: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: CURRENCY_CODE Not Found: '|| SQLERRM);
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: x_return_status_text := 'CURRENCY_CODE Not Found - ' || substr(SQLERRM,1,200);

Line 1621: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');

1617: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: CURRENCY_CODE Not Found: '|| SQLERRM);
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619: x_return_status_text := 'CURRENCY_CODE Not Found - ' || substr(SQLERRM,1,200);
1620: IF l_debug = FND_API.G_TRUE THEN
1621: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1622: END IF;
1623: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1624: IF l_debug = FND_API.G_TRUE THEN
1625: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

Line 1625: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

1621: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1622: END IF;
1623: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1624: IF l_debug = FND_API.G_TRUE THEN
1625: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');
1626: END IF;
1627: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1628:
1629: WHEN OTHERS THEN

Line 1631: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);

1627: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1628:
1629: WHEN OTHERS THEN
1630: IF l_debug = FND_API.G_TRUE THEN
1631: QP_PREQ_GRP.engine_debug('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);
1632: END IF;
1633: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: x_return_status_text := substr(SQLERRM,1,240);

Line 1637: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');

1633: -- dbms_output.put_line('In WRITE_TO_DEBUG_TABLES: '|| SQLERRM);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: x_return_status_text := substr(SQLERRM,1,240);
1636: IF l_debug = FND_API.G_TRUE THEN
1637: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1638: END IF;
1639: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1640: IF l_debug = FND_API.G_TRUE THEN
1641: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

Line 1641: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');

1637: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1638: END IF;
1639: -- dbms_output.put_line('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1640: IF l_debug = FND_API.G_TRUE THEN
1641: QP_PREQ_GRP.engine_debug('***End Duplicating Temp Table Records ***');
1642: END IF;
1643: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1644:
1645: END WRITE_TO_DEBUG_TABLES;