APPS.QP_COPY_DEBUG_PVT dependencies on FND_API

Line 55: IF l_debug = FND_API.G_TRUE THEN

51: nvl(g_control_rec.CHECK_CUST_VIEW_FLAG,'N'),
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;

Line 163: IF l_debug = FND_API.G_TRUE THEN

159: nvl(PRIMARY_QUAL_MATCH_FLAG_T(Tbl_Index),'N'),
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;

Line 332: IF l_debug = FND_API.G_TRUE THEN

328: nvl(HEADER_LIMIT_EXISTS_T(Tbl_Index),'N'),
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:

Line 479: IF l_debug = FND_API.G_TRUE THEN

475: LINE_DETAIL_TYPE_CODE_T(Tbl_Index),
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;

Line 578: IF l_debug = FND_API.G_TRUE THEN

574: ADJUSTMENT_AMOUNT_T(Tbl_Index),
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:

Line 639: IF l_debug = FND_API.G_TRUE THEN

635: LIST_HEADER_ID_T(Tbl_Index),
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:

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: OPEN DEBUG_REQUEST_ID_CUR;
696: FETCH DEBUG_REQUEST_ID_CUR INTO l_request_id;
697: G_DEBUG_REQUEST_ID := l_request_id;
698: if (DEBUG_REQUEST_ID_CUR%NOTFOUND) then
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: x_status_text := 'DEBUG_REQUEST_ID_CUR Not Found - ' || SQLERRM;
701: end if;
702: CLOSE DEBUG_REQUEST_ID_CUR;
703: -- dbms_output.put_line('G_DEBUG_REQUEST_ID - ' || G_DEBUG_REQUEST_ID || ', G_DEBUG_TEXT_LINE_NO - ' || G_DEBUG_TEXT_LINE_NO);

Line 706: x_return_status := FND_API.G_RET_STS_ERROR;

702: CLOSE DEBUG_REQUEST_ID_CUR;
703: -- dbms_output.put_line('G_DEBUG_REQUEST_ID - ' || G_DEBUG_REQUEST_ID || ', G_DEBUG_TEXT_LINE_NO - ' || G_DEBUG_TEXT_LINE_NO);
704: EXCEPTION
705: WHEN OTHERS THEN
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: x_status_text := 'DEBUG_REQUEST_ID_CUR Not Found - ' || SQLERRM;
708: END Generate_Debug_Req_Seq;
709:
710: PROCEDURE SET_REQUEST_TO_NULL IS

Line 1160: IF l_debug = FND_API.G_TRUE THEN

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 ***');
1164:

Line 1224: IF l_debug = FND_API.G_TRUE THEN

1220: Insert_Request;
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

Line 1303: IF l_debug = FND_API.G_TRUE THEN

1299: END IF;
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;

Line 1314: IF l_debug = FND_API.G_TRUE THEN

1310: CLOSE lines_cur;
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

Line 1390: IF l_debug = FND_API.G_TRUE THEN

1386:
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:

Line 1402: IF l_debug = FND_API.G_TRUE THEN

1398:
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

Line 1459: IF l_debug = FND_API.G_TRUE THEN

1455:
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;

Line 1469: IF l_debug = FND_API.G_TRUE THEN

1465: CLOSE line_attrs_cur;
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;

Line 1474: 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
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;

Line 1480: IF l_debug = FND_API.G_TRUE THEN

1476: END IF;
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

Line 1508: IF l_debug = FND_API.G_TRUE THEN

1504: ADJUSTMENT_AMOUNT_T,
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:

Line 1515: IF l_debug = FND_API.G_TRUE THEN

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
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;

Line 1526: IF l_debug = FND_API.G_TRUE THEN

1522: END IF;
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;

Line 1537: IF l_debug = FND_API.G_TRUE THEN

1533:
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

Line 1562: IF l_debug = FND_API.G_TRUE THEN

1558: END IF;
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;

Line 1570: IF l_debug = FND_API.G_TRUE THEN

1566: EXIT WHEN step_values_cur%NOTFOUND;
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

Line 1574: IF l_debug = FND_API.G_TRUE THEN

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 ***');
1576: END IF;
1577: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

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';
1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN
1582: IF l_debug = FND_API.G_TRUE THEN

Line 1582: IF l_debug = FND_API.G_TRUE THEN

1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 1586: x_return_status := FND_API.G_RET_STS_ERROR;

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);
1588: IF l_debug = FND_API.G_TRUE THEN
1589: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1590: END IF;

Line 1588: IF l_debug = FND_API.G_TRUE THEN

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);
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

Line 1592: IF l_debug = FND_API.G_TRUE THEN

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 ***');
1594: END IF;
1595: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1596:

Line 1598: IF l_debug = FND_API.G_TRUE THEN

1594: END IF;
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;

Line 1602: x_return_status := FND_API.G_RET_STS_ERROR;

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);
1604: IF l_debug = FND_API.G_TRUE THEN
1605: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1606: END IF;

Line 1604: IF l_debug = FND_API.G_TRUE THEN

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);
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

Line 1608: IF l_debug = FND_API.G_TRUE THEN

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 ***');
1610: END IF;
1611: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1612:

Line 1614: IF l_debug = FND_API.G_TRUE THEN

1610: END IF;
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;

Line 1618: x_return_status := FND_API.G_RET_STS_ERROR;

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);
1620: IF l_debug = FND_API.G_TRUE THEN
1621: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1622: END IF;

Line 1620: IF l_debug = FND_API.G_TRUE THEN

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);
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

Line 1624: IF l_debug = FND_API.G_TRUE THEN

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 ***');
1626: END IF;
1627: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1628:

Line 1630: IF l_debug = FND_API.G_TRUE THEN

1626: END IF;
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;

Line 1634: x_return_status := FND_API.G_RET_STS_ERROR;

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);
1636: IF l_debug = FND_API.G_TRUE THEN
1637: QP_PREQ_GRP.engine_debug('***Procedure WRITE_TO_DEBUG_TABLES Failed ***');
1638: END IF;

Line 1636: IF l_debug = FND_API.G_TRUE THEN

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);
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

Line 1640: IF l_debug = FND_API.G_TRUE THEN

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 ***');
1642: END IF;
1643: -- dbms_output.put_line('***End Duplicating Temp Table Records ***');
1644: