464: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
465: BEGIN
466:
467:
468: oe_debug_pub.add('in apply attribute changes');
469:
470:
471: -- Load out record
472:
689: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,p_old_QUALIFIERS_rec.qualify_hier_descendent_flag)
690: THEN
691: NULL;
692: END IF;
693: oe_debug_pub.add(' leaving apply attribute changes');
694:
695: END Apply_Attribute_Changes;
696:
697: -- Function Complete_Record
2270: IS
2271: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2272: BEGIN
2273:
2274: oe_debug_pub.add('in QPXUQPQB.pls lock row');
2275:
2276:
2277:
2278:
2553: THEN
2554:
2555: -- Row has not changed. Set out parameter.
2556:
2557: oe_debug_pub.add('row not changed');
2558: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
2559:
2560: -- Set return status
2561:
2564:
2565: ELSE
2566:
2567: -- Row has changed by another user.
2568: oe_debug_pub.add('row changed');
2569:
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2572:
2589:
2590: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2591: THEN
2592:
2593: oe_debug_pub.add('row deleted');
2594: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_DELETED');
2595: OE_MSG_PUB.Add;
2596:
2597: END IF;
3057: --7120399
3058:
3059: BEGIN
3060:
3061: oe_debug_pub.Add('Entering OE_QUALIFIERS_Util.pre_write_process');
3062: oe_debug_pub.Add('mkarya - p_QUALIFIERS_rec.operation = ' ||p_QUALIFIERS_rec.operation);
3063:
3064:
3065: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3058:
3059: BEGIN
3060:
3061: oe_debug_pub.Add('Entering OE_QUALIFIERS_Util.pre_write_process');
3062: oe_debug_pub.Add('mkarya - p_QUALIFIERS_rec.operation = ' ||p_QUALIFIERS_rec.operation);
3063:
3064:
3065: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3066:
3173: END IF;
3174:
3175: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3176:
3177: oe_debug_pub.add('log delayed request------------');
3178:
3179: qp_delayed_requests_PVT.log_request(
3180: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3181: p_param1 => p_QUALIFIERS_rec.list_header_id,
3261: /*
3262: IF (p_QUALIFIERS_rec.operation IN
3263: (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)) THEN
3264:
3265: oe_debug_pub.add('log delayed request--------warn_same_qual_grp');
3266:
3267: qp_delayed_requests_PVT.log_request(
3268: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3269: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3301: WHEN OTHERS THEN
3302: NULL;
3303: END;
3304: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3305: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3306: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3307: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3308: qp_delayed_requests_PVT.log_request(
3309: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3302: NULL;
3303: END;
3304: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3305: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3306: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3307: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3308: qp_delayed_requests_PVT.log_request(
3309: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3310: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3303: END;
3304: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3305: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3306: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3307: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3308: qp_delayed_requests_PVT.log_request(
3309: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3310: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3311: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3344: begin
3345:
3346: for l_rec in c_qual_grp
3347: LOOP
3348: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3349: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3350: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3351: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3352: qp_delayed_requests_PVT.log_request(
3345:
3346: for l_rec in c_qual_grp
3347: LOOP
3348: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3349: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3350: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3351: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3352: qp_delayed_requests_PVT.log_request(
3353: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3346: for l_rec in c_qual_grp
3347: LOOP
3348: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3349: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3350: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3351: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3352: qp_delayed_requests_PVT.log_request(
3353: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3354: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3347: LOOP
3348: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3349: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3350: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3351: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3352: qp_delayed_requests_PVT.log_request(
3353: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3354: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3355: p_request_unique_key2 => l_rec.qualifier_grouping_no,