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
2269: IS
2270: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2271: BEGIN
2272:
2273: oe_debug_pub.add('in QPXUQPQB.pls lock row');
2274:
2275:
2276:
2277:
2552: THEN
2553:
2554: -- Row has not changed. Set out parameter.
2555:
2556: oe_debug_pub.add('row not changed');
2557: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
2558:
2559: -- Set return status
2560:
2562: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2563:
2564: ELSE
2565: --8594682 - Add debug messages for OE_LOCK error
2566: oe_debug_pub.ADD('-------------------Data compare in Price list line Qualifier(database vs record)------------------');
2567: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2568: oe_debug_pub.ADD('attribute1 :'||l_QUALIFIERS_rec.attribute1||':'||p_QUALIFIERS_rec.attribute1||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2563:
2564: ELSE
2565: --8594682 - Add debug messages for OE_LOCK error
2566: oe_debug_pub.ADD('-------------------Data compare in Price list line Qualifier(database vs record)------------------');
2567: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2568: oe_debug_pub.ADD('attribute1 :'||l_QUALIFIERS_rec.attribute1||':'||p_QUALIFIERS_rec.attribute1||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2564: ELSE
2565: --8594682 - Add debug messages for OE_LOCK error
2566: oe_debug_pub.ADD('-------------------Data compare in Price list line Qualifier(database vs record)------------------');
2567: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2568: oe_debug_pub.ADD('attribute1 :'||l_QUALIFIERS_rec.attribute1||':'||p_QUALIFIERS_rec.attribute1||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2565: --8594682 - Add debug messages for OE_LOCK error
2566: oe_debug_pub.ADD('-------------------Data compare in Price list line Qualifier(database vs record)------------------');
2567: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2568: oe_debug_pub.ADD('attribute1 :'||l_QUALIFIERS_rec.attribute1||':'||p_QUALIFIERS_rec.attribute1||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2566: oe_debug_pub.ADD('-------------------Data compare in Price list line Qualifier(database vs record)------------------');
2567: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2568: oe_debug_pub.ADD('attribute1 :'||l_QUALIFIERS_rec.attribute1||':'||p_QUALIFIERS_rec.attribute1||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2567: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2568: oe_debug_pub.ADD('attribute1 :'||l_QUALIFIERS_rec.attribute1||':'||p_QUALIFIERS_rec.attribute1||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2568: oe_debug_pub.ADD('attribute1 :'||l_QUALIFIERS_rec.attribute1||':'||p_QUALIFIERS_rec.attribute1||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2569: oe_debug_pub.ADD('attribute10 :'||l_QUALIFIERS_rec.attribute10||':'||p_QUALIFIERS_rec.attribute10||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2570: oe_debug_pub.ADD('attribute11 :'||l_QUALIFIERS_rec.attribute11||':'||p_QUALIFIERS_rec.attribute11||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2571: oe_debug_pub.ADD('attribute12 :'||l_QUALIFIERS_rec.attribute12||':'||p_QUALIFIERS_rec.attribute12||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2572: oe_debug_pub.ADD('attribute13 :'||l_QUALIFIERS_rec.attribute13||':'||p_QUALIFIERS_rec.attribute13||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2573: oe_debug_pub.ADD('attribute14 :'||l_QUALIFIERS_rec.attribute14||':'||p_QUALIFIERS_rec.attribute14||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2574: oe_debug_pub.ADD('attribute15 :'||l_QUALIFIERS_rec.attribute15||':'||p_QUALIFIERS_rec.attribute15||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2575: oe_debug_pub.ADD('attribute2 :'||l_QUALIFIERS_rec.attribute2||':'||p_QUALIFIERS_rec.attribute2||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2576: oe_debug_pub.ADD('attribute3 :'||l_QUALIFIERS_rec.attribute3||':'||p_QUALIFIERS_rec.attribute3||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2577: oe_debug_pub.ADD('attribute4 :'||l_QUALIFIERS_rec.attribute4||':'||p_QUALIFIERS_rec.attribute4||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2578: oe_debug_pub.ADD('attribute5 :'||l_QUALIFIERS_rec.attribute5||':'||p_QUALIFIERS_rec.attribute5||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2579: oe_debug_pub.ADD('attribute6 :'||l_QUALIFIERS_rec.attribute6||':'||p_QUALIFIERS_rec.attribute6||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2580: oe_debug_pub.ADD('attribute7 :'||l_QUALIFIERS_rec.attribute7||':'||p_QUALIFIERS_rec.attribute7||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2581: oe_debug_pub.ADD('attribute8 :'||l_QUALIFIERS_rec.attribute8||':'||p_QUALIFIERS_rec.attribute8||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2582: oe_debug_pub.ADD('attribute9 :'||l_QUALIFIERS_rec.attribute9||':'||p_QUALIFIERS_rec.attribute9||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2583: oe_debug_pub.ADD('comparison_operator_code:'||l_QUALIFIERS_rec.comparison_operator_code||':'||p_QUALIFIERS_rec.comparison_operator_code||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2584: oe_debug_pub.ADD('context :'||l_QUALIFIERS_rec.context||':'||p_QUALIFIERS_rec.context||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2585: oe_debug_pub.ADD('created_by :'||l_QUALIFIERS_rec.created_by||':'||p_QUALIFIERS_rec.created_by||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2586: oe_debug_pub.ADD('created_from_rule_id :'||l_QUALIFIERS_rec.created_from_rule_id||':'||p_QUALIFIERS_rec.created_from_rule_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2587: oe_debug_pub.ADD('creation_date :'||l_QUALIFIERS_rec.creation_date||':'||p_QUALIFIERS_rec.creation_date||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2588: oe_debug_pub.ADD('end_date_active :'||l_QUALIFIERS_rec.end_date_active||':'||p_QUALIFIERS_rec.end_date_active||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2589: oe_debug_pub.ADD('excluder_flag :'||l_QUALIFIERS_rec.excluder_flag||':'||p_QUALIFIERS_rec.excluder_flag||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2590: oe_debug_pub.ADD('last_updated_by :'||l_QUALIFIERS_rec.last_updated_by||':'||p_QUALIFIERS_rec.last_updated_by||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2591: oe_debug_pub.ADD('last_update_date :'||l_QUALIFIERS_rec.last_update_date||':'||p_QUALIFIERS_rec.last_update_date||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2592: oe_debug_pub.ADD('last_update_login :'||l_QUALIFIERS_rec.last_update_login||':'||p_QUALIFIERS_rec.last_update_login||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2593: oe_debug_pub.ADD('list_header_id :'||l_QUALIFIERS_rec.list_header_id||':'||p_QUALIFIERS_rec.list_header_id||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2594: oe_debug_pub.ADD('list_line_id :'||l_QUALIFIERS_rec.list_line_id||':'||p_QUALIFIERS_rec.list_line_id||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2595: oe_debug_pub.ADD('program_application_id:'||l_QUALIFIERS_rec.program_application_id||':'||p_QUALIFIERS_rec.program_application_id||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2596: oe_debug_pub.ADD('program_id :'||l_QUALIFIERS_rec.program_id||':'||p_QUALIFIERS_rec.program_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2597: oe_debug_pub.ADD('program_update_date :'||l_QUALIFIERS_rec.program_update_date||':'||p_QUALIFIERS_rec.program_update_date||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2598: oe_debug_pub.ADD('qualifier_attribute :'||l_QUALIFIERS_rec.qualifier_attribute||':'||p_QUALIFIERS_rec.qualifier_attribute||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2599: oe_debug_pub.ADD('qualifier_attr_value :'||l_QUALIFIERS_rec.qualifier_attr_value||':'||p_QUALIFIERS_rec.qualifier_attr_value||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2607: oe_debug_pub.ADD('request_id :'||l_QUALIFIERS_rec.request_id||':'||p_QUALIFIERS_rec.request_id||':');
2600: oe_debug_pub.ADD('qualifier_attr_value_to:'||l_QUALIFIERS_rec.qualifier_attr_value_to||':'||p_QUALIFIERS_rec.qualifier_attr_value_to||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2607: oe_debug_pub.ADD('request_id :'||l_QUALIFIERS_rec.request_id||':'||p_QUALIFIERS_rec.request_id||':');
2608: oe_debug_pub.ADD('start_date_active :'||l_QUALIFIERS_rec.start_date_active||':'||p_QUALIFIERS_rec.start_date_active||':');
2601: oe_debug_pub.ADD('qualifier_context :'||l_QUALIFIERS_rec.qualifier_context||':'||p_QUALIFIERS_rec.qualifier_context||':');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2607: oe_debug_pub.ADD('request_id :'||l_QUALIFIERS_rec.request_id||':'||p_QUALIFIERS_rec.request_id||':');
2608: oe_debug_pub.ADD('start_date_active :'||l_QUALIFIERS_rec.start_date_active||':'||p_QUALIFIERS_rec.start_date_active||':');
2609: oe_debug_pub.ADD('-------------------Data compare in price list line qualifier end------------------');
2602: oe_debug_pub.ADD('qualifier_datatype :'||l_QUALIFIERS_rec.qualifier_datatype||':'||p_QUALIFIERS_rec.qualifier_datatype||':');
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2607: oe_debug_pub.ADD('request_id :'||l_QUALIFIERS_rec.request_id||':'||p_QUALIFIERS_rec.request_id||':');
2608: oe_debug_pub.ADD('start_date_active :'||l_QUALIFIERS_rec.start_date_active||':'||p_QUALIFIERS_rec.start_date_active||':');
2609: oe_debug_pub.ADD('-------------------Data compare in price list line qualifier end------------------');
2610: -- Row has changed by another user.
2603: oe_debug_pub.ADD('qualifier_grouping_no :'||l_QUALIFIERS_rec.qualifier_grouping_no||':'||p_QUALIFIERS_rec.qualifier_grouping_no||':');
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2607: oe_debug_pub.ADD('request_id :'||l_QUALIFIERS_rec.request_id||':'||p_QUALIFIERS_rec.request_id||':');
2608: oe_debug_pub.ADD('start_date_active :'||l_QUALIFIERS_rec.start_date_active||':'||p_QUALIFIERS_rec.start_date_active||':');
2609: oe_debug_pub.ADD('-------------------Data compare in price list line qualifier end------------------');
2610: -- Row has changed by another user.
2611: --End 8594682 - Add debug messages for OE_LOCK error
2604: oe_debug_pub.ADD('qualifier_id :'||l_QUALIFIERS_rec.qualifier_id||':'||p_QUALIFIERS_rec.qualifier_id||':');
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2607: oe_debug_pub.ADD('request_id :'||l_QUALIFIERS_rec.request_id||':'||p_QUALIFIERS_rec.request_id||':');
2608: oe_debug_pub.ADD('start_date_active :'||l_QUALIFIERS_rec.start_date_active||':'||p_QUALIFIERS_rec.start_date_active||':');
2609: oe_debug_pub.ADD('-------------------Data compare in price list line qualifier end------------------');
2610: -- Row has changed by another user.
2611: --End 8594682 - Add debug messages for OE_LOCK error
2612:
2605: oe_debug_pub.ADD('qualifier_precedence :'||l_QUALIFIERS_rec.qualifier_precedence||':'||p_QUALIFIERS_rec.qualifier_precedence||':');
2606: oe_debug_pub.ADD('qualifier_rule_id :'||l_QUALIFIERS_rec.qualifier_rule_id||':'||p_QUALIFIERS_rec.qualifier_rule_id||':');
2607: oe_debug_pub.ADD('request_id :'||l_QUALIFIERS_rec.request_id||':'||p_QUALIFIERS_rec.request_id||':');
2608: oe_debug_pub.ADD('start_date_active :'||l_QUALIFIERS_rec.start_date_active||':'||p_QUALIFIERS_rec.start_date_active||':');
2609: oe_debug_pub.ADD('-------------------Data compare in price list line qualifier end------------------');
2610: -- Row has changed by another user.
2611: --End 8594682 - Add debug messages for OE_LOCK error
2612:
2613: -- Row has changed by another user.
2610: -- Row has changed by another user.
2611: --End 8594682 - Add debug messages for OE_LOCK error
2612:
2613: -- Row has changed by another user.
2614: oe_debug_pub.add('row changed');
2615:
2616: x_return_status := FND_API.G_RET_STS_ERROR;
2617: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2618:
2635:
2636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN
2638:
2639: oe_debug_pub.add('row deleted');
2640: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_DELETED');
2641: OE_MSG_PUB.Add;
2642:
2643: END IF;
3103: --7120399
3104:
3105: BEGIN
3106:
3107: oe_debug_pub.Add('Entering OE_QUALIFIERS_Util.pre_write_process');
3108: oe_debug_pub.Add('mkarya - p_QUALIFIERS_rec.operation = ' ||p_QUALIFIERS_rec.operation);
3109:
3110:
3111: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3104:
3105: BEGIN
3106:
3107: oe_debug_pub.Add('Entering OE_QUALIFIERS_Util.pre_write_process');
3108: oe_debug_pub.Add('mkarya - p_QUALIFIERS_rec.operation = ' ||p_QUALIFIERS_rec.operation);
3109:
3110:
3111: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3112:
3219: END IF;
3220:
3221: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3222:
3223: oe_debug_pub.add('log delayed request------------');
3224:
3225: qp_delayed_requests_PVT.log_request(
3226: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3227: p_param1 => p_QUALIFIERS_rec.list_header_id,
3308: /*
3309: IF (p_QUALIFIERS_rec.operation IN
3310: (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)) THEN
3311:
3312: oe_debug_pub.add('log delayed request--------warn_same_qual_grp');
3313:
3314: qp_delayed_requests_PVT.log_request(
3315: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3316: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3348: WHEN OTHERS THEN
3349: NULL;
3350: END;
3351: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3352: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3353: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3354: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3355: qp_delayed_requests_PVT.log_request(
3356: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3349: NULL;
3350: END;
3351: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3352: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3353: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3354: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3355: qp_delayed_requests_PVT.log_request(
3356: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3357: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3350: END;
3351: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3352: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3353: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3354: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3355: qp_delayed_requests_PVT.log_request(
3356: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3357: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3358: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3391: begin
3392:
3393: for l_rec in c_qual_grp
3394: LOOP
3395: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3396: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3397: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3398: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3399: qp_delayed_requests_PVT.log_request(
3392:
3393: for l_rec in c_qual_grp
3394: LOOP
3395: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3396: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3397: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3398: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3399: qp_delayed_requests_PVT.log_request(
3400: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3393: for l_rec in c_qual_grp
3394: LOOP
3395: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3396: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3397: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3398: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3399: qp_delayed_requests_PVT.log_request(
3400: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3401: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3394: LOOP
3395: oe_debug_pub.add('In LOOP - update of qualifier grp to -1');
3396: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3397: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3398: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3399: qp_delayed_requests_PVT.log_request(
3400: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3401: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3402: p_request_unique_key2 => l_rec.qualifier_grouping_no,