830: BEGIN
831: -- Routing Header Record
832:
833: IF (p_rtg_hdr_XML IS NULL) THEN
834: FND_MESSAGE.SET_NAME('BOM', 'BOM_SETUP_NO_ROWS');
835: FND_MESSAGE.RETRIEVE(X_G_msg_data);
836: ELSE
837: -- get the context handle
838: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_HEADER_TEMP');
831: -- Routing Header Record
832:
833: IF (p_rtg_hdr_XML IS NULL) THEN
834: FND_MESSAGE.SET_NAME('BOM', 'BOM_SETUP_NO_ROWS');
835: FND_MESSAGE.RETRIEVE(X_G_msg_data);
836: ELSE
837: -- get the context handle
838: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_HEADER_TEMP');
839: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1018: END;
1019: END LOOP;
1020: END LOOP;
1021: IF (hdr_cnt = 0) THEN -- There are no records to be processed. RETURN with Error Message
1022: FND_MESSAGE.SET_NAME('BOM', 'BOM_SETUP_NO_ROWS');
1023: FND_MESSAGE.RETRIEVE(X_G_msg_data);
1024: END IF;
1025: END IF;
1026: END Import_Routing;
1019: END LOOP;
1020: END LOOP;
1021: IF (hdr_cnt = 0) THEN -- There are no records to be processed. RETURN with Error Message
1022: FND_MESSAGE.SET_NAME('BOM', 'BOM_SETUP_NO_ROWS');
1023: FND_MESSAGE.RETRIEVE(X_G_msg_data);
1024: END IF;
1025: END IF;
1026: END Import_Routing;
1027: