DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on QP_DELAYED_REQUESTS_PVT

Line 3166: qp_delayed_requests_PVT.log_request(

3162:
3163: IF NOT (l_list_type_code = 'PRL' and p_QUALIFIERS_rec.qualifier_context='MODLIST'
3164: and p_QUALIFIERS_rec.qualifier_attribute='QUALIFIER_ATTRIBUTE4') THEN
3165:
3166: qp_delayed_requests_PVT.log_request(
3167: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3168: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3169: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3170: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,

Line 3179: qp_delayed_requests_PVT.log_request(

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,
3182: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3183: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 3199: qp_delayed_requests_PVT.log_request(

3195: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3196: p_QUALIFIERS_rec.list_line_id <> -1 AND
3197: l_llq_count = 1)
3198: THEN
3199: qp_delayed_requests_PVT.log_request(
3200: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3201: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3202: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3203: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,

Line 3209: qp_delayed_requests_PVT.log_request(

3205: x_return_status => l_return_status);
3206:
3207: -- mkarya for bug1769955 - log the MAINTAIN_LIST_HEADER_PHASES request for line qualifier
3208: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3209: qp_delayed_requests_PVT.log_request(
3210: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3211: p_param1 => p_QUALIFIERS_rec.list_header_id,
3212: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3213: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 3241: qp_delayed_requests_PVT.log_request(

3237: IF p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3238: QP_GLOBALS.G_OPR_UPDATE,
3239: QP_GLOBALS.G_OPR_DELETE) THEN
3240: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3241: qp_delayed_requests_PVT.log_request(
3242: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3243: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3244: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3245: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,

Line 3250: qp_delayed_requests_PVT.log_request(

3246: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3247: x_return_status => l_return_status);
3248: END IF;
3249: --Added following delayed request for Attributes Manager
3250: qp_delayed_requests_PVT.log_request(
3251: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3252: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3253: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3254: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,

Line 3267: qp_delayed_requests_PVT.log_request(

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,
3270: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3271: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,

Line 3308: qp_delayed_requests_PVT.log_request(

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,
3312: p_entity_id => p_qualifiers_rec.list_line_id,

Line 3323: qp_delayed_requests_PVT.log_request(

3319: -- Log a delayed request to validate that if header level qualifier exist then at least
3320: -- one qualifier should exist for any existence of modifier line of modifier level
3321: -- 'LINE' or 'ORDER'
3322: if p_qualifiers_rec.list_line_id = -1 then
3323: qp_delayed_requests_PVT.log_request(
3324: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3325: p_entity_id => l_qualifiers_rec.list_header_id,
3326: p_request_unique_key1 => -1,
3327: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

Line 3352: qp_delayed_requests_PVT.log_request(

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,
3356: p_entity_id => p_qualifiers_rec.list_line_id,

Line 3380: qp_delayed_requests_pvt.log_request(

3376: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3377: p_QUALIFIERS_rec.list_line_id = -1 THEN
3378: -- header qualifier is added to price list/modifier
3379: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3380: qp_delayed_requests_pvt.log_request(
3381: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3382: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3383: p_request_unique_key1 => NULL,
3384: p_request_unique_key2 => 'I',

Line 3390: qp_delayed_requests_pvt.log_request(

3386: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3387: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3388: x_return_status => l_return_status);
3389: ELSE
3390: qp_delayed_requests_pvt.log_request(
3391: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3392: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3393: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3394: p_request_unique_key2 => 'I',

Line 3409: qp_delayed_requests_pvt.log_request(

3405: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3406: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3407: -- updated other than qualifier grouping number
3408: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3409: qp_delayed_requests_pvt.log_request(
3410: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3411: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3412: p_request_unique_key1 => NULL,
3413: p_request_unique_key2 => 'U',

Line 3419: qp_delayed_requests_pvt.log_request(

3415: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3416: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3417: x_return_status => l_return_status);
3418: ELSE
3419: qp_delayed_requests_pvt.log_request(
3420: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3421: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3422: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3423: p_request_unique_key2 => 'U',

Line 3434: qp_delayed_requests_pvt.log_request(

3430: ELSE
3431: -- qualifier grouping number is modified
3432: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3433: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3434: qp_delayed_requests_pvt.log_request(
3435: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3436: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3437: p_request_unique_key1 => NULL,
3438: p_request_unique_key2 => 'U',

Line 3444: qp_delayed_requests_pvt.log_request(

3440: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3441: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3442: x_return_status => l_return_status);
3443: ELSE
3444: qp_delayed_requests_pvt.log_request(
3445: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3446: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3447: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3448: p_request_unique_key2 => 'U',

Line 3453: qp_delayed_requests_pvt.log_request(

3449: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3450: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3451: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3452: x_return_status => l_return_status);
3453: qp_delayed_requests_pvt.log_request(
3454: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3455: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3456: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3457: p_request_unique_key2 => 'U',

Line 3470: qp_delayed_requests_pvt.log_request(

3466:
3467: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3468: p_QUALIFIERS_rec.list_line_id = -1 THEN
3469: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3470: qp_delayed_requests_pvt.log_request(
3471: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3472: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3473: p_request_unique_key1 => NULL,
3474: p_request_unique_key2 => 'D',

Line 3480: qp_delayed_requests_pvt.log_request(

3476: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3477: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3478: x_return_status => l_return_status);
3479: ELSE
3480: qp_delayed_requests_pvt.log_request(
3481: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3482: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3483: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3484: p_request_unique_key2 => 'D',

Line 3496: qp_delayed_requests_pvt.log_request(

3492: -- line pattern
3493: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3494: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3495: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3496: qp_delayed_requests_pvt.log_request(
3497: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3498: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3499: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3500: p_request_unique_key2 => NULL,

Line 3507: qp_delayed_requests_pvt.log_request(

3503: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3504: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3505: x_return_status => l_return_status);
3506: ELSE
3507: qp_delayed_requests_pvt.log_request(
3508: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3509: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3510: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3511: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3525: qp_delayed_requests_pvt.log_request(

3521: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3522: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3523: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3524: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3525: qp_delayed_requests_pvt.log_request(
3526: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3527: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3528: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3529: p_request_unique_key2 => NULL,

Line 3536: qp_delayed_requests_pvt.log_request(

3532: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3533: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3534: x_return_status => l_return_status);
3535: ELSE
3536: qp_delayed_requests_pvt.log_request(
3537: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3538: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3539: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3540: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3551: qp_delayed_requests_pvt.log_request(

3547:
3548: ELSE
3549: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3550: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3551: qp_delayed_requests_pvt.log_request(
3552: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3553: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3554: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3555: p_request_unique_key2 => NULL,

Line 3562: qp_delayed_requests_pvt.log_request(

3558: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3559: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3560: x_return_status => l_return_status);
3561: ELSE
3562: qp_delayed_requests_pvt.log_request(
3563: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3564: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3565: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3566: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,

Line 3572: qp_delayed_requests_pvt.log_request(

3568: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3569: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3570: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3571: x_return_status => l_return_status);
3572: qp_delayed_requests_pvt.log_request(
3573: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3574: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3575: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3576: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,

Line 3590: qp_delayed_requests_pvt.log_request(

3586:
3587: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3588: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3589: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3590: qp_delayed_requests_pvt.log_request(
3591: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3592: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3593: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3594: p_request_unique_key2 => NULL,

Line 3601: qp_delayed_requests_pvt.log_request(

3597: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3598: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3599: x_return_status => l_return_status);
3600: ELSE
3601: qp_delayed_requests_pvt.log_request(
3602: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3603: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3604: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3605: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,