eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PREQ_GRP

Line 3412: QP_PREQ_GRP.Set_QP_Debug;

3408: INVALID_PRICE_BOOK_HEADER EXCEPTION;
3409:
3410: BEGIN
3411:
3412: QP_PREQ_GRP.Set_QP_Debug;
3413: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3414: IF l_debug = FND_API.G_TRUE THEN
3415: l_output_file := OE_DEBUG_PUB.SET_DEBUG_MODE('FILE');
3416: FND_FILE.PUT_LINE( FND_FILE.LOG, 'The output file is : ' || l_output_file );

Line 3413: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

3409:
3410: BEGIN
3411:
3412: QP_PREQ_GRP.Set_QP_Debug;
3413: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3414: IF l_debug = FND_API.G_TRUE THEN
3415: l_output_file := OE_DEBUG_PUB.SET_DEBUG_MODE('FILE');
3416: FND_FILE.PUT_LINE( FND_FILE.LOG, 'The output file is : ' || l_output_file );
3417: END IF;

Line 3483: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

3479: WHEN INVALID_PARAMS_ERROR THEN
3480: x_return_status := FND_API.G_RET_STS_ERROR;
3481: x_return_status_text := 'Invalid parameter values.';
3482: WHEN E_ROUTINE_ERRORS THEN
3483: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3484: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
3485: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
3486: END IF;
3487: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3484: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);

3480: x_return_status := FND_API.G_RET_STS_ERROR;
3481: x_return_status_text := 'Invalid parameter values.';
3482: WHEN E_ROUTINE_ERRORS THEN
3483: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3484: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
3485: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
3486: END IF;
3487: x_return_status := FND_API.G_RET_STS_ERROR;
3488: x_return_status_text := l_return_status_text;

Line 3485: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);

3481: x_return_status_text := 'Invalid parameter values.';
3482: WHEN E_ROUTINE_ERRORS THEN
3483: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3484: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
3485: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
3486: END IF;
3487: x_return_status := FND_API.G_RET_STS_ERROR;
3488: x_return_status_text := l_return_status_text;
3489: WHEN MAX_STATUS_REQUESTS_REACHED THEN

Line 3496: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

3492: WHEN INVALID_PRICE_BOOK_HEADER THEN
3493: x_return_status := FND_API.G_RET_STS_ERROR;
3494: x_return_status_text := 'Invalid price book header id.';
3495: WHEN OTHERS THEN
3496: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3497: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
3498: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
3499: END IF;
3500: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3497: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);

3493: x_return_status := FND_API.G_RET_STS_ERROR;
3494: x_return_status_text := 'Invalid price book header id.';
3495: WHEN OTHERS THEN
3496: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3497: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
3498: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
3499: END IF;
3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: x_return_status_text := l_return_status_text;

Line 3498: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);

3494: x_return_status_text := 'Invalid price book header id.';
3495: WHEN OTHERS THEN
3496: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3497: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
3498: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
3499: END IF;
3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: x_return_status_text := l_return_status_text;
3502: END PUBLISH_AND_DELIVER;

Line 3544: QP_PREQ_GRP.Set_QP_Debug;

3540: l_debug VARCHAR2(3);
3541:
3542: BEGIN
3543: -- set debug level
3544: QP_PREQ_GRP.Set_QP_Debug;
3545: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3546:
3547: IF (l_debug = FND_API.G_TRUE) THEN
3548: QP_PREQ_GRP.engine_debug('ENTERING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG');

Line 3545: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

3541:
3542: BEGIN
3543: -- set debug level
3544: QP_PREQ_GRP.Set_QP_Debug;
3545: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3546:
3547: IF (l_debug = FND_API.G_TRUE) THEN
3548: QP_PREQ_GRP.engine_debug('ENTERING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG');
3549: END IF;

Line 3548: QP_PREQ_GRP.engine_debug('ENTERING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG');

3544: QP_PREQ_GRP.Set_QP_Debug;
3545: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3546:
3547: IF (l_debug = FND_API.G_TRUE) THEN
3548: QP_PREQ_GRP.engine_debug('ENTERING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG');
3549: END IF;
3550:
3551: IF (l_debug = FND_API.G_TRUE) THEN
3552: QP_PREQ_GRP.engine_debug('With the following parameters:');

Line 3552: QP_PREQ_GRP.engine_debug('With the following parameters:');

3548: QP_PREQ_GRP.engine_debug('ENTERING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG');
3549: END IF;
3550:
3551: IF (l_debug = FND_API.G_TRUE) THEN
3552: QP_PREQ_GRP.engine_debug('With the following parameters:');
3553: QP_PREQ_GRP.engine_debug('p_price_book_header_id:' || p_price_book_header_id);
3554: END IF;
3555:
3556: -- initialize parameters

Line 3553: QP_PREQ_GRP.engine_debug('p_price_book_header_id:' || p_price_book_header_id);

3549: END IF;
3550:
3551: IF (l_debug = FND_API.G_TRUE) THEN
3552: QP_PREQ_GRP.engine_debug('With the following parameters:');
3553: QP_PREQ_GRP.engine_debug('p_price_book_header_id:' || p_price_book_header_id);
3554: END IF;
3555:
3556: -- initialize parameters
3557: x_progress := '000';

Line 3584: QP_PREQ_GRP.engine_debug('party_id:' || party_id);

3580: WHERE p.price_book_header_id = p_price_book_header_id
3581: AND p.pb_input_header_id = i.pb_input_header_id;
3582:
3583: IF (l_debug = FND_API.G_TRUE) THEN
3584: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3585: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3586: END IF;
3587:
3588: SELECT FND_PROFILE.VALUE('ORG_ID')

Line 3585: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);

3581: AND p.pb_input_header_id = i.pb_input_header_id;
3582:
3583: IF (l_debug = FND_API.G_TRUE) THEN
3584: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3585: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3586: END IF;
3587:
3588: SELECT FND_PROFILE.VALUE('ORG_ID')
3589: INTO l_operating_unit_id

Line 3593: QP_PREQ_GRP.engine_debug('l_operating_unit_id:' || l_operating_unit_id);

3589: INTO l_operating_unit_id
3590: FROM dual;
3591:
3592: IF (l_debug = FND_API.G_TRUE) THEN
3593: QP_PREQ_GRP.engine_debug('l_operating_unit_id:' || l_operating_unit_id);
3594: END IF;
3595:
3596: l_inv_org_id := qp_util.Get_Item_Validation_Org;
3597: IF (l_debug = FND_API.G_TRUE) THEN

Line 3598: QP_PREQ_GRP.engine_debug('l_inv_org_id:' || l_inv_org_id);

3594: END IF;
3595:
3596: l_inv_org_id := qp_util.Get_Item_Validation_Org;
3597: IF (l_debug = FND_API.G_TRUE) THEN
3598: QP_PREQ_GRP.engine_debug('l_inv_org_id:' || l_inv_org_id);
3599: END IF;
3600:
3601: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Parameters Initialized';
3602: IF (l_debug = FND_API.G_TRUE) THEN

Line 3603: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3599: END IF;
3600:
3601: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Parameters Initialized';
3602: IF (l_debug = FND_API.G_TRUE) THEN
3603: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3604: END IF;
3605:
3606: -- XML Setup Check
3607: IF (l_debug = FND_API.G_TRUE) THEN

Line 3608: QP_PREQ_GRP.engine_debug('Parameters before ecx_document.isDeliveryRequired:');

3604: END IF;
3605:
3606: -- XML Setup Check
3607: IF (l_debug = FND_API.G_TRUE) THEN
3608: QP_PREQ_GRP.engine_debug('Parameters before ecx_document.isDeliveryRequired:');
3609: QP_PREQ_GRP.engine_debug('transaction_type:' || transaction_type);
3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);
3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);

Line 3609: QP_PREQ_GRP.engine_debug('transaction_type:' || transaction_type);

3605:
3606: -- XML Setup Check
3607: IF (l_debug = FND_API.G_TRUE) THEN
3608: QP_PREQ_GRP.engine_debug('Parameters before ecx_document.isDeliveryRequired:');
3609: QP_PREQ_GRP.engine_debug('transaction_type:' || transaction_type);
3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);
3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3613: QP_PREQ_GRP.engine_debug('return_code:' || return_code);

Line 3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);

3606: -- XML Setup Check
3607: IF (l_debug = FND_API.G_TRUE) THEN
3608: QP_PREQ_GRP.engine_debug('Parameters before ecx_document.isDeliveryRequired:');
3609: QP_PREQ_GRP.engine_debug('transaction_type:' || transaction_type);
3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);
3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3613: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3614: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);

Line 3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);

3607: IF (l_debug = FND_API.G_TRUE) THEN
3608: QP_PREQ_GRP.engine_debug('Parameters before ecx_document.isDeliveryRequired:');
3609: QP_PREQ_GRP.engine_debug('transaction_type:' || transaction_type);
3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);
3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3613: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3614: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3615: END IF;

Line 3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);

3608: QP_PREQ_GRP.engine_debug('Parameters before ecx_document.isDeliveryRequired:');
3609: QP_PREQ_GRP.engine_debug('transaction_type:' || transaction_type);
3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);
3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3613: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3614: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3615: END IF;
3616:

Line 3613: QP_PREQ_GRP.engine_debug('return_code:' || return_code);

3609: QP_PREQ_GRP.engine_debug('transaction_type:' || transaction_type);
3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);
3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3613: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3614: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3615: END IF;
3616:
3617: ecx_document.isDeliveryRequired(

Line 3614: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);

3610: QP_PREQ_GRP.engine_debug('transaction_subtype:' || transaction_subtype);
3611: QP_PREQ_GRP.engine_debug('party_id:' || party_id);
3612: QP_PREQ_GRP.engine_debug('party_site_id:' || party_site_id);
3613: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3614: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3615: END IF;
3616:
3617: ecx_document.isDeliveryRequired(
3618: transaction_type => transaction_type,

Line 3627: QP_PREQ_GRP.engine_debug('Values returned from ecx_document.isDeliveryRequired:');

3623: retcode => return_code,
3624: errmsg => errmsg);
3625:
3626: IF (l_debug = FND_API.G_TRUE) THEN
3627: QP_PREQ_GRP.engine_debug('Values returned from ecx_document.isDeliveryRequired:');
3628: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3629: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3630: END IF;
3631:

Line 3628: QP_PREQ_GRP.engine_debug('return_code:' || return_code);

3624: errmsg => errmsg);
3625:
3626: IF (l_debug = FND_API.G_TRUE) THEN
3627: QP_PREQ_GRP.engine_debug('Values returned from ecx_document.isDeliveryRequired:');
3628: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3629: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3630: END IF;
3631:
3632: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : XML Setup Check';

Line 3629: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);

3625:
3626: IF (l_debug = FND_API.G_TRUE) THEN
3627: QP_PREQ_GRP.engine_debug('Values returned from ecx_document.isDeliveryRequired:');
3628: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3629: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3630: END IF;
3631:
3632: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : XML Setup Check';
3633: IF (l_debug = FND_API.G_TRUE) THEN

Line 3634: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3630: END IF;
3631:
3632: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : XML Setup Check';
3633: IF (l_debug = FND_API.G_TRUE) THEN
3634: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3635: END IF;
3636:
3637: IF NOT(result) THEN
3638: -- trading partner not found

Line 3641: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3637: IF NOT(result) THEN
3638: -- trading partner not found
3639: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : No Trading Partner found during XML Setup Check';
3640: IF (l_debug = FND_API.G_TRUE) THEN
3641: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3642: END IF;
3643:
3644: ELSE -- no number specified, send in one message
3645:

Line 3648: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3644: ELSE -- no number specified, send in one message
3645:
3646: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : No Number Limit Specified';
3647: IF (l_debug = FND_API.G_TRUE) THEN
3648: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3649: END IF;
3650:
3651: -- create unique key
3652: SELECT QP_XML_MESSAGES_S.NEXTVAL INTO l_syncctlg_seq FROM dual;

Line 3654: QP_PREQ_GRP.engine_debug('l_syncctlg_seq:' || l_syncctlg_seq);

3650:
3651: -- create unique key
3652: SELECT QP_XML_MESSAGES_S.NEXTVAL INTO l_syncctlg_seq FROM dual;
3653: IF (l_debug = FND_API.G_TRUE) THEN
3654: QP_PREQ_GRP.engine_debug('l_syncctlg_seq:' || l_syncctlg_seq);
3655: END IF;
3656: l_event_key := to_char(p_price_book_header_id) || '.' || to_char(l_syncctlg_seq);
3657:
3658: SELECT SYSDATE INTO l_date FROM dual;

Line 3660: QP_PREQ_GRP.engine_debug('l_date:' || l_date);

3656: l_event_key := to_char(p_price_book_header_id) || '.' || to_char(l_syncctlg_seq);
3657:
3658: SELECT SYSDATE INTO l_date FROM dual;
3659: IF (l_debug = FND_API.G_TRUE) THEN
3660: QP_PREQ_GRP.engine_debug('l_date:' || l_date);
3661: END IF;
3662: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
3663:
3664: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Created Unique Key';

Line 3666: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3662: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
3663:
3664: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Created Unique Key';
3665: IF (l_debug = FND_API.G_TRUE) THEN
3666: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3667: END IF;
3668:
3669: -- add parameters to list for create collaboration event
3670: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',

Line 3703: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3699: p_parameterlist => l_create_cln_parameter_list);
3700:
3701: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Initialize Create Event Parameters';
3702: IF (l_debug = FND_API.G_TRUE) THEN
3703: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3704: end if;
3705:
3706: -- raise create collaboration event
3707: wf_event.raise(p_event_name => l_create_cln_event,

Line 3713: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3709: p_parameters => l_create_cln_parameter_list);
3710:
3711: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Create Event Raised';
3712: IF (l_debug = FND_API.G_TRUE) THEN
3713: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3714: end if;
3715:
3716: -- add parameters to list for send show shipment document
3717: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',

Line 3792: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3788: p_parameterlist => l_send_syct_parameter_list);
3789:
3790: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Send Document Event Parameters Initialized';
3791: IF (l_debug = FND_API.G_TRUE) THEN
3792: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3793: END IF;
3794:
3795: -- raise event for send show shipment document
3796: wf_event.RAISE(p_event_name => l_send_syct_event,

Line 3802: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3798: p_parameters => l_send_syct_parameter_list);
3799:
3800: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Send Document Event Raised';
3801: IF (l_debug = FND_API.G_TRUE) THEN
3802: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3803: END IF;
3804:
3805: END IF;
3806:

Line 3808: QP_PREQ_GRP.engine_debug('EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG Successfully');

3804:
3805: END IF;
3806:
3807: IF (l_debug = FND_API.G_TRUE) THEN
3808: QP_PREQ_GRP.engine_debug('EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG Successfully');
3809: END IF;
3810:
3811: x_return_status := FND_API.G_RET_STS_SUCCESS;
3812:

Line 3818: QP_PREQ_GRP.engine_debug('Exception ' || ':' || l_error_code || ':' || l_error_msg);

3814: WHEN OTHERS THEN
3815: l_error_code := SQLCODE;
3816: l_error_msg := SQLERRM;
3817: IF (l_debug = FND_API.G_TRUE) THEN
3818: QP_PREQ_GRP.engine_debug('Exception ' || ':' || l_error_code || ':' || l_error_msg);
3819: END IF;
3820:
3821: x_progress := 'EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG in Error ';
3822: IF (l_debug = FND_API.G_TRUE) THEN

Line 3823: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);

3819: END IF;
3820:
3821: x_progress := 'EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG in Error ';
3822: IF (l_debug = FND_API.G_TRUE) THEN
3823: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3824: END IF;
3825: x_return_status := FND_API.G_RET_STS_ERROR;
3826: x_return_status_text := l_error_msg;
3827: END SEND_SYNC_CATALOG;

Line 3871: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

3867: END IF;
3868:
3869: SET_XML_CONTEXT(l_user_name, l_status_code, l_status_text);
3870:
3871: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3872: IF l_debug = FND_API.G_TRUE THEN
3873: QP_PREQ_GRP.engine_debug(l_routine||'calling GENERATE_PUBLISH_PRICE_BOOK');
3874: END IF;
3875: QP_PRICE_BOOK_PVT.GENERATE_PUBLISH_PRICE_BOOK(l_pb_input_header_id,

Line 3873: QP_PREQ_GRP.engine_debug(l_routine||'calling GENERATE_PUBLISH_PRICE_BOOK');

3869: SET_XML_CONTEXT(l_user_name, l_status_code, l_status_text);
3870:
3871: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3872: IF l_debug = FND_API.G_TRUE THEN
3873: QP_PREQ_GRP.engine_debug(l_routine||'calling GENERATE_PUBLISH_PRICE_BOOK');
3874: END IF;
3875: QP_PRICE_BOOK_PVT.GENERATE_PUBLISH_PRICE_BOOK(l_pb_input_header_id,
3876: l_request_id,
3877: l_status_code,

Line 3881: QP_PREQ_GRP.engine_debug(l_routine||'returned from GENERATE_PUBLISH_PRICE_BOOK');

3877: l_status_code,
3878: l_ret_code,
3879: l_err_buf);
3880: IF l_debug = FND_API.G_TRUE THEN
3881: QP_PREQ_GRP.engine_debug(l_routine||'returned from GENERATE_PUBLISH_PRICE_BOOK');
3882: END IF;
3883:
3884: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
3885:

Line 3913: QP_PREQ_GRP.Set_QP_Debug;

3909: a varchar2(100);
3910:
3911: BEGIN
3912:
3913: QP_PREQ_GRP.Set_QP_Debug;
3914: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3915:
3916: IF l_debug = FND_API.G_TRUE THEN
3917: QP_PREQ_GRP.engine_debug( 'ENTERING CATSO_SELECTOR PROCEDURE' ) ;

Line 3914: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

3910:
3911: BEGIN
3912:
3913: QP_PREQ_GRP.Set_QP_Debug;
3914: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3915:
3916: IF l_debug = FND_API.G_TRUE THEN
3917: QP_PREQ_GRP.engine_debug( 'ENTERING CATSO_SELECTOR PROCEDURE' ) ;
3918: QP_PREQ_GRP.engine_debug( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;

Line 3917: QP_PREQ_GRP.engine_debug( 'ENTERING CATSO_SELECTOR PROCEDURE' ) ;

3913: QP_PREQ_GRP.Set_QP_Debug;
3914: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3915:
3916: IF l_debug = FND_API.G_TRUE THEN
3917: QP_PREQ_GRP.engine_debug( 'ENTERING CATSO_SELECTOR PROCEDURE' ) ;
3918: QP_PREQ_GRP.engine_debug( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
3919: END IF;
3920:
3921: IF (p_funcmode = 'RUN') THEN

Line 3918: QP_PREQ_GRP.engine_debug( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;

3914: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3915:
3916: IF l_debug = FND_API.G_TRUE THEN
3917: QP_PREQ_GRP.engine_debug( 'ENTERING CATSO_SELECTOR PROCEDURE' ) ;
3918: QP_PREQ_GRP.engine_debug( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
3919: END IF;
3920:
3921: IF (p_funcmode = 'RUN') THEN
3922: IF l_debug = FND_API.G_TRUE THEN

Line 3923: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS RUN' ) ;

3919: END IF;
3920:
3921: IF (p_funcmode = 'RUN') THEN
3922: IF l_debug = FND_API.G_TRUE THEN
3923: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS RUN' ) ;
3924: END IF;
3925: p_x_result := 'COMPLETE';
3926: ELSIF(p_funcmode = 'TEST_CTX') THEN
3927: IF l_debug = FND_API.G_TRUE THEN

Line 3928: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS TEST_CTX' ) ;

3924: END IF;
3925: p_x_result := 'COMPLETE';
3926: ELSIF(p_funcmode = 'TEST_CTX') THEN
3927: IF l_debug = FND_API.G_TRUE THEN
3928: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS TEST_CTX' ) ;
3929: END IF;
3930:
3931: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3932: itemkey => p_itemkey,

Line 3936: QP_PREQ_GRP.engine_debug( 'l_org_id (from workflow)=>'|| l_org_id ) ;

3932: itemkey => p_itemkey,
3933: aname => 'ORG_ID');
3934:
3935: IF l_debug = FND_API.G_TRUE THEN
3936: QP_PREQ_GRP.engine_debug( 'l_org_id (from workflow)=>'|| l_org_id ) ;
3937: QP_PREQ_GRP.engine_debug( 'mo_global.get_current_org_id =>'|| mo_global.get_current_org_id ) ;
3938: END IF;
3939:
3940: IF (mo_global.get_current_org_id is null OR MO_GLOBAL.get_access_mode is null) THEN

Line 3937: QP_PREQ_GRP.engine_debug( 'mo_global.get_current_org_id =>'|| mo_global.get_current_org_id ) ;

3933: aname => 'ORG_ID');
3934:
3935: IF l_debug = FND_API.G_TRUE THEN
3936: QP_PREQ_GRP.engine_debug( 'l_org_id (from workflow)=>'|| l_org_id ) ;
3937: QP_PREQ_GRP.engine_debug( 'mo_global.get_current_org_id =>'|| mo_global.get_current_org_id ) ;
3938: END IF;
3939:
3940: IF (mo_global.get_current_org_id is null OR MO_GLOBAL.get_access_mode is null) THEN
3941: p_x_result := 'NOTSET';

Line 3952: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS SET_CTX' ) ;

3948: END IF;
3949:
3950: ELSIF(p_funcmode = 'SET_CTX') THEN
3951: IF l_debug = FND_API.G_TRUE THEN
3952: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS SET_CTX' ) ;
3953: END IF;
3954:
3955: l_user_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3956: itemkey => p_itemkey,

Line 3969: QP_PREQ_GRP.engine_debug('l_user_id =>' || l_user_id || ' l_resp_id =>' || l_resp_id || ' l_resp_appl_id =>' || l_resp_appl_id || ' l_org_id =>' || l_org_id);

3965: itemkey => p_itemkey,
3966: aname => 'ORG_ID');
3967:
3968: IF l_debug = FND_API.G_TRUE THEN
3969: QP_PREQ_GRP.engine_debug('l_user_id =>' || l_user_id || ' l_resp_id =>' || l_resp_id || ' l_resp_appl_id =>' || l_resp_appl_id || ' l_org_id =>' || l_org_id);
3970: END IF;
3971:
3972: IF l_resp_appl_id is null OR l_resp_id is null THEN
3973: dbms_application_info.set_client_info(l_org_id);

Line 3975: QP_PREQ_GRP.engine_debug('set org using dbms_application_info.set_client_info');

3971:
3972: IF l_resp_appl_id is null OR l_resp_id is null THEN
3973: dbms_application_info.set_client_info(l_org_id);
3974: IF l_debug = FND_API.G_TRUE THEN
3975: QP_PREQ_GRP.engine_debug('set org using dbms_application_info.set_client_info');
3976: END IF;
3977: ELSE
3978: -- Set the database session context
3979: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);

Line 3999: QP_PREQ_GRP.engine_debug('p_x_result =>'||p_x_result);

3995: p_x_result := 'COMPLETE';
3996: END IF;
3997:
3998: IF l_debug = FND_API.G_TRUE THEN
3999: QP_PREQ_GRP.engine_debug('p_x_result =>'||p_x_result);
4000: END IF;
4001:
4002: EXCEPTION
4003: WHEN OTHERS THEN NULL;

Line 4037: QP_PREQ_GRP.Set_QP_Debug;

4033: fnd_global.apps_initialize(l_user_id,
4034: null,
4035: null);
4036: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
4037: QP_PREQ_GRP.Set_QP_Debug;
4038: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
4039: IF l_debug = FND_API.G_TRUE THEN
4040: QP_PREQ_GRP.engine_debug(l_routine || ':l_user_id=' || l_user_id);
4041: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_code=' || l_pricing_perspective_code);

Line 4038: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

4034: null,
4035: null);
4036: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
4037: QP_PREQ_GRP.Set_QP_Debug;
4038: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
4039: IF l_debug = FND_API.G_TRUE THEN
4040: QP_PREQ_GRP.engine_debug(l_routine || ':l_user_id=' || l_user_id);
4041: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_code=' || l_pricing_perspective_code);
4042: END IF;

Line 4040: QP_PREQ_GRP.engine_debug(l_routine || ':l_user_id=' || l_user_id);

4036: l_pricing_perspective_code := FND_PROFILE.VALUE('QP_EXT_DEFAULT_PRICING_PERSPECTIVE');
4037: QP_PREQ_GRP.Set_QP_Debug;
4038: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
4039: IF l_debug = FND_API.G_TRUE THEN
4040: QP_PREQ_GRP.engine_debug(l_routine || ':l_user_id=' || l_user_id);
4041: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_code=' || l_pricing_perspective_code);
4042: END IF;
4043:
4044: -- get pricing perspective application id based on pricing perspective code

Line 4041: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_code=' || l_pricing_perspective_code);

4037: QP_PREQ_GRP.Set_QP_Debug;
4038: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
4039: IF l_debug = FND_API.G_TRUE THEN
4040: QP_PREQ_GRP.engine_debug(l_routine || ':l_user_id=' || l_user_id);
4041: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_code=' || l_pricing_perspective_code);
4042: END IF;
4043:
4044: -- get pricing perspective application id based on pricing perspective code
4045: SELECT a.application_id

Line 4050: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_appl_id=' || l_pricing_perspective_appl_id);

4046: INTO l_pricing_perspective_appl_id
4047: FROM fnd_application a
4048: WHERE a.application_short_name = l_pricing_perspective_code;
4049: IF l_debug = FND_API.G_TRUE THEN
4050: QP_PREQ_GRP.engine_debug(l_routine || ':l_pricing_perspective_appl_id=' || l_pricing_perspective_appl_id);
4051: END IF;
4052:
4053: -- get responsibility based on pricing perspective
4054: fnd_global.apps_initialize(l_user_id,

Line 4059: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_id=' || l_resp_id);

4055: null,
4056: l_pricing_perspective_appl_id);
4057: l_resp_id := FND_PROFILE.VALUE('QP_XML_RESP');
4058: IF l_debug = FND_API.G_TRUE THEN
4059: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_id=' || l_resp_id);
4060: END IF;
4061:
4062: -- get application id and short name based on responsibility
4063: SELECT a.application_id, a.application_short_name

Line 4069: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_appl_id=' || l_resp_appl_id || ',l_resp_appl_name=' || l_resp_appl_name);

4065: FROM fnd_responsibility r, fnd_application a
4066: WHERE r.responsibility_id = l_resp_id
4067: AND a.application_id = r.application_id;
4068: IF l_debug = FND_API.G_TRUE THEN
4069: QP_PREQ_GRP.engine_debug(l_routine || ':l_resp_appl_id=' || l_resp_appl_id || ',l_resp_appl_name=' || l_resp_appl_name);
4070: END IF;
4071:
4072: -- set context
4073: fnd_global.apps_initialize(l_user_id,