478: IF l_debug = FND_API.G_TRUE THEN
479: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
480:
481: END IF;
482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
483: THEN
484: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
485: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
486: l_message := FND_MESSAGE.GET;
523: IF l_debug = FND_API.G_TRUE THEN
524: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
525:
526: END IF;
527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
530: l_message := FND_MESSAGE.GET;
531:
605: IF l_debug = FND_API.G_TRUE THEN
606: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
607:
608: END IF;
609: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
610: THEN
611: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
612: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
613: l_message := FND_MESSAGE.GET;
650: IF l_debug = FND_API.G_TRUE THEN
651: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
652:
653: END IF;
654: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
655: THEN
656: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
657: l_message := FND_MESSAGE.GET;
658:
972:
973: END IF;
974: WHEN E_ORDER_PRICE_REQ_CODE_NULL THEN
975:
976: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
977: THEN
978: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
979: l_message := FND_MESSAGE.GET;
980:
1011: IF l_debug = FND_API.G_TRUE THEN
1012: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1013:
1014: END IF;
1015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1016: THEN
1017: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1018: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1019: l_message := FND_MESSAGE.GET;
1056: IF l_debug = FND_API.G_TRUE THEN
1057: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1058:
1059: END IF;
1060: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1061: THEN
1062: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1063: l_message := FND_MESSAGE.GET;
1064: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);
1500: g_limit_balance_line(i).process_action := g_insert;
1501:
1502: WHEN E_ORDER_PRICE_REQ_CODE_NULL THEN
1503:
1504: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506: FND_MESSAGE.SET_NAME('QP','QP_ORDER_PRICE_REQ_CODE_NULL');
1507: l_message := FND_MESSAGE.GET;
1508:
1539: IF l_debug = FND_API.G_TRUE THEN
1540: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1541:
1542: END IF;
1543: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1544: THEN
1545: FND_MESSAGE.SET_NAME('QP','QP_MULT_LIMIT_BALANCES');
1546: FND_MESSAGE.SET_TOKEN('LIMIT', g_limit_balance_line(i).limit_id);
1547: l_message := FND_MESSAGE.GET;
1585: IF l_debug = FND_API.G_TRUE THEN
1586: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1587:
1588: END IF;
1589: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1590: THEN
1591: FND_MESSAGE.SET_NAME('QP','QP_ERROR_IN_LIMIT_PROCESSING');
1592: l_message := FND_MESSAGE.GET;
1593: l_message := substr(ltrim(rtrim(l_message))||l_message, 1, 2000);