126:
127: raise FND_API.G_EXC_ERROR;
128: end if;
129:
130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
131: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:quote_header_id:'|| p_qte_header_rec.quote_header_id,1,'N');
132: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: header_pricing_event:'|| p_control_rec.header_pricing_event,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
127: raise FND_API.G_EXC_ERROR;
128: end if;
129:
130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
131: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:quote_header_id:'|| p_qte_header_rec.quote_header_id,1,'N');
132: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: header_pricing_event:'|| p_control_rec.header_pricing_event,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
128: end if;
129:
130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
131: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:quote_header_id:'|| p_qte_header_rec.quote_header_id,1,'N');
132: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: header_pricing_event:'|| p_control_rec.header_pricing_event,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
129:
130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
131: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:quote_header_id:'|| p_qte_header_rec.quote_header_id,1,'N');
132: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: header_pricing_event:'|| p_control_rec.header_pricing_event,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
131: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:quote_header_id:'|| p_qte_header_rec.quote_header_id,1,'N');
132: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: header_pricing_event:'|| p_control_rec.header_pricing_event,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
131: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:quote_header_id:'|| p_qte_header_rec.quote_header_id,1,'N');
132: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: header_pricing_event:'|| p_control_rec.header_pricing_event,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
132: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: header_pricing_event:'|| p_control_rec.header_pricing_event,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
133: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing_request_type:'|| p_control_rec.pricing_request_type,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
134: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calculate_tax_flag:'|| p_control_rec.calculate_tax_flag,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
135: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: calc_freight_charge_flag:'|| p_control_rec.calculate_freight_charge_flag,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
136: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: price_mode:'|| p_control_rec.price_mode,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
144: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: APPLICATION_TYPE_CODE:'|| p_control_rec.APPLICATION_TYPE_CODE,1,'N');
137: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: auto_version_flag:'|| p_control_rec.auto_version_flag,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
144: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: APPLICATION_TYPE_CODE:'|| p_control_rec.APPLICATION_TYPE_CODE,1,'N');
145: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing status indicator:'|| p_qte_header_rec.Pricing_status_indicator,1,'N');
138: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_task_flag:'|| p_control_rec.copy_task_flag ,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
144: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: APPLICATION_TYPE_CODE:'|| p_control_rec.APPLICATION_TYPE_CODE,1,'N');
145: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing status indicator:'|| p_qte_header_rec.Pricing_status_indicator,1,'N');
146: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: tax status indicator:'|| p_qte_header_rec.tax_status_indicator,1,'N');
139: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_notes_flag:'|| p_control_rec.copy_notes_flag,1,'N');
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
144: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: APPLICATION_TYPE_CODE:'|| p_control_rec.APPLICATION_TYPE_CODE,1,'N');
145: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing status indicator:'|| p_qte_header_rec.Pricing_status_indicator,1,'N');
146: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: tax status indicator:'|| p_qte_header_rec.tax_status_indicator,1,'N');
147: END IF;
140: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: copy_att_flag:'|| p_control_rec.copy_att_flag,1,'N');
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
144: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: APPLICATION_TYPE_CODE:'|| p_control_rec.APPLICATION_TYPE_CODE,1,'N');
145: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing status indicator:'|| p_qte_header_rec.Pricing_status_indicator,1,'N');
146: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: tax status indicator:'|| p_qte_header_rec.tax_status_indicator,1,'N');
147: END IF;
148:
141: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEPENDENCY_FLAG:'|| p_control_rec.DEPENDENCY_FLAG,1,'N');
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
144: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: APPLICATION_TYPE_CODE:'|| p_control_rec.APPLICATION_TYPE_CODE,1,'N');
145: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing status indicator:'|| p_qte_header_rec.Pricing_status_indicator,1,'N');
146: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: tax status indicator:'|| p_qte_header_rec.tax_status_indicator,1,'N');
147: END IF;
148:
149: If ((p_control_rec.header_pricing_event = null) or (p_control_rec.header_pricing_event = FND_API.G_MISS_CHAR)) then
142: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FLAG:'|| p_control_rec.DEFAULTING_FLAG,1,'N');
143: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: DEFAULTING_FWK_FLAG:'|| p_control_rec.DEFAULTING_FWK_FLAG,1,'N');
144: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: APPLICATION_TYPE_CODE:'|| p_control_rec.APPLICATION_TYPE_CODE,1,'N');
145: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing status indicator:'|| p_qte_header_rec.Pricing_status_indicator,1,'N');
146: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: tax status indicator:'|| p_qte_header_rec.tax_status_indicator,1,'N');
147: END IF;
148:
149: If ((p_control_rec.header_pricing_event = null) or (p_control_rec.header_pricing_event = FND_API.G_MISS_CHAR)) then
150: l_header_pricing_event := ' ';
243: -- Changes Done by : Girish
244: -- Comments : Setting the org id context before submitting the request
245:
246: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
247: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
248: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:Org ID:'|| l_org_id,1,'N');
249: END IF;
250: fnd_request.set_org_id(l_org_id);
251:
244: -- Comments : Setting the org id context before submitting the request
245:
246: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
247: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
248: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:Org ID:'|| l_org_id,1,'N');
249: END IF;
250: fnd_request.set_org_id(l_org_id);
251:
252: -- Change END
1040:
1041: BEGIN
1042:
1043: -- get the quote header id
1044: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1045: aso_debug_pub.ADD ('Quote header ID is ' || p_quote_header_id,1,'N');
1046: END IF;
1047:
1048: -- get the server address
1041: BEGIN
1042:
1043: -- get the quote header id
1044: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1045: aso_debug_pub.ADD ('Quote header ID is ' || p_quote_header_id,1,'N');
1046: END IF;
1047:
1048: -- get the server address
1049: l_url := fnd_web_config.jsp_agent ();
1046: END IF;
1047:
1048: -- get the server address
1049: l_url := fnd_web_config.jsp_agent ();
1050: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1051: aso_debug_pub.ADD ('URL ID is ' || l_url,1,'N');
1052: END IF;
1053:
1054: -- get the quote details
1047:
1048: -- get the server address
1049: l_url := fnd_web_config.jsp_agent ();
1050: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1051: aso_debug_pub.ADD ('URL ID is ' || l_url,1,'N');
1052: END IF;
1053:
1054: -- get the quote details
1055: OPEN get_quote_details (p_quote_header_id);
1082:
1083: -- Create an html text buffer
1084: IF (p_display_type = 'MAILHTML')
1085: THEN
1086: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1087: aso_debug_pub.ADD ('Display type is text/html',1,'N');
1088: END IF;
1089: x_document := ''||l_attr_desc|| '';
1090:
1083: -- Create an html text buffer
1084: IF (p_display_type = 'MAILHTML')
1085: THEN
1086: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1087: aso_debug_pub.ADD ('Display type is text/html',1,'N');
1088: END IF;
1089: x_document := ''||l_attr_desc|| '';
1090:
1091: END IF;
1093: -- Create a plain text buffer
1094:
1095: IF (p_display_type = 'MAILTEXT')
1096: THEN
1097: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1098: aso_debug_pub.ADD ('Display type is text/plain',1,'N');
1099: END IF;
1100: NULL;
1101: END IF;
1094:
1095: IF (p_display_type = 'MAILTEXT')
1096: THEN
1097: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1098: aso_debug_pub.ADD ('Display type is text/plain',1,'N');
1099: END IF;
1100: NULL;
1101: END IF;
1102:
1099: END IF;
1100: NULL;
1101: END IF;
1102:
1103: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1104: aso_debug_pub.ADD ('End QUOTE_DETAIL_URL procedure ',1,'N');
1105: END IF;
1106:
1107: EXCEPTION
1100: NULL;
1101: END IF;
1102:
1103: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1104: aso_debug_pub.ADD ('End QUOTE_DETAIL_URL procedure ',1,'N');
1105: END IF;
1106:
1107: EXCEPTION
1108: WHEN OTHERS
1106:
1107: EXCEPTION
1108: WHEN OTHERS
1109: THEN
1110: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1111: aso_debug_pub.ADD ('Exception in QUOTE_DETAIL_URL SqlCode :' || SQLERRM,1,'N');
1112: END IF;
1113:
1114: RAISE;
1107: EXCEPTION
1108: WHEN OTHERS
1109: THEN
1110: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1111: aso_debug_pub.ADD ('Exception in QUOTE_DETAIL_URL SqlCode :' || SQLERRM,1,'N');
1112: END IF;
1113:
1114: RAISE;
1115:
1153: BEGIN
1154:
1155: -- get the server address
1156: l_url := fnd_web_config.jsp_agent ();
1157: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1158: aso_debug_pub.ADD ('URL ID is ' || l_url,1,'N');
1159: END IF;
1160:
1161: -- get the quote details
1154:
1155: -- get the server address
1156: l_url := fnd_web_config.jsp_agent ();
1157: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1158: aso_debug_pub.ADD ('URL ID is ' || l_url,1,'N');
1159: END IF;
1160:
1161: -- get the quote details
1162: itemtype := 'ASO_NTFY';
1162: itemtype := 'ASO_NTFY';
1163: itemkey := document_id;
1164:
1165:
1166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1167: aso_debug_pub.ADD ('itemtype is ' || itemtype,1,'N');
1168: aso_debug_pub.ADD ('itemkey is ' || itemkey,1,'N');
1169: END IF;
1170:
1163: itemkey := document_id;
1164:
1165:
1166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1167: aso_debug_pub.ADD ('itemtype is ' || itemtype,1,'N');
1168: aso_debug_pub.ADD ('itemkey is ' || itemkey,1,'N');
1169: END IF;
1170:
1171: l_quote_header_id := wf_engine.getitemattrnumber (
1164:
1165:
1166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1167: aso_debug_pub.ADD ('itemtype is ' || itemtype,1,'N');
1168: aso_debug_pub.ADD ('itemkey is ' || itemkey,1,'N');
1169: END IF;
1170:
1171: l_quote_header_id := wf_engine.getitemattrnumber (
1172: itemtype => itemtype,
1209:
1210: -- Create an html text buffer
1211: IF (display_type = 'text/html')
1212: THEN
1213: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1214: aso_debug_pub.ADD ('Display type is text/html',1,'N');
1215: END IF;
1216: document := ''||l_attr_desc|| '';
1217: document_type := 'text/html';
1210: -- Create an html text buffer
1211: IF (display_type = 'text/html')
1212: THEN
1213: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1214: aso_debug_pub.ADD ('Display type is text/html',1,'N');
1215: END IF;
1216: document := ''||l_attr_desc|| '';
1217: document_type := 'text/html';
1218:
1222:
1223: IF (display_type = 'text/plain')
1224: THEN
1225: document_type := 'text/plain';
1226: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1227: aso_debug_pub.ADD ('Display type is text/plain',1,'N');
1228: END IF;
1229: NULL;
1230: END IF;
1223: IF (display_type = 'text/plain')
1224: THEN
1225: document_type := 'text/plain';
1226: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1227: aso_debug_pub.ADD ('Display type is text/plain',1,'N');
1228: END IF;
1229: NULL;
1230: END IF;
1231:
1228: END IF;
1229: NULL;
1230: END IF;
1231:
1232: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1233: aso_debug_pub.ADD ('End QUOTE_DETAIL_URL procedure ',1,'N');
1234: END IF;
1235:
1236: EXCEPTION
1229: NULL;
1230: END IF;
1231:
1232: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1233: aso_debug_pub.ADD ('End QUOTE_DETAIL_URL procedure ',1,'N');
1234: END IF;
1235:
1236: EXCEPTION
1237: WHEN OTHERS