APPS.QP_MAINTAIN_DENORMALIZED_DATA dependencies on FND_API

Line 81: x_return_status := FND_API.G_RET_STS_ERROR;

77: -- commit; --Commented because of Bug #3548384
78:
79: EXCEPTION
80: When OTHERS Then
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: x_return_status_text := 'Exception in Set_HVOP_Pricing: '||SQLERRM;
83:
84: END Set_HVOP_Pricing;
85: --hvop

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196:
197: commit;
198: EXCEPTION
199: When OTHERS Then
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: x_return_status_text := 'update_adv_mod_products exception '||SQLERRM;
202: END update_adv_mod_products;
203:
204: procedure update_pricing_phases(p_update_type IN VARCHAR2

Line 543: ,'Y','SITE'))--) = FND_API.G_FALSE)

539: THEN
540: put_line('Completed Update of Profile: limits exist: '||l_limits_exist||' basic modifiers exist: '||l_basic_modifiers_exist);
541: END IF;--update_type
542: IF (FND_PROFILE.SAVE('QP_BASIC_MODIFIERS_SETUP'
543: ,'Y','SITE'))--) = FND_API.G_FALSE)
544: THEN
545: null;
546: ELSE
547: Raise Phase_Exception;

Line 556: ,'N','SITE'))--) = FND_API.G_FALSE)

552: put_line('Completed Update of Profile: limits exist: '||l_limits_exist||' basic modifiers exist: '||l_basic_modifiers_exist);
553: END IF;--update_type
554:
555: IF (FND_PROFILE.SAVE('QP_BASIC_MODIFIERS_SETUP'
556: ,'N','SITE'))--) = FND_API.G_FALSE)
557: THEN
558: null;
559: ELSE
560: Raise Phase_Exception;

Line 581: x_return_status := FND_API.G_RET_STS_ERROR;

577:
578:
579: EXCEPTION
580: When Phase_Exception THEN
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: x_return_status_text := 'QP_DENOB.update_pricing_phases:'||substr(SQLERRM,1,200);
583: IF p_update_type in ('ALL', 'PHASE')
584: THEN
585: put_line('EXCEPTION RAISED IN PHASE UPDATE'||SQLERRM);

Line 588: x_return_status := FND_API.G_RET_STS_ERROR;

584: THEN
585: put_line('EXCEPTION RAISED IN PHASE UPDATE'||SQLERRM);
586: END IF;
587: When OTHERS THEN
588: x_return_status := FND_API.G_RET_STS_ERROR;
589: x_return_status_text := 'QP_DENOB.update_pricing_phases:'||substr(SQLERRM,1,200);
590: IF p_update_type in ('ALL', 'PHASE')
591: THEN
592: put_line('EXCEPTION RAISED IN PHASE UPDATE'||SQLERRM);

Line 685: x_return_status:= FND_API.G_RET_STS_ERROR;

681: fnd_file.put_line(FND_FILE.LOG,'Completed Row Count Update');
682: END IF;
683: EXCEPTION
684: WHEN OTHERS THEN
685: x_return_status:= FND_API.G_RET_STS_ERROR;
686: x_return_status_text:='Exception In Update Row '||substr(sqlerrm,1,300);
687: end update_row_count;
688:
689: PROCEDURE Update_Qualifiers

Line 804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

800:
801: IF P_UPDATE_TYPE in ('HVOP_PRICING_SETUP','ALL')
802: and QP_CODE_CONTROL.Get_Code_Release_Level > '110509' THEN
803: Set_HVOP_Pricing(l_return_status, err_buff);
804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
805: IF P_UPDATE_TYPE in ('HVOP_PRICING_SETUP','ALL') THEN
806: put_line('Exception in Update_HVOP Profile: '||l_return_status);
807: END IF;
808: Raise Phase_Exception;

Line 830: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

826:
827: G_UPDATE_TYPE := P_UPDATE_TYPE;
828:
829: Update_adv_mod_products(l_return_status, err_buff);
830: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
831: IF P_UPDATE_TYPE in ('ADV_MOD_PRODUCTS','ALL') THEN
832: put_line('Exception in Update_adv_mod_products: '||l_return_status);
833: END IF;
834: Raise Phase_Exception;

Line 854: IF l_return_status = FND_API.G_RET_STS_ERROR

850: update_pricing_phases(p_update_type => p_update_type,
851: x_return_status => l_return_status,
852: x_return_status_text => err_buff);
853:
854: IF l_return_status = FND_API.G_RET_STS_ERROR
855: THEN
856: Raise Phase_Exception;
857: END IF;
858: commit;

Line 1204: IF l_return_status=FND_API.G_RET_STS_ERROR THEN

1200:
1201: --Added for 5922279. procedure update_row_count does not need to be called for AGR,PRL through UI
1202: IF NOT( l_list_header_id_low = l_list_header_id_high AND l_list_type_code in ('PRL','AGR')) then
1203: Update_row_count(l_list_header_id_low,l_list_header_id_high, p_update_type,l_return_status,err_buff);
1204: IF l_return_status=FND_API.G_RET_STS_ERROR THEN
1205: put_line('Exception While Updating Row Count'||l_return_status);
1206: Raise Phase_Exception;
1207: END IF;
1208: END IF;